function setup_edit() { $rel = new Relationship(); $rel->setFromRequest(); if (!$rel->relation->person_id) { $rel->relation->person_id = -1; } $pdao = getPeopleDAO(); if ($rel->person->person_id > 0) { $dao = getRelationsDAO(); $dao->getRelationshipDetails($rel); if ($rel->numResults > 0) { $ret = $rel->results[0]; $pdao->getParents($ret->relation); } } else { $ret = $rel; } $pdao->getParents($ret->person); $dao = getEventDAO(); $e = new Event(); $e->event_id = $ret->event->event_id; $dao->getEvents($e, Q_REL, true); if ($e->numResults == 0) { $e = new Event(); $e->type = MARRIAGE_EVENT; $ret->event = $e; } else { $ret->event = $e->results[0]; } $ret->event->person->person_id = 'null'; return $ret; }
function addRelationships() { $search = new Relationship(); $dao = getRelationsDAO(); $dao->getMarriages($search); $i = 0; foreach ($search->results as $rel) { $this->addNode($rel->person, $rel->event->event_id); $this->addNode($rel->relation, $rel->event->event_id); $this->addLink($rel->person, $rel->relation, 'Marriage ' . $rel->dom); } }
function get_spouse_string($per) { global $tblprefix, $datefmt, $strBorn, $strDied, $restrictdate, $strLivingPerson, $strDeceasedPerson; $rel = new Relationship(); $rel->person = $per; $dao = getRelationsDAO(); $dao->getRelationshipDetails($rel); $ret = ""; foreach ($rel->results as $marriage) { if (!isset($marriage->relation->person_id)) { continue; } $ret .= " X"; if ($marriage->isViewable()) { $ret .= $marriage->dom; } $ret .= "X "; $ret .= "{" . $marriage->relation->getDisplayName() . "}"; } return $ret; }
function show_relations($per) { global $strMarriage, $strRestricted, $strOn, $strAt, $strCertified, $strEdit, $strDelete; $editable = $per->isEditable(); $search = new Relationship(); $search->setFromRequest(); $dao = getRelationsDAO(); $dao->getRelationshipDetails($search); $count = 0; for ($i = 0; $i < $search->numResults; $i++) { $rel = $search->results[$i]; if (!isset($rel->relation->person_id)) { continue; } if ($i > 0) { echo "<hr/>"; } $count++; echo $rel->relation->getLink(); if ($rel->isViewable()) { if ($rel->marriage_date != "0000-00-00") { echo " " . $strOn . " " . $rel->dom; } echo $rel->marriage_place->getAtDisplayPlace(); } if ($rel->marriage_cert == "Y") { echo " ({$strCertified})"; } if ($rel->isEditable()) { echo " (<a href=\"edit.php?func=edit&area=relations&person=" . $rel->person->person_id . "&event=" . $rel->event->event_id . "\">" . $strEdit . "</a>)"; echo " (<a href=\"JavaScript:confirm_delete('" . $rel->relation->getDisplayName() . "', '" . strtolower($strMarriage) . "', 'passthru.php?func=delete&area=marriage&person=" . $rel->person->person_id . "&event=" . $rel->event->event_id . "')\" class=\"delete\">" . $strDelete . "</a>)"; } insertChildrenLink($rel->person->person_id, $rel->relation->person_id, $rel->person->gender, $rel->isEditable()); } return $count; }
echo $strMarriages; ?> </th> <th><?php echo $strDate; ?> </th> <th><?php echo $strAnniversary; ?> </th> </tr> <?php $search = new Relationship(); $search->count = 6; $dao = getRelationsDAO(); $dao->getNearest($search); $i = 0; foreach ($search->results as $rel) { if ($i == 0 || fmod($i, 2) == 0) { $class = "tbl_odd"; } else { $class = "tbl_even"; } list($yom, $mom, $dom) = explode("-", $rel->marriage_date); ?> <tr> <td class="<?php echo $class; ?> " align="left"><?php
function get_edit_form($search) { global $strYear, $strSource, $strSchedule; global $strSubmit, $strReset; ?> <!--Fill out the form--> <form method="post" action="passthru.php?area=census"> <input type="hidden" name="person" value="<?php echo $search->event->person->person_id; ?> "/> <input type="hidden" name="d1type" value="8" size="30" /> <input type="hidden" name="date1" id="date1" value="<?php echo $search->event->date1; ?> " size="30" /> <input type="hidden" name="etype" value="<?php echo CENSUS_EVENT; ?> " /> <table> <tr><td><table><tr><th></th><?php showEventHeaderFields(CENSUS_EVENT); ?> <th><?php echo $strSchedule; ?> </th></tr> <tr><td class="tbl_even"><?php list_censuses("frmYear", $search->census); ?> </td> <?php showEventEditCols($search->event, CENSUS_EVENT); ?> <td class="tbl_even"><input type="text" name="schedule" value="<?php echo $search->schedule; ?> "/></td> </tr> </table> </td></tr> <tr> <td class="tbl_even"> <?php $sp = $search->event->person; $sp = $search->person; $people = array($sp); $rel = new Relationship(); $rel->person = $sp; $dao = getRelationsDAO(); $dao->getRelationshipDetails($rel); if ($rel->numResults > 0) { $spouses = $rel->results; foreach ($spouses as $partner) { $relation = $partner->relation; if (isset($relation) && $relation->person_id > 0 && $relation->isEditable()) { $people[] = $relation; } } } $dao = getPeopleDAO(); $per = $sp; if ($dao->getChildren($per) > 0) { foreach ($per->children as $child) { if ($child->isEditable()) { $people[] = $child; } } } attendeeEditTable($search->event, CENSUS_EVENT, $people); ?> </table></td> </tr> <tr> <td class="tbl_even"><input type="submit" name="Submit1" value="<?php echo $strSubmit; ?> " /></td> <td class="tbl_even"><input type="reset" name="Reset1" value="<?php echo $strReset; ?> " /></td> </tr> </table> </form> <?php }
function deletePerson($per) { global $tblprefix, $err_child_update, $err_person_delete; // there's a lot to do here $this->startTrans(); $dao = getEventDAO(); $dao->deletePersonEvents($per, BIRTH_EVENT); // delete transcripts $trans = new Transcript(); $trans->person = $per; $tdao = getTranscriptDAO(); $tdao->getTranscripts($trans); for ($i = 0; $i < $trans->numResults; $i++) { $tdao->deleteTranscript($trans->results[$i]); } // delete censuses $cdao = getCensusDAO(); $cdao->deletePersonCensusRecord($per); // delete images $img = new Image(); $img->person = $per; $idao = getImageDAO(); $idao->getImages($img); for ($i = 0; $i < $img->numResults; $i++) { $idao->deleteImage($img->results[$i]); } // delete marriages $rdao = getRelationsDAO(); $rdao->deletePersonRelationshipDetails($per); // delete tracking $dtquery = "DELETE FROM " . $tblprefix . "tracking WHERE person_id = '" . $per->person_id . "'"; $dtresult = $this->runQuery($dtquery, $err_person_delete); // update children to point to the right person $ucquery = "UPDATE " . $tblprefix . "people SET mother_id = '0' WHERE mother_id = '" . $per->person_id . "'"; $ucresult = $this->runQuery($ucquery, $err_child_update); $ucquery = "UPDATE " . $tblprefix . "people SET father_id = '0' WHERE father_id = '" . $per->person_id . "'"; $ucresult = $this->runQuery($ucquery, $err_child_update); // names $dpquery = "DELETE FROM " . $tblprefix . "names WHERE person_id = '" . $per->person_id . "'"; $dpresult = $this->runQuery($dpquery, $err_person_delete); // finally, the person $dpquery = "DELETE FROM " . $tblprefix . "people WHERE person_id = '" . $per->person_id . "'"; $dpresult = $this->runQuery($dpquery, $err_person_delete); $this->commitTrans(); }