| | |
|---|
| | | |
|---|
| | | @Override |
|---|
| | | public PageDTO<ManagementimgSlVolumeProductionCkVO> getManagementimgSlVolumeProductionCkList(SlGoodsMaterialsSlVolumeProductionRkQuery slGoodsMaterialsSlVolumeProductionRkQuery) { |
|---|
| | | QueryWrapper<SlVolumeProductionRk> notNull = new QueryWrapper<SlVolumeProductionRk>() |
|---|
| | | |
|---|
| | | .eq("del_flag", "0") |
|---|
| | | .isNotNull("new_add_time"); |
|---|
| | | if (slGoodsMaterialsSlVolumeProductionRkQuery.getId()!=null){ |
|---|
| | | notNull.eq("management_id", slGoodsMaterialsSlVolumeProductionRkQuery.getId()); |
|---|
| | | } |
|---|
| | | |
|---|
| | | // 查询该仓库的入库记录 |
|---|
| | | List<Long> collect = slVolumeProductionRkMapper.selectList(notNull |
|---|
| | | ).stream().map(SlVolumeProductionRk::getId).collect(Collectors.toList()); |
|---|
| | | Page<SlVolumeProductionCk> page = new Page<>(slGoodsMaterialsSlVolumeProductionRkQuery.getPageCurr(), slGoodsMaterialsSlVolumeProductionRkQuery.getPageSize()); |
|---|
| | | LambdaQueryWrapper< SlVolumeProductionCk> wrapper1= Wrappers.lambdaQuery(); |
|---|
| | | wrapper1.like(SlVolumeProductionCk::getMaterialsId,slGoodsMaterialsSlVolumeProductionRkQuery.getSlGoodsMaterialsid()); |
|---|
| | | wrapper1.eq( SlVolumeProductionCk::getDelFlag,0); |
|---|
| | | |
|---|
| | | wrapper1.eq(SlVolumeProductionCk::getMaterialsId,slGoodsMaterialsSlVolumeProductionRkQuery.getSlGoodsMaterialsid()); |
|---|
| | | wrapper1.eq(SlVolumeProductionCk::getDelFlag,0); |
|---|
| | | wrapper1.orderByDesc(SlVolumeProductionCk::getCreateTime); |
|---|
| | | if (!collect.isEmpty()){ |
|---|
| | | wrapper1.in(SlVolumeProductionCk::getRkId,collect); |
|---|
| | | } |
|---|
| | | Page<SlVolumeProductionCk> page2 = this.page(page, wrapper1); |
|---|
| | | PageDTO<ManagementimgSlVolumeProductionCkVO> SlGoodsShelfDTO = PageDTO.of(page2, ManagementimgSlVolumeProductionCkVO.class); |
|---|
| | | List<ManagementimgSlVolumeProductionCkVO> list2 = SlGoodsShelfDTO.getList(); |
|---|
| | |
|---|
| | | wrapper.in("materials_id",collect1); |
|---|
| | | wrapper.eq("management_id",query.getManagementId()); |
|---|
| | | wrapper.eq("del_flag","0"); |
|---|
| | | wrapper.isNotNull("new_add_time"); |
|---|
| | | |
|---|
| | | Page<SlVolumeProductionRk> page2 = slVolumeProductionRkService.page(page, wrapper); |
|---|
| | | List<SlVolumeProductionRk> list = page2.getRecords(); |
|---|
