eloquent($query)
->filterColumn('expenseBy.name', function (){
})
->addColumn('action', function ($item) {
$buttons = '';
if (auth()->user()->can('Show Expenses')) {
$buttons .= ' ' . __('custom.show') . ' ';
}
if (auth()->user()->can('Edit Expenses')) {
$buttons .= ' ' . __('custom.edit') . ' ';
}
if (auth()->user()->can('Delete Expenses')) {
$buttons .= '
';
}
return '';
})->editColumn('category.name', function ($item) {
return $item->category->name ?? '';
})->editColumn('total', function ($item) {
return currencySymbol() . makeCurrencyFormat($item->total);
})->editColumn('notes', function ($item) {
return Str::limit($item->notes, 50, '...');
})->editColumn('expenseBy.name', function ($item) {
return optional($item->expenseBy)->name;
})
->filterColumn('date', function ($item) {
if (request()->has('from_date') && request()->has('to_date')) {
$item->whereBetween('date', [request()->from_date, request()->to_date]);
}
})
->rawColumns(['action'])->addIndexColumn();
}
/**
* Get query source of dataTable.
*
* @param User $model
* @return \Illuminate\Database\Eloquent\Builder
*/
public function query(Expenses $model)
{
return $model->newQuery()->with(['category'])->select('expenses.*');
}
/**
* Optional method if you want to use html builder.
*
* @return \Yajra\DataTables\Html\Builder
*/
public function html()
{
$params['order'] = [[2, 'desc']];
return $this->builder()
->columns($this->getColumns())
->minifiedAjax()
->addAction(['width' => '55px', 'class' => "text-center", 'printable' => false, 'exportable' => false, 'title' => __('custom.action')])
->dom('Bfrtip')
->buttons(
Button::make('create')->action("window.location = '".route('admin.expenses.create')."';"),
Button::make('csv'),
Button::make('excel'),
Button::make('pdf'),
Button::make('print'),
Button::make('reload')
)->parameters($params);;
}
public function createAction()
{
return Button::make('create')->action("window.location = '".route('admin.expenses.create')."';");
}
/**
* Get columns.
*
* @return array
*/
protected function getColumns()
{
return [
Column::computed('DT_RowIndex', __('custom.sl')),
Column::make('title', 'title')->title(__('custom.title')),
Column::make('date', 'date')->title(__('custom.date'))->class('width_10p'),
Column::make('category.name', 'category.name')->title(__('custom.category')),
Column::make('total', 'total')->title(__('custom.total')),
Column::make('expenseBy.name', 'expenseBy.name')->title(__('custom.expense_user')),
];
}
/**
* Get filename for export.
*
* @return string
*/
protected function filename()
{
return 'Expenses_' . date('YmdHis');
}
/**
* pdf
*
* @return void
*/
public function pdf()
{
$data = $this->getDataForExport();
$pdf = PDF::loadView('vendor.datatables.print', [
'data' => $data
]);
return $pdf->download($this->getFilename() . '.pdf');
}