@section('title', 'Reports')

@section('top-menu-items')
    <x-partials.top-menu-item name="Orders" route="orders" />
    <x-partials.top-menu-item name="Block Bookings" route="block-booking" />
    <x-partials.top-menu-item name="Invoices" route="invoices" />
        <div class="menu-item here show menu-lg-down-accordion me-lg-1">
        <a class="menu_link py-3 " style="background: #F3F3F3; color: #F4404B" href="/reports/daily-sales" wire:navigate>
            <span class="menu-title">Reports</span>
            <span class="menu-arrow d-lg-none"></span>
        </a>
    </div> 
@endsection
@section('sub-menu-items')
    <x-partials.sub-menu-item name="Daily Sales" route="reports.daily-sales" />
    <x-partials.sub-menu-item name="Aged AR" route="reports.aded-ar" />
    <x-partials.sub-menu-item name="AR Statement" route="reports.ar-statement" />
    <x-partials.sub-menu-item name="Booking Sales" route="reports.booking-sales" />
    <x-partials.sub-menu-item name="Merchandise Sales" route="reports.merchandise-sales" />
    <x-partials.sub-menu-item name="Tour Add-on Sales" route="reports.addon-sales" />
    <x-partials.sub-menu-item name="Fuel Sales" route="reports.fuel-sales" />
    <x-partials.sub-menu-item name="Discounts" route="reports.discounts" />
    <x-partials.sub-menu-item name="Commissions" route="reports.commissions" />
    <x-partials.sub-menu-item name="Flights" route="reports.flights" />
    <x-partials.sub-menu-item name="PAX Details" route="reports.pax-details" />
    <x-partials.sub-menu-item name="Weathered Bookings" route="reports.weathered-bookings" />
    <x-partials.sub-menu-item name="On Account Payments" route="reports.on-account-payments" />
    <x-partials.sub-menu-item name="Monthly Payments" route="reports.monthly-payments" />
    <x-partials.sub-menu-item name="Group Bookings" route="reports.group-bookings" />
@endsection

<div>
    <div class="content d-flex flex-column flex-column-fluid" id="kt_content">
        <!--begin::Container-->
        <div id="kt_content_container" class="container-xxl">
            <div class="tab-content" id="myTabContent">
            <div class="tab-pane fade show active p-5 mt-custom" id="kt_tab_pane_2" role="tabpanel">
                <div class="d-flex justify-content-between">
                    <div>
                        <form  wire:submit="getReport">
                            <div class="d-flex mb-5 align-items-center">
                                {{-- <input type="date" wire:model="" name="date" class="form-control-sm me-2 w-auto border border-gray-400"/>                        
                                <span style="font-weight: normal;" class="me-2">Start Date:</span> --}}
                                <span style="font-weight: normal;" class="me-2">Report Date:</span>
                                <input type="date" wire:model="report_date" name="date" class="form-control-sm me-2 w-auto border border-gray-400"/>                        
                                <span style="font-weight: normal;" class="me-2">Start Date:</span>
                                <input type="date" wire:model="start_date" name="date" class="form-control-sm me-2 w-auto border border-gray-400"/>                        
                                <span style="font-weight: normal;" class="me-2">End Date:</span>
                                <input type="date" wire:model="end_date" name="date" class="form-control-sm me-2 w-auto border border-gray-400"/>                        
                                <button class="btn btn-secondary btn-sm border border-gray-400">Update</button>
                            </div>
                        </form>
                    </div>
                    <div class="ms-2">
                        <button class="btn btn-primary btn-sm" onclick="printReport()">Print Report</button>
                          <button class="btn btn-success btn-sm mt-2" wire:click="exportReport">Export CSV</button>
                    </div>
                </div>
                <div id="printSection" class="mb-5">
                    <table class="table">
                        <thead>
                            <tr class="fw-bolder fs-6 text-gray-800 border-bottom border-gray-400">
                                <th>Company Name</th>
                                <th>Order #</th>
                                <th>Invoice #</th>
                                <th>Wp Order Id</th>
                                <th>Transaction Date</th>
                                <th>Order Balance</th>
                                <th>0-29 Days</th>
                                <th>30-59 Days</th>
                                <th>60-89 Days</th>
                                <th>90 & Over</th>
                            </tr>
                        </thead>
                        <tbody>
                           @forelse($orders ?? [] as $partnerGroup)
                                {{-- Orders under this partner --}}
                                @foreach($partnerGroup['orders'] as $order)
                                    <tr class="border-bottom border-gray-400" style="font-weight: normal;">
                                        <td>{{ $partnerGroup['partner_name'] }}</td>
                                        <td>
                                            <a href="{{ route('order.edit', $order['id']) }}" target="_blank">
                                                {{ $order['id'] }}
                                            </a>
                                        </td>
                                        <td>{{ $order['invoice_id'] }}</td>
                                        <td>{{ $order['wp_orderId'] }}</td>
                                        <td>{{ $order['date'] }}</td>
                                        <td>${{ number_format($order['balance'], 2) }}</td>
                                        <td>${{ number_format($order['bucket_0_29'], 2) }}</td>
                                        <td>${{ number_format($order['bucket_30_59'], 2) }}</td>
                                        <td>${{ number_format($order['bucket_60_89'], 2) }}</td>
                                        <td>${{ number_format($order['bucket_90_plus'], 2) }}</td>
                                    </tr>                   
                                @endforeach
                                  <tr class="fw-bolder fs-6 text-gray-800 border-bottom border-gray-400">
                                    <td colspan="4"></td>
                                    <td>${{ number_format($partnerGroup['totals']['balance'], 2) }}</td>
                                    <td>${{ number_format($partnerGroup['totals']['bucket_0_29'], 2) }}</td>
                                    <td>${{ number_format($partnerGroup['totals']['bucket_30_59'], 2) }}</td>
                                    <td>${{ number_format($partnerGroup['totals']['bucket_60_89'], 2) }}</td>
                                    <td>${{ number_format($partnerGroup['totals']['bucket_90_plus'], 2) }}</td>
                                </tr>
                            @empty
                                <tr>
                                    <td colspan="9">No records found.</td>
                                </tr>
                            @endforelse


                            {{-- Grand Total Row --}}
                            <tr class="fw-bolder fs-6 text-gray-800 border-bottom border-gray-400">
                                <td colspan="3"></td>
                                <td>Grand Total:</td>
                                <td>${{ number_format($totalBalance, 2) }}</td>
                                <td>${{ number_format($bucket_0_29, 2) }}</td>
                                <td>${{ number_format($bucket_30_59, 2) }}</td>
                                <td>${{ number_format($bucket_60_89, 2) }}</td>
                                <td>${{ number_format($bucket_90_plus, 2) }}</td>
                            </tr>
                        </tbody>
                    </table>
                </div>
            </div>
            </div>
        </div>
    </div>
</div>
@push('scripts')    
    <script src="/assets/js/custom/reports.js"></script>
@endpush