From f330903e12d38af89d61f16c96856924d241a0f2 Mon Sep 17 00:00:00 2001
From: zss <zss@example.com>
Date: 星期三, 26 七月 2023 09:08:58 +0800
Subject: [PATCH] 查删检验计划
---
standard-server/src/main/java/com/yuanchu/limslaboratory/service/impl/ProductServiceImpl.java | 73 ++++++++++++++++++++++++++++++++++++
1 files changed, 72 insertions(+), 1 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 844a971..11ff370 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,13 +1,18 @@
package com.yuanchu.limslaboratory.service.impl;
+import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
+import com.baomidou.mybatisplus.core.conditions.update.LambdaUpdateWrapper;
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 org.springframework.beans.factory.annotation.Autowired;
+import com.yuanchu.limslaboratory.service.UserService;
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;
@@ -26,7 +31,73 @@
private ProductMapper productMapper;
@Override
- public List<Product> selectProductByMaterialId(int materialId) {
+ public List<Product> selectProductByMaterialId(String materialId) {
return productMapper.selectProductByMaterialId(materialId);
}
+
+ @Autowired
+ private UserService userService;
+
+ @Override
+ public Integer addProductInformation(Product product) {
+ return productMapper.insert(product);
+ }
+
+ @Override
+ public List<Map<String, Object>> getListProductInformation(String 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) {
+ LambdaUpdateWrapper<Product> wrapper = new LambdaUpdateWrapper<>();
+ wrapper.eq(Product::getId, productId);
+ wrapper.set(Product::getState, 0);
+ return productMapper.update(new Product(), wrapper);
+ }
+
+ @Override
+ public void MaterialIdDeleteProduct(List<String> deleteMaterialId) {
+ for (String materialId : deleteMaterialId){
+ LambdaUpdateWrapper<Product> wrapper = new LambdaUpdateWrapper<>();
+ wrapper.eq(Product::getMaterialId, materialId);
+ wrapper.set(Product::getState, 0);
+ productMapper.update(new Product(), wrapper);
+ }
+ }
+
+ @Override
+ public Integer updateMaterialInformation(Product product) {
+ LambdaUpdateWrapper<Product> updateWrapper = new LambdaUpdateWrapper<>();
+ updateWrapper.eq(Product::getId, product.getId());
+ return productMapper.update(product, updateWrapper);
+ }
}
--
Gitblit v1.9.3