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