eloquent($query)
->editColumn('is_active',function ($query){
return $query->is_active ? 'True' : 'False';
})
->addColumn('action', function ($query){
return '
';
});
}
/**
* Get query source of dataTable.
*
* @param UssdPrice $model
* @return Builder
*/
public function query(UssdPrice $model)
{
return $model->newQuery();
}
/**
* Optional method if you want to use html builder.
*
* @return \Yajra\DataTables\Html\Builder
*/
public function html()
{
return $this->builder()
->setTableId('ussdpricingdatatable-table')
->columns($this->getColumns())
->minifiedAjax()
->dom('Bfrtip')
->orderBy(1)
->buttons(
Button::make('create'),
Button::make('export'),
Button::make('print'),
Button::make('reset'),
Button::make('reload')
);
}
/**
* Get columns.
*
* @return array
*/
protected function getColumns()
{
return [
Column::make('name'),
Column::make('sessions'),
Column::make('cost'),
Column::make('apply_to'),
Column::make('is_active'),
Column::make('created_at'),
Column::computed('action')
->exportable(false)
->printable(false)
->width(120)
->addClass('text-center'),
];
}
/**
* Get filename for export.
*
* @return string
*/
protected function filename()
{
return 'UssdPricing_' . date('YmdHis');
}
}