314084 Credit Tracking

This coding job is for an addition to our PHP MySql based website. Our site is already up and running and this would be an add on module to the site. This project will be developed separately from the site with you giving us db tables to create and code to upload. You will not have any access to our db or current coding. We will basically plug your code into our site. You will of course get a current framework of our db in order to pull relevant info. The project is designed to track continuing education credits for professionals. Many professions require that their members complete a certain number of continuing education credits a year. You will create a system that allows our users to sign up for credit tracking. Since each state has different requirements such as frequency of credits due and number of credits, there will be a state db table which has all the requirements. The user will be able to sign up for keeping track of one or more state credit requirements. When signing up, the user can select the info from the db or can overwrite the db with their own deadline and number of credits required. The number of credits required also includes specialty classes, so we need to keep track of general classes along with specialty classes taken. The system should be able to integrate into our db and know when a user has completed a class (date, class name, and number of credits). A user will be able to look at a webpage and see how many credits they have taken, how many more they need before the deadline, and when the deadline is. A user would also be able to upload credits not taken on our site. This would allow a manual upload of credits. The user would enter the name of the organization where they got the credits, the class name, and how many credits they got. The manually entered credits would also show up on our system. There is also a section needed for emails sent to the user. These reminders would be sent to the user a set intervals. A user could have reminders set 1 month before deadline, every month, every three months, every six months, or never. This code would need to integrate into our PHP heavy site, but want some web 2.0 features, so using Ajax to give us that look is needed (or something similar).