From 7dcb6f8665db1334940dca300c4b83c6cd81373d Mon Sep 17 00:00:00 2001
From: JYW <2013732181@qq.com>
Date: 星期二, 23 四月 2024 15:00:44 +0800
Subject: [PATCH] 2024-04-23 印章后端关联实验室

---
 cnas-server/src/main/java/com/yuanchu/mom/service/SealService.java             |    3 +
 system-run/src/main/resources/application-dev.yml                              |    2 
 cnas-server/src/main/java/com/yuanchu/mom/service/impl/SealServiceImpl.java    |    8 ++-
 cnas-server/src/main/resources/mapper/SealMapper.xml                           |   13 +++---
 cnas-server/src/main/java/com/yuanchu/mom/controller/SealController.java       |   15 +++++--
 cnas-server/src/main/java/com/yuanchu/mom/pojo/Seal.java                       |    7 ++-
 cnas-server/src/main/java/com/yuanchu/mom/controller/DeviceController.java     |    1 
 system-run/src/main/resources/application.yml                                  |    2 
 cnas-server/src/main/java/com/yuanchu/mom/mapper/SealMapper.java               |    8 +++
 cnas-server/src/main/java/com/yuanchu/mom/controller/LaboratoryController.java |    5 ++
 10 files changed, 44 insertions(+), 20 deletions(-)

diff --git a/cnas-server/src/main/java/com/yuanchu/mom/controller/DeviceController.java b/cnas-server/src/main/java/com/yuanchu/mom/controller/DeviceController.java
index 315c89e..d4ca573 100644
--- a/cnas-server/src/main/java/com/yuanchu/mom/controller/DeviceController.java
+++ b/cnas-server/src/main/java/com/yuanchu/mom/controller/DeviceController.java
@@ -126,6 +126,5 @@
     public Result selectDeviceByCategory(String category) {
         return Result.success(deviceService.selectDeviceByCategory(category));
     }
-
 }
 
diff --git a/cnas-server/src/main/java/com/yuanchu/mom/controller/LaboratoryController.java b/cnas-server/src/main/java/com/yuanchu/mom/controller/LaboratoryController.java
index d6ff7a8..fbcae21 100644
--- a/cnas-server/src/main/java/com/yuanchu/mom/controller/LaboratoryController.java
+++ b/cnas-server/src/main/java/com/yuanchu/mom/controller/LaboratoryController.java
@@ -12,6 +12,9 @@
 import io.swagger.annotations.ApiOperation;
 import org.springframework.beans.factory.annotation.Value;
 import org.springframework.web.bind.annotation.*;
+
+import javax.annotation.Resource;
+import javax.annotation.Resources;
 import java.util.Map;
 
 /**
@@ -25,7 +28,7 @@
     @Value("${file.path}")
     private String filePath;
 
-
+    @Resource
     private LaboratoryService laboratoryService;
 
     @ApiOperation(value = "鏌ヨ瀹為獙瀹ょ鐞嗗垪琛�")
diff --git a/cnas-server/src/main/java/com/yuanchu/mom/controller/SealController.java b/cnas-server/src/main/java/com/yuanchu/mom/controller/SealController.java
index d406559..3fccae6 100644
--- a/cnas-server/src/main/java/com/yuanchu/mom/controller/SealController.java
+++ b/cnas-server/src/main/java/com/yuanchu/mom/controller/SealController.java
@@ -1,5 +1,6 @@
 package com.yuanchu.mom.controller;
 import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
+import com.yuanchu.mom.pojo.Laboratory;
 import com.yuanchu.mom.pojo.Seal;
 import com.yuanchu.mom.service.SealService;
 import com.yuanchu.mom.utils.JackSonUtil;
@@ -10,6 +11,7 @@
 import org.springframework.web.bind.annotation.*;
 
 import javax.annotation.Resource;
+import java.util.List;
 import java.util.Map;
 
 /**
@@ -32,7 +34,15 @@
     @ApiOperation(value = "娣诲姞鍗扮珷鍙傛暟")
     @PostMapping("/addSeal")
     public Result addSeal(@RequestBody Seal seal) {
-        return Result.success(sealService.addSeal(seal));
+        int i = sealService.addSeal(seal);
+        if(i>0){
+            Integer labId = seal.getLabId();
+            List<Laboratory> laboratory = sealService.Laboratory(labId);
+            return Result.success(laboratory);
+        }else{
+            return Result.fail();
+        }
+
     }
     @ApiOperation(value = "淇敼鍗扮珷鍙傛暟")
     @PostMapping("/upSeal")
@@ -42,11 +52,8 @@
     @ApiOperation(value="鏌ヨ鍗扮珷鍒楄〃")
     @PostMapping("/selectSeal")
     public  Result selectSeal(@RequestBody Map<String, Object> data) throws Exception {
-        //鑾峰彇褰撳墠椤垫暟
         Page page = JackSonUtil.unmarshal(JackSonUtil.marshal(data.get("page")), Page.class);
-        //鑾峰彇褰撳墠鍗扮珷淇℃伅
         Seal seal = JackSonUtil.unmarshal(JackSonUtil.marshal(data.get("entity")), Seal.class);
-        //鑾峰彇鍒嗛〉鏁版嵁
         return Result.success(sealService.selectSeal(page,seal));
     }
 }
diff --git a/cnas-server/src/main/java/com/yuanchu/mom/mapper/SealMapper.java b/cnas-server/src/main/java/com/yuanchu/mom/mapper/SealMapper.java
index fd6f001..7577a20 100644
--- a/cnas-server/src/main/java/com/yuanchu/mom/mapper/SealMapper.java
+++ b/cnas-server/src/main/java/com/yuanchu/mom/mapper/SealMapper.java
@@ -6,8 +6,14 @@
 import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
 import com.yuanchu.mom.pojo.Certification;
 
+import com.yuanchu.mom.pojo.Laboratory;
 import com.yuanchu.mom.pojo.Seal;
 
+import java.util.List;
+import java.util.Map;
+
 public interface SealMapper extends BaseMapper<Seal> {
-    IPage<Seal> selectSeal(Page page, QueryWrapper<Seal> ew);
+    IPage<Seal>selectSeal(Page page, QueryWrapper<Seal> ew);
+    List<Laboratory> selectLaboratory (Integer labId);
+
 }
diff --git a/cnas-server/src/main/java/com/yuanchu/mom/pojo/Seal.java b/cnas-server/src/main/java/com/yuanchu/mom/pojo/Seal.java
index 8154dec..07e7d1a 100644
--- a/cnas-server/src/main/java/com/yuanchu/mom/pojo/Seal.java
+++ b/cnas-server/src/main/java/com/yuanchu/mom/pojo/Seal.java
@@ -20,9 +20,11 @@
     @ApiModelProperty(value = "涓婚敭")
     @TableId(type = IdType.AUTO)
     private Integer id;
-
+    @ValueTableShow(1)
+    @ApiModelProperty(value = "瀹為獙瀹d")
+    private Integer labId;
     @ValueTableShow(2)
-    @ApiModelProperty(value = "鍗扮珷鍦板潃")
+    @ApiModelProperty(value = "鍗扮珷鍥剧墖")
     private String address;
 
     @ValueTableShow(3)
@@ -38,5 +40,6 @@
     @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
     private LocalDateTime createTime;
 
+
 }
 
diff --git a/cnas-server/src/main/java/com/yuanchu/mom/service/SealService.java b/cnas-server/src/main/java/com/yuanchu/mom/service/SealService.java
index fc4cd75..df66ac6 100644
--- a/cnas-server/src/main/java/com/yuanchu/mom/service/SealService.java
+++ b/cnas-server/src/main/java/com/yuanchu/mom/service/SealService.java
@@ -6,6 +6,7 @@
 import com.yuanchu.mom.pojo.Laboratory;
 import com.yuanchu.mom.pojo.Seal;
 
+import java.util.List;
 import java.util.Map;
 
 public interface SealService extends IService<Seal> {
@@ -19,5 +20,7 @@
     //鏌ヨ
     Map<String, Object> selectSeal(Page page, Seal seal);
 
+    List<Laboratory>  Laboratory(Integer id);
+
 
 }
diff --git a/cnas-server/src/main/java/com/yuanchu/mom/service/impl/SealServiceImpl.java b/cnas-server/src/main/java/com/yuanchu/mom/service/impl/SealServiceImpl.java
index 589a578..390fbf7 100644
--- a/cnas-server/src/main/java/com/yuanchu/mom/service/impl/SealServiceImpl.java
+++ b/cnas-server/src/main/java/com/yuanchu/mom/service/impl/SealServiceImpl.java
@@ -14,6 +14,7 @@
 import org.springframework.stereotype.Service;
 
 import java.util.HashMap;
+import java.util.List;
 import java.util.Map;
 
 @Service
@@ -42,9 +43,10 @@
         Map<String, Object> map = new HashMap<>();
         map.put("head", PrintChina.printChina(Seal.class));
         map.put("body", sealMapper.selectSeal(page, QueryWrappers.queryWrappers(seal)));
-        System.out.println(page);
         return map;
     }
-
-
+    @Override
+    public List<Laboratory> Laboratory(Integer labId) {
+        return sealMapper.selectLaboratory(labId);
+    }
 }
diff --git a/cnas-server/src/main/resources/mapper/SealMapper.xml b/cnas-server/src/main/resources/mapper/SealMapper.xml
index 0ae0d6e..c1e4380 100644
--- a/cnas-server/src/main/resources/mapper/SealMapper.xml
+++ b/cnas-server/src/main/resources/mapper/SealMapper.xml
@@ -3,14 +3,15 @@
         PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
         "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
 <mapper namespace="com.yuanchu.mom.mapper.SealMapper">
-    <select id="selectSeal" resultType="com.yuanchu.mom.mapper.SealMapper">
-        select s.address,s.type,u.`name`,s.create_time
-        from seal s
-            LEFT JOIN `user` u
-                on s.create_user=u.id
+    <select id="selectSeal" resultType="com.yuanchu.mom.pojo.Seal">
+        select * from seal
         <if test="ew.customSqlSegment != null and ew.customSqlSegment != ''">
             ${ew.customSqlSegment}
         </if>
     </select>
-
+    <select id="selectLaboratory" resultType="com.yuanchu.mom.pojo.Laboratory">
+        SELECT *
+        from laboratory
+        WHERE id =#{labId}
+    </select>
 </mapper>
\ No newline at end of file
diff --git a/system-run/src/main/resources/application-dev.yml b/system-run/src/main/resources/application-dev.yml
index 87cdec8..8436085 100644
--- a/system-run/src/main/resources/application-dev.yml
+++ b/system-run/src/main/resources/application-dev.yml
@@ -67,7 +67,7 @@
     # redis绔彛锛堥粯璁や负6379锛�
     port: 6379
     # redis璁块棶瀵嗙爜锛堥粯璁や负绌猴級
-    password: null
+    password: 123456
     # redis杩炴帴瓒呮椂鏃堕棿锛堝崟浣嶆绉掞級
     timeout: 50
     # redis杩炴帴姹犻厤缃�
diff --git a/system-run/src/main/resources/application.yml b/system-run/src/main/resources/application.yml
index cfbe348..648b09f 100644
--- a/system-run/src/main/resources/application.yml
+++ b/system-run/src/main/resources/application.yml
@@ -1,5 +1,5 @@
 server:
-  port: 8002
+  port: 8001
 spring:
   profiles:
     active: dev

--
Gitblit v1.9.3