#include <lt2001.style>

<page title="Night Requirements" subtitle="Night places">

<?
  $t_head  = "<p><div align=\"center\"><table width=\"99%\" cellpadding=\"0\" cellspacing=\"0\" summary=\"\">";
  $t_title = "<tr bgcolor=\"%s\"><th><font face=\"Helvetica,Arial\">Location</font></th><th><font face=\"Helvetica,Arial\">Name</font></th><th><font face=\"Helvetica,Arial\">Project</font></th></tr>";
  $t_row   = "<tr bgcolor=\"%s\"><td><font face=\"Helvetica,Arial\">%s</font></td><td><font face=\"Helvetica,Arial\">%s</font></td><td><font face=\"Helvetica,Arial\">%s</font></td></tr>";
  $t_foot  = "</table></div><p>";

  $dbh = pg_pconnect ("<dbhost>", "<dbport>", "<dbname>")
	       or die("Unable to connect to SQL server");

  # pg_exec ($dbh, "SET DateStyle = 'ISO'") or die("Datenbank-Abfrage!");

  $query = "SELECT night,nightplace,name,email,project,oid FROM person WHERE night = 1 AND list = 0 ORDER BY nightplace,name";
  $sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!");

  if (pg_NumRows ($sth) > 0) {
    echo ($t_head);
    printf ($t_title, "<colh>");

    $color = "<cold>";
    $done = $open = 0;
    for ($nr=0; $nr < pg_NumRows ($sth); $nr++) {
      $color=$color == "<cold>"?"<coln>" : "<cold>";
      $row = pg_fetch_array ($sth, $nr);
      $name = sprintf ("<a href=\"edit_person.php3?oid=%d\">%s</a>", $row['oid'], $row['name']);
      if (strlen ($row['email'])) {
        $name .= " &lt;" . $row['email'] . "&gt;";
      }
      if (strlen ($row['nightplace'])) {
        $done++;
      } else {
        $open++;
	$row['nightplace'] = "&nbsp;";
      }

      printf ($t_row, $color, $row['nightplace'], $name, $row['project']);
    }
    $color=$color == "<cold>"?"<coln>" : "<cold>";
    printf ("<tr bgcolor=\"%s\"><td colspan=\"3\"><font face=\"Helvetica,Arial\"><b>Done: %d<br>Open: %d</b></font></td></tr>",
      $color, $done, $open);

    echo ($t_foot);
  }
?>

</page>

# Local variables:
# mode: text
# mode: auto-fill
# end: