java/zhihuishenqu.git

			@@ -51,6 +51,7 @@
			and community_id = ${communityId}
			</if>
			</where>
			order by create_at desc
			</select>


			@@ -194,6 +195,7 @@
			<select id="getReserveIndexList" resultType="com.panzhihua.common.model.vos.community.ComActReserveIndexVo">
			select id,title,type,img_type,img_url,adver_position_top,adver_position_application from com_act_reserve where `status` = 2 and is_del = 2
			and community_id = ${communityId}
			order by create_at desc
			</select>

			<select id="indexBackReserve" resultType="Integer">
			@@ -203,7 +205,7 @@
			<select id="indexHomeQuarantine" resultType="Integer">
			select count(*) from com_act_reserve t LEFT JOIN com_act_reserve_record t3 on t.id=t3.reserve_id where t.community_id = ${communityId} and t.title like '%居家隔离%'
			</select>


			<select id="indexBackReserveSub" resultType="com.panzhihua.common.model.vos.community.bigscreen.IndexReserveSub">
			select a.*,IFNULL(b.num,0) num from (select count(t2.id) as allCount,t1.key from com_act_reserve t
			LEFT JOIN com_act_reserve_sub t1 on t.id = t1.reserve_id
			@@ -229,4 +231,4 @@
			<select id="selectCommunityPhoneByReserveId" resultType="string">
			select contacts_phone from com_act_reserve t left join com_act t1 on t.community_id = t1.community_id where t.id = #{reserveId}
			</select>
			</mapper>
			</mapper>