Role: Lead Full Stack Developer & System Architect
Tech Stack: Python (Flask), MS SQL Server, SQLAlchemy, JavaScript (ES6+), HTML5/CSS3, OpenCV (EasyOCR), Telegram API, Chart.js, FullCalendar.
Scale: 300+ Active Users | Multi-Department Integration | Real-time Data Processing
A comprehensive, custom-built ERP ecosystem designed for a high-volume, Full-Cycle Automotive Service Center. Unlike generic off-the-shelf solutions, this system was engineered to cover specific "blind spots" in the complex automotive workflow, providing seamless synchronization across all operational departments—from Diagnostics, Repair, and Detailing to Parts Logistics, HR, and Rental Fleet.
The system features a modular architecture using Flask Blueprints, ensuring scalability and ease of maintenance. A key architectural decision was the "Low-Code Admin" approach, allowing managers to modify business logic, task workflows, and system configurations without deploying code updates.
The heart of the system is a flexible task management core.
State Machine Logic: Tasks are not static; they follow complex life cycles. Status changes can trigger automated sub-tasks for other departments.
No-Code Workflow Editor: Administrators can build new task types, define branching logic, and add custom data fields via a UI Constructor, dynamically altering the database structure.
Collaboration: Integrated chat, file attachments (drag-and-drop), and history tracking within every task ticket.
A mobile-first interface designed for service advisors working on the shop floor.
Computer Vision Integration: Built-in License Plate Recognition (LPR) using OpenCV and EasyOCR. The system analyzes the camera stream, detects UA-standard plates, and instantly pulls up the vehicle's service history from the ERP.
Media Pipeline: optimized upload of photos/videos of vehicle damage directly from mobile devices to the central server.
A dedicated Statistics Blueprint that processes raw SQL data into actionable business insights.
Gamification & KPIs: Real-time "Best Employees" leaderboards based on closed hours/sales, fostering competition among managers and mechanics.
Financial Reports: Automated calculation of turnover, net profit per department, and margin analysis.
Visual Dashboards: Interactive charts (using Chart.js) for visualizing income trends.
The system goes beyond standard CRM features to support niche business units:
Rental Fleet Control: A Gantt-chart style timeline for managing car rentals. Visualizes booking overlap, car availability, and maintenance windows.
Tyre Hotel & Sales: A separate module Tyres for the tyre storage warehouse. Features a custom mobile form for logging tyre condition (tread depth, brand) and generating Telegram reports with photo evidence.
Promotions: A module for tracking marketing campaigns and manager performance in selling specific service packages.
A background multi-threaded scheduler Reminder ensures the system runs proactively.
Telegram Ecosystem: Deep integration with Telegram Bots to send personal notifications about task deadlines, new assignments, and system alerts.
HR Automation: The system automatically tracks employee birthdays (sending alerts to HR) and manages vacation substitutions.
Health Checks: Self-diagnosing scripts that monitor database connectivity and API integrations.
Designed to give total control to the product owner.
Global Configuration: Critical system parameters (API keys, timeout limits, UI text) are managed via a key-value config interface.
RBAC (Role-Based Access Control): Granular permission system protected by custom Python decorators, allowing dynamic assignment of access rights to different modules.
Vacation & Substitution Logic: When an employee goes on vacation, the system automatically re-routes their incoming tasks to a designated substitute.
Modular Architecture: The application is split into independent Flask Blueprints (Core, Tyres, Statistics), making the codebase clean and maintainable.
Robust Database Layer: A custom SQLAlchemy wrapper ensures secure, parameterized SQL execution with detailed audit logging.
Asynchronous Operations: Heavy tasks (like report generation or mass notifications) are handled in background threads to keep the UI responsive.
Security First: Implementation of CSRF protection, secure session management, and input sanitization against SQL injection.
Description: The Core Interface: A comprehensive tour of the system's main capabilities.
Smart Calendar & Filtering: Demonstrating the ability to switch between time periods (Day/Week/Month) and view modes, coupled with powerful filtering to navigate through active tasks.
Deep Task Architecture: The video reveals the internal structure of a task, showing its Multi-Stage Journey between departments. It highlights key interactions: approving stages, rejecting tasks with mandatory comments/attachments, and the "Resume" functionality for adapting to changing circumstances.
Flexible Assignment Logic: Showcasing advanced distribution models—from "Department Pools" (where any team member can claim a task) to Direct Delegation, where Department Heads can reassign tasks to specific subordinates.
User Profile: A look at personal customization, enabling users to update contact details and manage their avatars.
Description: Mobile-First Experience: A walkthrough of the fully responsive interface designed for staff on the move. Every page adapts perfectly to smartphones, allowing seamless workflow management from the shop floor.
Mass Notification Center: The demo highlights a powerful communication module. Managers can broadcast targeted messages to specific departments (e.g., "To: Parts Dept & Mechanics") directly via Telegram bots. The system supports file attachments, allowing users to send documents or photos to the entire team in one click.
Smart Calendar Filtering: To ensure usability on small screens, the video demonstrates the Advanced Filtering System. Users can instantly filter the global calendar by specific departments or task types, isolating only the relevant events needed for their current shift.
Description: Defining Business Processes: A demonstration of the system's "God Mode," where administrators create and configure different Task Types (e.g., "Diagnostics", "Parts Ordering", "Warranty Claim"). For each type, a unique workflow is built via a visual interface.
Flexible Stage Logic: The video shows how to build a chain of execution steps. Admins can set up Parallel Stages involving multiple departments (where the process is blocked until all confirm) or simple sequential steps.
Advanced Routing: Demonstrating the assignment rules: stages can be open to a "Department Pool" (any employee) or restricted strictly to Department Heads.
Conditional Branching: A key feature shown is Scenario-Based Workflows. Admins can configure stages to appear only if specific conditions are met (e.g., "If Warranty = True"), creating dynamic paths for the same task type.
Custom Field Builder: How the admin defines the input data for each task type: adding mandatory or optional fields (Text, Selectors, File Uploads, Departments, Project, Position) that the author must fill out to launch the process.
Description: Global Connectivity: A showcase of the system's modular architecture and utility tools available from any page.
Interactive Employee Directory: A rich modal window acting as the company's internal phonebook. It features smart filtering (by Name, Department, or Project) and direct action buttons, allowing users to call or open a Telegram chat with any colleague instantly.
Communication Hub: A dynamic menu listing all internal Telegram channels and bots accessible specifically to the current user based on their role.
AI-Powered Vehicle Search: A universal search module where users can retrieve full car history not just by text (VIN/Plate number), but also by uploading a photo. The system uses the integrated Computer Vision library to recognize the plate and pull data from the ERP.
Description: Command Center for Owners: A fully dynamic statistics page aggregating critical business data.
Granular Financial Metrics: The dashboard breaks down Total Profit and Department-specific revenue with a 12-month retrospective.
Interactive Widgets: Unlike standard dashboards, each metric card allows independent period filtering, enabling managers to compare different timelines simultaneously.
Visual Benchmarking: Every card features built-in graphs showing yearly trends and automatically compares current figures against the historical "Best Month" record.
Key Indicators: Tracking Average Ticket (Check) size across projects and integrating live Social Media statistics.
Top Performers: A dedicated section highlighting the Best Managers based on real-time performance data.
Part 2: Engineering Highlights
Snippet 1: Universal API & Date Logic
Description: API Request Generator: A universal utility designed to construct precise API query strings. It handles the logic of Start/End Date Selection and Normalization, automatically converting various input formats and presets (e.g., "Current Month", "Year") into the standardized format required for data retrieval.
Snippet 2: Role-Based Access Control (RBAC)
Description: Security Architecture: A custom Python decorator serving as the system's intelligent gatekeeper.
Granular Permissions: Unlike simple role checks, this system validates specific access keys loaded from a dynamic configuration, allowing fine-tuned control over every route.
Context-Aware Redirection: Instead of showing a generic "403 Access Denied" error, the logic identifies the user type and automatically redirects them to their appropriate dashboard (e.g., routing an office "TV User" directly to the Statistics Board).
Superuser Bypass: Efficiently handles override logic for high-level admins (Editors/Developers).
Snippet 3: Universal Secure Database Wrapper
Description:The Core Abstraction Layer: A highly versatile function designed to handle all types of database interactions (SELECT, INSERT, UPDATE, DELETE) through a single, secure interface.
Universal Usage: It adapts to different query types and parameter formats (lists, dicts, tuples), eliminating the need for repetitive boilerplate code across the app.
Security First: It implements strict parameter binding, automatically converting raw inputs into safe named parameters to guarantee protection against SQL Injection.
Robustness: The wrapper manages transaction lifecycles (commit/rollback) and ensures that every database action is logged for audit purposes.