数据字段

LuoTong

2024-04-24 6c344ec0da6760b4276ffcedced10bc0de978559

数据字段

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

@@ -53,5 +53,12 @@
    @ApiModelProperty("会议完成率")
    private Float discussPercentage;


    @ApiModelProperty("志愿者队伍")
    private Integer volunteerTeam;
    @ApiModelProperty("志愿者组织")
    private Integer volunteerOrg;
    @ApiModelProperty("议事投票")
    private Integer discussCount;
    @ApiModelProperty("问卷调查")
    private Integer questnaireCount;
}

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

@@ -55,28 +55,34 @@
        (SELECT
            Round(
                        (
                                (
                                (  SELECT count(1) FROM (
                                    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'
                                            INNER JOIN com_act_discuss_option_user AS ou ON ou.discuss_id = ad.id GROUP BY ad.id  ) as ddd
                                ) / (
                                    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

                ) )as discussPercentage,
            ( SELECT count(*) from com_act as ca INNER JOIN com_mng_volunteer_org_team as vm on ca.community_id = vm.community_id
                where vm.parent_id != '0'
            )  AS volunteerTeam ,
            (  SELECT count(*) from com_act as ca INNER JOIN com_mng_volunteer_org_team as vm on ca.community_id = vm.community_id
                where vm.parent_id != '0'
             ) as volunteerOrg ,
            (   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 ado on ado.discuss_id = ad.id
                ) as discussCount,
        (SELECT count(*) from com_act as ca INNER JOIN com_act_questnaire as aq  on ca.community_id = aq.community_id ) as questnaireCount


    </select>