Orders Summary

Total Orders {{ \App\Models\Order::count() }}

{{--

Packing Orders {{ \App\Models\Order::where('delivery_status', 'packing')->whereDate('created_at', today())->count() }} -- Packed {{ \App\Models\Order::where('delivery_status', 'packed')->where('created_at', today())->count() }}

--}} {{--

Dispatch Orders {{ \App\Models\Order::where('delivery_status', 'dispatched')->whereDate('created_at', today())->count() }}

--}}

Completed Orders {{ \App\Models\Order::where('delivery_status', 'completed')->count() }}

{{--

Pending Orders {{ \App\Models\Order::where('approval_status', 'pending')->whereDate('created_at', today())->count() }}

--}} {{--

Approved Orders {{ \App\Models\Order::where('approval_status', 'approved')->whereDate('created_at', today())->count() }}

--}}

Declined Orders {{ \App\Models\Order::where('approval_status', 'decline')->count() }}

Cancelled Orders {{ \App\Models\Order::where('approval_status', 'canceled')->count() }}

Invoices Summary

@php $total = \App\Models\Order::whereHas('invoice')->sum('grand_total'); $EAtotal = \App\Models\Order::whereHas('invoice', function ($query) { $query->where('company_id', '3'); })->sum('grand_total'); $FAtotal = \App\Models\Order::whereHas('invoice', function ($query) { $query->where('company_id', '4'); })->sum('grand_total'); $totalPaind = \App\Models\Order::whereHas('invoice')->where("payment_status", "paid")->sum('grand_total'); $totalPending = \App\Models\Order::whereHas('invoice')->where("payment_status", "pending")->sum('grand_total'); @endphp

Total Invoices {{ $total }}

FA Invoices {{ $FAtotal }}

EA Invoices {{ $EAtotal }}

Paid Invoices {{ $totalPaind }}

Pending Invoices {{ $totalPending }}

{{--