| | |
|---|
| | | package com.mes.glassinfo.service.impl; |
|---|
| | | |
|---|
| | | import com.baomidou.dynamic.datasource.annotation.DS; |
|---|
| | | import com.github.yulichang.base.MPJBaseServiceImpl; |
|---|
| | | import com.github.yulichang.query.MPJQueryWrapper; |
|---|
| | | import com.mes.glassinfo.entity.GlassInfo; |
|---|
| | | import com.mes.glassinfo.entity.OptimizeGlassinfo; |
|---|
| | | import com.mes.glassinfo.mapper.GlassInfoMapper; |
|---|
| | | import com.mes.glassinfo.service.GlassInfoService; |
|---|
| | | import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; |
|---|
| | | import com.mes.pp.entity.OptimizeProject; |
|---|
| | | import com.mes.pp.mapper.OptimizeProjectMapper; |
|---|
| | | import com.mes.uppattenusage.entity.UpPattenUsage; |
|---|
| | | import lombok.extern.slf4j.Slf4j; |
|---|
| | | import org.springframework.beans.factory.annotation.Autowired; |
|---|
| | | import org.springframework.stereotype.Service; |
|---|
| | | import com.github.yulichang.base.MPJBaseServiceImpl; |
|---|
| | | |
|---|
| | | import java.util.ArrayList; |
|---|
| | | import java.util.Collections; |
|---|
| | | import java.util.List; |
|---|
| | | |
|---|
| | | /** |
|---|
| | |
|---|
| | | OptimizeProjectMapper optimizeProjectMapper; |
|---|
| | | @Override |
|---|
| | | @DS("pp") |
|---|
| | | |
|---|
| | | public List<GlassInfo> selectGlassInfo(String engineeringId) { |
|---|
| | | List<OptimizeGlassinfo> optimizeGlassinfos=null; |
|---|
| | | if (engineeringId != null) { |
|---|
| | | optimizeGlassinfos = optimizeProjectMapper.selectJoinList(OptimizeGlassinfo.class, new MPJQueryWrapper<OptimizeProject>() |
|---|
| | | .select("b.process_id,t.type,b.width,b.height,t.glass_thickness,t.glass_type,b.p_width,b.p_height,b.stock_id,b.heat_layout_id,b.heat_layout_sort,b.x_axis,b.y_axis,b.project_no,b.glass_id") |
|---|
| | | .select("b.process_id,t.type,b.width,b.height,t.glass_thickness,t.glass_type,b.p_width,b.p_height,b.layer, b.total_layer, b.stock_id,b.heat_layout_id,b.heat_layout_sort,b.x_axis,b.y_axis,b.project_no,b.glass_id") |
|---|
| | | .leftJoin("optimize_detail b on t.project_no=b.project_no") |
|---|
| | | .eq("t.state",200) |
|---|
| | | .eq("t.state",100) |
|---|
| | | .eq("t.project_no", engineeringId)); |
|---|
| | | } |
|---|
| | | |
|---|
| | |
|---|
| | | GlassInfo glassInfo = new GlassInfo(); |
|---|
| | | // 将 Map 中的每个键值对映射到 OptimizeGlassinfo 对象的相应字段上 |
|---|
| | | glassInfo.setEngineerId(map.getProjectNo()); |
|---|
| | | glassInfo.setFlowCardId(map.getProjectId()); |
|---|
| | | glassInfo.setFlowCardId(map.getProcessId()); |
|---|
| | | glassInfo.setFilmsid(map.getGlassType()); |
|---|
| | | glassInfo.setGlassType(map.getType()); |
|---|
| | | glassInfo.setWidth(map.getWidth()); |
|---|
| | | glassInfo.setHeight(map.getHeight()); |
|---|
| | | glassInfo.setEdgWidth(map.getPWidth()); |
|---|
| | | glassInfo.setLayer(map.getLayer()); |
|---|
| | | glassInfo.setTotalLayer(map.getTotalLayer()); |
|---|
| | | glassInfo.setEdgHeight(map.getPHeight()); |
|---|
| | | glassInfo.setThickness(map.getGlassThickness()); |
|---|
| | | glassInfo.setPatternSequence(map.getStockId());// |
|---|
| | | glassInfo.setTemperingLayoutId(map.getHeatLayoutId());//钢化版图id |
|---|
| | |
|---|
| | | log.info("查询出glassinfopro的数据{}:",optimizeGlassinfos); |
|---|
| | | return resultList; |
|---|
| | | } |
|---|
| | | |
|---|
| | | @Override |
|---|
| | | public void saveGlassInfo(List<GlassInfo> glassinfo) { |
|---|
| | | this.saveBatch(glassinfo); |
|---|
| | | } |
|---|
| | | } |
|---|
