@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,
      
        #printButton{
            display: none;
        }
        #truckreporthead{
            display: none !important;
        }
        th.text-gray-500 {
                color: #fff !important;
        }
            .dataTable .btn.btn-dark {   
             background-color: #b72b2b !important;
             padding: 8px !important;

            }
            #plmonthlybtn{
                display: none !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">
             
                <div class="d-flex flex-wrap align-items-center my-1" id="topheadsection">
                    <h3 class="fw-bold me-5 my-1" id="truckreporthead">Trucks P&L Report
                        <a id="backbtn" href="{{ route('assets.loads.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 me-2" type="button" id="dropdownMenuButton1"
                        data-bs-toggle="dropdown" aria-expanded="false" style="padding: 7px 10px;">
                        Export
                    </button>
                    <a target="_blank"
                        href="{{ route('assets.loads.allLoadsMonthReport') }}?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" id="plmonthlybtn">P&L Monthly Statement</a>
                    <ul class="dropdown-menu" aria-labelledby="dropdownMenuButton1" id="printandyeardropdown">
                        <li></li>
                        <li><a class="dropdown-item"
                                href="{{ route('assets.loads.LoadsReportPdf') }}?year={{ $cur_year }}"
                                class="btn btn-primary btn-sm me-2">PDF</a> </li>
                        <li><a class="dropdown-item"
                                href="{{ route('assets.loads.LoadsReportCsv') }}?year={{ $cur_year }}"
                                class="btn btn-primary btn-sm me-2">CSV</a> </li>
                        <li><a class="dropdown-item"
                                href="{{ route('assets.loads.allLoadReportExcel') }}?year={{ $cur_year }}"
                                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                                
                                    $year = request('year');
                                @endphp
                                <div style="margin:0 auto;text-align:center;"> <span
                                        style="font-weight: bold; font-size: 20px; margin-top: 9px;"> Trucks P & L Report ({{!empty($year) ? $year : date('Y') }})
                                    </span>
                                </div>
                                <div style="margin:0 auto;text-align:center;">
                                    <h3>{{ getAuthCompanyName() }}</h3>
                                    <span> {{ getAuthCarrierInfo()->BILL_TO }}</span>
                                </div>
                                <div class="row">                                   
                                    <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>
                                    <hr>
                                    <div class="row">
                                    <table class="table table-bordered" width="100%">
                                            <tr style="background: #388DC6;">
                                                <th class="text-gray-500"><b>UNIT ID</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> <!-- New Total Column -->
                                            </tr>

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

                                            @foreach ($profitAmounts as $key => $profits)
                                                @php
                                                    [$type, $id] = explode('-', $key);
                                                    $isTrailer = $type === 'Trailer';
                                                    $isDriver = $type === 'Driver';
                                                    $isMisc = $type === 'Misc';

                                                    $rowTotal = array_sum($profits); // Calculate row-wise total
                                                    $gtotal += $rowTotal; // Add to Grand Total
                                                @endphp
                                                <tr>
                                                    <th>
                                                        @if ($isTrailer)
                                                            <b><a href="{{ route('assets.trailers.edit', $id) }}#kt_stats_widget_16_tab_7"
                                                                    target="_blank">Trailer {{ $id }}</a></b>
                                                        @elseif($isDriver)
                                                            <b><a href="{{ route('assets.drivers.edit', $id) }}#kt_stats_widget_16_tab_6"
                                                                    target="_blank">Driver {{ $id }}</a></b>
                                                        @elseif($isMisc)
                                                            <b>MISC Expenses</b>
                                                        @else
                                                            <a href="{{ route('assets.trucks.profitAndLossReport', $type) }}"
                                                                title="Truck Loads" target="_blank">
                                                                <b>{{ $id }}</b>
                                                            </a>
                                                        @endif
                                                    </th>
                                                    @for ($month = 1; $month <= 12; $month++)
                                                        @php
                                                            $profit = $profits[$month] ?? 0;
                                                            $monthlyTotals[$month] += $profit; // Sum monthly profits for the total row
                                                        @endphp
                                                        <td>
                                                            <b><span style="color: {{ $profit > 0 ? 'green' : ($profit < 0 ? 'red' : 'black') }}"
                                                                    class="{{ $profit < 0 ? 'text-danger' : '' }}">${{ number_format($profit, 2) }}</span></b>
                                                        </td>
                                                    @endfor
                                                    <td style="color: {{ $rowTotal > 0 ? 'green' : ($rowTotal < 0 ? 'red' : 'black') }}">
                                                        <b>${{ number_format($rowTotal, 2) }}</b> <!-- Display row-wise total -->
                                                    </td>
                                                </tr>
                                            @endforeach

                                            <!-- Monthly Total Row -->
                                            <tr style="background:#c3b9b9">
                                                <td><b>Total</b></td>
                                                @for ($month = 1; $month <= 12; $month++)
                                                    <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> <!-- Grand Total column -->
                                                </td>
                                            </tr>

                                            <!-- Grand Total Row -->
                                            <tr style="background:#c3b9b9">
                                                <td colspan="14"> 
                                                    <b>
                                                        <h4 style="color: {{ $gtotal > 0 ? 'green' : ($gtotal < 0 ? 'red' : 'black') }}">
                                                            Grand Total Profit: ${{ 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="unitMonthlyPLChart" style="height: 420px; width: 100%;"></div>
                                    
                                    @endif
                                    @php
                                        $monthNames = ["Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"];
                                        $chartSeries = [];

                                        foreach ($profitAmounts as $key => $profits) {
                                            [$type, $id] = explode('-', $key);

                                            if ($type === 'Trailer') {
                                                $label = "Trailer $id";
                                            } elseif ($type === 'Driver') {
                                                $label = "Driver $id";
                                            } elseif ($type === 'Misc') {
                                                $label = "Misc Expenses";
                                            } else {
                                                $label = $id; // Truck / Unit
                                            }

                                            $dataPoints = [];
                                            for ($m = 1; $m <= 12; $m++) {
                                                $val = $profits[$m] ?? 0;
                                                $dataPoints[] = [
                                                    'label' => $monthNames[$m-1],
                                                    'y'     => round($val, 2)
                                                ];
                                            }

                                            $chartSeries[] = [
                                                'type'         => 'stackedColumn',
                                                'name'         => $label,
                                                'showInLegend' => true,
                                                'dataPoints'   => $dataPoints
                                            ];
                                        }
                                    @endphp
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
@endsection()
@section('script')
<script src="https://canvasjs.com/assets/script/canvasjs.min.js"></script>
    <script>
        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.loads.allLoadReport') }}";
            var fullUrl = baseUrl + "?year=" + encodeURIComponent(year);
            location.href = fullUrl;
        });
    </script>
    <script>
window.onload = function () {

    var chartData = @json($chartSeries);

    var chart = new CanvasJS.Chart("unitMonthlyPLChart", {
        animationEnabled: true,
        theme: "light2",
        title: {
            text: "Truck Monthly P&L ({{ $cur_year }}) Chart"
        },
        axisX: {
            title: "Month"
        },
        axisY: {
            title: "Profit / Loss ($)",
            includeZero: true
        },
        toolTip: {
            shared: true,
            content: function (e) {
                var content = "<b>" + e.entries[0].dataPoint.label + "</b><br/>";
                var total = 0;

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

                content += "<hr/><b>Total: $" + total.toFixed(2) + "</b>";
                return content;
            }
        },
        legend: {
            verticalAlign: "top",
            horizontalAlign: "center",
            fontSize: 12
        },
        data: chartData
    });

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