ColdFusion Reminder Script

I have a coldfusion site that needs to be able to provide a very simple reminder service for people to take medication, dr. appointments, etc. The site is hosted, and the DB is MySQL.? Everything in the site is complete except for the processing of the reminder script.? We cannot user CFSCHEDULE for the reminders because it is hosted, and there may be tens of thousands (or more) events, so we need to have a CFSCHEDULE event that regularly (once every 15 or 30 minutes) processed this script, and the script will take care of everything. The reminders also have to be aware of the users time zone ## Deliverables I have a site in ColdFusion that is connecting to a MySQL Database. I need for someone to write a simple ‘REMINDERS’ app for me that does the following There is a TABLE called REMINDERS, that has the following fields: User This is a user id that corresponds with a record in the USERS table of the database. Type This will hold a TYPE of reminder.? It can be Appointment, Take Medication, Refill Prescription, Check Vitals, or Other. Recur This is a Boolean.? It tells if this is a recurring reminder or one time only.? If it is one time, once this reminder completes, we need to delete it. Mon A Boolean for Recurring reminders, that tells us if this happens on Mondays. Tue Same as above for Tuesday Wed Same as above for Wednesday Thu Same as above for Thursday Fri Same as above for Friday Sat Same as above for Saturday Sun Same as above for Sunday Date If the Recurring Boolean was 0 (so this is one time), on what date does it happen? Time What time should this happen (for both recurring and not) Remindwhen How many hours BEFORE the above day and time should the reminder happen? Remindto This will be set to EMAIL or SMS Subject The subject of the mail or SMS Message The message body. ? I will have a scheduled task in Cold Fusion that will run every 15 minutes or so, and run the script you make. Your script has to send an e-mail when it is time to send an e-mail based on the above, or send an SMS (I will have an SMS gateway set up). ? ? The e-mail address to send to and the cell phone number for the SMS will both be in the corresponding USERS table. You have to make sure that the script is bulletproof, and: 1.? ? ? ? ? ? Does not double-fire the same event 2.? ? ? ? ? ? Has a way of making sure everything that needs to be processed is processed correctly. 3.? ? ? ? ? ? Is extremely fast and efficient, as there can potentially be hundreds of thousands of events. 4. It has to also have a way of knowing the user's time zone and sending notices when appropriate based on their time zone You will also provide me with a basic form for adding, editing and deleting reminder events as follows: lease select your reminder type and medication Choose one of the following: __ Remind me to take my medication __ Remind me to refill my prescription __ Remind me to both take and refill medication - OR - __ Remind me about an appointment __ Remind me to check or monitor my vitals ? Step 2 | Select your appointment date Name Your Appointment: __________________________ Date: _______________________? ? Step 3 | What time is your appointment? ? Time: ______________________________ Time Zone: ________________________ Step 4 | Please type your appointment message _________________________________________________________________ _________________________________________________________________ _________________________________________________________________ ? Step 5 | When would you like to be reminded? ? Remind me: _______ + pulldown with “minutes?? “hours?? “days?? and “weeks?? as options. ? Step 6 | How would you like to be reminded? ___ Email ___ Text message ? ? I will provide you with: A login to the hosting account for this app with full access.