From 00e8c3f4a239031ef5b91333ffa7d20c6a80b67f Mon Sep 17 00:00:00 2001 From: mitao <2763622819@qq.com> Date: 星期五, 21 三月 2025 16:13:29 +0800 Subject: [PATCH] 问题处理单模板调整 --- springcloud_k8s_panzhihuazhihuishequ/service_sangeshenbian/src/main/java/com/panzhihua/sangeshenbian/service/impl/ComplaintServiceImpl.java | 29 ++++++++++++++++++----------- 1 files changed, 18 insertions(+), 11 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 ef8e807..40e393c 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,7 +2,6 @@ import cn.hutool.core.bean.BeanUtil; import cn.hutool.core.collection.CollUtil; -import cn.hutool.core.collection.CollectionUtil; import cn.idev.excel.EasyExcel; import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; import com.baomidou.mybatisplus.core.conditions.update.LambdaUpdateWrapper; @@ -13,8 +12,10 @@ 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.config.AutoColumnWidthStrategy; import com.panzhihua.sangeshenbian.dao.ComplaintMapper; import com.panzhihua.sangeshenbian.enums.AuditStatusEnum; +import com.panzhihua.sangeshenbian.enums.ComplaintExportEnum; import com.panzhihua.sangeshenbian.enums.ProcessStatusEnum; import com.panzhihua.sangeshenbian.enums.RateEnum; import com.panzhihua.sangeshenbian.enums.ReportTypeEnum; @@ -27,15 +28,13 @@ import com.panzhihua.sangeshenbian.model.vo.ComplaintVO; import com.panzhihua.sangeshenbian.model.vo.DispatchVO; import com.panzhihua.sangeshenbian.service.*; -import com.panzhihua.sangeshenbian.utils.FileUtil; import com.panzhihua.sangeshenbian.warpper.IdentityInformation; import com.panzhihua.sangeshenbian.warpper.MgtComplaintQuery; import com.panzhihua.sangeshenbian.warpper.PermissionsVO; +import jodd.util.StringUtil; import lombok.RequiredArgsConstructor; import lombok.extern.slf4j.Slf4j; import org.springframework.context.annotation.Lazy; -import org.springframework.core.io.ClassPathResource; -import org.springframework.data.redis.connection.RedisServer; import org.springframework.stereotype.Service; import org.springframework.transaction.annotation.Transactional; @@ -454,7 +453,7 @@ } ComplaintVO detail = baseMapper.getDetail(id); if (detail.getStatus().equals(0)) { - List<ComplaintFlow> list = complaintFlowService.lambdaQuery().eq(ComplaintFlow::getComplaintId, id).orderByAsc(ComplaintFlow::getCreateTime).list(); + List<ComplaintFlow> list = complaintFlowService.lambdaQuery().eq(ComplaintFlow::getComplaintId, id).orderByAsc(ComplaintFlow::getSort).list(); detail.setComplaintFlows(list); } //查询办理进度 @@ -940,6 +939,8 @@ if (Objects.isNull(complaintAuditRecord)) { throw new ServiceException("诉求延期申请不存在"); } + complaintAuditRecord.setAuditorName(systemUser.getName()); + complaintAuditRecord.setAuditorPhone(systemUser.getPhone()); //审核通过后,设置诉求延期 if (complaintAuditRecord.getAuditType().equals(1) && complaintAuditRecord.getAuditStatus().equals(0) && dto.getAuditResult().equals(1)) { Complaint complaint = getById(complaintAuditRecord.getComplaintId()); @@ -1089,7 +1090,7 @@ //查询诉求流转记录 List<ComplaintFlow> complaintFlows = complaintFlowService.lambdaQuery() .eq(ComplaintFlow::getComplaintId, id) - .orderByAsc(ComplaintFlow::getCreateTime) + .orderByAsc(ComplaintFlow::getSort) .list(); complaintVO.setComplaintFlows(complaintFlows); //查询评价 @@ -1114,11 +1115,12 @@ response.setHeader("Content-disposition", "attachment;filename*=utf-8''" + fileName + ".xlsx"); EasyExcel.write(response.getOutputStream(), ComplaintExcel.class) .sheet("诉求数据") + .registerWriteHandler(new AutoColumnWidthStrategy()) .doWrite(complaintExcels); } @Override - public void downloadFile(Long id, Integer type) throws IOException { + public void downloadFile(Long id, Integer type, SystemUserVo loginUserInfo) throws IOException { Complaint complaint = baseMapper.getDetailBg(id); if (Objects.isNull(complaint)) { throw new ServiceException("该诉求不存在"); @@ -1173,7 +1175,9 @@ case 2: fileName = "question_handle.docx"; if (Objects.nonNull(partyMember)) { - community = community + "-" + partyMember.getServiceTarget(); + if (StringUtil.isNotBlank(partyMember.getServiceTarget())) { + community = community + "-" + partyMember.getServiceTarget(); + } } reportType = complaint.getCompletionUserLevel(); break; @@ -1195,7 +1199,9 @@ map.put("problemType", complaint.getProblemType()); map.put("descriptionContent", complaint.getDescriptionContent()); map.put("reportType", reportType == null ? "" : ReportTypeEnum.getDescriptionByCode(reportType)); - map.put("partyOrganization", Objects.nonNull(partyMember) ? partyMember.getPartyOrganization() : ""); + if (Objects.nonNull(partyMember)) { + map.put("partyOrganization", StringUtil.isNotBlank(partyMember.getPartyOrganization()) ? partyMember.getPartyOrganization() : ""); + } map.put("name", complaint.getName()); map.put("contactNumber", complaint.getContactNumber()); map.put("nickname", complaint.getReportUserName()); @@ -1211,13 +1217,14 @@ } // 在文本中直接使用换行符 map.put("complaintProgress", sb.toString()); - map.put("status", ProcessStatusEnum.getDescriptionByCode(complaint.getStatus())); + map.put("status", ComplaintExportEnum.getEnumByCode(complaint.getStatus()).getDesc()); 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())); + map.put("rateStr", RateEnum.getEnumByCode(complaintComment.getRate()).getDesc()); } + map.put("departmentLevel", ReportTypeEnum.getDescriptionByCode(loginUserInfo.getAccountLevel()) + "级"); } response.setContentType("application/octet-stream"); String fileNameEncode = URLEncoder.encode(fileName, "UTF-8").replaceAll("\\+", "%20"); -- Gitblit v1.7.1