PHP5 & MySQL Web Pages / Template Project
We need a PHP5 framework developed, this is defines as a set of PHP5 webpages that connect to MySQL 5 Database that perform several specific tasks, be very well commented, and use resource files supporting multiple languages, and work on all server platforms Windows / Linux / Mac OS and all browsers IE8 / FF / Chrome / Safari
There needs to be TONS of comments, and headers for each function!!
There also needs to be documentation explaining how the system works together!
Here are the requirements:
1) A secure login page with the following:
A) Company (Drop Down)
D) Captcha (Graphic)
E) Language (Drop-Down)
F) Style (Drop Down)
The Login page loads session variables from a table in a database, uses the language for database lookups for the field names, and uses the css stylesheet from the style drop down. All of these values propagate to all other php pages in the project, and all steps commented
2) A menu form that has the links to the other forms, with the language drop-down and style drop down so these can be changed anytime and will propagate to the rest of the pages. Menu items display based on user security.
3) A Sample form that does the following:
A) Populates a data grid from a table in the database
B) Allows sorts on field names
C) Allows searches
Be sure to imclude complete and full documentation.
Clicking on one of the records in the datagrid opens a new form, that allows update or delete of the selected record. There should also be an add record form. Values for the new record form should be populated from a default record, code for this should be included in the code of the form with full comments.
All field names for the grid and the record forms come from a database look-up, the system passes the field name and the language to a translation table which returns the proper translation for that field.
All of these pages support the language and style sheets from 1 above, in other works the stylesheet and langage propogates through all of the pages - All records in the database have compound primary keys, so, system should be able to handle this. Make sure the page is fully and completely commented so it's easy to understand whats going on and how to change it. The comments should be good enough for a brand new programmer to follow!
4) date fields should use a date picker with comments
5) Sample form that executes a stored procedure, fully commented
6) Sample form that calles a stored procedure, passing it a value, and getting a reutrn value and displaying it on the screen, all fully commented
7) A sample of a master / detail form, like an order form, field names come from the database lookup like #3 above, completely commented
8) Sample report page from a query, table and stored procedure fully commented
9) Export the report to an email, pdf file, html file, commented fully
Again, ALL pages have the following:
1) Inherted stylesheet from login page
2) Inehrited language from the login page
3) code to lookup the field names from the database using the default fiueld name + language selected
4) support multiple primary keys
5) have TONS of in-linme comments, documentation, and headers for each function / procedure
6) Be hand-written in as easy to understand manor as possible
7) Tested with all popular browsers
8) tested on all populate server platforms, windows / linux / mac
Also needs to comply with the following:
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 Worker 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 worker's Worker Legal Agreement).
We have programmers and designers that have done these frameworks above before, but in different languages, so they will be able to provide a lot of guideance and anwser a lot of questions with any coding and possible provide schemas and such.
Platform is any machine that runs MySQL 5 and PHP5, including Windows / Linux / Mac Servers and the pages should run on any browser. This means use simple, easy to understand code, nothing fancy, it just needs to work and work well