lxzn-module-mdc/src/main/java/org/jeecg/modules/mdc/mapper/xml/MdcEquipmentStatisticalInfoMapper.xml
@@ -34,11 +34,11 @@ <select id="findByEquipmentAndDate" resultType="org.jeecg.modules.mdc.entity.MdcEquipmentStatisticalInfo"> SELECT the_date, AVG ( open_long ) openLong, AVG ( wait_long ) waitLong, AVG ( process_long ) processLong, AVG ( close_long ) closeLong, AVG ( error_long ) errorLong AVG( open_long ) openLong, AVG( wait_long ) waitLong, AVG( process_long ) processLong, AVG( close_long ) closeLong, AVG( error_long ) errorLong FROM mdc_equipment_statistical_info <where> lxzn-module-mdc/src/main/java/org/jeecg/modules/mdc/mapper/xml/MdcOeeInfoMapper.xml
@@ -40,6 +40,7 @@ <foreach collection="equipmentIdList" item="id" index="index" open="(" close=")" separator=","> #{ id } </foreach> AND plan_close_long != 1440 </where> GROUP BY the_date @@ -58,6 +59,6 @@ mdc_oee_info WHERE the_date LIKE CONCAT(#{month}, '%') AND equipment_id = #{equipmentId} AND equipment_id = #{equipmentId} AND plan_close_long != 1440 </select> </mapper>
