$(document).ready(function() {
// Function to calculate and update the total
function calculateTotal() {
var total = 0;
$('.sum-col').each(function() {
var val = parseFloat($(this).val()) || 0;
total += val;
});
$('#columnTotal').text(total.toFixed(2));
}
// Auto-calculate Amount = Quantity × Price when Quantity or Price changes
$('#myTable').on('input', '.qty, .price', function() {
var row = $(this).closest('tr');
var qty = parseFloat(row.find('.qty').val()) || 0;
var price = parseFloat(row.find('.price').val()) || 0;
var amount = qty * price;
row.find('.sum-col').val(amount.toFixed(2));
calculateTotal();
});
// If Amount is manually edited, just update the total (no override)
$('#myTable').on('input', '.sum-col', function() {
calculateTotal();
});
// Add new row
$('#addRow').on('click', function() {
var newRow = `
