From aa33bb96ba9f14b16c6c7832e21bfbd88983ba6d Mon Sep 17 00:00:00 2001
From: zjh <1084500556@qq.com>
Date: 星期三, 24 一月 2024 18:02:39 +0800
Subject: [PATCH] zjh 2024/01/24--3
---
ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjOrderMapper.java | 13 +++++++++++++
1 files changed, 13 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..33cf20a 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,16 @@
@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);
}
--
Gitblit v1.8.0