182 lines
7.7 KiB
PHP
182 lines
7.7 KiB
PHP
<?php
|
|
$page_title = "Dashboard";
|
|
require_once 'includes/header.php';
|
|
|
|
// Fetch stats using indexed columns
|
|
$customer_count = db()->query("SELECT COUNT(*) FROM customers WHERE deleted_at IS NULL")->fetchColumn();
|
|
$quotation_count = db()->query("SELECT COUNT(*) FROM quotations WHERE deleted_at IS NULL")->fetchColumn();
|
|
$invoice_count = db()->query("SELECT COUNT(*) FROM invoices WHERE deleted_at IS NULL")->fetchColumn();
|
|
$total_revenue = db()->query("SELECT SUM(total_amount) FROM invoices WHERE status = 'Paid' AND deleted_at IS NULL")->fetchColumn() ?: 0;
|
|
|
|
// Fetch Recent Invoices
|
|
$recent_invoices = db()->query("
|
|
SELECT i.*, c.name as customer_name
|
|
FROM invoices i
|
|
JOIN customers c ON i.customer_id = c.id
|
|
WHERE i.deleted_at IS NULL
|
|
ORDER BY i.created_at DESC
|
|
LIMIT 5
|
|
")->fetchAll();
|
|
|
|
// Fetch Recent Activity (Audit Logs)
|
|
$recent_activity = db()->query("
|
|
SELECT a.*, u.full_name
|
|
FROM audit_logs a
|
|
LEFT JOIN users u ON a.user_id = u.id
|
|
ORDER BY a.created_at DESC
|
|
LIMIT 10
|
|
")->fetchAll();
|
|
?>
|
|
|
|
<div class="row g-4 mb-4">
|
|
<div class="col-12 col-sm-6 col-xl-3">
|
|
<div class="card h-100 p-3 border-start border-4 border-primary">
|
|
<div class="d-flex align-items-center">
|
|
<div class="flex-shrink-0 bg-light p-3 rounded-2 text-primary">
|
|
<i class="bi bi-people fs-4"></i>
|
|
</div>
|
|
<div class="flex-grow-1 ms-3">
|
|
<h6 class="mb-0 text-muted">Total Customers</h6>
|
|
<h4 class="mb-0 fw-bold"><?= e($customer_count) ?></h4>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
<div class="col-12 col-sm-6 col-xl-3">
|
|
<div class="card h-100 p-3 border-start border-4 border-info">
|
|
<div class="d-flex align-items-center">
|
|
<div class="flex-shrink-0 bg-light p-3 rounded-2 text-info">
|
|
<i class="bi bi-file-earmark-text fs-4"></i>
|
|
</div>
|
|
<div class="flex-grow-1 ms-3">
|
|
<h6 class="mb-0 text-muted">Quotations</h6>
|
|
<h4 class="mb-0 fw-bold"><?= e($quotation_count) ?></h4>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
<div class="col-12 col-sm-6 col-xl-3">
|
|
<div class="card h-100 p-3 border-start border-4 border-warning">
|
|
<div class="d-flex align-items-center">
|
|
<div class="flex-shrink-0 bg-light p-3 rounded-2 text-warning">
|
|
<i class="bi bi-receipt fs-4"></i>
|
|
</div>
|
|
<div class="flex-grow-1 ms-3">
|
|
<h6 class="mb-0 text-muted">Invoices</h6>
|
|
<h4 class="mb-0 fw-bold"><?= e($invoice_count) ?></h4>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
<div class="col-12 col-sm-6 col-xl-3">
|
|
<div class="card h-100 p-3 border-start border-4 border-success">
|
|
<div class="d-flex align-items-center">
|
|
<div class="flex-shrink-0 bg-light p-3 rounded-2 text-success">
|
|
<i class="bi bi-cash-stack fs-4"></i>
|
|
</div>
|
|
<div class="flex-grow-1 ms-3">
|
|
<h6 class="mb-0 text-muted">Total Revenue</h6>
|
|
<h4 class="mb-0 fw-bold"><?= format_currency($total_revenue) ?></h4>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
|
|
<div class="row mb-4">
|
|
<div class="col-lg-8">
|
|
<div class="card mb-4">
|
|
<div class="card-header bg-white py-3">
|
|
<h5 class="fw-bold mb-0">Recent Invoices</h5>
|
|
</div>
|
|
<div class="table-responsive">
|
|
<table class="table table-hover align-middle mb-0">
|
|
<thead>
|
|
<tr>
|
|
<th>Invoice #</th>
|
|
<th>Customer</th>
|
|
<th>Due Date</th>
|
|
<th>Amount</th>
|
|
<th>Status</th>
|
|
</tr>
|
|
</thead>
|
|
<tbody>
|
|
<?php foreach ($recent_invoices as $inv): ?>
|
|
<tr>
|
|
<td class="fw-medium"><?= e($inv['invoice_number']) ?></td>
|
|
<td><?= e($inv['customer_name']) ?></td>
|
|
<td><?= e($inv['due_date']) ?></td>
|
|
<td><?= format_currency($inv['total_amount']) ?></td>
|
|
<td>
|
|
<?php
|
|
$badge_class = 'bg-secondary';
|
|
if ($inv['status'] == 'Paid') $badge_class = 'bg-success';
|
|
if ($inv['status'] == 'Unpaid') $badge_class = 'bg-danger';
|
|
if ($inv['status'] == 'Overdue') $badge_class = 'bg-dark';
|
|
?>
|
|
<span class="badge <?= $badge_class ?>"><?= e($inv['status']) ?></span>
|
|
</td>
|
|
</tr>
|
|
<?php endforeach; if (empty($recent_invoices)): ?>
|
|
<tr>
|
|
<td colspan="5" class="text-center py-4 text-muted">No invoices found.</td>
|
|
</tr>
|
|
<?php endif; ?>
|
|
</tbody>
|
|
</table>
|
|
</div>
|
|
</div>
|
|
|
|
<div class="card">
|
|
<div class="card-header bg-white py-3">
|
|
<h5 class="fw-bold mb-0">Quick Actions</h5>
|
|
</div>
|
|
<div class="card-body">
|
|
<div class="row g-3">
|
|
<div class="col-md-4">
|
|
<a href="customer_form.php" class="btn btn-outline-primary w-100 py-3">
|
|
<i class="bi bi-person-plus d-block fs-3 mb-2"></i>
|
|
New Customer
|
|
</a>
|
|
</div>
|
|
<div class="col-md-4">
|
|
<a href="quotations.php" class="btn btn-outline-primary w-100 py-3">
|
|
<i class="bi bi-file-earmark-plus d-block fs-3 mb-2"></i>
|
|
New Quotation
|
|
</a>
|
|
</div>
|
|
<div class="col-md-4">
|
|
<a href="products.php" class="btn btn-outline-primary w-100 py-3">
|
|
<i class="bi bi-box-seam d-block fs-3 mb-2"></i>
|
|
Add Product
|
|
</a>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
<div class="col-lg-4">
|
|
<div class="card h-100">
|
|
<div class="card-header bg-white py-3">
|
|
<h5 class="fw-bold mb-0">Recent Activity</h5>
|
|
</div>
|
|
<div class="list-group list-group-flush">
|
|
<?php foreach ($recent_activity as $log): ?>
|
|
<div class="list-group-item py-3">
|
|
<div class="d-flex w-100 justify-content-between">
|
|
<h6 class="mb-1 fw-bold"><?= e($log['action']) ?>: <?= e($log['entity_type']) ?></h6>
|
|
<small class="text-muted"><?= date('H:i', strtotime($log['created_at'])) ?></small>
|
|
</div>
|
|
<p class="mb-1 small"><?= e($log['details']) ?></p>
|
|
<small class="text-muted">by <?= e($log['full_name'] ?: 'System') ?></small>
|
|
</div>
|
|
<?php endforeach; if (empty($recent_activity)): ?>
|
|
<div class="p-4 text-center text-muted">No activity recorded yet.</div>
|
|
<?php endif; ?>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
|
|
<?php require_once 'includes/footer.php'; ?>
|