From 00e04baf00ac8f35ca4483791bf17526b050ff44 Mon Sep 17 00:00:00 2001 From: wangwh <2397901735@qq.com> Date: Tue, 24 Sep 2024 19:48:30 +0800 Subject: [PATCH] 督办添加审核时间字段、排序 --- dyh-service/dyh-mediate/src/main/java/cn/huge/module/cases/controller/web/CaseTaskWebController.java | 210 ++++++++++++++++++++++++++++++++++++++++++---------- 1 files changed, 170 insertions(+), 40 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 f8ecdc4..7badcb5 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()); @@ -258,7 +254,7 @@ if (ObjectUtils.isNotEmpty(caseReturn)) { Map<String, Object> term = new HashMap<>(); term.put("mainId", caseReturn.getCaseId()); - term.put("ownerIds", caseReturn.getId()); + term.put("ownerIds", "'" + caseReturn.getId() + "'"); List<FileIdTypeInfoBaseDTO> fileInfoList = sysClient.listIdTypeInfoByOwnerIdList(term); if (CollectionUtils.isNotEmpty(fileInfoList)) { caseReturn.setFileInfoList(fileInfoList.get(0).getFileList().get(0).getFileList()); @@ -369,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") @@ -399,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; @@ -418,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: @@ -425,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)){ @@ -444,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") @@ -474,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; @@ -493,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: @@ -500,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)){ @@ -519,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") @@ -554,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: @@ -561,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)){ @@ -599,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) { @@ -614,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") @@ -652,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: @@ -659,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)){ @@ -679,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") @@ -723,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){ @@ -732,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)){ @@ -757,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(); // 回退/上报/结案申请/联合处置申请/审核时间区间 @@ -776,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){ @@ -794,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)){ @@ -856,7 +949,10 @@ sortName = "t1.auditTime"; break; case 3: - sortName = "t2.caseGrade"; + sortName = "caseGrade"; + break; + default: + sortName = "t1.turnaroundTime"; break; } switch (sortType){ @@ -865,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)){ @@ -914,7 +1013,19 @@ 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; + case 5: + sortName = "t1.reply_time"; + break; + default: + sortName = "t1.sup_time"; break; } switch (sortType){ @@ -924,23 +1035,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(); } @@ -965,13 +1080,12 @@ * @url {ctx}/api/web/caseTask/pageMyTaskYb * @param page 页码 * @param size 每页数量 - * @param sortColmn 排序字段(1:办理时间;2:事项等级;3:督办次数) - * @param sortType 排序方式(1:正序;2:倒序) + * sortColmn 排序字段(1:办理时间;2:事项等级;3:督办次数) + * sortType 排序方式(1:正序;2:倒序) * @return */ @GetMapping("/pageMyTaskYb") public Object pageMyTaskYb(@RequestParam(value = "page") int page, @RequestParam(value = "size") int size, - @RequestParam(value = "sortColmn") int sortColmn, @RequestParam(value = "sortType") int sortType, @CurrentUser String userId) { try { // 条件 @@ -1025,6 +1139,16 @@ // 排序 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"; @@ -1035,6 +1159,9 @@ case 3: sortName = "superviseCount"; break; + default: + sortName = "t1.handle_time"; + break; } switch (sortType){ case 1: @@ -1043,6 +1170,9 @@ 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"); -- Gitblit v1.8.0