eloquent($query) ->addColumn('name', function ($row) { return ''.$row->name.''; })->rawColumns(['name']); } public function query() { $client_id = $this->request()->get('client_id'); $client = User::find($client_id ?? session()->get('client_id')); $query = $client->jobs()->orderBy('sched_datetime', '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('') ->parameters($params); } /** * Get columns. * * @return array */ protected function getColumns() { return [ 'name'=>['title'=>'Campaign Name'], 'sender' => ['title'=>'Sender Id'], 'created_at', 'sched_datetime' => ['title'=>'Schedule Date'], 'status', 'total_traffic', ]; } /** * Get filename for export. * * @return string */ protected function filename() { return 'admin_campaign_' . time(); } }