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