<?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);
}

?>