oms/backend/database/orderMenu.js
liufumingren 6c03a20364 feat(backend): 订单状态分表、WMS 推送与归档
- 新增 order_index 索引表 + 6 张同构状态表(待审核/异常/委外中/配送/已作废/已取消)与历史表,
  订单 ID 全局唯一,状态由业务事务推动:审核、驳回、取消、作废、恢复、归档
- 明细表 order_status_items、收件人文本智能解析、批量切换仓库/店铺并刷新快照
- WMS deliveryorder.create 推送(单条/批量)、推送失败定时重试、订单归档定时任务
- 迁移:建表、旧发货单数据迁入新表、菜单合并与迁移记录清理
- routes / swagger contract 补充订单状态接口

Co-authored-by: Copilot <223556219+Copilot@users.noreply.github.com>
2026-10-30 23:06:18 +08:00

134 lines
4.4 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';
/**
* 「订单」菜单口径(唯一来源,供菜单迁移复用)。
*
* 口径(2026-09-15 按用户要求):订单按状态分表、页面按状态分视图展示,
* 该页面就是「订单」菜单的内容,不再单独挂「订单拆分」菜单。
*/
const ORDER_MENU = {
name: '订单',
path: '/order',
type: 2,
icon: 'Tickets',
component: 'views/Order/Status.vue',
permission: 'order:list',
};
/** 上一版「订单」页(发货单列表)——回退用;代码保留但不再挂菜单 */
const PREVIOUS_ORDER_MENU = {
component: 'views/Order/Index.vue',
permission: 'order:list',
};
/** 已废弃的独立「订单拆分」菜单 */
const LEGACY_SPLIT_MENU = {
name: '订单拆分',
path: '/order-split',
icon: 'Switch',
permission: 'splitOrder:list',
component: 'views/Order/Status.vue',
sort: 60,
};
/**
* 已并入「订单」的老发货单菜单(创建发货单 / 发货单列表)
*
* 口径(2026-09-16 按用户要求):老发货单的**能力**(创建 / 审核 / 推送 / 驳回 / 取消 / 作废 / 恢复 /
* 明细维护 / 换仓换店铺)已全部落到新表并在「订单」页实现,数据也已迁入新表,故不再单独挂这两个菜单;
* 代码文件保留(views/Order/Index.vue、Create.vue),仅菜单入口下线,必要时可一键恢复。
*/
const LEGACY_DELIVERY_MENUS = [
{ path: '/order-create', name: '创建发货单' },
{ path: '/order-delivery', name: '发货单' },
];
/**
* 应用「订单」菜单口径:
* 1. 「订单」菜单(/order)指向订单页(views/Order/Status.vue),权限 order:list;
* 2. 删除历史上单独挂的「订单拆分」菜单(其能力已并入「订单」);
* 3. 删除老发货单菜单(创建发货单 / 发货单列表)——能力与数据均已并入「订单」。
* 幂等:重复执行结果一致;表/行不存在时为空操作。
* @param {Object} queryInterface sequelize queryInterface
* @return {Promise<void>} 无
*/
async function applyOrderMenu(queryInterface) {
const sequelize = queryInterface.sequelize;
await sequelize.query(
`UPDATE menus SET component = ?, permission = ?, icon = ?, updated_at = NOW()
WHERE name = ? AND path = ? AND type = ?`,
{
replacements: [
ORDER_MENU.component, ORDER_MENU.permission, ORDER_MENU.icon,
ORDER_MENU.name, ORDER_MENU.path, ORDER_MENU.type,
],
}
);
await sequelize.query(
'DELETE FROM menus WHERE name = ? AND path = ?',
{ replacements: [ LEGACY_SPLIT_MENU.name, LEGACY_SPLIT_MENU.path ] }
);
for (const menu of LEGACY_DELIVERY_MENUS) {
await sequelize.query(
'DELETE FROM menus WHERE path = ?',
{ replacements: [ menu.path ] }
);
}
}
/**
* 回退「订单」菜单口径:订单页指回发货单列表,并重建「订单拆分」菜单(挂在「订单管理」下)
* @param {Object} queryInterface sequelize queryInterface
* @return {Promise<void>} 无
*/
async function revertOrderMenu(queryInterface) {
const sequelize = queryInterface.sequelize;
await sequelize.query(
`UPDATE menus SET component = ?, permission = ?, updated_at = NOW()
WHERE name = ? AND path = ? AND type = ?`,
{
replacements: [
PREVIOUS_ORDER_MENU.component, PREVIOUS_ORDER_MENU.permission,
ORDER_MENU.name, ORDER_MENU.path, ORDER_MENU.type,
],
}
);
const [ orderMgmt ] = await sequelize.query(
"SELECT id FROM menus WHERE name = '订单管理' AND parent_id = 0 LIMIT 1",
{ type: sequelize.QueryTypes.SELECT }
);
if (!orderMgmt) return;
const [ exist ] = await sequelize.query(
'SELECT id FROM menus WHERE name = ? AND path = ? LIMIT 1',
{ replacements: [ LEGACY_SPLIT_MENU.name, LEGACY_SPLIT_MENU.path ], type: sequelize.QueryTypes.SELECT }
);
if (exist) return;
await sequelize.query(
`INSERT INTO menus
(parent_id, name, type, path, icon, permission, component, sort, status, created_at, updated_at)
VALUES (?, ?, 2, ?, ?, ?, ?, ?, 1, NOW(), NOW())`,
{
replacements: [
Number(orderMgmt.id), LEGACY_SPLIT_MENU.name, LEGACY_SPLIT_MENU.path, LEGACY_SPLIT_MENU.icon,
LEGACY_SPLIT_MENU.permission, LEGACY_SPLIT_MENU.component, LEGACY_SPLIT_MENU.sort,
],
}
);
}
module.exports = {
ORDER_MENU,
PREVIOUS_ORDER_MENU,
LEGACY_SPLIT_MENU,
LEGACY_DELIVERY_MENUS,
applyOrderMenu,
revertOrderMenu,
};