From 2dac861d9cca95e31da45bc03e948868a8356fb3 Mon Sep 17 00:00:00 2001
From: dengzedong <dengzedong@email>
Date: 星期一, 19 五月 2025 08:48:56 +0800
Subject: [PATCH] 概况 月累计保留两位小数，炉数保留0位
---
ansteel-biz/src/main/java/com/iailab/module/ansteel/coking/service/impl/CokingOverviewServiceImpl.java | 2 +-
1 files changed, 1 insertions(+), 1 deletions(-)
diff --git a/ansteel-biz/src/main/java/com/iailab/module/ansteel/coking/service/impl/CokingOverviewServiceImpl.java b/ansteel-biz/src/main/java/com/iailab/module/ansteel/coking/service/impl/CokingOverviewServiceImpl.java
index a98421a..53beca3 100644
--- a/ansteel-biz/src/main/java/com/iailab/module/ansteel/coking/service/impl/CokingOverviewServiceImpl.java
+++ b/ansteel-biz/src/main/java/com/iailab/module/ansteel/coking/service/impl/CokingOverviewServiceImpl.java
@@ -72,7 +72,7 @@
QueryWrapper<CokingOverviewEntity> queryWrapperMonth = new QueryWrapper<>();
queryWrapperMonth.eq("process_type", processType);
queryWrapperMonth.between("clock", monthStartClock,clock);
- queryWrapperMonth.select("sub_process_type","SUM(steam_p)*30/count(*) as steam_p","SUM(dj_steam_p)*30/count(*) as dj_steam_p","SUM(steam_c)*30/count(*) as steam_c","SUM(steam_only_c)*30/count(*) as steam_only_c","SUM(steam_v)*30/count(*) as steam_v","SUM(gas_p)*30/count(*) as gas_p","SUM(gas_c)*30/count(*) as gas_c","SUM(power_c)*30/count(*) as power_c","SUM(power_only_c)*30/count(*) as power_only_c","SUM(power_c_standard)*30/count(*) as power_c_standard","SUM(idle_time)*30/count(*) as idle_time","SUM(bfg_c)*30/count(*) as bfg_c","SUM(cog_p)*30/count(*) as cog_p","SUM(cog_c)*30/count(*) as cog_c","SUM(bfg_only_c)*30/count(*) as bfg_only_c","SUM(cog_only_c)*30/count(*) as cog_only_c","SUM(gxls)*30/count(*) as gxls")
+ queryWrapperMonth.select("sub_process_type","ROUND(SUM(steam_p)*30/count(*), 2) as steam_p","ROUND(SUM(dj_steam_p)*30/count(*), 2) as dj_steam_p","ROUND(SUM(steam_c)*30/count(*), 2) as steam_c","ROUND(SUM(steam_only_c)*30/count(*), 2) as steam_only_c","ROUND(SUM(steam_v)*30/count(*), 2) as steam_v","ROUND(SUM(gas_p)*30/count(*), 2) as gas_p","ROUND(SUM(gas_c)*30/count(*), 2) as gas_c","ROUND(SUM(power_c)*30/count(*), 2) as power_c","ROUND(SUM(power_only_c)*30/count(*), 2) as power_only_c","ROUND(SUM(power_c_standard)*30/count(*), 2) as power_c_standard","ROUND(SUM(idle_time)*30/count(*), 2) as idle_time","ROUND(SUM(bfg_c)*30/count(*), 2) as bfg_c","ROUND(SUM(cog_p)*30/count(*), 2) as cog_p","ROUND(SUM(cog_c)*30/count(*), 2) as cog_c","ROUND(SUM(bfg_only_c)*30/count(*), 2) as bfg_only_c","ROUND(SUM(cog_only_c)*30/count(*), 2) as cog_only_c","ROUND(SUM(gxls)*30/count(*), 0) as gxls")
.groupBy("sub_process_type");
List<CokingOverviewEntity> monthList = cokingOverviewDao.selectList(queryWrapperMonth);
--
Gitblit v1.9.3