oms/backend/app/model/waybillFetchRecord.js
liufumingren 4c2cfe1793 修复取号回调的订单级幂等与重放
Co-authored-by: Copilot <223556219+Copilot@users.noreply.github.com>
2026-11-17 17:16:14 +08:00

54 lines
3.1 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';
/**
* 取号明细记录模型,对应 waybill_fetch_records。
*
* 每次实际调用平台取号都写一条,保存打单平台原始返回、完整结果及包裹序号。
* 已有运单号的幂等重放不新增平台取号记录。
* 仅做留痕,不参与业务状态流转(取号与订单表暂不关联)。
* @param {Egg.Application} app egg application
* @return {object} waybillFetchRecord model
*/
module.exports = app => {
const { BIGINT, STRING, INTEGER, TINYINT, TEXT, DATE } = app.Sequelize;
const WaybillFetchRecord = app.model.define('waybill_fetch_record', {
id: { type: BIGINT.UNSIGNED, primaryKey: true, autoIncrement: true, comment: '主键' },
principal_id: { type: BIGINT.UNSIGNED, allowNull: false, comment: '主体ID(来自 app_key)' },
warehouse_id: { type: BIGINT.UNSIGNED, comment: '仓库ID(来自 app_key)' },
request_id: { type: STRING(100), comment: '调用方 request_id' },
delivery_order_code: { type: STRING(100), allowNull: false, comment: 'OMS 发货单号' },
express_code: { type: STRING(50), comment: '本次取号的快递编码' },
package_index: { type: INTEGER.UNSIGNED, comment: '包裹序号(0 基);历史记录可能为空' },
platform_code: { type: STRING(50), comment: '订单来源平台编码' },
account_id: { type: BIGINT.UNSIGNED, comment: '外部打单账号ID' },
template_id: { type: STRING(100), comment: '面单模板ID' },
status: { type: TINYINT, allowNull: false, defaultValue: 0, comment: '状态:1成功 0失败' },
waybill_source: { type: STRING(20), comment: '运单号来源:express_print / platform_last' },
waybill_code: { type: STRING(100), comment: '主运单号' },
waybill_codes: { type: TEXT, comment: '全部运单号(JSON 数组)' },
result_data: { type: TEXT('medium'), comment: '完整的逐单返回结果(JSON)' },
printinfo: { type: TEXT('medium'), comment: '面单打印数据(平台原样返回)' },
signature: { type: TEXT('medium'), comment: '面单签名(平台原样返回)' },
print_history_ids: {
type: TEXT,
comment: '打印记录(平台 PrintHistoryIds,JSON 数组:id/pid/waybill_code/batch_index),重打/作废用',
},
cai_niao_auth_info_id: {
type: BIGINT.UNSIGNED,
comment: '菜鸟授权网点ID(=店铺唯一标识,重取打印数据时按它+运单号定位)',
},
dbname: { type: STRING(100), comment: '实际命中的打单平台分区(重取打印数据要带同一个 dbname)' },
platform_host: { type: STRING(100), comment: '实际命中的订单域名(重取打印数据要发到同一个域名)' },
raw_response: { type: TEXT('medium'), comment: '平台原始返回(JSON)' },
error_message: { type: TEXT, comment: '失败原因' },
created_at: { type: DATE, comment: '创建时间' },
updated_at: { type: DATE, comment: '更新时间' },
}, {
tableName: 'waybill_fetch_records',
comment: '取号明细记录(平台原始返回留痕)',
});
return WaybillFetchRecord;
};