datatables ->eloquent($this->query()) ->addColumn('name', function ($row) { return ''.$row->name.''; })->rawColumns(['name']) ->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() { $client = User::findOrFail($this->user_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 'reseller_campaign_' . time(); } }