/**
* {@inheritdoc}
*/
public function generate(Post $post)
{
return sprintf($this->pattern, $post->getYear(), $post->getMonth(), $post->getDay(), $post->getSlug());
}
/**
* get Current queryBuilder
*
* @param Post $article
* @return \Doctrine\ORM\QueryBuilder $queryBuilder
*/
public function getArticlesQueryBuilder(Post $article)
{
$queryBuilder = $this->createQueryBuilder('n')->select('n')->andWhere('n.publicationDateStart IS NULL OR DATE(n.publicationDateStart) <= CURRENT_DATE()')->setParameter('publicationDateStart', $article->getPublicationDateStart())->orderBy('n.publicationDateStart', 'desc')->addOrderBy('n.title', 'asc')->setMaxResults(1);
return $queryBuilder;
}
