更新

chenlu

2025-08-04 dad17d6ef945ad3bebb6338f2562e2416ee410a0

更新

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

@@ -540,8 +540,8 @@

            left join sd.`order` as o on o.order_id=rw.order_id
        where rw.reviewed_state != 2
          and rw.reporting_work_time >= #{selectTime1}
    AND rw.reporting_work_time <  #{selectTime2}
          and date(rw.reporting_work_time) >= date(#{selectTime1})
    AND date(rw.reporting_work_time) <=  date(#{selectTime2})
          and position(#{orderId} in rw.order_id)
          and rw.reviewed_state!=-1
          and o.create_order>0