We have a PHP and MySQl website we created to keep track of our appointments. It is ugly, but functional. It was created by non-professional coders (myself included). It keeps tracks of three types of appointments: Meetings (M), Contract Work (C) and Non-Contract Work (N). C and N appointments also tie to a work record, which details all the tasks achieved during that appointment.
All that being said, what we need is a way to sync our iPhones with our calendar, without having to go to a third party ISP, host or provider. If this means rewriting our calendaring application to an iCal standard, that is fine. We would like to be able to add/edit/remove appointments on one of our iCal calendars on our iPhones, and those appoinments being added/edited/removed from our web calendar. Also, if an appoinment is added/edited/removed from the web calendar, we'd like that to push to our iPhones as well.
This is an application for ourselves, and not for resale. So we need to find a way to get it to our iPhones without necessarily putting it up on the iTunes app store. Although worst case scenerio, we'd want the iPhone app to have settings to enter a URL for the calendar system and save a username and password.
## Deliverables
I don't know how easy or hard this is, which is why I did not suggest a price. Please suggest something that seems fair to you. I have more time than money, so I can be quite flexible with the deadline on this project.
For reference, these are things we keep track on for appointments:
-Date
-Start time
-End time
-Customer Name and ID (obtained from MySQL database)
-Customer
-Employee (the person logging on through iPhone. From the website you can create appointments for other people, but in the iPhone you should be able to only create appointments for yourself.)
-Type (Meeting, Contract, Non-contract)
-Description
-Notes
We are going to have a lot of opportunities for PHP development for our calendar system in the future as well. Please let me know if you are interested in this project.
Thanks!