eloquent($query) ->addColumn('action', function ($item) { $buttons = ''; if (auth()->user()->can('Edit Coupon')) { $buttons .= ' ' . __('custom.edit') . ' '; } if (auth()->user()->can('Delete Coupon')) { $buttons .= '
'; } $buttons .= ' ' . __('custom.products') . ' '; return '
' . $buttons . '
'; }) ->editColumn('banner', function ($item) { return '' . $item->name . ''; })->editColumn('status', function ($item) { $startDate = \Carbon\Carbon::parse($item->start_date)->format('Y-m-d'); $endDate = \Carbon\Carbon::parse($item->end_date)->format('Y-m-d'); // $check = \Carbon\Carbon::now()->between($startDate,$endDate); if($startDate <= \Carbon\Carbon::now()->format('Y-m-d') && $endDate >= \Carbon\Carbon::now()->format('Y-m-d')){ $badge = $item->status == Coupon::STATUS_ACTIVE ? "badge-success" : "badge-danger"; $data = '' . Str::upper($item->status) . ''; return $data; }else{ $data = '' . Str::upper(Coupon::STATUS_INACTIVE) . ''; return $data; } }) ->editColumn('validity', function ($item) { $startDate = \Carbon\Carbon::parse($item->start_date)->format('Y-m-d'); $endDate = \Carbon\Carbon::parse($item->end_date)->format('Y-m-d'); // $check = \Carbon\Carbon::now()->between($startDate,$endDate); if($startDate <= \Carbon\Carbon::now()->format('Y-m-d') && $endDate >= \Carbon\Carbon::now()->format('Y-m-d')){ $data = '

' . Carbon::parse($item->start_date)->format('d M Y') . ' - ' . Carbon::parse($item->end_date)->format('d M Y') .'

'; }else { $data = '

' . Carbon::parse($item->start_date)->format('d M Y') . ' - ' . Carbon::parse($item->end_date)->format('d M Y') .'

'; } return $data; }) ->editColumn('discount', function ($item) { return $item->discount .' '. ($item->discount_type == 'percent' ? '%' : currencySymbol()); }) ->rawColumns(['validity','status', 'banner', 'action'])->addIndexColumn(); } /** * Get query source of dataTable. * * @param \App\Models\Coupon $model * @return \Illuminate\Database\Eloquent\Builder */ public function query(Coupon $model) { return $model->newQuery(); } /** * Optional method if you want to use html builder. * * @return \Yajra\DataTables\Html\Builder */ public function html() { $params = $this->getBuilderParameters(); $params['order'] = [[2, 'asc']]; 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('banner', 'banner')->title(__('custom.banner')), Column::make('title', 'title')->title(__('custom.title')), Column::make('code', 'code')->title(__('custom.coupon_code')), Column::make('discount', 'discount')->title(__('custom.discount')), Column::make('validity', 'validity')->title(__('custom.validity')), Column::make('minimum_shopping', 'minimum_shopping')->title(__('custom.minimum_quantity')), Column::make('status', 'status')->title(__('custom.status')), ]; } /** * Get filename for export. * * @return string */ protected function filename() { return 'Coupons_' . date('YmdHis'); } public function pdf() { $data = $this->getDataForExport(); $pdf = PDF::loadView('vendor.datatables.print', [ 'data' => $data ]); return $pdf->download($this->getFilename() . '.pdf'); }