SoundSoftware Code Site

# Redmine - project management software

# Copyright (C) 2006-2013  Jean-Philippe Lang

#

# 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.

require File.expand_path('../../test_helper', __FILE__)

class QueriesControllerTest < ActionController::TestCase

  fixtures :projects, :users, :members, :member_roles, :roles, :trackers, :issue_statuses, :issue_categories, :enumerations, :issues, :custom_fields, :custom_values, :queries, :enabled_modules

  def setup

    User.current = nil

  end

  def test_index

    get :index

    # HTML response not implemented

    assert_response 406

  end

  def test_new_project_query

    @request.session[:user_id] = 2

    get :new, :project_id => 1

    assert_response :success

    assert_template 'new'

    assert_tag :tag => 'input', :attributes => { :type => 'checkbox',

                                                 :name => 'query[is_public]',

                                                 :checked => nil }

    assert_tag :tag => 'input', :attributes => { :type => 'checkbox',

                                                 :name => 'query_is_for_all',

                                                 :checked => nil,

                                                 :disabled => nil }

    assert_select 'select[name=?]', 'c[]' do

      assert_select 'option[value=tracker]'

      assert_select 'option[value=subject]'

    end

  end

  def test_new_global_query

    @request.session[:user_id] = 2

    get :new

    assert_response :success

    assert_template 'new'

    assert_no_tag :tag => 'input', :attributes => { :type => 'checkbox',

                                                    :name => 'query[is_public]' }

    assert_tag :tag => 'input', :attributes => { :type => 'checkbox',

                                                 :name => 'query_is_for_all',

                                                 :checked => 'checked',

                                                 :disabled => nil }

  end

  def test_new_on_invalid_project

    @request.session[:user_id] = 2

    get :new, :project_id => 'invalid'

    assert_response 404

  end

  def test_create_project_public_query

    @request.session[:user_id] = 2

    post :create,

         :project_id => 'ecookbook',

         :default_columns => '1',

         :f => ["status_id", "assigned_to_id"],

         :op => {"assigned_to_id" => "=", "status_id" => "o"},

         :v => { "assigned_to_id" => ["1"], "status_id" => ["1"]},

         :query => {"name" => "test_new_project_public_query", "is_public" => "1"}

    q = Query.find_by_name('test_new_project_public_query')

    assert_redirected_to :controller => 'issues', :action => 'index', :project_id => 'ecookbook', :query_id => q

    assert q.is_public?

    assert q.has_default_columns?

    assert q.valid?

  end

  def test_create_project_private_query

    @request.session[:user_id] = 3

    post :create,

         :project_id => 'ecookbook',

         :default_columns => '1',

         :fields => ["status_id", "assigned_to_id"],

         :operators => {"assigned_to_id" => "=", "status_id" => "o"},

         :values => { "assigned_to_id" => ["1"], "status_id" => ["1"]},

         :query => {"name" => "test_new_project_private_query", "is_public" => "1"}

    q = Query.find_by_name('test_new_project_private_query')

    assert_redirected_to :controller => 'issues', :action => 'index', :project_id => 'ecookbook', :query_id => q

    assert !q.is_public?

    assert q.has_default_columns?

    assert q.valid?

  end

  def test_create_global_private_query_with_custom_columns

    @request.session[:user_id] = 3

    post :create,

         :fields => ["status_id", "assigned_to_id"],

         :operators => {"assigned_to_id" => "=", "status_id" => "o"},

         :values => { "assigned_to_id" => ["me"], "status_id" => ["1"]},

         :query => {"name" => "test_new_global_private_query", "is_public" => "1"},

         :c => ["", "tracker", "subject", "priority", "category"]

    q = Query.find_by_name('test_new_global_private_query')

    assert_redirected_to :controller => 'issues', :action => 'index', :project_id => nil, :query_id => q

    assert !q.is_public?

    assert !q.has_default_columns?

    assert_equal [:id, :tracker, :subject, :priority, :category], q.columns.collect {|c| c.name}

    assert q.valid?

  end

  def test_create_global_query_with_custom_filters

    @request.session[:user_id] = 3

    post :create,

         :fields => ["assigned_to_id"],

         :operators => {"assigned_to_id" => "="},

         :values => { "assigned_to_id" => ["me"]},

         :query => {"name" => "test_new_global_query"}

    q = Query.find_by_name('test_new_global_query')

    assert_redirected_to :controller => 'issues', :action => 'index', :project_id => nil, :query_id => q

    assert !q.has_filter?(:status_id)

    assert_equal ['assigned_to_id'], q.filters.keys

    assert q.valid?

  end

  def test_create_with_sort

    @request.session[:user_id] = 1

    post :create,

         :default_columns => '1',

         :operators => {"status_id" => "o"},

         :values => {"status_id" => ["1"]},

         :query => {:name => "test_new_with_sort",

                    :is_public => "1",

                    :sort_criteria => {"0" => ["due_date", "desc"], "1" => ["tracker", ""]}}

    query = Query.find_by_name("test_new_with_sort")

    assert_not_nil query

    assert_equal [['due_date', 'desc'], ['tracker', 'asc']], query.sort_criteria

  end

  def test_create_with_failure

    @request.session[:user_id] = 2

    assert_no_difference '::Query.count' do

      post :create, :project_id => 'ecookbook', :query => {:name => ''}

    end

    assert_response :success

    assert_template 'new'

    assert_select 'input[name=?]', 'query[name]'

  end

  def test_edit_global_public_query

    @request.session[:user_id] = 1

    get :edit, :id => 4

    assert_response :success

    assert_template 'edit'

    assert_tag :tag => 'input', :attributes => { :type => 'checkbox',

                                                 :name => 'query[is_public]',

                                                 :checked => 'checked' }

    assert_tag :tag => 'input', :attributes => { :type => 'checkbox',

                                                 :name => 'query_is_for_all',

                                                 :checked => 'checked',

                                                 :disabled => 'disabled' }

  end

  def test_edit_global_private_query

    @request.session[:user_id] = 3

    get :edit, :id => 3

    assert_response :success

    assert_template 'edit'

    assert_no_tag :tag => 'input', :attributes => { :type => 'checkbox',

                                                    :name => 'query[is_public]' }

    assert_tag :tag => 'input', :attributes => { :type => 'checkbox',

                                                 :name => 'query_is_for_all',

                                                 :checked => 'checked',

                                                 :disabled => 'disabled' }

  end

  def test_edit_project_private_query

    @request.session[:user_id] = 3

    get :edit, :id => 2

    assert_response :success

    assert_template 'edit'

    assert_no_tag :tag => 'input', :attributes => { :type => 'checkbox',

                                                    :name => 'query[is_public]' }

    assert_tag :tag => 'input', :attributes => { :type => 'checkbox',

                                                 :name => 'query_is_for_all',

                                                 :checked => nil,

                                                 :disabled => nil }

  end

  def test_edit_project_public_query

    @request.session[:user_id] = 2

    get :edit, :id => 1

    assert_response :success

    assert_template 'edit'

    assert_tag :tag => 'input', :attributes => { :type => 'checkbox',

                                                 :name => 'query[is_public]',

                                                 :checked => 'checked'

                                                  }

    assert_tag :tag => 'input', :attributes => { :type => 'checkbox',

                                                 :name => 'query_is_for_all',

                                                 :checked => nil,

                                                 :disabled => 'disabled' }

  end

  def test_edit_sort_criteria

    @request.session[:user_id] = 1

    get :edit, :id => 5

    assert_response :success

    assert_template 'edit'

    assert_tag :tag => 'select', :attributes => { :name => 'query[sort_criteria][0][]' },

                                 :child => { :tag => 'option', :attributes => { :value => 'priority',

                                                                                :selected => 'selected' } }

    assert_tag :tag => 'select', :attributes => { :name => 'query[sort_criteria][0][]' },

                                 :child => { :tag => 'option', :attributes => { :value => 'desc',

                                                                                :selected => 'selected' } }

  end

  def test_edit_invalid_query

    @request.session[:user_id] = 2

    get :edit, :id => 99

    assert_response 404

  end

  def test_udpate_global_private_query

    @request.session[:user_id] = 3

    put :update,

         :id => 3,

         :default_columns => '1',

         :fields => ["status_id", "assigned_to_id"],

         :operators => {"assigned_to_id" => "=", "status_id" => "o"},

         :values => { "assigned_to_id" => ["me"], "status_id" => ["1"]},

         :query => {"name" => "test_edit_global_private_query", "is_public" => "1"}

    assert_redirected_to :controller => 'issues', :action => 'index', :query_id => 3

    q = Query.find_by_name('test_edit_global_private_query')

    assert !q.is_public?

    assert q.has_default_columns?

    assert q.valid?

  end

  def test_update_global_public_query

    @request.session[:user_id] = 1

    put :update,

         :id => 4,

         :default_columns => '1',

         :fields => ["status_id", "assigned_to_id"],

         :operators => {"assigned_to_id" => "=", "status_id" => "o"},

         :values => { "assigned_to_id" => ["1"], "status_id" => ["1"]},

         :query => {"name" => "test_edit_global_public_query", "is_public" => "1"}

    assert_redirected_to :controller => 'issues', :action => 'index', :query_id => 4

    q = Query.find_by_name('test_edit_global_public_query')

    assert q.is_public?

    assert q.has_default_columns?

    assert q.valid?

  end

  def test_update_with_failure

    @request.session[:user_id] = 1

    put :update, :id => 4, :query => {:name => ''}

    assert_response :success

    assert_template 'edit'

  end

  def test_destroy

    @request.session[:user_id] = 2

    delete :destroy, :id => 1

    assert_redirected_to :controller => 'issues', :action => 'index', :project_id => 'ecookbook', :set_filter => 1, :query_id => nil

    assert_nil Query.find_by_id(1)

  end

  def test_backslash_should_be_escaped_in_filters

    @request.session[:user_id] = 2

    get :new, :subject => 'foo/bar'

    assert_response :success

    assert_template 'new'

    assert_include 'addFilter("subject", "=", ["foo\/bar"]);', response.body

  end

end

<div class="contextual">

<%= link_to l(:button_log_time), 

            {:controller => 'timelog', :action => 'new', :project_id => @project, :issue_id => @issue},

            :class => 'icon icon-time-add' if User.current.allowed_to?(:log_time, @project, :global => true) %>

</div>

<%= render_timelog_breadcrumb %>

<h2><%= l(:label_spent_time) %></h2>

<%= form_tag({:controller => 'timelog', :action => 'index', :project_id => @project, :issue_id => @issue}, :method => :get, :id => 'query_form') do %>

<%= render :partial => 'date_range' %>

<% end %>

<div class="total-hours">

<p><%= l(:label_total_time) %>: <%= html_hours(l_hours(@total_hours)) %></p>

</div>

<% unless @entries.empty? %>

<%= render :partial => 'list', :locals => { :entries => @entries }%>

<p class="pagination"><%= pagination_links_full @entry_pages, @entry_count %></p>

<% other_formats_links do |f| %>

  <%= f.link_to 'Atom', :url => params.merge({:issue_id => @issue, :key => User.current.rss_key}) %>

  <%= f.link_to 'CSV', :url => params, :onclick => "showModal('csv-export-options', '330px'); return false;" %>

<% end %>

<div id="csv-export-options" style="display:none;">

  <h3 class="title"><%= l(:label_export_options, :export_format => 'CSV') %></h3>

  <%= form_tag(params.slice(:project_id, :issue_id).merge(:format => 'csv', :page=>nil), :method => :get, :id => 'csv-export-form') do %>

  <%= query_hidden_tags @query %>

  <p>

    <label><%= radio_button_tag 'columns', '', true %> <%= l(:description_selected_columns) %></label><br />

    <label><%= radio_button_tag 'columns', 'all' %> <%= l(:description_all_columns) %></label>

  </p>

  <p class="buttons">

    <%= submit_tag l(:button_export), :name => nil, :onclick => "hideModal(this);" %>

    <%= submit_tag l(:button_cancel), :name => nil, :onclick => "hideModal(this);", :type => 'button' %>

  </p>

  <% end %>

</div>

<% end %>

<% html_title l(:label_spent_time), l(:label_details) %>

<% content_for :header_tags do %>

    <%= auto_discovery_link_tag(:atom, {:issue_id => @issue, :format => 'atom', :key => User.current.rss_key}, :title => l(:label_spent_time)) %>

<% end %>

# Redmine - project management software

# Copyright (C) 2006-2013  Jean-Philippe Lang

#

# 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.

require File.expand_path('../../../../test_helper', __FILE__)

class Redmine::ConfigurationTest < ActiveSupport::TestCase

  def setup

    @conf = Redmine::Configuration

  end

  def test_empty

    assert_kind_of Hash, load_conf('empty.yml', 'test')

  end

  def test_default

    assert_kind_of Hash, load_conf('default.yml', 'test')

    assert_equal 'foo', @conf['somesetting']

  end

  def test_no_default

    assert_kind_of Hash, load_conf('no_default.yml', 'test')

    assert_equal 'foo', @conf['somesetting']

  end

  def test_overrides

    assert_kind_of Hash, load_conf('overrides.yml', 'test')

    assert_equal 'bar', @conf['somesetting']

  end

  def test_with

    load_conf('default.yml', 'test')

    assert_equal 'foo', @conf['somesetting']

    @conf.with 'somesetting' => 'bar' do

      assert_equal 'bar', @conf['somesetting']

    end

    assert_equal 'foo', @conf['somesetting']

  end

  private

  def load_conf(file, env)

    @conf.load(

      :file => File.join(Rails.root, 'test', 'fixtures', 'configuration', file),

      :env => env

    )

  end

end