Preview: welcome.php
Size: 15.77 KB
/home/urbanman/roadkaraja.in/manager/welcome.php
<?php
error_reporting(0);
include("common.php");
include("config.php");
//if($_SESSION[manager_name]==''){header("Location:index.php");exit;}
?>
<style>
#content-desktop {display: block;}
#content-mobile {display: none;}
@media screen and (max-width: 768px) {#content-desktop {display:none;}
#content-mobile {display: block;}
}
</style>
<?php
$tdte = date("Y/m/d");
$branch = $_SESSION[branch];
$rdte = date("Y/m/d");
$que="select * from customer where regdte='$rdte' and branch='$branch'";
if (!($page_res = mysql_query($que))) { echo "FOR QUERY: $strsql<BR>".mysql_error(); exit;}
$rowCount = mysql_num_rows($page_res);
$count2=$srnum[0];
while($row=mysql_fetch_array($page_res)){$count2++;}
$que3="select * from customer where branch='$branch'";
if (!($page_res3 = mysql_query($que3))) { echo "FOR QUERY: $strsql<BR>".mysql_error(); exit;}
$rowCount = mysql_num_rows($page_res3);
$count3=$srnum[0];
while($row=mysql_fetch_array($page_res3)){$count3++;}
$que4="SELECT * FROM customer where branch='$branch' and `regdte` >= DATE_SUB(CURDATE(), INTERVAL 1 MONTH)";
if (!($page_res4 = mysql_query($que4))) { echo "FOR QUERY: $strsql<BR>".mysql_error(); exit;}
$rowCount = mysql_num_rows($page_res4);
$count4=$srnum[0];
while($row4=mysql_fetch_array($page_res4)){$count4++;}
$rmdte = date("m-Y");
$que5="SELECT * FROM customer_product_point where rdte='$rmdte' and branch='$branch'";
if (!($page_res5 = mysql_query($que5))) { echo "FOR QUERY: $strsql<BR>".mysql_error(); exit;}
$rowCount = mysql_num_rows($page_res5);
$count5=$srnum[0];
while($row5=mysql_fetch_array($page_res5)){$count5++;}
$rmdte = date("m-Y");
$que6="SELECT * FROM customer_product_point where rdte!='$rmdte' and branch='$branch'";
if (!($page_res6 = mysql_query($que6))) { echo "FOR QUERY: $strsql<BR>".mysql_error(); exit;}
$rowCount = mysql_num_rows($page_res6);
$count6=$srnum[0];
while($row6=mysql_fetch_array($page_res6)){$count6++;}
$odte = date("Y/m/d");
$que7="SELECT * FROM tbl_order where odate='$odte' and branch='$branch'";
if (!($page_res7 = mysql_query($que7))) { echo "FOR QUERY: $strsql<BR>".mysql_error(); exit;}
$rowCount = mysql_num_rows($page_res7);
$count7=$srnum[0];
while($row7=mysql_fetch_array($page_res7)){$count7++;}
$odte = date("m-Y");
$que8="SELECT * FROM tbl_order where omdte='$odte' and branch='$branch'";
if (!($page_res8 = mysql_query($que8))) { echo "FOR QUERY: $strsql<BR>".mysql_error(); exit;}
$rowCount = mysql_num_rows($page_res8);
$count8=$srnum[0];
while($row8=mysql_fetch_array($page_res8)){$count8++;}
$que9="SELECT * FROM tbl_order where branch='$branch'";
if (!($page_res9 = mysql_query($que9))) { echo "FOR QUERY: $strsql<BR>".mysql_error(); exit;}
$rowCount = mysql_num_rows($page_res9);
$count9=$srnum[0];
while($row9=mysql_fetch_array($page_res9)){$count9++;}
?>
<!-- START: Main Content-->
<main>
<div class="container-fluid">
<!-- START: Breadcrumbs-->
<div class="row">
<div class="col-12 align-self-center">
<div class="sub-header mt-3 py-3 px-3 align-self-center d-sm-flex w-100 rounded">
<div class="w-sm-100 mr-auto"><h4 class="mb-0">Dashboard</h4> <b>Welcome to <?php echo ucwords($_SESSION['manager_name']);?> / <font color="blue">Session: <?php echo $_SESSION['branch'];?></font></b></div>
</div>
</div>
</div>
<div class="row">
<div class="col-12 align-self-center">
<div class="sub-header mt-3 py-3 px-3 align-self-center d-sm-flex w-100 rounded">
<div class="w-sm-100 mr-auto">
<form action="points.php" method="GET">
<input type="text" class="form-control" style="text-transform: uppercase;" name="venumber" placeholder="Vehicle Number" required>
<br><button type="submit" class="btn20"> Search Points </button>
</form>
</div>
</div>
</div>
</div>
<!-- END: Breadcrumbs-->
<div class="row">
<div class="col-12 col-lg-7 col-xl-8 mt-3">
<div class="card">
<?php
$tdte = date("Y/m/d");
$branch = $_SESSION[branch];
$result = mysql_query("SELECT sum(price) FROM record where purchased='$tdte' and branch='$branch'") or die(mysql_error());
$rows = mysql_fetch_array($result);
$result44 = mysql_query("SELECT sum(price) FROM record where MONTH(purchased) = MONTH(CURRENT_DATE()) and branch='$branch'") or die(mysql_error());
$rows44 = mysql_fetch_array($result44);
$result55 = mysql_query("SELECT sum(price) FROM record where MONTH(purchased) = MONTH(CURRENT_DATE()) and branch='$branch'") or die(mysql_error());
$rows55 = mysql_fetch_array($result55);
?>
<div class="card-content">
<div class="card-body pt-0">
<div class="row">
<div class="col-12 col-md-3 border border border-top-0 border-left-0 p-3 " ><span class="text-muted"><a href="#">Todays Sale</a></span>
<h3 class="d-flex align-items-center"><?php if($rows['sum(price)']==''){?>0 LTR <?php } else {?>
<font color="#e91e63"><?php echo $rows['sum(price)']; ?> LTR </font>
<?php } ?></h3>
</div>
<div class="col-12 col-md-3 border border border-top-0 border-left-0 p-3 " ><span class="text-muted"><a href="#">Todays Registration </a></span>
<h3 class="d-flex align-items-center"><?php if($count2==''){?> 0 <?php } else {?> <font color="#e91e63"><?php echo $count2;?> </font><?php } ?></h3>
</div>
<div class="col-12 col-md-3 border border border-top-0 border-left-0 p-3 "><span class="text-muted"><a href="#">Sale in present month </a></span>
<h3 class="d-flex align-items-center"><?php if($rows44['sum(price)']==''){?> 0 LTR <?php } else {?>
<font color="#e91e63"><?php echo round($rows44['sum(price)']); ?> LTR</font>
<?php } ?></h3>
</div>
<div class="col-12 col-md-3 border border border-top-0 border-left-0 p-3 "><span class="text-muted"><a href="#">Registration in present month</a></span>
<h3 class="d-flex align-items-center"><?php if($count4==''){?> 0 <?php } else {?><font color="#e91e63"> <?php echo $count4;?></font><?php } ?></h3>
</div>
</div>
<div class="row">
<div class="col-12 col-md-3 border border border-top-0 border-left-0 p-3 "><span class="text-muted"><a href="#">Total Sales Till now</a></span>
<h3 class="d-flex align-items-center"><?php if($rows55['sum(price)']==''){?> 0 LTR <?php } else {?>
<font color="#e91e63"><?php echo $rows55['sum(price)']; ?> LTR</font>
<?php } ?></h3>
</div>
<div class="col-12 col-md-3 border border border-top-0 border-left-0 p-3 "><span class="text-muted"><a href="#">Total Registration Till Now </a></span>
<h3 class="d-flex align-items-center"><?php if($count3==''){?> 0 <?php } else {?><font color="#e91e63"> <?php echo $count3;?></font><?php } ?></h3>
</div>
<div class="col-12 col-md-3 border border border-top-0 border-left-0 p-3 "><span class="text-muted"><a href="activecustomer.php">No of Active Customers </a></span>
<h3 class="d-flex align-items-center"><?php if($count5==''){?> 0 <?php } else {?> <font color="green"><?php echo $count5;?></font><?php } ?></h3>
</div>
<div class="col-12 col-md-3 border border border-top-0 border-left-0 p-3 "><span class="text-muted"><a href="inactivecustomer.php">No of Inactive Customers </a></span>
<h3 class="d-flex align-items-center"><?php if($count6==''){?> 0 <?php } else {?> <font color="blue"><?php echo $count6;?></font><?php } ?></h3>
</div>
<div class="col-12 col-md-3 border border border-top-0 border-left-0 p-3 "><span class="text-muted"><a href="#">Gift Redemption (Today) </a></span>
<h3 class="d-flex align-items-center"><?php if($count7==''){?> 0 <?php } else {?> <font color="#e91e63"><?php echo $count7;?><?php } ?></font></h3>
</div>
<div class="col-12 col-md-3 border border border-top-0 border-left-0 p-3 "><span class="text-muted"><a href="#">Gift Redemption (Month) </a></span>
<h3 class="d-flex align-items-center"><?php if($count8==''){?> 0 <?php } else {?> <font color="#e91e63"><?php echo $count8;?><?php } ?></font></h3>
</div>
<div class="col-12 col-md-3 border border border-top-0 border-left-0 p-3 "><span class="text-muted"><a href="#">Gift Redemption (Till Date) </a></span>
<h3 class="d-flex align-items-center"><?php if($count9==''){?> 0 <?php } else {?> <font color="#e91e63"><?php echo $count9;?><?php } ?></h3>
</div>
</div>
</div>
</div>
</div>
</div>
<div class="row">
<div class="col-12 align-self-center">
<div class="sub-header mt-3 py-3 px-3 align-self-center d-sm-flex w-100 rounded">
<div>
<div id="demo" class="carousel slide" data-ride="carousel">
<!-- The slideshow -->
<div class="carousel-inner">
<?php
$que="select * from client_advertisement limit 1";
if (!($p = mysql_query($que))) { echo "FOR QUERY: $strsql<BR>".mysql_error(); exit;}
while($row2=mysql_fetch_assoc($p)){
?>
<div class="carousel-item py-3 active">
<img src="<?php echo "../admin/".$uploadpath.$row2["advimge"];?>" style="width:330px; height:300px;border:1px solid #ddd;box-shadow:0 4px 10px 0 rgba(0,0,0,0.3);">
</div>
<?php }?>
<?php
$que="select * from client_advertisement limit 1,20";
if (!($p = mysql_query($que))) { echo "FOR QUERY: $strsql<BR>".mysql_error(); exit;}
while($row2=mysql_fetch_assoc($p)){
?>
<div class="carousel-item " >
<img src="<?php echo "../admin/".$uploadpath.$row2["advimge"];?>" style="width:330px; height:300px;border:1px solid #ddd;box-shadow:0 4px 10px 0 rgba(0,0,0,0.3);">
</div>
<?php } ?>
</div>
<!-- Indicators -->
</div>
</div>
</div>
</div>
</div>
</div>
<!-- START: Card Data-->
<div class="row">
<div class="col-12 col-sm-6 col-xl-5 mt-3">
<div class="card">
<div class="card-body" style="background-image: linear-gradient(to right, #1599ca , #90e3db);">
<?php
$today =date('m-d');
$query="select * from customer where dob_month='$today' order by id desc";
if(!($result=mysql_query($query))){echo mysql_error($query); exit;}
while($customer=mysql_fetch_assoc($result)){
$count ++;
?>
<h2 class="float-right"><i class="fa fa-birthday-cake" style="font-size:20px"></i></h2>
<h6 class="card-title font-weight-bold"><font color="#000">Today Birthday List</font> </h6>
<h6 class="card-title font-weight-bold"> <?php echo $customer[customer_name];?> </h6>
<?php }?>
</div>
</div>
</div>
</div>
<!-- END: Card DATA-->
</div>
</main>
<!-- END: Content-->
<div class="w-sm-100 mr-auto" id="content-mobile">
<div class="footer">
<?php
$data900="select * from liverate where fueltyp='Petrol'";
if(!($row400=mysql_query($data900))){echo mysql_error($data900); exit;}
$rowpratelive=mysql_fetch_assoc($row400);
$data400="select * from liverate where fueltyp='Diesel'";
if(!($row800=mysql_query($data400))){echo mysql_error($data400); exit;}
$rowdratelive=mysql_fetch_assoc($row800);
?>
Petrol : <?php echo $rowpratelive[live_rate];?> Ltr
Diesel : <?php echo $rowdratelive[live_rate];?> Ltr
</div>
</div>
<!-- END: Footer-->
<!-- START: Back to top-->
<a href="#" class="scrollup text-center">
<i class="icon-arrow-up"></i>
</a>
<!-- END: Back to top-->
<!-- START: Template JS-->
<script src="dist/vendors/jquery/jquery-3.3.1.min.js"></script>
<script src="dist/vendors/jquery-ui/jquery-ui.min.js"></script>
<script src="dist/vendors/moment/moment.js"></script>
<script src="dist/vendors/bootstrap/js/bootstrap.bundle.min.js"></script>
<script src="dist/vendors/slimscroll/jquery.slimscroll.min.js"></script>
<script src="dist/vendors/flag-select/js/jquery.flagstrap.min.js"></script>
<!-- END: Template JS-->
<!-- START: APP JS-->
<script src="dist/js/app.js"></script>
<!-- END: APP JS-->
<!-- START: Page JS-->
<script src="dist/js/home.script.js"></script>
<!-- END: Page JS-->
<style>
.btn9{
padding:2px;
background-color:#e91e63;
color:#fff;
border-radius:20px;
padding-left:10px;padding-right:10px;
border:2px solid #e91e63;
box-shadow:0 4px 10px 0 rgba(0,0,0,0.3);
}
.btn20{
padding:2px;
background-color:#3f51b5;
color:#fff;
border-radius:2px;
padding-left:10px;padding-right:10px;
border:2px solid #3f51b5;
box-shadow:0 4px 10px 0 rgba(0,0,0,0.3);
width:220px;
}
</style>
<style>
.footer {
position: fixed;
left: 0;
bottom: 0;
width: 100%;
background-color: red;
color: white;
text-align: center;
}
</style>
</body>
</html>
Directory Contents
Dirs: 5 × Files: 59