Project:
Induction Panel
This Project allowed me to upgrade my MySQL skills significantly and learn bunch of useful things.
The Induction Panel allows an employer to assign an employee or a contractor a set of courses and tests to perform. Each inductee can complete them at his own convenient time. After successful completion a Certificate can be printed out. Each Certificate is by default valid for a period of twelve months.
Features
- Two panels: Admin and User (different panels can be added if requested)
- Each course can be delivered in a format of online Screens or a PDF file
- A test can be set for each course
- Many courses can be groupped under a Program and thus assigned to the User with one click only
- Auto-reminders (via email) for assigned contractors who haven't yet started a course (after 14 days)
- Expiring Certificate email auto-reminder (2 weeks prior expiration date)
- jQuery search populating a query on the fly
- Reports exported in .csv format
Main View, listing all the Inductees and their status (not started, in progress or completed). The X in front of the name indicates the Induction is already past due. Cron Job's script checks every day's date against expriring inductions and auto sends emails one day before due date. Another Cron checks if the course has been started and if the status still flash as "not started" after 14 days, an auto email is being sent to the User
New Users, not assigned yet to any Course / Program
Adding a new course
Upload a PDF ( or Screens ) if they were selected. For screen, scroll down
Now, since to PDF file is alredy uploaded, proceed to manage the Test
Course with updated requirements - Test and a PDF file
Assigning multiple courses to a Program while creating it
Quick edition
Other means of delivering the Course, apart from a PDF file, are the Screens, in a form of slides
They can be added/edited with a regular WYSIWYG with built-in Library for Media files
Assigning the Inductee to Courses and/or Programs
- Skills used:
- programmer
Random projects for programmer
Ambrosia Interior Design
Garden Figurines
Der Designs
Coo-ee Art
Products for Points
Order Manager
Wordpress
I've lately been using:
- Wordpress
- PHP
- CSS
- jQuery