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 of us now have iPhones and when we look at the page with mobile Safari it looks terrible. We'd like a professional to design a new calendar interface to our site specifically for the iPhone. We want a clean look, not graphic heavy.
## Deliverables
I'd like the interface to resemble the iPhone Calendar somewhat, mixed with the simplicity of a mobile-friendly site like: [login to view URL]
These are the things I'd like the interface to be able to do:
-choosing whose calendar to view "My calendar", "Everybody" or "Another person". In the case of another person, have the option to choose from a list of people.
-Viewing the calendar of the chosen person or persons in a "List", "Day" or "Month" view.
-Add an appointment for "myself" or "somebody else". Appointments can be for more than one person at a time. Options for this are: Start time (military time, always in increments of 15 minutes, like 10:15, 14:45 and 16:00), End Time (or length. Appointments MUST be in increments of 30 minutes with 30 minutes minimum length), Customer, Date, Type (Meeting, Contract, Non-Contract; both Contract and Non-Contract appointments also create a record in the "work" table), Description of appointment.
-Edit an appointment.
-Delete an appointment. Deleted appointments must be logged (PHP function for this already exists).
-in Day view, be able to go to "Today", as well as being able to browse back one day and forward one day.
-in List view show today, the last 4 days, and the next 7 days, but it should default to scrolling down to "today" (with something like a href=#TODAY )
-in Month view, ability to select a day from calendar, as well as showing dots in days where the selected person (or persons) has appointments. Also, ability to go to next month, or back to previous month.
I am including almost our entire MySQL table structure, of which the most important tables in this project are: calendar, work, customer, employee, attendant. Once I select a coder, I will also present data for testing. I am also attaching our current web calendar, [login to view URL]
Having an iPhone is not a requirement for this project, although it would certainly help. I am including some modified screenshots of the iphone screens and more or less what I'd expect to see on the iphone-friendly side.