summaryrefslogtreecommitdiff
path: root/lib/gitlab/analytics/cycle_analytics/stage_events/issue_stage_end.rb
blob: 77e4092b9abe51c0154e6d0945b1498688efbe54 (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
# frozen_string_literal: true

module Gitlab
  module Analytics
    module CycleAnalytics
      module StageEvents
        class IssueStageEnd < SimpleStageEvent
          def self.name
            PlanStageStart.name
          end

          def self.identifier
            :issue_stage_end
          end

          def object_type
            Issue
          end

          def timestamp_projection
            Arel::Nodes::NamedFunction.new('COALESCE', [
              issue_metrics_table[:first_associated_with_milestone_at],
              issue_metrics_table[:first_added_to_board_at]
            ])
          end

          # rubocop: disable CodeReuse/ActiveRecord
          def apply_query_customization(query)
            query.joins(:metrics).where(issue_metrics_table[:first_added_to_board_at].not_eq(nil).or(issue_metrics_table[:first_associated_with_milestone_at].not_eq(nil)))
          end
          # rubocop: enable CodeReuse/ActiveRecord
        end
      end
    end
  end
end