@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">Truck Maintenance & Expense Report</h3>
                <div class="d-flex flex-wrap align-items-center my-1"  id="topheadsection">
                    <h3 class="fw-bold me-5 my-1">Truck Maintenance & Expense <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">
                                @php
                                                $currentYear = date('Y'); 
                                                $startYear = 2019; 
                                                $selectedYear = request()->get('year') ?? $currentYear; 
                                            @endphp
                                    <select id="year" class="form-control ms-4" style="padding: 7px; display:none">
                                            <option value="">Please select</option>
                                           
                                            @for($year = $currentYear; $year >= $startYear; $year--)
                                                <option value="{{ $year }}" @if($selectedYear == $year) selected @endif>{{ $year }}</option>
                                            @endfor
                                        </select>

                                        <form action="{{ route('assets.trucks.allTruckReportnew') }}" class="d-flex align-items-center mt-3" id="searchFrom">
                                            <div id="range" class="me-2"
                                                style="background: #fff; cursor: pointer; padding: 5px 10px; border: 1px solid #ccc; width: 151px">
                                                <i class="fa fa-calendar"></i>&nbsp;
                                                <span></span> <i class="fa fa-caret-down"></i>
                                            </div>
                                            <input type="hidden" class="form-control sm" name="start_date" id="start_date">
                                            <input type="hidden" class="form-control sm" name="end_date" id="end_date">
                                            <button type="submit" class="btn btn-primary btn-sm me-2">Search</button>
                                            <a class="btn btn-primary btn-sm me-2 ms-10" href="javascript:void(0);" id="printButton">Print</a>
                                            <a href="{{route('assets.trucks.allTruckReportnew')}}?start_date={{ date('Y-m-d', strtotime('first day of this month')) }}&end_date={{ date('Y-m-d', strtotime('last day of this month')) }}" class="btn btn-primary btn-sm me-2">Clear</a>
                                        </form>
                                  </div>
                                
                                  <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.allTruckReportNewPdf')}}?start_date={{$startDate}}&end_date={{$endDate}}" class="btn btn-primary btn-sm me-2">Pdf</a> </li>
                                        <li><a class="dropdown-item" href="{{route('assets.trucks.allTruckReportNewCsv')}}?start_date={{$startDate}}&end_date={{$endDate}}" class="btn btn-primary btn-sm me-2">Csv</a> </li>
                                        <li><a class="dropdown-item" href="{{route('assets.trucks.allTruckReportNewExcel')}}?start_date={{$startDate}}&end_date={{$endDate}}" 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">
                                      @php
                                $startdate = request('start_date') ?: date('Y-m-01'); 
                                $enddate = request('end_date') ?: date('Y-m-t'); 

                                    // Format dates using PHP's DateTime class
                                    $formattedStartDate = $startdate ? (new DateTime($startdate))->format('m/d/Y') : '';
                                    $formattedEndDate = $enddate ? (new DateTime($enddate))->format('m/d/Y') : '';
                                @endphp
                                        <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">                                            
                                        
                                        <!-- <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;">Truck Maintenance & Expense Report</h3>
                                            <h3 style="color: {{ $gtotal > 0 ? 'green' : ($gtotal < 0 ? 'red' : 'black') }}; margin: 0;">
                                                Grand Total: ${{ number_format($gtotal, 2) }}
                                            </h3>
                                        </div>
                                            <hr>
                                            <div class="row">
                                            <table class="table table-bordered" width="100%">
                                                    @php
                                                        // Initialize DateTime objects for start and end dates
                                                        $start = new DateTime($startDate);
                                                        $end = new DateTime($endDate);

                                                        // Calculate the number of months between start and end dates
                                                        $monthDiff = (($end->format('Y') - $start->format('Y')) * 12) + ($end->format('m') - $start->format('m'));
                                                     
                                                        // Initialize an array to hold monthly totals
                                                        $monthlyTotals = [];
                                                        $gtotal = 0;
                                                    @endphp

                                                    <!-- Table Header -->
                                                    <tr style="background: #388DC6;">
                                                        <td class="text-gray-500"><b>Unit Id</b></td>
                                                        
                                                        @for ($i = 0; $i <= $monthDiff; $i++)
                                                            <th data-month="{{ $start->format('m-Y') }}" class="text-gray-500">
                                                                <b>{{ $start->format('M-Y') }}</b>
                                                            </th>
                                                            @php
                                                                // Initialize monthly total for this month
                                                                $monthlyTotals[$start->format('m-Y')] = 0;
                                                                
                                                                // Move to the next month
                                                                $start->modify('+1 month');
                                                            @endphp
                                                        @endfor

                                                        <th class="text-gray-500"><b>Total</b></th>
                                                    </tr>

                                                    <!-- Data Rows -->
                                                    @foreach ($trucks as $truck)
                                                        @php
                                                            $total = 0;
                                                            $start = new DateTime($startDate);  // Reset start date for each row
                                                        @endphp

                                                        <tr>
                                                            <td>
                                                                <a href="{{ route('assets.trucks.report', $truck->TRUCK_ID) }}?year={{$cur_year}}" target="_blank">
                                                                    <b>{{ $truck->UNIT_ID }}</b>
                                                                </a>
                                                            </td>

                                                            @for ($i = 0; $i <= $monthDiff; $i++)
                                                                @php
                                                                    $monthKey = $start->format('m-Y');
                                                                    $month = (int)$start->format('m');
                                                                    $year = (int)$start->format('Y');
                                                                  
                                                                    // Get the amounts for this truck and month
                                                                    $repairAmount = $repairAmounts[$truck->TRUCK_ID][$month] ?? 0;
                                                                    $expenseAmount = $expenseAmounts[$truck->TRUCK_ID][$month] ?? 0;
                                                                    $totalAmount = $repairAmount + $expenseAmount;

                                                                    // Add to monthly and row totals
                                                                    $monthlyTotals[$monthKey] += $totalAmount;
                                                                    $total += $totalAmount;
                                                                @endphp

                                                                <td style="color: 
                                                                    {{ $totalAmount > 0 ? 'green' : ($totalAmount < 0 ? 'red' : 'black') }}">
                                                                    ${{ number_format($totalAmount, 2) }}
                                                                </td>

                                                                @php
                                                                    // Move to the next month
                                                                    $start->modify('+1 month');
                                                                @endphp
                                                            @endfor

                                                            <td style="color: {{ $total > 0 ? 'green' : ($total < 0 ? 'red' : 'black') }}">
                                                                ${{ number_format($total, 2) }}
                                                            </td>
                                                        </tr>
                                                    @endforeach

                                                    <!-- Total Row -->
                                                    <tr style="background:#c3b9b9">
                                                        <td><b>Total</b></td>

                                                        @php
                                                            $start = new DateTime($startDate);  // Reset start date for totals row
                                                        @endphp

                                                        @for ($i = 0; $i <= $monthDiff; $i++)
                                                            @php
                                                                $monthKey = $start->format('m-Y');
                                                                $gtotal += $monthlyTotals[$monthKey];
                                                            @endphp

                                                            <td style="color: 
                                                                {{ $monthlyTotals[$monthKey] > 0 ? 'green' : ($monthlyTotals[$monthKey] < 0 ? 'red' : 'black') }}">
                                                                <b>${{ number_format($monthlyTotals[$monthKey], 2) }}</b>
                                                            </td>

                                                            @php
                                                                // Move to the next month
                                                                $start->modify('+1 month');
                                                            @endphp
                                                        @endfor

                                                        <td style="color: {{ $gtotal > 0 ? 'green' : ($gtotal < 0 ? 'red' : 'black') }}">
                                                            <b>${{ number_format($gtotal, 2) }}</b>
                                                        </td>
                                                    </tr>

                                                    <!-- Grand Total Row -->
                                                    <tr style="background:#c3b9b9">
                                                        <td colspan="{{ $monthDiff + 2 }}">
                                                            <b>
                                                                <h4 style="color: 
                                                                        {{ $gtotal > 0 ? 'green' : ($gtotal < 0 ? 'red' : 'black') }}">
                                                                    Grand Total: ${{ number_format($gtotal, 2) }}
                                                                </h4>
                                                            </b>
                                                        </td>
                                                        <td></td>
                                                    </tr>
                                                </table>



                                            </div>                                   
                                                                                  
                                        </div>
                                        
                                        

                                        <div class="chart mt-10">
                                            <h3 style="margin: 0;">Maintenance & Expense By Truck</h3>
                                            <hr>
                                            <canvas id="truckChart" width="400" height="200"></canvas>
                                        </div>

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


@endsection()
@section('script')
<script type="text/javascript" src="//cdnjs.cloudflare.com/ajax/libs/Chart.js/2.1.2/Chart.min.js"></script>

<script>

$(function() {
            var start = "{{ $startDate ? \Carbon\Carbon::parse($startDate)->format('Y-m-d') : 'moment()' }}";
            var end = "{{ $endDate ? \Carbon\Carbon::parse($endDate)->format('Y-m-d') : 'moment()' }}";

            function cb(start, end) {
                $('#range span').html(start.format('MMMM D, YYYY') + ' - ' + end.format('MMMM D, YYYY'));
                $("#start_date").val(start.format('YYYY-MM-DD'));
                $("#end_date").val(end.format('YYYY-MM-DD'));
            }

            $('#range').daterangepicker({
                startDate: start ? moment(start) : moment(),
                endDate: end ? moment(end) : moment(),
                ranges: {
                    'Today': [moment(), moment()],
                    'Yesterday': [moment().subtract(1, 'days'), moment().subtract(1, 'days')],
                    'Last 7 Days': [moment().subtract(6, 'days'), moment()],
                    'Last 30 Days': [moment().subtract(29, 'days'), moment()],
                    'This Month': [moment().startOf('month'), moment().endOf('month')],
                    'Last Month': [moment().subtract(1, 'month').startOf('month'), moment().subtract(1,
                        'month').endOf('month')]
                }
            }, cb);

            cb(moment(start), moment(end));
        });

     document.addEventListener("DOMContentLoaded", function() {
    const yearElement = document.getElementById('year');
    const printButton = document.getElementById('printButton');

    if (yearElement) {
        yearElement.addEventListener('change', function() {
            const selectedYear = this.value;
            const baseUrl = "{{ route('assets.loads.allLoadsMonthReport') }}";
            const fullUrl = baseUrl + "?year=" + encodeURIComponent(selectedYear);
            location.href = fullUrl;
        });
    }

    if (printButton) {
        printButton.addEventListener('click', function() {
            window.print();
        });
    }
});
         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.trucks.allTruckReport') }}";
        var fullUrl = baseUrl + "?year=" + encodeURIComponent(year);
        location.href = fullUrl;
});
    const truckData = @json($trucks);  
    const months = [...Array(12).keys()].map(i => i + 1);  
    
    const chartData = {
        labels: truckData.map(truck => truck.UNIT_ID),  
        datasets: [{
            label: 'Maintenance & Expense Costs',
            data: truckData.map(truck => {
                return months.reduce((sum, month) => {
                    const repairAmount = @json($repairAmounts)[truck.TRUCK_ID]?.[month] ?? 0;
                    const expenseAmount = @json($expenseAmounts)[truck.TRUCK_ID]?.[month] ?? 0;
                    return sum + repairAmount + expenseAmount;
                }, 0);
            }),
           backgroundColor: '#0073b7',
            // borderColor: 'rgba(75, 192, 192, 1)',
            borderWidth: 1
        }]
    };

    const ctx = document.getElementById('truckChart').getContext('2d');
    new Chart(ctx, {
        type: 'bar',
        data: chartData,
        options: {
            responsive: true,
            scales: {
                x: {
                    beginAtZero: true
                }
            }
        }
    });

   
    </script>

  
@endsection