From 033e696ffd783f3d78a16c1a359353ec6a7aeec2 Mon Sep 17 00:00:00 2001 From: dengzedong <dengzedong@email> Date: 星期三, 08 一月 2025 11:31:38 +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