connect_error) {
die("Connection failed: " . $conn->connect_error);
}
// Fetch distinct evaluation dates from the evaluations table and order them
$sql = "SELECT DISTINCT evaluation_date FROM evaluations ORDER BY evaluation_date";
$result = $conn->query($sql);
$dates = array();
while ($row = $result->fetch_assoc()) {
$dates[] = $row['evaluation_date'];
}
// Fetch distinct employee names from the evaluations table
$sql = "SELECT DISTINCT employeeName FROM evaluations";
$result = $conn->query($sql);
$employeeNames = array();
while ($row = $result->fetch_assoc()) {
$employeeNames[] = $row['employeeName'];
}
$conn->close();
?>
Evaluation Data
Employee Evaluation Data
| Employee Name |
|
Total |
Score |
Detail |
|
query($sql);
$totalScore = $result->fetch_assoc()['total_score'];
$totalSumForRow += $totalScore;
$conn->close();
?>
|
|
9) {
$scoreClass = 'green';
} elseif ($score > 6 && $score < 9) {
$scoreClass = 'yellow';
} elseif ($score > 5.009 && $score < 8) {
$scoreClass = 'orange';
}
?>
|
View Details |