First create the salary table. ### SQL ```sql CREATE TABLE employee_salary ( id INT AUTO_INCREMENT PRIMARY KEY, employee_id INT NOT NULL UNIQUE, salary_type ENUM('monthly','daily','hourly') DEFAULT 'monthly', basic_salary DECIMAL(12,2) DEFAULT 0, overtime_rate DECIMAL(12,2) DEFAULT 0, tax_percent DECIMAL(5,2) DEFAULT 0, pension_percent DECIMAL(5,2) DEFAULT 0, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ); ``` --- # salary_settings_script.php ```php prepare(" INSERT INTO employee_salary ( employee_id, salary_type, basic_salary, overtime_rate, tax_percent, pension_percent ) VALUES (?,?,?,?,?,?) ON DUPLICATE KEY UPDATE salary_type = VALUES(salary_type), basic_salary = VALUES(basic_salary), overtime_rate = VALUES(overtime_rate), tax_percent = VALUES(tax_percent), pension_percent = VALUES(pension_percent) "); foreach ($_POST['employee_id'] as $empId) { $empId = intval($empId); $salaryType = $_POST['salary_type'][$empId] ?? 'monthly'; $basicSalary = floatval( $_POST['basic_salary'][$empId] ?? 0 ); $overtimeRate = floatval( $_POST['overtime_rate'][$empId] ?? 0 ); $taxPercent = floatval( $_POST['tax_percent'][$empId] ?? 0 ); $pensionPercent = floatval( $_POST['pension_percent'][$empId] ?? 0 ); $stmt->bind_param( "issddd", $empId, $salaryType, $basicSalary, $overtimeRate, $taxPercent, $pensionPercent ); $stmt->execute(); } $stmt->close(); header("Location: salary_settings.php?saved=1"); exit; } /* |-------------------------------------------------------------------------- | LOAD EMPLOYEES |-------------------------------------------------------------------------- */ $employees = []; $res = $conn->query(" SELECT e.id, e.name, d.name AS department FROM employees e LEFT JOIN departments d ON d.id = e.department_id ORDER BY e.name "); while($row = $res->fetch_assoc()){ $employees[$row['id']] = $row; } /* |-------------------------------------------------------------------------- | LOAD SALARIES |-------------------------------------------------------------------------- */ $salaries = []; $res = $conn->query(" SELECT * FROM employee_salary "); while($row = $res->fetch_assoc()){ $salaries[$row['employee_id']] = $row; } ?> ``` --- # salary_settings.php ```php Salary Settings

Salary Settings

Configure employee payroll information

Salary settings saved successfully.

Employee	Department	Salary Type	Basic Salary	OT Rate	Tax %	Pension %

``` ### Add to Sidebar ```php

💰 Salary Settings

🧾 Payroll

``` After this is working, the next file should be `payroll.php`, which will automatically calculate salaries from your attendance records and department schedules and generate monthly payroll.