src/Repository/ArticleRepository.php line 131

Open in your IDE?
  1. <?php
  3. namespace App\Repository;
  5. use App\Entity\Article;
  6. use App\Entity\WebsiteLanguage;
  7. use Doctrine\Persistence\ManagerRegistry;
  8. use App\Repository\WebsiteLanguageRepository;
  9. use Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository;
  11. /**
  12.  * @method Article|null find($id, $lockMode = null, $lockVersion = null)
  13.  * @method Article|null findOneBy(array $criteria, array $orderBy = null)
  14.  * @method Article[]    findAll()
  15.  * @method Article[]    findBy(array $criteria, array $orderBy = null, $limit = null, $offset = null)
  16.  */
  17. class ArticleRepository extends ServiceEntityRepository
  18. {
  19.     public function __construct(ManagerRegistry $registry)
  20.     {
  21.         parent::__construct($registry, Article::class);
  22.     }
  24.     public function getArticles($published)
  25.     {
  26.         return $this->createQueryBuilder('a')
  27.             ->where('a.published = :published')
  28.             ->setParameter('published', $published)
  29.             ->getQuery();
  30.     }
  32.     public function getArticlesByLanguage($locale)
  33.     {
  34.         return $this->createQueryBuilder('a')
  35.             ->join('a.websiteLanguage', 'w')
  36.             ->andWhere('w.slug = :locale')
  37.             ->setParameter('locale', $locale)
  38.             ->orderBy('a.featuredAt' , 'DESC')
  39.             ->getQuery()
  40.             ->getResult();
  41.     }
  43.     public function getArticleOriginal($published, $original = true)
  44.     {
  45.         return $this->createQueryBuilder('a')
  46.             ->where('a.published = :published')
  47.             ->setParameter('published', $published)
  48.             ->andWhere('a.original = :original')
  49.             ->setParameter('original', $original)
  50.             ->orderBy('a.id', 'DESC')
  51.             ->getQuery()
  52.             ->getResult();
  53.     }
  55.     public function getArticleTranslate($unit)
  56.     {
  57.         return $this->createQueryBuilder('a')
  58.             ->where('a.unit = :unit')
  59.             ->setParameter('unit', $unit)
  60.             ->getQuery()
  61.             ->getResult();
  62.     }
  64.     public function getMyArticles($published, $user)
  65.     {
  66.         return $this->createQueryBuilder('a')
  67.             ->where('a.published = :published')
  68.             ->setParameter('published', $published)
  69.             ->andWhere('a.author = :author')
  70.             ->setParameter('author', $user)
  71.             ->andWhere('a.original = :true')
  72.             ->setParameter('true', true)
  73.             ->orWhere('a.reviewer = :reviewer')
  74.             ->setParameter('reviewer', $user)
  75.             ->getQuery()
  76.             ->getResult();
  77.     }
  79.     public function getFourFeaturedArticles($locale)
  80.     {
  81.         return $this->createQueryBuilder('a')
  82.             ->where('a.published = :published')
  83.             ->setParameter('published', true)
  84.             ->andWhere('a.featured = true')
  85.             ->join('a.websiteLanguage', 'w')
  86.             ->andWhere('w.slug = :locale')
  87.             ->setParameter('locale', $locale)
  88.             ->orderBy('a.featuredAt' , 'DESC')
  89.             ->setMaxResults(4)
  90.             ->getQuery()
  91.             ->getResult();
  92.     }
  94.     public function getLatestArticles($locale, $limit)
  95.     {
  96.         return $this->createQueryBuilder('a')
  97.             ->where('a.published = :published')
  98.             ->setParameter('published', true)
  99.             ->join('a.websiteLanguage', 'w')
  100.             ->andWhere('w.slug = :locale')
  101.             ->setParameter('locale', $locale)
  102.             ->orderBy('a.createdDate' , 'DESC')
  103.             ->setMaxResults($limit)
  104.             ->getQuery()
  105.             ->getResult();
  106.     }
  108.     public function getNumberOfCategorizedArticles($locale, $category, $number = 4,  $slug = '')
  109.     {
  110.         $query = $this->createQueryBuilder('a');
  112.         if ($category || count($category) > 0) {
  113.             $query->orWhere(':category MEMBER OF a.categories')
  114.                   ->setParameter('category', $category);
  115.         }
  117.         return $query
  118.                     ->join('a.websiteLanguage', 'w')
  119.                     ->andWhere('w.slug = :locale')
  120.                     ->setParameter('locale', $locale)
  121.                     ->andWhere('a.slug NOT LIKE :slug')
  122.                     ->setParameter('slug', $slug)
  123.                     ->andWhere('a.published = :published')
  124.                     ->setParameter('published', true)
  125.                     ->orderBy('a.createdDate' , 'DESC')
  126.                     ->setMaxResults($number)
  127.                     ->getQuery()->getResult();
  129.     }
  131.     public function getLatestNews($locale)
  132.     {
  133.         return $this->createQueryBuilder('a')
  134.             ->where('a.published = :published')
  135.             ->setParameter('published', true)
  136.             ->join('a.websiteLanguage', 'w')
  137.             ->andWhere('w.slug = :locale')
  138.             ->setParameter('locale', $locale)
  139.             ->orderBy('a.createdDate' , 'DESC')
  140.             ->getQuery();
  141.     }
  143.     public function getTopDeals($locale, $category)
  144.     {
  145.         return $this->createQueryBuilder('a')
  146.             ->where('a.published = :published')
  147.             ->setParameter('published', true)
  148.             ->andWhere(':category MEMBER OF a.categories')
  149.             ->setParameter('category', $category)
  150.             ->join('a.websiteLanguage', 'w')
  151.             ->andWhere('w.slug = :locale')
  152.             ->setParameter('locale', $locale)
  153.             ->orderBy('a.createdDate' , 'DESC')
  154.             ->getQuery();
  155.     }
  157.     public function getSearchedArticles($locale, $search)
  158.     {
  159.         return $this->createQueryBuilder('a')
  160.             ->where('a.published = :published')
  161.             ->setParameter('published', true)
  162.             ->andWhere('a.title LIKE :search')
  163.             ->setParameter('search', '%' . $search->getTitle() . '%')
  164.             ->join('a.websiteLanguage', 'w')
  165.             ->andWhere('w.slug = :locale')
  166.             ->setParameter('locale', $locale)
  167.             ->orderBy('a.createdDate' , 'DESC')
  168.             ->getQuery();
  169.     }
  171.     public function findCategoryArticles($locale, $category)
  172.     {
  173.         return $this->createQueryBuilder('a')
  174.             ->where('a.published = :published')
  175.             ->setParameter('published', true)
  176.             ->join('a.websiteLanguage', 'w')
  177.             ->andWhere('w.slug = :locale')
  178.             ->setParameter('locale', $locale)
  179.             ->andWhere(':category MEMBER OF a.categories')
  180.             ->setParameter('category', $category)
  181.             ->orderBy('a.createdDate' , 'DESC')
  182.             ->getQuery();
  183.     }
  185.     public function getSearchedCategoryArticles($locale, $search, $category)
  186.     {
  187.         return $this->createQueryBuilder('a')
  188.             ->where('a.published = :published')
  189.             ->setParameter('published', true)
  190.             ->andWhere('a.title LIKE :search')
  191.             ->setParameter('search', '%' . $search->getTitle() . '%')
  192.             ->join('a.websiteLanguage', 'w')
  193.             ->andWhere('w.slug = :locale')
  194.             ->setParameter('locale', $locale)
  195.             ->andWhere(':category MEMBER OF a.categories')
  196.             ->setParameter('category', $category)
  197.             ->orderBy('a.createdDate' , 'DESC')
  198.             ->getQuery();
  199.     }
  201.     public function getReviewCount()
  202.     {
  203.         return $this->createQueryBuilder('a')
  204.                     ->where('a.status = :review')
  205.                     ->setParameter('review', 'review')
  206.                     ->select('count(a.id)')
  207.                     ->getQuery()
  208.                     ->getSingleScalarResult();
  209.     }
  211.     public function getArticleToTranslate()
  212.     {
  213.         return $this->createQueryBuilder('a')
  214.             ->where('a.status = :translate')
  215.             ->setParameter('translate', 'translate')
  216.             ->orderBy('a.id', 'DESC')
  217.             ->getQuery()
  218.             ->getResult();
  219.     }
  221.     public function getLocaleArticleByUnit($unit, $locale) {
  222.         return $this->createQueryBuilder('a')
  223.             ->where('a.unit = :unit')
  224.             ->setParameter('unit', $unit)
  225.             ->join('a.websiteLanguage', 'w')
  226.             ->andWhere('w.slug = :locale')
  227.             ->setParameter('locale', $locale)
  228.             ->getQuery()
  229.             ->getOneOrNullResult();
  230.     }
  233. }