@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;
            }
        }
    .dt-buttons{
        display:none !important;
    }
    .select2-container--bootstrap5 .select2-selection--single.form-select-solid .select2-selection__placeholder {
    color: #fff !important;
}
</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">Top 10 Vendor  Report</h3>
                <div class="d-flex flex-wrap align-items-center my-1"  id="topheadsection">
                    <h3 class="fw-bold me-5 my-1">Top 10 Vendor <span class="text-muted">Report</span>
                    <a id="backbtn" href="{{ route('assets.vendors.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>--}}
                                     <div class="float-end">

                                   <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.vendors.top10vendorPdf')}}" 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>

                                </div> 
                    <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" />  -->
                                        <h2  style="font-weight: bold; font-size: 20px; margin-top: 9px;">Top 10 Vendor  Report</h2>
                                         <h3>{{ getAuthCompanyName() }}</h3>
                                         <span> {{ getAuthCarrierInfo()->BILL_TO }}</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;"> {{ date('m/d/Y h:i A') }}</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 table-striped" width="100%">
                                                    <thead style="background:#388DC6;color:#fff">
                                                        <tr>
                                                            <th class="text-gray-500">NAME</th>
                                                            <th class="text-gray-500">STATUS</th>
                                                            <th class="text-gray-500">DATE</th>
                                                            <th class="text-gray-500">REPAIR</th>
                                                            <th class="text-gray-500">EXPENSE</th>
                                                        </tr>
                                                    </thead>

                                                    <tbody>
                                                        @foreach ($vendors as $row)
                                                            <tr>
                                                                <th>
                                                                    <a href="{{ route('assets.vendors.edit', $row->VENDOR_ID) }}"
                                                                    class="text-uppercase">
                                                                        {{ $row->NAME }}
                                                                    </a>
                                                                </th>

                                                                <td>
                                                                    {{ $row->IS_INACTIVE === 'False' ? 'ACTIVE' : 'INACTIVE' }}
                                                                </td>

                                                                <td>
                                                                    {{ $row->CREATED_WHEN
                                                                        ? \Carbon\Carbon::parse($row->CREATED_WHEN)->format('m/d/Y')
                                                                        : '' }}
                                                                </td>

                                                                <td style="color:green;">
                                                                    ${{ number_format($row->repair_total, 2) }}
                                                                </td>

                                                                <td style="color:red;">
                                                                    ${{ number_format($row->expense_total, 2) }}
                                                                </td>
                                                            </tr>
                                                        @endforeach

                                                        {{-- GRAND TOTAL --}}
                                                        <tr style="background:#c3b9b9;font-weight:bold;">
                                                            <td>GRAND TOTAL</td>
                                                            <td></td>
                                                            <td></td>
                                                            <td style="color:green;">
                                                                ${{ number_format($grandRepair, 2) }}
                                                            </td>
                                                            <td style="color:red;">
                                                                ${{ number_format($grandExpense, 2) }}
                                                            </td>
                                                        </tr>
                                                    </tbody>
                                                </table>
                                            </div>                                   
                                                                                  
                                        </div>
                                       @php
                                            $repairData = [];
                                            $expenseData = [];

                                            foreach ($vendors as $row) {
                                                $status = $row->IS_INACTIVE === 'False' ? 'ACTIVE' : 'INACTIVE';
                                                $date   = $row->CREATED_WHEN
                                                            ? \Carbon\Carbon::parse($row->CREATED_WHEN)->format('m/d/Y')
                                                            : 'N/A';

                                                $repairData[] = [
                                                    'label'  => strtoupper($row->NAME),
                                                    'y'      => round($row->repair_total, 2),
                                                    'status' => $status,
                                                    'date'   => $date
                                                ];

                                                $expenseData[] = [
                                                    'label'  => strtoupper($row->NAME),
                                                    'y'      => round($row->expense_total, 2),
                                                    'status' => $status,
                                                    'date'   => $date
                                                ];
                                            }

                                            $maxValue = max(
                                                collect($repairData)->max('y') ?? 0,
                                                collect($expenseData)->max('y') ?? 0
                                            );

                                            $yAxisMax = ceil($maxValue * 1.15);
                                            $yAxisMax = ceil($yAxisMax / 1000) * 1000;
                                        @endphp
                                        <div class="row" style="margin-top: 10px;">
                                            <div id="topTenVendorChart" style="height: 420px; width: 100%;"></div>
                                        </div>
                                </div>                           
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>


@endsection()
@section('script')
<script src="https://canvasjs.com/assets/script/canvasjs.min.js"></script>
<script>
window.onload = function () {

    var repairPoints  = @json($repairData);
    var expensePoints = @json($expenseData);

    var chart = new CanvasJS.Chart("topTenVendorChart", {
        animationEnabled: true,
        theme: "light2",
        title: {
            text: "Top 10 Vendors – Repair vs Expense"
        },
        axisX: {
            labelAngle: -45,
            interval: 1
        },
        axisY: {
            title: "Amount ($)",
            includeZero: true,
            maximum: {{ $yAxisMax }},
            margin: 25
        },
        toolTip: {
            shared: true,
            content: function (e) {

                var name   = e.entries[0].dataPoint.label;
                var status = e.entries[0].dataPoint.status;
                var date   = e.entries[0].dataPoint.date;

                var content = "<b>" + name + "</b><br/>";
                content += "Status: <b>" + status + "</b><br/>";
                content += "Created: <b>" + date + "</b><br/><hr/>";

                e.entries.forEach(function (entry) {
                    content += entry.dataSeries.name + ": $" +
                        entry.dataPoint.y.toFixed(2) + "<br/>";
                });

                return content;
            }
        },
        legend: {
            verticalAlign: "top",
            horizontalAlign: "center"
        },
        data: [
            {
                type: "column",
                name: "Repair",
                showInLegend: true,
                indexLabel: "${y}",
                indexLabelPlacement: "outside",
                color: "#28a745",
                dataPoints: repairPoints
            },
            {
                type: "column",
                name: "Expense",
                showInLegend: true,
                indexLabel: "${y}",
                indexLabelPlacement: "outside",
                color: "#dc3545",
                dataPoints: expensePoints
            }
        ]
    });

    chart.render();
};
</script>

<script>
    
        
//         document.getElementById('year').addEventListener('change', function() {
//         const selectedYear = this.value;
       
//         var year = selectedYear; 
//         var baseUrl = "{{ route('assets.customers.topTenCustomerReport') }}";
//         var fullUrl = baseUrl + "?year=" + encodeURIComponent(year);
//         location.href = fullUrl;
// });
        const table = $('#topTenVendor-table');
       
        table.on('preXhr.dt', function(e, setting, data) {
            data.search = $('#search').val();
            data.start_date = $('#start_date').val();
            data.end_date = $('#end_date').val();
            data.status = $('#STATUS').val();
            
        });

          $('#downloadOptions').on('change', function() {
            var downloadOptions = this.value;
            $(".buttons-" + downloadOptions).click();
            var datatableId = 'topTenVendor-table';
            downloadDataTable(downloadOptions, datatableId);
        });

              function downloadDataTable(option, datatableId) {
           
           switch (option) {
               case 'excel':
                   $('#' + datatableId).DataTable().buttons('.buttons-excel').trigger();
                   break;
               case 'csv':
                   $('#' + datatableId).DataTable().buttons('.buttons-csv').trigger();
                   break;
               case 'print':
                   $('#' + datatableId).DataTable().buttons('.buttons-print').trigger();
                   break;
               case 'reset':
                   $('#' + datatableId).DataTable().buttons('.buttons-reset').trigger();
                   break;
               case 'reload':
                   $('#' + datatableId).DataTable().buttons('.buttons-reload').trigger();
                   break;
               default:
                   break;
           }
       }

    </script>

 
@endsection