PHP Desarrolla2\Bundle\BlogBundle\Entity Tag::getSlug Examples

Example #1

File: PostRepository.php Project: radutopala/BlogBundle

 /**
  *
  * @param  \Desarrolla2\Bundle\BlogBundle\Entity\Tag $tag
  * @return \Doctrine\ORM\Query
  */
 public function getQueryForGetByTag(Tag $tag)
 {
     $em = $this->getEntityManager();
     $query = $em->createQuery(' SELECT p FROM BlogBundle:Post p ' . ' JOIN p.tags t ' . ' WHERE p.status = ' . PostStatus::PUBLISHED . ' AND t.slug  = :slug ' . ' ORDER BY p.publishedAt DESC ')->setParameter('slug', $tag->getSlug());
     return $query;
 }