<?
include "./auth.inc.php";
include "mysql.inc.php";
?>
<HTML>
<HEAD>
<TITLE>List</TITLE>
<style>
<!--
A:link {text-decoration: none; color:#ffff66;}
A:visited {text-decoration: none; color:#ffff66;}
A:active {font-weight: bold;text-decoration: none; color:#ffff66;}
A:hover {font-weight: bold;text-decoration:underlined; color:#ffff66;}
A:text {text-decoration:none; color:#ffffff;}
-->
</style>
</head>
<body
bgcolor=#2b3155
text=#ffffff
link=#ffff66
vlink=#ff8866
alink=#ffffff
topmargin=20
leftmargin=40
marginheight=20
marginwidth=40>
<FONT SIZE=+1 FACE="arial">
<P><FONT SIZE="+2"><B>ACCOUNTS LISTING</B></FONT>
<BR>
<P>Number of Customers in Database (Last 30,90 days): <?
$csql="SELECT count(CustomerID) FROM MasterAccounts";
$result=mysql_query($csql);
$row=mysql_fetch_array($result);
$ccsql = "SELECT count(CustomerID) FROM MasterAccounts WHERE TO_DAYS(now()) - TO_DAYS(LastUse) < 30";
$cres = mysql_query($ccsql);
print mysql_error();
$crow = mysql_fetch_array($cres);
$ncsql = "SELECT count(CustomerID) FROM MasterAccounts WHERE TO_DAYS(now()) - TO_DAYS(LastUse) < 90";
$ncres = mysql_query($ncsql);
print mysql_error();
$ncrow = mysql_fetch_array($ncres);
echo $row[0];
echo " (<B>$crow[0], $ncrow[0] </B>)<BR>";
$acsql="SELECT AccountTypeName FROM AccountTypes";
$result=mysql_query($acsql);
while($row=mysql_fetch_row($result)){
$acountsql="SELECT Count(AccountID) FROM SubAccounts WHERE AccountType='$row[0]'";
$lacsql = "SELECT Count(AccountID) FROM SubAccounts, MasterAccounts WHERE AccountType='$row[0]' AND TO_DAYS(now()) - TO_DAYS(LastUse) < 30 AND SubAccounts.CustomerID=MasterAccounts.CustomerID";
$ares=mysql_query($acountsql);
if (mysql_error())
print "1: ".mysql_error();
$lares=mysql_query($lacsql);
if (mysql_error())
print "2: ".mysql_error();
$value=mysql_result($ares,0);
$vall=mysql_result($lares,0);
echo "<P> ";
if (file_exists("$row[0]-check.php"))
print "<A HREF=\"$row[0]-check.php\">$row[0]</A>";
else
print $row[0];
print ": $value (<B>$vall</B>)</P>";
}
?>
</font>
</BODY>
</HTML>