From d89bdcd93aff8d94d3b3b50dbf866eafc1f58bac Mon Sep 17 00:00:00 2001 From: zjh <1084500556@qq.com> Date: 星期四, 23 五月 2024 18:04:01 +0800 Subject: [PATCH] zjh 2024/05/23-1 --- ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjOrderMapper.java | 21 +++++++++++++++++++++ 1 files changed, 21 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 56dfb05..f323916 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 @@ -5,6 +5,7 @@ import java.util.Map; import com.baomidou.mybatisplus.core.mapper.BaseMapper; +import com.ltkj.hosp.domain.TjCustomer; import com.ltkj.hosp.domain.TjOrder; import com.ltkj.hosp.vodomain.LineChartsVo; import org.apache.ibatis.annotations.Mapper; @@ -185,4 +186,24 @@ @Select("SELECT * FROM tj_order WHERE deleted='0' and user_id =#{userId}" + " AND !ISNULL(finish_time) ORDER BY create_time DESC LIMIT 1") TjOrder getLastTjOrderListByCusId(Long userId); + + + //瀛樺偍杩囩▼涓撶敤鎺ュ彛(鎬绘) + List<List<?>> getCunChuGuoChengCustomerList(Map<String,Object> map); + + + //瀛樺偍杩囩▼涓撶敤鎺ュ彛(鍒濆) + List<List<?>> getCsCunChuGuoChengCustomerList(Map<String,Object> map); + + + @Select("SELECT count(*) FROM tj_order a WHERE a.deleted=0 and a.card_id=#{cardId}") + int selectTjOrderByCardId(String cardId); + + + @Select("SELECT a.card_id FROM tj_order a WHERE a.deleted=0") + List<String> selectTjOrderByCardId1(); + + + @Select("SELECT a.order_id FROM tj_order_detail a WHERE a.order_id=#{orderId} AND !ISNULL(a.flowing_water_id) GROUP BY a.order_id ") + String isPayByTjNum(String orderId); } -- Gitblit v1.8.0