From 9b015b51b72ba050b4c38a6ba79eb45b7065e67d Mon Sep 17 00:00:00 2001
From: Lius <Lius2225@163.com>
Date: 星期四, 25 七月 2024 10:11:52 +0800
Subject: [PATCH] 调整sql
---
lxzn-module-mdc/src/main/java/org/jeecg/modules/mdc/service/impl/MdcUtilizationRateServiceImpl.java | 22 ++++++++++++++++++++--
1 files changed, 20 insertions(+), 2 deletions(-)
diff --git a/lxzn-module-mdc/src/main/java/org/jeecg/modules/mdc/service/impl/MdcUtilizationRateServiceImpl.java b/lxzn-module-mdc/src/main/java/org/jeecg/modules/mdc/service/impl/MdcUtilizationRateServiceImpl.java
index 8c00020..3138156 100644
--- a/lxzn-module-mdc/src/main/java/org/jeecg/modules/mdc/service/impl/MdcUtilizationRateServiceImpl.java
+++ b/lxzn-module-mdc/src/main/java/org/jeecg/modules/mdc/service/impl/MdcUtilizationRateServiceImpl.java
@@ -13,7 +13,6 @@
import org.springframework.stereotype.Service;
import javax.servlet.http.HttpServletRequest;
-import java.sql.Array;
import java.util.ArrayList;
import java.util.Arrays;
import java.util.List;
@@ -85,9 +84,28 @@
for (MdcUtilizationRate mdcUtilizationRate : list) {
MdcUtilizationRateDto mdcUtilizationRateDto = new MdcUtilizationRateDto();
mdcUtilizationRateDto.setColor(mdcUtilizationRate.getRateParameterColor());
- mdcUtilizationRateDto.setTitle(mdcUtilizationRate.getMinimumRange() + "% <= " + mdcUtilizationRate.getRateParameterCategory() + " < " + mdcUtilizationRate.getMaximumRange() + "%");
+ String title;
+ if (mdcUtilizationRate.getMinimumRange() == 0) {
+ title = mdcUtilizationRate.getRateParameterCategory() + " < " + mdcUtilizationRate.getMaximumRange() + "%";
+ } else if (mdcUtilizationRate.getMaximumRange() == 100) {
+ title = mdcUtilizationRate.getRateParameterCategory() + ">= " + mdcUtilizationRate.getMinimumRange() + "%";
+ } else {
+ title = mdcUtilizationRate.getMinimumRange() + "% <= " + mdcUtilizationRate.getRateParameterCategory() + " < " + mdcUtilizationRate.getMaximumRange() + "%";
+ }
+ mdcUtilizationRateDto.setTitle(title);
result.add(mdcUtilizationRateDto);
}
return result;
}
+
+ /**
+ * 鎹被鍨嬭幏鍙栨暟鎹尯闂村拰棰滆壊
+ *
+ * @param type
+ * @return
+ */
+ @Override
+ public List<MdcUtilizationRate> getSectionByType(String type) {
+ return this.list(new LambdaQueryWrapper<MdcUtilizationRate>().eq(MdcUtilizationRate::getRateParameterType, type).orderByAsc(MdcUtilizationRate::getRateParameterLevel));
+ }
}
--
Gitblit v1.9.3