businessId(); $user_id = auth()->id(); if ($request->ajax()) { $sells = $this->transactionUtil->getListSells($business_id); $sells->where('transactions.commission_agent', $user_id); if (! empty($request->start_date) && ! empty($request->end_date)) { $sells->whereDate('transactions.transaction_date', '>=', $request->start_date) ->whereDate('transactions.transaction_date', '<=', $request->end_date); } $sells->groupBy('transactions.id'); return Datatables::of($sells) ->editColumn('final_total', '{{$final_total}}') ->editColumn('transaction_date', '{{@format_datetime($transaction_date)}}') ->rawColumns(['final_total']) ->make(true); } $payment_types = $this->transactionUtil->payment_types(null, true); return view('portal::marketer.sells.index', compact('payment_types')); } }