| @@ 40-47 (lines=8) @@ | ||
| 37 | )->execute() > 0; |
|
| 38 | } |
|
| 39 | ||
| 40 | public static function generateCase($priorities) |
|
| 41 | { |
|
| 42 | $result = 'CASE `id`'; |
|
| 43 | foreach ($priorities as $k => $v) { |
|
| 44 | $result .= ' when "' . $k . '" then "' . $v . '"'; |
|
| 45 | } |
|
| 46 | return $result . ' END'; |
|
| 47 | } |
|
| 48 | ||
| 49 | public static function moveIdBefore($id, $id_before, $field = 'sort_order') |
|
| 50 | { |
|
| @@ 686-693 (lines=8) @@ | ||
| 683 | * @param $priorities |
|
| 684 | * @return string |
|
| 685 | */ |
|
| 686 | private static function generateCase($priorities) |
|
| 687 | { |
|
| 688 | $result = 'CASE `id`'; |
|
| 689 | foreach ($priorities as $k => $v) { |
|
| 690 | $result .= ' when "' . $k . '" then "' . $v . '"'; |
|
| 691 | } |
|
| 692 | return $result . ' END'; |
|
| 693 | } |
|
| 694 | ||
| 695 | /** |
|
| 696 | * @return array |
|