25 lines
857 B
SQL
25 lines
857 B
SQL
|
-- 添加默认出差审批流程节点
|
||
|
|
-- 1个审批人 + 2个抄送人
|
||
|
|
|
||
|
|
USE xserver;
|
||
|
|
|
||
|
|
-- 清空 business_trip 流程的现有节点
|
||
|
|
DELETE FROM approval_node WHERE flow_id = 2;
|
||
|
|
|
||
|
|
-- 添加审批节点（用户ID 2: 闫继光）
|
||
|
|
INSERT INTO approval_node (flow_id, type, name, `order`, approvers) VALUES
|
||
|
|
(2, "approver", "主管审批", 1, '[2]');
|
||
|
|
|
||
|
|
-- 添加抄送节点（用户ID 3: 孟启, 5: 程丽敏）
|
||
|
|
INSERT INTO approval_node (flow_id, type, name, `order`, approvers) VALUES
|
||
|
|
(2, "notify", "抄送人-孟启", 2, '[3]'),
|
||
|
|
(2, "notify", "抄送人-程丽敏", 3, '[5]');
|
||
|
|
|
||
|
|
-- 验证结果
|
||
|
|
SELECT "=== 默认审批流程节点 ===" AS "";
|
||
|
|
SELECT an.id, an.type, an.name, an.`order`, an.approvers, u.name AS approver_name
|
||
|
|
FROM approval_node an
|
||
|
|
LEFT JOIN users u ON JSON_CONTAINS(an.approvers, CAST(u.id AS JSON))
|
||
|
|
WHERE an.flow_id = 2
|
||
|
|
ORDER BY an.`order`;
|