getSidebarAjaxContent();
break;
default:
header('HTTP/1.0 404 Not Found');
break;
}
exit;
}
// Implement WT_Module_Sidebar
public function defaultSidebarOrder() {
return 50;
}
// Implement WT_Module_Sidebar
public function hasSidebarContent() {
return true;
}
// Implement WT_Module_Sidebar
public function getSidebarAjaxContent() {
$alpha =safe_GET('alpha'); // All surnames beginning with this letter where "@"=unknown and ","=none
$surname =safe_GET('surname', '[^<>&%{};]*'); // All indis with this surname. NB - allow ' and "
$search =safe_GET('search');
$last = array('alpha'=>$alpha, 'surname'=>$surname, 'search'=>$search);
$_SESSION['sb_families_last'] = $last;
if ($search) {
return $this->search($search);
} elseif ($alpha=='@' || $alpha==',' || $surname) {
return $this->getSurnameFams($alpha, $surname);
} elseif ($alpha) {
return $this->getAlphaSurnames($alpha, $surname);
} else {
return '';
}
}
// Implement WT_Module_Sidebar
public function getSidebarContent() {
global $SHOW_MARRIED_NAMES, $WT_IMAGES, $UNKNOWN_NN;
// Fetch a list of the initial letters of all surnames in the database
$initials=WT_Query_Name::surnameAlpha($SHOW_MARRIED_NAMES, false, WT_GED_ID);
$out = '
';
return $out;
}
public function getAlphaSurnames($alpha, $surname1='') {
global $SHOW_MARRIED_NAMES;
$surns=WT_Query_Name::surnames('', $alpha, $SHOW_MARRIED_NAMES, true, WT_GED_ID);
$out = '';
return $out;
}
public function getSurnameFams($alpha, $surname) {
global $SHOW_MARRIED_NAMES;
$families=WT_Query_Name::families($surname, $alpha, '', $SHOW_MARRIED_NAMES, WT_GED_ID);
$out = '';
return $out;
}
public function search($query) {
if (strlen($query)<2) {
return '';
}
//-- search for INDI names
$rows=WT_DB::prepare(
"SELECT ? AS type, i_id AS xref, i_file AS ged_id, i_gedcom AS gedrec".
" FROM `##individuals`, `##name`".
" WHERE (i_id LIKE ? OR n_sort LIKE ?)".
" AND i_id=n_id AND i_file=n_file AND i_file=?".
" ORDER BY n_sort LIMIT ".WT_AUTOCOMPLETE_LIMIT
)
->execute(array('INDI', "%{$query}%", "%{$query}%", WT_GED_ID))
->fetchAll(PDO::FETCH_ASSOC);
$ids = array();
foreach ($rows as $row) {
$ids[] = $row['xref'];
}
$vars=array('FAM');
if (empty($ids)) {
//-- no match : search for FAM id
$where = "f_id LIKE ?";
$vars[]="%{$query}%";
} else {
//-- search for spouses
$qs=implode(',', array_fill(0, count($ids), '?'));
$where = "(f_husb IN ($qs) OR f_wife IN ($qs))";
$vars=array_merge($vars, $ids, $ids);
}
$vars[]=WT_GED_ID;
$rows=WT_DB::prepare("SELECT ? AS type, f_id AS xref, f_file AS ged_id, f_gedcom AS gedrec FROM `##families` WHERE {$where} AND f_file=? LIMIT ".WT_AUTOCOMPLETE_LIMIT)
->execute($vars)
->fetchAll(PDO::FETCH_ASSOC);
$out = '';
return $out;
}
}