#include <lt2001.style>
#include "phptools.inc"

<page title="Projekte" subtitle=Index>

<?
  function night ($project)
  {
    global $dbh;

    $query = sprintf ("SELECT COUNT(*) FROM person WHERE project = '%s' AND list = 0 AND night = 1", $project);
    $sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!");

    if (pg_NumRows ($sth) > 0) {
      $row = pg_fetch_array ($sth, 0);
      return $row[0];
    }
  }
  function comments ($project)
  {
    global $dbh;

    $query = sprintf ("SELECT COUNT(*) FROM comments WHERE project = '%s'", $project);
    $sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!");

    if (pg_NumRows ($sth) > 0) {
      $row = pg_fetch_array ($sth, 0);
      return $row[0];
    }
  }

  $t_head  = "<p><div align=\"center\"><table width=\"99%\" cellpadding=\"0\" cellspacing=\"0\" summary=\"\">";
  $t_title = "<tr bgcolor=\"%s\"><th><font face=\"Helvetica,Arial\">Name</font></th><th><font face=\"Helvetica,Arial\">Members</font></th><th><font face=\"Helvetica,Arial\">Night</font></th><th><font face=\"Helvetica,Arial\">Puters</font></th><th><font face=\"Helvetica,Arial\">Size</font></th><th><font face=\"Helvetica,Arial\">Comments</font></th></tr>";
  $t_row   = "<tr bgcolor=\"%s\"><td><font face=\"Helvetica,Arial\">%s</font></td><td align=\"right\"><font face=\"Helvetica,Arial\">%d</font></td><td align=\"right\"><font face=\"Helvetica,Arial\">%d</font></td><td align=\"right\"><font face=\"Helvetica,Arial\">%d</font></td><td align=\"right\"><font face=\"Helvetica,Arial\">%d</font></td><td align=\"right\"><font face=\"Helvetica,Arial\">%d</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 name,oid,boothsize,computer FROM project ORDER BY name";
  $sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!");

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

    $color = "<cold>";
    for ($nr=0; $nr < pg_NumRows ($sth); $nr++) {
      $color=$color == "<cold>"?"<coln>" : "<cold>";
      $row = pg_fetch_array ($sth, $nr);
      $members = members ($row['name']);
      $night = night ($row['name']);
      $comments = comments ($row['name']);
      $name = sprintf ("<a href=\"show.php3?oid=%d\">%s</a>", $row['oid'], $row['name']);
      printf ($t_row, $color, $name, $members, $night, $row['computer'], $row['boothsize'], $comments);
      $sum['project']++;
      $sum['members']+= $members;
      $sum['night']+= $night;
      $sum['comments']+= $comments;
      $sum['computer']+=$row['computer'];
      $sum['boothsize']+=$row['boothsize'];
    }
    $color=$color == "<cold>"?"<coln>" : "<cold>";
    $foo = sprintf ("<b>Sum</b> (%d projects)", $sum['project']);
    printf ($t_row, $color, $foo, $sum['members'], $sum['night'],
	    $sum['computer'], $sum['boothsize'], $sum['comments']);
    echo ($t_foot);
  }
?>

<p><font face="Helvetica,Arial"><b><a href="edit_project.php3?oid=0">New project</a></b></font><p>

</page>

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