The Objective
As the client base and product offerings expanded, managing subscriptions, licenses, and external integrations manually became a bottleneck. The goal was to build BOS Admin: a robust, centralized internal back-office SaaS. It needed to provide operators and the support team with a unified interface to handle everything from contact details and invoicing to complex multi-tiered subscription limits and per-client database connections.
System Architecture & Tech Stack
The application was engineered for reliability, security, and data integrity, utilizing a traditional but highly optimized backend structure.
- Backend: PHP 8 utilizing PDO and prepared statements for secure, high-performance data handling.
- Database: PostgreSQL, handling complex relational data, cascade rules, and external client database connections.
- Frontend: A custom Bootstrap UI with a modern, component-driven approach (SCSS), utilizing JavaScript/AJAX for dynamic form loading and asynchronous updates without page reloads.
Core Features & Workflows
- Comprehensive Client Management: A deep CRM module tracking company data, network memberships, and secure credential storage. It features an intelligent algorithm that automatically handles retail clients by generating synthetic Tax IDs (AFM) to maintain database consistency.
- Advanced Subscription & Product Control: Operators can assign and upgrade pricing tiers (e.g., Business Starter, Pro) on the fly. The system automatically calculates license limits, module access, and expiration dates.
- Automated Serial Number Generation: Every purchase automatically generates a unique, traceable cryptographic serial number bound to the client’s ID and product choice, ensuring strict license enforcement.
- Network & Circuit Routing: Visual management of various digital “circuits” (Κυκλώματα) and subnets, allowing administrators to route clients to specific microservices (e.g., MYDATA, ERGANI, GoFleet).
- Automated Housekeeping: Background routines systematically clean up stale notifications and audit active subscriptions, ensuring the dashboard data is always real-time and accurate.
The Result
BOS Admin successfully unified a fragmented administrative workflow into a single source of truth. By automating license generation, standardizing database configurations, and providing deep analytics right on the dashboard, the operations team can now scale the SaaS business without administrative friction.
