From 0892d843cd394f383ff50f480f7f22f2ec3829bc Mon Sep 17 00:00:00 2001 From: zhaowenxuan <chacca165@163.com> Date: 星期五, 27 六月 2025 20:24:45 +0800 Subject: [PATCH] Merge remote-tracking branch 'origin/master' --- ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjOrderMapper.java | 17 ++++++++++++++++- 1 files changed, 16 insertions(+), 1 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..005dcb2 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' ") @@ -386,4 +386,19 @@ " 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); } -- Gitblit v1.8.0