From f0a9a41697a8568e8b3bd3436c450e68b3298916 Mon Sep 17 00:00:00 2001
From: Pu Zhibing <393733352@qq.com>
Date: 星期四, 27 二月 2025 11:39:18 +0800
Subject: [PATCH] 修改日志

---
 springcloud_k8s_panzhihuazhihuishequ/service_sangeshenbian/src/main/java/com/panzhihua/sangeshenbian/service/impl/ComplaintServiceImpl.java |  310 ++++++++++++++++++++++++++++++++++++++++++++++-----
 1 files changed, 277 insertions(+), 33 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 2232872..0819eb4 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
@@ -1,27 +1,44 @@
 package com.panzhihua.sangeshenbian.service.impl;
 
+import cn.hutool.core.bean.BeanUtil;
 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.panzhihua.common.exceptions.ServiceException;
 import com.panzhihua.common.model.vos.LoginUserInfoVO;
+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.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.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.service.*;
 import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
 import com.panzhihua.sangeshenbian.model.vo.ComplaintVO;
+import com.panzhihua.sangeshenbian.service.ISystemUserService;
 import lombok.RequiredArgsConstructor;
+import org.springframework.context.annotation.Lazy;
 import org.springframework.stereotype.Service;
+import org.springframework.transaction.annotation.Transactional;
 
 import java.text.SimpleDateFormat;
 import java.util.ArrayList;
 import java.util.Date;
 import java.util.List;
+import java.util.Objects;
+import java.util.Optional;
 
 import static cn.hutool.core.util.ObjectUtil.isNull;
 
@@ -34,15 +51,17 @@
  * @since 2025-02-22
  */
 @Service
-@RequiredArgsConstructor
+@RequiredArgsConstructor(onConstructor_ = {@Lazy})
 public class ComplaintServiceImpl extends ServiceImpl<ComplaintMapper, Complaint> implements IComplaintService {
-
-    private final IComplaintAuditRecordService complaintAuditRecordService;
     private final ISystemUserService systemUserService;
     private final IComplaintFlowService complaintFlowService;
+    private final IComplaintProgressService complaintProgressService;
+
+    private final IComplaintAuditRecordService complaintAuditRecordService;
     private final IBcRegionService bcRegionService;
     private final IComStreetService comStreetService;
     private final IComActService comActService;
+    private final IWorkOrderItemConfigService workOrderItemConfigService;
 
     @Override
     public void saveComplaint(Complaint complaint, Long userId) {
@@ -75,67 +94,152 @@
         complaint.setCreateBy(userId);
         complaint.setUpdateBy(userId);
         complaint.setUpdateTime(new Date(System.currentTimeMillis()));
-
+        //查询系统配置诉求处理期限,设置截止日期
+        WorkOrderItemConfig config = workOrderItemConfigService.lambdaQuery().orderByDesc(WorkOrderItemConfig::getId).last("LIMIT 1").one();
+        if (Objects.isNull(config)){
+            throw new ServiceException("工单事项未配置,请联系管理员");
+        }
+        complaint.setClosingTime(new Date(System.currentTimeMillis() + config.getDemandProcessingTime() * 24 * 60 * 60 * 1000));
         // 保存诉求记录
         save(complaint);
     }
 
     /**
      * @param query
+     * @param loginUserInfoVO
      * @return
      */
     @Override
-    public Page<ComplaintVO> complaintList(ComplaintQuery query) {
-        //判断当前登录用户级别,查询对应工单
+    public Page<ComplaintVO> complaintList(ComplaintQuery query, LoginUserInfoVO loginUserInfoVO) {
         Page<ComplaintVO> page = new Page<>(query.getPageNum(), query.getPageSize());
+        //判断当前登录用户级别,查询对应工单
+        Optional<SystemUser> systemUserByPhone = systemUserService.getSystemUserByPhone(loginUserInfoVO.getPhone());
+        String targetId = "";
+        int isSuperior = 0;
+        //上级
+        if (systemUserByPhone.isPresent()) {
+            SystemUser systemUser = systemUserByPhone.get();
+            Integer accountLevel = systemUser.getAccountLevel();
+            switch (accountLevel) {
+                case 1:
+                    //市级
+                    targetId = "510400";
+                    break;
+                case 2:
+                    //区县级
+                    targetId = systemUser.getDistrictsCode();
+                    break;
+                case 3:
+                    //街道
+                    targetId = systemUser.getStreetId().toString();
+                    break;
+                case 4:
+                    //社区
+                    targetId = systemUser.getCommunityId().toString();
+                    break;
+            }
+            isSuperior = 1;
+        } else {
+        //党员
+            targetId = loginUserInfoVO.getUserId().toString();
+        }
+        //查询对应诉求
+        query.setUserId(loginUserInfoVO.getUserId());//当前登录用户id
+        page = baseMapper.selectComplaintPage(page, query, targetId,isSuperior);
         return page;
+    }
+
+    /**
+     * 工单详情
+     * @param id
+     * @return
+     */
+    @Override
+    public ComplaintVO detail(Long id) {
+        ComplaintVO detail = baseMapper.getDetail(id);
+        if (detail.getStatus().equals(0)) {
+            List<ComplaintFlow> list = complaintFlowService.lambdaQuery().eq(ComplaintFlow::getComplaintId, id).orderByAsc(ComplaintFlow::getCreateTime).list();
+            detail.setComplaintFlows(list);
+        }
+        //查询办理进度
+        List<ComplaintProgress> list = complaintProgressService.lambdaQuery().eq(ComplaintProgress::getComplaintId, id)
+                .orderByAsc(ComplaintProgress::getCreateTime).list();
+        detail.setComplaintProgresses(list);
+        return detail;
     }
 
     /**
      * 办理进度录入
      *
      * @param dto
+     * @param loginUserInfoVO
      */
     @Override
-    public void saveProcess(ComplaintProcessDTO dto) {
-
+    public void saveProcess(ComplaintProcessDTO dto, LoginUserInfoVO loginUserInfoVO) {
+        ComplaintProgress complaintProgress = BeanUtil.copyProperties(dto, ComplaintProgress.class);
+        complaintProgress.setCreateTime(new Date());
+        complaintProgress.setCreateBy(loginUserInfoVO.getUserId());
+        complaintProgress.setCreateByName(loginUserInfoVO.getNickName());
+        complaintProgressService.save(complaintProgress);
     }
 
     /**
      * 办理结果录入
      *
      * @param dto
+     * @param loginUserInfoVO
      */
     @Override
-    public void saveResult(ComplaintCompletionDTO dto) {
-
+    public void saveResult(ComplaintCompletionDTO dto, LoginUserInfoVO loginUserInfoVO) {
+        Complaint complaint = BeanUtil.copyProperties(dto, Complaint.class);
+        complaint.setUpdateTime(new Date());
+        complaint.setCompletionUserId(loginUserInfoVO.getUserId());
+        complaint.setCompletionUsername(loginUserInfoVO.getNickName());
+        complaint.setCompletionUserPhone(loginUserInfoVO.getPhone());
+        complaint.setCompletionTime(new Date());
+        this.updateById(complaint);
+    }
+    /**
+     * 办理进度列表
+     * @param complaintId
+     * @return
+     */
+    @Override
+    public List<ComplaintProgress> progress(Long complaintId) {
+        //查询办理进度
+        return complaintProgressService.lambdaQuery().eq(ComplaintProgress::getComplaintId, complaintId)
+                .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)
-                .eq(SystemUser::getStatus, 3)
+                .ne(SystemUser::getStatus, 3)
                 .last("LIMIT 1"));
 
         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(); // 改为基本类型
             if (accountLevel == 1) {
                 throw new ServiceException("市级账号,无法上报!");
             }
-            reportType = accountLevel + 1;
+            reportType = accountLevel - 1;
 
             // 使用基本类型比较并补充默认分支
             if (accountLevel == ReportTypeEnum.COMMUNITY.getCode()) {
-                superiorId = Long.parseLong(adminUser.getStreetCode());
+                superiorId = Long.parseLong(adminUser.getStreetId());
             } else if (accountLevel == ReportTypeEnum.STREET.getCode()) {
                 superiorId = Long.parseLong(adminUser.getDistrictsCode());
             } else if (accountLevel == ReportTypeEnum.DISTRICT.getCode()) {
@@ -157,35 +261,35 @@
                 .set(ComplaintAuditRecord::getLatestFlag,false));
 
         // 添加审核记录
-        complaintAuditRecordService.createComplaintAuditRecord(dto.getComplaintId(), 2, dto.getComment(), loginUserInfoVO.getUserId());
+        complaintAuditRecordService.createComplaintAuditRecord(dto.getComplaintId(), 2, dto.getComment(), loginUserInfoVO,adminUser);
     }
 
     @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)
-                .eq(SystemUser::getStatus, 3)
+                .ne(SystemUser::getStatus, 3)
                 .last("LIMIT 1"));
 
         if (adminUser == null) {
             throw new ServiceException("无权下派");
         }
 
+
         long superiorId;
-        int reportType;
         int accountLevel = adminUser.getAccountLevel(); // 改为基本类型
-        if (accountLevel == 1) {
-            throw new ServiceException("市级账号,无法上报!");
+        if (accountLevel == 4) {
+            throw new ServiceException("社区账号,无法下派!");
         }
-        reportType = accountLevel - 1;
 
         // 使用基本类型比较并补充默认分支
         if (accountLevel == ReportTypeEnum.STREET.getCode()) {
-            superiorId = Long.parseLong(adminUser.getCommunityCode());
+            superiorId = adminUser.getCommunityId().longValue();
         } else if (accountLevel == ReportTypeEnum.DISTRICT.getCode()) {
-            superiorId = Long.parseLong(adminUser.getStreetCode());
+            superiorId = Long.parseLong(adminUser.getStreetId());
         } else if (accountLevel == ReportTypeEnum.CITY.getCode()) {
             superiorId = Long.parseLong(adminUser.getDistrictsCode());
         } else {
@@ -193,40 +297,127 @@
             throw new ServiceException("未知的账号等级");
         }
 
+        Long superiorOrgId;
         Complaint complaint = getById(dto.getComplaintId());
-        complaint.setReportType(reportType);
+        superiorOrgId = complaint.getSuperiorId();
+        complaint.setReportType(accountLevel + 1);
         complaint.setSuperiorId(superiorId);
         updateById(complaint);
 
         // 添加流转记录
-        complaintFlowService.createFlow(dto.getComplaintId(), 1, loginUserInfoVO.getUserId());
+        complaintFlowService.createFlow(dto.getComplaintId(), superiorOrgId, accountLevel, 1, loginUserInfoVO.getUserId());
     }
 
     @Override
+    @Transactional(rollbackFor = Exception.class)
     public void reportAudit(ComplaintReporAuditDTO complaintReporAuditDTO, LoginUserInfoVO loginUserInfoVO) {
-        complaintAuditRecordService.audit(complaintReporAuditDTO.getId(), loginUserInfoVO.getUserId(),
+        Optional<SystemUser> systemUserByPhone = systemUserService.getSystemUserByPhone(loginUserInfoVO.getPhone());
+        if (!systemUserByPhone.isPresent()) {
+            throw new ServiceException("无权审核");
+        }
+        //查询上报审核记录
+        ComplaintAuditRecord complaintAuditRecord = complaintAuditRecordService.lambdaQuery().eq(ComplaintAuditRecord::getComplaintId, complaintReporAuditDTO.getId())
+                .eq(ComplaintAuditRecord::getAuditType, 2)
+                .eq(ComplaintAuditRecord::getLatestFlag, true)
+                .last("LIMIT 1").one();
+        if (Objects.isNull(complaintAuditRecord)) {
+            throw new ServiceException("上报申请记录不存在");
+        }
+        //查询待审核诉求
+        complaintAuditRecordService.audit(complaintAuditRecord,  loginUserInfoVO.getUserId(),
                 complaintReporAuditDTO.getAuditResult(), complaintReporAuditDTO.getRejectReason());
 
         // 添加流转记录
-        ComplaintAuditRecord complaintAuditRecord = complaintAuditRecordService.getById(complaintReporAuditDTO.getId());
-        complaintFlowService.createFlow(complaintAuditRecord.getComplaintId(), 0, loginUserInfoVO.getUserId());
+        Complaint complaint = getById(complaintAuditRecord.getComplaintId());
+
+        Long superiorId = null;
+        if (Objects.nonNull(complaint)) {
+            superiorId = complaint.getCreateBy();
+            if (Objects.nonNull(complaint.getSuperiorId())) {
+                superiorId = complaint.getSuperiorId();
+            }
+            complaintFlowService.createFlow(complaintAuditRecord.getComplaintId(), superiorId,complaint.getReportType(),0, loginUserInfoVO.getUserId());
+        }
+        //审核通过后,将诉求转移给上级
+        if (complaintAuditRecord.getAuditType().equals(2) && complaintAuditRecord.getAuditStatus().equals(1)){
+            SystemUser systemUser = systemUserByPhone.get();
+                switch (systemUser.getAccountLevel()) {
+                    case 1:
+                        superiorId = 510400L;//默认市级
+                        break;
+                    case 2:
+                        superiorId = Long.parseLong(systemUser.getDistrictsCode());
+                        break;
+                    case 3:
+                        superiorId = Long.parseLong(systemUser.getStreetId());
+                        break;
+                    case 4:
+                        superiorId = systemUser.getCommunityId();
+                        break;
+                }
+            }
+            complaint.setSuperiorId(superiorId);
+            updateById(complaint );
     }
 
 
     @Override
+    @Transactional(rollbackFor = Exception.class)
     public void saveDelay(ComplaintDelayDTO dto, LoginUserInfoVO loginUserInfoVO) {
         // 标记最新
         complaintAuditRecordService.update(new LambdaUpdateWrapper<ComplaintAuditRecord>()
                 .eq(ComplaintAuditRecord::getComplaintId, dto.getComplaintId())
                 .set(ComplaintAuditRecord::getLatestFlag,false));
+        SystemUser systemUser = systemUserService.getSystemUserByPhone(loginUserInfoVO.getPhone()).orElse(null);
+        Long superiorId;
+        int reportType;
+        if (systemUser == null) {
+            superiorId = loginUserInfoVO.getCommunityId();
+            if (Objects.isNull(superiorId)){
+                throw new ServiceException("上报失败,请绑定社区");
+            }
+            reportType = ReportTypeEnum.COMMUNITY.getCode();
+        } else {
+            int accountLevel = systemUser.getAccountLevel(); // 改为基本类型
+            if (accountLevel == 1) {
+                throw new ServiceException("市级账号,无法上报!");
+            }
+            reportType = accountLevel + 1;
+
+            // 使用基本类型比较并补充默认分支
+            if (accountLevel == ReportTypeEnum.COMMUNITY.getCode()) {
+                superiorId = Long.parseLong(systemUser.getStreetId());
+            } else if (accountLevel == ReportTypeEnum.STREET.getCode()) {
+                superiorId = Long.parseLong(systemUser.getDistrictsCode());
+            } else if (accountLevel == ReportTypeEnum.DISTRICT.getCode()) {
+                superiorId = 510400L; // 攀枝花市
+            } else {
+                // 处理未预期的账号等级
+                throw new ServiceException("未知的账号等级");
+            }
+        }
+
+        Complaint complaint = getById(dto.getComplaintId());
+        complaint.setReportType(reportType);
+        complaint.setSuperiorId(superiorId);
+        updateById(complaint);
         // 添加审核记录
-        complaintAuditRecordService.createComplaintAuditRecord(dto.getComplaintId(), 1, dto.getComment(), loginUserInfoVO.getUserId());
+        complaintAuditRecordService.createComplaintAuditRecord(dto.getComplaintId(), 1, dto.getComment(), loginUserInfoVO, systemUser);
     }
 
 
     @Override
     public void delayAudit(ComplaintDelayAuditDTO complaintDelayAuditDTO, LoginUserInfoVO loginUserInfoVO) {
-        complaintAuditRecordService.audit(complaintDelayAuditDTO.getId(), loginUserInfoVO.getUserId(),
+        //查询待审核诉求
+        ComplaintAuditRecord complaintAuditRecord = complaintAuditRecordService.lambdaQuery().eq(ComplaintAuditRecord::getComplaintId, complaintDelayAuditDTO.getComplaintId())
+                .eq(ComplaintAuditRecord::getAuditType, 1)
+                .eq(ComplaintAuditRecord::getAuditStatus, 0)
+                .eq(ComplaintAuditRecord::getLatestFlag, true)
+                .last("LIMIT 1").one();
+        if (Objects.isNull(complaintAuditRecord)) {
+            throw new ServiceException("诉求延期申请不存在");
+        }
+        complaintAuditRecordService.audit(complaintAuditRecord, loginUserInfoVO.getUserId(),
                 complaintDelayAuditDTO.getAuditResult(), complaintDelayAuditDTO.getRejectReason());
     }
 
@@ -237,16 +428,16 @@
         SystemUser adminUser = systemUserService.getOne(new LambdaQueryWrapper<SystemUser>()
                 .eq(SystemUser::getPhone, phone)
                 .eq(SystemUser::getIsAdmin, 1)
-                .eq(SystemUser::getStatus, 3)
+                .ne(SystemUser::getStatus, 3)
                 .last("LIMIT 1"));
 
         if (adminUser == null) {
             throw new ServiceException("无权下派");
         }
         int accountLevel = adminUser.getAccountLevel(); // 改为基本类型
-        if (accountLevel == 1) {
+      /*  if (accountLevel == 1) {
             throw new ServiceException("市级账号,无法上报!");
-        }
+        }*/
 
         // 使用基本类型比较并补充默认分支
         List<DispatchVO> dispatchVOList = new ArrayList<>();
@@ -268,7 +459,7 @@
             }
         } else if (accountLevel == ReportTypeEnum.CITY.getCode()) {
             List<BcRegion> list = bcRegionService.list(new LambdaQueryWrapper<BcRegion>()
-                    .eq(BcRegion::getHierarchyOrder, 3));
+                    .eq(BcRegion::getHierarchyOrder, 3).eq(BcRegion::getParentId, 510400));//获取攀枝花市下的区县
             for (BcRegion region : list) {
                 DispatchVO dispatchVO = new DispatchVO();
                 dispatchVO.setId(Long.valueOf(region.getRegionCode()));
@@ -281,5 +472,58 @@
         }
         return dispatchVOList;
     }
+    /**
+     * 获取待办诉求
+     * @param basePage
+     * @param loginUserInfo
+     * @return
+     */
+    @Override
+    public Page<ComplaintTodoVO> getTodoList(BasePage basePage, LoginUserInfoVO loginUserInfo) {
+        Optional<SystemUser> systemUserByPhone = systemUserService.getSystemUserByPhone(loginUserInfo.getPhone());
+        String targetId = "";
+        int isSuperior = 0;
+        //上级
+        if (systemUserByPhone.isPresent()) {
+            SystemUser systemUser = systemUserByPhone.get();
+            Integer accountLevel = systemUser.getAccountLevel();
+            switch (accountLevel) {
+                case 1:
+                    //市级
+                    targetId = "510400";
+                    break;
+                case 2:
+                    //区县级
+                    targetId = systemUser.getDistrictsCode();
+                    break;
+                case 3:
+                    //街道
+                    targetId = systemUser.getStreetId().toString();
+                    break;
+                case 4:
+                    //社区
+                    targetId = systemUser.getCommunityId().toString();
+                    break;
+            }
+            isSuperior = 1;
+        } else {
+            //党员
+            targetId = loginUserInfo.getUserId().toString();
+        }
+        Page<ComplaintTodoVO> page = baseMapper.getTodoList(new Page<>(basePage.getPageNum(), basePage.getPageSize()), targetId,isSuperior);
+        return page;
+    }
+    /**
+     * 延期情况说明
+     * @param complaintId
+     * @return
+     */
+    @Override
+    public ComplaintAuditRecord delayDetail(Long complaintId) {
+        return complaintAuditRecordService.lambdaQuery().eq(ComplaintAuditRecord::getComplaintId, complaintId)
+                .eq(ComplaintAuditRecord::getAuditType, 1)
+                .eq(ComplaintAuditRecord::getLatestFlag, true)
+                .last("LIMIT 1").one();
+    }
 }
 

--
Gitblit v1.7.1