@extends('admin.layouts.masterlayout')

@section('title')
Report Management
@endsection

@section('head_title')
Report Management
@endsection

@section('Css')
<link href="{{ asset('assets') }}/css/flatpickr/flatpickr.min.css" rel="stylesheet" type="text/css" />
<link href="{{ asset('assets/css/select2.min.css') }}" rel="stylesheet" type="text/css" />
@endsection

@section('content')
<div class="dashboard-body-content">
    <div class="card p-0 w-100">
        <div class="card-body w-100">
            <form id="report_form" method="POST">
                @csrf
                <div class="d-flex gap-3 align-items-start manage-search-container generate-report-top-head w-100"
                    style="max-width: 100% !important">
                    <div class="w-100 flex-1 d-flex align-items-start gap-3 flex-sm-row flex-column">
                        <div class="report-type-width-select w-100">
                            <label for="Filter" class="">Report Type</label>
                            <div class="position-relative w-100">
                                <select class="form-control select-menu pe-5" id="report_filter" name="report_filter">
                                    <option value="">Select</option>
                                    <option value="booking">Booking</option>
                                    <option value="inventory">Inventory</option>
                                    <option value="customer">Customer</option>
                                    <option value="artist">Artist</option>
                                    <option value="promotion">Promotion</option>
                                    <option value="advertisement">Advertisement</option>
                                    <option value="cancellation">Cancellation</option>
                                    <option value="shop">Shop</option>
                                    <option value="transaction">Transaction</option>
                                    <option value="admin_revenue">Admin Revenue</option>
                                    <option value="currency">Currency</option>
                                </select>
                                <div class="search-icon">
                                    <img src="{{ asset('assets') }}/img/Filter.png" alt="">
                                </div>
                                <div class="down-icon">
                                    <img src="{{ asset('assets') }}/img/arrow-down.png" alt="">
                                </div>
                            </div>
                        </div>
                        <div class="report-type-width-select w-100 selet2shop" style="display: none;">
                            <label for="Filter" class="">Shop</label>
                            <div class="position-relative w-100">
                                <select class="form-control select-menu pe-5" id="shop" name="shop">
                                    <option value="">Select Shop</option>
                                    @foreach($shops as $shop)
                                    <option value="{{ $shop->id }}" {{ old('shop_id') == $shop->id ? 'selected' : '' }}>
                                        {{ $shop->shop_name }}
                                    </option>
                                    @endforeach
                                </select>
                                <div class="search-icon">
                                    <img src="{{ asset('assets') }}/img/Filter.png" alt="">
                                </div>
                                <!-- <div class="down-icon">
                                    <img src="{{ asset('assets') }}/img/arrow-down.png" alt="">
                                </div> -->
                            </div>
                        </div>
                        <div class="report-type-width-select w-100 selet2shop" style="display: none;">
                            <label for="Filter" class="">Currency</label>
                            <div class="position-relative w-100">
                                <select class="form-control select-menu pe-5" id="currency" name="currency">
                                    <option value="">Select Currency</option>
                                    @foreach($currencies as $currency)
                                    <option value="{{ $currency->currency_code }}" {{ old('currency_code') == $currency->currency_code ? 'selected' : '' }}>
                                        {{ $currency->currency_code }}
                                    </option>
                                    @endforeach
                                </select>
                                <div class="search-icon">
                                    <img src="{{ asset('assets') }}/img/dollar.png" alt="">
                                </div>
                            </div>
                        </div>
                        <div class="date-picker-width w-100 flex-1">
                            <label for="start_date">Start Date
                            </label>
                            <div class="auth-input-position auth-input-position-datepicker">
                                <input type="text" name="start_date" id="start_date" class="form-control flatpickr pe-5"
                                    placeholder="Select Start Date" value="{{ old('start_date') }}" required>
                                <div class="search-icon">
                                    <img src="{{ asset('assets') }}/img/dashboard/calendar.png" alt="">
                                </div>
                                <!-- <div class="down-icon">
                                <img src="{{ asset('assets') }}/img/arrow-down.png" alt="">
                            </div> -->
                            </div>
                        </div>
                        <div class="date-picker-width w-100 flex-1">
                            <label for="end_date">End Date
                            </label>
                            <div class="auth-input-position auth-input-position-datepicker">
                                <input type="text" name="end_date" id="end_date" class="form-control flatpickr pe-5"
                                    placeholder="Select End Date" value="{{ old('end_date') }}" required>
                                <div class="search-icon">
                                    <img src="{{ asset('assets') }}/img/dashboard/calendar.png" alt="">
                                </div>
                                <!-- <div class="down-icon">
                                <img src="{{ asset('assets') }}/img/arrow-down.png" alt="">
                            </div> -->
                            </div>
                        </div>
                    </div>
                    <div class="report-name-width ms-auto ml-auto">
                        <!-- <div class="d-flex gap-3 align-items-center manage-search-container">
                        <div class="position-relative w-100">
                            <input type="search" class="form-control artist-search" placeholder="Search here">
                            <div class="search-icon">
                                <img src="{{asset('assets/img/dashboard/search-icon.png')}}" alt="">
                            </div>
                        </div>

                    </div> -->
                        <label class="opacity-0 d-md-block d-none">Generate</label>
                        <button type="button" id="submit_report" class="ct-btn text-center py-3">Generate
                            Report</button>
                        <input type="hidden" name="shop_id" id="export_shop_id">
                        <input type="hidden" name="start_date" id="export_start_date">
                        <input type="hidden" name="end_date" id="export_end_date">
                        <button type="submit" id="download_report_btn" class="ct-btn text-center py-3">Download Excel</button>
                    </div>


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

<div class="tab-content mt-3">
    <!-- Inventory Report Table -->
    <div class="ct-dashboard-table-container" id="inventory_report_table" style="display:none;">
        <div class="card p-2">
            <div class="table-responsive">
                <table class="table mb-0" id="inventoryTBL">
                    <thead>
                        <tr>
                            <th>#</th>
                            <th>Customer Name</th>
                            <th>Artist Name</th>
                            <!-- <th>Shop Name</th> -->
                            <th>Item Name</th>
                            <th>Usages Stock</th>
                            <th>Created At</th>
                        </tr>
                    </thead>
                </table>
            </div>
        </div>
    </div>

    <!-- Booking Report Table -->
    <div class="ct-dashboard-table-container" id="booking_report_table" style="display:none;">
        <div class="card p-2">
            <div class="table-responsive">
                <table class="table mb-0" id="bookingTBL">
                    <thead>
                        <tr>
                            <th>#</th>
                            <!-- <th>Booking ID</th> -->
                            <th>Artist Name</th>
                            <th>Customer Name</th>
                            <th>Status</th>
                            <th>Created At</th>
                        </tr>
                    </thead>
                </table>
            </div>
        </div>
    </div>

    <!-- Customer Report Table -->
    <div class="ct-dashboard-table-container" id="customer_report_table" style="display:none;">
        <div class="card p-2">
            <div class="table-responsive">
                <table class="table mb-0" id="customerTBL">
                    <thead>
                        <tr>
                            <th>#</th>
                            <th>Customer Name</th>
                            <th>Email</th>
                            <th>Total Booking</th>
                            <th>Cancellations</th>
                            <th>Status</th>
                            <th>Created At</th>
                        </tr>
                    </thead>
                </table>
            </div>
        </div>
    </div>

    <!-- Customer Report Table -->
    <div class="ct-dashboard-table-container" id="artist_report_table" style="display:none;">
        <div class="card p-2">
            <table class="table mb-0" id="artistTBL">
                <div class="table-responsive">
                    <thead>
                        <tr>
                            <th>#</th>
                            <th>Artist Name</th>
                            <th>Email</th>
                            <th>Experience</th>
                            <th>Total Booking</th>
                            <th>Cancellations</th>
                            <th>Status</th>
                            <th>Created At</th>
                        </tr>
                    </thead>
                </div>
            </table>
        </div>
    </div>

    <!-- Promotion Report Table -->
    <div class="ct-dashboard-table-container" id="promotion_report_table" style="display:none;">
        <div class="card p-2">
            <table class="table mb-0" id="promotionTBL">
                <div class="table-responsive">
                    <thead>
                        <tr>
                            <th>#</th>
                            <th>Shop</th>
                            <th>Promotion Code</th>
                            <th>Type</th>
                            <th>Value</th>
                            <th>Total Used</th>
                            <th>Status</th>
                            <th>Created At</th>
                        </tr>
                    </thead>
                </div>
            </table>
        </div>
    </div>
    <!-- Advertisement Report Table -->
    <div class="ct-dashboard-table-container" id="advertisement_report_table" style="display:none;">
        <div class="card p-2">
            <table class="table mb-0" id="advertisementTBL">
                <div class="table-responsive">
                    <thead>
                        <tr>
                            <th>#</th>
                            <th>Title</th>
                            <th>Price</th>
                            <th>Audience Target</th>
                            <th>Views</th>
                            <th>Clicks</th>
                            <th>Status</th>
                            <th>Created At</th>
                        </tr>
                    </thead>
                </div>
            </table>
        </div>
    </div>

    <!-- Cancellation  Report Table -->
    <div class="ct-dashboard-table-container" id="cancellation_report_table" style="display:none;">
        <div class="card p-2">
            <table class="table mb-0" id="CancellationTBL">
                <div class="table-responsive">
                    <thead>
                        <tr>
                            <th>#</th>
                            <th>Customer</th>
                            <th>Artist</th>
                            <th>Price</th>
                            <th>Customer Reason</th>
                            <th>Shop Reason</th>
                            <th>Created At</th>
                        </tr>
                    </thead>
                </div>
            </table>
        </div>
    </div>

    <!-- Shop  Report Table -->
    <div class="ct-dashboard-table-container" id="shop_report_table" style="display:none;">
        <div class="card p-2">
            <table class="table mb-0" id="ShopTBL">
                <div class="table-responsive">
                    <thead>
                        <tr>
                            <th>#</th>
                            <th>Name</th>
                            <th>Owner Name</th>
                            <th>Email</th>
                            <th>Total Booking</th>
                            <th>Revenue</th>
                            <th>Status</th>
                            <th>Created At</th>

                        </tr>
                    </thead>
                </div>
            </table>
        </div>
    </div>

    <!-- transaction  Report Table -->
    <div class="ct-dashboard-table-container" id="transaction_report_table" style="display:none;">
        <div class="card p-2">
            <table class="table mb-0" id="TransactionTBL">
                <div class="table-responsive">
                    <thead>
                        <tr>
                            <th>#</th>
                            <th>Shop Name</th>
                            <th>User Name</th>
                            <th>Amount</th>
                            <th>Transaction type</th>
                            <th>Status</th>
                            <th>Created At</th>
                        </tr>
                    </thead>
                </div>
            </table>
        </div>
    </div>

    <!-- Admin Revenue  Report Table -->
    <div class="ct-dashboard-table-container" id="admin_revenue_report_table" style="display:none;">
        <div class="card p-2">
            <table class="table mb-0" id="admin_revenueTBL">
                <div class="table-responsive">
                    <thead>
                        <tr>
                            <th>#</th>
                            <th>Shop Name</th>
                            <th>User Name</th>
                            <th>Admin Commission Amount</th>
                            <th>Transaction Type</th>
                            <th>Status</th>
                            <th>Created At</th>
                        </tr>
                    </thead>
                </div>
            </table>
        </div>
    </div>

    <div class="ct-dashboard-table-container" id="currency_report_table" style="display:none;">
        <div class="card p-2">
            <table class="table mb-0" id="currencyTBL">
                <div class="table-responsive">
                    <thead>
                        <tr>
                            <th>#</th>
                            <th>Currency Code</th>
                            <th>Currency Symbol</th>
                            <th>Admin Commission Amount</th>
                        </tr>
                    </thead>
                </div>
            </table>
        </div>
    </div>

</div>
</div>

@endsection

@section('script')
<script src="{{ asset('assets/js/dataTables.js') }}"></script>
<script src="{{ asset('assets') }}/js/flatpickr.js"></script>
<script src="{{ asset('assets/js/select2.min.js') }}"></script>

<script>
    $(document).ready(function() {
        $("#shop").select2();
        $("#currency").select2();
        const reportForm = $('#report_form');

        // Flatpickr
       const startDatePicker = flatpickr("#start_date", {
            dateFormat: "Y-m-d",
            altInput: true,
            altFormat: "d-m-Y",
            altInputClass: "form-control flatpickr-alt",
            onChange: function(selectedDates, dateStr, instance) {
                endDatePicker.set("minDate", dateStr);
                $('#start_date').valid();
                $('#end_date').valid();
            }
        });
       const endDatePicker = flatpickr("#end_date", {
            dateFormat: "Y-m-d",
            altInput: true,
            altFormat: "d-m-Y",
            altInputClass: "form-control flatpickr-alt",
            onChange: function(selectedDates, dateStr, instance) {
                $('#end_date').valid();
            }
        });

        // Show/hide shop field
        function toggleShopVisibility() {
            const type = $('#report_filter').val();
            const show = type === 'booking' || type === 'inventory' || type === 'advertisement' || type === 'cancellation' || type === 'transaction';
            $('#shop').closest('.report-type-width-select').toggle(show);

            const currency_show = type === 'admin_revenue';
            $('#currency').closest('.report-type-width-select').toggle(currency_show);
        }

        $('#report_filter').on('change', toggleShopVisibility);
        toggleShopVisibility(); // initial

        // Validation
        reportForm.validate({
            ignore: [],
            rules: {
                report_filter: {
                    required: true
                },
                start_date: {
                    required: true,
                    dateISO: true
                },
                end_date: {
                    required: true,
                    dateISO: true,
                    endDateAfterStartDate: true
                },
                shop: {
                    required: function() {
                        const val = $('#report_filter').val();
                        return val === 'booking' || val === 'inventory' || val === 'advertisement' || val === 'cancellation' || val === 'transaction';
                    }
                }
            },
            errorPlacement: function(error, element) {
             if (element.attr("name") === "start_date") {
                  error.appendTo(element.closest('.auth-input-position-datepicker'));
              } else if (element.attr("name") === "end_date") {
                 error.appendTo(element.closest('.auth-input-position-datepicker'));
             } else {
                  error.appendTo(element.closest('.report-type-width-select'));
              }
          },
            // messages: {
            //     report_filter: "Select report type",
            //     shop: "Select shop for booking/inventory",
            //     start_date: "Start date required",
            //     end_date: "End date required"
            // }
        });

        $.validator.addMethod("endDateAfterStartDate", function(value, element) {
          var startDate = $('#start_date').val();
          var endDate = $('#end_date').val();
          if (!startDate || !endDate) {
              return true;
          }
          return new Date(endDate) >= new Date(startDate);
      }, "End date must be equal to or after start date");
        // DataTables references
        let booking_TBL = null;
        let inventory_TBL = null;
        let customer_TBL = null;
        let artist_TBL = null;
        let promotion_TBL = null;
        let advertisement_TBL = null;
        let cancellation_TBL = null;
        let shop_TBL = null;
        let transaction_TBL = null;
        let admin_revenueTBL = null;
        let currencyTBL = null;


        // On Generate Report
        $('#submit_report').click(function() {
            if (!reportForm.valid()) return;

            const reportType = $('#report_filter').val();
            const shopId = $('#shop').val();
            const start = $('#start_date').val();
            const end = $('#end_date').val();

            $('#export_shop_id').val(shopId);
            $('#export_start_date').val(start);
            $('#export_end_date').val(end);


            // Reload correct DataTable
            if (reportType === 'booking') {
                $('#booking_report_table').show();
                $('#inventory_report_table,#customer_report_table, #artist_report_table, #promotion_report_table, #advertisement_report_table, #cancellation_report_table,#shop_report_table,#transaction_report_table, #admin_revenue_report_table, #currency_report_table').hide();

                if (!booking_TBL) {
                    booking_TBL = $('#bookingTBL').DataTable({
                        dom: '<"table-responsive"t><"pagination-container"<i><p>>>',
                        processing: true,
                        serverSide: true,
                        order: [],
                        ajax: {
                            url: '{{ route("admin.getBookingReportData") }}',
                            data: function(d) {
                                d.shop_id = $('#shop').val();
                                d.start_date = $('#start_date').val();
                                d.end_date = $('#end_date').val();

                            }
                        },
                        columns: [{
                                data: 'DT_RowIndex',
                                orderable: false,
                                searchable: false
                            },
                            // {
                            //     data: 'booking_id'
                            // },
                            {
                                data: 'artist_name'
                            },
                            {
                                data: 'customer_name'
                            },
                            {
                                data: 'status'
                            },
                            {
                                data: 'created_at'
                            },
                        ]
                    });
                } else {
                    booking_TBL.ajax.reload();
                }

            } else if (reportType === 'inventory') {
                $('#inventory_report_table').show();
                $('#booking_report_table, #customer_report_table, #artist_report_table, #promotion_report_table, #advertisement_report_table, #cancellation_report_table,#shop_report_table,#transaction_report_table, #admin_revenue_report_table, #currency_report_table').hide();

                if (!inventory_TBL) {
                    inventory_TBL = $('#inventoryTBL').DataTable({
                        dom: '<"table-responsive"t><"pagination-container"<i><p>>>',
                        processing: true,
                        serverSide: true,
                        order: [],
                        ajax: {
                            url: '{{ route("admin.getInventoryReportData") }}',
                            data: function(d) {
                                d.shop_id = $('#shop').val();
                                d.start_date = $('#start_date').val();
                                d.end_date = $('#end_date').val();

                            }
                        },
                        columns: [{
                                data: 'DT_RowIndex',
                                orderable: false,
                                searchable: false
                            },
                            {
                                data: 'customer_name'
                            },
                            {
                                data: 'artist_name'
                            },

                            {
                                data: 'item_name'
                            },
                            {
                                data: 'usage_stock'
                            },
                            {
                                data: 'created_at'
                            }
                        ]
                    });
                } else {
                    inventory_TBL.ajax.reload();
                }
            } else if (reportType === 'customer') {
                $('#customer_report_table').show();
                $('#inventory_report_table, #booking_report_table, #artist_report_table, #promotion_report_table, #advertisement_report_table, #cancellation_report_table,#shop_report_table, #transaction_report_table, #admin_revenue_report_table, #currency_report_table').hide();

                if (!customer_TBL) {
                    customer_TBL = $('#customerTBL').DataTable({
                        dom: '<"table-responsive"t><"pagination-container"<i><p>>>',
                        processing: true,
                        serverSide: true,
                        order: [],
                        ajax: {
                            url: '{{ route("admin.getCustomerReportData") }}',
                            data: function(d) {
                                d.start_date = $('#start_date').val();
                                d.end_date = $('#end_date').val();
                                d.shop_id = $('#shop').val(); // if needed
                            }
                        },
                        columns: [{
                                data: 'DT_RowIndex',
                                orderable: false,
                                searchable: false
                            },
                            {
                                data: 'name'
                            },
                            {
                                data: 'email'
                            },
                            {
                                data: 'total_bookings'
                            },
                            {
                                data: 'cancellations'
                            },
                            {
                                data: 'status'
                            },
                            {
                                data: 'created_at'
                            }
                        ]
                    });
                } else {
                    customer_TBL.ajax.reload();
                }
            } else if (reportType === 'artist') {
                $('#artist_report_table').show();
                $('#booking_report_table, #inventory_report_table, #customer_report_table,#promotion_report_table, #advertisement_report_table, #cancellation_report_table,#shop_report_table, #transaction_report_table, #admin_revenue_report_table, #currency_report_table').hide();

                if (!artist_TBL) {
                    artist_TBL = $('#artistTBL').DataTable({
                        dom: '<"table-responsive"t><"pagination-container"<i><p>>>',
                        processing: true,
                        serverSide: true,
                        order: [],
                        ajax: {
                            url: '{{ route("admin.getArtistReportData") }}',
                            data: function(d) {
                                d.start_date = $('#start_date').val();
                                d.end_date = $('#end_date').val();
                            }
                        },
                        columns: [{
                                data: 'DT_RowIndex',
                                orderable: false,
                                searchable: false
                            },
                            {
                                data: 'name'
                            },
                            {
                                data: 'email'
                            },
                            {
                                data: 'experience'
                            },
                            {
                                data: 'total_bookings'
                            },
                            {
                                data: 'cancellations'
                            },
                            {
                                data: 'status'
                            },
                            {
                                data: 'created_at'
                            }
                        ]
                    });
                } else {
                    artist_TBL.ajax.reload();
                }
            } else if (reportType === 'promotion') {
                $('#promotion_report_table').show();
                $('#inventory_report_table, #booking_report_table, #customer_report_table, #artist_report_table, #advertisement_report_table, #cancellation_report_table, #shop_report_table, #transaction_report_table').hide();

                if (!promotion_TBL) {
                    promotion_TBL = $('#promotionTBL').DataTable({
                        dom: '<"table-responsive"t><"pagination-container"<i><p>>>',
                        processing: true,
                        serverSide: true,
                        order: [],
                        ajax: {
                            url: '{{ route("admin.getPromotionReportData") }}',
                            data: function(d) {
                                d.start_date = $('#start_date').val();
                                d.end_date = $('#end_date').val();
                            }
                        },
                        columns: [{
                                data: 'DT_RowIndex',
                                orderable: false,
                                searchable: false
                            },
                            {
                                data: 'code'
                            },
                            {
                                data: 'shop_name'
                            },
                            {
                                data: 'type'
                            },
                            {
                                data: 'value'
                            },
                            {
                                data: 'used'
                            },
                            {
                                data: 'status'
                            },
                            {
                                data: 'created_at'
                            }
                        ]
                    });
                } else {
                    promotion_TBL.ajax.reload();
                }
            } else if (reportType === 'advertisement') {
                $('#advertisement_report_table').show();
                $('#booking_report_table, #inventory_report_table, #customer_report_table, #artist_report_table, #promotion_report_table, #cancellation_report_table,#shop_report_table,#transaction_report_table, #admin_revenue_report_table, #currency_report_table').hide();

                if (!advertisement_TBL) {
                    advertisement_TBL = $('#advertisementTBL').DataTable({
                        dom: '<"table-responsive"t><"pagination-container"<i><p>>>',
                        processing: true,
                        serverSide: true,
                        order: [],
                        ajax: {
                            url: '{{ route("admin.getAdvertisementReportData") }}',
                            data: function(d) {
                                d.start_date = $('#start_date').val();
                                d.end_date = $('#end_date').val();
                                d.shop_id = $('#shop').val();
                            }
                        },
                        columns: [{
                                data: 'DT_RowIndex',
                                orderable: false,
                                searchable: false
                            },
                            {
                                data: 'title'
                            },
                            {
                                data: 'price'
                            },
                            {
                                data: 'audience_target'
                            },
                            {
                                data: 'views'
                            },
                            {
                                data: 'clicks'
                            },
                            {
                                data: 'status'
                            },
                            {
                                data: 'created_at'
                            }
                        ]
                    });
                } else {
                    advertisement_TBL.ajax.reload();
                }
            } else if (reportType === 'cancellation') {
                $('#cancellation_report_table').show();
                $('#booking_report_table, #inventory_report_table, #customer_report_table, #artist_report_table, #promotion_report_table, #shop_report_table, #transaction_report_table,#advertisement_report_table, #admin_revenue_report_table, #currency_report_table').hide();

                if (!cancellation_TBL) {
                    cancellation_TBL = $('#CancellationTBL').DataTable({
                        dom: '<"table-responsive"t><"pagination-container"<i><p>>>',
                        processing: true,
                        serverSide: true,
                        order: [],
                        ajax: {
                            url: '{{ route("admin.getCancellationReportData") }}',
                            data: function(d) {
                                d.start_date = $('#start_date').val();
                                d.end_date = $('#end_date').val();
                                d.shop_id = $('#shop').val();
                            }
                        },
                        columns: [{
                                data: 'DT_RowIndex',
                                orderable: false,
                                searchable: false
                            },
                            {
                                data: 'customer'
                            },
                            {
                                data: 'artist'
                            },
                            {
                                data: 'price'
                            },
                            {
                                data: 'customer_reason'
                            },
                            {
                                data: 'shop_reason'
                            },
                            {
                                data: 'created_at'
                            }
                        ]
                    });
                } else {
                    cancellation_TBL.ajax.reload();
                }
            } else if (reportType === 'shop') {
                $('#shop_report_table').show();
                $('#inventory_report_table, #booking_report_table, #customer_report_table, #artist_report_table, #promotion_report_table, #advertisement_report_table, #cancellation_report_table, #transaction_report_table, #admin_revenue_report_table, #currency_report_table').hide();

                if (!shop_TBL) {
                    shop_TBL = $('#ShopTBL').DataTable({
                        dom: '<"table-responsive"t><"pagination-container"<i><p>>>',
                        processing: true,
                        serverSide: true,
                        order: [],
                        ajax: {
                            url: '{{ route("admin.getShopReportData") }}',
                            data: function(d) {
                                d.start_date = $('#start_date').val();
                                d.end_date = $('#end_date').val();
                                // No shop_id passed, since you want all shops
                            }
                        },
                        columns: [{
                                data: 'DT_RowIndex',
                                orderable: false,
                                searchable: false
                            },
                            {
                                data: 'name'
                            },
                            {
                                data: 'owner_name'
                            },
                            {
                                data: 'email'
                            },
                            {
                                data: 'total_bookings'
                            },
                            {
                                data: 'revenue'
                            },
                            {
                                data: 'status'
                            },
                            {
                                data: 'created_at'
                            }
                        ]
                    });
                } else {
                    shop_TBL.ajax.reload();
                }

            } else if (reportType === 'transaction') {
                $('#transaction_report_table').show();
                $('#inventory_report_table, #booking_report_table, #customer_report_table, #artist_report_table, #promotion_report_table, #advertisement_report_table, #cancellation_report_table, #shop_report_table, #admin_revenue_report_table, #currency_report_table').hide();

                if (!transaction_TBL) {
                    transaction_TBL = $('#TransactionTBL').DataTable({
                        dom: '<"table-responsive"t><"pagination-container"<i><p>>>',
                        processing: true,
                        serverSide: true,
                        // order: [],
                        ajax: {
                            url: '{{ route("admin.getTransactionReportData") }}',
                            data: function(d) {
                                d.start_date = $('#start_date').val();
                                d.end_date = $('#end_date').val();
                                // Optional: shop_id if needed
                                d.shop_id = $('#shop').val();
                            }
                        },
                        columns: [{
                                data: 'DT_RowIndex',
                                orderable: false,
                                searchable: false
                            },
                            {
                                data: 'shop_name'
                            },
                            {
                                data: 'user_name'
                            },
                            {
                                data: 'amount'
                            },
                            {
                                data: 'transaction_type'
                            },
                            {
                                data: 'status'
                            },
                            {
                                data: 'created_at',
                            }
                        ]
                    });
                } else {
                    transaction_TBL.ajax.reload();
                }
            } else if (reportType === 'admin_revenue') {
                $('#admin_revenue_report_table').show();
                $('#inventory_report_table, #booking_report_table, #customer_report_table, #artist_report_table, #promotion_report_table, #advertisement_report_table, #cancellation_report_table, #shop_report_table, #transaction_report_table, #currency_report_table').hide();

                if (!admin_revenueTBL) {
                    admin_revenueTBL = $('#admin_revenueTBL').DataTable({
                        dom: '<"table-responsive"t><"pagination-container"<i><p>>>',
                        processing: true,
                        serverSide: true,
                        order: [],
                        ajax: {
                            url: '{{ route("admin.GetAdminRevenueReportData") }}',
                            data: function(d) {
                                d.start_date = $('#start_date').val();
                                d.end_date = $('#end_date').val();
                                d.currency = $('#currency').val();
                            }
                        },
                        columns: [{
                                data: 'DT_RowIndex',
                                orderable: false,
                                searchable: false
                            },
                            {
                                data: 'shop_name'
                            },
                            {
                                data: 'user_name'
                            },
                            {
                                data: 'amount'
                            },
                            {
                                data: 'transaction_type'
                            },
                            {
                                data: 'status'
                            },
                            {
                                data: 'created_at'
                            }
                        ]
                    });
                } else {
                    admin_revenueTBL.ajax.reload();
                }
            } else if (reportType === 'currency') {
                $('#currency_report_table').show();
                $('#inventory_report_table, #booking_report_table, #customer_report_table, #artist_report_table, #promotion_report_table, #advertisement_report_table, #cancellation_report_table, #shop_report_table, #transaction_report_table, #admin_revenue_report_table').hide();

                if (!currencyTBL) {
                    currencyTBL = $('#currencyTBL').DataTable({
                        dom: '<"table-responsive"t><"pagination-container"<i><p>>>',
                        processing: true,
                        serverSide: true,
                        order: [],
                        ajax: {
                            url: '{{ route("admin.GetCurrencyReportData") }}',
                        },
                        columns: [{
                                data: 'DT_RowIndex',
                                orderable: false,
                                searchable: false
                            },
                            {
                                data: 'currency_code'
                            },
                            {
                                data: 'currency_symbol'
                            },
                            {
                                data: 'amount'
                            },
                        ]
                    });
                } else {
                    currencyTBL.ajax.reload();
                }
            } else {
                $('#inventory_report_table, #booking_report_table').hide();
            }

            // Set download form action
            let actionUrl = '';
            if (reportType === 'booking') {
                actionUrl = '{{ route("admin.downloadBookingReport") }}';
            } else if (reportType === 'inventory') {
                actionUrl = '{{ route("admin.downloadInventoryUseReport") }}';
            } else if (reportType === 'customer') {
                actionUrl = '{{ route("admin.downloadCustomerReport") }}'; // <-- Add this
            } else if (reportType === 'artist') {
                actionUrl = '{{ route("admin.downloadArtistReport") }}';
            } else if (reportType === 'promotion') {
                actionUrl = '{{ route("admin.downloadPromotionReport") }}';
            } else if (reportType === 'advertisement') {
                actionUrl = '{{ route("admin.downloadAdvertisementReport") }}';
            } else if (reportType === 'cancellation') {
                actionUrl = '{{ route("admin.downloadCancellationReport") }}';
            } else if (reportType === 'shop') {
                actionUrl = '{{ route("admin.downloadShopReport") }}';
            } else if (reportType === 'transaction') {
                actionUrl = '{{ route("admin.downloadTransactionReport") }}';
            } else if (reportType === 'admin_revenue') {
                actionUrl = '{{ route("admin.downloadAdminRevenueReport") }}';
            }

            reportForm.attr('action', actionUrl);
        });
    });
</script>
@endsection