#include <lt2001.style>

<page title="Todo" subtitle=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 subject,who,email,date,oid FROM todo WHERE done IS NULL ORDER BY subject";
  $sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!");

  if (pg_NumRows ($sth) > 0) {
    echo ("<h3>Open jobs</h3><ul>");

    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 ("<li> <a href=\"display_todo.php3?oid=%d\">%s</a><br>%s, %s",
        $row['oid'], $row['subject'], $date, $row['who']);
      if (strlen ($row['email'])) {
        echo (" &lt;" . $row['email'] . "&gt;");
      }
    }
    echo ("</ul>");
  }

  $query = "SELECT subject,who,email,date,done,oid FROM todo WHERE done IS NOT NULL ORDER BY subject";
  $sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!");

  if (pg_NumRows ($sth) > 0) {
    echo ("<h3>Done jobs</h3><ul>");

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

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

      printf ("<li> <a href=\"display_todo.php3?oid=%d\">%s</a><br>%s, %s",
        $row['oid'], $row['subject'], $date, $row['who']);
      if (strlen ($row['email'])) {
        echo (" &lt;" . $row['email'] . "&gt;");
      }
      printf ("<br>Done: %s", $done);
    }
    echo ("</ul>");
  }
?>

<a href="edit_todo.php3?oid=<? echo $oid; ?>">Add job</a>

</page>

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