1234567891011121314151617181920212223242526272829303132333435363738394041424344454647 |
- # Copyright (C) 2012-2023 Zammad Foundation, https://zammad-foundation.org/
- require 'rails_helper'
- RSpec.describe ExcelSheet do
- describe '.timestamp_in_localtime' do
- let(:document) { described_class.new(title: 'some title', header: [], records: [], timezone: 'Europe/Berlin', locale: 'de-de') }
- it 'does convert UTC timestamp to local system based timestamp' do
- expect(document.timestamp_in_localtime(Time.parse('2019-08-08T01:00:05Z').in_time_zone)).to eq('2019-08-08 03:00:05')
- end
- end
- describe 'Multiselect does not show values properly in reports #4186', db_strategy: :reset do
- let(:document) { described_class.new(title: 'some title', header: [], records: [], timezone: 'Europe/Berlin', locale: 'de-de') }
- let(:ticket) { create(:ticket, '4186_select': 'key_1', '4186_tree_select': 'Incident::Hardware', '4186_multiselect': %w[key_1 key_2], '4186_multi_tree_select': ['Incident', 'Incident::Hardware']) }
- before do
- create(:object_manager_attribute_select, name: '4186_select')
- create(:object_manager_attribute_tree_select, name: '4186_tree_select')
- create(:object_manager_attribute_multiselect, name: '4186_multiselect')
- create(:object_manager_attribute_multi_tree_select, name: '4186_multi_tree_select')
- ObjectManager::Attribute.migration_execute
- ticket
- end
- it 'does show select values formatted' do
- expect(document.value_lookup(ticket, '4186_select', ObjectManager::Attribute.find_by(name: '4186_select'), nil)).to eq('value_1')
- end
- it 'does show tree select values formatted' do
- expect(document.value_lookup(ticket, '4186_tree_select', ObjectManager::Attribute.find_by(name: '4186_tree_select'), nil)).to eq('Incident::Hardware')
- end
- it 'does show multiselect values formatted' do
- expect(document.value_lookup(ticket, '4186_multiselect', ObjectManager::Attribute.find_by(name: '4186_multiselect'), nil)).to eq('value_1,value_2')
- end
- it 'does show multi tree select values formatted' do
- expect(document.value_lookup(ticket, '4186_multi_tree_select', ObjectManager::Attribute.find_by(name: '4186_multi_tree_select'), nil)).to eq('Incident,Incident::Hardware')
- end
- end
- end
|