From ad6e2c216fb5b653285e6b82c46327e77b0ffb75 Mon Sep 17 00:00:00 2001
From: Cui Zhi Feng <cuizf@fengyuntec.com>
Date: 星期三, 28 八月 2024 20:07:09 +0800
Subject: [PATCH] 质检 配送单详情
---
src/main/java/com/mzl/flower/dto/response/payment/DeliveryOrderItemCheckDTO.java | 9 +++++++++
src/main/resources/mapper/payment/DeliveryOrderItemMapper.xml | 3 +++
2 files changed, 12 insertions(+), 0 deletions(-)
diff --git a/src/main/java/com/mzl/flower/dto/response/payment/DeliveryOrderItemCheckDTO.java b/src/main/java/com/mzl/flower/dto/response/payment/DeliveryOrderItemCheckDTO.java
index 4a4898a..caa0112 100644
--- a/src/main/java/com/mzl/flower/dto/response/payment/DeliveryOrderItemCheckDTO.java
+++ b/src/main/java/com/mzl/flower/dto/response/payment/DeliveryOrderItemCheckDTO.java
@@ -41,6 +41,15 @@
@ApiModelProperty(value = "集货状态")
private String status;
+ @ApiModelProperty(value = "补货数量")
+ private Integer replaceNum;
+
+ @ApiModelProperty(value = "降级数量")
+ private Integer reduceNum;
+
+ @ApiModelProperty(value = "缺货数量")
+ private Integer lackNum;
+
/*private String checkImages;
@ApiModelProperty(value = "质检图片")
diff --git a/src/main/resources/mapper/payment/DeliveryOrderItemMapper.xml b/src/main/resources/mapper/payment/DeliveryOrderItemMapper.xml
index b36955a..f6b9e26 100644
--- a/src/main/resources/mapper/payment/DeliveryOrderItemMapper.xml
+++ b/src/main/resources/mapper/payment/DeliveryOrderItemMapper.xml
@@ -16,6 +16,9 @@
<select id="selectDoItemCheckList" resultType="com.mzl.flower.dto.response.payment.DeliveryOrderItemCheckDTO">
SELECT oi.id, oi.flower_name, oi.flower_unit, oi.flower_color, oi.flower_cover, oi.num
, oi.supplier_price price, oi.flower_level, oi.status, oi.check_images, oi.check_time, oi.check_remarks
+ , (select oic.num from t_order_item_check oic where oic.order_item_id = oi.id and oic.type = 'replace') replaceNum
+ , (select oic.num from t_order_item_check oic where oic.order_item_id = oi.id and oic.type = 'reduce') reduceNum
+ , (select oic.num from t_order_item_check oic where oic.order_item_id = oi.id and oic.type = 'lack') lackNum
FROM t_delivery_order_item q
join t_order_item oi on oi.id = q.order_item_id
WHERE q.deleted = 0 and oi.deleted = 0
--
Gitblit v1.9.3