Contents

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_func ||=
      if Content.connection.class.name =~ /SQLite3Adapter/
        ["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

3 entries across 3 versions & 1 rubygems

Version	Path
publify_core-9.1.0	app/models/archives_sidebar.rb
publify_core-9.0.1	app/models/archives_sidebar.rb
publify_core-9.0.0	app/models/archives_sidebar.rb