@extends('layouts.master')
<style>
    .table-bordered td, .table-bordered th{ border:1px solid #00000042 !important; font-size: 13px !important; }
    .first-table td, .first-table th{ font-size: 13px !important; }
    .form-control { appearance: auto  !important; }
    @media print {
            #kt_header {
                display: none;
            }

            #kt_footer {
                display: none;
            }

            #backbtn,
            #yearDropdown,
            #dropdownMenuButton1,
            #printandyeardropdown,
            #truckreporthead {
                display: none;
            }
        }
   
</style>
@section('content')
    <div class="content d-flex flex-column flex-column-fluid" id="kt_content">
        <div id="kt_content_container" class="container-xxl">
            <div class="d-flex flex-wrap flex-stack pb-7">
            <h3 class="text-muted" id="pdfhead" style="display:none">Customer Maintenance Report</h3>
                <div class="d-flex flex-wrap align-items-center my-1"  id="topheadsection">
                    <h3 class="fw-bold me-5 my-1">Customer Maintenance <span class="text-muted">Report</span>
                    <a id="backbtn" href="{{ route('assets.expense.index') }}" class="btn btn-primary btn-sm me-2"><i
                    class="fa fa-arrow-left" aria-hidden="true"></i>Back</a>
                
                    </h3>
                                <div class="row" id="yearDropdown">
                                    <select id="year" class="form-control ms-4" style="padding: 7px;">
                                            <option value="">Please select</option>
                                            @php
                                                $currentYear = date('Y'); 
                                                $startYear = 2019; 
                                                $selectedYear = request()->get('year') ?? $currentYear; 
                                            @endphp
                                            @for($year = $currentYear; $year >= $startYear; $year--)
                                                <option value="{{ $year }}" @if($selectedYear == $year) selected @endif>{{ $year }}</option>
                                            @endfor
                                        </select>
                                  </div>
                                  <a class="btn btn-primary btn-sm me-2 ms-10" href="javascript:void(0);" id="printButton">Print</a>
                                  <button class="btn btn-primary dropdown-toggle" type="button" id="dropdownMenuButton1" data-bs-toggle="dropdown" aria-expanded="false" style="padding: 7px 10px;">
                                       Export
                                    </button>
                                    <ul class="dropdown-menu" aria-labelledby="dropdownMenuButton1"  id="printandyeardropdown">
                                    <li></li>                                      
                                        <li><a class="dropdown-item" href="{{route('assets.trucks.allTruckReportExport')}}?year={{$cur_year}}" class="btn btn-primary btn-sm me-2">Pdf</a> </li>
                                        <li><a class="dropdown-item" href="{{route('assets.trucks.allTruckReportCsv')}}?year={{$cur_year}}" class="btn btn-primary btn-sm me-2">Csv</a> </li>
                                        <li><a class="dropdown-item" href="{{route('assets.trucks.allTruckReportExcel')}}?year={{$cur_year}}" class="btn btn-primary btn-sm me-2">Export</a> </li>
                                    </ul>
                    <h3 class="fw-bold me-5 my-1"></h3>
                </div>
            </div>
            <div class="card card-flush">
                <div class="card-body">
                    <div class=" pb-lg-11 pb-7">
                        <div class="container">                       
                                <div class="modal-body">
                                        <div  style="margin:0 auto;text-align:center;"> <img alt="Logo" src="{{ asset('images/main_logo.png') }}" class="h-45px logo" /> <span  style="font-weight: bold; font-size: 20px; margin-top: 9px;">{{ getAuthCompanyName() }} </span></div>     
                                      
                                        <div class="row">  
                                        @php
                                            $monthlyTotals = array_fill(1, 12, 0); 
                                            $gtotal = 0;
                                        @endphp                                          
                                        
                                        <!-- <h3 style="color:green">Truck Maintenance Report</h3> -->
                                        <div style="display: flex; justify-content: space-between; align-items: center; padding: 10px;">
                                            <h3 style="margin: 0;">Customers Maintenance Report</h3>
                                            <h3 style="color: {{ $gtotal > 0 ? 'green' : ($gtotal < 0 ? 'red' : 'black') }}; margin: 0;">
                                                <!-- Grand Total Maintenance: ${{ number_format($gtotal, 2) }} -->
                                            </h3>
                                        </div>
                                            <hr>
                                            <div class="row">
                                            <table class="table table-bordered" width="100%">
    <tr style="background: #388DC6;">
        <td><b>Customer Name</b></td>
        @for ($month = 1; $month <= 12; $month++)
            <td data-month="{{ $month }}"><b>{{ \Carbon\Carbon::createFromDate($cur_year, $month, 1)->format('M-Y') }}</b></td>
        @endfor
    </tr>

    @php
        $monthlyTotals = array_fill(1, 12, 0); // Initialize monthly totals
        $gtotal = 0; // Initialize grand total
    @endphp

    @foreach ($customers as $customer)
        <tr>
            <td><b>{{ $customer->NAME }}</b></td>
            @for ($month = 1; $month <= 12; $month++)
                @php
                    // Dynamically get the load rate sum for each month
                    $loadRateSum = $customer->{'load_rate_sum_' . strtolower(\Carbon\Carbon::createFromDate($cur_year, $month, 1)->format('M'))} ?? 0;
                    $monthlyTotals[$month] += $loadRateSum; // Add to monthly total
                @endphp
                <td style="color: 
                    {{ $loadRateSum > 0 ? 'green' : ($loadRateSum < 0 ? 'red' : 'black') }}">
                    ${{ number_format($loadRateSum, 2) }}
                </td>
            @endfor
        </tr>
    @endforeach

    <tr style="background: #c3b9b9;">
        <td><b>Total</b></td>
        @for ($month = 1; $month <= 12; $month++)
            @php
                $gtotal += $monthlyTotals[$month]; // Update grand total
            @endphp
            <td style="color: 
                {{ $monthlyTotals[$month] > 0 ? 'green' : ($monthlyTotals[$month] < 0 ? 'red' : 'black') }}">
                <b>${{ number_format($monthlyTotals[$month], 2) }}</b>
            </td>
        @endfor
    </tr>

    <tr style="background: #c3b9b9;">
        <td colspan="13">
            <b>
                <h4 style="color: 
                    {{ $gtotal > 0 ? 'green' : ($gtotal < 0 ? 'red' : 'black') }}">
                    Grand Total Load Rate: ${{ number_format($gtotal, 2) }}
                </h4>
            </b>
        </td>
    </tr>
</table>


                                            </div>                                   
                                                                                  
                                        </div>
                                </div>                           
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>


@endsection()
@section('script')
<script>
         document.getElementById('printButton').addEventListener('click', function() {
            window.print();
        });
document.getElementById('year').addEventListener('change', function() {
        const selectedYear = this.value;
       
        var year = selectedYear; 
        var baseUrl = "{{ route('assets.customers.topCustomerReport') }}";
        var fullUrl = baseUrl + "?year=" + encodeURIComponent(year);
        location.href = fullUrl;
});

    </script>

  
@endsection