datatables ->eloquent($this->query()) ->addColumn('name', function ($row) { return ''.$row->name.''; })->rawColumns(['name']) ->make(true); } public function query() { $client = User::findOrFail($this->user_id); $first = date('Y-m-d H:i:s', mktime(0, 0, 0, date('n'), date('j'))); $last = date('Y-m-d H:i:s', mktime(23, 59, 59, date('n'), date('j'))); $query = $client->jobs() ->where('created_at', '>=', $first) ->where('created_at', '<=', $last) ->orderBy('sched_datetime', 'desc'); return $this->applyScopes($query); } public function user() { } /** * 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_daily_' . time(); } }