From 303a933ae58e2057f34693d5813e4128550d1081 Mon Sep 17 00:00:00 2001
From: zjh <1084500556@qq.com>
Date: 星期五, 03 一月 2025 20:58:25 +0800
Subject: [PATCH] zjh20250103
---
ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjXdPictureMapper.java | 24 ++++++++++++++++++++++++
1 files changed, 24 insertions(+), 0 deletions(-)
diff --git a/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjXdPictureMapper.java b/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjXdPictureMapper.java
index e292edb..aba62c4 100644
--- a/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjXdPictureMapper.java
+++ b/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjXdPictureMapper.java
@@ -3,7 +3,10 @@
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ltkj.common.core.domain.BaseEntity;
import com.ltkj.hosp.domain.TjXdPicture;
+import org.apache.ibatis.annotations.Delete;
+import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
+import org.apache.ibatis.annotations.Select;
import java.util.List;
@@ -63,4 +66,25 @@
* @return 缁撴灉
*/
public int deleteTjXdPictureByIds(String[] ids);
+
+ @Select("SELECT\n" +
+ " b.tj_number tj_num,\n" +
+ " b.user_id cus_id,\n" +
+ " c.cus_name,\n" +
+ " a.pro_id ,\n" +
+ " d.pro_name,\n" +
+ " a.pro_result\n" +
+ "FROM\n" +
+ " tj_order_detail a\n" +
+ " JOIN tj_order b ON b.order_id = a.order_id\n" +
+ " JOIN tj_customer c ON c.cus_id = b.user_id\n" +
+ " JOIN tj_project d ON d.pro_id = a.pro_id\n" +
+ " JOIN sys_dept e ON e.dept_id = d.dept_id \n" +
+ "WHERE\n" +
+ " e.dept_id = '601' AND d.pro_parent_id !=0 AND b.tj_number=#{tjNum}")
+ List<TjXdPicture> saveTjXdPicture(String tjNum);
+
+
+ @Delete("delete from tj_xd_picture where tj_num= #{tjNum}")
+ void deleteTjXdPictureBytjNum(String tjNum);
}
--
Gitblit v1.8.0