vendor/uvdesk/core-framework/Repository/SavedRepliesRepository.php line 15

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;
  8. use Symfony\Component\HttpFoundation\ParameterBag;
  10. class SavedRepliesRepository extends EntityRepository
  11. {
  12.     const LIMIT = 10;
  13.     public $safeFields = array('page','limit','sort','order','direction');
  15.     public function getSavedReplies(ParameterBag $obj = null, $container)
  16.     {
  17.         $json = array();
  18.         $qb = $this->getEntityManager()->createQueryBuilder();
  19.         $qb->select('DISTINCT sr.id, sr.name')->from($this->getEntityName(), 'sr');
  21.         $data = $obj->all();
  22.         $data = array_reverse($data);
  23.         foreach ($data as $key => $value) {
  24.             if(!in_array($key,$this->safeFields)) {
  25.                 if($key!='dateUpdated' AND $key!='dateAdded' AND $key!='search') {
  26.                     $qb->andwhere('sr.'.$key.' = :'.$key);
  27.                     $qb->setParameter($key, $value);
  28.                 } else {
  29.                     if($key == 'search') {
  30.                         $qb->andwhere('sr.name'.' LIKE :name');
  31.                         $qb->setParameter('name', '%'.urldecode(trim($value)).'%');    
  32.                     }
  33.                 }
  34.             }
  35.         }
  37.         // filter saved replies based on groups and teams.
  38.         $this->addGroupTeamFilter($qb, $container); 
  40.         if(!isset($data['sort']))
  41.             $qb->orderBy('sr.id', Criteria::DESC);
  43.         $paginator  = $container->get('knp_paginator');
  45.         $newQb = clone $qb;
  46.         $newQb->select('COUNT(DISTINCT sr.id)');
  48.         $results = $paginator->paginate(
  49.             $qb->getQuery()->setHydrationMode(Query::HYDRATE_ARRAY)->setHint('knp_paginator.count', $newQb->getQuery()->getSingleScalarResult()),
  50.             isset($data['page']) ? $data['page'] : 1,
  51.             self::LIMIT,
  52.             array('distinct' => false)
  53.         );
  55.         $paginationData = $results->getPaginationData();
  56.         $queryParameters = $results->getParams();
  57.         if(isset($queryParameters['template']))
  58.             unset($queryParameters['template']);
  60.        $paginationData['url'] = '#'.$container->get('uvdesk.service')->buildPaginationQuery($queryParameters);
  62.         $json['savedReplies'] = $results->getItems();
  63.         $json['pagination_data'] = $paginationData;
  64.        
  65.         return $json;
  66.     }
  68.     public function addGroupTeamFilter($qb, $container, $entityAlias = 'sr')
  69.     {
  70.         $qb->leftJoin($entityAlias.'.groups', 'grps')
  71.             ->leftJoin($entityAlias.'.teams', 'tms');
  73.         $user = $container->get('user.service')->getCurrentUser();
  74.         $userCondition = $qb->expr()->orX();
  75.         $userCondition->add($qb->expr()->eq($entityAlias.'.user', ':userId'));
  76.         $qb->setParameter('userId', $container->get('user.service')->getCurrentUser()->getAgentInstance()->getId());
  77.         
  78.         if($user->getAgentInstance()->getSupportGroups()) {
  79.             foreach($user->getAgentInstance()->getSupportGroups() as $key => $grp) {
  80.                 $userCondition->add($qb->expr()->eq('grps.id', ':groupId'.$key));
  81.                 $qb->setParameter('groupId'.$key, $grp->getId());
  82.             }
  83.         }
  85.         $subgroupIds = $user->getAgentInstance()->getSupportTeams();
  86.         foreach($subgroupIds as $key => $teamId) {
  87.             $userCondition->add($qb->expr()->eq('tms.id', ':teamId'.$key ));
  88.             $qb->setParameter('teamId'.$key, $teamId);
  89.         } 
  90.         
  91.         $qb->andWhere($userCondition);
  93.         return $qb;        
  94.     }
  96.     public function getSavedReply($id, $container)
  97.     {
  98.         $qb = $this->getEntityManager()->createQueryBuilder();
  99.         $qb->select('sr')->from($this->getEntityName(), 'sr')
  100.             ->andWhere('sr.id = :id')
  101.             ->setParameter('id', $id );
  103.         return $qb->getQuery()->getOneOrNullResult();
  104.     }
  105. }