1168ff6f3Sric2016<?php 23976b470SGreg Roach 3168ff6f3Sric2016/** 4168ff6f3Sric2016 * webtrees: online genealogy 51fe542e9SGreg Roach * Copyright (C) 2021 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; 38*b55cbc6bSGreg 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 75*b55cbc6bSGreg Roach private ModuleService $module_service; 76*b55cbc6bSGreg Roach 776fcafd02SGreg Roach private TreeService $tree_service; 786fcafd02SGreg Roach 796fcafd02SGreg Roach private RelationshipService $relationship_service; 803df1e584SGreg Roach 813df1e584SGreg Roach /** 82*b55cbc6bSGreg Roach * @param ModuleService $module_service 836fcafd02SGreg Roach * @param RelationshipService $relationship_service 843df1e584SGreg Roach * @param TreeService $tree_service 853df1e584SGreg Roach */ 86*b55cbc6bSGreg Roach public function __construct(ModuleService $module_service, RelationshipService $relationship_service, TreeService $tree_service) 873df1e584SGreg Roach { 88*b55cbc6bSGreg 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 { 1009e18e23bSGreg Roach $router_container = app(RouterContainer::class); 1019e18e23bSGreg Roach assert($router_container instanceof RouterContainer); 1029e18e23bSGreg Roach 1033cfcc809SGreg Roach $router_container->getMap() 10472f04adfSGreg Roach ->get(static::class, static::ROUTE_URL, $this) 1053cfcc809SGreg Roach ->allows(RequestMethodInterface::METHOD_POST) 1063cfcc809SGreg Roach ->tokens([ 1073cfcc809SGreg Roach 'ancestors' => '\d+', 1083cfcc809SGreg Roach 'recursion' => '\d+', 1093cfcc809SGreg Roach ]); 1103cfcc809SGreg Roach } 111e0bd7dc9SGreg Roach 112168ff6f3Sric2016 /** 113168ff6f3Sric2016 * A sentence describing what this module does. 114168ff6f3Sric2016 * 115168ff6f3Sric2016 * @return string 116168ff6f3Sric2016 */ 11749a243cbSGreg Roach public function description(): string 118c1010edaSGreg Roach { 119bbb76c12SGreg Roach /* I18N: Description of the “RelationshipsChart” module */ 120bbb76c12SGreg Roach return I18N::translate('A chart displaying relationships between two individuals.'); 121168ff6f3Sric2016 } 122168ff6f3Sric2016 123168ff6f3Sric2016 /** 1246ccdf4f0SGreg Roach * Return a menu item for this chart - for use in individual boxes. 1256ccdf4f0SGreg Roach * 1266ccdf4f0SGreg Roach * @param Individual $individual 1276ccdf4f0SGreg Roach * 1286ccdf4f0SGreg Roach * @return Menu|null 1296ccdf4f0SGreg Roach */ 1306ccdf4f0SGreg Roach public function chartBoxMenu(Individual $individual): ?Menu 1316ccdf4f0SGreg Roach { 1326ccdf4f0SGreg Roach return $this->chartMenu($individual); 1336ccdf4f0SGreg Roach } 1346ccdf4f0SGreg Roach 1356ccdf4f0SGreg Roach /** 136e6562982SGreg Roach * A main menu item for this chart. 137168ff6f3Sric2016 * 1388e69695bSGreg Roach * @param Individual $individual 1398e69695bSGreg Roach * 140e6562982SGreg Roach * @return Menu 141168ff6f3Sric2016 */ 142e6562982SGreg Roach public function chartMenu(Individual $individual): Menu 143c1010edaSGreg Roach { 144a0c3c04bSGreg Roach $my_xref = $individual->tree()->getUserPreference(Auth::user(), UserInterface::PREF_TREE_ACCOUNT_XREF); 145168ff6f3Sric2016 146a0c3c04bSGreg Roach if ($my_xref !== '' && $my_xref !== $individual->xref()) { 147a0c3c04bSGreg Roach $my_record = Registry::individualFactory()->make($my_xref, $individual->tree()); 148a0c3c04bSGreg Roach 1492491533aSGreg Roach if ($my_record instanceof Individual) { 150168ff6f3Sric2016 return new Menu( 151168ff6f3Sric2016 I18N::translate('Relationship to me'), 152a0c3c04bSGreg Roach $this->chartUrl($my_record, ['xref2' => $individual->xref()]), 153377a2979SGreg Roach $this->chartMenuClass(), 154e6562982SGreg Roach $this->chartUrlAttributes() 155168ff6f3Sric2016 ); 156b2ce94c6SRico Sonntag } 1572491533aSGreg Roach } 158b2ce94c6SRico Sonntag 159168ff6f3Sric2016 return new Menu( 160e6562982SGreg Roach $this->title(), 161e6562982SGreg Roach $this->chartUrl($individual), 162377a2979SGreg Roach $this->chartMenuClass(), 163e6562982SGreg Roach $this->chartUrlAttributes() 164168ff6f3Sric2016 ); 165168ff6f3Sric2016 } 166168ff6f3Sric2016 1674eb71cfaSGreg Roach /** 168377a2979SGreg Roach * CSS class for the URL. 169377a2979SGreg Roach * 170377a2979SGreg Roach * @return string 171377a2979SGreg Roach */ 172377a2979SGreg Roach public function chartMenuClass(): string 173377a2979SGreg Roach { 174377a2979SGreg Roach return 'menu-chart-relationship'; 175377a2979SGreg Roach } 176377a2979SGreg Roach 177377a2979SGreg Roach /** 1786ccdf4f0SGreg Roach * How should this module be identified in the control panel, etc.? 1794eb71cfaSGreg Roach * 1806ccdf4f0SGreg Roach * @return string 1814eb71cfaSGreg Roach */ 1826ccdf4f0SGreg Roach public function title(): string 183c1010edaSGreg Roach { 1846ccdf4f0SGreg Roach /* I18N: Name of a module/chart */ 1856ccdf4f0SGreg Roach return I18N::translate('Relationships'); 186e6562982SGreg Roach } 187e6562982SGreg Roach 188e6562982SGreg Roach /** 1893cfcc809SGreg Roach * The URL for a page showing chart options. 19057ab2231SGreg Roach * 1913cfcc809SGreg Roach * @param Individual $individual 19276d39c55SGreg Roach * @param array<bool|int|string|array<string>|null> $parameters 19318d7a90dSGreg Roach * 1943cfcc809SGreg Roach * @return string 195e0bd7dc9SGreg Roach */ 1963cfcc809SGreg Roach public function chartUrl(Individual $individual, array $parameters = []): string 197c1010edaSGreg Roach { 19872f04adfSGreg Roach return route(static::class, [ 1993cfcc809SGreg Roach 'xref' => $individual->xref(), 2003cfcc809SGreg Roach 'tree' => $individual->tree()->name(), 2013cfcc809SGreg Roach ] + $parameters + self::DEFAULT_PARAMETERS); 2021e3273c9SGreg Roach } 2039b5537c3SGreg Roach 2049b5537c3SGreg Roach /** 2056ccdf4f0SGreg Roach * @param ServerRequestInterface $request 2066ccdf4f0SGreg Roach * 2076ccdf4f0SGreg Roach * @return ResponseInterface 2086ccdf4f0SGreg Roach */ 2093cfcc809SGreg Roach public function handle(ServerRequestInterface $request): ResponseInterface 2106ccdf4f0SGreg Roach { 211*b55cbc6bSGreg Roach $tree = Validator::attributes($request)->tree(); 212*b55cbc6bSGreg Roach $xref = Validator::attributes($request)->isXref()->string('xref'); 213*b55cbc6bSGreg Roach $xref2 = Validator::attributes($request)->isXref()->string('xref2', ''); 214*b55cbc6bSGreg Roach $ajax = Validator::queryParams($request)->boolean('ajax', false); 2153cfcc809SGreg Roach $ancestors = (int) $request->getAttribute('ancestors'); 2163cfcc809SGreg Roach $recursion = (int) $request->getAttribute('recursion'); 217*b55cbc6bSGreg Roach $user = Validator::attributes($request)->user(); 2189b5537c3SGreg Roach 2193cfcc809SGreg Roach // Convert POST requests into GET requests for pretty URLs. 2203cfcc809SGreg Roach if ($request->getMethod() === RequestMethodInterface::METHOD_POST) { 22172f04adfSGreg Roach return redirect(route(static::class, [ 2224ea62551SGreg Roach 'tree' => $tree->name(), 223*b55cbc6bSGreg Roach 'ancestors' => Validator::parsedBody($request)->string('ancestors', ''), 224*b55cbc6bSGreg Roach 'recursion' => Validator::parsedBody($request)->string('recursion', ''), 225*b55cbc6bSGreg Roach 'xref' => Validator::parsedBody($request)->string('xref', ''), 226*b55cbc6bSGreg Roach 'xref2' => Validator::parsedBody($request)->string('xref2', ''), 2273cfcc809SGreg Roach ])); 2283cfcc809SGreg Roach } 2299b5537c3SGreg Roach 2306b9cb339SGreg Roach $individual1 = Registry::individualFactory()->make($xref, $tree); 2316b9cb339SGreg Roach $individual2 = Registry::individualFactory()->make($xref2, $tree); 2329b5537c3SGreg Roach 2333dcc812bSGreg Roach $ancestors_only = (int) $tree->getPreference('RELATIONSHIP_ANCESTORS', static::DEFAULT_ANCESTORS); 2343dcc812bSGreg Roach $max_recursion = (int) $tree->getPreference('RELATIONSHIP_RECURSION', static::DEFAULT_RECURSION); 2359b5537c3SGreg Roach 2369b5537c3SGreg Roach $recursion = min($recursion, $max_recursion); 2379b5537c3SGreg Roach 238*b55cbc6bSGreg Roach Auth::checkComponentAccess($this, ModuleChartInterface::class, $tree, $user); 239*b55cbc6bSGreg Roach 2403dcc812bSGreg Roach if ($individual1 instanceof Individual) { 2413c3fd0a5SGreg Roach $individual1 = Auth::checkIndividualAccess($individual1, false, true); 2423dcc812bSGreg Roach } 2433dcc812bSGreg Roach 2443dcc812bSGreg Roach if ($individual2 instanceof Individual) { 2453c3fd0a5SGreg Roach $individual2 = Auth::checkIndividualAccess($individual2, false, true); 2468365f910SGreg Roach } 2473dcc812bSGreg Roach 2489b5537c3SGreg Roach if ($individual1 instanceof Individual && $individual2 instanceof Individual) { 249*b55cbc6bSGreg Roach if ($ajax) { 250f866a2aeSGreg Roach return $this->chart($individual1, $individual2, $recursion, $ancestors); 251f866a2aeSGreg Roach } 252f866a2aeSGreg Roach 2539b5537c3SGreg Roach /* I18N: %s are individual’s names */ 25439ca88baSGreg Roach $title = I18N::translate('Relationships between %1$s and %2$s', $individual1->fullName(), $individual2->fullName()); 2559b5537c3SGreg Roach $ajax_url = $this->chartUrl($individual1, [ 2569b5537c3SGreg Roach 'ajax' => true, 2579b5537c3SGreg Roach 'ancestors' => $ancestors, 2583cfcc809SGreg Roach 'recursion' => $recursion, 2593cfcc809SGreg Roach 'xref2' => $individual2->xref(), 2609b5537c3SGreg Roach ]); 2613dcc812bSGreg Roach } else { 2623dcc812bSGreg Roach $title = I18N::translate('Relationships'); 263f866a2aeSGreg Roach $ajax_url = ''; 2643dcc812bSGreg Roach } 2659b5537c3SGreg Roach 2669b5537c3SGreg Roach return $this->viewResponse('modules/relationships-chart/page', [ 2679b5537c3SGreg Roach 'ajax_url' => $ajax_url, 2689b5537c3SGreg Roach 'ancestors' => $ancestors, 2699b5537c3SGreg Roach 'ancestors_only' => $ancestors_only, 2709b5537c3SGreg Roach 'ancestors_options' => $this->ancestorsOptions(), 2719b5537c3SGreg Roach 'individual1' => $individual1, 2729b5537c3SGreg Roach 'individual2' => $individual2, 2739b5537c3SGreg Roach 'max_recursion' => $max_recursion, 27471378461SGreg Roach 'module' => $this->name(), 2759b5537c3SGreg Roach 'recursion' => $recursion, 2769b5537c3SGreg Roach 'recursion_options' => $this->recursionOptions($max_recursion), 2779b5537c3SGreg Roach 'title' => $title, 2783cfcc809SGreg Roach 'tree' => $tree, 2799b5537c3SGreg Roach ]); 2809b5537c3SGreg Roach } 2819b5537c3SGreg Roach 2829b5537c3SGreg Roach /** 2833dcc812bSGreg Roach * @param Individual $individual1 2843dcc812bSGreg Roach * @param Individual $individual2 2853dcc812bSGreg Roach * @param int $recursion 2863dcc812bSGreg Roach * @param int $ancestors 2879b5537c3SGreg Roach * 2886ccdf4f0SGreg Roach * @return ResponseInterface 2899b5537c3SGreg Roach */ 2906ccdf4f0SGreg Roach public function chart(Individual $individual1, Individual $individual2, int $recursion, int $ancestors): ResponseInterface 2919b5537c3SGreg Roach { 2923dcc812bSGreg Roach $tree = $individual1->tree(); 2939b5537c3SGreg Roach 2943dcc812bSGreg Roach $max_recursion = (int) $tree->getPreference('RELATIONSHIP_RECURSION', static::DEFAULT_RECURSION); 2959b5537c3SGreg Roach 2969b5537c3SGreg Roach $recursion = min($recursion, $max_recursion); 2979b5537c3SGreg Roach 2989b5537c3SGreg Roach $paths = $this->calculateRelationships($individual1, $individual2, $recursion, (bool) $ancestors); 2999b5537c3SGreg Roach 3009b5537c3SGreg Roach ob_start(); 3019b5537c3SGreg Roach if (I18N::direction() === 'ltr') { 302e837ff07SGreg Roach $diagonal1 = asset('css/images/dline.png'); 303e837ff07SGreg Roach $diagonal2 = asset('css/images/dline2.png'); 3049b5537c3SGreg Roach } else { 305e837ff07SGreg Roach $diagonal1 = asset('css/images/dline2.png'); 306e837ff07SGreg Roach $diagonal2 = asset('css/images/dline.png'); 3079b5537c3SGreg Roach } 3089b5537c3SGreg Roach 3099b5537c3SGreg Roach $num_paths = 0; 3109b5537c3SGreg Roach foreach ($paths as $path) { 3119b5537c3SGreg Roach // Extract the relationship names between pairs of individuals 3129b5537c3SGreg Roach $relationships = $this->oldStyleRelationshipPath($tree, $path); 313075d1a05SGreg Roach if ($relationships === []) { 3149b5537c3SGreg Roach // Cannot see one of the families/individuals, due to privacy; 3159b5537c3SGreg Roach continue; 3169b5537c3SGreg Roach } 3176fcafd02SGreg Roach 3186fcafd02SGreg Roach $nodes = Collection::make($path) 3196fcafd02SGreg Roach ->map(static function (string $xref, int $key) use ($tree): GedcomRecord { 3206fcafd02SGreg Roach if ($key % 2 === 0) { 3216fcafd02SGreg Roach return Registry::individualFactory()->make($xref, $tree); 3226fcafd02SGreg Roach } 3236fcafd02SGreg Roach 3246fcafd02SGreg Roach return Registry::familyFactory()->make($xref, $tree); 3256fcafd02SGreg Roach }); 3266fcafd02SGreg Roach 327*b55cbc6bSGreg Roach $language = $this->module_service 3286fcafd02SGreg Roach ->findByInterface(ModuleLanguageInterface::class, true) 3296fcafd02SGreg Roach ->first(fn (ModuleLanguageInterface $language): bool => $language->locale()->languageTag() === I18N::languageTag()); 3306fcafd02SGreg Roach 3316fcafd02SGreg Roach echo '<h3>', I18N::translate('Relationship: %s', $this->relationship_service->nameFromPath($nodes->all(), $language)), '</h3>'; 3329b5537c3SGreg Roach $num_paths++; 3339b5537c3SGreg Roach 3349b5537c3SGreg Roach // Use a table/grid for layout. 3359b5537c3SGreg Roach $table = []; 3369b5537c3SGreg Roach // Current position in the grid. 3379b5537c3SGreg Roach $x = 0; 3389b5537c3SGreg Roach $y = 0; 3399b5537c3SGreg Roach // Extent of the grid. 3409b5537c3SGreg Roach $min_y = 0; 3419b5537c3SGreg Roach $max_y = 0; 3429b5537c3SGreg Roach $max_x = 0; 3439b5537c3SGreg Roach // For each node in the path. 3449b5537c3SGreg Roach foreach ($path as $n => $xref) { 3459b5537c3SGreg Roach if ($n % 2 === 1) { 3469b5537c3SGreg Roach switch ($relationships[$n]) { 3479b5537c3SGreg Roach case 'hus': 3489b5537c3SGreg Roach case 'wif': 3499b5537c3SGreg Roach case 'spo': 3509b5537c3SGreg Roach case 'bro': 3519b5537c3SGreg Roach case 'sis': 3529b5537c3SGreg Roach case 'sib': 353*b55cbc6bSGreg 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>'; 3549b5537c3SGreg Roach $x += 2; 3559b5537c3SGreg Roach break; 3569b5537c3SGreg Roach case 'son': 3579b5537c3SGreg Roach case 'dau': 3589b5537c3SGreg Roach case 'chi': 3599b5537c3SGreg Roach if ($n > 2 && preg_match('/fat|mot|par/', $relationships[$n - 2])) { 360*b55cbc6bSGreg 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>'; 3619b5537c3SGreg Roach $x += 2; 3629b5537c3SGreg Roach } else { 363*b55cbc6bSGreg 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>'; 3649b5537c3SGreg Roach } 3659b5537c3SGreg Roach $y -= 2; 3669b5537c3SGreg Roach break; 3679b5537c3SGreg Roach case 'fat': 3689b5537c3SGreg Roach case 'mot': 3699b5537c3SGreg Roach case 'par': 3709b5537c3SGreg Roach if ($n > 2 && preg_match('/son|dau|chi/', $relationships[$n - 2])) { 371*b55cbc6bSGreg 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>'; 3729b5537c3SGreg Roach $x += 2; 3739b5537c3SGreg Roach } else { 374*b55cbc6bSGreg 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>'; 3759b5537c3SGreg Roach } 3769b5537c3SGreg Roach $y += 2; 3779b5537c3SGreg Roach break; 3789b5537c3SGreg Roach } 3799b5537c3SGreg Roach $max_x = max($max_x, $x); 3809b5537c3SGreg Roach $min_y = min($min_y, $y); 3819b5537c3SGreg Roach $max_y = max($max_y, $y); 3829b5537c3SGreg Roach } else { 3836b9cb339SGreg Roach $individual = Registry::individualFactory()->make($xref, $tree); 384f4ba05e3SGreg Roach $table[$x][$y] = view('chart-box', ['individual' => $individual]); 3859b5537c3SGreg Roach } 3869b5537c3SGreg Roach } 3874a2590a5SGreg Roach echo '<div class="wt-chart wt-chart-relationships">'; 3889b5537c3SGreg Roach echo '<table style="border-collapse: collapse; margin: 20px 50px;">'; 3899b5537c3SGreg Roach for ($y = $max_y; $y >= $min_y; --$y) { 3909b5537c3SGreg Roach echo '<tr>'; 3919b5537c3SGreg Roach for ($x = 0; $x <= $max_x; ++$x) { 3929b5537c3SGreg Roach echo '<td style="padding: 0;">'; 3939b5537c3SGreg Roach if (isset($table[$x][$y])) { 3949b5537c3SGreg Roach echo $table[$x][$y]; 3959b5537c3SGreg Roach } 3969b5537c3SGreg Roach echo '</td>'; 3979b5537c3SGreg Roach } 3989b5537c3SGreg Roach echo '</tr>'; 3999b5537c3SGreg Roach } 4009b5537c3SGreg Roach echo '</table>'; 4019b5537c3SGreg Roach echo '</div>'; 4029b5537c3SGreg Roach } 4039b5537c3SGreg Roach 4049b5537c3SGreg Roach if (!$num_paths) { 4059b5537c3SGreg Roach echo '<p>', I18N::translate('No link between the two individuals could be found.'), '</p>'; 4069b5537c3SGreg Roach } 4079b5537c3SGreg Roach 4089b5537c3SGreg Roach $html = ob_get_clean(); 4099b5537c3SGreg Roach 4106ccdf4f0SGreg Roach return response($html); 4119b5537c3SGreg Roach } 4129b5537c3SGreg Roach 4139b5537c3SGreg Roach /** 4143cfcc809SGreg Roach * @param ServerRequestInterface $request 4153cfcc809SGreg Roach * 4163cfcc809SGreg Roach * @return ResponseInterface 4173cfcc809SGreg Roach */ 4183cfcc809SGreg Roach public function getAdminAction(ServerRequestInterface $request): ResponseInterface 4193cfcc809SGreg Roach { 4203cfcc809SGreg Roach $this->layout = 'layouts/administration'; 4213cfcc809SGreg Roach 4223cfcc809SGreg Roach return $this->viewResponse('modules/relationships-chart/config', [ 4233df1e584SGreg Roach 'all_trees' => $this->tree_service->all(), 4243cfcc809SGreg Roach 'ancestors_options' => $this->ancestorsOptions(), 4253cfcc809SGreg Roach 'default_ancestors' => self::DEFAULT_ANCESTORS, 4263cfcc809SGreg Roach 'default_recursion' => self::DEFAULT_RECURSION, 4273cfcc809SGreg Roach 'recursion_options' => $this->recursionConfigOptions(), 4283cfcc809SGreg Roach 'title' => I18N::translate('Chart preferences') . ' — ' . $this->title(), 4293cfcc809SGreg Roach ]); 4303cfcc809SGreg Roach } 4313cfcc809SGreg Roach 4323cfcc809SGreg Roach /** 4333cfcc809SGreg Roach * @param ServerRequestInterface $request 4343cfcc809SGreg Roach * 4353cfcc809SGreg Roach * @return ResponseInterface 4363cfcc809SGreg Roach */ 4373cfcc809SGreg Roach public function postAdminAction(ServerRequestInterface $request): ResponseInterface 4383cfcc809SGreg Roach { 439b46c87bdSGreg Roach $params = (array) $request->getParsedBody(); 440b46c87bdSGreg Roach 4413df1e584SGreg Roach foreach ($this->tree_service->all() as $tree) { 442b46c87bdSGreg Roach $recursion = $params['relationship-recursion-' . $tree->id()] ?? ''; 443b46c87bdSGreg Roach $ancestors = $params['relationship-ancestors-' . $tree->id()] ?? ''; 4443cfcc809SGreg Roach 4453cfcc809SGreg Roach $tree->setPreference('RELATIONSHIP_RECURSION', $recursion); 4463cfcc809SGreg Roach $tree->setPreference('RELATIONSHIP_ANCESTORS', $ancestors); 4473cfcc809SGreg Roach } 4483cfcc809SGreg Roach 4493cfcc809SGreg Roach FlashMessages::addMessage(I18N::translate('The preferences for the module “%s” have been updated.', $this->title()), 'success'); 4503cfcc809SGreg Roach 4513cfcc809SGreg Roach return redirect($this->getConfigLink()); 4523cfcc809SGreg Roach } 4533cfcc809SGreg Roach 4543cfcc809SGreg Roach /** 4553cfcc809SGreg Roach * Possible options for the ancestors option 4563cfcc809SGreg Roach * 4577c2c99faSGreg Roach * @return array<int,string> 4583cfcc809SGreg Roach */ 4593cfcc809SGreg Roach private function ancestorsOptions(): array 4603cfcc809SGreg Roach { 4613cfcc809SGreg Roach return [ 4623cfcc809SGreg Roach 0 => I18N::translate('Find any relationship'), 4633cfcc809SGreg Roach 1 => I18N::translate('Find relationships via ancestors'), 4643cfcc809SGreg Roach ]; 4653cfcc809SGreg Roach } 4663cfcc809SGreg Roach 4673cfcc809SGreg Roach /** 4683cfcc809SGreg Roach * Possible options for the recursion option 4693cfcc809SGreg Roach * 4707c2c99faSGreg Roach * @return array<int,string> 4713cfcc809SGreg Roach */ 4723cfcc809SGreg Roach private function recursionConfigOptions(): array 4733cfcc809SGreg Roach { 4743cfcc809SGreg Roach return [ 4753cfcc809SGreg Roach 0 => I18N::translate('none'), 4763cfcc809SGreg Roach 1 => I18N::number(1), 4773cfcc809SGreg Roach 2 => I18N::number(2), 4783cfcc809SGreg Roach 3 => I18N::number(3), 4793cfcc809SGreg Roach self::UNLIMITED_RECURSION => I18N::translate('unlimited'), 4803cfcc809SGreg Roach ]; 4813cfcc809SGreg Roach } 4823cfcc809SGreg Roach 4833cfcc809SGreg Roach /** 4849b5537c3SGreg Roach * Calculate the shortest paths - or all paths - between two individuals. 4859b5537c3SGreg Roach * 4869b5537c3SGreg Roach * @param Individual $individual1 4879b5537c3SGreg Roach * @param Individual $individual2 4889b5537c3SGreg Roach * @param int $recursion How many levels of recursion to use 4899b5537c3SGreg Roach * @param bool $ancestor Restrict to relationships via a common ancestor 4909b5537c3SGreg Roach * 49124f2a3afSGreg Roach * @return array<array<string>> 4929b5537c3SGreg Roach */ 49324f2a3afSGreg Roach private function calculateRelationships( 49424f2a3afSGreg Roach Individual $individual1, 49524f2a3afSGreg Roach Individual $individual2, 49624f2a3afSGreg Roach int $recursion, 49724f2a3afSGreg Roach bool $ancestor = false 49824f2a3afSGreg Roach ): array { 4993dcc812bSGreg Roach $tree = $individual1->tree(); 5003dcc812bSGreg Roach 5019b5537c3SGreg Roach $rows = DB::table('link') 5023dcc812bSGreg Roach ->where('l_file', '=', $tree->id()) 5039b5537c3SGreg Roach ->whereIn('l_type', ['FAMS', 'FAMC']) 5049b5537c3SGreg Roach ->select(['l_from', 'l_to']) 5059b5537c3SGreg Roach ->get(); 5069b5537c3SGreg Roach 5079b5537c3SGreg Roach // Optionally restrict the graph to the ancestors of the individuals. 5089b5537c3SGreg Roach if ($ancestor) { 5093dcc812bSGreg Roach $ancestors = $this->allAncestors($individual1->xref(), $individual2->xref(), $tree->id()); 5103dcc812bSGreg Roach $exclude = $this->excludeFamilies($individual1->xref(), $individual2->xref(), $tree->id()); 5119b5537c3SGreg Roach } else { 5129b5537c3SGreg Roach $ancestors = []; 5139b5537c3SGreg Roach $exclude = []; 5149b5537c3SGreg Roach } 5159b5537c3SGreg Roach 5169b5537c3SGreg Roach $graph = []; 5179b5537c3SGreg Roach 5189b5537c3SGreg Roach foreach ($rows as $row) { 519075d1a05SGreg Roach if ($ancestors === [] || in_array($row->l_from, $ancestors, true) && !in_array($row->l_to, $exclude, true)) { 5209b5537c3SGreg Roach $graph[$row->l_from][$row->l_to] = 1; 5219b5537c3SGreg Roach $graph[$row->l_to][$row->l_from] = 1; 5229b5537c3SGreg Roach } 5239b5537c3SGreg Roach } 5249b5537c3SGreg Roach 5259b5537c3SGreg Roach $xref1 = $individual1->xref(); 5269b5537c3SGreg Roach $xref2 = $individual2->xref(); 5279b5537c3SGreg Roach $dijkstra = new Dijkstra($graph); 5289b5537c3SGreg Roach $paths = $dijkstra->shortestPaths($xref1, $xref2); 5299b5537c3SGreg Roach 5309b5537c3SGreg Roach // Only process each exclusion list once; 5319b5537c3SGreg Roach $excluded = []; 5329b5537c3SGreg Roach 5339b5537c3SGreg Roach $queue = []; 5349b5537c3SGreg Roach foreach ($paths as $path) { 5359b5537c3SGreg Roach // Insert the paths into the queue, with an exclusion list. 5369b5537c3SGreg Roach $queue[] = [ 5379b5537c3SGreg Roach 'path' => $path, 5389b5537c3SGreg Roach 'exclude' => [], 5399b5537c3SGreg Roach ]; 5409b5537c3SGreg Roach // While there are un-extended paths 5419b5537c3SGreg Roach for ($next = current($queue); $next !== false; $next = next($queue)) { 5429b5537c3SGreg Roach // For each family on the path 5439b5537c3SGreg Roach for ($n = count($next['path']) - 2; $n >= 1; $n -= 2) { 5449b5537c3SGreg Roach $exclude = $next['exclude']; 5459b5537c3SGreg Roach if (count($exclude) >= $recursion) { 5469b5537c3SGreg Roach continue; 5479b5537c3SGreg Roach } 5489b5537c3SGreg Roach $exclude[] = $next['path'][$n]; 5499b5537c3SGreg Roach sort($exclude); 5509b5537c3SGreg Roach $tmp = implode('-', $exclude); 55122d65e5aSGreg Roach if (in_array($tmp, $excluded, true)) { 5529b5537c3SGreg Roach continue; 5539b5537c3SGreg Roach } 5549b5537c3SGreg Roach 5559b5537c3SGreg Roach $excluded[] = $tmp; 5569b5537c3SGreg Roach // Add any new path to the queue 5579b5537c3SGreg Roach foreach ($dijkstra->shortestPaths($xref1, $xref2, $exclude) as $new_path) { 5589b5537c3SGreg Roach $queue[] = [ 5599b5537c3SGreg Roach 'path' => $new_path, 5609b5537c3SGreg Roach 'exclude' => $exclude, 5619b5537c3SGreg Roach ]; 5629b5537c3SGreg Roach } 5639b5537c3SGreg Roach } 5649b5537c3SGreg Roach } 5659b5537c3SGreg Roach } 566185cbb4dSGreg Roach // Extract the paths from the queue. 5679b5537c3SGreg Roach $paths = []; 5689b5537c3SGreg Roach foreach ($queue as $next) { 569185cbb4dSGreg Roach // The Dijkstra library does not use strict types, and converts 570185cbb4dSGreg Roach // numeric array keys (XREFs) from strings to integers; 571185cbb4dSGreg Roach $path = array_map($this->stringMapper(), $next['path']); 572185cbb4dSGreg Roach 573185cbb4dSGreg Roach // Remove duplicates 574185cbb4dSGreg Roach $paths[implode('-', $next['path'])] = $path; 5759b5537c3SGreg Roach } 5769b5537c3SGreg Roach 5779b5537c3SGreg Roach return $paths; 5789b5537c3SGreg Roach } 5799b5537c3SGreg Roach 5809b5537c3SGreg Roach /** 581185cbb4dSGreg Roach * Convert numeric values to strings 582185cbb4dSGreg Roach * 583185cbb4dSGreg Roach * @return Closure 584185cbb4dSGreg Roach */ 585c3f3b628SGreg Roach private function stringMapper(): Closure 586c3f3b628SGreg Roach { 587185cbb4dSGreg Roach return static function ($xref) { 588185cbb4dSGreg Roach return (string) $xref; 589185cbb4dSGreg Roach }; 590185cbb4dSGreg Roach } 591185cbb4dSGreg Roach 592185cbb4dSGreg Roach /** 5939b5537c3SGreg Roach * Find all ancestors of a list of individuals 5949b5537c3SGreg Roach * 5959b5537c3SGreg Roach * @param string $xref1 5969b5537c3SGreg Roach * @param string $xref2 5979b5537c3SGreg Roach * @param int $tree_id 5989b5537c3SGreg Roach * 59924f2a3afSGreg Roach * @return array<string> 6009b5537c3SGreg Roach */ 60124f2a3afSGreg Roach private function allAncestors(string $xref1, string $xref2, int $tree_id): array 6029b5537c3SGreg Roach { 6039b5537c3SGreg Roach $ancestors = [ 6049b5537c3SGreg Roach $xref1, 6059b5537c3SGreg Roach $xref2, 6069b5537c3SGreg Roach ]; 6079b5537c3SGreg Roach 6089b5537c3SGreg Roach $queue = [ 6099b5537c3SGreg Roach $xref1, 6109b5537c3SGreg Roach $xref2, 6119b5537c3SGreg Roach ]; 612075d1a05SGreg Roach while ($queue !== []) { 6139b5537c3SGreg Roach $parents = DB::table('link AS l1') 6140b5fd0a6SGreg Roach ->join('link AS l2', static function (JoinClause $join): void { 6159b5537c3SGreg Roach $join 6169b5537c3SGreg Roach ->on('l1.l_to', '=', 'l2.l_to') 6179b5537c3SGreg Roach ->on('l1.l_file', '=', 'l2.l_file'); 6189b5537c3SGreg Roach }) 6199b5537c3SGreg Roach ->where('l1.l_file', '=', $tree_id) 6209b5537c3SGreg Roach ->where('l1.l_type', '=', 'FAMC') 6219b5537c3SGreg Roach ->where('l2.l_type', '=', 'FAMS') 6229b5537c3SGreg Roach ->whereIn('l1.l_from', $queue) 6239b5537c3SGreg Roach ->pluck('l2.l_from'); 6249b5537c3SGreg Roach 6259b5537c3SGreg Roach $queue = []; 6269b5537c3SGreg Roach foreach ($parents as $parent) { 62722d65e5aSGreg Roach if (!in_array($parent, $ancestors, true)) { 6289b5537c3SGreg Roach $ancestors[] = $parent; 6299b5537c3SGreg Roach $queue[] = $parent; 6309b5537c3SGreg Roach } 6319b5537c3SGreg Roach } 6329b5537c3SGreg Roach } 6339b5537c3SGreg Roach 6349b5537c3SGreg Roach return $ancestors; 6359b5537c3SGreg Roach } 6369b5537c3SGreg Roach 6379b5537c3SGreg Roach /** 6389b5537c3SGreg Roach * Find all families of two individuals 6399b5537c3SGreg Roach * 6409b5537c3SGreg Roach * @param string $xref1 6419b5537c3SGreg Roach * @param string $xref2 6429b5537c3SGreg Roach * @param int $tree_id 6439b5537c3SGreg Roach * 64424f2a3afSGreg Roach * @return array<string> 6459b5537c3SGreg Roach */ 64624f2a3afSGreg Roach private function excludeFamilies(string $xref1, string $xref2, int $tree_id): array 6479b5537c3SGreg Roach { 6489b5537c3SGreg Roach return DB::table('link AS l1') 6490b5fd0a6SGreg Roach ->join('link AS l2', static function (JoinClause $join): void { 6509b5537c3SGreg Roach $join 6519b5537c3SGreg Roach ->on('l1.l_to', '=', 'l2.l_to') 6529b5537c3SGreg Roach ->on('l1.l_type', '=', 'l2.l_type') 6539b5537c3SGreg Roach ->on('l1.l_file', '=', 'l2.l_file'); 6549b5537c3SGreg Roach }) 6559b5537c3SGreg Roach ->where('l1.l_file', '=', $tree_id) 6569b5537c3SGreg Roach ->where('l1.l_type', '=', 'FAMS') 6579b5537c3SGreg Roach ->where('l1.l_from', '=', $xref1) 6589b5537c3SGreg Roach ->where('l2.l_from', '=', $xref2) 6599b5537c3SGreg Roach ->pluck('l1.l_to') 6609b5537c3SGreg Roach ->all(); 6619b5537c3SGreg Roach } 6629b5537c3SGreg Roach 6639b5537c3SGreg Roach /** 6646ccdf4f0SGreg Roach * Convert a path (list of XREFs) to an "old-style" string of relationships. 6656ccdf4f0SGreg Roach * Return an empty array, if privacy rules prevent us viewing any node. 6666ccdf4f0SGreg Roach * 6676ccdf4f0SGreg Roach * @param Tree $tree 66809482a55SGreg Roach * @param array<string> $path Alternately Individual / Family 6696ccdf4f0SGreg Roach * 67024f2a3afSGreg Roach * @return array<string> 6716ccdf4f0SGreg Roach */ 6726ccdf4f0SGreg Roach private function oldStyleRelationshipPath(Tree $tree, array $path): array 6736ccdf4f0SGreg Roach { 6746ccdf4f0SGreg Roach $spouse_codes = [ 6756ccdf4f0SGreg Roach 'M' => 'hus', 6766ccdf4f0SGreg Roach 'F' => 'wif', 6776ccdf4f0SGreg Roach 'U' => 'spo', 6786ccdf4f0SGreg Roach ]; 6796ccdf4f0SGreg Roach $parent_codes = [ 6806ccdf4f0SGreg Roach 'M' => 'fat', 6816ccdf4f0SGreg Roach 'F' => 'mot', 6826ccdf4f0SGreg Roach 'U' => 'par', 6836ccdf4f0SGreg Roach ]; 6846ccdf4f0SGreg Roach $child_codes = [ 6856ccdf4f0SGreg Roach 'M' => 'son', 6866ccdf4f0SGreg Roach 'F' => 'dau', 6876ccdf4f0SGreg Roach 'U' => 'chi', 6886ccdf4f0SGreg Roach ]; 6896ccdf4f0SGreg Roach $sibling_codes = [ 6906ccdf4f0SGreg Roach 'M' => 'bro', 6916ccdf4f0SGreg Roach 'F' => 'sis', 6926ccdf4f0SGreg Roach 'U' => 'sib', 6936ccdf4f0SGreg Roach ]; 6946ccdf4f0SGreg Roach $relationships = []; 6956ccdf4f0SGreg Roach 6966ccdf4f0SGreg Roach for ($i = 1, $count = count($path); $i < $count; $i += 2) { 6976b9cb339SGreg Roach $family = Registry::familyFactory()->make($path[$i], $tree); 6986b9cb339SGreg Roach $prev = Registry::individualFactory()->make($path[$i - 1], $tree); 6996b9cb339SGreg Roach $next = Registry::individualFactory()->make($path[$i + 1], $tree); 7006ccdf4f0SGreg Roach if (preg_match('/\n\d (HUSB|WIFE|CHIL) @' . $prev->xref() . '@/', $family->gedcom(), $match)) { 7016ccdf4f0SGreg Roach $rel1 = $match[1]; 7026ccdf4f0SGreg Roach } else { 7036ccdf4f0SGreg Roach return []; 7046ccdf4f0SGreg Roach } 7056ccdf4f0SGreg Roach if (preg_match('/\n\d (HUSB|WIFE|CHIL) @' . $next->xref() . '@/', $family->gedcom(), $match)) { 7066ccdf4f0SGreg Roach $rel2 = $match[1]; 7076ccdf4f0SGreg Roach } else { 7086ccdf4f0SGreg Roach return []; 7096ccdf4f0SGreg Roach } 7106ccdf4f0SGreg Roach if (($rel1 === 'HUSB' || $rel1 === 'WIFE') && ($rel2 === 'HUSB' || $rel2 === 'WIFE')) { 7116ccdf4f0SGreg Roach $relationships[$i] = $spouse_codes[$next->sex()]; 7126ccdf4f0SGreg Roach } elseif (($rel1 === 'HUSB' || $rel1 === 'WIFE') && $rel2 === 'CHIL') { 7136ccdf4f0SGreg Roach $relationships[$i] = $child_codes[$next->sex()]; 7146ccdf4f0SGreg Roach } elseif ($rel1 === 'CHIL' && ($rel2 === 'HUSB' || $rel2 === 'WIFE')) { 7156ccdf4f0SGreg Roach $relationships[$i] = $parent_codes[$next->sex()]; 7166ccdf4f0SGreg Roach } elseif ($rel1 === 'CHIL' && $rel2 === 'CHIL') { 7176ccdf4f0SGreg Roach $relationships[$i] = $sibling_codes[$next->sex()]; 7186ccdf4f0SGreg Roach } 7196ccdf4f0SGreg Roach } 7206ccdf4f0SGreg Roach 7216ccdf4f0SGreg Roach return $relationships; 7226ccdf4f0SGreg Roach } 7236ccdf4f0SGreg Roach 7246ccdf4f0SGreg Roach /** 7259b5537c3SGreg Roach * Possible options for the recursion option 7269b5537c3SGreg Roach * 7279b5537c3SGreg Roach * @param int $max_recursion 7289b5537c3SGreg Roach * 72924f2a3afSGreg Roach * @return array<string> 7309b5537c3SGreg Roach */ 7319b5537c3SGreg Roach private function recursionOptions(int $max_recursion): array 7329b5537c3SGreg Roach { 7333dcc812bSGreg Roach if ($max_recursion === static::UNLIMITED_RECURSION) { 7349b5537c3SGreg Roach $text = I18N::translate('Find all possible relationships'); 7359b5537c3SGreg Roach } else { 7369b5537c3SGreg Roach $text = I18N::translate('Find other relationships'); 7379b5537c3SGreg Roach } 7389b5537c3SGreg Roach 7399b5537c3SGreg Roach return [ 7409b5537c3SGreg Roach '0' => I18N::translate('Find the closest relationships'), 7419b5537c3SGreg Roach $max_recursion => $text, 7429b5537c3SGreg Roach ]; 7439b5537c3SGreg Roach } 744168ff6f3Sric2016} 745