diff options
| author | zhangshuai <[email protected]> | 2024-09-06 10:31:28 +0800 |
|---|---|---|
| committer | zhangshuai <[email protected]> | 2024-09-06 10:31:28 +0800 |
| commit | 69f09467753c8a8b8911328e0982d586ded17906 (patch) | |
| tree | ce031bcadcea2ffe6ab91cca385197fcf3923aea | |
| parent | d1f0ec1a582c69c52ebfe390b551a608c435a077 (diff) | |
fix: application&role接口返回 用户 userName 信息
3 files changed, 13 insertions, 3 deletions
diff --git a/src/main/resources/db/mapper/app/ApplicationMapper.xml b/src/main/resources/db/mapper/app/ApplicationMapper.xml index e3ade91..315215f 100644 --- a/src/main/resources/db/mapper/app/ApplicationMapper.xml +++ b/src/main/resources/db/mapper/app/ApplicationMapper.xml @@ -22,11 +22,13 @@ <association property="createUser" columnPrefix="cu_" javaType="net.geedge.asw.module.sys.entity.SysUserEntity"> <id property="id" column="id"/> <result property="name" column="name"/> + <result property="userName" column="user_name"/> </association> <association property="updateUser" columnPrefix="uu_" javaType="net.geedge.asw.module.sys.entity.SysUserEntity"> <id property="id" column="id"/> <result property="name" column="name"/> + <result property="userName" column="user_name"/> </association> </resultMap> @@ -35,8 +37,10 @@ app.*, cu.id as cu_id, cu.name as cu_name, + cu.user_name as cu_user_name, uu.id as uu_id, - uu.name as uu_name + uu.name as uu_name, + uu.user_name as uu_user_name FROM application app left join sys_user cu on app.create_user_id = cu.id diff --git a/src/main/resources/db/mapper/app/ApplicationSignatureMapper.xml b/src/main/resources/db/mapper/app/ApplicationSignatureMapper.xml index 441ba8c..113afc2 100644 --- a/src/main/resources/db/mapper/app/ApplicationSignatureMapper.xml +++ b/src/main/resources/db/mapper/app/ApplicationSignatureMapper.xml @@ -13,6 +13,7 @@ <association property="createUser" columnPrefix="c_" javaType="net.geedge.asw.module.sys.entity.SysUserEntity"> <id property="id" column="id"/> <result property="name" column="name"/> + <result property="userName" column="user_name"/> </association> </resultMap> @@ -20,7 +21,8 @@ SELECT asg.*, cu.id as c_id, - cu.name as c_name + cu.name as c_name, + cu.user_name as c_user_name, FROM application_signature asg left join sys_user cu on asg.create_user_id = cu.id diff --git a/src/main/resources/db/mapper/sys/SysRoleMapper.xml b/src/main/resources/db/mapper/sys/SysRoleMapper.xml index 8f569ef..2a4076c 100644 --- a/src/main/resources/db/mapper/sys/SysRoleMapper.xml +++ b/src/main/resources/db/mapper/sys/SysRoleMapper.xml @@ -16,11 +16,13 @@ <association property="createUser" columnPrefix="cu_" javaType="net.geedge.asw.module.sys.entity.SysUserEntity"> <id property="id" column="id"/> <result property="name" column="name"/> + <result property="userName" column="user_name"/> </association> <association property="updateUser" columnPrefix="uu_" javaType="net.geedge.asw.module.sys.entity.SysUserEntity"> <id property="id" column="id"/> <result property="name" column="name"/> + <result property="userName" column="user_name"/> </association> </resultMap> @@ -30,8 +32,10 @@ sr.*, cu.id as cu_id, cu.name as cu_name, + cu.user_name as cu_user_name, uu.id as uu_id, - uu.id as uu_name + uu.name as uu_name, + uu.user_name as uu_user_name FROM sys_role sr left join sys_user cu on sr.create_user_id = cu.id |