@php $start_date = date('Y-m-1'); $end_date = date('Y-m-t'); $this_month_petty_cash_amount = App\Models\PettyCashAmount::whereDate('Month', '>=', $start_date) ->whereDate('Month', '<=', $end_date) ->sum('Amount'); $petty_cash_amounts = App\Models\PettyCashAmount::whereYear('Month', date('Y')) ->whereDate('Month', '>=', $start_date) ->whereDate('Month', '<=', $end_date) ->get(); $petty_cash_expenses_count = App\Models\PettyCashExpense::whereDate('Date', '>=', $start_date) ->whereDate('Date', '<=', $end_date) ->count(); // dd( $petty_cash_expenses_count); $petty_cash_expenses = App\Models\PettyCashExpense::whereDate('Date', '>=', $start_date) ->whereDate('Date', '<=', $end_date) ->orderBy('Date', 'desc') ->get(); $merged_petty_cash_records = $petty_cash_expenses->concat($petty_cash_amounts)->sortBy('created_at'); @endphp

Petty Cash

@if ($merged_petty_cash_records->count() > 0) @php $total_amount_petty_cash = 0; @endphp @foreach ($merged_petty_cash_records as $record) @php $amount = isset($record->Amount) ? $record->Amount : 0; if (isset($record->Date)) { $date = $record->Date; } else { $date = $record->Month; $amount = $record->Amount; $this_month_petty_cash_amount += $amount; } $total_amount_petty_cash += $amount; @endphp @php $this_month_petty_cash_amount -= $amount; @endphp @endforeach @else @endif
DATE DESCRIPTION VENDOR PERSON AMOUNT NET AMOUNT
Opening Balance Rs. {{ $this_month_petty_cash_amount }}
{{ date('d F Y', strtotime($date)) }} {{ isset($record->Description) ? $record->Description : 'Petty Cash Addition' }} {{ isset($record->Vendor) ? $record->Vendor : 'N/A' }} {{ isset($record->Person) ? $record->Person : 'N/A' }} Rs. {{ $amount }}Rs. {{ $this_month_petty_cash_amount }} @if (date('Y-m-d', strtotime($date)) < date('Y-m-1')) Remove @else Remove @endif
Total Rs. {{ $total_amount_petty_cash }}
No Record Found