1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
| -- 空调多联机模块权限（防重复 INSERT）
|
| INSERT INTO `SYSTEM_PERMISSION`(`CODE`, `NAME`, `REMARK`, `FIXED`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `DELETED`)
| SELECT 'business:ywconditioner:sync', '同步空调内机', '', 0, 1, CURRENT_TIMESTAMP, NULL, NULL, 0
| WHERE NOT EXISTS (SELECT 1 FROM `SYSTEM_PERMISSION` WHERE `CODE` = 'business:ywconditioner:sync' AND `DELETED` = 0);
|
| INSERT INTO `SYSTEM_PERMISSION`(`CODE`, `NAME`, `REMARK`, `FIXED`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `DELETED`)
| SELECT 'business:ywconditioner:operate', '空调内机控制', '', 0, 1, CURRENT_TIMESTAMP, NULL, NULL, 0
| WHERE NOT EXISTS (SELECT 1 FROM `SYSTEM_PERMISSION` WHERE `CODE` = 'business:ywconditioner:operate' AND `DELETED` = 0);
|
| INSERT INTO `SYSTEM_PERMISSION`(`CODE`, `NAME`, `REMARK`, `FIXED`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `DELETED`)
| SELECT 'business:ywconditionergateway:query', '查询网关', '', 0, 1, CURRENT_TIMESTAMP, NULL, NULL, 0
| WHERE NOT EXISTS (SELECT 1 FROM `SYSTEM_PERMISSION` WHERE `CODE` = 'business:ywconditionergateway:query' AND `DELETED` = 0);
|
| INSERT INTO `SYSTEM_PERMISSION`(`CODE`, `NAME`, `REMARK`, `FIXED`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `DELETED`)
| SELECT 'business:ywconditionergateway:sync', '同步网关', '', 0, 1, CURRENT_TIMESTAMP, NULL, NULL, 0
| WHERE NOT EXISTS (SELECT 1 FROM `SYSTEM_PERMISSION` WHERE `CODE` = 'business:ywconditionergateway:sync' AND `DELETED` = 0);
|
| INSERT INTO `SYSTEM_PERMISSION`(`CODE`, `NAME`, `REMARK`, `FIXED`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `DELETED`)
| SELECT 'business:ywconditionermeter:query', '查询电表', '', 0, 1, CURRENT_TIMESTAMP, NULL, NULL, 0
| WHERE NOT EXISTS (SELECT 1 FROM `SYSTEM_PERMISSION` WHERE `CODE` = 'business:ywconditionermeter:query' AND `DELETED` = 0);
|
| INSERT INTO `SYSTEM_PERMISSION`(`CODE`, `NAME`, `REMARK`, `FIXED`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `DELETED`)
| SELECT 'business:ywconditionermeter:sync', '同步电表', '', 0, 1, CURRENT_TIMESTAMP, NULL, NULL, 0
| WHERE NOT EXISTS (SELECT 1 FROM `SYSTEM_PERMISSION` WHERE `CODE` = 'business:ywconditionermeter:sync' AND `DELETED` = 0);
|
| INSERT INTO `SYSTEM_PERMISSION`(`CODE`, `NAME`, `REMARK`, `FIXED`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `DELETED`)
| SELECT 'business:ywconditionermeter:operate', '电表查量查功率', '', 0, 1, CURRENT_TIMESTAMP, NULL, NULL, 0
| WHERE NOT EXISTS (SELECT 1 FROM `SYSTEM_PERMISSION` WHERE `CODE` = 'business:ywconditionermeter:operate' AND `DELETED` = 0);
|
| INSERT INTO `SYSTEM_PERMISSION`(`CODE`, `NAME`, `REMARK`, `FIXED`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `DELETED`)
| SELECT 'business:ywconditionerbilling:query', '查询计费系数', '', 0, 1, CURRENT_TIMESTAMP, NULL, NULL, 0
| WHERE NOT EXISTS (SELECT 1 FROM `SYSTEM_PERMISSION` WHERE `CODE` = 'business:ywconditionerbilling:query' AND `DELETED` = 0);
|
| INSERT INTO `SYSTEM_PERMISSION`(`CODE`, `NAME`, `REMARK`, `FIXED`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `DELETED`)
| SELECT 'business:ywconditionerbilling:sync', '同步计费系数', '', 0, 1, CURRENT_TIMESTAMP, NULL, NULL, 0
| WHERE NOT EXISTS (SELECT 1 FROM `SYSTEM_PERMISSION` WHERE `CODE` = 'business:ywconditionerbilling:sync' AND `DELETED` = 0);
|
| INSERT INTO `SYSTEM_PERMISSION`(`CODE`, `NAME`, `REMARK`, `FIXED`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `DELETED`)
| SELECT 'business:ywconditioneractions:query', '查询控制记录', '', 0, 1, CURRENT_TIMESTAMP, NULL, NULL, 0
| WHERE NOT EXISTS (SELECT 1 FROM `SYSTEM_PERMISSION` WHERE `CODE` = 'business:ywconditioneractions:query' AND `DELETED` = 0);
|
| INSERT INTO `SYSTEM_PERMISSION`(`CODE`, `NAME`, `REMARK`, `FIXED`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `DELETED`)
| SELECT 'business:ywconditioneractions:exportExcel', '导出控制记录', '', 0, 1, CURRENT_TIMESTAMP, NULL, NULL, 0
| WHERE NOT EXISTS (SELECT 1 FROM `SYSTEM_PERMISSION` WHERE `CODE` = 'business:ywconditioneractions:exportExcel' AND `DELETED` = 0);
|
| INSERT INTO `SYSTEM_PERMISSION`(`CODE`, `NAME`, `REMARK`, `FIXED`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `DELETED`)
| SELECT 'business:ywconditionerreport:query', '查询用量报表', '', 0, 1, CURRENT_TIMESTAMP, NULL, NULL, 0
| WHERE NOT EXISTS (SELECT 1 FROM `SYSTEM_PERMISSION` WHERE `CODE` = 'business:ywconditionerreport:query' AND `DELETED` = 0);
|
| INSERT INTO `SYSTEM_PERMISSION`(`CODE`, `NAME`, `REMARK`, `FIXED`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `DELETED`)
| SELECT 'business:ywconditionerreport:sync', '同步用量数据', '', 0, 1, CURRENT_TIMESTAMP, NULL, NULL, 0
| WHERE NOT EXISTS (SELECT 1 FROM `SYSTEM_PERMISSION` WHERE `CODE` = 'business:ywconditionerreport:sync' AND `DELETED` = 0);
|
| INSERT INTO `SYSTEM_PERMISSION`(`CODE`, `NAME`, `REMARK`, `FIXED`, `CREATE_USER`, `CREATE_TIME`, `UPDATE_USER`, `UPDATE_TIME`, `DELETED`)
| SELECT 'business:ywconditionerreport:exportExcel', '导出用量报表', '', 0, 1, CURRENT_TIMESTAMP, NULL, NULL, 0
| WHERE NOT EXISTS (SELECT 1 FROM `SYSTEM_PERMISSION` WHERE `CODE` = 'business:ywconditionerreport:exportExcel' AND `DELETED` = 0);
|
| -- 超级管理员：全部权限
| INSERT INTO `SYSTEM_ROLE_PERMISSION` (`ROLE_ID`, `PERMISSION_ID`, `CREATE_TIME`, `UPDATE_TIME`, `CREATE_USER`, `UPDATE_USER`, `DELETED`)
| SELECT r.`ID`, p.`ID`, CURRENT_TIMESTAMP, NULL, 1, NULL, 0
| FROM `SYSTEM_ROLE` r
| INNER JOIN `SYSTEM_PERMISSION` p ON p.`CODE` IN (
| 'business:ywconditioner:query',
| 'business:ywconditioner:create',
| 'business:ywconditioner:update',
| 'business:ywconditioner:delete',
| 'business:ywconditioner:exportExcel',
| 'business:ywconditioner:sync',
| 'business:ywconditioner:operate',
| 'business:ywconditionergateway:query',
| 'business:ywconditionergateway:sync',
| 'business:ywconditionermeter:query',
| 'business:ywconditionermeter:sync',
| 'business:ywconditionermeter:operate',
| 'business:ywconditionerbilling:query',
| 'business:ywconditionerbilling:sync',
| 'business:ywconditioneractions:query',
| 'business:ywconditioneractions:exportExcel',
| 'business:ywconditionerreport:query',
| 'business:ywconditionerreport:sync',
| 'business:ywconditionerreport:exportExcel'
| ) AND p.`DELETED` = 0
| WHERE r.`DELETED` = 0 AND (r.`CODE` = 'admin' OR r.`NAME` IN ('超级管理员', '管理员'))
| AND NOT EXISTS (
| SELECT 1 FROM `SYSTEM_ROLE_PERMISSION` rp
| WHERE rp.`ROLE_ID` = r.`ID` AND rp.`PERMISSION_ID` = p.`ID` AND rp.`DELETED` = 0
| );
|
|
