package com.zy.asrs.service.impl; import com.baomidou.mybatisplus.mapper.EntityWrapper; import com.baomidou.mybatisplus.service.impl.ServiceImpl; import com.zy.asrs.entity.AgvLocMast; import com.zy.asrs.entity.AgvLocRule; import com.zy.asrs.mapper.AgvLocMastMapper; import com.zy.asrs.service.AgvLocMastService; 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; @Service @Transactional public class AgvLocMastServiceImpl extends ServiceImpl implements AgvLocMastService { @Autowired AgvLocMastMapper agvLocMastMapper; public void clearLoc(){ agvLocMastMapper.deleteAll(); } public void initLocFloor1() { this.insertBatch(getLocMastList(1, 32, 1, 20, 1, 1, 1)); } public void initLocFloor2() { //2楼 1-25排 1-33列 1层 this.insertBatch(getLocMastList(1, 25, 1, 33, 1, 1, 2)); } public void initLocFloor3() { //2楼 1-25排 1-33列 1层 this.insertBatch(getLocMastList(1, 26, 1, 34, 1, 1, 3)); } //根据排列层获取AGV库位列表 private List getLocMastList(int rowIndex, int rowMax, int bayIndex, int bayMax, int levIndex, int levMax, int floor){ List agvLocMastList = new ArrayList<>(); Date now = new Date(); for(int row=rowIndex; row<=rowMax; row++) { for (int bay = bayIndex; bay <= bayMax; bay++) { for (int lev = levIndex; lev <= levMax; lev++) { if(!checkLocExistFloor1(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 = "YZ" + locRow + locBay + locLev + "F" + floor; loc.setLocNo(locNo); loc.setLocSts("O"); loc.setRow1(row); loc.setBay1(bay); loc.setLev1(lev); loc.setFloor(floor); loc.setModiTime(now); loc.setFirstTime(now); loc.setAppeTime(now); loc.setLocType1((short)3); // loc.setLocType1(initLocMastSts3(row,bay)); agvLocMastList.add(loc); } } } return agvLocMastList; } private boolean checkLocExistFloor1(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 public List queryFreeLocMast2(Short locType1, Integer rowBeg, Integer rowEnd, Integer bayBeg, Integer bayEnd, Integer levBeg, Integer levEnd) { return this.baseMapper.queryFreeLocMast2(locType1, rowBeg, rowEnd, bayBeg, bayEnd, levBeg, levEnd); } @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()); } 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 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); } public List queryGroupEmptyStock(int floor) { return this.baseMapper.queryGroupEmptyStock(floor); } public List selectLocByLevAndFloor(int lev, int floor) { List agvLocMastList = this.selectList(new EntityWrapper().eq("lev1", lev).eq("floor", floor)); return agvLocMastList; //return this.agvLocMastMapper.selectLocByLevAndFloor(lev,floor); } @Override public AgvLocMast selectEmptyZpallet(int type, int floor) { return this.selectOne(new EntityWrapper().eq("loc_sts","D").eq("loc_type2",type).eq("floor",floor)); } @Override public AgvLocMast selectEmptyZpalletByLocType1(int type) { return this.selectOne(new EntityWrapper().eq("loc_sts","D").eq("loc_type1",type)); } @Override public List queryContainerTypeByLocType1(Short locType1) { return this.baseMapper.queryContainerTypeByLocType1(locType1); } }