From 05a1bbf8c7f01498d084b04c30652bb685b333bb Mon Sep 17 00:00:00 2001
From: 潘志宝 <979469083@qq.com>
Date: 星期五, 08 十一月 2024 09:36:04 +0800
Subject: [PATCH] 计划数据动态查询
---
iailab-module-data/iailab-module-data-biz/src/main/java/com/iailab/module/data/plan/item/collection/PlanItemCollector.java | 8 +++++---
1 files changed, 5 insertions(+), 3 deletions(-)
diff --git a/iailab-module-data/iailab-module-data-biz/src/main/java/com/iailab/module/data/plan/item/collection/PlanItemCollector.java b/iailab-module-data/iailab-module-data-biz/src/main/java/com/iailab/module/data/plan/item/collection/PlanItemCollector.java
index e46e544..4e116ea 100644
--- a/iailab-module-data/iailab-module-data-biz/src/main/java/com/iailab/module/data/plan/item/collection/PlanItemCollector.java
+++ b/iailab-module-data/iailab-module-data-biz/src/main/java/com/iailab/module/data/plan/item/collection/PlanItemCollector.java
@@ -93,10 +93,12 @@
StringBuilder whereSql = new StringBuilder();
String startStr = DateUtils.format(startTime, DateUtils.DATE_NUMBER_PATTERN);
String endStr = DateUtils.format(endTime, DateUtils.DATE_NUMBER_PATTERN);
- whereSql.append(" plan_t.start_time <= ")
+ whereSql.append(" plan_t.start_time <= '")
.append(endStr)
- .append(" and plan_t.end_time >= ")
- .append(startStr);
+ .append("'")
+ .append(" and plan_t.end_time >= '")
+ .append(startStr)
+ .append("'");
params.put("whereSql", whereSql.toString());
return params;
}
--
Gitblit v1.9.3