Application\Repository\OrganizationRepository

Complexity

Total Complexity

1

Size/Duplication

Total Lines	29
Duplicated Lines	0 %

Test Coverage

Coverage

100%

Importance

Changes	1
Bugs	0	Features	0

1 Method

Rating	Name	Duplication	Size	Complexity
A	applyOrganizationAccesses()	0	21	1

<?php

declare(strict_types=1);

namespace Application\Repository;

class OrganizationRepository extends AbstractRepository
{
    /**
     * Apply the organizations accesses to all users
     *
     * - If a user email matches the org pattern and the org access is better, then user will get the org access
     * - If many organizations match then only the best one is used
     */
    public function applyOrganizationAccesses(): void
    {
        $connection = $this->getEntityManager()->getConnection();

        $sqlUpgrade = <<<STRING
                UPDATE user
                INNER JOIN (
                    SELECT user.email, MAX(product.review_number) AS bestReviewNumber
                    FROM organization
                    INNER JOIN product ON organization.subscription_last_review_id = product.id
                    INNER JOIN user ON user.email REGEXP organization.pattern
                    GROUP BY user.email
                ) AS bestMatch ON user.email = bestMatch.email
                INNER JOIN product AS orgProduct ON orgProduct.review_number = bestMatch.bestReviewNumber
                LEFT JOIN product AS userProduct ON userProduct.id = user.subscription_last_review_id
                SET
                    user.subscription_last_review_id = IF(userProduct.id IS NULL OR orgProduct.review_number > userProduct.review_number, orgProduct.id, userProduct.id),
                    user.subscription_type = IF(user.subscription_type IN ('paper', 'both'), 'both', 'digital')
            STRING;

        $connection->executeUpdate($sqlUpgrade);
    }
}