xref: /webtrees/app/Individual.php (revision f94b830f9a4ef11b0a336999817b29b5b6e0acf0)
1a25f0a04SGreg Roach<?php
23976b470SGreg Roach
3a25f0a04SGreg Roach/**
4a25f0a04SGreg Roach * webtrees: online genealogy
5d11be702SGreg Roach * Copyright (C) 2023 webtrees development team
6a25f0a04SGreg Roach * This program is free software: you can redistribute it and/or modify
7a25f0a04SGreg Roach * it under the terms of the GNU General Public License as published by
8a25f0a04SGreg Roach * the Free Software Foundation, either version 3 of the License, or
9a25f0a04SGreg Roach * (at your option) any later version.
10a25f0a04SGreg Roach * This program is distributed in the hope that it will be useful,
11a25f0a04SGreg Roach * but WITHOUT ANY WARRANTY; without even the implied warranty of
12a25f0a04SGreg Roach * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
13a25f0a04SGreg Roach * GNU General Public License for more details.
14a25f0a04SGreg Roach * 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/>.
16a25f0a04SGreg Roach */
17fcfa147eSGreg Roach
18e7f56f2aSGreg Roachdeclare(strict_types=1);
19e7f56f2aSGreg Roach
2076692c8bSGreg Roachnamespace Fisharebest\Webtrees;
21a25f0a04SGreg Roach
22886b77daSGreg Roachuse Closure;
23a25f0a04SGreg Roachuse Fisharebest\ExtCalendar\GregorianCalendar;
241fe542e9SGreg Roachuse Fisharebest\Webtrees\Contracts\UserInterface;
25665e281aSGreg Roachuse Fisharebest\Webtrees\Elements\PedigreeLinkageType;
26852ede8cSGreg Roachuse Fisharebest\Webtrees\Http\RequestHandlers\IndividualPage;
272e5b4452SGreg Roachuse Illuminate\Database\Capsule\Manager as DB;
2839ca88baSGreg Roachuse Illuminate\Support\Collection;
29a25f0a04SGreg Roach
3010e06497SGreg Roachuse function array_key_exists;
3110e06497SGreg Roachuse function count;
3210e06497SGreg Roachuse function in_array;
337d70e4a7SGreg Roachuse function preg_match;
347d70e4a7SGreg Roach
35a25f0a04SGreg Roach/**
3676692c8bSGreg Roach * A GEDCOM individual (INDI) object.
37a25f0a04SGreg Roach */
38c1010edaSGreg Roachclass Individual extends GedcomRecord
39c1010edaSGreg Roach{
4016d6367aSGreg Roach    public const RECORD_TYPE = 'INDI';
4116d6367aSGreg Roach
428fb4e87cSGreg Roach    // Placeholders to indicate unknown names
438fb4e87cSGreg Roach    public const NOMEN_NESCIO     = '@N.N.';
448fb4e87cSGreg Roach    public const PRAENOMEN_NESCIO = '@P.N.';
458fb4e87cSGreg Roach
46852ede8cSGreg Roach    protected const ROUTE_NAME = IndividualPage::class;
47a25f0a04SGreg Roach
487fa97a69SGreg Roach    /** Used in some lists to keep track of this individual’s generation in that list */
497fa97a69SGreg Roach    public ?int $generation = null;
50a25f0a04SGreg Roach
517fa97a69SGreg Roach    private ?Date $estimated_birth_date = null;
52a25f0a04SGreg Roach
537fa97a69SGreg Roach    private ?Date $estimated_death_date = null;
54a25f0a04SGreg Roach
55a25f0a04SGreg Roach    /**
56c156e8f5SGreg Roach     * A closure which will compare individuals by birth date.
57c156e8f5SGreg Roach     *
58c6921a17SGreg Roach     * @return Closure(Individual,Individual):int
59c156e8f5SGreg Roach     */
60c156e8f5SGreg Roach    public static function birthDateComparator(): Closure
61c156e8f5SGreg Roach    {
626c2179e2SGreg Roach        return static function (Individual $x, Individual $y): int {
63c156e8f5SGreg Roach            return Date::compare($x->getEstimatedBirthDate(), $y->getEstimatedBirthDate());
64c156e8f5SGreg Roach        };
65c156e8f5SGreg Roach    }
66c156e8f5SGreg Roach
67c156e8f5SGreg Roach    /**
68c156e8f5SGreg Roach     * A closure which will compare individuals by death date.
69c156e8f5SGreg Roach     *
70c6921a17SGreg Roach     * @return Closure(Individual,Individual):int
71c156e8f5SGreg Roach     */
72c156e8f5SGreg Roach    public static function deathDateComparator(): Closure
73c156e8f5SGreg Roach    {
746c2179e2SGreg Roach        return static function (Individual $x, Individual $y): int {
7510e21aa9SGreg Roach            return Date::compare($x->getEstimatedDeathDate(), $y->getEstimatedDeathDate());
76c156e8f5SGreg Roach        };
77c156e8f5SGreg Roach    }
78c156e8f5SGreg Roach
79c156e8f5SGreg Roach    /**
80a25f0a04SGreg Roach     * Can the name of this record be shown?
81a25f0a04SGreg Roach     *
8276692c8bSGreg Roach     * @param int|null $access_level
8376692c8bSGreg Roach     *
8476692c8bSGreg Roach     * @return bool
85a25f0a04SGreg Roach     */
8635584196SGreg Roach    public function canShowName(int $access_level = null): bool
87c1010edaSGreg Roach    {
883529c469SGreg Roach        $access_level ??= Auth::accessLevel($this->tree);
894b9ff166SGreg Roach
90f56b86d2SGreg Roach        return (int) $this->tree->getPreference('SHOW_LIVING_NAMES') >= $access_level || $this->canShow($access_level);
91a25f0a04SGreg Roach    }
92a25f0a04SGreg Roach
93a25f0a04SGreg Roach    /**
9476692c8bSGreg Roach     * Can this individual be shown?
95a25f0a04SGreg Roach     *
9676692c8bSGreg Roach     * @param int $access_level
9776692c8bSGreg Roach     *
9876692c8bSGreg Roach     * @return bool
99a25f0a04SGreg Roach     */
10035584196SGreg Roach    protected function canShowByType(int $access_level): bool
101c1010edaSGreg Roach    {
102a25f0a04SGreg Roach        // Dead people...
103f56b86d2SGreg Roach        if ((int) $this->tree->getPreference('SHOW_DEAD_PEOPLE') >= $access_level && $this->isDead()) {
104a25f0a04SGreg Roach            $keep_alive             = false;
10554ba7dc5SGreg Roach            $KEEP_ALIVE_YEARS_BIRTH = (int) $this->tree->getPreference('KEEP_ALIVE_YEARS_BIRTH');
106a25f0a04SGreg Roach            if ($KEEP_ALIVE_YEARS_BIRTH) {
107dce4f3a4SGreg Roach                preg_match_all('/\n1 (?:' . implode('|', Gedcom::BIRTH_EVENTS) . ').*(?:\n[2-9].*)*\n2 DATE (.+)/', $this->gedcom, $matches, PREG_SET_ORDER);
108a25f0a04SGreg Roach                foreach ($matches as $match) {
109a25f0a04SGreg Roach                    $date = new Date($match[1]);
110a25f0a04SGreg Roach                    if ($date->isOK() && $date->gregorianYear() + $KEEP_ALIVE_YEARS_BIRTH > date('Y')) {
111a25f0a04SGreg Roach                        $keep_alive = true;
112a25f0a04SGreg Roach                        break;
113a25f0a04SGreg Roach                    }
114a25f0a04SGreg Roach                }
115a25f0a04SGreg Roach            }
11654ba7dc5SGreg Roach            $KEEP_ALIVE_YEARS_DEATH = (int) $this->tree->getPreference('KEEP_ALIVE_YEARS_DEATH');
117a25f0a04SGreg Roach            if ($KEEP_ALIVE_YEARS_DEATH) {
118dce4f3a4SGreg Roach                preg_match_all('/\n1 (?:' . implode('|', Gedcom::DEATH_EVENTS) . ').*(?:\n[2-9].*)*\n2 DATE (.+)/', $this->gedcom, $matches, PREG_SET_ORDER);
119a25f0a04SGreg Roach                foreach ($matches as $match) {
120a25f0a04SGreg Roach                    $date = new Date($match[1]);
121a25f0a04SGreg Roach                    if ($date->isOK() && $date->gregorianYear() + $KEEP_ALIVE_YEARS_DEATH > date('Y')) {
122a25f0a04SGreg Roach                        $keep_alive = true;
123a25f0a04SGreg Roach                        break;
124a25f0a04SGreg Roach                    }
125a25f0a04SGreg Roach                }
126a25f0a04SGreg Roach            }
127a25f0a04SGreg Roach            if (!$keep_alive) {
128a25f0a04SGreg Roach                return true;
129a25f0a04SGreg Roach            }
130a25f0a04SGreg Roach        }
131a25f0a04SGreg Roach        // Consider relationship privacy (unless an admin is applying download restrictions)
1321fe542e9SGreg Roach        $user_path_length = (int) $this->tree->getUserPreference(Auth::user(), UserInterface::PREF_TREE_PATH_LENGTH);
1331fe542e9SGreg Roach        $gedcomid         = $this->tree->getUserPreference(Auth::user(), UserInterface::PREF_TREE_ACCOUNT_XREF);
1347c4add84SGreg Roach
13554ba7dc5SGreg Roach        if ($gedcomid !== '' && $user_path_length > 0) {
1364b9ff166SGreg Roach            return self::isRelated($this, $user_path_length);
137a25f0a04SGreg Roach        }
138a25f0a04SGreg Roach
139a25f0a04SGreg Roach        // No restriction found - show living people to members only:
1404b9ff166SGreg Roach        return Auth::PRIV_USER >= $access_level;
141a25f0a04SGreg Roach    }
142a25f0a04SGreg Roach
143a25f0a04SGreg Roach    /**
144a25f0a04SGreg Roach     * For relationship privacy calculations - is this individual a close relative?
145a25f0a04SGreg Roach     *
146a25f0a04SGreg Roach     * @param Individual $target
147cbc1590aSGreg Roach     * @param int        $distance
148a25f0a04SGreg Roach     *
149cbc1590aSGreg Roach     * @return bool
150a25f0a04SGreg Roach     */
15124f2a3afSGreg Roach    private static function isRelated(Individual $target, int $distance): bool
152c1010edaSGreg Roach    {
153a25f0a04SGreg Roach        static $cache = null;
154a25f0a04SGreg Roach
1551fe542e9SGreg Roach        $user_individual = Registry::individualFactory()->make($target->tree->getUserPreference(Auth::user(), UserInterface::PREF_TREE_ACCOUNT_XREF), $target->tree);
156a25f0a04SGreg Roach        if ($user_individual) {
157a25f0a04SGreg Roach            if (!$cache) {
15813abd6f3SGreg Roach                $cache = [
15913abd6f3SGreg Roach                    0 => [$user_individual],
16013abd6f3SGreg Roach                    1 => [],
16113abd6f3SGreg Roach                ];
1628d0ebef0SGreg Roach                foreach ($user_individual->facts(['FAMC', 'FAMS'], false, Auth::PRIV_HIDE) as $fact) {
163dc124885SGreg Roach                    $family = $fact->target();
164e24444eeSGreg Roach                    if ($family instanceof Family) {
165a25f0a04SGreg Roach                        $cache[1][] = $family;
166a25f0a04SGreg Roach                    }
167a25f0a04SGreg Roach                }
168a25f0a04SGreg Roach            }
169a25f0a04SGreg Roach        } else {
170a25f0a04SGreg Roach            // No individual linked to this account? Cannot use relationship privacy.
171a25f0a04SGreg Roach            return true;
172a25f0a04SGreg Roach        }
173a25f0a04SGreg Roach
174a25f0a04SGreg Roach        // Double the distance, as we count the INDI-FAM and FAM-INDI links separately
175a25f0a04SGreg Roach        $distance *= 2;
176a25f0a04SGreg Roach
177a25f0a04SGreg Roach        // Consider each path length in turn
178a25f0a04SGreg Roach        for ($n = 0; $n <= $distance; ++$n) {
179a25f0a04SGreg Roach            if (array_key_exists($n, $cache)) {
180a25f0a04SGreg Roach                // We have already calculated all records with this length
181e364afe4SGreg Roach                if ($n % 2 === 0 && in_array($target, $cache[$n], true)) {
182a25f0a04SGreg Roach                    return true;
183a25f0a04SGreg Roach                }
184a25f0a04SGreg Roach            } else {
185a25f0a04SGreg Roach                // Need to calculate these paths
18613abd6f3SGreg Roach                $cache[$n] = [];
187e364afe4SGreg Roach                if ($n % 2 === 0) {
188a25f0a04SGreg Roach                    // Add FAM->INDI links
189a25f0a04SGreg Roach                    foreach ($cache[$n - 1] as $family) {
1908d0ebef0SGreg Roach                        foreach ($family->facts(['HUSB', 'WIFE', 'CHIL'], false, Auth::PRIV_HIDE) as $fact) {
191dc124885SGreg Roach                            $individual = $fact->target();
192a25f0a04SGreg Roach                            // Don’t backtrack
193e364afe4SGreg Roach                            if ($individual instanceof self && !in_array($individual, $cache[$n - 2], true)) {
194a25f0a04SGreg Roach                                $cache[$n][] = $individual;
195a25f0a04SGreg Roach                            }
196a25f0a04SGreg Roach                        }
197a25f0a04SGreg Roach                    }
198a25f0a04SGreg Roach                    if (in_array($target, $cache[$n], true)) {
199a25f0a04SGreg Roach                        return true;
200a25f0a04SGreg Roach                    }
201a25f0a04SGreg Roach                } else {
202a25f0a04SGreg Roach                    // Add INDI->FAM links
203a25f0a04SGreg Roach                    foreach ($cache[$n - 1] as $individual) {
2048d0ebef0SGreg Roach                        foreach ($individual->facts(['FAMC', 'FAMS'], false, Auth::PRIV_HIDE) as $fact) {
205dc124885SGreg Roach                            $family = $fact->target();
206a25f0a04SGreg Roach                            // Don’t backtrack
207e24444eeSGreg Roach                            if ($family instanceof Family && !in_array($family, $cache[$n - 2], true)) {
208a25f0a04SGreg Roach                                $cache[$n][] = $family;
209a25f0a04SGreg Roach                            }
210a25f0a04SGreg Roach                        }
211a25f0a04SGreg Roach                    }
212a25f0a04SGreg Roach                }
213a25f0a04SGreg Roach            }
214a25f0a04SGreg Roach        }
215a25f0a04SGreg Roach
216a25f0a04SGreg Roach        return false;
217a25f0a04SGreg Roach    }
218a25f0a04SGreg Roach
21976692c8bSGreg Roach    /**
22076692c8bSGreg Roach     * Generate a private version of this record
22176692c8bSGreg Roach     *
22276692c8bSGreg Roach     * @param int $access_level
22376692c8bSGreg Roach     *
22476692c8bSGreg Roach     * @return string
22576692c8bSGreg Roach     */
2263c90ed31SGreg Roach    protected function createPrivateGedcomRecord(int $access_level): string
227c1010edaSGreg Roach    {
228acf76a54SGreg Roach        $SHOW_PRIVATE_RELATIONSHIPS = (bool) $this->tree->getPreference('SHOW_PRIVATE_RELATIONSHIPS');
229a25f0a04SGreg Roach
230a25f0a04SGreg Roach        $rec = '0 @' . $this->xref . '@ INDI';
231f56b86d2SGreg Roach        if ((int) $this->tree->getPreference('SHOW_LIVING_NAMES') >= $access_level) {
232a25f0a04SGreg Roach            // Show all the NAME tags, including subtags
2338d0ebef0SGreg Roach            foreach ($this->facts(['NAME']) as $fact) {
234138ca96cSGreg Roach                $rec .= "\n" . $fact->gedcom();
235a25f0a04SGreg Roach            }
236a25f0a04SGreg Roach        }
237a25f0a04SGreg Roach        // Just show the 1 FAMC/FAMS tag, not any subtags, which may contain private data
2388d0ebef0SGreg Roach        preg_match_all('/\n1 (?:FAMC|FAMS) @(' . Gedcom::REGEX_XREF . ')@/', $this->gedcom, $matches, PREG_SET_ORDER);
239a25f0a04SGreg Roach        foreach ($matches as $match) {
2406b9cb339SGreg Roach            $rela = Registry::familyFactory()->make($match[1], $this->tree);
241a25f0a04SGreg Roach            if ($rela && ($SHOW_PRIVATE_RELATIONSHIPS || $rela->canShow($access_level))) {
242a25f0a04SGreg Roach                $rec .= $match[0];
243a25f0a04SGreg Roach            }
244a25f0a04SGreg Roach        }
245a25f0a04SGreg Roach        // Don’t privatize sex.
246a25f0a04SGreg Roach        if (preg_match('/\n1 SEX [MFU]/', $this->gedcom, $match)) {
247a25f0a04SGreg Roach            $rec .= $match[0];
248a25f0a04SGreg Roach        }
249a25f0a04SGreg Roach
250a25f0a04SGreg Roach        return $rec;
251a25f0a04SGreg Roach    }
252a25f0a04SGreg Roach
25376692c8bSGreg Roach    /**
254a25f0a04SGreg Roach     * Calculate whether this individual is living or dead.
255a25f0a04SGreg Roach     * If not known to be dead, then assume living.
256a25f0a04SGreg Roach     *
257cbc1590aSGreg Roach     * @return bool
258a25f0a04SGreg Roach     */
2598f53f488SRico Sonntag    public function isDead(): bool
260c1010edaSGreg Roach    {
261c4b3e5a2SGreg Roach        $MAX_ALIVE_AGE = (int) $this->tree->getPreference('MAX_ALIVE_AGE');
262d97083feSGreg Roach        $today_jd      = Registry::timestampFactory()->now()->julianDay();
263a25f0a04SGreg Roach
264a25f0a04SGreg Roach        // "1 DEAT Y" or "1 DEAT/2 DATE" or "1 DEAT/2 PLAC"
2658d0ebef0SGreg Roach        if (preg_match('/\n1 (?:' . implode('|', Gedcom::DEATH_EVENTS) . ')(?: Y|(?:\n[2-9].+)*\n2 (DATE|PLAC) )/', $this->gedcom)) {
266a25f0a04SGreg Roach            return true;
267a25f0a04SGreg Roach        }
268a25f0a04SGreg Roach
269e63974caSStefan Weil        // If any event occurred more than $MAX_ALIVE_AGE years ago, then assume the individual is dead
270a25f0a04SGreg Roach        if (preg_match_all('/\n2 DATE (.+)/', $this->gedcom, $date_matches)) {
271a25f0a04SGreg Roach            foreach ($date_matches[1] as $date_match) {
272a25f0a04SGreg Roach                $date = new Date($date_match);
273269fd10dSGreg Roach                if ($date->isOK() && $date->maximumJulianDay() <= $today_jd - 365 * $MAX_ALIVE_AGE) {
274a25f0a04SGreg Roach                    return true;
275a25f0a04SGreg Roach                }
276a25f0a04SGreg Roach            }
277a25f0a04SGreg Roach            // The individual has one or more dated events. All are less than $MAX_ALIVE_AGE years ago.
278a25f0a04SGreg Roach            // If one of these is a birth, the individual must be alive.
279a25f0a04SGreg Roach            if (preg_match('/\n1 BIRT(?:\n[2-9].+)*\n2 DATE /', $this->gedcom)) {
280a25f0a04SGreg Roach                return false;
281a25f0a04SGreg Roach            }
282a25f0a04SGreg Roach        }
283a25f0a04SGreg Roach
284a25f0a04SGreg Roach        // If we found no conclusive dates then check the dates of close relatives.
285a25f0a04SGreg Roach
286a25f0a04SGreg Roach        // Check parents (birth and adopted)
28739ca88baSGreg Roach        foreach ($this->childFamilies(Auth::PRIV_HIDE) as $family) {
28839ca88baSGreg Roach            foreach ($family->spouses(Auth::PRIV_HIDE) as $parent) {
289a25f0a04SGreg Roach                // Assume parents are no more than 45 years older than their children
290a25f0a04SGreg Roach                preg_match_all('/\n2 DATE (.+)/', $parent->gedcom, $date_matches);
291a25f0a04SGreg Roach                foreach ($date_matches[1] as $date_match) {
292a25f0a04SGreg Roach                    $date = new Date($date_match);
293269fd10dSGreg Roach                    if ($date->isOK() && $date->maximumJulianDay() <= $today_jd - 365 * ($MAX_ALIVE_AGE + 45)) {
294a25f0a04SGreg Roach                        return true;
295a25f0a04SGreg Roach                    }
296a25f0a04SGreg Roach                }
297a25f0a04SGreg Roach            }
298a25f0a04SGreg Roach        }
299a25f0a04SGreg Roach
300a25f0a04SGreg Roach        // Check spouses
30139ca88baSGreg Roach        foreach ($this->spouseFamilies(Auth::PRIV_HIDE) as $family) {
302a25f0a04SGreg Roach            preg_match_all('/\n2 DATE (.+)/', $family->gedcom, $date_matches);
303a25f0a04SGreg Roach            foreach ($date_matches[1] as $date_match) {
304a25f0a04SGreg Roach                $date = new Date($date_match);
305a25f0a04SGreg Roach                // Assume marriage occurs after age of 10
306269fd10dSGreg Roach                if ($date->isOK() && $date->maximumJulianDay() <= $today_jd - 365 * ($MAX_ALIVE_AGE - 10)) {
307a25f0a04SGreg Roach                    return true;
308a25f0a04SGreg Roach                }
309a25f0a04SGreg Roach            }
310a25f0a04SGreg Roach            // Check spouse dates
31139ca88baSGreg Roach            $spouse = $family->spouse($this, Auth::PRIV_HIDE);
312a25f0a04SGreg Roach            if ($spouse) {
313a25f0a04SGreg Roach                preg_match_all('/\n2 DATE (.+)/', $spouse->gedcom, $date_matches);
314a25f0a04SGreg Roach                foreach ($date_matches[1] as $date_match) {
315a25f0a04SGreg Roach                    $date = new Date($date_match);
316a25f0a04SGreg Roach                    // Assume max age difference between spouses of 40 years
317269fd10dSGreg Roach                    if ($date->isOK() && $date->maximumJulianDay() <= $today_jd - 365 * ($MAX_ALIVE_AGE + 40)) {
318a25f0a04SGreg Roach                        return true;
319a25f0a04SGreg Roach                    }
320a25f0a04SGreg Roach                }
321a25f0a04SGreg Roach            }
322a25f0a04SGreg Roach            // Check child dates
32339ca88baSGreg Roach            foreach ($family->children(Auth::PRIV_HIDE) as $child) {
324a25f0a04SGreg Roach                preg_match_all('/\n2 DATE (.+)/', $child->gedcom, $date_matches);
325a25f0a04SGreg Roach                // Assume children born after age of 15
326a25f0a04SGreg Roach                foreach ($date_matches[1] as $date_match) {
327a25f0a04SGreg Roach                    $date = new Date($date_match);
328269fd10dSGreg Roach                    if ($date->isOK() && $date->maximumJulianDay() <= $today_jd - 365 * ($MAX_ALIVE_AGE - 15)) {
329a25f0a04SGreg Roach                        return true;
330a25f0a04SGreg Roach                    }
331a25f0a04SGreg Roach                }
332a25f0a04SGreg Roach                // Check grandchildren
33339ca88baSGreg Roach                foreach ($child->spouseFamilies(Auth::PRIV_HIDE) as $child_family) {
33439ca88baSGreg Roach                    foreach ($child_family->children(Auth::PRIV_HIDE) as $grandchild) {
335a25f0a04SGreg Roach                        preg_match_all('/\n2 DATE (.+)/', $grandchild->gedcom, $date_matches);
336a25f0a04SGreg Roach                        // Assume grandchildren born after age of 30
337a25f0a04SGreg Roach                        foreach ($date_matches[1] as $date_match) {
338a25f0a04SGreg Roach                            $date = new Date($date_match);
339269fd10dSGreg Roach                            if ($date->isOK() && $date->maximumJulianDay() <= $today_jd - 365 * ($MAX_ALIVE_AGE - 30)) {
340a25f0a04SGreg Roach                                return true;
341a25f0a04SGreg Roach                            }
342a25f0a04SGreg Roach                        }
343a25f0a04SGreg Roach                    }
344a25f0a04SGreg Roach                }
345a25f0a04SGreg Roach            }
346a25f0a04SGreg Roach        }
347a25f0a04SGreg Roach
348a25f0a04SGreg Roach        return false;
349a25f0a04SGreg Roach    }
350a25f0a04SGreg Roach
351a25f0a04SGreg Roach    /**
352a25f0a04SGreg Roach     * Find the highlighted media object for an individual
353a25f0a04SGreg Roach     *
354e364afe4SGreg Roach     * @return MediaFile|null
355a25f0a04SGreg Roach     */
356e364afe4SGreg Roach    public function findHighlightedMediaFile(): ?MediaFile
357c1010edaSGreg Roach    {
35892647683SGreg Roach        $fact = $this->facts(['OBJE'])
35919d319e7SGreg Roach            ->first(static function (Fact $fact): bool {
360dc124885SGreg Roach                $media = $fact->target();
36119d319e7SGreg Roach
36219d319e7SGreg Roach                return $media instanceof Media && $media->firstImageFile() instanceof MediaFile;
36319d319e7SGreg Roach            });
36419d319e7SGreg Roach
36592647683SGreg Roach        if ($fact instanceof Fact && $fact->target() instanceof Media) {
36692647683SGreg Roach            return $fact->target()->firstImageFile();
367a25f0a04SGreg Roach        }
368a25f0a04SGreg Roach
369a25f0a04SGreg Roach        return null;
370a25f0a04SGreg Roach    }
371a25f0a04SGreg Roach
372a25f0a04SGreg Roach    /**
3737b0d562eSGreg Roach     * Display the preferred image for this individual.
374a25f0a04SGreg Roach     * Use an icon if no image is available.
375a25f0a04SGreg Roach     *
376dce07401SGreg Roach     * @param int           $width      Pixels
377dce07401SGreg Roach     * @param int           $height     Pixels
378dce07401SGreg Roach     * @param string        $fit        "crop" or "contain"
37909482a55SGreg Roach     * @param array<string> $attributes Additional HTML attributes
380dce07401SGreg Roach     *
381a25f0a04SGreg Roach     * @return string
382a25f0a04SGreg Roach     */
38324f2a3afSGreg Roach    public function displayImage(int $width, int $height, string $fit, array $attributes): string
384c1010edaSGreg Roach    {
3854a9f750fSGreg Roach        $media_file = $this->findHighlightedMediaFile();
3864a9f750fSGreg Roach
3874a9f750fSGreg Roach        if ($media_file !== null) {
3884a9f750fSGreg Roach            return $media_file->displayImage($width, $height, $fit, $attributes);
389a25f0a04SGreg Roach        }
3904a9f750fSGreg Roach
3914a9f750fSGreg Roach        if ($this->tree->getPreference('USE_SILHOUETTE')) {
39268b631f1SGreg Roach            return '<i class="icon-silhouette icon-silhouette-' . strtolower($this->sex()) . ' wt-icon-flip-rtl"></i>';
3934a9f750fSGreg Roach        }
3944a9f750fSGreg Roach
3954a9f750fSGreg Roach        return '';
396a25f0a04SGreg Roach    }
397a25f0a04SGreg Roach
398a25f0a04SGreg Roach    /**
399a25f0a04SGreg Roach     * Get the date of birth
400a25f0a04SGreg Roach     *
401a25f0a04SGreg Roach     * @return Date
402a25f0a04SGreg Roach     */
4038f53f488SRico Sonntag    public function getBirthDate(): Date
404c1010edaSGreg Roach    {
405a25f0a04SGreg Roach        foreach ($this->getAllBirthDates() as $date) {
406a25f0a04SGreg Roach            if ($date->isOK()) {
407a25f0a04SGreg Roach                return $date;
408a25f0a04SGreg Roach            }
409a25f0a04SGreg Roach        }
410a25f0a04SGreg Roach
411a25f0a04SGreg Roach        return new Date('');
412a25f0a04SGreg Roach    }
413a25f0a04SGreg Roach
414a25f0a04SGreg Roach    /**
415a25f0a04SGreg Roach     * Get the place of birth
416a25f0a04SGreg Roach     *
41716d0b7f7SRico Sonntag     * @return Place
418a25f0a04SGreg Roach     */
4198f53f488SRico Sonntag    public function getBirthPlace(): Place
420c1010edaSGreg Roach    {
421a25f0a04SGreg Roach        foreach ($this->getAllBirthPlaces() as $place) {
422a25f0a04SGreg Roach            return $place;
423a25f0a04SGreg Roach        }
424a25f0a04SGreg Roach
425b20ddbf9SGreg Roach        return new Place('', $this->tree);
426a25f0a04SGreg Roach    }
427a25f0a04SGreg Roach
428a25f0a04SGreg Roach    /**
429a25f0a04SGreg Roach     * Get the date of death
430a25f0a04SGreg Roach     *
431a25f0a04SGreg Roach     * @return Date
432a25f0a04SGreg Roach     */
4338f53f488SRico Sonntag    public function getDeathDate(): Date
434c1010edaSGreg Roach    {
435a25f0a04SGreg Roach        foreach ($this->getAllDeathDates() as $date) {
436a25f0a04SGreg Roach            if ($date->isOK()) {
437a25f0a04SGreg Roach                return $date;
438a25f0a04SGreg Roach            }
439a25f0a04SGreg Roach        }
440a25f0a04SGreg Roach
441a25f0a04SGreg Roach        return new Date('');
442a25f0a04SGreg Roach    }
443a25f0a04SGreg Roach
444a25f0a04SGreg Roach    /**
445a25f0a04SGreg Roach     * Get the place of death
446a25f0a04SGreg Roach     *
44716d0b7f7SRico Sonntag     * @return Place
448a25f0a04SGreg Roach     */
4498f53f488SRico Sonntag    public function getDeathPlace(): Place
450c1010edaSGreg Roach    {
451a25f0a04SGreg Roach        foreach ($this->getAllDeathPlaces() as $place) {
452a25f0a04SGreg Roach            return $place;
453a25f0a04SGreg Roach        }
454a25f0a04SGreg Roach
455b20ddbf9SGreg Roach        return new Place('', $this->tree);
456a25f0a04SGreg Roach    }
457a25f0a04SGreg Roach
458a25f0a04SGreg Roach    /**
459a25f0a04SGreg Roach     * Get the range of years in which a individual lived. e.g. “1870–”, “1870–1920”, “–1920”.
46015d603e7SGreg Roach     * Provide the place and full date using a tooltip.
461a25f0a04SGreg Roach     * For consistent layout in charts, etc., show just a “–” when no dates are known.
462a25f0a04SGreg Roach     * Note that this is a (non-breaking) en-dash, and not a hyphen.
463a25f0a04SGreg Roach     *
464a25f0a04SGreg Roach     * @return string
465a25f0a04SGreg Roach     */
4665e6816beSGreg Roach    public function lifespan(): string
467c1010edaSGreg Roach    {
46853f5ca04SGreg Roach        // Just the first part of the place name.
469392561bbSGreg Roach        $birth_place = strip_tags($this->getBirthPlace()->shortName());
470392561bbSGreg Roach        $death_place = strip_tags($this->getDeathPlace()->shortName());
47153f5ca04SGreg Roach
47281b9dc5dSGreg Roach        // Remove markup from dates.  Use UTF_FSI / UTF_PDI instead of <bdi></bdi>, as
47381b9dc5dSGreg Roach        // we cannot use HTML markup in title attributes.
47481b9dc5dSGreg Roach        $birth_date = "\u{2068}" . strip_tags($this->getBirthDate()->display()) . "\u{2069}";
47581b9dc5dSGreg Roach        $death_date = "\u{2068}" . strip_tags($this->getDeathDate()->display()) . "\u{2069}";
47615d603e7SGreg Roach
47753f5ca04SGreg Roach        // Use minimum and maximum dates - to agree with the age calculations.
47853f5ca04SGreg Roach        $birth_year = $this->getBirthDate()->minimumDate()->format('%Y');
47953f5ca04SGreg Roach        $death_year = $this->getDeathDate()->maximumDate()->format('%Y');
48053f5ca04SGreg Roach
481*f94b830fSGreg Roach        if ($birth_year === '') {
482*f94b830fSGreg Roach            $birth_year = I18N::translate('…');
483*f94b830fSGreg Roach        }
484*f94b830fSGreg Roach
4857ecbeefdSGreg Roach        if ($death_year === '' && $this->isDead()) {
4867ecbeefdSGreg Roach            $death_year = I18N::translate('…');
4877ecbeefdSGreg Roach        }
4887ecbeefdSGreg Roach
489c1010edaSGreg Roach        /* I18N: A range of years, e.g. “1870–”, “1870–1920”, “–1920” */
490dacfe33cSGreg Roach        return I18N::translate(
491a25f0a04SGreg Roach            '%1$s–%2$s',
49253f5ca04SGreg Roach            '<span title="' . $birth_place . ' ' . $birth_date . '">' . $birth_year . '</span>',
49353f5ca04SGreg Roach            '<span title="' . $death_place . ' ' . $death_date . '">' . $death_year . '</span>'
494a25f0a04SGreg Roach        );
495a25f0a04SGreg Roach    }
496a25f0a04SGreg Roach
497a25f0a04SGreg Roach    /**
498a25f0a04SGreg Roach     * Get all the birth dates - for the individual lists.
499a25f0a04SGreg Roach     *
50009482a55SGreg Roach     * @return array<Date>
501a25f0a04SGreg Roach     */
5028f53f488SRico Sonntag    public function getAllBirthDates(): array
503c1010edaSGreg Roach    {
5048d0ebef0SGreg Roach        foreach (Gedcom::BIRTH_EVENTS as $event) {
505d240bb87SGreg Roach            $dates = $this->getAllEventDates([$event]);
506d240bb87SGreg Roach
507d240bb87SGreg Roach            if ($dates !== []) {
508d240bb87SGreg Roach                return $dates;
509a25f0a04SGreg Roach            }
510a25f0a04SGreg Roach        }
511a25f0a04SGreg Roach
51213abd6f3SGreg Roach        return [];
513a25f0a04SGreg Roach    }
514a25f0a04SGreg Roach
515a25f0a04SGreg Roach    /**
516a25f0a04SGreg Roach     * Gat all the birth places - for the individual lists.
517a25f0a04SGreg Roach     *
51809482a55SGreg Roach     * @return array<Place>
519a25f0a04SGreg Roach     */
5208f53f488SRico Sonntag    public function getAllBirthPlaces(): array
521c1010edaSGreg Roach    {
5228d0ebef0SGreg Roach        foreach (Gedcom::BIRTH_EVENTS as $event) {
5238d0ebef0SGreg Roach            $places = $this->getAllEventPlaces([$event]);
524d240bb87SGreg Roach
52554c1ab5eSGreg Roach            if ($places !== []) {
5264080d558SGreg Roach                return $places;
527a25f0a04SGreg Roach            }
528a25f0a04SGreg Roach        }
529a25f0a04SGreg Roach
53013abd6f3SGreg Roach        return [];
531a25f0a04SGreg Roach    }
532a25f0a04SGreg Roach
533a25f0a04SGreg Roach    /**
534a25f0a04SGreg Roach     * Get all the death dates - for the individual lists.
535a25f0a04SGreg Roach     *
53609482a55SGreg Roach     * @return array<Date>
537a25f0a04SGreg Roach     */
5388f53f488SRico Sonntag    public function getAllDeathDates(): array
539c1010edaSGreg Roach    {
5408d0ebef0SGreg Roach        foreach (Gedcom::DEATH_EVENTS as $event) {
541d240bb87SGreg Roach            $dates = $this->getAllEventDates([$event]);
542d240bb87SGreg Roach
543d240bb87SGreg Roach            if ($dates !== []) {
544d240bb87SGreg Roach                return $dates;
545a25f0a04SGreg Roach            }
546a25f0a04SGreg Roach        }
547a25f0a04SGreg Roach
54813abd6f3SGreg Roach        return [];
549a25f0a04SGreg Roach    }
550a25f0a04SGreg Roach
551a25f0a04SGreg Roach    /**
552a25f0a04SGreg Roach     * Get all the death places - for the individual lists.
553a25f0a04SGreg Roach     *
55409482a55SGreg Roach     * @return array<Place>
555a25f0a04SGreg Roach     */
5568f53f488SRico Sonntag    public function getAllDeathPlaces(): array
557c1010edaSGreg Roach    {
5588d0ebef0SGreg Roach        foreach (Gedcom::DEATH_EVENTS as $event) {
5598d0ebef0SGreg Roach            $places = $this->getAllEventPlaces([$event]);
560d240bb87SGreg Roach
56154c1ab5eSGreg Roach            if ($places !== []) {
5624080d558SGreg Roach                return $places;
563a25f0a04SGreg Roach            }
564a25f0a04SGreg Roach        }
565a25f0a04SGreg Roach
56613abd6f3SGreg Roach        return [];
567a25f0a04SGreg Roach    }
568a25f0a04SGreg Roach
569a25f0a04SGreg Roach    /**
570a25f0a04SGreg Roach     * Generate an estimate for the date of birth, based on dates of parents/children/spouses
571a25f0a04SGreg Roach     *
572a25f0a04SGreg Roach     * @return Date
573a25f0a04SGreg Roach     */
5748f53f488SRico Sonntag    public function getEstimatedBirthDate(): Date
575c1010edaSGreg Roach    {
5768f038c36SRico Sonntag        if ($this->estimated_birth_date === null) {
577a25f0a04SGreg Roach            foreach ($this->getAllBirthDates() as $date) {
578a25f0a04SGreg Roach                if ($date->isOK()) {
5794686330aSGreg Roach                    $this->estimated_birth_date = $date;
580a25f0a04SGreg Roach                    break;
581a25f0a04SGreg Roach                }
582a25f0a04SGreg Roach            }
5838f038c36SRico Sonntag            if ($this->estimated_birth_date === null) {
58413abd6f3SGreg Roach                $min = [];
58513abd6f3SGreg Roach                $max = [];
586a25f0a04SGreg Roach                $tmp = $this->getDeathDate();
587f5b60decSGreg Roach                if ($tmp->isOK()) {
588f5b60decSGreg Roach                    $min[] = $tmp->minimumJulianDay() - $this->tree->getPreference('MAX_ALIVE_AGE') * 365;
589f5b60decSGreg Roach                    $max[] = $tmp->maximumJulianDay();
590a25f0a04SGreg Roach                }
59139ca88baSGreg Roach                foreach ($this->childFamilies() as $family) {
592a25f0a04SGreg Roach                    $tmp = $family->getMarriageDate();
593f5b60decSGreg Roach                    if ($tmp->isOK()) {
594f5b60decSGreg Roach                        $min[] = $tmp->maximumJulianDay() - 365 * 1;
595f5b60decSGreg Roach                        $max[] = $tmp->minimumJulianDay() + 365 * 30;
596a25f0a04SGreg Roach                    }
59739ca88baSGreg Roach                    $husband = $family->husband();
598e364afe4SGreg Roach                    if ($husband instanceof self) {
5992e5b4452SGreg Roach                        $tmp = $husband->getBirthDate();
600f5b60decSGreg Roach                        if ($tmp->isOK()) {
601f5b60decSGreg Roach                            $min[] = $tmp->maximumJulianDay() + 365 * 15;
602f5b60decSGreg Roach                            $max[] = $tmp->minimumJulianDay() + 365 * 65;
603a25f0a04SGreg Roach                        }
604a25f0a04SGreg Roach                    }
60539ca88baSGreg Roach                    $wife = $family->wife();
606e364afe4SGreg Roach                    if ($wife instanceof self) {
6072e5b4452SGreg Roach                        $tmp = $wife->getBirthDate();
608f5b60decSGreg Roach                        if ($tmp->isOK()) {
609f5b60decSGreg Roach                            $min[] = $tmp->maximumJulianDay() + 365 * 15;
610f5b60decSGreg Roach                            $max[] = $tmp->minimumJulianDay() + 365 * 45;
611a25f0a04SGreg Roach                        }
612a25f0a04SGreg Roach                    }
61339ca88baSGreg Roach                    foreach ($family->children() as $child) {
614a25f0a04SGreg Roach                        $tmp = $child->getBirthDate();
615f5b60decSGreg Roach                        if ($tmp->isOK()) {
616f5b60decSGreg Roach                            $min[] = $tmp->maximumJulianDay() - 365 * 30;
617f5b60decSGreg Roach                            $max[] = $tmp->minimumJulianDay() + 365 * 30;
618a25f0a04SGreg Roach                        }
619a25f0a04SGreg Roach                    }
620a25f0a04SGreg Roach                }
62139ca88baSGreg Roach                foreach ($this->spouseFamilies() as $family) {
622a25f0a04SGreg Roach                    $tmp = $family->getMarriageDate();
623f5b60decSGreg Roach                    if ($tmp->isOK()) {
624f5b60decSGreg Roach                        $min[] = $tmp->maximumJulianDay() - 365 * 45;
625f5b60decSGreg Roach                        $max[] = $tmp->minimumJulianDay() - 365 * 15;
626a25f0a04SGreg Roach                    }
62739ca88baSGreg Roach                    $spouse = $family->spouse($this);
628a25f0a04SGreg Roach                    if ($spouse) {
629a25f0a04SGreg Roach                        $tmp = $spouse->getBirthDate();
630f5b60decSGreg Roach                        if ($tmp->isOK()) {
631f5b60decSGreg Roach                            $min[] = $tmp->maximumJulianDay() - 365 * 25;
632f5b60decSGreg Roach                            $max[] = $tmp->minimumJulianDay() + 365 * 25;
633a25f0a04SGreg Roach                        }
634a25f0a04SGreg Roach                    }
63539ca88baSGreg Roach                    foreach ($family->children() as $child) {
636a25f0a04SGreg Roach                        $tmp = $child->getBirthDate();
637f5b60decSGreg Roach                        if ($tmp->isOK()) {
638e364afe4SGreg Roach                            $min[] = $tmp->maximumJulianDay() - 365 * ($this->sex() === 'F' ? 45 : 65);
639f5b60decSGreg Roach                            $max[] = $tmp->minimumJulianDay() - 365 * 15;
640a25f0a04SGreg Roach                        }
641a25f0a04SGreg Roach                    }
642a25f0a04SGreg Roach                }
643a25f0a04SGreg Roach                if ($min && $max) {
64459f2f229SGreg Roach                    $gregorian_calendar = new GregorianCalendar();
645a25f0a04SGreg Roach
64665e02381SGreg Roach                    [$year] = $gregorian_calendar->jdToYmd(intdiv(max($min) + min($max), 2));
6474686330aSGreg Roach                    $this->estimated_birth_date = new Date('EST ' . $year);
648a25f0a04SGreg Roach                } else {
6494686330aSGreg Roach                    $this->estimated_birth_date = new Date(''); // always return a date object
650a25f0a04SGreg Roach                }
651a25f0a04SGreg Roach            }
652a25f0a04SGreg Roach        }
653a25f0a04SGreg Roach
6544686330aSGreg Roach        return $this->estimated_birth_date;
655a25f0a04SGreg Roach    }
656a25f0a04SGreg Roach
657a25f0a04SGreg Roach    /**
658a25f0a04SGreg Roach     * Generate an estimated date of death.
659a25f0a04SGreg Roach     *
660a25f0a04SGreg Roach     * @return Date
661a25f0a04SGreg Roach     */
6628f53f488SRico Sonntag    public function getEstimatedDeathDate(): Date
663c1010edaSGreg Roach    {
6644686330aSGreg Roach        if ($this->estimated_death_date === null) {
665a25f0a04SGreg Roach            foreach ($this->getAllDeathDates() as $date) {
666a25f0a04SGreg Roach                if ($date->isOK()) {
6674686330aSGreg Roach                    $this->estimated_death_date = $date;
668a25f0a04SGreg Roach                    break;
669a25f0a04SGreg Roach                }
670a25f0a04SGreg Roach            }
6714686330aSGreg Roach            if ($this->estimated_death_date === null) {
672f5b60decSGreg Roach                if ($this->getEstimatedBirthDate()->minimumJulianDay()) {
673c4b3e5a2SGreg Roach                    $max_alive_age              = (int) $this->tree->getPreference('MAX_ALIVE_AGE');
6744686330aSGreg Roach                    $this->estimated_death_date = $this->getEstimatedBirthDate()->addYears($max_alive_age, 'BEF');
675a25f0a04SGreg Roach                } else {
6764686330aSGreg Roach                    $this->estimated_death_date = new Date(''); // always return a date object
677a25f0a04SGreg Roach                }
678a25f0a04SGreg Roach            }
679a25f0a04SGreg Roach        }
680a25f0a04SGreg Roach
6814686330aSGreg Roach        return $this->estimated_death_date;
682a25f0a04SGreg Roach    }
683a25f0a04SGreg Roach
684a25f0a04SGreg Roach    /**
685a25f0a04SGreg Roach     * Get the sex - M F or U
686a25f0a04SGreg Roach     * Use the un-privatised gedcom record. We call this function during
687a25f0a04SGreg Roach     * the privatize-gedcom function, and we are allowed to know this.
688a25f0a04SGreg Roach     *
689a25f0a04SGreg Roach     * @return string
690a25f0a04SGreg Roach     */
691e364afe4SGreg Roach    public function sex(): string
692c1010edaSGreg Roach    {
6931baf69deSGreg Roach        if (preg_match('/\n1 SEX ([MFX])/', $this->gedcom . $this->pending, $match)) {
694a25f0a04SGreg Roach            return $match[1];
695a25f0a04SGreg Roach        }
696b2ce94c6SRico Sonntag
697b2ce94c6SRico Sonntag        return 'U';
698a25f0a04SGreg Roach    }
699a25f0a04SGreg Roach
700a25f0a04SGreg Roach    /**
701a25f0a04SGreg Roach     * Get a list of this individual’s spouse families
702a25f0a04SGreg Roach     *
703cbc1590aSGreg Roach     * @param int|null $access_level
704a25f0a04SGreg Roach     *
70536779af1SGreg Roach     * @return Collection<int,Family>
706a25f0a04SGreg Roach     */
70773d58381SGreg Roach    public function spouseFamilies(int $access_level = null): Collection
708c1010edaSGreg Roach    {
7093529c469SGreg Roach        $access_level ??= Auth::accessLevel($this->tree);
710d9e083e7SGreg Roach
711d9e083e7SGreg Roach        if ($this->tree->getPreference('SHOW_PRIVATE_RELATIONSHIPS') === '1') {
712d9e083e7SGreg Roach            $access_level = Auth::PRIV_HIDE;
7134b9ff166SGreg Roach        }
7144b9ff166SGreg Roach
71539ca88baSGreg Roach        $families = new Collection();
716d9e083e7SGreg Roach        foreach ($this->facts(['FAMS'], false, $access_level) as $fact) {
717dc124885SGreg Roach            $family = $fact->target();
718d9e083e7SGreg Roach            if ($family instanceof Family && $family->canShow($access_level)) {
71939ca88baSGreg Roach                $families->push($family);
720a25f0a04SGreg Roach            }
721a25f0a04SGreg Roach        }
722a25f0a04SGreg Roach
72339ca88baSGreg Roach        return new Collection($families);
724a25f0a04SGreg Roach    }
725a25f0a04SGreg Roach
726a25f0a04SGreg Roach    /**
727a25f0a04SGreg Roach     * Get the current spouse of this individual.
728a25f0a04SGreg Roach     *
729a25f0a04SGreg Roach     * Where an individual has multiple spouses, assume they are stored
730a25f0a04SGreg Roach     * in chronological order, and take the last one found.
731a25f0a04SGreg Roach     *
732a25f0a04SGreg Roach     * @return Individual|null
733a25f0a04SGreg Roach     */
734e364afe4SGreg Roach    public function getCurrentSpouse(): ?Individual
735c1010edaSGreg Roach    {
73639ca88baSGreg Roach        $family = $this->spouseFamilies()->last();
73739ca88baSGreg Roach
73839ca88baSGreg Roach        if ($family instanceof Family) {
73939ca88baSGreg Roach            return $family->spouse($this);
740a25f0a04SGreg Roach        }
741b2ce94c6SRico Sonntag
742b2ce94c6SRico Sonntag        return null;
743a25f0a04SGreg Roach    }
744a25f0a04SGreg Roach
745a25f0a04SGreg Roach    /**
746a25f0a04SGreg Roach     * Count the children belonging to this individual.
747a25f0a04SGreg Roach     *
748cbc1590aSGreg Roach     * @return int
749a25f0a04SGreg Roach     */
750e364afe4SGreg Roach    public function numberOfChildren(): int
751c1010edaSGreg Roach    {
7527d0db648SGreg Roach        if (preg_match('/\n1 NCHI (\d+)(?:\n|$)/', $this->gedcom(), $match)) {
7533dc7bbe9SGreg Roach            return (int) $match[1];
754b2ce94c6SRico Sonntag        }
755b2ce94c6SRico Sonntag
75613abd6f3SGreg Roach        $children = [];
75739ca88baSGreg Roach        foreach ($this->spouseFamilies() as $fam) {
75839ca88baSGreg Roach            foreach ($fam->children() as $child) {
759c0935879SGreg Roach                $children[$child->xref()] = true;
760a25f0a04SGreg Roach            }
761a25f0a04SGreg Roach        }
762a25f0a04SGreg Roach
763a25f0a04SGreg Roach        return count($children);
764a25f0a04SGreg Roach    }
765a25f0a04SGreg Roach
766a25f0a04SGreg Roach    /**
767a25f0a04SGreg Roach     * Get a list of this individual’s child families (i.e. their parents).
768a25f0a04SGreg Roach     *
769cbc1590aSGreg Roach     * @param int|null $access_level
770a25f0a04SGreg Roach     *
77136779af1SGreg Roach     * @return Collection<int,Family>
772a25f0a04SGreg Roach     */
77373d58381SGreg Roach    public function childFamilies(int $access_level = null): Collection
774c1010edaSGreg Roach    {
7753529c469SGreg Roach        $access_level ??= Auth::accessLevel($this->tree);
7764b9ff166SGreg Roach
777d9e083e7SGreg Roach        if ($this->tree->getPreference('SHOW_PRIVATE_RELATIONSHIPS') === '1') {
778d9e083e7SGreg Roach            $access_level = Auth::PRIV_HIDE;
779d9e083e7SGreg Roach        }
780a25f0a04SGreg Roach
78139ca88baSGreg Roach        $families = new Collection();
78239ca88baSGreg Roach
783d9e083e7SGreg Roach        foreach ($this->facts(['FAMC'], false, $access_level) as $fact) {
784dc124885SGreg Roach            $family = $fact->target();
785d9e083e7SGreg Roach            if ($family instanceof Family && $family->canShow($access_level)) {
78639ca88baSGreg Roach                $families->push($family);
787a25f0a04SGreg Roach            }
788a25f0a04SGreg Roach        }
789a25f0a04SGreg Roach
790a25f0a04SGreg Roach        return $families;
791a25f0a04SGreg Roach    }
792a25f0a04SGreg Roach
793a25f0a04SGreg Roach    /**
794a25f0a04SGreg Roach     * Get a list of step-parent families.
795a25f0a04SGreg Roach     *
79636779af1SGreg Roach     * @return Collection<int,Family>
797a25f0a04SGreg Roach     */
798820b62dfSGreg Roach    public function childStepFamilies(): Collection
799c1010edaSGreg Roach    {
800ed5b6227SGreg Roach        $step_families = new Collection();
80139ca88baSGreg Roach        $families      = $this->childFamilies();
802a25f0a04SGreg Roach        foreach ($families as $family) {
803ed5b6227SGreg Roach            foreach ($family->spouses() as $parent) {
804ed5b6227SGreg Roach                foreach ($parent->spouseFamilies() as $step_family) {
80539ca88baSGreg Roach                    if (!$families->containsStrict($step_family)) {
806ed5b6227SGreg Roach                        $step_families->add($step_family);
807a25f0a04SGreg Roach                    }
808a25f0a04SGreg Roach                }
809a25f0a04SGreg Roach            }
810a25f0a04SGreg Roach        }
811a25f0a04SGreg Roach
8128c627a69SGreg Roach        return $step_families->uniqueStrict(static function (Family $family): string {
8138c627a69SGreg Roach            return $family->xref();
8148c627a69SGreg Roach        });
815a25f0a04SGreg Roach    }
816a25f0a04SGreg Roach
817a25f0a04SGreg Roach    /**
818a25f0a04SGreg Roach     * Get a list of step-parent families.
819a25f0a04SGreg Roach     *
82036779af1SGreg Roach     * @return Collection<int,Family>
821a25f0a04SGreg Roach     */
822820b62dfSGreg Roach    public function spouseStepFamilies(): Collection
823c1010edaSGreg Roach    {
82413abd6f3SGreg Roach        $step_families = [];
82539ca88baSGreg Roach        $families      = $this->spouseFamilies();
826820b62dfSGreg Roach
827a25f0a04SGreg Roach        foreach ($families as $family) {
82839ca88baSGreg Roach            $spouse = $family->spouse($this);
829820b62dfSGreg Roach
830d823340dSGreg Roach            if ($spouse instanceof self) {
83139ca88baSGreg Roach                foreach ($family->spouse($this)->spouseFamilies() as $step_family) {
83239ca88baSGreg Roach                    if (!$families->containsStrict($step_family)) {
833a25f0a04SGreg Roach                        $step_families[] = $step_family;
834a25f0a04SGreg Roach                    }
835a25f0a04SGreg Roach                }
836a25f0a04SGreg Roach            }
837a25f0a04SGreg Roach        }
838a25f0a04SGreg Roach
839820b62dfSGreg Roach        return new Collection($step_families);
840a25f0a04SGreg Roach    }
841a25f0a04SGreg Roach
842a25f0a04SGreg Roach    /**
843a25f0a04SGreg Roach     * A label for a parental family group
844a25f0a04SGreg Roach     *
845a25f0a04SGreg Roach     * @param Family $family
846a25f0a04SGreg Roach     *
847a25f0a04SGreg Roach     * @return string
848a25f0a04SGreg Roach     */
849820b62dfSGreg Roach    public function getChildFamilyLabel(Family $family): string
850c1010edaSGreg Roach    {
8510e7e67a6SGreg Roach        $fact = $this->facts(['FAMC'])->first(static fn (Fact $fact): bool => $fact->target() === $family);
8520e7e67a6SGreg Roach
8530e7e67a6SGreg Roach        if ($fact instanceof Fact) {
8540e7e67a6SGreg Roach            $pedigree = $fact->attribute('PEDI');
8550e7e67a6SGreg Roach        } else {
8560e7e67a6SGreg Roach            $pedigree = '';
8570e7e67a6SGreg Roach        }
858b2ce94c6SRico Sonntag
8597d70e4a7SGreg Roach        $values = [
86088a03560SGreg Roach            PedigreeLinkageType::VALUE_BIRTH   => I18N::translate('Family with parents'),
86188a03560SGreg Roach            PedigreeLinkageType::VALUE_ADOPTED => I18N::translate('Family with adoptive parents'),
86288a03560SGreg Roach            PedigreeLinkageType::VALUE_FOSTER  => I18N::translate('Family with foster parents'),
863665e281aSGreg Roach            /* I18N: “sealing” is a Mormon ceremony. */
86488a03560SGreg Roach            PedigreeLinkageType::VALUE_SEALING => I18N::translate('Family with sealing parents'),
865665e281aSGreg Roach            /* I18N: “rada” is an Arabic word, pronounced “ra DAH”. It is child-to-parent pedigree, established by wet-nursing. */
86688a03560SGreg Roach            PedigreeLinkageType::VALUE_RADA    => I18N::translate('Family with rada parents'),
8677d70e4a7SGreg Roach        ];
8687d70e4a7SGreg Roach
86988a03560SGreg Roach        return $values[$pedigree] ?? $values[PedigreeLinkageType::VALUE_BIRTH];
870a25f0a04SGreg Roach    }
871a25f0a04SGreg Roach
872a25f0a04SGreg Roach    /**
873a25f0a04SGreg Roach     * Create a label for a step family
874a25f0a04SGreg Roach     *
875a25f0a04SGreg Roach     * @param Family $step_family
876a25f0a04SGreg Roach     *
877a25f0a04SGreg Roach     * @return string
878a25f0a04SGreg Roach     */
8798f53f488SRico Sonntag    public function getStepFamilyLabel(Family $step_family): string
880c1010edaSGreg Roach    {
88139ca88baSGreg Roach        foreach ($this->childFamilies() as $family) {
882a25f0a04SGreg Roach            if ($family !== $step_family) {
883a25f0a04SGreg Roach                // Must be a step-family
88439ca88baSGreg Roach                foreach ($family->spouses() as $parent) {
88539ca88baSGreg Roach                    foreach ($step_family->spouses() as $step_parent) {
886a25f0a04SGreg Roach                        if ($parent === $step_parent) {
887a25f0a04SGreg Roach                            // One common parent - must be a step family
888e364afe4SGreg Roach                            if ($parent->sex() === 'M') {
889a25f0a04SGreg Roach                                // Father’s family with someone else
89039ca88baSGreg Roach                                if ($step_family->spouse($step_parent)) {
891a25f0a04SGreg Roach                                    /* I18N: A step-family. %s is an individual’s name */
89239ca88baSGreg Roach                                    return I18N::translate('Father’s family with %s', $step_family->spouse($step_parent)->fullName());
893b2ce94c6SRico Sonntag                                }
894b2ce94c6SRico Sonntag
895a25f0a04SGreg Roach                                /* I18N: A step-family. */
896bbb76c12SGreg Roach                                return I18N::translate('Father’s family with an unknown individual');
897a25f0a04SGreg Roach                            }
898b2ce94c6SRico Sonntag
899a25f0a04SGreg Roach                            // Mother’s family with someone else
90039ca88baSGreg Roach                            if ($step_family->spouse($step_parent)) {
901a25f0a04SGreg Roach                                /* I18N: A step-family. %s is an individual’s name */
90239ca88baSGreg Roach                                return I18N::translate('Mother’s family with %s', $step_family->spouse($step_parent)->fullName());
903b2ce94c6SRico Sonntag                            }
904b2ce94c6SRico Sonntag
905a25f0a04SGreg Roach                            /* I18N: A step-family. */
906bbb76c12SGreg Roach                            return I18N::translate('Mother’s family with an unknown individual');
907a25f0a04SGreg Roach                        }
908a25f0a04SGreg Roach                    }
909a25f0a04SGreg Roach                }
910a25f0a04SGreg Roach            }
911a25f0a04SGreg Roach        }
912a25f0a04SGreg Roach
913a25f0a04SGreg Roach        // Perahps same parents - but a different family record?
914a25f0a04SGreg Roach        return I18N::translate('Family with parents');
915a25f0a04SGreg Roach    }
916a25f0a04SGreg Roach
917225e381fSGreg Roach    /**
918225e381fSGreg Roach     * Get the description for the family.
919225e381fSGreg Roach     *
920225e381fSGreg Roach     * For example, "XXX's family with new wife".
921225e381fSGreg Roach     *
922225e381fSGreg Roach     * @param Family $family
923225e381fSGreg Roach     *
924225e381fSGreg Roach     * @return string
925225e381fSGreg Roach     */
926e364afe4SGreg Roach    public function getSpouseFamilyLabel(Family $family): string
927c1010edaSGreg Roach    {
92839ca88baSGreg Roach        $spouse = $family->spouse($this);
929225e381fSGreg Roach        if ($spouse) {
930225e381fSGreg Roach            /* I18N: %s is the spouse name */
93139ca88baSGreg Roach            return I18N::translate('Family with %s', $spouse->fullName());
932225e381fSGreg Roach        }
933b2ce94c6SRico Sonntag
93439ca88baSGreg Roach        return $family->fullName();
935225e381fSGreg Roach    }
936225e381fSGreg Roach
937a25f0a04SGreg Roach    /**
938961ec755SGreg Roach     * If this object has no name, what do we call it?
939961ec755SGreg Roach     *
940961ec755SGreg Roach     * @return string
941961ec755SGreg Roach     */
9428f53f488SRico Sonntag    public function getFallBackName(): string
943c1010edaSGreg Roach    {
944a25f0a04SGreg Roach        return '@P.N. /@N.N./';
945a25f0a04SGreg Roach    }
946a25f0a04SGreg Roach
947a25f0a04SGreg Roach    /**
948a25f0a04SGreg Roach     * Convert a name record into ‘full’ and ‘sort’ versions.
949a25f0a04SGreg Roach     * Use the NAME field to generate the ‘full’ version, as the
950a25f0a04SGreg Roach     * gedcom spec says that this is the individual’s name, as they would write it.
951a25f0a04SGreg Roach     * Use the SURN field to generate the sortable names. Note that this field
952a25f0a04SGreg Roach     * may also be used for the ‘true’ surname, perhaps spelt differently to that
953a25f0a04SGreg Roach     * recorded in the NAME field. e.g.
954a25f0a04SGreg Roach     *
955a25f0a04SGreg Roach     * 1 NAME Robert /de Gliderow/
956a25f0a04SGreg Roach     * 2 GIVN Robert
957a25f0a04SGreg Roach     * 2 SPFX de
958a25f0a04SGreg Roach     * 2 SURN CLITHEROW
959a25f0a04SGreg Roach     * 2 NICK The Bald
960a25f0a04SGreg Roach     *
961a25f0a04SGreg Roach     * full=>'Robert de Gliderow 'The Bald''
962a25f0a04SGreg Roach     * sort=>'CLITHEROW, ROBERT'
963a25f0a04SGreg Roach     *
964a25f0a04SGreg Roach     * Handle multiple surnames, either as;
965a25f0a04SGreg Roach     *
966a25f0a04SGreg Roach     * 1 NAME Carlos /Vasquez/ y /Sante/
967a25f0a04SGreg Roach     * or
968a25f0a04SGreg Roach     * 1 NAME Carlos /Vasquez y Sante/
969a25f0a04SGreg Roach     * 2 GIVN Carlos
970a25f0a04SGreg Roach     * 2 SURN Vasquez,Sante
971a25f0a04SGreg Roach     *
972a25f0a04SGreg Roach     * @param string $type
97351928f9aSGreg Roach     * @param string $value
974a25f0a04SGreg Roach     * @param string $gedcom
975e364afe4SGreg Roach     *
976e364afe4SGreg Roach     * @return void
977a25f0a04SGreg Roach     */
97851928f9aSGreg Roach    protected function addName(string $type, string $value, string $gedcom): void
979c1010edaSGreg Roach    {
980a25f0a04SGreg Roach        ////////////////////////////////////////////////////////////////////////////
981a25f0a04SGreg Roach        // Extract the structured name parts - use for "sortable" names and indexes
982a25f0a04SGreg Roach        ////////////////////////////////////////////////////////////////////////////
983a25f0a04SGreg Roach
98476f666f4SGreg Roach        $sublevel = 1 + (int) substr($gedcom, 0, 1);
985ef475b14SGreg Roach        $GIVN     = preg_match('/\n' . $sublevel . ' GIVN (.+)/', $gedcom, $match) === 1 ? $match[1] : '';
986ef475b14SGreg Roach        $SURN     = preg_match('/\n' . $sublevel . ' SURN (.+)/', $gedcom, $match) === 1 ? $match[1] : '';
987a25f0a04SGreg Roach
988a25f0a04SGreg Roach        // SURN is an comma-separated list of surnames...
98976f666f4SGreg Roach        if ($SURN !== '') {
990a25f0a04SGreg Roach            $SURNS = preg_split('/ *, */', $SURN);
991a25f0a04SGreg Roach        } else {
99213abd6f3SGreg Roach            $SURNS = [];
993a25f0a04SGreg Roach        }
99476f666f4SGreg Roach
995a25f0a04SGreg Roach        // ...so is GIVN - but nobody uses it like that
996a25f0a04SGreg Roach        $GIVN = str_replace('/ *, */', ' ', $GIVN);
997a25f0a04SGreg Roach
998a25f0a04SGreg Roach        ////////////////////////////////////////////////////////////////////////////
999a25f0a04SGreg Roach        // Extract the components from NAME - use for the "full" names
1000a25f0a04SGreg Roach        ////////////////////////////////////////////////////////////////////////////
1001a25f0a04SGreg Roach
1002a25f0a04SGreg Roach        // Fix bad slashes. e.g. 'John/Smith' => 'John/Smith/'
100351928f9aSGreg Roach        if (substr_count($value, '/') % 2 === 1) {
100451928f9aSGreg Roach            $value .= '/';
1005a25f0a04SGreg Roach        }
1006a25f0a04SGreg Roach
1007a25f0a04SGreg Roach        // GEDCOM uses "//" to indicate an unknown surname
100851928f9aSGreg Roach        $full = preg_replace('/\/\//', '/@N.N./', $value);
1009a25f0a04SGreg Roach
1010a25f0a04SGreg Roach        // Extract the surname.
1011a25f0a04SGreg Roach        // Note, there may be multiple surnames, e.g. Jean /Vasquez/ y /Cortes/
1012a25f0a04SGreg Roach        if (preg_match('/\/.*\//', $full, $match)) {
1013a25f0a04SGreg Roach            $surname = str_replace('/', '', $match[0]);
1014a25f0a04SGreg Roach        } else {
1015a25f0a04SGreg Roach            $surname = '';
1016a25f0a04SGreg Roach        }
1017a25f0a04SGreg Roach
1018a25f0a04SGreg Roach        // If we don’t have a SURN record, extract it from the NAME
1019a25f0a04SGreg Roach        if (!$SURNS) {
1020a25f0a04SGreg Roach            if (preg_match_all('/\/([^\/]*)\//', $full, $matches)) {
1021a25f0a04SGreg Roach                // There can be many surnames, each wrapped with '/'
1022a25f0a04SGreg Roach                $SURNS = $matches[1];
1023a25f0a04SGreg Roach                foreach ($SURNS as $n => $SURN) {
1024a25f0a04SGreg Roach                    // Remove surname prefixes, such as "van de ", "d'" and "'t " (lower case only)
1025a25f0a04SGreg Roach                    $SURNS[$n] = preg_replace('/^(?:[a-z]+ |[a-z]+\' ?|\'[a-z]+ )+/', '', $SURN);
1026a25f0a04SGreg Roach                }
1027a25f0a04SGreg Roach            } else {
1028a25f0a04SGreg Roach                // It is valid not to have a surname at all
102913abd6f3SGreg Roach                $SURNS = [''];
1030a25f0a04SGreg Roach            }
1031a25f0a04SGreg Roach        }
1032a25f0a04SGreg Roach
1033a25f0a04SGreg Roach        // If we don’t have a GIVN record, extract it from the NAME
1034a25f0a04SGreg Roach        if (!$GIVN) {
1035c1010edaSGreg Roach            // remove surname
1036c72b7fa4SGreg Roach            $GIVN = preg_replace('/ ?\/.*\/ ?/', ' ', $full);
1037c1010edaSGreg Roach            // remove nickname
1038c72b7fa4SGreg Roach            $GIVN = preg_replace('/ ?".+"/', ' ', $GIVN);
1039c1010edaSGreg Roach            // multiple spaces, caused by the above
1040c72b7fa4SGreg Roach            $GIVN = preg_replace('/ {2,}/', ' ', $GIVN);
1041c1010edaSGreg Roach            // leading/trailing spaces, caused by the above
1042c72b7fa4SGreg Roach            $GIVN = preg_replace('/^ | $/', '', $GIVN);
1043a25f0a04SGreg Roach        }
1044a25f0a04SGreg Roach
1045a25f0a04SGreg Roach        // Add placeholder for unknown given name
1046a25f0a04SGreg Roach        if (!$GIVN) {
1047d823340dSGreg Roach            $GIVN = self::PRAENOMEN_NESCIO;
104873f4f553SGreg Roach            $pos  = (int) strpos($full, '/');
1049a25f0a04SGreg Roach            $full = substr($full, 0, $pos) . '@P.N. ' . substr($full, $pos);
1050a25f0a04SGreg Roach        }
1051a25f0a04SGreg Roach
1052a25f0a04SGreg Roach        // Remove slashes - they don’t get displayed
1053a25f0a04SGreg Roach        // $fullNN keeps the @N.N. placeholders, for the database
1054a25f0a04SGreg Roach        // $full is for display on-screen
1055a25f0a04SGreg Roach        $fullNN = str_replace('/', '', $full);
1056a25f0a04SGreg Roach
1057a25f0a04SGreg Roach        // Insert placeholders for any missing/unknown names
1058d823340dSGreg Roach        $full = str_replace(self::NOMEN_NESCIO, I18N::translateContext('Unknown surname', '…'), $full);
1059d823340dSGreg Roach        $full = str_replace(self::PRAENOMEN_NESCIO, I18N::translateContext('Unknown given name', '…'), $full);
1060c6f196c3SGreg Roach        // Format for display
1061d53324c9SGreg Roach        $full = '<span class="NAME" dir="auto" translate="no">' . preg_replace('/\/([^\/]*)\//', '<span class="SURN">$1</span>', e($full)) . '</span>';
1062acc34ea1SGreg Roach        // Localise quotation marks around the nickname
10630b5fd0a6SGreg Roach        $full = preg_replace_callback('/&quot;([^&]*)&quot;/', static function (array $matches): string {
1064c652cdbdSGreg Roach            return '<q class="wt-nickname">' . $matches[1] . '</q>';
10658d68cabeSGreg Roach        }, $full);
1066a25f0a04SGreg Roach
1067c6f196c3SGreg Roach        // A suffix of “*” indicates a preferred name
1068ee51991cSGreg Roach        $full = preg_replace('/([^ >\x{200C}]*)\*/u', '<span class="starredname">\\1</span>', $full);
1069a25f0a04SGreg Roach
1070a25f0a04SGreg Roach        // Remove prefered-name indicater - they don’t go in the database
1071a25f0a04SGreg Roach        $GIVN   = str_replace('*', '', $GIVN);
1072a25f0a04SGreg Roach        $fullNN = str_replace('*', '', $fullNN);
1073a25f0a04SGreg Roach
1074ffd703eaSGreg Roach        foreach ($SURNS as $SURN) {
1075a25f0a04SGreg Roach            // Scottish 'Mc and Mac ' prefixes both sort under 'Mac'
1076e364afe4SGreg Roach            if (strcasecmp(substr($SURN, 0, 2), 'Mc') === 0) {
1077a25f0a04SGreg Roach                $SURN = substr_replace($SURN, 'Mac', 0, 2);
1078e364afe4SGreg Roach            } elseif (strcasecmp(substr($SURN, 0, 4), 'Mac ') === 0) {
1079a25f0a04SGreg Roach                $SURN = substr_replace($SURN, 'Mac', 0, 4);
1080a25f0a04SGreg Roach            }
1081a25f0a04SGreg Roach
1082bdb3725aSGreg Roach            $this->getAllNames[] = [
1083a25f0a04SGreg Roach                'type'    => $type,
1084a25f0a04SGreg Roach                'sort'    => $SURN . ',' . $GIVN,
1085c1010edaSGreg Roach                'full'    => $full,
1086c1010edaSGreg Roach                // This is used for display
1087c1010edaSGreg Roach                'fullNN'  => $fullNN,
1088c1010edaSGreg Roach                // This goes into the database
1089c1010edaSGreg Roach                'surname' => $surname,
1090c1010edaSGreg Roach                // This goes into the database
1091c1010edaSGreg Roach                'givn'    => $GIVN,
1092c1010edaSGreg Roach                // This goes into the database
1093c1010edaSGreg Roach                'surn'    => $SURN,
1094c1010edaSGreg Roach                // This goes into the database
109513abd6f3SGreg Roach            ];
1096a25f0a04SGreg Roach        }
1097a25f0a04SGreg Roach    }
1098a25f0a04SGreg Roach
1099a25f0a04SGreg Roach    /**
110076692c8bSGreg Roach     * Extract names from the GEDCOM record.
1101c7ff4153SGreg Roach     *
1102c7ff4153SGreg Roach     * @return void
1103a25f0a04SGreg Roach     */
1104e364afe4SGreg Roach    public function extractNames(): void
1105c1010edaSGreg Roach    {
1106d9e083e7SGreg Roach        $access_level = $this->canShowName() ? Auth::PRIV_HIDE : Auth::accessLevel($this->tree);
1107d9e083e7SGreg Roach
11088f53f488SRico Sonntag        $this->extractNamesFromFacts(
11098f53f488SRico Sonntag            1,
11108f53f488SRico Sonntag            'NAME',
1111d9e083e7SGreg Roach            $this->facts(['NAME'], false, $access_level)
11128f53f488SRico Sonntag        );
1113a25f0a04SGreg Roach    }
1114a25f0a04SGreg Roach
1115a25f0a04SGreg Roach    /**
1116a25f0a04SGreg Roach     * Extra info to display when displaying this record in a list of
1117a25f0a04SGreg Roach     * selection items or favorites.
1118a25f0a04SGreg Roach     *
1119a25f0a04SGreg Roach     * @return string
1120a25f0a04SGreg Roach     */
11218f53f488SRico Sonntag    public function formatListDetails(): string
1122c1010edaSGreg Roach    {
1123a25f0a04SGreg Roach        return
11248d0ebef0SGreg Roach            $this->formatFirstMajorFact(Gedcom::BIRTH_EVENTS, 1) .
11258d0ebef0SGreg Roach            $this->formatFirstMajorFact(Gedcom::DEATH_EVENTS, 1);
1126a25f0a04SGreg Roach    }
11278091bfd1SGreg Roach
11288091bfd1SGreg Roach    /**
11298091bfd1SGreg Roach     * Lock the database row, to prevent concurrent edits.
11308091bfd1SGreg Roach     */
11318091bfd1SGreg Roach    public function lock(): void
11328091bfd1SGreg Roach    {
11338091bfd1SGreg Roach        DB::table('individuals')
11348091bfd1SGreg Roach            ->where('i_file', '=', $this->tree->id())
11358091bfd1SGreg Roach            ->where('i_id', '=', $this->xref())
11368091bfd1SGreg Roach            ->lockForUpdate()
11378091bfd1SGreg Roach            ->get();
11388091bfd1SGreg Roach    }
1139a25f0a04SGreg Roach}
1140