<?
session_start();
$brcode=$_SESSION['brcode'];
$user=$_SESSION['user'];
if(strlen($brcode)<=0)
{
 print "<script> alert('Session timed out'); parent.document.location='../index.html'; </script>";
 return;
}
include("../opendb.php");
include("../test.php");
if(isset($_POST['show']))
{
?>
<style>
td,th,body{font-size:14;font-family:'arial narrow';letter-spacing:1}
</style>
<center>
<?
$d1=$_REQUEST['d1'];
$m1=$_REQUEST['m1'];
$y1=$_REQUEST['y1'];

$d2=$_REQUEST['d2'];
$m2=$_REQUEST['m2'];
$y2=$_REQUEST['y2'];
 $dfrom=$y1.'-'.$m1.'-'.$d1;
 $dto=$y2.'-'.$m2.'-'.$d2;

$ordby=$_REQUEST['ordby'];

$brres=mysqli_query($db,"select * from branch where brcode='$brcode'");
$brrow=mysqli_fetch_array($brres);
?>
<table>
<TR><TD COLSPAN=2 ALIGN=CENTER><b> PSN AUTOMOTIVE P LTD </b><BR>
	 <?print $brrow[braddr].",".$brrow[brcity].",<br><u> PH - ".$brrow[brphone]?></u>
TIN: <?print $brrow[tin]?>, CST: <?print $brrow[cstno]?>&nbsp;
</td></tr>
<tr><td COLSPAN=2 ALIGN=CENTER>
<?print "<h4><br>WARANTY PASSED REPORT - </H4>";

print " from ".datetohtml($dfrom).' to '.datetohtml($dto);
?>
</td></tr>
</table>

<?
        $grand_gtot1=0;
        $grand_ttx=0;
        $grand_tcess=0;
        $grand_ttot=0;
        $grand_ttrnd=0;
        $grand_rndtot=0;
	$gtot1=0;
    $ttx=0;
    $tcess=0;
    $ttot=0;
    $ttrnd=0;
   /* if($ordby=='Invoice')
$re=mysqli_query($db,"select invno,invdate,customer,sum(aprice) aprice,sum(taxamt)txamt,sum(cessamt)cess ,sum(tot)tot, vatorcst,invtype,msno from spareinvoice  where brcode='$brcode' and invtype='$invrow[0]' and invdate>='$dfrom' and invdate<='$dto'  group by invno")or die('err'.mysqli_error($db));
    else*/
$re=mysqli_query($db,"select saleordno,invdate,sum(tot) tt,sum(claimptot)cptt,claimpdate from warspareinvoice  where brcode='$brcode' and  invdate>='$dfrom' and invdate<='$dto'  group by invno")or die('err'.mysqli_error($db));    
print "<table border=0 cellspacing=1 cellpadding=4 bgcolor='lightsteelblue'>";
//print "<th colspan=10><h3>Invoice Type $invrow[0]</th></tr>";
print " <th>Inv No <th>Invoice Date ";
print "<th>Claim Amt<th>Passed Amt<th>Diff<th>Pass Date";
while($row=mysqli_fetch_array($re))
{
    
	//$mtin=$cus_row[0];
	$diff=$row[tt]-$row[cptt];
    print "\n<tr bgcolor=white><td>$row[0]</td><td>".datetohtml($row[invdate]);
    //print "<td>".$mtin."</td>";
    //print "<td>".strtoupper($row[customer])."</td>";
    print "<td align=right>".putComa($row[tt])."</td><td align=right>".putComa($row[cptt])."</td>";
    print "<td align=right>".putComa($diff)."</td>";
    print "\n<td>".datetohtml($row[claimpdate]);
   
    //print "<td align=right>".putComa($row[tot])."</td>";
    $rnd=round($row[tot])-$row[tot];
    $rndtot+=$rnd;
    //printf("<td align=right>%.2f</td>",$rnd);
    //print "<td align=right>".putComa(round($row[tot]))."</td>";
    //print "<td>".$row[msno]."</td>";
    $ttrnd+=round($row[tot]);
    $gtot1+=$row[tt];
    $ttx+=$row[cptt];
    $tcess+=$diff;
    $ttot+=$row[tot];
}
print "<tr><td colspan=2><center><b>Total</td><td align=right>".putComa($gtot1)."</td>";
print "<td align=right>".putComa($ttx)."</td>";
print "<td align=right>".putComa($tcess)."</td>";
//print "<td align=right>".putComa($ttot)."</td>";
//printf("<td align=right>%.2f</td>",$rndtot);
//print "<td align=right>".putComa($ttrnd)."</td></tr><br>";
$grand_gtot1+=$gtot1;
$grand_ttx+=$ttx;
$grand_tcess+=$tcess;
$grand_ttot+=$ttot;
$grand_rndtot+=$rndtot;
$grand_ttrnd+=$ttrnd;
//}
print "</table><br>";
 

return;
}// end if
?>

<link rel="stylesheet" href="../style.css" type="text/css" />
<style>
//	tr{background-color:white}
	th{background-color:steelblue;color:white}
	td{font-size:13}
.right{text-align:right};
</style>

<center>
<h3>WARRANTY PASS REPORT -2</H3>
<form action='<?Print $PHP_SELF?>' method='post'>
<table cellspacing=1 cellpadding=1 bgcolor='steelblue'>
<tr><td bgcolor='white' align=center>
<table class=noprint>
<tr><td>Date from </td><td>dd <input type=text name='d1' size=2 value='<?print date("d")?>'>
mm <input type=text name='m1' size=2 value='<?print date("m")?>'>
yy <input type=text name='y1' size=4 value='<?print date("Y")?>'></td></tr>

<tr><td align=right>to </td><td>dd <input type=text name='d2' size=2 value='<?print date("d")?>'>
mm <input type=text name='m2' size=2 value='<?print date("m")?>'>
yy <input type=text name='y2' size=4 value='<?print date("Y")?>'>
</td></tr>
<tr><td colspan=2 align=center bgcolor='lightsteelblue'><input type=submit value='Show' name='show'></td></tr>

</table>
</td></tr>
</table>
</form>


