} else {
show_person($personDb);
}
} else {
$privcount++;
// If it is a privacy person and it's an birth/ death search
// - don't show anything:
// it's not allowed to search a privacy restricted with non-privacy data!
}
} else {
// No privacy restrictions
// *** Extra privacy filter check for total_filter ***
if ($user["group_pers_hide_totally_act"] == 'j' and strpos(' ' . $personDb->pers_own_code, $user["group_pers_hide_totally"]) > 0) {
$privcount++;
} else {
show_person($personDb);
}
}
}
}
echo '</table>';
if ($privcount) {
echo "<br>" . $privcount . __(' persons are not shown due to privacy settings') . ".<br>";
}
//echo '</div>';
// *** Don't executed this code if spouse search is used ***
if (!$selection['spouse_firstname'] and !$selection['spouse_lastname']) {
echo '<br><div class="index_list1">' . $line_pages . '</div>';
}
//echo '</div>';
//for testing only:
$personDb = $db_functions->get_person($familyDb->fam_man);
// *** Person class used for name and person pop-up data ***
$man_cls = new person_cls();
$man_cls->construct($personDb);
// *** Woman privacy filter ***
$personDb = $db_functions->get_person($familyDb->fam_woman);
// *** Person class used for name and person pop-up data ***
$woman_cls = new person_cls();
$woman_cls->construct($personDb);
// *** Proces marriage using a class ***
$marriage_cls = new marriage_cls();
$marriage_cls->construct($familyDb, $man_cls->privacy, $woman_cls->privacy);
$family_privacy = $marriage_cls->privacy;
// *** $family_privacy='1' = filter ***
if ($family_privacy) {
$privcount++;
} else {
show_person($familyDb);
}
}
echo '</table>';
if ($privcount) {
echo "<br>" . $privcount . __(' persons are not shown due to privacy settings') . ".<br>";
}
echo '<br><div class="index_list1">' . $line_pages . '</div>';
//for testing only:
//echo 'Query: '.$query." LIMIT ".safe_text($item).",".$nr_persons.'<br>';
//echo 'Count qry: '.$count_qry.'<br>';
//echo '<p>index_list: '.$index_list;
//echo '<br>nr. of persons: '.$count_persons;
include_once CMS_ROOTPATH . "footer.php";
function show_event($selected_events = '')
{
global $dbh, $tree_id, $page, $tree_prefix, $pers_gedcomnumber, $marriage, $field_date, $field_text, $joomlastring;
global $editor_cls, $path_prefix, $tree_pict_path;
// *** Picture list for selecting pictures ***
$datasql = $dbh->query("SELECT * FROM humo_trees WHERE tree_prefix='" . $tree_prefix . "'");
$dataDb = $datasql->fetch(PDO::FETCH_OBJ);
$tree_pict_path = $dataDb->tree_pict_path;
$dir = $path_prefix . $tree_pict_path;
if (file_exists($dir)) {
$dh = opendir($dir);
while (false !== ($filename = readdir($dh))) {
if (substr($filename, 0, 6) != 'thumb_' and $filename != '.' and $filename != '..') {
$picture_array[] = $filename;
}
}
}
// *** Order pictures by alphabet ***
@sort($picture_array);
$nr_pictures = count($picture_array);
// *** Change line colour ***
$change_bg_colour = ' class="humo_color3"';
$event_group = 'event_person=1';
// *** Show all events EXCEPT for events allready processed by person data (profession etc.) ***
if ($selected_events == 'person') {
$event_group = 'event_person=1';
$qry = "SELECT * FROM humo_events\r\n\t\t\tWHERE event_tree_id='" . $tree_id . "' AND event_person_id='" . $pers_gedcomnumber . "'\r\n\t\t\tAND event_kind!='name'\r\n\t\t\tAND event_kind!='nobility'\r\n\t\t\tAND event_kind!='title'\r\n\t\t\tAND event_kind!='lordship'\r\n\t\t\tAND event_kind!='birth_declaration'\r\n\t\t\tAND event_kind!='baptism_witness'\r\n\t\t\tAND event_kind!='death_declaration'\r\n\t\t\tAND event_kind!='burial_witness'\r\n\t\t\tAND event_kind!='profession'\r\n\t\t\tAND event_kind!='picture'\r\n\t\t\tORDER BY event_kind, event_order";
} elseif ($selected_events == 'name') {
$event_group = 'event_person=1';
$qry = "SELECT * FROM humo_events\r\n\t\t\tWHERE event_tree_id='" . $tree_id . "' AND event_person_id='" . $pers_gedcomnumber . "' AND event_kind='name' ORDER BY event_order";
} elseif ($selected_events == 'nobility') {
$event_group = 'event_person=1';
$qry = "SELECT * FROM humo_events\r\n\t\t\tWHERE event_tree_id='" . $tree_id . "' AND event_person_id='" . $pers_gedcomnumber . "' AND event_kind='nobility' ORDER BY event_order";
} elseif ($selected_events == 'title') {
$event_group = 'event_person=1';
$qry = "SELECT * FROM humo_events WHERE event_tree_id='" . $tree_id . "' AND event_person_id='" . $pers_gedcomnumber . "' AND event_kind='title' ORDER BY event_order";
} elseif ($selected_events == 'lordship') {
$event_group = 'event_person=1';
$qry = "SELECT * FROM humo_events\r\n\t\t\tWHERE event_tree_id='" . $tree_id . "' AND event_person_id='" . $pers_gedcomnumber . "' AND event_kind='lordship' ORDER BY event_order";
} elseif ($selected_events == 'birth_declaration') {
$event_group = 'event_person=1';
$qry = "SELECT * FROM humo_events\r\n\t\t\tWHERE event_tree_id='" . $tree_id . "' AND event_person_id='" . $pers_gedcomnumber . "' AND event_kind='birth_declaration' ORDER BY event_order";
} elseif ($selected_events == 'baptism_witness') {
$event_group = 'event_person=1';
$qry = "SELECT * FROM humo_events\r\n\t\t\tWHERE event_tree_id='" . $tree_id . "' AND event_person_id='" . $pers_gedcomnumber . "' AND event_kind='baptism_witness' ORDER BY event_order";
} elseif ($selected_events == 'death_declaration') {
$event_group = 'event_person=1';
$qry = "SELECT * FROM humo_events\r\n\t\t\tWHERE event_tree_id='" . $tree_id . "' AND event_person_id='" . $pers_gedcomnumber . "' AND event_kind='death_declaration' ORDER BY event_order";
} elseif ($selected_events == 'burial_witness') {
$event_group = 'event_person=1';
$qry = "SELECT * FROM humo_events WHERE event_tree_id='" . $tree_id . "' AND event_person_id='" . $pers_gedcomnumber . "' AND event_kind='burial_witness' ORDER BY event_order";
} elseif ($selected_events == 'profession') {
$event_group = 'event_person=1';
$qry = "SELECT * FROM humo_events\r\n\t\t\tWHERE event_tree_id='" . $tree_id . "' AND event_person_id='" . $pers_gedcomnumber . "' AND event_kind='profession' ORDER BY event_order";
} elseif ($selected_events == 'picture') {
$event_group = 'event_person=1';
$qry = "SELECT * FROM humo_events\r\n\t\t\tWHERE event_tree_id='" . $tree_id . "' AND event_person_id='" . $pers_gedcomnumber . "' AND event_kind='picture' ORDER BY event_order";
} elseif ($selected_events == 'family') {
$event_group = 'event_family=1';
$qry = "SELECT * FROM humo_events \r\n\t\t\tWHERE event_tree_id='" . $tree_id . "' AND event_family_id='" . $marriage . "'\r\n\t\t\tAND event_kind!='marriage_witness'\r\n\t\t\tAND event_kind!='marriage_witness_rel'\r\n\t\t\tAND event_kind!='picture'\r\n\t\t\tORDER BY event_kind, event_order";
} elseif ($selected_events == 'marriage_witness') {
$event_group = 'event_family=1';
$qry = "SELECT * FROM humo_events\r\n\t\t\tWHERE event_tree_id='" . $tree_id . "' AND event_family_id='" . $marriage . "' AND event_kind='marriage_witness' ORDER BY event_kind, event_order";
} elseif ($selected_events == 'marriage_witness_rel') {
$event_group = 'event_family=1';
$qry = "SELECT * FROM humo_events\r\n\t\t\tWHERE event_tree_id='" . $tree_id . "' AND event_family_id='" . $marriage . "' AND event_kind='marriage_witness_rel' ORDER BY event_kind, event_order";
} elseif ($selected_events == 'marriage_picture') {
$event_group = 'event_family=1';
$qry = "SELECT * FROM humo_events\r\n\t\t\tWHERE event_tree_id='" . $tree_id . "' AND event_family_id='" . $marriage . "' AND event_kind='picture' ORDER BY event_order";
}
$data_list_qry = $dbh->query($qry);
// *** Show events by person ***
if ($selected_events == 'person') {
echo '<tr><td style="border-right:0px;"><a name="event_person_link"><a href="#event_person_link" onclick="hideShow(51);"><span id="hideshowlink51">' . __('[+]') . '</span></a> ' . __('Events') . '</td>';
echo '<td style="border-right:0px;">';
//echo '<a href="index.php?'.$joomlastring.'page='.$page.'&menu_admin=person&event_add=add_event">'.__('Add').'</a>';
echo '</td><td style="border-left:0px;">';
$count_event = $dbh->query("SELECT * FROM humo_events\r\n\t\t\t\tWHERE event_tree_id='" . $tree_id . "' AND event_person_id='" . $pers_gedcomnumber . "'\r\n\t\t\t\tAND event_kind!='name'\r\n\t\t\t\tAND event_kind!='nobility'\r\n\t\t\t\tAND event_kind!='title'\r\n\t\t\t\tAND event_kind!='lordship'\r\n\t\t\t\tAND event_kind!='birth_declaration'\r\n\t\t\t\tAND event_kind!='baptism_witness'\r\n\t\t\t\tAND event_kind!='death_declaration'\r\n\t\t\t\tAND event_kind!='burial_witness'\r\n\t\t\t\tAND event_kind!='profession'\r\n\t\t\t\tAND event_kind!='picture'\r\n\t\t\t\tORDER BY event_kind, event_order");
$count = $count_event->rowCount();
echo $count . ' x ' . __('Events');
echo '. ' . __('For items like:') . ' ' . __('Event') . ', ' . __('baptized as child') . ', ' . __('depart') . ' ' . __('etc.');
echo '</td>';
echo '<td></td>';
echo '</tr>';
}
// *** Show events by family ***
if ($selected_events == 'family') {
echo '<tr class="humo_color"><td style="border-right:0px;"><a name="event_family_link"><a href="#event_family_link" onclick="hideShow(52);"><span id="hideshowlink52">' . __('[+]') . '</span></a> ' . __('Events') . '</td>';
echo '<td style="border-right:0px;">';
//echo '<a href="index.php?'.$joomlastring.'page='.$page.'&menu_admin=person&event_add=add_event">'.__('Add').'</a>';
echo '</td><td style="border-left:0px;">';
$count_event = $dbh->query("SELECT * FROM humo_events\r\n\t\t\t\tWHERE event_tree_id='" . $tree_id . "' AND event_family_id='" . $marriage . "'\r\n\t\t\t\tAND event_kind!='marriage_witness'\r\n\t\t\t\tAND event_kind!='marriage_witness_rel'\r\n\t\t\t\tAND event_kind!='picture'\r\n\t\t\t\tORDER BY event_kind, event_order");
$count = $count_event->rowCount();
echo $count . ' x ' . __('Events');
echo '. ' . __('For items like:') . ' ' . __('Event') . ', ' . __('Marriage contract') . ', ' . __('Marriage license') . ', ' . __('etc.');
// __('Marriage settlement')
// __('Marriage bond')
// __('Divorce filed')
// __('Annulled')
// __('Engaged')
// __('Sealed to spouse LDS')
echo '</td>';
echo '<td></td>';
echo '</tr>';
}
// *** Show name by person ***
if ($selected_events == 'name') {
//echo '<tr style="display:none;" class="row1" name="row1">';
echo '<tr style="display:none;" class="row1">';
echo '<td></td>';
echo '<td style="border-right:0px;">' . __('Name') . '</td>';
echo '<td style="border-left:0px;">';
echo '<a href="index.php?' . $joomlastring . 'page=' . $page . '&menu_admin=person&event_add=add_name">[' . __('Add') . ']</a> ';
echo __('Nickname') . ', ' . __('alias name') . ', ' . __('Adopted name') . ', ' . __('Hebrew name') . ', ' . __('etc.');
echo '</td>';
echo '<td></td>';
echo '</tr>';
}
// *** Show nobility by person ***
if ($selected_events == 'nobility') {
//echo '<tr style="display:none;" class="row1" name="row1">';
echo '<tr style="display:none;" class="row1">';
echo '<td></td>';
echo '<td style="border-right:0px;">' . __('Title of Nobility') . '</td>';
echo '<td style="border-left:0px;">';
echo '<a href="index.php?' . $joomlastring . 'page=' . $page . '&menu_admin=person&event_add=add_nobility">[' . __('Add') . ']</a> ' . __('e.g. Jhr., Jkvr.') . '</td>';
echo '<td></td>';
echo '</tr>';
}
// *** Show title by person ***
if ($selected_events == 'title') {
echo '<tr style="display:none;" class="row1" name="row1">';
//echo '<tr class="table_header" style="display:none;" id="row1" name="row1">';
echo '<td></td>';
echo '<td style="border-right:0px;">' . __('Title') . '</td>';
echo '<td style="border-left:0px;">';
echo '<a href="index.php?' . $joomlastring . 'page=' . $page . '&menu_admin=person&event_add=add_title">[' . __('Add') . ']</a> ' . __('e.g. Prof., Dr.') . '</td>';
echo '<td></td>';
echo '</tr>';
}
// *** Show lordship by person ***
if ($selected_events == 'lordship') {
echo '<tr style="display:none;" class="row1" name="row1">';
echo '<td></td>';
echo '<td style="border-right:0px;">' . __('Title of Lordship') . '</td>';
echo '<td style="border-left:0px;">';
echo '<a href="index.php?' . $joomlastring . 'page=' . $page . '&menu_admin=person&event_add=add_lordship">[' . __('Add') . ']</a> ' . __('e.g. Lord of Amsterdam') . '</td>';
echo '<td></td>';
echo '</tr>';
}
// *** Show birth declaration by person ***
if ($selected_events == 'birth_declaration') {
echo '<tr class="humo_color row2" style="display:none;" name="row2">';
//echo '<tr class="table_header" style="display:none;" id="row2" name="row2">';
echo '<td></td>';
echo '<td style="border-right:0px;">' . __('birth declaration') . '</td>';
echo '<td style="border-left:0px;">';
echo '<a href="index.php?' . $joomlastring . 'page=' . $page . '&menu_admin=person&event_add=add_birth_declaration">[' . __('Add') . ']</a></td>';
echo '<td></td>';
echo '</tr>';
}
// *** Show baptism witness by person ***
if ($selected_events == 'baptism_witness') {
echo '<tr style="display:none;" class="row3" name="row3">';
//echo '<tr class="table_header" style="display:none;" id="row3" name="row3">';
echo '<td></td>';
echo '<td style="border-right:0px;">' . __('baptism witness') . '</td>';
echo '<td style="border-left:0px;">';
echo '<a href="index.php?' . $joomlastring . 'page=' . $page . '&menu_admin=person&event_add=add_baptism_witness">[' . __('Add') . ']</a></td>';
echo '<td></td>';
echo '</tr>';
}
// *** Show death declaration by person ***
if ($selected_events == 'death_declaration') {
echo '<tr class="humo_color row4" style="display:none;" name="row4">';
//echo '<tr class="table_header" style="display:none;" id="row4" name="row4">';
echo '<td></td>';
echo '<td style="border-right:0px;">' . __('death declaration') . '</td>';
echo '<td style="border-left:0px;">';
echo '<a href="index.php?' . $joomlastring . 'page=' . $page . '&menu_admin=person&event_add=add_death_declaration">[' . __('Add') . ']</a></td>';
echo '<td></td>';
echo '</tr>';
}
// *** Show burial witness by person ***
if ($selected_events == 'burial_witness') {
echo '<tr style="display:none;" class="row5" name="row5">';
//echo '<tr class="table_header" style="display:none;" id="row5" name="row5">';
echo '<td></td>';
echo '<td style="border-right:0px;">' . __('burial witness') . '</td>';
echo '<td style="border-left:0px;">';
echo '<a href="index.php?' . $joomlastring . 'page=' . $page . '&menu_admin=person&event_add=add_burial_witness">[' . __('Add') . ']</a></td>';
echo '<td></td>';
echo '</tr>';
}
// *** Show profession by person ***
if ($selected_events == 'profession') {
//echo '<tr class="humo_color">';
echo '<tr>';
echo '<td style="border-right:0px;">';
echo '<a name="profession"></a>';
$count = $data_list_qry->rowCount();
if ($count > 0) {
echo '<a href="#profession" onclick="hideShow(50);"><span id="hideshowlink50">' . __('[+]') . '</span></a> ';
}
echo __('Profession') . '</td>';
echo '<td style="border-right:0px;"></td>';
echo '<td style="border-left:0px;">';
echo '<a href="index.php?' . $joomlastring . 'page=' . $page . '&menu_admin=person&event_add=add_profession#profession">[' . __('Add') . ']</a> ';
$text = '';
while ($data_listDb = $data_list_qry->fetch(PDO::FETCH_OBJ)) {
if ($text) {
$text .= ', ';
}
$text .= $data_listDb->event_event;
}
echo $text;
echo '</td>';
echo '<td></td>';
echo '</tr>';
}
// *** Show pictures by person and family ***
if ($selected_events == 'picture' or $selected_events == 'marriage_picture') {
echo '<tr class="humo_color">';
echo '<td style="border-right:0px;">';
echo '<a name="picture"></a>';
$count_qry = $dbh->query($qry);
$count = $count_qry->rowCount();
if ($count > 0) {
echo '<a href="#picture" onclick="hideShow(53);"><span id="hideshowlink53">' . __('[+]') . '</span></a> ';
}
echo __('Picture/ Media') . '</td>';
echo '<td style="border-right:0px;"></td>';
echo '<td style="border-left:0px;">';
$event_add = 'add_picture';
//if ($selected_events=='marriage_picture') $event_add='add_marriage_picture';
if ($selected_events == 'marriage_picture') {
$event_add = 'add_marriage_picture&marriage_nr=' . $marriage;
}
echo '<a href="index.php?' . $joomlastring . 'page=' . $page . '&menu_admin=person&event_add=' . $event_add . '#picture">[' . __('Add') . ']</a> ';
if ($count > 1) {
echo " " . __('(Drag pictures to change display order)');
}
echo ' <a href="index.php?page=thumbs">' . __('Pictures/ create thumbnails') . '.</a>';
echo '<ul id="sortable_pic" class="sortable_pic handle_pic" style="width:auto">';
while ($data_listDb = $data_list_qry->fetch(PDO::FETCH_OBJ)) {
echo '<li style="word-wrap:break-word;hight:auto;" id="' . $data_listDb->event_id . '" class="mediamove">';
echo '<div style="position:relative">';
if ($count > 1) {
echo '<div style="position:absolute;top:0;left:0">';
$show_image = '<img src="' . CMS_ROOTPATH_ADMIN . 'images/drag-icon.gif" style="float:left;vertical-align:top;height:16px;">';
echo $show_image;
echo '</div>';
}
echo '<div style="overflow:hidden">';
$thumb_prefix = '';
if (file_exists($path_prefix . $tree_pict_path . 'thumb_' . $data_listDb->event_event)) {
$thumb_prefix = 'thumb_';
}
$extensions_check = substr($path_prefix . $tree_pict_path . $data_listDb->event_event, -3, 3);
if ($extensions_check == "jpg" or $extensions_check == "gif" or $extensions_check == "png" or $extensions_check == "bmp") {
if (file_exists($path_prefix . $tree_pict_path . $thumb_prefix . $data_listDb->event_event)) {
$show_image = '<img src="' . $path_prefix . $tree_pict_path . $thumb_prefix . $data_listDb->event_event . '" style="height:80px;">';
} else {
$show_image = '<img src="../images/thumb_missing-image.jpg" height="60px">';
}
if (!$data_listDb->event_event) {
$show_image = ' <img src="../images/thumb_missing-image.jpg" height="60px">';
}
echo $show_image;
} else {
$ext = substr($data_listDb->event_event, -3, 3);
if ($ext == "tif" or $ext == "iff") {
echo '<span style="font-size:80%">[' . __('Format not supported') . "]</span>";
} elseif ($ext == "pdf") {
echo '<img src="../images/pdf.jpeg" style="width:30px;height:30px;">';
} elseif ($ext == "doc") {
echo '<img src="../images/msdoc.gif" style="width:30px;height:30px;">';
} elseif ($ext == "avi" or $ext == "wmv" or $ext == "mpg" or $ext == "mov") {
echo '<img src="../images/video-file.png" style="width:30px;height:30px;">';
} elseif ($ext == "wma" or $ext == "wav" or $ext == "mp3" or $ext == "mid" or $ext == "ram" or $ext == ".ra") {
echo '<img src="../images/audio.gif" style="width:30px;height:30px;">';
}
echo '<br><span style="font-size:85%">' . $data_listDb->event_event . '</span>';
}
// *** No picture selected yet, show dummy picture ***
if (!$data_listDb->event_event) {
echo '<img src="../images/thumb_missing-image.jpg" height="60px">';
}
echo '</div>';
echo '</div>';
echo '</li>';
}
echo '</ul>';
//echo $text;
$data_list_qry = $dbh->query($qry);
$data_listDb = $data_list_qry->fetch(PDO::FETCH_OBJ);
?>
<script>
$('#sortable_pic').sortable().bind('sortupdate', function() {
var mediastring = "";
var media_arr = document.getElementsByClassName("mediamove");
for (var z = 0; z < media_arr.length; z++) {
// create the new order after dragging to store in database with ajax
mediastring = mediastring + media_arr[z].id + ";";
// change the order numbers of the pics in the pulldown (that was generated before the drag
// so that if one presses on delete before refresh the right pic will be deleted !!
}
mediastring = mediastring.substring(0, mediastring.length-1); // take off last ;
var parnode = document.getElementById('pic_main_' + media_arr[0].id).parentNode;
var picdomclass = document.getElementsByClassName("pic_row2");
var nextnode = picdomclass[(picdomclass.length)-1].nextSibling;
for(var d=media_arr.length-1; d >=0 ; d--) {
parnode.insertBefore(document.getElementById('pic_row2_' + media_arr[d].id),nextnode);
nextnode = document.getElementById('pic_row2_' + media_arr[d].id);
parnode.insertBefore(document.getElementById('pic_row1_' + media_arr[d].id),nextnode);
nextnode = document.getElementById('pic_row1_' + media_arr[d].id);
parnode.insertBefore(document.getElementById('pic_main_' + media_arr[d].id),nextnode);
nextnode = document.getElementById('pic_main_' + media_arr[d].id);
}
$.ajax({
url: "include/drag.php?drag_kind=media&mediastring=" + mediastring ,
success: function(data){
} ,
error: function (xhr, ajaxOptions, thrownError) {
alert(xhr.status);
alert(thrownError);
}
});
});
</script>
<?php
echo '</td>';
echo '<td></td>';
echo '</tr>';
}
// *** Show marriage witness by family ***
if ($selected_events == 'marriage_witness') {
echo '<tr style="display:none;" class="row8" name="row8">';
//echo '<tr class="table_header" style="display:none;" id="row8" name="row8">';
echo '<td></td>';
echo '<td style="border-right:0px;">' . __('marriage witness') . '</td>';
echo '<td style="border-left:0px;">';
echo '<a href="index.php?' . $joomlastring . 'page=' . $page . '&menu_admin=person&event_add=add_marriage_witness&marriage_nr=' . $marriage . '#event_family_link">[' . __('Add') . ']</a></td>';
echo '<td></td>';
echo '</tr>';
}
// *** Show marriage witness (church) by family ***
if ($selected_events == 'marriage_witness_rel') {
echo '<tr style="display:none;" class="row10" name="row10">';
//echo '<tr class="table_header" style="display:none;" id="row10" name="row10">';
echo '<td></td>';
echo '<td style="border-right:0px;">' . __('marriage witness (religious)') . '</td>';
echo '<td style="border-left:0px;">';
echo '<a href="index.php?' . $joomlastring . 'page=' . $page . '&menu_admin=person&event_add=add_marriage_witness_rel&marriage_nr=' . $marriage . '#event_family_link">[' . __('Add') . ']</a></td>';
echo '<td style="border-left:0px;"></td>';
echo '</tr>';
}
$data_list_qry = $dbh->query($qry);
while ($data_listDb = $data_list_qry->fetch(PDO::FETCH_OBJ)) {
echo '<input type="hidden" name="event_id[' . $data_listDb->event_id . ']" value="' . $data_listDb->event_id . '">';
$expand_link = '';
$internal_link = '#';
if ($selected_events == 'person') {
//$change_bg_colour=' class="humo_color"';
$expand_link = ' style="display:none;" class="row51" name="row51"';
$internal_link = '#event_person_link';
}
if ($selected_events == 'family') {
//$change_bg_colour=' class="humo_color"';
$expand_link = ' style="display:none;" class="row52" name="row52"';
$internal_link = '#event_family_link';
}
if ($selected_events == 'name') {
//$change_bg_colour=' class="humo_color"';
$change_bg_colour = '';
$expand_link = ' style="display:none;" class="row1" name="row1"';
$internal_link = '#';
}
if ($selected_events == 'nobility') {
//$change_bg_colour=' class="humo_color"';
$change_bg_colour = '';
$expand_link = ' style="display:none;" class="row1" name="row1"';
}
if ($selected_events == 'title') {
//$change_bg_colour=' class="humo_color"';
$change_bg_colour = '';
$expand_link = ' style="display:none;" class="row1" name="row1"';
}
if ($selected_events == 'lordship') {
//$change_bg_colour=' class="humo_color"';
$change_bg_colour = '';
$expand_link = ' style="display:none;" class="row1" name="row1"';
}
if ($selected_events == 'birth_declaration') {
//$change_bg_colour='';
$change_bg_colour = ' class="humo_color"';
$expand_link = ' style="display:none;" class="row2 humo_color" name="row2"';
}
if ($selected_events == 'baptism_witness') {
//$change_bg_colour=' class="humo_color"';
$change_bg_colour = '';
$expand_link = ' style="display:none;" class="row3" name="row3"';
}
if ($selected_events == 'death_declaration') {
//$change_bg_colour='';
$change_bg_colour = ' class="humo_color"';
$expand_link = ' style="display:none;" class="row4 humo_color" name="row4"';
}
if ($selected_events == 'burial_witness') {
//$change_bg_colour=' class="humo_color"';
$change_bg_colour = '';
$expand_link = ' style="display:none;" class="row5" name="row5"';
}
if ($selected_events == 'profession') {
//$change_bg_colour=' class="humo_color"';
$change_bg_colour = '';
$expand_link = ' style="display:none;" class="row50" name="row50"';
$internal_link = '#profession';
}
if ($selected_events == 'picture' or $selected_events == 'marriage_picture') {
//$change_bg_colour='';
$change_bg_colour = ' class="humo_color"';
$expand_link = ' style="display:none;" id="pic_main_' . $data_listDb->event_id . '" class="pic_main row53 humo_color" name="row53"';
$internal_link = '#picture';
}
if ($selected_events == 'marriage_witness') {
//$change_bg_colour=' class="humo_color"';
$change_bg_colour = '';
$expand_link = ' style="display:none;" class="row8" name="row8"';
$internal_link = '#event_family_link';
}
if ($selected_events == 'marriage_witness_rel') {
//$change_bg_colour=' class="humo_color"';
$change_bg_colour = '';
$expand_link = ' style="display:none;" class="row10" name="row10"';
$internal_link = '#event_family_link';
}
echo '<tr' . $expand_link . '>';
// *** Show name of event and [+] link ***
echo '<td>';
echo ' <a href="' . $internal_link . '" onclick="hideShow(' . $data_listDb->event_id . '00);"><span id="hideshowlink' . $data_listDb->event_id . '00">' . __('[+]') . '</span></a>';
//echo ' #'.$data_listDb->event_order;
echo '<a href="index.php?' . $joomlastring . 'page=' . $page . '&' . $event_group . '&event_kind=' . $data_listDb->event_kind . '&event_drop=' . $data_listDb->event_order . '"><img src="' . CMS_ROOTPATH_ADMIN . 'images/button_drop.png" border="0" alt="down"></a>';
if ($data_listDb->event_kind != 'picture') {
// *** Count number of events ***
if ($event_group == 'event_person=1') {
$count_event = $dbh->query("SELECT * FROM humo_events\r\n\t\t\t\t\t\tWHERE event_tree_id='" . $tree_id . "' AND event_person_id='" . $pers_gedcomnumber . "' AND event_kind='" . $data_listDb->event_kind . "'");
} elseif ($event_group == 'event_family=1') {
$count_event = $dbh->query("SELECT * FROM humo_events\r\n\t\t\t\t\t\tWHERE event_tree_id='" . $tree_id . "' AND event_family_id='" . $marriage . "' AND event_kind='" . $data_listDb->event_kind . "'");
}
$count = $count_event->rowCount();
// *** dummy is not really necessary, but otherwise it's not possible to click an arrow twice ***
if ($data_listDb->event_order < $count) {
echo ' <a href="index.php?' . $joomlastring . 'page=' . $page . '&' . $event_group . '&event_down=' . $data_listDb->event_order . '&event_kind=' . $data_listDb->event_kind . '&dummy=' . $data_listDb->event_id . $internal_link . '"><img src="' . CMS_ROOTPATH_ADMIN . 'images/arrow_down.gif" border="0" alt="down"></a>';
} else {
echo ' ';
}
// *** dummy is not really necessary, but otherwise it's not possible to click an arrow twice ***
if ($data_listDb->event_order > 1) {
echo ' <a href="index.php?' . $joomlastring . 'page=' . $page . '&' . $event_group . '&event_up=' . $data_listDb->event_order . '&event_kind=' . $data_listDb->event_kind . '&dummy=' . $data_listDb->event_id . $internal_link . '"><img src="' . CMS_ROOTPATH_ADMIN . 'images/arrow_up.gif" border="0" alt="down"></a>';
} else {
echo ' ';
}
}
echo '</td>';
echo '<td style="border-right:0px;">';
echo $this->event_text($data_listDb->event_kind);
echo '<br>';
if ($data_listDb->event_kind == 'picture') {
$thumb_prefix = '';
if (file_exists($path_prefix . $tree_pict_path . 'thumb_' . $data_listDb->event_event)) {
$thumb_prefix = 'thumb_';
}
$extensions_check = substr($path_prefix . $tree_pict_path . $data_listDb->event_event, -3, 3);
if (strtolower($extensions_check) == "pdf") {
echo '<a href="' . $path_prefix . $tree_pict_path . $data_listDb->event_event . '"><img src="' . CMS_ROOTPATH . 'images/pdf.jpeg"></a>';
} elseif (strtolower($extensions_check) == "doc" or strtolower(substr($path_prefix . $tree_pict_path . $data_listDb->event_event, -4, 4)) == "docx") {
echo '<a href="' . $path_prefix . $tree_pict_path . $data_listDb->event_event . '"><img src="' . CMS_ROOTPATH . 'images/msdoc.gif"></a>';
} elseif ($extensions_check == "avi") {
echo '<a href="' . $path_prefix . $tree_pict_path . $data_listDb->event_event . '" target="_blank"><img src="' . CMS_ROOTPATH . 'images/video-file.png"></a>';
} elseif ($extensions_check == "wmv") {
echo '<a href="' . $path_prefix . $tree_pict_path . $data_listDb->event_event . '" target="_blank"><img src="' . CMS_ROOTPATH . 'images/video-file.png"></a>';
} elseif (strtolower($extensions_check) == "mpg") {
echo '<a href="' . $path_prefix . $tree_pict_path . $data_listDb->event_event . '" target="_blank"><img src="' . CMS_ROOTPATH . 'images/video-file.png"></a>';
} elseif (strtolower($extensions_check) == "mov") {
echo '<a href="' . $path_prefix . $tree_pict_path . $data_listDb->event_event . '" target="_blank"><img src="' . CMS_ROOTPATH . 'images/video-file.png"></a>';
} elseif (strtolower($extensions_check) == "wma") {
echo '<a href="' . $path_prefix . $tree_pict_path . $data_listDb->event_event . '" target="_blank"><img src="' . CMS_ROOTPATH . 'images/audio.gif"></a>';
} elseif (strtolower($extensions_check) == "wav") {
echo '<a href="' . $path_prefix . $tree_pict_path . $data_listDb->event_event . '" target="_blank"><img src="' . CMS_ROOTPATH . 'images/audio.gif"></a>';
} elseif (strtolower($extensions_check) == "mp3") {
echo '<a href="' . $path_prefix . $tree_pict_path . $data_listDb->event_event . '" target="_blank"><img src="' . CMS_ROOTPATH . 'images/audio.gif"></a>';
} elseif (strtolower($extensions_check) == "mid") {
echo '<a href="' . $path_prefix . $tree_pict_path . $data_listDb->event_event . '" target="_blank"><img src="' . CMS_ROOTPATH . 'images/audio.gif"></a>';
} elseif (strtolower($extensions_check) == "ram") {
echo '<a href="' . $path_prefix . $tree_pict_path . $data_listDb->event_event . '" target="_blank"><img src="' . CMS_ROOTPATH . 'images/audio.gif"></a>';
} elseif (strtolower($extensions_check) == ".ra") {
echo '<a href="' . $path_prefix . $tree_pict_path . $data_listDb->event_event . '" target="_blank"><img src="' . CMS_ROOTPATH . 'images/audio.gif"></a>';
} else {
$show_image = '';
if (file_exists($path_prefix . $tree_pict_path . $thumb_prefix . $data_listDb->event_event)) {
$show_image = '<img src="' . $path_prefix . $tree_pict_path . $thumb_prefix . $data_listDb->event_event . '" width="100px">';
} else {
$show_image = '<img src="../images/thumb_missing-image.jpg" height="100px">';
}
if (!$data_listDb->event_event) {
$show_image = ' <img src="../images/thumb_missing-image.jpg" height="80px">';
}
echo $show_image;
}
}
echo '</td>';
// *** Witness and declaration persons ***
if ($data_listDb->event_kind == 'baptism_witness' or $data_listDb->event_kind == 'birth_declaration' or $data_listDb->event_kind == 'death_declaration' or $data_listDb->event_kind == 'burial_witness') {
echo '<td style="border-left:0px;">';
witness_edit($data_listDb->event_event, '[' . $data_listDb->event_id . ']');
} elseif ($data_listDb->event_kind == 'picture') {
// *** Show pull-down list pictures ***
echo '<td style="border-left:0px;"><select size="1" name="text_event[' . $data_listDb->event_id . ']">';
echo '<option value=""></option>';
for ($picture_nr = 0; $picture_nr < $nr_pictures; $picture_nr++) {
$selected = '';
if ($picture_array[$picture_nr] == $data_listDb->event_event) {
$selected = ' SELECTED';
}
echo '<option value="' . $picture_array[$picture_nr] . '"' . $selected . '>' . $picture_array[$picture_nr] . '</option>';
}
echo '</select>';
} elseif ($data_listDb->event_kind == 'adoption') {
echo '<td style="border-left:0px;"><select size="1" name="text_event[' . $data_listDb->event_id . ']">';
echo '<option value="">' . __('* Select adoption parents *') . '</option>';
// *** Search for adoption parents ***
$family_parents = $dbh->query("SELECT * FROM humo_families WHERE fam_tree_id='" . $tree_id . "' ORDER BY fam_gedcomnumber");
while ($family_parentsDb = $family_parents->fetch(PDO::FETCH_OBJ)) {
$parent_text = '[' . $family_parentsDb->fam_gedcomnumber . '] ';
//*** Father ***
if ($family_parentsDb->fam_man) {
$parent_text .= show_person($family_parentsDb->fam_man);
} else {
$parent_text = __('N.N.');
}
$parent_text .= ' ' . __('and') . ' ';
//*** Mother ***
if ($family_parentsDb->fam_woman) {
$parent_text .= show_person($family_parentsDb->fam_woman);
} else {
$parent_text .= __('N.N.');
}
$selected = '';
if ($family_parentsDb->fam_gedcomnumber == $data_listDb->event_event) {
$selected = ' SELECTED';
}
echo '<option value="' . $family_parentsDb->fam_gedcomnumber . '"' . $selected . '>' . $parent_text . '</option>';
}
echo '</select>';
} elseif ($data_listDb->event_kind == 'person_colour_mark') {
// *** Needed for descendants/ ascendants color ***
echo '<input type="hidden" name="event_event_old[' . $data_listDb->event_id . ']" value="' . $data_listDb->event_event . '">';
$person_colour_mark = $data_listDb->event_event;
echo '<td style="border-left:0px;">';
echo '<select class="fonts" size="1" name="text_event[' . $data_listDb->event_id . ']">';
echo '<option value="0">' . __('Change colour mark by person') . '</option>';
$selected = '';
if ($person_colour_mark == '1') {
$selected = ' selected';
}
echo '<option value="1" style="color:#FF0000;"' . $selected . '>' . __('Colour 1') . '</option>';
$selected = '';
if ($person_colour_mark == '2') {
$selected = ' selected';
}
echo '<option value="2" style="color:#00FF00;"' . $selected . '>' . __('Colour 2') . '</option>';
$selected = '';
if ($person_colour_mark == '3') {
$selected = ' selected';
}
echo '<option value="3" style="color:#0000FF;"' . $selected . '>' . __('Colour 3') . '</option>';
$selected = '';
if ($person_colour_mark == '4') {
$selected = ' selected';
}
echo '<option value="4" style="color:#FF00FF;"' . $selected . '>' . __('Colour 4') . '</option>';
$selected = '';
if ($person_colour_mark == '5') {
$selected = ' selected';
}
echo '<option value="5" style="color:#FFFF00;"' . $selected . '>' . __('Colour 5') . '</option>';
$selected = '';
if ($person_colour_mark == '6') {
$selected = ' selected';
}
echo '<option value="6" style="color:#00FFFF;"' . $selected . '>' . __('Colour 6') . '</option>';
$selected = '';
if ($person_colour_mark == '7') {
$selected = ' selected';
}
echo '<option value="7" style="color:#C0C0C0;"' . $selected . '>' . __('Colour 7') . '</option>';
$selected = '';
if ($person_colour_mark == '8') {
$selected = ' selected';
}
echo '<option value="8" style="color:#800000;"' . $selected . '>' . __('Colour 8') . '</option>';
$selected = '';
if ($person_colour_mark == '9') {
$selected = ' selected';
}
echo '<option value="9" style="color:#008000;"' . $selected . '>' . __('Colour 9') . '</option>';
$selected = '';
if ($person_colour_mark == '10') {
$selected = ' selected';
}
echo '<option value="10" style="color:#000080;"' . $selected . '>' . __('Colour 10') . '</option>';
$selected = '';
if ($person_colour_mark == '11') {
$selected = ' selected';
}
echo '<option value="11" style="color:#800080;"' . $selected . '>' . __('Colour 11') . '</option>';
$selected = '';
if ($person_colour_mark == '12') {
$selected = ' selected';
}
echo '<option value="12" style="color:#A52A2A;"' . $selected . '>' . __('Colour 12') . '</option>';
$selected = '';
if ($person_colour_mark == '13') {
$selected = ' selected';
}
echo '<option value="13" style="color:#008080;"' . $selected . '>' . __('Colour 13') . '</option>';
$selected = '';
if ($person_colour_mark == '14') {
$selected = ' selected';
}
echo '<option value="14" style="color:#808080;"' . $selected . '>' . __('Colour 14') . '</option>';
echo '</select>';
$pers_colour = '';
if ($person_colour_mark == '1') {
$pers_colour = 'style="color:#FF0000;"';
}
if ($person_colour_mark == '2') {
$pers_colour = 'style="color:#00FF00;"';
}
if ($person_colour_mark == '3') {
$pers_colour = 'style="color:#0000FF;"';
}
if ($person_colour_mark == '4') {
$pers_colour = 'style="color:#FF00FF;"';
}
if ($person_colour_mark == '5') {
$pers_colour = 'style="color:#FFFF00;"';
}
if ($person_colour_mark == '6') {
$pers_colour = 'style="color:#00FFFF;"';
}
if ($person_colour_mark == '7') {
$pers_colour = 'style="color:#C0C0C0;"';
}
if ($person_colour_mark == '8') {
$pers_colour = 'style="color:#800000;"';
}
if ($person_colour_mark == '9') {
$pers_colour = 'style="color:#008000;"';
}
if ($person_colour_mark == '10') {
$pers_colour = 'style="color:#000080;"';
}
if ($person_colour_mark == '11') {
$pers_colour = 'style="color:#800080;"';
}
if ($person_colour_mark == '12') {
$pers_colour = 'style="color:#A52A2A;"';
}
if ($person_colour_mark == '13') {
$pers_colour = 'style="color:#008080;"';
}
if ($person_colour_mark == '14') {
$pers_colour = 'style="color:#808080;"';
}
echo ' <span ' . $pers_colour . '>' . __('Selected colour') . '</span>';
// *** Also change color of ascendants and/ or descendants ***
$check = '';
//if (isset($xx) AND $xx=='y'){ $check=' checked'; }
echo '<br>' . __('Also change') . ' <input type="checkbox" name="pers_colour_desc[' . $data_listDb->event_id . ']" ' . $check . '> ' . __('Descendants');
echo '<input type="checkbox" name="pers_colour_anc[' . $data_listDb->event_id . ']" ' . $check . '> ' . __('Ancestors');
} else {
echo '<td style="border-left:0px;"><input type="text" name="text_event[' . $data_listDb->event_id . ']" value="' . $data_listDb->event_event . '" size="60">';
}
if ($data_listDb->event_kind == 'nobility') {
echo ' ' . __('e.g. Jhr., Jkvr.');
} elseif ($data_listDb->event_kind == 'title') {
echo ' ' . __('e.g. Prof., Dr.');
} elseif ($data_listDb->event_kind == 'lordship') {
echo ' ' . __('e.g. Lord of Amsterdam');
}
// *** Select type of event ***
if ($data_listDb->event_kind == 'event') {
echo ' <select size="1" name="event_gedcom[' . $data_listDb->event_id . ']" style="width: 150px">';
if ($selected_events == 'person') {
event_option($data_listDb->event_gedcom, 'EVEN');
event_option($data_listDb->event_gedcom, 'ARVL');
event_option($data_listDb->event_gedcom, 'BAPM');
event_option($data_listDb->event_gedcom, 'DPRT');
event_option($data_listDb->event_gedcom, 'LEGI');
event_option($data_listDb->event_gedcom, 'MILI');
event_option($data_listDb->event_gedcom, 'SLGL');
event_option($data_listDb->event_gedcom, 'TXPY');
event_option($data_listDb->event_gedcom, 'ADOP');
event_option($data_listDb->event_gedcom, '_ADPF');
event_option($data_listDb->event_gedcom, '_ADPM');
event_option($data_listDb->event_gedcom, 'BAPL');
event_option($data_listDb->event_gedcom, 'BARM');
event_option($data_listDb->event_gedcom, 'BASM');
event_option($data_listDb->event_gedcom, 'BLES');
event_option($data_listDb->event_gedcom, 'CENS');
event_option($data_listDb->event_gedcom, 'CHRA');
event_option($data_listDb->event_gedcom, 'CONF');
event_option($data_listDb->event_gedcom, 'CONL');
event_option($data_listDb->event_gedcom, 'EMIG');
event_option($data_listDb->event_gedcom, 'ENDL');
event_option($data_listDb->event_gedcom, 'FCOM');
event_option($data_listDb->event_gedcom, '_FNRL');
event_option($data_listDb->event_gedcom, 'GRAD');
event_option($data_listDb->event_gedcom, 'IMMI');
event_option($data_listDb->event_gedcom, 'NATU');
event_option($data_listDb->event_gedcom, 'ORDN');
event_option($data_listDb->event_gedcom, 'PROB');
event_option($data_listDb->event_gedcom, 'RETI');
event_option($data_listDb->event_gedcom, 'SLGC');
event_option($data_listDb->event_gedcom, 'WILL');
event_option($data_listDb->event_gedcom, '_YART');
event_option($data_listDb->event_gedcom, '_INTE');
event_option($data_listDb->event_gedcom, '_BRTM');
event_option($data_listDb->event_gedcom, '_NMAR');
event_option($data_listDb->event_gedcom, 'NCHI');
event_option($data_listDb->event_gedcom, 'EDUC');
event_option($data_listDb->event_gedcom, 'NATI');
event_option($data_listDb->event_gedcom, 'CAST');
event_option($data_listDb->event_gedcom, 'AFN');
event_option($data_listDb->event_gedcom, 'SSN');
event_option($data_listDb->event_gedcom, 'IDNO');
event_option($data_listDb->event_gedcom, '_HEIG');
event_option($data_listDb->event_gedcom, '_WEIG');
event_option($data_listDb->event_gedcom, '_EYEC');
event_option($data_listDb->event_gedcom, '_HAIR');
event_option($data_listDb->event_gedcom, '_MEDC');
event_option($data_listDb->event_gedcom, 'PROP');
}
if ($selected_events == 'family') {
// *** Marriage events ***
event_option($data_listDb->event_gedcom, 'EVEN');
event_option($data_listDb->event_gedcom, '_MBON');
event_option($data_listDb->event_gedcom, 'MARC');
event_option($data_listDb->event_gedcom, 'MARL');
event_option($data_listDb->event_gedcom, 'MARS');
event_option($data_listDb->event_gedcom, 'DIVF');
event_option($data_listDb->event_gedcom, 'ANUL');
event_option($data_listDb->event_gedcom, 'ENGA');
event_option($data_listDb->event_gedcom, 'SLGS');
}
echo '</select>';
}
if ($data_listDb->event_kind == 'name') {
echo ' <select size="1" name="event_gedcom[' . $data_listDb->event_id . ']" style="width: 150px">';
$event = '_AKAN';
$selected = '';
if ($data_listDb->event_gedcom == $event) {
$selected = ' SELECTED';
}
echo '<option value="' . $event . '"' . $selected . '>_AKAN ' . __('Also known as') . '</option>';
$event = 'NICK';
$selected = '';
if ($data_listDb->event_gedcom == $event) {
$selected = ' SELECTED';
}
echo '<option value="' . $event . '"' . $selected . '>NICK ' . __('Nickname') . '</option>';
$event = '_ALIA';
$selected = '';
if ($data_listDb->event_gedcom == $event) {
$selected = ' SELECTED';
}
echo '<option value="' . $event . '"' . $selected . '>_ALIA ' . __('alias name') . '</option>';
$event = '_SHON';
$selected = '';
if ($data_listDb->event_gedcom == $event) {
$selected = ' SELECTED';
}
echo '<option value="' . $event . '"' . $selected . '>_SHON ' . __('Short name (for reports)') . '</option>';
$event = '_ADPN';
$selected = '';
if ($data_listDb->event_gedcom == $event) {
$selected = ' SELECTED';
}
echo '<option value="' . $event . '"' . $selected . '>_ADPN ' . __('Adopted name') . '</option>';
$event = '_HEBN';
$selected = '';
if ($data_listDb->event_gedcom == $event) {
$selected = ' SELECTED';
}
echo '<option value="' . $event . '"' . $selected . '>_HEBN ' . __('Hebrew name') . '</option>';
$event = '_CENN';
$selected = '';
if ($data_listDb->event_gedcom == $event) {
$selected = ' SELECTED';
}
echo '<option value="' . $event . '"' . $selected . '>_CENN ' . __('Census name') . '</option>';
$event = '_MARN';
$selected = '';
if ($data_listDb->event_gedcom == $event) {
$selected = ' SELECTED';
}
echo '<option value="' . $event . '"' . $selected . '>_MARN ' . __('Married name') . '</option>';
$event = '_GERN';
$selected = '';
if ($data_listDb->event_gedcom == $event) {
$selected = ' SELECTED';
}
echo '<option value="' . $event . '"' . $selected . '>_GERN ' . __('Nickname') . '</option>';
$event = '_FARN';
$selected = '';
if ($data_listDb->event_gedcom == $event) {
$selected = ' SELECTED';
}
echo '<option value="' . $event . '"' . $selected . '>_FARN ' . __('Farm name') . '</option>';
$event = '_BIRN';
$selected = '';
if ($data_listDb->event_gedcom == $event) {
$selected = ' SELECTED';
}
echo '<option value="' . $event . '"' . $selected . '>_BIRN ' . __('Birth name') . '</option>';
$event = '_INDN';
$selected = '';
if ($data_listDb->event_gedcom == $event) {
$selected = ' SELECTED';
}
echo '<option value="' . $event . '"' . $selected . '>_INDN ' . __('Indian name') . '</option>';
$event = '_FKAN';
$selected = '';
if ($data_listDb->event_gedcom == $event) {
$selected = ' SELECTED';
}
echo '<option value="' . $event . '"' . $selected . '>_FKAN ' . __('Formal name') . '</option>';
$event = '_CURN';
$selected = '';
if ($data_listDb->event_gedcom == $event) {
$selected = ' SELECTED';
}
echo '<option value="' . $event . '"' . $selected . '>_CURN ' . __('Current name') . '</option>';
$event = '_SLDN';
$selected = '';
if ($data_listDb->event_gedcom == $event) {
$selected = ' SELECTED';
}
echo '<option value="' . $event . '"' . $selected . '>_SLDN ' . __('Soldier name') . '</option>';
$event = '_RELN';
$selected = '';
if ($data_listDb->event_gedcom == $event) {
$selected = ' SELECTED';
}
echo '<option value="' . $event . '"' . $selected . '>_RELN ' . __('Religious name') . '</option>';
$event = '_OTHN';
$selected = '';
if ($data_listDb->event_gedcom == $event) {
$selected = ' SELECTED';
}
echo '<option value="' . $event . '"' . $selected . '>_OTHN ' . __('Other name') . '</option>';
$event = '_FRKA';
$selected = '';
if ($data_listDb->event_gedcom == $event) {
$selected = ' SELECTED';
}
echo '<option value="' . $event . '"' . $selected . '>_FRKA ' . __('Formerly known as') . '</option>';
echo '</select>';
}
//echo '<td><input type="submit" name="submit" title="submit" value="'.__('Save').'"></td></td>';
echo '<td>';
// *** Source by event ***
if ($event_group == 'event_person=1') {
// *** Calculate and show nr. of sources ***
$connect_qry = "SELECT *\r\n\t\t\t\t\tFROM humo_connections\r\n\t\t\t\t\tWHERE connect_tree_id='" . $tree_id . "' AND connect_sub_kind='pers_event_source'\r\n\t\t\t\t\tAND connect_connect_id='" . $data_listDb->event_id . "'";
$connect_sql = $dbh->query($connect_qry);
echo " <a href=\"" . $internal_link . "\" onClick=\"window.open('index.php?page=editor_sources&" . $event_group . "&connect_kind=person&connect_sub_kind=pers_event_source&connect_connect_id=" . $data_listDb->event_id . "', '','width=800,height=500')\">" . __('source');
} else {
// *** Calculate and show nr. of sources ***
$connect_qry = "SELECT *\r\n\t\t\t\t\tFROM humo_connections\r\n\t\t\t\t\tWHERE connect_tree_id='" . $tree_id . "' AND connect_sub_kind='fam_event_source'\r\n\t\t\t\t\tAND connect_connect_id='" . $data_listDb->event_id . "'";
$connect_sql = $dbh->query($connect_qry);
echo " <a href=\"" . $internal_link . "\" onClick=\"window.open('index.php?page=editor_sources&event_family=1&connect_kind=family&connect_sub_kind=fam_event_source&connect_connect_id=" . $data_listDb->event_id . "', '','width=800,height=500')\">" . __('source');
}
echo ' [' . $connect_sql->rowCount() . ']</a>';
echo '</td>';
echo '</tr>';
// *** Date and place line ***
//$internal_link1='style="display:none;" id="row'.$data_listDb->event_id.'00" name="row'.$data_listDb->event_id.'00"';
$pic_row1 = "";
if ($selected_events == 'picture' or $selected_events == 'marriage_picture') {
$pic_row1 = ' id="pic_row1_' . $data_listDb->event_id . '"';
$change_bg_colour = ' class="humo_color pic_row1 row' . $data_listDb->event_id . '00"';
} else {
// *** Date and place line for other events like profession and witnesses etc. ***
if ($change_bg_colour != '') {
$change_bg_colour = substr($change_bg_colour, 0, -1) . ' row' . $data_listDb->event_id . '00"';
} else {
$change_bg_colour = ' class="row' . $data_listDb->event_id . '00"';
}
}
$internal_link1 = 'style="display:none;" ' . $pic_row1 . ' name="row' . $data_listDb->event_id . '00"';
echo '<tr' . $change_bg_colour . ' ' . $internal_link1 . '><td></td>';
echo '<td style="border-right:0px;">' . __('date') . '</td>';
echo '<td style="border-left:0px;">' . $editor_cls->date_show($data_listDb->event_date, 'event_date', "[{$data_listDb->event_id}]") . ' ' . __('place') . ' <input type="text" name="event_place[' . $data_listDb->event_id . ']" placeholder="' . __('place') . '" value="' . $data_listDb->event_place . '" size="' . $field_date . '">';
echo '</td><td>';
echo '</td></tr>';
// *** Text by event ***
$pic_row2 = "";
if ($selected_events == 'picture' or $selected_events == 'marriage_picture') {
$pic_row2 = ' id="pic_row2_' . $data_listDb->event_id . '"';
$change_bg_colour = ' class="humo_color pic_row2 row' . $data_listDb->event_id . '00"';
} else {
// *** Date and place line for other events like profession and witnesses etc. ***
if ($change_bg_colour != '') {
$change_bg_colour = substr($change_bg_colour, 0, -1) . ' row' . $data_listDb->event_id . '00"';
} else {
$change_bg_colour = ' class="row' . $data_listDb->event_id . '00"';
}
}
$internal_link2 = 'style="display:none;" ' . $pic_row2 . ' name="row' . $data_listDb->event_id . '00"';
echo '<tr' . $change_bg_colour . ' ' . $internal_link2 . '><td></td>';
echo '<td style="border-right:0px;">' . __('text') . '</td><td style="border-left:0px;"><textarea rows="1" name="event_text[' . $data_listDb->event_id . ']" ' . $field_text . '>' . $editor_cls->text_show($data_listDb->event_text) . '</textarea>';
echo '</td><td></td></tr>';
if ($change_bg_colour != ' class="humo_color3"') {
$change_bg_colour = ' class="humo_color3"';
} else {
$change_bg_colour = ' class="humo_color2"';
}
}
if ($selected_events == 'picture') {
// *** Upload image ***
//echo '<tr style="display:none;" id="row51" name="row51"><td class="table_header_large" colspan="4">';
echo '<tr style="display:none;" class="row53" name="row53"><td class="table_header_large" colspan="4">';
echo 'Upload new image (max: pic 2MB) or media (max: 49 MB):' . ' <input type="file" name="photo_upload">';
echo '<input type="submit" name="person_event_change" title="submit" value="' . __('Upload') . '">';
echo '</td></tr>';
}
// *** Add person event ***
if ($selected_events == 'person') {
// *** Add person event ***
//echo '<tr bgcolor="#CCFFFF" style="display:none;" class="row51" name="row51"><td>'.__('Add event').'</td><td style="border-right:0px;"></td><td style="border-left:0px;">';
echo '<tr bgcolor="#CCFFFF"><td>' . __('Add event') . '</td><td style="border-right:0px;"></td><td style="border-left:0px;">';
echo '<select size="1" name="event_kind">';
//echo '<option value="profession">'.__('Profession').'</option>';
//echo '<option value="picture">'.__('Picture/ Media').'</option>';
echo '<option value="event">' . __('Event') . '</option>';
//echo '<option value="birth_declaration">'.__('Birth Declaration').'</option>';
//echo '<option value="baptism_witness">'.__('Baptism Witness').'</option>';
//echo '<option value="death_declaration">'.__('Death Declaration').'</option>';
//echo '<option value="burial_witness">'.__('Burial Witness').'</option>';
//echo '<option value="name">'.__('Name').'</option>';
//echo '<option value="nobility">'.__('Title of Nobility').'</option>';
//echo '<option value="title">'.__('Title').'</option>';
echo '<option value="adoption">' . __('Adoption') . '</option>';
//echo '<option value="lordship">'.__('Title of Lordship').'</option>';
echo '<option value="URL">' . __('URL/ Internet link') . '</option>';
echo '<option value="person_colour_mark">' . __('Colour mark by person') . '</option>';
echo '</select>';
echo '</td><td><input type="Submit" name="person_event_add" value="' . __('Add') . '"></td><tr>';
}
// *** Add event ***
if ($selected_events == 'family') {
//echo '<tr bgcolor="#CCFFFF" style="display:none;" class="row52" name="row52"></td><td>'.__('Add event').'</td><td style="border-right:0px;"></td><td style="border-left:0px;">';
echo '<tr bgcolor="#CCFFFF"></td><td>' . __('Add event') . '</td><td style="border-right:0px;"></td><td style="border-left:0px;">';
echo '<select size="1" name="event_kind">';
//echo '<option value="address">Address</option>';
//echo '<option value="picture">Picture</option>';
echo '<option value="event">' . __('Event') . '</option>';
//echo '<option value="marriage_witness">'.__('Marriage Witness').'</option>';
//echo '<option value="marriage_witness_rel">'.__('Marriage Witness (church)').'</option>';
echo '</select>';
echo '</td><td><input type="Submit" name="marriage_event_add" value="' . __('Add') . '"></td><tr>';
}
// *** Show events if save or arrow links are used ***
if (isset($_GET['event_person']) or isset($_GET['event_family']) or isset($_GET['event_add'])) {
// *** Script voor expand and collapse of items ***
$link_id = '';
if (isset($_GET['event_person']) and $_GET['event_person'] == '1') {
$link_id = '51';
}
if (isset($_GET['event_family']) and $_GET['event_family'] == '1') {
$link_id = '52';
}
if (isset($_GET['event_kind'])) {
if ($_GET['event_kind'] == 'name') {
$link_id = '1';
}
if ($_GET['event_kind'] == 'nobility') {
$link_id = '1';
}
if ($_GET['event_kind'] == 'title') {
$link_id = '1';
}
if ($_GET['event_kind'] == 'lordship') {
$link_id = '1';
}
if ($_GET['event_kind'] == 'birth_declaration') {
$link_id = '2';
}
if ($_GET['event_kind'] == 'baptism_witness') {
$link_id = '3';
}
if ($_GET['event_kind'] == 'death_declaration') {
$link_id = '4';
}
if ($_GET['event_kind'] == 'burial_witness') {
$link_id = '5';
}
if ($_GET['event_kind'] == 'profession') {
$link_id = '50';
}
if ($_GET['event_kind'] == 'picture') {
$link_id = '53';
}
if ($_GET['event_kind'] == 'marriage_witness') {
$link_id = '8';
}
if ($_GET['event_kind'] == 'marriage_witness_rel') {
$link_id = '10';
}
}
if (isset($_GET['event_add'])) {
if ($_GET['event_add'] == 'add_name') {
$link_id = '1';
}
if ($_GET['event_add'] == 'add_nobility') {
$link_id = '1';
}
if ($_GET['event_add'] == 'add_title') {
$link_id = '1';
}
if ($_GET['event_add'] == 'add_lordship') {
$link_id = '1';
}
if ($_GET['event_add'] == 'add_birth_declaration') {
$link_id = '2';
}
if ($_GET['event_add'] == 'add_baptism_witness') {
$link_id = '3';
}
if ($_GET['event_add'] == 'add_death_declaration') {
$link_id = '4';
}
if ($_GET['event_add'] == 'add_burial_witness') {
$link_id = '5';
}
if ($_GET['event_add'] == 'add_profession') {
$link_id = '50';
}
if ($_GET['event_add'] == 'add_picture') {
$link_id = '53';
}
if ($_GET['event_add'] == 'add_marriage_witness') {
$link_id = '8';
}
if ($_GET['event_add'] == 'add_marriage_witness_rel') {
$link_id = '10';
}
}
echo '
<script type="text/javascript">
function Show(el_id){
// *** Hide or show item ***
var arr = document.getElementsByClassName(\'row\'+el_id);
for (i=0; i<arr.length; i++){
arr[i].style.display="";
}
// *** Change [+] into [-] ***
document.getElementById(\'hideshowlink\'+el_id).innerHTML = "[-]";
}
</script>';
echo '<script>
Show("' . $link_id . '");
</script>';
}
}
if ($age_cal > 0 and $age_cal < $woman_min_married) {
$woman_min_married = $age_cal;
}
} else {
$age_woman_unmarried[] = $age_cal;
}
if ($age_cal >= $test_year && $age_cal < 120) {
$index = $record->pers_indexnr;
$test_year = $age_cal;
$oldest_person = $record;
}
}
if (isset($oldest_person)) {
$row = $db_functions->get_person($oldest_person->pers_gedcomnumber);
echo '<td align="center"><i>' . $test_year . ' ' . __('years') . "</i></td>\n";
echo show_person($row);
} else {
echo "<td></td><td></td>\n";
}
// *** Average age ***
echo "<tr><td>" . __('Average age') . "</td>\n";
echo '<td align="center">';
@($average = array_sum($age_man) / count($age_man));
echo round($average, 1);
echo ' ' . __('years') . '</td>';
if ($man_min == 0) {
$man_min = '0';
}
echo '<td align="center">' . $man_min . ' ' . __('years') . ' - ' . $man_max . ' ' . __('years') . '</td>';
echo '<td align="center">';
@($average = array_sum($age_woman) / count($age_woman));
$child_count = substr_count($familyDb->fam_children, ";");
echo '<ul id="sortable' . $i . '" class="sortable">';
for ($j = 0; $j <= $child_count; $j++) {
// *** Create new children variabele, for disconnect child ***
$fam_children = '';
for ($k = 0; $k <= substr_count($familyDb->fam_children, ";"); $k++) {
if ($k != $j) {
$fam_children .= $fam_children_array[$k] . ';';
}
}
$fam_children = substr($fam_children, 0, -1);
// *** strip last ; character ***
echo '<li><span style="cursor:move;" id="' . $fam_children_array[$j] . '" class="handle' . $i . '" ><img src="' . CMS_ROOTPATH_ADMIN . 'images/drag-icon.gif" border="0" title="' . __('Drag to change order (saves automatically)') . '" alt="' . __('Drag to change order') . '"></span> ';
echo '<a href="index.php?' . $joomlastring . 'page=' . $page . '&family_id=' . $familyDb->fam_id . '&child_disconnect=' . $fam_children . '&child_disconnect_gedcom=' . $fam_children_array[$j] . '">
<img src="' . CMS_ROOTPATH_ADMIN . 'images/person_disconnect.gif" border="0" title="' . __('Disconnect child') . '" alt="' . __('Disconnect child') . '"></a>';
echo ' <span id="chldnum' . $fam_children_array[$j] . '">' . ($j + 1) . '</span>. ' . show_person($fam_children_array[$j], true) . '</li>';
}
echo '</ul>';
}
//already in index.php echo '<script src="../include/jqueryui/js/jquery-1.8.0.min.js"></script>';
//to index.php - echo '<script src="../include/jqueryui/js/jquery.sortable.min.js"></script>';
?>
<script>
$('#sortable'+'<?php
echo $i;
?>
').sortable({handle: '.handle'+'<?php
echo $i;
?>
'}).bind('sortupdate', function() {
var childstring = "";