admin_stat.php

<?php


require_once './connection/config.php';
session_start();
if (!isset($_SESSION['username']) && !$_SESSION['login_success']) {
  header(" Location: admin_login.php");
  exit();
}
$error = "";

//for fetching the count of the books
$result = $mysqli->query("SELECT COUNT(id) AS total_rows FROM books");
if ($result) {
    $row = $result->fetch_assoc();
    $book_count = $row['total_rows'];

    echo "Total rows: " . $book_count;
} else {
    $book_count = 0;
}

// fetching the completed order which represents the total sales
$result = $mysqli->query("SELECT sum(total_price) AS total_sales FROM orders WHERE status = 'Completed'");
if ($result) {
    $row = $result->fetch_assoc();
    $total_sales = $row['total_sales'];
    if($total_sales < 0 ){
        $total_sales = 0;
    }
} else {
    $total_sales = 0;
}

// count the books quantity 
$result = $mysqli->query("SELECT sum(stock) AS total_quantity FROM books");
if ($result) {
    $row = $result->fetch_assoc();
    $book_quantities = $row['total_quantity'];

} else {
    $book_quantities = 0;
}


// select the order status

$result = $mysqli->query("SELECT status, COUNT(*) AS count FROM orders WHERE status IN ('Pending', 'Completed', 'Cancelled') GROUP BY status");
if ($result) {
    // Initialize counts
    $counts = [
        'Pending' => 0,
        'Completed' => 0,
        'Cancelled' => 0
    ];

    // Fetch results
    while ($row = $result->fetch_assoc()) {
        if ($row['status'] === 'Pending') {
            $counts['Pending'] = $row['count'];
        } elseif ($row['status'] === 'Completed') {
            $counts['Completed'] = $row['count'];
        } elseif ($row['status'] === 'Cancelled') {
            $counts['Cancelled'] = $row['count'];
        }
    }

    // Assign to variables for easier usage
    $order_pending = $counts['Pending'];
    $order_completed = $counts['Completed'];
    $order_cancelled = $counts['Cancelled'];

} else {
    echo "Error: " . $mysqli->error;
}

?>


<!DOCTYPE html>
<html lang="en">

<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">

    <!-- Boxicons -->
    <link href='https://unpkg.com/boxicons@2.0.9/css/boxicons.min.css' rel='stylesheet'>
    <!-- My CSS -->
    <link rel="stylesheet" href="./css/admindashboard.css">
    <title>Dashboard Admin: <?php echo $username ?> </title>


    <!-- fro erro handling -->
    
</head>

<body>


    <!-- SIDEBAR -->
    <?php include 'admin_sidebar.php' ?>;
    <!-- SIDEBAR -->



    <!-- CONTENT -->
    <section id="content">
        <!-- NAVBAR -->
        <nav>

            <a href="admin_dashboard.php" class="nav-link">Admin Dashboard</a>
            <div class="nav-link-2">
                <a href="admin_profilecard.php" class="profile">
                    <img src="img/people.png">
                </a>
            </div>
        </nav>
        <!-- NAVBAR -->
        <div class="container">
        <!-- Error Message -->
        <?php if (!empty($error)) { ?>
            <div class="error-box"><?php echo $error; ?></div>
        <?php } ?>

        <h2 class="dashboard-title">📊 Report Overview</h2>

        <div class="dashboard">
            <!-- Sales Overview -->
            <div class="card sales">
                <h3>💰 Sales Overview</h3>
                <div class="stats">
                    <div class="stat">
                        <h4>Total Sales</h4>
                        <p>Rs.<?php echo number_format((float)$total_sales, 2); ?></p>
                    </div>
                    <div class="stat">
                        <h4>Total Books</h4>
                        <p><?php echo $book_count; ?></p>
                    </div>
                    <div class="stat">
                        <h4>Books Quantity</h4>
                        <p><?php echo $book_quantities; ?></p>
                    </div>
                </div>
            </div>

            <!-- Orders Overview -->
            <div class="card orders">
                <h3>📦 Orders Overview</h3>
                <div class="stats">
                    <div class="stat">
                        <h4>Pending Orders</h4>
                        <p><?php echo $order_pending; ?></p>
                    </div>
                    <div class="stat">
                        <h4>Completed Orders</h4>
                        <p><?php echo $order_completed; ?></p>
                    </div>
                    <div class="stat">
                        <h4>Cancelled Orders</h4>
                        <p><?php echo $order_cancelled; ?></p>
                    </div>
                </div>
            </div>
        </div>

    </div>


    </section>
    <!-- CONTENT -->





</body>

</html>