<?php 
error_reporting(0);

@session_start();
include("common.php"); 

?>

     
        <!-- 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 report</h4> 
                            </div>
                            <div class="card-body">
                                <div class="table-responsive">
                                    <table id="example" class="display table dataTable table-striped table-bordered" >
                                        <thead>
                                            <tr>
											
											 <th>Order Date </th>
											  <th>Vehicle Number</th>
											   <th>Customer Name</th>
											    <th>Mobile</th>
											   
											  <th>Gift </th>
											  <th>Product Name </th>
											   <th>Debit Point </th>
											    <th>Bal Point </th>
											  <th> </th>
											
                                            </tr>
                                        </thead>
                                        <tbody>
										<?php
										//error_reporting(0);
										include("config.php");
										$branch =  $_SESSION['branch'];
										//$vnumber = $_GET[vnumber];
										//$vnumber = $_SESSION['vehiclenumber'];
	 $query="select * from tbl_order  where branch='$branch' and pid!='0' order by id desc";
    if(!($result=mysql_query($query))){echo mysql_error($query); exit;}
    while($rowdata=mysql_fetch_assoc($result)){
		$count ++;
		
		  $que = sprintf("SELECT * from  product WHERE id = '%s' ",$rowdata['pid']);
    if(!($res=mysql_query($que))){echo mysql_error($que); exit;}
    $pro_data=mysql_fetch_assoc($res);
		
		 $que3 = sprintf("SELECT * from  customer WHERE id = '%s' ",$rowdata['cid']);
    if(!($res3=mysql_query($que3))){echo mysql_error($que3); exit;}
    $cusdata=mysql_fetch_assoc($res3);
	
	$que4 = sprintf("SELECT * from  customer_product_point WHERE cid = '%s' ",$rowdata['cid']);
    if(!($res4=mysql_query($que4))){echo mysql_error($que4); exit;}
    $cuspointdata=mysql_fetch_assoc($res4);
		
	?>
         <tr>
		
		 <td><?php echo $rowdata[odate];?> </td>
											 <td><b><?php echo strtoupper($rowdata[vehicle_number]);?></b> </td>
											  <td><?php echo ucwords($cusdata[customer_name]);?> </td>
											  <td><?php echo $cusdata[customer_mobile];?> </td>
                                                <td><img src="<?php echo "../admin/".$uploadpath.$pro_data["pimg"];?>" style="width:60px; height:60px;border:1px solid #ddd;"></td>
												<td><?php echo $pro_data[proname];?></td>
												<td><font color="green"><b><?php echo $pro_data[point];?> p</b></font></td>
												<td><font color="blue"><b><?php echo $cuspointdata[point];?> p</b></font></td>
                                              <td><a class="btn3" title="delete" href="del-order.php?flag=del&id=<?php echo $rowdata[id];?>"onclick="if(confirm('Do You Want To Delete This ?')){return true;}else{return false;}">
                <i class="fa fa-trash icon-white"></i>
                 
            </a></td>
			                   
	<?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>