@extends('layouts.app')

@section('title', 'Incentive Report')

@push('styles')
    <link rel="stylesheet"
        href="https://cdn.jsdelivr.net/npm/bootstrap-datepicker@1.9.0/dist/css/bootstrap-datepicker3.min.css">
    <style>
        .pagination-wrapper nav {
            display: inline-block;
            box-shadow: 0 2px 8px rgba(0, 0, 0, 0.1);
            border-radius: 8px;
            background: #fff;
        }

        .pagination-wrapper .page-link {
            border-radius: 6px !important;
            padding: 6px 12px;
        }

        .pagination-wrapper .page-item.active .page-link {
            background-color: #0d6efd;
            border-color: #0d6efd;
            color: #fff;
        }

        .export-buttons {
            display: flex;
            gap: 10px;
            margin-bottom: 15px;
        }

        .export-btn {
            padding: 8px 16px;
            border-radius: 6px;
            font-weight: 500;
            display: flex;
            align-items: center;
            gap: 5px;
        }

        .toast {
            z-index: 9999 !important;
        }

        /* Datepicker Styles - Fixed */
        .datepicker {
            z-index: 1055 !important;
        }

        .datepicker-dropdown {
            padding: 10px;
            border-radius: 8px;
            box-shadow: 0 5px 15px rgba(0, 0, 0, 0.2);
        }

        .datepicker table tr td,
        .datepicker table tr th {
            border-radius: 4px;
            width: 35px;
            height: 35px;
        }

        .datepicker table tr td.active,
        .datepicker table tr td.active:hover,
        .datepicker table tr td.active.highlighted {
            background-color: #0d6efd !important;
            border-color: #0d6efd !important;
            color: #fff !important;
        }

        .datepicker table tr td.today,
        .datepicker table tr td.today:hover {
            background-color: #ffc107 !important;
            color: #000 !important;
        }

        .datepicker table tr td.day:hover {
            background-color: #e9ecef;
            cursor: pointer;
        }

        /* Make input clickable */
        .datepicker-input {
            background-color: #fff !important;
            cursor: pointer;
        }
    </style>
@endpush

@section('content')
    <main class="app-main">

        <!-- Header -->
        <div class="app-content-header">
            <div class="container-fluid">
                <div class="row">
                    <div class="col-sm-6">
                        <h3 class="mb-0">Incentive Details Report</h3>
                    </div>
                    <div class="col-sm-6">
                        <ol class="breadcrumb float-sm-end">
                            <li class="breadcrumb-item">
                                <a href="/dashboard"><i class="bi bi-house"></i> Home</a>
                            </li>
                            <li class="breadcrumb-item active" aria-current="page">Incentive Report</li>
                        </ol>
                    </div>
                </div>
            </div>
        </div>

        <div class="app-content">
            <div class="container-fluid">

                <div class="row">
                    <div class="col-md-12">

                        @include('common.alerts')

                        <!-- Card -->
                        <div class="card shadow-sm border-0 mb-4">
                            <div class="card-body">

                                <div class="row mb-3">

                                    <!-- Export Buttons -->
                                    <div class="col-md-6">
                                        <div class="d-flex gap-2">
                                            <button type="button" class="btn btn-success" id="exportExcelBtn">
                                                <i class="bi bi-file-earmark-excel"></i> Export to Excel
                                            </button>
                                            <button type="button" class="btn btn-danger" id="exportPdfBtn">
                                                <i class="bi bi-file-earmark-pdf"></i> Export to PDF
                                            </button>
                                            <button type="button" class="btn btn-info" id="exportCsvBtn">
                                                <i class="bi bi-filetype-csv"></i> Export to CSV
                                            </button>
                                        </div>
                                    </div>

                                    <!-- Date Range Search -->
                                    <!-- Date Range Search -->
                                    <!-- Date Range Search -->
                                    <div class="col-md-6">
                                        <form action="{{ route('report.report_intencive') }}" method="get"
                                            id="dateFilterForm">
                                            <div class="input-group">
                                                <span class="input-group-text" style="cursor: pointer;">
                                                    <i class="bi bi-calendar"></i>
                                                </span>
                                                <input type="text" class="form-control datepicker-input" name="from"
                                                    placeholder="From Date (YYYY-MM-DD)" value="{{ request('from') }}"
                                                    id="fromDate" autocomplete="off">

                                                <span class="input-group-text" style="cursor: pointer;">
                                                    <i class="bi bi-calendar"></i>
                                                </span>
                                                <input type="text" class="form-control datepicker-input" name="to"
                                                    placeholder="To Date (YYYY-MM-DD)" value="{{ request('to') }}"
                                                    id="toDate" autocomplete="off">

                                                <button type="submit" class="btn btn-primary">
                                                    <i class="bi bi-search"></i> Search
                                                </button>
                                                <button type="button" class="btn btn-secondary" id="resetDates">
                                                    <i class="bi bi-arrow-clockwise"></i> Reset
                                                </button>
                                            </div>
                                        </form>
                                    </div>

                                </div>

                                @php
                                    function ordinal($number)
                                    {
                                        if (!$number) {
                                            return '-';
                                        }
                                        $ends = ['th', 'st', 'nd', 'rd', 'th', 'th', 'th', 'th', 'th', 'th'];
                                        if ($number % 100 >= 11 && $number % 100 <= 13) {
                                            return $number . 'th';
                                        }
                                        return $number . $ends[$number % 10];
                                    }

                                    // Get all main IDs first
                                    $mainIds = $get_outward_data->pluck('id')->toArray();

                                    // Fetch all sub data at once (outside the loop for better performance)
                                    $all_sub_data = [];
                                    if (!empty($mainIds)) {
                                        $all_sub_data = DB::table('Outwardmodel_type1_t2s')
                                            ->whereIn('outward_id', $mainIds)
                                            ->leftJoin(
                                                'customers',
                                                'customers.customers',
                                                '=',
                                                'Outwardmodel_type1_t2s.customer_se',
                                            )
                                            ->select(
                                                'Outwardmodel_type1_t2s.*',
                                                'customers.customers_name',
                                                'customers.type',
                                                'customers.distance',
                                            )
                                            ->get()
                                            ->groupBy('outward_id');
                                    }
                                    $previous_date = null;
                                @endphp

                                <!-- Data Table -->
                                <div class="table-responsive">
                                    <table class="table table-bordered table-hover table-striped align-middle mb-0"
                                        style="width:250%;" id="incentiveTable">
                                        <thead class="table-light">
                                            <tr>
                                                <th>#</th>
                                                <th>Date</th>
                                                <th>OUT No</th>
                                                <th>AOD No</th>
                                                <th>Customer Names</th>
                                                <th>D/Trip</th>
                                                <th>Driver</th>
                                                <th>D/EPF No</th>
                                                <th>H/Trip</th>
                                                <th>Helper</th>
                                                <th>H/EPF NO</th>
                                                <th>Vehicle</th>
                                                <th>D Trip Fee</th>
                                                <th>H Trip Fee</th>
                                                <th>D Breakfast</th>
                                                <th>H Breakfast</th>
                                                <th>D Lunch</th>
                                                <th>H Lunch</th>
                                                <th>D Dinner</th>
                                                <th>H Dinner</th>
                                                <th>D B.C./5MT</th>
                                                <th>H B.C./5MT</th>
                                                <th>D Good Return</th>
                                                <th>H Good Return</th>
                                                <th>D Pallet</th>
                                                <th>H Pallet</th>
                                                <th>D Unload</th>
                                                <th>H Unload</th>
                                                <th>D N Allowance</th>
                                                <th>H N Allowance</th>
                                                <th>D Total</th>
                                                <th>H Total</th>

                                            </tr>
                                        </thead>

                                        <tbody>
                                            @php
                                                $grand_driver_total = 0;
                                                $grand_helper_total = 0;
                                            @endphp
                                            @forelse ($get_outward_data as $key => $data)
                                                @php
                                                    $sub_items = $all_sub_data[$data->id] ?? collect([]);
                                                    $customer_names = $sub_items
                                                        ->pluck('customers_name')
                                                        ->filter()
                                                        ->implode('/ ');

                                                    // 1. Get all unique types
                                                    $all_types = $sub_items->pluck('type')->filter()->unique()->all();

                                                    // 2. Define priority (C > B > A). Add other types if needed.
                                                    $type_priority = ['C', 'B', 'A'];
                                                    $selected_type = null;

                                                    // 3. Find the highest-ranking type
                                                    foreach ($type_priority as $priority_type) {
                                                        if (in_array($priority_type, $all_types)) {
                                                            $selected_type = $priority_type;
                                                            break; // Found the highest priority type, stop searching
                                                        }
                                                    }

                                                    // Use the selected type for the lookup, or default to the original logic if no priority type is found (e.g., if you have other types like 'D', 'E', etc.)
                                                    $customer_type =
                                                        $selected_type ??
                                                        ($sub_items->pluck('type')->filter()->first() ?? null);
                                                    $customer_distance = $sub_items
                                                        ->pluck('distance')
                                                        ->filter()
                                                        ->implode('/ ');

                                                    $aod = $sub_items->pluck('aod_td')->filter()->implode('/ ');

                                                    $trip_no_d = $data->driver_trip_no ?? null;
                                                    $trip_no_h = $data->helper_trip_no ?? null;
                                                    $distance = intval($customer_distance ?? 0);

                                                    $weight = intval($data->weight ?? 0);

                                                    // Fetch driver amount
                                                    $trip_fee_driver = DB::table('payment_cons')
                                                        ->where('type', $customer_type)
                                                        ->where('trip', $trip_no_d)
                                                        ->where('km_min', '<=', $distance)
                                                        ->where('km_max', '>=', $distance)
                                                        ->where('weight_min', '<=', $weight)
                                                        ->where('weight_max', '>=', $weight)
                                                        ->value('driver_amount'); // returns single value

                                                    // Fetch helper amount
                                                    $trip_fee_helper = DB::table('payment_cons')
                                                        ->where('type', $customer_type)
                                                        ->where('trip', $trip_no_h)
                                                        ->where('km_min', '<=', $distance)
                                                        ->where('km_max', '>=', $distance)
                                                        ->where('weight_min', '<=', $weight)
                                                        ->where('weight_max', '>=', $weight)
                                                        ->value('helper_amount');

                                                    $lunch_hour = '13:00';
                                                    $d_lunch_payment = 0; // Initialize lunch payment

                                                    if (!empty($data->time_in) && !empty($data->time_out)) {
                                                        if (
                                                            $data->time_in >= $lunch_hour &&
                                                            $data->time_out <= $lunch_hour
                                                        ) {
                                                            $d_lunch_payment = DB::table('other_payments')
                                                                ->where('payment_type', 'Lunch')
                                                                ->value('driver_amount');
                                                        }
                                                    }

                                                    $d_lunch = $d_lunch_payment > 0 ? $d_lunch_payment : '-';

                                                    $h_lunch_payment = 0; // Initialize lunch payment

                                                    if (!empty($data->time_in) && !empty($data->time_out)) {
                                                        if (
                                                            $data->time_in >= $lunch_hour &&
                                                            $data->time_out <= $lunch_hour
                                                        ) {
                                                            $h_lunch_payment = DB::table('other_payments')
                                                                ->where('payment_type', 'Lunch')
                                                                ->value('helper_amount');
                                                        }
                                                    }

                                                    $h_lunch = $h_lunch_payment > 0 ? $h_lunch_payment : '-';

                                                    $break_hour = '8:00';
                                                    $d_break_payment = 0; // Initialize break payment

                                                    if (!empty($data->time_in) && !empty($data->time_out)) {
                                                        if (
                                                            $data->time_in >= $break_hour &&
                                                            $data->time_out <= $break_hour
                                                        ) {
                                                            $d_break_payment = DB::table('other_payments')
                                                                ->where('payment_type', 'Breakfast')
                                                                ->value('driver_amount');
                                                        }
                                                    }

                                                    $d_break = $d_break_payment > 0 ? $d_break_payment : '-';

                                                    $h_break_payment = 0; // Initialize break payment

                                                    if (!empty($data->time_in) && !empty($data->time_out)) {
                                                        if (
                                                            $data->time_in >= $break_hour &&
                                                            $data->time_out <= $break_hour
                                                        ) {
                                                            $h_break_payment = DB::table('other_payments')
                                                                ->where('payment_type', 'Breakfast')
                                                                ->value('helper_amount');
                                                        }
                                                    }

                                                    $h_break = $h_break_payment > 0 ? $h_break_payment : '-';
                                                    $dinner_hour = '20:00';
                                                    $dinner_start = '20:00';
                                                    $dinner_end = '00:00'; // midnight
                                                    $d_dinner_payment = 0; // Initialize dinner payment

                                                    if (!empty($data->time_in) && !empty($data->time_out)) {
                                                        $timeIn = strtotime($data->time_in);
                                                        $timeOut = strtotime($data->time_out);

                                                        // Convert dinner start to today
                                                        $dinnerStartTime = strtotime($dinner_start);
                                                        $dinnerEndTime = strtotime($dinner_end);

                                                        // Handle the case where dinner_end is after midnight
                                                        if ($dinnerEndTime < $dinnerStartTime) {
                                                            $dinnerEndTime += 24 * 60 * 60; // add 24 hours
                                                            if ($timeOut < $timeIn) {
                                                                $timeOut += 24 * 60 * 60; // add 24 hours if shift goes past midnight
                                                            }
                                                        }

                                                        // Check if any part of the shift overlaps dinner time
                                                        if ($timeIn < $dinnerEndTime && $timeOut > $dinnerStartTime) {
                                                            $d_dinner_payment = DB::table('other_payments')
                                                                ->where('payment_type', 'Dinner')
                                                                ->value('driver_amount');
                                                        }
                                                    }

                                                    $d_dinner = $d_dinner_payment > 0 ? $d_dinner_payment : '-';

                                                    $h_dinner_payment = 0; // Initialize dinner payment

                                                    if (!empty($data->time_in) && !empty($data->time_out)) {
                                                        if (
                                                            $data->time_in >= $dinner_hour &&
                                                            $data->time_out <= $dinner_hour
                                                        ) {
                                                            $h_dinner_payment = DB::table('other_payments')
                                                                ->where('payment_type', 'Dinner')
                                                                ->value('helper_amount');
                                                        }
                                                    }

                                                    $h_dinner = $h_dinner_payment > 0 ? $h_dinner_payment : '-';

                                                    $night_hour = '00:00';
                                                    $d_night_payment = 0; // Initialize night payment

                                                    if (!empty($data->time_in) && !empty($data->time_out)) {
                                                        if (
                                                            $data->time_in >= $night_hour &&
                                                            $data->time_out <= $night_hour
                                                        ) {
                                                            $d_night_payment = DB::table('other_payments')
                                                                ->where('payment_type', 'Night allowance')
                                                                ->value('driver_amount');
                                                        }
                                                    }

                                                    $d_night = $d_night_payment > 0 ? $d_night_payment : '-';

                                                    $h_night_payment = 0; // Initialize night payment

                                                    if (!empty($data->time_in) && !empty($data->time_out)) {
                                                        if (
                                                            $data->time_in >= $night_hour &&
                                                            $data->time_out <= $night_hour
                                                        ) {
                                                            $h_night_payment = DB::table('other_payments')
                                                                ->where('payment_type', 'Night allowance')
                                                                ->value('helper_amount');
                                                        }
                                                    }

                                                    $h_night = $h_night_payment > 0 ? $h_night_payment : '-';

                                                    $h_ballclay_payment = 0;

                                                    if (!empty($data->inward_items)) {
                                                        $items_string = trim($data->inward_items);
                                                        $inward_items_array = array_map(
                                                            'trim',
                                                            explode(',', $items_string),
                                                        );
                                                        $target_item = '5';
                                                        if (in_array($target_item, $inward_items_array)) {
                                                            $h_ballclay_payment = DB::table('other_payments')
                                                                ->where('id', $target_item)
                                                                ->value('helper_amount');
                                                        }
                                                    }
                                                    $h_ball_clay = $h_ballclay_payment > 0 ? $h_ballclay_payment : '-';

                                                    $d_ballclay_payment = 0;

                                                    if (!empty($data->inward_items)) {
                                                        $items_string = trim($data->inward_items);
                                                        $inward_items_array = array_map(
                                                            'trim',
                                                            explode(',', $items_string),
                                                        );
                                                        $target_item = '5';
                                                        if (in_array($target_item, $inward_items_array)) {
                                                            $d_ballclay_payment = DB::table('other_payments')
                                                                ->where('id', $target_item)
                                                                ->value('driver_amount');
                                                        }
                                                    }
                                                    $d_ball_clay = $d_ballclay_payment > 0 ? $d_ballclay_payment : '-';

                                                    $h_goodru_payment = 0;

                                                    if (!empty($data->inward_items)) {
                                                        $items_string = trim($data->inward_items);
                                                        $inward_items_array = array_map(
                                                            'trim',
                                                            explode(',', $items_string),
                                                        );
                                                        $target_item = '6';
                                                        if (in_array($target_item, $inward_items_array)) {
                                                            $h_goodru_payment = DB::table('other_payments')
                                                                ->where('id', $target_item)
                                                                ->value('helper_amount');
                                                        }
                                                    }
                                                    $h_goodru = $h_goodru_payment > 0 ? $h_goodru_payment : '-';

                                                    $d_goodru_payment = 0;

                                                    if (!empty($data->inward_items)) {
                                                        $items_string = trim($data->inward_items);
                                                        $inward_items_array = array_map(
                                                            'trim',
                                                            explode(',', $items_string),
                                                        );
                                                        $target_item = '6';
                                                        if (in_array($target_item, $inward_items_array)) {
                                                            $d_goodru_payment = DB::table('other_payments')
                                                                ->where('id', $target_item)
                                                                ->value('driver_amount');
                                                        }
                                                    }
                                                    $d_goodru = $d_goodru_payment > 0 ? $d_goodru_payment : '-';

                                                    $h_pallet_payment = 0;

                                                    if (!empty($data->inward_items)) {
                                                        $items_string = trim($data->inward_items);
                                                        $inward_items_array = array_map(
                                                            'trim',
                                                            explode(',', $items_string),
                                                        );
                                                        $target_item = '8';
                                                        if (in_array($target_item, $inward_items_array)) {
                                                            $h_pallet_payment = DB::table('other_payments')
                                                                ->where('id', $target_item)
                                                                ->value('helper_amount');
                                                        }
                                                    }
                                                    $h_pallet = $h_pallet_payment > 0 ? $h_pallet_payment : '-';

                                                    $d_pallet_payment = 0;

                                                    if (!empty($data->inward_items)) {
                                                        $items_string = trim($data->inward_items);
                                                        $inward_items_array = array_map(
                                                            'trim',
                                                            explode(',', $items_string),
                                                        );
                                                        $target_item = '8';
                                                        if (in_array($target_item, $inward_items_array)) {
                                                            $d_pallet_payment = DB::table('other_payments')
                                                                ->where('id', $target_item)
                                                                ->value('driver_amount');
                                                        }
                                                    }
                                                    $d_pallet = $d_pallet_payment > 0 ? $d_pallet_payment : '-';

                                                    $h_unload_payment = 0;

                                                    if (!empty($data->inward_items)) {
                                                        $items_string = trim($data->inward_items);
                                                        $inward_items_array = array_map(
                                                            'trim',
                                                            explode(',', $items_string),
                                                        );
                                                        $target_item = '9';
                                                        if (in_array($target_item, $inward_items_array)) {
                                                            $h_unload_payment = DB::table('other_payments')
                                                                ->where('id', $target_item)
                                                                ->value('helper_amount');
                                                        }
                                                    }
                                                    $h_unload = $h_unload_payment > 0 ? $h_unload_payment : '-';

                                                    $d_unload_payment = 0;

                                                    if (!empty($data->inward_items)) {
                                                        $items_string = trim($data->inward_items);
                                                        $inward_items_array = array_map(
                                                            'trim',
                                                            explode(',', $items_string),
                                                        );
                                                        $target_item = '9';
                                                        if (in_array($target_item, $inward_items_array)) {
                                                            $d_unload_payment = DB::table('other_payments')
                                                                ->where('id', $target_item)
                                                                ->value('driver_amount');
                                                        }
                                                    }
                                                    $d_unload = $d_unload_payment > 0 ? $d_unload_payment : '-';

                                                    // Calculate Totals
                                                    $trip_fee_driver_cleaned = str_replace(
                                                        ',',
                                                        '',
                                                        $trip_fee_driver ?? 0,
                                                    );
                                                    $d_break_payment_cleaned = str_replace(',', '', $d_break_payment);
                                                    $d_lunch_payment_cleaned = str_replace(',', '', $d_lunch_payment);
                                                    $d_dinner_payment_cleaned = str_replace(',', '', $d_dinner_payment);
                                                    $d_night_payment_cleaned = str_replace(',', '', $d_night_payment);
                                                    $d_ballclay_payment_cleaned = str_replace(
                                                        ',',
                                                        '',
                                                        $d_ballclay_payment,
                                                    );
                                                    $d_pallet_payment_cleaned = str_replace(',', '', $d_pallet_payment);
                                                    $d_goodru_payment_cleaned = str_replace(',', '', $d_goodru_payment);
                                                    $d_unload_payment_cleaned = str_replace(',', '', $d_unload_payment);
                                                    $d_total =
                                                        (float) $trip_fee_driver_cleaned +
                                                        (float) $d_break_payment_cleaned +
                                                        (float) $d_lunch_payment_cleaned +
                                                        (float) $d_dinner_payment_cleaned +
                                                        (float) $d_ballclay_payment_cleaned +
                                                        (float) $d_pallet_payment_cleaned +
                                                        (float) $d_goodru_payment_cleaned +
                                                        (float) $d_unload_payment_cleaned +
                                                        (float) $d_night_payment_cleaned;

                                                    $trip_fee_helper_cleaned = str_replace(
                                                        ',',
                                                        '',
                                                        $trip_fee_helper ?? 0,
                                                    );
                                                    $h_break_payment_cleaned = str_replace(',', '', $h_break_payment);
                                                    $h_lunch_payment_cleaned = str_replace(',', '', $h_lunch_payment);
                                                    $h_dinner_payment_cleaned = str_replace(',', '', $h_dinner_payment);
                                                    $h_night_payment_cleaned = str_replace(',', '', $h_night_payment);
                                                    $h_ballclay_payment_cleaned = str_replace(
                                                        ',',
                                                        '',
                                                        $h_ballclay_payment,
                                                    );

                                                    $h_pallet_payment_cleaned = str_replace(',', '', $h_pallet_payment);
                                                    $h_goodru_payment_cleaned = str_replace(',', '', $h_goodru_payment);
                                                    $h_unload_payment_cleaned = str_replace(',', '', $h_unload_payment);

                                                    $h_total =
                                                        (float) $trip_fee_helper_cleaned +
                                                        (float) $h_break_payment_cleaned +
                                                        (float) $h_lunch_payment_cleaned +
                                                        (float) $h_dinner_payment_cleaned +
                                                        (float) $h_ballclay_payment_cleaned +
                                                        (float) $h_pallet_payment_cleaned +
                                                        (float) $h_goodru_payment_cleaned +
                                                        (float) $h_unload_payment_cleaned +
                                                        (float) $h_night_payment_cleaned;

                                                    $grand_driver_total += $d_total;
                                                    $grand_helper_total += $h_total;
                                                @endphp

                                                {{-- Main Row --}}
                                                <tr class="table-primary" data-bs-toggle="collapse"
                                                    data-bs-target="#sub_{{ $data->id }}" style="cursor: pointer;">
                                                    <td>{{ $key + 1 }}</td>
                                                    <td>{{ \Carbon\Carbon::parse($data->created_at)->format('d-m-Y') }}</td>
                                                    <td>{{ $data->outward_number ?? '-' }}</td>
                                                    <td>{{ $aod ?: '-' }}</td>
                                                    <td>{{ $customer_names ?: '-' }}</td>
                                                    <td>{{ ordinal($data->driver_trip_no ?? null) }}</td>
                                                    <td>{{ $data->d_name ?? '-' }}</td>
                                                    <td>{{ $data->d_epf ?? '-' }}</td>
                                                    <td>{{ ordinal($data->helper_trip_no ?? null) }}</td>
                                                    <td>{{ $data->h_name ?? '-' }}</td>
                                                    <td>{{ $data->h_epf ?? '-' }}</td>
                                                    <td>{{ $data->vehicle_no ?? '-' }}
                                                        {{ isset($data->v_type) ? "({$data->v_type})" : '' }}</td>
                                                    <td>{{ $trip_fee_driver ?? '-' }}</td>
                                                    <td>{{ $trip_fee_helper ?? '-' }}</td>
                                                    <td>{{ $d_break ?? '-' }}</td>
                                                    <td>{{ $h_break ?? '-' }}</td>
                                                    <td>{{ $d_lunch ?? '-' }}</td>
                                                    <td>{{ $h_lunch ?? '-' }}</td>
                                                    <td>{{ $d_dinner ?? '-' }}</td>
                                                    <td>{{ $h_dinner ?? '-' }}</td>
                                                    <td>{{ $d_ball_clay ?? '-' }}</td>
                                                    <td>{{ $h_ball_clay ?? '-' }}</td>
                                                    <td>{{ $d_goodru ?? '-' }}</td>
                                                    <td>{{ $h_goodru ?? '-' }}</td>
                                                    <td>{{ $d_pallet ?? '-' }}</td>
                                                    <td>{{ $h_pallet ?? '-' }}</td>
                                                    <td>{{ $d_unload ?? '-' }}</td>
                                                    <td>{{ $h_unload ?? '-' }}</td>
                                                    <td>{{ $d_night ?? '-' }}</td>
                                                    <td>{{ $h_night ?? '-' }}</td>
                                                    <td class="driver-total">
                                                        {{ number_format($d_total, 2, '.', ',') ?? '-' }}</td>
                                                    <td class="helper-total">
                                                        {{ number_format($h_total, 2, '.', ',') ?? '-' }}</td>

                                                </tr>
                                            @empty
                                                <tr>
                                                    <td colspan="32" class="text-center">No data available</td>
                                                </tr>
                                            @endforelse
                                            <tr class="table-success fw-bold" id="grandTotalRow">
                                                <td colspan="30" class="text-end">Grand Total</td>
                                                <td id="grandDriverTotal">
                                                    {{ number_format($grand_driver_total, 2, '.', ',') }}</td>
                                                <td id="grandHelperTotal">
                                                    {{ number_format($grand_helper_total, 2, '.', ',') }}</td>
                                            </tr>
                                        </tbody>

                                    </table>
                                </div>

                                <!-- Pagination -->
                                <div class="d-flex justify-content-end mt-4">
                                    <div class="pagination-wrapper">
                                        @if (method_exists($get_outward_data, 'links'))
                                            {{ $get_outward_data->onEachSide(1)->links('pagination::bootstrap-5') }}
                                        @endif
                                    </div>
                                </div>

                            </div>
                        </div>
                        <!-- End Card -->
                    </div>
                </div>

            </div>
        </div>

    </main>
@endsection

@push('scripts')
    <!-- Excel export library -->
    <script src="https://cdnjs.cloudflare.com/ajax/libs/xlsx/0.18.5/xlsx.full.min.js"></script>
    <!-- PDF export library -->
    <script src="https://cdnjs.cloudflare.com/ajax/libs/jspdf/2.5.1/jspdf.umd.min.js"></script>
    <script src="https://cdnjs.cloudflare.com/ajax/libs/jspdf-autotable/3.5.28/jspdf.plugin.autotable.min.js"></script>
    <!-- FileSaver -->
    <script src="https://cdnjs.cloudflare.com/ajax/libs/FileSaver.js/2.0.5/FileSaver.min.js"></script>

    <script>
        $(document).ready(function() {
            console.log('jQuery version:', $.fn.jquery);
            console.log('Datepicker available:', typeof $.fn.datepicker !== 'undefined');

            // Initialize FROM date picker
            $('#fromDate').datepicker({
                format: 'yyyy-mm-dd',
                autoclose: true,
                todayHighlight: true,
                todayBtn: 'linked',
                clearBtn: true,
                orientation: 'bottom auto',
                endDate: new Date(),
                templates: {
                    leftArrow: '<i class="bi bi-chevron-left"></i>',
                    rightArrow: '<i class="bi bi-chevron-right"></i>'
                }
            }).on('changeDate', function(e) {
                var fromDate = $('#fromDate').datepicker('getDate');
                if (fromDate) {
                    $('#toDate').datepicker('setStartDate', fromDate);
                }
            });

            // Initialize TO date picker
            $('#toDate').datepicker({
                format: 'yyyy-mm-dd',
                autoclose: true,
                todayHighlight: true,
                todayBtn: 'linked',
                clearBtn: true,
                orientation: 'bottom auto',
                endDate: new Date(),
                startDate: $('#fromDate').val() ? new Date($('#fromDate').val()) : null,
                templates: {
                    leftArrow: '<i class="bi bi-chevron-left"></i>',
                    rightArrow: '<i class="bi bi-chevron-right"></i>'
                }
            });

            // If there's already a from date value
            if ($('#fromDate').val()) {
                $('#toDate').datepicker('setStartDate', new Date($('#fromDate').val()));
            }

            // Calendar icon click
            $('.input-group-text').on('click', function() {
                $(this).next('input.datepicker-input').datepicker('show');
            });

            // Reset dates button
            $('#resetDates').on('click', function() {
                $('#fromDate').val('').datepicker('update');
                $('#toDate').val('').datepicker('update').datepicker('setStartDate', null);
                window.location.href = window.location.pathname;
            });

            // Form validation
            $('#dateFilterForm').on('submit', function(e) {
                var fromDate = $('#fromDate').val();
                var toDate = $('#toDate').val();

                if (fromDate && toDate) {
                    if (new Date(fromDate) > new Date(toDate)) {
                        e.preventDefault();
                        showToast('From date cannot be greater than To date', 'error');
                        return false;
                    }
                }
            });

            // Export buttons
            $('#exportExcelBtn').on('click', exportTableToExcel);
            $('#exportPdfBtn').on('click', exportTableToPDF);
            $('#exportCsvBtn').on('click', exportTableToCSV);
        });

        // ========== EXPORT FUNCTIONS ==========
        function exportTableToExcel() {
            try {
                showToast('Preparing Excel file...', 'info');
                const table = document.getElementById('incentiveTable');
                if (!table) {
                    showToast('Table not found!', 'error');
                    return;
                }

                const tableClone = table.cloneNode(true);
                $(tableClone).find('tr[data-bs-toggle="collapse"]').removeAttr('data-bs-toggle data-bs-target style');
                $(tableClone).find('tr.collapse').remove();

                const wb = XLSX.utils.book_new();
                const ws = XLSX.utils.table_to_sheet(tableClone);
                XLSX.utils.book_append_sheet(wb, ws, "Incentive Report");

                const date = new Date().toISOString().split('T')[0];
                XLSX.writeFile(wb, `Incentive_Report_${date}.xlsx`);
                showToast('Excel file downloaded successfully!', 'success');
            } catch (error) {
                console.error('Error:', error);
                showToast('Error exporting to Excel', 'error');
            }
        }

        function exportTableToCSV() {
            try {
                showToast('Preparing CSV file...', 'info');
                const table = document.getElementById('incentiveTable');
                if (!table) {
                    showToast('Table not found!', 'error');
                    return;
                }

                const rows = table.querySelectorAll('tr');
                const csv = [];
                rows.forEach(row => {
                    const rowData = [];
                    row.querySelectorAll('td, th').forEach(cell => {
                        let data = cell.innerText.replace(/(\r\n|\n|\r)/gm, '').replace(/\s+/g, ' ').trim();
                        if (data.includes(',') || data.includes('"')) {
                            data = '"' + data.replace(/"/g, '""') + '"';
                        }
                        rowData.push(data);
                    });
                    csv.push(rowData.join(','));
                });

                const blob = new Blob(['\ufeff' + csv.join('\n')], {
                    type: 'text/csv;charset=utf-8;'
                });
                const link = document.createElement('a');
                link.href = URL.createObjectURL(blob);
                link.download = `Incentive_Report_${new Date().toISOString().split('T')[0]}.csv`;
                document.body.appendChild(link);
                link.click();
                document.body.removeChild(link);
                showToast('CSV file downloaded successfully!', 'success');
            } catch (error) {
                console.error('Error:', error);
                showToast('Error exporting to CSV', 'error');
            }
        }

        function exportTableToPDF() {
            try {
                showToast('Preparing PDF file...', 'info');
                const {
                    jsPDF
                } = window.jspdf;
                const doc = new jsPDF({
                    orientation: 'landscape',
                    unit: 'mm',
                    format: 'a3'
                });

                doc.setFontSize(16);
                doc.text('Incentive Report', 14, 15);
                doc.setFontSize(10);
                doc.text(`Generated on: ${new Date().toLocaleDateString()}`, 14, 22);

                const table = document.getElementById('incentiveTable');
                const headers = [];
                const data = [];

                table.querySelectorAll('thead th').forEach(cell => headers.push(cell.innerText));
                table.querySelectorAll('tbody tr').forEach(row => {
                    const rowData = [];
                    row.querySelectorAll('td').forEach(cell => rowData.push(cell.innerText));
                    if (rowData.length > 0) data.push(rowData);
                });

                doc.autoTable({
                    head: [headers],
                    body: data,
                    startY: 30,
                    theme: 'grid',
                    styles: {
                        fontSize: 6,
                        cellPadding: 1
                    },
                    headStyles: {
                        fillColor: [13, 110, 253],
                        fontSize: 7
                    },
                    margin: {
                        left: 5,
                        right: 5
                    }
                });

                doc.save(`Incentive_Report_${new Date().toISOString().split('T')[0]}.pdf`);
                showToast('PDF file downloaded successfully!', 'success');
            } catch (error) {
                console.error('Error:', error);
                showToast('Error exporting to PDF', 'error');
            }
        }

        function showToast(message, type = 'info') {
            $('.toast').remove();
            const toastClass = {
                'success': 'bg-success',
                'error': 'bg-danger',
                'info': 'bg-info',
                'warning': 'bg-warning'
            } [type] || 'bg-info';
            const toastId = 'toast-' + Date.now();
            const toast = `
                <div id="${toastId}" class="toast align-items-center text-white ${toastClass} border-0 position-fixed bottom-0 end-0 m-3" role="alert" style="z-index: 9999;">
                    <div class="d-flex">
                        <div class="toast-body">${message}</div>
                        <button type="button" class="btn-close btn-close-white me-2 m-auto" data-bs-dismiss="toast"></button>
                    </div>
                </div>`;
            $('body').append(toast);
            const toastElement = new bootstrap.Toast(document.getElementById(toastId));
            toastElement.show();
            setTimeout(() => toastElement.hide(), 3000);
        }
    </script>
@endpush