| Server IP : 213.186.33.4 / Your IP :
216.73.216.146 [
Web Server : Apache System : Linux webm002.cluster103.gra.hosting.ovh.net 5.15.167-ovh-vps-grsec-zfs-classid #1 SMP Tue Sep 17 08:14:20 UTC 2024 x86_64 User : dealkatnwc ( 662330) PHP Version : 7.0.33 Disable Function : _dyuweyrj4,_dyuweyrj4r,dl Domains : 2 Domains MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : OFF | Pkexec : OFF Directory : /home/dealkatnwc/www/GARAGE/ |
Upload File : |
<?php error_reporting(1); ?>
<?php include('./constant/layout/head.php');?>
<!-- Author Name- Mayuri K.
for any PHP, Codeignitor, Laravel OR Python work contact me at mayuri.infospace@gmail.com
Visit website - www.mayurik.com -->
<?php include('./constant/layout/header.php');?>
<?php //include('./constant/layout/sidebar.php');?>
<?php
$sql = "SELECT * FROM product WHERE status = 1";
$query = $connect->query($sql);
$countProduct = $query->num_rows;
$orderSql = "SELECT * FROM orders WHERE order_status = 1";
$orderQuery = $connect->query($orderSql);
$countOrder = $orderQuery->num_rows;
$totalRevenue = 0;
while ($orderResult = $orderQuery->fetch_assoc()) {
//echo $orderResult['paid'];exit;
$totalRevenue += $orderResult['paid'];
}
$lowStockSql = "SELECT * FROM product WHERE quantity <= 3 AND status = 1";
$lowStockQuery = $connect->query($lowStockSql);
$countLowStock = $lowStockQuery->num_rows;
$userwisesql = "SELECT users.username , SUM(orders.grand_total) as totalorder FROM orders INNER JOIN users ON orders.user_id = users.user_id WHERE orders.order_status = 1 GROUP BY orders.user_id";
$userwiseQuery = $connect->query($userwisesql);
$userwieseOrder = $userwiseQuery->num_rows;
$connect->close();
?>
<style type="text/css">
.ui-datepicker-calendar {
display: none;
}
</style>
<div class="page-wrapper">
<!-- Author Name: Mayuri K.
for any PHP, Codeignitor, Laravel OR Python work contact me at mayuri.infospace@gmail.com
Visit website : www.mayurik.com -->
<div class="container-fluid">
<br>
<marquee direction="left" behavior="alternate" scrollamount=1 >
<h3 style="color:red"><b>Alert : Don't Sale or Publish this script with your name. However you can use it for Academic learning Purpose !</b></h3>
</marquee>
<div class="row">
<div class="col-md-4 dashboard">
<div class="card" style="background: #2BC155 ">
<div class="media widget-ten">
<div class="media-left meida media-middle">
<span><i class="fa fa-car f-s-40"></i></span>
</div>
<div class="media-body media-text-right">
<h2 class="color-white"><?php echo $countProduct; ?></h2>
<a href="product.php"><p class="m-b-0">Total Vehicles</p></a>
</div>
</div>
</div>
</div>
<?php if(isset($_SESSION['userId']) && $_SESSION['userId']==1) { ?>
<div class="col-md-4 dashboard">
<div class="card" style="background:#A02CFA ">
<div class="media widget-ten">
<div class="media-left meida media-middle">
<span><i class="ti-comment f-s-40"></i></span>
</div>
<div class="media-body media-text-right">
<h2 class="color-white"><?php echo $countLowStock; ?></h2>
<a href="product.php"><p class="m-b-0">Low Stock</p></a>
</div>
</div>
</div>
</div>
<?php }?>
<?php if(isset($_SESSION['userId']) && $_SESSION['userId']==1) { ?>
<div class="col-md-4 dashboard">
<div class="card" style="background-color: #F94687 ">
<div class="media widget-ten">
<div class="media-left meida media-middle">
<span><i class="ti-vector f-s-40"></i></span>
</div>
<div class="media-body media-text-right">
<h2 class="color-white"><?php echo $countOrder; ?></h2>
<a href="Order.php"><p class="m-b-0">Total Order</p></a>
</div>
</div>
</div>
</div>
<?php }?>
<div class="col-md-4 dashboard">
<div class="card" style="background-color:#ffc107;">
<div class="media widget-ten">
<div class="media-left meida media-middle">
<span><i class="ti-calendar f-s-40"></i></span>
</div>
<div class="media-body media-text-right">
<h1 style="color:white;"><?php echo date('d'); ?></h1>
<p style="color:white;"><?php echo date('l') .' '.date('d').', '.date('Y'); ?></p>
</div>
</div>
</div>
</div>
<div class="col-md-4 dashboard">
<div class="card" style="background-color:#009688;">
<div class="media widget-ten">
<div class="media-left meida media-middle">
<span><i class="fa fa-money f-s-40"></i></span>
</div>
<div class="media-body media-text-right">
<h1 style="color:white;"><?php if($totalRevenue) {
echo $totalRevenue;
} else {
echo '0';
} ?></h1>
<p style="color:white;">Total Revenue</p>
</div>
</div>
</div>
</div>
<?php if(isset($_SESSION['userId']) && $_SESSION['userId']==1) { ?>
<div class="col-md-12">
<div class="card">
<div class="card-header">
<strong class="card-title">User Wise Order</strong>
</div>
<div class="card-body">
<table class="table">
<thead>
<tr>
<th scope="col">Name</th>
<th scope="col">Orders Amount</th>
</tr>
</thead>
<tbody>
<?php while ($orderResult = $userwiseQuery->fetch_assoc()) { ?>
<tr>
<td><?php echo $orderResult['username']?></td>
<td><?php echo $orderResult['totalorder']?></td>
</tr>
<?php } ?>
</tbody>
</table>
</div>
</div>
</div>
<?php }?>
</div>
</div>
</div>
</div>
<?php include ('./constant/layout/footer.php');?>
<script type="text/javascript">
google.charts.load('current', {'packages':['corechart']});
google.charts.setOnLoadCallback(drawChart);
function drawChart() {
var data = google.visualization.arrayToDataTable([
['Task', 'Hours per Day'],
['Work', 11],
['Eat', 2],
['Commute', 2],
['Watch TV', 2],
['Sleep', 7]
]);
var options = {
title: 'My Daily Activities'
};
var chart = new google.visualization.PieChart(document.getElementById('piechart'));
chart.draw(data, options);
}
</script>