Class DataTableHelper

This class contains helper methods for datatable manipulation. Create an instance and define the columns of your table and their respective database fields. You can also provide two fields separated with a space for concatenated string.

Package: Extensions\Helpers
Category: System
Located at Extensions/Helpers/DataTableHelper/DataTableHelper.inc.php

Methods summary

`public string`	# `getOrderByClause( DataTableColumnCollection $columns )` Get ORDER BY clause. Get ORDER BY clause. This method will check the order parameter of the DataTables request and return the appropriate ORDER BY clause. Notice: DataTables sends the zero-based index of the table column and not the name. If the column order changes then the method needs to be updated. Parameters `$columns` Contains the definitions of the table columns. Returns string Throws Exception If there is no order case for the provided column index. InvalidArgumentException
`public array`	# `getFilterParameters( DataTableColumnCollection $columns )` Get the filtering parameters of the request. Get the filtering parameters of the request. Notice: Multiple string values need to be sent as concatenated strings with "\|\|" as the delimiter. Parameters `$columns` Contains the definitions of the table columns. Returns array Throws InvalidArgumentException
`protected array\|string`	# `_trimArray( string\|array $entry )` Recursively trim the array values. Recursively trim the array values. Parameters `$entry` Returns array\|string

Packages

Classes

Interfaces

Class DataTableHelper

Methods summary

Parameters

Returns

Throws

Parameters

Returns

Throws

Parameters

Returns