Create("churchil_demo");
function TmpFunc() {
global $sql;
for ($i = 0; $i < $sql->rows; $i++) {
$sql->Fetch($i);
$id = $sql->data[ID];
$fname = $sql->data[FirstName];
$lname = $sql->data[LastName];
$city = $sql->data[City];
$state = $sql->data[State];
$j = $i + 1;
echo("| $j | \n");
echo(" $fname $lname\n");
echo(" of $city, $state |
\n");
}
}
$num1 = $sql->QueryItem("select count(ID) from ACME_Attendee where Paid = 'Y'");
$num2 = $sql->QueryItem("select count(ID) from ACME_Attendee where Paid = 'N' and PaymentType = 'BillMe'");
$num3 = $sql->QueryItem("select count(ID) from ACME_Attendee where Paid = 'N' and PaymentType != 'BillMe' and PaymentType != 'PayAtShow'");
$num4 = $sql->QueryItem("select count(ID) from ACME_Attendee where Paid = 'N' and PaymentType = 'PayAtShow'");
$num5 = $sql->QueryItem("select count(ID) from ACME_Attendee where Paid = 'P'");
?>
Billing List
| Summary |
|---|
| people have paid. |
|---|
| people need to be billed. |
|---|
| people need to have their credit card charged. |
|---|
| people will pay at the seminar. |
|---|
| people with payment pending |
|---|
| To Be Billed |
|---|
Query("select * from ACME_Attendee where Paid = 'N' and PaymentType = 'BillMe'");
TmpFunc();
?>
| Credit Card Charges |
|---|
Query("select * from ACME_Attendee where Paid = 'N' and PaymentType != 'BillMe' and PaymentType != 'PayAtShow'");
TmpFunc();
?>
| Will Pay at Seminar |
|---|
Query("select * from ACME_Attendee where Paid = 'N' and PaymentType = 'PayAtShow'");
TmpFunc();
?>
| Payment Pending |
|---|
Query("select * from ACME_Attendee where Paid = 'P'");
TmpFunc();
?>