collection($query)
->editColumn('creator',function($query){
return $query->creator?->first_name.' '.$query->creator?->last_name;
})
->editColumn('assignedto',function($query){
return $query->assignedto? $query->assignedto->first_name.' '.$query->assignedto->last_name : 'N/A';
})
->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('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,
];
// Log::info('From DataTable'.json_encode($params));
$query = $this->get(env('TICKETS_API_URL') . "/all/pending",$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(5)
->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('creator')->title('Created By'),
Column::make('assignedto')->title('Assigned To'),
Column::make('created_at'),
Column::computed('action')
->exportable(false)
->printable(false)
->width(100)
->addClass('text-center'),
];
}
/**
* Get the filename for export.
*/
protected function filename(): string
{
return 'Pending_' . date('YmdHis');
}
}