oms/backend/app/controller/orderDeliveryItem.js
liufumingren 11e7b26ced feat(backend): 发货单模块与 WMS 定时推送队列
- 发货单主表/明细表(order_deliveries / order_delivery_items)控制器与模型
- 表头金额与明细派生字段重算(utils/recalcOrderDelivery.js)
- 状态流转:审核/驳回/取消/恢复/作废、批量审核、批量切换仓库
- 审核入队 + 定时推送:service/orderDeliveryPush.js(乐观锁 CAS 防重、失败重试上限 3 次、业务失败退回待审核)+ schedule/orderDeliveryPush.js
- 收件人 AI 智能识别(service/ai.js,DeepSeek)
- 相关迁移:建表、站内字段、明细表、订单类型默认值、快递字典、菜单种子、历史数据搬迁
2026-09-13 02:23:47 +08:00

250 lines
8.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';
const { Controller } = require('egg');
const { parsePagination, buildPageResult } = require('../lib/pagination');
const { validateItems, buildItemRow } = require('../lib/orderDeliveryItems');
const recalcOrderDelivery = require('../utils/recalcOrderDelivery');
/**
* 明细仅在所属发货单处于「待处理(1)」时可增删改;
* 单据进入已审核(2) 及之后明细即锁定,避免审核后篡改导致仓库侧对账不一致。
* @param {Object} ctx egg context
* @param {Number} orderDeliveryId 发货单头ID
* @return {Promise<{ok: boolean, order?: Object, message?: string}>} 校验结果(ok=false 时 message 为原因)
*/
async function assertItemsEditable(ctx, orderDeliveryId) {
const order = await ctx.model.OrderDelivery.findByPk(orderDeliveryId);
if (!order) return { ok: false, message: '所属发货单不存在' };
if (Number(order.status) !== 1) {
return { ok: false, message: '发货单已审核或已结束,明细已锁定,不允许增删改' };
}
return { ok: true, order };
}
/**
* @controller OrderDeliveryItemController 发货单明细(子表商品明细)管理
* 明细挂在 order_delivery_items 表,通过 order_delivery_id 关联发货单头
*/
class OrderDeliveryItemController extends Controller {
/**
* @summary 明细列表
* @description 按 order_delivery_id 查询明细(必填),按行号升序返回
* @router get /api/order-delivery-items
* @apikey
* @request query integer order_delivery_id 所属发货单ID(必填)
* @request query string item_code 商品编码,支持模糊匹配
* @request query integer page 页码,默认 1
* @request query integer pageSize 每页条数,默认 50
* @response 200 orderDeliveryItemListResponse success
*/
async index() {
const { ctx } = this;
const Op = this.app.Sequelize.Op;
const { page, pageSize, offset, limit } = parsePagination(ctx.query, { defaultPageSize: 50 });
const { order_delivery_id: orderDeliveryId, item_code: itemCode } = ctx.query;
if (!orderDeliveryId) {
ctx.status = 400;
ctx.body = { code: 400, message: 'order_delivery_id(所属发货单)为必填项' };
return;
}
const where = { order_delivery_id: Number(orderDeliveryId), principal_id: ctx.state.principalId };
if (itemCode) where.item_code = { [Op.like]: `%${itemCode}%` };
const { count, rows } = await ctx.model.OrderDeliveryItem.findAndCountAll({
where,
offset,
limit,
order: [[ 'order_line_no', 'ASC' ], [ 'id', 'ASC' ]],
});
ctx.body = { code: 0, message: 'success', data: buildPageResult(rows, count, { page, pageSize }) };
}
/**
* @summary 明细详情
* @router get /api/order-delivery-items/{id}
* @apikey
* @request path integer *id 明细主键ID
* @response 200 baseResponse success
*/
async show() {
const { ctx } = this;
const item = await ctx.model.OrderDeliveryItem.findByPk(ctx.params.id);
if (!item) {
ctx.status = 404;
ctx.body = { code: 404, message: '明细不存在' };
return;
}
ctx.body = { code: 0, message: 'success', data: item };
}
/**
* @summary 新增明细
* @description 明细可随发货单一次性创建(POST /api/order-deliveries 的 items),也可单独追加;
* plan_qty 必须大于 0,actual_price(单价)必填,item_id 与 item_code 至少填写一个
* @router post /api/order-delivery-items
* @apikey
* @request body createOrderDeliveryItemRequest *body
* @response 200 baseResponse success
*/
async create() {
const { ctx } = this;
const body = ctx.request.body || {};
const orderDeliveryId = body.order_delivery_id;
if (!orderDeliveryId) {
ctx.status = 400;
ctx.body = { code: 400, message: 'order_delivery_id(所属发货单)为必填项' };
return;
}
const editable = await assertItemsEditable(ctx, orderDeliveryId);
if (!editable.ok) {
ctx.status = 400;
ctx.body = { code: 400, message: editable.message };
return;
}
const invalid = validateItems([ body ]);
if (!invalid.ok) {
ctx.status = 400;
ctx.body = { code: 400, message: invalid.message };
return;
}
const existLine = await ctx.model.OrderDeliveryItem.findOne({
where: { order_delivery_id: Number(orderDeliveryId), order_line_no: String(body.order_line_no == null || body.order_line_no === '' ? 1 : body.order_line_no) },
});
if (existLine) {
ctx.status = 400;
ctx.body = { code: 400, message: '该发货单下明细行号已存在' };
return;
}
const item = await ctx.model.OrderDeliveryItem.create(buildItemRow(body, {
principalId: editable.order.principal_id,
orderDeliveryId: Number(orderDeliveryId),
lineIndex: 0,
}));
// 主表商品总数/种类数随之重算
await recalcOrderDelivery(ctx, item.order_delivery_id);
ctx.body = { code: 0, message: 'success', data: { id: item.id } };
}
/**
* @summary 更新明细
* @description 未传入的字段保持原值;明细仅在发货单「待处理(1)」时可修改
* @router put /api/order-delivery-items/{id}
* @apikey
* @request path integer *id 明细主键ID
* @request body updateOrderDeliveryItemRequest *body
* @response 200 baseResponse success
*/
async update() {
const { ctx } = this;
const item = await ctx.model.OrderDeliveryItem.findByPk(ctx.params.id);
if (!item) {
ctx.status = 404;
ctx.body = { code: 404, message: '明细不存在' };
return;
}
const editable = await assertItemsEditable(ctx, item.order_delivery_id);
if (!editable.ok) {
ctx.status = 400;
ctx.body = { code: 400, message: editable.message };
return;
}
const body = { ...(ctx.request.body || {}) };
delete body.order_delivery_id;
delete body.principal_id;
if (body.plan_qty !== undefined && !(Number(body.plan_qty) > 0)) {
ctx.status = 400;
ctx.body = { code: 400, message: 'plan_qty(计划数量)必须大于 0' };
return;
}
// 单价为必填项:显式传空(null / 空串)视为非法,未传则保持原值
if (body.actual_price !== undefined) {
const price = body.actual_price;
if (price == null || String(price).trim() === '' || !(Number(price) >= 0)) {
ctx.status = 400;
ctx.body = { code: 400, message: 'actual_price(单价)必须为不小于 0 的数字' };
return;
}
}
// 行号变更时校验同单据内不重复(有唯一索引兜底,这里提前给出友好提示)
if (body.order_line_no !== undefined && String(body.order_line_no) !== String(item.order_line_no)) {
const Op = this.app.Sequelize.Op;
const dup = await ctx.model.OrderDeliveryItem.findOne({
where: {
order_delivery_id: item.order_delivery_id,
order_line_no: String(body.order_line_no),
id: { [Op.ne]: item.id },
},
});
if (dup) {
ctx.status = 400;
ctx.body = { code: 400, message: '该发货单下明细行号已存在' };
return;
}
}
const row = buildItemRow({ ...item.get({ plain: true }), ...body }, {
principalId: item.principal_id,
orderDeliveryId: item.order_delivery_id,
lineIndex: 0,
});
delete row.principal_id;
delete row.order_delivery_id;
delete row.created_at;
await item.update(row);
await recalcOrderDelivery(ctx, item.order_delivery_id);
ctx.body = { code: 0, message: 'success', data: { id: item.id } };
}
/**
* @summary 删除明细
* @description 物理删除;明细仅在发货单「待处理(1)」时可删除
* @router delete /api/order-delivery-items/{id}
* @apikey
* @request path integer *id 明细主键ID
* @response 200 baseResponse success
*/
async destroy() {
const { ctx } = this;
const item = await ctx.model.OrderDeliveryItem.findByPk(ctx.params.id);
if (!item) {
ctx.status = 404;
ctx.body = { code: 404, message: '明细不存在' };
return;
}
const editable = await assertItemsEditable(ctx, item.order_delivery_id);
if (!editable.ok) {
ctx.status = 400;
ctx.body = { code: 400, message: editable.message };
return;
}
const orderDeliveryId = item.order_delivery_id;
await item.destroy();
await recalcOrderDelivery(ctx, orderDeliveryId);
ctx.body = { code: 0, message: 'success' };
}
}
module.exports = OrderDeliveryItemController;