大屏 左边数据 1个完成率

LuoTong

2024-04-23 53cfb265924079c1e20ce3e149ffe3e805ed2053

大屏 左边数据 1个完成率

 springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/model/vos/community/bigscreen/ScreenStatics.java

@@ -46,5 +46,12 @@
    private Integer gridMember;


    @ApiModelProperty("随手拍完成率")
    private Float easyPhotoPercentage;
    @ApiModelProperty("微心愿成率")
    private Float microWishPercentage;
    @ApiModelProperty("会议完成率")
    private Float discussPercentage;


}

 springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComActDaoMapper.xml

@@ -51,7 +51,31 @@
                    (select count(*) from com_act_micro_wish as ep INNER JOIN com_act as ca on ca.community_id = ep.community_id WHERE `status` in ('6','5') )
                        /
                    ( select count(*) from com_act_micro_wish as ep INNER JOIN com_act as ca on ca.community_id = ep.community_id )
                ) * 100 , 2) ) as microWishPercentage
                ) * 100 , 2) ) as microWishPercentage ,
        (SELECT
            Round(
                        (
                                (
                                    SELECT
                                        count( 1 )
                                    FROM
                                        com_act_discuss AS ad
                                            INNER JOIN com_act AS ca ON ca.community_id = ad.community_id
                                            INNER JOIN com_act_discuss_option_user AS ou ON ou.discuss_option_id = ad.id
                                    WHERE
                                        ad.`status` = '5'
                                ) / (
                                    SELECT
                                        count( 1 )
                                    FROM
                                        com_act_discuss AS ad
                                            INNER JOIN com_act AS ca ON ca.community_id = ad.community_id
                                    WHERE
                                        ad.`status` = '5'
                                )
                            ) * 100,
                        2
                ) )as discussPercentage