大屏 左边数据 2个完成率

LuoTong

2024-04-23 d8302146d68a0bf8a1344d55925f51cc5cfe8a41

大屏 左边数据 2个完成率

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

@@ -41,8 +41,17 @@
                ) as consultationStatistics,

                ( SELECT count(*) FROM event_grid_member_relation as mr INNER JOIN com_act as ca  on ca.community_id  = mr.grid_community_id
                       ) as gridMember

                       ) as gridMember,
                (SELECT Round( (
                        (select count(*) from com_act_easy_photo as ep INNER JOIN com_act as ca on ca.community_id = ep.community_id WHERE `status` in ('4','5') )
                                        /
                        ( select count(*) from com_act_easy_photo as ep INNER JOIN com_act as ca on ca.community_id = ep.community_id )
                ) * 100 , 2)  )  as easyPhotoPercentage ,
                (SELECT Round( (
                    (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