Newscoop\PaywallBundle\Meta\MetaSubscriptions::getSubscriptions()

Complexity

Conditions	1
Paths	1

Size

Total Lines	19
Code Lines	14

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	1	Features	0

<?php
    protected function getSubscriptions($publicationId, $userId)
    {
        $em = \Zend_Registry::get('container')->getService('em');

        $subscriptions = $em->getRepository("Newscoop\PaywallBundle\Entity\UserSubscription")
            ->createQueryBuilder('s')
            ->select('s.id')
            ->where('s.publication = :publicationId')
            ->andWhere('s.user = :userId')
            ->setParameters(array(
                'publicationId' => $publicationId,
                'userId' => $userId,
            ))
            ->orderBy('s.created_at', 'asc')
            ->getQuery()
            ->getArrayResult();

        return $subscriptions;
    }
}