zammad/lib/excel_sheet/ticket.rb

class ExcelSheet::Ticket < ExcelSheet

=begin

  excel = ExcelSheet::Ticket.new(
    title:                        "#{year}-#{month}",
    ticket_ids:                   ticket_ids,
    additional_attributes:        additional_attributes,
    additional_attributes_header: additional_attributes_header,
    timezone:                     params[:timezone],
    locale:                       current_user.locale,
  )

  excel.content

=end

  def initialize(params)
    @ticket_ids                   = params[:ticket_ids] || []
    @additional_attributes        = params[:additional_attributes] || []
    @additional_attributes_header = params[:additional_attributes_header] || []

    super(
      title:    params[:title],
      header:   ticket_header,
      records:  [],
      timezone: params[:timezone],
      locale:   params[:locale]
    )
  end

  def ticket_header
    header = [
      { display: '#', name: 'number', width: 18, data_type: 'string' },
      { display: 'Title', name: 'title', width: 34, data_type: 'string' },
      { display: 'State', name: 'state_id', width: 14, data_type: 'string' },
      { display: 'Priority', name: 'priority_id', width: 14, data_type: 'string' },
      { display: 'Group', name: 'group_id', width: 20, data_type: 'string' },
      { display: 'Owner', name: 'owner_id', width: 20, data_type: 'string' },
      { display: 'Customer', name: 'customer_id', width: 20, data_type: 'string' },
      { display: 'Organization', name: 'organization_id', width: 20, data_type: 'string' },
      { display: 'Create Channel', name: 'create_article_type_id', width: 10, data_type: 'string' },
      { display: 'Sender', name: 'create_article_sender_id', width: 14, data_type: 'string' },
      { display: 'Tags', name: 'tag_list', width: 20, data_type: 'string' },
      { display: 'Time Units Total', name: 'time_unit', width: 10, data_type: 'float' },
    ]

    header = header.concat(@additional_attributes_header) if @additional_attributes_header

    # ObjectManager attributes
    objects = ObjectManager::Attribute.where(active:           true,
                                             to_create:        false,
                                             object_lookup_id: ObjectLookup.lookup(name: 'Ticket').id)
                                      .pluck(:name, :display, :data_type, :data_option)
                                      .map { |name, display, data_type, data_option| { name: name, display: display, data_type: data_type, data_option: data_option, width: 20 } }
    objects.each do |object|
      already_exists = false
      header.each do |local_header|
        next if local_header[:name] != object[:name]

        already_exists = true
        break
      end
      next if already_exists

      header.push object
    end

    header.concat([
                    { display: 'Created At', name: 'created_at', width: 18, data_type: 'datetime' },
                    { display: 'Updated At', name: 'updated_at', width: 18, data_type: 'datetime' },
                    { display: 'Closed At', name: 'close_at', width: 18, data_type: 'datetime' },
                    { display: 'Close Escalation At', name: 'close_escalation_at', width: 18, data_type: 'datetime' },
                    { display: 'Close In Min', name: 'close_in_min', width: 10, data_type: 'integer' },
                    { display: 'Close Diff In Min', name: 'close_diff_in_min', width: 10, data_type: 'integer' },
                    { display: 'First Response At', name: 'first_response_at', width: 18, data_type: 'datetime' },
                    { display: 'First Response Escalation At', name: 'first_response_escalation_at', width: 18, data_type: 'datetime' },
                    { display: 'First Response In Min', name: 'first_response_in_min', width: 10, data_type: 'integer' },
                    { display: 'First Response Diff In Min', name: 'first_response_diff_in_min', width: 10, data_type: 'integer' },
                    { display: 'Update Escalation At', name: 'update_escalation_at', width: 18, data_type: 'datetime' },
                    { display: 'Update In Min', name: 'update_in_min', width: 10, data_type: 'integer' },
                    { display: 'Update Diff In Min', name: 'update_diff_in_min', width: 10, data_type: 'integer' },
                    { display: 'Last Contact At', name: 'last_contact_at', width: 18, data_type: 'datetime' },
                    { display: 'Last Contact Agent At', name: 'last_contact_agent_at', width: 18, data_type: 'datetime' },
                    { display: 'Last Contact Customer At', name: 'last_contact_customer_at', width: 18, data_type: 'datetime' },
                    { display: 'Article Count', name: 'article_count', width: 10, data_type: 'integer' },
                    { display: 'Escalation At', name: 'escalation_at', width: 18, data_type: 'datetime' },
                  ])

  end

  def gen_rows
    @ticket_ids.each_with_index do |ticket_id, index|
      ticket = ::Ticket.lookup(id: ticket_id)
      raise "Can't find Ticket with ID #{ticket_id} for '#{@title}' #{self.class.name} generation" if !ticket

      gen_row_by_header(ticket, @additional_attributes[index])
    rescue => e
      Rails.logger.error e
    end
  end

end