-- 流域管理模块菜单配置 -- 1. 添加流域管理主菜单 INSERT INTO "SYS_MENU" VALUES (2000, '流域管理', 0, 1, 'watershed', NULL, '', 1, 0, 'M', '0', '0', '', 'water', 'admin', sysdate, '', NULL, '流域管理目录'); -- 2. 添加流域平台子菜单 INSERT INTO "SYS_MENU" VALUES (2001, '流域平台', 2000, 1, 'hydrological', 'watershed/hydrological/index', '', 1, 0, 'C', '0', '0', 'watershed:hydrological:list', 'monitor', 'admin', sysdate, '', NULL, '流域管理平台菜单'); -- 3. 添加机电设备管理子菜单 INSERT INTO "SYS_MENU" VALUES (2002, '机电设备', 2000, 2, 'equipment', 'watershed/equipment/index', '', 1, 0, 'C', '0', '0', 'watershed:equipment:list', 'list', 'admin', sysdate, '', NULL, '机电设备管理菜单'); -- 4. 添加流域模型管理子菜单 INSERT INTO "SYS_MENU" VALUES (2003, '流域模型', 2000, 3, 'model', 'watershed/model/index', '', 1, 0, 'C', '0', '0', 'watershed:model:list', 'build', 'admin', sysdate, '', NULL, '流域模型管理菜单'); -- 5. 添加水利设施管理子菜单 INSERT INTO "SYS_MENU" VALUES (2004, '水利设施', 2000, 4, 'facility', 'watershed/facility/index', '', 1, 0, 'C', '0', '0', 'watershed:facility:list', 'tree', 'admin', sysdate, '', NULL, '水利设施管理菜单'); -- 6. 流域平台按钮权限 INSERT INTO "SYS_MENU" VALUES (2005, '流域平台查询', 2001, 1, '', '', '', 1, 0, 'F', '0', '0', 'watershed:hydrological:query', '#', 'admin', sysdate, '', NULL, ''); INSERT INTO "SYS_MENU" VALUES (2006, '流域平台新增', 2001, 2, '', '', '', 1, 0, 'F', '0', '0', 'watershed:hydrological:add', '#', 'admin', sysdate, '', NULL, ''); INSERT INTO "SYS_MENU" VALUES (2007, '流域平台修改', 2001, 3, '', '', '', 1, 0, 'F', '0', '0', 'watershed:hydrological:edit', '#', 'admin', sysdate, '', NULL, ''); INSERT INTO "SYS_MENU" VALUES (2008, '流域平台删除', 2001, 4, '', '', '', 1, 0, 'F', '0', '0', 'watershed:hydrological:remove', '#', 'admin', sysdate, '', NULL, ''); INSERT INTO "SYS_MENU" VALUES (2009, '流域平台导出', 2001, 5, '', '', '', 1, 0, 'F', '0', '0', 'watershed:hydrological:export', '#', 'admin', sysdate, '', NULL, ''); -- 7. 机电设备按钮权限 INSERT INTO "SYS_MENU" VALUES (2010, '机电设备查询', 2002, 1, '', '', '', 1, 0, 'F', '0', '0', 'watershed:equipment:query', '#', 'admin', sysdate, '', NULL, ''); INSERT INTO "SYS_MENU" VALUES (2011, '机电设备新增', 2002, 2, '', '', '', 1, 0, 'F', '0', '0', 'watershed:equipment:add', '#', 'admin', sysdate, '', NULL, ''); INSERT INTO "SYS_MENU" VALUES (2012, '机电设备修改', 2002, 3, '', '', '', 1, 0, 'F', '0', '0', 'watershed:equipment:edit', '#', 'admin', sysdate, '', NULL, ''); INSERT INTO "SYS_MENU" VALUES (2013, '机电设备删除', 2002, 4, '', '', '', 1, 0, 'F', '0', '0', 'watershed:equipment:remove', '#', 'admin', sysdate, '', NULL, ''); INSERT INTO "SYS_MENU" VALUES (2014, '机电设备导出', 2002, 5, '', '', '', 1, 0, 'F', '0', '0', 'watershed:equipment:export', '#', 'admin', sysdate, '', NULL, ''); INSERT INTO "SYS_MENU" VALUES (2015, '设备监控', 2002, 6, '', '', '', 1, 0, 'F', '0', '0', 'watershed:equipment:monitor', '#', 'admin', sysdate, '', NULL, ''); -- 8. 流域模型按钮权限 INSERT INTO "SYS_MENU" VALUES (2016, '流域模型查询', 2003, 1, '', '', '', 1, 0, 'F', '0', '0', 'watershed:model:query', '#', 'admin', sysdate, '', NULL, ''); INSERT INTO "SYS_MENU" VALUES (2017, '流域模型新增', 2003, 2, '', '', '', 1, 0, 'F', '0', '0', 'watershed:model:add', '#', 'admin', sysdate, '', NULL, ''); INSERT INTO "SYS_MENU" VALUES (2018, '流域模型修改', 2003, 3, '', '', '', 1, 0, 'F', '0', '0', 'watershed:model:edit', '#', 'admin', sysdate, '', NULL, ''); INSERT INTO "SYS_MENU" VALUES (2019, '流域模型删除', 2003, 4, '', '', '', 1, 0, 'F', '0', '0', 'watershed:model:remove', '#', 'admin', sysdate, '', NULL, ''); INSERT INTO "SYS_MENU" VALUES (2020, '流域模型导出', 2003, 5, '', '', '', 1, 0, 'F', '0', '0', 'watershed:model:export', '#', 'admin', sysdate, '', NULL, ''); INSERT INTO "SYS_MENU" VALUES (2021, '流域模型上传', 2003, 6, '', '', '', 1, 0, 'F', '0', '0', 'watershed:model:upload', '#', 'admin', sysdate, '', NULL, ''); -- 9. 水利设施按钮权限 INSERT INTO "SYS_MENU" VALUES (2022, '水利设施查询', 2004, 1, '', '', '', 1, 0, 'F', '0', '0', 'watershed:facility:query', '#', 'admin', sysdate, '', NULL, ''); INSERT INTO "SYS_MENU" VALUES (2023, '水利设施新增', 2004, 2, '', '', '', 1, 0, 'F', '0', '0', 'watershed:facility:add', '#', 'admin', sysdate, '', NULL, ''); INSERT INTO "SYS_MENU" VALUES (2024, '水利设施修改', 2004, 3, '', '', '', 1, 0, 'F', '0', '0', 'watershed:facility:edit', '#', 'admin', sysdate, '', NULL, ''); INSERT INTO "SYS_MENU" VALUES (2025, '水利设施删除', 2004, 4, '', '', '', 1, 0, 'F', '0', '0', 'watershed:facility:remove', '#', 'admin', sysdate, '', NULL, ''); INSERT INTO "SYS_MENU" VALUES (2026, '水利设施导出', 2004, 5, '', '', '', 1, 0, 'F', '0', '0', 'watershed:facility:export', '#', 'admin', sysdate, '', NULL, ''); -- 10. 给管理员角色分配流域管理权限 INSERT INTO "SYS_ROLE_MENU" VALUES (1, 2000); INSERT INTO "SYS_ROLE_MENU" VALUES (1, 2001); INSERT INTO "SYS_ROLE_MENU" VALUES (1, 2002); INSERT INTO "SYS_ROLE_MENU" VALUES (1, 2003); INSERT INTO "SYS_ROLE_MENU" VALUES (1, 2004); INSERT INTO "SYS_ROLE_MENU" VALUES (1, 2005); INSERT INTO "SYS_ROLE_MENU" VALUES (1, 2006); INSERT INTO "SYS_ROLE_MENU" VALUES (1, 2007); INSERT INTO "SYS_ROLE_MENU" VALUES (1, 2008); INSERT INTO "SYS_ROLE_MENU" VALUES (1, 2009); INSERT INTO "SYS_ROLE_MENU" VALUES (1, 2010); INSERT INTO "SYS_ROLE_MENU" VALUES (1, 2011); INSERT INTO "SYS_ROLE_MENU" VALUES (1, 2012); INSERT INTO "SYS_ROLE_MENU" VALUES (1, 2013); INSERT INTO "SYS_ROLE_MENU" VALUES (1, 2014); INSERT INTO "SYS_ROLE_MENU" VALUES (1, 2015); INSERT INTO "SYS_ROLE_MENU" VALUES (1, 2016); INSERT INTO "SYS_ROLE_MENU" VALUES (1, 2017); INSERT INTO "SYS_ROLE_MENU" VALUES (1, 2018); INSERT INTO "SYS_ROLE_MENU" VALUES (1, 2019); INSERT INTO "SYS_ROLE_MENU" VALUES (1, 2020); INSERT INTO "SYS_ROLE_MENU" VALUES (1, 2021); INSERT INTO "SYS_ROLE_MENU" VALUES (1, 2022); INSERT INTO "SYS_ROLE_MENU" VALUES (1, 2023); INSERT INTO "SYS_ROLE_MENU" VALUES (1, 2024); INSERT INTO "SYS_ROLE_MENU" VALUES (1, 2025); INSERT INTO "SYS_ROLE_MENU" VALUES (1, 2026);