src/Controller/AutocompleteController.php line 30

  1. <?php
  3. namespace App\Controller;
  5. use Doctrine\Common\Collections\ArrayCollection;
  6. use Doctrine\Persistence\ManagerRegistry;
  8. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  9. use Symfony\Component\HttpFoundation\Request;
  10. use Symfony\Component\HttpFoundation\Response;
  11. use Symfony\Component\Routing\Annotation\Route;
  12. use Psr\Log\LoggerInterface;
  14. class AutocompleteController extends AbstractController
  15. {
  16. private $term;
  17. public $columns;
  18. public $query;
  19. public $pagination = array(
  20. 'start' => 0,
  21. 'count' => 10,
  22. );
  23. public $limit=100;
  25. public function __construct(private ManagerRegistry $doctrine, private LoggerInterface $logger)
  26. {
  28. }
  30. #[\Symfony\Component\Routing\Attribute\Route('/autocomplete/{object}', name: 'autocomplete')]
  31. public function indexAction($object, Request $request)
  32. {
  33. if ($request->query->get('appendNew') == 1)
  34. $return[0] = array('label' => 'Click here to add a new entry', 'value' => 'new');
  35. else
  36. $return = array();
  38. $method = 'ajaxGet'.ucfirst($object);
  39. if (method_exists($this, $method))
  40. {
  41. $this->term = '%'.$request->get('term').'%';
  42. $data = $this->$method($request);
  43. $return = array_merge($return,$data);
  44. }
  45. else
  46. {
  47. $return = array(
  48. 'query' => 'Unit',
  49. 'suggestions' => array('suggest')
  50. );
  51. }
  52. $response = new Response(json_encode($return));
  53. $response->headers->set('Content-Type', 'application/json');
  54. return $response;
  55. }
  57. public function ajaxGetAircraft($request)
  58. {
  59. $em = $this->doctrine->getManager();
  60. $q = $em->createQueryBuilder();
  61. $q->select('a')
  62. ->from('App\Entity\Aircraft','a')
  63. ->add('where', $q->expr()->orx(
  64. $q->expr()->like('a.aircraftname', '?1')))
  65. ->orderby('a.aircraftname')
  66. ->setParameters(array(1 => $this->term));
  68. $q->setMaxResults($this->limit);
  69. $data = $q->getQuery()->getResult();
  70. $final = array();
  71. $i = 0;
  72. foreach ($data as $d)
  73. {
  74. $final[$i]['label'] = $d->getAircraftname();
  75. $final[$i]['value'] = $d->getAircraftid();
  76. $i++;
  77. }
  79. return $final;
  80. }
  81. public function ajaxGetAirport($request)
  82. {
  83. $em = $this->doctrine->getManager();
  84. $q = $em->createQueryBuilder();
  85. $q->select('a')
  86. ->from('App\Entity\Airport','a')
  87. ->orWhere('a.cityTownSuburb LIKE \''.$this->term.'\'')
  88. ->add('where', $q->expr()->orx(
  89. $q->expr()->like('a.airportname', '?1'),
  90. $q->expr()->like('a.iatacode', '?2')
  91. ))
  92. ->setParameters(array(1 => $this->term, 2 => $this->term))
  93. ->add('orderBy','a.airportname ASC, a.iatacode ASC');
  95. $data = $q->getQuery()->getResult();
  96. $final = array();
  97. $i = 0;
  98. foreach ($data as $d)
  99. {
  100. $final[$i]['label'] = $d->__toString();
  101. $final[$i]['value'] = $d->getAirportid();
  102. $i++;
  103. }
  105. return $final;
  106. }
  107. public function ajaxGetCustomer($request)
  108. {
  109. $term = $request->get('term');
  110. $user = $this->getUser();
  112. $em = $this->doctrine->getManager();
  113. $q = $em->createQueryBuilder();
  114. $q->select('c')
  115. ->from('App\Entity\Customer','c')
  116. ->add('where', $q->expr()->orx(
  117. $q->expr()->like('c.firstname', '?1'),
  118. $q->expr()->like('c.surname', '?2'),
  119. $q->expr()->like('c.email', '?3'),
  120. $q->expr()->like('c.postcode', '?4')))
  121. ->orderBy('c.firstname', 'ASC')
  122. ->orderBy('c.surname', 'ASC')
  123. ->orderBy('c.email', 'ASC')
  124. ->orderBy('c.postcode', 'ASC')
  125. ->setParameters(array(1 => $this->term, 2 => $this->term, 3 => $this->term, 4 => $this->term));
  127. if (!$this->isGranted('ROLE_ADMIN'))
  128. $q->andWhere('c.createdby='.$user->getUserId());
  130. $data = $q->getQuery()->getResult();
  131. $final = array();
  132. $i = 0;
  133. foreach ($data as $d)
  134. {
  135. $final[$i]['label'] = $d->__toString();
  136. $final[$i]['value'] = $d->getCustomerId();
  137. $i++;
  138. }
  140. return $final;
  141. }
  142. }