| | |
|---|
| | | |
|---|
| | | 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.github.yulichang.base.MPJBaseServiceImpl; |
|---|
| | | import com.github.yulichang.query.MPJQueryWrapper; |
|---|
| | | import com.mes.pp.entity.OptimizeProject; |
|---|
| | |
|---|
| | | 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.heat_layout_sort") |
|---|
| | | .select("t.project_no,t.glass_type,b.width,b.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)); |
|---|
| | | } |
|---|
| | |
|---|
| | | // 创建一个新的 OptimizeProject 对象 |
|---|
| | | UpPattenUsage optimizeProject = new UpPattenUsage(); |
|---|
| | | // 将 Map 中的每个键值对映射到 OptimizeProject 对象的相应字段上 |
|---|
| | | optimizeProject.setEngineeringId((String) map.getProjectNo()); |
|---|
| | | optimizeProject.setFilmsId((String) map.getGlassType()); |
|---|
| | | optimizeProject.setWidth((Double) map.getWidth()); |
|---|
| | | optimizeProject.setHeight((Double) map.getHeight()); |
|---|
| | | optimizeProject.setThickness((Double)map.getHeight()); |
|---|
| | | optimizeProject.setLayoutSequence((Integer) map.getHeatLayoutSort()); |
|---|
| | | 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); |
|---|
| | |
|---|
| | | //保存原片使用详情表 |
|---|
| | | } |
|---|
| | | |
|---|
| | | //@Override |
|---|
| | | public void selectSaveGlassinfo(String engineeringId) { |
|---|
| | | //保存玻璃信息表 |
|---|
| | | //optimizeProjectMapper.selectJoinList(); |
|---|
| | | @Override |
|---|
| | | public void updateupPattenUsageState(UpPattenUsage upPattenUsage, Integer state) { |
|---|
| | | upPattenUsage.setState(state); |
|---|
| | | boolean updateSuccess=this.updateById(upPattenUsage); |
|---|
| | | log.info("更新状态{}",updateSuccess); |
|---|
| | | //更新状态 |
|---|
| | | } |
|---|
| | | |
|---|
| | | @Override |
|---|
| | | public UpPattenUsage selectedEngineering(String engineeringId) { |
|---|
| | | QueryWrapper<UpPattenUsage>wrapper = new QueryWrapper<>(); |
|---|
| | | wrapper.eq("engineering_id",engineeringId) |
|---|
| | | .last("limit 1"); |
|---|
| | | return this.getOne(wrapper); |
|---|
| | | } |
|---|
| | | |
|---|
| | | |
|---|
