Statistics/Repository/FamilyRepository.php

75      * General query on family.
153                     ->on('children.l_from', '=', 'f_id')
154                     ->on('children.l_file', '=', 'f_file')
158                     ->on('mchildren.l_file', '=', 'children.l_file')
159                     ->on('mchildren.l_from', '=', 'children.l_to')
163                     ->on('gchildren.l_file', '=', 'mchildren.l_file')
164                     ->on('gchildren.l_from', '=', 'mchildren.l_to')
309                     ->on('link2.l_from', '=', 'link1.l_from')
310                     ->on('link2.l_type', '=', 'link1.l_type')
311                     ->on('link2.l_file', '=', 'link1.l_file');
315                     ->on('child1.d_gid', '=', 'link1.l_to')
316                     ->on('child1.d_file', '=', 'link1.l_file')
322                     ->on('child2.d_gid', '=', 'link2.l_to')
323                     ->on('child2.d_file', '=', 'link2.l_file')
550      * General query on families/children.
568                         ->on('d_file', '=', 'f_file')
569                         ->on('d_gid', '=', 'f_id');
580      * Genearl query on families/children.
619      * General query on families.
704                     ->on('d_gid', '=', 'l_to')
705                     ->on('d_file', '=', 'l_file')
717                     ->on('d_gid', '=', 'l_to')
718                     ->on('d_file', '=', 'l_file');
722                     ->on('family_id', '=', 'l_from')
723                     ->on('min_birth_jd', '=', 'd_julianday1');
750                     ->on('i_file', '=', 'l_file')
751                     ->on('i_id', '=', 'l_to');
790      * General query on parents.
814                     ->on('childfamily.l_file', '=', 'parentfamily.l_file')
815                     ->on('childfamily.l_from', '=', 'parentfamily.l_from')
820                     ->on('birth.d_file', '=', 'parentfamily.l_file')
821                     ->on('birth.d_gid', '=', 'parentfamily.l_to')
827                     ->on('childbirth.d_file', '=', 'parentfamily.l_file')
828                     ->on('childbirth.d_gid', '=', 'childfamily.l_to')
1004      * General query on age at marriage.
1018                     ->on('married.d_file', '=', 'f_file')
1019                     ->on('married.d_gid', '=', 'f_id')
1025                     ->on('husbdeath.d_gid', '=', 'f_husb')
1026                     ->on('husbdeath.d_file', '=', 'f_file')
1039                     ->on('married.d_file', '=', 'f_file')
1040                     ->on('married.d_gid', '=', 'f_id')
1046                     ->on('wifedeath.d_gid', '=', 'f_wife')
1047                     ->on('wifedeath.d_file', '=', 'f_file')
1060                     ->on('married.d_file', '=', 'f_file')
1061                     ->on('married.d_gid', '=', 'f_id')
1067                     ->on('divorced.d_gid', '=', 'f_id')
1068                     ->on('divorced.d_file', '=', 'f_file')
1168      * General query on marriage ages.
1178      * General query on marriage ages.
1188      * General query on marriage ages.
1200      * General query on marriage ages.
1212      * General query on marriage ages.
1222      * General query on marriage ages.
1232      * General query on marriage ages.
1244      * General query on marriage ages.
1269                     ->on('wife.d_gid', '=', 'f_wife')
1270                     ->on('wife.d_file', '=', 'f_file')
1276                     ->on('husb.d_gid', '=', 'f_husb')
1277                     ->on('husb.d_file', '=', 'f_file')
1382      * General query on ages at marriage.
1395                     ->on('f_file', '=', 'married.d_file')
1396                     ->on('f_id', '=', 'married.d_gid');
1400                     ->on('birth.d_file', '=', 'married.d_file')
1401                     ->on('birth.d_gid', '=', $sex === 'M' ? 'f_husb' : 'f_wife')
1427      * General query on marriage ages.
1462                     ->on('married.d_file', '=', 'f_file')
1463                     ->on('married.d_gid', '=', 'f_id')
1468                     ->on('i_file', '=', 'f_file')
1469                     ->on('i_id', '=', $sex_field)
1474                     ->on('birth.d_file', '=', 'i_file')
1475                     ->on('birth.d_gid', '=', 'i_id')
1652      * General query on marriages.
1675      * General query on marriages.
1687                     ->on('d_gid', '=', 'f_id')
1688                     ->on('d_file', '=', 'f_file')
1705      * General query on marriages.