@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 Monthly 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.allAccountingMonthlyReport') }}"
                            class="d-flex align-items-center mt-3" id="searchFrom" method="GET">

                             <select id="year"
                                name="year"
                                class="form-control ms-4"
                                style="padding:7px;width:140px;margin-left: 0px !important;margin-right: 7px;">
                            <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 me-2">Search</button>

                            <a href="{{ route('assets.accounting.allAccountingMonthlyReport') }}"
                            class="btn btn-primary btn-sm me-2">
                                Clear
                            </a>
                        </form>
                    <a href="{{ route('assets.accounting.allAccountingYearlyReport') }}" class="btn btn-primary btn-sm me-2"id="report_link" target="_blank">P&L Yearly Report</a><a href="{{ route('assets.accounting.yearlyComparison') }}" class="btn btn-primary btn-sm me-2"id="report_link" target="_blank">P&L Comparison 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.allLoadsMonthlyReportpdf', ['start_date' => $startDate, 'end_date' => $endDate]) }}">
                                            PDF
                                        </a>--}}
                                        <form id="pdfForm"
                                                method="POST"
                                                action="{{ route('assets.accounting.allLoadsMonthlyReportpdf') }}">
                                                @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-m-01');

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

                            <div style="margin:0 auto;text-align:center;">
                                <h2>{{ 'P&L Monthly Report' }}  ({{ $monthYear }})</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>
                             <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: {{ ($profitGrandTotal ?? 0) > 0 ? 'green' : 'red' }};">
                                                ${{ number_format($profitGrandTotal ?? 0, 2) }}
                                            </span>
                                        </strong>
                                    </td>
                                </tr>
                            </table>
                           {{--  @php 
                                $repair_type_totals = 0;
                                $expense_type_totals = 0;

                                foreach ($truck_issues_new as $truck_issues) {
                                    if (isset($repair_type_array_new[$truck_issues->Type])) {
                                        $repair_type_totals += $truck_issues->total_amount;
                                    }
                                }

                                foreach ($truck_expense_new as $truck_expense) {
                                    if (isset($expense_type_array_new[$truck_expense->TYPE])) {
                                        $expense_type_totals += $truck_expense->total_amount;
                                    }
                                }

                                $profit = $income - $repair_type_totals - $expense_type_totals;
                            @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: {{ $profit > 0 ? 'green' : 'red' }};">
                                                ${{ number_format($profit, 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);
                                             $overallTotals=0;   
                                        @endphp


                                        <table class="table table-bordered text-center" width="100%">
                                        <thead class="bg-primary text-white" style="background: #388DC6;">
                                            <tr>
                                                <th></th>
                                               @foreach($months as $month)
                                                    <th style="text-align: center; color: #ffffff;">
                                                        {{ strtoupper($month) }}
                                                        
                                                    </th>
                                                @endforeach
                                                <th style="text-align: center; color: #ffffff;">Total</th>
                                            </tr>
                                        </thead>

                                        <tbody>
                                            <tr>
                                                <th class="text-start">Loads Income</th>
                                                @php $totalLoadIncome=0; @endphp
                                                @foreach($months as $month)
                                                    <td><a target="_blank"
                                                        class="{{ $report['income'][$month] >= 0 ? 'text-success' : 'text-danger' }}"
                                                        href="{{ route('assets.loads.index') }}?delivery_start_date={{ $monthDateRanges[$month]['start'] }}&delivery_end_date={{ $monthDateRanges[$month]['end'] }}&request_status=All">
                                                          ${{ number_format($report['income'][$month] ?? 0, 2) }}
                                                            @php 
                                                             $overallTotals+=$report['income'][$month];
                                                             @endphp
                                                        </a></td>
                                                @endforeach
                                                           
              
                                                 <td>
                                                    <a target="_blank"
                                                        class="{{ $report['income'][$month] >= 0 ? 'text-success' : 'text-danger' }}"
                                                        href="{{ route('assets.loads.index') }}?delivery_start_date={{ $monthDateRanges[$month]['start'] }}&delivery_end_date={{ $monthDateRanges[$month]['end'] }}&request_status=All">
                                                      ${{ number_format((float) array_sum($report['income']), 2) }}
                                                        </a>
                                                    </td> 
                                            </tr>

                                            <tr>
                                                <th class="text-start">Extra Charge</th>
                                                 @php $totalExtracharge=0; @endphp
                                                @foreach($months as $month)
                                                    <td> <a target="_blank" href="{{ route('assets.loads.index') }}?delivery_start_date={{ $monthDateRanges[$month]['start'] }}&delivery_end_date={{ $monthDateRanges[$month]['end'] }}&request_status=All"
                                                                class="{{ $report['income_total'][$month] >= 0 ? 'text-success' : 'text-danger' }}"> ${{ number_format($report['extra_charge'][$month] ?? 0, 2) }}</a>
                                                                @php 
                                                                    $totalExtracharge+=$report['extra_charge'][$month]; 
                                                                    $overallTotals+=$totalExtracharge;

                                                                @endphp
                                                         </td>
                                                @endforeach
                                           <td>
                                                    <a target="_blank"
                                                        class="{{ $report['income'][$month] >= 0 ? 'text-success' : 'text-danger' }}"
                                                        href="{{ route('assets.loads.index') }}?delivery_start_date={{ $monthDateRanges[$month]['start'] }}&delivery_end_date={{ $monthDateRanges[$month]['end'] }}&request_status=All">
                                                       ${{ number_format((float) array_sum($report['extra_charge']), 2) }}
                                                        </a>
                                                    </td>
                                            </tr>

                                            <tr class="fw-bold bg-light">
                                                <th class="text-start">Income Total</th>
                                                 @php $totalIncome=0; @endphp
                                                @foreach($months as $month)
                                                    <td><b class="{{ $report['income_total'][$month] >= 0 ? 'text-dark' : '' }}">${{ number_format($report['income_total'][$month] ?? 0, 2) }}</b></td>
                                                        @php 
                                                            $totalIncome+=$report['income_total'][$month]; 
                                                            $overallTotals+=$totalIncome
                                                        @endphp
                                                @endforeach
                                                <td>
                                                    <a target="_blank"
                                                        class="{{ $report['income'][$month] >= 0 ? 'text-success' : 'text-danger' }}"
                                                        href="{{ route('assets.loads.index') }}?delivery_start_date={{ $monthDateRanges[$month]['start'] }}&delivery_end_date={{ $monthDateRanges[$month]['end'] }}&request_status=All">
                                                  
                                                      
                                                      ${{ number_format((float) array_sum($report['income_total']), 2, '.', ',') }}
                                                        </a>
                                                    </td> 
                                            </tr>

                                            <tr>
                                                <th class="text-start text-danger">Repair</th>
                                                @php $totalRepair=0; @endphp
                                                @foreach($months as $month)
                                                    <td class="text-danger">
                                                        <a target="_blank" href="{{ route('assets.repair.index') }}?start_date={{ $monthDateRanges[$month]['start'] }}&end_date={{ $monthDateRanges[$month]['end'] }}"
                                                            class="text-danger">${{ number_format($report['repair'][$month] ?? 0, 2) }}
                                                        </a>
                                                         @php 
                                                         $totalRepair+=$report['repair'][$month];
                                                             $overallTotals+=$totalRepair
                                                          @endphp
                                                    </td>
                                                @endforeach
                                                <td>
                                                    <a target="_blank"
                                                        class="text-danger"
                                                        href="{{ route('assets.loads.index') }}?delivery_start_date={{ $monthDateRanges[$month]['start'] }}&delivery_end_date={{ $monthDateRanges[$month]['end'] }}&request_status=All">
                                                    
                                                   ${{ isset($report['repair'][$month]) 
                                                        ? number_format((float)$report['repair'][$month], 2, '.', ',') 
                                                        : '0.00' }}
                                                        </a>
                                                    </td> 
                                            </tr>

                                         <tr>
                                                <th class="text-start text-danger">Expense</th>
                                                @php $totalExp =0; @endphp

                                                @foreach($months as $month)
                                                    <td class="text-danger">
                                                        <a target="_blank"
                                                            href="{{ route('assets.expense.index') }}?start_date={{ $monthDateRanges[$month]['start'] }}&end_date={{ $monthDateRanges[$month]['end'] }}"
                                                            class="text-danger">${{ number_format($report['expense'][$month] ?? 0, 2) }}</a>
                                                             @php 
                                                                 $totalExp+=$report['expense'][$month]; 
                                                                 $overallTotals+=$totalExp
                                                             @endphp
                                                    </td>
                                                @endforeach
                                                          <td>
                                                    <a target="_blank"
                                                        class="text-danger"
                                                        href="{{ route('assets.loads.index') }}?delivery_start_date={{ $monthDateRanges[$month]['start'] }}&delivery_end_date={{ $monthDateRanges[$month]['end'] }}&request_status=All">
                                                         ${{ number_format((float) array_sum($report['expense']), 2, '.', '') }}
                                                      
                                                        </a>
                                                    </td>
                                                   
                                            </tr>
                                   

                                            <tr class="fw-bold bg-success text-white" style = "background-color: #17c653 !important;">
                                                <th class="text-start">PROFIT</th>
                                                  @php $totalProfit = 0; @endphp
                                                @foreach($months as $month)
                                                    @php
                                                        $monthlyProfit = $report['profit'][$month] ?? 0;
                                                    @endphp

                                                    <td>
                                                        ${{ number_format($monthlyProfit, 2) }}
                                                    </td>
                                                     @php $totalProfit+=$monthlyProfit; 
                                                     $overallTotals+=$totalProfit
                                                     @endphp
                                                @endforeach
                                                           <td>
                                                    <a target="_blank"
                                                        class="text-white"
                                                        href="{{ route('assets.loads.index') }}?delivery_start_date={{ $monthDateRanges[$month]['start'] }}&delivery_end_date={{ $monthDateRanges[$month]['end'] }}&request_status=All">
                                                        ${{ number_format((float) array_sum($report['profit']), 2, '.', '') }}
                                                        </a>
                                                    </td> 
                                            </tr>
                                            <tr class="fw-bold bg-success text-white" style = "background-color: #17c653 !important;">
                                                <th class="text-start">Grand Total</th>
 
                                                {{-- Grand Total column --}}
                                                <td colspan="13" style="text-align: center;">
                                                    ${{ number_format($profitGrandTotal ?? 0, 2) }}
                                                </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="monthlyBarChart" style="height: 380px; 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("monthlyBarChart", {
        animationEnabled: true,
        theme: "light2",
        title:{
            text: "{{ getAuthCompanyName() }} ({{ $year }}) - P&L Monthly Chart"
        },
        axisX:{
            title: "Months"
        },
        axisY:{
            title: "Amount ($)",
            includeZero: true
        },
        toolTip:{
            shared: true
        },
        legend:{
            cursor: "pointer",
            verticalAlign: "top"
        },
        data: [

            {
                type: "column",
                name: "Income",
                showInLegend: true,
                color: "#28a745",
                dataPoints: [
                    @foreach($months as $month)
                    { label: "{{ $month }}", y: {{ $report['income'][$month] ?? 0 }} },
                    @endforeach
                ]
            },

            {
                type: "column",
                name: "Expense",
                showInLegend: true,
                color: "#dc3545",
                dataPoints: [
                    @foreach($months as $month)
                    { label: "{{ $month }}", y: {{ $report['expense'][$month] ?? 0 }} },
                    @endforeach
                ]
            },

            {
                type: "column",
                name: "Profit",
                showInLegend: true,
                color: "#007bff",
                dataPoints: [
                    @foreach($months as $month)
                    { label: "{{ $month }}", y: {{ $report['profit'][$month] ?? 0 }} },
                    @endforeach
                ]
            }

        ]
    });

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

    // ✅ convert to 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;

        // val format: YYYY-MM
        const parts = val.split('-');
        const year  = parts[0];
        const month = parts[1];

        // first day of month
        const startDate = `${year}-${month}-01`;

        // last day of month (JS trick)
        const lastDay = new Date(year, month, 0).getDate();
        const endDate = `${year}-${month}-${lastDay}`;

        document.getElementById('start_date').value = startDate;
        document.getElementById('end_date').value   = endDate;
    }
    const monthInput = document.getElementById('year');

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

    // on page load
    applyYearFromMonth(monthInput.value);
});
</script>
    <script>
        // document.getElementById('printButton').addEventListener('click', function() {
        //     window.print();
        // });

        // $(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).ready(function () {

        //     function applyMonth(date) {
        //         let start = moment(date).startOf('month');
        //         let end   = moment(date).endOf('month');

        //         $('#range span').text(start.format('MMMM YYYY'));
        //         $('#start_date').val(start.format('YYYY-MM-DD'));
        //         $('#end_date').val(end.format('YYYY-MM-DD'));
        //     }

        //     $('#range').daterangepicker({
        //         singleDatePicker: true,
        //         showDropdowns: true,
        //         autoApply: true,
        //         linkedCalendars: false,
        //         locale: {
        //             format: 'MM/YYYY'
        //         }
        //     });

        //     // when month changes
        //     $('#range').on('apply.daterangepicker', function (ev, picker) {
        //         applyMonth(picker.startDate);
        //     });

        //     // default load (current month OR selected month)
        //     @if(!empty($startDate))
        //         applyMonth(moment("{{ $startDate }}"));
        //     @else
        //         applyMonth(moment());
        //     @endif
        // });

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