93 lines
3.1 KiB
PHP
93 lines
3.1 KiB
PHP
<?php
|
|
require_once 'header.php';
|
|
require_once 'db/config.php';
|
|
|
|
// Fetch stats from the database
|
|
$pdo = db_connect();
|
|
|
|
$counts = [
|
|
'properties' => 0,
|
|
'agents' => 0,
|
|
'owners' => 0,
|
|
'clients' => 0,
|
|
'transactions' => 0
|
|
];
|
|
|
|
try {
|
|
$counts['properties'] = $pdo->query('SELECT count(*) FROM properties')->fetchColumn();
|
|
$counts['agents'] = $pdo->query('SELECT count(*) FROM agent')->fetchColumn();
|
|
$counts['owners'] = $pdo->query('SELECT count(*) FROM owner')->fetchColumn();
|
|
$counts['clients'] = $pdo->query('SELECT count(*) FROM clients')->fetchColumn();
|
|
$counts['transactions'] = $pdo->query('SELECT count(*) FROM transactions')->fetchColumn();
|
|
} catch (PDOException $e) {
|
|
// If the tables don't exist yet, we can just show 0.
|
|
// On a real site, you would log this error.
|
|
}
|
|
|
|
?>
|
|
|
|
<div class="px-4 py-5 my-5 text-center">
|
|
<h1 class="display-5 fw-bold">Admin Dashboard</h1>
|
|
<div class="col-lg-6 mx-auto">
|
|
<p class="lead mb-4">Welcome to the Real Estate Management System. Here you can manage properties, clients, and transactions.</p>
|
|
</div>
|
|
</div>
|
|
|
|
<div class="row">
|
|
<!-- Properties Card -->
|
|
<div class="col-md-4 col-lg mb-4">
|
|
<div class="card h-100">
|
|
<div class="card-body text-center">
|
|
<h5 class="card-title">Total Properties</h5>
|
|
<p class="stat-number"><?php echo $counts['properties']; ?></p>
|
|
<a href="properties.php" class="btn btn-primary">Manage</a>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
|
|
<!-- Agents Card -->
|
|
<div class="col-md-4 col-lg mb-4">
|
|
<div class="card h-100">
|
|
<div class="card-body text-center">
|
|
<h5 class="card-title">Total Agents</h5>
|
|
<p class="stat-number"><?php echo $counts['agents']; ?></p>
|
|
<a href="agents.php" class="btn btn-primary">Manage</a>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
|
|
<!-- Owners Card -->
|
|
<div class="col-md-4 col-lg mb-4">
|
|
<div class="card h-100">
|
|
<div class="card-body text-center">
|
|
<h5 class="card-title">Total Owners</h5>
|
|
<p class="stat-number"><?php echo $counts['owners']; ?></p>
|
|
<a href="owners.php" class="btn btn-primary">Manage</a>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
|
|
<!-- Clients Card -->
|
|
<div class="col-md-6 col-lg mb-4">
|
|
<div class="card h-100">
|
|
<div class="card-body text-center">
|
|
<h5 class="card-title">Total Clients</h5>
|
|
<p class="stat-number"><?php echo $counts['clients']; ?></p>
|
|
<a href="clients.php" class="btn btn-primary">Manage</a>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
|
|
<!-- Transactions Card -->
|
|
<div class="col-md-6 col-lg mb-4">
|
|
<div class="card h-100">
|
|
<div class="card-body text-center">
|
|
<h5 class="card-title">Total Transactions</h5>
|
|
<p class="stat-number"><?php echo $counts['transactions']; ?></p>
|
|
<a href="transactions.php" class="btn btn-primary">Manage</a>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
|
|
<?php require_once 'footer.php'; ?>
|