jro_apps/redmine Commit - r15263:0e514b3144bf

1

# Redmine - project management software

1

# Redmine - project management software

2

3

#

3

#

4

# This program is free software; you can redistribute it and/or

4

# This program is free software; you can redistribute it and/or

5

# modify it under the terms of the GNU General Public License

5

# modify it under the terms of the GNU General Public License

6

# as published by the Free Software Foundation; either version 2

6

# as published by the Free Software Foundation; either version 2

7

# of the License, or (at your option) any later version.

7

# of the License, or (at your option) any later version.

8

#

8

#

9

# This program is distributed in the hope that it will be useful,

9

# This program is distributed in the hope that it will be useful,

10

# but WITHOUT ANY WARRANTY; without even the implied warranty of

10

# but WITHOUT ANY WARRANTY; without even the implied warranty of

11

# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the

11

# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the

12

# GNU General Public License for more details.

12

# GNU General Public License for more details.

13

#

13

#

14

# You should have received a copy of the GNU General Public License

14

# You should have received a copy of the GNU General Public License

15

# along with this program; if not, write to the Free Software

15

# along with this program; if not, write to the Free Software

16

# Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA.

16

# Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA.

17

18

module Redmine

18

module Redmine

19

module Helpers

19

module Helpers

20

class TimeReport

20

class TimeReport

21

attr_reader :criteria, :columns, :hours, :total_hours, :periods

21

attr_reader :criteria, :columns, :hours, :total_hours, :periods

22

23

def initialize(project, issue, criteria, columns, time_entry_scope)

23

def initialize(project, issue, criteria, columns, time_entry_scope)

24

@project = project

24

@project = project

25

@issue = issue

25

@issue = issue

26

27

@criteria = criteria || []

27

@criteria = criteria || []

28

@criteria = @criteria.select{|criteria| available_criteria.has_key? criteria}

28

@criteria = @criteria.select{|criteria| available_criteria.has_key? criteria}

29

@criteria.uniq!

29

@criteria.uniq!

30

@criteria = @criteria[0,3]

30

@criteria = @criteria[0,3]

31

32

@columns = (columns && %w(year month week day).include?(columns)) ? columns : 'month'

32

@columns = (columns && %w(year month week day).include?(columns)) ? columns : 'month'

33

@scope = time_entry_scope

33

@scope = time_entry_scope

34

35

run

35

run

36

end

36

end

37

38

def available_criteria

38

def available_criteria

39

@available_criteria || load_available_criteria

39

@available_criteria || load_available_criteria

40

end

40

end

41

42

private

42

private

43

44

def run

44

def run

45

unless @criteria.empty?

45

unless @criteria.empty?

46

time_columns = %w(tyear tmonth tweek spent_on)

46

time_columns = %w(tyear tmonth tweek spent_on)

47

@hours = []

47

@hours = []

48

@scope.includes(:issue, :activity).

48

@scope.includes(:issue, :activity).

49

group(@criteria.collect{|criteria| @available_criteria[criteria][:sql]} + time_columns).

49

group(@criteria.collect{|criteria| @available_criteria[criteria][:sql]} + time_columns).

50

joins(@criteria.collect{|criteria| @available_criteria[criteria][:joins]}.compact).

50

joins(@criteria.collect{|criteria| @available_criteria[criteria][:joins]}.compact).

51

sum(:hours).each do |hash, hours|

51

sum(:hours).each do |hash, hours|

52

h = {'hours' => hours}

52

h = {'hours' => hours}

53

(@criteria + time_columns).each_with_index do |name, i|

53

(@criteria + time_columns).each_with_index do |name, i|

54

h[name] = hash[i]

54

h[name] = hash[i]

55

end

55

end

56

@hours << h

56

@hours << h

57

end

57

end

58

59

@hours.each do |row|

59

@hours.each do |row|

60

case @columns

60

case @columns

61

when 'year'

61

when 'year'

62

row['year'] = row['tyear']

62

row['year'] = row['tyear']

63

when 'month'

63

when 'month'

64

row['month'] = "#{row['tyear']}-#{row['tmonth']}"

64

row['month'] = "#{row['tyear']}-#{row['tmonth']}"

65

when 'week'

65

when 'week'

66

row['week'] = "#{row['spent_on'].cwyear}-#{row['tweek']}"

66

row['week'] = "#{row['spent_on'].cwyear}-#{row['tweek']}"

67

when 'day'

67

when 'day'

68

row['day'] = "#{row['spent_on']}"

68

row['day'] = "#{row['spent_on']}"

69

end

69

end

70

end

70

end

71

72

min = @hours.collect {|row| row['spent_on']}.min

72

min = @hours.collect {|row| row['spent_on']}.min

73

@from = min ? min.to_date : User.current.today

73

@from = min ? min.to_date : User.current.today

74

75

max = @hours.collect {|row| row['spent_on']}.max

75

max = @hours.collect {|row| row['spent_on']}.max

76

@to = max ? max.to_date : User.current.today

76

@to = max ? max.to_date : User.current.today

77

78

@total_hours = @hours.inject(0) {|s,k| s = s + k['hours'].to_f}

78

@total_hours = @hours.inject(0) {|s,k| s = s + k['hours'].to_f}

79

80

@periods = []

80

@periods = []

81

# Date#at_beginning_of_ not supported in Rails 1.2.x

81

# Date#at_beginning_of_ not supported in Rails 1.2.x

82

date_from = @from.to_time

82

date_from = @from.to_time

83

# 100 columns max

83

# 100 columns max

84

while date_from <= @to.to_time && @periods.length < 100

84

while date_from <= @to.to_time && @periods.length < 100

85

case @columns

85

case @columns

86

when 'year'

86

when 'year'

87

@periods << "#{date_from.year}"

87

@periods << "#{date_from.year}"

88

date_from = (date_from + 1.year).at_beginning_of_year

88

date_from = (date_from + 1.year).at_beginning_of_year

89

when 'month'

89

when 'month'

90

@periods << "#{date_from.year}-#{date_from.month}"

90

@periods << "#{date_from.year}-#{date_from.month}"

91

date_from = (date_from + 1.month).at_beginning_of_month

91

date_from = (date_from + 1.month).at_beginning_of_month

92

when 'week'

92

when 'week'

93

@periods << "#{date_from.to_date.cwyear}-#{date_from.to_date.cweek}"

93

@periods << "#{date_from.to_date.cwyear}-#{date_from.to_date.cweek}"

94

date_from = (date_from + 7.day).at_beginning_of_week

94

date_from = (date_from + 7.day).at_beginning_of_week

95

when 'day'

95

when 'day'

96

@periods << "#{date_from.to_date}"

96

@periods << "#{date_from.to_date}"

97

date_from = date_from + 1.day

97

date_from = date_from + 1.day

98

end

98

end

99

end

99

end

100

end

100

end

101

end

101

end

102

103

def load_available_criteria

103

def load_available_criteria

104

@available_criteria = { 'project' => {:sql => "#{TimeEntry.table_name}.project_id",

104

@available_criteria = { 'project' => {:sql => "#{TimeEntry.table_name}.project_id",

105

:klass => Project,

105

:klass => Project,

106

:label => :label_project},

106

:label => :label_project},

107

'status' => {:sql => "#{Issue.table_name}.status_id",

107

'status' => {:sql => "#{Issue.table_name}.status_id",

108

:klass => IssueStatus,

108

:klass => IssueStatus,

109

:label => :field_status},

109

:label => :field_status},

110

'version' => {:sql => "#{Issue.table_name}.fixed_version_id",

110

'version' => {:sql => "#{Issue.table_name}.fixed_version_id",

111

:klass => Version,

111

:klass => ::Version,

112

:label => :label_version},

112

:label => :label_version},

113

'category' => {:sql => "#{Issue.table_name}.category_id",

113

'category' => {:sql => "#{Issue.table_name}.category_id",

114

:klass => IssueCategory,

114

:klass => IssueCategory,

115

:label => :field_category},

115

:label => :field_category},

116

'user' => {:sql => "#{TimeEntry.table_name}.user_id",

116

'user' => {:sql => "#{TimeEntry.table_name}.user_id",

117

:klass => User,

117

:klass => User,

118

:label => :label_user},

118

:label => :label_user},

119

'tracker' => {:sql => "#{Issue.table_name}.tracker_id",

119

'tracker' => {:sql => "#{Issue.table_name}.tracker_id",

120

:klass => Tracker,

120

:klass => Tracker,

121

:label => :label_tracker},

121

:label => :label_tracker},

122

'activity' => {:sql => "#{TimeEntry.table_name}.activity_id",

122

'activity' => {:sql => "#{TimeEntry.table_name}.activity_id",

123

:klass => TimeEntryActivity,

123

:klass => TimeEntryActivity,

124

:label => :label_activity},

124

:label => :label_activity},

125

'issue' => {:sql => "#{TimeEntry.table_name}.issue_id",

125

'issue' => {:sql => "#{TimeEntry.table_name}.issue_id",

126

:klass => Issue,

126

:klass => Issue,

127

:label => :label_issue}

127

:label => :label_issue}

128

}

128

}

129

130

# Add time entry custom fields

130

# Add time entry custom fields

131

custom_fields = TimeEntryCustomField.all

131

custom_fields = TimeEntryCustomField.all

132

# Add project custom fields

132

# Add project custom fields

133

custom_fields += ProjectCustomField.all

133

custom_fields += ProjectCustomField.all

134

# Add issue custom fields

134

# Add issue custom fields

135

custom_fields += (@project.nil? ? IssueCustomField.for_all : @project.all_issue_custom_fields)

135

custom_fields += (@project.nil? ? IssueCustomField.for_all : @project.all_issue_custom_fields)

136

# Add time entry activity custom fields

136

# Add time entry activity custom fields

137

custom_fields += TimeEntryActivityCustomField.all

137

custom_fields += TimeEntryActivityCustomField.all

138

139

# Add list and boolean custom fields as available criteria

139

# Add list and boolean custom fields as available criteria

140

custom_fields.select {|cf| %w(list bool).include?(cf.field_format) && !cf.multiple?}.each do |cf|

140

custom_fields.select {|cf| %w(list bool).include?(cf.field_format) && !cf.multiple?}.each do |cf|

141

@available_criteria["cf_#{cf.id}"] = {:sql => cf.group_statement,

141

@available_criteria["cf_#{cf.id}"] = {:sql => cf.group_statement,

142

:joins => cf.join_for_order_statement,

142

:joins => cf.join_for_order_statement,

143

:format => cf.field_format,

143

:format => cf.field_format,

144

:custom_field => cf,

144

:custom_field => cf,

145

:label => cf.name}

145

:label => cf.name}

146

end

146

end

147

148

@available_criteria

148

@available_criteria

149

end

149

end

150

end

150

end

151

end

151

end

152

end

152

end

	Site-wide shortcuts
/	Use quick search box
g h	Goto home page
g g	Goto my private gists page
g G	Goto my public gists page
g 0-9	Goto bookmarked items from 0-9
n r	New repository page
n g	New gist page

	Repositories
g s	Goto summary page
g c	Goto changelog page
g f	Goto files page
g F	Goto files page with file search activated
g p	Goto pull requests page
g o	Goto repository settings
g O	Goto repository access permissions settings
t s	Toggle sidebar on some pages

             # Redmine - project management software
             # Copyright (C) 2006-2016  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.
             module Redmine
               module Helpers
                 class TimeReport
                   attr_reader :criteria, :columns, :hours, :total_hours, :periods
                   def initialize(project, issue, criteria, columns, time_entry_scope)
                     @project = project
                     @issue = issue
                     @criteria = criteria || []
                     @criteria = @criteria.select{|criteria| available_criteria.has_key? criteria}
                     @criteria.uniq!
                     @criteria = @criteria[0,3]
                     @columns = (columns && %w(year month week day).include?(columns)) ? columns : 'month'
                     @scope = time_entry_scope
                     run
                   end
                   def available_criteria
                     @available_criteria || load_available_criteria
                   end
                   private
                   def run
                     unless @criteria.empty?
                       time_columns = %w(tyear tmonth tweek spent_on)
                       @hours = []
                       @scope.includes(:issue, :activity).
                           group(@criteria.collect{|criteria| @available_criteria[criteria][:sql]} + time_columns).
                           joins(@criteria.collect{|criteria| @available_criteria[criteria][:joins]}.compact).
                           sum(:hours).each do |hash, hours|
                         h = {'hours' => hours}
                         (@criteria + time_columns).each_with_index do |name, i|
                           h[name] = hash[i]
                         end
                         @hours << h
                       end
                       @hours.each do |row|
                         case @columns
                         when 'year'
                           row['year'] = row['tyear']
                         when 'month'
                           row['month'] = "#{row['tyear']}-#{row['tmonth']}"
                         when 'week'
                           row['week'] = "#{row['spent_on'].cwyear}-#{row['tweek']}"
                         when 'day'
                           row['day'] = "#{row['spent_on']}"
                         end
                       end
                       min = @hours.collect {|row| row['spent_on']}.min
                       @from = min ? min.to_date : User.current.today
                       max = @hours.collect {|row| row['spent_on']}.max
                       @to = max ? max.to_date : User.current.today
                       @total_hours = @hours.inject(0) {|s,k| s = s + k['hours'].to_f}
                       @periods = []
                       # Date#at_beginning_of_ not supported in Rails 1.2.x
                       date_from = @from.to_time
                       # 100 columns max
                       while date_from <= @to.to_time && @periods.length < 100
                         case @columns
                         when 'year'
                           @periods << "#{date_from.year}"
                           date_from = (date_from + 1.year).at_beginning_of_year
                         when 'month'
                           @periods << "#{date_from.year}-#{date_from.month}"
                           date_from = (date_from + 1.month).at_beginning_of_month
                         when 'week'
                           @periods << "#{date_from.to_date.cwyear}-#{date_from.to_date.cweek}"
                           date_from = (date_from + 7.day).at_beginning_of_week
                         when 'day'
                           @periods << "#{date_from.to_date}"
                           date_from = date_from + 1.day
                         end
                       end
                     end
                   end
                   def load_available_criteria
                     @available_criteria = { 'project' => {:sql => "#{TimeEntry.table_name}.project_id",
                                                           :klass => Project,
                                                           :label => :label_project},
                                              'status' => {:sql => "#{Issue.table_name}.status_id",
                                                           :klass => IssueStatus,
                                                           :label => :field_status},
                                              'version' => {:sql => "#{Issue.table_name}.fixed_version_id",
-                                                          :klass => Version,
+                                                          :klass => ::Version,
                                                           :label => :label_version},
                                              'category' => {:sql => "#{Issue.table_name}.category_id",
                                                             :klass => IssueCategory,
                                                             :label => :field_category},
                                              'user' => {:sql => "#{TimeEntry.table_name}.user_id",
                                                          :klass => User,
                                                          :label => :label_user},
                                              'tracker' => {:sql => "#{Issue.table_name}.tracker_id",
                                                           :klass => Tracker,
                                                           :label => :label_tracker},
                                              'activity' => {:sql => "#{TimeEntry.table_name}.activity_id",
                                                            :klass => TimeEntryActivity,
                                                            :label => :label_activity},
                                              'issue' => {:sql => "#{TimeEntry.table_name}.issue_id",
                                                          :klass => Issue,
                                                          :label => :label_issue}
                                            }
                     # Add time entry custom fields
                     custom_fields = TimeEntryCustomField.all
                     # Add project custom fields
                     custom_fields += ProjectCustomField.all
                     # Add issue custom fields
                     custom_fields += (@project.nil? ? IssueCustomField.for_all : @project.all_issue_custom_fields)
                     # Add time entry activity custom fields
                     custom_fields += TimeEntryActivityCustomField.all
                     # Add list and boolean custom fields as available criteria
                     custom_fields.select {|cf| %w(list bool).include?(cf.field_format) && !cf.multiple?}.each do |cf|
                       @available_criteria["cf_#{cf.id}"] = {:sql => cf.group_statement,
                                                              :joins => cf.join_for_order_statement,
                                                              :format => cf.field_format,
                                                              :custom_field => cf,
                                                              :label => cf.name}
                     end
                     @available_criteria
                   end
                 end
               end
             end