WMS_MAIN/test/app/service/systemMethods/stock.warehouse.import.test.js

367 lines
12 KiB
JavaScript
Raw Permalink Blame History

This file contains ambiguous Unicode characters

This file contains Unicode characters that might be confused with other characters. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.

'use strict';
const assert = require('node:assert/strict');
const WarehouseMethodService = require('../../../../app/service/systemMethods/stock/warehouse');
function createHarness() {
const calls = {
createArgs: [],
saveArgs: [],
};
const ctx = {
user: {
store_id: 100000,
},
app: {
config: {
jwt: {},
},
},
service: {
systems: {
stockStore: {
async createWarehouseStock(data) {
calls.createArgs.push(data);
return {
...data,
id: `create-${calls.createArgs.length}`,
};
},
async saveWarehouseStock(data) {
calls.saveArgs.push(data);
return {
id: data.id,
...data,
};
},
},
},
},
};
return {
service: new WarehouseMethodService(ctx),
calls,
ctx,
};
}
describe('test/app/service/systemMethods/stock.warehouse.import.test.js', () => {
it('should import direct array rows and route create/update by SKU with normalized fields', async () => {
const { service, calls, ctx } = createHarness();
const result = await service.import([
{
itemCode: 'SKU-CREATE',
goodsCode: 'G-CREATE',
skuProperty: '规格A',
stockUnit: '件',
brandName: '品牌A',
grossWeight: 1.2,
tagPrice: 11,
retailPrice: 22,
},
{
SKU: '99',
item_code: 'SKU-UPDATE',
goods_code: 'G-UPDATE',
sku_property: '规格B',
stock_unit: '箱',
brand_name: '品牌B',
gross_weight: 2.3,
tag_price: 33,
retail_price: 44,
},
]);
assert.equal(result.flag, 'success');
assert.equal(result.total_count, 2);
assert.equal(result.created_count, 1);
assert.equal(result.updated_count, 1);
assert.equal(result.fail_count, 0);
assert.deepEqual(result.created_ids, [ 'create-1' ]);
assert.deepEqual(result.updated_ids, [ '99' ]);
assert.deepEqual(result.fail_items, []);
assert.equal(calls.createArgs.length, 1);
assert.equal(calls.saveArgs.length, 1);
assert.equal(calls.createArgs[0].store_id, ctx.user.store_id);
assert.equal(calls.createArgs[0].item_code, 'SKU-CREATE');
assert.equal(calls.createArgs[0].goods_code, 'G-CREATE');
assert.equal(calls.createArgs[0].item_name, 'SKU-CREATE');
assert.equal(calls.createArgs[0].sku_property, '规格A');
assert.equal(calls.createArgs[0].stock_unit, '件');
assert.equal(calls.createArgs[0].brand_name, '品牌A');
assert.equal(calls.createArgs[0].gross_weight, 1.2);
assert.equal(calls.createArgs[0].tag_price, 11);
assert.equal(calls.createArgs[0].retail_price, 22);
assert.equal(calls.saveArgs[0].id, '99');
assert.equal(calls.saveArgs[0].store_id, ctx.user.store_id);
assert.equal(calls.saveArgs[0].item_code, 'SKU-UPDATE');
assert.equal(calls.saveArgs[0].goods_code, 'G-UPDATE');
assert.equal(calls.saveArgs[0].item_name, 'SKU-UPDATE');
assert.equal(calls.saveArgs[0].sku_property, '规格B');
assert.equal(calls.saveArgs[0].stock_unit, '箱');
assert.equal(calls.saveArgs[0].brand_name, '品牌B');
assert.equal(calls.saveArgs[0].gross_weight, 2.3);
assert.equal(calls.saveArgs[0].tag_price, 33);
assert.equal(calls.saveArgs[0].retail_price, 44);
});
it('should update by stock_id and map cargo_code to goods_code', async () => {
const { service, calls, ctx } = createHarness();
const result = await service.import([
{
stock_id: '321',
cargo_code: 'CARGO-321',
item_code: 'ITEM-321',
},
]);
assert.equal(result.flag, 'success');
assert.equal(result.total_count, 1);
assert.equal(result.updated_count, 1);
assert.equal(result.created_count, 0);
assert.equal(result.fail_count, 0);
assert.deepEqual(result.updated_ids, [ '321' ]);
assert.deepEqual(result.created_ids, []);
assert.equal(calls.saveArgs.length, 1);
assert.equal(calls.createArgs.length, 0);
assert.equal(calls.saveArgs[0].store_id, ctx.user.store_id);
assert.equal(calls.saveArgs[0].id, '321');
assert.equal(calls.saveArgs[0].goods_code, 'CARGO-321');
assert.equal(calls.saveArgs[0].item_code, 'ITEM-321');
});
// ======================= _normalizeBarcodeField 单元测试 =======================
describe('_normalizeBarcodeField()', () => {
let service;
before(() => {
const h = createHarness();
service = h.service;
});
it('should return empty array for null', () => {
assert.deepEqual(service._normalizeBarcodeField(null), []);
});
it('should return empty array for undefined', () => {
assert.deepEqual(service._normalizeBarcodeField(undefined), []);
});
it('should return empty array for array input (arrays no longer supported)', () => {
const result = service._normalizeBarcodeField([ 'A', 'B', 'A', '', 'C ' ]);
assert.deepEqual(result, []);
});
it('should return empty array for array input with whitespace items', () => {
const result = service._normalizeBarcodeField([ ' 69123456 ', '69123456', ' 7890 ' ]);
assert.deepEqual(result, []);
});
it('should split comma-separated string', () => {
const result = service._normalizeBarcodeField('A,B,C');
assert.deepEqual(result, [ 'A', 'B', 'C' ]);
});
it('should trim and filter empty parts from comma string', () => {
const result = service._normalizeBarcodeField(' A ,, B , ,C ');
assert.deepEqual(result, [ 'A', 'B', 'C' ]);
});
it('should return empty array for empty string', () => {
assert.deepEqual(service._normalizeBarcodeField(''), []);
});
it('should return empty array for whitespace-only string', () => {
assert.deepEqual(service._normalizeBarcodeField(' '), []);
});
it('should return empty array for all-empty array', () => {
assert.deepEqual(service._normalizeBarcodeField([ '', '', '' ]), []);
});
it('should return single item for single-value string', () => {
assert.deepEqual(service._normalizeBarcodeField('6901234567890'), [ '6901234567890' ]);
});
it('should deduplicate comma-separated values', () => {
const result = service._normalizeBarcodeField('A,A,B');
assert.deepEqual(result, [ 'A', 'B' ]);
});
});
// ======================= _normalizeWarehouseImportRow 条码别名映射测试 =======================
describe('_normalizeWarehouseImportRow barcode alias mapping', () => {
let service;
before(() => {
const h = createHarness();
service = h.service;
});
it('should map 条码 to barcode', () => {
const row = { 条码: 'A,B' };
const normalized = service._normalizeWarehouseImportRow(row);
assert.deepEqual(normalized.barcode, [ 'A', 'B' ]);
});
it('should map bar_code to barcode', () => {
const row = { bar_code: 'X,Y' };
const normalized = service._normalizeWarehouseImportRow(row);
assert.deepEqual(normalized.barcode, [ 'X', 'Y' ]);
});
it('should map barCode to barcode', () => {
const row = { barCode: 'P,Q' };
const normalized = service._normalizeWarehouseImportRow(row);
assert.deepEqual(normalized.barcode, [ 'P', 'Q' ]);
});
it('should return empty array for barcodeList (array no longer supported)', () => {
const row = { barcodeList: [ 'M', 'N' ] };
const normalized = service._normalizeWarehouseImportRow(row);
assert.deepEqual(normalized.barcode, []);
});
it('should map barcode_list to barcode', () => {
const row = { barcode_list: 'R,S,T' };
const normalized = service._normalizeWarehouseImportRow(row);
assert.deepEqual(normalized.barcode, [ 'R', 'S', 'T' ]);
});
it('should return empty array for barcode pass-through (array no longer supported)', () => {
const row = { barcode: [ 'U', 'V' ] };
const normalized = service._normalizeWarehouseImportRow(row);
assert.deepEqual(normalized.barcode, []);
});
});
// ======================= 新建商品时传入 barcode =======================
describe('create with barcode', () => {
it('should pass barcode as array to createWarehouseStock (comma string input)', async () => {
const { service, calls, ctx } = createHarness();
await service.import([
{
item_code: 'NEW-SKU-1',
goods_code: 'G-NEW-1',
条码: '6901234567890,6901234567891',
},
]);
assert.equal(calls.createArgs.length, 1);
assert.equal(calls.saveArgs.length, 0);
assert.equal(calls.createArgs[0].item_code, 'NEW-SKU-1');
assert.equal(calls.createArgs[0].store_id, ctx.user.store_id);
assert.deepEqual(calls.createArgs[0].barcode, [ '6901234567890', '6901234567891' ]);
});
it('should pass barcode as array to createWarehouseStock (comma string input via bar_code)', async () => {
const { service, calls, ctx } = createHarness();
await service.import([
{
item_code: 'NEW-SKU-2',
goods_code: 'G-NEW-2',
bar_code: '6901234567892,6901234567893',
},
]);
assert.equal(calls.createArgs.length, 1);
assert.equal(calls.saveArgs.length, 0);
assert.equal(calls.createArgs[0].item_code, 'NEW-SKU-2');
assert.deepEqual(calls.createArgs[0].barcode, [ '6901234567892', '6901234567893' ]);
});
it('should pass empty barcode array to createWarehouseStock when no barcode provided', async () => {
const { service, calls } = createHarness();
await service.import([
{
item_code: 'NEW-SKU-3',
goods_code: 'G-NEW-3',
},
]);
assert.equal(calls.createArgs.length, 1);
assert.deepEqual(calls.createArgs[0].barcode, []);
});
});
// ======================= 更新商品时传入 barcode =======================
describe('update with barcode', () => {
it('should pass barcode to saveWarehouseStock when updating (comma string format)', async () => {
const { service, calls } = createHarness();
await service.import([
{
SKU: '500',
item_code: 'SKU-500',
barcode_list: 'BAR-1,BAR-2,BAR-3',
},
]);
assert.equal(calls.saveArgs.length, 1);
assert.equal(calls.createArgs.length, 0);
assert.equal(calls.saveArgs[0].id, '500');
assert.deepEqual(calls.saveArgs[0].barcode, [ 'BAR-1', 'BAR-2', 'BAR-3' ]);
});
it('should return empty barcode array when updating (array no longer supported)', async () => {
const { service, calls } = createHarness();
await service.import([
{
id: '501',
item_code: 'SKU-501',
barcodeList: [ 'BAR-A', 'BAR-B' ],
},
]);
assert.equal(calls.saveArgs.length, 1);
assert.equal(calls.saveArgs[0].id, '501');
assert.deepEqual(calls.saveArgs[0].barcode, []);
});
it('should pass empty barcode array to saveWarehouseStock when barcode is explicitly empty', async () => {
const { service, calls } = createHarness();
await service.import([
{
SKU: '502',
item_code: 'SKU-502',
barcode: [],
},
]);
assert.equal(calls.saveArgs.length, 1);
assert.equal(calls.saveArgs[0].id, '502');
assert.deepEqual(calls.saveArgs[0].barcode, []);
});
it('should pass empty barcode array to saveWarehouseStock when barcode is not provided at all', async () => {
const { service, calls } = createHarness();
await service.import([
{
SKU: '503',
item_code: 'SKU-503',
goods_code: 'G-503',
},
]);
assert.equal(calls.saveArgs.length, 1);
assert.equal(calls.saveArgs[0].id, '503');
// barcode 属性由 _normalizeWarehouseImportRow 始终设置,未传入时为空数组 []
// saveWarehouseStock 中通过 hasOwnProperty('barcode') 判定为 true,会清空旧条码
assert.equal(Object.prototype.hasOwnProperty.call(calls.saveArgs[0], 'barcode'), true);
assert.deepEqual(calls.saveArgs[0].barcode, []);
});
});
});