TABLESORTER.md

=========== Tablesorter

• https://mottie.github.io/tablesorter/docs/index.html

General Concept

Tablesorter supports filter, column on/off and sort.

A QFQ enhancement allows save/delete/activate of custom tablesorter views. This feature is described in this document.

QFQ uses the table 'Setting' to store per user, public and readonly settings. At time of writing only 'tablesorter' settings are supported. Further settings might come in the future.

Show table with tablesorter activate/save/delete

A page with a HTML table includes the command {{'<uniqueName>' AS _tablesorter-view-saver}} inside of the HTML table tag. QFQ will replace the command::

...

by

data-tablesorter-id:

''

data-tablesorter-sip:

tableId: the '', in the example it's 'allperson' feUser: the current logged in FE user. If no FE user is logged in, take the QFQ cookie. With this workaround, it's at least possible to work with 'views' during a browser session.

data-tablesorter-view: JSON encoded array

Array of views. Each view:

['name'] - Name of the view. Value is html entity encoded. ['public'] - true or false. false mean's 'private'. ['tableId'] - '' - this is the filter to assign views to a specific HTML table. ['view'] - base64 encoded JSON array. It's base64 encoded for two reasons: a) we do not have to take care about SQL injection (the user might supply filter strings, incl. regex expressions) b) the JSON array will contain '}}', which confuses QFQ/evaluate.

QFQ will collect all views:

a) all private views of the current table and FE User, b) all public views of the current table.

Save tablesorter view

The user might click on 'Save Private View' or 'Save Public View'.

A Ajax Post request to

http://localhost/qfq/typo3conf/ext/qfq/Classes/Api/setting.php?s=badcaffee1234

The SIP is the one given by data-tablesorter-sip and contains tableId and feUser. The SIP is right to manipulate the views.

The POST contains:

feUser - fe user login name mode - missing or 'delete' if the given view should be deleted public - true|false name - name of the view view - base64 encoded tablesorter filter/order/column selector.

Response setting.php

setting.php will always answer with a JSON stream (Minimal response):

{
	"status": "success"|"error",
	"message": "<message>"
}