党建相关bug修改

101captain

2022-03-28 edffc9ed3a473c81cac495b11022e5f5ddda98b4

党建相关bug修改

 springcloud_k8s_panzhihuazhihuishequ/service_partybuilding/src/main/resources/mapper/ComPbMemberMapper.xml

@@ -277,13 +277,24 @@
                    ),
                0
            ) AS volunteerActivityDuration,
            IFNULL((
                       SELECT
                           sum( caa.duration )
                       FROM
                           com_act_act_sign AS caas
                               LEFT JOIN com_act_activity AS caa ON caa.id = caas.activity_id
                       WHERE
                           caas.user_id = #{userId} and caas.status = 1 and caa.type = 3 and caa.community_id = #{communityId}
                   ),
                   0
                ) AS partyActivityDuration,
            ( SELECT count( id ) FROM com_act_micro_wish WHERE sponsor_id = #{userId} AND `status` = 6 AND community_id = #{communityId} ) AS wishCount,
            ( SELECT count( id ) FROM com_act_easy_photo WHERE sponsor_id = #{userId} AND `status` = 4 AND community_id = #{communityId} ) AS easyCount
        FROM
            com_pb_activity_member AS cpam
            LEFT JOIN com_pb_member AS cpm ON cpm.id = cpam.member_id
            com_act_act_sign AS cpam
            LEFT JOIN com_act_activity AS caa ON caa.id = cpam.activity_id
        WHERE
            cpm.user_id = #{userId}
            cpam.user_id = #{userId} and caa.type = 3
    </select>

    <select id="getOrgDataStatistics" resultType="com.panzhihua.common.model.vos.partybuilding.ComDataStatisticsOrgVo">