diff options
Diffstat (limited to 'app/models/label.rb')
| -rw-r--r-- | app/models/label.rb | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/app/models/label.rb b/app/models/label.rb index 6608a0573cb..35daca92089 100644 --- a/app/models/label.rb +++ b/app/models/label.rb @@ -42,6 +42,7 @@ class Label < ApplicationRecord scope :order_name_asc, -> { reorder(title: :asc) } scope :order_name_desc, -> { reorder(title: :desc) } scope :subscribed_by, ->(user_id) { joins(:subscriptions).where(subscriptions: { user_id: user_id, subscribed: true }) } + scope :with_preloaded_container, -> { preload(parent_container: :route) } scope :top_labels_by_target, -> (target_relation) { label_id_column = arel_table[:id] @@ -59,6 +60,14 @@ class Label < ApplicationRecord .distinct } + scope :for_targets, ->(target_ids, targets_type) do + joins(:label_links) + .where(label_links: { target_id: target_ids }) + .where(label_links: { target_type: targets_type }) + .select("labels.*, target_id") + .with_preloaded_container + end + def self.prioritized(project) joins(:priorities) .where(label_priorities: { project_id: project }) |