|
Server IP : 103.191.208.227 / Your IP : 18.225.234.226 Web Server : LiteSpeed System : Linux emphasis.herosite.pro 4.18.0-553.8.1.lve.el8.x86_64 #1 SMP Thu Jul 4 16:24:39 UTC 2024 x86_64 User : mhmsfzcs ( 1485) PHP Version : 8.1.31 Disable Function : show_source, system, shell_exec, passthru, exec MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON Directory (0750) : /home/mhmsfzcs/vflyorions.com/.well-known/../../ssl/../www/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?php
include "db.php";
include "job/admin_header.php";
include "admin_sidebar.php";
$fetch=("SELECT COUNT(*) as id from profile");
$result = $conn->query($fetch);
while($row=$result->fetch_assoc())
{
$total_user=$row['id'];
}
$fetch1=("SELECT COUNT(*) as id from profile WHERE status='inactive'");
$result1 = $conn->query($fetch1);
while($row1=$result1->fetch_assoc())
{
$inactive_user=$row1['id'];
}
//for currently worked user list show
//$sql = "SELECT COUNT(*) as id FROM `profile` WHERE DATE(targetdate) >= DATE(NOW()) - INTERVAL 7 DAY";
$currentDate = date('Y-m-d');
$sql = "SELECT COUNT(*) as id FROM `profile` WHERE targetdate >= '$currentDate'";
$result = $conn->query($sql);
if ($result === false) {
// Handle the query error, e.g., by logging or displaying an error message
echo "Error: " . $conn->error;
} else {
$rowc = $result->fetch_assoc();
$current_user = $rowc['id'];
// Output the count of users
//echo "Number of users within the last 7 days: " . $current_user;
}
?>
<main id="main" class="main">
<div class="pagetitle">
<h1>Dashboard</h1>
<nav>
<ol class="breadcrumb">
<li class="breadcrumb-item"><a href="index.php">Home</a></li>
<li class="breadcrumb-item active">Dashboard</li>
</ol>
</nav>
</div>
<!-- End Page Title -->
<section class="section dashboard" style="padding-bottom: 200px;">
<div class="row">
<!-- Left side columns -->
<div class="col-lg-12">
<div class="row">
<!--<div class="col-sm-3"></div>-->
<!-- Sales Card -->
<div class="col-sm-4">
<div class="card info-card sales-card">
<div class="filter">
<a class="icon" href="#" data-bs-toggle="dropdown"><i class="bi bi-three-dots"></i></a>
<ul class="dropdown-menu dropdown-menu-end dropdown-menu-arrow">
<li class="dropdown-header text-start">
<h6>Filter</h6>
</li>
</ul>
</div>
<div class="card-body">
<a href="login_details.php">
<h5 class="card-title"><b>Total Users</b></h5>
<div class="d-flex align-items-center">
<div class="card-icon rounded-circle d-flex align-items-center justify-content-center">
<i class="bx bx-refresh"></i>
</div>
<div class="ps-3">
<h6><?php echo $total_user;?></h6>
</div>
</div>
</a>
</div>
</div>
</div>
<!-- End Sales Card -->
<div class="col-sm-4">
<div class="card info-card revenue-card">
<div class="filter">
<a class="icon" href="#" data-bs-toggle="dropdown"><i class="bi bi-three-dots"></i></a>
<ul class="dropdown-menu dropdown-menu-end dropdown-menu-arrow">
<li class="dropdown-header text-start">
<h6>Filter</h6>
</li>
</ul>
</div>
<div class="card-body">
<a href="currently_workinguser_details.php">
<h5 class="card-title"><b>Currently Working User</b></h5>
<div class="d-flex align-items-center">
<div class="card-icon rounded-circle d-flex align-items-center justify-content-center">
<i class="bx bx-group"></i>
</div>
<div class="ps-3">
<h6><?php echo $current_user
; //$cnameu ?></h6>
</div>
</div>
</a>
</div>
</div>
</div>
<!-- Revenue Card -->
<div class="col-sm-4">
<div class="card info-card revenue-card">
<div class="filter">
<a class="icon" href="#" data-bs-toggle="dropdown"><i class="bi bi-three-dots"></i></a>
<ul class="dropdown-menu dropdown-menu-end dropdown-menu-arrow">
<li class="dropdown-header text-start">
<h6>Filter</h6>
</li>
</ul>
</div>
<div class="card-body">
<a href="login_details.php">
<h5 class="card-title"><b>Inactive Users</b></h5>
<div class="d-flex align-items-center">
<div class="card-icon rounded-circle d-flex align-items-center justify-content-center">
<i class="bx bx-group"></i>
</div>
<div class="ps-3">
<h6><?php echo $inactive_user ;?></h6>
</div>
</div>
</a>
</div>
</div>
</div>
<!-- End Revenue Card -->
<!-- Customers Card -->
<!--<div class="col-sm-3">-->
<!-- <div class="card info-card customers-card">-->
<!-- <div class="filter">-->
<!-- <a class="icon" href="#" data-bs-toggle="dropdown"><i class="bi bi-three-dots"></i></a>-->
<!-- <ul class="dropdown-menu dropdown-menu-end dropdown-menu-arrow">-->
<!-- <li class="dropdown-header text-start">-->
<!-- <h6>Filter</h6>-->
<!-- </li>-->
<!-- <li><a class="dropdown-item" href="#">Today</a></li>
<!-- <li><a class="dropdown-item" href="#">This Month</a></li>-->
<!-- <li><a class="dropdown-item" href="#">This Year</a></li> -->
<!-- </ul>-->
<!-- </div>-->
<!-- <div class="card-body">-->
<!-- <h5 class="card-title" style="font-size:23px;"><b>Total Forms</b></h5>-->
<!-- <div class="d-flex align-items-center">-->
<!-- <div class="card-icon rounded-circle d-flex align-items-center justify-content-center">-->
<!-- <i class="bx bx-rupee"></i>-->
<!-- </div>-->
<!-- <div class="ps-3">-->
<!-- <h6><?php echo $total_form ;?></h6>-->
<!-- </div>-->
<!-- </div>-->
<!-- </div>-->
<!-- </div>-->
<!--</div><!-- End Customers Card -->
<!--<div class="col-sm-3"></div>-->
</div>
</div>
<!-- End Left side columns -->
</div>
</section>
</main>
<!-- End #main -->
<!--<script>-->
<!-- window.onbeforeunload = function () {-->
<!-- return "Do you really want to close?";-->
<!--};-->
<!--</script>-->
<?php
include "footer.php";
?>