fix(quality): 修正质量检测SQL中的条件判断错误

zss

2 天以前 4f263663066e351114e871d6017632a4eb406869

fix(quality): 修正质量检测SQL中的条件判断错误

 src/main/resources/mapper/quality/QualityInspectMapper.xml

@@ -320,7 +320,7 @@
        SELECT t.modelType,
               COALESCE(SUM(
                                CASE
                                    WHEN pp.product_name = '原料' 原料 t.modelType = 0 THEN qi.quantity
                                    WHEN pp.product_name = '原料' AND t.modelType = 0 THEN qi.quantity
                                    WHEN pp.product_name = '半成品' AND t.modelType = 1 THEN qi.quantity
                                    WHEN pp.product_name = '成品' AND t.modelType = 2 THEN qi.quantity
                                    ELSE 0