Statistics/Repository/FamilyRepository.php

69         $this->century_service = $century_service;
70         $this->color_service   = $color_service;
71         $this->tree            = $tree;
84             ->where('f_file', '=', $this->tree->id())
92         $family = Registry::familyFactory()->mapper($this->tree)($row);
118         return $this->familyQuery('full');
128         return $this->familyQuery('size');
138         return $this->familyQuery('name');
167             ->where('f_file', '=', $this->tree->id())
173             ->map(Registry::familyFactory()->mapper($this->tree))
201             'records' => $this->topTenGrandFamilyQuery($total),
215             'records' => $this->topTenGrandFamilyQuery($total),
227             ->where('f_file', '=', $this->tree->id())
239         return I18N::number($this->noChildrenFamiliesQuery());
252             ->where('f_file', '=', $this->tree->id())
255             ->map(Registry::familyFactory()->mapper($this->tree))
291         $no_child_fam = $this->noChildrenFamiliesQuery();
293         return (new ChartNoChildrenFamilies($this->century_service, $this->tree))
328             ->where('link1.l_file', '=', $this->tree->id())
371         $rows = $this->ageBetweenSiblingsQuery($total);
374             $family = Registry::familyFactory()->make($fam->family, $this->tree);
375             $child1 = Registry::individualFactory()->make($fam->ch1, $this->tree);
376             $child2 = Registry::individualFactory()->make($fam->ch2, $this->tree);
384                     'age'    => $this->calculateAge((int) $fam->age),
403         $rows  = $this->ageBetweenSiblingsQuery($total);
408             $family = Registry::familyFactory()->make($fam->family, $this->tree);
409             $child1 = Registry::individualFactory()->make($fam->ch1, $this->tree);
410             $child2 = Registry::individualFactory()->make($fam->ch2, $this->tree);
412             $age = $this->calculateAge((int) $fam->age);
447         $rows = $this->ageBetweenSiblingsQuery($total);
450             return $this->calculateAge((int) $fam->age);
466         $rows = $this->ageBetweenSiblingsQuery($total);
469             $family = Registry::familyFactory()->make($fam->family, $this->tree);
470             $child1 = Registry::individualFactory()->make($fam->ch1, $this->tree);
471             $child2 = Registry::individualFactory()->make($fam->ch2, $this->tree);
497         return $this->ageBetweenSiblingsName($total);
509         return $this->ageBetweenSiblingsAge($total);
521         $record = $this->ageBetweenSiblingsNoList($total);
542         $records = $this->ageBetweenSiblingsList($total, (bool) $one);
560             ->where('f_file', '=', $this->tree->id())
586         return (new ChartChildren($this->century_service, $this->tree))
598             ->where('f_file', '=', $this->tree->id())
612             ->where('f_file', '=', $this->tree->id())
628             ->where('f_file', '=', $this->tree->id())
632             ->map(Registry::familyFactory()->mapper($this->tree))
650         $records = $this->topTenFamilyQuery($total);
666         $records = $this->topTenFamilyQuery($total);
687         return (new ChartFamilyLargest($this->color_service, $this->tree))
709             ->where('l_file', '=', $this->tree->id())
725             ->where('link.l_file', '=', $this->tree->id())
747         return $this->monthFirstChildQuery($year1, $year2)
765             ->where('f_file', '=', $this->tree->id())
781             ->where('f_file', '=', $this->tree->id())
831             ->where('childfamily.l_file', '=', $this->tree->id())
844         $person = Registry::individualFactory()->make($row->id, $this->tree);
864                     $result = $this->calculateAge((int) $row->age);
882         return $this->parentsQuery('full', 'ASC', 'F', false);
892         return $this->parentsQuery('name', 'ASC', 'F', false);
904         return $this->parentsQuery('age', 'ASC', 'F', (bool) $show_years);
914         return $this->parentsQuery('full', 'DESC', 'F', false);
924         return $this->parentsQuery('name', 'DESC', 'F', false);
936         return $this->parentsQuery('age', 'DESC', 'F', (bool) $show_years);
946         return $this->parentsQuery('full', 'ASC', 'M', false);
956         return $this->parentsQuery('name', 'ASC', 'M', false);
968         return $this->parentsQuery('age', 'ASC', 'M', (bool) $show_years);
978         return $this->parentsQuery('full', 'DESC', 'M', false);
988         return $this->parentsQuery('name', 'DESC', 'M', false);
1000         return $this->parentsQuery('age', 'DESC', 'M', (bool) $show_years);
1015             ->where('f_file', '=', $this->tree->id())
1036             ->where('f_file', '=', $this->tree->id())
1057             ->where('f_file', '=', $this->tree->id())
1105             $family = Registry::familyFactory()->make((string) $xref, $this->tree);
1110             $age = $this->calculateAge((int) $age);
1174         return $this->ageOfMarriageQuery('name', 'DESC', 1);
1184         return $this->ageOfMarriageQuery('age', 'DESC', 1);
1196         return $this->ageOfMarriageQuery('nolist', 'DESC', $total);
1208         return $this->ageOfMarriageQuery('list', 'DESC', $total);
1218         return $this->ageOfMarriageQuery('name', 'ASC', 1);
1228         return $this->ageOfMarriageQuery('age', 'ASC', 1);
1240         return $this->ageOfMarriageQuery('nolist', 'ASC', $total);
1252         return $this->ageOfMarriageQuery('list', 'ASC', $total);
1266             ->where('f_file', '=', $this->tree->id())
1297             ->map(Registry::familyFactory()->mapper($this->tree))
1311                     'age'    => $this->calculateAge($diff),
1326         $records = $this->ageBetweenSpousesQuery('DESC', $total);
1342         $records = $this->ageBetweenSpousesQuery('DESC', $total);
1358         $records = $this->ageBetweenSpousesQuery('ASC', $total);
1374         $records = $this->ageBetweenSpousesQuery('ASC', $total);
1406             ->where('married.d_file', '=', $this->tree->id())
1433         return (new ChartMarriageAge($this->century_service, $this->tree))
1479             ->where('f_file', '=', $this->tree->id())
1491         $family = Registry::familyFactory()->make($row->famid, $this->tree);
1492         $person = Registry::individualFactory()->make($row->i_id, $this->tree);
1512                     $result = $this->calculateAge((int) $row->age);
1530         return $this->marriageQuery('full', 'ASC', 'F', false);
1540         return $this->marriageQuery('name', 'ASC', 'F', false);
1552         return $this->marriageQuery('age', 'ASC', 'F', (bool) $show_years);
1562         return $this->marriageQuery('full', 'DESC', 'F', false);
1572         return $this->marriageQuery('name', 'DESC', 'F', false);
1584         return $this->marriageQuery('age', 'DESC', 'F', (bool) $show_years);
1594         return $this->marriageQuery('full', 'ASC', 'M', false);
1604         return $this->marriageQuery('name', 'ASC', 'M', false);
1616         return $this->marriageQuery('age', 'ASC', 'M', (bool) $show_years);
1626         return $this->marriageQuery('full', 'DESC', 'M', false);
1636         return $this->marriageQuery('name', 'DESC', 'M', false);
1648         return $this->marriageQuery('age', 'DESC', 'M', (bool) $show_years);
1662             ->where('d_file', '=', $this->tree->id())
1693             ->where('f_file', '=', $this->tree->id());
1714         return (new ChartMarriage($this->century_service, $this->color_service, $this->tree))
1728         return (new ChartDivorce($this->century_service, $this->color_service, $this->tree))