From b497b0d4935e5a04680909ad4f14e08d3295e59f Mon Sep 17 00:00:00 2001
From: xusd <hugeinfo123>
Date: Mon, 23 Sep 2024 20:51:21 +0800
Subject: [PATCH] 首页登记记录接口
---
dyh-service/dyh-mediate/src/main/java/cn/huge/module/cases/dao/mapper/xml/CaseInfoMapper.xml | 12 ++----
dyh-service/dyh-mediate/src/main/java/cn/huge/module/cases/controller/web/CaseRegisterInfoWebController.java | 52 ++++++++++++++-----------
2 files changed, 33 insertions(+), 31 deletions(-)
diff --git a/dyh-service/dyh-mediate/src/main/java/cn/huge/module/cases/controller/web/CaseRegisterInfoWebController.java b/dyh-service/dyh-mediate/src/main/java/cn/huge/module/cases/controller/web/CaseRegisterInfoWebController.java
index 561f1ff..6307b5d 100644
--- a/dyh-service/dyh-mediate/src/main/java/cn/huge/module/cases/controller/web/CaseRegisterInfoWebController.java
+++ b/dyh-service/dyh-mediate/src/main/java/cn/huge/module/cases/controller/web/CaseRegisterInfoWebController.java
@@ -28,82 +28,88 @@
public class CaseRegisterInfoWebController {
@Autowired(required = false)
private HttpServletRequest request;
- private Map<String, Object> getParameter(){
+
+ private Map<String, Object> getParameter() {
Map<String, Object> terms = Maps.newHashMap();
// 登记部门
String inputUnitName = request.getParameter("inputUnitName");
- if (org.apache.commons.lang3.StringUtils.isNotBlank(inputUnitName)){
+ if (org.apache.commons.lang3.StringUtils.isNotBlank(inputUnitName)) {
terms.put("inputUnitName", inputUnitName);
}
// 事项等级
String caseLevel = request.getParameter("caseLevel");
- if (org.apache.commons.lang3.StringUtils.isNotBlank(caseLevel)){
- terms.put("caseLevel", caseLevel);
+ if (org.apache.commons.lang3.StringUtils.isNotBlank(caseLevel)) {
+ if (caseLevel.equals("三级"))
+ terms.put("caseLevel", 3);
+ else if (caseLevel.equals("二级"))
+ terms.put("caseLevel", 2);
+ else
+ terms.put("caseLevel", 1);
}
// 纠纷一级类型
String caseTypeFirst = request.getParameter("caseTypeFirst");
- if (org.apache.commons.lang3.StringUtils.isNotBlank(caseTypeFirst)){
+ if (org.apache.commons.lang3.StringUtils.isNotBlank(caseTypeFirst)) {
terms.put("caseTypeFirst", caseTypeFirst);
}
// 纠纷一级类型名称
String caseTypeFirstName = request.getParameter("caseTypeFirstName");
- if (org.apache.commons.lang3.StringUtils.isNotBlank(caseTypeFirstName)){
+ if (org.apache.commons.lang3.StringUtils.isNotBlank(caseTypeFirstName)) {
terms.put("caseTypeFirstName", caseTypeFirstName);
}
// 纠纷类型
String caseType = request.getParameter("caseType");
- if (org.apache.commons.lang3.StringUtils.isNotBlank(caseType)){
+ if (org.apache.commons.lang3.StringUtils.isNotBlank(caseType)) {
terms.put("caseType", caseType);
}
// 纠纷类型名称
String caseTypeName = request.getParameter("caseTypeName");
- if (org.apache.commons.lang3.StringUtils.isNotBlank(caseTypeName)){
+ if (org.apache.commons.lang3.StringUtils.isNotBlank(caseTypeName)) {
terms.put("caseTypeName", caseTypeName);
}
// 事项来源
String canal = request.getParameter("canal");
- if (org.apache.commons.lang3.StringUtils.isNotBlank(canal)){
+ if (org.apache.commons.lang3.StringUtils.isNotBlank(canal)) {
terms.put("canal", canal);
}
// 事项来源名称
String canalName = request.getParameter("canalName");
- if (org.apache.commons.lang3.StringUtils.isNotBlank(canalName)){
+ if (org.apache.commons.lang3.StringUtils.isNotBlank(canalName)) {
terms.put("canalName", canalName);
}
// 申请方当事人名称
String plaintiffs = request.getParameter("plaintiffs");
- if (org.apache.commons.lang3.StringUtils.isNotBlank(plaintiffs)){
+ if (org.apache.commons.lang3.StringUtils.isNotBlank(plaintiffs)) {
terms.put("plaintiffs", plaintiffs);
}
// 被申请方当事人名称
String defendants = request.getParameter("defendants");
- if (org.apache.commons.lang3.StringUtils.isNotBlank(defendants)){
+ if (org.apache.commons.lang3.StringUtils.isNotBlank(defendants)) {
terms.put("defendants", defendants);
}
// 事项状态，1：待分派，2：待签收，3：待受理，4：化解中，5：结案审核，6：待评价，7：已归档
String status = request.getParameter("status");
- if (org.apache.commons.lang3.StringUtils.isNotBlank(status)){
+ if (org.apache.commons.lang3.StringUtils.isNotBlank(status)) {
terms.put("status", status);
}
// 事项状态名称
String statusName = request.getParameter("statusName");
- if (org.apache.commons.lang3.StringUtils.isNotBlank(statusName)){
+ if (org.apache.commons.lang3.StringUtils.isNotBlank(statusName)) {
terms.put("statusName", statusName);
}
// 事项状态名称
String mediResultName = request.getParameter("mediResultName");
- if (org.apache.commons.lang3.StringUtils.isNotBlank(mediResultName)){
+ if (org.apache.commons.lang3.StringUtils.isNotBlank(mediResultName)) {
terms.put("mediResultName", mediResultName);
}
// 登记时间区间
String createStart = request.getParameter("createStart");
String createEnd = request.getParameter("createEnd");
- if(org.apache.commons.lang3.StringUtils.isNotBlank(createStart) && org.apache.commons.lang3.StringUtils.isNotBlank(createEnd)) {
+ if (org.apache.commons.lang3.StringUtils.isNotBlank(createStart) && org.apache.commons.lang3.StringUtils.isNotBlank(createEnd)) {
terms.put("createStart", createStart);
terms.put("createEnd", createEnd);
}
@@ -115,7 +121,7 @@
@GetMapping("/pageQuery")
public Object pageQuery(@RequestParam(value = "page") int page, @RequestParam(value = "size") int size
- ) {
+ ) {
try {
Map<String, Object> terms = getParameter();
// 排序
@@ -125,13 +131,13 @@
String sortTypeStr = request.getParameter("sortType");
int sortColmn = 1;
int sortType = 1;
- if(StringUtils.isNotBlank(sortColmnStr)){
+ if (StringUtils.isNotBlank(sortColmnStr)) {
sortColmn = Integer.valueOf(sortColmnStr);
}
- if(StringUtils.isNotBlank(sortTypeStr)){
+ if (StringUtils.isNotBlank(sortTypeStr)) {
sortType = Integer.valueOf(sortTypeStr);
}
- switch (sortColmn){
+ switch (sortColmn) {
case 1:
sortName = "t1.create_time";
break;
@@ -142,7 +148,7 @@
sortName = "t3.number";
break;
}
- switch (sortType){
+ switch (sortType) {
case 1:
sort = Sort.by(Sort.Direction.ASC, sortName);
break;
@@ -150,7 +156,7 @@
sort = Sort.by(Sort.Direction.DESC, sortName);
break;
}
- if(ObjectUtils.isEmpty(sort)){
+ if (ObjectUtils.isEmpty(sort)) {
sort = Sort.by(Sort.Direction.DESC, "t1.create_time");
}
@@ -158,7 +164,7 @@
Page<CaseRegisterDTO> caseInfoPage = service.pageQueryRegister(pageRequest, terms);
return ReturnSucUtils.getRepInfo("处理成功", caseInfoPage);
} catch (Exception e) {
- log.error("Controller接口[CaseRegisterInfoWebController.pageQuery]请求异常："+e, e);
+ log.error("Controller接口[CaseRegisterInfoWebController.pageQuery]请求异常：" + e, e);
return ReturnFailUtils.getRepInfo();
}
}
diff --git a/dyh-service/dyh-mediate/src/main/java/cn/huge/module/cases/dao/mapper/xml/CaseInfoMapper.xml b/dyh-service/dyh-mediate/src/main/java/cn/huge/module/cases/dao/mapper/xml/CaseInfoMapper.xml
index d3780bc..bd03ddb 100644
--- a/dyh-service/dyh-mediate/src/main/java/cn/huge/module/cases/dao/mapper/xml/CaseInfoMapper.xml
+++ b/dyh-service/dyh-mediate/src/main/java/cn/huge/module/cases/dao/mapper/xml/CaseInfoMapper.xml
@@ -704,23 +704,20 @@
<if test="terms.caseTypeFirstName != null and terms.caseTypeFirstName !=''">
and t1.case_type_first_name = #{caseTypeFirstName}
</if>
- <if test="terms.caseTypeName != null and terms.caseTypeName !=''">
- and t1.case_type_name = #{terms.caseTypeName}
+ <if test="terms.caseType != null and terms.caseType !=''">
+ and t1.case_type = #{terms.caseType}
</if>
<if test="terms.canal != null and terms.canal !=''">
- and t1.canal = #{canal}
+ and t1.canal = #{terms.canal}
</if>
<if test="terms.canalName != null and terms.canalName !=''">
- and t1.canal_name = #{canalName}
+ and t1.canal_name = #{terms.canalName}
</if>
<if test="terms.plaintiffs != null and terms.plaintiffs !=''">
and t1.plaintiffs = #{terms.plaintiffs}
</if>
<if test="terms.defendants != null and terms.defendants !=''">
and t1.defendants = #{terms.defendants}
- </if>
- <if test="terms.status != null and terms.status !=''">
- and t1.status = #{terms.status}
</if>
<if test="terms.statusName != null and terms.statusName !=''">
and t1.statusName = #{terms.statusName}
@@ -764,7 +761,6 @@
FROM
dyh_case_info t1
left join dyh_case_info_unfold t2 on t1.id = t2.id
- left join dyh_case_task t4 on t1.id = t4.case_id
<include refid="where-register-part"/>
</select>
<!-- 根据条件统计 -->
--
Gitblit v1.8.0