File "dashboard.php"
Full Path: /home/quiczmwg/lightspringdigitals.com/admin/dashboard.php
File size: 10.55 KB
MIME-type: text/html
Charset: utf-8
<?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-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-purple"></i></h1>
<p class="text-muted">TOTAL DEPOSIT</p>
</div>
<div class="ml-auto">
<?php
// Check if the user is logged in
if (isset($_SESSION['loginUser'])) {
// Use a prepared statement to fetch the balance
$sql = "SELECT account_balance FROM user_login WHERE userid = ?";
$stmt = $conn->prepare($sql);
$stmt->bind_param("i", $_SESSION['userid']);
$stmt->execute();
$result = $stmt->get_result();
// Check if there are any rows returned
if ($result->num_rows > 0) {
// Fetch the balance
$row = $result->fetch_assoc();
$balance = $row['account_balance'];
// Echo the balance
echo "<h2 class='counter text-purple'>$" . number_format($balance, 2) ."</h2>";
} else {
echo "User not logged in.";
}
} else {
echo "User not logged in.";
}
?>
</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="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">
<!-- <h2 class="counter text-primary"></?php echo $conn->query("SELECT * FROM users_login") ->num_rows; -->
<!-- ?></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="manage-products.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 Product</p>
</div>
<div class="ml-auto">
<h2 class="counter text-info"><?php echo $conn->query("SELECT * FROM products") ->num_rows;
?></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">Manage Plans</p>
</div>
<div class="ml-auto">
<h2 class="counter text-info"><?php echo $conn->query("SELECT * FROM plans") ->num_rows;
?></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="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>
<!-- Column -->
</div>
</div>
</div>
</div>
</div>
</div>
<?php include 'footer.php';
if(isset($_SESSION['mgs'])){ unset($_SESSION['mgs']);}?>