@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 Statement
                        <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.loads.allLoadsMonthReport') }}" class="d-flex align-items-center mt-3" id="searchFrom">
                        <div id="range" class="me-2"
                            style="background: #fff; cursor: pointer; padding: 5px 10px; border: 1px solid #ccc; width: 151px">
                            <i class="fa fa-calendar"></i>&nbsp;
                            <span></span> <i class="fa fa-caret-down"></i>
                        </div>
                        <input type="hidden" class="form-control sm" name="start_date" id="start_date">
                        <input type="hidden" class="form-control sm" name="end_date" id="end_date">
                        <button type="submit" class="btn btn-primary btn-sm me-2">Search</button>
                        <a class="btn btn-primary btn-sm me-2 ms-10" href="javascript:void(0);" id="printButton">Print</a>
                        <a 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">Clear</a>
                    </form>
                    <a href="{{ route('assets.loads.allLoadReport') }}" class="btn btn-primary btn-sm me-2"id="report_link" target="_blank">Trucks P&L 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.loads.allLoadsMonthReportpdf', ['start_date' => $startDate, 'end_date' => $endDate]) }}">
                                            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'); 
                                $enddate = request('end_date') ?: date('Y-m-t'); 

                                    // Format dates using PHP's DateTime class
                                    $formattedStartDate = $startdate ? (new DateTime($startdate))->format('m/d/Y') : '';
                                    $formattedEndDate = $enddate ? (new DateTime($enddate))->format('m/d/Y') : '';
                                @endphp

                                <div style="margin:0 auto;text-align:center;">
                                    <h3>P&L Report @php echo "(" . $formattedStartDate . " - " . $formattedEndDate . ")" @endphp </h3>
                                </div>

                                <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" width="100%">
                                            <tr style="background: #388DC6;">
                                                <td></td>
                                                @php
                                                    $repair_type_totals = 0;
                                                    $expense_type_totals = 0;
                                                @endphp
                                                <th class="text-uppercase text-gray-500"><b class="float-end">Amount</b></t>
                                            </tr>
                                            <tr>
                                                <td class="text-uppercase"><b><a target="_blank"
                                                            href="{{ route('assets.loads.index') }}?delivery_start_date={{ $startDate }}&delivery_end_date={{ $endDate }}&request_status=All"
                                                            class="text-dark">INCOME - LOADS</a></b></td>
                                                <td>
                                                    @if (!empty($income))
                                                        <b class="float-end"><a target="_blank" href="{{ route('assets.loads.index') }}?delivery_start_date={{ $startDate }}&delivery_end_date={{ $endDate }}&request_status=All"
                                                                class="{{ $income >= 0 ? 'text-success' : 'text-danger' }}">$
                                                                {{ number_format($income, 2) }}</a></b>
                                                    @else
                                                        <b class="float-end"><a target="_blank" href="{{ route('assets.loads.index') }}?delivery_start_date={{ $startDate }}&delivery_end_date={{ $endDate }}&request_status=All"
                                                                class="text-dark">$ 0.00</a></b>
                                                    @endif
                                                </td>
                                            </tr>
                                            <tr style="background:#388DC6">
                                                <td class="text-uppercase" colspan="2">
                                                    <b class="header_text_color">REPAIR TYPE</b>
                                                </td>
                                            </tr>
                                            @foreach ($truck_issues_new as $truck_issues)
                                                @if (isset($repair_type_array_new[$truck_issues->Type]))
                                                    @php
                                                        $repair_type_totals += $truck_issues->total_amount;
                                                    @endphp
                                                    <tr>
                                                        <td class="text-uppercase">
                                                            <b>
                                                                <a class="text-dark" target="_blank"
                                                                    href="{{ route('assets.repair.index') }}?start_date={{ $startDate }}&end_date={{ $endDate }}&Type={{ $truck_issues->Type }}">
                                                                    {{ strtoupper($repair_type_array_new[$truck_issues->Type]) }}
                                                                </a>
                                                            </b>
                                                        </td>
                                                        <td>
                                                            <b class="float-end"><a class="text-danger" target="_blank"
                                                                    href="{{ route('assets.repair.index') }}?start_date={{ $startDate }}&end_date={{ $endDate }}&Type={{ $truck_issues->Type }}">$
                                                                    {{ number_format($truck_issues->total_amount, 2) }}</a>
                                                            </b>
                                                        </td>
                                                    </tr>
                                                @endif
                                            @endforeach
                                            <tr style="background: #00000021;">
                                                <td class="text-uppercase"><b><a target="_blank"
                                                            href="{{ route('assets.repair.index') }}?start_date={{ $startDate }}&end_date={{ $endDate }}"
                                                            class="text-dark">REPAIR SUBTOTAL</a></b></td>
                                                <td>
                                                    <b class="float-end"><a target="_blank" href="{{ route('assets.repair.index') }}?start_date={{ $startDate }}&end_date={{ $endDate }}"
                                                            class="text-danger">$
                                                            {{ number_format($repair_type_totals, 2) }}</a></b>
                                                </td>
                                            </tr>
                                            <tr style="background:#388DC6">
                                                <td class="text-uppercase" colspan="2">
                                                    <b class="header_text_color">EXPENSE TYPE</b>
                                                </td>
                                            </tr>
                                            @foreach ($truck_expense_new as $truck_expense)
                                                @if (isset($expense_type_array_new[$truck_expense->TYPE]))
                                                    @php
                                                        $expense_type_totals += $truck_expense->total_amount;
                                                    @endphp
                                                    <tr>
                                                        <td class="text-uppercase"><b><a class="text-dark" target="_blank"
                                                                    href="{{ route('assets.expense.index') }}?start_date={{ $startDate }}&end_date={{ $endDate }}&Type={{ $truck_expense->TYPE }}">{{ strtoupper($expense_type_array_new[$truck_expense->TYPE]) }}</a></b>
                                                        </td>
                                                        <td>
                                                            <b class="float-end"><a class="text-danger" target="_blank"
                                                                    href="{{ route('assets.expense.index') }}?start_date={{ $startDate }}&end_date={{ $endDate }}&Type={{ $truck_expense->TYPE }}">$
                                                                    {{ number_format($truck_expense->total_amount, 2) }}</a></b>
                                                        </td>
                                                    </tr>
                                                @endif
                                            @endforeach
                                            <tr style="background: #00000021;">
                                                <td class="text-uppercase"><b><a target="_blank"
                                                            href="{{ route('assets.expense.index') }}?start_date={{ $startDate }}&end_date={{ $endDate }}"
                                                            class="text-dark">EXPENSE SUBTOTAL</a></b></td>
                                                <td class="text-danger">
                                                    <b class="float-end"><a target="_blank" href="{{ route('assets.expense.index') }}?start_date={{ $startDate }}&end_date={{ $endDate }}"
                                                            class="text-danger">$
                                                            {{ number_format($expense_type_totals, 2) }}</a></b>
                                                </td>
                                            </tr>
                                            @php
                                                $repair_expense_subtotal = $repair_type_totals + $expense_type_totals;
                                                $profit = $income - $repair_type_totals - $expense_type_totals;
                                            @endphp
                                            <tr style="background: #00000021;">
                                                <td class="text-uppercase text-dark"><b>REPAIR + EXPENSE SUBTOTAL</b></td>
                                                <td class="text-danger">
                                                    <b class="float-end">$ {{ number_format($repair_expense_subtotal, 2) }}</b>
                                                </td>
                                            </tr>
                                            <tr>
                                                <td class="text-uppercase"><b>PROFIT</b></td>
                                                <td class="text-danger">
                                                    <b class="float-end {{ $profit > 0 ? 'text-success' : 'text-danger' }}">$
                                                        {{ number_format($profit, 2) }}</b>
                                                </td>
                                            </tr>
                                        </table>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
@endsection()
@section('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.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.loads.allLoadsMonthReport') }}";
            const fullUrl = baseUrl + "?year=" + encodeURIComponent(selectedYear);
            location.href = fullUrl;
        });
    }

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

    </script>
@endsection