<?php 
//error_reporting(0);

include("common.php");
include("config.php");



$flag = $_REQUEST[flag];


		$_SESSION['product_ids']; 
		$count = count($_SESSION['product_ids']);
	//echo $count; exit;
	    $i=0;

 while($i<$count)  
	  {
		     $ccid = $_SESSION['cusid'];
			 
			 $que = sprintf("Select * from product WHERE id = '%d' ",$_SESSION['product_ids'][$i]);
		  if(!($res=mysql_query($que))){echo "Error : - ".$que.mysql_error(); exit;}
		 $row_cart = mysql_fetch_array($res);
		  
		  
	
			 $odate = date("Y/m/d");
			   $vehiclenumber =$_SESSION['vehiclenumber'];
			     $branch =$_SESSION['branch'];
			   
			$monthdte = date("m-Y");
                $six_digit_random_number = mt_rand(100000, 999999);
                  $quantity =$_SESSION['product_count'][$i];
			  //$uid=$_SESSION['user_info_id']; // User id
			 		 $point_item_total = $_SESSION['item_total_point'];  
		        $qadd=sprintf("INSERT INTO 	tbl_order set 
				trans_id ='%s',
				vehicle_number ='$vehiclenumber',
			    odate='%s',  omdte='$monthdte', 
				point ='%s',
				cid ='%s',
				pid = '%d',branch='$branch'
				", $six_digit_random_number, $odate,  $point_item_total, $ccid,  $_SESSION['product_ids'][$i]);  
				
				if(!($res1=mysql_query($qadd))){echo $qadd.mysql_error(); exit;}	
				
				//$stock =  $row_cart['qty'];
				//$avilable_qty =  $stock - 1; 
					 
				    //$query_update=sprintf("UPDATE product SET qty='%s' where id='%d' ",$avilable_qty,$_SESSION['product_ids'][$i]); 
					//if(!($result=mysql_query($query_update))){echo $query_update.mysql_error(); exit;} 	   
				  
		 //$cid = $_SESSION['cusid'];			   
		//echo $query_debit=sprintf("INSERT INTO record  set debit='$point' , cid ='$cid'"); exit;
		//if(!($rowdebit=mysql_query($query_debit))){echo $query_debit.mysql_error(); exit;}
				  
				$i++; }
	 $ccid = $_SESSION['cusid'];			
	$que2 = sprintf("Select * from customer_product_point WHERE cid = '%d' ",$ccid); 
		  if(!($res2=mysql_query($que2))){echo "Error : - ".$que2.mysql_error(); exit;}
		 $rowcart2 = mysql_fetch_array($res2);
				 
				 $mypoint = $rowcart2[point];
			      $productqty =   $mypoint - $point_item_total;
		                
		 $query_up=sprintf("UPDATE customer_product_point SET  point='$productqty' WHERE cid='%d' ",$ccid); 
		if(!($resu=mysql_query($query_up))){echo $query_up.mysql_error(); exit;}
		
		
	
?>
<meta http-equiv="refresh" content="3;url=customer-gift-list.php?flag=gift">  
        <!-- 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">Process Done</h4></div>

                        </div>
                    </div>
                </div>
				<div class="row">
				 <div class="col-12 align-self-center" style="background-color:#fff">
                    <h5 style="padding-left:20px;">
<b>Congratulation!  <br> You have won product. Collect your products in store room. <br>
Thank You!<br>
Please Drive Safely..</b>
</h5>
</div>
 </div>
                     
                <!-- END: Breadcrumbs-->

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


        <!-- 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>
		.btn4{
			padding:4px;
			background-color:#e91e63;
			color:#fff;
			border-radius:20px;
			padding-left:20px;padding-right:20px;
			border:2px solid #e91e63;
			box-shadow:0 4px 10px 0 rgba(0,0,0,0.3);
			width:150px;
		}
		.btn8{
			padding:2px;
			background-color:#f44336;
			color:#fff;
			border-radius:20px;
			padding-left:20px;padding-right:20px;
			border:2px solid #f44336;
			box-shadow:0 4px 10px 0 rgba(0,0,0,0.3);
			width:200px;
		}
		
		</style>
    </body>
 
</html>
