Waca\Security\UserAccessLoader::loadDomainsForUser()

Complexity

Conditions	2
Paths	2

Size

Total Lines	24
Code Lines	14

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

<?php
    public function loadDomainsForUser(User $user): array
    {
        $database = $user->getDatabase();

        $statement = $database->prepare(<<<'SQL'
            SELECT d.* 
            FROM domain d
            INNER JOIN userdomain ud on d.id = ud.domain
            WHERE ud.user = :user
            AND d.enabled = 1
SQL
        );
        $statement->execute([
            ':user' => $user->getId()
        ]);

        $resultObjects = $statement->fetchAll(PDO::FETCH_CLASS, Domain::class);

        /** @var Domain $t */
        foreach ($resultObjects as $t) {
            $t->setDatabase($database);
        }

        return $resultObjects;
    }
}