From ff9ff27ce3da6f911576152a0d41e8830041f0a0 Mon Sep 17 00:00:00 2001
From: zhang <zc857179121@qq.com>
Date: 星期三, 21 五月 2025 10:12:14 +0800
Subject: [PATCH] 接口编写
---
src/main/java/com/zy/asrs/service/impl/AgvLocMastServiceImpl.java | 411 +++++++++++++++++++++++++++++++++++++++++++++++++++++-----
1 files changed, 374 insertions(+), 37 deletions(-)
diff --git a/src/main/java/com/zy/asrs/service/impl/AgvLocMastServiceImpl.java b/src/main/java/com/zy/asrs/service/impl/AgvLocMastServiceImpl.java
index 57250ad..b1d9bb2 100644
--- a/src/main/java/com/zy/asrs/service/impl/AgvLocMastServiceImpl.java
+++ b/src/main/java/com/zy/asrs/service/impl/AgvLocMastServiceImpl.java
@@ -1,5 +1,6 @@
package com.zy.asrs.service.impl;
+import com.baomidou.mybatisplus.enums.SqlLike;
import com.baomidou.mybatisplus.mapper.EntityWrapper;
import com.baomidou.mybatisplus.service.impl.ServiceImpl;
import com.zy.asrs.entity.AgvLocMast;
@@ -21,58 +22,42 @@
@Autowired
AgvLocMastMapper agvLocMastMapper;
- public void clearLoc(){
+ public void clearLoc() {
agvLocMastMapper.deleteAll();
}
public void initLocFloor1() {
- //1妤� 13鎺� 86鍒� 12灞�
- List<AgvLocMast> agvLocMastList = getLocMastList(1,13,1,86,1,12,1);
- this.insertBatch(agvLocMastList);
+ this.insertBatch(getLocMastList(1, 22, 1, 39, 2, 2, 1));
}
+ public void initLocFloor2() {
+ //2妤� 1-25鎺� 1-33鍒� 1灞�
+ this.insertBatch(getLocMastList(1, 25, 1, 33, 1, 1, 2));
+ }
+
public void initLocFloor3() {
- //3妤� 1-33鎺� 1-14鍒� 8灞�
- this.insertBatch(getLocMastList(1, 33, 1, 14, 1, 8, 3));
-
- //3妤� 1-27鎺� 15-34鍒� 8灞�
- this.insertBatch(getLocMastList(1, 27, 15, 34, 1, 8, 3));
-
- //3妤� 1-25鎺� 35-46鍒� 8灞�
- this.insertBatch(getLocMastList(1, 25, 35, 46, 1, 8, 3));
-
- //3妤� 3-25鎺� 47-60鍒� 8灞�
- this.insertBatch(getLocMastList(3, 25, 47, 60, 1, 8, 3));
-
- //3妤� 4-25鎺� 61-70鍒� 8灞�
- this.insertBatch(getLocMastList(4, 25, 61, 70, 1, 8, 3));
-
+ //2妤� 1-25鎺� 1-33鍒� 1灞�
+ this.insertBatch(getLocMastList(1, 26, 1, 34, 1, 1, 3));
}
//鏍规嵁鎺掑垪灞傝幏鍙朅GV搴撲綅鍒楄〃
- private List<AgvLocMast> getLocMastList(int rowIndex, int rowMax, int bayIndex, int bayMax, int levIndex, int levMax, int floor){
+ private List<AgvLocMast> getLocMastList(int rowIndex, int rowMax, int bayIndex, int bayMax, int levIndex, int levMax, int floor) {
List<AgvLocMast> agvLocMastList = new ArrayList<>();
Date now = new Date();
- for(int row=rowIndex; row<=rowMax; row++) {
+ for (int row = rowIndex; row <= rowMax; row++) {
for (int bay = bayIndex; bay <= bayMax; bay++) {
for (int lev = levIndex; lev <= levMax; lev++) {
- if(row == 8 || row == 9){
- if((bay >=8 && bay <=11)
- || (bay >= 20 && bay <=23)
- || (bay>=37 && bay <=39)
- || (bay>=50 && bay <=52)
- || (bay>=63 && bay <=64)
- || (bay>=79 && bay <=80)){
- continue;
- }
+
+ if (!checkLocExistFloor1_2(row, bay)) {
+ continue;
}
AgvLocMast loc = new AgvLocMast();
- String locRow = row < 10 ? "-00" + row : "-0" + row;
- String locBay = bay < 10 ? "-00" + bay : "-0" + bay;
- String locLev = lev < 10 ? "-0" + lev : "-" + lev;
- String locNo = "SK" + locRow + locBay + locLev + "@" + floor;
+ String locRow = row < 10 ? "_00" + row : "_0" + row;
+ String locBay = bay < 10 ? "_00" + bay : "_0" + bay;
+ String locLev = lev < 10 ? "_0" + lev : "_" + lev;
+ String locNo = "YZ" + locRow + locBay + locLev + "F" + floor;
loc.setLocNo(locNo);
loc.setLocSts("O");
loc.setRow1(row);
@@ -82,12 +67,296 @@
loc.setModiTime(now);
loc.setFirstTime(now);
loc.setAppeTime(now);
+ loc.setLocType1((short) 3);
+ // loc.setLocType1(initLocMastSts3(row,bay));
agvLocMastList.add(loc);
}
}
}
- return agvLocMastList;
+ return agvLocMastList;
+ }
+
+ private boolean checkLocExistFloor1_2(int row, int bay) {
+ if (row == 4 && bay == 19) {
+ return false;
+ }
+
+ if (row == 5 && (bay == 3 || bay == 8 || bay == 13 || bay == 18 || bay == 19 || bay == 24 || bay == 29)) {
+ return false;
+ }
+
+ if ((row == 6 || row == 7) && bay == 39) {
+ return false;
+ }
+
+ if ((row == 9 || row == 10 || row == 14 || row == 18) && (bay == 3 || bay == 8 || bay == 13 || bay == 14 || bay == 19 || bay == 24 || bay == 29 || bay == 30)) {
+ return false;
+ }
+ if ((row == 10 || row == 11) && (bay == 7 || bay == 12 || bay == 23 || bay == 28)) {
+ return false;
+ }
+ if ((row == 9 || row == 13) && bay == 35) {
+ return false;
+ }
+ if (row == 13 && (bay == 18 || bay == 19 || bay == 20)) {
+ return false;
+ }
+ if (row == 9 && bay == 18) {
+ return false;
+ }
+ if ((row == 14 || row == 15) && bay > 37) {
+ return false;
+ }
+ if (row >= 16 && bay >= 35) {
+ return false;
+ }
+ if ((row >= 2 && row <= 21) && bay == 17) {
+ return false;
+ }
+
+ if (bay >= 33 && bay <= 34) {
+ return false;
+ }
+
+ return true;
+ }
+
+ private boolean checkLocExistFloor1_1(int row, int bay) {
+ if (row <= 2 && bay >= 20) {
+ return false;
+ }
+ if ((row == 4 || row == 9 || row == 14 || row == 20 || row == 25 || row == 30) && (bay == 7 || bay == 11 || bay == 12 || bay == 16)) {
+ return false;
+ }
+ if ((row == 7 || row == 13 || row == 21 || row == 26) && (bay == 12 || bay == 13)) {
+ return false;
+ }
+ if (row >= 10 && bay == 1) {
+ return false;
+ }
+ if (row == 18 && bay <= 19) {
+ return false;
+ }
+ if (row == 25 && bay == 20) {
+ return false;
+ }
+ if ((row >= 26 && row <= 27) && (bay >= 18 && bay <= 19)) {
+ return false;
+ }
+ if (row >= 28 && bay == 20) {
+ return false;
+ }
+
+ return true;
+ }
+
+ private boolean checkLocExistFloor2(int row, int bay) {
+ if (row <= 4 && bay >= 13) {
+ return false;
+ }
+
+ if (row <= 7 && bay >= 25) {
+ return false;
+ }
+
+ if (row >= 24 && bay >= 29) {
+ return false;
+ }
+
+ if ((row != 20 && row != 25) && (bay == 8 || bay == 22)) {
+ return false;
+ }
+
+ if ((row == 3 || row == 12 || row == 16 || row == 21) && (bay == 4 || bay == 9 || bay == 14 || bay == 20 || bay == 25 || bay == 30 || bay == 31)) {
+ return false;
+ }
+
+ if (row == 21 && bay == 15) {
+ return false;
+ }
+
+ if (row == 23 && bay == 29) {
+ return false;
+ }
+
+ return true;
+ }
+
+ private short initLocMastSts(int row, int bay) {
+
+ if (row <= 11 && bay <= 14) {
+ return 1;
+ }
+
+ if (row <= 7) {
+ return 1;
+ }
+
+ if (row >= 21) {
+ return 3;
+ }
+
+ return 2;
+ }
+
+ private boolean checkLocExistFloor3(int row, int bay) {
+ if (row == 1 && (bay <= 15 || bay >= 30)) {
+ return false;
+ }
+
+ if (row <= 6 && bay >= 30) {
+ return false;
+ }
+
+ if ((row >= 9 && row <= 16) && (bay <= 4 || bay >= 33)) {
+ return false;
+ }
+ if (row == 17 && (bay <= 3 || bay >= 33)) {
+ return false;
+ }
+
+ if (row <= 21 && row != 7 && row != 8 && bay >= 33) {
+ return false;
+ }
+ if ((row <= 24 && row != 7 && row != 8) && bay >= 34) {
+ return false;
+ }
+ if (row >= 25 && row <= 26 && bay >= 29) {
+ return false;
+ }
+
+
+ if ((row != 8 && row != 21 && row != 23 && row != 24 && row != 25 && row != 26) && bay == 15) {
+ return false;
+ }
+
+ if ((row >= 22 && row != 26) && bay == 16) {
+ return false;
+ }
+
+ if (row == 4 && (bay == 3 || bay == 4 || bay == 9 || bay == 14 || bay == 19 || bay == 20 || bay == 25)) {
+ return false;
+ }
+
+ if ((row == 13 || row == 17) && (bay == 8 || bay == 14 || bay == 19 || bay == 24)) {
+ return false;
+ }
+ if (row == 22 && (bay == 4 || bay == 9 || bay == 14 || bay == 20 || bay == 25)) {
+ return false;
+ }
+
+ return true;
+ }
+
+ private short initLocMastSts3(int row, int bay) {
+
+ if (row <= 8) {
+ return 1;
+ }
+
+ if (row <= 17) {
+ return 2;
+ }
+
+ if (row <= 18 && bay >= 9) {
+ return 2;
+ }
+
+ if (row <= 21) {
+ return 4;
+ }
+
+ if (row >= 22) {
+ return 3;
+ }
+
+ return 2;
+ }
+
+ private boolean checkLocExist(int row, int bay, int floor) {
+ //if(floor == 1 && (row == 2)){
+ // if((bay >=8 && bay <=11)
+ // || (bay >= 20 && bay <=23)
+ // || (bay>=37 && bay <=39)
+ // || (bay>=50 && bay <=52)
+ // || (bay>=63 && bay <=64)
+ // || (bay>=79 && bay <=80)){
+ // return false;
+ // }
+ //}
+ if (floor == 1) {
+ if (row == 2 || row == 5 || row == 8 || row == 11
+ || row == 14 || row == 17 || row == 19 || row == 22 || row == 25
+ || row == 28 || (row > 29 && row < 39) || row == 41 || row == 44) {
+ return false;
+ } else if (row == 1) {
+ if (bay < 19) {
+ return false;
+ }
+ } else if (row == 3 || row == 4) {
+ if (bay < 19 || bay == 26) {
+ return false;
+ }
+ } else if (row == 6) {
+ if (bay < 20 || bay == 26 || bay == 30) {
+ return false;
+ }
+ } else if (row == 7) {
+ if (bay < 4 || bay == 26) {
+ return false;
+ }
+ } else if (row == 9 || row == 10) {
+ if (bay < 4 || bay == 12 || bay == 26) {
+ return false;
+ }
+ } else if (row == 12) {
+ if (bay < 4) {
+ return false;
+ }
+ } else if (row == 15 || row == 18 || row == 20 || row == 21 || row == 24 || row == 26 || row == 27 || row == 40) {
+ if (bay == 12 || bay == 26) {
+ return false;
+ }
+ } else if (row == 16 || row == 23 || row == 39) {
+ if (bay == 3 || bay == 4 || bay == 9 || bay == 12 || bay == 14 || bay == 20 || bay == 25 || bay == 26) {
+ return false;
+ }
+ } else if (row == 42) {
+ if (bay == 5 || bay == 12 || bay == 26) {
+ return false;
+ }
+ } else if (row == 43) {
+ if (bay < 6 || bay == 12 || bay == 26) {
+ return false;
+ }
+ } else if (row == 45) {
+ if (bay < 6) {
+ return false;
+ }
+ } else {
+ return true;
+ }
+ }
+
+ if (floor == 3) {
+ if (row == 1 && bay > 63) {
+ return false;
+ }
+ if (row == 2 && bay > 65) {
+ return false;
+ }
+ if (row > 23 && bay == 1) {
+ return false;
+ }
+
+ if (bay > 35 && bay < 39) {
+ if (row == 4 || row == 5 || row == 10 || row == 11 || row == 17 || row == 18) {
+ return false;
+ }
+ }
+ }
+ return true;
}
@Override
@@ -97,12 +366,36 @@
@Override
public void updateLocType2ByRBL(Integer locType2, AgvLocRule locRule) {
- this.baseMapper.updateLocType2(locType2,locRule.getRowBeg(),locRule.getRowEnd(),locRule.getBayBeg(),locRule.getBayEnd(),locRule.getLevBeg(),locRule.getLevEnd(),locRule.getFloor());
+ this.baseMapper.updateLocType2(locType2, locRule.getRowBeg(), locRule.getRowEnd(), locRule.getBayBeg(), locRule.getBayEnd(), locRule.getLevBeg(), locRule.getLevEnd(), locRule.getFloor());
}
- public void updateLocStsByLocNo(String locNo, String locSts) {
+ public void updateLocStsByLocNo(String locNo, String locSts, String barcode, Short containerType) {
AgvLocMast agvLocMast = this.selectById(locNo);
agvLocMast.setLocSts(locSts);
+ agvLocMast.setBarcode(barcode);
+ agvLocMast.setLocType2(containerType);
+ agvLocMast.setModiTime(new Date());
+ this.updateById(agvLocMast);
+ }
+
+ public void updateLocStsByLocNo(String locNo, String locSts, String barcode, Short containerType, String ctnNo) {
+ AgvLocMast agvLocMast = this.selectById(locNo);
+ agvLocMast.setLocSts(locSts);
+ agvLocMast.setBarcode(barcode);
+ agvLocMast.setLocType2(containerType);
+ agvLocMast.setCtnNo(ctnNo);
+ agvLocMast.setModiTime(new Date());
+ this.updateById(agvLocMast);
+ }
+
+ public void updateLocStsByLocNo(String locNo, String locSts, String barcode, Short containerType, String locType, Short locType3) {
+ AgvLocMast agvLocMast = this.selectById(locNo);
+ agvLocMast.setLocSts(locSts);
+ agvLocMast.setBarcode(barcode);
+ agvLocMast.setLocType2(containerType);
+ agvLocMast.setLocType(locType);
+ agvLocMast.setLocType3(locType3);
+ agvLocMast.setModiTime(new Date());
this.updateById(agvLocMast);
}
@@ -117,4 +410,48 @@
//return this.agvLocMastMapper.selectLocByLevAndFloor(lev,floor);
}
+ @Override
+ public AgvLocMast selectEmptyZpallet(int type, int floor) {
+
+ return this.selectOne(new EntityWrapper<AgvLocMast>().eq("loc_sts", "D").like("barcode", type + "", SqlLike.RIGHT).eq("floor", floor).orderBy("lev1", true));
+
+ }
+
+ @Override
+ public AgvLocMast select30EmptyZpallet() {
+
+ return this.selectOne(new EntityWrapper<AgvLocMast>().eq("loc_sts", "D").eq("loc_type2", 30).eq("floor", 1).eq("lev1", 2));
+
+ }
+
+ @Override
+ public AgvLocMast selectEmptyZpalletByLocType1(int type) {
+
+ return this.selectOne(new EntityWrapper<AgvLocMast>().eq("loc_sts", "D").eq("loc_type1", type));
+
+ }
+
+ @Override
+ public List<String> queryContainerTypeByLocType1(Short locType1) {
+ return this.baseMapper.queryContainerTypeByLocType1(locType1);
+ }
+
+ @Override
+ public List<AgvLocMast> selectDistinctLocByLevAndFloor(int lev, int floor) {
+
+ return this.agvLocMastMapper.selectDistinctLocByLevAndFloor(lev, floor);
+ }
+
+ @Override
+ public List<AgvLocMast> selectDistinctLocByLevAndFloorMaprow1(int lev, int floor) {
+
+ return this.agvLocMastMapper.selectDistinctLocByLevAndFloorMaprow1(lev, floor);
+ }
+
+ @Override
+ public List<AgvLocMast> selectDistinctLocByLevAndFloorMapbay1(int lev, int floor) {
+
+ return this.agvLocMastMapper.selectDistinctLocByLevAndFloorMapbay1(lev, floor);
+ }
+
}
--
Gitblit v1.9.1