editColumn('name', function ($query){
return $query->name;
})
->editColumn('message', function ($query){
return $query->message;
})
->editColumn('total_traffic', function ($query){
return $query->total_traffic;
})
->editColumn('sent_datetime', function ($query){
return $query->sent_datetime;
})
->editColumn('status', function ($query){
if($query->status == 'sent')
{
return "".$query->status. "";
}
else if($query->status == 'pending')
{
return "".$query->status. "";
}
else{
return "".$query->status. "";
}
})
->rawColumns(['status']);
// ->addColumn('action', 'personalizedmailblast.action');
}
/**
* Get query source of dataTable.
*
* @return \Illuminate\Database\Eloquent\Builder
*/
public function query()
{
$query = MailMergeJob::query()->where('user_id', auth()->id());
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())
->minifiedAjax()
->dom('Bfrtip')
->orderBy(1)
->buttons(
Button::make('export'),
Button::make('print'),
Button::make('reset'),
Button::make('reload')
);
}
/**
* Get columns.
*
* @return array
*/
protected function getColumns()
{
return [
Column::make('name'),
Column::make('message'),
Column::make('status'),
Column::make('total_traffic'),
Column::make('sent_datetime'),
];
}
/**
* Get filename for export.
*
* @return string
*/
protected function filename()
{
return 'PersonalizedMailBlast_' . date('YmdHis');
}
}