mirror of
https://gitee.com/sdyunze/iotlink.git
synced 2026-10-31 18:21:54 +08:00
山东云则
45b73529ba
## 必须执行 SQL queryChildrenAreaInfo.sql ## 'queryChildrenAreaInfo.sql' 为 查询企业下子企业 查询函数 用来控制权限管理 执行该 SQL 需要 root 账号去执行 Signed-off-by: 山东云则 <fae@5iot.cn>
17 lines
530 B
Plaintext
17 lines
530 B
Plaintext
CREATE DEFINER=`root`@`%` FUNCTION `queryChildrenAreaInfo`(
|
|
`username_set` char(50) charset utf8mb4 collate utf8mb4_0900_ai_ci ) RETURNS varchar(16383) CHARSET utf8
|
|
SQL SECURITY INVOKER
|
|
BEGIN
|
|
|
|
DECLARE sTemp VARCHAR(16383);
|
|
DECLARE sTempChd VARCHAR(16383);
|
|
|
|
SET sTemp="";
|
|
SET sTempChd = CAST(username_set AS CHAR);
|
|
|
|
WHILE sTempChd IS NOT NULL DO
|
|
SET sTemp= CONCAT(sTemp,",",sTempChd);
|
|
SELECT GROUP_CONCAT(dept_id) INTO sTempChd FROM sys_dept WHERE FIND_IN_SET(parent_id,sTempChd)>0;
|
|
END WHILE;
|
|
RETURN sTemp;
|
|
END |