计算大使

count_referrer.rb

a = ["广州","长沙","福州","北京","南京","厦门","南昌","西安","武汉","天津","太原","沈阳","大连","长春","哈尔滨","上海","杭州","宁波","合肥","济南","青岛","郑州","深圳","南宁","海口","重庆","成都","贵阳","乌鲁木齐","香港","台北","三亚","丽江","拉萨","桂林"]
total_count = []
a.each do |c|
  u = User.within_circle('location.loc' => City.where(name_chn: c).first.to_a).desc(:referring_count).first
  total_count << { city: c, nickname: u.nickname, count: u.referring_count }
end

a = []
total_count.each do |u|
  user = User.where(nickname: u[:nickname]).first
  count = 0
  user.referring.each do |r|
    if r.avatar? && r.verifies_count > 0 && r.photos.count > 0 && r.referrer_id.to_s != r.id.to_s
      count += 1 if r.created_at > '2013-11-30 00:00:00' && r.created_at < '2014-04-18 23:59:59'
    end
  end
  a << { city: u[:city], nickname: u[:nickname], count: count }
end


城市推荐人数第一名（无任何条件）
[{:city=>"广州", :nickname=>"轮回何阳在路上", :count=>684}, {:city=>"长沙", :nickname=>"椰子海岛", :count=>2241}, {:city=>"福州", :nickname=>"jensen鑫", :count=>437}, {:city=>"北京", :nickname=>"Little笨笨", :count=>2}, {:city=>"南京", :nickname=>"神码传奇", :count=>244}, {:city=>"厦门", :nickname=>"Jack张", :count=>0}, {:city=>"南昌", :nickname=>"暮雨", :count=>17}, {:city=>"西安", :nickname=>"椰子海岛l", :count=>60}, {:city=>"武汉", :nickname=>"柏图卡", :count=>279}, {:city=>"天津", :nickname=>"璇飘雨", :count=>340}, {:city=>"太原", :nickname=>"以梦为马", :count=>697}, {:city=>"沈阳", :nickname=>"一凡m造梦屌丝", :count=>7}, {:city=>"大连", :nickname=>"田田兔", :count=>235}, {:city=>"长春", :nickname=>"可熊熊", :count=>0}, {:city=>"哈尔滨", :nickname=>"花语的秘密", :count=>17}, {:city=>"上海", :nickname=>"洋仔", :count=>69}, {:city=>"杭州", :nickname=>"正版小新", :count=>52}, {:city=>"宁波", :nickname=>"二毛", :count=>23}, {:city=>"合肥", :nickname=>"南以西", :count=>34}, {:city=>"济南", :nickname=>"宋先森", :count=>20}, {:city=>"青岛", :nickname=>"di请你吃小火锅", :count=>9}, {:city=>"郑州", :nickname=>"小蜜蜂", :count=>272}, {:city=>"深圳", :nickname=>"夏至", :count=>2}, {:city=>"南宁", :nickname=>"穷驴友zhk也是喜", :count=>1}, {:city=>"海口", :nickname=>"李大狼", :count=>6}, {:city=>"重庆", :nickname=>"小芒果", :count=>54}, {:city=>"成都", :nickname=>"闻香识你", :count=>574}, {:city=>"贵阳", :nickname=>"外星hero", :count=>1}, {:city=>"乌鲁木齐", :nickname=>"李晨曦", :count=>137}, {:city=>"香港", :nickname=>"Shawn", :count=>0}, {:city=>"台北", :nickname=>"bigsmaillbelly", :count=>0}, {:city=>"三亚", :nickname=>"三亚村长", :count=>0}, {:city=>"丽江", :nickname=>"Rachael", :count=>4}, {:city=>"拉萨", :nickname=>"白白vip001", :count=>730}, {:city=>"桂林", :nickname=>"陈麒元", :count=>13}]