| | |
| | | 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> |
| | |
| | | @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; |
| | | } |
| | | } |