<?
$pre   = '';
include "common.php";
$title = "U.S. GLOBEC AO's";
$logo  = true;
include HEAD;

//$tbname  = TABLE_EVENTS;
$primary = 'id';
$today   = date('Ymd');
$recent  = date('Ymd',strtotime("-90 days"));

switch ($when){
case 'past':
   $query  = "SELECT * FROM " . TABLE_AO . " WHERE deadline>=" . $recent . " AND deadline<" . $today . " ORDER BY deadline DESC";
   $header = "AO's Concluded in the Last 90 Days";
   break;
case 'old':
   $query  = "SELECT * FROM " . TABLE_AO . " WHERE deadline<" . $recent . " ORDER BY deadline DESC";
   $header = "AO's Older Than 90 Days";
   break;
default:
   $query  = "SELECT * FROM " . TABLE_AO . " WHERE deadline>=" . $today . " OR deadline IS NULL ORDER BY deadline";
   //echo $query;
   $header = "Upcoming AO Deadlines";
   break;
}

$aos = $db->sql_query($query);
?>
<form name="when" method="get" action="">
<select name="when" onChange="whenChange(this.options[this.selectedIndex].value);">
   <option value="" <?if($when == "")echo "selected";?>>Upcoming AO deadlines</option>
   <option value="past" <?if($when == "past")echo "selected";?>>Recently Conclude AO's</option>
   <option value="old" <?if($when == "old")echo "selected";?>>Old AO's</option>
</select>
</form>
<br />
<table style="width: 100%" border="1">
<tr>
   <td align="center">
      <h2><?=$header?></h2>
   </td>
</tr>
<tr>
   <td>
<?
      if($db->sql_numrows($aos)){
         while($row = $db->sql_fetchrow($aos)){
            echo "      <table>\n";
            echo display_ao($row,'      ');
            echo "      </table>\n   <td>\n</tr>\n<tr>\n   <td>\n";
         }
      }
      else{
         echo "      <h2>There are no AO's in this section</h2>\n";
      }
?>

   </td>
</tr>
</table>
<?
include FOOT;
?>
