all-project/backend/sql/fix_poverty_application_status.sql

-- 修复助学金申请表状态问题
-- 将状态为SUBMITTED的记录改为WAITING，以便正常进行审核

-- 查看当前状态分布（执行前检查）
SELECT status, COUNT(*) as count
FROM jcbt_poverty_application
GROUP BY status;

-- 修复SUBMITTED状态为WAITING
UPDATE jcbt_poverty_application
SET status = 'WAITING',
    update_time = NOW(),
    update_by = 103,
    remark = CONCAT(IFNULL(remark, ''), ' [系统修复：状态从SUBMITTED更新为WAITING以支持审核]')
WHERE status = 'SUBMITTED';

-- 查看修复后的状态分布
SELECT status, COUNT(*) as count
FROM jcbt_poverty_application
GROUP BY status;

-- 显示被修复的记录详情
SELECT id, application_no, student_name, status, submit_time, update_time
FROM jcbt_poverty_application
WHERE status = 'WAITING'
  AND remark LIKE '%系统修复：状态从SUBMITTED更新为WAITING%'
ORDER BY update_time DESC;