<?
include "./auth.inc.php";
if (!$date)
$date = 'now()';
else{
$ddate = $date;
$date = "'".$date."'";
}
$wsql = "SELECT week($date)";
$wres = mysql_query($wsql);
if (!mysql_num_rows($wres))
die("Invalid Date");
$week = intval(mysql_result($wres,0));
$sql = "SELECT CustomerID, FirstName, LastName
FROM MasterAccounts
WHERE to_days($date) - to_days(CreateDate) <45
AND Reseller>0";
$res = mysql_query($sql);
?>
<HTML>
<HEAD></HEAD>
<BODY bgcolor=white>
Dealer signup payments for week <? echo "$week ($ddate)" ?>
<BR>
<form>
Date: <input type=text name="date" value="<? echo $ddate ?>">
<BR>
<table border=1>
<?
while ($row = mysql_fetch_array($res)){
$psql = "SELECT week(PaymentDate,1), Purchase, PaymentDate,PaymentAmount
FROM Payments
WHERE CustomerID=$row[0] AND PaymentAmount>10
ORDER BY PaymentDate
LIMIT 1";
$pres = mysql_query($psql);
if (mysql_num_rows($pres)){
$prow = mysql_fetch_row($pres);
if ($prow[0] == $week){
print "<TR><TD><A HREF=\"user.php?ID=$row[0]\">$row[1] $row[2]</A></TD>
<td>$prow[2]</TD>
<TD>$prow[1]</TD>
<TD>\$$prow[3]</TD></TR>\n";
$total+=$prow[3];
}
}
}
?>
<tr><td colspan=3><B>Total</TD><TD><B>$<? echo $total ?></TD></TR>
</table>
</BODY>
</HTML>
