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

   <script>
setTimeout(function(){ 
    $('#myData').hide();
}, 6000);
</script>    
        <!-- START: Main Content-->
        <main>
            <div class="container-fluid">
                <!-- START: 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">Gift Redemption</h4> 
								  <?php 
										
								         if($_GET[flag]=="gift") {?>
										<center><div style="font-size:20px;" id="myData" >
										<span class="label label-danger">
										Gift Redemption successfully ..
										</div></center>	<br/>	
										<?php } ?>
                            </div>
                            <div class="card-body">
                                <div class="table-responsive">
                                    <table id="example" class="display table dataTable table-striped table-bordered" >
                                        <thead>
                                            <tr>
											 <th><center>Sr.</center></th>
											 <th><center>Customer Name</center></th>
											  <th><center>Branch</center></th>
											  <th><center>Vehicle Number</center> </th>
											   <th><center>Points </center></th>
											
                                             
											   <th></th>
                                            </tr>
                                        </thead>
                                        <tbody>
										<?php
										error_reporting(0);
										include("config.php");
										 $branch = $_SESSION['branch'];
									//$query="select * from customer where  branch='$branch' order by id desc";
									$query="select * from customer order by id desc";
    if(!($result=mysql_query($query))){echo mysql_error($query); exit;}
    while($customer=mysql_fetch_assoc($result)){
		$count ++;
		
		 $que = sprintf("SELECT * from  customer_product_point WHERE cid = '%s' ",$customer['id']);
    if(!($res=mysql_query($que))){echo mysql_error($que); exit;}
    $cis_data=mysql_fetch_assoc($res);
		
	?>
                                            <tr>
										
						
						<form action="eproduct-list.php" method="POST"> 
						<td><center> <b><?php echo $count;?> </b> </center></td>
                                                <td><center> 
												 
												
												<b><?php echo ucfirst($customer[customer_name]);?> 
												<br> <small><?php echo $customer[customer_mobile];?> </small></b> </center></td>
												<td>  
												<center><?php if($customer[branch]=='B1'){?> GNA <?php } ?>
							<?php if($customer[branch]=='B2'){?> RSM <?php } ?>
							<?php if($customer[branch]=='B3'){?> JHU <?php } ?>
							<?php if($customer[branch]=='B4'){?> GNAP <?php } ?>
							<?php if($customer[branch]=='B5'){?> JHUP <?php } ?> </center></td>
												<td><center> <b><?php echo strtoupper($customer[vehicle_number]);?> </b> </center></td>
												<td><center><b>
												<?php if($cis_data[point]==''){?> 0 p <?php } else { ?>
												<?php echo $cis_data[point];?> p 
												<?php } ?>
												</b> </center></td>
												
												<input type="hidden" name="vnumber" value="<?php echo $customer[vehicle_number];?>">
												<input type="hidden" name="cusid" value="<?php echo $customer[id];?>">
												<input type="hidden" name="cname" value="<?php echo $customer[customer_name];?>">
												
									
             <td> <button type="submit" class="btn3"> <b>Manage Gift </b></button></td>    
    </form>			 
                                            </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>
		<style>
	

		.btn2{
			padding:4px;
			background-color:#ffeb3b;
			color:#000;
			border-radius:20px;
			padding-left:10px;padding-right:8px;
			border:2px solid #ffeb3b;
			box-shadow:0 4px 10px 0 rgba(0,0,0,0.3);
			width:200px;
		}
		.btn3{
			padding:4px;
			background-color:#1ea5a521;
			color:#000;
			border-radius:20px;
			padding-left:10px;padding-right:8px;
			border:2px solid #1ea5a521;
			box-shadow:0 4px 10px 0 rgba(0,0,0,0.3);
			width:200px;
		}
		</style>
        <!-- END: Page Script JS-->
    </body>
   
</html>