eloquent($query)
->addColumn('action', function ($row) {
$user = Auth::user();
if ($row->status == 'cancelled' || $row->status == 'low_balance') {
// return '';
}
if (strtoupper($user->username) == 'SCBULK' || strtoupper($user->username) == 'GCBCARDS' || strtoupper($user->username) == 'ONIPA') {
// logger($user->username);
// logger("Scbulk getter");
if ($row->status == 'cancelled' || $row->status == 'low_balance') {
return '';
} else if ($row->status != 'done' && $row->status != 'started' && strtoupper($row->status) != 'STARTING' && $row->status != 'cancelled' && $row->status != 'stopped' && strtoupper($row->status) != 'PENDING') {
return '';
}
// else if (strtoupper($row->status) == 'PENDING') {
// return '';
// }
else {
return '';
}
} else if ($row->status != 'done' && $row->status != 'started' && $row->status != 'cancelled' && $row->status != 'stopped') {
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';
return $row->status != 'started' ? ($row->status != 'low_balance' ? $row->status : ('Paused')) : 'In Progress(' . $row->progress . '%)';
})->rawColumns(['status', 'name', 'action'])
->filterColumn('name', function ($query, $keyword) {
$query->orWhere('name', 'like', '%' . $keyword . '%');
});
}
/**
* 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()->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'])
->dom('Bfrtip')
->buttons(
Button::make('export'),
Button::make('print'),
Button::make('reset'),
Button::make('reload')
);
}
/**
* Get columns.
*
* @return array
*/
protected function getColumns()
{
return [
'name' => ['title' => 'Campaign Name'],
'sender' => ['title' => 'Sender Id'],
'created_at',
'sched_datetime' => ['title' => 'Schedule Date'],
'sms_count' => ['title' => 'Msg count'],
'status',
'total_traffic',
'message'
];
}
/**
* Get filename for export.
*
* @return string
*/
protected function filename()
{
return 'campaign_' . time();
}
}