From 2534683a07965bf3151fd1eac17f7798cd431f96 Mon Sep 17 00:00:00 2001 From: dengzedong <dengzedong@email> Date: 星期一, 19 五月 2025 09:25:18 +0800 Subject: [PATCH] 概况 停机时间保留0位 --- ansteel-biz/src/main/java/com/iailab/module/ansteel/coking/entity/CokingOverviewEntity.java | 2 +- ansteel-biz/src/main/java/com/iailab/module/ansteel/coking/service/impl/CokingOverviewServiceImpl.java | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) diff --git a/ansteel-biz/src/main/java/com/iailab/module/ansteel/coking/entity/CokingOverviewEntity.java b/ansteel-biz/src/main/java/com/iailab/module/ansteel/coking/entity/CokingOverviewEntity.java index db5df22..c48b502 100644 --- a/ansteel-biz/src/main/java/com/iailab/module/ansteel/coking/entity/CokingOverviewEntity.java +++ b/ansteel-biz/src/main/java/com/iailab/module/ansteel/coking/entity/CokingOverviewEntity.java @@ -75,7 +75,7 @@ */ private BigDecimal powerCStandard; /** - * 空转时间 + * 停机时间 */ private BigDecimal idleTime; /** 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 53beca3..415097a 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","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") + 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(*), 0) 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