src/Services/Search/SearchPost.php line 12

Open in your IDE?
  1. <?php
  3. namespace App\Services\Search;
  5. use App\Services\Search\BaseSearch;
  6. use App\Entity\Post;
  7. use \DateTime;
  8. use App\Cache\Helper as CacheHelper;
  10. class SearchPost extends BaseSearch
  11. {
  12.     public function get($aOptions)
  13.     {
  14.         $default_options = [
  15.             'ids_collection' => false,
  16.             'sorting' => 'name',
  17.             'aStatus' => [
  18.                 Post::STATUS_INIT,
  19.                 Post::STATUS_READY,
  20.                 Post::STATUS_WAITING,
  21.             ],
  22.             'max_results' => false,
  23.             'page' => 1,
  24.             'aExcluded_ids' => false,
  25.             //'show_hidden' => false,
  26.             'show_pagination' => false,
  27.             'return_count' => false // if true, will only return the count instead of the rows
  28.         ];
  29.         $aOptions = $this->getOptions($default_options, $aOptions);
  31.         $alias = '_'.uniqid();
  32.         $qb = $this->em->createQueryBuilder();
  33.         if($aOptions['return_count'])
  34.         {
  35.             $qb->select($qb->expr()->countDistinct($alias.'.id'));
  36.         } else {
  37.             $qb->select('DISTINCT '.$alias.'.id');
  38.         }
  39.         $qb->from(Post::class, $alias);
  41.         // Static collection of IDs
  42.         if(is_array($aOptions['ids_collection']))
  43.         {
  44.             if(empty($aOptions['ids_collection']))
  45.             {
  46.                 // 'ids_collection' rules over any other entry; if it comes empty, show empty results
  47.                 return [
  48.                     'results' => [],
  49.                     'pagination' => false
  50.                 ];
  51.             } else {
  52.                 $qb->andWhere(
  53.                     $qb->expr()->in($alias.'.id', $aOptions['ids_collection'])
  54.                 );
  55.             }
  56.         }
  58.         if(!empty($aOptions['aExcluded_ids']))
  59.         {
  60.             $qb->andWhere(
  61.                 $qb->expr()->notIn($alias.'.id', $aOptions['aExcluded_ids'])
  62.             );
  63.         }
  65.         if($aOptions['aStatus'])
  66.         {
  67.             $qb->andWhere(
  68.                 $qb->expr()->in($alias.'.status', $aOptions['aStatus'])
  69.             );
  70.         }
  72.         switch($aOptions['sorting'])
  73.         {
  74.             case 'date':
  75.                 $qb->orderBy($alias.'.publish_date','DESC');
  76.                 break;
  77.             case 'field': // preserve order set in 'ids_collection' param
  78.                 if(is_array($aOptions['ids_collection']) && !empty($aOptions['ids_collection']))
  79.                 {
  80.                     $qb
  81.                         ->addSelect("FIELD(".$alias.".id, ".implode(', ', $aOptions['ids_collection']).") AS HIDDEN sorting")
  82.                         ->orderBy('sorting', 'ASC');
  83.                 }
  84.                 break;
  85.             case 'name':
  86.                 $qb->orderBy($alias.'.name','ASC');
  87.                 break;
  88.             case 'random': // expensive query
  89.                 $qb
  90.                     ->addSelect("RAND() AS HIDDEN random_value")
  91.                     ->orderBy('random_value', 'ASC');
  92.                 break;
  93.         }
  95.         $query = $qb->getQuery();
  97.         /*if(!$aOptions['show_pagination'] && $aOptions['max_results'])
  98.         {
  99.             $query->setMaxResults($aOptions['max_results']);
  100.         }*/
  102.         $resultCache_id = CacheHelper::fixId(Post::class).'_collection_'.md5($query->getSQL());
  103.         $resultCache_ttl = 604800;
  105.         if(!$aOptions['no_cache'])
  106.         {
  107.             $query
  108.                 ->useQueryCache(true)
  109.                 ->setResultCacheLifetime($resultCache_ttl)
  110.                 ->setResultCacheId($resultCache_id);
  111.         }
  113.         return $aOptions['return_count'] ? [
  114.             'results' => $query->getSingleScalarResult(),
  115.             'pagination' => false
  116.         ] : $this->paginate([
  117.             'aResults' => $query->getArrayResult(),
  118.             'repository_class' => Post::class,
  119.             'max_results' => $aOptions['max_results'],
  120.             'page' => $aOptions['page'],
  121.             'show_pagination' => $aOptions['show_pagination'],
  122.             'paginator_params' => $aOptions['paginator_params'],
  123.             'paginator_route' => $aOptions['paginator_route']
  124.         ]);
  125.     }
  126. }