Chamilo\CoreBundle\Migrations\Schema\V200\Version20250106151300::fixHtmlLinks()

Complexity

Conditions	6
Paths	1

Size

Total Lines	59
Code Lines	29

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

<?php
    private function fixHtmlLinks(string $content, int $documentId, int $resourceNodeId, int $currentCourseId): string
    {
        // Define the pattern to find resource links
        $pattern = '/\/r\/document\/files\/([a-f0-9\-]+)\/view/';

        return preg_replace_callback($pattern, function ($matches) use ($documentId, $resourceNodeId, $currentCourseId) {
            $uuid = $matches[1];

            // Normalize UUID by removing dashes and converting to binary
            $cleanUuid = strtoupper(str_replace('-', '', $uuid));
            $uuidBinary = pack('H*', $cleanUuid);

            // Check the resource link for the given UUID and fetch title
                $query = '
                SELECT rl.resource_node_id, rl.c_id, rn.title
                FROM resource_link rl
                JOIN resource_node rn ON rl.resource_node_id = rn.id
                WHERE rn.uuid = UNHEX(:uuid)
            ';
            $resourceData = $this->connection->fetchAssociative($query, ['uuid' => $cleanUuid]);

            if ($resourceData && $resourceData['c_id'] === $currentCourseId) {
                // Log debugging information
                error_log("Document ID $documentId, Resource Node $resourceNodeId: Valid resource found for UUID $uuid in the correct course $currentCourseId");

                // Return the corrected link with original UUID format
                return "/r/document/files/$uuid/view";
            } elseif ($resourceData) {
                // If the course ID doesn't match, find the correct file in the current course
                error_log("Document ID $documentId, Resource Node $resourceNodeId: UUID $uuid does not belong to course $currentCourseId. Searching for the correct file...");

                $documentRepo = $this->container->get(CDocumentRepository::class);
                $courseRepo = $this->container->get(CourseRepository::class);
                $title = $resourceData['title'];

                // Load the Course object
                $course = $courseRepo->find($currentCourseId);
                if (!$course) {
                    error_log("Document ID $documentId, Resource Node $resourceNodeId: Course with ID $currentCourseId not found.");
                    return $matches[0]; // Return original link if course not found
                }

                // Search for a document in the current course by title
                $correctDocument = $documentRepo->findResourceByTitleInCourse($title, $course);

                if ($correctDocument) {
                    $newUrl = $documentRepo->getResourceFileUrl($correctDocument);
                    error_log("Document ID $documentId: Correct URL found: $newUrl");

                    return $newUrl;
                } else {
                    error_log("Document ID $documentId, Resource Node $resourceNodeId: No document found for title $title in course $currentCourseId.");
                }
            }

            // Log missing resource data
            error_log("Document ID $documentId, Resource Node $resourceNodeId: Resource link for UUID $uuid not found.");
            return $matches[0]; // Return original link if no match found
        }, $content);
    }