collection($query)
->editColumn('priority', function ($query) {
switch ($query->priority) {
case 1:
return '';
break;
case 2:
return '';
break;
case 3:
return '';
break;
case 4:
return '';
break;
}
})
// ->editColumn('count')
->rawColumns(['priority']);
}
/**
* 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,
];
// dd($params);
// Log::info('From DataTable'.json_encode($params));
$query = $this->get(env('TICKETS_API_URL') . "/occurrence/tickets", $params);
Log::info('', array($query));
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(2)
->selectStyleSingle()
->buttons([
Button::make('excel'),
Button::make('csv'),
Button::make('pdf'),
Button::make('print'),
]);
}
/**
* Get the dataTable columns definition.
*/
public function getColumns(): array
{
return [
Column::make('priority'),
Column::make('description')->title('Ticket Description'),
Column::make('count')->title('Occurrences'),
// Column::make('updated_at'),
];
}
/**
* Get the filename for export.
*/
protected function filename(): string
{
return 'OccurrenceDatable_' . date('YmdHis');
}
}