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 [url removed, login to view] 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 : [url removed, login to view]) 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 - [url removed, login to view]
2. Home Page - [url removed, login to view]
3. Readings (search filters) Page - [url removed, login to view]
4. Pre Treatment and RO Page - [url removed, login to view]
5. Evaporator / Crystaliser / Brine Page - [url removed, login to view]
6. Member Units - 1,2&3 Page (this will be default pattern for all 15 Units) - [url removed, login to view]
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.