-- ============================================================ -- 13. 退费/销户 BPM 审批分类 -- 说明:仅种入流程分类;具体 BPMN 流程需在「BPM 管理后台 → 流程模型」设计并发布, -- 流程 key 引用分类 refund_approve / cancellation_approve 下任意已发布流程。 -- ============================================================ INSERT INTO `bpm_category` (`id`, `name`, `code`, `status`, `sort`, `creator`, `create_time`, `updater`, `update_time`, `deleted`) VALUES (209, '退费审批', 'refund_approve', 0, 209, '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 (210, '销户审批', 'cancellation_approve', 0, 210, '1', NOW(), '1', NOW(), b'0') ON DUPLICATE KEY UPDATE `name` = VALUES(`name`); -- ============================================================ -- 库存预警自动生成采购计划:定时任务(每 2 小时) -- ============================================================ INSERT INTO `infra_job` (`name`, `status`, `handler_name`, `handler_param`, `cron_expression`, `retry_count`, `retry_interval`, `monitor_timeout`, `creator`, `create_time`, `updater`, `update_time`, `deleted`) SELECT '库存预警自动生成采购计划', 1, 'erpPurchasePlanStockAlertJob', '', '0 0 */2 * * ?', 0, 0, 0, '1', NOW(), '1', NOW(), b'0' FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM `infra_job` WHERE `handler_name` = 'erpPurchasePlanStockAlertJob' AND `deleted` = b'0');