#include <lt2001.style>

<page title="Workshops" subtitle="Workshops">

<define-tag nextrow whitespace=delete>
if ($nr < pg_NumRows ($sth)) {
  $row = pg_fetch_array ($sth, $nr++);
  $rdate = explode (" ", $row['date_time']);
  $rtime = $rdate[1];
  $rdate = $rdate[0];
  $rtime = explode (":", $rtime);
  $rtime = sprintf ("%s:%s", $rtime[0], $rtime[1]);
  $rows++;
}
</define-tag>

<?
  $t_head  = "<p><div align=\"center\"><table width=\"99%%\" cellpadding=\"0\" cellspacing=\"0\" summary=\"\">"
	    ."<tr bgcolor=\"%s\"><th><font face=\"Helvetica,Arial\">Time</font></th>";
  $t_room  = "<th><font face=\"Helvetica,Arial\">%s</font></th>";
  $t_head2 = "</tr>";

  $t_row   = "<tr bgcolor=\"%s\">";
  $t_time  = "<td><font face=\"Helvetica,Arial\">%s</font></td>";
  $t_talk  = "<td><font face=\"Helvetica,Arial\"><font size=\"-1\"><b>%s</b>: </font><font size=\"-1\">%s</font></font></td>";
  $t_talke = "<td>&nbsp;</td>";
  $t_row2  = "</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 room,date_time,title,speaker,oid FROM workshop ORDER BY date_time,room";
  $sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!");

  if (pg_NumRows ($sth) > 0) {
    $nr = 0;
    $color = "<coln>";

    $day[]="2001-07-05";
    $day[]="2001-07-06";
    $day[]="2001-07-07";
    $day[]="2001-07-08";
    $time[]="10:00";
    $time[]="11:00";
    $time[]="12:00";
    $time[]="13:00";
    $time[]="14:00";
    $time[]="15:00";
    $time[]="16:00";
    $time[]="17:00";
    $room[]="CCA III";
    $room[]="CCA IV";

    $rows = 0;
    <nextrow>
    for ($thisday=$day[0],$daycount=1; $daycount<=count($day); $thisday=$day[$daycount++]) {
      printf ("<h3>Day %s</h3>", $thisday);
      printf ($t_head, "<colh>");
      for ($thisroom=$room[0],$roomcount=1; $roomcount<=count($room); $thisroom=$room[$roomcount++]) {
        printf ($t_room, $thisroom);
      }
      echo ($t_head2);
      $color = "<cold>";

      for ($thistime=$time[0],$timecount=1; $timecount<=count($time); $thistime=$time[$timecount++]) {
        $color=$color == "<cold>"?"<coln>" : "<cold>";
        printf ($t_row, $color);
	printf ($t_time, $thistime);

        for ($thisroom=$room[0],$roomcount=1; $roomcount<=count($room); $thisroom=$room[$roomcount++]) {
	  if (($rdate == $thisday) && ($rtime == $thistime) && ($row['room'] == $thisroom)) {
	    $talk = sprintf ("<a href=\"edit_workshop.php3?oid=%d\">%s</a>", $row['oid'], $row['title']);
	    printf ($t_talk, $row['speaker'], $talk);
	    <nextrow>
	  } else {
	    echo ($t_talke);
	  }
	}
	echo ($t_row2);
      }
      echo ($t_foot);
    }
    printf ("<p>%d sessions", $rows);
  }
?>

<p><a href="edit_workshop.php3">Add workshop</a><p>

</page>

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