| | |
| | | |
| | | // 入成品库摆放规则 判断可用堆垛机自动-无报警 按层列排顺序从下往上,从前往后排 先深库位在浅库位 最上面一层只能放208L桶(剩余库位达到一个阈值208L就先从最上面开始放,下面留给其他货物-后续优化) |
| | | |
| | | List<BasCrnp> basCrnps = basCrnpService.selectList(new EntityWrapper<BasCrnp>().eq("crn_sts", 3).eq("crn_err", 0).in("crn_no",1,2,3).eq("in_enable","Y")); |
| | | List<BasCrnp> basCrnps = basCrnpService.selectList(new EntityWrapper<BasCrnp>().eq("crn_sts", 3).eq("crn_err", 0).in("crn_no",1,2,3) |
| | | .eq("in_enable","Y").orderBy("crn_no",false)); |
| | | if (basCrnps.size() == 0) { |
| | | log.error("入库请求库位失败,没有联机堆垛机或堆垛机异常"); |
| | | throw new CoolException("入库请求库位失败,没有联机堆垛机或堆垛机异常"); |
| | |
| | | LocMast locMast; |
| | | |
| | | // 先找浅库位 |
| | | locMast = locMastMapper.queryLocMasterByLocStsAndRow(Arrays.asList(2, 3), type); |
| | | locMast = locMastMapper.queryLocMasterByLocStsAndRow(Arrays.asList(2,3,5,6,7,8), type); |
| | | |
| | | // 浅库位没有则查询所有 |
| | | if (locMast == null) { |
| | |
| | | #{item} |
| | | </foreach> |
| | | </if> |
| | | order by |
| | | lev1,bay1,row1 |
| | | order by alm.crn_no desc,lev1,bay1,row1 |
| | | </select> |
| | | |
| | | </mapper> |