From f9feae49eee21286708bcef1cea91be34d9e9241 Mon Sep 17 00:00:00 2001
From: “djh” <“3298565835@qq.com”>
Date: 星期二, 25 十一月 2025 09:04:59 +0800
Subject: [PATCH] 修改新增

---
 multi-system/src/main/java/com/gkhy/exam/system/domain/ProjectDocument.java                            |   50 ++++++++++
 multi-system/src/main/resources/mapper/system/ProjectDocumentMapper.xml                                |   30 ++++++
 multi-system/src/main/resources/mapper/system/UseSealApplyFlowMapper.xml                               |    4 
 multi-system/src/main/java/com/gkhy/exam/system/service/impl/CatalogueServiceImpl.java                 |   19 +++
 multi-system/src/main/resources/mapper/system/CatalogueMapper.xml                                      |    3 
 multi-system/src/main/java/com/gkhy/exam/system/mapper/ProjectDocumentMapper.java                      |   15 +++
 multi-system/src/main/java/com/gkhy/exam/system/domain/Catalogue.java                                  |   12 ++
 multi-system/src/main/java/com/gkhy/exam/system/domain/UseSealApplyFlow.java                           |    4 
 multi-system/src/main/java/com/gkhy/exam/system/service/ProjectDocumentService.java                    |   16 +++
 multi-system/src/main/java/com/gkhy/exam/system/service/useSealApply/impl/UseSealApplyServiceImpl.java |    6 +
 multi-system/src/main/java/com/gkhy/exam/system/domain/req/CatalogueReq.java                           |    1 
 multi-system/src/main/java/com/gkhy/exam/system/service/CatalogueService.java                          |    2 
 multi-system/src/main/java/com/gkhy/exam/system/service/impl/ProjectDocumentServiceImpl.java           |   60 ++++++++++++
 multi-system/src/main/java/com/gkhy/exam/system/domain/vo/CatalogueVo.java                             |    6 +
 multi-admin/src/main/java/com/gkhy/exam/admin/controller/web/QualityController.java                    |   49 ++++++++-
 multi-system/src/main/java/com/gkhy/exam/system/domain/req/CatalogueProjectDocumentReq.java            |   14 ++
 16 files changed, 285 insertions(+), 6 deletions(-)

diff --git a/multi-admin/src/main/java/com/gkhy/exam/admin/controller/web/QualityController.java b/multi-admin/src/main/java/com/gkhy/exam/admin/controller/web/QualityController.java
index 8c532ea..982185e 100644
--- a/multi-admin/src/main/java/com/gkhy/exam/admin/controller/web/QualityController.java
+++ b/multi-admin/src/main/java/com/gkhy/exam/admin/controller/web/QualityController.java
@@ -43,6 +43,9 @@
     @Autowired
     private ItemReviewService itemReviewService;
 
+    @Autowired
+    private ProjectDocumentService projectDocumentService;
+
 
     /**
      * 质量目标列表
@@ -207,11 +210,11 @@
 
 
     /**
-     * 质量管理体系运行列表
+     * 目录数据
      * @param catalogueReq
      * @return
      */
-    @ApiOperation(value = "质量管理体系运行列表")
+    @ApiOperation(value = "目录数据列表")
     @GetMapping("/catalogue/list")
     public CommonResult listCatalogue(CatalogueReq catalogueReq){
         return CommonResult.success(catalogueService.selectCatalogueList(catalogueReq));
@@ -223,7 +226,7 @@
      * @param catalogue
      * @return
      */
-    @ApiOperation(value = "质量管理体系运行新增")
+    @ApiOperation(value = "目录数据新增")
     @PostMapping("/catalogue/insert")
     public CommonResult insertCatalogue(@RequestBody Catalogue catalogue){
         return catalogueService.insertCatalogue(catalogue);
@@ -245,7 +248,7 @@
      * @param catalogue
      * @return
      */
-    @ApiOperation(value = "质量管理体系运行修改")
+    @ApiOperation(value = "目录数据修改")
     @PostMapping("/catalogue/update")
     public CommonResult updateCatalogue(@RequestBody Catalogue catalogue){
         return catalogueService.updateCatalogue(catalogue);
@@ -256,7 +259,7 @@
      * @param catalogueId
      * @return
      */
-    @ApiOperation(value = "质量管理体系运行删除")
+    @ApiOperation(value = "目录数据删除")
     @GetMapping("/catalogue/deleted")
     public CommonResult deletedCatalogue(@RequestParam("catalogueId") Integer catalogueId){
         return catalogueService.deletedCatalogue(catalogueId);
@@ -518,4 +521,40 @@
     }
 
 
+    /**
+     * 项目文档新增
+     * @param projectDocument
+     * @return
+     */
+    @ApiOperation(value = "项目文档新增")
+    @PostMapping("/project/insert")
+    public CommonResult insertProjectDocument(@RequestBody CatalogueProjectDocumentReq projectDocument){
+        return projectDocumentService.insertprojectDocument(projectDocument);
+    }
+
+    /**
+     * 项目文档修改
+     * @param projectDocument
+     * @return
+     */
+    @ApiOperation(value = "项目文档修改")
+    @PostMapping("/project/update")
+    public CommonResult updateProjectDocument(@RequestBody CatalogueProjectDocumentReq projectDocument){
+        return projectDocumentService.updateprojectDocument(projectDocument);
+    }
+
+
+    /**
+     * 目录文档数据
+     * @param catalogueReq
+     * @return
+     */
+    @ApiOperation(value = "目录文档数据列表")
+    @GetMapping("/document/list")
+    public CommonResult listProjectDocument(CatalogueReq catalogueReq){
+        return CommonResult.success(catalogueService.selectCatalogueDocumentList(catalogueReq));
+    }
+
+
+
 }
diff --git a/multi-system/src/main/java/com/gkhy/exam/system/domain/Catalogue.java b/multi-system/src/main/java/com/gkhy/exam/system/domain/Catalogue.java
index c87bf16..e74e289 100644
--- a/multi-system/src/main/java/com/gkhy/exam/system/domain/Catalogue.java
+++ b/multi-system/src/main/java/com/gkhy/exam/system/domain/Catalogue.java
@@ -46,6 +46,18 @@
     @TableField(value = "sort")
     private Integer sort;
 
+    @ApiModelProperty("模版文件名称")
+    @TableField(value = "file_name")
+    private String fileName;
+
+    @ApiModelProperty("模版文件路径")
+    @TableField(value = "file_path")
+    private String filePath;
+
+    @ApiModelProperty("是否上传文件")
+    @TableField(value = "is_file")
+    private Integer isFile;
+
     @TableField(value = "del_flag")
     private Integer delFlag;
 
diff --git a/multi-system/src/main/java/com/gkhy/exam/system/domain/ProjectDocument.java b/multi-system/src/main/java/com/gkhy/exam/system/domain/ProjectDocument.java
new file mode 100644
index 0000000..6b0de29
--- /dev/null
+++ b/multi-system/src/main/java/com/gkhy/exam/system/domain/ProjectDocument.java
@@ -0,0 +1,50 @@
+package com.gkhy.exam.system.domain;
+
+import com.baomidou.mybatisplus.annotation.IdType;
+import com.baomidou.mybatisplus.annotation.TableField;
+import com.baomidou.mybatisplus.annotation.TableId;
+import com.baomidou.mybatisplus.annotation.TableName;
+import io.swagger.annotations.ApiModel;
+import io.swagger.annotations.ApiModelProperty;
+import lombok.Getter;
+import lombok.Setter;
+
+@Getter
+@Setter
+@TableName("project_document")
+@ApiModel(value = "projectDocument",description = "项目文档")
+public class ProjectDocument {
+
+    @ApiModelProperty("主键")
+    @TableId(value = "id", type = IdType.AUTO)
+    private Integer id;
+
+    @TableField("company_id")
+    private Integer companyId;
+
+    @ApiModelProperty(value = "项目id")
+    @TableField("catalogue_id")
+    private Integer catalogueId;
+
+    @ApiModelProperty(value = "项目id")
+    @TableField("item_id")
+    private Integer itemId;
+
+    @ApiModelProperty(value = "项目id")
+    @TableField("file_name")
+    private String fileName;
+
+    @ApiModelProperty(value = "项目id")
+    @TableField("file_path")
+    private String filePath;
+
+    private Integer del_flag;
+
+
+
+
+
+
+
+
+}
diff --git a/multi-system/src/main/java/com/gkhy/exam/system/domain/UseSealApplyFlow.java b/multi-system/src/main/java/com/gkhy/exam/system/domain/UseSealApplyFlow.java
index c21038d..9b5c792 100644
--- a/multi-system/src/main/java/com/gkhy/exam/system/domain/UseSealApplyFlow.java
+++ b/multi-system/src/main/java/com/gkhy/exam/system/domain/UseSealApplyFlow.java
@@ -49,6 +49,10 @@
     @TableField("approve_content")
     private String approveContent;
 
+    @ApiModelProperty(value = "审批意见")
+    @TableField("approve_mess")
+    private String approveMess;
+
     @ApiModelProperty(value = "审批时间")
     @TableField("approve_time")
     @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
diff --git a/multi-system/src/main/java/com/gkhy/exam/system/domain/req/CatalogueProjectDocumentReq.java b/multi-system/src/main/java/com/gkhy/exam/system/domain/req/CatalogueProjectDocumentReq.java
new file mode 100644
index 0000000..8992e2d
--- /dev/null
+++ b/multi-system/src/main/java/com/gkhy/exam/system/domain/req/CatalogueProjectDocumentReq.java
@@ -0,0 +1,14 @@
+package com.gkhy.exam.system.domain.req;
+
+import com.gkhy.exam.system.domain.ProjectDocument;
+import lombok.Data;
+
+import java.util.List;
+
+@Data
+public class CatalogueProjectDocumentReq {
+    private Integer companyId;
+    private Integer catalogueId;
+    private Integer itemId;
+    private List<ProjectDocument> projectDocuments;
+}
diff --git a/multi-system/src/main/java/com/gkhy/exam/system/domain/req/CatalogueReq.java b/multi-system/src/main/java/com/gkhy/exam/system/domain/req/CatalogueReq.java
index 2cbe820..3593377 100644
--- a/multi-system/src/main/java/com/gkhy/exam/system/domain/req/CatalogueReq.java
+++ b/multi-system/src/main/java/com/gkhy/exam/system/domain/req/CatalogueReq.java
@@ -9,4 +9,5 @@
     private Integer catalogueId;
     private Integer companyId;
     private Integer number;
+    private Integer itemId;
 }
diff --git a/multi-system/src/main/java/com/gkhy/exam/system/domain/vo/CatalogueVo.java b/multi-system/src/main/java/com/gkhy/exam/system/domain/vo/CatalogueVo.java
index 8a39063..40bc80d 100644
--- a/multi-system/src/main/java/com/gkhy/exam/system/domain/vo/CatalogueVo.java
+++ b/multi-system/src/main/java/com/gkhy/exam/system/domain/vo/CatalogueVo.java
@@ -1,5 +1,6 @@
 package com.gkhy.exam.system.domain.vo;
 
+import com.gkhy.exam.system.domain.ProjectDocument;
 import lombok.Data;
 
 import java.util.List;
@@ -17,9 +18,14 @@
     private String mess;
     private Integer type;
     private Integer sort;
+    private String fileName;
+    private String filePath;
+    private Integer isFile;
 
     private Integer delFlag;
+    private List<ProjectDocument> projectDocuments;
 
     private List<CatalogueVo> children;
 
+
 }
diff --git a/multi-system/src/main/java/com/gkhy/exam/system/mapper/ProjectDocumentMapper.java b/multi-system/src/main/java/com/gkhy/exam/system/mapper/ProjectDocumentMapper.java
new file mode 100644
index 0000000..fc9c745
--- /dev/null
+++ b/multi-system/src/main/java/com/gkhy/exam/system/mapper/ProjectDocumentMapper.java
@@ -0,0 +1,15 @@
+package com.gkhy.exam.system.mapper;
+
+import com.baomidou.mybatisplus.core.mapper.BaseMapper;
+import com.gkhy.exam.system.domain.ProjectDocument;
+import org.apache.ibatis.annotations.Param;
+import org.mapstruct.Mapper;
+
+import java.util.List;
+
+@Mapper
+public interface ProjectDocumentMapper extends BaseMapper<ProjectDocument> {
+    Integer insertBaths(@Param("projectDocuments") List<ProjectDocument> projectDocuments);
+
+    List<ProjectDocument> selectDocumentList(@Param("companyId") Integer companyId, @Param("itemId") Integer itemId, @Param("catalogueId") Integer catalogueId);
+}
diff --git a/multi-system/src/main/java/com/gkhy/exam/system/service/CatalogueService.java b/multi-system/src/main/java/com/gkhy/exam/system/service/CatalogueService.java
index b4f6be0..c3fad52 100644
--- a/multi-system/src/main/java/com/gkhy/exam/system/service/CatalogueService.java
+++ b/multi-system/src/main/java/com/gkhy/exam/system/service/CatalogueService.java
@@ -37,4 +37,6 @@
     CommonResult selectCatalogueDataFileList(CatalogueReq catalogueReq);
 
     CommonResult copyCatalogue(List<CatalogueVo> catalogue);
+
+    CommonResult selectCatalogueDocumentList(CatalogueReq catalogueReq);
 }
diff --git a/multi-system/src/main/java/com/gkhy/exam/system/service/ProjectDocumentService.java b/multi-system/src/main/java/com/gkhy/exam/system/service/ProjectDocumentService.java
new file mode 100644
index 0000000..48d2886
--- /dev/null
+++ b/multi-system/src/main/java/com/gkhy/exam/system/service/ProjectDocumentService.java
@@ -0,0 +1,16 @@
+package com.gkhy.exam.system.service;
+
+import com.baomidou.mybatisplus.extension.service.IService;
+import com.gkhy.exam.common.api.CommonResult;
+import com.gkhy.exam.system.domain.ProjectDocument;
+import com.gkhy.exam.system.domain.req.CatalogueProjectDocumentReq;
+
+import java.util.List;
+
+public interface ProjectDocumentService extends IService<ProjectDocument> {
+    CommonResult insertprojectDocument(CatalogueProjectDocumentReq projectDocument);
+
+    List<ProjectDocument> selectList(Integer companyId, Integer itemId, Integer catalogueId);
+
+    CommonResult updateprojectDocument(CatalogueProjectDocumentReq projectDocument);
+}
diff --git a/multi-system/src/main/java/com/gkhy/exam/system/service/impl/CatalogueServiceImpl.java b/multi-system/src/main/java/com/gkhy/exam/system/service/impl/CatalogueServiceImpl.java
index 8579fe1..40c4f0f 100644
--- a/multi-system/src/main/java/com/gkhy/exam/system/service/impl/CatalogueServiceImpl.java
+++ b/multi-system/src/main/java/com/gkhy/exam/system/service/impl/CatalogueServiceImpl.java
@@ -16,6 +16,7 @@
 import com.gkhy.exam.system.mapper.ProductItemMapper;
 import com.gkhy.exam.system.mapper.SysCompanyMapper;
 import com.gkhy.exam.system.service.CatalogueService;
+import com.gkhy.exam.system.service.ProjectDocumentService;
 import com.gkhy.exam.system.service.SysCompanyService;
 import org.springframework.beans.BeanUtils;
 import org.springframework.beans.factory.annotation.Autowired;
@@ -38,6 +39,8 @@
     private CompanyIndustryTemplateMapper companyIndustryTemplateMapper;
     @Autowired
     private ProductItemMapper productItemMapper;
+    @Autowired
+    private ProjectDocumentService projectDocumentService;
 
     /**
      * 目录管理
@@ -262,6 +265,22 @@
         return CommonResult.success();
     }
 
+    @Override
+    public CommonResult selectCatalogueDocumentList(CatalogueReq catalogueReq) {
+        List<CatalogueVo> catalogueVos = catalogueMapper.selectCatalogueList(catalogueReq);
+        for (CatalogueVo catalogueVo : catalogueVos) {
+            List<ProjectDocument> projectDocuments = projectDocumentService.selectList(catalogueVo.getCompanyId(), catalogueReq.getItemId(), catalogueVo.getId());
+            catalogueVo.setProjectDocuments(projectDocuments);
+        }
+
+        List<CatalogueVo> collect = catalogueVos.stream().filter(catalogueVo -> catalogueVo.getParentId() == 0).collect(Collectors.toList());
+        for (CatalogueVo catalogueVo : collect) {
+            List<CatalogueVo> getchildren = getchildren(catalogueVo, catalogueVos);
+            catalogueVo.setChildren(getchildren);
+        }
+        return CommonResult.success(collect);
+    }
+
     private void saveCatalogue(List<CatalogueVo> children,Catalogue catalogue) {
         for (CatalogueVo child : children) {
             Catalogue catalogue1 = new Catalogue();
diff --git a/multi-system/src/main/java/com/gkhy/exam/system/service/impl/ProjectDocumentServiceImpl.java b/multi-system/src/main/java/com/gkhy/exam/system/service/impl/ProjectDocumentServiceImpl.java
new file mode 100644
index 0000000..a4db4b6
--- /dev/null
+++ b/multi-system/src/main/java/com/gkhy/exam/system/service/impl/ProjectDocumentServiceImpl.java
@@ -0,0 +1,60 @@
+package com.gkhy.exam.system.service.impl;
+
+import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
+import com.gkhy.exam.common.api.CommonResult;
+import com.gkhy.exam.system.domain.ProductItem;
+import com.gkhy.exam.system.domain.ProjectDocument;
+import com.gkhy.exam.system.domain.req.CatalogueProjectDocumentReq;
+import com.gkhy.exam.system.mapper.ProjectDocumentMapper;
+import com.gkhy.exam.system.service.ProjectDocumentService;
+import org.springframework.beans.factory.annotation.Autowired;
+import org.springframework.stereotype.Service;
+
+import java.util.HashMap;
+import java.util.List;
+import java.util.Map;
+import java.util.Objects;
+
+@Service
+public class ProjectDocumentServiceImpl extends ServiceImpl<ProjectDocumentMapper, ProjectDocument> implements ProjectDocumentService {
+
+    @Autowired
+    private ProjectDocumentMapper projectDocumentMapper;
+
+    @Override
+    public CommonResult insertprojectDocument(CatalogueProjectDocumentReq projectDocument) {
+        List<ProjectDocument> projectDocuments = projectDocument.getProjectDocuments();
+        for (ProjectDocument document : projectDocuments) {
+            document.setCompanyId(projectDocument.getCompanyId());
+            document.setCatalogueId(projectDocument.getCatalogueId());
+            document.setItemId(projectDocument.getItemId());
+        }
+        Integer i = projectDocumentMapper.insertBaths(projectDocuments);
+        return CommonResult.success();
+    }
+
+    @Override
+    public List<ProjectDocument> selectList(Integer companyId, Integer itemId, Integer catalogueId) {
+        return projectDocumentMapper.selectDocumentList(companyId,itemId,catalogueId);
+    }
+
+    @Override
+    public CommonResult updateprojectDocument(CatalogueProjectDocumentReq projectDocument) {
+        Map<String, Object> stringObjectsHashMap = new HashMap<>();
+        stringObjectsHashMap.put("company_id",projectDocument.getCompanyId());
+        stringObjectsHashMap.put("catalogue_id",projectDocument.getCatalogueId());
+        stringObjectsHashMap.put("item_id",projectDocument.getItemId());
+        int update = projectDocumentMapper.deleteByMap(stringObjectsHashMap);
+        if (update<=0){
+            return CommonResult.failed("修改失败");
+        }
+        List<ProjectDocument> projectDocuments = projectDocument.getProjectDocuments();
+        for (ProjectDocument document : projectDocuments) {
+            document.setCompanyId(projectDocument.getCompanyId());
+            document.setCatalogueId(projectDocument.getCatalogueId());
+            document.setItemId(projectDocument.getItemId());
+        }
+        Integer i = projectDocumentMapper.insertBaths(projectDocuments);
+        return CommonResult.success();
+    }
+}
diff --git a/multi-system/src/main/java/com/gkhy/exam/system/service/useSealApply/impl/UseSealApplyServiceImpl.java b/multi-system/src/main/java/com/gkhy/exam/system/service/useSealApply/impl/UseSealApplyServiceImpl.java
index ff20781..52a4a78 100644
--- a/multi-system/src/main/java/com/gkhy/exam/system/service/useSealApply/impl/UseSealApplyServiceImpl.java
+++ b/multi-system/src/main/java/com/gkhy/exam/system/service/useSealApply/impl/UseSealApplyServiceImpl.java
@@ -6,6 +6,7 @@
 import com.gkhy.exam.common.exception.ApiException;
 import com.gkhy.exam.common.utils.PageUtils;
 import com.gkhy.exam.common.utils.SecurityUtils;
+import com.gkhy.exam.common.utils.StringUtils;
 import com.gkhy.exam.system.domain.UseSealApply;
 import com.gkhy.exam.system.domain.UseSealApplyFile;
 import com.gkhy.exam.system.domain.UseSealApplyFlow;
@@ -62,7 +63,7 @@
             List<UseSealApplyFlow> flows = useSealApply.getFlows();
             for (UseSealApplyFlow flow : flows) {
                 flow.setUseSealId(useSealApply.getId());
-                if (flow.getApproveUserId().equals(useSealApply.getApplyUserId())){
+                if (flow.getApproveUserId().equals(useSealApply.getApplyUserId()) && flow.getFlowName().equals("申请人")){
                     flow.setStatus(2);
                 }else {
                     flow.setStatus(1);
@@ -124,6 +125,9 @@
         if (useSealApplyFlow.getApproveStatus()==null){
             return CommonResult.failed("审批意见不可为空");
         }
+        if (StringUtils.isEmpty(useSealApplyFlow.getApproveMess())){
+            return CommonResult.failed("审批意见不可为空");
+        }
         if (useSealApplyFlow.getApproveStatus()==1){
             useSealApplyFlow.setApproveContent("同意");
         }else {
diff --git a/multi-system/src/main/resources/mapper/system/CatalogueMapper.xml b/multi-system/src/main/resources/mapper/system/CatalogueMapper.xml
index c5f921f..eb12005 100644
--- a/multi-system/src/main/resources/mapper/system/CatalogueMapper.xml
+++ b/multi-system/src/main/resources/mapper/system/CatalogueMapper.xml
@@ -102,6 +102,9 @@
             `number`,
             `mess`,
             `type`,
+            `file_name`,
+            `file_path`,
+            `is_file`,
             `del_flag`,
             `sort`,
             `create_by`,
diff --git a/multi-system/src/main/resources/mapper/system/ProjectDocumentMapper.xml b/multi-system/src/main/resources/mapper/system/ProjectDocumentMapper.xml
new file mode 100644
index 0000000..6887d94
--- /dev/null
+++ b/multi-system/src/main/resources/mapper/system/ProjectDocumentMapper.xml
@@ -0,0 +1,30 @@
+<?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.gkhy.exam.system.mapper.ProjectDocumentMapper">
+
+    <insert id="insertBaths">
+        INSERT INTO `project_document`
+            (`company_id`, `catalogue_id`, `item_id`, `file_name`, `file_path` )
+        VALUES
+            <foreach collection="projectDocuments" separator="," item="item">
+                ( #{item.companyId}, #{item.catalogueId}, #{item.itemId}, #{item.fileName}, #{item.filePath} )
+            </foreach>
+
+    </insert>
+    <select id="selectDocumentList" resultType="com.gkhy.exam.system.domain.ProjectDocument">
+        SELECT
+            `id`,
+            `company_id`,
+            `catalogue_id`,
+            `item_id`,
+            `file_name`,
+            `file_path`,
+            `del_flag`
+        FROM
+            `project_document`
+        where del_flag = 1
+        and company_id = #{companyId}
+        and catalogue_id = #{catalogueId}
+        and item_id = #{itemId}
+    </select>
+</mapper>
diff --git a/multi-system/src/main/resources/mapper/system/UseSealApplyFlowMapper.xml b/multi-system/src/main/resources/mapper/system/UseSealApplyFlowMapper.xml
index b26e6ba..0d300f4 100644
--- a/multi-system/src/main/resources/mapper/system/UseSealApplyFlowMapper.xml
+++ b/multi-system/src/main/resources/mapper/system/UseSealApplyFlowMapper.xml
@@ -21,6 +21,7 @@
         UPDATE `use_seal_apply_flow`
         SET
             `approve_content` = #{approveContent},
+            `approve_mess` = #{approveMess},
             `approve_time` = #{approveTime},
             `approve_status` = #{approveStatus},
             `status` = #{status}
@@ -41,6 +42,7 @@
             usaf.`approve_dept_id`,
             sd.	`dept_name` as approve_dept_name,
             usaf.`approve_content`,
+            usaf.`approve_mess`,
             usaf.`approve_time`,
             usaf.`approve_status`,
             usaf.`status`
@@ -58,6 +60,7 @@
             `approve_user_id`,
             `approve_dept_id`,
             `approve_content`,
+            `approve_mess`,
             `approve_time`,
             `approve_status`,
             `status`
@@ -74,6 +77,7 @@
         usaf.`approve_user_id`,
         usaf.`approve_dept_id`,
         usaf.`approve_content`,
+        usaf.`approve_mess`,
         usaf.`approve_time`,
         usaf.`approve_status`,
         usaf.`status`

--
Gitblit v1.9.2