Symfony Profiler

<?php
namespace App\DataProvider;
use ApiPlatform\Core\Bridge\Doctrine\Orm\Extension\QueryCollectionExtensionInterface;
use ApiPlatform\Core\Bridge\Doctrine\Orm\Extension\QueryResultCollectionExtensionInterface;
use ApiPlatform\Core\Bridge\Doctrine\Orm\Util\QueryNameGenerator;
use ApiPlatform\Core\DataProvider\ContextAwareCollectionDataProviderInterface;
use ApiPlatform\Core\DataProvider\RestrictedDataProviderInterface;
use ApiPlatform\Core\Exception\RuntimeException;
use Doctrine\ORM\EntityManagerInterface;
use Doctrine\Persistence\ManagerRegistry;
use App\Entity\Api\Article as Article;
use Score\CmsBundle\Entity\Article as CmsArticle;
use stdClass;
/*
use ApiPlatform\Core\Bridge\Doctrine\Orm\Extension\QueryCollectionExtensionInterface;
use ApiPlatform\Core\Bridge\Doctrine\Orm\Extension\QueryResultCollectionExtensionInterface;
use ApiPlatform\Core\DataProvider\ContextAwareCollectionDataProviderInterface;
use ApiPlatform\Core\DataProvider\RestrictedDataProviderInterface;
use App\Entity\Api\Article as Article;
use Score\CmsBundle\Entity\Article as CmsArticle;
use ApiPlatform\Core\Bridge\Doctrine\Orm\Extension\QueryResultItemExtensionInterface;
use ApiPlatform\Core\Bridge\Doctrine\Orm\Util\QueryNameGenerator;
use Doctrine\Persistence\ManagerRegistry;
use Doctrine\ORM\EntityManagerInterface;
use ApiPlatform\Core\Exception\RuntimeException;
*/
final class ArticleCollectionDataProvider implements ContextAwareCollectionDataProviderInterface, RestrictedDataProviderInterface
{
private $collectionExtensions;
private $managerRegistry;
public function __construct(ManagerRegistry $managerRegistry, iterable $collectionExtensions = [])
{
$this->managerRegistry = $managerRegistry;
$this->collectionExtensions = $collectionExtensions;
}
public function supports(string $resourceClass, string $operationName = null, array $context = []): bool
{
return Article::class === $resourceClass;
}
public function getCollection(string $resourceClass, string $operationName = null, array $context = []): iterable
{
$manager = $this->managerRegistry->getManagerForClass($resourceClass);
$repository = $manager->getRepository($resourceClass);
$cmsResourceClass = CmsArticle::class;
$cmsArticleRepository = $manager->getRepository($cmsResourceClass);
$queryBuilder = $cmsArticleRepository->createQueryBuilder('o');
$queryBuilder->leftJoin('o.siteItemArticle','a');
$queryBuilder->leftJoin('App\Entity\LanguageInfo', 'l', 'WITH', 'o.id = l.entityId AND l.entity = \'Article\'');
$pageSize = 20;
$currentPage = 1;
if(array_key_exists('page',$context['filters']))
{
$currentPage = $context['filters']['page'];
}
if(array_key_exists('itemsPerPage',$context['filters']))
{
$pageSize = $context['filters']['itemsPerPage'];
}
if(array_key_exists('filters',$context))
{
if(null != $this->getFilterCriteria('category',$context['filters']))
{
if(is_array($context['filters']['category']))
{
$orX = $queryBuilder->expr()->orX();
foreach($context['filters']['category'] as $key => $site)
{
$orX->add($queryBuilder->expr()->eq('o.category', ':category'.$key ));
}
foreach($context['filters']['category'] as $key => $site)
{
$queryBuilder->setParameter('category'.$key,$site);
}
$queryBuilder->andWhere($orX);
}
else
{
$queryBuilder->andWhere('o.category = :category');
$queryBuilder->setParameter('category',$context['filters']['category']);
}
}
if(null != $this->getFilterCriteria('slug',$context['filters']))
{
if(is_array($context['filters']['slug']))
{
$orX = $queryBuilder->expr()->orX();
foreach($context['filters']['slug'] as $key => $site)
{
$orX->add($queryBuilder->expr()->eq('o.slug', ':slug'.$key ));
}
foreach($context['filters']['slug'] as $key => $site)
{
$queryBuilder->setParameter('slug'.$key,$site);
}
$queryBuilder->andWhere($orX);
}
else
{
$queryBuilder->andWhere('o.slug = :slug');
$queryBuilder->setParameter('slug',$context['filters']['slug']);
}
}
if(null != $this->getFilterCriteria('site',$context['filters']))
{
if(is_array($context['filters']['site']))
{
$orX = $queryBuilder->expr()->orX();
foreach($context['filters']['site'] as $key => $site)
{
$orX->add($queryBuilder->expr()->eq('a.site', ':site'.$key ));
}
foreach($context['filters']['site'] as $key => $site)
{
$queryBuilder->setParameter('site'.$key,$site);
}
$queryBuilder->andWhere($orX);
}
else
{
$queryBuilder->andWhere('a.site = :site');
$queryBuilder->setParameter('site',$context['filters']['site']);
}
}
if(null != $this->getFilterCriteria('publishedFrom',$context['filters']))
{
//dump($context['filters']['publishedFrom']);
if(array_key_exists('before',$context['filters']['publishedFrom']) )
{
$queryBuilder->andWhere('o.publishedFrom <= :publishedFromBefore');
$queryBuilder->setParameter('publishedFromBefore',$context['filters']['publishedFrom']['before'].' 23:59:59');
}
if(array_key_exists('strictly_before',$context['filters']['publishedFrom']) )
{
$queryBuilder->andWhere('o.publishedFrom <= :publishedFromStrictlyBefore');
$queryBuilder->setParameter('publishedFromStrictlyBefore',$context['filters']['publishedFrom']['strictly_before'].' 00:00:00');
}
if(array_key_exists('after',$context['filters']['publishedFrom']) )
{
$queryBuilder->andWhere('o.publishedFrom >= :publishedFromAfter');
$queryBuilder->setParameter('publishedFromAfter',$context['filters']['publishedFrom']['after'].' 00:00:00');
}
if(array_key_exists('strictly_after',$context['filters']['publishedFrom']) )
{
$queryBuilder->andWhere('o.publishedFrom >= :publishedFromStrictlyAfter');
$queryBuilder->setParameter('publishedFromStrictlyAfter',$context['filters']['publishedFrom']['strictly_after'].' 23:59:59');
}
}
if(null != $this->getFilterCriteria('published',$context['filters']))
{
$queryBuilder->andWhere('o.published = :published');
$queryBuilder->setParameter('published',$context['filters']['published']);
}
}
if(null != $this->getFilterCriteria('lang',$context['filters']))
{
$queryBuilder->andWhere('l.language = :lang');
$queryBuilder->setParameter('lang',$context['filters']['lang']);
}
if(array_key_exists('filters',$context) and array_key_exists('order',$context['filters']))
{
foreach($context['filters']['order'] as $col => $direction)
{
$queryBuilder->addOrderBy('o.'.$col, $direction);
}
}
$pageFrom = $pageSize * ($currentPage-1);
$cmsArticles = $queryBuilder->getQuery()
->setFirstResult($pageFrom) // set the offset
->setMaxResults($pageSize) // set the limit
->getResult();
$queryBuilder->select('COUNT(o)');
$queryBuilder->resetDQLPart('orderBy');
$totalSize = $queryBuilder->getQuery()->getResult();
$total = $totalSize[0][1];
$lastPage = ceil($total/$pageSize);
$collection = [];
foreach($cmsArticles as $cmsArticle)
{
$article = $repository->getArticleFromCmsArticle($cmsArticle);
$collection[] = $article;
}
$meta = [
'current_page' => (int)$currentPage,
'from' => $pageFrom,
'to' => $pageFrom+$pageSize,
'per_page' => $pageSize,
'last_page' => $lastPage,
'total' => $total
];
$result = ['data' => $collection,'meta' => $meta];
return $result;
}
private function getFilterCriteria($index,$filterData)
{
$criteria = null;
if(array_key_exists($index,$filterData) and $filterData[$index] != null)
{
if(is_array($filterData[$index]))
{
$values = array_filter($filterData[$index]);
if(!empty($values ))
{
$criteria = $values ;
}
}
else
{
$criteria = trim($filterData[$index]);
}
}
if(null != $criteria and !empty($criteria))
{
return $criteria;
}
else
{
return null;
}
}
}

src/DataProvider/ArticleCollectionDataProvider.php line 196