vendor/uvdesk/support-center-bundle/Repository/AnnouncementRepository.php line 29

Open in your IDE?
  1. <?php
  3. namespace Webkul\UVDesk\SupportCenterBundle\Repository;
  5. use Webkul\UVDesk\SupportCenterBundle\Entity\Announcement;
  6. use Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository;
  7. use Doctrine\Persistence\ManagerRegistry;
  8. use Doctrine\Common\Collections\Criteria;
  9. use Doctrine\Common\Collections;
  10. use Doctrine\ORM\Tools\Pagination\Paginator;
  12. /**
  13.  * @method Announcement|null find($id, $lockMode = null, $lockVersion = null)
  14.  * @method Announcement|null findOneBy(array $criteria, array $orderBy = null)
  15.  * @method Announcement[]    findAll()
  16.  * @method Announcement[]    findBy(array $criteria, array $orderBy = null, $limit = null, $offset = null)
  17.  */
  18. class AnnouncementRepository extends ServiceEntityRepository
  19. {
  20.     public $safeFields = array('page','limit','sort','order','direction');
  21.     const LIMIT = 10;
  23.     public function __construct(ManagerRegistry $registry)
  24.     {
  25.         parent::__construct($registry, Announcement::class);
  26.     }
  27.     
  29.     public function getAllAnnouncements(\Symfony\Component\HttpFoundation\ParameterBag $obj = null, $container)
  30.     {
  31.         $json = array();
  32.         $qb = $this->getEntityManager()->createQueryBuilder();
  33.         $qb->select('a')->from($this->getEntityName(), 'a');
  35.         $data = $obj->all();
  36.         $data = array_reverse($data);
  37.         foreach ($data as $key => $value) {
  38.             if(!in_array($key,$this->safeFields)) {
  39.                 if($key!='dateUpdated' AND $key!='dateAdded' AND $key!='search') {
  40.                     $qb->Andwhere('a.'.$key.' = :'.$key);
  41.                     $qb->setParameter($key, $value);
  42.                 } else {
  43.                     if($key == 'search') {
  44.                         $qb->orwhere('a.title'.' LIKE :name');
  45.                         $qb->setParameter('name', '%'.urldecode($value).'%');
  46.                         $qb->orwhere('a.promoText'.' LIKE :promoText');
  47.                         $qb->setParameter('promoText', '%'.urldecode($value).'%');
  48.                     }
  49.                 }
  50.             }
  51.         }
  53.         if(!isset($data['sort'])){
  54.             $qb->orderBy('a.id',Criteria::DESC);
  55.         }
  57.         $paginator  = $container->get('knp_paginator');
  59.         $results = $paginator->paginate(
  60.             $qb,
  61.             isset($data['page']) ? $data['page'] : 1,
  62.             self::LIMIT,
  63.             array('distinct' => false)
  64.         );
  66.         $newResult = [];
  67.         foreach ($results as $key => $result) {
  68.             $newResult[] = array(
  69.                 'id'        => $result->getId(),
  70.                 'title'      => $result->getTitle(),
  71.                 'promoText' => $result->getPromoText(),
  72.                 'promoTag'  => $result->getPromoTag(),
  73.                 'tagColor'  => $result->getTagColor(),
  74.                 'linkText'  => $result->getLinkText(),
  75.                 'linkUrl'   => $result->getLinkUrl(),
  76.                 'isActive'  => $result->getIsActive(),
  77.                 'createdAt' => $result->getCreatedAt(),
  78.                 'group'     => array(
  79.                     'id'    => $result->getGroup()->getId(),
  80.                     'name'  => $result->getGroup()->getName()
  81.                 )
  82.             );
  83.         }
  85.         $paginationData = $results->getPaginationData();
  86.         $queryParameters = $results->getParams();
  88.         $paginationData['url'] = '#'.$container->get('uvdesk.service')->buildPaginationQuery($queryParameters);
  90.         $json['groups'] = $newResult;
  91.         $json['pagination_data'] = $paginationData;
  93.         return $json;
  94.     }
  95. }