Geek asks and answers

Show only posts created last week

I want to be able to display messages and sort them according to several criteria, first by the number of votes that they have, and secondly, by the date they were created. I don’t want messages that are more than a week to be displayed so that only messages from the last week. I tried to do this:

 <%= render @posts.sort_by { |post| post.votes.count if post.created_at < 1.week.ago.utc }.reverse %>

but it gave me an error comparing NilClass with 2 unsuccessful

I know that the code works by simply sorting the messages by the number of votes, but I also want to limit the time for someone to tell me how to do this. I'm still a beginner, so I'm sorry for the simplicity.

+5
source share
2 answers

@Salil , counter_cache (http://api.rubyonrails.org/classes/ActiveRecord/Associations/ClassMethods.html) recent_post ( : fooobar.com/questions/1120232/...) :

def self.recent_posts
  Post.where("created_at >= ?", 1.week.ago.utc).order("votes_count DESC, created_at DESC")
end
+9

, . , , , , . -

post.rb

def self.recent_posts
  Post.select("p.*, COUNT(v.id) AS count").where("post.created_at >= 1.week.ago.utc").joins("p LEFT JOIN votes v on p.id=v.post_id").order("count, created_at DESC")
end
+2

More articles:


All Articles