@extends('reports.layout')

@section('content')
@php
    function fmt($amount) { return '$ ' . number_format((float)$amount, 2); }
    $jalaliMonths = ['حمل', 'ثور', 'جوزا', 'سرطان', 'اسد', 'سنبله', 'میزان', 'عقرب', 'قوس', 'جدی', 'دلو', 'حوت'];
@endphp

<table class="report-table">
    <thead>
        <tr>
            <th>نوع مصرف</th>
            @foreach($jalaliMonths as $month)
                <th class="text-center">{{ $month }}</th>
            @endforeach
            <th class="text-center">مجموع</th>
        </tr>
    </thead>
    <tbody>
        @foreach($matrix as $row)
            <tr>
                <td>{{ $row['category'] }}</td>
                @for($i = 1; $i <= 12; $i++)
                    <td class="currency">{{ fmt($row[$i] ?? 0) }}</td>
                @endfor
                <td class="currency"><strong>{{ fmt($row['total'] ?? 0) }}</strong></td>
            </tr>
        @endforeach
    </tbody>
    <tfoot>
        <tr>
            <td><strong>مجموع</strong></td>
            @for($i = 1; $i <= 12; $i++)
                <td class="currency"><strong>{{ fmt($monthTotals[$i] ?? 0) }}</strong></td>
            @endfor
            <td class="currency"><strong>{{ fmt($grandTotal) }}</strong></td>
        </tr>
    </tfoot>
</table>
@endsection