PLEASE NOTE: This project needs to be programmed "the right way" – ie. No quick fix code or copy and paste solutions. The programming should get the job done with the most concise and reusable code. REGULAR UPDATES INCLUDING CODE CHANGES ARE REQUIRED. Many thanks.
We have an existing multi-page "wizard" style application form in PHP that collects information (much like a survey), provides a printable summary and stores the information in a MySQL database. Please ask in PMB for URL along with more details of the changes.
We need to make the following improvements:
a) Database fields need to match the form variables and vice versa. At the moment there are some unnamed variables in the form that need to have a place in the database.
b) INSERT queries need to be created to get the information into the database correctly
c) A few extra fields need to be added to the form, perhaps 4 or 5
d) A new Smarty template needs to be created to present the results of an application for printing
e) If possible, the method of re-filling the form data when the user presses the “Previous” button should be made more flexible and concise
f) An admin section with a staff and admin login levels to view the form results, and see form statistics such as number of forms completed over a time period, and group results by various database fields
We are looking for someone who is tidy with their coding, will suggest changes or improvements to make the system work better, and can start straight away. This needs to be nicely finished.
The UI is in Spanish (not any coding, database field names, or comments) - so if you know Spanish, it's a plus but in no way necessary.
Thanks for your bids!