openproject/spec/models/query/results_version_integration_spec.rb

# frozen_string_literal: true

#-- copyright
# OpenProject is an open source project management software.
# Copyright (C) the OpenProject GmbH
#
# This program is free software; you can redistribute it and/or
# modify it under the terms of the GNU General Public License version 3.
#
# OpenProject is a fork of ChiliProject, which is a fork of Redmine. The copyright follows:
# Copyright (C) 2006-2013 Jean-Philippe Lang
# Copyright (C) 2010-2013 the ChiliProject Team
#
# This program is free software; you can redistribute it and/or
# modify it under the terms of the GNU General Public License
# as published by the Free Software Foundation; either version 2
# of the License, or (at your option) any later version.
#
# This program is distributed in the hope that it will be useful,
# but WITHOUT ANY WARRANTY; without even the implied warranty of
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
# GNU General Public License for more details.
#
# You should have received a copy of the GNU General Public License
# along with this program; if not, write to the Free Software
# Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301, USA.
#
# See COPYRIGHT and LICENSE files for more details.
#++

require "spec_helper"

RSpec.describe Query::Results, "Grouping and sorting for version" do
  let(:query_results) do
    Query::Results.new query
  end
  let(:project) { create(:project) }
  let(:user) do
    create(:user,
           firstname: "user",
           lastname: "1",
           member_with_permissions: { project => [:view_work_packages] })
  end

  let(:old_version) do
    create(:version,
           name: "4. Old version",
           project:,
           start_date: "2019-02-02",
           effective_date: "2019-02-03")
  end

  let(:new_version) do
    create(:version,
           name: "10.2 New version",
           project:,
           start_date: "2020-02-02",
           effective_date: "2020-02-03")
  end

  let(:no_date_version) do
    create(:version,
           name: "10.1 No date version",
           project:,
           start_date: nil,
           effective_date: nil)
  end

  let!(:no_version_wp) do
    create(:work_package,
           subject: "No version wp",
           project:)
  end
  let!(:new_version_wp) do
    create(:work_package,
           subject: "Newest version wp",
           version: new_version,
           project:)
  end
  let!(:old_version_wp) do
    create(:work_package,
           subject: "Oldest version wp",
           version: old_version,
           project:)
  end
  let!(:no_date_version_wp) do
    create(:work_package,
           subject: "No date version wp",
           version: no_date_version,
           project:)
  end

  let(:group_by) { nil }
  let(:sort_criteria) { [["version", "asc"]] }

  let(:query) do
    build(:query,
          user:,
          group_by:,
          show_hierarchies: false,
          project:).tap do |q|
      q.filters.clear
      q.sort_criteria = sort_criteria
    end
  end
  let(:work_packages_asc) { [old_version_wp, no_date_version_wp, new_version_wp, no_version_wp] }
  let(:work_packages_desc) { [no_version_wp, new_version_wp, no_date_version_wp, old_version_wp] }

  before do
    login_as(user)
  end

  describe "grouping by version" do
    let(:group_by) { "version" }

    it "returns the correctly sorted grouped result" do
      # Keys are also sorted by the version
      expect(query_results.work_package_count_by_group.keys)
        .to eql work_packages_asc.map(&:version)

      expect(query_results.work_package_count_by_group)
        .to eql(old_version => 1, no_date_version => 1, new_version => 1, nil => 1)

      expect(query_results.work_packages.pluck(:id))
        .to match work_packages_asc.map(&:id)
    end
  end

  describe "sorting ASC by version" do
    let(:sort_criteria) { [["version", "asc"]] }

    it "returns the correctly sorted result" do
      expect(query_results.work_packages.pluck(:id))
        .to match work_packages_asc.map(&:id)
    end
  end

  describe "sorting DESC by version" do
    let(:sort_criteria) { [["version", "desc"]] }

    it "returns the correctly sorted result" do
      expect(query_results.work_packages.pluck(:id))
        .to match work_packages_desc.map(&:id)
    end
  end
end