| | |
| | | @Override |
| | | public PageDTO<InventoriesSuppliesVO> getInventoriesSuppliesList(InventoriesSuppliesQuery inventoriesSuppliesQuery) { |
| | | LambdaQueryWrapper<SlStoreManagement> wrapper= Wrappers.lambdaQuery(); |
| | | if (inventoriesSuppliesQuery.getStoreManagementName()!=null){ |
| | | if (inventoriesSuppliesQuery.getStoreManagementName()!=null&&inventoriesSuppliesQuery.getStoreManagementName()!=""){ |
| | | wrapper.eq(SlStoreManagement::getStoreManagementName,inventoriesSuppliesQuery.getStoreManagementName()); |
| | | } |
| | | if (inventoriesSuppliesQuery.getStoreManagementNo()!=null){ |
| | | if (inventoriesSuppliesQuery.getStoreManagementNo()!=null&&inventoriesSuppliesQuery.getStoreManagementNo()!=""){ |
| | | wrapper.eq(SlStoreManagement::getStoreManagementNo,inventoriesSuppliesQuery.getStoreManagementNo()); |
| | | } |
| | | List<SlStoreManagement> slStoreManagements = slStoreManagementMapper.selectList(wrapper); |
| | |
| | | |
| | | Page<InventoriesSupplies> page = new Page<>(inventoriesSuppliesQuery.getPageCurr(), inventoriesSuppliesQuery.getPageSize()); |
| | | LambdaQueryWrapper< InventoriesSupplies> wrapper1= Wrappers.lambdaQuery(); |
| | | wrapper1.like(InventoriesSupplies::getPdrName,inventoriesSuppliesQuery.getPdrName()); |
| | | if (inventoriesSuppliesQuery.getPdrName()!=null&&inventoriesSuppliesQuery.getPdrName()!=""){ |
| | | wrapper1.like(InventoriesSupplies::getPdrName,inventoriesSuppliesQuery.getPdrName()); |
| | | } |
| | | if (slStoreManagementIdList.size()>0){ |
| | | wrapper1.in(InventoriesSupplies::getMaterialsId,slStoreManagementIdList); |
| | | }else { |
| | |
| | | |
| | | wrapper1.gt(InventoriesSupplies::getPdTime, inventoriesSuppliesQuery.getStartpdTime()); |
| | | } |
| | | if (inventoriesSuppliesQuery.getEndpdTime()!=null){ |
| | | if (inventoriesSuppliesQuery.getEndpdTime()!=null&&inventoriesSuppliesQuery.getPdrName()!=""){ |
| | | wrapper1.le(InventoriesSupplies::getPdTime, inventoriesSuppliesQuery.getEndpdTime()); |
| | | } |
| | | |