| private getEndingSubscriptions ( ) : Newscoop\Subscription\Subscription | ||
| return | Newscoop\Subscription\Subscription | |
private function getEndingSubscriptions()
{
$subscriptions = $this->em->getRepository('Newscoop\\Subscription\\Subscription')->createQueryBuilder('s')->select('s, p, u, a')->leftJoin('s.publication', 'p')->leftJoin('s.user', 'u')->leftJoin('p.defaultAlias', 'a')->where('s.active = :active')->andWhere('s.toPay = :toPay')->getQuery()->setParameters(array('active' => 'Y', 'toPay' => '0.00'))->getResult();
return $subscriptions;
}