@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('trialBalanceReport') }}" method="post" id="dateRangeForm">
                    @csrf
                    <input type="hidden" name="start_date" id="start_date">
                    <input type="hidden" name="end_date" id="end_date">
                </form>
                <!--begin::Card body-->
                <div class="card-body py-4">
                    <!--begin::Table-->
                    <div class="table-responsive">
                        <table class="table align-middle table-row-dashed fs-6 gy-5 table-hover table-striped" id="kt_table_trial_balance_report">
                            <!--begin::Table head-->
                            <thead>
                                <!--begin::Table row-->
                                <tr class="text-center fw-bolder fs-7 text-uppercase gs-0">
                                    <th class="min-w-100px">Code</th>
                                    <th class="min-w-100px">Name</th>
                                    <th class="min-w-100px">Credit</th>
                                    <th class="min-w-100px">Conv. Credit</th>
                                    <th class="min-w-100px">Code</th>
                                    <th class="min-w-100px">Name</th>
                                    <th class="min-w-100px">Debit</th>
                                    <th class="min-w-100px">Conv. Debit</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 token             = "{{ csrf_token() }}";
    const table             = $('#kt_table_trial_balance_report');
    var fileName            = "Trial_Balance_Report";
    var title               = fileName + '_' + Date.now();
    var columns             = [0, 1, 2, 4, 5, 6];
    var minFractionDigit    = "{{CommonConstants::PL_SUMMARY['MIN_FRACTION_DIGIT']}}";
    var maxFractionDigit    = "{{CommonConstants::PL_SUMMARY['MAX_FRACTION_DIGIT']}}";
    var url;

    var start_date      = "{{ $start_date }}";
    var end_date        = "{{ $end_date }}";

    var dataColumns = [
        {
            data: 'loginCredit',
            name: 'loginCredit',
            render: function(data, type, full, meta) {
                detailUrl       = "{{ route('trialBalanceDetails') }}";
                var queryParams = '?managerId='+ full.loginCredit +'&start_date='+ start_date +'&end_date='+ end_date;
                detailUrl       += queryParams;
                var loginId     = '<a href="'+detailUrl+'" target="_blank" class="text-dark fw-bolder text-hover-primary fs-6">'+full.loginCredit+'</a>';
                // var loginId     = full.loginCredit;
                return loginId;
            }
        },
        {
            data: 'nameCredit',
            name: 'nameCredit'
        },
        {
            data: 'balanceCredit',
            name: 'balanceCredit',
            render: function(data, type, full, meta) {                    
                var balanceCredit = full.balanceCredit;
                if (balanceCredit != '-') {
                    var creditValue = (full.balanceCredit < 0 ? (full.balanceCredit * -1) : full.balanceCredit);
                    balanceCredit   = numberSeparator(Number(creditValue), minFractionDigit, maxFractionDigit)
                }
                return `<span class="fs-4 mb-0">${balanceCredit}</span>`;
            }
        },
        {
            data: 'convertedPriceCredit',
            name: 'convertedPriceCredit',
            visible: false,
            render: function(data, type, full, meta) {
                var convertedPriceCredit = data;

                if (convertedPriceCredit != '-') {
                    convertedPriceDebit  = (data < 0 ? (data * -1) : data);
                    convertedPriceCredit   = numberSeparator(Number(convertedPriceCredit), minFractionDigit, maxFractionDigit)
                }

                return `<span class="fs-4 mb-0">${convertedPriceCredit}</span>`;
            }
        },
        {
            data: 'loginDebit',
            name: 'loginDebit',
            render: function(data, type, full, meta) {
                detailUrl       = "{{ route('trialBalanceDetails') }}";
                var queryParams = '?managerId='+ full.loginDebit +'&start_date='+ start_date +'&end_date='+ end_date;
                detailUrl       += queryParams;
                var loginId     = '<a href="'+detailUrl+'" target="_blank" class="text-dark fw-bolder text-hover-primary fs-6">'+full.loginDebit+'</a>';
                // var loginId     = full.loginDebit;
                return loginId;
            }
        },
        {
            data: 'nameDebit',
            name: 'nameDebit'
        },
        {
            data: 'balanceDebit',
            name: 'balanceDebit',
            render: function(data, type, full, meta) {                    
                var balanceDebit = full.balanceDebit;
                if (balanceDebit != '-') {
                    var debitValue  = (full.balanceDebit < 0 ? (full.balanceDebit * -1) : full.balanceDebit);
                    balanceDebit    = numberSeparator(Number(debitValue), minFractionDigit, maxFractionDigit)
                }
                return `<span class="fs-4 mb-0">${balanceDebit}</span>`;
            }
        },
        {
            data: 'convertedPriceDebit',
            name: 'convertedPriceDebit',
            visible: false,
            render: function(data, type, full, meta) {
                var convertedPriceDebit = data;

                if (convertedPriceDebit != '-') {
                    convertedPriceDebit  = (data < 0 ? (data * -1) : data);
                    convertedPriceDebit   = numberSeparator(Number(convertedPriceDebit), minFractionDigit, maxFractionDigit)
                }

                return `<span class="fs-4 mb-0">${convertedPriceDebit}</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 diffName = '{{CommonConstants::COMPANY_NAME}}';
        var reloadAjex = $(table).dataTable({
            // export buttons
            dom: "<'card-header align-items-center py-5 gap-2 gap-md-5'<'card-title'<'d-flex position-relative my-1'f>><'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: true,
            "stateSaveParams": function (settings, data) {
                data.search.search = '';
            },
            pageLength: 500,
            "lengthMenu": {!! json_encode(CommonConstants::ALL_PAGE_PER_DATA) !!},
            language: {
                searchPlaceholder: "Search Balance",
                search: ""
            },
            buttons: [{
                extend: "collection",
                className: "exportButton",
                text: "<i class='fa fa-download'></i>",
                    buttons: [
                    {
                        extend: "excelHtml5",
                        text: "Only CMX (Excel)",
                        className: "btn btn-default btn-sm gap-5",
                        title: title,
                        exportOptions: {
                            columns: columnArray
                        },
                        action: function(e, dt, button, config) {
                            var self = this;
                            var oldStart = dt.settings()[0]._iDisplayStart;

                            dt.one('preXhr', function(e, s, data) {
                                data.start  = 0;
                                data.length = -1;
                                data.cmx_filter = "{{CommonConstants::TRIAL_BALANCE_REPORT['CMX_FILTER']['ONLY_CMX']}}";

                                dt.one('preDraw', function(e, settings) {
                                    $.fn.dataTable.ext.buttons.excelHtml5.available(dt, config) ?
                                        $.fn.dataTable.ext.buttons.excelHtml5.action.call(self, e, dt, button, config) :
                                        $.fn.dataTable.ext.buttons.excelFlash.action.call(self, e, dt, button, config);

                                    dt.one('preXhr', function(e, s, data) {
                                        settings._iDisplayStart = oldStart;
                                        data.start = oldStart;
                                    });

                                    setTimeout(dt.ajax.reload, 0);
                                    return false;
                                });
                            });

                            dt.ajax.reload();
                        },
                        customizeData: function(data) {
                            var totalCredit = 0, totalDebit = 0;
                            var parseNumber = function(value) {
                                value = value.replace(/,/g, '');
                                return value !== "-" && !isNaN(value) ? parseFloat(value) : 0;
                            };

                            // Calculate totals
                            data.body.forEach(row => {                                
                                totalCredit += parseNumber(row[2]);
                                totalDebit  += parseNumber(row[5]);
                            });

                            var totalDifference = Math.abs(totalCredit - totalDebit);
                            var diffCredit      = "";
                            var diffCreditText  = "";
                            var diffDebit       = "";
                            var diffDebitText   = "";

                            // Adjust the lower side & store the difference correctly
                            if (totalCredit > totalDebit) {
                                diffDebit       = numberSeparator(totalDifference, minFractionDigit, maxFractionDigit);
                                diffDebitText   = diffName;
                                totalDebit     += totalDifference;
                            } else if (totalDebit > totalCredit) {
                                diffCredit      = numberSeparator(totalDifference, minFractionDigit, maxFractionDigit);
                                diffCreditText  = diffName;
                                totalCredit    += totalDifference;
                            }

                            // Insert difference row
                            var diffRow = [ diffCreditText, "", diffCredit, diffDebitText, "", diffDebit ];
                            data.body.unshift(diffRow);

                            // Insert total row
                            data.body.push([
                                "Total Amount", "",
                                numberSeparator(totalCredit, minFractionDigit, maxFractionDigit),
                                "", "",
                                numberSeparator(totalDebit, minFractionDigit, maxFractionDigit)
                            ]);
                        }
                    },{
                        extend: "excelHtml5",
                        text: "Without CMX (Excel)",
                        className: "btn btn-default btn-sm gap-5",
                        title: title,
                        exportOptions: {
                            columns: columnArray
                        },
                        action: function(e, dt, button, config) {
                            var self = this;
                            var oldStart = dt.settings()[0]._iDisplayStart;

                            dt.one('preXhr', function(e, s, data) {
                                data.start  = 0;
                                data.length = -1;
                                data.cmx_filter = "{{CommonConstants::TRIAL_BALANCE_REPORT['CMX_FILTER']['WITHOUT_CMX']}}";

                                dt.one('preDraw', function(e, settings) {
                                    $.fn.dataTable.ext.buttons.excelHtml5.available(dt, config) ?
                                        $.fn.dataTable.ext.buttons.excelHtml5.action.call(self, e, dt, button, config) :
                                        $.fn.dataTable.ext.buttons.excelFlash.action.call(self, e, dt, button, config);

                                    dt.one('preXhr', function(e, s, data) {
                                        settings._iDisplayStart = oldStart;
                                        data.start = oldStart;
                                    });

                                    setTimeout(dt.ajax.reload, 0);
                                    return false;
                                });
                            });

                            dt.ajax.reload();
                        },
                        customizeData: function(data) {
                            var totalCredit = 0, totalDebit = 0;
                            var parseNumber = function(value) {
                                value = value.replace(/,/g, '');
                                return value !== "-" && !isNaN(value) ? parseFloat(value) : 0;
                            };

                            // Calculate totals
                            data.body.forEach(row => {                                
                                totalCredit += parseNumber(row[2]);
                                totalDebit += parseNumber(row[5]);
                            });
                            
                            var totalDifference = Math.abs(totalCredit - totalDebit);
                            var diffCredit      = "";
                            var diffCreditText  = "";
                            var diffDebit       = "";
                            var diffDebitText   = "";

                            // Adjust the lower side & store the difference correctly
                            if (totalCredit > totalDebit) {
                                diffDebit       = numberSeparator(totalDifference, minFractionDigit, maxFractionDigit);
                                diffDebitText   = diffName;
                                totalDebit      += totalDifference; // Add difference to Debit side
                            } else if (totalDebit > totalCredit) {
                                diffCredit      = numberSeparator(totalDifference, minFractionDigit, maxFractionDigit);
                                diffCreditText  = diffName;
                                totalCredit    += totalDifference;
                            }

                            // Insert difference row
                            var diffRow = [ diffCreditText, "", diffCredit, diffDebitText, "", diffDebit ];
                            data.body.unshift(diffRow);

                            // Insert total row
                            data.body.push([
                                "Total Amount", "",
                                numberSeparator(totalCredit, minFractionDigit, maxFractionDigit),
                                "", "",
                                numberSeparator(totalDebit, minFractionDigit, maxFractionDigit)
                            ]);
                        }
                    },{
                        extend: "excelHtml5",
                        text: "All Segment (Excel)",
                        className: "btn btn-default btn-sm gap-5",
                        title: title,
                        exportOptions: {
                            columns: columnArray
                        },
                        action: function(e, dt, button, config) {
                            var self = this;
                            var oldStart = dt.settings()[0]._iDisplayStart;

                            dt.one('preXhr', function(e, s, data) {
                                data.start  = 0;
                                data.length = -1;
                                data.cmx_filter = "{{CommonConstants::TRIAL_BALANCE_REPORT['CMX_FILTER']['ALL_SEGMENT']}}";

                                dt.one('preDraw', function(e, settings) {
                                    $.fn.dataTable.ext.buttons.excelHtml5.available(dt, config) ?
                                        $.fn.dataTable.ext.buttons.excelHtml5.action.call(self, e, dt, button, config) :
                                        $.fn.dataTable.ext.buttons.excelFlash.action.call(self, e, dt, button, config);

                                    // restore table to previous state
                                    dt.one('preXhr', function(e, s, data) {
                                        settings._iDisplayStart = oldStart;
                                        data.start = oldStart;
                                    });

                                    setTimeout(dt.ajax.reload, 0);
                                    return false;
                                });
                            });

                            dt.ajax.reload();
                        },
                        customizeData: function(data) {
                            var totalCredit = 0, totalDebit = 0;
                            var parseNumber = function(value) {
                                value = value.replace(/,/g, '');
                                return value !== "-" && !isNaN(value) ? parseFloat(value) : 0;
                            };

                            // Calculate totals
                            data.body.forEach(row => {                                
                                totalCredit += parseNumber(row[2]);
                                totalDebit  += parseNumber(row[5]);
                            });

                            var totalDifference = Math.abs(totalCredit - totalDebit);
                            var diffCredit      = "";
                            var diffCreditText  = "";
                            var diffDebit       = "";
                            var diffDebitText   = "";

                            if (totalCredit > totalDebit) {
                                diffDebit       = numberSeparator(totalDifference, minFractionDigit, maxFractionDigit);
                                diffDebitText   = diffName;
                                totalDebit     += totalDifference;
                            } else if (totalDebit > totalCredit) {
                                diffCredit      = numberSeparator(totalDifference, minFractionDigit, maxFractionDigit);
                                diffCreditText  = diffName;
                                totalCredit    += totalDifference;
                            }

                            // Insert difference row
                            var diffRow = [ diffCreditText, "", diffCredit, diffDebitText, "", diffDebit ];
                            data.body.unshift(diffRow);

                            // Insert total row
                            data.body.push([
                                "Total Amount", "",
                                numberSeparator(totalCredit, minFractionDigit, maxFractionDigit),
                                "", "",
                                numberSeparator(totalDebit, minFractionDigit, maxFractionDigit)
                            ]);
                        }
                    },{
                        extend: "csvHtml5",
                        text: "CSV",
                        className: "btn btn-default btn-sm gap-5 d-none",
                        title: title,
                        exportOptions: {
                            columns: columnArray
                        }
                    },{
                        extend: "pdfHtml5",
                        text: 'Only CMX (Pdf)',
                        className: "btn btn-default btn-sm",
                        title: title,
                        exportOptions: {
                            columns: [0, 1, 2, 4, 5, 6]
                        },
                        action: function(e, dt, button, config) {
                            var self = this;
                            var oldStart = dt.settings()[0]._iDisplayStart;

                            dt.one('preXhr', function(e, s, data) {
                                data.start = 0;
                                data.length = -1;
                                data.cmx_filter = "{{CommonConstants::TRIAL_BALANCE_REPORT['CMX_FILTER']['ONLY_CMX']}}";

                                dt.one('preDraw', function(e, settings) {
                                    $.fn.dataTable.ext.buttons.pdfHtml5.available(dt, config) ?
                                        $.fn.dataTable.ext.buttons.pdfHtml5.action.call(self, e, dt, button, config) :
                                        $.fn.dataTable.ext.buttons.pdfFlash.action.call(self, e, dt, button, config);

                                    dt.one('preXhr', function(e, s, data) {
                                        settings._iDisplayStart = oldStart;
                                        data.start = oldStart;
                                    });

                                    setTimeout(dt.ajax.reload, 0);
                                    return false;
                                });
                            });

                            dt.ajax.reload();
                        },
                        customize: function(doc) {
                            doc.content.splice(0, 1);

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

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

                            doc['header'] = function() {
                                return {
                                    columns: [
                                        { alignment: 'left', text: "", fontSize: 14, margin: [10, 10, 10, 10] },
                                        { alignment: 'center', text: "{{CommonConstants::TRIAL_BALANCE_REPORT['PDF_HEADING']}}", fontSize: 12, bold: true, 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
                                };
                            };

                            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
                                };
                            };

                            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; }
                            };

                            doc.content[0].table.widths = ['12.5%', '25%', '12.5%', '12.5%', '25%', '12.5%'];
                            doc.content[0].layout = objLayout;

                            var parseNumber = function(value) {
                                if (typeof value === 'string') {
                                    value = value.replace(/,/g, '');
                                }
                                return value !== "-" && !isNaN(value) ? parseFloat(value) : 0;
                            };

                            let totalCredit = 0;
                            let totalDebit  = 0;

                            doc.content[0].table.body.forEach(row => {
                                if (row.length < 6) return;

                                row[2].alignment = 'right';
                                row[5].alignment = 'right';

                                const credit    = parseNumber(row[2].text || row[2]);
                                const debit     = parseNumber(row[5].text || row[5]); 

                                totalCredit += credit;
                                totalDebit  += debit;
                            });

                            var totalDifference = Math.abs(totalCredit - totalDebit);
                            var diffCredit      = "";
                            var diffCreditText  = "";
                            var diffDebit       = "";
                            var diffDebitText   = "";

                            // Adjust the lower side & store the difference correctly
                            if (totalCredit > totalDebit) {
                                diffDebit       = totalDifference.toFixed(2);
                                diffDebitText   = diffName;
                                totalDebit      += totalDifference; // Add difference to Debit side
                            } else if (totalDebit > totalCredit) {
                                diffCredit      = totalDifference.toFixed(2);
                                diffCreditText  = diffName;
                                totalCredit     += totalDifference; // Add difference to Credit side
                            }

                            // Insert Difference Amount as the **first row after the headers**
                            doc.content[0].table.body.splice(1, 0, [
                                { text: diffCreditText, alignment: 'center', colSpan: 2, bold: true, fontSize: 10 },
                                {},
                                { text: diffCredit, alignment: 'right', bold: true, fontSize: 10 }, 
                                { text: diffDebitText, colSpan: 2, bold: true, fontSize: 10 },
                                {},
                                { text: diffDebit, alignment: 'right', bold: true, fontSize: 10 }
                            ]);

                            // Add the Total Amount row **at the end** ensuring both sides are equal
                            doc.content[0].table.body.push([
                                { text: 'Total Amount', alignment: 'center', colSpan: 2, bold: true, fontSize: 10 },
                                {},
                                { text: totalCredit.toFixed(2), alignment: 'right', bold: true, fontSize: 10 }, 
                                { text: '', colSpan: 2 },
                                {},
                                { text: totalDebit.toFixed(2), alignment: 'right', bold: true, fontSize: 10 }
                            ]);
                        }
                    },{
                        extend: "pdfHtml5",
                        text: 'Without CMX (Pdf)',
                        className: "btn btn-default btn-sm",
                        title: title,
                        exportOptions: {
                            columns: [0, 1, 2, 4, 5, 6]
                        },
                        action: function(e, dt, button, config) {
                            var self = this;
                            var oldStart = dt.settings()[0]._iDisplayStart;

                            dt.one('preXhr', function(e, s, data) {
                                data.start = 0;
                                data.length = -1;
                                data.cmx_filter = "{{CommonConstants::TRIAL_BALANCE_REPORT['CMX_FILTER']['WITHOUT_CMX']}}";

                                dt.one('preDraw', function(e, settings) {
                                    $.fn.dataTable.ext.buttons.pdfHtml5.available(dt, config) ?
                                        $.fn.dataTable.ext.buttons.pdfHtml5.action.call(self, e, dt, button, config) :
                                        $.fn.dataTable.ext.buttons.pdfFlash.action.call(self, e, dt, button, config);

                                    dt.one('preXhr', function(e, s, data) {
                                        settings._iDisplayStart = oldStart;
                                        data.start = oldStart;
                                    });

                                    setTimeout(dt.ajax.reload, 0);
                                    return false;
                                });
                            });

                            dt.ajax.reload();
                        },
                        customize: function(doc) {
                            doc.content.splice(0, 1);

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

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

                            doc['header'] = function() {
                                return {
                                    columns: [
                                        { alignment: 'left', text: "", fontSize: 14, margin: [10, 10, 10, 10] },
                                        { alignment: 'center', text: "{{CommonConstants::TRIAL_BALANCE_REPORT['PDF_HEADING']}}", fontSize: 12, bold: true, 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
                                };
                            };

                            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
                                };
                            };

                            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; }
                            };

                            doc.content[0].table.widths = ['12.5%', '25%', '12.5%', '12.5%', '25%', '12.5%'];
                            doc.content[0].layout = objLayout;

                            var parseNumber = function(value) {
                                if (typeof value === 'string') {
                                    value = value.replace(/,/g, '');
                                }
                                return value !== "-" && !isNaN(value) ? parseFloat(value) : 0;
                            };

                            let totalCredit = 0;
                            let totalDebit  = 0;

                            doc.content[0].table.body.forEach(row => {
                                if (row.length < 6) return;

                                row[2].alignment = 'right';
                                row[5].alignment = 'right';

                                const credit    = parseNumber(row[2].text || row[2]);
                                const debit     = parseNumber(row[5].text || row[5]); 

                                totalCredit += credit;
                                totalDebit  += debit;
                            });

                            var totalDifference = Math.abs(totalCredit - totalDebit);
                            var diffCredit      = "";
                            var diffCreditText  = "";
                            var diffDebit       = "";
                            var diffDebitText   = "";

                            // Adjust the lower side & store the difference correctly
                            if (totalCredit > totalDebit) {
                                diffDebit       = totalDifference.toFixed(2);
                                diffDebitText   = diffName;
                                totalDebit      += totalDifference; // Add difference to Debit side
                            } else if (totalDebit > totalCredit) {
                                diffCredit      = totalDifference.toFixed(2);
                                diffCreditText  = diffName;
                                totalCredit     += totalDifference; // Add difference to Credit side
                            }

                            // Insert Difference Amount as the **first row after the headers**
                            doc.content[0].table.body.splice(1, 0, [
                                { text: diffCreditText, alignment: 'center', colSpan: 2, bold: true, fontSize: 10 },
                                {},
                                { text: diffCredit, alignment: 'right', bold: true, fontSize: 10 }, 
                                { text: diffDebitText, colSpan: 2, bold: true, fontSize: 10 },
                                {},
                                { text: diffDebit, alignment: 'right', bold: true, fontSize: 10 }
                            ]);

                            // Add the Total Amount row **at the end** ensuring both sides are equal
                            doc.content[0].table.body.push([
                                { text: 'Total Amount', alignment: 'center', colSpan: 2, bold: true, fontSize: 10 },
                                {},
                                { text: totalCredit.toFixed(2), alignment: 'right', bold: true, fontSize: 10 }, 
                                { text: '', colSpan: 2 },
                                {},
                                { text: totalDebit.toFixed(2), alignment: 'right', bold: true, fontSize: 10 }
                            ]);
                        }
                    },{
                        extend: "pdfHtml5",
                        text: 'All Segment (Pdf)',
                        className: "btn btn-default btn-sm",
                        title: title,
                        exportOptions: {
                            columns: [0, 1, 2, 4, 5, 6]
                        },
                        action: function(e, dt, button, config) {
                            var self = this;
                            var oldStart = dt.settings()[0]._iDisplayStart;

                            dt.one('preXhr', function(e, s, data) {
                                data.start = 0;
                                data.length = -1;
                                data.cmx_filter = "{{CommonConstants::TRIAL_BALANCE_REPORT['CMX_FILTER']['ALL_SEGMENT']}}";

                                dt.one('preDraw', function(e, settings) {
                                    $.fn.dataTable.ext.buttons.pdfHtml5.available(dt, config) ?
                                        $.fn.dataTable.ext.buttons.pdfHtml5.action.call(self, e, dt, button, config) :
                                        $.fn.dataTable.ext.buttons.pdfFlash.action.call(self, e, dt, button, config);

                                    dt.one('preXhr', function(e, s, data) {
                                        settings._iDisplayStart = oldStart;
                                        data.start = oldStart;
                                    });

                                    setTimeout(dt.ajax.reload, 0);
                                    return false;
                                });
                            });

                            dt.ajax.reload();
                        },
                        customize: function(doc) {
                            doc.content.splice(0, 1);

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

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

                            doc['header'] = function() {
                                return {
                                    columns: [
                                        { alignment: 'left', text: "", fontSize: 14, margin: [10, 10, 10, 10] },
                                        { alignment: 'center', text: "{{CommonConstants::TRIAL_BALANCE_REPORT['PDF_HEADING']}}", fontSize: 12, bold: true, 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
                                };
                            };

                            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
                                };
                            };

                            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; }
                            };

                            doc.content[0].table.widths = ['12.5%', '25%', '12.5%', '12.5%', '25%', '12.5%'];
                            doc.content[0].layout = objLayout;

                            var parseNumber = function(value) {
                                if (typeof value === 'string') {
                                    value = value.replace(/,/g, '');
                                }
                                return value !== "-" && !isNaN(value) ? parseFloat(value) : 0;
                            };

                            let totalCredit = 0;
                            let totalDebit  = 0;

                            doc.content[0].table.body.forEach(row => {
                                if (row.length < 6) return;

                                row[2].alignment = 'right';
                                row[5].alignment = 'right';

                                const credit    = parseNumber(row[2].text || row[2]);
                                const debit     = parseNumber(row[5].text || row[5]); 

                                totalCredit += credit;
                                totalDebit  += debit;
                            });

                            var totalDifference = Math.abs(totalCredit - totalDebit);
                            var diffCredit      = "";
                            var diffCreditText  = "";
                            var diffDebit       = "";
                            var diffDebitText   = "";

                            // Adjust the lower side & store the difference correctly
                            if (totalCredit > totalDebit) {
                                diffDebit       = totalDifference.toFixed(2);
                                diffDebitText   = diffName;
                                totalDebit      += totalDifference; // Add difference to Debit side
                            } else if (totalDebit > totalCredit) {
                                diffCredit      = totalDifference.toFixed(2);
                                diffCreditText  = diffName;
                                totalCredit     += totalDifference; // Add difference to Credit side
                            }

                            // Insert Difference Amount as the **first row after the headers**
                            doc.content[0].table.body.splice(1, 0, [
                                { text: diffCreditText, alignment: 'center', colSpan: 2, bold: true, fontSize: 10 },
                                {},
                                { text: diffCredit, alignment: 'right', bold: true, fontSize: 10 }, 
                                { text: diffDebitText, colSpan: 2, bold: true, fontSize: 10 },
                                {},
                                { text: diffDebit, alignment: 'right', bold: true, fontSize: 10 }
                            ]);

                            // Add the Total Amount row **at the end** ensuring both sides are equal
                            doc.content[0].table.body.push([
                                { text: 'Total Amount', alignment: 'center', colSpan: 2, bold: true, fontSize: 10 },
                                {},
                                { text: totalCredit.toFixed(2), alignment: 'right', bold: true, fontSize: 10 }, 
                                { text: '', colSpan: 2 },
                                {},
                                { text: totalDebit.toFixed(2), alignment: 'right', bold: true, fontSize: 10 }
                            ]);
                        }
                    },{
                        extend: "pdfHtml5",
                        text: 'CMX PDF ₹',
                        className: "btn btn-default btn-sm",
                        title: title + ' - CMX ₹',
                        exportOptions: {
                            columns: [0, 1, 3, 4, 5, 7]
                        },
                        customize: function(doc) {
                            doc.content.splice(0, 1);

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

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

                            doc['header'] = function() {
                                return {
                                    columns: [
                                        { alignment: 'left', text: "", fontSize: 14, margin: [10, 10, 10, 10] },
                                        { alignment: 'center', text: "{{CommonConstants::TRIAL_BALANCE_REPORT['CMX_PDF_HEADING']}}", fontSize: 12, bold: true, 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
                                };
                            };

                            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
                                };
                            };

                            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; }
                            };

                            doc.content[0].table.widths = ['12.5%', '25%', '12.5%', '12.5%', '25%', '12.5%'];
                            doc.content[0].layout = objLayout;

                            var parseNumber = function(value) {
                                if (typeof value === 'string') {
                                    value = value.replace(/,/g, '');
                                }
                                return value !== "-" && !isNaN(value) ? parseFloat(value) : 0;
                            };

                            var diffName = '{{CommonConstants::COMPANY_NAME}}';

                            let body = doc.content[0].table.body;
                            let header = body[0];
                            let dataRows = body.slice(1);

                            let creditRows = [];
                            let debitRows = [];
                            let totalCredit = 0;
                            let totalDebit = 0;

                            dataRows.forEach(row => {
                                const credit = parseNumber(row[2]?.text || row[2]);
                                const debit = parseNumber(row[5]?.text || row[5]);

                                if (credit !== 0) {
                                    creditRows.push([
                                        { text: row[0]?.text || '-' },
                                        { text: row[1]?.text || '-' },
                                        { text: credit.toFixed(2), alignment: 'right' }
                                    ]);
                                }

                                if (debit !== 0) {
                                    debitRows.push([
                                        { text: row[3]?.text || '-' },
                                        { text: row[4]?.text || '-' },
                                        { text: debit.toFixed(2), alignment: 'right' }
                                    ]);
                                }

                                totalCredit += credit;
                                totalDebit += debit;
                            });

                            const maxLength = Math.max(creditRows.length, debitRows.length);

                            while (creditRows.length < maxLength) {
                                creditRows.push([
                                    { text: '-' },
                                    { text: '-' },
                                    { text: '-', alignment: 'right' }
                                ]);
                            }

                            while (debitRows.length < maxLength) {
                                debitRows.push([
                                    { text: '-' },
                                    { text: '-' },
                                    { text: '-', alignment: 'right' }
                                ]);
                            }

                            let alignedRows = [];

                            for (let i = 0; i < maxLength; i++) {
                                const fillColor = i % 2 === 0 ? '#f9f9f9' : '#F0F0F0';

                                alignedRows.push([
                                    { ...creditRows[i][0], fillColor },
                                    { ...creditRows[i][1], fillColor },
                                    { ...creditRows[i][2], fillColor },

                                    { ...debitRows[i][0], fillColor },
                                    { ...debitRows[i][1], fillColor },
                                    { ...debitRows[i][2], fillColor }
                                ]);
                            }

                            const totalDifference = Math.abs(totalCredit - totalDebit);
                            let diffCredit = '';
                            let diffCreditText = '';
                            let diffDebit = '';
                            let diffDebitText = '';

                            if (totalCredit > totalDebit) {
                                diffDebit = totalDifference.toFixed(2);
                                diffDebitText = diffName;
                                totalDebit += totalDifference;
                            } else if (totalDebit > totalCredit) {
                                diffCredit = totalDifference.toFixed(2);
                                diffCreditText = diffName;
                                totalCredit += totalDifference;
                            }

                            alignedRows.unshift([
                                { text: diffCreditText, alignment: 'center', colSpan: 2, bold: true, fontSize: 10 }, {},
                                { text: numberSeparator(diffCredit, minFractionDigit, maxFractionDigit), alignment: 'right', bold: true, fontSize: 10 },

                                { text: diffDebitText, alignment: 'center', colSpan: 2, bold: true, fontSize: 10 }, {},
                                { text: numberSeparator(diffDebit, minFractionDigit, maxFractionDigit), alignment: 'right', bold: true, fontSize: 10 }
                            ]);

                            alignedRows.push([
                                { text: 'Total Amount', alignment: 'center', colSpan: 2, bold: true, fontSize: 10 }, {},
                                { text: numberSeparator(totalCredit, minFractionDigit, maxFractionDigit), alignment: 'right', bold: true, fontSize: 10 },

                                { text: '', colSpan: 2 }, {},
                                { text: numberSeparator(totalDebit, minFractionDigit, maxFractionDigit), alignment: 'right', bold: true, fontSize: 10 }
                            ]);

                            doc.content[0].table.body = [header, ...alignedRows];
                        }
                    }
                ]
            }],
            ajax: {
                url: url,
                method: "GET",
                data: function(d) {
                    d.start_date    = "{{ $start_date }}",
                    d.end_date      = "{{ $end_date }}",
                    d.cmx_filter    = $('#cmx_filter').val()
                }
            },
            columns: dataColumns,
            rowCallback: function(row, data) {
                $(row).addClass('text-center');
            },
            "stateLoadParams": function (settings, data) {
                if (data.select) {
                    data.select.rows = [];
                }
            },
            order: [],
            drawCallback: function(settings) {
                var api = this.api();

                if (api.data().count() === 0) {
                    return;
                }

                var pageInfo    = api.page.info();
                var currentPage = pageInfo.page;
                var lastPage    = pageInfo.pages - 1;

                var parseNumber = function(value) {
                    let num = (value !== "-" && value !== null && value !== undefined) ? parseFloat(value) : 0;
                    return Math.abs(num);
                };

                var totalCredit = api
                    .column(2)
                    .data()
                    .reduce((a, b) => a + parseNumber(b), 0);

                var totalDebit = api
                    .column(6)
                    .data()
                    .reduce((a, b) => a + parseNumber(b), 0);

                var diffAmount = Math.abs(totalCredit - totalDebit);

                // Ensure both totals are equal by adding the difference to the smaller side
                var adjustedCredit  = totalCredit;
                var adjustedDebit   = totalDebit;

                if (totalCredit > totalDebit) {
                    adjustedDebit += diffAmount;
                } else if (totalDebit > totalCredit) {
                    adjustedCredit += diffAmount;
                }

                // Remove previously added rows
                $(table).find('tbody .total-row').remove();

                // Show Difference Row at the First Row (First Page)
                if (currentPage === 0) {
                    $(table).find('tbody').prepend(`
                        <tr class="bg-light fw-bold total-row text-center">
                            <td colspan="2" class="fs-3 text-dark text-center fw-boldest">${(totalDebit > totalCredit) ? diffName : '-'}</td>
                            <td class="fs-3 text-dark text-center fw-boldest">${(totalDebit > totalCredit) ? numberSeparator(diffAmount, minFractionDigit, maxFractionDigit) : '-'}</td>
                            <td colspan="2" class="fs-3 text-dark text-center fw-boldest">${(totalCredit > totalDebit) ? diffName : '-'}</td>
                            <td class="fs-3 text-dark text-center fw-boldest">${(totalCredit > totalDebit) ? numberSeparator(diffAmount, minFractionDigit, maxFractionDigit) : '-'}</td>
                        </tr>
                    `);
                }

                // Show Total Amount Row at the Last Page
                if (currentPage === lastPage) {
                    $(table).find('tbody').append(`
                        <tr class="bg-light fw-bold total-row text-center">
                            <td colspan="2" class="text-center text-dark fs-3 fw-boldest">Total</td>
                            <td class="fs-3 text-dark text-center fw-boldest">${numberSeparator(adjustedCredit, minFractionDigit, maxFractionDigit)}</td>
                            <td colspan="2"></td>
                            <td class="fs-3 text-dark text-center fw-boldest">${numberSeparator(adjustedDebit, minFractionDigit, maxFractionDigit)}</td>
                        </tr>
                    `);
                }
            }
        },);
    }

    $(document).ready(function() {          
        $('.card-toolbar').append(`<div class="d-flex align-items-center gap-2 gap-lg-3">
                    <!--begin::Filter menu-->
                    <div class="m-0">
                        <button class="btn btn-sm btn-flex btn-light btn-active-primary fw-bolder" data-kt-menu-trigger="click" data-kt-menu-placement="bottom-end">
                        <span class="svg-icon svg-icon-5 svg-icon-gray-500 me-1">
                            <i class="fas fa-filter"></i>
                        </span>Filter</button>
                        <div class="menu menu-sub menu-sub-dropdown w-250px w-md-300px" data-kt-menu="true" id="kt_menu_filter">
                            <div class="px-7 py-5">
                                <div class="fs-5 text-dark fw-bolder">Filter</div>
                            </div>
                            <div class="separator border-gray-200"></div>
                            <div class="px-7 py-5">
                                <div class="mb-10">
                                    <label class="form-label fw-bold">Segment:</label>
                                    <div>
                                        <select class="form-select form-select-solid" data-kt-select2="true" data-placeholder="Select Filter" data-dropdown-parent="#kt_menu_filter" data-allow-clear="true" id="cmx_filter">
                                            <option></option>
                                           <option value="{{ CommonConstants::TRIAL_BALANCE_REPORT['CMX_FILTER']['ONLY_CMX'] }}">{{ CommonConstants::TRIAL_BALANCE_REPORT['CMX_FILTER']['ONLY_CMX'] }}</option>
                                            <option value="{{ CommonConstants::TRIAL_BALANCE_REPORT['CMX_FILTER']['WITHOUT_CMX'] }}">{{ CommonConstants::TRIAL_BALANCE_REPORT['CMX_FILTER']['WITHOUT_CMX'] }}</option>
                                            <option value="{{ CommonConstants::TRIAL_BALANCE_REPORT['CMX_FILTER']['ALL_SEGMENT'] }}" selected>{{ CommonConstants::TRIAL_BALANCE_REPORT['CMX_FILTER']['ALL_SEGMENT'] }}</option>
                                        </select>
                                    </div>
                                </div>
                                <div class="d-flex justify-content-end">
                                    <button type="reset" class="btn btn-sm btn-light btn-active-light-primary me-2" data-kt-menu-dismiss="true" id="reset_filter">Reset</button>
                                    <button type="submit" class="btn btn-sm btn-primary" data-kt-menu-dismiss="true" id="apply_filter">Apply</button>
                                </div>
                            </div>
                        </div>
                    </div>
                    <!--end::Filter menu-->
                </div>
        <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>`);

        KTMenu.createInstances(); // Initialize dropdown
        $('#cmx_filter').select2(); // Initialize Select2 dropdown

        // 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
        }

        $('.card-toolbar').prepend(`
            <button class="btn btn-secondary" id="updateBalance">
                <span class="fas fa-sync-alt me-2" id="updateBalanceLoader"></span><span>Update</span>
            </button>
        `);

        $("#updateBalance").click(function(){
            var updateButton = $(this);

            $('#updateBalanceLoader').addClass('loader');
            updateButton.prop('disabled', true);

            $.ajax({
                url: "{{ route('updateTrialBalance') }}",
                method: "POST",
                data: {
                    _token: token
                },
                success: function(response){
                    $('#updateBalanceLoader').removeClass('loader');
                    updateButton.prop('disabled', false);
                    location.reload();
                },
                error: function(xhr, status, error) {
                    $('#updateBalanceLoader').removeClass('loader');
                    updateButton.prop('disabled', false);
                    console.error(xhr.responseText);
                }
            });
        });

        // Filter apply
        $('#apply_filter').on('click', function () {
            $('#kt_table_trial_balance_report').DataTable().ajax.reload();
        });

        $('#reset_filter').on('click', function () {
            $('#cmx_filter').val("{{ CommonConstants::TRIAL_BALANCE_REPORT['CMX_FILTER']['ALL_SEGMENT'] }}").trigger('change');
            $('#kt_table_trial_balance_report').DataTable().ajax.reload();
        });
    });
</script>
@endsection