<br />
<p>
<b>People Connected to This Place:</b>
<ul>
<?php
// find related persons
$records_persons = recordSearch_2('[{"t":"10"},{"related_to:12":"' . $recID . '"} ]');
if (@$records_persons['reccount'] > 0) {
foreach ($records_persons['order'] as $personID) {
//role on address
$person_role = getTermById_2(recordGetRealtionshipType($system, $personID, $recID));
print '<li>' . getFieldValue($records_persons, $personID, DT_NAME) . ' ' . getFieldValue($records_persons, $personID, DT_GIVEN_NAMES) . ' ' . '(' . $person_role . ')';
print '<ul>' . '<li>' . getTermById_2(getFieldValue($records_persons, $personID, DT_PERSON_RACE), 'race') . ', ' . getTermById_2(getFieldValue($records_persons, $personID, DT_GENDER), 'gender') . ', from ' . getTermById_2(getFieldValue($records_persons, $personID, DT_PERSON_BIRTHPLACE), 'origin') . '</li>';
//find reports Report->Person
$records_reports = recordSearch_2('[{"t":"15"},{"related_to:10":"' . $personID . '"} ]');
foreach ($records_reports['order'] as $reportID) {
$relation1 = recordGetRealtionship_2($system, $reportID, $personID, 'report for person');
foreach ($relation1['order'] as $relID) {
$person_age = getFieldValue($relation1, $relID, DT_PERSON_AGE);
if ($person_age > 0) {
print '<li>' . $person_age . ' years of age on ' . getFieldValue($records_reports, $reportID, DT_DATE) . '</li>';
}
$occupation_termid = getFieldValue($relation1, $relID, DT_PERSON_OCCUPATION);
if ($occupation_termid > 0) {
print '<li>' . getTermById_2($occupation_termid) . ' on ' . getFieldValue($records_reports, $reportID, DT_DATE) . '</li>';
}
?>
</ul>
</p>
<p>
<b>Involved in events: </b>
<ul>
<?php
// find related events
$records_events = recordSearch_2('[{"t":"14"},{"related_to:10":"' . $recID . '"} ]');
if (@$records_events['reccount'] > 0) {
foreach ($records_events['order'] as $eventID) {
//get relationship record for related address (or search events with relation at once?)
$term_id = recordGetRealtionshipType($system, $eventID, $recID);
//date and time
$date_out = composeDates($records_events, $eventID, '<b>Date: </b>');
$time_out = composeTime($records_events, $eventID, '<b>Time: </b>');
print '<li><a href="dh_popup.php?db=' . HEURIST_DBNAME . '&full=1&recID=' . $eventID . '">' . getFieldValue($records_events, $eventID, DT_NAME) . '</a> (' . getTermById(getFieldValue($records_events, $eventID, DT_EVENT_TYPE)) . ')';
print '<ul><li>' . $date_out . ' ' . $time_out . '</li>';
//get address of event
$records_address = recordSearch_2('[{"t":"12"},{"relatedfrom:14":"' . $eventID . '"} ]');
foreach ($records_address['order'] as $addrID) {
$relation1 = recordGetRealtionship_2($system, $eventID, $addrID, 'address for event');
// TODO: Remove, enable or explain: $term_id = recordGetRealtionshipType( $system, $recID, $recID );
$event_address = '';
$term_id = getFieldValue($relation1, 0, DT_RELATION_TYPE);
if ($term_id == TERM_MAIN_CRIME_LOCATION) {
$event_address = 'Location: ';
} else {
