diff options
Diffstat (limited to 'app/models/label.rb')
-rw-r--r-- | app/models/label.rb | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/app/models/label.rb b/app/models/label.rb index 6608a0573cb..483d51099b1 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,13 @@ class Label < ApplicationRecord .distinct } + scope :for_targets, ->(target_relation) do + joins(:label_links) + .merge(LabelLink.where(target: target_relation)) + .select(arel_table[Arel.star], LabelLink.arel_table[:target_id]) + .with_preloaded_container + end + def self.prioritized(project) joins(:priorities) .where(label_priorities: { project_id: project }) |