~admin/HangZhouMes.git

			@@ -1,26 +1,56 @@
			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;
			import com.mes.common.config.Const;
			import com.mes.common.utils.RedisUtil;
			import com.mes.downglassinfo.entity.DownGlassInfo;
			import com.mes.downglassinfo.entity.request.DownGlassInfoRequest;
			import com.mes.downglassinfo.mapper.DownGlassInfoMapper;
			import com.mes.downglassinfo.service.DownGlassInfoService;
			import com.mes.downstorage.entity.DownStorageCageDetails;
			import com.mes.downstorage.service.DownStorageCageDetailsService;
			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 {

			@Autowired
			DownLoadCacheGlassTask downLoadCacheGlassTask;

			@Autowired
			DownStorageCageDetailsService downStorageCageDetailsService;

			@Autowired
			RedisUtil redisUtil;

			@Autowired
			FlowCardService flowCardService;

			/**
			* 根据流程卡号查询最大序号
			*/
			@Override
			public Integer getMaxSequenceByFlowCardId(String flowCardId) {
			public Integer getMaxSequenceByFlowCardId(String flowCardId, int layer) {
			LambdaQueryWrapper<DownGlassInfo> lambdaQueryWrapper = Wrappers.lambdaQuery();
			lambdaQueryWrapper.eq(DownGlassInfo::getFlowCardId, flowCardId)
			.eq(DownGlassInfo::getLayer, layer)
			.select(DownGlassInfo::getSequence)
			.orderByDesc(DownGlassInfo::getSequence)
			.last("LIMIT 1");
			@@ -45,7 +75,84 @@
			}

			@Override
			public List<DownGlassInfoDTO> queryWorkStationNotIn() {
			return baseMapper.queryWorkStationNotIn();
			public List<DownGlassInfoDTO> queryWorkStationIsIn(Boolean isDownload) {
			return baseMapper.queryWorkStationIsIn(isDownload);
			}

			@Override
			public boolean generateOutGlassTask(String glassId) {
			//更新卧式理片笼内玻璃状态
			downStorageCageDetailsService.update(new LambdaUpdateWrapper<DownStorageCageDetails>()
			.set(DownStorageCageDetails::getState, Const.GLASS_STATE_OUT).eq(DownStorageCageDetails::getGlassId, glassId));
			DownStorageCageDetails details = downStorageCageDetailsService.getOne(new LambdaQueryWrapper<DownStorageCageDetails>()
			.eq(DownStorageCageDetails::getGlassId, glassId));
			//生成下片信息
			DownGlassInfo downGlassInfo = new DownGlassInfo();
			BeanUtils.copyProperties(details, downGlassInfo);
			//获取当前流程卡最大片序
			downGlassInfo.setSequence(this.getMaxSequenceByFlowCardId(details.getFlowCardId(), details.getLayer()) + 1);
			this.save(downGlassInfo);
			//生成任务信息并向plc发送出片任务
			GlassInfo glassInfo = new GlassInfo();
			BeanUtils.copyProperties(details, glassInfo);
			return downLoadCacheGlassTask.initDownGlassTask(glassInfo, details.getSlot(), Const.G13_WORK_STATION, 2);
			}

			@Override
			public String setDownGlassInfoRequest(DownGlassInfoRequest request) {
			if (request == null) {
			redisUtil.deleteObject("downGlassRequest");
			} else {
			redisUtil.setCacheObject("downGlassRequest", request);
			}
			return "success";
			}

			@Override
			public List<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);
			}
			}
			}
			List<Map<String, List<Map<String, Object>>>> listMap=new ArrayList<>();
			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);
			}
			listMap.add(result);
			return listMap;
			}

			}