-- ===================================================== -- CRM 销售报价单审批增强(需求二:销售报价) -- 1. crm_sale_quotation 增加「审批状态」字段(BPM 协同办公) -- 2. crm_sale_quotation 增加「业务员」字段 -- 3. BPM 流程分类 bpm_category:sale_quotation_approve -- 说明:脚本幂等、可重复执行。审批状态字典复用已有 crm_audit_status,无需新建。 -- 注意:BPM 具体审批流程模型(BPMN)需在「协同办公 → 流程管理」中创建/部署后, -- 报价单「提交审批」才会出现可选流程;否则提交时会提示“审批流程不存在或未激活”。 -- ===================================================== -- 1. 增加字段 audit_status(审批状态) SET @c1 := (SELECT COUNT(*) FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'crm_sale_quotation' AND COLUMN_NAME = 'audit_status'); SET @d1 := IF(@c1 = 0, 'ALTER TABLE `crm_sale_quotation` ADD COLUMN `audit_status` int NULL DEFAULT 0 COMMENT ''审批状态(字典 crm_audit_status:0未提交/10审批中/20通过/30不通过/40取消)'' AFTER `status`', 'SELECT 1'); PREPARE stmt FROM @d1; EXECUTE stmt; DEALLOCATE PREPARE stmt; -- 2. 增加字段 sale_user_id(业务员/经办销售) SET @c2 := (SELECT COUNT(*) FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'crm_sale_quotation' AND COLUMN_NAME = 'sale_user_id'); SET @d2 := IF(@c2 = 0, 'ALTER TABLE `crm_sale_quotation` ADD COLUMN `sale_user_id` bigint NULL COMMENT ''业务员(销售)用户编号'' AFTER `owner_user_id`', 'SELECT 1'); PREPARE stmt FROM @d2; EXECUTE stmt; DEALLOCATE PREPARE stmt; -- 3. BPM 流程分类:sale_quotation_approve(幂等) INSERT INTO bpm_category (name, code, description, status, sort, creator, create_time, updater, update_time, deleted) SELECT '销售报价审批', 'sale_quotation_approve', 'CRM 销售报价单审批', 0, 25, '1', NOW(), '1', NOW(), 0 WHERE NOT EXISTS (SELECT 1 FROM bpm_category WHERE code = 'sale_quotation_approve' AND deleted = 0);