vendor/uvdesk/automation-bundle/Repository/PreparedResponsesRepository.php line 21

Open in your IDE?
  1. <?php
  3. namespace Webkul\UVDesk\AutomationBundle\Repository;
  5. use Doctrine\ORM\Query;
  6. use Doctrine\ORM\EntityRepository;
  7. use Doctrine\Common\Collections\Criteria;
  9. /**
  10. * PreparedResponsesRepository
  11. *
  12. * This class was generated by the Doctrine ORM. Add your own custom
  13. * repository methods below.
  14. */
  15. class PreparedResponsesRepository extends EntityRepository
  16. {
  17. const LIMIT = 10;
  19. public $safeFields = ['page','limit','sort','order','direction'];
  21. public function getPreparesResponses(\Symfony\Component\HttpFoundation\ParameterBag $obj = null, $container)
  22. {
  24. $userService = $container->get('user.service');
  26. $qb = $this->getEntityManager()->createQueryBuilder()
  27. ->select('DISTINCT pr.id, pr.name, pr.status, u.id as agentId')
  28. ->from($this->getEntityName(), 'pr')
  29. ->leftJoin('pr.user', 'ud')
  30. ->leftJoin('ud.user', 'u');
  32. $data = $obj->all();
  33. $data = array_reverse($data);
  35. foreach ($data as $key => $value) {
  36. switch ($key) {
  37. case 'name':
  38. case 'description':
  39. case 'type':
  40. case 'status':
  41. $qb
  42. ->andWhere("pr.$key = :$key")
  43. ->setParameter($key, $value);
  44. break;
  45. case 'search':
  46. $qb
  47. ->andWhere('pr.name LIKE :name')
  48. ->setParameter('name', '%' . urldecode(trim($value)) . '%');
  49. break;
  50. default:
  51. break;
  52. }
  53. }
  55. if (!isset($data['sort'])) {
  56. $qb->orderBy('pr.id',Criteria::DESC);
  57. }
  59. $paginator = $container->get('knp_paginator');
  61. $newQb = clone $qb;
  62. $newQb->select('COUNT(DISTINCT pr.id)');
  64. $results = $paginator->paginate(
  65. $qb->getQuery()->setHydrationMode(Query::HYDRATE_ARRAY)->setHint('knp_paginator.count', $newQb->getQuery()->getSingleScalarResult()),
  66. isset($data['page']) ? $data['page'] : 1,
  67. self::LIMIT,
  68. array('distinct' => false)
  69. );
  71. $paginationData = $results->getPaginationData();
  72. $queryParameters = $results->getParams();
  74. $paginationData['url'] = '#'.$container->get('uvdesk.service')->buildPaginationQuery($queryParameters);
  76. $data = $results->getItems();
  77. foreach ($data as $key => $row) {
  78. $data[$key]['user'] = $userService->getAgentDetailById($row['agentId']);
  79. }
  81. return [
  82. 'preparedResponses' => $data,
  83. 'pagination_data' => $paginationData,
  84. ];
  85. }
  87. public function getPreparedResponse($id)
  88. {
  89. $qb = $this->getEntityManager()->createQueryBuilder();
  90. $qb->select('DISTINCT pr')->from($this->getEntityName(), 'pr')
  91. ->leftJoin('pr.user', 'ud')
  92. ->leftJoin('ud.user', 'u')
  93. ->andWhere('pr.id'.' = :id')
  94. ->setParameter('id', $id)
  95. ->groupBy('pr.id');
  97. return $qb->getQuery()->getOneOrNullResult();
  98. }
  99. }