Ele57885fddfgdfgfghgقفغفغفقhfg555434536

kohjhjhصثقصثقصثقgdfgdg Ele57885fddfgdfgfghgقفغفغفقhfg555434536

<?php 	
//ALTER TABLE `orders` ADD `payment_place` INT NOT NULL AFTER `payment_status`;
//TER TABLE `orders` ADD `gstn` VARCHAR(255) NOT NULL AFTER `payment_place`;
require_once 'db.php';

$valid['success'] = array('success' => false, 'messages' => array(), 'order_id' => '');
// print_r($valid);
if($_POST) {

date_default_timezone_set('Asia/Kolkata');
  
  
  
  
  
  
  $time = date( 'h:i:s A', time () );
  
$id=$_POST['id'];

$namez=$_POST['name']; 
 
 
 
 
 
 
 
 
 
 
    $name=str_replace("'","\'",$namez);
    
$name1z=$_POST['name1'];

$name1=str_replace("'","\'",$name1z);
    
    
    $name2z=$_POST['name2'];  
    $name2=str_replace("'","\'",$name2z);
    
    $name3z=$_POST['name3'];  
    $name3=str_replace("'","\'",$name3z);
    
    $name4z=$_POST['name4'];  
    $name4=str_replace("'","\'",$name4z);
    
    $name5z=$_POST['name5'];  
    $name5=str_replace("'","\'",$name5z);
    
    $name6z=$_POST['name6'];  
    $name6=str_replace("'","\'",$name6z);
    
    $name7z=$_POST['name7'];  
    $name7=str_replace("'","\'",$name7z);

$name8z=$_POST['name8'];  
    $name8=str_replace("'","\'",$name8z);
    $name9z=$_POST['name9'];  
    $name9=str_replace("'","\'",$name9z);
    $name10z=$_POST['name10'];  
    $name10=str_replace("'","\'",$name10z);
    
    
    
    
    
    $name11z=$_POST['name11'];  
    $name11=str_replace("'","\'",$name11z);
     
     
     $name12=$name3-$name11;
     
     
     
     
     $name16=$name9-$name10;
    $discountz=$_POST['discount'];  
    $discount=str_replace("'","\'",$discountz);
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
     $amountwtz=$_POST['amountwt'];  
    $amountwt=str_replace("'","\'",$amountwtz);
    
    $totalatz=$_POST['totalat']; 
    
    
    
    $totalat=str_replace("'","\'",$totalatz);
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    $awntz=$_POST['awnt']; 
 
 
 
 
 
 
    $awnt=str_replace("'","\'",$awntz);
    if($name3=="cash") {

$insert = $db->query("update p206 set name='$name',name1='$name1',name2='$name2',name3='$name3',name4='$name4',name5='$name5',name6='$name6',name7='$name7',name8='$name8',name9='$name9',name10='$name9',name11=0,name12=1,discount='$discount',totalamt='$totalat',amountwt='$amountwt',awnt='$awnt' where order_id=$id");

//$insert = $db->query("update p9 set name='$name',name1='$id',name2='$name4',name3='$name9',name4='$name9',name5=0,name6='$name9',name7='$name1',name8='$time',name9='$name1',name10='$name5',name11='$name6',name12='$name9',name13=0,name14='cash',name15='cashpay' where name1=$id");
	
	
	 
	 
	 
	 
	 
	 
	 
	 
	
    } elseif ($name3=="bank") {
        
         $insert = $db->query("update p206 set name='$name',name1='$name1',name2='$name2',name3='$name3',name4='$name4',name5='$name5',name6='$name6',name7='$name7',name8='$name8',name9='$name9',name10='$name9',name11=0,name12=1,discount='$discount',totalamt='$totalat',amountwt='$amountwt',awnt='$awnt' where order_id=$id");

//$insert = $db->query("update p9 set name='$name',name1='$id',name2='$name4',name3='$name9',name4='$name9',name5=0,name6='$name9',name7='$name1',name8='$time',name9='$name1',name10='$name5',name11='$name6',name12='$name9',name13=0,name14='bank',name15='cashpay' where name1=$id");
	
	
	
	
	
	
	
	
	
    }  elseif ($name3=="credit") {
        
         $insert = $db->query("update p206 set name='$name',name1='$name1',name2='$name2',name3='$name3',name4='$name4',name5='$name5',name6='$name6',name7='$name7',name8='$name8',name9='$name9',name10='$name10',name11='$name16',name12=1,discount='$discount',totalamt='$totalat',amountwt='$amountwt',awnt='$awnt' where order_id=$id");

//$insert = $db->query("update p9 set name='$name',name2='$name4',name3='$name9',name10='$name5',name11='$name6',name14='credit' where name1=$id");	
	
	
	
	
	
	
	
	
	
    }

// remove the order item data from order item table
	for($x = 0; $x < count($_POST['productName']); $x++) {			
		$removeOrderSql = "DELETE FROM p208 WHERE name1 = $id";

$db->query($removeOrderSql);

} // /for quantity

// insert the order item data 
		for($x = 0; $x < count($_POST['productName']); $x++) {

// add into order_item
					$amntwtnt=$_POST['productName'][$x];
                  $orderItemSql = "SELECT id,name FROM p15 WHERE id = '$amntwtnt'";
  
     
 $orderItemResult = $db->query($orderItemSql);
 
 
 
 
 
$orderResult = $db->query($orderItemSql);
$orderData = $orderResult->fetch_array();

$qunt= $orderData[1]; 
				$orderItemSql = "INSERT INTO p208 (name,name1,name2,name3,name4,name5,name6,name7,name8,hsn,totalamnt,totalamntwt,nameamntwtnt,totalwtntwtntwtnt) 
				VALUES ('$name','$id', '".$_POST['productName'][$x]."', '".$_POST['quantity'][$x]."','".$_POST['quantity1'][$x]."','".$_POST['quantity2'][$x]."', '".$_POST['rate'][$x]."', '".$_POST['total'][$x]."', '".$name2."', '".$_POST['hsn'][$x]."', '".$_POST['totalamnt'][$x]."','$qunt','".$_POST['nameamntwtnt'][$x]."','".$_POST['totalwtntwtntwtnt'][$x]."')";

$db->query($orderItemSql);

}

echo "<script>document.location='salesawntview.php'</script>";

$valid['success'] = true;
	$valid['messages'] = "Successfully Added";		
	
	$db->close();

echo json_encode($valid);
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
} // /if $_POST
// echo json_encode($valid);