/
latest_changes.php
112 lines (89 loc) · 4.52 KB
/
latest_changes.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
<?php
include_once("header.php"); // returns CMS_ROOTPATH constant
include_once(CMS_ROOTPATH."menu.php");
include_once(CMS_ROOTPATH."include/person_cls.php");
global $selected_language;
$person_cls = New person_cls;
// *** EXAMPLE of a UNION querie ***
//$qry = "(SELECT * FROM humo1_person ".$query.') ';
//$qry.= " UNION (SELECT * FROM humo2_person ".$query.')';
//$qry.= " UNION (SELECT * FROM humo3_person ".$query.')';
//$qry.= " ORDER BY pers_lastname, pers_firstname";
$person_qry= "(SELECT *, STR_TO_DATE(pers_changed_date,'%d %b %Y') AS changed_date, pers_changed_time as changed_time
FROM humo_persons WHERE pers_tree_id='".$tree_id."' AND pers_changed_date IS NOT NULL)";
$person_qry.= " UNION (SELECT *, STR_TO_DATE(pers_new_date,'%d %b %Y') AS changed_date, pers_new_time as changed_time
FROM humo_persons WHERE pers_tree_id='".$tree_id."' AND pers_changed_date IS NULL)";
$person_qry.= " ORDER BY changed_date DESC, changed_time DESC LIMIT 0,100";
$search_name='';
if (isset($_POST["search_name"])){
$search_name=$_POST["search_name"];
// *** EXAMPLE of a UNION querie ***
//$qry = "(SELECT * FROM humo1_person ".$query.') ';
//$qry.= " UNION (SELECT * FROM humo2_person ".$query.')';
//$qry.= " UNION (SELECT * FROM humo3_person ".$query.')';
//$qry.= " ORDER BY pers_lastname, pers_firstname";
$person_qry = "(SELECT * , STR_TO_DATE(pers_changed_date,'%d %b %Y') AS changed_date, pers_changed_time as changed_time
FROM humo_persons WHERE pers_tree_id='".$tree_id."'
LEFT JOIN humo_events
ON pers_gedcomnumber=event_person_id AND event_kind='name' AND event_tree_id='".$tree_id."'
WHERE (CONCAT(pers_firstname,REPLACE(pers_prefix,'_',' '),pers_lastname) LIKE '%$search_name%'
OR event_event LIKE '%$search_name%')
AND pers_changed_date IS NOT NULL
)";
$person_qry .= " UNION (SELECT * , STR_TO_DATE(pers_new_date,'%d %b %Y') AS changed_date, pers_new_time as changed_time
FROM humo_persons WHERE pers_tree_id='".$tree_id."'
LEFT JOIN humo_events
ON pers_gedcomnumber=event_person_id AND event_kind='name' AND event_tree_id='".$tree_id."'
WHERE (CONCAT(pers_firstname,REPLACE(pers_prefix,'_',' '),pers_lastname) LIKE '%$search_name%'
OR event_event LIKE '%$search_name%')
AND pers_changed_date IS NULL)";
$person_qry .= " ORDER BY changed_date DESC, changed_time DESC LIMIT 0,100";
}
$person_result = $dbh->query($person_qry);
echo '<h2 class="center">'.__('Recently changed and/or new persons').'</h2>';
// *** Search box ***
echo '<div style="text-align: center; margin-bottom: 16px">';
echo '<form action="'.CMS_ROOTPATH.'latest_changes.php" method="post">';
echo '<input type="text" name="search_name" id="part_of_name" value="'.$search_name.'">';
echo ' <input type="submit" value="'.__('Search').'">';
echo '</form>';
echo '</div>';
//echo '<div style="height: 400px; width: 90%; margin-left: 5%; overflow-y: scroll;">';
if($rtlmarker=="ltr") echo '<div style="height:400px; width:60%; margin-left: 20%; overflow-y: scroll;">';
else echo '<div style="height:400px; width:60%; margin-right: 20%; overflow-y: scroll;">';
echo '<table class="humo" width="99%">';
echo '<tr class=table_headline>';
echo '<th style="font-size: 90%; text-align: left">'.__('Changed/ Added').'</th>';
echo '<th style="font-size: 90%; text-align: left">'.__('When changed').'</th>';
echo '<th style="font-size: 90%; text-align: left">'.__('When added').'</th>';
echo '</tr>';
$rowcounter=0;
while (@$person=$person_result->fetch(PDO::FETCH_OBJ)){
$rowcounter++;
echo '<tr>';
echo '<td style="font-size: 90%">';
$person_cls->construct($person);
echo $person_cls->person_popup_menu($person);
if ($person->pers_sexe=="M"){
echo '<img src="'.CMS_ROOTPATH.'images/man.gif" alt="man">';
}
elseif ($person->pers_sexe=="F"){
echo '<img src="'.CMS_ROOTPATH.'images/woman.gif" alt="woman">';
}
else{
echo '<img src="'.CMS_ROOTPATH.'images/unknown.gif" alt="unknown">';
}
echo '<a href="'.CMS_ROOTPATH.'family.php?database='.$_SESSION['tree_prefix'].'&id='.$person->pers_indexnr.'&main_person='.$person->pers_gedcomnumber.'">';
$name=$person_cls->person_name($person);
echo $name["standard_name"];
echo '</a>';
echo '</td><td style="font-size: 90%">';
echo '<span style="white-space: nowrap">'.strtolower($person->pers_changed_date).' - '.$person->pers_changed_time.'</span>';
echo '</td><td style="font-size: 90%">';
echo '<span style="white-space: nowrap">'.strtolower($person->pers_new_date).' - '.$person->pers_new_time.'</span></td>';
echo '</tr>';
}
echo '</table>';
echo '</div>';
include_once(CMS_ROOTPATH."footer.php");
?>