larvel-admin表格查询汇总

larvel-admin 表单列表自定义查询条件

1.表单自定义查询条件

 $grid->model()
            ->where('user_id','>',0)
            ->groupBy('dateTime', 'user_id')
            ->orderBy('created_at','desc')
            ->selectRaw(' COUNT(1) AS countNumber, DATE_FORMAT(created_at,\'%Y-%m\') AS dateTime,user_id') ;

2.表单当前行，某一字段数据映射

$grid->column(