Full Stack Developer

Online Rota Management System Specification

Overview

The system is an online rota management platform designed for driver scheduling. It will be accessible via a weblink and include an interlinked mobile application where drivers can view their schedules.

The system will have two types of users:

Drivers – Can only view their own rota but cannot modify it.
Administrators – Have full control over shifts, users, and scheduling.
User Roles & Permissions

Driver Permissions

Login via email and password.
View only their own rota.
Cannot edit, modify, or delete any data.
Receive push notifications regarding their assigned route and van.
Access the mobile app to view their schedules.

Administrator Permissions
Full control over the system.
Ability to:
Add, remove, and edit users (drivers). When driver is removed all data is archived and stored
Modify shifts for all users.
View all users in a single screen.
Assign service types to drivers.
Set up routes and van assignments.
Send push notifications to drivers regarding their routes.
User Interface & Design Layout

Main Rota View (Administrator Dashboard & Driver View)

The rota should be structured as follows:

Drivers' names listed down the left-hand side of the screen.
Week numbers displayed at the top of the screen.
Days and dates running horizontally from Sunday to Saturday.
Each cell should display the assigned service type for that day.
Administrators can click on a cell to edit the assigned service type.
Drivers can only view their assigned shifts.
Service Types Available

The following service types must be available to assign to drivers:

"In"
"Ridealong"
"NL1"
"NL2"
"NL3"
"Debrief"
"Off"
"Class"
"Drop"
"Refused"
"HOL" (Holiday)
"Office"

At the bottom of the rota, the system should calculate:

Total driver pool available each day.
Total commitment (sum of "In", "NL1", NL2, NL3 & "Debrief" assigned shifts).
Routes scheduled (a field the administrator can edit).
Difference between total commitment and routes scheduled (automatically calculated).
Total count of each service type per day.
Additional Features

Driver Route Assignment Page

Separate page where administrators can:

Assign route numbers to each driver.
Assign the van number for that driver.
Send push notifications with route and van details to drivers.
Mobile Application
A mobile app that allows drivers to view their rota.
Push notifications for route and van assignments.
Secure login with email and password.
Security & Access Control
All users must log in with an email and password.
Role-based access control (RBAC) to ensure drivers can only view their own rota.
Data encryption for sensitive user information.
Technical Requirements

Weekly Performance Page

Separate page where administrators can:

Upload a file and this will extract data to predetermine fields with a scoring system.

Web Platform

Responsive web application (accessible via desktop and mobile browsers).
Authentication system for login (email & password).
Admin dashboard for full system control.
Database-backed rota system with real-time updates.
Mobile App
Native or hybrid mobile application (iOS & Android).
Push notification system to send route and van details to drivers.
Secure authentication with the same credentials as the web version.
Backend & Data Handling
Cloud-based database to store users, schedules, and routes.
Automated calculations for driver pool, commitments, and scheduling gaps.

We have examples of all data in excel that can be shared.