Spaces:
Sleeping
Sleeping
File size: 8,021 Bytes
063f5af 38c96d1 063f5af 38c96d1 063f5af 38c96d1 063f5af 38c96d1 063f5af 38c96d1 |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 |
// helper: convert number to Indian-notation words (Crore, Lakh, Thousand, Hundred)
function numberToWords(num) {
const small = ['', 'One', 'Two', 'Three', 'Four', 'Five', 'Six', 'Seven', 'Eight', 'Nine',
'Ten', 'Eleven', 'Twelve', 'Thirteen', 'Fourteen', 'Fifteen', 'Sixteen', 'Seventeen', 'Eighteen', 'Nineteen'];
const tens = ['', '', 'Twenty', 'Thirty', 'Forty', 'Fifty', 'Sixty', 'Seventy', 'Eighty', 'Ninety'];
function twoDigit(n) {
if (n < 20) return small[n];
return tens[Math.floor(n / 10)] + (n % 10 ? ' ' + small[n % 10] : '');
}
let words = '';
const crore = Math.floor(num / 10000000); num %= 10000000;
if (crore) words += twoDigit(crore) + ' Crore ';
const lakh = Math.floor(num / 100000); num %= 100000;
if (lakh) words += twoDigit(lakh) + ' Lakh ';
const thousand = Math.floor(num / 1000); num %= 1000;
if (thousand) words += twoDigit(thousand) + ' Thousand ';
const hundred = Math.floor(num / 100); num %= 100;
if (hundred) words += small[hundred] + ' Hundred ';
if (num) words += (words ? 'and ' : '') + twoDigit(num) + ' ';
return words.trim() || 'Zero';
}
if (typeof document !== 'undefined') {
document.addEventListener('DOMContentLoaded', function () {
const addItemBtn = document.getElementById('add-item');
const itemsTableBody = document.querySelector('#items-table tbody');
const form = document.getElementById('quotation-form');
const output = document.getElementById('quotation-output');
function updateSerialNumbers() {
itemsTableBody.querySelectorAll('tr').forEach((row, i) => {
row.querySelector('.item-slno').textContent = i + 1;
});
}
function addItemRow() {
const row = document.createElement('tr');
row.innerHTML = `
<td class="item-slno" data-label="S.No"></td>
<td data-label="Description"><input type="text" class="item-desc" placeholder="Item Description" required></td>
<td data-label="HSN Code"><input type="text" class="item-hsn" placeholder="HSN Code"></td>
<td data-label="Qty"><input type="number" class="item-qty" value="1" min="0" required></td>
<td data-label="Unit Price"><input type="number" class="item-price" value="0" min="0" required></td>
<td data-label="Discount (%)"><input type="number" class="item-discount" value="0" min="0" max="100" step="0.01" placeholder="Discount %"></td>
<td class="item-amount" data-label="Amount">0.00</td>
<td data-label="Action"><button type="button" class="remove-item">Remove</button></td>
`;
itemsTableBody.appendChild(row);
updateSerialNumbers();
const inputs = row.querySelectorAll('input');
inputs.forEach(input => input.addEventListener('input', updateItemAmount));
row.querySelector('.remove-item').addEventListener('click', () => {
row.remove();
updateSerialNumbers();
});
}
function updateItemAmount(e) {
const row = e.target.closest('tr');
const qty = parseFloat(row.querySelector('.item-qty').value) || 0;
const price = parseFloat(row.querySelector('.item-price').value) || 0;
const discountRate = parseFloat(row.querySelector('.item-discount').value) || 0;
const discountAmount = qty * price * discountRate / 100;
const amount = qty * price - discountAmount;
row.querySelector('.item-amount').textContent = amount.toFixed(2);
}
addItemBtn.addEventListener('click', addItemRow);
form.addEventListener('submit', function (e) {
e.preventDefault();
const data = new FormData(form);
const company = {
name: data.get('company-name'),
address: data.get('company-address'),
phone: data.get('company-phone'),
email: data.get('company-email')
};
const customer = {
name: data.get('customer-name'),
address: data.get('customer-address'),
phone: data.get('customer-phone'),
email: data.get('customer-email')
};
const quotationNumber = data.get('quotation-number');
const quotationDate = data.get('quotation-date');
const igstRate = parseFloat(data.get('igst-rate')) || 0;
const freightCharges = parseFloat(data.get('freight-charges')) || 0;
const bank = {
name: data.get('bank-name'),
account: data.get('bank-account'),
ifsc: data.get('bank-ifsc'),
branch: data.get('bank-branch')
};
const items = [];
itemsTableBody.querySelectorAll('tr').forEach(row => {
items.push({
description: row.querySelector('.item-desc').value,
hsn: row.querySelector('.item-hsn').value,
qty: parseFloat(row.querySelector('.item-qty').value) || 0,
price: parseFloat(row.querySelector('.item-price').value) || 0,
discount: parseFloat(row.querySelector('.item-discount').value) || 0,
amount: parseFloat(row.querySelector('.item-amount').textContent) || 0
});
});
const subtotal = items.reduce((sum, i) => sum + i.amount, 0);
const igstAmount = (subtotal * igstRate) / 100;
const total = subtotal + igstAmount + freightCharges;
// convert total to words (Rupees and Paise)
const rupeePart = Math.floor(total);
const paisePart = Math.round((total - rupeePart) * 100);
const rupeeWords = numberToWords(rupeePart);
const paiseWords = paisePart > 0 ? numberToWords(paisePart) : '';
let html = '<div class="quotation-print">';
html += `<div class="section"><strong>From:</strong><br>${company.name}<br>${company.address.replace(/\n/g, '<br>')}<br>Phone: ${company.phone}<br>Email: ${company.email}</div>`;
html += `<div class="section"><strong>To:</strong><br>${customer.name}<br>${customer.address.replace(/\n/g, '<br>')}<br>Phone: ${customer.phone}<br>Email: ${customer.email}</div>`;
html += `<div class="section quote-meta">Quotation No: ${quotationNumber}<br>Date: ${quotationDate}</div>`;
html += '<table class="quotation-table"><thead><tr><th>S.No</th><th>Description</th><th>HSN</th><th>Qty</th><th>Unit Price</th><th>Discount (%)</th><th>Amount</th></tr></thead><tbody>';
items.forEach((item, idx) => {
html += `<tr><td>${idx + 1}</td><td>${item.description}</td><td>${item.hsn}</td><td>${item.qty}</td><td>${item.price.toFixed(2)}</td><td>${item.discount.toFixed(2)}%</td><td>${item.amount.toFixed(2)}</td></tr>`;
});
html += '</tbody></table>';
html += `<div class="section amount-words"><strong>Amount in Words:</strong> Rupees ${rupeeWords}${paiseWords ? ' and ' + paiseWords + ' Paise' : ''} only</div>`;
html += '<div class="totals"><table>';
html += `<tr><td>Subtotal:</td><td>${subtotal.toFixed(2)}</td></tr>`;
html += `<tr><td>IGST (${igstRate}%):</td><td>${igstAmount.toFixed(2)}</td></tr>`;
html += `<tr><td>Freight:</td><td>${freightCharges.toFixed(2)}</td></tr>`;
html += `<tr><td><strong>Total:</strong></td><td><strong>${total.toFixed(2)}</strong></td></tr>`;
html += '</table></div>';
html += `<div class="section"><strong>Bank Details:</strong><br>Bank: ${bank.name}<br>Account: ${bank.account}<br>IFSC: ${bank.ifsc}<br>Branch: ${bank.branch}</div>`;
html += '<p class="disclaimer">This quotation is not a contract or a bill. It is our best guess at the total price for the service and goods described above. The customer will be billed after indicating acceptance of this quote. Payment will be due prior to the delivery of service and goods. Please fax or mail the signed quote to the address listed above.</p>';
html += '<button onclick="window.print()">Print / Save as PDF</button>';
html += '</div>';
output.innerHTML = html;
output.style.display = 'block';
document.getElementById('form-container').style.display = 'none';
addItemRow();
});
});
}
// Export for testing (Node.js)
if (typeof module !== 'undefined' && module.exports) {
module.exports = { numberToWords };
}
|