Something went wrong. Try again.
Open source inventory management system with php and mysql Invoice generation and easy to download invoice in PDF format Lightweight and ea…
Something went wrong. Try again.
php-inventory-management-system dashboard.php
123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176<?php require_once 'includes/header.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 = "";while ($orderResult = $orderQuery->fetch_assoc()) { $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>
<!-- fullCalendar 2.2.5--> <link rel="stylesheet" href="assests/plugins/fullcalendar/fullcalendar.min.css"> <link rel="stylesheet" href="assests/plugins/fullcalendar/fullcalendar.print.css" media="print">
<div class="row"> <?php if(isset($_SESSION['userId']) && $_SESSION['userId']==1) { ?> <div class="col-md-4"> <div class="panel panel-success"> <div class="panel-heading"> <a href="product.php" style="text-decoration:none;color:black;"> Total Product <span class="badge pull pull-right"><?php echo $countProduct; ?></span> </a> </div> <!--/panel-hdeaing--> </div> <!--/panel--> </div> <!--/col-md-4--> <div class="col-md-4"> <div class="panel panel-danger"> <div class="panel-heading"> <a href="product.php" style="text-decoration:none;color:black;"> Low Stock <span class="badge pull pull-right"><?php echo $countLowStock; ?></span> </a> </div> <!--/panel-hdeaing--> </div> <!--/panel--> </div> <!--/col-md-4--> <?php } ?> <div class="col-md-4"> <div class="panel panel-info"> <div class="panel-heading"> <a href="orders.php?o=manord" style="text-decoration:none;color:black;"> Total Orders <span class="badge pull pull-right"><?php echo $countOrder; ?></span> </a> </div> <!--/panel-hdeaing--> </div> <!--/panel--> </div> <!--/col-md-4-->
<div class="col-md-4"> <div class="card"> <div class="cardHeader"> <h1><?php echo date('d'); ?></h1> </div>
<div class="cardContainer"> <p><?php echo date('l') .' '.date('d').', '.date('Y'); ?></p> </div> </div> <br/>
<div class="card"> <div class="cardHeader" style="background-color:#245580;"> <h1><?php if($totalRevenue) { echo $totalRevenue; } else { echo '0'; } ?></h1> </div>
<div class="cardContainer"> <p> INR Total Revenue</p> </div> </div>
</div> <?php if(isset($_SESSION['userId']) && $_SESSION['userId']==1) { ?> <div class="col-md-8"> <div class="panel panel-default"> <div class="panel-heading"> <i class="glyphicon glyphicon-calendar"></i> User Wise Order</div> <div class="panel-body"> <table class="table" id="productTable"> <thead> <tr> <th style="width:40%;">Name</th> <th style="width:20%;">Orders in Rupees</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 id="calendar"></div>--> </div> </div> </div> <?php } ?> </div> <!--/row-->
<!-- fullCalendar 2.2.5 --><script src="assests/plugins/moment/moment.min.js"></script><script src="assests/plugins/fullcalendar/fullcalendar.min.js"></script>
<script type="text/javascript"> $(function () { // top bar active $('#navDashboard').addClass('active');
//Date for the calendar events (dummy data) var date = new Date(); var d = date.getDate(), m = date.getMonth(), y = date.getFullYear();
$('#calendar').fullCalendar({ header: { left: '', center: 'title' }, buttonText: { today: 'today', month: 'month' } });
});</script>
<?php require_once 'includes/footer.php'; ?>