37 lines
1.2 KiB
PHP
37 lines
1.2 KiB
PHP
<?php
|
|
include "db.php";
|
|
|
|
$query = "SELECT school_num,user_num,count(*) AS payments FROM user_account " .
|
|
"WHERE `transaction_type` = 'Payment' " .
|
|
"AND transaction_datetime > '2014-08-01 00:00:00' " .
|
|
"AND (deleted != 'Y' OR deleted IS NULL) " .
|
|
"group by 1,2 " .
|
|
"having payments > 1";
|
|
$users = db_query($query);
|
|
|
|
$count = 0;
|
|
while ($row = db_fetch_assoc($users)) {
|
|
extract($row);
|
|
|
|
$results = db_query("SELECT * FROM schools WHERE record_num = $school_num");
|
|
$row = db_fetch_assoc($results);
|
|
$school_name = $row['school_name'];
|
|
$post = $row['select_transactions_on_post'];
|
|
if ($post == 'N') continue;
|
|
|
|
$results = db_query("SELECT * FROM users WHERE school_num = $school_num AND record_num = $user_num");
|
|
$row = db_fetch_assoc($results);
|
|
$userid = $row['userid'];
|
|
|
|
$query = "SELECT sum(transaction_amount) AS balance FROM user_account " .
|
|
"WHERE school_num = $school_num " .
|
|
"AND user_num = $user_num " .
|
|
"AND (deleted != 'Y' OR deleted IS NULL)";
|
|
$balance = db_getVal($query);
|
|
|
|
$count++;
|
|
printf("%3d - %5d: %-30s %30s %3d %12.2f\n",$count,$school_num,$school_name,$userid,$payments,$balance);
|
|
}
|
|
|
|
?>
|