| | |
| | | |
| | | import com.baomidou.mybatisplus.mapper.EntityWrapper; |
| | | import com.baomidou.mybatisplus.mapper.Wrapper; |
| | | import com.baomidou.mybatisplus.plugins.Page; |
| | | import com.baomidou.mybatisplus.service.impl.ServiceImpl; |
| | | import com.core.common.Cools; |
| | | import com.zy.asrs.entity.AgvLocDetl; |
| | |
| | | |
| | | } |
| | | |
| | | /* |
| | | 更新库存明细 |
| | | */ |
| | | public void updateStock(String sourceLoc, String targetLoc) { |
| | | this.baseMapper.updateStock(sourceLoc,targetLoc); |
| | | } |
| | | |
| | | public Page<AgvLocDetl> getStockStatis(Page<AgvLocDetl> page) { |
| | | page.setRecords(baseMapper.getStockStatis(page.getCondition())); |
| | | page.setTotal(baseMapper.getStockStatisCount(page.getCondition())); |
| | | return page; |
| | | } |
| | | |
| | | /* |
| | | 获取库存总数 |
| | | */ |
| | | public Integer sum() { |
| | | return this.baseMapper.sum(); |
| | | } |
| | | |
| | | public List<AgvLocDetl> getStockStatisExcel(){ |
| | | return this.baseMapper.getStockStatisExcel(); |
| | | } |
| | | |
| | | public List<AgvLocDetl> searchByLike(String orderNo, String matnr, String maktx, String specs, String locNo) { |
| | | if (Cools.isEmpty(orderNo) && Cools.isEmpty(matnr) && Cools.isEmpty(maktx) && Cools.isEmpty(specs) && Cools.isEmpty(locNo)) { |
| | | return new ArrayList<AgvLocDetl>(); |
| | | } |
| | | EntityWrapper<AgvLocDetl> wrapper = new EntityWrapper<>(); |
| | | if(Cools.isEmpty(orderNo)){ |
| | | wrapper.like("order_no",orderNo); |
| | | } |
| | | if(Cools.isEmpty(matnr)){ |
| | | wrapper.like("matnr",matnr); |
| | | } |
| | | if(Cools.isEmpty(maktx)){ |
| | | wrapper.like("maktx",maktx); |
| | | } |
| | | if(Cools.isEmpty(specs)){ |
| | | wrapper.like("specs",specs); |
| | | } |
| | | if(Cools.isEmpty()){ |
| | | wrapper.like("loc_no",locNo); |
| | | } |
| | | return this.selectList(wrapper); |
| | | } |
| | | |
| | | private List<String> queryAgvStaNosByFloor(int floor){ |
| | | List<String> agvStaNos = new ArrayList<>(); |
| | | if(floor == 1){ |