package cn.huge.module.cases.controller.web;
|
|
import cn.huge.base.common.bo.R;
|
import cn.huge.base.common.utils.DateUtils;
|
import cn.huge.base.common.utils.ObjectUtils;
|
import cn.huge.base.common.utils.ReturnFailUtils;
|
import cn.huge.base.common.utils.ReturnSucUtils;
|
import cn.huge.base.config.CurrentUser;
|
import cn.huge.module.casebook.consts.ByCaseConstsEnum;
|
import cn.huge.module.cases.domain.bo.CasePersonCountBO;
|
import cn.huge.module.cases.domain.dto.*;
|
import cn.huge.module.cases.domain.po.CaseAgent;
|
import cn.huge.module.cases.domain.po.CaseInfo;
|
import cn.huge.module.cases.domain.po.CaseInfo2;
|
import cn.huge.module.cases.domain.vo.CaseVo;
|
import cn.huge.module.cases.service.CaseInfoService;
|
import cn.huge.module.cases.service.CaseRepeatService;
|
import cn.huge.module.draft.service.CasedraftInfoService;
|
import cn.huge.module.mediate.constant.CaseBaseConstsEnum;
|
import cn.huge.module.utils.TimeUtils;
|
import com.alibaba.excel.EasyExcel;
|
import com.google.common.collect.Maps;
|
import lombok.extern.slf4j.Slf4j;
|
import org.apache.commons.lang3.StringUtils;
|
import org.springframework.beans.BeanUtils;
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.data.domain.Page;
|
import org.springframework.data.domain.PageRequest;
|
import org.springframework.data.domain.Sort;
|
import org.springframework.web.bind.annotation.*;
|
|
import javax.servlet.ServletOutputStream;
|
import javax.servlet.http.HttpServletRequest;
|
import javax.servlet.http.HttpServletResponse;
|
import java.net.URLEncoder;
|
import java.time.LocalDate;
|
import java.time.format.DateTimeFormatter;
|
import java.time.temporal.ChronoUnit;
|
import java.util.*;
|
|
/**
|
* @title: 纠纷信息主表接口api-web端
|
* @description: 纠纷信息主表接口api-web端
|
* @company: hugeinfo
|
* @author: wangwh
|
* @time: 2024-08-27 10:00:57
|
* @version: 1.0.0
|
*/
|
@Slf4j
|
@RestController
|
@RequestMapping("/api/web/caseInfo")
|
public class CaseInfoWebController {
|
|
@Autowired(required = false)
|
private HttpServletRequest request;
|
|
@Autowired
|
private CaseInfoService service;
|
@Autowired
|
private CasedraftInfoService casedraftInfoService;
|
@Autowired
|
private CaseRepeatService caseRepeatService;
|
|
private Map<String, Object> getParameterOverview() {
|
Map<String, Object> terms = new HashMap<>();
|
String startDate = request.getParameter("startDate");
|
String endDate = request.getParameter("endDate");
|
terms.put("startDate", startDate);
|
terms.put("endDate", endDate);
|
terms.put("areaType", "2");
|
// 属地市
|
String queCity = request.getParameter("queCity");
|
if (StringUtils.isNotBlank(queCity)) {
|
terms.put("queCity", queCity);
|
terms.put("areaType", "2");
|
terms.put("areaCode", queCity);
|
}
|
// 属地区
|
String queArea = request.getParameter("queArea");
|
if (StringUtils.isNotBlank(queArea)) {
|
terms.put("queArea", queArea);
|
terms.put("areaType", "3");
|
terms.put("areaCode", queArea);
|
}
|
// 属地街道
|
String queRoad = request.getParameter("queRoad");
|
if (StringUtils.isNotBlank(queRoad)) {
|
terms.put("queRoad", queRoad);
|
terms.put("areaType", "4");
|
terms.put("areaCode", queRoad);
|
}
|
// 属地社区
|
String queVillage = request.getParameter("queVillage");
|
if (StringUtils.isNotBlank(queVillage)) {
|
terms.put("queVillage", queVillage);
|
terms.put("areaType", "4");
|
terms.put("areaCode", queVillage);
|
}
|
return terms;
|
}
|
|
private Map<String, Object> getParameterAll() {
|
Map<String, Object> terms = getParameter();
|
// // 来访时间
|
String visitTimeStart = request.getParameter("visitTimeStart");
|
String visitTimeEnd = request.getParameter("visitTimeEnd");
|
if (StringUtils.isNotBlank(visitTimeStart) && StringUtils.isNotBlank(visitTimeEnd)) {
|
terms.put("visitTimeStart", visitTimeStart + " 00:00:00");
|
terms.put("visitTimeEnd", visitTimeEnd + " 23:59:59");
|
}
|
String createStart = request.getParameter("createStart");
|
String createEnd = request.getParameter("createEnd");
|
if (StringUtils.isNotBlank(createStart) && StringUtils.isNotBlank(createEnd)) {
|
terms.put("createStart", createStart + " 00:00:00");
|
terms.put("createEnd", createEnd + " 23:59:59");
|
}
|
String closeStart = request.getParameter("closeStart");
|
String closeEnd = request.getParameter("closeEnd");
|
if (StringUtils.isNotBlank(closeStart) && StringUtils.isNotBlank(closeEnd)) {
|
terms.put("createStart", closeStart + " 00:00:00");
|
terms.put("createEnd", closeEnd + " 23:59:59");
|
}
|
String fileStart = request.getParameter("fileStart");
|
String fileEnd = request.getParameter("fileEnd");
|
if (StringUtils.isNotBlank(fileStart) && StringUtils.isNotBlank(fileEnd)) {
|
terms.put("createStart", fileStart + " 00:00:00");
|
terms.put("createEnd", fileEnd + " 23:59:59");
|
}
|
String queRoad = request.getParameter("queRoad");
|
if (StringUtils.isNotBlank(queRoad)) {
|
terms.put("areaType", "2");
|
}
|
|
// 实际调解组织编号
|
String mediateUnitId = request.getParameter("mediateUnitId");
|
if (StringUtils.isNotBlank(mediateUnitId)) {
|
terms.put("mediateUnitId", mediateUnitId);
|
}
|
// 配合组织，多个用,隔开
|
String assistUnitId = request.getParameter("assistUnitId");
|
if (StringUtils.isNotBlank(assistUnitId)) {
|
terms.put("assistUnitId", assistUnitId);
|
}
|
|
// 实际调解组织编号
|
String mediateUnitName = request.getParameter("mediateUnitName");
|
if (StringUtils.isNotBlank(mediateUnitName)) {
|
terms.put("mediateUnitName", mediateUnitName);
|
}
|
// 配合组织，多个用,隔开
|
String assistUnitName = request.getParameter("assistUnitName");
|
if (StringUtils.isNotBlank(assistUnitName)) {
|
terms.put("assistUnitName", assistUnitName);
|
}
|
// 配合组织，多个用,隔开
|
String evaluateGrade = request.getParameter("evaluateGrade");
|
if (StringUtils.isNotBlank(evaluateGrade)) {
|
terms.put("evaluateGrade", evaluateGrade);
|
}
|
// 配合组织，多个用,隔开
|
String mediResult = request.getParameter("mediResult");
|
if (StringUtils.isNotBlank(mediResult)) {
|
terms.put("mediResult", mediResult);
|
}
|
//经办人ID
|
String mediatorId = request.getParameter("mediatorId");
|
if (StringUtils.isNotBlank(mediatorId)) {
|
terms.put("mediatorId", mediatorId);
|
}
|
//经办人ID
|
String mediator = request.getParameter("mediator");
|
if (StringUtils.isNotBlank(mediator)) {
|
terms.put("mediator", mediator);
|
}
|
|
//经办人ID
|
String systemSource = request.getParameter("systemSource");
|
if (StringUtils.isNotBlank(systemSource)) {
|
terms.put("systemSource", systemSource);
|
}
|
|
//市民编码
|
String cityCode = request.getParameter("cityCode");
|
if (StringUtils.isNotBlank(cityCode)) {
|
terms.put("cityCode", cityCode);
|
}
|
|
String peopleNum = request.getParameter("peopleNum");
|
if (StringUtils.isNotBlank(peopleNum)) {
|
String[] split = peopleNum.split("-");
|
String number = split[0];
|
if (number.equals("0") && split.length == 1) {
|
terms.put("peopleNumEnd", split[0]);
|
} else {
|
terms.put("peopleNumStart", split[0]);
|
if (split.length > 1) {
|
terms.put("peopleNumEnd", split[1]);
|
}
|
}
|
}
|
String amount = request.getParameter("amount");
|
if (StringUtils.isNotBlank(amount)) {
|
String[] split = amount.split("-");
|
String number = split[0];
|
if (number.equals("0") && split.length == 1) {
|
terms.put("amountEnd", split[0]);
|
} else {
|
terms.put("amountStart", split[0]);
|
if (split.length > 1) {
|
terms.put("amountEnd", split[1]);
|
}
|
}
|
}
|
return terms;
|
}
|
|
/**
|
* 获取请求URL参数
|
*
|
* @return Map<String, Object>
|
*/
|
private Map<String, Object> getParameter() {
|
Map<String, Object> terms = Maps.newHashMap();
|
// 主键编号
|
String id = request.getParameter("id");
|
if (StringUtils.isNotBlank(id)) {
|
terms.put("id", id);
|
}
|
// 事项标题
|
String caseTitle = request.getParameter("caseTitle");
|
if (StringUtils.isNotBlank(caseTitle)) {
|
terms.put("caseTitle", caseTitle);
|
}
|
// 事项编号
|
String caseRef = request.getParameter("caseRef");
|
if (StringUtils.isNotBlank(caseRef)) {
|
terms.put("caseRef", caseRef);
|
}
|
// 事项等级
|
String caseLevel = request.getParameter("caseLevel");
|
if (StringUtils.isNotBlank(caseLevel)) {
|
terms.put("caseLevel", caseLevel);
|
}
|
// 来访时间
|
String visitTime = request.getParameter("visitTime");
|
if (StringUtils.isNotBlank(visitTime)) {
|
terms.put("visitTime", visitTime);
|
}
|
// 来访人数
|
String visitPeopleNum = request.getParameter("visitPeopleNum");
|
if (StringUtils.isNotBlank(visitPeopleNum)) {
|
terms.put("visitPeopleNum", visitPeopleNum);
|
}
|
// 调解类型
|
String mediType = request.getParameter("mediType");
|
if (StringUtils.isNotBlank(mediType)) {
|
terms.put("mediType", mediType);
|
}
|
// 调解类型名称
|
String mediTypeName = request.getParameter("mediTypeName");
|
if (StringUtils.isNotBlank(mediTypeName)) {
|
terms.put("mediTypeName", mediTypeName);
|
}
|
// 纠纷一级类型
|
String caseTypeFirst = request.getParameter("caseTypeFirst");
|
if (StringUtils.isNotBlank(caseTypeFirst)) {
|
terms.put("caseTypeFirst", caseTypeFirst);
|
}
|
// 纠纷一级类型名称
|
String caseTypeFirstName = request.getParameter("caseTypeFirstName");
|
if (StringUtils.isNotBlank(caseTypeFirstName)) {
|
terms.put("caseTypeFirstName", caseTypeFirstName);
|
}
|
// 纠纷类型
|
String caseType = request.getParameter("caseType");
|
if (StringUtils.isNotBlank(caseType)) {
|
terms.put("caseType", caseType);
|
}
|
// 纠纷类型名称
|
String caseTypeName = request.getParameter("caseTypeName");
|
if (StringUtils.isNotBlank(caseTypeName)) {
|
terms.put("caseTypeName", caseTypeName);
|
}
|
// 纠纷发生时间
|
String occurTime = request.getParameter("occurTime");
|
if (StringUtils.isNotBlank(occurTime)) {
|
terms.put("occurTime", occurTime);
|
}
|
// 纠纷发生地详细地址
|
String addr = request.getParameter("addr");
|
if (StringUtils.isNotBlank(addr)) {
|
terms.put("addr", addr);
|
}
|
// 纠纷发生地经度
|
String lng = request.getParameter("lng");
|
if (StringUtils.isNotBlank(lng)) {
|
terms.put("lng", lng);
|
}
|
// 纠纷发生地纬度
|
String lat = request.getParameter("lat");
|
if (StringUtils.isNotBlank(lat)) {
|
terms.put("lat", lat);
|
}
|
// 纠纷发生地网格地址
|
String wgAddr = request.getParameter("wgAddr");
|
if (StringUtils.isNotBlank(wgAddr)) {
|
terms.put("wgAddr", wgAddr);
|
}
|
// 纠纷发生地网格地址经度
|
String wgLng = request.getParameter("wgLng");
|
if (StringUtils.isNotBlank(wgLng)) {
|
terms.put("wgLng", wgLng);
|
}
|
// 纠纷发生地网格地址纬度
|
String wgLat = request.getParameter("wgLat");
|
if (StringUtils.isNotBlank(wgLat)) {
|
terms.put("wgLat", wgLat);
|
}
|
// 问题属地省
|
String queProv = request.getParameter("queProv");
|
if (StringUtils.isNotBlank(queProv)) {
|
terms.put("queProv", queProv);
|
}
|
// 问题属地省名称
|
String queProvName = request.getParameter("queProvName");
|
if (StringUtils.isNotBlank(queProvName)) {
|
terms.put("queProvName", queProvName);
|
}
|
// 问题属地市
|
String queCity = request.getParameter("queCity");
|
if (StringUtils.isNotBlank(queCity)) {
|
terms.put("queCity", queCity);
|
}
|
// 问题属地市名称
|
String queCityName = request.getParameter("queCityName");
|
if (StringUtils.isNotBlank(queCityName)) {
|
terms.put("queCityName", queCityName);
|
}
|
// 问题属地区
|
String queArea = request.getParameter("queArea");
|
if (StringUtils.isNotBlank(queArea)) {
|
terms.put("queArea", queArea);
|
}
|
// 问题属地区名称
|
String queAreaName = request.getParameter("queAreaName");
|
if (StringUtils.isNotBlank(queAreaName)) {
|
terms.put("queAreaName", queAreaName);
|
}
|
// 问题属地街道
|
String queRoad = request.getParameter("queRoad");
|
if (StringUtils.isNotBlank(queRoad)) {
|
terms.put("queRoad", queRoad);
|
}
|
// 问题属地街道名称
|
String queRoadName = request.getParameter("queRoadName");
|
if (StringUtils.isNotBlank(queRoadName)) {
|
terms.put("queRoadName", queRoadName);
|
}
|
// 问题属地社区
|
String queVillage = request.getParameter("queVillage");
|
if (StringUtils.isNotBlank(queVillage)) {
|
terms.put("queVillage", queVillage);
|
}
|
// 问题属地社区名称
|
String queVillageName = request.getParameter("queVillageName");
|
if (StringUtils.isNotBlank(queVillageName)) {
|
terms.put("queVillageName", queVillageName);
|
}
|
// 涉及人数
|
String peopleNum = request.getParameter("peopleNum");
|
if (StringUtils.isNotBlank(peopleNum)) {
|
terms.put("peopleNum", peopleNum);
|
}
|
// 涉及金额
|
String amount = request.getParameter("amount");
|
if (StringUtils.isNotBlank(amount)) {
|
terms.put("amount", amount);
|
}
|
// 涉及人群
|
String crowd = request.getParameter("crowd");
|
if (StringUtils.isNotBlank(crowd)) {
|
terms.put("crowd", crowd);
|
}
|
// 涉及人群名称
|
String crowdName = request.getParameter("crowdName");
|
if (StringUtils.isNotBlank(crowdName)) {
|
terms.put("crowdName", crowdName);
|
}
|
// 事项来源
|
String canal = request.getParameter("canal");
|
if (StringUtils.isNotBlank(canal)) {
|
terms.put("canal", canal);
|
}
|
// 事项来源名称
|
String canalName = request.getParameter("canalName");
|
if (StringUtils.isNotBlank(canalName)) {
|
terms.put("canalName", canalName);
|
}
|
// 来访形式
|
String visitWay = request.getParameter("visitWay");
|
if (StringUtils.isNotBlank(visitWay)) {
|
terms.put("visitWay", visitWay);
|
}
|
// 来访形式名称
|
String visitWayName = request.getParameter("visitWayName");
|
if (StringUtils.isNotBlank(visitWayName)) {
|
terms.put("visitWayName", visitWayName);
|
}
|
// 事项概况
|
String caseDes = request.getParameter("caseDes");
|
if (StringUtils.isNotBlank(caseDes)) {
|
terms.put("caseDes", caseDes);
|
}
|
// 事项申请
|
String caseClaim = request.getParameter("caseClaim");
|
if (StringUtils.isNotBlank(caseClaim)) {
|
terms.put("caseClaim", caseClaim);
|
}
|
// 是否重大矛盾纠纷，0：否，1：是
|
String majorStatus = request.getParameter("majorStatus");
|
if (StringUtils.isNotBlank(majorStatus)) {
|
terms.put("majorStatus", majorStatus);
|
}
|
// 纠纷来源
|
String source = request.getParameter("source");
|
if (StringUtils.isNotBlank(source)) {
|
terms.put("source", source);
|
}
|
// 纠纷来源名称
|
String sourceName = request.getParameter("sourceName");
|
if (StringUtils.isNotBlank(sourceName)) {
|
terms.put("sourceName", sourceName);
|
}
|
// 矛调号
|
String caseNo = request.getParameter("caseNo");
|
if (StringUtils.isNotBlank(caseNo)) {
|
terms.put("caseNo", caseNo);
|
}
|
// 民诉前调号
|
String mediateNo = request.getParameter("mediateNo");
|
if (StringUtils.isNotBlank(mediateNo)) {
|
terms.put("mediateNo", mediateNo);
|
}
|
// 民诉前调书号
|
String mediateBookNo = request.getParameter("mediateBookNo");
|
if (StringUtils.isNotBlank(mediateBookNo)) {
|
terms.put("mediateBookNo", mediateBookNo);
|
}
|
// 诉讼案号
|
String civilNo = request.getParameter("civilNo");
|
if (StringUtils.isNotBlank(civilNo)) {
|
terms.put("civilNo", civilNo);
|
}
|
// 申请方当事人名称
|
String plaintiffs = request.getParameter("plaintiffs");
|
if (StringUtils.isNotBlank(plaintiffs)) {
|
terms.put("plaintiffs", plaintiffs);
|
}
|
// 申请方代理人名称
|
String pagents = request.getParameter("pagents");
|
if (StringUtils.isNotBlank(pagents)) {
|
terms.put("pagents", pagents);
|
}
|
// 被申请方当事人名称
|
String defendants = request.getParameter("defendants");
|
if (StringUtils.isNotBlank(defendants)) {
|
terms.put("defendants", defendants);
|
}
|
// 被申请方代理人名称
|
String dagents = request.getParameter("dagents");
|
if (StringUtils.isNotBlank(dagents)) {
|
terms.put("dagents", dagents);
|
}
|
// 登记组织编号
|
String inputUnitId = request.getParameter("inputUnitId");
|
if (StringUtils.isNotBlank(inputUnitId)) {
|
terms.put("inputUnitId", inputUnitId);
|
}
|
// 登记组织名称
|
String inputUnitName = request.getParameter("inputUnitName");
|
if (StringUtils.isNotBlank(inputUnitName)) {
|
terms.put("inputUnitName", inputUnitName);
|
}
|
// 登记人编号
|
String inputUserId = request.getParameter("inputUserId");
|
if (StringUtils.isNotBlank(inputUserId)) {
|
terms.put("inputUserId", inputUserId);
|
}
|
// 登记人名称
|
String inputUserName = request.getParameter("inputUserName");
|
if (StringUtils.isNotBlank(inputUserName)) {
|
terms.put("inputUserName", inputUserName);
|
}
|
// 登记方式，1：正常登记，2：案件导入
|
String inputWay = request.getParameter("inputWay");
|
if (StringUtils.isNotBlank(inputWay)) {
|
terms.put("inputWay", inputWay);
|
}
|
// 事项状态，1：待分派，2：待签收，3：待受理，4：化解中，5：结案审核，6：待评价，7：已归档，8：不予受理
|
String status = request.getParameter("status");
|
if (StringUtils.isNotBlank(status)) {
|
terms.put("status", status);
|
}
|
// 事项状态名称
|
String statusName = request.getParameter("statusName");
|
if (StringUtils.isNotBlank(statusName)) {
|
terms.put("statusName", statusName);
|
}
|
// 事项进度，1：来访登记，2：事件流转，3：办理反馈，4：结案申请，5：当事人评价，6：结案归档
|
String process = request.getParameter("process");
|
if (StringUtils.isNotBlank(process)) {
|
terms.put("process", process);
|
}
|
// 事项进度名称
|
String processName = request.getParameter("processName");
|
if (StringUtils.isNotBlank(processName)) {
|
terms.put("processName", processName);
|
}
|
// 对外展示事项进度，1：待受理，2：化解中，3：已结案，4：不予受理
|
String infoProcess = request.getParameter("process");
|
if (StringUtils.isNotBlank(infoProcess)) {
|
terms.put("infoProcess", infoProcess);
|
}
|
// 对外展示事项进度
|
String infoProcessName = request.getParameter("infoProcessName");
|
if (StringUtils.isNotBlank(infoProcessName)) {
|
terms.put("infoProcessName", infoProcessName);
|
}
|
// 小程序是否可见，0：不可见，1：可见
|
String partyShow = request.getParameter("partyShow");
|
if (StringUtils.isNotBlank(partyShow)) {
|
terms.put("partyShow", partyShow);
|
}
|
// 意向调解组织编号
|
String wantUnitId = request.getParameter("wantUnitId");
|
if (StringUtils.isNotBlank(wantUnitId)) {
|
terms.put("wantUnitId", wantUnitId);
|
}
|
// 意向调解组织名称
|
String wantUnitName = request.getParameter("wantUnitName");
|
if (StringUtils.isNotBlank(wantUnitName)) {
|
terms.put("wantUnitName", wantUnitName);
|
}
|
// 意向调解员编号
|
String wantUserId = request.getParameter("wantUserId");
|
if (StringUtils.isNotBlank(wantUserId)) {
|
terms.put("wantUserId", wantUserId);
|
}
|
// 意向调解员名称
|
String wantUserName = request.getParameter("wantUserName");
|
if (StringUtils.isNotBlank(wantUserName)) {
|
terms.put("wantUserName", wantUserName);
|
}
|
// 删除状态，0：未删除，1：已删除
|
String deleteStatus = request.getParameter("deleteStatus");
|
if (StringUtils.isNotBlank(deleteStatus)) {
|
terms.put("deleteStatus", deleteStatus);
|
}
|
// 顾客编号
|
String custId = request.getParameter("custId");
|
if (StringUtils.isNotBlank(custId)) {
|
terms.put("custId", custId);
|
}
|
// 创建时间区间
|
String createStart = request.getParameter("createStart");
|
String createEnd = request.getParameter("createEnd");
|
if (StringUtils.isNotBlank(createStart) && StringUtils.isNotBlank(createEnd)) {
|
terms.put("createStart", createStart);
|
terms.put("createEnd", createEnd);
|
}
|
// 更新时间区间
|
String updateStart = request.getParameter("updateStart");
|
String updateEnd = request.getParameter("updateEnd");
|
if (StringUtils.isNotBlank(updateStart) && StringUtils.isNotBlank(updateEnd)) {
|
terms.put("updateStart", updateStart);
|
terms.put("updateEnd", updateEnd);
|
}
|
|
// 协同推送-二级分类
|
String canalSecond = request.getParameter("canalSecond");
|
if (StringUtils.isNotBlank(canalSecond)) {
|
terms.put("canalSecond", canalSecond);
|
}
|
|
// 协同推送-二级分类名称
|
String canalSecondName = request.getParameter("canalSecondName");
|
if (StringUtils.isNotBlank(canalSecondName)) {
|
terms.put("canalSecondName", canalSecondName);
|
}
|
|
// 是否扬言风险案件，0：否，1：是
|
String isRisk = request.getParameter("isRisk");
|
if (StringUtils.isNotBlank(isRisk)) {
|
terms.put("isRisk", isRisk);
|
}
|
|
// 结案协议类型
|
String agreeType = request.getParameter("agreeType");
|
if (StringUtils.isNotBlank(agreeType)) {
|
terms.put("agreeType", agreeType);
|
}
|
return terms;
|
}
|
|
/**
|
* 条件查询多个
|
*
|
* @return Object
|
* @url {ctx}/api/web/caseInfo/listQuery
|
*/
|
@GetMapping("/listQuery")
|
public Object listQuery() {
|
try {
|
Map<String, Object> terms = getParameter();
|
return ReturnSucUtils.getRepInfo(service.listTerms(terms));
|
} catch (Exception e) {
|
return ReturnFailUtils.getRepInfo();
|
}
|
}
|
|
/**
|
* 条件查询多个
|
*
|
* @return Object
|
* @url {ctx}/api/web/caseInfo/listQuery
|
*/
|
@GetMapping("/listQuery2")
|
public R<List<CaseInfo2>> listQuery2(CaseVo caseVo) {
|
try {
|
return R.ok(service.selectByLastTime(caseVo));
|
} catch (Exception e) {
|
return R.fail();
|
}
|
}
|
|
/**
|
* 条件分页查询
|
*
|
* @param page 页码
|
* @param size 每页数量
|
* @return Object
|
* @url {ctx}/api/web/caseInfo/pageQuery
|
*/
|
@GetMapping("/pageQuery")
|
public Object pageQuery(@RequestParam(value = "page") int page, @RequestParam(value = "size") int size) {
|
try {
|
Map<String, Object> terms = getParameter();
|
Sort sort = Sort.by(Sort.Direction.DESC, "create_time");
|
PageRequest pageRequest = PageRequest.of(page - 1, size, sort);
|
Page<CaseInfo> caseInfoPage = service.pageQuery(pageRequest, terms);
|
return ReturnSucUtils.getRepInfo("处理成功", caseInfoPage);
|
} catch (Exception e) {
|
return ReturnFailUtils.getRepInfo();
|
}
|
}
|
|
/**
|
* 根据编号查询单个
|
*
|
* @param id 主键编号
|
* @return Object
|
* @url {ctx}/api/web/caseInfo/getById
|
*/
|
@GetMapping("/getById")
|
public Object getById(@RequestParam(value = "id") String id) {
|
try {
|
return ReturnSucUtils.getRepInfo(service.getById(id));
|
} catch (Exception e) {
|
return ReturnFailUtils.getRepInfo();
|
}
|
}
|
|
/**
|
* 根据主键单个
|
*
|
* @param id 主键编号
|
* @return Object
|
* @url {ctx}/api/web/caseInfo/deleteById
|
*/
|
@GetMapping("/deleteById")
|
public Object deleteById(@RequestParam(value = "id") String id) {
|
try {
|
service.removeById(id);
|
return ReturnSucUtils.getRepInfo();
|
} catch (Exception e) {
|
return ReturnFailUtils.getRepInfo();
|
}
|
}
|
|
/**
|
* 根据主键单个
|
*
|
* @return Object
|
* @url {ctx}/api/web/caseInfo/deleteById
|
*/
|
@PostMapping("/deleteCaseById")
|
public Object deleteCaseById(@RequestBody CaseInfo caseInfo) {
|
try {
|
service.deleteCaseById(caseInfo.getId());
|
return ReturnSucUtils.getRepInfo();
|
} catch (Exception e) {
|
log.error(e.getMessage());
|
return ReturnFailUtils.getRepInfo();
|
}
|
}
|
|
/**
|
* 新增或更新对象
|
*
|
* @param caseInfo 实体对象
|
* @return Object
|
* @url {ctx}/api/web/caseInfo/saveCaseInfo
|
*/
|
@PostMapping("/saveCaseInfo")
|
public Object saveCaseInfo(@RequestBody CaseInfo caseInfo) {
|
try {
|
service.saveCaseInfo(caseInfo);
|
return ReturnSucUtils.getRepInfo();
|
} catch (Exception e) {
|
log.error(e.getMessage());
|
return ReturnFailUtils.getRepInfo();
|
}
|
}
|
|
/**
|
* PC端-纠纷登记-根据坐标信息入格
|
*
|
* @param caseId 纠纷编号
|
* @url {ctx}/api/web/caseInfo/setGridInfoById
|
*/
|
@PostMapping("/setGridInfoById")
|
public Object setGridInfoById(@RequestParam String caseId) {
|
try {
|
service.setGridInfoById(caseId);
|
} catch (Exception e) {
|
return ReturnFailUtils.getRepInfo(e.getMessage());
|
}
|
return ReturnSucUtils.getRepInfo(caseId);
|
}
|
|
|
/**
|
* PC端-纠纷登记-保存纠纷信息-正常案件
|
*
|
* @param registerSaveDTO 实体对象
|
* @url {ctx}/api/web/caseInfo/caseRegister
|
*/
|
@PostMapping("/caseRegister")
|
public Object caseRegister(@CurrentUser String userId, @RequestBody RegisterSaveDTO registerSaveDTO) {
|
try {
|
// if (StringUtils.isEmpty(registerSaveDTO.getQueRoad())) {
|
// return ReturnFailUtils.getRepInfo("问题属地镇街不能为空，请重新选择！");
|
// }
|
String caseId = service.caseRegister(registerSaveDTO, userId);
|
//如果存在草稿，则删除
|
casedraftInfoService.deleteCaseDraft(registerSaveDTO.getId());
|
return ReturnSucUtils.getRepInfo(caseId);
|
} catch (Exception e) {
|
return ReturnFailUtils.getRepInfo(e.getMessage());
|
}
|
}
|
|
/**
|
* PC端-正式案件-查询纠纷信息
|
*
|
* @param id 纠纷编号
|
* @return Object
|
* @url {ctx}/api/web/caseInfo/getCaseInfo?id=
|
*/
|
@GetMapping("/getCaseInfo")
|
public Object getCaseInfo(@RequestParam(value = "id") String id) {
|
try {
|
return ReturnSucUtils.getRepInfo(service.getCaseInfo(id));
|
} catch (Exception e) {
|
return ReturnFailUtils.getRepInfo(e.getMessage());
|
}
|
}
|
|
/**
|
* PC端-查询档案信息
|
*
|
* @param id 纠纷编号
|
* @return Object
|
* @url {ctx}/api/web/caseInfo/getCaseArchivesInfo?id=
|
*/
|
@GetMapping("/getCaseArchivesInfo")
|
public Object getCaseArchivesInfo(@RequestParam(value = "id") String id) {
|
try {
|
return ReturnSucUtils.getRepInfo(service.getCaseArchivesInfo(id));
|
} catch (Exception e) {
|
return ReturnFailUtils.getRepInfo(e.getMessage());
|
}
|
}
|
|
|
/**
|
* 综合查询
|
*
|
* @param page 页码
|
* @param size 每页数量
|
* @return Object
|
* @url {ctx}/api/web/caseInfo/pageQueryAll
|
*/
|
@GetMapping("/pageQueryAll")
|
public Object pageQueryAll(@RequestParam(value = "page") int page, @RequestParam(value = "size") int size) {
|
try {
|
Map<String, Object> terms = getParameterAll();
|
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 = "a.create_time";
|
break;
|
case 2:
|
sortName = "b.close_time";
|
break;
|
}
|
switch (sortType) {
|
case 1:
|
sort = Sort.by(Sort.Direction.ASC, sortName);
|
break;
|
case 2:
|
sort = Sort.by(Sort.Direction.DESC, sortName);
|
break;
|
}
|
if (ObjectUtils.isEmpty(sort)) {
|
sort = Sort.by(Sort.Direction.DESC, "a.create_time");
|
}
|
PageRequest pageRequest = PageRequest.of(page - 1, size, sort);
|
Page<CasePageDTO> caseInfoPage = service.pageQueryAll(pageRequest, terms);
|
return ReturnSucUtils.getRepInfo("处理成功", caseInfoPage);
|
} catch (Exception e) {
|
log.error("Controller接口[CaseInfoWebController.pageQueryAll]请求异常：" + e, e);
|
return ReturnFailUtils.getRepInfo();
|
}
|
}
|
|
/**
|
* 解纷态势-区域列表
|
*
|
* @param page 页码
|
* @param size 每页数量
|
* @return Object
|
* @url {ctx}/api/web/caseInfo/pageQueryArea
|
*/
|
@GetMapping("/pageQueryArea")
|
public Object pageQueryArea(@RequestParam(value = "page") int page, @RequestParam(value = "size") int size) {
|
try {
|
Map<String, Object> terms = getParameterAll();
|
Sort sort = null;
|
String sortName = null;
|
String sortColmnStr = request.getParameter("sortColmn");
|
String sortTypeStr = request.getParameter("sortType");
|
String areaType = request.getParameter("areaType");
|
terms.put("areaType", areaType);
|
String unitGrades = request.getParameter("unitGrades");
|
if(ObjectUtils.isNotEmpty(unitGrades)){
|
String[] split = unitGrades.split(",");
|
List<String> unitGradeList = new ArrayList<>();
|
for (String s : split) {
|
unitGradeList.add(s);
|
}
|
terms.put("unitGrades", unitGradeList);
|
}
|
//统计条件 resolveType 1-化解中，2-已结案，3-不予受理
|
String resolveType = request.getParameter("resolveType");
|
if(ObjectUtils.isNotEmpty(unitGrades)){
|
terms.put("resolveType", resolveType);
|
}
|
|
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 = "a.create_time";
|
break;
|
case 2:
|
sortName = "b.close_time";
|
break;
|
}
|
switch (sortType) {
|
case 1:
|
sort = Sort.by(Sort.Direction.ASC, sortName);
|
break;
|
case 2:
|
sort = Sort.by(Sort.Direction.DESC, sortName);
|
break;
|
}
|
if (ObjectUtils.isEmpty(sort)) {
|
sort = Sort.by(Sort.Direction.DESC, "a.create_time");
|
}
|
PageRequest pageRequest = PageRequest.of(page - 1, size, sort);
|
Page<CasePageDTO> caseInfoPage = service.pageQueryArea(pageRequest, terms);
|
return ReturnSucUtils.getRepInfo("处理成功", caseInfoPage);
|
} catch (Exception e) {
|
log.error("Controller接口[CaseInfoWebController.pageQueryAll]请求异常：" + e, e);
|
return ReturnFailUtils.getRepInfo();
|
}
|
}
|
|
|
/**
|
* 综合查询-导出
|
*
|
* @return Object
|
* @url {ctx}/api/web/caseInfo/exportQueryAll
|
*/
|
@RequestMapping("/exportQueryAll")
|
public Object exportQueryAll(HttpServletResponse response) {
|
try {
|
Map<String, Object> terms = getParameterAll();
|
String createStart = request.getParameter("createStart");
|
String createEnd = request.getParameter("createEnd");
|
if(ObjectUtils.isEmpty(createStart) || ObjectUtils.isEmpty(createEnd)){
|
return ReturnFailUtils.getRepInfo("请选择登记时间区间");
|
}
|
//计算两个时间的天数
|
DateTimeFormatter formatter = DateTimeFormatter.ofPattern("yyyy-MM-dd");
|
LocalDate date1 = LocalDate.parse(createStart, formatter);
|
LocalDate date2 = LocalDate.parse(createEnd, formatter);
|
long daysBetween = ChronoUnit.DAYS.between(date1, date2);
|
if(daysBetween > 366){
|
return ReturnFailUtils.getRepInfo("选择登记时间区间不能大于1年");
|
}
|
|
Sort sort = Sort.by(Sort.Direction.DESC, "a.create_time");
|
PageRequest pageRequest = PageRequest.of(0, 100000, sort);
|
terms.put("report", "report");
|
Page<CasePageDTO> caseInfoPage = service.pageQueryAll(pageRequest, terms);
|
List<CaseInfoWeExcelDTO> excelList = new ArrayList<>();
|
if (ObjectUtils.isNotEmpty(caseInfoPage.getContent())) {
|
int i = 1;
|
for (CasePageDTO casePageDTO : caseInfoPage.getContent()) {
|
String extreme = "否";
|
CaseInfoWeExcelDTO caseInfoWeExcelDTO = new CaseInfoWeExcelDTO();
|
BeanUtils.copyProperties(casePageDTO, caseInfoWeExcelDTO);
|
caseInfoWeExcelDTO.setSysSource("本系统");
|
Map<String,String> personMap = new HashMap<>();
|
//申请人
|
if(ObjectUtils.isNotEmpty(casePageDTO.getPlaintiffList())){
|
StringBuffer sb = new StringBuffer();
|
for (CasePersonWeDTO casePersonWeDTO : casePageDTO.getPlaintiffList()) {
|
if(ObjectUtils.isNotEmpty(casePersonWeDTO.getExtreme()) && casePersonWeDTO.getExtreme().equals(1)){
|
extreme = "是";
|
}
|
personMap.put(casePersonWeDTO.getId(), casePersonWeDTO.getTrueName());
|
if(CaseBaseConstsEnum.PERSON_CLASS_1.getIndex().equals(casePersonWeDTO.getPerClass())){
|
sb.append(casePersonWeDTO.getTrueName());
|
if(ObjectUtils.isNotEmpty(casePersonWeDTO.getCertiNo())){
|
sb.append("(").append(casePersonWeDTO.getCertiNo()).append(")");
|
}
|
sb.append("、");
|
}else{
|
sb.append(casePersonWeDTO.getTrueName());
|
if(ObjectUtils.isNotEmpty(casePersonWeDTO.getOrgaCode())){
|
sb.append("(").append(casePersonWeDTO.getOrgaCode()).append(")");
|
}
|
sb.append("、");
|
}
|
}
|
//申请代理人
|
if(ObjectUtils.isNotEmpty(casePageDTO.getAgentList())){
|
for (CaseAgentWeDTO caseAgentWeDTO : casePageDTO.getAgentList()) {
|
if (CaseBaseConstsEnum.PERSON_TYPE_3.getIndex().equals(caseAgentWeDTO.getPerType())) {
|
sb.append(caseAgentWeDTO.getTrueName());
|
sb.append("(");
|
if(ObjectUtils.isNotEmpty(caseAgentWeDTO.getCertiNo())){
|
sb.append(caseAgentWeDTO.getCertiNo()).append(",");
|
}
|
sb.append("代理对象：");
|
if(ObjectUtils.isNotEmpty(personMap.get(caseAgentWeDTO.getPersonId()))){
|
String[] split = caseAgentWeDTO.getPersonId().split(",");
|
Boolean isfrist = true;
|
for (String personId : split) {
|
if(isfrist){
|
sb.append(personMap.get(personId));
|
isfrist = false;
|
}else{
|
sb.append(",").append(personMap.get(personId));
|
}
|
}
|
}
|
sb.append(")").append("、");
|
}
|
}
|
}
|
caseInfoWeExcelDTO.setPlaintiffs(sb.substring(0, sb.length() - 1));
|
}
|
//被申请人
|
if(ObjectUtils.isNotEmpty(casePageDTO.getDefendantList())){
|
StringBuffer sb = new StringBuffer();
|
for (CasePersonWeDTO casePersonWeDTO : casePageDTO.getDefendantList()) {
|
personMap.put(casePersonWeDTO.getId(), casePersonWeDTO.getTrueName());
|
if(CaseBaseConstsEnum.PERSON_CLASS_1.getIndex().equals(casePersonWeDTO.getPerClass())){
|
sb.append(casePersonWeDTO.getTrueName());
|
if(ObjectUtils.isNotEmpty(casePersonWeDTO.getCertiNo())){
|
sb.append("(").append(casePersonWeDTO.getCertiNo()).append(")");
|
}
|
sb.append("、");
|
}else{
|
sb.append(casePersonWeDTO.getTrueName());
|
if(ObjectUtils.isNotEmpty(casePersonWeDTO.getOrgaCode())){
|
sb.append("(").append(casePersonWeDTO.getOrgaCode()).append(")");
|
}
|
sb.append("、");
|
}
|
}
|
//被申请代理人
|
if(ObjectUtils.isNotEmpty(casePageDTO.getAgentList())){
|
for (CaseAgentWeDTO caseAgentWeDTO : casePageDTO.getAgentList()) {
|
if (CaseBaseConstsEnum.PERSON_TYPE_4.getIndex().equals(caseAgentWeDTO.getPerType())) {
|
sb.append(caseAgentWeDTO.getTrueName());
|
sb.append("(");
|
if(ObjectUtils.isNotEmpty(caseAgentWeDTO.getCertiNo())){
|
sb.append(caseAgentWeDTO.getCertiNo()).append(",");
|
}
|
sb.append("代理对象：");
|
if(ObjectUtils.isNotEmpty(personMap.get(caseAgentWeDTO.getPersonId()))){
|
String[] split = caseAgentWeDTO.getPersonId().split(",");
|
Boolean isfrist = true;
|
for (String personId : split) {
|
if(isfrist){
|
sb.append(personMap.get(personId));
|
isfrist = false;
|
}else{
|
sb.append(",").append(personMap.get(personId));
|
}
|
}
|
}
|
sb.append(")").append("、");
|
}
|
}
|
}
|
caseInfoWeExcelDTO.setDefendants(sb.substring(0, sb.length() - 1));
|
}
|
caseInfoWeExcelDTO.setCloseTime(DateUtils.DateToString(casePageDTO.getCloseTime(), "yyyy/MM/dd"));
|
caseInfoWeExcelDTO.setCreateTime(DateUtils.DateToString(casePageDTO.getCreateTime(), "yyyy/MM/dd"));
|
caseInfoWeExcelDTO.setVisitTime(DateUtils.DateToString(casePageDTO.getVisitTime(), "yyyy/MM/dd"));
|
caseInfoWeExcelDTO.setOccurTime(DateUtils.DateToString(casePageDTO.getOccurTime(), "yyyy/MM/dd"));
|
caseInfoWeExcelDTO.setPeopleNum(casePageDTO.getPeopleNum()+"");
|
caseInfoWeExcelDTO.setAmount(casePageDTO.getAmount()+"");
|
caseInfoWeExcelDTO.setExtreme(extreme);
|
if(ObjectUtils.isNotEmpty(casePageDTO.getMajorStatus())){
|
switch (casePageDTO.getMajorStatus()) {
|
case 1:
|
caseInfoWeExcelDTO.setMajorStatus("是");
|
break;
|
case 0:
|
caseInfoWeExcelDTO.setMajorStatus("否");
|
break;
|
}
|
}
|
caseInfoWeExcelDTO.setSort(i+"");
|
i++;
|
excelList.add(caseInfoWeExcelDTO);
|
}
|
}
|
String fileName = "矛盾纠纷应用纠纷数据台账.xlsx";
|
response.setCharacterEncoding("UTF-8");
|
response.setHeader("content-Type", "application/vnd.ms-excel;charset=UTF-8");
|
response.setHeader("Content-Disposition", "attachment;filename=" + URLEncoder.encode(fileName, "UTF-8"));
|
ServletOutputStream outputStream = response.getOutputStream();
|
EasyExcel.write(outputStream, CaseInfoWeExcelDTO.class).sheet("矛盾纠纷应用纠纷数据台账").doWrite(excelList);
|
} catch (Exception e) {
|
log.error("Controller接口[CaseInfoWebController.exportQueryAll]请求异常：" + e, e);
|
}
|
return ReturnSucUtils.getRepInfo("处理成功");
|
}
|
|
/**
|
* 解纷态势
|
*
|
* @return Object
|
* @url {ctx}/api/web/caseInfo/statistics
|
* @CurrentUser String userId
|
*/
|
@GetMapping("/statistics")
|
public Object statistics(@CurrentUser String userId) {
|
try {
|
// String userId = "2409240631181052";
|
Map<String, Object> terms = getParameterAll();
|
return ReturnSucUtils.getRepInfo("处理成功", service.statistics(terms, userId));
|
} catch (Exception e) {
|
log.error("Controller接口[CaseInfoWebController.statistics]请求异常：" + e, e);
|
return ReturnFailUtils.getRepInfo();
|
}
|
}
|
|
/**
|
* 解纷态势
|
*
|
* @return Object
|
* @url {ctx}/api/web/caseInfo/exportStatisticsArea
|
* @CurrentUser String userId
|
*/
|
@GetMapping("/exportStatisticsArea")
|
public Object exportStatisticsArea(HttpServletResponse response) {
|
try {
|
Map<String, Object> terms = getParameterAll();
|
CaseStatisticsBaseDTO statistics = service.statistics(terms, null);
|
List<CaseInfoWeAreaExcelDTO> excelList = new ArrayList<>();
|
if(ObjectUtils.isNotEmpty(statistics.getAreaList())){
|
int i = 1;
|
for (CaseStatisticsAreaDTO caseStatisticsAreaDTO : statistics.getAreaList()) {
|
CaseInfoWeAreaExcelDTO caseInfoWeAreaExcelDTO = new CaseInfoWeAreaExcelDTO();
|
BeanUtils.copyProperties(caseStatisticsAreaDTO, caseInfoWeAreaExcelDTO);
|
caseInfoWeAreaExcelDTO.setSort(i+"");
|
caseInfoWeAreaExcelDTO.setFinishNUm(caseStatisticsAreaDTO.getResolveNum()+caseStatisticsAreaDTO.getUnResolveNum());
|
excelList.add(caseInfoWeAreaExcelDTO);
|
i++;
|
}
|
}
|
String fileName = "矛盾纠纷应用纠纷地区统计数据.xlsx";
|
response.setCharacterEncoding("UTF-8");
|
response.setHeader("content-Type", "application/vnd.ms-excel;charset=UTF-8");
|
response.setHeader("Content-Disposition", "attachment;filename=" + URLEncoder.encode(fileName, "UTF-8"));
|
ServletOutputStream outputStream = response.getOutputStream();
|
EasyExcel.write(outputStream, CaseInfoWeAreaExcelDTO.class).sheet("矛盾纠纷应用纠纷地区统计数据").doWrite(excelList);
|
} catch (Exception e) {
|
log.error("Controller接口[CaseInfoWebController.exportStatisticsArea]请求异常：" + e, e);
|
}
|
return ReturnSucUtils.getRepInfo("处理成功");
|
}
|
|
/**
|
* 解纷态势-纠纷类型
|
*
|
* @return Object
|
* @url {ctx}/api/web/caseInfo/statisticsCaseType
|
* @CurrentUser String userId
|
*/
|
@GetMapping("/statisticsCaseType")
|
public Object statisticsCaseType(@CurrentUser String userId) {
|
try {
|
Map<String, Object> terms = getParameterAll();
|
return ReturnSucUtils.getRepInfo("处理成功", service.statisticsCaseType(terms, userId));
|
} catch (Exception e) {
|
log.error("Controller接口[CaseInfoWebController.statistics]请求异常：" + e, e);
|
return ReturnFailUtils.getRepInfo();
|
}
|
}
|
|
/**
|
* 小程序是否可见修改修改
|
*
|
* @return Object
|
* @url {ctx}/api/web/caseInfo/updateVisibleStatus
|
* @CurrentUser String userId
|
*/
|
@PostMapping("/updateVisibleStatus")
|
public Object updateVisibleStatus(@RequestBody CaseInfo caseInfo) {
|
try {
|
service.updateCaseInfo(caseInfo);
|
return ReturnSucUtils.getRepInfo();
|
} catch (Exception e) {
|
log.error("Controller接口[CaseInfoWebController.statistics]请求异常：" + e, e);
|
return ReturnFailUtils.getRepInfo();
|
}
|
}
|
|
/**
|
* 个人查询
|
*
|
* @param page 页码
|
* @param size 每页数量
|
* @return Object
|
* @url {ctx}/api/web/caseInfo/pagePerson
|
*/
|
@GetMapping("/pagePerson")
|
public Object pagePerson(@RequestParam(value = "page") int page, @RequestParam(value = "size") int size, @RequestParam(value = "certiNo") String certiNo) {
|
try {
|
Map<String, Object> terms = getParameterAll();
|
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 = "a.create_time";
|
break;
|
case 2:
|
sortName = "b.close_time";
|
break;
|
}
|
switch (sortType) {
|
case 1:
|
sort = Sort.by(Sort.Direction.ASC, sortName);
|
break;
|
case 2:
|
sort = Sort.by(Sort.Direction.DESC, sortName);
|
break;
|
}
|
if (ObjectUtils.isEmpty(sort)) {
|
sort = Sort.by(Sort.Direction.DESC, "a.create_time");
|
}
|
PageRequest pageRequest = PageRequest.of(page - 1, size, sort);
|
Page<CasePageDTO> caseInfoPage = service.pagePerson(pageRequest, terms, certiNo);
|
return ReturnSucUtils.getRepInfo("处理成功", caseInfoPage);
|
} catch (Exception e) {
|
log.error("Controller接口[CaseInfoWebController.pageQueryAll]请求异常：" + e, e);
|
return ReturnFailUtils.getRepInfo();
|
}
|
}
|
|
/**
|
* 个人查询统计
|
*
|
* @return Object
|
* @url {ctx}/api/web/caseInfo/countPerson
|
*/
|
@GetMapping("/countPerson")
|
public Object countPerson(@RequestParam(value = "certiNo") String certiNo) {
|
try {
|
CasePersonCountBO casePersonCountBO = service.countPerson(certiNo);
|
return ReturnSucUtils.getRepInfo("处理成功", casePersonCountBO);
|
} catch (Exception e) {
|
log.error("Controller接口[CaseInfoWebController.pageQueryAll]请求异常：" + e, e);
|
return ReturnFailUtils.getRepInfo();
|
}
|
}
|
|
/**
|
* 概况统计
|
*
|
* @return Object
|
* @url {ctx}/api/web/caseInfo/overview
|
*/
|
@GetMapping(value = "overview")
|
public Object overview() {
|
try {
|
Map<String, Object> terms = getParameterOverview();
|
return ReturnSucUtils.getRepInfo(service.overview(terms));
|
} catch (Exception e) {
|
log.error("Controller接口[CaseInfoWebController.overview]请求异常：" + e, e);
|
return ReturnFailUtils.getRepInfo();
|
}
|
}
|
|
|
/**
|
* 综合查询-导出
|
*
|
* @return Object
|
* @url {ctx}/api/web/caseInfo/exportOverview
|
*/
|
@RequestMapping("/exportOverview")
|
public void exportOverview(HttpServletResponse response) {
|
try {
|
Map<String, Object> terms = getParameterOverview();
|
CaseOverviewDTO overview = service.overview(terms);
|
List<CaseOverviewDetailDTO> childList = overview.getChildList();
|
childList.add(overview.getParent());
|
List<CaseOverviewRoadExcelDTO> excelList = new ArrayList<>();
|
if (ObjectUtils.isNotEmpty(childList)) {
|
for (CaseOverviewDetailDTO child : childList) {
|
CaseOverviewRoadExcelDTO caseOverviewExcelDTO = new CaseOverviewRoadExcelDTO();
|
BeanUtils.copyProperties(child, caseOverviewExcelDTO);
|
excelList.add(caseOverviewExcelDTO);
|
}
|
}
|
String fileName = "系统使用情况.xlsx";
|
response.setCharacterEncoding("UTF-8");
|
response.setHeader("content-Type", "application/vnd.ms-excel;charset=UTF-8");
|
response.setHeader("Content-Disposition", "attachment;filename=" + URLEncoder.encode(fileName, "UTF-8"));
|
ServletOutputStream outputStream = response.getOutputStream();
|
if ("2".equals(terms.get("areaType"))) {
|
EasyExcel.write(outputStream, CaseOverviewAreaExcelDTO.class).sheet("系统使用情况").doWrite(excelList);
|
} else {
|
|
EasyExcel.write(outputStream, CaseOverviewRoadExcelDTO.class).sheet("系统使用情况").doWrite(excelList);
|
}
|
} catch (Exception e) {
|
log.error("Controller接口[CaseInfoWebController.exportOverview]请求异常：" + e, e);
|
}
|
|
}
|
|
/**
|
* 解纷态势
|
*
|
* @return Object
|
* @url {ctx}/api/web/caseInfo/ledger
|
* @CurrentUser String userId
|
*/
|
@GetMapping("/ledger")
|
public Object ledger(@CurrentUser String userId) {
|
try {
|
Map<String, Object> terms = getParameterAll();
|
// 查询类型 1-本系统，2-12345，3-人民调解，4-信访，5-劳动仲裁，6-非警务纠纷
|
String ledgerType = request.getParameter("ledgerType");
|
|
//所有表里面的数据都是本系统，其他的后续会新建表存储
|
if(ObjectUtils.isNotEmpty(ledgerType) && !"1".equals(ledgerType)){
|
terms.put("canal", "-1");
|
}
|
return ReturnSucUtils.getRepInfo("处理成功", service.ledger(terms, userId, ledgerType));
|
} catch (Exception e) {
|
log.error("Controller接口[CaseInfoWebController.ledger]请求异常：" + e, e);
|
return ReturnFailUtils.getRepInfo();
|
}
|
}
|
|
/**
|
* 解纷态势
|
*
|
* @return Object
|
* @url {ctx}/api/web/caseInfo/ledgerCount
|
* @CurrentUser String userId
|
*/
|
@GetMapping("/ledgerCount")
|
public Object ledgerCount(@CurrentUser String userId) {
|
try {
|
Map<String, Object> terms = getParameterAll();
|
// 查询类型 1-本系统，2-12345，3-人民调解，4-信访，5-劳动仲裁，6-非警务纠纷
|
String ledgerType = request.getParameter("ledgerType");
|
|
//所有表里面的数据都是本系统，其他的后续会新建表存储
|
if(ObjectUtils.isNotEmpty(ledgerType) && !"1".equals(ledgerType)){
|
terms.put("canal", "-1");
|
}
|
return ReturnSucUtils.getRepInfo("处理成功", service.ledgerCount(terms, userId));
|
} catch (Exception e) {
|
log.error("Controller接口[CaseInfoWebController.ledger]请求异常：" + e, e);
|
return ReturnFailUtils.getRepInfo();
|
}
|
}
|
|
/**
|
* 查询重复事项
|
* @url {ctx}/api/web/caseInfo/listRepeatCase
|
* @param caseId 案件编号
|
* @param userId 登录用户
|
* @return Object
|
*/
|
@GetMapping("/listRepeatCase")
|
public Object listRepeatCase( @RequestParam(value = "caseId") String caseId, @CurrentUser String userId) {
|
try {
|
return ReturnSucUtils.getRepInfo(caseRepeatService.listRepeatCase(caseId));
|
} catch (Exception e) {
|
log.error("Controller接口[CaseInfoWebController.listRepeatCase]请求异常：" + e, e);
|
return ReturnFailUtils.getRepInfo();
|
}
|
}
|
|
/**
|
*
|
* 协同推送-网格推送案件入库
|
* @param registerSaveDTO 实体对象
|
* @url {ctx}/api/web/caseInfo/gridCaseRegister
|
*/
|
@PostMapping("/gridCaseRegister")
|
public Object gridCaseRegister(@RequestBody RegisterSaveDTO registerSaveDTO) {
|
try {
|
String caseId = service.gridCaseRegister(registerSaveDTO);
|
return ReturnSucUtils.getRepInfo(caseId);
|
} catch (Exception e) {
|
return ReturnFailUtils.getRepInfo(e.getMessage());
|
}
|
}
|
}
|
