class Org
  class CreateCreatedPlanService
    class << self
      def call(org = nil)
        orgs = org.nil? ? Org.all : [org]

        orgs.each do |org|
          OrgDateRangeable.split_months_from_creation(org) do |start_date, end_date|
            create_count_for_date(start_date: start_date, end_date: end_date, org: org)  
          end
        end
      end

      private

      def count_plans(start_date: , end_date: , org:)
        users = User.where('users.org_id = ?', org.id)
        plans = Plan.where('plans.created_at >= ? AND plans.created_at <= ?', start_date, end_date)
        creator_admon = Role.with_access_flags(:creator, :administrator)

        Role.joins([:plan, :user]).merge(creator_admon).merge(users).merge(plans).select(:plan_id).distinct.count
      end

      def create_count_for_date(start_date:, end_date:, org:)
        count = count_plans(start_date: start_date, end_date: end_date, org: org)
        StatCreatedPlan.create(date: end_date.to_date, count: count, org_id: org.id)
      end
    end
  end
end