<?php $PageSecurity = 11;//echo $_SERVER['QUERY_STRING'];exit;
include('includes/DefineSuppTransClass.php');
include('includes/DefinePOClass.php');
include('includes/SQL_CommonFunctions.inc');
include('includes/function_lib.php');
include('includes/session.inc');
$sql="Select * from addmrn where id='".$_GET['mrnno']."'";
$result=DB_query($sql,$db);
$mrnrow=DB_fetch_array($result);
$data1='';

if($mrnrow['DocumentType']=='Bill')
{
$data1.="<input name='bill_no' type='text' value='".$mrnrow['BillNo']."' style='width:200px;' readonly='true'/>";
}
else
{
$data1.="<input name='bill_no' type='text' value='' style='width:200px;'/>";
}


$data2="";

if($mrnrow['DocumentType']=='Challan')
{
$data2.="<input name='challan_no' type='text' value='".$mrnrow['BillNo']."' style='width:200px;' readonly='true'/>";
}
else
{
$data2.="<input name='challan_no' type='text' value='' style='width:200px;' />";
}



$data3="";
$data3.="<table width='200%' border='1' cellspacing='2' cellpadding='3' style='border:solid 1px #333333;'>";
  $data3.="<tr bgcolor='#d4d4d4'>";
    $data3.="<td class='tabledata'><strong>Part Code</strong></td>";
    $data3.="<td class='tabledata'><strong>Part Name</strong></td>";
    $data3.="<td class='tabledata'><strong>UOM</strong></td>";
	if($mrnrow['ReceivedAgainst']=='Indent')
	{
	$data3.="<td class='tabledata'><strong>PR QTY</strong></td>";}
	else
    {
	$data3.="<td class='tabledata'><strong>PO QTY </strong></td>";}
    $data3.="<td class='tabledata'><strong>QTY AS PER BILL </strong></td>";
    $data3.="<td class='tabledata'><strong>QTY ACCEPTED </strong></td>";
    $data3.="<td class='tabledata'><strong>SHORT QUANTITY </strong></td>";
    $data3.="<td class='tabledata'><strong>RATE</strong></td>";
	$data3.="<td class='tabledata'><strong>Total Price</strong></td>";	
	$data3.="<td class='tabledata'><strong>Discount Percent</strong></td>";
	$data3.="<td class='tabledata'><strong>Discount</strong></td>";
	$data3.="<td class='tabledata'><strong>Discount Amount</strong></td>";
	$data3.="<td class='tabledata'><strong>Sub Total</strong></td>";
	$data3.="<td class='tabledata'><strong>BASIC AMOUNT</strong></td>";
	
//******************************************EXCISE DUTY HEADERPART*************************************************************************************************	

if($mrnrow['Type']=='DO'){

	
	$data3.="<td class='tabledata'><strong>Tax Type</strong></td>";
	$data3.="<td class='tabledata'><strong>Excise</strong></td>";
	$data3.="<td class='tabledata'><strong>Excise Value</strong></td>";
	$data3.="<td class='tabledata'><strong>E-Cess</strong></td>";
	$data3.="<td class='tabledata'><strong>E-Cess Value</strong></td>";
	$data3.="<td class='tabledata'><strong>SAH-E Cess</strong></td>";
	$data3.="<td class='tabledata'><strong>SAH-E Value</strong></td>";
	$data3.="<td class='tabledata'><strong>Taxable Amount </strong></td>";}




//******************************************EXCISE DUTY HEADERPART*************************************************************************************************





//******************************************CUSTOM DUTY HEADERPART*************************************************************************************************
	
	if($mrnrow['Type']=='IO'){
	$data3.="<td class='tabledata'><strong>Custom Duty flag</strong></td>";
	$data3.="<td class='tabledata'><strong>Custom Duty</strong></td>";
	$data3.="<td class='tabledata'><strong>Duty Amount</strong></td>";}



//******************************************CUSTOM DUTY HEADERPART*************************************************************************************************	
	
	
	
	$data3.="<td class='tabledata'><strong>TOTAL AMOUNT</strong><input type='hidden' name='pb_type' value='".$mrnrow['Type']."' /></td>";    
	$data3.="</tr>";
	$i=0;
	$sql2=DB_query("select * from addmrnqty where issue_id='".$_GET['mrnno']."'",$db);
  while($rowdata=DB_fetch_array($sql2))
  {  			
	$unitname=$s->getField('unitsofmeasure','unitid',$rowdata['UOM'],'unitname');
	$poid=$s->getField('addmrn','id',$_GET['mrnno'],'PO_WO_MTO');
	$item_code=$s->getField('item_master','id',$rowdata['mst_itemid'],'StockID');
	$item_name=$s->getField('item_master','id',$rowdata['mst_itemid'],'item_name');
	
	
	$TotalPrice=$rowdata['itemprice']*$rowdata['reciveqty'];
	
	if($rowdata['billing_type']=='NonExcisable' || $rowdata['billing_type']=='IncludeTax')
	{
		$disabled='disabled';
	}
	else
	{
		$disabled='';
	}

	$data3.="<tr class='rowdata'><td>
	
	<input type='hidden' name='ProductID[$i]' value='".$item_code."'> 
	<input type='hidden' name='item_id[$i]' value='".$rowdata['mst_itemid']."'>".$item_code."</td>";
	$data3.="<td><input type='hidden' name='ProductDes[$i]' value='".$item_name."'>".$item_name."</td>";
	$data3.="<td><input type='hidden' name='UOM[$i]' value='".$rowdata['UOM']."'>".$unitname."</td>";
	$data3.="<td>".$rowdata['POQty']."</td>";
	$data3.="<td>".$rowdata['qty_as_per_bill']."<input type='hidden' name='qty_as_per_bill[".$i."]' id='qty_as_per_bill_".$i."' value='".$rowdata['qty_as_per_bill']."'></td>";
	$data3.="<td><input type='hidden' name='quantity[$i]' id='Quantity_$i' value='".$rowdata['reciveqty']."'>".$rowdata['reciveqty']."</td>";
	$data3.="<td>".$rowdata['short_accessid']."<input type='hidden' name='short_qty[".$i."]' id='short_qty_".$i."' value='".$rowdata['short_accessid']."' style='width:100%;'></td>";
	$data3.="<td><input type='text' name='rate[$i]' style='width:100%;' id='Rate_$i' value='".$rowdata['itemprice']."' onchange='calamt($i)'></td>";
	
	$data3.="<td><input type='text' name='total_price[$i]' id='totalValue_$i' value='".$TotalPrice."' style='width:100%;'  onfocus='calculateTotalPrice($i)'></td>";
	$data3.="<td><select style='width:100%;' name='discount_type[$i]' id='PerAmo_$i'>";
	$data3.="<option value='Amount' ".($rowdata['disc_type']=='Amount'?'selected':'').">Amount</option>";
	$data3.="<option value='PercentAmt' ".($rowdata['disc_type']=='PercentAmt'?'selected':'')." >Percent Amt</option>";
	$data3.="</select></td>";
	$data3.="<td><input type='text' name='discount[$i]' id='Discount_$i' onblur='DiscountAmount(this.value,$i)' style='width:100%;' value='".$rowdata['discount']."'  /></td>";
	$data3.="<td><input type='text' name='discount_amount[$i]' id='perc_$i'  readonly='true' style='width:100%;' onblur='checkamount(this.value,$i)'
	value='".$rowdata['discount_amount']."' /></td>";
	$data3.="<td><input type='text' id='NetRate_$i' name='sub_total[$i]' style='width:100%;' readonly value='".$rowdata['val_after_disc']."' /></td>";
	$data3.="<td><input type='text' id='basic_$i' name='basic[$i]' style='width:100%;' readonly  value='".$rowdata['basic']."' /></td>";
	

//******************************************EXCISE DUTY PART*************************************************************************************************

if($mrnrow['Type']=='DO'){

	$data3.="<td><select name='tax_type[$i]' style='width:100%;' id='hid_billing_type_$i'  onchange='checkExcisable(this.value,$i)' onkeyup='checkExcisable(this.value,$i)'>";
	$data3.="<option value=''>Select</option>";
	if($rowdata['billing_type']=='NonExcisable')
	{$d="selected";}
	else if($rowdata['billing_type']=='Excisable')
	{$e="selected";}
	else if($rowdata['billing_type']=='IncludeTax')
	{$f="selected";}
	$data3.="<option value='NonExcisable'".$d.">NonExcisable</option>";
	$data3.="<option value='Excisable' ".$e.">Excisable</option>";
	$data3.="<option value='IncludeTax' ".$f.">IncludeTax</option>";
	$data3.="</select></td>";
	$data3.="<td><select name='Excise_Duty[$i]' id='exciseDuty_$i' style='width:100%;' onchange='claculateExcise(this.id,this.value)' onfocus='checkexiseflag($i)'  ".$disabled.">";
	$data3.="<option value=''>Select</option>";   	    
	$excise_sql=DB_query("Select * from excise_tax where caption like '%excise%' and form_type='Purchase'",$db);
	while($excise_row=DB_fetch_array($excise_sql)){
	$data3.="<option value=".$excise_row['id']." ".($rowdata['excise_duty']==$excise_row['id']?'selected':'').">".$excise_row['caption']."</option>";
	}
	$data3.="</select>";
	$data3.="<td><input name='exciseValue[$i]' id='exciseValue_".$i."' type='text' value='".$rowdata['excise_val']."' style='width:100%;' onfocus='calculateExciseDuty(this.id)' readonly='' ".$disabled." /></td>";
	$cessSql=DB_query("Select caption from excise_tax where caption like '%cess%'",$db);
	$k=1;
	while($cessRow=DB_fetch_array($cessSql))
	{
	$caption[$k]=$cessRow['caption']; 
	$rate_sql=DB_query("Select def_rate from excise_tax where caption='".$caption[$k]."'",$db);
	while($rate_row=DB_fetch_array($rate_sql))
	{
	$rate[$k]=$rate_row['def_rate'];
	}
	$k++;
	} 	
	
	$cessLedgerSql1=DB_query("Select * from excise_tax where ledgertype='cess' LIMIT 0,1",$db);	 
	$cessLedgerSql2=DB_query("Select * from excise_tax where ledgertype='cess' LIMIT 1,1",$db);	 	 
	
	$data3.="<td><select name='Cess_ID[$i]' id='cess_ID1_".$i."' style='width:100%;' onchange='calEcessonchange(this.id,this.value)' ".$disabled.">";
	$data3.="<option value=''>Select</option>";	
	while($cessLedger1=DB_fetch_array($cessLedgerSql1)){
	$data3.="<option value='".$cessLedger1['id']."' ".($rowdata['Cess_ID']==$cessLedger1['id']?'selected':'').">".$cessLedger1['caption']."</option>";
	}
	$data3.="</select>";
	$data3.="<input name='ECessPercentage[$i]' id='ECessPercentage' type='hidden' value='".$rate[1]."' style='width:100%;' readonly />";
	$data3.="</td>";
	$data3.="<td><input name='ECessValue[$i]' id='ECessValue_".$i."' type='text' value='".$rowdata['e_cess_val']."' ".$disabled." style='width:100%;'  onfocus='calculateECess(this.id)' readonly/></td>";
	$data3.="<td><select name='SHECess_ID[$i]' id='cess_ID2_".$i."' style='width:100%;' ".$disabled." onchange='calSHEcessonchange(this.id,this.value)'>";
	$data3.="<option value=''>Select</option>";	
	while($cessLedger2=DB_fetch_array($cessLedgerSql2)){
	$data3.="<option value='".$cessLedger2['id']."' ".($rowdata['SHECess_ID']==$cessLedger2['id']?'selected':'').">".$cessLedger2['caption']."</option>";
	}
	$data3.="</select>";
	$data3.="<input name='SAHCessPercentage[$i]' id='SAHCessPercentage' type='hidden' value='".$rate[2]."' style='width:100%;' readonly/>";
	$data3.="</td>";
	$data3.="<td><input name='SAHCessValue[$i]' id='SAHCessValue_".$i."' ".$disabled." type='text' value='".$rowdata['sah_val']."' style='width:100%;' readonly onfocus='calculateSAHCess(this.id)' /></td>";
	
	$data3.="<td><input type='text' name='taxable_amt[$i]' id='taxable_amt_$i' value='".$rowdata['total_amt_with_tax']."' style='width:100%;' onfocus='calculateTaxable($i)'   ".$disabled."   readonly/></td>";
	$data3.="<td><input type='text' id='TotalSpecial_$i' name='TotalAmount[$i]' style='width:100%;' readonly  onfocus='cal_grandtotal($i);' value='".$rowdata['mat_value']."' /></td>";					
}

//******************************************EXCISE DUTY PART*************************************************************************************************

					
					
//******************************************CUSTOM DUTY PART*************************************************************************************************					

if($mrnrow['Type']=='IO'){					
					
	$data3.="<td class='tabledata'><select name='cuntomDuty_Flag[$i]' style='width:100%' id='cuntomDuty_Flag_".$i."'  onchange='CustomDutyType(this.value,".$i.")'>";
	$data3.="<option value=''>Select</option>";
	$data3.="<option value='1' ".($rowdata['cuntomDuty_Flag']=='1'?'selected':'').">Yes</option>";
	$data3.="<option value='2' ".($rowdata['cuntomDuty_Flag']=='2'?'selected':'').">No</option>";
	$data3.="</select></td>";
	$data3.="<td class='tabledata'><select name='Custon_Duty[$i]' id='Custon_Duty_".$i."' style='width:100%;'    onchange='CalculateCustomDuty(this.id,this.value)' onFocus='checkCustomtype(".$i.")'>";
	$data3.="<option value=''>Select</option>";
	$excise_sql=DB_query("Select * from custom_duty",$db);
	while($excise_row=DB_fetch_array($excise_sql)){
	$data3.="<option value='".$excise_row['id']."' ".($rowdata['Custon_Duty']==$excise_row['id']?'selected':'').">".$excise_row['caption']."</option>";}
	$data3.="</select>
	<input type='hidden' id='custonduty1_".$i."' value='".$rowdata['Custon_Duty']."' />
	";
	$data3.="</td>";
	$data3.="<td class='tabledata'><input type='text'  id='CustomDutyAmt_".$i."'  onfocus='checkCustomDuty(".$i.");' readonly='' name='CustomDutyAmt[$i]' style='width:100%;' value='".$rowdata['CustomDutyAmt']."'  />
	<input type='hidden' id='custondutyamt1_".$i."' value='".$rowdata['CustomDutyAmt']."' />
	</td>";
	$data3.="<td class='tabledata'><input type='text' id='TotalSpecial_".$i."' name='TotalAmount[$i]' style='width:100%;'    onfocus='cal_grandtotalImp(".$i.");' value='".$rowdata['mat_value']."'/></td>";

}
					
//******************************************CUSTOM DUTY PART*************************************************************************************************					
					
					
 $data3.="</tr>";
			   $i++; }
	$data3.="<input type='hidden' id='conterimp' value='".$i."' />";
  	$data3.="<input type='hidden' name='count' id='count' value=".$i.">";
  $data3.="</table>";
  
  $venderdata1=DB_query("select * from venderquotations where id='".$venderqtyid."' ",$db);
 $venderrow1=DB_fetch_array($venderdata1);
 
 
 
 $data4="";
 
 
 
 //*******************************BASIC CALCULATION FROM DOMESTIC ORDER********************************************************************************************
 
 
 if($mrnrow['Type']=='DO'){
 
 		$data4.="<table width='100%' border='0' cellspacing='0' cellpadding='3'>";
		$data4.="<tr class='row1'>";
		$data4.="<td class='tabledata1'><strong>Basic Amount</strong> </td>";
		$data4.="<td><input type='text'  name='basic_amt' id='total_item_amount' style='width:150px;' readonly onfocus='cal_totalamount()' value='".$mrnrow['total_Item_Amount']."' /></td>";
		$data4.="</tr>";
		$data4.="<tr class='row1'>";
        $data4.="<td class='tabledata1'><strong>Pkg Charges</strong> </td>";
        $data4.="<td><input type='text' name='pkg_per' id='pkg_perc' style='width:50px' value='".$mrnrow['pkg_perc']."' onkeyup='calcPackaging(this.value)' />													<input name='pkg_charges' id='pkg_charges1' style='width:100px' value='".$mrnrow['pkg_charges']."' type='text'/></td>";
        $data4.="</tr>";
        $data4.="<tr class='row1'>";
        $data4.="<td class='tabledata1'><strong>Vat/Cst(discription) </strong> </td>";
		$Taxsql='SELECT salestax_id,tax_code, taxrate FROM sales_tax_master';
		$Taxresult=DB_query($Taxsql,$db);
        $data4.="<td><select id='taxname' name='vatcst' onchange='tax_rate1(this.value)' style='width:150px;'>";
	    $data4.="<option value='0'>---Select---</option>";
		while($Taxmyrow=DB_fetch_array($Taxresult)){
        $data4.="<option  value='".$Taxmyrow['salestax_id']."' ".($mrnrow['vat_cst']==$Taxmyrow['salestax_id']?'selected':'').">".$Taxmyrow['tax_code'].' --- '.$Taxmyrow['taxrate'].'%'."</option>";
        }
        $data4.="</select></td>";
        $data4.="</tr>";
        $data4.="<tr class='row1'>";
        $data4.="<td class='tabledata1'><strong>Tax Value</strong></td>";
        $data4.="<td><div id='taxval'><input type='text' name='taxvalue' id='taxvalue' style='width:150px;' value='".$mrnrow['vat_cst_val']."' readonly='true'/>";
        $data4.="</div></td>";
        $data4.="</tr>";
     	$data4.="<tr class='row1'>";
        $data4.="<td class='tabledata1'><strong>Surcharge Amount</strong> </td>";
        $data4.="<td><input type='text' name='surcharge_per' id='sur_oct_per' style='width:50px;' value='".$mrnrow['sur_oct_per']."' onchange='calsuroctamt(this.value)'/><input name='surcharge_amt' type='text' id='sur_oct_amt' value='".$mrnrow['sur_oct_amt']."' style='width:100px;' /></td>";
        $data4.="</tr>";
        $data4.="<tr class='row1'>";
        $data4.="<td class='tabledata1'><strong>Freight</strong></td>";
        $data4.="<td><input type='text' name='Freight' id='TotalCharge' value='".$mrnrow['tot_freight']."' style='width:150px;'/></td>";
        $data4.="</tr>";
        $data4.="<tr class='row1'>";
        $data4.="<td class='tabledata1'><strong>Additional Charges</strong> </td>";
        $data4.="<td><input name='add_charges' id='additionalCharges' value='".$mrnrow['add_charges']."' type='text' style='width:150px;' /></td>";
        $data4.="</tr>";
				
        $data4.="<tr class='row1'>";
		$data4.="<td class='tabledata1'><strong>Grand Total</strong></td>";
        $data4.="<td><input type='text' name='GrandTotal' id='GrandTotal' onfocus='cal_grandamount()' style='width:150px;' value='".$mrnrow['grandtotal']."' /><input type='hidden'  id='orig_grand_tot' />&nbsp;<strong>Round Off</strong>&nbsp;";
		$data4.="<select name='round_off' id='round_off' style='width:50px; height:20px' onchange='calcRounded(this.value)'>";
				 $data4.="<option value=''>None</option>";
				 $data4.="<option value='+'>+</option>";
				 $data4.="<option value='-'>-</option>";
				 $data4.="</select></td>";
    	$data4.="</tr>";
		$data4.="</table>";
 }
 
  //*******************************BASIC CALCULATION FROM DOMESTIC ORDER********************************************************************************************

 
 
 
 //*******************************BASIC CALCULATION FROM IMPORT ORDER********************************************************************************************
 
 
 if($mrnrow['Type']=='IO'){	
 
 
 
 
 	$data4.="<table width='100%' border='0' cellspacing='0' cellpadding='3'>";
	$data4.="<tr class='row1'>";
	$data4.="<td class='tabledata1'><strong>Basic Amount</strong></td>";
	$data4.="<td><input name='basic_amt' id='total_item_amount' style='width:150px;' value='".$mrnrow['total_Item_Amount']."' readonly onfocus='cal_totalamount()'></td>";
	$data4.="</tr>";
	$data4.="<tr class='row1'>";
	$data4.="<td class='tabledata1'><strong>Custom Duty</strong></td>";
	$data4.="<td><select name='CustomDuty' id='CustomDuty' style='width:150px;' onChange='claculateExcisetotal(this.id,this.value)'>";
	$data4.="<option value='0'>Select</option>";
	$ServiceSql='select * from  custom_duty' ;
	$ServiceRes=DB_query($ServiceSql,$db);
	while($ServiceRow=DB_fetch_array($ServiceRes)){
	$data4.="<option value='".$ServiceRow['id']."' ".($mrnrow['CustomDuty']==$ServiceRow['id']?'selected':'').">".$ServiceRow['caption']."</option>";} 
	$data4.="</select><br/><input name='custondutyval' id='custondutyval' 
	type='text'  style='width:150px;' onFocus='cal_totalamountwithduty()' value='".$mrnrow['custondutyval']."' />
	<input type='hidden' id='rateval' />";
	$data4.="</td>";
	$data4.="</tr>";
	
	$data4.="<tr class='row1'>";
	$data4.="<td class='tabledata1'><strong>Insurance charges</strong></td>";
	$data4.="<td><input type='text' name='insurancecharges' id='insurancecharges' style='width:50px;' value='".$mrnrow['insurancecharges']."'   onblur='calsuroctamtipm(this.value)'/>
	<input name='insurancecharges_amt' type='text'  onkeyup='reversecalsuroctamt(this.value);' id='insurancecharges_amt' value='".$mrnrow['insurancecharges_amt']."'  style='width:100px;' /></td>";
	$data4.="</tr>";
	$data4.="<tr class='row1'>";
	$data4.="<td class='tabledata1'><strong>Overseas Freight</strong></td>";
	$data4.="<td><input type='text' name='overseasfrieght' id='overseasfrieght'  style='width:50px;' value='".$mrnrow['overseasfrieght']."' onBlur='caloverfreight(this.value)'/>
	<input name='overseasfrieght_amt' type='text' onkeyup='reversecaloverfreight(this.value);' id='overseasfrieght_amt' value='".$mrnrow['overseasfrieght_amt']."' style='width:100px;' /></td>";
	$data4.="</tr>";
	$data4.="<tr class='row1'>";
	$data4.="<td class='tabledata1'><strong>Local Freight</strong></td>";
	$data4.="<td><input type='text' name='localfreight' id='localfreight'  style='width:50px;' value='".$mrnrow['localfreight']."' onBlur='callocalfreight(this.value)'/>
	<input name='localfreight_amt' type='text'  onkeyup='reversecallocalfreight(this.value);' value='".$mrnrow['localfreight_amt']."'  id='localfreight_amt' style='width:100px;' /></td>";
	$data4.="</tr>";
	$data4.="<tr class='row1'>";
	$data4.="<td class='tabledata1'><strong>Clearing & Forwarding</strong> </td>";
	$data4.="<td><input type='text' name='clearingforwarding' id='clearingforwarding' value='".$mrnrow['clearingforwarding']."'  style='width:50px;' onBlur='calclearingforwarding(this.value)'/>
	<input name='calclearingforwarding_amt' type='text' onkeyup='reversecalclearingforwarding(this.value);' id='calclearingforwarding_amt' style='width:100px;' value='".$mrnrow['calclearingforwarding_amt']."' /></td>";
	$data4.="</tr>";
	
	$data4.="<tr class='row1'>";
	$data4.="<td class='tabledata1'><strong>Detetion Charges</strong> </td>";
	$data4.="<td><input type='text' name='detetioncharges' id='detetioncharges' value='".$mrnrow['detetioncharges']."'  style='width:50px;' onBlur='caldetetioncharges(this.value)'/>
	<input name='detetioncharges_amt' type='text' onkeyup='reversecaldetetioncharges(this.value);' value='".$mrnrow['detetioncharges_amt']."' id='detetioncharges_amt'style='width:100px;' /></td>";
	$data4.="</tr>";
	$data4.="<tr class='row1'>";
	$data4.="<td class='tabledata1'><strong>Other charges</strong></td>";
	$data4.="<td><input type='text' name='othercharges' id='othercharges' value='".$mrnrow['othercharges']."'  style='width:150px;' style='margin-left:18px;'/></td>";
	$data4.="</tr>";		
	
	$data4.="<tr class='row1'>";
	$data4.="<td class='tabledata1'><strong>Grand Total</strong></td>";
	$data4.="<td><input type='text' name='GrandTotal' id='GrandTotal' onFocus='cal_grandamountimp()' value='".$mrnrow['grandtotal']."'  style='width:150px;'/></td>";
	$data4.="</tr>";
	$data4.="</table>";
 
 
 
 
 
 
 }
 
 
 //*******************************BASIC CALCULATION FROM IMPORT ORDER********************************************************************************************
 
 
 
 
 

echo $data=$data1."__".$data2."__".$data3."__".$data4;
//$sql2=DB_query("select * from addmrnqty where issue_id='".$_GET['mrnno']."'",$db);
?>
