datatables ->queryBuilder($this->query()) ->addColumn('username', function ($row){ return ''.$row->username.''; })->rawColumns(['name']) // ->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|\Illuminate\Support\Collection */ public function query() { $user = Auth::user(); $_start_date = Carbon::now()->toDateString(); $_end_date = Carbon::parse($_start_date)->addDay()->addSeconds(-1)->toDateTimeString(); /* $query = DB::table('sms_log') ->join('users', 'users.id', '=', 'sms_log.user_id') ->where('users.created_by', $user->username) ->whereBetween('sms_log.submit_date', [$_start_date, $_end_date]) ->groupBy(['sms_log.user_id', 'sms_log.status','network','full_name','users.username','sms_log.submit_date']) ->orderBy('sms_log.submit_date', 'desc') ->select(DB::raw('count(*) as count, sms_log.status, network, full_name as user, users.username as username')) ; */ $query = DB::table('sms_log') ->select(DB::raw('username,sender,count(id) as countt')) ->where('created_by',$user->username) ->where('submit_date','>',$_start_date) ->groupBy('username') ->groupBy('sender'); //$query = DB::query("SELECT username,sender,count(id) as countt from sms_log where created_by='".$user->username."' and submit_date >curdate() group by username,sender"); return $this->applyScopes($query); } /** * Optional method if you want to use html builder. * * @return \Yajra\Datatables\Html\Builder */ public function html() { return $this->builder() ->columns($this->getColumns()) ->ajax('') ->parameters([ 'dom' => 'Bfrtip', 'buttons' => ['csv', 'excel', 'pdf', 'print', 'reload'], 'order' => [[1, 'desc']] ]); } /** * Get columns. * * @return array */ protected function getColumns() { return [ 'username', 'sender', 'countt' =>['searchable'=>false] ]; } /** * Get filename for export. * * @return string */ protected function filename() { return 'resellerdaily_' . time(); } }