Project Description:
Hi Every one,
My client have already created this application in VB with MS Access. Currently client want to develop the front end in php instead of Vb.net and MS Access Database to MySQL. This application will be hosted online in linux server. Current VB application is running in a local machine at client's place.
I have attached the MySql database (download from : http://arulpuramcetpflow.com/sample-data_dump.zip) from which you need to code the front-end in php to retrieve data from Database and list it in the design as given below.
1. Index Page - http://arulpuramcetpflow.com/template/
2. Home Page - http://arulpuramcetpflow.com/template/home.html
3. Readings (search filters) Page - http://arulpuramcetpflow.com/template/readings.html
4. Pre Treatment and RO Page - http://arulpuramcetpflow.com/template/readings_ptro.html
5. Evaporator / Crystaliser / Brine Page - http://arulpuramcetpflow.com/template/readings_ecb.html
6. Member Units - 1,2&3 Page (this will be default pattern for all 15 Units) - http://arulpuramcetpflow.com/template/readings_mu123.html
Reports are generated on Daily and Monthly (monthly design format yet to complete-it will have 30 days record of each day total value) basis and each report has its own format as designed in the html pages. Export to excel option must be available - it must be the same pattern as like the html page.
Also i need a script that will do a incremental backup from existing MySQL database (local machine-with internet access) and upload the same to the online DB which is hosted in Linux. So this script will update the latest datas from local machine in a set time interval for online access.
I will give you the source of the html pages and expect you to code the functionality in php.
PM fo any clarifications.
