Application\Repository\FileRepository::getAccessibleSubQuery()

Complexity

Conditions	5
Paths	4

Size

Total Lines	23
Code Lines	12

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	10
CRAP Score	5.0187

Importance

Changes

0

<?php
    public function getAccessibleSubQuery(?User $user): string
    {
        if (!$user) {
            return '-1';
        }

        if (in_array($user->getRole(), [User::ROLE_FACILITATOR, User::ROLE_ADMINISTRATOR], true)) {
            return $this->getAllIdsQuery();
        }

        if (!$user->getWebTemporaryAccess() && !in_array($user->getSubscriptionType(), [ProductTypeType::BOTH, ProductTypeType::DIGITAL], true)) {
            $webTypesSql = '(' .
                $this->getEntityManager()->getConnection()->quote(ProductTypeType::BOTH) . ', ' .
                $this->getEntityManager()->getConnection()->quote(ProductTypeType::DIGITAL) .
                ')';

            return '
SELECT file.id FROM file
INNER JOIN product p ON file.product_id = p.id AND p.is_active and p.type IN ' . $webTypesSql . '
';
        }

        return '';
    }