@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">Trailer Report</h3>
            
                <div class="d-flex flex-wrap align-items-center my-1" id="topheadsection">
                    <h3 class="fw-bold me-5 my-1" id="truckreporthead">Trailer <span class="text-muted">Report</span>
                    </h3>
                    <a id="backbtn"  href="{{ route('assets.trailers.edit',$trailer->ID) }}" class="btn btn-primary btn-sm me-2"><i
                    class="fa fa-arrow-left" aria-hidden="true"></i>Back</a>
                 

                                    
                                    <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);" onclick="window.print()"  id="printBtn">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><a class="dropdown-item" href="{{ route('assets.trailers.export_pdf',$trailer->ID) }}?year={{$cur_year}}" class="btn btn-primary btn-sm me-2">Pdf</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>     
                                        <h3 style="color:green">Maintenance Log</h3>
                                        <hr>    
                                        <div class="row">
                                            <table class="table first-table" width="100%">
                                                <tr>                                                  
                                                   <td><b>Year:</b> {{$trailer->YEAR}}</td>
                                                   <td><b>Status:</b> {{$trailer->STATUS}}</td>
                                                   <td><b>Trailer Number:</b> {{$trailer->TRAILER_ID}}</td> 
                                                   <td><b>Purcahsed Leased:</b> {{$trailer->LEASE_PUR}}</td>
                                                </tr>
                                                <tr>        
                                                    <td style="padding-bottom: 0px;padding-top: 0px;"><b>Copmany / Owner Operator:</b> {{$trailer->OWNER_TYPE}}</td>
                                                    <td style="padding-bottom: 0px;padding-top: 0px;"><b>Purcahsed From:</b> {{$trailer->LEASE_PUR_FROM}}</td>
                                                    <td style="padding-bottom: 0px;padding-top: 0px;"><b>Sold To:</b> {{$trailer->SOLD_TO}}</td> 
                                                    <td style="padding-bottom: 0px;padding-top: 0px;"><b>Purcahsed Date:</b> {{ ($trailer->LEASE_PUR_DATE && $trailer->LEASE_PUR_DATE != '0000-00-00 00:00:00') ?  date('m/d/Y',strtotime($trailer->LEASE_PUR_DATE)) : ''}}</td>                                                   
                                                 <tr>   
                                                   
                                                    <td><b>Sold Date:</b> {{ ($trailer->SOLD_DATE && $trailer->SOLD_DATE != '0000-00-00 00:00:00') ? date('m/d/Y',strtotime($trailer->SOLD_DATE)) : ''}}</td>         
                                                    <td><b>Purchase Amount:</b> {{$trailer->LEASE_PUR_AMT}}</td>
                                                    <td><b>Sold Amount:</b> {{$trailer->SOLD_AMT}}</td>  
                                                    <td></td>                                                 
                                                  </tr>                                            
                                            </table>
                                            @php
                                                    $totalSum = 0;
                                                    $totalSum2 = 0;
                                                @endphp
                                                
                                                @foreach ($vehicle_maintenances as $item) 
                                                    @php
                                                        $arr = [];
                                                        if (!empty($item->service_provider)) {
                                                            $arr = explode(",", $item->service_provider);
                                                        }
                                                        $total = $item->part + $item->labor;
                                                        $totalSum2 += $total;
                                                    @endphp
                                                @endforeach  
                                           
                                                <table class="second-table" width="100%">
                                                    <tr>
                                                        <td> <span style="color:green; font-size: 16px; font-weight: 600;">Total Part Cost: ${{ number_format($sum->total_part, 2) }}</span></td>
                                                        <td><span style="color:green;  font-size: 16px; font-weight: 600; float: right;">Total Maintenance Cost ${{ number_format($totalSum2, 2) }}</span> </td>
                                                    </tr>
                                                    <tr>
                                                        <td><span style="color:green; font-size: 16px; font-weight: 600;">Total Labor Cost: ${{ number_format($sum->total_labour, 2) }}</span></td>
                                                        <td></td>
                                                    </tr>
                                                </table>  
                                           
                                          
                                            <hr>
                                            <div class="row">
                                            <table class="table table-bordered" width="100%">
                                                    <tr style="background: #388DC6;"> 
                                                        <td><b>Month</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
                                                        $repairSubtotals = array_fill(1, 12, 0);
                                                    @endphp

                                                    @foreach ($repairTypes as $repairType)
                                                        <tr>
                                                            <td><b>{{ $repairType->NAME }}</b></td>
                                                            @for ($month = 1; $month <= 12; $month++)
                                                                @php
                                                                    $key = sprintf('%02d-%d', $month, $cur_year);
                                                                    $amount = $repairAmounts[$repairType->NAME][$key] ?? '0'; 
                                                                    $amount = floatval($amount); 
                                                                    $repairSubtotals[$month] += $amount;
                                                                @endphp
                                                                <td data-month="{{ $month }}" data-year="2024">
                                                                    @if($amount > 0) ${{ number_format($amount, 2) }} @endif
                                                                </td>
                                                            @endfor
                                                        </tr>
                                                    @endforeach

                                                    <tr>
                                                        <td style="font-weight: bold; color:red;background:#eee;"><b>Repair Subtotal</b></td>
                                                        @for ($month = 1; $month <= 12; $month++)
                                                            <td style="font-weight: bold; color:red;background:#eee;">
                                                                @if($repairSubtotals[$month] > 0) ${{ number_format($repairSubtotals[$month], 2) }} @endif
                                                            </td>
                                                        @endfor
                                                    </tr>
                                                      <td colspan="13" style="background: #ddd;"><b>EXPENSE TYPE</b></td>
                                                    </tr>
                                                    @php
                                                        $expenseSubtotals = array_fill(1, 12, 0);
                                                    @endphp
                                                    @foreach ($expenseTypes as $expenseType)
                                                        <tr>
                                                            <td><b>{{ $expenseType->NAME }}</b></td>
                                                            @for ($month = 1; $month <= 12; $month++)
                                                                @php
                                                                    $key = sprintf('%02d-%d', $month, $cur_year); 
                                                                    $amount = $expenseAmounts[$expenseType->NAME][$key] ?? 0;
                                                                    $expenseSubtotals[$month] += $amount;
                                                                @endphp
                                                                <td>@if(!empty($amount)) ${{ number_format($amount,2) }} @endif</td>
                                                            @endfor
                                                        </tr>
                                                    @endforeach
                                                    <tr>
                                                                <td  style="font-weight: bold; color:red;background:#eee;"><b>Expense Subtotal</b></td>
                                                                @for ($month = 1; $month <= 12; $month++)
                                                                    <td style="font-weight: bold; color:red;background:#eee;">
                                                                        @if($expenseSubtotals[$month] > 0) ${{ number_format($expenseSubtotals[$month], 2) }} @endif
                                                                    </td>
                                                                @endfor
                                                            </tr>
                                                    <tr style="background: #ddd;">
                                                        <td><b>Total Monthly Cost</b></td>
                                                        @for ($month = 1; $month <= 12; $month++)
                                                            <td style="color:green"><b>${{ number_format($monthlyTotals[$month], 2) }}</b></td>
                                                        @endfor
                                                    </tr>
                                                </table>
                                            </div>
                                            <h3 style="color:green">Vehicle Maintenance Log</h3>
                                            <hr>
                                            <table class="table table-bordered" width="100%">
                                                <thead>
                                                    <tr  style="background: #388DC6;">
                                                        <th>Description</th>
                                                        <th>Status</th>
                                                        <th>Date</th>
                                                        <th>Odometer</th>
                                                        <th>Type</th>
                                                        <th>Vendor</th>
                                                        <th>Part</th>                                                        
                                                        <th>Labor Cost</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><a href="{{route('assets.trailers.edit',$trailer->ID)}}?issue_id={{$item->issue_id}}#kt_stats_widget_16_tab_6" style="text-decoration: none">{{$item->description}}</a></td>
                                                        <td><a href="{{route('assets.trailers.edit',$trailer->ID)}}?issue_id={{$item->issue_id}}#kt_stats_widget_16_tab_6" style="color:{{$item->status=='Closed' ? 'red':'green'}};text-decoration: none">{{$item->status}}</a></td>
                                                        <td><a href="{{route('assets.trailers.edit',$trailer->ID)}}?issue_id={{$item->issue_id}}#kt_stats_widget_16_tab_6" style="text-decoration: none">{{date('m/d/Y',strtotime($item->date))}}</a></td>
                                                        <td>{{$item->odometer}}</td>
                                                        <td>
                                                           
                                                        {{$item->repair_name}}
                                                        </td>
                                                        <td>{{$item->vendorname}}</td>
                                                        <td>{{$item->part}}</td>
                                                        
                                                        <td>{{$item->labor}}</td>
                                                      
                                                        <td>${{number_format($total, 2)}}</td>
                                                    </tr>
                                                @endforeach
                                                
                                                <tr style="background: #ddd;">
                                                    <td><b class="p-1">Total</bb</td>
                                                    <td></td>
                                                    <td></td>
                                                    <td></td>
                                                    <td></td>
                                                    <td></td>
                                                    <td></td>
                                                    <td></td>                                                  
                                                    
                                                    <td><b style="color:green">${{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'
            }
        });
    

document.getElementById('year').addEventListener('change', function() {
        const selectedYear = this.value;
   
        var year = selectedYear; // This should be a JavaScript variable
        var baseUrl = "{{ route('assets.trailers.report', $trailer->ID) }}";
        var fullUrl = baseUrl + "?year=" + encodeURIComponent(year);
        location.href = fullUrl;
});
    </script>
@endsection