Desk Booking System (RPS Group)

Designed and delivered an end-to-end desk booking system used by internal employees across all RPS Group offices in Ireland, replacing off-the-shelf, low-quality booking solutions with a structured, self-service platform.

Booking Engine:
• Full booking lifecycle — employees can browse available desks, create, amend, and cancel reservations with real-time availability checks and conflict prevention.
• Booking rules engine — configurable lead-time restrictions, maximum advance-booking windows, and per-office capacity limits enforced at the service layer.
• Calendar-aware scheduling — daily and weekly views, with at-a-glance occupancy indicators per floor and office zone.
• Email notifications — automated confirmation, reminder, and cancellation emails triggered via the queue system.

Floor Plan & Layout Planning:
• Interactive layout editor — office administrators can design and update floor plans visually, placing desks, labelling zones and assigning desk identifiers directly on the canvas.
• Zone management — floors divided into named zones (departments, teams, quiet areas), each independently configurable with capacity rules.
• Desk metadata — each desk carries a rich attribute set: adjustable height (standing desk), monitor count, accessibility requirements, and equipment notes.
• Publish & draft states — layout changes are held in draft until an admin publishes them, preventing disruption to live bookings.

Multi-Office Support & Role-Based Admin:
• Multiple offices — the system supports all RPS Group office locations as independent entities, each with its own floor plans, desk inventory, and booking rules.
• Office admin role — designated admins per office can edit their own layouts, manage desk availability, and review booking reports without access to other offices.
• Super-admin panel — central management view for cross-office reporting, user role assignment, and global configuration.
• Magic link authentication — passwordless login via tokenised email links, removing the need for password management entirely.
• Platform-managed roles — admin, office admin, and employee roles assigned and revoked directly within the platform, independent of any directory service.

Customisation:
• Per-office branding — each office location supports custom display names and floor identifiers to match internal naming conventions.
• Configurable desk attributes — attribute types are admin-definable (e.g. dual monitor, locker, near window, accessible) with no code changes required.
• Booking rules per desk or zone — specific desks or zones can be restricted to certain teams or user groups via role-checked policies.

Parking Spot Control (Planned — Partially Deployed):
• Parking bay inventory — data model and backend service layer built to represent bays per office site, bay types (standard, EV charging, accessible), and registration plate association.
• Reservation flow — booking logic mirroring the desk system implemented and tested; UI integrated into the employee dashboard in a feature-flagged state.
• Partial rollout — the backend and admin management screens were ready to be deployed; the employee-facing booking flow was held pending site survey sign-off across remaining offices.

Technology:
• PHP — Custom MVC backend handling booking logic, role enforcement, and layout state management.
• SQL Server — Relational schema with booking, desk, zone, floor, office, and parking tables; conflict checks implemented as server-side constraints and stored procedures.
• JavaScript, Bootstrap, jQuery — Responsive employee-facing UI and the canvas-based floor plan editor.
• Magic link auth — Passwordless, token-based email authentication with secure expiry and single-use enforcement.