xref: /webtrees/app/Module/LifespansChartModule.php (revision 0c1a5edc9a45beb310c7bdf17938a95189864c83)
1<?php
2/**
3 * webtrees: online genealogy
4 * Copyright (C) 2019 webtrees development team
5 * This program is free software: you can redistribute it and/or modify
6 * it under the terms of the GNU General Public License as published by
7 * the Free Software Foundation, either version 3 of the License, or
8 * (at your option) any later version.
9 * This program is distributed in the hope that it will be useful,
10 * but WITHOUT ANY WARRANTY; without even the implied warranty of
11 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
12 * GNU General Public License for more details.
13 * You should have received a copy of the GNU General Public License
14 * along with this program. If not, see <http://www.gnu.org/licenses/>.
15 */
16declare(strict_types=1);
17
18namespace Fisharebest\Webtrees\Module;
19
20use Fisharebest\ExtCalendar\GregorianCalendar;
21use Fisharebest\Webtrees\Auth;
22use Fisharebest\Webtrees\ColorGenerator;
23use Fisharebest\Webtrees\Contracts\UserInterface;
24use Fisharebest\Webtrees\Date;
25use Fisharebest\Webtrees\I18N;
26use Fisharebest\Webtrees\Individual;
27use Fisharebest\Webtrees\Place;
28use Fisharebest\Webtrees\Tree;
29use Illuminate\Database\Capsule\Manager as DB;
30use Illuminate\Database\Query\JoinClause;
31use Psr\Http\Message\ResponseInterface;
32use Psr\Http\Message\ServerRequestInterface;
33use stdClass;
34
35/**
36 * Class LifespansChartModule
37 */
38class LifespansChartModule extends AbstractModule implements ModuleChartInterface
39{
40    use ModuleChartTrait;
41
42    // Parameters for generating colors
43    protected const RANGE      = 120; // degrees
44    protected const SATURATION = 100; // percent
45    protected const LIGHTNESS  = 30; // percent
46    protected const ALPHA      = 0.25;
47
48    /**
49     * How should this module be identified in the control panel, etc.?
50     *
51     * @return string
52     */
53    public function title(): string
54    {
55        /* I18N: Name of a module/chart */
56        return I18N::translate('Lifespans');
57    }
58
59    /**
60     * A sentence describing what this module does.
61     *
62     * @return string
63     */
64    public function description(): string
65    {
66        /* I18N: Description of the “LifespansChart” module */
67        return I18N::translate('A chart of individuals’ lifespans.');
68    }
69
70    /**
71     * CSS class for the URL.
72     *
73     * @return string
74     */
75    public function chartMenuClass(): string
76    {
77        return 'menu-chart-lifespan';
78    }
79
80    /**
81     * The URL for this chart.
82     *
83     * @param Individual $individual
84     * @param string[]   $parameters
85     *
86     * @return string
87     */
88    public function chartUrl(Individual $individual, array $parameters = []): string
89    {
90        return route('module', [
91                'module'  => $this->name(),
92                'action'  => 'Chart',
93                'xrefs[]' => $individual->xref(),
94                'ged'     => $individual->tree()->name(),
95            ] + $parameters);
96    }
97
98    /**
99     * A form to request the chart parameters.
100     *
101     * @param ServerRequestInterface $request
102     * @param Tree                   $tree
103     * @param UserInterface          $user
104     *
105     * @return ResponseInterface
106     */
107    public function getChartAction(ServerRequestInterface $request, Tree $tree, UserInterface $user): ResponseInterface
108    {
109        Auth::checkComponentAccess($this, 'chart', $tree, $user);
110
111        $ajax      = (bool) $request->get('ajax');
112        $xrefs     = (array) $request->get('xrefs', []);
113        $addxref   = $request->get('addxref', '');
114        $addfam    = (bool) $request->get('addfam', false);
115        $placename = $request->get('placename', '');
116        $start     = $request->get('start', '');
117        $end       = $request->get('end', '');
118
119        $place      = new Place($placename, $tree);
120        $start_date = new Date($start);
121        $end_date   = new Date($end);
122
123        $xrefs = array_unique($xrefs);
124
125        // Add an individual, and family members
126        $individual = Individual::getInstance($addxref, $tree);
127        if ($individual !== null) {
128            $xrefs[] = $addxref;
129            if ($addfam) {
130                $xrefs = array_merge($xrefs, $this->closeFamily($individual));
131            }
132        }
133
134        // Select by date and/or place.
135        if ($start_date->isOK() && $end_date->isOK() && $placename !== '') {
136            $date_xrefs  = $this->findIndividualsByDate($start_date, $end_date, $tree);
137            $place_xrefs = $this->findIndividualsByPlace($place, $tree);
138            $xrefs       = array_intersect($date_xrefs, $place_xrefs);
139        } elseif ($start_date->isOK() && $end_date->isOK()) {
140            $xrefs = $this->findIndividualsByDate($start_date, $end_date, $tree);
141        } elseif ($placename !== '') {
142            $xrefs = $this->findIndividualsByPlace($place, $tree);
143        }
144
145        // Filter duplicates and private individuals.
146        $xrefs = array_unique($xrefs);
147        $xrefs = array_filter($xrefs, static function (string $xref) use ($tree): bool {
148            $individual = Individual::getInstance($xref, $tree);
149
150            return $individual !== null && $individual->canShow();
151        });
152
153        if ($ajax) {
154            $subtitle = $this->subtitle(count($xrefs), $start_date, $end_date, $placename);
155
156            return $this->chart($tree, $xrefs, $subtitle);
157        }
158
159        $ajax_url = route('module', [
160            'ajax'   => true,
161            'module' => $this->name(),
162            'action' => 'Chart',
163            'ged'    => $tree->name(),
164            'xrefs'  => $xrefs,
165        ]);
166
167        $reset_url = route('module', [
168            'module' => $this->name(),
169            'action' => 'Chart',
170            'ged'    => $tree->name(),
171        ]);
172
173        return $this->viewResponse('modules/lifespans-chart/page', [
174            'ajax_url'    => $ajax_url,
175            'module_name' => $this->name(),
176            'reset_url'   => $reset_url,
177            'title'       => $this->title(),
178            'xrefs'       => $xrefs,
179        ]);
180    }
181
182    /**
183     * @param Tree   $tree
184     * @param array  $xrefs
185     * @param string $subtitle
186     *
187     * @return ResponseInterface
188     */
189    protected function chart(Tree $tree, array $xrefs, string $subtitle): ResponseInterface
190    {
191        /** @var Individual[] $individuals */
192        $individuals = array_map(static function (string $xref) use ($tree) {
193            return Individual::getInstance($xref, $tree);
194        }, $xrefs);
195
196        $individuals = array_filter($individuals, static function (Individual $individual = null): bool {
197            return $individual !== null && $individual->canShow();
198        });
199
200        // Sort the array in order of birth year
201        usort($individuals, Individual::birthDateComparator());
202
203        // Round to whole decades
204        $start_year = (int) floor($this->minYear($individuals) / 10) * 10;
205        $end_year   = (int) ceil($this->maxYear($individuals) / 10) * 10;
206
207        $lifespans = $this->layoutIndividuals($individuals);
208
209        $max_rows = array_reduce($lifespans, static function ($carry, stdClass $item) {
210            return max($carry, $item->row);
211        }, 0);
212
213        $html = view('modules/lifespans-chart/chart', [
214            'dir'        => I18N::direction(),
215            'end_year'   => $end_year,
216            'lifespans'  => $lifespans,
217            'max_rows'   => $max_rows,
218            'start_year' => $start_year,
219            'subtitle'   => $subtitle,
220        ]);
221
222        return response($html);
223    }
224
225    /**
226     * @param Individual[] $individuals
227     *
228     * @return stdClass[]
229     */
230    private function layoutIndividuals(array $individuals): array
231    {
232        $colors = [
233            'M' => new ColorGenerator(240, self::SATURATION, self::LIGHTNESS, self::ALPHA, self::RANGE * -1),
234            'F' => new ColorGenerator(000, self::SATURATION, self::LIGHTNESS, self::ALPHA, self::RANGE),
235            'U' => new ColorGenerator(120, self::SATURATION, self::LIGHTNESS, self::ALPHA, self::RANGE),
236        ];
237
238        $current_year = (int) date('Y');
239
240        // Latest year used in each row
241        $rows = [];
242
243        $lifespans = [];
244
245        foreach ($individuals as $individual) {
246            $birth_jd   = $individual->getEstimatedBirthDate()->minimumJulianDay();
247            $birth_year = $this->jdToYear($birth_jd);
248            $death_jd   = $individual->getEstimatedDeathDate()->maximumJulianDay();
249            $death_year = $this->jdToYear($death_jd);
250
251            // Died before they were born?  Swapping the dates allows them to be shown.
252            if ($death_year < $birth_year) {
253                $death_year = $birth_year;
254            }
255
256            // Don't show death dates in the future.
257            $death_year = min($death_year, $current_year);
258
259            // Add this individual to the next row in the chart...
260            $next_row = count($rows);
261            // ...unless we can find an existing row where it fits.
262            foreach ($rows as $row => $year) {
263                if ($year < $birth_year) {
264                    $next_row = $row;
265                    break;
266                }
267            }
268
269            // Fill the row up to the year (leaving a small gap)
270            $rows[$next_row] = $death_year;
271
272            $lifespans[] = (object) [
273                'background' => $colors[$individual->sex()]->getNextColor(),
274                'birth_year' => $birth_year,
275                'death_year' => $death_year,
276                'id'         => 'individual-' . md5($individual->xref()),
277                'individual' => $individual,
278                'row'        => $next_row,
279            ];
280        }
281
282        return $lifespans;
283    }
284
285    /**
286     * Find the latest event year for individuals
287     *
288     * @param array $individuals
289     *
290     * @return int
291     */
292    protected function maxYear(array $individuals): int
293    {
294        $jd = array_reduce($individuals, static function ($carry, Individual $item) {
295            return max($carry, $item->getEstimatedDeathDate()->maximumJulianDay());
296        }, 0);
297
298        $year = $this->jdToYear($jd);
299
300        // Don't show future dates
301        return min($year, (int) date('Y'));
302    }
303
304    /**
305     * Find the earliest event year for individuals
306     *
307     * @param array $individuals
308     *
309     * @return int
310     */
311    protected function minYear(array $individuals): int
312    {
313        $jd = array_reduce($individuals, static function ($carry, Individual $item) {
314            return min($carry, $item->getEstimatedBirthDate()->minimumJulianDay());
315        }, PHP_INT_MAX);
316
317        return $this->jdToYear($jd);
318    }
319
320    /**
321     * Convert a julian day to a gregorian year
322     *
323     * @param int $jd
324     *
325     * @return int
326     */
327    protected function jdToYear(int $jd): int
328    {
329        if ($jd === 0) {
330            return 0;
331        }
332
333        $gregorian = new GregorianCalendar();
334        [$y] = $gregorian->jdToYmd($jd);
335
336        return $y;
337    }
338
339    /**
340     * @param Date $start
341     * @param Date $end
342     * @param Tree $tree
343     *
344     * @return string[]
345     */
346    protected function findIndividualsByDate(Date $start, Date $end, Tree $tree): array
347    {
348        return DB::table('individuals')
349            ->join('dates', static function (JoinClause $join): void {
350                $join
351                    ->on('d_file', '=', 'i_file')
352                    ->on('d_gid', '=', 'i_id');
353            })
354            ->where('i_file', '=', $tree->id())
355            ->where('d_julianday1', '<=', $end->maximumJulianDay())
356            ->where('d_julianday2', '>=', $start->minimumJulianDay())
357            ->whereNotIn('d_fact', ['BAPL', 'ENDL', 'SLGC', 'SLGS', '_TODO', 'CHAN'])
358            ->pluck('i_id')
359            ->all();
360    }
361
362    /**
363     * @param Place $place
364     * @param Tree  $tree
365     *
366     * @return string[]
367     */
368    protected function findIndividualsByPlace(Place $place, Tree $tree): array
369    {
370        return DB::table('individuals')
371            ->join('placelinks', static function (JoinClause $join): void {
372                $join
373                    ->on('pl_file', '=', 'i_file')
374                    ->on('pl_gid', '=', 'i_id');
375            })
376            ->where('i_file', '=', $tree->id())
377            ->where('pl_p_id', '=', $place->id())
378            ->pluck('i_id')
379            ->all();
380    }
381
382    /**
383     * Find the close family members of an individual.
384     *
385     * @param Individual $individual
386     *
387     * @return string[]
388     */
389    protected function closeFamily(Individual $individual): array
390    {
391        $xrefs = [];
392
393        foreach ($individual->spouseFamilies() as $family) {
394            foreach ($family->children() as $child) {
395                $xrefs[] = $child->xref();
396            }
397
398            foreach ($family->spouses() as $spouse) {
399                $xrefs[] = $spouse->xref();
400            }
401        }
402
403        foreach ($individual->childFamilies() as $family) {
404            foreach ($family->children() as $child) {
405                $xrefs[] = $child->xref();
406            }
407
408            foreach ($family->spouses() as $spouse) {
409                $xrefs[] = $spouse->xref();
410            }
411        }
412
413        return $xrefs;
414    }
415
416    /**
417     * Generate a subtitle, based on filter parameters
418     *
419     * @param int    $count
420     * @param Date   $start
421     * @param Date   $end
422     * @param string $placename
423     *
424     * @return string
425     */
426    protected function subtitle(int $count, Date $start, Date $end, string $placename): string
427    {
428        if ($start->isOK() && $end->isOK() && $placename !== '') {
429            return I18N::plural(
430                '%s individual with events in %s between %s and %s',
431                '%s individuals with events in %s between %s and %s',
432                $count,
433                I18N::number($count),
434                $placename,
435                $start->display(false, '%Y'),
436                $end->display(false, '%Y')
437            );
438        }
439
440        if ($placename !== '') {
441            return I18N::plural(
442                '%s individual with events in %s',
443                '%s individuals with events in %s',
444                $count,
445                I18N::number($count),
446                $placename
447            );
448        }
449
450        if ($start->isOK() && $end->isOK()) {
451            return I18N::plural(
452                '%s individual with events between %s and %s',
453                '%s individuals with events between %s and %s',
454                $count,
455                I18N::number($count),
456                $start->display(false, '%Y'),
457                $end->display(false, '%Y')
458            );
459        }
460
461        return I18N::plural('%s individual', '%s individuals', $count, I18N::number($count));
462    }
463}
464