vendor/uvdesk/support-center-bundle/Repository/MarketingModuleRepository.php line 21

Open in your IDE?
  1. <?php
  3. namespace Webkul\UVDesk\SupportCenterBundle\Repository;
  5. use Doctrine\Persistence\ManagerRegistry;
  6. use Doctrine\Common\Collections\Criteria;
  7. use Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository;
  8. use Webkul\UVDesk\CoreFrameworkBundle\Entity\Ticket;
  9. use Webkul\UVDesk\SupportCenterBundle\Entity\MarketingModule;
  11. class MarketingModuleRepository extends ServiceEntityRepository
  12. {
  13. public $safeFields = array('page', 'limit', 'sort', 'order', 'direction');
  14. const LIMIT = 10;
  16. public function __construct(ManagerRegistry $registry)
  17. {
  18. parent::__construct($registry, MarketingModule::class);
  19. }
  21. public function getAllMarketingModules(\Symfony\Component\HttpFoundation\ParameterBag $obj = null, $container)
  22. {
  23. $json = array();
  24. $qb = $this->getEntityManager()->createQueryBuilder();
  25. $qb->select('a')->from($this->getEntityName(), 'a');
  27. $data = $obj->all();
  28. $data = array_reverse($data);
  30. foreach ($data as $key => $value) {
  31. if (! in_array($key, $this->safeFields)) {
  32. if ($key != 'dateUpdated' and $key != 'dateAdded' and $key != 'search') {
  33. $qb->andWhere('a.' . $key . ' = :' . $key);
  34. $qb->setParameter($key, $value);
  35. } else {
  36. if ($key == 'search') {
  37. $qb->orWhere('a.title' . ' LIKE :name');
  38. $qb->setParameter('name', '%' . urldecode(trim($value)) . '%');
  39. $qb->orWhere('a.description' . ' LIKE :description');
  40. $qb->setParameter('description', '%' . urldecode(trim($value)) . '%');
  41. }
  42. }
  43. }
  44. }
  46. if (! isset($data['sort'])) {
  47. $qb->orderBy('a.id', Criteria::DESC);
  48. }
  50. $paginator = $container->get('knp_paginator');
  52. $results = $paginator->paginate(
  53. $qb,
  54. isset($data['page']) ? $data['page'] : 1,
  55. self::LIMIT,
  56. array('distinct' => false)
  57. );
  59. $newResult = [];
  60. foreach ($results as $key => $result) {
  61. $newResult[] = array(
  62. 'id' => $result->getId(),
  63. 'title' => $result->getTitle(),
  64. 'description' => $result->getDescription(),
  65. 'isActive' => $result->getIsActive(),
  66. 'createdAt' => $result->getCreatedAt(),
  67. 'updatedAt' => $result->getUpdatedAt(),
  68. 'group' => $result->getGroup()->getId() == 1 ? $group = ['name' => 'Default Group'] : $group = ['name' => $result->getGroup()->getName()],
  69. );
  70. }
  72. $paginationData = $results->getPaginationData();
  73. $queryParameters = $results->getParams();
  75. $paginationData['url'] = '#' . $container->get('uvdesk.service')->buildPaginationQuery($queryParameters);
  77. $json['groups'] = $newResult;
  78. $json['pagination_data'] = $paginationData;
  80. return $json;
  81. }
  83. public function getAllMarketingModulesForCustomer($query, $container, $customer)
  84. {
  85. $order = array_rand(array(
  86. 'DESC' => 'DESC',
  87. 'ASC' => 'ASC'
  88. ));
  90. $column = array_rand(array(
  91. 'mm.id' => 'mm.id',
  92. 'mm.createdAt' => 'mm.createdAt'
  93. ));
  95. $ticket = $this->getEntityManager()->getRepository(Ticket::class)->findOneById($query->get('ticketId'));
  97. $qb = $this->getEntityManager()->createQueryBuilder();
  98. $entityClass = MarketingModule::class;
  99. $limit = (int)$query->get('limit');
  101. $qb->select('mm')
  102. ->from($entityClass, 'mm')
  103. ->join(Ticket::class, 't', 'WITH', 'mm.group = t.supportGroup')
  104. ->where('mm.isActive = :isActive')
  105. ->andWhere('t.customer = :userId')
  106. ->andWhere('mm.group = :groupId')
  107. ->groupBy('mm.id')
  108. ->orderBy($column, $order)
  109. ->setParameter('isActive', 1)
  110. ->setParameter('groupId', $ticket->getSupportGroup()->getId())
  111. ->setParameter('userId', $customer)
  112. ->setMaxResults($limit);
  114. $paginator = $container->get('knp_paginator');
  115. $results = $paginator->paginate(
  116. $qb,
  117. $query->get('page'),
  118. $limit,
  119. array('distinct' => false)
  120. );
  122. $newResult = [];
  123. foreach ($results as $key => $result) {
  124. $newResult[] = array(
  125. 'id' => $result->getId(),
  126. 'title' => $result->getTitle(),
  127. 'description' => $result->getDescription(),
  128. 'isActive' => $result->getIsActive(),
  129. 'linkURL' => $result->getLinkUrl(),
  130. 'image' => $result->getImage(),
  131. 'borderColor' => $result->getBorderColor(),
  132. 'createdAt' => $result->getCreatedAt(),
  133. 'updatedAt' => $result->getUpdatedAt(),
  134. 'group' => $result->getGroup()->getId() == 1 ? $group = ['name' => 'Default Group'] : $group = ['name' => $result->getGroup()->getName()],
  135. );
  136. }
  138. $paginationData = $results->getPaginationData();
  140. $json['modules'] = ($newResult);
  141. $json['pagination_data'] = $paginationData;
  143. return $json;
  144. }
  145. }