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

<page title="Show Project" subtitle=Project>

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

    $query = sprintf ("SELECT description FROM appendix WHERE project = '%s'", $project);
    $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);
	printf ("<blockquote>%s</blockquote>", $row['description']);
      }
    }
  }

  function display_urls ($project, $url)
  {
    global $dbh;

    $query = sprintf ("SELECT oid,url,description FROM urls WHERE project = '%s'", $project);
    $sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!");

    echo ("<strong>URLs</strong>:<br>");
    if (strlen ($url)) {
      printf ("&nbsp;&nbsp;<a href=\"%s\">%s</a> <br>", $url, $project);
    }
    if (pg_NumRows ($sth) > 0) {
      for ($nr=0; $nr < pg_NumRows ($sth); $nr++) {
	$row = pg_fetch_array ($sth, $nr);
	printf ("&nbsp;&nbsp;<a href=\"%s\">%s</a> [<a href=\"edit_url.php3?oid=%d\">edit</a>]<br>",
	  $row['url'], $row['description'], $row['oid']);
      }
    }
  }

  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];
    }
  }

  $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 = sprintf ("SELECT * FROM project WHERE oid = %d ORDER BY name", $oid);
  $sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!");

  if (pg_NumRows ($sth) > 0) {
    $row = pg_fetch_array ($sth, 0);

    $project = $row['name'];

    printf ("<h3><strong>%s</strong></h3>", $row['name']);
    display_description ($row['name']);
    display_urls ($row['name'], $row['url']);

    if (strlen ($row['boothnr'])) {
      printf ("<strong>Booth Nr.</strong>: %s<br>", $row['boothnr']);
    }
    if (strlen ($row['boothsize'])) {
      printf ("<strong>Booth Size</strong>: %d<br>", $row['boothsize']);
    }
    printf ("<strong>Computer</strong>: %d<br>", $row['computer']);
    $comment = $row['comment'];

    $night = night ($project);
    if ($night > 0) {
      printf ("<strong>Night</strong>: %d<br>", $night);
    }
    $query = sprintf ("SELECT name,email,list,oid FROM person WHERE project = '%s' ORDER BY name", $project);
    $sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!");

    if (pg_NumRows ($sth) > 0) {
      printf ("<strong>Members</strong> (%d):<br>", members ($project));
      for ($nr=0; $nr < pg_NumRows ($sth); $nr++) {
	$row = pg_fetch_array ($sth, $nr);
	if ($row['list']) {
	  if (strlen ($row['name']) && ($row['name'] != $row['email'])) {
	  printf ("&nbsp;&nbsp;(<a href=\"edit_person.php3?oid=%d\">%s</a> &lt;%s&gt;)<br>", $row['oid'], $row['name'], $row['email']);
	  } else {
	    printf ("&nbsp;&nbsp;(<a href=\"edit_person.php3?oid=%d\">%s</a>)<br>", $row['oid'], $row['email']);
	  }
	} elseif ($row['email']) {
	  printf ("&nbsp;&nbsp;<a href=\"edit_person.php3?oid=%d\">%s</a> &lt;%s&gt;<br>", $row['oid'], $row['name'], $row['email']);
	} else {
	  printf ("&nbsp;&nbsp;<a href=\"edit_person.php3?oid=%d\">%s</a><br>", $row['oid'], $row['name']);
	}
      }
    }

    # Supplies ----------------------------------------
    $query = sprintf ("SELECT supplies.amount,supplylist.name,supplylist.height,supplylist.width,supplylist.depth,supplylist.id"
		     .",supplylist.price FROM supplylist,supplies "
		     ."WHERE supplylist.id = supplies.supply AND project='%s' ORDER by id",
		     $project);
    $sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!");

    if (pg_NumRows ($sth) > 0) {
      echo "<strong>Supplies</strong><br>";
      $price = 0.00;
      for ($nr=0; $nr < pg_NumRows ($sth); $nr++) {
	$row = pg_fetch_array ($sth, $nr);

	printf ("<br>&nbsp;&nbsp;%d [%s] %s", $row['amount'], $row['id'], $row['name']);
	if ($row['height'] > 0) {
	  printf (" (%dx%dx%d)", $row['height'], $row['width'], $row['depth']);
	}
	$price += ($row['amount'] * $row['price']);
      }
      printf ("<br>Kosten: %6.2f Euro", $price);
    }

    # Comments ----------------------------------------
    $query = sprintf ("SELECT oid,date,who,email,body FROM comments WHERE project = '%s' ORDER BY date", $project);
    $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);

	$date = explode (" ", $row['date']);
	$date = explode ("-", $date[0]);
	$date = sprintf ("%d.%d.%d", $date[2], $date[1], $date[0]);

	printf ("<hr><h3><a href=\"edit_comment.php3?oid=%d\">%s, %s &lt;%s&gt;</a></h3>%s<p>",
	  $row['oid'], $date, $row['who'], $row['email'], $row['body']);
      }
    }

    printf ("<hr><p><a href=\"edit_person.php3?project=%d\">Add member</a> ", $oid);
    printf ("&nbsp;<a href=\"edit_comment.php3?project=%d\">Add comment</a> ", $oid);
    printf ("&nbsp;<a href=\"edit_url.php3?project=%d\">Add url</a> ", $oid);
    printf ("&nbsp;<a href=\"edit_appendix.php3?project=%d\">Edit appendix</a> ", $oid);
    printf ("&nbsp;<a href=\"edit_workshop.php3?project=%d\">Add workshop</a> ", $oid);
    printf ("&nbsp;<a href=\"edit_supplies.php3?project=%d\">Edit supplies</a> ", $oid);
    printf ("&nbsp;<a href=\"edit_project.php3?oid=%d\">Edit project</a>", $oid);

    # FIXME -- DELETEME
    #if (strlen ($comment)) {
    #  echo ("<p>" . $comment . "<p>");
    #}
  }
?>

</page>

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