65 lines
2.1 KiB
PHP
65 lines
2.1 KiB
PHP
<?php
|
|
require_once 'db/config.php';
|
|
require_once 'templates/header.php';
|
|
|
|
// Fetch stats for dashboard
|
|
$stats = ['contacts' => 0, 'deals' => 0, 'open_deals' => 0];
|
|
try {
|
|
$pdo = db();
|
|
$stats['contacts'] = $pdo->query("SELECT count(*) FROM contacts")->fetchColumn();
|
|
// Deals table doesn't exist yet, so we'll keep it at 0
|
|
} catch (PDOException $e) {
|
|
// Silently fail for now, the contacts page will show a proper error
|
|
}
|
|
|
|
?>
|
|
|
|
<div class="d-flex justify-content-between align-items-center mb-4">
|
|
<h1 class="h2">Dashboard</h1>
|
|
</div>
|
|
|
|
<div class="row">
|
|
<div class="col-md-4">
|
|
<div class="card text-center">
|
|
<div class="card-body">
|
|
<h5 class="card-title">Total Contacts</h5>
|
|
<p class="card-text fs-1 fw-bold"><?php echo $stats['contacts']; ?></p>
|
|
<a href="contacts.php" class="btn btn-primary">View Contacts</a>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
<div class="col-md-4">
|
|
<div class="card text-center">
|
|
<div class="card-body">
|
|
<h5 class="card-title">Total Deals</h5>
|
|
<p class="card-text fs-1 fw-bold text-muted"><?php echo $stats['deals']; ?></p>
|
|
<a href="#" class="btn btn-secondary disabled">View Deals</a>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
<div class="col-md-4">
|
|
<div class="card text-center">
|
|
<div class="card-body">
|
|
<h5 class="card-title">Open Deals</h5>
|
|
<p class="card-text fs-1 fw-bold text-muted"><?php echo $stats['open_deals']; ?></p>
|
|
<a href="#" class="btn btn-secondary disabled">View Deals</a>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
|
|
<div class="mt-5">
|
|
<h3>Welcome to your new CRM!</h3>
|
|
<p>This is a starting point for your back office. You can now manage your contacts.</p>
|
|
<p>Next steps you might want to consider:</p>
|
|
<ul>
|
|
<li>Implement the "Add Contact" functionality.</li>
|
|
<li>Build out the "Deals" section.</li>
|
|
<li>Enhance the dashboard with more detailed reports.</li>
|
|
</ul>
|
|
</div>
|
|
|
|
|
|
<?php
|
|
require_once 'templates/footer.php';
|
|
?>
|