editTaskPermission = user()->permission('edit_tasks');
$this->deleteTaskPermission = user()->permission('delete_tasks');
$this->viewTaskPermission = user()->permission('view_tasks');
}
/**
* Build DataTable class.
*
* @param mixed $query Results from query() method.
* @return \Yajra\DataTables\DataTableAbstract
*/
public function dataTable($query)
{
return datatables()
->eloquent($query)
->addColumn('check', fn($row) => $this->checkBox($row))
->addColumn('action', function ($row) {
$action = '';
return $action;
})
->editColumn('heading', function ($row) {
$taskLabelList = TaskLabelList::whereNull('project_id')->get();
$taskLabelIds = explode(',', $row->task_labels);
$labels = '';
// Use foreach instead of forelse
foreach (
$taskLabelList->filter(function ($label) use ($taskLabelIds) {
return in_array($label->id, $taskLabelIds);
}) as $key => $label
) {
$labels .= ''
. $label->label_name . '';
}
return '';
})
->setRowId(fn($row) => 'row-' . $row->id)
->rawColumns(['action', 'heading', 'check']);
}
/**
* Get query source of dataTable.
*
* @param \App\Models\ProjectTemplateTask $model
* @return \Illuminate\Database\Eloquent\Builder
*/
public function query(ProjectTemplateTask $model)
{
$request = $this->request();
$projectId = $request->projectId;
$model = $model->where('project_template_id', $projectId);
if ($request->searchText != '') {
$safeTerm = Common::safeString(request('searchText'));
$model->where(function ($query) use ($safeTerm) {
$query->where('heading', 'like', '%' . $safeTerm . '%');
});
}
return $model;
}
/**
* Optional method if you want to use html builder.
*
* @return \Yajra\DataTables\Html\Builder
*/
public function html()
{
$dataTable = $this->setBuilder('allTasks-table', 0)
->parameters([
'initComplete' => 'function () {
window.LaravelDataTables["allTasks-table"].buttons().container()
.appendTo("#table-actions")
}',
'fnDrawCallback' => 'function( oSettings ) {
$("#allTasks-table .select-picker").selectpicker();
}',
]);
return $dataTable;
}
/**
* Get columns.
*
* @return array
*/
protected function getColumns()
{
return [
'#' => ['data' => 'id', 'name' => 'id', 'visible' => false],
__('app.task') => ['data' => 'heading', 'name' => 'heading', 'title' => __('app.task')],
Column::computed('action', __('app.action'))
->exportable(false)
->printable(false)
->orderable(false)
->searchable(false)
->width(150)
->addClass('text-right pr-20')
];
}
}