| @@ 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 | { |
|
| @@ 671-678 (lines=8) @@ | ||
| 668 | * @param $priorities |
|
| 669 | * @return string |
|
| 670 | */ |
|
| 671 | private static function generateCase($priorities) |
|
| 672 | { |
|
| 673 | $result = 'CASE `id`'; |
|
| 674 | foreach ($priorities as $k => $v) { |
|
| 675 | $result .= ' when "' . $k . '" then "' . $v . '"'; |
|
| 676 | } |
|
| 677 | return $result . ' END'; |
|
| 678 | } |
|
| 679 | ||
| 680 | /** |
|
| 681 | * @return array |
|