From 2d44844cafa096bd42391b8d2c2185f0bfbf2d79 Mon Sep 17 00:00:00 2001 From: XiaoRuby <3114200645@qq.com> Date: 星期三, 19 七月 2023 11:13:17 +0800 Subject: [PATCH] LIMS管理系统框架-开发7-19-v1.0.0 --- standard-server/src/main/java/com/yuanchu/limslaboratory/service/impl/ProductServiceImpl.java | 75 +++++++++++++++++++++++++++++++++++++ 1 files changed, 75 insertions(+), 0 deletions(-) diff --git a/standard-server/src/main/java/com/yuanchu/limslaboratory/service/impl/ProductServiceImpl.java b/standard-server/src/main/java/com/yuanchu/limslaboratory/service/impl/ProductServiceImpl.java index 8079756..59dcc91 100644 --- a/standard-server/src/main/java/com/yuanchu/limslaboratory/service/impl/ProductServiceImpl.java +++ b/standard-server/src/main/java/com/yuanchu/limslaboratory/service/impl/ProductServiceImpl.java @@ -1,10 +1,20 @@ package com.yuanchu.limslaboratory.service.impl; +import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; import com.yuanchu.limslaboratory.pojo.Product; import com.yuanchu.limslaboratory.mapper.ProductMapper; import com.yuanchu.limslaboratory.service.ProductService; import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; +import com.yuanchu.limslaboratory.service.UserService; +import com.yuanchu.limslaboratory.utils.MyUtil; +import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; +import org.springframework.util.ObjectUtils; + +import javax.annotation.Resource; +import java.util.ArrayList; +import java.util.List; +import java.util.Map; /** * <p> @@ -17,4 +27,69 @@ @Service public class ProductServiceImpl extends ServiceImpl<ProductMapper, Product> implements ProductService { + @Resource + private ProductMapper productMapper; + + @Autowired + private UserService userService; + + @Override + public Integer addProductInformation(Product product) { + return productMapper.insert(product); + } + + @Override + public List<Map<String, Object>> getListProductInformation(Integer materialId) { + LambdaQueryWrapper<Product> wrapper = new LambdaQueryWrapper<>(); + wrapper.eq(Product::getMaterialId, materialId); + wrapper.select(Product::getId, Product::getName, Product::getFather); + wrapper.groupBy(Product::getFather); + List<Map<String, Object>> products = productMapper.selectMaps(wrapper); + for (Map<String, Object> product:products){ + if (!ObjectUtils.isEmpty(product.get("father"))){ + product.remove("name"); + product.remove("id"); + LambdaQueryWrapper<Product> wrapper1 = new LambdaQueryWrapper<>(); + wrapper1.eq(Product::getFather, product.get("father")); + wrapper1.select(Product::getId, Product::getName); + List<Map<String, Object>> maps = productMapper.selectMaps(wrapper1); + product.put("sonProduct", maps); + } + } + for (Map<String, Object> product:products){ + System.out.println(product); + } + return products; + } + + @Override + public Map<String, Object> getProductInformation(Integer productId) { + Map<String, Object> productMap = productMapper.getProductInformation(productId); + String userName = userService.selectByUserId((Integer) productMap.get("user_id")); + productMap.remove("user_id"); + productMap.put("userName", userName); + return productMap; + } + + @Override + public Integer deleteProductInformation(Integer productId) { + LambdaQueryWrapper<Product> wrapper = new LambdaQueryWrapper<>(); + wrapper.eq(Product::getId, productId); + return productMapper.delete(wrapper); + } + + @Override + public void deleteProductEqMaterialId(List<String> materialListId) { + for (String materialId : materialListId){ + LambdaQueryWrapper<Product> wrapper = new LambdaQueryWrapper<>(); + wrapper.eq(Product::getMaterialId, materialId); + wrapper.select(Product::getId); + List<Product> products = productMapper.selectList(wrapper); + List<Integer> productDeleteId = new ArrayList<>(); + for (Product product : products){ + productDeleteId.add(product.getId()); + } + productMapper.deleteBatchIds(productDeleteId); + } + } } -- Gitblit v1.9.3