<?php
// index.php - System Dashboard / Overview
require_once __DIR__ . '/config/app.php';
require_once __DIR__ . '/config/database.php';
require_login();

// Quick summary metrics calculation
$totalCustomers = $db->query("SELECT COUNT(*) as cnt FROM contacts WHERE contact_type IN ('Customer', 'Both')")->fetch_assoc()['cnt'];
$totalVendors = $db->query("SELECT COUNT(*) as cnt FROM contacts WHERE contact_type IN ('Vendor', 'Both')")->fetch_assoc()['cnt'];
$totalInvoices = $db->query("SELECT COUNT(*) as cnt FROM sales_invoices WHERE status = 'Posted'")->fetch_assoc()['cnt'];
$totalBills = $db->query("SELECT COUNT(*) as cnt FROM supplier_bills WHERE status = 'Posted'")->fetch_assoc()['cnt'];

include_once __DIR__ . '/includes/header.php';
include_once __DIR__ . '/includes/sidebar.php';
?>

<!-- Content Wrapper. Contains page content -->
<div class="content-wrapper">
    <!-- Content Header (Page header) -->
    <div class="content-header">
        <div class="container-fluid">
            <div class="row mb-2">
                <div class="col-sm-6">
                    <h1 class="m-0">Dashboard</h1>
                </div>
            </div>
        </div>
    </div>

    <!-- Main content -->
    <section class="content">
        <div class="container-fluid">
            <!-- Small boxes (Stat box) -->
            <div class="row">
                <div class="col-lg-3 col-6">
                    <div class="small-box bg-info">
                        <div class="inner">
                            <h3><?= $totalCustomers ?></h3>
                            <p>Active Customers</p>
                        </div>
                        <div class="icon">
                            <i class="fas fa-users"></i>
                        </div>
                        <a href="<?= APP_URL ?>/modules/customers/index.php" class="small-box-footer">More info <i class="fas fa-arrow-circle-right"></i></a>
                    </div>
                </div>
                
                <div class="col-lg-3 col-6">
                    <div class="small-box bg-success">
                        <div class="inner">
                            <h3><?= $totalVendors ?></h3>
                            <p>Active Vendors</p>
                        </div>
                        <div class="icon">
                            <i class="fas fa-truck"></i>
                        </div>
                        <a href="<?= APP_URL ?>/modules/vendors/index.php" class="small-box-footer">More info <i class="fas fa-arrow-circle-right"></i></a>
                    </div>
                </div>

                <div class="col-lg-3 col-6">
                    <div class="small-box bg-warning">
                        <div class="inner">
                            <h3><?= $totalInvoices ?></h3>
                            <p>Posted Invoices</p>
                        </div>
                        <div class="icon">
                            <i class="fas fa-file-invoice-dollar"></i>
                        </div>
                        <a href="<?= APP_URL ?>/modules/invoices/index.php" class="small-box-footer">More info <i class="fas fa-arrow-circle-right"></i></a>
                    </div>
                </div>

                <div class="col-lg-3 col-6">
                    <div class="small-box bg-danger">
                        <div class="inner">
                            <h3><?= $totalBills ?></h3>
                            <p>Supplier Bills</p>
                        </div>
                        <div class="icon">
                            <i class="fas fa-shopping-cart"></i>
                        </div>
                        <a href="<?= APP_URL ?>/modules/bills/index.php" class="small-box-footer">More info <i class="fas fa-arrow-circle-right"></i></a>
                    </div>
                </div>
            </div>
            <!-- /.row -->
        </div>
    </section>
</div>

<?php
include_once __DIR__ . '/includes/footer.php';
?>