From be9c7a2f692b19c319bce50b613600c22c1d38cd Mon Sep 17 00:00:00 2001
From: liusuyi <1951119284@qq.com>
Date: 星期一, 20 五月 2024 10:02:55 +0800
Subject: [PATCH] 优化雷达报警汇聚sql
---
ruoyi-system/src/main/java/com/ruoyi/system/mapper/SysUserMapper.java | 10 ++++++++++
1 files changed, 10 insertions(+), 0 deletions(-)
diff --git a/ruoyi-system/src/main/java/com/ruoyi/system/mapper/SysUserMapper.java b/ruoyi-system/src/main/java/com/ruoyi/system/mapper/SysUserMapper.java
index bb854de..f132a51 100644
--- a/ruoyi-system/src/main/java/com/ruoyi/system/mapper/SysUserMapper.java
+++ b/ruoyi-system/src/main/java/com/ruoyi/system/mapper/SysUserMapper.java
@@ -138,4 +138,14 @@
*
*/
public List<SysUser> getSysUserByCarId(String carId);
+
+ List<SysUser> userByPlanId(String id);
+
+ List<SysUser> getOnlineCommander(String usersId);
+
+ List<SysUser> getOnlinePC(@Param("usersId") String usersId,@Param("onLinePCIdList")List<String> onLinePCIdList);
+
+ List<SysUser> getOwnAndChildrenOnlineSoilderList(@Param("deptIdList")List<Long> deptIdList);
+
+ List<SysUser> getOwnAndChildrenSoilderListAll(@Param("deptIdList")List<Long> deptIdList);
}
--
Gitblit v1.9.3