From 7096b34d983aaf5c1a863a903a7ebd09a217f687 Mon Sep 17 00:00:00 2001 From: lsh <1> Date: 星期三, 11 十月 2023 13:07:34 +0800 Subject: [PATCH] # --- src/main/java/com/zy/common/service/CommonService.java | 228 ++++++++++++++++++++++++++++++++++++++++++-------------- 1 files changed, 171 insertions(+), 57 deletions(-) diff --git a/src/main/java/com/zy/common/service/CommonService.java b/src/main/java/com/zy/common/service/CommonService.java index 530f2d5..29719cf 100644 --- a/src/main/java/com/zy/common/service/CommonService.java +++ b/src/main/java/com/zy/common/service/CommonService.java @@ -1,22 +1,36 @@ package com.zy.common.service; +import com.alibaba.fastjson.JSON; import com.baomidou.mybatisplus.mapper.EntityWrapper; import com.baomidou.mybatisplus.mapper.Wrapper; +import com.core.common.Arith; import com.core.common.Cools; import com.core.exception.CoolException; import com.zy.asrs.entity.*; +import com.zy.asrs.entity.result.KeyValueVo; import com.zy.asrs.service.*; +import com.zy.asrs.utils.Utils; +import com.zy.asrs.utils.VersionUtils; +import com.zy.common.model.LocTypeDto; +import com.zy.common.model.Shelves; import com.zy.common.model.StartupDto; -import com.zy.common.model.enums.WorkNoType; +import com.zy.common.properties.SlaveProperties; +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.time.LocalDate; +import java.time.format.DateTimeFormatter; +import java.time.temporal.ChronoUnit; +import java.util.ArrayList; import java.util.List; /** * 璐ф灦鏍稿績鍔熻兘 * Created by vincent on 2020/6/11 */ +@Slf4j @Service public class CommonService { @@ -36,10 +50,12 @@ private LocMastService locMastService; @Autowired private LocDetlService locDetlService; + @Autowired + private SlaveProperties slaveProperties; /** * 鐢熸垚宸ヤ綔鍙� - * @param wrkMk 0:鍏ュ簱 1 - 3000 ; 1:鎷f枡/骞舵澘/鐩樼偣 3001 - 6000 ; 2: 鍑哄簱 6001 -9000 ; 3:鍏朵粬 9001 -9999 + * @param wrkMk * @return workNo(宸ヤ綔鍙�) */ public int getWorkNo(Integer wrkMk) { @@ -76,87 +92,185 @@ return workNo; } + //鎷嗙洏鏈哄绌烘澘鎵爜锛岄┍鍔ㄦ墭鐩樺悜鐮佸灈浣嶏紝涓嶅叆搴� + @Transactional + public StartupDto getScanBarcodeEmptyBoard(){ + StartupDto startupDto = new StartupDto(); + Integer staNo = 0; + if (wrkMastService.selectCount(new EntityWrapper<WrkMast>().eq("io_type", 201).eq("staNo", 216))<2){ + staNo=216; + } + if (wrkMastService.selectCount(new EntityWrapper<WrkMast>().eq("io_type", 201).eq("staNo", 220))<2){ + staNo=220; + } + + startupDto.setStaNo(staNo); + return startupDto; + } + /** * 妫�绱㈠簱浣嶅彿 * @param whsType 绫诲瀷 1:鍙屾繁寮忚揣鏋� * @param staDescId 璺緞ID * @param sourceStaNo 婧愮珯 - * @param matNos 鐗╂枡鍙烽泦鍚� + * @param matnr 鐗╂枡鍙烽泦鍚� * @return locNo 妫�绱㈠埌鐨勫簱浣嶅彿 */ - public StartupDto getLocNo(Integer whsType, Integer staDescId, Integer sourceStaNo, List<String> matNos) { - StartupDto startupDto = new StartupDto(); - // 鐢熸垚宸ヤ綔鍙� - int workNo = getWorkNo(WorkNoType.getWorkNoType(staDescId)); - startupDto.setWorkNo(workNo); - if (sourceStaNo < 100) { - whsType = 1; - } else { - whsType = 2; + @Transactional + public StartupDto getLocNo(Integer whsType, Integer staDescId, Integer sourceStaNo, String matnr, String batch,String grade,LocTypeDto locTypeDto, int times) { + if (Cools.isEmpty(matnr)){ //鐗╂枡鍙� + matnr=""; } + if (Cools.isEmpty(batch)){ //绠卞彿 + batch=""; + } + if (Cools.isEmpty(grade)){ //澶囩敤 + grade=""; + } + + // 鍒濆鍖栧弬鏁� + int crnNo = 0; //鍫嗗灈鏈哄彿 + int nearRow = 0; //鏈�娴呭簱浣嶆帓 + int curRow = 0; //鏈�娣卞簱浣嶆帓 + int rowCount = 0; //杞杞 + LocMast locMast = null; // 鐩爣搴撲綅 + + StartupDto startupDto = new StartupDto(); RowLastno rowLastno = rowLastnoService.selectById(whsType); if (Cools.isEmpty(rowLastno)) { throw new CoolException("鏁版嵁寮傚父锛岃鑱旂郴绠$悊鍛�"); } - if (whsType == 1 || whsType == 2){ - int curRow = rowLastno.getCurrentRow(); - int sRow = rowLastno.getsRow(); - int eRow = rowLastno.geteRow(); + // ===============>>>> 寮�濮嬫墽琛� + curRow = rowLastno.getCurrentRow(); - // 鑾峰彇鐩爣绔欐墍鍦ㄨ揣鏋舵帓鍙� - curRow = curRow == sRow ? eRow : sRow; - // 鐩爣鍫嗗灈鏈哄彿 - int crnNo; - switch (whsType) { - case 1: - crnNo = 1; + int[] locNecessaryParameters = Utils.LocNecessaryParameters(whsType, curRow); + rowCount=locNecessaryParameters[0]; + curRow=locNecessaryParameters[1]; + crnNo=locNecessaryParameters[2]; + nearRow=locNecessaryParameters[3]; + if (!basCrnpService.checkSiteError(crnNo,true)){ //姝ょ▼搴忕敤浜庝紭鍖栧爢鍨涙満寮傚父鏃剁殑杩愯鏃堕棿 + times++; + for (int i=times;i<Utils.RowCount(whsType,curRow);i++){ + locNecessaryParameters = Utils.LocNecessaryParameters(whsType, curRow); + rowCount=locNecessaryParameters[0]; + curRow=locNecessaryParameters[1]; + crnNo=locNecessaryParameters[2]; + nearRow=locNecessaryParameters[3]; + if (basCrnpService.checkSiteError(crnNo,true)){ break; - case 2: - crnNo = 2; - break; - default: - throw new CoolException("妫�绱㈠簱浣� -- 妫�绱㈠爢鍨涙満鍙峰け璐�"); + }else { + times++; + } } + if (times==Utils.RowCount(whsType,curRow)){ + throw new CoolException("鏃犲彲鐢ㄥ爢鍨涙満"); + } + } - basCrnpService.checkSiteStatus(crnNo); + // 闈犺繎鎽嗘斁瑙勫垯 --- 鍚屽ぉ鍚岃鏍肩墿鏂� + if (Cools.isEmpty(locMast) && !Cools.isEmpty(matnr) && (staDescId == 1 || staDescId == 11 || staDescId == 111)) { + List<LocMast> locMasts = locMastService.selectList(new EntityWrapper<LocMast>().eq("row1", nearRow).eq("loc_sts", "O")); + for (LocMast locMast1:locMasts){ + String shallowLoc = Utils.getDeepLoc(slaveProperties,locMast1.getLocNo()); + LocMast locMast2 = locMastService.selectOne(new EntityWrapper<LocMast>().eq("loc_no",shallowLoc)); + if (!Cools.isEmpty(locMast2) && locMast2.getLocSts().equals("F")){ + LocDetl locDetl = locDetlService.selectOne(new EntityWrapper<LocDetl>().eq("loc_no", locMast2.getLocNo())); + if (!Cools.isEmpty(locDetl) && matnr.equals(locDetl.getMatnr())) { + locMast = locMast1; + break; + } + } + } + } + + // 闈犺繎鎽嗘斁瑙勫垯 --- 绌烘墭 + if (Cools.isEmpty(locMast) && staDescId == 10) { + List<LocMast> locMasts = locMastService.selectList(new EntityWrapper<LocMast>().eq("row1", nearRow).eq("loc_sts", "O")); + for (LocMast locMast1:locMasts){ + String shallowLoc = Utils.getDeepLoc(slaveProperties,locMast1.getLocNo()); + LocMast locMast2 = locMastService.selectOne(new EntityWrapper<LocMast>().eq("loc_no",shallowLoc)); + if (!Cools.isEmpty(locMast2) && locMast2.getLocSts().equals("D")){ + locMast = locMast1; + break; + } + } + } + + Wrapper<StaDesc> wrapper = null; + StaDesc staDesc = null; + BasDevp staNo = null; + + if (Utils.BooleanWhsTypeSta(whsType)){ // 鑾峰彇鐩爣绔� - Wrapper<StaDesc> wrapper = new EntityWrapper<StaDesc>() + wrapper = new EntityWrapper<StaDesc>() .eq("type_no", staDescId) .eq("stn_no", sourceStaNo) .eq("crn_no", crnNo); - StaDesc staDesc = staDescService.selectOne(wrapper); + staDesc = staDescService.selectOne(wrapper); if (Cools.isEmpty(staDesc)) { - throw new CoolException("鍏ュ簱璺緞涓嶅瓨鍦�"); + log.error("type_no={},stn_no={},crn_no={}", staDescId, sourceStaNo, crnNo); +// throw new CoolException("鍏ュ簱璺緞涓嶅瓨鍦�"); + crnNo=0; } - BasDevp staNo = basDevpService.selectById(staDesc.getCrnStn()); - int inQty = staNo.getInQty()==null?0:staNo.getInQty(); - if (staNo.getAutoing().equals("Y") && inQty<2) { - // 鏌ユ壘搴撲綅 - LocMast locMast = locMastService.queryFreeLocMast(curRow); - if (Cools.isEmpty(locMast)) { - throw new CoolException("娌℃湁绌哄簱浣�"); - } - String locNo = locMast.getLocNo(); - - // 鏇存柊搴撲綅鎺掑彿 - rowLastno.setCurrentRow(curRow); - rowLastnoService.updateById(rowLastno); - - // 杩斿洖dto - startupDto.setCrnNo(crnNo); - startupDto.setSourceStaNo(sourceStaNo); - startupDto.setStaNo(staNo.getDevNo()); - startupDto.setLocNo(locNo); - } else { - throw new CoolException("鐩爣绔�"+staDesc.getCrnStn()+"涓嶅彲鐢�"); + staNo = basDevpService.selectById(staDesc.getCrnStn()); + if (!staNo.getAutoing().equals("Y")) { +// throw new CoolException("鐩爣绔�"+staDesc.getCrnStn()+"涓嶅彲鐢�"); + crnNo=0; } - } else { - throw new CoolException(rowLastno.getWhsType()+"鍙峰簱浣嶆帓鍙峰垎閰嶈鍒欎笉鍙敤"); } + + // 鏇存柊搴撲綅鎺掑彿 + if (Utils.BooleanWhsTypeSta(whsType)){ + rowLastno.setCurrentRow(curRow); + rowLastnoService.updateById(rowLastno); + } + + // 寮�濮嬫煡鎵惧簱浣� ==============================>> + + // 1.鎸夎鍒欐煡鎵惧簱浣� + if (Cools.isEmpty(locMast) && crnNo!=0){ + List<LocMast> locMasts = locMastService.selectList(new EntityWrapper<LocMast>().eq("row1", nearRow).eq("loc_sts", "O")); + for (LocMast locMast1:locMasts){ + String shallowLoc = Utils.getDeepLoc(slaveProperties,locMast1.getLocNo()); + LocMast locMast2 = locMastService.selectOne(new EntityWrapper<LocMast>().eq("loc_no",shallowLoc).eq("loc_sts","O")); + if (!Cools.isEmpty(locMast2)){ + locMast = locMast2; + break; + } + } + } + + if (Cools.isEmpty(locMast) && !basCrnpService.checkSiteError(crnNo,true)){ + locMast = null; + } + + // 2.搴撲綅褰撳墠鎵�灞炲昂瀵告棤绌哄簱浣嶆椂锛岃皟鏁村昂瀵稿弬鏁帮紝鍚戜笂鍏煎妫�绱㈠簱浣� + if (Cools.isEmpty(locMast) || !locMast.getLocSts().equals("O")) { + // 褰撳墠宸烽亾鏃犵┖搴撲綅鏃讹紝閫掑綊璋冩暣鑷充笅涓�宸烽亾锛屾绱㈠叏閮ㄥ贩閬撴棤鏋滃悗锛岃烦鍑洪�掑綊 + if (times < rowCount) { + times = times + 1; + return getLocNo(1, staDescId, sourceStaNo, matnr,batch,grade, locTypeDto, times); + } + + log.error("绯荤粺娌℃湁绌哄簱浣嶏紒锛侊紒 灏哄瑙勬牸锛� {}锛� 杞娆℃暟锛歿}", JSON.toJSONString(locTypeDto), times); + throw new CoolException("娌℃湁绌哄簱浣�"); + } + String locNo = locMast.getLocNo(); + + // 鐢熸垚宸ヤ綔鍙� + int workNo = getWorkNo(0); + // 杩斿洖dto + startupDto.setWorkNo(workNo); + startupDto.setCrnNo(crnNo); + startupDto.setSourceStaNo(sourceStaNo); + if (Utils.BooleanWhsTypeSta(whsType)){ + startupDto.setStaNo(staNo.getDevNo()); + } + startupDto.setLocNo(locNo); return startupDto; } - public static String zerofill(String msg, Integer count) { + private static String zerofill(String msg, Integer count) { if (msg.length() == count) { return msg; } else if (msg.length() > count) { @@ -170,4 +284,4 @@ } } -} \ No newline at end of file +} -- Gitblit v1.9.1