excel导出优化

zhangchao

2024-11-04 59f80df1e377e8775969ca4acadfa2eadd6e37ae

 src/main/java/com/zy/asrs/service/impl/LocRuleServiceImpl.java

@@ -1,20 +1,20 @@
package com.zy.asrs.service.impl;

import com.baomidou.mybatisplus.mapper.EntityWrapper;
import com.baomidou.mybatisplus.mapper.Wrapper;
import com.baomidou.mybatisplus.service.impl.ServiceImpl;
import com.core.common.Cools;
import com.zy.asrs.entity.LocMast;
import com.zy.asrs.entity.LocRule;
import com.zy.asrs.entity.Mat;
import com.zy.asrs.mapper.LocRuleMapper;
import com.zy.asrs.entity.LocRule;
import com.zy.asrs.service.LocMastService;
import com.zy.asrs.service.LocRuleService;
import com.baomidou.mybatisplus.service.impl.ServiceImpl;
import com.zy.asrs.service.MatService;
import com.zy.asrs.utils.Utils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.ArrayList;
import java.util.List;

@Service("locRuleService")
@@ -38,6 +38,30 @@
        return this.baseMapper.selectByMatnr(matnr);
    }

    @Override
    public List<LocRule> findCode(String matnr,String other) {
        if (Cools.isEmpty(matnr)) {
            return null;
        }
        Mat mat = matService.selectByMatnr(matnr);
        if (Cools.isEmpty(mat)) {
            return null;
        }
        if(Cools.isEmpty(mat.getBrand())){
            return null;
        }

        Wrapper<LocRule> wrapper = new EntityWrapper<LocRule>()
                .eq("matnr",mat.getBrand().substring(0,4))
                .eq("mixed",0)
                .eq("status",1);

        Utils.wapperSetCondition(wrapper,"other",other);

        return this.selectList(wrapper);

    }

    //找混载库位规则
    @Override
    public List<LocRule> findMixed() {