Appointment CALENDAR

Create an online Appointment Calendar? for my events using PHP software and an easy-to-use? DataBase (i.e. can be examined, edited,? and printed? offline with standard text? editing software).? Deliverable is working source code.? This will be on its own separate web page on my site.

This software must display a graphic calendar of the current month (with an option to show? 3 or? 4 months into the future, 1 at a time), keep track of maximum number of Attendees allowed at any one event,? provide for multiple events (time-slots) per day,? let an Attendee to choose the day, time-slot, and enter their information (into the DataBase).? When an event is full, it is [graphically & textually] indicated as FULL so no others can book that same time-slot.

? ?

## Deliverables

I require a "proof" pre-approval [

*Phase 1*] on the graphic of the Calendar, time-slot open & FULL? look,? & control buttons (forward a month, back a month [to current], and "Book Your Appointment" [submit] buttons), and the data entry fields, before starting the main coding & DataBase interface [*Phase 2*].

Once Appointment is made, Attendee will see their Last Name & # Attendees

appear on the Calendar.? Attendee must have ability to change # of Attendees (if open, for more), Reschedule to another open time-slot, or even to Cancel an Appointment. (Upon any Cancellation or reduction in # Attendees, time-slot ? if FULL, should revert to open.)? Also, Attendee should be able to print this out.

INFORMATION Attendee must enter:

1). First Name.

2).? Last Name.

3). Email Address.

4). Phone #.

5). Alt. Phone #, [optional if they don't have 1; separate check box can say so].

6). City.

7). Zip.

8). # Attendees? [This could be a drop-down box with 0, 1, & 2, defaulting to 0 which would give err message if they don't change it.]? We want them to THINK about this, and enter correct information carefully.? (Other ideas are welcome!)

Software allows event Coordinator [via login?] to have a separate view with ALL Attendees' information. This? should be printable.? Software allows event Coordinator to have control? to set:

Time-slot start times (e.g. 9:00 am, 1:00 pm, 7:00 pm, and others), including adjusting the event time/duration (currently 3 hours), and deciding which days events will happen & which not? [typically, each month will be pre-planned];

Minimum & Maximum # of Attendees per event [current thoughts: 2 min, 8 max];

Location of event [perhaps can be color coded for different local cities?];

Override Database information [e.g. # Attendees to 3 or more, etc.];

Hecklers? into a "Do Not Allow" Database, to prohibit their future attempts to? make an Appointment (via email, last_name, phone # & alt. phone); this too needs to be editable;

?

Indication of a CANCELLED event? OR ? change of event location;

Our GOAL is to fully inform (via text/instructions) the prospective Attendee of how to get things done on this Appointment web page.? Have understandable err messages, when they happen.? Yet we want to make it as simple, intuitive,? and easy for them as we can.? (And for the Coordinator, too, if possible.? ;-)

* * *This broadcast message was sent to all bidders on Thursday May 13, 2010 4:54:57 PM:

Answering some Bidder's questions & providing more clarification:

1. Attendee identified by email address (&/or phone #) with NO NEED to login - only Coordinator needs password protected login to schedule event days/times/places & edit DataBase. Attendee, if already registered, enters email address (or phone #) and their data is redisplayed. Text instructions - I had planned to add this - will explain how to reschedule (create new, then cancel old?) They can edit their info - e.g. change # attendees (GUEST), reschedule, or cancel their Appointment.

2. Attendees are individuals - not Teams. 8 people (this to be a Coordinator setting) FILLS the event. Event will be cancelled if less than 2 people (again, a Coordinator setting) are registered to attend.

3. Attendee can later bump up from 1 to 2 people (attendee + guest) if event has space (is OPEN). Guest "associates" with Attendee, but has no info in DataBase. Or Attendee can reduce from 2 to 1 (or 0 = cancelation, which should be confirmed by Attendee). This opens a FULL event.

4. A registered Attendee adds/removes guest, reschedules, or cancels by entering email (or phone #) & gets their Appointment data. Separate buttons allow: edit data (including change # guests), reschedule, or cancel.

5. "Proof"/pre-approval on graphics - I just want to see a prototype/mock-up of how the screen will look (calendar, Attendee controls & event selection, event listings & Attendee name display, input form, and coordinator controls) before you get into the main coding & database setup. This could be a few JPEGS with descriptions, or your page to view out on the internet [without DB]. This will let me know if you are on-track & have all the functionality built in that I need.

6. Pre-planned time slots for events: Coordinator will enter this info - which days have "No Events", other days will typically have 2 or 3 events. On the calendar, I'd like to show those 2 or 3 events (Coordinator will enter:

date/day, time, location), and then the Attendee will enter the # in party ([1]Attendee, or [2]Attendee + Guest) and input form data. The # attending and the Last Name (e.g. "2 LastName") will show on calendar for each event. [Could be "just there"/displayed [most desired], or on hover/mouse-over, or even on click for day or event. Coordinator plans to enter data for each month ahead of time (the previous month), and adjust as necessary.

7. Admin Page or NOT? Depends on how easy it is to edit/populate the DataBase without one. This needs to be easy for the Coordinator, and will likely be used multiple times per month, to set event info, update upon phone calls received from Attendees, and if event gets cancelled. The ability to do this must be allowed only to the Coordinator (NOT the Attendees). Coordinator can edit Database info, including adding another Attendee, change phone # or email of Attendee, moving an Attendee to the "Do-Not-Allow/Heckler" Database, bump the # of attendees to 3 (Attendee + 2 guests) or 4 (Attendee + 3 guest) or whatever, [Note: the Attendee is limited to 1 or 2 via software; again, drop-down box with default = 0 is desired concept].

8. Colors? I was hoping to allow YOU this creativity. But as a guide, I want to see already PAST days on the calendar (still with date number) "blocked off" without events showing, and not accessible. Suggestion: light red background, perhaps with red "X" in day (table cell)? The same background could be used for "No Date #"/empty-day cells. Current Day "highlighted" in some unique way, WITH events listed for the day. Suggestion: light green background? Other days with events, WHITE. Days with NO events, perhaps light yellow? Locations: currently plan for 2 to 4 different event locations (maybe more later), and these also should be color coded, with 2 character initials; e.g. "MH" = Morgan Hill, "SC" = Santa Clara, "MV" = Mountain View, & "SM" = San Mateo. These will be beside each event, as set by Coordinator. A "key" describing the city initials (& color codes), with complete addresses for each event, will be easily visible on the page. [I can add this, if necessary.] Also, FULL events are color coded - perhaps in red (?) and are NOT accessible to new registrants. [Nor for adding a Guest to an already-registered Attendee.]

9. Event Cancellation: I had planned to manually email &/or phone call the attendees [they would need to contact their Guest(s)]. This happens if < 2 Attendees are registered, OR (sometimes) if the presenter is forced to cancel. IF you want to offer the enhanced capability to email all attendees, that is FINE - but not required. I will ask about whether your bid includes this before I select my coder.

10. CMS (Content Management System)? This sounds like you MAY be getting too complex.

I'm not sure, but this sounds like "overkill".

Is this what you envision to be the Coordinator's connection to/with the DataBase?

Is there any EASIER way to DO this?

11. My comment to bidders: Some bidders are showing me "calendar" like pages. I have asked my project be PHP (+ MySQL or other DB). Some calendar projects being shown to me are JavaScript [and not PHP]. I intend to work some on this project later, mostly adding instructional text where necessary. And making things SIMPLE/EASY for the Attendee. But also to change any "hard-coded" variables that are not controllable from the DB [which I consider more desireable], and perhaps an occasional "bug fix" (?). In this regard, I believe I can handle PHP edits & source-code enhancements. I am less confident I can handle JavaScript, and if this project CAN be done WITHOUT JavaScript, that is what I want. I expect clear, standard comments scattered as needed to describe functions, structures, variables, program flow, "tricky coding", and so on. I.e. Code it like YOU would have to maintain it (after 6 months away from it)!

12. If you have already bid, and the above new details would cause your bid to be invalid, you may submit a NEW bid (please mark as "Adjusted Bid").

13. To the bidder who asked me to raise my limit amount: "NO!" (I'd code it myself, if I had to. But I doubt I'll have to, after looking at several bids coming in.)

Administration de Bases de données Ingénierie MySQL PHP Architecture Logicielle Tests de Logiciels SQL Hébergement Web Administration de Site Web Tests de Sites Web

Nº du projet : #3415517

À propos du projet