I need to convert an existing web based reporting interface(ASP + Java applet) to PHP based.
it has about 20 report templates where user can select parameters and generate report against a sql based transaction database, it mainly has a customer table and transaction table, with some supporting tables.
Most of the reports are generated in both data grid and graphics format (bar chart, pie chart).
user should be able to export the reports into excel, csv, pdf and xml.
user should be able to drill down the report results to see more details.
report result should be cached for for easy regeneration, re-sort, export etc.
user should be able to save a template with the parameter specified, and schedule it for regeneration and auto email in a particular export format of choice.
The development has be in PHP with mysql as the backend, an ready built M-V-C framework has be used ( it is to make sure the reports module are going to fit nicely with other system modules, it will handle the user authentication/privileges, multi-language and database abstraction stuff). Compatibility with MSSQL is required.
Potential developers should at least has 2 years of PHP experience, done decent size o-o and M-V-C type of PHP project. Must have good knowledge on mssql/mysql, query optimization/cache etc.