花城 修改大屏微心愿数据接口

lidongdong

2024-11-07 eab08a4207e6c83292de6b8eb7107d9fc6d90dbe

花城 修改大屏微心愿数据接口

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

@@ -225,12 +225,20 @@



<!--    <select id="selectRealizePercent" resultType="com.panzhihua.common.model.vos.community.StatisticsCommVO">-->
<!--        SELECT t1.filed, t1.num, ROUND( t1.num / t2.sum * 100, 2 ) AS percent-->
<!--        FROM-->
<!--        (SELECT IF(`status` = 6,'已实现','待实现') AS filed, COUNT(`status`) AS num FROM com_act_micro_wish-->
<!--        WHERE community_id = ${communityId} AND `status` NOT IN(1,4) GROUP BY filed) t1,-->
<!--        (SELECT COUNT(id) AS sum FROM com_act_micro_wish WHERE community_id = ${communityId} AND  `status` NOT IN(1,4)) t2-->
<!--    </select>-->

    <select id="selectRealizePercent" resultType="com.panzhihua.common.model.vos.community.StatisticsCommVO">
        SELECT t1.filed, t1.num, ROUND( t1.num / t2.sum * 100, 2 ) AS percent
        FROM
        (SELECT IF(`status` = 6,'已实现','待实现') AS filed, COUNT(`status`) AS num FROM com_act_micro_wish
        WHERE community_id = ${communityId} AND `status` NOT IN(1,4) GROUP BY filed) t1,
        (SELECT COUNT(id) AS sum FROM com_act_micro_wish WHERE community_id = ${communityId} AND  `status` NOT IN(1,4)) t2
        (SELECT IF(`state` = 2,'已实现','待实现') AS filed, COUNT(`state`) AS num FROM jinhui_micro_volunteering
         GROUP BY filed) t1,
        (SELECT COUNT(id) AS sum FROM jinhui_micro_volunteering) t2
    </select>
<!--    <select id="getPassedAllImages" resultType="java.lang.String">-->
<!--        SELECT photo_path_list FROM com_act_micro_wish-->