From 261f390eaa70cbb103b85e872e463c65d16cdeb1 Mon Sep 17 00:00:00 2001
From: luofl <1442745593@qq.com>
Date: 星期一, 17 三月 2025 11:43:44 +0800
Subject: [PATCH] 党员认证、党员上级角色切换
---
springcloud_k8s_panzhihuazhihuishequ/service_sangeshenbian/src/main/java/com/panzhihua/sangeshenbian/service/impl/ComplaintServiceImpl.java | 756 +++++++++++++++++++++++++++++++++++++--------------------
1 files changed, 485 insertions(+), 271 deletions(-)
diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_sangeshenbian/src/main/java/com/panzhihua/sangeshenbian/service/impl/ComplaintServiceImpl.java b/springcloud_k8s_panzhihuazhihuishequ/service_sangeshenbian/src/main/java/com/panzhihua/sangeshenbian/service/impl/ComplaintServiceImpl.java
index 9eeb578..36131d9 100644
--- a/springcloud_k8s_panzhihuazhihuishequ/service_sangeshenbian/src/main/java/com/panzhihua/sangeshenbian/service/impl/ComplaintServiceImpl.java
+++ b/springcloud_k8s_panzhihuazhihuishequ/service_sangeshenbian/src/main/java/com/panzhihua/sangeshenbian/service/impl/ComplaintServiceImpl.java
@@ -2,11 +2,15 @@
import cn.hutool.core.bean.BeanUtil;
import cn.hutool.core.collection.CollUtil;
-import com.alibaba.fastjson.JSON;
+import cn.idev.excel.EasyExcel;
import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
import com.baomidou.mybatisplus.core.conditions.update.LambdaUpdateWrapper;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
+import com.deepoove.poi.XWPFTemplate;
import com.panzhihua.common.model.vos.LoginUserInfoVO;
+import com.panzhihua.common.model.vos.sangeshenbian.SystemUserVo;
+import com.panzhihua.common.redis.RedisUtils;
+import com.panzhihua.sangeshenbian.enums.RateEnum;
import com.panzhihua.sangeshenbian.model.dto.ComplaintCompletionDTO;
import com.panzhihua.sangeshenbian.model.dto.ComplaintProcessDTO;
import com.panzhihua.sangeshenbian.model.entity.Complaint;
@@ -19,6 +23,8 @@
import com.panzhihua.sangeshenbian.model.entity.ComplaintFlow;
import com.panzhihua.sangeshenbian.model.entity.ComplaintProgress;
import com.panzhihua.sangeshenbian.model.entity.SystemUser;
+import com.panzhihua.sangeshenbian.model.excel.ComplaintExcel;
+import com.panzhihua.sangeshenbian.model.excel.PartyMemberExcel;
import com.panzhihua.sangeshenbian.model.query.BasePage;
import com.panzhihua.sangeshenbian.model.query.ComplaintQuery;
import com.panzhihua.sangeshenbian.model.vo.ComplaintTodoVO;
@@ -30,17 +36,23 @@
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.panzhihua.sangeshenbian.model.vo.ComplaintVO;
import com.panzhihua.sangeshenbian.service.ISystemUserService;
-import io.jsonwebtoken.lang.Collections;
+import com.panzhihua.sangeshenbian.utils.FileUtil;
+import com.panzhihua.sangeshenbian.warpper.MgtComplaintQuery;
import lombok.RequiredArgsConstructor;
import lombok.extern.slf4j.Slf4j;
import org.springframework.context.annotation.Lazy;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;
+import javax.servlet.http.HttpServletResponse;
+import java.io.IOException;
+import java.net.URLEncoder;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Date;
+import java.util.HashMap;
import java.util.List;
+import java.util.Map;
import java.util.Objects;
import java.util.Optional;
@@ -67,6 +79,10 @@
private final IComStreetService comStreetService;
private final IComActService comActService;
private final IWorkOrderItemConfigService workOrderItemConfigService;
+ private final IComplaintCommentService complaintCommentService;
+ private final HttpServletResponse response;
+ private final IPartyMemberService partyMemberService;
+ private final RedisUtils redisUtils;
@Override
public void saveComplaint(Complaint complaint, LoginUserInfoVO loginUserInfoVO) {
@@ -92,38 +108,66 @@
// 设置流水号
complaint.setSerialNumber(serialNumber);
- Optional<SystemUser> systemUserOpt = systemUserService.getSystemUserByPhone(loginUserInfoVO.getPhone());
+ Optional<SystemUser> systemUserOpt = systemUserService.getSystemUserAdminByPhone(loginUserInfoVO.getPhone());
Integer accountLevel = 5;
- Long superiorId = null;
- if (systemUserOpt.isPresent()) {
+ //获取当前身份，1=党员，2=管理员
+ Integer identity = (Integer) redisUtils.get("identity:" + loginUserInfoVO.getPhone());
+ if (systemUserOpt.isPresent() && identity == 2) {
SystemUser systemUser = systemUserOpt.get();
accountLevel = systemUser.getAccountLevel();
switch (accountLevel) {
case 1:
//市级
- superiorId = 510400L;
+ complaint.setCityCode(510400);
+ complaint.setReportUserName(systemUser.getName());
+ complaint.setReportUserPhone(systemUser.getPhone());
break;
case 2:
//区县级
- superiorId = Long.parseLong(systemUser.getDistrictsCode());
+ complaint.setCityCode(510400);
+ complaint.setDistrictsCode(Integer.valueOf(systemUser.getDistrictsCode()));
+ complaint.setReportUserName(systemUser.getName());
+ complaint.setReportUserPhone(systemUser.getPhone());
break;
case 3:
//街道
- superiorId = Long.parseLong(systemUser.getStreetId());
+ complaint.setCityCode(510400);
+ complaint.setDistrictsCode(Integer.valueOf(systemUser.getDistrictsCode()));
+ complaint.setStreetId(Long.valueOf(systemUser.getStreetId()));
+ complaint.setReportUserName(systemUser.getName());
+ complaint.setReportUserPhone(systemUser.getPhone());
break;
case 4:
//社区
- superiorId = systemUser.getCommunityId();
+ complaint.setCityCode(510400);
+ complaint.setDistrictsCode(Integer.valueOf(systemUser.getDistrictsCode()));
+ complaint.setStreetId(Long.valueOf(systemUser.getStreetId()));
+ complaint.setCommunityId(systemUser.getCommunityId());
+ complaint.setReportUserName(systemUser.getName());
+ complaint.setReportUserPhone(systemUser.getPhone());
break;
case 5:
- //社区
- superiorId = loginUserInfoVO.getUserId();
+ //党员
+ complaint.setCityCode(510400);
+ complaint.setDistrictsCode(Integer.valueOf(systemUser.getDistrictsCode()));
+ complaint.setStreetId(Long.valueOf(systemUser.getStreetId()));
+ complaint.setCommunityId(systemUser.getCommunityId());
+ PartyMember partyMember = partyMemberService.getPartyMemberByPhone(loginUserInfoVO.getPhone());
+ complaint.setPartyMemberId(partyMember.getId());
+ complaint.setReportUserName(partyMember.getName());
+ complaint.setReportUserPhone(partyMember.getPhone());
break;
}
- complaint.setSuperiorType(accountLevel);
- complaint.setSuperiorId(superiorId);
- }else{
- superiorId = loginUserInfoVO.getUserId();
+ } else{
+ PartyMember partyMember = partyMemberService.getPartyMemberByPhone(loginUserInfoVO.getPhone());
+ //党员
+ complaint.setCityCode(510400);
+ complaint.setDistrictsCode(Integer.valueOf(partyMember.getDistrictsCode()));
+ complaint.setStreetId(Long.valueOf(partyMember.getStreetId()));
+ complaint.setCommunityId(partyMember.getCommunityId());
+ complaint.setPartyMemberId(partyMember.getId());
+ complaint.setReportUserName(partyMember.getName());
+ complaint.setReportUserPhone(partyMember.getPhone());
}
complaint.setReportType(accountLevel);
// 设置其他字段
@@ -140,21 +184,6 @@
complaint.setClosingTime(new Date(System.currentTimeMillis() + config.getDemandProcessingTime() * 24 * 60 * 60 * 1000));
// 保存诉求记录
save(complaint);
- int count = complaintAuditRecordService.count(new LambdaQueryWrapper<ComplaintAuditRecord>().eq(ComplaintAuditRecord::getComplaintId, complaint.getId()));
- //保存记录
- ComplaintAuditRecord complaintAuditRecord = new ComplaintAuditRecord();
- complaintAuditRecord.setComplaintId(complaint.getId());
- complaintAuditRecord.setLatestFlag(true);
- complaintAuditRecord.setAuditType(0);
- complaintAuditRecord.setAuditStatus(-1);
- complaintAuditRecord.setCreateBy(loginUserInfoVO.getUserId());
- complaintAuditRecord.setCreateTime(new Date(System.currentTimeMillis()));
- complaintAuditRecord.setUpdateBy(loginUserInfoVO.getUserId());
- complaintAuditRecord.setUpdateTime(new Date(System.currentTimeMillis()));
- complaintAuditRecord.setReportType(accountLevel);
- complaintAuditRecord.setSuperiorId(superiorId);
- complaintAuditRecord.setSort(count + 1);
- complaintAuditRecordService.save(complaintAuditRecord);
}
/**
@@ -166,12 +195,217 @@
public Page<ComplaintVO> complaintList(ComplaintQuery query, LoginUserInfoVO loginUserInfoVO) {
Page<ComplaintVO> page = new Page<>(query.getPageNum(), query.getPageSize());
//判断当前登录用户级别，查询对应工单
- Optional<SystemUser> systemUserByPhone = systemUserService.getSystemUserByPhone(loginUserInfoVO.getPhone());
- String targetId = "";
- int isSuperior = 0;
+ Optional<SystemUser> systemUserByPhone = systemUserService.getSystemUserAdminByPhone(loginUserInfoVO.getPhone());
+ Long targetId = null;
Integer accountLevel = 5;
+ //获取当前身份，1=党员，2=管理员
+ Integer identity = (Integer) redisUtils.get("identity:" + loginUserInfoVO.getPhone());
//上级
- if (systemUserByPhone.isPresent()) {
+ if (systemUserByPhone.isPresent() && identity == 2) {
+ SystemUser systemUser = systemUserByPhone.get();
+ accountLevel = systemUser.getAccountLevel();
+ switch (accountLevel) {
+ case 1:
+ //市级
+ targetId = 510400L;
+ break;
+ case 2:
+ //区县级
+ targetId = Long.valueOf(systemUser.getDistrictsCode());
+ break;
+ case 3:
+ //街道
+ targetId = Long.valueOf(systemUser.getStreetId());
+ break;
+ case 4:
+ //社区
+ targetId = systemUser.getCommunityId();
+ break;
+ case 5:
+ //党员
+ PartyMember partyMember = partyMemberService.getPartyMemberByPhone(loginUserInfoVO.getPhone());
+ targetId = partyMember.getId();
+ break;
+ }
+ } else {
+ //党员
+ PartyMember partyMember = partyMemberService.getPartyMemberByPhone(loginUserInfoVO.getPhone());
+ targetId = partyMember.getId();
+ }
+ //查询对应诉求
+ //page = baseMapper.selectComplaintPage(page, query, targetId, isSuperior);
+ page = baseMapper.selectComplaintPage1(page, query, accountLevel, targetId);
+ page.getRecords().forEach(s->{
+ buttonPermission(s, systemUserByPhone);
+ });
+ return page;
+ }
+
+
+ /**
+ * 列表按钮权限
+ * @param vo
+ */
+ public void buttonPermission(ComplaintVO vo, Optional<SystemUser> systemUserByPhone){
+ vo.setListControlsButtonStatus(1);
+ vo.setEvaluateButtonStatus(1);
+ ComplaintAuditRecord one = complaintAuditRecordService.getOne(new LambdaQueryWrapper<ComplaintAuditRecord>().eq(ComplaintAuditRecord::getComplaintId, vo.getId())
+ .ne(ComplaintAuditRecord::getAuditType, 1).orderByDesc(ComplaintAuditRecord::getSort).last(" limit 0, 1"));
+ //没有审核数据，且正在办理，则按钮权限是添加人员的
+ if(null == one && (vo.getStatus() == 0 || vo.getStatus() == 1 || vo.getStatus() == 2)){
+ if(systemUserByPhone.isPresent()){
+ SystemUser systemUser = systemUserByPhone.get();
+ Integer accountLevel = systemUser.getAccountLevel();
+ Integer isAdmin = systemUser.getIsAdmin();
+ //非党员用户，必须是管理员有权限
+ if(accountLevel.compareTo(vo.getReportType()) == 0 && ((accountLevel != 5 && 1 == isAdmin) || accountLevel == 5)){
+ vo.setListControlsButtonStatus(0);
+ }
+ }else{
+ if(vo.getReportType() == 5){
+ vo.setListControlsButtonStatus(0);
+ }
+ }
+ }
+ //有审核数据，且正在办理
+ if(null != one && (vo.getStatus() == 0 || vo.getStatus() == 1 || vo.getStatus() == 2)){
+ //区分是上报数据还是下派数据
+ if(one.getAuditType() == 2){
+ //判断当前审核状态
+ if(one.getAuditStatus() == 1){
+ //审核状态为通过，则权限给到上报审核的这一层
+ if(systemUserByPhone.isPresent()){
+ SystemUser systemUser = systemUserByPhone.get();
+ Integer accountLevel = systemUser.getAccountLevel();
+ Integer isAdmin = systemUser.getIsAdmin();
+ //非党员用户，必须是管理员有权限
+ if(accountLevel.compareTo(one.getReportType()) == 0 && accountLevel != 5 && 1 == isAdmin){
+ vo.setListControlsButtonStatus(0);
+ }
+ }
+ }else{
+ //没有审核通过，则需要查询上一条审核通过的数据，如果没有则给到添加诉求的人
+ ComplaintAuditRecord one1 = complaintAuditRecordService.getOne(new LambdaQueryWrapper<ComplaintAuditRecord>().eq(ComplaintAuditRecord::getComplaintId, vo.getId())
+ .eq(ComplaintAuditRecord::getAuditType, 2).eq(ComplaintAuditRecord::getAuditStatus, 1).orderByDesc(ComplaintAuditRecord::getSort).last(" limit 0, 1"));
+ if(null != one1){
+ if(systemUserByPhone.isPresent()){
+ SystemUser systemUser = systemUserByPhone.get();
+ Integer accountLevel = systemUser.getAccountLevel();
+ Integer isAdmin = systemUser.getIsAdmin();
+ //非党员用户，必须是管理员有权限
+ if(accountLevel.compareTo(one1.getReportType()) == 0 && accountLevel != 5 && 1 == isAdmin){
+ vo.setListControlsButtonStatus(0);
+ }
+ }
+ }else{
+ //没有上一层审核通过的数据，则权限给到添加人
+ if(systemUserByPhone.isPresent()){
+ SystemUser systemUser = systemUserByPhone.get();
+ Integer accountLevel = systemUser.getAccountLevel();
+ Integer isAdmin = systemUser.getIsAdmin();
+ //非党员用户，必须是管理员有权限
+ if(accountLevel.compareTo(vo.getReportType()) == 0 && ((accountLevel != 5 && 1 == isAdmin) || accountLevel == 5)){
+ vo.setListControlsButtonStatus(0);
+ }
+ }else{
+ if(vo.getReportType() == 5){
+ vo.setListControlsButtonStatus(0);
+ }
+ }
+ }
+ }
+ }
+
+ //下派数据
+ if(one.getAuditType() == 3){
+ //判断当前审核状态
+ if(one.getAuditStatus() == 1){
+ //审核状态为通过，则权限给到下报审核的这一层
+ if(systemUserByPhone.isPresent()){
+ SystemUser systemUser = systemUserByPhone.get();
+ Integer accountLevel = systemUser.getAccountLevel();
+ Integer isAdmin = systemUser.getIsAdmin();
+ //非党员用户，必须是管理员有权限
+ if(accountLevel.compareTo(one.getReportType()) == 0 && ((accountLevel != 5 && 1 == isAdmin) || accountLevel == 5)){
+ vo.setListControlsButtonStatus(0);
+ }
+ }else{
+ if(vo.getReportType() == 5 && one.getReportType() == 5){
+ vo.setListControlsButtonStatus(0);
+ }
+ }
+ }else{
+ //没有审核通过，则需要查询上一条审核通过的数据，如果没有则给到添加诉求的人
+ ComplaintAuditRecord one1 = complaintAuditRecordService.getOne(new LambdaQueryWrapper<ComplaintAuditRecord>().eq(ComplaintAuditRecord::getComplaintId, vo.getId())
+ .eq(ComplaintAuditRecord::getAuditType, 3).eq(ComplaintAuditRecord::getAuditStatus, 1).orderByDesc(ComplaintAuditRecord::getSort).last(" limit 0, 1"));
+ if(null != one1){
+ if(systemUserByPhone.isPresent()){
+ SystemUser systemUser = systemUserByPhone.get();
+ Integer accountLevel = systemUser.getAccountLevel();
+ Integer isAdmin = systemUser.getIsAdmin();
+ //非党员用户，必须是管理员有权限
+ if(accountLevel.compareTo(one1.getReportType()) == 0 && ((accountLevel != 5 && 1 == isAdmin) || accountLevel == 5)){
+ vo.setListControlsButtonStatus(0);
+ }
+ }else{
+ if(vo.getReportType() == 5 && one1.getReportType() == 5){
+ vo.setListControlsButtonStatus(0);
+ }
+ }
+ }else{
+ //没有上一层审核通过的数据，则权限给到添加人
+ if(systemUserByPhone.isPresent()){
+ SystemUser systemUser = systemUserByPhone.get();
+ Integer accountLevel = systemUser.getAccountLevel();
+ Integer isAdmin = systemUser.getIsAdmin();
+ //非党员用户，必须是管理员有权限
+ if(accountLevel.compareTo(vo.getReportType()) == 0 && ((accountLevel != 5 && 1 == isAdmin) || accountLevel == 5)){
+ vo.setListControlsButtonStatus(0);
+ }
+ }else{
+ if(vo.getReportType() == 5){
+ vo.setListControlsButtonStatus(0);
+ }
+ }
+ }
+ }
+ }
+ }
+
+ //状态为已办结，判断评价按钮
+ int count = complaintCommentService.count(new LambdaQueryWrapper<ComplaintComment>().eq(ComplaintComment::getComplaintId, vo.getId()).eq(ComplaintComment::getDelFlag, 0));
+ if(vo.getStatus() == 3 && 0 == count){
+ if(systemUserByPhone.isPresent()){
+ SystemUser systemUser = systemUserByPhone.get();
+ Integer accountLevel = systemUser.getAccountLevel();
+ Integer isAdmin = systemUser.getIsAdmin();
+ if(accountLevel.compareTo(vo.getReportType()) == 0 && ((accountLevel != 5 && 1 == isAdmin) || accountLevel == 5)){
+ vo.setEvaluateButtonStatus(0);
+ }
+ }else{
+ if(vo.getReportType() == 5){
+ vo.setEvaluateButtonStatus(0);
+ }
+ }
+ }
+ }
+
+
+ /**
+ * 工单详情
+ *
+ * @param id
+ * @return
+ */
+ @Override
+ public ComplaintVO detail(Long id, LoginUserInfoVO loginUserInfoVO) {
+ Optional<SystemUser> systemUserByPhone = systemUserService.getSystemUserAdminByPhone(loginUserInfoVO.getPhone());
+ String targetId = "";
+ Integer accountLevel = 5;
+ //获取当前身份，1=党员，2=管理员
+ Integer identity = (Integer) redisUtils.get("identity:" + loginUserInfoVO.getPhone());
+ //上级
+ if (systemUserByPhone.isPresent() && identity == 2) {
SystemUser systemUser = systemUserByPhone.get();
accountLevel = systemUser.getAccountLevel();
switch (accountLevel) {
@@ -193,66 +427,16 @@
break;
case 5:
//党员
- targetId = loginUserInfoVO.getUserId().toString();
+ PartyMember partyMember = partyMemberService.getPartyMemberByPhone(loginUserInfoVO.getPhone());
+ targetId = partyMember.getId().toString();
break;
}
- isSuperior = 1;
} else {
//党员
- targetId = loginUserInfoVO.getUserId().toString();
+ PartyMember partyMember = partyMemberService.getPartyMemberByPhone(loginUserInfoVO.getPhone());
+ targetId = partyMember.getId().toString();
}
- //查询对应诉求
- //page = baseMapper.selectComplaintPage(page, query, targetId, isSuperior);
- page = baseMapper.selectComplaintPage1(page, query, accountLevel, targetId);
- return page;
- }
-
- /**
- * 工单详情
- *
- * @param id
- * @return
- */
- @Override
- public ComplaintVO detail(Long id, LoginUserInfoVO loginUserInfoVO) {
- Optional<SystemUser> systemUserByPhone = systemUserService.getSystemUserByPhone(loginUserInfoVO.getPhone());
- String targetId = "";
- int isSuperior = 0;
- Integer accountLevel = 5;
- //上级
- if (systemUserByPhone.isPresent()) {
- SystemUser systemUser = systemUserByPhone.get();
- accountLevel = systemUser.getAccountLevel();
- switch (accountLevel) {
- case 1:
- //市级
- targetId = "510400";
- break;
- case 2:
- //区县级
- targetId = systemUser.getDistrictsCode();
- break;
- case 3:
- //街道
- targetId = systemUser.getStreetId().toString();
- break;
- case 4:
- //社区
- targetId = systemUser.getCommunityId().toString();
- break;
- case 5:
- //社区
- targetId = loginUserInfoVO.getUserId().toString();
- break;
- }
- isSuperior = 1;
- } else {
- //党员
- targetId = loginUserInfoVO.getUserId().toString();
- }
-
-
- ComplaintVO detail = baseMapper.getDetail(id,targetId, isSuperior);
+ ComplaintVO detail = baseMapper.getDetail(id);
if (detail.getStatus().equals(0)) {
List<ComplaintFlow> list = complaintFlowService.lambdaQuery().eq(ComplaintFlow::getComplaintId, id).orderByAsc(ComplaintFlow::getCreateTime).list();
detail.setComplaintFlows(list);
@@ -262,14 +446,30 @@
.orderByAsc(ComplaintProgress::getCreateTime).list();
detail.setComplaintProgresses(list);
detail.setAuditButtonStatus(1);
- Long superiorId = detail.getSuperiorId();
- Integer superiorType = detail.getSuperiorType();
+ detail.setEvaluateButtonStatus(1);
if((detail.getStatus() == 5 || detail.getStatus() == 7) && systemUserByPhone.isPresent()){
- if(superiorType.equals(accountLevel) && superiorId.toString().equals(targetId)){
+ ComplaintAuditRecord one = complaintAuditRecordService.getOne(new LambdaQueryWrapper<ComplaintAuditRecord>().eq(ComplaintAuditRecord::getComplaintId, detail.getId())
+ .eq(ComplaintAuditRecord::getLatestFlag, 1));
+ Integer isAdmin = systemUserByPhone.get().getIsAdmin();
+ if(one.getReportType().equals(accountLevel) && one.getSuperiorId().toString().equals(targetId) && 1 == isAdmin){
detail.setAuditButtonStatus(0);
}
}
-
+ //已办结，显示评价按钮
+ int count = complaintCommentService.count(new LambdaQueryWrapper<ComplaintComment>().eq(ComplaintComment::getComplaintId, detail.getId()).eq(ComplaintComment::getDelFlag, 0));
+ if(detail.getStatus() == 3 && 0 == count){
+ if(systemUserByPhone.isPresent()){
+ SystemUser systemUser = systemUserByPhone.get();
+ Integer isAdmin = systemUser.getIsAdmin();
+ if(accountLevel.compareTo(detail.getReportType()) == 0 && ((accountLevel != 5 && 1 == isAdmin) || accountLevel == 5)){
+ detail.setEvaluateButtonStatus(0);
+ }
+ }else{
+ if(detail.getReportType() == 5){
+ detail.setEvaluateButtonStatus(0);
+ }
+ }
+ }
return detail;
}
@@ -321,9 +521,7 @@
@Override
@Transactional(rollbackFor = Exception.class)
public void saveReport(ComplaintReportDTO dto, LoginUserInfoVO loginUserInfoVO) {
- log.info("用户登录数据----------------》" + JSON.toJSONString(loginUserInfoVO));
String phone = loginUserInfoVO.getPhone();
-
SystemUser adminUser = systemUserService.getOne(new LambdaQueryWrapper<SystemUser>()
.eq(SystemUser::getPhone, phone)
.eq(SystemUser::getIsAdmin, 1)
@@ -331,16 +529,13 @@
.last("LIMIT 1"));
Long superiorId;
- Long currentId;
int reportType;
if (adminUser == null) {
superiorId = loginUserInfoVO.getCommunityId();
- currentId = 0L;
if (Objects.isNull(superiorId)) {
throw new ServiceException("上报失败，请绑定社区");
}
reportType = ReportTypeEnum.COMMUNITY.getCode();
- currentId = loginUserInfoVO.getUserId();
} else {
int accountLevel = adminUser.getAccountLevel(); // 改为基本类型
if (accountLevel == 1) {
@@ -351,16 +546,12 @@
// 使用基本类型比较并补充默认分支
if (accountLevel == ReportTypeEnum.COMMUNITY.getCode()) {
superiorId = Long.parseLong(adminUser.getStreetId());
- currentId = adminUser.getCommunityId();
} else if (accountLevel == ReportTypeEnum.STREET.getCode()) {
superiorId = Long.parseLong(adminUser.getDistrictsCode());
- currentId = Long.valueOf(adminUser.getStreetId());
} else if (accountLevel == ReportTypeEnum.DISTRICT.getCode()) {
superiorId = 510400L; // 攀枝花市
- currentId = Long.valueOf(adminUser.getDistrictsCode());
} else if(accountLevel == ReportTypeEnum.PARTY.getCode()){
superiorId = adminUser.getCommunityId();
- currentId = loginUserInfoVO.getUserId();
} else {
// 处理未预期的账号等级
throw new ServiceException("未知的账号等级");
@@ -368,9 +559,9 @@
}
Complaint complaint = getById(dto.getComplaintId());
- //complaint.setReportType(+);
- complaint.setSuperiorType(reportType);
- complaint.setSuperiorId(superiorId);
+ if (complaint.getStatus() != 0) {
+ complaint.setStatus(0);
+ }
updateById(complaint);
// 标记最新
@@ -379,7 +570,6 @@
.set(ComplaintAuditRecord::getLatestFlag, false));
// 添加审核记录
- //complaintAuditRecordService.createComplaintAuditRecord(dto.getComplaintId(), 2, dto.getComment(), loginUserInfoVO,adminUser);
int count = complaintAuditRecordService.count(new LambdaQueryWrapper<ComplaintAuditRecord>().eq(ComplaintAuditRecord::getComplaintId, complaint.getId()));
ComplaintAuditRecord complaintAuditRecord = new ComplaintAuditRecord();
complaintAuditRecord.setComplaintId(complaint.getId());
@@ -391,28 +581,11 @@
complaintAuditRecord.setUpdateBy(loginUserInfoVO.getUserId());
complaintAuditRecord.setUpdateTime(new Date());
complaintAuditRecord.setReporter(loginUserInfoVO.getNickName());
- complaintAuditRecord.setReportType(Objects.isNull(adminUser) ? 5 : adminUser.getAccountLevel());
- complaintAuditRecord.setSuperiorId(currentId);
+ complaintAuditRecord.setReportType(reportType);
+ complaintAuditRecord.setSuperiorId(superiorId);
complaintAuditRecord.setComment(dto.getComment());
complaintAuditRecord.setSort(count + 1);
complaintAuditRecordService.save(complaintAuditRecord);
-
-
- ComplaintAuditRecord complaintAuditRecord2 = new ComplaintAuditRecord();
- complaintAuditRecord2.setComplaintId(complaint.getId());
- complaintAuditRecord2.setLatestFlag(true);
- complaintAuditRecord2.setAuditType(2);
- complaintAuditRecord2.setAuditStatus(0);
- complaintAuditRecord2.setCreateBy(loginUserInfoVO.getUserId());
- complaintAuditRecord2.setCreateTime(new Date());
- complaintAuditRecord2.setUpdateBy(loginUserInfoVO.getUserId());
- complaintAuditRecord2.setUpdateTime(new Date());
- complaintAuditRecord2.setReporter(loginUserInfoVO.getNickName());
- complaintAuditRecord2.setReportType(reportType);
- complaintAuditRecord2.setSuperiorId(superiorId);
- complaintAuditRecord2.setComment(dto.getComment());
- complaintAuditRecord2.setSort(count + 2);
- complaintAuditRecordService.save(complaintAuditRecord2);
}
@Override
@@ -436,11 +609,7 @@
accountLevel++;
Complaint complaint = getById(dto.getComplaintId());
- complaint.setSuperiorType(accountLevel);
- complaint.setSuperiorId(dto.getDispatchId());
updateById(complaint);
- Long superiorOrgId = complaint.getSuperiorId();
- Integer superiorType = complaint.getSuperiorType();
//查询当前单位审核记录表数据
//查询上报审核记录
ComplaintAuditRecord complaintAuditRecord = complaintAuditRecordService.lambdaQuery()
@@ -460,7 +629,7 @@
ComplaintAuditRecord record = new ComplaintAuditRecord();
record.setComplaintId(complaint.getId());
record.setLatestFlag(true);
- record.setAuditType(0);
+ record.setAuditType(3);
record.setAuditStatus(1);
record.setCreateBy(loginUserInfoVO.getUserId());
record.setCreateTime(new Date(System.currentTimeMillis()));
@@ -476,7 +645,7 @@
@Override
@Transactional(rollbackFor = Exception.class)
public void reportAudit(ComplaintReporAuditDTO complaintReporAuditDTO, LoginUserInfoVO loginUserInfoVO) {
- Optional<SystemUser> systemUserByPhone = systemUserService.getSystemUserByPhone(loginUserInfoVO.getPhone());
+ Optional<SystemUser> systemUserByPhone = systemUserService.getSystemUserAdminByPhone(loginUserInfoVO.getPhone());
if (!systemUserByPhone.isPresent()) {
throw new ServiceException("无权审核");
}
@@ -506,82 +675,20 @@
.eq(ComplaintAuditRecord::getReportType, systemUser.getAccountLevel())
.eq(ComplaintAuditRecord::getSuperiorId, superiorId)
.last("LIMIT 1").one();
- ComplaintAuditRecord lowLevelRecord = complaintAuditRecordService.lambdaQuery()
- .eq(ComplaintAuditRecord::getComplaintId, complaintReporAuditDTO.getId())
- .eq(ComplaintAuditRecord::getAuditType, 2)
- .eq(ComplaintAuditRecord::getLatestFlag, true)
- .eq(ComplaintAuditRecord::getReportType, systemUser.getAccountLevel()+1)
- .last("LIMIT 1").one();
if (Objects.isNull(complaintAuditRecord)) {
throw new ServiceException("上报申请记录不存在");
}
- //查询待审核诉求
- //complaintAuditRecordService.audit(complaintAuditRecord, loginUserInfoVO.getUserId(),
- // complaintReporAuditDTO.getAuditResult(), complaintReporAuditDTO.getRejectReason());
-
- // 添加流转记录
- Complaint complaint = getById(complaintAuditRecord.getComplaintId());
-
- // 标记最新
- complaintAuditRecordService.update(new LambdaUpdateWrapper<ComplaintAuditRecord>()
- .eq(ComplaintAuditRecord::getComplaintId, complaintAuditRecord.getComplaintId())
- .set(ComplaintAuditRecord::getLatestFlag, false));
-
if (complaintReporAuditDTO.getAuditResult().equals(1)) {
- int count = complaintAuditRecordService.count(new LambdaQueryWrapper<ComplaintAuditRecord>().eq(ComplaintAuditRecord::getComplaintId, complaint.getId()));
- ComplaintAuditRecord record = new ComplaintAuditRecord();
- record.setComplaintId(complaint.getId());
- record.setLatestFlag(true);
- record.setAuditorId(loginUserInfoVO.getUserId());
- record.setAuditType(0);
- record.setAuditStatus(1);
- record.setCreateBy(loginUserInfoVO.getUserId());
- record.setCreateTime(new Date());
- record.setUpdateBy(loginUserInfoVO.getUserId());
- record.setUpdateTime(new Date());
- record.setReporter(complaintAuditRecord.getReporter());
- record.setReportType(complaintAuditRecord.getReportType());
- record.setSuperiorId(superiorId);
- record.setSort(count + 1);
- complaintAuditRecordService.save(record);
+ complaintAuditRecord.setAuditStatus(1);
+ complaintAuditRecord.setAuditorId(loginUserInfoVO.getUserId());
+ complaintAuditRecordService.updateById(complaintAuditRecord);
//创建流程
- complaintFlowService.createFlow(lowLevelRecord ,0, loginUserInfoVO.getUserId());
+ complaintFlowService.createFlow(complaintAuditRecord ,0, loginUserInfoVO.getUserId());
} else {
-
- switch (systemUser.getAccountLevel() + 1) {
- case 1:
- superiorId = 510400L;//默认市级
- break;
- case 2:
- superiorId = Long.parseLong(systemUser.getDistrictsCode());
- break;
- case 3:
- superiorId = Long.parseLong(systemUser.getStreetId());
- break;
- case 4:
- superiorId = systemUser.getCommunityId();
- break;
- case 5:
- superiorId = complaint.getCreateBy();
- break;
- }
- int count = complaintAuditRecordService.count(new LambdaQueryWrapper<ComplaintAuditRecord>().eq(ComplaintAuditRecord::getComplaintId, complaint.getId()));
- ComplaintAuditRecord record2 = new ComplaintAuditRecord();
- record2.setComplaintId(complaint.getId());
- record2.setLatestFlag(true);
- record2.setAuditType(2);
- record2.setAuditorId(loginUserInfoVO.getUserId());
- record2.setAuditStatus(2);
- record2.setCreateBy(loginUserInfoVO.getUserId());
- record2.setCreateTime(new Date());
- record2.setUpdateBy(loginUserInfoVO.getUserId());
- record2.setUpdateTime(new Date());
- record2.setReporter(complaintAuditRecord.getReporter());
- record2.setReportType(systemUser.getAccountLevel() + 1);
- record2.setSuperiorId(superiorId);
- record2.setRejectReason(complaintReporAuditDTO.getRejectReason());
- record2.setSort(count + 1);
- complaintAuditRecordService.save(record2);
+ complaintAuditRecord.setRejectReason(complaintReporAuditDTO.getRejectReason());
+ complaintAuditRecord.setAuditStatus(2);
+ complaintAuditRecord.setAuditorId(loginUserInfoVO.getUserId());
+ complaintAuditRecordService.updateById(complaintAuditRecord);
}
}
@@ -589,57 +696,44 @@
@Override
@Transactional(rollbackFor = Exception.class)
public void saveDelay(ComplaintDelayDTO dto, LoginUserInfoVO loginUserInfoVO) {
- SystemUser systemUser = systemUserService.getSystemUserByPhone(loginUserInfoVO.getPhone()).orElse(null);
+ SystemUser systemUser = systemUserService.getSystemUserAdminByPhone(loginUserInfoVO.getPhone()).orElse(null);
Long superiorId;
- Long currentId;
int reportType;
if (systemUser == null) {
superiorId = loginUserInfoVO.getCommunityId();
- currentId = loginUserInfoVO.getUserId();
if (Objects.isNull(superiorId)) {
- throw new ServiceException("上报失败，请绑定社区");
+ throw new ServiceException("延期申请失败，请绑定社区");
}
reportType = ReportTypeEnum.COMMUNITY.getCode();
} else {
int accountLevel = systemUser.getAccountLevel(); // 改为基本类型
if (accountLevel == 1) {
- throw new ServiceException("市级账号,无法上报！");
+ throw new ServiceException("市级账号,无法延期申请！");
}
reportType = accountLevel - 1;
// 使用基本类型比较并补充默认分支
if (accountLevel == ReportTypeEnum.COMMUNITY.getCode()) {
superiorId = Long.parseLong(systemUser.getStreetId());
- currentId = systemUser.getCommunityId();
} else if (accountLevel == ReportTypeEnum.STREET.getCode()) {
superiorId = Long.parseLong(systemUser.getDistrictsCode());
- currentId = Long.parseLong(systemUser.getStreetId());
} else if (accountLevel == ReportTypeEnum.DISTRICT.getCode()) {
superiorId = 510400L; // 攀枝花市
- currentId = Long.parseLong(systemUser.getDistrictsCode());
} else if (accountLevel == ReportTypeEnum.PARTY.getCode()) {
superiorId = systemUser.getCommunityId();
- currentId = loginUserInfoVO.getUserId();
} else {
// 处理未预期的账号等级
throw new ServiceException("未知的账号等级");
}
}
- Complaint complaint = getById(dto.getComplaintId());
- complaint.setSuperiorType(reportType);
- complaint.setSuperiorId(superiorId);
- updateById(complaint);
- // 添加审核记录
- //complaintAuditRecordService.createComplaintAuditRecord(dto.getComplaintId(), 1, dto.getComment(), loginUserInfoVO, systemUser);
-
// 清除最新记录
complaintAuditRecordService.update(new LambdaUpdateWrapper<ComplaintAuditRecord>()
.eq(ComplaintAuditRecord::getComplaintId, dto.getComplaintId())
.set(ComplaintAuditRecord::getLatestFlag, false));
- int count = complaintAuditRecordService.count(new LambdaQueryWrapper<ComplaintAuditRecord>().eq(ComplaintAuditRecord::getComplaintId, complaint.getId()));
+ int count = complaintAuditRecordService.count(new LambdaQueryWrapper<ComplaintAuditRecord>().eq(ComplaintAuditRecord::getComplaintId, dto.getComplaintId()));
ComplaintAuditRecord record1 = new ComplaintAuditRecord();
- record1.setComplaintId(complaint.getId());
+ record1.setComplaintId(dto.getComplaintId());
record1.setLatestFlag(true);
record1.setAuditType(1);
record1.setAuditStatus(0);
@@ -648,42 +742,28 @@
record1.setUpdateBy(loginUserInfoVO.getUserId());
record1.setUpdateTime(new Date(System.currentTimeMillis()));
record1.setReporter(loginUserInfoVO.getNickName());
- record1.setReportType(Objects.isNull(systemUser) ? 5 : systemUser.getAccountLevel());
- record1.setSuperiorId(currentId);
+ record1.setReportType(reportType);
+ record1.setSuperiorId(superiorId);
record1.setSort(count + 1);
+ record1.setComment(dto.getComment());
complaintAuditRecordService.save(record1);
-
- ComplaintAuditRecord record2 = new ComplaintAuditRecord();
- record2.setComplaintId(complaint.getId());
- record2.setLatestFlag(true);
- record2.setAuditType(1);
- record2.setAuditStatus(0);
- record2.setCreateBy(loginUserInfoVO.getUserId());
- record2.setCreateTime(new Date(System.currentTimeMillis()));
- record2.setUpdateBy(loginUserInfoVO.getUserId());
- record2.setUpdateTime(new Date(System.currentTimeMillis()));
- record2.setReporter(loginUserInfoVO.getNickName());
- record2.setReportType(reportType);
- record2.setSuperiorId(superiorId);
- record2.setSort(count + 2);
- complaintAuditRecordService.save(record2);
}
@Override
public void delayAudit(ComplaintDelayAuditDTO dto, LoginUserInfoVO loginUserInfoVO) {
-
- SystemUser systemUser = systemUserService.getSystemUserByPhone(loginUserInfoVO.getPhone()).orElse(null);
-
+ SystemUser systemUser = systemUserService.getSystemUserAdminByPhone(loginUserInfoVO.getPhone()).orElse(null);
int accountLevel = systemUser.getAccountLevel(); // 改为基本类型
- Long cunrrentId;
+ Long superiorId;
// 使用基本类型比较并补充默认分支
if (accountLevel == ReportTypeEnum.COMMUNITY.getCode()) {
- cunrrentId = systemUser.getCommunityId();
+ superiorId = systemUser.getCommunityId();
} else if (accountLevel == ReportTypeEnum.STREET.getCode()) {
- cunrrentId = Long.parseLong(systemUser.getStreetId());
+ superiorId = Long.parseLong(systemUser.getStreetId());
} else if (accountLevel == ReportTypeEnum.DISTRICT.getCode()) {
- cunrrentId = Long.parseLong(systemUser.getDistrictsCode());
+ superiorId = Long.parseLong(systemUser.getDistrictsCode());
+ } else if (accountLevel == ReportTypeEnum.CITY.getCode()) {
+ superiorId = 510400L;
} else {
// 处理未预期的账号等级
throw new ServiceException("未知的账号等级");
@@ -694,8 +774,8 @@
.eq(ComplaintAuditRecord::getAuditType, 1)
.eq(ComplaintAuditRecord::getLatestFlag, 1)
.eq(ComplaintAuditRecord::getAuditStatus, 0)
- .ne(ComplaintAuditRecord::getSuperiorId, cunrrentId)
- .eq(ComplaintAuditRecord::getReportType, accountLevel+1)
+ .ne(ComplaintAuditRecord::getSuperiorId, superiorId)
+ .eq(ComplaintAuditRecord::getReportType, accountLevel)
.eq(ComplaintAuditRecord::getComplaintId, dto.getComplaintId())
.last("LIMIT 1"));
@@ -703,36 +783,23 @@
if (Objects.isNull(complaintAuditRecord)) {
throw new ServiceException("诉求延期申请不存在");
}
- //complaintAuditRecordService.audit(complaintAuditRecord, loginUserInfoVO.getUserId(),
- // dto.getAuditResult(), dto.getRejectReason());
//审核通过后，设置诉求延期
- if (complaintAuditRecord.getAuditType().equals(1) && complaintAuditRecord.getAuditStatus().equals(0)) {
+ if (complaintAuditRecord.getAuditType().equals(1) && complaintAuditRecord.getAuditStatus().equals(0) && dto.getAuditResult().equals(1)) {
Complaint complaint = getById(complaintAuditRecord.getComplaintId());
complaint.setStatus(1);
updateById(complaint);
+
+ complaintAuditRecord.setAuditStatus(1);
+ complaintAuditRecord.setAuditorId(loginUserInfoVO.getUserId());
+ complaintAuditRecordService.updateById(complaintAuditRecord);
}
-
-
- complaintAuditRecordService.update(new LambdaUpdateWrapper<ComplaintAuditRecord>()
- .eq(ComplaintAuditRecord::getComplaintId, dto.getComplaintId())
- .set(ComplaintAuditRecord::getLatestFlag, false));
- int count = complaintAuditRecordService.count(new LambdaQueryWrapper<ComplaintAuditRecord>().eq(ComplaintAuditRecord::getComplaintId, dto.getId()));
- ComplaintAuditRecord record1 = new ComplaintAuditRecord();
- record1.setComplaintId(dto.getComplaintId());
- record1.setLatestFlag(true);
- record1.setAuditType(2);
- record1.setAuditorId(loginUserInfoVO.getUserId());
- record1.setAuditStatus(dto.getAuditResult());
- record1.setCreateBy(loginUserInfoVO.getUserId());
- record1.setCreateTime(new Date(System.currentTimeMillis()));
- record1.setUpdateBy(loginUserInfoVO.getUserId());
- record1.setUpdateTime(new Date(System.currentTimeMillis()));
- record1.setReporter(complaintAuditRecord.getReporter());
- record1.setReportType(complaintAuditRecord.getReportType());
- record1.setSuperiorId(complaintAuditRecord.getSuperiorId());
- record1.setSort(count + 1);
- complaintAuditRecordService.save(record1);
-
+ //审核不通过
+ if(complaintAuditRecord.getAuditType().equals(1) && complaintAuditRecord.getAuditStatus().equals(0) && dto.getAuditResult().equals(2)){
+ complaintAuditRecord.setRejectReason(dto.getRejectReason());
+ complaintAuditRecord.setAuditStatus(2);
+ complaintAuditRecord.setAuditorId(loginUserInfoVO.getUserId());
+ complaintAuditRecordService.updateById(complaintAuditRecord);
+ }
}
@Override
@@ -798,7 +865,7 @@
*/
@Override
public Page<ComplaintTodoVO> getTodoList(BasePage basePage, LoginUserInfoVO loginUserInfo) {
- Optional<SystemUser> systemUserByPhone = systemUserService.getSystemUserByPhone(loginUserInfo.getPhone());
+ Optional<SystemUser> systemUserByPhone = systemUserService.getSystemUserAdminByPhone(loginUserInfo.getPhone());
String targetId = "";
int isSuperior = 0;
//上级
@@ -845,5 +912,152 @@
.eq(ComplaintAuditRecord::getLatestFlag, true)
.last("LIMIT 1").one();
}
+
+ /**
+ * 管理后台-诉求列表
+ *
+ * @param query
+ * @param loginUserInfo
+ * @return
+ */
+ @Override
+ public Page<ComplaintVO> pageList(MgtComplaintQuery query, SystemUserVo loginUserInfo) {
+ return baseMapper.pageList(new Page<>(query.getPageNum(), query.getPageSize()), query,loginUserInfo);
+ }
+
+ @Override
+ public ComplaintVO getDetailMgt(Long id) {
+ Complaint complaint = getById(id);
+ ComplaintVO complaintVO = BeanUtil.copyProperties(complaint, ComplaintVO.class);
+ //查询办理进度
+ List<ComplaintProgress> complaintProgresses = complaintProgressService.lambdaQuery().eq(ComplaintProgress::getComplaintId, id).orderByAsc(ComplaintProgress::getCreateTime).list();
+ complaintVO.setComplaintProgresses(complaintProgresses);
+ //查询诉求流转记录
+ List<ComplaintFlow> complaintFlows = complaintFlowService.lambdaQuery().eq(ComplaintFlow::getComplaintId, id).orderByAsc(ComplaintFlow::getCreateTime).list();
+ complaintVO.setComplaintFlows(complaintFlows);
+ //查询评价
+ ComplaintComment comment = complaintCommentService.lambdaQuery().eq(ComplaintComment::getComplaintId, id).last("LIMIT 1").one();
+ complaintVO.setComplaintComment(comment);
+ return complaintVO;
+ }
+
+ /**
+ * 诉求列表导出
+ * @param query
+ * @param loginUserInfo
+ */
+ @Override
+ public void export(MgtComplaintQuery query, SystemUserVo loginUserInfo) throws IOException {
+ List<ComplaintVO> list = baseMapper.getList(query, loginUserInfo);
+ List<ComplaintExcel> complaintExcels = BeanUtil.copyToList(list, ComplaintExcel.class);
+ response.setContentType("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet");
+ response.setCharacterEncoding("utf-8");
+ String fileName = URLEncoder.encode("诉求数据", "UTF-8").replaceAll("\\+", "%20");
+ response.setHeader("Content-disposition", "attachment;filename*=utf-8''" + fileName + ".xlsx");
+ EasyExcel.write(response.getOutputStream(), PartyMemberExcel.class)
+ .sheet("诉求数据")
+ .doWrite(complaintExcels);
+ }
+
+ @Override
+ public void downloadFile(Long id,Integer type) throws IOException {
+ Complaint complaint = getById(id);
+ if (Objects.isNull(complaint)) {
+ throw new ServiceException("该诉求不存在");
+ }
+ //查询社区信息
+ BcRegion region = bcRegionService.lambdaQuery().eq(BcRegion::getRegionCode, complaint.getDistrictsCode()).last("LIMIT 1").one();
+ ComStreet street = comStreetService.lambdaQuery().eq(ComStreet::getStreetId, complaint.getStreetId()).one();
+ ComAct act = comActService.lambdaQuery().eq(ComAct::getCommunityId, complaint.getCommunityId()).one();
+ String community = region.getRegionName() +"-"+ street.getName() + act.getName();
+ PartyMember partyMember = null;
+ if (Objects.nonNull(complaint.getPartyMemberId())){
+ partyMember = partyMemberService.getById(complaint.getPartyMemberId());
+ }
+ String fileName = "";
+ switch (type){
+ case 1:
+ fileName = "社区问题单";
+ break;
+ case 2:
+ fileName = "问题处理单";
+ if (Objects.nonNull(partyMember)) {
+ community = community + "-" + partyMember.getServiceTarget();
+ }
+ break;
+ case 3:
+ fileName = "协调通知单";
+ break;
+ }
+ Map<String, Object> map = new HashMap<>();
+ map.put("community", community);
+ map.put("problemType", complaint.getProblemType());
+ map.put("descriptionContent", complaint.getDescriptionContent());
+ map.put("reportType", Objects.nonNull(complaint.getPartyMemberId())?"党员": "上级"); //TODO待修改
+ map.put("partyOrganization",Objects.nonNull(partyMember)? partyMember.getPartyOrganization() : "");
+ map.put("name", complaint.getName());
+ map.put("contactNumber", complaint.getContactNumber());
+ map.put("nickname", Objects.nonNull(partyMember)? partyMember.getName() : "");
+ map.put("phone", Objects.nonNull(partyMember)? partyMember.getPhone() : "");
+ List<ComplaintProgress> list = complaintProgressService.lambdaQuery().eq(ComplaintProgress::getComplaintId, id).orderByAsc(ComplaintProgress::getCreateTime).list();
+ StringBuilder sb = new StringBuilder();
+ if (CollUtil.isNotEmpty(list)) {
+ int rowNum = 1;
+ list.forEach(item->{
+ sb.append(rowNum).append("、 ");
+ sb.append(item.getDescribe()).append("\n");
+ });
+ }
+ // 在文本中直接使用换行符
+ map.put("complaintProgress", sb.toString());
+ map.put("status", ProcessStatusEnum.getDescriptionByCode(complaint.getStatus()));
+ if (2 == type) {
+ //查询诉求评价
+ ComplaintComment complaintComment = complaintCommentService.lambdaQuery().eq(ComplaintComment::getComplaintId, id).last("LIMIT 1").one();
+ if (Objects.nonNull(complaintComment)) {
+ map.put("rateStr", RateEnum.getEnumByCode(complaintComment.getRate()));
+ }
+ }
+ response.setContentType("application/octet-stream");
+ String fileNameEncode = URLEncoder.encode(fileName, "UTF-8").replaceAll("\\+", "%20");
+ response.setHeader("Content-disposition","attachment;filename=\""+fileNameEncode+".docx"+"\"");
+ String fileTemplateName = FileUtil.getPath() + "template/"+fileName+".docx";
+ XWPFTemplate.compile(fileTemplateName).render(map).writeAndClose(response.getOutputStream());
+ }
+
+
+ public static void main(String[] args) {
+ try {
+ /*文本*/
+ Map<String, Object> map = new HashMap<>();
+ map.put("community", "社区社区");
+ map.put("problemType", "就业");
+ map.put("descriptionContent", "描述内容");
+ map.put("reportType", "党员");
+ map.put("partyOrganization", "石羊党群");
+ map.put("name", "张三");
+ map.put("contactNumber", "1888888888");
+ map.put("nickname", "李四");
+ map.put("phone", "17777777777");
+ // 在文本中直接使用换行符
+ String content = "第一行内容\n第二行内容\n第三行内容";
+ map.put("complaintProgress", content);
+ map.put("status", "处理中");
+ XWPFTemplate.compile("F:\\DeskTop\\zhihuishequ\\springcloud_k8s_panzhihuazhihuishequ\\service_sangeshenbian\\src\\main\\resources\\template\\社区问题单.docx").render(map).writeToFile("F:\\DeskTop\\社区.docx");
+ } catch (IOException e) {
+ e.printStackTrace();
+ }
+ }
+
+
+ /**
+ * 获取超时未评价的数据
+ * @return
+ */
+ @Override
+ public List<Complaint> getTimeoutAndNotComment() {
+ return this.baseMapper.getTimeoutAndNotComment();
+ }
+
}
--
Gitblit v1.7.1