首页 > 其他分享 >laravel groupBy 分页

laravel groupBy 分页

时间:2023-01-30 00:11:36浏览次数:63  
标签:laravel dates 分页 DB xx num model groupBy

$model=DB::table('tablebname')
        ->where(function($query) use ($res){
           	$query->where('xx','xx');
        })
        ->selectRaw("area,from_unixtime(created_time,'%Y-%m-%d') as dates,sum(num) as use_num,path,desc")
        ->groupBy(['dates','area','path','money_id'])
        ->orderBy('dates','desc');
        
$data=DB::table(DB::raw("({$model->toSql()}) as temptable"))
        ->mergeBindings($model)
        ->paginate(15);

 

标签:laravel,dates,分页,DB,xx,num,model,groupBy
From: https://www.cnblogs.com/fenle/p/17074158.html

相关文章