I am looking for one final script for my site.
My company offers safety training courses such as first aid and CPR classes.
I would like to get a script that interfaces with a MySQL database indicating my availability. Nothing fancy here, just a means of indicating if my day is taken already or not.
The script will obtain input on the number of people the training is for, how many classes, number of books needed, type of training, any ADA accomodations needed, location, etc. It will also ask specific questions (ie "Do you want adult CPR, do you want child CPR, etc) in a number of fields.
Each question will have a certain value placed to it. A quote will be generated via multiplying this total times the number of people to be trained. The variable representing the number of people to be trained will probably be further modified by a multiplier which will charge according to the number of people to be trained.
The script will present an invoice automatically and offer the customer the opportunity to pay via credit card to reserve the day. The script will also present an option to mail a check. Either day, the script will cause the day to be flagged as unavailable in the database.
After the quote is generated and/or paid for, an email will be sent to me with details about the quote, etc.