Organizational Structure
A django-mptt tree for departments and units, with an interactive React Flow org chart for the multi-level structure.
Case · Personnel and Time Tracking System
Organization (NDA)
Personnel and Time Tracking System
Staff management system for personnel records and time tracking (NDA)
The case is published without the project name or interface screenshots under NDA. The description contains only general technical information.
About Product
A Personnel and Time Tracking System (NDA). It combines staff records, the organizational structure, timesheets, reports and integrations.
The system brings personnel records, timesheets and reporting together in 17 modules.
Technology Stack
Backend
Django 6, PostgreSQL, Row-Level Security, 200+ API endpoints
Frontend
React 19, TypeScript, React Flow
Infrastructure
Headless architecture, real-time WebSocket, PostgreSQL RLS
Integrations
Excel export, Google Sheets, WhatsApp messaging bot, report builder
~93KLines of Code
17Modules
60+Data Models
200+API Endpoints
Key Modules & Solutions
Organizational Structure
A django-mptt tree for departments and units, with an interactive React Flow org chart for the multi-level structure.
1 / 8Staff Management
Employee card, EAV field builder, and tracking for assignments, transfers, business trips and offboarding.
2 / 8Timetable
Timesheet with employee statuses, automatic filling, manual editing and Excel export.
3 / 8RBAC & Data Security
~30 granular permissions and 3-level data isolation with PostgreSQL Row-Level Security.
4 / 8Data Export
Excel export and Google Sheets integration for working with data outside the system.
5 / 8Reports and Messaging
Report builder, Excel export, Google Sheets integration and a WhatsApp bot for messaging.
6 / 8Real-time & Performance
WebSocket delivers changes between Django 6 and React 19 in real time.
7 / 8System Configuration
The EAV field builder and granular permissions configure the data structure and access.
8 / 8Staff Management
Employee card, EAV field builder, and tracking for assignments, transfers, business trips and offboarding.
Timetable
Timesheet with employee statuses, automatic filling, manual editing and Excel export.
RBAC & Data Security
~30 granular permissions and 3-level data isolation with PostgreSQL Row-Level Security.
Data Export
Excel export and Google Sheets integration for working with data outside the system.
Reports and Messaging
Report builder, Excel export, Google Sheets integration and a WhatsApp bot for messaging.
Real-time & Performance
WebSocket delivers changes between Django 6 and React 19 in real time.
System Configuration
The EAV field builder and granular permissions configure the data structure and access.
Architecture & Security
The headless architecture combines Django 6 as the API backend with React 19 and TypeScript. WebSocket delivers real-time changes, while 3-level data isolation includes PostgreSQL RLS.
Frontend
React 19TypeScriptReact Flow
WebSocket
API
Headless architecture200+ endpoints
Backend
Django 6WebSocket real-time
Data Layer
PostgreSQL + RLS60+ data models
3 Levels of Data Isolation
1
Application
Granular roles and permissions
2
API
Access checks for API endpoints
3
PostgreSQL RLS
Row-Level Security at the data layer
What Was Done
The work covered a headless architecture with Django 6, React 19 and TypeScript, a PostgreSQL data model with RLS, real-time WebSocket, reports and integrations.
17 System Modules
Organizational Structure
Department Tree
React Flow Org Chart
Employee Cards
Custom Field Builder
Headcount and Staffing
Position Categories
Assignments and Transfers
Offboarding
Timesheet
Real-Time Updates
Roles and Permissions
Data Isolation
Report Builder
Excel Export
Google Sheets Integration
WhatsApp Messaging
Frequently Asked Questions
The headless platform uses Django 6, React 19, TypeScript, PostgreSQL with RLS and real-time WebSocket updates.
The system combines ~30 granular permissions with 3-level data isolation and PostgreSQL Row-Level Security.
The platform includes 17 modules, ~93K lines of code, 60+ data models and 200+ API endpoints.
Yes, Artbrain specializes in custom HRM/ERP system development. We can build a tailored solution based on your organization's specific requirements. Contact us to discuss your project.
Start your journey to success
Have a project? Let's bring it to life together.
Need a similar Personnel and Time Tracking System, ERP or custom system? Tell us about your task, and we will prepare an estimate.
