CDocumentRepository::getAllDocumentDataByUserAndGroup()

Complexity

Conditions	7
Paths	24

Size

Total Lines	66
Code Lines	36

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	1

<?php
    public function getAllDocumentDataByUserAndGroup(
        Course $course,
        string $path = '/',
        int $toGroupId = 0,
        ?int $toUserId = null,
        bool $search = false,
        ?Session $session = null
    ): array {
        $qb = $this->createQueryBuilder('d');
        
        $qb->innerJoin('d.resourceNode', 'rn')
            ->innerJoin('rn.resourceLinks', 'rl')
            ->where('rl.course = :course')
            ->setParameter('course', $course);
        
        // Session filtering
        if ($session) {
            $qb->andWhere('(rl.session = :session OR rl.session IS NULL)')
            ->setParameter('session', $session);
        } else {
            $qb->andWhere('rl.session IS NULL');
        }
        
        // Path filtering - convert document.lib.php logic to Doctrine
        if ($path !== '/') {
            // The original uses LIKE with path patterns
            $pathPattern = rtrim($path, '/') . '/%';
            $qb->andWhere('rn.title LIKE :pathPattern OR rn.title = :exactPath')
            ->setParameter('pathPattern', $pathPattern)
            ->setParameter('exactPath', ltrim($path, '/'));
            
            // Exclude deeper nested paths if not searching
            if (!$search) {
                // Exclude paths with additional slashes beyond the current level
                $excludePattern = rtrim($path, '/') . '/%/%';
                $qb->andWhere('rn.title NOT LIKE :excludePattern')
                ->setParameter('excludePattern', $excludePattern);
            }
        }
        
        // User/Group filtering
        if ($toUserId !== null) {
            if ($toUserId > 0) {
                $qb->andWhere('rl.user = :userId')
                ->setParameter('userId', $toUserId);
            } else {
                $qb->andWhere('rl.user IS NULL');
            }
        } else {
            if ($toGroupId > 0) {
                $qb->andWhere('rl.group = :groupId')
                ->setParameter('groupId', $toGroupId);
            } else {
                $qb->andWhere('rl.group IS NULL');
            }
        }
        
        // Exclude deleted documents (like %_DELETED_% in original)
        $qb->andWhere('rn.title NOT LIKE :deletedPattern')
        ->setParameter('deletedPattern', '%_DELETED_%');
        
        // Order by creation date (equivalent to last.iid DESC)
        $qb->orderBy('rn.createdAt', 'DESC')
        ->addOrderBy('rn.id', 'DESC');
        
        return $qb->getQuery()->getResult();
    }