PHP Decode

<?php include('../connectfile.php');if(isset($_POST['type']) == 'sales_prod'){	$row_num = $_POST['row_num'];	$name = $_POST['name_startsWith'];	$query = "SELECT * FROM product_basic WHERE UPPER(product_barcode) LIKE '%".strtoupper($name)."%' OR UPPER(product_name) LIKE '%".strtoupper($name)."%' ORDER BY product_name ASC";	$result = $mysqli->query($query);	$data = array();	while ($row = $result->fetch_assoc()) {			$name = $row['id'].'|'.$row['product_name'].' ('.$row['product_barcode'].')|'.$row['product_barcode'].'|'.$row['product_tax'];		array_push($data, $name);		}		echo json_encode($data);}if(isset($_GET['proid']) && isset($_GET['batchno'])){	$proid=$_GET["proid"];	$batchno=$_GET["batchno"];	$query = "SELECT * FROM `stock` WHERE stock_proid = '$proid' AND stock_batchno='$batchno'";	$result = $mysqli->query($query);	$row = $result->fetch_assoc();	if(isset($_GET['qtytype']))	{		$qtytype=$_GET["qtytype"];		if($qtytype=="BOX")		{			echo $row['stock_selrate'].'|'. $row['stock_mrp_bulk'];		}		else		{			echo $row['stock_selrate'].'|'. $row['stock_mrp_item'];		}		}	else	{		echo $row['stock_selrate'].'|'. $row['stock_mrp_bulk'];	}}/*NEW SALE AUTO DISPLAY IN QTY AND SALES RATE*/if(isset($_GET['salesbatch'])){	$salesid=$_GET["salesid"];	$salesbatch=$_GET["salesbatch"];	$cond =" AND stock_batchno='$salesbatch'";	/*stock table select*/	$query = "SELECT * FROM `stock` WHERE id = '$salesid' GROUP BY stock_batchno ORDER BY id ASC";	$result = $mysqli->query($query);	$row = $result->fetch_assoc();	$rowcnt = $result->num_rows;	if($rowcnt == 0)	{		echo "0|0|0";	}	else	{		echo $row['stock_qty'].'|'. $row['stock_selrate'].'|'. $row['stock_taxper'];	}}/*SELECT STOCK DETAILS BY BATCH */if(isset($_GET['salesid1']) && isset($_GET['salesbatch1'])){	$salesid1=$_GET["salesid1"];	$salesbatch1=$_GET["salesbatch1"];	$queryone = "SELECT * FROM `stock` WHERE stock_batchno = '$salesbatch1' AND stock_proid='$salesid1'";	$resultone = $mysqli->query($queryone);	$rowone = $resultone->fetch_assoc();	$rowcut = $resultone->num_rows;	if($rowcut != 0)	{		echo $rowone['stock_mrp'].'|'. $rowone['stock_selrate'];	}	else	{		echo "0|0";	}}if(isset($_GET['proid']) && isset($_GET['barcode'])){	$proid=$_GET["proid"];	$barcode=$_GET["barcode"];	$query = "SELECT * FROM `stock` WHERE stock_proid = '$proid' AND stock_barcode='$barcode' GROUP BY stock_batchno ORDER BY stock_qty DESC";	$result = $mysqli->query($query);	$rowcut = $result->num_rows;	/* SELECT BATCHS IN STOCK TABLE*/	while ($row = $result->fetch_assoc()) {	echo '<option value="'.$row['stock_batchno'].'">'. $row['stock_batchno'].' ('.$row['stock_qty'].')</option>';	}		$query1 = "SELECT * FROM `temp_table` WHERE field_name='$proid' and active=1";		$result1 = $mysqli->query($query1);		$numcut=$result1->num_rows;		if($numcut != 0)		{			while ($row1 = $result1->fetch_assoc()) {			echo '<option value="'.$row1['field_value'].'">'. $row1['field_value'].'</option>';			}		}		/* ADD NEW BATCH OPTION */		if($rowcut != 0)		{			echo '<option value="New Batch">New Batch</option>';		}		else		{			echo '<option value="">Select</option>';			echo '<option value="New Batch">New Batch</option>';		}	}/*NEW BATCH INSERT IN TEMP TABLE FOR ALL PRODUCT*//********if(isset($_POST['newbatchno'])){	$newbatchno = $_POST['newbatchno'];	$salesid = $_POST['salesid'];	//select prodid 	$selectquery1 ="SELECT * FROM `stock` WHERE id='$salesid'";	$select1=$mysqli->query($selectquery1);	$row1=$select1->fetch_assoc();	$prodid = $row1['stock_proid'];	//	$selectquery ="SELECT * FROM `stock` WHERE stock_batchno='$newbatchno' AND stock_proid='$prodid'";	$select=$mysqli->query($selectquery);	$row=$select->fetch_assoc();//	$purchaseid=$row['stock_proid'];	$rowcount = $select->num_rows;	if($rowcount == 0)	{		$selectprod ="SELECT * FROM `product_basic` WHERE id='$prodid'";		$prodselect=$mysqli->query($selectprod);		$rowcut = $prodselect->num_rows;		if($rowcut !=0)		{			$query="INSERT INTO temp_table(field_name,field_value,active)VALUES('$prodid','$newbatchno',1)";			$result = $mysqli->query($query);		}				if($salesid == "")		{			echo "error| Invalid Product Name|";		}	}	echo $rowcount."|".$newbatchno;}*//* QTY TYPE DEFALUT SELECT*/if(isset($_GET['producttype'])){	echo "<option selected data-tokens='BOX'>BOX</option><option data-tokens='PS'>PS</option>";}/*NEW SALES AUTO QTY DISPLAY*/if(isset($_GET['salesprodid']) && ($_GET['salestype'])){	$salesprodid=$_GET["salesprodid"];	$salestype=$_GET["salestype"];		$query = "SELECT * FROM product_basic WHERE id='$salesprodid'";	$result = $mysqli->query($query);	$row = $result->fetch_assoc();		if($result->num_rows != 0)	{		if($salestype == "PS")		{			echo $row['product_item_perqty'].'|';		}		else		{			echo $row['product_bulk_qty'].'|';		}	}	else	{		echo "0|0";	}	echo $row['product_bulk_qty'].'|'; 
}/* NEW CUTOMER SELECT OPTION IN SALES PAGE*/if(isset($_GET['custselectquery'])){	$custselectquery = $_GET['custselectquery'];	$result = $mysqli->query($custselectquery);	while ($row = $result->fetch_assoc()) {		echo "<option value='".$row['id']."'>".$row['customer_company_name']."</option>";	}	}/* New  PRODUCT INSERT IN SALES PAGE*/if(isset($_POST['newprodname']) && ($_POST['taxper']) && ($_POST['itemperqty']) && ($_POST['itembulk'])){	$newprodname = $_POST['newprodname'];	$taxper = $_POST['taxper'];	$itemperqty = $_POST['itemperqty'];	$itembulk = $_POST['itembulk'];		$insquerycus="INSERT INTO `product_basic`(`product_name`, `product_tax`, `product_item_perqty`, `product_bulk_qty`,`product_active`) VALUES ('$newprodname','$taxper','$itemperqty','$itembulk','1')";	$result = $mysqli->query($insquerycus);	$proid=$mysqli->insert_id;	if($result){			$insquerycstock="INSERT INTO `stock`(`stock_proid`, `stock_batchno`, `stock_qty`, `stock_purrate`, `stock_selrate`) VALUES ('$proid','A','0','0','1')";			$mysqli->query($insquerycstock);			echo "0|Success";		}		else		{			echo "1|$newprodname";		}}/* New  CUSTOMER INSERT IN SALES PAGE*/if(isset($_POST['newcustname']) && ($_POST['newcusttype'])){	$newcustname = $_POST['newcustname'];	$newcusttype = $_POST['newcusttype'];	$mobileno = $_POST['mobileno'];		$newid="SELECT * FROM customer ORDER BY `id` DESC";	$newidone=$mysqli->query($newid);	$idfet=$newidone->fetch_assoc();	if($newidone->num_rows==0) {		$newcode="C1";	}	else{		$newsup=$idfet['customer_code'];		$len=1;		$substr = substr($newsup,$len);		$newcode = "C".($substr+1);	}	$insquerycus="INSERT INTO `customer`(`customer_code`, `customer_company_name`, `customer_type`, `customer_mobile`,`customer_active`) VALUES ('$newcode','$newcustname','$newcusttype','$mobileno','1')";	$result = $mysqli->query($insquerycus);		if($result){			echo "0|Success";		}		else		{			echo "1|$newcustname";		}}/* Delete Sales table a row using auto id*/if(isset($_GET['salesautoid'])){	$saleautoid = $_GET['salesautoid'];	$query="SELECT * FROM sales WHERE id='$saleautoid'";	$result = $mysqli->query($query);	$row = $result->fetch_assoc();	$salescustid = $row['sales_custid'];	$salesbillno = $row['sales_billno'];	$salesproid = $row['sales_proid'];	$salesbatchno = $row['sales_batchno'];	$salesqty = $row['sales_qty'];	$salesprice = $row['sales_price'];		$querysalemaster = "UPDATE `sales_master` SET sales_subtotal=sales_subtotal-'$salesprice',sales_total=sales_total-'$salesprice',sales_nettotal=sales_nettotal-'$salesprice' WHERE sales_custid='$salescustid' AND sales_billno='$salesbillno' ";	$updatesalemaster=$mysqli->query($querysalemaster);		$querystock = "UPDATE `stock` SET stock_qty=stock_qty+'$salesqty' WHERE stock_proid='$salesproid' AND stock_batchno='$salesbatchno' ";	$updatestock=$mysqli->query($querystock);		$querysales = "DELETE FROM sales WHERE id='$saleautoid'";	$delete = $mysqli->query($querysales);}?>