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