From 837da67d468fbcdd10ee27dcc44a94e7b1130a85 Mon Sep 17 00:00:00 2001 From: rentaiming <806181062@qq.com> Date: 星期二, 30 七月 2024 17:34:28 +0800 Subject: [PATCH] 森林防火 供应商管理 --- ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/service/impl/SlStoreManagementServiceImpl.java | 182 +++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 182 insertions(+), 0 deletions(-) diff --git a/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/service/impl/SlStoreManagementServiceImpl.java b/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/service/impl/SlStoreManagementServiceImpl.java index 8cd6db1..bfd86d5 100644 --- a/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/service/impl/SlStoreManagementServiceImpl.java +++ b/ruoyi-modules/ruoyi-management/src/main/java/com/ruoyi/management/service/impl/SlStoreManagementServiceImpl.java @@ -1,12 +1,30 @@ package com.ruoyi.management.service.impl; +import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; +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.baomidou.mybatisplus.extension.service.impl.ServiceImpl; +import com.ruoyi.management.domain.SlVolumeProductionRk; +import com.ruoyi.management.domain.dto.QStoreManagementQuery; +import com.ruoyi.management.domain.dto.StoreManagementDTO; +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 com.ruoyi.management.service.SlStoreManagementService; import org.springframework.stereotype.Service; + +import javax.annotation.Resource; +import java.util.ArrayList; +import java.util.List; /** * <p> @@ -19,4 +37,168 @@ @Service public class SlStoreManagementServiceImpl extends ServiceImpl<SlStoreManagementMapper, SlStoreManagement> implements SlStoreManagementService { + @Resource + private ManagementGoodsMaterialsMapper managementGoodsMaterialsMapper; + + @Override + public PageDTO<SlStoreManagement> getStoreManagementList(StoreManagementQuery storeManagementQuery) { + Page<SlStoreManagement> page = new Page<>(storeManagementQuery.getPageCurr(), storeManagementQuery.getPageSize()); + LambdaQueryWrapper< SlStoreManagement> wrapper= Wrappers.lambdaQuery(); + if (storeManagementQuery.getStoreManagementName()!=null&&storeManagementQuery.getStoreManagementName()!=""){ + wrapper.eq(SlStoreManagement::getStoreManagementName,storeManagementQuery.getStoreManagementName()); + } + if(storeManagementQuery.getStoreManagementNo()!=null&&storeManagementQuery.getStoreManagementNo()!=""){ + wrapper.eq(SlStoreManagement::getStoreManagementNo,storeManagementQuery.getStoreManagementNo()); + } + + 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); + return PageDTO.of(page1); + } + + @Override + public void addStoreManagement(StoreManagementDTO storeManagementDTO) { + if (storeManagementDTO.getId()==null){ + SlStoreManagement slStoreManagement=new SlStoreManagement(); + slStoreManagement.setStoreManagementNo(storeManagementDTO.getStoreManagementNo()); + slStoreManagement.setStoreManagementAdder(storeManagementDTO.getStoreManagementAdder()); + slStoreManagement.setStoreManagementExplain(storeManagementDTO.getStoreManagementExplain()); + slStoreManagement.setStoreManagementName(storeManagementDTO.getStoreManagementName()); + slStoreManagement.setStoreManagementGrade(storeManagementDTO.getStoreManagementGrade()); + slStoreManagement.setStoreManagementNumber(storeManagementDTO.getStoreManagementNumber()); + slStoreManagement.setAdministratorId(storeManagementDTO.getAdministratorId()); + slStoreManagement.setCompetentId(storeManagementDTO.getCompetentId()); + slStoreManagement.setDirectorId(storeManagementDTO.getDirectorId()); + slStoreManagement.setProvinceName(storeManagementDTO.getProvinceName()); + slStoreManagement.setProvinceCode(storeManagementDTO.getProvinceCode()); + slStoreManagement.setCityName(storeManagementDTO.getCityName()); + slStoreManagement.setCityCode(storeManagementDTO.getCityCode()); + slStoreManagement.setCountyName(storeManagementDTO.getCountyName()); + slStoreManagement.setCountyCode(storeManagementDTO.getCountyCode()); + slStoreManagement.setTownCode(storeManagementDTO.getTownCode()); + slStoreManagement.setTownName(storeManagementDTO.getTownName()); + this.save(slStoreManagement); + }else { + SlStoreManagement slStoreManagement = this.getById(storeManagementDTO.getId()); + if (storeManagementDTO.getStoreManagementNo()!=null){ + slStoreManagement.setStoreManagementNo(storeManagementDTO.getStoreManagementNo()); + } + if (storeManagementDTO.getStoreManagementAdder()!=null){ + slStoreManagement.setStoreManagementAdder(storeManagementDTO.getStoreManagementAdder()); + } + if (storeManagementDTO.getStoreManagementExplain()!=null){ + slStoreManagement.setStoreManagementExplain(storeManagementDTO.getStoreManagementExplain()); + } + if (storeManagementDTO.getStoreManagementName()!=null){ + slStoreManagement.setStoreManagementName(storeManagementDTO.getStoreManagementName()); + } + if (storeManagementDTO.getStoreManagementGrade()!=null){ + slStoreManagement.setStoreManagementGrade(storeManagementDTO.getStoreManagementGrade()); + } + if (storeManagementDTO.getStoreManagementNumber()!=null){ + slStoreManagement.setStoreManagementNumber(storeManagementDTO.getStoreManagementNumber()); + } + if (storeManagementDTO.getAdministratorId()!=null){ + slStoreManagement.setAdministratorId(storeManagementDTO.getAdministratorId()); + } + if (storeManagementDTO.getCompetentId()!=null){ + slStoreManagement.setCompetentId(storeManagementDTO.getCompetentId()); + } + if (storeManagementDTO.getDirectorId()!=null){ + slStoreManagement.setDirectorId(storeManagementDTO.getDirectorId()); + } + if (storeManagementDTO.getProvinceName()!=null){ + slStoreManagement.setProvinceName(storeManagementDTO.getProvinceName()); + } + if (storeManagementDTO.getProvinceCode()!=null){ + slStoreManagement.setProvinceCode(storeManagementDTO.getProvinceCode()); + } + if (storeManagementDTO.getCityName()!=null){ + slStoreManagement.setCityName(storeManagementDTO.getCityName()); + } + if (storeManagementDTO.getCityCode()!=null){ + slStoreManagement.setCityCode(storeManagementDTO.getCityCode()); + } + if (storeManagementDTO.getCountyName()!=null){ + slStoreManagement.setCountyName(storeManagementDTO.getCountyName()); + } + if (storeManagementDTO.getCountyCode()!=null){ + slStoreManagement.setCountyCode(storeManagementDTO.getCountyCode()); + } + if (storeManagementDTO.getTownCode()!=null){ + slStoreManagement.setTownCode(storeManagementDTO.getTownCode()); + } + if (storeManagementDTO.getTownName()!=null){ + slStoreManagement.setTownName(storeManagementDTO.getTownName()); + } + this.updateById(slStoreManagement); + } + + } + + @Override + public List<SlStoreManagement> QueryStoreManagementList(QStoreManagementQuery StoreManagementQuery) { + LambdaQueryWrapper< SlStoreManagement> wrapper= Wrappers.lambdaQuery(); + if (StoreManagementQuery.getCityCode()!="" && StoreManagementQuery.getCityCode()!=null){ + wrapper.eq(SlStoreManagement::getCityCode,StoreManagementQuery.getCityCode()); + } + if (StoreManagementQuery.getCountyCode()!="" && StoreManagementQuery.getCountyCode()!=null){ + wrapper.eq(SlStoreManagement::getCountyCode,StoreManagementQuery.getCountyCode()); + } + if (StoreManagementQuery.getStoreManagementGrade()!=null&&StoreManagementQuery.getStoreManagementGrade()!=0 ){ + wrapper.eq(SlStoreManagement::getStoreManagementGrade,StoreManagementQuery.getStoreManagementGrade()); + } + + wrapper.eq( SlStoreManagement::getDelFlag,0); + wrapper.orderByDesc(SlStoreManagement::getCreateTime); + List<SlStoreManagement> page1 = this.list(wrapper); + return page1; + } + + @Override + public PageDTO<SlStoreManagementInventoryVO> getManagementInventoryList(StoreManagementQuery storeManagementQuery) { + + 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()!=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); + + PageDTO<SlStoreManagementInventoryVO> InventoryVO = PageDTO.of(page1, SlStoreManagementInventoryVO.class); + List<SlStoreManagementInventoryVO> list2 = InventoryVO.getList(); + for(SlStoreManagementInventoryVO list:list2){ + LambdaQueryWrapper<ManagementGoodsMaterials> wrapper1= Wrappers.lambdaQuery(); + + wrapper1.eq(ManagementGoodsMaterials::getManagementId,list.getId()); + List<ManagementGoodsMaterials> managementGoodsMaterials = managementGoodsMaterialsMapper.selectList(wrapper1); + list.setGoodsMaterialsNum(managementGoodsMaterials.size()); + + } + return InventoryVO; + } } -- Gitblit v1.7.1