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;
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<AgvLocMastMapper, AgvLocMast> implements AgvLocMastService {

    @Autowired
    AgvLocMastMapper agvLocMastMapper;

    public void clearLoc() {
        agvLocMastMapper.deleteAll();
    }

    public void initLocFloor1() {
        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() {
        //2楼 1-25排 1-33列 1层
        this.insertBatch(getLocMastList(1, 26, 1, 34, 1, 1, 3));
    }

    //根据排列层获取AGV库位列表
    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 bay = bayIndex; bay <= bayMax; bay++) {
                for (int lev = levIndex; lev <= levMax; lev++) {

                    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 = "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_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
    public List<AgvLocMast> 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 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);
    }

    public List<String> queryGroupEmptyStock(int floor) {
        return this.baseMapper.queryGroupEmptyStock(floor);
    }

    public List<AgvLocMast> selectLocByLevAndFloor(int lev, int floor) {

        List<AgvLocMast> agvLocMastList = this.selectList(new EntityWrapper<AgvLocMast>().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<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);
    }

}