From 8b477267727b0fe9ca60c98be57ae5a387a6a272 Mon Sep 17 00:00:00 2001
From: zjh <1084500556@qq.com>
Date: 星期四, 31 十月 2024 11:45:01 +0800
Subject: [PATCH] zjh20241031

---
 ltkj-hosp/src/main/java/com/ltkj/hosp/service/ITjOrderRemarkService.java         |    4 ++++
 ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjOrderRemarkMapper.java            |   12 ++++++++++++
 ltkj-admin/src/main/java/com/ltkj/web/controller/system/TjOrderController.java   |    2 ++
 ltkj-hosp/src/main/java/com/ltkj/hosp/service/impl/TjOrderRemarkServiceImpl.java |    5 +++++
 4 files changed, 23 insertions(+), 0 deletions(-)

diff --git a/ltkj-admin/src/main/java/com/ltkj/web/controller/system/TjOrderController.java b/ltkj-admin/src/main/java/com/ltkj/web/controller/system/TjOrderController.java
index 0eb3160..42e9a63 100644
--- a/ltkj-admin/src/main/java/com/ltkj/web/controller/system/TjOrderController.java
+++ b/ltkj-admin/src/main/java/com/ltkj/web/controller/system/TjOrderController.java
@@ -1830,6 +1830,7 @@
                     }
                 }
             }
+            remarkService.updateRemark(tjNumber);
             asyncService.tjGoutAsync(domainVos, sysUser, list);
 
             TjCustomer customer = tjCustomerService.selectTjCustomerByCusId(tjOrder.getUserId());
@@ -1866,6 +1867,7 @@
             }*/
             return AjaxResult.success("绛剧鎴愬姛锛�");
         } else {
+            remarkService.updateRemark(tjNumber);
             return getAjaxResult(tjNumber);
         }
     }
diff --git a/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjOrderRemarkMapper.java b/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjOrderRemarkMapper.java
index 0ef8cbd..b96b163 100644
--- a/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjOrderRemarkMapper.java
+++ b/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjOrderRemarkMapper.java
@@ -143,4 +143,16 @@
 
     @Delete("DELETE  FROM tj_order_remark WHERE jxbz=#{bldh}")
     void deleteTjOrderDetailByjxbz(String bldh);
+
+
+    @Update("UPDATE tj_order_remark rem\n" +
+            "JOIN tj_project a ON a.pro_id=rem.pro_id\n" +
+            "  SET rem.type = 1,\n" +
+            "  rem.update_time = SYSDATE() \n" +
+            "WHERE\n" +
+            "  rem.pro_id = a.pro_id \n" +
+            "  AND rem.tj_number = #{tjNum} \n" +
+            "  AND (a.pro_name LIKE '%蹇冪數鍥�%' OR a.pro_name LIKE '%濡囨煡%' OR a.pro_name LIKE '%hpv%' OR a.pro_name LIKE '%tct%' OR a.pro_name LIKE '%濡囩浜旇仈妫�%'\n" +
+            "  OR  a.pro_name LIKE '%鐢靛瓙闃撮亾闀滄鏌�%' OR  a.pro_name LIKE '%C14%' OR  a.pro_name LIKE '%蹇冪悊妫�娴�%' OR  a.pro_name LIKE '%鑲哄姛鑳芥鏌�%' OR  a.pro_name LIKE '%闈欒剦%');")
+    boolean updateRemark(String tjNum);
 }
diff --git a/ltkj-hosp/src/main/java/com/ltkj/hosp/service/ITjOrderRemarkService.java b/ltkj-hosp/src/main/java/com/ltkj/hosp/service/ITjOrderRemarkService.java
index 444e9a7..898c6c0 100644
--- a/ltkj-hosp/src/main/java/com/ltkj/hosp/service/ITjOrderRemarkService.java
+++ b/ltkj-hosp/src/main/java/com/ltkj/hosp/service/ITjOrderRemarkService.java
@@ -59,4 +59,8 @@
     void updateTjOrderRemark(String tjnumber,String proId);
 
     void deleteTjOrderDetailByjxbz(String bldh);
+
+
+    //淇敼鎸囧畾椤圭洰(蹇冪數鍥剧瓑)鐘舵��
+    boolean updateRemark(String tjNum);
 }
diff --git a/ltkj-hosp/src/main/java/com/ltkj/hosp/service/impl/TjOrderRemarkServiceImpl.java b/ltkj-hosp/src/main/java/com/ltkj/hosp/service/impl/TjOrderRemarkServiceImpl.java
index 4095a2b..3f982b5 100644
--- a/ltkj-hosp/src/main/java/com/ltkj/hosp/service/impl/TjOrderRemarkServiceImpl.java
+++ b/ltkj-hosp/src/main/java/com/ltkj/hosp/service/impl/TjOrderRemarkServiceImpl.java
@@ -107,4 +107,9 @@
         mapper.deleteTjOrderDetailByjxbz(bldh);
     }
 
+    @Override
+    public boolean updateRemark(String tjNum) {
+        return mapper.updateRemark(tjNum);
+    }
+
 }

--
Gitblit v1.8.0