其他附件管理列表接口新增 创建人字段

lidongdong

2022-11-23 2244c1ff307fc310cc59da3183b99afa2c808994

其他附件管理列表接口新增 创建人字段

 flower_city/src/main/resources/mapper/ElseAccessoryMapper.xml

@@ -4,7 +4,6 @@

    <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"      />
@@ -20,9 +19,7 @@
            (select organization_name from automessage_organization_chart where automessage_organization_chart.id=automessage_else_accessory.department_id) as departmentName,
            create_time,
            update_time,
            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,
            (select automessage_sys_user.user_name from automessage_sys_user where automessage_sys_user.user_id=automessage_sys_user.create_user_id) as createUserName,
            url,
            name
        FROM
@@ -33,14 +30,14 @@
        SELECT
        id,
        department_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,
        (select organization_name from automessage_organization_chart where automessage_organization_chart.id=automessage_else_accessory.department_id) as departmentName,
        create_time,
        update_time,
        url,
        name,
        create_user_id,
        (select user_name from automessage_sys_user where automessage_sys_user.user_id=create_user_id) as createUserName,
        (select automessage_sys_user.user_name from automessage_sys_user where
        automessage_sys_user.user_id=automessage_else_accessory.create_user_id) as createUserName,
        <if test="userId!=null and userId!=''">
        (case create_user_id when  #{userId} then 1 else 0 end)isDelete
        </if>