1168ff6f3Sric2016<?php 23976b470SGreg Roach 3168ff6f3Sric2016/** 4168ff6f3Sric2016 * webtrees: online genealogy 55bfc6897SGreg Roach * Copyright (C) 2022 webtrees development team 6168ff6f3Sric2016 * This program is free software: you can redistribute it and/or modify 7168ff6f3Sric2016 * it under the terms of the GNU General Public License as published by 8168ff6f3Sric2016 * the Free Software Foundation, either version 3 of the License, or 9168ff6f3Sric2016 * (at your option) any later version. 10168ff6f3Sric2016 * This program is distributed in the hope that it will be useful, 11168ff6f3Sric2016 * but WITHOUT ANY WARRANTY; without even the implied warranty of 12168ff6f3Sric2016 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the 13168ff6f3Sric2016 * GNU General Public License for more details. 14168ff6f3Sric2016 * You should have received a copy of the GNU General Public License 1589f7189bSGreg Roach * along with this program. If not, see <https://www.gnu.org/licenses/>. 16168ff6f3Sric2016 */ 17fcfa147eSGreg Roach 18e7f56f2aSGreg Roachdeclare(strict_types=1); 19e7f56f2aSGreg Roach 20168ff6f3Sric2016namespace Fisharebest\Webtrees\Module; 21168ff6f3Sric2016 223cfcc809SGreg Roachuse Aura\Router\RouterContainer; 23185cbb4dSGreg Roachuse Closure; 243cfcc809SGreg Roachuse Fig\Http\Message\RequestMethodInterface; 259b5537c3SGreg Roachuse Fisharebest\Algorithm\Dijkstra; 26168ff6f3Sric2016use Fisharebest\Webtrees\Auth; 271fe542e9SGreg Roachuse Fisharebest\Webtrees\Contracts\UserInterface; 2845ac604bSGreg Roachuse Fisharebest\Webtrees\FlashMessages; 296fcafd02SGreg Roachuse Fisharebest\Webtrees\GedcomRecord; 30168ff6f3Sric2016use Fisharebest\Webtrees\I18N; 31168ff6f3Sric2016use Fisharebest\Webtrees\Individual; 321e3273c9SGreg Roachuse Fisharebest\Webtrees\Menu; 336fcafd02SGreg Roachuse Fisharebest\Webtrees\Registry; 346fcafd02SGreg Roachuse Fisharebest\Webtrees\Services\ModuleService; 356fcafd02SGreg Roachuse Fisharebest\Webtrees\Services\RelationshipService; 363df1e584SGreg Roachuse Fisharebest\Webtrees\Services\TreeService; 3745ac604bSGreg Roachuse Fisharebest\Webtrees\Tree; 38b55cbc6bSGreg Roachuse Fisharebest\Webtrees\Validator; 399b5537c3SGreg Roachuse Illuminate\Database\Capsule\Manager as DB; 409b5537c3SGreg Roachuse Illuminate\Database\Query\JoinClause; 416fcafd02SGreg Roachuse Illuminate\Support\Collection; 426ccdf4f0SGreg Roachuse Psr\Http\Message\ResponseInterface; 436ccdf4f0SGreg Roachuse Psr\Http\Message\ServerRequestInterface; 443cfcc809SGreg Roachuse Psr\Http\Server\RequestHandlerInterface; 453976b470SGreg Roach 469e18e23bSGreg Roachuse function app; 479e18e23bSGreg Roachuse function assert; 483cfcc809SGreg Roachuse function redirect; 493cfcc809SGreg Roachuse function route; 50f4ba05e3SGreg Roachuse function view; 51168ff6f3Sric2016 52168ff6f3Sric2016/** 53168ff6f3Sric2016 * Class RelationshipsChartModule 54168ff6f3Sric2016 */ 557a1b7425SGreg Roachclass RelationshipsChartModule extends AbstractModule implements ModuleChartInterface, ModuleConfigInterface, RequestHandlerInterface 56c1010edaSGreg Roach{ 5749a243cbSGreg Roach use ModuleChartTrait; 5849a243cbSGreg Roach use ModuleConfigTrait; 5949a243cbSGreg Roach 6072f04adfSGreg Roach protected const ROUTE_URL = '/tree/{tree}/relationships-{ancestors}-{recursion}/{xref}{/xref2}'; 613cfcc809SGreg Roach 621e3273c9SGreg Roach /** It would be more correct to use PHP_INT_MAX, but this isn't friendly in URLs */ 6316d6367aSGreg Roach public const UNLIMITED_RECURSION = 99; 641e3273c9SGreg Roach 651e3273c9SGreg Roach /** By default new trees allow unlimited recursion */ 6616d6367aSGreg Roach public const DEFAULT_RECURSION = '99'; 6745ac604bSGreg Roach 68e0bd7dc9SGreg Roach /** By default new trees search for all relationships (not via ancestors) */ 6916d6367aSGreg Roach public const DEFAULT_ANCESTORS = '0'; 703cfcc809SGreg Roach public const DEFAULT_PARAMETERS = [ 713cfcc809SGreg Roach 'ancestors' => self::DEFAULT_ANCESTORS, 723cfcc809SGreg Roach 'recursion' => self::DEFAULT_RECURSION, 733cfcc809SGreg Roach ]; 743cfcc809SGreg Roach 75b55cbc6bSGreg Roach private ModuleService $module_service; 76b55cbc6bSGreg Roach 776fcafd02SGreg Roach private TreeService $tree_service; 786fcafd02SGreg Roach 796fcafd02SGreg Roach private RelationshipService $relationship_service; 803df1e584SGreg Roach 813df1e584SGreg Roach /** 82b55cbc6bSGreg Roach * @param ModuleService $module_service 836fcafd02SGreg Roach * @param RelationshipService $relationship_service 843df1e584SGreg Roach * @param TreeService $tree_service 853df1e584SGreg Roach */ 86b55cbc6bSGreg Roach public function __construct(ModuleService $module_service, RelationshipService $relationship_service, TreeService $tree_service) 873df1e584SGreg Roach { 88b55cbc6bSGreg Roach $this->module_service = $module_service; 896fcafd02SGreg Roach $this->relationship_service = $relationship_service; 903df1e584SGreg Roach $this->tree_service = $tree_service; 913df1e584SGreg Roach } 923df1e584SGreg Roach 933cfcc809SGreg Roach /** 943cfcc809SGreg Roach * Initialization. 953cfcc809SGreg Roach * 969e18e23bSGreg Roach * @return void 973cfcc809SGreg Roach */ 989e18e23bSGreg Roach public function boot(): void 993cfcc809SGreg Roach { 100158900c2SGreg Roach Registry::routeFactory()->routeMap() 10172f04adfSGreg Roach ->get(static::class, static::ROUTE_URL, $this) 1023cfcc809SGreg Roach ->allows(RequestMethodInterface::METHOD_POST) 1033cfcc809SGreg Roach ->tokens([ 1043cfcc809SGreg Roach 'ancestors' => '\d+', 1053cfcc809SGreg Roach 'recursion' => '\d+', 1063cfcc809SGreg Roach ]); 1073cfcc809SGreg Roach } 108e0bd7dc9SGreg Roach 109168ff6f3Sric2016 /** 110168ff6f3Sric2016 * A sentence describing what this module does. 111168ff6f3Sric2016 * 112168ff6f3Sric2016 * @return string 113168ff6f3Sric2016 */ 11449a243cbSGreg Roach public function description(): string 115c1010edaSGreg Roach { 116bbb76c12SGreg Roach /* I18N: Description of the “RelationshipsChart” module */ 117bbb76c12SGreg Roach return I18N::translate('A chart displaying relationships between two individuals.'); 118168ff6f3Sric2016 } 119168ff6f3Sric2016 120168ff6f3Sric2016 /** 1216ccdf4f0SGreg Roach * Return a menu item for this chart - for use in individual boxes. 1226ccdf4f0SGreg Roach * 1236ccdf4f0SGreg Roach * @param Individual $individual 1246ccdf4f0SGreg Roach * 1256ccdf4f0SGreg Roach * @return Menu|null 1266ccdf4f0SGreg Roach */ 1276ccdf4f0SGreg Roach public function chartBoxMenu(Individual $individual): ?Menu 1286ccdf4f0SGreg Roach { 1296ccdf4f0SGreg Roach return $this->chartMenu($individual); 1306ccdf4f0SGreg Roach } 1316ccdf4f0SGreg Roach 1326ccdf4f0SGreg Roach /** 133e6562982SGreg Roach * A main menu item for this chart. 134168ff6f3Sric2016 * 1358e69695bSGreg Roach * @param Individual $individual 1368e69695bSGreg Roach * 137e6562982SGreg Roach * @return Menu 138168ff6f3Sric2016 */ 139e6562982SGreg Roach public function chartMenu(Individual $individual): Menu 140c1010edaSGreg Roach { 141a0c3c04bSGreg Roach $my_xref = $individual->tree()->getUserPreference(Auth::user(), UserInterface::PREF_TREE_ACCOUNT_XREF); 142168ff6f3Sric2016 143a0c3c04bSGreg Roach if ($my_xref !== '' && $my_xref !== $individual->xref()) { 144a0c3c04bSGreg Roach $my_record = Registry::individualFactory()->make($my_xref, $individual->tree()); 145a0c3c04bSGreg Roach 1462491533aSGreg Roach if ($my_record instanceof Individual) { 147168ff6f3Sric2016 return new Menu( 148168ff6f3Sric2016 I18N::translate('Relationship to me'), 149a0c3c04bSGreg Roach $this->chartUrl($my_record, ['xref2' => $individual->xref()]), 150377a2979SGreg Roach $this->chartMenuClass(), 151e6562982SGreg Roach $this->chartUrlAttributes() 152168ff6f3Sric2016 ); 153b2ce94c6SRico Sonntag } 1542491533aSGreg Roach } 155b2ce94c6SRico Sonntag 156168ff6f3Sric2016 return new Menu( 157e6562982SGreg Roach $this->title(), 158e6562982SGreg Roach $this->chartUrl($individual), 159377a2979SGreg Roach $this->chartMenuClass(), 160e6562982SGreg Roach $this->chartUrlAttributes() 161168ff6f3Sric2016 ); 162168ff6f3Sric2016 } 163168ff6f3Sric2016 1644eb71cfaSGreg Roach /** 165377a2979SGreg Roach * CSS class for the URL. 166377a2979SGreg Roach * 167377a2979SGreg Roach * @return string 168377a2979SGreg Roach */ 169377a2979SGreg Roach public function chartMenuClass(): string 170377a2979SGreg Roach { 171377a2979SGreg Roach return 'menu-chart-relationship'; 172377a2979SGreg Roach } 173377a2979SGreg Roach 174377a2979SGreg Roach /** 1756ccdf4f0SGreg Roach * How should this module be identified in the control panel, etc.? 1764eb71cfaSGreg Roach * 1776ccdf4f0SGreg Roach * @return string 1784eb71cfaSGreg Roach */ 1796ccdf4f0SGreg Roach public function title(): string 180c1010edaSGreg Roach { 1816ccdf4f0SGreg Roach /* I18N: Name of a module/chart */ 1826ccdf4f0SGreg Roach return I18N::translate('Relationships'); 183e6562982SGreg Roach } 184e6562982SGreg Roach 185e6562982SGreg Roach /** 1863cfcc809SGreg Roach * The URL for a page showing chart options. 18757ab2231SGreg Roach * 1883cfcc809SGreg Roach * @param Individual $individual 18976d39c55SGreg Roach * @param array<bool|int|string|array<string>|null> $parameters 19018d7a90dSGreg Roach * 1913cfcc809SGreg Roach * @return string 192e0bd7dc9SGreg Roach */ 1933cfcc809SGreg Roach public function chartUrl(Individual $individual, array $parameters = []): string 194c1010edaSGreg Roach { 19572f04adfSGreg Roach return route(static::class, [ 1963cfcc809SGreg Roach 'xref' => $individual->xref(), 1973cfcc809SGreg Roach 'tree' => $individual->tree()->name(), 1983cfcc809SGreg Roach ] + $parameters + self::DEFAULT_PARAMETERS); 1991e3273c9SGreg Roach } 2009b5537c3SGreg Roach 2019b5537c3SGreg Roach /** 2026ccdf4f0SGreg Roach * @param ServerRequestInterface $request 2036ccdf4f0SGreg Roach * 2046ccdf4f0SGreg Roach * @return ResponseInterface 2056ccdf4f0SGreg Roach */ 2063cfcc809SGreg Roach public function handle(ServerRequestInterface $request): ResponseInterface 2076ccdf4f0SGreg Roach { 208b55cbc6bSGreg Roach $tree = Validator::attributes($request)->tree(); 209b55cbc6bSGreg Roach $xref = Validator::attributes($request)->isXref()->string('xref'); 210b55cbc6bSGreg Roach $xref2 = Validator::attributes($request)->isXref()->string('xref2', ''); 211b55cbc6bSGreg Roach $ajax = Validator::queryParams($request)->boolean('ajax', false); 2123cfcc809SGreg Roach $ancestors = (int) $request->getAttribute('ancestors'); 2133cfcc809SGreg Roach $recursion = (int) $request->getAttribute('recursion'); 214b55cbc6bSGreg Roach $user = Validator::attributes($request)->user(); 2159b5537c3SGreg Roach 2163cfcc809SGreg Roach // Convert POST requests into GET requests for pretty URLs. 2173cfcc809SGreg Roach if ($request->getMethod() === RequestMethodInterface::METHOD_POST) { 21872f04adfSGreg Roach return redirect(route(static::class, [ 2194ea62551SGreg Roach 'tree' => $tree->name(), 220b55cbc6bSGreg Roach 'ancestors' => Validator::parsedBody($request)->string('ancestors', ''), 221b55cbc6bSGreg Roach 'recursion' => Validator::parsedBody($request)->string('recursion', ''), 222b55cbc6bSGreg Roach 'xref' => Validator::parsedBody($request)->string('xref', ''), 223b55cbc6bSGreg Roach 'xref2' => Validator::parsedBody($request)->string('xref2', ''), 2243cfcc809SGreg Roach ])); 2253cfcc809SGreg Roach } 2269b5537c3SGreg Roach 2276b9cb339SGreg Roach $individual1 = Registry::individualFactory()->make($xref, $tree); 2286b9cb339SGreg Roach $individual2 = Registry::individualFactory()->make($xref2, $tree); 2299b5537c3SGreg Roach 2303dcc812bSGreg Roach $ancestors_only = (int) $tree->getPreference('RELATIONSHIP_ANCESTORS', static::DEFAULT_ANCESTORS); 2313dcc812bSGreg Roach $max_recursion = (int) $tree->getPreference('RELATIONSHIP_RECURSION', static::DEFAULT_RECURSION); 2329b5537c3SGreg Roach 2339b5537c3SGreg Roach $recursion = min($recursion, $max_recursion); 2349b5537c3SGreg Roach 235b55cbc6bSGreg Roach Auth::checkComponentAccess($this, ModuleChartInterface::class, $tree, $user); 236b55cbc6bSGreg Roach 2373dcc812bSGreg Roach if ($individual1 instanceof Individual) { 2383c3fd0a5SGreg Roach $individual1 = Auth::checkIndividualAccess($individual1, false, true); 2393dcc812bSGreg Roach } 2403dcc812bSGreg Roach 2413dcc812bSGreg Roach if ($individual2 instanceof Individual) { 2423c3fd0a5SGreg Roach $individual2 = Auth::checkIndividualAccess($individual2, false, true); 2438365f910SGreg Roach } 2443dcc812bSGreg Roach 2459b5537c3SGreg Roach if ($individual1 instanceof Individual && $individual2 instanceof Individual) { 246b55cbc6bSGreg Roach if ($ajax) { 247f866a2aeSGreg Roach return $this->chart($individual1, $individual2, $recursion, $ancestors); 248f866a2aeSGreg Roach } 249f866a2aeSGreg Roach 2509b5537c3SGreg Roach /* I18N: %s are individual’s names */ 25139ca88baSGreg Roach $title = I18N::translate('Relationships between %1$s and %2$s', $individual1->fullName(), $individual2->fullName()); 2529b5537c3SGreg Roach $ajax_url = $this->chartUrl($individual1, [ 2539b5537c3SGreg Roach 'ajax' => true, 2549b5537c3SGreg Roach 'ancestors' => $ancestors, 2553cfcc809SGreg Roach 'recursion' => $recursion, 2563cfcc809SGreg Roach 'xref2' => $individual2->xref(), 2579b5537c3SGreg Roach ]); 2583dcc812bSGreg Roach } else { 2593dcc812bSGreg Roach $title = I18N::translate('Relationships'); 260f866a2aeSGreg Roach $ajax_url = ''; 2613dcc812bSGreg Roach } 2629b5537c3SGreg Roach 2639b5537c3SGreg Roach return $this->viewResponse('modules/relationships-chart/page', [ 2649b5537c3SGreg Roach 'ajax_url' => $ajax_url, 2659b5537c3SGreg Roach 'ancestors' => $ancestors, 2669b5537c3SGreg Roach 'ancestors_only' => $ancestors_only, 2679b5537c3SGreg Roach 'ancestors_options' => $this->ancestorsOptions(), 2689b5537c3SGreg Roach 'individual1' => $individual1, 2699b5537c3SGreg Roach 'individual2' => $individual2, 2709b5537c3SGreg Roach 'max_recursion' => $max_recursion, 27171378461SGreg Roach 'module' => $this->name(), 2729b5537c3SGreg Roach 'recursion' => $recursion, 2739b5537c3SGreg Roach 'recursion_options' => $this->recursionOptions($max_recursion), 2749b5537c3SGreg Roach 'title' => $title, 2753cfcc809SGreg Roach 'tree' => $tree, 2769b5537c3SGreg Roach ]); 2779b5537c3SGreg Roach } 2789b5537c3SGreg Roach 2799b5537c3SGreg Roach /** 2803dcc812bSGreg Roach * @param Individual $individual1 2813dcc812bSGreg Roach * @param Individual $individual2 2823dcc812bSGreg Roach * @param int $recursion 2833dcc812bSGreg Roach * @param int $ancestors 2849b5537c3SGreg Roach * 2856ccdf4f0SGreg Roach * @return ResponseInterface 2869b5537c3SGreg Roach */ 2876ccdf4f0SGreg Roach public function chart(Individual $individual1, Individual $individual2, int $recursion, int $ancestors): ResponseInterface 2889b5537c3SGreg Roach { 2893dcc812bSGreg Roach $tree = $individual1->tree(); 2909b5537c3SGreg Roach 2913dcc812bSGreg Roach $max_recursion = (int) $tree->getPreference('RELATIONSHIP_RECURSION', static::DEFAULT_RECURSION); 2929b5537c3SGreg Roach 2939b5537c3SGreg Roach $recursion = min($recursion, $max_recursion); 2949b5537c3SGreg Roach 2959b5537c3SGreg Roach $paths = $this->calculateRelationships($individual1, $individual2, $recursion, (bool) $ancestors); 2969b5537c3SGreg Roach 2979b5537c3SGreg Roach ob_start(); 2989b5537c3SGreg Roach if (I18N::direction() === 'ltr') { 299e837ff07SGreg Roach $diagonal1 = asset('css/images/dline.png'); 300e837ff07SGreg Roach $diagonal2 = asset('css/images/dline2.png'); 3019b5537c3SGreg Roach } else { 302e837ff07SGreg Roach $diagonal1 = asset('css/images/dline2.png'); 303e837ff07SGreg Roach $diagonal2 = asset('css/images/dline.png'); 3049b5537c3SGreg Roach } 3059b5537c3SGreg Roach 3069b5537c3SGreg Roach $num_paths = 0; 3079b5537c3SGreg Roach foreach ($paths as $path) { 3089b5537c3SGreg Roach // Extract the relationship names between pairs of individuals 3099b5537c3SGreg Roach $relationships = $this->oldStyleRelationshipPath($tree, $path); 310075d1a05SGreg Roach if ($relationships === []) { 3119b5537c3SGreg Roach // Cannot see one of the families/individuals, due to privacy; 3129b5537c3SGreg Roach continue; 3139b5537c3SGreg Roach } 3146fcafd02SGreg Roach 3156fcafd02SGreg Roach $nodes = Collection::make($path) 3166fcafd02SGreg Roach ->map(static function (string $xref, int $key) use ($tree): GedcomRecord { 3176fcafd02SGreg Roach if ($key % 2 === 0) { 3186fcafd02SGreg Roach return Registry::individualFactory()->make($xref, $tree); 3196fcafd02SGreg Roach } 3206fcafd02SGreg Roach 3216fcafd02SGreg Roach return Registry::familyFactory()->make($xref, $tree); 3226fcafd02SGreg Roach }); 3236fcafd02SGreg Roach 324b55cbc6bSGreg Roach $language = $this->module_service 3256fcafd02SGreg Roach ->findByInterface(ModuleLanguageInterface::class, true) 3266fcafd02SGreg Roach ->first(fn (ModuleLanguageInterface $language): bool => $language->locale()->languageTag() === I18N::languageTag()); 3276fcafd02SGreg Roach 3286fcafd02SGreg Roach echo '<h3>', I18N::translate('Relationship: %s', $this->relationship_service->nameFromPath($nodes->all(), $language)), '</h3>'; 3299b5537c3SGreg Roach $num_paths++; 3309b5537c3SGreg Roach 3319b5537c3SGreg Roach // Use a table/grid for layout. 3329b5537c3SGreg Roach $table = []; 3339b5537c3SGreg Roach // Current position in the grid. 3349b5537c3SGreg Roach $x = 0; 3359b5537c3SGreg Roach $y = 0; 3369b5537c3SGreg Roach // Extent of the grid. 3379b5537c3SGreg Roach $min_y = 0; 3389b5537c3SGreg Roach $max_y = 0; 3399b5537c3SGreg Roach $max_x = 0; 3409b5537c3SGreg Roach // For each node in the path. 3419b5537c3SGreg Roach foreach ($path as $n => $xref) { 3429b5537c3SGreg Roach if ($n % 2 === 1) { 3439b5537c3SGreg Roach switch ($relationships[$n]) { 3449b5537c3SGreg Roach case 'hus': 3459b5537c3SGreg Roach case 'wif': 3469b5537c3SGreg Roach case 'spo': 3479b5537c3SGreg Roach case 'bro': 3489b5537c3SGreg Roach case 'sis': 3499b5537c3SGreg Roach case 'sib': 350b55cbc6bSGreg Roach $table[$x + 1][$y] = '<div style="background:url(' . e(asset('css/images/hline.png')) . ') repeat-x center; width: 94px; text-align: center"><div class="hline-text" style="height: 32px;">' . $this->relationship_service->legacyNameAlgorithm($relationships[$n], Registry::individualFactory()->make($path[$n - 1], $tree), Registry::individualFactory()->make($path[$n + 1], $tree)) . '</div><div style="height: 32px;">' . view('icons/arrow-right') . '</div></div>'; 3519b5537c3SGreg Roach $x += 2; 3529b5537c3SGreg Roach break; 3539b5537c3SGreg Roach case 'son': 3549b5537c3SGreg Roach case 'dau': 3559b5537c3SGreg Roach case 'chi': 3569b5537c3SGreg Roach if ($n > 2 && preg_match('/fat|mot|par/', $relationships[$n - 2])) { 357b55cbc6bSGreg Roach $table[$x + 1][$y - 1] = '<div style="background:url(' . $diagonal2 . '); width: 64px; height: 64px; text-align: center;"><div style="height: 32px; text-align: end;">' . $this->relationship_service->legacyNameAlgorithm($relationships[$n], Registry::individualFactory()->make($path[$n - 1], $tree), Registry::individualFactory()->make($path[$n + 1], $tree)) . '</div><div style="height: 32px; text-align: start;">' . view('icons/arrow-down') . '</div></div>'; 3589b5537c3SGreg Roach $x += 2; 3599b5537c3SGreg Roach } else { 360b55cbc6bSGreg Roach $table[$x][$y - 1] = '<div style="background:url(' . e('"' . asset('css/images/vline.png') . '"') . ') repeat-y center; height: 64px; text-align: center;"><div class="vline-text" style="display: inline-block; width:50%; line-height: 64px;">' . $this->relationship_service->legacyNameAlgorithm($relationships[$n], Registry::individualFactory()->make($path[$n - 1], $tree), Registry::individualFactory()->make($path[$n + 1], $tree)) . '</div><div style="display: inline-block; width:50%; line-height: 64px;">' . view('icons/arrow-down') . '</div></div>'; 3619b5537c3SGreg Roach } 3629b5537c3SGreg Roach $y -= 2; 3639b5537c3SGreg Roach break; 3649b5537c3SGreg Roach case 'fat': 3659b5537c3SGreg Roach case 'mot': 3669b5537c3SGreg Roach case 'par': 3679b5537c3SGreg Roach if ($n > 2 && preg_match('/son|dau|chi/', $relationships[$n - 2])) { 368b55cbc6bSGreg Roach $table[$x + 1][$y + 1] = '<div style="background:url(' . $diagonal1 . '); background-position: top right; width: 64px; height: 64px; text-align: center;"><div style="height: 32px; text-align: start;">' . $this->relationship_service->legacyNameAlgorithm($relationships[$n], Registry::individualFactory()->make($path[$n - 1], $tree), Registry::individualFactory()->make($path[$n + 1], $tree)) . '</div><div style="height: 32px; text-align: end;">' . view('icons/arrow-down') . '</div></div>'; 3699b5537c3SGreg Roach $x += 2; 3709b5537c3SGreg Roach } else { 371b55cbc6bSGreg Roach $table[$x][$y + 1] = '<div style="background:url(' . e('"' . asset('css/images/vline.png') . '"') . ') repeat-y center; height: 64px; text-align:center; "><div class="vline-text" style="display: inline-block; width: 50%; line-height: 64px;">' . $this->relationship_service->legacyNameAlgorithm($relationships[$n], Registry::individualFactory()->make($path[$n - 1], $tree), Registry::individualFactory()->make($path[$n + 1], $tree)) . '</div><div style="display: inline-block; width: 50%; line-height: 32px">' . view('icons/arrow-up') . '</div></div>'; 3729b5537c3SGreg Roach } 3739b5537c3SGreg Roach $y += 2; 3749b5537c3SGreg Roach break; 3759b5537c3SGreg Roach } 3769b5537c3SGreg Roach $max_x = max($max_x, $x); 3779b5537c3SGreg Roach $min_y = min($min_y, $y); 3789b5537c3SGreg Roach $max_y = max($max_y, $y); 3799b5537c3SGreg Roach } else { 3806b9cb339SGreg Roach $individual = Registry::individualFactory()->make($xref, $tree); 381f4ba05e3SGreg Roach $table[$x][$y] = view('chart-box', ['individual' => $individual]); 3829b5537c3SGreg Roach } 3839b5537c3SGreg Roach } 3844a2590a5SGreg Roach echo '<div class="wt-chart wt-chart-relationships">'; 3859b5537c3SGreg Roach echo '<table style="border-collapse: collapse; margin: 20px 50px;">'; 3869b5537c3SGreg Roach for ($y = $max_y; $y >= $min_y; --$y) { 3879b5537c3SGreg Roach echo '<tr>'; 3889b5537c3SGreg Roach for ($x = 0; $x <= $max_x; ++$x) { 3899b5537c3SGreg Roach echo '<td style="padding: 0;">'; 3909b5537c3SGreg Roach if (isset($table[$x][$y])) { 3919b5537c3SGreg Roach echo $table[$x][$y]; 3929b5537c3SGreg Roach } 3939b5537c3SGreg Roach echo '</td>'; 3949b5537c3SGreg Roach } 3959b5537c3SGreg Roach echo '</tr>'; 3969b5537c3SGreg Roach } 3979b5537c3SGreg Roach echo '</table>'; 3989b5537c3SGreg Roach echo '</div>'; 3999b5537c3SGreg Roach } 4009b5537c3SGreg Roach 4019b5537c3SGreg Roach if (!$num_paths) { 4029b5537c3SGreg Roach echo '<p>', I18N::translate('No link between the two individuals could be found.'), '</p>'; 4039b5537c3SGreg Roach } 4049b5537c3SGreg Roach 4059b5537c3SGreg Roach $html = ob_get_clean(); 4069b5537c3SGreg Roach 4076ccdf4f0SGreg Roach return response($html); 4089b5537c3SGreg Roach } 4099b5537c3SGreg Roach 4109b5537c3SGreg Roach /** 4113cfcc809SGreg Roach * @param ServerRequestInterface $request 4123cfcc809SGreg Roach * 4133cfcc809SGreg Roach * @return ResponseInterface 4143cfcc809SGreg Roach */ 4153cfcc809SGreg Roach public function getAdminAction(ServerRequestInterface $request): ResponseInterface 4163cfcc809SGreg Roach { 4173cfcc809SGreg Roach $this->layout = 'layouts/administration'; 4183cfcc809SGreg Roach 4193cfcc809SGreg Roach return $this->viewResponse('modules/relationships-chart/config', [ 4203df1e584SGreg Roach 'all_trees' => $this->tree_service->all(), 4213cfcc809SGreg Roach 'ancestors_options' => $this->ancestorsOptions(), 4223cfcc809SGreg Roach 'default_ancestors' => self::DEFAULT_ANCESTORS, 4233cfcc809SGreg Roach 'default_recursion' => self::DEFAULT_RECURSION, 4243cfcc809SGreg Roach 'recursion_options' => $this->recursionConfigOptions(), 4253cfcc809SGreg Roach 'title' => I18N::translate('Chart preferences') . ' — ' . $this->title(), 4263cfcc809SGreg Roach ]); 4273cfcc809SGreg Roach } 4283cfcc809SGreg Roach 4293cfcc809SGreg Roach /** 4303cfcc809SGreg Roach * @param ServerRequestInterface $request 4313cfcc809SGreg Roach * 4323cfcc809SGreg Roach * @return ResponseInterface 4333cfcc809SGreg Roach */ 4343cfcc809SGreg Roach public function postAdminAction(ServerRequestInterface $request): ResponseInterface 4353cfcc809SGreg Roach { 436b46c87bdSGreg Roach $params = (array) $request->getParsedBody(); 437b46c87bdSGreg Roach 4383df1e584SGreg Roach foreach ($this->tree_service->all() as $tree) { 439b46c87bdSGreg Roach $recursion = $params['relationship-recursion-' . $tree->id()] ?? ''; 440b46c87bdSGreg Roach $ancestors = $params['relationship-ancestors-' . $tree->id()] ?? ''; 4413cfcc809SGreg Roach 4423cfcc809SGreg Roach $tree->setPreference('RELATIONSHIP_RECURSION', $recursion); 4433cfcc809SGreg Roach $tree->setPreference('RELATIONSHIP_ANCESTORS', $ancestors); 4443cfcc809SGreg Roach } 4453cfcc809SGreg Roach 4463cfcc809SGreg Roach FlashMessages::addMessage(I18N::translate('The preferences for the module “%s” have been updated.', $this->title()), 'success'); 4473cfcc809SGreg Roach 4483cfcc809SGreg Roach return redirect($this->getConfigLink()); 4493cfcc809SGreg Roach } 4503cfcc809SGreg Roach 4513cfcc809SGreg Roach /** 4523cfcc809SGreg Roach * Possible options for the ancestors option 4533cfcc809SGreg Roach * 4547c2c99faSGreg Roach * @return array<int,string> 4553cfcc809SGreg Roach */ 4563cfcc809SGreg Roach private function ancestorsOptions(): array 4573cfcc809SGreg Roach { 4583cfcc809SGreg Roach return [ 4593cfcc809SGreg Roach 0 => I18N::translate('Find any relationship'), 4603cfcc809SGreg Roach 1 => I18N::translate('Find relationships via ancestors'), 4613cfcc809SGreg Roach ]; 4623cfcc809SGreg Roach } 4633cfcc809SGreg Roach 4643cfcc809SGreg Roach /** 4653cfcc809SGreg Roach * Possible options for the recursion option 4663cfcc809SGreg Roach * 4677c2c99faSGreg Roach * @return array<int,string> 4683cfcc809SGreg Roach */ 4693cfcc809SGreg Roach private function recursionConfigOptions(): array 4703cfcc809SGreg Roach { 4713cfcc809SGreg Roach return [ 4723cfcc809SGreg Roach 0 => I18N::translate('none'), 4733cfcc809SGreg Roach 1 => I18N::number(1), 4743cfcc809SGreg Roach 2 => I18N::number(2), 4753cfcc809SGreg Roach 3 => I18N::number(3), 4763cfcc809SGreg Roach self::UNLIMITED_RECURSION => I18N::translate('unlimited'), 4773cfcc809SGreg Roach ]; 4783cfcc809SGreg Roach } 4793cfcc809SGreg Roach 4803cfcc809SGreg Roach /** 4819b5537c3SGreg Roach * Calculate the shortest paths - or all paths - between two individuals. 4829b5537c3SGreg Roach * 4839b5537c3SGreg Roach * @param Individual $individual1 4849b5537c3SGreg Roach * @param Individual $individual2 4859b5537c3SGreg Roach * @param int $recursion How many levels of recursion to use 4869b5537c3SGreg Roach * @param bool $ancestor Restrict to relationships via a common ancestor 4879b5537c3SGreg Roach * 48824f2a3afSGreg Roach * @return array<array<string>> 4899b5537c3SGreg Roach */ 49024f2a3afSGreg Roach private function calculateRelationships( 49124f2a3afSGreg Roach Individual $individual1, 49224f2a3afSGreg Roach Individual $individual2, 49324f2a3afSGreg Roach int $recursion, 49424f2a3afSGreg Roach bool $ancestor = false 49524f2a3afSGreg Roach ): array { 4963dcc812bSGreg Roach $tree = $individual1->tree(); 4973dcc812bSGreg Roach 4989b5537c3SGreg Roach $rows = DB::table('link') 4993dcc812bSGreg Roach ->where('l_file', '=', $tree->id()) 5009b5537c3SGreg Roach ->whereIn('l_type', ['FAMS', 'FAMC']) 5019b5537c3SGreg Roach ->select(['l_from', 'l_to']) 5029b5537c3SGreg Roach ->get(); 5039b5537c3SGreg Roach 5049b5537c3SGreg Roach // Optionally restrict the graph to the ancestors of the individuals. 5059b5537c3SGreg Roach if ($ancestor) { 5063dcc812bSGreg Roach $ancestors = $this->allAncestors($individual1->xref(), $individual2->xref(), $tree->id()); 5073dcc812bSGreg Roach $exclude = $this->excludeFamilies($individual1->xref(), $individual2->xref(), $tree->id()); 5089b5537c3SGreg Roach } else { 5099b5537c3SGreg Roach $ancestors = []; 5109b5537c3SGreg Roach $exclude = []; 5119b5537c3SGreg Roach } 5129b5537c3SGreg Roach 5139b5537c3SGreg Roach $graph = []; 5149b5537c3SGreg Roach 5159b5537c3SGreg Roach foreach ($rows as $row) { 516075d1a05SGreg Roach if ($ancestors === [] || in_array($row->l_from, $ancestors, true) && !in_array($row->l_to, $exclude, true)) { 5179b5537c3SGreg Roach $graph[$row->l_from][$row->l_to] = 1; 5189b5537c3SGreg Roach $graph[$row->l_to][$row->l_from] = 1; 5199b5537c3SGreg Roach } 5209b5537c3SGreg Roach } 5219b5537c3SGreg Roach 5229b5537c3SGreg Roach $xref1 = $individual1->xref(); 5239b5537c3SGreg Roach $xref2 = $individual2->xref(); 5249b5537c3SGreg Roach $dijkstra = new Dijkstra($graph); 5259b5537c3SGreg Roach $paths = $dijkstra->shortestPaths($xref1, $xref2); 5269b5537c3SGreg Roach 5279b5537c3SGreg Roach // Only process each exclusion list once; 5289b5537c3SGreg Roach $excluded = []; 5299b5537c3SGreg Roach 5309b5537c3SGreg Roach $queue = []; 5319b5537c3SGreg Roach foreach ($paths as $path) { 5329b5537c3SGreg Roach // Insert the paths into the queue, with an exclusion list. 5339b5537c3SGreg Roach $queue[] = [ 5349b5537c3SGreg Roach 'path' => $path, 5359b5537c3SGreg Roach 'exclude' => [], 5369b5537c3SGreg Roach ]; 5379b5537c3SGreg Roach // While there are un-extended paths 5389b5537c3SGreg Roach for ($next = current($queue); $next !== false; $next = next($queue)) { 5399b5537c3SGreg Roach // For each family on the path 5409b5537c3SGreg Roach for ($n = count($next['path']) - 2; $n >= 1; $n -= 2) { 5419b5537c3SGreg Roach $exclude = $next['exclude']; 5429b5537c3SGreg Roach if (count($exclude) >= $recursion) { 5439b5537c3SGreg Roach continue; 5449b5537c3SGreg Roach } 5459b5537c3SGreg Roach $exclude[] = $next['path'][$n]; 5469b5537c3SGreg Roach sort($exclude); 5479b5537c3SGreg Roach $tmp = implode('-', $exclude); 54822d65e5aSGreg Roach if (in_array($tmp, $excluded, true)) { 5499b5537c3SGreg Roach continue; 5509b5537c3SGreg Roach } 5519b5537c3SGreg Roach 5529b5537c3SGreg Roach $excluded[] = $tmp; 5539b5537c3SGreg Roach // Add any new path to the queue 5549b5537c3SGreg Roach foreach ($dijkstra->shortestPaths($xref1, $xref2, $exclude) as $new_path) { 5559b5537c3SGreg Roach $queue[] = [ 5569b5537c3SGreg Roach 'path' => $new_path, 5579b5537c3SGreg Roach 'exclude' => $exclude, 5589b5537c3SGreg Roach ]; 5599b5537c3SGreg Roach } 5609b5537c3SGreg Roach } 5619b5537c3SGreg Roach } 5629b5537c3SGreg Roach } 563185cbb4dSGreg Roach // Extract the paths from the queue. 5649b5537c3SGreg Roach $paths = []; 5659b5537c3SGreg Roach foreach ($queue as $next) { 566185cbb4dSGreg Roach // The Dijkstra library does not use strict types, and converts 567185cbb4dSGreg Roach // numeric array keys (XREFs) from strings to integers; 568185cbb4dSGreg Roach $path = array_map($this->stringMapper(), $next['path']); 569185cbb4dSGreg Roach 570185cbb4dSGreg Roach // Remove duplicates 571185cbb4dSGreg Roach $paths[implode('-', $next['path'])] = $path; 5729b5537c3SGreg Roach } 5739b5537c3SGreg Roach 5749b5537c3SGreg Roach return $paths; 5759b5537c3SGreg Roach } 5769b5537c3SGreg Roach 5779b5537c3SGreg Roach /** 578185cbb4dSGreg Roach * Convert numeric values to strings 579185cbb4dSGreg Roach * 580185cbb4dSGreg Roach * @return Closure 581185cbb4dSGreg Roach */ 582c3f3b628SGreg Roach private function stringMapper(): Closure 583c3f3b628SGreg Roach { 584185cbb4dSGreg Roach return static function ($xref) { 585185cbb4dSGreg Roach return (string) $xref; 586185cbb4dSGreg Roach }; 587185cbb4dSGreg Roach } 588185cbb4dSGreg Roach 589185cbb4dSGreg Roach /** 5909b5537c3SGreg Roach * Find all ancestors of a list of individuals 5919b5537c3SGreg Roach * 5929b5537c3SGreg Roach * @param string $xref1 5939b5537c3SGreg Roach * @param string $xref2 5949b5537c3SGreg Roach * @param int $tree_id 5959b5537c3SGreg Roach * 59624f2a3afSGreg Roach * @return array<string> 5979b5537c3SGreg Roach */ 59824f2a3afSGreg Roach private function allAncestors(string $xref1, string $xref2, int $tree_id): array 5999b5537c3SGreg Roach { 6009b5537c3SGreg Roach $ancestors = [ 6019b5537c3SGreg Roach $xref1, 6029b5537c3SGreg Roach $xref2, 6039b5537c3SGreg Roach ]; 6049b5537c3SGreg Roach 6059b5537c3SGreg Roach $queue = [ 6069b5537c3SGreg Roach $xref1, 6079b5537c3SGreg Roach $xref2, 6089b5537c3SGreg Roach ]; 609075d1a05SGreg Roach while ($queue !== []) { 6109b5537c3SGreg Roach $parents = DB::table('link AS l1') 6110b5fd0a6SGreg Roach ->join('link AS l2', static function (JoinClause $join): void { 6129b5537c3SGreg Roach $join 6139b5537c3SGreg Roach ->on('l1.l_to', '=', 'l2.l_to') 6149b5537c3SGreg Roach ->on('l1.l_file', '=', 'l2.l_file'); 6159b5537c3SGreg Roach }) 6169b5537c3SGreg Roach ->where('l1.l_file', '=', $tree_id) 6179b5537c3SGreg Roach ->where('l1.l_type', '=', 'FAMC') 6189b5537c3SGreg Roach ->where('l2.l_type', '=', 'FAMS') 6199b5537c3SGreg Roach ->whereIn('l1.l_from', $queue) 6209b5537c3SGreg Roach ->pluck('l2.l_from'); 6219b5537c3SGreg Roach 6229b5537c3SGreg Roach $queue = []; 6239b5537c3SGreg Roach foreach ($parents as $parent) { 62422d65e5aSGreg Roach if (!in_array($parent, $ancestors, true)) { 6259b5537c3SGreg Roach $ancestors[] = $parent; 6269b5537c3SGreg Roach $queue[] = $parent; 6279b5537c3SGreg Roach } 6289b5537c3SGreg Roach } 6299b5537c3SGreg Roach } 6309b5537c3SGreg Roach 6319b5537c3SGreg Roach return $ancestors; 6329b5537c3SGreg Roach } 6339b5537c3SGreg Roach 6349b5537c3SGreg Roach /** 6359b5537c3SGreg Roach * Find all families of two individuals 6369b5537c3SGreg Roach * 6379b5537c3SGreg Roach * @param string $xref1 6389b5537c3SGreg Roach * @param string $xref2 6399b5537c3SGreg Roach * @param int $tree_id 6409b5537c3SGreg Roach * 64124f2a3afSGreg Roach * @return array<string> 6429b5537c3SGreg Roach */ 64324f2a3afSGreg Roach private function excludeFamilies(string $xref1, string $xref2, int $tree_id): array 6449b5537c3SGreg Roach { 6459b5537c3SGreg Roach return DB::table('link AS l1') 6460b5fd0a6SGreg Roach ->join('link AS l2', static function (JoinClause $join): void { 6479b5537c3SGreg Roach $join 6489b5537c3SGreg Roach ->on('l1.l_to', '=', 'l2.l_to') 6499b5537c3SGreg Roach ->on('l1.l_type', '=', 'l2.l_type') 6509b5537c3SGreg Roach ->on('l1.l_file', '=', 'l2.l_file'); 6519b5537c3SGreg Roach }) 6529b5537c3SGreg Roach ->where('l1.l_file', '=', $tree_id) 6539b5537c3SGreg Roach ->where('l1.l_type', '=', 'FAMS') 6549b5537c3SGreg Roach ->where('l1.l_from', '=', $xref1) 6559b5537c3SGreg Roach ->where('l2.l_from', '=', $xref2) 6569b5537c3SGreg Roach ->pluck('l1.l_to') 6579b5537c3SGreg Roach ->all(); 6589b5537c3SGreg Roach } 6599b5537c3SGreg Roach 6609b5537c3SGreg Roach /** 6616ccdf4f0SGreg Roach * Convert a path (list of XREFs) to an "old-style" string of relationships. 6626ccdf4f0SGreg Roach * Return an empty array, if privacy rules prevent us viewing any node. 6636ccdf4f0SGreg Roach * 6646ccdf4f0SGreg Roach * @param Tree $tree 66509482a55SGreg Roach * @param array<string> $path Alternately Individual / Family 6666ccdf4f0SGreg Roach * 66724f2a3afSGreg Roach * @return array<string> 6686ccdf4f0SGreg Roach */ 6696ccdf4f0SGreg Roach private function oldStyleRelationshipPath(Tree $tree, array $path): array 6706ccdf4f0SGreg Roach { 6716ccdf4f0SGreg Roach $spouse_codes = [ 6726ccdf4f0SGreg Roach 'M' => 'hus', 6736ccdf4f0SGreg Roach 'F' => 'wif', 6746ccdf4f0SGreg Roach 'U' => 'spo', 6756ccdf4f0SGreg Roach ]; 6766ccdf4f0SGreg Roach $parent_codes = [ 6776ccdf4f0SGreg Roach 'M' => 'fat', 6786ccdf4f0SGreg Roach 'F' => 'mot', 6796ccdf4f0SGreg Roach 'U' => 'par', 6806ccdf4f0SGreg Roach ]; 6816ccdf4f0SGreg Roach $child_codes = [ 6826ccdf4f0SGreg Roach 'M' => 'son', 6836ccdf4f0SGreg Roach 'F' => 'dau', 6846ccdf4f0SGreg Roach 'U' => 'chi', 6856ccdf4f0SGreg Roach ]; 6866ccdf4f0SGreg Roach $sibling_codes = [ 6876ccdf4f0SGreg Roach 'M' => 'bro', 6886ccdf4f0SGreg Roach 'F' => 'sis', 6896ccdf4f0SGreg Roach 'U' => 'sib', 6906ccdf4f0SGreg Roach ]; 6916ccdf4f0SGreg Roach $relationships = []; 6926ccdf4f0SGreg Roach 6936ccdf4f0SGreg Roach for ($i = 1, $count = count($path); $i < $count; $i += 2) { 6946b9cb339SGreg Roach $family = Registry::familyFactory()->make($path[$i], $tree); 6956b9cb339SGreg Roach $prev = Registry::individualFactory()->make($path[$i - 1], $tree); 6966b9cb339SGreg Roach $next = Registry::individualFactory()->make($path[$i + 1], $tree); 6976ccdf4f0SGreg Roach if (preg_match('/\n\d (HUSB|WIFE|CHIL) @' . $prev->xref() . '@/', $family->gedcom(), $match)) { 6986ccdf4f0SGreg Roach $rel1 = $match[1]; 6996ccdf4f0SGreg Roach } else { 7006ccdf4f0SGreg Roach return []; 7016ccdf4f0SGreg Roach } 7026ccdf4f0SGreg Roach if (preg_match('/\n\d (HUSB|WIFE|CHIL) @' . $next->xref() . '@/', $family->gedcom(), $match)) { 7036ccdf4f0SGreg Roach $rel2 = $match[1]; 7046ccdf4f0SGreg Roach } else { 7056ccdf4f0SGreg Roach return []; 7066ccdf4f0SGreg Roach } 7076ccdf4f0SGreg Roach if (($rel1 === 'HUSB' || $rel1 === 'WIFE') && ($rel2 === 'HUSB' || $rel2 === 'WIFE')) { 708*23a98013SGreg Roach $relationships[$i] = $spouse_codes[$next->sex()] ?? $spouse_codes['U']; 7096ccdf4f0SGreg Roach } elseif (($rel1 === 'HUSB' || $rel1 === 'WIFE') && $rel2 === 'CHIL') { 710*23a98013SGreg Roach $relationships[$i] = $child_codes[$next->sex()] ?? $child_codes['U']; 7116ccdf4f0SGreg Roach } elseif ($rel1 === 'CHIL' && ($rel2 === 'HUSB' || $rel2 === 'WIFE')) { 712*23a98013SGreg Roach $relationships[$i] = $parent_codes[$next->sex()] ?? $parent_codes['U']; 7136ccdf4f0SGreg Roach } elseif ($rel1 === 'CHIL' && $rel2 === 'CHIL') { 714*23a98013SGreg Roach $relationships[$i] = $sibling_codes[$next->sex()] ?? $sibling_codes['U']; 7156ccdf4f0SGreg Roach } 7166ccdf4f0SGreg Roach } 7176ccdf4f0SGreg Roach 7186ccdf4f0SGreg Roach return $relationships; 7196ccdf4f0SGreg Roach } 7206ccdf4f0SGreg Roach 7216ccdf4f0SGreg Roach /** 7229b5537c3SGreg Roach * Possible options for the recursion option 7239b5537c3SGreg Roach * 7249b5537c3SGreg Roach * @param int $max_recursion 7259b5537c3SGreg Roach * 72624f2a3afSGreg Roach * @return array<string> 7279b5537c3SGreg Roach */ 7289b5537c3SGreg Roach private function recursionOptions(int $max_recursion): array 7299b5537c3SGreg Roach { 7303dcc812bSGreg Roach if ($max_recursion === static::UNLIMITED_RECURSION) { 7319b5537c3SGreg Roach $text = I18N::translate('Find all possible relationships'); 7329b5537c3SGreg Roach } else { 7339b5537c3SGreg Roach $text = I18N::translate('Find other relationships'); 7349b5537c3SGreg Roach } 7359b5537c3SGreg Roach 7369b5537c3SGreg Roach return [ 7379b5537c3SGreg Roach '0' => I18N::translate('Find the closest relationships'), 7389b5537c3SGreg Roach $max_recursion => $text, 7399b5537c3SGreg Roach ]; 7409b5537c3SGreg Roach } 741168ff6f3Sric2016} 742