xref: /webtrees/app/Statistics/Repository/GedcomRepository.php (revision 5c6b027e05b0d264623896d5ec4adcd2fdd555fc) 
1<?php
2
3/**
4 * webtrees: online genealogy
5 * Copyright (C) 2019 webtrees development team
6 * This program is free software: you can redistribute it and/or modify
7 * it under the terms of the GNU General Public License as published by
8 * the Free Software Foundation, either version 3 of the License, or
9 * (at your option) any later version.
10 * This program is distributed in the hope that it will be useful,
11 * but WITHOUT ANY WARRANTY; without even the implied warranty of
12 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
13 * GNU General Public License for more details.
14 * You should have received a copy of the GNU General Public License
15 * along with this program. If not, see <http://www.gnu.org/licenses/>.
16 */
17
18declare(strict_types=1);
19
20namespace Fisharebest\Webtrees\Statistics\Repository;
21
22use Fisharebest\Webtrees\Date;
23use Fisharebest\Webtrees\Fact;
24use Fisharebest\Webtrees\GedcomRecord;
25use Fisharebest\Webtrees\Header;
26use Fisharebest\Webtrees\Statistics\Repository\Interfaces\GedcomRepositoryInterface;
27use Fisharebest\Webtrees\Tree;
28use Illuminate\Database\Capsule\Manager as DB;
29use Illuminate\Database\Query\Builder;
30
31/**
32 * A repository providing methods for GEDCOM related statistics.
33 */
34class GedcomRepository implements GedcomRepositoryInterface
35{
36    /**
37     * @var Tree
38     */
39    private $tree;
40
41    /**
42     * Constructor.
43     *
44     * @param Tree $tree
45     */
46    public function __construct(Tree $tree)
47    {
48        $this->tree = $tree;
49    }
50
51    /**
52     * Get information from the GEDCOM's HEAD record.
53     *
54     * @return string[]
55     */
56    private function gedcomHead(): array
57    {
58        $title   = '';
59        $version = '';
60        $source  = '';
61
62        $head = Header::getInstance('HEAD', $this->tree);
63
64        if ($head instanceof Header) {
65            $sour = $head->facts(['SOUR'])->first();
66
67            if ($sour instanceof Fact) {
68                $source  = $sour->value();
69                $title   = $sour->attribute('NAME');
70                $version = $sour->attribute('VERS');
71            }
72        }
73
74        return [
75            $title,
76            $version,
77            $source,
78        ];
79    }
80
81    /**
82     * @inheritDoc
83     */
84    public function gedcomFilename(): string
85    {
86        return $this->tree->name();
87    }
88
89    /**
90     * @inheritDoc
91     */
92    public function gedcomId(): int
93    {
94        return $this->tree->id();
95    }
96
97    /**
98     * @inheritDoc
99     */
100    public function gedcomTitle(): string
101    {
102        return e($this->tree->title());
103    }
104
105    /**
106     * @inheritDoc
107     */
108    public function gedcomCreatedSoftware(): string
109    {
110        return $this->gedcomHead()[0];
111    }
112
113    /**
114     * @inheritDoc
115     */
116    public function gedcomCreatedVersion(): string
117    {
118        $head = $this->gedcomHead();
119
120        // Fix broken version string in Family Tree Maker
121        if (strpos($head[1], 'Family Tree Maker ') !== false) {
122            $p       = strpos($head[1], '(') + 1;
123            $p2      = strpos($head[1], ')');
124            $head[1] = substr($head[1], $p, $p2 - $p);
125        }
126
127        // Fix EasyTree version
128        if ($head[2] === 'EasyTree') {
129            $head[1] = substr($head[1], 1);
130        }
131
132        return $head[1];
133    }
134
135    /**
136     * @inheritDoc
137     */
138    public function gedcomDate(): string
139    {
140        $head = Header::getInstance('HEAD', $this->tree);
141
142        if ($head instanceof Header) {
143            $fact = $head->facts(['DATE'])->first();
144
145            if ($fact instanceof Fact) {
146                return (new Date($fact->value()))->display();
147            }
148        }
149
150        return '';
151    }
152
153    /**
154     * @inheritDoc
155     */
156    public function gedcomUpdated(): string
157    {
158        $row = DB::table('dates')
159            ->select(['d_year', 'd_month', 'd_day'])
160            ->where('d_julianday1', '=', function (Builder $query): void {
161                $query->selectRaw('MAX(d_julianday1)')
162                    ->from('dates')
163                    ->where('d_file', '=', $this->tree->id())
164                    ->where('d_fact', '=', 'CHAN');
165            })
166            ->first();
167
168        if ($row) {
169            $date = new Date("{$row->d_day} {$row->d_month} {$row->d_year}");
170            return $date->display();
171        }
172
173        return $this->gedcomDate();
174    }
175
176    /**
177     * @inheritDoc
178     */
179    public function gedcomRootId(): string
180    {
181        return $this->tree->getPreference('PEDIGREE_ROOT_ID');
182    }
183}
184