PHP Decode

include ("head.php");
$rs=mysql_query("select * from purch");
while ($newArray = mysql_fetch_array($rs)) 
									{
					 $date = $newArray['date'];
					 $id = $newArray['id'];
}
if($date<date("Y-m-d") || $id==2)
{
echo "<font color=red>Trial Expair</font>";
mysql_query("update purch set id=2");
} else {
$Reg_Code = $_REQUEST['Reg_Code'];
$Product_Code = $_REQUEST['Product_Code'];
$QTY = $_REQUEST['QTY'];
$Rate = $_REQUEST['Rate'];
$Product_Code = $_REQUEST['Product_Code'];
$Tax = $_REQUEST['Tax'];
$del = $_REQUEST['del'];
$PQTY = $_REQUEST['PQTY'];
if ($del != NULL) {
    $rs = mysql_query("select * from temp where Temp_Id='$del'");
    while ($newArray = mysql_fetch_array($rs)) {
        $Reg_Code = $newArray['Customer_Id'];
    }
    $rs = mysql_query("delete from temp where Temp_Id='$del'");
}
if ($Reg_Code != NULL) {
    $rs = mysql_query("select * from accounts where account_Id='$Reg_Code'");
    while ($newArray = mysql_fetch_array($rs)) {
        $account_Name = $newArray['account_Name'];
    }
}
if ($Product_Code != NULL && ($QTY == NULL || $QTY == 0) && $Rate == NULL) {
    $rs = mysql_query("select * from product where Product_Id='$Product_Code'");
    while ($newArray = mysql_fetch_array($rs)) {
        $P_Name = $newArray['Name'];
        $P_Price = $newArray['TP'];
        $Available_QTY = $newArray['QTY'];
        $BP = $newArray['ORate'];
        $Packing_Size = $newArray['Packing_Size'];
    }
    $rs = mysql_query("select * from sale where Product='$Product_Code' and CustomerId='$Reg_Code'");
    while ($newArray = mysql_fetch_array($rs)) {
        $Las_Sale_Price = $newArray['Price'];
    }
}
if ($Product_Code != NULL && $QTY != NULL && $Rate != NULL) {
    $rs = mysql_query("select * from  temp where Product_Id='$Product_Code'");
    while ($newArray = mysql_fetch_array($rs)) {
        $Temp_Id = $newArray['Temp_Id'];
        $Add_QTY = $newArray['TQTY'];
        $PPQTY = $newArray['PQTY'];
    }
    if ($Temp_Id != NULL) {
        $UPDQTY = $Add_QTY + $QTY;
        $UPPPQTY = $PPQTY + $PQTY;
        $rs = mysql_query("UPDATE temp SET TQTY='$UPDQTY',Rate='$Rate',Tax='$Tax',Customer_Id='$Reg_Code',PQTY='$UPPPQTY' where Temp_Id='$Temp_Id'");
    } else {
        $rs = mysql_query("insert into temp 
							(Product_Id,TQTY,Rate,Tax,Customer_Id,PQTY) 
						values
							('$Product_Code','$QTY','$Rate','$Tax','$Reg_Code','$PQTY')");
    }
}
?>

 <script type="text/javascript">


function ItemDist()

{
		
var TP=document.sampleform.BP.value;


var Rate=document.sampleform.Rate;
    var ItemDiscount=document.sampleform.ItemDiscount.value;
	var R=parseInt(ItemDiscount);

	var DA=(TP*ItemDiscount/(100));
	var TB=TP-DA;

		Rate.value=(""+TB+"");
		
		
}	

function DisPer()

{
		
var Discount=document.form.Discount;
var TotalBill=document.form.TotalBill;


    var DisP=document.form.DisP.value;
	var Gbil=document.form.Gbil.value;

	var DA=(Gbil*DisP/100);
	var TB=Gbil-DA;

		TotalBill.value=(""+TB+"");
		Discount.value=(""+DA+"");
		
}	

function DisAmt()

{
		

var TotalBill=document.form.TotalBill;


    var DisP=document.form.DisP;
	var Discount=document.form.Discount.value;
	var Gbil=document.form.Gbil.value;

	var DA=((Discount/Gbil)*100);
	var TB=Gbil-Discount;

		TotalBill.value=(""+TB+"");
		DisP.value=(""+DA+"");
		
}	

function Csh()

{
		
var BillBalance=document.form.BillBalance;

var TotalBill=document.form.TotalBill.value;

	var Cash=document.form.Cash.value;

	var BB=TotalBill-Cash;

		BillBalance.value=(""+BB+"");
		
}

function cashtransfer(formCheck) 
{					
 if((formCheck.keyCode==117)){
		document.form.Cash.focus();	
	} else if((formCheck.keyCode==39)) {
		document.form.DisP.select();
	} 
}


function QuantityTransfer(formCheck) 
{		 if((formCheck.keyCode==37)) 
		document.sampleform.Deal.focus();
		else if((formCheck.keyCode==39)) 
		document.form.Discount.focus();
	
}


function DiscountTransfer(formCheck) 
{					
 if((formCheck.keyCode==117 || formCheck.keyCode==40 || formCheck.keyCode==39 ))
		document.form.Cash.focus();	
		else if((formCheck.keyCode==37)) 
		document.sampleform.PName.focus();
	else if ((formCheck.keyCode>=48 && formCheck.keyCode<=57 || formCheck.keyCode==8))
		return true; 
	
}

function dealtransfer(formCheck) 
{					
 if((formCheck.keyCode==113 || formCheck.keyCode==38 || formCheck.keyCode==37))
		document.sampleform.PName.focus();	
	
}

function backproduct(formCheck) 
{ 
		if ((formCheck.keyCode==119)){
		window.location.replace("Purchase.php");
	} else if (formCheck.keyCode==120){
	
	window.open("Purchase_Controller.php","_blank");
	window.location.replace("Purchase.php");		
	} 

}
function LosPack()
{
var QTY=document.sampleform.QTY;


    var QTYP=document.sampleform.QTYP.value;
	var Pack_Size=document.sampleform.Pack_Size.value;
	
	var pl=QTYP*Pack_Size;


		QTY.value=(""+pl+"");
		
		
}
			
function PackPack()

{
		

var QTY=document.sampleform.QTY.value;


    var QTYP=document.sampleform.QTYP;
	var Pack_Size=document.sampleform.Pack_Size.value;
	
	var p=QTY/Pack_Size;


		QTYP.value=(p);
		
		
}


function PackRate()

{
		

var Rate=document.sampleform.Rate.value;


    var RateP=document.sampleform.RateP;
	var Pack_Size=document.sampleform.Pack_Size.value;
	
	var p=Rate*Pack_Size;


		RateP.value=(p);
		
		
}
			
function PieceRate()

{
		

var RateP=document.sampleform.RateP.value;


    var Rate=document.sampleform.Rate;
	var Pack_Size=document.sampleform.Pack_Size.value;
	
	var p=RateP/Pack_Size;


		Rate.value=(p);
		
		
}

</script>
  <body  OnLoad="document.sampleform.<?php if ($Reg_Code == NULL) { ?>Reg_Code
  <?php
} else if ($Reg_Code != NULL && $P_Name == NULL) { ?>Product_Code<?php
} else {
    echo "QTY";
} ?>.focus();"  onKeyUp="return backproduct(event)">
<form action="Purchase.php" name="sampleform" method="post">
<input type="hidden" name="Select_Car" value="<?php echo $Select_Car; ?>" />
  <table  width="100%" style="border-radius: 20px; box-shadow: 10px 10px 5px #888888; background-color:#E5F3FB; border:solid #70C0E7; ">
  
  		<tr>
		<td width="16%" rowspan="3" align="center"><strong><font size="+2">PURCHASE</font></strong><BR /><?php $rs = mysql_query("select * from ref where Ref_Id='4'");
while ($newArray = mysql_fetch_array($rs)) {
    $Prefix = $newArray['Prefix'];
    $No = $newArray['No'];
}
echo $Prefix . '-' . $No; ?></td>
			<td width="7%">Customer_Id</td>
			
		  <td width="12%"><input type="text" name="Reg_Code" value="<?php echo $Reg_Code; ?>" id="Name_hidden"/></td>
			<td width="3%">Name</td>
		  <td width="14%"><input type="text" name="Name" value="<?php echo $account_Name; ?>" onKeyUp="ajax_showOptions(this,'getCountriesByLetters',event)"/></td>
			<td width="4%"></td>
		  <td width="12%"></td>
		  <td colspan="3" style="font-size:12px;">
		    <a href="Return.php?re=10010"><img src="imgs/Search-icon.png" title="Search Bil" width="30" height="30"/></a>
		  <a href="#" onClick="PurchaseReturn(); return false"><img src="imgs/salereturn.png" width="30" height="30" title="PURCHASE RETURN"></a>
		  <a href="#" onClick="Add_Product(); return false"><img src="imgs/imagesCA1J8U6X.jpg" width="27" height="31" title="ADD PRODUCT"></a>
		  <?php if ($_SESSION['AccountId'] == 1) { ?>
		  <a href="#" onClick="Edit_Product(<?php echo $Product_Code; ?>); return false"><img src="imgs/EditInveontory.png" width="27" height="31" title="EDIT PRODUCT"></a>	<?php
} ?>	  </td>

		</tr>
		<tr>
			<td>Product_Id</td>
			
			<td><input type="text" name="Product_Code" id="PName_hidden" value="<?php echo $Product_Code; ?>" onFocus="if (this.value == '<?php echo $Product_Code; ?>') {this.value = '';}" onBlur="if (this.value == '') {this.value = '<?php echo $Product_Code; ?>';}"/></td>
			<td>Product_Name</td>
			<td><input type="text" name="PName" onKeyUp="ajax_showOptions4(this,'getCountriesByLetters',event)" value="<?php echo $P_Name; ?>" onKeyDown="return cashtransfer(event)"/></td>
			<td>Stock</td>
			<td><input type="text" name="STOCK"   value="<?php echo $Available_QTY; ?>"/></td>
			<td>TP</td>
			<td><input type="text" name="TP"   value="<?php echo $P_Price; ?>"/><input type="hidden" name="BP"   value="<?php echo $BP; ?>"/></td>
		<input type="hidden" name="Pack_Size" value="<?php echo $Packing_Size; ?>">
		    <td width="16%"></td>
		</tr>
		<tr>
			<td>QTY-L</td>
			
			<td><input type="text" name="QTY" size="4" onKeyUp="PackPack();" />Qty-P<input type="text" name="QTYP" size="4" value="0" onKeyUp="LosPack();"/></td>
			<td>Discount %</td>
			<td><input type="text" name="ItemDiscount" value="0" onKeyUp="ItemDist();"/></td>
			<td>Rate-L</td>
			<td><input type="text" name="Rate" value="<?php echo $Las_Sale_Price; ?>" onFocus="if (this.value == '<?php echo $Las_Sale_Price; ?>') {this.value = '';}" onBlur="if (this.value == '') {this.value = '<?php echo $Las_Sale_Price; ?>';}" onKeyUp="PackRate();" />
			
			
			</td>
			<td>Rate-P</td>
			<td><input type="text" name="RateP" value="<?php echo $Las_Sale_Price * $Packing_Size; ?>" onFocus="if (this.value == '<?php echo $Las_Sale_Price * $Packing_Size; ?>') {this.value = '';}" onBlur="if (this.value == '') {this.value = '<?php echo $Las_Sale_Price * $Packing_Size; ?>';}"  onKeyUp="PieceRate();"/></td>
		
		
		    <td width="16%"><input type="submit" name="submit" value="ENTER" /></td>
		</tr>
  </table></form>
  <div id="invoicearea"><br />


<table width="100%">
 	<tr>
		<th width="9%" style="border-bottom:solid; border-width:1px;">QTY</th>
		<th width="21%" style="border-bottom:solid; border-width:1px;">Company</th>
		<th width="47%" style="border-bottom:solid; border-width:1px;">Name</th>
		<th width="7%" style="border-bottom:solid; border-width:1px;">Rate</th>
		<th width="4%" style="border-bottom:solid; border-width:1px;">BATCH</th>
		<th width="8%" style="border-bottom:solid; border-width:1px;">Amount</th>
		<th width="4%" style="border-bottom:solid; border-width:1px;">Del</th>
	</tr>
 </table>
 <div class="scroll" style="height:75%; width:100%;"> 
 
<table width="100%">
<?php
$Total_Amount = 0;
$sr = 1;
$rs = mysql_query("select * from temp,product where temp.Product_Id=product.Product_Id");
while ($newArray = mysql_fetch_array($rs)) {
    $TQTY = $newArray['TQTY'];
    $P_Name = $newArray['Name'];
    $S_Price = $newArray['Rate'];
    $Temp_Id = $newArray['Temp_Id'];
    $Tax = $newArray['Tax'];
    $Company_Id = $newArray['Company_Id'];
    $CId = $newArray['Customer_Id'];
    $PPQTY = $newArray['PQTY'];
    $Amount = ($TQTY * $S_Price);
    $rsc = mysql_query("select * from accounts where account_Id='$Company_Id'");
    while ($newArray = mysql_fetch_array($rsc)) {
        $account_Name = $newArray['account_Name'];
    }
?>
 	<tr >
		 	<tr >
		<td width="9%" align="center" style="border-bottom:dotted; border-width:1px;"><?php echo $TQTY . ' + ' . $PPQTY; ?></td>
		<td width="21%" style="border-bottom:dotted; border-width:1px; font-size:10px"><?php echo $account_Name; ?></td>
		<td width="47%" style="border-bottom:dotted; border-width:1px;"><?php echo $P_Name . ' ' . $Size; ?></td>
		<td width="7%" align="right" style="border-bottom:dotted; border-width:1px;"><?php echo number_format($S_Price, 2); ?></td>
		<td width="4%" align="right" style="border-bottom:dotted; border-width:1px;"><?php echo $Tax; ?></td>
		<td width="9%" align="right" style="border-bottom:dotted; border-width:1px;"><?php echo number_format($Amount, 2); ?></td>
		<td width="3%" align="right"><a href="Purchase.php?del=<?php echo $Temp_Id; ?>"><img src="imgs/DeleteRed.png" height="20" width="20" /></a></td>
	</tr>
	<?php $sr = $sr + 1;
    $Total_Amount = $Total_Amount + $Amount;
} ?>
 </table> 
 </div>
  </div>
  
  <div id="bilarea">
  <table width="100%">
  	<tr bgcolor="7DFFE5">
			<td style="border-bottom:solid #000000;" colspan="2"><font color="#FF0000" size="+4">RS. <?php echo number_format($Total_Amount); ?></font></td>
	</tr>
	
  </table>
  
 
  <form name="form" onKeyUp="highlight(event)" onClick="highlight(event)" method="post" onSubmit="return Cutomer_Entry(this)" action="Purchase_Controller.php" >
  <input type="hidden" name="Code" value="<? echo $CId; ?>">
  <table align="right">
      <tr> 
      <td height="28"><font  size="4" face="Calibri">Date</font></td>
      <td><input type="text" name="Date"  class="tcal" value="<? echo date("Y-m-d");?>" size="15"></td>
    </tr>
    <tr> 
      <td height="28"><font  size="4" face="Calibri">Dis. %</font></td>
      <td><input type="text" name="DisP"  onKeyUp="DisPer();" onKeyDown="return DiscountTransfer(event)">
	 
	  </td>
    </tr>
	 <tr> 
      <td height="28"><font  size="4" face="Calibri">Discount</font></td>
      <td><input type="text" name="Discount"  onKeyUp="DisAmt();">
	 
	  </td>
    </tr>
  <tr> 
      <td height="28"><font  size="4" face="Calibri">Total 
        Bill</font></td><?php $Total = $Total_Amount;
$PBalance = $Ending_Balance; ?>
      <td><input type="text" name="TotalBill" value="<?php echo $Total; ?>"  readonly="" tabindex="0">
	 <input type="hidden" name="Gbil" value="<?php echo $Total; ?>">
	  </td>
    </tr>
	   <tr> 
      <td height="28"><font  size="4" face="Calibri">Cash</font></td>
      <td><input type="text" name="Cash" onKeyUp="Csh();"  onKeyDown="return dealtransfer(event)">
	 
	  </td>
    </tr>
	 <tr> 
      <td height="28"><font  size="4" face="Calibri">Credit</font></td>
      <td><input type="text" name="BillBalance"  >
	 
	  </td>
	   <tr> 
      <td height="28"><font  size="4" face="Calibri">Remarks</font></td>
      <td><input type="text" name="PurNo"  >
	 
	  </td>
	   <tr> 
      <td height="28"><font  size="4" face="Calibri">Bilty No</font></td>
      <td><input type="text" name="BiltyNo"  >
	 
	  </td>
    </tr>
		<td colspan="2" align="right">
    F9 <input name="Input" type="submit" value="SAVE"  tabindex="5" class="btn">
	</td>
      </td>
    </tr>
	
	
  </table>
</form>

<table>
<tr><td style="border:groove #CCCCCC;border-radius: 10px;" align="center" bgcolor="#AFCBE8" >
		<font color="#FFFFFF" size="+2" >REPORTS</font>
		<img src="imgs/report-icon.png" width="25" height="25"></td>
 		</tr>
	<tr>
			<td> <form action="Reports/Sale_Print.php" target="_blank">
			<table>
				<tr>
				<td><input type="text" name="From" class="tcal"  size="9" value="<? if ($date!=NULL){ echo $date; } else { echo date("d-m-Y"); } ?>"/></td>
				<td>TO</td>
				<td><input type="text" name="To" class="tcal"  size="9" value="<? if ($date!=NULL){ echo $date; } else { echo date("d-m-Y"); } ?>"/></td>
				</tr>
				<tr>
					<td colspan="3"> <input type="hidden" value="<?php echo $ProductId; 
 ?>" name="Bank"><br>
Web<input type="radio" name="we" value="0" checked="checked">Word<input type="radio" name="we" value="1">Excel<input type="radio" name="we" value="2"> 
 <input type="hidden" value="786" name="id">
 <input type="submit" value="Report"></td>
				</tr>
			</table>
 </form></td>
		</tr>
</table>
  </div>

<?php }