collection($query)
->editColumn('opener', function ($query) {
return $query->opener?->first_name . ' ' . $query->opener?->last_name;
})
->editColumn('priority', function ($query) {
switch ($query->priority) {
case 1:
return '';
break;
case 2:
return '';
break;
case 3:
return '';
break;
case 4:
return '';
break;
}
})->editColumn('type', function ($query) {
return ($query->type == 'ISSUE') ? '' . $query->type . '' : '' . $query->type . '';
})
->editColumn('created_at', function ($query) {
return date('M j, Y g:i A', strtotime($query->created_at));
})
->editColumn('opened_at', function ($query) {
return date('M j, Y g:i A', strtotime($query->opened_at));
})
->editColumn('action', function ($query) {
return '
';
})
->rawColumns(['priority', 'type', 'action']);
}
/**
* Get the query source of dataTable.
*/
public function query()
{
$duration = $this->request()->get('duration');
$start_date = $this->request()->get('start_date');
$end_date = $this->request()->get('end_date');
$params = [
'duration'=>$duration,
'start_date'=>$start_date,
'end_date'=>$end_date,
];
$query = $this->get(env('TICKETS_API_URL') . '/all/opened',$params);
if ($query->api_code == 200)
return collect($query->api_data);
else
return collect();
}
/**
* Optional method if you want to use the html builder.
*/
public function html(): HtmlBuilder
{
return $this->builder()
->setTableId('dataTable')
->columns($this->getColumns())
->minifiedAjax()
->dom('lBfrtip')
// ->orderBy(6)
->selectStyleSingle()
->buttons([
Button::make('csv'),
Button::make('excel'),
Button::make('pdf'),
Button::make('print'),
]);
}
/**
* Get the dataTable columns definition.
*/
public function getColumns(): array
{
return [
Column::make('title'),
Column::make('priority'),
Column::make('type'),
Column::make('opener')->title('Opened By'),
Column::make('created_at'),
Column::make('opened_at'),
Column::computed('action')
->exportable(false)
->printable(false)
->width(100)
->addClass('text-center'),
];
}
/**
* Get the filename for export.
*/
protected function filename(): string
{
return 'Opened_' . date('YmdHis');
}
}