src/Repository/PostRepository.php line 137

Open in your IDE?
  1. <?php
  3. namespace App\Repository;
  5. use App\Entity\Post;
  6. use App\Entity\PostTranslation;
  7. use Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository;
  8. use Doctrine\Persistence\ManagerRegistry;
  9. use Symfony\Component\Intl\Locale;
  10. use App\Pagination\Paginator;
  12. /**
  13.  * @method Post|null find($id, $lockMode = null, $lockVersion = null)
  14.  * @method Post|null findOneBy(array $criteria, array $orderBy = null)
  15.  * @method Post[]    findAll()
  16.  * @method Post[]    findBy(array $criteria, array $orderBy = null, $limit = null, $offset = null)
  17.  */
  18. class PostRepository extends ServiceEntityRepository
  19. {
  20.     public function __construct(ManagerRegistry $registry)
  21.     {
  22.         parent::__construct($registry, Post::class);
  23.     }
  25.     /** find conut nb resultat post **/
  26.     public function findCountPost($type = null)
  27.     {
  29.         $locale = Locale::getDefault();
  30.         $sql =  $this->createQueryBuilder('p')
  31.                      ->select('count(p.id)');
  32.       
  33.         if($type != null){
  34.             $sql->join('p.type_post','typePost')
  35.                 ->andWhere('typePost.id = :type')
  36.                 ->setParameter('type', $type);
  37.         }
  39.         return $sql->getQuery()->getSingleScalarResult();
  40.     }
  41.     /** end off method **/
  43.     public function findPostBySlug($slug)
  44.     {
  46.         $locale = Locale::getDefault();
  47.         $sql =  $this->createQueryBuilder('p')
  48.                      ->join('p.translations','t')
  49.                      ->andWhere('t.locale = :locale')
  50.                      ->setParameter('locale', $locale);
  51.       
  52.         if($slug){
  53.             $sql->andWhere('t.slug = :slug')
  54.                 ->setParameter('slug', $slug);
  55.         }
  57.         return $sql->getQuery()->getOneOrNullResult();
  58.     }
  60.         
  61.     public function findAllPostByType($locale,$type,$IdSite)
  62.     {
  63.        
  64.         $sql =  $this->createQueryBuilder('p')
  65.                      ->join('p.translations','t')
  66.                      ->andWhere('p.post_archive = 0 OR p.post_archive is null')
  67.                      ->andWhere('t.locale = :locale')
  68.                      ->setParameter('locale', $locale);
  70.         if($type){
  71.             $sql->join('p.type_post','tp')
  72.                 ->andWhere('tp.id = :type')
  73.                 ->setParameter('type', $type);
  75.             // if($type == '6'){
  76.             //     $sql->orderBy('p.date_publication','DESC');
  77.             // }
  78.         }
  79.      
  80.         $sql->orderBy('p.position','ASC');
  81.         return $sql->getQuery()->getResult();
  82.     }
  84.     public function findPostByType($type,$option,$nb)
  85.     {
  86.         $locale = Locale::getDefault();
  87.         $sql =  $this->createQueryBuilder('p')
  88.                      ->join('p.translations','t')
  89.                      ->join('p.type_post','typePost')
  90.                      ->andWhere('typePost.id = :type')
  91.                      ->andWhere('t.actif = true')
  92.                      ->andWhere('t.locale = :locale')
  93.                      ->setParameter('locale', $locale)
  94.                      ->setParameter('type', $type)
  95.                      ->setMaxResults($nb);
  97.         if($option == '1'){
  98.             $sql->orderBy('p.id', 'ASC');
  99.         }elseif($option == '2'){
  100.             $sql->orderBy('p.id', 'DESC');
  101.         }
  102.       
  103.         return $sql->getQuery()->getResult();
  104.     }
  106.     public function findPostActifsHomeByType($type,$option,$nb = 1,$all_post = false)
  107.     {
  108.         $locale = Locale::getDefault();
  109.         $sql =  $this->createQueryBuilder('p')
  110.                      ->join('p.translations','t')
  111.                      ->join('p.type_post','typePost')
  112.                      ->andWhere('typePost.id = :type')
  113.                      ->andWhere('t.actif = true')
  114.                      ->andWhere('p.actif_home = 1')
  115.                      ->andWhere('t.locale = :locale')
  116.                      ->setParameter('locale', $locale)
  117.                      ->setParameter('type', $type);
  119.                      
  121.         if($all_post == false){
  122.            $sql->setMaxResults($nb);
  123.         }
  125.         if($option == '1'){
  126.             $sql->orderBy('p.id', 'ASC');
  127.         }elseif($option == '2'){
  128.             $sql->orderBy('p.id', 'DESC');
  129.         }elseif($option == '3'){
  130.             $sql->orderBy('p.date_publication','DESC');
  131.         }elseif($option == '4'){
  132.             $sql->orderBy('p.position', 'ASC');
  133.         }elseif($option == '5'){
  134.             $sql->orderBy('RAND()');
  135.         }
  136.       
  137.         return $sql->getQuery()->getResult();
  138.     }
  140.     public function findPostByTypeInterne($type,$option,$nb)
  141.     {
  142.         $locale = Locale::getDefault();
  143.         $sql =  $this->createQueryBuilder('p')
  144.                      ->join('p.translations','t')
  145.                      ->join('p.type_post','typePost')
  146.                      ->andWhere('typePost.id = :type')
  147.                      ->andWhere('t.actif = true')
  148.                      ->andWhere('t.locale = :locale')
  149.                      ->setParameter('locale', $locale)
  150.                      ->setParameter('type', $type)
  151.                      ->setMaxResults($nb);
  153.         if($option == '1'){
  154.             $sql->orderBy('p.id', 'ASC');
  155.         }elseif($option == '2'){
  156.             $sql->orderBy('p.id', 'DESC');
  157.         }elseif($option == '3'){
  158.             $sql->orderBy('p.date_publication','DESC');
  159.         }elseif($option == '4'){
  160.             $sql->orderBy('p.position', 'ASC');
  161.         }elseif($option == '5'){
  162.             $sql->orderBy('RAND()');
  163.         }
  164.       
  165.         return $sql->getQuery()->getResult();
  166.     }
  168.     
  169.     public function findPostBySystemName($name)
  170.     {
  171.         $locale = Locale::getDefault();
  173.         $sql =  $this->createQueryBuilder('p')
  174.                      ->join('p.type_post','typePost')
  175.                      ->join('typePost.translations','translation')
  176.                      ->join('p.translations','t')
  177.                      ->andWhere('t.actif = true')
  178.                      ->andWhere('translation.system_name = :name')
  179.                      ->andWhere('translation.locale = :locale')
  180.                      ->setParameter('locale', $locale)
  181.                      ->setParameter('name', $name)
  182.                      ->getQuery()
  183.                      ->getResult();
  184.      
  185.         return $sql;
  186.     }
  189.     public function findPostBySystemNames($system_name)
  190.     {
  191.         $locale = Locale::getDefault();
  193.         $sql =  $this->createQueryBuilder('p')
  194.                      ->join('p.type_post','typePost')
  195.                      ->join('typePost.translations','translation')
  196.                      ->join('p.translations','t')
  197.                      ->andWhere('t.actif = true')
  198.                      ->andWhere("translation.system_name IN(:system_name)")
  199.                      ->andWhere('translation.locale = :locale')
  200.                      ->setParameter('locale', $locale)
  201.                      ->setParameter('system_name', $system_name)
  202.                      ->getQuery()
  203.                      ->getResult();
  204.      
  205.         return $sql;
  206.     }
  209.     public function findPostByCategory($categorie,$pagination,$page = 1,$page_size = 10)
  210.     {
  212.         $locale = Locale::getDefault();
  213.         $sql =  $this->createQueryBuilder('p')
  214.                      ->join('p.translations','t')
  215.                      ->join('p.PostCategory','post_categorie')
  216.                      ->andWhere('t.actif = true')
  217.                      ->andWhere('post_categorie.Category =:categorie_id')
  218.                      ->andWhere('t.locale = :locale')
  219.                      ->setParameter('locale', $locale)
  220.                      ->setParameter('categorie_id', $categorie)
  221.                      ->orderBy('p.position', 'ASC');
  224.         if ($pagination == true) {
  225.             return (new Paginator($sql))->paginate($page,$page_size);
  226.         }else{
  227.             return $sql->getQuery()->getResult();
  228.         }
  230.     }
  232.     /**
  233.      * Retourne les posts par type et par id avec limit
  234.      */
  236.     public function getPostsWithLimit($locale,$type,$limit,$order,$IdSite)
  237.     {
  238.        
  239.         $sql =  $this->createQueryBuilder('p')
  240.                      ->join('p.translations','t')
  241.                      ->andWhere('t.locale = :locale')
  242.                      ->setParameter('locale', $locale);
  244.         if($type){
  245.             $sql->join('p.type_post','tp')
  246.                 ->andWhere('tp.id = :type')
  247.                 ->setParameter('type', $type);
  249.            /* if($type == '6'){
  250.               $sql->orderBy('p.date_publication','DESC');
  251.            } */
  252.         }
  254.         switch ($order) {
  255.             case 0:
  256.                 $sql->orderBy('RAND()');
  257.                 break;
  258.             case 1:
  259.                 $sql->orderBy('p.id','ASC');
  260.                 break;
  261.             case 2:
  262.                 $sql->orderBy('p.id','DESC');
  263.                 break;
  264.             case 3:
  265.                 $sql->orderBy('p.date_publication','DESC');
  266.                 break;
  267.             
  268.             default:
  269.                 $sql->orderBy('p.id','ASC');
  270.                 break;
  271.         }
  273.         if($limit){
  274.             $sql->setMaxResults($limit);
  275.         }
  276.      
  277.         return $sql->getQuery()->getResult();
  278.     }
  280.     /**
  281.      * Retourne la liste des catégories du post
  282.      */
  284.     public function getCategoryPost($post_category, $_locale){
  285.         $categories = [];
  287.         if($post_category){
  288.             foreach ($post_category as $key => $post_cat) {
  289.               if($post_cat->getCategory()){
  290.                 $cat = $post_cat->getCategory();
  291.                 $categories[] = ['id'=> $cat->getId(),'title'=> $cat->translate($_locale)->getTitreCategorie()];
  292.               }
  293.             }
  294.          }
  296.          return $categories;
  297.     }
  300.     // get article prev or next   
  301.     public function findPostPrevOrNext($ids_categories,$id_post,$action = 'next')
  302.     {
  304.         $locale = Locale::getDefault();
  305.         $sql =  $this->createQueryBuilder('p')
  306.                      ->join('p.translations','t')
  307.                      ->join('p.PostCategory','post_categorie')
  308.                      ->andWhere('t.actif = true')
  309.                      ->andWhere('p.id != :id_post')
  310.                      ->andWhere('post_categorie.Category IN (:ids_categories)')
  311.                      ->andWhere('t.locale = :locale')
  312.                      ->setParameter('locale', $locale)
  313.                      ->setParameter('ids_categories', $ids_categories)
  314.                      ->setMaxResults(1);
  316.                     
  317.         if($action == 'next') {
  318.              $sql->andWhere('p.id > :id_post')
  319.                  ->orderBy('p.id', 'asc');
  320.         }else{
  321.              $sql->andWhere('p.id < :id_post')
  322.                  ->orderBy('p.id', 'DESC');
  323.         }
  325.         $sql->setParameter('id_post', $id_post);
  327.         return $sql->getQuery()->getOneOrNullResult();
  329.     }
  333. }