vendor/uvdesk/support-center-bundle/Repository/AnnouncementRepository.php line 27

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\Announcement;
  11. /**
  12. * @method Announcement|null find($id, $lockMode = null, $lockVersion = null)
  13. * @method Announcement|null findOneBy(array $criteria, array $orderBy = null)
  14. * @method Announcement[] findAll()
  15. * @method Announcement[] findBy(array $criteria, array $orderBy = null, $limit = null, $offset = null)
  16. */
  17. class AnnouncementRepository extends ServiceEntityRepository
  18. {
  19. public $safeFields = array('page', 'limit', 'sort', 'order', 'direction');
  20. const LIMIT = 10;
  22. public function __construct(ManagerRegistry $registry)
  23. {
  24. parent::__construct($registry, Announcement::class);
  25. }
  27. public function getAllAnnouncements(\Symfony\Component\HttpFoundation\ParameterBag $obj = null, $container)
  28. {
  29. $json = array();
  30. $qb = $this->getEntityManager()->createQueryBuilder();
  31. $qb->select('a')->from($this->getEntityName(), 'a');
  33. $data = $obj->all();
  34. $data = array_reverse($data);
  36. foreach ($data as $key => $value) {
  37. if (! in_array($key, $this->safeFields)) {
  38. if ($key != 'dateUpdated' and $key != 'dateAdded' and $key != 'search') {
  39. $qb->andWhere('a.' . $key . ' = :' . $key);
  40. $qb->setParameter($key, $value);
  41. } else {
  42. if ($key == 'search') {
  43. $qb->orWhere('a.title' . ' LIKE :name');
  44. $qb->setParameter('name', '%' . urldecode($value) . '%');
  45. $qb->orWhere('a.promoText' . ' LIKE :promoText');
  46. $qb->setParameter('promoText', '%' . urldecode($value) . '%');
  47. }
  48. }
  49. }
  50. }
  52. if (! isset($data['sort'])) {
  53. $qb->orderBy('a.id', Criteria::DESC);
  54. }
  56. $paginator = $container->get('knp_paginator');
  58. $results = $paginator->paginate(
  59. $qb,
  60. isset($data['page']) ? $data['page'] : 1,
  61. self::LIMIT,
  62. array('distinct' => false)
  63. );
  65. $newResult = [];
  66. foreach ($results as $key => $result) {
  67. $newResult[] = array(
  68. 'id' => $result->getId(),
  69. 'title' => $result->getTitle(),
  70. 'promoText' => $result->getPromoText(),
  71. 'promoTag' => $result->getPromoTag(),
  72. 'tagColor' => $result->getTagColor(),
  73. 'linkText' => $result->getLinkText(),
  74. 'linkUrl' => $result->getLinkUrl(),
  75. 'isActive' => $result->getIsActive(),
  76. 'createdAt' => $result->getCreatedAt(),
  77. 'group' => array(
  78. 'id' => $result->getGroup()->getId(),
  79. 'name' => $result->getGroup()->getName()
  80. )
  81. );
  82. }
  84. $paginationData = $results->getPaginationData();
  85. $queryParameters = $results->getParams();
  87. $paginationData['url'] = '#' . $container->get('uvdesk.service')->buildPaginationQuery($queryParameters);
  89. $json['groups'] = $newResult;
  90. $json['pagination_data'] = $paginationData;
  92. return $json;
  93. }
  95. public function getAllAnnouncementForCustomer($query, $container, $customer)
  96. {
  97. $order = array_rand(array(
  98. 'DESC' => 'DESC',
  99. 'ASC' => 'ASC'
  100. ));
  102. $column = array_rand(array(
  103. 'ma.id' => 'ma.id',
  104. 'ma.createdAt' => 'ma.createdAt'
  105. ));
  107. $qb = $this->getEntityManager()->createQueryBuilder();
  108. $entityClass = Announcement::class;
  109. $limit = 10;
  111. $qb->select('ma')
  112. ->from($entityClass, 'ma')
  113. ->join(Ticket::class, 't', 'WITH', 'ma.group = t.supportGroup')
  114. ->where('ma.isActive = :isActive')
  115. ->andWhere('t.customer = :userId')
  116. ->groupBy('ma.id')
  117. ->orderBy($column, $order)
  118. ->setParameter('isActive', 1)
  119. ->setParameter('userId', $customer)
  120. ->setMaxResults($limit);
  122. $paginator = $container->get('knp_paginator');
  123. $results = $paginator->paginate(
  124. $qb,
  125. $query->get('page') ?: 1,
  126. $limit,
  127. array('distinct' => false)
  128. );
  130. $newResult = [];
  132. foreach ($results as $key => $result) {
  133. $newResult[] = array(
  134. 'id' => $result->getId(),
  135. 'title' => $result->getTitle(),
  136. 'promoText' => $result->getPromoText(),
  137. 'promoTag' => $result->getPromoTag(),
  138. 'isActive' => $result->getIsActive(),
  139. 'linkURL' => $result->getLinkUrl(),
  140. 'linkText' => $result->getLinkText(),
  141. 'createdAt' => $result->getCreatedAt(),
  142. 'updatedAt' => $result->getUpdatedAt(),
  143. 'group' => $result->getGroup()->getId() == 1 ? $group = ['name' => 'Default Group'] : $group = ['name' => $result->getGroup()->getName()],
  144. );
  145. }
  147. $paginationData = $results->getPaginationData();
  149. $json['modules'] = ($newResult);
  150. $json['pagination_data'] = $paginationData;
  152. return $json;
  153. }
  154. }