jro_apps/redmine Commit - r11789:3c9263221d3d

1

# encoding: utf-8

1

# encoding: utf-8

2

#

2

#

3

# Redmine - project management software

3

# Redmine - project management software

4

5

#

5

#

6

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

6

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

7

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

7

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

8

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

8

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

9

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

9

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

10

#

10

#

11

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

11

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

12

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

12

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

13

# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the

13

# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the

14

# GNU General Public License for more details.

14

# GNU General Public License for more details.

15

#

15

#

16

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

16

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

17

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

17

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

18

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

18

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

19

20

module QueriesHelper

20

module QueriesHelper

21

def filters_options_for_select(query)

21

def filters_options_for_select(query)

22

options_for_select(filters_options(query))

22

options_for_select(filters_options(query))

23

end

23

end

24

25

def filters_options(query)

25

def filters_options(query)

26

options = [[]]

26

options = [[]]

27

options += query.available_filters.map do |field, field_options|

27

options += query.available_filters.map do |field, field_options|

28

[field_options[:name], field]

28

[field_options[:name], field]

29

end

29

end

30

end

30

end

31

32

def query_filters_hidden_tags(query)

32

def query_filters_hidden_tags(query)

33

tags = ''.html_safe

33

tags = ''.html_safe

34

query.filters.each do |field, options|

34

query.filters.each do |field, options|

35

tags << hidden_field_tag("f[]", field, :id => nil)

35

tags << hidden_field_tag("f[]", field, :id => nil)

36

tags << hidden_field_tag("op[#{field}]", options[:operator], :id => nil)

36

tags << hidden_field_tag("op[#{field}]", options[:operator], :id => nil)

37

options[:values].each do |value|

37

options[:values].each do |value|

38

tags << hidden_field_tag("v[#{field}][]", value, :id => nil)

38

tags << hidden_field_tag("v[#{field}][]", value, :id => nil)

39

end

39

end

40

end

40

end

41

tags

41

tags

42

end

42

end

43

44

def query_columns_hidden_tags(query)

44

def query_columns_hidden_tags(query)

45

tags = ''.html_safe

45

tags = ''.html_safe

46

query.columns.each do |column|

46

query.columns.each do |column|

47

tags << hidden_field_tag("c[]", column.name, :id => nil)

47

tags << hidden_field_tag("c[]", column.name, :id => nil)

48

end

48

end

49

tags

49

tags

50

end

50

end

51

52

def query_hidden_tags(query)

52

def query_hidden_tags(query)

53

query_filters_hidden_tags(query) + query_columns_hidden_tags(query)

53

query_filters_hidden_tags(query) + query_columns_hidden_tags(query)

54

end

54

end

55

56

def available_block_columns_tags(query)

56

def available_block_columns_tags(query)

57

tags = ''.html_safe

57

tags = ''.html_safe

58

query.available_block_columns.each do |column|

58

query.available_block_columns.each do |column|

59

tags << content_tag('label', check_box_tag('c[]', column.name.to_s, query.has_column?(column)) + " #{column.caption}", :class => 'inline')

59

tags << content_tag('label', check_box_tag('c[]', column.name.to_s, query.has_column?(column)) + " #{column.caption}", :class => 'inline')

60

end

60

end

61

tags

61

tags

62

end

62

end

63

64

def query_available_inline_columns_options(query)

64

def query_available_inline_columns_options(query)

65

(query.available_inline_columns - query.columns).reject(&:frozen?).collect {|column| [column.caption, column.name]}

65

(query.available_inline_columns - query.columns).reject(&:frozen?).collect {|column| [column.caption, column.name]}

66

end

66

end

67

68

def query_selected_inline_columns_options(query)

68

def query_selected_inline_columns_options(query)

69

(query.inline_columns & query.available_inline_columns).reject(&:frozen?).collect {|column| [column.caption, column.name]}

69

(query.inline_columns & query.available_inline_columns).reject(&:frozen?).collect {|column| [column.caption, column.name]}

70

end

70

end

71

72

def render_query_columns_selection(query, options={})

72

def render_query_columns_selection(query, options={})

73

tag_name = (options[:name] || 'c') + '[]'

73

tag_name = (options[:name] || 'c') + '[]'

74

render :partial => 'queries/columns', :locals => {:query => query, :tag_name => tag_name}

74

render :partial => 'queries/columns', :locals => {:query => query, :tag_name => tag_name}

75

end

75

end

76

77

def column_header(column)

77

def column_header(column)

78

column.sortable ? sort_header_tag(column.name.to_s, :caption => column.caption,

78

column.sortable ? sort_header_tag(column.name.to_s, :caption => column.caption,

79

:default_order => column.default_order) :

79

:default_order => column.default_order) :

80

content_tag('th', h(column.caption))

80

content_tag('th', h(column.caption))

81

end

81

end

82

83

def column_content(column, issue)

83

def column_content(column, issue)

84

value = column.value(issue)

84

value = column.value(issue)

85

if value.is_a?(Array)

85

if value.is_a?(Array)

86

value.collect {|v| column_value(column, issue, v)}.compact.join(', ').html_safe

86

value.collect {|v| column_value(column, issue, v)}.compact.join(', ').html_safe

87

else

87

else

88

column_value(column, issue, value)

88

column_value(column, issue, value)

89

end

89

end

90

end

90

end

91

92

def column_value(column, issue, value)

92

def column_value(column, issue, value)

93

case value.class.name

93

case value.class.name

94

when 'String'

94

when 'String'

95

if column.name == :subject

95

if column.name == :subject

96

link_to(h(value), :controller => 'issues', :action => 'show', :id => issue)

96

link_to(h(value), :controller => 'issues', :action => 'show', :id => issue)

97

elsif column.name == :description

97

elsif column.name == :description

98

issue.description? ? content_tag('div', textilizable(issue, :description), :class => "wiki") : ''

98

issue.description? ? content_tag('div', textilizable(issue, :description), :class => "wiki") : ''

99

else

99

else

100

h(value)

100

h(value)

101

end

101

end

102

when 'Time'

102

when 'Time'

103

format_time(value)

103

format_time(value)

104

when 'Date'

104

when 'Date'

105

format_date(value)

105

format_date(value)

106

when 'Fixnum'

106

when 'Fixnum'

107

if column.name == :id

107

if column.name == :id

108

link_to value, issue_path(issue)

108

link_to value, issue_path(issue)

109

elsif column.name == :done_ratio

109

elsif column.name == :done_ratio

110

progress_bar(value, :width => '80px')

110

progress_bar(value, :width => '80px')

111

else

111

else

112

value.to_s

112

value.to_s

113

end

113

end

114

when 'Float'

114

when 'Float'

115

sprintf "%.2f", value

115

sprintf "%.2f", value

116

when 'User'

116

when 'User'

117

link_to_user value

117

link_to_user value

118

when 'Project'

118

when 'Project'

119

link_to_project value

119

link_to_project value

120

when 'Version'

120

when 'Version'

121

link_to(h(value), :controller => 'versions', :action => 'show', :id => value)

121

link_to(h(value), :controller => 'versions', :action => 'show', :id => value)

122

when 'TrueClass'

122

when 'TrueClass'

123

l(:general_text_Yes)

123

l(:general_text_Yes)

124

when 'FalseClass'

124

when 'FalseClass'

125

l(:general_text_No)

125

l(:general_text_No)

126

when 'Issue'

126

when 'Issue'

127

value.visible? ? link_to_issue(value) : "##{value.id}"

127

value.visible? ? link_to_issue(value) : "##{value.id}"

128

when 'IssueRelation'

128

when 'IssueRelation'

129

other = value.other_issue(issue)

129

other = value.other_issue(issue)

130

content_tag('span',

130

content_tag('span',

131

(l(value.label_for(issue)) + " " + link_to_issue(other, :subject => false, :tracker => false)).html_safe,

131

(l(value.label_for(issue)) + " " + link_to_issue(other, :subject => false, :tracker => false)).html_safe,

132

:class => value.css_classes_for(issue))

132

:class => value.css_classes_for(issue))

133

else

133

else

134

h(value)

134

h(value)

135

end

135

end

136

end

136

end

137

138

def csv_content(column, issue)

138

def csv_content(column, issue)

139

value = column.value(issue)

139

value = column.value(issue)

140

if value.is_a?(Array)

140

if value.is_a?(Array)

141

value.collect {|v| csv_value(column, issue, v)}.compact.join(', ')

141

value.collect {|v| csv_value(column, issue, v)}.compact.join(', ')

142

else

142

else

143

csv_value(column, issue, value)

143

csv_value(column, issue, value)

144

end

144

end

145

end

145

end

146

147

def csv_value(column, issue, value)

147

def csv_value(column, issue, value)

148

case value.class.name

148

case value.class.name

149

when 'Time'

149

when 'Time'

150

format_time(value)

150

format_time(value)

151

when 'Date'

151

when 'Date'

152

format_date(value)

152

format_date(value)

153

when 'Float'

153

when 'Float'

154

sprintf("%.2f", value).gsub('.', l(:general_csv_decimal_separator))

154

sprintf("%.2f", value).gsub('.', l(:general_csv_decimal_separator))

155

when 'IssueRelation'

155

when 'IssueRelation'

156

other = value.other_issue(issue)

156

other = value.other_issue(issue)

157

l(value.label_for(issue)) + " ##{other.id}"

157

l(value.label_for(issue)) + " ##{other.id}"

158

else

158

else

159

value.to_s

159

value.to_s

160

end

160

end

161

end

161

end

162

163

def query_to_csv(items, query, options={})

163

def query_to_csv(items, query, options={})

164

encoding = l(:general_csv_encoding)

164

encoding = l(:general_csv_encoding)

165

columns = (options[:columns] == 'all' ? query.available_inline_columns : query.inline_columns)

165

columns = (options[:columns] == 'all' ? query.available_inline_columns : query.inline_columns)

166

query.available_block_columns.each do |column|

166

query.available_block_columns.each do |column|

167

if options[column.name].present?

167

if options[column.name].present?

168

columns << column

168

columns << column

169

end

169

end

170

end

170

end

171

172

export = FCSV.generate(:col_sep => l(:general_csv_separator)) do |csv|

172

export = FCSV.generate(:col_sep => l(:general_csv_separator)) do |csv|

173

# csv header fields

173

# csv header fields

174

csv << columns.collect {|c| Redmine::CodesetUtil.from_utf8(c.caption.to_s, encoding) }

174

csv << columns.collect {|c| Redmine::CodesetUtil.from_utf8(c.caption.to_s, encoding) }

175

# csv lines

175

# csv lines

176

items.each do |item|

176

items.each do |item|

177

csv << columns.collect {|c| Redmine::CodesetUtil.from_utf8(csv_content(c, item), encoding) }

177

csv << columns.collect {|c| Redmine::CodesetUtil.from_utf8(csv_content(c, item), encoding) }

178

end

178

end

179

end

179

end

180

export

180

export

181

end

181

end

182

183

# Retrieve query from session or build a new query

183

# Retrieve query from session or build a new query

184

def retrieve_query

184

def retrieve_query

185

if !params[:query_id].blank?

185

if !params[:query_id].blank?

186

cond = "project_id IS NULL"

186

cond = "project_id IS NULL"

187

cond << " OR project_id = #{@project.id}" if @project

187

cond << " OR project_id = #{@project.id}" if @project

188

@query = IssueQuery.where(cond).find(params[:query_id])

188

@query = IssueQuery.where(cond).find(params[:query_id])

189

raise ::Unauthorized unless @query.visible?

189

raise ::Unauthorized unless @query.visible?

190

@query.project = @project

190

@query.project = @project

191

session[:query] = {:id => @query.id, :project_id => @query.project_id}

191

session[:query] = {:id => @query.id, :project_id => @query.project_id}

192

sort_clear

192

sort_clear

193

elsif api_request? || params[:set_filter] || session[:query].nil? || session[:query][:project_id] != (@project ? @project.id : nil)

193

elsif api_request? || params[:set_filter] || session[:query].nil? || session[:query][:project_id] != (@project ? @project.id : nil)

194

# Give it a name, required to be valid

194

# Give it a name, required to be valid

195

@query = IssueQuery.new(:name => "_")

195

@query = IssueQuery.new(:name => "_")

196

@query.project = @project

196

@query.project = @project

197

@query.build_from_params(params)

197

@query.build_from_params(params)

198

session[:query] = {:project_id => @query.project_id, :filters => @query.filters, :group_by => @query.group_by, :column_names => @query.column_names}

198

session[:query] = {:project_id => @query.project_id, :filters => @query.filters, :group_by => @query.group_by, :column_names => @query.column_names}

199

else

199

else

200

# retrieve from session

200

# retrieve from session

201

@query = nil

201

@query = IssueQuery.find_by_id(session[:query][:id]) if session[:query][:id]

202

@query = IssueQuery.find_by_id(session[:query][:id]) if session[:query][:id]

202

@query ||= IssueQuery.new(:name => "_", :filters => session[:query][:filters], :group_by => session[:query][:group_by], :column_names => session[:query][:column_names])

203

@query ||= IssueQuery.new(:name => "_", :filters => session[:query][:filters], :group_by => session[:query][:group_by], :column_names => session[:query][:column_names])

203

@query.project = @project

204

@query.project = @project

204

end

205

end

205

end

206

end

206

207

def retrieve_query_from_session

208

def retrieve_query_from_session

208

if session[:query]

209

if session[:query]

209

if session[:query][:id]

210

if session[:query][:id]

210

@query = IssueQuery.find_by_id(session[:query][:id])

211

@query = IssueQuery.find_by_id(session[:query][:id])

211

return unless @query

212

return unless @query

212

else

213

else

213

@query = IssueQuery.new(:name => "_", :filters => session[:query][:filters], :group_by => session[:query][:group_by], :column_names => session[:query][:column_names])

214

@query = IssueQuery.new(:name => "_", :filters => session[:query][:filters], :group_by => session[:query][:group_by], :column_names => session[:query][:column_names])

214

end

215

end

215

if session[:query].has_key?(:project_id)

216

if session[:query].has_key?(:project_id)

216

@query.project_id = session[:query][:project_id]

217

@query.project_id = session[:query][:project_id]

217

else

218

else

218

@query.project = @project

219

@query.project = @project

219

end

220

end

220

@query

221

@query

221

end

222

end

222

end

223

end

223

end

224

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

             # encoding: utf-8
             #
             # 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.
             module QueriesHelper
               def filters_options_for_select(query)
                 options_for_select(filters_options(query))
               end
               def filters_options(query)
                 options = [[]]
                 options += query.available_filters.map do |field, field_options|
                   [field_options[:name], field]
                 end
               end
               def query_filters_hidden_tags(query)
                 tags = ''.html_safe
                 query.filters.each do |field, options|
                   tags << hidden_field_tag("f[]", field, :id => nil)
                   tags << hidden_field_tag("op[#{field}]", options[:operator], :id => nil)
                   options[:values].each do |value|
                     tags << hidden_field_tag("v[#{field}][]", value, :id => nil)
                   end
                 end
                 tags
               end
               def query_columns_hidden_tags(query)
                 tags = ''.html_safe
                 query.columns.each do |column|
                   tags << hidden_field_tag("c[]", column.name, :id => nil)
                 end
                 tags
               end
               def query_hidden_tags(query)
                 query_filters_hidden_tags(query) + query_columns_hidden_tags(query)
               end
               def available_block_columns_tags(query)
                 tags = ''.html_safe
                 query.available_block_columns.each do |column|
                   tags << content_tag('label', check_box_tag('c[]', column.name.to_s, query.has_column?(column)) + " #{column.caption}", :class => 'inline')
                 end
                 tags
               end
               def query_available_inline_columns_options(query)
                 (query.available_inline_columns - query.columns).reject(&:frozen?).collect {|column| [column.caption, column.name]}
               end
               def query_selected_inline_columns_options(query)
                 (query.inline_columns & query.available_inline_columns).reject(&:frozen?).collect {|column| [column.caption, column.name]}
               end
               def render_query_columns_selection(query, options={})
                 tag_name = (options[:name] || 'c') + '[]'
                 render :partial => 'queries/columns', :locals => {:query => query, :tag_name => tag_name}
               end
               def column_header(column)
                 column.sortable ? sort_header_tag(column.name.to_s, :caption => column.caption,
                                                                     :default_order => column.default_order) :
                                   content_tag('th', h(column.caption))
               end
               def column_content(column, issue)
                 value = column.value(issue)
                 if value.is_a?(Array)
                   value.collect {|v| column_value(column, issue, v)}.compact.join(', ').html_safe
                 else
                   column_value(column, issue, value)
                 end
               end
               def column_value(column, issue, value)
                 case value.class.name
                 when 'String'
                   if column.name == :subject
                     link_to(h(value), :controller => 'issues', :action => 'show', :id => issue)
                   elsif column.name == :description
                     issue.description? ? content_tag('div', textilizable(issue, :description), :class => "wiki") : ''
                   else
                     h(value)
                   end
                 when 'Time'
                   format_time(value)
                 when 'Date'
                   format_date(value)
                 when 'Fixnum'
                   if column.name == :id
                     link_to value, issue_path(issue)
                   elsif column.name == :done_ratio
                     progress_bar(value, :width => '80px')
                   else
                     value.to_s
                   end
                 when 'Float'
                   sprintf "%.2f", value
                 when 'User'
                   link_to_user value
                 when 'Project'
                   link_to_project value
                 when 'Version'
                   link_to(h(value), :controller => 'versions', :action => 'show', :id => value)
                 when 'TrueClass'
                   l(:general_text_Yes)
                 when 'FalseClass'
                   l(:general_text_No)
                 when 'Issue'
                   value.visible? ? link_to_issue(value) : "##{value.id}"
                 when 'IssueRelation'
                   other = value.other_issue(issue)
                   content_tag('span',
                     (l(value.label_for(issue)) + " " + link_to_issue(other, :subject => false, :tracker => false)).html_safe,
                     :class => value.css_classes_for(issue))
                 else
                   h(value)
                 end
               end
               def csv_content(column, issue)
                 value = column.value(issue)
                 if value.is_a?(Array)
                   value.collect {|v| csv_value(column, issue, v)}.compact.join(', ')
                 else
                   csv_value(column, issue, value)
                 end
               end
               def csv_value(column, issue, value)
                 case value.class.name
                 when 'Time'
                   format_time(value)
                 when 'Date'
                   format_date(value)
                 when 'Float'
                   sprintf("%.2f", value).gsub('.', l(:general_csv_decimal_separator))
                 when 'IssueRelation'
                   other = value.other_issue(issue)
                   l(value.label_for(issue)) + " ##{other.id}"
                 else
                   value.to_s
                 end
               end
               def query_to_csv(items, query, options={})
                 encoding = l(:general_csv_encoding)
                 columns = (options[:columns] == 'all' ? query.available_inline_columns : query.inline_columns)
                 query.available_block_columns.each do |column|
                   if options[column.name].present?
                     columns << column
                   end
                 end
                 export = FCSV.generate(:col_sep => l(:general_csv_separator)) do |csv|
                   # csv header fields
                   csv << columns.collect {|c| Redmine::CodesetUtil.from_utf8(c.caption.to_s, encoding) }
                   # csv lines
                   items.each do |item|
                     csv << columns.collect {|c| Redmine::CodesetUtil.from_utf8(csv_content(c, item), encoding) }
                   end
                 end
                 export
               end
               # Retrieve query from session or build a new query
               def retrieve_query
                 if !params[:query_id].blank?
                   cond = "project_id IS NULL"
                   cond << " OR project_id = #{@project.id}" if @project
                   @query = IssueQuery.where(cond).find(params[:query_id])
                   raise ::Unauthorized unless @query.visible?
                   @query.project = @project
                   session[:query] = {:id => @query.id, :project_id => @query.project_id}
                   sort_clear
                 elsif api_request? || params[:set_filter] || session[:query].nil? || session[:query][:project_id] != (@project ? @project.id : nil)
                   # Give it a name, required to be valid
                   @query = IssueQuery.new(:name => "_")
                   @query.project = @project
                   @query.build_from_params(params)
                   session[:query] = {:project_id => @query.project_id, :filters => @query.filters, :group_by => @query.group_by, :column_names => @query.column_names}
                 else
                   # retrieve from session
+                  @query = nil
                   @query = IssueQuery.find_by_id(session[:query][:id]) if session[:query][:id]
                   @query ||= IssueQuery.new(:name => "_", :filters => session[:query][:filters], :group_by => session[:query][:group_by], :column_names => session[:query][:column_names])
                   @query.project = @project
                 end
               end
               def retrieve_query_from_session
                 if session[:query]
                   if session[:query][:id]
                     @query = IssueQuery.find_by_id(session[:query][:id])
                     return unless @query
                   else
                     @query = IssueQuery.new(:name => "_", :filters => session[:query][:filters], :group_by => session[:query][:group_by], :column_names => session[:query][:column_names])
                   end
                   if session[:query].has_key?(:project_id)
                     @query.project_id = session[:query][:project_id]
                   else
                     @query.project = @project
                   end
                   @query
                 end
               end
             end