From e6ffa9fcebef022be1e8e8162c65f52754f9081e Mon Sep 17 00:00:00 2001 From: zss <zss@example.com> Date: 星期六, 19 八月 2023 15:11:22 +0800 Subject: [PATCH] 基础数据 --- standard-server/src/main/java/com/yuanchu/limslaboratory/service/impl/ProductServiceImpl.java | 80 ++++++++++------------------------------ 1 files changed, 20 insertions(+), 60 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 11ff370..c27c343 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 @@ -2,23 +2,31 @@ import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; import com.baomidou.mybatisplus.core.conditions.update.LambdaUpdateWrapper; +import com.baomidou.mybatisplus.core.metadata.IPage; +import com.baomidou.mybatisplus.extension.plugins.pagination.Page; +import com.yuanchu.limslaboratory.mapper.ProductModelMapper; +import com.yuanchu.limslaboratory.mapper.SpecificationsMapper; import com.yuanchu.limslaboratory.pojo.Product; import com.yuanchu.limslaboratory.mapper.ProductMapper; +import com.yuanchu.limslaboratory.pojo.ProductModel; import com.yuanchu.limslaboratory.service.ProductService; import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; +import com.yuanchu.limslaboratory.utils.MyUtil; import org.springframework.beans.factory.annotation.Autowired; import com.yuanchu.limslaboratory.service.UserService; import org.springframework.stereotype.Service; +import org.springframework.transaction.annotation.Transactional; import org.springframework.util.ObjectUtils; import javax.annotation.Resource; import java.util.ArrayList; import java.util.List; import java.util.Map; +import java.util.Objects; /** * <p> - * 鏈嶅姟瀹炵幇绫� + * 鏈嶅姟瀹炵幇绫� * </p> * * @author 姹熻嫃榈烽洀缃戠粶绉戞妧鏈夐檺鍏徃 @@ -30,74 +38,26 @@ @Resource private ProductMapper productMapper; - @Override - public List<Product> selectProductByMaterialId(String materialId) { - return productMapper.selectProductByMaterialId(materialId); - } + @Resource + ProductModelMapper productModelMapper; - @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){ + public void deleteProductInformation(List<Integer> SpecificationsId) { + for (Integer materialId : SpecificationsId){ LambdaUpdateWrapper<Product> wrapper = new LambdaUpdateWrapper<>(); - wrapper.eq(Product::getMaterialId, materialId); + wrapper.eq(Product::getSpecifications_id, 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); + @Transactional(rollbackFor = Exception.class) + public List<Map<String, Object>> pageProductInformation(Integer specificationsId) { + return productMapper.pageProductInformation(specificationsId); } + + } -- Gitblit v1.9.3