#include <infodrom.style>

<page func="Infodrom Oldenburg" title="Todo">

<?
  $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 oid,package,subject,submitted FROM todo WHERE done IS NOT NULL ORDER BY package,submitted";
  $sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!");

  if (pg_NumRows ($sth) > 0) {
    echo ("<table width=\"100%\" border=\"0\" cellspacing=\"3\" bgcolor=\"#f7ba2e\" summary=\"\">");
    echo ("<tr><th width=\"10%\"><font face=\"Helvetica,Arial\">Paket</font></th>");
    echo ("<th width=\"10%\"><font face=\"Helvetica,Arial\">Datum</font></th>");
    echo ("<th width=\"80%\"><font face=\"Helvetica,Arial\">Subject</font></th></tr>");
  }

  for ($nr=0; $nr < pg_NumRows ($sth); $nr++) {
    $row = pg_fetch_array ($sth, $nr);
    $date = explode (" ", $row['submitted']);
    $date = explode ("-", $date[0]);
    $date = sprintf ("%d.%d.%d", $date[2], $date[1], $date[0]);

    printf ("<tr><td align=\"left\" width=\"10%%\"><font face=\"Helvetica,Arial\">%s</font></th>", $row['package']);
    printf ("<td align=\"right\" width=\"10%%\"><font face=\"Helvetica,Arial\">%s</font></th>", $date);
    printf ("<td align=\"left\" width=\"80%%\"><font face=\"Helvetica,Arial\"><a href=\"edit.php?id=%d\">%s</a></font></th></tr>",
      $row['oid'], $row['subject']);
  }
  if (pg_NumRows ($sth) > 0) {
    echo ("</table>");
  }
?>

</table>

</page>

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