From a33396e17dd847f31b62f416f7d9c5a58b79126b Mon Sep 17 00:00:00 2001 From: XiaoRuby <3114200645@qq.com> Date: 星期五, 28 七月 2023 09:02:29 +0800 Subject: [PATCH] LIMS管理系统框架-开发7-28早上 --- standard-server/src/main/java/com/yuanchu/limslaboratory/service/impl/MaterialServiceImpl.java | 127 ++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 127 insertions(+), 0 deletions(-) diff --git a/standard-server/src/main/java/com/yuanchu/limslaboratory/service/impl/MaterialServiceImpl.java b/standard-server/src/main/java/com/yuanchu/limslaboratory/service/impl/MaterialServiceImpl.java index 9279599..83e6236 100644 --- a/standard-server/src/main/java/com/yuanchu/limslaboratory/service/impl/MaterialServiceImpl.java +++ b/standard-server/src/main/java/com/yuanchu/limslaboratory/service/impl/MaterialServiceImpl.java @@ -1,10 +1,26 @@ package com.yuanchu.limslaboratory.service.impl; +import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; +import com.baomidou.mybatisplus.core.conditions.update.LambdaUpdateWrapper; +import com.baomidou.mybatisplus.core.toolkit.IdWorker; +import com.baomidou.mybatisplus.core.toolkit.ObjectUtils; import com.yuanchu.limslaboratory.pojo.Material; import com.yuanchu.limslaboratory.mapper.MaterialMapper; +import com.yuanchu.limslaboratory.pojo.Specifications; +import com.yuanchu.limslaboratory.pojo.Standard; +import com.yuanchu.limslaboratory.pojo.dto.AddMaterialDto; import com.yuanchu.limslaboratory.service.MaterialService; import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; +import com.yuanchu.limslaboratory.service.ProductService; +import com.yuanchu.limslaboratory.service.SpecificationsService; +import com.yuanchu.limslaboratory.service.StandardService; +import com.yuanchu.limslaboratory.utils.MyUtil; +import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; + +import javax.annotation.Resource; +import java.util.List; +import java.util.Map; /** * <p> @@ -17,4 +33,115 @@ @Service public class MaterialServiceImpl extends ServiceImpl<MaterialMapper, Material> implements MaterialService { + @Resource + private MaterialMapper materialMapper; + + @Autowired + private StandardService standardService; + + @Autowired + private SpecificationsService specificationsService; + + @Autowired + private ProductService productService; + + //鏌ヨ鐗╂枡淇℃伅 + @Override + public List<Map> selectMaterialLimit(int pageSize, int countSize, int type) { + return materialMapper.selectMaterialLimit((pageSize - 1) * countSize,pageSize * countSize, type); + } + + //鏍规嵁鐗╂枡id鏌ヨ鐗╂枡淇℃伅 + @Override + public Map selectMaterialById(String materialId) { + return materialMapper.selectMaterialById(materialId); + } + + @Override + public Integer deleteMaterialInformation(Integer materialId) { + LambdaUpdateWrapper<Material> updateWrapper = new LambdaUpdateWrapper<>(); + updateWrapper.eq(Material::getId, materialId); + updateWrapper.set(Material::getState, 0); + int isDeleteSuccess = materialMapper.update(new Material(), updateWrapper); + if (isDeleteSuccess == 1){ + List<Integer> isDeleteStandard = standardService.deleteStandardsInformation(materialId); + if (!ObjectUtils.isEmpty(isDeleteStandard)){ + List<Integer> idDeleteSpecifications = specificationsService.StandardIdDeleteSpecifications(isDeleteStandard); + if (!ObjectUtils.isEmpty(idDeleteSpecifications)){ + productService.deleteProductInformation(idDeleteSpecifications); + } + } + return 1; + } + return 0; + } + + @Override + public Integer addMaterialInformation(AddMaterialDto addMaterialDto) { + Material material = new Material() + .setCode("BZ" + IdWorker.getIdStr()) + .setName(addMaterialDto.getMaterialName()) + .setType(addMaterialDto.getType()); + int isInsertSuccess = materialMapper.insert(material); + if (isInsertSuccess > 0){ + Standard standard = new Standard() + .setMaterialId(material.getId()) + .setName(addMaterialDto.getStandardName()); + boolean save = standardService.save(standard); + if (save){ + Specifications specifications = new Specifications() + .setName(addMaterialDto.getSpecificationsName()) + .setStandardId(standard.getId()); + boolean save1 = specificationsService.save(specifications); + if (save1) + return 1; + } + } + return 0; + } + + @Override + public List<Map<String, Object>> getFourLevelInformation(String specificationName) { + LambdaQueryWrapper<Material> typeWrapper = new LambdaQueryWrapper<>(); + typeWrapper.groupBy(Material::getType); + typeWrapper.select(Material::getType); + List<Map<String, Object>> typeMaps = materialMapper.selectMaps(typeWrapper); + for (Map<String, Object> typeMap : typeMaps){ + LambdaQueryWrapper<Material> materialWrapper = new LambdaQueryWrapper<>(); + materialWrapper.eq(Material::getType, typeMap.get("type")); + materialWrapper.select(Material::getId, Material::getName); + List<Map<String, Object>> materialMaps = materialMapper.selectMaps(materialWrapper); + if (!ObjectUtils.isEmpty(materialMaps)){ + for (Map<String, Object> materialMap : materialMaps){ + LambdaQueryWrapper<Standard> wrapper = new LambdaQueryWrapper<>(); + wrapper.eq(Standard::getMaterialId, materialMap.get("id")); + wrapper.select(Standard::getId, Standard::getName); + List<Map<String, Object>> standardMaps = standardService.listMaps(wrapper); + if (!ObjectUtils.isEmpty(standardMaps)){ + for (Map<String, Object> standardMap : standardMaps){ + LambdaQueryWrapper<Specifications> specificationWrapper = new LambdaQueryWrapper<>(); + specificationWrapper.eq(Specifications::getStandardId, standardMap.get("id")); + if (!ObjectUtils.isEmpty(specificationName)){ + specificationWrapper.eq(Specifications::getName, specificationName); + } + specificationWrapper.select(Specifications::getId, Specifications::getName); + List<Map<String, Object>> specificationsMaps = specificationsService.listMaps(specificationWrapper); + if (!ObjectUtils.isEmpty(specificationsMaps)){ + standardMap.put("children", specificationsMaps); + } else { + standardMap.put("children", null); + } + } + materialMap.put("children", standardMaps); + } else { + materialMap.put("children", null); + } + } + typeMap.put("children", materialMaps); + } else { + typeMap.put("children", null); + } + } + return typeMaps; + } } -- Gitblit v1.9.3