@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 !important;
        }

        #kt_footer {
            display: none !important;
        }
        #topheadsection,
        #backbtn,
        #dropdownMenuButton1,
        #pdfhead,
        #report_link,
        #printButton,
        #searchFrom {
            display: none !important;
        }
    }
    .header_text_color{
        color: #fff;
    }

</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">
              
                <div class="d-flex flex-wrap align-items-center my-1" id="topheadsection">
                    <h3 class="fw-bold me-5 my-1">P&L Yearly Comparison 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>
                  {{-- 
                  <form action="{{ route('assets.accounting.yearlyComparison') }}"
                        class="d-flex align-items-center mt-3" method="GET">

                        <select id="year"
                                name="year"
                                class="form-control ms-4"
                                style="padding:7px; width:140px;">
                            <option value="">Please select</option>

                            @for($y = date('Y'); $y >= 2019; $y--)
                                <option value="{{ $y }}"
                                    {{ request('year') == $y ? 'selected' : '' }}>
                                    {{ $y }}
                                </option>
                            @endfor
                        </select>

                        <input type="hidden" name="start_date" id="start_date">
                        <input type="hidden" name="end_date" id="end_date">

                        <button type="submit" class="btn btn-primary btn-sm ms-2">Search</button>

                        <a href="{{ route('assets.accounting.allAccountingYearlyReport') }}"
                        class="btn btn-primary btn-sm ms-2">
                            Clear
                        </a>
                    </form> 
                    --}}
                    <a href="{{ route('assets.accounting.allAccountingMonthlyReport') }}" class="btn btn-primary btn-sm me-2"id="report_link" target="_blank" style="
                        margin-left: 10px;
                        padding: 9px;
                    ">P&L Monthly Report</a> <a href="{{ route('assets.accounting.allAccountingYearlyReport') }}" class="btn btn-primary btn-sm me-2"id="report_link" target="_blank">P&L Yearly Report</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  me-2"
                                        href="{{ route('assets.accounting.yearlyComparison', ['year' => $year, 'start_date' => $startDate, 'end_date' => $endDate]) }}">
                                            PDF
                                        </a>--}}
                                        <form id="pdfForm"
                                                method="POST"
                                                action="{{ route('assets.accounting.yearlyComparisonpdf') }}">
                                                @csrf
                                                <input type="hidden" name="year" value="{{ $year }}">
                                                <input type="hidden" name="start_date" value="{{ $startDate }}">
                                                <input type="hidden" name="end_date" value="{{ $endDate }}">
                                                <input type="hidden" name="chart_image" id="chart_image">
                                            </form>
                                        <a class="dropdown-item me-2" href="javascript:void(0);" onclick="downloadPdfWithChart()">
                                                PDF
                                        </a>
                                    </li>
                                    </ul>
                    {{-- <a class="btn btn-primary btn-sm me-2" href="javascript:void(0);" id="printButton">Print</a> --}}
                    {{-- <div class="dropdown">
                        <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.loads.LoadsReportPdf') }}">Pdf</a></li>
                            <li><a class="dropdown-item" href="{{ route('assets.loads.LoadsReportCsv') }}">Csv</a></li>
                            <li><a class="dropdown-item" href="{{ route('assets.loads.allLoadReportExcel') }}">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">
                                @php
                                    $startdate = request('start_date') ?: date('Y-01-01');
                                    $year = (new DateTime($startdate))->format('Y');
                                @endphp
                                <div style="margin:0 auto;text-align:center;">
                                    <h2>{{ 'P&L Yearly Comparison Report' }}  ({{ $year }} - {{$year-1}})</h2>                                
                                </div>
                                <div style="margin:0 auto;text-align:center;">
                                <h3>{{ getAuthCompanyName() }}</h3>
                                <span> {{ getAuthCarrierInfo()->BILL_TO }}</span>
                            </div>
                            <div style="margin:0 auto;text-align:left;display:none;">
                                <span style="font-size:16px;">{{ date('m/d/Y h:i A') }}</span>
                            </div>
                            @php 
                             $d = ($current['profit'] ?? 0) - ($previous['profit'] ?? 0);
                            @endphp
                            <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>
                                            Profit:
                                            <span style="color: {{ $d >= 0 ? 'green' : 'red' }};">
                                                ${{ number_format($d, 2) }}
                                            </span>
                                        </strong>
                                    </td>
                                </tr>
                            </table>
                                

                                <div class="row">
                                    <hr>
                                    <div class="row">
                                        @php
                                            $start = \Carbon\Carbon::parse($startDate);
                                            $end = \Carbon\Carbon::parse($endDate);

                                            $dateInterval = \Carbon\CarbonPeriod::create($start, '1 month', $end);
                                        @endphp
                                            
                                        <table class="table table-bordered text-center" width="100%">
                                            <thead style="background:#388DC6;color:#fff;">
                                                <tr>
                                                    <th>TYPE</th>
                                                    <th>Current Year</th>
                                                    <th>Prior Year</th>
                                                    <th>Comparative</th>
                                                </tr>
                                            </thead>

                                            <tbody>
                                                {{-- Loads Income --}}
                                                @php $d = ($current['income'] ?? 0) - ($previous['income'] ?? 0); @endphp
                                                <tr>
                                                    <td class="text-uppercase text-start"><b>Loads Income</b></td>

                                                    <td class="text-success">
                                                        <a target="_blank"
                                                        href="{{ route('assets.loads.index') }}?delivery_start_date={{ $currentYear.'-01-01' }}&delivery_end_date={{ $currentYear.'-12-31' }}&request_status=All"
                                                        class="text-success">
                                                            ${{ number_format($current['income'], 2) }}
                                                        </a>
                                                    </td>

                                                    <td class="text-success">
                                                        <a target="_blank"
                                                        href="{{ route('assets.loads.index') }}?delivery_start_date={{ $previousYear.'-01-01' }}&delivery_end_date={{ $previousYear.'-12-31' }}&request_status=All"
                                                        class="text-success">
                                                            ${{ number_format($previous['income'], 2) }}
                                                        </a>
                                                    </td>

                                                    <td class="{{ $d >= 0 ? 'text-success' : 'text-danger' }}">
                                                        <b>${{ number_format($d, 2) }}</b>
                                                    </td>
                                                </tr>

                                                {{-- Extra Charge --}}
                                                @php 
                                                    $d = ($current['extra'] ?? 0) - ($previous['extra'] ?? 0);
                                                @endphp
                                                <tr>
                                                    <td class="text-uppercase text-start"><b>Extra Charge</b></td>

                                                    <td class="{{ $current['extra'] >= 0 ? 'text-success' : 'text-danger' }}">
                                                        ${{ number_format($current['extra'], 2) }}
                                                    </td>

                                                    <td class="{{ $previous['extra'] >= 0 ? 'text-success' : 'text-danger' }}">
                                                        ${{ number_format($previous['extra'], 2) }}
                                                    </td>

                                                    <td class="{{ $d >= 0 ? 'text-success' : 'text-danger' }}">
                                                        <b>${{ number_format($d, 2) }}</b>
                                                    </td>
                                                </tr>

                                                {{-- Income Subtotal --}}
                                                @php 
                                                $d = ($current['income_total'] ?? 0) - ($previous['income_total'] ?? 0);
                                                 @endphp
                                                <tr style="background:#00000021;">
                                                    <td class="text-uppercase text-start"><b>Income Subtotal</b></td>
                                                    <td><b>${{ number_format($current['income_total'], 2) }}</b></td>
                                                    <td><b>${{ number_format($previous['income_total'], 2) }}</b></td>
                                                    <td class="{{ $d >= 0 ? 'text-success' : 'text-danger' }}">
                                                        <b>${{ number_format($d, 2) }}</b>
                                                    </td>
                                                </tr>

                                                {{-- Repair --}}
                                                @php 
                                                $d = ($current['repair'] ?? 0) - ($previous['repair'] ?? 0);
                                                @endphp
                                                <tr>
                                                    <td class="text-uppercase text-start text-danger"><b>Repair</b></td>
                                                    <td class="text-danger">${{ number_format($current['repair'], 2) }}</td>
                                                    <td class="text-danger">${{ number_format($previous['repair'], 2) }}</td>
                                                    <td class="{{ $d <= 0 ? 'text-success' : 'text-danger' }}">
                                                        <b>${{ number_format($d, 2) }}</b>
                                                    </td>
                                                </tr>

                                                {{-- Expense --}}
                                                @php 
                                                $d = ($current['expense'] ?? 0) - ($previous['expense'] ?? 0);
                                                @endphp
                                                <tr>
                                                    <td class="text-uppercase text-start text-danger"><b>Expense</b></td>
                                                    <td class="text-danger">${{ number_format($current['expense'], 2) }}</td>
                                                    <td class="text-danger">${{ number_format($previous['expense'], 2) }}</td>
                                                    <td class="{{ $d <= 0 ? 'text-success' : 'text-danger' }}">
                                                        <b>${{ number_format($d, 2) }}</b>
                                                    </td>
                                                </tr>

                                                {{-- PROFIT --}}
                                                @php 
                                                $d = ($current['profit'] ?? 0) - ($previous['profit'] ?? 0);
                                                @endphp
                                                <tr style="background:#388DC6;color:#fff;">
                                                    <td class="text-uppercase text-start"><b>PROFIT</b></td>

                                                    <td class="{{ $current['profit'] >= 0 ? 'text-success' : 'text-danger' }}">
                                                        <b>${{ number_format($current['profit'], 2) }}</b>
                                                    </td>

                                                    <td class="{{ $previous['profit'] >= 0 ? 'text-success' : 'text-danger' }}">
                                                        <b>${{ number_format($previous['profit'], 2) }}</b>
                                                    </td>

                                                    <td class="{{ $d >= 0 ? 'text-success' : 'text-danger' }}">
                                                        <b>${{ number_format($d, 2) }}</b>
                                                    </td>
                                                </tr>
                                            </tbody>
                                        </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="yearComparisonChart" style="height: 420px; width: 100%;"></div>
                                    @endif                                   
                                </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 () {

    window.financeChart = new CanvasJS.Chart("yearComparisonChart", {
        animationEnabled: true,
        theme: "light2",
        title: {
            text: "{{ getAuthCompanyName() }} – P&L Yearly Comparison Chart"
        },
        axisY: {
            title: "Amount ($)",
            includeZero: true
        },
        toolTip: {
            shared: true
        },
        legend: {
            cursor: "pointer",
            verticalAlign: "top"
        },
        data: [

            {
                type: "column",
                name: "{{ 'Current Year' }}",
                showInLegend: true,
                color: "#28a745",
                dataPoints: [
                    { label: "Income",        y: {{ $current['income'] }} },
                    { label: "Extra Charge",  y: {{ $current['extra'] }} },
                    { label: "Income Total",  y: {{ $current['income_total'] }} },
                    { label: "Repair",        y: {{ $current['repair'] }} },
                    { label: "Expense",       y: {{ $current['expense'] }} },
                    { label: "Profit",        y: {{ $current['profit'] }} }
                ]
            },

            {
                type: "column",
                name: "{{ 'Previous Year' }}",
                showInLegend: true,
                color: "#007bff",
                dataPoints: [
                    { label: "Income",        y: {{ $previous['income'] }} },
                    { label: "Extra Charge",  y: {{ $previous['extra'] }} },
                    { label: "Income Total",  y: {{ $previous['income_total'] }} },
                    { label: "Repair",        y: {{ $previous['repair'] }} },
                    { label: "Expense",       y: {{ $previous['expense'] }} },
                    { label: "Profit",        y: {{ $previous['profit'] }} }
                ]
            },

            {
                type: "column",
                name: "{{ 'Comparative' }}",
                showInLegend: true,
                color: "#550e85",
                dataPoints: [
                    { label: "Income",        y: {{ $current['income'] - $previous['income'] }} },
                    { label: "Extra Charge",  y: {{ $current['extra'] - $previous['extra'] }} },
                    { label: "Income Total",  y: {{ $current['income_total'] - $previous['income_total'] }} },
                    { label: "Repair",        y: {{ $current['repair'] - $previous['repair'] }} },
                    { label: "Expense",       y: {{ $current['expense'] - $previous['expense'] }} },
                    { label: "Profit",        y: {{ $current['profit'] - $previous['profit'] }} }
                ]
            }

        ]
    });

    // ✅ render correctly
    window.financeChart.render();

    // ✅ capture image (for PDF / email)
    setTimeout(function () {
        var img = document.getElementById("chartImage");
        if (img && window.financeChart.canvas) {
            img.src = window.financeChart.canvas.toDataURL("image/png");
        }
    }, 300);

};
</script>

<script>
function downloadPdfWithChart() {

    if (!window.financeChart) {
        alert("Chart not ready yet");
        return;
    }

    // Convert chart to image
    var base64Image = window.financeChart.canvas
        .toDataURL("image/png")
        .replace(/^data:image\/png;base64,/, "");

    // Put image into hidden field
    document.getElementById("chart_image").value = base64Image;

    // Submit form
    document.getElementById("pdfForm").submit();
}
</script>
<script>
document.addEventListener('DOMContentLoaded', function () {

    function applyYearFromMonth(val) {
        if (!val) return;

        let year = val.split('-')[0];

        document.getElementById('start_date').value = year + '-01-01';
        document.getElementById('end_date').value   = year + '-12-31';
    }

    const monthInput = document.getElementById('year');

    // on change
    monthInput.addEventListener('change', function () {
        applyYearFromMonth(this.value);
    });

    // on page load
    applyYearFromMonth(monthInput.value);
});

     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.accounting.allAccountingYearlyReport') }}";
                const fullUrl = baseUrl + "?year=" + encodeURIComponent(selectedYear);
                //location.href = fullUrl;
            });
        }

        if (printButton) {
            printButton.addEventListener('click', function() {
                window.print();
            });
        }
    });

    </script>
@endsection