aps-modules/aps-core/src/main/java/com/aps/core/service/impl/ApsWeldSeamServiceImpl.java
@@ -10,6 +10,7 @@ import com.aps.core.mapper.ApsWeldSeamStatisticsMapper; import com.aps.core.mapper.ApsWeldSeamTempMapper; import com.aps.core.service.IApsWeldSeamService; import org.apache.commons.lang3.ObjectUtils; import org.springframework.beans.BeanUtils; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; @@ -113,7 +114,7 @@ //通过工单号查询是否存在数据 ApsWeldSeam apsWeldSeam1 = apsWeldSeamMapper.selectApsWeldSeamByWorkOrderNo(apsWeldSeam.getWorkOrderNo()); //当工单号存在则更新数据否则插入数据 if (StringUtils.isNotEmpty(apsWeldSeam1.getId())) { if (ObjectUtils.isNotEmpty(apsWeldSeam1)) { apsWeldSeam.setId(apsWeldSeam1.getId()); apsWeldSeamMapper.updateApsWeldSeam(apsWeldSeam); } else { aps-modules/aps-core/src/main/resources/mapper/core/ApsWeldSeamMapper.xml
@@ -162,9 +162,9 @@ SUM ( CASE WHEN work_order_type = '1' AND classification = '1' THEN production_quantity ELSE 0 END ) AS pipingPredictionRequirement, SUM ( CASE WHEN work_order_type = '1' AND classification = '0' THEN production_quantity ELSE 0 END ) AS gasPredictionRequirement FROM "aps_weld_seam" aps_weld_seam where 1=1 <foreach item="item" index="index" collection="list" separator=","> <foreach item="item" index="index" collection="list" separator=" "> or ( produce_year=#{item.produceYear} and produce_month=#{item.produceMonth} and production_base=#{item.productionBase}) </foreach> GROUP BY