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);
2、多条件查询
$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());