Partial Fulfillment & Automatic Customer Notifications

/**
 * @NApiVersion 2.1
 * @NScriptType UserEventScript
 * Title: UE | Email customer on partial fulfillment
 * Author: The NetSuite Pro
 */
define(['N/record','N/search','N/email','N/runtime','N/format','N/log','N/url'],
(record, search, email, runtime, format, log, url) => {

  const SO_NOTIFY_FIELD = 'custbody_notify_on_partial';
  const SO_LINE_ETA = 'custcol_expected_ship_date'; // optional

  const afterSubmit = (ctx) => {
    if (ctx.type !== ctx.UserEventType.CREATE) return;

    try {
      const ifRec = record.load({ type: record.Type.ITEM_FULFILLMENT, id: ctx.newRecord.id });
      const soId = ifRec.getValue('createdfrom');
      if (!soId) return;

      const so = record.load({ type: record.Type.SALES_ORDER, id: soId });
      const notify = !!so.getValue(SO_NOTIFY_FIELD);
      if (!notify) return;

      const customerId = so.getValue('entity');
      const customerEmail = so.getValue('email'); // fallback to entity email; could also search for primary contact

      // Build shipped lines (from the IF just created)
      const shipped = [];
      const ifLineCount = ifRec.getLineCount({ sublistId: 'item' });
      for (let i = 0; i < ifLineCount; i++) {
        const itemId = ifRec.getSublistValue({ sublistId:'item', fieldId:'item', line:i });
        const itemName = ifRec.getSublistText({ sublistId:'item', fieldId:'item', line:i });
        const qtyShip = Number(ifRec.getSublistValue({ sublistId:'item', fieldId:'quantity', line:i }) || 0);
        if (qtyShip > 0) {
          shipped.push({ itemId, itemName, qty: qtyShip });
        }
      }

      // Compute remaining lines from the SO snapshot
      const remaining = [];
      const soLineCount = so.getLineCount({ sublistId: 'item' });
      let anyShipped = shipped.length > 0;
      let anyRemaining = false;

      for (let i = 0; i < soLineCount; i++) {
        const itemName = so.getSublistText({ sublistId:'item', fieldId:'item', line:i });
        const qtyOrdered = Number(so.getSublistValue({ sublistId:'item', fieldId:'quantity', line:i }) || 0);
        const qtyFulfilled = Number(so.getSublistValue({ sublistId:'item', fieldId:'quantityfulfilled', line:i }) || 0);
        const eta = so.getSublistValue({ sublistId:'item', fieldId: SO_LINE_ETA, line:i });

        const qtyRemain = Math.max(qtyOrdered - qtyFulfilled, 0);
        if (qtyRemain > 0) {
          anyRemaining = true;
          remaining.push({
            itemName,
            qtyRemain,
            eta: eta ? tryFormatDate(eta) : ''
          });
        }
      }

      // If not partial (i.e., shipped and nothing remaining), do nothing
      const isPartial = anyShipped && anyRemaining;
      if (!isPartial) return;

      // Tracking (from IF packages) – optional
      const trackingList = collectTracking(ifRec);

      // Compose email HTML
      const soTranId = so.getValue('tranid');
      const subject = `Your order ${soTranId} has partially shipped`;
      const html = buildEmailHtml({
        soTranId,
        shipped,
        remaining,
        trackingList
      });

      // Recipient: customer email or fall back to primary contact
      if (!customerEmail) {
        log.audit('No customer email on SO; skipping send', { soId, customerId });
        return;
      }

      // Send
      const author = runtime.getCurrentUser().id;
      email.send({
        author,
        recipients: customerEmail,
        subject,
        body: html,
        relatedRecords: { transactionId: soId }
      });

      log.audit('Partial fulfillment email sent', { soId, customerEmail, shippedCount: shipped.length, remainingCount: remaining.length });

    } catch (e) {
      log.error('Partial fulfillment UE error', e);
    }
  };

  function collectTracking(ifRec) {
    const tracking = [];
    const pkgCount = ifRec.getLineCount({ sublistId: 'package' });
    for (let i = 0; i < pkgCount; i++) {
      const num = ifRec.getSublistValue({ sublistId:'package', fieldId:'packagetrackingnumber', line:i });
      const carrier = ifRec.getSublistText({ sublistId:'package', fieldId:'packagecarrier', line:i });
      if (num) tracking.push({ carrier, number: num });
    }
    return tracking;
  }

  function tryFormatDate(val) {
    try {
      return format.format({ value: val, type: format.Type.DATE });
    } catch (_e) {
      return String(val);
    }
  }

  function buildEmailHtml({ soTranId, shipped, remaining, trackingList }) {
    const css = `
      <style>
        .tbl{border-collapse:collapse;width:100%;}
        .tbl th,.tbl td{border:1px solid #e5e5e5;padding:6px 8px;font-size:13px;}
        .num{text-align:right;}
        .muted{color:#666;}
        h2{margin:0 0 8px 0;font-size:18px;}
        h3{margin:16px 0 6px 0;font-size:15px;}
      </style>`;
    const shippedRows = shipped.map(s => `<tr><td>${escapeHtml(s.itemName)}</td><td class="num">${s.qty}</td></tr>`).join('');
    const remainRows = remaining.map(r => `<tr><td>${escapeHtml(r.itemName)}</td><td class="num">${r.qtyRemain}</td><td>${r.eta || '<span class="muted">—</span>'}</td></tr>`).join('');
    const trackRows = trackingList.length
      ? trackingList.map(t => `<div>${escapeHtml(t.carrier || 'Carrier')}: <b>${escapeHtml(t.number)}</b></div>`).join('')
      : '<div class="muted">Tracking not available for all packages yet.</div>';

    return `
      ${css}
      <div>
        <h2>Good news — part of your order has shipped!</h2>
        <div>Order: <b>${escapeHtml(soTranId)}</b></div>

        <h3>Shipped Items</h3>
        <table class="tbl">
          <tr><th>Item</th><th class="num">Qty Shipped</th></tr>
          ${shippedRows || '<tr><td colspan="2" class="muted">No items detected.</td></tr>'}
        </table>

        <h3>Items Still on the Way</h3>
        <table class="tbl">
          <tr><th>Item</th><th class="num">Qty Remaining</th><th>ETA</th></tr>
          ${remainRows || '<tr><td colspan="3" class="muted">None.</td></tr>'}
        </table>

        <h3>Tracking</h3>
        ${trackRows}

        <p class="muted">You’ll receive another email once the remaining items ship. If you have questions, just reply to this message.</p>
      </div>
    `;
  }

  function escapeHtml(s) {
    return String(s || '').replace(/[&<>"']/g, m => ({'&':'&','<':'<','>':'>','"':'"',"'":'''}[m]));
  }

  return { afterSubmit };
});