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

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