emran / Ssp
Customized Server Side Processing (SSP) Class For Datatables Library
Stars: ✭ 101
Programming Languages
javascript
184084 projects - #8 most used programming language
Labels
Projects that are alternatives of or similar to Ssp
Ajax Datatables Rails
A wrapper around DataTable's ajax methods that allow synchronization with server-side pagination in a Rails app
Stars: ✭ 520 (+414.85%)
Mutual labels: datatables
Vue Data Tables
A simple, customizable and pageable table with SSR support, based on vue2 and element-ui
Stars: ✭ 976 (+866.34%)
Mutual labels: datatables
Clinicmanagement
Clinic management project using Asp.net mvc5
Stars: ✭ 74 (-26.73%)
Mutual labels: datatables
Ce
Jspreadsheet is a lightweight vanilla javascript plugin to create amazing web-based interactive tables and spreadsheets compatible with other spreadsheet software.
Stars: ✭ 5,832 (+5674.26%)
Mutual labels: datatables
Modern Datatables
They are many ways to build reactive web interfaces but do we really need to add the complexity of JavaScript frameworks like Vue.js or React?
Stars: ✭ 48 (-52.48%)
Mutual labels: datatables
Laratables
Ajax support of DataTables (Laravel 5.5+) Demo @
Stars: ✭ 451 (+346.53%)
Mutual labels: datatables
Dashvis
An open-source Dashboard built for users, to organize their resources via Tables and Folders.
Stars: ✭ 31 (-69.31%)
Mutual labels: datatables
Yii2 Datatables
Yii2 Widget for DataTables jQuery plug-in
Stars: ✭ 67 (-33.66%)
Mutual labels: datatables
Tablesaw
A group of plugins for responsive tables.
Stars: ✭ 5,497 (+5342.57%)
Mutual labels: datatables
Lightning Data Grid
A data grid for Lightning Component Framework
Stars: ✭ 24 (-76.24%)
Mutual labels: datatables
Svelte Simple Datatables
A Datatable component for Svelte
Stars: ✭ 56 (-44.55%)
Mutual labels: datatables
Springboot Shiro
使用SpringBoot与shiro实现基于数据库的细粒度动态权限管理系统实例
Stars: ✭ 564 (+458.42%)
Mutual labels: datatables
Drf Datatable Example Server Side
DataTables Example (server-side) - Python Django REST framework
Stars: ✭ 84 (-16.83%)
Mutual labels: datatables
Bunny
BunnyJS - Lightweight native (vanilla) JavaScript (JS) and ECMAScript 6 (ES6) browser library, package of small stand-alone components without dependencies: FormData, upload, image preview, HTML5 validation, Autocomplete, Dropdown, Calendar, Datepicker, Ajax, Datatable, Pagination, URL, Template engine, Element positioning, smooth scrolling, routing, inversion of control and more. Simple syntax and architecture. Next generation jQuery and front-end framework. Documentation and examples available.
Stars: ✭ 473 (+368.32%)
Mutual labels: datatables
Spicy Datatable
React.js datatables without jQuery. Smart react datatable that includes search, pagination and localization.
Stars: ✭ 36 (-64.36%)
Mutual labels: datatables
Bootstrap Simple Admin Template
The most reliable HTML, CSS, and JavaScript simple admin template for developing responsive, mobile first web applications on the web.
Stars: ✭ 92 (-8.91%)
Mutual labels: datatables
Datatables Library
Customized SSP Class ForSSP 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
New formatted COLUMN Array
$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' )
How to Use
$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
Note that the project description data, including the texts, logos, images, and/or trademarks,
for each open source project belongs to its rightful owner.
If you wish to add or remove any projects, please contact us at [email protected].