xref: /webtrees/app/Statistics/Google/ChartFamilyLargest.php (revision f70bcff589628705e50ed72a6fc6cbad68558677)
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\Google;
218add1155SRico Sonntag
226b9cb339SGreg Roachuse Fisharebest\Webtrees\Registry;
238add1155SRico Sonntaguse Fisharebest\Webtrees\I18N;
2493ccd686SRico Sonntaguse Fisharebest\Webtrees\Module\ModuleThemeInterface;
2593ccd686SRico Sonntaguse Fisharebest\Webtrees\Statistics\Service\ColorService;
2693ccd686SRico Sonntaguse Fisharebest\Webtrees\Tree;
278add1155SRico Sonntaguse Illuminate\Database\Capsule\Manager as DB;
288add1155SRico Sonntag
2990a2f718SGreg Roachuse function app;
3071378461SGreg Roachuse function count;
3171378461SGreg Roach
328add1155SRico Sonntag/**
3393ccd686SRico Sonntag * A chart showing the largest families (Families with most children).
348add1155SRico Sonntag */
3593ccd686SRico Sonntagclass ChartFamilyLargest
368add1155SRico Sonntag{
378add1155SRico Sonntag    /**
3893ccd686SRico Sonntag     * @var Tree
3993ccd686SRico Sonntag     */
4093ccd686SRico Sonntag    private $tree;
4193ccd686SRico Sonntag
4293ccd686SRico Sonntag    /**
4393ccd686SRico Sonntag     * @var ModuleThemeInterface
4493ccd686SRico Sonntag     */
4593ccd686SRico Sonntag    private $theme;
4693ccd686SRico Sonntag
4793ccd686SRico Sonntag    /**
4893ccd686SRico Sonntag     * @var ColorService
4993ccd686SRico Sonntag     */
5093ccd686SRico Sonntag    private $color_service;
5193ccd686SRico Sonntag
5293ccd686SRico Sonntag    /**
5393ccd686SRico Sonntag     * Constructor.
5493ccd686SRico Sonntag     *
5593ccd686SRico Sonntag     * @param Tree $tree
5693ccd686SRico Sonntag     */
5793ccd686SRico Sonntag    public function __construct(Tree $tree)
5893ccd686SRico Sonntag    {
5993ccd686SRico Sonntag        $this->tree          = $tree;
60cab242e7SGreg Roach        $this->theme         = app(ModuleThemeInterface::class);
6193ccd686SRico Sonntag        $this->color_service = new ColorService();
6293ccd686SRico Sonntag    }
6393ccd686SRico Sonntag
6493ccd686SRico Sonntag    /**
658add1155SRico Sonntag     * Returns the related database records.
668add1155SRico Sonntag     *
678add1155SRico Sonntag     * @param int $total
688add1155SRico Sonntag     *
69*f70bcff5SGreg Roach     * @return array<object>
708add1155SRico Sonntag     */
718add1155SRico Sonntag    private function queryRecords(int $total): array
728add1155SRico Sonntag    {
738add1155SRico Sonntag        $query = DB::table('families')
7488de55fdSRico Sonntag            ->select(['f_numchil AS total', 'f_id AS id'])
758add1155SRico Sonntag            ->where('f_file', '=', $this->tree->id())
7688de55fdSRico Sonntag            ->orderBy('total', 'desc')
778add1155SRico Sonntag            ->limit($total);
788add1155SRico Sonntag
798add1155SRico Sonntag        return $query->get()->all();
808add1155SRico Sonntag    }
818add1155SRico Sonntag
828add1155SRico Sonntag    /**
838add1155SRico Sonntag     * Create a chart of the largest families.
848add1155SRico Sonntag     *
858add1155SRico Sonntag     * @param string|null $color_from
868add1155SRico Sonntag     * @param string|null $color_to
878add1155SRico Sonntag     * @param int         $total
888add1155SRico Sonntag     *
898add1155SRico Sonntag     * @return string
908add1155SRico Sonntag     */
918add1155SRico Sonntag    public function chartLargestFamilies(
928add1155SRico Sonntag        string $color_from = null,
938add1155SRico Sonntag        string $color_to = null,
948add1155SRico Sonntag        int $total = 10
958add1155SRico Sonntag    ): string {
964c78e066SGreg Roach        $chart_color1 = $this->theme->parameter('distribution-chart-no-values');
974c78e066SGreg Roach        $chart_color2 = $this->theme->parameter('distribution-chart-high-values');
988add1155SRico Sonntag        $color_from   = $color_from ?? $chart_color1;
998add1155SRico Sonntag        $color_to     = $color_to   ?? $chart_color2;
1008add1155SRico Sonntag
10188de55fdSRico Sonntag        $data = [
10288de55fdSRico Sonntag            [
10388de55fdSRico Sonntag                I18N::translate('Type'),
10488de55fdSRico Sonntag                I18N::translate('Total')
10588de55fdSRico Sonntag            ],
10688de55fdSRico Sonntag        ];
1078add1155SRico Sonntag
10888de55fdSRico Sonntag        foreach ($this->queryRecords($total) as $record) {
1096b9cb339SGreg Roach            $family = Registry::familyFactory()->make($record->id, $this->tree);
1108add1155SRico Sonntag
1118add1155SRico Sonntag            if ($family && $family->canShow()) {
11288de55fdSRico Sonntag                $data[] = [
11339ca88baSGreg Roach                    htmlspecialchars_decode(strip_tags($family->fullName())),
11488de55fdSRico Sonntag                    $record->total
11588de55fdSRico Sonntag                ];
1168add1155SRico Sonntag            }
1178add1155SRico Sonntag        }
1188add1155SRico Sonntag
1196ccdf4f0SGreg Roach        $colors = $this->color_service->interpolateRgb($color_from, $color_to, count($data) - 1);
1208add1155SRico Sonntag
12190a2f718SGreg Roach        return view('statistics/other/charts/pie', [
12288de55fdSRico Sonntag            'title'    => I18N::translate('Largest families'),
12388de55fdSRico Sonntag            'data'     => $data,
12488de55fdSRico Sonntag            'colors'   => $colors,
12565cf5706SGreg Roach            'language' => I18N::languageTag(),
12690a2f718SGreg Roach        ]);
1278add1155SRico Sonntag    }
1288add1155SRico Sonntag}
129