From 64b43585fc8bed4612b32d7984729c5b1e449cf6 Mon Sep 17 00:00:00 2001
From: zjj <3272660260@qq.com>
Date: 星期四, 20 二月 2025 13:47:25 +0800
Subject: [PATCH] #四向库入库修改
---
src/main/java/com/zy/asrs/utils/Utils.java | 22 ++--
src/main/java/com/zy/common/service/CommonService.java | 177 ++++++++++++++++----------------------------
2 files changed, 76 insertions(+), 123 deletions(-)
diff --git a/src/main/java/com/zy/asrs/utils/Utils.java b/src/main/java/com/zy/asrs/utils/Utils.java
index e1d291c..9fc0635 100644
--- a/src/main/java/com/zy/asrs/utils/Utils.java
+++ b/src/main/java/com/zy/asrs/utils/Utils.java
@@ -526,27 +526,27 @@
curRow = curRow - offset;
//婊℃澘姝ｅ父鍏ュ簱
switch (curRow){
- case 1:
- necessaryParameters[1] = 4; //curRow 鏈�娣卞簱浣嶆帓
+ case 2:
+ necessaryParameters[1] = 5; //curRow 鏈�娣卞簱浣嶆帓
necessaryParameters[2] = sCrnNo; //crnNo 鍫嗗灈鏈哄彿
- necessaryParameters[3] = 6; //nearRow 鏈�娴呭簱浣嶆帓
+ necessaryParameters[3] = 4; //nearRow 鏈�娴呭簱浣嶆帓
break;
- case 4:
- necessaryParameters[1] = 7; //curRow 鏈�娣卞簱浣嶆帓
+ case 5:
+ necessaryParameters[1] = 6; //curRow 鏈�娣卞簱浣嶆帓
necessaryParameters[2] = sCrnNo; //crnNo 鍫嗗灈鏈哄彿
necessaryParameters[3] = 7; //nearRow 鏈�娴呭簱浣嶆帓
break;
- case 7:
- necessaryParameters[1] = 9; //curRow 鏈�娣卞簱浣嶆帓
+ case 6:
+ necessaryParameters[1] = 10; //curRow 鏈�娣卞簱浣嶆帓
necessaryParameters[2] = sCrnNo; //crnNo 鍫嗗灈鏈哄彿
- necessaryParameters[3] = 11; //nearRow 鏈�娴呭簱浣嶆帓
+ necessaryParameters[3] = 9; //nearRow 鏈�娴呭簱浣嶆帓
break;
- case 9:
- necessaryParameters[1] = 12; //curRow 鏈�娣卞簱浣嶆帓
+ case 10:
+ necessaryParameters[1] = 11; //curRow 鏈�娣卞簱浣嶆帓
necessaryParameters[2] = sCrnNo; //crnNo 鍫嗗灈鏈哄彿
necessaryParameters[3] = 12; //nearRow 鏈�娴呭簱浣嶆帓
break;
- case 12:
+ case 11:
necessaryParameters[1] = 14; //curRow 鏈�娣卞簱浣嶆帓
necessaryParameters[2] = sCrnNo; //crnNo 鍫嗗灈鏈哄彿
necessaryParameters[3] = 14; //nearRow 鏈�娴呭簱浣嶆帓
diff --git a/src/main/java/com/zy/common/service/CommonService.java b/src/main/java/com/zy/common/service/CommonService.java
index 1a77b31..09ce68b 100644
--- a/src/main/java/com/zy/common/service/CommonService.java
+++ b/src/main/java/com/zy/common/service/CommonService.java
@@ -534,57 +534,6 @@
throw new CoolException("鏃犲彲鐢ㄥ簱浣�");
}
-
- // 鐩镐技宸ヤ綔妗ｆ --- 鍚屽ぉ鍚岃鏍肩墿鏂�
- if (!Cools.isEmpty(matnr) && (staDescId == 1 || staDescId == 11 || staDescId == 111) && !mixture ) {
- //鏌ヨ鐩镐技宸ヤ綔妗ｆ
- List<WrkMast> wrkMasts = wrkMastService.selectWrkMastWrkDetlMatnrBatch(staDescId, matnr, batch,grade, crnNo);
- int nearbay = 0; //鐩镐技宸ヤ綔妗ｆ 鐩爣搴撲綅鍒�
- int nearlev = 0; //鐩镐技宸ヤ綔妗ｆ 鐩爣搴撲綅灞�
- for (WrkMast wrkMast:wrkMasts){
- LocMast locMastWrk = locMastService.selectOne(new EntityWrapper<LocMast>().eq("loc_no", wrkMast.getLocNo()));
- List<LocMast> locMasts = new ArrayList<>();
- if (locMastWrk.getBay1() >=1 && locMastWrk.getBay1()<=2){
- locMasts = locMastService.selectList(new EntityWrapper<LocMast>()
- .eq("gro1", locMastWrk.getGro1())
- .eq("crn_no", 7)
- .eq("loc_type1",locTypeDto.getLocType1())
- .orderBy("bay1", true));
- }else if (locMastWrk.getBay1() >=4 && locMastWrk.getBay1()<=12){
- locMasts = locMastService.selectList(new EntityWrapper<LocMast>()
- .eq("gro1", locMastWrk.getGro1())
- .eq("crn_no", 7)
- .eq("loc_type1",locTypeDto.getLocType1())
- .orderBy("bay1", false));
- }else {
- locMasts = locMastService.selectList(new EntityWrapper<LocMast>()
- .eq("gro1", locMastWrk.getGro1())
- .eq("crn_no", 7)
- .eq("loc_type1",locTypeDto.getLocType1())
- .orderBy("bay1", true));
- }
- if (Cools.isEmpty(locMasts)) {
- continue;
- }
- for (LocMast locMastGro1 : locMasts) {
-
- if (locMastGro1.getBay1() == 2){ //wcs闂闄愬埗
- continue;
- }
- if (locMastGro1.getLocSts().equals("P") || locMastGro1.getLocSts().equals("Q")) {
- break;
- }
- if (locMastGro1.getLocSts().equals("O")){
- locMast = locMastGro1;
- break;
- }
- }
-
-
- }
-
- }
-
Wrapper<StaDesc> wrapper = null;
StaDesc staDesc = null;
BasDevp staNo = null;
@@ -619,12 +568,48 @@
// 1.鎸夎鍒欐煡鎵惧簱浣�
if (Cools.isEmpty(locMast) && crnNo != 0) {
- List<LocMast> locMasts = locMastService.selectList(new EntityWrapper<LocMast>()
+ List<LocMast> locMasts = new ArrayList<>();
+ int floor = 0;
+ if (locTypeDto.getLocType1() == 1){
+ int F1count = locMastService.selectCount(new EntityWrapper<LocMast>()
+ .in("loc_sts", "O").eq("whs_type", rowLastnoType.getType().longValue())
+ .eq("crn_no", 7)
+ .eq("loc_type1", locTypeDto.getLocType1())
+ .eq("lev1", 1));
+ if (F1count <= 10) {
+ int F2count = locMastService.selectCount(new EntityWrapper<LocMast>()
+ .in("loc_sts", "O").eq("whs_type", rowLastnoType.getType().longValue())
+ .eq("crn_no", 7)
+ .eq("loc_type1", locTypeDto.getLocType1())
+ .eq("lev1", 2));
+ if (F2count <= 10) {
+ throw new CoolException("搴撲綅涓嶈冻");
+ }else {
+ floor = 2;
+ }
+ }else {
+ floor = 1;
+ }
+
+ }else if (locTypeDto.getLocType1() == 2){
+ int F3count = locMastService.selectCount(new EntityWrapper<LocMast>()
+ .in("loc_sts", "O").eq("whs_type", rowLastnoType.getType().longValue())
+ .eq("crn_no", 7)
+ .eq("loc_type1", locTypeDto.getLocType1())
+ .eq("lev1", 3));
+ if (F3count <= 10) {
+ throw new CoolException("搴撲綅涓嶈冻");
+ }
+ floor = 3;
+ }else {
+ throw new CoolException("搴撲綅楂樺害鏁版嵁寮傚父");
+ }
+ locMasts = locMastService.selectList(new EntityWrapper<LocMast>()
.eq("bay1", nearRow)
- .in("loc_sts", "O","X").eq("whs_type",rowLastnoType.getType().longValue())
+ .in("loc_sts", "O").eq("whs_type",rowLastnoType.getType().longValue())
.eq("crn_no",7)
.eq("loc_type1",locTypeDto.getLocType1())
- .orderBy("lev1",true).orderBy("row1",false));//鏈�娴呭簱浣�
+ .eq("lev1",floor).orderBy("row1",false));//鏈�娴呭簱浣�
for (LocMast locMast1 : locMasts) {
if (locMast != null){
@@ -633,65 +618,33 @@
if (!VersionUtils.locMoveCheckLocTypeComplete(locMast1, locTypeDto)) {
continue;
}
- if (Utils.BooleanWhsTypeStaIoType(rowLastno)){
- //鑾峰彇鐩爣搴撲綅鎵�鍦ㄥ贩閬撴渶娣辩┖搴撲綅
-// LocMast locMast2 = locMastService.selectLocByLocStsPakInO(curRow,nearRow,locMast1,rowLastnoType.getType().longValue());
-// if (!Cools.isEmpty(locMast2) && locMast2.getBay1()==curRow) {
-// locMast = locMast2;
-// break;
-// }
- List<LocMast> locMasts1 = null;
- if (curRow < nearRow){
- locMasts1 = locMastService.selectList(new EntityWrapper<LocMast>()
- .eq("gro1", locMast1.getGro1())
- .eq("crn_no",7)
- .eq("loc_type1",locTypeDto.getLocType1())
- .orderBy("bay1",true));
- if(locMast1.getBay1()>= 4 && locMast1.getBay1()<=12){
- locMasts1 = locMastService.selectList(new EntityWrapper<LocMast>()
- .eq("gro1", locMast1.getGro1())
- .eq("crn_no",7)
- .eq("loc_type1",locTypeDto.getLocType1())
- .orderBy("bay1",false));
- }
- }else {
- locMasts1 = locMastService.selectList(new EntityWrapper<LocMast>()
- .eq("gro1", locMast1.getGro1())
- .eq("crn_no",7)
- .eq("loc_type1",locTypeDto.getLocType1())
- .orderBy("bay1",false));
- }
- if (Cools.isEmpty(locMasts1)) {
- continue;
- }
- for (LocMast locMastGro1 : locMasts1) {
- if (mixture){ //娣锋枡鍙厑璁告斁 7 12 14
- if (locMastGro1.getBay1() != 7 && locMastGro1.getBay1() != 12 && locMastGro1.getBay1() != 14){
- continue;
- }
- }else { //涓嶆贩鏂欎笉鍏佽鏀� 7 12 14
- if (locMastGro1.getBay1() == 7 || locMastGro1.getBay1() == 12 || locMastGro1.getBay1() == 14){
- continue;
- }
- }
- if (locMastGro1.getLocSts().equals("F")){
- LocDetl locDetl = locDetlService.selectOne(new EntityWrapper<LocDetl>().eq("loc_No", locMastGro1.getLocNo()));
- if (!locDetl.getMatnr().equals(matnr) || !locDetl.getBatch().equals(batch)){
- break;
- }
- }
- if (locMastGro1.getLocSts().equals("P") || locMastGro1.getLocSts().equals("Q") || locMastGro1.getLocSts().equals("R")) {
- break;
- }
- if (locMastGro1.getLocSts().equals("O")){
- locMast = locMastGro1;
- break;
- }
- }
-
-
-
+ List<LocMast> locMasts1 = null;
+ if (nearRow == 2 || nearRow ==7 || nearRow == 12){
+ locMasts1 = locMastService.selectList(new EntityWrapper<LocMast>()
+ .eq("gro1", locMast1.getGro1())
+ .eq("crn_no",7)
+ .eq("loc_type1",locTypeDto.getLocType1())
+ .orderBy("bay1",true));
+ }else {
+ locMasts1 = locMastService.selectList(new EntityWrapper<LocMast>()
+ .eq("gro1", locMast1.getGro1())
+ .eq("crn_no",7)
+ .eq("loc_type1",locTypeDto.getLocType1())
+ .orderBy("bay1",false));
}
+ if (Cools.isEmpty(locMasts1)) {
+ continue;
+ }
+ for (LocMast locMastGro1 : locMasts1) {
+ if (locMastGro1.getLocSts().equals("P") || locMastGro1.getLocSts().equals("Q") || locMastGro1.getLocSts().equals("R")) {
+ break;
+ }
+ if (locMastGro1.getLocSts().equals("O")){
+ locMast = locMastGro1;
+ break;
+ }
+ }
+
}
}
--
Gitblit v1.9.1