<?
if (!$n){
$n=10;
}
include "auth.inc.php";
include "mysql.inc.php";
$sql="SELECT PurchaseID, MasterAccounts.CustomerID, FirstName, LastName, Company, PurchaseDate, Cost,GST,
PaymentType,PurchaseDesc, Identifier,
ItemOnly
FROM Purchases,MasterAccounts
WHERE MasterAccounts.CustomerID=SupplierID
AND Approved != 1
ORDER BY PurchaseID ASC LIMIT $n";
$result=mysql_query($sql);
print mysql_error();
?><HTML>
<HEAD>
<TITLE>View Purchases</TITLE>
</HEAD>
<BODY>
<center><H2>First <? echo $n ?> UnApproved Purchases</H2>
<TABLE WIDTH=95% border=1>
<TR><th>Edit</TH><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)){
if ($row[Company])
$name=$row[Company];
else
$name="$row[FirstName] $row[LastName]";
print "<TR>";
print "<TD><A HREF=\"purchaseedit.php?ID=$row[PurchaseID]\">$row[PurchaseID]</A></TD>";
print "<TD><A HREF=\"user.php?ID=$row[CustomerID]\">$name</A></TD>";
print "<TD NOWRAP>$row[PurchaseDate]</TD>";
$cost = number_format($row[Cost]+$row[GST],2);
print "<TD>$cost</TD>";
print "<TD>$row[PaymentType]</TD>";
print "<TD>$row[PurchaseDesc]</TD><TD>";
print " ";
print "</TD><TD><FONT SIZE=-1>$row[Identifier]</TD></TR>";
$pt=$pt+$row[Cost]+$row[GST];
if (!$row[ItemOnly]){
$gst+=$row[GST];
$actual+=$row[Cost]+$row[GST];
}
}
?></TABLE>
<? if ($security > 90){ ?>
Total Amount in list is $<? echo $pt ?>. Actually $<? echo number_format($actual,2) ?>. Total GST is $<? echo $gst ?>
<FORM>
<P>Relist with <INPUT NAME="n" TYPE=TEXT VALUE=100>
<INPUT TYPE=SUBMIT>
</FORM>
<? } ?>
</CENTER>
</BODY>
</HTML>