The next major module after ESS is **Performance Management / Appraisal System**.
I would build it as:
```text
performance/
│
├── appraisal_dashboard.php
├── appraisal_periods.php
├── kpi_setup.php
├── employee_appraisal.php
├── manager_review.php
├── hr_review.php
├── appraisal_reports.php
├── my_appraisals.php
```
Before I generate all the copy-paste-ready files, we need the database tables because this module is much more data-driven than ESS.
Run these SQL statements first:
```sql
CREATE TABLE appraisal_periods (
id INT AUTO_INCREMENT PRIMARY KEY,
title VARCHAR(255),
start_date DATE,
end_date DATE,
status ENUM('Open','Closed') DEFAULT 'Open',
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);
CREATE TABLE performance_kpis (
id INT AUTO_INCREMENT PRIMARY KEY,
department_id INT,
kpi_name VARCHAR(255),
max_score INT DEFAULT 5,
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);
CREATE TABLE employee_appraisals (
id INT AUTO_INCREMENT PRIMARY KEY,
period_id INT,
employee_id INT,
self_score DECIMAL(5,2) DEFAULT 0,
manager_score DECIMAL(5,2) DEFAULT 0,
hr_score DECIMAL(5,2) DEFAULT 0,
self_comment TEXT,
manager_comment TEXT,
hr_comment TEXT,
status ENUM(
'Pending Self Review',
'Pending Manager Review',
'Pending HR Review',
'Completed'
) DEFAULT 'Pending Self Review',
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);
CREATE TABLE appraisal_scores (
id INT AUTO_INCREMENT PRIMARY KEY,
appraisal_id INT,
kpi_id INT,
self_score INT DEFAULT 0,
manager_score INT DEFAULT 0,
hr_score INT DEFAULT 0
);
```
After creating these tables, I can generate:
* `appraisal_dashboard.php`
* `appraisal_periods.php`
* `kpi_setup.php`
* `employee_appraisal.php`
* `manager_review.php`
* `hr_review.php`
* `appraisal_reports.php`
* `my_appraisals.php`
with the complete Tailwind UI, approval workflow, KPI scoring, performance reports, promotion recommendations, and salary increment recommendations.
Since that is about 1,500–2,000 lines of code, it's best to generate the files one by one after the tables exist so the code exactly matches your schema.
---------------------------------------------------------------
query("
SELECT COUNT(*) total
FROM appraisal_periods
")->fetch_assoc()['total'];
$totalOpen = $conn->query("
SELECT COUNT(*) total
FROM appraisal_periods
WHERE status='Open'
")->fetch_assoc()['total'];
$totalAppraisals = $conn->query("
SELECT COUNT(*) total
FROM employee_appraisals
")->fetch_assoc()['total'];
$totalCompleted = $conn->query("
SELECT COUNT(*) total
FROM employee_appraisals
WHERE status='Completed'
")->fetch_assoc()['total'];
?>
Performance Dashboard