DocumentManager::get_document_data_by_id()

Complexity

Conditions	19
Paths	435

Size

Total Lines	101
Code Lines	64

Duplication

Lines	0
Ratio	0 %

Importance

Changes

0

<?php
    public static function get_document_data_by_id(
        int $id,
        string $course_code,
        bool $load_parents = false,
        int $session_id = null,
        bool $ignoreDeleted = false
    ): bool|array {
        $course_info = api_get_course_info($course_code);
        if (empty($course_info)) {
            return false;
        }

        $course_id  = (int) $course_info['real_id'];
        $session_id = empty($session_id) ? api_get_session_id() : $session_id;

        $TABLE_DOCUMENT = Database::get_course_table(TABLE_DOCUMENT);
        $id = (int) $id;

        $sql = "SELECT * FROM $TABLE_DOCUMENT WHERE iid = $id";
        $result = Database::query($sql);
        if (!$result || Database::num_rows($result) != 1) {
            return false;
        }

        $row = Database::fetch_assoc($result);

        try {
            /** @var EntityManagerInterface $em */
            $em = \Database::getManager();

            /** @var Course|null $courseEntity */
            $courseEntity = $em->getRepository(Course::class)
                ->findOneBy(['code' => $course_code]);

            if ($courseEntity) {
                /** @var CDocumentRepository $docRepo */
                $docRepo = Container::getDocumentRepository();

                $qb = $docRepo->getResourcesByCourse($courseEntity,);
                $qb->andWhere('resource.iid = :iid')->setParameter('iid', $id);
                /** @var CDocument[] $docs */
                $docs = $qb->getQuery()->getResult();
                $doc  = $docs[0] ?? null;

                if ($doc) {
                    $fullPath  = (string) $doc->getFullPath();
                    $filetype  = (string) $doc->getFiletype();
                    $title     = (string) $doc->getTitle();
                    $size      = 0;

                    $node = $doc->getResourceNode();
                    if ($node && $filetype === 'file') {
                        $file = $node->getFirstResourceFile();
                        if ($file) {
                            $size = (int) $file->getSize();
                        }
                    } elseif ($node && $filetype === 'folder') {
                        $size = (int) $docRepo->getFolderSize($node, $courseEntity, null);
                    }

                    $row['path']       = $row['path']       ?? ('document/' . ltrim($fullPath, '/'));
                    $row['full_path']  = $row['full_path']  ?? $row['path'];
                    $row['filetype']   = $row['filetype']   ?? $filetype;
                    $row['file_type']  = $row['file_type']  ?? $filetype;
                    $row['title']      = $row['title']      ?? $title;
                    $row['size']       = $row['size']       ?? $size;
                    if (empty($row['parent_id'])) {
                        $parentNode = $node?->getParent();
                        if ($parentNode) {
                            $parentResource = $docRepo->getResourceByResourceNode($parentNode);
                            $row['parent_id'] = $parentResource?->getIid() ?? '0';
                        } else {
                            $row['parent_id'] = '0';
                        }
                    }
                }
            }
        } catch (\Throwable $e) {
            error_log('DOC_COMPAT: Fail CDocument iid='.$id.' -> '.$e->getMessage());
        }

        $row['url']          = api_get_path(WEB_CODE_PATH).'document/showinframes.php?id='.$id;
        $row['document_url'] = api_get_path(WEB_CODE_PATH).'document/document.php?id='.$id;
        $row['basename']     = $row['basename'] ?? $id;

        $parents = [];
        if ($load_parents) {
            $current_id = $row['parent_id'] ?? '0';
            $guard = 0;
            while ($current_id != '0' && $guard++ < 64) {
                $parent_data = self::get_document_data_by_id((int)$current_id, $course_code, false, $session_id);
                if (!$parent_data) {
                    break;
                }
                $parents[]  = $parent_data;
                $current_id = $parent_data['parent_id'] ?? '0';
            }
        }
        $row['parents'] = array_reverse($parents);

        return $row;
    }