eloquent($query)
->editColumn('status', function ($query){
return empty($query->status) ? 'N/A' : ucfirst($query->status);
})
->addColumn('user_mailing_list_id', function ($query){
return ''.$query->user_mailing_list->name.'';
})
->addColumn('action', function ($query){
return '';
})->rawColumns(['user_mailing_list_id','action']);
}
public function query()
{
return auth()->user()->user_email_campaigns()->whereHas('user_mailing_list')->newQuery()->whereNotNull('schedule_at')->latest();
// return auth()->user()->user_email_campaigns()->whereHas('user_mailing_list')->newQuery()->latest();
}
public function send($query)
{
return $query->is_sent ? " return confirm('Are you sure you want to resend this campaign')" : "return confirm('Are you sure you want to send campaign ?')";
}
/**
* Optional method if you want to use html builder.
*
* @return \Yajra\DataTables\Html\Builder
*/
public function html()
{
return $this->builder()
->setTableId('usercampaignemaildatatable-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('user_mailing_list_id')->title('Mailing List'),
Column::make('subject'),
Column::make('from_name'),
Column::make('reply_to'),
Column::make('created_at'),
Column::make('schedule_at'),
Column::make('count')->title('Times Sent'),
Column::make('status'),
Column::computed('action')
->exportable(false)
->printable(false)
->width(100)
->addClass('text-center'),
];
}
/**
* Get filename for export.
*
* @return string
*/
protected function filename()
{
return 'UserCampaignEmail_' . date('YmdHis');
}
}