BCRM / www

    /**

     * @return Option

     */

    public function getNextEvent()

    {

        $qb = $this->createQueryBuilder('e');

        $qb->andWhere('e.registrationStart <= :now');

        $qb->setParameter('now', new \DateTime());

        $qb->setMaxResults(1);

        $qb->orderBy('e.start', 'ASC');

        $event = $qb->getQuery()->getOneOrNullResult();

        return $event == null ? None::create() : new Some($event);

    }

    /**

     * @param Event $event

     *

     * @return \PhpOption\Option

     */

    public function getUnregistrationByIdAndKey($id, $key)

    {

        $qb = $this->createQueryBuilder('u');

        $qb->andWhere('u.id = :id')->setParameter('id', $id);

        $qb->andWhere('u.confirmationKey = :key')->setParameter('key', $key);

        $result = $qb->getQuery()->getOneOrNullResult();

        return $result === null ? None::create() : new Some($result);

    }

    /**

     * @param Event $event