Billing Summary by Court/Tenant Report

Billing Summary by Court/Tenant Report (Electricity Charges)

Period: {{ date('F Y', strtotime($period ?? now())) }}

@foreach($billLineDescriptions as $description) @endforeach @php $grandTotal = 0; @endphp @foreach($customers as $customer) @php $grandTotal += $customer['total'] ?? 0; @endphp @php // Get the bill ID from the customer data $billId = null; $lineAmounts = []; // Find the BillID in the customer data foreach ($customer as $key => $value) { if (strpos($key, 'line_') === 0) { $lineAmounts[$customer[$key]['description']] = $customer[$key]['amount']; } elseif ($key === 'BillID') { $billId = $value; } } // Log customer info for debugging \Log::info('Processing customer:', [ 'customer_name' => $customer['customer_name'] ?? 'N/A', 'BillID' => $billId ?? 'N/A', 'total' => $customer['total'] ?? 0, 'line_amounts' => $lineAmounts ]); @endphp @foreach($billLineDescriptions as $desc) @php // Get the line amount from the pre-fetched data $lineAmount = $lineAmounts[$desc] ?? 0; // Log the line amount being used \Log::info('Line amount:', [ 'customer' => $customer['customer_name'] ?? 'N/A', 'description' => $desc, 'amount' => $lineAmount ]); @endphp @endforeach @endforeach

Tenant Name	{{ $description }}	Total
{{ $customer['customer_name'] }}	{{ number_format($lineAmount, 2) }}	{{ number_format($customer['total'] ?? 0, 2) }}
Grand Total:	{{ number_format($grandTotal, 2) }}