. */ declare(strict_types=1); namespace Fisharebest\Webtrees\Http\RequestHandlers; use Fisharebest\Algorithm\ConnectedComponent; use Fisharebest\Webtrees\Http\ViewResponseTrait; use Fisharebest\Webtrees\I18N; use Fisharebest\Webtrees\Individual; use Fisharebest\Webtrees\Tree; use Fisharebest\Webtrees\User; use Illuminate\Database\Capsule\Manager as DB; use Psr\Http\Message\ResponseInterface; use Psr\Http\Message\ServerRequestInterface; use Psr\Http\Server\RequestHandlerInterface; use function assert; /** * Find groups of unrelated individuals. */ class UnconnectedPage implements RequestHandlerInterface { use ViewResponseTrait; /** * @param ServerRequestInterface $request * * @return ResponseInterface */ public function handle(ServerRequestInterface $request): ResponseInterface { $tree = $request->getAttribute('tree'); assert($tree instanceof Tree); $user = $request->getAttribute('user'); assert($user instanceof User); $associates = (bool) ($request->getQueryParams()['associates'] ?? false); if ($associates) { $links = ['FAMS', 'FAMC', 'ASSO', '_ASSO']; } else { $links = ['FAMS', 'FAMC']; } $rows = DB::table('link') ->where('l_file', '=', $tree->id()) ->whereIn('l_type', $links) ->select(['l_from', 'l_to']) ->get(); $graph = []; foreach ($rows as $row) { $graph[$row->l_from][$row->l_to] = 1; $graph[$row->l_to][$row->l_from] = 1; } $algorithm = new ConnectedComponent($graph); $components = $algorithm->findConnectedComponents(); $root = $tree->significantIndividual($user); $xref = $root->xref(); /** @var Individual[][] */ $individual_groups = []; foreach ($components as $component) { if (!in_array($xref, $component, true)) { $individuals = []; foreach ($component as $xref) { $individuals[] = Individual::getInstance($xref, $tree); } // The database query may return pending additions/deletions, which may not exist. $individual_groups[] = array_filter($individuals); } } $title = I18N::translate('Find unrelated individuals') . ' — ' . e($tree->title()); $this->layout = 'layouts/administration'; return $this->viewResponse('admin/trees-unconnected', [ 'associates' => $associates, 'root' => $root, 'individual_groups' => $individual_groups, 'title' => $title, 'tree' => $tree, ]); } }