Así que tengo estos campos en mi tabla de directors
id, name, position, summary, deletedEsta tabla tiene los siguientes registros
1 | John Doe | President | Some text | 0 2 | Mary Doe | Vice President | Some text | 0 3 | Hannah Doe | Treasurer | Some text | 0 4 | Ann Doe | Board | Some text | 0 5 | Mark Doe | Board| Some text | 0 6 | Johnny Doe | Secretary | Some text | 0A partir de ahora, puedo obtenerlos usando este código
$directors = Director::where('deleted',0)->get();Pero, ¿cómo puedo organizar según mis valores preferidos? Esto debería organizarse así.
President, Vice President, Secretary, Treasurer, Board and if the position is blank this will be below the records of Board Position
1 | John Doe | President | Some text | 0 2 | Mary Doe | Vice President | Some text | 0 6 | Johnny Doe | Secretary | Some text | 0 3 | Hannah Doe | Treasurer | Some text | 0 4 | Ann Doe | Board | Some text | 0 5 | Mark Doe | Board| Some text | 0la consulta sera asi
SELECT * FROM `directors` WHERE `deleted` = '0' ORDER BY CASE position WHEN "President" THEN 1 WHEN "Vice President" THEN 2 WHEN "Secretary" THEN 3 WHEN "Treasurer" THEN 4 WHEN "Board" THEN 5 ELSE 6 END, position;Versión elocuente;
return Director::where('deleted', 0) ->orderBy( DB::raw( 'CASE position WHEN "President" THEN 1 WHEN "Vice President" THEN 2 WHEN "Secretary" THEN 3 WHEN "Treasurer" THEN 4 WHEN "Board" THEN 5 ELSE 6 END, position' ) ) ->get();Si su base de datos es lo suficientemente pequeña y no está en contra de ordenar en laravel después de la consulta, ya que puede volverse lento con datos masivos, aquí hay una forma de hacerlo usando el método de recopilación sort() .
$sortOrder = array_flip(['President', 'Vice President', 'Secretary', 'Treasurer', 'Board', '']); $directors = Director::where('deleted',0) ->get() ->sort(function($prev,$next)use($sortOrder){ // Note: Flip $prev and $next around on this next line for opposite order return $sortOrder[$prev->position] <=> $sortOrder[$next->position]; });