-- mom-xgdl：回款 BPM 必要配置。仅在现有开票审批配置可用时复用同一财务审批人。
|
-- 幂等执行；不会插入业务回款、伪造审批结果或改动定制流程定义。
|
START TRANSACTION;
|
|
INSERT INTO system_approval_config
|
(biz_type, biz_name, approval_enabled, remark, creator, create_time, updater, update_time, deleted)
|
SELECT 'crm_receivable_approve', '回款审批', i.approval_enabled,
|
'回款审批复用开票财务审批人', '1', NOW(), '1', NOW(), b'0'
|
FROM system_approval_config i
|
WHERE i.biz_type = 'crm_invoice_approve' AND i.deleted = b'0'
|
AND NOT EXISTS (
|
SELECT 1 FROM system_approval_config c
|
WHERE c.biz_type = 'crm_receivable_approve' AND c.deleted = b'0'
|
)
|
LIMIT 1;
|
|
INSERT INTO system_approval_config_user
|
(config_id, user_id, sort, creator, create_time, updater, update_time, deleted)
|
SELECT r.id, iu.user_id, iu.sort, '1', NOW(), '1', NOW(), b'0'
|
FROM system_approval_config r
|
JOIN system_approval_config i ON i.biz_type = 'crm_invoice_approve' AND i.deleted = b'0'
|
JOIN system_approval_config_user iu ON iu.config_id = i.id AND iu.deleted = b'0'
|
WHERE r.biz_type = 'crm_receivable_approve' AND r.deleted = b'0'
|
AND r.remark = '回款审批复用开票财务审批人'
|
AND NOT EXISTS (
|
SELECT 1 FROM system_approval_config_user existing
|
WHERE existing.config_id = r.id AND existing.deleted = b'0'
|
)
|
AND NOT EXISTS (
|
SELECT 1 FROM system_approval_config_user ru
|
WHERE ru.config_id = r.id AND ru.user_id = iu.user_id AND ru.deleted = b'0'
|
);
|
|
COMMIT;
|
|
-- 只读核验：回款流程定义及审批配置均应存在且启用。
|
SELECT KEY_, SUSPENSION_STATE_ FROM ACT_RE_PROCDEF WHERE KEY_ = 'crm-receivable-audit';
|
SELECT c.biz_type, c.approval_enabled, COUNT(u.id) AS approver_count
|
FROM system_approval_config c
|
LEFT JOIN system_approval_config_user u ON u.config_id = c.id AND u.deleted = b'0'
|
WHERE c.biz_type = 'crm_receivable_approve' AND c.deleted = b'0'
|
GROUP BY c.id, c.biz_type, c.approval_enabled;
|
