-- 项目管理系统新流程升级脚本 -- 适用库:product-inventory-management-xmgl -- 说明:执行前先做全库备份。本脚本不删除原业务数据,可重复执行。 SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; DROP PROCEDURE IF EXISTS `add_column_if_missing`; DELIMITER $$ CREATE PROCEDURE `add_column_if_missing`( IN p_table varchar(64), IN p_column varchar(64), IN p_definition varchar(1000) ) BEGIN IF NOT EXISTS ( SELECT 1 FROM information_schema.COLUMNS WHERE TABLE_SCHEMA=DATABASE() AND TABLE_NAME=p_table AND COLUMN_NAME=p_column ) THEN SET @ddl=CONCAT('ALTER TABLE `',p_table,'` ADD COLUMN `',p_column,'` ',p_definition); PREPARE stmt FROM @ddl; EXECUTE stmt; DEALLOCATE PREPARE stmt; END IF; END$$ DELIMITER ; CALL add_column_if_missing('project_management_info','project_leader_id',"bigint DEFAULT NULL COMMENT '项目负责人ID'"); CALL add_column_if_missing('project_management_info','project_leader_name',"varchar(100) DEFAULT NULL COMMENT '项目负责人'"); CALL add_column_if_missing('project_management_info','project_manager_ids',"json DEFAULT NULL COMMENT '项目经理ID数组'"); CALL add_column_if_missing('project_management_info','project_manager_names',"json DEFAULT NULL COMMENT '项目经理名称数组'"); -- 新版的“立项”是开始前的信息准备活动,开始后统一进入“开发”阶段。 UPDATE project_management_info SET current_phase = '开发' WHERE current_phase = '立项' AND is_delete = 0; CALL add_column_if_missing('project_management_info','follow_cycle',"varchar(20) DEFAULT 'MONTH' COMMENT 'MONTH每月 QUARTER每季度 YEAR每年'"); CALL add_column_if_missing('project_management_info','follow_detail',"varchar(1000) DEFAULT NULL COMMENT '跟进要求说明'"); CALL add_column_if_missing('project_management_info','current_phase',"varchar(30) DEFAULT '未开始' COMMENT '未开始/立项/开发/申报/申报结果/验收'"); CALL add_column_if_missing('project_management_info','source_business_id',"bigint DEFAULT NULL COMMENT '来源业务ID'"); ALTER TABLE `project_management_info` MODIFY COLUMN `project_management_plan_id` bigint DEFAULT NULL COMMENT '旧计划模板ID(新流程不再必填)'; CREATE TABLE IF NOT EXISTS `project_management_category` ( `id` bigint NOT NULL AUTO_INCREMENT, `parent_id` bigint NOT NULL DEFAULT 0, `category_name` varchar(100) NOT NULL, `sort` int NOT NULL DEFAULT 0, `remark` varchar(500) DEFAULT NULL, `is_deleted` tinyint NOT NULL DEFAULT 0, `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`), KEY `idx_project_category_parent` (`parent_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='项目多级分类'; CREATE TABLE IF NOT EXISTS `project_management_module` ( `id` bigint NOT NULL AUTO_INCREMENT, `project_id` bigint NOT NULL, `module_name` varchar(200) NOT NULL, `planned_start_date` date DEFAULT NULL, `summary` varchar(1000) DEFAULT NULL, `project_weight` decimal(7,2) NOT NULL DEFAULT 0 COMMENT '模块占项目工作量百分比', `current_progress` decimal(7,2) NOT NULL DEFAULT 0 COMMENT '模块最新进度百分比', `is_deleted` tinyint NOT NULL DEFAULT 0, `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`), KEY `idx_project_module_project` (`project_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='项目模块'; CREATE TABLE IF NOT EXISTS `project_management_module_member` ( `id` bigint NOT NULL AUTO_INCREMENT, `module_id` bigint NOT NULL, `user_id` bigint NOT NULL, `user_name` varchar(100) NOT NULL, `module_share` decimal(7,2) NOT NULL DEFAULT 0 COMMENT '兼容旧数据,新流程不在模块设置中填写', `is_deleted` tinyint NOT NULL DEFAULT 0, `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`), KEY `idx_module_member_module` (`module_id`), KEY `idx_module_member_user` (`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='项目模块执行人'; CREATE TABLE IF NOT EXISTS `project_management_follow_up` ( `id` bigint NOT NULL AUTO_INCREMENT, `project_id` bigint NOT NULL, `follow_date` date NOT NULL, `detail` varchar(2000) NOT NULL, `attachments` json DEFAULT NULL, `create_user_id` bigint DEFAULT NULL, `create_user_name` varchar(100) DEFAULT NULL, `is_deleted` tinyint NOT NULL DEFAULT 0, `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`), KEY `idx_project_follow_project` (`project_id`,`follow_date`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='项目周期跟进'; CREATE TABLE IF NOT EXISTS `project_management_progress_report` ( `id` bigint NOT NULL AUTO_INCREMENT, `project_id` bigint NOT NULL, `module_id` bigint NOT NULL, `reporter_ids` json NOT NULL, `reporter_names` json NOT NULL, `reporter_shares` json DEFAULT NULL COMMENT '本次汇报人员及工作量比重', `progress` decimal(7,2) NOT NULL, `report_date` date NOT NULL, `remark` varchar(2000) DEFAULT NULL, `attachments` json DEFAULT NULL, `is_deleted` tinyint NOT NULL DEFAULT 0, `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`), KEY `idx_progress_report_project` (`project_id`,`report_date`), KEY `idx_progress_report_module` (`module_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='项目模块进度汇报'; CALL add_column_if_missing('project_management_progress_report','reporter_shares',"json DEFAULT NULL COMMENT '本次汇报人员及工作量比重'"); DROP PROCEDURE IF EXISTS `add_column_if_missing`; CREATE TABLE IF NOT EXISTS `project_management_material` ( `id` bigint NOT NULL AUTO_INCREMENT, `project_id` bigint NOT NULL, `material_name` varchar(200) NOT NULL, `material_type` varchar(50) DEFAULT NULL, `remark` varchar(1000) DEFAULT NULL, `attachments` json DEFAULT NULL, `create_user_id` bigint DEFAULT NULL, `create_user_name` varchar(100) DEFAULT NULL, `is_deleted` tinyint NOT NULL DEFAULT 0, `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`), KEY `idx_project_material_project` (`project_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='项目整体资料库'; CREATE TABLE IF NOT EXISTS `project_management_phase` ( `id` bigint NOT NULL AUTO_INCREMENT, `project_id` bigint NOT NULL, `phase_code` varchar(30) NOT NULL, `phase_name` varchar(50) NOT NULL, `phase_order` int NOT NULL, `status` varchar(20) NOT NULL DEFAULT 'NOT_STARTED' COMMENT 'NOT_STARTED/IN_PROGRESS/COMPLETED', `form_data` json DEFAULT NULL COMMENT '阶段对应业务信息', `remark` varchar(2000) DEFAULT NULL, `attachments` json DEFAULT NULL, `completed_time` datetime DEFAULT NULL, `update_user_name` varchar(100) DEFAULT NULL, `is_deleted` tinyint NOT NULL DEFAULT 0, `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`), UNIQUE KEY `uk_project_phase` (`project_id`,`phase_code`), KEY `idx_project_phase_order` (`project_id`,`phase_order`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='项目立项、开发、申报、申报结果、验收流程'; CREATE TABLE IF NOT EXISTS `government_policy_file` ( `id` bigint NOT NULL AUTO_INCREMENT, `policy_name` varchar(255) NOT NULL, `publish_date` date DEFAULT NULL, `policy_url` varchar(1000) DEFAULT NULL, `attachments` json DEFAULT NULL, `maintainer_name` varchar(100) DEFAULT NULL, `remark` varchar(1000) DEFAULT NULL, `is_deleted` tinyint NOT NULL DEFAULT 0, `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`), KEY `idx_policy_publish_date` (`publish_date`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='政府政策文件'; -- 五阶段模板:立项 → 开发 → 申报 → 申报结果 → 验收。 INSERT INTO `project_management_plan` (`name`,`description`,`is_delete`,`create_time`,`update_time`,`create_user_name`) SELECT '项目五阶段','立项、开发、申报、申报结果、验收顺序推进',0,NOW(),NOW(),'升级脚本' WHERE NOT EXISTS (SELECT 1 FROM `project_management_plan` WHERE `name`='项目五阶段' AND `is_delete`=0); SET @five_stage_plan_id=(SELECT id FROM project_management_plan WHERE name='项目五阶段' AND is_delete=0 ORDER BY id LIMIT 1); INSERT INTO project_management_plan_node(project_management_plan_id,sort,name,estimated_duration,work_content,is_delete,create_time,update_time,create_user_name) SELECT @five_stage_plan_id,1,'立项',1,'完善项目基本情况、分类、负责人、经理、周期和模块',0,NOW(),NOW(),'升级脚本' WHERE NOT EXISTS (SELECT 1 FROM project_management_plan_node WHERE project_management_plan_id=@five_stage_plan_id AND name='立项' AND is_delete=0); INSERT INTO project_management_plan_node(project_management_plan_id,sort,name,estimated_duration,work_content,is_delete,create_time,update_time,create_user_name) SELECT @five_stage_plan_id,2,'开发',1,'开展项目跟进、进度汇报、统计和资料维护',0,NOW(),NOW(),'升级脚本' WHERE NOT EXISTS (SELECT 1 FROM project_management_plan_node WHERE project_management_plan_id=@five_stage_plan_id AND name='开发' AND is_delete=0); INSERT INTO project_management_plan_node(project_management_plan_id,sort,name,estimated_duration,work_content,is_delete,create_time,update_time,create_user_name) SELECT @five_stage_plan_id,3,'申报',1,'填写项目申报信息并上传申报文件',0,NOW(),NOW(),'升级脚本' WHERE NOT EXISTS (SELECT 1 FROM project_management_plan_node WHERE project_management_plan_id=@five_stage_plan_id AND name='申报' AND is_delete=0); INSERT INTO project_management_plan_node(project_management_plan_id,sort,name,estimated_duration,work_content,is_delete,create_time,update_time,create_user_name) SELECT @five_stage_plan_id,4,'申报结果',1,'登记申报结果并上传结果文件',0,NOW(),NOW(),'升级脚本' WHERE NOT EXISTS (SELECT 1 FROM project_management_plan_node WHERE project_management_plan_id=@five_stage_plan_id AND name='申报结果' AND is_delete=0); INSERT INTO project_management_plan_node(project_management_plan_id,sort,name,estimated_duration,work_content,is_delete,create_time,update_time,create_user_name) SELECT @five_stage_plan_id,5,'验收',1,'填写验收信息、上传验收文件并归档',0,NOW(),NOW(),'升级脚本' WHERE NOT EXISTS (SELECT 1 FROM project_management_plan_node WHERE project_management_plan_id=@five_stage_plan_id AND name='验收' AND is_delete=0); -- 已有手工项目若尚未指定周期和阶段,补默认值;不覆盖已有内容。 UPDATE project_management_info SET follow_cycle='MONTH' WHERE follow_cycle IS NULL OR follow_cycle=''; UPDATE project_management_info SET current_phase='未开始' WHERE current_phase IS NULL OR current_phase=''; UPDATE project_management_info SET project_leader_id=manager_id,project_leader_name=manager_name WHERE project_leader_id IS NULL AND manager_id IS NOT NULL; -- ------------------------------ -- 菜单路由重组 -- ------------------------------ -- 行政管理:复用原“协同办公”根菜单。 UPDATE sys_menu SET menu_name='行政管理',path='administrationManagement',route_name='AdministrationManagement',order_num=1, icon='time-range',visible='0',status='0',remark='请假、出差和统一审批入口' WHERE menu_id=2053; -- 继续使用项目原有的审批管理与协同审批页面,不启用另一套审批流程配置页面。 UPDATE sys_menu SET menu_name='审批管理',parent_id=2053,order_num=3,path='approvalManagement', component='collaborativeApproval/approvalManagement/index',route_name='ApprovalManagement', perms='',icon='cascader',visible='0',status='0',app_component=NULL, remark='原有审批类型和审批节点管理' WHERE menu_id=2293; UPDATE sys_menu SET menu_name='协同审批',parent_id=2053,order_num=4,path='approvalProcess', component='collaborativeApproval/approvalProcess/index',route_name='ApprovalProcess', perms='',icon='skill',visible='1',status='1',app_component='/pages/indexItem?label=协同审批', remark='功能与请假、出差入口重复,菜单停用但保留页面和历史数据' WHERE menu_id=2054; INSERT INTO sys_menu(menu_name,parent_id,order_num,path,component,route_name,is_frame,is_cache,menu_type,visible,status,perms,icon,create_by,create_time,remark) SELECT '请假管理',2053,1,'leave','officeProcessAutomation/AttendManage/leave-apply/index','LeaveManagement',1,0,'C','0','0','approval:leave:list','form','admin',NOW(),'员工请假申请与重新提交' WHERE NOT EXISTS (SELECT 1 FROM sys_menu WHERE parent_id=2053 AND path='leave'); INSERT INTO sys_menu(menu_name,parent_id,order_num,path,component,route_name,is_frame,is_cache,menu_type,visible,status,perms,icon,create_by,create_time,remark) SELECT '出差管理',2053,2,'businessTrip','officeProcessAutomation/AttendManage/out-apply/index','BusinessTripManagement',1,0,'C','0','0','approval:trip:list','documentation','admin',NOW(),'员工出差申请与重新提交' WHERE NOT EXISTS (SELECT 1 FROM sys_menu WHERE parent_id=2053 AND path='businessTrip'); UPDATE sys_menu SET component='collaborativeApproval/approvalProcess/index2', remark='使用原有协同审批的请假流程(类型2)' WHERE parent_id=2053 AND path='leave'; UPDATE sys_menu SET component='collaborativeApproval/approvalProcess/index3', remark='使用原有协同审批的出差流程(类型3)' WHERE parent_id=2053 AND path='businessTrip'; -- 客户管理:复用原“营销管理”根菜单。 UPDATE sys_menu SET menu_name='客户管理',path='customerManagement',route_name='CustomerManagement',order_num=2, icon='peoples',visible='0',status='0',remark='客户信息与近三年财务报表' WHERE menu_id=2010; UPDATE sys_menu SET menu_name='客户信息维护',parent_id=2010,order_num=1,path='customerFile', component='basicData/customerFile/index',route_name='CustomerFile',visible='0',status='0' WHERE menu_id=2001; UPDATE sys_menu SET menu_name='近三年财务报表',parent_id=2010,order_num=2,path='financialReport', component='salesManagement/reportAudit/index',route_name='CustomerFinancialReport', perms='sales:report:audit',visible='1',status='1',remark='已合并到客户信息维护,不再单独显示' WHERE menu_id=2369; -- 业务管理根菜单,并迁移原销售台账页面。 INSERT INTO sys_menu(menu_name,parent_id,order_num,path,component,route_name,is_frame,is_cache,menu_type,visible,status,perms,icon,create_by,create_time,remark) SELECT '业务管理',0,3,'businessManagement',NULL,'BusinessManagement',1,0,'M','0','0','','documentation','admin',NOW(),'关联客户的业务登记、附件、进度与审批' WHERE NOT EXISTS (SELECT 1 FROM sys_menu WHERE parent_id=0 AND path='businessManagement'); SET @business_root=(SELECT menu_id FROM sys_menu WHERE parent_id=0 AND path='businessManagement' ORDER BY menu_id LIMIT 1); UPDATE sys_menu SET menu_name='业务登记',parent_id=@business_root,order_num=1,path='businessLedger', component='salesManagement/salesLedger/index',route_name='BusinessLedger',visible='0',status='0',remark='业务登记、附件、进度与审批' WHERE menu_id=2011; UPDATE sys_menu SET order_num=4,visible='0',status='0' WHERE menu_id=2276; UPDATE sys_menu SET menu_name='项目列表',order_num=1,path='projectList',route_name='ProjectList',visible='0',status='0' WHERE menu_id=2285; INSERT INTO sys_menu(menu_name,parent_id,order_num,path,component,route_name,is_frame,is_cache,menu_type,visible,status,perms,icon,create_by,create_time,remark) SELECT '项目分类',2276,2,'projectCategory','projectManagement/projectCategory/index','ProjectCategory',1,0,'C','0','0','project:category:list','tree','admin',NOW(),'多层树形项目分类维护' WHERE NOT EXISTS (SELECT 1 FROM sys_menu WHERE parent_id=2276 AND path='projectCategory'); UPDATE sys_menu SET order_num=5,visible='0',status='0' WHERE menu_id=2015; UPDATE sys_menu SET menu_name='采购信息',order_num=1,route_name='ProcurementLedger',visible='0',status='0' WHERE menu_id=2016; -- 政府政策文件。 INSERT INTO sys_menu(menu_name,parent_id,order_num,path,component,route_name,is_frame,is_cache,menu_type,visible,status,perms,icon,create_by,create_time,remark) SELECT '政府政策文件',0,6,'governmentPolicy',NULL,'GovernmentPolicy',1,0,'M','0','0','','documentation','admin',NOW(),'政策依据资料库' WHERE NOT EXISTS (SELECT 1 FROM sys_menu WHERE parent_id=0 AND path='governmentPolicy'); SET @policy_root=(SELECT menu_id FROM sys_menu WHERE parent_id=0 AND path='governmentPolicy' ORDER BY menu_id LIMIT 1); INSERT INTO sys_menu(menu_name,parent_id,order_num,path,component,route_name,is_frame,is_cache,menu_type,visible,status,perms,icon,create_by,create_time,remark) SELECT '政策文件维护',@policy_root,1,'policyFile','governmentPolicy/policyFile/index','PolicyFile',1,0,'C','0','0','policy:file:list','documentation','admin',NOW(),'政策名称、发布时间、链接、文件和维护人' WHERE NOT EXISTS (SELECT 1 FROM sys_menu WHERE parent_id=@policy_root AND path='policyFile'); -- 客户账号入口保留,但只分配给客户角色;不提供自行注册。 UPDATE sys_menu SET menu_name='客户资料',order_num=90,visible='0',status='0' WHERE menu_id=2357; UPDATE sys_menu SET menu_name='财务报表上传',parent_id=2357,order_num=1,visible='0',status='0' WHERE menu_id=2358; UPDATE sys_menu SET status='1',visible='1' WHERE menu_id=2359; -- 项目按钮权限。 SET @project_list_menu=2285; INSERT INTO sys_menu(menu_name,parent_id,order_num,path,component,route_name,is_frame,is_cache,menu_type,visible,status,perms,icon,create_by,create_time,remark) SELECT '模块维护',@project_list_menu,21,'#',NULL,'',1,0,'F','0','0','project:module:edit','#','admin',NOW(),'' WHERE NOT EXISTS (SELECT 1 FROM sys_menu WHERE perms='project:module:edit'); INSERT INTO sys_menu(menu_name,parent_id,order_num,path,component,route_name,is_frame,is_cache,menu_type,visible,status,perms,icon,create_by,create_time,remark) SELECT '模块删除',@project_list_menu,22,'#',NULL,'',1,0,'F','0','0','project:module:remove','#','admin',NOW(),'' WHERE NOT EXISTS (SELECT 1 FROM sys_menu WHERE perms='project:module:remove'); INSERT INTO sys_menu(menu_name,parent_id,order_num,path,component,route_name,is_frame,is_cache,menu_type,visible,status,perms,icon,create_by,create_time,remark) SELECT '新增跟进',@project_list_menu,23,'#',NULL,'',1,0,'F','0','0','project:follow:add','#','admin',NOW(),'' WHERE NOT EXISTS (SELECT 1 FROM sys_menu WHERE perms='project:follow:add'); INSERT INTO sys_menu(menu_name,parent_id,order_num,path,component,route_name,is_frame,is_cache,menu_type,visible,status,perms,icon,create_by,create_time,remark) SELECT '删除跟进',@project_list_menu,24,'#',NULL,'',1,0,'F','0','0','project:follow:remove','#','admin',NOW(),'' WHERE NOT EXISTS (SELECT 1 FROM sys_menu WHERE perms='project:follow:remove'); INSERT INTO sys_menu(menu_name,parent_id,order_num,path,component,route_name,is_frame,is_cache,menu_type,visible,status,perms,icon,create_by,create_time,remark) SELECT '进度汇报',@project_list_menu,25,'#',NULL,'',1,0,'F','0','0','project:report:add','#','admin',NOW(),'' WHERE NOT EXISTS (SELECT 1 FROM sys_menu WHERE perms='project:report:add'); INSERT INTO sys_menu(menu_name,parent_id,order_num,path,component,route_name,is_frame,is_cache,menu_type,visible,status,perms,icon,create_by,create_time,remark) SELECT '项目资料维护',@project_list_menu,26,'#',NULL,'',1,0,'F','0','0','project:material:add','#','admin',NOW(),'' WHERE NOT EXISTS (SELECT 1 FROM sys_menu WHERE perms='project:material:add'); INSERT INTO sys_menu(menu_name,parent_id,order_num,path,component,route_name,is_frame,is_cache,menu_type,visible,status,perms,icon,create_by,create_time,remark) SELECT '删除进度汇报',@project_list_menu,27,'#',NULL,'',1,0,'F','0','0','project:report:remove','#','admin',NOW(),'' WHERE NOT EXISTS (SELECT 1 FROM sys_menu WHERE perms='project:report:remove'); INSERT INTO sys_menu(menu_name,parent_id,order_num,path,component,route_name,is_frame,is_cache,menu_type,visible,status,perms,icon,create_by,create_time,remark) SELECT '删除项目资料',@project_list_menu,28,'#',NULL,'',1,0,'F','0','0','project:material:remove','#','admin',NOW(),'' WHERE NOT EXISTS (SELECT 1 FROM sys_menu WHERE perms='project:material:remove'); INSERT INTO sys_menu(menu_name,parent_id,order_num,path,component,route_name,is_frame,is_cache,menu_type,visible,status,perms,icon,create_by,create_time,remark) SELECT '维护项目阶段',@project_list_menu,29,'#',NULL,'',1,0,'F','0','0','project:phase:edit','#','admin',NOW(),'' WHERE NOT EXISTS (SELECT 1 FROM sys_menu WHERE perms='project:phase:edit'); SET @project_category_menu=(SELECT menu_id FROM sys_menu WHERE parent_id=2276 AND path='projectCategory' ORDER BY menu_id LIMIT 1); INSERT INTO sys_menu(menu_name,parent_id,order_num,path,component,route_name,is_frame,is_cache,menu_type,visible,status,perms,icon,create_by,create_time,remark) SELECT '维护项目分类',@project_category_menu,1,'#',NULL,'',1,0,'F','0','0','project:category:edit','#','admin',NOW(),'' WHERE NOT EXISTS (SELECT 1 FROM sys_menu WHERE perms='project:category:edit'); INSERT INTO sys_menu(menu_name,parent_id,order_num,path,component,route_name,is_frame,is_cache,menu_type,visible,status,perms,icon,create_by,create_time,remark) SELECT '删除项目分类',@project_category_menu,2,'#',NULL,'',1,0,'F','0','0','project:category:remove','#','admin',NOW(),'' WHERE NOT EXISTS (SELECT 1 FROM sys_menu WHERE perms='project:category:remove'); SET @policy_file_menu=(SELECT menu_id FROM sys_menu WHERE parent_id=@policy_root AND path='policyFile' ORDER BY menu_id LIMIT 1); INSERT INTO sys_menu(menu_name,parent_id,order_num,path,component,route_name,is_frame,is_cache,menu_type,visible,status,perms,icon,create_by,create_time,remark) SELECT '维护政策文件',@policy_file_menu,1,'#',NULL,'',1,0,'F','0','0','policy:file:edit','#','admin',NOW(),'' WHERE NOT EXISTS (SELECT 1 FROM sys_menu WHERE perms='policy:file:edit'); INSERT INTO sys_menu(menu_name,parent_id,order_num,path,component,route_name,is_frame,is_cache,menu_type,visible,status,perms,icon,create_by,create_time,remark) SELECT '删除政策文件',@policy_file_menu,2,'#',NULL,'',1,0,'F','0','0','policy:file:remove','#','admin',NOW(),'' WHERE NOT EXISTS (SELECT 1 FROM sys_menu WHERE perms='policy:file:remove'); -- 超级管理员角色补齐新增菜单;其他角色仍在“角色管理”中按需配置。 INSERT IGNORE INTO sys_role_menu(role_id,menu_id) SELECT 1,menu_id FROM sys_menu WHERE status='0' AND ( menu_id IN (2053,2010,2015,2276,2357,@business_root,@policy_root) OR parent_id IN (2053,2010,2015,2276,2357,@business_root,@policy_root,2285) ); SET FOREIGN_KEY_CHECKS = 1; SELECT 'five_stage_nodes' AS item,COUNT(*) AS count_value FROM project_management_plan_node WHERE project_management_plan_id=@five_stage_plan_id AND is_delete=0 UNION ALL SELECT 'project_workflow_tables',COUNT(*) FROM information_schema.TABLES WHERE TABLE_SCHEMA=DATABASE() AND TABLE_NAME IN ( 'project_management_category','project_management_module','project_management_module_member', 'project_management_follow_up','project_management_progress_report','project_management_material', 'project_management_phase','government_policy_file' ) UNION ALL SELECT 'enabled_root_menus',COUNT(*) FROM sys_menu WHERE parent_id=0 AND status='0';