| | | | | | |
The main feature of the system will be the customizable generation of online reports based on an existing database. A certain format will be followed. Users will then feed a template form into the system in order to have it filled with the relevant data. Users will specify which fields of the form are to be filled and which fields not be filled. This form will then be parsed and a database query will then be delivered to the database indicating the required fields to be filled in. Upon database query acknowledgement the form will then be filled with the appropriate data. This form will then be saved to a preferred format.
It will have an editor that allows flexibility to create and format a document so that the output of the database can be similar to the template of any desired report.
The user must be able to specify where the different fields from the database would be inserted and how to specify the static and dynamic parts of the template so that the page will be generated correctly using the online editor.
The actual records to be filled would depend on the specific information required by the template providers
The system must be able to accept a database query and generate the report accordingly in the format of the template with the records
Examples of template forms to be filled are available upon request
This project should be written in php and mysql and editor configurations done in javascript since its an open source project.
Upon inquiry a copy of the database schematic will be sent
P.s-this system must be able to populate a dynamic form