Background
This website is an administrative tool for tracking whether a business’s tradespeople have valid safety certifications. It is based off my own past job experience in which the company I worked for was ineffectively tracking their tradespeople’s safety certifications in an Excel sheet, causing issues in which tradespeople’s safety certifications would expire and training certification renewal sessions were being scheduled reactively, resulting in downtime.
This webtool I conceived looks to solve that problem by providing the administrator with alerts and visual notifications of certification expiries/upcoming expiries.
The website allows the administrator to create, edit, and delete tradespeople from the Trades page.
The Certifications page allows the administrator to create certifications associated with each of the tradespeople in their company. This page also allows certifications to be edited and deleted from the table.
JavaScript is used on the page to highlight all expired safety certifications in red and highlight soon to expire (within 30 days) certifications in yellow, alerting the administrator so that training can be scheduled proactively, and safe work policies can be followed.
All valid certifications remain green on this page. In addition, alerts pop up when opening this page to notify the user about the total number of expired and soon to expire certifications.
Key Features
- All pages require the user to be logged in before they can view the content.
- The user is redirected to the Login page if they try and access any of the restricted content.
- The Login page has an optional button which links to a Sign Up page. If the user doesn’t have login credentials, they can sign up as a regular user here.
- When logged in, the user name is now displayed on the Home page in a greeting message.
- Only accounts with administrator privilege’s have the ability to edit content, preventing regular users from tampering with the data.
- On the Certifications page, I changed the pop-up alert message into a set of <div>’s at the top of the page, so all the warnings about expired/soon to expire trades certifications appear near the top of the page.
Final Solution
Ideation
A colour-coding system along with alert messages was conceived to bring attention to expired, and soon-to-expire tradesperson safety certificate so a manager can schedule the appropriate training and ensure no tradesperson is working unsafely while their certification has expired.
Database Schema
A database was connected using phpMyAdmin.
Background
This website is an administrative tool for tracking whether a business’s tradespeople have valid safety certifications. It is based off my own past job experience in which the company I worked for was ineffectively tracking their tradespeople’s safety certifications in an Excel sheet, causing issues in which tradespeople’s safety certifications would expire and training certification renewal sessions were being scheduled reactively, resulting in downtime.
This webtool I conceived looks to solve that problem by providing the administrator with alerts and visual notifications of certification expiries/upcoming expiries.
The website allows the administrator to create, edit, and delete tradespeople from the Trades page.
The Certifications page allows the administrator to create certifications associated with each of the tradespeople in their company. This page also allows certifications to be edited and deleted from the table.
JavaScript is used on the page to highlight all expired safety certifications in red and highlight soon to expire (within 30 days) certifications in yellow, alerting the administrator so that training can be scheduled proactively, and safe work policies can be followed.
All valid certifications remain green on this page. In addition, alerts pop up when opening this page to notify the user about the total number of expired and soon to expire certifications.
Ideation
A colour-coding system along with alert messages was conceived to bring attention to expired, and soon-to-expire tradesperson safety certificate so a manager can schedule the appropriate training and ensure no tradesperson is working unsafely while their certification has expired.
Key Features
- All pages require the user to be logged in before they can view the content.
- The user is redirected to the Login page if they try and access any of the restricted content.
- The Login page has an optional button which links to a Sign Up page. If the user doesn’t have login credentials, they can sign up as a regular user here.
- When logged in, the user name is now displayed on the Home page in a greeting message.
- Only accounts with administrator privilege’s have the ability to edit content, preventing regular users from tampering with the data.
- On the Certifications page, I changed the pop-up alert message into a set of <div>’s at the top of the page, so all the warnings about expired/soon to expire trades certifications appear near the top of the page.
Database Schema
A database was connected using phpMyAdmin.
Final Solution