eloquent($query) ->editColumn('name', function ($row) { return ''.$row->name.''; })->filterColumn('name',function ($query,$keyword){ $query->orWhere('name', 'like', '%' . $keyword . '%'); }) ->rawColumns(['name']); } /** * Get the query object to be processed by dataTables. * */ public function query() { $client_id = $this->request()->get('client_id', 0) == null ? 1 : $this->request()->get('client_id', 0); $user_id = $this->user_id; $client = User::findOrFail($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(); } }