From 83c1bbca96beb5461fff56d861214444348e86d0 Mon Sep 17 00:00:00 2001
From: liurunyu <lry9898@163.com>
Date: 星期二, 29 七月 2025 16:51:28 +0800
Subject: [PATCH] 优化SQL语句，以提高查询速度
---
pipIrr-platform/pipIrr-web/pipIrr-web-statistics/src/main/java/com/dy/pipIrrStatistics/client/ClientCtrl.java | 12 ++++++++++++
1 files changed, 12 insertions(+), 0 deletions(-)
diff --git a/pipIrr-platform/pipIrr-web/pipIrr-web-statistics/src/main/java/com/dy/pipIrrStatistics/client/ClientCtrl.java b/pipIrr-platform/pipIrr-web/pipIrr-web-statistics/src/main/java/com/dy/pipIrrStatistics/client/ClientCtrl.java
index 489e3e6..b68af91 100644
--- a/pipIrr-platform/pipIrr-web/pipIrr-web-statistics/src/main/java/com/dy/pipIrrStatistics/client/ClientCtrl.java
+++ b/pipIrr-platform/pipIrr-web/pipIrr-web-statistics/src/main/java/com/dy/pipIrrStatistics/client/ClientCtrl.java
@@ -141,6 +141,9 @@
return BaseResponseUtils.buildFail(Objects.requireNonNull(bindingResult.getFieldError()).getDefaultMessage());
}
try {
+ if(qo.getAmountSpent() == null){
+ qo.setAmountSpent(0.0D);
+ }
return BaseResponseUtils.buildSuccess(clientSv.getLargeAmountSpentClients(qo));
} catch (Exception e) {
log.error("鑾峰彇寮�鍗¤褰曞紓甯�", e);
@@ -161,6 +164,9 @@
return BaseResponseUtils.buildFail(Objects.requireNonNull(bindingResult.getFieldError()).getDefaultMessage());
}
try {
+ if(qo.getAmountSpent() == null){
+ qo.setAmountSpent(0.0D);
+ }
return BaseResponseUtils.buildSuccess(clientSv.getSmallAmountSpentClients(qo));
} catch (Exception e) {
log.error("鑾峰彇璁板綍寮傚父", e);
@@ -181,6 +187,9 @@
return BaseResponseUtils.buildFail(Objects.requireNonNull(bindingResult.getFieldError()).getDefaultMessage());
}
try {
+ if(qo.getWaterDuration() == null){
+ qo.setWaterDuration(0);
+ }
return BaseResponseUtils.buildSuccess(clientSv.getLargeWaterDurationClients(qo));
} catch (Exception e) {
log.error("鑾峰彇寮�鍗¤褰曞紓甯�", e);
@@ -201,6 +210,9 @@
return BaseResponseUtils.buildFail(Objects.requireNonNull(bindingResult.getFieldError()).getDefaultMessage());
}
try {
+ if(qo.getWaterDuration() == null){
+ qo.setWaterDuration(0);
+ }
return BaseResponseUtils.buildSuccess(clientSv.getSmallWaterDurationClients(qo));
} catch (Exception e) {
log.error("鑾峰彇寮�鍗¤褰曞紓甯�", e);
--
Gitblit v1.8.0