<?php
include "db.php";

$query = "SELECT substr(posting_time,1,7),sum(mc_gross),count(*) FROM user_paypal_transactions " .
         "WHERE posting_time > '2014-09-01 00:00:00' " .
         "AND payment_status = 'Completed' " .
         "GROUP BY 1";
$results = db_query($query);

$total = 0;
$subtotal = 0;
$yearly = 0;
while ($row = db_fetch_array($results)) {
   $subtotal += $row[1];
   $total += $row[1];
   $yearly += $row[1];
   $st = '';
   $est = '';
   $annual = '';
   if (strpos($row[0],'-03') || strpos($row[0],'-06') || strpos($row[0],'-09') || strpos($row[0],'-12')) {
      $st = '$'.number_format($subtotal,2);
      $est = '$'.number_format($subtotal * .00074,2);
      $subtotal = 0;
   }
   if (strpos($row[0],'-06')) {
      $annual = '$'.number_format($yearly,2);
      $yearly = 0;
   }
   printf("%10s %17s   %7d   %17s %17s %20s\n",$row[0],'$'.number_format($row[1],2),$row[2],$st,$annual,$est);
}

?>