diff options
Diffstat (limited to 'app/finders/issuables/crm_organization_filter.rb')
-rw-r--r-- | app/finders/issuables/crm_organization_filter.rb | 21 |
1 files changed, 21 insertions, 0 deletions
diff --git a/app/finders/issuables/crm_organization_filter.rb b/app/finders/issuables/crm_organization_filter.rb new file mode 100644 index 00000000000..f746049c405 --- /dev/null +++ b/app/finders/issuables/crm_organization_filter.rb @@ -0,0 +1,21 @@ +# frozen_string_literal: true + +module Issuables + class CrmOrganizationFilter < BaseFilter + def filter(issuables) + by_crm_organization(issuables) + end + + # rubocop: disable CodeReuse/ActiveRecord + def by_crm_organization(issuables) + return issuables if params[:crm_organization_id].blank? + + condition = CustomerRelations::IssueContact + .joins(:contact) + .where(contact: { organization_id: params[:crm_organization_id] }) + .where(Arel.sql("issue_id = issues.id")) + issuables.where(condition.arel.exists) + end + # rubocop: enable CodeReuse/ActiveRecord + end +end |