summaryrefslogtreecommitdiff
path: root/app/models/concerns/has_integrations.rb
blob: b2775f4cbb2ef4393d1035acca12a600fa28f517 (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
# frozen_string_literal: true

module HasIntegrations
  extend ActiveSupport::Concern

  class_methods do
    def with_custom_integration_for(integration, page = nil, per = nil)
      custom_integration_project_ids = Integration
        .select(:project_id)
        .where(type: integration.type)
        .where(inherit_from_id: nil)
        .where.not(project_id: nil)
        .page(page)
        .per(per)

      Project.where(id: custom_integration_project_ids)
    end

    def without_integration(integration)
      integrations = Integration
        .select('1')
        .where('services.project_id = projects.id')
        .where(type: integration.type)

      Project
        .where('NOT EXISTS (?)', integrations)
        .where(pending_delete: false)
        .where(archived: false)
    end
  end
end