geekhub-php / CheTheatre

class CustomerRepository extends \Doctrine\ORM\EntityRepository

{

    public $apiKey;

    public function findUsernameByApiKey($apiKey){

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

        $qb->select('u.username,u.id')

            // ->from('User', 'u')

            ->where('u.apiKey =:api')

            ->setParameter('api', $apiKey);

        //->getQuery()

        //->getResult();

        return $qb->getQuery()->getResult();

    }

    public $id;

    public function findUserByFacebookId($id){

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

        return $qb->getQuery()->getResult();

    }

    public $id;

    public function findUserByFacebookId($id){

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

        $qb->select('u.id, u.username, u.facebookID')

            // ->from('User', 'u')

            ->where('u.facebookID =:name')

            ->setParameter('name', $id);

        //->getQuery()

        //->getResult();

        return $qb->getQuery()->getResult();

    }

}