Next is **Overtime Approval Module**. This should sit between Attendance and Payroll: ```text Attendance ↓ Overtime Request ↓ Manager Approval ↓ HR Approval ↓ Payroll Calculation ↓ Payslip ``` This prevents staff from automatically getting paid for every extra hour and lets management approve overtime first. # SQL 1 — Overtime Requests ```sql CREATE TABLE overtime_requests ( id INT AUTO_INCREMENT PRIMARY KEY, employee_id INT NOT NULL, attendance_id INT NULL, overtime_date DATE NOT NULL, overtime_hours DECIMAL(10,2) NOT NULL, reason TEXT, manager_status ENUM( 'Pending', 'Approved', 'Rejected' ) DEFAULT 'Pending', hr_status ENUM( 'Pending', 'Approved', 'Rejected' ) DEFAULT 'Pending', created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ); ``` --- # Directory ```text overtime_management/ ├── overtime_request.php ├── overtime_request_script.php ├── overtime_approval.php ├── overtime_approval_script.php ├── overtime_reports.php ├── overtime_reports_script.php ``` --- # overtime_request_script.php ```php prepare(" INSERT INTO overtime_requests ( employee_id, overtime_date, overtime_hours, reason ) VALUES (?,?,?,?) "); $stmt->bind_param( "isds", $userId, $date, $hours, $reason ); $stmt->execute(); header( "Location:overtime_request.php?saved=1" ); exit; } ``` --- # overtime_request.php ```php Overtime Request

Overtime Request

Request submitted successfully.
``` --- # overtime_approval_script.php Supports: ```text Manager Approval HR Approval ``` ```php query(" UPDATE overtime_requests SET manager_status='Approved' WHERE id=$id "); } if( in_array( $userRole, ['hr','admin','superadmin'] ) ){ $conn->query(" UPDATE overtime_requests SET hr_status='Approved' WHERE id=$id "); } header( "Location:overtime_approval.php" ); exit; } $res = $conn->query(" SELECT o.*, e.name employee_name, d.name department FROM overtime_requests o LEFT JOIN employees e ON e.id=o.employee_id LEFT JOIN departments d ON d.id=e.department_id ORDER BY o.created_at DESC "); $requests=[]; while($row=$res->fetch_assoc()){ $requests[]=$row; } ``` --- # overtime_approval.php ```php Overtime Approval

Overtime Approval

Employee Department Date Hours Manager HR Action
Approve
``` --- # Payroll Integration Inside your `payroll_script.php` Replace the overtime section with: ```php $overtimeHours = 0; $overtimeQuery = $conn->query(" SELECT SUM(overtime_hours) total FROM overtime_requests WHERE employee_id = $empId AND manager_status='Approved' AND hr_status='Approved' AND MONTH(overtime_date)=$month AND YEAR(overtime_date)=$year "); if($row=$overtimeQuery->fetch_assoc()){ $overtimeHours = floatval($row['total']); } $overtimePay = $overtimeHours * floatval($emp['overtime_rate']); ``` Then: ```php $gross += $overtimePay; ``` --- # Add to Payslip Add rows: ```php Overtime Hours Overtime Pay ₦ ``` --- After Overtime Approval, your HR suite becomes: ```text ✓ Attendance ✓ Shift Scheduling ✓ Leave Management ✓ Payroll ✓ Payslips ✓ Salary Settings ✓ Loan Management ✓ Salary Advance ✓ Overtime Approval NEXT: ✓ Public Holidays ✓ Asset Assignment ✓ Performance Appraisal ✓ Employee Self Service Portal ✓ Payroll Approval Workflow ``` The next module after this should be **Public Holidays**, because it affects attendance, leave balances, overtime calculations, and payroll.