if ($type == "person") {
$project = 'Supporter';
+
# Begin transaction
pg_exec($dbh, "BEGIN TRANSACTION") or die ("Could not start transaction.");
$query = sprintf ("DELETE FROM person WHERE oid = %d", $oid);
<when <not <string-eq "$(NILI)" "" />>>
- $query = sprintf("DELETE from nili where person = '%s'", addslashes($name));
+ $query = sprintf("DELETE from nili WHERE person = '%s'", addslashes($name));
pg_exec($dbh, $query) or die ("Cannot delete nilis");
</when>
+ $query = sprintf("DELETE from availability WHERE name = '%s'", addslashes($name));
+ pg_exec($dbh, $query) or die ("Cannot delete availability");
+
+ $query = sprintf("DELETE from assignment WHERE person = '%s'", addslashes($name));
+ pg_exec($dbh, $query) or die ("Cannot delete availability");
+
} else {
$newpass = '';
if ($password == 1) {
</when>
}
+
+ # Now process the availability table
+ $thisday = '';
+ $counter = 0;
+ for ($nr=0; $nr < $maxcounter; $nr++) {
+ $append = sprintf ("_%d", $counter);
+
+ if (strlen ($GLOBALS["date".$append]) > 0) {
+ $thisday = $GLOBALS["date".$append];
+ }
+
+ if ($GLOBALS["oid".$append] > 0) {
+ if (strlen ($GLOBALS["shift".$append]) > 0) {
+ $fromto = split_timeframe ($GLOBALS["shift".$append]);
+ $query = sprintf ("UPDATE availability SET starttime='%s',endtime='%s',comment='%s' "
+ ."WHERE oid = %d",
+ addslashes ($thisday." ".$fromto[0]),
+ addslashes ($thisday." ".$fromto[1]),
+ addslashes ($GLOBALS["comment".$append]),
+ $GLOBALS["oid".$append]);
+ pg_exec($dbh, $query) or die ("Cannot update availability");
+ } else {
+ $query = sprintf ("DELETE FROM availability WHERE oid = %d", $GLOBALS["oid".$append]);
+ pg_exec($dbh, $query) or die ("Cannot delete from availability");
+ }
+ } else {
+ if (strlen ($GLOBALS["shift".$append]) > 0) {
+ $fromto = split_timeframe ($GLOBALS["shift".$append]);
+ $query = sprintf ("INSERT INTO availability (person,starttime,endtime,comment) "
+ ."VALUES ('%s','%s','%s','%s')",
+ addslashes ($name),
+ addslashes ($thisday." ".$fromto[0]),
+ addslashes ($thisday." ".$fromto[1]),
+ addslashes ($GLOBALS["comment".$append]));
+ pg_exec($dbh, $query) or die ("Cannot insert into availability");
+ }
+ }
+
+ $counter++;
+ }
}
# Finish transaction