From da5297a654ba3a5bf61e8de383bcc723b03ddb58 Mon Sep 17 00:00:00 2001 From: wu <731351411@qq.com> Date: 星期四, 19 十二月 2024 14:50:06 +0800 Subject: [PATCH] 更改选择工程的显示条件 --- hangzhoumesParent/moduleService/LoadGlassModule/src/main/java/com/mes/uppattenusage/service/impl/UpPattenUsageServiceImpl.java | 186 +++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 183 insertions(+), 3 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 008b424..1fa6eec 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 @@ -1,10 +1,27 @@ package com.mes.uppattenusage.service.impl; +import cn.hutool.core.collection.CollectionUtil; +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; +import com.mes.engineering.service.EngineeringService; +import com.mes.pp.entity.OptimizeProject; +import com.mes.pp.mapper.OptimizeProjectMapper; +import com.mes.uppattenusage.entity.OptimizeUpPattenUsage; import com.mes.uppattenusage.entity.UpPattenUsage; -import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; 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.ArrayList; +import java.util.Collections; +import java.util.List; /** * <p> @@ -12,9 +29,172 @@ * </p> * * @author zhoush - * @since 2024-04-07 + * @since 2024-04-18 */ @Service -public class UpPattenUsageServiceImpl extends ServiceImpl<UpPattenUsageMapper, UpPattenUsage> implements UpPattenUsageService { +@Slf4j +public class UpPattenUsageServiceImpl extends MPJBaseServiceImpl<UpPattenUsageMapper, UpPattenUsage> implements UpPattenUsageService { + + @Autowired + OptimizeProjectMapper optimizeProjectMapper; + @Autowired + EngineeringService engineeringService; + @Override + public List<UpPattenUsage> prioritylist() { + //鑾峰彇姝e湪涓婄墖鐨勪换鍔d + Engineering engineering= engineeringService.selectInitiate(1); + //log.info("灏嗗弬鏁颁紶鍏ュ埌鏌ヨ绫婚噷{}",engineering); + if(engineering!=null){ + LambdaQueryWrapper<UpPattenUsage> wrapper = new LambdaQueryWrapper<>(); + wrapper.eq(UpPattenUsage::getEngineeringId, engineering.getEngineerId()); + return this.list(wrapper); + } else { + return null; + } + + } + + @Override + public List<UpPattenUsage> selectLoadTask(Integer cell) { + //鑾峰彇姝e湪涓婄墖鐨勪换鍔d + Engineering engineering= engineeringService.selectInitiates(1,cell); + //log.info("灏嗗弬鏁颁紶鍏ュ埌鏌ヨ绫婚噷{}",engineering); + if(engineering!=null){ + LambdaQueryWrapper<UpPattenUsage> wrapper = new LambdaQueryWrapper<>(); + wrapper.eq(UpPattenUsage::getEngineeringId, engineering.getEngineerId()); + return this.list(wrapper); + } else { + return null; + } + } + + @Override + public List<UpPattenUsage> selectUpPattenUsage(UpPattenUsage upPattenUsage) { + LambdaQueryWrapper<UpPattenUsage> wrapper = new LambdaQueryWrapper<>(); + wrapper.eq(UpPattenUsage::getEngineeringId, upPattenUsage.getEngineeringId()); +// .eq(UpPattenUsage::getStationCell, upPattenUsage.getStationCell()) +// .eq(UpPattenUsage::getFilmRemove, upPattenUsage.getFilmRemove()); + + 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.realwidth as width,b.realheight 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)); + } + // 鍒涘缓涓�涓� List 鐢ㄤ簬淇濆瓨鏄犲皠鍚庣殑瀹炰綋瀵硅薄 + List<UpPattenUsage> resultList = new ArrayList<>(); + +// 閬嶅巻鏌ヨ缁撴灉涓殑姣忎釜 Map 瀵硅薄 + if (upPattenUsageList != null) { + for (OptimizeUpPattenUsage map : upPattenUsageList) { + // 鍒涘缓涓�涓柊鐨� OptimizeProject 瀵硅薄 + UpPattenUsage optimizeProject = new UpPattenUsage(); + // 灏� Map 涓殑姣忎釜閿�煎鏄犲皠鍒� OptimizeProject 瀵硅薄鐨勭浉搴斿瓧娈典笂 + optimizeProject.setEngineeringId(map.getProjectNo()); + optimizeProject.setFilmsId( map.getGlassType()); + optimizeProject.setWidth(map.getWidth()); + optimizeProject.setHeight( map.getHeight()); + optimizeProject.setThickness(map.getGlassThickness()); + optimizeProject.setLayoutSequence( map.getStockId()); + optimizeProject.setState(0); + // 灏嗘槧灏勫悗鐨勫璞℃坊鍔犲埌缁撴灉鍒楄〃涓� + resultList.add(optimizeProject); + } + } + log.info("鏌ヨ鍑轰笂鐗囬『搴忛泦鍚堜繚瀛樺埌瀹炰綋绫粄}",resultList); + return resultList; + } + + @Override + public void saveUpPattenUsage(List<UpPattenUsage> upPattenUsage) { + if (CollectionUtil.isEmpty(upPattenUsage)){ + return; + } + String engineerId = upPattenUsage.get(0).getEngineeringId(); + int count = this.count(new LambdaQueryWrapper<UpPattenUsage>().eq(UpPattenUsage::getEngineeringId, engineerId)); + if (count <=0){ + //淇濆瓨鍘熺墖浣跨敤璇︽儏琛� + this.saveBatch(upPattenUsage); + } + } + + @Override + public void updateUpPattenUsageState(UpPattenUsage upPattenUsage, Integer state) { + upPattenUsage.setState(state); + boolean updateSuccess = this.updateById(upPattenUsage); + log.info("鏇存柊鐘舵�亄}", updateSuccess); + //鏇存柊鐘舵�� + } + + @Override + public UpPattenUsage selectedTaskEngineering(String engineeringId) { + return null; + } + + @Override + public UpPattenUsage selectedEngineering(String engineerId) { + QueryWrapper<UpPattenUsage> wrapper = new QueryWrapper<>(); + wrapper.eq("engineering_id", engineerId) +// .eq("station_cell", stationCell) +// .eq("film_remove", filmRemove) + .last("limit 1"); + log.info("鏌ヨ棰勮鍙傛暟"); + log.info("鏌ヨ棰勮鍙傛暟{}", this.getOne(wrapper)); + return this.getOne(wrapper); + } + + @Override + public void deleteTask(String engineerId) { + QueryWrapper<UpPattenUsage> wrapper = new QueryWrapper<>(); + wrapper.eq("engineering_id",engineerId); + this.remove(wrapper); + } + + + + @Override + public UpPattenUsage selectOverTask() { + QueryWrapper<UpPattenUsage>wrapper = new QueryWrapper<>(); + wrapper.gt("state",0) + .lt("state",99) + .last("limit 1"); + 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); + } + + @Override + public List<Engineering> setRawGlassTaskRequest(Engineering request) { + return null; + } + + public Object Engineering(Engineering request) { + return null; + } + } -- Gitblit v1.8.0