File "dashboard.php"
Full path: /home/eshuaesb/public_html/www.mhawaterpark.com/admin/dashboard.php
File
size: 0.01 KB (9.68 KB bytes)
MIME-type: text/x-php
Charset: utf-8
Download Open Edit Advanced Editor Back
<?php include("auth.php") ?>
<?php
function getticketstoday()
{
include "conn.php";
$total = 0;
$query = "select SUM(no_of_tickets) as tot from tbl_ticket_bookings where DATE(created_at)=CURDATE() and deleted_at is NULL";
$smt1 = mysqli_query($conn, $query);
$result = mysqli_fetch_assoc($smt1);
if($result['tot']>0)
return ($result['tot']);
else
{
return ("0");
}
}
function getticketsmonthly()
{
include "conn.php";
$total = 0;
$query = "select SUM(no_of_tickets) as tot from tbl_ticket_bookings where MONTH(created_at)=MONTH(CURDATE()) and deleted_at is NULL";
$smt1 = mysqli_query($conn, $query);
$result = mysqli_fetch_assoc($smt1);
if($result['tot']>0)
return ($result['tot']);
else
{
return ("0");
}
}
function gettransactionstoday()
{
include "conn.php";
$total = 0;
$query = "select count(*) as tot from user_payment_history where DATE(created_at)=CURDATE() and deleted_at is NULL";
$smt1 = mysqli_query($conn, $query);
$result = mysqli_fetch_assoc($smt1);
if($result['tot']>0)
return ($result['tot']);
else
{
return ("0");
}
}
function gettransactionsmonth()
{
include "conn.php";
$total = 0;
$query = "select count(*) as tot from user_payment_history where MONTH(created_at)=MONTH(CURDATE()) and deleted_at is NULL";
$smt1 = mysqli_query($conn, $query);
$result = mysqli_fetch_assoc($smt1);
if($result['tot']>0)
return ($result['tot']);
else
{
return ("0");
}
}
function getusers()
{
include "conn.php";
$total = 0;
$query = "select count(*) as tot from tbl_user where deleted_at is NULL";
$smt1 = mysqli_query($conn, $query);
$result = mysqli_fetch_assoc($smt1);
if($result['tot']>0)
return ($result['tot']);
else
{
return ("0");
}
}
function getwithdrawals()
{
include "conn.php";
$total = 0;
$query = "select count(*) as tot from tbl_withdraw_request where status='Pending' and deleted_at is NULL";
$smt1 = mysqli_query($conn, $query);
$result = mysqli_fetch_assoc($smt1);
if($result['tot']>0)
return ($result['tot']);
else
{
return ("0");
}
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta content="width=device-width, initial-scale=1.0" name="viewport">
<title> Dashboard</title>
<meta content="" name="description">
<meta content="" name="keywords">
<?php include("templates/inc.php"); ?>
</head>
<body>
<!-- ======= Header ======= -->
<?php
include("templates/header.php");
?>
<!-- End Header -->
<!-- ======= Sidebar ======= -->
<?php
include("templates/sidebar.php");
?>
<!-- End Sidebar-->
<main id="main" class="main">
<div class="pagetitle">
<h1>Dashboard</h1>
<nav>
<ol class="breadcrumb">
<li class="breadcrumb-item"><a href="index.html">Home</a></li>
<li class="breadcrumb-item">Dashboard</li>
</ol>
</nav>
</div><!-- End Page Title -->
<section class="section dashboard">
<div class="row">
<!-- Left side columns -->
<div class="col-lg-12">
<div class="row">
<div class="col-xxl-6 col-md-6">
<div class="card info-card revenue-card" style="border:solid;border-width:1px;border-color:#F8C800">
<div class="card-body">
<br>
<div class="d-flex align-items-center"><a href="tickets.php?filter=<?php echo base64_encode('today'); ?>">
<div class="card-icon rounded-circle d-flex align-items-center justify-content-center">
<i style="color:#F8C800;" class="bi bi-ticket-perforated-fill"></i>
</div>
</a>
<div class="ps-3"><a href="tickets.php?filter=<?php echo base64_encode('today'); ?>">
<h5 class="text-dark">Tickets <br><span style="font-size:14px;color:#808183">(Today)</span> <b class="text-dark"><?php echo getticketstoday() ?></b></h5>
</a>
</div>
</div>
</div>
</div>
</div>
<div class="col-xxl-6 col-md-6">
<div class="card info-card revenue-card" style="border:solid;border-width:1px;border-color:#F8C800">
<div class="card-body">
<br>
<div class="d-flex align-items-center"><a href="tickets.php?filter=<?php echo base64_encode('month'); ?>">
<div class="card-icon rounded-circle d-flex align-items-center justify-content-center">
<i style="color:#F8C800;" class="bi bi-ticket-perforated-fill"></i>
</div>
</a>
<div class="ps-3"><a href="tickets.php?filter=<?php echo base64_encode('month'); ?>">
<h5 class="text-dark">Tickets <br><span style="font-size:14px;color:#808183">(This Month)</span> <b class="text-dark"><?php echo getticketsmonthly() ?></b></h5>
</a>
</div>
</div>
</div>
</div>
</div>
<?php if($_SESSION['role']=="Admin") { ?>
<div class="col-xxl-6 col-md-6">
<div class="card info-card revenue-card" style="border:solid;border-width:1px;border-color:#01B20A">
<div class="card-body">
<br>
<div class="d-flex align-items-center"><a href="user-transaction-list.php?filter=<?php echo base64_encode('today'); ?>">
<div class="card-icon rounded-circle d-flex align-items-center justify-content-center">
<i style="color:#01B20A;" class="bi bi-arrow-left-right"></i>
</div>
</a>
<div class="ps-3"><a href="user-transaction-list.php?filter=<?php echo base64_encode('today'); ?>">
<h5 class="text-dark">Transactions <br><span style="font-size:14px;color:#808183">(Today)</span> <b class="text-dark"><?php echo gettransactionstoday() ?></b></h5>
</a>
</div>
</div>
</div>
</div>
</div>
<div class="col-xxl-6 col-md-6">
<div class="card info-card revenue-card" style="border:solid;border-width:1px;border-color:#01B20A">
<div class="card-body">
<br>
<div class="d-flex align-items-center"><a href="user-transaction-list.php?filter=<?php echo base64_encode('month'); ?>">
<div class="card-icon rounded-circle d-flex align-items-center justify-content-center">
<i style="color:#01B20A;" class="bi bi-arrow-left-right"></i>
</div>
</a>
<div class="ps-3"><a href="user-transaction-list.php?filter=<?php echo base64_encode('month'); ?>">
<h5 class="text-dark">Transactions <br><span style="font-size:14px;color:#808183">(This Month)</span> <b class="text-dark"><?php echo gettransactionsmonth() ?></b></h5>
</a>
</div>
</div>
</div>
</div>
</div>
<div class="col-xxl-6 col-md-6">
<div class="card info-card revenue-card" style="border:solid;border-width:1px;border-color:#3A03CA">
<div class="card-body">
<br>
<div class="d-flex align-items-center"><a href="leads-list.php?filter=demo_today">
<div class="card-icon rounded-circle d-flex align-items-center justify-content-center">
<i style="color:#3A03CA;" class="bi bi-person-fill"></i>
</div>
</a>
<div class="ps-3"><a href="create-user-list.php">
<h5 class="text-dark">App Users <br><span style="font-size:14px;color:#808183">(Total)</span> <b class="text-dark"><?php echo getusers() ?></b></h5>
</a>
</div>
</div>
</div>
</div>
</div>
<div class="col-xxl-6 col-md-6">
<div class="card info-card revenue-card" style="border:solid;border-width:1px;border-color:#EC0000">
<div class="card-body">
<br>
<div class="d-flex align-items-center"><a href="leads-list.php?filter=demo_today">
<div class="card-icon rounded-circle d-flex align-items-center justify-content-center">
<i style="color:#EC0000;" class="bi bi-wallet2"></i>
</div>
</a>
<div class="ps-3"><a href="requests.php?status=pending">
<h5 class="text-dark">Withdrawals <br><span style="font-size:14px;color:#808183">(Requests)</span> <b class="text-dark"><?php echo getwithdrawals() ?></b></h5>
</a>
</div>
</div>
</div>
</div>
</div>
<?php } ?>
</div>
</div>
</div>
</section>
</main><!-- End #main -->
<!-- ======= Footer ======= -->
<?php
include("templates/footer.php");
?>
<!-- End Footer -->
<?php include("templates/vendors.php"); ?>
</html>