<?php

namespace App\Repository;

use App\Entity\Article;

use Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository;

use Doctrine\Persistence\ManagerRegistry;

/**

* @method Article|null find($id, $lockMode = null, $lockVersion = null)

* @method Article|null findOneBy(array $criteria, array $orderBy = null)

* @method Article[] findAll()

* @method Article[] findBy(array $criteria, array $orderBy = null, $limit = null, $offset = null)

*/

class ArticleRepository extends ServiceEntityRepository

{

public function __construct(ManagerRegistry $registry)

{

parent::__construct($registry, Article::class);

}

public function findPostCountByDate(string $after = null, string $before = null)

{

$qb = $this->createQueryBuilder('a')

->select('date_format(a.createdAt, \'%Y-%m-%d\') as date', 'COUNT(a.id) as count')

->groupBy('date')

->orderBy('a.createdAt', 'asc')

;

if ($after) {

$qb->andWhere('a.createdAt >= :after')->setParameter('after', new \DateTime($after));

}

if ($before) {

$qb->andWhere('a.createdAt <= :before')->setParameter('before', new \DateTime($before));

}

return $qb->getQuery()->getResult();

}

// /**

// * @return Article[] Returns an array of Article objects

// */

/*

public function findByExampleField($value)

{

return $this->createQueryBuilder('a')

->andWhere('a.exampleField = :val')

->setParameter('val', $value)

->orderBy('a.id', 'ASC')

->setMaxResults(10)

->getQuery()

->getResult()

;

}

*/

/*

public function findOneBySomeField($value): ?Article

{

return $this->createQueryBuilder('a')

->andWhere('a.exampleField = :val')

->setParameter('val', $value)

->getQuery()

->getOneOrNullResult()

;

}

*/

}