| | |
| | | import com.baomidou.mybatisplus.core.toolkit.Wrappers; |
| | | import com.baomidou.mybatisplus.extension.plugins.pagination.Page; |
| | | import com.ruoyi.common.core.utils.page.PageDTO; |
| | | import com.ruoyi.management.domain.ManagementGoodsMaterials; |
| | | import com.ruoyi.management.domain.SlStoreManagement; |
| | | |
| | | |
| | |
| | | import com.ruoyi.management.domain.dto.StoreManagementQuery; |
| | | import com.ruoyi.management.domain.vo.SlGoodsShelfVO; |
| | | import com.ruoyi.management.domain.vo.SlStoreManagementInventoryVO; |
| | | import com.ruoyi.management.mapper.ManagementGoodsMaterialsMapper; |
| | | import com.ruoyi.management.mapper.SlStoreManagementMapper; |
| | | import com.ruoyi.management.mapper.SlVolumeProductionRkMapper; |
| | | import com.ruoyi.management.mapper.SlVolumeProductionRkglMapper; |
| | |
| | | import org.springframework.stereotype.Service; |
| | | |
| | | import javax.annotation.Resource; |
| | | import java.util.ArrayList; |
| | | import java.util.List; |
| | | |
| | | /** |
| | |
| | | public class SlStoreManagementServiceImpl extends ServiceImpl<SlStoreManagementMapper, SlStoreManagement> implements SlStoreManagementService { |
| | | |
| | | @Resource |
| | | private SlVolumeProductionRkMapper SlVolumeProductionRkMapper; |
| | | private ManagementGoodsMaterialsMapper managementGoodsMaterialsMapper; |
| | | |
| | | @Override |
| | | public PageDTO<SlStoreManagement> getStoreManagementList(StoreManagementQuery storeManagementQuery) { |
| | |
| | | if(storeManagementQuery.getStoreManagementNo()!=null&&storeManagementQuery.getStoreManagementNo()!=""){ |
| | | wrapper.eq(SlStoreManagement::getStoreManagementNo,storeManagementQuery.getStoreManagementNo()); |
| | | } |
| | | if (storeManagementQuery.getStoreManagementGrade()!=0 && storeManagementQuery.getStoreManagementGrade()!=null){ |
| | | wrapper.eq(SlStoreManagement::getStoreManagementGrade,storeManagementQuery.getStoreManagementGrade()); |
| | | |
| | | if ( storeManagementQuery.getStoreManagementGrade()!=null &&!storeManagementQuery.getStoreManagementGrade().equals("0") ){ |
| | | String[] split = storeManagementQuery.getStoreManagementGrade().split(","); |
| | | List<Integer> arr=new ArrayList<>(); |
| | | for(int i=0;i<split.length;i++){ |
| | | arr.add(Integer.valueOf(split[i])); |
| | | } |
| | | wrapper.in(SlStoreManagement::getStoreManagementGrade,arr); |
| | | } |
| | | |
| | | wrapper.eq( SlStoreManagement::getDelFlag,0); |
| | | wrapper.orderByDesc(SlStoreManagement::getCreateTime); |
| | | Page<SlStoreManagement> page1 = this.page(page, wrapper); |
| | |
| | | |
| | | Page<SlStoreManagement> page = new Page<>(storeManagementQuery.getPageCurr(), storeManagementQuery.getPageSize()); |
| | | LambdaQueryWrapper< SlStoreManagement> wrapper= Wrappers.lambdaQuery(); |
| | | if (storeManagementQuery.getStoreManagementName()!=null){ |
| | | wrapper.eq(SlStoreManagement::getStoreManagementName,storeManagementQuery.getStoreManagementName()); |
| | | } |
| | | if (storeManagementQuery.getStoreManagementNo()!=null){ |
| | | wrapper.eq(SlStoreManagement::getStoreManagementNo,storeManagementQuery.getStoreManagementNo()); |
| | | if (storeManagementQuery.getStoreManagementGrade()!=0 && storeManagementQuery.getStoreManagementGrade()!=null){ |
| | | wrapper.eq(SlStoreManagement::getStoreManagementGrade,storeManagementQuery.getStoreManagementGrade()); |
| | | } |
| | | |
| | | if ( storeManagementQuery.getStoreManagementGrade()!=null&&!storeManagementQuery.getStoreManagementGrade().equals("0")){ |
| | | String[] split = storeManagementQuery.getStoreManagementGrade().split(","); |
| | | List<Integer> arr=new ArrayList<>(); |
| | | for(int i=0;i<split.length;i++){ |
| | | arr.add(Integer.valueOf(split[i])); |
| | | } |
| | | wrapper.in(SlStoreManagement::getStoreManagementGrade,arr); |
| | | } |
| | | wrapper.eq( SlStoreManagement::getDelFlag,0); |
| | | wrapper.orderByDesc(SlStoreManagement::getCreateTime); |
| | |
| | | PageDTO<SlStoreManagementInventoryVO> InventoryVO = PageDTO.of(page1, SlStoreManagementInventoryVO.class); |
| | | List<SlStoreManagementInventoryVO> list2 = InventoryVO.getList(); |
| | | for(SlStoreManagementInventoryVO list:list2){ |
| | | Integer managementInventoryList = SlVolumeProductionRkMapper.getManagementInventoryList(list.getId()); |
| | | list.setGoodsMaterialsNum(managementInventoryList); |
| | | LambdaQueryWrapper<ManagementGoodsMaterials> wrapper1= Wrappers.lambdaQuery(); |
| | | |
| | | wrapper1.eq(ManagementGoodsMaterials::getManagementId,list.getId()); |
| | | List<ManagementGoodsMaterials> managementGoodsMaterials = managementGoodsMaterialsMapper.selectList(wrapper1); |
| | | list.setGoodsMaterialsNum(managementGoodsMaterials.size()); |
| | | |
| | | } |
| | | return InventoryVO; |