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

' . 'View Details' . '

'; })->rawColumns(['action']) ->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_id = $this->request()->get('client_id') == null ? 1 : $this->request()->get('client_id', 0); $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 = DB::table('sms_log') ->where('user_id', '=', $client->id) ->where('originated', '=', 'mtnuser') ->where('created_at', '>=', $first) ->where('created_at', '<=', $last) ->select('user_id', 'sender', DB::raw('DATE(submit_date) submit_date'), DB::raw('COUNT(*) sms_count')) ->groupBy(DB::raw('DATE(submit_date),user_id,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 'resellerdailycampaignapidatatables_' . time(); } }