Laravel find in setソート

プロジェクトを行うには、結果セットのデータを指定するルールの順序で並べ替える必要があります.たとえば、ユーザーのステータスは4つあります.
0=>非アクティブ1=>正常;2=>無効3=>ソフト削除
通常->非アクティブ->無効->削除に従う必要があります.この順番で並べ替えて、同時に登録時間の降順に従って、ネット上で多くの資料を調べて、国内でこれに言及するのは少なくて、stackOverFlowの上で答えを見つけました!先行ソリューション:

public function index($customer_type = null) {
    $search = request('search');
    $perPage = request('perPage') ? request('perPage') : 10;
    $customer_type = $customer_type ? $customer_type : request('customer_type');
    // \DB::enableQueryLog();
    $data = Customer::select(['id', 'email', 'user_name', 'nick_name', 'status', 'phone', 'create_time'])
        ->where('customer_type', '=', $customer_type)
        ->where(function ($query) use ($search) {
            if ($search) {
                $query->where('user_name', 'like binary', '%' . $search . '%')
                    ->orWhere('nick_name', 'like binary', '%' . $search . '%')
                    ->orWhere('phone', 'like binary', '%' . $search . '%')
                    ->orWhere('email', 'like binary', '%' . $search . '%');
            }
        })
        ->orderByRaw("FIELD(status, " . implode(", ", [1, 2, 0, 3, 4]) . ")")
        ->orderBy('create_time', 'desc')
        ->paginate($perPage);
    // $query = \DB::getQueryLog();
    // dd($data);
    //      ，      
    $appendData = $data->appends(array(
        'search' => $search,
        'perPage' => $perPage,
    ));
    return view('admin/customer/customerList', compact('data'));
}

印刷されたsql文は次のとおりです.
array:2 [▼ 0 => array:3 [▼ “query” => “select count(*) as aggregate from customer where customer_type = ?” “bindings” => array:1 [▼ 0 => “1” ] “time” => 2.08 ] 1 => array:3 [▼ “query” => “select id , email , user_name , nick_name , status , phone , create_time from customer where customer_type = ? order by FIELD(status, 1, 2, 0, 3, 4), create_time desc limit 10 offset 0” “bindings” => array:1 [▼ 0 => “1” ] “time” => 1.2 ] ]
次のリンクを参照してください.https://stackoverflow.com/questions/42068986/laravel-weird-behavior-orderbyrawfield
https://stackoverflow.com/questions/34244455/how-to-use-not-find-in-set-in-laravel-5-1
https://stackoverflow.com/questions/35594450/find-in-set-in-laravel-example/35594503
find_in_set複雑な応用:

public function get_teacher_list($timeType, $name, $perPage = 10, $personality = 0, $teachingStyle = 0, $ageType = 0)
{
    // \DB::enableQueryLog();
    $result_data = DB::table('teacher_info as ti')
        ->select('ti.*')
        ->join('customer', 'customer.id', '=', 'ti.customer_id')
        ->where(function ($query) use ($personality) {
            if (trim($personality)) {
                $query->whereRaw("find_in_set($personality,ti.label_ids)");
            }
        })
        ->where(function ($query) use ($teachingStyle) {
            if (trim($teachingStyle)) {
                $query->whereRaw("find_in_set($teachingStyle,ti.label_ids)");
            }
        })
        ->where(function ($query) use ($ageType) {
            if (trim($ageType)) {
                $ageType = explode('-', $ageType);
                $query->whereRaw("DATE_FORMAT(FROM_DAYS(TO_DAYS(NOW())-TO_DAYS(birthday)), '%Y')+0 between $ageType[0] and $ageType[1]");
            }
        })
        ->where(function ($query) use ($timeType) {
            //1  ，2  
            if ($timeType == 1) {
                $query->where('ti.can_appointment_1', 1);
            } elseif ($timeType == 2) {
                $query->where('ti.can_appointment_2', 1);
            } else {
                $query->where('ti.can_appointment_1', '>', 0)
                    ->orWhere('ti.can_appointment_2', '>', 0);
            }
        })
        ->where(function ($query) use ($name) {
            if (trim($name)) {
                $query->where('ti.chinese_name', 'like', '%' . $name . '%')
                    ->orWhere('ti.english_name', 'like', '%' . $name . '%');
            }
        })
        ->where('ti.status', 1)
        ->orderBy('ti.total_teach_num', 'desc')
        ->orderBy('ti.total_star_num', 'desc')
        ->orderBy('ti.satisfaction', 'desc')
        ->orderBy('ti.comment_num', 'desc')
        ->orderBy('ti.english_name', 'asc')
        ->paginate($perPage);
    // dd($result_data, \DB::getQueryLog());

    return $result_data;
}

わざわざ出してみてください.

$ids = array(1,17,2);

$ids_ordered = implode(',', $ids);

$items = User::whereIn('id', $ids)
 ->orderByRaw(DB::raw("FIELD(id, $ids_ordered)"))
 ->get();