Chris@909
|
1 # encoding: utf-8
|
Chris@909
|
2 #
|
Chris@0
|
3 # Helpers to sort tables using clickable column headers.
|
Chris@0
|
4 #
|
Chris@0
|
5 # Author: Stuart Rackham <srackham@methods.co.nz>, March 2005.
|
Chris@0
|
6 # Jean-Philippe Lang, 2009
|
Chris@0
|
7 # License: This source code is released under the MIT license.
|
Chris@0
|
8 #
|
Chris@0
|
9 # - Consecutive clicks toggle the column's sort order.
|
Chris@0
|
10 # - Sort state is maintained by a session hash entry.
|
Chris@0
|
11 # - CSS classes identify sort column and state.
|
Chris@0
|
12 # - Typically used in conjunction with the Pagination module.
|
Chris@0
|
13 #
|
Chris@0
|
14 # Example code snippets:
|
Chris@0
|
15 #
|
Chris@0
|
16 # Controller:
|
Chris@0
|
17 #
|
Chris@0
|
18 # helper :sort
|
Chris@0
|
19 # include SortHelper
|
Chris@909
|
20 #
|
Chris@0
|
21 # def list
|
Chris@0
|
22 # sort_init 'last_name'
|
Chris@0
|
23 # sort_update %w(first_name last_name)
|
Chris@0
|
24 # @items = Contact.find_all nil, sort_clause
|
Chris@0
|
25 # end
|
Chris@909
|
26 #
|
Chris@0
|
27 # Controller (using Pagination module):
|
Chris@0
|
28 #
|
Chris@0
|
29 # helper :sort
|
Chris@0
|
30 # include SortHelper
|
Chris@909
|
31 #
|
Chris@0
|
32 # def list
|
Chris@0
|
33 # sort_init 'last_name'
|
Chris@0
|
34 # sort_update %w(first_name last_name)
|
Chris@0
|
35 # @contact_pages, @items = paginate :contacts,
|
Chris@0
|
36 # :order_by => sort_clause,
|
Chris@0
|
37 # :per_page => 10
|
Chris@0
|
38 # end
|
Chris@909
|
39 #
|
Chris@0
|
40 # View (table header in list.rhtml):
|
Chris@909
|
41 #
|
Chris@0
|
42 # <thead>
|
Chris@0
|
43 # <tr>
|
Chris@0
|
44 # <%= sort_header_tag('id', :title => 'Sort by contact ID') %>
|
Chris@0
|
45 # <%= sort_header_tag('last_name', :caption => 'Name') %>
|
Chris@0
|
46 # <%= sort_header_tag('phone') %>
|
Chris@0
|
47 # <%= sort_header_tag('address', :width => 200) %>
|
Chris@0
|
48 # </tr>
|
Chris@0
|
49 # </thead>
|
Chris@0
|
50 #
|
Chris@0
|
51 # - Introduces instance variables: @sort_default, @sort_criteria
|
Chris@0
|
52 # - Introduces param :sort
|
Chris@0
|
53 #
|
Chris@0
|
54
|
Chris@0
|
55 module SortHelper
|
Chris@0
|
56 class SortCriteria
|
Chris@909
|
57
|
Chris@0
|
58 def initialize
|
Chris@0
|
59 @criteria = []
|
Chris@0
|
60 end
|
Chris@909
|
61
|
Chris@0
|
62 def available_criteria=(criteria)
|
Chris@0
|
63 unless criteria.is_a?(Hash)
|
Chris@0
|
64 criteria = criteria.inject({}) {|h,k| h[k] = k; h}
|
Chris@0
|
65 end
|
Chris@0
|
66 @available_criteria = criteria
|
Chris@0
|
67 end
|
Chris@909
|
68
|
Chris@0
|
69 def from_param(param)
|
Chris@0
|
70 @criteria = param.to_s.split(',').collect {|s| s.split(':')[0..1]}
|
Chris@0
|
71 normalize!
|
Chris@0
|
72 end
|
Chris@909
|
73
|
Chris@0
|
74 def criteria=(arg)
|
Chris@0
|
75 @criteria = arg
|
Chris@0
|
76 normalize!
|
Chris@0
|
77 end
|
Chris@909
|
78
|
Chris@0
|
79 def to_param
|
Chris@0
|
80 @criteria.collect {|k,o| k + (o ? '' : ':desc')}.join(',')
|
Chris@0
|
81 end
|
Chris@909
|
82
|
Chris@0
|
83 def to_sql
|
Chris@0
|
84 sql = @criteria.collect do |k,o|
|
Chris@0
|
85 if s = @available_criteria[k]
|
Chris@0
|
86 (o ? s.to_a : s.to_a.collect {|c| append_desc(c)}).join(', ')
|
Chris@0
|
87 end
|
Chris@0
|
88 end.compact.join(', ')
|
Chris@0
|
89 sql.blank? ? nil : sql
|
Chris@0
|
90 end
|
Chris@909
|
91
|
Chris@0
|
92 def add!(key, asc)
|
Chris@0
|
93 @criteria.delete_if {|k,o| k == key}
|
Chris@0
|
94 @criteria = [[key, asc]] + @criteria
|
Chris@0
|
95 normalize!
|
Chris@0
|
96 end
|
Chris@909
|
97
|
Chris@0
|
98 def add(*args)
|
Chris@0
|
99 r = self.class.new.from_param(to_param)
|
Chris@0
|
100 r.add!(*args)
|
Chris@0
|
101 r
|
Chris@0
|
102 end
|
Chris@909
|
103
|
Chris@0
|
104 def first_key
|
Chris@0
|
105 @criteria.first && @criteria.first.first
|
Chris@0
|
106 end
|
Chris@909
|
107
|
Chris@0
|
108 def first_asc?
|
Chris@0
|
109 @criteria.first && @criteria.first.last
|
Chris@0
|
110 end
|
Chris@909
|
111
|
Chris@0
|
112 def empty?
|
Chris@0
|
113 @criteria.empty?
|
Chris@0
|
114 end
|
Chris@909
|
115
|
Chris@0
|
116 private
|
Chris@909
|
117
|
Chris@0
|
118 def normalize!
|
Chris@0
|
119 @criteria ||= []
|
Chris@0
|
120 @criteria = @criteria.collect {|s| s = s.to_a; [s.first, (s.last == false || s.last == 'desc') ? false : true]}
|
Chris@0
|
121 @criteria = @criteria.select {|k,o| @available_criteria.has_key?(k)} if @available_criteria
|
Chris@0
|
122 @criteria.slice!(3)
|
Chris@0
|
123 self
|
Chris@0
|
124 end
|
Chris@909
|
125
|
Chris@0
|
126 # Appends DESC to the sort criterion unless it has a fixed order
|
Chris@0
|
127 def append_desc(criterion)
|
Chris@0
|
128 if criterion =~ / (asc|desc)$/i
|
Chris@0
|
129 criterion
|
Chris@0
|
130 else
|
Chris@0
|
131 "#{criterion} DESC"
|
Chris@0
|
132 end
|
Chris@0
|
133 end
|
Chris@0
|
134 end
|
Chris@909
|
135
|
Chris@0
|
136 def sort_name
|
Chris@0
|
137 controller_name + '_' + action_name + '_sort'
|
Chris@0
|
138 end
|
Chris@0
|
139
|
Chris@0
|
140 # Initializes the default sort.
|
Chris@0
|
141 # Examples:
|
Chris@909
|
142 #
|
Chris@0
|
143 # sort_init 'name'
|
Chris@0
|
144 # sort_init 'id', 'desc'
|
Chris@0
|
145 # sort_init ['name', ['id', 'desc']]
|
Chris@0
|
146 # sort_init [['name', 'desc'], ['id', 'desc']]
|
Chris@0
|
147 #
|
Chris@0
|
148 def sort_init(*args)
|
Chris@0
|
149 case args.size
|
Chris@0
|
150 when 1
|
Chris@0
|
151 @sort_default = args.first.is_a?(Array) ? args.first : [[args.first]]
|
Chris@0
|
152 when 2
|
Chris@0
|
153 @sort_default = [[args.first, args.last]]
|
Chris@0
|
154 else
|
Chris@0
|
155 raise ArgumentError
|
Chris@0
|
156 end
|
Chris@0
|
157 end
|
Chris@0
|
158
|
Chris@0
|
159 # Updates the sort state. Call this in the controller prior to calling
|
Chris@0
|
160 # sort_clause.
|
Chris@0
|
161 # - criteria can be either an array or a hash of allowed keys
|
Chris@0
|
162 #
|
Chris@0
|
163 def sort_update(criteria)
|
Chris@0
|
164 @sort_criteria = SortCriteria.new
|
Chris@0
|
165 @sort_criteria.available_criteria = criteria
|
Chris@0
|
166 @sort_criteria.from_param(params[:sort] || session[sort_name])
|
Chris@0
|
167 @sort_criteria.criteria = @sort_default if @sort_criteria.empty?
|
Chris@0
|
168 session[sort_name] = @sort_criteria.to_param
|
Chris@0
|
169 end
|
Chris@909
|
170
|
Chris@0
|
171 # Clears the sort criteria session data
|
Chris@0
|
172 #
|
Chris@0
|
173 def sort_clear
|
Chris@0
|
174 session[sort_name] = nil
|
Chris@0
|
175 end
|
Chris@0
|
176
|
Chris@0
|
177 # Returns an SQL sort clause corresponding to the current sort state.
|
Chris@0
|
178 # Use this to sort the controller's table items collection.
|
Chris@0
|
179 #
|
Chris@0
|
180 def sort_clause()
|
Chris@0
|
181 @sort_criteria.to_sql
|
Chris@0
|
182 end
|
Chris@0
|
183
|
Chris@0
|
184 # Returns a link which sorts by the named column.
|
Chris@0
|
185 #
|
Chris@0
|
186 # - column is the name of an attribute in the sorted record collection.
|
Chris@0
|
187 # - the optional caption explicitly specifies the displayed link text.
|
Chris@0
|
188 # - 2 CSS classes reflect the state of the link: sort and asc or desc
|
Chris@0
|
189 #
|
Chris@0
|
190 def sort_link(column, caption, default_order)
|
Chris@0
|
191 css, order = nil, default_order
|
Chris@909
|
192
|
Chris@0
|
193 if column.to_s == @sort_criteria.first_key
|
Chris@0
|
194 if @sort_criteria.first_asc?
|
Chris@0
|
195 css = 'sort asc'
|
Chris@0
|
196 order = 'desc'
|
Chris@0
|
197 else
|
Chris@0
|
198 css = 'sort desc'
|
Chris@0
|
199 order = 'asc'
|
Chris@0
|
200 end
|
Chris@0
|
201 end
|
Chris@0
|
202 caption = column.to_s.humanize unless caption
|
Chris@909
|
203
|
Chris@0
|
204 sort_options = { :sort => @sort_criteria.add(column.to_s, order).to_param }
|
Chris@441
|
205 url_options = params.merge(sort_options)
|
Chris@909
|
206
|
Chris@0
|
207 # Add project_id to url_options
|
Chris@0
|
208 url_options = url_options.merge(:project_id => params[:project_id]) if params.has_key?(:project_id)
|
Chris@0
|
209
|
Chris@909
|
210 link_to_content_update(h(caption), url_options, :class => css)
|
Chris@0
|
211 end
|
Chris@0
|
212
|
Chris@0
|
213 # Returns a table header <th> tag with a sort link for the named column
|
Chris@0
|
214 # attribute.
|
Chris@0
|
215 #
|
Chris@0
|
216 # Options:
|
Chris@0
|
217 # :caption The displayed link name (defaults to titleized column name).
|
Chris@0
|
218 # :title The tag's 'title' attribute (defaults to 'Sort by :caption').
|
Chris@0
|
219 #
|
Chris@0
|
220 # Other options hash entries generate additional table header tag attributes.
|
Chris@0
|
221 #
|
Chris@0
|
222 # Example:
|
Chris@0
|
223 #
|
Chris@0
|
224 # <%= sort_header_tag('id', :title => 'Sort by contact ID', :width => 40) %>
|
Chris@0
|
225 #
|
Chris@0
|
226 def sort_header_tag(column, options = {})
|
Chris@0
|
227 caption = options.delete(:caption) || column.to_s.humanize
|
Chris@0
|
228 default_order = options.delete(:default_order) || 'asc'
|
Chris@0
|
229 options[:title] = l(:label_sort_by, "\"#{caption}\"") unless options[:title]
|
Chris@0
|
230 content_tag('th', sort_link(column, caption, default_order), options)
|
Chris@0
|
231 end
|
Chris@0
|
232 end
|
Chris@0
|
233
|