vendor/uvdesk/core-framework/Repository/SupportPrivilegeRepository.php line 20

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;
  9. /**
  10. * AgentPrivilegeRepository
  11. *
  12. * This class was generated by the Doctrine ORM. Add your own custom
  13. * repository methods below.
  14. */
  15. class SupportPrivilegeRepository extends \Doctrine\ORM\EntityRepository
  16. {
  17. public $safeFields = array('page','limit','sort','order','direction');
  18. const LIMIT = 10;
  20. public function getAllPrivileges(\Symfony\Component\HttpFoundation\ParameterBag $obj = null, $container) {
  22. $json = array();
  23. $qb = $this->getEntityManager()->createQueryBuilder();
  24. $qb->select('ap')->from($this->getEntityName(), 'ap');
  26. $data = $obj->all();
  28. $data = array_reverse($data);
  29. foreach ($data as $key => $value) {
  30. if (!in_array($key,$this->safeFields)) {
  31. if ($key!='dateUpdated' AND $key!='dateAdded' AND $key!='search') {
  32. $qb->andWhere('ap.'.$key.' = :'.$key);
  33. $qb->setParameter($key, $value);
  34. } else {
  35. if ($key == 'search') {
  36. $qb->orWhere('ap.name'.' LIKE :name');
  37. $qb->setParameter('name', '%'.urldecode(trim($value)).'%');
  38. $qb->orWhere('ap.description'.' LIKE :description');
  39. $qb->setParameter('description', '%'.urldecode(trim($value)).'%');
  40. }
  41. }
  42. }
  43. }
  45. if (!isset($data['sort'])){
  46. $qb->orderBy('ap.createdAt',Criteria::DESC);
  47. }
  49. $paginator = $container->get('knp_paginator');
  51. $results = $paginator->paginate(
  52. $qb,
  53. isset($data['page']) ? $data['page'] : 1,
  54. self::LIMIT,
  55. array('distinct' => false)
  56. );
  58. $paginationData = $results->getPaginationData();
  59. $queryParameters = $results->getParams();
  61. $paginationData['url'] = '#'.$container->get('uvdesk.service')->buildPaginationQuery($queryParameters);
  63. $parsedCollection = array_map(function($privilege) {
  64. return [
  65. 'id' => $privilege->getId(),
  66. 'name' => $privilege->getName(),
  67. 'description' => $privilege->getDescription(),
  68. ];
  69. }, $results->getItems());
  71. $json['privileges'] = $parsedCollection;
  72. $json['pagination_data'] = $paginationData;
  74. return $json;
  75. }
  76. }