geekhub-php / serve-seattle

 */

class SurveyRepository extends \Doctrine\ORM\EntityRepository

{

    public function findSurveyByStatus($status)

    {

        $query = $this->createQueryBuilder('s')

            ->where('s.status = :status')

            ->setParameter('status', $status)

            ->orderBy('s.updatedAt', 'DESC')

            ->getQuery();

        return $query->getResult();

    }

    public function findSurveyByUser($user)

    {

        return $query->getResult();

    }

    public function findSurveyByUser($user)

    {

        $query = $this->createQueryBuilder('s')

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

            ->setParameter('user', $user)

            ->orderBy('s.updatedAt', 'DESC')

            ->getQuery();

        return $query->getResult();

    }

}