@{
    ViewData["Title"] = "Journal";
}

<div class="d-flex align-items-center mb-3">
    <div>
        <ul class="breadcrumb">
            <li class="breadcrumb-item"><a href="/">Home</a></li>
            <li class="breadcrumb-item active">Journal</li>
        </ul>
        <h1 class="page-header mb-0">Journal Entries</h1>
    </div>
</div>

<!-- BEGIN container -->
<div class="container">
    <div class="row justify-content-center" id="container">
        <div class="container entry-container">
        <!-- START Table -->
            <table class="table table-hover text-nowrap">
                <thead>
                    <tr>
                        <th class="border-top-0 pt-0 pb-2">Date</th>
                        <th class="border-top-0 pt-0 pb-2">Account code</th>
                        <th class="border-top-0 pt-0 pb-2">Description</th>
                        <th class="border-top-0 pt-0 pb-2">Division</th>
                        <th class="border-top-0 pt-0 pb-2">VAT</th>
                        <th class="border-top-0 pt-0 pb-2">Debit</th>
                        <th class="border-top-0 pt-0 pb-2">Credit</th>
                        <th class="border-top-0 pt-0 pb-2">User</th>
                    </tr>
                </thead>
                <tbody id="tableBody">
                    <tr class="tableBodyContainer">
                        <!-- Date -->
                        <td><input type="date" class="form-control dateInput" name="Date" id="dateInput" /></td>
                        <!-- Account -->
                        <td>
                            <input type="text" class="form-control accountInput" placeholder="Enter an account" name="Account" id="accountInput" autocomplete="off" />
                            <ul class="list-group position-absolute w-100 mt-1" id="accountSuggestions" style="z-index: 1000; display: none;"></ul>
                        </td>
                        <!-- Description -->
                        <td><textarea class="form-control descriptionInput" placeholder="Enter a description" id="descriptionInput" name="Description" rows="1"></textarea></td>
                           <!-- Division -->
                        <td><textarea class="form-control divisionInput" placeholder="Enter a description" id="divisionInput" name="Division" rows="1"></textarea></td>                    
                       <!-- VAT -->
                        <td><textarea class="form-control vatInput" placeholder="Enter a description" id="VATInput" name="VAT" rows="1"></textarea></td>
			<!-- Amount -->
                            <!-- Debit -->
                            <td><input type="number" class="form-control debitInput" placeholder="0.00" name="Debit" /></td>
                            <!-- Credit -->
                            <td><input type="number" class="form-control creditInput" placeholder="0.00" name="Credit" /></td>
                        <!-- User -->
                        <td><input type="text" class="form-control userInput" name="User" id="userInput" placeholder="Enter a user" /></td>


                    </tr>
                </tbody>
            </table>
            <!-- END Table -->
        </div>
    </div>
    <button class="btn btn-light ms-auto d-block mt-3 add-btn">
        <i class="bi bi-plus text-light-emphasis">Add Another Entry</i>
    </button>

    <button class="btn btn-light ms-auto d-block mt-3" id="submitBtn">
        <i class="text-light-emphasis">Post Entry</i>
    </button>
    <div id="errorContainer" class="text-danger mt-2"></div>
    <div id="recent-entry" class=" card mb-5 mt-3">
        <div class="container mt-3" id="resultContainer">
            <!-- Data will be shown here after form submission -->
        </div>
    </div>
</div>
<!-- END Container -->

@section scripts
{
<script>
    const accounts = [
        "01000 - Fixed Asset - Freehold Property",
        "01001 - Fixed Asset - Freehold Property Depreciation",
        "01002 - Fixed Asset - Leasehold Property Depreciation",
        "01003 - Fixed Asset - Leasehold Property",
        "01004 - Fixed Asset - Plant and Machinery",
        "01005 - Fixed Asset - Plant and Machinery Depreciation",
        "01006 - Fixed Asset - Furniture and Fixtures",
        "01007 - Fixed Asset - Furniture/Fixture Depreciation",
        "01008 - Fixed Asset - Computer equipment",
        "01009 - Fixed Asset - Computer equipment Depreciation",
        "01010 - Fixed Asset - Office Equipment",
        "01011 - Fixed Asset - Office Equipment Depreciation",
        "01012 - Fixed Asset - Tools",
        "01013 - Fixed Asset - Tools Depreciation",
        "01014 - Fixed Asset - Motor Vehicles",
        "01015 - Fixed Asset - Motor Vehicles Depreciation",
        "02000 - Intangible Assets - Goodwill",
        "02001 - Intangible Assets -Goodwill Amortisation",
        "02002 - Intangible Assets - Patents and Licences",
        "02003 - Intangible Assets - Patents and Licences Amortisation",
        "02004 - Intangible Assets - Trademarks",
        "02005 - Intangible Assets - Trademarks Amortisation",
        "02006 - Intangible Assets - Software and IP",
        "02007 - Intangible Assets - Software and IP Amortisation",
        "02008 - Intangible Assets - Brand and Customer relations",
        "02009 - Intangible Assets - Brand and Customer relations Amortisation",
        "02900 - Other Assets - Research and Development",
        "02901 - Other Assets - Preliminary Expenses",
        "03000 - Quoted - Investment - 1",
        "03001 - Quoted - Investment - 2",
        "03002 - Quoted - Investment - 3",
        "03003 - Quoted - Investment - 4",
        "03004 - Quoted - Investment - 5",
        "03005 - Quoted - Investment - 6",
        "03006 - Quoted - Investment - 7",
        "04000 - Unquoted - Investment - 1",
        "04002 - Unquoted - Investment - 2",
        "04003 - Unquoted - Investment - 3",
        "04004 - Unquoted - Investment - 4",
        "05000 - Stock - 1",
        "05001 - Stock - 2",
        "05002 - Stock - 3",
        "05003 - Stock - 4",
        "05004 - Stock - 5",
        "05500 - Trade Receivables",
        "05501 - Provisions for doubtful debts",
        "05502 - Other debtors",
        "05503 - Sundry debtors",
        "05504 - Advances and deposits",
        "05505 - Dividend receivables",
        "05506 - Outstanding share capital",
        "05507 - Deposits",
        "05508 - Deferred expenses",
        "05509 - Prepayments",
        "06000 - Bank GBP",
        "06001 - Bank EUR",
        "06002 - Bank USD",
        "06003 - Bank CHF",
        "06004 - Bank NOK",
        "06020 - Bank Reserves account",
        "06040 - Money Market deposit account",
        "06200 - Petty Cash",
        "06300 - Cripto account",
        "06400 - Credit card",
        "06500 - Bank Loan",
        "06600 - Bank Mortgage",
        "07000 - Employee current account",
        "07001 - Directors loan account - 1",
        "07002 - Directors loan account - 2",
        "07003 - Directors loan account - 3",
        "07004 - Directors loan account - 4",
        "07005 - Directors loan account - 5",
        "07200 - Members current account - 1",
        "07201 - Members current account - 2",
        "07203 - Members current account - 3",
        "07204 - Members current account - 4",
        "07205 - Members current account - 5",
        "07500 - Inter-company 1",
        "07501 - Inter-company 2",
        "07502 - Inter-company 3",
        "07503 - Inter-company 4",
        "07504 - Inter-company 5",
        "08000 - Trade Payables",
        "08001 - Sundry Creditors",
        "08100 - Other Creditors",
        "08200 - Accruals",
        "08300 - Hire Purchase",
        "08500 - P.A.Y.E.",
        "08501 - National Insurance",
        "08502 - Net Wages",
        "08503 - Pension Fund",
        "09000 - Debentures",
        "10000 - Vat on Income / Revenue - Accrual basis",
        "10001 - Vat on purchases / Expenses - Accrual basis",
        "10002 - Vat on Income / Revenue - Cash basis",
        "10003 - Vat on purchases / Expenses - Cash basis",
        "10010 - Vat liability",
        "10011 - Vat account",
        "11000 - Ordinary Shares",
        "11001 - Preference Shares",
        "11200 - Members capital",
        "11300 - Reserves",
        "11301 - Undistributed Reserves",
        "11302 - Profit and Loss Account",
        "11500 - Drawings",
        "12000 - Sales North",
        "12001 - Sales South",
        "12002 - Sales East",
        "12003 - Sales West",
        "12004 - Sales Scotland",
        "12005 - Sales Wales",
        "12006 - Sales Europe",
        "12007 - Sales International",
        "12100 - Discounts Allowed",
        "12200 - Sales of Assets",
        "12300 - Miscellaneous Income",
        "12400 - Royalties Received",
        "12500 - Commissions Received",
        "12800 - Insurance Claims",
        "12900 - Bank Interest Received",
        "13000 - Materials Purchased",
        "13001 - Miscellaneous Purchases",
        "13100 - Packaging",
        "13101 - Carriage",
        "13200 - Import Duty",
        "13300 - Productive Labour",
        "13301 - Cost of Sales Labour",
        "13302 - Sub-Contractors",
        "13400 - Discounts Taken",
        "13900 - Opening Stock",
        "13950 - Closing Stock",
        "14000 - Sales Commissions",
        "14100 - Sales Promotions",
        "14200 - Advertising",
        "14300 - Gifts and Samples",
        "14400 - P.R. (Literature & Brochures)",
        "15000 - Gross Wages",
        "15001 - Directors Salaries",
        "15002 - Directors Remuneration",
        "15003 - Staff Salaries",
        "15004 - Wages - Regular",
        "15005 - Wages - Casual",
        "15006 - Employers N.I.",
        "15007 - Employers Pensions",
        "15008 - Adjustments",
        "15009 - SSP Reclaimed",
        "15010 - SMP Reclaimed",  
        "15011 - Other Statutory Payments",  
        "15012 - Staff Benefits",  
        "15013 - Staff Recruitment",  
        "15014 - Staff Training",  
        "15015 - Staff Welfare",  
        "15016 - Staff Medical",  
        "15017 - Staff Uniforms",  
        "15018 - Staff Bonuses",  
        "16000 - Rent",  
        "16001 - Rates",  
        "16002 - Light and Heat",  
        "16003 - Power",  
        "16004 - Water",  
        "16005 - Property Insurance",  
        "16006 - Cleaning",  
        "16007 - Security",  
        "16008 - Service Charges",  
        "16009 - Repairs and Maintenance",  
        "16010 - Decorating",  
        "16011 - Grounds Maintenance",  
        "16012 - Waste Disposal",  
        "16500 - Hire of Plant and Machinery",  
        "16501 - Equipment Hire",  
        "17000 - Motor Expenses - Fuel",  
        "17001 - Motor Expenses - Repairs",  
        "17002 - Motor Expenses - Servicing",  
        "17003 - Motor Expenses - Road Tax",  
        "17004 - Motor Expenses - Insurance",  
        "17005 - Motor Expenses - Lease",  
        "17006 - Motor Expenses - Parking",  
        "17007 - Motor Expenses - Fines",  
        "17008 - Motor Expenses - Breakdown Cover",  
        "17009 - Motor Expenses - Cleaning",  
        "17010 - Travel - Air",  
        "17011 - Travel - Rail",  
        "17012 - Travel - Taxi",  
        "17013 - Travel - Accommodation",  
        "17014 - Travel - Meals",  
        "17015 - Travel - Subsistence",  
        "17016 - Travel - Mileage Allowance",  
        "17500 - Telephone",  
        "17501 - Fax",  
        "17502 - Mobile Phones",  
        "17503 - Internet Services",  
        "17504 - Postage",  
        "17505 - Couriers",  
        "17506 - Stationery",  
        "17507 - Printing",  
        "17508 - Office Supplies",  
        "17509 - Subscriptions",  
        "17510 - Books and Journals",  
        "17511 - Publications",  
        "17512 - Newspapers and Magazines",  
        "17513 - Professional Fees",  
        "17514 - Accountancy Fees",  
        "17515 - Audit Fees",  
        "17516 - Legal Fees",  
        "17517 - Consultancy Fees",  
        "17518 - Bank Charges",  
        "17519 - Loan Interest",  
        "17520 - HP Interest",  
        "17521 - Leasing Charges",  
        "17522 - Depreciation",  
        "17523 - Amortisation",  
        "17524 - Bad Debts",  
        "17525 - Irrecoverable VAT",  
        "17526 - Entertaining - Staff",  
        "17527 - Entertaining - Clients",  
        "17528 - Donations",  
        "17529 - Fines and Penalties",  
        "17530 - Insurance - Business",  
        "17531 - Insurance - Employers Liability",  
        "17532 - Insurance - Public Liability",  
        "17533 - Insurance - Product Liability",  
        "17534 - Insurance - Professional Indemnity",  
        "17535 - Insurance - Directors & Officers",  
        "17536 - Insurance - Buildings",  
        "17537 - Insurance - Contents",  
        "17538 - Insurance - Vehicles",  
        "17539 - Insurance - Other",  
        "17540 - Software Licences",  
        "17541 - Computer Consumables",  
        "17542 - IT Support",  
        "17543 - Website Costs",  
        "17544 - Hosting Fees",  
        "17545 - Domain Name Costs",  
        "17546 - Advertising - Online",  
        "17547 - Advertising - Print",  
        "17548 - Advertising - Radio",  
        "17549 - Advertising - TV",  
        "17550 - Marketing - General",  
        "17551 - Marketing - Campaigns",  
        "17552 - PR Fees",  
        "17553 - Trade Shows",  
        "17554 - Event Costs",  
        "17555 - Sponsorship",  
        "17556 - Research and Development",  
        "17557 - Training Courses",  
        "17558 - Conferences",  
        "17559 - Professional Subscriptions",  
        "17560 - Recruitment Costs",  
        "17561 - Agency Fees",  
        "17562 - Relocation Costs",  
        "17563 - Redundancy Payments",  
        "17564 - Staff Functions",  
        "17565 - Staff Incentives",  
        "17566 - Childcare Vouchers",  
        "17567 - Pension Administration Fees",  
        "17568 - Payroll Services",  
        "17569 - HR Support",  
        "17570 - Environmental Costs",  
        "17571 - Health & Safety Costs",  
        "17572 - Quality Assurance",  
        "17573 - Internal Audit",  
        "17574 - Risk Management",  
        "17575 - Management Consultancy",  
        "17576 - Strategic Planning",  
        "17577 - Board Expenses",  
        "17578 - AGM Costs",  
        "17579 - Shareholder Costs",  
        "17580 - Company Secretarial",  
        "17581 - Registrar Fees",  
        "17582 - Government Levies",  
        "17583 - Regulatory Fees",  
        "17584 - Licences",  
        "17585 - Permits",  
        "17586 - Other Operating Expenses",  
        "17587 - Miscellaneous Expenses",  
        "18000 - Corporation Tax",  
        "18001 - Deferred Tax",  
        "18002 - Over/Under Provision PY",  
        "18003 - R&D Tax Credit",  
        "18004 - Tax Penalties",  
        "18005 - Tax Interest",  
        "18500 - Dividends Paid",  
        "18501 - Dividend Tax Credit",  
        "19000 - Extraordinary Income",  
        "19001 - Extraordinary Expenses",  
        "19500 - Prior Year Adjustments",  
        "19501 - Correction of Errors",  
        "19502 - Accounting Policy Changes",  
        "19900 - Suspense Account",  
        "19901 - Roundings",  
        "19902 - Journal Adjustments",  
        "19903 - Control Account Adjustments",  
        "19904 - Revaluation Reserve",  
        "19905 - Share Premium Account",  
        "19906 - Capital Redemption Reserve",  
        "19907 - Merger Reserve",  
        "19908 - Currency Translation Reserve",  
        "19909 - Other Reserves",
        "19910 - Retained Earnings",
        "19911 - Unrealised Gains",
        "19912 - Unrealised Losses",
        "19913 - Gains on Revaluation",
        "19914 - Losses on Revaluation",
        "19915 - Actuarial Gains",
        "19916 - Actuarial Losses",
        "19917 - Currency Gains",
        "19918 - Currency Losses",
        "19919 - Fair Value Adjustments",
        "19920 - Investment Revaluation",
        "19921 - Share-based Payment Reserve",
        "19922 - Treasury Shares",
        "19923 - Share Option Reserve",
        "19924 - Convertible Loan Reserve",
        "19925 - Equity Component of Convertible Loan",
        "19926 - Non-controlling Interest",
        "19927 - Minority Interest",
        "19928 - Capital Contributions",
        "19929 - Equity Settled Transactions",
        "19930 - Reclassification Adjustments",
        "19931 - OCI - Exchange Differences",
        "19932 - OCI - Revaluation Surplus",
        "19933 - OCI - Gains on Cash Flow Hedges",
        "19934 - OCI - Losses on Cash Flow Hedges",
        "19935 - OCI - Actuarial Gains/Losses",
        "19936 - OCI - Available-for-sale Investments",
        "19937 - OCI - Share of OCI of Associates",
        "19938 - OCI - Tax Relating to Components of OCI",
        "19939 - OCI - Other Items",
        "19940 - Equity - Opening Balance",
        "19941 - Equity - Closing Balance",
        "19942 - Opening Balance Adjustments",
        "19943 - Prior Period Restatement",
        "19944 - Movement in Reserves",
        "19945 - Reserve Transfers",
        "19946 - Capital Introduced",
        "19947 - Capital Withdrawn",
        "19948 - Drawings",
        "19949 - Owner’s Equity",
        "19950 - Partner’s Capital Account",
        "19951 - Partner’s Current Account",
        "19952 - Partnership Adjustments",
        "19953 - Members’ Contributions",
        "19954 - Members’ Withdrawals",
        "19955 - Members’ Profit Share",
        "19956 - LLP Capital Account",
        "19957 - LLP Current Account",
        "19958 - Sole Trader Capital",
        "19959 - Sole Trader Drawings",
        "19960 - Personal Expenses",
        "19961 - Business Start-up Costs",
        "19962 - Business Acquisition Costs",
        "19963 - Business Disposal Costs",
        "19964 - Goodwill Written Off",
        "19965 - Impairment of Goodwill",
        "19966 - Intangible Assets Reserve",
        "19967 - Tangible Asset Reserve",
        "19968 - Investment Property Reserve",
        "19969 - Biological Assets Reserve",
        "19970 - Held-for-sale Assets",
        "19971 - Liabilities Held-for-sale",
        "19972 - Discontinued Operations",
        "19973 - Assets Held in Trust",
        "19974 - Trust Liabilities",
        "19975 - Agency Balances",
        "19976 - Custodian Balances",
        "19977 - Client Funds Held",
        "19978 - Client Liabilities",
        "19979 - Deferred Consideration",
        "19980 - Contingent Consideration",
        "19981 - Escrow Accounts",
        "19982 - Escrow Liabilities",
        "19983 - Legal Provisions",
        "19984 - Warranty Provisions",
        "19985 - Dilapidation Provisions",
        "19986 - Onerous Contracts",
        "19987 - Restructuring Costs",
        "19988 - Environmental Provisions",
        "19989 - Provision for Litigation",
        "19990 - Provision for Claims",
        "19991 - Provision for Penalties",
        "19992 - Provision for Guarantees",
        "19993 - Deferred Income",
        "19994 - Pre-acquisition Profits",
        "19995 - Post-acquisition Profits",
        "19996 - Miscellaneous Equity Adjustments",
        "19997 - Non-standard Adjustments",
        "19998 - Technical Corrections",
        "19999 - Closing Reserve Balance"
    ];

    const input = document.getElementById('accountInput');
    const suggestionBox = document.getElementById('accountSuggestions');

    input.addEventListener('input', function () {
        const val = this.value.toLowerCase();
        suggestionBox.innerHTML = '';
        if (val === '') {
            suggestionBox.style.display = 'none';
            return;
        }

        const filtered = accounts.filter(acc => acc.toLowerCase().includes(val));

        filtered.forEach(account => {
            const item = document.createElement('li');
            item.classList.add('list-group-item', 'list-group-item-action');
            item.textContent = account;
            item.addEventListener('click', () => {
                input.value = account;
                suggestionBox.style.display = 'none';
            });
            suggestionBox.appendChild(item);
        });

        suggestionBox.style.display = filtered.length ? 'block' : 'none';
    });

    document.addEventListener('click', function (e) {
        if (!input.contains(e.target) && !suggestionBox.contains(e.target)) {
            suggestionBox.style.display = 'none';
        }
    });

    document.addEventListener('click', function (e) {
        if (e.target.closest('.add-btn')) {
            const tableBody = document.getElementById('tableBody');

            for (let i = 0; i < 1; i++) {  
                const newRow = tableBody.rows[0].cloneNode(true); 

                const inputs = newRow.querySelectorAll('input, select, textarea');
                inputs.forEach(input => {
                    if (input.type === 'date') {
                        // Skip clearing date inputs
                        return;
                    }

                    if (input.type === 'checkbox' || input.type === 'radio') {
                        input.checked = false;
                    } else {
                        input.value = '';
                    }
                });

                const clonedAccountInput = newRow.querySelector('#accountInput');
                const clonedSuggestionBox = newRow.querySelector('#accountSuggestions');

                clonedAccountInput.addEventListener('input', function () {
                    const val = this.value.toLowerCase();
                    clonedSuggestionBox.innerHTML = '';
                    if (val === '') {
                        clonedSuggestionBox.style.display = 'none';
                        return;
                    }

                    const filtered = accounts.filter(acc => acc.toLowerCase().includes(val));

                    filtered.forEach(account => {
                        const item = document.createElement('li');
                        item.classList.add('list-group-item', 'list-group-item-action');
                        item.textContent = account;
                        item.addEventListener('click', () => {
                            clonedAccountInput.value = account;
                            clonedSuggestionBox.style.display = 'none';
                        });
                        clonedSuggestionBox.appendChild(item);
                    });

                    clonedSuggestionBox.style.display = filtered.length ? 'block' : 'none';
                });

                tableBody.appendChild(newRow);
            }
        }
    });

    document.addEventListener("DOMContentLoaded", function() {
        const rows = document.querySelectorAll('#tableBody tr');
        
        rows.forEach(row => {
            const debitInput = row.querySelector('.debitInput');
            const creditInput = row.querySelector('.creditInput');

            // Disable opposite field based on user input
            debitInput.addEventListener('input', function() {
                if (debitInput.value !== "") {
                    creditInput.disabled = true;
                    creditInput.value = ""; // clear credit input if debit is typed
                } else {
                    creditInput.disabled = false;
                }
            });

            creditInput.addEventListener('input', function() {
                if (creditInput.value !== "") {
                    debitInput.disabled = true;
                    debitInput.value = ""; // clear debit input if credit is typed
                } else {
                    debitInput.disabled = false;
                }
            });
        });
    });

    // Function to capture and store values from all form inputs
    function captureFormData() {
        const entries = document.querySelectorAll('#tableBody tr');
        let capturedData = [];

        entries.forEach(entry => {
            const date = entry.querySelector('.dateInput')?.value.trim();
            const description = entry.querySelector('.descriptionInput')?.value.trim();
            const user = entry.querySelector('.userInput')?.value.trim();
            const account = entry.querySelector('.accountInput')?.value.trim();
            const debit = parseFloat(entry.querySelector('.debitInput')?.value.trim()) || 0;
            const credit = parseFloat(entry.querySelector('.creditInput')?.value.trim()) || 0;

            let amount = 0;
            let type = "";

            if (credit > 0 && debit === 0) {
                amount = credit;
                type = "Credit";
            } else if (debit > 0 && credit === 0) {
                amount = debit;
                type = "Debit";
            }

            if (date && description && user && account && amount && type) {
                capturedData.push({
                    date: date,
                    description: description,
                    user: user,
                    account: account,
                    amount: amount,
                    type: type
                });
            }
        });

        const tableHeader = `
            <thead>
                <tr>
                    <th>Date</th>
                    <th>Description</th>
                    <th>User</th>
                    <th>Account</th>
                    <th>Amount</th>
                    <th>Type</th>
                </tr>
            </thead>
        `;

        const tableBody = `
            <tbody>
                ${capturedData.map(entry => `
                    <tr>
                        <td>${entry.date}</td>
                        <td>${entry.description}</td>
                        <td>${entry.user}</td>
                        <td>${entry.account}</td>
                        <td>${entry.amount.toFixed(2)}</td>
                        <td>${entry.type}</td>
                    </tr>
                `).join('')}
            </tbody>
        `;

        document.getElementById('resultContainer').innerHTML = `
            <h4>Recent Entries</h4>
            <table class="table table-hover text-nowrap">
                ${tableHeader} 
                ${tableBody}
            </table>
        `;

        entries.forEach(entry => {
            entry.querySelectorAll('input, textarea').forEach(el => el.value = '');
        });

        const suggestionBox = document.getElementById('accountSuggestions');
        if (suggestionBox) {
            suggestionBox.style.display = 'none';
        }
    }


    document.getElementById('submitBtn').addEventListener('click', function() {
        // Capture the form data
        calculateTotals();
    });

    // Get the table body element
    const tableBody = document.getElementById('tableBody');

    // Loop 30 times and clone the first row
    for (let i = 0; i < 29; i++) {  // Start from 0 to 29 for a total of 30 rows (1 already in HTML)
        const newRow = tableBody.rows[0].cloneNode(true); // Clone the first row

        // Reattach the event listener for account input field in the clone
        const clonedAccountInput = newRow.querySelector('#accountInput');
        const clonedSuggestionBox = newRow.querySelector('#accountSuggestions');

        clonedAccountInput.addEventListener('input', function () {
            const val = this.value.toLowerCase();
            clonedSuggestionBox.innerHTML = '';
            if (val === '') {
                clonedSuggestionBox.style.display = 'none';
                return;
            }

            const filtered = accounts.filter(acc => acc.toLowerCase().includes(val));

            filtered.forEach(account => {
                const item = document.createElement('li');
                item.classList.add('list-group-item', 'list-group-item-action');
                item.textContent = account;
                item.addEventListener('click', () => {
                    clonedAccountInput.value = account;
                    clonedSuggestionBox.style.display = 'none';
                });
                clonedSuggestionBox.appendChild(item);
            });

            clonedSuggestionBox.style.display = filtered.length ? 'block' : 'none';
        });

        tableBody.appendChild(newRow);
    }

    document.addEventListener('DOMContentLoaded', () => {
        // Get all current and future date inputs
        const updateAllDates = (value) => {
            document.querySelectorAll('.dateInput').forEach(input => {
                input.value = value;
            });
        };

        // Delegate event listener
        document.addEventListener('input', (e) => {
            if (e.target && e.target.classList.contains('dateInput')) {
                updateAllDates(e.target.value);
            }
        });
    });

    function calculateTotals() {
        let creditTotal = 0;
        let debitTotal = 0;

        const rows = document.querySelectorAll('#tableBody tr');

        rows.forEach(row => {
            const creditInput = row.querySelector('.creditInput');
            const debitInput = row.querySelector('.debitInput');

            const credit = parseFloat(creditInput?.value.trim()) || 0;
            const debit = parseFloat(debitInput?.value.trim()) || 0;

            creditTotal += credit;
            debitTotal += debit;
        });

        const sum = creditTotal - debitTotal;

        if (sum !== 0) {
            errorContainer.textContent = `⚠️ Amounts must balance. Difference: ${sum.toFixed(2)}`;
        } else {
            errorContainer.textContent = '';
            captureFormData();
        }
    }

</script>