datatables
->eloquent($this->query())
->addColumn('action', function ($row) {
if($row->status != 'done' && $row->status != 'started' && $row->status != 'cancelled' && $row->status != 'stopped') {
return '';
} else if($row->status == 'cancelled') {
return '';
} else {
return '';
}
})
->addColumn('name', function ($row) {
return ''.$row->name.'';
// return ''.$row->name.'';
})
->addColumn('status', function ($row) {
return $row->status != 'started' ? $row->status : 'In Progress('.$row->progress.'%)';
})
->rawColumns(['action','name','status'])
->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()
{
$query = Auth::user()->email_jobs()->orderBy('sched_datetime', 'desc');
return $this->applyScopes($query);
}
/**
* Optional method if you want to use html builder.
*
* @return \Yajra\Datatables\Html\Builder
*/
public function html()
{
$params = $this->getBuilderParameters();
$params['order'] = [[2, 'desc']];
return $this->builder()
->columns($this->getColumns())
->ajax('')
->addAction(['width' => '200px'])
->parameters($params);
}
/**
* Get columns.
*
* @return array
*/
protected function getColumns()
{
return [
'name'=>['title'=>'Campaign Name'],
'sender' => ['title'=>'Sender'],
'subject',
'sched_datetime' => ['title'=>'Schedule Date'],
'status',
'total_traffic',
];
}
/**
* Get filename for export.
*
* @return string
*/
protected function filename()
{
return 'campaign_' . time();
}
}