<?php
date_default_timezone_set('Africa/Lagos');
$currentHour = date('H');
// Greetings based on the current hour
if ($currentHour >= 5 && $currentHour < 12) {
$greeting = 'Good morning, Admin!';
} elseif ($currentHour >= 12 && $currentHour < 18) {
$greeting = 'Good afternoon, Admin!';
} else {
$greeting = 'Good evening, Admin!';
}
?>
<?php
// include 'config.php';
include 'head.php';
include 'header.php';
?>
<body class="skin-default fixed-layout">
<!-- Sidebar scroll-->
<?php include 'sidebar.php'; ?>
<div class="page-wrapper">
<div class="container-fluid">
<?php include 'nav.php'; ?>
<div class="container-fluid">
<div class="row">
<!-- Column -->
<!-- Column -->
<h5 id="greeting"></h5>
<script>
// JavaScript to display the greeting
document.addEventListener('DOMContentLoaded', function() {
var greetingElement = document.getElementById('greeting');
var greeting = '<?php echo $greeting; ?>';
greetingElement.innerHTML = greeting;
});
</script>
<!-- <div class="col-lg-4 col-md-12"> -->
<div class="row">
<!-- Column -->
<div class="col-md-4">
<div class="card w-100 my-3">
<!-- <div class="card w-100 my-3"> -->
<div class="card-body">
<a href="deposit_confirmed.php">
<div class="row">
<div class="col-md-12">
<div class="d-flex no-block align-items-center">
<div>
<h1><i class="bi bi-cash-coin text-purple"></i></h1>
<p class="text-muted">TOTAL DEPOSIT</p>
</div>
<div class="ml-auto">
<?php
// Use a prepared statement to fetch the total balance
$sql = "SELECT SUM(account_balance) AS total_balance FROM user_login";
$stmt = $conn->prepare($sql);
$stmt->execute();
$result = $stmt->get_result();
// Check if there are any rows returned
if ($result->num_rows > 0) {
// Fetch the total balance
$row = $result->fetch_assoc();
$total_balance = $row['total_balance'];
// Echo the total balance
echo "<h2 class='counter text-purple'>$" . number_format($total_balance, 2) ."</h2>";
} else {
echo "No data available.";
}
?>
</div>
</div>
</div>
<div class="col-12">
<div class="progress">
<div class="progress-bar bg-purple" role="progressbar" style="width: 100%; height: 6px;" aria-valuenow="25" aria-valuemin="0" aria-valuemax="100"></div>
</div>
</div>
</div>
</a>
</div>
</div>
</div>
<div class="col-md-4">
<div class="card w-100 my-3">
<div class="card-body">
<a href="manage-users.php">
<div class="row">
<div class="col-md-12">
<div class="d-flex no-block align-items-center">
<div>
<h1><i class="bi bi-people "></i></h1>
<p class="text-muted">MANAGE USERS</p>
</div>
<div class="ml-auto">
<?php
$sql = "SELECT COUNT(*) AS user_count FROM user_login";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
$row = $result->fetch_assoc();
$user_count = $row['user_count'];
} else {
$user_count = 0;
}
?>
<h2 class="counter text-primary"><?php echo $user_count; ?></h2>
</div>
</div>
</div>
<div class="col-12">
<div class="progress">
<div class="progress-bar bg-primary" role="progressbar" style="width: 100%; height: 6px;" aria-valuenow="25" aria-valuemin="0" aria-valuemax="100"></div>
</div>
</div>
</div>
</a>
</div>
</div>
</div>
<div class="col-md-4">
<div class="card w-100 my-3">
<div class="card-body"><a href="deposit_pending.php">
<div class="row">
<div class="col-md-12">
<div class="d-flex no-block align-items-center">
<div>
<h1><i class="bi bi-cash-coin text-info"></i></h1>
<p class="text-muted">MANAGE DEPOSITS</p>
</div>
<div class="ml-auto">
<?php
$sql = "SELECT COUNT(*) AS user_count FROM deposit";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
$row = $result->fetch_assoc();
$user_count = $row['user_count'];
} else {
$user_count = 0;
}
?>
<h2 class="counter text-primary"><?php echo $user_count; ?></h2>
</div>
</div>
</div>
<div class="col-12">
<div class="progress">
<div class="progress-bar bg-info" role="progressbar" style="width: 100%; height: 6px;" aria-valuenow="25" aria-valuemin="0" aria-valuemax="100"></div>
</div>
</div>
</div>
</a>
</div>
</div>
</div>
<div class="col-md-4">
<div class="card w-100 my-3">
<div class="card-body"><a href="manage-plan.php">
<div class="row">
<div class="col-md-12">
<div class="d-flex no-block align-items-center">
<div>
<h1><i class="bi bi-reception-4 text-info"></i></h1>
<p class="text-muted">INVESTMENT PLANS</p>
</div>
<div class="ml-auto">
<?php
$sql = "SELECT COUNT(*) AS user_count FROM plans";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
$row = $result->fetch_assoc();
$user_count = $row['user_count'];
} else {
$user_count = 0;
}
?>
<h2 class="counter text-primary"><?php echo $user_count; ?></h2>
</div>
</div>
</div>
<div class="col-12">
<div class="progress">
<div class="progress-bar bg-info" role="progressbar" style="width: 100%; height: 6px;" aria-valuenow="25" aria-valuemin="0" aria-valuemax="100"></div>
</div>
</div>
</div>
</a>
</div>
</div>
<!-- </div> -->
</div>
<div class="col-md-4">
<div class="card w-100 my-3">
<div class="card-body">
<a href="manage-wallet.php">
<div class="row">
<div class="col-md-12">
<div class="d-flex no-block align-items-center">
<div>
<h1><i class="bi bi-wallet-fill text-success"></i></h1>
<p class="text-muted">MANAGE WALLETS</p>
</div>
<div class="ml-auto">
<?php
$sql = "SELECT COUNT(*) AS user_count FROM wallet";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
$row = $result->fetch_assoc();
$user_count = $row['user_count'];
} else {
$user_count = 0;
}
?>
<h2 class="counter text-primary"><?php echo $user_count; ?></h2>
</div>
</div>
</div>
<div class="col-12">
<div class="progress">
<div class="progress-bar bg-success" role="progressbar" style="width: 100%; height: 6px;" aria-valuenow="25" aria-valuemin="0" aria-valuemax="100"></div>
</div>
</div>
</div>
</div>
</a>
</div>
</div>
<!-- <div class="col-md-4">
<div class="card w-100 my-3">
<div class="card-body">
<a href="manage-deposit.php">
<div class="row">
<div class="col-md-12">
<div class="d-flex no-block align-items-center">
<div>
<h1><i class="bi bi-receipt-cutoff text-warning"></i></h1>
<p class="text-muted">MANAGE INVESTMENT</p>
</div>
<div class="ml-auto">
<h2 class="counter text-warning"></?php echo $conn->query("SELECT * FROM deposit") ->num_rows; ?></h2>
</div>
</div>
</div>
<div class="col-12">
<div class="progress">
<div class="progress-bar bg-warning" role="progressbar" style="width: 100%; height: 6px;" aria-valuenow="25" aria-valuemin="0" aria-valuemax="100"></div>
</div>
</div>
</div>
</div>
</a>
</div>
</div> -->
<div class="col-md-4">
<div class="card w-100 my-3">
<div class="card-body"><a href="change-password.php">
<div class="row">
<div class="col-md-12">
<div class="d-flex no-block align-items-center">
<div>
<h1><i class="bi bi-lock text-cyan"></i></h1>
<p class="text-muted">CHANGE PASSWORD</p>
</div>
<div class="ml-auto">
</div>
</div>
</div>
<div class="col-12">
<div class="progress">
<div class="progress-bar bg-cyan" role="progressbar" style="width: 100%; height: 6px;" aria-valuenow="25" aria-valuemin="0" aria-valuemax="100"></div>
</div>
</div>
</div>
</a>
</div>
</div>
</div>
<!-- <div class="col-md-6">
<div class="card w-100 my-3">
<div class="card-body"><a href="change-password.php">
<div class="row">
<div class="col-md-12">
<div class="d-flex no-block align-items-center">
<div>
<h3><i class="bi bi-lock"></i></h3>
<p class="text-muted">CHANGE PASSWORD</p>
</div>
<div class="ml-auto">
<h2 class="counter text-purple"></h2>
</div>
</div>
</div>
<div class="col-12">
<div class="progress">
<div class="progress-bar bg-purple" role="progressbar" style="width: 100%; height: 6px;" aria-valuenow="25" aria-valuemin="0" aria-valuemax="100"></div>
</div>
</div>
</div>
</a>
</div>
</div>
</div> -->
<!-- Column -->
</div>
</div>
</div>
</div>
</div>
</div>
<?php include 'footer.php';
if(isset($_SESSION['mgs'])){ unset($_SESSION['mgs']);}?>