java/zhihuishenqu.git

			@@ -266,7 +266,7 @@
			@Select("SELECT \n" +
			"COUNT(DISTINCT u.user_id)allUser,\n" +
			"(select COUNT(m.id) from com_mng_volunteer_mng m where m.community_id=#{communityId} and m.`state`=2)volunteerUser,\n" +
			"COUNT(case when u.is_partymember=1 then u.user_id else null end )partymemberUser,\n" +
			"COUNT(DISTINCT case when u.is_partymember=1 then u.user_id else null end )partymemberUser,\n" +
			"COUNT(h.id)house\n" +
			"FROM\n" +
			"sys_user u\n" +
			@@ -393,4 +393,26 @@
			" </if> " +
			"</script>")
			List<EexcelUserDTO> selectExport(@Param("exportUserDTO") ExportUserDTO exportUserDTO);

			@Select("SELECT\n" +
			"\t COUNT(a.id)\n" +
			"FROM\n" +
			"\t com_pb_member_role a \n" +
			"WHERE\n" +
			"\t a.phone = #{phone}")
			Integer selectCountMemberRole(@Param("phone")String phone);

			@Select("SELECT\n" +
			"\t COUNT(a.id)\n" +
			"FROM\n" +
			"\t com_pb_service_team a \n" +
			"WHERE\n" +
			"\t a.phone = #{phone}")
			Integer selectCountTeam(@Param("phone")String phone);


			@Update("update com_pb_member_role u set u.phone=#{newphone},is_reg=1 where u.phone=#{oldphone}")
			void updateMemberRole(@Param("newphone")String newphone,@Param("oldphone")String oldphone);
			@Update("update com_pb_service_team u set u.phone=#{newphone},is_reg=1 where u.phone=#{oldphone}")
			void updateServiceTeam(@Param("newphone")String newphone,@Param("oldphone")String oldphone);
			}