addColumn('action', function ($query){
$action= '';
return $action;
})
->addColumn('day', function ($query){
$date = Carbon::parse($query->date)->format('l');
return $date;
})
->editColumn('state', function ($query){
if($query->state == true):
return '';
elseif ($query->state == false):
return '';
else:
return 'N/A';
endif;
})->rawColumns(['state','action']);
}
/**
* Get query source of dataTable.
*
* @param \App\User $model
* @return \Illuminate\Database\Eloquent\Builder
*/
public function query(PubDate $model)
{
return $model->newQuery()->select('*');
}
/**
* Optional method if you want to use html builder.
*
* @return \Yajra\DataTables\Html\Builder
*/
public function html()
{
return $this->builder()
->columns($this->getColumns())
->minifiedAjax()
->addAction(['width' => '80px'])
->parameters($this->getBuilderParameters());
}
/**
* Get columns.
*
* @return array
*/
protected function getColumns()
{
return [
'date',
'day',
'state',
'created_at',
'updated_at'
];
}
/**
* Get filename for export.
*
* @return string
*/
protected function filename()
{
return 'AvailableDates_' . date('YmdHis');
}
}