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;
  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());
  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. }
  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. }