123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565 |
- # Copyright (C) 2012-2023 Zammad Foundation, https://zammad-foundation.org/
- require 'rails_helper'
- RSpec.describe 'Organization', performs_jobs: true, searchindex: true, type: :request do
- let!(:admin) do
- create(:admin, groups: Group.all)
- end
- let!(:agent) do
- create(:agent, firstname: 'Search 1234', groups: Group.all)
- end
- let!(:customer) do
- create(:customer)
- end
- let!(:organization) do
- create(
- :organization,
- name: 'Rest Org #1',
- note: 'Rest Org #1',
- created_at: '2017-09-05 10:00:00',
- )
- end
- let!(:organization2) do
- create(
- :organization,
- name: 'Rest Org #2',
- note: 'Rest Org #2',
- created_at: '2017-09-05 11:00:00',
- )
- end
- let!(:organization3) do
- create(
- :organization,
- name: 'Rest Org #3',
- note: 'Rest Org #3',
- created_at: '2017-09-05 12:00:00',
- )
- end
- let!(:customer2) do
- create(:customer, organization: organization)
- end
- before do
- searchindex_model_reload([Organization])
- end
- describe 'request handling' do
- it 'does index with agent' do
- # index
- authenticated_as(agent)
- get '/api/v1/organizations', params: {}, as: :json
- expect(response).to have_http_status(:ok)
- expect(json_response).to be_a(Array)
- expect(json_response[0]['member_ids']).to be_a(Array)
- expect(json_response.length >= 3).to be_truthy
- get '/api/v1/organizations?limit=40&page=1&per_page=2', params: {}, as: :json
- expect(response).to have_http_status(:ok)
- expect(json_response).to be_a(Array)
- organizations = Organization.order(:id).limit(2)
- expect(json_response[0]['id']).to eq(organizations[0].id)
- expect(json_response[0]['member_ids']).to eq(organizations[0].member_ids)
- expect(json_response[1]['id']).to eq(organizations[1].id)
- expect(json_response[1]['member_ids']).to eq(organizations[1].member_ids)
- expect(json_response.count).to eq(2)
- get '/api/v1/organizations?limit=40&page=2&per_page=2', params: {}, as: :json
- expect(response).to have_http_status(:ok)
- expect(json_response).to be_a(Array)
- organizations = Organization.order(:id).limit(4)
- expect(json_response[0]['id']).to eq(organizations[2].id)
- expect(json_response[0]['member_ids']).to eq(organizations[2].member_ids)
- expect(json_response[1]['id']).to eq(organizations[3].id)
- expect(json_response[1]['member_ids']).to eq(organizations[3].member_ids)
- expect(json_response.count).to eq(2)
- # show/:id
- get "/api/v1/organizations/#{organization.id}", params: {}, as: :json
- expect(response).to have_http_status(:ok)
- expect(json_response).to be_a(Hash)
- expect(json_response['member_ids']).to be_a(Array)
- expect(json_response['members']).to be_falsey
- expect('Rest Org #1').to eq(json_response['name'])
- get "/api/v1/organizations/#{organization2.id}", params: {}, as: :json
- expect(response).to have_http_status(:ok)
- expect(json_response).to be_a(Hash)
- expect(json_response['member_ids']).to be_a(Array)
- expect(json_response['members']).to be_falsey
- expect('Rest Org #2').to eq(json_response['name'])
- # search as agent
- perform_enqueued_jobs
- get "/api/v1/organizations/search?query=#{CGI.escape('Zammad')}", params: {}, as: :json
- expect(response).to have_http_status(:ok)
- expect(json_response).to be_a(Array)
- organization = json_response.detect { |object| object['name'] == 'Zammad Foundation' }
- expect(organization['name']).to eq('Zammad Foundation')
- expect(organization['member_ids']).to be_truthy
- expect(organization['members']).to be_falsey
- get "/api/v1/organizations/search?query=#{CGI.escape('Zammad')}&expand=true", params: {}, as: :json
- expect(response).to have_http_status(:ok)
- expect(json_response).to be_a(Array)
- organization = json_response.detect { |object| object['name'] == 'Zammad Foundation' }
- expect(organization['name']).to eq('Zammad Foundation')
- expect(organization['member_ids']).to be_truthy
- expect(organization['members']).to be_truthy
- get "/api/v1/organizations/search?query=#{CGI.escape('Zammad')}&label=true", params: {}, as: :json
- expect(response).to have_http_status(:ok)
- expect(json_response).to be_a(Array)
- organization = json_response.detect { |object| object['label'] == 'Zammad Foundation' }
- expect(organization['label']).to eq('Zammad Foundation')
- expect(organization['value']).to eq('Zammad Foundation')
- expect(organization['member_ids']).to be_falsey
- expect(organization['members']).to be_falsey
- end
- it 'does index with customer1' do
- # index
- authenticated_as(customer)
- get '/api/v1/organizations', params: {}, as: :json
- expect(response).to have_http_status(:ok)
- expect(json_response).to be_a(Array)
- expect(json_response.length).to eq(0)
- # show/:id
- get "/api/v1/organizations/#{organization.id}", params: {}, as: :json
- expect(response).to have_http_status(:ok)
- expect(json_response).to be_a(Hash)
- expect(json_response['name']).to be_nil
- get "/api/v1/organizations/#{organization2.id}", params: {}, as: :json
- expect(response).to have_http_status(:ok)
- expect(json_response).to be_a(Hash)
- expect(json_response['name']).to be_nil
- # search
- perform_enqueued_jobs
- get "/api/v1/organizations/search?query=#{CGI.escape('Zammad')}", params: {}, as: :json
- expect(response).to have_http_status(:forbidden)
- end
- it 'does index with customer2' do
- # index
- authenticated_as(customer2)
- get '/api/v1/organizations', params: {}, as: :json
- expect(response).to have_http_status(:ok)
- expect(json_response).to be_a(Array)
- expect(json_response.length).to eq(1)
- # show/:id
- get "/api/v1/organizations/#{organization.id}", params: {}, as: :json
- expect(response).to have_http_status(:ok)
- expect(json_response).to be_a(Hash)
- expect('Rest Org #1').to eq(json_response['name'])
- get "/api/v1/organizations/#{organization2.id}", params: {}, as: :json
- expect(response).to have_http_status(:forbidden)
- expect(json_response).to be_a(Hash)
- expect(json_response['name']).to be_nil
- # search
- perform_enqueued_jobs
- get "/api/v1/organizations/search?query=#{CGI.escape('Zammad')}", params: {}, as: :json
- expect(response).to have_http_status(:forbidden)
- end
- it 'does organization search sortable' do
- authenticated_as(admin)
- get "/api/v1/organizations/search?query=#{CGI.escape('Rest Org')}", params: {}, as: :json
- expect(response).to have_http_status(:ok)
- result = json_response
- result.collect! { |v| v['id'] }
- expect(result).to be_a(Array)
- expect(result).to eq([ organization.id, organization3.id, organization2.id ])
- get "/api/v1/organizations/search?query=#{CGI.escape('Rest Org')}", params: { sort_by: 'created_at', order_by: 'asc' }, as: :json
- expect(response).to have_http_status(:ok)
- result = json_response
- result.collect! { |v| v['id'] }
- expect(result).to be_a(Array)
- expect(result).to eq([ organization.id, organization2.id, organization3.id ])
- get "/api/v1/organizations/search?query=#{CGI.escape('Rest Org')}", params: { sort_by: 'note', order_by: 'asc' }, as: :json
- expect(response).to have_http_status(:ok)
- result = json_response
- result.collect! { |v| v['id'] }
- expect(result).to be_a(Array)
- expect(result).to eq([ organization.id, organization2.id, organization3.id ])
- get "/api/v1/organizations/search?query=#{CGI.escape('Rest Org')}", params: { sort_by: 'note', order_by: 'desc' }, as: :json
- expect(response).to have_http_status(:ok)
- result = json_response
- result.collect! { |v| v['id'] }
- expect(result).to be_a(Array)
- expect(result).to eq([ organization3.id, organization2.id, organization.id ])
- get "/api/v1/organizations/search?query=#{CGI.escape('Rest Org')}", params: { sort_by: %w[note created_at], order_by: %w[desc asc] }, as: :json
- expect(response).to have_http_status(:ok)
- result = json_response
- result.collect! { |v| v['id'] }
- expect(result).to be_a(Array)
- expect(result).to eq([ organization3.id, organization2.id, organization.id ])
- end
- it 'does organization show and response format' do
- organization = create(
- :organization,
- name: 'Rest Org NEW',
- members: [customer],
- updated_by_id: admin.id,
- created_by_id: admin.id,
- )
- authenticated_as(admin)
- get "/api/v1/organizations/#{organization.id}", params: {}, as: :json
- expect(response).to have_http_status(:ok)
- expect(json_response).to be_a(Hash)
- expect(json_response['id']).to eq(organization.id)
- expect(json_response['name']).to eq(organization.name)
- expect(json_response['members']).to be_falsey
- expect(json_response['member_ids']).to eq([customer.id])
- expect(json_response['updated_by_id']).to eq(admin.id)
- expect(json_response['created_by_id']).to eq(admin.id)
- get "/api/v1/organizations/#{organization.id}?expand=true", params: {}, as: :json
- expect(response).to have_http_status(:ok)
- expect(json_response).to be_a(Hash)
- expect(json_response['id']).to eq(organization.id)
- expect(json_response['name']).to eq(organization.name)
- expect(json_response['members']).to be_truthy
- expect(json_response['member_ids']).to eq([customer.id])
- expect(json_response['updated_by_id']).to eq(admin.id)
- expect(json_response['created_by_id']).to eq(admin.id)
- get "/api/v1/organizations/#{organization.id}?expand=false", params: {}, as: :json
- expect(response).to have_http_status(:ok)
- expect(json_response).to be_a(Hash)
- expect(json_response['id']).to eq(organization.id)
- expect(json_response['name']).to eq(organization.name)
- expect(json_response['members']).to be_falsey
- expect(json_response['member_ids']).to eq([customer.id])
- expect(json_response['updated_by_id']).to eq(admin.id)
- expect(json_response['created_by_id']).to eq(admin.id)
- get "/api/v1/organizations/#{organization.id}?full=true", params: {}, as: :json
- expect(response).to have_http_status(:ok)
- expect(json_response).to be_a(Hash)
- expect(json_response['id']).to eq(organization.id)
- expect(json_response['assets']).to be_truthy
- expect(json_response['assets']['Organization']).to be_truthy
- expect(json_response['assets']['Organization'][organization.id.to_s]).to be_truthy
- expect(json_response['assets']['Organization'][organization.id.to_s]['id']).to eq(organization.id)
- expect(json_response['assets']['Organization'][organization.id.to_s]['name']).to eq(organization.name)
- expect(json_response['assets']['Organization'][organization.id.to_s]['member_ids']).to eq(organization.member_ids)
- expect(json_response['assets']['Organization'][organization.id.to_s]['members']).to be_falsey
- get "/api/v1/organizations/#{organization.id}?full=false", params: {}, as: :json
- expect(response).to have_http_status(:ok)
- expect(json_response).to be_a(Hash)
- expect(json_response['id']).to eq(organization.id)
- expect(json_response['name']).to eq(organization.name)
- expect(json_response['members']).to be_falsey
- expect(json_response['member_ids']).to eq([customer.id])
- expect(json_response['updated_by_id']).to eq(admin.id)
- expect(json_response['created_by_id']).to eq(admin.id)
- end
- it 'does organization index and response format' do
- organization = create(
- :organization,
- name: 'Rest Org NEW',
- members: [customer],
- updated_by_id: admin.id,
- created_by_id: admin.id,
- )
- authenticated_as(admin)
- get '/api/v1/organizations', params: {}, as: :json
- expect(response).to have_http_status(:ok)
- expect(json_response).to be_a(Array)
- expect(json_response[0].class).to eq(Hash)
- expect(json_response.last['id']).to eq(organization.id)
- expect(json_response.last['name']).to eq(organization.name)
- expect(json_response.last['members']).to be_falsey
- expect(json_response.last['member_ids']).to eq(organization.member_ids)
- expect(json_response.last['updated_by_id']).to eq(admin.id)
- expect(json_response.last['created_by_id']).to eq(admin.id)
- get '/api/v1/organizations?expand=true', params: {}, as: :json
- expect(response).to have_http_status(:ok)
- expect(json_response).to be_a(Array)
- expect(json_response[0].class).to eq(Hash)
- expect(json_response.last['id']).to eq(organization.id)
- expect(json_response.last['name']).to eq(organization.name)
- expect(json_response.last['member_ids']).to eq(organization.member_ids)
- expect([customer.login]).to eq(organization.members.pluck(:login))
- expect(json_response.last['updated_by_id']).to eq(admin.id)
- expect(json_response.last['created_by_id']).to eq(admin.id)
- get '/api/v1/organizations?expand=false', params: {}, as: :json
- expect(response).to have_http_status(:ok)
- expect(json_response).to be_a(Array)
- expect(json_response[0].class).to eq(Hash)
- expect(json_response.last['id']).to eq(organization.id)
- expect(json_response.last['name']).to eq(organization.name)
- expect(json_response.last['members']).to be_falsey
- expect(json_response.last['member_ids']).to eq(organization.member_ids)
- expect(json_response.last['updated_by_id']).to eq(admin.id)
- expect(json_response.last['created_by_id']).to eq(admin.id)
- get '/api/v1/organizations?full=true', params: {}, as: :json
- expect(response).to have_http_status(:ok)
- expect(json_response).to be_a(Hash)
- expect(json_response['record_ids'].class).to eq(Array)
- expect(json_response['record_ids'][0]).to eq(1)
- expect(json_response['record_ids'].last).to eq(organization.id)
- expect(json_response['assets']).to be_truthy
- expect(json_response['assets']['Organization']).to be_truthy
- expect(json_response['assets']['Organization'][organization.id.to_s]).to be_truthy
- expect(json_response['assets']['Organization'][organization.id.to_s]['id']).to eq(organization.id)
- expect(json_response['assets']['Organization'][organization.id.to_s]['name']).to eq(organization.name)
- expect(json_response['assets']['Organization'][organization.id.to_s]['member_ids']).to eq(organization.member_ids)
- expect(json_response['assets']['Organization'][organization.id.to_s]['members']).to be_falsey
- get '/api/v1/organizations?full=false', params: {}, as: :json
- expect(response).to have_http_status(:ok)
- expect(json_response).to be_a(Array)
- expect(json_response[0].class).to eq(Hash)
- expect(json_response.last['id']).to eq(organization.id)
- expect(json_response.last['name']).to eq(organization.name)
- expect(json_response.last['members']).to be_falsey
- expect(json_response.last['member_ids']).to eq(organization.member_ids)
- expect(json_response.last['updated_by_id']).to eq(admin.id)
- expect(json_response.last['created_by_id']).to eq(admin.id)
- end
- it 'does ticket create and response format' do
- params = {
- name: 'Rest Org NEW',
- members: [customer.login],
- }
- authenticated_as(admin)
- post '/api/v1/organizations', params: params, as: :json
- expect(response).to have_http_status(:created)
- expect(json_response).to be_a(Hash)
- organization = Organization.find(json_response['id'])
- expect(json_response['name']).to eq(organization.name)
- expect(json_response['member_ids']).to eq(organization.member_ids)
- expect(json_response['members']).to be_falsey
- expect(json_response['updated_by_id']).to eq(admin.id)
- expect(json_response['created_by_id']).to eq(admin.id)
- params[:name] = 'Rest Org NEW #2'
- post '/api/v1/organizations?expand=true', params: params, as: :json
- expect(response).to have_http_status(:created)
- expect(json_response).to be_a(Hash)
- organization = Organization.find(json_response['id'])
- expect(json_response['name']).to eq(organization.name)
- expect(json_response['member_ids']).to eq(organization.member_ids)
- expect(json_response['members']).to eq(organization.members.pluck(:login))
- expect(json_response['updated_by_id']).to eq(admin.id)
- expect(json_response['created_by_id']).to eq(admin.id)
- params[:name] = 'Rest Org NEW #3'
- post '/api/v1/organizations?full=true', params: params, as: :json
- expect(response).to have_http_status(:created)
- expect(json_response).to be_a(Hash)
- organization = Organization.find(json_response['id'])
- expect(json_response['assets']).to be_truthy
- expect(json_response['assets']['Organization']).to be_truthy
- expect(json_response['assets']['Organization'][organization.id.to_s]).to be_truthy
- expect(json_response['assets']['Organization'][organization.id.to_s]['id']).to eq(organization.id)
- expect(json_response['assets']['Organization'][organization.id.to_s]['name']).to eq(organization.name)
- expect(json_response['assets']['Organization'][organization.id.to_s]['member_ids']).to eq(organization.member_ids)
- expect(json_response['assets']['Organization'][organization.id.to_s]['members']).to be_falsey
- end
- it 'does ticket update and response formats' do
- organization = create(
- :organization,
- name: 'Rest Org NEW',
- members: [customer],
- updated_by_id: admin.id,
- created_by_id: admin.id,
- )
- params = {
- name: 'a update name #1',
- }
- authenticated_as(admin)
- put "/api/v1/organizations/#{organization.id}", params: params, as: :json
- expect(response).to have_http_status(:ok)
- expect(json_response).to be_a(Hash)
- organization = Organization.find(json_response['id'])
- expect(json_response['name']).to eq(params[:name])
- expect(json_response['member_ids']).to eq(organization.member_ids)
- expect(json_response['members']).to be_falsey
- expect(json_response['updated_by_id']).to eq(admin.id)
- expect(json_response['created_by_id']).to eq(admin.id)
- params = {
- name: 'a update name #2',
- }
- put "/api/v1/organizations/#{organization.id}?expand=true", params: params, as: :json
- expect(response).to have_http_status(:ok)
- expect(json_response).to be_a(Hash)
- organization = Organization.find(json_response['id'])
- expect(json_response['name']).to eq(params[:name])
- expect(json_response['member_ids']).to eq(organization.member_ids)
- expect([customer.login]).to eq(organization.members.pluck(:login))
- expect(json_response['updated_by_id']).to eq(admin.id)
- expect(json_response['created_by_id']).to eq(admin.id)
- params = {
- name: 'a update name #3',
- }
- put "/api/v1/organizations/#{organization.id}?full=true", params: params, as: :json
- expect(response).to have_http_status(:ok)
- expect(json_response).to be_a(Hash)
- organization = Organization.find(json_response['id'])
- expect(json_response['assets']).to be_truthy
- expect(json_response['assets']['Organization']).to be_truthy
- expect(json_response['assets']['Organization'][organization.id.to_s]).to be_truthy
- expect(json_response['assets']['Organization'][organization.id.to_s]['id']).to eq(organization.id)
- expect(json_response['assets']['Organization'][organization.id.to_s]['name']).to eq(params[:name])
- expect(json_response['assets']['Organization'][organization.id.to_s]['member_ids']).to eq(organization.member_ids)
- expect(json_response['assets']['Organization'][organization.id.to_s]['members']).to be_falsey
- end
- it 'does organization history' do
- organization1 = create(
- :organization,
- name: 'some org',
- )
- authenticated_as(agent)
- get "/api/v1/organizations/history/#{organization1.id}", params: {}, as: :json
- expect(response).to have_http_status(:ok)
- expect(json_response).to be_a(Hash)
- expect(json_response['history'].class).to eq(Array)
- expect(json_response['assets'].class).to eq(Hash)
- expect(json_response['assets']['Ticket']).to be_nil
- expect(json_response['assets']['Organization'][organization1.id.to_s]).not_to be_nil
- end
- it 'does csv example - customer no access' do
- authenticated_as(customer)
- get '/api/v1/organizations/import_example', params: {}, as: :json
- expect(response).to have_http_status(:forbidden)
- expect(json_response['error']).to eq('Not authorized (user)!')
- end
- it 'does csv example - admin access' do
- authenticated_as(admin)
- get '/api/v1/organizations/import_example', params: {}, as: :json
- expect(response).to have_http_status(:ok)
- rows = CSV.parse(@response.body)
- header = rows.shift
- expect(header[0]).to eq('id')
- expect(header[1]).to eq('name')
- expect(header[2]).to eq('shared')
- expect(header[3]).to eq('domain')
- expect(header[4]).to eq('domain_assignment')
- expect(header[5]).to eq('active')
- expect(header[6]).to eq('note')
- expect(header).to include('members')
- end
- it 'does csv import - admin access' do
- UserInfo.current_user_id = 1
- customer1 = create(
- :customer,
- login: 'customer1-members@example.com',
- firstname: 'Member',
- lastname: 'Customer',
- email: 'customer1-members@example.com',
- password: 'customerpw',
- active: true,
- )
- customer2 = create(
- :customer,
- login: 'customer2-members@example.com',
- firstname: 'Member',
- lastname: 'Customer',
- email: 'customer2-members@example.com',
- password: 'customerpw',
- active: true,
- )
- UserInfo.current_user_id = nil
- # invalid file
- authenticated_as(admin)
- csv_file = fixture_file_upload('csv_import/organization/simple_col_not_existing.csv', 'text/csv')
- post '/api/v1/organizations/import?try=true', params: { file: csv_file, col_sep: ';' }
- expect(response).to have_http_status(:ok)
- expect(json_response).to be_a(Hash)
- expect(json_response['try']).to be(true)
- expect(json_response['records']).to be_empty
- expect(json_response['result']).to eq('failed')
- expect(json_response['errors'].count).to eq(2)
- expect(json_response['errors'][0]).to eq("Line 1: Unable to create record - unknown attribute 'name2' for Organization.")
- expect(json_response['errors'][1]).to eq("Line 2: Unable to create record - unknown attribute 'name2' for Organization.")
- # valid file try
- csv_file = fixture_file_upload('csv_import/organization/simple.csv', 'text/csv')
- post '/api/v1/organizations/import?try=true', params: { file: csv_file, col_sep: ';' }
- expect(response).to have_http_status(:ok)
- expect(json_response).to be_a(Hash)
- expect(json_response['try']).to be(true)
- expect(json_response['records'].count).to eq(2)
- expect(json_response['result']).to eq('success')
- expect(Organization.find_by(name: 'organization-member-import1')).to be_nil
- expect(Organization.find_by(name: 'organization-member-import2')).to be_nil
- # valid file
- csv_file = fixture_file_upload('csv_import/organization/simple.csv', 'text/csv')
- post '/api/v1/organizations/import', params: { file: csv_file, col_sep: ';' }
- expect(response).to have_http_status(:ok)
- expect(json_response).to be_a(Hash)
- expect(json_response['try']).to be(false)
- expect(json_response['records'].count).to eq(2)
- expect(json_response['result']).to eq('success')
- organization1 = Organization.find_by(name: 'organization-member-import1')
- expect(organization1).to be_truthy
- expect(organization1.name).to eq('organization-member-import1')
- expect(organization1.members.count).to eq(1)
- expect(organization1.members.first.login).to eq(customer1.login)
- expect(organization1.active).to be(true)
- organization2 = Organization.find_by(name: 'organization-member-import2')
- expect(organization2).to be_truthy
- expect(organization2.name).to eq('organization-member-import2')
- expect(organization2.members.count).to eq(1)
- expect(organization2.members.first.login).to eq(customer2.login)
- expect(organization2.active).to be(false)
- end
- end
- end
|