. */ declare(strict_types=1); namespace Fisharebest\Webtrees\Module; use Fisharebest\Algorithm\Dijkstra; use Fisharebest\Webtrees\Auth; use Fisharebest\Webtrees\Family; use Fisharebest\Webtrees\FlashMessages; use Fisharebest\Webtrees\FontAwesome; use Fisharebest\Webtrees\Functions\Functions; use Fisharebest\Webtrees\Functions\FunctionsPrint; use Fisharebest\Webtrees\I18N; use Fisharebest\Webtrees\Individual; use Fisharebest\Webtrees\Menu; use Fisharebest\Webtrees\Theme; use Fisharebest\Webtrees\Tree; use Fisharebest\Webtrees\User; use Illuminate\Database\Capsule\Manager as DB; use Illuminate\Database\Query\JoinClause; use Symfony\Component\HttpFoundation\RedirectResponse; use Symfony\Component\HttpFoundation\Request; use Symfony\Component\HttpFoundation\Response; /** * Class RelationshipsChartModule */ class RelationshipsChartModule extends AbstractModule implements ModuleChartInterface, ModuleConfigInterface { use ModuleChartTrait; use ModuleConfigTrait; /** It would be more correct to use PHP_INT_MAX, but this isn't friendly in URLs */ public const UNLIMITED_RECURSION = 99; /** By default new trees allow unlimited recursion */ public const DEFAULT_RECURSION = '99'; /** By default new trees search for all relationships (not via ancestors) */ public const DEFAULT_ANCESTORS = '0'; /** * How should this module be labelled on tabs, menus, etc.? * * @return string */ public function title(): string { /* I18N: Name of a module/chart */ return I18N::translate('Relationships'); } /** * A sentence describing what this module does. * * @return string */ public function description(): string { /* I18N: Description of the “RelationshipsChart” module */ return I18N::translate('A chart displaying relationships between two individuals.'); } /** * A main menu item for this chart. * * @param Individual $individual * * @return Menu */ public function chartMenu(Individual $individual): Menu { $gedcomid = $individual->tree()->getUserPreference(Auth::user(), 'gedcomid'); if ($gedcomid !== '' && $gedcomid !== $individual->xref()) { return new Menu( I18N::translate('Relationship to me'), $this->chartUrl($individual, ['xref2' => $gedcomid]), $this->chartMenuClass(), $this->chartUrlAttributes() ); } return new Menu( $this->title(), $this->chartUrl($individual), $this->chartMenuClass(), $this->chartUrlAttributes() ); } /** * CSS class for the URL. * * @return string */ public function chartMenuClass(): string { return 'menu-chart-relationship'; } /** * Return a menu item for this chart - for use in individual boxes. * * @param Individual $individual * * @return Menu|null */ public function chartBoxMenu(Individual $individual): ?Menu { return $this->chartMenu($individual); } /** * @return Response */ public function getAdminAction(): Response { $this->layout = 'layouts/administration'; return $this->viewResponse('modules/relationships-chart/config', [ 'all_trees' => Tree::getAll(), 'ancestors_options' => $this->ancestorsOptions(), 'default_ancestors' => self::DEFAULT_ANCESTORS, 'default_recursion' => self::DEFAULT_RECURSION, 'recursion_options' => $this->recursionConfigOptions(), 'title' => I18N::translate('Chart preferences') . ' — ' . $this->title(), ]); } /** * @param Request $request * * @return RedirectResponse */ public function postAdminAction(Request $request): RedirectResponse { foreach (Tree::getAll() as $tree) { $recursion = $request->get('relationship-recursion-' . $tree->id(), ''); $ancestors = $request->get('relationship-ancestors-' . $tree->id(), ''); $tree->setPreference('RELATIONSHIP_RECURSION', $recursion); $tree->setPreference('RELATIONSHIP_ANCESTORS', $ancestors); } FlashMessages::addMessage(I18N::translate('The preferences for the module “%s” have been updated.', $this->title()), 'success'); return new RedirectResponse($this->getConfigLink()); } /** * Possible options for the ancestors option * * @return string[] */ private function ancestorsOptions(): array { return [ 0 => I18N::translate('Find any relationship'), 1 => I18N::translate('Find relationships via ancestors'), ]; } /** * Possible options for the recursion option * * @return string[] */ private function recursionConfigOptions(): array { return [ 0 => I18N::translate('none'), 1 => I18N::number(1), 2 => I18N::number(2), 3 => I18N::number(3), self::UNLIMITED_RECURSION => I18N::translate('unlimited'), ]; } /** * A form to request the chart parameters. * * @param Request $request * @param Tree $tree * @param User $user * * @return Response */ public function getChartAction(Request $request, Tree $tree, User $user): Response { $ajax = (bool) $request->get('ajax'); $xref = $request->get('xref', ''); $xref2 = $request->get('xref2', ''); $individual1 = Individual::getInstance($xref, $tree); $individual2 = Individual::getInstance($xref2, $tree); $recursion = (int) $request->get('recursion', '0'); $ancestors = (int) $request->get('ancestors', '0'); $ancestors_only = (int) $tree->getPreference('RELATIONSHIP_ANCESTORS', static::DEFAULT_ANCESTORS); $max_recursion = (int) $tree->getPreference('RELATIONSHIP_RECURSION', static::DEFAULT_RECURSION); $recursion = min($recursion, $max_recursion); if ($individual1 instanceof Individual) { Auth::checkIndividualAccess($individual1); } if ($individual2 instanceof Individual) { Auth::checkIndividualAccess($individual2); } Auth::checkComponentAccess($this, 'chart', $tree, $user); if ($individual1 instanceof Individual && $individual2 instanceof Individual) { if ($ajax) { return $this->chart($individual1, $individual2, $recursion, $ancestors); } /* I18N: %s are individual’s names */ $title = I18N::translate('Relationships between %1$s and %2$s', $individual1->getFullName(), $individual2->getFullName()); $ajax_url = $this->chartUrl($individual1, [ 'ajax' => true, 'xref2' => $individual2->xref(), 'recursion' => $recursion, 'ancestors' => $ancestors, ]); } else { $title = I18N::translate('Relationships'); $ajax_url = ''; } return $this->viewResponse('modules/relationships-chart/page', [ 'ajax_url' => $ajax_url, 'ancestors' => $ancestors, 'ancestors_only' => $ancestors_only, 'ancestors_options' => $this->ancestorsOptions(), 'individual1' => $individual1, 'individual2' => $individual2, 'max_recursion' => $max_recursion, 'module_name' => $this->name(), 'recursion' => $recursion, 'recursion_options' => $this->recursionOptions($max_recursion), 'title' => $title, ]); } /** * @param Individual $individual1 * @param Individual $individual2 * @param int $recursion * @param int $ancestors * * @return Response */ public function chart(Individual $individual1, Individual $individual2, int $recursion, int $ancestors): Response { $tree = $individual1->tree(); $max_recursion = (int) $tree->getPreference('RELATIONSHIP_RECURSION', static::DEFAULT_RECURSION); $recursion = min($recursion, $max_recursion); $paths = $this->calculateRelationships($individual1, $individual2, $recursion, (bool) $ancestors); // @TODO - convert to views ob_start(); if (I18N::direction() === 'ltr') { $diagonal1 = app()->make(ModuleThemeInterface::class)->parameter('image-dline'); $diagonal2 = app()->make(ModuleThemeInterface::class)->parameter('image-dline2'); } else { $diagonal1 = app()->make(ModuleThemeInterface::class)->parameter('image-dline2'); $diagonal2 = app()->make(ModuleThemeInterface::class)->parameter('image-dline'); } $num_paths = 0; foreach ($paths as $path) { // Extract the relationship names between pairs of individuals $relationships = $this->oldStyleRelationshipPath($tree, $path); if (empty($relationships)) { // Cannot see one of the families/individuals, due to privacy; continue; } echo '

', I18N::translate('Relationship: %s', Functions::getRelationshipNameFromPath(implode('', $relationships), $individual1, $individual2)), '

'; $num_paths++; // Use a table/grid for layout. $table = []; // Current position in the grid. $x = 0; $y = 0; // Extent of the grid. $min_y = 0; $max_y = 0; $max_x = 0; // For each node in the path. foreach ($path as $n => $xref) { if ($n % 2 === 1) { switch ($relationships[$n]) { case 'hus': case 'wif': case 'spo': case 'bro': case 'sis': case 'sib': $table[$x + 1][$y] = '
' . Functions::getRelationshipNameFromPath($relationships[$n], Individual::getInstance($path[$n - 1], $tree), Individual::getInstance($path[$n + 1], $tree)) . '
' . view('icons/arrow-end') . '
'; $x += 2; break; case 'son': case 'dau': case 'chi': if ($n > 2 && preg_match('/fat|mot|par/', $relationships[$n - 2])) { $table[$x + 1][$y - 1] = '
' . Functions::getRelationshipNameFromPath($relationships[$n], Individual::getInstance($path[$n - 1], $tree), Individual::getInstance($path[$n + 1], $tree)) . '
' . view('icons/arrow-down') . '
'; $x += 2; } else { $table[$x][$y - 1] = '
' . Functions::getRelationshipNameFromPath($relationships[$n], Individual::getInstance($path[$n - 1], $tree), Individual::getInstance($path[$n + 1], $tree)) . '
' . view('icons/arrow-down') . '
'; } $y -= 2; break; case 'fat': case 'mot': case 'par': if ($n > 2 && preg_match('/son|dau|chi/', $relationships[$n - 2])) { $table[$x + 1][$y + 1] = '
' . Functions::getRelationshipNameFromPath($relationships[$n], Individual::getInstance($path[$n - 1], $tree), Individual::getInstance($path[$n + 1], $tree)) . '
' . view('icons/arrow-down') . '
'; $x += 2; } else { $table[$x][$y + 1] = '
' . Functions::getRelationshipNameFromPath($relationships[$n], Individual::getInstance($path[$n - 1], $tree), Individual::getInstance($path[$n + 1], $tree)) . '
' . view('icons/arrow-up') . '
'; } $y += 2; break; } $max_x = max($max_x, $x); $min_y = min($min_y, $y); $max_y = max($max_y, $y); } else { $individual = Individual::getInstance($xref, $tree); $table[$x][$y] = FunctionsPrint::printPedigreePerson($individual); } } echo '
'; echo ''; for ($y = $max_y; $y >= $min_y; --$y) { echo ''; for ($x = 0; $x <= $max_x; ++$x) { echo ''; } echo ''; } echo '
'; if (isset($table[$x][$y])) { echo $table[$x][$y]; } echo '
'; echo '
'; } if (!$num_paths) { echo '

', I18N::translate('No link between the two individuals could be found.'), '

'; } $html = ob_get_clean(); return new Response($html); } /** * Calculate the shortest paths - or all paths - between two individuals. * * @param Individual $individual1 * @param Individual $individual2 * @param int $recursion How many levels of recursion to use * @param bool $ancestor Restrict to relationships via a common ancestor * * @return string[][] */ private function calculateRelationships(Individual $individual1, Individual $individual2, $recursion, $ancestor = false): array { $tree = $individual1->tree(); $rows = DB::table('link') ->where('l_file', '=', $tree->id()) ->whereIn('l_type', ['FAMS', 'FAMC']) ->select(['l_from', 'l_to']) ->get(); // Optionally restrict the graph to the ancestors of the individuals. if ($ancestor) { $ancestors = $this->allAncestors($individual1->xref(), $individual2->xref(), $tree->id()); $exclude = $this->excludeFamilies($individual1->xref(), $individual2->xref(), $tree->id()); } else { $ancestors = []; $exclude = []; } $graph = []; foreach ($rows as $row) { if (empty($ancestors) || in_array($row->l_from, $ancestors) && !in_array($row->l_to, $exclude)) { $graph[$row->l_from][$row->l_to] = 1; $graph[$row->l_to][$row->l_from] = 1; } } $xref1 = $individual1->xref(); $xref2 = $individual2->xref(); $dijkstra = new Dijkstra($graph); $paths = $dijkstra->shortestPaths($xref1, $xref2); // Only process each exclusion list once; $excluded = []; $queue = []; foreach ($paths as $path) { // Insert the paths into the queue, with an exclusion list. $queue[] = [ 'path' => $path, 'exclude' => [], ]; // While there are un-extended paths for ($next = current($queue); $next !== false; $next = next($queue)) { // For each family on the path for ($n = count($next['path']) - 2; $n >= 1; $n -= 2) { $exclude = $next['exclude']; if (count($exclude) >= $recursion) { continue; } $exclude[] = $next['path'][$n]; sort($exclude); $tmp = implode('-', $exclude); if (in_array($tmp, $excluded)) { continue; } $excluded[] = $tmp; // Add any new path to the queue foreach ($dijkstra->shortestPaths($xref1, $xref2, $exclude) as $new_path) { $queue[] = [ 'path' => $new_path, 'exclude' => $exclude, ]; } } } } // Extract the paths from the queue, removing duplicates. $paths = []; foreach ($queue as $next) { $paths[implode('-', $next['path'])] = $next['path']; } return $paths; } /** * Convert a path (list of XREFs) to an "old-style" string of relationships. * Return an empty array, if privacy rules prevent us viewing any node. * * @param Tree $tree * @param string[] $path Alternately Individual / Family * * @return string[] */ private function oldStyleRelationshipPath(Tree $tree, array $path): array { $spouse_codes = [ 'M' => 'hus', 'F' => 'wif', 'U' => 'spo', ]; $parent_codes = [ 'M' => 'fat', 'F' => 'mot', 'U' => 'par', ]; $child_codes = [ 'M' => 'son', 'F' => 'dau', 'U' => 'chi', ]; $sibling_codes = [ 'M' => 'bro', 'F' => 'sis', 'U' => 'sib', ]; $relationships = []; for ($i = 1, $count = count($path); $i < $count; $i += 2) { $family = Family::getInstance($path[$i], $tree); $prev = Individual::getInstance($path[$i - 1], $tree); $next = Individual::getInstance($path[$i + 1], $tree); if (preg_match('/\n\d (HUSB|WIFE|CHIL) @' . $prev->xref() . '@/', $family->gedcom(), $match)) { $rel1 = $match[1]; } else { return []; } if (preg_match('/\n\d (HUSB|WIFE|CHIL) @' . $next->xref() . '@/', $family->gedcom(), $match)) { $rel2 = $match[1]; } else { return []; } if (($rel1 === 'HUSB' || $rel1 === 'WIFE') && ($rel2 === 'HUSB' || $rel2 === 'WIFE')) { $relationships[$i] = $spouse_codes[$next->getSex()]; } elseif (($rel1 === 'HUSB' || $rel1 === 'WIFE') && $rel2 === 'CHIL') { $relationships[$i] = $child_codes[$next->getSex()]; } elseif ($rel1 === 'CHIL' && ($rel2 === 'HUSB' || $rel2 === 'WIFE')) { $relationships[$i] = $parent_codes[$next->getSex()]; } elseif ($rel1 === 'CHIL' && $rel2 === 'CHIL') { $relationships[$i] = $sibling_codes[$next->getSex()]; } } return $relationships; } /** * Find all ancestors of a list of individuals * * @param string $xref1 * @param string $xref2 * @param int $tree_id * * @return string[] */ private function allAncestors($xref1, $xref2, $tree_id): array { $ancestors = [ $xref1, $xref2, ]; $queue = [ $xref1, $xref2, ]; while (!empty($queue)) { $parents = DB::table('link AS l1') ->join('link AS l2', function (JoinClause $join): void { $join ->on('l1.l_to', '=', 'l2.l_to') ->on('l1.l_file', '=', 'l2.l_file'); }) ->where('l1.l_file', '=', $tree_id) ->where('l1.l_type', '=', 'FAMC') ->where('l2.l_type', '=', 'FAMS') ->whereIn('l1.l_from', $queue) ->pluck('l2.l_from'); $queue = []; foreach ($parents as $parent) { if (!in_array($parent, $ancestors)) { $ancestors[] = $parent; $queue[] = $parent; } } } return $ancestors; } /** * Find all families of two individuals * * @param string $xref1 * @param string $xref2 * @param int $tree_id * * @return string[] */ private function excludeFamilies($xref1, $xref2, $tree_id): array { return DB::table('link AS l1') ->join('link AS l2', function (JoinClause $join): void { $join ->on('l1.l_to', '=', 'l2.l_to') ->on('l1.l_type', '=', 'l2.l_type') ->on('l1.l_file', '=', 'l2.l_file'); }) ->where('l1.l_file', '=', $tree_id) ->where('l1.l_type', '=', 'FAMS') ->where('l1.l_from', '=', $xref1) ->where('l2.l_from', '=', $xref2) ->pluck('l1.l_to') ->all(); } /** * Possible options for the recursion option * * @param int $max_recursion * * @return array */ private function recursionOptions(int $max_recursion): array { if ($max_recursion === static::UNLIMITED_RECURSION) { $text = I18N::translate('Find all possible relationships'); } else { $text = I18N::translate('Find other relationships'); } return [ '0' => I18N::translate('Find the closest relationships'), $max_recursion => $text, ]; } }