java/zhihuishenqu.git

			@@ -30,7 +30,23 @@
			(select count( id ) from com_act_easy_photo t left join com_act t1 on t.community_id = t1.community_id where `status` = 5 and del_tag = 0 ) grid,
			(select count(*) from com_act_discuss t left join com_act t1 on t.community_id = t1.community_id where t.is_del =2 ) discuss,
			(select count(*) from new_fight_community_construction t left join com_act t1 on t.construction_community_id = t1.community_id) agreement,
			(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) arrivePartyMember
			(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) arrivePartyMember,

			( SELECT count(*) from automessage_transaction_event ) as transactionEvent,
			(SELECT count(*) from com_convenient_merchants as cm INNER JOIN com_act as ca on ca.community_id = cm.community_id ) as merchantsCount ,
			(
			SELECT count(*) FROM com_convenient_consultation_statistics ccs inner JOIN
			( SELECT cm.id from com_convenient_merchants as cm INNER JOIN com_act as ca on ca.community_id = cm.community_id
			where ca.app_id = 'wx118de8a734d269f0'
			) as mc on mc.id = ccs.merchant_id
			) 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
			where ca.app_id = 'wx118de8a734d269f0' ) as gridMember




			</select>
			<select id="getPopulationSpecial"
			resultType="com.panzhihua.common.model.vos.community.screen.event.EventPopulationSpecialStatisticsVO">
			@@ -323,7 +339,9 @@
			FROM
			com_act_neighbor_circle_topic_new AS ctn
			LEFT JOIN (
			SELECT * from new_fight_need_problem_inventory
			SELECT new_fight_need_problem_inventory.* from new_fight_need_problem_inventory inner join (
			SELECT community_id from com_act WHERE app_id ='wx118de8a734d269f0'
			) as ca on ca.community_id = new_fight_need_problem_inventory.community_id
			<if test="yearTime != null and yearTime != '' ">
			WHERE
			creation_time >= concat(#{yearTime},'-01-01 00:00:00')

	springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/model/vos/community/bigscreen/ScreenStatics.java	14 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史
	springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComActDaoMapper.xml	22 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史

			@@ -33,4 +33,18 @@
			private Integer agreement;
			@ApiModelProperty("报道党员")
			private Integer arrivePartyMember;

			@ApiModelProperty("办事指南")
			private Integer transactionEvent;

			@ApiModelProperty("便民商家")
			private Integer merchantsCount;

			@ApiModelProperty("商家累计资询量")
			private Integer consultationStatistics;
			@ApiModelProperty("网格员")
			private Integer gridMember;



			}