From 488cc3665822da42c4a4173d962920c6bd057a3d Mon Sep 17 00:00:00 2001 From: zjh <1084500556@qq.com> Date: 星期五, 15 九月 2023 17:57:01 +0800 Subject: [PATCH] zjh 2023/09/15--3 --- ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjFlowingWaterMapper.java | 3 +++ 1 files changed, 3 insertions(+), 0 deletions(-) diff --git a/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjFlowingWaterMapper.java b/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjFlowingWaterMapper.java index bf63a6f..88f4d80 100644 --- a/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjFlowingWaterMapper.java +++ b/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjFlowingWaterMapper.java @@ -69,4 +69,7 @@ "\n" + " tj_flowing_water b ON a.order_id = b.order_id WHERE a.tj_number =#{tjNum} AND a.deleted='0' AND b.deleted='0'") List<String> getFlowingWaterIds(String tjNum); + + @Select("\tSELECT a.discount/10 FROM tj_flowing_water a WHERE 1=1 AND a.deleted =0 AND a.order_id=#{orderId} AND a.discount !='/'") + String getDiscount(String orderId); } -- Gitblit v1.8.0