package com.panzhihua.service_user.service.impl;
|
|
import java.util.ArrayList;
|
import java.util.Date;
|
import java.util.List;
|
|
import javax.annotation.Resource;
|
|
import org.apache.commons.lang3.ObjectUtils;
|
import org.springframework.beans.BeanUtils;
|
import org.springframework.data.redis.core.StringRedisTemplate;
|
import org.springframework.data.redis.core.ValueOperations;
|
import org.springframework.stereotype.Service;
|
import org.springframework.transaction.annotation.Transactional;
|
|
import com.alibaba.fastjson.JSONArray;
|
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
|
import com.baomidou.mybatisplus.core.metadata.IPage;
|
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
|
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
|
import com.panzhihua.common.model.dtos.community.ExportSpecialUserDTO;
|
import com.panzhihua.common.model.dtos.community.ExportUserDTO;
|
import com.panzhihua.common.model.dtos.user.ComMngUserTagDTO;
|
import com.panzhihua.common.model.dtos.user.EexcelUserDTO;
|
import com.panzhihua.common.model.dtos.user.InputUserTagsDTO;
|
import com.panzhihua.common.model.dtos.user.PageInputUserDTO;
|
import com.panzhihua.common.model.vos.R;
|
import com.panzhihua.common.model.vos.community.ComMngStructAreaVO;
|
import com.panzhihua.common.model.vos.community.ComMngStructHouseVO;
|
import com.panzhihua.common.model.vos.user.ComMngFamilyInfoVO;
|
import com.panzhihua.common.model.vos.user.ComMngTagVO;
|
import com.panzhihua.common.model.vos.user.CommunityUserInfoVO;
|
import com.panzhihua.common.model.vos.user.InputUserInfoVO;
|
import com.panzhihua.common.utlis.IdCard;
|
import com.panzhihua.common.utlis.SensitiveUtil;
|
import com.panzhihua.common.utlis.StringUtils;
|
import com.panzhihua.service_user.dao.ComMngUserTagDAO;
|
import com.panzhihua.service_user.dao.SysUserInputDAO;
|
import com.panzhihua.service_user.model.dos.ComMngUserTagDO;
|
import com.panzhihua.service_user.model.dos.SysUserInputDO;
|
import com.panzhihua.service_user.service.SysUserInputService;
|
|
/**
|
* @program: springcloud_k8s_panzhihuazhihuishequ
|
* @description: 居民导入
|
* @author: huang.hongfa weixin hhf9596 qq 959656820
|
* @create: 2021-02-05 17:42
|
**/
|
@Service
|
public class SysUserInputServiceImpl extends ServiceImpl<SysUserInputDAO, SysUserInputDO>
|
implements SysUserInputService {
|
@Resource
|
private SysUserInputDAO sysUserInputDAO;
|
@Resource
|
private StringRedisTemplate stringRedisTemplate;
|
@Resource
|
private ComMngUserTagDAO comMngUserTagDAO;
|
|
/**
|
* 批量导入居民用户
|
*
|
* @param list
|
* 居民用户集合
|
* @param areaName
|
* 小区名字
|
* @return 导入结果
|
*/
|
@Override
|
@Transactional(rollbackFor = Exception.class)
|
public R batchSaveUser(List<EexcelUserDTO> list, StringBuffer areaName) {
|
List<SysUserInputDO> sysUserInputDOS = new ArrayList<>();
|
if (!ObjectUtils.isEmpty(list)) {
|
ComMngStructAreaVO comMngStructAreaVO = sysUserInputDAO.selectByAreaName(areaName.toString());
|
// 查询该小区所有房屋信息用来进行匹配房屋编码
|
String key = "house_" + areaName;
|
Boolean aBoolean = stringRedisTemplate.hasKey(key);
|
ValueOperations<String, String> stringStringValueOperations = stringRedisTemplate.opsForValue();
|
List<ComMngStructHouseVO> comMngStructHouseVOS = new ArrayList<>();
|
if (aBoolean) {
|
String value = stringStringValueOperations.get(key);
|
comMngStructHouseVOS = JSONArray.parseArray(value, ComMngStructHouseVO.class);
|
} else {
|
comMngStructHouseVOS = sysUserInputDAO.selectHouserByareaName(areaName.toString());
|
}
|
List<ComMngStructHouseVO> comMngStructHouseVOS1 = comMngStructHouseVOS;
|
list.forEach(eexcelUserDTO -> {
|
// 判断身份证和门牌号是否重复
|
int count = sysUserInputDAO.selectCount(
|
new QueryWrapper<SysUserInputDO>().lambda().eq(SysUserInputDO::getIdCard, eexcelUserDTO.getIdCard())
|
.and(wrapper -> wrapper.eq(SysUserInputDO::getDoorNumber, eexcelUserDTO.getDoorNumber())));
|
if (count == 0) {
|
SysUserInputDO sysUserInputDO = new SysUserInputDO();
|
String doorNumber = eexcelUserDTO.getDoorNumber();
|
// 暂时注释门牌号匹配设置房屋编号功能
|
// List<ComMngStructHouseVO> collect = comMngStructHouseVOS1.stream().filter(comMngStructHouseVO ->
|
// comMngStructHouseVO.getHouseName().equals(doorNumber)).collect(Collectors.toList());
|
// if (ObjectUtils.isEmpty(collect)) {
|
// throw new ServiceException("门牌号后台不存在或格式错误,错误门牌号为"+doorNumber);
|
// }else{
|
// sysUserInputDO.setHouseCode(collect.get(0).getHouseCode());
|
// }
|
sysUserInputDO.setAreaId(comMngStructAreaVO.getId());
|
sysUserInputDO.setCommunityId(comMngStructAreaVO.getCommunityId());
|
sysUserInputDO.setCompany(eexcelUserDTO.getCompany());
|
sysUserInputDO.setDoorNumber(doorNumber);
|
sysUserInputDO.setEducation(eexcelUserDTO.getEducation());
|
sysUserInputDO.setIdCard(eexcelUserDTO.getIdCard());
|
sysUserInputDO.setIsContact(eexcelUserDTO.getIsContact().equals("是") ? 1 : 0);
|
sysUserInputDO.setIsPanzhihua(eexcelUserDTO.getIsPanZhiHua().equals("是") ? 1 : 0);
|
sysUserInputDO.setIsRent(eexcelUserDTO.getIsRent().equals("是") ? 1 : 0);
|
sysUserInputDO.setKeyPersonnel(eexcelUserDTO.getKeyPersonnel().equals("是") ? 1 : 0);
|
sysUserInputDO.setLowIncomeHouseholds(eexcelUserDTO.getLowIncomeHouseholds().equals("是") ? 1 : 0);
|
sysUserInputDO.setLowIncomePeople(eexcelUserDTO.getLowIncomePeople().equals("是") ? 1 : 0);
|
sysUserInputDO.setMajor(eexcelUserDTO.getMajor().equals("是") ? 1 : 0);
|
sysUserInputDO.setMaritalStatus(eexcelUserDTO.getMaritalStatus().equals("是") ? 1 : 0);
|
sysUserInputDO.setName(eexcelUserDTO.getName());
|
sysUserInputDO.setNation(eexcelUserDTO.getNation());
|
sysUserInputDO.setOldPeople(eexcelUserDTO.getOldPeople().equals("是") ? 1 : 0);
|
sysUserInputDO.setDisability(eexcelUserDTO.getDisability().equals("是") ? 1 : 0);
|
sysUserInputDO.setPhone(eexcelUserDTO.getPhone());
|
String politicalOutlook = eexcelUserDTO.getPoliticalOutlook();
|
if (!ObjectUtils.isEmpty(politicalOutlook)) {
|
sysUserInputDO.setPoliticalOutlook(
|
politicalOutlook.equals("党员") ? 1 : politicalOutlook.equals("团员") ? 2 : 3);
|
} else {
|
sysUserInputDO.setPoliticalOutlook(3);
|
}
|
sysUserInputDO.setResidence(eexcelUserDTO.getResidence());
|
sysUserInputDO.setSituation(eexcelUserDTO.getSituation());
|
sysUserInputDO.setSoldier(eexcelUserDTO.getSoldier().equals("是") ? 1 : 0);
|
sysUserInputDO.setSpecialServiceFamily(eexcelUserDTO.getSpecialServiceFamily().equals("是") ? 1 : 0);
|
|
sysUserInputDOS.add(sysUserInputDO);
|
}
|
});
|
this.saveBatch(sysUserInputDOS);
|
}
|
return R.ok();
|
}
|
|
/**
|
* 社区人员详情包括导入人员
|
*
|
* @param userId
|
* 人员id
|
* @return CommunityUserInfoVO
|
*/
|
@Override
|
public CommunityUserInfoVO detailUserComunity(Long userId) {
|
CommunityUserInfoVO communityUserInfoVO=null;
|
// userId = userId - 100000000l;
|
SysUserInputDO sysUserInputDO = sysUserInputDAO.selectById(userId);
|
if (!org.springframework.util.ObjectUtils.isEmpty(sysUserInputDO)) {
|
communityUserInfoVO = new CommunityUserInfoVO();
|
BeanUtils.copyProperties(sysUserInputDO, communityUserInfoVO);
|
String idCard = sysUserInputDO.getIdCard();
|
if (!org.springframework.util.ObjectUtils.isEmpty(idCard)) {
|
communityUserInfoVO.setAge(IdCard.IdNOToAge(idCard));
|
communityUserInfoVO.setBirthday(IdCard.birthDay(idCard));
|
communityUserInfoVO.setIdCard(idCard);
|
communityUserInfoVO.setSex(IdCard.sex(idCard));
|
}
|
String phone = sysUserInputDO.getPhone();
|
communityUserInfoVO.setPhone(phone);
|
Integer keyPersonnel = sysUserInputDO.getKeyPersonnel();
|
Integer specialServiceFamily = sysUserInputDO.getSpecialServiceFamily();
|
Integer soldier = sysUserInputDO.getSoldier();
|
Integer lowincomeHouseholds = sysUserInputDO.getLowIncomeHouseholds();
|
Integer lowincomePeople = sysUserInputDO.getLowIncomePeople();
|
Integer oldPeople = sysUserInputDO.getOldPeople();
|
Integer disability = sysUserInputDO.getDisability();
|
|
StringBuilder stringBuilder = new StringBuilder();
|
if (keyPersonnel.intValue() == 1) {
|
stringBuilder.append("重点人员,");
|
}
|
if (specialServiceFamily.intValue() == 1) {
|
stringBuilder.append("特服家庭,");
|
}
|
if (soldier.intValue() == 1) {
|
stringBuilder.append("军人,");
|
}
|
if (lowincomeHouseholds.intValue() == 1) {
|
stringBuilder.append("低保户,");
|
}
|
if (lowincomePeople.intValue() == 1) {
|
stringBuilder.append("低收入人员,");
|
}
|
if (oldPeople.intValue() == 1) {
|
stringBuilder.append("高龄老人,");
|
}
|
if (disability.intValue() == 1) {
|
stringBuilder.append("残疾人,");
|
}
|
communityUserInfoVO.setTags(stringBuilder.toString());
|
communityUserInfoVO.setUserId(userId);
|
communityUserInfoVO.setIsVolunteer(0);
|
String doorNumber = sysUserInputDO.getDoorNumber();
|
List<ComMngFamilyInfoVO> comMngFamilyInfoVOS = sysUserInputDAO.selectListFamily(doorNumber, userId);
|
communityUserInfoVO.setComMngFamilyInfoVOS(comMngFamilyInfoVOS);
|
}
|
return communityUserInfoVO;
|
}
|
|
@Override
|
public R pageInputUser(PageInputUserDTO pageInputUserDTO) {
|
Page page = new Page<>();
|
Long pageNum = pageInputUserDTO.getPageNum();
|
Long pageSize = pageInputUserDTO.getPageSize();
|
if (null == pageNum || 0 == pageNum) {
|
pageNum = 1l;
|
}
|
if (null == pageSize || 0 == pageSize) {
|
pageSize = 10l;
|
}
|
page.setSize(pageSize);
|
page.setCurrent(pageNum);
|
IPage<InputUserInfoVO> iPage = sysUserInputDAO.pageInputUser(page, pageInputUserDTO);
|
iPage.getRecords().forEach(record -> {
|
record.setPhone(SensitiveUtil.desensitizedPhoneNumber(record.getPhone()));
|
record.setIdCard(SensitiveUtil.desensitizedIdNumber(record.getIdCard()));
|
if (!StringUtils.isEmpty(record.getTags()) && record.getTags().endsWith(",")) {
|
record.setTags(record.getTags().substring(0, record.getTags().length() - 1));
|
}
|
});
|
return R.ok(iPage);
|
}
|
|
@Override
|
public R putUserTag(InputUserTagsDTO inputUserTagsDTO) {
|
SysUserInputDO userInputDO = new SysUserInputDO();
|
userInputDO.setId(inputUserTagsDTO.getId());
|
userInputDO.setTags(inputUserTagsDTO.getTags());
|
List<SysUserInputDO> all = sysUserInputDAO
|
.selectList(new QueryWrapper<SysUserInputDO>().lambda().eq(SysUserInputDO::getId, userInputDO.getId()));
|
all.forEach(d -> {
|
if (!StringUtils.isEmpty(d.getTags())) {
|
d.setTags(d.getTags() + "," + inputUserTagsDTO.getTags());
|
} else {
|
d.setTags(inputUserTagsDTO.getTags());
|
}
|
sysUserInputDAO.updateById(userInputDO);
|
|
});
|
return R.ok();
|
}
|
|
@Override
|
public R exportInputUser(ExportUserDTO exportUserDTO) {
|
List<EexcelUserDTO> eexcelUserDTOS = sysUserInputDAO.selectExport(exportUserDTO);
|
return R.ok(eexcelUserDTOS);
|
}
|
|
@Override
|
public R inputUserDetail(Long id) {
|
InputUserInfoVO inputUserInfoVO = new InputUserInfoVO();
|
SysUserInputDO sysUserInputDO = sysUserInputDAO.selectById(id);
|
if (!org.springframework.util.ObjectUtils.isEmpty(sysUserInputDO)) {
|
BeanUtils.copyProperties(sysUserInputDO, inputUserInfoVO);
|
String idCard = sysUserInputDO.getIdCard();
|
if (!org.springframework.util.ObjectUtils.isEmpty(idCard)) {
|
inputUserInfoVO.setAge(IdCard.IdNOToAge(idCard));
|
inputUserInfoVO.setBirthday(IdCard.birthDay(idCard));
|
inputUserInfoVO.setIdCard(idCard);
|
inputUserInfoVO.setSex(IdCard.sex(idCard));
|
}
|
Integer keyPersonnel = sysUserInputDO.getKeyPersonnel();
|
Integer specialServiceFamily = sysUserInputDO.getSpecialServiceFamily();
|
Integer soldier = sysUserInputDO.getSoldier();
|
Integer lowincomeHouseholds = sysUserInputDO.getLowIncomeHouseholds();
|
Integer lowincomePeople = sysUserInputDO.getLowIncomePeople();
|
Integer oldPeople = sysUserInputDO.getOldPeople();
|
Integer disability = sysUserInputDO.getDisability();
|
|
StringBuilder stringBuilder = new StringBuilder();
|
if (keyPersonnel.intValue() == 1) {
|
stringBuilder.append("重点人员,");
|
}
|
if (specialServiceFamily.intValue() == 1) {
|
stringBuilder.append("特服家庭,");
|
}
|
if (soldier.intValue() == 1) {
|
stringBuilder.append("军人,");
|
}
|
if (lowincomeHouseholds.intValue() == 1) {
|
stringBuilder.append("低保户,");
|
}
|
if (lowincomePeople.intValue() == 1) {
|
stringBuilder.append("低收入人员,");
|
}
|
if (oldPeople.intValue() == 1) {
|
stringBuilder.append("高龄老人,");
|
}
|
if (disability.intValue() == 1) {
|
stringBuilder.append("残疾人,");
|
}
|
inputUserInfoVO.setTags(stringBuilder.toString());
|
String doorNumber = sysUserInputDO.getDoorNumber();
|
List<ComMngFamilyInfoVO> comMngFamilyInfoVOS = sysUserInputDAO.selectListFamily(doorNumber, id);
|
inputUserInfoVO.setComMngFamilyInfoVOS(comMngFamilyInfoVOS);
|
List<ComMngStructHouseVO> comMngStructHouseVOS =
|
sysUserInputDAO.selectUserHouseList(inputUserInfoVO.getIdCard());
|
inputUserInfoVO.setComMngStructHouseVOS(comMngStructHouseVOS);
|
}
|
return R.ok(inputUserInfoVO);
|
}
|
|
@Override
|
public R specialInputUser(PageInputUserDTO pageInputUserDTO) {
|
Page page = new Page<>();
|
Long pageNum = pageInputUserDTO.getPageNum();
|
Long pageSize = pageInputUserDTO.getPageSize();
|
if (null == pageNum || 0 == pageNum) {
|
pageNum = 1l;
|
}
|
if (null == pageSize || 0 == pageSize) {
|
pageSize = 10l;
|
}
|
page.setSize(pageSize);
|
page.setCurrent(pageNum);
|
IPage<InputUserInfoVO> iPage = sysUserInputDAO.specialInputUser(page, pageInputUserDTO);
|
iPage.getRecords().forEach(record -> {
|
record.setPhone(SensitiveUtil.desensitizedPhoneNumber(record.getPhone()));
|
record.setIdCard(SensitiveUtil.desensitizedIdNumber(record.getIdCard()));
|
});
|
return R.ok(iPage);
|
}
|
|
@Override
|
public R specialInputUserTags(ComMngUserTagDTO comMngUserTagDTO) {
|
Page page = new Page<>();
|
Long pageNum = comMngUserTagDTO.getPageNum();
|
Long pageSize = comMngUserTagDTO.getPageSize();
|
if (null == pageNum || 0 == pageNum) {
|
pageNum = 1l;
|
}
|
if (null == pageSize || 0 == pageSize) {
|
pageSize = 10l;
|
}
|
page.setSize(pageSize);
|
page.setCurrent(pageNum);
|
IPage<ComMngTagVO> iPage = comMngUserTagDAO.pageSpecialInputUserTags(page, comMngUserTagDTO);
|
return R.ok(iPage);
|
}
|
|
@Override
|
public R saveSpecialInputUserTags(ComMngTagVO comMngTagVO) {
|
if (null != comMngTagVO.getId() && comMngTagVO.getId() != 0) {
|
ComMngUserTagDO comMngUserTagDO = comMngUserTagDAO.selectById(comMngTagVO.getId());
|
if (null == comMngUserTagDO) {
|
return R.fail("标签不存在");
|
}
|
if (comMngUserTagDO.getSysFlag() == 1) {
|
return R.fail("系统预置标签不可修改");
|
}
|
ComMngUserTagDO exist = comMngUserTagDAO.selectOne(
|
new QueryWrapper<ComMngUserTagDO>().lambda().eq(ComMngUserTagDO::getTagName, comMngTagVO.getTagName()));
|
if (null != exist && !exist.getId().equals(comMngTagVO.getId())) {
|
return R.fail("标签重复");
|
}
|
comMngUserTagDO.setTagName(comMngTagVO.getTagName());
|
comMngUserTagDAO.updateById(comMngUserTagDO);
|
} else {
|
ComMngUserTagDO comMngUserTagDO = comMngUserTagDAO.getSpecialInputUserTagsByVO(comMngTagVO);
|
if (comMngUserTagDO != null) {
|
return R.fail("标签重复");
|
}
|
ComMngUserTagDO comMngUserTagDO1 = new ComMngUserTagDO();
|
comMngUserTagDO1.setTagName(comMngTagVO.getTagName());
|
// comMngUserTagDO1.setCommunityId(comMngTagVO.getCommunityId());
|
comMngUserTagDO1.setSysFlag(0);
|
comMngUserTagDO1.setCreateAt(new Date());
|
comMngUserTagDAO.insert(comMngUserTagDO1);
|
}
|
return R.ok();
|
}
|
|
@Override
|
public R deleteSpecialInputUserTags(Long id) {
|
ComMngUserTagDO comMngUserTagDO = comMngUserTagDAO.selectById(id);
|
if (null == comMngUserTagDO) {
|
return R.fail("标签不存在");
|
}
|
if (comMngUserTagDO.getSysFlag() == 1) {
|
return R.fail("系统预置标签不可删除");
|
}
|
int delete = comMngUserTagDAO.deleteById(id);
|
if (delete > 0) {
|
return R.ok();
|
}
|
return R.fail("删除失败");
|
}
|
|
@Override
|
public R deleteSpecialInputUser(Long id) {
|
SysUserInputDO sysUserInputDO = sysUserInputDAO.selectById(id);
|
if (null == sysUserInputDO) {
|
return R.fail("用户不存在");
|
}
|
List<SysUserInputDO> sysUserInputDOS = sysUserInputDAO.selectList(
|
new QueryWrapper<SysUserInputDO>().lambda().eq(SysUserInputDO::getIdCard, sysUserInputDO.getIdCard()));
|
sysUserInputDOS.forEach(sysUserInput -> {
|
sysUserInput.setTags(null);
|
sysUserInput.setKeyPersonnel(0);
|
sysUserInput.setSpecialServiceFamily(0);
|
sysUserInput.setSoldier(0);
|
sysUserInput.setLowIncomeHouseholds(0);
|
sysUserInput.setLowIncomePeople(0);
|
sysUserInput.setOldPeople(0);
|
sysUserInput.setDisability(0);
|
});
|
boolean update = this.updateBatchById(sysUserInputDOS);
|
if (update) {
|
return R.ok();
|
}
|
return R.fail();
|
}
|
|
@Override
|
public R specialUserExport(ExportSpecialUserDTO exportSpecialUserDTO) {
|
List<EexcelUserDTO> eexcelUserDTOS = sysUserInputDAO.specialUserExport(exportSpecialUserDTO);
|
return R.ok(eexcelUserDTOS);
|
}
|
}
|
