Skip to content


Subversion checkout URL

You can clone with HTTPS or Subversion.

Download ZIP
Fetching contributors…

Cannot retrieve contributors at this time

443 lines (275 sloc) 15.305 kb
to do:
1) get rid of this :href => "javascript: toggle_multi_select
at view_columns
Fixed the "Cannot modify SafeBuffer in place" problem and thus Rails 3.0.8 and 3.0.9
Support for ActiveRecord::Relation
Rails 3 support
wice_grid_custom_filter_params used to be a view helper, not it is also accessible from the controller, to be used in cases like redirect_to(my_resource_path(wice_grid_custom_filter_params(...)))
auto reloading filters
helper export_to_csv_javascript to create custom CSV buttons
option :hide_csv_button to hide the default CSV export button
Method WiceGrid#selected_records and parameter :after were a bit of a mess and have been substituted by
* WiceGrid#current_page_records returning records on the current page
* WiceGrid#all_pages_records returning records browsable throughout all pages
* :with_paginated_resultset - callback to process records on the current page
* :with_resultset - callback to process records browsable throughout all pages
Compliant with Rails 1.2.8 with or without rails_xss and erubis
Ruby 1.9.1 compliance
Dropdowns generated with :custom_filter => :auto and :custom_filter => [method chain] are now ordered by option labels
how_filters => false is the same as :show_filters => :no and :show_filters => true is the same as :show_filters => :always
action_column - Adds a column with checkboxes for each record.
Useful for actions with multiple records, for example, delete
the selected records.
using merge_conditions to merge conditions :)
WiceGrid is now compatible with the new Rails XSS behavior which
will be the default in Rails 3.0 and can be used in Rails 2.3.5
using the rails_xss plugin.
Read for more
support for with_scope and with_exclusive_scope
:total_entries parameter added to initialize_grid (will_paginate)
assert_keys wherever possible
== 0.5
Today "WiceGrid": has reached its next level of maturity and was awarded the tag of version 0.5.
This version of WiceGrid is accompanied by an application called _WiceGrid Examples_ running "online": and with source code available on "GitHub":
Here's a list of changes as compared with "version 0.4": :
h4. selected_records
Method @selected_records@ of WiceGrid instances allows to access the list of all records of the current selection throughout all pages in the context of a view:
<%= grid(@tasks_grid) do |g|
end -%>
<% selected = @tasks_grid.selected_records %>
<p><%= selected.size %> records selected: <%= %></p>
"See an online example":
h4. placement of filter related icons
A change in placement of filter related icons (filter icon, reset icon, show/hide icon): if the last column doesn't have any filter or a column name, icons will be placed in the header of this column, otherwise it falls back to the usual behavior when an additional table column is added. To change the behavior back to the old style, set @Wice::Defaults::REUSE_LAST_COLUMN_FOR_FILTER_ICONS@ to @false@ in the configuration file.
"See an online example":
h4. wice_grid_assets generator
Copying asset files (images, css, js, and the configuration file) is now done by a plugin generator, not rake tasks:
./script/generate wice_grid_assets
h4. blank slate
Blank slate feature: it is now possible to replace the grid with some alternative view if no filters are active and there are no records to render:
<%= grid(@grid) do |g|
g.blank_slate do
"There are no records"
g.column do |product|
end -%>
There are also two alternative three ways to do it:
--- Ruby
g.blank_slate "some text to be rendered"
--- Ruby
g.blank_slate :partial => "partial_name"
"See an online example":
h4. custom filters with symbols
Improvement to custom filters, namely to
--- Ruby
:custom_filter => :symbol
--- Ruby
:custom_filter => [:symbol1, :symbol2, :symbol3]
Now, if the last method returns an array of 2 elements, the first element becomes the select option label and the second - the select option value (usually @id@).
Before this change the value returned by the method had been used for both the value and the label of the select option.
"See an online example":
h4. custom filters and NULL
Values @null@ and @not null@ in a generated custom filter dropdown are treated specially, as SQL @null@ statement and not as strings. Value @null@ is transformed into SQL condition @IS NULL@, and @not null@ into @IS NOT NULL@ .
Thus, if in a filter defined by
--- Ruby
:custom_filter => {'No' => 'null', 'Yes' => 'not null', '1' => 1, '2' => '2', '3' => '3'}
values @1@, @2@ and @'No'@ are selected (in a multi-select mode), this will result in the following SQL:
--- SQL
( table.field IN ( '1', '2' ) OR table.field IS NULL )
"See an online example":
in addition to the configuration constant @Wice::Defaults::STRING_MATCHING_OPERATOR@ to define the operator for matching strings (@LIKE@ in most cases), hash @Wice::Defaults::STRING_MATCHING_OPERATORS@ was added to specify string matching operators on per-database basis:
--- Ruby
'ActiveRecord::ConnectionAdapters::MysqlAdapter' => 'LIKE',
'ActiveRecord::ConnectionAdapters::PostgreSQLAdapter' => 'ILIKE'
A use-case for this is a Rails application connecting to two databases, one of which is MySQL, and the other is Postgresql. To use case-insensitive matching in Postgresql 'ILIKE' has to be used, but this operator is unknown to MySQL.
h4. td_html_attrs and table_html_attrs shortcuts
@:td_html_attrs@ in column definitions and @table_html_attrs@ in the table definitions are mostly used to add css classes, so a shorter way has been added to add css classes.
Instead of
<%= grid(@grid, :table_html_attrs => {:class => 'css_class1'}) do |g|
g.column(:td_html_attrs => {:class => 'css_class2'}) do
end -%>
It's possible to just use the new @:class@ option:
<%= grid(@grid, :class => 'css_class1') do |g|
g.column(:class => 'css_class2') do
end -%>
h4. allow_multiple_selection
New options for @column@: @:allow_multiple_selection@, use @:allow_multiple_selection => false@ to disable switching between single and multiple selection modes for custom dropdown boxes.
"See an online example":
h4. allow_ordering
New parameter for @column@: @:allow_ordering@. Use @:allow_ordering => false@ to disable the ordering of the column.
"See an online example":
h4. allow_showing_all_records
Parameter @:allow_showing_all_records@ moved from @initialize_grid@ to the view helper.
h4. other
* Default styles updated.
* Javascript code cleaned up and refactored.
* Quite some number of bugs fixed
== 0.4
* Detached filters: it has become possible to detach filters and place them anywhere on the page, before or after the grid.
Read section "Detached Filters" in the README.
* More control over Submit and Reset buttons.
Two new view helpers: submit_grid_javascript returns javascript which applies current filters; reset_grid_javascript returns javascript
which resets the grid, clearing the state of filters. This allows to create your own Submit and Reset buttons anywhere on the page
with the help of button_to_function:
<%= button_to_function "Submit", submit_grid_javascript(@grid) %>
<%= button_to_function "Reset", reset_grid_javascript(@grid) %>
To complement this feature there are two new parameters in the +grid+ helper :hide_submit_button and :hide_reset_button which
hide default buttons in the grid if set to true. Together with detached filter this allows to completely
get rid of the filter row with filters and icons.
* erb_mode option has been moved to the grid view helper - watch for warnings and remove the parameter from initialize_grid if you have it there.
* helper include_wice_grid_assets will require WiceGrid javascripts and stylesheets on demand, that is, only if at least one initialize_grid
has been called in the controller. Otherwise the helper returns an empty string. However, you can force the old unconditioned behavior if you
need by submitting parameter :load_on_demand set to false:
<%= include_wice_grid_assets(:load_on_demand => false) %>
* Compatibility with Rails asset caching. Helpers names_of_wice_grid_stylesheets and names_of_wice_grid_javascripts return names of stylesheet and
javascript files and can be used with stylesheet_link_tag and javascript_include_tag with :cache => true. Using this trick you have to deal with
the parameters correctly, mind that Prototype has to be loaded before WiceGrid javascripts:
<%= stylesheet_link_tag *(['core', 'modalbox'] + names_of_wice_grid_stylesheets + [ {:cache => true}]) %>
<%= javascript_include_tag *([:defaults] + names_of_wice_grid_javascripts + [ 'ui', 'swfobject', {:cache => true}]) %>
* When a page with a WiceGrid instance is loaded there is check a small chunk of javascript that checks whether Prototype is loaded and whether
the main WiceGrid javascript files is loaded and is of the correct version. Problems are reported to the user via alert() dialog boxes.
This check has now been disabled in the production mode.
* The default field separator in generated CSV (comma) can now be overridden by setting :enable_export_to_csv to a string instead of +true+.
* It is possible to add your own handcrafted HTML after and/or before each grid row. This works similar to +row_attributes+,
by adding blocks after_row and before_row:
<%= grid(@tasks_grid) do |g|
g.before_row do |task|
"<tr><td colspan=\"10\">Custom line for #{}</td></tr>" # this would add a row
# before every active task row
end %>
* Bug fixes
* Refactoring
=== 03/04/2009
Possibility to add custom lines after and/or before a grid row.
=== 16/03/2009
Option to override the default field separator in generated CSV (comma).
=== 13/02/2009
a bug fix for incorrect generation if dom ids for javascript calendar filter. Happened only for columns belonging to joined tables
=== 12/01/2009
WiceGrid 0.3 released
=== 12/01/2009
All records mode
=== 10/12/2008
custom_filter made Rails-compliant, a new flavor - Array of two-element arrays
=== 4/12/2008
A single helper to include all assets in a page
A javascript error message if Prototype is not loaded
A javascript error message if wice_grid.js is not loaded
Added status info to the pagination line:
« Previous 1 2 3 Next » 1-20 / 50
=== 3/12/2008
First implementation of saved queries
=== 25/11/2008
Negation for string filters: match records where this fiels DOES NOT include the given fragment.
=== 24/11/2008
The string matching operator for string filters (LIKE) has been moved to wice_grid_config.rb in order to make it easier to substitute it with
something else, for example, ILIKE of Postgresql.
=== 19/11/2008
Experimental feature : :table_alias parameter to allow ordering and filtering for joining associations referring the same table.
(See "Joined associations referring to the same table" in README)
=== 18/11/2008
=== 6/11/2008
Ability to provide a callback to a Proc object or a method, the callback will be called with the objects of the current selection of
objects (throughout all pages). Can be used to use the WiceGrid filters set up by the user for further processing of the user's selection of
=== 5/11/2008
Javascript calendars as Date/Datetime filters
=== 4/11/2008
Ability to inject custom sql code into the ORDER BY clause, for example, ORDER BY char_length(
=== 4/11/2008
Creates a new branch for version 2.3
=== 21/10/2008
A bugfix related to custom filters influencing other columns with filters
A more informative error message if the grid can't find the underlying database column for a view column (incorrect :column_name and :model)
=== 8/10/2008
New view helper parameter <tt>:sorting_dependant_row_cycling</tt> - When set to true (by default it is false) the row styles +odd+ and +even+
will be changed only when the content of the cell belonging to the sorted column changes. In other words, rows with identical values in the
ordered column will have the same style (color).
=== 3/10/2008
For simple columns like
g.column :column_name => 'Username', :attribute_name => 'username' do |account|
the following blockless shortcut can be used:
g.column :column_name => 'Username', :attribute_name => 'username'
In this case +attribute_name+ will be used as the method name to send to the ActiveRecord instance.
=== revision 27 (30/09/2008)
* CSV export
* Custom filters can switch between a dropdown list and a multiple select list, thus allowing to search for records matching
more that one value (operator OR)
=== revision 17 (19/08/2008)
* A bug fixed: extra_request_parameters did not propagate to will_paginate page panel. Now it does.
=== revision 13 (6/08/2008)
* File <tt>config.rb</tt> renamed.
* New parameters for +column+ :
* <tt>:boolean_filter_true_label</tt> - overrides the default value for <tt>BOOLEAN_FILTER_TRUE_LABEL</tt> ('+yes+') in the config.
Only has effect in a column with a boolean filter.
* <tt>:boolean_filter_false_label</tt> - overrides the default value for <tt>BOOLEAN_FILTER_FALSE_LABEL</tt> ('+no+') in the config.
Only has effect in a column with a boolean filter.
* <tt>:filter_all_label</tt> - overrides the default value for <tt>BOOLEAN_FILTER_FALSE_LABEL</tt> ('<tt>--</tt>') in the config.
Has effect in a column with a boolean filter _or_ a custom filter.
=== revision 11
* New row_attributes method to dynamically generate HTML attributes for the <tt><tr></tt> tag:
<%= grid(@portal_applications_grid) do |g|
g.row_attributes{ |portal_application|
{:id => "#{}_row_#{}"}
g.column{ |portal_application| ... }
g.column{ |portal_application| ... }
end -%>
* The column block can now optionally return an array of two values, where the first element is the cell
contents and the second is a hash of HTML attributes to be added for the <td> tag of the current cell.
=== revision 10
* New parameter +grid+ parameter: <tt>:extra_request_parameters</tt>.
=== 0
Jump to Line
Something went wrong with that request. Please try again.