{{--
--}}

{{ __('messages.total_sale') }}

{{ $bookings->where('status','!=','cancelled')->sum('debit') }}

{{ __('messages.total_cash') }}

{{ ($cashPayment + $toTransfers->filter(fn($t)=>$t->toAccount->type === 'cash')->sum('amount')) - ($expense->where('account.type', 'cash')->sum('expense') + $fromTransfers->filter(fn($t)=>$t->fromAccount->type === 'cash')->sum('amount')) }}

{{ __('messages.outsource_vehicle_amount') }}

{{ $bookings->where('outsource', 1)->sum('outsource_purchase') }}

{{ __('messages.total_bookings') }}

{{ $bookings->where('on_road',0)->count() }}

{{ __('messages.total_income') }}

{{ $bookings->where('status', 'finished')->sum('debit') }}

{{ __('messages.total_bank') }}

{{ ($bankPayment + $toTransfers->filter(fn($t)=>$t->toAccount->type === 'account')->sum('amount')) - ($expense->where('account.type', 'account')->sum('expense') + $fromTransfers->filter(fn($t)=>$t->fromAccount->type === 'account')->sum('amount')) }}
@php // Filter the bookings to exclude those with 'outsourceExpense' $filteredBookings = $bookings->filter(function ($booking) { return !$booking->outsourceExpense; }); // Further filter for 'outsource' being 1 $filteredBookings = $filteredBookings->filter(function ($booking) { return $booking->outsource == 1; }); // Calculate the sums and difference $outsourcePurchaseSum = $filteredBookings->sum('outsource_purchase'); $outsourceCreditSum = $filteredBookings->sum('outsource_credit'); $difference = $outsourcePurchaseSum - $outsourceCreditSum; @endphp

{{ __('messages.outsource_pending_payment') }}

{{ $difference }}

{{ __('messages.ongoing_bookings') }}

{{ $bookings->where('on_road',0)->where('status', 'on_going')->count() }}

{{ __('messages.total_expense') }}

{{ $expense->sum('expense') }}

{{ __('messages.receivable') }}

{{ $bookings->where('on_road',0)->sum('debit') - $payments->where('booking_id','')->sum('amount') }}

{{ __('messages.outsource_profit') }}

{{ $bookings->where('outsource', 1)->sum('debit') - $bookings->where('outsource', 1)->sum('outsource_purchase') }}

{{ __('messages.pending_bookings') }}

{{ $bookings->where('on_road',0)->where('status', 'pending')->count() }}

{{ __('messages.total_profit') }}

{{ $payments->sum('amount') - $expense->sum('expense') }}

{{ __('messages.receivable_finished_payment') }}

{{ $bookings->where('status','finished')->where('on_road',0)->sum('debit') - $payments->where('booking_id','')->sum('amount') }}

{{ __('messages.on_road_total_debit') }}

{{ $bookings->where('on_road', 1)->sum('debit') }}

{{ __('messages.finished_bookings') }}

{{ $bookings->where('on_road',0)->where('status', 'finished')->count() }}

{{ __('messages.liability') }}

0

{{ __('messages.loan') }}

0

{{ __('messages.amount_to_others') }}

0