summaryrefslogtreecommitdiff
path: root/app/models/concerns/loaded_in_group_list.rb
blob: e73ddcfb56780ca5ace12eddc433e7230eb6a6bc (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
module LoadedInGroupList
  extend ActiveSupport::Concern

  PROJECT_COUNT_SQL = <<~PROJECTCOUNT.freeze
                     (SELECT COUNT(*) AS preloaded_project_count
                      FROM projects
                      WHERE projects.namespace_id = namespaces.id
                      AND projects.archived IS NOT true)
                     PROJECTCOUNT
  SUBGROUP_COUNT_SQL = <<~SUBGROUPCOUNT.freeze
                     (SELECT COUNT(*) AS preloaded_subgroup_count
                      FROM namespaces children
                      WHERE children.parent_id = namespaces.id)
                     SUBGROUPCOUNT
  MEMBER_COUNT_SQL = <<~MEMBERCOUNT.freeze
                     (SELECT COUNT(*) AS preloaded_member_count
                     FROM members
                     WHERE members.source_type = 'Namespace'
                     AND members.source_id = namespaces.id
                     AND members.requested_at IS NULL)
                     MEMBERCOUNT

  COUNT_SELECTS = ['namespaces.*',
                   PROJECT_COUNT_SQL,
                   SUBGROUP_COUNT_SQL,
                   MEMBER_COUNT_SQL].freeze

  module ClassMethods
    def with_counts
      select(COUNT_SELECTS)
    end

    def with_selects_for_list
      with_route.with_counts
    end
  end

  def children_count
    @children_count ||= project_count + subgroup_count
  end

  def project_count
    @project_count ||= if respond_to?(:preloaded_project_count)
                         preloaded_project_count
                       else
                         projects.non_archived.count
                       end
  end

  def subgroup_count
    @subgroup_count ||= if respond_to?(:preloaded_subgroup_count)
                          preloaded_subgroup_count
                        else
                          children.count
                        end
  end

  def member_count
    @member_count ||= if respond_to?(:preloaded_member_count)
                        preloaded_member_count
                      else
                        users.count
                      end
  end
end