eloquent($query)
->addColumn('id', function ($row) {
return '';
})
->addColumn('action', function ($item) {
$buttons = '';
$buttons .= ' ' . __('custom.show') . ' ';
if (auth()->user()->can('Edit Product')) {
$buttons .= ' ' . __('custom.edit') . ' ';
}
if (auth()->user()->can('Stock Product')) {
$buttons .= ' ' . __('custom.stock_and_price') . ' ';
}
$buttons .= ' ' . __('custom.update_stock') . ' ';
$buttons .= ' ' . __('custom.download_barcode') . ' ';
if (auth()->user()->can('Delete Product')) {
$buttons .= '
';
}
return '';
})->editColumn('is_variant', function ($item) {
if ($item->is_variant) {
return 'Yes';
} else {
return 'No';
}
})
->editColumn('name', function ($item) {
return ''.$item->name.'';
})
->editColumn('price', function ($item) {
return currencySymbol() . make2decimal($item->price);
})
->editColumn('stock', function ($item) {
return $item->stock .' '.optional($item->weight_unit)->name;
})
->editColumn('category.name', function ($item) {
return $item->category->name ?? '';
})
->editColumn('suppliers', function ($item) {
return $item->suppliers ?? '';
})
->editColumn('thumb', function ($item) {
return '
';
})->editColumn('status', function ($item) {
$badge = $item->status == Product::STATUS_ACTIVE ? "badge-success" : "badge-danger";
return '' . Str::upper($item->status) . '';
})->addColumn('transfer_product', function($item){
return 'Transfer Product';
})
/*->editColumn('tax_status', function ($item) {
return Str::upper($item->tax_status);
})*/
->rawColumns(['tax_status','suppliers', 'status', 'is_variant', 'thumb', 'action', 'id', 'name','transfer_product'])->addIndexColumn();
}
/**
* Get query source of dataTable.
*
* @param User $model
* @return \Illuminate\Database\Eloquent\Builder
*/
public function query(Product $model)
{
return $model->with(['category', 'manufacturer', 'weight_unit'])->newQuery()->select('products.*');
}
/**
* Optional method if you want to use html builder.
*
* @return \Yajra\DataTables\Html\Builder
*/
public function html()
{
$params = $this->getBuilderParameters();
$params['order'] = [[3, 'asc']];
return $this->builder()
->columns($this->getColumns())
->minifiedAjax()
->addAction(
[
'width' => '55px',
'class' => "text-center",
'printable' => false,
'exportable' => false,
'title' => __('custom.action'),
'scrollY' => '320px'
],
)
->parameters($params);
}
/**
* Get columns.
*
* @return array
*/
protected function getColumns()
{
return [
Column::computed('DT_RowIndex', __('custom.sl')),
Column::make('id', 'id')
->orderable(false)
->searchable(false)
->printable(false)
->exportable(false)
->className('select_all_checkbox')
->title('')
->render(''),
Column::make('thumb', 'thumb')->title(__('custom.thumb')),
Column::make('name', 'name')->title(__('custom.product_name')),
Column::make('sku', 'sku')->title(__('custom.sku')),
Column::make('category.name', 'category.name')->title(__('custom.category')),
Column::make('price', 'price')->title(__('custom.price')),
Column::make('stock', 'stock')->title(__('custom.stock_quantity')),
Column::make('suppliers', 'suppliers')->title(__('custom.suppliers_count')),
Column::make('is_variant', 'is_variant')->title(__('custom.variant')),
/*Column::make('tax_status', 'tax_status')->title(__('custom.tax')),*/
Column::make('status', 'status')->title(__('custom.status')),
Column::make('transfer_product', 'transfer_product')->title(__("custom.transfer_product")),
];
}
/**
* Get filename for export.
*
* @return string
*/
protected function filename()
{
return 'Product_' . 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');
}