@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">
                    <!--begin::Card body-->
                    <form action="{{ route('plSummary') }}" 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="card-body py-4">
                        <!--begin::Table-->
                        <div class="table-responsive">
                            <table class="table align-middle table-row-dashed fs-6 gy-5" id="kt_table_pl_summary">
                                <!--begin::Table head-->
                                <thead>
                                    <!--begin::Table row-->
                                    <tr class="text-center fw-bolder fs-7 text-uppercase gs-0">
                                        <th class="min-w-80px d-none">Manager Id</th>
                                        <th class="min-w-80px">Code</th>
                                        <th class="min-w-80px">Name</th>
                                        <th class="min-w-100px">M2M</th>
                                        <th class="min-w-100px">Min.Brokerage</th>
                                        <th class="min-w-100px">Bill</th>
                                        <th class="min-w-100px">Extra Brkg</th>
                                        <th class="min-w-100px">Gross Bill</th>
                                        <th class="min-w-100px">Manager 1 Share</th>
                                        <th class="min-w-100px">Manager 1 Net</th>
                                        <th class="min-w-100px">Manager 2 Share</th>
                                        <th class="min-w-100px">Manager 2 Net</th>
                                        <th class="min-w-100px">Manager 3 Share</th>
                                        <th class="min-w-100px">Manager 3 Net</th>
                                        <th class="min-w-100px">Manager 4 Share</th>
                                        <th class="min-w-100px">Manager 4 Net</th>
                                        <th class="min-w-100px">Lotus Net</th>
                                    </tr>
                                    <!--end::Table row-->
                                </thead>
                                <!--end::Table head-->
                                <!--begin::Table body-->
                                <tbody class="fw-bold">
                                </tbody>
                                <!--end::Table body-->
                            </table>
                        </div>
                        <!--end::Table-->
                    </div>
                </div>
                <!--end::Card-->
            </div>
            <!--end::Container-->
        </div>
        <!--end::Post-->
    </div>
    <script type="text/javascript">

        const table             = $('#kt_table_pl_summary');
        const token             = "{{ csrf_token() }}";

        var fileName            = "PL_SUMMARY";
        var title               = fileName + '_' +Date.now();
        var columns             = [1, 2, 3, 4, 5, 6, 7,8, 9, 10, 11, 12, 13, 14, 15, 16];
        var minFractionDigit    = "{{CommonConstants::PL_SUMMARY['MIN_FRACTION_DIGIT']}}";
        var maxFractionDigit    = "{{CommonConstants::PL_SUMMARY['MAX_FRACTION_DIGIT']}}";
        var url;        
        var jsDate              = new Date();
        var formattedDate       = jsDate.toLocaleString('en-US', { 
                                    year: 'numeric', 
                                    month: '2-digit', 
                                    day: '2-digit', 
                                    hour: '2-digit', 
                                    minute: '2-digit', 
                                    hour12: false 
                                }).replace(',', '');
        var pdfFooterText = ("{{CommonConstants::BILLING_PDF['FOOTER_TEXT']}}").replace('DATE_TIME', formattedDate).replace(/&amp;/g, '&');

        var dataColumns = [
            {
                data: 'managerLogin',
                name: 'managerLogin',
                visible: false
            },
            {
                data: 'loginId',
                name: 'loginId'
            },
            {
                data: 'name',
                name: 'name',
                render: function(data, type, full, meta) {
                    var name = full.name ? full.name : ''
                    return name;
                } 
            },
            {
                data: 'totalProfit',
                name: 'totalProfit',
                render: function(data, type, full, meta) {

                    return `<span class="fs-4 mb-0">
                            ${numberSeparator(full.totalProfit, minFractionDigit, maxFractionDigit)}</span>`;
                },
                searchable: false,
            },
            {
                data: 'totalBrokerage',
                name: 'totalBrokerage',
                render: function(data, type, full, meta) {
                return `<span class="fs-4 mb-0">
                        ${numberSeparator(full.totalBrokerage, minFractionDigit, maxFractionDigit)}</span>`;
                },
            },
            {
                data: 'billingAmount',
                name: 'billingAmount',
                render: function(data, type, full, meta) {
                return `<span class="fs-4 mb-0">
                        ${numberSeparator(full.billingAmount, minFractionDigit, maxFractionDigit)}</span>`;
                },
            },
            {
                data: 'extraBrokerage',
                name: 'extraBrokerage',
                render: function(data, type, full, meta) {
                return `<span class="fs-4 mb-0">
                        ${numberSeparator(full.extraBrokerage, minFractionDigit, maxFractionDigit)}</span>`;
                },
            },
            {
                data: 'grossBill',
                name: 'grossBill',
                render: function(data, type, full, meta) {
                return `<span class="fs-4 mb-0">
                        ${numberSeparator(full.grossBill, minFractionDigit, maxFractionDigit)}</span>`;
                },
            },
            {
                data: 'managerOnePercentage',
                name: 'managerOnePercentage',
                render: function(data, type, full, meta) {
                    return `<span class="fs-4 mb-0">${full.managerOnePercentage == null ? '-' : full.managerOnePercentage}</span>`;
                },
            },
            {
                data: 'managerOneNet',
                name: 'managerOneNet',
                render: function(data, type, full, meta) {
                    var managerOneNet = full.managerOneNet;
                    if (managerOneNet != '-') {
                        managerOneNet = numberSeparator(Number(full.managerOneNet), minFractionDigit, maxFractionDigit)
                    }
                    return `<span class="fs-4 mb-0">${managerOneNet}</span>`;
                },
            },
            {
                data: 'managerTwoPercentage',
                name: 'managerTwoPercentage',
                render: function(data, type, full, meta) {                    
                    return `<span class="fs-4 mb-0">${full.managerTwoPercentage == null ? '-' : full.managerTwoPercentage}</span>`;
                },
            },
            {
                data: 'managerTwoNet',
                name: 'managerTwoNet',
                render: function(data, type, full, meta) {
                    var managerTwoNet = full.managerTwoNet;
                    if (managerTwoNet != '-') {
                        managerTwoNet = numberSeparator(Number(full.managerTwoNet), minFractionDigit, maxFractionDigit)
                    }
                    return `<span class="fs-4 mb-0">${managerTwoNet}</span>`;
                },
            },
            {
                data: 'managerThreePercentage',
                name: 'managerThreePercentage',
                render: function(data, type, full, meta) {                    
                    return `<span class="fs-4 mb-0">${full.managerThreePercentage == null ? '-' : full.managerThreePercentage}</span>`;
                },
            },
            {
                data: 'managerThreeNet',
                name: 'managerThreeNet',
                render: function(data, type, full, meta) {
                    var managerThreeNet = full.managerThreeNet;
                    if (managerThreeNet != '-') {
                        managerThreeNet = numberSeparator(Number(full.managerThreeNet), minFractionDigit, maxFractionDigit)
                    }
                    return `<span class="fs-4 mb-0">${managerThreeNet}</span>`;
                },
            },
            {
                data: 'managerFourPercentage',
                name: 'managerFourPercentage',
                render: function(data, type, full, meta) {                    
                    return `<span class="fs-4 mb-0">${full.managerFourPercentage == null ? '-' : full.managerFourPercentage}</span>`;
                },
            },
            {
                data: 'managerFourNet',
                name: 'managerFourNet',
                render: function(data, type, full, meta) {
                    var managerFourNet = full.managerFourNet;
                    if (managerFourNet != '-') {
                        managerFourNet = numberSeparator(Number(full.managerFourNet), minFractionDigit, maxFractionDigit)
                    }
                    return `<span class="fs-4 mb-0">${managerFourNet}</span>`;
                },
            },
            {
                data: 'lotusNet',
                name: 'lotusNet',
                render: function(data, type, full, meta) {
                    return `<span class="fs-4 mb-0">
                        ${numberSeparator(full.lotusNet, minFractionDigit, maxFractionDigit)}</span>`;
                },
            }
        ];

        $.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 totalProfitColumn           = 3;
            var totalBrokerageColumn        = 4;
            var totalBillingAmountColumn    = 5;
            var totalExtraBrokerageColumn   = 6;
            var totalGrossBillColumn        = 7;
            var totalManagerOneColumn       = 9;
            var totalManagerTwoColumn       = 11;
            var totalManagerThreeColumn     = 13;
            var totalManagerFourColumn      = 15;
            var totalLotusNetColumn         = 16;

            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'<'custom-button-container'>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,
                serverSide: false,
                drawCallback: function(settings) {
                    var api                         = this.api();
                    var rows                        = api.rows().nodes();
                    var lastGroup                   = null;
                    var lastTotalProfit             = 0;
                    var lastTotalBrokerage          = 0;
                    var lastBillingAmount           = 0;
                    var lastTotalExtraBrokerage     = 0;
                    var lastTotalGrossBill          = 0;
                    var lastTotalManagerNet         = 0;
                    var lastTotalManagerTwoNet      = 0;
                    var lastTotalManagerThreeNet    = 0;
                    var lastTotalManagerFourNet     = 0;
                    var lastTotalLotusNet           = 0;
                    var lastRowIndex                = -1;

                    api.column(groupColumn).data().each(function(group, i) {
                        var totalProfit = parseFloat(api.column(totalProfitColumn).data()[i]) || 0;
                        var totalBrokerage = parseFloat(api.column(totalBrokerageColumn).data()[i]) || 0;
                        var billingAmount = parseFloat(api.column(totalBillingAmountColumn).data()[i]) || 0;
                        var extraBrokerage = parseFloat(api.column(totalExtraBrokerageColumn).data()[i]) || 0;
                        var grossBill = parseFloat(api.column(totalGrossBillColumn).data()[i]) || 0;
                        var managerNet = parseFloat(api.column(totalManagerOneColumn).data()[i]) || 0;
                        var managerTwoNet = parseFloat(api.column(totalManagerTwoColumn).data()[i]) || 0;
                        var managerThreeNet = parseFloat(api.column(totalManagerThreeColumn).data()[i]) || 0;
                        var managerFourNet = parseFloat(api.column(totalManagerFourColumn).data()[i]) || 0;
                        var lotusNet = parseFloat(api.column(totalLotusNetColumn).data()[i]) || 0;

                        if (lastGroup !== group) {
                            if (lastRowIndex !== -1) {
                                $(rows).eq(lastRowIndex).after(
                                    '<tr class="group even">' +
                                    '<td colspan="2" class="fs-3 text-center fw-bold">Total</td>' +
                                    '<td class="fs-3 text-dark text-center fs-3 fw-boldest">' + numberSeparator(lastTotalProfit, minFractionDigit, maxFractionDigit) + '</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(lastBillingAmount, 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(lastTotalGrossBill, minFractionDigit, maxFractionDigit) + '</td>' +
                                    '<td class="fs-3 text-dark text-center fs-3 fw-boldest">-</td>' +
                                    '<td class="fs-3 text-dark text-center fs-3 fw-boldest">' + numberSeparator(lastTotalManagerNet, minFractionDigit, maxFractionDigit) + '</td>' +
                                    '<td class="fs-3 text-dark text-center fs-3 fw-boldest">-</td>' +
                                    '<td class="fs-3 text-dark text-center fs-3 fw-boldest">' + numberSeparator(lastTotalManagerTwoNet, minFractionDigit, maxFractionDigit) + '</td>' +
                                    '<td class="fs-3 text-dark text-center fs-3 fw-boldest">-</td>' +
                                    '<td class="fs-3 text-dark text-center fs-3 fw-boldest">' + numberSeparator(lastTotalManagerThreeNet, minFractionDigit, maxFractionDigit) + '</td>' +
                                    '<td class="fs-3 text-dark text-center fs-3 fw-boldest">-</td>' +
                                    '<td class="fs-3 text-dark text-center fs-3 fw-boldest">' + numberSeparator(lastTotalManagerFourNet, minFractionDigit, maxFractionDigit) + '</td>' +
                                    '<td class="fs-3 text-dark text-center fs-3 fw-boldest">' + numberSeparator(lastTotalLotusNet, minFractionDigit, maxFractionDigit) + '</td>' +
                                    '</tr>'
                                );
                            }

                            lastGroup                   = group;
                            lastTotalProfit             = totalProfit;
                            lastTotalBrokerage          = totalBrokerage;
                            lastBillingAmount           = billingAmount;
                            lastTotalExtraBrokerage     = extraBrokerage;
                            lastTotalGrossBill          = grossBill;
                            lastTotalManagerNet         = managerNet;
                            lastTotalManagerTwoNet      = managerTwoNet;
                            lastTotalManagerThreeNet    = managerThreeNet;
                            lastTotalManagerFourNet     = managerFourNet;
                            lastTotalLotusNet           = lotusNet;

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

                            lastTotalProfit             += totalProfit;
                            lastTotalBrokerage          += totalBrokerage;
                            lastBillingAmount           += billingAmount;
                            lastTotalExtraBrokerage     += extraBrokerage;
                            lastTotalGrossBill          += grossBill;
                            lastTotalManagerNet         += managerNet;
                            lastTotalManagerTwoNet      += managerTwoNet;
                            lastTotalManagerThreeNet    += managerThreeNet;
                            lastTotalManagerFourNet     += managerFourNet;
                            lastTotalLotusNet           += lotusNet;
                        }

                        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="2" class="fs-3 text-center fw-bold">Total</td>' +
                                '<td class="fs-3 text-dark text-center fs-3 fw-boldest">' + numberSeparator(lastTotalProfit, minFractionDigit, maxFractionDigit) + '</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(lastBillingAmount, 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(lastTotalGrossBill, minFractionDigit, maxFractionDigit) + '</td>' +
                                '<td class="fs-3 text-dark text-center fs-3 fw-boldest">-</td>' +
                                '<td class="fs-3 text-dark text-center fs-3 fw-boldest">' + numberSeparator(lastTotalManagerNet, minFractionDigit, maxFractionDigit) + '</td>' +
                                '<td class="fs-3 text-dark text-center fs-3 fw-boldest">-</td>' +
                                '<td class="fs-3 text-dark text-center fs-3 fw-boldest">' + numberSeparator(lastTotalManagerTwoNet, minFractionDigit, maxFractionDigit) + '</td>' +
                                '<td class="fs-3 text-dark text-center fs-3 fw-boldest">-</td>' +
                                '<td class="fs-3 text-dark text-center fs-3 fw-boldest">' + numberSeparator(lastTotalManagerThreeNet, minFractionDigit, maxFractionDigit) + '</td>' +
                                '<td class="fs-3 text-dark text-center fs-3 fw-boldest">-</td>' +
                                '<td class="fs-3 text-dark text-center fs-3 fw-boldest">' + numberSeparator(lastTotalManagerFourNet, minFractionDigit, maxFractionDigit) + '</td>' +
                                '<td class="fs-3 text-dark text-center fs-3 fw-boldest">' + numberSeparator(lastTotalLotusNet, minFractionDigit, maxFractionDigit) + '</td>' +
                                '</tr>'
                            );
                        }
                    }
                },
                "stateSaveParams": function (settings, data) {
                    data.search.search = '';
                },
                pageLength: 10,
                "lengthMenu": {!! json_encode(CommonConstants::ALL_PAGE_PER_DATA) !!},
                language: {
                    searchPlaceholder: "Search",
                    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 lastTotalExtraBrokerage     = 0;
                                var lastTotalGrossBill          = 0;
                                var lastTotalManagerNet         = 0;
                                var lastTotalManagerTwoNet      = 0;
                                var lastTotalManagerThreeNet    = 0;
                                var lastTotalManagerFourNet     = 0;
                                var lastTotalLotusNet           = 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;

                                // PDF landscape
                                doc.pageOrientation = 'landscape';

                                // Header definition
                                doc['header'] = function() {
                                    return {
                                        columns: [
                                            {
                                                alignment: 'left',
                                                text: "",
                                                fontSize: 14,
                                                margin: [10, 10, 10, 10]
                                            },
                                            {
                                                alignment: 'center',
                                                text: "{{CommonConstants::PL_SUMMARY['PDF_HEADING']}}",
                                                fontSize: 10,
                                                margin: [20, 0, 0, 0]
                                            },
                                            {
                                                alignment: 'right',
                                                text: [
                                                    { text: 'Week Date : ', fontSize: 10 },
                                                    { text: "{{ $start_date }}" + ' - '+ "{{ $end_date }}" , fontSize: 10, color: 'red' }
                                                ],
                                                margin: [0, 20, 20, 20]
                                            }
                                        ],
                                        margin: 20
                                    };
                                };

                                // Footer definition
                                doc['footer'] = function(page, pages) {
                                    return {
                                        columns: [
                                            {
                                                alignment: 'left',
                                                text: pdfFooterText,
                                                fontSize: 8
                                            },
                                            {
                                                alignment: 'right',
                                                text: ['Page ', { text: page.toString() }, ' of ', { text: pages.toString() }]
                                            }
                                        ],
                                        margin: [20, 0, 20, 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(16).fill('6.25%');
                                doc.content[0].layout = objLayout;

                                // Header row for the table
                                newRows.push([
                                    { text: 'Code', style: 'tableHeader' },
                                    { text: 'Name', style: 'tableHeader' },
                                    { text: 'M2M', style: 'tableHeader', alignment: 'center' },
                                    { text: 'Brokerage', style: 'tableHeader', alignment: 'center' },
                                    { text: 'Bill', style: 'tableHeader', alignment: 'center' },
                                    { text: 'Extra Brkg', style: 'tableHeader', alignment: 'center' },
                                    { text: 'Gross Bill', style: 'tableHeader', alignment: 'center' },
                                    { text: 'Manager 1 Share', style: 'tableHeader', alignment: 'center' },
                                    { text: 'Manager 1 Net', style: 'tableHeader', alignment: 'center' },
                                    { text: 'Manager 2 Share', style: 'tableHeader', alignment: 'center' },
                                    { text: 'Manager 2 Net', style: 'tableHeader', alignment: 'center' },
                                    { text: 'Manager 3 Share', style: 'tableHeader', alignment: 'center' },
                                    { text: 'Manager 3 Net', style: 'tableHeader', alignment: 'center' },
                                    { text: 'Manager 4 Share', style: 'tableHeader', alignment: 'center' },
                                    { text: 'Manager 4 Net', style: 'tableHeader', alignment: 'center' },
                                    { text: 'Lotus Net', style: 'tableHeader', alignment: 'center' }
                                ]);

                                // Processing each row of the DataTable
                                rows.each(function(row, index) {
                                    var group           = row['managerLogin'];
                                    var totalProfit     = parseFloat(row['totalProfit']);
                                    var totalBrokerage  = parseFloat(row['totalBrokerage']);
                                    var billingAmount   = parseFloat(row['billingAmount']);
                                    var extraBrokerage  = parseFloat(row['extraBrokerage']);
                                    var grossBill       = parseFloat(row['grossBill']);
                                    var managerNet      = row['managerOneNet'] != '-' ? parseFloat(row['managerOneNet']) : '-';
                                    var managerTwoNet   = row['managerTwoNet'] != '-' ? parseFloat(row['managerTwoNet']) : '-';
                                    var managerThreeNet   = row['managerThreeNet'] != '-' ? parseFloat(row['managerThreeNet']) : '-';
                                    var managerFourNet   = row['managerFourNet'] != '-' ? parseFloat(row['managerFourNet']) : '-';
                                    var lotusNet        = parseFloat(row['lotusNet']);

                                    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: 2, 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(lastTotalExtraBrokerage, minFractionDigit, maxFractionDigit), style: 'tableBody', bold: true, alignment: 'right' },
                                                { text: numberSeparator(lastTotalGrossBill, minFractionDigit, maxFractionDigit), style: 'tableBody', bold: true, alignment: 'right' },
                                                { text: '-', bold: true, alignment: 'center' },
                                                { text: numberSeparator(lastTotalManagerNet, minFractionDigit, maxFractionDigit), style: 'tableBody', bold: true, alignment: 'right' },
                                                { text: '-', bold: true, alignment: 'center' },
                                                { text: numberSeparator(lastTotalManagerTwoNet, minFractionDigit, maxFractionDigit), style: 'tableBody', bold: true, alignment: 'right' },
                                                { text: '-', bold: true, alignment: 'center' },
                                                { text: numberSeparator(lastTotalManagerThreeNet, minFractionDigit, maxFractionDigit), style: 'tableBody', bold: true, alignment: 'right' },
                                                { text: '-', bold: true, alignment: 'center' },
                                                { text: numberSeparator(lastTotalManagerFourNet, minFractionDigit, maxFractionDigit), style: 'tableBody', bold: true, alignment: 'right' },
                                                { text: numberSeparator(lastTotalLotusNet, minFractionDigit, maxFractionDigit), style: 'tableBody', bold: true, alignment: 'right' }
                                            ]);
                                        }

                                        // Add the new group row
                                        newRows.push([{ text: group, colSpan: 16, style: 'tableBody', color: '#FF0000' }]);
                                        lastGroup                   = group;
                                        lastTotalProfit             = 0;
                                        lastTotalBrokerage          = 0;
                                        lastTotalBillingAmount      = 0;
                                        lastTotalExtraBrokerage     = 0;
                                        lastTotalGrossBill          = 0;
                                        lastTotalManagerNet         = 0;
                                        lastTotalManagerTwoNet      = 0;
                                        lastTotalManagerThreeNet    = 0;
                                        lastTotalManagerFourNet     = 0;
                                        lastTotalLotusNet           = 0;
                                    }

                                    // Add the regular data row
                                    newRows.push([
                                        { text: row['loginId'], style: 'tableBody', ...rowStyle },
                                        { text: row['name'], 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(extraBrokerage, minFractionDigit, maxFractionDigit), style: 'tableBody', alignment: 'right', ...rowStyle },
                                        { text: numberSeparator(grossBill, minFractionDigit, maxFractionDigit), style: 'tableBody', alignment: 'right', ...rowStyle },
                                        { text: row['managerOnePercentage'] ? row['managerOnePercentage'] : '-', style: 'tableBody', alignment: 'right', ...rowStyle },
                                        { text: numberSeparator(managerNet, minFractionDigit, maxFractionDigit), style: 'tableBody', alignment: 'right', ...rowStyle },
                                        { text: row['managerTwoPercentage'] ? row['managerTwoPercentage'] : '-', style: 'tableBody', alignment: 'right', ...rowStyle },
                                        { text: numberSeparator(managerTwoNet, minFractionDigit, maxFractionDigit), style: 'tableBody', alignment: 'right', ...rowStyle },
                                        { text: row['managerThreePercentage'] ? row['managerThreePercentage'] : '-', style: 'tableBody', alignment: 'right', ...rowStyle },
                                        { text: numberSeparator(managerThreeNet, minFractionDigit, maxFractionDigit), style: 'tableBody', alignment: 'right', ...rowStyle },
                                        { text: row['managerFourPercentage'] ? row['managerFourPercentage'] : '-', style: 'tableBody', alignment: 'right', ...rowStyle },
                                        { text: numberSeparator(managerFourNet, minFractionDigit, maxFractionDigit), style: 'tableBody', alignment: 'right', ...rowStyle },
                                        { text: numberSeparator(lotusNet, minFractionDigit, maxFractionDigit), style: 'tableBody', alignment: 'right', ...rowStyle }
                                    ]);

                                    // Accumulate totals within the current group
                                    lastTotalProfit += totalProfit;
                                    lastTotalBrokerage += totalBrokerage;
                                    lastTotalBillingAmount += billingAmount;
                                    lastTotalExtraBrokerage += extraBrokerage;
                                    lastTotalGrossBill += grossBill;
                                    lastTotalManagerNet += managerNet;
                                    if (managerTwoNet != '-') {
                                        lastTotalManagerTwoNet += managerTwoNet;
                                    }
                                    if (managerThreeNet != '-') {
                                        lastTotalManagerThreeNet += managerThreeNet;
                                    }
                                    if (managerFourNet != '-') {
                                        lastTotalManagerFourNet += managerFourNet;
                                    }
                                    lastTotalLotusNet += lotusNet;
                                });

                                // Add the final total row for the last group
                                if (lastGroup !== null) {
                                    newRows.push([
                                        { text: 'Total', colSpan: 2, 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(lastTotalExtraBrokerage, minFractionDigit, maxFractionDigit), style: 'tableBody', bold: true, alignment: 'right' },
                                        { text: numberSeparator(lastTotalGrossBill, minFractionDigit, maxFractionDigit), style: 'tableBody', bold: true, alignment: 'right' },
                                        { text: '-', style: 'tableBody', alignment: 'center' },
                                        { text: numberSeparator(lastTotalManagerNet, minFractionDigit, maxFractionDigit), style: 'tableBody', bold: true, alignment: 'right' },
                                        { text: '-', style: 'tableBody', alignment: 'center' },
                                        { text: numberSeparator(lastTotalManagerTwoNet, minFractionDigit, maxFractionDigit), style: 'tableBody', bold: true, alignment: 'right' },
                                        { text: '-', style: 'tableBody', alignment: 'center' },
                                        { text: numberSeparator(lastTotalManagerThreeNet, minFractionDigit, maxFractionDigit), style: 'tableBody', bold: true, alignment: 'right' },
                                        { text: '-', style: 'tableBody', alignment: 'center' },
                                        { text: numberSeparator(lastTotalManagerFourNet, minFractionDigit, maxFractionDigit), style: 'tableBody', bold: true, alignment: 'right' },
                                        { text: numberSeparator(lastTotalLotusNet, minFractionDigit, maxFractionDigit), style: 'tableBody', bold: true, alignment: 'right' }
                                    ]);
                                }

                                // Assigning the rows to the content body
                                doc.content[0].table.body = newRows;
                            }

                        },{
                            extend: "pdfHtml5",
                            text: 'CMX 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 lastTotalExtraBrokerage     = 0;
                                var lastTotalGrossBill          = 0;
                                var lastTotalManagerNet         = 0;
                                var lastTotalManagerOneConvNet  = 0;
                                var lastTotalManagerTwoNet      = 0;
                                var lastTotalManagerThreeNet    = 0;
                                var lastTotalManagerFourNet     = 0;
                                var lastTotalLotusNet           = 0;
                                var lastTotalLotusConvNet       = 0;
                                var lastTotalGrossBillConvNet   = 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;

                                // PDF landscape
                                doc.pageOrientation = 'landscape';

                                // Header definition
                                doc['header'] = function() {
                                    return {
                                        columns: [
                                            {},
                                            {
                                                alignment: 'center',
                                                text: "{{CommonConstants::PL_SUMMARY['CMX_PDF_HEADING']}}",
                                                fontSize: 10,
                                                margin: [20, 0, 0, 0]
                                            },
                                            {}
                                        ],
                                        margin: 20
                                    };
                                };

                                // Footer definition
                                doc['footer'] = function(page, pages) {
                                    return {
                                        columns: [
                                            {
                                                alignment: 'left',
                                                text: pdfFooterText,
                                                fontSize: 8
                                            },
                                            {
                                                alignment: 'right',
                                                text: ['Page ', { text: page.toString() }, ' of ', { text: pages.toString() }]
                                            }
                                        ],
                                        margin: [20, 0, 20, 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 = ['10%', '10%', '10%', '10%', '10%', '10%', '5%', '5%', '10%', '10%', '10%'];
                                // doc.content[0].table.widths = ['10%', '25%', '20%', '20%', '25%'];
                                doc.content[0].layout = objLayout;
                                doc.content[0].table.headerRows = 2;

                                var noBorder = { border: [false, false, false, false] };
                                var thickTop = {
                                    border: [false, true, false, false],
                                    borderWidth: [0, 2, 0, 0],
                                    borderColor: ['black', 'black', 'black', 'black']
                                };
                                var thickBottom = {
                                    border: [false, false, false, true],
                                    borderWidth: [0, 0, 0, 2],
                                    borderColor: ['black', 'black', 'black', 'black']
                                };

                                newRows.push([
                                    {
                                        text: "{{CommonConstants::PL_SUMMARY['CMX_TABLE_HEADING']}}" + ' ' +
                                            moment("{{ $start_date }}").isoWeekday(1).format('DD/MM/YYYY') + ' To ' +
                                            moment("{{ $end_date }}").isoWeekday(5).format('DD/MM/YYYY'),
                                        colSpan: 11,
                                        style: 'tableHeader',
                                        fillColor: '#a6a6a6',
                                        color: 'black'
                                    },
                                    {}, {}, {}, {}, {}, {}, {}, {}, {}, {}
                                ]);

                                // Header row for the table
                                newRows.push([
                                    { text: 'Party Name', style: 'tableHeader', alignment: 'left', fillColor: '#ffffff', color: 'blue', ...noBorder },
                                    { text: 'Gross', style: 'tableHeader', alignment: 'right', fillColor: '#ffffff', color: 'blue', ...noBorder },
                                    { text: 'Brok', style: 'tableHeader', alignment: 'right', fillColor: '#ffffff', color: 'blue', ...noBorder },
                                    { text: 'Bill Amt', style: 'tableHeader', alignment: 'right', fillColor: '#ffffff', color: 'blue', ...noBorder },
                                    { text: 'Brk Brok', style: 'tableHeader', alignment: 'right', fillColor: '#ffffff', color: 'blue', ...noBorder },
                                    { text: 'Net Amt', style: 'tableHeader', alignment: 'right', fillColor: '#ffffff', color: 'blue', ...noBorder },
                                    { text: 'Sh %', style: 'tableHeader', alignment: 'center', fillColor: '#ffffff', color: 'blue', ...noBorder },
                                    { text: 'Pair Name', style: 'tableHeader', alignment: 'center', fillColor: '#ffffff', color: 'blue', ...noBorder },
                                    { text: 'Bill Amt', style: 'tableHeader', alignment: 'center', fillColor: '#ffffff', color: 'blue', ...noBorder },
                                    { text: 'Share', style: 'tableHeader', alignment: 'center', fillColor: '#ffffff', color: 'blue', ...noBorder },
                                    { text: 'Lotus Net Amt', style: 'tableHeader', alignment: 'right', fillColor: '#ffffff', color: 'blue', ...noBorder }
                                ]);

                                // Processing each row of the DataTable
                                rows.each(function(row, index) {

                                    var cmxPair     = row['cmxPair'];
                                    var cmxRate     = row['cmxRate'];
                                    var cmxPrice    = row['cmxPrice'];

                                    if (cmxPair == null && cmxRate == null && cmxPrice == null) {
                                        return;
                                    }

                                    var group               = row['managerLogin'];
                                    var totalProfit         = parseFloat(row['totalProfit']);
                                    var totalBrokerage      = parseFloat(row['totalBrokerage']);
                                    var billingAmount       = parseFloat(row['billingAmount']);
                                    var extraBrokerage      = parseFloat(row['extraBrokerage']);
                                    var grossBill           = parseFloat(row['grossBill']);
                                    var managerNet          = row['managerOneNet'] != '-' ? parseFloat(row['managerOneNet']) : '-';
                                    var managerTwoNet       = row['managerTwoNet'] != '-' ? parseFloat(row['managerTwoNet']) : '-';
                                    var managerThreeNet     = row['managerThreeNet'] != '-' ? parseFloat(row['managerThreeNet']) : '-';
                                    var managerFourNet      = row['managerFourNet'] != '-' ? parseFloat(row['managerFourNet']) : '-';
                                    // var lotusNet            = parseFloat(row['lotusNet']);
                                    var lotusNet            = (managerNet != '-' && grossBill != null) ? grossBill - managerNet : 0;

                                    var cmxConvPrice        = (cmxPrice != null && grossBill >= 0) ? (cmxPrice - cmxRate) : (cmxPrice != null ? (cmxPrice + cmxRate) : '-');
                                    var grossBillConvNet    = (grossBill != null && cmxConvPrice != '-')? (grossBill * cmxConvPrice) : 0;
                                    var managerOneConvNet   = (managerNet != '-' && cmxConvPrice != '-') ? (managerNet * cmxConvPrice) : '-';
                                    var lotusConvNet        = (lotusNet != '-' && cmxConvPrice != '-') ? (lotusNet * cmxConvPrice) : '-';
                                    var match               = row['managerOnePercentage'].match(/\((\d+)%\)/);
                                    var managerPercentage   = match ? parseFloat(match[1]).toFixed(2) : '-';

                                    var rowStyle        = (index % 2 === 0) ? {fillColor: '#F0F0F0'} : {};
                                    var managerLoginId  = group.split(':')[0].trim();

                                    // 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: lastGroup, bold: true, alignment: 'center', fillColor: '#a6a6a6', color: 'black', ...thickBottom },
                                                { text: numberSeparator(lastTotalProfit, minFractionDigit, maxFractionDigit), style: 'tableBody', bold: true, alignment: 'right', ...thickBottom },
                                                { text: '-' + numberSeparator(lastTotalBrokerage, minFractionDigit, maxFractionDigit), style: 'tableBody', bold: true, alignment: 'right', ...thickBottom },
                                                { text: numberSeparator(lastTotalBillingAmount, minFractionDigit, maxFractionDigit), style: 'tableBody', bold: true, alignment: 'right', color: lastTotalBillingAmount >= 0 ? 'blue' : 'red', ...thickBottom },
                                                { text: numberSeparator(lastTotalExtraBrokerage, minFractionDigit, maxFractionDigit), style: 'tableBody', bold: true, alignment: 'right', color: 'red', ...thickBottom },
                                                { text: numberSeparator(lastTotalGrossBill, minFractionDigit, maxFractionDigit), style: 'tableBody', bold: true, alignment: 'right', color: lastTotalGrossBill >= 0 ? 'blue' : 'red', ...thickBottom },
                                                { text: '', bold: true, alignment: 'center', ...thickBottom },
                                                { text: '', bold: true, alignment: 'center', ...thickBottom },
                                                { text: numberSeparator(lastTotalGrossBillConvNet, minFractionDigit, maxFractionDigit), style: 'tableBody', bold: true, alignment: 'right', ...thickBottom },
                                                { text: numberSeparator(-lastTotalManagerOneConvNet, minFractionDigit, maxFractionDigit), style: 'tableBody', bold: true, alignment: 'right', color: -lastTotalManagerOneConvNet >= 0 ? 'blue' : 'red', ...thickBottom },
                                                { text: numberSeparator(lastTotalLotusConvNet, minFractionDigit, maxFractionDigit), style: 'tableBody', bold: true, alignment: 'right', ...thickBottom }
                                            ]);
                                        }

                                        // Add the new group row
                                        newRows.push([
                                            {
                                                text: managerLoginId,
                                                style: 'tableBody',
                                                bold: true,
                                                color: 'black',
                                                fillColor: '#a6a6a6',
                                                ...thickTop,
                                                borderColor: ['black', 'black', 'black', 'black'],
                                                borderWidth: [0, 2, 0, 0],
                                                pageBreak: lastGroup != null ? 'before' : undefined
                                            },
                                            {
                                                text: group,
                                                colSpan: 2,
                                                style: 'tableBody',
                                                bold: true,
                                                color: 'black',
                                                fillColor: '#a6a6a6',
                                                ...thickTop,
                                                borderColor: ['black', 'black', 'black', 'black'],
                                                borderWidth: [0, 2, 0, 0],
                                                pageBreak: lastGroup != null ? 'before' : undefined
                                            },
                                            {},
                                            { text: '', colSpan: 5, ...thickTop, borderColor: ['black', 'black', 'black', 'black'], borderWidth: [0, 2, 0, 0]},
                                            {},
                                            {},
                                            {},
                                            {},
                                            { 
                                                text: cmxPair,
                                                style: 'tableBody',
                                                bold: true,
                                                ...thickTop,
                                                borderColor: ['black', 'black', 'black', 'black'],
                                                borderWidth: [0, 2, 0, 0],
                                                pageBreak: lastGroup !== null ? 'before' : undefined
                                             },
                                            { 
                                                text: cmxPair + ' - Net',
                                                colSpan: 2,
                                                style: 'tableBody',
                                                bold: true,
                                                ...thickTop,
                                                borderColor: ['black', 'black', 'black', 'black'],
                                                borderWidth: [0, 2, 0, 0],
                                                pageBreak: lastGroup !== null ? 'before' : undefined 
                                            },
                                            { 
                                                text: cmxPair + ' - Net',
                                                style: 'tableBody',
                                                bold: true,
                                                color: '#FF0000',
                                                ...thickTop,
                                                borderColor: ['black', 'black', 'black', 'black'],
                                                borderWidth: [0, 2, 0, 0],
                                                pageBreak: lastGroup !== null ? 'before' : undefined 
                                            },
                                        ]);
                                        lastGroup                   = group;
                                        lastTotalProfit             = 0;
                                        lastTotalBrokerage          = 0;
                                        lastTotalBillingAmount      = 0;
                                        lastTotalExtraBrokerage     = 0;
                                        lastTotalGrossBill          = 0;
                                        lastTotalManagerNet         = 0;
                                        lastTotalManagerOneConvNet  = 0;
                                        lastTotalManagerTwoNet      = 0;
                                        lastTotalManagerThreeNet    = 0;
                                        lastTotalManagerFourNet     = 0;
                                        lastTotalLotusNet           = 0;
                                        lastTotalLotusConvNet       = 0;
                                        lastTotalGrossBillConvNet   = 0;
                                    }

                                    // Add the regular data row
                                    newRows.push([
                                        { text: row['loginId'] + ' ' + row['name'], style: 'tableBody', ...noBorder },
                                        { text: numberSeparator(totalProfit, minFractionDigit, maxFractionDigit), style: 'tableBody', alignment: 'right', color: totalProfit >= 0 ? 'blue' : 'red', ...noBorder },
                                        { text: '-' + numberSeparator(totalBrokerage, minFractionDigit, maxFractionDigit), style: 'tableBody', alignment: 'right', color: 'red', ...noBorder },
                                        { text: numberSeparator(billingAmount, minFractionDigit, maxFractionDigit), style: 'tableBody', alignment: 'right', color: billingAmount >= 0 ? 'blue' : 'red', ...noBorder },
                                        { text: numberSeparator(extraBrokerage, minFractionDigit, maxFractionDigit), style: 'tableBody', alignment: 'right', color: 'blue', ...noBorder },
                                        { text: numberSeparator(grossBill, minFractionDigit, maxFractionDigit), style: 'tableBody', alignment: 'right', color: grossBill >= 0 ? 'blue' : 'red', ...noBorder },
                                        { text: managerPercentage, style: 'tableBody', alignment: 'center', ...noBorder },
                                        { text: parseFloat(cmxConvPrice).toFixed(2), style: 'tableBody', alignment: 'center', ...noBorder },
                                        { text: numberSeparator(grossBillConvNet, minFractionDigit, maxFractionDigit), style: 'tableBody', alignment: 'right', color: grossBillConvNet >= 0 ? 'blue' : 'red', ...noBorder },
                                        { text: numberSeparator(-managerOneConvNet, minFractionDigit, maxFractionDigit), style: 'tableBody', alignment: 'right', color: -managerOneConvNet >= 0 ? 'blue' : 'red', ...noBorder },
                                        { text: numberSeparator(lotusConvNet, minFractionDigit, maxFractionDigit), style: 'tableBody', alignment: 'right', color: lotusConvNet >= 0 ? 'blue' : 'red', ...noBorder }
                                    ]);

                                    // Accumulate totals within the current group
                                    lastTotalProfit             += totalProfit;
                                    lastTotalBrokerage          += totalBrokerage;
                                    lastTotalBillingAmount      += billingAmount;
                                    lastTotalExtraBrokerage     += extraBrokerage;
                                    lastTotalGrossBill          += grossBill;
                                    lastTotalManagerNet         += managerNet;
                                    lastTotalManagerOneConvNet  += managerOneConvNet != '-' ? managerOneConvNet : 0;
                                    lastTotalLotusConvNet       += lotusConvNet != '-' ? lotusConvNet : 0;
                                    lastTotalGrossBillConvNet   += grossBillConvNet != '-' ? grossBillConvNet : 0;

                                    if (managerTwoNet != '-') {
                                        lastTotalManagerTwoNet += managerTwoNet;
                                    }
                                    if (managerThreeNet != '-') {
                                        lastTotalManagerThreeNet += managerThreeNet;
                                    }
                                    if (managerFourNet != '-') {
                                        lastTotalManagerFourNet += managerFourNet;
                                    }
                                    lastTotalLotusNet += lotusNet;
                                });

                                // Add the final total row for the last group
                                if (lastGroup !== null) {
                                    newRows.push([
                                        { text: lastGroup, bold: true, alignment: 'center', fillColor: '#a6a6a6', color: 'black', ...thickBottom },
                                        { text: numberSeparator(lastTotalProfit, minFractionDigit, maxFractionDigit), style: 'tableBody', bold: true, alignment: 'right', ...thickBottom },
                                        { text: '-' + numberSeparator(lastTotalBrokerage, minFractionDigit, maxFractionDigit), style: 'tableBody', bold: true, alignment: 'right', ...thickBottom },
                                        { text: numberSeparator(lastTotalBillingAmount, minFractionDigit, maxFractionDigit), style: 'tableBody', bold: true, alignment: 'right', color: lastTotalBillingAmount >= 0 ? 'blue' : 'red', ...thickBottom },
                                        { text: numberSeparator(lastTotalExtraBrokerage, minFractionDigit, maxFractionDigit), style: 'tableBody', bold: true, alignment: 'right', color: 'red', ...thickBottom },
                                        { text: numberSeparator(lastTotalGrossBill, minFractionDigit, maxFractionDigit), style: 'tableBody', bold: true, alignment: 'right', color: lastTotalGrossBill >= 0 ? 'blue' : 'red', ...thickBottom },
                                        { text: '', style: 'tableBody', alignment: 'center', ...thickBottom },
                                        { text: '', style: 'tableBody', alignment: 'center', ...thickBottom },
                                        { text: numberSeparator(lastTotalGrossBillConvNet, minFractionDigit, maxFractionDigit), style: 'tableBody', bold: true, alignment: 'right', ...thickBottom },
                                        { text: numberSeparator(-lastTotalManagerOneConvNet, minFractionDigit, maxFractionDigit), style: 'tableBody', bold: true, alignment: 'right', color: -lastTotalManagerOneConvNet >= 0 ? 'blue' : 'red', ...thickBottom },
                                        { text: numberSeparator(lastTotalLotusConvNet, minFractionDigit, maxFractionDigit), style: 'tableBody', bold: true, alignment: 'right', ...thickBottom }
                                    ]);
                                }

                                // Assigning the rows to the content body
                                doc.content[0].table.body = newRows;
                            }
                        }
                    ]
                }],
                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();
                    }
                },
                columns: dataColumns,
                rowCallback: function(row, data) {
                    $(row).addClass('text-center');
                },
                "stateLoadParams": function (settings, data) {
                    if (data.select) {
                        data.select.rows = [];
                    }
                },
                order: [
                    [0, "asc"],
                    [1, "asc"]
                ],
            }, );
        }

        $(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" id="managerFilterDiv"><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>`);

            @hasrole(CommonConstants::ADMIN_ROLES['MANAGER_ADMIN'])
                $('#managerFilterDiv').addClass('d-none');
            @endhasrole

            $('.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 = $('#kt_table_pl_summary').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