eloquent($query)
->filterColumn('sale_return_items', function ($query, $keyword) {
})
->addColumn('action', function ($item) {
$buttons = '';
if (auth()->user()->can('Show Sale Return')) {
$buttons .= ' ' . __t('show') . ' ';
}
return '';
})
->editColumn('invoice_id', function ($item) {
return ''. make8digits($item->invoice_id).'';
})
->editColumn('date', function ($item) {
return date('Y-m-d', strtotime($item->return_date));
})
->editColumn('sale_return_items', function ($item) {
return $item->saleReturnItems->count();
})
->editColumn('invoice.customer', function ($item) {
if (!empty($item->invoice->customer_id)) {
return ucfirst($item->invoice->customer['full_name'] ?? '');
} else {
return ucfirst($item->invoice->customer['full_name'] ?? 'Walk-In Customer');
}
})
->rawColumns(['invoice_id', 'date', 'sale_return_items', 'action', 'invoice.customer'])->addIndexColumn();
}
/**
* Get query source of dataTable.
*
* @param User $model
* @return \Illuminate\Database\Eloquent\Builder
*/
public function query(SaleReturn $model)
{
return $model->with(['invoice', 'invoice.customerInfo', 'saleReturnItems'])->newQuery()->select('sale_returns.*');
}
/**
* 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' => '55px', 'class' => "text-center", 'width' => '55px', 'printable' => false, 'exportable' => false, 'title' => __('custom.action')])
->parameters([
'dom' => 'Bfrtilp',
'order' => [[1, 'desc']],
'buttons' => [
'csv',
'excel',
'pdf',
'print',
'reload',
],
]);
}
/**
* Get columns.
*
* @return array
*/
protected function getColumns()
{
return [
Column::computed('DT_RowIndex', __('custom.sl')),
Column::make('invoice_id', 'invoice_id')->title(__t('invoice_number')),
Column::make('invoice.customer', 'invoice.customer')->title(__t('customer_name')),
Column::make('return_date', 'return_date')->title(__t('date')),
Column::make('sale_return_items', 'sale_return_items')->title(__t('total_product'))->addClass('text-center'),
];
}
/**
* Get filename for export.
*
* @return string
*/
protected function filename()
{
return 'Sales_return_list_' . 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');
}