Enterprise Resource Planning (ERP)
A comprehensive enterprise resource planning system managing HR, occupational health, payroll, electronic billing, accounting, and quality management.
Platform
Web Application
Role
Full Stack Developer
Architecture
MVC
Status
Completed / Active
Overview
This document details the comprehensive suite of modules that make up the custom ERP solution, designed to orchestrate the core operations of a business. It encompasses human resources, occupational health, payroll, billing, accounting, and quality assurance.
Core Application Modules
1. Human Resources Management System (SARH)
The central hub for comprehensive talent management:
- Recruitment & Selection: Complete flow from prospect creation to applicant selection, including psychological and technical tests.
- Employee Management: Extensive employee profiles capturing work experience, academic background, and entry documentation.
- Hiring & Termination: Seamless onboarding and offboarding processes tracking reasons and status.
- Attendance & Updates: Timestamp registrations, leave permissions, and payroll-related novelties.
- Occupational Health & Performance: Pre-employment medical exams, home visits, and performance evaluations.
2. Occupational Safety and Health (SST)
Dedicated to managing workplace risks and physical wellbeing:
- Disabilities: Registration and control of medical disabilities, tracking types and status.
- Health Conditions: Detailed tracking of worker health, identifying origins, restrictions, and current states.
- SST Visits: Scheduling and logging of workplace safety visits.
- Risk Matrix: Identification and management of workplace risk factors across different roles.
Comprehensive employee profiles and talent management interfaces.
3. Payroll Processing
- Payroll Settlement: Regular calculation and management of worker payments.
- Electronic Payroll (DIAN integration): Direct integration for generating and transmitting electronic payroll to government tax authorities, including concept parameterization and complex calculation formulas.
4. Client Companies (Outsourcing/Temp Management)
- Client Management: Registration of companies, associated subsidiaries, and multiple branch locations.
- Configuration Sheets per Company: Individual parameterization per client for hiring, billing, payroll, and selection processes.
- Order Management: Handling personnel requests and staffing orders from client companies.
5. Accounting & Billing
- Billing & Collections: Generation of invoices and tracking of other billable items.
- Electronic Invoicing: Full electronic billing module with automated dispatches and compliance with national tax authority standards.
- Treasury: Bank configurations, payment methods, and payment schedules.
- General Ledger: Reporting and tools for general corporate accounting.
6. Quality Management & KPIs
- Non-Conformities: Tracking and controlling non-conforming products or services.
- Continuous Improvement: Management of corrective/preventive actions and continuous improvement plans.
7. Telephony Integration
- Call Control: Logging and classification of phone interactions, useful for recruitment processes, client attention, or worker follow-ups.
Billing, accounting, and electronic payroll generation.
Technology Stack
The application is built on a classic client-server architecture utilizing a custom MVC pattern.
Backend
- Language & Architecture: PHP via a custom MVC structure (controller, model, view directories).
- Document Generation: TCPDF for dynamic PDF documents (reports, certificates).
- Data Processing: PhpSpreadsheet for Excel file manipulation and PHPMailer for robust email delivery.
- API Integration: Guzzle HTTP client for external API consumption (e.g., electronic billing and payroll).
Frontend
- Framework: AdminLTE and Bootstrap ecosystem utilizing HTML5, CSS3, and JavaScript.
- Interactivity: jQuery, jQuery UI, DataTables for advanced data grids, and Select2 for dynamic comboboxes.
- Data Visualization: Chart.js, Flot, and Morris.js for reports and visual indicators.
- Components: Bootstrap Datepicker, Inputmask, FullCalendar, and CKEditor.
Database
- Engine: Microsoft SQL Server with localized backup strategies.
Interested in learning more about this project? Get in touch with me to discuss custom system development.