# File models/common/popularity_history.rb, line 3
  def self.generate_report(year, week)
    start_date = DateTime.commercial(year,week)
    #I'm catching the case when the week is in the new year
    end_date = DateTime.commercial(year,week+1) rescue DateTime.commercial(year+1,1)
    
    movies = Movie.find_by_sql ["select for_id as id, count(*) as counter from popularities where for_type = 'Movie' and created_at > ? and created_at < ? group by for_id order by counter desc", start_date, end_date ]
    
    movies.each do |m|
      stat = self.new
      stat.related_object = m
      stat.rating = m.counter
      stat.start_date = start_date
      stat.end_date = end_date
      #get the STI Classname when called as a Class Method
      stat.type = self.to_s
      stat.save
    end
  end