PHP/MYSQL application
We have a calendar service, that is used by 200 people doing approx 7000 bookings a month.
We need a small PHP application that can be used when our customers are doing minor things, from their mobile phones for instance.
The formatting / layout is minimal.
The user will be able to:
* Log on (password verification)
* Select which calender and which date they want to display
* Schedule a visit
## Deliverables
PHP/MYSQL application
We have a calendar service, that is used by 200 people doing approx 7000 bookings a month.
We need a small PHP application that can be used when our customers are doing minor things.
The formatting / layout is minimal.
The user will be able to:
* Log on (password verification)
* Select which calender and which date they want to display
* Schedule a visit
The main use for this application is using our normal calendar on webbrowsers in mobile phones like windows mobile and iphone.
-------
database name clinicbuddy
login root
password XXX
--------
All these steps have HTML examples.
----
STEP 1.
----
Login screen:
Username: ____
Password: ____
[X] Keep me logged in until i log out
SUBMIT
----
Username and password are input textboxes, the keep logged in is a checkbox. Submit is the submit button
If Keep logged in is checked, the person will be logged in next time he accesses this page, otherwise he will be asked to log in again once session has ended (a timeout).
----
STEP 2.?
----
When pressing submit
check database table "personnel" for "name" and "password". Store from same table persons "company" (integer, number) as cookie or global varible.
If "name" doesnt match "password" or if name doesnt exist, go back to step 1 - login screeen.
----
STEP 3.
----
Show the "personnel" of the "company" that was retrieved in step 2. All are selectable.
----
STEP 4.
----
When a "personnel" was selected, double check that that personnel has the same company (number) as the first one stored in step 2.
Show screen of dateselector
Once a date is selected go to step 5.
----
STEP 5.
----
Show the "personnel_reservations" for this person, sorted by time. If there is a gap in the schedule, a link with the number of minutes should be there. if the link is pressed go to step 6 with the start time pre entered (not the end time).
Ability to schedule a time
If booking, go to step 6
----
STEP 6.
----
Show form for scheduling. Once stored -? Go back to step 5.
The tables in the database:
personnel
---------
id unique ID number for the personnel
name login name of the personnel
password the password
company which company they belong to (a number)
personnel_reservations
----------------------
id unique ID number of the reservation
personnel which personnel does the reservation belong to
timefrom start time
timeto end time
date date of reservation
comment text field of whats been booked
Please see attached zipfile, with all the forms as HTML example.