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

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

<?

  $dbh = pg_pconnect ("<dbhost>", "<dbport>", "<dbname>")
	       or die("Unable to connect to SQL server");

  # pg_exec ($dbh, "SET DateStyle = 'ISO'") or die("Datenbank-Abfrage!");

  if ($project) {
    $query = sprintf ("SELECT name FROM project WHERE oid = %d", $project);
  } else {
    $query = sprintf ("SELECT * FROM person WHERE oid = %d", $oid);
  }

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

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

    if ($project) {
      $row['project'] = $row['name'];
      $row['name'] = '';
    } else {
      $name = $row['name'];
    }

# Mögliche Optimierung: Nachfolgende Queries können durch einen
# einzigen Query abgedeckt werden, der alle Tage überdeckt und die
# passenden internen Variablen mit sinnvollen Werten füttert.  Das
# wären dann noch genzu zwei Queries anstelle von fünf.

?>
<form method=post action=update.php3>
<input type=hidden name=type value="person">
<input type=hidden name=oid value="<? echo $oid; ?>">
<center><table cellpadding=0 cellspacing=1>

<row_input	name=name
		title="<b>Name</b>"
		value="<? echo $row['name']; ?>"
		>
<row_input	name=email
		title="<b>E-Mail</b>"
		value="<? echo $row['email']; ?>"
		>

<row_input	name=project
		title="<b>Project</b>"
		value="<? echo $row['project']; ?>"
		>

<? if ($row['list'] == 0) { ?>

<row_input	name=nightplace
		title="<b>Nightplace</b>"
		value="<? echo $row['nightplace']; ?>"
		>
<? } ?>

<row_input	name=comment
		title="<b>Comment</b>"
		value="<? echo $row['comment']; ?>"
		>

<? if ($row['list'] == 0) { ?>
<row_radiobox	name=night
		title="<b>Night</b>"
		checked_0="<? if ($row['night']==0) { echo "checked";} ?>"
		checked_1="<? if ($row['night']==1) { echo "checked";} ?>"
		>
<? } ?>

<row_radiobox	name=infomail
		title="<b>Infomail</b>"
		checked_0="<? if ($row['infomail']==0) { echo "checked";} ?>"
		checked_1="<? if ($row['infomail']==1) { echo "checked";} ?>"
		>

<? if ($row['list'] == 0) { ?>

<row_radiobox	name=insurance
		title="<b>Insurance</b>"
		checked_0="<? if ($row['insurance']==0) { echo "checked";} ?>"
		checked_1="<? if ($row['insurance']==1) { echo "checked";} ?>"
		>

<? } ?>

<row_radiobox	name=list
		title="<b>List</b>"
		checked_0="<? if ($row['list']==0) { echo "checked";} ?>"
		checked_1="<? if ($row['list']==1) { echo "checked";} ?>"
		>

<row_checkbox	name=admin
		title="<b>Admin</b>"
		descr="Manages this project: "
		checked="<? if ($row['admin']==1) { echo \"checked\";} ?>"
		>

<row_checkbox	name=login
		title="<b>Login</b>"
		descr="Permission to log in: "
		checked="<? if ($row['login']==1) { echo \"checked\";} ?>"
		>

<row_input	name=password
		title="<b>Password</b>"
		value=""
		size=20
		>


<? if ($row['list'] == 0) {
  $nili = array ();
  if (!$project) {
    $query = sprintf ("SELECT oid,breakfast,dinner,sleeping FROM nili WHERE person = '%s' AND date = '2001-07-04'",
		      $row['name']);
    $sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!");

    if (pg_NumRows ($sth) > 0) {
      $nili = pg_fetch_array ($sth, 0);
      printf ("<input type=\"hidden\" name=\"oid_07_04\" value=\"%d\">", $nili['oid']);
    }
  }
?>

<row_checkbox	name=dinner_07_04
		title="<b>Wednesday</b>"
		descr="Dinner&nbsp;&nbsp;&nbsp;: "
		checked="<? if ($nili['dinner']==1) { echo \"checked\";} ?>"
		>
<row_checkbox	name=sleeping_07_04
		title="4.7."
		descr="Sleeping&nbsp;: "
		checked="<? if ($nili['sleeping']==1) { echo \"checked\";} ?>"
		>

<?
  $nili = array ();
  if (!$project) {
    $query = sprintf ("SELECT oid,breakfast,dinner,sleeping FROM nili WHERE person = '%s' AND date = '2001-07-05'",
		      $row['name']);
    $sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!");

    if (pg_NumRows ($sth) > 0) {
      $nili = pg_fetch_array ($sth, 0);
      printf ("<input type=\"hidden\" name=\"oid_07_05\" value=\"%d\">", $nili['oid']);
    }
  }
?>

<row_checkbox	name=breakfast_07_05
		title="<b>Thursday</b>"
		descr="Breakfast: "
		checked="<? if ($nili['breakfast']==1) { echo \"checked\";} ?>"
		>
<row_checkbox	name=dinner_07_05
		title="5.7."
		descr="Dinner&nbsp;&nbsp;&nbsp;: "
		checked="<? if ($nili['dinner']==1) { echo \"checked\";} ?>"
		>
<row_checkbox	name=sleeping_07_05
		descr="Sleeping&nbsp;: "
		checked="<? if ($nili['sleeping']==1) { echo \"checked\";} ?>"
		>

<?
  $nili = array ();
  if (!$project) {
    $query = sprintf ("SELECT oid,breakfast,dinner,sleeping FROM nili WHERE person = '%s' AND date = '2001-07-06'",
		      $row['name']);
    $sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!");

    if (pg_NumRows ($sth) > 0) {
      $nili = pg_fetch_array ($sth, 0);
      printf ("<input type=\"hidden\" name=\"oid_07_06\" value=\"%d\">", $nili['oid']);
    }
  }
?>

<row_checkbox	name=breakfast_07_06
		title="<b>Friday</b>"
		descr="Breakfast: "
		checked="<? if ($nili['breakfast']==1) { echo \"checked\";} ?>"
		>
<row_checkbox	name=dinner_07_06
		title="6.7."
		descr="Dinner&nbsp;&nbsp;&nbsp;: "
		checked="<? if ($nili['dinner']==1) { echo \"checked\";} ?>"
		>
<row_checkbox	name=sleeping_07_06
		descr="Sleeping&nbsp;: "
		checked="<? if ($nili['sleeping']==1) { echo \"checked\";} ?>"
		>

<?
  $nili = array ();
  if (!$project) {
    $query = sprintf ("SELECT oid,breakfast,dinner,sleeping FROM nili WHERE person = '%s' AND date = '2001-07-07'",
		      $row['name']);
    $sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!");

    if (pg_NumRows ($sth) > 0) {
      $nili = pg_fetch_array ($sth, 0);
      printf ("<input type=\"hidden\" name=\"oid_07_07\" value=\"%d\">", $nili['oid']);
    }
  }
?>

<row_checkbox	name=breakfast_07_07
		title="<b>Saturday</b>"
		descr="Breakfast: "
		checked="<? if ($nili['breakfast']==1) { echo \"checked\";} ?>"
		>
<row_checkbox	name=dinner_07_07
		title="7.7."
		descr="Dinner&nbsp;&nbsp;&nbsp;: "
		checked="<? if ($nili['dinner']==1) { echo \"checked\";} ?>"
		>
<row_checkbox	name=sleeping_07_07
		descr="Sleeping&nbsp;: "
		checked="<? if ($nili['sleeping']==1) { echo \"checked\";} ?>"
		>

<?
  $nili = array ();
  if (!$project) {
    $query = sprintf ("SELECT oid,breakfast,dinner,sleeping FROM nili WHERE person = '%s' AND date = '2001-07-08'",
		      $row['name']);
    $sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!");

    if (pg_NumRows ($sth) > 0) {
      $nili = pg_fetch_array ($sth, 0);
      printf ("<input type=\"hidden\" name=\"oid_07_08\" value=\"%d\">", $nili['oid']);
    }
  }
?>

<row_checkbox	name=breakfast_07_08
		title="<b>Sunday</b>"
		descr="Breakfast: "
		checked="<? if ($nili['breakfast']==1) { echo \"checked\";} ?>"
		>
<row_checkbox	name=dinner_07_08
		title="8.7."
		descr="Dinner&nbsp;&nbsp;&nbsp;: "
		checked="<? if ($nili['dinner']==1) { echo \"checked\";} ?>"
		>
<row_checkbox	name=sleeping_07_08
		descr="Sleeping&nbsp;: "
		checked="<? if ($nili['sleeping']==1) { echo \"checked\";} ?>"
		>

<?
  $nili = array ();
  if (!$project) {
    $query = sprintf ("SELECT oid,breakfast,dinner,sleeping FROM nili WHERE person = '%s' AND date = '2001-07-09'",
		      $row['name']);
    $sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!");

    if (pg_NumRows ($sth) > 0) {
      $nili = pg_fetch_array ($sth, 0);
      printf ("<input type=\"hidden\" name=\"oid_07_09\" value=\"%d\">", $nili['oid']);
    }
  }
?>

<row_checkbox	name=breakfast_07_09
		title="<b>Monday</b>"
		descr="Breakfast: "
		checked="<? if ($nili['breakfast']==1) { echo \"checked\";} ?>"
		>
<? } ?>

<? if ($oid > 0) { ?>
<row_radiobox	name=delete
		title="<b>Delete</b>"
		checked_0="checked"
		checked_1=""
		>
<? } ?>

<row_submit>

</table></center></form>
<?
  }
?>

</page>

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