152 lines
18 KiB
SQL
152 lines
18 KiB
SQL
-- ----------------------------
|
|
-- 业务模块 菜单SQL
|
|
-- 包含：业务管理、财务合同管理、人事管理
|
|
-- 注意:
|
|
-- - 业务管理/财务合同管理: 菜单ID 2000-2999 (权限前缀: project:/biz:)
|
|
-- - 人事管理: 菜单ID 3000-3999 (权限前缀: hr:)
|
|
-- 请根据实际数据库最大ID调整
|
|
-- ----------------------------
|
|
|
|
-- ----------------------------
|
|
-- 清理旧菜单数据
|
|
-- ----------------------------
|
|
delete from sys_role_menu where menu_id between 2000 and 4200;
|
|
delete from sys_menu where menu_id between 2000 and 4200;
|
|
|
|
-- ----------------------------
|
|
-- 一级目录: 业务管理
|
|
-- ----------------------------
|
|
insert into sys_menu values('2000', '业务管理', '0', '10', 'business', null, '', 1, 0, 'M', '0', '0', '', 'briefcase', 103, 1, sysdate(), null, null, '业务管理目录');
|
|
|
|
-- 业务管理 - 二级菜单: 项目管理
|
|
insert into sys_menu values('2005', '项目管理', '2000', '1', 'project', 'project/project/index', '', 1, 0, 'C', '0', '0', 'biz:project:list', 'example', 103, 1, sysdate(), null, null, '项目管理菜单');
|
|
insert into sys_menu values('2051', '项目查询', '2005', '1', '', '', '', 1, 0, 'F', '0', '0', 'biz:project:query', '#', 103, 1, sysdate(), null, null, '');
|
|
insert into sys_menu values('2052', '项目新增', '2005', '2', '', '', '', 1, 0, 'F', '0', '0', 'biz:project:add', '#', 103, 1, sysdate(), null, null, '');
|
|
insert into sys_menu values('2053', '项目修改', '2005', '3', '', '', '', 1, 0, 'F', '0', '0', 'biz:project:edit', '#', 103, 1, sysdate(), null, null, '');
|
|
insert into sys_menu values('2054', '项目删除', '2005', '4', '', '', '', 1, 0, 'F', '0', '0', 'biz:project:remove', '#', 103, 1, sysdate(), null, null, '');
|
|
insert into sys_menu values('2055', '项目导出', '2005', '5', '', '', '', 1, 0, 'F', '0', '0', 'biz:project:export', '#', 103, 1, sysdate(), null, null, '');
|
|
insert into sys_menu values('2056', '项目导入', '2005', '6', '', '', '', 1, 0, 'F', '0', '0', 'biz:project:import', '#', 103, 1, sysdate(), null, null, '');
|
|
insert into sys_menu values('2057', '分配人员', '2005', '7', '', '', '', 1, 0, 'F', '0', '0', 'biz:projectPersonnel:add', '#', 103, 1, sysdate(), null, null, '');
|
|
insert into sys_menu values('2058', '查看人员', '2005', '8', '', '', '', 1, 0, 'F', '0', '0', 'biz:projectPersonnel:query', '#', 103, 1, sysdate(), null, null, '');
|
|
|
|
-- 业务管理 - 二级菜单: 项目人员管理
|
|
insert into sys_menu values('2090', '项目人员', '2005', '9', 'projectPersonnel', 'biz/projectPersonnel/index', '', 1, 0, 'C', '0', '0', 'biz:projectPersonnel:list', 'team', 103, 1, sysdate(), null, null, '项目人员管理菜单');
|
|
insert into sys_menu values('2091', '项目人员查询', '2090', '1', '', '', '', 1, 0, 'F', '0', '0', 'biz:projectPersonnel:query', '#', 103, 1, sysdate(), null, null, '');
|
|
insert into sys_menu values('2092', '项目人员新增', '2090', '2', '', '', '', 1, 0, 'F', '0', '0', 'biz:projectPersonnel:add', '#', 103, 1, sysdate(), null, null, '');
|
|
insert into sys_menu values('2093', '项目人员修改', '2090', '3', '', '', '', 1, 0, 'F', '0', '0', 'biz:projectPersonnel:edit', '#', 103, 1, sysdate(), null, null, '');
|
|
insert into sys_menu values('2094', '项目人员删除', '2090', '4', '', '', '', 1, 0, 'F', '0', '0', 'biz:projectPersonnel:remove', '#', 103, 1, sysdate(), null, null, '');
|
|
insert into sys_menu values('2095', '项目人员导出', '2090', '5', '', '', '', 1, 0, 'F', '0', '0', 'biz:projectPersonnel:export', '#', 103, 1, sysdate(), null, null, '');
|
|
|
|
-- 业务管理 - 二级菜单: 招投标管理
|
|
insert into sys_menu values('2008', '招投标管理', '2000', '2', 'bidding', 'project/bidding/index', '', 1, 0, 'C', '0', '0', 'biz:bidding:list', 'shop', 103, 1, sysdate(), null, null, '招投标管理菜单');
|
|
insert into sys_menu values('2081', '招投标查询', '2008', '1', '', '', '', 1, 0, 'F', '0', '0', 'biz:bidding:query', '#', 103, 1, sysdate(), null, null, '');
|
|
insert into sys_menu values('2082', '招投标新增', '2008', '2', '', '', '', 1, 0, 'F', '0', '0', 'biz:bidding:add', '#', 103, 1, sysdate(), null, null, '');
|
|
insert into sys_menu values('2083', '招投标修改', '2008', '3', '', '', '', 1, 0, 'F', '0', '0', 'biz:bidding:edit', '#', 103, 1, sysdate(), null, null, '');
|
|
insert into sys_menu values('2084', '招投标删除', '2008', '4', '', '', '', 1, 0, 'F', '0', '0', 'biz:bidding:remove', '#', 103, 1, sysdate(), null, null, '');
|
|
insert into sys_menu values('2085', '招投标导出', '2008', '5', '', '', '', 1, 0, 'F', '0', '0', 'biz:bidding:export', '#', 103, 1, sysdate(), null, null, '');
|
|
insert into sys_menu values('2086', '招投标导入', '2008', '6', '', '', '', 1, 0, 'F', '0', '0', 'biz:bidding:import', '#', 103, 1, sysdate(), null, null, '');
|
|
insert into sys_menu values('2087', '退保证金', '2008', '7', '', '', '', 1, 0, 'F', '0', '0', 'biz:bidding:return', '#', 103, 1, sysdate(), null, null, '');
|
|
|
|
-- 业务管理 - 二级菜单: 业绩案例管理
|
|
insert into sys_menu values('2004', '业绩案例管理', '2000', '3', 'performanceCase', 'project/performanceCase/index', '', 1, 0, 'C', '0', '0', 'biz:performanceCase:list', 'trophy', 103, 1, sysdate(), null, null, '业绩案例管理菜单');
|
|
insert into sys_menu values('2041', '业绩案例查询', '2004', '1', '', '', '', 1, 0, 'F', '0', '0', 'biz:performanceCase:query', '#', 103, 1, sysdate(), null, null, '');
|
|
insert into sys_menu values('2042', '业绩案例新增', '2004', '2', '', '', '', 1, 0, 'F', '0', '0', 'biz:performanceCase:add', '#', 103, 1, sysdate(), null, null, '');
|
|
insert into sys_menu values('2043', '业绩案例修改', '2004', '3', '', '', '', 1, 0, 'F', '0', '0', 'biz:performanceCase:edit', '#', 103, 1, sysdate(), null, null, '');
|
|
insert into sys_menu values('2044', '业绩案例删除', '2004', '4', '', '', '', 1, 0, 'F', '0', '0', 'biz:performanceCase:remove', '#', 103, 1, sysdate(), null, null, '');
|
|
insert into sys_menu values('2045', '业绩案例导出', '2004', '5', '', '', '', 1, 0, 'F', '0', '0', 'biz:performanceCase:export', '#', 103, 1, sysdate(), null, null, '');
|
|
insert into sys_menu values('2046', '业绩案例导入', '2004', '6', '', '', '', 1, 0, 'F', '0', '0', 'biz:performanceCase:import', '#', 103, 1, sysdate(), null, null, '');
|
|
|
|
-- 业务管理 - 二级菜单: 项目统计看板
|
|
insert into sys_menu values('2009', '项目统计看板', '2000', '9', 'statistics', 'project/statistics/index', '', 1, 0, 'C', '0', '0', 'biz:project:list', 'dashboard', 103, 1, sysdate(), null, null, '项目统计看板菜单');
|
|
insert into sys_menu values('2110', '统计查询', '2009', '1', '', '', '', 1, 0, 'F', '0', '0', 'biz:project:query', '#', 103, 1, sysdate(), null, null, '');
|
|
|
|
-- ----------------------------
|
|
-- 一级目录: 财务合同管理
|
|
-- ----------------------------
|
|
insert into sys_menu values('2010', '财务合同管理', '0', '11', 'finance', null, '', 1, 0, 'M', '0', '0', '', 'money', 103, 1, sysdate(), null, null, '财务合同管理目录');
|
|
|
|
-- 财务合同管理 - 二级菜单: 合同管理
|
|
insert into sys_menu values('2001', '合同管理', '2010', '1', 'contract', 'project/contract/index', '', 1, 0, 'C', '0', '0', 'biz:contract:list', 'document', 103, 1, sysdate(), null, null, '合同管理菜单');
|
|
insert into sys_menu values('2011', '合同查询', '2001', '1', '', '', '', 1, 0, 'F', '0', '0', 'biz:contract:query', '#', 103, 1, sysdate(), null, null, '');
|
|
insert into sys_menu values('2012', '合同新增', '2001', '2', '', '', '', 1, 0, 'F', '0', '0', 'biz:contract:add', '#', 103, 1, sysdate(), null, null, '');
|
|
insert into sys_menu values('2013', '合同修改', '2001', '3', '', '', '', 1, 0, 'F', '0', '0', 'biz:contract:edit', '#', 103, 1, sysdate(), null, null, '');
|
|
insert into sys_menu values('2014', '合同删除', '2001', '4', '', '', '', 1, 0, 'F', '0', '0', 'biz:contract:remove', '#', 103, 1, sysdate(), null, null, '');
|
|
insert into sys_menu values('2015', '合同导出', '2001', '5', '', '', '', 1, 0, 'F', '0', '0', 'biz:contract:export', '#', 103, 1, sysdate(), null, null, '');
|
|
|
|
-- 财务合同管理 - 二级菜单: 发票管理
|
|
insert into sys_menu values('2003', '发票管理', '2010', '3', 'invoice', 'project/invoice/index', '', 1, 0, 'C', '0', '0', 'biz:invoice:list', 'ticket', 103, 1, sysdate(), null, null, '发票管理菜单');
|
|
insert into sys_menu values('2031', '发票查询', '2003', '1', '', '', '', 1, 0, 'F', '0', '0', 'biz:invoice:query', '#', 103, 1, sysdate(), null, null, '');
|
|
insert into sys_menu values('2032', '发票新增', '2003', '2', '', '', '', 1, 0, 'F', '0', '0', 'biz:invoice:add', '#', 103, 1, sysdate(), null, null, '');
|
|
insert into sys_menu values('2033', '发票修改', '2003', '3', '', '', '', 1, 0, 'F', '0', '0', 'biz:invoice:edit', '#', 103, 1, sysdate(), null, null, '');
|
|
insert into sys_menu values('2034', '发票删除', '2003', '4', '', '', '', 1, 0, 'F', '0', '0', 'biz:invoice:remove', '#', 103, 1, sysdate(), null, null, '');
|
|
insert into sys_menu values('2035', '发票导出', '2003', '5', '', '', '', 1, 0, 'F', '0', '0', 'biz:invoice:export', '#', 103, 1, sysdate(), null, null, '');
|
|
insert into sys_menu values('2036', '确认付款', '2003', '6', '', '', '', 1, 0, 'F', '0', '0', 'biz:invoice:payment', '#', 103, 1, sysdate(), null, null, '');
|
|
|
|
-- 财务合同管理 - 二级菜单: 结算管理
|
|
insert into sys_menu values('2006', '结算管理', '2010', '4', 'settlement', 'project/settlement/index', '', 1, 0, 'C', '0', '0', 'biz:settlement:list', 'calculator', 103, 1, sysdate(), null, null, '结算管理菜单');
|
|
insert into sys_menu values('2061', '结算查询', '2006', '1', '', '', '', 1, 0, 'F', '0', '0', 'biz:settlement:query', '#', 103, 1, sysdate(), null, null, '');
|
|
insert into sys_menu values('2062', '结算新增', '2006', '2', '', '', '', 1, 0, 'F', '0', '0', 'biz:settlement:add', '#', 103, 1, sysdate(), null, null, '');
|
|
insert into sys_menu values('2063', '结算修改', '2006', '3', '', '', '', 1, 0, 'F', '0', '0', 'biz:settlement:edit', '#', 103, 1, sysdate(), null, null, '');
|
|
insert into sys_menu values('2064', '结算删除', '2006', '4', '', '', '', 1, 0, 'F', '0', '0', 'biz:settlement:remove', '#', 103, 1, sysdate(), null, null, '');
|
|
insert into sys_menu values('2065', '结算导出', '2006', '5', '', '', '', 1, 0, 'F', '0', '0', 'biz:settlement:export', '#', 103, 1, sysdate(), null, null, '');
|
|
insert into sys_menu values('2066', '确认付款', '2006', '6', '', '', '', 1, 0, 'F', '0', '0', 'biz:settlement:payment', '#', 103, 1, sysdate(), null, null, '');
|
|
|
|
-- 财务合同管理 - 二级菜单: 报销管理
|
|
insert into sys_menu values('2007', '报销管理', '2010', '5', 'reimbursement', 'project/reimbursement/index', '', 1, 0, 'C', '0', '0', 'biz:reimbursement:list', 'transaction', 103, 1, sysdate(), null, null, '报销管理菜单');
|
|
insert into sys_menu values('2071', '报销查询', '2007', '1', '', '', '', 1, 0, 'F', '0', '0', 'biz:reimbursement:query', '#', 103, 1, sysdate(), null, null, '');
|
|
insert into sys_menu values('2072', '报销新增', '2007', '2', '', '', '', 1, 0, 'F', '0', '0', 'biz:reimbursement:add', '#', 103, 1, sysdate(), null, null, '');
|
|
insert into sys_menu values('2073', '报销修改', '2007', '3', '', '', '', 1, 0, 'F', '0', '0', 'biz:reimbursement:edit', '#', 103, 1, sysdate(), null, null, '');
|
|
insert into sys_menu values('2074', '报销删除', '2007', '4', '', '', '', 1, 0, 'F', '0', '0', 'biz:reimbursement:remove', '#', 103, 1, sysdate(), null, null, '');
|
|
insert into sys_menu values('2075', '报销导出', '2007', '5', '', '', '', 1, 0, 'F', '0', '0', 'biz:reimbursement:export', '#', 103, 1, sysdate(), null, null, '');
|
|
insert into sys_menu values('2076', '报销发放', '2007', '6', '', '', '', 1, 0, 'F', '0', '0', 'biz:reimbursement:grant', '#', 103, 1, sysdate(), null, null, '');
|
|
insert into sys_menu values('2077', '报销导入', '2007', '7', '', '', '', 1, 0, 'F', '0', '0', 'biz:reimbursement:import', '#', 103, 1, sysdate(), null, null, '');
|
|
|
|
-- 财务合同管理 - 二级菜单: 附件管理
|
|
insert into sys_menu values('2100', '附件管理', '2010', '6', 'attachment', 'project/attachment/index', '', 1, 0, 'C', '0', '0', 'biz:attachment:list', 'paper-clip', 103, 1, sysdate(), null, null, '业务附件管理菜单');
|
|
insert into sys_menu values('2101', '附件查询', '2100', '1', '', '', '', 1, 0, 'F', '0', '0', 'biz:attachment:query', '#', 103, 1, sysdate(), null, null, '');
|
|
insert into sys_menu values('2102', '附件新增', '2100', '2', '', '', '', 1, 0, 'F', '0', '0', 'biz:attachment:add', '#', 103, 1, sysdate(), null, null, '');
|
|
insert into sys_menu values('2103', '附件修改', '2100', '3', '', '', '', 1, 0, 'F', '0', '0', 'biz:attachment:edit', '#', 103, 1, sysdate(), null, null, '');
|
|
insert into sys_menu values('2104', '附件删除', '2100', '4', '', '', '', 1, 0, 'F', '0', '0', 'biz:attachment:remove', '#', 103, 1, sysdate(), null, null, '');
|
|
insert into sys_menu values('2105', '附件下载', '2100', '5', '', '', '', 1, 0, 'F', '0', '0', 'biz:attachment:download', '#', 103, 1, sysdate(), null, null, '');
|
|
|
|
-- ----------------------------
|
|
-- 一级目录: 人事管理
|
|
-- ----------------------------
|
|
insert into sys_menu values('3000', '人事管理', '0', '20', 'hr', null, '', 1, 0, 'M', '0', '0', '', 'team', 103, 1, sysdate(), null, null, '人事管理目录');
|
|
|
|
-- 人事管理 - 二级菜单: 候选人管理
|
|
insert into sys_menu values('3001', '候选人管理', '3000', '1', 'candidate', 'hr/candidate/index', '', 1, 0, 'C', '0', '0', 'hr:candidate:list', 'user-add', 103, 1, sysdate(), null, null, '候选人管理菜单');
|
|
insert into sys_menu values('3011', '候选人查询', '3001', '1', '', '', '', 1, 0, 'F', '0', '0', 'hr:candidate:query', '#', 103, 1, sysdate(), null, null, '');
|
|
insert into sys_menu values('3012', '候选人新增', '3001', '2', '', '', '', 1, 0, 'F', '0', '0', 'hr:candidate:add', '#', 103, 1, sysdate(), null, null, '');
|
|
insert into sys_menu values('3013', '候选人修改', '3001', '3', '', '', '', 1, 0, 'F', '0', '0', 'hr:candidate:edit', '#', 103, 1, sysdate(), null, null, '');
|
|
insert into sys_menu values('3014', '候选人删除', '3001', '4', '', '', '', 1, 0, 'F', '0', '0', 'hr:candidate:remove', '#', 103, 1, sysdate(), null, null, '');
|
|
insert into sys_menu values('3015', '候选人导出', '3001', '5', '', '', '', 1, 0, 'F', '0', '0', 'hr:candidate:export', '#', 103, 1, sysdate(), null, null, '');
|
|
insert into sys_menu values('3016', '候选人导入', '3001', '6', '', '', '', 1, 0, 'F', '0', '0', 'hr:candidate:import', '#', 103, 1, sysdate(), null, null, '');
|
|
|
|
-- 人事管理 - 二级菜单: 员工管理
|
|
insert into sys_menu values('3002', '员工管理', '3000', '2', 'employee', 'hr/employee/index', '', 1, 0, 'C', '0', '0', 'hr:employee:list', 'user', 103, 1, sysdate(), null, null, '员工管理菜单');
|
|
insert into sys_menu values('3021', '员工查询', '3002', '1', '', '', '', 1, 0, 'F', '0', '0', 'hr:employee:query', '#', 103, 1, sysdate(), null, null, '');
|
|
insert into sys_menu values('3022', '员工新增', '3002', '2', '', '', '', 1, 0, 'F', '0', '0', 'hr:employee:add', '#', 103, 1, sysdate(), null, null, '');
|
|
insert into sys_menu values('3023', '员工修改', '3002', '3', '', '', '', 1, 0, 'F', '0', '0', 'hr:employee:edit', '#', 103, 1, sysdate(), null, null, '');
|
|
insert into sys_menu values('3024', '员工删除', '3002', '4', '', '', '', 1, 0, 'F', '0', '0', 'hr:employee:remove', '#', 103, 1, sysdate(), null, null, '');
|
|
insert into sys_menu values('3025', '员工导出', '3002', '5', '', '', '', 1, 0, 'F', '0', '0', 'hr:employee:export', '#', 103, 1, sysdate(), null, null, '');
|
|
insert into sys_menu values('3026', '员工导入', '3002', '6', '', '', '', 1, 0, 'F', '0', '0', 'hr:employee:import', '#', 103, 1, sysdate(), null, null, '');
|
|
|
|
-- 人事管理 - 二级菜单: 工资管理
|
|
insert into sys_menu values('3003', '工资管理', '3000', '3', 'salary', 'hr/salary/index', '', 1, 0, 'C', '0', '0', 'hr:salary:list', 'money', 103, 1, sysdate(), null, null, '工资管理菜单');
|
|
insert into sys_menu values('3031', '工资查询', '3003', '1', '', '', '', 1, 0, 'F', '0', '0', 'hr:salary:query', '#', 103, 1, sysdate(), null, null, '');
|
|
insert into sys_menu values('3032', '工资新增', '3003', '2', '', '', '', 1, 0, 'F', '0', '0', 'hr:salary:add', '#', 103, 1, sysdate(), null, null, '');
|
|
insert into sys_menu values('3033', '工资修改', '3003', '3', '', '', '', 1, 0, 'F', '0', '0', 'hr:salary:edit', '#', 103, 1, sysdate(), null, null, '');
|
|
insert into sys_menu values('3034', '工资删除', '3003', '4', '', '', '', 1, 0, 'F', '0', '0', 'hr:salary:remove', '#', 103, 1, sysdate(), null, null, '');
|
|
insert into sys_menu values('3035', '工资导出', '3003', '5', '', '', '', 1, 0, 'F', '0', '0', 'hr:salary:export', '#', 103, 1, sysdate(), null, null, '');
|
|
insert into sys_menu values('3036', '工资导入', '3003', '6', '', '', '', 1, 0, 'F', '0', '0', 'hr:salary:import', '#', 103, 1, sysdate(), null, null, '');
|
|
|
|
-- 人事管理 - 二级菜单: 五险一金管理
|
|
insert into sys_menu values('3004', '五险一金管理', '3000', '4', 'socialSecurity', 'hr/socialSecurity/index', '', 1, 0, 'C', '0', '0', 'hr:socialSecurity:list', 'bank', 103, 1, sysdate(), null, null, '五险一金管理菜单');
|
|
insert into sys_menu values('3041', '五险一金查询', '3004', '1', '', '', '', 1, 0, 'F', '0', '0', 'hr:socialSecurity:query', '#', 103, 1, sysdate(), null, null, '');
|
|
insert into sys_menu values('3042', '五险一金新增', '3004', '2', '', '', '', 1, 0, 'F', '0', '0', 'hr:socialSecurity:add', '#', 103, 1, sysdate(), null, null, '');
|
|
insert into sys_menu values('3043', '五险一金修改', '3004', '3', '', '', '', 1, 0, 'F', '0', '0', 'hr:socialSecurity:edit', '#', 103, 1, sysdate(), null, null, '');
|
|
insert into sys_menu values('3044', '五险一金删除', '3004', '4', '', '', '', 1, 0, 'F', '0', '0', 'hr:socialSecurity:remove', '#', 103, 1, sysdate(), null, null, '');
|
|
insert into sys_menu values('3045', '五险一金导出', '3004', '5', '', '', '', 1, 0, 'F', '0', '0', 'hr:socialSecurity:export', '#', 103, 1, sysdate(), null, null, '');
|
|
insert into sys_menu values('3046', '五险一金导入', '3004', '6', '', '', '', 1, 0, 'F', '0', '0', 'hr:socialSecurity:import', '#', 103, 1, sysdate(), null, null, '');
|