I need help to add more functions to a web page based on the CodeIgniter framework (php) and MySQL. The responsive design, user authentication etc is already finished so this bid request only include to add the new functions as follow.
1. Create possibility for authorized users to edit the web page text for four pages (Home, About, Contact, Instructions). The edit function will be in wysiwyg-mode for the page text including possibility to upload and use images with the text. Fields will be Title, Keywords, Description, Introduction and Text body. Only the last two fields (Introduction and Text body) will be wysiwyg. Color, font, size etc will be same as in the css so wysiwyg functions must be limited. The pages must be changed to show the dynamically data saved from this function. No functions to delete or create new pages are needed.
2. Create a form based on the structure in the attached file. The exact names of each form element will be sent to the selected coder. The form will consist of several main questions. If a question is answered with Yes, sub questions will be shown. All Yes/No questions are mandatory. For each question it will be possible to see thumbnail example photos. When a thumbnail is clicked, it will open in lightbox mode together with an image text. A function where authorized users can upload example images with description texts must be included with authorization group other than the form. Before the questions start the following fields have to be:
- Building or place: Drop down menu with the building names from table 'buildings' in the MySQL-database.
- Date for observation: A date field. Current date will be shown as default with possibilities to change to another date.
- Surveyor: Drop down menu with all names and surnames from the 'users' table. The logged in user will be default and if user changes surveyor name to another name than the logged in a warning with text 'Are you sure you want to set another surveyor for this observation?' followed by the buttons Cancel and Yes.
- Inventory number, text field (not mandatory)
- Last question in the form will be a note field (textarea, not mandatory)
After form data are saved the user will be redirected to the empty form.
3. A Statistics function will be created. The name is a little misleading because no statistical calculations will be made. With this page it will be possible to select, view and download posts from the database. Download will be possible as excel format on the page where selected posts are viewed. On top of the page there will be a link to download all data as excel followed by a searching form with the following fields:
- Building name (drop down, table buildings)
- Building category (checkboxes, table buildings)
- Climate zone (checkboxes, table buildings)
- Inventory number (text field, the new form table)
- Possibility to search for all form question parameters with yes/no answers (the new form table)
Of course a search will be possible with several of the parameters at the same time. The posts from the search result will be shown on the web page together with a Download as Excel link.
I will not accept hourly rates so I appreciate if you can give a bid of the total cost for these functions. Time to complete the work may be two-three weeks including time for tests and bug fixes.
15 freelancerjev ponuja v povprečju za $261 na tem delu
Hello menhir, I have read your requirements, I'm a PHP/MySQL Expert and I am very confident to do this project. I guarantee COMPLETE satisfaction before payment. Please check PM for more details!