| | |
| | | import org.springframework.stereotype.Service; |
| | | |
| | | import javax.annotation.Resource; |
| | | import java.util.HashSet; |
| | | import java.util.List; |
| | | import java.util.Set; |
| | | import java.util.stream.Collectors; |
| | |
| | | @Override |
| | | public PageDTO<ManagementGoodsMaterialsVO> getManagementGoodsMaterialsList(ManagementGoodsMaterialsQuery managementGoodsMaterialsQuery) { |
| | | LambdaQueryWrapper<SlStoreManagement> wrapper= Wrappers.lambdaQuery(); |
| | | if (managementGoodsMaterialsQuery.getStoreManagementName()!=null){ |
| | | if (managementGoodsMaterialsQuery.getStoreManagementName()!=null&&managementGoodsMaterialsQuery.getStoreManagementName()!=""){ |
| | | wrapper.like(SlStoreManagement::getStoreManagementName,managementGoodsMaterialsQuery.getStoreManagementName()); |
| | | } |
| | | if (managementGoodsMaterialsQuery.getStoreManagementNo()!=null){ |
| | | if (managementGoodsMaterialsQuery.getStoreManagementNo()!=null&&managementGoodsMaterialsQuery.getStoreManagementNo()!=""){ |
| | | wrapper.eq(SlStoreManagement::getStoreManagementNo,managementGoodsMaterialsQuery.getStoreManagementNo()); |
| | | } |
| | | if (managementGoodsMaterialsQuery.getCityCode()!=null){ |
| | | if (managementGoodsMaterialsQuery.getCityCode()!=null&&managementGoodsMaterialsQuery.getCityCode()!=""){ |
| | | wrapper.eq(SlStoreManagement::getCityCode,managementGoodsMaterialsQuery.getCityCode()); |
| | | } |
| | | if (managementGoodsMaterialsQuery.getCountyCode()!=null){ |
| | | if (managementGoodsMaterialsQuery.getCountyCode()!=null&&managementGoodsMaterialsQuery.getCountyCode()!=""){ |
| | | wrapper.eq(SlStoreManagement::getCountyCode,managementGoodsMaterialsQuery.getCountyCode()); |
| | | } |
| | | if (managementGoodsMaterialsQuery.getTownCode()!=null){ |
| | | if (managementGoodsMaterialsQuery.getTownCode()!=null&&managementGoodsMaterialsQuery.getTownCode()!=""){ |
| | | wrapper.eq(SlStoreManagement::getTownCode,managementGoodsMaterialsQuery.getTownCode()); |
| | | } |
| | | List<SlStoreManagement> slStoreManagements = slStoreManagementMapper.selectList(wrapper); |
| | |
| | | .collect(Collectors.toSet()); |
| | | |
| | | LambdaQueryWrapper<SlGoodsMaterials> wrapper1= Wrappers.lambdaQuery(); |
| | | if (managementGoodsMaterialsQuery.getGoodsMaterialsName()!=null){ |
| | | if (managementGoodsMaterialsQuery.getGoodsMaterialsName()!=null&&managementGoodsMaterialsQuery.getGoodsMaterialsName()!=""){ |
| | | wrapper1.like(SlGoodsMaterials::getGoodsMaterialsName,managementGoodsMaterialsQuery.getGoodsMaterialsName()); |
| | | } |
| | | |
| | |
| | | |
| | | if (slVolumeProductionIdList.size()>0){ |
| | | wrapper3.in(ManagementGoodsMaterials::getManagementId,slVolumeProductionIdList); |
| | | }else{ |
| | | slVolumeProductionIdList=new HashSet<>(); |
| | | slVolumeProductionIdList.add(0L); |
| | | wrapper3.in(ManagementGoodsMaterials::getGoodsMaterialsId,slVolumeProductionIdList); |
| | | } |
| | | if (SlGoodsMaterialsList.size()>0){ |
| | | wrapper3.in(ManagementGoodsMaterials::getGoodsMaterialsId,SlGoodsMaterialsList); |
| | | }else{ |
| | | SlGoodsMaterialsList=new HashSet<>(); |
| | | SlGoodsMaterialsList.add(0L); |
| | | wrapper3.in(ManagementGoodsMaterials::getGoodsMaterialsId,SlGoodsMaterialsList); |
| | | } |
| | | wrapper3.apply("repertory_zhai<repertory"); |
| | | wrapper3.eq( ManagementGoodsMaterials::getDelFlag,0); |