addColumn('action', '$VIEW_PREFIX$$MODEL_NAME_PLURAL_SNAKE$.datatables_actions');
}
/**
* Get query source of dataTable.
*
* @param \App\Models\$MODEL_NAME$ $model
* @return \Illuminate\Database\Eloquent\Builder
*/
public function query($MODEL_NAME$ $model)
{
return $model->newQuery();
}
/**
* 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' => '120px', 'printable' => false, 'title' => __('crud.action')])
->parameters([
'dom' => 'Bfrtip',
'stateSave' => true,
'order' => [[0, 'desc']],
'buttons' => [
[
'extend' => 'create',
'className' => 'btn btn-default btn-sm no-corner',
'text' => ' ' .__('auth.app.create').''
],
[
'extend' => 'export',
'className' => 'btn btn-default btn-sm no-corner',
'text' => ' ' .__('auth.app.export').''
],
[
'extend' => 'print',
'className' => 'btn btn-default btn-sm no-corner',
'text' => ' ' .__('auth.app.print').''
],
[
'extend' => 'reset',
'className' => 'btn btn-default btn-sm no-corner',
'text' => ' ' .__('auth.app.reset').''
],
[
'extend' => 'reload',
'className' => 'btn btn-default btn-sm no-corner',
'text' => ' ' .__('auth.app.reload').''
],
],
'language' => [
'url' => url('//cdn.datatables.net/plug-ins/1.10.12/i18n/English.json'),
],
]);
}
/**
* Get columns.
*
* @return array
*/
protected function getColumns()
{
return [
$DATATABLE_COLUMNS$
];
}
/**
* Get filename for export.
*
* @return string
*/
protected function filename()
{
return '$MODEL_NAME_PLURAL_SNAKE$_datatable_' . time();
}
}