Customized SSP Class For Datatables Library
SSP is a Server Side Processing class for Datatables Library v1.10.0. I have customized it for include JOIN, Extra condition and Rename acceptance within query.
While using Datatables with complex query, I faced problem like these
- Get Data from Multiple table not supported via Joining.
- Extra Where, except filtering was not possible.
- During work on Multiple Table, to avoid Duplicate key was not possible.
So due to allow complex query, I have changed the SSP class like my own. What i made changes are
- I have added option to ADD JOIN Query and make necessary changes.
- I have changed Column ARRAY format to handle get data from multiple table. Add TWO new index for complex query handle.
- Add Extra Where condition through SSP Class.
- You can Group by the result via sending Query through simple function of SSP Class.
- You can use Having as well same like Group By
$columns = array(
array( 'db' => '`c`.`id`', 'dt' => 0, 'field' => 'id' ),
array( 'db' => '`c`.`login`', 'dt' => 1 'field' => 'login' ),
array( 'db' => '`c`.`password`', 'dt' => 2, 'field' => 'password' ),
array( 'db' => '`c`.`name`', 'dt' => 3, 'field' => 'client_name', 'as' => 'client_name' ),
array( 'db' => '`cn`.`name`', 'dt' => 4, 'field' => 'currency_name','as' => 'currency_name' )
array( 'db' => '`c`.`id_client`', 'dt' => 5, 'formatter' => function( $d, $row ) {
return '<a href="EDIT_URL"><span class="label label-inverse"><i class="fa fa-edit"></i> Edit</span></a>';},
'field' => 'id_client' )
$joinQuery = "FROM `{$table}` AS `c` LEFT JOIN `currency_names` AS `cn` ON (`cn`.`id` = `c`.`id_currency`)";
$extraCondition = "`id_client`=".$ID_CLIENT_VALUE;
echo json_encode(
SSP::simple( $_GET, $sql_details, $table, $primaryKey, $columns, $joinQuery, $extraCondition)
);
I have described the changes at My personal blog. You can also check there to see details.
Hope it will help... Thanks
React
Typescript
Django
Laravel
Facebook
Microsoft
Google
Alibaba
D3
Tencent