From 2c0b07b09ab772646e973983e4fb6cddbd3664dc Mon Sep 17 00:00:00 2001
From: wangwh <2397901735@qq.com>
Date: Tue, 24 Sep 2024 17:28:05 +0800
Subject: [PATCH] 督办列表修改新增字段、新增排序 待审核列表修改新增字段、新增排序

---
 dyh-service/dyh-mediate/src/main/java/cn/huge/module/cases/controller/web/CaseTaskWebController.java |  307 ++++++++++++++++++++++++++++++++++++++++++++-------
 1 files changed, 265 insertions(+), 42 deletions(-)

diff --git a/dyh-service/dyh-mediate/src/main/java/cn/huge/module/cases/controller/web/CaseTaskWebController.java b/dyh-service/dyh-mediate/src/main/java/cn/huge/module/cases/controller/web/CaseTaskWebController.java
index e3dca49..d390c3a 100644
--- a/dyh-service/dyh-mediate/src/main/java/cn/huge/module/cases/controller/web/CaseTaskWebController.java
+++ b/dyh-service/dyh-mediate/src/main/java/cn/huge/module/cases/controller/web/CaseTaskWebController.java
@@ -4,10 +4,7 @@
 import cn.huge.base.common.utils.ReturnFailUtils;
 import cn.huge.base.common.utils.ReturnSucUtils;
 import cn.huge.base.config.CurrentUser;
-import cn.huge.module.cases.domain.dto.AcceptTaskDTO;
-import cn.huge.module.cases.domain.dto.AssignTaskDTO;
-import cn.huge.module.cases.domain.dto.FrontPageListSLDTO;
-import cn.huge.module.cases.domain.dto.SignTaskDTO;
+import cn.huge.module.cases.domain.dto.*;
 import cn.huge.module.cases.domain.po.*;
 import cn.huge.module.cases.service.*;
 import cn.huge.module.client.api.SysClient;
@@ -137,22 +134,21 @@
      * @return Object
      */
     @PostMapping("/allSign")
-    public Object allSign(@CurrentUser String userId) {
+    public Object allSign(@CurrentUser String userId, @RequestBody AllSignDTO allSignDTO) {
         try {
             // 条件
             Map<String, Object> terms = Maps.newHashMap();
-            // 流程/签收时间区间
-            String timeStart = request.getParameter("timeStart");
-            String timeEnd = request.getParameter("timeEnd");
-            if(StringUtils.isNotBlank(timeStart) && StringUtils.isNotBlank(timeEnd)) {
-                // 待签收,查询流转时间
-                terms.put("createTimeStart", timeStart);
-                terms.put("createTimeEnd", timeEnd);
-            }
-            // 查询申请方/被申请方关键词
-            String partyName = request.getParameter("partyName");
-            if (StringUtils.isNotBlank(partyName)){
-                terms.put("partyName", partyName);
+            if(ObjectUtils.isNotEmpty(allSignDTO)){
+                // 流程/签收时间区间
+                if(StringUtils.isNotBlank(allSignDTO.getTimeStart()) && StringUtils.isNotBlank(allSignDTO.getTimeEnd())) {
+                    // 待签收,查询流转时间
+                    terms.put("createTimeStart", allSignDTO.getTimeStart());
+                    terms.put("createTimeEnd", allSignDTO.getTimeEnd());
+                }
+                // 查询申请方/被申请方关键词
+                if (StringUtils.isNotBlank(allSignDTO.getPartyName())){
+                    terms.put("partyName", allSignDTO.getPartyName());
+                }
             }
             CtUserDTO loginUser = custClient.clientGetUserAll(userId);
             terms.put("candeUnitId",loginUser.getUnitId());
@@ -255,12 +251,14 @@
     public Object getReturnApplyInfo(@RequestParam(value = "caseTaskId") String caseTaskId, @CurrentUser String userId) {
         try {
             CaseReturn caseReturn = caseReturnService.getByCaseTaskId(caseTaskId);
-            Map<String, Object> term = new HashMap<>();
-            term.put("mainId", caseReturn.getCaseId());
-            term.put("ownerIds", caseReturn.getId());
-            List<FileIdTypeInfoBaseDTO> fileInfoList = sysClient.listIdTypeInfoByOwnerIdList(term);
-            if(CollectionUtils.isNotEmpty(fileInfoList)){
-                caseReturn.setFileInfoList(fileInfoList.get(0).getFileList().get(0).getFileList());
+            if (ObjectUtils.isNotEmpty(caseReturn)) {
+                Map<String, Object> term = new HashMap<>();
+                term.put("mainId", caseReturn.getCaseId());
+                term.put("ownerIds", "'" + caseReturn.getId() + "'");
+                List<FileIdTypeInfoBaseDTO> fileInfoList = sysClient.listIdTypeInfoByOwnerIdList(term);
+                if (CollectionUtils.isNotEmpty(fileInfoList)) {
+                    caseReturn.setFileInfoList(fileInfoList.get(0).getFileList().get(0).getFileList());
+                }
             }
             return ReturnSucUtils.getRepInfo(caseReturn);
         } catch (Exception e) {
@@ -367,7 +365,7 @@
      * @param size 每页数量
      * @param status 状态,1:待分派,2:已分派
      * @param sortType 排序方式(1:正序;2:倒序)
-     * @param sortColmn 排序字段(1:流转时间;2:分派时限/分派时间;3:事项等级)
+     * @param sortColmn 排序字段(1:流转时间;2:分派时限/分派时间;3:事项等级;4:督办次数)
      * @return
      */
     @GetMapping("/pageMyTaskFp")
@@ -397,7 +395,11 @@
                 terms.put("partyName", partyName);
             }
             CtUserDTO loginUser = custClient.clientGetUserAll(userId);
-            terms.put("candeUnitId",loginUser.getUnitId());
+            if (status == 1) {
+                terms.put("candeUnitId", loginUser.getUnitId());
+            }else {
+                terms.put("handleUnitId", loginUser.getUnitId());
+            }
             terms.put("status", status);
             // 排序
             Sort sort = null;
@@ -416,6 +418,12 @@
                 case 3:
                     sortName = "t2.case_level";
                     break;
+                case 4:
+                    sortName = "superviseCount";
+                    break;
+                default:
+                    sortName = "t1.create_time";
+                    break;
             }
             switch (sortType){
                 case 1:
@@ -423,6 +431,9 @@
                     break;
                 case 2:
                     sort = Sort.by(Sort.Direction.DESC, sortName);
+                    break;
+                default:
+                    sort = Sort.by(Sort.Direction.ASC, sortName);
                     break;
             }
             if(ObjectUtils.isEmpty(sort)){
@@ -442,7 +453,7 @@
      * @param size 每页数量
      * @param status 状态,1:待签收,2:已签收
      * @param sortType 排序方式(1:正序;2:倒序)
-     * @param sortColmn 排序字段(1:流转时间;2:签收时限/签收时间;3:事项等级)
+     * @param sortColmn 排序字段(1:流转时间;2:签收时限/签收时间;3:事项等级;4:督办次数)
      * @return
      */
     @GetMapping("/pageMyTaskQs")
@@ -472,7 +483,11 @@
                 terms.put("partyName", partyName);
             }
             CtUserDTO loginUser = custClient.clientGetUserAll(userId);
-            terms.put("candeUnitId",loginUser.getUnitId());
+            if (status == 1) {
+                terms.put("candeUnitId", loginUser.getUnitId());
+            }else {
+                terms.put("handleUnitId", loginUser.getUnitId());
+            }
             terms.put("signStatus", status);
             // 排序
             Sort sort = null;
@@ -491,6 +506,12 @@
                 case 3:
                     sortName = "t2.case_level";
                     break;
+                case 4:
+                    sortName = "superviseCount";
+                    break;
+                default:
+                    sortName = "t1.create_time";
+                    break;
             }
             switch (sortType){
                 case 1:
@@ -498,6 +519,9 @@
                     break;
                 case 2:
                     sort = Sort.by(Sort.Direction.DESC, sortName);
+                    break;
+                default:
+                    sort = Sort.by(Sort.Direction.ASC, sortName);
                     break;
             }
             if(ObjectUtils.isEmpty(sort)){
@@ -517,7 +541,7 @@
      * @param size 每页数量
      * @param status 状态,1:待受理,2:已受理,3:不予受理
      * @param sortType 排序方式(1:正序;2:倒序)
-     * @param sortColmn 排序字段(1:流转时间;2:受理时限/受理时间/不予受理时间;3:事项等级)
+     * @param sortColmn 排序字段(1:流转时间;2:受理时限/受理时间/不予受理时间;3:事项等级;4:督办次数)
      * @return
      */
     @GetMapping("/pageMyTaskSl")
@@ -552,6 +576,17 @@
                 case 3:
                     sortName = "t2.case_level";
                     break;
+                case 4:
+                    sortName = "superviseCount";
+                    break;
+                default:
+                    // 不予受理
+                    if (status == 3){
+                        sortName = "t1.case_task_time";
+                    }else {
+                        sortName = "t1.create_time";
+                    }
+                    break;
             }
             switch (sortType){
                 case 1:
@@ -559,6 +594,9 @@
                     break;
                 case 2:
                     sort = Sort.by(Sort.Direction.DESC, sortName);
+                    break;
+                default:
+                    sort = Sort.by(Sort.Direction.ASC, sortName);
                     break;
             }
             if(ObjectUtils.isEmpty(sort)){
@@ -597,7 +635,11 @@
                 return ReturnSucUtils.getRepInfo(caseDismissService.pageMyTaskBysl(pageRequest, terms));
             }else {
                 terms.put("status", status);
-                terms.put("candeUnitId", loginUser.getUnitId());
+                if (status == 1){
+                    terms.put("candeUnitId", loginUser.getUnitId());
+                }else {
+                    terms.put("handleUnitId", loginUser.getUnitId());
+                }
                 return ReturnSucUtils.getRepInfo(service.pageMyTaskSl(pageRequest, terms));
             }
         } catch (Exception e) {
@@ -612,7 +654,7 @@
      * @param size 每页数量
      * @param caseTaskType 纠纷任务类型(1:我承办的;2:我配合的)
      * @param sortType 排序方式(1:正序;2:倒序)
-     * @param sortColmn 排序字段(1:流转时间/已办天数;2:分派时限;3:事项等级)
+     * @param sortColmn 排序字段(1:流转时间/已办天数;2:分派时限;3:事项等级;4:督办次数)
      * @return
      */
     @GetMapping("/pageMyTaskBlz")
@@ -650,6 +692,12 @@
                 case 3:
                     sortName = "t2.case_level";
                     break;
+                case 4:
+                    sortName = "superviseCount";
+                    break;
+                default:
+                    sortName = "t1.create_time";
+                    break;
             }
             switch (sortType){
                 case 1:
@@ -657,6 +705,9 @@
                     break;
                 case 2:
                     sort = Sort.by(Sort.Direction.DESC, sortName);
+                    break;
+                default:
+                    sort = Sort.by(Sort.Direction.ASC, sortName);
                     break;
             }
             if(ObjectUtils.isEmpty(sort)){
@@ -677,7 +728,7 @@
      * @param status 状态,0:结案申请,1:已结案
      * @param caseTaskType 纠纷任务类型(1:我承办的;2:我配合的)
      * @param sortType 排序方式(1:正序;2:倒序)
-     * @param sortColmn 排序字段(1:结案申请时间;2:事项等级)
+     * @param sortColmn 排序字段(1:结案申请时间;2:事项等级;3:督办次数)
      * @return
      */
     @GetMapping("/pageMyTaskBl")
@@ -721,7 +772,17 @@
                     }
                     break;
                 case 2:
-                    sortName = "t1.case_level";
+                    sortName = "t2.case_level";
+                    break;
+                case 3:
+                    sortName = "superviseCount";
+                    break;
+                default:
+                    if (status == 0) {
+                        sortName = "t1.apply_time";
+                    }else {
+                        sortName = "t1.audit_time";
+                    }
                     break;
             }
             switch (sortType){
@@ -730,6 +791,9 @@
                     break;
                 case 2:
                     sort = Sort.by(Sort.Direction.DESC, sortName);
+                    break;
+                default:
+                    sort = Sort.by(Sort.Direction.ASC, sortName);
                     break;
             }
             if(ObjectUtils.isEmpty(sort)){
@@ -755,7 +819,8 @@
     @GetMapping("/pageMyTaskSh")
     public Object pageMyTaskSh(@RequestParam(value = "page") int page, @RequestParam(value = "size") int size,
                                @RequestParam(value = "status") int status, @RequestParam(value = "type") int type,
-                               @CurrentUser String userId, @RequestParam(value = "sortType") int sortType) {
+                               @CurrentUser String userId, @RequestParam(value = "sortType") int sortType,
+                               @RequestParam(value = "sortColmn") int sortColmn) {
         try {
             Map<String, Object> terms = Maps.newHashMap();
             // 回退/上报/结案申请/联合处置申请/审核时间区间
@@ -774,16 +839,43 @@
             String sortName = null;
             switch (type){
                 case 1:
-                    sortName = "t1.return_time";
+                    if(1 == sortColmn){
+                        sortName = "t1.return_time";
+                    }else if(2 == sortColmn){
+                        sortName = "t2.case_level";
+                    }else if(3 == sortColmn){
+                        sortName = "t1.audit_time";
+                    }
                     break;
                 case 2:
-                    sortName = "t1.appear_time";
+                    if(1 == sortColmn) {
+                        sortName = "t1.appear_time";
+                    }else if(2 == sortColmn){
+                        sortName = "t2.case_level";
+                    }else if(3 == sortColmn){
+                        sortName = "t1.audit_time";
+                    }
                     break;
                 case 3:
-                    sortName = "t1.apply_time";
+                    if(1 == sortColmn) {
+                        sortName = "t1.apply_time";
+                    }else if(2 == sortColmn){
+                        sortName = "t2.case_level";
+                    }else if(3 == sortColmn){
+                        sortName = "t1.audit_time";
+                    }
                     break;
                 case 4:
-                    sortName = "t1.apply_time";
+                    if(1 == sortColmn) {
+                        sortName = "t1.apply_time";
+                    }else if(2 == sortColmn){
+                        sortName = "t2.case_level";
+                    }else if(3 == sortColmn){
+                        sortName = "t1.audit_time";
+                    }
+                    break;
+                default:
+                    sortName = "t1.create_time";
                     break;
             }
             switch (sortType){
@@ -792,6 +884,9 @@
                     break;
                 case 2:
                     sort = Sort.by(Sort.Direction.DESC, sortName);
+                    break;
+                default:
+                    sort = Sort.by(Sort.Direction.ASC, sortName);
                     break;
             }
             if(ObjectUtils.isEmpty(sort)){
@@ -854,7 +949,10 @@
                     sortName = "t1.auditTime";
                     break;
                 case 3:
-                    sortName = "t2.caseGrade";
+                    sortName = "caseGrade";
+                    break;
+                default:
+                    sortName = "t1.turnaroundTime";
                     break;
             }
             switch (sortType){
@@ -863,6 +961,9 @@
                     break;
                 case 2:
                     sort = Sort.by(Sort.Direction.DESC, sortName);
+                    break;
+                default:
+                    sort = Sort.by(Sort.Direction.ASC, sortName);
                     break;
             }
             if(ObjectUtils.isEmpty(sort)){
@@ -912,7 +1013,16 @@
                     sortName = "t1.sup_time";
                     break;
                 case 2:
-                    sortName = "t1.case_level";
+                    sortName = "timeLimit";
+                    break;
+                case 3:
+                    sortName = "t2.case_level";
+                    break;
+                case 4:
+                    sortName = "t1.sup_status";
+                    break;
+                default:
+                    sortName = "t1.sup_time";
                     break;
             }
             switch (sortType){
@@ -922,23 +1032,27 @@
                 case 2:
                     sort = Sort.by(Sort.Direction.DESC, sortName);
                     break;
+                default:
+                    sort = Sort.by(Sort.Direction.ASC, sortName);
+                    break;
             }
             if(ObjectUtils.isEmpty(sort)){
                 sort = Sort.by(Sort.Direction.DESC, "t1.create_time");
             }
             PageRequest pageRequest = PageRequest.of(page-1, size, sort);
             CtUserDTO loginUser = custClient.clientGetUserAll(userId);
-            Page<CaseSupervise> caseSupervisePage = null;
+            Page<FrontPageListDTO> frontPageListDTOPage = null;
             if(StringUtils.isNotBlank(loginUser.getUnitId())){
+                terms.put("type", status);
                 if(3 != status){
                     terms.put("quiltUnitId",loginUser.getUnitId());
                     terms.put("supStatus", status);
                 }else{
                     terms.put("supUnitId",loginUser.getUnitId());
                 }
-                caseSupervisePage = superviseService.pageMyTaskDb(pageRequest, terms);
+                frontPageListDTOPage = superviseService.pageMyTaskDb(pageRequest, terms);
             }
-            return ReturnSucUtils.getRepInfo(caseSupervisePage);
+            return ReturnSucUtils.getRepInfo(frontPageListDTOPage);
         } catch (Exception e) {
             return ReturnFailUtils.getRepInfo();
         }
@@ -957,4 +1071,113 @@
             return ReturnFailUtils.getRepInfo();
         }
     }
+
+    /**
+     * web端-工作台-已办事项
+     * @url {ctx}/api/web/caseTask/pageMyTaskYb
+     * @param page 页码
+     * @param size 每页数量
+     * sortColmn 排序字段(1:办理时间;2:事项等级;3:督办次数)
+     * sortType 排序方式(1:正序;2:倒序)
+     * @return
+     */
+    @GetMapping("/pageMyTaskYb")
+    public Object pageMyTaskYb(@RequestParam(value = "page") int page, @RequestParam(value = "size") int size,
+                               @CurrentUser String userId) {
+        try {
+            // 条件
+            Map<String, Object> terms = Maps.newHashMap();
+            // 受理时间
+            String createTimeStart = request.getParameter("createTimeStart");
+            String createTimeEnd = request.getParameter("createTimeEnd");
+            if(StringUtils.isNotBlank(createTimeStart) && StringUtils.isNotBlank(createTimeEnd)) {
+                terms.put("createTimeStart", createTimeStart);
+                terms.put("createTimeEnd", createTimeEnd);
+            }
+            // 办结时间
+            String handleTimeStart = request.getParameter("handleTimeStart");
+            String handleTimeEnd = request.getParameter("handleTimeEnd");
+            if(StringUtils.isNotBlank(handleTimeStart) && StringUtils.isNotBlank(handleTimeEnd)) {
+                terms.put("handleTimeStart", handleTimeStart);
+                terms.put("handleTimeEnd", handleTimeEnd);
+            }
+            // 经办人
+            String mediator = request.getParameter("mediator");
+            if (StringUtils.isNotBlank(mediator)){
+                terms.put("mediator", mediator);
+            }
+            // 事项来源
+            String canal = request.getParameter("canal");
+            if (StringUtils.isNotBlank(canal)){
+                terms.put("canal", canal);
+            }
+            // 化解结果
+            String mediResult = request.getParameter("mediResult");
+            if (StringUtils.isNotBlank(mediResult)){
+                terms.put("mediResult", mediResult);
+            }
+            // 事项等级
+            String caseLevel = request.getParameter("caseLevel");
+            if (StringUtils.isNotBlank(caseLevel)){
+                terms.put("caseLevel", caseLevel);
+            }
+            // 纠纷类型
+            String caseType = request.getParameter("caseType");
+            if (StringUtils.isNotBlank(caseType)){
+                terms.put("caseType", caseType);
+            }
+            // 事项状态
+            String status = request.getParameter("status");
+            if (StringUtils.isNotBlank(status)){
+                terms.put("status", status);
+            }
+            CtUserDTO loginUser = custClient.clientGetUserAll(userId);
+            terms.put("handleUnitId", loginUser.getUnitId());
+            // 排序
+            Sort sort = null;
+            String sortName = null;
+            String sortColmnStr = request.getParameter("sortColmn");
+            String sortTypeStr = request.getParameter("sortType");
+            int sortColmn = 1;
+            int sortType = 1;
+            if(StringUtils.isNotBlank(sortColmnStr)){
+                sortColmn = Integer.valueOf(sortColmnStr);
+            }
+            if(StringUtils.isNotBlank(sortTypeStr)){
+                sortType = Integer.valueOf(sortTypeStr);
+            }
+            switch (sortColmn){
+                case 1:
+                    sortName = "t1.handle_time";
+                    break;
+                case 2:
+                    sortName = "t2.case_level";
+                    break;
+                case 3:
+                    sortName = "superviseCount";
+                    break;
+                default:
+                    sortName = "t1.handle_time";
+                    break;
+            }
+            switch (sortType){
+                case 1:
+                    sort = Sort.by(Sort.Direction.ASC, sortName);
+                    break;
+                case 2:
+                    sort = Sort.by(Sort.Direction.DESC, sortName);
+                    break;
+                default:
+                    sort = Sort.by(Sort.Direction.ASC, sortName);
+                    break;
+            }
+            if(ObjectUtils.isEmpty(sort)){
+                sort = Sort.by(Sort.Direction.DESC, "t1.create_time");
+            }
+            PageRequest pageRequest = PageRequest.of(page-1, size, sort);
+            return ReturnSucUtils.getRepInfo(service.pageMyTaskYb(pageRequest, terms));
+        } catch (Exception e) {
+            return ReturnFailUtils.getRepInfo();
+        }
+    }
 }

--
Gitblit v1.8.0