@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_11" role="tabpanel">
                    <div class="d-flex justify-content-between">
                        <form wire:submit="getReport">
                            <div class="d-flex mb-5 align-items-center">
                                <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>
                            <button class="btn btn-primary btn-sm" onclick="printReport()">Print report</button>
                            <button class="btn btn-success btn-sm" wire:click="exportReport">Export CSV</button>
                        </div>
                    </div>
                    <div id="printSection" class="mb-5">
                        <div>
                            <h3 class="py-3">PAX Details</h3>
                        </div>
                        <div class="table-responsive">
                            <table class="table">
                                <thead>
                                    <tr class="fw-bolder fs-6 text-gray-800 border-bottom border-gray-400">
                                        <th>Transaction Date</th>
                                        <th>Order #</th>
                                        <th>Wp Order Id</th>
                                        <th>Company</th>
                                        <th>Product</th>
                                        <th>Quantity</th>
                                        <th>Origin City</th>
                                        <th>Origin Province</th>
                                        <th>Origin Country</th>
                                        <th>Stay Night Before</th>
                                        <th>Stay Night After</th>
                                        <th>Referral Source</th>
                                    </tr>
                                </thead>
                                <tbody>
                                    @forelse($orders ?? [] as $order)
                                    @foreach($order->booking_details ?? [] as $detail)
                                    <tr class="border-bottom border-gray-400" style="font-weight: normal;">
                                        <td>
                                            {{ $order->bookings->min('booking_date') 
                                            ? \Carbon\Carbon::parse($order->bookings->min('booking_date'))->format('Y-m-d') 
                                            : '--' }}
                                        </td>

                                        <td>
                                            <a href="{{ route('order.edit', $order->id) }}" target="_blank">
                                                {{ $order->id }}
                                            </a>
                                        </td>
                                        <td>{{ $order->wp_order_id }} </td>
                                        <td>
                                            @if(!empty($order->partner_organization_name ))
                                                {{ $order->partner_organization_name }}
                                            @else
                                                Cash Customer
                                            @endif

                                        </td>
                                        <td>
                                            @if($detail['tour_id'])
                                            <a href="{{ route('tours.edit', ['tour' => $detail['tour_id']]) }}" wire:navigate>
                                                {{ $detail['tour_name'] }}
                                            </a>
                                            @else
                                            {{ $detail['tour_name'] ?? 'N/A' }}
                                            @endif


                                        </td>
                                        <td>{{ $detail['passenger_count'] }}</td>
                                        <td>{{ !empty($order->orderable->city) ? $order->orderable->city : '--' }}</td>
                                        <td>{{ !empty($order->orderable->province) ? $order->orderable->province : '--' }}</td>
                                        <td>{{ !empty($order->orderable->country) ? $order->orderable->country : '--' }}</td>
                                        <td>{{ !empty($order->before_stay_address) ? $order->before_stay_address : '--' }}</td>
                                        <td>{{ !empty($order->after_stay_address) ? $order->after_stay_address : '--' }}</td>
                                        <td style="white-space: normal !important; word-break: break-word !important; max-width: 500px;">
                                            {{ ($order->orderable->referral_source && $order->orderable->referral_source !== '0') ? $order->orderable->referral_source : '' }}
                                        </td>
                                    </tr>
                                    @endforeach
                                    @endforeach
                                </tbody>
                            </table>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>
@push('styles')
<style>
    /* Keep table within container */
    .table-responsive {
        width: 100%;
        overflow-x: auto;
    }

    /* Force equal column widths and wrapping */
    .table {
        table-layout: fixed !important;
        width: 100% !important;
        border-collapse: collapse;
    }

    /* Control cell text overflow */
    .table th,
    .table td {
        white-space: normal !important;
        word-break: break-word !important;
        vertical-align: top;
        padding: 8px;
        max-width: 180px;
    }

    /* Optional: Add scroll on small screens */
    @media (max-width: 992px) {
        #printSection {
            overflow-x: auto;
        }
    }
</style>
@endpush

@push('scripts')
<script src="/assets/js/custom/reports.js"></script>
@endpush