eloquent($query)
->addColumn('action', function ($item) {
$buttons = '';
if (auth()->user()->can('Show Invoice')) {
$buttons .= ' ' . __('custom.show') . ' ';
}
if (auth()->user()->can('Edit Invoice')) {
if ($item->status == Invoice::STATUS_PENDING) {
$buttons .= ' ' . __('custom.edit') . ' ';
}
}
if ($item->status != Invoice::STATUS_PENDING && auth()->user()->can('Return Invoice')) {
$buttons .= ' ' . __('custom.return') . ' ';
}
if (auth()->user()->can('View Payment Invoice')) {
$buttons .= ' ' . __('custom.view_payment') . ' ';
}
if ($item->status != Invoice::STATUS_PAID && auth()->user()->can('Make Payment Invoice')) {
$buttons .= ' ' . __('custom.make_payment') . ' ';
}
if (auth()->user()->can('Download Invoice')) {
$buttons .= ' ' . __('custom.download') . ' ';
}
// if (auth()->user()->can('delivery Invoice')) {
if ($item->delivery_status != Invoice::DELIVERY_STATUS_DELIVERED && ($item->status == Invoice::STATUS_PAID || $item->status == Invoice::STATUS_PARTIALLY_PAID)) {
$buttons .= ' ' . __('custom.make_delivered') . ' ';
}
if ($item->delivery_status != Invoice::DELIVERY_STATUS_CANCELED ) {
$buttons .= ' ' . __('custom.make_cancel') . ' ';
}
// }
if (auth()->user()->can('Send Invoice')) {
$buttons .= ' ' . __('custom.send') . ' ';
}
if (auth()->user()->can('Link Invoice')) {
$buttons .= ' ' . __('custom.link') . ' ';
}
if (auth()->user()->can('Delete Invoice')) {
// if ($item->status == Invoice::STATUS_PENDING) {
$buttons .= '
';
// }
}
return '';
})->editColumn('id', function ($item) {
return ''.make8digits($item->id).' ';
})->editColumn('customer', function ($item) {
if ($item->customer_id) {
return ucfirst($item->customer['full_name'] ?? '');
} else {
return ucfirst($item->customer['full_name'] ?? 'Walk-In Customer');
}
})->editColumn('warehouse', function ($item) {
if ($item->warehouse_id){
return optional($item->warehouse)->name;
}
})->editColumn('date', function ($item) {
return custom_date($item->date);
})->editColumn('payment_type', function ($item) {
return strtoupper($item->payment_type);
})->editColumn('due_date', function ($item) {
return custom_date($item->date);
})->editColumn('total', function ($item) {
return currencySymbol() . $item->total;
})
->editColumn('total_paid', function ($item) {
return currencySymbol() . $item->total_paid;
})
->editColumn('status', function ($item) {
return invoiceStatusBadge($item->status);
})
->editColumn('delivery_status', function ($item) {
return invoiceDeliveryStatusBadge($item->delivery_status);
})
->filterColumn('id', function ($query, $keyword) {
$query->orWhere('id', 'like', '%' . ltrim($keyword, '0') . '%');
})
->rawColumns(['status','delivery_status', 'action', 'id', 'warehouse'])->addIndexColumn();
}
/**
* Get query source of dataTable.
*
* @param User $model
* @return \Illuminate\Database\Eloquent\Builder
*/
public function query(Invoice $model)
{
return $model->newQuery()->with('warehouse')->select('invoices.*');
}
/**
* Optional method if you want to use html builder.
*
* @return \Yajra\DataTables\Html\Builder
*/
public function html()
{
$params = $this->getBuilderParameters();
$params['order'] = [[1, 'desc']];
return $this->builder()
->columns($this->getColumns())
->minifiedAjax()
->addAction(['width' => '55px', 'class' => "text-center", 'printable' => false, 'exportable' => false, 'title' => 'ACTION'])
->parameters($params);
}
/**
* Get columns.
*
* @return array
*/
protected function getColumns()
{
return [
Column::computed('DT_RowIndex', __('custom.sl')),
Column::make('id', 'id')->title(__('custom.invoice_id')),
Column::make('warehouse', 'warehouse.name')->title(__('custom.warehouse')),
Column::make('date', 'date')->title(__('custom.date')),
Column::make('customer', 'customer')->title(__('custom.customer')),
Column::make('total', 'total')->title(__('custom.total')),
Column::make('total_paid', 'total_paid')->title(__('custom.total_paid')),
Column::make('payment_type', 'payment_type')->title(__('custom.payment_type')),
Column::make('status', 'status')->title(__('custom.status')),
Column::make('delivery_status', 'delivery_status')->title(__('custom.delivery_status')),
];
}
/**
* filename
*
* @return void
*/
protected function filename()
{
return 'Invoice_' . 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');
}