<? 
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 taxtype='VAT' and brcode='$brcode'");
$row=mysqli_fetch_array($result);
if($row[tp]!='8a')
{
 print "<script> alert('Bill is not 8A'); </script>";
}
$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>TIN: <?print $brow[tin]?><BR>(TAX PAYERS IDENTIFICATION NO.)
<?
$brname=explode(',',$branch);
?>
</td><td align=right>CST Reg. No.:<?print $brow[cstno]?></td></tr>
<tr><td align=center COLSPAN=2><span style={letter-spacing:5}><b><?print STRTOUPPER($brname[0])?></b> </span> <br>AUTHORISED DEALER FOR EICHER VEHICLES<BR>
Regd.Off. 35/189, NH 47, PALARIVATTOM, KOCHIN, PIN.682 025<BR>
<?Print $brow[braddr].'<br>'.$brow[brcity].',Phone:'.$brow[brphone]?>
</td></tr>

<tr><td align=center COLSPAN=2>
<?
print "FORM NO 8 ";
?>
</TD></TR>
<tr><td align=center COLSPAN=2><span style={letter-spacing:5}> 
<?
print "TAX - 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><?print $invno.'<br>'.datetohtml($row[invdate])?></td>
<td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td></tr>
</table>
</center>
<?
if($typ=='d')
{
$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($typ=='d')
{
  $custo1=explode(',',$cus_row[1]);
  $custo=$custo1[0];
}
else
$custo=$cus_row[1];

?>

<blockquote>
<? print $custo.'<br>'.str_replace(',','<br>',$cus_row[2]).'<br>'.$cus_row[3].''.$cus_row[4].' Pin:'.$cus_row[pin].'<br>'?>
<?
print "Tin : ".$cus_row[tin];
?>
</blockquote>

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 $row[fin].','.$fi_row[0]?>
</blockquote>


<TABLE CELLSPACING=1 CELLPADDING=1 BGCOLOR=BLACK width=90% border=1>
<tr align=center><td>SL<br>No.</td><td>Description </td><td width=10>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 <br>Amount</td>
<td>Cess% </td><td>Cess Amt</td>
<td>Grand Total</td><td>Discount<br>Gifts Free</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 align=right><?print $row[disc]?></td>
<td align=right><?print $row[amt2]?></td><td align=right><?print $row[tax]?></td>
<td align=right><?print $row[cessp]?></td><td align=right><?print $row[cessamt]?></td>
<td align=right><?print $row[netamt]?></td><td align=center>-<br><br><br></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 align=right><?print $row[disc]?></td><td align=right><?print $row[amt2]?>
<td align=right><?print $row[tax]?></td>
<td align=right><?print $row[cessp]?></td>
<td align=right><?print $row[cessamt]?></td>
<td align=right><font size=3><?print $row[netamt]?></td>
<td align=center>- </td></tr>
</table>

<font size=3>(RUPEES <?print word($row[netamt])?> ONLY)</font>
<br>&nbsp;<br>
<table border=0 width=90%>
<tr><td width=115>EMLDA NO</TD><TD>:<font size=3> <?print $row[da]?></td></tr>
<tr><td>ENGINE NO</TD><TD>: <font size=3><?print $row[engno]?></td></tr>
<tr><td>CHASSIS NO</TD><TD>:<font size=3> <?print $row[chasis]?></td></tr>
<tr><td>COLOR</TD><TD>: <font size=3><?print $row[color]?></td></tr>
<tr><td></td><td width=150>&nbsp;</td><td align=center> Goods once sold will not be taken back</td></tr>
<tr><td>E & OE</TD></TR>
</TABLE>
<P ALIGN=JUSTIFY style="width:900">
<U>DECLARATION</U><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
{
?>
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.
<?
}
?>
</p>
Received the above vehicle in good condition.
<br><br><br>
<table width=90%>
<tr><td>Customer Signature</td><td width=500 align=right> For <?print $brname[0]?></td></tr>
<tr><td colspan=3 ALIGN=right><BR><BR><BR>Authorised Signatory</td></tr>
<tr><td colspan=3 align=center><b>PSN - 86
<?//print (date("Y")-1922)
?> 
YEARS OF REPUTATION & TRUST</TD></TR>
</TABLE>
<BR>&nbsp;
