根据入库单与销售单查询库存

zyx

2024-04-11 4dbb96434dceef64f00cc118853e131b04bf6ba1

根据入库单与销售单查询库存

 src/main/java/com/zy/asrs/controller/AgvMobileController.java

@@ -1,7 +1,11 @@
package com.zy.asrs.controller;

import com.baomidou.mybatisplus.mapper.EntityWrapper;
import com.baomidou.mybatisplus.mapper.Wrapper;
import com.core.common.Cools;
import com.core.common.R;
import com.zy.asrs.entity.AgvBasDevp;
import com.zy.asrs.entity.AgvLocDetl;
import com.zy.asrs.entity.param.AgvMobileStartPakin;
import com.zy.asrs.entity.param.AgvMobileStartParam;
import com.zy.asrs.entity.param.CombParam;
@@ -38,6 +42,8 @@
    private AgvLocMastService agvLocMastService;
    @Autowired
    private OrderDetlService orderDetlService;
    @Autowired
    private AgvLocDetlService agvLocDetlService;


    /*
@@ -157,6 +163,24 @@
        return R.ok(agvLocMastService.queryContainerTypeByLocType1(agvBasDevp.getLocType1()));

    }
    
    /*
    查询库存 入库订单与销售单号
     */
    @PostMapping("/query/locDetl/v1")
    public R queryAgvLocDetl(@RequestBody HashMap<String,String> params){

        String orderNo = params.get("orderNo");
        String threeCode = params.get("threeCode");

        Wrapper<AgvLocDetl> wrapper = new EntityWrapper<AgvLocDetl>().eq("order_no", orderNo);

        wrapper = Cools.isEmpty(threeCode) ? wrapper.isNull("three_code") : wrapper.eq("three_code",threeCode);

        List<AgvLocDetl> agvLocDetls = agvLocDetlService.selectList(wrapper);

        return R.ok(agvLocDetls);
    }


}