UPDATE approval_instance i
|
JOIN appointment_order o ON o.id = i.order_id
|
SET i.status = 'CANCELLED'
|
WHERE i.del_flag = 0
|
AND o.del_flag = 0
|
AND o.status = 'CANCELLED'
|
AND i.status = 'REJECTED';
|
|
UPDATE approval_task t
|
JOIN approval_instance i ON i.id = t.instance_id
|
JOIN appointment_order o ON o.id = i.order_id
|
SET t.task_status = 'CANCELLED'
|
WHERE t.del_flag = 0
|
AND i.del_flag = 0
|
AND o.del_flag = 0
|
AND o.status = 'CANCELLED'
|
AND t.task_status = 'REJECTED'
|
AND t.comment = '预约人取消';
|
