datatables ->eloquent($this->query()) ->addColumn('action', 'path.to.action.view') ->addColumn('username', function ($query){ return ''. $query->users->username.''; }) ->addColumn('count', function ($query){ $count = CompanyEmail::query()->where([['company_id',$query->id],['status',null]])->get(); return $count->count(); })->rawColumns(['action','username']) ->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() { $ids = CompanyEmail::query()->where('status',null)->pluck('company_id')->toArray(); $query = Company::query()->whereIn('id',$ids); return $this->applyScopes($query); } /** * Optional method if you want to use html builder. * * @return \Yajra\Datatables\Html\Builder */ public function html() { return $this->builder() ->columns($this->getColumns()) ->ajax('') ->addAction(['width' => '80px']) ->parameters($this->getBuilderParameters()); } /** * Get columns. * * @return array */ protected function getColumns() { return [ 'id', 'username', 'count', 'created_at', 'updated_at', ]; } /** * Get filename for export. * * @return string */ protected function filename() { return 'clientemaildatatables_' . time(); } }