35 lines
832 B
SQL
35 lines
832 B
SQL
-- 重置样品状态为"待测试"
|
|
-- 当删除工单后，需要重置样品状态，以便重新生成工单
|
|
|
|
-- 查看当前样品状态分布
|
|
SELECT
|
|
status,
|
|
CASE
|
|
WHEN status = '0' THEN '待测试'
|
|
WHEN status = '1' THEN '测试中'
|
|
WHEN status = '2' THEN '已完成'
|
|
ELSE '未知'
|
|
END AS status_name,
|
|
COUNT(*) AS count
|
|
FROM warehouse_sample
|
|
GROUP BY status;
|
|
|
|
-- 重置所有样品状态为"待测试"
|
|
UPDATE warehouse_sample
|
|
SET status = '0',
|
|
update_time = NOW()
|
|
WHERE status != '0';
|
|
|
|
-- 验证更新结果
|
|
SELECT
|
|
status,
|
|
CASE
|
|
WHEN status = '0' THEN '待测试'
|
|
WHEN status = '1' THEN '测试中'
|
|
WHEN status = '2' THEN '已完成'
|
|
ELSE '未知'
|
|
END AS status_name,
|
|
COUNT(*) AS count
|
|
FROM warehouse_sample
|
|
GROUP BY status;
|