<?php 
error_reporting(0);
@session_start();
include("common.php"); 
include("config.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 Admin /  <font color="blue">
							Session: 
							<?php if($_SESSION['branch']=='B1'){?> GNA <?php } ?>
							<?php if($_SESSION['branch']=='B2'){?> RSM <?php } ?>
							<?php if($_SESSION['branch']=='B3'){?> JHU <?php } ?>
							<?php if($_SESSION['branch']=='B4'){?> GNAP <?php } ?>
							<?php if($_SESSION['branch']=='B5'){?> JHUP <?php } ?>
							
							(<?php echo $_SESSION['branch'];?>)</font></b></div>

                           
                        </div>
                    </div>
                </div>
				
				  <?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-4 border border border-top-0 border-left-0 p-3 " ><span class="text-muted"><a href="#"> Sale Today</a></span>
                                            <h3 class="d-flex  align-items-center"><?php if($rows['sum(price)']==''){?>0 LTR <?php } else {?>
								<font color="#e91e63"><?php echo round($rows['sum(price)']); ?> LTR </font>
								<?php } ?></h3>
                                        </div>
                                        <div class="col-12 col-md-4 border border border-top-0 border-left-0 p-3 " ><span class="text-muted"><a href="#">Registration Today  </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-4 border border border-top-0 border-left-0 p-3 "><span class="text-muted"><a href="#">Gift 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-4 border border border-top-0 border-left-0 p-3 "><span class="text-muted"><a href="#">Sale 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-4 border border border-top-0 border-left-0 p-3 "><span class="text-muted"><a href="#">Registration 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 class="col-12 col-md-4 border border border-top-0 border-left-0 p-3 "><span class="text-muted"><a href="#">Gift Month </a></span>
                                            <h3 class="d-flex  align-items-center"><?php if($count8==''){?> 0 <?php } else {?> <font color="#e91e63"><?php echo $count8;?></font><?php } ?></font></h3>
                                        </div>
                                        
                                       
                                    </div>
									   <div class="row">
									 <div class="col-12 col-md-4 border border border-top-0 border-left-0 p-3 "><span class="text-muted"><a href="#"> Sale Total</a></span>
                                           <h3 class="d-flex  align-items-center"><?php if($rows55['sum(price)']==''){?> 0 LTR <?php } else {?>
								<font color="#e91e63"><?php echo round($rows55['sum(price)']); ?> LTR</font>
								<?php } ?></h3>
                                        </div>
                                        <div class="col-12 col-md-4 border border border-top-0 border-left-0 p-3 "><span class="text-muted"><a href="#">Registration Total    </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-4 border border border-top-0 border-left-0 p-3 "><span class="text-muted"><a href="#">Gift Total  </a></span>
                                            <h3 class="d-flex  align-items-center"><?php if($count9==''){?> 0 <?php } else {?> <font color="#e91e63"><?php echo $count9;?></font><?php } ?></h3>
                                        </div>
										 
										 <div class="col-12 col-md-6 border border border-top-0 border-left-0 p-3 "><span class="text-muted"><a href="activecustomer.php"> 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-6 border border border-top-0 border-left-0 p-3 "><span class="text-muted"><a href="inactivecustomer.php">Inactive Customers </a></span>
                                            <h3 class="d-flex  align-items-center"><?php if($count6==''){?> 0 <?php } else {?>  <font color="red"><?php echo $count6;?></font><?php } ?></h3>
                                        </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"> 
							 <?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); 

                        ?>
  <button type="button" class="btn9"> Petrol : <b><?php echo $rowpratelive[live_rate];?> Ltr </b></button>  
 <button type="button" class="btn9"> Diesel : <b><?php echo $rowdratelive[live_rate];?>  Ltr </b></button>     
							
							 </div>

                           
                        </div>
                    </div>
                </div>
                <!-- END: Breadcrumbs-->

                <!-- START: Card Data-->
                <div class="row">
                   
                  
                    <div class="col-12  col-lg-5 col-xl-8 mt-3">
                        <div class="card">
                           
			 
		
							
							
							  <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
							$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);
					           ?> 
							
                                <h2 class="float-right"><font color="#000">
								<?php if($rows['sum(price)']==''){?> 0 LTR <?php } else {?>
								<?php echo $rows['sum(price)']; ?> LTR</font>
								<?php } ?>
								</h2>
								
							
								
								 <h6 class="card-title font-weight-bold"><font color="#000">Today Sell LTR</font> </h6>
                                <h6 class="card-title font-weight-bold">  <?php echo date('d-m-Y');?> </h6>
								
							 <hr>
								
                            </div>
							
							
							
                        </div>  
							  
							  
							  
							  
							  
							  
                        <div class="card">
                            <div class="card-body" style="background-color:#ffeb3b">
							<?php
							 $data="select * from commission order by id desc";
					   if(!($row=mysql_query($data))){echo mysql_error($data); exit;}
						while($rowrte=mysql_fetch_assoc($row)){?> 
							
                                <h5 class="float-right"><a href="edit-discount.php?id= <?php echo $rowrte[id];?>"><i class="fa fa-edit icon-white"></i></a><br>
								<?php echo $rowrte[fueltyp];?>
								</h5>
								 <h6 class="card-title font-weight-bold"><font color="#b74d0e"><?php echo $rowrte[cardtyp];?></font> </h6>
                                <h6 class="card-title font-weight-bold"><?php echo $rowrte[paise];?>point (per LTR)</h6>
								<p>Update Date: <br><?php echo date('d-m-Y',strtotime($rowrte['updte'])); ?>  </p>
							 <hr>
							 <?php } ?>
							 
                            </div>
							
							
                        </div>
						<div class="card">
                            <div class="card-body" style="background-image: linear-gradient(to right, #1599ca , #90e3db);">
							<?php
							 $today =date('m-d'); $branch = $_SESSION[branch];
							 
									 $query="select * from customer where dob_month='$today' and branch='$branch' 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>
                    </div>
					
                  
                
                </div>
                <!-- END: Card DATA-->
            </div>
        </main>
        <!-- END: Content-->

        <!-- START: Footer-->
        <footer class="site-footer">© 2022 Road Ka Raja</footer>
        <!-- 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 Vendor JS-->
        <script src="dist/vendors/raphael/raphael.min.js"></script>
        <script src="dist/vendors/morris/morris.min.js"></script>
        <script src="dist/vendors/chartjs/Chart.min.js"></script>
        <script src="dist/vendors/starrr/starrr.js"></script>
        <script src="dist/vendors/jquery-flot/jquery.canvaswrapper.js"></script>
        <script src="dist/vendors/jquery-flot/jquery.colorhelpers.js"></script>
        <script src="dist/vendors/jquery-flot/jquery.flot.js"></script>
        <script src="dist/vendors/jquery-flot/jquery.flot.saturated.js"></script>
        <script src="dist/vendors/jquery-flot/jquery.flot.browser.js"></script>
        <script src="dist/vendors/jquery-flot/jquery.flot.drawSeries.js"></script>
        <script src="dist/vendors/jquery-flot/jquery.flot.uiConstants.js"></script>
        <script src="dist/vendors/jquery-flot/jquery.flot.legend.js"></script>
        <script src="dist/vendors/jquery-flot/jquery.flot.pie.js"></script>
        
        <!-- END: Page Vendor JS-->
 <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js"></script>
  <script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.4.1/js/bootstrap.min.js"></script>
        <!-- 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);
		}
		
		
		</style>
		<style>

div.b {
  position: absolute;
  left: 40px;
  width: 100px;
  height: 280px;
 
} 

div.c {
  position: absolute;
  left: 100px;
  width: 200px;
  height: 280px;
 
} 
div.d {
  position: absolute;
  left: 220px;
  width: 200px;
  height: 280px;
 
} 
</style>
    </body>
 
</html>