Motivation repository

gistfile1.txt

<?php

namespace Gymloop\CoreBundle\Entity;

use Doctrine\ORM\EntityRepository;

/**
 * MotivationRepository
 *
 * This class was generated by the Doctrine ORM. Add your own custom
 * repository methods below.
 */
class MotivationRepository extends EntityRepository
{
  public function findOneOrderedByDate($user)
  {
    $query = $this->getEntityManager()->createQuery('
                          SELECT m FROM GymloopCoreBundle:Motivation m
                          WHERE m.user = :user
                          ORDER BY m.date DESC');

    $query->setParameter('user',$user);
    $query->setFirstResult(0);
    $query->setMaxResults(1);
    //@TODO if there is not result recorded for the user, return sth which indicates this
    return $query->getResult();

  }
}