/**
* 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;
}
