From f7debb464a2d49b6e66b014cf2beef2a9c4bf98d Mon Sep 17 00:00:00 2001
From: Van333 <van666666@foxmail.com>
Date: 星期三, 26 十月 2022 15:41:46 +0800
Subject: [PATCH] 参数调整
---
src/main/java/api/dao/SinglelampDataDao.java | 4 ++++
1 files changed, 4 insertions(+), 0 deletions(-)
diff --git a/src/main/java/api/dao/SinglelampDataDao.java b/src/main/java/api/dao/SinglelampDataDao.java
index 0441d70..b50e8e5 100644
--- a/src/main/java/api/dao/SinglelampDataDao.java
+++ b/src/main/java/api/dao/SinglelampDataDao.java
@@ -4,6 +4,7 @@
import api.bean.SinglelampDataEntity;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
+import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;
import java.util.List;
@@ -26,4 +27,7 @@
//List<SinglelampDataEntity> selectByUserId(Long userId);
/**鍗曚釜鐏潌鏁版嵁*/
List<SinglelampDataEntity> selectByStreetlightId(String mac);
+
+ @Select("select count(*) from pole_streetlight ps where ps.streetlight_id in(select pus.streetlight_id from pole_user_streetlight pus where pus.company_id in(select suc.company_id from sys_user_company suc where suc.user_id=#{userId}))")
+ Integer countByCompany(@Param("userId") Long userId);
}
--
Gitblit v1.9.3