We have a database application built for a service company using the web. Programming is in php, MySQL database. The app lets customers (or office staff) schedule appts on-line & generates daily schedules (on paper) for techs to make their service routes. Performs other functions like letting customer pay bills on-line, etc.
We want to provide techs with a tablet style computer that they can take with them. We want to download to the tablet each day the daily schedule with driving directions (as calculated on the web server using Google Maps). The tech will make service calls, then will use a parts database on the tablet (downloaded from the web server), indicate which parts are used on each job. The tech will enter labor hours spent on each job. The tech may take credit card payments from the customer. Finally, the tech may take photos (using the tablet) of circumstances of a specific job. The tech might also enter free-form text to annotate job circumstances.
At the end of the day, at the office, the tech will upload the results (parts used, hours per job, photos & payments made) to the web server.
The ideal circumstance would be to use php & mySql as the software on the tablet, using the tablet as a web server during the daytime (localhost), then when connected to the internet, upload the appropriate info from the tablet database to the web server.
We are looking for the tablet best suited for these requirements.
Which one would be best suited for these needs?