prepare("SELECT id, agent_name, amount, description, status, created_at FROM expense_reports WHERE agent_name = ? ORDER BY created_at DESC");
$stmt->execute([$agent_name]);
$reports = $stmt->fetchAll(PDO::FETCH_ASSOC);
} catch (PDOException $e) {
// For a real app, log this error instead of displaying it
die("Database error: " . $e->getMessage());
}
}
function getStatusBadgeClass($status) {
switch ($status) {
case 'Approved': return 'badge-approved';
case 'Rejected': return 'badge-rejected';
case 'Pending':
default:
return 'badge-pending';
}
}
require_once 'includes/header.php';
?>
No Agent Selected
Please go to the main dashboard and click on an agent's name to see their reports.
No Reports Found
This agent has not submitted any expense reports yet.
Submit First Report
| Agent |
Date |
Amount |
Description |
Status |
|
|
$ |
|
|