This class ensures the compatibility of the input and output of the functions with js DataTables
NOTICE! Even if the model can be used for more functions, the uage depends on the basic function capabilities. For example: if the basic function allow no fulltext search (q) using the sSearch param will bring nothing
@params DataTable aliases/params:
iDisplayStart Alias to start. Display start point in the current data set.
iDisplayLength Alias to limit. Number of records that the table can display in the current draw. It is expected that the number of records returned will be equal to this number, unless the server has fewer records to return.
sSearch Alias to q. Global search field
iSortCol_0 Column being sorted on (you will need to decode this number for your database)
sSortDir_0 Direction to be sorted - "desc" or "asc".
sEcho Information for DataTables to use for rendering. (Implemented as integer)
mDataProp_(int) - as in DataTable
sSearch_(int) - as in DataTable
@returns
"iTotalDisplayRecords" => total records of the current selection
"sEcho" => received value,
"aaData" - rows
"aoColumns" columns
@param noDataTable - if it is set, the DataTable format is not used.
Arguments
| iDisplayStart |
integer |
| iDisplayLength |
integer |
| sSearch |
|
| sEcho |
integer |
| iSortCol_0 |
integer |
| sSortDir_0 |
|
| mDataProp_0 |
|
| mDataProp_1 |
|
| mDataProp_2 |
|
| mDataProp_3 |
|
| mDataProp_4 |
|
| mDataProp_5 |
|
| mDataProp_6 |
|
| mDataProp_7 |
|
| mDataProp_8 |
|
| mDataProp_9 |
|
| mDataProp_10 |
|
| mDataProp_11 |
|
| mDataProp_12 |
|
| mDataProp_13 |
|
| mDataProp_14 |
|
| mDataProp_15 |
|
| mDataProp_16 |
|
| mDataProp_17 |
|
| mDataProp_18 |
|
| mDataProp_19 |
|
| sSearch_0 |
|
| sSearch_1 |
|
| sSearch_2 |
|
| sSearch_3 |
|
| sSearch_4 |
|
| sSearch_5 |
|
| sSearch_6 |
|
| sSearch_7 |
|
| sSearch_8 |
|
| sSearch_9 |
|
| sSearch_10 |
|
| sSearch_11 |
|
| sSearch_12 |
|
| sSearch_13 |
|
| sSearch_14 |
|
| sSearch_15 |
|
| sSearch_16 |
|
| sSearch_17 |
|
| sSearch_18 |
|
| sSearch_19 |
|