execute(['tree_id' => $tree->id()])->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 = 'NOTE' AND l_file = :tree_id GROUP BY l_to" )->execute(['tree_id' => $tree->id()])->fetchAssoc(); $count_sources = Database::prepare( "SELECT l_to, COUNT(*) FROM `##sources` JOIN `##link` ON l_from = s_id AND l_file = s_file AND l_type = 'NOTE' AND l_file = :tree_id GROUP BY l_to" )->execute(['tree_id' => $tree->id()])->fetchAssoc(); ?>
= I18N::translate('Media') ?> | = I18N::translate('Title') ?> | = I18N::translate('Individuals') ?> | = I18N::translate('Families') ?> | = I18N::translate('Sources') ?> | = I18N::translate('Last change') ?> |
---|---|---|---|---|---|
mediaFiles() as $media_file) : ?> = $media_file->displayImage(100, 100, 'contain', []) ?> | = $media_object->getFullName() ?> | = I18N::number($count_individuals[$media_object->xref()] ?? 0) ?> | = I18N::number($count_families[$media_object->xref()] ?? 0) ?> | = I18N::number($count_sources[$media_object->xref()] ?? 0) ?> | = $media_object->lastChangeTimestamp() ?> |