@extends('layouts.master')
<style>
    .table-bordered td, .table-bordered th{ border:1px solid #00000042 !important; font-size: 13px !important; }
    .first-table td, .first-table th{ font-size: 13px !important; }
    .form-control { appearance: auto  !important; }

    @media print {
            #kt_header {
                display: none;
            }

            #kt_footer {
                display: none;
            }

            #backbtn,
            #yearDropdown,
            #dropdownMenuButton1,
            #printandyeardropdown,
            #truckreporthead {
                display: none;
            }
        }

</style>
@section('content')
    <div class="content d-flex flex-column flex-column-fluid" id="kt_content">
        <div id="kt_content_container" class="container-xxl">
            <div class="d-flex flex-wrap flex-stack pb-7">
            <h3 class="text-muted" id="pdfhead" style="display:none">Profit and Loss Summary Report</h3>
                <div class="d-flex flex-wrap align-items-center my-1"  id="topheadsection">
                    <h3 class="fw-bold me-5 my-1" id="truckreporthead">Profit and Loss Summary <span class="text-muted">Report</span>
                    </h3>
                    <a id="backbtn" href="{{ route('assets.trucks.edit',$truck->truck_id) }}" class="btn btn-primary btn-sm me-2"><i
                    class="fa fa-arrow-left" aria-hidden="true"></i>Back</a>

                                    <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'); 
                                                $selectedYear = request()->get('year') ?? $currentYear; // Default to current year if not selected
                                                $startYear = 2019; // Set your starting year
                                            @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);" onclick="window.print()" id="printButton">Print</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" href="{{ route('assets.trucks.monthlytruckSummeryReport',$truck->truck_id) }}?year={{$cur_year}}" class="btn btn-primary btn-sm me-2">Pdf</a> </li>
                                        <!-- <li><a class="dropdown-item" href="{{ route('assets.trucks.profitsummeryForTurckCsv',$truck->truck_id) }}?year={{$cur_year}}" class="btn btn-primary btn-sm me-2">Csv</a> </li> -->
                                        <li><a class="dropdown-item" href="{{ route('assets.trucks.profitTruckSummeryReportExcel',$truck->truck_id) }}?year={{$cur_year}}" class="btn btn-primary btn-sm me-2">Excel</a> </li>
                                    </ul>
                                    <a id="backbtn" target="_blank" href="{{ route('assets.trucks.edit',$truck->truck_id) }}" class="btn btn-primary btn-sm ms-2">View Truck #{{$truck->UNIT_ID}}</a>
                                    <a href="{{ route('assets.trucks.profitAndLossReport',$truck->truck_id) }}?year={{$cur_year}}" target="_blank" class="btn btn-primary btn-sm ms-2">Summary Report Details</a>
                    <h3 class="fw-bold me-5 my-1"></h3>
                </div>
            </div>
            <div class="card card-flush">
                <div class="card-body">
                    <div class=" pb-lg-11 pb-7">
                        <div class="container">
                                <div class="modal-body">
                                        <div  style="margin:0 auto;text-align:center;"> <span  style="font-weight: bold; font-size: 20px; margin-top: 9px;">{{ getAuthCompanyName() }} - Truck#({{$truck->UNIT_ID}})</span></div>
                                        <h3 style="color:green">Profit and Loss Summary Report</h3>
                                        <hr>    
                                        <div class="row">
                                        <table class="table first-table" width="100%">
                                                <tr>
                                                   <td><b>Year:</b> {{$truck->year}}</td>
                                                   <td><b>Status:</b> {{$truck->status}}</td>
                                                   <td><b>Operator:</b> {{$truck->driver_name}}</td>
                                                   <td><b>Registration Expiration:</b> {{ ($truck->LIC_1_EXP_DATE && $truck->LIC_1_EXP_DATE != '0000-00-00 00:00:00') ? date('m/d/Y',strtotime($truck->LIC_1_EXP_DATE)) : ''}}</td>

                                                </tr>
                                                <tr>
                                                    <td style="padding-bottom: 0px;padding-top: 0px;"><b>Make: </b>{{$truck->MAKE}}</td>
                                                    <td style="padding-bottom: 0px;padding-top: 0px;"><b>Tank capacity:</b> {{$truck->TANK_CAPACITY}}</td>
                                                    <td style="padding-bottom: 0px;padding-top: 0px;"><b>Location:</b> {{$truck->current_address}}</td>
                                                    <td style="padding-bottom: 0px;padding-top: 0px;"><b>Last Annual PM Service Date:</b> {{  ($truck->LAST_SERVICE && $truck->LAST_SERVICE != '0000-00-00 00:00:00') ? date('m/d/Y', strtotime($truck->LAST_SERVICE)) : ''}}</td>
                                                 <tr>
                                                    <td><b>Model:</b> {{$truck->MODEL}}</td>
                                                    <td><b>VIN:</b> {{$truck->VIN}}</td>
                                                    <td><b>Acquisition Date:</b>{{ ($truck->ACQUISITION_DATE && $truck->ACQUISITION_DATE != '0000-00-00 00:00:00') ? date('m/d/Y', strtotime($truck->ACQUISITION_DATE)) : '' }}</td>
                                                    <td></td>
                                                 </tr>
                                                 <tr>
                                                   <td style="padding-bottom: 0px;padding-top: 0px;"><b>Plate / Reg #:</b> {{$truck->PLATE}}</td>
                                                    <td></td>
                                                    <td></td>
                                                    <td></td>
                                                 </tr>
                                            </table>
                                              </div>
                                            <div style="display: flex; justify-content: space-between; align-items: center; padding: 10px;">
                                            <h3 style="color:green">Maintenance Cost Summary</h3>
                                            <!-- <h3 style="color: {{ $gtotal > 0 ? 'green' : ($gtotal < 0 ? 'red' : 'black') }}">Grand Total: ${{   number_format($gtotal, 2) }}</h3> -->
                                              </div>
                                            <hr>
                                            <div class="row">
                                            <table class="table table-bordered" width="100%">
                                                            <tr style="background: #388DC6;">
                                                                <th class="text-gray-500"><b>Month</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-Y') }}</b></t>
                                                                @endfor
                                                                <th class="text-gray-500"><b>Total</b></th>
                                                            </tr>
                                                            

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

                                                            @foreach ($repairTypes as $repairType)
                                                               
                                                                    @for ($month = 1; $month <= 12; $month++)
                                                                        @php
                                                                            $key = sprintf('%02d-%d', $month, $cur_year);
                                                                            $amount = $repairAmounts[$repairType->REPID][$key] ?? 0;
                                                                            $repairSubtotals[$month] += $amount;
                                                                            // $color = $amount > 0 ? 'green' : ($amount < 0 ? 'red' : '#000');
                                                                            $color = 'red';
                                                                        @endphp
                                                                     
                                                                    @endfor
                                                                    @php
                                                                        $rowTotal = $amount; 
                                                                        $gtotal += $amount;
                                                                   
                                                                    @endphp
                                                            @endforeach

                                                         
                                                                <td  style="font-weight: bold;background:#eee;"><b>REPAIR</b></td>
                                                                @php
                                                                $totalRepair = array_sum($repairSubtotals);
                                                            @endphp

                                                            @for ($month = 1; $month <= 12; $month++)
                                                                @php
                                                                    $subtotal = $repairSubtotals[$month] ?? 0;
                                                                    $color = 'red';
                                                                @endphp
                                                                <td style="font-weight: bold; background: #eee; color: {{ $color }};">
                                                                    @if($subtotal != 0)
                                                                        ${{ number_format($subtotal, 2) }}
                                                                    @endif
                                                                </td>
                                                            @endfor

                                                            <!-- Add the Total column -->
                                                            <td style="font-weight: bold; background: #eee;  color: @if($totalRepair > 0) green @else red @endif;">
                                                            
                                                                @if($totalRepair != 0)
                                                                    ${{ number_format($totalRepair, 2) }}
                                                                @endif
                                                            </td>
                                                            </tr>                                                     
                                                            @php
                                                                $expenseSubtotals = array_fill(1, 12, 0);
                                                                $driverpaySubtotals = array_fill(1, 12, 0);
                                                            @endphp

                                                            @foreach ($expenseTypes as $expenseType)
                                                                <tr>
                                                                    @if($type->EXPID == $expenseType->EXPID)
                                                                        <td><b>{{ strtoupper($expenseType->NAME."+ load driver pay") }}</b></td>
                                                                    @endif

                                                                    @php
                                                                        $totalExpenseForType = 0; // Initialize total for this expense type
                                                                    @endphp

                                                                    @for ($month = 1; $month <= 12; $month++)
                                                                        @php
                                                                            $key = sprintf('%02d-%d', $month, $cur_year);
                                                                            $amount = $expenseAmounts[$expenseType->EXPID][$key] ?? 0;

                                                                            $expenseSubtotals[$month] += $amount;
                                                                            
                                                                            if ($type->EXPID != $expenseType->EXPID) {
                                                                                $driverpaySubtotals[$month] += $amount;
                                                                            }

                                                                            $color = 'red';
                                                                            $totalExpenseForType += $amount; 
                                                                        @endphp

                                                                        @if($type->EXPID == $expenseType->EXPID)
                                                                            <td style="color: {{ $color }}">
                                                                                @if(!empty($amount)) ${{ number_format($amount, 2) }} @endif
                                                                            </td>
                                                                        @endif
                                                                    @endfor

                                                                    <!-- Add Total column for this expense type -->
                                                                    @if($type->EXPID == $expenseType->EXPID)
                                                                            
                                                                        <td style="font-weight: bold; color: @if($totalExpenseForType > 0) green @else red @endif">
                                                                            @if($totalExpenseForType != 0)
                                                                                ${{ number_format($totalExpenseForType, 2) }}
                                                                            @endif
                                                                        </td>
                                                                    @endif
                                                                    
                                                                </tr>
                                                            @endforeach


                                                            <tr>
                                                        <td style="font-weight: bold; background:#eee;"><b>EXPENSE</b></td>
                                                        @php
                                                                $totalexpense = array_sum($driverpaySubtotals);
                                                            @endphp
                                                        @for ($month = 1; $month <= 12; $month++)
                                                   
                                                            @php
                                                                $subtotal = $driverpaySubtotals[$month] ?? 0;
                                                                $color = $subtotal != 0 ? 'red' : 'black'; // Adjust color logic as needed
                                                            @endphp
                                                            <td style="font-weight: bold; background: #eee; color: {{ $color }};">
                                                                @if($subtotal != 0)
                                                                    ${{ number_format($subtotal, 2) }}
                                                                @endif
                                                            </td>
                                                        @endfor
                                                        <td style="font-weight: bold; background: #eee; color: @if($totalexpense > 0) green @else red @endif">
                                                                            @if($totalexpense != 0)
                                                                                ${{ number_format($totalexpense, 2) }}
                                                                            @endif
                                                            </td>
                                                    </tr>
                                                            <tr>
                                                                <td><b>INCOME</b></td>
                                                                @php
                                                                $totalincome = array_sum($loadAmounts['income']);
                                                            
                                                             @endphp
                                                                @for ($month = 1; $month <= 12; $month++)
                                                                    @php
                                                                        $key = sprintf('%02d-%d', $month, $cur_year);
                                                                        $income = $loadAmounts['income'][$key] ?? '';
                                                                        $color = $income > 0 ? 'green' : ($income < 0 ? 'red' : '#000');

                                                                    @endphp
                                                                    <td style="color: green"><b>  {{$income ? '$'.number_format($income, 2) : '' }} </b></td>
                                                                @endfor
                                                                <td style="font-weight: bold; color: @if($totalincome > 0) green @else red @endif">
                                                                            @if($totalexpense != 0)
                                                                                ${{ number_format($totalincome, 2) }}
                                                                            @endif
                                                            </td>
                                                            </tr>
                                                            <tr style="background: #ddd;">
                                                                    <td><b>TOTAL MAINTENANCE + EXPENSES</b></td>

                                                                    @php
                                                                        $totalMaintenance = 0;
                                                                    @endphp

                                                                    @for ($month = 1; $month <= 12; $month++)
                                                                        @php
                                                                            $maintenance = ($repairSubtotals[$month] ?? 0) + ($expenseSubtotals[$month] ?? 0);
                                                                            $totalMaintenance += $maintenance;
                                                                            $color = 'red';
                                                                        @endphp
                                                                        <td style="color: {{ $color }};"><b>{{ $maintenance != 0 ? '$' . number_format($maintenance, 2) : '' }}</b></td>
                                                                    @endfor

                                                                    <!-- Grand Total -->
                                                                    <td style="font-weight: bold; background: #eee; color: @if($totalMaintenance > 0) green @else red @endif">
                                                                        @if($totalMaintenance != 0)
                                                                            ${{ number_format($totalMaintenance, 2) }}
                                                                        @endif
                                                                    </td>
                                                                </tr>

                                                                <tr>
    <td><b>PROFIT</b></td>

    @php
        $totalProfit = 0; // Initialize total profit
    @endphp

    @for ($month = 1; $month <= 12; $month++)
        @php
            $key = sprintf('%02d-%d', $month, $cur_year);
            $income = $loadAmounts['income'][$key] ?? 0;
            $maintenance = ($repairSubtotals[$month] ?? 0) + ($expenseSubtotals[$month] ?? 0);

            $profit = $income - $maintenance;
            $totalProfit += $profit;
        @endphp

        <td style="color: {{ $profit > 0 ? 'green' : ($profit < 0 ? 'red' : '#000') }};">
            <b>{{ $profit != 0 ? '$'.number_format($profit, 2) : '' }}</b>
        </td>
    @endfor

    <!-- Grand Total Profit -->
    <td style="font-weight: bold; color: {{ $totalProfit > 0 ? 'green' : ($totalProfit < 0 ? 'red' : '#000') }};">
        @if($totalProfit != 0)
            ${{ number_format($totalProfit, 2) }}
        @endif
    </td>
</tr>

                                                                                                                          

                                                                <tr style="background: #ddd;">
                                                                    <td><b>GRAND TOTAL</b></td>
                                                                    <td colspan="13">
                                                                        <b><h4 style="color:
                                                                                {{ $totalProfit > 0 ? 'green' : ($totalProfit < 0 ? 'red' : 'black') }}">
                                                                                ${{ number_format($totalProfit, 2) }}
                                                                            </h4>
                                                                        </b>
                                                                    </td>
                                                                </tr>

                                                        </table>
                                            </div>

                                        </div>
                                </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>

@endsection()
@section('script')
    <script>
        $('.datetimepicker').daterangepicker({
            timePicker: false ,
            singleDatePicker: true,
            locale: {
                format: 'MM/DD/YYYY'
            }
        });

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

        document.getElementById('year').addEventListener('change', function() {
        const selectedYear = this.value;
        var truckId = "{{ $truck->truck_id }}"; // This should be set by your server-side code
        var year = selectedYear; // This should be a JavaScript variable
        var baseUrl = "{{ route('assets.trucks.truckSummeryReport', $truck->truck_id) }}";
        var fullUrl = baseUrl + "?year=" + encodeURIComponent(year);
        location.href = fullUrl;
});
    </script>
@endsection