From dedefa06e62e001b69fa52bb18c759f5fe951c08 Mon Sep 17 00:00:00 2001
From: liujie <1793218484@qq.com>
Date: 星期五, 06 六月 2025 18:32:28 +0800
Subject: [PATCH] 替换百度key

---
 springcloud_k8s_panzhihuazhihuishequ/service_sangeshenbian/src/main/java/com/panzhihua/sangeshenbian/service/impl/ComplaintServiceImpl.java | 1318 +++++++++++++++++++++++++++++++++++++++++++++--------------
 1 files changed, 993 insertions(+), 325 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 c4a4fbf..ac31ea7 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
@@ -6,55 +6,49 @@
 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.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
 import com.deepoove.poi.XWPFTemplate;
+import com.panzhihua.common.exceptions.ServiceException;
 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;
-import com.panzhihua.common.exceptions.ServiceException;
-import com.panzhihua.sangeshenbian.enums.ReportTypeEnum;
+import com.panzhihua.common.utlis.DateUtils;
+import com.panzhihua.common.utlis.StringUtils;
+import com.panzhihua.sangeshenbian.config.AutoColumnWidthStrategy;
+import com.panzhihua.sangeshenbian.dao.ComplaintMapper;
+import com.panzhihua.sangeshenbian.enums.*;
 import com.panzhihua.sangeshenbian.model.dto.*;
 import com.panzhihua.sangeshenbian.model.entity.*;
-import com.panzhihua.sangeshenbian.enums.ProcessStatusEnum;
-import com.panzhihua.sangeshenbian.dao.ComplaintMapper;
-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.AnalyticStatisticsQuery;
+import com.panzhihua.sangeshenbian.model.query.AppStaticsQuery;
 import com.panzhihua.sangeshenbian.model.query.BasePage;
 import com.panzhihua.sangeshenbian.model.query.ComplaintQuery;
-import com.panzhihua.sangeshenbian.model.vo.ComplaintTodoVO;
-import com.panzhihua.sangeshenbian.service.IComplaintFlowService;
-import com.panzhihua.sangeshenbian.service.IComplaintProgressService;
-import com.panzhihua.sangeshenbian.service.IComplaintService;
-import com.panzhihua.sangeshenbian.model.vo.DispatchVO;
+import com.panzhihua.sangeshenbian.model.vo.*;
 import com.panzhihua.sangeshenbian.service.*;
-import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
-import com.panzhihua.sangeshenbian.model.vo.ComplaintVO;
-import com.panzhihua.sangeshenbian.service.ISystemUserService;
-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.beans.BeanUtils;
 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.io.InputStream;
+import java.math.BigDecimal;
+import java.math.RoundingMode;
 import java.net.URLEncoder;
+import java.text.ParseException;
 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;
+import java.time.Duration;
+import java.time.LocalDate;
+import java.util.*;
+import java.util.stream.Collectors;
 
 import static cn.hutool.core.util.ObjectUtil.isNull;
 
@@ -82,6 +76,7 @@
     private final IComplaintCommentService complaintCommentService;
     private final HttpServletResponse response;
     private final IPartyMemberService partyMemberService;
+    private final IdentityInformationService identityInformationService;
     private final RedisUtils redisUtils;
 
     @Override
@@ -108,13 +103,15 @@
 
         // 设置流水号
         complaint.setSerialNumber(serialNumber);
-        Optional<SystemUser> systemUserOpt = systemUserService.getSystemUserAdminByPhone(loginUserInfoVO.getPhone());
         Integer accountLevel = 5;
-        //获取当前身份,1=党员,2=管理员
-        Integer identity = (Integer) redisUtils.get("identity:" + loginUserInfoVO.getPhone());
-        if (systemUserOpt.isPresent() && identity == 2) {
-            SystemUser systemUser = systemUserOpt.get();
-            accountLevel = systemUser.getAccountLevel();
+        //获取当前身份
+        IdentityInformation identityInformationVO = identityInformationService.getCurrentIdentityInformation(loginUserInfoVO);
+        //1=党员,2=管理员
+        SystemUser systemUser = identityInformationVO.getSystemUser();
+        Integer identity = identityInformationVO.getIdentity();
+        if (identity == 2) {
+            SystemUserLevel systemUserLevel = identityInformationVO.getSystemUserLevel();
+            accountLevel = systemUserLevel.getLevel();
             switch (accountLevel) {
                 case 1:
                     //市级
@@ -125,40 +122,40 @@
                 case 2:
                     //区县级
                     complaint.setCityCode(510400);
-                    complaint.setDistrictsCode(Integer.valueOf(systemUser.getDistrictsCode()));
+                    complaint.setDistrictsCode(Integer.valueOf(systemUserLevel.getDistrictsCode()));
                     complaint.setReportUserName(systemUser.getName());
                     complaint.setReportUserPhone(systemUser.getPhone());
                     break;
                 case 3:
                     //街道
                     complaint.setCityCode(510400);
-                    complaint.setDistrictsCode(Integer.valueOf(systemUser.getDistrictsCode()));
-                    complaint.setStreetId(Long.valueOf(systemUser.getStreetId()));
+                    complaint.setDistrictsCode(Integer.valueOf(systemUserLevel.getDistrictsCode()));
+                    complaint.setStreetId(Long.valueOf(systemUserLevel.getStreetId()));
                     complaint.setReportUserName(systemUser.getName());
                     complaint.setReportUserPhone(systemUser.getPhone());
                     break;
                 case 4:
                     //社区
                     complaint.setCityCode(510400);
-                    complaint.setDistrictsCode(Integer.valueOf(systemUser.getDistrictsCode()));
-                    complaint.setStreetId(Long.valueOf(systemUser.getStreetId()));
-                    complaint.setCommunityId(systemUser.getCommunityId());
+                    complaint.setDistrictsCode(Integer.valueOf(systemUserLevel.getDistrictsCode()));
+                    complaint.setStreetId(Long.valueOf(systemUserLevel.getStreetId()));
+                    complaint.setCommunityId(systemUserLevel.getCommunityId());
                     complaint.setReportUserName(systemUser.getName());
                     complaint.setReportUserPhone(systemUser.getPhone());
                     break;
                 case 5:
                     //党员
                     complaint.setCityCode(510400);
-                    complaint.setDistrictsCode(Integer.valueOf(systemUser.getDistrictsCode()));
-                    complaint.setStreetId(Long.valueOf(systemUser.getStreetId()));
-                    complaint.setCommunityId(systemUser.getCommunityId());
+                    complaint.setDistrictsCode(Integer.valueOf(systemUserLevel.getDistrictsCode()));
+                    complaint.setStreetId(Long.valueOf(systemUserLevel.getStreetId()));
+                    complaint.setCommunityId(systemUserLevel.getCommunityId());
                     PartyMember partyMember = partyMemberService.getPartyMemberByPhone(loginUserInfoVO.getPhone());
                     complaint.setPartyMemberId(partyMember.getId());
                     complaint.setReportUserName(partyMember.getName());
                     complaint.setReportUserPhone(partyMember.getPhone());
                     break;
             }
-        } else{
+        } else {
             PartyMember partyMember = partyMemberService.getPartyMemberByPhone(loginUserInfoVO.getPhone());
             //党员
             complaint.setCityCode(510400);
@@ -186,24 +183,49 @@
         save(complaint);
     }
 
-    /**
-     * @param query
-     * @param loginUserInfoVO
-     * @return
-     */
+    @Override
+    @Transactional(rollbackFor = Exception.class)
+    public void saveAndReport(ComplaintVO complaintVO, LoginUserInfoVO loginUserInfo) {
+        Complaint complaint = new Complaint();
+        BeanUtil.copyProperties(complaintVO, complaint);
+        saveComplaint(complaint, loginUserInfo);
+        ComplaintReportDTO dto = new ComplaintReportDTO();
+        dto.setComplaintId(complaint.getId());
+        dto.setComment(complaintVO.getComment());
+        saveReport(dto, loginUserInfo);
+    }
+
+    @Override
+    @Transactional(rollbackFor = Exception.class)
+    public void saveAndComplete(ComplaintSaveAndCompleteDTO complaintVO, LoginUserInfoVO loginUserInfo) {
+        Complaint complaint = new Complaint();
+        BeanUtil.copyProperties(complaintVO, complaint);
+        saveComplaint(complaint, loginUserInfo);
+
+        ComplaintCompletionDTO complaintCompletionDTO = complaintVO.getComplaintCompletionDTO();
+        complaintCompletionDTO.setComplaintId(complaint.getId());
+        complaintCompletionDTO.setId(complaint.getId());
+        saveResult(complaintCompletionDTO, loginUserInfo);
+    }
+
     @Override
     public Page<ComplaintVO> complaintList(ComplaintQuery query, LoginUserInfoVO loginUserInfoVO) {
+
+
         Page<ComplaintVO> page = new Page<>(query.getPageNum(), query.getPageSize());
         //判断当前登录用户级别,查询对应工单
         Optional<SystemUser> systemUserByPhone = systemUserService.getSystemUserAdminByPhone(loginUserInfoVO.getPhone());
         Long targetId = null;
         Integer accountLevel = 5;
         //获取当前身份,1=党员,2=管理员
-        Integer identity = (Integer) redisUtils.get("identity:" + loginUserInfoVO.getPhone());
+        IdentityInformation identityInformation = identityInformationService.getCurrentIdentityInformation(loginUserInfoVO);
+        Integer identity = identityInformation.getIdentity();
+        query.setUserId(loginUserInfoVO.getUserId());
         //上级
-        if (systemUserByPhone.isPresent() && identity == 2) {
+        if (systemUserByPhone.isPresent() && null != identity && identity == 2) {
             SystemUser systemUser = systemUserByPhone.get();
-            accountLevel = systemUser.getAccountLevel();
+            SystemUserLevel systemUserLevel = identityInformation.getSystemUserLevel();
+            accountLevel = systemUserLevel.getLevel();
             switch (accountLevel) {
                 case 1:
                     //市级
@@ -211,15 +233,15 @@
                     break;
                 case 2:
                     //区县级
-                    targetId = Long.valueOf(systemUser.getDistrictsCode());
+                    targetId = Long.valueOf(systemUserLevel.getDistrictsCode());
                     break;
                 case 3:
                     //街道
-                    targetId = Long.valueOf(systemUser.getStreetId());
+                    targetId = Long.valueOf(systemUserLevel.getStreetId());
                     break;
                 case 4:
                     //社区
-                    targetId = systemUser.getCommunityId();
+                    targetId = systemUserLevel.getCommunityId();
                     break;
                 case 5:
                     //党员
@@ -235,162 +257,243 @@
         //查询对应诉求
         //page = baseMapper.selectComplaintPage(page, query, targetId, isSuperior);
         page = baseMapper.selectComplaintPage1(page, query, accountLevel, targetId);
-        page.getRecords().forEach(s->{
-            buttonPermission(s, systemUserByPhone);
-        });
+
+     /*   for (ComplaintVO s : page.getRecords()) {
+            buttonPermission(s, systemUserByPhone, loginUserInfoVO);
+            Integer auditButtonStatus = s.getAuditButtonStatus();
+
+            Long reporterId = s.getReporterId();
+            Long superiorId = s.getSuperiorId2();
+            if (!targetId.equals(reporterId) && !targetId.equals(superiorId) && (s.getStatus() == 5)) {
+                s.setStatus(0);
+            }
+        }*/
         return page;
     }
-    
-    
+
+
     /**
      * 列表按钮权限
-     * @param vo
      */
-    public void buttonPermission(ComplaintVO vo, Optional<SystemUser> systemUserByPhone){
+    public void buttonPermission(ComplaintVO vo, Optional<SystemUser> systemUserByPhone, LoginUserInfoVO loginUserInfo) {
         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"));
+        vo.setAuditButtonStatus(1);
+        // 获取身份
+        IdentityInformation currentIdentityInformation = identityInformationService.getCurrentIdentityInformation(loginUserInfo);
+        Integer identity = currentIdentityInformation.getIdentity();
+        SystemUserLevel systemUserLevel = currentIdentityInformation.getSystemUserLevel();
+        SystemUser systemUser1 = currentIdentityInformation.getSystemUser();
+        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()){
+        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)){
+                //当前身份是管理员
+                if (2 == identity && accountLevel.compareTo(vo.getReportType()) == 0 && (accountLevel != 5)) {
                     vo.setListControlsButtonStatus(0);
                 }
-            }else{
-                if(vo.getReportType() == 5){
+                //如果当前身份是党员
+                if (1 == identity && 5 == vo.getReportType()) {
                     vo.setListControlsButtonStatus(0);
                 }
+            } else {
+                if (vo.getReportType() == 5) {
+                    vo.setListControlsButtonStatus(0);
+                }
+            }*/
+            //当前身份是管理员
+            if (2 == identity && systemUserLevel.getLevel().compareTo(vo.getReportType()) == 0 && (systemUserLevel.getLevel() != 5)) {
+                vo.setListControlsButtonStatus(0);
+            }
+            //如果当前身份是党员
+            if (1 == identity && 5 == vo.getReportType()) {
+                vo.setListControlsButtonStatus(0);
             }
         }
         //有审核数据,且正在办理
-        if(null != one && (vo.getStatus() == 0 || vo.getStatus() == 1 || vo.getStatus() == 2)){
+        if (null != one && (vo.getStatus() == 0 || vo.getStatus() == 1 || vo.getStatus() == 2 || vo.getStatus() == 6)) {
             //区分是上报数据还是下派数据
-            if(one.getAuditType() == 2){
+            if (one.getAuditType() == 2 || one.getAuditType() == 1) {
                 //判断当前审核状态
-                if(one.getAuditStatus() == 1){
+                if (one.getAuditStatus() == 1) {
                     //审核状态为通过,则权限给到上报审核的这一层
-                    if(systemUserByPhone.isPresent()){
+                /*    if (systemUserByPhone.isPresent() && identity == 2) {
                         SystemUser systemUser = systemUserByPhone.get();
                         Integer accountLevel = systemUser.getAccountLevel();
-                        Integer isAdmin = systemUser.getIsAdmin();
                         //非党员用户,必须是管理员有权限
-                        if(accountLevel.compareTo(one.getReportType()) == 0 && accountLevel != 5 && 1 == isAdmin){
+                        if (accountLevel.compareTo(one.getReportType()) == 0) {
+                            vo.setListControlsButtonStatus(0);
+                        }
+                    }*/
+                    if (identity == 2) {
+                        //非党员用户,必须是管理员有权限
+                        if (systemUserLevel.getLevel().compareTo(one.getReportType()) == 0) {
                             vo.setListControlsButtonStatus(0);
                         }
                     }
-                }else{
+                } 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);
-                            }
+                    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 (identity == 2 && systemUserLevel.getLevel().compareTo(one1.getReportType()) == 0 && systemUserLevel.getLevel() != 5) {
+                            vo.setListControlsButtonStatus(0);
                         }
-                    }else{
-                        //没有上一层审核通过的数据,则权限给到添加人
-                        if(systemUserByPhone.isPresent()){
+                        /*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)){
+                            if (accountLevel.compareTo(one1.getReportType()) == 0 && accountLevel != 5 && 1 == isAdmin) {
                                 vo.setListControlsButtonStatus(0);
                             }
-                        }else{
-                            if(vo.getReportType() == 5){
+                        }*/
+                    } else {
+                        //没有上一层审核通过的数据,则权限给到添加人
+                        /*if (systemUserByPhone.isPresent()) {
+                            SystemUser systemUser = systemUserByPhone.get();
+                            Integer accountLevel = systemUser.getAccountLevel();
+                            Integer isAdmin = systemUser.getIsAdmin();
+                            //当前身份是管理员
+                            if (2 == identity && accountLevel.compareTo(vo.getReportType()) == 0 && (accountLevel != 5 && 1 == isAdmin)) {
                                 vo.setListControlsButtonStatus(0);
                             }
+                            //如果当前身份是党员
+                            if (1 == identity && 5 == vo.getReportType()) {
+                                vo.setListControlsButtonStatus(0);
+                            }
+                        } else {
+                            if (vo.getReportType() == 5) {
+                                vo.setListControlsButtonStatus(0);
+                            }
+                        }*/
+                        //当前身份是管理员
+                        if (2 == identity && systemUserLevel.getLevel().compareTo(vo.getReportType()) == 0 && (systemUserLevel.getLevel() != 5)) {
+                            vo.setListControlsButtonStatus(0);
+                        }
+                        //如果当前身份是党员
+                        if (1 == identity && 5 == vo.getReportType()) {
+                            vo.setListControlsButtonStatus(0);
                         }
                     }
                 }
             }
-            
+
             //下派数据
-            if(one.getAuditType() == 3){
+            if (one.getAuditType() == 3) {
                 //判断当前审核状态
-                if(one.getAuditStatus() == 1){
+                if (one.getAuditStatus() == 1) {
                     //审核状态为通过,则权限给到下报审核的这一层
-                    if(systemUserByPhone.isPresent()){
+                    /*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)){
+                        if (accountLevel.compareTo(one.getReportType()) == 0 && 1 == isAdmin && 2 == identity) {
                             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);
-                            }
-                        }
+                    }*/
+                    if (2 == identity && systemUserLevel.getLevel().compareTo(one.getReportType()) == 0) {
+                        vo.setListControlsButtonStatus(0);
                     }
                 }
             }
         }
-        
+
+        //有审核数据,且为审核中
+        //审核状态为待审核,需要授权审核按钮
+        if (null != one && (vo.getStatus() == 5 || vo.getStatus() == 7) && identity == 2) {
+            SystemUser systemUser = systemUserByPhone.get();
+            String targetId = "";
+            Integer accountLevel = 5;
+            //获取当前身份,1=党员,2=管理员
+            accountLevel = systemUserLevel.getLevel();
+            switch (accountLevel) {
+                case 1:
+                    //市级
+                    targetId = "510400";
+                    break;
+                case 2:
+                    //区县级
+                    targetId = systemUserLevel.getDistrictsCode();
+                    break;
+                case 3:
+                    //街道
+                    targetId = systemUserLevel.getStreetId().toString();
+                    break;
+                case 4:
+                    //社区
+                    targetId = systemUserLevel.getCommunityId().toString();
+                    break;
+                case 5:
+                    //党员
+                    PartyMember partyMember = partyMemberService.getPartyMemberByPhone(systemUser.getPhone());
+                    targetId = partyMember.getId().toString();
+                    break;
+            }
+
+            ComplaintAuditRecord one2 = complaintAuditRecordService.getOne(new LambdaQueryWrapper<ComplaintAuditRecord>()
+                    .eq(ComplaintAuditRecord::getComplaintId, vo.getId())
+                    .eq(ComplaintAuditRecord::getLatestFlag, 1));
+            if (one2.getReportType().equals(accountLevel) && one2.getSuperiorId().toString().equals(targetId)) {
+                vo.setAuditButtonStatus(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()){
+        if ((vo.getStatus() == 3 || vo.getStatus() == 8) && 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)){
+                //当前不是党员身份,需要是管理员才有权限
+                if (2 == identity && accountLevel.compareTo(vo.getReportType()) == 0 && accountLevel != 5 && 1 == isAdmin) {
                     vo.setEvaluateButtonStatus(0);
                 }
-            }else{
-                if(vo.getReportType() == 5){
+                //当前是党员身份,只有是以党员身份提交的数据才有权限
+                if (1 == identity && vo.getReportType() == 5) {
                     vo.setEvaluateButtonStatus(0);
                 }
+            } else {
+                if (vo.getReportType() == 5) {
+                    vo.setEvaluateButtonStatus(0);
+                }
+            }*/
+            //当前不是党员身份,需要是管理员才有权限
+            if (2 == identity && systemUserLevel.getLevel().compareTo(vo.getReportType()) == 0 && systemUserLevel.getLevel() != 5) {
+                vo.setEvaluateButtonStatus(0);
+            }
+            //当前是党员身份,只有是以党员身份提交的数据才有权限
+            if (1 == identity && vo.getReportType() == 5) {
+                vo.setEvaluateButtonStatus(0);
             }
         }
+
+        Long auditCreateBy = vo.getAuditCreateBy();
+        Long userId = loginUserInfo.getUserId();
+        if (null != auditCreateBy && auditCreateBy.compareTo(userId) == 0 && vo.getStatus() == 5) {
+            vo.setWithdrawButtonStatus(0);
+        } else {
+            vo.setWithdrawButtonStatus(1);
+        }
+
+
     }
-    
-    
+
+
     /**
      * 工单详情
      *
@@ -403,11 +506,12 @@
         String targetId = "";
         Integer accountLevel = 5;
         //获取当前身份,1=党员,2=管理员
-        Integer identity = (Integer) redisUtils.get("identity:" + loginUserInfoVO.getPhone());
+        IdentityInformation identityInformation = identityInformationService.getCurrentIdentityInformation(loginUserInfoVO);
+        Integer identity = identityInformation.getIdentity();
         //上级
-        if (systemUserByPhone.isPresent() && identity == 2) {
-            SystemUser systemUser = systemUserByPhone.get();
-            accountLevel = systemUser.getAccountLevel();
+        if (identity == 2) {
+            SystemUserLevel systemUserLevel = identityInformation.getSystemUserLevel();
+            accountLevel = systemUserLevel.getLevel();
             switch (accountLevel) {
                 case 1:
                     //市级
@@ -415,15 +519,15 @@
                     break;
                 case 2:
                     //区县级
-                    targetId = systemUser.getDistrictsCode();
+                    targetId = systemUserLevel.getDistrictsCode();
                     break;
                 case 3:
                     //街道
-                    targetId = systemUser.getStreetId().toString();
+                    targetId = systemUserLevel.getStreetId().toString();
                     break;
                 case 4:
                     //社区
-                    targetId = systemUser.getCommunityId().toString();
+                    targetId = systemUserLevel.getCommunityId().toString();
                     break;
                 case 5:
                     //党员
@@ -438,38 +542,43 @@
         }
         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);
         }
         //查询办理进度
         List<ComplaintProgress> list = complaintProgressService.lambdaQuery().eq(ComplaintProgress::getComplaintId, id)
                 .orderByAsc(ComplaintProgress::getCreateTime).list();
         detail.setComplaintProgresses(list);
-        detail.setAuditButtonStatus(1);
-        detail.setEvaluateButtonStatus(1);
-        if((detail.getStatus() == 5 || detail.getStatus() == 7) && systemUserByPhone.isPresent()){
-            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);
-            }
+
+
+        buttonPermission(detail, systemUserByPhone, loginUserInfoVO);
+        Long reporterId = detail.getReporterId();
+        Long superiorId = detail.getSuperiorId2();
+        if (!String.valueOf(reporterId).equals(targetId) && !String.valueOf(superiorId).equals(targetId) && detail.getStatus() == 5) {
+            detail.setStatus(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);
-                }
-            }
-        }
+
+
+//        if (auditButtonStatus == 1 && detail.getStatus() == 5 && !Objects.equals(detail.getAuditCreateBy(), loginUserInfoVO.getUserId())){
+//            detail.setStatus(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;
     }
 
@@ -481,10 +590,27 @@
      */
     @Override
     public void saveProcess(ComplaintProcessDTO dto, LoginUserInfoVO loginUserInfoVO) {
+        //获取当前身份
+        IdentityInformation identityInformationVO = identityInformationService.getCurrentIdentityInformation(loginUserInfoVO);
+
+        List<PermissionsVO> permissions = identityInformationVO.getPermissions();
+        if (permissions.isEmpty()) {
+            throw new ServiceException("请先完善个人信息");
+        }
+        //上级
+        String name = "";
+        if (identityInformationVO.getIdentity() == 2) {
+            //1=党员,2=管理员
+            SystemUser systemUser = identityInformationVO.getSystemUser();
+            name = systemUser.getName();
+        } else if (identityInformationVO.getIdentity() == 1) {
+            PartyMember partyMember = identityInformationVO.getPartyMember();
+            name = partyMember.getName();
+        }
         ComplaintProgress complaintProgress = BeanUtil.copyProperties(dto, ComplaintProgress.class);
         complaintProgress.setCreateTime(new Date());
         complaintProgress.setCreateBy(loginUserInfoVO.getUserId());
-        complaintProgress.setCreateByName(loginUserInfoVO.getNickName());
+        complaintProgress.setCreateByName(name);
         complaintProgressService.save(complaintProgress);
     }
 
@@ -496,12 +622,43 @@
      */
     @Override
     public void saveResult(ComplaintCompletionDTO dto, LoginUserInfoVO loginUserInfoVO) {
-        Complaint complaint = BeanUtil.copyProperties(dto, Complaint.class);
+        //获取当前身份
+        IdentityInformation identityInformationVO = identityInformationService.getCurrentIdentityInformation(loginUserInfoVO);
+
+        List<PermissionsVO> permissions = identityInformationVO.getPermissions();
+        if (permissions.isEmpty()) {
+            throw new ServiceException("请先完善个人信息");
+        }
+        Integer accountLevel = null;
+        String name = "";
+        //上级
+        if (identityInformationVO.getIdentity() == 2) {
+            //1=党员,2=管理员
+            SystemUser systemUser = identityInformationVO.getSystemUser();
+            SystemUserLevel systemUserLevel = identityInformationVO.getSystemUserLevel();
+            accountLevel = systemUserLevel.getLevel();
+            name = systemUser.getName();
+        } else if (identityInformationVO.getIdentity() == 1) {
+            accountLevel = 5;
+            PartyMember partyMember = identityInformationVO.getPartyMember();
+            name = partyMember.getName();
+        }
+
+        Long complaintId = dto.getId();
+        Complaint complaint = this.getById(complaintId);
+        Date createTime = complaint.getCreateTime();
+        complaint = BeanUtil.copyProperties(dto, Complaint.class);
+
         complaint.setUpdateTime(new Date());
         complaint.setCompletionUserId(loginUserInfoVO.getUserId());
-        complaint.setCompletionUsername(loginUserInfoVO.getNickName());
+        complaint.setCompletionUsername(name);
         complaint.setCompletionUserPhone(loginUserInfoVO.getPhone());
         complaint.setCompletionTime(new Date());
+        complaint.setCompletionUserLevel(accountLevel);
+        // 计算处理时间
+        long l = Duration.between(createTime.toInstant(), complaint.getCompletionTime().toInstant()).getSeconds() / 3600;
+        double handlingDay = new BigDecimal(l).divide(new BigDecimal("24"), 2, RoundingMode.HALF_UP).doubleValue();
+        complaint.setHandlingDay(handlingDay);
         this.updateById(complaint);
     }
 
@@ -518,44 +675,81 @@
                 .orderByAsc(ComplaintProgress::getCreateTime).list();
     }
 
+
     @Override
     @Transactional(rollbackFor = Exception.class)
     public void saveReport(ComplaintReportDTO dto, LoginUserInfoVO loginUserInfoVO) {
         String phone = loginUserInfoVO.getPhone();
-        SystemUser adminUser = systemUserService.getOne(new LambdaQueryWrapper<SystemUser>()
-                .eq(SystemUser::getPhone, phone)
-                .eq(SystemUser::getIsAdmin, 1)
-                .ne(SystemUser::getStatus, 3)
-                .last("LIMIT 1"));
+        IdentityInformation identityInformationVO = identityInformationService.getCurrentIdentityInformation(loginUserInfoVO);
+        SystemUser adminUser = identityInformationVO.getSystemUser();
+        SystemUserLevel systemUserLevel = identityInformationVO.getSystemUserLevel();
 
         Long superiorId;
         int reportType;
-        if (adminUser == null) {
-            superiorId = loginUserInfoVO.getCommunityId();
-            if (Objects.isNull(superiorId)) {
-                throw new ServiceException("上报失败,请绑定社区");
-            }
-            reportType = ReportTypeEnum.COMMUNITY.getCode();
-        } else {
-            int accountLevel = adminUser.getAccountLevel(); // 改为基本类型
+        int reporterLevel;
+        Long reporterId = null;
+        String departmentName = "";
+        String reporter = "";
+        if (identityInformationVO.getIdentity() == 1) {
+            PartyMember partyMember = partyMemberService.getPartyMemberByPhone(phone);
+            superiorId = partyMember.getCommunityId();
+            reporterId = partyMember.getId();
+            reportType = 4;
+            reporterLevel = 5;
+            departmentName = partyMember.getDistricts() + "-" + partyMember.getStreet() + "-" + partyMember.getCommunity();
+            reporter = partyMember.getName();
+        } else if (identityInformationVO.getIdentity() == 2) {
+            int accountLevel = systemUserLevel.getLevel(); // 改为基本类型
             if (accountLevel == 1) {
                 throw new ServiceException("市级账号,无法上报!");
             }
             reportType = accountLevel - 1;
+            reporterLevel = accountLevel;
+            reporter = adminUser.getName();
 
             // 使用基本类型比较并补充默认分支
             if (accountLevel == ReportTypeEnum.COMMUNITY.getCode()) {
-                superiorId = Long.parseLong(adminUser.getStreetId());
+                superiorId = Long.parseLong(systemUserLevel.getStreetId());
+                reporterId = systemUserLevel.getCommunityId();
             } else if (accountLevel == ReportTypeEnum.STREET.getCode()) {
-                superiorId = Long.parseLong(adminUser.getDistrictsCode());
+                superiorId = Long.parseLong(systemUserLevel.getDistrictsCode());
+                reporterId = Long.parseLong(systemUserLevel.getStreetId());
             } else if (accountLevel == ReportTypeEnum.DISTRICT.getCode()) {
                 superiorId = 510400L; // 攀枝花市
-            } else if(accountLevel == ReportTypeEnum.PARTY.getCode()){
-                superiorId = adminUser.getCommunityId();
+                reporterId = Long.parseLong(systemUserLevel.getDistrictsCode());
+            } else if (accountLevel == ReportTypeEnum.PARTY.getCode()) {
+                superiorId = systemUserLevel.getCommunityId();
             } else {
                 // 处理未预期的账号等级
                 throw new ServiceException("未知的账号等级");
             }
+            //查询社区信息
+            switch (accountLevel) {
+                case 2:
+                    BcRegion region = bcRegionService.getDistrictByCode(systemUserLevel.getDistrictsCode().toString());
+                    if (Objects.nonNull(region)) {
+                        departmentName = region.getRegionName();
+                    }
+                    break;
+                case 3:
+                    ComStreet street = comStreetService.getById(systemUserLevel.getStreetId().toString());
+                    if (Objects.nonNull(street)) {
+                        BcRegion district = bcRegionService.getDistrictByCode(street.getAreaCode().toString());
+                        departmentName = Objects.nonNull(district) ? district.getRegionName() + "-" + street.getName() : street.getName();
+                    }
+                    break;
+                case 4:
+                    ComAct act = comActService.getById(systemUserLevel.getCommunityId());
+                    if (Objects.nonNull(act)) {
+                        ComStreet street2 = comStreetService.getById(adminUser.getStreetId().toString());
+                        BcRegion district = bcRegionService.getDistrictByCode(act.getAreaCode());
+                        departmentName = Objects.nonNull(district) && Objects.nonNull(street2) ?
+                                district.getRegionName() + "-" + street2.getName() + "-" + act.getName() : act.getName();
+                    }
+                    break;
+            }
+        } else {
+            throw new ServiceException("未知的账号等级");
         }
 
         Complaint complaint = getById(dto.getComplaintId());
@@ -580,47 +774,80 @@
         complaintAuditRecord.setCreateTime(new Date());
         complaintAuditRecord.setUpdateBy(loginUserInfoVO.getUserId());
         complaintAuditRecord.setUpdateTime(new Date());
-        complaintAuditRecord.setReporter(loginUserInfoVO.getNickName());
+        complaintAuditRecord.setReporter(reporter);
         complaintAuditRecord.setReportType(reportType);
         complaintAuditRecord.setSuperiorId(superiorId);
         complaintAuditRecord.setComment(dto.getComment());
         complaintAuditRecord.setSort(count + 1);
+        complaintAuditRecord.setDepartmentName(departmentName);
+        complaintAuditRecord.setReporterLevel(reporterLevel);
+        complaintAuditRecord.setReporterId(reporterId);
+        complaintAuditRecord.setApplyName(reporter);
+        complaintAuditRecord.setApplyPhone(phone);
         complaintAuditRecordService.save(complaintAuditRecord);
+    }
+
+    @Override
+    public void reportWithdraw(ComplaintReportWithdrawDTO dto, LoginUserInfoVO loginUserInfoVO) {
+        ComplaintAuditRecord complaintAuditRecord = complaintAuditRecordService.getOne(new LambdaQueryWrapper<ComplaintAuditRecord>()
+                .eq(ComplaintAuditRecord::getComplaintId, dto.getComplaintId())
+                .eq(ComplaintAuditRecord::getAuditType, 2)
+                .eq(ComplaintAuditRecord::getLatestFlag, true));
+        if (Objects.isNull(complaintAuditRecord)) {
+            throw new ServiceException("未找到相关记录");
+        }
+        complaintAuditRecord.setAuditStatus(3);
+        complaintAuditRecord.setUpdateBy(loginUserInfoVO.getUserId());
+        complaintAuditRecord.setUpdateTime(new Date());
+        complaintAuditRecord.setLatestFlag(false);
+        complaintAuditRecordService.updateById(complaintAuditRecord);
+
+        // 获取上一条记录
+        ComplaintAuditRecord lastRecord = complaintAuditRecordService.getOne(new LambdaQueryWrapper<ComplaintAuditRecord>()
+                .ne(ComplaintAuditRecord::getId, complaintAuditRecord.getId())
+                .eq(ComplaintAuditRecord::getComplaintId, dto.getComplaintId())
+                .eq(ComplaintAuditRecord::getAuditType, 2)
+                .eq(ComplaintAuditRecord::getLatestFlag, false)
+                .orderByDesc(ComplaintAuditRecord::getSort)
+        );
+        if (Objects.nonNull(lastRecord)) {
+            // 复制上一条记录
+            ComplaintAuditRecord newRecord = new ComplaintAuditRecord();
+            BeanUtils.copyProperties(lastRecord, newRecord);
+            newRecord.setId(null);
+            newRecord.setLatestFlag(true);
+            newRecord.setUpdateBy(loginUserInfoVO.getUserId());
+            newRecord.setUpdateTime(new Date());
+            complaintAuditRecordService.save(newRecord);
+        }
     }
 
     @Override
     @Transactional(rollbackFor = Exception.class)
     public void saveDispatch(ComplaintDispatch dto, LoginUserInfoVO loginUserInfoVO) {
-        String phone = loginUserInfoVO.getPhone();
-        SystemUser adminUser = systemUserService.getOne(new LambdaQueryWrapper<SystemUser>()
-                .eq(SystemUser::getPhone, phone)
-                .eq(SystemUser::getIsAdmin, 1)
-                .ne(SystemUser::getStatus, 3)
-                .last("LIMIT 1"));
-
-        if (adminUser == null) {
+        IdentityInformation identityInformation = identityInformationService.getCurrentIdentityInformation(loginUserInfoVO);
+        if (identityInformation.getIdentity() != 2) {
             throw new ServiceException("无权下派");
         }
 
-        int accountLevel = adminUser.getAccountLevel(); // 改为基本类型
+        SystemUserLevel systemUserLevel = identityInformation.getSystemUserLevel();
+        int accountLevel = systemUserLevel.getLevel(); // 改为基本类型
         if (accountLevel == 4) {
             throw new ServiceException("社区账号,无法下派!");
         }
         accountLevel++;
 
         Complaint complaint = getById(dto.getComplaintId());
-        updateById(complaint);
         //查询当前单位审核记录表数据
         //查询上报审核记录
-        ComplaintAuditRecord complaintAuditRecord = complaintAuditRecordService.lambdaQuery()
-                .eq(ComplaintAuditRecord::getComplaintId, dto.getComplaintId())
-                .eq(ComplaintAuditRecord::getAuditType, 0)
-                .eq(ComplaintAuditRecord::getLatestFlag, true)
-                .eq(ComplaintAuditRecord::getReportType, adminUser.getAccountLevel())
-                .last("LIMIT 1").one();
+//        ComplaintAuditRecord complaintAuditRecord = complaintAuditRecordService.lambdaQuery()
+//                .eq(ComplaintAuditRecord::getComplaintId, dto.getComplaintId())
+//                .eq(ComplaintAuditRecord::getAuditType, 0)
+//                .eq(ComplaintAuditRecord::getLatestFlag, true)
+//                .eq(ComplaintAuditRecord::getReportType, adminUser.getAccountLevel())
+//                .last("LIMIT 1").one();
         // 添加流转记录
-        complaintFlowService.createFlow(complaintAuditRecord, 1,loginUserInfoVO.getUserId());
-
+//        complaintFlowService.createFlow(complaintAuditRecord, 1,loginUserInfoVO.getUserId());
         // 标记最新
         complaintAuditRecordService.update(new LambdaUpdateWrapper<ComplaintAuditRecord>()
                 .eq(ComplaintAuditRecord::getComplaintId, dto.getComplaintId())
@@ -640,30 +867,53 @@
         record.setSuperiorId(dto.getDispatchId());
         record.setSort(count + 1);
         complaintAuditRecordService.save(record);
+        ComplaintAuditRecord complaintAuditRecord = new ComplaintAuditRecord();
+        complaintAuditRecord.setComplaintId(complaint.getId());
+        complaintAuditRecord.setReportType(systemUserLevel.getLevel());
+        Long superiorId = null;
+        switch (systemUserLevel.getLevel()) {
+            case 1:
+                superiorId = 510400L;//默认市级
+                break;
+            case 2:
+                superiorId = Long.parseLong(systemUserLevel.getDistrictsCode());
+                break;
+            case 3:
+                superiorId = Long.parseLong(systemUserLevel.getStreetId());
+                break;
+            case 4:
+                superiorId = systemUserLevel.getCommunityId();
+                break;
+        }
+        complaintAuditRecord.setSuperiorId(superiorId);
+        complaintFlowService.createFlow(complaintAuditRecord, 1, loginUserInfoVO.getUserId());
     }
 
     @Override
     @Transactional(rollbackFor = Exception.class)
     public void reportAudit(ComplaintReporAuditDTO complaintReporAuditDTO, LoginUserInfoVO loginUserInfoVO) {
-        Optional<SystemUser> systemUserByPhone = systemUserService.getSystemUserAdminByPhone(loginUserInfoVO.getPhone());
-        if (!systemUserByPhone.isPresent()) {
+
+        IdentityInformation identityInformation = identityInformationService.getCurrentIdentityInformation(loginUserInfoVO);
+
+        SystemUser systemUser = identityInformation.getSystemUser();
+        SystemUserLevel systemUserLevel = identityInformation.getSystemUserLevel();
+        if (identityInformation.getIdentity() != 2) {
             throw new ServiceException("无权审核");
         }
 
-        SystemUser systemUser = systemUserByPhone.get();
         Long superiorId = 0L;
-        switch (systemUser.getAccountLevel()) {
+        switch (systemUserLevel.getLevel()) {
             case 1:
                 superiorId = 510400L;//默认市级
                 break;
             case 2:
-                superiorId = Long.parseLong(systemUser.getDistrictsCode());
+                superiorId = Long.parseLong(systemUserLevel.getDistrictsCode());
                 break;
             case 3:
-                superiorId = Long.parseLong(systemUser.getStreetId());
+                superiorId = Long.parseLong(systemUserLevel.getStreetId());
                 break;
             case 4:
-                superiorId = systemUser.getCommunityId();
+                superiorId = systemUserLevel.getCommunityId();
                 break;
         }
 
@@ -672,18 +922,25 @@
                 .eq(ComplaintAuditRecord::getComplaintId, complaintReporAuditDTO.getId())
                 .eq(ComplaintAuditRecord::getAuditType, 2)
                 .eq(ComplaintAuditRecord::getLatestFlag, true)
-                .eq(ComplaintAuditRecord::getReportType, systemUser.getAccountLevel())
+                .eq(ComplaintAuditRecord::getReportType, systemUserLevel.getLevel())
                 .eq(ComplaintAuditRecord::getSuperiorId, superiorId)
                 .last("LIMIT 1").one();
         if (Objects.isNull(complaintAuditRecord)) {
             throw new ServiceException("上报申请记录不存在");
         }
+        complaintAuditRecord.setAuditorName(systemUser.getName());
+        complaintAuditRecord.setAuditorPhone(systemUser.getPhone());
+        complaintAuditRecord.setAuditTime(new Date());
         if (complaintReporAuditDTO.getAuditResult().equals(1)) {
             complaintAuditRecord.setAuditStatus(1);
             complaintAuditRecord.setAuditorId(loginUserInfoVO.getUserId());
             complaintAuditRecordService.updateById(complaintAuditRecord);
             //创建流程
-            complaintFlowService.createFlow(complaintAuditRecord ,0, loginUserInfoVO.getUserId());
+            ComplaintAuditRecord complaintAuditRecord2 = new ComplaintAuditRecord();
+            complaintAuditRecord2.setComplaintId(complaintReporAuditDTO.getId());
+            complaintAuditRecord2.setSuperiorId(complaintAuditRecord.getReporterId());
+            complaintAuditRecord2.setReportType(complaintAuditRecord.getReporterLevel());
+            complaintFlowService.createFlow(complaintAuditRecord2, 0, loginUserInfoVO.getUserId());
         } else {
             complaintAuditRecord.setRejectReason(complaintReporAuditDTO.getRejectReason());
             complaintAuditRecord.setAuditStatus(2);
@@ -696,35 +953,71 @@
     @Override
     @Transactional(rollbackFor = Exception.class)
     public void saveDelay(ComplaintDelayDTO dto, LoginUserInfoVO loginUserInfoVO) {
-        SystemUser systemUser = systemUserService.getSystemUserAdminByPhone(loginUserInfoVO.getPhone()).orElse(null);
+        IdentityInformation identityInformation = identityInformationService.getCurrentIdentityInformation(loginUserInfoVO);
+
+        SystemUser systemUser = identityInformation.getSystemUser();
+        SystemUserLevel systemUserLevel = identityInformation.getSystemUserLevel();
         Long superiorId;
         int reportType;
-        if (systemUser == null) {
-            superiorId = loginUserInfoVO.getCommunityId();
+        String departmentName = "";
+        String reporter = "";
+        if (identityInformation.getIdentity() == 1) {
+            PartyMember partyMember = partyMemberService.getPartyMemberByPhone(loginUserInfoVO.getPhone());
+            superiorId = partyMember.getCommunityId();
             if (Objects.isNull(superiorId)) {
                 throw new ServiceException("延期申请失败,请绑定社区");
             }
             reportType = ReportTypeEnum.COMMUNITY.getCode();
-        } else {
-            int accountLevel = systemUser.getAccountLevel(); // 改为基本类型
+            departmentName = partyMember.getDistricts() + "-" + partyMember.getStreet() + "-" + partyMember.getCommunity();
+            reporter = partyMember.getName();
+        } else if (identityInformation.getIdentity() == 2) {
+            int accountLevel = systemUserLevel.getLevel(); // 改为基本类型
             if (accountLevel == 1) {
                 throw new ServiceException("市级账号,无法延期申请!");
             }
             reportType = accountLevel - 1;
+            reporter = systemUser.getName();
 
             // 使用基本类型比较并补充默认分支
             if (accountLevel == ReportTypeEnum.COMMUNITY.getCode()) {
-                superiorId = Long.parseLong(systemUser.getStreetId());
+                superiorId = Long.parseLong(systemUserLevel.getStreetId());
             } else if (accountLevel == ReportTypeEnum.STREET.getCode()) {
-                superiorId = Long.parseLong(systemUser.getDistrictsCode());
+                superiorId = Long.parseLong(systemUserLevel.getDistrictsCode());
             } else if (accountLevel == ReportTypeEnum.DISTRICT.getCode()) {
                 superiorId = 510400L; // 攀枝花市
             } else if (accountLevel == ReportTypeEnum.PARTY.getCode()) {
-                superiorId = systemUser.getCommunityId();
+                superiorId = systemUserLevel.getCommunityId();
             } else {
                 // 处理未预期的账号等级
                 throw new ServiceException("未知的账号等级");
             }
+            //查询社区信息
+            switch (accountLevel) {
+                case 2:
+                    BcRegion region = bcRegionService.getDistrictByCode(systemUserLevel.getDistrictsCode().toString());
+                    if (Objects.nonNull(region)) {
+                        departmentName = region.getRegionName();
+                    }
+                    break;
+                case 3:
+                    ComStreet street = comStreetService.getById(systemUserLevel.getStreetId().toString());
+                    if (Objects.nonNull(street)) {
+                        BcRegion district = bcRegionService.getDistrictByCode(street.getAreaCode().toString());
+                        departmentName = Objects.nonNull(district) ? district.getRegionName() + "-" + street.getName() : street.getName();
+                    }
+                    break;
+                case 4:
+                    ComAct act = comActService.getById(systemUserLevel.getCommunityId());
+                    if (Objects.nonNull(act)) {
+                        ComStreet street2 = comStreetService.getById(systemUserLevel.getStreetId().toString());
+                        BcRegion district = bcRegionService.getDistrictByCode(act.getAreaCode());
+                        departmentName = Objects.nonNull(district) && Objects.nonNull(street2) ?
+                                district.getRegionName() + "-" + street2.getName() + "-" + act.getName() : act.getName();
+                    }
+                    break;
+            }
+        } else {
+            throw new ServiceException("无权申请");
         }
 
         // 清除最新记录
@@ -741,28 +1034,38 @@
         record1.setCreateTime(new Date(System.currentTimeMillis()));
         record1.setUpdateBy(loginUserInfoVO.getUserId());
         record1.setUpdateTime(new Date(System.currentTimeMillis()));
-        record1.setReporter(loginUserInfoVO.getNickName());
+        record1.setReporter(reporter);
         record1.setReportType(reportType);
         record1.setSuperiorId(superiorId);
         record1.setSort(count + 1);
         record1.setComment(dto.getComment());
+        record1.setDepartmentName(departmentName);
+        // 冗余申请人名称
+        record1.setApplyName(reporter);
+        record1.setApplyPhone(loginUserInfoVO.getPhone());
         complaintAuditRecordService.save(record1);
     }
 
 
     @Override
     public void delayAudit(ComplaintDelayAuditDTO dto, LoginUserInfoVO loginUserInfoVO) {
-        SystemUser systemUser = systemUserService.getSystemUserAdminByPhone(loginUserInfoVO.getPhone()).orElse(null);
-        int accountLevel = systemUser.getAccountLevel(); // 改为基本类型
+        IdentityInformation identityInformation = identityInformationService.getCurrentIdentityInformation(loginUserInfoVO);
+        SystemUser systemUser = identityInformation.getSystemUser();
+        SystemUserLevel systemUserLevel = identityInformation.getSystemUserLevel();
+        if (identityInformation.getIdentity() != 2) {
+            throw new ServiceException("无权审核");
+        }
+
+        int accountLevel = systemUserLevel.getLevel(); // 改为基本类型
         Long superiorId;
         // 使用基本类型比较并补充默认分支
         if (accountLevel == ReportTypeEnum.COMMUNITY.getCode()) {
-            superiorId = systemUser.getCommunityId();
+            superiorId = systemUserLevel.getCommunityId();
         } else if (accountLevel == ReportTypeEnum.STREET.getCode()) {
-            superiorId = Long.parseLong(systemUser.getStreetId());
+            superiorId = Long.parseLong(systemUserLevel.getStreetId());
         } else if (accountLevel == ReportTypeEnum.DISTRICT.getCode()) {
-            superiorId = Long.parseLong(systemUser.getDistrictsCode());
-        }  else if (accountLevel == ReportTypeEnum.CITY.getCode()) {
+            superiorId = Long.parseLong(systemUserLevel.getDistrictsCode());
+        } else if (accountLevel == ReportTypeEnum.CITY.getCode()) {
             superiorId = 510400L;
         } else {
             // 处理未预期的账号等级
@@ -774,7 +1077,7 @@
                 .eq(ComplaintAuditRecord::getAuditType, 1)
                 .eq(ComplaintAuditRecord::getLatestFlag, 1)
                 .eq(ComplaintAuditRecord::getAuditStatus, 0)
-                .ne(ComplaintAuditRecord::getSuperiorId, superiorId)
+                .eq(ComplaintAuditRecord::getSuperiorId, superiorId)
                 .eq(ComplaintAuditRecord::getReportType, accountLevel)
                 .eq(ComplaintAuditRecord::getComplaintId, dto.getComplaintId())
                 .last("LIMIT 1"));
@@ -783,18 +1086,26 @@
         if (Objects.isNull(complaintAuditRecord)) {
             throw new ServiceException("诉求延期申请不存在");
         }
+        complaintAuditRecord.setAuditorName(systemUser.getName());
+        complaintAuditRecord.setAuditorPhone(systemUser.getPhone());
+        complaintAuditRecord.setAuditTime(new Date());
         //审核通过后,设置诉求延期
         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);
         }
         //审核不通过
-        if(complaintAuditRecord.getAuditType().equals(1) && complaintAuditRecord.getAuditStatus().equals(0) && dto.getAuditResult().equals(2)){
+        if (complaintAuditRecord.getAuditType().equals(1) && complaintAuditRecord.getAuditStatus().equals(0) && dto.getAuditResult().equals(2)) {
+            Complaint complaint = getById(complaintAuditRecord.getComplaintId());
+            // 设置为正在办理
+            complaint.setStatus(0);
+            updateById(complaint);
+
             complaintAuditRecord.setRejectReason(dto.getRejectReason());
             complaintAuditRecord.setAuditStatus(2);
             complaintAuditRecord.setAuditorId(loginUserInfoVO.getUserId());
@@ -805,17 +1116,15 @@
     @Override
     public List<DispatchVO> getDispatchList(LoginUserInfoVO loginUserInfoVO) {
 
-        String phone = loginUserInfoVO.getPhone();
-        SystemUser adminUser = systemUserService.getOne(new LambdaQueryWrapper<SystemUser>()
-                .eq(SystemUser::getPhone, phone)
-                .eq(SystemUser::getIsAdmin, 1)
-                .ne(SystemUser::getStatus, 3)
-                .last("LIMIT 1"));
+        IdentityInformation identityInformation = identityInformationService.getCurrentIdentityInformation(loginUserInfoVO);
 
-        if (adminUser == null) {
+        SystemUser adminUser = identityInformation.getSystemUser();
+        SystemUserLevel systemUserLevel = identityInformation.getSystemUserLevel();
+
+        if (identityInformation.getIdentity() != 2) {
             throw new ServiceException("无权下派");
         }
-        int accountLevel = adminUser.getAccountLevel(); // 改为基本类型
+        int accountLevel = systemUserLevel.getLevel(); // 改为基本类型
       /*  if (accountLevel == 1) {
             throw new ServiceException("市级账号,无法上报!");
         }*/
@@ -823,8 +1132,8 @@
         // 使用基本类型比较并补充默认分支
         List<DispatchVO> dispatchVOList = new ArrayList<>();
         if (accountLevel == ReportTypeEnum.STREET.getCode()) {
-            String streetId = adminUser.getStreetId();
-            List<ComAct> list = comActService.list(new LambdaQueryWrapper<ComAct>().eq(ComAct::getStreetId, streetId).eq(ComAct::getState, 0));
+            String streetId = systemUserLevel.getStreetId();
+            List<ComAct> list = comActService.list(new LambdaQueryWrapper<ComAct>().eq(ComAct::getStreetId, streetId));
             for (ComAct comAct : list) {
                 DispatchVO dispatchVO = new DispatchVO();
                 dispatchVO.setId(comAct.getCommunityId().toString());
@@ -832,7 +1141,7 @@
                 dispatchVOList.add(dispatchVO);
             }
         } else if (accountLevel == ReportTypeEnum.DISTRICT.getCode()) {
-            String districtsCode = adminUser.getDistrictsCode();
+            String districtsCode = systemUserLevel.getDistrictsCode();
             List<ComStreet> list = comStreetService.list(new LambdaQueryWrapper<ComStreet>().eq(ComStreet::getAreaCode, districtsCode));
             for (ComStreet street : list) {
                 DispatchVO dispatchVO = new DispatchVO();
@@ -865,13 +1174,13 @@
      */
     @Override
     public Page<ComplaintTodoVO> getTodoList(BasePage basePage, LoginUserInfoVO loginUserInfo) {
-        Optional<SystemUser> systemUserByPhone = systemUserService.getSystemUserAdminByPhone(loginUserInfo.getPhone());
+        IdentityInformation identityInformation = identityInformationService.getCurrentIdentityInformation(loginUserInfo);
+        SystemUserLevel systemUserLevel = identityInformation.getSystemUserLevel();
         String targetId = "";
         int isSuperior = 0;
         //上级
-        if (systemUserByPhone.isPresent()) {
-            SystemUser systemUser = systemUserByPhone.get();
-            Integer accountLevel = systemUser.getAccountLevel();
+        if (identityInformation.getIdentity() == 2) {
+            Integer accountLevel = systemUserLevel.getLevel();
             switch (accountLevel) {
                 case 1:
                     //市级
@@ -879,15 +1188,15 @@
                     break;
                 case 2:
                     //区县级
-                    targetId = systemUser.getDistrictsCode();
+                    targetId = systemUserLevel.getDistrictsCode();
                     break;
                 case 3:
                     //街道
-                    targetId = systemUser.getStreetId().toString();
+                    targetId = systemUserLevel.getStreetId();
                     break;
                 case 4:
                     //社区
-                    targetId = systemUser.getCommunityId().toString();
+                    targetId = systemUserLevel.getCommunityId().toString();
                     break;
             }
             isSuperior = 1;
@@ -895,8 +1204,7 @@
             //党员
             targetId = loginUserInfo.getUserId().toString();
         }
-        Page<ComplaintTodoVO> page = baseMapper.getTodoList(new Page<>(basePage.getPageNum(), basePage.getPageSize()), targetId, isSuperior);
-        return page;
+        return baseMapper.getTodoList(new Page<>(basePage.getPageNum(), basePage.getPageSize()), targetId, isSuperior);
     }
 
     /**
@@ -922,7 +1230,7 @@
      */
     @Override
     public Page<ComplaintVO> pageList(MgtComplaintQuery query, SystemUserVo loginUserInfo) {
-        return baseMapper.pageList(new Page<>(query.getPageNum(), query.getPageSize()), query,loginUserInfo);
+        return baseMapper.pageList(new Page<>(query.getPageNum(), query.getPageSize()), query, loginUserInfo);
     }
 
     @Override
@@ -930,71 +1238,133 @@
         Complaint complaint = getById(id);
         ComplaintVO complaintVO = BeanUtil.copyProperties(complaint, ComplaintVO.class);
         //查询办理进度
-        List<ComplaintProgress> complaintProgresses = complaintProgressService.lambdaQuery().eq(ComplaintProgress::getComplaintId, id).orderByAsc(ComplaintProgress::getCreateTime).list();
+        List<ComplaintProgress> complaintProgresses = complaintProgressService.lambdaQuery()
+                .eq(ComplaintProgress::getComplaintId, id).orderByDesc(ComplaintProgress::getCreateTime).list();
         complaintVO.setComplaintProgresses(complaintProgresses);
         //查询诉求流转记录
-        List<ComplaintFlow> complaintFlows = complaintFlowService.lambdaQuery().eq(ComplaintFlow::getComplaintId, id).orderByAsc(ComplaintFlow::getCreateTime).list();
+        List<ComplaintFlow> complaintFlows = complaintFlowService.lambdaQuery()
+                .eq(ComplaintFlow::getComplaintId, id)
+                .orderByAsc(ComplaintFlow::getSort)
+                .list();
         complaintVO.setComplaintFlows(complaintFlows);
         //查询评价
         ComplaintComment comment = complaintCommentService.lambdaQuery().eq(ComplaintComment::getComplaintId, id).last("LIMIT 1").one();
         complaintVO.setComplaintComment(comment);
+        ArrayList<String> voiceFileList = new ArrayList<>();
+        String voiceFile = complaint.getVoiceFile();
+        if (StringUtils.isNotEmpty(voiceFile)) {
+            for (String file : voiceFile.split(",")) {
+                voiceFileList.add(file);
+            }
+        }
+
+        complaintVO.setVoiceFileList(voiceFileList);
         return complaintVO;
     }
 
     /**
      * 诉求列表导出
+     *
      * @param query
      * @param loginUserInfo
      */
     @Override
     public void export(MgtComplaintQuery query, SystemUserVo loginUserInfo) throws IOException {
-        List<ComplaintVO> list =  baseMapper.getList(query, loginUserInfo);
+        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)
+        EasyExcel.write(response.getOutputStream(), ComplaintExcel.class)
                 .sheet("诉求数据")
+                .registerWriteHandler(new AutoColumnWidthStrategy())
                 .doWrite(complaintExcels);
     }
 
     @Override
-    public void downloadFile(Long id,Integer type) throws IOException {
-        Complaint complaint = getById(id);
+    public String downloadFile(Long id, Integer type, SystemUserVo loginUserInfo) throws IOException {
+        Complaint complaint = baseMapper.getDetailBg(id);
         if (Objects.isNull(complaint)) {
             throw new ServiceException("该诉求不存在");
         }
-         //查询社区信息
-        BcRegion region = bcRegionService.getDistrictByCode(complaint.getDistrictsCode().toString());
-        ComStreet street = comStreetService.getById(complaint.getStreetId().toString());
-        ComAct act = comActService.getById(complaint.getCommunityId());
-        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){
+        //查询社区信息
+        Integer reportType = complaint.getReportType();
+        String community = "";
+        switch (reportType) {
             case 1:
-                fileName = "社区问题单";
+                community = "攀枝花市";
                 break;
             case 2:
-                fileName = "问题处理单";
-                if (Objects.nonNull(partyMember)) {
-                    community = community + "-" + partyMember.getServiceTarget();
+                BcRegion region = bcRegionService.getDistrictByCode(complaint.getDistrictsCode().toString());
+                if (Objects.nonNull(region)) {
+                    community = region.getRegionName();
                 }
                 break;
             case 3:
-                fileName = "协调通知单";
+                ComStreet street = comStreetService.getById(complaint.getStreetId().toString());
+                if (Objects.nonNull(street)) {
+                    BcRegion district = bcRegionService.getDistrictByCode(street.getAreaCode().toString());
+                    community = Objects.nonNull(district) ? district.getRegionName() + "-" + street.getName() : street.getName();
+                }
+                break;
+            case 4:
+                ComAct act = comActService.getById(complaint.getCommunityId());
+                if (Objects.nonNull(act)) {
+                    ComStreet street2 = comStreetService.getById(complaint.getStreetId().toString());
+                    BcRegion district = bcRegionService.getDistrictByCode(act.getAreaCode());
+                    community = Objects.nonNull(district) && Objects.nonNull(street2) ? district.getRegionName() + "-" + street2.getName() + "-" + act.getName() : act.getName();
+                }
+                break;
+            case 5:
+                ComAct act2 = comActService.getById(complaint.getCommunityId());
+                if (Objects.nonNull(act2)) {
+                    ComStreet street2 = comStreetService.getById(complaint.getStreetId().toString());
+                    BcRegion district = bcRegionService.getDistrictByCode(act2.getAreaCode());
+                    community = Objects.nonNull(district) && Objects.nonNull(street2) ? district.getRegionName() + "-" + street2.getName() + "-" + act2.getName() : act2.getName();
+                }
+                break;
+        }
+
+        PartyMember partyMember = null;
+        if (Objects.nonNull(complaint.getPartyMemberId())) {
+            partyMember = partyMemberService.getById(complaint.getPartyMemberId());
+        }
+        String fileName = "";
+        switch (type) {
+            case 1:
+                fileName = "community_question.docx";
+                break;
+            case 2:
+                fileName = "question_handle.docx";
+                if (Objects.nonNull(partyMember)) {
+                    if (StringUtil.isNotBlank(partyMember.getServiceTarget())) {
+                        community = community + "-" + partyMember.getServiceTarget();
+                    }
+                }
+                reportType = complaint.getCompletionUserLevel();
+                break;
+            case 3:
+                //如果上报或下派了,取当前操作人的层级
+                ComplaintAuditRecord record = complaintAuditRecordService.lambdaQuery().eq(ComplaintAuditRecord::getComplaintId, complaint.getId())
+                        .in(ComplaintAuditRecord::getAuditType, 2, 3)
+                        .eq(ComplaintAuditRecord::getAuditStatus, AuditStatusEnum.APPROVED.getCode())
+                        .eq(ComplaintAuditRecord::getLatestFlag, true)
+                        .last("LIMIT 1").one();
+                if (Objects.nonNull(record)) {
+                    reportType = record.getReportType();
+                }
+                fileName = "notice.docx";
                 break;
         }
         Map<String, Object> map = new HashMap<>();
         map.put("community", community);
         map.put("problemType", complaint.getProblemType());
         map.put("descriptionContent", complaint.getDescriptionContent());
-        map.put("reportType", ReportTypeEnum.fromCode(complaint.getReportType())); //TODO待修改
-        map.put("partyOrganization",Objects.nonNull(partyMember)? partyMember.getPartyOrganization() : "");
+        map.put("reportType", reportType == null ? "" : ReportTypeEnum.getDescriptionByCode(reportType));
+        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());
@@ -1003,61 +1373,359 @@
         StringBuilder sb = new StringBuilder();
         if (CollUtil.isNotEmpty(list)) {
             int rowNum = 1;
-            list.forEach(item->{
+            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()));
+        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");
-        response.setHeader("Content-disposition","attachment;filename=\""+fileNameEncode+".docx"+"\"");
-        String fileTemplateName = FileUtil.getPath() + "template/"+fileName+".docx";
-        XWPFTemplate.compile(fileTemplateName).render(map).writeAndClose(response.getOutputStream());
+        response.setHeader("Content-disposition", "attachment;filename=\"" + fileNameEncode + ".docx" + "\"");
+        InputStream resourceAsStream = this.getClass().getResourceAsStream("/template/" + fileName);
+        XWPFTemplate.compile(resourceAsStream).render(map).writeAndClose(response.getOutputStream());
+        return complaint.getName();
+    }
+
+
+//    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\\community_question.docx").render(map).writeToFile("F:\\DeskTop\\社区.docx");
+//        } catch (IOException e) {
+//            e.printStackTrace();
+//        }
+//    }
+
+
+    /**
+     * 获取超时未评价的数据
+     *
+     * @return
+     */
+    @Override
+    public List<Complaint> getTimeoutAndNotComment() {
+        return this.baseMapper.getTimeoutAndNotComment();
+    }
+
+    /**
+     *  修改办理进度
+     * @param dto
+     */
+    @Override
+    public void updateProgress(ComplaintProcessUpdateDto dto) {
+        complaintProgressService.update(new LambdaUpdateWrapper<ComplaintProgress>().eq(ComplaintProgress::getId, dto.getId())
+                .set(ComplaintProgress::getDescribe, dto.getDescribe()).set(ComplaintProgress::getImgUrl, dto.getImgUrl())
+                .set(ComplaintProgress::getVideo, dto.getVideo()));
+    }
+
+    /**
+     *  删除办理进度
+     * @param
+     */
+    @Override
+    public void delProgress(Long id) {
+        complaintProgressService.removeById(id);
+    }
+
+    @Override
+    public AnalyticStatisticsOneVo analyticStatisticsOne(AnalyticStatisticsQuery query, List<Complaint> complaints, SimpleDateFormat simpleDateFormat) {
+        String nowYearMonth;
+        String lastYearMonth;
+        int value = LocalDate.now().getMonth().getValue();
+        if (value < 10) {
+            nowYearMonth = LocalDate.now().getYear() + "-0" + LocalDate.now().getMonth().getValue();
+        } else {
+            nowYearMonth = LocalDate.now().getYear() + "-" + LocalDate.now().getMonth().getValue();
+        }
+        int value1 = LocalDate.now().minusMonths(1).getMonth().getValue();
+        if (value1 < 10) {
+            lastYearMonth = LocalDate.now().minusMonths(1).getYear() + "-0" + LocalDate.now().minusMonths(1).getMonth().getValue();
+        } else {
+            lastYearMonth = LocalDate.now().minusMonths(1).getYear() + "-" + LocalDate.now().minusMonths(1).getMonth().getValue();
+        }
+
+
+        // 要根据驳回表来改状态
+        List<Long> ids = complaints.stream().map(Complaint::getId).collect(Collectors.toList());
+        if (CollUtil.isEmpty(ids)) {
+            ids.add(0, -1L);
+        }
+        complaints = this.baseMapper.getStatusForList(ids);
+
+        AnalyticStatisticsOneVo vo = new AnalyticStatisticsOneVo();
+
+        // 诉求单量总计
+        vo.setAllTotal(complaints.size());
+        // 诉求单量本月
+        int thisMonthTotal = (int) complaints.stream().filter(e -> simpleDateFormat.format(e.getCreateTime()).contains(nowYearMonth)).count();
+        vo.setThisMonthTotal(thisMonthTotal);
+
+        // 诉求单量同比上月
+        int lastMonthTotal = (int) complaints.stream().filter(e -> simpleDateFormat.format(e.getCreateTime()).contains(lastYearMonth)).count();
+        vo.setLastMonthCompareTotal(thisMonthTotal - lastMonthTotal);
+
+        // 正在办理
+        int nowTransactTotal = (int) complaints.stream().filter(e -> e.getStatus() == 0).count();
+        vo.setNowTransactTotal(nowTransactTotal);
+
+        // 审核中
+        int auditTransactTotal = (int) complaints.stream().filter(e -> e.getStatus() == 5 || e.getStatus() == 7).count();
+        vo.setAuditTransactTotal(auditTransactTotal);
+
+        // 延期办理
+        int postponeTransactTotal = (int) complaints.stream().filter(e -> e.getStatus() == 1).count();
+        vo.setPostponeTransactTotal(postponeTransactTotal);
+
+        // 已办结
+        int completeTransactTotal = (int) complaints.stream().filter(e -> e.getStatus() == 3 || e.getStatus() == 8).count();
+        vo.setCompleteTransactTotal(completeTransactTotal);
+
+        // 超时办理总量
+        List<Complaint> overtimeComplaints = complaints.stream().filter(e -> e.getStatus() == 2).collect(Collectors.toList());
+        vo.setOvertimeTransactTotal(overtimeComplaints.size());
+
+        // 超时办理本月
+        int thisMonthOvertimeTransactTotal = (int) overtimeComplaints.stream().filter(e -> simpleDateFormat.format(e.getCreateTime()).contains(nowYearMonth)).count();
+        vo.setThisMonthOvertimeTransactTotal(thisMonthOvertimeTransactTotal);
+
+        // 超时办理同比上月
+        int lastMonthOvertimeTransactTotal = (int) overtimeComplaints.stream().filter(e -> simpleDateFormat.format(e.getCreateTime()).contains(lastYearMonth)).count();
+        vo.setLastMonthOvertimeTransactCompareTotal(thisMonthOvertimeTransactTotal - lastMonthOvertimeTransactTotal);
+
+        // 平均处理时长
+        if (complaints.size() > 0) {
+            double averageDay = complaints.stream().mapToDouble(v -> v.getHandlingDay() == null ? 0 : v.getHandlingDay()).average().getAsDouble();
+            averageDay = BigDecimal.valueOf(averageDay).setScale(2, RoundingMode.HALF_UP).doubleValue();
+            vo.setAverageTime(averageDay);
+
+            List<Complaint> thisMonthAverageTimeComplaints = complaints.stream().filter(e -> simpleDateFormat.format(e.getCreateTime()).contains(nowYearMonth)).collect(Collectors.toList());
+            if (thisMonthAverageTimeComplaints.size() > 0) {
+                double thisMonthAverageTime = thisMonthAverageTimeComplaints.stream().mapToDouble(v -> v.getHandlingDay() == null ? 0 : v.getHandlingDay()).average().getAsDouble();
+                thisMonthAverageTime = BigDecimal.valueOf(thisMonthAverageTime).setScale(2, RoundingMode.HALF_UP).doubleValue();
+                vo.setThisMonthAverageTime(thisMonthAverageTime);
+            }
+            List<Complaint> lastMonthAverageTimeComplaints = complaints.stream().filter(e -> simpleDateFormat.format(e.getCreateTime()).contains(lastYearMonth)).collect(Collectors.toList());
+            if (lastMonthAverageTimeComplaints.size() > 0) {
+                double lastMonthAverageTime = lastMonthAverageTimeComplaints.stream().mapToDouble(v -> v.getHandlingDay() == null ? 0 : v.getHandlingDay()).average().getAsDouble();
+                BigDecimal lastMonthAverageTime1 = BigDecimal.valueOf(lastMonthAverageTime).setScale(2, RoundingMode.HALF_UP);
+
+                vo.setLastMonthCompareAverageTime( new BigDecimal(vo.getThisMonthAverageTime()).subtract(lastMonthAverageTime1).setScale(2,RoundingMode.HALF_UP).doubleValue());
+            }else {
+                vo.setLastMonthCompareAverageTime( new BigDecimal(vo.getThisMonthAverageTime()).setScale(2,RoundingMode.HALF_UP).doubleValue());
+
+            }
+
+        }
+        // 获取评价了的诉求
+        List<Complaint> commentRateComplaints = complaints.stream().filter(e -> e.getCommentRate() != null).collect(Collectors.toList());
+        long count = commentRateComplaints.stream().filter(e -> e.getCommentRate() > 1).count();
+        int size = commentRateComplaints.size();
+        if (size > 0) {
+            BigDecimal multiply = BigDecimal.valueOf(count).divide(new BigDecimal(size), 2, BigDecimal.ROUND_HALF_UP).multiply(new BigDecimal("100"));
+            vo.setSatisfactionRate(multiply.doubleValue());
+
+            List<Complaint> nowMonth = commentRateComplaints.stream().filter(e -> simpleDateFormat.format(e.getCreateTime()).contains(nowYearMonth)).collect(Collectors.toList());
+            // 当月满意
+            long count1 = nowMonth.stream().filter(e -> e.getCommentRate() > 1).count();
+            // 当月的评价数
+            int nowMonthSize = nowMonth.size();
+            if (nowMonthSize > 0) {
+                BigDecimal multiply1 = BigDecimal.valueOf(count1).divide(new BigDecimal(nowMonthSize), 2, BigDecimal.ROUND_HALF_UP).multiply(new BigDecimal("100"));
+                vo.setThisMonthSatisfactionRate(multiply1.doubleValue());
+            }
+
+            List<Complaint> lastMonth = commentRateComplaints.stream().filter(e -> simpleDateFormat.format(e.getCreateTime()).contains(lastYearMonth)).collect(Collectors.toList());
+            // 当月满意
+            long count2 = lastMonth.stream().filter(e -> e.getCommentRate() > 1).count();
+            // 当月的评价数
+            int lastMonthSize = lastMonth.size();
+            if (lastMonthSize > 0) {
+                BigDecimal multiply2 = BigDecimal.valueOf(count2).divide(new BigDecimal(lastMonthSize), 2, BigDecimal.ROUND_HALF_UP).multiply(new BigDecimal("100"));
+                vo.setLastMonthCompareSatisfactionRate(vo.getThisMonthSatisfactionRate() - multiply2.doubleValue());
+            }else {
+                vo.setLastMonthCompareSatisfactionRate(vo.getThisMonthSatisfactionRate());
+            }
+        }
+        return vo;
     }
 
 
     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();
-        }
+        String time = "2022-02-02 - 2023-02-02";
+        String[] split = time.split(" - ");
+        System.out.println(split[0]);
     }
-    
-    
-    /**
-     * 获取超时未评价的数据
-     * @return
-     */
-    @Override
-	public List<Complaint> getTimeoutAndNotComment() {
-		return this.baseMapper.getTimeoutAndNotComment();
-	}
 
+    @Override
+    public List<AnalyticStatisticsTwoVo> analyticStatisticsTwo(String time, List<Complaint> complaints, SimpleDateFormat simpleDateFormat) {
+        ArrayList<AnalyticStatisticsTwoVo> list = new ArrayList<>();
+        try {
+            if (StringUtils.isNotEmpty(time)) {
+                String[] split = time.split(" - ");
+                Date parse = simpleDateFormat.parse(split[0] + " 00:00:00");
+                Date parse1 = simpleDateFormat.parse(split[1] + " 23:59:59");
+                complaints = complaints.stream().filter(e -> e.getCreateTime().getTime() <= parse1.getTime() && e.getCreateTime().getTime() >= parse.getTime()).collect(Collectors.toList());
+                int day = DateUtils.getDay(parse, parse1);
+
+                if (day > 30) {
+                    throw new ServiceException("时间范围不能超过30天");
+                }
+
+                for (int i = 0; i <= day; i++) {
+                    AnalyticStatisticsTwoVo analyticStatisticsTwoVo = new AnalyticStatisticsTwoVo();
+                    if (i == 0) {
+                        List<Complaint> collect = complaints.stream().filter(e -> simpleDateFormat.format(e.getCreateTime()).contains(split[0])).collect(Collectors.toList());
+                        analyticStatisticsTwoVo.setTime(split[0]);
+                        analyticStatisticsTwoVo.setAllTotal(collect.size());
+                        int count = (int) collect.stream().filter(e -> e.getStatus() == 3).count();
+                        analyticStatisticsTwoVo.setCompleteTotal(count);
+                        list.add(analyticStatisticsTwoVo);
+                    } else {
+                        String nextDay = DateUtils.getNextDay(parse, i);
+                        List<Complaint> collect = complaints.stream().filter(e -> simpleDateFormat.format(e.getCreateTime()).contains(nextDay)).collect(Collectors.toList());
+                        analyticStatisticsTwoVo.setTime(nextDay);
+                        analyticStatisticsTwoVo.setAllTotal(collect.size());
+                        int count = (int) collect.stream().filter(e -> e.getStatus() == 3).count();
+                        analyticStatisticsTwoVo.setCompleteTotal(count);
+                        list.add(analyticStatisticsTwoVo);
+                    }
+                }
+
+            } else {
+                time = DateUtils.getBeforeDay(6) + " 00:00:00";
+                Date parse = simpleDateFormat.parse(time);
+                // 近7天数据
+                complaints = complaints.stream().filter(e -> e.getCreateTime().getTime() <= new Date().getTime() && e.getCreateTime().getTime() >= parse.getTime()).collect(Collectors.toList());
+
+                for (int i = 6; i >= 0; i--) {
+                    // 获取前7天的时间
+                    String day = DateUtils.getBeforeDay(i);
+                    List<Complaint> complaintList = complaints.stream().filter(e -> simpleDateFormat.format(e.getCreateTime()).contains(day)).collect(Collectors.toList());
+                    AnalyticStatisticsTwoVo analyticStatisticsTwoVo = new AnalyticStatisticsTwoVo();
+                    analyticStatisticsTwoVo.setTime(day);
+                    analyticStatisticsTwoVo.setAllTotal(complaintList.size());
+                    int count = (int) complaintList.stream().filter(e -> e.getStatus() == 3).count();
+                    analyticStatisticsTwoVo.setCompleteTotal(count);
+                    list.add(analyticStatisticsTwoVo);
+                }
+
+            }
+        } catch (ParseException e) {
+            throw new RuntimeException(e);
+        }
+        return list;
+    }
+
+    @Override
+    public List<AnalyticStatisticsThreeVo> analyticStatisticsThree(Integer rank, List<Complaint> complaints) {
+        Map<String, List<Complaint>> groupedByProblemType = complaints.stream()
+                .collect(Collectors.groupingBy(Complaint::getProblemType));
+        List<AnalyticStatisticsThreeVo> analyticStatisticsThreeVos = groupedByProblemType.entrySet().stream()
+                .map(entry -> {
+                    AnalyticStatisticsThreeVo analyticStatisticsThreeVo = new AnalyticStatisticsThreeVo();
+                    analyticStatisticsThreeVo.setName(entry.getKey());
+                    analyticStatisticsThreeVo.setAllTotal(entry.getValue().size());
+                    return analyticStatisticsThreeVo;
+                })
+                .collect(Collectors.toList());
+        analyticStatisticsThreeVos = analyticStatisticsThreeVos.stream().sorted(Comparator.comparing(AnalyticStatisticsThreeVo::getAllTotal).reversed()).collect(Collectors.toList());
+        if (rank == null) {
+            return analyticStatisticsThreeVos;
+        } else if (rank == 5) {
+            return analyticStatisticsThreeVos.stream().limit(5).collect(Collectors.toList());
+        } else if (rank == 10) {
+            return analyticStatisticsThreeVos.stream().limit(10).collect(Collectors.toList());
+        }
+        return Collections.emptyList();
+    }
+
+    @Override
+    public AnalyticStatisticsFourVo analyticStatisticsFour(List<Complaint> complaints) {
+        // 只计算评分了的
+        complaints = complaints.stream().filter(e -> e.getCommentRate() != null).collect(Collectors.toList());
+        AnalyticStatisticsFourVo vo = new AnalyticStatisticsFourVo();
+        // 0:不满意 1:一般 2:满意 3:非常满意
+        long count = complaints.stream().filter(e -> e.getCommentRate() != null && e.getCommentRate() == 0).count();
+        vo.setDissatisfactionNum((int) count);
+        long count1 = complaints.stream().filter(e -> e.getCommentRate() != null && e.getCommentRate() == 1).count();
+        vo.setGeneralSatisfactionNum((int) count1);
+        long count2 = complaints.stream().filter(e -> e.getCommentRate() != null && e.getCommentRate() == 2).count();
+        vo.setSatisfactionRateNum((int) count2);
+        long count3 = complaints.stream().filter(e -> e.getCommentRate() != null && e.getCommentRate() == 3).count();
+        vo.setGreatSatisfactionNum((int) count3);
+        if (complaints.size() > 0) {
+            vo.setDissatisfactionRate(BigDecimal.valueOf(count).divide(BigDecimal.valueOf(complaints.size()),4,RoundingMode.HALF_UP).multiply(new BigDecimal("100")).setScale(2,RoundingMode.HALF_UP).doubleValue());
+            vo.setGeneralSatisfactionRate(BigDecimal.valueOf(count1).divide(BigDecimal.valueOf(complaints.size()),4,RoundingMode.HALF_UP).multiply(new BigDecimal("100")).setScale(2,RoundingMode.HALF_UP).doubleValue());
+            vo.setSatisfactionRate(BigDecimal.valueOf(count2).divide(BigDecimal.valueOf(complaints.size()),4,RoundingMode.HALF_UP).multiply(new BigDecimal("100")).setScale(2,RoundingMode.HALF_UP).doubleValue());
+            vo.setGreatSatisfactionRate(BigDecimal.valueOf(count3).divide(BigDecimal.valueOf(complaints.size()),4,RoundingMode.HALF_UP).multiply(new BigDecimal("100")).setScale(2,RoundingMode.HALF_UP).doubleValue());
+        }
+        return vo;
+    }
+
+    @Override
+    public List<Complaint> queryCompliantList(AppStaticsQuery query, LoginUserInfoVO loginUserInfo) {
+        IdentityInformation identityInformation = identityInformationService.getIdentityInformation(loginUserInfo);
+        Integer identity = identityInformation.getIdentity();
+        PartyMember partyMember = identityInformation.getPartyMember();
+        SystemUserLevel systemUserLevel = identityInformation.getSystemUserLevel();
+        Long targetId = null;
+        Integer accountLevel = 5;
+        //党员,查询该党员
+        if (identity.equals(1)) {
+            targetId = partyMember.getId();
+        } else if (identity.equals(2)) {
+            //上级
+            if (Objects.nonNull(query.getTier()) && query.getTier().equals(-1)) {
+                accountLevel = systemUserLevel.getLevel();
+                switch (systemUserLevel.getLevel()) {
+                    case 1:
+                        //市级
+                        targetId = 510400L;
+                        break;
+                    case 2:
+                        //区县级
+                        targetId = Long.valueOf(systemUserLevel.getDistrictsCode());
+                        break;
+                    case 3:
+                        //街道
+                        targetId = Long.valueOf(systemUserLevel.getStreetId());
+                        break;
+                    case 4:
+                        //社区
+                        targetId = systemUserLevel.getCommunityId();
+                        break;
+                }
+            } else {
+                targetId = Long.valueOf(query.getAreaId());
+                accountLevel = query.getTier();
+            }
+        }
+        return baseMapper.queryCompliantList(targetId, accountLevel, loginUserInfo, query);
+    }
 }
 

--
Gitblit v1.7.1