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();
}
