@extends('layouts.master')

@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">Vendor Report</h3>
                <div class="d-flex flex-wrap align-items-center my-1"  id="topheadsection">
                    <h3 class="fw-bold me-5 my-1">Vendor <span class="text-muted">Report</span>
                    </h3>
                    <a href="{{ route('assets.vendors.edit',$vendor->VENDOR_ID) }}" class="btn btn-primary btn-sm me-2"><i
                    class="fa fa-arrow-left" aria-hidden="true"></i>Back</a>
                    <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>     
                                        <h3>Maintenance Log</h3>
                                        <hr>    
                                        <div class="row">
                                            <table class="table" width="100%">
                                                <tr>                                                  
                                                   <td><b>Name:</b> {{$vendor->NAME}}</td>
                                                   <td><b>Address:</b> {{$vendor->ADDRESS_1}}</td>
                                                   <td><b>Address 2:</b> {{$vendor->ADDRESS_2}}</td>
                                                  
                                                  
                                                </tr>
                                                <tr>        
                                                    <td><b>City:</b> {{$vendor->CITY}}</td> 
                                                    <td><b>State:</b> {{$vendor->PROVINCE}}</td>
                                                    <td><b>Zip:</b> {{$vendor->POSTAL_CODE}}</td>
                                                 </tr>
                                                                                         
                                            </table>
                                           
                                            <h3>Maintenance Cost Summary</h3>
                                            <hr>
                                            <div class="row">
                                                   <table class="table table-bordered" width="100%">
                                                <tr>
                                                    <td><b>Month</b></td>
                                                    @for ($month = 1; $month <= 12; $month++)
                                                        <td><b>{{ \Carbon\Carbon::createFromDate(2024, $month, 1)->format('M-Y') }}</b></td>
                                                    @endfor  
                                                </tr>
                                                <tr>
                                                    <td><b>REPAIR TYPE</b></td>
                                                    @for ($month = 1; $month <= 12; $month++)
                                                        <td></td>
                                                    @endfor  
                                                </tr>
                                                @foreach ($repairTypes as $repairType)
                                                    <tr>
                                                        <td><b>{{ $repairType->NAME }}</b></td>
                                                        @for ($month = 1; $month <= 12; $month++)
                                                            @php
                                                                $key = sprintf('%02d-%d', $month, 2024); // Adjust year if necessary
                                                                $amount = $repairAmounts[$repairType->NAME][$key] ?? '';
                                                            @endphp
                                                            <td>@if(!empty($amount))  ${{ number_format($amount,2) }} @endif</td>
                                                        @endfor
                                                    </tr>
                                                @endforeach
                                                <tr>
                                                    <td><b>EXPENSE TYPE</b></td>
                                                    @for ($month = 1; $month <= 12; $month++)
                                                        <td></td>
                                                    @endfor  
                                                </tr>
                                                @foreach ($expenseTypes as $expenseType)
                                                    <tr>
                                                        <td><b>{{ $expenseType->NAME }}</b></td>
                                                        @for ($month = 1; $month <= 12; $month++)
                                                            @php
                                                                $key = sprintf('%02d-%d', $month, 2024); // Adjust year if necessary
                                                                $amount = $expenseAmounts[$expenseType->NAME][$key] ?? '';
                                                            @endphp
                                                            <td>@if(!empty($amount)) ${{ number_format($amount,2) }} @endif</td>
                                                        @endfor
                                                    </tr>
                                                @endforeach
                                                <tr>
                                                    <td><b>TOTAL MONTHLY COST</b></td>
                                                    @for ($month = 1; $month <= 12; $month++)
                                                        <td><b>${{ number_format($monthlyTotals[$month], 2) }}</b></td>
                                                    @endfor
                                                </tr>
                                            </table>
                                            </div>
                                            <h3>Vehicle Maintenance Log</h3>
                                            <hr>
                                            <table class="table table-bordered" width="100%">
                                                <thead>
                                                    <tr>
                                                        <th>Date</th>
                                                        <th>Description</th>
                                                        <th>Odometer</th>
                                                        <th>Service Provider</th>
                                                        <th>Mechanic</th>
                                                        <th>Part</th>
                                                        <th>Next Service Due</th>
                                                        <th>Material Cost</th>
                                                        <th>Labor Cost</th>
                                                        <th>Warranty</th>
                                                        <th>Total Cost</th>
                                                    </tr>
                                                </thead>
                                                
                                                @php
                                                    $totalSum = 0;
                                                @endphp
                                                
                                                @foreach ($vehicle_maintenances as $item) 
                                                    @php
                                                        $arr = [];
                                                        if (!empty($item->service_provider)) {
                                                            $arr = explode(",", $item->service_provider);
                                                        }
                                                        $total = $item->part + $item->labor;
                                                        $totalSum += $total;
                                                    @endphp

                                                    <tr>
                                                        <td>{{ date('m/d/Y',strtotime($item->date))}}</td>
                                                        <td>{{$item->description}}</td>
                                                        <td>{{$item->odometer}}</td>
                                                        <td>
                                                            @foreach($serviceCode as $key => $serviceCodes)
                                                                @if(in_array($serviceCodes->SERVICEID, $arr))
                                                                    {{$serviceCodes->Description}} 
                                                                @endif
                                                            @endforeach
                                                            {{$item->service_provider}}
                                                        </td>
                                                        <td>{{$item->vendorname}}</td>
                                                        <td>{{$item->part}}</td>
                                                        <td></td>
                                                        <td></td>
                                                        <td>{{$item->labor}}</td>
                                                        <td></td>
                                                        <td>${{number_format($total, 2)}}</td>
                                                    </tr>
                                                @endforeach
                                                
                                                <tr>
                                                    <td><b>Total</b></td>
                                                    <td></td>
                                                    <td></td>
                                                    <td></td>
                                                    <td></td>
                                                    <td></td>
                                                    <td></td>
                                                    <td></td>
                                                    <td></td>
                                                    <td></td>
                                                    <td><b>${{number_format($totalSum, 2)}}</b></td>
                                                </tr>
                                            </table>
                                                                                  
                                        </div>
                                </div>                           
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
@endsection()
@section('script')
    <script>
        $('.datetimepicker').daterangepicker({
            timePicker: false ,
            singleDatePicker: true,
            locale: {
                format: 'MM/DD/YYYY'
            }
        });
    </script>
@endsection