public function getPostsSearchPager(array $criteria, $page, $limit = 10, array $sort = array())
{
$parameters = array();
$em = $this->postManager->getEntityManager();
$query = $em->createQueryBuilder()->select('p')->from('AppBundle:News\\Post', 'p')->orderBy('p.publicationDateStart', 'DESC');
if ($criteria['search']) {
$query->andWhere('p.title LIKE :search');
$parameters['search'] = (string) '%' . $criteria['search'] . '%';
}
/* d($parameters); */
$query->setParameters($parameters);
/*dd($query->getQuery()->getResult());*/
/* d($query->getResult()); */
$pager = new Pager();
$pager->setMaxPerPage($limit);
$pager->setQuery(new ProxyQuery($query));
$pager->setPage($page);
/*dd($criteria);*/
$pager->init();
return $pager;
}
