vendor/uvdesk/core-framework/Repository/EmailTemplatesRepository.php line 14

Open in your IDE?
  1. <?php
  3. namespace Webkul\UVDesk\CoreFrameworkBundle\Repository;
  5. use Doctrine\ORM\Query;
  6. use Doctrine\ORM\EntityRepository;
  7. use Doctrine\Common\Collections\Criteria;
  9. class EmailTemplatesRepository extends EntityRepository
  10. {
  11.     const LIMIT = 10;
  12.     public $safeFields = array('page','limit','sort','order','direction');
  14.     public function getEmailTemplates(\Symfony\Component\HttpFoundation\ParameterBag $obj = null, $container)
  15.     {
  16.         $json = array();
  17.         $qb = $this->getEntityManager()->createQueryBuilder();
  18.         $qb->select('sr')->from($this->getEntityName(), 'sr');
  20.         $data = $obj->all();
  21.         $data = array_reverse($data);
  22.         foreach ($data as $key => $value) {
  23.             if(!in_array($key,$this->safeFields)) {
  24.                 if($key!='dateUpdated' AND $key!='dateAdded' AND $key!='search') {
  25.                     $qb->andwhere('sr.'.$key.' = :'.$key);
  26.                     $qb->setParameter($key, $value);
  27.                 } else {
  28.                     if($key == 'search') {
  29.                         $qb->andwhere('sr.name'.' LIKE :name');
  30.                         $qb->setParameter('name', '%'.urldecode(trim($value)).'%');    
  31.                     }
  32.                 }
  33.             }
  34.         }   
  35.         
  36.         if(!isset($data['sort']))
  37.             $qb->orderBy('sr.id', Criteria::DESC);
  39.         $paginator  = $container->get('knp_paginator');
  41.         $newQb = clone $qb;
  42.         $newQb->select('COUNT(DISTINCT sr.id)');
  44.         $results = $paginator->paginate(
  45.             $qb->getQuery()->setHydrationMode(Query::HYDRATE_ARRAY)->setHint('knp_paginator.count', $newQb->getQuery()->getSingleScalarResult()),
  46.             isset($data['page']) ? $data['page'] : 1,
  47.             self::LIMIT,
  48.             array('distinct' => false)
  49.         );
  51.         $paginationData = $results->getPaginationData();
  52.         $queryParameters = $results->getParams();
  53.         if(isset($queryParameters['template']))
  54.             unset($queryParameters['template']);
  56.         $paginationData['url'] = '#'.$container->get('uvdesk.service')->buildPaginationQuery($queryParameters);
  58.         $json['templates'] = $results->getItems();
  59.         $json['pagination_data'] = $paginationData;
  61.         return $json;
  62.     }
  63. }