I need a web based reporting system developed.
The main purpose of the system would be for a user to be capable via the web to enter information into a pre-defined form and when submitted for that information to go into a MySql DB.
The system should have two sections to it, 1) an administration section where by all the forms get created in and users get assigned a user id and password.
2) The web based part, where the users can log in with their name and password and pick and fill the correct form.
The administrator should be able to dynamically create the reporting system with as many forms as needed in a tree style hierarchy.
The administrator should be able to assign permission rights to the users so that they have access to some of the forms and not to others.
The administrator should also when building the forms be capable of choosing the names of the options, the values and whether it should be a drop down list, a radio button or just a text field.
The reporting mechanism should then be capable of returning reports based on chosen dates (between when and when), by form type, user name and anything else you can think of... The reports should give back clear numbers in % format and ideally graphs too. These reports should only be accessible by the administrator. One should also be capable of printing them.
The administrator should start with an empty system. The first question would be:
What name would you like to give to this 'main' section?
He/She types: "Customer Survey"
Would you like another section? yes/no?
Would you like a sub section or a form?
What name do you want to assign the form?
Now please enter the name for the first field..
Now please choose: Radio button, Text field or Drop down list..
Another field or finished?
Now please enter the name for the field..
And that's how it would go until the form is finished. The administrator should be able to create the above forms easily and the user should be able to enter the information easily.
There should be provision for changing/altering or adding more forms or sections to the system.
Everything should be done via a web browser.
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request.
3) Exclusive and complete copyrights to all work purchased. (No GPL, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site).