join('link', static function (JoinClause $join): void { $join->on('l_from', '=', 'i_id'); $join->on('l_file', '=', 'i_file'); }) ->where('l_type', '=', 'NOTE') ->where('l_file', '=', $tree->id()) ->groupBy('l_to') ->select(['l_to', new Expression('COUNT(*) AS total')]) ->pluck('total', 'l_to') ->all(); $count_families = DB::table('families') ->join('link', static function (JoinClause $join): void { $join->on('l_from', '=', 'f_id'); $join->on('l_file', '=', 'f_file'); }) ->where('l_type', '=', 'NOTE') ->where('l_file', '=', $tree->id()) ->groupBy('l_to') ->select(['l_to', new Expression('COUNT(*) AS total')]) ->pluck('total', 'l_to') ->all(); $count_sources = DB::table('sources') ->join('link', static function (JoinClause $join): void { $join->on('l_from', '=', 's_id'); $join->on('l_file', '=', 's_file'); }) ->where('l_type', '=', 'NOTE') ->where('l_file', '=', $tree->id()) ->groupBy('l_to') ->select(['l_to', new Expression('COUNT(*) AS total')]) ->pluck('total', 'l_to') ->all(); ?>
mediaFiles() as $media_file) : ?> displayImage(100, 100, 'contain', []) ?> fullName() ?> xref()] ?? 0) ?> xref()] ?? 0) ?> xref()] ?? 0) ?> $media_object->lastChangeTimestamp()]) ?>