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 | 116 +++++++++++++++++++++++++++++++++++++++++++++++-----------
1 files changed, 94 insertions(+), 22 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 ac7f7f5..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
@@ -145,7 +145,7 @@
@Select("SELECT * FROM tj_order WHERE user_id = #{cusId} AND deleted='0' ORDER BY create_time DESC")
public List<TjOrder> getOrderListByCusId(@Param("cusId") String cusId);
- @Select("SELECT * FROM tj_order WHERE tj_number = #{tjNum} AND deleted='0' ")
+ @Select("SELECT * FROM tj_order WHERE tj_number = #{tjNum} AND deleted=0 ")
public TjOrder getOrderByTjNum(String tjNum);
@Select("SELECT * FROM tj_order WHERE card_id = #{cardId} AND deleted='0' ")
@@ -233,28 +233,58 @@
// List<Map<String ,String >> selectDjdInfo(@Param("tjNumber")String tjNumber);
+// @Select("SELECT \n" +
+// " ROW_NUMBER() OVER (ORDER BY d.djd_num) AS xh, " +
+// " REPLACE(d.dept_name, '闂ㄨ瘖', '') AS ksmc,\n" +
+// " ifnull(d.official_web,'') AS ksdz,\n" +
+// " e.tjxm,\n" +
+// " e.tjjg\n" +
+// "FROM sys_dept d\n" +
+// "JOIN (\n" +
+// " SELECT\n" +
+// " c.dept_id,\n" +
+// " GROUP_CONCAT(DISTINCT c1.pro_name ORDER BY c1.pro_name DESC SEPARATOR ';') AS tjxm,\n" +
+// " SUM(b.ord_price) AS tjjg\n" +
+// " FROM tb_transition b\n" +
+// " JOIN tj_project c ON c.pro_id = b.parent_pro_id\n" +
+// " JOIN tj_project c1 ON c1.pro_id = b.parent_pro_id\n" +
+// " WHERE trim(b.tj_num) = #{tjNumber} \n" +
+// " AND c.pro_parent_id = 0\n" +
+// " AND c1.pro_name NOT IN ('涓讳换鍖诲笀璇婃煡', '(tj)浣撴璐�(鐗╃悊妫�鏌�)')\n" +
+// " AND c1.pro_name NOT LIKE '%涓讳换鍖诲笀璇婃煡%'\n" +
+// " GROUP BY c.dept_id\n" +
+// ") e ON e.dept_id = d.dept_id\n" +
+// "ORDER BY d.djd_num")
@Select("SELECT \n" +
- " ROW_NUMBER() OVER (ORDER BY d.djd_num) AS xh, " +
- " REPLACE(d.dept_name, '闂ㄨ瘖', '') AS ksmc,\n" +
- " ifnull(d.official_web,'') AS ksdz,\n" +
- " e.tjxm,\n" +
- " e.tjjg\n" +
- "FROM sys_dept d\n" +
- "JOIN (\n" +
- " SELECT\n" +
- " c.dept_id,\n" +
- " GROUP_CONCAT(DISTINCT c1.pro_name ORDER BY c1.pro_name DESC SEPARATOR ';') AS tjxm,\n" +
- " SUM(b.ord_price) AS tjjg\n" +
- " FROM tb_transition b\n" +
- " JOIN tj_project c ON c.pro_id = b.parent_pro_id\n" +
- " JOIN tj_project c1 ON c1.pro_id = b.parent_pro_id\n" +
- " WHERE trim(b.tj_num) = #{tjNumber} \n" +
- " AND c.pro_parent_id = 0\n" +
- " AND c1.pro_name NOT IN ('涓讳换鍖诲笀璇婃煡', '(tj)浣撴璐�(鐗╃悊妫�鏌�)')\n" +
- " AND c1.pro_name NOT LIKE '%涓讳换鍖诲笀璇婃煡%'\n" +
- " GROUP BY c.dept_id\n" +
- ") e ON e.dept_id = d.dept_id\n" +
- "ORDER BY d.djd_num")
+ " @rownum := @rownum + 1 AS xh,\n" +
+ " t.ksmc,\n" +
+ " t.ksdz,\n" +
+ " t.tjxm,\n" +
+ " t.tjjg\n" +
+ "FROM (\n" +
+ " SELECT \n" +
+ " REPLACE(d.dept_name, '闂ㄨ瘖', '') AS ksmc,\n" +
+ " IFNULL(d.official_web, '') AS ksdz,\n" +
+ " e.tjxm,\n" +
+ " e.tjjg,\n" +
+ " d.djd_num\n" +
+ " FROM sys_dept d\n" +
+ " JOIN (\n" +
+ " SELECT\n" +
+ " c.dept_id,\n" +
+ " GROUP_CONCAT(DISTINCT c1.pro_name ORDER BY c1.pro_name DESC SEPARATOR ';') AS tjxm,\n" +
+ " SUM(b.ord_price) AS tjjg\n" +
+ " FROM tb_transition b\n" +
+ " JOIN tj_project c ON c.pro_id = b.parent_pro_id\n" +
+ " JOIN tj_project c1 ON c1.pro_id = b.parent_pro_id\n" +
+ " WHERE TRIM(b.tj_num) = #{tjNumber} \n" +
+ " AND c.pro_parent_id = 0\n" +
+ " AND c1.pro_name NOT IN ('涓讳换鍖诲笀璇婃煡', '(tj)浣撴璐�(鐗╃悊妫�鏌�)')\n" +
+ " AND c1.pro_name NOT LIKE '%涓讳换鍖诲笀璇婃煡%'\n" +
+ " GROUP BY c.dept_id\n" +
+ " ) e ON e.dept_id = d.dept_id\n" +
+ ") t, (SELECT @rownum := 0) r\n" +
+ "ORDER BY t.djd_num;\n")
List<Map<String ,Object >> selectDjdInfo(@Param("tjNumber")String tjNumber);
/**
@@ -386,4 +416,46 @@
" a.deleted = 0 \n" +
" AND b.org_type = 2 \n")
List<String> getJianChaTjNum();
+
+
+ @Select("SELECT a.tj_number FROM tj_order a WHERE a.deleted=0 AND a.check_status=0 AND\n" +
+ "ISNULL(a.report_time)")
+ List<String> getJianChaTjNumWsh();
+
+
+
+
+
+ List<List<?>> getYxJcList(Map<String,Object> map);
+
+
+ @Select("SELECT count(*) FROM tj_order WHERE tj_number = #{tjNum}")
+ int getOrderCountByTjNum(String tjNum);
+
+
+
+ //瀛樺偍杩囩▼涓撶敤鎺ュ彛(鎬绘)
+ 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