use Carbon\Carbon; if(!empty($request->date)){ $all_data->date=$request->date; } else{ $all_data->date= Carbon::today(); } DATE WISE
@csrf
Datewise ReportAAA
From
To
public function datewise_report(Request $request){ $start_date = Carbon::parse($request->start_date) ->toDateTimeString(); $end_date = Carbon::parse($request->end_date) ->toDateTimeString(); $datewiseReport = Credit::join('payment', 'receive.id', '=', 'payment.receive_id') ->whereBetween('receive.created_at',[$start_date,$end_date]) ->orderBy('id','DESC') ->distinct('id') ->get(['receive.*', 'payment.date','payment.source','payment.credit_source','payment.receive_id','payment.particular', 'payment.amount','payment.project']); $datewiseReportNew = Credit::join('payment', 'receive.id', '=', 'payment.receive_id') ->whereBetween('receive.created_at',[$start_date,$end_date]) ->select('r_amount') ->distinct() ->get(); $totalDebit = $datewiseReportNew->sum('r_amount'); $totalCredit = $datewiseReport->sum('amount'); return view('account.report.datewiseReport', compact('datewiseReport','totalDebit','totalCredit')); return view('restaurant.report.dateWiseReport', compact('dateWiseReport','totalAmount')); } MONTHLY public function monthly_report(){ $monthlyReport = Credit::join('payment', 'receive.id', '=', 'payment.receive_id') ->whereMonth('receive.created_at', Carbon::now()->month) ->orderBy('id','DESC') ->distinct('id') ->get(['receive.*', 'payment.date','payment.source','payment.credit_source','payment.receive_id','payment.particular', 'payment.amount','payment.project']); $monthlyReportNew = Credit::join('payment', 'receive.id', '=', 'payment.receive_id') ->whereMonth('receive.created_at', Carbon::now()->month) ->select('r_amount') ->distinct() ->get(); $totalDebit = $monthlyReportNew->sum('r_amount'); $totalCredit = $monthlyReport->sum('amount'); return view('account.report.monthlyReport', compact('monthlyReport','totalDebit','totalCredit')); } DAILY public function daily_report(){ $dailyReport = Credit::join('payment', 'receive.id', '=', 'payment.receive_id') ->orderBy('id','DESC') ->where('r_date', Carbon::today()) ->distinct('r_amount') ->get(['receive.*', 'payment.date','payment.source','payment.credit_source','payment.receive_id','payment.particular', 'payment.amount','payment.project']); $dailyReportNew = Credit::join('payment', 'receive.id', '=', 'payment.receive_id') ->where('r_date', Carbon::today()) ->select('r_amount') ->distinct() ->get(); $totalDebit = $dailyReportNew->sum('r_amount'); $totalCredit = $dailyReport->sum('amount'); return view('account.report.dailyReport', compact('dailyReport','totalDebit','totalCredit')); }