eloquent($query)
->filterColumn('missing_item', function ($query, $keyword) {
})
->filterColumn('purchaseItems', function ($query, $keyword) {
})
->addColumn('action', function ($item) {
$buttons = '';
if (auth()->user()->can('Show Purchase')) {
$buttons .= ' ' . __t('show') . ' ';
}
if ($item->status != Purchase::STATUS_CANCEL) {
if ($item->received == null) {
if (auth()->user()->can('Edit Purchase')) {
$buttons .= ' ' . __('custom.edit') . ' ';
}
if (auth()->user()->can('Cancel Purchase')) {
$buttons .= ' ' . __('custom.cancel') . ' ';
}
}
if (auth()->user()->can('Receive Purchase')) {
$buttons .= ' ' . __t('receive') . ' ';
}
if ($item->status == Purchase::STATUS_CONFIRMED) {
if ($item->received) {
if (auth()->user()->can('Return Purchase')) {
$buttons .= ' ' . __t('return') . ' ';
}
}
}
// if ($item->status != Purchase::STATUS_CONFIRMED) {
// if (auth()->user()->can('Confirm Purchase')) {
// $buttons .= ' ' . __t('confirm') . ' ';
// }
// }
}
if (auth()->user()->can('Show Purchase')) {
$buttons .= '
';
}
return '';
})
->editColumn('date', function ($item) {
return date('Y-m-d', strtotime($item->date));
})
->editColumn('purchase_number', function ($item) {
return '' . $item->purchase_number . '';
})
// ->editColumn('status', function ($item) {
// $badge = $item->status == Purchase::STATUS_REQUESTED ? "badge-success" : ($item->status == Purchase::STATUS_CONFIRMED ? "badge-primary" : "badge-danger");
// return '' . Str::upper($item->status) . '';
// })
->editColumn('received', function ($item) {
if ($item->received) {
return '' . __t('received') . '';
} else {
if ($item->status == \App\Models\Purchase::STATUS_CANCEL) {
return '' . ucfirst(\App\Models\Purchase::STATUS_CANCEL) . '';
} elseif ($item->status == \App\Models\Purchase::STATUS_REQUESTED) {
return '' . ucfirst(\App\Models\Purchase::STATUS_REQUESTED) . '';
} elseif ($item->status == \App\Models\Purchase::STATUS_CONFIRMED) {
return '' . ucfirst(\App\Models\Purchase::STATUS_CONFIRMED) . '';
} else {
return '' . __t('not_received_yet') . '';
}
}
})
->editColumn('purchaseItems', function ($item) {
return $item->purchaseItems->count();
})
->editColumn('missing_item', function ($item) {
if ($item->received) {
$purchaseItemQty = $item->purchaseItems->sum('quantity');
$purchaseReceiveItemQty = 0;
foreach ($item->purchaseItems as $purchaseItems) {
$purchaseReceiveItemQty += $purchaseItems->receiveItems->sum('quantity');
}
if ($purchaseItemQty != $purchaseReceiveItemQty) {
return '' . __t('missing') .' ('.$purchaseItemQty - $purchaseReceiveItemQty.')' .'';
}
}
})
->editColumn('total', function ($item) {
return currencySymbol() . make2decimal($item->total);
})
->editColumn('supplier.first_name', function ($item) {
return $item->supplier->full_name;
})
->rawColumns(['status', 'received', 'date', 'purchaseItems', 'action', 'missing_item', 'supplier.first_name', 'purchase_number'])->addIndexColumn();
}
/**
* Get query source of dataTable.
*
* @param User $model
* @return \Illuminate\Database\Eloquent\Builder
*/
public function query(Purchase $model)
{
return $model->with(['supplier', 'warehouse', 'purchaseItems'])->newQuery()->select('purchases.*');
}
/**
* 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", 'width' => '55px', 'printable' => false, 'exportable' => false, 'title' => __('custom.action')])
->parameters($params);
}
/**
* Get columns.
*
* @return array
*/
protected function getColumns()
{
return [
Column::computed('DT_RowIndex', __('custom.sl')),
Column::make('purchase_number', 'purchase_number')->title(__t('purchase_number')),
Column::make('supplier.first_name', 'supplier.first_name')->title(__t('supplier_name')),
Column::make('warehouse.name', 'warehouse.name')->title(__t('warehouse')),
Column::make('date', 'date')->title(__t('date')),
Column::make('total', 'total')->title(__t('total')),
// Column::make('status', 'status')->title(__('custom.status')),
Column::make('purchaseItems', 'purchaseItems')->title(__t('total_product'))->addClass('text-center'),
Column::make('received', 'received')->title(__t('received')),
Column::make('missing_item', 'missing_item')->title(__t('missing_item')),
];
}
/**
* Get filename for export.
*
* @return string
*/
protected function filename()
{
return 'Purchase_' . 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');
}