ruoyi-common/src/main/java/com/ruoyi/common/core/domain/entity/SysUser.java
@@ -19,355 +19,351 @@ /** * 用户对象 sys_user * * * @author ruoyi */ public class SysUser extends BaseEntity { public class SysUser extends BaseEntity { private static final long serialVersionUID = 1L; /** 用户ID */ /** * 用户ID */ @Excel(name = "用户序号", cellType = ColumnType.NUMERIC, prompt = "用户编号") private Long userId; /** 部门ID */ /** * 部门ID */ @Excel(name = "部门编号", type = Type.IMPORT) private Long deptId; /** 微信openID */ /** * 微信openID */ @Excel(name = "微信openId") private String openid; /** 用户账号 */ /** * 用户账号 */ @Excel(name = "登录名称") private String userName; /** 用户昵称 */ /** * 用户昵称 */ @Excel(name = "用户名称") private String nickName; /** 用户邮箱 */ /** * 用户邮箱 */ @Excel(name = "用户邮箱") private String email; /** 手机号码 */ /** * 手机号码 */ @Excel(name = "手机号码") private String phonenumber; /** 用户性别 */ /** * 用户性别 */ @Excel(name = "用户性别", readConverterExp = "0=男,1=女,2=未知") private String sex; /** 用户头像 */ /** * 用户头像 */ private String avatar; /** 密码 */ /** * 密码 */ private String password; /** 盐加密 */ /** * 盐加密 */ private String salt; /** 帐号状态（0正常 1停用） */ /** * 帐号状态（0正常 1停用） */ @Excel(name = "帐号状态", readConverterExp = "0=正常,1=停用") private String status; /** 删除标志（0代表存在 2代表删除） */ /** * 删除标志（0代表存在 2代表删除） */ private String delFlag; /** 最后登录IP */ /** * 最后登录IP */ @Excel(name = "最后登录IP", type = Type.EXPORT) private String loginIp; /** 最后登录时间 */ /** * 最后登录时间 */ @Excel(name = "最后登录时间", width = 30, dateFormat = "yyyy-MM-dd HH:mm:ss", type = Type.EXPORT) private Date loginDate; /** 报销级别 */ /** * 报销级别 */ @Excel(name = "报销级别") private Integer standardlevel; /** 部门对象 */ @Excels({ @Excel(name = "部门名称", targetAttr = "deptName", type = Type.EXPORT), @Excel(name = "部门负责人", targetAttr = "leader", type = Type.EXPORT) }) /** * 部门对象 */ @Excels({@Excel(name = "部门名称", targetAttr = "deptName", type = Type.EXPORT), @Excel(name = "部门负责人", targetAttr = "leader", type = Type.EXPORT)}) private SysDept dept; /** 角色对象 */ /** * 角色对象 */ private List<SysRole> roles; /** 角色组 */ /** * 角色组 */ private Long[] roleIds; /** 岗位组 */ /** * 岗位组 */ private Long[] postIds; /** 角色ID */ /** * 角色ID */ private Long roleId; public SysUser() { /** * 错误次数 */ private int errorNums; /** * 错误时间 */ private String errorTimes; public SysUser() { } public SysUser(Long userId) { public int getErrorNums() { return errorNums; } public void setErrorNums(int errorNums) { this.errorNums = errorNums; } public String getErrorTimes() { return errorTimes; } public void setErrorTimes(String errorTimes) { this.errorTimes = errorTimes; } public SysUser(Long userId) { this.userId = userId; } public Long getUserId() { public Long getUserId() { return userId; } public void setUserId(Long userId) { public void setUserId(Long userId) { this.userId = userId; } public String getOpenId() { public String getOpenId() { return openid; } public void setOpenId(String openid) { public void setOpenId(String openid) { this.openid = openid; } public boolean isAdmin() { public boolean isAdmin() { return isAdmin(this.userId); } public static boolean isAdmin(Long userId) { public static boolean isAdmin(Long userId) { return userId != null && 1L == userId; } public Long getDeptId() { public Long getDeptId() { return deptId; } public void setDeptId(Long deptId) { public void setDeptId(Long deptId) { this.deptId = deptId; } @Size(min = 0, max = 30, message = "用户昵称长度不能超过30个字符") public String getNickName() { public String getNickName() { return nickName; } public void setNickName(String nickName) { public void setNickName(String nickName) { this.nickName = nickName; } @NotBlank(message = "用户账号不能为空") @Size(min = 0, max = 30, message = "用户账号长度不能超过30个字符") public String getUserName() { public String getUserName() { return userName; } public void setUserName(String userName) { public void setUserName(String userName) { this.userName = userName; } @Email(message = "邮箱格式不正确") @Size(min = 0, max = 50, message = "邮箱长度不能超过50个字符") public String getEmail() { public String getEmail() { return email; } public void setEmail(String email) { public void setEmail(String email) { this.email = email; } @Size(min = 0, max = 11, message = "手机号码长度不能超过11个字符") public String getPhonenumber() { public String getPhonenumber() { return phonenumber; } public void setPhonenumber(String phonenumber) { public void setPhonenumber(String phonenumber) { this.phonenumber = phonenumber; } public Integer getStandardlevel() { public Integer getStandardlevel() { return standardlevel; } public void setStandardlevel(Integer standardlevel) { public void setStandardlevel(Integer standardlevel) { this.standardlevel = standardlevel; } public String getAvatar() { public String getAvatar() { return avatar; } public void setAvatar(String avatar) { public void setAvatar(String avatar) { this.avatar = avatar; } public String getSex() { public String getSex() { return sex; } public void setSex(String sex) { public void setSex(String sex) { this.sex = sex; } @JsonIgnore @JsonProperty public String getPassword() { public String getPassword() { return password; } public void setPassword(String password) { public void setPassword(String password) { this.password = password; } public String getSalt() { public String getSalt() { return salt; } public void setSalt(String salt) { public void setSalt(String salt) { this.salt = salt; } public String getStatus() { public String getStatus() { return status; } public void setStatus(String status) { public void setStatus(String status) { this.status = status; } public String getDelFlag() { public String getDelFlag() { return delFlag; } public void setDelFlag(String delFlag) { public void setDelFlag(String delFlag) { this.delFlag = delFlag; } public String getLoginIp() { public String getLoginIp() { return loginIp; } public void setLoginIp(String loginIp) { public void setLoginIp(String loginIp) { this.loginIp = loginIp; } public Date getLoginDate() { public Date getLoginDate() { return loginDate; } public void setLoginDate(Date loginDate) { public void setLoginDate(Date loginDate) { this.loginDate = loginDate; } public SysDept getDept() { public SysDept getDept() { return dept; } public void setDept(SysDept dept) { public void setDept(SysDept dept) { this.dept = dept; } public List<SysRole> getRoles() { public List<SysRole> getRoles() { return roles; } public void setRoles(List<SysRole> roles) { public void setRoles(List<SysRole> roles) { this.roles = roles; } public Long[] getRoleIds() { public Long[] getRoleIds() { return roleIds; } public void setRoleIds(Long[] roleIds) { public void setRoleIds(Long[] roleIds) { this.roleIds = roleIds; } public Long[] getPostIds() { public Long[] getPostIds() { return postIds; } public void setPostIds(Long[] postIds) { public void setPostIds(Long[] postIds) { this.postIds = postIds; } public Long getRoleId() { public Long getRoleId() { return roleId; } public void setRoleId(Long roleId) { public void setRoleId(Long roleId) { this.roleId = roleId; } @Override public String toString() { return new ToStringBuilder(this,ToStringStyle.MULTI_LINE_STYLE) .append("userId", getUserId()) .append("deptId", getDeptId()) .append("userName", getUserName()) .append("nickName", getNickName()) .append("email", getEmail()) .append("phonenumber", getPhonenumber()) .append("sex", getSex()) .append("avatar", getAvatar()) .append("password", getPassword()) .append("salt", getSalt()) .append("status", getStatus()) .append("delFlag", getDelFlag()) .append("loginIp", getLoginIp()) .append("loginDate", getLoginDate()) .append("createBy", getCreateBy()) .append("createTime", getCreateTime()) .append("updateBy", getUpdateBy()) .append("updateTime", getUpdateTime()) .append("remark", getRemark()) .append("dept", getDept()) .toString(); return new ToStringBuilder(this, ToStringStyle.MULTI_LINE_STYLE).append("userId", getUserId()).append("deptId", getDeptId()).append("userName", getUserName()).append("nickName", getNickName()).append("email", getEmail()).append("phonenumber", getPhonenumber()).append("sex", getSex()).append("avatar", getAvatar()).append("password", getPassword()).append("salt", getSalt()).append("status", getStatus()).append("delFlag", getDelFlag()).append("loginIp", getLoginIp()).append("loginDate", getLoginDate()).append("createBy", getCreateBy()).append("createTime", getCreateTime()).append("updateBy", getUpdateBy()).append("updateTime", getUpdateTime()).append("remark", getRemark()).append("dept", getDept()).toString(); } } ruoyi-framework/src/main/java/com/ruoyi/framework/web/service/SysLoginService.java
@@ -3,9 +3,11 @@ import javax.annotation.Resource; import com.ruoyi.common.core.domain.AjaxResult; import com.ruoyi.common.exception.base.BaseException; import com.ruoyi.common.exception.user.WxOpenIDNotFindException; import com.ruoyi.common.utils.StringUtils; import com.ruoyi.framework.wxopenidConfig.WxOpenIDAuthenticationToken; import com.ruoyi.system.mapper.SysUserMapper; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.security.authentication.AuthenticationManager; import org.springframework.security.authentication.BadCredentialsException; @@ -31,12 +33,11 @@ /** * 登录校验方法 * * * @author ruoyi */ @Component public class SysLoginService { public class SysLoginService { @Autowired private TokenService tokenService; @@ -45,47 +46,49 @@ @Autowired private RedisCache redisCache; @Autowired private ISysUserService userService; @Autowired private ISysConfigService configService; @Autowired private SysUserMapper sysUserMapper; /** * 登录验证 * * * @param username 用户名 * @param password 密码 * @param code 验证码 * @param uuid 唯一标识 * @param code 验证码 * @param uuid 唯一标识 * @return 结果 */ public String login(String username, String password, String code, String uuid, String openId) { public String login(String username, String password, String code, String uuid, String openId) { SysUser sysUser = sysUserMapper.selectUserByUserName(username); if (sysUser.getErrorNums() >= 3) { //校验失败次数 throw new BaseException("你的密码输入错误次数过多，请联系管理员处理"); } boolean captchaOnOff = configService.selectCaptchaOnOff(); // 验证码开关 if (captchaOnOff) { if (captchaOnOff) { validateCaptcha(username, code, uuid); } // 用户验证 Authentication authentication = null; try { try { // 该方法会去调用UserDetailsServiceImpl.loadUserByUsername authentication = authenticationManager .authenticate(new UsernamePasswordAuthenticationToken(username, password)); } catch (Exception e) { if (e instanceof BadCredentialsException) { authentication = authenticationManager.authenticate(new UsernamePasswordAuthenticationToken(username, password)); } catch (Exception e) { if (e instanceof BadCredentialsException) { AsyncManager.me().execute(AsyncFactory.recordLogininfor(username, Constants.LOGIN_FAIL, MessageUtils.message("user.password.not.match"))); sysUserMapper.updateErrorNums(sysUser); throw new UserPasswordNotMatchException(); } else { } else { AsyncManager.me().execute(AsyncFactory.recordLogininfor(username, Constants.LOGIN_FAIL, e.getMessage())); throw new ServiceException(e.getMessage()); } @@ -97,52 +100,44 @@ //更新openid String userOpenId = user.getOpenId(); if(StringUtils.isEmpty(openId)) { if (StringUtils.isEmpty(openId)) { recordLoginInfo(loginUser.getUserId()); }else { if(StringUtils.isNotEmpty(userOpenId)) { } else { if (StringUtils.isNotEmpty(userOpenId)) { //当本次登录的微信OPENID不等于第一次绑定的微信OPENID就不允许登录，防止同一个账号多微信登录 if(!userOpenId.equals(openId)) { if (!userOpenId.equals(openId)) { AsyncManager.me().execute(AsyncFactory.recordLogininfor(username, Constants.LOGIN_FAIL, "该账户已经绑定其他设备，须先解除绑定再登录，请跟系统管理员联系！")); throw new ServiceException("该账户已经绑定其他设备，须先解除绑定再登录，请跟系统管理员联系！"); }else { } else { recordLoginInfo(loginUser.getUserId()); } }else { } else { recordLoginInfo(loginUser.getUserId(), openId); } } //清除失败次数 sysUserMapper.cleanErrorNums(username); // 生成token return tokenService.createToken(loginUser); } /** * 校验验证码 * * * @param username 用户名 * @param code 验证码 * @param uuid 唯一标识 * @param code 验证码 * @param uuid 唯一标识 * @return 结果 */ public void validateCaptcha(String username, String code, String uuid) { public void validateCaptcha(String username, String code, String uuid) { String verifyKey = Constants.CAPTCHA_CODE_KEY + uuid; String captcha = redisCache.getCacheObject(verifyKey); redisCache.deleteObject(verifyKey); if (captcha == null) { if (captcha == null) { AsyncManager.me().execute(AsyncFactory.recordLogininfor(username, Constants.LOGIN_FAIL, MessageUtils.message("user.jcaptcha.expire"))); throw new CaptchaExpireException(); } if (!code.equalsIgnoreCase(captcha)) { if (!code.equalsIgnoreCase(captcha)) { AsyncManager.me().execute(AsyncFactory.recordLogininfor(username, Constants.LOGIN_FAIL, MessageUtils.message("user.jcaptcha.error"))); throw new CaptchaException(); } @@ -155,20 +150,15 @@ * @return 结果 */ public AjaxResult wxopenidLogin(String openid) { public AjaxResult wxopenidLogin(String openid) { // 用户验证 Authentication authentication = null; try { try { // 该方法会去调用UserDetailsServiceImpl.loadUserByUsername authentication = authenticationManager .authenticate(new WxOpenIDAuthenticationToken(openid)); } catch (Exception e) { authentication = authenticationManager.authenticate(new WxOpenIDAuthenticationToken(openid)); } catch (Exception e) { AsyncManager.me().execute(AsyncFactory.recordLogininfor(openid, Constants.LOGIN_FAIL, e.getMessage())); throw new WxOpenIDNotFindException(); @@ -189,8 +179,7 @@ * * @param userId 用户ID */ public void recordLoginInfo(Long userId) { public void recordLoginInfo(Long userId) { SysUser sysUser = new SysUser(); sysUser.setUserId(userId); sysUser.setLoginIp(IpUtils.getIpAddr(ServletUtils.getRequest())); @@ -199,8 +188,7 @@ } public void recordLoginInfo(Long userId, String openId) { public void recordLoginInfo(Long userId, String openId) { SysUser sysUser = new SysUser(); sysUser.setUserId(userId); sysUser.setOpenId(openId); ruoyi-system/src/main/java/com/ruoyi/system/mapper/SysPostMapper.java
@@ -1,18 +1,20 @@ package com.ruoyi.system.mapper; import java.util.List; import com.ruoyi.system.domain.SysPost; import org.apache.ibatis.annotations.Mapper; /** * 岗位信息 数据层 * * * @author ruoyi */ public interface SysPostMapper { @Mapper public interface SysPostMapper { /** * 查询岗位数据集合 * * * @param post 岗位信息 * @return 岗位数据集合 */ @@ -20,14 +22,14 @@ /** * 查询所有岗位 * * * @return 岗位列表 */ public List<SysPost> selectPostAll(); /** * 通过岗位ID查询岗位信息 * * * @param postId 岗位ID * @return 角色对象信息 */ @@ -35,7 +37,7 @@ /** * 根据用户ID获取岗位选择框列表 * * * @param userId 用户ID * @return 选中岗位ID列表 */ @@ -43,7 +45,7 @@ /** * 查询用户所属岗位组 * * * @param userName 用户名 * @return 结果 */ @@ -51,7 +53,7 @@ /** * 删除岗位信息 * * * @param postId 岗位ID * @return 结果 */ @@ -59,7 +61,7 @@ /** * 批量删除岗位信息 * * * @param postIds 需要删除的岗位ID * @return 结果 */ @@ -67,7 +69,7 @@ /** * 修改岗位信息 * * * @param post 岗位信息 * @return 结果 */ @@ -75,7 +77,7 @@ /** * 新增岗位信息 * * * @param post 岗位信息 * @return 结果 */ @@ -83,7 +85,7 @@ /** * 校验岗位名称 * * * @param postName 岗位名称 * @return 结果 */ @@ -91,7 +93,7 @@ /** * 校验岗位编码 * * * @param postCode 岗位编码 * @return 结果 */ ruoyi-system/src/main/java/com/ruoyi/system/mapper/SysRoleMapper.java
@@ -1,18 +1,20 @@ package com.ruoyi.system.mapper; import java.util.List; import com.ruoyi.common.core.domain.entity.SysRole; import org.apache.ibatis.annotations.Mapper; /** * 角色表 数据层 * * * @author ruoyi */ public interface SysRoleMapper { @Mapper public interface SysRoleMapper { /** * 根据条件分页查询角色数据 * * * @param role 角色信息 * @return 角色数据集合信息 */ @@ -20,7 +22,7 @@ /** * 根据用户ID查询角色 * * * @param userId 用户ID * @return 角色列表 */ @@ -28,14 +30,14 @@ /** * 查询所有角色 * * * @return 角色列表 */ public List<SysRole> selectRoleAll(); /** * 根据用户ID获取角色选择框列表 * * * @param userId 用户ID * @return 选中角色ID列表 */ @@ -43,7 +45,7 @@ /** * 通过角色ID查询角色 * * * @param roleId 角色ID * @return 角色对象信息 */ @@ -51,7 +53,7 @@ /** * 根据用户ID查询角色 * * * @param userName 用户名 * @return 角色列表 */ @@ -59,7 +61,7 @@ /** * 校验角色名称是否唯一 * * * @param roleName 角色名称 * @return 角色信息 */ @@ -67,7 +69,7 @@ /** * 校验角色权限是否唯一 * * * @param roleKey 角色权限 * @return 角色信息 */ @@ -75,7 +77,7 @@ /** * 修改角色信息 * * * @param role 角色信息 * @return 结果 */ @@ -83,7 +85,7 @@ /** * 新增角色信息 * * * @param role 角色信息 * @return 结果 */ @@ -91,7 +93,7 @@ /** * 通过角色ID删除角色 * * * @param roleId 角色ID * @return 结果 */ @@ -99,7 +101,7 @@ /** * 批量删除角色信息 * * * @param roleIds 需要删除的角色ID * @return 结果 */ ruoyi-system/src/main/java/com/ruoyi/system/mapper/SysUserMapper.java
@@ -3,19 +3,20 @@ import java.util.List; import com.ruoyi.system.domain.vo.Nickname; import org.apache.ibatis.annotations.Mapper; import org.apache.ibatis.annotations.Param; import com.ruoyi.common.core.domain.entity.SysUser; /** * 用户表 数据层 * * * @author ruoyi */ public interface SysUserMapper { @Mapper public interface SysUserMapper { /** * 根据条件分页查询用户列表 * * * @param sysUser 用户信息 * @return 用户信息集合信息 */ @@ -23,7 +24,7 @@ /** * 根据条件分页查询未已配用户角色列表 * * * @param user 用户信息 * @return 用户信息集合信息 */ @@ -31,7 +32,7 @@ /** * 根据条件分页查询未分配用户角色列表 * * * @param user 用户信息 * @return 用户信息集合信息 */ @@ -39,7 +40,7 @@ /** * 通过用户名查询用户 * * * @param userName 用户名 * @return 用户对象信息 */ @@ -52,9 +53,10 @@ * @return 用户对象信息 */ public SysUser selectUserByOpenID(String openid); /** * 通过用户ID查询用户 * * * @param userId 用户ID * @return 用户对象信息 */ @@ -62,7 +64,7 @@ /** * 新增用户信息 * * * @param user 用户信息 * @return 结果 */ @@ -70,7 +72,7 @@ /** * 修改用户信息 * * * @param user 用户信息 * @return 结果 */ @@ -78,16 +80,16 @@ /** * 修改用户头像 * * * @param userName 用户名 * @param avatar 头像地址 * @param avatar 头像地址 * @return 结果 */ public int updateUserAvatar(@Param("userName") String userName, @Param("avatar") String avatar); /** * 重置用户密码 * * * @param userName 用户名 * @param password 密码 * @return 结果 @@ -96,7 +98,7 @@ /** * 通过用户ID删除用户 * * * @param userId 用户ID * @return 结果 */ @@ -104,7 +106,7 @@ /** * 批量删除用户信息 * * * @param userIds 需要删除的用户ID * @return 结果 */ @@ -112,7 +114,7 @@ /** * 校验用户名称是否唯一 * * * @param userName 用户名称 * @return 结果 */ @@ -135,4 +137,20 @@ public SysUser checkEmailUnique(String email); List<Nickname> getNickname(); /** * 增加密码错误次数 * * @param sysUser 用户信息 * @return 结果 */ public int updateErrorNums(SysUser sysUser); /** * 清空密码错误次数 * * @param username 用户名 * @return 结果 */ public int cleanErrorNums(String username); } ruoyi-system/src/main/java/com/ruoyi/system/mapper/SysUserPostMapper.java
@@ -1,18 +1,20 @@ package com.ruoyi.system.mapper; import java.util.List; import com.ruoyi.system.domain.SysUserPost; import org.apache.ibatis.annotations.Mapper; /** * 用户与岗位关联表 数据层 * * * @author ruoyi */ public interface SysUserPostMapper { @Mapper public interface SysUserPostMapper { /** * 通过用户ID删除用户和岗位关联 * * * @param userId 用户ID * @return 结果 */ @@ -20,7 +22,7 @@ /** * 通过岗位ID查询岗位使用数量 * * * @param postId 岗位ID * @return 结果 */ @@ -28,7 +30,7 @@ /** * 批量删除用户和岗位关联 * * * @param ids 需要删除的数据ID * @return 结果 */ @@ -36,7 +38,7 @@ /** * 批量新增用户岗位信息 * * * @param userPostList 用户角色列表 * @return 结果 */ ruoyi-system/src/main/java/com/ruoyi/system/mapper/SysUserRoleMapper.java
@@ -1,19 +1,21 @@ package com.ruoyi.system.mapper; import java.util.List; import org.apache.ibatis.annotations.Mapper; import org.apache.ibatis.annotations.Param; import com.ruoyi.system.domain.SysUserRole; /** * 用户与角色关联表 数据层 * * * @author ruoyi */ public interface SysUserRoleMapper { @Mapper public interface SysUserRoleMapper { /** * 通过用户ID删除用户和角色关联 * * * @param userId 用户ID * @return 结果 */ @@ -21,7 +23,7 @@ /** * 批量删除用户和角色关联 * * * @param ids 需要删除的数据ID * @return 结果 */ @@ -29,7 +31,7 @@ /** * 通过角色ID查询角色使用数量 * * * @param roleId 角色ID * @return 结果 */ @@ -37,7 +39,7 @@ /** * 批量新增用户角色信息 * * * @param userRoleList 用户角色列表 * @return 结果 */ @@ -45,7 +47,7 @@ /** * 删除用户和角色关联信息 * * * @param userRole 用户和角色关联信息 * @return 结果 */ @@ -53,8 +55,8 @@ /** * 批量取消授权用户角色 * * @param roleId 角色ID * * @param roleId 角色ID * @param userIds 需要删除的用户数据ID * @return 结果 */ ruoyi-system/src/main/java/com/ruoyi/system/service/ISysUserService.java
@@ -1,19 +1,19 @@ package com.ruoyi.system.service; import java.util.List; import com.ruoyi.common.core.domain.entity.SysUser; import com.ruoyi.system.domain.vo.Nickname; /** * 用户 业务层 * * * @author ruoyi */ public interface ISysUserService { public interface ISysUserService { /** * 根据条件分页查询用户列表 * * * @param user 用户信息 * @return 用户信息集合信息 */ @@ -21,7 +21,7 @@ /** * 根据条件分页查询已分配用户角色列表 * * * @param user 用户信息 * @return 用户信息集合信息 */ @@ -29,7 +29,7 @@ /** * 根据条件分页查询未分配用户角色列表 * * * @param user 用户信息 * @return 用户信息集合信息 */ @@ -37,7 +37,7 @@ /** * 通过用户名查询用户 * * * @param userName 用户名 * @return 用户对象信息 */ @@ -50,9 +50,10 @@ * @return 用户对象信息 */ public SysUser selectUserByOpenID(String openid); /** * 通过用户ID查询用户 * * * @param userId 用户ID * @return 用户对象信息 */ @@ -60,7 +61,7 @@ /** * 根据用户ID查询用户所属角色组 * * * @param userName 用户名 * @return 结果 */ @@ -68,7 +69,7 @@ /** * 根据用户ID查询用户所属岗位组 * * * @param userName 用户名 * @return 结果 */ @@ -76,7 +77,7 @@ /** * 校验用户名称是否唯一 * * * @param userName 用户名称 * @return 结果 */ @@ -100,21 +101,21 @@ /** * 校验用户是否允许操作 * * * @param user 用户信息 */ public void checkUserAllowed(SysUser user); /** * 校验用户是否有数据权限 * * * @param userId 用户id */ public void checkUserDataScope(Long userId); /** * 新增用户信息 * * * @param user 用户信息 * @return 结果 */ @@ -122,7 +123,7 @@ /** * 注册用户信息 * * * @param user 用户信息 * @return 结果 */ @@ -130,7 +131,7 @@ /** * 修改用户信息 * * * @param user 用户信息 * @return 结果 */ @@ -138,15 +139,15 @@ /** * 用户授权角色 * * @param userId 用户ID * * @param userId 用户ID * @param roleIds 角色组 */ public void insertUserAuth(Long userId, Long[] roleIds); /** * 修改用户状态 * * * @param user 用户信息 * @return 结果 */ @@ -154,7 +155,7 @@ /** * 修改用户基本信息 * * * @param user 用户信息 * @return 结果 */ @@ -162,16 +163,16 @@ /** * 修改用户头像 * * * @param userName 用户名 * @param avatar 头像地址 * @param avatar 头像地址 * @return 结果 */ public boolean updateUserAvatar(String userName, String avatar); /** * 重置用户密码 * * * @param user 用户信息 * @return 结果 */ @@ -179,7 +180,7 @@ /** * 重置用户密码 * * * @param userName 用户名 * @param password 密码 * @return 结果 @@ -188,7 +189,7 @@ /** * 通过用户ID删除用户 * * * @param userId 用户ID * @return 结果 */ @@ -196,7 +197,7 @@ /** * 批量删除用户信息 * * * @param userIds 需要删除的用户ID * @return 结果 */ @@ -204,13 +205,24 @@ /** * 导入用户数据 * * @param userList 用户数据列表 * * @param userList 用户数据列表 * @param isUpdateSupport 是否更新支持，如果已存在，则进行更新数据 * @param operName 操作用户 * @param operName 操作用户 * @return 结果 */ public String importUser(List<SysUser> userList, Boolean isUpdateSupport, String operName); List<Nickname> getNickName(); /** * 登陆错误限制 * 更新时sys_user加两字段 * error_nums int类型(默认0!!) * error_times varchar类型 * * @param sysUser */ public void loginError(SysUser sysUser); } ruoyi-system/src/main/java/com/ruoyi/system/service/impl/SysUserServiceImpl.java
@@ -3,6 +3,7 @@ import java.util.ArrayList; import java.util.List; import com.ruoyi.common.exception.base.BaseException; import com.ruoyi.system.domain.vo.Nickname; import org.slf4j.Logger; import org.slf4j.LoggerFactory; @@ -30,12 +31,11 @@ /** * 用户 业务层处理 * * * @author ruoyi */ @Service public class SysUserServiceImpl implements ISysUserService { public class SysUserServiceImpl implements ISysUserService { private static final Logger log = LoggerFactory.getLogger(SysUserServiceImpl.class); @Autowired @@ -58,52 +58,48 @@ /** * 根据条件分页查询用户列表 * * * @param user 用户信息 * @return 用户信息集合信息 */ @Override @DataScope(deptAlias = "d", userAlias = "u") public List<SysUser> selectUserList(SysUser user) { public List<SysUser> selectUserList(SysUser user) { return userMapper.selectUserList(user); } /** * 根据条件分页查询已分配用户角色列表 * * * @param user 用户信息 * @return 用户信息集合信息 */ @Override @DataScope(deptAlias = "d", userAlias = "u") public List<SysUser> selectAllocatedList(SysUser user) { public List<SysUser> selectAllocatedList(SysUser user) { return userMapper.selectAllocatedList(user); } /** * 根据条件分页查询未分配用户角色列表 * * * @param user 用户信息 * @return 用户信息集合信息 */ @Override @DataScope(deptAlias = "d", userAlias = "u") public List<SysUser> selectUnallocatedList(SysUser user) { public List<SysUser> selectUnallocatedList(SysUser user) { return userMapper.selectUnallocatedList(user); } /** * 通过用户名查询用户 * * * @param userName 用户名 * @return 用户对象信息 */ @Override public SysUser selectUserByUserName(String userName) { public SysUser selectUserByUserName(String userName) { return userMapper.selectUserByUserName(userName); } @@ -121,33 +117,29 @@ /** * 通过用户ID查询用户 * * * @param userId 用户ID * @return 用户对象信息 */ @Override public SysUser selectUserById(Long userId) { public SysUser selectUserById(Long userId) { return userMapper.selectUserById(userId); } /** * 查询用户所属角色组 * * * @param userName 用户名 * @return 结果 */ @Override public String selectUserRoleGroup(String userName) { public String selectUserRoleGroup(String userName) { List<SysRole> list = roleMapper.selectRolesByUserName(userName); StringBuffer idsStr = new StringBuffer(); for (SysRole role : list) { for (SysRole role : list) { idsStr.append(role.getRoleName()).append(","); } if (StringUtils.isNotEmpty(idsStr.toString())) { if (StringUtils.isNotEmpty(idsStr.toString())) { return idsStr.substring(0, idsStr.length() - 1); } return idsStr.toString(); @@ -155,21 +147,18 @@ /** * 查询用户所属岗位组 * * * @param userName 用户名 * @return 结果 */ @Override public String selectUserPostGroup(String userName) { public String selectUserPostGroup(String userName) { List<SysPost> list = postMapper.selectPostsByUserName(userName); StringBuffer idsStr = new StringBuffer(); for (SysPost post : list) { for (SysPost post : list) { idsStr.append(post.getPostName()).append(","); } if (StringUtils.isNotEmpty(idsStr.toString())) { if (StringUtils.isNotEmpty(idsStr.toString())) { return idsStr.substring(0, idsStr.length() - 1); } return idsStr.toString(); @@ -177,16 +166,14 @@ /** * 校验用户名称是否唯一 * * * @param userName 用户名称 * @return 结果 */ @Override public String checkUserNameUnique(String userName) { public String checkUserNameUnique(String userName) { int count = userMapper.checkUserNameUnique(userName); if (count > 0) { if (count > 0) { return UserConstants.NOT_UNIQUE; } return UserConstants.UNIQUE; @@ -199,12 +186,10 @@ * @return */ @Override public String checkPhoneUnique(SysUser user) { public String checkPhoneUnique(SysUser user) { Long userId = StringUtils.isNull(user.getUserId()) ? -1L : user.getUserId(); SysUser info = userMapper.checkPhoneUnique(user.getPhonenumber()); if (StringUtils.isNotNull(info) && info.getUserId().longValue() != userId.longValue()) { if (StringUtils.isNotNull(info) && info.getUserId().longValue() != userId.longValue()) { return UserConstants.NOT_UNIQUE; } return UserConstants.UNIQUE; @@ -217,12 +202,10 @@ * @return */ @Override public String checkEmailUnique(SysUser user) { public String checkEmailUnique(SysUser user) { Long userId = StringUtils.isNull(user.getUserId()) ? -1L : user.getUserId(); SysUser info = userMapper.checkEmailUnique(user.getEmail()); if (StringUtils.isNotNull(info) && info.getUserId().longValue() != userId.longValue()) { if (StringUtils.isNotNull(info) && info.getUserId().longValue() != userId.longValue()) { return UserConstants.NOT_UNIQUE; } return UserConstants.UNIQUE; @@ -230,33 +213,28 @@ /** * 校验用户是否允许操作 * * * @param user 用户信息 */ @Override public void checkUserAllowed(SysUser user) { if (StringUtils.isNotNull(user.getUserId()) && user.isAdmin()) { public void checkUserAllowed(SysUser user) { if (StringUtils.isNotNull(user.getUserId()) && user.isAdmin()) { throw new ServiceException("不允许操作超级管理员用户"); } } /** * 校验用户是否有数据权限 * * * @param userId 用户id */ @Override public void checkUserDataScope(Long userId) { if (!SysUser.isAdmin(SecurityUtils.getUserId())) { public void checkUserDataScope(Long userId) { if (!SysUser.isAdmin(SecurityUtils.getUserId())) { SysUser user = new SysUser(); user.setUserId(userId); List<SysUser> users = SpringUtils.getAopProxy(this).selectUserList(user); if (StringUtils.isEmpty(users)) { if (StringUtils.isEmpty(users)) { throw new ServiceException("没有权限访问用户数据！"); } } @@ -264,14 +242,13 @@ /** * 新增保存用户信息 * * * @param user 用户信息 * @return 结果 */ @Override @Transactional public int insertUser(SysUser user) { public int insertUser(SysUser user) { // 新增用户信息 int rows = userMapper.insertUser(user); // 新增用户岗位关联 @@ -283,26 +260,24 @@ /** * 注册用户信息 * * * @param user 用户信息 * @return 结果 */ @Override public boolean registerUser(SysUser user) { public boolean registerUser(SysUser user) { return userMapper.insertUser(user) > 0; } /** * 修改保存用户信息 * * * @param user 用户信息 * @return 结果 */ @Override @Transactional public int updateUser(SysUser user) { public int updateUser(SysUser user) { Long userId = user.getUserId(); // 删除用户与角色关联 userRoleMapper.deleteUserRoleByUserId(userId); @@ -317,101 +292,92 @@ /** * 用户授权角色 * * @param userId 用户ID * * @param userId 用户ID * @param roleIds 角色组 */ @Override @Transactional public void insertUserAuth(Long userId, Long[] roleIds) { public void insertUserAuth(Long userId, Long[] roleIds) { userRoleMapper.deleteUserRoleByUserId(userId); insertUserRole(userId, roleIds); } /** * 修改用户状态 * * * @param user 用户信息 * @return 结果 */ @Override public int updateUserStatus(SysUser user) { public int updateUserStatus(SysUser user) { return userMapper.updateUser(user); } /** * 修改用户基本信息 * * * @param user 用户信息 * @return 结果 */ @Override public int updateUserProfile(SysUser user) { public int updateUserProfile(SysUser user) { return userMapper.updateUser(user); } /** * 修改用户头像 * * * @param userName 用户名 * @param avatar 头像地址 * @param avatar 头像地址 * @return 结果 */ @Override public boolean updateUserAvatar(String userName, String avatar) { public boolean updateUserAvatar(String userName, String avatar) { return userMapper.updateUserAvatar(userName, avatar) > 0; } /** * 重置用户密码 * * * @param user 用户信息 * @return 结果 */ @Override public int resetPwd(SysUser user) { public int resetPwd(SysUser user) { user.setErrorNums(0); return userMapper.updateUser(user); } /** * 重置用户密码 * * * @param userName 用户名 * @param password 密码 * @return 结果 */ @Override public int resetUserPwd(String userName, String password) { public int resetUserPwd(String userName, String password) { return userMapper.resetUserPwd(userName, password); } /** * 新增用户角色信息 * * * @param user 用户对象 */ public void insertUserRole(SysUser user) { public void insertUserRole(SysUser user) { Long[] roles = user.getRoleIds(); if (StringUtils.isNotNull(roles)) { if (StringUtils.isNotNull(roles)) { // 新增用户与角色管理 List<SysUserRole> list = new ArrayList<SysUserRole>(); for (Long roleId : roles) { for (Long roleId : roles) { SysUserRole ur = new SysUserRole(); ur.setUserId(user.getUserId()); ur.setRoleId(roleId); list.add(ur); } if (list.size() > 0) { if (list.size() > 0) { userRoleMapper.batchUserRole(list); } } @@ -419,25 +385,21 @@ /** * 新增用户岗位信息 * * * @param user 用户对象 */ public void insertUserPost(SysUser user) { public void insertUserPost(SysUser user) { Long[] posts = user.getPostIds(); if (StringUtils.isNotNull(posts)) { if (StringUtils.isNotNull(posts)) { // 新增用户与岗位管理 List<SysUserPost> list = new ArrayList<SysUserPost>(); for (Long postId : posts) { for (Long postId : posts) { SysUserPost up = new SysUserPost(); up.setUserId(user.getUserId()); up.setPostId(postId); list.add(up); } if (list.size() > 0) { if (list.size() > 0) { userPostMapper.batchUserPost(list); } } @@ -445,25 +407,21 @@ /** * 新增用户角色信息 * * @param userId 用户ID * * @param userId 用户ID * @param roleIds 角色组 */ public void insertUserRole(Long userId, Long[] roleIds) { if (StringUtils.isNotNull(roleIds)) { public void insertUserRole(Long userId, Long[] roleIds) { if (StringUtils.isNotNull(roleIds)) { // 新增用户与角色管理 List<SysUserRole> list = new ArrayList<SysUserRole>(); for (Long roleId : roleIds) { for (Long roleId : roleIds) { SysUserRole ur = new SysUserRole(); ur.setUserId(userId); ur.setRoleId(roleId); list.add(ur); } if (list.size() > 0) { if (list.size() > 0) { userRoleMapper.batchUserRole(list); } } @@ -471,14 +429,13 @@ /** * 通过用户ID删除用户 * * * @param userId 用户ID * @return 结果 */ @Override @Transactional public int deleteUserById(Long userId) { public int deleteUserById(Long userId) { // 删除用户与角色关联 userRoleMapper.deleteUserRoleByUserId(userId); // 删除用户与岗位表 @@ -488,16 +445,14 @@ /** * 批量删除用户信息 * * * @param userIds 需要删除的用户ID * @return 结果 */ @Override @Transactional public int deleteUserByIds(Long[] userIds) { for (Long userId : userIds) { public int deleteUserByIds(Long[] userIds) { for (Long userId : userIds) { checkUserAllowed(new SysUser(userId)); } // 删除用户与角色关联 @@ -509,17 +464,15 @@ /** * 导入用户数据 * * @param userList 用户数据列表 * * @param userList 用户数据列表 * @param isUpdateSupport 是否更新支持，如果已存在，则进行更新数据 * @param operName 操作用户 * @param operName 操作用户 * @return 结果 */ @Override public String importUser(List<SysUser> userList, Boolean isUpdateSupport, String operName) { if (StringUtils.isNull(userList) || userList.size() == 0) { public String importUser(List<SysUser> userList, Boolean isUpdateSupport, String operName) { if (StringUtils.isNull(userList) || userList.size() == 0) { throw new ServiceException("导入用户数据不能为空！"); } int successNum = 0; @@ -527,48 +480,36 @@ StringBuilder successMsg = new StringBuilder(); StringBuilder failureMsg = new StringBuilder(); String password = configService.selectConfigByKey("sys.user.initPassword"); for (SysUser user : userList) { try { for (SysUser user : userList) { try { // 验证是否存在这个用户 SysUser u = userMapper.selectUserByUserName(user.getUserName()); if (StringUtils.isNull(u)) { if (StringUtils.isNull(u)) { user.setPassword(SecurityUtils.encryptPassword(password)); user.setCreateBy(operName); this.insertUser(user); successNum++; successMsg.append("<br/>" + successNum + "、账号 " + user.getUserName() + " 导入成功"); } else if (isUpdateSupport) { } else if (isUpdateSupport) { user.setUpdateBy(operName); this.updateUser(user); successNum++; successMsg.append("<br/>" + successNum + "、账号 " + user.getUserName() + " 更新成功"); } else { } else { failureNum++; failureMsg.append("<br/>" + failureNum + "、账号 " + user.getUserName() + " 已存在"); } } catch (Exception e) { } catch (Exception e) { failureNum++; String msg = "<br/>" + failureNum + "、账号 " + user.getUserName() + " 导入失败："; failureMsg.append(msg + e.getMessage()); log.error(msg, e); } } if (failureNum > 0) { if (failureNum > 0) { failureMsg.insert(0, "很抱歉，导入失败！共 " + failureNum + " 条数据格式不正确，错误如下："); throw new ServiceException(failureMsg.toString()); } else { } else { successMsg.insert(0, "恭喜您，数据已全部导入成功！共 " + successNum + " 条，数据如下："); } return successMsg.toString(); @@ -578,4 +519,11 @@ public List<Nickname> getNickName() { return userMapper.getNickname(); } @Override public void loginError(SysUser sysUser) { if (sysUser.getErrorNums() > 3) { throw new BaseException("对不起，您的账号已被锁定，请联系管理员修改密码后，再次尝试"); } } } ruoyi-system/src/main/resources/mapper/system/SysUserMapper.xml
@@ -1,231 +1,300 @@ <?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"> PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> <mapper namespace="com.ruoyi.system.mapper.SysUserMapper"> <resultMap type="SysUser" id="SysUserResult"> <id property="userId" column="user_id" /> <result property="openid" column="openid" /> <result property="deptId" column="dept_id" /> <result property="userName" column="user_name" /> <result property="nickName" column="nick_name" /> <result property="email" column="email" /> <result property="phonenumber" column="phonenumber" /> <result property="sex" column="sex" /> <result property="avatar" column="avatar" /> <result property="password" column="password" /> <result property="status" column="status" /> <result property="delFlag" column="del_flag" /> <result property="loginIp" column="login_ip" /> <result property="loginDate" column="login_date" /> <result property="createBy" column="create_by" /> <result property="createTime" column="create_time" /> <result property="updateBy" column="update_by" /> <result property="updateTime" column="update_time" /> <result property="remark" column="remark" /> <result property="standardlevel" column="standardlevel" /> <association property="dept" column="dept_id" javaType="SysDept" resultMap="deptResult" /> <collection property="roles" javaType="java.util.List" resultMap="RoleResult" /> </resultMap> <resultMap id="deptResult" type="SysDept"> <id property="deptId" column="dept_id" /> <result property="parentId" column="parent_id" /> <result property="deptName" column="dept_name" /> <result property="orderNum" column="order_num" /> <result property="leader" column="leader" /> <result property="status" column="dept_status" /> </resultMap> <resultMap id="RoleResult" type="SysRole"> <id property="roleId" column="role_id" /> <result property="roleName" column="role_name" /> <result property="roleKey" column="role_key" /> <result property="roleSort" column="role_sort" /> <result property="dataScope" column="data_scope" /> <result property="status" column="role_status" /> </resultMap> <sql id="selectUserVo"> select u.user_id,u.openid, u.dept_id, u.user_name, u.nick_name, u.email, u.avatar, u.phonenumber, u.password, u.sex, u.status, u.del_flag, u.login_ip, u.login_date, u.create_by, u.create_time, u.remark,u.standardlevel, d.dept_id, d.parent_id, d.dept_name, d.order_num, d.leader, d.status as dept_status, r.role_id, r.role_name, r.role_key, r.role_sort, r.data_scope, r.status as role_status <resultMap type="com.ruoyi.common.core.domain.entity.SysUser" id="SysUserResult"> <id property="userId" column="user_id"/> <result property="openid" column="openid"/> <result property="deptId" column="dept_id"/> <result property="userName" column="user_name"/> <result property="nickName" column="nick_name"/> <result property="email" column="email"/> <result property="phonenumber" column="phonenumber"/> <result property="sex" column="sex"/> <result property="avatar" column="avatar"/> <result property="password" column="password"/> <result property="status" column="status"/> <result property="delFlag" column="del_flag"/> <result property="loginIp" column="login_ip"/> <result property="loginDate" column="login_date"/> <result property="createBy" column="create_by"/> <result property="createTime" column="create_time"/> <result property="updateBy" column="update_by"/> <result property="updateTime" column="update_time"/> <result property="remark" column="remark"/> <result property="errorNums" column="error_nums"/> <result property="errorTimes" column="error_times"/> <result property="standardlevel" column="standardlevel"/> <association property="dept" column="dept_id" javaType="com.ruoyi.common.core.domain.entity.SysDept" resultMap="deptResult"/> <collection property="roles" javaType="java.util.List" resultMap="RoleResult"/> </resultMap> <resultMap id="deptResult" type="com.ruoyi.common.core.domain.entity.SysDept"> <id property="deptId" column="dept_id"/> <result property="parentId" column="parent_id"/> <result property="deptName" column="dept_name"/> <result property="orderNum" column="order_num"/> <result property="leader" column="leader"/> <result property="status" column="dept_status"/> </resultMap> <resultMap id="RoleResult" type="com.ruoyi.common.core.domain.entity.SysRole"> <id property="roleId" column="role_id"/> <result property="roleName" column="role_name"/> <result property="roleKey" column="role_key"/> <result property="roleSort" column="role_sort"/> <result property="dataScope" column="data_scope"/> <result property="status" column="role_status"/> </resultMap> <sql id="selectUserVo"> select u.user_id, u.openid, u.dept_id, u.error_nums, u.error_times, u.user_name, u.nick_name, u.email, u.avatar, u.phonenumber, u.password, u.sex, u.status, u.del_flag, u.login_ip, u.login_date, u.create_by, u.create_time, u.remark, u.standardlevel, d.dept_id, d.parent_id, d.dept_name, d.order_num, d.leader, d.status as dept_status, r.role_id, r.role_name, r.role_key, r.role_sort, r.data_scope, r.status as role_status from sys_user u left join sys_dept d on u.dept_id = d.dept_id left join sys_user_role ur on u.user_id = ur.user_id left join sys_role r on r.role_id = ur.role_id left join sys_dept d on u.dept_id = d.dept_id left join sys_user_role ur on u.user_id = ur.user_id left join sys_role r on r.role_id = ur.role_id </sql> <select id="selectUserList" parameterType="SysUser" resultMap="SysUserResult"> select u.user_id, u.dept_id, u.nick_name, u.user_name, u.email, u.avatar, u.phonenumber, u.password, u.sex, u.status, u.del_flag, u.login_ip, u.login_date, u.create_by, u.create_time, u.remark,u.standardlevel, d.dept_name, d.leader from sys_user u left join sys_dept d on u.dept_id = d.dept_id where u.del_flag = '0' <if test="userId != null and userId != 0"> AND u.user_id = #{userId} </if> <if test="userName != null and userName != ''"> AND u.user_name like concat('%', #{userName}, '%') </if> <if test="status != null and status != ''"> AND u.status = #{status} </if> <if test="phonenumber != null and phonenumber != ''"> AND u.phonenumber like concat('%', #{phonenumber}, '%') </if> <if test="params.beginTime != null and params.beginTime != ''"><!-- 开始时间检索 --> AND date_format(u.create_time,'%y%m%d') >= date_format(#{params.beginTime},'%y%m%d') </if> <if test="params.endTime != null and params.endTime != ''"><!-- 结束时间检索 --> AND date_format(u.create_time,'%y%m%d') <= date_format(#{params.endTime},'%y%m%d') </if> <if test="deptId != null and deptId != 0"> AND (u.dept_id = #{deptId} OR u.dept_id IN ( SELECT t.dept_id FROM sys_dept t WHERE find_in_set(#{deptId}, ancestors) )) </if> <!-- 数据范围过滤 --> ${params.dataScope} </select> <select id="selectAllocatedList" parameterType="SysUser" resultMap="SysUserResult"> select distinct u.user_id, u.dept_id, u.user_name, u.nick_name, u.email, u.phonenumber, u.status, u.create_time from sys_user u left join sys_dept d on u.dept_id = d.dept_id left join sys_user_role ur on u.user_id = ur.user_id left join sys_role r on r.role_id = ur.role_id where u.del_flag = '0' and r.role_id = #{roleId} <if test="userName != null and userName != ''"> AND u.user_name like concat('%', #{userName}, '%') </if> <if test="phonenumber != null and phonenumber != ''"> AND u.phonenumber like concat('%', #{phonenumber}, '%') </if> <!-- 数据范围过滤 --> ${params.dataScope} </select> <select id="selectUnallocatedList" parameterType="SysUser" resultMap="SysUserResult"> select distinct u.user_id, u.dept_id, u.user_name, u.nick_name, u.email, u.phonenumber, u.status, u.create_time from sys_user u left join sys_dept d on u.dept_id = d.dept_id left join sys_user_role ur on u.user_id = ur.user_id left join sys_role r on r.role_id = ur.role_id where u.del_flag = '0' and (r.role_id != #{roleId} or r.role_id IS NULL) and u.user_id not in (select u.user_id from sys_user u inner join sys_user_role ur on u.user_id = ur.user_id and ur.role_id = #{roleId}) <if test="userName != null and userName != ''"> AND u.user_name like concat('%', #{userName}, '%') </if> <if test="phonenumber != null and phonenumber != ''"> AND u.phonenumber like concat('%', #{phonenumber}, '%') </if> <!-- 数据范围过滤 --> ${params.dataScope} </select> <select id="selectUserByUserName" parameterType="String" resultMap="SysUserResult"> <include refid="selectUserVo"/> where u.user_name = #{userName} </select> <select id="selectUserByOpenID" parameterType="String" resultMap="SysUserResult"> <include refid="selectUserVo"/> where u.openid = #{openid} </select> <select id="selectUserList" parameterType="com.ruoyi.common.core.domain.entity.SysUser" resultMap="SysUserResult"> select u.user_id, u.dept_id, u.nick_name, u.user_name, u.email, u.avatar, u.phonenumber, u.password, u.sex, u.status, u.del_flag, u.login_ip, u.login_date, u.create_by, u.create_time, u.remark,u.standardlevel, d.dept_name, d.leader from sys_user u left join sys_dept d on u.dept_id = d.dept_id where u.del_flag = '0' <if test="userId != null and userId != 0"> AND u.user_id = #{userId} </if> <if test="userName != null and userName != ''"> AND u.user_name like concat('%', #{userName}, '%') </if> <if test="status != null and status != ''"> AND u.status = #{status} </if> <if test="phonenumber != null and phonenumber != ''"> AND u.phonenumber like concat('%', #{phonenumber}, '%') </if> <if test="params.beginTime != null and params.beginTime != ''"><!-- 开始时间检索 --> AND date_format(u.create_time,'%y%m%d') >= date_format(#{params.beginTime},'%y%m%d') </if> <if test="params.endTime != null and params.endTime != ''"><!-- 结束时间检索 --> AND date_format(u.create_time,'%y%m%d') <= date_format(#{params.endTime},'%y%m%d') </if> <if test="deptId != null and deptId != 0"> AND (u.dept_id = #{deptId} OR u.dept_id IN ( SELECT t.dept_id FROM sys_dept t WHERE find_in_set(#{deptId}, ancestors) )) </if> <!-- 数据范围过滤 --> ${params.dataScope} </select> <select id="selectUserById" parameterType="Long" resultMap="SysUserResult"> <include refid="selectUserVo"/> where u.user_id = #{userId} </select> <select id="checkUserNameUnique" parameterType="String" resultType="int"> select count(1) from sys_user where user_name = #{userName} limit 1 </select> <select id="checkPhoneUnique" parameterType="String" resultMap="SysUserResult"> select user_id, phonenumber from sys_user where phonenumber = #{phonenumber} limit 1 </select> <select id="checkEmailUnique" parameterType="String" resultMap="SysUserResult"> select user_id, email from sys_user where email = #{email} limit 1 </select> <select id="selectAllocatedList" parameterType="com.ruoyi.common.core.domain.entity.SysUser" resultMap="SysUserResult"> select distinct u.user_id, u.dept_id, u.user_name, u.nick_name, u.email, u.phonenumber, u.status, u.create_time from sys_user u left join sys_dept d on u.dept_id = d.dept_id left join sys_user_role ur on u.user_id = ur.user_id left join sys_role r on r.role_id = ur.role_id where u.del_flag = '0' and r.role_id = #{roleId} <if test="userName != null and userName != ''"> AND u.user_name like concat('%', #{userName}, '%') </if> <if test="phonenumber != null and phonenumber != ''"> AND u.phonenumber like concat('%', #{phonenumber}, '%') </if> <!-- 数据范围过滤 --> ${params.dataScope} </select> <select id="selectUnallocatedList" parameterType="com.ruoyi.common.core.domain.entity.SysUser" resultMap="SysUserResult"> select distinct u.user_id, u.dept_id, u.user_name, u.nick_name, u.email, u.phonenumber, u.status, u.create_time from sys_user u left join sys_dept d on u.dept_id = d.dept_id left join sys_user_role ur on u.user_id = ur.user_id left join sys_role r on r.role_id = ur.role_id where u.del_flag = '0' and (r.role_id != #{roleId} or r.role_id IS NULL) and u.user_id not in (select u.user_id from sys_user u inner join sys_user_role ur on u.user_id = ur.user_id and ur.role_id = #{roleId}) <if test="userName != null and userName != ''"> AND u.user_name like concat('%', #{userName}, '%') </if> <if test="phonenumber != null and phonenumber != ''"> AND u.phonenumber like concat('%', #{phonenumber}, '%') </if> <!-- 数据范围过滤 --> ${params.dataScope} </select> <select id="selectUserByUserName" parameterType="String" resultMap="SysUserResult"> <include refid="selectUserVo"/> where u.user_name = #{userName} </select> <select id="selectUserByOpenID" parameterType="String" resultMap="SysUserResult"> <include refid="selectUserVo"/> where u.openid = #{openid} </select> <select id="selectUserById" parameterType="Long" resultMap="SysUserResult"> <include refid="selectUserVo"/> where u.user_id = #{userId} </select> <select id="checkUserNameUnique" parameterType="String" resultType="int"> select count(1) from sys_user where user_name = #{userName} limit 1 </select> <select id="checkPhoneUnique" parameterType="String" resultMap="SysUserResult"> select user_id, phonenumber from sys_user where phonenumber = #{phonenumber} limit 1 </select> <select id="checkEmailUnique" parameterType="String" resultMap="SysUserResult"> select user_id, email from sys_user where email = #{email} limit 1 </select> <select id="getNickname" resultType="com.ruoyi.system.domain.vo.Nickname"> select user_name, nick_name,phonenumber from sys_user </select> select user_name, nick_name, phonenumber from sys_user </select> <insert id="insertUser" parameterType="SysUser" useGeneratedKeys="true" keyProperty="userId"> insert into sys_user( <if test="userId != null and userId != 0">user_id,</if> <if test="deptId != null and deptId != 0">dept_id,</if> <if test="userName != null and userName != ''">user_name,</if> <if test="nickName != null and nickName != ''">nick_name,</if> <if test="email != null and email != ''">email,</if> <if test="avatar != null and avatar != ''">avatar,</if> <if test="phonenumber != null and phonenumber != ''">phonenumber,</if> <if test="sex != null and sex != ''">sex,</if> <if test="password != null and password != ''">password,</if> <if test="status != null and status != ''">status,</if> <if test="createBy != null and createBy != ''">create_by,</if> <if test="remark != null and remark != ''">remark,</if> create_time )values( <if test="userId != null and userId != ''">#{userId},</if> <if test="deptId != null and deptId != ''">#{deptId},</if> <if test="userName != null and userName != ''">#{userName},</if> <if test="nickName != null and nickName != ''">#{nickName},</if> <if test="email != null and email != ''">#{email},</if> <if test="avatar != null and avatar != ''">#{avatar},</if> <if test="phonenumber != null and phonenumber != ''">#{phonenumber},</if> <if test="sex != null and sex != ''">#{sex},</if> <if test="password != null and password != ''">#{password},</if> <if test="status != null and status != ''">#{status},</if> <if test="createBy != null and createBy != ''">#{createBy},</if> <if test="remark != null and remark != ''">#{remark},</if> sysdate() ) </insert> <update id="updateUser" parameterType="SysUser"> update sys_user <set> <if test="deptId != null and deptId != 0">dept_id = #{deptId},</if> <insert id="insertUser" parameterType="com.ruoyi.common.core.domain.entity.SysUser" useGeneratedKeys="true" keyProperty="userId"> insert into sys_user( <if test="userId != null and userId != 0">user_id,</if> <if test="deptId != null and deptId != 0">dept_id,</if> <if test="userName != null and userName != ''">user_name,</if> <if test="nickName != null and nickName != ''">nick_name,</if> <if test="email != null and email != ''">email,</if> <if test="avatar != null and avatar != ''">avatar,</if> <if test="phonenumber != null and phonenumber != ''">phonenumber,</if> <if test="sex != null and sex != ''">sex,</if> <if test="password != null and password != ''">password,</if> <if test="status != null and status != ''">status,</if> <if test="createBy != null and createBy != ''">create_by,</if> <if test="remark != null and remark != ''">remark,</if> create_time )values( <if test="userId != null and userId != ''">#{userId},</if> <if test="deptId != null and deptId != ''">#{deptId},</if> <if test="userName != null and userName != ''">#{userName},</if> <if test="nickName != null and nickName != ''">#{nickName},</if> <if test="email != null and email != ''">#{email},</if> <if test="avatar != null and avatar != ''">#{avatar},</if> <if test="phonenumber != null and phonenumber != ''">#{phonenumber},</if> <if test="sex != null and sex != ''">#{sex},</if> <if test="password != null and password != ''">#{password},</if> <if test="status != null and status != ''">#{status},</if> <if test="createBy != null and createBy != ''">#{createBy},</if> <if test="remark != null and remark != ''">#{remark},</if> sysdate() ) </insert> <update id="updateUser" parameterType="com.ruoyi.common.core.domain.entity.SysUser"> update sys_user <set> <if test="deptId != null and deptId != 0">dept_id = #{deptId},</if> <if test="openid != null and openid != ''">openid = #{openid},</if> <if test="userName != null and userName != ''">user_name = #{userName},</if> <if test="nickName != null and nickName != ''">nick_name = #{nickName},</if> <if test="email != null ">email = #{email},</if> <if test="phonenumber != null ">phonenumber = #{phonenumber},</if> <if test="sex != null and sex != ''">sex = #{sex},</if> <if test="avatar != null and avatar != ''">avatar = #{avatar},</if> <if test="password != null and password != ''">password = #{password},</if> <if test="status != null and status != ''">status = #{status},</if> <if test="loginIp != null and loginIp != ''">login_ip = #{loginIp},</if> <if test="loginDate != null">login_date = #{loginDate},</if> <if test="updateBy != null and updateBy != ''">update_by = #{updateBy},</if> <if test="remark != null">remark = #{remark},</if> update_time = sysdate() </set> where user_id = #{userId} </update> <update id="updateUserStatus" parameterType="SysUser"> update sys_user set status = #{status} where user_id = #{userId} </update> <update id="updateUserAvatar" parameterType="SysUser"> update sys_user set avatar = #{avatar} where user_name = #{userName} </update> <update id="resetUserPwd" parameterType="SysUser"> update sys_user set password = #{password} where user_name = #{userName} </update> <delete id="deleteUserById" parameterType="Long"> update sys_user set del_flag = '2' where user_id = #{userId} </delete> <delete id="deleteUserByIds" parameterType="Long"> update sys_user set del_flag = '2' where user_id in <foreach collection="array" item="userId" open="(" separator="," close=")"> #{userId} </foreach> </delete> <if test="userName != null and userName != ''">user_name = #{userName},</if> <if test="nickName != null and nickName != ''">nick_name = #{nickName},</if> <if test="email != null ">email = #{email},</if> <if test="phonenumber != null ">phonenumber = #{phonenumber},</if> <if test="sex != null and sex != ''">sex = #{sex},</if> <if test="avatar != null and avatar != ''">avatar = #{avatar},</if> <if test="password != null and password != ''">password = #{password},</if> <if test="status != null and status != ''">status = #{status},</if> <if test="loginIp != null and loginIp != ''">login_ip = #{loginIp},</if> <if test="loginDate != null">login_date = #{loginDate},</if> <if test="updateBy != null and updateBy != ''">update_by = #{updateBy},</if> <if test="remark != null">remark = #{remark},</if> <if test="errorNums != null">error_nums = #{errorNums},</if> update_time = sysdate() </set> where user_id = #{userId} </update> <update id="updateUserStatus" parameterType="com.ruoyi.common.core.domain.entity.SysUser"> update sys_user set status = #{status} where user_id = #{userId} </update> <update id="updateUserAvatar" parameterType="com.ruoyi.common.core.domain.entity.SysUser"> update sys_user set avatar = #{avatar} where user_name = #{userName} </update> <update id="resetUserPwd" parameterType="SysUser"> update sys_user set password = #{password} where user_name = #{userName} </update> <delete id="deleteUserById" parameterType="Long"> update sys_user set del_flag = '2' where user_id = #{userId} </delete> <delete id="deleteUserByIds" parameterType="Long"> update sys_user set del_flag = '2' where user_id in <foreach collection="array" item="userId" open="(" separator="," close=")"> #{userId} </foreach> </delete> <!--is null or LENGTH( trim( 字段 ) 判断是否为空 或无值 --> <update id="updateErrorNums" parameterType="com.ruoyi.common.core.domain.entity.SysUser"> update sys_user set error_nums = if(error_nums is null or LENGTH(trim(error_nums)) = 0, 0, error_nums) + 1, error_times = if(#{errorTimes} is null, now(), #{errorTimes}) where user_name = #{userName} </update> <update id="cleanErrorNums" parameterType="String"> update sys_user set error_nums = 0 where user_name = #{userName} </update> </mapper>
