execute(['tree_id' => $tree->getTreeId()])->fetchAssoc(); $count_families = Database::prepare( "SELECT l_to, COUNT(*) FROM `##families` JOIN `##link` ON l_from = f_id AND l_file = f_file AND l_type = 'SOUR' AND l_file = :tree_id GROUP BY l_to" )->execute(['tree_id' => $tree->getTreeId()])->fetchAssoc(); $count_media = Database::prepare( "SELECT l_to, COUNT(*) FROM `##media` JOIN `##link` ON l_from = m_id AND l_file = m_file AND l_type = 'SOUR' AND l_file = :tree_id GROUP BY l_to" )->execute(['tree_id' => $tree->getTreeId()])->fetchAssoc(); $count_notes = Database::prepare( "SELECT l_to, COUNT(*) FROM `##other` JOIN `##link` ON l_from = o_id AND l_file = o_file AND o_type = 'NOTE' AND l_type = 'SOUR' AND l_file = :tree_id GROUP BY l_to" )->execute(['tree_id' => $tree->getTreeId()])->fetchAssoc(); ?>
= I18N::translate('Title') ?> | = I18N::translate('Author') ?> | = I18N::translate('Individuals') ?> | = I18N::translate('Families') ?> | = I18N::translate('Media objects') ?> | = I18N::translate('Shared notes') ?> | = I18N::translate('Last change') ?> |
---|---|---|---|---|---|---|
= $source->getFullName() ?> | = e($source->getFirstFact('AUTH') ? $source->getFirstFact('AUTH')->getValue() : '') ?> | = I18N::number($count_individuals[$source->getXref()] ?? 0) ?> | = I18N::number($count_families[$source->getXref()] ?? 0) ?> | = I18N::number($count_media[$source->getXref()] ?? 0) ?> | = I18N::number($count_notes[$source->getXref()] ?? 0) ?> | = $source->lastChangeTimestamp() ?> |