We need a web application that allows for the entry of info on forms and then generates reports based on the info entered and saves these reports in PDF format in disk.
The current system is composed of forms that were created in MS Word using VBA which use a db in Access.
We want this to be converted to a web app.
The user will select from menu the form that he wants to fill. The form will request an ID which will be used to get info from db to fill the fields, the ID is like a member ID. If there is no info for that ID a new record ID will be created with the supplied info. Once the user enters the info the record should be created or updated in the DB and the user have the option to create a report from the form that can be either save to disk and print or just saved.
The forms are docs such as loan applications. Types:
informative ??" paragraphs of text like for small contracts. Nothing or little is entered. Do not get info from the db.
simple ??" these require info to be entered. Some will retrieve data from db based on a key.
complex ??" require info. to be entered. they will retrieve data from db based on key.
The majority of the fields are common to all forms. such as name, address, phone, etc.
The total forms is 54. 13 informative, 8 complex and 33 simple.
Must include an admin area to create/update/delete users.
Finally it should log in a table:
* user login/logout
* User opens form and save
All current forms will be provided. The coder will be responsible to:
* create the app.
* Create the new DB, can use the current structure for reference
After consideration we can provide an example of forms.
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
The app. Must run in a Red Hat server, and instructions should be provided for installation. It can be developed either in PHP or JSP, the DB will be MySQL. Any tool that is used to create the system must be open source. It is not a requirement for the reports to be created with a report writer.
Apache web server
PHP - latest version
MySQL - latest version
JSP & Tomcat