From d797dc7cdb67354e187030372e8185c86369bab6 Mon Sep 17 00:00:00 2001
From: xieb <vip_xiaobin810@163.com>
Date: Thu, 29 Feb 2024 18:22:17 +0800
Subject: [PATCH] 水库质量规则修改
---
skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/resDataCheck/feign/RulesClient.java | 33 ++++++++++++++++++++-------------
1 files changed, 20 insertions(+), 13 deletions(-)
diff --git a/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/resDataCheck/feign/RulesClient.java b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/resDataCheck/feign/RulesClient.java
index b2533db..e0f03ea 100644
--- a/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/resDataCheck/feign/RulesClient.java
+++ b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/resDataCheck/feign/RulesClient.java
@@ -50,7 +50,7 @@
String retStr = "-1";
switch (key) {
case "EQUAL": //等于
- retStr = " is null OR = '' ";
+ retStr = " is null";
break;
case "UNEQUAL": //不等于
retStr = " is not null ";
@@ -238,7 +238,7 @@
} else if (rc.getRelation().equals("OR")) {
relation = " OR ";
} else {
- relation = " WHERE ";
+ relation = " WHERE (";
}
sqlStr += relation + getPropSqlStr(rc.getBasic());
@@ -270,10 +270,15 @@
}
+ sqlStr += ")";
+
varStr = "concat(" + varStr +") AS val";
if (StringUtil.isNotBlank(rules.getIsGate())) {
- sqlStr += " and a.\"is_gate\" = " + rules.getIsGate();
+
+ String gateStr = rules.getIsGate().equals("1") ?"'有闸控制'":"'无闸控制'";
+
+ sqlStr += " and a.\"is_gate\" = " + gateStr;
}
// 拼接条件有问题，不操作
@@ -282,17 +287,19 @@
return R.fail(-1, sqlStr + "\\n 查询条件错误，请检查规则设置");
}
- Integer ret = 0;
- try {
- ret = qualityManageService.addQualityManage(id, varStr, sqlStr);
- } catch (Exception e) {
- e.printStackTrace();
- log.info("查询条件错误，请检查规则设置......：", sqlStr);
- } finally {
- log.info("执行完成......：");
- }
+ return R.data(sqlStr);
+
+// Integer ret = 0;
+// try {
+// ret = qualityManageService.addQualityManage(id, varStr, sqlStr);
+// } catch (Exception e) {
+// e.printStackTrace();
+// log.info("查询条件错误，请检查规则设置......：", sqlStr);
+// } finally {
+// log.info("执行完成......：");
+// }
// 执行sql
- return R.data(ret);
+// return R.data(ret);
}
}
--
Gitblit v1.9.3