OrganizationRepository::getBestMatchingOrganization()

Complexity

Conditions	1
Paths	1

Size

Total Lines	19
Code Lines	9

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	10
CRAP Score	1

Importance

Changes	1
Bugs	0	Features	0

<?php
    {
        $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);