<?php 
error_reporting(0);
include("common.php"); 
?>

     <title> Active Customers List </title>
        <!-- START: Main Content-->
        <main>
            <div class="container-fluid">
                <!-- START: Breadcrumbs-->
              
                <!-- END: Breadcrumbs-->

                <!-- START: Card Data-->
                <div class="row">
                    <div class="col-12 mt-3">
                        <div class="card">
                            <div class="card-header  justify-content-between align-items-center">                               
                                <h4 class="card-title">Active Customers List</h4> 
                            </div>
                            <div class="card-body">
                                <div class="table-responsive">
                                    <table id="example" class="display table dataTable table-striped table-bordered" >
                                        <thead>
                                            <tr>
											 <th>#</th>
											 <th>Last Visit</th>
											 <th> Name</th>
											  <th>Vehicle Number</th>
                                       <th>Vehicle Type</th> 											  
											<th>Driver Phone </th>
											<th>Phone </th>
                                             <th>Birth Date</th>
											  <th>Route from</th> 
											    <th>Route to</th> 
											   <th>Urea Required</th> 
											<th>Company Name</th> 
											   <th>Owner Name</th> 
											   <th>Owner Phone</th> 
											  
											  
                                            </tr>
                                        </thead>
                                        <tbody>
										<?php
										error_reporting(0);
										include("config.php");
									 $rmdte = date("m-Y");
									 $branch = $_SESSION[branch];
  $que55="SELECT * FROM customer_product_point where rdte='$rmdte' and branch='$branch' order by id";			
if (!($page_res55 = mysql_query($que55))) { echo "FOR QUERY: $strsql<BR>".mysql_error(); exit;}
$rowCount = mysql_num_rows($page_res55);
$count55=$srnum[0];
while($row55=mysql_fetch_array($page_res55)){
	$count55++;
		
		
		  $que = sprintf("SELECT * from  customer WHERE id = '%s' ",$row55['cid']);
                               if(!($res=mysql_query($que))){echo mysql_error($que); exit;}
                                  $customerdata=mysql_fetch_assoc($res);
								  
								  $que4 = sprintf("SELECT * from  record WHERE id = '%s' ",$row55['cid']);
                               if(!($res4=mysql_query($que4))){echo mysql_error($que4); exit;}
                                  $customerdatasell=mysql_fetch_assoc($res);
	?>
                                            <tr>
										
					
						
                                                <td><?php echo $count55;?></td>
												 <td><?php echo date('d/M Y',strtotime($row55['purchased'])); ?></td>
												 
											 <td><?php echo ucfirst($customerdata[customer_name]);?></td>
												  <td><?php echo strtoupper($customerdata[vehicle_number]);?></td>
												    <td><?php echo $customerdata[vehicletyp];?></td>
											 <td><?php echo ucfirst($customerdata[customer_mobile]);?></td>
											  <td> <?php echo ucfirst($customerdata[mobile2]);?></td>
                                                <td><?php echo date('d/M Y',strtotime($customerdata['dob'])); ?></td>
												   <td><?php echo $customerdata[routefrom];?></td>
												    <td><?php echo $customerdata[routeto];?></td>
												    <td><?php echo $customerdata[urea];?></td>
                                              <td><?php echo ucfirst($customerdata[companyname]);?></td>
												    <td><?php echo ucfirst($customerdata[owner]);?></td>
													 <td><?php echo ucfirst($customerdata[ownermobile]);?></td>
													 
											
                                  
                                             
                                            </tr>
	<?php } ?>
                                          
                                           
                                        </tbody>
                            
                                    </table>
                                </div>
                            </div>
                        </div> 

                    </div>                  
                </div>
                <!-- END: Card DATA-->
            </div>
        </main>
        <!-- END: Content-->

      
        <!-- 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/datatable/js/jquery.dataTables.min.js"></script> 
        <script src="dist/vendors/datatable/js/dataTables.bootstrap4.min.js"></script>
        <script src="dist/vendors/datatable/jszip/jszip.min.js"></script>
        <script src="dist/vendors/datatable/pdfmake/pdfmake.min.js"></script>
        <script src="dist/vendors/datatable/pdfmake/vfs_fonts.js"></script>
        <script src="dist/vendors/datatable/buttons/js/dataTables.buttons.min.js"></script>
        <script src="dist/vendors/datatable/buttons/js/buttons.bootstrap4.min.js"></script>
        <script src="dist/vendors/datatable/buttons/js/buttons.colVis.min.js"></script>
        <script src="dist/vendors/datatable/buttons/js/buttons.flash.min.js"></script>
        <script src="dist/vendors/datatable/buttons/js/buttons.html5.min.js"></script>
        <script src="dist/vendors/datatable/buttons/js/buttons.print.min.js"></script>
        <!-- END: Page Vendor JS-->

        <!-- START: Page Script JS-->        
        <script src="dist/js/datatable.script.js"></script>
		
        <!-- END: Page Script JS-->
    </body>
   
</html>