From cac8f41a47915de2a30a8784fe1fc35c364e86df Mon Sep 17 00:00:00 2001
From: jiaosong <jiaosong6760@dingtalk.com>
Date: 星期二, 10 十月 2023 18:27:08 +0800
Subject: [PATCH] #pgsql 运营监控
---
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