discourse-rewind/app/services/discourse_rewind/rewind/action/activity_calendar.rb

# frozen_string_literal: true

# For a GitHub like calendar
# https://docs.github.com/assets/cb-35216/mw-1440/images/help/profile/contributions-graph.webp
module DiscourseRewind
  class Rewind::Action::ActivityCalendar < Rewind::Action::BaseReport
    FakeData = {
      data:
        (Date.new(2024, 1, 1)..Date.new(2024, 12, 31)).map do |date|
          { date: date.strftime("%Y-%m-%d"), post_count: rand(0..20), visited: false }
        end,
      identifier: "activity-calendar",
    }

    def call
      return FakeData if Rails.env.development?

      calendar =
        Post
          .unscoped
          .joins(<<~SQL)
            RIGHT JOIN
              generate_series('#{date.first}', '#{date.last}', '1 day'::interval) ON
              posts.created_at::date = generate_series::date AND
              posts.user_id = #{user.id} AND
              posts.deleted_at IS NULL
          SQL
          .joins(
            "LEFT JOIN user_visits ON generate_series::date = visited_at AND user_visits.user_id = #{user.id}",
          )
          .select(
            "generate_series::date as date, count(posts.id) as post_count, COUNT(visited_at) > 0 as visited",
          )
          .group("generate_series, user_visits.id")
          .order("generate_series")
          .map do |row|
            {
              date: row.date.strftime("%Y-%m-%d"),
              post_count: row.post_count,
              visited: row.visited,
            }
          end

      { data: calendar, identifier: "activity-calendar" }
    end
  end
end