From 6cd215389e72e5c12be9e5ee124b470b9d620f4d Mon Sep 17 00:00:00 2001
From: Fixiaobai <fixiaobai@163.com>
Date: 星期三, 30 八月 2023 10:09:30 +0800
Subject: [PATCH] 修改委托单位

---
 inspection-server/src/main/java/com/yuanchu/limslaboratory/mapper/LinkBasicInformationMapper.java            |    1 +
 inspection-server/src/main/java/com/yuanchu/limslaboratory/service/impl/LinkBasicInformationServiceImpl.java |    4 ++--
 inspection-server/src/main/resources/mapper/LinkBasicInformationMapper.xml                                   |   10 ++++++----
 sys/src/main/java/com/yuanchu/limslaboratory/commandLineRunner/ResolutionRequestsCommandLineRunner.java      |    6 ++----
 inspection-server/src/main/java/com/yuanchu/limslaboratory/controller/LinkBasicInformationController.java    |    4 +++-
 inspection-server/src/main/java/com/yuanchu/limslaboratory/service/impl/InspectionServiceImpl.java           |    2 ++
 6 files changed, 16 insertions(+), 11 deletions(-)

diff --git a/inspection-server/src/main/java/com/yuanchu/limslaboratory/controller/LinkBasicInformationController.java b/inspection-server/src/main/java/com/yuanchu/limslaboratory/controller/LinkBasicInformationController.java
index ebe036d..60b83e9 100644
--- a/inspection-server/src/main/java/com/yuanchu/limslaboratory/controller/LinkBasicInformationController.java
+++ b/inspection-server/src/main/java/com/yuanchu/limslaboratory/controller/LinkBasicInformationController.java
@@ -5,6 +5,8 @@
 import com.baomidou.mybatisplus.core.toolkit.ObjectUtils;
 import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
 import com.yuanchu.limslaboratory.annotation.AuthHandler;
+import com.yuanchu.limslaboratory.enums.InterfaceType;
+import com.yuanchu.limslaboratory.enums.MenuEnums;
 import com.yuanchu.limslaboratory.pojo.LinkBasicInformation;
 import com.yuanchu.limslaboratory.service.LinkBasicInformationService;
 import com.yuanchu.limslaboratory.utils.MyUtil;
@@ -76,7 +78,7 @@
             @ApiImplicitParam(name = "id", value = "濮旀墭鏍峰搧id", dataTypeClass = Integer.class, required = true)
     })
     @PostMapping("/delLink")
-    @AuthHandler
+    @AuthHandler(type = InterfaceType.DELETE,menuId = MenuEnums.commissionInspection,isAdd = true)
     public Result<?> delLink(Integer id){
         linkBasicInformationService.delLink(id);
         return Result.success("鍒犻櫎鎴愬姛!");
diff --git a/inspection-server/src/main/java/com/yuanchu/limslaboratory/mapper/LinkBasicInformationMapper.java b/inspection-server/src/main/java/com/yuanchu/limslaboratory/mapper/LinkBasicInformationMapper.java
index cf34ec5..422dae3 100644
--- a/inspection-server/src/main/java/com/yuanchu/limslaboratory/mapper/LinkBasicInformationMapper.java
+++ b/inspection-server/src/main/java/com/yuanchu/limslaboratory/mapper/LinkBasicInformationMapper.java
@@ -32,4 +32,5 @@
 
     LinkBasicInformation getLinkBasicInformation(@Param("uid")String uid);
 
+    int deleteByID(Integer id);
 }
diff --git a/inspection-server/src/main/java/com/yuanchu/limslaboratory/service/impl/InspectionServiceImpl.java b/inspection-server/src/main/java/com/yuanchu/limslaboratory/service/impl/InspectionServiceImpl.java
index 875b650..580f029 100644
--- a/inspection-server/src/main/java/com/yuanchu/limslaboratory/service/impl/InspectionServiceImpl.java
+++ b/inspection-server/src/main/java/com/yuanchu/limslaboratory/service/impl/InspectionServiceImpl.java
@@ -1,5 +1,6 @@
 package com.yuanchu.limslaboratory.service.impl;
 
+import cn.hutool.core.date.DateUtil;
 import cn.hutool.core.lang.Snowflake;
 import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
 import com.baomidou.mybatisplus.core.conditions.update.UpdateWrapper;
@@ -133,6 +134,7 @@
             RawMaterial rawMaterial = new RawMaterial();
             rawMaterial.setId(inspectionVo.getId());
             rawMaterial.setType(1);
+            rawMaterial.setInspectionDate(DateUtil.date());
             rawMaterial.setSurveyor(userMapper.selectById(id).getName());
             rawMaterialMapper.updateById(rawMaterial);
         }
diff --git a/inspection-server/src/main/java/com/yuanchu/limslaboratory/service/impl/LinkBasicInformationServiceImpl.java b/inspection-server/src/main/java/com/yuanchu/limslaboratory/service/impl/LinkBasicInformationServiceImpl.java
index 6cde1b5..db1d27a 100644
--- a/inspection-server/src/main/java/com/yuanchu/limslaboratory/service/impl/LinkBasicInformationServiceImpl.java
+++ b/inspection-server/src/main/java/com/yuanchu/limslaboratory/service/impl/LinkBasicInformationServiceImpl.java
@@ -45,10 +45,10 @@
         QueryWrapper<LinkBasicInformation> queryWrapper = new QueryWrapper<>();
         queryWrapper.lambda().select(LinkBasicInformation::getId).eq(LinkBasicInformation::getUid, linkBasicInformation.getUid());
         LinkBasicInformation linkBasicInformation1 = linkBasicInformationMapper.selectOne(queryWrapper);
-        Optional.ofNullable(linkBasicInformation.getId()).ifPresent(l->{
+        Optional.ofNullable(linkBasicInformation1.getId()).ifPresent(l->{
             //鎵ц鍒犻櫎
             linkDetectionMapper.deleteByLinkbasic(linkBasicInformation1.getId());
-            linkBasicInformationMapper.deleteById(linkBasicInformation1.getId());
+            linkBasicInformationMapper.deleteByID(linkBasicInformation1.getId());
         });
         //濮旀墭缂栧彿
         String code = MyUtil.getTimeSixNumberCode("SL", "SL");
diff --git a/inspection-server/src/main/resources/mapper/LinkBasicInformationMapper.xml b/inspection-server/src/main/resources/mapper/LinkBasicInformationMapper.xml
index 45753e2..694d9fd 100644
--- a/inspection-server/src/main/resources/mapper/LinkBasicInformationMapper.xml
+++ b/inspection-server/src/main/resources/mapper/LinkBasicInformationMapper.xml
@@ -1,6 +1,9 @@
 <?xml version="1.0" encoding="UTF-8"?>
 <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
 <mapper namespace="com.yuanchu.limslaboratory.mapper.LinkBasicInformationMapper">
+    <delete id="deleteByID">
+        delete from link_basic_information where id=#{id}
+    </delete>
     <select id="getLinkBasicPage" resultType="map">
         SELECT d.`id`, l.`entrust_coding`, l.`entrusted`, d.`samples_number`, d.`sample_name`,
         d.`specifications_models`,
@@ -62,12 +65,11 @@
                ld.unit                  unit,
                ld.samples_number        samplesNumber,
                ld.remarks               remarks
-        FROM link_basic_information lb,
+        FROM link_basic_information lb left join
              link_detection ld
-        WHERE lb.id = ld.link_basic_id
-          AND lb.uid = #{uid}
+             on lb.id = ld.link_basic_id
+        where lb.uid = #{uid}
           and lb.state = 1
-          AND ld.state = 1
     </select>
 
     <resultMap id="getLinkBasicInformationMap" type="com.yuanchu.limslaboratory.pojo.LinkBasicInformation">
diff --git a/sys/src/main/java/com/yuanchu/limslaboratory/commandLineRunner/ResolutionRequestsCommandLineRunner.java b/sys/src/main/java/com/yuanchu/limslaboratory/commandLineRunner/ResolutionRequestsCommandLineRunner.java
index 4fbf344..5a2b1ef 100644
--- a/sys/src/main/java/com/yuanchu/limslaboratory/commandLineRunner/ResolutionRequestsCommandLineRunner.java
+++ b/sys/src/main/java/com/yuanchu/limslaboratory/commandLineRunner/ResolutionRequestsCommandLineRunner.java
@@ -39,9 +39,6 @@
     @Autowired
     private RoleManageMapper roleManageMapper;
 
-    @Autowired
-    private MenuMapper menuMapper;
-
     @SneakyThrows
     @Override
     public void run(String... args) throws Exception {
@@ -104,8 +101,9 @@
                         .noneMatch(value2 -> value2.equals(map1.get("url")))  // 鏌ユ壘涓嶅悓鐨勫��
                 ).collect(Collectors.toList());
         if(differentMaps.size()>0){
+
             int insertInterfaceList = roleManageMapper.insertInterfaceList(differentMaps);
-            if (insertInterfaceList>0) log.info("鏂板鎺ュ彛鎴愬姛锛�");
+            if (insertInterfaceList>0) log.info(String.valueOf(differentMaps));log.info("鏂板鎺ュ彛鎴愬姛锛�");
         }else {
             log.info("鏃犻渶澧炲姞鏂扮殑鎺ュ彛锛�");
         }

--
Gitblit v1.9.3