We have an existing website created in Joomla which includes a PHP + MySQL application (embedded as a component). The application has a simple Add / Edit form and a Search facility. The master table has about 15000 records, along with about 10 supporting tables. I am unable to share the current website details, however once the project is confirmed I will share the details, including the existing table structure.
We want to upgrade the existing search facility as described below :
1) The search utility has to be very fast, hence it is important that the search queries are created as per the best practices. I am fine if the existing table / database structure needs to be changed.
2) The search utility will have 3 search fields as shown in the screenshot1
3) The output of the search should be displayed via various Google Charts as shown in the screenshot2
The screenshots are created only to depict the requirements and not the final design and hence you can provide better design suggestions.
Only serious freelancer bids are requested, should have good past experience to showcase. More work on the same project will be given to the freelancer who implements this work tp our satisfaction.