time_entry_reports_controller_test.rb
352 lines
| 13.1 KiB
| text/x-ruby
|
RubyLexer
Eric Davis
|
r4118 | # -*- coding: utf-8 -*- | ||
Jean-Philippe Lang
|
r10709 | # Redmine - project management software | ||
|
Jean-Philippe Lang
|
r14856 | # Copyright (C) 2006-2016 Jean-Philippe Lang | ||
|
Jean-Philippe Lang
|
r10709 | # | ||
| # 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. | ||||
Jean-Baptiste Barth
|
r4395 | require File.expand_path('../../test_helper', __FILE__) | ||
|
Eric Davis
|
r4118 | |||
|
Jean-Philippe Lang
|
r15279 | class TimeEntryReportsControllerTest < Redmine::ControllerTest | ||
|
Jean-Philippe Lang
|
r7907 | tests TimelogController | ||
Toshi MARUYAMA
|
r7644 | fixtures :projects, :enabled_modules, :roles, :members, :member_roles, | ||
|
Toshi MARUYAMA
|
r13548 | :email_addresses, | ||
|
Toshi MARUYAMA
|
r7644 | :issues, :time_entries, :users, :trackers, :enumerations, | ||
|
Toshi MARUYAMA
|
r12605 | :issue_statuses, :custom_fields, :custom_values, | ||
| :projects_trackers, :custom_fields_trackers, | ||||
| :custom_fields_projects | ||||
|
Eric Davis
|
r4118 | |||
|
Toshi MARUYAMA
|
r7829 | include Redmine::I18n | ||
|
Toshi MARUYAMA
|
r7691 | def setup | ||
| Setting.default_language = "en" | ||||
| end | ||||
|
Jean-Philippe Lang
|
r5177 | def test_report_at_project_level | ||
|
Jean-Philippe Lang
|
r15284 | get :report, :params => {:project_id => 'ecookbook'} | ||
|
Eric Davis
|
r4118 | assert_response :success | ||
|
Jean-Philippe Lang
|
r13242 | assert_select 'form#query_form[action=?]', '/projects/ecookbook/time_entries/report' | ||
|
Eric Davis
|
r4118 | end | ||
|
Toshi MARUYAMA
|
r6492 | |||
|
Eric Davis
|
r4118 | def test_report_all_projects | ||
| get :report | ||||
| assert_response :success | ||||
|
Jean-Philippe Lang
|
r13242 | assert_select 'form#query_form[action=?]', '/time_entries/report' | ||
|
Eric Davis
|
r4118 | end | ||
|
Toshi MARUYAMA
|
r6492 | |||
|
Eric Davis
|
r4118 | def test_report_all_projects_denied | ||
| r = Role.anonymous | ||||
| r.permissions.delete(:view_time_entries) | ||||
| r.permissions_will_change! | ||||
| r.save | ||||
| get :report | ||||
| assert_redirected_to '/login?back_url=http%3A%2F%2Ftest.host%2Ftime_entries%2Freport' | ||||
| end | ||||
|
Toshi MARUYAMA
|
r6492 | |||
|
Eric Davis
|
r4118 | def test_report_all_projects_one_criteria | ||
|
Jean-Philippe Lang
|
r15284 | get :report, :params => {:columns => 'week', :from => "2007-04-01", :to => "2007-04-30", :criteria => ['project']} | ||
|
Eric Davis
|
r4118 | assert_response :success | ||
|
Jean-Philippe Lang
|
r15342 | assert_select 'tr.total td:last', :text => '8.65' | ||
|
Eric Davis
|
r4118 | end | ||
| def test_report_all_time | ||||
|
Jean-Philippe Lang
|
r15284 | get :report, :params => {:project_id => 1, :criteria => ['project', 'issue']} | ||
|
Eric Davis
|
r4118 | assert_response :success | ||
|
Jean-Philippe Lang
|
r15342 | assert_select 'tr.total td:last', :text => '162.90' | ||
|
Eric Davis
|
r4118 | end | ||
| def test_report_all_time_by_day | ||||
|
Jean-Philippe Lang
|
r15284 | get :report, :params => {:project_id => 1, :criteria => ['project', 'issue'], :columns => 'day'} | ||
|
Eric Davis
|
r4118 | assert_response :success | ||
|
Jean-Philippe Lang
|
r15342 | assert_select 'tr.total td:last', :text => '162.90' | ||
|
Jean-Philippe Lang
|
r13242 | assert_select 'th', :text => '2007-03-12' | ||
|
Eric Davis
|
r4118 | end | ||
|
Toshi MARUYAMA
|
r6492 | |||
|
Eric Davis
|
r4118 | def test_report_one_criteria | ||
|
Jean-Philippe Lang
|
r15284 | get :report, :params => {:project_id => 1, :columns => 'week', :from => "2007-04-01", :to => "2007-04-30", :criteria => ['project']} | ||
|
Eric Davis
|
r4118 | assert_response :success | ||
|
Jean-Philippe Lang
|
r15342 | assert_select 'tr.total td:last', :text => '8.65' | ||
|
Eric Davis
|
r4118 | end | ||
|
Toshi MARUYAMA
|
r6492 | |||
|
Jean-Philippe Lang
|
r7906 | def test_report_two_criteria | ||
|
Jean-Philippe Lang
|
r15284 | get :report, :params => {:project_id => 1, :columns => 'month', :from => "2007-01-01", :to => "2007-12-31", :criteria => ["user", "activity"]} | ||
|
Eric Davis
|
r4118 | assert_response :success | ||
|
Jean-Philippe Lang
|
r15342 | assert_select 'tr.total td:last', :text => '162.90' | ||
|
Eric Davis
|
r4118 | end | ||
|
Toshi MARUYAMA
|
r6492 | |||
|
Jean-Philippe Lang
|
r12780 | def test_report_custom_field_criteria_with_multiple_values_on_single_value_custom_field_should_not_fail | ||
|
Jean-Philippe Lang
|
r9648 | field = TimeEntryCustomField.create!(:name => 'multi', :field_format => 'list', :possible_values => ['value1', 'value2']) | ||
| entry = TimeEntry.create!(:project => Project.find(1), :hours => 1, :activity_id => 10, :user => User.find(2), :spent_on => Date.today) | ||||
| CustomValue.create!(:customized => entry, :custom_field => field, :value => 'value1') | ||||
| CustomValue.create!(:customized => entry, :custom_field => field, :value => 'value2') | ||||
|
Jean-Philippe Lang
|
r15284 | get :report, :params => {:project_id => 1, :columns => 'day', :criteria => ["cf_#{field.id}"]} | ||
|
Jean-Philippe Lang
|
r9648 | assert_response :success | ||
| end | ||||
|
Jean-Philippe Lang
|
r12780 | def test_report_multiple_values_custom_fields_should_not_be_proposed | ||
| TimeEntryCustomField.create!(:name => 'Single', :field_format => 'list', :possible_values => ['value1', 'value2']) | ||||
| TimeEntryCustomField.create!(:name => 'Multi', :field_format => 'list', :multiple => true, :possible_values => ['value1', 'value2']) | ||||
|
Jean-Philippe Lang
|
r15284 | get :report, :params => {:project_id => 1} | ||
|
Jean-Philippe Lang
|
r12780 | assert_response :success | ||
| assert_select 'select[name=?]', 'criteria[]' do | ||||
| assert_select 'option', :text => 'Single' | ||||
| assert_select 'option', :text => 'Multi', :count => 0 | ||||
| end | ||||
| end | ||||
|
Eric Davis
|
r4118 | def test_report_one_day | ||
|
Jean-Philippe Lang
|
r15284 | get :report, :params => {:project_id => 1, :columns => 'day', :from => "2007-03-23", :to => "2007-03-23", :criteria => ["user", "activity"]} | ||
|
Eric Davis
|
r4118 | assert_response :success | ||
|
Jean-Philippe Lang
|
r15342 | assert_select 'tr.total td:last', :text => '4.25' | ||
|
Eric Davis
|
r4118 | end | ||
|
Toshi MARUYAMA
|
r6492 | |||
|
Jean-Philippe Lang
|
r11241 | def test_report_by_week_should_use_commercial_year | ||
| TimeEntry.delete_all | ||||
| TimeEntry.generate!(:hours => '2', :spent_on => '2009-12-25') # 2009-52 | ||||
| TimeEntry.generate!(:hours => '4', :spent_on => '2009-12-31') # 2009-53 | ||||
| TimeEntry.generate!(:hours => '8', :spent_on => '2010-01-01') # 2009-53 | ||||
| TimeEntry.generate!(:hours => '16', :spent_on => '2010-01-05') # 2010-1 | ||||
|
Jean-Philippe Lang
|
r15284 | get :report, :params => {:columns => 'week', :from => "2009-12-25", :to => "2010-01-05", :criteria => ["project"]} | ||
|
Jean-Philippe Lang
|
r11241 | assert_response :success | ||
| assert_select '#time-report thead tr' do | ||||
| assert_select 'th:nth-child(1)', :text => 'Project' | ||||
| assert_select 'th:nth-child(2)', :text => '2009-52' | ||||
| assert_select 'th:nth-child(3)', :text => '2009-53' | ||||
| assert_select 'th:nth-child(4)', :text => '2010-1' | ||||
|
Jean-Philippe Lang
|
r11352 | assert_select 'th:nth-child(5)', :text => 'Total time' | ||
|
Jean-Philippe Lang
|
r11241 | end | ||
| assert_select '#time-report tbody tr' do | ||||
| assert_select 'td:nth-child(1)', :text => 'eCookbook' | ||||
| assert_select 'td:nth-child(2)', :text => '2.00' | ||||
| assert_select 'td:nth-child(3)', :text => '12.00' | ||||
| assert_select 'td:nth-child(4)', :text => '16.00' | ||||
| assert_select 'td:nth-child(5)', :text => '30.00' # Total | ||||
| end | ||||
| end | ||||
|
Jean-Philippe Lang
|
r11229 | def test_report_should_propose_association_custom_fields | ||
| get :report | ||||
| assert_response :success | ||||
| assert_select 'select[name=?]', 'criteria[]' do | ||||
| assert_select 'option[value=cf_1]', {:text => 'Database'}, 'Issue custom field not found' | ||||
| assert_select 'option[value=cf_3]', {:text => 'Development status'}, 'Project custom field not found' | ||||
| assert_select 'option[value=cf_7]', {:text => 'Billable'}, 'TimeEntryActivity custom field not found' | ||||
| end | ||||
| end | ||||
| def test_report_with_association_custom_fields | ||||
|
Jean-Philippe Lang
|
r15284 | get :report, :params => {:criteria => ['cf_1', 'cf_3', 'cf_7']} | ||
|
Eric Davis
|
r4118 | assert_response :success | ||
|
Jean-Philippe Lang
|
r15342 | |||
| assert_select 'tr.total td:last', :text => '162.90' | ||||
|
Jean-Philippe Lang
|
r11229 | |||
| # Custom fields columns | ||||
| assert_select 'th', :text => 'Database' | ||||
| assert_select 'th', :text => 'Development status' | ||||
| assert_select 'th', :text => 'Billable' | ||||
|
Eric Davis
|
r4118 | # Custom field row | ||
|
Jean-Philippe Lang
|
r11229 | assert_select 'tr' do | ||
| assert_select 'td', :text => 'MySQL' | ||||
| assert_select 'td.hours', :text => '1.00' | ||||
| end | ||||
|
Eric Davis
|
r4118 | end | ||
|
Toshi MARUYAMA
|
r6492 | |||
|
Eric Davis
|
r4118 | def test_report_one_criteria_no_result | ||
|
Jean-Philippe Lang
|
r15284 | get :report, :params => {:project_id => 1, :columns => 'week', :from => "1998-04-01", :to => "1998-04-30", :criteria => ['project']} | ||
|
Eric Davis
|
r4118 | assert_response :success | ||
|
Jean-Philippe Lang
|
r15342 | |||
| assert_select '.nodata' | ||||
|
Eric Davis
|
r4118 | end | ||
|
Toshi MARUYAMA
|
r6492 | |||
|
Jean-Philippe Lang
|
r8523 | def test_report_status_criterion | ||
|
Jean-Philippe Lang
|
r15284 | get :report, :params => {:project_id => 1, :criteria => ['status']} | ||
|
Jean-Philippe Lang
|
r8523 | assert_response :success | ||
|
Jean-Philippe Lang
|
r15342 | |||
|
Jean-Philippe Lang
|
r13242 | assert_select 'th', :text => 'Status' | ||
| assert_select 'td', :text => 'New' | ||||
|
Jean-Philippe Lang
|
r8523 | end | ||
|
Eric Davis
|
r4118 | def test_report_all_projects_csv_export | ||
|
Jean-Philippe Lang
|
r15284 | get :report, :params => { | ||
| :columns => 'month', | ||||
| :from => "2007-01-01", | ||||
| :to => "2007-06-30", | ||||
| :criteria => ["project", "user", "activity"], | ||||
| :format => "csv" | ||||
| } | ||||
|
Eric Davis
|
r4118 | assert_response :success | ||
|
Jean-Philippe Lang
|
r9346 | assert_equal 'text/csv; header=present', @response.content_type | ||
|
Eric Davis
|
r4118 | lines = @response.body.chomp.split("\n") | ||
| # Headers | ||||
|
Jean-Philippe Lang
|
r11352 | assert_equal 'Project,User,Activity,2007-3,2007-4,Total time', lines.first | ||
|
Eric Davis
|
r4118 | # Total row | ||
|
Jean-Philippe Lang
|
r11352 | assert_equal 'Total time,"","",154.25,8.65,162.90', lines.last | ||
|
Eric Davis
|
r4118 | end | ||
|
Toshi MARUYAMA
|
r6492 | |||
|
Eric Davis
|
r4118 | def test_report_csv_export | ||
|
Jean-Philippe Lang
|
r15284 | get :report, :params => { | ||
| :project_id => 1, | ||||
| :columns => 'month', | ||||
| :from => "2007-01-01", | ||||
| :to => "2007-06-30", | ||||
| :criteria => ["project", "user", "activity"], | ||||
| :format => "csv" | ||||
| } | ||||
|
Eric Davis
|
r4118 | assert_response :success | ||
|
Jean-Philippe Lang
|
r9346 | assert_equal 'text/csv; header=present', @response.content_type | ||
|
Eric Davis
|
r4118 | lines = @response.body.chomp.split("\n") | ||
| # Headers | ||||
|
Jean-Philippe Lang
|
r11352 | assert_equal 'Project,User,Activity,2007-3,2007-4,Total time', lines.first | ||
|
Eric Davis
|
r4118 | # Total row | ||
|
Jean-Philippe Lang
|
r11352 | assert_equal 'Total time,"","",154.25,8.65,162.90', lines.last | ||
|
Eric Davis
|
r4118 | end | ||
|
Toshi MARUYAMA
|
r7691 | |||
| def test_csv_big_5 | ||||
|
Jean-Philippe Lang
|
r13100 | str_utf8 = "\xe4\xb8\x80\xe6\x9c\x88".force_encoding('UTF-8') | ||
| str_big5 = "\xa4@\xa4\xeb".force_encoding('Big5') | ||||
|
Toshi MARUYAMA
|
r7691 | user = User.find_by_id(3) | ||
| user.firstname = str_utf8 | ||||
| user.lastname = "test-lastname" | ||||
| assert user.save | ||||
| comments = "test_csv_big_5" | ||||
| te1 = TimeEntry.create(:spent_on => '2011-11-11', | ||||
| :hours => 7.3, | ||||
| :project => Project.find(1), | ||||
| :user => user, | ||||
| :activity => TimeEntryActivity.find_by_name('Design'), | ||||
| :comments => comments) | ||||
| te2 = TimeEntry.find_by_comments(comments) | ||||
| assert_not_nil te2 | ||||
| assert_equal 7.3, te2.hours | ||||
| assert_equal 3, te2.user_id | ||||
|
Jean-Philippe Lang
|
r13542 | with_settings :default_language => "zh-TW" do | ||
|
Jean-Philippe Lang
|
r15284 | get :report, :params => { | ||
| :project_id => 1, | ||||
| :columns => 'day', | ||||
| :from => "2011-11-11", | ||||
| :to => "2011-11-11", | ||||
| :criteria => ["user"], | ||||
| :format => "csv" | ||||
| } | ||||
|
Jean-Philippe Lang
|
r13542 | end | ||
|
Toshi MARUYAMA
|
r7691 | assert_response :success | ||
|
Jean-Philippe Lang
|
r9346 | assert_equal 'text/csv; header=present', @response.content_type | ||
|
Toshi MARUYAMA
|
r7691 | lines = @response.body.chomp.split("\n") | ||
| # Headers | ||||
|
Jean-Philippe Lang
|
r13100 | s1 = "\xa5\xce\xa4\xe1,2011-11-11,\xa4u\xae\xc9\xc1`\xadp".force_encoding('Big5') | ||
| s2 = "\xa4u\xae\xc9\xc1`\xadp".force_encoding('Big5') | ||||
|
Toshi MARUYAMA
|
r7691 | assert_equal s1, lines.first | ||
| # Total row | ||||
| assert_equal "#{str_big5} #{user.lastname},7.30,7.30", lines[1] | ||||
|
Toshi MARUYAMA
|
r7827 | assert_equal "#{s2},7.30,7.30", lines[2] | ||
|
Toshi MARUYAMA
|
r7829 | |||
|
Jean-Philippe Lang
|
r13100 | str_tw = "Traditional Chinese (\xe7\xb9\x81\xe9\xab\x94\xe4\xb8\xad\xe6\x96\x87)".force_encoding('UTF-8') | ||
|
Toshi MARUYAMA
|
r7829 | assert_equal str_tw, l(:general_lang_name) | ||
| assert_equal 'Big5', l(:general_csv_encoding) | ||||
| assert_equal ',', l(:general_csv_separator) | ||||
| assert_equal '.', l(:general_csv_decimal_separator) | ||||
|
Toshi MARUYAMA
|
r7691 | end | ||
|
Toshi MARUYAMA
|
r7700 | |||
| def test_csv_cannot_convert_should_be_replaced_big_5 | ||||
|
Jean-Philippe Lang
|
r13100 | str_utf8 = "\xe4\xbb\xa5\xe5\x86\x85".force_encoding('UTF-8') | ||
|
Toshi MARUYAMA
|
r7700 | user = User.find_by_id(3) | ||
| user.firstname = str_utf8 | ||||
| user.lastname = "test-lastname" | ||||
| assert user.save | ||||
| comments = "test_replaced" | ||||
| te1 = TimeEntry.create(:spent_on => '2011-11-11', | ||||
| :hours => 7.3, | ||||
| :project => Project.find(1), | ||||
| :user => user, | ||||
| :activity => TimeEntryActivity.find_by_name('Design'), | ||||
| :comments => comments) | ||||
| te2 = TimeEntry.find_by_comments(comments) | ||||
| assert_not_nil te2 | ||||
| assert_equal 7.3, te2.hours | ||||
| assert_equal 3, te2.user_id | ||||
|
Jean-Philippe Lang
|
r13542 | with_settings :default_language => "zh-TW" do | ||
|
Jean-Philippe Lang
|
r15284 | get :report, :params => { | ||
| :project_id => 1, | ||||
| :columns => 'day', | ||||
| :from => "2011-11-11", | ||||
| :to => "2011-11-11", | ||||
| :criteria => ["user"], | ||||
| :format => "csv" | ||||
| } | ||||
|
Jean-Philippe Lang
|
r13542 | end | ||
|
Toshi MARUYAMA
|
r7700 | assert_response :success | ||
|
Jean-Philippe Lang
|
r9346 | assert_equal 'text/csv; header=present', @response.content_type | ||
|
Toshi MARUYAMA
|
r7700 | lines = @response.body.chomp.split("\n") | ||
| # Headers | ||||
|
Jean-Philippe Lang
|
r13100 | s1 = "\xa5\xce\xa4\xe1,2011-11-11,\xa4u\xae\xc9\xc1`\xadp".force_encoding('Big5') | ||
|
Toshi MARUYAMA
|
r7700 | assert_equal s1, lines.first | ||
| # Total row | ||||
|
Jean-Philippe Lang
|
r13100 | s2 = "\xa5H?".force_encoding('Big5') | ||
|
Toshi MARUYAMA
|
r7700 | assert_equal "#{s2} #{user.lastname},7.30,7.30", lines[1] | ||
| end | ||||
|
Toshi MARUYAMA
|
r7831 | |||
| def test_csv_fr | ||||
| with_settings :default_language => "fr" do | ||||
| str1 = "test_csv_fr" | ||||
| user = User.find_by_id(3) | ||||
| te1 = TimeEntry.create(:spent_on => '2011-11-11', | ||||
| :hours => 7.3, | ||||
| :project => Project.find(1), | ||||
| :user => user, | ||||
| :activity => TimeEntryActivity.find_by_name('Design'), | ||||
| :comments => str1) | ||||
| te2 = TimeEntry.find_by_comments(str1) | ||||
| assert_not_nil te2 | ||||
| assert_equal 7.3, te2.hours | ||||
| assert_equal 3, te2.user_id | ||||
|
Jean-Philippe Lang
|
r15284 | get :report, :params => { | ||
| :project_id => 1, | ||||
| :columns => 'day', | ||||
| :from => "2011-11-11", | ||||
| :to => "2011-11-11", | ||||
| :criteria => ["user"], | ||||
| :format => "csv" | ||||
| } | ||||
|
Toshi MARUYAMA
|
r7831 | assert_response :success | ||
|
Jean-Philippe Lang
|
r9346 | assert_equal 'text/csv; header=present', @response.content_type | ||
|
Toshi MARUYAMA
|
r7831 | lines = @response.body.chomp.split("\n") | ||
| # Headers | ||||
|
Jean-Philippe Lang
|
r13100 | s1 = "Utilisateur;2011-11-11;Temps total".force_encoding('ISO-8859-1') | ||
| s2 = "Temps total".force_encoding('ISO-8859-1') | ||||
|
Toshi MARUYAMA
|
r7831 | assert_equal s1, lines.first | ||
| # Total row | ||||
| assert_equal "#{user.firstname} #{user.lastname};7,30;7,30", lines[1] | ||||
| assert_equal "#{s2};7,30;7,30", lines[2] | ||||
|
Toshi MARUYAMA
|
r13528 | str_fr = "French (Fran\xc3\xa7ais)".force_encoding('UTF-8') | ||
|
Toshi MARUYAMA
|
r7831 | assert_equal str_fr, l(:general_lang_name) | ||
| assert_equal 'ISO-8859-1', l(:general_csv_encoding) | ||||
| assert_equal ';', l(:general_csv_separator) | ||||
| assert_equal ',', l(:general_csv_decimal_separator) | ||||
| end | ||||
| end | ||||
|
Eric Davis
|
r4118 | end | ||