@extends('layouts.master')

@section('content')
    <div class="container-fluid py-4">
        <div class="card">
            <div class="card-header d-flex justify-content-between align-items-center">
                <h4 class="card-title">Yearly Gallons Report ({{ $year }})</h4>
                <form class="d-flex" method="GET" action="{{ route('yearlyReports.index') }}">
                    <input type="number" name="year" value="{{ $year }}" class="form-control form-control-sm me-2" min="2019" max="2099" style="width:110px;" />
                    <button class="btn btn-primary btn-sm">Run</button>
                </form>
            </div>
            <div class="card-body table-responsive">
                <table class="table table-bordered table-hover table-striped">
                    <thead>
                        <tr>
                            <th>Month</th>
                            <th>#</th>
                            <th>Total Gallons</th>
                            <th>Out of Network</th>
                            <th>Pilot One9-Express</th>
                            <th>Total OUT</th>
                            <th>Total Net</th>
                            <th>%</th>
                            <th>Pilot</th>
                            <th>TA</th>
                            <th>Loves</th>
                            <th>+/-</th>
                            <th>Pilot Rebate</th>
                            <th>TA Rebate</th>
                            <th>Loves Rebate</th>
                        </tr>
                    </thead>
                    <tbody>
                        @foreach($monthly as $row)
                            <tr>
                                <td>{{ $row['month'] }}</td>
                                <td>{{ $row['count'] }}</td>
                                <td>{{ number_format($row['total_gallons'],2) }}</td>
                                <td>{{ number_format($row['out_network'],2) }}</td>
                                <td>{{ number_format($row['one9_express'],2) }}</td>
                                <td>{{ number_format($row['total_out'],2) }}</td>
                                <td>{{ number_format($row['total_net'],2) }}</td>
                                <td>{{ number_format($row['percent'],2) }}%</td>
                                <td>{{ number_format($row['pilot'],2) }}</td>
                                <td>{{ number_format($row['ta'],2) }}</td>
                                <td>{{ number_format($row['loves'],2) }}</td>
                                <td>{{ number_format($row['plus_minus'],2) }}</td>
                                <td>${{ number_format($row['pilot_rebate'],2) }}</td>
                                <td>${{ number_format($row['ta_rebate'],2) }}</td>
                                <td>${{ number_format($row['loves_rebate'],2) }}</td>
                            </tr>
                        @endforeach
                    </tbody>
                    <tfoot>
                        @php
                            $monthsCount = 12; // ya count($monthly)
                            $yearTotals['avg_count'] = $yearTotals['count'] / $monthsCount;
                            $yearTotals['avg_total_gallons'] = $yearTotals['total_gallons'] / $monthsCount;
                            $yearTotals['avg_out_network'] = $yearTotals['out_network'] / $monthsCount;
                            $yearTotals['avg_one9_express'] = $yearTotals['one9_express'] / $monthsCount;
                            $yearTotals['avg_total_out'] = $yearTotals['total_out'] / $monthsCount;
                            $yearTotals['avg_total_net'] = $yearTotals['total_net'] / $monthsCount;
                            $yearTotals['avg_percent'] = $yearTotals['percent']; // already avg type hai
                            $yearTotals['avg_pilot'] = $yearTotals['pilot'] / $monthsCount;
                            $yearTotals['avg_ta'] = $yearTotals['ta'] / $monthsCount;
                            $yearTotals['avg_loves'] = $yearTotals['loves'] / $monthsCount;
                            $yearTotals['avg_plus_minus'] = $yearTotals['plus_minus'] / $monthsCount;
                            $yearTotals['avg_pilot_rebate'] = $yearTotals['pilot_rebate'] / $monthsCount;
                            $yearTotals['avg_ta_rebate'] = $yearTotals['ta_rebate'] / $monthsCount;
                            $yearTotals['avg_loves_rebate'] = $yearTotals['loves_rebate'] / $monthsCount;
                        @endphp
                        <tr class="fw-bold">
                            <td>Average</td>
                            <td>{{ number_format($yearTotals['avg_count'],2) }}</td>
                            <td>{{ number_format($yearTotals['avg_total_gallons'],2) }}</td>
                            <td>{{ number_format($yearTotals['avg_out_network'],2) }}</td>
                            <td>{{ number_format($yearTotals['avg_one9_express'],2) }}</td>
                            <td>{{ number_format($yearTotals['avg_total_out'],2) }}</td>
                            <td>{{ number_format($yearTotals['avg_total_net'],2) }}</td>
                            <td>{{ number_format($yearTotals['avg_percent'],2) }}%</td>
                            <td>{{ number_format($yearTotals['avg_pilot'],2) }}</td>
                            <td>{{ number_format($yearTotals['avg_ta'],2) }}</td>
                            <td>{{ number_format($yearTotals['avg_loves'],2) }}</td>
                            <td>{{ number_format($yearTotals['avg_plus_minus'],2) }}</td>
                            <td>${{ number_format($yearTotals['avg_pilot_rebate'],2) }}</td>
                            <td>${{ number_format($yearTotals['avg_ta_rebate'],2) }}</td>
                            <td>${{ number_format($yearTotals['avg_loves_rebate'],2) }}</td>
                        </tr>
                    </tfoot>
                </table>
            </div>
        </div>
    </div>
@endsection