From 47712cc6cd4d52fcd1dde44e2a400ccbb9c6ae7a Mon Sep 17 00:00:00 2001
From: zhongrj <646384940@qq.com>
Date: Fri, 12 Apr 2024 15:20:49 +0800
Subject: [PATCH] 民警网格区域查询合并，网格员区域树查询修改，解决不显示网格问题
---
src/main/java/org/springblade/modules/system/service/impl/UserServiceImpl.java | 135 ++++++++++++++++++++++++++++++---------------
1 files changed, 90 insertions(+), 45 deletions(-)
diff --git a/src/main/java/org/springblade/modules/system/service/impl/UserServiceImpl.java b/src/main/java/org/springblade/modules/system/service/impl/UserServiceImpl.java
index 02d2ecd..871e434 100644
--- a/src/main/java/org/springblade/modules/system/service/impl/UserServiceImpl.java
+++ b/src/main/java/org/springblade/modules/system/service/impl/UserServiceImpl.java
@@ -24,6 +24,8 @@
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.core.toolkit.Wrappers;
import lombok.AllArgsConstructor;
+import org.apache.commons.lang3.StringUtils;
+import org.apache.ibatis.annotations.Param;
import org.apache.logging.log4j.util.Strings;
import org.flowable.idm.engine.impl.persistence.entity.UserEntity;
import org.springblade.common.cache.DictCache;
@@ -49,6 +51,7 @@
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.house.vo.HouseholdVO;
import org.springblade.modules.police.entity.PoliceAffairsGridEntity;
import org.springblade.modules.police.service.IPoliceAffairsGridService;
import org.springblade.modules.property.entity.PropertyCompanyEntity;
@@ -146,12 +149,13 @@
/**
* 更新警格或网格的绑定
+ *
* @param user
*/
public void updateGridBind(User user) {
// 先删除原有区域的绑定
QueryWrapper<PoliceAffairsGridEntity> queryWrapper = new QueryWrapper<>();
- queryWrapper.eq("is_deleted",0).like("police_user_id",user.getId());
+ queryWrapper.eq("is_deleted", 0).like("police_user_id", user.getId());
// 删除掉之前已绑定的
List<PoliceAffairsGridEntity> list = SpringUtil.getBean(IPoliceAffairsGridService.class).list(queryWrapper);
// 遍历
@@ -159,7 +163,7 @@
List<String> arrayList = new ArrayList<>(Arrays.asList(policeAffairsGridEntity.getPoliceUserId().split(",")));
arrayList.remove(user.getId().toString());
// 更新
- policeAffairsGridEntity.setPoliceUserId(String.join(",",arrayList));
+ policeAffairsGridEntity.setPoliceUserId(String.join(",", arrayList));
// 解决更新报错
policeAffairsGridEntity.setGeom(null);
SpringUtil.getBean(IPoliceAffairsGridService.class).updateById(policeAffairsGridEntity);
@@ -169,15 +173,15 @@
for (String deptId : deptIds) {
// 查询对应的机构
Dept dept = SpringUtil.getBean(IDeptService.class).getById(deptId);
- if (null!=dept.getDeptNature()
+ if (null != dept.getDeptNature()
&& !Strings.isBlank(dept.getRegionCode())
- && dept.getDeptNature()==1
- ){
+ && dept.getDeptNature() == 1
+ ) {
QueryWrapper<PoliceAffairsGridEntity> wrapper = new QueryWrapper<>();
- wrapper.eq("is_deleted",0).eq("jw_grid_code",dept.getRegionCode());
+ wrapper.eq("is_deleted", 0).eq("jw_grid_code", dept.getRegionCode());
PoliceAffairsGridEntity policeAffairsGridEntity = policeAffairsGridService.getOne(wrapper);
// 更新
- if (null!=policeAffairsGridEntity){
+ if (null != policeAffairsGridEntity) {
if (!Strings.isBlank(policeAffairsGridEntity.getPoliceUserId())) {
if (!policeAffairsGridEntity.getPoliceUserId().contains(user.getId().toString())) {
policeAffairsGridEntity.setPoliceUserId(policeAffairsGridEntity.getPoliceUserId() + "," + user.getId());
@@ -186,7 +190,7 @@
// 更新
SpringUtil.getBean(IPoliceAffairsGridService.class).updateById(policeAffairsGridEntity);
}
- }else {
+ } else {
policeAffairsGridEntity.setPoliceUserId(user.getId().toString());
// 解决更新报错
policeAffairsGridEntity.setGeom(null);
@@ -373,7 +377,7 @@
throw new ServiceException("不能删除本账号!");
}
boolean deleteLogic = deleteLogic(Func.toLongList(userIds));
- if (deleteLogic){
+ if (deleteLogic) {
// 删除警格绑定
removePoliceGridBind(userIds);
}
@@ -382,6 +386,7 @@
/**
* 删除警格绑定
+ *
* @param userIds
*/
public void removePoliceGridBind(String userIds) {
@@ -389,10 +394,10 @@
for (String userId : userIdList) {
// 先删除原有区域的绑定
QueryWrapper<PoliceAffairsGridEntity> queryWrapper = new QueryWrapper<>();
- queryWrapper.eq("is_deleted",0).like("police_user_id",userId);
+ queryWrapper.eq("is_deleted", 0).like("police_user_id", userId);
// 删除掉之前已绑定的
List<PoliceAffairsGridEntity> list = SpringUtil.getBean(IPoliceAffairsGridService.class).list(queryWrapper);
- if (list.size()>0) {
+ if (list.size() > 0) {
// 遍历
for (PoliceAffairsGridEntity policeAffairsGridEntity : list) {
List<String> arrayList = new ArrayList<>(Arrays.asList(policeAffairsGridEntity.getPoliceUserId().split(",")));
@@ -442,8 +447,12 @@
}
@Override
- public List<UserExcel> exportUser(Wrapper<User> queryWrapper) {
- List<UserExcel> userList = baseMapper.exportUser(queryWrapper);
+ public List<UserExcel> exportUser(Wrapper<User> queryWrapper, String deptId) {
+ if (Strings.isBlank(deptId) && !AuthUtil.isAdministrator() && !AuthUtil.isAdmin()) {
+ deptId = AuthUtil.getDeptId();
+ }
+ List<Long> deptIdList = SysCache.getDeptChildIds(deptId);
+ List<UserExcel> userList = baseMapper.exportUser(queryWrapper, deptIdList);
userList.forEach(user -> {
user.setUserTypeName(DictCache.getValue(DictEnum.USER_TYPE, user.getUserType()));
user.setRoleName(StringUtil.join(SysCache.getRoleNames(user.getRoleId())));
@@ -602,19 +611,26 @@
} else {
IPropertyCompanyDistrictService bean1 = SpringUtil.getBean(IPropertyCompanyDistrictService.class);
return bean1.getDistictUserByCode(houseCode);
+ // 通过huosecode 查询物业工作人员
+// String deptId = AuthUtil.getDeptId();
+// List<Long> deptIdList = SysCache.getDeptChildIds(deptId);
+// return baseMapper.selectUserByDept(deptIdList);
}
}
+ /**
+ * 通过小区id查询物业人员
+ *
+ * @param districtId
+ * @param building
+ * @return
+ */
@Override
public List<UserEntity> getUserInfoByDistrictId(String districtId, String building) {
return baseMapper.getUserInfoByDistrictId(districtId, building);
}
- @Override
- public List<UserEntity> getUserInfoByDistrictIds(String districtIds) {
- List<String> list = JSON.parseArray(districtIds).toJavaList(String.class);
- return baseMapper.getUserInfoByDistrictIds(list);
- }
+
/**
* 处理漏绑定的user_dept
@@ -637,6 +653,9 @@
@Override
public List<User> getUserInfoByPropertyId(String propertyCompanyId, String roleId) {
// 查询物业公司，获取物业公司的机构
+ if (StringUtils.isBlank(propertyCompanyId)) {
+ return new ArrayList<>();
+ }
IPropertyCompanyService bean = SpringUtil.getBean(IPropertyCompanyService.class);
PropertyCompanyEntity one = bean.getOne(Wrappers.<PropertyCompanyEntity>lambdaQuery().eq(PropertyCompanyEntity::getId, propertyCompanyId));
return baseMapper.getUserInfoByPropertyId(one.getDeptId().toString(), roleId);
@@ -664,6 +683,7 @@
/**
* 导入民警信息
+ *
* @param data
*/
@Override
@@ -672,21 +692,21 @@
for (PoliceUserExcel userExcel : data) {
// 查询用户
List<User> list = getUserListByPhoneOrAccount(userExcel.getPhone());
- if (list.size()>0){
+ if (list.size() > 0) {
User userInfo = list.get(0);
// 判断角色
- if (!userInfo.getRoleId().contains("1727864411451359233")){
+ if (!userInfo.getRoleId().contains("1727864411451359233")) {
userInfo.setRoleId(userInfo.getRoleId() + ",1727864411451359233");
}
// 更新机构
- setDeptId(userInfo,userExcel);
+ setDeptId(userInfo, userExcel);
// 更新
updateById(userInfo);
// 更新用户机构绑定
submitUserDept(userInfo);
// 更新社区民警绑定信息
updateGridBind(userInfo);
- }else {
+ } else {
// 插入用户角色
User user = new User();
user.setTenantId("000000");
@@ -697,7 +717,7 @@
user.setPhone(userExcel.getPhone());
user.setAccount(userExcel.getPhone());
// 更新机构
- setDeptId(user,userExcel);
+ setDeptId(user, userExcel);
// 设置初始密码
user.setPassword("123456");
// 保存
@@ -713,24 +733,24 @@
/**
* 设置机构
*/
- public void setDeptId(User user,PoliceUserExcel userExcel) {
+ public void setDeptId(User user, PoliceUserExcel userExcel) {
// 查询机构
QueryWrapper<PoliceAffairsGridEntity> queryWrapper = new QueryWrapper<>();
- queryWrapper.eq("is_deleted",0)
- .eq("community_code",userExcel.getCommunityCode())
- .eq("pcs_name",userExcel.getPoliceStationName());
+ queryWrapper.eq("is_deleted", 0)
+ .eq("community_code", userExcel.getCommunityCode())
+ .eq("pcs_name", userExcel.getPoliceStationName());
PoliceAffairsGridEntity policeAffairsGridEntity = policeAffairsGridService.getOne(queryWrapper);
- if (null!=policeAffairsGridEntity){
+ if (null != policeAffairsGridEntity) {
// 查询对应绑定的机构
QueryWrapper<Dept> wrapper = new QueryWrapper<>();
- wrapper.eq("is_deleted",0)
- .eq("dept_nature",1)
- .eq("region_code",policeAffairsGridEntity.getJwGridCode());
+ wrapper.eq("is_deleted", 0)
+ .eq("dept_nature", 1)
+ .eq("region_code", policeAffairsGridEntity.getJwGridCode());
Dept dept = SpringUtil.getBean(IDeptService.class).getOne(wrapper);
- if (null!=dept){
- if (null!=user.getId()){
+ if (null != dept) {
+ if (null != user.getId()) {
DeptNotHandle(user, dept);
- }else {
+ } else {
user.setDeptId(dept.getId().toString());
}
}
@@ -739,32 +759,33 @@
/**
* 机构不为空时处理
+ *
* @param user
* @param dept
*/
public void DeptNotHandle(User user, Dept dept) {
// 更新设置机构
- if (!Strings.isBlank(user.getDeptId())){
+ if (!Strings.isBlank(user.getDeptId())) {
// 查询对应的派出所（去掉）
Dept deptPcs = SpringUtil.getBean(IDeptService.class).getDeptByDeptIds(user.getDeptId());
- if (null!=deptPcs) {
+ if (null != deptPcs) {
// 如果存在需要去掉派出所的机构id
List<String> list = new ArrayList<>(Arrays.asList(user.getDeptId().split(",")));
// 先删除派出所对应的机构ID
- if (list.contains(deptPcs.getId().toString())){
+ if (list.contains(deptPcs.getId().toString())) {
list.remove(deptPcs.getId().toString());
- user.setDeptId(String.join(",",list));
+ user.setDeptId(String.join(",", list));
}
// 删完后可能就没了
if (!Strings.isBlank(user.getDeptId())) {
if (!user.getDeptId().contains(dept.getId().toString())) {
user.setDeptId(user.getDeptId() + "," + dept.getId());
}
- }else {
+ } else {
// 删完后的
user.setDeptId(dept.getId().toString());
}
- }else {
+ } else {
if (!user.getDeptId().contains(dept.getId().toString())) {
user.setDeptId(user.getDeptId() + "," + dept.getId());
}
@@ -774,23 +795,24 @@
/**
* 更新社区民警绑定信息
+ *
* @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());
+ wrapper.eq("is_deleted", 0).eq("code", userExcel.getCommunityCode());
CommunityEntity one = SpringUtil.getBean(ICommunityService.class).getOne(wrapper);
- if (null!=one){
+ if (null != one) {
String userId = user.getId().toString();
- if (!Strings.isBlank(one.getResPoliceUserId())){
- if(!one.getResPoliceUserId().contains(userId)) {
+ if (!Strings.isBlank(one.getResPoliceUserId())) {
+ if (!one.getResPoliceUserId().contains(userId)) {
one.setResPoliceUserId(one.getResPoliceUserId() + "," + userId);
// 更新
SpringUtil.getBean(ICommunityService.class).updateById(one);
}
- }else {
+ } else {
one.setResPoliceUserId(userId);
// 更新
SpringUtil.getBean(ICommunityService.class).updateById(one);
@@ -807,4 +829,27 @@
public List<User> getUserListByDeptIds(String receiveDept) {
return baseMapper.getUserListByDeptIds(receiveDept);
}
+
+ /**
+ * 通过经纬度查询最近的民警人员
+ *
+ * @param longitude
+ * @param latitude
+ * @return
+ */
+ @Override
+ public List<User> getPoliceUser(String longitude, String latitude, String houseCode) {
+ List<User> policeUser = baseMapper.getPoliceUser(longitude, latitude);
+ // 自动生成警单
+// if (StringUtils.isNotBlank(houseCode)) {
+// IPoliceAlarmRecordsService policeAlarmRecordsService = SpringUtil.getBean(IPoliceAlarmRecordsService.class);
+// PoliceAlarmRecordsEntity policeAlarmRecordsEntity = new PoliceAlarmRecordsEntity();
+// policeAlarmRecordsEntity.setHouseCode(houseCode);
+// if (policeUser != null && policeUser.size() == 1) {
+// policeAlarmRecordsEntity.setPoliceId(policeUser.get(0).getId());
+// }
+// policeAlarmRecordsService.save(policeAlarmRecordsEntity);
+// }
+ return policeUser;
+ }
}
--
Gitblit v1.9.3