Gestion Du Pointage
Back to home details

Employee Attendance Management System

Problem

• Manual attendance tracking is time-consuming and error-prone
• Excel spreadsheets are difficult to manage at scale
• Multi-shift management complexity (4h, 6h, 8h, 12h shifts)

Our Solution

• Automated Excel import with intelligent column detection
• Dynamic formula engine for accurate time calculations
• Complete audit trail tracking all changes
• Multi-shift support with department configurations
• Professional PDF reports (Fiche de Présence)

About

Gestion Du pointage a desktop Employee Attendance Management System designed for enterprises that need to track work hours, and manage complex shift schedules. Built with Python and PyQt5, it offers a powerful desktop experience with enterprise-grade features.

The system is particularly well-suited for manufacturing companies, service industries, and organizations with shift workers who need detailed tracking of regular hours, overtime (supplementary hours), and recovery time.

The application allows users to:

• Track employee attendance with automated Excel import
• Calculate work hours using customizable formulas
• Process salaries and payroll with category-based pricing
• Manage overtime (supplementary hours +25%, +50%)
• Track recovery hours and leave management
• Generate Fiche de Présence (professional attendance sheets)
• Import/export Excel files with smart column mapping
• Create PDF reports with company branding

Core Features

Employee Attendance Tracking:

• Automated Excel Import: Intelligent parser with column auto-detection
• Time Entry Management: In/out times with automatic calculations
• Shift Support: 4h, 6h, 8h, 12h shift configurations
• Month Detection: Automatic detection and dynamic table creation
• Duplicate Prevention: File hash checking to avoid re-imports

Work Hours Calculation:

• H. Travaillées (Total Hours Worked)
• H. Normales (Regular Hours)
• H. Réelles (Actual Hours)
• H. Récup (Recovery Hours)
• H. Supp1 (Supplementary +25%)
• H. Supp2 (Supplementary +50%)
• Pause (Break time)
• Accumulé (Weekly/monthly accumulation)

Overtime Management:

• Supplementary Hours Type 1: +25% rate calculation
• Supplementary Hours Type 2: +50% rate calculation
• Day Mode: Daily overtime calculation
• Week Mode: Weekly overtime aggregation
• Custom Formulas: Tag-based dynamic formulas

Recovery Hours Tracking:

• Hours to Days Conversion: Automatic conversion for leave
• Transaction Tracking: Earned vs. consumed tracking
• Balance Management: Real-time balance calculations
• Leave Integration: Integration with leave management

Attendance Sheet Generation (Fiche de Présence):

• Professional PDF Generation: A4 format with company branding
• Company Logo Support: Include logo with transparency
• Print Preview: Review before printing
• Batch Processing: Generate for multiple employees
• Customizable Layout: Headers, footers, company details

Technical Summary

Programming Languages:

• Python 3.x (Primary language)
• SQL (Database queries)
• JavaScript (UI enhancements)

Frameworks & Libraries:

• PyQt5 5.15.0+ (Desktop GUI framework)
• SQLAlchemy 1.4.0+ (ORM layer)
• PostgreSQL 13-17 (Primary database)
• SQLite 3.x (Offline database)
• Pandas 1.3.0+ (Data processing)
• OpenPyXL 3.0.0+ (Excel operations)
• ReportLab 4.4.1 (PDF generation)
• XlsxWriter (Excel export)
• Cryptography 3.4.0+ (Security/Encryption)

System Architecture:

Desktop Application (PyQt5)
├── Employee Management
├── Attendance Tracking
├── Fiche de Présence Generation
├── Import/Export System
├── Reporting System
└── User Interface

Project Advantages

Business Advantages:

• Time Savings: Automated Excel import saves 20+ hours/month

Technical Advantages:

• Modular Architecture: Well-structured, maintainable codebase
• Connection Pooling: Singleton pattern for optimal performance
• Dynamic Table Creation: Automatic month-specific table generation
• Safe Formula Evaluation: Tag-based calculation system
• Change Tracking: Complete audit trail with who/when/what
• License Protection: AES-encrypted license keys

© 2025 W2DS