From 09a010c5dc11c68a866a6075a74bd1bbefb4a9a8 Mon Sep 17 00:00:00 2001 From: wu <731351411@qq.com> Date: 星期一, 24 六月 2024 16:38:23 +0800 Subject: [PATCH] Merge branch 'master' of http://10.153.19.25:10101/r/HangZhouMes --- hangzhoumesParent/moduleService/LoadGlassModule/src/main/java/com/mes/uppattenusage/service/impl/UpPattenUsageServiceImpl.java | 35 +++++++++++++++++++++++++++++++---- 1 files changed, 31 insertions(+), 4 deletions(-) diff --git a/hangzhoumesParent/moduleService/LoadGlassModule/src/main/java/com/mes/uppattenusage/service/impl/UpPattenUsageServiceImpl.java b/hangzhoumesParent/moduleService/LoadGlassModule/src/main/java/com/mes/uppattenusage/service/impl/UpPattenUsageServiceImpl.java index 132a0e5..e7bdf13 100644 --- a/hangzhoumesParent/moduleService/LoadGlassModule/src/main/java/com/mes/uppattenusage/service/impl/UpPattenUsageServiceImpl.java +++ b/hangzhoumesParent/moduleService/LoadGlassModule/src/main/java/com/mes/uppattenusage/service/impl/UpPattenUsageServiceImpl.java @@ -3,6 +3,7 @@ import com.baomidou.dynamic.datasource.annotation.DS; import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; +import com.baomidou.mybatisplus.core.conditions.update.UpdateWrapper; import com.github.yulichang.base.MPJBaseServiceImpl; import com.github.yulichang.query.MPJQueryWrapper; import com.mes.engineering.entity.Engineering; @@ -11,13 +12,14 @@ import com.mes.pp.mapper.OptimizeProjectMapper; import com.mes.uppattenusage.entity.OptimizeUpPattenUsage; import com.mes.uppattenusage.entity.UpPattenUsage; -import com.mes.uppattenusage.service.UpPattenUsageService; import com.mes.uppattenusage.mapper.UpPattenUsageMapper; +import com.mes.uppattenusage.service.UpPattenUsageService; import lombok.extern.slf4j.Slf4j; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; -import java.util.*; +import java.util.ArrayList; +import java.util.List; /** * <p> @@ -39,7 +41,7 @@ public List<UpPattenUsage> prioritylist() { //鑾峰彇姝e湪涓婄墖鐨勪换鍔d Engineering engineering= engineeringService.selectInitiate(1); - log.info("灏嗗弬鏁颁紶鍏ュ埌鏌ヨ绫婚噷{}",engineering); + //log.info("灏嗗弬鏁颁紶鍏ュ埌鏌ヨ绫婚噷{}",engineering); if(engineering!=null){ LambdaQueryWrapper<UpPattenUsage> wrapper = new LambdaQueryWrapper<>(); wrapper.eq(UpPattenUsage::getEngineeringId,engineering.getEngineerId()); @@ -51,13 +53,20 @@ } @Override + public List<UpPattenUsage> selectUpPattenUsage(UpPattenUsage upPattenUsage) { + LambdaQueryWrapper<UpPattenUsage> wrapper = new LambdaQueryWrapper<>(); + wrapper.eq(UpPattenUsage::getEngineeringId,upPattenUsage.getEngineeringId()); + return this.list(wrapper); + } + + @Override @DS("pp") public List<UpPattenUsage> selectSaveUpPattenUsage(String engineeringId) { List<OptimizeUpPattenUsage> upPattenUsageList = null; if (engineeringId != null) { upPattenUsageList = optimizeProjectMapper.selectJoinList(OptimizeUpPattenUsage.class, new MPJQueryWrapper<OptimizeProject>() - .select("t.project_no,t.glass_type,b.width,b.height,REGEXP_REPLACE(t.glass_thickness,'\\D','')as glass_thickness,b.stock_id") + .select("t.project_no,t.glass_type,b.o_width as width,b.o_height as height ,REGEXP_REPLACE(t.glass_thickness,'\\D','')as glass_thickness,b.stock_id") .leftJoin("optimize_layout b on t.project_no=b.project_no") .eq("b.project_no", engineeringId)); } @@ -116,5 +125,23 @@ return this.getOne(wrapper); } + @Override + //鑾峰彇鏈�鍚庝竴鍧楃幓鐠� + public UpPattenUsage selectSequence(UpPattenUsage upPattenUsage) { + QueryWrapper<UpPattenUsage>wrapper = new QueryWrapper<>(); + wrapper.eq("engineering_id",upPattenUsage.getEngineeringId()) + .orderByDesc("layout_sequence") + .last("limit 1"); + return this.getOne(wrapper); + } + + @Override + public Boolean updateGlassState(UpPattenUsage upPattenUsage) { + UpdateWrapper<UpPattenUsage> updateWrapper = new UpdateWrapper<>(); + updateWrapper.eq("id",upPattenUsage.getId()) + .set("state",upPattenUsage.getState()); + return this.update(updateWrapper); + } + } -- Gitblit v1.8.0