From b34230301d2f6618e3f2af344b47ec3737d7007c Mon Sep 17 00:00:00 2001
From: luofl <1442745593@qq.com>
Date: 星期日, 16 三月 2025 14:30:49 +0800
Subject: [PATCH] Merge remote-tracking branch 'origin/dev-2.0' into dev-2.0
---
springcloud_k8s_panzhihuazhihuishequ/service_sangeshenbian/src/main/java/com/panzhihua/sangeshenbian/service/impl/PartyMemberServiceImpl.java | 182 ++++++++++++++++++++++++++++++++++++++++++++-
1 files changed, 177 insertions(+), 5 deletions(-)
diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_sangeshenbian/src/main/java/com/panzhihua/sangeshenbian/service/impl/PartyMemberServiceImpl.java b/springcloud_k8s_panzhihuazhihuishequ/service_sangeshenbian/src/main/java/com/panzhihua/sangeshenbian/service/impl/PartyMemberServiceImpl.java
index 1ab5bd8..63a99dd 100644
--- a/springcloud_k8s_panzhihuazhihuishequ/service_sangeshenbian/src/main/java/com/panzhihua/sangeshenbian/service/impl/PartyMemberServiceImpl.java
+++ b/springcloud_k8s_panzhihuazhihuishequ/service_sangeshenbian/src/main/java/com/panzhihua/sangeshenbian/service/impl/PartyMemberServiceImpl.java
@@ -2,20 +2,33 @@
import cn.hutool.core.bean.BeanUtil;
import cn.hutool.core.date.DateUtil;
+import cn.hutool.core.collection.CollUtil;
+import cn.hutool.core.util.StrUtil;
+import cn.idev.excel.EasyExcel;
+import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
import cn.idev.excel.FastExcel;
import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.panzhihua.common.exceptions.ServiceException;
import com.panzhihua.common.model.vos.LoginUserInfoVO;
+import com.panzhihua.common.exceptions.ServiceException;
import com.panzhihua.common.model.vos.sangeshenbian.SystemUserVo;
import com.panzhihua.sangeshenbian.dao.PartyMemberMapper;
import com.panzhihua.sangeshenbian.enums.AuditStatusEnum;
import com.panzhihua.sangeshenbian.enums.ReportTypeEnum;
+import com.panzhihua.sangeshenbian.enums.AuditStatusEnum;
+import com.panzhihua.sangeshenbian.model.entity.BcRegion;
+import com.panzhihua.sangeshenbian.model.entity.ComAct;
+import com.panzhihua.sangeshenbian.model.entity.ComStreet;
import com.panzhihua.sangeshenbian.model.entity.PartyMember;
import com.panzhihua.sangeshenbian.model.entity.SystemUser;
import com.panzhihua.sangeshenbian.model.excel.PartyMemberExcel;
+import com.panzhihua.sangeshenbian.warpper.PartyMemberImportFailedVO;
import com.panzhihua.sangeshenbian.model.excel.PartyMemberTemplate;
+import com.panzhihua.sangeshenbian.service.IBcRegionService;
+import com.panzhihua.sangeshenbian.service.IComActService;
+import com.panzhihua.sangeshenbian.service.IComStreetService;
import com.panzhihua.sangeshenbian.service.IPartyMemberService;
import com.panzhihua.sangeshenbian.service.ISystemUserService;
import com.panzhihua.sangeshenbian.warpper.PartyMemberApplicationRequest;
@@ -26,10 +39,13 @@
import org.springframework.context.annotation.Lazy;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;
+import org.springframework.transaction.annotation.Transactional;
+import org.springframework.web.multipart.MultipartFile;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
import java.net.URLEncoder;
+import java.util.ArrayList;
import java.util.Collections;
import java.util.List;
import java.util.Objects;
@@ -47,6 +63,9 @@
public class PartyMemberServiceImpl extends ServiceImpl<PartyMemberMapper, PartyMember> implements IPartyMemberService {
private final HttpServletResponse response;
private final ISystemUserService systemUserService;
+ private final IBcRegionService bcRegionService;
+ private final IComStreetService comStreetService;
+ private final IComActService comActService;
/**
* 党员分页查询列表
*
@@ -71,6 +90,8 @@
if (Objects.isNull(dto.getId())) {
//添加
partyMember.setCreateBy(Long.parseLong(loginUserInfo.getId().toString()));
+ partyMember.setAuditStatus(AuditStatusEnum.APPROVED.getCode());
+ partyMember.setSource(1);
save(partyMember);
} else {
partyMember.setUpdateBy(Long.parseLong(loginUserInfo.getId().toString()));
@@ -96,7 +117,7 @@
response.setCharacterEncoding("utf-8");
String fileName = URLEncoder.encode("党员导入模板", "UTF-8").replaceAll("\\+", "%20");
response.setHeader("Content-disposition", "attachment;filename*=utf-8''" + fileName + ".xlsx");
- FastExcel.write(response.getOutputStream(), PartyMemberTemplate.class)
+ EasyExcel.write(response.getOutputStream(), PartyMemberTemplate.class)
.sheet("党员导入模板")
.doWrite(Collections.emptyList());
}
@@ -114,18 +135,158 @@
response.setCharacterEncoding("utf-8");
String fileName = URLEncoder.encode("党员数据", "UTF-8").replaceAll("\\+", "%20");
response.setHeader("Content-disposition", "attachment;filename*=utf-8''" + fileName + ".xlsx");
- FastExcel.write(response.getOutputStream(), PartyMemberExcel.class)
+ EasyExcel.write(response.getOutputStream(), PartyMemberExcel.class)
.sheet("党员数据")
.doWrite(partyMemberExcels);
}
/**
- *
+ * @param file
* @param loginUserInfo
*/
@Override
- public void importExcel(SystemUserVo loginUserInfo) {
+ @Transactional(rollbackFor = Exception.class)
+ public List<PartyMemberImportFailedVO> importExcel(MultipartFile file, SystemUserVo loginUserInfo) throws IOException {
+ // 使用 FastExcel 同步读取 Excel 数据为对象列表
+ List<PartyMemberTemplate> list = EasyExcel.read(file.getInputStream()).head(PartyMemberTemplate.class).headRowNumber(2).sheet().doReadSync();
+ if (CollUtil.isEmpty(list)) {
+ throw new ServiceException("导入数据为空");
+ }
+ // 存储验证失败的记录
+ List<PartyMemberImportFailedVO> failedList = new ArrayList<>();
+ // 存储验证成功的记录
+ List<PartyMember> validPartyMembers = new ArrayList<>();
+
+ // 手机号正则表达式
+ String phoneRegex = "^1[3-9]\\d{9}$";
+ // 身份证号正则表达式
+ String idCardRegex = "(^\\d{15}$)|(^\\d{18}$)|(^\\d{17}(\\d|X|x)$)";
+
+ // 批量验证数据
+ for (PartyMemberTemplate template : list) {
+ PartyMemberImportFailedVO failedVO = new PartyMemberImportFailedVO();
+ boolean isValid = true;
+ StringBuilder errorMsg = new StringBuilder();
+
+ // 复制数据到失败记录对象
+ BeanUtil.copyProperties(template, failedVO);
+
+ // 1. 验证手机号
+ if (StrUtil.isBlank(template.getPhone()) || !template.getPhone().matches(phoneRegex)) {
+ isValid = false;
+ errorMsg.append("手机号格式不正确; ");
+ }
+
+ // 2. 验证身份证号
+ if (StrUtil.isBlank(template.getIdNumber()) || !template.getIdNumber().matches(idCardRegex)) {
+ isValid = false;
+ errorMsg.append("身份证号格式不正确; ");
+ }
+
+ // 3. 验证账号是否已存在
+ if (StrUtil.isNotBlank(template.getPhone())) {
+ LambdaQueryWrapper<PartyMember> queryWrapper = new LambdaQueryWrapper<>();
+ queryWrapper.eq(PartyMember::getPhone, template.getPhone());
+ long count = count(queryWrapper);
+ if (count > 0) {
+ isValid = false;
+ errorMsg.append("账号已存在");
+ }
+ }
+
+ // 4. 验证所在社区
+ String districtName = null;
+ String streetName = null;
+ String communityName = null;
+ String districtCode = "";
+ String streetId = "";
+ Long communityId = null;
+
+ if (StrUtil.isNotBlank(template.getCommunity())) {
+ String[] addressParts = template.getCommunity().split("-");
+ if (addressParts.length != 3) {
+ isValid = false;
+ errorMsg.append("社区格式不正确，应为'区县-街道-社区'; ");
+ } else {
+ districtName = addressParts[0];
+ streetName = addressParts[1];
+ communityName = addressParts[2];
+
+ // 验证区县、街道、社区信息
+
+ // 验证区县是否存在
+ BcRegion district = bcRegionService.getDistrictByName(districtName);
+
+ if (Objects.isNull(district)) {
+ isValid = false;
+ errorMsg.append("区县不存在; ");
+ } else {
+ // 验证街道是否存在且属于该区县
+ ComStreet comStreet = comStreetService.getStreetByNameAndDistrict(streetName, district.getRegionCode());
+ districtCode = district.getRegionCode();
+ if (Objects.isNull(comStreet)) {
+ isValid = false;
+ errorMsg.append("街道不存在或不属于所选区县; ");
+ } else {
+ // 验证社区是否存在且属于该街道
+ // 实际代码应该是调用相应的Service查询社区信息
+ ComAct comAct = comActService.getCommunityByNameAndStreet(communityName, comStreet.getStreetId());
+ streetId = comStreet.getStreetId();
+ communityId = comAct.getCommunityId();
+ if (Objects.isNull(comAct)) {
+ isValid = false;
+ errorMsg.append("社区不存在或不属于所选街道; ");
+ }
+ }
+ }
+ }
+ } else {
+ isValid = false;
+ errorMsg.append("社区信息不能为空; ");
+ }
+
+ // 如果验证失败，添加到失败列表，否则添加到成功列表
+ if (!isValid) {
+ failedVO.setFailReason(errorMsg.toString());
+ failedList.add(failedVO);
+ } else {
+ PartyMember partyMember = new PartyMember();
+ BeanUtil.copyProperties(template, partyMember);
+
+ // 设置创建人和更新人
+ partyMember.setCreateBy(Long.parseLong(loginUserInfo.getId().toString()));
+ partyMember.setUpdateBy(Long.parseLong(loginUserInfo.getId().toString()));
+ //导入党员默认审核通过
+ partyMember.setAuditStatus(AuditStatusEnum.APPROVED.getCode());
+ partyMember.setSource(1);//管理后台录入
+ //默认头像 TODO 默认头像
+ partyMember.setAvatar("");
+ // 根据身份证号设置性别
+ if (StrUtil.isNotBlank(template.getIdNumber())) {
+ partyMember.setGender(getGender(template.getIdNumber()));
+ }
+
+ // 然后设置到partyMember对象中
+ partyMember.setDistricts(districtName);
+ partyMember.setDistrictsCode(districtCode);
+ partyMember.setStreet(streetName);
+ partyMember.setStreetId(streetId);
+ partyMember.setCommunity(communityName);
+ partyMember.setCommunityId(communityId);
+
+ validPartyMembers.add(partyMember);
+ }
+ }
+
+ // 处理验证成功的数据
+ if (!validPartyMembers.isEmpty()) {
+ // 批量保存
+ saveBatch(validPartyMembers);
+ }
+
+ // 返回验证失败的数据
+ return failedList;
}
@Override
@@ -199,4 +360,15 @@
return (genderDigit % 2 == 0) ? 0 : 1;
}
-}
+
+ /**
+ * 根据电话号码查询有效的党员数据
+ * @param phone
+ * @return
+ */
+ @Override
+ public PartyMember getPartyMemberByPhone(String phone) {
+ PartyMember one = this.getOne(new LambdaQueryWrapper<PartyMember>().eq(PartyMember::getPhone, phone)
+ .eq(PartyMember::getAuditStatus, 1).eq(PartyMember::getFreezeStatus, 0).eq(PartyMember::getDelFlag, 0));
+ return one;
+ }}
--
Gitblit v1.7.1