@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">Driver 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"  id="truckreporthead">Driver 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">
                        <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><a class="dropdown-item" href="{{ route('assets.trucks.driverpay_export_pdf') }}?year={{$cur_year}}" class="btn btn-primary btn-sm me-2">Pdf</a> </li>
                        <li><a class="dropdown-item" href="{{ route('assets.trucks.allDriverReportCsv') }}?year={{$cur_year}}" class="btn btn-primary btn-sm me-2">Csv</a> </li>
                        <li><a class="dropdown-item" href="{{ route('assets.trucks.allDriverReportExcel') }}?year={{$cur_year}}" class="btn btn-primary btn-sm me-2">Excel</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');

                                                $monthYear = (new DateTime($startdate))->format('Y');
                                            @endphp

                                            <div style="margin:0 auto;text-align:center;">
                                                <h2>{{ 'Driver Maintenance & Expense Report' }}  ({{ request('year') ? request('year') : $monthYear }})</h2>

                                            </div>
                                        <div  style="margin:0 auto;text-align:center;">
                                         <!-- <img alt="Logo" src="{{ asset('images/main_logo.png') }}" class="h-45px logo" /> -->
                                          <h3>{{ getAuthCompanyName() }}</h3>
                                           <span> {{ getAuthCarrierInfo()->BILL_TO }}</span>
                                        </div>
                                       <table width="100%" cellpadding="0" cellspacing="0" style="margin-bottom:10px; border: none; border-collapse:collapse; margin-bottom:5px;">
                                <tr>
                                    <td style="text-align:left; font-size:16px;border:none;">
                                        {{ date('m/d/Y h:i A') }}
                                    </td>

                                    <td style="text-align:right; font-size:16px;border:none;">
                                        <strong>
                                            Grand Total:
                                            <span style="color: {{ ($gtotal ?? 0) > 0 ? 'green' : 'red' }};">
                                                ${{ number_format($gtotal, 2) }}
                                            </span>
                                        </strong>
                                    </td>
                                </tr>
                            </table>
                                    <div class="row">

                                        <!-- <h3 style="color:green">Driver Maintenance & Expense Report</h3> -->


                                            <hr>
                                            <div class="row">
                                                <table class="table table-bordered" width="100%">
                                                    <tr style="background: #388DC6;">
                                                        <th class="text-gray-500"><b>Driver Name</b></th>
                                                        @for ($month = 1; $month <= 12; $month++)
                                                            <th data-month="{{ $month }}" class="text-gray-500"><b > {{ \Carbon\Carbon::createFromDate($cur_year, $month, 1)->format('M') }}</b></th>
                                                        @endfor
                                                        <th class="text-gray-500"><b >Total</b></th>
                                                    </tr>

                                                    @php
                                                        $monthlyTotals = array_fill(1, 12, 0);
                                                        $gtotal = 0;
                                                    @endphp

                                                    @foreach ($drivers as $driver)
                                                    @php $total = 0; @endphp
                                                        <tr>
                                                            <td><a target="_blank" href="{{ route('assets.drivers.edit', ['driverId' => $driver->DRIVER_ID]) }}"><b class="">{{ strtoupper($driver->FIRST_NAME) }} {{ strtoupper($driver->LAST_NAME) }}</b></a></td>
                                                            @for ($month = 1; $month <= 12; $month++)
                                                            @php
                                                                $expenseAmount = $expenseAmounts[$driver->DRIVER_ID][$month] ?? 0;
                                                                $monthlyTotals[$month] += $expenseAmount;
                                                                $color = $expenseAmount > 0 ? 'green' : ($expenseAmount < 0 ? 'red' : '#000');
                                                                $total += $expenseAmount;

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

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

                                                </table>

                                            </div>

                                        </div>
                                        <div class="row mt-5">
                                            @if(!empty($chartImage))
                                                <div style="margin-bottom:15px; display:none;">
                                                    <img src="{{ $chartImage }}" style="width:100%; max-height:350px;">
                                                </div>
                                            @else
                                            <div id="monthlyDriverExpenseChart" style="height: 420px; width: 100%;"></div>
                                            @endif
                                            @php
                                                $monthNames = ["Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"];
                                            @endphp
                                        </div>
                                </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>





@endsection()
@section('script')
<script>
document.getElementById('year').addEventListener('change', function() {
        const selectedYear = this.value;

        var year = selectedYear;
        var baseUrl = "{{ route('assets.trucks.allDriverReport') }}";
        var fullUrl = baseUrl + "?year=" + encodeURIComponent(year);
        location.href = fullUrl;
});
        document.getElementById('printButton').addEventListener('click', function() {
            window.print();
        });
    </script>

<script src="https://canvasjs.com/assets/script/canvasjs.min.js"></script>
<script>

window.onload = function () {

    var chartData = [];

    @foreach ($drivers as $driver)
        chartData.push({
            type: "stackedColumn",
            name: @json(strtoupper($driver->FIRST_NAME . ' ' . $driver->LAST_NAME)),
            showInLegend: true,
            dataPoints: [
                @for ($m = 1; $m <= 12; $m++)
                    {
                        label: "{{ $monthNames[$m-1] }}",
                        y: {{ $expenseAmounts[$driver->DRIVER_ID][$m] ?? 0 }}
                    },
                @endfor
            ]
        });
    @endforeach

    var chart = new CanvasJS.Chart("monthlyDriverExpenseChart", {
        animationEnabled: true,
        theme: "light2",
        title: {
            text: "Monthly Driver Maintenance & Expense Report ({{ $cur_year }}) Chart"
        },
        axisY: {
            title: "Driver Maintenance & Expense Amount ($)",
            includeZero: true
        },
        toolTip: {
            shared: true
        },
        legend: {
            verticalAlign: "bottom"
        },
        data: chartData
    });

    chart.render();
};
setTimeout(() => {
    $(".canvasjs-chart-credit").addClass('d-none');
}, 2000);

</script>


@endsection