From 23deff80efa6651995f7c1013a968275045f0e0f Mon Sep 17 00:00:00 2001 From: ZengTao <2773468879@qq.com> Date: 星期四, 08 八月 2024 08:47:58 +0800 Subject: [PATCH] 添加查询流程卡打印数据 --- hangzhoumesParent/moduleService/UnLoadGlassModule/src/main/java/com/mes/downglassinfo/service/impl/DownGlassInfoServiceImpl.java | 56 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 56 insertions(+), 0 deletions(-) diff --git a/hangzhoumesParent/moduleService/UnLoadGlassModule/src/main/java/com/mes/downglassinfo/service/impl/DownGlassInfoServiceImpl.java b/hangzhoumesParent/moduleService/UnLoadGlassModule/src/main/java/com/mes/downglassinfo/service/impl/DownGlassInfoServiceImpl.java index 232743a..b09fcf6 100644 --- a/hangzhoumesParent/moduleService/UnLoadGlassModule/src/main/java/com/mes/downglassinfo/service/impl/DownGlassInfoServiceImpl.java +++ b/hangzhoumesParent/moduleService/UnLoadGlassModule/src/main/java/com/mes/downglassinfo/service/impl/DownGlassInfoServiceImpl.java @@ -1,6 +1,9 @@ package com.mes.downglassinfo.service.impl; +import cn.hutool.json.JSONArray; +import com.alibaba.fastjson.JSONObject; import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; +import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; import com.baomidou.mybatisplus.core.conditions.update.LambdaUpdateWrapper; import com.baomidou.mybatisplus.core.toolkit.Wrappers; import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; @@ -15,11 +18,15 @@ import com.mes.downworkstation.entity.dto.DownGlassInfoDTO; import com.mes.glassinfo.entity.GlassInfo; import com.mes.job.DownLoadCacheGlassTask; +import com.mes.pp.service.FlowCardService; import org.springframework.beans.BeanUtils; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; +import java.util.ArrayList; +import java.util.HashMap; import java.util.List; +import java.util.Map; @Service public class DownGlassInfoServiceImpl extends ServiceImpl<DownGlassInfoMapper, DownGlassInfo> implements DownGlassInfoService { @@ -32,6 +39,9 @@ @Autowired RedisUtil redisUtil; + + @Autowired + FlowCardService flowCardService; /** * 鏍规嵁娴佺▼鍗″彿鏌ヨ鏈�澶у簭鍙� @@ -97,4 +107,50 @@ } return "success"; } + + @Override + public Map<String, List<Map<String, Object>>> downGlassPrint(DownGlassInfo downGlassInfo){ + QueryWrapper<DownGlassInfo> queryWrapper = Wrappers.query(); + queryWrapper.eq("flow_card_id", "NG24080012A001") + .eq("layer", 1) + .select("flow_card_id", "layer", "width", "height", "filmsid", "thickness","glass_type","COUNT(*) AS quantity") + .groupBy("flow_card_id", "layer", "width", "height", "filmsid", "thickness"); + List<Map<String, Object>> resultList = baseMapper.selectMaps(queryWrapper); + + + List<Map<String, Object>> projectInfo=flowCardService.selectProject(downGlassInfo.getFlowCardId(),downGlassInfo.getLayer()); + List<Map<String, Object>> flowCardInfo=flowCardService.selectFlowCard(downGlassInfo.getFlowCardId(),downGlassInfo.getLayer()); + + for (Map<String, Object> row : flowCardInfo) { + int order_number = (int) row.get("order_number"); + int technology_number = (int) row.get("technology_number"); + + for (Map<String, Object> row1 : resultList) { + int glass_type = (int) row1.get("glass_type"); + int layer = (int) row1.get("layer"); + Long quantity=(Long) row1.get("quantity"); + + if(order_number==glass_type&&technology_number==layer){ + row.put("quantity1",quantity); + } + } + } + Map<String, List<Map<String, Object>>> result = new HashMap<>(); + result.put("detail", projectInfo); + result.put("detailList", flowCardInfo); + for (Map<String, Object> row : projectInfo) { + String order_number = (String) row.get("process"); + String[] processes=order_number.split("->"); + List<Map<String, Object>> processList = new ArrayList<>(); + for (int i = 0; i < processes.length; i++) { + Map<String, Object> processMap = new JSONObject(); + processMap.put("process", processes[i]); + processMap.put("id", i); + processList.add(processMap); + } + result.put("processList", processList); + } + return result; + } + } -- Gitblit v1.8.0