Employee Controller Documentation

File: /controllers/employeeController.php

Purpose: Manages employee records, personal data, attendance systems, and employee lifecycle

Last Updated: December 19, 2024

Total Functions: 4

Lines of Code: ~986

---

📋 Overview

The Employee Controller is the core component for managing employee-related operations in the ERP system. It handles:

• • Creating and editing employee profiles
• • Managing employee personal information and documents
• • Setting up employee attendance systems and schedules
• • Tracking salary changes and employment history
• • Handling employee groups and subgroups
• • Managing employee documents and file uploads
• • Calculating salary-related metrics (minute costs, absence costs)
• • Branch-based employee access control

Primary Functions

• ✅ Create new employee profiles
• ✅ Edit existing employee data
• ✅ Delete employee records
• ✅ View employee listings with search
• ✅ Upload employee documents (contracts, ID cards, etc.)
• ✅ Set up weekly attendance schedules
• ✅ Calculate salary breakdowns and costs
• ✅ Track salary change history
• ✅ Manage employee groups and subgroups
• ✅ Branch-based employee filtering

Related Controllers

• • salaryReportController.php - Salary calculations and reports
• • EmployeeAttendanceController.php - Daily attendance tracking
• • employeePersonalController.php - Employee loans and advances
• • clientController.php - Customer management
• • supplierController.php - Supplier management
• • dailyentry.php - Accounting entries
• • accountstree.php - Chart of accounts

---

🗄️ Database Tables

Primary Tables (Direct Operations)

🔧 Key Functions

Main Controller Actions

Default Action (Show Add Form)

if (!isset($_GET['do'])) // Line 121

• • Purpose: Display employee add form with necessary data
• • Parameters: None (GET request)
• • Process Flow:

Show Employee List

elseif ($_GET['do'] == "show") // Line 167

• • Purpose: Display filtered list of employees
• • Parameters:

- txtSearch (string): Employee name search

- Branch filtering from session

• • Process Flow:

Edit Employee

elseif ($_GET['do'] == "edit") // Line 217

• • Purpose: Load employee data for editing
• • Parameters:

- id (int): Employee ID to edit

• • Security: Branch access validation
• • Process Flow:

Core Business Functions

add() Function

function add() // Line 289

• • Purpose: Create new employee with full data processing
• • Parameters (from $_POST):

- empName: Employee name (required)

- empSalary: Base salary amount

- empBouns: Bonus amount

- houseAllowance: Housing allowance

- transportationAllowance: Transport allowance

- noOfWorkDaysPerMonth: Working days per month

- noOfWorkHoursDaysPerDay: Working hours per day

- socialInsurance: Social insurance percentage

- workTax: Work tax percentage

- branchid: Branch assignment

- Multiple file uploads for documents

- Attendance schedule for 7 days

• • Return: Employee ID (int)

• • Process Flow:

• • Code Example:

// Salary cost calculations
$bast = $employee->employeeSalary + $employee->houseAllowance + $employee->transportationAllowance;
$makam = $employee->noOfWorkDaysPerMonth * $employee->noOfWorkHoursDaysPerDay * 60;
if ($makam != 0) {
    $employee->minuteLateCost = round(($bast / $makam), 3);
}

// Create accounting entries
$treeId1 = addTreeElement("سلفة $employee->employeeName", 63, 1, 0, 1);
$treeId2 = addTreeElement($employee->employeeName, 97, 1, 0, 1);

update() Function

function update() // Line 576

• • Purpose: Update existing employee with change tracking
• • Parameters: Similar to add() plus employeeId
• • Key Features:

- Salary change history tracking via savesalaryChangeRecord()

- Document update with old file cleanup

- Attendance schedule updates

- Accounting tree updates

• • Process Flow:

delete() Function

function delete() // Line 915

• • Purpose: Soft delete employee (mark as deleted)
• • Parameters:

- id (GET): Employee ID

- conditions (GET): Delete status

• • Process Flow:

savesalaryChangeRecord() Function

function savesalaryChangeRecord($employeeId, $oldSalary, $newSalary, $changeReason = '') // Line 941

• • Purpose: Track salary changes for audit purposes
• • Parameters:

- $employeeId (int): Employee identifier

- $oldSalary (float): Previous salary amount

- $newSalary (float): New salary amount

- $changeReason (string): Optional reason for change

• • Process Flow:

---

🔄 Business Logic Flow

Employee Creation Workflow

Salary Change Tracking

Cost Calculation Logic

Total Compensation = Base Salary + House Allowance + Transportation Allowance

Minute Late Cost = Total Compensation / (Work Days × Work Hours × 60 minutes)

Day Absence Cost = Total Compensation / (Work Days × Absence Days Factor)

---

⚠️ Common Issues

Known Bugs & Limitations

1. File Upload Issues

- Issue: Unlink operations may fail if files don't exist

- Location: Lines 640-727 in update()

- Impact: PHP warnings when updating documents

- Solution: Add file_exists() checks before unlink()

2. Duplicate Code

- Issue: Army photo upload duplicated

- Location: Lines 694-696 in update()

- Impact: Redundant processing

- Solution: Remove duplicate block

3. Missing Validation

- Issue: No validation for required fields in frontend

- Impact: Database errors if critical fields are empty

- Solution: Add proper validation before processing

4. Branch Security

- Issue: Branch filtering can be bypassed in some queries

- Location: Various query functions

- Impact: Users might see employees from other branches

- Solution: Ensure consistent branch filtering

PHP 8.2 Compatibility

1. Object Initialization

- All objects properly initialized before property assignment

- No "attempt to assign property on null" errors

2. Type Safety

- Proper float casting for numeric fields

- Safe array handling for POST data

---

🔗 Dependencies

Required Files

• • ../public/impOpreation.php - Core operations
• • ../public/config.php - Database configuration
• • ../public/include_dao.php - DAO includes
• • ../library/uploadImages.php - File upload handling
• • dailyentryfun.php - Daily entry functions

Required DAOs

• • EmployeeDAO - Main employee operations
• • EmployeeMySqlExtDAO - Extended employee queries
• • EmployeegroupDAO - Employee group management
• • EmployeesubgroupDAO - Sub-group management
• • EmployeepersonnelDAO - Employee history/transactions
• • UserDAO - User management
• • CountryDAO - Country lookup
• • ReligionsMySqlDAO - Religion lookup
• • YoutubeLinkDAO - Training video links

Related Controllers

• • Must work in coordination with attendance systems
• • Integrates with payroll processing
• • Links to accounting system through tree elements
• • Connects to branch-based security system

Template Files

• • employeeview/add.html - Add employee form
• • employeeview/edit.html - Edit employee form
• • employeeview/show.html - Employee listing
• • succes.html - Success message
• • error.html - Error message

Key HR Features

• • Salary Management: Base salary, allowances, bonuses tracking
• • Document Management: 15+ document types (contract, ID, passport, etc.)
• • Attendance Integration: 7-day schedule setup with flexible timing
• • Cost Calculations: Automatic minute and day absence cost computation
• • Change Tracking: Complete salary change audit trail
• • Branch Security: Multi-branch organization support
• • Group Management: Hierarchical employee categorization