<?php

include "db.php";


$query = "SELECT school_num, payment_reference, count(*) " .
         "FROM user_account " .
         "WHERE transaction_type = 'Payment' " .
         "AND payment_method = 'PayPal' " .
         "AND (transaction_datetime LIKE '2019-01-15 %' " .
            "OR transaction_datetime LIKE '2019-01-17 %') " .
         "AND payment_reference IS NOT NULL AND payment_reference != '' " .
         "GROUP BY 1, 2 " .
         "HAVING count(*) > 1";
$transactions = db_query($query);

while ($row = db_fetch_assoc($transactions)) {
   extract($row);
   echo("$school_num - $payment_reference\n");

   $query = "SELECT * FROM user_account " .
            "WHERE school_num = $school_num " .
            "AND payment_reference = '$payment_reference' " .
            "AND transaction_type = 'Payment' " .
            "AND payment_method = 'PayPal' " .
            "ORDER BY record_num";
   $results = db_query($query);
   $row = db_fetch_assoc($results);
   while ($row = db_fetch_assoc($results)) {
      extract($row);
      echo(" -> $record_num\n");
      db_query("UPDATE user_account SET deleted = 'Y', deleted_datetime = '2019-01-17 16:00:00', deleted_by_user_num = 1, delete_reason = 'PayPal Posting Error' WHERE record_num = $record_num");
   }
}

?>