From c1eb35b338c6796d493d60ec12e499802b0a8072 Mon Sep 17 00:00:00 2001
From: value <z1292839451@163.com>
Date: 星期五, 14 六月 2024 08:13:22 +0800
Subject: [PATCH] 标准库导入

---
 inspect-server/src/main/java/com/yuanchu/mom/service/impl/StandardTreeServiceImpl.java |  129 ++++++++++++++++++++++++++++++++++++++++--
 1 files changed, 122 insertions(+), 7 deletions(-)

diff --git a/inspect-server/src/main/java/com/yuanchu/mom/service/impl/StandardTreeServiceImpl.java b/inspect-server/src/main/java/com/yuanchu/mom/service/impl/StandardTreeServiceImpl.java
index 139ce93..3977838 100644
--- a/inspect-server/src/main/java/com/yuanchu/mom/service/impl/StandardTreeServiceImpl.java
+++ b/inspect-server/src/main/java/com/yuanchu/mom/service/impl/StandardTreeServiceImpl.java
@@ -1,26 +1,49 @@
 package com.yuanchu.mom.service.impl;
 
+import cn.hutool.poi.excel.ExcelUtil;
+import com.alibaba.fastjson.JSON;
+import com.alibaba.fastjson.JSONArray;
+import com.baomidou.mybatisplus.core.toolkit.Wrappers;
 import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
 import com.yuanchu.mom.dto.FactoryDto;
-import com.yuanchu.mom.pojo.StandardTree;
-import com.yuanchu.mom.service.StandardTreeService;
+import com.yuanchu.mom.dto.SampleTypeDto;
+import com.yuanchu.mom.mapper.StandardMethodListMapper;
+import com.yuanchu.mom.mapper.StandardProductListMapper;
 import com.yuanchu.mom.mapper.StandardTreeMapper;
+import com.yuanchu.mom.pojo.StandardProductList;
+import com.yuanchu.mom.pojo.StandardTree;
+import com.yuanchu.mom.service.StandardMethodListService;
+import com.yuanchu.mom.service.StandardProductListService;
+import com.yuanchu.mom.service.StandardTreeService;
 import lombok.AllArgsConstructor;
 import org.springframework.stereotype.Service;
+import org.springframework.transaction.annotation.Transactional;
+import org.springframework.web.multipart.MultipartFile;
 
+import java.io.IOException;
+import java.io.InputStream;
 import java.util.List;
+import java.util.Map;
 
 /**
-* @author Administrator
-* @description 閽堝琛ㄣ�恠tandard_tree(鏍囧噯鏍�)銆戠殑鏁版嵁搴撴搷浣淪ervice瀹炵幇
-* @createDate 2024-03-01 15:06:44
-*/
+ * @author Administrator
+ * @description 閽堝琛ㄣ�恠tandard_tree(鏍囧噯鏍�)銆戠殑鏁版嵁搴撴搷浣淪ervice瀹炵幇
+ * @createDate 2024-03-01 15:06:44
+ */
 @Service
 @AllArgsConstructor
 public class StandardTreeServiceImpl extends ServiceImpl<StandardTreeMapper, StandardTree>
-    implements StandardTreeService{
+        implements StandardTreeService {
 
     private StandardTreeMapper standardTreeMapper;
+
+    private StandardMethodListMapper standardMethodListMapper;
+
+    private StandardMethodListService standardMethodListService;
+
+    private StandardProductListMapper standardProductListMapper;
+
+    private StandardProductListService standardProductListService;
 
     @Override
     public List<FactoryDto> selectStandardTreeList() {
@@ -28,9 +51,101 @@
     }
 
     @Override
+    @Transactional(rollbackFor = Exception.class)
     public int addStandardTree(StandardTree standardTree) {
         return standardTreeMapper.insert(standardTree);
     }
+
+    @Override
+    @Transactional(rollbackFor = Exception.class)
+    public int delStandardTree(String tree) {
+        String[] trees = tree.split(" - ");
+        switch (trees.length) {
+            case 5:
+                standardTreeMapper.delete(Wrappers.<StandardTree>lambdaUpdate().eq(StandardTree::getFactory, trees[0]).eq(StandardTree::getLaboratory, trees[1]).eq(StandardTree::getSampleType, trees[2]).eq(StandardTree::getSample, trees[3]).eq(StandardTree::getModel, trees[4]));
+                break;
+            /*case 4:
+                standardTreeMapper.delete(Wrappers.<StandardTree>lambdaUpdate().eq(StandardTree::getFactory, trees[0]).eq(StandardTree::getLaboratory, trees[1]).eq(StandardTree::getSampleType, trees[2]).eq(StandardTree::getSample, trees[3]));
+                break;
+            case 3:
+                standardTreeMapper.delete(Wrappers.<StandardTree>lambdaUpdate().eq(StandardTree::getFactory, trees[0]).eq(StandardTree::getLaboratory, trees[1]).eq(StandardTree::getSampleType, trees[2]));
+                break;
+            case 2:
+                standardTreeMapper.delete(Wrappers.<StandardTree>lambdaUpdate().eq(StandardTree::getFactory, trees[0]).eq(StandardTree::getLaboratory, trees[1]));
+                break;
+            case 1:
+                standardTreeMapper.delete(Wrappers.<StandardTree>lambdaUpdate().eq(StandardTree::getFactory, trees[0]));
+                break;*/
+        }
+        return 1;
+    }
+
+    @Override
+    @Transactional(rollbackFor = Exception.class)
+    public int addStandardProduct(String ids, String tree) {
+        String[] trees = tree.split(" - ");
+        JSONArray jsonArray = JSON.parseArray(ids);
+        for (Object o : jsonArray) {
+            StandardProductList standardProductList = standardTreeMapper.selectStandardProductById(Integer.parseInt("" + o));
+            standardProductList.setFactory(trees[0]);
+            try {
+                standardProductList.setLaboratory(trees[1]);
+            } catch (Exception e) {
+            }
+            try {
+                standardProductList.setSampleType(trees[2]);
+            } catch (Exception e) {
+            }
+            try {
+                standardProductList.setSample(trees[3]);
+            } catch (Exception e) {
+            }
+            try {
+                standardProductList.setModel(trees[4]);
+            } catch (Exception e) {
+            }
+            standardProductListMapper.insert(standardProductList);
+        }
+        return 1;
+    }
+
+    @Override
+    public List<SampleTypeDto> getStandardTree2() {
+        return standardTreeMapper.getStandardTree2();
+    }
+
+    @Override
+    @Transactional(rollbackFor = Exception.class)
+    public int upStandardProducts(Map<String, Object> product) {
+        List<Integer> ids = JSON.parseArray(product.get("ids")+"");
+        StandardProductList productList = JSON.parseObject(JSON.toJSONString(product.get("standardProductList")), StandardProductList.class);
+        standardProductListMapper.update(productList, Wrappers.<StandardProductList>lambdaUpdate().in(StandardProductList::getId, ids));
+        return 1;
+    }
+
+    @Override
+    public List<StandardTree> getStandTreeBySampleType(String laboratory, String sampleType) {
+        return standardTreeMapper.selectList(Wrappers.<StandardTree>lambdaQuery()
+                .eq(StandardTree::getLaboratory, laboratory)
+                .eq(StandardTree::getSampleType, sampleType)
+                .select(StandardTree::getModel, StandardTree::getSample));
+    }
+
+    @Override
+    public void inExcelOfTree(MultipartFile file) {
+        InputStream inputStream;
+        try {
+            inputStream = file.getInputStream();
+        } catch (IOException e) {
+            throw new RuntimeException(e);
+        }
+        ExcelUtil.readBySax(inputStream, 0, (i, l, list) -> {
+            System.out.println(list);
+            if (i == 0 && l >= 1) {
+
+            }
+        });
+    }
 }
 
 

--
Gitblit v1.9.3