From 2234cee8e872fd7633b95eef5b0c760cbbb8eabf Mon Sep 17 00:00:00 2001
From: Van333 <van666666@foxmail.com>
Date: 星期五, 02 九月 2022 17:00:00 +0800
Subject: [PATCH] 20220902林平凡离职交接（新增北理工大气数据获取）
---
src/main/java/api/dao/SinglelampDataDao.java | 7 ++++++-
1 files changed, 6 insertions(+), 1 deletions(-)
diff --git a/src/main/java/api/dao/SinglelampDataDao.java b/src/main/java/api/dao/SinglelampDataDao.java
index cf7b541..b50e8e5 100644
--- a/src/main/java/api/dao/SinglelampDataDao.java
+++ b/src/main/java/api/dao/SinglelampDataDao.java
@@ -3,6 +3,8 @@
import api.bean.LampEntity;
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;
@@ -20,9 +22,12 @@
/**瓒呯骇绠＄悊鍛樻煡鎵惧叏閮�*/
List<SinglelampDataEntity> selectAll();
/**鏅�氱鐞嗗憳鎸夊叕鍙告煡鎵�*/
- List<SinglelampDataEntity> selectByCompany(Long userId);
+ List<SinglelampDataEntity> selectByCompany(@Param("page") Integer page, @Param("size") Integer size,@Param("userId") Long userId);
/**鐢ㄦ埛鏌ユ壘*/
//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