File: /home/cafsindia/refimac_cafsjobs_com/tech_dashboard.php
<?php
// Turn off all error reporting
error_reporting(0);
include('dbconnect.php');
//session_start();
$user=$_SESSION['clid'];
$perm=$_SESSION['cper'];
$mid=$_REQUEST['mid'];
$smid=$_REQUEST['smid'];
$pid=$_REQUEST['pid'];
// customer count
$sqlcustomer="select count(*) as total from customer where CUSTOMER_UPDATE=1";
$qucust=mysql_query($sqlcustomer);
$qucust_f=mysql_fetch_assoc($qucust);
$cust_count=$qucust_f['total'];
//employee
$sqlemp="select count(*) as total from employee where EMP_UPDATE=1";
$quemp=mysql_query($sqlemp);
$quemp_f=mysql_fetch_assoc($quemp);
$emp_count=$quemp_f['total'];
//make
$sqlmake="select count(*) as total from make";
$qumake=mysql_query($sqlmake);
$qumake_f=mysql_fetch_assoc($qumake);
$make_count=$qumake_f['total'];
//service
$sqlservice="select count(*) as total from service where year='2017' and month='01'";
$quservicet=mysql_query($sqlservice);
$quservicet_f=mysql_fetch_assoc($quservicet);
$service_count=$quservicet_f['total'];
?>
<div id="contentwrapper">
<div class="main_content">
<div class="page-head">
<div class="container">
<!-- BEGIN PAGE TITLE -->
<div class="page-title">
<h1>Dahboard statistics, charts, recent events and reports</h1>
</div>
</div>
</div>
<div class="page-content">
<div class="container">
<div class="row-fluid">
<div class="span12">
<?php
if($nav=="1"||$nav=="3")
echo "<div class='alert alert-success'>
<span>Given information successfully updated !</span>
</div>";
elseif($nav=="2"||$nav=="4"||$nav=="6")
echo "<div class='alert alert-warning'>
<span>sorry, given information not updated, please try again !</span>
</div>";
elseif($nav=="5")
echo "<div class='alert alert-danger'>
<span>Selected Record successfully deleted !</span>
</div>";
?>
</div>
</div>
<div class="page-content-inner">
<div class="page-content-inner">
<div class="row widget-row">
<div class="col-md-3">
<!-- BEGIN WIDGET THUMB -->
<div class="widget-thumb widget-bg-color-white text-uppercase margin-bottom-20 ">
<h4 class="widget-thumb-heading">Number of service call</h4>
<div class="widget-thumb-wrap">
<i class="widget-thumb-icon bg-green icon-bulb"></i>
<div class="widget-thumb-body">
<span class="widget-thumb-subtitle"></span>
<span class="widget-thumb-body-stat" data-counter="counterup" data-value="<?php echo $cust_count; ?>">0</span>
</div>
</div>
</div>
<!-- END WIDGET THUMB -->
</div>
<div class="col-md-3">
<!-- BEGIN WIDGET THUMB -->
<div class="widget-thumb widget-bg-color-white text-uppercase margin-bottom-20 ">
<h4 class="widget-thumb-heading"> Number of Regular Call</h4>
<div class="widget-thumb-wrap">
<i class="widget-thumb-icon bg-red icon-layers"></i>
<div class="widget-thumb-body">
<span class="widget-thumb-subtitle"></span>
<span class="widget-thumb-body-stat" data-counter="counterup" data-value="<?php echo $emp_count; ?>">0</span>
</div>
</div>
</div>
<!-- END WIDGET THUMB -->
</div>
<div class="col-md-3">
<!-- BEGIN WIDGET THUMB -->
<div class="widget-thumb widget-bg-color-white text-uppercase margin-bottom-20 ">
<h4 class="widget-thumb-heading"> Complted Call</h4>
<div class="widget-thumb-wrap">
<i class="widget-thumb-icon bg-purple icon-screen-desktop"></i>
<div class="widget-thumb-body">
<span class="widget-thumb-subtitle"></span>
<span class="widget-thumb-body-stat" data-counter="counterup" data-value="<?php echo $service_count; ?>">0</span>
</div>
</div>
</div>
<!-- END WIDGET THUMB -->
</div>
<div class="col-md-3">
<!-- BEGIN WIDGET THUMB -->
<div class="widget-thumb widget-bg-color-white text-uppercase margin-bottom-20 ">
<h4 class="widget-thumb-heading"> number of pending call</h4>
<div class="widget-thumb-wrap">
<i class="widget-thumb-icon bg-blue icon-bar-chart"></i>
<div class="widget-thumb-body">
<span class="widget-thumb-subtitle"></span>
<span class="widget-thumb-body-stat" data-counter="counterup" data-value="<?php echo $make_count; ?>">0</span>
</div>
</div>
</div>
<!-- END WIDGET THUMB -->
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>