From 945a278393bef3adc650fba5bc050b82535d5f19 Mon Sep 17 00:00:00 2001
From: k94314517 <8417338+k94314517@user.noreply.gitee.com>
Date: 星期三, 11 十月 2023 10:31:15 +0800
Subject: [PATCH] 111
---
server/services/src/main/java/com/doumee/dao/business/SitesMapper.java | 18 ++++++++++++++++++
1 files changed, 18 insertions(+), 0 deletions(-)
diff --git a/server/services/src/main/java/com/doumee/dao/business/SitesMapper.java b/server/services/src/main/java/com/doumee/dao/business/SitesMapper.java
index 6ec68e6..0fbb35b 100644
--- a/server/services/src/main/java/com/doumee/dao/business/SitesMapper.java
+++ b/server/services/src/main/java/com/doumee/dao/business/SitesMapper.java
@@ -2,6 +2,8 @@
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.doumee.dao.business.model.Sites;
+import com.doumee.dao.business.web.request.SitesMonitorDTO;
+import org.apache.ibatis.annotations.Select;
/**
* @author 姹熻箘韫�
@@ -9,4 +11,20 @@
*/
public interface SitesMapper extends BaseMapper<Sites> {
+
+ /**
+ * @return
+ */
+ @Select("SELECT \n" +
+ "sites.id,\n" +
+ "sites.name as name,\n" +
+ "sites.code as code,\n" +
+ "count(l.id) as lid,\n" +
+ "count(l.bike_code ) as lbikeCount\n" +
+ "from \n" +
+ "sites sites\n" +
+ "LEFT JOIN locks l on sites.id = l.site_id\n" +
+ "GROUP BY sites.id ")
+ SitesMonitorDTO getSitesMonitorDTO();
+
}
--
Gitblit v1.9.3