54 lines
3.1 KiB
JavaScript
54 lines
3.1 KiB
JavaScript
'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;
|
||
};
|