gregorybesson / PlaygroundGame

     * @param unknown_type $game

     * @param unknown_type $user

     */

    public function findLastEntriesByUser($game, $user, $dateLimit)

    {

        $query = $this->em->createQuery(

            'SELECT e.id FROM PlaygroundGame\Entity\Entry e 

             WHERE e.user = :user AND e.game = :game AND (e.bonus = 0 OR e.bonus IS NULL) AND e.created_at >= :date'

        );

        $query->setParameter('user', $user);

        $query->setParameter('game', $game);

        $query->setParameter('date', $dateLimit);

        $total = $query->getResult();

        return $total;

    }

    public function findLastEntriesByAnonymousIdentifier($game, $anonymousIdentifier, $dateLimit)

    {

        return $total;

    }

    public function findLastEntriesByAnonymousIdentifier($game, $anonymousIdentifier, $dateLimit)

    {

        $query = $this->em->createQuery(

            'SELECT e.id FROM PlaygroundGame\Entity\Entry e 

             WHERE e.anonymousIdentifier = :anonymousIdentifier AND e.game = :game 

             AND (e.bonus = 0 OR e.bonus IS NULL) AND e.created_at >= :date'

        );

        $query->setParameter('anonymousIdentifier', $anonymousIdentifier);

        $query->setParameter('game', $game);

        $query->setParameter('date', $dateLimit);

        $total = $query->getResult();

        return $total;

    }

    public function findLastEntriesByIp($game, $ip, $dateLimit)

    {

        return $total;

    }

    public function findLastEntriesByIp($game, $ip, $dateLimit)

    {

        $query = $this->em->createQuery(

            'SELECT e.id FROM PlaygroundGame\Entity\Entry e 

             WHERE e.ip = :ip AND e.game = :game AND (e.bonus = 0 OR e.bonus IS NULL) AND e.created_at >= :date'

        );

        $query->setParameter('ip', $ip);

        $query->setParameter('game', $game);

        $query->setParameter('date', $dateLimit);

        $total = $query->getResult();

        return $total;

    }

    /**

     * Get all the entries of the player except those offered as bonus

     * @param unknown_type $game

     * @param unknown_type $user

     */

    public function countLastEntriesByUser($game, $user, $dateLimit)

    {

        $query = $this->em->createQuery(

            'SELECT COUNT(e.id) FROM PlaygroundGame\Entity\Entry e 

             WHERE e.user = :user AND e.game = :game AND (e.bonus = 0 OR e.bonus IS NULL) AND e.created_at >= :date'

        );

        $query->setParameter('user', $user);

        $query->setParameter('game', $game);

        $query->setParameter('date', $dateLimit);

        $total = $query->getSingleScalarResult();

        return $total;

    }

    public function countLastEntriesByAnonymousIdentifier($game, $anonymousIdentifier, $dateLimit)

    {

        return $total;

    }

    public function countLastEntriesByAnonymousIdentifier($game, $anonymousIdentifier, $dateLimit)

    {

        $query = $this->em->createQuery(

            'SELECT COUNT(e.id) FROM PlaygroundGame\Entity\Entry e 

             WHERE e.anonymousIdentifier = :anonymousIdentifier AND e.game = :game 

             AND (e.bonus = 0 OR e.bonus IS NULL) AND e.created_at >= :date'

        );

        $query->setParameter('anonymousIdentifier', $anonymousIdentifier);

        $query->setParameter('game', $game);

        $query->setParameter('date', $dateLimit);

        $total = $query->getSingleScalarResult();

        return $total;

    }

    public function countLastEntriesByIp($game, $ip, $dateLimit)

    {

        return $total;

    }

    public function countLastEntriesByIp($game, $ip, $dateLimit)

    {

        $query = $this->em->createQuery(

            'SELECT COUNT(e.id) FROM PlaygroundGame\Entity\Entry e 

             WHERE e.ip = :ip AND e.game = :game AND (e.bonus = 0 OR e.bonus IS NULL) AND e.created_at >= :date'

        );

        $query->setParameter('ip', $ip);

        $query->setParameter('game', $game);

        $query->setParameter('date', $dateLimit);

        $total = $query->getSingleScalarResult();

        return $total;

    }

    /**

     * get users with only one participation able to