<? 
session_start();
if(strlen($brcode)<=0)
{
 print "<script> alert('Session timed out'); parent.document.location='../ind.php'; </script>";
 return;
}

include("../opendb.php");
include("../test.php");
$result=mysqli_query($db,"select * from veh_invoice where invno='$invno' and invtype='$ttype' and brcode='$brcode'");
$row=mysqli_fetch_array($result);
$re=mysqli_query($db,"select * from branch where brcode='$brcode'");
$brow=mysqli_fetch_array($re);
?>
<style>
td,body{font-family:arial;background-color:white;font-size:12}
</style>
<table width=100% BORDER=0>
<tr><td></td>
<td align=right>
TIN &nbsp;&nbsp;&nbsp;: <?print $brow[tin]?><br>
CST No.: <?print $brow[cstno]?></td></tr>
<tr><td align=center COLSPAN=2><B>
THE KERALA VALUE ADDED TAX RULES, 2005<BR>
FORM NO. <?print $row[invtype]?>
</td></tr>

<tr><td align=center COLSPAN=2><span style={letter-spacing:5}> 
<?
print "<B>RETAIL INVOICE ";
?>

</span></TD></TR>
</TABLE>
<br>
<center>
<TABLE CELLSPACING=1 CELLPADDING=1 BGCOLOR=BLACK border=1>
<tr align=center><td>Invoice No <br>& Date</td><td>Delivery Note <br>No. & Date</td><td>Purchase Order <br>NO.&Date</td><td>Despatch<br>Doc.No. &Dt. </td><td>Terms of Delivery</td></tr>
<tr><td align=center><b> <font size=3>M<?print $invno.'<br>'.datetohtml($row[invdate])?></td>
<td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td></tr>
</table>
</center>
<?
if($row[invtype]=='8A')
{
$sq="select * from sup_master where supname='$row[cust]' and branch='$brcode'";
$r=mysqli_query($db,$sq) or die('err1'.mysqli_error());
}
/*else
$r=mysqli_query($db,"select * from cust_master where code='$row[cust]' and branch='$brcode'") or die('err2'.mysqli_error());
$cus_row=mysqli_fetch_array($r);*/
?>
<br>
<?
print "Name & Address of the Purchasing Dealer: <br>";
if($row[invtype]=='8A')
{
//  $custo1=explode(',',$cus_row[1]);
  $custo=$row[cust];
}
else
$custo=strtoupper($row[cust]);

?>

<blockquote>
<? print "<font size=2>".$custo.'<br>'.strtoupper(str_replace(',','<br>',$row[addr])).'<br>'?>
</font>
</blockquote>
<b>
Hypothicated to:
<blockquote>
<?
 $fff=mysqli_query($db,"select city from fin_master where finname='$row[fin]' and branch='$brcode'")or die(mysqli_error());
 $fi_row=mysqli_fetch_row($fff);
print "<font size=2>".$row[fin].','.$fi_row[0]?></font>
</blockquote>
<TABLE CELLSPACING=1 CELLPADDING=3 BGCOLOR=BLACK  width=80% border=1>
<tr align=center><td>SL<br>No.</td><td>Description </td><td>ITem Code </td><td>Tax<br>Rate
<td>Unit Price </td><td>Qty</td><td>Gross Value</td><td>Cash<br>Disc</td><td>Net Value</td>
<td>Tax Amount</td><td>Grand Total</td></tr>

<tr valign=top><td>1</td><td><?print $row[config]?></td><td>&nbsp;</td>
<td><?print $row[taxp].'%'?></td><td align=right><?print $row[unit]?></td><td align=right>1</td>
<td align=right><?print $row[netamt]?></td><td><?print $row[disc]?></td>
<td align=right><?print $row[amt2]?></td><td align=right><?print $row[tax]?></td>
<td align=right><?print $row[netamt]?></td></tr>
<tr><td>&nbsp;</td><td>T O T A L</TD><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td>
<td align=right><?print $row[netamt]?></td><td><?print $row[disc]?></td><td align=right><?print $row[amt2]?><td align=right><?print $row[tax]?></td><td align=right><font size=3><?print $row[netamt]?></td>
</tr>
</table>

<br>&nbsp;<br>
<table border=0 width=90%>
<tr><td width=115>Machine Serial NO</TD><TD>:<font size=3> <?print $row[msno]?></td></tr>
<tr><td>ENGINE NO</TD><TD>: <font size=3><?print $row[engno]?></td></tr>
<tr><td colspan=3>Total amount in words : RUPEES <?print word($row[netamt])?> ONLY

<tr><td><br>&nbsp;<br>
E & OE</TD></TR>
</TABLE>
<P ALIGN=JUSTIFY>
<U><B>"PRINCIPAL TO PRINCIPAL CLAUSE"</U></B><BR>
<?

if($brcode=='AUT009')
{
?>
Certified that all the particulars shown in the above Tax Invoice are true and correct to all respects and the goods on which the tax charged and collected are in accordance with the provision of the KVAT ACT 2003 and the rules made there under.  It is also certified that my/our Registration under KVAT ACT 2003 is not subject to any suspension/cancellation and it is valid as on the date of this Bill.
<?
}
else
{
?></b>
This is to inform all our esteemed customers that our principles,are in no way responsible implicitly or explicitly, for any vicarious liability for the refund of advance or delivery of machine thereof, as they dealwith us on a principal to principalbasis.
<?
}
?>
</p>
Received the above vehicle in good condition.
<br><br><br>
<table width=100%>
<tr><td>Signature of Customer </td><td width=500 align=right> For PSN CONSTRUCTION EQUIPMENT PVT. LTD.</td></tr>
<tr><td colspan=3 ALIGN=right><BR><BR><BR>Authorised Signatory</td></tr>
</TABLE>
<BR>&nbsp;
