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

Open in your IDE?
  1. <?php
  3. namespace Webkul\UVDesk\CoreFrameworkBundle\Repository;
  5. use Doctrine\ORM\EntityRepository;
  6. use Doctrine\Common\Collections;
  7. use Doctrine\ORM\Tools\Pagination\Paginator;
  8. use Doctrine\Common\Collections\Criteria;
  10. class SupportGroupRepository extends \Doctrine\ORM\EntityRepository
  11. {
  12.     public $safeFields = array('page','limit','sort','order','direction');
  13.     const LIMIT = 10;
  15.     public function getAllGroups(\Symfony\Component\HttpFoundation\ParameterBag $obj = null, $container) {
  16.         $json = array();
  17.         $qb = $this->getEntityManager()->createQueryBuilder();
  18.         $qb->select('a')->from($this->getEntityName(), 'a');
  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('a.'.$key.' = :'.$key);
  26.                     $qb->setParameter($key, $value);
  27.                 } else {
  28.                     if($key == 'search') {
  29.                         $qb->orwhere('a.name'.' LIKE :name');
  30.                         $qb->setParameter('name', '%'.urldecode($value).'%');    
  31.                         $qb->orwhere('a.description'.' LIKE :description');
  32.                         $qb->setParameter('description', '%'.urldecode(trim($value)).'%');
  33.                     }
  34.                 }
  35.             }
  36.         }   
  37.         
  38.         if(!isset($data['sort'])){
  39.             $qb->orderBy('a.createdAt',Criteria::DESC);
  40.         }
  42.         $paginator  = $container->get('knp_paginator');
  44.         $results = $paginator->paginate(
  45.             $qb,
  46.             isset($data['page']) ? $data['page'] : 1,
  47.             self::LIMIT,
  48.             array('distinct' => false)
  49.         );
  51.         $parsedCollection = array_map(function($group) {
  52.             return [
  53.                 'id'          => $group->getId(),
  54.                 'name'        => $group->getName(),
  55.                 'description' => $group->getDescription(),
  56.                 'isActive'    => $group->getIsActive(),
  57.             ];
  58.         }, $results->getItems()); 
  60.         $paginationData = $results->getPaginationData();
  61.         $queryParameters = $results->getParams();
  63.         $paginationData['url'] = '#'.$container->get('uvdesk.service')->buildPaginationQuery($queryParameters);
  65.         $json['groups'] = $parsedCollection;
  66.         $json['pagination_data'] = $paginationData;
  67.         
  68.         return $json;
  69.     }
  71.     public function findGroupById($filterArray = [])
  72.     {
  73.         $json = array();
  74.         $qb = $this->getEntityManager()->createQueryBuilder();
  75.         $qb->select('a')->from($this->getEntityName(), 'a');
  77.         foreach ($filterArray as $key => $value) {
  78.             $qb->Andwhere('a.'.$key.' = :'.$key);
  79.             $qb->setParameter($key, $value);
  80.         }   
  82.         $result = $qb->getQuery()->getOneOrNullResult();
  84.         return($result);
  85.     }
  87. }