自动补货

zyx

2023-11-23 cb68c3e4547653ee7d308aa4da51f31363647a0f

 src/main/java/com/zy/asrs/task/AutoReplenishmentScheduler.java

@@ -3,12 +3,10 @@
import com.baomidou.mybatisplus.mapper.EntityWrapper;
import com.core.common.Cools;
import com.zy.asrs.entity.DocType;
import com.zy.asrs.entity.LocDetl;
import com.zy.asrs.entity.Mat;
import com.zy.asrs.entity.Order;
import com.zy.asrs.service.AgvLocDetlService;
import com.zy.asrs.service.DocTypeService;
import com.zy.asrs.service.MatService;
import com.zy.asrs.service.OrderService;
import com.zy.asrs.service.*;
import com.zy.asrs.task.handler.AutoReplenishmentHandler;
import lombok.extern.slf4j.Slf4j;
import org.springframework.beans.factory.annotation.Autowired;
@@ -31,28 +29,38 @@
    private MatService matService;
    @Autowired
    private AgvLocDetlService agvLocDetlService;
    @Autowired
    private LocDetlService locDetlService;

    /*
    定时便利库存，生成自动补货单据
     */
    //@Scheduled(cron = "0/5 * * * * ? ")
    @Scheduled(cron = "0/5 * * * * ? ")
    public void createOrder(){
        //检测是否有未完成的补货单据
        DocType docType = docTypeService.selectOne(new EntityWrapper<DocType>().eq("doc_name", "自动补货单"));
        int count = orderService.selectCount(new EntityWrapper<Order>()
                .eq("doc_type", docType.getDocId())
                .andNew().eq("settle",2)
                .or("settle",1));
                .or().eq("settle",1));
        if(count > 0){
            return;
        }

        //查询所有需要补货的物料
        List<Mat> matList = matService.selectList(new EntityWrapper<Mat>().eq(false, "store_min", 0));
        List<Mat> matList = matService.selectList(new EntityWrapper<Mat>().gt( "store_min", 0));
        if(!Cools.isEmpty(matList)){
            for (Mat mat : matList){
                //查询当前物料是否在agv库小于库存上限
                Double anfmeSum = agvLocDetlService.selectSumAnfmeByMatnr(mat.getMatnr());
                if(Cools.isEmpty(anfmeSum)){
                    anfmeSum = 0.0;
                }
                //查询当前物料四项库是否存在
                if(Cools.isEmpty(locDetlService.selectOne(new EntityWrapper<LocDetl>().eq("matnr", mat.getMatnr())))){
                    continue;
                }

                if(anfmeSum < mat.getStoreMin()){
                    autoReplenishmentHandler.create(mat,mat.getStoreMax() - anfmeSum);
                    break;