|
Server IP : 162.214.80.37 / Your IP : 216.73.216.173 Web Server : Apache System : Linux sh013.webhostingservices.com 4.19.286-203.ELK.el7.x86_64 #1 SMP Wed Jun 14 04:33:55 CDT 2023 x86_64 User : imyrqtmy ( 2189) PHP Version : 8.2.18 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON Directory (0755) : /home2/imyrqtmy/public_html/skyispatudyog/sym/Users/0-imyrqtmy/localapp/admin/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?php
session_start();
$se = $_SESSION["id"];
if (!isset($_SESSION['id'])) {
header("Location: login.php");
}
include("inc/config.php");
?>
<!DOCTYPE html>
<html lang="en">
<?php require "inc/head.php"; ?>
<body>
<!-- header-->
<?php require "inc/header.php"; ?>
<!-- End header-->
<!-- Main-content Top bar-->
<!-- End Main-content Top bar-->
<!-- main-content-->
<div class="wrapper">
<?php require "inc/sidebar.php"; ?>
<div id="content">
<div class="row">
<div class="col-sm-12">
<div class="row mb-xl-4 mb-0">
<?php
// Fetch the count of pending projects
$pending_query = "SELECT COUNT(*) AS pending_count FROM news WHERE status = 'Pending'";
$pending_result = mysqli_query($conn, $pending_query);
$pending_row = mysqli_fetch_assoc($pending_result);
// Get the count or default to 0 if no pending projects
$pending_count = $pending_row['pending_count'] ?? 0;
?>
<div class="col-12 col-sm-6 col-xl-3 mb-4 mb-xl-0">
<div class="card redial-border-primary redial-shadow redial-bg-primary text-white">
<div class="card-body">
<div class="media d-block d-sm-flex text-center text-sm-left">
<div class="d-md-flex align-self-center mx-auto mb-4 mb-sm-0 mr-0 mr-sm-3 spark10"></div>
<div class="media-body">
<div class=" text-center text-sm-right">
<h2 class="mb-1 redial-font-weight-400 text-white" style="padding-right: 17px;"><?php echo $pending_count; ?></h2>
<p class="mb-2" style="padding-right: 17px;">Pending News</p>
<div class="chart sparkline spark5"></div>
</div>
</div>
</div>
</div>
</div>
</div>
<?php
// Fetch the count of pending projects
$pending_query = "SELECT COUNT(*) AS pending_count FROM News WHERE status = 'Approved'";
$pending_result = mysqli_query($conn, $pending_query);
$pending_row = mysqli_fetch_assoc($pending_result);
// Get the count or default to 0 if no pending projects
$pending_count = $pending_row['pending_count'] ?? 0;
?>
<div class="col-12 col-sm-6 col-xl-3 mb-4 mb-xl-0">
<div class="card redial-bg-pink redial-border-pink redial-shadow text-white">
<div class="card-body">
<div class="media d-block d-sm-flex text-center text-sm-left">
<div class="d-md-flex align-self-center mx-auto mb-4 mb-sm-0 mr-0 mr-sm-3 spark10"></div>
<div class="media-body">
<div class="text-center text-sm-right">
<h2 class=" mb-1 redial-font-weight-400 text-white" style="padding-right: 17px;"><?php echo $pending_count; ?> </h2>
<p class="mb-2" style="padding-right: 17px;">Approve News</p>
<div class="chart sparkline spark5"></div>
</div>
</div>
</div>
</div>
</div>
</div>
<?php
// Fetch the count of pending projects
$pending_query = "SELECT COUNT(*) AS pending_count FROM vendor WHERE status = 'Pending'";
$pending_result = mysqli_query($conn, $pending_query);
$pending_row = mysqli_fetch_assoc($pending_result);
// Get the count or default to 0 if no pending projects
$pending_count = $pending_row['pending_count'] ?? 0;
?>
<div class="col-12 col-sm-6 col-xl-3 mb-4 mb-xl-0">
<div class="card redial-bg-success redial-border-success redial-shadow text-white">
<div class="card-body">
<div class="media d-block d-sm-flex text-center text-sm-left">
<div class="d-md-flex align-self-center mx-auto mb-4 mb-sm-0 mr-0 mr-sm-3 spark10"></div>
<div class="media-body">
<div class="text-center text-sm-right">
<h2 class=" mb-1 redial-font-weight-400 text-white" style="padding-right: 17px;"><?php echo $pending_count; ?> </h2>
<p class="mb-2" style="padding-right: 17px;">Pending Reporter</p>
<div class="chart sparkline spark5"></div>
</div>
</div>
</div>
</div>
</div>
</div>
<?php
// Fetch the count of completed tasks
$complete_query = "SELECT COUNT(*) AS complete_count FROM vendor WHERE status = 'Approved'";
$complete_result = mysqli_query($conn, $complete_query);
$complete_row = mysqli_fetch_assoc($complete_result);
// Get the count or default to 0 if no completed tasks
$complete_count = $complete_row['complete_count'] ?? 0;
?>
<div class="col-12 col-sm-6 col-xl-3">
<div class="card redial-bg-info redial-border-info redial-shadow text-white">
<div class="card-body">
<div class="media d-block d-sm-flex text-center text-sm-left">
<div class="d-md-flex align-self-center mx-auto mb-4 mb-sm-0 mr-0 mr-sm-3 spark10"></div>
<div class="media-body">
<div class="text-center text-sm-right">
<h2 class=" mb-1 redial-font-weight-400 text-white" style="padding-right: 17px;"><?php echo $complete_count; ?> </h2>
<p class="mb-2" style="padding-right: 17px;">Approved Reporter</p>
<div class="chart sparkline spark5"></div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<!-- End main-content-->
<!-- Top To Bottom--> <a href="#" class="scrollup text-center redial-bg-primary redial-rounded-circle-50 ">
<h4 class="text-white mb-0"><i class="icofont icofont-long-arrow-up"></i></h4>
</a>
<!-- End Top To Bottom-->
<!-- jQuery -->
<script src="dist/js/plugins.min.js"></script>
<script src="dist/js/common.js"></script>
</body>
</html>