鞍钢鲅鱼圈能源管控系统后端代码
dengzedong
2025-05-19 2534683a07965bf3151fd1eac17f7798cd431f96
概况 停机时间保留0位
已修改2个文件
4 ■■■■ 文件已修改
ansteel-biz/src/main/java/com/iailab/module/ansteel/coking/entity/CokingOverviewEntity.java 2 ●●● 补丁 | 查看 | 原始文档 | blame | 历史
ansteel-biz/src/main/java/com/iailab/module/ansteel/coking/service/impl/CokingOverviewServiceImpl.java 2 ●●● 补丁 | 查看 | 原始文档 | blame | 历史
ansteel-biz/src/main/java/com/iailab/module/ansteel/coking/entity/CokingOverviewEntity.java
@@ -75,7 +75,7 @@
     */
    private BigDecimal powerCStandard;
    /**
     * 空转时间
     * 停机时间
     */
    private BigDecimal idleTime;
    /**
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);