From e7ac7e5702f6ac1f88403485de232e5494a1c76a Mon Sep 17 00:00:00 2001
From: zhaowenxuan <chacca165@163.com>
Date: 星期一, 11 八月 2025 13:55:57 +0800
Subject: [PATCH] 修改错误日志打印
---
ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjOrderMapper.java | 22 ++++++++++++++++++++++
1 files changed, 22 insertions(+), 0 deletions(-)
diff --git a/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjOrderMapper.java b/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjOrderMapper.java
index dd93ba0..17a9ede 100644
--- a/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjOrderMapper.java
+++ b/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjOrderMapper.java
@@ -436,4 +436,26 @@
//瀛樺偍杩囩▼涓撶敤鎺ュ彛(鎬绘)
List<List<?>> getEsjCunChuGuoChengCustomerList(Map<String,Object> map);
+
+
+ @Select("SELECT * FROM tj_order WHERE tj_number = card_id ")
+ List<TjOrder> getOrderListBypiliangqiandaofasong();
+
+
+ @Select("SELECT COUNT(*) FROM tj_order a WHERE a.deleted=0 AND " +
+ "(a.firm_id=#{compId} OR a.team_no=#{teamNo}) AND a.pac_id=#{pacId}")
+ Integer getTjTeamSelectRecordCount(@Param("teamNo") String teamNo,@Param("compId") String compId,@Param("pacId") String pacId);
+
+ @Select(" SELECT aa.pacname pacname FROM (\n" +
+ " SELECT TRIM(a.pac_name) pacname FROM tj_package a WHERE a.pac_id=#{pacId}\n" +
+ " \n" +
+ " UNION \n" +
+ " \n" +
+ " SELECT TRIM(b.dw_dept_name) pacname FROM tj_dw_grouping b WHERE b.id=#{pacId}) aa GROUP BY aa.pacname\n" +
+ " ")
+ String getpacName(String pacId);
+
+
+ @Select(" SELECT SUM(a.paid_in) FROM tj_flowing_water a WHERE a.deleted=0 AND a.pay_stasus=1 AND a.order_id=#{orderId} ")
+ String gettjzj(Long orderId);
}
--
Gitblit v1.8.0