the-badger / badger

    /**

     * {@inheritdoc}

     */

    public function userHasBadge(UserInterface $user, BadgeInterface $badge)

    {

        $qb = $this->getEntityManager()->createQueryBuilder();

        $qb->select('badge.id')

            ->from('GameBundle:BadgeCompletion', 'completion')

            ->leftJoin('completion.badge', 'badge')

            ->where('completion.user = :user')

            ->andWhere('completion.pending = 0')

            ->setParameter('user', $user);

        $queryResult = $qb->getQuery()->getScalarResult();

        return array_column($queryResult, 'id');

    }

    /**

     * {@inheritdoc}

    /**

     * {@inheritdoc}

     */

    public function getQuestIdsClaimedByUser(UserInterface $user)

    {

        $qb = $this->getEntityManager()->createQueryBuilder();

        $qb->select('quest.id')

            ->from('GameBundle:QuestCompletion', 'completion')

            ->leftJoin('completion.quest', 'quest')

            ->where('completion.user = :user')

            ->andWhere('completion.pending = 1')

            ->setParameter('user', $user);

        $queryResult = $qb->getQuery()->getScalarResult();

        return array_column($queryResult, 'id');

    }

}