java/zhihuishenqu.git

			@@ -170,8 +170,11 @@
			</if>
			AND belong_to = temp.belong_to) AS organTotal,
			(SELECT COUNT( id ) FROM com_pb_check_unit WHERE nature_name = '企事业单位'
			<if test="commonDto.communityId != null">
			AND community_id = #{commonDto.communityId}
			<if test="commonDto.communityIds != null and commonDto.communityIds.size() >0">
			AND community_id IN
			<foreach collection="commonDto.communityIds" item="item" open="(" separator="," close=")">
			#{item}
			</foreach>
			</if>
			AND belong_to = temp.belong_to) AS businessTotal,
			(SELECT COUNT( m.id ) FROM com_pb_member m LEFT JOIN com_pb_check_unit as cpcu ON m.check_unit_id = cpcu.id WHERE m.audit_result = 1
			@@ -260,14 +263,14 @@
			#{item}
			</foreach>
			</if>
			AND AND m.check_unit_id is not null AND cpcu.nature_name = '机关单位' AND cpcu.belong_to = temp.belong_to) AS organTotal,
			AND m.check_unit_id is not null AND cpcu.nature_name = '机关单位' AND cpcu.belong_to = temp.belong_to) AS organTotal,
			(SELECT COUNT( m.id ) FROM com_pb_member m LEFT JOIN com_pb_check_unit as cpcu ON m.check_unit_id = cpcu.id WHERE m.audit_result = 1
			<if test="commonDto.communityIds != null and commonDto.communityIds.size() >0">
			AND m.community_id IN
			<foreach collection="commonDto.communityIds" item="item" open="(" separator="," close=")">
			#{item}
			</foreach>
			</if>
			<foreach collection="commonDto.communityIds" item="item" open="(" separator="," close=")">
			#{item}
			</foreach>
			</if>
			AND cpcu.nature_name = '企事业单位' AND cpcu.belong_to = temp.belong_to) AS businessTotal
			FROM (SELECT cpcu.belong_to,COUNT( m.id ) AS partyMemberTotal FROM com_pb_member m LEFT JOIN com_pb_check_unit as cpcu ON m.check_unit_id = cpcu.id WHERE m.audit_result = 1
			<if test="commonDto.communityIds != null and commonDto.communityIds.size() >0">