aboutsummaryrefslogtreecommitdiffstats
path: root/app/controllers/users_controller.rb
blob: 670c1c6efb3fbbefae9f6547b2523883a7009774 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
class UsersController < ApplicationController
  def best
    page = get_page_number(params)
    screen_name = params[:screen_name]
    user = User.where(:screen_name => screen_name).first
    if user
      @items = user.tweets
        .where("favorites_count > 0 OR retweets_count > 0")
        .order("COALESCE(favorites_count, 0) + COALESCE(retweets_count, 0) DESC")
        .page(page)
        .per(Settings.page_per)
    else
      @items = []
    end
    @title = "@#{screen_name}'s Best Tweets"
  end

   def recent
    page = get_page_number(params)
    screen_name = params[:screen_name]
    user = User.where(:screen_name => screen_name).first
    if user
      @items = user.tweets
        .where("favorites_count > 0 OR retweets_count > 0")
        .order("id DESC")
        .page(page)
        .per(Settings.page_per)
    else
      @items = []
    end
    @title = "@#{screen_name}'s Newest Favorited Tweets"
  end

  def timeline
    page = get_page_number(params)
    screen_name = params[:screen_name]
    user = User.where(:screen_name => screen_name).first
    if user
      @items = user.tweets
        .order("id DESC")
        .page(page)
        .per(Settings.page_per)
    else
      @items = []
    end
    @title = "@#{screen_name}'s Newest Tweets"
  end

  def my
    page = get_page_number(params)
    screen_name = params[:screen_name]
    user = User.where(:screen_name => screen_name).first
    if user
      @items = Tweet
        .where("id IN (SELECT tweet_id FROM (" +
          "SELECT tweet_id FROM favorites WHERE user_id = #{user.id} " +
          "UNION " +
          "SELECT tweet_id FROM retweets WHERE user_id = #{user.id}" +
          ") AS rf)")
        .order("id DESC")
        .page(page)
        .per(Settings.page_per)

    else
      @items = []
    end
    @title = "@#{screen_name}'s Recent Discoveries"
    prepare_cache
  end

  def info
    screen_name = params[:screen_name]
    user = User.where(:screen_name => screen_name).first
    if user
      @tweets_count = user.tweets.count
      @favorites_count = user.favorites.count
      @retweets_count = user.retweets.count
      @favorited_count = user.tweets.inject(0){|s, m| s + m.favorites_count}
      @retweeted_count = user.tweets.inject(0){|s, m| s + m.retweets_count}
    else
      @info = nil
    end
  end
end