src/Controller/AutocompleteController.php line 30

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