WiceGrid
Sources: http://github.com/leikind/wice_grid
API: http://leikind.org/apis/wice_grid/index.html
Examples online: http://grid.leikind.org
About
WiceGrid is a Rails grid plugin.
One of the goals of this plugin was to allow the programmer to define the contents of the cell by himself, just like one does when rendering a collection via a simple table (and this is what differentiates WiceGrid from various scaffolding solutions), but automate implementation of filters, ordering, paginations, CSV export, and so on. Ruby blocks provide an elegant means for this.
WiceGrid builds the call to the ActiveRecord layer for you and creates a table view with the results of the call including:
- paging
- sortable columns
- filtering by multiple columns
- CSV export
- saving queries
All working nicely together. Filters are added automatically according to the type of the underlying DB column. Filtering by more than one column at the same time is possible. More than one such grid can appear on a page, and manipulations with one grid do not have any impact on the other.
WiceGrid does not take a collection as an input, it works directly with ActiveRecord (with the help of will_paginate).
WiceGrid does not use AJAX calls to reload itself, instead simple GET requests are used for this, nevertheless, all other page parameters are respected and preserved. WiceGrid views do not contain forms so you can include it in your own forms.
WiceGrid is known to work with MySQL and Postgres.
Examples
Filtered by two columns, ordered by title, javascript calendar:
A grid with filters hidden and a CSV export icon:
Selection by three filters: