Invoice Report

{{ $user?->user?->name }} ({{ $user?->user?->email }})

Date Range:{{ $date_range['start'] }} to {{ $date_range['end'] }}

@foreach ($monthly_data as $monthData)

{{ $monthData['month'] }} Summary

Day and Night Summary

@php if (!function_exists('calculateTotals')) { function calculateTotals($records, $key) { return collect($records)->sum($key); } } $dayRecords = !empty($monthData['daily_records']['day']) ? $monthData['daily_records']['day'] : null; $nightRecords = !empty($monthData['daily_records']['night']) ? $monthData['daily_records']['night'] : null; @endphp @if ($dayRecords || $nightRecords) {{-- Milk Quantity Row --}} {{-- Total Amount Row --}} {{-- Payments Row --}}
Key Day Value Night Value
Milk Quantity {{ $dayRecords ? calculateTotals($dayRecords, 'milk_quantity') : 'N/A' }} {{ $nightRecords ? calculateTotals($nightRecords, 'milk_quantity') : 'N/A' }}
Total Amount {{ $dayRecords ? number_format(calculateTotals($dayRecords, 'total_amount'), 2) : 'N/A' }} {{ $nightRecords ? number_format(calculateTotals($nightRecords, 'total_amount'), 2) : 'N/A' }}
Payments @if ($dayRecords)
    @foreach ($dayRecords as $record) @if (!empty($record['payments'])) @foreach ($record['payments'] as $payment)
  • Amount: {{ number_format($payment['amount'], 2) }} (Reason: {{ $payment['reason'] }})
    • @endforeach @endif @endforeach
@else N/A @endif 		@if ($nightRecords)
    @foreach ($nightRecords as $record) @if (!empty($record['payments'])) @foreach ($record['payments'] as $payment)
  • Amount: {{ number_format($payment['amount'], 2) }} (Reason: {{ $payment['reason'] }})
    • @endforeach @endif @endforeach
@else N/A @endif
@else

No data found for this month.

@endif
@endforeach

Total Summary

@if ($user_type == 'vendor') @endif
Key Value
Total Milk Quantity {{ number_format($total_records['total_milk_quantity'], 2) }}
Total Milk Amount {{ number_format($total_records['total_milk_amount'], 2) }}
{{ $user_type == 'customer' ? 'Total Payments Received' : 'Total Payments Payable' }} {{ number_format($total_records['total_received_payments'], 2) }}
Remaining Balance {{ number_format($total_records['remaining_balance'], 2) }}
Total Remaining Amount With Advance {{ number_format($total_remaining_amount, 2) }}
Advance Payment {{ number_format($advance_payment, 2) }}