56,940
社区成员




CREATE DEFINER=`root`@`%` PROCEDURE `ps_test`(workInfoId INT,staffId INT,OUT errorNo INT,OUT errorInfo VARCHAR(1000))
BEGIN
DECLARE cur_step INT DEFAULT 0;
DECLARE next_staff VARCHAR(20) DEFAULT '';
SET errorNo=0;
SET errorInfo='成功';
SELECT step INTO cur_step FROM T1 WHERE work_info_id=workInfoId AND staff_id=staffId AND stat =1; -- 查找当前步骤
SELECT GROUP_CONCAT(staff_id) INTO next_staff FROM T1 WHERE work_info_id=workInfoId AND step=cur_step+1; -- 查找下一步审核人ID
DELETE FROM T2 WHERE work_id=workInfoId AND staff_id IN(next_staff); -- 删除下一步审核人的短链接
END$$
DELIMITER ;