<?
if (!$n || $security<90){
$n=10;
}
include "auth.inc.php";
include "mysql.inc.php";
$sql="SELECT MasterAccounts.CustomerID, FirstName, LastName, PaymentDate, PaymentAmount,GST,
PaymentType,ResellerPayment,Purchase, Identifier FROM
Payments,MasterAccounts
WHERE MasterAccounts.CustomerID=Payments.CustomerID
ORDER BY PaymentDate DESC LIMIT $n";
$result=mysql_query($sql);
?><HTML>
<HEAD>
<TITLE>View Payments</TITLE>
</HEAD>
<BODY>
<center><H2>Last <? echo $n ?> Payments</H2>
<TABLE WIDTH=95% border=1>
<TR><TH>Name</TH><TH>Date</TH><TH>Amount</TH><TH>Payment
Type</TH><TH>Purchase</TH><TH>Paid at</TH><TH>Who Added</TH></TR>
<?
while ($row=mysql_fetch_array($result)){
print "<TR><TD><A HREF=\"user.php?ID=$row[CustomerID]\">$row[FirstName] $row[LastName]</A><TD
NOWRAP>$row[PaymentDate]</TD><TD>";
$cost=number_format($row[PaymentAmount]+$row[GST],2);
print $cost;
print "</TD><TD>$row[PaymentType]</TD>";
print "<TD>$row[Purchase]</TD><TD>";
$rsql="SELECT resellername FROM resellers WHERE resellerID=$row[ResellerPayment]";
$rres=0;
$rres=mysql_query($rsql);
#print $rres;
if ($rres){
$rr=mysql_fetch_row($rres);
print $rr[0];
}
else
print " ";
print "</TD><TD><FONT SIZE=-1>$row[Identifier]</TD></TR>";
$pt=$pt+$row[PaymentAmount];
}
?></TABLE>
<? if ($security > 90){ ?>
Total Amount in list is $<? echo $pt ?>.
<FORM>
<P>Relist with <INPUT NAME="n" TYPE=TEXT VALUE=100>
<INPUT TYPE=SUBMIT>
</FORM>
<? } ?>
</CENTER>
</BODY>
</HTML>