#include "party.style"

<auth>

#include <infodrom.style>
#include <debian.style>

<page title="Debian Birthday Party -- Attendees">

<h1 align=center>Attendess at the Debian Birthday Party</h1>

<center><table border=0 cellpadding=2 cellspacing=0>

<tr bgcolor="<eventcolh>">
<th><ifont><strong>Name</strong></ifont></th>
<th><ifont><strong>Type</strong></ifont></th>
<th><ifont><strong>Country</strong></ifont></th>
<th><ifont><strong>City</strong></ifont></th>
<th><ifont><strong>Saturday</strong></ifont></th>
<th><ifont><strong>Sunday</strong></ifont></th>
</tr>

<fetch_days>
<?
  $trow = '
<tr bgcolor="%s">
<td><ifont>%s</ifont></td>
<td align=center><ifont>%s</ifont></td>
<td align=center><ifont>%s</ifont></td>
<td align=center><ifont>%s</ifont></td>
<td align=center><ifont>%s</ifont></td>
<td align=center><ifont>%s</ifont></td>
</tr>';

  $dbh = pg_pconnect ("<dbconnstring>")
	       or die("Unable to connect to SQL server");

  $query = "SELECT id,name,type,country,city FROM party_person ORDER BY name";
  $sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!");

  if (pg_NumRows ($sth) > 0) {
    for ($nr=0; $nr < pg_NumRows ($sth); $nr++) {
      $row = pg_fetch_array ($sth, $nr);
      $days = fetch_days ($dbh, $row['id']);
      $color=$color == "<cold>"?"<coln>":"<cold>";
      $tcountry=$tzip=$tcity=$thardware=$tbooth = '';

      $tcountry = $row['country']; if (!strlen ($tcountry)) {$tcountry = "&nbsp;";}
      $tcity = $row['city']; if (!strlen ($tcity)) {$tcity = "&nbsp;";}
      $tsat = $days['2003-08-16'] == 1 ? "x" : "&nbsp;";
      $tsun = $days['2003-08-17'] == 1 ? "x" : "&nbsp;";

      if ($DEBIAN_AUTH['admin'] == 1) {
        $tname = sprintf ("<a href=\"edit.php3?id=%d\">%s</a>", $row['id'], $row['name']);
      } else {
        $tname = $row['name'];
      }

      printf ($trow, $color, $tname, $row['type'], $tcountry, $tcity, $tsat, $tsun);
    }
  }
?>

</table></center>

<nrpeople>

<p>
<?
  if ($DEBIAN_AUTH['admin'] == 1) {

    $query = "SELECT count(*) FROM party_person";
    $sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!");
    if (pg_NumRows ($sth) > 0) {
      $row = pg_fetch_array ($sth, 0);
      printf ("<br>%d attendants total", $row[0]);
    }

    $query = "SELECT count(*) FROM party_attend WHERE day = '2003-08-16'";
    $sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!");
    if (pg_NumRows ($sth) > 0) {
      $row = pg_fetch_array ($sth, 0);
      printf ("<br>%d attendants on Saturday", $row[0]);
    }

    $query = "SELECT count(*) FROM party_attend WHERE day = '2003-08-17'";
    $sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!");
    if (pg_NumRows ($sth) > 0) {
      $row = pg_fetch_array ($sth, 0);
      printf ("<br>%d attendants on Sunday", $row[0]);
    }

    $query = "SELECT count(*) FROM party_person WHERE food = 'vegetarian'";
    $sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!");
    if (pg_NumRows ($sth) > 0) {
      $row = pg_fetch_array ($sth, 0);
      printf ("<br>%d vegetarian", $row[0]);
    }

    $query = "SELECT count(*) FROM party_person WHERE food = 'vegan'";
    $sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!");
    if (pg_NumRows ($sth) > 0) {
      $row = pg_fetch_array ($sth, 0);
      printf ("<br>%d vegan", $row[0]);
    }

  }
?>

</page>

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