zammad/lib/report/ticket_reopened.rb

# Copyright (C) 2012-2025 Zammad Foundation, https://zammad-foundation.org/

class Report::TicketReopened < Report::BaseSql

=begin

  result = Report::TicketReopened.aggs(
    range_start: Time.zone.parse('2015-01-01T00:00:00Z'),
    range_end:   Time.zone.parse('2015-12-31T23:59:59Z'),
    interval:    'month', # quarter, month, week, day, hour, minute, second
    selector:    selector, # ticket selector to get only a collection of tickets
    timezone:    'Europe/Berlin',
  )

returns

  [4,5,1,5,0,51,5,56,7,4]

=end

  def self.aggs(params_origin)
    params = params_origin.deep_dup
    ticket_state_ids = ticket_ids

    result = []
    case params[:interval]
    when 'month'
      stop_interval = 12
    when 'week'
      stop_interval = 7
    when 'day'
      stop_interval = 31
    when 'hour'
      stop_interval = 24
    when 'minute'
      stop_interval = 60
    end
    (1..stop_interval).each do |_counter|
      case params[:interval]
      when 'month'
        params[:range_end] = params[:range_start].next_month
      when 'week', 'day'
        params[:range_end] = params[:range_start].next_day
      when 'hour'
        params[:range_end] = params[:range_start] + 1.hour
      when 'minute'
        params[:range_end] = params[:range_start] + 1.minute
      end

      params[:selector].merge!(without_merged_tickets_selector) # do not show merged tickets in reports
      count = history_count(
        object:    'Ticket',
        type:      'updated',
        attribute: 'state',
        id_from:   ticket_state_ids,
        id_not_to: ticket_state_ids,
        start:     params[:range_start],
        end:       params[:range_end],
        selector:  params[:selector]
      )
      result.push count
      params[:range_start] = params[:range_end]
    end
    result
  end

=begin

  result = Report::TicketReopened.items(
    range_start: Time.zone.parse('2015-01-01T00:00:00Z'),
    range_end:   Time.zone.parse('2015-12-31T23:59:59Z'),
    selector:    selector, # ticket selector to get only a collection of tickets
    timezone:    'Europe/Berlin',
  )

returns

  {
    count: 123,
    ticket_ids: [4,5,1,5,0,51,5,56,7,4],
    assets: assets,
  }

=end

  def self.items(params)
    ticket_state_ids = ticket_ids
    result = history(
      object:    'Ticket',
      type:      'updated',
      attribute: 'state',
      id_from:   ticket_state_ids,
      id_not_to: ticket_state_ids,
      start:     params[:range_start],
      end:       params[:range_end],
      selector:  params[:selector]
    )
    return result if params[:sheet].present?

    assets = {}
    result[:ticket_ids].each do |ticket_id|
      ticket_full = Ticket.find(ticket_id)
      assets = ticket_full.assets(assets)
    end
    result[:assets] = assets
    result
  end

  def self.ticket_ids
    key = 'Report::TicketReopened::StateList'
    ticket_state_ids = Rails.cache.read(key)
    return ticket_state_ids if ticket_state_ids

    ticket_state_types = Ticket::StateType.where(name: %w[closed merged removed])
    ticket_state_ids = []
    ticket_state_types.each do |ticket_state_type|
      ticket_state_type.states.each do |ticket_state|
        ticket_state_ids.push ticket_state.id
      end
    end
    Rails.cache.write(key, ticket_state_ids, { expires_in: 2.days })
    ticket_state_ids
  end
end