@extends('layouts.user.main')
@section('content')

    
    <div class="content d-flex flex-column flex-column-fluid" id="kt_content">
        <!--begin::Post-->
        <div class="post d-flex flex-column-fluid" id="kt_post">
            <!--begin::Container-->
            <div id="kt_content_container" class="container-xxl">
                <!--begin::Card-->
                <div class="card card-flush">
                    <div class="card-body py-4">
                        <!--begin::Table-->
                        <form action="{{ route('companyBrokerage') }}" method="post" id="dateRangeForm">
                            @csrf
                            <input type="hidden" name="start_date" id="start_date">
                            <input type="hidden" name="end_date" id="end_date">
                        </form>
                        <div class="table-responsive">
                            <table class="table align-middle table-row-dashed fs-6 gy-5 mb-0" id="company_brokerage_table_reports">
                                <!--begin::Table head-->
                                <thead>
                                    <tr class="text-center fw-bolder fs-7 text-uppercase gs-0">
                                        <th class="min-w-80px d-none">Manager Name</th>
                                        <th class="min-w-80px">Code</th>
                                        <th class="min-w-80px">Name</th>
                                        <th class="min-w-80px">Lotus Share</th>
                                        <th class="min-w-80px">Total BRK</th>
                                        <th class="min-w-80px">Return BRK</th>
                                        <th class="min-w-80px">Sharing Min BRK</th>
                                        <th class="min-w-80px">Sharing Min Lotus BRK</th>
                                    </tr>
                                </thead>
                                <!--end::Table head-->
                                <!--begin::Table body-->
                                <tbody class="fw-bold">
                                </tbody>
                                <!--end::Table head-->
                            </table>
                        </div>
                        <!--end::Table-->
                    </div>
                </div>
                <!--end::Card-->
            </div>
            <!--end::Container-->
        </div>
        <!--end::Post-->
    </div>
    <script type="text/javascript">
        const table          = $('#company_brokerage_table_reports');
        const token          = "{{ csrf_token() }}";
        var fileName         = "Company_Brokerage_Report";
        var title            = fileName + '_' +Date.now();
        var columns          = [1, 2, 3, 4, 5, 6, 7];
        var minFractionDigit = "{{CommonConstants::BILLING_SUMMARY['MIN_FRACTION_DIGIT']}}";
        var maxFractionDigit = "{{CommonConstants::BILLING_SUMMARY['MAX_FRACTION_DIGIT']}}";
        var url;

        var dataColumns = [
            {
                data: 'managerLogin',
                name: 'managerLogin',
                visible: false
            },
            {
                data: 'loginId',
                name: 'loginId'
            },
            {
                data: 'name',
                name: 'accounts.name'
            },
            {
                data: 'lotusPercentage',
                name: 'lotusPercentage',
                render: function(data, type, full, meta) {
                    var percentage = full.lotusPercentage; 
                    return percentage;
                }
            },
            {
                data: 'totalBrokerage',
                name: 'brokerage_report.totalBrokerage',
                render: function(data, type, full, meta) {
                    var number = numberSeparator(full.totalBrokerage, minFractionDigit, maxFractionDigit);
                    return number;
                }
            },
            {
                data: 'extraBrokerage',
                name: 'brokerage_report.extraBrokerage',
                render: function(data, type, full, meta) {
                    var number = numberSeparator(full.extraBrokerage, minFractionDigit, maxFractionDigit);
                    return number;
                }
            },
            {
                data: 'sharingBrokerage',
                name: 'sharingBrokerage',
                render: function(data, type, full, meta) {
                    var number = numberSeparator(full.sharingBrokerage, minFractionDigit, maxFractionDigit);
                    return number;
                }
            },
            {
                data: 'lotusSharingBrokerage',
                name: 'lotusSharingBrokerage',
                render: function(data, type, full, meta) {
                    var number = numberSeparator(full.lotusSharingBrokerage, minFractionDigit, maxFractionDigit);
                    return number;
                }
            }
        ];

        $.ajaxSetup({
            headers: {
                'X-CSRF-TOKEN': $('meta[name="csrf-token"]').attr('content')
            }
        });

        $(document).ready(function() {
            makeDataTable(table, title, columns, dataColumns);
        });

        function makeDataTable(table, title, columnArray, dataColumns) {
            var groupColumn                 = 0;
            var totalBrokerageColumn        = 4;
            var totalExtraBkrgColumn        = 5;
            var totalSharingAmountColumn    = 6;
            var totalLotusAmountColumn      = 7;
            var sharingPercentageColumn     = 3
            var reloadAjex = $(table).dataTable({
                // export buttons
                dom: "<'card-header align-items-center py-5 gap-2 gap-md-5'<'card-title col-4'<'d-flex position-relative my-1'>><'card-toolbar flex-row-fluid justify-content-end gap-6'B>>" +
                    "<'row'<'col-sm-12'tr>>" +
                    "<'row'<'col-sm-12 col-md-5 gap-2 d-flex align-items-center justify-content-center justify-content-md-start'l<i>><'col-sm-12 col-md-7 d-flex align-items-center justify-content-center justify-content-md-end'p>>",
                processing: true,
                stateSave: false,
                drawCallback: function(settings) {
                    var api                     = this.api();
                    var rows                    = api.rows().nodes();
                    var lastGroup               = null;
                    var lastTotalBrokerage      = 0;
                    var lastRowIndex            = -1;
                    var lastSharingBkrgAmount   = 0;
                    var lastTotalExtraBrokerage = 0;
                    var lastTotalLotusBrokerage = 0;

                    api.column(groupColumn).data().each(function(group, i) {
                        var totalBrokerage      = parseFloat(api.column(totalBrokerageColumn).data()[i]) || 0;
                        var totalExtraBrokerage = parseFloat(api.column(totalExtraBkrgColumn).data()[i]) || 0;
                        var sharingBkrgAmount   = parseFloat(api.column(totalSharingAmountColumn).data()[i]) || 0;
                        var lotusBkrgAmount     = parseFloat(api.column(totalLotusAmountColumn).data()[i]) || 0;

                        if (lastGroup !== group) {
                            if (lastRowIndex !== -1) {
                                $(rows).eq(lastRowIndex).after(
                                    '<tr class="group even">' +
                                    '<td colspan="3" class="fs-3 text-center fw-bold">Total</td>' +
                                    '<td class="fs-3 text-dark text-center fs-3 fw-boldest">' + numberSeparator(lastTotalBrokerage, minFractionDigit, maxFractionDigit) + '</td>' +
                                    '<td class="fs-3 text-dark text-center fs-3 fw-boldest">' + numberSeparator(lastTotalExtraBrokerage, minFractionDigit, maxFractionDigit) + '</td>' +
                                    '<td class="fs-3 text-dark text-center fs-3 fw-boldest">' + numberSeparator(lastSharingBkrgAmount, minFractionDigit, maxFractionDigit) + '</td>' +
                                    '<td class="fs-3 text-dark text-center fs-3 fw-boldest">' + numberSeparator(lastTotalLotusBrokerage, minFractionDigit, maxFractionDigit) + '</td>' +
                                    '</tr>'
                                );
                            }

                            lastGroup               = group;
                            lastTotalBrokerage      = totalBrokerage;
                            lastTotalExtraBrokerage = totalExtraBrokerage;
                            lastSharingBkrgAmount   = sharingBkrgAmount;
                            lastTotalLotusBrokerage = lotusBkrgAmount;

                            $(rows).eq(i).before(
                                '<tr class="group even"><td colspan="5" class="fs-3 text-danger fw-bold">' +
                                group +
                                '</td></tr>'
                            );
                        } else {
                            lastTotalBrokerage      += totalBrokerage;
                            lastTotalExtraBrokerage += totalExtraBrokerage;
                            lastSharingBkrgAmount   += sharingBkrgAmount;
                            lastTotalLotusBrokerage += lotusBkrgAmount;

                        }

                        lastRowIndex = i;
                    });

                    if (api.page.info().page + 1 == api.page.info().pages) {
                        if (lastRowIndex !== -1) {
                            $(rows).eq(lastRowIndex).after(
                                '<tr class="group even">' +
                                '<td colspan="3" class="fs-3 text-center fw-bold">Total</td>' +
                                '<td class="fs-3 text-dark text-center fs-3 fw-boldest">' + numberSeparator(lastTotalBrokerage, minFractionDigit, maxFractionDigit) + '</td>' +
                                '<td class="fs-3 text-dark text-center fs-3 fw-boldest">' + numberSeparator(lastTotalExtraBrokerage, minFractionDigit, maxFractionDigit) + '</td>' +
                                '<td class="fs-3 text-dark text-center fs-3 fw-boldest">' + numberSeparator(lastSharingBkrgAmount, minFractionDigit, maxFractionDigit) + '</td>' +
                                '<td class="fs-3 text-dark text-center fs-3 fw-boldest">' + numberSeparator(lastTotalLotusBrokerage, minFractionDigit, maxFractionDigit) + '</td>' +
                                '</tr>'
                            );
                        }
                    }
                },
                "stateSaveParams": function (settings, data) {
                    data.search.search = '';
                },
                pageLength: 10,
                "lengthMenu": {!! json_encode(CommonConstants::ALL_PAGE_PER_DATA) !!},
                language: {
                    searchPlaceholder: "Search Brokerage",
                    search: ""
                },
                buttons: [{
                    extend: "collection",
                    className: "exportButton",
                    text: "<i class='fa fa-download'></i> Export",
                        buttons: [
                        {
                            extend: "excelHtml5",
                            text: "Export",
                            className: "btn btn-default btn-sm gap-5",
                            title: title,
                            exportOptions: {
                                columns: columnArray
                            }
                        },{
                            extend: "excelHtml5",
                            text: "Export All",
                            className: "btn btn-default btn-sm gap-5",
                            title: title,
                            "action": exportAllAction,
                            exportOptions: {
                                columns: columnArray
                            }
                        },{
                            extend: "csvHtml5",
                            text: "CSV",
                            className: "btn btn-default btn-sm gap-5 d-none",
                            title: title,
                            exportOptions: {
                                columns: columnArray
                            }
                        },{
                            extend: "pdfHtml5",
                            text: 'Pdf',
                            className: "btn btn-default btn-sm",
                            title: title,
                            "action": exportAllAction,
                            exportOptions: {
                                columns: columnArray
                            },
                            customize: function(doc) {
                                var api             = reloadAjex; 
                                // Assuming reloadAjex is your DataTable instance
                                var rows            = api.api().rows().data();
                                var lastGroup       = null;
                                var newRows         = [];

                                var lastTotalProfit             = 0;
                                var lastTotalBrokerage          = 0;
                                var lastTotalBillingAmount      = 0;
                                var lastBrokerageBillingAmount  = 0;

                                // Remove existing first element in content (assuming it's a placeholder)
                                doc.content.splice(0, 1);

                                // Date string for footer
                                var now = new Date();
                                var jsDate = now.getDate() + '-' + (now.getMonth() + 1) + '-' + now.getFullYear();

                                // Margins and styles
                                doc.pageMargins = [20, 60, 20, 30];
                                doc.defaultStyle.fontSize = 7;
                                doc.styles.tableHeader.fontSize = 7;

                                // Header definition
                                doc['header'] = function() {
                                    return {
                                        columns: [
                                            {
                                                alignment: 'left',
                                                text: "",
                                                fontSize: 14,
                                                margin: [10, 10, 10, 10]
                                            },
                                            {
                                                alignment: 'center',
                                                text: "Company Brokerage Report",
                                                fontSize: 10,
                                                margin: [20, 0, 0, 0]
                                            },
                                            {
                                                alignment: 'right',
                                                text: [
                                                    { text: 'Week Date : ', fontSize: 10 },
                                                    { text: moment().weekday(1).format('DD-MM-YYYY')+ ' - '+ moment().weekday(5).format('DD-MM-YYYY') , fontSize: 10, color: 'red' }
                                                ],
                                                margin: [0, 20, 20, 20]
                                            }
                                        ],
                                        margin: 20
                                    };
                                };

                                // Footer definition
                                doc['footer'] = function(page, pages) {
                                    return {
                                        columns: [
                                            {
                                                alignment: 'left',
                                                text: ['Created on: ', { text: jsDate.toString() }]
                                            },
                                            {
                                                alignment: 'right',
                                                text: ['page ', { text: page.toString() }, ' of ', { text: pages.toString() }]
                                            }
                                        ],
                                        margin: 20
                                    };
                                };

                                // Table layout
                                var objLayout = {
                                    hLineWidth: function(i) { return 0.5; },
                                    vLineWidth: function(i) { return 0.5; },
                                    hLineColor: function(i) { return '#aaa'; },
                                    vLineColor: function(i) { return '#aaa'; },
                                    paddingLeft: function(i) { return 4; },
                                    paddingRight: function(i) { return 4; }
                                };

                                // Applying layout
                                doc.content[0].table.widths = Array(7).fill('14.28%');
                                doc.content[0].layout       = objLayout;

                                // Header row for the table
                                newRows.push([
                                    { text: 'Code', style: 'tableHeader' },
                                    { text: 'Name', style: 'tableHeader' },
                                    { text: 'Lotus Share', style: 'tableHeader', alignment: 'center' },
                                    { text: 'Total BRK', style: 'tableHeader', alignment: 'center' },
                                    { text: 'Return BRK', style: 'tableHeader', alignment: 'center' },
                                    { text: 'Sharing Min BRK', style: 'tableHeader', alignment: 'center' },
                                    { text: 'Sharing Min Lotus BRK', style: 'tableHeader', alignment: 'center' }
                                ]);

                                // Processing each row of the DataTable
                                rows.each(function(row, index) {
                                    var group                = row['managerLogin'];
                                    var totalProfit          = parseFloat(row['totalBrokerage']);
                                    var totalBrokerage       = parseFloat(row['extraBrokerage']);
                                    var billingAmount        = parseFloat(row['sharingBrokerage']);
                                    var lotusBrokerageAmount = parseFloat(row['lotusSharingBrokerage']);
                                    var rowStyle             = (index % 2 === 0) ? {fillColor: '#F0F0F0'} : {};

                                    // Check if new group is encountered
                                    if (lastGroup !== group) {
                                        // If it's not the first group, add the total row for the previous group
                                        if (lastGroup !== null) {
                                            newRows.push([
                                                { text: 'Total', colSpan: 3, bold: true, alignment: 'center' },
                                                {},
                                                {},
                                                { text: numberSeparator(lastTotalProfit, minFractionDigit, maxFractionDigit), style: 'tableBody', bold: true, alignment: 'right' },
                                                { text: numberSeparator(lastTotalBrokerage, minFractionDigit, maxFractionDigit), style: 'tableBody', bold: true, alignment: 'right' },
                                                { text: numberSeparator(lastTotalBillingAmount, minFractionDigit, maxFractionDigit), style: 'tableBody', bold: true, alignment: 'right' },
                                                { text: numberSeparator(lastBrokerageBillingAmount, minFractionDigit, maxFractionDigit), style: 'tableBody', bold: true, alignment: 'right' }
                                            ]);
                                        }

                                        // Add the new group row
                                        newRows.push([{ text: group, colSpan: 7, style: 'tableBody', color: '#FF0000' }]);
                                        lastGroup                   = group;
                                        lastTotalProfit             = 0;
                                        lastTotalBrokerage          = 0;
                                        lastTotalBillingAmount      = 0;
                                        lastBrokerageBillingAmount  = 0;
                                    }

                                    // Add the regular data row
                                    newRows.push([
                                        { text: row['loginId'], style: 'tableBody', ...rowStyle},
                                        { text: row['name'], style: 'tableBody', ...rowStyle},
                                        { text: row['lotusPercentage'], style: 'tableBody', ...rowStyle},
                                        { text: numberSeparator(totalProfit, minFractionDigit, maxFractionDigit), style: 'tableBody', alignment: 'right', ...rowStyle},
                                        { text: numberSeparator(totalBrokerage, minFractionDigit, maxFractionDigit), style: 'tableBody', alignment: 'right', ...rowStyle},
                                        { text: numberSeparator(billingAmount, minFractionDigit, maxFractionDigit), style: 'tableBody', alignment: 'right', ...rowStyle},
                                        { text: numberSeparator(lotusBrokerageAmount, minFractionDigit, maxFractionDigit), style: 'tableBody', alignment: 'right', ...rowStyle}
                                    ]);

                                    // Accumulate totals within the current group
                                    lastTotalProfit             += totalProfit;
                                    lastTotalBrokerage          += totalBrokerage;
                                    lastTotalBillingAmount      += billingAmount;
                                    lastBrokerageBillingAmount  += lotusBrokerageAmount;
                                });

                                // Add the final total row for the last group
                                if (lastGroup !== null) {
                                    newRows.push([
                                        { text: 'Total', colSpan: 3, bold: true, alignment: 'center' },
                                        {},
                                        {},
                                        { text: numberSeparator(lastTotalProfit, minFractionDigit, maxFractionDigit), style: 'tableBody', bold: true, alignment: 'right' },
                                        { text: numberSeparator(lastTotalBrokerage, minFractionDigit, maxFractionDigit), style: 'tableBody', bold: true, alignment: 'right' },
                                        { text: numberSeparator(lastTotalBillingAmount, minFractionDigit, maxFractionDigit), style: 'tableBody', bold: true, alignment: 'right' },
                                        { text: numberSeparator(lastBrokerageBillingAmount, minFractionDigit, maxFractionDigit), style: 'tableBody', bold: true, alignment: 'right' }
                                    ]);
                                }
                                // Assigning the rows to the content body
                                doc.content[0].table.body = newRows;
                            }
                        }
                    ]
                }],
                columnDefs: [{ visible: false, targets: dataColumns }],
                ajax: {
                    url: url,
                    method: "GET",
                    data: function(d) {
                        d.start_date    = "{{ $start_date }}",
                        d.end_date      = "{{ $end_date }}",
                        d.managerId     = $("#managers").val(),
                        d.userId        = $("#users").val();
                    }
                },
                rowCallback: function(row, data) {
                    $(row).addClass('text-center');
                },
                columns: dataColumns,
                order: [
                    [1, "asc"],
                    [0, "asc"]
                ],
                searchDelay: "{{CommonConstants::SEARCH_DELAY}}"
            }, );

        }

        $(document).ready(function() {          
            $('.card-toolbar').append(`<div class="input-group w-250px">
                <input type="week" id="weekPicker" class="form-control form-control-solid rounded rounded-end-0" placeholder="Pick date range"/>
                    <button class="btn btn-icon btn-light" id="weekPickerClear">
                        <span class="fas fa-times">
                    </span>
                </button>
            </div>`);

            // Retrieving start and end dates (in case they are passed from the server-side)
            var start_date = "{{ $start_date }}";
            var end_date = "{{ $end_date }}";

            // Function to determine the current week either based on provided dates or today's date
            function getCurrentWeek() {
                if (start_date && end_date) {
                // If start_date and end_date are provided, convert the start_date into the corresponding week
                return convertToWeekSelection(start_date);
                } else {
                // If no dates are provided, calculate the current ISO week
                return getISOWeek(new Date());
                }
            }

            // Convert the given start_date (YYYY-MM-DD) into the corresponding ISO week (YYYY-WW)
            function convertToWeekSelection(start_date) {
                var startDateObj = new Date(start_date); // Convert the start_date string to a Date object
                return getISOWeek(startDateObj); // Calculate the ISO week for the given date
            }

            // Function to calculate the ISO week (YYYY-WW) for a given date
            function getISOWeek(date) {
                // Find the day of the week for the given date (Sunday = 0, Monday = 1, ..., Saturday = 6)
                var dayOfWeek = date.getDay();

                // Find the Monday of the current week (ISO weeks start on Monday)
                var mondayDate = new Date(date);
                mondayDate.setDate(date.getDate() - (dayOfWeek === 0 ? 6 : dayOfWeek - 1)); // Adjust the date to Monday of the week

                // Adjust to the nearest Thursday to determine the ISO week year
                var adjustedDate = new Date(mondayDate);
                adjustedDate.setDate(mondayDate.getDate() + 4 - (mondayDate.getDay() || 7)); // Move to the nearest Thursday

                // Calculate the start of the year and determine the week number
                var yearStart = new Date(adjustedDate.getFullYear(), 0, 1); // January 1st of the adjusted year
                var weekNumber = Math.ceil(((adjustedDate - yearStart) / 86400000 + 1) / 7); // Calculate the week number

                // Format and return the week as YYYY-WW
                return adjustedDate.getFullYear() + "-W" + ("0" + weekNumber).slice(-2);
            }

            // Function to calculate the start and end dates for a given ISO week (YYYY-WW)
            function getWeekDateRange(weekString) {
                var [year, week] = weekString.split("-W").map(Number); // Split the weekString into year and week

                // Find the first Thursday of the given year to determine the ISO week start
                var firstThursday = new Date(year, 0, 1);
                firstThursday.setDate(firstThursday.getDate() + (4 - (firstThursday.getDay() || 7))); // Adjust to the nearest Thursday

                // Calculate the start date of the ISO week (Monday)
                var startOfWeek = new Date(firstThursday);
                startOfWeek.setDate(firstThursday.getDate() + (week - 1) * 7 - 3); // Calculate the Monday of the selected week

                // Calculate the end date of the ISO week (Sunday)
                var endOfWeek = new Date(startOfWeek);
                endOfWeek.setDate(startOfWeek.getDate() + 6); // Sunday of the same week

                const formatDate = (date) =>
                new Date(date.getTime() - date.getTimezoneOffset() * 60000)
                    .toISOString()
                    .split("T")[0];

                // Return the formatted date range (start date - end date)
                return formatDate(startOfWeek) + " - " + formatDate(endOfWeek);
            }

            // Set the current week in the week picker
            var currentWeek = getCurrentWeek();
            $("#weekPicker").val(currentWeek); // Set the value of the week picker to the current or provided week

            // Set the maximum allowed week selection to the current week
            var maxAllow = getDefaultSelectedWeek();
            $("#weekPicker").attr("max", maxAllow); // Set the max attribute for the week picker to prevent selecting past weeks

            // Event handler for changes in the week picker input field
            $("#weekPicker").on("change", function () {
                var selectedWeek = $(this).val(); // Get the selected week in the format YYYY-WW

                if (!selectedWeek) {
                // If the input is cleared (empty), trigger the click event of the "clear" button
                $("#weekPickerClear").trigger("click");
                } else {
                // If a valid week is selected, process the selected week
                var dateRange = getWeekDateRange(selectedWeek); // Get the start and end date for the selected week
                var [startDate, endDate] = dateRange.split(" - "); // Split the date range into start and end dates

                // Update the attributes and values based on the selected week
                $("#weekPicker").attr("data-date-range", dateRange); // Store the date range in a custom attribute
                $(this).attr("placeholder", dateRange); // Set the placeholder to the date range
                $("#start_date").val(startDate); // Set the start date in the form field
                $("#end_date").val(endDate); // Set the end date in the form field

                // Submit the form with the selected date range
                $("#dateRangeForm").submit();
                }
            });

            // Event handler for the "clear" button
            $("#weekPickerClear").on("click", function () {
                // When the clear button is clicked, set the current week as the selected week
                var currentWeek = getDefaultSelectedWeek();
                $("#weekPicker").val(currentWeek); // Set the value of the week picker to the current week

                // Submit the form with the default week
                $("#dateRangeForm").submit();
            });

            // Function to get the default selected week (current ISO week)
            function getDefaultSelectedWeek() {
                return getISOWeek(new Date()); // Calculate the current ISO week and return it
            }
        });

        $(document).ready(function() {
            var managers    = @json($managers);
            var users       = @json($users);
            var managerId   = $("#managers").val();
            var userId      = $("#users").val();

            $('.card-title').append(`<div class="w-100 d-flex ms-2"><select class="js-example-basic-multiple
                form-select form-select-solid multi-select-option" data-placeholder="Manager" id="managers" data-allow-clear="true">
                <option value=""></option>'
                 ${managers.map(element => {
                    var selected = (managerId == element.id) ? 'selected' : ''; 
                    return '<option value="'+element.id+'" '+selected+'>'+element.loginId+' : ' +element.name+'</option>';
                }).join('')}
            </select>
            </div>`);

            $('.card-title').append(`<div class="w-100 d-flex ms-2"><select class="js-example-basic-multiple
                form-select form-select-solid multi-select-option" data-placeholder="User" id="users" data-allow-clear="true" multiple="multiple">
                ${users.map(element => {
                    var selected = userId == element.loginId ? 'selected' : '';
                    return '<option value="'+element.loginId+'" '+selected+'>'+element.loginId+'</option>';
                }).join('')}
            </select>
            </div>`);

            // Initialize Select2 on the users dropdown
            $('#users').select2({
                allowClear: true,
                tokenSeparators: [','],
            });

            // Event listener for manager dropdown change
            $('#managers').on('change', function() {
                var selectedManagerId = $(this).val(); // Get the selected manager's ID

                // Clear the user dropdown
                $('#users').empty();

                // If no manager is selected, show all users
                if (selectedManagerId === '') {
                    users.forEach(function(user) {
                        $('#users').append(`<option value="${user.loginId}">${user.loginId}</option>`);
                    });
                } else {
                    // Filter users whose managerId matches the selected manager
                    var filteredUsers = users.filter(function(user) {
                        return user.managerId == selectedManagerId;
                    });

                    // Append the filtered users to the dropdown
                    filteredUsers.forEach(function(user) {
                        $('#users').append(`<option value="${user.loginId}">${user.loginId}</option>`);
                    });
                }

                // Get the Select2 container
                var select2Container = $('#users').data('select2').$container;

                // Check if the Select2 dropdown is open by looking for the class in the container
                if (select2Container.hasClass('select2-container--open')) {
                    $('#users').select2('close'); // Close the dropdown if it's open
                }
            });

            var reloadTimeout;
            $('#managers, #users').on('change', function() {
                clearTimeout(reloadTimeout); // Clear any previously set timeout

                reloadTimeout = setTimeout(function() {
                    var table = $('#company_brokerage_table_reports').DataTable();
                    table.ajax.reload();
                }, 1000); // 1000ms = 1 second
            });

            $('#users').on('select2:open', function () {
                let searchField = $('#users').siblings('.select2-container').find('.select2-search__field');

                searchField.on('input', function () {
                    let inputValue = searchField.val().trim();

                    if (inputValue.includes(',')) {
                        let inputValues = inputValue.split(',').map(val => val.trim());
                        let options = $('#users option').map(function () {
                            return $(this).val();
                        }).get();

                        let selectedValues = $('#users').val() || [];
                        let validValues = inputValues.filter(value => options.includes(value));

                        selectedValues = [...new Set([...selectedValues, ...validValues])];

                        if (validValues.length > 0) {
                            $('#users').val(selectedValues).trigger('change');
                        }

                        searchField.val('');
                    }
                });
            });
        });
    </script>
@endsection