From abb9b5c51d8a20be68b64e0c4a9620f6578d2e3a Mon Sep 17 00:00:00 2001 From: pang.jiabao <pang_jiabao@163.com> Date: 星期三, 30 四月 2025 09:59:26 +0800 Subject: [PATCH] 手动导入订单和mes下发订单,增加客户名称和备注字段 --- src/main/java/com/zy/asrs/service/impl/OpenServiceImpl.java | 1598 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 1,580 insertions(+), 18 deletions(-) diff --git a/src/main/java/com/zy/asrs/service/impl/OpenServiceImpl.java b/src/main/java/com/zy/asrs/service/impl/OpenServiceImpl.java index c55bc31..29658dd 100644 --- a/src/main/java/com/zy/asrs/service/impl/OpenServiceImpl.java +++ b/src/main/java/com/zy/asrs/service/impl/OpenServiceImpl.java @@ -1,27 +1,41 @@ package com.zy.asrs.service.impl; +import com.alibaba.fastjson.JSON; +import com.alibaba.fastjson.JSONObject; import com.baomidou.mybatisplus.mapper.EntityWrapper; +import com.baomidou.mybatisplus.mapper.Wrapper; import com.core.common.Cools; import com.core.common.DateUtils; +import com.core.common.R; import com.core.common.SnowflakeIdWorker; import com.core.exception.CoolException; import com.zy.asrs.entity.*; import com.zy.asrs.entity.param.*; import com.zy.asrs.entity.result.OpenOrderCompeteResult; import com.zy.asrs.entity.result.StockVo; -import com.zy.asrs.mapper.TagMapper; +import com.zy.asrs.entity.result.ZphjcdgzVo; +import com.zy.asrs.entity.result.ZphjcdwcVo; +import com.zy.asrs.mapper.*; import com.zy.asrs.service.*; import com.zy.asrs.utils.MatUtils; +import com.zy.common.constant.MesConstant; import com.zy.common.model.DetlDto; +import com.zy.common.model.LocTypeDto; +import com.zy.common.model.StartupDto; +import com.zy.common.model.enums.WorkNoType; +import com.zy.common.service.CommonService; +import com.zy.common.utils.HttpHandler; import com.zy.common.utils.NodeUtils; +import com.zy.system.entity.Config; +import com.zy.system.mapper.ConfigMapper; import lombok.extern.slf4j.Slf4j; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import org.springframework.transaction.annotation.Transactional; -import java.util.ArrayList; -import java.util.Date; -import java.util.List; +import javax.annotation.Resource; +import java.util.*; +import java.util.stream.Collectors; /** * Created by vincent on 2022/4/9 @@ -29,6 +43,14 @@ @Slf4j @Service public class OpenServiceImpl implements OpenService { + + // 浜屾ゼ鍫嗗灈鏈哄搴斿叆搴撶珯鐐� + private static final int[] secondFloorIn = new int[]{0,2061,2064,2067,2070,2073,2076}; + // 鍫嗗灈鏈哄搴斾竴妤煎嚭搴撶珯鐐� + private static final int[] secondFloorOut = new int[]{0,3002,3003,3006,3008,3009,3012}; + // 鍫嗗灈鏈哄搴斾竴妤煎叆搴撶珯鐐� + private static final int[] oneFloorIn = new int[]{0,3001,3004,3005,3007,3010,3011}; + @Autowired private OrderService orderService; @@ -54,6 +76,41 @@ private BasDevpService basDevpService; @Autowired private WrkDetlService wrkDetlService; + @Autowired + private WaitPakinService waitPakinService; + @Autowired + private CommonService commonService; + @Autowired + private LocDetlRullUpDetailService locDetlRullUpDetailService; + @Autowired + private WrkDetlSingleService wrkDetlSingleService; + @Autowired + private WrkMastLogService wrkMastLogService; + @Autowired + private WrkMastStaService wrkMastStaService; + @Autowired + private WrkMastStaLogService wrkMastStaLogService; + @Autowired + private StaDescService staDescService; + @Autowired + private LocMastService locMastService; + @Autowired + private ApiLogService apiLogService; + + @Resource + private MatMapper matMapper; + + @Resource + private LocDetlMapper locDetlMapper; + + @Resource + private ConfigMapper configMapper; + + @Resource + private OrderMapper orderMapper; + + @Resource + private BasCrnpMapper basCrnpMapper; @Override @Transactional @@ -586,19 +643,28 @@ LabellerMatParam labellerMatParam = new LabellerMatParam(); labellerMatParam.setDevNo(param.getDevNo()); labellerMatParam.setLabNo(param.getLabNo()); - ArrayList<LabellerMatParam.CombMat> combMats = new ArrayList<>(); - String orderNo = ""; - for (WrkDetl wrkDetl:wrkDetls){ - LabellerMatParam.CombMat combMat = new LabellerMatParam.CombMat(wrkDetl); - orderNo=wrkDetl.getOrderNo(); - combMat.setTemp1("1"); - combMats.add(combMat); - } - labellerMatParam.setCombMats(combMats); - labellerMatParam.setLabellingTime(DateUtils.convert(new Date())); labellerMatParam.setWrkNo(basDevp.getWrkNo().toString()); - labellerMatParam.setLabTemplate("1"); - labellerMatParam.setOrderNo(orderNo); +// ArrayList<LabellerMatParam.CombMat> combMats = new ArrayList<>(); + ArrayList<LabellerMatParam.BoxNo> boxNos = new ArrayList<>(); +// String orderNo = ""; + + for (WrkDetl wrkDetl:wrkDetls){ + LabellerMatParam.BoxNo boxNo = new LabellerMatParam.BoxNo(); + boxNo.setBoxNo(wrkDetl.getBatch()); + boxNos.add(boxNo); + } + labellerMatParam.setBoxNos(boxNos); +// for (WrkDetl wrkDetl:wrkDetls){ +// LabellerMatParam.CombMat combMat = new LabellerMatParam.CombMat(wrkDetl); +// orderNo=wrkDetl.getOrderNo(); +// combMat.setTemp1("1"); +// combMats.add(combMat); +// } + +// labellerMatParam.setCombMats(combMats); +// labellerMatParam.setLabellingTime(DateUtils.convert(new Date())); +// labellerMatParam.setLabTemplate("1"); +// labellerMatParam.setOrderNo(orderNo); wrkMast.setWrkSts(53L); if (!wrkMastService.updateById(wrkMast)){ throw new CoolException("寮傚父锛岃閲嶆柊鐢宠"); @@ -612,7 +678,46 @@ @Override @Transactional public void labellerComplete(LabellerCompleteParam param) { - // + if (Cools.isEmpty(param.getDevNo())){ + throw new CoolException("鍙傛暟锛氱珯鐐瑰彿 devNo涓虹┖"); + }else if (Cools.isEmpty(param.getLabNo())){ + throw new CoolException("鍙傛暟锛氳创鏍囨満鍙� labNo涓虹┖"); + }else if (Cools.isEmpty(param.getLabResult())){ + throw new CoolException("鍙傛暟锛氳创鏍囩粨鏋� labResult涓虹┖"); + }else if (Cools.isEmpty(param.getWrkNo())){ + throw new CoolException("鍙傛暟锛氳创鏍囦换鍔″彿 wrkNo涓虹┖"); + } + BasDevp basDevp = basDevpService.selectById(param.getDevNo()); + if (Cools.isEmpty(basDevp)){ + throw new CoolException("鍙傛暟锛氱珯鐐瑰彿 devNo="+param.getDevNo()+"涓嶅瓨鍦�"); + }else if (Cools.isEmpty(basDevp.getWrkNo()) || basDevp.getWrkNo()==0 ){ + throw new CoolException("绔欑偣:"+param.getDevNo()+" 涓嶅瓨鍦ㄥ伐浣滀腑浠诲姟"); + }else if(!basDevp.getWrkNo().toString().equals(param.getWrkNo())){ + throw new CoolException("绔欑偣:"+param.getDevNo()+" 杩涜涓换鍔″彿="+basDevp.getWrkNo()+" 涓庤创鏍囩粨鏋滆繑鍥炰换鍔″彿="+param.getWrkNo()+" 涓嶄竴鑷�"); + } + + WrkMast wrkMast = wrkMastService.selectOne(new EntityWrapper<WrkMast>().eq("wrk_no", basDevp.getWrkNo())); + if (Cools.isEmpty(wrkMast)){ + throw new CoolException("绔欑偣:"+param.getDevNo()+" 宸ヤ綔涓换鍔′笉瀛樺湪,浠诲姟鍙凤細"+basDevp.getWrkNo()); + }else if (!wrkMast.getWrkSts().equals(53L)){ + throw new CoolException("绔欑偣:"+param.getDevNo()+" 宸ヤ綔涓换鍔$姸鎬佸凡鍙樻洿锛岃鍕块噸澶嶇敵璇�,浠诲姟鍙凤細"+basDevp.getWrkNo()+",浠诲姟鐘舵��:"+wrkMast.getWrkSts$()); + } + + if (param.getLabResult().equals("OK")){ + wrkMast.setWrkSts(54L); + wrkMast.setStaNo(144); + if (!wrkMastService.updateById(wrkMast)){ + throw new CoolException("寮傚父锛岃閲嶆柊鐢宠"); + } + }else if (param.getLabResult().equals("NG")){ + wrkMast.setWrkSts(52L);//閲嶆柊璐存爣 + if (!wrkMastService.updateById(wrkMast)){ + throw new CoolException("寮傚父锛岃閲嶆柊鐢宠"); + } + }else { + throw new CoolException("鍙傛暟锛氳创鏍囩粨鏋�:labResult"+param.getLabResult()+";璇锋寜瑙勫垯鍙戦�侊細鎴愬姛锛歄K 銆佸け璐�:NG"); + } + } /* @@ -620,8 +725,172 @@ * */ @Override @Transactional - public void palletizingComplete(PalletizingCompleteParam param) { + public void PalletizingCompleteTwoFloorParam(PalletizingCompleteTwoFloorParam param) { + Long userId = 7777L;//涓帶 + //鍒ゆ柇param鍙傛暟 + if (Cools.isEmpty(param.getBarcode())){ + throw new CoolException("鍙傛暟锛氭墭鐩樼爜 barcode涓虹┖"); + }else if (Cools.isEmpty(param.getPalletizingNo())){ + throw new CoolException("鍙傛暟锛氱爜鍨涗綅缂栧彿 palletizingNo涓虹┖"); + }else if (Cools.isEmpty(param.getBoxType())){ + throw new CoolException("鍙傛暟锛氭湪绠辩被鍨� boxType涓虹┖"); + }else if (Cools.isEmpty(param.getMatList()) || param.getMatList().size()==0){ + throw new CoolException("鍙傛暟锛氱墿鏂欐槑缁� matLists涓虹┖"); + } + String matnrOne = "";//鏈ㄧ鐩稿悓浣嶇疆 瑙勬牸 matnr鏍¢獙 1銆佸乏 + String matnrTwo = "";//鏈ㄧ鐩稿悓浣嶇疆 瑙勬牸 matnr鏍¢獙 2銆佸彸 + ArrayList<String> boxNos = new ArrayList<>(); //鏈ㄧ鍞竴缂栫爜鏌ラ噸 锛坆atch锛� + //鍒ゆ柇matLists鍙傛暟 + for (PalletizingCompleteTwoFloorParam.MatList matList:param.getMatList()){ + if (Cools.isEmpty(matList.getMatnr())){ + throw new CoolException("鍙傛暟锛氳鏍� matnr涓虹┖"); + }else if (Cools.isEmpty(matList.getPosition())){ + throw new CoolException("瑙勬牸锛�"+matList.getMatnr()+"銆佸弬鏁帮細鐮佸灈浣嶇疆 position涓虹┖"); + }else if (Cools.isEmpty(matList.getBatch())){ + throw new CoolException("瑙勬牸锛�"+matList.getMatnr()+"銆佸弬鏁帮細鏈ㄧ缂栧彿 batch涓虹┖"); + }else if (Cools.isEmpty(matList.getModel())){ + throw new CoolException("瑙勬牸锛�"+matList.getMatnr()+"銆佸弬鏁帮細鍗峰彿 model涓虹┖"); + }else if (Cools.isEmpty(matList.getBatch())){ + throw new CoolException("瑙勬牸锛�"+matList.getMatnr()+"銆佸弬鏁帮細鏈ㄧ缂栧彿 boxNo涓虹┖"); + }else if (Cools.isEmpty(matList.getWeight()) || matList.getWeight().equals(0D)){ + throw new CoolException("瑙勬牸锛�"+matList.getMatnr()+"銆佸弬鏁帮細鍑�閲� weight涓虹┖"); + }else if (Cools.isEmpty(matList.getRoughWeight()) || matList.getRoughWeight().equals(0D)){ + throw new CoolException("瑙勬牸锛�"+matList.getMatnr()+"銆佸弬鏁帮細姣涢噸 roughWeight"); + }else if (Cools.isEmpty(matList.getRollExtent()) || matList.getRollExtent().equals(0D)){ + throw new CoolException("瑙勬牸锛�"+matList.getMatnr()+"銆佸弬鏁帮細鍗烽暱搴� rollExtent"); + } +// else if (Cools.isEmpty(matList.getJoint()) || matList.getJoint()==0){ +// throw new CoolException("瑙勬牸锛�"+matList.getMatnr()+"銆佸弬鏁帮細鎺ュご鏁� joint"); +// } + + if (matList.getPosition().equals("1")){//1銆佸乏 2銆佸彸 + if (!matnrOne.equals("")){ + if (!matnrOne.equals(matList.getMatnr())){ + throw new CoolException("鏈ㄧ浣嶇疆锛�"+matList.getPosition()+"瀛樺湪涓嶅悓瑙勬牸鍗蜂俊鎭�"); + } + }else { + matnrOne=matList.getMatnr(); + } + }else if (matList.getPosition().equals("2")){ + if (!matnrTwo.equals("")){ + if (!matnrTwo.equals(matList.getMatnr())){ + throw new CoolException("鏈ㄧ浣嶇疆锛�"+matList.getPosition()+"瀛樺湪涓嶅悓瑙勬牸鍗蜂俊鎭�"); + } + }else { + matnrTwo=matList.getMatnr(); + } + }else { + throw new CoolException("鍙傛暟锛氭湪绠辩紪鍙� boxNo:"+matList.getBatch()+",鏈ㄧ浣嶇疆閿欒锛�"+matList.getPosition()); + } + + if (!boxNos.contains(matList.getBatch())){ + boxNos.add(matList.getBatch()); + }else { + throw new CoolException("鍙傛暟锛氭湪绠辩紪鍙� boxNo:"+matList.getBatch()+",鏈ㄧ缂栫爜瀛樺湪閲嶅"); + } + } + +// BasDevp basDevp = basDevpService.selectById(Integer.parseInt(param.getDevNo$())); +// if (Cools.isEmpty(basDevp)){ +// throw new CoolException("鍙傛暟锛氱爜鍨涗綅缂栧彿 palletizingNo="+param.getPalletizingNo()+"涓嶅瓨鍦�"); +// } +// if (Cools.isEmpty(basDevp.getAutoing()) || !basDevp.getAutoing().equals("Y")){ +// throw new CoolException("鐮佸灈浣嶇紪鍙� palletizingNo="+param.getPalletizingNo()+" 鎵�澶勭珯鐐逛笉鏄嚜鍔ㄧ姸鎬�"); +// } +// if (Cools.isEmpty(basDevp.getLoading()) || !basDevp.getLoading().equals("Y")){ +// throw new CoolException("鐮佸灈浣嶇紪鍙� palletizingNo="+param.getPalletizingNo()+" 鎵�澶勭珯鐐逛笉鏄湁鐗╃姸鎬�"); +// } +// if (Cools.isEmpty(basDevp.getCanining()) || !basDevp.getCanining().equals("Y")){ +// throw new CoolException("鐮佸灈浣嶇紪鍙� palletizingNo="+param.getPalletizingNo()+" 鎵�澶勭珯鐐逛笉鏄兘鍏ョ姸鎬�"); +// } + + + if (locDetlService.selectCount(new EntityWrapper<LocDetl>().eq("zpallet", param.getBarcode()))!=0 + || wrkDetlService.selectCount(new EntityWrapper<WrkDetl>().eq("zpallet", param.getBarcode()))!=0 + || waitPakinService.selectCount(new EntityWrapper<WaitPakin>().eq("zpallet", param.getBarcode()))!=0){ + throw new CoolException("鎵樼洏鏉$爜锛�"+param.getBarcode()+"宸插瓨鍦紝璇峰嬁閲嶅缁勬墭"); + } + + + Date now = new Date(); + for (PalletizingCompleteTwoFloorParam.MatList matList:param.getMatList()){ + Mat mat = matService.selectByMatnr(matList.getMatnr()); + if (Cools.isEmpty(mat)) { + mat = new Mat(); + mat.setMatnr(matList.getMatnr()); + mat.setMaktx(matList.getMatnr()); + mat.setTagId(tagService.getTop().getId()); + mat.setCreateBy(userId); + mat.setCreateTime(now); + mat.setUpdateBy(userId); + mat.setUpdateTime(now); + mat.setStatus(1); + if (!matService.insert(mat)) { + throw new CoolException("瑙勬牸娣诲姞澶辫触锛岃鑱旂郴绠$悊鍛�"); + } + } + WaitPakin waitPakin = new WaitPakin(); + waitPakin.sync(mat); + waitPakin.setBatch(matList.getBatch()); //鏈ㄧ缂栫爜 //鎵规 鍞竴鍊� 绠卞彿 + waitPakin.setModel(matList.getModel()); //鍗峰彿 鍞竴鍊� + waitPakin.setBrand(param.getBoxType()); //鏈ㄧ绫诲瀷 + waitPakin.setZpallet(param.getBarcode()); //鎵樼洏鐮� + waitPakin.setOrigin(matList.getPosition()); //鏈ㄧ鍦ㄦ墭鐩樹笂鐨勪綅缃� + waitPakin.setWeight(matList.getWeight()); //鍑�閲� + waitPakin.setVolume(matList.getRoughWeight()); //姣涢噸 + waitPakin.setPrice(matList.getRollExtent()); //闀垮害 + waitPakin.setSpecs(String.valueOf(matList.getJoint())); //鎺ュご + waitPakin.setIoStatus("N"); // 鍏ュ嚭鐘舵�� + waitPakin.setAnfme(matList.getAnfme()); // 鏁伴噺 + waitPakin.setStatus("Y"); // 鐘舵�� + waitPakin.setAppeUser(userId); + waitPakin.setAppeTime(now); + waitPakin.setModiUser(userId); + waitPakin.setModiTime(now); + if (!waitPakinService.insert(waitPakin)) { + throw new CoolException("淇濆瓨鍏ュ簱閫氱煡妗eけ璐�"); + } + } + + } + + /* + * 鏉剧洓(1妤�)锛氱爜鍨涘畬鎴愪笅鍙戝叆搴撲俊鎭� + * */ + @Override + @Transactional + public void palletizingCompleteS(PalletizingCompleteParam param) { + //鍒ゆ柇param鍙傛暟 + if (Cools.isEmpty(param.getBarcode())){ + throw new CoolException("鍙傛暟锛氭墭鐩樼爜 barcode涓虹┖"); + } + + WrkMast wrkMast = wrkMastService.selectByBarcode(param.getBarcode()); + if (Cools.isEmpty(wrkMast) || wrkMast.getWrkSts()!=2){ + log.error("閫�搴撶爜鍨涘畬鎴愶紝杩斿洖鎵樼洏鐮佹湭鏌ヨ鍒板伐浣滄。妗堬紒"); + throw new CoolException("鍙傛暟锛氭墭鐩樼爜 barcode鏈煡璇㈠埌宸ヤ綔妗f"); + } + wrkMast.setSheetNo("4"); + wrkMastService.updateById(wrkMast); + } + + + /* + *涓帶锛氬嚭搴撳畬鎴愭湀鍙扮浉鍏� + * */ + @Override + @Transactional + public void balconyComplete(LabellerMatParam param) { + if (Cools.isEmpty(param.getWrkNo())){ + throw new CoolException("宸ヤ綔鍙蜂负绌猴紒"); + } + WrkMast wrkMast = wrkMastService.selectOne(new EntityWrapper<WrkMast>().eq("wrk_no", param.getWrkNo())); + if (Cools.isEmpty(wrkMast)){ + throw new CoolException("宸ヤ綔鍙蜂负绌猴紒"); + } + wrkMast.setWrkSts(57L); + wrkMastService.updateById(wrkMast); } /* @@ -630,6 +899,78 @@ @Override @Transactional public void singleUnstackingComplete(SingleUnstackingCompleteParam param) { + Long userId = 8888L;//妗佹灦涓婁綅杞欢 + //鍒ゆ柇param鍙傛暟 + if (Cools.isEmpty(param.getPalletizingNo())){ + throw new CoolException("鍙傛暟锛氱爜鍨涗綅缂栧彿 palletizingNo涓虹┖"); + }else if (Cools.isEmpty(param.getMatList()) || param.getMatList().size()==0){ + throw new CoolException("鍙傛暟锛氱墿鏂欐槑缁� matLists涓虹┖"); + } + + ArrayList<WrkDetl> wrkDetlsNew = new ArrayList<>(); + ArrayList<WrkDetlSingle> wrkDetlsOld = new ArrayList<>(); + //鍒ゆ柇matLists鍙傛暟 + for (SingleUnstackingCompleteParam.MatList matList:param.getMatList()){ + if (Cools.isEmpty(matList.getPosition())){ + throw new CoolException("鍙傛暟锛氱爜鍨涗綅缃� position涓虹┖"); + }else if (Cools.isEmpty(matList.getBoxNo())){ + throw new CoolException("鍙傛暟锛氭湪绠辩紪鍙� boxNo涓虹┖"); + } + WrkDetlSingle wrkDetlSingleOne = wrkDetlSingleService.selectOne(new EntityWrapper<WrkDetlSingle>().eq("batch", matList.getBoxNo())); + List<WrkDetlSingle> wrkDetlSingles = wrkDetlSingleService.selectList(new EntityWrapper<WrkDetlSingle>() + .eq("wrk_no", wrkDetlSingleOne.getWrkNo()).eq("io_time", wrkDetlSingleOne.getIoTime())); + boolean sign=true; + for (WrkDetlSingle wrkDetlSingle:wrkDetlSingles){ + WrkDetl wrkDetl = new WrkDetl(); + wrkDetl.sync(wrkDetlSingle); + wrkDetlsNew.add(wrkDetl); + wrkDetlsOld.add(wrkDetlSingle); + sign=false; + break; + } + if (sign){ + throw new CoolException("鍙傛暟锛氭湪绠辩紪鍙� boxNo鏈煡璇㈠埌瀵瑰簲鐨勫伐浣滄槑缁嗭紒"); + } + } + + // 鐢熸垚宸ヤ綔鍙� + int workNo = commonService.getWorkNo(WorkNoType.getWorkNoType(202)); + Date now = new Date(); + + // 鐢熸垚宸ヤ綔妗� + WrkMast wrkMast = new WrkMast(); + wrkMast.setWrkNo(workNo); + wrkMast.setIoTime(now); + wrkMast.setWrkSts(51L); // 宸ヤ綔鐘舵�侊細鐢熸垚鍏ュ簱ID + wrkMast.setIoType(202); // 鍏ュ嚭搴撶姸鎬侊細202.鎷嗗灈鍚庡嚭搴� + wrkMast.setIoPri(99D); // 浼樺厛绾� + wrkMast.setSourceStaNo(param.getDevNo$()); + wrkMast.setStaNo(144); //璐存爣绔欑偣 鐩存帴鍒板熬绔� + // 鎿嶄綔浜哄憳鏁版嵁 + wrkMast.setAppeUser(userId); + wrkMast.setAppeTime(now); + wrkMast.setModiUser(userId); + wrkMast.setModiTime(now); + if (!wrkMastService.insert(wrkMast)) { + throw new CoolException("鐢熸垚宸ヤ綔妗eけ璐�==銆嬫鏋朵笂浣嶈蒋浠讹細鍗曟鎷嗗灈瀹屾垚閫氱煡"); + } + + for (WrkDetl wrkDetl : wrkDetlsNew){ + wrkDetl.setWrkNo(wrkMast.getWrkNo()); + wrkDetl.setIoTime(wrkMast.getIoTime()); + wrkDetl.setAppeTime(now); + wrkDetl.setModiTime(now); + if (!wrkDetlService.insert(wrkDetl)) { + throw new CoolException("淇濆瓨宸ヤ綔鏄庣粏澶辫触==銆嬫鏋朵笂浣嶈蒋浠讹細鍗曟鎷嗗灈瀹屾垚閫氱煡"); + } + } + + for (WrkDetlSingle wrkDetlSingle : wrkDetlsOld) { + wrkDetlSingleService.delete(new EntityWrapper<WrkDetlSingle>() + .eq("batch",wrkDetlSingle.getBatch()) + .eq("wrk_no",wrkDetlSingle.getWrkNo()) + .eq("io_time",wrkDetlSingle.getIoTime())); + } } @@ -639,7 +980,1228 @@ @Override @Transactional public void singleMountUnstackingComplete(SingleMountUnstackingCompleteParam param) { +// Long userId = 8888L;//妗佹灦涓婁綅杞欢 + //鍒ゆ柇param鍙傛暟 + if (Cools.isEmpty(param.getBarcode())){ + throw new CoolException("鍙傛暟锛氭墭鐩樼爜 barcode涓虹┖"); + } + WrkMast wrkMastMatrix = wrkMastService.selectByBarcode(param.getBarcode()); + if (Cools.isEmpty(wrkMastMatrix)){ + throw new CoolException("鍙傛暟锛氭墭鐩樼爜鏌ヨ宸ヤ綔妗eけ璐ワ細"+param.getBarcode()); + } + wrkMastMatrix.setSheetNo("2"); + if (!wrkMastService.updateById(wrkMastMatrix)){ + throw new CoolException("鏇存柊宸ヤ綔妗eけ璐�==銆嬫鏋朵笂浣嶈蒋浠讹細鍗曟墭鎷嗗灈瀹屾垚閫氱煡"); + } + } + + /* + * + * */ + @Override + @Transactional + public void cs2() { +// int[] staNos =new int[]{122}; +// for (Integer staNo:staNos){ +// int[] crnNos =new int[]{6}; +// for (Integer crnNo:crnNos){ +// descSta(staNo,crnNo); +// } +// } + + } + + @Override + public void updateBarcode() { + List<LocMast> locMasts = locMastService.selectList(new EntityWrapper<LocMast>().eq("loc_sts", "D")); + for (int i = 0; i < locMasts.size(); i ++) { + LocMast locMast = locMasts.get(i); + locMast.setBarcode("a"+i); + locMastService.updateById(locMast); + } + System.out.println("鏇存柊瀹屼簡" + locMasts.size()); + } + + @Override + @Transactional + public R prodCheck(List<ProdCheckParam> param) { + if (param.isEmpty()) { + return R.parse("璇锋眰鍙傛暟涓嶈兘涓虹┖"); + } + for (ProdCheckParam checkParam : param) { + // 鏇存柊搴撳瓨鏄庣粏鏄惁鍚堟牸 + LocDetl locDetl = locDetlService.selectOne(new EntityWrapper<LocDetl>().eq("model", checkParam.getRollNo())); + // 鏇存柊鍟嗗搧琛ㄦ槸鍚﹀悎鏍� +// Mat mat = matService.selectOne(new EntityWrapper<Mat>().eq("model", checkParam.getRollNo())); + if (locDetl == null) { // || mat == null + throw new CoolException("鏇存柊鏄惁鍚堟牸鐗╂枡涓嶅瓨鍦細" + checkParam); + } + + locDetl.setThreeCode(checkParam.getQualified()); +// mat.setThreeCode(checkParam.getQualified()); + + locDetlService.update(locDetl, new EntityWrapper<LocDetl>().eq("model", checkParam.getRollNo())); +// matService.update(mat, (new EntityWrapper<Mat>().eq("model", checkParam.getRollNo()))); + } + + return R.ok("鏇存柊鎴愬姛"); + } + + @Override + @Transactional + public String fxprk(FxprkParam param) { + + // 鏍规嵁鍖呰缁勫彿鑾峰彇鍒版湪绠卞嵎淇℃伅 + List<Mat> list = matService.selectList(new EntityWrapper<Mat>().in("brand", param.getBoxList().stream().map(FxprkParam.Box::getPackageGroupNo).collect(Collectors.toList()))); + if (list.isEmpty()) { + throw new CoolException("娌℃湁鏌ヨ鍒拌鍖呰缁勫彿淇℃伅锛�" + param.getBoxList().toString()); + } + + LocTypeDto locTypeDto = new LocTypeDto(); + locTypeDto.setLocType1((short) 1); + StartupDto dto = commonService.getLocNo(1, param.getPalletizingNo(), locTypeDto, 0); + + // 杩斿洖GWCS鐩爣淇℃伅 + pushStaNoToGwcs(param.getPalletizingNo(), dto.getStaNo(), dto.getWorkNo(), param.getBarcode(),"涓�妤煎弽淇搧鍏ュ簱鎺ㄩ�乬wcs"); +// if (!result) { +// throw new CoolException("鍏ュ簱鍥炴帹鍏ュ簱鐮佸ご缁橤WCS澶辫触"); +// } + + int workNo = dto.getWorkNo(); + Date now = new Date(); + // 鐢熸垚宸ヤ綔妗� + WrkMast wrkMast = new WrkMast(); + wrkMast.setWrkNo(workNo); + wrkMast.setIoTime(new Date()); + wrkMast.setWrkSts(1L); // 宸ヤ綔鐘舵�侊細璁惧涓婅蛋 + wrkMast.setIoType(1); // 鍏ュ嚭搴撶姸鎬侊細1.鍏ュ簱 + wrkMast.setIoPri(13D); // 浼樺厛绾� + wrkMast.setCrnNo(dto.getCrnNo()); + wrkMast.setSourceStaNo(param.getPalletizingNo()); + wrkMast.setStaNo(dto.getStaNo()); + wrkMast.setLocNo(dto.getLocNo()); + wrkMast.setBarcode(param.getBarcode()); // 鎵樼洏鐮� + wrkMast.setFullPlt("Y"); // 婊℃澘锛歒 + wrkMast.setPicking("N"); // 鎷f枡 + wrkMast.setExitMk("N"); // 閫�鍑� + wrkMast.setEmptyMk("N"); // 绌烘澘 + wrkMast.setLinkMis("Y"); + wrkMast.setCtnType(1); // 瀹瑰櫒绫诲瀷 + // 鎿嶄綔浜哄憳鏁版嵁 + wrkMast.setAppeTime(now); + wrkMast.setModiTime(now); + boolean res = wrkMastService.insert(wrkMast); + if (!res) { + throw new CoolException("淇濆瓨宸ヤ綔妗eけ璐�"); + } + + for (Mat obj : list) { + WrkDetl wrkDetl = new WrkDetl(); + wrkDetl.sync(obj); + wrkDetl.setWrkNo(wrkMast.getWrkNo()); + wrkDetl.setAnfme(1.0); + // 閲嶆柊瀹氫綅鏈ㄧ浣嶇疆 + for (FxprkParam.Box box :param.getBoxList()) { + if (box.getPackageGroupNo().equals(obj.getBrand())) { + if (!box.getBoxPos().equals(obj.getOrigin())) { + wrkDetl.setOrigin(box.getBoxPos()); + wrkDetl.setZpallet(param.getBarcode()); + wrkDetl.setBarcode(param.getBarcode()); + matMapper.updateBoxPos(box.getPackageGroupNo(), box.getBoxPos(),param.getBarcode()); + } + break; + } + } + wrkDetl.setIoTime(now); + wrkDetl.setAppeTime(now); + wrkDetl.setModiTime(now); + if (!wrkDetlService.insert(wrkDetl)) { + throw new CoolException("淇濆瓨宸ヤ綔鏄庣粏澶辫触"); + } + } + + // 鏇存柊鐩爣搴撲綅鐘舵�� + LocMast locMast = locMastService.selectById(dto.getLocNo()); + if (locMast.getLocSts().equals("O")) { + locMast.setLocSts("S"); // S.鍏ュ簱棰勭害 + locMast.setModiTime(now); + if (!locMastService.updateById(locMast)) { + throw new CoolException("鏀瑰彉搴撲綅鐘舵�佸け璐�"); + } + } else { + throw new CoolException(dto.getLocNo() + "鐩爣搴撲綅宸茶鍗犵敤"); + } + return "鍏ュ簱鎴愬姛"; + } + + @Override + @Transactional + public R kthl(KthlParam param) { + + // 鑾峰彇妯″紡涓虹數鑴戞ā寮忥紝鏃犱换鍔$殑鍫嗗灈鏈哄垪琛�:闃叉鍒嗛厤鍒板爢鍨涙満涓嶅彲鐢� + List<BasCrnp> basCrnps = basCrnpService.selectList(new EntityWrapper<BasCrnp>().eq("crn_sts",3) + .eq("wrk_no",0).eq("in_enable","Y").eq("out_enable","Y")); + if (basCrnps.isEmpty()) { + // 閮芥湁浠诲姟鍒欒幏鍙栫數鑴戞ā寮忕殑鍫嗗灈鏈哄垪琛� + basCrnps = basCrnpService.selectList(new EntityWrapper<BasCrnp>().eq("crn_sts",3).eq("in_enable","Y") + .eq("out_enable","Y")); + } + if (basCrnps.isEmpty()) { + throw new CoolException("娌℃湁鍙敤鍫嗗灈鏈�,鍫嗗灈鏈哄仠姝㈡垨寮傚父鎴栫鐢�"); + } + // 鍙敤鍫嗗灈鏈哄垪琛� + List<Integer> crnNoList = basCrnps.stream().map(BasCrnp::getCrnNo).collect(Collectors.toList()); + Integer crnNo = crnNoList.get(0); + + int workNo = commonService.getWorkNo(5); + Date now = new Date(); + // 鐢熸垚宸ヤ綔妗� + WrkMast wrkMast = new WrkMast(); + wrkMast.setWrkNo(workNo); + wrkMast.setIoTime(new Date()); + wrkMast.setWrkSts(1L); // + wrkMast.setIoType(3); // 绔欏埌绔� + wrkMast.setIoPri(14D); // 浼樺厛绾� + wrkMast.setCrnNo(crnNo); + wrkMast.setSourceStaNo(secondFloorIn[crnNo]); + wrkMast.setStaNo(secondFloorOut[crnNo]); + wrkMast.setLocNo(""); + wrkMast.setBarcode(param.getBarcode()); // 鎵樼洏鐮� + wrkMast.setFullPlt("N"); // 婊℃澘锛歒 + wrkMast.setPicking("N"); // 鎷f枡 + wrkMast.setExitMk("N"); // 閫�鍑� + wrkMast.setEmptyMk("Y"); // 绌烘澘 + wrkMast.setLinkMis("Y"); + wrkMast.setCtnType(1); // 瀹瑰櫒绫诲瀷 + // 鎿嶄綔浜哄憳鏁版嵁 + wrkMast.setAppeTime(now); + wrkMast.setModiTime(now); + boolean res = wrkMastService.insert(wrkMast); + if (!res) { + throw new CoolException("淇濆瓨宸ヤ綔妗eけ璐�"); + } + // 杩斿洖GWCS鐩爣淇℃伅 + pushStaNoToGwcs(param.getPalletizingNo(),wrkMast.getSourceStaNo(),workNo,param.getBarcode(),"浜屾ゼ绌烘墭鍥炴祦鎺ㄩ�乬wcs"); + + return R.ok("绌烘墭鍥炴祦璇锋眰鎴愬姛"); + } + + @Override + public R tb(TbParam param) { + List<WrkDetl> wrkDetls = wrkDetlService.selectList(new EntityWrapper<WrkDetl>().eq("barcode", param.getBarcode())); + if (wrkDetls.isEmpty()) { + return R.parse("鏃犵墿鏂欐槑缁嗕俊鎭�"); + } + List<String> collect = wrkDetls.stream().map(WrkDetl::getUnit).distinct().collect(Collectors.toList()); + return R.ok(collect); + } + + @Override + public R dd(TbParam param) { + List<WrkDetl> wrkDetls = wrkDetlService.selectList(new EntityWrapper<WrkDetl>().eq("barcode", param.getBarcode())); + if (wrkDetls.isEmpty()) { + return R.parse("鏃犵墿鏂欐槑缁嗕俊鎭�"); + } + List<DdParam> collect = wrkDetls.stream().map(wrkDetl -> { + DdParam ddParam = new DdParam(); + ddParam.setBoxPos(wrkDetl.getOrigin()); + ddParam.setBoxType(wrkDetl.getColor()); + return ddParam; + }).distinct().collect(Collectors.toList()); + + return R.ok(collect); + } + + @Override + @Transactional + public R gwmsGenerateInventory(GwmsGenerateInventoryDto param) { + + if (Cools.isEmpty(param)) { + throw new CoolException("璇锋眰鍙傛暟鏈夎锛�" + param); + } + if (!Cools.isEmpty(param.getBarcode())) { + int zpalletCount = locDetlService.selectCount(new EntityWrapper<LocDetl>().eq("zpallet", param.getBarcode())); + if (zpalletCount > 0) { + throw new CoolException("搴撳瓨鎵樼洏鐮佸凡瀛樺湪锛�" + param.getBarcode()); + } + + int barcodeCount = wrkMastService.selectCount(new EntityWrapper<WrkMast>().eq("barcode", param.getBarcode())); + if (barcodeCount > 0) { + throw new CoolException("宸ヤ綔妗e凡瀛樺湪璇ユ墭鐩樼爜锛�" + param.getBarcode()); + } + } + LocTypeDto locTypeDto = new LocTypeDto(); + locTypeDto.setLocType1((short)1); + int iotype = 1; + if (Cools.isEmpty(param.getMatList())) { + iotype = 10; + } + // 鏍规嵁婧愮珯鐐瑰鎵惧簱浣� +// StartupDto dto = commonService.getLocNo(1, 1, param.getPalletizingNo(), null,null,null, locTypeDto); + StartupDto dto = commonService.getLocNo(iotype, param.getPalletizingNo(), locTypeDto,0); + + int workNo = dto.getWorkNo(); + Date now = new Date(); + // 鐢熸垚宸ヤ綔妗� + WrkMast wrkMast = new WrkMast(); + wrkMast.setWrkNo(workNo); + wrkMast.setWhsType(iotype == 1 && param.getPalletizingNo() == 2051 ? 1 : 0); // 杩斾慨鍏ュ簱鏍囪 + wrkMast.setIoTime(new Date()); + wrkMast.setWrkSts(1L); // 宸ヤ綔鐘舵�侊細璁惧涓婅蛋 + wrkMast.setIoType(iotype); // 鍏ュ嚭搴撶姸鎬侊細1.鍏ュ簱 + wrkMast.setIoPri(13D); // 浼樺厛绾� + wrkMast.setCrnNo(dto.getCrnNo()); + wrkMast.setSourceStaNo(param.getPalletizingNo()); + wrkMast.setStaNo(dto.getStaNo()); + wrkMast.setLocNo(dto.getLocNo()); + wrkMast.setBarcode(param.getBarcode()); // 鎵樼洏鐮� + wrkMast.setFullPlt("Y"); // 婊℃澘锛歒 + wrkMast.setPicking("N"); // 鎷f枡 + wrkMast.setExitMk("N"); // 閫�鍑� + wrkMast.setEmptyMk("N"); // 绌烘澘 + wrkMast.setLinkMis("Y"); + wrkMast.setCtnType(1); // 瀹瑰櫒绫诲瀷 + // 鎿嶄綔浜哄憳鏁版嵁 + wrkMast.setAppeTime(now); + wrkMast.setModiTime(now); + boolean res = wrkMastService.insert(wrkMast); + if (!res) { + throw new CoolException("淇濆瓨宸ヤ綔妗eけ璐�"); + } + + if (!Cools.isEmpty(param.getMatList())) { + List<GwmsGenerateInventoryDto.MatList> matList = param.getMatList(); + for (GwmsGenerateInventoryDto.MatList obj :matList) { + WrkDetl wrkDetl = new WrkDetl(); + wrkDetl.setWrkNo(wrkMast.getWrkNo()); + obj.getRolls().forEach(roll -> { + wrkDetl.setWrkNo(wrkMast.getWrkNo()); + wrkDetl.setMatnr(roll.getSpecs()); // 瑙勬牸 + wrkDetl.setMaktx(roll.getSpecs()); //瑙勬牸 + wrkDetl.setUnit(roll.getBoxNo()); // 绠卞彿 + wrkDetl.setModel(roll.getRollNo()); // 鍗峰彿 + wrkDetl.setBrand(obj.getPackageGroupNo()); // 鍖呰缁勫彿 + wrkDetl.setZpallet(param.getBarcode()); // 鎵樼洏鐮� + wrkDetl.setBarcode(param.getBarcode()); + wrkDetl.setOrigin(obj.getBoxPos()); // 鏈ㄧ鍦ㄦ墭鐩樹綅缃� + wrkDetl.setColor(obj.getBoxType()); // 鏈ㄧ绫诲瀷 + wrkDetl.setManu(obj.getRollType()); // 绠¤姱绫诲瀷 + wrkDetl.setSku(obj.getWideInWidth()); // 瀹炴祴瀹藉箙 + wrkDetl.setItemNum(obj.getThickness()); // 鐢熺當鍘氬害 + wrkDetl.setManuDate(roll.getFqTime()); // 鍒嗗垏涓嬫枡鏃堕棿 + wrkDetl.setWeight(roll.getNetWeight()); // 鍑�閲� + wrkDetl.setVolume(roll.getGrossWeight()); // 姣涢噸 + wrkDetl.setLength(roll.getLength()); // 闀垮害 + wrkDetl.setSpecs(String.valueOf(roll.getSplices())); // 鎺ュご + wrkDetl.setAnfme(1.0); +// wrkDetl.setThreeCode(null); // 閫氳繃mes鎴杄xcel瀵煎叆妫�娴嬫槸鍚﹀悎鏍� 0涓嶅悎鏍硷紝1 鍚堟牸 +// wrkDetl.setDeadWarn(); // 鐞嗚揣鏍囪瘑 0榛樿锛�1鐞嗚揣涓紝2鐞嗚揣瀹屾垚w +// wrkDetl.setInspect(); // 璁㈠崟鏄庣粏涓敤锛屾爣璇嗗璐х殑鐘舵�� 0鏈璐э紝1澶囪揣涓紝2澶囪揣瀹屾垚 +// wrkDetl.setDanger(); // 璁㈠崟鏄庣粏涓敤锛屾爣璇嗚法宸烽亾绉诲簱 0鏈Щ搴擄紝1绉诲簱涓紝2绉诲簱瀹屾垚 + wrkDetl.setIoTime(now); + wrkDetl.setAppeTime(now); + wrkDetl.setAppeUser(21L); // root + wrkDetl.setModiUser(21L); // root + wrkDetl.setModiTime(now); + if (!wrkDetlService.insert(wrkDetl)) { + throw new CoolException("淇濆瓨宸ヤ綔鏄庣粏澶辫触"); + } + + // 鐗╂枡琛ㄥ浠戒竴浠� +// Mat mat = new Mat(); +// mat.sync(wrkDetl); +// mat.setTagId(6L); +// mat.setCreateTime(now); +// mat.setUpdateTime(now); +// if (!matService.insert(mat)) { +// throw new CoolException("澶囦唤鐗╂枡琛ㄥけ璐�"); +// } + + }); + } + } + + + // 鏇存柊鐩爣搴撲綅鐘舵�� + LocMast locMast = locMastService.selectById(dto.getLocNo()); + if (locMast.getLocSts().equals("O")){ + locMast.setLocSts("S"); // S.鍏ュ簱棰勭害 + locMast.setModiTime(now); + if (!locMastService.updateById(locMast)){ + throw new CoolException("鏀瑰彉搴撲綅鐘舵�佸け璐�"); + } + } else { + throw new CoolException(dto.getLocNo()+"鐩爣搴撲綅宸茶鍗犵敤"); + } + + // 杩斿洖GWCS鐩爣淇℃伅 + pushStaNoToGwcs(param.getPalletizingNo(),dto.getStaNo(),dto.getWorkNo(),param.getBarcode(),"gwms鐢宠鍏ュ簱鍚庢帹閫乬wcs"); + + return null; + } + + @Override + @Transactional + public String crnExecute(CrnExecuteParam param) { + if (Cools.isEmpty(param.getStaNo(),param.getWorkNo())){ + throw new CoolException("鍙傛暟涓嶈兘涓虹┖锛�" + param); + } + + WrkMast wrkMast = wrkMastService.selectOne(new EntityWrapper<WrkMast>().eq("wrk_no", param.getWorkNo())); + if (wrkMast == null) { + throw new CoolException("涓嶅瓨鍦ㄨ宸ヤ綔鍙凤細" + param.getWorkNo()); + } + + wrkMast.setWrkSts(2L); + if(wrkMast.getIoType() == 10){ + wrkMast.setBarcode(param.getBarcode()); + } else if(wrkMast.getIoType() == 12) { // 璺ㄥ贩閬撹浆绉诲叆搴� + + } else if(wrkMast.getSourceStaNo() == 3046 || wrkMast.getSourceStaNo() == 3042) { + wrkMast.setBarcode(param.getBarcode()); + } + wrkMastService.updateById(wrkMast); + + return "璇锋眰鎴愬姛"; + } + + @Override + @Transactional + public R zwmsOutLocWork(ZwmsOutLocWorkDto param) { + + Order order = orderService.selectByNo(param.getOrderNo()); + if (!Cools.isEmpty(order)) { + throw new CoolException(param.getOrderNo() + "鍗曟嵁宸插瓨鍦紝璇峰嬁閲嶅鎻愪氦"); + } + + DocType docType = docTypeService.selectOrAdd(param.getOrderType(), Boolean.FALSE); + if (docType == null) { + return R.parse("鍗曟嵁绫诲瀷涓嶅瓨鍦紝璇锋鏌ワ細" + param.getOrderType()); + } + Date now = new Date(); + + // 鍗曟嵁涓绘。 + order = new Order( + String.valueOf(snowflakeIdWorker.nextId()), // 缂栧彿[闈炵┖] + param.getOrderNo(), // 璁㈠崟缂栧彿 + DateUtils.convert(now), // 鍗曟嵁鏃ユ湡 + docType.getDocId(), // 鍗曟嵁绫诲瀷 + null, // 椤圭洰缂栧彿 + null, // + null, // 璋冩嫧椤圭洰缂栧彿 + null, // 鍒濆绁ㄦ嵁鍙� + null, // 绁ㄦ嵁鍙� + null, // 瀹㈡埛缂栧彿 + param.getCustomerName(), // 瀹㈡埛 + null, // 鑱旂郴鏂瑰紡 + null, // 鎿嶄綔浜哄憳 + null, // 鍚堣閲戦 + null, // 浼樻儬鐜� + null, // 浼樻儬閲戦 + null, // 閿�鍞垨閲囪喘璐圭敤鍚堣 + null, // 瀹炰粯閲戦 + null, // 浠樻绫诲瀷 + null, // 涓氬姟鍛� + null, // 缁撶畻澶╂暟 + null, // 閭垂鏀粯绫诲瀷 + null, // 閭垂 + null, // 浠樻鏃堕棿 + null, // 鍙戣揣鏃堕棿 + null, // 鐗╂祦鍚嶇О + null, // 鐗╂祦鍗曞彿 + 1L, // 璁㈠崟鐘舵�� + 1, // 鐘舵�� + 9527L, // 娣诲姞浜哄憳 + now, // 娣诲姞鏃堕棿 + 9527L, // 淇敼浜哄憳 + now, // 淇敼鏃堕棿 + param.getMemo() // 澶囨敞 + ); + + if (!orderService.insert(order)) { + throw new CoolException("鐢熸垚鍗曟嵁涓绘。澶辫触锛岃鑱旂郴绠$悊鍛�"); + } + + // 鍗曟嵁鏄庣粏妗� + for (String groupNo : param.getGroups()) { + OrderDetl orderDetl = new OrderDetl(); + orderDetl.setBrand(groupNo); + orderDetl.setBatch(""); + orderDetl.setOrderId(order.getId()); + orderDetl.setOrderNo(order.getOrderNo()); + orderDetl.setCreateBy(9527L); + orderDetl.setCreateTime(now); + orderDetl.setUpdateBy(9527L); + orderDetl.setUpdateTime(now); + orderDetl.setStatus(1); + orderDetl.setQty(0.0D); + orderDetl.setAnfme(1.0); + if (!orderDetlService.insert(orderDetl)) { + throw new CoolException("鐢熸垚鍗曟嵁鏄庣粏澶辫触锛岃鑱旂郴绠$悊鍛�"); + } + } + + return R.ok("鍗曟嵁鐢熸垚鎴愬姛"); + + } + + @Override + public R queryInLocTime(List<String> param) { + if (Cools.isEmpty(param)) { + return R.parse("鍙傛暟涓嶈兘涓虹┖"); + } + + List<InLocTimeDto> inLocTimeDtos = locDetlMapper.queryInLocTime(param); + + return R.ok(inLocTimeDtos); + } + + @Override + @Transactional + public String outLocResultReport(GhjtApiParam param) { + + if (Cools.isEmpty(param.getOutLocResult(),param.getWorkNo())) { + throw new CoolException("鍏ュ弬涓嶈兘涓虹┖锛�" + param); + } + + WrkMast wrkMast = wrkMastService.selectOne(new EntityWrapper<WrkMast>().eq("wrk_no", param.getWorkNo())); + if (wrkMast == null) { + throw new CoolException("璇ュ伐浣滄。涓嶅瓨鍦紝浠诲姟鍙凤細" + param.getWorkNo()); + } else if(wrkMast.getWrkSts() != 2) { + throw new CoolException("宸ヤ綔妗e綋鍓嶇姸鎬佷笉绗﹀悎锛屼换鍔″彿锛�" + param.getWorkNo() + "锛屽伐浣滄。鐘舵�侊細" + wrkMast.getWrkSts()); + } + + List<WrkDetl> wrkDetls = wrkDetlService.selectList(new EntityWrapper<WrkDetl>().eq("wrk_no", param.getWorkNo())); + + // 鏄惁闇�瑕佸鏍�(鍑哄簱鍗曢渶澶嶆牳) + boolean flag = false; + if (!wrkDetls.isEmpty()) { + flag = wrkDetls.stream().anyMatch(wrkDetl -> wrkDetl.getOrderNo() != null); + } + + // 鍒拌揪鍑哄簱鍙g‘璁や负1锛屾洿鏂板伐浣滄。鐘舵�佷负57.鍑哄簱瀹屾垚 + if (param.getOutLocResult() == 1) { +// wrkMast.setWrkSts(20L); +// // 绌烘墭鐩樺埌浣嶇洿鎺ユ洿鏂板伐浣滄。鐘舵�佷负14.宸插嚭搴撴湭纭锛岀┖鎵樻棤闇�澶嶆牳纭 +// if (!flag || wrkMast.getIoType() == 110) { + wrkMast.setWrkSts(14L); +// } + wrkMastService.updateById(wrkMast); + } + + // 鍑哄簱涓婃姤鎺ㄩ�乵es璁板綍 + ckjgsbPushMes(wrkMast,wrkDetls); + + return "鍑哄簱缁撴灉涓婃姤鎴愬姛"; + } + + private void ckjgsbPushMes(WrkMast wrkMast, List<WrkDetl> wrkDetls) { + GwmsGenerateInventoryDto gwmsGenerateInventoryDto = new GwmsGenerateInventoryDto(); + gwmsGenerateInventoryDto.setBarcode(wrkMast.getBarcode()); + gwmsGenerateInventoryDto.setPalletizingNo(wrkMast.getStaNo()); + List<GwmsGenerateInventoryDto.MatList> matLists = new ArrayList<>(); + for (WrkDetl wrkDetl:wrkDetls) { + boolean flag = true; + for (GwmsGenerateInventoryDto.MatList matList : matLists) { + if (matList.getPackageGroupNo().equals(wrkDetl.getBrand())) { + matList.getRolls().add(new GwmsGenerateInventoryDto.Rolls(wrkDetl.getModel(), + wrkDetl.getUnit(),wrkDetl.getMaktx(),wrkDetl.getLength(), + Integer.parseInt(wrkDetl.getSpecs()),wrkDetl.getWeight(),wrkDetl.getVolume(), + wrkDetl.getManuDate())); + flag = false; + break; + } + } + if (flag) { + GwmsGenerateInventoryDto.MatList matList = new GwmsGenerateInventoryDto.MatList(); + matList.setBoxPos(wrkDetl.getOrigin()); + matList.setPackageGroupNo(wrkDetl.getBrand()); + matList.setOutOrIn("out"); + matList.setStockType(wrkMast.getStaNo() == 2041 ? "杩斾慨鍑哄簱" : "鎴愬搧鍑哄簱"); + matList.setBoxType(wrkDetl.getColor()); + matList.setRollType(wrkDetl.getManu()); + matList.setWideInWidth(wrkDetl.getSku()); + matList.setThickness(wrkDetl.getItemNum()); + List<GwmsGenerateInventoryDto.Rolls> rollsList = new ArrayList<>(); + GwmsGenerateInventoryDto.Rolls roll = new GwmsGenerateInventoryDto.Rolls(wrkDetl.getModel(), + wrkDetl.getUnit(),wrkDetl.getMaktx(),wrkDetl.getLength(), + Integer.parseInt(wrkDetl.getSpecs()),wrkDetl.getWeight(),wrkDetl.getVolume(), + wrkDetl.getManuDate()); + rollsList.add(roll); + matList.setRolls(rollsList); + matLists.add(matList); + } + } + gwmsGenerateInventoryDto.setMatList(matLists); + + + + boolean success = false; + // 鑾峰彇璇锋眰澶� + Map<String,Object> headers = new HashMap<>(); + headers.put("Content-Type","application/json;charset=UTF-8"); + + // 鏋勯�犺姹備綋 + String body = JSON.toJSONString(gwmsGenerateInventoryDto); + String response = ""; + try { + response = new HttpHandler.Builder() + .setUri(MesConstant.MES_CC_IP_PORT) + .setPath(MesConstant.MES_CC_FXRK_URL) + .setHeaders(headers) + .setJson(body) + .build() + .doPost(); + if (!Cools.isEmpty(response)) { + JSONObject jsonObject1 = JSONObject.parseObject(response); + int code = (int) jsonObject1.get("code"); + boolean state = jsonObject1.getBoolean("state"); + if (code == 200 && state) { + success = true; + } + } else { + log.error("鍑哄簱涓婃姤鎺ㄩ�乵es璁板綍澶辫触锛侊紒锛乽rl锛歿}锛況equest锛歿}锛況esponse锛歿}", MesConstant.MES_CC_IP_PORT + MesConstant.MES_CC_FXRK_URL, body, response); + } + } catch (Exception e) { + log.error("鍑哄簱涓婃姤鎺ㄩ�乵es璁板綍寮傚父锛歿}", e.getMessage()); + } finally { + try { + // 淇濆瓨鎺ュ彛鏃ュ織 + apiLogService.save( + "鍑哄簱涓婃姤鎺ㄩ�乵es璁板綍", + MesConstant.MES_CC_IP_PORT + MesConstant.MES_CC_FXRK_URL, + null, + "127.0.0.1", + body, + response, + success + ); + } catch (Exception e) { + log.error("", e); + } + } + } + + @Autowired + private BasCrnpService basCrnpService; + + @Override + @Transactional + public String emptyOutLoc(GhjtApiParam param) { +// 3102/3009/3008/3006/3003/3002鈫�3047/3112 + // 鑾峰彇妯″紡涓虹數鑴戞ā寮忥紝鏃犱换鍔$殑鍫嗗灈鏈哄垪琛�:闃叉鍒嗛厤鍒板爢鍨涙満涓嶅彲鐢� + List<BasCrnp> basCrnps = basCrnpService.selectList(new EntityWrapper<BasCrnp>().eq("crn_sts",3) + .eq("wrk_no",0)); + if (basCrnps.isEmpty()) { + // 閮芥湁浠诲姟鍒欒幏鍙栫數鑴戞ā寮忕殑鍫嗗灈鏈哄垪琛� + basCrnps = basCrnpService.selectList(new EntityWrapper<BasCrnp>().eq("crn_sts",3)); + } + if (basCrnps.isEmpty()) { + throw new CoolException("娌℃湁鍙敤鍫嗗灈鏈�,鍫嗗灈鏈哄仠姝㈡垨寮傚父"); + } + // 鍙敤鍫嗗灈鏈哄垪琛� + List<Integer> crnNoList = basCrnps.stream().map(BasCrnp::getCrnNo).collect(Collectors.toList()); + // 瀵绘壘绌烘墭鐩樺簱浣嶏紝鍏堟壘娴呭簱浣� + List<LocMast> locMasts; + locMasts = locMastService.selectList(new EntityWrapper<LocMast>().eq("loc_sts","D") + .orderAsc(Arrays.asList("row1","lev1","bay1")).in("crn_no",crnNoList).in("row1",3,4,6,7,10,11,14,15,18,19,22,23)); + if (locMasts.isEmpty()) { + locMasts = locMastService.selectList(new EntityWrapper<LocMast>().eq("loc_sts","D") + .orderAsc(Arrays.asList("row1","lev1","bay1")).in("crn_no",crnNoList).in("row1",1,4,5,8,9,12,13,16,17,20,21,24)); + } + + if (locMasts.isEmpty()) { + throw new CoolException("娌℃湁鎵惧埌绌烘墭鐩橈紝绔欑偣锛�" + param.getStaNo()); + } + + // 鍙栫涓�涓┖搴撲綅 + LocMast locMast = locMasts.get(0); + + // 鑾峰彇宸ヤ綔璺緞 + StaDesc staDesc = staDescService.selectOne(new EntityWrapper<StaDesc>().eq("type_no", 110).eq("stn_no", + param.getStaNo()).eq("crn_no", locMast.getCrnNo())); + + if (staDesc == null) { + throw new CoolException("璺緞涓嶅瓨鍦�"); + } + + //2.鐢熸垚绌烘墭鐩樺嚭搴撳伐浣滄。 + Date now = new Date(); + WrkMast wrkMast = new WrkMast(); + wrkMast.setWrkNo(commonService.getWorkNo(WorkNoType.PAKOUT.type)); + wrkMast.setIoTime(now); + wrkMast.setWrkSts(11L); // 宸ヤ綔鐘舵�侊細11.鐢熸垚鍑哄簱ID + wrkMast.setIoType(110); // 鍏ュ嚭搴撶姸鎬侊細 110.绌烘澘鍑哄簱 + wrkMast.setIoPri(10D); + wrkMast.setSourceStaNo(staDesc.getCrnStn()); // 婧愮珯 + wrkMast.setStaNo(staDesc.getStnNo()); // 鐩爣绔� + wrkMast.setCrnNo(locMast.getCrnNo()); + wrkMast.setSourceLocNo(locMast.getLocNo()); // 婧愬簱浣� + wrkMast.setBarcode(locMast.getBarcode()); + wrkMast.setFullPlt("N"); // 婊℃澘锛歒 + wrkMast.setPicking("N"); // 鎷f枡 + wrkMast.setExitMk("N"); // 閫�鍑� + wrkMast.setEmptyMk("Y"); // 绌烘澘 + wrkMast.setLinkMis("N"); + wrkMast.setAppeUser(9999L); + wrkMast.setAppeTime(now); + wrkMast.setModiUser(9999L); + wrkMast.setModiTime(now); + if (!wrkMastService.insert(wrkMast)) { + throw new CoolException("淇濆瓨宸ヤ綔妗eけ璐�"); + } + + // 3.鏇存柊搴撲綅鐘舵�� D.绌烘澘 -> R.鍑哄簱棰勭害 + if (locMast.getLocSts().equals("D")) { + locMast.setLocSts("R"); + locMast.setModiUser(9999L); + locMast.setModiTime(now); + if (!locMastService.updateById(locMast)) { + throw new CoolException("鏇存柊搴撲綅鐘舵�佸け璐�"); + } + } + + return "鍑哄簱鎴愬姛"; + } + + @Override + @Transactional + public R zphjDw(ZphjckdwParam param) { + // 鏍规嵁浠诲姟鍙峰緱鍒板伐浣滀富妗� + if (Cools.isEmpty(param.getWorkNo())) { + throw new CoolException("宸ヤ綔鍙蜂笉鑳戒负绌猴紒"); + } + WrkMast wrkMast = wrkMastService.selectById(param.getWorkNo()); + if (wrkMast == null) { + throw new CoolException("宸ヤ綔妗d笉瀛樺湪锛�"); + } + if (wrkMast.getWrkSts() != 2 || wrkMast.getIoType() != 103 && wrkMast.getIoType() != 109) { + throw new CoolException("宸ヤ綔妗e綋鍓嶇姸鎬佷笉涓�2/鍑哄簱绫诲瀷涓嶄负鎷f枡锛�"); + } + // 鏇存柊宸ヤ綔妗g姸鎬�2.璁惧涓婅蛋->42.绛夊緟鐮佸灈 + wrkMast.setWrkSts(42L); + wrkMastService.updateById(wrkMast); + + // 鏌ヨ瑕佹媶鐨勪綅缃紝鍙湁涓�涓� + List<WrkDetl> wrkDetls = wrkDetlService.selectList(new EntityWrapper<WrkDetl>().eq("wrk_no", wrkMast.getWrkNo())); + WrkDetl wrkDetl = wrkDetls.get(0); + + // 杩斿洖鎷嗗灈瑙勫垯 + ZphjcdgzVo zphjcdgzVo = new ZphjcdgzVo(); + zphjcdgzVo.setWorkNo(wrkDetl.getWrkNo()); + zphjcdgzVo.setBoxType(wrkDetl.getColor()); + zphjcdgzVo.setPosition(wrkDetl.getOrigin()); + zphjcdgzVo.setCdType(wrkMast.getIoType() == 103 ? 1 : 2); + + return R.ok(zphjcdgzVo); + } + + @Override + @Transactional + public R zphjCdwc(ZphjcdwcParam param) { + + if (Cools.isEmpty(param.getWorkNo(),param.getSourceStaNo(),param.getSite(),param.getBarcode())) { + return R.parse("鍙傛暟涓嶈兘涓虹┖锛岃妫�鏌ュ叆鍙�"); + } + WrkMast wrkMast = wrkMastService.selectById(param.getWorkNo()); + if (wrkMast == null) { + throw new CoolException("宸ヤ綔妗d笉瀛樺湪锛�"); + } + if (wrkMast.getWrkSts() != 42 || wrkMast.getIoType() != 103) { + throw new CoolException("宸ヤ綔妗e綋鍓嶇姸鎬佷笉涓�42/鍑哄簱绫诲瀷涓嶄负鎷f枡锛�"); + } + + // 鑾峰彇鍑哄簱鐗╂枡 + List<WrkDetl> wrkDetls = wrkDetlService.selectList(new EntityWrapper<WrkDetl>().eq("wrk_no", wrkMast.getWrkNo())); + + // 婧愬簱浣� + LocMast locMast = locMastService.selectById(wrkMast.getSourceLocNo()); + + // 鍒涘缓妗佹灦鐞嗚揣鍑哄簱鐨勫伐浣滄。 + int work = create111Work(wrkMast, wrkDetls, param.getSite(), wrkMast.getStaNo(), param.getBarcode()); + + int descFlag = getType(wrkDetls); + + // 淇濆瓨宸ヤ綔涓绘。鍘嗗彶妗� + if (!wrkMastLogService.save(wrkMast.getWrkNo())) { + throw new CoolException("淇濆瓨宸ヤ綔涓绘。鍘嗗彶妗eけ璐�"); + } + + // 鑾峰彇澶囪揣鍖洪厤缃� + Config config = configMapper.selectConfigByCode("auto_stock_up"); + if (config == null) { + throw new CoolException("鐞嗚揣鑾峰彇澶囪揣鍖洪厤缃敊璇紒锛侊紒"); + } + // 鍓嶅嚑鍒楁槸澶囪揣鍖� + int columnNum = Integer.parseInt(config.getValue()); + + // get0鍘熸墭鐩樺洖娴佷俊鎭紝get1鎷嗗灈鍑烘潵鐗╂枡鍑哄簱淇℃伅 + List<ZphjcdwcVo> zphjcdwcVos = new ArrayList<>(); + + ZphjcdwcVo zphjcdwcVo2 = new ZphjcdwcVo(); + zphjcdwcVo2.setWorkNo(work); + zphjcdwcVo2.setSourceStaNo(param.getSite()); + zphjcdwcVo2.setStaNo(wrkMast.getStaNo()); + zphjcdwcVo2.setBarcode(param.getBarcode()); + zphjcdwcVo2.setDescFlag(descFlag); + zphjcdwcVos.add(zphjcdwcVo2); + + // 濡傛灉浠庡璐у尯鏉ョ殑锛屽垯涓嶈兘鍥炲師搴撲綅 + if (locMast.getBay1() <= columnNum) { + + // 瀵绘壘涓�涓柊搴撲綅 + LocTypeDto locTypeDto = new LocTypeDto(); + locTypeDto.setLocType1((short) 1); + StartupDto dto = commonService.getLocNo(53, param.getSourceStaNo(), locTypeDto, 0); + // 鏂板簱浣� + LocMast staLocMast = locMastService.selectById(dto.getLocNo()); + + // 鏇存柊鏃у簱浣嶇姸鎬� O + locMast.setLocSts("O"); + locMast.setBarcode(""); + locMast.setModiTime(new Date()); + locMastService.updateById(locMast); + + // 鎶婃棫搴撲綅鏄庣粏杞埌鏂板簱浣� + locDetlService.updateLocNo(staLocMast.getLocNo(), wrkMast.getSourceLocNo()); + + // 鏇存柊鏂板簱浣嶇姸鎬� Q + staLocMast.setLocSts("Q"); + staLocMast.setBarcode(wrkMast.getBarcode()); + staLocMast.setModiTime(new Date()); + locMastService.updateById(staLocMast); + + // 鏇存柊宸ヤ綔宸ヤ綔涓绘。 + wrkMast.setIoType(53); + wrkMast.setWrkSts(52L); // 宸ヤ綔鐘舵��42->52.璁惧涓婅蛋锛堟媶鍨涘畬鎴愶級 + // 鐩爣绔欑偣婧愮珯鐐硅浆鎹� + wrkMast.setStaNo(dto.getStaNo()); + wrkMast.setSourceStaNo(dto.getSourceStaNo()); + wrkMast.setCrnNo(dto.getCrnNo()); + // 鐩爣搴撲綅=婧愬簱浣� + wrkMast.setLocNo(dto.getLocNo()); + // 婧愬簱浣嶆竻闄� + wrkMast.setSourceLocNo(""); + wrkMast.setModiTime(new Date()); + + } else { + // 鏇存柊宸ヤ綔宸ヤ綔涓绘。 + wrkMast.setIoType(53); + wrkMast.setWrkSts(52L); // 宸ヤ綔鐘舵��42->52.璁惧涓婅蛋锛堟媶鍨涘畬鎴愶級 + wrkMast.setSourceStaNo(param.getSourceStaNo()); + wrkMast.setStaNo(oneFloorIn[wrkMast.getCrnNo()]); + // 婧愬簱浣� + LocMast staLocMast = locMastService.selectById(wrkMast.getSourceLocNo()); + // 鐩爣搴撲綅=婧愬簱浣� + wrkMast.setLocNo(wrkMast.getSourceLocNo()); + // 婧愬簱浣嶆竻闄� + wrkMast.setSourceLocNo(""); + wrkMast.setModiTime(new Date()); + + // 鏇存柊鏂板簱浣嶇姸鎬� Q + staLocMast.setLocSts("Q"); + staLocMast.setModiTime(new Date()); + locMastService.updateById(staLocMast); + } + + // 鏇存柊宸ヤ綔涓绘。 + wrkMastService.updateById(wrkMast); + + // 鍥炲簱 + ZphjcdwcVo zphjcdwcVo1 = new ZphjcdwcVo(); + zphjcdwcVo1.setWorkNo(wrkMast.getWrkNo()); + zphjcdwcVo1.setStaNo(wrkMast.getStaNo()); + zphjcdwcVo1.setSourceStaNo(wrkMast.getSourceStaNo()); + zphjcdwcVo1.setBarcode(wrkMast.getBarcode()); + zphjcdwcVos.add(0,zphjcdwcVo1); + + // 涓嬪彂鍥炲簱鐨勭洰鏍囩珯鐐瑰拰鎷嗗灈鐨勫嚭搴撶洰鏍囩珯鐐圭粰gwcs + return R.ok(zphjcdwcVos); + } + + @Override + public R kxlhCdwc(KxlhcdwcParam param) { + + if (Cools.isEmpty(param.getWorkNo(),param.getSourceStaNo(),param.getSite(),param.getBarcode())) { + return R.parse("鍙傛暟涓嶈兘涓虹┖锛岃妫�鏌ュ叆鍙�"); + } + WrkMast wrkMast = wrkMastService.selectById(param.getWorkNo()); + if (wrkMast == null) { + throw new CoolException("宸ヤ綔妗d笉瀛樺湪锛�"); + } + if (wrkMast.getWrkSts() != 42 || wrkMast.getIoType() != 109) { + throw new CoolException("宸ヤ綔妗e綋鍓嶇姸鎬佷笉涓�42/鍑哄簱绫诲瀷涓嶄负绌洪棽鐞嗚揣锛�"); + } + + Date now = new Date(); + + // 鑾峰彇鍑哄簱鐗╂枡 + List<WrkDetl> wrkDetls = wrkDetlService.selectList(new EntityWrapper<WrkDetl>().eq("wrk_no", wrkMast.getWrkNo())); + + // 鑾峰彇搴撳瓨鐗╂枡 + List<LocDetl> locDetls = locDetlMapper.selectList(new EntityWrapper<LocDetl>().eq("loc_no", wrkMast.getSourceLocNo())); + + // 婧愬簱浣� + LocMast locMast = locMastService.selectById(wrkMast.getSourceLocNo()); + + List<ZphjcdwcVo> zphjcdwcVos = new ArrayList<>(); + + if (wrkDetls.size() == locDetls.size()) { // 涓嶉渶瑕佸洖搴擄紝鎷嗗畬鍚庡墿绌烘墭鐩樺幓鍙犵洏鏈� + + // 鍒犻櫎婧愬簱浣嶅簱瀛樻槑缁� + locDetlMapper.delete(new EntityWrapper<LocDetl>().eq("loc_no", wrkMast.getSourceLocNo())); + + // 淇敼婧愬簱浣嶇姸鎬� + if (locMast.getLocSts().equals("R")) { + locMast.setLocSts("O"); + locMast.setBarcode(""); + locMast.setSheetNo("0"); + locMast.setModiTime(now); + locMast.setIoTime(now); + locMastService.updateById(locMast); + } + + // 淇敼宸ヤ綔涓绘。鐘舵�� + wrkMast.setWrkSts(15L); + wrkMast.setModiTime(now); + wrkMastService.updateById(wrkMast); + + // 涓嬪彂鍘诲彔鐩樹綅缃� + ZphjcdwcVo zphjcdwcVo = new ZphjcdwcVo(); + zphjcdwcVo.setWorkNo(wrkMast.getWrkNo()); + zphjcdwcVo.setStaNo(3013); + zphjcdwcVo.setSourceStaNo(param.getSourceStaNo()); + zphjcdwcVo.setBarcode(wrkMast.getBarcode()); + zphjcdwcVos.add(zphjcdwcVo); + + } else { // 鎷嗗畬鍚庤繕鏈夌墿鏂欙紝闇�瑕佸洖搴� + + // 鍏堝垹闄ゅ簱瀛樻槑缁嗭紝閬垮厤杩樻湭鍥炲簱浣嗙粍鐩樼殑鍏堝叆搴撲簡 + for (WrkDetl wrkDetl : wrkDetls) { + locDetlMapper.delete(new EntityWrapper<LocDetl>().eq("brand",wrkDetl.getBrand())); + } + + // 淇敼宸ヤ綔涓绘。 + wrkMast.setWrkSts(52L); + wrkMast.setIoType(59); + wrkMast.setSourceStaNo(wrkMast.getStaNo()); + wrkMast.setStaNo(oneFloorIn[wrkMast.getCrnNo()]); + wrkMast.setLocNo(wrkMast.getSourceLocNo()); + wrkMast.setSourceLocNo(""); + wrkMast.setModiTime(now); + wrkMastService.updateById(wrkMast); + + // 淇敼婧愬簱浣嶇姸鎬� + if (locMast.getLocSts().equals("R")) { + locMast.setLocSts("S"); + locMast.setModiTime(now); + locMastService.updateById(locMast); + } + + // 涓嬪彂鍥炲簱鍛戒护 + ZphjcdwcVo zphjcdwcVo = new ZphjcdwcVo(); + zphjcdwcVo.setWorkNo(wrkMast.getWrkNo()); + zphjcdwcVo.setStaNo(oneFloorIn[wrkMast.getCrnNo()]); + zphjcdwcVo.setSourceStaNo(param.getSourceStaNo()); + zphjcdwcVo.setBarcode(wrkMast.getBarcode()); + zphjcdwcVos.add(zphjcdwcVo); + } + + // 缁勭洏鐐� + Integer site = param.getSite(); + + // 鍒ゆ柇缁勭洏鏄惁瀹屾垚锛氫袱涓埌鎹㈢洏绔欑偣鐨勪换鍔℃槸鍚﹀畬鎴� + Wrapper<WrkMast> wrapper = new EntityWrapper<WrkMast>().eq("io_type", 109).ne("wrk_sts",15); + if (site == 3046) { + wrapper.in("sta_no",3045,3044); + } else { + wrapper.in("sta_no",3041,3040); + } + int count = wrkMastService.selectCount(wrapper); + + // 宸茬粡瀹屾垚鍒欎笅鍙戠粍鐩樼偣鍏ュ簱鍛戒护 + if (count == 0) { + // 鑾峰彇鍒扮粍鐩樼偣鍏ュ簱浠诲姟 + WrkMast wrkMast1 = wrkMastService.selectOne(new EntityWrapper<WrkMast>().eq("wrk_sts", 1).eq("io_type", 1).eq("source_sta_no", site)); + ZphjcdwcVo zphjcdwcVo = new ZphjcdwcVo(); + zphjcdwcVo.setWorkNo(wrkMast1.getWrkNo()); + zphjcdwcVo.setStaNo(wrkMast1.getStaNo()); + zphjcdwcVo.setSourceStaNo(site); + zphjcdwcVo.setBarcode(param.getBarcode()); + zphjcdwcVos.add(zphjcdwcVo); + } + + return R.ok(zphjcdwcVos); + } + + @Override + public R requestXhd(String barcode) { + + // 娌℃湁浠诲姟鎴栬�呬笉鏄洏鐐逛换鍔$殑鎵樼洏缁忚繃鍒欒繑鍥�-1锛屽拷鐣� + WrkMast wrkMast = wrkMastService.selectOne(new EntityWrapper<WrkMast>().eq("barcode", barcode)); + if (wrkMast == null || wrkMast.getIoType() != 107) { + return R.ok(-1); + } + + // 搴撳瓨鏄庣粏鏈ㄧ浣嶇疆闆嗗悎 + List<LocDetl> locDetls = locDetlMapper.selectList(new EntityWrapper<LocDetl>().eq("zpallet", barcode)); + List<String> collect1 = locDetls.stream().map(LocDetl::getOrigin).distinct().collect(Collectors.toList()); + // 宸ヤ綔鏄庣粏鏈ㄧ浣嶇疆闆嗗悎 + List<WrkDetl> wrkDetls = wrkDetlService.selectList(new EntityWrapper<WrkDetl>().eq("zpallet", barcode)); + List<String> collect2 = wrkDetls.stream().map(WrkDetl::getOrigin).distinct().collect(Collectors.toList()); + + // 0鏄庣粏寮傚父,1浜乏锛�2浜彸锛�3閮戒寒 + if (collect1.size() == 0 || collect2.size() == 0){ + return R.ok(0); + } else if((collect1.size() == 1 && collect2.size() == 1) || (collect1.size() == 2 && collect2.size() == 2)) { + return R.ok(3); + } else if(collect1.size() == 2 && collect2.size() == 1) { + return R.ok(collect2.get(0).equals("宸�") ? 1 : 2); + } else { + return R.parse("浜俊鍙风伅鏉$爜寮傚父锛�" + barcode); + } + + } + + @Override + public R getUnfulfilledOrders() { + // 鑾峰彇鏈畬鎴愯鍗曠粺璁′俊鎭� + List<OrderStatisticsDto> unfulfilledOrders = orderMapper.getUnfulfilledOrders(""); + return R.ok(unfulfilledOrders); + } + + @Override + public R getCrnLaneWayInfo() { + List<CrnLaneWayInfoDto> crnLaneWayInfo = basCrnpMapper.getCrnLaneWayInfo(); + return R.ok(crnLaneWayInfo); + } + + @Override + public R getOutLocInfoByBarcode(String barcode) { + + // 鏍规嵁鎵樼洏鐮佽幏鍙栦换鍔′富妗� + WrkMast wrkMast = wrkMastService.selectOne(new EntityWrapper<WrkMast>().eq("barcode", barcode)); + if (wrkMast == null) { + return R.parse("璇ユ潯鐮佹棤姝e湪鎵ц浠诲姟锛�" + barcode); + } + // 鏍规嵁浠诲姟涓绘。鑾峰彇宸ヤ綔妗f槑缁� + List<WrkDetl> wrkDetls = wrkDetlService.selectList(new EntityWrapper<WrkDetl>().eq("wrk_no", wrkMast.getWrkNo())); + // 鎻愬彇鍖呰缁勫彿 + List<String> brandList = wrkDetls.stream().map(WrkDetl::getBrand).distinct().collect(Collectors.toList()); + OutLocInfoDto outLocInfoDto = new OutLocInfoDto(); + outLocInfoDto.setWrkNo(wrkMast.getWrkNo()); + List<OutLocInfoDto.Material> materialList = new ArrayList<>(); + for (String brand : brandList) { + // 涓�涓湪绠� + OutLocInfoDto.Material material = new OutLocInfoDto.Material(); + material.setPackageGroupNo(brand); // 鍖呰缁勫彿 + // 鎸夊寘瑁呯粍鍙疯繃婊� + List<WrkDetl> wrkDetls1 = wrkDetls.stream().filter(wrkDetl -> Objects.equals(wrkDetl.getBrand(), brand)).collect(Collectors.toList()); + // 鍗蜂俊鎭� + List<OutLocInfoDto.Material.MaterialDetail> materialDetailList = new ArrayList<>(); + for (WrkDetl wrkDetl : wrkDetls1) { + OutLocInfoDto.Material.MaterialDetail materialDetail = new OutLocInfoDto.Material.MaterialDetail(); + materialDetail.setRollNo(wrkDetl.getModel()); + materialDetail.setBoxNo(wrkDetl.getUnit()); + materialDetail.setSpecs(wrkDetl.getMatnr()); + material.setBoxPos(wrkDetl.getOrigin()); // 鎵樼洏涓婃湪绠变綅缃� + materialDetailList.add(materialDetail); + } + // 璁㈠崟淇℃伅 + WrkDetl wrkDetl = wrkDetls1.get(0); + if (wrkDetl != null && wrkDetl.getOrderNo() != null) { + Order order = orderService.selectOne(new EntityWrapper<Order>().eq("order_no", wrkDetl.getOrderNo())); + if (order != null) { + material.setOrderNo(order.getOrderNo()); + material.setMemo(order.getMemo()); + material.setCustomerName(order.getCstmrName()); + List<OrderStatisticsDto> unfulfilledOrders = orderMapper.getUnfulfilledOrders(order.getOrderNo()); + if (unfulfilledOrders.size() == 1) { + OrderStatisticsDto orderStatisticsDto = unfulfilledOrders.get(0); + material.setSum(orderStatisticsDto.getSum()); + material.setToShipQuantity(orderStatisticsDto.getToShipQuantity()); + material.setWorkQuantity(orderStatisticsDto.getWorkQuantity()); + } + } + } + + material.setMaterialDetailList(materialDetailList); + materialList.add(material); + } + outLocInfoDto.setMaterialList(materialList); + + return R.ok(outLocInfoDto); + } + + /** + * 鍒涘缓妗佹灦鐞嗚揣鍑哄簱鐨勫伐浣滄。 + */ + private int create111Work(WrkMast wrk, List<WrkDetl> wrkDetls, Integer site, Integer staNo,String barcode) { + int workNo = commonService.getWorkNo(4); + Date now = new Date(); + // 鐢熸垚宸ヤ綔妗� + WrkMast wrkMast = new WrkMast(); + wrkMast.setWrkNo(workNo); + wrkMast.setIoTime(new Date()); + wrkMast.setWrkSts(2L); // 宸ヤ綔鐘舵�侊細璁惧涓婅蛋 + wrkMast.setIoType(111); // 鍏ュ嚭搴撶姸鎬侊細111.鐞嗚揣璐存爣鍑哄簱 + wrkMast.setIoPri(13D); // 浼樺厛绾� + wrkMast.setCrnNo(wrk.getCrnNo()); + wrkMast.setSourceStaNo(site); + wrkMast.setStaNo(staNo); + wrkMast.setSourceLocNo(wrk.getSourceLocNo()); + wrkMast.setBarcode(barcode); // 鎵樼洏鐮� + wrkMast.setFullPlt("Y"); // 婊℃澘锛歒 + wrkMast.setPicking("N"); // 鎷f枡 + wrkMast.setExitMk("N"); // 閫�鍑� + wrkMast.setEmptyMk("N"); // 绌烘澘 + wrkMast.setLinkMis("Y"); + wrkMast.setCtnType(1); // 瀹瑰櫒绫诲瀷 + // 鎿嶄綔浜哄憳鏁版嵁 + wrkMast.setAppeTime(now); + wrkMast.setModiTime(now); + + // 鎻掑叆宸ヤ綔妗� + wrkMastService.insert(wrkMast); + + // 鎻掑叆宸ヤ綔妗f槑缁� + for (WrkDetl wrkDetl:wrkDetls) { + wrkDetl.setWrkNo(workNo); + wrkDetl.setBarcode(barcode); + wrkDetl.setZpallet(barcode); + wrkDetlService.insert(wrkDetl); + } + + return workNo; + } + + /** + * 鏍规嵁鍑哄簱鐗╂枡鏄庣粏鍒ゆ柇鏄惁鍘昏创鏍�(鍗曞嵎璐存爣锛屽鍗蜂笉璐存爣) + * @param wrkDetls 鐗╂枡鏄庣粏 + * @return 1.澶氬嵎鐩存帴鍑鸿矾寰勶紝4.鍗曞嵎璐存爣璺緞 + */ + private int getType(List<WrkDetl> wrkDetls) { + return wrkDetls.size() > 1 ? 1 : 4; // 涓�鏉¤褰曞氨鏄竴鍗� + } + + public boolean pushStaNoToGwcs(Integer palletizingNo, Integer staNo, Integer workNo,String barcode,String message) { + boolean success = false; + // 鑾峰彇璇锋眰澶� + Map<String, Object> headers = getHeaders(); + + // 鏋勯�犺姹備綋 + JSONObject jsonObject = new JSONObject(); + jsonObject.put("workNo", workNo); + jsonObject.put("staNo", staNo); + jsonObject.put("sourceStaNo", palletizingNo); + jsonObject.put("barcode", barcode); + String body = jsonObject.toJSONString(); + String response = ""; + try { + response = new HttpHandler.Builder() + .setUri(MesConstant.GWCS_IP_PORT) + .setPath(MesConstant.GWCS_FPKW_URL) + .setHeaders(headers) + .setJson(body) + .build() + .doPost(); + if (!Cools.isEmpty(response)) { + success = true; + } else { + log.error(message + "澶辫触锛侊紒锛乽rl锛歿}锛況equest锛歿}锛況esponse锛歿}", MesConstant.GWCS_IP_PORT + MesConstant.GWCS_FPKW_URL, body, response); + } + } catch (Exception e) { + log.error(message + "寮傚父锛歿}", e); + } finally { + try { + // 淇濆瓨鎺ュ彛鏃ュ織 + apiLogService.save( + message, + MesConstant.GWCS_IP_PORT + MesConstant.GWCS_FPKW_URL, + null, + "127.0.0.1", + body, + response, + success + ); + } catch (Exception e) { + log.error("", e); + } + } + return success; + } + + Map<String, Object> getHeaders(){ + Map<String,Object> headers = new HashMap<>(); + headers.put("digi-type","sync "); + headers.put("digi-protocol","raw"); + headers.put("digi-datakey"," XCommon.ImportData"); + + return headers; + } + + + private void descSta(Integer staNo,Integer crnNo){ +// int[] typeNos =new int[]{1,10,53,101,103,110}; + int[] typeNos =new int[]{10,110}; + for (Integer typeNo:typeNos){ + descSta3(staNo,crnNo,typeNo); + } + } + + private void descSta3(Integer staNo,Integer crnNo,Integer typeNo){ + StaDesc staDesc = new StaDesc(); + staDesc.setTypeNo(typeNo); + staDesc.setStnNo(staNo); + staDesc.setCrnNo(crnNo); + staDesc.setCrnStn(CrnNoRC(crnNo,staDesc.getTypeNo()>100)); + descSta2(staDesc); + } + + private void descSta2(StaDesc staDesc){ + Date now = new Date(); + //鍏ュ簱 + int sameRes = staDescService.selectCount(new EntityWrapper<StaDesc>() + .eq("type_no", staDesc.getTypeNo()) + .eq("stn_no", staDesc.getStnNo()) + .eq("crn_no", staDesc.getCrnNo()) + .eq("crn_stn", staDesc.getCrnStn())); + if (sameRes == 0) { + staDesc.setModiUser(9527L); + staDesc.setModiTime(now); + staDesc.setAppeUser(9527L); + staDesc.setAppeTime(now); + staDescService.insert(staDesc); + } + } + + private Integer CrnNoRC(Integer crnNo,boolean sign){ + Integer crnStn = 0; + switch (crnNo){ + case 1: + crnStn = 102; + break; + case 2: + crnStn = 105; + break; + case 3: + crnStn = 108; + break; + case 4: + crnStn = 111; + break; + case 5: + crnStn = 114; + break; + case 6: + crnStn = 117; + break; + } + if (sign){ + return crnStn-2; + } + return crnStn; } /*...........................涓婇ザ姹熼摐..............浠ヤ笂.............寰愬伐姹変簯...........................*/ -- Gitblit v1.9.1