. */ declare(strict_types=1); namespace Fisharebest\Webtrees\Statistics\Google; use Fisharebest\Webtrees\I18N; use Fisharebest\Webtrees\Registry; use Fisharebest\Webtrees\Statistics\Service\ColorService; use Fisharebest\Webtrees\Tree; use Illuminate\Database\Capsule\Manager as DB; use function count; use function htmlspecialchars_decode; use function strip_tags; use function view; /** * A chart showing the largest families (Families with most children). */ class ChartFamilyLargest { private Tree $tree; private ColorService $color_service; /** * @param ColorService $color_service * @param Tree $tree */ public function __construct(ColorService $color_service, Tree $tree) { $this->tree = $tree; $this->color_service = $color_service; } /** * Returns the related database records. * * @param int $total * * @return array */ private function queryRecords(int $total): array { $query = DB::table('families') ->select(['f_numchil AS total', 'f_id AS id']) ->where('f_file', '=', $this->tree->id()) ->orderBy('total', 'desc') ->limit($total); return $query->get()->all(); } /** * Create a chart of the largest families. * * @param string|null $color_from * @param string|null $color_to * @param int $total * * @return string */ public function chartLargestFamilies( string $color_from = null, string $color_to = null, int $total = 10 ): string { $color_from = $color_from ?? 'ffffff'; $color_to = $color_to ?? '84beff'; $data = [ [ I18N::translate('Type'), I18N::translate('Total') ], ]; foreach ($this->queryRecords($total) as $record) { $family = Registry::familyFactory()->make($record->id, $this->tree); if ($family && $family->canShow()) { $data[] = [ htmlspecialchars_decode(strip_tags($family->fullName())), $record->total ]; } } $colors = $this->color_service->interpolateRgb($color_from, $color_to, count($data) - 1); return view('statistics/other/charts/pie', [ 'title' => I18N::translate('Largest families'), 'data' => $data, 'colors' => $colors, 'language' => I18N::languageTag(), ]); } }