query($query) ->addColumn('action', function ($row) { return '

' . 'View Details' . '

'; }); } /** * Get the query object to be processed by dataTables. * * @return \Illuminate\Database\Eloquent\Builder|\Illuminate\Database\Query\Builder|\Illuminate\Support\Collection */ public function query() { $query = DB::table('logs') ->where('user_id', '=', Auth::user()->id) ->where('originated', '=', 'guiuser') ->select('sender', DB::raw('DATE(submit_date) submit_date'), DB::raw('COUNT(*) sms_count')) ->groupBy(DB::raw('DATE(submit_date),sender')) ->orderBy('submit_date', 'desc'); return $this->applyScopes($query); } /** * Optional method if you want to use html builder. * * @return \Yajra\Datatables\Html\Builder */ public function html() { $params = $this->getBuilderParameters(); $params['order'] = [[2, 'desc']]; return $this->builder() ->columns($this->getColumns()) ->ajax('') // ->addAction(['width' => '150px']) ->parameters($params); } /** * Get columns. * * @return array */ protected function getColumns() { return [ 'submit_date', 'sender', 'sms_count', ]; } /** * Get filename for export. * * @return string */ protected function filename() { return 'campaignapi_' . time(); } }