Statistics/Repository/IndividualRepository.php

82         $this->century_service = $century_service;
83         $this->color_service   = $color_service;
84         $this->tree            = $tree;
106             ->where('n_file', '=', $this->tree->id())
192         return $this->commonGivenQuery('B', 'nolist', false, $threshold, $maxtoshow);
205         return $this->commonGivenQuery('B', 'nolist', true, $threshold, $maxtoshow);
218         return $this->commonGivenQuery('B', 'list', false, $threshold, $maxtoshow);
231         return $this->commonGivenQuery('B', 'list', true, $threshold, $maxtoshow);
244         return $this->commonGivenQuery('B', 'table', false, $threshold, $maxtoshow);
257         return $this->commonGivenQuery('F', 'nolist', false, $threshold, $maxtoshow);
270         return $this->commonGivenQuery('F', 'nolist', true, $threshold, $maxtoshow);
283         return $this->commonGivenQuery('F', 'list', false, $threshold, $maxtoshow);
296         return $this->commonGivenQuery('F', 'list', true, $threshold, $maxtoshow);
309         return $this->commonGivenQuery('F', 'table', false, $threshold, $maxtoshow);
322         return $this->commonGivenQuery('M', 'nolist', false, $threshold, $maxtoshow);
335         return $this->commonGivenQuery('M', 'nolist', true, $threshold, $maxtoshow);
348         return $this->commonGivenQuery('M', 'list', false, $threshold, $maxtoshow);
361         return $this->commonGivenQuery('M', 'list', true, $threshold, $maxtoshow);
374         return $this->commonGivenQuery('M', 'table', false, $threshold, $maxtoshow);
387         return $this->commonGivenQuery('U', 'nolist', false, $threshold, $maxtoshow);
400         return $this->commonGivenQuery('U', 'nolist', true, $threshold, $maxtoshow);
413         return $this->commonGivenQuery('U', 'list', false, $threshold, $maxtoshow);
426         return $this->commonGivenQuery('U', 'list', true, $threshold, $maxtoshow);
439         return $this->commonGivenQuery('U', 'table', false, $threshold, $maxtoshow);
452             ->where('n_file', '=', $this->tree->id());
480             ->where('n_file', '=', $this->tree->id());
506             ->where('n_file', '=', $this->tree->id())
523                 ->where('n_file', '=', $this->tree->id())
545         $top_surname = $this->topSurnames(1, 0);
568         $surnames = $this->topSurnames($number_of_surnames, $threshold);
586             ->findByComponent(ModuleListInterface::class, $this->tree, Auth::user())
594                 'tree'     => $this->tree,
602             'tree'     => $this->tree,
620 …     return $this->commonSurnamesQuery('nolist', false, $threshold, $number_of_surnames, $sorting);
637 …      return $this->commonSurnamesQuery('nolist', true, $threshold, $number_of_surnames, $sorting);
654         return $this->commonSurnamesQuery('list', false, $threshold, $number_of_surnames, $sorting);
671         return $this->commonSurnamesQuery('list', true, $threshold, $number_of_surnames, $sorting);
686             ->where('d_file', '=', $this->tree->id())
708         return $this->statsBirthQuery($year1, $year2)
728         return (new ChartBirth($this->century_service, $this->color_service, $this->tree))
744             ->where('d_file', '=', $this->tree->id())
766         return $this->statsDeathQuery($year1, $year2)
786         return (new ChartDeath($this->century_service, $this->color_service, $this->tree))
802         $query = $this->birthAndDeathQuery($sex);
830         return (new ChartAge($this->century_service, $this->tree))->chartAge();
843         $row = $this->birthAndDeathQuery($sex)
852         $individual = Registry::individualFactory()->mapper($this->tree)($row);
878         return $this->longlifeQuery('full', 'BOTH');
888         return $this->longlifeQuery('age', 'BOTH');
898         return $this->longlifeQuery('name', 'BOTH');
908         return $this->longlifeQuery('full', 'F');
918         return $this->longlifeQuery('age', 'F');
928         return $this->longlifeQuery('name', 'F');
938         return $this->longlifeQuery('full', 'M');
948         return $this->longlifeQuery('age', 'M');
958         return $this->longlifeQuery('name', 'M');
994         $rows = $this->birthAndDeathQuery($sex)
1003             $individual = Registry::individualFactory()->mapper($this->tree)($row);
1008                     'age'    => $this->calculateAge((int) $row->days),
1025         $records = $this->topTenOldestQuery('BOTH', $total);
1041         $records = $this->topTenOldestQuery('BOTH', $total);
1057         $records = $this->topTenOldestQuery('F', $total);
1073         $records = $this->topTenOldestQuery('F', $total);
1089         $records = $this->topTenOldestQuery('M', $total);
1105         $records = $this->topTenOldestQuery('M', $total);
1128             ->where('d_file', '=', $this->tree->id())
1145             ->map(Registry::individualFactory()->mapper($this->tree))
1149 …'age'    => $this->calculateAge(Registry::timestampFactory()->now()->julianDay() - $individual->ge…
1163         if (!Auth::isMember($this->tree)) {
1167         $records = $this->topTenOldestAliveQuery('BOTH', $total);
1183         if (!Auth::isMember($this->tree)) {
1187         $records = $this->topTenOldestAliveQuery('BOTH', $total);
1203         if (!Auth::isMember($this->tree)) {
1207         $records = $this->topTenOldestAliveQuery('F', $total);
1223         if (!Auth::isMember($this->tree)) {
1227         $records = $this->topTenOldestAliveQuery('F', $total);
1243         if (!Auth::isMember($this->tree)) {
1247         $records = $this->topTenOldestAliveQuery('M', $total);
1263         if (!Auth::isMember($this->tree)) {
1267         $records = $this->topTenOldestAliveQuery('M', $total);
1284         $days = (int) $this->birthAndDeathQuery($sex)
1289             return $this->calculateAge($days);
1304         return $this->averageLifespanQuery('BOTH', $show_years);
1316         return $this->averageLifespanQuery('F', $show_years);
1328         return $this->averageLifespanQuery('M', $show_years);
1352             ->where('i_file', '=', $this->tree->id())
1369             ->where('i_file', '=', $this->tree->id());
1386             ->where('i_file', '=', $this->tree->id())
1405             ->where('i_file', '=', $this->tree->id())
1417         return $this->getTotalSexQuery('M');
1427         return $this->getTotalSexQuery('F');
1437         return $this->getTotalSexQuery('U');
1448             ->where('f_file', '=', $this->tree->id())
1466             ->where('l_file', '=', $this->tree->id())
1485             ->where('l_file', '=', $this->tree->id())
1498             ->where('o_file', '=', $this->tree->id())
1511             ->where('s_file', '=', $this->tree->id())
1523             ->where('o_file', '=', $this->tree->id())
1536             ->where('m_file', '=', $this->tree->id())
1547         return $this->totalIndividualsQuery()
1548             + $this->totalFamiliesQuery()
1549             + $this->totalMediaQuery()
1550             + $this->totalNotesQuery()
1551             + $this->totalRepositoriesQuery()
1552             + $this->totalSourcesQuery();
1560         return I18N::number($this->totalRecordsQuery());
1568         return I18N::number($this->totalIndividualsQuery());
1578         return I18N::number($this->totalLivingQuery());
1588         return I18N::number($this->totalDeceasedQuery());
1596         return I18N::number($this->totalSexMalesQuery());
1604         return I18N::number($this->totalSexFemalesQuery());
1612         return I18N::number($this->totalSexUnknownQuery());
1620         return I18N::number($this->totalFamiliesQuery());
1630         return I18N::number($this->totalIndisWithSourcesQuery());
1640         return I18N::number($this->totalFamsWithSourcesQuery());
1648         return I18N::number($this->totalRepositoriesQuery());
1656         return I18N::number($this->totalSourcesQuery());
1664         return I18N::number($this->totalNotesQuery());
1672         return $this->getPercentage(
1673             $this->totalIndividualsQuery(),
1674             $this->totalRecordsQuery()
1683         return $this->getPercentage(
1684             $this->totalIndisWithSourcesQuery(),
1685             $this->totalIndividualsQuery()
1694         return $this->getPercentage(
1695             $this->totalFamiliesQuery(),
1696             $this->totalRecordsQuery()
1705         return $this->getPercentage(
1706             $this->totalFamsWithSourcesQuery(),
1707             $this->totalFamiliesQuery()
1716         return $this->getPercentage(
1717             $this->totalRepositoriesQuery(),
1718             $this->totalRecordsQuery()
1727         return $this->getPercentage(
1728             $this->totalSourcesQuery(),
1729             $this->totalRecordsQuery()
1738         return $this->getPercentage(
1739             $this->totalNotesQuery(),
1740             $this->totalRecordsQuery()
1749         return $this->getPercentage(
1750             $this->totalLivingQuery(),
1751             $this->totalIndividualsQuery()
1760         return $this->getPercentage(
1761             $this->totalDeceasedQuery(),
1762             $this->totalIndividualsQuery()
1771         return $this->getPercentage(
1772             $this->totalSexMalesQuery(),
1773             $this->totalIndividualsQuery()
1782         return $this->getPercentage(
1783             $this->totalSexFemalesQuery(),
1784             $this->totalIndividualsQuery()
1793         return $this->getPercentage(
1794             $this->totalSexUnknownQuery(),
1795             $this->totalIndividualsQuery()
1813         $tot_indi = $this->totalIndividualsQuery();
1814         $given    = $this->commonGivenQuery('B', 'chart', false, 1, $maxtoshow);
1820         return (new ChartCommonGiven($this->color_service))
1838         $tot_indi     = $this->totalIndividualsQuery();
1839         $all_surnames = $this->topSurnames($number_of_surnames, 0);
1846             ->make($this->tree->getPreference('SURNAME_TRADITION'));
1848         return (new ChartCommonSurname($this->color_service, $surname_tradition))
1862         $tot_l = $this->totalLivingQuery();
1863         $tot_d = $this->totalDeceasedQuery();
1865         return (new ChartMortality($this->color_service))
1881         $tot_indi        = $this->totalIndividualsQuery();
1882         $tot_indi_source = $this->totalIndisWithSourcesQuery();
1884         return (new ChartIndividualWithSources($this->color_service))
1900         $tot_fam        = $this->totalFamiliesQuery();
1901         $tot_fam_source = $this->totalFamsWithSourcesQuery();
1903         return (new ChartFamilyWithSources($this->color_service))
1919         $tot_m = $this->totalSexMalesQuery();
1920         $tot_f = $this->totalSexFemalesQuery();
1921         $tot_u = $this->totalSexUnknownQuery();
1937             ->where('i_file', '=', $this->tree->id())