/**
 * @NApiVersion 2.1
 * @NScriptType ClientScript
 * @NModuleScope SameAccount
 */
define(['N/currentRecord', 'N/ui/dialog'], (cr, dialog) => {

  function saveRecord(context) {
    const rec = cr.get();
    const customer = rec.getValue({ fieldId: 'entity' });
    const total = rec.getValue({ fieldId: 'total' });

    if (!customer) {
      dialog.alert({ title: 'Validation', message: 'Customer is required.' });
      return false;
    }
    if (total <= 0) {
      dialog.alert({ title: 'Validation', message: 'Order total must be greater than zero.' });
      return false;
    }
    return true;
  }

  function fieldChanged(context) {
    if (context.fieldId === 'quantity' || context.fieldId === 'rate') {
      const rec = cr.get();
      const qty = rec.getCurrentSublistValue({ sublistId: 'item', fieldId: 'quantity' });
      const rate = rec.getCurrentSublistValue({ sublistId: 'item', fieldId: 'rate' });
      rec.setCurrentSublistValue({ sublistId: 'item', fieldId: 'amount', value: qty * rate });
    }
  }

  return { saveRecord, fieldChanged };
});

/**
 * @NApiVersion 2.1
 * @NScriptType UserEventScript
 */
define(['N/record', 'N/log'], (record, log) => {

  function beforeSubmit(context) {
    if (context.type !== context.UserEventType.CREATE) return;
    const rec = context.newRecord;
    rec.setValue({ fieldId: 'department', value: 1 }); // Dairy & Cheese
    log.audit('GFS-UE', 'Set department for ' + rec.type + ' ' + rec.id);
  }

  function afterSubmit(context) {
    if (context.type === context.UserEventType.DELETE) return;
    const rec = record.load({ type: context.newRecord.type, id: context.newRecord.id });
    const total = rec.getValue({ fieldId: 'total' });
    if (total > 25000) {
      log.audit('GFS-UE', 'Order ' + rec.id + ' requires L2 approval: $' + total);
    }
  }

  return { beforeSubmit, afterSubmit };
});

/**
 * @NApiVersion 2.1
 * @NScriptType Suitelet
 */
define(['N/ui/serverWidget', 'N/query'], (sw, query) => {

  function onRequest(context) {
    if (context.request.method === 'GET') {
      const form = sw.createForm({ title: 'GFS Operations Dashboard' });
      form.clientScriptModulePath = './gfs_cs_dashboard.js';

      const sublist = form.addSublist({
        id: 'custpage_results', type: sw.SublistType.LIST,
        label: 'Search Results'
      });
      sublist.addField({ id: 'custpage_doc', type: sw.FieldType.TEXT, label: 'Doc #' });
      sublist.addField({ id: 'custpage_entity', type: sw.FieldType.TEXT, label: 'Customer' });
      sublist.addField({ id: 'custpage_amount', type: sw.FieldType.CURRENCY, label: 'Amount' });

      const sql = "SELECT tranid, entity, foreigntotal FROM transaction " +
                  "WHERE type = 'SalesOrd' ORDER BY trandate DESC FETCH FIRST 50 ROWS ONLY";
      const results = query.runSuiteQL({ query: sql }).asMappedResults();
      results.forEach((row, i) => {
        sublist.setSublistValue({ id: 'custpage_doc', line: i, value: row.tranid });
        sublist.setSublistValue({ id: 'custpage_amount', line: i, value: row.foreigntotal });
      });

      context.response.writePage(form);
    }
  }

  return { onRequest };
});

/**
 * @NApiVersion 2.1
 * @NScriptType Restlet
 */
define(['N/record', 'N/log'], (record, log) => {

  function get(context) {
    const { type, id } = context;
    if (!type || !id) return { error: 'Missing type or id parameter' };
    try {
      const rec = record.load({ type, id, isDynamic: false });
      return {
        id: rec.id, tranid: rec.getValue('tranid'),
        entity: rec.getText('entity'), total: rec.getValue('total'),
        status: rec.getText('status')
      };
    } catch (e) {
      log.error('GFS-RESTlet', e.message);
      return { error: e.message };
    }
  }

  function post(context) {
    const rec = record.create({ type: context.recordType, isDynamic: true });
    Object.keys(context.fields).forEach(fld => {
      rec.setValue({ fieldId: fld, value: context.fields[fld] });
    });
    return { success: true, id: rec.save() };
  }

  return { get, post };
});

/**
 * @NApiVersion 2.1
 * @NScriptType MapReduceScript
 */
define(['N/search', 'N/record', 'N/log'], (search, record, log) => {

  function getInputData() {
    return search.create({
      type: 'salesorder',
      filters: [
        ['status', 'anyof', 'SalesOrd:B'],
        'AND', ['trandate', 'onorbefore', 'daysago7']
      ],
      columns: ['tranid', 'entity', 'total']
    });
  }

  function map(context) {
    const result = JSON.parse(context.value);
    context.write({
      key: result.values.entity.value,
      value: { tranid: result.values.tranid, total: result.values.total }
    });
  }

  function reduce(context) {
    const orders = context.values.map(v => JSON.parse(v));
    log.audit('GFS-MR', 'Entity ' + context.key + ': ' + orders.length + ' stale orders');
  }

  function summarize(summary) {
    log.audit('GFS-MR Complete', 'Map errors: ' + summary.mapSummary.errors.length +
      ', Reduce errors: ' + summary.reduceSummary.errors.length);
  }

  return { getInputData, map, reduce, summarize };
});

/**
 * @NApiVersion 2.1
 * @NScriptType ScheduledScript
 */
define(['N/search', 'N/record', 'N/email', 'N/runtime', 'N/log'], (search, record, email, runtime, log) => {

  function execute(context) {
    const script = runtime.getCurrentScript();
    log.audit('GFS-Sched', 'Start: ' + context.type + ' | Gov remaining: ' + script.getRemainingUsage());

    // Find invoices past due > 30 days
    const results = search.create({
      type: 'invoice',
      filters: [
        ['status', 'anyof', 'CustInvc:A'],
        'AND', ['duedate', 'before', 'daysago30'],
        'AND', ['amountremaining', 'greaterthan', 0]
      ],
      columns: ['tranid', 'entity', 'amountremaining', 'duedate']
    }).run().getRange({ start: 0, end: 100 });

    results.forEach(r => {
      // Check governance before each operation
      if (script.getRemainingUsage() < 100) {
        log.audit('GFS-Sched', 'Rescheduling - low governance');
        return;
      }
      log.audit('GFS-Sched', 'Past due: ' + r.getValue('tranid') +
        ' | $' + r.getValue('amountremaining'));
    });

    log.audit('GFS-Sched', 'Complete. Processed ' + results.length + ' records.');
  }

  return { execute };
});

/**
 * @NApiVersion 2.1
 * @NScriptType Portlet
 */
define(['N/query', 'N/ui/serverWidget'], (query, sw) => {

  function render(params) {
    const portlet = params.portlet;
    portlet.title = 'GFS Open Orders Summary';
    portlet.addColumn({ id: 'custpage_metric', type: 'text', label: 'Metric', align: sw.LayoutJustification.LEFT });
    portlet.addColumn({ id: 'custpage_value', type: 'text', label: 'Value', align: sw.LayoutJustification.RIGHT });

    const sql = `SELECT
      COUNT(*) AS cnt,
      SUM(foreigntotal) AS total
    FROM transaction
    WHERE type = 'SalesOrd' AND status IN ('SalesOrd:A','SalesOrd:B')`;

    const result = query.runSuiteQL({ query: sql }).asMappedResults()[0];

    portlet.addRow({ custpage_metric: 'Open Sales Orders', custpage_value: String(result.cnt) });
    portlet.addRow({ custpage_metric: 'Total Value', custpage_value: '$' + Number(result.total).toLocaleString() });
  }

  return { render };
});

/**
 * @NApiVersion 2.1
 * @NScriptType MassUpdateScript
 */
define(['N/record', 'N/log'], (record, log) => {

  function each(params) {
    try {
      const rec = record.load({ type: params.type, id: params.id });
      const currentDept = rec.getValue({ fieldId: 'department' });

      if (!currentDept) {
        rec.setValue({ fieldId: 'department', value: 1 }); // Default: Dairy & Cheese
        rec.setValue({ fieldId: 'custbody_gfs_brand', value: 'GFS' });
        rec.save();
        log.audit('GFS-MassUpdate', 'Updated record ' + params.id);
      }
    } catch (e) {
      log.error('GFS-MassUpdate', 'Error on ' + params.id + ': ' + e.message);
    }
  }

  return { each };
});

/**
 * @NApiVersion 2.1
 * @NScriptType BundleInstallationScript
 */
define(['N/log', 'N/runtime'], (log, runtime) => {

  function beforeInstall(params) {
    log.audit('GFS-Bundle', 'Pre-install check. Version: ' + params.version);
    // Verify prerequisites
    const account = runtime.accountId;
    log.audit('GFS-Bundle', 'Installing to account: ' + account);
  }

  function afterInstall(params) {
    log.audit('GFS-Bundle', 'Bundle installed. Version: ' + params.version);
    // Initialize custom records, default values, etc.
  }

  function beforeUpdate(params) {
    log.audit('GFS-Bundle', 'Updating from ' + params.fromVersion + ' to ' + params.toVersion);
  }

  function afterUpdate(params) {
    log.audit('GFS-Bundle', 'Update complete. Running migrations...');
    // Data migration logic for version upgrades
  }

  function beforeUninstall(params) {
    log.audit('GFS-Bundle', 'Uninstall requested. Cleaning up...');
  }

  return { beforeInstall, afterInstall, beforeUpdate, afterUpdate, beforeUninstall };
});

/**
 * @NApiVersion 2.1
 * @NScriptType WorkflowActionScript
 */
define(['N/record', 'N/email', 'N/runtime', 'N/log'], (record, email, runtime, log) => {

  function onAction(context) {
    const rec = context.newRecord;
    const total = rec.getValue({ fieldId: 'total' });
    const dept = rec.getText({ fieldId: 'department' });

    // Determine approval level based on amount
    let approverRole;
    if (total < 5000) {
      approverRole = 'auto-approved';
    } else if (total < 25000) {
      approverRole = 'L1-manager';
    } else {
      approverRole = 'L2-vp';
    }

    rec.setValue({ fieldId: 'custbody_gfs_approval_level', value: approverRole });

    // Send notification
    email.send({
      author: runtime.getCurrentUser().id,
      recipients: getApprover(approverRole),
      subject: 'GFS Approval Required: ' + rec.getValue('tranid') + ' ($' + total + ')',
      body: 'PO requires ' + approverRole + ' approval. Dept: ' + dept
    });

    log.audit('GFS-WF', rec.getValue('tranid') + ' routed to ' + approverRole);
    return approverRole;
  }

  function getApprover(role) {
    // Map roles to employee IDs
    const map = { 'L1-manager': 142, 'L2-vp': 87 };
    return map[role] || 1; // fallback to admin
  }

  return { onAction };
});

<div class="ns-app-shell">
  <div class="ns-topbar">
    <div class="ns-topbar-left">
      <span class="ns-topbar-logo">&#9632; GFS</span>
      <div class="ns-topbar-divider"></div>
      <span class="ns-topbar-portal">[Portal Name]</span>
    </div>
    <div class="ns-topbar-right">
      <div class="ns-topbar-user">
        <div class="ns-topbar-avatar">ML</div>
        <span class="ns-topbar-name">M. Levine</span>
      </div>
    </div>
  </div>
  <div class="ns-breadcrumb">
    <a href="#">Home</a>
    <span class="ns-bc-sep">/</span>
    <span class="ns-bc-current">[Page]</span>
  </div>
  <div class="ns-app-body">
    <div class="ns-sidebar"><!-- Nav items --></div>
    <div class="ns-content"><!-- Page content --></div>
  </div>
  <div class="ns-app-footer">
    <span>Global Food Solutions, Inc.</span>
    <span>GFS Suitelet Framework v10.0</span>
  </div>
</div>

<div class="ns-record-header">
  <div>
    <div class="ns-record-type">Sales Order</div>
    <div class="ns-record-id">SO-XXXXX
      <span class="ns-badge ns-badge-pending">Pending</span>
    </div>
  </div>
</div>
<div class="ns-form-section" style="padding:0 24px;">
  <div class="ns-form-section-title">Primary Information</div>
  <div class="ns-2col">
    <div class="ns-field">
      <label class="ns-field-label">Customer <span class="ns-required">*</span></label>
      <select class="ns-input" required><option value="">-- Select --</option></select>
    </div>
  </div>
</div>
<div class="ns-form-actions" style="padding:0 24px 24px;">
  <button class="ns-btn ns-btn-primary">Save</button>
  <button class="ns-btn">Cancel</button>
</div>

<div class="ns-filter-bar">
  <select><option>All Status</option></select>
  <input type="date">
  <button class="ns-btn ns-btn-primary ns-btn-sm">Apply</button>
  <button class="ns-btn ns-btn-ghost ns-btn-sm">Clear</button>
</div>
<div class="ns-table-wrap">
  <table class="ns-table">
    <thead><tr>
      <th class="col-checkbox"><input type="checkbox"></th>
      <th>Doc #</th><th>Date</th><th>Entity</th>
      <th style="text-align:right;">Amount</th><th>Status</th><th>Actions</th>
    </tr></thead>
    <tbody><tr>
      <td class="col-checkbox"><input type="checkbox"></td>
      <td><span class="cell-link">SO-XXXXX</span></td>
      <td class="cell-mono">05/20/2026</td>
      <td>Customer Name</td>
      <td class="cell-currency">$0.00</td>
      <td><span class="ns-badge ns-badge-pending">Pending</span></td>
      <td><button class="ns-btn ns-btn-ghost ns-btn-sm">View</button></td>
    </tr></tbody>
  </table>
</div>

<div class="ns-portlet">
  <div class="ns-portlet-header">
    <span class="ns-portlet-title">Portlet Title</span>
    <div class="ns-portlet-actions">
      <button class="ns-btn ns-btn-ghost ns-btn-sm">&#9881;</button>
    </div>
  </div>
  <div class="ns-portlet-body">
    <div class="ns-kpi">
      <div class="ns-kpi-label">Metric Name</div>
      <div class="ns-kpi-value">142</div>
      <div class="ns-kpi-trend ns-up">+8 today</div>
    </div>
  </div>
</div>

<div class="ns-approval-chain">
  <div class="ns-approval-step completed">
    <div class="ns-approval-node">&#10003;</div>
    <div class="ns-approval-name">Submitted</div>
    <div class="ns-approval-role">Requester</div>
  </div>
  <div class="ns-approval-step current">
    <div class="ns-approval-node">2</div>
    <div class="ns-approval-name">Level 1</div>
    <div class="ns-approval-role">Manager</div>
  </div>
  <div class="ns-approval-step pending">
    <div class="ns-approval-node">3</div>
    <div class="ns-approval-name">Final</div>
    <div class="ns-approval-role">VP</div>
  </div>
</div>

<div class="ns-print-template">
  <div class="ns-print-header">
    <div class="ns-print-co">
      <div class="ns-print-co-name">GLOBAL FOOD SOLUTIONS, INC.</div>
      <div class="ns-print-co-addr">131 Heartland Blvd, Edgewood, NY 11717</div>
    </div>
    <div class="ns-print-doc-type">
      <div class="ns-print-doc-type-name">[DOC TYPE]</div>
      <div class="ns-print-doc-type-id">#[ID]</div>
    </div>
  </div>
  <div class="ns-print-addr-row">
    <div class="ns-print-addr-box">
      <div class="ns-print-addr-label">Bill To</div>
      <div>[Address]</div>
    </div>
    <div class="ns-print-addr-box">
      <div class="ns-print-addr-label">Ship To</div>
      <div>[Address]</div>
    </div>
  </div>
  <div class="ns-print-footer">
    Global Food Solutions, Inc. | 131 Heartland Blvd, Edgewood, NY 11717
  </div>
</div>

<div class="ns-email-template">
  <div class="ns-email-header">
    <div class="ns-email-logo">&#9632; GLOBAL FOOD SOLUTIONS</div>
  </div>
  <div class="ns-email-body">
    <p>Dear [Name],</p>
    <p>[Message body]</p>
    <a href="#" class="ns-email-cta">[CTA Text]</a>
  </div>
  <div class="ns-email-footer">
    Global Food Solutions, Inc.<br>
    131 Heartland Blvd, Edgewood, NY 11717<br>
    (877) 728-5550 | globalfoodsolutions.co
  </div>
</div>

/**
 * @NApiVersion 2.1
 * @NScriptType ClientScript
 */
define(['N/currentRecord', 'N/ui/dialog'], (cr, dialog) => {
  function saveRecord() {
    const rec = cr.get();
    const required = ['entity', 'trandate', 'department'];
    for (const fld of required) {
      if (!rec.getValue({ fieldId: fld })) {
        dialog.alert({ title: 'Required', message: fld + ' is required.' });
        return false;
      }
    }
    return true;
  }
  return { saveRecord };
});

Type: Sales Order
Filters:
  Status = Pending Fulfillment, Partially Fulfilled, Pending Billing
  Date >= beginning of this month
  Main Line = F
Columns:
  Document Number | Date | Entity | Item | Quantity | Amount | Status | Memo
Sort: Entity (A-Z), Date (newest)
Summary: Group by Entity, SUM Amount

SuiteQL Equivalent:
SELECT BUILTIN.DF(t.entity) AS "Customer", COUNT(*) AS "Orders",
  SUM(t.foreigntotal) AS "Total"
FROM transaction t
WHERE t.type = 'SalesOrd'
  AND t.status IN ('SalesOrd:B','SalesOrd:D','SalesOrd:C')
GROUP BY BUILTIN.DF(t.entity)
ORDER BY "Total" DESC

Type: Invoice
Filters:
  Status = Open
  Amount Remaining > 0
  Main Line = T
Columns:
  Entity | Document Number | Due Date | Amount Remaining | Days Overdue
  Formula (Numeric): CASE WHEN {daysoverdue} <= 30 THEN {amountremaining} ELSE 0 END  -- "1-30"
  Formula (Numeric): CASE WHEN {daysoverdue} BETWEEN 31 AND 60 THEN {amountremaining} ELSE 0 END  -- "31-60"
  Formula (Numeric): CASE WHEN {daysoverdue} BETWEEN 61 AND 90 THEN {amountremaining} ELSE 0 END  -- "61-90"
  Formula (Numeric): CASE WHEN {daysoverdue} > 90 THEN {amountremaining} ELSE 0 END  -- "90+"
Sort: Days Overdue (descending)
Summary: Group by Entity, SUM all amount columns

Type: Item
Filters:
  Is Inactive = F
  Type = Inventory Item, Assembly
  Formula (Numeric): {quantityavailable} < {reorderpoint}  -- equals 1
Columns:
  Name | Display Name | Quantity Available | Quantity On Hand | Quantity On Order
  Reorder Point | Preferred Stock Level
  Formula (Numeric): {reorderpoint} - {quantityavailable}  -- "Shortfall"
Sort: Shortfall (descending)
Summary: None (detail view)

Type: Purchase Order
Filters:
  Status = Pending Receipt, Partially Received
  Main Line = T
Columns:
  Document Number | Date | Vendor | Total | Expected Receipt Date
  Formula (Numeric): {expectedreceiptdate} - TODAY  -- "Days Until Expected"
  Memo
Sort: Expected Receipt Date (ascending)
Summary: Group by Vendor, COUNT, SUM Total

Type: Sales Order
Filters:
  Date = this year
  Main Line = F
  Status != Closed, Cancelled
Columns:
  custbody_gfs_brand (Group) | Amount (SUM) | Quantity (SUM)
  Formula (%): SUM({amount}) / (SELECT SUM({amount}) FROM ...) * 100  -- "% of Total"
Sort: Amount SUM (descending)
Summary: Group by Brand, SUM Amount

Type: Invoice
Filters:
  Date = this year | Status = Open, Paid In Full | Main Line = T
Columns:
  Entity (Group) | Amount (SUM) | Document Number (COUNT)
  Formula (Numeric): ROUND(SUM({amount}) / [total revenue] * 100, 1)  -- "% Share"
Sort: Amount SUM (descending)
Max Results: 20

Type: Item
Filters:
  Is Inactive = F | Type = Inventory Item
  Formula (Date): NVL({lastquantityavailablechange}, TO_DATE('2000-01-01','YYYY-MM-DD'))
    before daysago90
  Quantity Available > 0
Columns:
  Name | Display Name | Quantity On Hand | Last Sale Date | Location | Cost | Total Value
Sort: Total Value (descending)

Type: Customer
Filters:
  Credit Hold = On | Is Inactive = F
Columns:
  Company Name | Balance | Overdue Balance | Credit Limit
  Formula (Numeric): {balance} - {creditlimit}  -- "Over Limit By"
  Sales Rep | Phone | Email
Sort: Overdue Balance (descending)

Type: Work Order
Filters:
  Status = Planned, Released, In Process
Columns:
  Document Number | Assembly Item | Quantity | Location | Status | Start Date
  custbody_gfs_priority
Sort: Location (A-Z), Start Date (ascending)
Summary: Group by Location, COUNT

Type: Invoice
Filters:
  Date = this year | Main Line = F | Type = CustInvc
Columns:
  Item (Group) | Quantity (SUM) | Amount (SUM) | Cost (SUM)
  Formula (Currency): SUM({amount}) - SUM({costestimate})  -- "Gross Profit"
  Formula (%): ROUND((SUM({amount}) - SUM({costestimate})) / NULLIF(SUM({amount}),0) * 100, 1)  -- "Margin %"
Sort: Margin % (ascending) -- show lowest margins first

Type: Inventory Number
Filters:
  Inventory Number contains [search input]
Columns:
  Inventory Number | Item | Quantity Available | Quantity On Hand
  Status | Expiration Date | custrecord_gfs_vendor_lot | custrecord_gfs_received_date
Join:
  Transaction (via inventoryDetail) -> tranid, trandate, type, entity
Sort: Received Date (descending)

Type: Custom Record: Temperature Log (custrecord_gfs_temp_log)
Filters:
  custrecord_gfs_temp_status = Exception
  Date = last 7 days
Columns:
  Date | Location | Item | Lot # | Recorded Temp | Required Range
  Deviation | Logged By | Action Taken | Related Transaction
Sort: Date (descending), Deviation (descending)

Type: Item Fulfillment
Filters:
  Ship Date = this quarter | Status = Shipped
Columns:
  Entity (Group) | COUNT (total shipments)
  Formula (Numeric): SUM(CASE WHEN {shipdate} <= {custbody_gfs_promised_date} THEN 1 ELSE 0 END)  -- "On Time"
  Formula (%): On Time / Total * 100  -- "OTD %"
  Formula (Numeric): AVG({shipdate} - {custbody_gfs_promised_date})  -- "Avg Days Late"
Sort: OTD % (ascending) -- show worst performers first

Type: Purchase Order
Filters:
  Date = this year | Status = Fully Billed, Closed | Main Line = T
Columns:
  Vendor (Group) | COUNT POs | SUM Total
  Related Item Receipts -> AVG(Receipt Date - Expected Date)  -- "Avg Days Variance"
  Formula (%): On-Time % (receipts on or before expected date)
  Quality Score (from custrecord_gfs_vendor_score join)
Sort: Total Spend (descending)

Type: Invoice
Filters:
  Date = this month | Status = Paid In Full | Main Line = T
Columns:
  Sales Rep (Group) | Entity (Group) | Amount (SUM)
  Formula (Currency): SUM({amount}) * 0.03  -- "Commission @ 3%"
  Formula (Currency): SUM({amount}) * CASE
    WHEN SUM({amount}) > 500000 THEN 0.04
    WHEN SUM({amount}) > 250000 THEN 0.035
    ELSE 0.03 END  -- "Tiered Commission"
Sort: Sales Rep, Amount (descending)

function onRequest(context) {
  const params = context.request.parameters;
  const page = params.page || 'dashboard';
  const recordId = params.id;
  const action = params.action; // view, edit, delete

  // Route to appropriate handler
  switch (page) {
    case 'dashboard': return renderDashboard(context);
    case 'record':    return renderRecord(context, recordId, action);
    case 'search':    return renderSearch(context, params);
    case 'export':    return handleExport(context, params);
    default:          return render404(context);
  }
}

// Generate internal Suitelet URL with parameters
const url = require('N/url');
const suiteletUrl = url.resolveScript({
  scriptId: 'customscript_gfs_ops',
  deploymentId: 'customdeploy_gfs_ops',
  params: { page: 'record', id: 12345, action: 'view' }
});

// REQUEST (POST /restlet?script=xxx&deploy=xxx)
{
  "action": "getRecord",           // Required: operation name
  "recordType": "salesorder",      // Required: NS record type
  "recordId": 12345,               // Required for get/update/delete
  "fields": {                      // Required for create/update
    "entity": 1001,
    "trandate": "2026-05-20",
    "department": 1,
    "custbody_gfs_brand": "GFS",
    "custbody_gfs_temp_zone": 1
  },
  "lines": [                       // Optional: sublist lines
    { "item": 4420, "quantity": 12, "rate": 2847.50 }
  ],
  "options": {                     // Optional: pagination, filters
    "page": 1,
    "pageSize": 50,
    "sortBy": "trandate",
    "sortDir": "DESC"
  }
}

// SUCCESS RESPONSE
{
  "success": true,
  "data": {
    "id": 12345,
    "tranid": "SO-24891",
    "entity": { "id": 1001, "name": "Driscoll Foods" },
    "total": 46642.49,
    "status": { "id": "SalesOrd:B", "name": "Pending Fulfillment" }
  },
  "meta": {
    "timestamp": "2026-05-20T14:30:00Z",
    "governance": { "used": 15, "remaining": 4985 },
    "pagination": { "page": 1, "pageSize": 50, "totalResults": 247, "totalPages": 5 }
  }
}

// ERROR RESPONSE
{
  "success": false,
  "error": {
    "code": "RECORD_NOT_FOUND",
    "message": "Sales Order 99999 does not exist or you do not have permission.",
    "details": { "type": "salesorder", "id": 99999 }
  },
  "meta": {
    "timestamp": "2026-05-20T14:30:00Z"
  }
}

function get(context) {
  const page = parseInt(context.page) || 1;
  const pageSize = Math.min(parseInt(context.pageSize) || 50, 100); // Max 100
  const start = (page - 1) * pageSize;

  const srch = search.create({
    type: 'salesorder',
    filters: [['status','anyof','SalesOrd:B']],
    columns: ['tranid','entity','total','trandate']
  });

  const totalCount = srch.runPaged({ pageSize: 1000 }).count;
  const results = srch.run().getRange({ start, end: start + pageSize });

  return {
    success: true,
    data: results.map(r => ({
      id: r.id,
      tranid: r.getValue('tranid'),
      entity: r.getText('entity'),
      total: r.getValue('total'),
      date: r.getValue('trandate')
    })),
    meta: {
      pagination: {
        page, pageSize,
        totalResults: totalCount,
        totalPages: Math.ceil(totalCount / pageSize),
        hasNext: start + pageSize < totalCount,
        hasPrev: page > 1
      }
    }
  };
}

function post(context) {
  const { action, records } = context;
  if (action !== 'batchUpdate' || !Array.isArray(records)) {
    return { success: false, error: { code: 'INVALID_REQUEST', message: 'Expected batchUpdate action with records array' }};
  }

  const results = [];
  const script = runtime.getCurrentScript();

  for (const rec of records) {
    // Governance check before each operation
    if (script.getRemainingUsage() < 50) {
      results.push({ id: rec.id, success: false, error: 'GOVERNANCE_LIMIT' });
      break;
    }

    try {
      record.submitFields({
        type: rec.type,
        id: rec.id,
        values: rec.fields
      });
      results.push({ id: rec.id, success: true });
    } catch (e) {
      results.push({ id: rec.id, success: false, error: e.message });
    }
  }

  return {
    success: true,
    data: { processed: results.length, succeeded: results.filter(r => r.success).length, results },
    meta: { governance: { remaining: script.getRemainingUsage() }}
  };
}

<?xml version="1.0"?>
<!DOCTYPE pdf PUBLIC "-//big.faceless.org//report" "report-1.1.dtd">
<pdf>
<head>
  <style>
    body { font-family: sans-serif; font-size: 10pt; color: #092F64; }
    .header { border-top: 3px solid #092F64; padding: 12px 0; }
    .co-name { font-size: 14pt; font-weight: bold; letter-spacing: 0.5px; }
    table.items { width: 100%; border-collapse: collapse; margin: 12px 0; }
    table.items th { background: #092F64; color: #fff; padding: 6px 8px;
      font-size: 8pt; text-transform: uppercase; text-align: left; }
    table.items td { padding: 6px 8px; border-bottom: 1px solid #D9E1EA; }
    .total-row { background: #092F64; color: #fff; font-weight: bold; }
  </style>
</head>
<body>
  <div class="header">
    <table width="100%"><tr>
      <td><span class="co-name">GLOBAL FOOD SOLUTIONS, INC.</span><br/>
        131 Heartland Blvd, Edgewood, NY 11717<br/>(877) 728-5550</td>
      <td align="right"><span style="font-size:18pt;font-weight:bold">INVOICE</span><br/>
        #${record.tranid}</td>
    </tr></table>
  </div>

  <table width="100%"><tr>
    <td width="50%" style="border:1px solid #D9E1EA;padding:8px">
      <b style="font-size:8pt;text-transform:uppercase">Bill To</b><br/>
      ${record.billaddress}</td>
    <td width="50%" style="border:1px solid #D9E1EA;padding:8px">
      <b style="font-size:8pt;text-transform:uppercase">Ship To</b><br/>
      ${record.shipaddress}</td>
  </tr></table>

  <table><tr>
    <td>Date: ${record.trandate?string("MM/dd/yyyy")}</td>
    <td>Due: ${record.duedate?string("MM/dd/yyyy")}</td>
    <td>Terms: ${record.terms}</td>
    <td>Rep: ${record.salesrep}</td>
  </tr></table>

  <table class="items">
    <tr><th>Item</th><th>Description</th><th align="right">Qty</th>
      <th align="right">Rate</th><th align="right">Amount</th></tr>
    <#list record.item as line>
    <tr>
      <td>${line.item}</td>
      <td>${line.description}</td>
      <td align="right">${line.quantity}</td>
      <td align="right">${line.rate?string.currency}</td>
      <td align="right">${line.amount?string.currency}</td>
    </tr>
    </#list>
  </table>

  <table align="right" width="200px">
    <tr><td>Subtotal</td><td align="right">${record.subtotal?string.currency}</td></tr>
    <tr><td>Tax</td><td align="right">${record.taxtotal?string.currency}</td></tr>
    <tr><td>Shipping</td><td align="right">${record.shippingcost?string.currency}</td></tr>
    <tr class="total-row"><td>Total Due</td><td align="right">${record.total?string.currency}</td></tr>
  </table>

  <#if record.total > 50000>
  <p style="color:#DC2626;font-weight:bold">NOTE: This invoice exceeds $50,000. Wire transfer preferred.</p>
  </#if>
</body>
</pdf>

<!-- Key section: Line items with lot tracking -->
<table class="items">
  <tr><th>Item</th><th>Description</th><th align="right">Ordered</th>
    <th align="right">Shipped</th><th>Lot #</th><th>Expiry</th><th>Temp</th></tr>
  <#list record.item as line>
  <tr>
    <td>${line.item}</td>
    <td>${line.description}</td>
    <td align="right">${line.quantityordered!""}</td>
    <td align="right">${line.quantity}</td>
    <td>${line.custcol_gfs_lot!""}</td>
    <td><#if line.custcol_gfs_expiry?has_content>${line.custcol_gfs_expiry?string("MM/dd/yyyy")}</#if></td>
    <td><#if line.custcol_gfs_temp?has_content>${line.custcol_gfs_temp}F</#if></td>
  </tr>
  </#list>
</table>

<!-- Cold chain compliance note -->
<#if record.custbody_gfs_temp_zone?has_content>
  <#if record.custbody_gfs_temp_zone == "1">
    <p style="border:1px solid #0F766E;background:#F0FDF4;padding:6px;font-size:9pt">
      COLD CHAIN: Maintain 34-38F. Do not break cold chain. Inspect upon delivery.</p>
  <#elseif record.custbody_gfs_temp_zone == "2">
    <p style="border:1px solid #092F64;background:#E9F5FF;padding:6px;font-size:9pt">
      FROZEN: Maintain -10 to 0F. Do not refreeze if thawed.</p>
  </#if>
</#if>

<!-- Signature block -->
<table width="100%" style="margin-top:20px"><tr>
  <td width="25%">Received by: ____________</td>
  <td width="25%">Date: ____________</td>
  <td width="25%">Condition: ____________</td>
  <td width="25%">Temp at delivery: ____F</td>
</tr></table>

<!-- Show credit memo notice -->
<#if record.type == "creditmemo">
  <p style="color:#DC2626;font-weight:bold">CREDIT MEMO - This document reduces your account balance.</p>
</#if>

<!-- International shipping notice -->
<#if record.shipcountry != "US">
  <p>INTERNATIONAL SHIPMENT - Additional customs documentation required.
  HS Code and country of origin included on commercial invoice.</p>
</#if>

<!-- Multi-currency handling -->
<#if record.currency != "1">
  <p>Currency: ${record.currency} | Exchange Rate: ${record.exchangerate}
  | USD Equivalent: ${(record.total * record.exchangerate)?string.currency}</p>
</#if>

<!-- Null-safe field access -->
${record.memo!"No memo provided"}
${record.custbody_gfs_route!"Route not assigned"}
<#if record.otherrefnum?has_content>PO#: ${record.otherrefnum}</#if>

<!-- Line-level conditionals -->
<#list record.item as line>
  <tr style="<#if line.amount > 10000>font-weight:bold;background:#FFF7ED</#if>">
    <td>${line.item}</td>
    <td align="right">${line.amount?string.currency}</td>
    <td><#if line.custcol_gfs_lot?has_content>${line.custcol_gfs_lot}<#else>N/A</#if></td>
  </tr>
</#list>

<!-- Barcode generation -->
<barcode codetype="code128" showtext="true" value="${record.tranid}"/>

<macrolist>
  <macro id="nlheader">
    <table width="100%"><tr>
      <td style="font-size:8pt;color:#092F64">GLOBAL FOOD SOLUTIONS, INC.</td>
      <td align="right" style="font-size:8pt;color:#6B7280">
        ${record.type?upper_case} #${record.tranid} | Page <pagenumber/> of <totalpages/>
      </td>
    </tr></table>
    <hr style="border-top:1px solid #D9E1EA" />
  </macro>

  <macro id="nlfooter">
    <hr style="border-top:1px solid #D9E1EA" />
    <table width="100%"><tr>
      <td style="font-size:7pt;color:#6B7280">
        Global Food Solutions, Inc. | 131 Heartland Blvd, Edgewood, NY 11717 | (877) 728-5550
      </td>
      <td align="right" style="font-size:7pt;color:#6B7280">
        Printed: ${.now?string("MM/dd/yyyy HH:mm")}
      </td>
    </tr></table>
  </macro>
</macrolist>

/**
 * @NApiVersion 2.1
 * @NScriptType UserEventScript
 */
define(['N/runtime', 'N/url'], (runtime, url) => {

  function beforeLoad(context) {
    if (context.type !== context.UserEventType.VIEW) return;
    const form = context.form;
    const rec = context.newRecord;
    const status = rec.getValue('approvalstatus');

    // Show approve/reject buttons only for current approver
    const currentUser = runtime.getCurrentUser().id;
    const nextApprover = rec.getValue('nextapprover');

    if (status === '1' && currentUser === nextApprover) {
      form.addButton({
        id: 'custpage_approve',
        label: 'Approve',
        functionName: 'gfsApprove'
      });
      form.addButton({
        id: 'custpage_reject',
        label: 'Reject',
        functionName: 'gfsReject'
      });
    }

    // Always show audit trail button
    const auditUrl = url.resolveScript({
      scriptId: 'customscript_gfs_audit',
      deploymentId: 'customdeploy_gfs_audit',
      params: { recordId: rec.id, recordType: rec.type }
    });
    form.addButton({
      id: 'custpage_audit',
      label: 'View Audit Trail',
      functionName: 'window.open("' + auditUrl + '")'
    });

    form.clientScriptModulePath = './gfs_cs_approval.js';
  }

  return { beforeLoad };
});

/**
 * @NApiVersion 2.1
 * @NScriptType ClientScript
 */
define(['N/currentRecord', 'N/ui/dialog', 'N/ui/message'], (cr, dialog, message) => {

  function pageInit(context) {
    // Show warning banner if record is on credit hold
    const rec = cr.get();
    if (rec.getValue('custbody_gfs_credit_hold')) {
      message.create({
        type: message.Type.WARNING,
        title: 'Credit Hold',
        message: 'This customer is on credit hold. Order will not be fulfilled until released.'
      }).show();
    }
  }

  function saveRecord(context) {
    const rec = cr.get();
    const errors = [];

    // Required field validation
    if (!rec.getValue('entity')) errors.push('Customer is required.');
    if (!rec.getValue('trandate')) errors.push('Date is required.');
    if (!rec.getValue('department')) errors.push('Department is required.');
    if (!rec.getValue('custbody_gfs_temp_zone')) errors.push('Temperature Zone is required.');

    // Line item validation
    const lineCount = rec.getLineCount({ sublistId: 'item' });
    if (lineCount === 0) errors.push('At least one line item is required.');

    for (let i = 0; i < lineCount; i++) {
      const qty = rec.getSublistValue({ sublistId: 'item', fieldId: 'quantity', line: i });
      const rate = rec.getSublistValue({ sublistId: 'item', fieldId: 'rate', line: i });
      if (qty <= 0) errors.push('Line ' + (i + 1) + ': Quantity must be greater than 0.');
      if (rate <= 0) errors.push('Line ' + (i + 1) + ': Rate must be greater than 0.');
    }

    // Business rule: minimum order value
    const total = rec.getValue('total');
    if (total < 100) errors.push('Minimum order value is $100.00.');

    if (errors.length) {
      dialog.alert({ title: 'Validation Errors', message: errors.join('\n') });
      return false;
    }
    return true;
  }

  function fieldChanged(context) {
    const rec = cr.get();
    if (context.fieldId === 'entity') {
      // Auto-populate terms, rep, and delivery window from customer defaults
      const custId = rec.getValue('entity');
      if (custId) {
        // Use lookupFields in a real implementation
        console.log('Customer changed to: ' + custId);
      }
    }
    if (context.sublistId === 'item' &&
        (context.fieldId === 'quantity' || context.fieldId === 'rate')) {
      const qty = rec.getCurrentSublistValue({ sublistId: 'item', fieldId: 'quantity' }) || 0;
      const rate = rec.getCurrentSublistValue({ sublistId: 'item', fieldId: 'rate' }) || 0;
      rec.setCurrentSublistValue({ sublistId: 'item', fieldId: 'amount', value: qty * rate });
    }
  }

  function validateLine(context) {
    if (context.sublistId !== 'item') return true;
    const rec = cr.get();
    const item = rec.getCurrentSublistValue({ sublistId: 'item', fieldId: 'item' });
    if (!item) {
      dialog.alert({ title: 'Validation', message: 'Please select an item before adding the line.' });
      return false;
    }
    return true;
  }

  function sublistChanged(context) {
    if (context.sublistId === 'item') {
      // Recalculate totals, update UI elements
      const rec = cr.get();
      const lineCount = rec.getLineCount({ sublistId: 'item' });
      console.log('Sublist changed. Lines: ' + lineCount);
    }
  }

  return { pageInit, saveRecord, fieldChanged, validateLine, sublistChanged };
});

function safeRecordOperation(recordType, recordId, operation) {
  try {
    const rec = record.load({ type: recordType, id: recordId, isDynamic: true });
    const result = operation(rec);
    const savedId = rec.save({ enableSourcing: true, ignoreMandatoryFields: false });
    log.audit('GFS-Op', 'Success: ' + recordType + ' ' + savedId);
    return { success: true, id: savedId, data: result };

  } catch (e) {
    // Categorize errors for appropriate handling
    if (e.name === 'RCRD_HAS_BEEN_CHANGED') {
      log.audit('GFS-Op', 'Conflict on ' + recordId + '. Retrying...');
      // Retry once after conflict
      return safeRecordOperation(recordType, recordId, operation);
    }

    if (e.name === 'SSS_USAGE_LIMIT_EXCEEDED') {
      log.error('GFS-Op', 'Governance exceeded. Remaining: ' +
        runtime.getCurrentScript().getRemainingUsage());
      return { success: false, error: 'GOVERNANCE_LIMIT', message: 'Script governance limit reached.' };
    }

    if (e.name === 'RCRD_DSNT_EXIST') {
      log.audit('GFS-Op', 'Record not found: ' + recordType + ' ' + recordId);
      return { success: false, error: 'NOT_FOUND', message: 'Record does not exist.' };
    }

    // Unknown error -- log full details
    log.error('GFS-Op', JSON.stringify({
      name: e.name, message: e.message, stack: e.stack,
      recordType, recordId
    }));
    return { success: false, error: e.name, message: e.message };
  }
}

// 1. Inline field error (highlight field + message below)
function showFieldError(fieldId, msg) {
  const field = document.getElementById(fieldId);
  if (field) {
    field.classList.add('ns-input-error');
    const errEl = document.getElementById('err-' + fieldId);
    if (errEl) { errEl.textContent = msg; errEl.style.display = 'block'; }
  }
}

// 2. Banner warning (top of form, dismissible)
// Uses N/ui/message module in SuiteScript
const banner = message.create({
  type: message.Type.ERROR,
  title: 'Save Failed',
  message: 'Unable to save record. ' + errorDetails,
  duration: 10000  // auto-dismiss after 10s
});
banner.show();

// 3. Modal alert (blocking, requires user action)
dialog.alert({
  title: 'Critical Error',
  message: 'This operation cannot be completed.\n\n' + errorDetails
}).then(() => {
  // User clicked OK -- redirect or reload
  window.location.reload();
});

// 4. Toast notification (non-blocking, auto-dismiss)
// Using GFS custom toast (from this design system)
nsShowToast('Record saved successfully.', 'ns-toast-success');
nsShowToast('Unable to save. Try again.', 'ns-toast-error');
nsShowToast('Unsaved changes detected.', 'ns-toast-warning');