Securex - CCTV & Security Service Management System
End-to-end security service booking, slot conflict prevention, and invoice generation system.
My Role
Developer
Category
Field Work / Industrial Training Project
Timeline / Date
June 2026
Supervisor
Zahid Hasan Rabbi, Lecturer
01 / The Problem
The Operational & Engineering Challenge
Local security and CCTV service providers frequently face operational friction caused by manual phone reservations, technician double-booking conflicts, handwritten receipts, and delayed billing cycles. Without a centralized digital platform, clients experience scheduling uncertainty and businesses suffer revenue leakage.
02 / The Solution
Architecture & System Implementation
Engineered a full-stack Laravel MVC platform with MySQL relational schema design. The platform introduces an algorithmic conflict-aware time-slot booking engine that eliminates overlapping reservations, pairs client self-service with administrative oversight, and automates transactional email delivery and dynamic PDF invoice generation.
03 / Platform Showcase
Securex CCTV & Security Platform Showcase
Public-facing product showcase offering direct access to security services, booking consultations, and customer quote requests.
04 / Key Features
Core System Capabilities & Workflows
Email and password authentication
Feature 01
Google OAuth 2.0 authentication
Feature 02
Role-based administration (Admin & Client)
Feature 03
Dynamic service CRUD operations
Feature 04
Client service booking
Feature 05
Administrative booking review
Feature 06
Booking status updates
Feature 07
Automated email notifications
Feature 08
PDF invoice generation and delivery
Feature 09
Time-slot conflict detection
Feature 010
Alternative available-slot recommendations
Feature 011
Duplicate-booking prevention
Feature 012
05 / System Overview & Dashboard
Securex Control Room & Service Admin Panel
Comprehensive administrator control center displaying live booking review queues (8 pending reviews), active service metrics (16 active services), and customer inbox communications.
06 / Service Management Workflow
Security Service Management & Operational Workflow
Administrative operations interface for configuring security service offerings (CC Camera, Video Surveillance, Fingerprint Access Control, Fire Alarm), updating pricing, and managing lifecycle statuses.
08 / Engineering Contribution
My Specific Role & Responsibilities
Full Stack Developer responsible for end-to-end system architecture, relational database design, Laravel MVC backend implementation, Google OAuth 2.0 authentication, conflict detection algorithms, and automated PDF invoice generation.
09 / Technology Architecture
Full-Stack Technology Decisions
Backend & APIs
- Laravel
- PHP
- Laravel MVC
- Laravel Sanctum
Frontend & UI
- Blade Templates
- Tailwind CSS
- JavaScript
- HTML5
Database Layer
- MySQL
- Eloquent ORM
- Relational Schema (3NF)
Integrations & Tools
- Google OAuth 2.0
- SMTP Mailer
- PDF Generation
- Git & GitHub
10 / Data Layer
Database Architecture & Relational Schema
Structured around a normalized 3NF relational schema that maintains strict referential integrity across users, roles, services, time-slots, bookings, and transactional invoices.
Key Relational Entities
- users: Stores client and administrative accounts with role identification
- services: Catalogs security service types, standard pricing, and durations
- time_slots: Manages available technician scheduling windows
- bookings: Links clients, services, and time-slots with status workflows
- invoices: Generates immutable billing records linked to completed bookings
Schema Design Principles
- Foreign key constraints ensuring automatic cascade integrity
- Indexed lookup columns on booking_date and service_id for instant slot queries
- Transactional database operations to prevent partial or duplicate reservations
11 / System Flow
API Architecture & Data Flow Lifecycle
Follows a structured controller-service pattern where all booking requests pass through middleware validation, concurrency checks, and automated notification triggers.
12 / Problem Solving
Engineering Challenges & Technical Solutions
Challenge 01
Handling simultaneous booking attempts for the same technician time slot without creating duplicate reservations.
Engineered Solution:
Implemented database-level transaction locks (DB::transaction) and pre-commit conflict queries that verify slot availability before committing booking records.
Challenge 02
Providing frictionless client onboarding while maintaining secure role-based administrative control.
Engineered Solution:
Integrated Google OAuth 2.0 single sign-on alongside email authentication, paired with middleware that automatically assigns and routes roles upon login.
13 / Result & Verification
Project Delivery & Technical Achievements
Successfully completed and verified during industrial field work under university faculty supervision. Published as a formal technical report on Zenodo with registered DOI.
- Verified in industrial training project evaluation
- Published technical report on Zenodo (DOI: 10.5281/zenodo.21893082)
- Open-source codebase maintained on GitHub