From 9ac01b48ef00a0855306d72e8c680b912a9a8d03 Mon Sep 17 00:00:00 2001 From: zjh <1084500556@qq.com> Date: 星期四, 07 八月 2025 08:44:50 +0800 Subject: [PATCH] zjh20250807 --- ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjOrderMapper.java | 27 +++++++++++++++++++++++++++ 1 files changed, 27 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 681bbd1..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 @@ -431,4 +431,31 @@ @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