Application\Repository\FileRepository::getAccessibleSubQuery()

Complexity

Conditions	5
Paths	4

Size

Total Lines	23
Code Lines	12

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	8
CRAP Score	5.5069

Importance

Changes	1
Bugs	0	Features	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();
        }

        $webTypes = [ProductTypeType::BOTH, ProductTypeType::DIGITAL];
        if ($user->getWebTemporaryAccess() || in_array($user->getSubscriptionType(), $webTypes, true)) {
            $webTypesSql = implode(',', array_map(function (string $val): string {
                return $this->getEntityManager()->getConnection()->quote($val);
            }, $webTypes));

            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 '-1';
    }