用户机构调整绑定警格处理

zhongrj

2024-02-05 bb758220283deccd1ae7ea79a7c635d8828c71be

 src/main/java/org/springblade/modules/system/service/impl/UserServiceImpl.java

@@ -19,6 +19,7 @@

import com.baomidou.mybatisplus.core.conditions.Wrapper;
import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.core.toolkit.Wrappers;
import lombok.AllArgsConstructor;
@@ -42,25 +43,28 @@
import org.springblade.core.tool.support.Kv;
import org.springblade.core.tool.utils.*;
import org.springblade.modules.auth.enums.UserEnum;
import org.springblade.modules.community.entity.CommunityEntity;
import org.springblade.modules.community.service.ICommunityService;
import org.springblade.modules.grid.service.IGridmanService;
import org.springblade.modules.house.entity.HouseholdEntity;
import org.springblade.modules.house.service.IHouseholdService;
import org.springblade.modules.police.entity.PoliceAffairsGridEntity;
import org.springblade.modules.police.service.IPoliceAffairsGridService;
import org.springblade.modules.property.entity.PropertyCompanyEntity;
import org.springblade.modules.property.service.IPropertyCompanyDistrictService;
import org.springblade.modules.property.service.IPropertyCompanyService;
import org.springblade.modules.system.entity.*;
import org.springblade.modules.system.excel.PoliceUserExcel;
import org.springblade.modules.system.excel.UserExcel;
import org.springblade.modules.system.mapper.UserMapper;
import org.springblade.modules.system.service.IRoleService;
import org.springblade.modules.system.service.IUserDeptService;
import org.springblade.modules.system.service.IUserOauthService;
import org.springblade.modules.system.service.IUserService;
import org.springblade.modules.system.service.*;
import org.springblade.modules.system.vo.UserDetailVO;
import org.springblade.modules.system.vo.UserVO;
import org.springblade.modules.system.wrapper.UserWrapper;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;

import java.util.ArrayList;
import java.util.Collections;
import java.util.List;
import java.util.Objects;
import java.util.*;

import static org.springblade.common.constant.CommonConstant.DEFAULT_PARAM_PASSWORD;

@@ -78,6 +82,7 @@
   private final IUserOauthService userOauthService;
   private final IRoleService roleService;
   private final BladeTenantProperties tenantProperties;
   private final IPoliceAffairsGridService policeAffairsGridService;

   @Override
   @Transactional(rollbackFor = Exception.class)
@@ -106,7 +111,11 @@
      if (userCount > 0L && Func.isEmpty(user.getId())) {
         throw new ServiceException(StringUtil.format("当前用户 [{}] 已存在!", user.getAccount()));
      }
      return save(user) && submitUserDept(user);
      boolean save = save(user);
      // 更新警格或网格的绑定
      updateGridBind(user);
      // 返回
      return save && submitUserDept(user);
   }

   @Override
@@ -129,7 +138,48 @@
   public boolean updateUserInfo(User user) {
      user.setPassword(null);
      boolean b = updateById(user);
      // 更新警格或网格的绑定
      updateGridBind(user);
      return b;
   }

   /**
    * 更新警格或网格的绑定
    * @param user
    */
   public void updateGridBind(User user) {
      // 判断机构类型
      List<String> deptIds = Arrays.asList(user.getDeptId().split(","));
      for (String deptId : deptIds) {
         // 查询对应的机构
         Dept dept = SpringUtil.getBean(IDeptService.class).getById(deptId);
         if (null!=dept.getDeptNature()
            && !Strings.isBlank(dept.getRegionCode())
            && dept.getDeptNature()==1
         ){
            QueryWrapper<PoliceAffairsGridEntity> wrapper = new QueryWrapper<>();
            wrapper.eq("is_deleted",0).eq("jw_grid_code",dept.getRegionCode());
            PoliceAffairsGridEntity policeAffairsGridEntity = policeAffairsGridService.getOne(wrapper);
            // 更新
            if (null!=policeAffairsGridEntity){
               if (!Strings.isBlank(policeAffairsGridEntity.getPoliceUserId())) {
                  if (!policeAffairsGridEntity.getPoliceUserId().contains(user.getId().toString())) {
                     policeAffairsGridEntity.setPoliceUserId(policeAffairsGridEntity.getPoliceUserId() + "," + user.getId());
                     // 解决更新报错
                     policeAffairsGridEntity.setGeom(null);
                     // 更新
                     SpringUtil.getBean(IPoliceAffairsGridService.class).updateById(policeAffairsGridEntity);
                  }
               }else {
                  policeAffairsGridEntity.setPoliceUserId(user.getId().toString());
                  // 解决更新报错
                  policeAffairsGridEntity.setGeom(null);
                  // 更新
                  SpringUtil.getBean(IPoliceAffairsGridService.class).updateById(policeAffairsGridEntity);
               }
            }
         }
      }
   }

   private boolean submitUserDept(User user) {
@@ -465,23 +515,26 @@

   /**
    * 根据手机号查询对应账号和手机号的用户信息
    *
    * @param phoneNumber
    * @return
    */
   @Override
   public List<User> getUserListByPhoneOrAccount(String phoneNumber) {
      return baseMapper.getUserListByPhoneOrAccount( phoneNumber);
      return baseMapper.getUserListByPhoneOrAccount(phoneNumber);
   }

   /**
    * 获取用户信息
    *
    * @return
    */
   @Override
   public UserDetailVO getUserInfo(Long userId) {
      // 根据用户id 获取用户详情信息
      UserDetailVO userVO = baseMapper.getUserInfo(userId);
      if (null!=userVO){
      if (null != userVO) {
         // 设置机构
         userVO.setPassword(null);
      }
      // 返回
@@ -495,7 +548,7 @@

   @Override
   public List<UserEntity> getUserInfoByCode(String houseCode, String type) {
      if (type.equals("1")) {
      if (type.equals("0")) {
         IGridmanService bean = SpringUtil.getBean(IGridmanService.class);
         return bean.getGridManByCode(houseCode);
      } else {
@@ -503,4 +556,137 @@
         return bean1.getDistictUserByCode(houseCode);
      }
   }

   @Override
   public List<UserEntity> getUserInfoByDistrictId(String districtId, String building) {
      return baseMapper.getUserInfoByDistrictId(districtId, building);
   }

   /**
    * 处理漏绑定的user_dept
    */
   @Override
   public Object handleUserDept() {
      // 查询没有匹配的数据
      List<User> list = baseMapper.getNotBindUserDept();
      // 遍历处理
      for (User user : list) {
         UserDept userDept = new UserDept();
         userDept.setUserId(user.getId());
         userDept.setDeptId(Long.parseLong(user.getDeptId()));
         // 保存
         userDeptService.save(userDept);
      }
      return null;
   }

   @Override
   public List<User> getUserInfoByPropertyId(String propertyCompanyId, String roleId) {
      // 查询物业公司，获取物业公司的机构
      IPropertyCompanyService bean = SpringUtil.getBean(IPropertyCompanyService.class);
      PropertyCompanyEntity one = bean.getOne(Wrappers.<PropertyCompanyEntity>lambdaQuery().eq(PropertyCompanyEntity::getId, propertyCompanyId));
      return baseMapper.getUserInfoByPropertyId(one.getDeptId().toString(), roleId);
   }

   @Override
   public Object handleUser() {
      List<User> list = list(Wrappers.<User>lambdaQuery()
         .eq(User::getDeptId, "1727979636479037441")
         .eq(User::getRoleId, "1717429059648606209"));
      IHouseholdService bean = SpringUtil.getBean(IHouseholdService.class);
      int a = 0;
      for (User user : list) {
         System.out.println("查詢處理啊的人：" + user.getId());
         HouseholdEntity one = bean.getOne(Wrappers.<HouseholdEntity>lambdaQuery()
            .eq(HouseholdEntity::getAssociatedUserId, user.getId())
            .eq(HouseholdEntity::getIsDeleted, 0));
         if (one != null) {
            a++;
         }
         System.out.println("查詢處理啊的人：" + a);
      }
      return null;
   }

   /**
    * 导入民警信息
    * @param data
    */
   @Override
   @Transactional(rollbackFor = Exception.class)
   public void importPoliceUser(List<PoliceUserExcel> data) {
      for (PoliceUserExcel userExcel : data) {
         // 查询用户
         List<User> list = getUserListByPhoneOrAccount(userExcel.getPhone());
         if (list.size()>0){
            User userInfo = list.get(0);
            // 判断角色
            if (!userInfo.getRoleId().contains("1727864411451359233")){
               userInfo.setRoleId(userInfo.getRoleId() + ",1727864411451359233");
               // 更新
               updateById(userInfo);
               // 更新社区民警绑定信息
               updateCommunityInfo(userExcel,userInfo);
            }
         }else {
            // 插入用户角色
            User user = new User();
            user.setTenantId("000000");
            user.setUserType(1);
            user.setRoleId("1727864411451359233");
            user.setName(userExcel.getRealName());
            user.setRealName(userExcel.getRealName());
            user.setPhone(userExcel.getPhone());
            user.setAccount(userExcel.getPhone());
            // 查询机构
            QueryWrapper<Dept> queryWrapper = new QueryWrapper<>();
            queryWrapper.eq("is_deleted",0).eq("dept_name",userExcel.getPoliceStationName());
            Dept dept = SpringUtil.getBean(IDeptService.class).getOne(queryWrapper);
            if (null!=dept){
               user.setDeptId(dept.getId().toString());
            }
            user.setPassword("123456");
            // 保存
            submit(user);
            // 更新社区民警绑定信息
            updateCommunityInfo(userExcel,user);
         }
      }
   }

   /**
    * 更新社区民警绑定信息
    * @param userExcel
    * @param user
    */
   public void updateCommunityInfo(PoliceUserExcel userExcel, User user) {
      QueryWrapper<CommunityEntity> wrapper = new QueryWrapper<>();
      System.out.println("wrapper = " + userExcel.getCommunityCode());
      wrapper.eq("is_deleted",0).eq("code",userExcel.getCommunityCode());
      CommunityEntity one = SpringUtil.getBean(ICommunityService.class).getOne(wrapper);
      if (null!=one){
         String userId = user.getId().toString();
         if (!Strings.isBlank(one.getResPoliceUserId())){
            if(!one.getResPoliceUserId().contains(userId)) {
               one.setResPoliceUserId(one.getResPoliceUserId() + "," + userId);
               // 更新
               SpringUtil.getBean(ICommunityService.class).updateById(one);
            }
         }else {
            one.setResPoliceUserId(userId);
            // 更新
            SpringUtil.getBean(ICommunityService.class).updateById(one);
         }
      }
   }

   @Override
   public List<User> getUserListByIds(String receiveUser) {
      return baseMapper.selectBatchIds(Arrays.asList(receiveUser.split(",")));
   }

   @Override
   public List<User> getUserListByDeptIds(String receiveDept) {
      return baseMapper.getUserListByDeptIds(receiveDept);
   }
}