跳至內容
Astera Technology

把貨品數量行與費用行分開

依明列種類保存,不把費用當貨品數量。

下載完整個案資料及參考答案 ↓

來源格式與預期記錄

這是原創假設轉換例子。輸入限下列欄位的普通、無循環 JSON 形記錄,統一記錄格式及拒絕代碼由本例訂明。若換來源,先修改格式約定。

本例記錄有幣別字樣,entries 明列 item 或 charge。item 要有 sku 及非負安全整數 units;charge 要有 description 及非負安全整數 amountUnits。amountUnits 按來源已訂的記賬單位,不自動換成輔幣。分開 items、charges,欠資料的行拒絕。

可修改的假設轉換個案
個案輸入記錄(JSON)預期輸出(JSON)
貨品與費用項目分開{"currency":"HKD","entries":[{"kind":"item","sku":"A","units":2},{"kind":"charge","description":"delivery","amountUnits":10}]}{"ok":true,"value":{"currency":"HKD","items":[{"sku":"A","units":2}],"charges":[{"description":"delivery","amountUnits":10}]}}
拒絕費用缺值{"currency":"HKD","entries":[{"kind":"charge","description":"delivery"}]}{"ok":false,"error":"CHARGE_LINE"}
保留零件數貨品項目{"currency":"HKD","entries":[{"kind":"item","sku":"A","units":0}]}{"ok":true,"value":{"currency":"HKD","items":[{"sku":"A","units":0}],"charges":[]}}
下載可編輯 CSV ↓

在本機執行轉換

把完整例子以 JavaScript 模組在 Node.js 執行,內含純轉換函數、三個輸入及寫明的預期輸出,對不上便由斷言停止。拒絕個案回傳 ok=false 及代碼,不回傳半份統一記錄。

完整函數及可執行個案
import assert from 'node:assert/strict';

function itemChargeSplit(i){
  const fail=error=>({ok:false,error});if(!i||typeof i.currency!=='string'||!i.currency||!Array.isArray(i.entries))return fail('ENTRY_SHAPE');
  const items=[],charges=[];
  for(const e of i.entries){
    if(!e)return fail('ENTRY_KIND');
    if(e.kind==='item'){
      if(typeof e.sku!=='string'||!e.sku||!Number.isSafeInteger(e.units)||e.units<0)return fail('ITEM_LINE');items.push({sku:e.sku,units:e.units});
    }else if(e.kind==='charge'){
      if(typeof e.description!=='string'||!e.description||!Number.isSafeInteger(e.amountUnits)||e.amountUnits<0)return fail('CHARGE_LINE');charges.push({description:e.description,amountUnits:e.amountUnits});
    }else return fail('ENTRY_KIND');
  }
  return {ok:true,value:{currency:i.currency,items,charges}};
}

// Original synthetic cases; expected outputs are literal records.
const cases = [
  {
    "label": "Partition goods and charge entries",
    "input": {
      "currency": "HKD",
      "entries": [
        {
          "kind": "item",
          "sku": "A",
          "units": 2
        },
        {
          "kind": "charge",
          "description": "delivery",
          "amountUnits": 10
        }
      ]
    },
    "expected": {
      "ok": true,
      "value": {
        "currency": "HKD",
        "items": [
          {
            "sku": "A",
            "units": 2
          }
        ],
        "charges": [
          {
            "description": "delivery",
            "amountUnits": 10
          }
        ]
      }
    }
  },
  {
    "label": "Reject incomplete charge",
    "input": {
      "currency": "HKD",
      "entries": [
        {
          "kind": "charge",
          "description": "delivery"
        }
      ]
    },
    "expected": {
      "ok": false,
      "error": "CHARGE_LINE"
    }
  },
  {
    "label": "Preserve zero goods line",
    "input": {
      "currency": "HKD",
      "entries": [
        {
          "kind": "item",
          "sku": "A",
          "units": 0
        }
      ]
    },
    "expected": {
      "ok": true,
      "value": {
        "currency": "HKD",
        "items": [
          {
            "sku": "A",
            "units": 0
          }
        ],
        "charges": []
      }
    }
  }
];
for (const sample of cases) {
  const actual = itemChargeSplit(sample.input);
  assert.deepEqual(actual, sample.expected);
  console.log(sample.label, JSON.stringify(actual));
}
下載可執行例子 ↓

判清邊界個案

運送費 10 是否令貨品 A 多 10 件?

查看參考答案

不會。A 仍為 units=2;運送另列 charge,amountUnits=10,幣別字樣保留。此處沒有付款或改存貨。

相關資源

系統整合服務 →