Replace jqGrid: Difference between revisions
From LimeSurvey Manual
| Line 40: | Line 40: | ||
** Features | ** Features | ||
*** Filter by model : http://www.yiiframework.com/doc/api/1.1/CGridView#filter-detail , model can extend attribute. | *** Filter by model : http://www.yiiframework.com/doc/api/1.1/CGridView#filter-detail , model can extend attribute. | ||
*** Already included in Yii. | |||
* bootstrap-table http://bootstrap-table.wenzhixin.net.cn/ | * bootstrap-table http://bootstrap-table.wenzhixin.net.cn/ | ||
** Antifeature | ** Antifeature | ||
Revision as of 11:07, 5 April 2016
We want to replace jQgrid with another similar jQuery library.
Why?
- Hard to exactly control and style the HTML, e.g. wrap something with a span tag
- Not maintained since the license changed
- ...more?
Wanted features
- Sort by column
- Inline edit or pop-up edit
- Pop-up dialog should handle CActiveForm and model rules validation
- Edit single cell in-line?
- Massive actions, e.g. marking 10 elements and delete all
- Fetch using Ajax
- Filter and/or search
- Pagination
- NB: There's a conflict between real-time filter and pagination. If nr of rows is very large, loading of complete table will take long time.
- GPL or MIT license (or another free licence like a speech)
- i18n
Suggestions
- handsontable, https://handsontable.com/
- Antifeature : Filter data + Header tooltips + Fixing bottom rows are unfree
- Feature: XML-like view, so edit-in-place for single cells could be extremely efficient (from user point of view)
- datatables, https://www.datatables.net/
- Antifeature :
- inline edit are not free
- Features
- Sort by column : https://www.datatables.net/examples/basic_init/multi_col_sort.html
- Fetch using Ajax : https://www.datatables.net/examples/ajax/
- Filter : http://datatables.net/examples/api/multi_filter.html
- Pagination : included
- i18n : https://datatables.net/plug-ins/i18n/
- Antifeature :
- Yii included GridView
- http://www.yiiplayground.com/index.php?r=UiModule/dataview/gridView
- Started in https://github.com/LimeSurvey/LimeSurvey/pull/460
- Features
- Filter by model : http://www.yiiframework.com/doc/api/1.1/CGridView#filter-detail , model can extend attribute.
- Already included in Yii.
- bootstrap-table http://bootstrap-table.wenzhixin.net.cn/
- Antifeature
- Features
Other notes
CPDB
CPDB uses jQgrid to open up - within the table - possibilities to edit attributes and surveys for one participant. This should probably be a dialog instead.
Dialog or inline
- Actual edit in token don't update link. And we have issue with some control. A dialog edit fix this 2 issue more easily.
- Alterantive : use http://www.appelsiini.net/projects/jeditable (still think dioalog editor is the best)