-- ============================================================ -- 电力数转增强 - 第十四阶段(xlsx 复核缺口补齐) -- 适用:MySQL 8.4+ -- 内容: -- 1) 绩效考核全流程(hrm_performance_appraise/_item/_result/_result_item,含 BPM 审批) -- 2) 作业替代方案 + 电力运维日历(mes_pro_alternative_plan / mes_pro_maintenance_calendar) -- 3) 故障赔付 / 服务补偿单(after_sale_compensation,含 BPM 审批) -- 4) 负荷预测 -> 生成工单联动(mes_pro_work_order_source_type 追加 4=负荷预测 + 生成工单按钮) -- 说明:账务联动/成本核算对接依赖财务,仅预留接口字段不接账 -- 注意:本脚本不包含 tenant_id(项目未启用多租户) -- ============================================================ -- ---------- 1. 绩效考核方案表 ---------- CREATE TABLE IF NOT EXISTS `hrm_performance_appraise` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '编号', `name` varchar(200) NOT NULL COMMENT '方案名称', `period_type` tinyint DEFAULT NULL COMMENT '考核周期类型(1月度/2季度/3年度)', `period` varchar(50) DEFAULT NULL COMMENT '考核周期描述,如 2026-08', `scope_type` tinyint DEFAULT NULL COMMENT '考核范围类型(1全部员工/2指定班组)', `status` tinyint NOT NULL DEFAULT '0' COMMENT '方案状态(0草稿/10已发布/20进行中/30已完成)', `audit_status` tinyint NOT NULL DEFAULT '0' COMMENT '审批状态(0未提交/10审批中/20审批通过/30审批驳回/40已取消)', `process_instance_id` varchar(64) DEFAULT NULL COMMENT '审批流程实例编号', `audit_user_id` bigint DEFAULT NULL COMMENT '审核人', `audit_time` datetime DEFAULT NULL COMMENT '审核时间', `audit_remark` varchar(500) DEFAULT NULL COMMENT '审核备注', `remark` varchar(500) DEFAULT NULL COMMENT '备注', `creator` varchar(64) DEFAULT '' COMMENT '创建者', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `updater` varchar(64) DEFAULT '' COMMENT '更新者', `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除', PRIMARY KEY (`id`), KEY `idx_status` (`status`), KEY `idx_audit_status` (`audit_status`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='绩效考核方案'; -- ---------- 2. 绩效考核指标表 ---------- CREATE TABLE IF NOT EXISTS `hrm_performance_appraise_item` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '编号', `appraise_id` bigint NOT NULL COMMENT '考核方案编号', `item_name` varchar(200) NOT NULL COMMENT '指标名称', `weight` decimal(10,2) DEFAULT NULL COMMENT '权重', `scoring_standard` varchar(500) DEFAULT NULL COMMENT '评分标准', `scorer_type` tinyint DEFAULT NULL COMMENT '评分人类型(1自评/2上级评)', `sort` int NOT NULL DEFAULT '0' COMMENT '排序', `creator` varchar(64) DEFAULT '' COMMENT '创建者', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `updater` varchar(64) DEFAULT '' COMMENT '更新者', `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除', PRIMARY KEY (`id`), KEY `idx_appraise_id` (`appraise_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='绩效考核指标'; -- ---------- 3. 绩效考核结果表(按员工汇总) ---------- CREATE TABLE IF NOT EXISTS `hrm_performance_appraise_result` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '编号', `appraise_id` bigint NOT NULL COMMENT '考核方案编号', `employee_id` bigint NOT NULL COMMENT '员工编号', `self_score` decimal(10,2) DEFAULT NULL COMMENT '自评总分', `superior_score` decimal(10,2) DEFAULT NULL COMMENT '上级评总分', `final_score` decimal(10,2) DEFAULT NULL COMMENT '综合得分', `grade` tinyint DEFAULT NULL COMMENT '档级(1优秀/2良好/3合格/4待改进)', `comment` varchar(500) DEFAULT NULL COMMENT '评语', `creator` varchar(64) DEFAULT '' COMMENT '创建者', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `updater` varchar(64) DEFAULT '' COMMENT '更新者', `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除', PRIMARY KEY (`id`), UNIQUE KEY `uk_appraise_employee` (`appraise_id`, `employee_id`), KEY `idx_grade` (`grade`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='绩效考核结果'; -- ---------- 4. 绩效考核结果明细表(按员工×指标) ---------- CREATE TABLE IF NOT EXISTS `hrm_performance_appraise_result_item` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '编号', `result_id` bigint NOT NULL COMMENT '考核结果编号', `item_id` bigint NOT NULL COMMENT '考核指标编号', `item_name` varchar(200) DEFAULT NULL COMMENT '指标名称(冗余)', `weight` decimal(10,2) DEFAULT NULL COMMENT '权重(冗余)', `self_score` decimal(10,2) DEFAULT NULL COMMENT '自评得分', `superior_score` decimal(10,2) DEFAULT NULL COMMENT '上级评得分', `creator` varchar(64) DEFAULT '' COMMENT '创建者', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `updater` varchar(64) DEFAULT '' COMMENT '更新者', `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除', PRIMARY KEY (`id`), KEY `idx_result_id` (`result_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='绩效考核结果明细'; -- ---------- 5. 作业替代方案表 ---------- CREATE TABLE IF NOT EXISTS `mes_pro_alternative_plan` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '编号', `code` varchar(50) NOT NULL COMMENT '方案编码', `name` varchar(200) NOT NULL COMMENT '方案名称', `main_process_id` bigint DEFAULT NULL COMMENT '主工序编号', `main_process_name` varchar(200) DEFAULT NULL COMMENT '主工序名称', `alt_process_id` bigint DEFAULT NULL COMMENT '替代工序编号', `alt_process_name` varchar(200) DEFAULT NULL COMMENT '替代工序名称', `alt_condition` varchar(500) DEFAULT NULL COMMENT '替代条件(设备故障/负荷受限/人员不足)', `scope` varchar(500) DEFAULT NULL COMMENT '适用范围', `status` tinyint NOT NULL DEFAULT '0' COMMENT '状态(0草稿/10已发布)', `remark` varchar(500) DEFAULT NULL COMMENT '备注', `creator` varchar(64) DEFAULT '' COMMENT '创建者', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `updater` varchar(64) DEFAULT '' COMMENT '更新者', `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除', PRIMARY KEY (`id`), UNIQUE KEY `uk_code` (`code`), KEY `idx_status` (`status`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='作业替代方案'; -- ---------- 6. 电力运维日历表 ---------- CREATE TABLE IF NOT EXISTS `mes_pro_maintenance_calendar` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '编号', `code` varchar(50) NOT NULL COMMENT '日历编码', `name` varchar(200) NOT NULL COMMENT '日历名称', `work_date` date DEFAULT NULL COMMENT '作业日期', `shift` tinyint DEFAULT NULL COMMENT '班次(mes_cal_shift_type)', `work_type` tinyint DEFAULT NULL COMMENT '作业类型(mes_pro_calendar_work_type)', `region` varchar(200) DEFAULT NULL COMMENT '作业区域/线路', `team_id` bigint DEFAULT NULL COMMENT '值班班组编号', `team_name` varchar(200) DEFAULT NULL COMMENT '值班班组名称', `personnel` varchar(500) DEFAULT NULL COMMENT '值班人员', `status` tinyint NOT NULL DEFAULT '0' COMMENT '状态(0草稿/10已发布)', `remark` varchar(500) DEFAULT NULL COMMENT '备注', `creator` varchar(64) DEFAULT '' COMMENT '创建者', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `updater` varchar(64) DEFAULT '' COMMENT '更新者', `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除', PRIMARY KEY (`id`), UNIQUE KEY `uk_code` (`code`), KEY `idx_work_date` (`work_date`), KEY `idx_status` (`status`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='电力运维日历'; -- ---------- 7. 售后赔付/服务补偿单表 ---------- CREATE TABLE IF NOT EXISTS `after_sale_compensation` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '编号', `compensation_no` varchar(50) NOT NULL COMMENT '赔付单号', `compensation_type` tinyint NOT NULL COMMENT '赔付类型(1故障赔付/2服务补偿)', `ticket_id` bigint DEFAULT NULL COMMENT '关联售后工单编号', `customer_id` bigint DEFAULT NULL COMMENT '客户编号', `sale_order_id` bigint DEFAULT NULL COMMENT '关联销售订单编号', `amount` decimal(12,2) DEFAULT NULL COMMENT '赔付金额', `payee` varchar(100) DEFAULT NULL COMMENT '赔付对象', `reason` varchar(500) DEFAULT NULL COMMENT '赔付原因', `audit_status` tinyint NOT NULL DEFAULT '0' COMMENT '审批状态(0草稿/10审批中/20已通过/30已驳回/40已取消)', `process_instance_id` varchar(64) DEFAULT NULL COMMENT '审批流程实例编号', `audit_user_id` bigint DEFAULT NULL COMMENT '审核人', `audit_time` datetime DEFAULT NULL COMMENT '审核时间', `audit_remark` varchar(500) DEFAULT NULL COMMENT '审核备注', `pay_status` tinyint DEFAULT NULL COMMENT '支付状态(账务联动预留)', `remark` varchar(500) DEFAULT NULL COMMENT '备注', `creator` varchar(64) DEFAULT '' COMMENT '创建者', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `updater` varchar(64) DEFAULT '' COMMENT '更新者', `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除', PRIMARY KEY (`id`), UNIQUE KEY `uk_compensation_no` (`compensation_no`), KEY `idx_audit_status` (`audit_status`), KEY `idx_ticket_id` (`ticket_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='售后赔付/服务补偿单'; -- ============================================================ -- 8. 字典 -- ============================================================ INSERT INTO `system_dict_type` (`name`, `type`, `status`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `deleted_time`) VALUES ('考核周期类型', 'hrm_performance_period_type', 0, '考核周期类型', '1', NOW(), '1', NOW(), b'0', NULL), ('考核范围类型', 'hrm_performance_scope_type', 0, '考核范围类型', '1', NOW(), '1', NOW(), b'0', NULL), ('评分人类型', 'hrm_performance_scorer_type', 0, '评分人类型', '1', NOW(), '1', NOW(), b'0', NULL), ('考核档级', 'hrm_performance_grade', 0, '考核档级', '1', NOW(), '1', NOW(), b'0', NULL), ('电力运维作业类型', 'mes_pro_calendar_work_type', 0, '电力运维作业类型', '1', NOW(), '1', NOW(), b'0', NULL), ('赔付类型', 'after_sale_compensation_type', 0, '赔付类型', '1', NOW(), '1', NOW(), b'0', NULL) ON DUPLICATE KEY UPDATE `name` = VALUES(`name`); INSERT INTO `system_dict_data` (`sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`) VALUES (1, '月度', '1', 'hrm_performance_period_type', 0, 'primary', '', '月度', '1', NOW(), '1', NOW(), b'0'), (2, '季度', '2', 'hrm_performance_period_type', 0, 'info', '', '季度', '1', NOW(), '1', NOW(), b'0'), (3, '年度', '3', 'hrm_performance_period_type', 0, 'warning', '', '年度', '1', NOW(), '1', NOW(), b'0'), (1, '全部员工', '1', 'hrm_performance_scope_type', 0, 'primary', '', '全部员工', '1', NOW(), '1', NOW(), b'0'), (2, '指定班组', '2', 'hrm_performance_scope_type', 0, 'info', '', '指定班组', '1', NOW(), '1', NOW(), b'0'), (1, '自评', '1', 'hrm_performance_scorer_type', 0, 'primary', '', '自评', '1', NOW(), '1', NOW(), b'0'), (2, '上级评', '2', 'hrm_performance_scorer_type', 0, 'warning', '', '上级评', '1', NOW(), '1', NOW(), b'0'), (1, '优秀', '1', 'hrm_performance_grade', 0, 'success', '', '优秀(≥90)', '1', NOW(), '1', NOW(), b'0'), (2, '良好', '2', 'hrm_performance_grade', 0, 'primary', '', '良好(≥80)', '1', NOW(), '1', NOW(), b'0'), (3, '合格', '3', 'hrm_performance_grade', 0, 'info', '', '合格(≥60)', '1', NOW(), '1', NOW(), b'0'), (4, '待改进', '4', 'hrm_performance_grade', 0, 'danger', '', '待改进(<60)', '1', NOW(), '1', NOW(), b'0'), (1, '变电运维', '1', 'mes_pro_calendar_work_type', 0, 'primary', '', '变电运维', '1', NOW(), '1', NOW(), b'0'), (2, '线路巡检', '2', 'mes_pro_calendar_work_type', 0, 'info', '', '线路巡检', '1', NOW(), '1', NOW(), b'0'), (3, '发电运维', '3', 'mes_pro_calendar_work_type', 0, 'warning', '', '发电运维', '1', NOW(), '1', NOW(), b'0'), (4, '储能充放电', '4', 'mes_pro_calendar_work_type', 0, 'danger', '', '储能充放电', '1', NOW(), '1', NOW(), b'0'), (5, '电网调度', '5', 'mes_pro_calendar_work_type', 0, 'info', '', '电网调度', '1', NOW(), '1', NOW(), b'0'), (1, '故障赔付', '1', 'after_sale_compensation_type', 0, 'danger', '', '故障赔付', '1', NOW(), '1', NOW(), b'0'), (2, '服务补偿', '2', 'after_sale_compensation_type', 0, 'warning', '', '服务补偿', '1', NOW(), '1', NOW(), b'0') ON DUPLICATE KEY UPDATE `label` = VALUES(`label`), `sort` = VALUES(`sort`); -- 工单来源类型追加 4=负荷预测 INSERT INTO `system_dict_data` (`sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`) VALUES (4, '负荷预测', '4', 'mes_pro_work_order_source_type', 0, 'warning', '', '负荷预测', '1', NOW(), '1', NOW(), b'0') ON DUPLICATE KEY UPDATE `label` = VALUES(`label`), `sort` = VALUES(`sort`); -- ============================================================ -- 9. BPM 审批分类 -- 说明:仅种入流程分类;具体 BPMN 流程需在「BPM 管理后台 → 流程模型」设计并发布, -- 流程 key 引用分类 performance_appraise_approve / compensation_approve 下任意已发布流程。 -- ============================================================ INSERT INTO `bpm_category` (`id`, `name`, `code`, `status`, `sort`, `creator`, `create_time`, `updater`, `update_time`, `deleted`) VALUES (211, '绩效考核审批', 'performance_appraise_approve', 0, 211, '1', NOW(), '1', NOW(), b'0') ON DUPLICATE KEY UPDATE `name` = VALUES(`name`); INSERT INTO `bpm_category` (`id`, `name`, `code`, `status`, `sort`, `creator`, `create_time`, `updater`, `update_time`, `deleted`) VALUES (212, '赔付审批', 'compensation_approve', 0, 212, '1', NOW(), '1', NOW(), b'0') ON DUPLICATE KEY UPDATE `name` = VALUES(`name`); -- ============================================================ -- 10. 菜单(绩效考核 / 作业替代方案 / 电力运维日历 / 故障赔付 / 生成工单按钮) -- ============================================================ INSERT INTO `system_menu` (`id`, `name`, `permission`, `type`, `sort`, `parent_id`, `path`, `icon`, `component`, `component_name`, `status`, `visible`, `keep_alive`, `always_show`, `creator`, `create_time`, `updater`, `update_time`, `deleted`) VALUES -- 10.1 绩效考核(父 6001 人力资源) (1065302, '绩效考核', '', 2, 1, 6001, 'performance-appraise', 'ep:data-analysis', 'hrm/performance-appraise/index', 'HrmPerformanceAppraise', 0, b'1', b'0', b'1', '1', NOW(), '1', NOW(), b'0'), (1065303, '绩效考核查询', 'hrm:performance-appraise:query', 3, 1, 1065302, '', '', '', '', 0, b'1', b'0', b'1', '1', NOW(), '1', NOW(), b'0'), (1065304, '绩效考核创建', 'hrm:performance-appraise:create', 3, 2, 1065302, '', '', '', '', 0, b'1', b'0', b'1', '1', NOW(), '1', NOW(), b'0'), (1065305, '绩效考核更新', 'hrm:performance-appraise:update', 3, 3, 1065302, '', '', '', '', 0, b'1', b'0', b'1', '1', NOW(), '1', NOW(), b'0'), (1065306, '绩效考核删除', 'hrm:performance-appraise:delete', 3, 4, 1065302, '', '', '', '', 0, b'1', b'0', b'1', '1', NOW(), '1', NOW(), b'0'), (1065307, '绩效考核提交审批', 'hrm:performance-appraise:submit', 3, 5, 1065302, '', '', '', '', 0, b'1', b'0', b'1', '1', NOW(), '1', NOW(), b'0'), (1065308, '绩效考核审批', 'hrm:performance-appraise:audit', 3, 6, 1065302, '', '', '', '', 0, b'1', b'0', b'1', '1', NOW(), '1', NOW(), b'0'), -- 10.2 作业替代方案(父 6809 工艺设计) (1065310, '作业替代方案', '', 2, 6, 6809, 'alternative-plan', 'ep:switch', 'mes/pro/alternativeplan/index', 'MesProAlternativePlan', 0, b'1', b'0', b'1', '1', NOW(), '1', NOW(), b'0'), (1065311, '作业替代方案查询', 'mes:pro-alternative-plan:query', 3, 1, 1065310, '', '', '', '', 0, b'1', b'0', b'1', '1', NOW(), '1', NOW(), b'0'), (1065312, '作业替代方案创建', 'mes:pro-alternative-plan:create', 3, 2, 1065310, '', '', '', '', 0, b'1', b'0', b'1', '1', NOW(), '1', NOW(), b'0'), (1065313, '作业替代方案更新', 'mes:pro-alternative-plan:update', 3, 3, 1065310, '', '', '', '', 0, b'1', b'0', b'1', '1', NOW(), '1', NOW(), b'0'), (1065314, '作业替代方案删除', 'mes:pro-alternative-plan:delete', 3, 4, 1065310, '', '', '', '', 0, b'1', b'0', b'1', '1', NOW(), '1', NOW(), b'0'), -- 10.3 电力运维日历(父 6809 工艺设计) (1065320, '电力运维日历', '', 2, 7, 6809, 'maintenance-calendar', 'ep:calendar', 'mes/pro/maintenancecalendar/index', 'MesProMaintenanceCalendar', 0, b'1', b'0', b'1', '1', NOW(), '1', NOW(), b'0'), (1065321, '电力运维日历查询', 'mes:pro-maintenance-calendar:query', 3, 1, 1065320, '', '', '', '', 0, b'1', b'0', b'1', '1', NOW(), '1', NOW(), b'0'), (1065322, '电力运维日历创建', 'mes:pro-maintenance-calendar:create', 3, 2, 1065320, '', '', '', '', 0, b'1', b'0', b'1', '1', NOW(), '1', NOW(), b'0'), (1065323, '电力运维日历更新', 'mes:pro-maintenance-calendar:update', 3, 3, 1065320, '', '', '', '', 0, b'1', b'0', b'1', '1', NOW(), '1', NOW(), b'0'), (1065324, '电力运维日历删除', 'mes:pro-maintenance-calendar:delete', 3, 4, 1065320, '', '', '', '', 0, b'1', b'0', b'1', '1', NOW(), '1', NOW(), b'0'), -- 10.4 故障赔付/服务补偿单(父 602587 售后服务) (602650, '故障赔付', '', 2, 1, 602587, 'compensation', 'ep:money', 'aftersales/compensation/index', 'AfterSaleCompensation', 0, b'1', b'0', b'1', '1', NOW(), '1', NOW(), b'0'), (602651, '故障赔付查询', 'aftersales:compensation:query', 3, 1, 602650, '', '', '', '', 0, b'1', b'0', b'1', '1', NOW(), '1', NOW(), b'0'), (602652, '故障赔付创建', 'aftersales:compensation:create', 3, 2, 602650, '', '', '', '', 0, b'1', b'0', b'1', '1', NOW(), '1', NOW(), b'0'), (602653, '故障赔付更新', 'aftersales:compensation:update', 3, 3, 602650, '', '', '', '', 0, b'1', b'0', b'1', '1', NOW(), '1', NOW(), b'0'), (602654, '故障赔付删除', 'aftersales:compensation:delete', 3, 4, 602650, '', '', '', '', 0, b'1', b'0', b'1', '1', NOW(), '1', NOW(), b'0'), (602655, '故障赔付提交审批', 'aftersales:compensation:submit', 3, 5, 602650, '', '', '', '', 0, b'1', b'0', b'1', '1', NOW(), '1', NOW(), b'0'), (602656, '故障赔付审批', 'aftersales:compensation:audit', 3, 6, 602650, '', '', '', '', 0, b'1', b'0', b'1', '1', NOW(), '1', NOW(), b'0'), -- 10.5 生成工单按钮(父 1064002 负荷预测,type 3) (1064006, '生成工单', 'bi:decision-forecast:generate-work-order', 3, 1, 1064002, '', '', '', '', 0, b'1', b'0', b'1', '1', NOW(), '1', NOW(), b'0') ON DUPLICATE KEY UPDATE `name` = VALUES(`name`); -- 角色授权(普通角色2 / 租户管理员109、111) INSERT INTO `system_role_menu` (`role_id`, `menu_id`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `tenant_id`) SELECT r.role_id, m.menu_id, '1', NOW(), '1', NOW(), b'0', 1 FROM (SELECT 2 AS role_id UNION ALL SELECT 109 UNION ALL SELECT 111) r CROSS JOIN (SELECT 1065302 AS menu_id UNION ALL SELECT 1065303 UNION ALL SELECT 1065304 UNION ALL SELECT 1065305 UNION ALL SELECT 1065306 UNION ALL SELECT 1065307 UNION ALL SELECT 1065308 UNION ALL SELECT 1065310 UNION ALL SELECT 1065311 UNION ALL SELECT 1065312 UNION ALL SELECT 1065313 UNION ALL SELECT 1065314 UNION ALL SELECT 1065320 UNION ALL SELECT 1065321 UNION ALL SELECT 1065322 UNION ALL SELECT 1065323 UNION ALL SELECT 1065324 UNION ALL SELECT 602650 UNION ALL SELECT 602651 UNION ALL SELECT 602652 UNION ALL SELECT 602653 UNION ALL SELECT 602654 UNION ALL SELECT 602655 UNION ALL SELECT 602656 UNION ALL SELECT 1064006) m LEFT JOIN `system_role_menu` existing ON existing.role_id = r.role_id AND existing.menu_id = m.menu_id AND existing.deleted = b'0' WHERE existing.id IS NULL; -- ==================== 执行完成提示 ==================== SELECT '电力数转第十四阶段(xlsx 复核缺口补齐)SQL 执行完成!' AS result;