src/Controller/SearchController.php line 26

Open in your IDE?
  1. <?php
  3. namespace App\Controller;
  5. use App\Form\SearchFormType;
  6. use Doctrine\DBAL\Driver\Exception;
  7. use Doctrine\DBAL\Types\Type;
  8. use Pimcore\Controller\FrontendController;
  9. use Pimcore\Model\DataObject\ProductGroup;
  10. use Pimcore\Model\DataObject\ProductSubgroup;
  11. use Symfony\Component\Form\Extension\Core\Type\SubmitType;
  12. use Symfony\Component\Form\Extension\Core\Type\TextType;
  13. use Symfony\Component\HttpFoundation\Request;
  14. use Pimcore\Model\DataObject\ProductArticle;
  15. use Symfony\Component\HttpFoundation\Response;
  16. use Symfony\Component\Routing\Annotation\Route;
  17. use Pimcore\Model\DataObject;
  18. use Symfony\Component\Validator\Constraints\Length;
  20. class SearchController extends FrontendController
  21. {
  22.     /**
  23.      * @Route("{_locale}/navbarsearch", name="navBarSearch")
  24.      * @param Request $request
  25.      */
  26.     public function NavBarSearch(Request $request)
  27.     {
  29.         $form = $this->createFormBuilder()
  30.             ->setAction($this->generateUrl('handleSearch'))
  31.             ->add('query', TextType::class, [
  32.                 'required' => false,
  33.                 'attr' => [
  34.                     'class' => 'form-control rounded m-1',
  35.                      'placeholder' => 'Ik ben op zoek naar',
  36.                 ],
  37.                 'constraints' => [
  38.                     new Length([
  39.                         'min' => 3,
  40.                         'minMessage' => 'min 3 ***',
  41.                     ]),
  42.                 ],
  44.             ])
  45.             ->add('search', SubmitType::class, [
  46.                 'label'=> 'Zoeken',
  47.                 'attr' => [
  48.                     'class' => 'btn btn-primary btn-sm rounded m-1',
  49.                 ]
  50.             ])
  51.             ->getForm();
  53.         return $this->render('layouts/navigation/searchbar.html.twig', [
  54.             'form' => $form->createView()
  55.         ]);
  57.     }
  59.     /**
  60.      * @Route("{_locale}/handlesearch", name="handleSearch")
  61.      * @param Request $request
  62.      * @throws \Exception
  63.      * @throws Exception
  64.      */
  65.     public function handleSearch(Request $request)
  66.     {
  68.         $query = $request->request->get('form')['query'];
  71.         if ($query && strlen($query) >= 3) {
  72.             $array = [];
  74.             $classIdProduct = DataObject\ProductArticle::classId();
  76.             // Get the database connection
  77.             $connection = $this->getDoctrine()->getConnection();
  78.             // Prepare the SQL statement
  79.             $statement = $connection->prepare("SELECT object_query_".$classIdProduct.".oo_id FROM  object_query_".$classIdProduct." WHERE `oms` LIKE :query OR `barcode` LIKE :query  OR `code` LIKE :query ORDER BY `oms` LIMIT 100");
  80.             // Bind the variable to the prepared statement
  81.             $statement->bindValue('query', '%' . $query . '%');
  82.             // Execute the statement
  83.             $statement->execute();
  84.             // Fetch the results
  85.             $ProductsIds = $statement->fetchAll();
  88.             foreach ($ProductsIds as $ProductId) {
  89.                 if (ProductArticle::getById($ProductId['oo_id'])?->isPublished()){
  90.                     $array[] = ProductArticle::getById($ProductId['oo_id']);
  91.                 }
  92.             }
  94.             return $this->render('search-objects/products/overview.html.twig', [
  95.                 'productDetail' => $array,
  96.                 'query'=> $query,
  97.             ]);
  99.         }
  100.         return $this->redirect('/');
  101.     }
  103.     /**
  104.      * @Route("{_locale}/handlesearch/detailpage", name="handleSearchDetail")
  105.      * @param Request $request
  106.      * @return Response
  107.      * @throws \Exception
  108.      */
  109.     public function handleSearchDetail(Request $request): Response
  110.     {
  112.         $product = ProductArticle::getById($request->get('id'));
  114.         return $this->render('search-objects/products/detail.html.twig', [
  115.             'product' => $product,
  116.         ]);
  118.     }
  119. }