src/Controller/Frontend/ComiteController.php line 31

Open in your IDE?
  1. <?php
  3. namespace App\Controller\Frontend;
  5. use App\Entity\Backend\Cliente;
  6. use App\Entity\Backend\Comite;
  7. use App\Entity\Backend\Competicion;
  8. use App\Entity\Backend\Jornada;
  9. use App\Entity\Backend\Provincia;
  10. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  11. use Symfony\Component\Routing\Annotation\Route;
  12. use Symfony\Component\HttpFoundation\Request;
  13. use Symfony\Bridge\Doctrine\Form\Type\EntityType;
  14. use Symfony\Component\Form\Extension\Core\Type\ChoiceType;
  15. use Symfony\Component\Form\Extension\Core\Type\SubmitType;
  16. use Doctrine\Persistence\ManagerRegistry;
  18. class ComiteController extends AbstractController {
  20.     private $em;
  21.     
  22.     public function __construct(ManagerRegistry $doctrine){
  23.         $this->em = $doctrine->getManager();
  24.     }
  26.     /**
  27.      * F-016 Visualización de las competiciones de un comité
  28.      * 
  29.      * @Route("/competiciones-comite/{rfgacomite}", name="competiciones_comite", defaults={"rfgacomite"=0})
  30.      */
  31.     public function competicionesComite($rfgacomite, Request $request) {
  32.         $jornadas = array();
  33.         $numInscritos = array();
  34.         $numCompeticionesMes = array();
  35.         $user = $this->getUser();
  36.         $comite = 0;
  37.         $comiteSql = null;
  38.         $cliente = false;
  40.         if ($rfgacomite !== 0) {
  41.             if (in_array($rfgacomite, ["AM00", "CM00"])) {
  42.                 $cliente = $this->em->getRepository(Cliente::class)->findOneBy(array('nombreCorto' => $rfgacomite));
  43.             } else {
  44.                 $comiteAux = $this->em->getRepository(Comite::class)->findOneBy(array('rfga_id' => $rfgacomite));
  45.                 if ($comiteAux) {
  46.                     $cliente = $comiteAux->getCliente();
  47.                     $comite = $comiteAux->getId();    //NO es comiteSql. Esto es para el formulario, no para la query
  48.                     if (!empty($comiteAux->getCliente())) {
  49.                         $comiteSql = $comiteAux->getCliente()->getNombreCorto();
  50.                     }
  51.                 } else {
  52.                     $comite = 0;    //NO es comiteSql. Esto es para el formulario, no para la query
  53.                 }
  54.             }
  55.         }
  57.         $rango = range(date("Y") + 1, 2013);
  58.         $valores = array_combine($rango, $rango);
  60.         $form = $this->createFormBuilder([], array('attr' => array("class" => "ui equal width form")))
  61.                 ->add('anio', ChoiceType::class, array("label"   => false, 'choices' => $valores, 'empty_data' => (new \DateTime('now'))->format("Y"), 'data' => (new \DateTime('now'))->format("Y"), "attr" => array("class" => "ui selection dropdown")))
  62.                 ->add('comite', EntityType::class, array("label" => false,
  63.                     'placeholder' => "Comité",
  64.                     'required' => false,
  65.                     'class' => Comite::class,
  66.                     'query_builder' => function (\Doctrine\ORM\EntityRepository $e) use ($cliente) {
  67.                         if ($cliente) {
  68.                             return $e->createQueryBuilder("c")
  69.                                     ->where("c.activo = 1")
  70.                                     ->andWhere("c.cliente = " . $cliente->getId());
  71.                         } else {
  72.                             return $e->createQueryBuilder("c")
  73.                                     ->where("c.activo = 1");
  74.                         }
  75.                     },
  76.                     "attr" => array("class" => "ui selection dropdown"))
  77.                 )
  78.                 ->add('provincia', EntityType::class, array("label" => false,
  79.                     'placeholder' => "Provincias",
  80.                     'required' => false,
  81.                     'class' => Provincia::class,
  82.                     'query_builder' => function (\Doctrine\ORM\EntityRepository $e) {
  83.                         return $e->createQueryBuilder('p')->where("p.comunidad IN (1, 14)");
  84.                     },
  85.                     "attr" => array("class" => "ui selection dropdown"))
  86.                 )
  87.                 ->add('send', SubmitType::class, array("label" => "Buscar", "attr" => array("class" => "ui fluid button")))
  88.                 ->setMethod("POST")
  89.                 ->setAction($this->generateUrl('competiciones_comite'))
  90.                 ->getForm();
  92.         $form->handleRequest($request);
  93.         if ($form->isSubmitted() && $form->isValid()) {
  94.             $data = $form->getData();
  95.         }else{
  96.             //Este array es para tener los datos del jugador, lo hacemos asi por rapidez, pero lo ideal es meterlo en array de resultados y trabajar con todos los datos a la vez y filtrar debidamente
  97.             $data = array("anio" => (new \DateTime('now'))->format("Y"), "provincia" => 0, "comite" => $comite);
  98.         }
  100.         $competiciones = $this->em->getRepository(Competicion::class)->findCompeticionComiteByRango($data["anio"] . '-01-01', $data["anio"] . '-12-31', /* $comiteSql,*/ $user, $data["provincia"], $data["comite"], $cliente);
  102.         $mes = "0";
  103.         foreach ($competiciones as $competicion) {
  104.             $compid = $competicion->getId();
  105.             $numInscritos[$compid] = $this->em->getRepository(Competicion::class)->getNumInscritos($compid);
  106.             $jornadas[$compid] = count($competicion->getJornadas());        //$this->em->getRepository(Jornada::class)->getCountPorCompeticion($compid);
  108.             $m = $competicion->getFecha()->format("m");
  109.             if ($m != $mes) {
  110.                 $mes = $m;
  112.                 $numCompeticionesMes[$mes] = 0;
  113.             }
  115.             $numCompeticionesMes[$mes]++;
  116.         }
  118.         $mobile = false;
  119.         $useragent = $request->headers->get('User-Agent');
  120.         if (preg_match('/(android|bb\d+|meego).+mobile|avantgo|bada\/|blackberry|blazer|compal|elaine|fennec|hiptop|iemobile|ip(hone|od)|iris|kindle|lge |maemo|midp|mmp|mobile.+firefox|netfront|opera m(ob|in)i|palm( os)?|phone|p(ixi|re)\/|plucker|pocket|psp|series(4|6)0|symbian|treo|up\.(browser|link)|vodafone|wap|windows ce|xda|xiino/i', $useragent) || preg_match('/1207|6310|6590|3gso|4thp|50[1-6]i|770s|802s|a wa|abac|ac(er|oo|s\-)|ai(ko|rn)|al(av|ca|co)|amoi|an(ex|ny|yw)|aptu|ar(ch|go)|as(te|us)|attw|au(di|\-m|r |s )|avan|be(ck|ll|nq)|bi(lb|rd)|bl(ac|az)|br(e|v)w|bumb|bw\-(n|u)|c55\/|capi|ccwa|cdm\-|cell|chtm|cldc|cmd\-|co(mp|nd)|craw|da(it|ll|ng)|dbte|dc\-s|devi|dica|dmob|do(c|p)o|ds(12|\-d)|el(49|ai)|em(l2|ul)|er(ic|k0)|esl8|ez([4-7]0|os|wa|ze)|fetc|fly(\-|_)|g1 u|g560|gene|gf\-5|g\-mo|go(\.w|od)|gr(ad|un)|haie|hcit|hd\-(m|p|t)|hei\-|hi(pt|ta)|hp( i|ip)|hs\-c|ht(c(\-| |_|a|g|p|s|t)|tp)|hu(aw|tc)|i\-(20|go|ma)|i230|iac( |\-|\/)|ibro|idea|ig01|ikom|im1k|inno|ipaq|iris|ja(t|v)a|jbro|jemu|jigs|kddi|keji|kgt( |\/)|klon|kpt |kwc\-|kyo(c|k)|le(no|xi)|lg( g|\/(k|l|u)|50|54|\-[a-w])|libw|lynx|m1\-w|m3ga|m50\/|ma(te|ui|xo)|mc(01|21|ca)|m\-cr|me(rc|ri)|mi(o8|oa|ts)|mmef|mo(01|02|bi|de|do|t(\-| |o|v)|zz)|mt(50|p1|v )|mwbp|mywa|n10[0-2]|n20[2-3]|n30(0|2)|n50(0|2|5)|n7(0(0|1)|10)|ne((c|m)\-|on|tf|wf|wg|wt)|nok(6|i)|nzph|o2im|op(ti|wv)|oran|owg1|p800|pan(a|d|t)|pdxg|pg(13|\-([1-8]|c))|phil|pire|pl(ay|uc)|pn\-2|po(ck|rt|se)|prox|psio|pt\-g|qa\-a|qc(07|12|21|32|60|\-[2-7]|i\-)|qtek|r380|r600|raks|rim9|ro(ve|zo)|s55\/|sa(ge|ma|mm|ms|ny|va)|sc(01|h\-|oo|p\-)|sdk\/|se(c(\-|0|1)|47|mc|nd|ri)|sgh\-|shar|sie(\-|m)|sk\-0|sl(45|id)|sm(al|ar|b3|it|t5)|so(ft|ny)|sp(01|h\-|v\-|v )|sy(01|mb)|t2(18|50)|t6(00|10|18)|ta(gt|lk)|tcl\-|tdg\-|tel(i|m)|tim\-|t\-mo|to(pl|sh)|ts(70|m\-|m3|m5)|tx\-9|up(\.b|g1|si)|utst|v400|v750|veri|vi(rg|te)|vk(40|5[0-3]|\-v)|vm40|voda|vulc|vx(52|53|60|61|70|80|81|83|85|98)|w3c(\-| )|webc|whit|wi(g |nc|nw)|wmlb|wonu|x700|yas\-|your|zeto|zte\-/i', substr($useragent, 0, 4))) {
  121.             $mobile = true;
  122.         }
  124.         return $this->render("frontend/Comite/competicionesComite.html.twig", [
  125.             "competiciones" => $competiciones,
  126.             "numInscritos" => $numInscritos,
  127.             "jornadas" => $jornadas,
  128.             "comite" => $comite,
  129.             "numCompeticionesMes" => $numCompeticionesMes,
  130.             "form" => $form->createView(),
  131.             "movil" => $mobile
  132.         ]);
  133.     }
  135. }