From 9a16d4675b22d0845158d0f07424f4bda2e39475 Mon Sep 17 00:00:00 2001
From: zss <zss@example.com>
Date: 星期一, 11 九月 2023 18:02:24 +0800
Subject: [PATCH] Merge remote-tracking branch 'origin/master'

---
 system-run/src/main/resources/application-dev.yml                                           |    2 
 inspect-server/src/main/java/com/yuanchu/mom/mapper/InspectUnacceptedMapper.java            |    4 -
 inspect-server/src/main/resources/mapper/InspectUnacceptedMapper.xml                        |   70 ++++++++++++++---------
 inspect-server/src/main/resources/mapper/RawInspectMapper.xml                               |   11 ++-
 inspect-server/src/main/java/com/yuanchu/mom/service/impl/RawInspectServiceImpl.java        |    2 
 inspect-server/src/main/java/com/yuanchu/mom/controller/InspectUnacceptedController.java    |   24 ++++++-
 inspect-server/src/main/java/com/yuanchu/mom/service/impl/RawInsProductServiceImpl.java     |   16 +++--
 inspect-server/src/main/java/com/yuanchu/mom/service/impl/OpinionServiceImpl.java           |    5 +
 inspect-server/src/main/java/com/yuanchu/mom/controller/RawInspectController.java           |    2 
 inspect-server/src/main/java/com/yuanchu/mom/service/InspectUnacceptedService.java          |    5 +
 inspect-server/src/main/java/com/yuanchu/mom/service/impl/InspectUnacceptedServiceImpl.java |   15 ++++-
 11 files changed, 104 insertions(+), 52 deletions(-)

diff --git a/inspect-server/src/main/java/com/yuanchu/mom/controller/InspectUnacceptedController.java b/inspect-server/src/main/java/com/yuanchu/mom/controller/InspectUnacceptedController.java
index 4b0c6ad..9415e88 100644
--- a/inspect-server/src/main/java/com/yuanchu/mom/controller/InspectUnacceptedController.java
+++ b/inspect-server/src/main/java/com/yuanchu/mom/controller/InspectUnacceptedController.java
@@ -28,7 +28,6 @@
  * @author zss
  * @since 2023-08-07 10:04:01
  */
-@Api(tags = "QMS绠$悊-->涓嶅悎鏍煎搧绠$悊")
 @RestController
 @RequestMapping("/inspectUnaccepted")
 public class InspectUnacceptedController {
@@ -42,16 +41,17 @@
     @Autowired
     private OpinionService opinionService;
 
-    @ApiOperation(value = "鏌ヨ鎴愬搧涓嶅悎鏍煎搧妫�楠屽崟鍒楄〃", tags = "QMS绠$悊-->涓嶅悎鏍煎搧绠$悊")
+    @ApiOperation(value = "涓嶅悎鏍煎搧绠$悊鍒楄〃", tags = "QMS绠$悊-->涓嶅悎鏍煎搧绠$悊")
     @ApiImplicitParams(value = {
             @ApiImplicitParam(name = "pageSize",value = "椤垫暟",dataTypeClass  = Integer.class,required = true),
             @ApiImplicitParam(name = "countSize",value = "鏉℃暟/椤�",dataTypeClass  = Integer.class,required = true),
             @ApiImplicitParam(name = "formTime",value = "鏉ユ枡鏃ユ湡",dataTypeClass  = String.class),
-            @ApiImplicitParam(name = "dealState",value = "澶勭悊鐘舵��(涓虹┖=鍏ㄩ儴)",dataTypeClass  = Integer.class)
+            @ApiImplicitParam(name = "dealState",value = "澶勭悊鐘舵��(涓虹┖=鍏ㄩ儴)",dataTypeClass  = Integer.class),
+            @ApiImplicitParam(name = "productCategories",value = "浜у搧澶х被",dataTypeClass  = Integer.class),
     })
     @GetMapping("/selectUnRawInspectsList")
-    public Result<?> selectUnRawInspectsList(int pageSize, int countSize, String formTime, Integer dealState){
-        IPage<Map<String, Object>> inspectionPage = inspectUnacceptedService.selectUnRawInspectsList(new Page<Object>(pageSize, countSize), formTime,dealState);
+    public Result<?> selectUnRawInspectsList(int pageSize, int countSize, String formTime, Integer dealState, Integer productCategories){
+        IPage<Map<String, Object>> inspectionPage = inspectUnacceptedService.selectUnRawInspectsList(new Page<Object>(pageSize, countSize), formTime,dealState, productCategories);
         Map<String, Object> map = new HashMap<>();
         map.put("total", inspectionPage.getTotal());
         map.put("row", inspectionPage.getRecords());
@@ -86,6 +86,20 @@
         return Result.success(map);
     }
 
+    @ApiOperation(value = "璇勫", tags = "QMS绠$悊-->鍘熸潗鏂欎笉鍚堟牸鍝�")
+    @ApiImplicitParams(value = {
+            @ApiImplicitParam(name = "rawId",value = "鍘熸潗鏂橧d",dataTypeClass  = Integer.class,required = true),
+            @ApiImplicitParam(name = "passOrNo",value = "鏄惁閫氳繃锛�0锛氫笉閫氳繃锛�1锛氶�氳繃",dataTypeClass  = Integer.class,required = true)
+    })
+    @PostMapping("/evaluatePassOrNo")
+    public Result<?> rawEvaluate(Integer rawId, Integer passOrNo){
+        Integer integer = inspectUnacceptedService.rawEvaluate(rawId, passOrNo);
+        if (integer >= 1) {
+            return Result.success("璇勫鎴愬姛锛�");
+        }
+        return Result.fail("璇勫澶辫触锛�");
+    }
+
     @ApiOperation(value = "涓嶅悎鏍煎搧鍒嗛〉鍒楄〃", tags = "QMS绠$悊-->涓嶅悎鏍煎搧澶勭疆")
     @ApiImplicitParams(value = {
             @ApiImplicitParam(name = "pageSize",value = "椤垫暟",dataTypeClass  = Integer.class,required = true),
diff --git a/inspect-server/src/main/java/com/yuanchu/mom/controller/RawInspectController.java b/inspect-server/src/main/java/com/yuanchu/mom/controller/RawInspectController.java
index 93f7f02..e5331a8 100644
--- a/inspect-server/src/main/java/com/yuanchu/mom/controller/RawInspectController.java
+++ b/inspect-server/src/main/java/com/yuanchu/mom/controller/RawInspectController.java
@@ -39,7 +39,7 @@
     @PostMapping("/addRawInspects")
     public Result addRawInspects(@RequestHeader("token") String token,@Validated @RequestBody RawInspectVo rawInspectVo) throws Exception {
         Map<String, String> data = JackSonUtil.unmarshal(jwt.readJWT(token).get("data"), Map.class);
-        return Result.success(rawInspectService.addRawInspects(data.get("id").replaceAll("\"", ""), rawInspectVo));
+        return Result.success("鎻愪氦鎴愬姛锛�",rawInspectService.addRawInspects(data.get("id").replaceAll("\"", ""), rawInspectVo));
     }
 
     @ApiOperation(value = "鍒嗛〉鏌ヨ鍘熸潗鏂欐楠屽崟鍒楄〃")
diff --git a/inspect-server/src/main/java/com/yuanchu/mom/mapper/InspectUnacceptedMapper.java b/inspect-server/src/main/java/com/yuanchu/mom/mapper/InspectUnacceptedMapper.java
index 8f9e557..2ab9e78 100644
--- a/inspect-server/src/main/java/com/yuanchu/mom/mapper/InspectUnacceptedMapper.java
+++ b/inspect-server/src/main/java/com/yuanchu/mom/mapper/InspectUnacceptedMapper.java
@@ -16,9 +16,7 @@
 
 
     //鏌ヨ鎴愬搧妫�楠屼腑涓嶅悎鏍煎搧妫�楠屽崟鍒楄〃
-    IPage<Map<String, Object>> selectInsList(Page<Object> page, String formTime, Integer dealState);
-
-
+    IPage<Map<String, Object>> selectInsList(Page<Object> page, String formTime, Integer dealState, Integer productCategories);
 
     IPage<Map<String, Object>> selectUnqualifiedRawMaterials(Page<Object> page, String formTime, String productName, String supplier, Integer processingStatus);
 
diff --git a/inspect-server/src/main/java/com/yuanchu/mom/service/InspectUnacceptedService.java b/inspect-server/src/main/java/com/yuanchu/mom/service/InspectUnacceptedService.java
index 8505445..1bd912b 100644
--- a/inspect-server/src/main/java/com/yuanchu/mom/service/InspectUnacceptedService.java
+++ b/inspect-server/src/main/java/com/yuanchu/mom/service/InspectUnacceptedService.java
@@ -4,6 +4,7 @@
 import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
 import com.baomidou.mybatisplus.extension.service.IService;
 import com.yuanchu.mom.pojo.InspectUnaccepted;
+import com.yuanchu.mom.vo.Result;
 
 import java.util.Map;
 
@@ -22,7 +23,7 @@
      * @param dealState
      * @return
      */
-    IPage<Map<String, Object>> selectUnRawInspectsList(Page<Object> page, String formTime, Integer dealState);
+    IPage<Map<String, Object>> selectUnRawInspectsList(Page<Object> page, String formTime, Integer dealState, Integer productCategories);
 
     /**
      * 鏌ヨ鍘熸潗鏂欎笉鍚堟牸鍝佹楠屽崟鍒楄〃
@@ -52,5 +53,7 @@
      * @return
      */
     Integer descriptionUpdate(Integer rawUnacceptedId, String tell);
+
+    Integer rawEvaluate(Integer rawId, Integer passOrNo);
 }
 
diff --git a/inspect-server/src/main/java/com/yuanchu/mom/service/impl/InspectUnacceptedServiceImpl.java b/inspect-server/src/main/java/com/yuanchu/mom/service/impl/InspectUnacceptedServiceImpl.java
index fd02e38..ea412f4 100644
--- a/inspect-server/src/main/java/com/yuanchu/mom/service/impl/InspectUnacceptedServiceImpl.java
+++ b/inspect-server/src/main/java/com/yuanchu/mom/service/impl/InspectUnacceptedServiceImpl.java
@@ -8,6 +8,7 @@
 import com.yuanchu.mom.mapper.InspectUnacceptedMapper;
 import com.yuanchu.mom.pojo.InspectUnaccepted;
 import com.yuanchu.mom.service.InspectUnacceptedService;
+import com.yuanchu.mom.vo.Result;
 import org.springframework.stereotype.Service;
 
 import javax.annotation.Resource;
@@ -27,8 +28,8 @@
 
     //鏌ヨ鎴愬搧涓嶅悎鏍煎搧妫�楠屽崟鍒楄〃
     @Override
-    public IPage<Map<String, Object>> selectUnRawInspectsList(Page<Object> page, String formTime, Integer dealState) {
-        return inspectUnacceptedMapper.selectInsList(page, formTime, dealState);
+    public IPage<Map<String, Object>> selectUnRawInspectsList(Page<Object> page, String formTime, Integer dealState, Integer productCategories) {
+        return inspectUnacceptedMapper.selectInsList(page, formTime, dealState, productCategories);
     }
 
     @Override
@@ -48,5 +49,13 @@
                 .set(InspectUnaccepted::getTell, tell);
         return inspectUnacceptedMapper.update(new InspectUnaccepted(), updateWrapper);
     }
-}
 
+    @Override
+    public Integer rawEvaluate(Integer rawId, Integer passOrNo) {
+        LambdaUpdateWrapper<InspectUnaccepted> updateWrapper = Wrappers.<InspectUnaccepted>lambdaUpdate()
+                .eq(InspectUnaccepted::getId, rawId)
+                .set(InspectUnaccepted::getDealReasult, passOrNo)
+                .set(InspectUnaccepted::getDealState, passOrNo);
+        return inspectUnacceptedMapper.update(new InspectUnaccepted(), updateWrapper);
+    }
+}
diff --git a/inspect-server/src/main/java/com/yuanchu/mom/service/impl/OpinionServiceImpl.java b/inspect-server/src/main/java/com/yuanchu/mom/service/impl/OpinionServiceImpl.java
index da3dcd9..7f4ba7f 100644
--- a/inspect-server/src/main/java/com/yuanchu/mom/service/impl/OpinionServiceImpl.java
+++ b/inspect-server/src/main/java/com/yuanchu/mom/service/impl/OpinionServiceImpl.java
@@ -8,6 +8,7 @@
 import com.yuanchu.mom.pojo.Opinion;
 import com.yuanchu.mom.mapper.OpinionMapper;
 import com.yuanchu.mom.pojo.dto.UpdateInspectUnacceptedDto;
+import com.yuanchu.mom.service.InspectUnacceptedService;
 import com.yuanchu.mom.service.OpinionService;
 import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
 import com.yuanchu.mom.utils.JackSonUtil;
@@ -33,6 +34,9 @@
 
     @Resource
     private OpinionMapper opinionMapper;
+
+    @Resource
+    private InspectUnacceptedService inspectUnacceptedService;
 
     @Override
     public List<UpdateInspectUnacceptedDto> clickEditingTriggerQuery(Integer rawUnacceptedId) {
@@ -64,6 +68,7 @@
                 throw new RuntimeException(e);
             }
         });
+        MyUtil.PrintLog(list.get(1).getRawUnacceptedId().toString());
         return opinionMapper.updateOpinion(list);
     }
 
diff --git a/inspect-server/src/main/java/com/yuanchu/mom/service/impl/RawInsProductServiceImpl.java b/inspect-server/src/main/java/com/yuanchu/mom/service/impl/RawInsProductServiceImpl.java
index 98ea903..f3be70b 100644
--- a/inspect-server/src/main/java/com/yuanchu/mom/service/impl/RawInsProductServiceImpl.java
+++ b/inspect-server/src/main/java/com/yuanchu/mom/service/impl/RawInsProductServiceImpl.java
@@ -1,15 +1,19 @@
 package com.yuanchu.mom.service.impl;
 
 
+import com.baomidou.mybatisplus.core.conditions.update.LambdaUpdateWrapper;
+import com.baomidou.mybatisplus.core.toolkit.Wrappers;
 import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
 import com.yuanchu.mom.mapper.RawInsProductMapper;
 import com.yuanchu.mom.mapper.RawInspectMapper;
 import com.yuanchu.mom.pojo.RawInsProduct;
 import com.yuanchu.mom.pojo.RawInspect;
 import com.yuanchu.mom.service.RawInsProductService;
+import com.yuanchu.mom.utils.MyUtil;
 import org.springframework.stereotype.Service;
 
 import javax.annotation.Resource;
+import java.sql.Wrapper;
 import java.util.Arrays;
 import java.util.Date;
 import java.util.List;
@@ -64,12 +68,12 @@
     //鍙洿鏀硅澶�,涔嬪墠鐨勬楠屽�煎垹鎺�
     @Override
     public void updateDevByRpId(Integer rpId, Integer devId) {
-        RawInsProduct rawInsProduct = new RawInsProduct();
-        rawInsProduct.setId(rpId);
-        rawInsProduct.setDeviceId(devId);
-        rawInsProduct.setTestValue(null);
-        rawInsProduct.setTestState(null);
-        rawInsProductMapper.updateById(rawInsProduct);
+        LambdaUpdateWrapper<RawInsProduct> updateWrapper = Wrappers.<RawInsProduct>lambdaUpdate()
+                .eq(RawInsProduct::getId, rpId)
+                .set(RawInsProduct::getDeviceId, devId)
+                .set(RawInsProduct::getTestState, null)
+                .set(RawInsProduct::getTestValue, null);
+        rawInsProductMapper.update(new RawInsProduct(), updateWrapper);
     }
 
     /*鍒ゆ柇妫�娴嬪�兼槸鍚︽弧瓒虫爣鍑嗗�煎拰鍐呮帶鍊肩殑瑕佹眰,濡傛灉涓嶆弧瓒冲垯妫�楠岀粨璁轰负涓嶅悎鏍�*/
diff --git a/inspect-server/src/main/java/com/yuanchu/mom/service/impl/RawInspectServiceImpl.java b/inspect-server/src/main/java/com/yuanchu/mom/service/impl/RawInspectServiceImpl.java
index ad82f48..f53b6c8 100644
--- a/inspect-server/src/main/java/com/yuanchu/mom/service/impl/RawInspectServiceImpl.java
+++ b/inspect-server/src/main/java/com/yuanchu/mom/service/impl/RawInspectServiceImpl.java
@@ -93,7 +93,7 @@
         }).collect(Collectors.toList());
         //妫�楠岄」鐩壒閲忔坊鍔�
         rawInsProductService.saveBatch(rawInsProductList);
-        return "鏂板妫�楠屽崟鎴愬姛!";
+        return rawInspect.getId().toString();
     }
 
 
diff --git a/inspect-server/src/main/resources/mapper/InspectUnacceptedMapper.xml b/inspect-server/src/main/resources/mapper/InspectUnacceptedMapper.xml
index 7a3d9b8..724ac00 100644
--- a/inspect-server/src/main/resources/mapper/InspectUnacceptedMapper.xml
+++ b/inspect-server/src/main/resources/mapper/InspectUnacceptedMapper.xml
@@ -6,36 +6,51 @@
     <!--涓嶅悎鏍肩鐞�-->
     <select id="selectInsList" resultType="java.util.Map">
         SELECT ru.id,
-        DATE_FORMAT(fi.create_time, '%Y-%m-%d') dateArrival,
-        reason,
-        material_code,
-        project_name,
+        ru.reason,
         u.`name`,
-        specifications_model,
-        unit,
-        quantity,
-        DATE_FORMAT(fi.create_time, '%Y-%m-%d') inspectionDate,
-        u.name,
-        deal_state,
-        deal_reasult,
-        DATE_FORMAT(fi.update_time, '%Y-%m-%d') processingDate
-        FROM (inspect_unaccepted ru,
-        `user` u)
-        LEFT JOIN finished_inspect fi ON fi.`id` = ru.`raw_inspect_id`
-        where fi.id = ru.raw_inspect_id
-        AND ru.type = 1
+        ru.deal_state,
+        ru.deal_reasult,
+        DATE_FORMAT(fi.dateArrival, '%Y-%m-%d') dateArrival,
+        fi.material_code,
+        fi.project_name,
+        fi.specifications_model,
+        fi.unit,
+        fi.quantity,
+        DATE_FORMAT(fi.inspectionDate, '%Y-%m-%d') inspectionDate,
+        DATE_FORMAT(fi.processingDate, '%Y-%m-%d') processingDate
+        FROM mom_ocean.inspect_unaccepted ru, mom_ocean.`user` u, (
+        SELECT p.id, DATE_FORMAT(p.`create_time`, '%Y-%m-%d') dateArrival, p.`material_code`, p.`material` project_name,
+        p.`specifications_model`,
+        p.`unit`, p.`quantity`,DATE_FORMAT(p.`create_time`, '%Y-%m-%d') inspectionDate, DATE_FORMAT(p.`update_time`,
+        '%Y-%m-%d') processingDate, p.`user_id`, 2 AS
+        classify
+        FROM mom_ocean.process_inspect p
+        WHERE p.`state` = 1
+        UNION ALL
+        SELECT fi.id, DATE_FORMAT(fi.create_time, '%Y-%m-%d')
+        dateArrival,material_code,project_name,specifications_model,
+        unit,quantity,DATE_FORMAT(fi.create_time, '%Y-%m-%d') inspectionDate,DATE_FORMAT(fi.update_time, '%Y-%m-%d')
+        processingDate, fi.`user_id`, 1 AS classify
+        FROM mom_ocean.finished_inspect fi
+        WHERE fi.`state` = 1) fi
+        WHERE fi.id = ru.raw_inspect_id
+        AND ru.`type` = fi.`classify`
+        AND ru.type != 0
         AND ru.state=1
         AND fi.`user_id` = u.`id`
         <if test="dealState!=null">
-            and deal_state = #{dealState}
+            and ru.deal_state = #{dealState}
         </if>
         <if test="formTime!=null and formTime!=''">
-            and fi.create_time=#{formTime}
+            and fi.dateArrival=#{formTime}
+        </if>
+        <if test="productCategories != null">
+            and ru.`type` = #{productCategories}
         </if>
         order by ru.id desc
     </select>
 
-    <!--鍘熸潗鏂欎笉鍚堟牸-->
+    <!--鍘熸潗鏂欎笉鍚堟牸鍝�-->
     <select id="selectUnqualifiedRawMaterials" resultType="map">
         SELECT i.id,
                DATE_FORMAT(r.form_time, '%Y-%m-%d') dateArrival,
@@ -51,8 +66,8 @@
                r.`supplier`,
                i.`deal_state`,
                i.`deal_reasult`
-        FROM inspect_unaccepted i
-                 LEFT JOIN raw_inspect r ON i.`raw_inspect_id` = r.`id`
+        FROM mom_ocean.inspect_unaccepted i
+                 LEFT JOIN mom_ocean.raw_inspect r ON i.`raw_inspect_id` = r.`id`
         WHERE i.`state` = 1
           AND i.`type` = 0
         <if test="formTime != null and formTime != ''">
@@ -74,12 +89,12 @@
     <select id="selectDisposal" resultType="map">
         SELECT i.`id`, s.`type`, s.name productName, s.`specifications`, s.number, i.`tell` description,
         i.`tell` opinions, s.user_name, DATE_FORMAT(i.`create_time`, '%Y-%m-%d') `date`, i.`deal_state`
-        FROM inspect_unaccepted i
+        FROM mom_ocean.inspect_unaccepted i
         LEFT JOIN
         (
             -- 鍘熸潗鏂�
             SELECT 0 AS `type`, r.`name`, r.`specifications`, r.`number`, r.`id`, r.`user_name`
-            FROM raw_inspect r
+            FROM mom_ocean.raw_inspect r
             WHERE r.state = 1
             <if test="specificationModel != null and specificationModel != ''">AND r.`specifications` LIKE CONCAT('%',
                 #{specificationModel}, '%')
@@ -90,7 +105,7 @@
             UNION ALL
             -- 鎴愬搧
             SELECT 1 AS `type`, f.`project_name` `name`, f.`specifications_model` specifications, f.`quantity` `number`, f.`id`, u.name user_name
-            FROM finished_inspect f, `user` u
+            FROM mom_ocean.finished_inspect f, mom_ocean.`user` u
             WHERE f.`state` = 1
               AND u.id = f.user_id
             <if test="specificationModel != null and specificationModel != ''">
@@ -102,7 +117,7 @@
             UNION ALL
             -- 鍗婃垚鍝�
             SELECT 2 AS `type`, p.`material` `name`, p.`specifications_model` specifications, p.`quantity` `number`, p.`id`, u.name user_name
-            FROM process_inspect p, `user` u
+            FROM mom_ocean.process_inspect p, mom_ocean.`user` u
             WHERE p.state = 1
                 AND u.id = p.user_id
             <if test="specificationModel != null and specificationModel != ''">
@@ -113,12 +128,13 @@
             </if>
          )AS s ON s.`id` = i.`raw_inspect_id` AND s.`type` = i.type
         WHERE i.`state` = 1
+          AND i.`deal_reasult` = 0
         <if test="state != null">
             AND i.`deal_state` = #{state}
         </if>
         <if test="productCategories != null">
             AND s.`type` = #{productCategories}
         </if>
-        ORDER BY i.id DESC
+        ORDER BY i.`update_time` DESC
     </select>
 </mapper>
diff --git a/inspect-server/src/main/resources/mapper/RawInspectMapper.xml b/inspect-server/src/main/resources/mapper/RawInspectMapper.xml
index eae9690..985266e 100644
--- a/inspect-server/src/main/resources/mapper/RawInspectMapper.xml
+++ b/inspect-server/src/main/resources/mapper/RawInspectMapper.xml
@@ -56,14 +56,15 @@
         <if test="name!=null and name!=''">
             and name like concat('%',#{name},'%')
         </if>
+        ORDER BY id DESC
     </select>
 
     <!--鏍规嵁鍘熸潗鏂欐楠屽崟id鏌ョ湅璇︽儏-->
     <resultMap id="oneMap" type="map">
-        <id property="rcode" column="rcode"/>
+        <id property="code" column="rcode"/>
         <result property="formTime" column="formTime"/>
         <result property="creatTime" column="creatTime"/>
-        <result property="rname" column="rname"/>
+        <result property="name" column="rname"/>
         <result property="specifications" column="specifications"/>
         <result property="runit" column="runit"/>
         <result property="number" column="number"/>
@@ -72,7 +73,7 @@
         <result property="userName" column="user_name"/>
         <collection property="children" resultMap="twoMap" javaType="List"/>
     </resultMap>
-    <resultMap id="twoMap" type="map">
+    <resultMap id="twoMap" type="Map">
         <id property="rpId" column="rpId"/>
         <result property="rpName" column="rpName"/>
         <result property="rpUnit" column="rpUnit"/>
@@ -80,7 +81,8 @@
         <result property="internal" column="internal"/>
         <result property="testValue" column="test_value"/>
         <result property="testState" column="test_state"/>
-        <result property="devName" column="devName"/>
+        <result property="deviceName" column="devName"/>
+        <result property="deviceId" column="deviceId"/>
         <result property="uName" column="uName"/>
     </resultMap>
 
@@ -103,6 +105,7 @@
                test_value,
                test_state,
                device.name                            devName,
+               device.`id`                            deviceId,
                user.name                              uName
         from mom_ocean.raw_ins_product rp
                  left join mom_ocean.raw_inspect r on rp.raw_inspect_id = r.id
diff --git a/system-run/src/main/resources/application-dev.yml b/system-run/src/main/resources/application-dev.yml
index 7eb7e36..ecbb862 100644
--- a/system-run/src/main/resources/application-dev.yml
+++ b/system-run/src/main/resources/application-dev.yml
@@ -5,7 +5,7 @@
 logging:
   config: classpath:logback-spring.xml
   # 鏃ュ織瀛樺偍璺緞+++++++++++++++++++++++++++杩愮淮闇�瑕侀厤缃�+++++++++++++++++++++++++++
-  file-location:
+  file-location: /abc
 
 # 鏁版嵁搴撳浠借矾寰�
 backup:

--
Gitblit v1.9.3