Contents

# frozen_string_literal: true

class ArchivesSidebar < Sidebar
  description "Displays links to monthly archives"
  setting :title, "Archives"
  setting :show_count, true, label: "Show article counts", input_type: :checkbox
  setting :count, 10, label: "Number of Months"

  attr_accessor :archives

  def self.date_funcs
    @date_funcs ||=
      if /SQLite3Adapter/.match?(Content.connection.class.name)
        ["strftime('%Y', published_at) as year", "strftime('%m', published_at) as month"]
      else
        ["extract(year from published_at) as year",
         "extract(month from published_at) as month"]
      end
  end

  def parse_request(_contents, _params)
    # The original query that was here instantiated every article and every
    # tag, and then sorted through them just to do a 'group by date'.
    # Unfortunately, there's no universally-supported way to do this
    # across all three of our supported DBs.  So, we resort to a bit of
    # DB-specific code.
    date_funcs = self.class.date_funcs

    article_counts = Article.published.select("count(*) as count", *date_funcs).
      group(:year, :month).reorder("year desc", "month desc").limit(count.to_i)

    @archives = article_counts.map do |entry|
      month = entry.month.to_i
      year = entry.year.to_i
      {
        name: I18n.l(Date.new(year, month), format: "%B %Y"),
        month: month,
        year: year,
        article_count: entry.count,
      }
    end
  end
end

SidebarRegistry.register_sidebar ArchivesSidebar

Version data entries

21 entries across 21 versions & 2 rubygems

Version	Path
publify_core-9.2.0	app/models/archives_sidebar.rb