From db0b87b36c44a5a9bc32a915769024f0c9db7c05 Mon Sep 17 00:00:00 2001
From: 龚焕茏 <2842157468@qq.com>
Date: 星期四, 11 四月 2024 15:10:49 +0800
Subject: [PATCH] 运维单位绑定账号
---
ycl-server/src/main/java/com/ycl/platform/service/impl/YwUnitServiceImpl.java | 51 ++++++++++++++++++++++++-
ycl-server/src/main/resources/mapper/system/SysRoleMapper.xml | 8 +++-
ycl-server/src/main/java/com/ycl/system/mapper/SysRoleMapper.java | 8 ++++
3 files changed, 63 insertions(+), 4 deletions(-)
diff --git a/ycl-server/src/main/java/com/ycl/platform/service/impl/YwUnitServiceImpl.java b/ycl-server/src/main/java/com/ycl/platform/service/impl/YwUnitServiceImpl.java
index 8f9d143..35e1fab 100644
--- a/ycl-server/src/main/java/com/ycl/platform/service/impl/YwUnitServiceImpl.java
+++ b/ycl-server/src/main/java/com/ycl/platform/service/impl/YwUnitServiceImpl.java
@@ -1,7 +1,9 @@
package com.ycl.platform.service.impl;
+import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
+import java.util.Collections;
import java.util.HashMap;
import java.util.List;
@@ -12,10 +14,17 @@
import com.ycl.platform.domain.vo.YwUnitVO;
import com.ycl.system.Result;
import com.ycl.platform.mapper.YwUnitMapper;
+import com.ycl.system.domain.SysUserRole;
+import com.ycl.system.entity.SysRole;
+import com.ycl.system.entity.SysUser;
+import com.ycl.system.mapper.SysRoleMapper;
+import com.ycl.system.mapper.SysUserMapper;
+import com.ycl.system.mapper.SysUserRoleMapper;
import com.ycl.system.page.PageUtil;
import com.ycl.platform.service.YwUnitService;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.ycl.utils.DateUtils;
+import com.ycl.utils.SecurityUtils;
import org.springframework.stereotype.Service;
import org.springframework.beans.BeanUtils;
import org.springframework.util.Assert;
@@ -37,6 +46,9 @@
public class YwUnitServiceImpl extends ServiceImpl<YwUnitMapper, YwUnit> implements YwUnitService {
private final YwUnitMapper ywUnitMapper;
+ private final SysUserMapper sysUserMapper;
+ private final SysUserRoleMapper sysUserRoleMapper;
+ private final SysRoleMapper sysRoleMapper;
/**
* 娣诲姞
@@ -45,9 +57,24 @@
*/
@Override
public Result add(YwUnitForm form) {
- // todo 澧炲姞瀵瑰簲璐﹀彿
YwUnit entity = YwUnitForm.getEntityByForm(form, null);
if(baseMapper.insert(entity) > 0) {
+ // 鏂板杩愮淮浜哄憳璐﹀彿
+ SysUser sysUser = new SysUser();
+ sysUser.setDeptId(null);
+ sysUser.setUserName(entity.getUnitAdminAccount());
+ sysUser.setNickName(entity.getUnitContact());
+ sysUser.setPhonenumber(entity.getUnitContactPhone());
+ sysUser.setPassword(SecurityUtils.encryptPassword("123456"));
+ sysUserMapper.insertUser(sysUser);
+ // 鑾峰彇杩愮淮浜哄憳瑙掕壊
+ SysRole sysRole = sysRoleMapper.selectRoleByKey("yw_user");
+ if (Objects.isNull(sysRole)) { return Result.error("杩愮淮瑙掕壊涓嶅瓨鍦�"); }
+ // 缁戝畾璐﹀彿瑙掕壊鍏崇郴
+ SysUserRole sysUserRole = new SysUserRole();
+ sysUserRole.setRoleId(sysRole.getRoleId());
+ sysUserRole.setUserId(sysUser.getUserId());
+ sysUserRoleMapper.batchUserRole(Collections.singletonList(sysUserRole));
return Result.ok("娣诲姞鎴愬姛");
}
return Result.error("娣诲姞澶辫触");
@@ -60,13 +87,19 @@
*/
@Override
public Result update(YwUnitForm form) {
- // todo 淇敼瀵瑰簲璐﹀彿
YwUnit entity = baseMapper.selectById(form.getId());
// 涓虹┖鎶汭llegalArgumentException锛屽仛鍏ㄥ眬寮傚父澶勭悊
Assert.notNull(entity, "璁板綍涓嶅瓨鍦�");
BeanUtils.copyProperties(form, entity);
if (baseMapper.updateById(entity) > 0) {
+ // 淇敼杩愮淮鍗曚綅璐﹀彿淇℃伅
+ SysUser sysUser = sysUserMapper.selectUserByUserName(entity.getUnitAdminAccount());
+ if (Objects.nonNull(sysUser)) {
+ sysUser.setPhonenumber(entity.getUnitContactPhone());
+ sysUser.setNickName(entity.getUnitContact());
+ sysUserMapper.updateUser(sysUser);
+ }
return Result.ok("淇敼鎴愬姛");
}
return Result.error("淇敼澶辫触");
@@ -79,6 +112,14 @@
*/
@Override
public Result remove(List<String> ids) {
+ ids.forEach(id -> {
+ // 鍒犻櫎杩愮淮浜哄憳璐﹀彿
+ SysUser sysUser = sysUserMapper.selectUserByUserName(baseMapper.selectById(id).getUnitAdminAccount());
+ if (Objects.nonNull(sysUser)) {
+ sysUserRoleMapper.deleteUserRoleByUserId(sysUser.getUserId());
+ sysUserMapper.deleteUserById(sysUser.getUserId());
+ }
+ });
if(baseMapper.deleteBatchIds(ids) > 0) {
return Result.ok("鍒犻櫎鎴愬姛");
}
@@ -92,6 +133,12 @@
*/
@Override
public Result removeById(String id) {
+ // 鍒犻櫎杩愮淮浜哄憳璐﹀彿
+ SysUser sysUser = sysUserMapper.selectUserByUserName(baseMapper.selectById(id).getUnitAdminAccount());
+ if (Objects.nonNull(sysUser)) {
+ sysUserRoleMapper.deleteUserRoleByUserId(sysUser.getUserId());
+ sysUserMapper.deleteUserById(sysUser.getUserId());
+ }
if(baseMapper.deleteById(id) > 0) {
return Result.ok("鍒犻櫎鎴愬姛");
}
diff --git a/ycl-server/src/main/java/com/ycl/system/mapper/SysRoleMapper.java b/ycl-server/src/main/java/com/ycl/system/mapper/SysRoleMapper.java
index a13df4b..eb620c0 100644
--- a/ycl-server/src/main/java/com/ycl/system/mapper/SysRoleMapper.java
+++ b/ycl-server/src/main/java/com/ycl/system/mapper/SysRoleMapper.java
@@ -1,5 +1,6 @@
package com.ycl.system.mapper;
+import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
import com.ycl.system.entity.SysRole;
import org.apache.ibatis.annotations.Mapper;
@@ -107,4 +108,11 @@
* @return 缁撴灉
*/
public int deleteRoleByIds(Long[] roleIds);
+
+ /**
+ * 鏍规嵁瑙掕壊缂栫爜鏌ヨ瑙掕壊
+ * @param roleKey 瑙掕壊缂栫爜
+ * @return 瑙掕壊
+ */
+ SysRole selectRoleByKey(String roleKey);
}
diff --git a/ycl-server/src/main/resources/mapper/system/SysRoleMapper.xml b/ycl-server/src/main/resources/mapper/system/SysRoleMapper.xml
index 86adbf5..d1a41e8 100644
--- a/ycl-server/src/main/resources/mapper/system/SysRoleMapper.xml
+++ b/ycl-server/src/main/resources/mapper/system/SysRoleMapper.xml
@@ -92,8 +92,12 @@
<include refid="selectRoleVo"/>
where r.role_key=#{roleKey} and r.del_flag = '0' limit 1
</select>
-
- <insert id="insertRole" parameterType="com.ycl.system.entity.SysRole" useGeneratedKeys="true" keyProperty="roleId">
+
+ <select id="selectRoleByKey" resultType="com.ycl.system.entity.SysRole">
+ select * from sys_role where role_key = #{roleKey} and del_flag = '0' limit 1
+ </select>
+
+ <insert id="insertRole" parameterType="com.ycl.system.entity.SysRole" useGeneratedKeys="true" keyProperty="roleId">
insert into sys_role(
<if test="roleId != null and roleId != 0">role_id,</if>
<if test="roleName != null and roleName != ''">role_name,</if>
--
Gitblit v1.8.0