TB Copters GmbH•Sep 2019 – Aug 2025•enterprise
TBCopters Employee Portal – Enterprise Workflow Management
Enterprise workforce operations, flight crew availability, and regulatory governance portal built for TB Copters GmbH to manage commercial drone pilots, administrative staff, and multi-tier flight operations.
Executive Overview & Key Engineering Deliverables
- 5-Tier RBAC Architecture: Granular role-segregated governance across Admin, Accountant, Pilot Manager, Assistant, and Drone Pilot tiers with OAuth2 token scopes and profile impersonation.
- Flight Availability & Scheduling: Interactive FullCalendar scheduler coordinating crew availability, mission assignments, and daily flight readiness rosters across regional hubs.
- Automated Document Pipeline: Server-side document engine compiling dynamic legal contracts, timesheets, and expense claims into digitally signed PDFs and Excel audits.
- Aviation Safety Governance: Enforces mandatory pre-flight Daily Safety Briefing MCQ examinations before pilots can be activated for commercial field operations.
LaravelVue.jsMySQLVuexBootstrapLaravel PassportAWS S3PhpSpreadsheetPhpWordFullCalendarREST APIPHPUnit
Multi-Role Tiers
5 RBAC Tiers
Contract Renewals
100% Annual
Payroll Lock
Dual-Lock Month
Safety Compliance
EASA / Daily
LIVE SYSTEM SIMULATION & INTERACTIVE PREVIEW
STATUS: ACTIVE WEBGL/SIMTB COPTERS EMPLOYEE PORTAL // ROLE-BASED WORKFORCE OPERATIONS
LARAVEL • VUE.JS • VUEX • BOOTSTRAPTB COPTERS EMPLOYEE PORTALVuex State: ADMIN
EMPLOYEE LIST & ANNUAL CONTRACT MANAGEMENT
| EMPLOYEE | CONTRACT STATUS | ADMIN ACTIONS |
|---|---|---|
J J. Weber TBC-0104 | Expires: 31 Dec 2025 | |
S S. Becker TBC-0219 | Expires: 31 Dec 2025 | |
K K. Schmidt TBC-0342 | ✓ Renewed for 2026 |
FULL-STACK SYSTEM ARCHITECTURE SPECIFICATION
CLIENT & UI TIER
- Vue.js Single-Page Application with modular role-segregated Vuex state stores.
- Vue Router with multi-role route guards, session validation, and authorized administrator profile impersonation.
- Interactive FullCalendar scheduler for flight crew availability (Available, If Required, Off-Duty) and safety exams.
- Responsive Bootstrap interfaces with dynamic flight operations and workforce analytics.
- vue-i18n dual-language localization seamlessly supporting German (de) and English (en).
API & REAL-TIME ENGINE
- Laravel REST API with OAuth2 authentication and custom role-based token scopes.
- 5-tier Role-Based Access Control (RBAC) middleware pipeline (Admin, Accountant, Pilot Manager, Assistant, Employee).
- Automated document compilation pipeline converting dynamic compliance contracts into digitally signed PDFs.
- High-performance spreadsheet generation engine producing formatted reports for working hours and expense audits.
- Mandatory Daily Safety Briefing pre-flight exam engine with dynamic question banks and automated score calculation.
DATA & INFRASTRUCTURE
- MariaDB / MySQL schema with UUID primary keys and strict foreign-key integrity.
- Dual-lock accounting governance mechanisms freezing monthly timesheets and expenses.
- Relational schemas for timesheets, expenses, pilot licenses, training records, and exam answer banks.
- Encrypted AWS S3 cloud storage with segregated bucket policies and strict access control lists (ACLs).
- Automated server-side receipt compilation and secure compressed archive bundling.
- Resilient background queue workers, automated task schedulers, and containerized Docker CI testing environments.
ROLE-BASED WORKFLOW SPECIFICATION (RBAC)
AdminPLATFORM GOVERNANCE
- ▸Search & view comprehensive employee list and inspect individual profiles
- ▸Renew employee contracts annually and upload custom working agreements
- ▸Configure factor multipliers, hours TBD, allocated days off, and salary models
- ▸Access assistant and accountant management pages & delegate system permissions
- ▸Manage Daily Safety Briefing question bank, exam time limits, and passing scores
AssistantOPERATIONS & FINANCE
- ▸View and audit employee work information, timesheets, and export Excel reports
- ▸Generate official monthly salary certificates and freeze payroll via dual-lock verification
- ▸Verify itemized expenses (Fuel, Hotel, Travel) and batch-download receipt ZIPs
- ▸Pilot Manager dispatch: monitor crew availability matrix via Ask/Agree workflows
- ▸Manage contract templates, pilot lists, permission files, and monthly summaries
EmployeePILOT & TECHNICIAN
- ▸Set up profile, tax details, university enrollment proof, and emergency contacts
- ▸Upload working hour information (timesheets) with automated weekly quota checks
- ▸Upload expense receipts, track reimbursement claims, and export spreadsheets
- ▸Take regulatory drone training Daily Safety Briefing MCQ examinations
- ▸Set flight availability on interactive calendar (Available, If Required, Off-Duty)
- ▸Manage drone pilot licenses, EASA certificates, GPS consent, and download salary slips
Key Technical Achievements
- 015-Tier RBAC Architecture: Role-segregated workflows for Admin, Accountant, Pilot Manager, Assistant, and Employee/Drone Pilot with granular role-based token scopes and authorized administrator profile impersonation.
- 02Aviation Safety & Daily Briefing Exams: Mandatory date-locked pilot safety examinations featuring dynamic question banks, countdown timers, and automated percentage scoring.
- 03Dual-Lock Payroll Governance: Dual-lock verification mechanisms freezing approved timesheets and itemized expenses, paired with automated monthly receipt archive bundling.
- 04Automated Document & PDF Compilation: Server-side document engine compiling dynamic legal agreements and compliance contracts into signed PDFs.
- 05FullCalendar Crew Availability Dispatch: Interactive calendar matrix allowing pilots to set availability states (Available, Available if Required, Off-Duty) with Pilot Manager "Ask" & "Agree" flight dispatch toggles.
- 06Financial Spreadsheet & Receipt Export: Automated tabular report generators creating styled financial workbooks for work hours and expenses alongside digital salary certificate delivery.
Measurable Impact & Production Verification
Saved ~25 administrative hours per week, automated 100% of annual contract renewals, and ensured seamless multi-role workforce operations across European flight teams.
Key Production Deliverables & Verification
5-Tier RBAC Scopes
Strict role-segregated authorization pipelines for Admin, Accountant, Pilot Manager, Assistant, and Drone Pilots.
Dual-Lock Payroll Governance
Dual-lock verification mechanisms freezing monthly timesheets and itemized expenses.
Headless Document Compilation
Server-side document compilation pipeline converting dynamic legal agreements to certified PDFs.
Daily Safety Briefing Gates
Date-locked pre-flight safety MCQ examinations with automated pass/fail scoring before flight dispatch.