Back to projects
System PHP / MVC SQL Server jQuery 2024

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

Enterprise Resource Planning System

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.
Human Resources and Employee Profile

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.
Payroll and Accounting Modules

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.

Ready to start?

Got a similar project?

I'm available for new projects. Tell me about what you're building and let's see if we're a good fit.

Start a project →