fusio icon indicating copy to clipboard operation
fusio copied to clipboard

fusioTable - JQuery Plugin to generate paginated table for SQL Table Adapter

Open kidino opened this issue 6 years ago • 3 comments

Just sharing this. It's not really complete yet. But I created this JQuery Plugin where it will autogenerate a paginated table for the SQL-Table Adapter. So far it only supports pagination with ugly buttons. But I plan to support filtering and column sorting soon.

https://github.com/kidino/fusioTable

kidino avatar Dec 16 '18 14:12 kidino

Hi, this looks really great! I have just created a new apps directoy on the Fusio page, since the apps which are working with Fusio are growing we have now an overview. I have also included your library, please take a look: https://www.fusio-project.org/apps

chriskapp avatar Dec 16 '18 16:12 chriskapp

awesome! just a few updates with better pagination buttons, custom columns, sortable columns

kidino avatar Dec 19 '18 07:12 kidino

Some features I am thinking about SQL Table Adapter and maybe do a Pull Request later

  • where primary key is optional, for GET listing, to cater for cases like MySQL Views where primary key does not exist
  • where primary key does not have to be INTEGER. Some cases UUID is used instead of Integer value
  • Response where filterOp, filterBy, filterValue is applied to return parameter for totalFilteredResults, which is required for better pagination

kidino avatar Dec 19 '18 07:12 kidino