From ff3cc467816f0e70d524633b401c62b6bf927b92 Mon Sep 17 00:00:00 2001
From: Cui Zhi Feng <7426394+wuxixiaocui@user.noreply.gitee.com>
Date: 星期四, 12 九月 2024 13:09:24 +0800
Subject: [PATCH] 订单商品质检供应商扣款字段
---
src/main/java/com/mzl/flower/dto/response/payment/OrderItemPlatformListDTO.java | 9 +++++++++
src/main/resources/mapper/payment/OrderItemMapper.xml | 2 ++
2 files changed, 11 insertions(+), 0 deletions(-)
diff --git a/src/main/java/com/mzl/flower/dto/response/payment/OrderItemPlatformListDTO.java b/src/main/java/com/mzl/flower/dto/response/payment/OrderItemPlatformListDTO.java
index 6ad932b..40e5069 100644
--- a/src/main/java/com/mzl/flower/dto/response/payment/OrderItemPlatformListDTO.java
+++ b/src/main/java/com/mzl/flower/dto/response/payment/OrderItemPlatformListDTO.java
@@ -48,4 +48,13 @@
@ApiModelProperty(value = "异常未处理数量")
private Integer unProcessCount;
+
+ @ApiModelProperty(value = "供应商缺货扣款")
+ private BigDecimal lackFeeSupplier;
+
+ @ApiModelProperty(value = "供应商补货扣款")
+ private BigDecimal replaceFee;
+
+ @ApiModelProperty(value = "供应商降级扣款")
+ private BigDecimal checkFee;
}
diff --git a/src/main/resources/mapper/payment/OrderItemMapper.xml b/src/main/resources/mapper/payment/OrderItemMapper.xml
index c637e25..87c38d7 100644
--- a/src/main/resources/mapper/payment/OrderItemMapper.xml
+++ b/src/main/resources/mapper/payment/OrderItemMapper.xml
@@ -50,9 +50,11 @@
, (select oic.audit_status from t_order_item_check oic where oic.order_item_id = oi.id and oic.type = 'reduce') reduceStatus
, (select oic.audit_status from t_order_item_check oic where oic.order_item_id = oi.id and oic.type = 'lack') lackStatus
, (select count(1) from t_order_item_check oic where oic.order_item_id = oi.id and oic.audit_status is null) unProcessCount
+ , ois.lack_fee_supplier, ois.replace_fee, ois.check_fee
FROM t_order_item oi
left join t_station s on s.id = oi.station_id
left join t_supplier_info si on si.id = oi.supplier_id
+ left join t_order_item_settlement ois on ois.order_item_id = oi.id
WHERE oi.deleted = 0
and oi.order_id = #{orderId}
</select>
--
Gitblit v1.9.3