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() { //1楼 13排 86列 12层 List agvLocMastList = getLocMastList(1,13,1,86,1,12,1); this.insertBatch(agvLocMastList); } 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)); } //根据排列层获取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(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; } } 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; 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); agvLocMastList.add(loc); } } } return agvLocMastList; } @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) { AgvLocMast agvLocMast = this.selectById(locNo); agvLocMast.setLocSts(locSts); 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); } }