The Buckblog

module Buckblog
module SectionDrop
  class MonthDrop < Liquid::Drop
    attr_reader :section, :year, :month, :count

    def initialize(section, year, month, count)
      @section = section
      @year, @month, @count = year.to_i, month.to_i, count.to_i
    end

    def name
      "#{Date::MONTHNAMES[month]} #{year}"
    end

    def url
      path = [""]
      path << section.path unless section.path.blank?
      path += ["archives", year, month]
      path.join("/")
    end
  end

  def months_with_articles
    @months_with_articles ||= begin
      case Article.connection.adapter_name
      when "SQLite"
        month = "strftime('%Y-%m', published_at)"
      when "MySQL"
        month = "date_format(published_at, '%Y-%m')"
      else
        raise "#{Article.connection.adapter_name} is not yet supported here"
      end

      results = Article.connection.select_all(<<-SQL)
        select #{month} as month, count(c.id) as count_for_month
          from contents c, assigned_sections a
         where c.type='Article'
           and a.article_id = c.id
           and a.section_id = #{@source.id}
         group by month
         order by month DESC;
      SQL

      results.map do |row|
        year, month = row["month"].split(/-/, 2)
        MonthDrop.new(@source, year, month, row["count_for_month"])
      end
    end
  end
end
end