<?php 
error_reporting(0);
//echo hello;
//include("common.php");
include("config.php");

date_default_timezone_set('Asia/Kolkata');
$rtime = date( 'h:i:s A', time () );

$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);
		  
		   $quantity =$_SESSION['product_count'][$i];
	
			 $odate = date("Y/m/d");
			   $vehiclenumber =$_SESSION['vehiclenumber'];
			     $branch =$_SESSION['branch'];
				 $mob = $_POST['mobile'] ;
			   
			$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', pqty='$quantity',
				vehicle_number ='$vehiclenumber',
			    odate='%s',  otime='$rtime', 
				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;}	
				
				 $query_debit=sprintf("INSERT INTO record  set cid ='$ccid',fueltyp='Petrol/Disel',mobile='$mob',
				 debit='$point_item_total',narration='gift',purchased='$odate',   ptime='$rtime',branch='$branch' "); 
		        if(!($rowdebit=mysql_query($query_debit))){echo $query_debit.mysql_error(); exit;}
				
				
				
				$stock =  $row_cart['qty'];
				$avilable_qty =  $stock - $quantity; 
					 
				    $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];
				  $mobile = $rowcart2[mobile];
			      $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;}
		
	/*         
$message = urlencode("Redemption Successful for ".$point_item_total." Points. Please Collect Gift. - Road Ka Raja");
$mobile = $mobile;

$curl = curl_init();

curl_setopt_array($curl, array(
  CURLOPT_URL => 'http://bulksmsindia.mobi/sendurlcomma.aspx?user=20064497&pwd=Prasad@0509&senderid=RKRAJA&mobileno='.$mobile.'&msgtext='.$message.'&smstype=0',
  CURLOPT_RETURNTRANSFER => true,
  CURLOPT_ENCODING => '',
  CURLOPT_MAXREDIRS => 10,
  CURLOPT_TIMEOUT => 0,
  CURLOPT_FOLLOWLOCATION => true,
  CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
  CURLOPT_CUSTOMREQUEST => 'GET',
  CURLOPT_HTTPHEADER => array(
    'Cookie: ASP.NET_SessionId=qojdkmyjuhbrhodcflxie1mj'
  ),
));

$response = curl_exec($curl);

curl_close($curl);
	*/

	
?>
<meta http-equiv="refresh" content="2;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">
                           <center> <div class="w-sm-100 mr-auto"><h4 class="mb-0">Process Done</h4></div></center>

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

<br> <br>  wait page redirect mode....
</center>
</h2>
</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>
        
        <!-- 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>