Contents

class Category < ActiveRecord::Base
  acts_as_list
  has_and_belongs_to_many(:articles,
                          :order => "published_at DESC, created_at DESC")

  def self.find_all_with_article_counters(maxcount=nil)
    self.find_by_sql([%{
      SELECT categories.id, categories.name, categories.permalink, categories.position, COUNT(articles.id) AS article_counter
      FROM #{Category.table_name} categories
        LEFT OUTER JOIN #{Category.table_name_prefix}articles_categories#{Category.table_name_suffix} articles_categories
          ON articles_categories.category_id = categories.id
        LEFT OUTER JOIN #{Article.table_name} articles
          ON (articles_categories.article_id = articles.id AND articles.published = ?)
      GROUP BY categories.id, categories.name, categories.position, categories.permalink
      ORDER BY position
      }, true]).each {|item| item.article_counter = item.article_counter.to_i }
  end

  def self.find_by_permalink(*args)
    super || new
  end

  def self.to_prefix
    'category'
  end

  def stripped_name
    self.name.to_url
  end

  def self.reorder(serialized_list)
    self.transaction do
      serialized_list.each_with_index do |cid,index|
        find(cid).update_attribute "position", index rescue nil
      end
    end
  end

  def self.reorder_alpha
    reorder find(:all, :order => 'UPPER(name)').collect { |c| c.id }
  end

  def published_articles
    self.articles.find_already_published
  end

  def display_name
    name
  end

  protected

  before_save :set_defaults

  def set_defaults
    self.permalink ||= self.stripped_name
  end

  validates_presence_of :name
  validates_uniqueness_of :name, :on => :create
end

Version data entries

9 entries across 9 versions & 1 rubygems

Version	Path
typo-3.99.0	app/models/category.rb
typo-3.99.2	app/models/category.rb
typo-3.99.1	app/models/category.rb
typo-3.99.3	app/models/category.rb
typo-4.0.1	app/models/category.rb
typo-3.99.4	app/models/category.rb
typo-4.0.2	app/models/category.rb
typo-4.0.0	app/models/category.rb
typo-4.0.3	app/models/category.rb