#include <lt2001.style>
#include "edit.style"

<page title="Edit Supplies" subtitle="Supplies">

<?
  $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 name FROM project WHERE oid = %d", $project);
  $sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!");
  if (pg_NumRows ($sth) > 0) {
    $row = pg_fetch_array ($sth, 0);
    printf ("<h3><a href=\"edit_project.php3?oid=%d\">%s</a></h3>", $project, $row['name']);
    $project = $row['name'];
  }
?>

<form method=post action=update.php3>
<input type=hidden name=type value="supplies">
<input type=hidden name=project value="<? echo $project; ?>">
<center><table cellpadding=0 cellspacing=0 width=99%>

<tr bgcolor="<colh>"><th><font face="Helvetica,Arial">Pieces</font></th>
<th><font face="Helvetica,Arial">Pos.-Nr.</font></th>
<th><font face="Helvetica,Arial">Description</font></th>
<th><font face="Helvetica,Arial">Price</font></th></tr>

<?
  function supply ($project, $supply)
  {
    global $dbh;

    $query = sprintf ("SELECT amount FROM supplies WHERE project = '%s' AND supply = '%s'", $project, $supply);
    $sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!");

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

  $t_row   = "<tr bgcolor=\"%s\"><td><font size=\"-2\" face=\"Helvetica,Arial\">"
            ."<input name=\"%s\" value=\"%d\" size=\"5\" maxlength=\"5\"></font></td>"
            ."<td><font face=\"Helvetica,Arial\">%s</font></td>"
            ."<td><font face=\"Helvetica,Arial\"> %s</font></td>"
            ."<td align=\"right\"><font face=\"Helvetica,Arial\">%5.2f </font></td></tr>";

  $query = sprintf ("SELECT oid,name,id,price,height,width,depth FROM supplylist ORDER BY id", $oid);

  $sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!");

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

    for ($nr=0; $nr < pg_NumRows ($sth); $nr++) {
      $row = pg_fetch_array ($sth, $nr);
      $color=$color == "<cold>"?"<coln>" : "<cold>";
      $name = sprintf ("<a href=\"edit_supplylist.php3?oid=%d\">%s</a> (%dx%dx%d)",
              $row['oid'], $row['name'], $row['height'], $row['width'], $row['depth']);
      printf ($t_row, $color, $row['id'], supply ($project, $row['id']), $row['id'], $name, $row['price']);
    }
  }

?>

<tr>
<td colspan=4 align=center bgcolor="<cold>"><font face="Helvetica,Arial"><b><input type=submit value="<?echo $oid?"Change":"Submit";?>"> <input type=reset value="Reset"></b></font></td>
</tr>

</table></center></form>

</page>

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