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.