jro_apps/redmine Commit - r14341:e2d860b34ba9

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

class TimeEntryQuery < Query

18

class TimeEntryQuery < Query

19

20

self.queried_class = TimeEntry

20

self.queried_class = TimeEntry

21

22

self.available_columns = [

22

self.available_columns = [

23

QueryColumn.new(:project, :sortable => "#{Project.table_name}.name", :groupable => true),

23

QueryColumn.new(:project, :sortable => "#{Project.table_name}.name", :groupable => true),

24

QueryColumn.new(:spent_on, :sortable => ["#{TimeEntry.table_name}.spent_on", "#{TimeEntry.table_name}.created_on"], :default_order => 'desc', :groupable => true),

24

QueryColumn.new(:spent_on, :sortable => ["#{TimeEntry.table_name}.spent_on", "#{TimeEntry.table_name}.created_on"], :default_order => 'desc', :groupable => true),

25

QueryColumn.new(:tweek, :sortable => ["#{TimeEntry.table_name}.spent_on", "#{TimeEntry.table_name}.created_on"], :caption => l(:label_week)),

25

QueryColumn.new(:user, :sortable => lambda {User.fields_for_order_statement}, :groupable => true),

26

QueryColumn.new(:user, :sortable => lambda {User.fields_for_order_statement}, :groupable => true),

26

QueryColumn.new(:activity, :sortable => "#{TimeEntryActivity.table_name}.position", :groupable => true),

27

QueryColumn.new(:activity, :sortable => "#{TimeEntryActivity.table_name}.position", :groupable => true),

27

QueryColumn.new(:issue, :sortable => "#{Issue.table_name}.id"),

28

QueryColumn.new(:issue, :sortable => "#{Issue.table_name}.id"),

28

QueryColumn.new(:comments),

29

QueryColumn.new(:comments),

29

QueryColumn.new(:hours, :sortable => "#{TimeEntry.table_name}.hours"),

30

QueryColumn.new(:hours, :sortable => "#{TimeEntry.table_name}.hours"),

30

]

31

]

31

32

def initialize(attributes=nil, *args)

33

def initialize(attributes=nil, *args)

33

super attributes

34

super attributes

34

self.filters ||= {}

35

self.filters ||= {}

35

add_filter('spent_on', '*') unless filters.present?

36

add_filter('spent_on', '*') unless filters.present?

36

end

37

end

37

38

def initialize_available_filters

39

def initialize_available_filters

39

add_available_filter "spent_on", :type => :date_past

40

add_available_filter "spent_on", :type => :date_past

40

41

principals = []

42

principals = []

42

if project

43

if project

43

principals += project.principals.visible.sort

44

principals += project.principals.visible.sort

44

unless project.leaf?

45

unless project.leaf?

45

subprojects = project.descendants.visible.to_a

46

subprojects = project.descendants.visible.to_a

46

if subprojects.any?

47

if subprojects.any?

47

add_available_filter "subproject_id",

48

add_available_filter "subproject_id",

48

:type => :list_subprojects,

49

:type => :list_subprojects,

49

:values => subprojects.collect{|s| [s.name, s.id.to_s] }

50

:values => subprojects.collect{|s| [s.name, s.id.to_s] }

50

principals += Principal.member_of(subprojects).visible

51

principals += Principal.member_of(subprojects).visible

51

end

52

end

52

end

53

end

53

else

54

else

54

if all_projects.any?

55

if all_projects.any?

55

# members of visible projects

56

# members of visible projects

56

principals += Principal.member_of(all_projects).visible

57

principals += Principal.member_of(all_projects).visible

57

# project filter

58

# project filter

58

project_values = []

59

project_values = []

59

if User.current.logged? && User.current.memberships.any?

60

if User.current.logged? && User.current.memberships.any?

60

project_values << ["<< #{l(:label_my_projects).downcase} >>", "mine"]

61

project_values << ["<< #{l(:label_my_projects).downcase} >>", "mine"]

61

end

62

end

62

project_values += all_projects_values

63

project_values += all_projects_values

63

add_available_filter("project_id",

64

add_available_filter("project_id",

64

:type => :list, :values => project_values

65

:type => :list, :values => project_values

65

) unless project_values.empty?

66

) unless project_values.empty?

66

end

67

end

67

end

68

end

68

principals.uniq!

69

principals.uniq!

69

principals.sort!

70

principals.sort!

70

users = principals.select {|p| p.is_a?(User)}

71

users = principals.select {|p| p.is_a?(User)}

71

72

users_values = []

73

users_values = []

73

users_values << ["<< #{l(:label_me)} >>", "me"] if User.current.logged?

74

users_values << ["<< #{l(:label_me)} >>", "me"] if User.current.logged?

74

users_values += users.collect{|s| [s.name, s.id.to_s] }

75

users_values += users.collect{|s| [s.name, s.id.to_s] }

75

add_available_filter("user_id",

76

add_available_filter("user_id",

76

:type => :list_optional, :values => users_values

77

:type => :list_optional, :values => users_values

77

) unless users_values.empty?

78

) unless users_values.empty?

78

79

activities = (project ? project.activities : TimeEntryActivity.shared)

80

activities = (project ? project.activities : TimeEntryActivity.shared)

80

add_available_filter("activity_id",

81

add_available_filter("activity_id",

81

:type => :list, :values => activities.map {|a| [a.name, a.id.to_s]}

82

:type => :list, :values => activities.map {|a| [a.name, a.id.to_s]}

82

) unless activities.empty?

83

) unless activities.empty?

83

84

add_available_filter "comments", :type => :text

85

add_available_filter "comments", :type => :text

85

add_available_filter "hours", :type => :float

86

add_available_filter "hours", :type => :float

86

87

add_custom_fields_filters(TimeEntryCustomField)

88

add_custom_fields_filters(TimeEntryCustomField)

88

add_associations_custom_fields_filters :project, :issue, :user

89

add_associations_custom_fields_filters :project, :issue, :user

89

end

90

end

90

91

def available_columns

92

def available_columns

92

return @available_columns if @available_columns

93

return @available_columns if @available_columns

93

@available_columns = self.class.available_columns.dup

94

@available_columns = self.class.available_columns.dup

94

@available_columns += TimeEntryCustomField.visible.

95

@available_columns += TimeEntryCustomField.visible.

95

map {|cf| QueryCustomFieldColumn.new(cf) }

96

map {|cf| QueryCustomFieldColumn.new(cf) }

96

@available_columns += IssueCustomField.visible.

97

@available_columns += IssueCustomField.visible.

97

map {|cf| QueryAssociationCustomFieldColumn.new(:issue, cf) }

98

map {|cf| QueryAssociationCustomFieldColumn.new(:issue, cf) }

98

@available_columns

99

@available_columns

99

end

100

end

100

101

def default_columns_names

102

def default_columns_names

102

@default_columns_names ||= [:project, :spent_on, :user, :activity, :issue, :comments, :hours]

103

@default_columns_names ||= [:project, :spent_on, :user, :activity, :issue, :comments, :hours]

103

end

104

end

104

105

def results_scope(options={})

106

def results_scope(options={})

106

order_option = [group_by_sort_order, options[:order]].flatten.reject(&:blank?)

107

order_option = [group_by_sort_order, options[:order]].flatten.reject(&:blank?)

107

108

TimeEntry.visible.

109

TimeEntry.visible.

109

where(statement).

110

where(statement).

110

order(order_option).

111

order(order_option).

111

joins(joins_for_order_statement(order_option.join(','))).

112

joins(joins_for_order_statement(order_option.join(','))).

112

includes(:activity).

113

includes(:activity).

113

references(:activity)

114

references(:activity)

114

end

115

end

115

116

def sql_for_activity_id_field(field, operator, value)

117

def sql_for_activity_id_field(field, operator, value)

117

condition_on_id = sql_for_field(field, operator, value, Enumeration.table_name, 'id')

118

condition_on_id = sql_for_field(field, operator, value, Enumeration.table_name, 'id')

118

condition_on_parent_id = sql_for_field(field, operator, value, Enumeration.table_name, 'parent_id')

119

condition_on_parent_id = sql_for_field(field, operator, value, Enumeration.table_name, 'parent_id')

119

ids = value.map(&:to_i).join(',')

120

ids = value.map(&:to_i).join(',')

120

table_name = Enumeration.table_name

121

table_name = Enumeration.table_name

121

if operator == '='

122

if operator == '='

122

"(#{table_name}.id IN (#{ids}) OR #{table_name}.parent_id IN (#{ids}))"

123

"(#{table_name}.id IN (#{ids}) OR #{table_name}.parent_id IN (#{ids}))"

123

else

124

else

124

"(#{table_name}.id NOT IN (#{ids}) AND (#{table_name}.parent_id IS NULL OR #{table_name}.parent_id NOT IN (#{ids})))"

125

"(#{table_name}.id NOT IN (#{ids}) AND (#{table_name}.parent_id IS NULL OR #{table_name}.parent_id NOT IN (#{ids})))"

125

end

126

end

126

end

127

end

127

128

# Accepts :from/:to params as shortcut filters

129

# Accepts :from/:to params as shortcut filters

129

def build_from_params(params)

130

def build_from_params(params)

130

super

131

super

131

if params[:from].present? && params[:to].present?

132

if params[:from].present? && params[:to].present?

132

add_filter('spent_on', '><', [params[:from], params[:to]])

133

add_filter('spent_on', '><', [params[:from], params[:to]])

133

elsif params[:from].present?

134

elsif params[:from].present?

134

add_filter('spent_on', '>=', [params[:from]])

135

add_filter('spent_on', '>=', [params[:from]])

135

elsif params[:to].present?

136

elsif params[:to].present?

136

add_filter('spent_on', '<=', [params[:to]])

137

add_filter('spent_on', '<=', [params[:to]])

137

end

138

end

138

self

139

self

139

end

140

end

140

end

141

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-2015  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.
             class TimeEntryQuery < Query
               self.queried_class = TimeEntry
               self.available_columns = [
                 QueryColumn.new(:project, :sortable => "#{Project.table_name}.name", :groupable => true),
                 QueryColumn.new(:spent_on, :sortable => ["#{TimeEntry.table_name}.spent_on", "#{TimeEntry.table_name}.created_on"], :default_order => 'desc', :groupable => true),
+                QueryColumn.new(:tweek, :sortable => ["#{TimeEntry.table_name}.spent_on", "#{TimeEntry.table_name}.created_on"], :caption => l(:label_week)),
                 QueryColumn.new(:user, :sortable => lambda {User.fields_for_order_statement}, :groupable => true),
                 QueryColumn.new(:activity, :sortable => "#{TimeEntryActivity.table_name}.position", :groupable => true),
                 QueryColumn.new(:issue, :sortable => "#{Issue.table_name}.id"),
                 QueryColumn.new(:comments),
                 QueryColumn.new(:hours, :sortable => "#{TimeEntry.table_name}.hours"),
               ]
               def initialize(attributes=nil, *args)
                 super attributes
                 self.filters ||= {}
                 add_filter('spent_on', '*') unless filters.present?
               end
               def initialize_available_filters
                 add_available_filter "spent_on", :type => :date_past
                 principals = []
                 if project
                   principals += project.principals.visible.sort
                   unless project.leaf?
                     subprojects = project.descendants.visible.to_a
                     if subprojects.any?
                       add_available_filter "subproject_id",
                         :type => :list_subprojects,
                         :values => subprojects.collect{|s| [s.name, s.id.to_s] }
                       principals += Principal.member_of(subprojects).visible
                     end
                   end
                 else
                   if all_projects.any?
                     # members of visible projects
                     principals += Principal.member_of(all_projects).visible
                     # project filter
                     project_values = []
                     if User.current.logged? && User.current.memberships.any?
                       project_values << ["<< #{l(:label_my_projects).downcase} >>", "mine"]
                     end
                     project_values += all_projects_values
                     add_available_filter("project_id",
                       :type => :list, :values => project_values
                     ) unless project_values.empty?
                   end
                 end
                 principals.uniq!
                 principals.sort!
                 users = principals.select {|p| p.is_a?(User)}
                 users_values = []
                 users_values << ["<< #{l(:label_me)} >>", "me"] if User.current.logged?
                 users_values += users.collect{|s| [s.name, s.id.to_s] }
                 add_available_filter("user_id",
                   :type => :list_optional, :values => users_values
                 ) unless users_values.empty?
                 activities = (project ? project.activities : TimeEntryActivity.shared)
                 add_available_filter("activity_id",
                   :type => :list, :values => activities.map {|a| [a.name, a.id.to_s]}
                 ) unless activities.empty?
                 add_available_filter "comments", :type => :text
                 add_available_filter "hours", :type => :float
                 add_custom_fields_filters(TimeEntryCustomField)
                 add_associations_custom_fields_filters :project, :issue, :user
               end
               def available_columns
                 return @available_columns if @available_columns
                 @available_columns = self.class.available_columns.dup
                 @available_columns += TimeEntryCustomField.visible.
                                         map {|cf| QueryCustomFieldColumn.new(cf) }
                 @available_columns += IssueCustomField.visible.
                                         map {|cf| QueryAssociationCustomFieldColumn.new(:issue, cf) }
                 @available_columns
               end
               def default_columns_names
                 @default_columns_names ||= [:project, :spent_on, :user, :activity, :issue, :comments, :hours]
               end
               def results_scope(options={})
                 order_option = [group_by_sort_order, options[:order]].flatten.reject(&:blank?)
                 TimeEntry.visible.
                   where(statement).
                   order(order_option).
                   joins(joins_for_order_statement(order_option.join(','))).
                   includes(:activity).
                   references(:activity)
               end
               def sql_for_activity_id_field(field, operator, value)
                 condition_on_id = sql_for_field(field, operator, value, Enumeration.table_name, 'id')
                 condition_on_parent_id = sql_for_field(field, operator, value, Enumeration.table_name, 'parent_id')
                 ids = value.map(&:to_i).join(',')
                 table_name = Enumeration.table_name
                 if operator == '='
                   "(#{table_name}.id IN (#{ids}) OR #{table_name}.parent_id IN (#{ids}))"
                 else
                   "(#{table_name}.id NOT IN (#{ids}) AND (#{table_name}.parent_id IS NULL OR #{table_name}.parent_id NOT IN (#{ids})))"
                 end
               end
               # Accepts :from/:to params as shortcut filters
               def build_from_params(params)
                 super
                 if params[:from].present? && params[:to].present?
                   add_filter('spent_on', '><', [params[:from], params[:to]])
                 elsif params[:from].present?
                   add_filter('spent_on', '>=', [params[:from]])
                 elsif params[:to].present?
                   add_filter('spent_on', '<=', [params[:to]])
                 end
                 self
               end
             end