private function pageBody(PageController $controller)
{
?>
<!-- ADMIN PAGE CONTENT -->
<ol class="breadcrumb small">
<li><a href="admin.php"><?php
echo I18N::translate('Control panel');
?>
</a></li>
<li><a href="admin_modules.php"><?php
echo I18N::translate('Module administration');
?>
</a></li>
<li class="active"><?php
echo $controller->getPageTitle();
?>
</li>
</ol>
<h2><?php
echo $controller->getPageTitle();
?>
</h2>
<form class="form-inline" method="post">
<?php
echo Filter::getCsrf();
?>
<input type="hidden" name="save" value="1">
<!-- SHOW PDF -->
<div class="form-group">
<label class="control-label">
<?php
echo I18N::translate('Access level');
?>
</label>
<?php
echo FunctionsEdit::editFieldAccessLevel('NEW_FTV_PDF_ACCESS_LEVEL', $this->getSetting('FTV_PDF_ACCESS_LEVEL'), 'class="form-control"');
?>
</div>
<!-- BUTTONS -->
<button class="btn btn-primary" type="submit">
<i class="fa fa-check"></i>
<?php
echo I18N::translate('save');
?>
</button>
</form>
<?php
}
/**
* SosaStats@index
*/
public function index()
{
global $WT_TREE;
$controller = new PageController();
$controller->setPageTitle(I18N::translate('Sosa Statistics'))->addInlineJavascript('$(".help_tooltip").tooltip();');
$view_bag = new ViewBag();
$view_bag->set('title', $controller->getPageTitle());
$view_bag->set('is_setup', false);
if ($this->sosa_provider->isSetup()) {
$view_bag->set('is_setup', true);
$view_bag->set('root_indi', $this->sosa_provider->getRootIndi());
$sosaCount = $this->sosa_provider->getSosaCount();
$diffSosaCount = $this->sosa_provider->getDifferentSosaCount();
$general_stats = array('sosa_count' => $sosaCount, 'distinct_count' => $diffSosaCount, 'sosa_rate' => Functions::safeDivision($diffSosaCount, $this->sosa_provider->getTotalIndividuals()), 'pedi_collapse' => 1 - Functions::safeDivision($diffSosaCount, $sosaCount), 'mean_gen_time' => $this->sosa_provider->getMeanGenerationTime());
$view_bag->set('general_stats', $general_stats);
$stats_gen = $this->sosa_provider->getStatisticsByGeneration();
$view_bag->set('missinganc_url', 'module.php?mod=' . $this->module->getName() . '&mod_action=SosaList@missing&ged=' . $WT_TREE->getNameUrl() . '&gen=');
$view_bag->set('sosaanc_url', 'module.php?mod=' . $this->module->getName() . '&mod_action=SosaList&ged=' . $WT_TREE->getNameUrl() . '&gen=');
$gen_theoretical = 1;
$total_theoretical = 0;
$prev_diff = 0;
$prev_known = 0.5;
$gen_equiv = 0;
$generation_stats = array();
foreach ($stats_gen as $gen => $tab) {
$genY1 = I18N::translate('-');
$genY2 = I18N::translate('-');
if ($tab['firstBirth'] > 0) {
$genY1 = $tab['firstBirth'];
}
if ($tab['lastBirth'] > 0) {
$genY2 = $tab['lastBirth'];
}
$total_theoretical += $gen_theoretical;
$perc_sosa_count_theor = Functions::safeDivision($tab['sosaCount'], $gen_theoretical);
$gen_equiv += $perc_sosa_count_theor;
$missing = 2 * $prev_known - $tab['sosaCount'];
$gen_diff = $tab['diffSosaTotalCount'] - $prev_diff;
$generation_stats[$gen] = array('gen_min_birth' => $genY1, 'gen_max_birth' => $genY2, 'theoretical' => $gen_theoretical, 'known' => $tab['sosaCount'], 'perc_known' => $perc_sosa_count_theor, 'missing' => $missing, 'perc_missing' => 1 - Functions::safeDivision($tab['sosaCount'], 2 * $prev_known), 'total_known' => $tab['sosaTotalCount'], 'perc_total_known' => Functions::safeDivision($tab['sosaTotalCount'], $total_theoretical), 'different' => $gen_diff, 'perc_different' => Functions::safeDivision($gen_diff, $tab['sosaCount']), 'total_different' => $tab['diffSosaTotalCount'], 'pedi_collapse' => 1 - Functions::safeDivision($tab['diffSosaTotalCount'], $tab['sosaTotalCount']));
$gen_theoretical = $gen_theoretical * 2;
$prev_known = $tab['sosaCount'];
$prev_diff = $tab['diffSosaTotalCount'];
}
$view_bag->set('generation_stats', $generation_stats);
$view_bag->set('equivalent_gen', $gen_equiv);
$view_bag->set('chart_img_g2', $this->htmlAncestorDispersionG2());
$view_bag->set('chart_img_g3', $this->htmlAncestorDispersionG3());
}
ViewFactory::make('SosaStats', $this, $controller, $view_bag)->render();
}
/**
* AdminConfig@index
*/
public function index()
{
global $WT_TREE;
$action = Filter::post('action');
if ($action == 'update' && Filter::checkCsrf()) {
$this->update();
}
Theme::theme(new AdministrationTheme())->init($WT_TREE);
$ctrl = new PageController();
$ctrl->restrictAccess(Auth::isAdmin())->setPageTitle($this->module->getTitle());
$view_bag = new ViewBag();
$view_bag->set('title', $ctrl->getPageTitle());
$view_bag->set('module', $this->module);
ViewFactory::make('AdminConfig', $this, $ctrl, $view_bag)->render();
}
/**
* Translation@status
*/
public function status()
{
global $WT_TREE;
$table_id = \Rhumsaa\Uuid\Uuid::uuid4();
Theme::theme(new AdministrationTheme())->init($WT_TREE);
$ctrl = new PageController();
$ctrl->restrictAccess(Auth::isAdmin())->setPageTitle(I18N::translate('Translations status'))->addExternalJavascript(WT_JQUERY_DATATABLES_JS_URL)->addExternalJavascript(WT_DATATABLES_BOOTSTRAP_JS_URL)->addInlineJavascript('
//Datatable initialisation
jQuery.fn.dataTableExt.oSort["unicode-asc" ]=function(a,b) {return a.replace(/<[^<]*>/, "").localeCompare(b.replace(/<[^<]*>/, ""))};
jQuery.fn.dataTableExt.oSort["unicode-desc" ]=function(a,b) {return b.replace(/<[^<]*>/, "").localeCompare(a.replace(/<[^<]*>/, ""))};
jQuery.fn.dataTableExt.oSort["num-html-asc" ]=function(a,b) {a=parseFloat(a.replace(/<[^<]*>/, "")); b=parseFloat(b.replace(/<[^<]*>/, "")); return (a<b) ? -1 : (a>b ? 1 : 0);};
jQuery.fn.dataTableExt.oSort["num-html-desc"]=function(a,b) {a=parseFloat(a.replace(/<[^<]*>/, "")); b=parseFloat(b.replace(/<[^<]*>/, "")); return (a>b) ? -1 : (a<b ? 1 : 0);};
jQuery("#table_missing_' . $table_id . '").DataTable({
' . I18N::datatablesI18N() . ',
sorting: [[0, "asc"]],
pageLength: 15,
columns: [
/* 0 Message */ null,
/* 1 Reference */ null
],
});
jQuery("#table_nonused_' . $table_id . '").DataTable({
' . I18N::datatablesI18N() . ',
sorting: [[0, "asc"]],
pageLength: 15,
columns: [
/* 0 Message */ null,
/* 1 Reference */ null
],
});
');
$source_code_paths = array(WT_ROOT . 'vendor/jon48/webtrees-lib/src', WT_ROOT . 'vendor/jon48/webtrees-tools/src/app');
$analyzer = new TranslationsAnalyzer($source_code_paths);
$analyzer->load();
$locale = $analyzer->getLocale();
$view_bag = new ViewBag();
$view_bag->set('table_id', $table_id);
$view_bag->set('module', $this->module);
$view_bag->set('source_code_paths', $source_code_paths);
$view_bag->set('title', $ctrl->getPageTitle() . ' - ' . I18N::languageName($locale->languageTag()));
$view_bag->set('missing_translations', $analyzer->getMissingTranslations());
$view_bag->set('non_used_translations', $analyzer->getMajNonUsedTranslations());
$view_bag->set('loading_stats', $analyzer->getLoadingStatistics());
ViewFactory::make('TranslationStatus', $this, $ctrl, $view_bag)->render();
}
private function pageBody(PageController $controller)
{
?>
<!-- FANCY TREEVIEW PAGE -->
<div id="fancy_treeview-page">
<div id="page-header">
<h2><?php
echo $controller->getPageTitle();
?>
</h2>
<?php
if ($this->options('show_pdf_icon') >= Auth::accessLevel($this->tree)) {
?>
<div id="dialog-confirm" title="<?php
echo I18N::translate('Generate PDF');
?>
" style="display:none">
<p><?php
echo I18N::translate('The pdf contains only visible generation blocks.');
?>
</p>
</div>
<a id="pdf" href="#"><i class="icon-mime-application-pdf"></i></a>
<?php
}
?>
</div>
<div id="page-body">
<?php
if ($this->options('show_userform') >= Auth::accessLevel($this->tree)) {
?>
<form id="change_root">
<label class="label"><?php
echo I18N::translate('Change root person');
?>
</label>
<input
data-autocomplete-type="INDI"
id="new_rootid"
name="new_rootid"
placeholder="<?php
echo I18N::translate('Search ID by name');
?>
"
type="text"
>
<input
id="btn_go"
class="btn btn-primary btn-sm"
name="btn_go"
type="submit"
value="<?php
echo I18N::translate('Go');
?>
"
>
</form>
<div id="error"></div>
<?php
}
?>
<ol id="fancy_treeview"><?php
echo $this->printPage();
?>
</ol>
<div id="btn_next">
<input
class="btn btn-primary"
type="button"
name="next"
value="<?php
echo I18N::translate('next');
?>
"
>
</div>
</div>
</div>
<?php
}
/**
* Display a form to edit configuration settings.
*/
private function editConfig()
{
$controller = new PageController();
$controller->restrictAccess(Auth::isAdmin())->setPageTitle(I18N::translate('Chart preferences') . ' — ' . $this->getTitle())->pageHeader();
?>
<ol class="breadcrumb small">
<li><a href="admin.php"><?php
echo I18N::translate('Control panel');
?>
</a></li>
<li><a href="admin_modules.php"><?php
echo I18N::translate('Module administration');
?>
</a></li>
<li class="active"><?php
echo $controller->getPageTitle();
?>
</li>
</ol>
<h1><?php
echo $controller->getPageTitle();
?>
</h1>
<p>
<?php
echo I18N::translate('Searching for all possible relationships can take a lot of time in complex trees.');
?>
</p>
<form method="post">
<?php
foreach (Tree::getAll() as $tree) {
?>
<h2><?php
echo $tree->getTitleHtml();
?>
</h2>
<div class="form-group">
<label class="control-label col-sm-3" for="relationship-ancestors-<?php
echo $tree->getTreeId();
?>
">
<?php
echo I18N::translate('Relationships');
?>
</label>
<div class="col-sm-9">
<?php
echo FunctionsEdit::selectEditControl('relationship-ancestors-' . $tree->getTreeId(), $this->ancestorsOptions(), null, $tree->getPreference('RELATIONSHIP_ANCESTORS', self::DEFAULT_ANCESTORS), 'class="form-control"');
?>
</div>
</div>
<fieldset class="form-group">
<legend class="control-label col-sm-3">
<?php
echo I18N::translate('How much recursion to use when searching for relationships');
?>
</legend>
<div class="col-sm-9">
<?php
echo FunctionsEdit::radioButtons('relationship-recursion-' . $tree->getTreeId(), $this->recursionOptions(), $tree->getPreference('RELATIONSHIP_RECURSION', self::DEFAULT_RECURSION), 'class="radio-inline"');
?>
</div>
</fieldset>
<?php
}
?>
<div class="form-group">
<div class="col-sm-offset-3 col-sm-9">
<button type="submit" class="btn btn-primary">
<i class="fa fa-check"></i>
<?php
echo I18N::translate('save');
?>
</button>
</div>
</div>
</form>
<?php
}
private function config()
{
global $WT_TREE;
$controller = new webtrees\Controller\PageController();
$controller->restrictAccess(webtrees\Auth::isManager($WT_TREE))->setPageTitle($this->getTitle())->pageHeader();
$args = array();
$args['module_name'] = $this->getName();
$args['tree_id'] = $WT_TREE->getTreeId();
$items = webtrees\Database::prepare("SELECT block_id, block_order, gedcom_id, bs1.setting_value AS menu_title, bs2.setting_value AS menu_address" . " FROM `##block` b" . " JOIN `##block_setting` bs1 USING (block_id)" . " JOIN `##block_setting` bs2 USING (block_id)" . " WHERE module_name = :module_name" . " AND bs1.setting_name = 'menu_title'" . " AND bs2.setting_name = 'menu_address'" . " AND IFNULL(gedcom_id, :tree_id) = :tree_id" . " ORDER BY block_order")->execute($args)->fetchAll();
unset($args['tree_id']);
$min_block_order = webtrees\Database::prepare("SELECT MIN(block_order) FROM `##block` WHERE module_name = :module_name")->execute($args)->fetchOne();
$max_block_order = webtrees\Database::prepare("SELECT MAX(block_order) FROM `##block` WHERE module_name = :module_name")->execute($args)->fetchOne();
?>
<style>
.text-left-not-xs, .text-left-not-sm, .text-left-not-md, .text-left-not-lg {
text-align: left;
}
.text-center-not-xs, .text-center-not-sm, .text-center-not-md, .text-center-not-lg {
text-align: center;
}
.text-right-not-xs, .text-right-not-sm, .text-right-not-md, .text-right-not-lg {
text-align: right;
}
.text-justify-not-xs, .text-justify-not-sm, .text-justify-not-md, .text-justify-not-lg {
text-align: justify;
}
@media (max-width: 767px) {
.text-left-not-xs, .text-center-not-xs, .text-right-not-xs, .text-justify-not-xs {
text-align: inherit;
}
.text-left-xs {
text-align: left;
}
.text-center-xs {
text-align: center;
}
.text-right-xs {
text-align: right;
}
.text-justify-xs {
text-align: justify;
}
}
@media (min-width: 768px) and (max-width: 991px) {
.text-left-not-sm, .text-center-not-sm, .text-right-not-sm, .text-justify-not-sm {
text-align: inherit;
}
.text-left-sm {
text-align: left;
}
.text-center-sm {
text-align: center;
}
.text-right-sm {
text-align: right;
}
.text-justify-sm {
text-align: justify;
}
}
@media (min-width: 992px) and (max-width: 1199px) {
.text-left-not-md, .text-center-not-md, .text-right-not-md, .text-justify-not-md {
text-align: inherit;
}
.text-left-md {
text-align: left;
}
.text-center-md {
text-align: center;
}
.text-right-md {
text-align: right;
}
.text-justify-md {
text-align: justify;
}
}
@media (min-width: 1200px) {
.text-left-not-lg, .text-center-not-lg, .text-right-not-lg, .text-justify-not-lg {
text-align: inherit;
}
.text-left-lg {
text-align: left;
}
.text-center-lg {
text-align: center;
}
.text-right-lg {
text-align: right;
}
.text-justify-lg {
text-align: justify;
}
}
</style>
<ol class="breadcrumb small">
<li><a href="admin.php"><?php
echo webtrees\I18N::translate('Control panel');
?>
</a></li>
<li><a href="admin_modules.php"><?php
echo webtrees\I18N::translate('Module administration');
?>
</a></li>
<li class="active"><?php
echo $controller->getPageTitle();
?>
</li>
</ol>
<div class="row">
<div class="col-sm-4 col-xs-12">
<form class="form">
<label for="ged" class="sr-only">
<?php
echo webtrees\I18N::translate('Family tree');
?>
</label>
<input type="hidden" name="mod" value="<?php
echo $this->getName();
?>
">
<input type="hidden" name="mod_action" value="admin_config">
<div class="col-sm-9 col-xs-9" style="padding:0;">
<?php
echo webtrees\Functions\FunctionsEdit::selectEditControl('ged', webtrees\Tree::getNameList(), null, $WT_TREE->getName(), 'class="form-control"');
?>
</div>
<div class="col-sm-3" style="padding:0;">
<input type="submit" class="btn btn-primary" value="<?php
echo webtrees\I18N::translate('show');
?>
">
</div>
</form>
</div>
<span class="visible-xs hidden-sm hidden-md hidden-lg" style="display:block;"></br></br></span>
<div class="col-sm-4 text-center text-left-xs col-xs-12">
<p>
<a href="module.php?mod=<?php
echo $this->getName();
?>
&mod_action=admin_edit" class="btn btn-primary">
<i class="fa fa-plus"></i>
<?php
echo webtrees\I18N::translate('Add Menu');
?>
</a>
</p>
</div>
<div class="col-sm-4 text-right text-left-xs col-xs-12">
<?php
// TODO: Move to internal item/page
if (file_exists(WT_MODULES_DIR . $this->getName() . '/readme.html')) {
?>
<a href="<?php
echo WT_MODULES_DIR . $this->getName();
?>
/readme.html" class="btn btn-info">
<i class="fa fa-newspaper-o"></i>
<?php
echo webtrees\I18N::translate('ReadMe');
?>
</a>
<?php
}
?>
</div>
</div>
<table class="table table-bordered table-condensed">
<thead>
<tr>
<th class="col-sm-2"><?php
echo webtrees\I18N::translate('Position');
?>
</th>
<th class="col-sm-4"><?php
echo webtrees\I18N::translate('Menu title');
?>
</th>
<th class="col-sm-4"><?php
echo webtrees\I18N::translate('Menu address');
?>
</th>
<th class="col-sm-2" colspan=4><?php
echo webtrees\I18N::translate('Controls');
?>
</th>
</tr>
</thead>
<tbody>
<?php
foreach ($items as $item) {
?>
<tr>
<td>
<?php
echo $item->block_order, ', ';
if ($item->gedcom_id == null) {
echo webtrees\I18N::translate('All');
} else {
echo webtrees\Tree::findById($item->gedcom_id)->getTitleHtml();
}
?>
</td>
<td>
<?php
echo webtrees\Filter::escapeHtml(webtrees\I18N::translate($item->menu_title));
?>
</td>
<td>
<?php
echo webtrees\Filter::escapeHtml(substr(webtrees\I18N::translate($item->menu_address), 0, 1) == '<' ? webtrees\I18N::translate($item->menu_address) : nl2br(webtrees\I18N::translate($item->menu_address)));
?>
</td>
<td class="text-center">
<a href="module.php?mod=<?php
echo $this->getName();
?>
&mod_action=admin_edit&block_id=<?php
echo $item->block_id;
?>
">
<div class="icon-edit"> </div>
</a>
</td>
<td class="text-center">
<a href="module.php?mod=<?php
echo $this->getName();
?>
&mod_action=admin_moveup&block_id=<?php
echo $item->block_id;
?>
">
<?php
if ($item->block_order == $min_block_order) {
echo ' ';
} else {
echo '<div class="icon-uarrow"> </div>';
}
?>
</a>
</td>
<td class="text-center">
<a href="module.php?mod=<?php
echo $this->getName();
?>
&mod_action=admin_movedown&block_id=<?php
echo $item->block_id;
?>
">
<?php
if ($item->block_order == $max_block_order) {
echo ' ';
} else {
echo '<div class="icon-darrow"> </div>';
}
?>
</a>
</td>
<td class="text-center">
<a href="module.php?mod=<?php
echo $this->getName();
?>
&mod_action=admin_delete&block_id=<?php
echo $item->block_id;
?>
"
onclick="return confirm('<?php
echo webtrees\I18N::translate('Are you sure you want to delete this menu?');
?>
');">
<div class="icon-delete"> </div>
</a>
</td>
</tr>
<?php
}
?>
</tbody>
</table>
<?php
}
namespace Fisharebest\Webtrees;
/**
* Defined in session.php
*
* @global Tree $WT_TREE
*/
global $WT_TREE;
use Fisharebest\Webtrees\Controller\PageController;
define('WT_SCRIPT_NAME', 'admin_trees_renumber.php');
require './includes/session.php';
$controller = new PageController();
$controller->restrictAccess(Auth::isManager($WT_TREE))->setPageTitle(I18N::translate('Renumber family tree') . ' — ' . $WT_TREE->getTitleHtml())->pageHeader();
// Every XREF used by this tree and also used by some other tree
$xrefs = Database::prepare("SELECT xref, type FROM (" . " SELECT i_id AS xref, 'INDI' AS type FROM `##individuals` WHERE i_file = ?" . " UNION " . " SELECT f_id AS xref, 'FAM' AS type FROM `##families` WHERE f_file = ?" . " UNION " . " SELECT s_id AS xref, 'SOUR' AS type FROM `##sources` WHERE s_file = ?" . " UNION " . " SELECT m_id AS xref, 'OBJE' AS type FROM `##media` WHERE m_file = ?" . " UNION " . " SELECT o_id AS xref, o_type AS type FROM `##other` WHERE o_file = ? AND o_type NOT IN ('HEAD', 'TRLR')" . ") AS this_tree JOIN (" . " SELECT xref FROM `##change` WHERE gedcom_id <> ?" . " UNION " . " SELECT i_id AS xref FROM `##individuals` WHERE i_file <> ?" . " UNION " . " SELECT f_id AS xref FROM `##families` WHERE f_file <> ?" . " UNION " . " SELECT s_id AS xref FROM `##sources` WHERE s_file <> ?" . " UNION " . " SELECT m_id AS xref FROM `##media` WHERE m_file <> ?" . " UNION " . " SELECT o_id AS xref FROM `##other` WHERE o_file <> ? AND o_type NOT IN ('HEAD', 'TRLR')" . ") AS other_trees USING (xref)")->execute(array($WT_TREE->getTreeId(), $WT_TREE->getTreeId(), $WT_TREE->getTreeId(), $WT_TREE->getTreeId(), $WT_TREE->getTreeId(), $WT_TREE->getTreeId(), $WT_TREE->getTreeId(), $WT_TREE->getTreeId(), $WT_TREE->getTreeId(), $WT_TREE->getTreeId(), $WT_TREE->getTreeId()))->fetchAssoc();
echo '<h1>', $controller->getPageTitle(), '</h1>';
if (Filter::get('action') === 'renumber') {
foreach ($xrefs as $old_xref => $type) {
Database::beginTransaction();
Database::exec("LOCK TABLE `##individuals` WRITE," . " `##families` WRITE," . " `##sources` WRITE," . " `##media` WRITE," . " `##other` WRITE," . " `##name` WRITE," . " `##placelinks` WRITE," . " `##change` WRITE," . " `##next_id` WRITE," . " `##dates` WRITE," . " `##default_resn` WRITE," . " `##hit_counter` WRITE," . " `##link` WRITE," . " `##user_gedcom_setting` WRITE");
$new_xref = $WT_TREE->getNewXref($type);
switch ($type) {
case 'INDI':
Database::prepare("UPDATE `##individuals` SET i_id = ?, i_gedcom = REPLACE(i_gedcom, ?, ?) WHERE i_id = ? AND i_file = ?")->execute(array($new_xref, "0 @{$old_xref}@ INDI\n", "0 @{$new_xref}@ INDI\n", $old_xref, $WT_TREE->getTreeId()));
Database::prepare("UPDATE `##families` JOIN `##link` ON (l_file = f_file AND l_to = ? AND l_type = 'HUSB') SET f_gedcom = REPLACE(f_gedcom, ?, ?) WHERE f_file = ?")->execute(array($old_xref, " HUSB @{$old_xref}@", " HUSB @{$new_xref}@", $WT_TREE->getTreeId()));
Database::prepare("UPDATE `##families` JOIN `##link` ON (l_file = f_file AND l_to = ? AND l_type = 'WIFE') SET f_gedcom = REPLACE(f_gedcom, ?, ?) WHERE f_file = ?")->execute(array($old_xref, " WIFE @{$old_xref}@", " WIFE @{$new_xref}@", $WT_TREE->getTreeId()));
Database::prepare("UPDATE `##families` JOIN `##link` ON (l_file = f_file AND l_to = ? AND l_type = 'CHIL') SET f_gedcom = REPLACE(f_gedcom, ?, ?) WHERE f_file = ?")->execute(array($old_xref, " CHIL @{$old_xref}@", " CHIL @{$new_xref}@", $WT_TREE->getTreeId()));
Database::prepare("UPDATE `##families` JOIN `##link` ON (l_file = f_file AND l_to = ? AND l_type = 'ASSO') SET f_gedcom = REPLACE(f_gedcom, ?, ?) WHERE f_file = ?")->execute(array($old_xref, " ASSO @{$old_xref}@", " ASSO @{$new_xref}@", $WT_TREE->getTreeId()));
Database::prepare("UPDATE `##families` JOIN `##link` ON (l_file = f_file AND l_to = ? AND l_type = '_ASSO') SET f_gedcom = REPLACE(f_gedcom, ?, ?) WHERE f_file = ?")->execute(array($old_xref, " _ASSO @{$old_xref}@", " _ASSO @{$new_xref}@", $WT_TREE->getTreeId()));
Database::prepare("UPDATE `##individuals` JOIN `##link` ON (l_file = i_file AND l_to = ? AND l_type = 'ASSO') SET i_gedcom = REPLACE(i_gedcom, ?, ?) WHERE i_file = ?")->execute(array($old_xref, " ASSO @{$old_xref}@", " ASSO @{$new_xref}@", $WT_TREE->getTreeId()));
Database::prepare("UPDATE `##individuals` JOIN `##link` ON (l_file = i_file AND l_to = ? AND l_type = '_ASSO') SET i_gedcom = REPLACE(i_gedcom, ?, ?) WHERE i_file = ?")->execute(array($old_xref, " _ASSO @{$old_xref}@", " _ASSO @{$new_xref}@", $WT_TREE->getTreeId()));
/**
* Create the contents of the <head> tag.
*
* @param PageController $controller The current controller
*
* @return string
*/
protected function headContents(PageController $controller)
{
// The title often includes the names of records, which may include HTML markup.
$title = Filter::unescapeHtml($controller->getPageTitle());
// If an extra (site) title is specified, append it.
if ($this->tree && $this->tree->getPreference('META_TITLE')) {
$title .= ' – ' . $this->tree->getPreference('META_TITLE');
}
$html = '<!--[if IE 8]><script src="' . WT_MODERNIZR_JS_URL . '"></script><![endif]-->' . '<!--[if IE 8]><script src="' . WT_RESPOND_JS_URL . '"></script><![endif]-->' . $this->metaCharset() . $this->title($title) . $this->favicon() . $this->metaViewport() . $this->metaRobots($controller->getMetaRobots()) . $this->metaUaCompatible() . $this->metaGenerator(WT_WEBTREES . ' ' . WT_VERSION . ' - ' . WT_WEBTREES_URL);
if ($this->tree) {
$html .= $this->metaDescription($this->tree->getPreference('META_DESCRIPTION'));
}
// CSS files
foreach ($this->stylesheets() as $css) {
$html .= '<link rel="stylesheet" type="text/css" href="' . $css . '">';
}
return $html;
}
private function pageBody(PageController $controller)
{
$FTV_SETTINGS = unserialize($this->getSetting('FTV_SETTINGS'));
?>
<!-- ADMIN PAGE CONTENT -->
<ol class="breadcrumb small">
<li><a href="admin.php"><?php
echo I18N::translate('Control panel');
?>
</a></li>
<li><a href="admin_modules.php"><?php
echo I18N::translate('Module administration');
?>
</a></li>
<li class="active"><?php
echo $controller->getPageTitle();
?>
</li>
</ol>
<h2><?php
echo $controller->getPageTitle();
?>
</h2>
<!-- *** FORM 1 *** -->
<form class="form-horizontal" method="post" name="form1">
<?php
echo Filter::getCsrf();
?>
<!-- SELECT TREE -->
<div class="form-group">
<label class="control-label col-sm-2" for="tree">
<?php
echo I18N::translate('Family tree');
?>
</label>
<div class="col-sm-4">
<select id="tree" name="NEW_FIB_TREE" class="form-control">
<?php
foreach (Tree::getAll() as $tree) {
?>
<?php
if ($tree->getTreeId() == $this->tree_id) {
?>
<option value="<?php
echo $tree->getTreeId();
?>
" data-ged="<?php
echo $tree->getNameHtml();
?>
" selected="selected">
<?php
echo $tree->getTitleHtml();
?>
</option>
<?php
} else {
?>
<option value="<?php
echo $tree->getTreeId();
?>
" data-ged="<?php
echo $tree->getNameHtml();
?>
">
<?php
echo $tree->getTitleHtml();
?>
</option>
<?php
}
?>
<?php
}
?>
</select>
</div>
</div>
</form>
<!-- PANEL GROUP ACCORDION -->
<div class="panel-group" id="accordion">
<!-- PANEL 1 -->
<div class="panel panel-default" id="panel1">
<div class="panel-heading">
<h4 class="panel-title">
<a data-toggle="collapse" data-target="#collapseOne" href="#">
<?php
echo I18N::translate('Pages');
?>
</a>
</h4>
</div>
<div id="collapseOne" class="panel-collapse collapse in">
<div class="panel-body">
<?php
if (empty($FTV_SETTINGS) || !empty($FTV_SETTINGS) && !$this->searchArray($FTV_SETTINGS, 'TREE', $this->tree_id)) {
?>
<div class="alert alert-info alert-dismissible" role="alert">
<button type="button" class="close" data-dismiss="alert" aria-label="' . I18N::translate('close') . '">
<span aria-hidden="true">×</span>
</button>
<p class="small text-muted">
<?php
echo I18N::translate('Use the search form below to search for a root person. After a successful search the Fancy Treeview page will be automatically created. You can add as many root persons as you want.');
?>
</p>
</div>
<?php
}
?>
<!-- *** FORM 2 *** -->
<div id="ftv-search-form" class="form-group alert alert-info">
<form class="form-inline" method="post" name="form2">
<!-- SURNAME SEARCH FIELD -->
<div class="form-group">
<label class="control-label">
<?php
echo I18N::translate('Search root person');
?>
</label>
<input
class="form-control"
data-autocomplete-type="SURN"
id="surname-search"
name="SURNAME"
placeholder="<?php
echo I18N::translate('Surname');
?>
"
type="text"
>
<label class="checkbox-inline">
<?php
echo FunctionsEdit::checkbox('soundex_std') . I18N::translate('Russell');
?>
</label>
<label class="checkbox-inline">
<?php
echo FunctionsEdit::checkbox('soudex_dm') . I18N::translate('Daitch-Mokotoff');
?>
</label>
<button name="search" class="btn btn-primary" type="submit">
<i class="fa fa-search"></i>
<?php
echo I18N::translate('search');
?>
</button>
</div>
<!-- PID SEARCH FIELD -->
<?php
$class = I18N::direction() === 'rtl' ? 'pull-left' : 'pull-right';
?>
<div class="form-group <?php
echo $class;
?>
">
<label class="control-label" for="pid-search">
<?php
echo I18N::translate('Or enter an ID');
?>
</label>
<input
class="form-control"
data-autocomplete-type="INDI"
id="pid-search"
name="PID"
placeholder="<?php
echo I18N::translate('Search ID by name');
?>
"
type="text"
value=""
>
<button name="Ok" class="btn btn-primary" type="submit">
<i class="fa fa-check"></i>
<?php
echo I18N::translate('ok');
?>
</button>
</div>
</form>
<!-- *** FORM 3 *** -->
<form class="form-horizontal" method="post" name="form3">
<!-- TABLE -->
<table id="search-result-table" class="table" style="display: none">
<thead>
<tr>
<th><?php
echo I18N::translate('Root person');
?>
</th>
<?php
if (!$this->options('use_fullname')) {
?>
<th><?php
echo I18N::translate('Surname in page title');
?>
</th>
<?php
}
?>
<th><?php
echo I18N::translate('Page title');
?>
</th>
<th><?php
echo I18N::translate('Access level');
?>
</th>
<th><?php
echo I18N::translate('Add');
?>
</th>
</tr>
</thead>
<tbody>
<tr>
<!-- ROOT PERSONS FULL NAME -->
<td id="root">
<?php
if ($this->options('use_fullname')) {
?>
<input
name="surname"
type="hidden"
value=""
>
<?php
}
?>
<input
name="pid"
type="hidden"
value=""
>
<input
name="sort"
type="hidden"
value=""
>
<span></span>
</td>
<?php
if (!$this->options('use_fullname')) {
?>
<!-- SURNAME IN PAGE TITLE -->
<td id="surn">
<label class="showname"></label>
<input
class="form-control editname"
name="surname"
type="text"
value=""
>
</td>
<?php
}
?>
<!-- PAGE TITLE -->
<td id="title"></td>
<!-- ACCESS LEVEL -->
<td>
<?php
echo FunctionsEdit::editFieldAccessLevel('access_level', 2, 'class="form-control"');
?>
</td>
<!-- ADD BUTTON -->
<td>
<button type="submit" name="add" class="btn btn-success btn-sm" title="<?php
I18N::translate('Add');
?>
">
<i class="fa fa-plus"></i>
</button>
</td>
</tr>
</tbody>
</table>
</form>
</div>
<?php
echo $this->addMessage("error", "danger", true);
?>
<?php
echo $this->addMessage('update-settings', 'success', true, I18N::translate('The settings for this tree are succesfully updated'));
?>
<div id="fancy-treeview-form" class="form-group">
<?php
if (!empty($FTV_SETTINGS) && $this->searchArray($FTV_SETTINGS, 'TREE', $this->tree_id)) {
?>
<form class="form-horizontal" method="post" name="form4">
<!-- TABLE -->
<table id="fancy-treeview-table" class="table table-hover">
<thead>
<tr>
<th><?php
echo I18N::translate('Root person');
?>
</th>
<?php
if (!$this->options('use_fullname')) {
?>
<th><?php
echo I18N::translate('Surname in page title');
?>
</th>
<?php
}
?>
<th><?php
echo I18N::translate('Page title');
?>
</th>
<th><?php
echo I18N::translate('Access level');
?>
</th>
<th><?php
echo I18N::translate('Delete');
?>
</th>
</tr>
</thead>
<tbody>
<?php
foreach ($FTV_SETTINGS as $key => $this_ITEM) {
?>
<?php
if ($this_ITEM['TREE'] == $this->tree_id) {
?>
<?php
if (Individual::getInstance($this_ITEM['PID'], $this->tree)) {
?>
<tr class="sortme">
<!-- ROOT PERSONS FULL NAME -->
<td>
<input
name="pid[<?php
echo $key;
?>
]"
type="hidden"
value="<?php
echo $this_ITEM['PID'];
?>
"
>
<input
name="sort[<?php
echo $key;
?>
]"
type="hidden"
value="<?php
echo $this_ITEM['SORT'];
?>
"
>
<?php
echo Individual::getInstance($this_ITEM['PID'], $this->tree)->getFullName() . '';
?>
(<?php
echo Individual::getInstance($this_ITEM['PID'], $this->tree)->getLifeSpan();
?>
)
</td>
<?php
if (!$this->options('use_fullname')) {
?>
<!-- SURNAME IN PAGE TITLE -->
<td>
<label class="showname">
<?php
echo $this_ITEM['SURNAME'];
?>
</label>
<input
class="form-control editname"
name="surname[<?php
echo $key;
?>
]"
type="text"
value="<?php
echo $this_ITEM['SURNAME'];
?>
"
>
</td>
<?php
}
?>
<!-- PAGE TITLE -->
<td>
<a href="module.php?mod=<?php
echo $this->getName();
?>
&mod_action=page&ged=<?php
echo $this->tree->getNameHtml();
?>
&rootid=<?php
echo $this_ITEM['PID'];
?>
" target="_blank">
<?php
if ($this->options('use_fullname') == true) {
echo I18N::translate('Descendants of %s', Individual::getInstance($this_ITEM['PID'], $this->tree)->getFullName());
} else {
echo I18N::translate('Descendants of the %s family', $this_ITEM['SURNAME']);
}
?>
</a>
</td>
<!-- ACCESS LEVEL -->
<td>
<?php
echo FunctionsEdit::editFieldAccessLevel('access_level[' . $key . ']', $this_ITEM['ACCESS_LEVEL'], 'class="form-control"');
?>
</td>
<!-- DELETE BUTTON -->
<td>
<button type="button" name="delete" class="btn btn-danger btn-sm" data-key="<?php
echo $key;
?>
" title="<?php
I18N::translate('Delete');
?>
">
<i class="fa fa-trash-o"></i>
</button>
</td>
</tr>
<?php
} else {
?>
<tr>
<!-- SURNAME -->
<td class="error">
<input
name="pid[<?php
echo $key;
?>
]"
type="hidden"
value="<?php
echo $this_ITEM['PID'];
?>
"
>
<?php
echo $this_ITEM['SURNAME'];
?>
</td>
<!-- ERROR MESSAGE -->
<td colspan="4" class="error">
<?php
echo I18N::translate('The person with root id %s doesn’t exist anymore in this tree', $this_ITEM['PID']);
?>
</td>
<!-- DELETE BUTTON -->
<td>
<button name="delete" type="button" class="btn btn-danger btn-sm" title="<?php
I18N::translate('Delete');
?>
">
<i class="fa fa-trash-o"></i>
</button>
</td>
</tr>
<?php
}
?>
<?php
}
?>
<?php
}
?>
</tbody>
</table>
<!-- BUTTONS -->
<button name="update" class="btn btn-primary" type="submit">
<i class="fa fa-check"></i>
<?php
echo I18N::translate('update');
?>
</button>
</form>
<?php
}
?>
</div>
</div>
</div>
</div>
<!-- PANEL 2 -->
<div class="panel panel-default" id="panel2">
<div class="panel-heading">
<h4 class="panel-title">
<a data-toggle="collapse" data-target="#collapseTwo" href="#" class="collapsed">
<?php
echo I18N::translate('Options for %s', $this->tree->getTitleHtml());
?>
</a>
</h4>
</div>
<div id="collapseTwo" class="panel-collapse collapse">
<div class="panel-body">
<?php
echo $this->addMessage('save-options', 'success', true, I18N::translate('The options for this tree are succesfully saved'));
?>
<?php
echo $this->addMessage('reset-options', 'success', true, I18N::translate('The options for this tree are succesfully reset to the default settings'));
?>
<div id="ftv-options-form" class="form-group">
<form class="form-horizontal" method="post" name="form5">
<!-- USE FULLNAME IN MENU -->
<div class="form-group fullname">
<label class="control-label col-sm-4">
<?php
echo I18N::translate('Use fullname in menu');
?>
</label>
<div class="col-sm-8">
<?php
echo FunctionsEdit::editFieldYesNo('NEW_FTV_OPTIONS[USE_FULLNAME]', $this->options('use_fullname'), 'class="radio-inline"');
?>
</div>
</div>
<!-- GENERATION BLOCKS -->
<div class="form-group">
<label class="control-label col-sm-4">
<?php
echo I18N::translate('Number of generation blocks to show');
?>
</label>
<div class="col-sm-4">
<?php
echo FunctionsEdit::selectEditControl('NEW_FTV_OPTIONS[NUMBLOCKS]', array(I18N::translate('All'), '1', '2', '3', '4', '5', '6', '7', '8', '9', '10'), null, $this->options('numblocks'), 'class="form-control"');
?>
</div>
<p class="col-sm-8 col-sm-offset-4 small text-muted">
<?php
echo I18N::translate('This option is especially usefull for large trees. When you notice a slow page load, here you can set the number of generation blocks to load at once to a lower level. Below the last generation block a button will appear to add the next set of generation blocks. The new blocks will be added to the blocks already loaded. Clicking on a “follow” link in the last visible generation block, will also load the next set of generation blocks.');
?>
</p>
</div>
<!-- SHOW SINGLES -->
<div class="form-group">
<label class="control-label col-sm-4">
<?php
echo I18N::translate('Show single persons');
?>
</label>
<div class="col-sm-8">
<?php
echo FunctionsEdit::editFieldYesNo('NEW_FTV_OPTIONS[SHOW_SINGLES]', $this->options('show_singles'), 'class="radio-inline"');
?>
</div>
<p class="col-sm-8 col-sm-offset-4 small text-muted">
<?php
echo I18N::translate('Turn this option on if you want to show single persons in the generation blocks. Single persons are persons without partner and children. With this option turned on, every child of a family will be shown in a detailed way in the next generation block.');
?>
</p>
</div>
<!-- CHECK RELATIONSHIP -->
<div class="form-group">
<label class="control-label col-sm-4">
<?php
echo I18N::translate('Check relationship between partners');
?>
</label>
<div class="col-sm-8">
<?php
echo FunctionsEdit::editFieldYesNo('NEW_FTV_OPTIONS[CHECK_RELATIONSHIP]', $this->options('check_relationship'), 'class="radio-inline"');
?>
</div>
<p class="col-sm-8 col-sm-offset-4 small text-muted">
<?php
echo I18N::translate('With this option turned on, the script checks if a (married) couple has the same ancestors. If a relationship between the partners is found, a text will appear between brackets after the spouses’ name to indicate the blood relationship.');
?>
</p>
<p class="col-sm-8 col-sm-offset-4 small text-muted">
<?php
echo I18N::translate('<strong>Note</strong>: this option can be time and/or memory consuming, especially on large trees. It can cause very slow page loading or an ’execution time out error’ on your server. If you notice such a behavior, reduce the number of generation blocks to load at once or don’t use it in combination with the option to show singles (see the previous options). If you still experience any problems, don’t use this option at all.');
?>
</p>
</div>
<!-- SHOW PLACES -->
<div id="places" class="form-group">
<label class="control-label col-sm-4">
<?php
echo I18N::translate('Show places?');
?>
</label>
<div class="col-sm-8">
<?php
echo FunctionsEdit::editFieldYesNo('NEW_FTV_OPTIONS[SHOW_PLACES]', $this->options('show_places'), 'class="radio-inline"');
?>
</div>
</div>
<!-- USE GEDCOM PLACE SETTING -->
<div id="gedcom_places" class="form-group<?php
if (!$this->options('show_places')) {
echo ' collapse';
}
?>
">
<label class="control-label col-sm-4">
<?php
echo I18N::translate('Use default GEDCOM settings to abbreviate place names?');
?>
</label>
<div class="col-sm-8">
<?php
echo FunctionsEdit::editFieldYesNo('NEW_FTV_OPTIONS[USE_GEDCOM_PLACES]', $this->options('use_gedcom_places'), 'class="radio-inline"');
?>
</div>
<p class="col-sm-8 col-sm-offset-4 small text-muted">
<?php
echo I18N::translate('If you have ticked the “Show places” option, you can choose to use the default GEDCOM settings to abbreviate placenames. If you don’t set this option, full place names will be shown.');
?>
</p>
</div>
<!-- GET COUNTRYLIST -->
<?php
if ($this->getCountrylist()) {
?>
<div id="country_list" class="form-group<?php
if (!$this->options('show_places') || $this->options('use_gedcom_places')) {
echo ' collapse';
}
?>
">
<label class="control-label col-sm-4">
<?php
echo I18N::translate('Select your country');
?>
</label>
<div class="col-sm-8">
<?php
echo FunctionsEdit::selectEditControl('NEW_FTV_OPTIONS[COUNTRY]', $this->getCountryList(), '', $this->options('country'), 'class="form-control"');
?>
</div>
<p class="col-sm-8 col-sm-offset-4 small text-muted">
<?php
echo I18N::translate('If you have ticked the “Show places” option but NOT the option to abbreviate placenames, you can set your own country here. Full places will be listed on the Fancy Treeview pages, but when a place includes the name of your own country, this name will be left out. If you don’t select a country then all countries will be shown, including your own.');
?>
</p>
</div>
<?php
}
?>
<!-- SHOW OCCUPATIONS -->
<div class="form-group">
<label class="control-label col-sm-4">
<?php
echo I18N::translate('Show occupations');
?>
</label>
<div class="col-sm-8">
<?php
echo FunctionsEdit::editFieldYesNo('NEW_FTV_OPTIONS[SHOW_OCCU]', $this->options('show_occu'), 'class="radio-inline"');
?>
</div>
</div>
<!-- RESIZE THUMBS -->
<div id="resize_thumbs" class="form-group">
<label class="control-label col-sm-4">
<?php
echo I18N::translate('Resize thumbnails');
?>
</label>
<div class="col-sm-8">
<?php
echo FunctionsEdit::editFieldYesNo('NEW_FTV_OPTIONS[RESIZE_THUMBS]', $this->options('resize_thumbs'), 'class="radio-inline"');
?>
</div>
<p class="col-sm-8 col-sm-offset-4 small text-muted">
<?php
echo I18N::translate('Here you can choose to resize the default webtrees thumbnails especially for the Fancy Treeview pages. You can set a custom size in percentage or in pixels. If you choose “no” the default webtrees thumbnails will be used with the formats you have set on the tree configuration page.');
?>
</p>
</div>
<!-- THUMB SIZE -->
<div id="thumb_size" class="form-group<?php
if (!$this->options('resize_thumbs')) {
echo ' collapse';
}
?>
">
<label class="control-label col-sm-4">
<?php
echo I18N::translate('Thumbnail size');
?>
</label>
<div class="row">
<div class="col-sm-1">
<input
class="form-control"
id="NEW_FTV_OPTIONS[THUMB_SIZE]"
name="NEW_FTV_OPTIONS[THUMB_SIZE]"
type="text"
value="<?php
echo $this->options('thumb_size');
?>
"
>
</div>
<div class="col-sm-2">
<?php
echo FunctionsEdit::selectEditControl('NEW_FTV_OPTIONS[THUMB_RESIZE_FORMAT]', array('1' => I18N::translate('percent'), '2' => I18N::translate('pixels')), null, $this->options('thumb_resize_format'), 'class="form-control"');
?>
</div>
</div>
</div>
<!-- SQUARE THUMBS -->
<div id="square_thumbs" class="form-group<?php
if (!$this->options('resize_thumbs')) {
echo ' collapse';
}
?>
">
<label class="control-label col-sm-4">
<?php
echo I18N::translate('Use square thumbnails');
?>
</label>
<div class="col-sm-8">
<?php
echo FunctionsEdit::editFieldYesNo('NEW_FTV_OPTIONS[USE_SQUARE_THUMBS]', $this->options('use_square_thumbs'), 'class="radio-inline"');
?>
</div>
</div>
<!-- SHOW USERFORM -->
<div class="form-group">
<label class="control-label col-sm-4">
<?php
echo I18N::translate('Show form to change start person');
?>
</label>
<div class="col-sm-4">
<?php
echo FunctionsEdit::editFieldAccessLevel('NEW_FTV_OPTIONS[SHOW_USERFORM]', $this->options('show_userform'), 'class="form-control"');
?>
</div>
</div>
<!-- SHOW PDF -->
<div class="form-group">
<label class="control-label col-sm-4">
<?php
echo I18N::translate('Show PDF icon?');
?>
</label>
<div class="col-sm-4">
<?php
echo FunctionsEdit::editFieldAccessLevel('NEW_FTV_OPTIONS[SHOW_PDF_ICON]', $this->options('show_pdf_icon'), 'class="form-control"');
?>
</div>
</div>
<!-- SHOW FANCY TREEVIEW ON INDI PAGE -->
<div class="form-group fullname">
<label class="control-label col-sm-4">
<?php
echo I18N::translate('Show a Fancy Treeview tab on the individual page');
?>
</label>
<div class="col-sm-8">
<?php
echo FunctionsEdit::editFieldYesNo('NEW_FTV_OPTIONS[FTV_TAB]', $this->options('ftv_tab'), 'class="radio-inline"');
?>
</div>
</div>
<!-- BUTTONS -->
<button name="save-options" class="btn btn-primary" type="submit">
<i class="fa fa-check"></i>
<?php
echo I18N::translate('save');
?>
</button>
<button name="reset-options" class="btn btn-primary" type="reset">
<i class="fa fa-recycle"></i>
<?php
echo I18N::translate('reset');
?>
</button>
</form>
</div>
</div>
</div>
</div>
</div>
<?php
}
/**
* Certificate@listAll
*/
public function listAll()
{
global $WT_TREE;
$controller = new PageController();
$controller->setPageTitle(I18N::translate('Certificates'))->restrictAccess($this->module->getSetting('MAJ_SHOW_CERT', Auth::PRIV_HIDE) >= Auth::accessLevel($WT_TREE));
$city = Filter::get('city');
if (!empty($city) && strlen($city) > 22) {
$city = Functions::decryptFromSafeBase64($city);
$controller->setPageTitle(I18N::translate('Certificates for %s', $city));
}
$data = new ViewBag();
$data->set('title', $controller->getPageTitle());
$data->set('url_module', $this->module->getName());
$data->set('url_action', 'Certificate@listAll');
$data->set('url_ged', $WT_TREE->getNameUrl());
$data->set('cities', $this->provider->getCitiesList());
$data->set('selected_city', $city);
$data->set('has_list', false);
if (!empty($city)) {
$table_id = 'table-certiflist-' . Uuid::uuid4();
$certif_list = $this->provider->getCertificatesList($city);
if (!empty($certif_list)) {
$data->set('has_list', true);
$data->set('table_id', $table_id);
$data->set('certificate_list', $certif_list);
$controller->addExternalJavascript(WT_JQUERY_DATATABLES_JS_URL)->addInlineJavascript('
/* Initialise datatables */
jQuery.fn.dataTableExt.oSort["unicode-asc" ]=function(a,b) {return a.replace(/<[^<]*>/, "").localeCompare(b.replace(/<[^<]*>/, ""))};
jQuery.fn.dataTableExt.oSort["unicode-desc" ]=function(a,b) {return b.replace(/<[^<]*>/, "").localeCompare(a.replace(/<[^<]*>/, ""))};
jQuery.fn.dataTableExt.oSort["num-html-asc" ]=function(a,b) {a=parseFloat(a.replace(/<[^<]*>/, "")); b=parseFloat(b.replace(/<[^<]*>/, "")); return (a<b) ? -1 : (a>b ? 1 : 0);};
jQuery.fn.dataTableExt.oSort["num-html-desc"]=function(a,b) {a=parseFloat(a.replace(/<[^<]*>/, "")); b=parseFloat(b.replace(/<[^<]*>/, "")); return (a>b) ? -1 : (a<b ? 1 : 0);};
jQuery("#' . $table_id . '").dataTable( {
dom: \'<"H"<"filtersH_' . $table_id . '">T<"dt-clear">pf<"dt-clear">irl>t<"F"pl<"dt-clear"><"filtersF_' . $table_id . '">>\',
' . I18N::datatablesI18N() . ',
jQueryUI: true,
autoWidth: false,
processing: true,
columns: [
/* 0-Date */ { dataSort: 1, width: "15%", class: "center" },
/* 1-DateSort */ { type: "unicode", visible : false },
/* 2-Type */ { width: "5%", searchable: false, class: "center"},
/* 3-CertificateSort */ { type: "unicode", visible : false },
/* 4-Certificate */ { dataSort: 3, class: "left" }
],
sorting: [[0,"asc"], [2,"asc"]],
displayLength: 20,
pagingType: "full_numbers"
});
jQuery(".certificate-list").css("visibility", "visible");
jQuery(".loading-image").css("display", "none");
');
}
}
ViewFactory::make('CertificatesList', $this, $controller, $data)->render();
}
/**
* AdminConfig@index
*/
public function index()
{
global $WT_TREE;
Theme::theme(new AdministrationTheme())->init($WT_TREE);
$controller = new PageController();
$controller->restrictAccess(Auth::isAdmin())->setPageTitle($this->module->getTitle());
$token = $this->module->getSetting('MAJ_AT_FORCE_EXEC_TOKEN');
if (is_null($token)) {
$token = Functions::generateRandomToken();
$this->module->setSetting('PAT_FORCE_EXEC_TOKEN', $token);
}
$data = new ViewBag();
$data->set('title', $controller->getPageTitle());
$table_id = 'table-admintasks-' . Uuid::uuid4();
$data->set('table_id', $table_id);
$data->set('trigger_url_root', WT_BASE_URL . 'module.php?mod=' . $this->module->getName() . '&mod_action=Task@trigger');
$token = $this->module->getSetting('MAJ_AT_FORCE_EXEC_TOKEN');
if (is_null($token)) {
$token = Functions::generateRandomToken();
$this->module->setSetting('MAJ_AT_FORCE_EXEC_TOKEN', $token);
}
$data->set('trigger_token', $token);
$this->provider->getInstalledTasks();
$controller->addExternalJavascript(WT_JQUERY_DATATABLES_JS_URL)->addExternalJavascript(WT_DATATABLES_BOOTSTRAP_JS_URL)->addInlineJavascript('
//Datatable initialisation
jQuery.fn.dataTableExt.oSort["unicode-asc" ]=function(a,b) {return a.replace(/<[^<]*>/, "").localeCompare(b.replace(/<[^<]*>/, ""))};
jQuery.fn.dataTableExt.oSort["unicode-desc" ]=function(a,b) {return b.replace(/<[^<]*>/, "").localeCompare(a.replace(/<[^<]*>/, ""))};
jQuery.fn.dataTableExt.oSort["num-html-asc" ]=function(a,b) {a=parseFloat(a.replace(/<[^<]*>/, "")); b=parseFloat(b.replace(/<[^<]*>/, "")); return (a<b) ? -1 : (a>b ? 1 : 0);};
jQuery.fn.dataTableExt.oSort["num-html-desc"]=function(a,b) {a=parseFloat(a.replace(/<[^<]*>/, "")); b=parseFloat(b.replace(/<[^<]*>/, "")); return (a>b) ? -1 : (a<b ? 1 : 0);};
var adminTasksTable = jQuery("#' . $table_id . '").DataTable({
' . I18N::datatablesI18N() . ',
sorting: [[3, "asc"]],
pageLength: 10,
processing: true,
serverSide : true,
ajax : {
url : "module.php?mod=' . $this->module->getName() . '&mod_action=AdminConfig@jsonTasksList&ged=' . $WT_TREE->getNameUrl() . '",
type : "POST"
},
columns: [
/* 0 Edit */ { sortable: false, className: "text-center"},
/* 1 task_name */ { visible: false },
/* 2 Enabled */ { sortable: false, className: "text-center" },
/* 3 Task Title */ null,
/* 4 Last Run */ null,
/* 5 Last status */ { className: "text-center" },
/* 6 Frequency */ { sortable: false, className: "text-center" },
/* 7 Nb Occcurrences*/ { sortable: false, className: "text-center" },
/* 8 Is Running */ { sortable: false, className: "text-center" },
/* 9 Run task */ { sortable: false, className: "text-center" }
],
});
')->addInlineJavascript('
function generate_force_token() {
jQuery("#bt_genforcetoken").attr("disabled", "disabled");
jQuery("#bt_tokentext").empty().html("<i class=\\"fa fa-spinner fa-pulse fa-fw\\"></i>");
jQuery("#token_url").load(
"module.php?mod=' . $this->module->getName() . '&mod_action=AdminConfig@generateToken",
function() {
jQuery("#bt_genforcetoken").removeAttr("disabled");
jQuery("#bt_tokentext").empty().html("' . I18N::translate('Regenerate token') . '");
adminTasksTable.ajax.reload();
}
);
}
function set_admintask_status(task, status) {
jQuery.ajax({
url: "module.php",
type: "GET",
data: {
mod: "' . $this->module->getName() . '",
mod_action: "Task@setStatus",
task: task,
status: status
},
error: function(result, stat, error) {
var err = typeof result.responseJSON === "undefined" ? error : result.responseJSON.error;
alert("' . I18N::translate('An error occured while editing this task:') . '" + err);
},
complete: function(result, stat) {
adminTasksTable.ajax.reload(null, false);
}
});
}
function run_admintask(taskname) {
jQuery("#bt_runtask_" + taskname).attr("disabled", "disabled");
jQuery("#bt_runtasktext_" + taskname).empty().html("<i class=\\"fa fa-cog fa-spin fa-fw\\"></i><span class=\\"sr-only\\">' . I18N::translate('Running') . '</span>");
jQuery("#bt_runtasktext_" + taskname).load(
"module.php?mod=' . $this->module->getName() . '&mod_action=Task@trigger&force=' . $token . '&task=" + taskname,
function() {
jQuery("#bt_runtasktext_" + taskname).empty().html("<i class=\\"fa fa-check\\"></i>' . I18N::translate('Done') . '");
adminTasksTable.ajax.reload();
}
);
}
');
ViewFactory::make('AdminConfig', $this, $controller, $data)->render();
}
/**
* Renders the edit form, whether it is an edition of an existing GeoAnalysis, or the addition of a new one.
*
* @param (GeoAnalysis!null) $ga GeoAnalysis to edit
*/
protected function renderEdit(GeoAnalysis $ga = null)
{
global $WT_TREE;
Theme::theme(new AdministrationTheme())->init($WT_TREE);
$controller = new PageController();
$controller->restrictAccess(Auth::isManager($WT_TREE))->addInlineJavascript('
function toggleMapOptions() {
if($("input:radio[name=\'use_map\']:checked").val() == 1) {
$("#map_options").show();
}
else {
$("#map_options").hide();
}
}
$("[name=\'use_map\']").on("change", toggleMapOptions);
toggleMapOptions();
');
$data = new ViewBag();
if ($ga) {
$controller->setPageTitle(I18N::translate('Edit the geographical dispersion analysis'));
$data->set('geo_analysis', $ga);
} else {
$controller->setPageTitle(I18N::translate('Add a geographical dispersion analysis'));
}
$data->set('title', $controller->getPageTitle());
$data->set('admin_config_url', 'module.php?mod=' . $this->module->getName() . '&mod_action=AdminConfig&ged=' . $WT_TREE->getNameUrl());
$data->set('module_title', $this->module->getTitle());
$data->set('save_url', 'module.php?mod=' . $this->module->getName() . '&mod_action=AdminConfig@save&ged=' . $WT_TREE->getNameUrl());
$data->set('places_hierarchy', $this->provider->getPlacesHierarchy());
$map_list = array_map(function (OutlineMap $map) {
return $map->getDescription();
}, $this->provider->getOutlineMapsList());
asort($map_list);
$data->set('map_list', $map_list);
$gen_details = array(0 => I18N::translate('All'));
for ($i = 1; $i <= 10; $i++) {
$gen_details[$i] = $i;
}
$data->set('generation_details', $gen_details);
ViewFactory::make('GeoAnalysisEdit', $this, $controller, $data)->render();
}
private function pageBody(PageController $controller)
{
$FRL_PLUGINS = unserialize($this->getSetting('FRL_PLUGINS'));
?>
<ol class="breadcrumb small">
<li><a href="admin.php"><?php
echo I18N::translate('Control panel');
?>
</a></li>
<li><a href="admin_modules.php"><?php
echo I18N::translate('Module administration');
?>
</a></li>
<li class="active"><?php
echo $controller->getPageTitle();
?>
</li>
</ol>
<h2><?php
echo $controller->getPageTitle();
?>
</h2>
<p class="small text-muted"><?php
echo I18N::translate('Check the plugins you want to use in the sidebar.');
?>
</p>
<form class="form-horizontal" method="post" name="configform" action="<?php
echo $this->getConfigLink();
?>
">
<input type="hidden" name="save" value="1">
<!-- SELECT ALL -->
<div class="form-group checkbox col-sm-12">
<label>
<?php
echo FunctionsEdit::checkbox('select-all') . I18N::translate('select all');
?>
</label>
</div>
<!-- RESEARCH LINKS -->
<?php
foreach ($this->getPluginList() as $area => $plugins) {
?>
<div class="form-group col-sm-12">
<h4><?php
echo $area;
?>
</h4>
<?php
foreach ($plugins as $label => $plugin) {
?>
<?php
if (is_array($FRL_PLUGINS) && array_key_exists($label, $FRL_PLUGINS)) {
$enabled = $FRL_PLUGINS[$label];
} else {
$enabled = '1';
}
?>
<div class="checkbox col-sm-4" dir="ltr">
<label class="checkbox-inline">
<?php
echo FunctionsEdit::twoStateCheckbox('NEW_FRL_PLUGINS[' . $label . ']', $enabled) . ' ' . $plugin->getPluginName();
?>
</label>
</div>
<?php
}
?>
</div>
<?php
}
?>
<div class="form-group col-sm-12">
<button type="submit" class="btn btn-primary">
<i class="fa fa-check"></i>
<?php
echo I18N::translate('save');
?>
</button>
<button type="reset" class="btn btn-primary" onclick="if (confirm('<?php
echo I18N::translate('The settings will be reset to default. Are you sure you want to do this?');
?>
'))
window.location.href = 'module.php?mod=<?php
echo $this->getName();
?>
&mod_action=admin_reset';">
<i class="fa fa-recycle"></i>
<?php
echo I18N::translate('reset');
?>
</button>
</div>
</form>
<?php
}
/**
* GeoAnalysis@listAll
*/
public function listAll()
{
$controller = new PageController();
$controller->setPageTitle(I18N::translate('Sosa Geographical dispersion'));
$data = new ViewBag();
$data->set('title', $controller->getPageTitle());
$data->set('has_list', false);
$ga_list = $this->provider->getGeoAnalysisList();
if (count($ga_list) > 0) {
$data->set('has_list', true);
$data->set('geoanalysislist', $ga_list);
}
ViewFactory::make('GeoAnalysisList', $this, $controller, $data)->render();
}
/**
* Lineage@index
*/
public function index()
{
global $WT_TREE;
$controller = new PageController();
$controller->setPageTitle(I18N::translate('Patronymic Lineages') . ' : ' . $this->legend);
$view_bag = new ViewBag();
$view_bag->set('title', $controller->getPageTitle());
$view_bag->set('tree', $WT_TREE);
$view_bag->set('alpha', $this->alpha);
$view_bag->set('surname', $this->surname);
$view_bag->set('legend', $this->legend);
$view_bag->set('show_all', $this->show_all);
if ($this->isShowingSurnames()) {
$view_bag->set('issurnames', true);
$view_bag->set('surnameslist', $this->getSurnamesList());
}
if ($this->isShowingLineages()) {
$view_bag->set('islineages', true);
$view_bag->set('lineages', $this->getLineages());
if ($this->show_all === 'no') {
$view_bag->set('table_title', I18N::translate('Individuals in %s lineages', $this->legend));
} else {
$view_bag->set('table_title', I18N::translate('All lineages'));
}
}
ViewFactory::make('Lineage', $this, $controller, $view_bag)->render();
}
/**
* AdminConfig@index
*/
public function index()
{
global $WT_TREE;
HookProvider::getInstance()->updateHooks();
$action = Filter::post('action');
if ($action == 'update' && Filter::checkCsrf()) {
$this->update();
}
Theme::theme(new AdministrationTheme())->init($WT_TREE);
$ctrl = new PageController();
$ctrl->restrictAccess(Auth::isAdmin())->setPageTitle($this->module->getTitle());
$table_id = 'table-installedhooks-' . Uuid::uuid4();
$view_bag = new ViewBag();
$view_bag->set('title', $ctrl->getPageTitle());
$view_bag->set('table_id', $table_id);
$view_bag->set('hook_list', HookProvider::getInstance()->getRawInstalledHooks());
$ctrl->addExternalJavascript(WT_JQUERY_DATATABLES_JS_URL)->addExternalJavascript(WT_DATATABLES_BOOTSTRAP_JS_URL)->addInlineJavascript('
jQuery(document).ready(function() {
jQuery("#' . $table_id . '").dataTable( {
' . I18N::datatablesI18N() . ',
sorting: [[ 2, "asc" ], [ 3, "asc" ]],
displayLength: 10,
pagingType: "full_numbers",
columns: [
/* 0 Enabled */ { dataSort: 1, class: "center" },
/* 1 Enabled sort */ { visible: false},
/* 2 Hook function */ null,
/* 3 Hook context */ null,
/* 4 Module name */ null,
/* 5 Priority */ { dataSort: 6, class: "center" },
/* 6 Priority sort */ { type: "num", visible: false}
]
});
});
');
ViewFactory::make('AdminConfig', $this, $ctrl, $view_bag)->render();
}
/**
* Main entry point
*
* @return string
*/
private function main()
{
global $WT_TREE;
$this->plugins = $this->getPluginList();
// List of available plugins
$this->plugin = Filter::get('plugin');
// User parameters
$this->xref = Filter::get('xref', WT_REGEX_XREF);
$this->action = Filter::get('action');
$this->data = Filter::get('data');
// Don't do any processing until a plugin is chosen.
if ($this->plugin && array_key_exists($this->plugin, $this->plugins)) {
$this->PLUGIN = new $this->plugin();
$this->PLUGIN->getOptions();
$this->getAllXrefs();
switch ($this->action) {
case 'update':
$record = self::getLatestRecord($this->xref, $this->all_xrefs[$this->xref]);
if ($this->PLUGIN->doesRecordNeedUpdate($this->xref, $record)) {
$newrecord = $this->PLUGIN->updateRecord($this->xref, $record);
if ($newrecord != $record) {
if ($newrecord) {
GedcomRecord::getInstance($this->xref, $WT_TREE)->updateRecord($newrecord, $this->PLUGIN->chan);
} else {
GedcomRecord::getInstance($this->xref, $WT_TREE)->deleteRecord();
}
}
}
$this->xref = $this->findNextXref($this->xref);
break;
case 'update_all':
foreach ($this->all_xrefs as $xref => $type) {
$record = self::getLatestRecord($xref, $type);
if ($this->PLUGIN->doesRecordNeedUpdate($xref, $record)) {
$newrecord = $this->PLUGIN->updateRecord($xref, $record);
if ($newrecord != $record) {
if ($newrecord) {
GedcomRecord::getInstance($xref, $WT_TREE)->updateRecord($newrecord, $this->PLUGIN->chan);
} else {
GedcomRecord::getInstance($xref, $WT_TREE)->deleteRecord();
}
}
}
}
$this->xref = '';
break;
}
// Make sure that our requested record really does need updating.
// It may have been updated in another session, or may not have
// been specified at all.
if (array_key_exists($this->xref, $this->all_xrefs) && $this->PLUGIN->doesRecordNeedUpdate($this->xref, self::getLatestRecord($this->xref, $this->all_xrefs[$this->xref]))) {
$this->curr_xref = $this->xref;
}
// The requested record doesn't need updating - find one that does
if (!$this->curr_xref) {
$this->curr_xref = $this->findNextXref($this->xref);
}
if (!$this->curr_xref) {
$this->curr_xref = $this->findPrevXref($this->xref);
}
// If we've found a record to update, get details and look for the next/prev
if ($this->curr_xref) {
$this->prev_xref = $this->findPrevXref($this->curr_xref);
$this->next_xref = $this->findNextXref($this->curr_xref);
}
}
// HTML common to all pages
$controller = new PageController();
$controller->setPageTitle(I18N::translate('Batch update'))->restrictAccess(Auth::isAdmin())->pageHeader();
echo $this->getJavascript();
?>
<ol class="breadcrumb small">
<li><a href="admin.php"><?php
echo I18N::translate('Control panel');
?>
</a></li>
<li><a href="admin_modules.php"><?php
echo I18N::translate('Module administration');
?>
</a></li>
<li class="active"><?php
echo $controller->getPageTitle();
?>
</li>
</ol>
<h2><?php
echo $controller->getPageTitle();
?>
</h2>
<form id="batch_update_form" class="form-horizontal" action="module.php" method="get">
<input type="hidden" name="mod" value="batch_update">
<input type="hidden" name="mod_action" value="admin_batch_update">
<input type="hidden" name="xref" value="' . $this->xref . '">
<input type="hidden" name="action" value=""><?php
// will be set by javascript for next update
?>
<input type="hidden" name="data" value=""><?php
// will be set by javascript for next update
?>
<div class="form-group">
<label class="control-label col-sm-3"><?php
echo I18N::translate('Family tree');
?>
</label>
<div class="col-sm-9">
<?php
echo FunctionsEdit::selectEditControl('ged', Tree::getNameList(), '', $WT_TREE->getName(), 'class="form-control" onchange="reset_reload();"');
?>
</div>
</div>
<div class="form-group">
<label class="control-label col-sm-3"><?php
echo I18N::translate('Batch update');
?>
</label>
<div class="col-sm-9">
<select class="form-control" name="plugin" onchange="reset_reload();">
<?php
if (!$this->plugin) {
?>
<option value="" selected></option>
<?php
}
?>
<?php
foreach ($this->plugins as $class => $plugin) {
?>
<option value="<?php
echo $class;
?>
" <?php
echo $this->plugin == $class ? 'selected' : '';
?>
><?php
echo $plugin->getName();
?>
</option>
<?php
}
?>
</select>
<?php
if ($this->PLUGIN) {
?>
<p class="small text-muted"><?php
echo $this->PLUGIN->getDescription();
?>
</p>
<?php
}
?>
</div>
</div>
<?php
if (!Auth::user()->getPreference('auto_accept')) {
?>
<div class="alert alert-danger">
<?php
echo I18N::translate('Your user account does not have “automatically approve changes” enabled. You will only be able to change one record at a time.');
?>
</div>
<?php
}
?>
<?php
// If a plugin is selected, display the details
?>
<?php
if ($this->PLUGIN) {
?>
<?php
echo $this->PLUGIN->getOptionsForm();
?>
<?php
if (substr($this->action, -4) == '_all') {
?>
<?php
// Reset - otherwise we might "undo all changes", which refreshes the
?>
<?php
// page, which makes them all again!
?>
<script>reset_reload();</script>
<?php
} else {
?>
<hr>
<div id="batch_update2" class="col-sm-12">
<?php
if ($this->curr_xref) {
?>
<?php
// Create an object, so we can get the latest version of the name.
?>
<?php
$this->record = GedcomRecord::getInstance($this->curr_xref, $WT_TREE);
?>
<div class="form-group">
<?php
echo self::createSubmitButton(I18N::translate('previous'), $this->prev_xref);
?>
<?php
echo self::createSubmitButton(I18N::translate('next'), $this->next_xref);
?>
</div>
<div class="form-group">
<a class="lead" href="<?php
echo $this->record->getHtmlUrl();
?>
"><?php
echo $this->record->getFullName();
?>
</a>
<?php
echo $this->PLUGIN->getActionPreview($this->record);
?>
</div>
<div class="form-group">
<?php
echo implode(' ', $this->PLUGIN->getActionButtons($this->curr_xref, $this->record));
?>
</div>
<?php
} else {
?>
<div class="alert alert-info"><?php
echo I18N::translate('Nothing found.');
?>
</div>
<?php
}
?>
</div>
<?php
}
?>
<?php
}
?>
</form>
<?php
}
/**
* Edit the configuration
*/
private function admin()
{
$controller = new PageController();
$controller->restrictAccess(Auth::isAdmin())->setPageTitle($this->getTitle())->pageHeader();
// Save the updated preferences
if (Filter::post('action') == 'save') {
foreach (Tree::getAll() as $tree) {
$tree->setPreference('include_in_sitemap', Filter::postBool('include' . $tree->getTreeId()));
}
// Clear cache and force files to be regenerated
Database::prepare("DELETE FROM `##module_setting` WHERE setting_name LIKE 'sitemap%'")->execute();
}
$include_any = false;
?>
<ol class="breadcrumb small">
<li><a href="admin.php"><?php
echo I18N::translate('Control panel');
?>
</a></li>
<li><a href="admin_modules.php"><?php
echo I18N::translate('Module administration');
?>
</a></li>
<li class="active"><?php
echo $controller->getPageTitle();
?>
</li>
</ol>
<h1><?php
echo $controller->getPageTitle();
?>
</h1>
<?php
echo '<p>', I18N::translate('Sitemaps are a way for webmasters to tell search engines about the pages on a website that are available for crawling. All major search engines support sitemaps. For more information, see <a href="http://www.sitemaps.org/">www.sitemaps.org</a>.') . '</p>', '<p>', I18N::translate('Which family trees should be included in the sitemaps'), '</p>', '<form method="post" action="module.php?mod=' . $this->getName() . '&mod_action=admin">', '<input type="hidden" name="action" value="save">';
foreach (Tree::getAll() as $tree) {
echo '<div class="checkbox"><label><input type="checkbox" name="include', $tree->getTreeId(), '" ';
if ($tree->getPreference('include_in_sitemap')) {
echo 'checked';
$include_any = true;
}
echo '>', $tree->getTitleHtml(), '</label></div>';
}
echo '<input type="submit" value="', I18N::translate('save'), '">', '</form>', '<hr>';
if ($include_any) {
$site_map_url1 = WT_BASE_URL . 'module.php?mod=' . $this->getName() . '&mod_action=generate&file=sitemap.xml';
$site_map_url2 = rawurlencode(WT_BASE_URL . 'module.php?mod=' . $this->getName() . '&mod_action=generate&file=sitemap.xml');
echo '<p>', I18N::translate('To tell search engines that sitemaps are available, you should add the following line to your robots.txt file.'), '</p>', '<pre>Sitemap: ', $site_map_url1, '</pre>', '<hr>', '<p>', I18N::translate('To tell search engines that sitemaps are available, you can use the following links.'), '</p>', '<ul>', '<li><a href="http://www.bing.com/webmaster/ping.aspx?siteMap=' . $site_map_url2 . '">Bing</a></li>', '<li><a href="http://www.google.com/webmasters/tools/ping?sitemap=' . $site_map_url2 . '">Google</a></li>', '</ul>';
}
}
/**
* Provide a form to manage the FAQs.
*/
private function config()
{
global $WT_TREE;
$controller = new PageController();
$controller->restrictAccess(Auth::isAdmin())->setPageTitle(I18N::translate('Frequently asked questions'))->pageHeader();
$faqs = Database::prepare("SELECT block_id, block_order, gedcom_id, bs1.setting_value AS header, bs2.setting_value AS faqbody" . " FROM `##block` b" . " JOIN `##block_setting` bs1 USING (block_id)" . " JOIN `##block_setting` bs2 USING (block_id)" . " WHERE module_name = :module_name" . " AND bs1.setting_name = 'header'" . " AND bs2.setting_name = 'faqbody'" . " AND IFNULL(gedcom_id, :tree_id_1) = :tree_id_2" . " ORDER BY block_order")->execute(array('module_name' => $this->getName(), 'tree_id_1' => $WT_TREE->getTreeId(), 'tree_id_2' => $WT_TREE->getTreeId()))->fetchAll();
$min_block_order = Database::prepare("SELECT MIN(block_order) FROM `##block` WHERE module_name = 'faq' AND (gedcom_id = :tree_id OR gedcom_id IS NULL)")->execute(array('tree_id' => $WT_TREE->getTreeId()))->fetchOne();
$max_block_order = Database::prepare("SELECT MAX(block_order) FROM `##block` WHERE module_name = 'faq' AND (gedcom_id = :tree_id OR gedcom_id IS NULL)")->execute(array('tree_id' => $WT_TREE->getTreeId()))->fetchOne();
?>
<ol class="breadcrumb small">
<li><a href="admin.php"><?php
echo I18N::translate('Control panel');
?>
</a></li>
<li><a href="admin_modules.php"><?php
echo I18N::translate('Module administration');
?>
</a></li>
<li class="active"><?php
echo $controller->getPageTitle();
?>
</li>
</ol>
<h2><?php
echo $controller->getPageTitle();
?>
</h2>
<p>
<?php
echo I18N::translate('FAQs are lists of questions and answers, which allow you to explain the site’s rules, policies, and procedures to your visitors. Questions are typically concerned with privacy, copyright, user-accounts, unsuitable content, requirement for source-citations, etc.');
?>
<?php
echo I18N::translate('You may use HTML to format the answer and to add links to other websites.');
?>
</p>
<form class="form form-inline">
<label for="ged" class="sr-only">
<?php
echo I18N::translate('Family tree');
?>
</label>
<input type="hidden" name="mod" value="<?php
echo $this->getName();
?>
">
<input type="hidden" name="mod_action" value="admin_config">
<?php
echo FunctionsEdit::selectEditControl('ged', Tree::getNameList(), null, $WT_TREE->getName(), 'class="form-control"');
?>
<input type="submit" class="btn btn-primary" value="<?php
echo I18N::translate('show');
?>
">
</form>
<p>
<a href="module.php?mod=<?php
echo $this->getName();
?>
&mod_action=admin_edit" class="btn btn-default">
<i class="fa fa-plus"></i>
<?php
echo I18N::translate('Add an FAQ item');
?>
</a>
</p>
<?php
echo '<table class="table table-bordered">';
if (empty($faqs)) {
echo '<tr><td class="error center" colspan="5">', I18N::translate('The FAQ list is empty.'), '</td></tr></table>';
} else {
foreach ($faqs as $faq) {
// NOTE: Print the position of the current item
echo '<tr class="faq_edit_pos"><td>';
echo I18N::translate('#%s', $faq->block_order + 1), ' ';
if ($faq->gedcom_id === null) {
echo I18N::translate('All');
} else {
echo $WT_TREE->getTitleHtml();
}
echo '</td>';
// NOTE: Print the edit options of the current item
echo '<td>';
if ($faq->block_order == $min_block_order) {
echo ' ';
} else {
echo '<a href="module.php?mod=', $this->getName(), '&mod_action=admin_moveup&block_id=', $faq->block_id, '"><i class="fa fa-arrow-up"></i></i> ', I18N::translate('Move up'), '</a>';
}
echo '</td><td>';
if ($faq->block_order == $max_block_order) {
echo ' ';
} else {
echo '<a href="module.php?mod=', $this->getName(), '&mod_action=admin_movedown&block_id=', $faq->block_id, '"><i class="fa fa-arrow-down"></i></i> ', I18N::translate('Move down'), '</a>';
}
echo '</td><td>';
echo '<a href="module.php?mod=', $this->getName(), '&mod_action=admin_edit&block_id=', $faq->block_id, '"><i class="fa fa-pencil"></i> ', I18N::translate('Edit'), '</a>';
echo '</td><td>';
echo '<a href="module.php?mod=', $this->getName(), '&mod_action=admin_delete&block_id=', $faq->block_id, '" onclick="return confirm(\'', I18N::translate('Are you sure you want to delete “%s”?', Filter::escapeHtml($faq->header)), '\');"><i class="fa fa-trash"></i> ', I18N::translate('Delete'), '</a>';
echo '</td></tr>';
// NOTE: Print the title text of the current item
echo '<tr><td colspan="5">';
echo '<div class="faq_edit_item">';
echo '<div class="faq_edit_title">', $faq->header, '</div>';
// NOTE: Print the body text of the current item
echo '<div class="faq_edit_content">', substr($faq->faqbody, 0, 1) == '<' ? $faq->faqbody : nl2br($faq->faqbody, false), '</div></div></td></tr>';
}
echo '</table>';
}
}
$parent = Filter::getArray('parent');
$level = count($parent);
if ($display == 'hierarchy') {
if ($level) {
$controller->setPageTitle(I18N::translate('Place hierarchy') . ' - <span dir="auto">' . Filter::escapeHtml(end($parent)) . '</span>');
} else {
$controller->setPageTitle(I18N::translate('Place hierarchy'));
}
} else {
$controller->setPageTitle(I18N::translate('Place list'));
}
$controller->pageHeader();
echo '<div id="place-hierarchy">';
switch ($display) {
case 'list':
echo '<h2>', $controller->getPageTitle(), '</h2>';
$list_places = Place::allPlaces($WT_TREE);
$num_places = count($list_places);
if ($num_places == 0) {
echo '<b>', I18N::translate('No results found.'), '</b><br>';
} else {
echo '<table class="list_table">';
echo '<tr><td class="list_label" ';
echo ' colspan="', $num_places > 20 ? 3 : 2, '"><i class="icon-place"></i> ';
echo I18N::translate('Place list');
echo '</td></tr><tr><td class="list_value_wrap"><ul>';
foreach ($list_places as $n => $list_place) {
echo '<li><a href="', $list_place->getURL(), '">', $list_place->getReverseName(), '</a></li>';
if ($num_places > 20) {
if ($n == (int) ($num_places / 3)) {
echo '</ul></td><td class="list_value_wrap"><ul>';
/**
* SosaList@missing
*/
public function missing()
{
global $WT_TREE;
$controller = new PageController();
$controller->setPageTitle(I18N::translate('Missing Ancestors'));
$this->view_bag->set('title', $controller->getPageTitle());
if ($this->view_bag->get('is_setup', false)) {
$this->view_bag->set('url_module', $this->module->getName());
$this->view_bag->set('url_action', 'SosaList@missing');
$this->view_bag->set('url_ged', $WT_TREE->getNameUrl());
$this->view_bag->set('min_gen', 2);
$missing_list = $this->sosa_provider->getMissingSosaListAtGeneration($this->generation);
$this->view_bag->set('has_missing', $this->generation > 0 && count($missing_list) > 0);
$perc_sosa = Functions::safeDivision($this->sosa_provider->getSosaCountAtGeneration($this->generation), pow(2, $this->generation - 1));
$this->view_bag->set('perc_sosa', $perc_sosa);
if ($this->view_bag->get('has_missing', false)) {
$table_id = 'table-sosa-missing-' . Uuid::uuid4();
$this->view_bag->set('table_id', $table_id);
$controller->addExternalJavascript(WT_JQUERY_DATATABLES_JS_URL)->addInlineJavascript('
/* Initialise datatables */
jQuery.fn.dataTableExt.oSort["unicode-asc" ]=function(a,b) {return a.replace(/<[^<]*>/, "").localeCompare(b.replace(/<[^<]*>/, ""))};
jQuery.fn.dataTableExt.oSort["unicode-desc" ]=function(a,b) {return b.replace(/<[^<]*>/, "").localeCompare(a.replace(/<[^<]*>/, ""))};
jQuery.fn.dataTableExt.oSort["num-html-asc" ]=function(a,b) {a=parseFloat(a.replace(/<[^<]*>/, "")); b=parseFloat(b.replace(/<[^<]*>/, "")); return (a<b) ? -1 : (a>b ? 1 : 0);};
jQuery.fn.dataTableExt.oSort["num-html-desc"]=function(a,b) {a=parseFloat(a.replace(/<[^<]*>/, "")); b=parseFloat(b.replace(/<[^<]*>/, "")); return (a>b) ? -1 : (a<b ? 1 : 0);};
jQuery("#' . $table_id . '").dataTable( {
dom: \'<"H"<"filtersH_' . $table_id . '">T<"dt-clear">pf<"dt-clear">irl>t<"F"pl<"dt-clear"><"filtersF_' . $table_id . '">>\',
' . I18N::datatablesI18N() . ',
jQueryUI: true,
autoWidth:false,
processing: true,
retrieve: true,
columns: [
/* 0-Sosa */ { type: "num", class: "center" },
/* 1-ID */ { class: "center" },
/* 2-givn */ { dataSort: 4, class: "left"},
/* 3-surn */ { dataSort: 5},
/* 4-GIVN,SURN */ { type: "unicode", visible: false},
/* 5-SURN,GIVN */ { type: "unicode", visible: false},
/* PERSO Modify table to include IsSourced module */
/* 6-INDI_SOUR */ { dataSort : 7, class: "center", visible: ' . (ModuleManager::getInstance()->isOperational(Constants::MODULE_MAJ_ISSOURCED_NAME) ? 'true' : 'false') . ' },
/* 7-SORT_INDISC */ { visible : false},
/* 8-Father */ { class: "center"},
/* 9-Mother */ { class: "center"},
/* 10-Birth */ { dataSort : 11 , class: "center"},
/* 11-SORT_BIRT */ { visible : false},
/* 12-BIRT_PLAC */ { type: "unicode", class: "center"},
/* 13-BIRT_SOUR */ { dataSort : 14, class: "center", visible: ' . (ModuleManager::getInstance()->isOperational(Constants::MODULE_MAJ_ISSOURCED_NAME) ? 'true' : 'false') . ' },
/* 14-SORT_BIRTSC */{ visible : false},
/* 15-SEX */ { visible : false}
/* END PERSO */
],
sorting: [[0,"asc"]],
displayLength: 20,
pagingType: "full_numbers"
});
jQuery("#' . $table_id . '")
/* Filter buttons in table header */
.on("click", "button[data-filter-column]", function() {
var btn = jQuery(this);
// De-activate the other buttons in this button group
btn.siblings().removeClass("ui-state-active");
// Apply (or clear) this filter
var col = jQuery("#' . $table_id . '").DataTable().column(btn.data("filter-column"));
if (btn.hasClass("ui-state-active")) {
btn.removeClass("ui-state-active");
col.search("").draw();
} else {
btn.addClass("ui-state-active");
col.search(btn.data("filter-value")).draw();
}
});
jQuery(".smissing-list").css("visibility", "visible");
jQuery(".loading-image").css("display", "none");
');
$unique_indis = array();
$sum_missing_different = 0;
$sum_missing_different_without_hidden = 0;
foreach ($missing_list as $num => $missing_tab) {
if (isset($unique_indis[$missing_tab['indi']])) {
unset($missing_list[$num]);
continue;
}
$sum_missing_different += !$missing_tab['has_father'] + !$missing_tab['has_mother'];
$person = Individual::getInstance($missing_tab['indi'], $WT_TREE);
if (!$person || !$person->canShowName()) {
unset($missing_list[$num]);
continue;
}
$sum_missing_different_without_hidden += !$missing_tab['has_father'] + !$missing_tab['has_mother'];
$unique_indis[$person->getXref()] = true;
$missing_tab['indi'] = $person;
$missing_list[$num] = $missing_tab;
}
$this->view_bag->set('missing_list', $missing_list);
$this->view_bag->set('missing_diff_count', $sum_missing_different);
$this->view_bag->set('missing_hidden', $sum_missing_different - $sum_missing_different_without_hidden);
$perc_sosa_potential = Functions::safeDivision($this->sosa_provider->getSosaCountAtGeneration($this->generation - 1), pow(2, $this->generation - 2));
$this->view_bag->set('perc_sosa_potential', $perc_sosa_potential);
}
}
ViewFactory::make('SosaListMissing', $this, $controller, $this->view_bag)->render();
}
private function pageBody(PageController $controller)
{
?>
<!-- FANCY TREEVIEW PAGE -->
<div id="fancy_treeview-page">
<div id="page-header">
<h2><?php
echo $controller->getPageTitle();
?>
</h2>
<?php
if ($this->pdf()) {
echo $this->pdf()->getPdfIcon();
}
?>
</div>
<div id="page-body">
<?php
if ($this->pdf()) {
echo $this->pdf()->getPdfWaitingMessage();
}
?>
<?php
if ($this->options('show_userform') >= Auth::accessLevel($this->tree())) {
?>
<form id="change_root">
<label class="label"><?php
echo I18N::translate('Change root person');
?>
</label>
<input
data-autocomplete-type="INDI"
id="new_rootid"
name="new_rootid"
placeholder="<?php
echo I18N::translate('Search ID by name');
?>
"
type="text"
>
<input
id="btn_go"
class="btn btn-primary btn-sm"
name="btn_go"
type="submit"
value="<?php
echo I18N::translate('Go');
?>
"
>
</form>
<div id="error"></div>
<?php
}
?>
<ol id="fancy_treeview"><?php
echo $this->printPage($this->options('numblocks'));
?>
</ol>
<div id="btn_next">
<input
class="btn btn-primary"
type="button"
name="next"
value="<?php
echo I18N::translate('next');
?>
"
>
</div>
</div>
</div>
<?php
}
/**
* Places administration.
*/
private function adminPlaces()
{
global $WT_TREE;
$action = Filter::get('action');
$parent = Filter::get('parent');
$inactive = Filter::getBool('inactive');
$deleteRecord = Filter::get('deleteRecord');
if (!isset($parent)) {
$parent = 0;
}
$controller = new PageController();
$controller->restrictAccess(Auth::isAdmin());
if ($action == 'ExportFile' && Auth::isAdmin()) {
$tmp = $this->placeIdToHierarchy($parent);
$maxLevel = $this->getHighestLevel();
if ($maxLevel > 8) {
$maxLevel = 8;
}
$tmp[0] = 'places';
$outputFileName = preg_replace('/[:;\\/\\\\(\\)\\{\\}\\[\\] $]/', '_', implode('-', $tmp)) . '.csv';
header('Content-Type: application/octet-stream');
header('Content-Disposition: attachment; filename="' . $outputFileName . '"');
echo '"', I18N::translate('Level'), '";"', I18N::translate('Country'), '";';
if ($maxLevel > 0) {
echo '"', I18N::translate('State'), '";';
}
if ($maxLevel > 1) {
echo '"', I18N::translate('County'), '";';
}
if ($maxLevel > 2) {
echo '"', I18N::translate('City'), '";';
}
if ($maxLevel > 3) {
echo '"', I18N::translate('Place'), '";';
}
if ($maxLevel > 4) {
echo '"', I18N::translate('Place'), '";';
}
if ($maxLevel > 5) {
echo '"', I18N::translate('Place'), '";';
}
if ($maxLevel > 6) {
echo '"', I18N::translate('Place'), '";';
}
if ($maxLevel > 7) {
echo '"', I18N::translate('Place'), '";';
}
echo '"', I18N::translate('Longitude'), '";"', I18N::translate('Latitude'), '";';
echo '"', I18N::translate('Zoom level'), '";"', I18N::translate('Icon'), '";', WT_EOL;
$this->outputLevel($parent);
exit;
}
$controller->setPageTitle(I18N::translate('Google Maps™'))->pageHeader();
?>
<ol class="breadcrumb small">
<li><a href="admin.php"><?php
echo I18N::translate('Control panel');
?>
</a></li>
<li><a href="admin_modules.php"><?php
echo I18N::translate('Module administration');
?>
</a></li>
<li class="active"><?php
echo $controller->getPageTitle();
?>
</li>
</ol>
<ul class="nav nav-tabs nav-justified" role="tablist">
<li role="presentation">
<a href="?mod=googlemap&mod_action=admin_config" role="tab">
<?php
echo I18N::translate('Google Maps™ preferences');
?>
</a>
</li>
<li role="presentation" class="active">
<a href="#">
<?php
echo I18N::translate('Geographic data');
?>
</a>
</li>
<li role="presentation">
<a href="?mod=googlemap&mod_action=admin_placecheck">
<?php
echo I18N::translate('Place check');
?>
</a>
</li>
</ul>
<h2><?php
echo I18N::translate('Geographic data');
?>
</h2>
<?php
if ($action == 'ImportGedcom') {
$placelist = array();
$j = 0;
$gedcom_records = Database::prepare("SELECT i_gedcom FROM `##individuals` WHERE i_file=? UNION ALL SELECT f_gedcom FROM `##families` WHERE f_file=?")->execute(array($WT_TREE->getTreeId(), $WT_TREE->getTreeId()))->fetchOneColumn();
foreach ($gedcom_records as $gedrec) {
$i = 1;
$placerec = Functions::getSubRecord(2, '2 PLAC', $gedrec, $i);
while (!empty($placerec)) {
if (preg_match("/2 PLAC (.+)/", $placerec, $match)) {
$placelist[$j] = array();
$placelist[$j]['place'] = trim($match[1]);
if (preg_match("/4 LATI (.*)/", $placerec, $match)) {
$placelist[$j]['lati'] = trim($match[1]);
if ($placelist[$j]['lati'][0] != 'N' && $placelist[$j]['lati'][0] != 'S') {
if ($placelist[$j]['lati'] < 0) {
$placelist[$j]['lati'][0] = 'S';
} else {
$placelist[$j]['lati'] = 'N' . $placelist[$j]['lati'];
}
}
} else {
$placelist[$j]['lati'] = null;
}
if (preg_match("/4 LONG (.*)/", $placerec, $match)) {
$placelist[$j]['long'] = trim($match[1]);
if ($placelist[$j]['long'][0] != 'E' && $placelist[$j]['long'][0] != 'W') {
if ($placelist[$j]['long'] < 0) {
$placelist[$j]['long'][0] = 'W';
} else {
$placelist[$j]['long'] = 'E' . $placelist[$j]['long'];
}
}
} else {
$placelist[$j]['long'] = null;
}
$j = $j + 1;
}
$i = $i + 1;
$placerec = Functions::getSubRecord(2, '2 PLAC', $gedrec, $i);
}
}
asort($placelist);
$prevPlace = '';
$prevLati = '';
$prevLong = '';
$placelistUniq = array();
$j = 0;
foreach ($placelist as $k => $place) {
if ($place['place'] != $prevPlace) {
$placelistUniq[$j] = array();
$placelistUniq[$j]['place'] = $place['place'];
$placelistUniq[$j]['lati'] = $place['lati'];
$placelistUniq[$j]['long'] = $place['long'];
$j = $j + 1;
} elseif ($place['place'] == $prevPlace && ($place['lati'] != $prevLati || $place['long'] != $prevLong)) {
if ($placelistUniq[$j - 1]['lati'] == 0 || $placelistUniq[$j - 1]['long'] == 0) {
$placelistUniq[$j - 1]['lati'] = $place['lati'];
$placelistUniq[$j - 1]['long'] = $place['long'];
} elseif ($place['lati'] != '0' || $place['long'] != '0') {
echo 'Difference: previous value = ', $prevPlace, ', ', $prevLati, ', ', $prevLong, ' current = ', $place['place'], ', ', $place['lati'], ', ', $place['long'], '<br>';
}
}
$prevPlace = $place['place'];
$prevLati = $place['lati'];
$prevLong = $place['long'];
}
$highestIndex = $this->getHighestIndex();
$default_zoom_level = array(4, 7, 10, 12);
foreach ($placelistUniq as $k => $place) {
$parent = preg_split('/ *, */', $place['place']);
$parent = array_reverse($parent);
$parent_id = 0;
for ($i = 0; $i < count($parent); $i++) {
if (!isset($default_zoom_level[$i])) {
$default_zoom_level[$i] = $default_zoom_level[$i - 1];
}
$escparent = $parent[$i];
if ($escparent == '') {
$escparent = 'Unknown';
}
$row = Database::prepare("SELECT pl_id, pl_long, pl_lati, pl_zoom FROM `##placelocation` WHERE pl_level=? AND pl_parent_id=? AND pl_place LIKE ?")->execute(array($i, $parent_id, $escparent))->fetchOneRow();
if ($i < count($parent) - 1) {
// Create higher-level places, if necessary
if (empty($row)) {
$highestIndex++;
Database::prepare("INSERT INTO `##placelocation` (pl_id, pl_parent_id, pl_level, pl_place, pl_zoom) VALUES (?, ?, ?, ?, ?)")->execute(array($highestIndex, $parent_id, $i, $escparent, $default_zoom_level[$i]));
echo Filter::escapeHtml($escparent), '<br>';
$parent_id = $highestIndex;
} else {
$parent_id = $row->pl_id;
}
} else {
// Create lowest-level place, if necessary
if (empty($row->pl_id)) {
$highestIndex++;
Database::prepare("INSERT INTO `##placelocation` (pl_id, pl_parent_id, pl_level, pl_place, pl_long, pl_lati, pl_zoom) VALUES (?, ?, ?, ?, ?, ?, ?)")->execute(array($highestIndex, $parent_id, $i, $escparent, $place['long'], $place['lati'], $default_zoom_level[$i]));
echo Filter::escapeHtml($escparent), '<br>';
} else {
if (empty($row->pl_long) && empty($row->pl_lati) && $place['lati'] != '0' && $place['long'] != '0') {
Database::prepare("UPDATE `##placelocation` SET pl_lati=?, pl_long=? WHERE pl_id=?")->execute(array($place['lati'], $place['long'], $row->pl_id));
echo Filter::escapeHtml($escparent), '<br>';
}
}
}
}
}
$parent = 0;
}
if ($action === 'ImportFile') {
$placefiles = $this->findFiles(WT_MODULES_DIR . 'googlemap/extra');
sort($placefiles);
?>
<form class="form-horizontal" method="post" enctype="multipart/form-data" id="importfile" name="importfile" action="module.php?mod=googlemap&mod_action=admin_places&action=ImportFile2">
<!-- PLACES FILE -->
<div class="form-group">
<label class="control-label col-sm-4" for="placesfile">
<?php
echo I18N::translate('File containing places (CSV)');
?>
</label>
<div class="col-sm-8">
<div class="btn btn-default">
<input id="placesfile" type="file" name="placesfile">
</div>
</div>
</div>
<!-- LOCAL FILE -->
<?php
if (count($placefiles) > 0) {
?>
<div class="form-group">
<label class="control-label col-sm-4" for="localfile">
<?php
echo I18N::translate('Server file containing places (CSV)');
?>
</label>
<div class="col-sm-8">
<div class="input-group">
<span class="input-group-addon">
<?php
echo WT_MODULES_DIR . 'googlemap/extra/';
?>
</span>
<?php
foreach ($placefiles as $p => $placefile) {
unset($placefiles[$p]);
$p = Filter::escapeHtml($placefile);
if (substr($placefile, 0, 1) == "/") {
$placefiles[$p] = substr($placefile, 1);
} else {
$placefiles[$p] = $placefile;
}
}
echo FunctionsEdit::selectEditControl('localfile', $placefiles, '', '', 'class="form-control"');
?>
</div>
</div>
</div>
<?php
}
?>
<!-- CLEAR DATABASE -->
<fieldset class="form-group">
<legend class="control-label col-sm-4">
<?php
echo I18N::translate('Delete all existing geographic data before importing the file.');
?>
</legend>
<div class="col-sm-8">
<?php
echo FunctionsEdit::editFieldYesNo('cleardatabase', 0, 'class="radio-inline"');
?>
</div>
</fieldset>
<!-- UPDATE ONLY -->
<fieldset class="form-group">
<legend class="control-label col-sm-4">
<?php
echo I18N::translate('Do not create new locations, just import coordinates for existing locations.');
?>
</legend>
<div class="col-sm-8">
<?php
echo FunctionsEdit::editFieldYesNo('updateonly', 0, 'class="radio-inline"');
?>
</div>
</fieldset>
<!-- OVERWRITE DATA -->
<fieldset class="form-group">
<legend class="control-label col-sm-4">
<?php
echo I18N::translate('Overwrite existing coordinates.');
?>
</legend>
<div class="col-sm-8">
<?php
echo FunctionsEdit::editFieldYesNo('overwritedata', 0, 'class="radio-inline"');
?>
</div>
</fieldset>
<!-- SAVE BUTTON -->
<div class="form-group">
<div class="col-sm-offset-4 col-sm-8">
<button type="submit" class="btn btn-primary">
<i class="fa fa-check"></i>
<?php
echo I18N::translate('Continue adding');
?>
</button>
</div>
</div>
</form>
<?php
exit;
}
if ($action === 'ImportFile2') {
$country_names = array();
$stats = new Stats($WT_TREE);
foreach ($stats->iso3166() as $key => $value) {
$country_names[$key] = I18N::translate($key);
}
if (Filter::postBool('cleardatabase')) {
Database::exec("DELETE FROM `##placelocation` WHERE 1=1");
}
if (!empty($_FILES['placesfile']['tmp_name'])) {
$lines = file($_FILES['placesfile']['tmp_name']);
} elseif (!empty($_REQUEST['localfile'])) {
$lines = file(WT_MODULES_DIR . 'googlemap/extra' . $_REQUEST['localfile']);
}
// Strip BYTE-ORDER-MARK, if present
if (!empty($lines[0]) && substr($lines[0], 0, 3) === WT_UTF8_BOM) {
$lines[0] = substr($lines[0], 3);
}
asort($lines);
$highestIndex = $this->getHighestIndex();
$placelist = array();
$j = 0;
$maxLevel = 0;
foreach ($lines as $p => $placerec) {
$fieldrec = explode(';', $placerec);
if ($fieldrec[0] > $maxLevel) {
$maxLevel = $fieldrec[0];
}
}
$fields = count($fieldrec);
$set_icon = true;
if (!is_dir(WT_MODULES_DIR . 'googlemap/places/flags/')) {
$set_icon = false;
}
foreach ($lines as $p => $placerec) {
$fieldrec = explode(';', $placerec);
if (is_numeric($fieldrec[0]) && $fieldrec[0] <= $maxLevel) {
$placelist[$j] = array();
$placelist[$j]['place'] = '';
for ($ii = $fields - 4; $ii > 1; $ii--) {
if ($fieldrec[0] > $ii - 2) {
$placelist[$j]['place'] .= $fieldrec[$ii] . ',';
}
}
foreach ($country_names as $countrycode => $countryname) {
if ($countrycode == strtoupper($fieldrec[1])) {
$fieldrec[1] = $countryname;
break;
}
}
$placelist[$j]['place'] .= $fieldrec[1];
$placelist[$j]['long'] = $fieldrec[$fields - 4];
$placelist[$j]['lati'] = $fieldrec[$fields - 3];
$placelist[$j]['zoom'] = $fieldrec[$fields - 2];
if ($set_icon) {
$placelist[$j]['icon'] = trim($fieldrec[$fields - 1]);
} else {
$placelist[$j]['icon'] = '';
}
$j = $j + 1;
}
}
$prevPlace = '';
$prevLati = '';
$prevLong = '';
$placelistUniq = array();
$j = 0;
foreach ($placelist as $k => $place) {
if ($place['place'] != $prevPlace) {
$placelistUniq[$j] = array();
$placelistUniq[$j]['place'] = $place['place'];
$placelistUniq[$j]['lati'] = $place['lati'];
$placelistUniq[$j]['long'] = $place['long'];
$placelistUniq[$j]['zoom'] = $place['zoom'];
$placelistUniq[$j]['icon'] = $place['icon'];
$j = $j + 1;
} elseif ($place['place'] == $prevPlace && ($place['lati'] != $prevLati || $place['long'] != $prevLong)) {
if ($placelistUniq[$j - 1]['lati'] == 0 || $placelistUniq[$j - 1]['long'] == 0) {
$placelistUniq[$j - 1]['lati'] = $place['lati'];
$placelistUniq[$j - 1]['long'] = $place['long'];
$placelistUniq[$j - 1]['zoom'] = $place['zoom'];
$placelistUniq[$j - 1]['icon'] = $place['icon'];
} elseif ($place['lati'] != '0' || $place['long'] != '0') {
echo 'Difference: previous value = ', $prevPlace, ', ', $prevLati, ', ', $prevLong, ' current = ', $place['place'], ', ', $place['lati'], ', ', $place['long'], '<br>';
}
}
$prevPlace = $place['place'];
$prevLati = $place['lati'];
$prevLong = $place['long'];
}
$default_zoom_level = array();
$default_zoom_level[0] = 4;
$default_zoom_level[1] = 7;
$default_zoom_level[2] = 10;
$default_zoom_level[3] = 12;
foreach ($placelistUniq as $k => $place) {
$parent = explode(',', $place['place']);
$parent = array_reverse($parent);
$parent_id = 0;
for ($i = 0; $i < count($parent); $i++) {
$escparent = $parent[$i];
if ($escparent == '') {
$escparent = 'Unknown';
}
$row = Database::prepare("SELECT pl_id, pl_long, pl_lati, pl_zoom, pl_icon FROM `##placelocation` WHERE pl_level=? AND pl_parent_id=? AND pl_place LIKE ? ORDER BY pl_place")->execute(array($i, $parent_id, $escparent))->fetchOneRow();
if (empty($row)) {
// this name does not yet exist: create entry
if (!Filter::postBool('updateonly')) {
$highestIndex = $highestIndex + 1;
if ($i + 1 == count($parent)) {
$zoomlevel = $place['zoom'];
} elseif (isset($default_zoom_level[$i])) {
$zoomlevel = $default_zoom_level[$i];
} else {
$zoomlevel = $this->getSetting('GM_MAX_ZOOM');
}
if ($place['lati'] == '0' || $place['long'] == '0' || $i + 1 < count($parent)) {
Database::prepare("INSERT INTO `##placelocation` (pl_id, pl_parent_id, pl_level, pl_place, pl_zoom, pl_icon) VALUES (?, ?, ?, ?, ?, ?)")->execute(array($highestIndex, $parent_id, $i, $escparent, $zoomlevel, $place['icon']));
} else {
//delete leading zero
$pl_lati = str_replace(array('N', 'S', ','), array('', '-', '.'), $place['lati']);
$pl_long = str_replace(array('E', 'W', ','), array('', '-', '.'), $place['long']);
if ($pl_lati >= 0) {
$place['lati'] = 'N' . abs($pl_lati);
} elseif ($pl_lati < 0) {
$place['lati'] = 'S' . abs($pl_lati);
}
if ($pl_long >= 0) {
$place['long'] = 'E' . abs($pl_long);
} elseif ($pl_long < 0) {
$place['long'] = 'W' . abs($pl_long);
}
Database::prepare("INSERT INTO `##placelocation` (pl_id, pl_parent_id, pl_level, pl_place, pl_long, pl_lati, pl_zoom, pl_icon) VALUES (?, ?, ?, ?, ?, ?, ?, ?)")->execute(array($highestIndex, $parent_id, $i, $escparent, $place['long'], $place['lati'], $zoomlevel, $place['icon']));
}
$parent_id = $highestIndex;
}
} else {
$parent_id = $row->pl_id;
if (Filter::postBool('overwritedata') && $i + 1 == count($parent)) {
Database::prepare("UPDATE `##placelocation` SET pl_lati = ?, pl_long = ?, pl_zoom = ?, pl_icon = ? WHERE pl_id = ?")->execute(array($place['lati'], $place['long'], $place['zoom'], $place['icon'], $parent_id));
} else {
// Update only if existing data is missing
if (!$row->pl_long && !$row->pl_lati) {
Database::prepare("UPDATE `##placelocation` SET pl_lati = ?, pl_long = ? WHERE pl_id = ?")->execute(array($place['lati'], $place['long'], $parent_id));
}
if (!$row->pl_icon && $place['icon']) {
Database::prepare("UPDATE `##placelocation` SET pl_icon = ? WHERE pl_id = ?")->execute(array($place['icon'], $parent_id));
}
}
}
}
}
$parent = 0;
}
if ($action == 'DeleteRecord') {
$exists = Database::prepare("SELECT 1 FROM `##placelocation` WHERE pl_parent_id=?")->execute(array($deleteRecord))->fetchOne();
if (!$exists) {
Database::prepare("DELETE FROM `##placelocation` WHERE pl_id=?")->execute(array($deleteRecord));
} else {
echo '<table class="facts_table"><tr><td>', I18N::translate('Location not removed: this location contains sub-locations'), '</td></tr></table>';
}
}
?>
<script>
function updateList(inactive) {
window.location.href='<?php
if (strstr($_SERVER['REQUEST_URI'], '&inactive', true)) {
$uri = strstr($_SERVER['REQUEST_URI'], '&inactive', true);
} else {
$uri = $_SERVER['REQUEST_URI'];
}
echo $uri, '&inactive=';
?>
'+inactive;
}
function edit_place_location(placeid) {
window.open('module.php?mod=googlemap&mod_action=places_edit&action=update&placeid='+placeid, '_blank', gmap_window_specs);
return false;
}
function add_place_location(placeid) {
window.open('module.php?mod=googlemap&mod_action=places_edit&action=add&placeid='+placeid, '_blank', gmap_window_specs);
return false;
}
function delete_place(placeid) {
var answer=confirm('<?php
echo I18N::translate('Remove this location?');
?>
');
if (answer == true) {
window.location = '<?php
echo Functions::getQueryUrl(array('action' => 'DeleteRecord'));
?>
&action=DeleteRecord&deleteRecord=' + placeid;
}
}
</script>
<p id="gm_breadcrumb">
<?php
$where_am_i = $this->placeIdToHierarchy($parent);
foreach (array_reverse($where_am_i, true) as $id => $place) {
if ($id == $parent) {
if ($place != 'Unknown') {
echo Filter::escapeHtml($place);
} else {
echo I18N::translate('unknown');
}
} else {
echo '<a href="module.php?mod=googlemap&mod_action=admin_places&parent=', $id, '&inactive=', $inactive, '">';
if ($place != 'Unknown') {
echo Filter::escapeHtml($place), '</a>';
} else {
echo I18N::translate('unknown'), '</a>';
}
}
echo ' - ';
}
?>
<a href="module.php?mod=googlemap&mod_action=admin_places&parent=0&inactive=', $inactive, '"><?php
echo I18N::translate('Top level');
?>
</a>
</p>
<form class="form-inline" name="active" method="post" action="module.php?mod=googlemap&mod_action=admin_places&parent=', $parent, '&inactive=', $inactive, '">
<div class="checkbox">
<label for="inactive">
<?php
echo FunctionsEdit::checkbox('inactive', $inactive, 'onclick="updateList(this.checked)"');
?>
<?php
echo I18N::translate('Show inactive places');
?>
</label>
</div>
<p class="small text-muted">
<?php
echo I18N::translate('By default, the list shows only those places which can be found in your family trees. You may have details for other places, such as those imported in bulk from an external file. Selecting this option will show all places, including ones that are not currently used.');
?>
<?php
echo I18N::translate('If you have a large number of inactive places, it can be slow to generate the list.');
?>
</p>
</form>
<?php
$placelist = $this->getPlaceListLocation($parent, $inactive);
echo '<div class="gm_plac_edit">';
echo '<table class="table table-bordered table-condensed table-hover"><tr>';
echo '<th>', GedcomTag::getLabel('PLAC'), '</th>';
echo '<th>', GedcomTag::getLabel('LATI'), '</th>';
echo '<th>', GedcomTag::getLabel('LONG'), '</th>';
echo '<th>', I18N::translate('Zoom level'), '</th>';
echo '<th>', I18N::translate('Icon'), '</th>';
echo '<th>';
echo I18N::translate('Edit'), '</th><th>', I18N::translate('Delete'), '</th></tr>';
if (count($placelist) == 0) {
echo '<tr><td colspan="7">', I18N::translate('No places found'), '</td></tr>';
}
foreach ($placelist as $place) {
echo '<tr><td><a href="module.php?mod=googlemap&mod_action=admin_places&parent=', $place['place_id'], '&inactive=', $inactive, '">';
if ($place['place'] != 'Unknown') {
echo Filter::escapeHtml($place['place']), '</a></td>';
} else {
echo I18N::translate('unknown'), '</a></td>';
}
echo '<td>', $place['lati'], '</td>';
echo '<td>', $place['long'], '</td>';
echo '<td>', $place['zoom'], '</td>';
echo '<td>';
if ($place['icon']) {
echo '<img src="', WT_STATIC_URL, WT_MODULES_DIR, 'googlemap/', $place['icon'], '" width="25" height="15">';
} else {
if ($place['lati'] || $place['long']) {
echo '<img src="', WT_STATIC_URL, WT_MODULES_DIR, 'googlemap/images/mm_20_red.png">';
} else {
echo '<img src="', WT_STATIC_URL, WT_MODULES_DIR, 'googlemap/images/mm_20_yellow.png">';
}
}
echo '</td>';
echo '<td class="narrow"><a href="#" onclick="edit_place_location(', $place['place_id'], ');return false;" class="icon-edit" title="', I18N::translate('Edit'), '"></a></td>';
$noRows = Database::prepare("SELECT COUNT(pl_id) FROM `##placelocation` WHERE pl_parent_id=?")->execute(array($place['place_id']))->fetchOne();
if ($noRows == 0) {
?>
<td><a href="#" onclick="delete_place(<?php
echo $place['place_id'];
?>
);return false;" class="icon-delete" title="<?php
echo I18N::translate('Remove');
?>
"></a></td>
<?php
} else {
?>
<td><i class="icon-delete-grey"></i></td>
<?php
}
?>
</tr>
<?php
}
?>
</table>
</div>
<hr>
<form class="form-horizontal" action="?" onsubmit="add_place_location(this.parent_id.options[this.parent_id.selectedIndex].value); return false;">
<div class="form-group">
<label class="form-control-static col-sm-4" for="parent_id">
<?php
echo I18N::translate('Add a new geographic location');
?>
</label>
<div class="col-sm-8">
<div class="col-sm-6">
<?php
echo FunctionsEdit::selectEditControl('parent_id', $where_am_i, I18N::translate('Top level'), $parent, 'class="form-control"');
?>
</div>
<button type="submit" class="btn btn-default">
<i class="fa fa-plus"></i>
<?php
echo I18N::translate('Add');
?>
</button>
</div>
</div>
</form>
<form class="form-horizontal" action="module.php" method="get">
<input type="hidden" name="mod" value="googlemap">
<input type="hidden" name="mod_action" value="admin_places">
<input type="hidden" name="action" value="ImportGedcom">
<div class="form-group">
<label class="form-control-static col-sm-4" for="ged">
<?php
echo I18N::translate('Import all places from a family tree');
?>
</label>
<div class="col-sm-8">
<div class="col-sm-6">
<?php
echo FunctionsEdit::selectEditControl('ged', Tree::getNameList(), null, $WT_TREE->getName(), 'class="form-control"');
?>
</div>
<button type="submit" class="btn btn-default">
<i class="fa fa-upload"></i>
<?php
echo I18N::translate('Import');
?>
</button>
</div>
</div>
</form>
<form class="form-horizontal" action="module.php" method="get">
<input type="hidden" name="mod" value="googlemap">
<input type="hidden" name="mod_action" value="admin_places">
<input type="hidden" name="action" value="ImportFile">
<div class="form-group">
<label class="form-control-static col-sm-4">
<?php
echo I18N::translate('Upload geographic data');
?>
</label>
<div class="col-sm-8">
<div class="col-sm-6">
<button type="submit" class="btn btn-default">
<i class="fa fa-upload"></i>
<?php
echo I18N::translate('Upload');
?>
</button>
</div>
</div>
</div>
</form>
<form class="form-horizontal" action="module.php" method="get">
<input type="hidden" name="mod" value="googlemap">
<input type="hidden" name="mod_action" value="admin_places">
<input type="hidden" name="action" value="ExportFile">
<div class="form-group">
<label class="form-control-static col-sm-4">
<?php
echo I18N::translate('Download geographic data');
?>
</label>
<div class="col-sm-8">
<div class="col-sm-6">
<?php
echo FunctionsEdit::selectEditControl('parent', $where_am_i, I18N::translate('All'), $WT_TREE->getTreeId(), 'class="form-control"');
?>
</div>
<button type="submit" class="btn btn-default">
<i class="fa fa-download"></i>
<?php
echo I18N::translate('Download');
?>
</button>
</div>
</div>
</form>
<?php
}
/**
* The admin view - list, create, edit, delete stories.
*/
private function config()
{
global $WT_TREE;
$controller = new PageController();
$controller->restrictAccess(Auth::isAdmin())->setPageTitle($this->getTitle())->pageHeader()->addExternalJavascript(WT_JQUERY_DATATABLES_JS_URL)->addExternalJavascript(WT_DATATABLES_BOOTSTRAP_JS_URL)->addInlineJavascript('
jQuery("#story_table").dataTable({
' . I18N::datatablesI18N() . ',
autoWidth: false,
paging: true,
pagingType: "full_numbers",
lengthChange: true,
filter: true,
info: true,
sorting: [[0,"asc"]],
columns: [
/* 0-name */ null,
/* 1-NAME */ null,
/* 2-NAME */ { sortable:false },
/* 3-NAME */ { sortable:false }
]
});
');
$stories = Database::prepare("SELECT block_id, xref" . " FROM `##block` b" . " WHERE module_name=?" . " AND gedcom_id=?" . " ORDER BY xref")->execute(array($this->getName(), $WT_TREE->getTreeId()))->fetchAll();
?>
<ol class="breadcrumb small">
<li><a href="admin.php"><?php
echo I18N::translate('Control panel');
?>
</a></li>
<li><a href="admin_modules.php"><?php
echo I18N::translate('Module administration');
?>
</a></li>
<li class="active"><?php
echo $controller->getPageTitle();
?>
</li>
</ol>
<h1><?php
echo $controller->getPageTitle();
?>
</h1>
<form class="form form-inline">
<label for="ged" class="sr-only">
<?php
echo I18N::translate('Family tree');
?>
</label>
<input type="hidden" name="mod" value="<?php
echo $this->getName();
?>
">
<input type="hidden" name="mod_action" value="admin_config">
<?php
echo FunctionsEdit::selectEditControl('ged', Tree::getNameList(), null, $WT_TREE->getName(), 'class="form-control"');
?>
<input type="submit" class="btn btn-primary" value="<?php
echo I18N::translate('show');
?>
">
</form>
<p>
<a href="module.php?mod=<?php
echo $this->getName();
?>
&mod_action=admin_edit" class="btn btn-default">
<i class="fa fa-plus"></i>
<?php
echo I18N::translate('Add a story');
?>
</a>
</p>
<table class="table table-bordered table-condensed">
<thead>
<tr>
<th><?php
echo I18N::translate('Story title');
?>
</th>
<th><?php
echo I18N::translate('Individual');
?>
</th>
<th><?php
echo I18N::translate('Edit');
?>
</th>
<th><?php
echo I18N::translate('Delete');
?>
</th>
</tr>
</thead>
<tbody>
<?php
foreach ($stories as $story) {
?>
<tr>
<td>
<?php
echo Filter::escapeHtml($this->getBlockSetting($story->block_id, 'title'));
?>
</td>
<td>
<?php
$individual = Individual::getInstance($story->xref, $WT_TREE);
?>
<?php
if ($individual) {
?>
<a href="<?php
echo $individual->getHtmlUrl();
?>
#stories">
<?php
echo $individual->getFullName();
?>
</a>
<?php
} else {
?>
<?php
echo $story->xref;
?>
<?php
}
?>
</td>
<td>
<a href="module.php?mod=<?php
echo $this->getName();
?>
&mod_action=admin_edit&block_id=<?php
echo $story->block_id;
?>
">
<i class="fa fa-pencil"></i> <?php
echo I18N::translate('Edit');
?>
</a>
</td>
<td>
<a
href="module.php?mod=<?php
echo $this->getName();
?>
&mod_action=admin_delete&block_id=<?php
echo $story->block_id;
?>
"
onclick="return confirm('<?php
echo I18N::translate('Are you sure you want to delete “%s”?', Filter::escapeHtml($this->getBlockSetting($story->block_id, 'title')));
?>
');"
>
<i class="fa fa-trash"></i> <?php
echo I18N::translate('Delete');
?>
</a>
</td>
</tr>
<?php
}
?>
</tbody>
</table>
<?php
}
}
return;
}
$controller->pageHeader();
?>
<ol class="breadcrumb small">
<li><a href="admin.php"><?php
echo I18N::translate('Control panel');
?>
</a></li>
<li><a href="admin_trees_manage.php"><?php
echo I18N::translate('Manage family trees');
?>
</a></li>
<li class="active"><?php
echo $controller->getPageTitle();
?>
</li>
</ol>
<h1><?php
echo $controller->getPageTitle();
?>
</h1>
<form class="form form-horizontal" method="post" action="admin_trees_export.php">
<?php
echo Filter::getCsrf();
?>
<input type="hidden" name="ged" value="<?php
echo $WT_TREE->getNameHtml();
/**
* Task@edit
*/
public function edit()
{
global $WT_TREE;
$task_name = Filter::get('task');
$task = $this->provider->getTask($task_name, false);
Theme::theme(new AdministrationTheme())->init($WT_TREE);
$controller = new PageController();
$controller->restrictAccess(Auth::isAdmin() && $task)->setPageTitle(I18N::translate('Edit the administrative task'))->addInlineJavascript('
function toggleRemainingOccurrences() {
if($("input:radio[name=\'is_limited\']:checked").val() == 1) {
$("#nb_occurences").show();
}
else {
$("#nb_occurences").hide();
}
}
$("[name=\'is_limited\']").on("change", toggleRemainingOccurrences);
toggleRemainingOccurrences();
');
$data = new ViewBag();
$data->set('title', $controller->getPageTitle());
$data->set('admin_config_url', 'module.php?mod=' . $this->module->getName() . '&mod_action=AdminConfig&ged=' . $WT_TREE->getNameUrl());
$data->set('module_title', $this->module->getTitle());
$data->set('save_url', 'module.php?mod=' . $this->module->getName() . '&mod_action=Task@save&ged=' . $WT_TREE->getNameUrl());
$data->set('task', $task);
ViewFactory::make('TaskEdit', $this, $controller, $data)->render();
}
