From e023474fc9bcc726ed558a0623f1316dddc13152 Mon Sep 17 00:00:00 2001
From: zzw <wander.zheng@qq.com>
Date: 星期五, 01 十二月 2023 15:14:32 +0800
Subject: [PATCH] 编号
---
zt/core/src/main/resources/mapper/sys/SysUserDao.xml | 51 +++++++++++--------------
zt/common/src/main/java/com/zt/common/service/BaseService.java | 2
zt/common/src/main/java/com/zt/core/sys/model/SysUser.java | 2 -
zt/core/src/main/java/com/zt/modules/sys/service/SysUserService.java | 6 +-
4 files changed, 27 insertions(+), 34 deletions(-)
diff --git a/zt/common/src/main/java/com/zt/common/service/BaseService.java b/zt/common/src/main/java/com/zt/common/service/BaseService.java
index 1a7da94..f670400 100644
--- a/zt/common/src/main/java/com/zt/common/service/BaseService.java
+++ b/zt/common/src/main/java/com/zt/common/service/BaseService.java
@@ -80,7 +80,7 @@
public Entity get(Long id) {
Entity entity = baseDao.selectById(id);
- sysOssService.setOssField(entity);// 澶勭悊闄勪欢
+ sysOssService.setOssField(entity);// 澶勭悊闄勪欢*/
return entity;
}
diff --git a/zt/common/src/main/java/com/zt/core/sys/model/SysUser.java b/zt/common/src/main/java/com/zt/core/sys/model/SysUser.java
index 23af8c7..129866b 100644
--- a/zt/common/src/main/java/com/zt/core/sys/model/SysUser.java
+++ b/zt/common/src/main/java/com/zt/core/sys/model/SysUser.java
@@ -46,8 +46,6 @@
@TableField(exist = false)
@ApiModelProperty(value = "鐢ㄦ埛鍚�", required = false)
private String name;
- @ApiModelProperty(value = "鐢ㄦ埛ID", required = false)
- private Long userId;
@ApiModelProperty(value = "鍛樺伐宸ュ彿", required = false)
// @NotBlank(message = "鍛樺伐宸ュ彿涓嶈兘涓虹┖", groups = DefaultGroup.class)
private String userCode;
diff --git a/zt/core/src/main/java/com/zt/modules/sys/service/SysUserService.java b/zt/core/src/main/java/com/zt/modules/sys/service/SysUserService.java
index ca0c220..3052e84 100644
--- a/zt/core/src/main/java/com/zt/modules/sys/service/SysUserService.java
+++ b/zt/core/src/main/java/com/zt/modules/sys/service/SysUserService.java
@@ -120,9 +120,9 @@
@Override
@Cacheable(value = Constant.Cache.USER, key = "'id:' + #id")
public SysUser get(Long id) {
- SysUser entity = baseDao.getEntity(id);
- return entity;
- //return super.get(id);
+/* SysUser entity = baseDao.getEntity(id);
+ return entity;*/
+ return super.get(id);
}
/**
diff --git a/zt/core/src/main/resources/mapper/sys/SysUserDao.xml b/zt/core/src/main/resources/mapper/sys/SysUserDao.xml
index e275c3c..163ab9b 100644
--- a/zt/core/src/main/resources/mapper/sys/SysUserDao.xml
+++ b/zt/core/src/main/resources/mapper/sys/SysUserDao.xml
@@ -4,17 +4,12 @@
<mapper namespace="com.zt.modules.sys.dao.SysUserDao">
<select id="getList" resultType="com.zt.core.sys.model.SysUser">
- select a.user_id as id
- ,a.dept_id
- ,a.dept_id as company_id
- ,a.user_name as username
- ,a.nick_name as real_name
- ,a.phonenumber as MOBILE
+ select a.*
,(select t2.dept_name from SYS_DEPT t2 where t2.dept_id = a.dept_id) deptName
from SYS_USER a
- where a.del_flag = 0
+ where a.is_delete = 0
<if test="username != null and username.trim() != ''">
- and (a.user_name like #{username} or a.nick_name like #{username})
+ and (a.username like #{username} or a.nick_name like #{username})
</if>
<if test="deptId != null and deptId != 0">
and a.dept_id = #{deptId}
@@ -49,18 +44,18 @@
</select>
<select id="getByUsername" resultType="com.zt.core.sys.model.SysUser">
- select a.user_id as id
+ select a.id
, a.dept_id
- , a.dept_id as company_id
- , '1271368584383188993' as TENANT_ID
- , a.user_name as username
- , a.nick_name as real_name
- , a.phonenumber as MOBILE
+ , a.company_id
+ , '1271368584383188993' as TENANT_ID
+ , a.username
+ , a.real_name
+ , a.MOBILE
, (select t2.dept_name from SYS_DEPT t2 where t2.dept_id = a.dept_id) deptName
- , a.password as password
+ , a.password
from SYS_USER a
- where a.del_flag = 0
- and user_name = #{value}
+ where a.is_delete = 0
+ and username = #{value}
limit 1
</select>
<select id="checkUserArea" resultType="com.zt.core.sys.model.SysUser">
@@ -120,7 +115,7 @@
<select id="userRoleInfo" resultType="com.zt.core.context.User">
SELECT
- a.nick_name as realName,
+ a.real_Name,
c.name as roleName,
(select dept_name from SYS_DEPT d where a.DEPT_ID = d.DEPT_ID AND d.del_flag=0 limit 1 ) as deptName
FROM
@@ -131,12 +126,12 @@
sys_MENU f
WHERE 1=1
<if test="userId != null and userId != ''">
- and a.user_id = #{userId}
+ and a.id = #{userId}
</if>
<if test="username != null and username != ''">
- and a.user_name = #{username}
+ and a.username = #{username}
</if>
- and a.USER_ID = b.USER_ID
+ and a.ID = b.USER_ID
AND b.ROLE_ID = c.id
and c.id = e.role_id
and e.menu_id = f.id
@@ -196,16 +191,16 @@
</foreach>
</select>
<select id="getEntity" resultType="com.zt.core.sys.model.SysUser">
- SELECT b.user_id as id
+ SELECT b.id
, b.dept_id
- , b.dept_id as company_id
+ , b.company_id
, '1271368584383188993' as TENANT_ID
- , b.user_name as username
- , b.nick_name as real_name
- , b.phonenumber as MOBILE
+ , b.username
+ , b.real_name
+ , b.MOBILE
FROM SYS_USER b
- WHERE b.del_flag = 0
- and user_id = #{id}
+ WHERE b.is_delete = 0
+ and b.id = #{id}
limit 1
</select>
<select id="getNewConnectUser" resultType="com.zt.core.sys.model.SysUser">
--
Gitblit v1.9.1