eloquent($query);
$datatables->addIndexColumn();
$datatables->addColumn('action', function ($row) {
$action = '';
return $action;
});
$datatables->editColumn('rotation_name', fn ($row) => $row->rotation_name ? '
'.$row->rotation_name.'' : '--');
$datatables->addColumn('no_of_emp', function ($row) {
$rotationEmployees = AutomateShift::where('employee_shift_rotation_id', $row->id)->pluck('user_id');
if (count($rotationEmployees) > 0) {
return '' . count($rotationEmployees) . '';
}
else {
return '' . count($rotationEmployees) . '';
}
});
$datatables->editColumn('override_shift', function ($row) {
if ($row->override_shift == 'yes') {
return '' . __('app.yes') . '';
}
else {
return '' . __('app.no') . '';
}
});
$datatables->editColumn('send_mail', function ($row) {
if ($row->send_mail == 'yes') {
return '' . __('app.yes') . '';
}
else {
return '' . __('app.no') . '';
}
});
$datatables->editColumn('status', function ($row) {
$status = '';
return $status;
});
$datatables->smart(false);
$datatables->rawColumns(['rotation_name', 'no_of_emp', 'override_shift', 'send_mail', 'status', 'action']);
return $datatables;
}
/**
* @param ShiftRotation $model
* @return ShiftRotation|\Illuminate\Database\Eloquent\Builder|\Illuminate\Database\Query\Builder
*/
public function query(ShiftRotation $model)
{
return $model->query();
}
/**
* Optional method if you want to use html builder.
*
* @return \Yajra\DataTables\Html\Builder
*/
public function html()
{
$dataTable = $this->setBuilder('shift-rotation-table', 2)
->parameters(
[
'initComplete' => 'function () {
window.LaravelDataTables["shift-rotation-table"].buttons().container()
.appendTo( "#table-actions")
}',
'fnDrawCallback' => 'function( oSettings ) {
$("#shift-rotation-table .select-picker").selectpicker();
$("body").tooltip({
selector: \'[data-toggle="tooltip"]\'
})
}',
]
);
return $dataTable;
}
/**
* Get columns.
*
* @return array
*/
protected function getColumns()
{
$data = [
__('app.rotationName') => ['data' => 'rotation_name', 'name' => 'rotation_name', 'title' => __('app.rotationName')],
__('app.noOfEmp') => ['data' => 'no_of_emp', 'name' => 'no_of_emp', 'title' => __('app.noOfEmp'), 'orderable' => false],
__('app.replacePreAssignedShift') => ['data' => 'override_shift', 'name' => 'override_shift', 'title' => __('app.replacePreAssignedShift')],
__('app.sendRotationNotification') => ['data' => 'send_mail', 'name' => 'send_mail', 'title' => __('app.sendRotationNotification')],
__('app.status') => ['data' => 'status', 'name' => 'status', 'title' => __('app.status')],
];
$action = [
Column::computed('action', __('app.action'))
->exportable(false)
->printable(false)
->orderable(false)
->searchable(false)
->addClass('text-right pr-20')
];
return array_merge($data, $action);
}
}