<?
session_start();
include("opendb.php");
include("test.php");
if(strlen($user)<=0)
{
  print "<script> alert('Invalid User'); document.location='inde.php' </script>";
  return;
}

?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Xpress</title>
 <script src=" rightclick_deactive.js"></script> 
</head>
<style type="text/css">
table,tr,td{border-collapse:collapse;padding:1px;border: 1px solid black;}
body{font-family:Verdana;font-size:8px;color:black;}
td{font-family:Verdana;font-size:10px;color:black;height:30px;}
th{font-family:Verdana;font-size:11px;color:black;}
select,input[type=text], textarea{  
background: #eeeeee; /* Old browsers */
/* IE9 SVG, needs conditional override of 'filter' to 'none' */
background: url(data:image/svg+xml;base64,PD94bWwgdmVyc2lvbj0iMS4wIiA/Pgo8c3ZnIHhtbG5zPSJodHRwOi8vd3d3LnczLm9yZy8yMDAwL3N2ZyIgd2lkdGg9IjEwMCUiIGhlaWdodD0iMTAwJSIgdmlld0JveD0iMCAwIDEgMSIgcHJlc2VydmVBc3BlY3RSYXRpbz0ibm9uZSI+CiAgPGxpbmVhckdyYWRpZW50IGlkPSJncmFkLXVjZ2ctZ2VuZXJhdGVkIiBncmFkaWVudFVuaXRzPSJ1c2VyU3BhY2VPblVzZSIgeDE9IjAlIiB5MT0iMCUiIHgyPSIwJSIgeTI9IjEwMCUiPgogICAgPHN0b3Agb2Zmc2V0PSIwJSIgc3RvcC1jb2xvcj0iI2VlZWVlZSIgc3RvcC1vcGFjaXR5PSIxIi8+CiAgICA8c3RvcCBvZmZzZXQ9IjIzJSIgc3RvcC1jb2xvcj0iI2ZmZmZmZiIgc3RvcC1vcGFjaXR5PSIxIi8+CiAgPC9saW5lYXJHcmFkaWVudD4KICA8cmVjdCB4PSIwIiB5PSIwIiB3aWR0aD0iMSIgaGVpZ2h0PSIxIiBmaWxsPSJ1cmwoI2dyYWQtdWNnZy1nZW5lcmF0ZWQpIiAvPgo8L3N2Zz4=);
background: -moz-linear-gradient(top, #eeeeee 0%, #ffffff 23%); /* FF3.6+ */
background: -webkit-gradient(linear, left top, left bottom, color-stop(0%,#eeeeee), color-stop(23%,#ffffff)); /* Chrome,Safari4+ */
background: -webkit-linear-gradient(top, #eeeeee 0%,#ffffff 23%); /* Chrome10+,Safari5.1+ */
background: -o-linear-gradient(top, #eeeeee 0%,#ffffff 23%); /* Opera 11.10+ */
background: -ms-linear-gradient(top, #eeeeee 0%,#ffffff 23%); /* IE10+ */
background: linear-gradient(top, #eeeeee 0%,#ffffff 23%); /* W3C */
filter: progid:DXImageTransform.Microsoft.gradient( startColorstr='#eeeeee', endColorstr='#ffffff',GradientType=0 ); /* IE6-8 */
border:1px solid #999; padding:3px;
-webkit-border-radius: 3px;
-moz-border-radius: 3px;
border-radius: 3px;


}
p{padding:0px;}
em{font-size:14px;}
h2{color:#000;font-size:14px;margin:0px;padding:5px 20px;}

</style>
 

<script type="text/javascript">
    $(document).ready(function() {
        var cont_left = $("#container").position().left;
        $("a img").hover(function() {
            // hover in
            //$(this).parent().parent().css("z-index", 1);
            $(this).animate({
               height: "110",
               width: "90",
              
            }, "fast");
        }, function() {
            // hover out
         //   $(this).parent().parent().css("z-index", 0);
            $(this).animate({
                height: "80",
                width: "80",
                
            }, "fast");
        });
        
        $(".img").each(function(index) {
            var left = (index * 160) + cont_left;
            $(this).css("left", left + "px");
        });
    });









/////

(function($){
    $.fn.enterNext = function(){
       var _i =0;
       $('input[type=text], select',this)
            .each(function(index){
            _i = index;
            $(this)
                .addClass('tab'+index)
                .keydown(function(event){
                    if(event.keyCode==13){
                        $('.tab'+(index+1)).focus();
                        event.preventDefault();
                    }
                });

        })
     $( "input[type=submit]",this ).addClass('tab'+(_i+1));
}})(jQuery);
    </script>
<body onload='window.print();'>




<?
print "<table width='100%' bgcolor='white' border='1' style='border-collapse:collapse;'>";
print "<tr><td colspan='8' align='center'><h2><b><u> $company <br>";
print "STATEMENT OF ACCOUNT -".$inscomp."</u></b></h2></td></tr>";
print  "<tr><th>Sl.no<th>Date<th>Vehicle<th>Reg.no<th>File.no<th>Inv.no<th>Inv Amt<th>P.Ex</tr>";

$sql=mysqli_query($db,"select sum(amt),invno,date,veh,regno,fileno,jcno from jcardinvoice where inscomp='$inscomp' and brcode='$brcode' and marked_amt<=0 group by invno");
$i=1;
$tot_amt=0;
$tot_polex=0;
while($row=mysqli_fetch_array($sql))
{
print "<tr><td align='center'>".$i."</td><td >".datetoHtml($row[2])."</td>";
print "<td>$row[3]</td><td align='center'>$row[4]</td>";
print "<td align='center'>$row[5]</td>";
print "<td align='center'>$row[1]</td>";
print "<td align='right'>$row[0]</td>";

$sql1=mysqli_query($db,"select policyexcess from gateentry where jcno='$row[6]' and brcode='$brcode' ");
$row1=mysqli_fetch_array($sql1);
print "<td align='right'>$row1[0]</td>";
print "</tr>";
$tot_amt+=$row[0];
$tot_polex+=$row1[0];
$i++;

}

print "<tr><td colspan='6' align='right'><b>Grand Total:</b></td><td align='right' ><b>".putcoma($tot_amt)."</b></td><td align='right'><b>".putcoma($tot_polex)."</b></td></tr>";
print "</table>";
?>







