159036814SCostin Stroie<?php 259036814SCostin Stroie 359036814SCostin Stroienamespace dokuwiki\plugin\dokullm; 459036814SCostin Stroie 5*69e7c1a6SCostin Stroie (aider)use RecursiveIteratorIterator; 6*69e7c1a6SCostin Stroie (aider)use RecursiveDirectoryIterator; 7*69e7c1a6SCostin Stroie (aider) 859036814SCostin Stroieclass ChromaDBClient { 959036814SCostin Stroie private $baseUrl; 1059036814SCostin Stroie private $client; 1159036814SCostin Stroie private $ollamaClient; 1259036814SCostin Stroie private $tenant; 1359036814SCostin Stroie private $database; 1459036814SCostin Stroie private $ollamaHost; 1559036814SCostin Stroie private $ollamaPort; 16a068a1baSCostin Stroie (aider) private $ollamaModel; 17a068a1baSCostin Stroie (aider) 18a068a1baSCostin Stroie (aider) /** 19a068a1baSCostin Stroie (aider) * Get configuration value for the dokullm plugin 20a068a1baSCostin Stroie (aider) * 21a068a1baSCostin Stroie (aider) * @param string $key Configuration key 22a068a1baSCostin Stroie (aider) * @param mixed $default Default value if key not found 23a068a1baSCostin Stroie (aider) * @return mixed Configuration value 24a068a1baSCostin Stroie (aider) */ 2559036814SCostin Stroie /** 2659036814SCostin Stroie * Initialize the ChromaDB client 2759036814SCostin Stroie * 2859036814SCostin Stroie * Creates a new ChromaDB client instance with the specified connection parameters. 2959036814SCostin Stroie * Also ensures that the specified tenant and database exist. 3059036814SCostin Stroie * 317f9bf094SCostin Stroie (aider) * @param string $host ChromaDB server host 327f9bf094SCostin Stroie (aider) * @param int $port ChromaDB server port 337f9bf094SCostin Stroie (aider) * @param string $tenant ChromaDB tenant name 347f9bf094SCostin Stroie (aider) * @param string $database ChromaDB database name 35a223cb91SCostin Stroie (aider) * @param string $defaultCollection Default collection name 367f9bf094SCostin Stroie (aider) * @param string $ollamaHost Ollama server host 377f9bf094SCostin Stroie (aider) * @param int $ollamaPort Ollama server port 387f9bf094SCostin Stroie (aider) * @param string $ollamaModel Ollama embeddings model 3959036814SCostin Stroie */ 40a223cb91SCostin Stroie (aider) public function __construct($host, $port, $tenant, $database, $defaultCollection, $ollamaHost, $ollamaPort, $ollamaModel) { 4135d66f98SCostin Stroie (aider) // Use provided parameters (no fallback since they're mandatory) 4235d66f98SCostin Stroie (aider) $chromaHost = $host; 4335d66f98SCostin Stroie (aider) $chromaPort = $port; 4435d66f98SCostin Stroie (aider) $this->tenant = $tenant; 4535d66f98SCostin Stroie (aider) $this->database = $database; 46b1d13019SCostin Stroie $this->defaultCollection = $defaultCollection; 4735d66f98SCostin Stroie (aider) $this->ollamaHost = $ollamaHost; 4835d66f98SCostin Stroie (aider) $this->ollamaPort = $ollamaPort; 4935d66f98SCostin Stroie (aider) $this->ollamaModel = $ollamaModel; 50f2ab331fSCostin Stroie (aider) $this->baseUrl = "http://{$chromaHost}:{$chromaPort}"; 5159036814SCostin Stroie $this->client = curl_init(); 5259036814SCostin Stroie curl_setopt($this->client, CURLOPT_RETURNTRANSFER, true); 5359036814SCostin Stroie curl_setopt($this->client, CURLOPT_HTTPHEADER, [ 5459036814SCostin Stroie 'Content-Type: application/json', 5559036814SCostin Stroie 'Accept: application/json' 5659036814SCostin Stroie ]); 5759036814SCostin Stroie // Initialize Ollama client 5859036814SCostin Stroie $this->ollamaClient = curl_init(); 5959036814SCostin Stroie curl_setopt($this->ollamaClient, CURLOPT_RETURNTRANSFER, true); 6059036814SCostin Stroie curl_setopt($this->ollamaClient, CURLOPT_HTTPHEADER, [ 6159036814SCostin Stroie 'Content-Type: application/json' 6259036814SCostin Stroie ]); 6359036814SCostin Stroie // Check if tenant and database exist, create them if they don't 6459036814SCostin Stroie $this->ensureTenantAndDatabase(); 6559036814SCostin Stroie } 6659036814SCostin Stroie 6759036814SCostin Stroie /** 6859036814SCostin Stroie * Clean up the cURL client when the object is destroyed 6959036814SCostin Stroie * 7059036814SCostin Stroie * @return void 7159036814SCostin Stroie */ 7259036814SCostin Stroie public function __destruct() { 7359036814SCostin Stroie curl_close($this->client); 7459036814SCostin Stroie curl_close($this->ollamaClient); 7559036814SCostin Stroie } 7659036814SCostin Stroie 7759036814SCostin Stroie /** 7859036814SCostin Stroie * Make an HTTP request to the ChromaDB API 7959036814SCostin Stroie * 8059036814SCostin Stroie * This is a helper function that handles making HTTP requests to the ChromaDB API, 8159036814SCostin Stroie * including setting the appropriate headers for tenant and database. 8259036814SCostin Stroie * 8359036814SCostin Stroie * @param string $endpoint The API endpoint to call 8459036814SCostin Stroie * @param string $method The HTTP method to use (default: 'GET') 8559036814SCostin Stroie * @param array|null $data The data to send with the request (default: null) 8659036814SCostin Stroie * @return array The JSON response decoded as an array 8759036814SCostin Stroie * @throws Exception If there's a cURL error or HTTP error 8859036814SCostin Stroie */ 8959036814SCostin Stroie private function makeRequest($endpoint, $method = 'GET', $data = null) { 9059036814SCostin Stroie // Add tenant and database as headers instead of query parameters for v2 API 9159036814SCostin Stroie $headers = [ 9259036814SCostin Stroie 'Content-Type: application/json', 9359036814SCostin Stroie 'Accept: application/json' 9459036814SCostin Stroie ]; 95a74e859fSCostin Stroie // Version 2 9659036814SCostin Stroie $url = $this->baseUrl . '/api/v2' . $endpoint; 9759036814SCostin Stroie curl_setopt($this->client, CURLOPT_URL, $url); 9859036814SCostin Stroie curl_setopt($this->client, CURLOPT_CUSTOMREQUEST, $method); 9959036814SCostin Stroie curl_setopt($this->client, CURLOPT_HTTPHEADER, $headers); 100a74e859fSCostin Stroie // POST JSON data 10159036814SCostin Stroie if ($data) { 10259036814SCostin Stroie curl_setopt($this->client, CURLOPT_POSTFIELDS, json_encode($data)); 10359036814SCostin Stroie } else { 10459036814SCostin Stroie curl_setopt($this->client, CURLOPT_POSTFIELDS, null); 10559036814SCostin Stroie } 106a74e859fSCostin Stroie // Call 10759036814SCostin Stroie $response = curl_exec($this->client); 10859036814SCostin Stroie $httpCode = curl_getinfo($this->client, CURLINFO_HTTP_CODE); 109a74e859fSCostin Stroie // Check the result 11059036814SCostin Stroie if (curl_error($this->client)) { 1113eb8beceSCostin Stroie (aider) throw new \Exception('Curl error: ' . curl_error($this->client)); 11259036814SCostin Stroie } 11359036814SCostin Stroie if ($httpCode >= 400) { 1143eb8beceSCostin Stroie (aider) throw new \Exception("HTTP Error: $httpCode, Response: $response"); 11559036814SCostin Stroie } 116a74e859fSCostin Stroie // Return the decoded response 11759036814SCostin Stroie return json_decode($response, true); 11859036814SCostin Stroie } 11959036814SCostin Stroie 12059036814SCostin Stroie /** 12159036814SCostin Stroie * Generate embeddings for text using Ollama 12259036814SCostin Stroie * 12359036814SCostin Stroie * @param string $text The text to generate embeddings for 12459036814SCostin Stroie * @return array The embeddings vector 12559036814SCostin Stroie */ 12659036814SCostin Stroie public function generateEmbeddings($text) { 12759036814SCostin Stroie $ollamaUrl = "http://{$this->ollamaHost}:{$this->ollamaPort}/api/embeddings"; 12859036814SCostin Stroie curl_setopt($this->ollamaClient, CURLOPT_URL, $ollamaUrl); 12959036814SCostin Stroie $data = [ 13059036814SCostin Stroie 'model' => $this->ollamaModel, 13159036814SCostin Stroie 'prompt' => $text, 13259036814SCostin Stroie 'keep_alive' => '30m' 13359036814SCostin Stroie ]; 13459036814SCostin Stroie curl_setopt($this->ollamaClient, CURLOPT_POSTFIELDS, json_encode($data)); 13559036814SCostin Stroie $response = curl_exec($this->ollamaClient); 13659036814SCostin Stroie $httpCode = curl_getinfo($this->ollamaClient, CURLINFO_HTTP_CODE); 13759036814SCostin Stroie if (curl_error($this->ollamaClient)) { 1383eb8beceSCostin Stroie (aider) throw new \Exception('Ollama Curl error: ' . curl_error($this->ollamaClient)); 13959036814SCostin Stroie } 14059036814SCostin Stroie if ($httpCode >= 400) { 1413eb8beceSCostin Stroie (aider) throw new \Exception("Ollama HTTP Error: $httpCode, Response: $response"); 14259036814SCostin Stroie } 14359036814SCostin Stroie $result = json_decode($response, true); 14459036814SCostin Stroie if (!isset($result['embedding'])) { 1453eb8beceSCostin Stroie (aider) throw new \Exception("Ollama response missing embedding: " . $response); 14659036814SCostin Stroie } 14759036814SCostin Stroie return $result['embedding']; 14859036814SCostin Stroie } 14959036814SCostin Stroie 15059036814SCostin Stroie /** 15159036814SCostin Stroie * List all collections in the database 15259036814SCostin Stroie * 15359036814SCostin Stroie * Retrieves a list of all collections in the specified tenant and database. 15459036814SCostin Stroie * 15559036814SCostin Stroie * @return array List of collections 15659036814SCostin Stroie */ 15759036814SCostin Stroie public function listCollections() { 15859036814SCostin Stroie $endpoint = "/tenants/{$this->tenant}/databases/{$this->database}/collections"; 15959036814SCostin Stroie return $this->makeRequest($endpoint); 16059036814SCostin Stroie } 16159036814SCostin Stroie 16259036814SCostin Stroie /** 16359036814SCostin Stroie * Get a collection by name 16459036814SCostin Stroie * 16559036814SCostin Stroie * Retrieves information about a specific collection by its name. 16659036814SCostin Stroie * 16759036814SCostin Stroie * @param string $name The name of the collection to retrieve 16859036814SCostin Stroie * @return array The collection information 16959036814SCostin Stroie * @throws Exception If the collection is not found 17059036814SCostin Stroie */ 17159036814SCostin Stroie public function getCollection($name) { 17259036814SCostin Stroie // Use provided name, fallback to 'documents' if empty 17359036814SCostin Stroie if (empty($name)) { 17459036814SCostin Stroie $name = 'documents'; 17559036814SCostin Stroie } 17659036814SCostin Stroie // First try to get collection by name 17759036814SCostin Stroie $endpoint = "/tenants/{$this->tenant}/databases/{$this->database}/collections"; 17859036814SCostin Stroie $collections = $this->makeRequest($endpoint); 17959036814SCostin Stroie // Find collection by name 18059036814SCostin Stroie foreach ($collections as $collection) { 18159036814SCostin Stroie if (isset($collection['name']) && $collection['name'] === $name) { 18259036814SCostin Stroie return $collection; 18359036814SCostin Stroie } 18459036814SCostin Stroie } 18559036814SCostin Stroie // If not found, throw exception 1863eb8beceSCostin Stroie (aider) throw new \Exception("Collection '{$name}' not found"); 18759036814SCostin Stroie } 18859036814SCostin Stroie 18959036814SCostin Stroie /** 19059036814SCostin Stroie * Create a new collection 19159036814SCostin Stroie * 19259036814SCostin Stroie * Creates a new collection with the specified name and optional metadata. 19359036814SCostin Stroie * 19459036814SCostin Stroie * @param string $name The name of the collection to create 19559036814SCostin Stroie * @param array|null $metadata Optional metadata for the collection 19659036814SCostin Stroie * @return array The response from the API 19759036814SCostin Stroie */ 19859036814SCostin Stroie public function createCollection($name, $metadata = null) { 19959036814SCostin Stroie // Use provided name, fallback to 'documents' if empty 20059036814SCostin Stroie if (empty($name)) { 20159036814SCostin Stroie $name = 'documents'; 20259036814SCostin Stroie } 20359036814SCostin Stroie $endpoint = "/tenants/{$this->tenant}/databases/{$this->database}/collections"; 20459036814SCostin Stroie $data = ['name' => $name]; 20559036814SCostin Stroie if ($metadata) { 20659036814SCostin Stroie $data['metadata'] = $metadata; 20759036814SCostin Stroie } 20859036814SCostin Stroie return $this->makeRequest($endpoint, 'POST', $data); 20959036814SCostin Stroie } 21059036814SCostin Stroie 21159036814SCostin Stroie /** 21259036814SCostin Stroie * Delete a collection by name 21359036814SCostin Stroie * 21459036814SCostin Stroie * Deletes a collection with the specified name. 21559036814SCostin Stroie * 21659036814SCostin Stroie * @param string $name The name of the collection to delete 21759036814SCostin Stroie * @return array The response from the API 21859036814SCostin Stroie * @throws Exception If the collection ID is not found 21959036814SCostin Stroie */ 22059036814SCostin Stroie public function deleteCollection($name) { 22159036814SCostin Stroie // Use provided name, fallback to 'documents' if empty 22259036814SCostin Stroie if (empty($name)) { 22359036814SCostin Stroie $name = 'documents'; 22459036814SCostin Stroie } 22559036814SCostin Stroie // First get the collection to find its ID 22659036814SCostin Stroie $collection = $this->getCollection($name); 22759036814SCostin Stroie if (!isset($collection['id'])) { 2283eb8beceSCostin Stroie (aider) throw new \Exception("Collection ID not found for '{$name}'"); 22959036814SCostin Stroie } 23059036814SCostin Stroie $collectionId = $collection['id']; 23159036814SCostin Stroie $endpoint = "/tenants/{$this->tenant}/databases/{$this->database}/collections/{$collectionId}"; 23259036814SCostin Stroie return $this->makeRequest($endpoint, 'DELETE'); 23359036814SCostin Stroie } 23459036814SCostin Stroie 23559036814SCostin Stroie /** 23659036814SCostin Stroie * Get a document by its ID from a collection 23759036814SCostin Stroie * 23859036814SCostin Stroie * Retrieves a document from the specified collection using its ID. 23959036814SCostin Stroie * 24059036814SCostin Stroie * @param string $collectionName The name of the collection to get the document from 24159036814SCostin Stroie * @param string $documentId The document ID to retrieve 24259036814SCostin Stroie * @param array $include What to include in the response (default: ["metadatas", "documents"]) 24359036814SCostin Stroie * @return array The retrieved document 24459036814SCostin Stroie * @throws Exception If the collection ID is not found 24559036814SCostin Stroie */ 24659036814SCostin Stroie public function getDocument($collectionName, $documentId, $include = ["metadatas", "documents"]) { 24759036814SCostin Stroie // Use provided name, fallback to 'documents' if empty 24859036814SCostin Stroie if (empty($collectionName)) { 24959036814SCostin Stroie $collectionName = 'documents'; 25059036814SCostin Stroie } 25159036814SCostin Stroie // First get the collection to find its ID 25259036814SCostin Stroie $collection = $this->getCollection($collectionName); 25359036814SCostin Stroie if (!isset($collection['id'])) { 2543eb8beceSCostin Stroie (aider) throw new \Exception("Collection ID not found for '{$collectionName}'"); 25559036814SCostin Stroie } 25659036814SCostin Stroie $collectionId = $collection['id']; 25759036814SCostin Stroie $endpoint = "/tenants/{$this->tenant}/databases/{$this->database}/collections/{$collectionId}/get"; 25859036814SCostin Stroie $data = [ 25959036814SCostin Stroie 'ids' => [$documentId], 26059036814SCostin Stroie 'include' => $include 26159036814SCostin Stroie ]; 262a74e859fSCostin Stroie // Return the document 26359036814SCostin Stroie return $this->makeRequest($endpoint, 'POST', $data); 26459036814SCostin Stroie } 26559036814SCostin Stroie 26659036814SCostin Stroie /** 26759036814SCostin Stroie * Add documents to a collection 26859036814SCostin Stroie * 26959036814SCostin Stroie * Adds documents to the specified collection. Each document must have a corresponding ID. 27059036814SCostin Stroie * Optional metadata and pre-computed embeddings can also be provided. 27159036814SCostin Stroie * 27259036814SCostin Stroie * @param string $collectionName The name of the collection to add documents to 27359036814SCostin Stroie * @param array $documents The document contents 27459036814SCostin Stroie * @param array $ids The document IDs 27559036814SCostin Stroie * @param array|null $metadatas Optional metadata for each document 27659036814SCostin Stroie * @param array|null $embeddings Optional pre-computed embeddings for each document 27759036814SCostin Stroie * @return array The response from the API 27859036814SCostin Stroie * @throws Exception If the collection ID is not found 27959036814SCostin Stroie */ 28059036814SCostin Stroie public function addDocuments($collectionName, $documents, $ids, $metadatas = null, $embeddings = null) { 28159036814SCostin Stroie // Use provided name, fallback to 'documents' if empty 28259036814SCostin Stroie if (empty($collectionName)) { 28359036814SCostin Stroie $collectionName = 'documents'; 28459036814SCostin Stroie } 28559036814SCostin Stroie // First get the collection to find its ID 28659036814SCostin Stroie $collection = $this->getCollection($collectionName); 28759036814SCostin Stroie if (!isset($collection['id'])) { 2883eb8beceSCostin Stroie (aider) throw new \Exception("Collection ID not found for '{$collectionName}'"); 28959036814SCostin Stroie } 29059036814SCostin Stroie $collectionId = $collection['id']; 29159036814SCostin Stroie $endpoint = "/tenants/{$this->tenant}/databases/{$this->database}/collections/{$collectionId}/upsert"; 29259036814SCostin Stroie $data = [ 29359036814SCostin Stroie 'ids' => $ids, 29459036814SCostin Stroie 'documents' => $documents 29559036814SCostin Stroie ]; 296a74e859fSCostin Stroie // Get also the metadata 29759036814SCostin Stroie if ($metadatas) { 29859036814SCostin Stroie $data['metadatas'] = $metadatas; 29959036814SCostin Stroie } 300a74e859fSCostin Stroie // Get the embeddings 30159036814SCostin Stroie if ($embeddings) { 30259036814SCostin Stroie $data['embeddings'] = $embeddings; 30359036814SCostin Stroie } 304a74e859fSCostin Stroie // Return the respnse 30559036814SCostin Stroie return $this->makeRequest($endpoint, 'POST', $data); 30659036814SCostin Stroie } 30759036814SCostin Stroie 30859036814SCostin Stroie /** 30959036814SCostin Stroie * Check if a document needs to be updated based on timestamp comparison 31059036814SCostin Stroie * 31159036814SCostin Stroie * Determines whether a document should be reprocessed by comparing the file's last modification 31259036814SCostin Stroie * time with the processed_at timestamp stored in the document's metadata. The function checks 31359036814SCostin Stroie * the first 3 chunk IDs (@1, @2, @3) since the first chunks might be titles and therefore 31459036814SCostin Stroie * not included in the database. 31559036814SCostin Stroie * 31659036814SCostin Stroie * @param string $collectionId The ID of the collection to check documents in 31759036814SCostin Stroie * @param string $documentId The base document ID to check (without chunk suffixes) 31859036814SCostin Stroie * @param int $fileModifiedTime The file's last modification timestamp (from filemtime) 31959036814SCostin Stroie * @return bool True if document needs to be updated (doesn't exist, has no timestamp, or is outdated), false if up to date 32059036814SCostin Stroie * @throws Exception If there's an error checking the document 32159036814SCostin Stroie */ 32259036814SCostin Stroie public function needsUpdate($collectionId, $documentId, $fileModifiedTime) { 32359036814SCostin Stroie try { 32459036814SCostin Stroie $endpoint = "/tenants/{$this->tenant}/databases/{$this->database}/collections/{$collectionId}/get"; 32559036814SCostin Stroie // Check first 3 chunk numbers (@1, @2, @3) since first chunks might be titles and skipped 32659036814SCostin Stroie $chunkIdsToCheck = [ 32759036814SCostin Stroie $documentId . '@1', 32859036814SCostin Stroie $documentId . '@2', 32959036814SCostin Stroie $documentId . '@3' 33059036814SCostin Stroie ]; 33159036814SCostin Stroie $data = [ 33259036814SCostin Stroie 'ids' => $chunkIdsToCheck, 33359036814SCostin Stroie 'include' => [ 33459036814SCostin Stroie "metadatas" 33559036814SCostin Stroie ], 33659036814SCostin Stroie 'limit' => 1 33759036814SCostin Stroie ]; 33859036814SCostin Stroie // Check if document exists 33959036814SCostin Stroie $result = $this->makeRequest($endpoint, 'POST', $data); 34059036814SCostin Stroie // If no documents found, return true (needs to be added) 34159036814SCostin Stroie if (empty($result['ids'])) { 34259036814SCostin Stroie return true; 34359036814SCostin Stroie } 34459036814SCostin Stroie // Check if any document has a processed_at timestamp 34559036814SCostin Stroie if (!empty($result['metadatas']) && is_array($result['metadatas'])) { 34659036814SCostin Stroie // Check the first metadata entry directly 34759036814SCostin Stroie $metadata = $result['metadatas'][0]; 34859036814SCostin Stroie // If processed_at is not set, return true (needs update) 34959036814SCostin Stroie if (!isset($metadata['processed_at'])) { 35059036814SCostin Stroie return true; 35159036814SCostin Stroie } 35259036814SCostin Stroie // Parse the processed_at timestamp 35359036814SCostin Stroie $processedTimestamp = strtotime($metadata['processed_at']); 35459036814SCostin Stroie // If file is newer than processed time, return true (needs update) 35559036814SCostin Stroie if ($fileModifiedTime > $processedTimestamp) { 35659036814SCostin Stroie return true; 35759036814SCostin Stroie } 35859036814SCostin Stroie } 35959036814SCostin Stroie // Document exists and is up to date 36059036814SCostin Stroie return false; 3611f06f0c8SCostin Stroie (aider) } catch (\Exception $e) { 36259036814SCostin Stroie // If there's an error checking the document, assume it needs to be updated 36359036814SCostin Stroie return true; 36459036814SCostin Stroie } 36559036814SCostin Stroie } 36659036814SCostin Stroie 36759036814SCostin Stroie /** 36859036814SCostin Stroie * Query a collection for similar documents 36959036814SCostin Stroie * 37059036814SCostin Stroie * Queries the specified collection for documents similar to the provided query texts. 37159036814SCostin Stroie * The function generates embeddings for the query texts and sends them to ChromaDB. 37259036814SCostin Stroie * Supports filtering results by metadata using the where parameter. 37359036814SCostin Stroie * 37459036814SCostin Stroie * @param string $collectionName The name of the collection to query 37559036814SCostin Stroie * @param array $queryTexts The query texts to search for 37659036814SCostin Stroie * @param int $nResults The number of results to return (default: 5) 37759036814SCostin Stroie * @param array|null $where Optional filter conditions for metadata 37859036814SCostin Stroie * @return array The query results 37959036814SCostin Stroie * @throws Exception If the collection ID is not found 38059036814SCostin Stroie */ 38159036814SCostin Stroie public function queryCollection($collectionName, $queryTexts, $nResults = 5, $where = null) { 38259036814SCostin Stroie // Use provided name, fallback to 'documents' if empty 38359036814SCostin Stroie if (empty($collectionName)) { 38459036814SCostin Stroie $collectionName = 'documents'; 38559036814SCostin Stroie } 38659036814SCostin Stroie // First get the collection to find its ID 38759036814SCostin Stroie $collection = $this->getCollection($collectionName); 38859036814SCostin Stroie if (!isset($collection['id'])) { 3893eb8beceSCostin Stroie (aider) throw new \Exception("Collection ID not found for '{$collectionName}'"); 39059036814SCostin Stroie } 39159036814SCostin Stroie $collectionId = $collection['id']; 39259036814SCostin Stroie $endpoint = "/tenants/{$this->tenant}/databases/{$this->database}/collections/{$collectionId}/query"; 39359036814SCostin Stroie // Generate embeddings for query texts 39459036814SCostin Stroie $queryEmbeddings = []; 39559036814SCostin Stroie foreach ($queryTexts as $text) { 39659036814SCostin Stroie $queryEmbeddings[] = $this->generateEmbeddings($text); 39759036814SCostin Stroie } 39859036814SCostin Stroie $data = [ 39959036814SCostin Stroie 'query_embeddings' => $queryEmbeddings, 40059036814SCostin Stroie 'n_results' => $nResults 40159036814SCostin Stroie ]; 40259036814SCostin Stroie // Add where clause for metadata filtering if provided 40359036814SCostin Stroie if ($where && is_array($where)) { 40459036814SCostin Stroie $data['where'] = $where; 40559036814SCostin Stroie } 406a74e859fSCostin Stroie // Return the response 40759036814SCostin Stroie return $this->makeRequest($endpoint, 'POST', $data); 40859036814SCostin Stroie } 40959036814SCostin Stroie 41059036814SCostin Stroie /** 41159036814SCostin Stroie * Check if the ChromaDB server is alive 41259036814SCostin Stroie * 41359036814SCostin Stroie * Sends a heartbeat request to verify that the ChromaDB server is running. 41459036814SCostin Stroie * 41559036814SCostin Stroie * @return array The response from the heartbeat endpoint 41659036814SCostin Stroie */ 41759036814SCostin Stroie public function heartbeat() { 41859036814SCostin Stroie $endpoint = "/heartbeat"; 41959036814SCostin Stroie return $this->makeRequest($endpoint, 'GET'); 42059036814SCostin Stroie } 42159036814SCostin Stroie 42259036814SCostin Stroie /** 42359036814SCostin Stroie * Get authentication and identity information 42459036814SCostin Stroie * 42559036814SCostin Stroie * Retrieves authentication and identity information from the ChromaDB server. 42659036814SCostin Stroie * 42759036814SCostin Stroie * @return array The response from the auth/identity endpoint 42859036814SCostin Stroie */ 42959036814SCostin Stroie public function getIdentity() { 43059036814SCostin Stroie $endpoint = "/identity"; 43159036814SCostin Stroie return $this->makeRequest($endpoint, 'GET'); 43259036814SCostin Stroie } 43359036814SCostin Stroie 43459036814SCostin Stroie /** 43559036814SCostin Stroie * Ensure that the specified tenant and database exist 43659036814SCostin Stroie * 43759036814SCostin Stroie * Checks if the specified tenant and database exist, and creates them if they don't. 43859036814SCostin Stroie * 43959036814SCostin Stroie * @return void 44059036814SCostin Stroie */ 44159036814SCostin Stroie private function ensureTenantAndDatabase() { 44259036814SCostin Stroie // Check if tenant exists, create if it doesn't 44359036814SCostin Stroie try { 44459036814SCostin Stroie $this->getTenant($this->tenant); 4453eb8beceSCostin Stroie (aider) } catch (\Exception $e) { 44659036814SCostin Stroie // Tenant doesn't exist, create it 44759036814SCostin Stroie $this->createTenant($this->tenant); 44859036814SCostin Stroie } 44959036814SCostin Stroie // Check if database exists, create if it doesn't 45059036814SCostin Stroie try { 45159036814SCostin Stroie $this->getDatabase($this->database, $this->tenant); 4523eb8beceSCostin Stroie (aider) } catch (\Exception $e) { 45359036814SCostin Stroie // Database doesn't exist, create it 45459036814SCostin Stroie $this->createDatabase($this->database, $this->tenant); 45559036814SCostin Stroie } 45659036814SCostin Stroie } 45759036814SCostin Stroie 45859036814SCostin Stroie /** 45959036814SCostin Stroie * Get tenant information 46059036814SCostin Stroie * 46159036814SCostin Stroie * Retrieves information about the specified tenant. 46259036814SCostin Stroie * 46359036814SCostin Stroie * @param string $tenantName The tenant name 46459036814SCostin Stroie * @return array The tenant information 46559036814SCostin Stroie */ 46659036814SCostin Stroie public function getTenant($tenantName) { 46759036814SCostin Stroie $endpoint = "/tenants/{$tenantName}"; 46859036814SCostin Stroie return $this->makeRequest($endpoint, 'GET'); 46959036814SCostin Stroie } 47059036814SCostin Stroie 47159036814SCostin Stroie /** 47259036814SCostin Stroie * Create a new tenant 47359036814SCostin Stroie * 47459036814SCostin Stroie * Creates a new tenant with the specified name. 47559036814SCostin Stroie * 47659036814SCostin Stroie * @param string $tenantName The tenant name 47759036814SCostin Stroie * @return array The response from the API 47859036814SCostin Stroie */ 47959036814SCostin Stroie public function createTenant($tenantName) { 48059036814SCostin Stroie $endpoint = "/tenants"; 48159036814SCostin Stroie $data = ['name' => $tenantName]; 48259036814SCostin Stroie return $this->makeRequest($endpoint, 'POST', $data); 48359036814SCostin Stroie } 48459036814SCostin Stroie 48559036814SCostin Stroie /** 48659036814SCostin Stroie * Get database information 48759036814SCostin Stroie * 48859036814SCostin Stroie * Retrieves information about the specified database within a tenant. 48959036814SCostin Stroie * 49059036814SCostin Stroie * @param string $databaseName The database name 49159036814SCostin Stroie * @param string $tenantName The tenant name 49259036814SCostin Stroie * @return array The database information 49359036814SCostin Stroie */ 49459036814SCostin Stroie public function getDatabase($databaseName, $tenantName) { 49559036814SCostin Stroie $endpoint = "/tenants/{$tenantName}/databases/{$databaseName}"; 49659036814SCostin Stroie return $this->makeRequest($endpoint, 'GET'); 49759036814SCostin Stroie } 49859036814SCostin Stroie 49959036814SCostin Stroie /** 50059036814SCostin Stroie * Create a new database 50159036814SCostin Stroie * 50259036814SCostin Stroie * Creates a new database with the specified name within a tenant. 50359036814SCostin Stroie * 50459036814SCostin Stroie * @param string $databaseName The database name 50559036814SCostin Stroie * @param string $tenantName The tenant name 50659036814SCostin Stroie * @return array The response from the API 50759036814SCostin Stroie */ 50859036814SCostin Stroie public function createDatabase($databaseName, $tenantName) { 50959036814SCostin Stroie $endpoint = "/tenants/{$tenantName}/databases"; 51059036814SCostin Stroie $data = ['name' => $databaseName]; 51159036814SCostin Stroie return $this->makeRequest($endpoint, 'POST', $data); 51259036814SCostin Stroie } 51359036814SCostin Stroie 51459036814SCostin Stroie /** 51559036814SCostin Stroie * Ensure a collection exists, creating it if necessary 51659036814SCostin Stroie * 51759036814SCostin Stroie * This helper function checks if a collection exists and creates it if it doesn't. 51859036814SCostin Stroie * 51959036814SCostin Stroie * @param string $collectionName The name of the collection to check/create 52059036814SCostin Stroie * @return string Status message indicating what happened 52159036814SCostin Stroie */ 52259036814SCostin Stroie public function ensureCollectionExists($collectionName) { 52359036814SCostin Stroie try { 52459036814SCostin Stroie $collection = $this->getCollection($collectionName); 52559036814SCostin Stroie return "Collection '$collectionName' already exists."; 5263eb8beceSCostin Stroie (aider) } catch (\Exception $e) { 52759036814SCostin Stroie // Collection doesn't exist, create it 52859036814SCostin Stroie $created = $this->createCollection($collectionName); 52959036814SCostin Stroie return "Collection '$collectionName' created."; 53059036814SCostin Stroie } 53159036814SCostin Stroie } 53259036814SCostin Stroie 53359036814SCostin Stroie /** 53459036814SCostin Stroie * Process a single DokuWiki file and send it to ChromaDB with intelligent update checking 53559036814SCostin Stroie * 53659036814SCostin Stroie * This function handles the complete processing of a single DokuWiki file: 53759036814SCostin Stroie * 1. Parses the file path to extract metadata and document ID 53859036814SCostin Stroie * 2. Determines the appropriate collection based on document ID 53959036814SCostin Stroie * 3. Checks if the document needs updating using timestamp comparison 54059036814SCostin Stroie * 4. Reads and processes file content only if update is needed 54159036814SCostin Stroie * 5. Splits the document into chunks (paragraphs) 54259036814SCostin Stroie * 6. Extracts rich metadata from the DokuWiki ID format 54359036814SCostin Stroie * 7. Generates embeddings for each chunk 54459036814SCostin Stroie * 8. Sends all chunks to ChromaDB with metadata 54559036814SCostin Stroie * 54659036814SCostin Stroie * Supported ID formats: 54759036814SCostin Stroie * - Format 1: reports:mri:institution:250620-name-surname (third part is institution name) 54859036814SCostin Stroie * - Format 2: reports:mri:2024:g287-name-surname (third part is year) 54959036814SCostin Stroie * - Templates: reports:mri:templates:name-surname (contains 'templates' part) 55059036814SCostin Stroie * 55159036814SCostin Stroie * The function implements smart update checking by comparing file modification time 55259036814SCostin Stroie * with the 'processed_at' timestamp in document metadata to avoid reprocessing unchanged files. 55359036814SCostin Stroie * 55459036814SCostin Stroie * @param string $filePath The path to the file to process 55559036814SCostin Stroie * @param string $collectionName The name of the collection to use 55659036814SCostin Stroie * @param bool $collectionChecked Whether the collection has already been checked/created 55759036814SCostin Stroie * @return array Result with status and details 55859036814SCostin Stroie */ 55959036814SCostin Stroie public function processSingleFile($filePath, $collectionName, $collectionChecked = false) { 56059036814SCostin Stroie // Parse file path to extract metadata 56159036814SCostin Stroie $id = parseFilePath($filePath); 56259036814SCostin Stroie try { 56359036814SCostin Stroie // Create collection if it doesn't exist (only if not already checked) 56459036814SCostin Stroie $collectionStatus = ''; 56559036814SCostin Stroie if (!$collectionChecked) { 56659036814SCostin Stroie $collectionStatus = $this->ensureCollectionExists($collectionName); 56759036814SCostin Stroie } 56859036814SCostin Stroie // Get collection ID 56959036814SCostin Stroie $collection = $this->getCollection($collectionName); 57059036814SCostin Stroie if (!isset($collection['id'])) { 57159036814SCostin Stroie return [ 57259036814SCostin Stroie 'status' => 'error', 57359036814SCostin Stroie 'message' => "Collection ID not found for '{$collectionName}'" 57459036814SCostin Stroie ]; 57559036814SCostin Stroie } 57659036814SCostin Stroie $collectionId = $collection['id']; 57759036814SCostin Stroie // Get file modification time 57859036814SCostin Stroie $fileModifiedTime = filemtime($filePath); 57959036814SCostin Stroie // Check if document needs update 58059036814SCostin Stroie $needsUpdate = $this->needsUpdate($collectionId, $id, $fileModifiedTime); 58159036814SCostin Stroie // If document is up to date, skip processing 58259036814SCostin Stroie if (!$needsUpdate) { 58359036814SCostin Stroie return [ 58459036814SCostin Stroie 'status' => 'skipped', 58559036814SCostin Stroie 'message' => "Document '$id' is up to date in collection '$collectionName'. Skipping..." 58659036814SCostin Stroie ]; 58759036814SCostin Stroie } 58859036814SCostin Stroie // Read file content 58959036814SCostin Stroie $content = file_get_contents($filePath); 59059036814SCostin Stroie // Split document into chunks (paragraphs separated by two newlines) 59159036814SCostin Stroie $paragraphs = preg_split('/\n\s*\n/', $content); 59259036814SCostin Stroie $chunks = []; 59359036814SCostin Stroie $chunkMetadata = []; 59459036814SCostin Stroie // Parse the DokuWiki ID to extract base metadata 59559036814SCostin Stroie $parts = explode(':', $id); 59659036814SCostin Stroie // Extract metadata from the last part of the ID 59759036814SCostin Stroie $lastPart = end($parts); 59859036814SCostin Stroie $baseMetadata = []; 59959036814SCostin Stroie // Add the document ID as metadata 60059036814SCostin Stroie $baseMetadata['document_id'] = $id; 60159036814SCostin Stroie // Add current timestamp 60259036814SCostin Stroie $baseMetadata['processed_at'] = date('Y-m-d H:i:s'); 60359036814SCostin Stroie // Check if any part of the ID is 'templates' and set template metadata 60459036814SCostin Stroie $isTemplate = in_array('templates', $parts); 60559036814SCostin Stroie if ($isTemplate) { 60659036814SCostin Stroie $baseMetadata['type'] = 'template'; 60759036814SCostin Stroie } else { 60859036814SCostin Stroie $baseMetadata['type'] = 'report'; 60959036814SCostin Stroie } 61059036814SCostin Stroie // Extract modality from the second part 61159036814SCostin Stroie if (isset($parts[1])) { 61259036814SCostin Stroie $baseMetadata['modality'] = $parts[1]; 61359036814SCostin Stroie } 61459036814SCostin Stroie // Handle different ID formats based on the third part: word (institution) or numeric (year) 61559036814SCostin Stroie // Format 1: reports:mri:institution:250620-name-surname (third part is institution name) 61659036814SCostin Stroie // Format 2: reports:mri:2024:g287-name-surname (third part is year) 61759036814SCostin Stroie // For templates, don't set institution, date or year 61859036814SCostin Stroie if (isset($parts[2]) && !$isTemplate) { 61959036814SCostin Stroie // Check if third part is numeric (year) or word (institution) 62059036814SCostin Stroie if (is_numeric($parts[2])) { 62159036814SCostin Stroie // Format: reports:mri:2024:g287-name-surname (year format) 62259036814SCostin Stroie // Extract year from the third part 62359036814SCostin Stroie $baseMetadata['year'] = $parts[2]; 62459036814SCostin Stroie // Set default institution from config 62535d66f98SCostin Stroie (aider) global $conf; 62635d66f98SCostin Stroie (aider) $baseMetadata['institution'] = isset($conf['plugin']['dokullm']['default_institution']) ? $conf['plugin']['dokullm']['default_institution'] : 'default'; 62759036814SCostin Stroie // Extract registration and name from the last part 62859036814SCostin Stroie // Registration should start with one letter or number and contain numbers before the '-' character 62959036814SCostin Stroie if (preg_match('/^([a-zA-Z0-9]+[0-9]*)-(.+)$/', $lastPart, $matches)) { 63059036814SCostin Stroie // Check if the first part contains at least one digit to be considered a registration 63159036814SCostin Stroie if (preg_match('/[0-9]/', $matches[1])) { 63259036814SCostin Stroie $baseMetadata['registration'] = $matches[1]; 63359036814SCostin Stroie $baseMetadata['name'] = str_replace('-', ' ', $matches[2]); 63459036814SCostin Stroie } else { 63559036814SCostin Stroie // If no registration pattern found, treat entire part as patient name 63659036814SCostin Stroie $baseMetadata['name'] = str_replace('-', ' ', $lastPart); 63759036814SCostin Stroie } 63859036814SCostin Stroie } else { 63959036814SCostin Stroie // If no match, treat entire part as patient name 64059036814SCostin Stroie $baseMetadata['name'] = str_replace('-', ' ', $lastPart); 64159036814SCostin Stroie } 64259036814SCostin Stroie } else { 64359036814SCostin Stroie // Format: reports:mri:institution:250620-name-surname (institution format) 64459036814SCostin Stroie // Extract institution from the third part 64559036814SCostin Stroie $baseMetadata['institution'] = $parts[2]; 64659036814SCostin Stroie // Extract date and name from the last part 64759036814SCostin Stroie if (preg_match('/^(\d{6})-(.+)$/', $lastPart, $matches)) { 64859036814SCostin Stroie $dateStr = $matches[1]; 64959036814SCostin Stroie $name = $matches[2]; 65059036814SCostin Stroie // Convert date format (250620 -> 2025-06-20) 65159036814SCostin Stroie $day = substr($dateStr, 0, 2); 65259036814SCostin Stroie $month = substr($dateStr, 2, 2); 65359036814SCostin Stroie $year = substr($dateStr, 4, 2); 65459036814SCostin Stroie // Assuming 20xx for years 00-69 and 19xx for years 70-99 65559036814SCostin Stroie $fullYear = (int)$year <= 70 ? '20' . $year : '19' . $year; 65659036814SCostin Stroie $formattedDate = $fullYear . '-' . $month . '-' . $day; 65759036814SCostin Stroie $baseMetadata['date'] = $formattedDate; 65859036814SCostin Stroie $baseMetadata['name'] = str_replace('-', ' ', $name); 65959036814SCostin Stroie } 66059036814SCostin Stroie } 66159036814SCostin Stroie } 66259036814SCostin Stroie // For templates, always extract name from the last part 66359036814SCostin Stroie if ($isTemplate && isset($lastPart)) { 66459036814SCostin Stroie // Extract name from the last part (everything after the last colon) 66559036814SCostin Stroie if (preg_match('/^([a-zA-Z0-9]+[0-9]*)-(.+)$/', $lastPart, $matches)) { 66659036814SCostin Stroie // Check if the first part contains at least one digit to be considered a registration 66759036814SCostin Stroie if (preg_match('/[0-9]/', $matches[1])) { 66859036814SCostin Stroie $baseMetadata['registration'] = $matches[1]; 66959036814SCostin Stroie $baseMetadata['name'] = str_replace('-', ' ', $matches[2]); 67059036814SCostin Stroie } else { 67159036814SCostin Stroie // If no registration pattern found, treat entire part as template name 67259036814SCostin Stroie $baseMetadata['name'] = str_replace('-', ' ', $lastPart); 67359036814SCostin Stroie } 67459036814SCostin Stroie } else { 67559036814SCostin Stroie // If no match, treat entire part as template name 67659036814SCostin Stroie $baseMetadata['name'] = str_replace('-', ' ', $lastPart); 67759036814SCostin Stroie } 67859036814SCostin Stroie } 67959036814SCostin Stroie // Process each paragraph as a chunk with intelligent metadata handling 68059036814SCostin Stroie $chunkIds = []; 68159036814SCostin Stroie $chunkContents = []; 68259036814SCostin Stroie $chunkMetadatas = []; 68359036814SCostin Stroie $chunkEmbeddings = []; 68459036814SCostin Stroie $currentTags = []; 68559036814SCostin Stroie foreach ($paragraphs as $index => $paragraph) { 68659036814SCostin Stroie // Skip empty paragraphs to avoid processing whitespace-only content 68759036814SCostin Stroie $paragraph = trim($paragraph); 68859036814SCostin Stroie if (empty($paragraph)) { 68959036814SCostin Stroie continue; 69059036814SCostin Stroie } 69159036814SCostin Stroie // Check if this is a DokuWiki title (starts and ends with =) 69259036814SCostin Stroie // Titles are converted to tags for better searchability but not stored as content chunks 69359036814SCostin Stroie if (preg_match('/^=+(.*?)=+$/', $paragraph, $matches)) { 69459036814SCostin Stroie // Extract title content and clean it 69559036814SCostin Stroie $titleContent = trim($matches[1]); 69659036814SCostin Stroie // Split into words and create searchable tags 69759036814SCostin Stroie $words = preg_split('/\s+/', $titleContent); 69859036814SCostin Stroie $tags = []; 69959036814SCostin Stroie foreach ($words as $word) { 70059036814SCostin Stroie // Only use words longer than 3 characters to reduce noise 70159036814SCostin Stroie if (strlen($word) >= 3) { 70259036814SCostin Stroie $tags[] = strtolower($word); 70359036814SCostin Stroie } 70459036814SCostin Stroie } 70559036814SCostin Stroie // Remove duplicate tags and store for use in subsequent chunks 70659036814SCostin Stroie $currentTags = array_unique($tags); 70759036814SCostin Stroie continue; // Skip storing title chunks as content 70859036814SCostin Stroie } 70959036814SCostin Stroie // Create chunk ID 71059036814SCostin Stroie $chunkId = $id . '@' . ($index + 1); 71159036814SCostin Stroie // Generate embeddings for the chunk 71259036814SCostin Stroie $embeddings = $this->generateEmbeddings($paragraph); 71359036814SCostin Stroie // Add chunk-specific metadata 71459036814SCostin Stroie $metadata = $baseMetadata; 71559036814SCostin Stroie $metadata['chunk_id'] = $chunkId; 71659036814SCostin Stroie $metadata['chunk_number'] = $index + 1; 71759036814SCostin Stroie $metadata['total_chunks'] = count($paragraphs); 71859036814SCostin Stroie // Add current tags to metadata if any exist 71959036814SCostin Stroie if (!empty($currentTags)) { 72059036814SCostin Stroie $metadata['tags'] = implode(',', $currentTags); 72159036814SCostin Stroie } 72259036814SCostin Stroie // Store chunk data 72359036814SCostin Stroie $chunkIds[] = $chunkId; 72459036814SCostin Stroie $chunkContents[] = $paragraph; 72559036814SCostin Stroie $chunkMetadatas[] = $metadata; 72659036814SCostin Stroie $chunkEmbeddings[] = $embeddings; 72759036814SCostin Stroie } 72859036814SCostin Stroie // If no chunks were created, skip this file 72959036814SCostin Stroie if (empty($chunkIds)) { 73059036814SCostin Stroie return [ 73159036814SCostin Stroie 'status' => 'skipped', 73259036814SCostin Stroie 'message' => "No valid chunks found in file '$id'. Skipping..." 73359036814SCostin Stroie ]; 73459036814SCostin Stroie } 73559036814SCostin Stroie // Send all chunks to ChromaDB 73659036814SCostin Stroie $result = $this->addDocuments($collectionName, $chunkContents, $chunkIds, $chunkMetadatas, $chunkEmbeddings); 73759036814SCostin Stroie return [ 73859036814SCostin Stroie 'status' => 'success', 73959036814SCostin Stroie 'message' => "Successfully sent file to ChromaDB", 74059036814SCostin Stroie 'details' => [ 74159036814SCostin Stroie 'document_id' => $id, 74259036814SCostin Stroie 'chunks' => count($chunkIds), 74359036814SCostin Stroie 'collection' => $collectionName 74459036814SCostin Stroie ], 74559036814SCostin Stroie 'collection_status' => $collectionStatus 74659036814SCostin Stroie ]; 7471f06f0c8SCostin Stroie (aider) } catch (\Exception $e) { 74859036814SCostin Stroie return [ 74959036814SCostin Stroie 'status' => 'error', 75059036814SCostin Stroie 'message' => "Error sending file to ChromaDB: " . $e->getMessage() 75159036814SCostin Stroie ]; 75259036814SCostin Stroie } 75359036814SCostin Stroie } 75459036814SCostin Stroie 75559036814SCostin Stroie /** 75659036814SCostin Stroie * Process all DokuWiki files in a directory and send them to ChromaDB 75759036814SCostin Stroie * 75859036814SCostin Stroie * This function recursively processes all .txt files in a directory and its subdirectories. 75959036814SCostin Stroie * It first checks if the appropriate collection exists and creates it if needed. 76059036814SCostin Stroie * Then it processes each file individually. 76159036814SCostin Stroie * 76259036814SCostin Stroie * @param string $dirPath The directory path to process 76359036814SCostin Stroie * @return array Result with status and details 76459036814SCostin Stroie */ 76559036814SCostin Stroie public function processDirectory($dirPath) { 76659036814SCostin Stroie // Check if directory exists 76759036814SCostin Stroie if (!is_dir($dirPath)) { 76859036814SCostin Stroie return [ 76959036814SCostin Stroie 'status' => 'error', 77059036814SCostin Stroie 'message' => "Directory does not exist: $dirPath" 77159036814SCostin Stroie ]; 77259036814SCostin Stroie } 77359036814SCostin Stroie // Create RecursiveIteratorIterator to process directories recursively 77459036814SCostin Stroie $iterator = new RecursiveIteratorIterator( 77559036814SCostin Stroie new RecursiveDirectoryIterator($dirPath, RecursiveDirectoryIterator::SKIP_DOTS), 77659036814SCostin Stroie RecursiveIteratorIterator::LEAVES_ONLY 77759036814SCostin Stroie ); 77859036814SCostin Stroie $files = []; 77959036814SCostin Stroie foreach ($iterator as $file) { 78059036814SCostin Stroie // Process only .txt files that don't start with underscore 78159036814SCostin Stroie if ($file->isFile() && $file->getExtension() === 'txt' && $file->getFilename()[0] !== '_') { 78259036814SCostin Stroie $files[] = $file->getPathname(); 78359036814SCostin Stroie } 78459036814SCostin Stroie } 785a74e859fSCostin Stroie // Skip if no files 78659036814SCostin Stroie if (empty($files)) { 78759036814SCostin Stroie return [ 78859036814SCostin Stroie 'status' => 'skipped', 78959036814SCostin Stroie 'message' => "No .txt files found in directory: $dirPath" 79059036814SCostin Stroie ]; 79159036814SCostin Stroie } 79259036814SCostin Stroie // Use the first part of the document ID as collection name, fallback to 'documents' 79359036814SCostin Stroie $sampleFile = $files[0]; 79459036814SCostin Stroie $id = parseFilePath($sampleFile); 79559036814SCostin Stroie $idParts = explode(':', $id); 79659036814SCostin Stroie $collectionName = isset($idParts[0]) && !empty($idParts[0]) ? $idParts[0] : 'documents'; 79759036814SCostin Stroie try { 79859036814SCostin Stroie $this->ensureCollectionExists($collectionName); 79959036814SCostin Stroie $collectionChecked = true; 80059036814SCostin Stroie } catch (Exception $e) { 80159036814SCostin Stroie $collectionChecked = true; 80259036814SCostin Stroie } 803a74e859fSCostin Stroie // Send each file 80459036814SCostin Stroie $results = []; 80559036814SCostin Stroie foreach ($files as $file) { 80659036814SCostin Stroie $result = $this->processSingleFile($file, $collectionName, $collectionChecked); 80759036814SCostin Stroie $results[] = [ 80859036814SCostin Stroie 'file' => $file, 80959036814SCostin Stroie 'result' => $result 81059036814SCostin Stroie ]; 81159036814SCostin Stroie } 812a74e859fSCostin Stroie // Return the result 81359036814SCostin Stroie return [ 81459036814SCostin Stroie 'status' => 'success', 81559036814SCostin Stroie 'message' => "Finished processing directory.", 81659036814SCostin Stroie 'files_count' => count($files), 81759036814SCostin Stroie 'results' => $results 81859036814SCostin Stroie ]; 81959036814SCostin Stroie } 82059036814SCostin Stroie} 82159036814SCostin Stroie 82259036814SCostin Stroie/** 82359036814SCostin Stroie * Parse a file path and convert it to a DokuWiki ID 82459036814SCostin Stroie * 82559036814SCostin Stroie * Takes a file system path and converts it to the DokuWiki ID format by: 82659036814SCostin Stroie * 1. Removing the base path prefix (using DokuWiki's pages directory) 82759036814SCostin Stroie * 2. Removing the .txt extension 82859036814SCostin Stroie * 3. Converting directory separators to colons 82959036814SCostin Stroie * 83059036814SCostin Stroie * Example: /var/www/html/dokuwiki/data/pages/reports/mri/2024/g287-name-surname.txt 83159036814SCostin Stroie * Becomes: reports:mri:2024:g287-name-surname 83259036814SCostin Stroie * 83359036814SCostin Stroie * @param string $filePath The full file path to parse 83459036814SCostin Stroie * @return string The DokuWiki ID 83559036814SCostin Stroie */ 83659036814SCostin Stroiefunction parseFilePath($filePath) { 83759036814SCostin Stroie // Use DokuWiki's constant to get the pages directory if available 83859036814SCostin Stroie if (defined('DOKU_INC')) { 83959036814SCostin Stroie $pagesDir = DOKU_INC . 'data/pages/'; 84059036814SCostin Stroie } else { 84159036814SCostin Stroie // Fallback to common DokuWiki installation path 84259036814SCostin Stroie $pagesDir = '/var/www/html/dokuwiki/data/pages/'; 84359036814SCostin Stroie } 84459036814SCostin Stroie // Remove the base path 84559036814SCostin Stroie $relativePath = str_replace($pagesDir, '', $filePath); 84659036814SCostin Stroie // Remove .txt extension 84759036814SCostin Stroie $relativePath = preg_replace('/\.txt$/', '', $relativePath); 84859036814SCostin Stroie // Split path into parts and filter out empty parts 84959036814SCostin Stroie $parts = array_filter(explode('/', $relativePath)); 85059036814SCostin Stroie // Build DokuWiki ID (use first part as namespace) 85159036814SCostin Stroie $idParts = []; 85259036814SCostin Stroie foreach ($parts as $part) { 85359036814SCostin Stroie if (!empty($part)) { 85459036814SCostin Stroie $idParts[] = $part; 85559036814SCostin Stroie } 85659036814SCostin Stroie } 857a74e859fSCostin Stroie // Reurn the ID 85859036814SCostin Stroie return implode(':', $idParts); 85959036814SCostin Stroie} 860