From 538cd905b0819a22651fff47150bb7dfeae45d4a Mon Sep 17 00:00:00 2001
From: zc <zyzc>
Date: 星期一, 17 十一月 2025 08:35:04 +0800
Subject: [PATCH] 111
---
zy-acs-manager/src/main/java/com/zy/acs/manager/common/domain/PageParam.java | 24 ++++++++++++++++--------
1 files changed, 16 insertions(+), 8 deletions(-)
diff --git a/zy-acs-manager/src/main/java/com/zy/acs/manager/common/domain/PageParam.java b/zy-acs-manager/src/main/java/com/zy/acs/manager/common/domain/PageParam.java
index eabae2b..e862a8c 100644
--- a/zy-acs-manager/src/main/java/com/zy/acs/manager/common/domain/PageParam.java
+++ b/zy-acs-manager/src/main/java/com/zy/acs/manager/common/domain/PageParam.java
@@ -108,11 +108,19 @@
if (this.isToUnderlineCase) {
key = Utils.toSymbolCase(key, '_');
}
- if (like) {
- queryWrapper.like(key, val);
+ String finalKey = key;
+ if (like && key.contains(timeField)) {
+ queryWrapper.and(wrapper -> wrapper.like("`" + finalKey + "`", val));
+// queryWrapper.like("`" + key + "`", val);
} else {
- queryWrapper.eq(key, val);
+ queryWrapper.and(wrapper -> wrapper.eq("`" + finalKey + "`", val));
+// queryWrapper.eq("`" + key + "`", val);
}
+// if (like) {
+// queryWrapper.like(key, val);
+// } else {
+// queryWrapper.eq(key, val);
+// }
}
}
@@ -163,7 +171,7 @@
String condition = where.getCondition();
if (i == 0) {
- queryWrapper.and(wrapper -> wrapper.like(column, condition));
+ queryWrapper.and(wrapper -> wrapper.like("`" + column + "`", condition));
} else {
queryWrapper.or().like(column, condition);
}
@@ -200,9 +208,9 @@
key = Utils.toSymbolCase(key, '_');
}
if (like) {
- queryWrapper.like(key, val);
+ queryWrapper.like("`" + key + "`", val);
} else {
- queryWrapper.eq(key, val);
+ queryWrapper.eq("`" + key + "`", val);
}
}
}
@@ -254,9 +262,9 @@
String condition = where.getCondition();
if (i == 0) {
- queryWrapper.and(wrapper -> wrapper.like(column, condition));
+ queryWrapper.and(wrapper -> wrapper.like("`" + column + "`", condition));
} else {
- queryWrapper.or().like(column, condition);
+ queryWrapper.or().like("`" + column + "`", condition);
}
}
}
--
Gitblit v1.9.1