I give you ready MySql query text and all what I need from you is component which in joomla administrator page show this MySql query result as a table.
1. Design doesn't matter
2. Click on header should sort by columns asc and desc
3. In setting should be stored option "rows per page". For example if it value equal 10 then table should be shown on multiple pages, on each page only 10 rows.
4. First column on table should be checkboxes where should be possible to check single checkboxes, all checkboxes on all pages, all checkboxes on current page.
5. Option Export to CSV, which export checked rows to CSV
6. In the end of the page should be calculated three totals of the column "Amount" Total amount per page, total amount per all rows, total amount per checked rows.
7. Email column values should be clickable as a hyperling to index.php?email=[email_value]
8. In Last column of each row should be button "Open". Which perform other mysql request UPDATE persondata SET open=1 where contr_id=xxx;
xxx mean that should be used contr_id value of current row.
9. Should be possible to filter table and show only records from some datarange. column Date_added
10. Search by field value (optional if it too hard to realize or extremally increase work price notify me)
I can't give you any access to my webpage. You should prepare extension and just give me it to install via joomla administrator panel.
If you speak Russian you can write me on Russian language too.