xref: /webtrees/app/Statistics/Repository/GedcomRepository.php (revision d97083fe315dad9b7d0a150d4fb5f563e57d1869)
18add1155SRico Sonntag<?php
23976b470SGreg Roach
38add1155SRico Sonntag/**
48add1155SRico Sonntag * webtrees: online genealogy
589f7189bSGreg Roach * Copyright (C) 2021 webtrees development team
68add1155SRico Sonntag * This program is free software: you can redistribute it and/or modify
78add1155SRico Sonntag * it under the terms of the GNU General Public License as published by
88add1155SRico Sonntag * the Free Software Foundation, either version 3 of the License, or
98add1155SRico Sonntag * (at your option) any later version.
108add1155SRico Sonntag * This program is distributed in the hope that it will be useful,
118add1155SRico Sonntag * but WITHOUT ANY WARRANTY; without even the implied warranty of
128add1155SRico Sonntag * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
138add1155SRico Sonntag * GNU General Public License for more details.
148add1155SRico Sonntag * 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/>.
168add1155SRico Sonntag */
17fcfa147eSGreg Roach
188add1155SRico Sonntagdeclare(strict_types=1);
198add1155SRico Sonntag
208add1155SRico Sonntagnamespace Fisharebest\Webtrees\Statistics\Repository;
218add1155SRico Sonntag
220d047a8cSGreg Roachuse Exception;
23820b62dfSGreg Roachuse Fisharebest\Webtrees\Fact;
246b9cb339SGreg Roachuse Fisharebest\Webtrees\Registry;
251635452cSGreg Roachuse Fisharebest\Webtrees\Header;
268add1155SRico Sonntaguse Fisharebest\Webtrees\Statistics\Repository\Interfaces\GedcomRepositoryInterface;
278add1155SRico Sonntaguse Fisharebest\Webtrees\Tree;
288add1155SRico Sonntaguse Illuminate\Database\Capsule\Manager as DB;
298add1155SRico Sonntag
304c78e066SGreg Roachuse function e;
31dec352c1SGreg Roachuse function str_contains;
324c78e066SGreg Roachuse function strpos;
334c78e066SGreg Roachuse function substr;
34dec352c1SGreg Roach
358add1155SRico Sonntag/**
368add1155SRico Sonntag * A repository providing methods for GEDCOM related statistics.
378add1155SRico Sonntag */
388add1155SRico Sonntagclass GedcomRepository implements GedcomRepositoryInterface
398add1155SRico Sonntag{
404c78e066SGreg Roach    private Tree $tree;
418add1155SRico Sonntag
428add1155SRico Sonntag    /**
438add1155SRico Sonntag     * @param Tree $tree
448add1155SRico Sonntag     */
458add1155SRico Sonntag    public function __construct(Tree $tree)
468add1155SRico Sonntag    {
478add1155SRico Sonntag        $this->tree = $tree;
488add1155SRico Sonntag    }
498add1155SRico Sonntag
508add1155SRico Sonntag    /**
518add1155SRico Sonntag     * Get information from the GEDCOM's HEAD record.
528add1155SRico Sonntag     *
5324f2a3afSGreg Roach     * @return array<string>
548add1155SRico Sonntag     */
558add1155SRico Sonntag    private function gedcomHead(): array
568add1155SRico Sonntag    {
578add1155SRico Sonntag        $title   = '';
588add1155SRico Sonntag        $version = '';
598add1155SRico Sonntag        $source  = '';
608add1155SRico Sonntag
616b9cb339SGreg Roach        $head = Registry::headerFactory()->make('HEAD', $this->tree);
628add1155SRico Sonntag
631635452cSGreg Roach        if ($head instanceof Header) {
64820b62dfSGreg Roach            $sour = $head->facts(['SOUR'])->first();
658add1155SRico Sonntag
66820b62dfSGreg Roach            if ($sour instanceof Fact) {
678add1155SRico Sonntag                $source  = $sour->value();
688add1155SRico Sonntag                $title   = $sour->attribute('NAME');
698add1155SRico Sonntag                $version = $sour->attribute('VERS');
708add1155SRico Sonntag            }
718add1155SRico Sonntag        }
728add1155SRico Sonntag
738add1155SRico Sonntag        return [
748add1155SRico Sonntag            $title,
758add1155SRico Sonntag            $version,
768add1155SRico Sonntag            $source,
778add1155SRico Sonntag        ];
788add1155SRico Sonntag    }
798add1155SRico Sonntag
808add1155SRico Sonntag    /**
810dcd9387SGreg Roach     * @return string
828add1155SRico Sonntag     */
838add1155SRico Sonntag    public function gedcomFilename(): string
848add1155SRico Sonntag    {
858add1155SRico Sonntag        return $this->tree->name();
868add1155SRico Sonntag    }
878add1155SRico Sonntag
888add1155SRico Sonntag    /**
890dcd9387SGreg Roach     * @return int
908add1155SRico Sonntag     */
918add1155SRico Sonntag    public function gedcomId(): int
928add1155SRico Sonntag    {
938add1155SRico Sonntag        return $this->tree->id();
948add1155SRico Sonntag    }
958add1155SRico Sonntag
968add1155SRico Sonntag    /**
970dcd9387SGreg Roach     * @return string
988add1155SRico Sonntag     */
998add1155SRico Sonntag    public function gedcomTitle(): string
1008add1155SRico Sonntag    {
1018add1155SRico Sonntag        return e($this->tree->title());
1028add1155SRico Sonntag    }
1038add1155SRico Sonntag
1048add1155SRico Sonntag    /**
1050dcd9387SGreg Roach     * @return string
1068add1155SRico Sonntag     */
1078add1155SRico Sonntag    public function gedcomCreatedSoftware(): string
1088add1155SRico Sonntag    {
1098add1155SRico Sonntag        return $this->gedcomHead()[0];
1108add1155SRico Sonntag    }
1118add1155SRico Sonntag
1128add1155SRico Sonntag    /**
1130dcd9387SGreg Roach     * @return string
1148add1155SRico Sonntag     */
1158add1155SRico Sonntag    public function gedcomCreatedVersion(): string
1168add1155SRico Sonntag    {
1178add1155SRico Sonntag        $head = $this->gedcomHead();
1188add1155SRico Sonntag
1198add1155SRico Sonntag        // Fix broken version string in Family Tree Maker
120dec352c1SGreg Roach        if (str_contains($head[1], 'Family Tree Maker ')) {
1218add1155SRico Sonntag            $p       = strpos($head[1], '(') + 1;
1228add1155SRico Sonntag            $p2      = strpos($head[1], ')');
1238add1155SRico Sonntag            $head[1] = substr($head[1], $p, $p2 - $p);
1248add1155SRico Sonntag        }
1258add1155SRico Sonntag
1268add1155SRico Sonntag        // Fix EasyTree version
1278add1155SRico Sonntag        if ($head[2] === 'EasyTree') {
1288add1155SRico Sonntag            $head[1] = substr($head[1], 1);
1298add1155SRico Sonntag        }
1308add1155SRico Sonntag
1318add1155SRico Sonntag        return $head[1];
1328add1155SRico Sonntag    }
1338add1155SRico Sonntag
1348add1155SRico Sonntag    /**
1350dcd9387SGreg Roach     * @return string
1360d047a8cSGreg Roach     * @throws Exception
1378add1155SRico Sonntag     */
1388add1155SRico Sonntag    public function gedcomDate(): string
1398add1155SRico Sonntag    {
1406b9cb339SGreg Roach        $head = Registry::headerFactory()->make('HEAD', $this->tree);
1418add1155SRico Sonntag
1421635452cSGreg Roach        if ($head instanceof Header) {
143820b62dfSGreg Roach            $fact = $head->facts(['DATE'])->first();
1448add1155SRico Sonntag
145820b62dfSGreg Roach            if ($fact instanceof Fact) {
146*d97083feSGreg Roach                return Registry::timestampFactory()->fromString($fact->value(), 'j M Y')->isoFormat('LL');
1478add1155SRico Sonntag            }
1488add1155SRico Sonntag        }
1498add1155SRico Sonntag
1508add1155SRico Sonntag        return '';
1518add1155SRico Sonntag    }
1528add1155SRico Sonntag
1538add1155SRico Sonntag    /**
1540dcd9387SGreg Roach     * @return string
1558add1155SRico Sonntag     */
1568add1155SRico Sonntag    public function gedcomUpdated(): string
1578add1155SRico Sonntag    {
1588fd23e11SGreg Roach        $row = DB::table('change')
1598fd23e11SGreg Roach            ->where('gedcom_id', '=', $this->tree->id())
1608fd23e11SGreg Roach            ->where('status', '=', 'accepted')
1618fd23e11SGreg Roach            ->orderBy('change_id', 'DESC')
1628fd23e11SGreg Roach            ->select(['change_time'])
1638fd23e11SGreg Roach            ->first();
1648fd23e11SGreg Roach
1658fd23e11SGreg Roach        if ($row === null) {
1668fd23e11SGreg Roach            return $this->gedcomDate();
1678add1155SRico Sonntag        }
1688add1155SRico Sonntag
169*d97083feSGreg Roach        return Registry::timestampFactory()->fromString($row->change_time)->isoFormat('LL');
1708add1155SRico Sonntag    }
1718add1155SRico Sonntag
1728add1155SRico Sonntag    /**
1730dcd9387SGreg Roach     * @return string
1748add1155SRico Sonntag     */
1758add1155SRico Sonntag    public function gedcomRootId(): string
1768add1155SRico Sonntag    {
1778add1155SRico Sonntag        return $this->tree->getPreference('PEDIGREE_ROOT_ID');
1788add1155SRico Sonntag    }
1798add1155SRico Sonntag}
180