<?php

include "db.php";

$year = date("Y",time());
$lyear = $year - 1;
$school_year = "$lyear/$year";

$x = readline("$school_year ::  ");

$today = date("Y-m-d",time());

$query = "SELECT school_num,record_num FROM invoice_header WHERE school_year = '$school_year' AND status IN ('Open','Cancelled')";
$schools = db_query($query);

while ($row = db_fetch_assoc($schools)) {
   $school_num = $row['school_num'];

   $numPaid = db_getVal("SELECT count(*) FROM invoice_header WHERE school_num = $school_num AND school_year = '$school_year' AND status = 'Paid'");
   if ($numPaid > 0) continue;

   $school = db_getVal("SELECT * FROM schools WHERE record_num = $school_num");
   if ($school['expiry_date'] > $today) continue;
   if ($school['status'] != 'Active') continue;

   printf("%6d - %s (%s)\n", $school_num, $school['school_name'], $school['expiry_date']);

   db_query("UPDATE schools SET status = 'Inactive', renewal_invoice_issued = 'N' WHERE record_num = $school_num");
}

?>