datatables ->queryBuilder($this->query()) ->editColumn('user', function ($row){ return ''.$row->user.''; })->rawColumns(['user']) // ->addColumn('action', 'path.to.action.view') ->make(true); } /** * Get the query object to be processed by dataTables. * * @return \Illuminate\Database\Eloquent\Builder|\Illuminate\Database\Query\Builder|Collection */ public function query() { $_start_date = Carbon::now()->toDateString(); $_end_date = Carbon::parse($_start_date)->addDay()->addSeconds(-1)->toDateTimeString(); $query = DB::table('sms_log') ->where('user_id','<>',167) ->join('users', 'users.id', '=', 'sms_log.user_id') ->join('roles', 'users.role_id', '=', 'roles.id') ->whereBetween('sms_log.submit_date', [$_start_date, $_end_date]) ->groupBy(['sms_log.user_id', 'sms_log.status', 'full_name', 'users.username', 'roles.name','sms_log.submit_date']) ->orderBy('sms_log.submit_date', 'desc') ->select(DB::raw('count(*) as count, sms_log.status, full_name as user, users.username as username, roles.name as role')) ; return $this->applyScopes($query); } /** * Optional method if you want to use html builder. * * @return Builder */ public function html() { return $this->builder() ->columns($this->getColumns()) ->ajax('') ->parameters([ 'dom' => 'Bfrtip', 'buttons' => ['csv', 'excel', 'pdf', 'print', 'reload'], 'order' => [[0, 'asc']] ]); } /** * Get columns. * * @return array */ protected function getColumns() { return [ 'user'=>['name'=>'users.full_name'], 'username'=>['name'=>'users.username'], 'role'=>['name'=>'roles.name'], 'status', 'count'=>['searchable'=>false], ]; } /** * Get filename for export. * * @return string */ protected function filename() { return 'admindaily_' . time(); } }