public function getArticles($published = null)
{
$articleRepository = $this->em->getRepository('Newscoop\\Entity\\Article');
if ($published) {
return $articleRepository->createQueryBuilder('a')->select('COUNT(a)')->where('a.workflowStatus = \'Y\'')->getQuery()->getSingleScalarResult();
} else {
return $articleRepository->createQueryBuilder('a')->select('COUNT(a)')->getQuery()->getSingleScalarResult();
}
}