src/Controller/DominioController.php line 65

Open in your IDE?
  1. <?php
  3. namespace App\Controller;
  5. use Symfony\Component\HttpFoundation\Request;
  6. use Symfony\Component\Routing\Annotation\Route;
  8. class DominioController extends BaseController
  9. {
  10.     public function getProvinciasPorRegionAction( $region, $sel=-1)
  11.     {
  12.         $em = $this->em;
  13.         
  14.         $childs = $em->getRepository('App\\Entity\\NmclDominioLocalizacion')->createQueryBuilder('p')
  15.                         ->leftJoin('p.dominioPadre','region')
  16.                         ->where('region.id='.$region)
  17.                         ->orderBy('p.valor')
  18.                         ->getQuery()->getResult();
  19.      
  20.         return $this->render('@crud/Common/comboreloaded.html.twig', array("entities"=>$childs, 'value'=>$sel));
  21.     }
  22.     
  23.     public function getCantonesPorRegionAction( $region, $sel=-1)
  24.     {
  25.         $em = $this->em;
  26.         
  27.         $childs = $em->getRepository('App\\Entity\\NmclDominioLocalizacion')->createQueryBuilder('p')
  28.                         ->leftJoin('p.dominioPadre','provincia')
  29.                         ->leftJoin('provincia.dominioPadre','region')
  30.                         ->where('region.id='.$region)
  31.                         ->orderBy('p.valor')
  32.                         ->getQuery()->getResult();
  33.      
  34.         return $this->render('@crud/Common/comboreloaded.html.twig', array("entities"=>$childs, 'value'=>$sel));
  35.     }
  36.     
  37.     public function getParroquiasPorRegionAction( $region, $sel=-1)
  38.     {
  39.         $em = $this->em;
  40.         
  41.         $childs = $em->getRepository('App\\Entity\\NmclDominioLocalizacion')->createQueryBuilder('p')
  42.                         ->leftJoin('p.dominioPadre','canton')
  43.                         ->leftJoin('canton.dominioPadre','provincia')
  44.                         ->leftJoin('provincia.dominioPadre','region')
  45.                         ->where('region.id='.$region)
  46.                         ->orderBy('p.valor')
  47.                         ->getQuery()->getResult();
  48.      
  49.         return $this->render('@crud/Common/comboreloaded.html.twig', array("entities"=>$childs, 'value'=>$sel));
  50.     }
  51.     
  52.     public function getCantonesPorProvinciaAction( $provincia, $sel=-1)
  53.     {
  54.         $em = $this->em;
  55.         
  56.         $childs = $em->getRepository('App\\Entity\\NmclDominioLocalizacion')->createQueryBuilder('p')
  57.                         ->leftJoin('p.dominioPadre','provincia')
  58.                         ->where('provincia.id='.$provincia)
  59.                         ->orderBy('p.valor')
  60.                         ->getQuery()->getResult();
  61.      
  62.         return $this->render('@crud/Common/comboreloaded.html.twig', array("entities"=>$childs, 'value'=>$sel));
  63.     }
  65.     public function getParroquiasPorProvinciaAction( $provincia, $sel=-1)
  66.     {
  67.         $em = $this->em;
  68.         
  69.         $childs = $em->getRepository('App\\Entity\\NmclDominioLocalizacion')->createQueryBuilder('p')
  70.                         ->leftJoin('p.dominioPadre','canton')
  71.                         ->leftJoin('canton.dominioPadre','provincia')
  72.                         ->where('provincia.id='.$provincia)
  73.                         ->orderBy('p.valor')
  74.                         ->getQuery()->getResult();
  75.      
  76.         return $this->render('@crud/Common/comboreloaded.html.twig', array("entities"=>$childs, 'value'=>$sel));
  77.     }
  78.     
  79.     public function getParroquiasPorCantonAction( $canton, $sel=-1)
  80.     {
  81.         $em = $this->em;
  82.         
  83.         $childs = $em->getRepository('App\\Entity\\NmclDominioLocalizacion')->createQueryBuilder('p')
  84.                         ->leftJoin('p.dominioPadre','canton')
  85.                         ->where('canton.id='.$canton)
  86.                         ->orderBy('p.valor')
  87.                         ->getQuery()->getResult();
  88.      
  89.         return $this->render('@crud/Common/comboreloaded.html.twig', array("entities"=>$childs, 'value'=>$sel));
  90.     }
  92.     public function getDominiosPorNivelAction( $nivel, $sel=-1)
  93.     {
  94.         $em = $this->em;
  95.         
  96.         $childs = $em->getRepository('App\\Entity\\NmclDominioLocalizacion')->createQueryBuilder('p')
  97.                         ->leftJoin('p.nivelLocalizacion','nivel')
  98.                         ->where('nivel.id='.$nivel)
  99.                         ->orderBy('p.valor')
  100.                         ->getQuery()->getResult();
  101.      
  102.         return $this->render('@crud/Common/comboreloaded.html.twig', array("entities"=>$childs, 'value'=>$sel));
  103.     }
  105. }