|
public getArticlesForAuthorPerDay ( |
||
| $author | ||
| $range | string | |
| Результат | Doctrine\ORM\Query | |
public function getArticlesForAuthorPerDay($author, $range = '-60 days')
{
$em = $this->getEntityManager();
$date = new \DateTime();
$date->modify($range);
$queryBuilder = $em->getRepository('Newscoop\\Entity\\Article')->createQueryBuilder('a')->select('COUNT(a.number) as number', "DATE_FORMAT(a.published, '%Y-%m-%d') as date")->where('au.id = :author')->andWhere('a.workflowStatus = :status')->andWhere('a.published > :date')->join('a.authors', 'au')->setParameter('author', $author)->setParameter('status', 'Y')->setParameter('date', $date)->groupBy('date');
return $queryBuilder->getQuery();
}