@foreach (array_reverse(\Carbon\CarbonPeriod::create(now()->subYears(5), '1 year', now())->toArray()) as $date)
{{ $date->format('Y') }}
@endforeach
{{ request()->routeIs('billings.management.tellers') ? __('Teller Histories') : trans('menu.payment-histories') }}
@if (!request()->routeIs('billings.management.tellers'))
{{ __('Teller Histories') }}
@endif
@if (!request()->routeIs('billings.management.payments'))
{{ trans('menu.payment-histories') }}
@endif
@php
$paymentGroupedByMonths = $paymentHistories->groupBy([
function ($item) {
return \Carbon\Carbon::parse($item['created_at'])->format('y-m');
},
'teller_name'
])->sortBy(function ($item, $key) {
return $key;
});
@endphp
@forelse ( $paymentGroupedByMonths as $month => $paymentGroupedByTellers)
{{ \Carbon\Carbon::parse($month.'-01')->format('F Y') }}
{{ trans('billing.table.no') }}
Name
Cash
Transfer
Amount
@forelse ( $paymentGroupedByTellers as $teller => $paymentGroupedByTeller)
{{ $loop->index + 1 }}
{{ $teller }}
@moneyIDR($paymentGroupedByTeller->where('payment_method', 'cash')->sum('amount'))
@php
$paymentByTransfers = $paymentGroupedByTeller->where('payment_method', '!=', 'cash');
$paymentGroupedByBanks = $paymentByTransfers->groupBy('bank_account')
->sortBy(function ($item, $key) {
return $key;
});
@endphp
@foreach ($paymentGroupedByBanks as $bank => $paymentGroupedByBank)
{{ $bank }}
@moneyIDR($paymentGroupedByBank->sum('amount'))
@endforeach
Total Amount:
@moneyIDR($paymentByTransfers->sum('amount'))
@moneyIDR($paymentGroupedByTeller->sum('amount'))
@empty
{{ trans('Payment History not found') }}
@endforelse
Total:
@php
$totalPaymentHistoriesMonthCash = $paymentHistories->where('payment_method', 'cash')->filter(function ($paymentHistory) use($month) {
return \Carbon\Carbon::parse($paymentHistory->created_at)->isSameMonth(\Carbon\Carbon::parse($month.'-01'));
});
@endphp
@moneyIDR($totalPaymentHistoriesMonthCash->sum('amount'))
@php
$totalPaymentHistoriesMonthTransfer = $paymentHistories->where('payment_method', '!=', 'cash')
->filter(function ($paymentHistory) use($month) {
return \Carbon\Carbon::parse($paymentHistory->created_at)->isSameMonth(\Carbon\Carbon::parse($month.'-01'));
});
$paymentMonthGroupedByBanks = $totalPaymentHistoriesMonthTransfer->groupBy('bank_account')
->sortBy(function ($item, $key) {
return $key;
});
@endphp
@foreach ($paymentMonthGroupedByBanks as $bankName => $paymentMonthGroupedByBank)
{{ $bankName }}
@moneyIDR($paymentMonthGroupedByBank->sum('amount'))
@endforeach
Total Amount:
@moneyIDR($totalPaymentHistoriesMonthTransfer->sum('amount'))
@php
$totalPaymentHistoriesMonth = $paymentHistories->filter(function ($paymentHistory) use($month) {
return \Carbon\Carbon::parse($paymentHistory->created_at)->isSameMonth(\Carbon\Carbon::parse($month.'-01'));
});
@endphp
@moneyIDR($totalPaymentHistoriesMonth->sum('amount'))
@empty
{{ trans('billing.table.no') }}
Name
Amount
{{ trans('Payment history not found') }}
@endforelse