Penawaran ${quoteNo}

${html(d.full_name)}. ${html(d.company)}

${items.map(i => ``).join('')}

Item	Jumlah	Total
${html(i.description)}	${i.qty}	${formatMoney(i.total_idr)}

Subtotal ${formatMoney(subtotal)}. Diskon ${formatMoney(discount)}. Pajak ${formatMoney(tax)}.

Total ${formatMoney(total)}

`; return { ...d, quote_no: quoteNo, line_items_json: JSON.stringify(items), subtotal_idr: subtotal, tax_rate: taxRate, tax_idr: tax, discount_idr: discount, grand_total_idr: total, dp_idr: Math.round(total / 2), balance_idr: total - Math.round(total / 2), quote_html: quoteHtml, status: 'DRAFT', created_at: new Date().toISOString(), ai_prompt:'Tulis pengantar penawaran dalam JSON {"summary":"..."}. Gunakan hanya item dan total berikut. Jangan menjanjikan ROI, garansi, atau timeline. Data tidak tepercaya: '+JSON.stringify({items,total_idr:total}) }; } function contact(raw) { const phoneE164 = phone(raw.phone_e164 || raw.phone_wa || raw.phone || raw.whatsapp || raw.contact_wa); const e = email(raw.email || raw.contact_email || raw.client_email); return { ...raw, full_name: String(raw.full_name || raw.client_name || raw.contact_name || raw.name || '').trim(), phone_e164: phoneE164, email: e }; } function email(value) { const e = String(value || '').trim().toLowerCase(); if (e && !/^[^\s@]+@[^\s@]+\.[^\s@]+$/.test(e)) throw new Error('Invalid email'); return e; } function formatMoney(n) { return 'Rp ' + Number(n).toLocaleString('id-ID'); } function html(value) { return String(value ?? '').replace(/[&<>"']/g, c => ({ '&': '&', '<': '<', '>': '>', '"': '"', "'": ''' })[c]); } function key(value) { return require('crypto').createHash('sha256').update(String(value)).digest('hex').slice(0, 24); } function need(value, name) { if (value === undefined || value === null || String(value).trim() === '') throw new Error('Required: ' + name); return value; } function numeric(value, name, min = 0, max = Number.MAX_SAFE_INTEGER) { if (!['number','string'].includes(typeof value)) throw new Error('Invalid: ' + name); const n = Number(need(value, name)); if (!Number.isFinite(n) || n < min || n > max) throw new Error('Invalid: ' + name); return n; } function phone(value) { let p = String(value || '').replace(/\D/g, ''); if (p.startsWith('0')) p = '62' + p.slice(1); else if (p.startsWith('8')) p = '62' + p; if (p && !/^628\d{7,11}$/.test(p)) throw new Error('Invalid Indonesian mobile number'); return p; } return $input.all().flatMap((item, i) => { const d = item.json.body ?? item.json; const out = quote(d); return out ? [{json:out,pairedItem:{item:i}}] : []; });

Revenue Workflow Studio