次破报表添加报工审核状态条件

chenlu

2025-07-18 ef5b4a78ec2201b46cb0c9a59fc2cb036bd13f38

次破报表添加报工审核状态条件

 north-glass-erp/src/main/resources/mapper/pp/Report.xml

@@ -596,7 +596,7 @@
        rw.reporting_work_time >= #{selectTime1}
        AND rw.reporting_work_time <  #{selectTime2}

        AND dd.available = 0
        AND dd.available = 0 and rw.reviewed_state>=0
        <if test="damageReportDTO.orderId != null and damageReportDTO.orderId != ''">
            and o.order_id regexp #{damageReportDTO.orderId}
        </if>
@@ -1021,7 +1021,7 @@
            AND dd.technology_number = ogd.technology_number
        WHERE rw.reporting_work_time >= #{dates[0]}
          and rw.reporting_work_time &lt;= #{dates[1]}
          AND dd.available = 0
          AND dd.available = 0 and rw.reviewed_state>=0
        GROUP BY dd.id
    </select>