From 19b96e1b86b3ffd8a75de1bcf95bcbce85fb36e8 Mon Sep 17 00:00:00 2001
From: lidongdong <1459917685@qq.com>
Date: 星期三, 23 十一月 2022 18:21:32 +0800
Subject: [PATCH] 其他附件管理列表接口新增 创建人字段

---
 flower_city/src/main/java/com/dg/core/db/gen/entity/ElseAccessoryEntity.java |    2 +-
 flower_city/src/main/resources/mapper/ElseAccessoryMapper.xml                |    8 ++++++--
 2 files changed, 7 insertions(+), 3 deletions(-)

diff --git a/flower_city/src/main/java/com/dg/core/db/gen/entity/ElseAccessoryEntity.java b/flower_city/src/main/java/com/dg/core/db/gen/entity/ElseAccessoryEntity.java
index a1834f0..9b8c94c 100644
--- a/flower_city/src/main/java/com/dg/core/db/gen/entity/ElseAccessoryEntity.java
+++ b/flower_city/src/main/java/com/dg/core/db/gen/entity/ElseAccessoryEntity.java
@@ -69,7 +69,7 @@
     /**
      * 创建人id
      */
-    @ApiModelProperty(name = "id", value = "创建人id")
+    @ApiModelProperty(name = "createUserId", value = "创建人id")
     private String createUserId;
 
     /**
diff --git a/flower_city/src/main/resources/mapper/ElseAccessoryMapper.xml b/flower_city/src/main/resources/mapper/ElseAccessoryMapper.xml
index 21f64e4..802bbec 100644
--- a/flower_city/src/main/resources/mapper/ElseAccessoryMapper.xml
+++ b/flower_city/src/main/resources/mapper/ElseAccessoryMapper.xml
@@ -4,6 +4,7 @@
 
     <resultMap type="com.dg.core.db.gen.entity.ElseAccessoryEntity" id="ElseAccessoryEntityResult">
         <id     property="id"      column="id"      />
+        <id     property="createUserId"      column="create_user_id"      />
         <id     property="departmentId"      column="department_id"      />
         <id     property="createTime"      column="create_time"      />
         <id     property="updateTime"      column="update_time"      />
@@ -19,7 +20,9 @@
             (select organization_name from automessage_organization_chart where automessage_organization_chart.id=automessage_else_accessory.department_id) as departmentName,
             create_time,
             update_time,
-            (select user_name from automessage_sys_user where automessage_sys_user.user_id=create_user_id) as createUserName,
+            create_user_id,
+            (select automessage_sys_user.user_name from automessage_sys_user where
+             automessage_sys_user.user_id=automessage_else_accessory.create_user_id) as createUserName,
             url,
             name
         FROM
@@ -30,7 +33,8 @@
         SELECT
         id,
         department_id,
-        (select organization_name from automessage_organization_chart where automessage_organization_chart.id=automessage_else_accessory.department_id) as departmentName,
+        (select automessage_sys_user.user_name from automessage_sys_user where
+            automessage_sys_user.user_id=automessage_else_accessory.create_user_id) as createUserName,
         create_time,
         update_time,
         url,

--
Gitblit v1.7.1