Laravel資料庫擷取整合資料方法技巧合集（總）

1、根據資料庫中某字段的數量多少進行排序資料

//擷取資料
$datas = DB::table('cus')
            ->select('*', DB::raw('count(*) as count'))
            ->groupBy('province')
            ->get()->toArray();

//将資料按照
$arrSort = array();
foreach($datas AS $key => $value){
    foreach($value AS $k=>$v){
       $arrSort[$k][$key] = $v;
    }
}
array_multisort($arrSort['count'], SORT_DESC, $datas);      

$students = \App\AdminStudent::orderBy('created_at','desc')->where(function ($query) use ($request){
            
                    if($request->startdate == $request->enddate){
              $query->whereDate('created_at',$request->startdate);
            }
        
            if ($request->startdate != $request->enddate) {
      
              $startdate = $request->startdate . ' 00:00:00';
              $enddate = $request->enddate . ' 23:59:59';
              $query->whereBetween('created_at',[$startdate,$enddate]);
            }
            
            
            
            if($request->school!=''){
              $query->where(['school'=>$request->school]);
            }
            
            if($request->course!=''){
              $query->where(['course'=>$request->course]);
            }
            
    
        })->paginate(15);
    $students->appends($request->all());