eloquent($query) ->addColumn('package',function ($query){ $package = $query->social_subscription->media_price ?? null; return $package ? ''.$package->name.'' : 'N/A'; }) ->addColumn('linkedIn',function ($query){ return $query->posts()->where('channel','linkedIn')->count(); }) ->addColumn('Facebook',function ($query){ return $query->posts()->where('channel','Facebook')->count(); }) ->addColumn('Twitter',function ($query){ return $query->posts()->where('channel','Twitter')->count(); }) ->addColumn('lifetime',function ($query){ return $query->posts()->count(); }) ->addColumn('action', 'resellerclientemailreport.action') ->rawColumns(['action','Campaigns','package']); } public function query(User $model) { $username = auth()->user()->username; return $model->newQuery()->where('created_by',$username)->whereHas('company')->with('company'); } public function html() { return $this->builder() ->setTableId('resellerclientemailreport-table') ->columns($this->getColumns()) ->minifiedAjax() ->dom('Bfrtip') ->orderBy(1) ->buttons( // Button::make('create'), Button::make('export'), Button::make('print'), Button::make('reset'), Button::make('reload') ); } /** * Get columns. * * @return array */ protected function getColumns() { $now = now()->format('M'); return [ Column::make('username')->title('Username'), Column::computed('company.name')->title('Organisation'), Column::computed('package')->title('Package'), Column::computed('linkedIn')->title('linkedIn /'.$now), Column::computed('Facebook')->title('facebook /'.$now), Column::computed('Twitter')->title('Twitter /'.$now), Column::computed('lifetime'), Column::computed('created_at'), ]; } /** * Get filename for export. * * @return string */ protected function filename() { return 'ResellerClientEmailReport_' . date('YmdHis'); } }