{
"event": "PreToolUse",
"tool_name": "Read",
"tool_input": {
"file_path": "\/var\/www\/dev.campus.systemische-tools.de\/src\/Infrastructure\/Persistence\/ContractRepository.php",
"limit": 100
}
}
{
"tool_response": {
"type": "text",
"file": {
"filePath": "\/var\/www\/dev.campus.systemische-tools.de\/src\/Infrastructure\/Persistence\/SystemExplorerRepository.php",
"content": "<?php\n\ndeclare(strict_types=1);\n\nnamespace Infrastructure\\Persistence;\n\n\/\/ @responsibility: Persistenz für System-Explorer (Dokumentation + Chunks)\n\nuse Infrastructure\\Config\\DatabaseFactory;\nuse Infrastructure\\Traits\\JsonDecodeTrait;\nuse PDO;\n\nclass SystemExplorerRepository\n{\n use JsonDecodeTrait;\n\n private PDO $pdo;\n\n public function __construct(?PDO $pdo = null)\n {\n $this->pdo = $pdo ?? DatabaseFactory::dev();\n }\n\n \/\/ ==================== Statistics ====================\n\n public function countDokumente(): int\n {\n return (int) $this->pdo->query(\n 'SELECT COUNT(*) FROM dokumentation WHERE depth = 0'\n )->fetchColumn();\n }\n\n public function countSeiten(): int\n {\n return (int) $this->pdo->query(\n 'SELECT COUNT(*) FROM dokumentation WHERE depth > 0'\n )->fetchColumn();\n }\n\n \/**\n * @return array{total: int, tokens: int, analyzed: int, synced: int}\n *\/\n public function getChunkStats(): array\n {\n $result = $this->pdo->query(\n 'SELECT\n COUNT(*) as total,\n COALESCE(SUM(token_count), 0) as tokens,\n SUM(CASE WHEN analysis_status = \"completed\" THEN 1 ELSE 0 END) as analyzed,\n SUM(CASE WHEN qdrant_id IS NOT NULL THEN 1 ELSE 0 END) as synced\n FROM dokumentation_chunks'\n )->fetch(PDO::FETCH_ASSOC);\n\n return $result ?: ['total' => 0, 'tokens' => 0, 'analyzed' => 0, 'synced' => 0];\n }\n\n \/**\n * @return array<array{taxonomy_category: string, count: int}>\n *\/\n public function getTopTaxonomyCategories(int $limit = 10): array\n {\n $stmt = $this->pdo->prepare(\n 'SELECT taxonomy_category, COUNT(*) as count\n FROM dokumentation_chunks\n WHERE taxonomy_category IS NOT NULL\n GROUP BY taxonomy_category\n ORDER BY count DESC\n LIMIT :limit'\n );\n $stmt->bindValue(':limit', $limit, PDO::PARAM_INT);\n $stmt->execute();\n\n return $stmt->fetchAll(PDO::FETCH_ASSOC);\n }\n\n \/\/ ==================== Dokumente ====================\n\n \/**\n * @return array<array<string, mixed>>\n *\/\n public function getDokumenteWithStats(): array\n {\n return $this->pdo->query(\n 'SELECT d.id, d.title, d.path,\n (SELECT COUNT(*) FROM dokumentation WHERE parent_id = d.id) as seiten_count,\n (SELECT COUNT(*) FROM dokumentation_chunks WHERE dokumentation_id = d.id) as chunks_count\n FROM dokumentation d\n WHERE d.depth = 0\n ORDER BY d.title'\n )->fetchAll(PDO::FETCH_ASSOC);\n }\n\n \/**\n * @return array<array<string, mixed>>\n *\/\n public function getDokumenteWithFullStats(): array\n {\n return $this->pdo->query(\n 'SELECT d.id, d.title, d.path, d.content, d.created_at, d.updated_at,\n (SELECT COUNT(*) FROM dokumentation WHERE parent_id = d.id) as seiten_count,\n (SELECT COUNT(*) FROM dokumentation_chunks WHERE dokumentation_id IN\n (SELECT id FROM dokumentation WHERE parent_id = d.id OR id = d.id)) as total_chunks,\n (SELECT COALESCE(SUM(token_count), 0) FROM dokumentation_chunks WHERE dokumentation_id IN\n (SELECT id FROM dokumentation WHERE parent_id = d.id OR id = d.id)) as total_tokens\n FROM dokumentation d\n WHERE d.depth = 0\n ORDER BY d.title'\n )->fetchAll(PDO::FETCH_ASSOC);\n }\n\n \/**\n * @return array<string, mixed>|null\n *\/\n public function getDokument(int $id): ?array\n {\n $stmt = $this->pdo->prepare(\n 'SELECT d.*, p.title as parent_title\n FROM dokumentation d\n LEFT JOIN dokumentation p ON d.parent_id = p.id\n WHERE d.id = :id'\n );\n $stmt->execute(['id' => $id]);\n $result = $stmt->fetch(PDO::FETCH_ASSOC);\n\n return $result !== false ? $result : null;\n }\n\n \/**\n * Get root document (depth=0) by ID.\n *\n * @return array<string, mixed>|null\n *\/\n public function getDokumentRoot(int $id): ?array\n {\n $stmt = $this->pdo->prepare(\n 'SELECT * FROM dokumentation WHERE id = :id AND depth = 0'\n );\n $stmt->execute(['id' => $id]);\n $result = $stmt->fetch(PDO::FETCH_ASSOC);\n\n return $result !== false ? $result : null;\n }\n\n \/**\n * Get child pages with chunk statistics.\n *\n * @return array<array<string, mixed>>\n *\/\n public function getSeitenWithStatsForParent(int $parentId): array\n {\n $stmt = $this->pdo->prepare(\n 'SELECT s.id, s.title, s.path, s.depth,\n (SELECT COUNT(*) FROM dokumentation_chunks WHERE dokumentation_id = s.id) as chunks_count,\n (SELECT COALESCE(SUM(token_count), 0) FROM dokumentation_chunks WHERE dokumentation_id = s.id) as token_count\n FROM dokumentation s\n WHERE s.parent_id = :id\n ORDER BY s.title'\n );\n $stmt->execute(['id' => $parentId]);\n\n return $stmt->fetchAll(PDO::FETCH_ASSOC);\n }\n\n \/**\n * Get taxonomy aggregation for document tree.\n *\n * @return array<array{taxonomy_category: string, count: int}>\n *\/\n public function getTaxonomyForDokumentTree(int $dokumentId): array\n {\n $stmt = $this->pdo->prepare(\n 'SELECT taxonomy_category, COUNT(*) as count\n FROM dokumentation_chunks\n WHERE dokumentation_id IN (\n SELECT id FROM dokumentation WHERE id = :id OR parent_id = :id2\n )\n AND taxonomy_category IS NOT NULL\n GROUP BY taxonomy_category\n ORDER BY count DESC'\n );\n $stmt->execute(['id' => $dokumentId, 'id2' => $dokumentId]);\n\n return $stmt->fetchAll(PDO::FETCH_ASSOC);\n }\n\n \/\/ ==================== Seiten ====================\n\n \/**\n * Count seiten with optional filters.\n *\/\n public function countSeitenFiltered(string $search = '', string $parentId = ''): int\n {\n $sql = 'SELECT COUNT(*) FROM dokumentation s WHERE s.depth > 0';\n $params = [];\n\n if ($search !== '') {\n $sql .= ' AND (s.title LIKE :search OR s.path LIKE :search2)';\n $params['search'] = '%' . $search . '%';\n $params['search2'] = '%' . $search . '%';\n }",
"numLines": 200,
"startLine": 1,
"totalLines": 707
}
}
}