Emergency Display and Reporting System

Know what always catches my eye? Short people with umbrellas.

Description

This project was initiated to replace an existing XiboCMS setup that managed the emergency display visuals throughout the Club with a custom in-house solution. The system is divided into three main components:

Emergency Display Page - This component passively exhibits security-related information.
Employee Desktop Page - Designed to remain perpetually open on all club computer browsers, this component functions primarily as an emergency reporting tool. Is the emergency display page, with additional functionalities.
Content Management System (CMS) - This part of the system allows administrators to manage and update data efficiently.

In response to status updates, the system will send SMS notifications to select personnel.

Functions

Emergency Display

Display active emergency codes and the status level of four security-related conditions.
Display date and time, as well as a 7-day forecast for temperature and weather.
Display a news ticker.

Employee Desktop Page

Help system: a step-by-step guide that walks the user through a certain process.
Methods to report emergency: via an emergency button that users can submit in three clicks and a form that users can fill up. Each desktop page is mapped to an employee and a location, and is added to the data sent to the administrators.
Link to download a PDF copy of the emergency manual.
Display emergency hotline numbers.
Mirror the data on the Emergency Display.

Content Management System

Create/edit/delete emergency codes.
Activate/deactivate a certain emergency code.
Change the status level of four security-related conditions.
Create/delete messages that will be broadcasted in a news ticker fashion.
View and respond to messages or emergency beacons sent by remote units.

SMS Notifications

Activations of code alerts and promotions of emergency levels to a certain threshold will trigger the system to send SMS notifications to certain individuals.

Work Done

Interview

Collaborated with the manager of Health and Safety Division to gather requirements and ensure system met business needs.

Development

Designed database schema and created entity-relationship chart to ensure efficient data storage and relationships.
Developed backend code and tested it thoroughly to ensure functionality, reliability, and performance.
Created frontend code and tested it thoroughly to ensure user-friendly interface and seamless integration with backend.
Created database, tables, views, and stored procedures
Integrated system to the SMS distribution system
Produced comprehensive API documentation to facilitate future development and integration.