自动化立体仓库 - WMS系统
blame | 历史 | 补丁 | 提交 | 提交对比 | ignore whitespace
luxiaotao1123
2022-03-26 580a85c33e14a7d83d63de555bafc943547015f8 
 src/main/java/com/zy/asrs/controller/OpenController.java


@@ -1,6 +1,7 @@


package com.zy.asrs.controller;




import com.baomidou.mybatisplus.mapper.EntityWrapper;


import com.core.annotations.ManagerAuth;


import com.core.common.Cools;


import com.core.common.R;


import com.core.exception.CoolException;


@@ -14,15 +15,11 @@


import com.zy.asrs.service.*;


import com.zy.common.model.LocDetlDto;


import org.springframework.beans.factory.annotation.Autowired;


import org.springframework.jdbc.core.JdbcTemplate;


import org.springframework.transaction.annotation.Transactional;


import org.springframework.web.bind.annotation.PostMapping;


import org.springframework.web.bind.annotation.RequestBody;


import org.springframework.web.bind.annotation.RequestMapping;


import org.springframework.web.bind.annotation.RestController;


import org.springframework.web.bind.annotation.*;




import java.util.ArrayList;


import java.util.List;


import java.util.Optional;


import java.util.*;




/**


 * Created by vincent on 2021/3/19


@@ -31,6 +28,7 @@


@RequestMapping("/open/api")


public class OpenController {




    private boolean pickSite = false;


    @Autowired


    private LocDetlService locDetlService;


    @Autowired


@@ -41,6 +39,8 @@


    private BasDevpService basDevpService;


    @Autowired


    private WrkMastService wrkMastService;


    @Autowired


    private JdbcTemplate jdbcTemplate;




    @PostMapping("/stockOut/prew")


    @Transactional


@@ -118,6 +118,9 @@


                    throw new CoolException("当前补仓任务正在执行，请耐心等待");


                }


                Double sumAnfme = Optional.ofNullable(locDetlService.getSumAnfme(param.getMatnr())).orElse(0.0D);


                if (!Cools.isEmpty(param.getAllotNo()) && sumAnfme < param.getAnfme()) {


                    throw new CoolException("立库库存不足，缺货数量：" + (param.getAnfme() - sumAnfme));


                }


                double lack = 0.0D;


                if (sumAnfme < param.getAnfme()) {


                    lack = param.getAnfme() - sumAnfme;


@@ -137,6 +140,8 @@


                    if (issued > 0) {


                        // 生成出库工作档




                        int priorCount = jdbcTemplate.queryForObject("select isnull(count(*),0) from man_prior where 1=1 and matnr = '" + param.getMatnr() + "'", Integer.class);




                        // 全板


                        if (issued>=locDetl.getAnfme()) {


                            BasDevp staNo = basDevpService.checkSiteStatus(103);


@@ -145,16 +150,28 @@


                            dto.setLocDetl(locDetl);


                            dto.setCount(issued>=locDetl.getAnfme()?locDetl.getAnfme():issued);


                            detlDtos.add(dto);


                            workService.stockOut(staNo, detlDtos, 101, 9527L, param.getAllotNo());


                            workService.stockOut(staNo, detlDtos, 101, 9527L, param.getAllotNo(), Cools.isEmpty(param.getAllotNo()), null);


                        // 拣料


                        } else {


                            BasDevp staNo = basDevpService.checkSiteStatus(107);


                            List<LocDetlDto> detlDtos = new ArrayList<>();


                            LocDetlDto dto = new LocDetlDto();


                            dto.setLocDetl(locDetl);


                            dto.setCount(issued>=locDetl.getAnfme()?locDetl.getAnfme():issued);


                            detlDtos.add(dto);


                            workService.stockOut(staNo, detlDtos, 103, 9527L, param.getAllotNo());




                            if (priorCount > 0) {


                                BasDevp staNo = basDevpService.checkSiteStatus(103);


                                List<LocDetlDto> detlDtos = new ArrayList<>();


                                LocDetlDto dto = new LocDetlDto();


                                dto.setLocDetl(locDetl);


                                dto.setCount(locDetl.getAnfme());


                                detlDtos.add(dto);


                                workService.stockOut(staNo, detlDtos, 101, 9527L, param.getAllotNo(), Cools.isEmpty(param.getAllotNo()), locDetl.getAnfme()-issued);


                            } else {


                                BasDevp staNo = basDevpService.checkSiteStatus(pickSite?113:109);


                                List<LocDetlDto> detlDtos = new ArrayList<>();


                                LocDetlDto dto = new LocDetlDto();


                                dto.setLocDetl(locDetl);


                                dto.setCount(issued>=locDetl.getAnfme()?locDetl.getAnfme():issued);


                                detlDtos.add(dto);


                                workService.stockOut(staNo, detlDtos, 103, 9527L, param.getAllotNo(), Cools.isEmpty(param.getAllotNo()), null);


                            }




                        }




                        PakoutVo pakoutVo = new PakoutVo();


@@ -171,9 +188,107 @@




            }


        }




        pickSite = !pickSite;


        return R.ok().add(result);


    }




    @PostMapping("/available/take/site")


    @Transactional


    public R availableTakeSite(){


        List<Map<String, Object>> result = new ArrayList<>();


        List<Integer> outSite = basDevpService.getAvailableOutSite(101);


        for (Integer siteId : outSite) {


            Map<String, Object> map = new HashMap<>();


            map.put("siteId", siteId);


            map.put("desc", siteId + "（全板出库口）");


            result.add(map);


        }


        List<Integer> pickOutSite = basDevpService.getAvailableOutSite(103);


        for (Integer siteId : pickOutSite) {


            Map<String, Object> map = new HashMap<>();


            map.put("siteId", siteId);


            map.put("desc", siteId + "（拣料出库口）");


            result.add(map);


        }


        return R.ok().add(result);


    }




    @PostMapping("/get/asrsLocDetl")


    @Transactional


    public R queryLocDetl(String matnr) {


        List<LocDetl> locDetls = locDetlService.getAsrsLocDetl(matnr);


        return R.ok().add(locDetls);


    }




    @PostMapping("/stockOut/locMode")


    @Transactional


    public R stockOutLocMode(@RequestBody List<OpenApiStockOutParam> params){


        List<PakoutVo> result = new ArrayList<>();


        if (!Cools.isEmpty(params)) {


            for (OpenApiStockOutParam param : params) {


                // 推荐货位补仓工作档防重


                if (wrkMastService.selectCount(new EntityWrapper<WrkMast>().eq("packed", param.getAllotNo()).le("wrk_sts", 14)) > 0) {


                    throw new CoolException("当前补仓任务正在执行，请耐心等待");


                }


                Double sumAnfme = Optional.ofNullable(locDetlService.getSumAnfme(param.getMatnr())).orElse(0.0D);


                if (!Cools.isEmpty(param.getAllotNo()) && sumAnfme < param.getAnfme()) {


                    throw new CoolException("立库库存不足，缺货数量：" + (param.getAnfme() - sumAnfme));


                }


                double lack = 0.0D;


                if (sumAnfme < param.getAnfme()) {


                    lack = param.getAnfme() - sumAnfme;


                    PakoutVo pakoutVo = new PakoutVo();


                    pakoutVo.setLocNo("缺货");


                    pakoutVo.setAnfme(lack);


                    pakoutVo.setMatnr(param.getMatnr());


//                    pakoutVo.setZpallet("param.getZpallet()");


                    result.add(pakoutVo);




//                    throw new CoolException(param.getMatnr() + "物料数量不足，缺货数量：" + (param.getAnfme() - sumAnfme));


                }




                // 根据立库库位码去获取立库信息


                List<LocDetl> locDetls = locDetlService.selectList(new EntityWrapper<LocDetl>().eq("loc_no", param.getLocNo()));


                if (locDetls.size() == 0) {


                    throw new CoolException("未查询到库位信息！");


                }


                double issued = Optional.of(param.getAnfme()-lack).orElse(0.0D) ;


                for (LocDetl locDetl : locDetls) {


                    // 生成出库工作档




                    Integer locNoNum = locDetlService.countLocNoNum(locDetl.getLocNo());


                    // 全板


                    if (locNoNum == 1) {


                        BasDevp staNo = basDevpService.checkSiteStatus(103);


                        List<LocDetlDto> detlDtos = new ArrayList<>();


                        LocDetlDto dto = new LocDetlDto();


                        dto.setLocDetl(locDetl);


                        dto.setCount(issued>=locDetl.getAnfme()?locDetl.getAnfme():issued);


                        detlDtos.add(dto);


                        workService.stockOut(staNo, detlDtos, 101, 9527L, param.getAllotNo(), Cools.isEmpty(param.getAllotNo()), null);


                    } else { // 拣料


                        BasDevp staNo = basDevpService.checkSiteStatus(107);


                        List<LocDetlDto> detlDtos = new ArrayList<>();


                        LocDetlDto dto = new LocDetlDto();


                        dto.setLocDetl(locDetl);


                        dto.setCount(issued>=locDetl.getAnfme()?locDetl.getAnfme():issued);


                        detlDtos.add(dto);


                        workService.stockOut(staNo, detlDtos, 103, 9527L, param.getAllotNo(), Cools.isEmpty(param.getAllotNo()), null);


                    }


                    PakoutVo pakoutVo = new PakoutVo();


                    pakoutVo.setLocNo(locDetl.getLocNo());


                    pakoutVo.setAnfme(issued>=locDetl.getAnfme()?locDetl.getAnfme():issued);


                    pakoutVo.setMatnr(locDetl.getMatnr());


                    pakoutVo.setZpallet(locDetl.getZpallet());


                    result.add(pakoutVo);




                    // 剩余待出数量递减


                    issued = issued - locDetl.getAnfme();


                }




            }


        }




        return R.ok().add(result);


    }


}