eloquent($query)
->addColumn('package',function ($query){
$package = $query->users->subscription->email_pricing ?? null;
return $package ? ''.$package->package.'' : null;
})
->addColumn('No Audience',function ($query){
return $query->users->subscription ? $query->users->mailing_list->count() :null;
})
->addColumn('No Contacts',function ($query){
return $query->users->subscription ? $query->users->subscriberCount() :null;
})
->addColumn('Emails Sent',function ($query){
return $query->users->subscription ? $query->users->emailSentCount() :null;
})
->addColumn('Campaigns',function ($query){
return $query->users->subscription ? ''.$query->users->user_email_campaigns()->newQuery()->withTrashed()->where('is_sent',true)->count().'' :null;
})
->addColumn('action', 'resellerclientemailreport.action')
->rawColumns(['action','Campaigns','package']);
}
public function query(Company $model)
{
$username = auth()->user()->username;
return $model->newQuery()->with(['users'])->whereHas('users',function ($query) use ($username){
$query->where('created_by',$username);
});
}
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()
{
return [
Column::make('users.username')->title('Username'),
Column::computed('name')->title('Organisation'),
Column::computed('package'),
Column::computed('No Audience'),
Column::computed('No Contacts'),
Column::computed('Emails Sent'),
Column::computed('Campaigns'),
Column::computed('created_at'),
];
}
/**
* Get filename for export.
*
* @return string
*/
protected function filename()
{
return 'ResellerClientEmailReport_' . date('YmdHis');
}
}