From 9b6f602df09c5e39481f03e22d99fffe825b9393 Mon Sep 17 00:00:00 2001
From: zjh <1084500556@qq.com>
Date: 星期二, 31 十二月 2024 19:13:17 +0800
Subject: [PATCH] zjh202412031
---
ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TbTransitionMapper.java | 46 ++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 46 insertions(+), 0 deletions(-)
diff --git a/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TbTransitionMapper.java b/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TbTransitionMapper.java
index 9312fb3..e30df00 100644
--- a/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TbTransitionMapper.java
+++ b/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TbTransitionMapper.java
@@ -217,6 +217,44 @@
boolean saveTemoTransitionByGroupingId(@Param("cusId")String cusId,@Param("groupingId")String groupingId);
+ @Insert("INSERT INTO tb_transition(\n" +
+ " cus_id,\n" +
+ " pac_id,\n" +
+ " pac_name,\n" +
+ " pro_id,\n" +
+ " pro_name,\n" +
+ " parent_pro_id,\n" +
+ " parent_pro_name,\n" +
+ " ord_price,\n" +
+ " now_price,\n" +
+ " create_time,\n" +
+ " pro_check_method,\n" +
+ " pro_type,\n" +
+ " card_id\n" +
+ ")\n" +
+ "SELECT\n" +
+ "#{cusId},\n" +
+ "#{groupingId},\n" +
+ "d.grouping_name,\n" +
+ "c.pro_id,\n" +
+ "c.pro_name,\n" +
+ "b.pro_id,\n" +
+ "b.pro_name,\n" +
+ "c.pro_price * (a.limits/10),\n" +
+ "c.pro_price * (a.limits/10),\n" +
+ "SYSDATE(),\n" +
+ "c.pro_check_method,\n" +
+ "c.pro_type,\n" +
+ "\t#{cardId}\n" +
+ "FROM\n" +
+ "\ttj_grouping_pro a \n" +
+ "JOIN tj_dw_grouping d ON d.id=a.grouping_id \n" +
+ "\tLEFT JOIN tj_project b ON a.pro_id = b.pro_id \n" +
+ "\tLEFT JOIN tj_project c ON c.pro_parent_id=b.pro_id\n" +
+ "WHERE 1=1 AND a.grouping_id =#{groupingId} and c.deleted=0 ")
+ boolean ttsaveTemoTransitionByGroupingId(@Param("cusId")String cusId,@Param("cardId") String cardId,@Param("groupingId") String groupingId);
+
+
// @Select("SELECT b.price_now FROM \n" +
// "(SELECT a.pac_id FROM tb_transition a WHERE\n" +
// "\ta.cus_id = #{cusId} \n" +
@@ -289,4 +327,12 @@
"WHERE b.pro_id IN(SELECT DISTINCT a.parent_pro_id FROM tb_transition a WHERE a.cus_id=#{idCard} AND ISNULL(a.tj_num))" +
"AND b.pac_id=#{pacId}")
String panduantaocanshifouchongfu(@Param("idCard") String idCard,@Param("pacId") Long pacId);
+
+
+
+ @Select("SELECT GROUP_CONCAT(c.pro_name SEPARATOR ' ; ' ) FROM tj_grouping_pro b JOIN tj_project c ON c.pro_id=b.pro_id\n" +
+ "\n" +
+ "WHERE b.pro_id IN(SELECT DISTINCT a.parent_pro_id FROM tb_transition a WHERE a.cus_id=#{idCard} AND ISNULL(a.tj_num))" +
+ "AND b.grouping_id=#{pacId}")
+ String ttpanduantaocanshifouchongfu(@Param("idCard") String idCard,@Param("pacId") Long pacId);
}
--
Gitblit v1.8.0