src/Controller/HomeController.php line 365

Open in your IDE?
  1. <?php
  2. namespace App\Controller;
  3. use App\Entity\Blog;
  4. use App\Entity\Categoria;
  5. use App\Entity\Ciudad;
  6. use App\Entity\Comentario;
  7. use App\Entity\CodigoDescuento;
  8. use App\Entity\ComentarioBlog;
  9. use App\Entity\Compra;
  10. use App\Entity\CompraItem;
  11. use App\Entity\Contacto;
  12. use App\Entity\Direccion;
  13. use App\Entity\Distribuidor;
  14. use App\Entity\EstadoPedido;
  15. use App\Entity\Faq;
  16. use App\Entity\Favorito;
  17. use App\Entity\FavoritoBlog;
  18. use App\Entity\Image;
  19. use App\Entity\Inventario;
  20. use App\Entity\ListaPrecioItem;
  21. use App\Entity\ListaPrecios;
  22. use App\Entity\MetodoPago;
  23. use App\Entity\PoliticaPromocion;
  24. use App\Entity\Producto;
  25. use App\Entity\Seo;
  26. use App\Entity\Tienda;
  27. use App\Entity\TipSalud;
  28. use App\Entity\Usuario;
  29. use App\Form\ComentarioType;
  30. use App\Form\ContactoType;
  31. use App\Form\DireccionType;
  32. use App\Form\PerfilType;
  33. use App\Service\QI;
  34. use App\Service\ClientifyService;
  35. use Doctrine\ORM\Query;
  36. use FOS\UserBundle\Event\GetResponseNullableUserEvent;
  37. use FOS\UserBundle\Event\GetResponseUserEvent;
  38. use FOS\UserBundle\Model\UserInterface;
  39. use FOS\UserBundle\Model\UserManagerInterface;
  40. use FOS\UserBundle\Util\TokenGeneratorInterface;
  41. use Kreait\Firebase;
  42. use Kreait\Firebase\Factory;
  43. use App\Entity\SeguimientoTracking;
  44. use Kreait\Firebase\ServiceAccount;
  45. use MercadoPago\SDK;
  46. use MercadoPago;
  47. use phpDocumentor\Reflection\Types\This;
  48. use Sensio\Bundle\FrameworkExtraBundle\Configuration\Method;
  50. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  51. use Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcherInterface;
  52. use Symfony\Component\EventDispatcher\EventDispatcherInterface;
  53. use Symfony\Component\HttpFoundation\RedirectResponse;
  54. use Symfony\Component\HttpFoundation\Request;
  55. use Symfony\Component\HttpFoundation\Response;
  56. use Symfony\Component\HttpKernel\Debug\TraceableEventDispatcher;
  57. use Symfony\Component\Routing\Annotation\Route;
  58. use Symfony\Component\Routing\Generator\UrlGeneratorInterface;
  59. use Symfony\Component\Security\Core\Authorization\AuthorizationChecker;
  60. use Symfony\Component\Security\Core\Authorization\AuthorizationCheckerInterface;
  61. use Symfony\Component\Serializer\Encoder\JsonEncode;
  62. use Symfony\Component\Serializer\Encoder\JsonEncoder;
  63. use Symfony\Component\Serializer\Encoder\XmlEncoder;
  64. use Symfony\Component\Serializer\Normalizer\ObjectNormalizer;
  65. use Symfony\Component\Serializer\Serializer;
  67. use Symfony\Component\Security\Core\Authentication\Token\UsernamePasswordToken;
  68. use Symfony\Component\Security\Http\Event\InteractiveLoginEvent;
  69. use Algolia\SearchBundle\SearchService;
  70. use Symfony\Component\HttpFoundation\JsonResponse;
  71. use function Doctrine\ORM\QueryBuilder;
  74. class HomeController extends AbstractController
  75. {
  76.     private  $qi;
  77.     private $userManager;
  78.     private $retryTtl;
  79.     private $tokenGenerator;
  80.     private $eventDispatcher;
  81.     private $authorization;
  82.     protected $searchService;
  83.     private  $clientify;
  86.     public function __construct(ClientifyService $clientify, QI $qi, UserManagerInterface $userManager,TokenGeneratorInterface $tokenGenerator, EventDispatcherInterface $eventDispatcher,AuthorizationCheckerInterface $authorization,SearchService $searchService)
  87.     {
  88.         $this->clientify = $clientify;
  89.         $this->qi = $qi;
  90.         $this->userManager = $userManager;
  91.         $this->retryTtl = 7200;
  92.         $this->tokenGenerator = $tokenGenerator;
  93.         $this->eventDispatcher = $eventDispatcher;
  94.         $this->authorization = $authorization;
  95.         $this->searchService = $searchService;
  96.     }
  98.     /**
  99.      * @Route("/direcciones/romance/direcciones", name="direcciones")
  100.      */
  101.     public function direcciones(Request $request)
  102.     {
  103.         $dirs = $this->getDoctrine()->getRepository('App:Direccion')->findAll();
  104.         foreach ($dirs as $dir){
  105.             $this->qi->saveFire($dir);
  106.         }
  107.         $res =$this->qi->sendMail("envio de prueba", 'ferney@iridian.co', "este mensaje es de prueba");
  108.         dd($res);
  109.     }
  111.     /**
  112.      * @Route("/test_mail/romance/test_mail", name="test_mail")
  113.      */
  114.     public function testMail(Request $request)
  115.     {
  117.         $res =$this->qi->sendMail("envio de prueba", 'fabian@iridian.co,fwarrior91@gmail.com', "este mensaje es de prueba");
  118.         dd($res);
  119.     }
  121.     //Rutas romance relax
  123.     /**
  124.      * @Route("/", name="homepage")
  125.      */
  126.     public function home(Request $request)
  127.     {  
  128.         $session = $request->getSession();
  129.         $mostre_en_home = $session->get('cierre_home','0') == '1';
  130.         $session->set('cierre_home','0');
  131.         $user = $this->getUser();
  132.         if(!$user){
  133.             $idTiendaDefault = $this->qi->getSetting('id-tienda-usuario-anonimo');
  134.             $tienda = $this->getDoctrine()->getRepository(Tienda::class)->findOneBy(array("id" => $idTiendaDefault));
  135.             $this->qi->setTienda($tienda);
  136.         }
  137.         else{
  138.             if(!$this->qi->getDireccion()){
  139.             }
  140.             else{
  141.                 $tienda = $this->qi->getTiendaFromCoordinates($this->qi->getDireccion());
  142.                 $this->qi->setTienda($tienda);
  143.                 if(!$tienda){
  144.                     $this->addFlash(
  145.                         'warning',
  146.                         'La direccion seleccionada no tiene cobertura en este momento'
  147.                     );
  148.                 }
  149.             }
  150.         }
  152.         if ($this->qi->getSetting('registro_obligatorio') != '1'){
  154.             $productos = $this->getDoctrine()->getRepository('App:Producto')->findBy(array('visible'=>true,'destacado'=>true,'principal'=>true), array('orden'=>'asc'),4);
  155.             $listas=[];
  157.             if($user && $user->getConvenio())
  158.             $convenio = $user->getConvenio();
  159.             else{
  160.                 $convenio = $this->getDoctrine()->getRepository(ListaPrecios::class)->find(1);
  161.             }
  162.             foreach($productos as $product ){
  163.                 $lista = $this->getDoctrine()->getRepository(ListaPrecioItem::class)->findOneBy(array('lista'=>$convenio,'producto'=>$product));
  164.                 $listas[]= $lista;
  165.             }                      
  167.             $blogs = $this->getDoctrine()->getRepository('App:Blog')->findBy(array('visible'=>true,'destacado'=>true), array('created_at'=>'desc'));
  168.             $categorias = $this->qi->getCategoriasConProductos();
  169.             $cats = [];
  170.             $categorias = $this->getDoctrine()->getRepository('App:Categoria')->findBy(array('visible'=>true, 'home'=>true), array('orden'=>'asc'));
  171.             foreach ($categorias as $cat){
  172.                 $cats[$cat->getNombre()] = $this->qi->prodsCategoria($tienda, $cat->getId());
  173.             }
  174.             $subcategorias = $this->getDoctrine()->getRepository('App:Subcategoria')->findBy(array('home'=>true, 'visible'=>true), array('orden'=>'asc'));
  175.             $idprincipal=null;
  177.             return $this->render('home/home_new.html.twig', [
  178.                 'productos' => $productos,
  179.                 'listas' => $listas,
  180.                 'idprincipal' => $idprincipal,
  181.                 'categorias' => $categorias,
  182.                 'subcategorias' => $subcategorias,
  183.                 'cats' => $cats,
  184.                 'mostre_en_home' => $mostre_en_home,
  185.                 'blogs'=> $blogs
  186.             ]);
  187.         }else{
  188.             $direcciones = $this->getDoctrine()->getRepository(Direccion::class)->findBy(array('usuario'=>$user,'visible'=>true));
  189.             return $this->render('basic/addDir.html.twig', [
  190.                 'direcciones' => $direcciones,
  191.             ]);
  192.         }
  193.     }
  195.     /**
  196.      * @Route("/nosotros/romance/nosotros", name="nosotros")
  197.      */
  198.     public function nosotros(Request $request)
  199.     {
  200.         $tiendas = $this->getDoctrine()->getRepository(Tienda::class)->findBy(array("visible"=>true));
  201.         return $this->render('basic/nosotros.html.twig', [
  202.             "tiendas"=>$tiendas,
  204.             'idprincipal' => $idprincipal=null
  205.         ]);
  206.     }
  208.     /**
  209.      * @Route("/tiendas/romance/tiendas", name="tiendas")
  210.      * @Route("/tiendas/{ciudad_id}/{nombre}", name="tiendas_ciudada")
  211.      */
  212.     public function tiendas(Request $request, $ciudad_id = null)
  213.     {
  214.         $search = array('visible'=>true);
  215.         if($ciudad_id){
  216.             $ciudad = $this->getDoctrine()->getRepository('App:Ciudad')->find($ciudad_id);
  217.             if($ciudad)
  218.                 $search = array_merge($search,array('ciudad'=>$ciudad));
  219.         }
  220.         $tiendas = $this->getDoctrine()->getRepository('App:TiendaInfo')->findBy($search);
  221.         $tiendasall = $this->getDoctrine()->getRepository('App:TiendaInfo')->findBy(array('visible'=>true));
  223.         $distribuidores = $this->getDoctrine()->getRepository(Distribuidor::class)->findBy($search,array('orden'=>"asc"));
  224.         $ciudades = [];
  225.         foreach ($tiendasall as $tienda){
  226.             if($tienda->getCiudad())
  227.                 $ciudades[$tienda->getCiudad()->getId()] = $tienda->getCiudad()->getNombre();
  228.         }
  229.         foreach ($distribuidores as $d){
  230.             if($d->getCiudad())
  231.                 $ciudades[$d->getCiudad()->getId()] = $d->getCiudad()->getNombre();
  232.         }
  233.         // dd($distribuidores);
  235.         return $this->render('basic/tiendas.html.twig', [
  236.             'tiendas' => $tiendas,
  237.             'distribuidores' => $distribuidores,
  238.             'ciudades' => $ciudades,
  239.             'ciudad_id' => $ciudad_id,
  240.             'idprincipal' => $idprincipal=null
  241.         ]);
  242.     }
  244.     
  245.     /**
  246.      * @Route("/tienda/{id}", name="tienda")
  247.      */
  248.     public function tienda(Request $request, $id)
  249.     {   
  250.         // dd($id);
  251.         $tienda = $this->getDoctrine()->getRepository('App:TiendaInfo')->find($id);
  253.         // $tienda = $this->getDoctrine()->getRepository('App:TiendaInfo')->createQueryBuilder('t')
  254.         // ->where('t.id =:tienda_id ')
  255.         // ->setParameter('tienda_id', $id)
  256.         // ->andWhere('t.visible = 1')
  257.         // ->getQuery()
  258.         // ->getResult();
  261.         $tiendas = $this->getDoctrine()->getRepository('App:TiendaInfo')->createQueryBuilder('t')
  262.             ->where('t.id !=:tienda_id ')
  263.             ->setParameter('tienda_id', $id)
  264.             ->andWhere('t.visible = 1')
  265.             ->getQuery()
  266.             ->getResult();        
  268.         $imgstienda = $this->getDoctrine()->getRepository('App:Image')->findBy(array('tienda'=>$id));
  270.         return $this->render('basic/tienda.html.twig', [
  271.             'tiendas' => $tiendas,
  272.             'tienda' => $tienda,
  273.             'imgs_tienda'=>$imgstienda,
  274.             'idprincipal' => $idprincipal=null
  276.         ]);
  277.     }
  279.     /**
  280.      * @Route("/logo/{id}", name="logo")
  281.      */
  282.     public function logo(Request $request,$id)
  283.     {
  284.         $distribuidor = $this->getDoctrine()->getRepository(Distribuidor::class)->find($id);
  285.         return $this->render('basic/logo.html.twig', [
  286.             'distribuidor' => $distribuidor
  287.         ]);
  288.     }
  290.     
  291.     /**
  292.      * @Route("/envio/romance/envio", name="envio")
  293.      */
  294.     public function envio(Request $request)
  295.     {
  297.         return $this->render('basic/envios.html.twig', [
  298.             'idprincipal' => $idprincipal=null
  299.         ]);
  300.     }
  302.     /**
  303.      * @Route("/promociones/romance/promociones", name="promociones")
  304.      */
  305.     public function promociones(Request $request)
  306.     {
  308.         return $this->render('basic/promociones.html.twig', [
  309.             'idprincipal' => $idprincipal=null
  310.         ]);
  311.     }
  314.     /**
  315.      * @Route("/checkout/romance/checkout", name="checkout")
  316.      */
  317.     public function checkout(Request $request)
  318.     {
  319.         $accessToken = $this->qi->getSetting("access_token_mercado_pago");
  320.         SDK::setAccessToken($accessToken);
  321.         $payment_methods = SDK::get("/v1/payment_methods")["body"];
  322.         $pse = null;
  323.         $efecty=null;
  324.         $baloto=null;
  326.         foreach ($payment_methods as $p){
  328.             if (! $pse && $p["id"] == "pse"){
  329.                 $pse = $p;
  330.             }
  331.             if (! $efecty && $p["id"] == "efecty"){
  332.                 $efecty = $p;
  333.             }
  334.             if (! $baloto && $p["id"] == "baloto"){
  335.                 $baloto = $p;
  336.             }
  337.         }
  339.         /* @var $user Usuario */
  340.         $user = $this->getUser();
  341.         $departamentos = $this->getDoctrine()->getRepository('App:Departamento')->findBy(array('visible'=>true),array('nombre'=>'asc'));
  342.         $ciudades = $this->getDoctrine()->getRepository('App:Ciudad')->findBy(array('visible'=>true),array('nombre'=>'asc'));
  343.         $empty_user = array('nombre'=>'', 'apellido'=>'', 'email'=>'', 'celular'=>'','documento'=>'');
  344.         $direcciones = $this->getDoctrine()->getRepository('App:Direccion')->findBy(array('usuario'=>$this->getUser()));
  346.         if($this->qi->carritoLength() > 0){
  347.             return $this->render('basic/checkout.html.twig',
  348.             array("user" => $user, "ciudades" => $ciudades, "departamentos" => $departamentos,"pse"=>$pse,'efecty'=>$efecty,'baloto'=>$baloto,'empty_user'=>$empty_user,'direcciones'=>$direcciones,'idprincipal' => $idprincipal = null)
  349.         );
  350.         }else{
  351.             return $this->redirectToRoute('homepage'); 
  352.         }
  353.         
  354.         
  355.     }
  357.     /**
  358.      * @Route("/{producto}/romancerelax", name="producto_slug") 
  359.      * @Route("/{idproducto}/{categoria}/{producto}/romancerelax/ro", name="producto_slug_cat")  
  360.      * @Route("/{idproducto}/{producto}/romancerelax", name="producto_slug_subcat")            
  361.      * @Route("/product/{id}/{nombre}", name="product")
  362.      * @Route("/product/{id}/{nombre}/{medida}", name="product_medida")
  363.      * @Route("/{idproducto}/{subcategoria}/{categoria}/{producto}/romancerelax/ro", name="producto_slug_subcategoria")      
  364.      */
  365.     public function product(Request $request, $id=null, $medida=null)
  366.     {
  367.         $routeName = $request->attributes->get('_route');
  368.         $routeParameters = $request->attributes->get('_route_params');
  371.         // dd($routeName);
  373.         $vieneconsubcategoria=null;
  375.         if($routeName == 'producto_slug'){
  376.             $prod=$this->getDoctrine()->getRepository('App:Producto')->findOneBy(array('slug'=>$routeParameters['producto']));
  377.             $id=$prod->getId();
  378.         }
  380.         if($routeName == 'producto_slug_cat'){
  381.             $prod=$this->getDoctrine()->getRepository('App:Producto')->findOneBy(array('plu'=>$routeParameters['idproducto'], 'slug'=>$routeParameters['producto'], 'principal'=>1 ));
  382.             if(!$prod){
  383.                 $prod=$this->getDoctrine()->getRepository('App:Producto')->findOneBy(array('plu'=>$routeParameters['idproducto']));
  384.             }
  385.             if($prod != null){
  386.                 $id=$prod->getId();
  387.             }
  388.         }
  390.         if($routeName == 'producto_slug_subcat'){
  391.             $prod=$this->getDoctrine()->getRepository('App:Producto')->findOneBy(array('plu'=>$routeParameters['idproducto'],'slug'=>$routeParameters['producto'], 'principal'=>1 ));
  392.             if(!$prod){
  393.                 $prod=$this->getDoctrine()->getRepository('App:Producto')->findOneBy(array('plu'=>$routeParameters['idproducto']));
  394.             }
  395.             $id=$prod->getId();
  396.         }
  398.         if($routeName == 'producto_slug_subcategoria'){
  399.             $prod=$this->getDoctrine()->getRepository('App:Producto')->findOneBy(array('plu'=>$routeParameters['idproducto'],'slug'=>$routeParameters['producto'], 'principal'=>1 ));
  400.             if(!$prod){
  401.                 $prod=$this->getDoctrine()->getRepository('App:Producto')->findOneBy(array('plu'=>$routeParameters['idproducto']));
  402.             }
  403.             $id=$prod->getId();
  404.             $vieneconsubcategoria=$routeParameters['subcategoria'];
  405.         }
  407.         $product = $this->getDoctrine()->getRepository('App:Producto')->find($id);
  409.         $idsub=$product->getSubcategoria()->getId();
  410.         $subcateg = $this->getDoctrine()->getRepository('App:Subcategoria')->findOneBy(array('id'=>$idsub));
  411.         $idcateg = $subcateg->getCategoria();
  413.         $categoria=$this->getDoctrine()->getRepository('App:Categoria')->findBy(array('id'=>$idcateg));
  414.         $subcategorias = $this->qi->getSubCategoriasConProductos($idcateg);
  416.         $idmaterialproduct=$product->getMaterial();
  417.         if($idmaterialproduct){
  418.             $materialproduct=$this->getDoctrine()->getRepository('App:Material')->findOneBy(array('id'=>$idmaterialproduct));
  419.             $namemat=$materialproduct->getNombre();
  420.         }else{
  421.             $namemat=null; 
  422.         }
  423.         $user = $this->getUser();
  424.         if($user && $user->getConvenio())
  425.             $convenio = $user->getConvenio();
  426.         else{
  427.             $convenio = $this->getDoctrine()->getRepository(ListaPrecios::class)->find(1);
  428.         }
  430.         $lista = $this->getDoctrine()->getRepository(ListaPrecioItem::class)->findOneBy(array('lista'=>$convenio,'producto'=>$product));
  432.         $padre = $product->getPadre();
  433.         if(!$padre)
  434.             $padre = $product;
  435.         $hermanos = $this->getDoctrine()->getRepository(Producto::class)->createQueryBuilder('p')
  436.             ->select('p.plu', 'p.nombre', 'p.tamanio', 'p.maestro','p.tipologia', 'p.materiales','medida.nombre as nombremed','material.nombre as nombremat','medida.id as idmed','medida.orden as medidaorden')
  437.             ->leftJoin('p.medidas', 'medida')
  438.             ->leftJoin('p.material', 'material')
  439.             ->Where('p.maestro = :maestro')
  440.             ->setParameter('maestro',$product->getMaestro())
  441.             ->orderBy('medidaorden','asc')
  442.             ->getQuery()
  443.             ->getResult();
  447.         $medidas=[];
  448.         foreach($hermanos as $h){
  449.             $medidas[$h['nombremed']]=$h;
  450.         }
  452.         
  453.         $url_combos = "categoria/2/combo";
  455.         $med=null;
  456.         if($medida != null){
  457.             $med=$medida;
  458.         }
  460.         $idprincipal=null;
  461.         $slugcat=$categoria[0]->getSlug();
  463.         $imgsprod = $this->getDoctrine()->getRepository(Image::class)->createQueryBuilder('i')
  464.         ->select('i')
  465.         ->leftJoin('i.producto', 'prod')
  466.         ->where('prod.plu = '.$product->getId())
  467.         ->andWhere('i.visible = 1')
  468.         ->orderBy('i.orden','asc')
  469.         ->getQuery()
  470.         ->getResult();
  474.         $maestros = $this->qi->themaestros($product->getMaestro());
  476.         foreach($maestros as $m){
  477.             $princ = $m['principal'];
  478.             if($princ == 1){
  479.                 $principal = $m;
  480.             }
  481.         }
  483.         $relacionados = $principal['relacionados'];
  485.         if($product->getsubCategoria()->getCategoria()->getId() == 1){
  486.             $imgsprod = $this->getDoctrine()->getRepository(Image::class)->createQueryBuilder('i')
  487.             ->select('i')
  488.             ->leftJoin('i.producto', 'prod')
  489.             ->where('prod.plu = '.$principal['plu'])
  490.             ->andWhere('i.visible = 1')
  491.             ->orderBy('i.orden','asc')
  492.             ->getQuery()
  493.             ->getResult();
  494.         }
  497.         
  498.         return $this->render('basic/product.html.twig', array(
  499.                 'principal_padre'=>$principal,
  500.                 'medidaroute' => $medida,
  501.                 'product' => $product,
  502.                 'materialproduct'=>$namemat,
  503.                 'hermanos'  => $hermanos,
  504.                 'idprincipal' => $idprincipal,
  505.                 'lista' => $lista,
  506.                 'relacionados' => $relacionados,
  507.                 'medida' => $med,
  508.                 'subcategorias'=>$subcategorias,
  509.                 'idcateg'=>$idcateg,
  510.                 'slugcat'=>$slugcat,
  511.                 'imgsprod'=>$imgsprod,
  512.                 'medidas'=>$medidas,
  513.                 'vieneconsubcategoria'=>$vieneconsubcategoria,
  514.                 'idsub'=>$idsub,
  515.                 'idcateg'=>$idcateg
  516.             )
  517.         );
  518.     }
  520.     /**
  521.      * @Route("/contacto/romance/contacto", name="contacto")
  522.      */
  523.     public function contacto(Request $request)
  524.     {
  525.         $contacto= new Contacto();
  526.         $form = $this->createForm(ContactoType::class, $contacto);
  527.         $form->handleRequest($request);
  528.         if ($form->isSubmitted() && $form->isValid()) {
  529.             $entityManager = $this->getDoctrine()->getManager();
  530.             $entityManager->persist($contacto);
  531.             $entityManager->flush();
  532.             $asunto = $this->qi->getSetting('asunto_mail_contacto');
  534.             $html = $this->renderView('mailing/contacto.html.twig', array(
  535.              ));
  537.             $this->qi->sendMail($asunto,$contacto->getEmail(),$html);
  538.             $htmlenvio = $this->renderView('mailing/contactoenvio.html.twig', array(
  539.                 'nombre'=>$contacto->getNombre(),
  540.                 'email'=>$contacto->getEmail(),
  541.                 'telefono'=>$contacto->getTelefono(),
  542.                 'mensaje'=>$contacto->getMensaje(),
  543.             ));
  544.             $to = $this->qi->getSetting('mail_recepcion_contacto');
  545.              $this->qi->sendMail($asunto,$to,$htmlenvio);
  547.             return $this->render('basic/contacto.html.twig', [
  548.                 'gracias'=>true,
  549.                 'idprincipal' => $idprincipal=null
  550.             ]);
  551.         }
  552.         return $this->render('basic/contacto.html.twig', [
  553.             'gracias'=>false,
  554.             'form'=> $form->createView(),
  555.             'idprincipal' => $idprincipal=null
  556.         ]);
  558.     }
  560.     /**
  561.      * @Route("/blog/romance/blog", name="blog")
  562.      * @Route("/blog/{id}/{nombre}", name="blog_categoria")
  563.      */
  564.     public function blog(Request $request, $id = null)
  565.     {
  566.         $categorias = $this->getDoctrine()->getRepository('App:CategoriaBlog')->findAll();
  567.         if($id){
  568.             $categoria = $this->getDoctrine()->getRepository('App:CategoriaBlog')->find($id);
  569.             $blogs = $this->getDoctrine()->getManager()->getRepository('App:Blog')->findBy(array('visible'=>true,'categoria'=>$categoria),array('fecha'=>'desc'));
  570.         }else
  571.             $blogs = $this->getDoctrine()->getManager()->getRepository('App:Blog')->findBy(array('visible'=>true),array('fecha'=>'desc'));
  572.         return $this->render('blog/blog.html.twig', [
  573.             'blogs' => $blogs,
  574.             'categorias' => $categorias,
  575.             'idprincipal' => $idprincipal = null
  576.         ]);
  577.     }
  579.     /**
  580.      * @Route("/blog-interna/{id}/{nombre}", name="blog-interna")
  581.      */
  582.     public function blogInterna(Request $request, $id)
  583.     {
  584.         $blog = $this->getDoctrine()->getRepository('App:Blog')->find($id);
  585.         $blog_next = $this->getDoctrine()->getRepository('App:Blog')->createQueryBuilder('b')
  586.             ->select('b.id','b.titulo','b.created_at')
  587.             ->where('b.created_at <= :fecha')
  588.             ->andWhere('b.id != '.$blog->getId())
  589.             ->orderBy('b.created_at','desc')
  590.             ->setMaxResults(1)
  591.             ->setParameter('fecha', $blog->getCreatedAt())
  592.             ->getQuery()
  593.             ->getOneOrNullResult();
  594.         if(!$blog_next){
  595.             $blog_next = $this->getDoctrine()->getRepository('App:Blog')->createQueryBuilder('b')
  596.                 ->select('b.id','b.titulo')
  597.                 ->orderBy('b.created_at','desc')
  598.                 ->andWhere('b.id != '.$blog->getId())
  599.                 ->setMaxResults(1)
  600.                 ->getQuery()
  601.                 ->getOneOrNullResult();
  602.         }
  603.         $blog_prev = $this->getDoctrine()->getRepository('App:Blog')->createQueryBuilder('b')
  604.             ->select('b.id','b.titulo')
  605.             ->where('b.created_at >= :fecha')
  606.             ->andWhere('b.id != '.$blog->getId())
  607.             ->orderBy('b.created_at','asc')
  608.             ->setMaxResults(1)
  609.             ->setParameter('fecha', $blog->getCreatedAt())
  610.             ->getQuery()
  611.             ->getOneOrNullResult();
  612.         if(!$blog_prev){
  613.             $blog_prev = $this->getDoctrine()->getRepository('App:Blog')->createQueryBuilder('b')
  614.                 ->select('b.id','b.titulo')
  615.                 ->orderBy('b.created_at','asc')
  616.                 ->andWhere('b.id != '.$blog->getId())
  617.                 ->setMaxResults(1)
  618.                 ->getQuery()
  619.                 ->getOneOrNullResult();
  620.         }
  621.         $likes = $this->getDoctrine()->getRepository('App:Like')->createQueryBuilder('q')
  622.             ->select('count(q)')
  623.             ->leftJoin('q.blog','b')
  624.             ->where('b.id = '.$blog->getId())
  625.             ->getQuery()
  626.             ->getSingleResult();
  627.         $comentario = new ComentarioBlog();
  628.         $comentario->setBlog($blog);
  629.         $like_user = false;
  630.         $user_id = 0;
  632.         if($this->getUser()){
  633.             $user_id = $this->getUser()->getId();
  634.             $usuario = $this->getDoctrine()->getRepository('App:Usuario')->find($user_id);
  635.             $comentario->setUsuario($usuario);        
  636.             $idblog=$blog->getId();
  637.             $like_user = $this->getDoctrine()->getRepository('App:Like')->findBy(array('blog'=>$idblog));
  638.         }               
  640.         $form = $this->createForm(ComentarioType::class, $comentario);
  641.         $creado = false;
  642.         if($request->isMethod('POST')){
  643.             $form->handleRequest($request);
  644.             if ($form->isSubmitted() && $form->isValid()) {
  645.                 $entityManager = $this->getDoctrine()->getManager();
  646.                 $entityManager->persist($comentario);
  647.                 $entityManager->flush();
  648.                 $creado = true;
  649.                 $comentario = new ComentarioBlog();
  650.                 $comentario->setBlog($blog);
  651.                 if($this->getUser()){
  652.                     $usuario = $this->getDoctrine()->getRepository('App:Usuario')->find($this->getUser()->getId());
  653.                     $comentario->setUsuario($usuario);
  654.                 }
  655.                 $form = $this->createForm(ComentarioType::class, $comentario);
  656.             }
  657.         }
  659.         $comentarios = $this->getDoctrine()->getRepository('App:ComentarioBlog')->createQueryBuilder('q')
  660.             ->select('q.id','q.comentario', 'q.created_at', "concat(u.nombre, ' ', u.apellido) usuario")
  661.             ->leftJoin('q.blog','b')
  662.             ->leftJoin('q.usuario','u')
  663.             ->where('b.id = '.$blog->getId())
  664.             ->getQuery()
  665.             ->getResult();
  667.         return $this->render('blog/blog-interna.html.twig', [
  668.             'blog' => $blog,
  669.             'likes' => $likes,
  670.             'comentarios' => $comentarios,
  671.             'blog_next' => $blog_next,
  672.             'blog_prev' => $blog_prev,
  673.             'form' => $form->createView(),
  674.             'creado' => $creado,
  675.             'like_user' => $like_user,
  676.             'user_id' => $user_id,
  677.             'idprincipal' => $idprincipal = null
  679.         ]);
  680.     }
  684.     /**
  685.      * @Route("/comentario/romance/comentario", name="comentario")
  686.      */
  687.     public function comentario(Request $request)
  688.     {
  689.         $contacto= new Comentario();
  690.         $form = $this->createForm(ContactoType::class, $contacto);
  691.         $form->handleRequest($request);
  692.         if ($form->isSubmitted() && $form->isValid()) {
  693.             $entityManager = $this->getDoctrine()->getManager();
  694.             $entityManager->persist($contacto);
  695.             $entityManager->flush();
  696.             $asunto = $this->qi->getSetting('asunto_mail_contacto');
  697.             $html = $this->renderView('contact/contact_mail.html.twig', array(
  698.                 'nombre'=>$contacto->getNombre(),
  699.                 'email'=>$contacto->getEmail(),
  700.                 'telefono'=>$contacto->getTelefono(),
  701.                 'mensaje'=>$contacto->getMensaje(),
  702.             ));
  703.             $this->qi->sendMail($asunto,$contacto->getEmail(),$html);
  704.             $to = $this->qi->getSetting('mail_recepcion_pedidos');
  705.             $this->qi->sendMail($asunto,$to,$html);
  707.             return $this->render('basic/contacto.html.twig', [
  708.                 'gracias'=>true
  709.             ]);
  710.         }
  711.         return $this->render('basic/contacto.html.twig', [
  712.             'gracias'=>false,
  713.             'form'=> $form->createView(),
  714.             'idprincipal' => $idprincipal=null
  715.         ]);
  717.     }
  719.     /**
  720.      * @Route("/buscador_old/romance/buscador_old", name="buscador_old")
  721.      */
  722.     public function buscadorOld(Request $request)
  723.     {
  724.        /*  if (!$this->qi->getDireccion()) {
  725.             $tienda = null;
  726.         } else {
  727.             if (!$this->qi->getTienda()) {
  728.                 $tienda = $this->qi->getTiendaFromCoordinates($this->qi->getDireccion());
  729.                 if (!$tienda) {
  730.                     $this->addFlash(
  731.                         'warning',
  732.                         'La direccion seleccionada no tiene cobertura en este momento'
  733.                     );
  734.                     return $this->redirectToRoute('misdirecciones');
  735.                 }
  736.             } else {
  737.                 $tienda = $this->qi->getTienda();
  738.             }
  739.         } */
  741.         /* $query = $request->query->get('query', "");
  742.         $productos = $this->getDoctrine()->getRepository(Producto::class)->createQueryBuilder('p')
  743.             ->select('p')
  745.             ->leftJoin('p.categorias', 'c')
  746.             ->where('(p.nombre like :query or p.nombreComercial like :query or p.resumen like :query or p.contraindicaciones like :query or p.interacciones like :query or p.posologia like :query) and p.visible = 1')
  747.             ->andWhere('c.visible = 1')
  748.             ->setParameter('query', '%' . $query . '%');
  749.         if ($tienda) {
  750.             $productos->leftJoin('p.inventarios', 'i')
  751.                 ->leftJoin('i.tienda', 't')
  752.                 ->andWhere('i.cantidad >= 0 and t.id = :tienda')
  753.             ->setParameter('tienda', $tienda->getId());
  754.         }
  755.         $productos= $productos->groupBy('p.plu')->orderBy('p.orden','asc')
  756.             ->getQuery()
  757.             ->getArrayResult();*/
  759.         return false;
  760.         /*return $this->render('basic/buscador.html.twig', [
  761.         ]);*/
  762.     }
  766.     /**
  767.      * @Route("/buscadorapi/romance/buscadorapi", name="buscadorapi")
  768.      */
  769.     public function buscadorapi(Request $request)
  770.     {
  771.         $msg = '';
  772.         $status = 0;
  773.         $resp = [];
  774.         if (!$this->qi->getDireccion()) {
  775.             $tienda = null;
  776.         } else {
  777.             if (!$this->qi->getTienda()) {
  778.                 $tienda = $this->qi->getTiendaFromCoordinates($this->qi->getDireccion());
  779.                 if (!$tienda) {
  780.                     $resp = [];
  781.                 }
  782.             } else {
  783.                 $tienda = $this->qi->getTienda();
  784.             }
  785.         }
  787.         $query = $request->request->get('search', "");
  788.         $productos = $this->getDoctrine()->getRepository(Producto::class)->createQueryBuilder('p')
  789.             ->select('p.plu value', 'p.nombre label')
  791.             ->leftJoin('p.categorias', 'c')
  792.             ->where('(p.nombre like :query or p.nombreComercial like :query or p.resumen like :query or p.contraindicaciones like :query or p.interacciones like :query or p.posologia like :query) and p.visible = 1')
  793.             ->andWhere('c.visible = 1')
  794.             ->setParameter('query', '%' . $query . '%');
  795.         if ($tienda) {
  797.             $productos->leftJoin('p.inventarios', 'i')
  798.                 ->leftJoin('i.tienda', 't')
  799.                 ->andWhere('i.cantidad > 0 and t.id = :tienda')
  800.                 ->setParameter('tienda', $tienda->getId());
  801.         }
  802.         $productos= $productos->groupBy('p.plu')->orderBy('p.orden','asc')
  803.             ->getQuery()
  804.             ->getArrayResult();
  805.         return new Response(json_encode($productos));
  806.     }
  809.     /**
  810.      * @Route("/misdirecciones/romance/misdirecciones", name="misdirecciones")
  811.      */
  812.     public function misdirecciones(Request $request)
  813.     {
  814.         $user = $this->getUser();
  815.         if(!$user){
  816.             return $this->redirectToRoute('homepage');
  817.         }
  819.         $tiendas = $this->getDoctrine()->getRepository(Tienda::class)->findBy(array('visible'=>true),array('orden'=>'asc'));
  820.         $direcciones = $this->getDoctrine()->getRepository(Direccion::class)->findBy(array('usuario'=>$user,'visible'=>true));
  821.         return $this->render('basic/addDir.html.twig', [
  822.             'tiendas' => $tiendas,
  823.             'direcciones' => $direcciones,
  824.             'idprincipal' => $idprincipal=null
  825.         ]);
  826.     }
  829.     /**
  830.      * @Route("/perfil/romance/perfil", name="perfil")
  831.      */
  832.     public function perfil(Request $request, $id = null)
  833.     {
  834.         $user = $this->getUser();
  835.         $borre_dir = false;
  836.         if($id){
  837.             $direccion = $this->getDoctrine()->getRepository(Direccion::class)->find($id);
  838.             $direccion->setVisible(false);
  839.             $entityManager = $this->getDoctrine()->getManager();
  840.             $entityManager->persist($direccion);
  841.             $entityManager->flush();
  842.             $borre_dir = true;
  843.         }
  844.         $direcciones = $this->getDoctrine()->getRepository(Direccion::class)->createQueryBuilder('d')
  845.             ->select('d')
  846.             ->leftJoin('d.usuario','u')
  847.             ->where('u.id = '.$user->getId())
  848.             ->andWhere('d.visible is null or d.visible = 1')
  849.             ->getQuery()
  850.             ->getResult();
  851.         $form = $this->createForm(PerfilType::class, $user);
  852.         $form->handleRequest($request);
  853.         if ($form->isSubmitted() && $form->isValid()) {
  854.             $entityManager = $this->getDoctrine()->getManager();
  855.             $entityManager->persist($user);
  856.             $entityManager->flush();
  858.             return $this->render('user/perfil.html.twig', [
  859.                 'gracias'=>true,
  860.                 'borre_dir'=>$borre_dir,
  861.                 'direcciones' => $direcciones,
  862.                 'form'=> $form->createView()
  863.             ]);
  864.         }
  865.         return $this->render('user/perfil.html.twig', [
  866.             'gracias'=>false,
  867.             'borre_dir'=>$borre_dir,
  868.             'direcciones' => $direcciones,
  869.             'form'=> $form->createView()
  870.         ]);
  871.     }
  873.     /**
  874.      * @Route("/recomendaciones-para-pacientes/romance/recomendaciones-para-pacientes", name="recomendaciones")
  875.      */
  876.     public function recomendaciones(Request $request)
  877.     {
  878.         return $this->render('recomendaciones/recomendaciones.html.twig', [
  879.             'gracias'=>false,
  880.             'form'=> null
  881.         ]);
  882.     }
  884.     /**
  885.      * @Route("/tips/romance/tips", name="tips")
  886.      */
  887.     public function tips(Request $request)
  888.     {
  889.         $tips = $this->getDoctrine()->getRepository(TipSalud::class)->findBy(array("visible" => true), array('orden'=>'asc'));
  890.         return $this->render('tips/index.html.twig', [
  891.             "tips"=>$tips,
  892.             'gracias'=>false,
  893.             'form'=> null
  894.         ]);
  895.     }
  897.     /**
  898.      * @Route("/tip/{id}", name="tip")
  899.      */
  900.     public function tip(Request $request, $id)
  901.     {
  902.         $tip = $this->getDoctrine()->getRepository(TipSalud::class)->find($id);
  903.         return $this->render('tips/tip.html.twig', [
  904.             "tip"=>$tip,
  905.             'gracias'=>false,
  906.             'form'=> null
  907.         ]);
  908.     }
  911.     /**
  912.      * @Route("/covid-19", name="covid")
  913.      */
  914.     public function covid(Request $request)
  915.     {
  916.         $articulos = $this->getDoctrine()->getRepository('App:Covid')->findBy(array('visible'=>true),array('orden'=>'asc'));
  917.         return $this->render('recomendaciones/recomendaciones.html.twig', [
  918.             'gracias'=>false,
  919.             'form'=> null,
  920.             'articulos'=>$articulos
  921.         ]);
  922.     }
  924.     /**
  925.      * @Route("/servicios-de-enfermeria", name="enfermeria")
  926.      */
  927.     public function enfermeria(Request $request)
  928.     {
  929.         $first = 1;
  930.         $size = 100;
  931.         $productos = $this->getDoctrine()->getRepository('App:Inventario')->createQueryBuilder('i')
  932.         ->select('i.precio','p.nombre','p.imagen','p.plu')
  933.         ->addSelect(
  934.             'CASE WHEN p.nombreComercial is not null and p.nombreComercial <> \'\' THEN p.nombreComercial ELSE p.nombre END AS nombrePublico')
  935.         ->leftJoin('i.producto','p')
  936.         ->leftJoin('p.categorias','c')
  937.         ->where('i.cantidad > 0')
  938.         ->andWhere('p.visible = 1')
  939.         ->andWhere("p.imagen not like '%icon%'")
  940.         ->setFirstResult($first)
  941.         ->setMaxResults($size)
  942.         ->getQuery()
  943.         ->getArrayResult();
  944.         shuffle($productos);
  945.         $productos = array_slice($productos,0,4);
  946.         return $this->render('enfermeria/enfermeria.html.twig', [
  947.             'gracias'=>false,
  948.             'form'=> null,
  949.             'productos'=>$productos
  950.         ]);
  951.     }
  954.     /**
  955.      * @Route("/pedir/romance/pedir", name="pedir")
  956.      */
  957.     public function pedir(Request $request)
  958.     { 
  959.         try {
  960.             $user = $this->getUser();
  961.             $direccion = $this->getDoctrine()->getRepository(Direccion::class)->find($this->qi->getDireccion()->getId());
  962.             $metodo_sel = $request->request->get('metodo');
  963.             $metodo = $this->getDoctrine()->getRepository(MetodoPago::class)->findOneBy(array('id' => $metodo_sel));
  964.             $tienda = $this->getDoctrine()->getRepository(Tienda::class)->find($this->qi->getTienda()->getId());
  965.             $costo_domicilio = $tienda->getCostoDomicilio();
  966.             $comentarios = $request->request->get('comentarios');
  967.             $medico = $request->request->get('medico');
  968.             $lifemiles = $request->request->get('lifemiles');
  969.             $peticion= $this->qi->getCarrito();
  970.             $paga_con = 0;
  971.             $canal = "web";
  972.             $carrito=[];
  973.             if($metodo_sel == "2"){
  974.                 return $this->redirectToRoute('pagos_payu',array(
  975.                     "comentarios"=>$comentarios,
  976.                     "medico" => $medico,
  977.                     "lifemiles" => $lifemiles
  978.                 ));
  979.             }
  980.             foreach ($this->qi->getCarrito() as $item){
  981.                 $elem = array("product_id"=>$item["producto"]->getPlu(),"count"=>$item["cantidad"]);
  982.                 array_push($carrito,$elem);
  983.             }
  984.             $res = $this->qi->crearPedido($metodo,$canal,$comentarios,$this->getUser()); 
  986.             /* @var $compra Compra */
  987.             $compra =$res["compra"];
  989.             $resultado = array("ok" => true, 'obj' => array("compra"=>array("id"=>$compra->getId())));
  991.             // dd('entra a pedir',$compra);
  993.             if($this->qi->getSetting('enviar_correo') == "1"){
  994.                 $asunto = $this->qi->getTexto('asunto_compra_cliente');
  995.                 $this->qi->sendMail($asunto, $this->getUser()->getEmail(), $compra->getBody());
  996.                 $asunto = $this->qi->getTexto('asunto_compra_tienda');
  997.                 if($compra->getTienda()) {
  998.                     $this->qi->sendMail($asunto, $compra->getTienda()->getEmail(), $compra->getBody());
  999.                 }else{
  1000.                     $this->qi->sendMail($asunto, $this->qi->getSetting('mail_recepcion_pedidos'), $compra->getBody());
  1001.                 }
  1002.             }
  1004.         }catch (\Exception $e){
  1005.             $resultado = array("ok" => false, 'obj' => $e->getCode()." - ".$e->getMessage());
  1006.         }
  1008.         if($resultado["ok"]) {
  1009.             return $this->redirectToRoute('confirmacion', $resultado);
  1010.         }else{
  1011.             return $this->redirectToRoute('carrito', $resultado);
  1012.         }
  1013.     }
  1015.     /**
  1016.      * @Route("/set-direccion/{id}", name="set-direccion")
  1017.      */
  1018.     public function setDireccion(Request $request,$id)
  1019.     {
  1020.         $user = $this->getUser();
  1021.         $dir = $this->getDoctrine()->getRepository(Direccion::class)->find($id);
  1022.         $this->qi->setDireccion($dir);
  1024.         $tienda = $this->qi->getTiendaFromCoordinates($dir);
  1025.         if(!$tienda){
  1026.             $this->addFlash(
  1027.                 'warning',
  1028.                 'La direccion seleccionada no tiene cobertura en este momento'
  1029.             );
  1030.             return $this->redirectToRoute('misdirecciones');
  1031.         }
  1032.         $this->qi->setTienda($tienda);
  1034.         if($this->qi->carritoLength() > 0)
  1035.             return $this->redirectToRoute('carrito');
  1036.         return $this->redirectToRoute('homepage');
  1037.     }
  1039.     /**
  1040.      * @Route("/add-direccion/romance/add-direccion", name="add-direccion")
  1041.      */
  1042.     public function addDireccion(Request $request)
  1043.     {
  1044.         $user = $this->getUser();
  1045.         // dd($user);
  1046.         if($user) {
  1047.             $dir = new Direccion();
  1048.             $dirarr = $request->request->get('direccion');
  1049.             $ciudad = $request->request->get('ciudad');
  1050.             $prede = $request->request->get('predeterminada');
  1052.             $prede=$prede ?? 0;
  1053.             $ciudad = $this->getDoctrine()->getRepository(Ciudad::class)->find($ciudad);
  1054.             $dir->setUsuario($user);
  1055.             $dir->setDireccion($dirarr);
  1056.             $dir->setUid($user->getUid() ?? '');
  1057.             $dir->setCiudad($ciudad);
  1058.             $dir->setPredeterminada($prede);
  1059.             $entityManager = $this->getDoctrine()->getManager();
  1060.             $entityManager->persist($dir);
  1061.             $entityManager->flush();
  1063.             $this->qi->setDireccion($dir);
  1064.             return $this->redirectToRoute('mis-direcciones');
  1065.         }else{
  1067.             return $this->redirectToRoute('login');
  1068.         }
  1069.     }
  1074.     function existeCatProds($productos,$c){
  1075.         $encontrado = false;
  1076.         for ($i = 0; $i<count($productos);$i++){
  1077.             for($k = 0; $k < count($productos[$i]["producto"]["categorias"]);$k++){
  1078.                 $encontrado = $c->getId() == $productos[$i]["producto"]["categorias"][$k]['id'];
  1079.                 if($encontrado){
  1081.                     $k=count($productos[$i]["producto"]["categorias"])+1;
  1082.                     $i=count($productos)+1;
  1083.                     break;
  1084.                 }
  1085.             }
  1086.             if($encontrado){
  1087.                 break;
  1088.             }
  1091.         }
  1092.         return $encontrado;
  1093.     }
  1095.     function arePointsNear($checkPoint, $centerPoint, $km) {
  1096.         $ky = 40000 / 360;
  1097.         $kx = cos(pi() * $centerPoint->getLat() / 180.0) * $ky;
  1098.         $dx = abs($centerPoint->getLng() - $checkPoint->getLng()) * $kx;
  1099.         $dy = abs($centerPoint->getLat() - $checkPoint->getLat()) * $ky;
  1100.         return sqrt($dx * $dx + $dy * $dy) <= $km;
  1101.     }
  1103.     /**
  1104.      * @Route("/categoria", name="categoria")
  1105.      * @Route("/subcategoria/{id_sub}/{nombre}/{referencia}", name="subcategoria_nombre")
  1106.      * @Route("/{subcategoria}/{categoria_slug}", name="subcategoria_slug") 
  1107.      * @Route("/buscador/romance/buscador", name="buscador")
  1108.      * @Route("/{categoria}", name="categoria_slug")
  1109.      * @Route("/{categoria}/{medida}/romance/ro", name="medida")    
  1110.      * @Route("/{categoria}/{material}/romance", name="material")     
  1111.      */
  1112.     public function categoria(Request $request, $id_cat = null, $id_sub = null, $referencia=null, $medidaid=null, $materialid=null )
  1113.     {
  1114.         $subcategoria= null;
  1115.         $titulo = "";
  1117.         $query = $this->getDoctrine()->getRepository('App:Producto')->createQueryBuilder('p')
  1118.             ->select('p.plu')
  1119.             ->where('p.visible=1')
  1120.             ->leftJoin('p.subcategoria','s');
  1122.         $routeName = $request->attributes->get('_route');
  1123.         $routeParameters = $request->attributes->get('_route_params');
  1124.         $parameter_med='';
  1126.         $medidaparameter=[];
  1127.         $medidassel=[];
  1128.         $material=null;
  1130.         if($routeName == 'categoria_slug'){
  1131.             $cat=$this->getDoctrine()->getRepository('App:Categoria')->findOneBy(array('slug'=>$routeParameters['categoria']));
  1132.             if(!$cat){
  1133.                 return $this->redirectToRoute("homepage");
  1134.             }
  1135.             $id_cat=$cat->getId();
  1136.         }
  1138.         if($routeName == 'subcategoria_slug' ){
  1139.             $cat=$this->getDoctrine()->getRepository('App:Categoria')->findOneBy(array('slug'=>$routeParameters['categoria_slug']));
  1140.             if(!$cat){
  1141.                 return $this->redirectToRoute("homepage");
  1142.             }
  1143.             $subcat=$this->getDoctrine()->getRepository('App:Subcategoria')->findOneBy(array('slug'=>$routeParameters['subcategoria'],'categoria'=>$cat->getId()));
  1144.             if(!$subcat){
  1145.                 return $this->redirectToRoute("homepage");
  1146.             }
  1147.             $id_sub=$subcat->getId();
  1148.         }
  1150.         if($routeName == 'medida' ){
  1151.             $parameter_med=str_replace ( '-' , ' ' ,$routeParameters['medida'] );
  1152.             $routeParameters['categoria'];
  1153.             $cat=$this->getDoctrine()->getRepository('App:Categoria')->findOneBy(array('slug'=>$routeParameters['categoria']));
  1154.             $id_cat=$cat->getId();
  1155.             //$medidaparameter=$this->getDoctrine()->getRepository('App:Medidas')->findBy(array('nombre'=>$parameter_med));
  1156.             $medidaspa=$this->getDoctrine()->getRepository('App:Medidas')->createQueryBuilder('m')
  1157.                 ->select('m.id')
  1158.                 ->where('m.nombre like :nombremedidas')
  1159.                 ->setParameter('nombremedidas','%'.$parameter_med.'%');
  1160.              if($cat){
  1161.                  $medidaspa=$medidaspa->leftJoin('m.categoria','cat')
  1162.                  ->andWhere('cat.id = :catid')
  1163.                      ->setParameter('catid',$cat->getId());
  1164.              }
  1165.             $medidaspa= $medidaspa->groupBy('m.id')->getQuery()
  1166.                 ->getArrayResult();
  1168.             foreach ($medidaspa as $result) {
  1169.                array_push($medidaparameter,$result['id']);
  1170.             }
  1171.         }
  1175.         if($routeName == 'material' ){
  1176.             $cat=$this->getDoctrine()->getRepository('App:Categoria')->findOneBy(array('slug'=>$routeParameters['categoria']));
  1177.             $id_cat=$cat->getId();
  1178.             $material=$this->getDoctrine()->getRepository('App:Material')->findOneBy(array('nombre'=>$routeParameters['material']));
  1179.         }
  1182.         if($id_cat) {
  1183.             $categoria = $this->getDoctrine()->getRepository('App:Categoria')->find($id_cat);
  1184.             $subcategorias = $this->qi->getSubCategoriasConProductos($id_cat);
  1185.             if($id_cat != 6){
  1186.                 $query = $query->leftJoin('s.categoria','c')
  1187.                 ->andWhere('c.id = :cat')
  1188.                 ->setParameter('cat',$id_cat);
  1189.             }          
  1190.             $titulo = $categoria->getNombre();
  1191.         }else if($id_sub){
  1192.             $subcategoria = $this->getDoctrine()->getRepository('App:Subcategoria')->find($id_sub);
  1193.             $categoria = $subcategoria->getCategoria();
  1194.             $id_cat=$categoria->getId();
  1195.             $subcategorias = $this->qi->getSubCategoriasConProductos($id_cat);
  1196.             $query = $query->andWhere('s.id = :sub')
  1197.                 ->setParameter('sub',$id_sub);
  1198.             $titulo = $subcategoria->getNombre();
  1199.         }else{
  1200.             $subcategoria = null;
  1201.             $categoria = null;
  1202.             $subcategorias = [];
  1203.         }
  1206.         $preciomin = $request->query->get('preciomin',"");
  1207.         $preciomax = $request->query->get('preciomax',"");
  1208.         $preciomin_mobile = $request->query->get('preciomin_mobile',"");
  1209.         $preciomax_mobile = $request->query->get('preciomax_mobile',"");
  1210.         $medida = $request->query->get('medida',"");
  1211.         $tipologia = $request->query->get('tipologia',"");
  1213.         if($request->get('search')) {
  1214.             $search = $request->get('search',"");
  1215.             $prods_alg = false;
  1216.             $em = $this->getDoctrine()->getManagerForClass(Producto::class);
  1217.             $prods_alg = $this->searchService->rawSearch(Producto::class, $search)['hits'];
  1218.             $query = $query
  1219.                 ->andWhere('p.plu in (:idsalg)')
  1220.                 ->setParameter('idsalg',array_column($prods_alg,'plu'));
  1221.         }
  1223.         $tecnologias = array();
  1224.         $tipologias = array();
  1225.         $adaptabilidades = array();
  1226.         $independencias = array();
  1227.         $gammas = array();
  1228.         $medidas = array();
  1229.         $filtros = array(
  1230.             "Tipología" => $tipologias,
  1231.             "Medida" => $medidas
  1232.         );
  1234.         $plus = $query->getQuery()->getArrayResult();
  1237.         $user = $this->getUser();
  1238.         if($user && $user->getConvenio())
  1239.             $convenio = $user->getConvenio();
  1240.         else{
  1241.             $convenio = $this->getDoctrine()->getRepository(ListaPrecios::class)->find(1);
  1242.         }
  1244.         // consulta productos
  1245.         $productos=[];
  1247.         $productospadres = $this->getDoctrine()->getRepository('App:Producto')->createQueryBuilder('p')
  1248.             ->select('pa.plu,pa.slug, pa.nombre, pa.resumen , pa.imagen, pa.tamanio, pa.tecnologia, pa.tipologia, pa.adaptabilidad, pa.independencia,pa.gamma,
  1249.             pa.color_texto,pa.descuento ,pa.alt,pa.tela,pa.maestro,pa.principal,pa.visible,pa.orden,pa.dctoic,pa.incarrito,
  1250.                         me.nombre as medida, mat.nombre as material, l.precio')
  1251.             ->leftJoin('p.padre','pa')
  1252.             ->leftJoin('pa.listas','l')
  1253.             ->leftJoin('l.lista','li')
  1254.             ->leftJoin('pa.medidas','me')
  1255.                 ->leftJoin('pa.material','mat')
  1256.             ->Where('p.plu in (:ids)')
  1257.             ->andWhere('pa is not null')
  1258.             ->setParameter('ids',array_column($plus,'plu'))
  1259.             ->andWhere('li.id = :l_id')
  1260.              ->setParameter('l_id',$convenio->getId());
  1262.         $productosunicos=$this->getDoctrine()->getRepository('App:Producto')->createQueryBuilder('p')
  1263.         ->select('p.plu, p.slug,p.nombre, p.resumen , p.imagen, p.tamanio, p.tecnologia, p.tipologia, p.adaptabilidad, p.independencia,p.gamma,
  1264.             p.color_texto,p.descuento ,p.alt,p.tela,p.maestro,p.principal,p.visible,p.orden,p.dctoic,p.incarrito,
  1265.                         me.nombre as medida, mat.nombre as material, l.precio,pa.visible padre_visible, pa.plu padre_id')
  1266.         ->leftJoin('p.padre','pa')
  1267.         ->leftJoin('p.listas','l')
  1268.         ->leftJoin('l.lista','li')
  1269.         ->leftJoin('p.medidas','me')
  1270.         ->leftJoin('p.material','mat')
  1271.         ->Where('p.plu in (:ids)')
  1272.             ->andWhere("(p.padre is null and p.visible = 1) or (pa.visible = 1)")
  1273.        // ->andWhere('p.padre is null')
  1274.         ->setParameter('ids',array_column($plus,'plu'))
  1275.             ->andWhere('li.id = :l_id')
  1276.             ->setParameter('l_id',$convenio->getId());
  1278.         /*$productos = $this->getDoctrine()->getRepository('App:Producto')->createQueryBuilder('p')
  1279.         ->select(
  1280.         'DISTINCT (CASE WHEN p.padre is not null THEN pa.plu ELSE p.plu END) AS plu',
  1281.                 'CASE WHEN p.padre is not null THEN pa.slug ELSE p.slug END AS slug',
  1282.                 'CASE WHEN p.padre  is not null  THEN pa.nombre ELSE p.nombre END AS nombre',
  1283.                 'CASE WHEN p.padre  is not null  THEN pa.resumen ELSE p.resumen END AS resumen',
  1284.                 'CASE WHEN p.padre  is not null  THEN pa.imagen ELSE p.imagen END AS imagen',
  1285.                 'CASE WHEN p.padre  is not null  THEN pa.tamanio ELSE p.tamanio END AS tamanio',
  1286.                 'CASE WHEN p.padre  is not null  THEN me.nombre ELSE me.nombre END AS medida',
  1287.                 'CASE WHEN p.padre  is not null  THEN mat.nombre ELSE me.nombre END AS material',
  1288.                 'CASE WHEN p.padre  is not null  THEN pa.tecnologia ELSE p.tecnologia END AS tecnologia',
  1289.                 'CASE WHEN p.padre  is not null  THEN pa.tipologia ELSE p.tipologia END AS tipologia',
  1290.                 'CASE WHEN p.padre  is not null  THEN pa.adaptabilidad ELSE p.adaptabilidad END AS adaptabilidad',
  1291.                 'CASE WHEN p.padre  is not null  THEN pa.independencia ELSE p.independencia END AS independencia',
  1292.                 'CASE WHEN p.padre  is not null  THEN pa.gamma ELSE p.gamma END AS gamma',
  1293.                 'CASE WHEN p.padre  is not null  THEN pa.color_texto ELSE p.color_texto END AS color_texto',
  1294.                 'CASE WHEN p.padre  is not null  THEN pa.descuento ELSE p.descuento END AS descuento',
  1295.                 'CASE WHEN p.padre  is not null  THEN pa.alt ELSE p.alt END AS alt',
  1296.                 'CASE WHEN p.padre  is not null  THEN pa.tela ELSE p.tela END AS tela',
  1297.                 'CASE WHEN p.padre  is not null  THEN pa.maestro ELSE p.maestro END AS maestro',
  1298.                 'CASE WHEN p.padre  is not null  THEN pa.principal ELSE p.principal END AS principal',
  1299.                 'CASE WHEN p.padre  is not null  THEN pa.visible ELSE p.visible END AS visible',
  1300.                  'CASE WHEN p.padre  is not null  THEN pa.orden ELSE p.orden END AS orden',
  1301.                 'CASE WHEN p.dctoic  is not null  THEN pa.dctoic ELSE pa.dctoic END AS dctoic',
  1302.                 'CASE WHEN p.incarrito  is not null  THEN pa.incarrito ELSE pa.dctoic END AS incarrito',
  1303.                  'CASE WHEN p.padre  is not null  THEN lipadre.id ELSE l.id END AS lista',
  1304.                  'CASE WHEN p.padre  is not null  THEN lpadre.precio ELSE l.precio END AS precio')
  1305.         ->leftJoin('p.padre','pa')
  1306.         ->leftJoin('p.listas','l')
  1307.         ->leftJoin('l.lista','li')
  1308.         ->leftJoin('pa.listas','lpadre')
  1309.         ->leftJoin('lpadre.lista','lipadre')
  1310.         ->leftJoin('p.medidas','me')
  1311.         ->leftJoin('p.material','mat')
  1312.         ->Where('p.plu in (:ids)')
  1313.         ->setParameter('ids',array_column($plus,'plu'));
  1314.         //->andWhere('li.id = :l_id or lipadre.id =:l_id')
  1315.         //->setParameter('l_id',$convenio->getId());*/
  1317.         if($preciomin){
  1318.             $productospadres->andWhere('l.precio >='.$preciomin);
  1319.             $productosunicos->andWhere('l.precio >='.$preciomin);
  1320.         }
  1321.         if($preciomin_mobile){
  1322.             $productospadres->andWhere('l.precio >='.$preciomin_mobile);
  1323.             $productosunicos->andWhere('l.precio >='.$preciomin_mobile);
  1324.         }
  1325.         if($preciomax){
  1326.             $productospadres->andWhere('l.precio <='.$preciomax);
  1327.             $productosunicos->andWhere('l.precio <='.$preciomax);
  1328.         }
  1329.         if($preciomax_mobile){
  1330.             $productospadres->andWhere('l.precio <='.$preciomax_mobile);
  1331.             $productosunicos->andWhere('l.precio <='.$preciomax_mobile);
  1332.         }
  1334.         if($id_cat){
  1335.             if($id_cat==6){
  1336.                 $productosunicos->andwhere('p.padre is null');
  1337.             }
  1338.             $productospadres->leftJoin('pa.categorias','c')
  1339.                 ->andWhere('c.id = '.$id_cat);
  1340.             $productosunicos->leftJoin('p.categorias','c')
  1341.             ->andWhere('c.id = '.$id_cat);
  1342.         }
  1343.         if ($id_sub){
  1344.              $productospadres->leftJoin('pa.subcategoria','sub')
  1345.                 ->andWhere('sub.id = '.$id_sub);
  1346.             $productosunicos->leftJoin('p.subcategoria','sub')
  1347.             ->andWhere('sub.id = '.$id_sub);
  1348.         }
  1350.         if(count($medidaparameter)>0){
  1351.             $productospadres=$productospadres->andWhere($productospadres->expr()->in('me.id',$medidaparameter));
  1352.             $productosunicos=$productosunicos->andWhere($productosunicos->expr()->in('me.id',$medidaparameter));
  1353.             //$productospadres->andWhere("me.id = '".$medidaparameter->getId()."'");
  1354.            // $productosunicos->andWhere("me.id = '".$medidaparameter->getId()."'");
  1355.         }
  1356.         /*
  1357.         $productospadres=$productospadres->orderBy('pa.orden', 'asc')
  1358.             ->groupby('pa.maestro')
  1359.             ->getQuery()->getSQL();
  1360.         $productosunicos=$productosunicos->orderBy('p.orden', 'asc')
  1361.             ->groupby('p.maestro')
  1362.             ->getQuery()
  1363.         ->getSQL();
  1364.         dd($productospadres,$productosunicos);
  1365.         */
  1367.         if($material){
  1368.             $productospadres->andWhere("mat.nombre like '".$material->getNombre()."'");
  1369.             $productosunicos->andWhere("mat.nombre like '".$material->getNombre()."'");
  1370.         }
  1371.         if($tipologia){
  1372.             /*$productos->andWhere('p.tipologia = :tipologia')
  1373.                 ->setParameter('tipologia',$tipologia);*/
  1375.             $tipologiasel=explode(',',$tipologia);
  1376.             $busquedatipo='';
  1377.             foreach($tipologiasel as $key=>$tipo){
  1378.                 $busquedatipo.="p.tipologia like '".$tipo."'";
  1379.                 if($key<(count($tipologiasel)-1)){
  1380.                     $busquedatipo.=" OR ";
  1381.                 }
  1382.             }
  1383.             $productospadres->andWhere($busquedatipo);
  1384.             $productosunicos->andWhere($busquedatipo);
  1385.         }
  1388.         if($medida){
  1389.             $medidassele=explode(',',$medida);
  1390.             $medidascarga=$this->getDoctrine()->getRepository('App:Medidas')->createQueryBuilder('m')
  1391.                 ->select('m.id');
  1392.             $medidascarga->where($medidascarga->expr()->in('m.nombre',$medidassele));
  1394.             if($cat){
  1395.                 $medidascarga=$medidascarga->leftJoin('m.categoria','cat')
  1396.                     ->andWhere('cat.id = :catid')
  1397.                     ->setParameter('catid',$cat->getId());
  1398.             }
  1399.             $medidascarga= $medidascarga->groupBy('m.id')->getQuery()
  1400.                 ->getArrayResult();
  1402.             foreach ($medidascarga as $result) {
  1403.                 array_push($medidassel,$result['id']);
  1404.             }
  1408.             /*$productos->andWhere('p.medida = :medida')
  1409.                 ->setParameter('medida',$medida);*/
  1411.             /*$busquedasel='';
  1412.             foreach($medidassel as $key=>$me){
  1413.                 $busquedasel.="p.medida like '".$me."'";
  1414.                 if($key<(count($medidassel)-1)){
  1415.                     $busquedasel.=" OR ";
  1416.                 }
  1417.             }*/
  1418.             if(count($medidassel)>0) {
  1419.                 $productospadres->andWhere($productospadres->expr()->in('me.id', $medidassel));
  1420.                 $productosunicos->andWhere($productosunicos->expr()->in('me.id', $medidassel));
  1421.             }
  1423.         }
  1425.         $productospadres=$productospadres->orderBy('pa.orden', 'asc')
  1426.         ->groupby('pa.maestro')
  1427.             ->getQuery()
  1428.         ->getArrayResult();
  1430.         $productosunicos=$productosunicos->orderBy('p.orden', 'asc')
  1431.             ->groupby('p.maestro')
  1432.             ->getQuery()
  1433.             ->getArrayResult();
  1435.         $productos=[];
  1437.         foreach ($productospadres as $productopadre){
  1438.             $productos[$productopadre['plu']]=$productopadre;
  1439.         }
  1440.         foreach ($productosunicos as $productosunico){
  1441.             $productos[$productosunico['plu']]=$productosunico;
  1442.         }
  1447.         //$productos=array_merge($productospadres,$productosunicos);
  1448.         //$productos =array_map("unserialize", array_unique(array_map("serialize", $productos)));
  1451.         $maxprecio = $this->getDoctrine()->getRepository('App:Producto')->createQueryBuilder('p')
  1452.             ->select('Max(l.precio) as precio')
  1453.             ->leftJoin('p.listas','l')
  1454.             ->leftJoin('l.lista','li')
  1455.             ->leftJoin('p.medidas','me')
  1456.             ->leftJoin('p.material','mat')
  1457.             ->where('p.visible=1')
  1458.             ->andWhere('li.id = :l_id')
  1459.             ->setParameter('l_id',$convenio->getId());
  1461.          if($id_cat){
  1462.           $maxprecio->leftJoin('p.categorias','c')
  1463.              ->andWhere('c.id = '.$id_cat);
  1464.         }
  1465.         if ($id_sub){
  1466.             $maxprecio->leftJoin('p.subcategoria','sub')
  1467.                 ->andWhere('sub.id = '.$id_sub);
  1468.         }
  1470.         if(count($medidaparameter)>0){
  1471.             $maxprecio=$maxprecio->andWhere($maxprecio->expr()->in('me.id',$medidaparameter));
  1472.             //$maxprecio->andWhere("me.nombre like '".$medidaparameter->getNombre()."'");
  1473.         }
  1474.         if($material){
  1475.             $maxprecio->andWhere("mat.nombre like '".$material->getNombre()."'");
  1476.         }
  1477.         $maxprecio=$maxprecio->setMaxResults(1)
  1478.             ->getQuery()
  1479.             ->getOneOrNullResult();
  1481.         $minprecio = $this->getDoctrine()->getRepository('App:Producto')->createQueryBuilder('p')
  1482.             ->select('Min(l.precio) as precio')
  1483.             ->leftJoin('p.listas','l')
  1484.             ->leftJoin('l.lista','li')
  1485.             ->leftJoin('p.medidas','me')
  1486.             ->leftJoin('p.material','mat')
  1487.             ->where('p.visible=1')
  1488.             ->andWhere('li.id = :l_id')
  1489.             ->setParameter('l_id',$convenio->getId());
  1491.         if($id_cat){
  1492.             $minprecio->leftJoin('p.categorias','c')
  1493.                 ->andWhere('c.id = '.$id_cat);
  1494.         }
  1495.         if ($id_sub){
  1496.             $minprecio->leftJoin('p.subcategoria','sub')
  1497.                 ->andWhere('sub.id = '.$id_sub);
  1498.         }
  1499.         if(count($medidaparameter)>0){
  1500.             $minprecio=$minprecio->andWhere($minprecio->expr()->in('me.id',$medidaparameter));
  1501.             //$minprecio->andWhere("me.nombre like '".$medidaparameter->getNombre()."'");
  1502.         }
  1503.         if($material){
  1504.             $minprecio->andWhere("mat.nombre like '".$material->getNombre()."'");
  1505.         }
  1507.         $minprecio=$minprecio->setMaxResults(1)
  1508.             ->getQuery()
  1509.             ->getOneOrNullResult();
  1515.         $precios=[];
  1516.         foreach ($productos as $producto){
  1517.             $precios[]=$producto['precio'];
  1518.         }
  1519.         if($precios != null ){
  1520.             if(count($maxprecio)>0){
  1521.                 $preciomax=round($maxprecio['precio']);
  1522.             }else{
  1523.                 $preciomax=max($precios);
  1524.             }
  1526.             if(count($maxprecio)>0){
  1527.                 $preciomin=round($minprecio['precio']);
  1528.             }else{
  1529.                 $preciomin=min($precios);
  1530.             }
  1533.         }
  1534.         if($precios != null ){
  1535.             if(count($maxprecio)>0){
  1536.                 $preciomax_mobile=round($maxprecio['precio']);
  1537.             }else{
  1538.                 $preciomax_mobile=max($precios);
  1539.             }
  1541.             if(count($maxprecio)>0){
  1542.                 $preciomin_mobile=round($minprecio['precio']);
  1543.             }else{
  1544.                 $preciomin_mobile=min($precios);
  1545.             }
  1547.         }
  1549.         $hermanos = [];
  1550.         $medidas = [];
  1551.         $tipologias=[];
  1555.         foreach ($productos as $producto){
  1556.             $hermanos = $this->getDoctrine()->getRepository(Producto::class)->createQueryBuilder('p')
  1557.                 ->select('p.principal','p.plu', 'p.medida', 'p.nombre', 'p.tamanio', 'p.maestro','me.nombre as medida_real','me.id')
  1558.                 ->leftJoin('p.medidas','me')
  1559.                 ->where('me is not null')
  1560.                 ->andWhere('p.maestro = :maestro')
  1561.                 // ->andWhere('p.visible = 1')
  1562.                 ->setParameter('maestro',$producto['maestro'])
  1563.                 ->orderBy('p.medida','asc')
  1564.                 ->getQuery()
  1565.                 ->getResult();
  1567.             foreach ($hermanos as $hermano){
  1568.                 /* @var $producto Producto */  
  1569.        
  1570.                 $medidas[$hermano['medida_real']] = array("nombre" => $hermano['medida_real'], "checked"=>$this->isChecked($request,'medida_real',$hermano['medida_real']) );
  1571.                 if(count($medidassel)>0){
  1572.                     if(in_array($hermano['id'],$medidassel)) {
  1573.                         $medidas[$hermano['medida_real']] = array("nombre" => $hermano['medida_real'], "checked"=>true);
  1575.                     }
  1576.                 }
  1577.                 if($parameter_med){
  1578.                     if(count($medidaparameter)>0){
  1579.                          if(in_array($hermano['id'],$medidaparameter)) {
  1580.                              $medidas[$hermano['medida_real']] = array("nombre" => $hermano['medida_real'], "checked"=>true);
  1582.                          }
  1584.                     }
  1587.                 }
  1588.             }
  1589.         }
  1595.         foreach ($productos as $producto){
  1596.             /* @var $producto Producto */
  1597.             $tecs = explode('/', $producto['tecnologia']);
  1598.             foreach ($tecs as $tec){
  1599.                 $tec = trim($tec);
  1600.                 $tecnologias[$tec] = array("nombre"=>$tec, "checked"=>$this->isChecked($request,'tecnologia',$tec));
  1601.             }
  1602.             $tipologias[$producto['tipologia']] = array("nombre" => $producto['tipologia'], "checked"=>$this->isChecked($request,'tipologia',$producto['tipologia']));
  1603.             if(!array_key_exists($producto['medida'],$medidas))
  1604.                 $medidas[$producto['medida']] = array("nombre" => $producto['medida'], "checked"=>$this->isChecked($request,'medida',$producto['medida']));
  1606.             $adaptabilidades[$producto['adaptabilidad']] = array("nombre" => $producto['adaptabilidad'], "checked"=>$this->isChecked($request,'adaptabilidad',$producto['adaptabilidad']));
  1607.             $independencias[$producto['independencia']] = array("nombre" => $producto['independencia'], "checked"=>$this->isChecked($request,'independencia',$producto['independencia']));
  1608.             $gammas[$producto['gamma']] = array("nombre" => $producto['gamma'], "checked"=>$this->isChecked($request,'gamma',$producto['gamma']));
  1609.         }
  1611.         
  1612.         $filtros = array(
  1613.             "Medida" => $medidas,
  1614.             "Tipología" => $tipologias,
  1615.         );
  1619.         $idcategoria=null;
  1620.         if($categoria){
  1621.             $idcategoria=$categoria->getid();
  1622.         }
  1623.         $em = $this->getDoctrine()->getManager();
  1625.         // cod dcto solo al agregar al carrito
  1626.         $cods = $this->getDoctrine()->getRepository(CodigoDescuento::class)->createQueryBuilder('c')
  1627.                 ->select('p.nombre','p.plu')
  1628.                 ->leftJoin('c.productos','p')
  1629.                 ->where('c.incarrito = true')
  1630.                 ->andWhere('c.activo = true')
  1631.                 ->getQuery()
  1632.                 ->getResult();
  1635.         foreach($productos as $p){
  1636.             foreach($cods as $pc){
  1637.                 $pp=$p['plu'];
  1638.                 $codss=$pc['plu'];
  1639.                 if($pp == $codss){
  1640.                     $prod = $this->getDoctrine()->getRepository(Producto::class)->find(array('plu'=>$p['plu']));
  1641.                     $prod->setIncarrito(true);
  1642.                     $em->persist($prod);
  1643.                     $em->flush();
  1644.                 }else{
  1645.                     $prod = $this->getDoctrine()->getRepository(Producto::class)->find(array('plu'=>$p['plu']));
  1646.                     $prod->setIncarrito(false);
  1647.                     $em->persist($prod);
  1648.                     $em->flush();
  1649.                 }
  1650.             }
  1651.         }
  1655.         if($categoria && $categoria->getId() == 6){
  1658.             return $this->render('basic/promocionesIng.html.twig', [
  1659.                 'principal'=> $categoria,
  1660.                 'idprincipal'=> $idcategoria,
  1661.                 'productos' => $productos,
  1662.                 'subcategorias' => $subcategorias,
  1663.                 'titulo' => $titulo,
  1664.                 'plus' => $plus,
  1665.                 'cant' => count($productos),
  1666.             ]);
  1667.         }
  1669.         $referencia=null;
  1670.         if($id_sub != null){
  1671.             $referencia=$id_sub;
  1672.         }
  1674.         $idcategoria=null;
  1675.         if($categoria){
  1676.             $idcategoria=$categoria->getid();
  1677.         }
  1679.         return $this->render('basic/buscador.html.twig', [  
  1680.             'principal'=> $categoria,
  1681.             'idprincipal'=> $idcategoria,
  1682.             'productos' => $productos,
  1683.             'preciomaximo' => $preciomax ,
  1684.             'preciominimo' => $preciomin,   
  1685.             'preciomaximo_mobile' => $preciomax_mobile,
  1686.             'preciominimo_mobile' => $preciomin_mobile,         
  1687.             'subcategorias' => $subcategorias,
  1688.             'titulo' => $titulo,
  1689.             'plus' => $plus,
  1690.             'cant' => count($productos),
  1691.             'filtros' => $filtros,
  1692.             'idsubcategoria' => $id_sub,
  1693.             'referencia'=>$referencia,
  1694.             'subcategoria'=>$subcategoria
  1696.         ]);
  1697.     }
  1699.     private function isChecked(Request $request,$tipo,$valor){
  1700.         $qi = $this->qi;
  1701.         $tipo = $qi->slugify($tipo);
  1703.         $campos = explode(',',$request->get($tipo));
  1706.         // dd('request in isChecked ',$tipo,$campos,$request,in_array($valor, $campos));
  1708.         return in_array($valor, $campos);
  1709.     }
  1711.     /**
  1712.      * @param Request $request
  1713.      * @param $tipos
  1714.      * @param $columnas
  1715.      * @param $query
  1716.      * @return Query
  1717.      */
  1718.     private function getQueryFilter(Request $request,$tipos, $columnas, $query){
  1719.         $qi = $this->qi;
  1720.         $keys = [];
  1721.         $i = 0;
  1722.         foreach ($tipos as $key=>$val){
  1723.             $tipo = $qi->slugify($key);
  1724.             if($request->get($tipo)){
  1725.                 $campos = explode(',',$request->get($tipo));
  1726.                 $cad = [];
  1727.                 if(count($campos) > 0){
  1728.                     foreach ($campos as $j=>$campo){
  1729.                         array_push($cad,'p.'.$columnas[$i].' like :query_'.$columnas[$i].'_'.$j.' ');
  1730.                         $query->setParameter('query_'.$columnas[$i].'_'.$j,'%'.$campo.'%');
  1731.                     }
  1732.                     $query->andWhere(implode($cad,' or '));
  1733.                 }
  1734.             }
  1735.             $i++;
  1736.         }
  1737.         return $query;
  1738.     }
  1740.     /**
  1741.      * @Route("/producto/{id}/{tiendaId}", name="producto_old")
  1742.      */
  1743.     public function producto_old(Request $request, $id,$tiendaId)
  1744.     {
  1745.         $tienda = $this->getDoctrine()->getRepository('App:Tienda')->find($tiendaId);
  1746.         $productos = $this->getDoctrine()->getManager()->createQueryBuilder()
  1747.             ->from('App:Inventario','i')
  1748.             ->select('i')
  1749.             ->leftJoin('i.producto','p')
  1750.             ->addSelect('p')
  1751.             ->leftJoin('p.categorias','c')
  1752.             ->addSelect('c')
  1753.             ->where('i.tienda = :tienda')
  1754.             ->addSelect(
  1755.                 'CASE WHEN p.nombreComercial is not null and p.nombreComercial <> \'\' THEN p.nombreComercial ELSE p.nombre END AS nombrePublico')
  1756.             ->andWhere('i.cantidad > 0')
  1757.             ->andWhere('p.plu = :id')
  1758.             ->setParameter('tienda',$tienda)
  1759.             ->setParameter('id',$id)
  1760.             ->getQuery()
  1761.             ->getArrayResult();
  1762.         return $this->render('basic/producto.html.twig', [
  1763.             'producto' => $productos[0]
  1764.         ]);
  1765.     }
  1769.     /**
  1770.      * @Route("/producto/{id}", name="producto")
  1771.      */
  1772.     public function producto(Request $request, $id)
  1773.     {
  1774.         $tienda = $this->qi->getTienda();
  1775.         if(!$tienda)
  1776.             return $this->redirectToRoute('misdirecciones');
  1777.         $producto = $this->getDoctrine()->getRepository('App:Producto')->find($id);
  1778.         $inv = $this->getDoctrine()->getRepository('App:Inventario')->findOneBy(array('producto'=>$producto,'tienda'=>$tienda));
  1779.         $cant = 0;
  1780.         if($inv)
  1781.             $cant = $inv->getCantidad();
  1782.         //dd($tienda,$inv);
  1783.         return $this->render('basic/producto.html.twig', [
  1784.             'producto' => $producto,
  1785.             'cantidad' => $cant
  1786.         ]);
  1787.     }
  1789.     /**
  1790.      * @Route("/add-to-carrito/romance/add-to-carrito", name="add-to-carrito")
  1791.      */
  1792.     public function addtocarrito(Request $request)
  1793.     {
  1794.         $body = json_decode($request->getContent()); 
  1795.         $mensaje=array('ok' => false, 'mensaje' => "Ha ocurrido un error");
  1796.         // if($body->cantidad > 0){
  1797.             if($this->qi->addCantToCar($body->producto,$body->cantidad,$body->wish)) {
  1798.                 $mensaje = array('ok' => true, 'mensaje' => "Agregado al carrito ",'carrito'=>count($this->qi->getCarrito()));
  1799.                 if ($body->wish) {
  1800.                     $mensaje = array('ok' => true, 'mensaje' => "Agregado al wish list");
  1801.                 }
  1802.             }
  1803.         // }else{
  1804.         //     $this->qi->deleteItemFromCar($body->producto,$body->wish);
  1805.         //     $mensaje = array('ok' => true, 'mensaje' => "Eliminado del carrito");            
  1806.         // }       
  1808.         $response = new Response();
  1809.         $response->setContent(json_encode($mensaje));
  1810.         $response->headers->set('Content-Type', 'application/json');
  1811.         // dd($response);
  1812.         return $response;
  1813.     }
  1815.     /**
  1816.      * @Route("/eliminar-carro/{id}", name="eliminar-carro")
  1817.      */
  1818.     public function eliminarDeCarro(Request $request,$id)
  1819.     {
  1821.         $this->qi->deleteItemFromCar($id,"");
  1822.         return $this->redirectToRoute('carrito');
  1823.     }
  1825.     /**
  1826.      * @Route("/cambiar-cantidad/{id}/{cantidad}", name="cambiar-cantidad")
  1827.      */
  1828.     public function cambiarCantidad(Request $request,$id,$cantidad)
  1829.     {
  1831.         if($cantidad > 0) {
  1832.             $this->qi->addItemToCar($id, $cantidad, "");
  1833.         }
  1834.         else{
  1835.             $this->qi->deleteItemFromCar($id,  "");
  1836.         }
  1837.         return $this->redirectToRoute('carrito');
  1838.     }
  1840.     // /**
  1841.     //  * @Route("/carrito/romance/carrito", name="carrito")
  1842.     //  */
  1843.     // public function carrito(Request $request)
  1844.     // {
  1845.     //     $session = $request->getSession();
  1846.     //     $mostre_en_carrito = $session->get('cierre_carrito','0') == '1';
  1847.     //     $session->set('cierre_carrito','1');
  1848.     //     $ok = true;
  1850.     //     if($request->get('ok') != null ){
  1851.     //         $ok = $request->get('ok');
  1852.     //     }
  1853.     //     if(!$this->qi->getDireccion()){
  1854.     //         $this->addFlash(
  1855.     //             'warning',
  1856.     //             'Debes seleccionar una dirección antes de continuar'
  1857.     //         );
  1858.     //         return $this->redirectToRoute('misdirecciones');
  1859.     //     }
  1860.     //     /* @var $user Usuario */
  1861.     //     $user = $this->getUser();
  1862.     //     if(!$user->getNombre() || !$user->getApellido() || !$user->getCelular() || !$user->getDocumento())
  1863.     //     {
  1864.     //         $this->addFlash(
  1865.     //             'warning',
  1866.     //             'Debes actualizar tus datos para continuar con la compra.'
  1867.     //         );
  1868.     //         return $this->redirectToRoute('perfil');
  1869.     //     }
  1870.     //     if(!$this->qi->getTienda()){
  1872.     //         $tienda = $this->qi->getTiendaFromCoordinates($this->qi->getDireccion());
  1873.     //         $this->qi->setTienda($tienda);
  1875.     //         if(!$tienda){
  1876.     //             $this->addFlash(
  1877.     //                 'warning',
  1878.     //                 'La dirección seleccionada no tiene cobertura en este momento'
  1879.     //             );
  1880.     //             return $this->redirectToRoute('misdirecciones');
  1881.     //         }
  1882.     //     }
  1883.     //     $noDisp = $this->qi->validarCarrito();
  1885.     //     if(count($noDisp) ){
  1886.     //         $this->addFlash(
  1887.     //             'warning',
  1888.     //             'Algunos productos de tu carrito han sido eliminados ya que en la tienda actual no hay disponibilidad'
  1889.     //         );
  1890.     //     }
  1891.     //     $productos = $this->getDoctrine()->getRepository('App:Producto')->
  1892.     //     findBy(array('visible'=>true),array('orden'=>'desc'),7, rand(1,1500));
  1893.     //     return $this->render('basic/carrito.html.twig', [
  1894.     //         'productos' => $productos,
  1895.     //         'ok'=>$ok,
  1896.     //         'mostre_en_carrito' => $mostre_en_carrito
  1897.     //     ]);
  1898.     // }
  1900.     /**
  1901.      * @Route("/resumen_pedido/{id}", name="resumen_pedido")
  1902.      */
  1903.     public function resumenPedido(Request $request,$id)
  1904.     {
  1905.         /* @var Compra $compra*/
  1906.         $compra = $this->getDoctrine()->getRepository(Compra::class)->find($id);
  1907.         $productos = $compra->getProductosObj();
  1909.         return $this->render('basic/resumen.html.twig', [
  1910.             'productos' => $productos,
  1911.             'compra' => $compra
  1912.         ]);
  1913.     }
  1915.     /**
  1916.      * @Route("/pedido_respuesta/romance/pedido_respuesta", name="pedido_respuesta")
  1917.      */
  1918.     public function pedido_respuesta(Request $request)
  1919.     {
  1920.         $ok = true;
  1922.         if($request->get('ok') != null ){
  1923.             $ok = $request->get('ok');
  1924.         }
  1925.         if(!$this->qi->getDireccion()){
  1926.             return $this->redirectToRoute('misdirecciones');
  1927.         }
  1928.         if(!$this->qi->getTienda()){
  1929.             return $this->redirectToRoute('tienda');
  1930.         }
  1931.         return $this->render('basic/pedido_respuesta.html.twig', [
  1932.             'ok'=>$ok
  1933.         ]);
  1934.     }
  1936.     // /**
  1937.     //  * @Route("/mapa_tiendas/romance/mapa_tiendas", name="mapaTiendas")
  1938.     //  */
  1939.     // public function mapaTiendas(Request $request)
  1940.     // {
  1942.     //     $tiendas = $this->getDoctrine()->getRepository(Tienda::class)->findBy(array('visible'=>true));
  1944.     //     return $this->render('basic/mapaTiendas.html.twig', [
  1945.     //         'tiendas' => $tiendas,
  1946.     //         'idprincipal' => $idprincipal=null
  1947.     //     ]);
  1948.     // }
  1950.     /**
  1951.      * @Route("/direccion/romance/direccion", name="direccion")
  1952.      */
  1953.     public function direccion(Request $request)
  1954.     {
  1955.         $productos = $this->getDoctrine()->getRepository('App:Producto')->
  1956.         findBy(array('visible'=>true),array('orden'=>'desc'),7, rand(1,1500));
  1957.         return $this->render('basic/direccion.html.twig', [
  1958.             'productos' => $productos,
  1959.             'idprincipal' => $idprincipal=null
  1960.         ]);
  1961.     }
  1963.     /**
  1964.      * @Route("/confirmacion/romance/confirmacion", name="confirmacion")
  1965.      */
  1966.     public function confirmation(Request $request)
  1967.     {
  1969.         $respuesta = $request->get('obj');
  1970.         $compra = $this->getDoctrine()->getRepository(Compra::class)->find($respuesta["compra"]["id"]);
  1972.         $productos = $this->qi->getCarrito();
  1973.         $this->qi->clearCar("");
  1976.         return $this->render('basic/pedido_respuesta.html.twig', [
  1977.             'productos' => $productos,
  1978.             'compra' => $compra,
  1979.             'ok' => $request->get("ok"),
  1980.             'idprincipal' => $idprincipal=null
  1982.         ]);
  1983.     }
  1985.     /**
  1986.      * @Route("/ingresar/romance/ingresar", name="ingresar")
  1987.      */
  1988.     public function ingresar(Request $request)
  1989.     {
  1990.         $errores = [];
  1991.         $last_username = '';
  1992.         /*if($request->isMethod('POST')){
  1993.             $datos = $request->request->all();
  1994.             $email = strtolower($datos['_username'] );
  1995.             $last_username = $email;
  1996.             $pass = strtolower($datos['_password'] );
  1997.             try {
  1998.                 $serviceAccount = ServiceAccount::fromJsonFile(__DIR__.'/../../miveci-firebase-adminsdk-pteyb-91be53dc7d.json');
  1999.                 $firebase = (new Factory())
  2000.                     ->withServiceAccount($serviceAccount)
  2001.                     ->create();
  2002.                 $auth = $firebase->getAuth();
  2003.                 $fbuser = $auth->getUserByEmail($email);
  2004.                 $user = $this->userManager->findUserBy(array('email'=>$email));
  2006.                 $token = new UsernamePasswordToken($user, null, 'main', $user->getRoles());
  2007.                 $this->get('security.token_storage')->setToken($token);
  2008.                 $this->get('session')->set('_security_main', serialize($token));
  2009.                 $event = new InteractiveLoginEvent($request, $token);
  2010.                 //$this->get("event_dispatcher")->dispatch("security.interactive_login", $event);
  2011.                 $this->eventDispatcher->dispatch("security.interactive_login", $event);
  2012.                 if ($this->get('security.context')->isGranted('ROLE_POS_ADMIN')) {
  2013.                     return $this->redirectToRoute('easyadmin');
  2014.                 }else{
  2015.                     return $this->redirectToRoute('homepage');
  2016.                 }
  2018.             } catch (Firebase\Exception\AuthException $e) {
  2019.                 array_push($errores, $e->getMessage());
  2020.                 //echo($e->getMessage());
  2021.                 //echo(dump($e));
  2022.                 //exit();
  2023.             } catch (Firebase\Exception\FirebaseException $e) {
  2024.                 array_push($errores, $e->getMessage());
  2025.             }
  2027.         }
  2028.         return $this->render('user/login.html.twig', [
  2029.             'errores' => $errores,
  2030.             'last_username' => $last_username,
  2031.             'idprincipal' => $idprincipal=null
  2032.         ]);*/
  2033.     }
  2035.     /**
  2036.      * @Route("/olvide/romance/olvide", name="olvide")
  2037.      */
  2038.     public function olvide(Request $request)
  2039.     {
  2040.         return $this->render('user/olvide.html.twig', [
  2041.             'idprincipal' => $idprincipal=null
  2042.         ]);
  2043.     }
  2045.     /**
  2046.      * @Route("/crear-cuenta/romance/crear-cuenta", name="crear_cuenta")
  2047.      */
  2048.     public function crearCuenta(Request $request)
  2049.     {
  2050.         $errores = [];
  2051.         if($request->isMethod('POST')){
  2052.             $datos = $request->request->all();
  2053.             $properties = [
  2054.                 'displayName' => $datos['nombre'] . " " . $datos['apellido'] ,
  2055.                 'email' => strtolower($datos['email'] ),
  2056.                 'emailverified' => true
  2057.             ];
  2059.         }
  2060.         return $this->render('user/registro.html.twig', [
  2061.             'errores' => $errores,
  2062.             'idprincipal' => $idprincipal=null
  2063.         ]);
  2064.     }
  2066.     /**
  2067.      * @Route("/load/romance/load", name="load")
  2068.      */
  2069.     public function load(Request $request)
  2070.     {
  2072.         /*
  2073.         $prods = $this->getDoctrine()->getRepository(Inventario::class)->findAll();
  2075.         foreach ($prods as $inv){
  2076.             $this->qi->saveFire($inv);
  2077.         }
  2078.     */
  2079.         // dd(12);
  2080.         //return $this->redirectToRoute('easyadmin');
  2081.         //$this->denyAccessUnlessGranted('IS_AUTHENTICATED_FULLY');
  2082.     }
  2084.     /**
  2085.      * @Route("/preguntas_frecuentes/romance/preguntas_frecuentes", name="preguntas_frecuentes")
  2086.      */
  2087.     public function preguntasFrecuentes(Request $request)
  2088.     {
  2089.         $preguntas = $this->getDoctrine()->getRepository(Faq::class)->findBy(array("visible"=>true),array("orden"=>"asc"));
  2090.         return $this->render('basic/preguntas.html.twig', [
  2091.             "preguntas" => $preguntas,
  2092.             'idprincipal' => $idprincipal=null
  2093.         ]);
  2094.     }
  2097.     /**
  2098.      * @Route("/privacidad/romance/privacidad", name="privacidad")
  2099.      */
  2100.     public function privacidad(Request $request)
  2101.     {
  2102.         return $this->render('basic/politica.html.twig', [
  2103.             'llave'=>'politica_privacidad',
  2104.             'titulo'=> 'Políticas de privacidad',
  2105.             'idprincipal' => $idprincipal=null
  2106.         ]);
  2107.     }
  2109.     /**
  2110.      * @Route("/terminos/romance/terminos", name="terminos")
  2111.      */
  2112.     public function terminos(Request $request)
  2113.     {
  2114.         return $this->render('basic/politica.html.twig', [
  2115.             'llave'=>'terminos',
  2116.             'titulo'=> 'Términos y condiciones',
  2117.             'idprincipal' => $idprincipal=null
  2118.         ]);
  2119.     }
  2121.     /**
  2122.      * @Route("/politica/romance/politica", name="politica")
  2123.      */
  2124.     public function politica(Request $request)
  2125.     {
  2126.         return $this->render('basic/politica.html.twig', [
  2127.             'llave'=>'politica_promocion',
  2128.             'titulo'=> 'Políticas de promoción',
  2129.             'idprincipal' => $idprincipal=null
  2130.         ]);
  2131.     }
  2134.     /**
  2135.      * @Route("/politica_promocion/romance/politica_promocion", name="politica_promocion")
  2136.      */
  2137.     public function politicaPromocion(Request $request)
  2138.     {
  2139.         $politicas = $this->getDoctrine()->getRepository(PoliticaPromocion::class)->findBy(array("visible"=>true),array("orden"=>"asc"));
  2140.         return $this->render('basic/privacidad.html.twig', [
  2141.             "politicas" => $politicas,
  2142.             'llave'=>'politica_promocion',
  2143.             'titulo'=> 'Políticas de promoción',
  2144.             'idprincipal' => $idprincipal=null
  2145.         ]);
  2146.     }
  2148.     /**
  2149.      * @Route("/politica_entrega/romance/politica_entrega", name="politica_entrega")
  2150.      */
  2151.     public function politicaEntrega(Request $request)
  2152.     {
  2154.         return $this->render('basic/politica.html.twig', [
  2155.             'llave'=>'politica_entrega',
  2156.             'titulo'=> 'Política de entrega y devolución',
  2157.             'idprincipal' => $idprincipal=null
  2158.         ]);
  2159.     }
  2161.     /**
  2162.      * @Route("/ajax-cart/romance/ajax-cart", name="ajax-cart")
  2163.      */
  2164.     public function ajaxCart(Request $request)
  2165.     {
  2166.         return $this->render('cart/ajaxcart.html.twig', [
  2167.             'idprincipal' => $idprincipal=null
  2168.         ]);
  2169.     }
  2171.     /**
  2172.      * @Method({"GET"})
  2173.      * @Route("/api/clientify/create/{id}", name="crear_usuario_clientify")
  2174.      */
  2175.     public function crearUsuarioClientify(Request $request,$id)
  2176.     {
  2177.         $usuario = $this->getDoctrine()->getRepository('App:Usuario')->find($id);
  2178.         $this->clientify->CrearContacto($usuario);
  2179.         // dd($usuario);
  2181.     }
  2183.     /**
  2184.      * @Method({"POST"})
  2185.      * @Route("/api/auth/register", name="crear_actualizar_usuario")
  2186.      */
  2187.     public function crearActualizarUsuario(Request $request)
  2188.     {
  2189.         $logged = $this->getUser();
  2190.         $um = $this->userManager;
  2191.         $body = json_decode($request->getContent());
  2192.         // dd($body);
  2193.         /* @var $user Usuario */
  2194.         $user = $um->findUserBy(array('uid'=>$body->uid));
  2195.         if(!$user){
  2196.             $user = $um->findUserBy(array('email'=>$body->email));
  2197.         }
  2198.         if(!$user){
  2199.             $user = $um->createUser();
  2200.             $user->setUid($body->uid);
  2201.             $user->setEmail($body->email);
  2202.             $user->setUsername($body->email);
  2203.             $user->setCelular($body->telefono);
  2204.             $user->setUsernameCanonical($body->email);
  2205.             $user->setProviderData(json_encode($body->providerData));
  2206.             $user->setEnabled(true);
  2207.             $user->setPassword('redes123');
  2208.             $user->setCreatedAt(new \DateTime());
  2210.             // enviar correo de bienvenida
  2211.             // $mensaje = str_replace('%nombre%', '', $this->qi->getTextoBig('mail-bienvenida'));
  2212.             $mensaje = $this->renderView('mailing/agradecimiento-registro.html.twig', array(
  2213.                 // 'nombre'=>$user->getNombre(),
  2214.                 'email'=>$user->getEmail(),
  2215.                 // 'telefono'=>$user->getTelefono(),
  2216.                 // 'mensaje'=>$user->getMensaje(),
  2217.             ));
  2219.             $this->qi->sendMail($this->qi->getTexto('asunto_bienvenida'), $body->email,$mensaje);
  2221.             if(property_exists($body,'nombre')){
  2222.                 $user->setNombre($body->nombre);
  2223.             }
  2224.             if(property_exists($body,'apellido')){
  2225.                 $user->setApellido($body->apellido);
  2226.             }
  2227.             if(property_exists($body,'telefono')){
  2228.                 $user->setCelular($body->telefono);
  2229.             }
  2230.             if(property_exists($body,'convenio')){
  2231.                 $convenio = $this->getDoctrine()->getRepository('App:ListaPrecios')->findOneBy(array('codigo'=>$body->convenio));
  2232.                 if($convenio)
  2233.                     $user->setConvenio($convenio);
  2234.             }
  2235.             if(property_exists($body,'uid')){
  2236.                 $user->setUid($body->uid);
  2237.             }
  2239.         }
  2241.         $em = $this->getDoctrine()->getManager();
  2242.         $em->persist($user);
  2243.         $em->flush();
  2244.         $um->updateUser($user);
  2246.         // dd($user);
  2248.         // clientify
  2249.         $this->clientify->CrearContacto($user);
  2251.         $token = new UsernamePasswordToken($user, null, 'main', $user->getRoles());
  2252.         $this->get('security.token_storage')->setToken($token);
  2253.         $this->get('session')->set('_security_main', serialize($token));
  2254.         $event = new InteractiveLoginEvent($request, $token);
  2255.         //$this->get("event_dispatcher")->dispatch("security.interactive_login", $event);
  2256.         $this->eventDispatcher->dispatch("security.interactive_login", $event);
  2258.         if ($this->authorization->isGranted('ROLE_POS_ADMIN')) {
  2259.             $resultado= array("ok"=>true,'obj'=>$user,'url'=> $this->generateUrl('homepage'));
  2260.         }else{
  2261.             if($this->qi->carritoLength() > 0){
  2262.                 if($this->qi->getDireccion())
  2263.                     $ruta = $this->generateUrl('carrito');
  2264.                 else
  2265.                     $ruta = $this->generateUrl('misdirecciones');
  2266.             }
  2267.             else
  2268.                 $ruta = $this->generateUrl('homepage');
  2269.             $resultado= array("ok"=>true,'obj'=>$user,'url'=> $ruta);
  2270.         }
  2272.         $prlog= false;
  2273.         if($logged){
  2274.             $prlog = true;
  2275.         }
  2276.         return new Response(json_encode(array("preloged"=>$prlog,"id"=>$user->getId())));
  2278.     }
  2280.     /**
  2281.      * @Method({"POST"})
  2282.      * @Route("/api/direccion", name="crear_direccion")
  2283.      */
  2284.     public function crearDireccion(Request $request)
  2285.     {
  2286.         $body = json_decode($request->getContent());
  2287.         //dd($body);
  2288.         $qi = $this->qi;
  2289.         $user = $this->getDoctrine()->getRepository(Usuario::class)->findOneBy(array('uid'=>$body->uid));
  2290.         $ciudad = $this->getDoctrine()->getRepository(Ciudad::class)->find($body->ciudad->id);
  2291.         $news = new Direccion();
  2292.         $news->setUsuario($user);
  2293.         $news->setNombre($body->nombre);
  2294.         $news->setCiudad($ciudad);
  2295.         $news->setDireccion($body->direccion." ".$body->adicional);
  2296.         $news->setLat($body->lat);
  2297.         $news->setLng($body->lng);
  2298.         $news->setUid($body->uid);
  2299.         $news->setPredeterminada($body->predeterminada);
  2300.         $em = $this->getDoctrine()->getManager();
  2301.         $em->persist($news);
  2302.         $em->flush();
  2303.         $qi->saveFire($news);
  2304.         $resultado= array("ok"=>true,'obj'=>$news);
  2306.         $encoders = array(new XmlEncoder(), new JsonEncoder());
  2307.         $normalizer = new ObjectNormalizer();
  2308.         $normalizer->setCircularReferenceLimit(1);
  2309.         // Add Circular reference handler
  2310.         $normalizer->setCircularReferenceHandler(function ($object) {
  2311.             return $object->getId();
  2312.         });
  2313.         $normalizers = array($normalizer);
  2314.         $serializer = new Serializer($normalizers, $encoders);
  2315.         $json = $serializer->serialize($resultado,'json');
  2316.         return new Response($json);
  2318.     }
  2320.     /**
  2321.      * @Method({"POST"})
  2322.      * @Route("/api/historial/{uid}", name="historial")
  2323.      */
  2324.     public function historial(Request $request,$uid)
  2325.     {
  2326.         //$body = json_decode($request->getContent());
  2327.        // dd($uid);
  2328.         $qi = $this->qi;
  2329.         $user = $this->getDoctrine()->getRepository(Usuario::class)->findOneBy(array('uid'=>$uid));
  2330.         $compras = $this->getDoctrine()->getManager()->createQueryBuilder()
  2331.             ->from('App:Compra','c')
  2332.             ->addSelect('c')
  2333.             ->leftJoin('c.tienda','t')
  2334.             ->addSelect('t')
  2335.             ->leftJoin('c.direccion','d')
  2336.             ->addSelect('d')
  2337.             ->where('c.usuario = :usuario')
  2338.             ->setParameter('usuario',$user)
  2339.             ->getQuery()
  2340.             ->getArrayResult();
  2341.         //dd($compras);
  2342.         $resultado= array("ok"=>true,'historial'=>$compras);
  2344.         $encoders = array(new XmlEncoder(), new JsonEncoder());
  2345.         $normalizer = new ObjectNormalizer();
  2346.         $normalizer->setCircularReferenceLimit(1);
  2347.         // Add Circular reference handler
  2348.         $normalizer->setCircularReferenceHandler(function ($object) {
  2349.             return $object->getId();
  2350.         });
  2351.         $normalizers = array($normalizer);
  2352.         $serializer = new Serializer($normalizers, $encoders);
  2353.         $json = $serializer->serialize($resultado,'json');
  2354.         return new Response($json);
  2356.     }
  2358.     function crearPedido($user,$direccion,$metodo,$tienda,$costo_domicilio,$comentarios,$peticion,$paga_con,$carrito,$canal){
  2361.         $qi = $this->qi;
  2362.         $em = $this->getDoctrine()->getManager();
  2363.         $estado = $this->getDoctrine()->getRepository(EstadoPedido::class)->findOneBy(array('ref' => 'creado'));
  2364.         $subtotal = 0;
  2365.         $total = 0;
  2366.         $news = new Compra();
  2367.         $news->setCreatedAt(new \DateTime());
  2368.         $news->setDireccion($direccion);
  2369.         $news->setUsuario($user);
  2370.         $news->setFechaRealProcesamiento(new \DateTime());
  2371.         $news->setEstado($estado);
  2372.         $news->setEstadoProcesamiento("nuevo");
  2373.         $news->setCostoDomicilio($costo_domicilio);
  2374.         $news->setComentarios($comentarios);
  2375.         $news->setBody(json_encode($peticion));
  2376.         $news->setCanal($canal);
  2377.         $news->setMetodo($metodo);
  2378.         $news->setPagaCon($paga_con);
  2379.         $news->setSubtotal($subtotal);
  2380.         $news->setTienda($tienda);
  2382.         $total = $subtotal + $costo_domicilio;
  2383.         $news->setTotal($total);
  2384.         $em->persist($news);
  2385.         $em->flush();
  2386.         foreach ($carrito as $item) {
  2387.             if ($canal == 'app') {
  2388.                 $product_id = $item->product_id;
  2389.                 $count = $item->count;
  2390.             } else {
  2391.                 $product_id = $item["product_id"];
  2392.                 $count = $item["count"];
  2393.             }
  2394.             $prod = $this->getDoctrine()->getRepository(Producto::class)->findOneBy(array('plu' => $product_id));
  2395.             if($this->qi->getSetting('pedido_multitienda') != '1')
  2396.                 $inv = $this->getDoctrine()->getRepository(Inventario::class)->findOneBy(array('producto' => $prod, 'tienda' => $tienda));
  2397.             else
  2398.                 $inv = $this->getDoctrine()->getRepository(Inventario::class)->findOneBy(array('producto' => $prod));
  2399.             if ($inv) {
  2400.                 $subtotal = $subtotal + $inv->getPrecio() * $count;
  2401.                 $newci = new CompraItem();
  2402.                 $newci->setProducto($prod);
  2403.                 $newci->setPrecio($inv->getPrecio() * $count);
  2404.                 $newci->setCantidad($count);
  2405.                 $newci->setCompra($news);
  2406.                 $newci->setCosto($inv->getPrecio());
  2407.                 $em->persist($newci);
  2408.                 $em->flush();
  2409.                 $qi->saveFire($newci);
  2410.             } else {
  2412.             }
  2414.         }
  2415.         $news->setSubtotal($subtotal);
  2416.         $total = $subtotal + $costo_domicilio;
  2417.         $news->setTotal($total);
  2418.         $em->persist($news);
  2419.         $em->flush();
  2420.         $qi->saveFire($news);
  2421.         $obj = array('tienda' => $tienda,
  2422.             'compra' => array('id' => $news->getId(),
  2423.                 'total' => $news->getTotal(),
  2424.                 'estado' => $news->getEstadoProcesamiento(),
  2425.                 'subtotal' => $news->getSubtotal(),
  2426.                 'costoDomicilio' => $news->getCostoDomicilio(),
  2427.             )
  2428.         );
  2429.         $resultado = array("ok" => true, 'obj' => $obj);
  2431.         $qi->updateListenerTienda($tienda);
  2435.         return $resultado;
  2436.     }
  2438.     /**
  2439.      * @Route("/import/romance/import", name="import")
  2440.      */
  2441.     public function import(Request $request)
  2442.     {
  2443.         /*$categorias = $this->getDoctrine()->getRepository('App:Producto')->findAll();
  2444.         foreach ($categorias as $categoria){
  2445.             $this->qi->saveFire($categoria);
  2446.         }*/
  2447.         /*
  2448.         $em = $this->getDoctrine()->getManager();
  2449.         $data = json_decode($request->getContent(), true);
  2451.         foreach ($data as $producto){
  2452.             $producto_in = new Producto();
  2453.             $producto_in->setPlu($producto['sku']);
  2454.             $producto_in->setNombre($producto['nombreEs']);
  2455.             $producto_in->setImagen($producto['imagen']);
  2456.             $producto_in->setOrden(1);
  2457.             $producto_in->setPrecio(0);
  2458.             $producto_in->setVisible(true);
  2459.             if(is_numeric($producto['id'])){
  2460.                 $categoria = $this->getDoctrine()->getRepository('App:Categoria')->find($producto['id']);
  2461.                 $producto_in->addCategoria($categoria);
  2462.             }
  2463.             $em->persist($producto_in);
  2464.         }
  2465.         $em->flush();
  2466.         die();
  2468.         foreach ($data as $categoria){
  2469.             $categoria_in = new Categoria();
  2470.             $categoria_in->setNombre($categoria['nombre']);
  2471.             $categoria_in->setImagen($categoria['imagen']);
  2472.             $categoria_in->setVisible(true);
  2473.             $categoria_in->setOrden($categoria['orden']);
  2474.             $em->persist($categoria_in);
  2475.         }
  2476.         $em->flush();
  2477.         die();
  2478.         return $this->redirectToRoute('easyadmin');
  2479.         */
  2480.         //$this->denyAccessUnlessGranted('IS_AUTHENTICATED_FULLY');
  2481.     }
  2485.     /**
  2486.      * @Route("/resetting/iridian", name="reset-iridian")
  2487.      */
  2488.     public function sendEmailAction(Request $request)
  2489.     {
  2490.         $username = $request->request->get('username');
  2491.         $user = $this->userManager->findUserByUsernameOrEmail($username);
  2492.         $event = new GetResponseNullableUserEvent($user, $request);
  2493.         if (null !== $event->getResponse()) {
  2494.             return $event->getResponse();
  2495.         }
  2496.         if (null !== $user && !$user->isPasswordRequestNonExpired($this->retryTtl)) {
  2497.             $event = new GetResponseUserEvent($user, $request);
  2498.             if (null !== $event->getResponse()) {
  2499.                 return $event->getResponse();
  2500.             }
  2501.             if (null === $user->getConfirmationToken()) {
  2502.                 $user->setConfirmationToken($this->tokenGenerator->generateToken());
  2503.             }
  2504.             $event = new GetResponseUserEvent($user, $request);
  2505.             if (null !== $event->getResponse()) {
  2506.                 return $event->getResponse();
  2507.             }
  2508.             $this->sendResettingEmailMessage($user);
  2509.             $user->setPasswordRequestedAt(new \DateTime());
  2510.             $this->userManager->updateUser($user);
  2511.             $event = new GetResponseUserEvent($user, $request);
  2512.             if (null !== $event->getResponse()) {
  2513.                 return $event->getResponse();
  2514.             }
  2515.         }
  2517.         return new RedirectResponse($this->generateUrl('fos_user_resetting_check_email', array('username' => $username)));
  2518.     }
  2520.     public function sendResettingEmailMessage(UserInterface $user)
  2521.     {
  2523.         $url = $this->generateUrl('fos_user_resetting_reset', array('token' => $user->getConfirmationToken()), UrlGeneratorInterface::ABSOLUTE_URL);
  2525.         $mensaje= str_replace('%link%','<a href="'.$url.'">link</a>',$this->qi->getTextoBig('mail_contrasena'));
  2526.         //$this->qi->sendMailPHP($this->qi->getTexto('asunto_mail_resetting'),$user->getEmail(),$mensaje) ;
  2527.     }
  2531.     /**
  2532.      * @Route("/fullreload", name="fullreload")
  2533.      */
  2534.     /*
  2535.     public function fullreload(Request $request)
  2536.     {
  2537.         $productos = $this->getDoctrine()->getRepository('App:Producto')
  2538.             ->createQueryBuilder('p')
  2539.             ->select('p','c as cats')
  2540.             ->leftJoin('p.categorias','c')
  2541.             ->where('c.id is not null')
  2542.             //->setMaxResults(2)
  2543.             ->getQuery()
  2544.             ->getArrayResult();
  2545.         $prods = array();
  2546.         foreach ($productos as $producto){
  2547.             $cat = $producto['categorias'][0]['id'];
  2548.             $producto['categorias'] = array($cat);
  2549.             $prods[$producto['plu']] = $producto;
  2550.         }
  2551.         $this->qi->saveMultiFire('Producto',$prods);
  2552.         dd($prods);
  2553.         return $this->render('basic/template.html.twig', [
  2554.         ]);
  2555.     }
  2556.     */
  2561.     /**
  2562.      * @Route("/load", name="load")
  2563.      */
  2564.     /*
  2565.     public function load(Request $request)
  2566.     {
  2567.         $em = $this->getDoctrine()->getManager();
  2568.         $precios = array(10000, 5000, 7900, 12000, 17000, 20500,9000, 500, 300, 1000, 14500);
  2569.         $productos = $this->getDoctrine()->getRepository('App:Producto')->findAll();
  2570.         $tiendas = $this->getDoctrine()->getRepository('App:Tienda')->findAll();
  2571.         foreach ($tiendas as $tienda){
  2572.             $cont = 0;
  2573.             foreach ($productos as $producto){
  2574.                 if($cont >= count($precios))
  2575.                     $cont = 0;
  2576.                 $inventario = new Inventario();
  2577.                 $inventario->setCantidad(1);
  2578.                 $inventario->setProducto($producto);
  2579.                 $inventario->setPrecio($precios[$cont]);
  2580.                 $inventario->setTienda($tienda);
  2581.                 $cont++;
  2582.                 $em->persist($inventario);
  2583.                 $em->flush();
  2584.                 $this->qi->saveFire($inventario);
  2585.             }
  2586.         }
  2587.         return $this->render('basic/template.html.twig', [
  2588.         ]);
  2589.     }
  2590.     */
  2592.     /**
  2593.      * @Route("/mispedidos/romance/mispedidos", name="mispedidos")
  2594.      */
  2595.     public function mispedidos(Request $request)
  2596.     {
  2597.         $user = $this->getUser();
  2598.         if(!$user){
  2599.             return $this->redirectToRoute('homepage');
  2600.         }
  2601.         $aprobado = $this->getDoctrine()->getRepository(EstadoPedido::class)->findBy(array('ref'=>'APPROVED'));
  2602.         $pedidos = $this->getDoctrine()->getRepository(Compra::class)->findBy(array("usuario"=>$user,'estado'=>$aprobado), array("createdAt"=>"desc"));
  2604.         return $this->render('basic/pedidos.html.twig', [
  2605.             'pedidos' => $pedidos,
  2606.             'idprincipal' => $idprincipal=null
  2607.         ]);
  2608.     }
  2610.     /**
  2611.      * @Route("/mailingcompra/romance/mailingcompra", name="mailingcompra")
  2612.      */
  2613.     public function mailingcompra(Request $request)
  2614.     {
  2615.         $compra = $this->getDoctrine()->getRepository('App:Compra')->findOneBy(array(), array('id'=>'desc'));
  2616.         $asunto = $this->qi->getSetting('asunto_compra_cliente');
  2617.         $mail = $this->renderView('mailing/pedido.html.twig',array('compra'=>$compra));
  2619.         $this->qi->sendMail($asunto, 'laura@iridian.co', $mail);
  2620.         return $this->render('mailing/pedido.html.twig', array(
  2621.             'compra'=>$compra,
  2622.             'idprincipal' => $idprincipal=null
  2623.         ));
  2624.     }
  2626.     /**
  2627.      * @Route("/mailingcontacto/romance/mailingcontacto", name="mailingcontacto")
  2628.      */
  2629.     public function mailingcontacto(Request $request)
  2630.     {
  2631.         //$compra = $this->getDoctrine()->getRepository('App:Contacto')->findOneBy(array(), array('id'=>'desc'));
  2632.         $asunto = $this->qi->getTexto('asunto_compra_cliente');
  2633.         //$mail = $this->renderView('mailing/compra.html.twig',array('compra'=>$compra));
  2634.         //dd($this->qi->sendMail($asunto, 'mauricio@iridian.co', $mail));
  2635.         return $this->render('contact/contact_mail.html.twig', array(
  2636.             'nombre'=>'Luisa',
  2637.             'email'=>'samuel@iridian.co',
  2638.             'telefono'=>'3002111111',
  2639.             'mensaje'=>'Hola quiero saber si venden traumel en tabletas',
  2640.         ));
  2641.     }
  2643.     /**
  2644.      * @Route("/load_images/romance/load_images", name="load_images")
  2645.      */
  2646.     public function load_images(Request $request)
  2647.     {
  2648.         $em = $this->getDoctrine()->getManager();
  2649.         $imgs = [[90069577,1,'jpg'], [90069577,2,'jpg'], [90069577,3,'jpg'], [90069788,1,'jpg'], [90069788,2,'jpg'], [90069788,3,'jpg'], [90069789,1,'jpg'], [90069789,2,'jpg'], [90069789,3,'jpg'], [90069790,1,'jpg'], [90069790,2,'jpg'], [90069790,3,'jpg'], [90070677,1,'jpg'], [90070677,2,'jpg'], [90070677,3,'jpg'], [90071645,1,'jpg'], [90071645,2,'jpg'], [90072962,1,'jpg'], [90072962,2,'jpg'], [90072962,3,'jpg'], [90072967,1,'png'], [90072967,2,'jpg'], [90072967,3,'jpg'], [90073014,1,'jpg'], [90073014,2,'jpg'], [90073015,1,'jpg'], [90073015,2,'jpg'], [90073016,1,'jpg'], [90073016,2,'jpg'], [90073220,1,'png'], [90073220,2,'jpg'], [90073220,3,'jpg'], [90073223,1,'png'], [90073223,2,'jpg'], [90073223,3,'jpg'], [90073225,1,'png'], [90073225,2,'jpg'], [90073225,3,'jpg'], [90073228,1,'png'], [90073228,2,'jpg'], [90073228,3,'jpg'], [90073231,1,'png'], [90073231,2,'jpg'], [90073231,3,'jpg'], [90073241,1,'png'], [90073241,2,'jpg'], [90073241,3,'jpg'], [90073244,1,'png'], [90073244,2,'jpg'], [90073244,3,'jpg'], [90073249,1,'jpg'], [90073249,2,'jpg'], [90073249,3,'jpg'], [90073252,1,'jpg'], [90073252,2,'jpg'], [90073252,3,'jpg'], [90073257,1,'jpg'], [90073257,2,'jpg'], [90073257,3,'jpg'], [90073260,1,'jpg'], [90073260,2,'jpg'], [90073260,3,'jpg'], [90074207,1,'jpg'], [90074207,2,'jpg'], [90074207,3,'jpg'], [90074209,1,'jpg'], [90074209,2,'jpg'], [90074209,3,'jpg'], [90074211,1,'jpg'], [90074211,2,'jpg'], [90074211,3,'jpg'], [90075022,1,'jpg'], [90075022,2,'jpg'], [90075294,1,'png'], [90075294,2,'jpg'], [90075294,3,'jpg'], [90075295,1,'png'], [90075295,2,'jpg'], [90075295,3,'jpg'], [90075342,1,'jpg'], [90075342,2,'jpg'], [90075342,3,'jpg'], [90075348,1,'jpg'], [90075348,2,'jpg'], [90075349,1,'jpg'], [90075349,2,'jpg'], [90075467,1,'jpg'], [90075467,2,'jpg'], [90075467,3,'jpg'], [90075467,4,'jpg'], [90075467,5,'png'], [90075468,1,'jpg'], [90075468,2,'jpg'], [90075468,3,'jpg'], [90075468,4,'jpg'], [90075468,5,'png'], [90075469,1,'jpg'], [90075469,2,'jpg'], [90075469,3,'jpg'], [90075469,4,'jpg'], [90075469,5,'png'], [90075512,1,'jpg'], [90075512,2,'jpg'], [90075512,3,'jpg'], [90075512,4,'jpg'], [90075512,5,'png'], [90075513,1,'jpg'], [90075513,2,'jpg'], [90075513,3,'jpg'], [90075513,4,'jpg'], [90075513,5,'png'], [90076166,1,'jpg'], [90076166,2,'jpg'], [90076166,3,'jpg'], [90076166,4,'jpg'], [90076166,5,'png'], [90076166,6,'jpg'], [90076167,1,'jpg'], [90076167,2,'jpg'], [90076167,3,'jpg'], [90076167,4,'jpg'], [90076167,5,'png'], [90076167,6,'jpg'], [90076168,1,'jpg'], [90076168,2,'jpg'], [90076168,3,'jpg'], [90076168,4,'jpg'], [90076168,5,'png'], [90076168,6,'jpg'], [90076168,7,'jpg'], [90076168,8,'jpg'], [90076169,1,'jpg'], [90076169,2,'jpg'], [90076169,3,'jpg'], [90076169,4,'jpg'], [90076169,5,'png'], [90076169,6,'jpg'], [90076169,7,'jpg'], [90076169,8,'jpg'], [90076195,1,'jpg'], [90076195,2,'jpg'], [90076195,3,'jpg'], [90076195,4,'jpg'], [90076195,5,'png'], [90076195,6,'jpg'], [90076195,7,'jpg'], [90076195,8,'jpg'], [90076196,1,'jpg'], [90076196,2,'jpg'], [90076196,3,'jpg'], [90076196,4,'jpg'], [90076196,5,'png'], [90076196,6,'jpg'], [90076196,7,'jpg'], [90076196,8,'jpg'], [90076485,1,'jpg'], [90076485,2,'jpg'], [90076486,1,'jpg'], [90076486,2,'jpg'], [90077226,1,'jpg'], [90077226,2,'jpg'], [90077226,3,'jpg'], [90077588,1,'jpg'], [90077588,2,'jpg'], [90077588,3,'jpg'], [90077589,1,'jpg'], [90077589,2,'jpg'], [90077589,3,'jpg'], [90077590,1,'jpg'], [90077590,2,'jpg'], [90077590,3,'jpg'], [90077591,1,'jpg'], [90077591,2,'jpg'], [90077591,3,'jpg'], [90077592,1,'jpg'], [90077592,2,'jpg'], [90077592,3,'jpg'], [90077616,1,'jpg'], [90077616,2,'jpg'], [90077616,3,'jpg'], [90077616,4,'jpg'], [90077616,5,'jpg'], [90077616,6,'jpg'], [90077616,7,'jpg'], [90077616,8,'jpg'], [90077616,9,'jpg'], [90077876,1,'jpg'], [90077876,2,'jpg'], [90077876,3,'png'], [90077877,1,'jpg'], [90077877,2,'jpg'], [90078113,1,'jpg'], [90078113,2,'jpg'], [90078113,3,'jpg'], [90078113,4,'jpg'], [90078142,1,'jpg'], [90078142,2,'jpg'], [90078142,3,'jpg'], [90078142,4,'jpg'], [90078142,5,'jpg'], [90078143,1,'jpg'], [90078143,2,'jpg'], [90078143,3,'jpg'], [90078143,4,'jpg'], [90078143,5,'png'], [90078144,1,'jpg'], [90078144,2,'jpg'], [90078144,3,'jpg'], [90078144,4,'jpg'], [90078144,5,'jpg'], [90078145,1,'jpg'], [90078145,2,'jpg'], [90078145,3,'jpg'], [90078145,4,'jpg'], [90078145,5,'png'], [90078146,1,'jpg'], [90078146,2,'jpg'], [90078146,3,'jpg'], [90078146,4,'jpg'], [90078146,5,'jpg'], [90078147,1,'jpg'], [90078147,2,'jpg'], [90078147,3,'jpg'], [90078147,4,'jpg'], [90078147,5,'png'], [90078355,1,'jpg'], [90078355,2,'jpg'], [90078355,3,'jpg'], [90078355,4,'jpg'], [90078355,5,'png'], [90078356,1,'jpg'], [90078356,2,'jpg'], [90078356,3,'jpg'], [90078356,4,'jpg'], [90078356,5,'png'], [90078357,1,'jpg'], [90078357,2,'jpg'], [90078357,3,'jpg'], [90078357,4,'jpg'], [90078357,5,'png'], [90078358,1,'jpg'], [90078358,2,'jpg'], [90078358,3,'jpg'], [90078358,4,'jpg'], [90078358,5,'png'], [90078359,1,'jpg'], [90078359,2,'jpg'], [90078359,3,'jpg'], [90078359,4,'jpg'], [90078359,5,'png'], [90078361,1,'jpg'], [90078361,2,'jpg'], [90078361,3,'jpg'], [90078361,4,'jpg'], [90078361,5,'png'], [90078362,1,'jpg'], [90078362,2,'jpg'], [90078362,3,'jpg'], [90078362,4,'jpg'], [90078362,5,'png'], [90078363,1,'jpg'], [90078363,2,'jpg'], [90078363,3,'jpg'], [90078363,4,'jpg'], [90078363,5,'png'], [90078364,1,'jpg'], [90078364,2,'jpg'], [90078364,3,'jpg'], [90078364,4,'jpg'], [90078364,5,'jpg'], [90078365,1,'jpg'], [90078365,2,'jpg'], [90078365,3,'jpg'], [90078365,4,'jpg'], [90078365,5,'jpg'], [90078366,1,'jpg'], [90078366,2,'jpg'], [90078366,3,'jpg'], [90078366,4,'jpg'], [90078366,5,'jpg'], [90078367,1,'jpg'], [90078367,2,'jpg'], [90078367,3,'jpg'], [90078367,4,'jpg'], [90078367,5,'jpg'], [90078373,1,'jpg'], [90078373,2,'jpg'], [90078373,3,'jpg'], [90078373,4,'jpg'], [90078373,5,'png'], [90078374,1,'jpg'], [90078374,2,'jpg'], [90078374,3,'jpg'], [90078374,4,'jpg'], [90078374,5,'png'], [90078375,1,'jpg'], [90078375,2,'jpg'], [90078375,3,'jpg'], [90078375,4,'jpg'], [90078375,5,'png'], [90078376,1,'jpg'], [90078376,2,'jpg'], [90078376,3,'jpg'], [90078376,4,'jpg'], [90078376,5,'png'], [90078377,1,'jpg'], [90078377,2,'jpg'], [90078377,3,'jpg'], [90078377,4,'jpg'], [90078378,1,'jpg'], [90078378,2,'jpg'], [90078378,3,'jpg'], [90078378,4,'jpg'], [90078379,1,'jpg'], [90078379,2,'jpg'], [90078379,3,'jpg'], [90078379,4,'jpg'], [90078380,1,'jpg'], [90078380,2,'jpg'], [90078380,3,'jpg'], [90078380,4,'jpg'], [90078381,1,'jpg'], [90078381,2,'jpg'], [90078381,3,'jpg'], [90078381,4,'jpg'], [90078381,5,'jpg'], [90078383,1,'jpg'], [90078383,2,'jpg'], [90078383,3,'jpg'], [90078383,4,'jpg'], [90078383,5,'jpg'], [90078384,1,'jpg'], [90078384,2,'jpg'], [90078384,3,'jpg'], [90078384,4,'jpg'], [90078384,5,'jpg'], [90078385,1,'jpg'], [90078385,2,'jpg'], [90078385,3,'jpg'], [90078385,4,'jpg'], [90078385,5,'jpg'], [90078386,1,'jpg'], [90078386,2,'jpg'], [90078386,3,'jpg'], [90078386,4,'jpg'], [90078386,5,'jpg'], [90078387,1,'jpg'], [90078387,2,'jpg'], [90078387,3,'jpg'], [90078387,4,'jpg'], [90078387,5,'jpg'], [90078388,1,'jpg'], [90078388,2,'jpg'], [90078388,3,'jpg'], [90078388,4,'jpg'], [90078388,5,'jpg'], [90078389,1,'jpg'], [90078389,2,'jpg'], [90078389,3,'jpg'], [90078389,4,'jpg'], [90078389,5,'jpg'], [90078487,1,'jpg'], [90078487,2,'jpg'], [90078487,3,'jpg'], [90078487,4,'jpg'], [90078487,5,'jpg'], [90078487,6,'jpg'], [90078487,7,'jpg'], [90078488,1,'jpg'], [90078488,2,'jpg'], [90078488,3,'jpg'], [90078488,4,'jpg'], [90078488,5,'jpg'], [90078488,6,'jpg'], [90078488,7,'jpg'], [90078489,1,'jpg'], [90078489,2,'jpg'], [90078489,3,'jpg'], [90078489,4,'jpg'], [90078489,5,'jpg'], [90078489,6,'jpg'], [90078489,7,'jpg'], [90078490,1,'jpg'], [90078490,2,'jpg'], [90078490,3,'jpg'], [90078490,4,'jpg'], [90078490,5,'jpg'], [90078490,6,'jpg'], [90078490,7,'jpg'], [90078491,1,'jpg'], [90078491,2,'jpg'], [90078491,3,'jpg'], [90078491,4,'jpg'], [90078491,5,'jpg'], [90078491,6,'jpg'], [90078491,7,'jpg'], [90078492,1,'jpg'], [90078492,2,'jpg'], [90078492,3,'jpg'], [90078492,4,'jpg'], [90078492,5,'png'], [90078492,6,'jpg'], [90078492,7,'jpg'], [90078493,1,'jpg'], [90078493,2,'jpg'], [90078493,3,'jpg'], [90078493,4,'jpg'], [90078493,5,'png'], [90078493,6,'jpg'], [90078493,7,'jpg'], [90078494,1,'jpg'], [90078494,2,'jpg'], [90078494,3,'jpg'], [90078494,4,'jpg'], [90078494,5,'png'], [90078494,6,'jpg'], [90078494,7,'jpg'], [90078495,1,'jpg'], [90078495,2,'jpg'], [90078495,3,'jpg'], [90078495,4,'jpg'], [90078495,5,'png'], [90078495,6,'jpg'], [90078495,7,'jpg'], [90078496,1,'jpg'], [90078496,2,'jpg'], [90078496,3,'jpg'], [90078496,4,'jpg'], [90078496,5,'png'], [90078496,6,'jpg'], [90078496,7,'jpg'], [90078497,1,'jpg'], [90078497,2,'jpg'], [90078497,3,'jpg'], [90078497,4,'jpg'], [90078497,5,'jpg'], [90078497,6,'jpg'], [90078497,7,'jpg'], [90078498,1,'jpg'], [90078498,2,'jpg'], [90078498,3,'jpg'], [90078498,4,'jpg'], [90078498,5,'jpg'], [90078498,6,'jpg'], [90078498,7,'jpg'], [90078499,1,'jpg'], [90078499,2,'jpg'], [90078499,3,'jpg'], [90078499,4,'jpg'], [90078499,5,'jpg'], [90078499,6,'jpg'], [90078499,7,'jpg'], [90078500,1,'jpg'], [90078500,2,'jpg'], [90078500,3,'jpg'], [90078500,4,'jpg'], [90078500,5,'jpg'], [90078500,6,'jpg'], [90078500,7,'jpg'], [90078501,1,'jpg'], [90078501,2,'jpg'], [90078501,3,'jpg'], [90078501,4,'jpg'], [90078501,5,'jpg'], [90078501,6,'jpg'], [90078501,7,'jpg'], [90078507,1,'jpg'], [90078507,2,'jpg'], [90078507,3,'jpg'], [90078507,4,'jpg'], [90078507,5,'png'], [90078507,6,'jpg'], [90078507,7,'jpg'], [90078507,8,'jpg'], [90078507,9,'jpg'], [90078508,1,'jpg'], [90078508,2,'jpg'], [90078508,3,'jpg'], [90078508,4,'jpg'], [90078508,5,'png'], [90078508,6,'jpg'], [90078508,7,'jpg'], [90078508,8,'jpg'], [90078508,9,'jpg'], [90078509,1,'jpg'], [90078509,2,'jpg'], [90078509,3,'jpg'], [90078509,4,'jpg'], [90078509,5,'png'], [90078509,6,'jpg'], [90078509,7,'jpg'], [90078509,8,'jpg'], [90078509,9,'jpg'], [90078510,1,'jpg'], [90078510,2,'jpg'], [90078510,3,'jpg'], [90078510,4,'jpg'], [90078510,5,'png'], [90078510,6,'jpg'], [90078510,7,'jpg'], [90078510,8,'jpg'], [90078510,9,'jpg'], [90078511,1,'jpg'], [90078511,2,'jpg'], [90078511,3,'jpg'], [90078511,4,'jpg'], [90078511,5,'png'], [90078511,6,'jpg'], [90078511,7,'jpg'], [90078511,8,'jpg'], [90078511,9,'jpg'], [90078512,1,'jpg'], [90078512,2,'jpg'], [90078512,3,'jpg'], [90078512,4,'jpg'], [90078512,5,'png'], [90078512,6,'jpg'], [90078512,7,'jpg'], [90078513,1,'jpg'], [90078513,2,'jpg'], [90078513,3,'jpg'], [90078513,4,'jpg'], [90078513,5,'png'], [90078513,6,'jpg'], [90078513,7,'jpg'], [90078514,1,'jpg'], [90078514,2,'jpg'], [90078514,3,'jpg'], [90078514,4,'jpg'], [90078514,5,'png'], [90078514,6,'jpg'], [90078514,7,'jpg'], [90078515,1,'jpg'], [90078515,2,'jpg'], [90078515,3,'jpg'], [90078515,4,'jpg'], [90078515,5,'png'], [90078515,6,'jpg'], [90078515,7,'jpg'], [90078516,1,'jpg'], [90078516,2,'jpg'], [90078516,3,'jpg'], [90078516,4,'jpg'], [90078516,5,'png'], [90078516,6,'jpg'], [90078516,7,'jpg'], [90078694,1,'jpg'], [90078694,2,'jpg'], [90078694,3,'jpg'], [90078694,4,'jpg'], [90078694,5,'jpg'], [90078694,6,'jpg'], [90078695,1,'jpg'], [90078695,2,'jpg'], [90078695,3,'jpg'], [90078695,4,'jpg'], [90078695,5,'jpg'], [90078695,6,'jpg'], [90078696,1,'jpg'], [90078696,2,'jpg'], [90078696,3,'jpg'], [90078696,4,'jpg'], [90078696,5,'jpg'], [90078696,6,'jpg'], [90078697,1,'jpg'], [90078697,2,'jpg'], [90078697,3,'jpg'], [90078697,4,'jpg'], [90078697,5,'jpg'], [90078697,6,'jpg'], [90078698,1,'jpg'], [90078698,2,'jpg'], [90078698,3,'jpg'], [90078698,4,'jpg'], [90078698,5,'jpg'], [90078698,6,'jpg'], [90078699,1,'jpg'], [90078699,2,'jpg'], [90078699,3,'jpg'], [90078699,4,'jpg'], [90078699,5,'jpg'], [90078699,6,'jpg'], [90078700,1,'jpg'], [90078700,2,'jpg'], [90078700,3,'jpg'], [90078700,4,'jpg'], [90078700,5,'jpg'], [90078700,6,'jpg'], [90078701,1,'jpg'], [90078701,2,'jpg'], [90078701,3,'jpg'], [90078701,4,'jpg'], [90078701,5,'jpg'], [90078701,6,'jpg'], [90078702,1,'jpg'], [90078702,2,'jpg'], [90078702,3,'jpg'], [90078702,4,'jpg'], [90078702,5,'jpg'], [90078702,6,'jpg'], [90078703,1,'jpg'], [90078703,2,'jpg'], [90078703,3,'jpg'], [90078703,4,'jpg'], [90078703,5,'jpg'], [90078703,6,'jpg'], [90078704,1,'jpg'], [90078704,2,'jpg'], [90078704,3,'jpg'], [90078705,1,'jpg'], [90078705,2,'jpg'], [90078705,3,'jpg'], [90078706,1,'jpg'], [90078706,2,'jpg'], [90078706,3,'jpg'], [90078707,1,'jpg'], [90078707,2,'jpg'], [90078707,3,'jpg'], [90078708,1,'jpg'], [90078708,2,'jpg'], [90078708,3,'jpg'], [90078709,1,'jpg'], [90078709,2,'jpg'], [90078709,3,'jpg'], [90078710,1,'jpg'], [90078710,2,'jpg'], [90078710,3,'jpg'], [90078711,1,'jpg'], [90078711,2,'jpg'], [90078711,3,'jpg'], [90078712,1,'jpg'], [90078712,2,'jpg'], [90078712,3,'jpg'], [90078713,1,'jpg'], [90078713,2,'jpg'], [90078713,3,'jpg'], [90079388,1,'png'], [90079388,2,'jpg'], [90079388,3,'jpg'], [90079389,1,'png'], [90079389,2,'jpg'], [90079389,3,'jpg'], [90079390,1,'png'], [90079390,2,'jpg'], [90079390,3,'jpg'], [90079391,1,'png'], [90079391,2,'jpg'], [90079391,3,'jpg'], [90079392,1,'png'], [90079392,2,'jpg'], [90079392,3,'jpg'], [90079393,1,'png'], [90079393,2,'jpg'], [90079393,3,'jpg'], [90079394,1,'png'], [90079394,2,'jpg'], [90079394,3,'jpg'], [90079395,1,'png'], [90079395,2,'jpg'], [90079395,3,'jpg'], [90079396,1,'png'], [90079396,2,'jpg'], [90079396,3,'jpg'], [90079397,1,'png'], [90079397,2,'jpg'], [90079397,3,'jpg'], [90079398,1,'jpg'], [90079398,2,'jpg'], [90079398,3,'jpg'], [90079401,1,'jpg'], [90079401,2,'jpg'], [90079401,3,'jpg'], [90079402,1,'jpg'], [90079402,2,'jpg'], [90079402,3,'jpg'], [90079403,1,'jpg'], [90079403,2,'jpg'], [90079403,3,'jpg'], [90079404,1,'jpg'], [90079404,2,'jpg'], [90079404,3,'jpg'], [90079409,1,'png'], [90079409,2,'jpg'], [90079409,3,'jpg'], [90079410,1,'png'], [90079410,2,'jpg'], [90079410,3,'jpg'], [90079411,1,'png'], [90079411,2,'jpg'], [90079411,3,'jpg'], [90079412,1,'png'], [90079412,2,'jpg'], [90079412,3,'jpg'], [90079413,1,'png'], [90079413,2,'jpg'], [90079413,3,'jpg'], [90079414,1,'png'], [90079414,2,'jpg'], [90079414,3,'jpg'], [90079415,1,'png'], [90079415,2,'jpg'], [90079415,3,'jpg'], [90079416,1,'png'], [90079416,2,'jpg'], [90079416,3,'jpg'], [90079417,1,'png'], [90079417,2,'jpg'], [90079417,3,'jpg'], [90079418,1,'png'], [90079418,2,'jpg'], [90079418,3,'jpg'], [90079420,1,'jpg'], [90079420,2,'jpg'], [90079420,3,'jpg'], [90079421,1,'jpg'], [90079421,2,'jpg'], [90079421,3,'jpg'], [90079422,1,'jpg'], [90079422,2,'jpg'], [90079422,3,'jpg'], [90079423,1,'jpg'], [90079423,2,'jpg'], [90079423,3,'jpg'], [90079424,1,'jpg'], [90079424,2,'jpg'], [90079424,3,'jpg'], [90077616,10,'jpg'], [90077616,11,'jpg']];
  2650.         $prods = $this->getDoctrine()->getRepository('App:Producto')->findAll();
  2651.         $prods_array = [];
  2652.         foreach ($prods as $prod){
  2653.             $prods_array[$prod->getPlu()] = $prod;
  2654.         }
  2655.         $ini = "https://firebasestorage.googleapis.com/v0/b/romancerelax-2021.appspot.com/o/app_images%2F";
  2656.         $fin = "?alt=media&token=a72666b0-cf6f-4480-a06b-286f3f0911e6";
  2657.         foreach ($imgs as $data){
  2658.             $sku = $data[0];
  2659.             $pos = $data[1];
  2660.             $ext = $data[2];
  2661.             $ruta = $ini.$sku.'_'.$pos.'.'.$ext.$fin;
  2662.             $producto = $prods_array[$sku];
  2663.             if($pos == 1){
  2664.                 $producto->setImagen($ruta);
  2665.                 $em->persist($producto);
  2666.             }else{
  2667.                 $new_img = new Image();
  2668.                 $new_img->setProducto($producto);
  2669.                 $new_img->setVisible(true);
  2670.                 $new_img->setOrden(1);
  2671.                 $new_img->setImage($ruta);
  2672.                 $em->persist($new_img);
  2673.             }
  2674.         }
  2675.         $em->flush();
  2676.         dd(1);
  2677.         return $this->render('contact/contact_mail.html.twig', array(
  2678.             'nombre'=>'Luisa',
  2679.             'email'=>'samuel@iridian.co',
  2680.             'telefono'=>'3002111111',
  2681.             'mensaje'=>'Hola quiero saber si venden traumel en tabletas',
  2682.         ));
  2683.     }
  2685.     /**
  2686.      * @Route("/mis-datos/romance/mis-datos", name="mis-datos")
  2687.      */
  2688.     public function misDatos(Request $request)
  2689.     {
  2690.         $user = $this->getUser();
  2691.         if ($user) {
  2692.             $perfil = new Usuario();
  2693.             $form = $this->createForm(PerfilType::class, $perfil);
  2694.             $form->handleRequest($request);
  2696.             if ($form->isSubmitted() && $form->isValid()) {
  2697.                 $perfil = $form->getData();
  2698.                 $um = $this->userManager;
  2699.                 $user = $um->findUserBy(array('uid' => $user->getUid() ));
  2701.                 $user->setNombre($perfil->getNombre());
  2702.                 $user->setDocumento($perfil->getDocumento());
  2703.                 $user->setEmail($perfil->getEmail());
  2704.                 $user->setCelular($perfil->getCelular());
  2705.                 $user->setEmail($form->get('email')->getData());
  2706.                
  2707.                 $em = $this->getDoctrine()->getManager();
  2708.                 $em->persist($user);
  2709.                 $em->flush();
  2710.                 $um->updateUser($user);
  2712.                 return $this->render('home/mis-datos.html.twig', [
  2713.                     'user' => $user,
  2714.                     'msg' => 'submitted and validated',
  2715.                     'form' => $form->createView(),
  2716.                     'perfil' => $perfil
  2717.                 ]);
  2718.             }
  2719.           
  2720.             return $this->render('home/mis-datos.html.twig', [
  2721.                 'user' => $user,
  2722.                 'msg' => 'no submit',
  2723.                 'form' => $form->createView(),
  2724.                 'perfil' => $perfil,
  2725.                 'idprincipal' => $idprincipal = null
  2726.             ]);
  2727.         } else {
  2728.             return $this->redirectToRoute('homepage');
  2729.         }
  2730.     }
  2732.     /**
  2733.      * @Route("/mis-compras/romance/mis-compras", name="mis-compras")
  2734.      */
  2735.     public function misCompras(Request $request)
  2736.     {
  2737.         $user = $this->getUser();
  2739.         if(!$user){
  2740.             return $this->redirectToRoute('homepage');
  2741.         }
  2743.         // $estado = $this->getDoctrine()->getRepository(EstadoPedido::class)->findOneBy(array("ref" => 'APROBADA'));
  2744.         // $compras=$this->getDoctrine()->getRepository(Compra::class)->findBy(array( 'usuario'=>$user),array('id'=>'desc'));
  2746.         $aprobado = $this->getDoctrine()->getRepository(EstadoPedido::class)->findOneBy(array('ref'=>'APROBADA'));
  2747.         $compras=$this->getDoctrine()->getRepository(Compra::class)->findBy(array('usuario'=>$user),array('createdAt'=>'desc'));
  2749.         // dd($compras);
  2751.         
  2752.         return $this->render('home/mis-compras.html.twig', [
  2753.             'compras'=>$compras,
  2754.             'idprincipal' => $idprincipal = null
  2756.             ]);
  2758.     }
  2760.     /**
  2761.      * @Route("/mis-compras-interna/romance/mis-compras-interna/{id}", name="mis-compras-interna")
  2762.      */
  2763.     public function misComprasInterna(Request $request,$id)
  2764.     {
  2766.         $compra=$this->getDoctrine()->getRepository(Compra::class)->find($id);
  2767.         $usuario=$compra->getUsuario();
  2769.         // $tracking = $this->fedex->TrackingPedido($compra);
  2771.         // $estados = array(
  2772.         //     'PU' => 'RECIBIDA',
  2773.         //     'AF' => 'ALISTAMIENTO',
  2774.         //     'IT' => 'EN CAMINO',
  2775.         //     'DL' => 'ENTREGADA',
  2776.         //     'CA' => 'NOVEDAD',
  2777.         //     'DE' => 'NOVEDAD',
  2779.         // );
  2781.         // if(isset($tracking['code'])) {
  2782.         //     $seguimiento = $this->getDoctrine()->getRepository('App:Seguimiento')->findOneBy(array('nombre_es'=>$estados[$tracking['code']]));
  2784.         // }else{
  2785.         //     $seguimiento = $this->getDoctrine()->getRepository('App:Seguimiento')->find(2);
  2786.         // }
  2787.         // $track=$this->getDoctrine()->getRepository('App:SeguimientoTracking')->findOneBy(array('compra'=>$compra,'seguimiento'=>$seguimiento));
  2788.         // if($seguimiento && !$track){
  2790.         //     $compra->setSeguimiento($seguimiento);
  2791.         //     $segtrack = new SeguimientoTracking();
  2792.         //     $segtrack->setCompra($compra);
  2793.         //     $segtrack->setSeguimiento($seguimiento);
  2794.         //     $em = $this->getDoctrine()->getManager();
  2795.         //     $em->persist($compra);
  2796.         //     $em->persist($segtrack);
  2797.         //     $em->flush();
  2799.         // }
  2800.         // dd($compra);
  2801.         
  2802.         
  2803.         return $this->render('home/mis-compras-interna.html.twig', [
  2804.             'compra'=>$compra,
  2805.             'usuario'=>$usuario,
  2806.             'idprincipal' => $idprincipal = null
  2809.             
  2810.         ]);
  2811.         
  2813.     }
  2815.     /**
  2816.      * @Route("/mis-direcciones/romance/mis-direcciones", name="mis-direcciones")
  2817.      */
  2818.     public function misDirecciones2(Request $request)
  2819.     {
  2820.         $user = $this->getUser();
  2821.         if ($user) {
  2822.             $direcciones = $this->getDoctrine()->getRepository(Direccion::class)->createQueryBuilder('d')
  2823.                 ->select('d')
  2824.                 ->leftJoin('d.usuario','u')
  2825.                 ->where('u.id = '.$user->getId())
  2826.                 ->andWhere('d.visible = 1')
  2827.                 ->getQuery()
  2828.                 ->getResult();
  2829.             // ->andWhere('d.visible is null or d.visible = 1')
  2830.             return $this->render('home/mis-direcciones.html.twig', [
  2831.                 'direcciones' => $direcciones,
  2832.                 'idprincipal' => $idprincipal = null
  2834.             ]);
  2835.         }
  2836.     }
  2838.     /**
  2839.      * @Route("/editar-direccion/romance/{id}", name="editar-direccion")
  2840.      */
  2841.     public function editarDirecciones(Request $request,$id)
  2842.     {
  2843.         $user=$this->getUser();
  2844.         if(!$user){
  2845.             return $this->redirectToRoute('homepage');
  2846.         }
  2848.         $direccion=$this->getDoctrine()->getRepository(Direccion::class)->find($id);
  2850.         return $this->render('home/editar_mis-direcciones-formulario.html.twig', [
  2851.             'direccion'=>$direccion,
  2852.             'idprincipal' => $idprincipal=null
  2853.         ]);
  2854.     }
  2856.         /**
  2857.      * @Route("/enviar-edicion-formulario-direccion/romance/{id}", name="enviar-edicion-formulario-direccion")
  2858.      */
  2859.     public function enviaredicionformulariodireccion(Request $request,$id)
  2860.     {
  2861.         $mensaje = array("ok" => false, "mensaje" => "error");
  2862.         $user=$this->getUser();
  2863.         if(!$user){
  2864.             return $this->redirectToRoute('homepage');
  2865.         }
  2867.         $direccioneditada=$this->getDoctrine()->getRepository(Direccion::class)->find($id);
  2868.         // $nombre=$request->get("nombrecompleto");  
  2869.         // $telefono=$request->get("telefono");
  2870.         $direccion=$request->get("direccion");
  2872.         // $zip=$request->get("zip");
  2873.         $ciudad=$request->get("ciudad");
  2875.         //$departamento=$request->get("departamento");
  2876.         // $numerodoc=$request->request->get('numerodoc');
  2877.         // $tipodoc=$this->getDoctrine()->getRepository(Tipodocumento::class)->find($request->request->get('tipodoc'));
  2878.         $ciudad=$this->getDoctrine()->getRepository(Ciudad::class)->find($request->request->get('ciudad'));
  2880.         $em = $this->getDoctrine()->getManager();        
  2881.         // $direccioneditada->setPersona($nombre);
  2882.         // $direccioneditada->setTelefono($telefono);
  2883.         $direccioneditada->setDireccion($direccion);
  2884.         // $direccioneditada->setCodigopostal($zip);
  2885.         // if($zip) {
  2886.         //     $data =$this->fedex->ValidarPostal($zip, $ciudad->getPais()->getCodigo());
  2887.         //     if(isset($data->error)){
  2888.         //         $this->addFlash(
  2889.         //             'warning',
  2890.         //             'Error postal'
  2891.         //         );
  2892.         //         return $this->redirectToRoute('editar-direccion',array('id'=>$id));
  2893.         //     }
  2895.         // }
  2896.         $direccioneditada->setCiudad($ciudad);
  2897.         // $direccioneditada->setTipodocumento($tipodoc);
  2898.         // $direccioneditada->setNumerodocumento($numerodoc);
  2899.         $direccioneditada->setVisible(1);
  2900.         //$direccioneditada->setDepartamento($departamento);
  2901.         
  2902.         $em = $this->getDoctrine()->getManager();
  2903.         $em->persist($direccioneditada);
  2904.         $em->flush();
  2906.         $mensaje["ok"] = true;
  2907.         $mensaje["mensaje"] = "Direccion Editada";
  2909.         return new JsonResponse($mensaje);
  2910.     }
  2912.     /**
  2913.      * @Route("/eliminar-direccion/romance/{id}", name="eliminar-direccion")
  2914.      */
  2915.     public function eliminardireccion(Request $request,$id)
  2916.     {
  2917.         // $mensaje = array("ok" => false, "mensaje" => "error");
  2918.         $user=$this->getUser();
  2919.         if(!$user){
  2920.             return $this->redirectToRoute('homepage');
  2921.         }
  2923.         $direccion=$this->getDoctrine()->getRepository(Direccion::class)->find($id);
  2924.         // dd($direccion); 
  2925.         
  2926.         $em = $this->getDoctrine()->getManager();
  2927.         $direccion->setVisible(false);
  2928.         // $em->persist($direccioneditada);
  2929.         // $em->flush();
  2930.         $em->persist($direccion);
  2931.         $em->flush();
  2933.        return $this->redirectToRoute('mis-direcciones',[
  2934.         'idprincipal' => $idprincipal=null
  2936.         ]);
  2937.     }
  2939.     /**
  2940.      * @Route("/mis-direcciones-formulario/romance/mis-direcciones-formulario", name="mis-direcciones-formulario")
  2941.      */
  2942.     public function misDireccionesFormulario(Request $request)
  2943.     {
  2944.         return $this->render('home/mis-direcciones-formulario.html.twig', [
  2945.             'idprincipal' => $idprincipal = null
  2947.         ]);
  2948.     }
  2951.         /**
  2952.      * @Route("/mis-favoritos/romance/mis-favoritos", name="mis-favoritos")
  2953.      */
  2954.     public function misFavoritos(Request $request)
  2955.     { 
  2956.         $user=$this->getUser();
  2957.         if(!$user){
  2958.             return $this->redirectToRoute('homepage');
  2959.         }
  2961.         $favoritos_prod= $this->getDoctrine()->getRepository(Producto::class)->createQueryBuilder('p')
  2962.             ->select('p')
  2963.             ->leftJoin('p.favoritos', 'fav')
  2964.             ->leftJoin('fav.usuario', 'u')
  2965.             ->leftJoin('fav.producto', 'pa')
  2966.             ->Where('u.id ='.$user->getId())
  2967.             ->AndWhere('p.padre is null');
  2969.         $favoritos_prod= $favoritos_prod->groupBy('p.plu')->getQuery()
  2970.             ->getResult();
  2972.         $favoritos_blog= $this->getDoctrine()->getRepository(FavoritoBlog::class)->createQueryBuilder('p')
  2973.         ->select('p', 'b.id as id','b.titulo as titulo', 'b.created_at as fecha', 'b.imagen_listado as imagen')
  2974.         // ->leftJoin('p.favorito', 'fav')
  2975.         ->leftJoin('p.usuario', 'u')
  2976.         ->leftJoin('p.blog', 'b')
  2977.         ->Where('u.id ='.$user->getId())
  2978.         ->getQuery()
  2979.         ->getResult();
  2981.         return $this->render('home/mis-favoritos.html.twig', [
  2982.             'favoritos_prod'=>$favoritos_prod,
  2983.             'favoritos_blog'=>$favoritos_blog,
  2984.             'user'=>$user,
  2985.             'idprincipal' => $idprincipal = null
  2986.         ]);
  2987.     }
  2990.     /**
  2991.      *  @Method({"POST"})
  2992.      * @Route("/add-favorito-producto/romance/add-favorito-producto/{id}", name="add-favorito-producto")
  2993.      */
  2994.     public function FavoritoProducto(Request $request,$id)
  2995.     {
  2996.         $user=$this->getUser();
  2998.         $mensaje = array('ok' => false, 'msg' => 'Error al agregar');
  2999.         $producto=$this->getDoctrine()->getRepository(Producto::class)->find($id);
  3000.         $favorito=$this->getDoctrine()->getRepository(Favorito::class)->findOneBy(array('producto'=>$producto, 'usuario'=>$user));
  3001.         $em=$this->getDoctrine()->getManager();
  3002.         if($favorito){
  3003.             $em->remove($favorito);
  3004.             $em->flush();
  3005.             $mensaje = array('ok' => false, 'msg' => 'Eliminado');
  3006.         }else{
  3007.             $newfavorito=new Favorito();
  3008.             $newfavorito->setUsuario($user);
  3009.             $newfavorito->setProducto($producto);
  3010.             $em->persist($newfavorito);
  3011.             $em->flush();
  3012.             $mensaje = array('ok' => true, 'msg' => 'agregado');
  3013.         }
  3014.         $response = new Response();
  3015.         $response->setContent(json_encode($mensaje));
  3016.         $response->headers->set('Content-Type', 'application/json');
  3017.         return $response;
  3018.     }
  3020.      /**
  3021.      *  @Method({"POST"})
  3022.      * @Route("/add-favorito-blog/romance/add-favorito-blog/{id}", name="add-favorito-blog")
  3023.      */
  3024.     public function FavoritoBlog(Request $request,$id)
  3025.     {
  3026.         $user=$this->getUser();
  3028.         $mensaje = array('ok' => false, 'msg' => 'Error al agregar');
  3029.         $blog=$this->getDoctrine()->getRepository(Blog::class)->find($id);
  3030.         $favorito=$this->getDoctrine()->getRepository(FavoritoBlog::class)->findOneBy(array('blog'=>$blog, 'usuario'=>$user));
  3031.         $em=$this->getDoctrine()->getManager();
  3032.         if($favorito){
  3033.             $em->remove($favorito);
  3034.             $em->flush();
  3035.             $mensaje = array('ok' => false, 'msg' => 'Eliminado');
  3036.         }else{
  3037.             $newfavorito=new FavoritoBlog();
  3038.             $newfavorito->setUsuario($user);
  3039.             $newfavorito->setBlog($blog);
  3040.             $em->persist($newfavorito);
  3041.             $em->flush();
  3042.             $mensaje = array('ok' => true, 'msg' => 'agregado');
  3043.         }
  3044.         $response = new Response();
  3045.         $response->setContent(json_encode($mensaje));
  3046.         $response->headers->set('Content-Type', 'application/json');
  3047.         return $response;
  3048.     }
  3050.      /**
  3051.      *  @Method({"POST"})
  3052.      * @Route("/cargarfotos/romance/romance/ro", name="cargarfotos")
  3053.      */
  3054.     public function cargarfotos(Request $request)
  3055.     {
  3056.         $em = $this->getDoctrine()->getManager();
  3057.         // $photos=["90071645_1.jpg"];
  3058.         $photos=["90071645_1.jpg","90071645_2.jpg","90076168_1.jpg","90076168_2.jpg","90076168_3.jpg","90076168_4.jpg","90076168_5.jpg","90076168_6.jpg","90076168_7.jpg","90076168_8.jpg","90076168_9.jpg","90076169_1.jpg","90076169_2.jpg","90076169_3.jpg","90076169_4.jpg","90076169_5.jpg","90076169_6.jpg","90076169_7.jpg","90076169_8.jpg","90076169_9.jpg","90076195_1.jpg","90076195_2.jpg","90076195_3.jpg","90076195_4.jpg","90076195_5.jpg","90076195_6.jpg","90076195_7.jpg","90076195_8.jpg","90076195_9.jpg","90076196_1.jpg","90076196_2.jpg","90076196_3.jpg","90076196_4.jpg","90076196_5.jpg","90076196_6.jpg","90076196_7.jpg","90076196_8.jpg","90076196_9.jpg","90077875_1.jpg","90077875_2.jpg","90078512_1.jpg","90078512_2.jpg","90078512_3.jpg","90078512_4.jpg","90078512_5.jpg","90078512_6.jpg","90078512_7.jpg","90078513_1.jpg","90078513_2.jpg","90078513_3.jpg","90078513_4.jpg","90078513_5.jpg","90078513_6.jpg","90078513_7.jpg","90078514_1.jpg","90078514_2.jpg","90078514_3.jpg","90078514_4.jpg","90078514_5.jpg","90078514_6.jpg","90078514_7.jpg","90078515_1.jpg","90078515_2.jpg","90078515_3.jpg","90078515_4.jpg","90078515_5.jpg","90078515_6.jpg","90078515_7.jpg","90078516_1.jpg","90078516_2.jpg","90078516_4.jpg","90078516_5.jpg","90078516_6.jpg","90078516_7.jpg","90078603_1.jpg","90078603_2.jpg","90078694_1.jpg","90078694_2.jpg","90078694_3.jpg","90078694_4.jpg","90078694_5.jpg","90078694_6.jpg","90078694_7.jpg","90078695_1.jpg","90078695_2.jpg","90078695_3.jpg","90078695_4.jpg","90078695_5.jpg","90078695_6.jpg","90078695_7.jpg","90078696_1.jpg","90078696_2.jpg","90078696_3.jpg","90078696_4.jpg","90078696_5.jpg","90078696_6.jpg","90078696_7.jpg","90078697_1.jpg","90078697_2.jpg","90078697_3.jpg","90078697_4.jpg","90078697_5.jpg","90078697_6.jpg","90078697_7.jpg","90078698_1.jpg","90078698_2.jpg","90078698_3.jpg","90078698_4.jpg","90078698_5.jpg","90078698_6.jpg","90078698_7.jpg","90078699_1.jpg","90078699_2.jpg","90078699_3.jpg","90078699_4.jpg","90078699_5.jpg","90078699_6.jpg","90078699_7.jpg","90078700_1.jpg","90078700_2.jpg","90078700_3.jpg","90078700_4.jpg","90078700_5.jpg","90078700_6.jpg","90078700_7.jpg","90078701_1.jpg","90078701_2.jpg","90078701_3.jpg","90078701_4.jpg","90078701_5.jpg","90078701_6.jpg","90078701_7.jpg","90078702_1.jpg","90078702_2.jpg","90078702_3.jpg","90078702_4.jpg","90078702_5.jpg","90078702_6.jpg","90078702_7.jpg","90078703_1.jpg","90078703_2.jpg","90078703_3.jpg","90078703_4.jpg","90078703_5.jpg","90078703_6.jpg","90078703_7.jpg","90080091_1.jpg","90080091_2.jpg","90080091_3.jpg","90080091_4.jpg","90080091_5.jpg","90080091_6.jpg","90080091_7.jpg","90080091_8.jpg","90080091_9.jpg","90080092_1.jpg","90080092_2.jpg","90080092_3.jpg","90080092_4.jpg","90080092_5.jpg","90080092_6.jpg","90080092_7.jpg","90080092_8.jpg","90080092_9.jpg","90080094_1.jpg","90080094_2.jpg","90080094_3.jpg","90080094_4.jpg","90080094_5.jpg","90080094_6.jpg","90080094_7.jpg","90080094_8.jpg","90080094_9.jpg","90080095_1.jpg","90080095_2.jpg","90080095_3.jpg","90080095_4.jpg","90080095_5.jpg","90080095_6.jpg","90080095_7.jpg","90080095_8.jpg","90080095_9.jpg","90080097_1.jpg","90080097_2.jpg","90080097_3.jpg","90080097_4.jpg","90080097_5.jpg","90080097_6.jpg","90080097_7.jpg","90080097_8.jpg","90080097_9.jpg","90080098_1.jpg","90080098_2.jpg","90080098_3.jpg","90080098_4.jpg","90080098_5.jpg","90080098_6.jpg","90080098_7.jpg","90080098_8.jpg","90080098_9.jpg","90080100_1.jpg","90080100_2.jpg","90080100_3.jpg","90080100_4.jpg","90080100_5.jpg","90080100_6.jpg","90080100_7.jpg","90080100_8.jpg","90080100_9.jpg","90080101_1.jpg","90080101_2.jpg","90080101_3.jpg","90080101_4.jpg","90080101_5.jpg","90080101_6.jpg","90080101_7.jpg","90080101_8.jpg","90080101_9.jpg","90080103_1.jpg","90080103_2.jpg","90080103_3.jpg","90080103_4.jpg","90080103_5.jpg","90080103_6.jpg","90080103_7.jpg","90080103_8.jpg","90080103_9.jpg","90080104_1.jpg","90080104_2.jpg","90080104_3.jpg","90080104_4.jpg","90080104_5.jpg","90080104_6.jpg","90080104_7.jpg","90080104_8.jpg","90080104_9.jpg","90080105_1.jpg","90080105_2.jpg","90080106_1.jpg","90080106_2.jpg","90080107_1.jpg","90080107_2.jpg","90080108_1.jpg","90080108_2.jpg","90080109_1.jpg","90080109_2.jpg","90080111_1.jpg","90080111_2.jpg","90080111_3.jpg","90080111_4.jpg","90080111_5.jpg","90080111_6.jpg","90080111_7.jpg","90080111_8.jpg","90080111_9.jpg","90080112_1.jpg","90080112_2.jpg","90080112_3.jpg","90080112_4.jpg","90080112_5.jpg","90080112_6.jpg","90080112_7.jpg","90080112_8.jpg","90080112_9.jpg","90080114_1.jpg","90080114_2.jpg","90080114_3.jpg","90080114_4.jpg","90080114_5.jpg","90080114_6.jpg","90080114_7.jpg","90080114_8.jpg","90080114_9.jpg","90080115_1.jpg","90080115_2.jpg","90080115_3.jpg","90080115_4.jpg","90080115_5.jpg","90080115_6.jpg","90080115_7.jpg","90080115_8.jpg","90080115_9.jpg","90080117_1.jpg","90080117_2.jpg","90080117_3.jpg","90080117_4.jpg","90080117_5.jpg","90080117_6.jpg","90080117_7.jpg","90080117_8.jpg","90080117_9.jpg","90080118_1.jpg","90080118_2.jpg","90080118_3.jpg","90080118_4.jpg","90080118_5.jpg","90080118_6.jpg","90080118_7.jpg","90080118_8.jpg","90080118_9.jpg","90080120_1.jpg","90080120_2.jpg","90080120_3.jpg","90080120_4.jpg","90080120_5.jpg","90080120_6.jpg","90080120_7.jpg","90080120_8.jpg","90080120_9.jpg","90080121_1.jpg","90080121_2.jpg","90080121_3.jpg","90080121_4.jpg","90080121_5.jpg","90080121_6.jpg","90080121_7.jpg","90080121_8.jpg","90080121_9.jpg","90080123_1.jpg","90080123_2.jpg","90080123_3.jpg","90080123_4.jpg","90080123_5.jpg","90080123_6.jpg","90080123_7.jpg","90080123_8.jpg","90080123_9.jpg","90080124_1.jpg","90080124_2.jpg","90080124_3.jpg","90080124_4.jpg","90080124_5.jpg","90080124_6.jpg","90080124_7.jpg","90080124_8.jpg","90080124_9.jpg","90080141_1.jpg","90080141_2.jpg","90080141_3.jpg","90080141_4.jpg","90080141_5.jpg","90080141_6.jpg","90080141_7.jpg","90080141_8.jpg","90080141_9.jpg","90080144_1.jpg","90080144_2.jpg","90080144_3.jpg","90080144_4.jpg","90080144_5.jpg","90080144_6.jpg","90080144_7.jpg","90080144_8.jpg","90080144_9.jpg","90080147_1.jpg","90080147_2.jpg","90080147_3.jpg","90080147_4.jpg","90080147_5.jpg","90080147_6.jpg","90080147_7.jpg","90080147_8.jpg","90080147_9.jpg","90080150_1.jpg","90080150_2.jpg","90080150_3.jpg","90080150_4.jpg","90080150_5.jpg","90080150_6.jpg","90080150_7.jpg","90080150_8.jpg","90080150_9.jpg","90080153_1.jpg","90080153_2.jpg","90080153_3.jpg","90080153_4.jpg","90080153_5.jpg","90080153_6.jpg","90080153_7.jpg","90080153_8.jpg","90080153_9.jpg","90080556_1.jpg","90080556_2.jpg","90080556_3.jpg","90080556_4.jpg","90080556_5.jpg","90080556_6.jpg","90080557_1.jpg","90080557_2.jpg","90080557_3.jpg","90080557_4.jpg","90080557_5.jpg","90080557_6.jpg","90080558_1.jpg","90080558_2.jpg","90080558_3.jpg","90080558_4.jpg","90080558_5.jpg","90080558_6.jpg","90080559_1.jpg","90080559_2.jpg","90080559_3.jpg","90080559_4.jpg","90080559_5.jpg","90080559_6.jpg","90080828_1.jpg","90080828_2.jpg","90080828_3.jpg","90080828_4.jpg","90080828_5.jpg","90080828_6.jpg","90080828_7.jpg","90080830_1.jpg","90080830_2.jpg","90080830_3.jpg","90080830_4.jpg","90080830_5.jpg","90080830_6.jpg","90080830_7.jpg","90080831_1.jpg","90080831_2.jpg","90080831_3.jpg","90080831_4.jpg","90080831_5.jpg","90080831_6.jpg","90080831_7.jpg","90080832_1.jpg","90080832_2.jpg","90080832_3.jpg","90080832_4.jpg","90080832_5.jpg","90080832_6.jpg","90080832_7.jpg","90080833_1.jpg","90080833_2.jpg","90080833_3.jpg","90080833_4.jpg","90080833_5.jpg","90080833_6.jpg","90080833_7.jpg","90080834_1.jpg","90080834_2.jpg","90080834_3.jpg","90080834_4.jpg","90080834_5.jpg","90080834_6.jpg","90080834_7.jpg","90080835_1.jpg","90080835_2.jpg","90080835_3.jpg","90080835_4.jpg","90080835_5.jpg","90080835_6.jpg","90080835_7.jpg","90080836_1.jpg","90080836_2.jpg","90080836_3.jpg","90080836_4.jpg","90080836_5.jpg","90080836_6.jpg","90080836_7.jpg","90080837_1.jpg","90080837_2.jpg","90080837_3.jpg","90080837_4.jpg","90080837_5.jpg","90080837_6.jpg","90080837_7.jpg","90080838_1.jpg","90080838_2.jpg","90080838_3.jpg","90080838_4.jpg","90080838_5.jpg","90080838_6.jpg","90080838_7.jpg","90080839_1.jpg","90080839_2.jpg","90080839_3.jpg","90080839_4.jpg","90080839_5.jpg","90080839_6.jpg","90080839_7.jpg","90080839_8.jpg","90080839_9.jpg","90080840_1.jpg","90080840_2.jpg","90080840_3.jpg","90080840_4.jpg","90080840_5.jpg","90080840_6.jpg","90080840_7.jpg","90080840_8.jpg","90080840_9.jpg","90080841_1.jpg","90080841_2.jpg","90080841_3.jpg","90080841_4.jpg","90080841_5.jpg","90080841_6.jpg","90080841_7.jpg","90080841_8.jpg","90080841_9.jpg","90080842_1.jpg","90080842_2.jpg","90080842_3.jpg","90080842_4.jpg","90080842_5.jpg","90080842_6.jpg","90080842_7.jpg","90080842_8.jpg","90080842_9.jpg","90080843_1.jpg","90080843_2.jpg","90080843_3.jpg","90080843_4.jpg","90080843_5.jpg","90080843_6.jpg","90080843_7.jpg","90080843_8.jpg","90080843_9.jpg","90080844_1.jpg","90080844_2.jpg","90080844_3.jpg","90080844_4.jpg","90080844_5.jpg","90080844_6.jpg","90080844_7.jpg","90080844_8.jpg","90080844_9.jpg","90080845_1.jpg","90080845_2.jpg","90080845_3.jpg","90080845_4.jpg","90080845_5.jpg","90080845_6.jpg","90080845_7.jpg","90080845_8.jpg","90080845_9.jpg","90080846_1.jpg","90080846_2.jpg","90080846_3.jpg","90080846_4.jpg","90080846_5.jpg","90080846_6.jpg","90080846_7.jpg","90080846_8.jpg","90080846_9.jpg","90080847_1.jpg","90080847_2.jpg","90080847_3.jpg","90080847_4.jpg","90080847_5.jpg","90080847_6.jpg","90080847_7.jpg","90080847_8.jpg","90080847_9.jpg","90080848_1.jpg","90080848_2.jpg","90080848_3.jpg","90080848_4.jpg","90080848_5.jpg","90080848_6.jpg","90080848_7.jpg","90080848_8.jpg","90080848_9.jpg","90080849_1.jpg","90080849_2.jpg","90080849_3.jpg","90080849_4.jpg","90080849_5.jpg","90080849_6.jpg","90080849_7.jpg","90080850_1.jpg","90080850_2.jpg","90080850_3.jpg","90080850_4.jpg","90080850_5.jpg","90080850_6.jpg","90080850_7.jpg","90080851_1.jpg","90080851_2.jpg","90080851_3.jpg","90080851_4.jpg","90080851_5.jpg","90080851_6.jpg","90080851_7.jpg","90080852_1.jpg","90080852_2.jpg","90080852_3.jpg","90080852_4.jpg","90080852_5.jpg","90080852_6.jpg","90080852_7.jpg","90080853_1.jpg","90080853_2.jpg","90080853_3.jpg","90080853_4.jpg","90080853_5.jpg","90080853_6.jpg","90080853_7.jpg","90080883_1.jpg","90080883_2.jpg","90080883_3.jpg","90080883_4.jpg","90080883_5.jpg","90080883_6.jpg","90080883_7.jpg","90080883_8.jpg","90080883_9.jpg","90080884_1.jpg","90080884_2.jpg","90080884_3.jpg","90080884_4.jpg","90080884_5.jpg","90080884_6.jpg","90080884_7.jpg","90080884_8.jpg","90080884_9.jpg","90080885_1.jpg","90080885_2.jpg","90080885_3.jpg","90080885_4.jpg","90080885_5.jpg","90080885_6.jpg","90080885_7.jpg","90080885_8.jpg","90080885_9.jpg","90080886_1.jpg","90080886_2.jpg","90080886_3.jpg","90080886_4.jpg","90080886_5.jpg","90080886_6.jpg","90080886_7.jpg","90080886_8.jpg","90080886_9.jpg","90080887_1.jpg","90080887_2.jpg","90080887_3.jpg","90080887_4.jpg","90080887_5.jpg","90080887_6.jpg","90080887_7.jpg","90080887_8.jpg","90080887_9.jpg","90080888_1.jpg","90080888_2.jpg","90080888_3.jpg","90080888_4.jpg","90080888_5.jpg","90080888_6.jpg","90080888_7.jpg","90080888_8.jpg","90080888_9.jpg","90080889_1.jpg","90080889_2.jpg","90080889_3.jpg","90080889_4.jpg","90080889_5.jpg","90080889_6.jpg","90080889_7.jpg","90080889_8.jpg","90080889_9.jpg","90080890_1.jpg","90080890_2.jpg","90080890_3.jpg","90080890_4.jpg","90080890_5.jpg","90080890_6.jpg","90080890_7.jpg","90080890_8.jpg","90080890_9.jpg","90080891_1.jpg","90080891_2.jpg","90080891_3.jpg","90080891_4.jpg","90080891_5.jpg","90080891_6.jpg","90080891_7.jpg","90080891_8.jpg","90080891_9.jpg","90080892_1.jpg","90080892_2.jpg","90080892_3.jpg","90080892_4.jpg","90080892_5.jpg","90080892_6.jpg","90080892_7.jpg","90080892_8.jpg","90080892_9.jpg","90080893_1.jpg","90080893_2.jpg","90080893_3.jpg","90080893_4.jpg","90080893_5.jpg","90080893_6.jpg","90080893_7.jpg","90080893_8.jpg","90080893_9.jpg","90080894_1.jpg","90080894_2.jpg","90080894_3.jpg","90080894_4.jpg","90080894_5.jpg","90080894_6.jpg","90080894_7.jpg","90080894_8.jpg","90080894_9.jpg","90080895_1.jpg","90080895_2.jpg","90080895_3.jpg","90080895_4.jpg","90080895_5.jpg","90080895_6.jpg","90080895_7.jpg","90080895_8.jpg","90080895_9.jpg","90080896_1.jpg","90080896_2.jpg","90080896_3.jpg","90080896_4.jpg","90080896_5.jpg","90080896_6.jpg","90080896_7.jpg","90080896_8.jpg","90080896_9.jpg","90080897_1.jpg","90080897_2.jpg","90080897_3.jpg","90080897_4.jpg","90080897_5.jpg","90080897_6.jpg","90080897_7.jpg","90080897_8.jpg","90080897_9.jpg","90080898_1.jpg","90080898_2.jpg","90080898_3.jpg","90080898_4.jpg","90080898_5.jpg","90080898_6.jpg","90080898_7.jpg","90080898_8.jpg","90080898_9.jpg","90080899_1.jpg","90080899_2.jpg","90080899_3.jpg","90080899_4.jpg","90080899_5.jpg","90080899_6.jpg","90080899_7.jpg","90080899_8.jpg","90080899_9.jpg","90080900_1.jpg","90080900_2.jpg","90080900_3.jpg","90080900_4.jpg","90080900_5.jpg","90080900_6.jpg","90080900_7.jpg","90080900_8.jpg","90080900_9.jpg","90080901_01.jpg","90080901_2.jpg","90080901_3.jpg","90080901_4.jpg","90080901_5.jpg","90080901_6.jpg","90080901_7.jpg","90080901_8.jpg","90080901_9.jpg","90080902_1.jpg","90080902_2.jpg","90080902_3.jpg","90080902_4.jpg","90080902_5.jpg","90080902_6.jpg","90080902_7.jpg","90080902_8.jpg","90080902_9.jpg","90080904_01.jpg","90080904_2.jpg","90080904_3.jpg","90080904_4.jpg","90080904_5.jpg","90080904_6.jpg","90080904_7.jpg","90080904_8.jpg","90080904_9.jpg","90080905_1.jpg","90080905_2.jpg","90080905_3.jpg","90080905_4.jpg","90080905_5.jpg","90080905_6.jpg","90080905_7.jpg","90080905_8.jpg","90080905_9.jpg","90080906_01.jpg","90080906_2.jpg","90080906_3.jpg","90080906_4.jpg","90080906_5.jpg","90080906_6.jpg","90080906_7.jpg","90080906_8.jpg","90080906_9.jpg","90080907_1.jpg","90080907_2.jpg","90080907_3.jpg","90080907_4.jpg","90080907_5.jpg","90080907_6.jpg","90080907_7.jpg","90080907_8.jpg","90080907_9.jpg","90080908_01.jpg","90080908_2.jpg","90080908_3.jpg","90080908_4.jpg","90080908_5.jpg","90080908_6.jpg","90080908_7.jpg","90080908_8.jpg","90080908_9.jpg","90080909_1.jpg","90080909_2.jpg","90080909_3.jpg","90080909_4.jpg","90080909_5.jpg","90080909_6.jpg","90080909_7.jpg","90080909_8.jpg","90080909_9.jpg","90080910_1.jpg","90080910_2.jpg","90080910_3.jpg","90080910_4.jpg","90080910_5.jpg","90080910_6.jpg","90080910_7.jpg","90080910_8.jpg","90080910_9.jpg","90080911_1.jpg","90080911_2.jpg","90080911_3.jpg","90080911_4.jpg","90080911_5.jpg","90080911_6.jpg","90080911_7.jpg","90080911_8.jpg","90080911_9.jpg","90080912_1.jpg","90080912_2.jpg","90080912_3.jpg","90080912_4.jpg","90080912_5.jpg","90080912_6.jpg","90080912_7.jpg","90080912_8.jpg","90080912_9.jpg","90080913_1.jpg","90080913_2.jpg","90080913_3.jpg","90080913_4.jpg","90080913_5.jpg","90080913_6.jpg","90080913_7.jpg","90080913_8.jpg","90080913_9.jpg","90080914_1.jpg","90080914_2.jpg","90080914_3.jpg","90080914_4.jpg","90080914_5.jpg","90080914_6.jpg","90080914_7.jpg","90080914_8.jpg","90080914_9.jpg","90080915_1.jpg","90080915_2.jpg","90080915_3.jpg","90080915_4.jpg","90080915_5.jpg","90080915_6.jpg","90080915_7.jpg","90080915_8.jpg","90080915_9.jpg","90080916_1.jpg","90080916_2.jpg","90080916_3.jpg","90080916_4.jpg","90080916_5.jpg","90080916_6.jpg","90080916_7.jpg","90080916_8.jpg","90080916_9.jpg","90080917_1.jpg","90080917_2.jpg","90080917_3.jpg","90080917_4.jpg","90080917_5.jpg","90080917_6.jpg","90080917_7.jpg","90080917_8.jpg","90080917_9.jpg","90080918_1.jpg","90080918_2.jpg","90080918_3.jpg","90080918_4.jpg","90080918_5.jpg","90080918_6.jpg","90080918_7.jpg","90080918_8.jpg","90080918_9.jpg","90080919_1.jpg","90080919_2.jpg","90080919_3.jpg","90080919_4.jpg","90080919_5.jpg","90080919_6.jpg","90080919_7.jpg","90080919_8.jpg","90080919_9.jpg","90080920_1.jpg","90080920_2.jpg","90080920_3.jpg","90080920_4.jpg","90080920_5.jpg","90080920_6.jpg","90080920_7.jpg","90080920_8.jpg","90080920_9.jpg","90080921_1.jpg","90080921_2.jpg","90080921_3.jpg","90080921_4.jpg","90080921_5.jpg","90080921_6.jpg","90080921_7.jpg","90080921_8.jpg","90080921_9.jpg","90080922_1.jpg","90080922_2.jpg","90080922_3.jpg","90080922_4.jpg","90080922_5.jpg","90080922_6.jpg","90080922_7.jpg","90080922_8.jpg","90080922_9.jpg","90080923_1.jpg","90080923_2.jpg","90080923_3.jpg","90080923_4.jpg","90080923_5.jpg","90080923_6.jpg","90080923_7.jpg","90080923_8.jpg","90080923_9.jpg","90080924_1.jpg","90080924_2.jpg","90080924_3.jpg","90080924_4.jpg","90080924_5.jpg","90080924_6.jpg","90080924_7.jpg","90080924_8.jpg","90080924_9.jpg","90080925_1.jpg","90080925_2.jpg","90080925_3.jpg","90080925_4.jpg","90080925_5.jpg","90080925_6.jpg","90080925_7.jpg","90080925_8.jpg","90080925_9.jpg","90080926_1.jpg","90080926_2.jpg","90080926_3.jpg","90080926_4.jpg","90080926_5.jpg","90080926_6.jpg","90080926_7.jpg","90080926_8.jpg","90080926_9.jpg","90080927_1.jpg","90080927_2.jpg","90080927_3.jpg","90080927_4.jpg","90080927_5.jpg","90080927_6.jpg","90080927_7.jpg","90080927_8.jpg","90080927_9.jpg","90080928_1.jpg","90080928_2.jpg","90080928_3.jpg","90080928_4.jpg","90080928_5.jpg","90080928_6.jpg","90080928_7.jpg","90080928_8.jpg","90080928_9.jpg","90080929_1.jpg","90080929_2.jpg","90080929_3.jpg","90080929_4.jpg","90080929_5.jpg","90080929_6.jpg","90080929_7.jpg","90080929_8.jpg","90080929_9.jpg","90080930_1.jpg","90080930_2.jpg","90080930_3.jpg","90080930_4.jpg","90080930_5.jpg","90080930_6.jpg","90080930_7.jpg","90080930_8.jpg","90080930_9.jpg","90080931_1.jpg","90080931_2.jpg","90080931_3.jpg","90080931_4.jpg","90080931_5.jpg","90080931_6.jpg","90080931_7.jpg","90080931_8.jpg","90080931_9.jpg","90080932_1.jpg","90080932_2.jpg","90080932_3.jpg","90080932_4.jpg","90080932_5.jpg","90080932_6.jpg","90080932_7.jpg","90080932_8.jpg","90080932_9.jpg","90080933_1.jpg","90080933_2.jpg","90080933_3.jpg","90080933_4.jpg","90080933_5.jpg","90080933_6.jpg","90080933_7.jpg","90080933_8.jpg","90080933_9.jpg","90080934_1.jpg","90080934_2.jpg","90080934_3.jpg","90080934_4.jpg","90080934_5.jpg","90080934_6.jpg","90080934_7.jpg","90080934_8.jpg","90080934_9.jpg","90080935_1.jpg","90080935_2.jpg","90080935_3.jpg","90080935_4.jpg","90080935_5.jpg","90080935_6.jpg","90080935_7.jpg","90080935_8.jpg","90080935_9.jpg","90080936_1.jpg","90080936_2.jpg","90080936_3.jpg","90080936_4.jpg","90080936_5.jpg","90080936_6.jpg","90080936_7.jpg","90080936_8.jpg","90080936_9.jpg","90080937_1.jpg","90080937_2.jpg","90080937_3.jpg","90080937_4.jpg","90080937_5.jpg","90080937_6.jpg","90080937_7.jpg","90080937_8.jpg","90080937_9.jpg","90080938_1.jpg","90080938_2.jpg","90080938_3.jpg","90080938_4.jpg","90080938_5.jpg","90080938_6.jpg","90080938_7.jpg","90080938_8.jpg","90080938_9.jpg","90080939_1.jpg","90080939_2.jpg","90080939_3.jpg","90080939_4.jpg","90080939_5.jpg","90080939_6.jpg","90080939_7.jpg","90080939_8.jpg","90080939_9.jpg","90080940_1.jpg","90080940_2.jpg","90080940_3.jpg","90080940_4.jpg","90080940_5.jpg","90080940_6.jpg","90080940_7.jpg","90080940_8.jpg","90080940_9.jpg","90080941_1.jpg","90080941_2.jpg","90080941_3.jpg","90080941_4.jpg","90080941_5.jpg","90080941_6.jpg","90080941_7.jpg","90080941_8.jpg","90080941_9.jpg","90080942_1.jpg","90080942_2.jpg","90080942_3.jpg","90080942_4.jpg","90080942_5.jpg","90080942_6.jpg","90080942_7.jpg","90080942_8.jpg","90080942_9.jpg","90080943_1.jpg","90080943_2.jpg","90080943_3.jpg","90080943_4.jpg","90080943_5.jpg","90080943_6.jpg","90080943_7.jpg","90080943_8.jpg","90080943_9.jpg","90080944_1.jpg","90080944_2.jpg","90080944_3.jpg","90080944_4.jpg","90080944_5.jpg","90080944_6.jpg","90080944_7.jpg","90080944_8.jpg","90080944_9.jpg","90080945_1.jpg","90080945_2.jpg","90080945_3.jpg","90080945_4.jpg","90080945_5.jpg","90080945_6.jpg","90080945_7.jpg","90080945_8.jpg","90080945_9.jpg","90080946_1.jpg","90080946_2.jpg","90080946_3.jpg","90080946_4.jpg","90080946_5.jpg","90080946_6.jpg","90080946_7.jpg","90080946_8.jpg","90080946_9.jpg","90080947_1.jpg","90080947_2.jpg","90080947_3.jpg","90080947_4.jpg","90080947_5.jpg","90080947_6.jpg","90080947_7.jpg","90080947_8.jpg","90080947_9.jpg","90080948_1.jpg","90080948_2.jpg","90080948_3.jpg","90080948_4.jpg","90080948_5.jpg","90080948_6.jpg","90080948_7.jpg","90080948_8.jpg","90080948_9.jpg","90080949_1.jpg","90080949_2.jpg","90080949_3.jpg","90080949_4.jpg","90080949_5.jpg","90080949_6.jpg","90080949_7.jpg","90080949_8.jpg","90080949_9.jpg","90080950_1.jpg","90080950_2.jpg","90080950_3.jpg","90080950_4.jpg","90080950_5.jpg","90080950_6.jpg","90080950_7.jpg","90080950_8.jpg","90080950_9.jpg","90080951_1.jpg","90080951_2.jpg","90080951_3.jpg","90080951_4.jpg","90080951_5.jpg","90080951_6.jpg","90080951_7.jpg","90080951_8.jpg","90080951_9.jpg","90080952_1.jpg","90080952_2.jpg","90080952_3.jpg","90080952_4.jpg","90080952_5.jpg","90080952_6.jpg","90080952_7.jpg","90080952_8.jpg","90080952_9.jpg","90080953_1.jpg","90080953_2.jpg","90080953_3.jpg","90080953_4.jpg","90080953_5.jpg","90080953_6.jpg","90080953_7.jpg","90080953_8.jpg","90080953_9.jpg","90080954_1.jpg","90080954_2.jpg","90080954_3.jpg","90080954_4.jpg","90080954_5.jpg","90080954_6.jpg","90080954_7.jpg","90080954_8.jpg","90080954_9.jpg","90080955_1.jpg","90080955_2.jpg","90080955_3.jpg","90080955_4.jpg","90080955_5.jpg","90080955_6.jpg","90080955_7.jpg","90080955_8.jpg","90080955_9.jpg","90080956_1.jpg","90080956_2.jpg","90080956_3.jpg","90080956_4.jpg","90080956_5.jpg","90080956_6.jpg","90080956_7.jpg","90080956_8.jpg","90080956_9.jpg","90080957_1.jpg","90080957_2.jpg","90080957_3.jpg","90080957_4.jpg","90080957_5.jpg","90080957_6.jpg","90080957_7.jpg","90080957_8.jpg","90080957_9.jpg","90080958_1.jpg","90080958_2.jpg","90080958_3.jpg","90080958_4.jpg","90080958_5.jpg","90080958_6.jpg","90080958_7.jpg","90080958_8.jpg","90080958_9.jpg","90080959_1.jpg","90080959_2.jpg","90080959_3.jpg","90080959_4.jpg","90080959_5.jpg","90080959_6.jpg","90080959_7.jpg","90080959_8.jpg","90080959_9.jpg","90080960_1.jpg","90080960_2.jpg","90080960_3.jpg","90080960_4.jpg","90080960_5.jpg","90080960_6.jpg","90080960_7.jpg","90080960_8.jpg","90080960_9.jpg","90080961_1.jpg","90080961_2.jpg","90080961_3.jpg","90080961_4.jpg","90080961_5.jpg","90080961_6.jpg","90080961_7.jpg","90080961_8.jpg","90080961_9.jpg","90080962_1.jpg","90080962_2.jpg","90080962_3.jpg","90080962_4.jpg","90080962_5.jpg","90080962_6.jpg","90080962_7.jpg","90080962_8.jpg","90080962_9.jpg","90080963_1.jpg","90080963_2.jpg","90080963_3.jpg","90080963_4.jpg","90080963_5.jpg","90080963_6.jpg","90080963_7.jpg","90080963_8.jpg","90080963_9.jpg","90080964_1.jpg","90080964_2.jpg","90080964_3.jpg","90080964_4.jpg","90080964_5.jpg","90080964_6.jpg","90080964_7.jpg","90080964_8.jpg","90080964_9.jpg","90080965_1.jpg","90080965_2.jpg","90080965_3.jpg","90080965_4.jpg","90080965_5.jpg","90080965_6.jpg","90080965_7.jpg","90080965_8.jpg","90080965_9.jpg","90080966_1.jpg","90080966_2.jpg","90080966_3.jpg","90080966_4.jpg","90080966_5.jpg","90080966_6.jpg","90080966_7.jpg","90080966_8.jpg","90080966_9.jpg","90080970_1.jpg","90080970_2.jpg","90080970_3.jpg","90080970_4.jpg","90080970_5.jpg","90080970_6.jpg","90080970_7.jpg","90080970_8.jpg","90080970_9.jpg","90080971_1.jpg","90080971_2.jpg","90080971_3.jpg","90080971_4.jpg","90080971_5.jpg","90080971_6.jpg","90080971_7.jpg","90080971_8.jpg","90080971_9.jpg"];
  3060.         $productos=$this->getDoctrine()->getRepository(Producto::class)->findall();
  3061.         $prods=[];
  3062.         foreach( $productos as $prod){
  3063.             $prods[$prod->getPlu()]=$prod;
  3064.         }
  3065.         foreach($photos as $ph){
  3066.             $id_index=explode("_",$ph);  
  3067.             // dd('entró a un foreach',$id_index[1]);
  3068.             $sku=$id_index[0];
  3069.             /* @var $producto Producto */
  3070.             $producto=$prods[$sku];
  3071.             $image_path="https://firebasestorage.googleapis.com/v0/b/romancerelax-2021.appspot.com/o/app_images%2F".$ph."?alt=media";
  3072.             if($id_index[1]=="1.jpg"){
  3073.                 // dd('entró a este if');
  3074.                 // $imagencargada=$producto->setImagen();
  3075.                 // if(!$imagencargada){
  3076.                     $producto->setImagen($image_path);
  3077.                     $em->persist($producto);
  3078.                 // }
  3079.             }else{
  3080.                 $image = new Image();
  3081.                 /* @Var $image Image */
  3082.                 $image->setImage($image_path);
  3083.                 $image->setProducto($producto);
  3084.                 $em->persist($image);             
  3085.             }
  3086.             $em->flush();
  3087.         }
  3089.     }
  3091.     /**
  3092.      * @Route("/ajaxdesplegable/{categoria}/romance/romancerelax", name="ajaxdesplegable")
  3093.      */
  3094.     public function ajaxdesplegable(Request $request, $categoria)
  3095.     {
  3096.         // dd($categoria);
  3097.         $categoria=$this->getDoctrine()->getRepository(Categoria::class)->find($categoria);
  3098.         // dd($categoria);
  3099.         return $this->render('basic/busqueda2.html.twig', [
  3100.             'cat'=>$categoria
  3101.         ]);
  3103.         
  3104.     }
  3106.     /**
  3107.      * @Route("/api/ciudades/ro/ro")
  3108.      * @Method({"POST"})
  3109.      */
  3110.     public function getCiudades(Request $request)
  3111.     {
  3112.         $content = $request->getContent();
  3113.         $request_get = json_decode($content, true);
  3114.  
  3115.         $departamento_id = $request_get["departamento"];
  3117.         $ciudades = $this->getDoctrine()->getRepository(Ciudad::class)->createQueryBuilder('c')
  3118.             ->select('c.id', 'c.nombre')
  3119.             ->leftJoin('c.departamento', 'd')
  3120.             ->where('d.id = :departamentoid')
  3121.             ->setParameter('departamentoid', $departamento_id)
  3122.             ->orderBy('c.nombre', 'asc')
  3123.             ->getQuery()
  3124.             ->getArrayResult();
  3126.         return new Response(json_encode($ciudades));
  3127.     }
  3129.     /**
  3130.      * @Route("/validaremailregister/romance/romancevalida")
  3131.      */
  3132.     public function validaremailregister(Request $request)
  3133.     {
  3136.         $body = json_decode($request->getContent(), true);
  3137.         /* @var $user Usuario */
  3138.         $user = $body['email'];
  3141.         $usuario=$this->getDoctrine()->getRepository(Usuario::class)->findOneBy(array('email'=>$user));
  3142.         
  3143.         if($usuario){
  3144.             $msg = array('ok'=>false,'mensaje'=>"La dirección de correo electrónico ya está en uso por otra cuenta");
  3146.         }else{
  3147.             $msg = array('ok'=>true);
  3149.         }
  3150.         return new Response(json_encode($msg));
  3152.     }
  3154.     /**
  3155.      * @Route("/enviosuscripcion/ro/rom", name="enviosuscripcion")
  3156.      */
  3157.     public function enviosuscripcion(Request $request)
  3158.     {
  3159.         $mensaje = array("ok" => false, "mensaje" => "error");
  3161.         $email=$request->get("email");
  3163.         $mensaje["ok"] = true;
  3164.         $mensaje["mensaje"] = "Suscripcion realizada.";
  3166.         $asunto = "Suscripcion al Blog - Romance Relax.";
  3167.         $html = $this->renderView('contact/suscrip_mail.html.twig', array(
  3168.             'email'=>$email,
  3169.         ));
  3171.         $this->qi->sendMail($asunto,$email,$html);
  3172.         $to = $this->qi->getSetting('mail_recepcion_pedidos');
  3173.         $this->qi->sendMail($asunto,$to,$html);
  3175.         return new JsonResponse($mensaje);
  3176.     }
  3178. }