src/Controller/AppController.php line 18

Open in your IDE?
  1. <?php
  3. namespace App\Controller;
  5. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  6. use Symfony\Component\HttpFoundation\Request;
  7. use Symfony\Component\HttpFoundation\Response;
  8. use Symfony\Component\Routing\Annotation\Route;
  9. use App\Entity\Category;
  10. use App\Entity\Service;
  11. use App\Entity\Numero;
  13. class AppController extends AbstractController
  14. {
  15.     /**
  16.      * @Route("/", name="app_app")
  17.      */
  18.     public function index()
  19.     {
  20.         $em = $this->getDoctrine()->getManager();
  21.         $menu = null;
  22.         $category = $em->getRepository(Category::class)->findAll();
  24.         return $this->render('app/index.html.twig', [
  25.         'category'=>$category,
  26.         'menu'=>$menu]);
  27.     }
  29.     /**
  30.      * @Route("/search", name="app.search")
  31.      */
  32.     public function search(Request $request)
  33.     {
  34.         $em = $this->getDoctrine()->getManager();
  35.         $menu = null;
  36.         if($request->isMethod('post')){
  37.         $search = $request->get('search');
  38.           $sql= 'SELECT s.*, s.name AS nameService, c.name AS nameCat, c.color AS color
  39.               FROM service s
  40.               LEFT JOIN category c ON c.id = s.category_id
  42.               WHERE s.name LIKE "%'.$search.'%"';
  43.               $result = $em->getConnection()->fetchAllAssociative($sql);
  45.               foreach ($result as $key => $r) {
  46.                 $sql="SELECT n.*, n.numero AS num
  47.                 FROM numero n
  48.                 WHERE n.service_id ='".$r['id']."'";
  50.                 $numero = $em->getConnection()->fetchAllAssociative($sql);
  52.                 $result[$key]['num']=$numero;
  53.               }
  55.         }
  56.         return $this->render('app/search.html.twig', [
  57.         'menu'=>$menu,
  58.         'result'=>$result]);
  59.     }
  61.     /**
  62.      * @Route("/service/{id}", name="app_service")
  63.      */
  64.     public function Service($id)
  65.     {
  66.         $em = $this->getDoctrine()->getManager();
  67.         $category = $em->getRepository(Category::class)->findOneBy(['id'=>$id]);
  68.         $services = $em->getRepository(Service::class)->findBy(['category'=>$category,'enable'=>'1']);
  70.         foreach ($services as $service ) {
  71.           $num = $em->getRepository(Numero::class)->findBy(['service'=>$service]);
  72.         }
  74.         $subServ = $em->getRepository(Service::class)->findBy(['category'=>$category,'enable'=>'1','sub'=>'1']);
  76.         $numSub=[];
  77.         foreach ($subServ as $sub ) {
  78.           $numServ = $em->getRepository(Service::class)->findBy(['subCategory'=>$sub->getId()]);
  79.         foreach ($numServ as $nums ) {
  80.             $num = $em->getRepository(Numero::class)->findBy(['service'=>$nums]);
  81.             $numSub[] = $num;
  82.           }
  83.         }
  85.         $menu = null;
  87.         return $this->render('app/service.html.twig', [
  88.         'category'=>$category,
  89.         'services'=>$services,
  90.         'numSub'=>$numSub,
  91.         'menu'=>$menu]);
  92.     }
  93. }