I need a sorting class (not using pear libraries or prototype). I should be able to designate via php (using template.php) what tables I want it to talk to and what fields I want it to retrieve from the database along with the names for each column (header).
Two files :
sortlist.class.php (master class file)
template.php (extends master class for specific list)
Sortlist class will have all the methods to create a sortable table list that is paginated with a specified # records per page (see screenshot example).
…
template.php is and extension of the sortlist class and where I will build the sorted list by using php and setting custom variables it is also where the Mysql Query is done. I need to be able to search filter the query and I select the column to filter with a dropdown menu(see attached screenshot example) all filter and page data is done via AJAX. I should be able to send a flag variable (bool) to turn off sorting on a particular column. I should be able to specify column width. Also I should be able to attach a function to convert the data value before it outputs it to the table. Something like..
cols[‘mysql_table_field’] = Array(‘Column Header’,width,’center’,’8pt’,[sortable flag],’function_to_run_on data_if_any’);
Also need to be able to export the data in the table to EXCEL / CSV.
I would like this to be built on your own server. You can send me a link to run tests. I will escrow and complete payment when I am happy with the product. Then you can send me the files, and I get all ownership and rights to the files.
