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