prepare('UPDATE users SET branch = ? WHERE id = ?'); if ($stmt->execute([$branch, $_SESSION['user_id']])) { $branch_update_message = 'Branch updated successfully! Refreshing...'; // Redirect to refresh the page and clear POST data header("Refresh: 2; url=index.php"); } else { $branch_update_message = 'Error updating branch.'; } } } // Get user info $stmt = $pdo->prepare('SELECT username, branch FROM users WHERE id = ?'); $stmt->execute([$_SESSION['user_id']]); $user = $stmt->fetch(PDO::FETCH_ASSOC); $username = $user['username'] ?? 'User'; $branch = $user['branch'] ?? null; $current_role = current_user_role(); ?> <?php echo htmlspecialchars($_SERVER['PROJECT_NAME'] ?? 'GeoVerify'); ?>

Set Your Branch

Please set your branch to continue.

Dashboard

Welcome, ! You are logged in as a from the branch.

Visits by Status

prepare('SELECT status, COUNT(*) as count FROM visits WHERE user_id = ? GROUP BY status'); $stmt->execute([$_SESSION['user_id']]); ?> query("SELECT u.branch, u.username, COUNT(v.id) AS visit_count FROM visits v JOIN users u ON v.user_id = u.id WHERE u.branch IS NOT NULL AND u.role_id = (SELECT id FROM roles WHERE name = 'Loan Officer') GROUP BY u.branch, u.username ORDER BY u.branch, u.username"); $visits_by_officer = $stmt->fetchAll(PDO::FETCH_GROUP | PDO::FETCH_ASSOC); ?>

Visits by Branch and Loan Officer

No visits recorded yet.

$officers): ?>

  • visits