src/SiteBundle/Controller/SiteController.php line 147

Open in your IDE?
  1. <?php
  3. namespace SiteBundle\Controller;
  5. use PanelBundle\Controller\BaseController;
  6. use PanelBundle\Entity\FormKayit;
  7. use PanelBundle\Entity\Rezervasyon;
  8. use Symfony\Bundle\FrameworkBundle\Controller\Controller;
  9. use Symfony\Component\HttpFoundation\Request;
  10. use Symfony\Component\HttpFoundation\Response;
  12. class SiteController extends BaseController
  13. {
  14.     public function indexAction($dil='')
  15.     {
  16.         $em = $this->getDoctrine()->getManager();
  18.         if($dil==''){
  19.             $qb = $em->createQueryBuilder();
  20.             $dill=$qb->select('d.id,d.kisa,d.uzun')
  21.                 ->from('PanelBundle:Dil', 'd')
  22.                 ->where('d.varsayilan=1 and d.aktif=1')
  23.                 ->orderBy('d.aktif','DESC')
  24.                 ->getQuery()
  25.                 ->getScalarResult();
  26.             $dil = $dill[0]['id'];
  27.             $this->get('session')->set('dil',$dill[0]);
  28.         }else{
  29.             $qb = $em->createQueryBuilder();
  30.             $dill=$qb->select('d.id,d.kisa,d.uzun')
  31.                 ->from('PanelBundle:Dil', 'd')
  32.                 ->where("d.kisa='$dil' and d.aktif=1")
  33.                 ->orderBy('d.aktif','DESC')
  34.                 ->getQuery()
  35.                 ->getScalarResult();
  36.             if(count($dill)>0){
  37.                 $dil = $dill[0]['id'];
  38.                 $this->get('session')->set('dil',$dill[0]);
  39.             }else{
  40.                return $this->redirect($this->ayarlar('siteYolu'));
  41.             }
  42.         }
  48.         return $this->render('@Site/Sites/index.html.twig');
  49.     }
  51.     public function sayfaAction($dil='',$seo1,$seo2='',$seo3='',$seo4='',$seo5='',$seo6='',$seo7='',$seo8='',$seo9='',$seo10='',$seo11='',$seo12='',$seo13='',$seo14='',$seo15=''){
  52.         $em = $this->getDoctrine()->getManager();
  53.         if($dil==''){
  54.             $qb = $em->createQueryBuilder();
  55.             $dill=$qb->select('d.id,d.kisa,d.uzun')
  56.                 ->from('PanelBundle:Dil', 'd')
  57.                 ->where('d.varsayilan=1 and d.aktif=1')
  58.                 ->orderBy('d.aktif','DESC')
  59.                 ->getQuery()
  60.                 ->getScalarResult();
  61.             $dil = $dill[0]['id'];
  62.             $this->get('session')->set('dil',$dill[0]);
  63.         }else{
  64.             $qb = $em->createQueryBuilder();
  65.             $dill=$qb->select('d.id,d.kisa,d.uzun')
  66.                 ->from('PanelBundle:Dil', 'd')
  67.                 ->where("d.kisa='$dil' and d.aktif=1")
  68.                 ->orderBy('d.aktif','DESC')
  69.                 ->getQuery()
  70.                 ->getScalarResult();
  71.             if(count($dill)>0){
  72.                 $dil = $dill[0]['id'];
  73.                 $this->get('session')->set('dil',$dill[0]);
  74.             }else{
  75.                 return $this->redirect($this->ayarlar('siteYolu'));
  76.             }
  77.         }
  79.         $suankiDil = $this->get('session')->get('dil');
  81.        /* if($suankiDil['kisa']!=$dil){
  82.             return $this->redirect($this->ayarlar('siteYolu'));
  83.         }*/
  86.         $qb = $em->createQueryBuilder();
  87.         $sayfa=$qb->select('s.id,s.adi,s.bannerDurum,s.bannerUrl,s.title,s.keywords,s.description,s.dilgrup,s.seo,s.kategori,s.tekVeri,s.icIcerik,m.tabloAdi,m.alan,s.description,m.adi as madi')
  88.             ->from('PanelBundle:Sayfa', 's')
  89.             ->join('s.dil', 'd')
  90.             ->join('s.modul', 'm')
  91.             ->where("s.seo ='$seo1' and d.id=".$suankiDil['id'])
  92.             ->orderBy('s.sira','ASC')
  93.             ->getQuery()
  94.             ->getScalarResult();
  97.      /*   if(count($sayfa)==0){
  98.             return $this->redirect($this->ayarlar('siteYolu'));
  99.         }*/
  101.         $sayfa = $sayfa[0];
  103.         $sayfaAlan = explode(',', $sayfa['alan']);
  104.         $icerikalani = [];
  105.         foreach ($sayfaAlan as $sA) {
  106.             $icerikalani[] = 't.'.$this->seo(str_replace(' ', '', $sA));
  107.         }
  110.         $view = $this->seo(str_replace(' ','',$sayfa['madi']));
  112.         if(empty($seo2)){
  113.             $qb = $em->createQueryBuilder();
  114.             $villa_kategoriler = $qb->select('k.dilgrup,k.adi,k.seourl,k.sayfabasligi,k.anahtarkelimeler,k.sayfaaciklamasi,k.ustid,k.resim')
  115.                 ->from('PanelBundle:VillaKategori', 'k')
  116.                 ->join('k.dil', 'd')
  117.                 ->where("k.seourl='$seo1' and k.ustid=0 and d.id=" . $suankiDil['id'])
  118.                 ->orderBy('k.sira', 'ASC')
  119.                 ->getQuery()
  120.                 ->getScalarResult();
  121.             if(count($villa_kategoriler)>0){
  122.                 $qb = $em->createQueryBuilder();
  123.                 $villa_kategorileri = $qb->select('k.dilgrup,k.adi,k.seourl,k.sayfabasligi,k.anahtarkelimeler,k.sayfaaciklamasi,k.ustid,k.resim')
  124.                     ->from('PanelBundle:VillaKategori', 'k')
  125.                     ->join('k.dil', 'd')
  126.                     ->where("k.ustid='".$villa_kategoriler[0]['dilgrup']."' and d.id=" . $suankiDil['id'])
  127.                     ->orderBy('k.sira', 'ASC')
  128.                     ->getQuery()
  129.                     ->getScalarResult();
  131.                 return $this->render('@Site/Sites/ilanKategori.html.twig',array('kategori'=>$villa_kategoriler[0],'kategoriler'=>$villa_kategorileri));
  132.             }else{
  133.                 $qb = $em->createQueryBuilder();
  134.                 $ilan = $qb->select('i.id,i.adi,i.title,i.seo,i.keywords,i.description,i.metin,i.girisTarihi,i.cikisTarihi,i.depozito,i.temizlik,i.havuzbahceBakim,i.konum,i.kisi,i.yatak,i.banyo,i.dilgrup,i.kategoriId,i.resimler,i.durum,i.ozellikler,i.yasaklar,i.il,i.ilce,i.semt')
  135.                     ->from('PanelBundle:Villa', 'i')
  136.                     ->join('i.dil', 'd')
  137.                     ->where("i.seo='" .$seo1. "' and d.id=" . $suankiDil['id'])
  138.                     ->orderBy('i.id', 'DESC')
  139.                     ->getQuery()
  140.                     ->getScalarResult();
  141.                 if(count($ilan)>0) {
  142.                     return $this->render('@Site/Sites/ilan.html.twig', array('ilan' => $ilan[0]));
  143.                 }
  144.             }
  146.             //Sayfa
  147.             if($sayfa['kategori']==0){
  148.                 $qb = $em->createQueryBuilder();
  149.                 $icerikler = $qb->select(implode(',',$icerikalani).',t.dilgrup,t.kategoriId,d.id as did,t.sayfaId')
  150.                     ->from('PanelBundle:' . $sayfa['tabloAdi'], 't')
  151.                     ->join('t.dil', 'd')
  152.                     ->where("t.sayfaId='" .$sayfa['dilgrup']. "' and d.id=" . $suankiDil['id'])
  153.                     ->addOrderBy('t.sira', 'ASC')
  154.                     ->addOrderBy('t.id', 'DESC')
  155.                     ->getQuery()
  156.                     ->getScalarResult();
  157.             }
  158.             else{
  159.                 $qb = $em->createQueryBuilder();
  160.                 $kategoriler = $qb->select('k.dilgrup,k.adi,k.seourl,k.sayfabasligi,k.anahtarkelimeler,k.sayfaaciklamasi,k.ustid,k.resim,k.sayfaId')
  161.                     ->from('PanelBundle:Kategori', 'k')
  162.                     ->join('k.dil', 'd')
  163.                     ->where("k.sayfaId='" .$sayfa['dilgrup']. "' and k.ustid=0 and d.id=" . $suankiDil['id'])
  164.                     ->orderBy('k.sira', 'ASC')
  165.                     ->getQuery()
  166.                     ->getScalarResult();
  167.             }
  168.             return $this->render('@Site/Sites/'.$view.'.html.twig',array('sayfa'=>$sayfa,'kategoriler'=>$kategoriler,'icerikler'=>$icerikler));
  169.         }
  170.         else{
  171.             if(empty($seo3)){
  172.                 $qb = $em->createQueryBuilder();
  173.                 $villa_kategoriler = $qb->select('k.dilgrup,k.adi,k.seourl,k.sayfabasligi,k.anahtarkelimeler,k.sayfaaciklamasi,k.ustid,k.resim')
  174.                     ->from('PanelBundle:VillaKategori', 'k')
  175.                     ->join('k.dil', 'd')
  176.                     ->where("k.seourl='$seo2' and d.id=" . $suankiDil['id'])
  177.                     ->orderBy('k.sira', 'ASC')
  178.                     ->getQuery()
  179.                     ->getScalarResult();
  180.                 if(count($villa_kategoriler)>0){
  181.                     $qb = $em->createQueryBuilder();
  182.                     $villa_kategorileri = $qb->select('k.dilgrup,k.adi,k.seourl,k.sayfabasligi,k.anahtarkelimeler,k.sayfaaciklamasi,k.ustid,k.resim')
  183.                         ->from('PanelBundle:VillaKategori', 'k')
  184.                         ->join('k.dil', 'd')
  185.                         ->where("k.ustid='".$villa_kategoriler[0]['dilgrup']."' and d.id=" . $suankiDil['id'])
  186.                         ->orderBy('k.sira', 'ASC')
  187.                         ->getQuery()
  188.                         ->getScalarResult();
  190.                     return $this->render('@Site/Sites/ilanKategori.html.twig',array('kategori'=>$villa_kategoriler[0],'kategoriler'=>$villa_kategorileri));
  191.                 }else{
  192.                     $qb = $em->createQueryBuilder();
  193.                     $ilan = $qb->select('i.id,i.adi,i.title,i.seo,i.keywords,i.description,i.metin,i.girisTarihi,i.cikisTarihi,i.depozito,i.temizlik,i.havuzbahceBakim,i.konum,i.kisi,i.yatak,i.banyo,i.dilgrup,i.kategoriId,i.resimler,i.durum,i.ozellikler,i.yasaklar,i.il,i.ilce,i.semt')
  194.                         ->from('PanelBundle:Villa', 'i')
  195.                         ->join('i.dil', 'd')
  196.                         ->where("i.seo='" .$seo2. "' and d.id=" . $suankiDil['id'])
  197.                         ->orderBy('i.id', 'DESC')
  198.                         ->getQuery()
  199.                         ->getScalarResult();
  200.                     if(count($ilan)>0) {
  201.                         return $this->render('@Site/Sites/ilan.html.twig', array('ilan' => $ilan[0]));
  202.                     }
  203.                 }
  204.                 if($sayfa['kategori']==0) {
  205.                     // Sayfa İçi
  206.                     $qb = $em->createQueryBuilder();
  207.                     $icerik = $qb->select(implode(',',$icerikalani).',t.dilgrup,t.kategoriId,d.id as did,t.sayfaId')
  208.                         ->from('PanelBundle:' . $sayfa['tabloAdi'], 't')
  209.                         ->join('t.dil', 'd')
  210.                         ->where("t.seourl='" .$seo2. "' and d.id=" . $suankiDil['id'])
  211.                         ->addOrderBy('t.sira', 'ASC')
  212.                         ->addOrderBy('t.id', 'DESC')
  213.                         ->getQuery()
  214.                         ->getScalarResult();
  215.                     if(count($icerik)==0){
  216.                         return $this->redirect($this->ayarlar('siteYolu'));
  217.                     }
  218.                     return $this->render('@Site/Sites/'.$view.'_ic.html.twig',array('sayfa'=>$sayfa,'icerik'=>$icerik[0]));
  219.                 }
  220.                 else{
  222.                     $qb = $em->createQueryBuilder();
  223.                     $kategori = $qb->select('k.dilgrup,k.adi,k.seourl,k.sayfabasligi,k.anahtarkelimeler,k.sayfaaciklamasi,k.ustid,k.resim,k.sayfaId')
  224.                         ->from('PanelBundle:Kategori', 'k')
  225.                         ->join('k.dil', 'd')
  226.                         ->where("k.seourl='" .$seo2. "' and d.id=" . $suankiDil['id'])
  227.                         ->orderBy('k.sira', 'ASC')
  228.                         ->getQuery()
  229.                         ->getScalarResult();
  231.                     if(count($kategori)==0){
  232.                         $qb = $em->createQueryBuilder();
  233.                         $kategori = $qb->select('k.dilgrup,k.adi,k.seourl,k.sayfabasligi,k.anahtarkelimeler,k.sayfaaciklamasi,k.ustid,k.resim,k.sayfaId')
  234.                             ->from('PanelBundle:Kategori', 'k')
  235.                             ->join('k.dil', 'd')
  236.                             ->where("k.seourl='" .$seo1. "' and d.id=" . $suankiDil['id'])
  237.                             ->orderBy('k.sira', 'ASC')
  238.                             ->getQuery()
  239.                             ->getScalarResult();
  242.                         $qb = $em->createQueryBuilder();
  243.                         $icerik = $qb->select(implode(',', $icerikalani) . ',t.dilgrup,t.kategoriId,d.id as did,t.sayfaId')
  244.                             ->from('PanelBundle:' . $sayfa['tabloAdi'], 't')
  245.                             ->join('t.dil', 'd')
  246.                             ->where("t.kategoriId=" . $kategori[0]['dilgrup'] . " and t.seourl='".$seo2."' and d.id=" . $suankiDil['id'])
  247.                             ->addOrderBy('t.sira', 'ASC')
  248.                             ->addOrderBy('t.id', 'DESC')
  249.                             ->getQuery()
  250.                             ->getScalarResult();
  252.                         if(count($kategori)<1 and count($icerik)<1){
  253.                             return $this->redirect($this->ayarlar('siteYolu'));
  254.                         }
  256.                         return $this->render('@Site/Sites/' . $view . '_ic.html.twig', array('sayfa' => $sayfa, 'kategori' => $kategori[0], 'icerik' => $icerik[0]));
  258.                     } else {
  259.                         $qb = $em->createQueryBuilder();
  260.                         $kategoriler = $qb->select('k.dilgrup,k.adi,k.seourl,k.sayfabasligi,k.anahtarkelimeler,k.sayfaaciklamasi,k.ustid,k.resim,k.sayfaId')
  261.                             ->from('PanelBundle:Kategori', 'k')
  262.                             ->join('k.dil', 'd')
  263.                             ->where("k.ustid=" . $kategori[0]['dilgrup'] . " and d.id=" . $suankiDil['id'])
  264.                             ->orderBy('k.sira', 'ASC')
  265.                             ->getQuery()
  266.                             ->getScalarResult();
  268.                         $qb = $em->createQueryBuilder();
  269.                         $icerikler = $qb->select(implode(',', $icerikalani) . ',t.dilgrup,t.kategoriId,d.id as did,t.sayfaId')
  270.                             ->from('PanelBundle:' . $sayfa['tabloAdi'], 't')
  271.                             ->join('t.dil', 'd')
  272.                             ->where("t.kategoriId=" . $kategori[0]['dilgrup'] . " and d.id=" . $suankiDil['id'])
  273.                             ->addOrderBy('t.sira', 'ASC')
  274.                             ->addOrderBy('t.id', 'DESC')
  275.                             ->getQuery()
  276.                             ->getScalarResult();
  279.                         return $this->render('@Site/Sites/' . $view . '_kategori.html.twig', array('sayfa' => $sayfa, 'kategori' => $kategori[0], 'icerikler' => $icerikler, 'kategoriler' => $kategoriler));
  281.                     }
  282.                 }
  283.             }
  284.             elseif(empty($seo4)){
  285.                 $qb = $em->createQueryBuilder();
  286.                 $villa_kategoriler = $qb->select('k.dilgrup,k.adi,k.seourl,k.sayfabasligi,k.anahtarkelimeler,k.sayfaaciklamasi,k.ustid,k.resim')
  287.                     ->from('PanelBundle:VillaKategori', 'k')
  288.                     ->join('k.dil', 'd')
  289.                     ->where("k.seourl='$seo3' and d.id=" . $suankiDil['id'])
  290.                     ->orderBy('k.sira', 'ASC')
  291.                     ->getQuery()
  292.                     ->getScalarResult();
  293.                 if(count($villa_kategoriler)>0){
  294.                     $qb = $em->createQueryBuilder();
  295.                     $villa_kategorileri = $qb->select('k.dilgrup,k.adi,k.seourl,k.sayfabasligi,k.anahtarkelimeler,k.sayfaaciklamasi,k.ustid,k.resim')
  296.                         ->from('PanelBundle:VillaKategori', 'k')
  297.                         ->join('k.dil', 'd')
  298.                         ->where("k.ustid='".$villa_kategoriler[0]['dilgrup']."' and d.id=" . $suankiDil['id'])
  299.                         ->orderBy('k.sira', 'ASC')
  300.                         ->getQuery()
  301.                         ->getScalarResult();
  303.                     return $this->render('@Site/Sites/ilanKategori.html.twig',array('kategori'=>$villa_kategoriler[0],'kategoriler'=>$villa_kategorileri));
  304.                 }else{
  305.                     $qb = $em->createQueryBuilder();
  306.                     $ilan = $qb->select('i.id,i.adi,i.title,i.seo,i.keywords,i.description,i.metin,i.girisTarihi,i.cikisTarihi,i.depozito,i.temizlik,i.havuzbahceBakim,i.konum,i.kisi,i.yatak,i.banyo,i.dilgrup,i.kategoriId,i.resimler,i.durum,i.ozellikler,i.yasaklar,i.il,i.ilce,i.semt')
  307.                         ->from('PanelBundle:Villa', 'i')
  308.                         ->join('i.dil', 'd')
  309.                         ->where("i.seo='" .$seo3. "' and d.id=" . $suankiDil['id'])
  310.                         ->orderBy('i.id', 'DESC')
  311.                         ->getQuery()
  312.                         ->getScalarResult();
  313.                     if(count($ilan)>0) {
  314.                         return $this->render('@Site/Sites/ilan.html.twig', array('ilan' => $ilan[0]));
  315.                     }
  316.                 }
  317.                 if($sayfa['kategori']==0) {
  318.                     // Sayfa İçi
  319.                     $qb = $em->createQueryBuilder();
  320.                     $icerik = $qb->select(implode(',',$icerikalani).',t.dilgrup,t.kategoriId,d.id as did,t.sayfaId')
  321.                         ->from('PanelBundle:' . $sayfa['tabloAdi'], 't')
  322.                         ->join('t.dil', 'd')
  323.                         ->where("t.seourl='" .$seo3. "' and d.id=" . $suankiDil['id'])
  324.                         ->addOrderBy('t.sira', 'ASC')
  325.                         ->addOrderBy('t.id', 'DESC')
  326.                         ->getQuery()
  327.                         ->getScalarResult();
  328.                     if(count($icerik)==0){
  329.                         return $this->redirect($this->ayarlar('siteYolu'));
  330.                     }
  331.                     return $this->render('@Site/Sites/'.$view.'_ic.html.twig',array('sayfa'=>$sayfa,'icerik'=>$icerik[0]));
  332.                 }
  333.                 else{
  335.                     $qb = $em->createQueryBuilder();
  336.                     $kategori = $qb->select('k.dilgrup,k.adi,k.seourl,k.sayfabasligi,k.anahtarkelimeler,k.sayfaaciklamasi,k.ustid,k.resim,k.sayfaId')
  337.                         ->from('PanelBundle:Kategori', 'k')
  338.                         ->join('k.dil', 'd')
  339.                         ->where("k.seourl='" .$seo3. "' and d.id=" . $suankiDil['id'])
  340.                         ->orderBy('k.sira', 'ASC')
  341.                         ->getQuery()
  342.                         ->getScalarResult();
  344.                     if(count($kategori)==0){
  345.                         $qb = $em->createQueryBuilder();
  346.                         $kategori = $qb->select('k.dilgrup,k.adi,k.seourl,k.sayfabasligi,k.anahtarkelimeler,k.sayfaaciklamasi,k.ustid,k.resim,k.sayfaId')
  347.                             ->from('PanelBundle:Kategori', 'k')
  348.                             ->join('k.dil', 'd')
  349.                             ->where("k.seourl='" .$seo2. "' and d.id=" . $suankiDil['id'])
  350.                             ->orderBy('k.sira', 'ASC')
  351.                             ->getQuery()
  352.                             ->getScalarResult();
  355.                         $qb = $em->createQueryBuilder();
  356.                         $icerik = $qb->select(implode(',', $icerikalani) . ',t.dilgrup,t.kategoriId,d.id as did,t.sayfaId')
  357.                             ->from('PanelBundle:' . $sayfa['tabloAdi'], 't')
  358.                             ->join('t.dil', 'd')
  359.                             ->where("t.kategoriId=" . $kategori[0]['dilgrup'] . " and t.seourl='".$seo3."' and d.id=" . $suankiDil['id'])
  360.                             ->addOrderBy('t.sira', 'ASC')
  361.                             ->addOrderBy('t.id', 'DESC')
  362.                             ->getQuery()
  363.                             ->getScalarResult();
  365.                         if(count($kategori)<1 and count($icerik)<1){
  366.                             return $this->redirect($this->ayarlar('siteYolu'));
  367.                         }
  369.                         return $this->render('@Site/Sites/' . $view . '_ic.html.twig', array('sayfa' => $sayfa, 'kategori' => $kategori[0], 'icerik' => $icerik[0]));
  371.                     } else {
  372.                         $qb = $em->createQueryBuilder();
  373.                         $kategoriler = $qb->select('k.dilgrup,k.adi,k.seourl,k.sayfabasligi,k.anahtarkelimeler,k.sayfaaciklamasi,k.ustid,k.resim,k.sayfaId')
  374.                             ->from('PanelBundle:Kategori', 'k')
  375.                             ->join('k.dil', 'd')
  376.                             ->where("k.ustid=" . $kategori[0]['dilgrup'] . " and d.id=" . $suankiDil['id'])
  377.                             ->orderBy('k.sira', 'ASC')
  378.                             ->getQuery()
  379.                             ->getScalarResult();
  381.                         $qb = $em->createQueryBuilder();
  382.                         $icerikler = $qb->select(implode(',', $icerikalani) . ',t.dilgrup,t.kategoriId,d.id as did,t.sayfaId')
  383.                             ->from('PanelBundle:' . $sayfa['tabloAdi'], 't')
  384.                             ->join('t.dil', 'd')
  385.                             ->where("t.kategoriId=" . $kategori[0]['dilgrup'] . " and d.id=" . $suankiDil['id'])
  386.                             ->addOrderBy('t.sira', 'ASC')
  387.                             ->addOrderBy('t.id', 'DESC')
  388.                             ->getQuery()
  389.                             ->getScalarResult();
  392.                         return $this->render('@Site/Sites/' . $view . '_kategori.html.twig', array('sayfa' => $sayfa, 'kategori' => $kategori[0], 'icerikler' => $icerikler, 'kategoriler' => $kategoriler));
  394.                     }
  395.                 }
  396.             }
  397.             elseif(empty($seo5)){
  398.                 $qb = $em->createQueryBuilder();
  399.                 $villa_kategoriler = $qb->select('k.dilgrup,k.adi,k.seourl,k.sayfabasligi,k.anahtarkelimeler,k.sayfaaciklamasi,k.ustid,k.resim')
  400.                     ->from('PanelBundle:VillaKategori', 'k')
  401.                     ->join('k.dil', 'd')
  402.                     ->where("k.seourl='$seo4' and d.id=" . $suankiDil['id'])
  403.                     ->orderBy('k.sira', 'ASC')
  404.                     ->getQuery()
  405.                     ->getScalarResult();
  406.                 if(count($villa_kategoriler)>0){
  407.                     $qb = $em->createQueryBuilder();
  408.                     $villa_kategorileri = $qb->select('k.dilgrup,k.adi,k.seourl,k.sayfabasligi,k.anahtarkelimeler,k.sayfaaciklamasi,k.ustid,k.resim')
  409.                         ->from('PanelBundle:VillaKategori', 'k')
  410.                         ->join('k.dil', 'd')
  411.                         ->where("k.ustid='".$villa_kategoriler[0]['dilgrup']."' and d.id=" . $suankiDil['id'])
  412.                         ->orderBy('k.sira', 'ASC')
  413.                         ->getQuery()
  414.                         ->getScalarResult();
  416.                     return $this->render('@Site/Sites/ilanKategori.html.twig',array('kategori'=>$villa_kategoriler[0],'kategoriler'=>$villa_kategorileri));
  417.                 }else{
  418.                     $qb = $em->createQueryBuilder();
  419.                     $ilan = $qb->select('i.id,i.adi,i.title,i.seo,i.keywords,i.description,i.metin,i.girisTarihi,i.cikisTarihi,i.depozito,i.temizlik,i.havuzbahceBakim,i.konum,i.kisi,i.yatak,i.banyo,i.dilgrup,i.kategoriId,i.resimler,i.durum,i.ozellikler,i.yasaklar,i.il,i.ilce,i.semt')
  420.                         ->from('PanelBundle:Villa', 'i')
  421.                         ->join('i.dil', 'd')
  422.                         ->where("i.seo='" .$seo4. "' and d.id=" . $suankiDil['id'])
  423.                         ->orderBy('i.id', 'DESC')
  424.                         ->getQuery()
  425.                         ->getScalarResult();
  426.                     if(count($ilan)>0) {
  427.                         return $this->render('@Site/Sites/ilan.html.twig', array('ilan' => $ilan[0]));
  428.                     }
  429.                 }
  430.                 if($sayfa['kategori']==0) {
  431.                     // Sayfa İçi
  432.                     $qb = $em->createQueryBuilder();
  433.                     $icerik = $qb->select(implode(',',$icerikalani).',t.dilgrup,t.kategoriId,d.id as did,t.sayfaId')
  434.                         ->from('PanelBundle:' . $sayfa['tabloAdi'], 't')
  435.                         ->join('t.dil', 'd')
  436.                         ->where("t.seourl='" .$seo4. "' and d.id=" . $suankiDil['id'])
  437.                         ->addOrderBy('t.sira', 'ASC')
  438.                         ->addOrderBy('t.id', 'DESC')
  439.                         ->getQuery()
  440.                         ->getScalarResult();
  441.                     if(count($icerik)==0){
  442.                         return $this->redirect($this->ayarlar('siteYolu'));
  443.                     }
  444.                     return $this->render('@Site/Sites/'.$view.'_ic.html.twig',array('sayfa'=>$sayfa,'icerik'=>$icerik[0]));
  445.                 }else{
  447.                     $qb = $em->createQueryBuilder();
  448.                     $kategori = $qb->select('k.dilgrup,k.adi,k.seourl,k.sayfabasligi,k.anahtarkelimeler,k.sayfaaciklamasi,k.ustid,k.resim,k.sayfaId')
  449.                         ->from('PanelBundle:Kategori', 'k')
  450.                         ->join('k.dil', 'd')
  451.                         ->where("k.seourl='" .$seo4. "' and d.id=" . $suankiDil['id'])
  452.                         ->orderBy('k.sira', 'ASC')
  453.                         ->getQuery()
  454.                         ->getScalarResult();
  456.                     if(count($kategori)==0){
  457.                         $qb = $em->createQueryBuilder();
  458.                         $kategori = $qb->select('k.dilgrup,k.adi,k.seourl,k.sayfabasligi,k.anahtarkelimeler,k.sayfaaciklamasi,k.ustid,k.resim,k.sayfaId')
  459.                             ->from('PanelBundle:Kategori', 'k')
  460.                             ->join('k.dil', 'd')
  461.                             ->where("k.seourl='" .$seo3. "' and d.id=" . $suankiDil['id'])
  462.                             ->orderBy('k.sira', 'ASC')
  463.                             ->getQuery()
  464.                             ->getScalarResult();
  467.                         $qb = $em->createQueryBuilder();
  468.                         $icerik = $qb->select(implode(',', $icerikalani) . ',t.dilgrup,t.kategoriId,d.id as did,t.sayfaId')
  469.                             ->from('PanelBundle:' . $sayfa['tabloAdi'], 't')
  470.                             ->join('t.dil', 'd')
  471.                             ->where("t.kategoriId=" . $kategori[0]['dilgrup'] . " and t.seourl='".$seo4."' and d.id=" . $suankiDil['id'])
  472.                             ->addOrderBy('t.sira', 'ASC')
  473.                             ->addOrderBy('t.id', 'DESC')
  474.                             ->getQuery()
  475.                             ->getScalarResult();
  477.                         if(count($kategori)<1 and count($icerik)<1){
  478.                             return $this->redirect($this->ayarlar('siteYolu'));
  479.                         }
  481.                         return $this->render('@Site/Sites/' . $view . '_ic.html.twig', array('sayfa' => $sayfa, 'kategori' => $kategori[0], 'icerik' => $icerik[0]));
  483.                     } else {
  484.                             $qb = $em->createQueryBuilder();
  485.                             $kategoriler = $qb->select('k.dilgrup,k.adi,k.seourl,k.sayfabasligi,k.anahtarkelimeler,k.sayfaaciklamasi,k.ustid,k.resim,k.sayfaId')
  486.                                 ->from('PanelBundle:Kategori', 'k')
  487.                                 ->join('k.dil', 'd')
  488.                                 ->where("k.ustid=" . $kategori[0]['dilgrup'] . " and d.id=" . $suankiDil['id'])
  489.                                 ->orderBy('k.sira', 'ASC')
  490.                                 ->getQuery()
  491.                                 ->getScalarResult();
  493.                             $qb = $em->createQueryBuilder();
  494.                             $icerikler = $qb->select(implode(',', $icerikalani) . ',t.dilgrup,t.kategoriId,d.id as did,t.sayfaId')
  495.                                 ->from('PanelBundle:' . $sayfa['tabloAdi'], 't')
  496.                                 ->join('t.dil', 'd')
  497.                                 ->where("t.kategoriId=" . $kategori[0]['dilgrup'] . " and d.id=" . $suankiDil['id'])
  498.                                 ->addOrderBy('t.sira', 'ASC')
  499.                                 ->addOrderBy('t.id', 'DESC')
  500.                                 ->getQuery()
  501.                                 ->getScalarResult();
  504.                             return $this->render('@Site/Sites/' . $view . '_kategori.html.twig', array('sayfa' => $sayfa, 'kategori' => $kategori[0], 'icerikler' => $icerikler, 'kategoriler' => $kategoriler));
  506.                     }
  507.                 }
  508.             }
  509.             elseif(empty($seo6)){
  510.                 $qb = $em->createQueryBuilder();
  511.                 $villa_kategoriler = $qb->select('k.dilgrup,k.adi,k.seourl,k.sayfabasligi,k.anahtarkelimeler,k.sayfaaciklamasi,k.ustid,k.resim')
  512.                     ->from('PanelBundle:VillaKategori', 'k')
  513.                     ->join('k.dil', 'd')
  514.                     ->where("k.seourl='$seo5' and d.id=" . $suankiDil['id'])
  515.                     ->orderBy('k.sira', 'ASC')
  516.                     ->getQuery()
  517.                     ->getScalarResult();
  518.                 if(count($villa_kategoriler)>0){
  519.                     $qb = $em->createQueryBuilder();
  520.                     $villa_kategorileri = $qb->select('k.dilgrup,k.adi,k.seourl,k.sayfabasligi,k.anahtarkelimeler,k.sayfaaciklamasi,k.ustid,k.resim')
  521.                         ->from('PanelBundle:VillaKategori', 'k')
  522.                         ->join('k.dil', 'd')
  523.                         ->where("k.ustid='".$villa_kategoriler[0]['dilgrup']."' and d.id=" . $suankiDil['id'])
  524.                         ->orderBy('k.sira', 'ASC')
  525.                         ->getQuery()
  526.                         ->getScalarResult();
  528.                     return $this->render('@Site/Sites/ilanKategori.html.twig',array('kategori'=>$villa_kategoriler[0],'kategoriler'=>$villa_kategorileri));
  529.                 }else{
  530.                     $qb = $em->createQueryBuilder();
  531.                     $ilan = $qb->select('i.id,i.adi,i.title,i.seo,i.keywords,i.description,i.metin,i.girisTarihi,i.cikisTarihi,i.depozito,i.temizlik,i.havuzbahceBakim,i.konum,i.kisi,i.yatak,i.banyo,i.dilgrup,i.kategoriId,i.resimler,i.durum,i.ozellikler,i.yasaklar,i.il,i.ilce,i.semt')
  532.                         ->from('PanelBundle:Villa', 'i')
  533.                         ->join('i.dil', 'd')
  534.                         ->where("i.seo='" .$seo5. "' and d.id=" . $suankiDil['id'])
  535.                         ->orderBy('i.id', 'DESC')
  536.                         ->getQuery()
  537.                         ->getScalarResult();
  538.                     if(count($ilan)>0) {
  539.                         return $this->render('@Site/Sites/ilan.html.twig', array('ilan' => $ilan[0]));
  540.                     }
  541.                 }
  542.                 if($sayfa['kategori']==0) {
  543.                     // Sayfa İçi
  544.                     $qb = $em->createQueryBuilder();
  545.                     $icerik = $qb->select(implode(',',$icerikalani).',t.dilgrup,t.kategoriId,d.id as did,t.sayfaId')
  546.                         ->from('PanelBundle:' . $sayfa['tabloAdi'], 't')
  547.                         ->join('t.dil', 'd')
  548.                         ->where("t.seourl='" .$seo5. "' and d.id=" . $suankiDil['id'])
  549.                         ->addOrderBy('t.sira', 'ASC')
  550.                         ->addOrderBy('t.id', 'DESC')
  551.                         ->getQuery()
  552.                         ->getScalarResult();
  553.                     if(count($icerik)==0){
  554.                         return $this->redirect($this->ayarlar('siteYolu'));
  555.                     }
  556.                     return $this->render('@Site/Sites/'.$view.'_ic.html.twig',array('sayfa'=>$sayfa,'icerik'=>$icerik[0]));
  557.                 }else{
  559.                     $qb = $em->createQueryBuilder();
  560.                     $kategori = $qb->select('k.dilgrup,k.adi,k.seourl,k.sayfabasligi,k.anahtarkelimeler,k.sayfaaciklamasi,k.ustid,k.resim,k.sayfaId')
  561.                         ->from('PanelBundle:Kategori', 'k')
  562.                         ->join('k.dil', 'd')
  563.                         ->where("k.seourl='" .$seo5. "' and d.id=" . $suankiDil['id'])
  564.                         ->orderBy('k.sira', 'ASC')
  565.                         ->getQuery()
  566.                         ->getScalarResult();
  568.                     if(count($kategori)==0){
  569.                         $qb = $em->createQueryBuilder();
  570.                         $kategori = $qb->select('k.dilgrup,k.adi,k.seourl,k.sayfabasligi,k.anahtarkelimeler,k.sayfaaciklamasi,k.ustid,k.resim,k.sayfaId')
  571.                             ->from('PanelBundle:Kategori', 'k')
  572.                             ->join('k.dil', 'd')
  573.                             ->where("k.seourl='" .$seo4. "' and d.id=" . $suankiDil['id'])
  574.                             ->orderBy('k.sira', 'ASC')
  575.                             ->getQuery()
  576.                             ->getScalarResult();
  579.                         $qb = $em->createQueryBuilder();
  580.                         $icerik = $qb->select(implode(',', $icerikalani) . ',t.dilgrup,t.kategoriId,d.id as did,t.sayfaId')
  581.                             ->from('PanelBundle:' . $sayfa['tabloAdi'], 't')
  582.                             ->join('t.dil', 'd')
  583.                             ->where("t.kategoriId=" . $kategori[0]['dilgrup'] . " and t.seourl='".$seo5."' and d.id=" . $suankiDil['id'])
  584.                             ->addOrderBy('t.sira', 'ASC')
  585.                             ->addOrderBy('t.id', 'DESC')
  586.                             ->getQuery()
  587.                             ->getScalarResult();
  589.                         if(count($kategori)<1 and count($icerik)<1){
  590.                             return $this->redirect($this->ayarlar('siteYolu'));
  591.                         }
  593.                         return $this->render('@Site/Sites/' . $view . '_ic.html.twig', array('sayfa' => $sayfa, 'kategori' => $kategori[0], 'icerik' => $icerik[0]));
  595.                     } else {
  596.                         $qb = $em->createQueryBuilder();
  597.                         $kategoriler = $qb->select('k.dilgrup,k.adi,k.seourl,k.sayfabasligi,k.anahtarkelimeler,k.sayfaaciklamasi,k.ustid,k.resim,k.sayfaId')
  598.                             ->from('PanelBundle:Kategori', 'k')
  599.                             ->join('k.dil', 'd')
  600.                             ->where("k.ustid=" . $kategori[0]['dilgrup'] . " and d.id=" . $suankiDil['id'])
  601.                             ->orderBy('k.sira', 'ASC')
  602.                             ->getQuery()
  603.                             ->getScalarResult();
  605.                         $qb = $em->createQueryBuilder();
  606.                         $icerikler = $qb->select(implode(',', $icerikalani) . ',t.dilgrup,t.kategoriId,d.id as did,t.sayfaId')
  607.                             ->from('PanelBundle:' . $sayfa['tabloAdi'], 't')
  608.                             ->join('t.dil', 'd')
  609.                             ->where("t.kategoriId=" . $kategori[0]['dilgrup'] . " and d.id=" . $suankiDil['id'])
  610.                             ->addOrderBy('t.sira', 'ASC')
  611.                             ->addOrderBy('t.id', 'DESC')
  612.                             ->getQuery()
  613.                             ->getScalarResult();
  616.                         return $this->render('@Site/Sites/' . $view . '_kategori.html.twig', array('sayfa' => $sayfa, 'kategori' => $kategori[0], 'icerikler' => $icerikler, 'kategoriler' => $kategoriler));
  618.                     }
  619.                 }
  620.             }
  621.             elseif(empty($seo7)){
  622.                 $qb = $em->createQueryBuilder();
  623.                 $villa_kategoriler = $qb->select('k.dilgrup,k.adi,k.seourl,k.sayfabasligi,k.anahtarkelimeler,k.sayfaaciklamasi,k.ustid,k.resim')
  624.                     ->from('PanelBundle:VillaKategori', 'k')
  625.                     ->join('k.dil', 'd')
  626.                     ->where("k.seourl='$seo6' and d.id=" . $suankiDil['id'])
  627.                     ->orderBy('k.sira', 'ASC')
  628.                     ->getQuery()
  629.                     ->getScalarResult();
  630.                 if(count($villa_kategoriler)>0){
  631.                     $qb = $em->createQueryBuilder();
  632.                     $villa_kategorileri = $qb->select('k.dilgrup,k.adi,k.seourl,k.sayfabasligi,k.anahtarkelimeler,k.sayfaaciklamasi,k.ustid,k.resim')
  633.                         ->from('PanelBundle:VillaKategori', 'k')
  634.                         ->join('k.dil', 'd')
  635.                         ->where("k.ustid='".$villa_kategoriler[0]['dilgrup']."' and d.id=" . $suankiDil['id'])
  636.                         ->orderBy('k.sira', 'ASC')
  637.                         ->getQuery()
  638.                         ->getScalarResult();
  640.                     return $this->render('@Site/Sites/ilanKategori.html.twig',array('kategori'=>$villa_kategoriler[0],'kategoriler'=>$villa_kategorileri));
  641.                 }else{
  642.                     $qb = $em->createQueryBuilder();
  643.                     $ilan = $qb->select('i.id,i.adi,i.title,i.seo,i.keywords,i.description,i.metin,i.girisTarihi,i.cikisTarihi,i.depozito,i.temizlik,i.havuzbahceBakim,i.konum,i.kisi,i.yatak,i.banyo,i.dilgrup,i.kategoriId,i.resimler,i.durum,i.ozellikler,i.yasaklar,i.il,i.ilce,i.semt')
  644.                         ->from('PanelBundle:Villa', 'i')
  645.                         ->join('i.dil', 'd')
  646.                         ->where("i.seo='" .$seo6. "' and d.id=" . $suankiDil['id'])
  647.                         ->orderBy('i.id', 'DESC')
  648.                         ->getQuery()
  649.                         ->getScalarResult();
  650.                     if(count($ilan)>0) {
  651.                         return $this->render('@Site/Sites/ilan.html.twig', array('ilan' => $ilan[0]));
  652.                     }
  653.                 }
  654.                 if($sayfa['kategori']==0) {
  655.                     // Sayfa İçi
  656.                     $qb = $em->createQueryBuilder();
  657.                     $icerik = $qb->select(implode(',',$icerikalani).',t.dilgrup,t.kategoriId,d.id as did,t.sayfaId')
  658.                         ->from('PanelBundle:' . $sayfa['tabloAdi'], 't')
  659.                         ->join('t.dil', 'd')
  660.                         ->where("t.seourl='" .$seo6. "' and d.id=" . $suankiDil['id'])
  661.                         ->addOrderBy('t.sira', 'ASC')
  662.                         ->addOrderBy('t.id', 'DESC')
  663.                         ->getQuery()
  664.                         ->getScalarResult();
  665.                     if(count($icerik)==0){
  666.                         return $this->redirect($this->ayarlar('siteYolu'));
  667.                     }
  668.                     return $this->render('@Site/Sites/'.$view.'_ic.html.twig',array('sayfa'=>$sayfa,'icerik'=>$icerik[0]));
  669.                 }else{
  671.                     $qb = $em->createQueryBuilder();
  672.                     $kategori = $qb->select('k.dilgrup,k.adi,k.seourl,k.sayfabasligi,k.anahtarkelimeler,k.sayfaaciklamasi,k.ustid,k.resim,k.sayfaId')
  673.                         ->from('PanelBundle:Kategori', 'k')
  674.                         ->join('k.dil', 'd')
  675.                         ->where("k.seourl='" .$seo6. "' and d.id=" . $suankiDil['id'])
  676.                         ->orderBy('k.sira', 'ASC')
  677.                         ->getQuery()
  678.                         ->getScalarResult();
  680.                     if(count($kategori)==0){
  681.                         $qb = $em->createQueryBuilder();
  682.                         $kategori = $qb->select('k.dilgrup,k.adi,k.seourl,k.sayfabasligi,k.anahtarkelimeler,k.sayfaaciklamasi,k.ustid,k.resim,k.sayfaId')
  683.                             ->from('PanelBundle:Kategori', 'k')
  684.                             ->join('k.dil', 'd')
  685.                             ->where("k.seourl='" .$seo5. "' and d.id=" . $suankiDil['id'])
  686.                             ->orderBy('k.sira', 'ASC')
  687.                             ->getQuery()
  688.                             ->getScalarResult();
  691.                         $qb = $em->createQueryBuilder();
  692.                         $icerik = $qb->select(implode(',', $icerikalani) . ',t.dilgrup,t.kategoriId,d.id as did,t.sayfaId')
  693.                             ->from('PanelBundle:' . $sayfa['tabloAdi'], 't')
  694.                             ->join('t.dil', 'd')
  695.                             ->where("t.kategoriId=" . $kategori[0]['dilgrup'] . " and t.seourl='".$seo6."' and d.id=" . $suankiDil['id'])
  696.                             ->addOrderBy('t.sira', 'ASC')
  697.                             ->addOrderBy('t.id', 'DESC')
  698.                             ->getQuery()
  699.                             ->getScalarResult();
  701.                         if(count($kategori)<1 and count($icerik)<1){
  702.                             return $this->redirect($this->ayarlar('siteYolu'));
  703.                         }
  705.                         return $this->render('@Site/Sites/' . $view . '_ic.html.twig', array('sayfa' => $sayfa, 'kategori' => $kategori[0], 'icerik' => $icerik[0]));
  707.                     } else {
  708.                         $qb = $em->createQueryBuilder();
  709.                         $kategoriler = $qb->select('k.dilgrup,k.adi,k.seourl,k.sayfabasligi,k.anahtarkelimeler,k.sayfaaciklamasi,k.ustid,k.resim,k.sayfaId')
  710.                             ->from('PanelBundle:Kategori', 'k')
  711.                             ->join('k.dil', 'd')
  712.                             ->where("k.ustid=" . $kategori[0]['dilgrup'] . " and d.id=" . $suankiDil['id'])
  713.                             ->orderBy('k.sira', 'ASC')
  714.                             ->getQuery()
  715.                             ->getScalarResult();
  717.                         $qb = $em->createQueryBuilder();
  718.                         $icerikler = $qb->select(implode(',', $icerikalani) . ',t.dilgrup,t.kategoriId,d.id as did,t.sayfaId')
  719.                             ->from('PanelBundle:' . $sayfa['tabloAdi'], 't')
  720.                             ->join('t.dil', 'd')
  721.                             ->where("t.kategoriId=" . $kategori[0]['dilgrup'] . " and d.id=" . $suankiDil['id'])
  722.                             ->addOrderBy('t.sira', 'ASC')
  723.                             ->addOrderBy('t.id', 'DESC')
  724.                             ->getQuery()
  725.                             ->getScalarResult();
  728.                         return $this->render('@Site/Sites/' . $view . '_kategori.html.twig', array('sayfa' => $sayfa, 'kategori' => $kategori[0], 'icerikler' => $icerikler, 'kategoriler' => $kategoriler));
  730.                     }
  731.                 }
  732.             }
  733.             elseif(empty($seo8)){
  734.                 $qb = $em->createQueryBuilder();
  735.                 $villa_kategoriler = $qb->select('k.dilgrup,k.adi,k.seourl,k.sayfabasligi,k.anahtarkelimeler,k.sayfaaciklamasi,k.ustid,k.resim')
  736.                     ->from('PanelBundle:VillaKategori', 'k')
  737.                     ->join('k.dil', 'd')
  738.                     ->where("k.seourl='$seo7' and d.id=" . $suankiDil['id'])
  739.                     ->orderBy('k.sira', 'ASC')
  740.                     ->getQuery()
  741.                     ->getScalarResult();
  742.                 if(count($villa_kategoriler)>0){
  743.                     $qb = $em->createQueryBuilder();
  744.                     $villa_kategorileri = $qb->select('k.dilgrup,k.adi,k.seourl,k.sayfabasligi,k.anahtarkelimeler,k.sayfaaciklamasi,k.ustid,k.resim')
  745.                         ->from('PanelBundle:VillaKategori', 'k')
  746.                         ->join('k.dil', 'd')
  747.                         ->where("k.ustid='".$villa_kategoriler[0]['dilgrup']."' and d.id=" . $suankiDil['id'])
  748.                         ->orderBy('k.sira', 'ASC')
  749.                         ->getQuery()
  750.                         ->getScalarResult();
  752.                     return $this->render('@Site/Sites/ilanKategori.html.twig',array('kategori'=>$villa_kategoriler[0],'kategoriler'=>$villa_kategorileri));
  753.                 }else{
  754.                     $qb = $em->createQueryBuilder();
  755.                     $ilan = $qb->select('i.id,i.adi,i.title,i.seo,i.keywords,i.description,i.metin,i.girisTarihi,i.cikisTarihi,i.depozito,i.temizlik,i.havuzbahceBakim,i.konum,i.kisi,i.yatak,i.banyo,i.dilgrup,i.kategoriId,i.resimler,i.durum,i.ozellikler,i.yasaklar,i.il,i.ilce,i.semt')
  756.                         ->from('PanelBundle:Villa', 'i')
  757.                         ->join('i.dil', 'd')
  758.                         ->where("i.seo='" .$seo7. "' and d.id=" . $suankiDil['id'])
  759.                         ->orderBy('i.id', 'DESC')
  760.                         ->getQuery()
  761.                         ->getScalarResult();
  762.                     if(count($ilan)>0) {
  763.                         return $this->render('@Site/Sites/ilan.html.twig', array('ilan' => $ilan[0]));
  764.                     }
  765.                 }
  766.                 if($sayfa['kategori']==0) {
  767.                     // Sayfa İçi
  768.                     $qb = $em->createQueryBuilder();
  769.                     $icerik = $qb->select(implode(',',$icerikalani).',t.dilgrup,t.kategoriId,d.id as did,t.sayfaId')
  770.                         ->from('PanelBundle:' . $sayfa['tabloAdi'], 't')
  771.                         ->join('t.dil', 'd')
  772.                         ->where("t.seourl='" .$seo7. "' and d.id=" . $suankiDil['id'])
  773.                         ->addOrderBy('t.sira', 'ASC')
  774.                         ->addOrderBy('t.id', 'DESC')
  775.                         ->getQuery()
  776.                         ->getScalarResult();
  777.                     if(count($icerik)==0){
  778.                         return $this->redirect($this->ayarlar('siteYolu'));
  779.                     }
  780.                     return $this->render('@Site/Sites/'.$view.'_ic.html.twig',array('sayfa'=>$sayfa,'icerik'=>$icerik[0]));
  781.                 }else{
  783.                     $qb = $em->createQueryBuilder();
  784.                     $kategori = $qb->select('k.dilgrup,k.adi,k.seourl,k.sayfabasligi,k.anahtarkelimeler,k.sayfaaciklamasi,k.ustid,k.resim,k.sayfaId')
  785.                         ->from('PanelBundle:Kategori', 'k')
  786.                         ->join('k.dil', 'd')
  787.                         ->where("k.seourl='" .$seo7. "' and d.id=" . $suankiDil['id'])
  788.                         ->orderBy('k.sira', 'ASC')
  789.                         ->getQuery()
  790.                         ->getScalarResult();
  792.                     if(count($kategori)==0){
  793.                         $qb = $em->createQueryBuilder();
  794.                         $kategori = $qb->select('k.dilgrup,k.adi,k.seourl,k.sayfabasligi,k.anahtarkelimeler,k.sayfaaciklamasi,k.ustid,k.resim,k.sayfaId')
  795.                             ->from('PanelBundle:Kategori', 'k')
  796.                             ->join('k.dil', 'd')
  797.                             ->where("k.seourl='" .$seo6. "' and d.id=" . $suankiDil['id'])
  798.                             ->orderBy('k.sira', 'ASC')
  799.                             ->getQuery()
  800.                             ->getScalarResult();
  803.                         $qb = $em->createQueryBuilder();
  804.                         $icerik = $qb->select(implode(',', $icerikalani) . ',t.dilgrup,t.kategoriId,d.id as did,t.sayfaId')
  805.                             ->from('PanelBundle:' . $sayfa['tabloAdi'], 't')
  806.                             ->join('t.dil', 'd')
  807.                             ->where("t.kategoriId=" . $kategori[0]['dilgrup'] . " and t.seourl='".$seo7."' and d.id=" . $suankiDil['id'])
  808.                             ->addOrderBy('t.sira', 'ASC')
  809.                             ->addOrderBy('t.id', 'DESC')
  810.                             ->getQuery()
  811.                             ->getScalarResult();
  813.                         if(count($kategori)<1 and count($icerik)<1){
  814.                             return $this->redirect($this->ayarlar('siteYolu'));
  815.                         }
  817.                         return $this->render('@Site/Sites/' . $view . '_ic.html.twig', array('sayfa' => $sayfa, 'kategori' => $kategori[0], 'icerik' => $icerik[0]));
  819.                     } else {
  820.                         $qb = $em->createQueryBuilder();
  821.                         $kategoriler = $qb->select('k.dilgrup,k.adi,k.seourl,k.sayfabasligi,k.anahtarkelimeler,k.sayfaaciklamasi,k.ustid,k.resim,k.sayfaId')
  822.                             ->from('PanelBundle:Kategori', 'k')
  823.                             ->join('k.dil', 'd')
  824.                             ->where("k.ustid=" . $kategori[0]['dilgrup'] . " and d.id=" . $suankiDil['id'])
  825.                             ->orderBy('k.sira', 'ASC')
  826.                             ->getQuery()
  827.                             ->getScalarResult();
  829.                         $qb = $em->createQueryBuilder();
  830.                         $icerikler = $qb->select(implode(',', $icerikalani) . ',t.dilgrup,t.kategoriId,d.id as did,t.sayfaId')
  831.                             ->from('PanelBundle:' . $sayfa['tabloAdi'], 't')
  832.                             ->join('t.dil', 'd')
  833.                             ->where("t.kategoriId=" . $kategori[0]['dilgrup'] . " and d.id=" . $suankiDil['id'])
  834.                             ->addOrderBy('t.sira', 'ASC')
  835.                             ->addOrderBy('t.id', 'DESC')
  836.                             ->getQuery()
  837.                             ->getScalarResult();
  840.                         return $this->render('@Site/Sites/' . $view . '_kategori.html.twig', array('sayfa' => $sayfa, 'kategori' => $kategori[0], 'icerikler' => $icerikler, 'kategoriler' => $kategoriler));
  842.                     }
  843.                 }
  844.             }
  845.             elseif(empty($seo9)){
  846.                 $qb = $em->createQueryBuilder();
  847.                 $villa_kategoriler = $qb->select('k.dilgrup,k.adi,k.seourl,k.sayfabasligi,k.anahtarkelimeler,k.sayfaaciklamasi,k.ustid,k.resim')
  848.                     ->from('PanelBundle:VillaKategori', 'k')
  849.                     ->join('k.dil', 'd')
  850.                     ->where("k.seourl='$seo8' and d.id=" . $suankiDil['id'])
  851.                     ->orderBy('k.sira', 'ASC')
  852.                     ->getQuery()
  853.                     ->getScalarResult();
  854.                 if(count($villa_kategoriler)>0){
  855.                     $qb = $em->createQueryBuilder();
  856.                     $villa_kategorileri = $qb->select('k.dilgrup,k.adi,k.seourl,k.sayfabasligi,k.anahtarkelimeler,k.sayfaaciklamasi,k.ustid,k.resim')
  857.                         ->from('PanelBundle:VillaKategori', 'k')
  858.                         ->join('k.dil', 'd')
  859.                         ->where("k.ustid='".$villa_kategoriler[0]['dilgrup']."' and d.id=" . $suankiDil['id'])
  860.                         ->orderBy('k.sira', 'ASC')
  861.                         ->getQuery()
  862.                         ->getScalarResult();
  864.                     return $this->render('@Site/Sites/ilanKategori.html.twig',array('kategori'=>$villa_kategoriler[0],'kategoriler'=>$villa_kategorileri));
  865.                 }else{
  866.                     $qb = $em->createQueryBuilder();
  867.                     $ilan = $qb->select('i.id,i.adi,i.title,i.seo,i.keywords,i.description,i.metin,i.girisTarihi,i.cikisTarihi,i.depozito,i.temizlik,i.havuzbahceBakim,i.konum,i.kisi,i.yatak,i.banyo,i.dilgrup,i.kategoriId,i.resimler,i.durum,i.ozellikler,i.yasaklar,i.il,i.ilce,i.semt')
  868.                         ->from('PanelBundle:Villa', 'i')
  869.                         ->join('i.dil', 'd')
  870.                         ->where("i.seo='" .$seo8. "' and d.id=" . $suankiDil['id'])
  871.                         ->orderBy('i.id', 'DESC')
  872.                         ->getQuery()
  873.                         ->getScalarResult();
  874.                     if(count($ilan)>0) {
  875.                         return $this->render('@Site/Sites/ilan.html.twig', array('ilan' => $ilan[0]));
  876.                     }
  877.                 }
  878.                 if($sayfa['kategori']==0) {
  879.                     // Sayfa İçi
  880.                     $qb = $em->createQueryBuilder();
  881.                     $icerik = $qb->select(implode(',',$icerikalani).',t.dilgrup,t.kategoriId,d.id as did,t.sayfaId')
  882.                         ->from('PanelBundle:' . $sayfa['tabloAdi'], 't')
  883.                         ->join('t.dil', 'd')
  884.                         ->where("t.seourl='" .$seo8. "' and d.id=" . $suankiDil['id'])
  885.                         ->addOrderBy('t.sira', 'ASC')
  886.                         ->addOrderBy('t.id', 'DESC')
  887.                         ->getQuery()
  888.                         ->getScalarResult();
  889.                     if(count($icerik)==0){
  890.                         return $this->redirect($this->ayarlar('siteYolu'));
  891.                     }
  892.                     return $this->render('@Site/Sites/'.$view.'_ic.html.twig',array('sayfa'=>$sayfa,'icerik'=>$icerik[0]));
  893.                 }else{
  895.                     $qb = $em->createQueryBuilder();
  896.                     $kategori = $qb->select('k.dilgrup,k.adi,k.seourl,k.sayfabasligi,k.anahtarkelimeler,k.sayfaaciklamasi,k.ustid,k.resim,k.sayfaId')
  897.                         ->from('PanelBundle:Kategori', 'k')
  898.                         ->join('k.dil', 'd')
  899.                         ->where("k.seourl='" .$seo8. "' and d.id=" . $suankiDil['id'])
  900.                         ->orderBy('k.sira', 'ASC')
  901.                         ->getQuery()
  902.                         ->getScalarResult();
  904.                     if(count($kategori)==0){
  905.                         $qb = $em->createQueryBuilder();
  906.                         $kategori = $qb->select('k.dilgrup,k.adi,k.seourl,k.sayfabasligi,k.anahtarkelimeler,k.sayfaaciklamasi,k.ustid,k.resim,k.sayfaId')
  907.                             ->from('PanelBundle:Kategori', 'k')
  908.                             ->join('k.dil', 'd')
  909.                             ->where("k.seourl='" .$seo7. "' and d.id=" . $suankiDil['id'])
  910.                             ->orderBy('k.sira', 'ASC')
  911.                             ->getQuery()
  912.                             ->getScalarResult();
  915.                         $qb = $em->createQueryBuilder();
  916.                         $icerik = $qb->select(implode(',', $icerikalani) . ',t.dilgrup,t.kategoriId,d.id as did,t.sayfaId')
  917.                             ->from('PanelBundle:' . $sayfa['tabloAdi'], 't')
  918.                             ->join('t.dil', 'd')
  919.                             ->where("t.kategoriId=" . $kategori[0]['dilgrup'] . " and t.seourl='".$seo8."' and d.id=" . $suankiDil['id'])
  920.                             ->addOrderBy('t.sira', 'ASC')
  921.                             ->addOrderBy('t.id', 'DESC')
  922.                             ->getQuery()
  923.                             ->getScalarResult();
  925.                         if(count($kategori)<1 and count($icerik)<1){
  926.                             return $this->redirect($this->ayarlar('siteYolu'));
  927.                         }
  929.                         return $this->render('@Site/Sites/' . $view . '_ic.html.twig', array('sayfa' => $sayfa, 'kategori' => $kategori[0], 'icerik' => $icerik[0]));
  931.                     } else {
  932.                         $qb = $em->createQueryBuilder();
  933.                         $kategoriler = $qb->select('k.dilgrup,k.adi,k.seourl,k.sayfabasligi,k.anahtarkelimeler,k.sayfaaciklamasi,k.ustid,k.resim,k.sayfaId')
  934.                             ->from('PanelBundle:Kategori', 'k')
  935.                             ->join('k.dil', 'd')
  936.                             ->where("k.ustid=" . $kategori[0]['dilgrup'] . " and d.id=" . $suankiDil['id'])
  937.                             ->orderBy('k.sira', 'ASC')
  938.                             ->getQuery()
  939.                             ->getScalarResult();
  941.                         $qb = $em->createQueryBuilder();
  942.                         $icerikler = $qb->select(implode(',', $icerikalani) . ',t.dilgrup,t.kategoriId,d.id as did,t.sayfaId')
  943.                             ->from('PanelBundle:' . $sayfa['tabloAdi'], 't')
  944.                             ->join('t.dil', 'd')
  945.                             ->where("t.kategoriId=" . $kategori[0]['dilgrup'] . " and d.id=" . $suankiDil['id'])
  946.                             ->addOrderBy('t.sira', 'ASC')
  947.                             ->addOrderBy('t.id', 'DESC')
  948.                             ->getQuery()
  949.                             ->getScalarResult();
  952.                         return $this->render('@Site/Sites/' . $view . '_kategori.html.twig', array('sayfa' => $sayfa, 'kategori' => $kategori[0], 'icerikler' => $icerikler, 'kategoriler' => $kategoriler));
  954.                     }
  955.                 }
  956.             }
  957.             elseif(empty($seo10)){
  958.                 $qb = $em->createQueryBuilder();
  959.                 $villa_kategoriler = $qb->select('k.dilgrup,k.adi,k.seourl,k.sayfabasligi,k.anahtarkelimeler,k.sayfaaciklamasi,k.ustid,k.resim')
  960.                     ->from('PanelBundle:VillaKategori', 'k')
  961.                     ->join('k.dil', 'd')
  962.                     ->where("k.seourl='$seo9' and d.id=" . $suankiDil['id'])
  963.                     ->orderBy('k.sira', 'ASC')
  964.                     ->getQuery()
  965.                     ->getScalarResult();
  966.                 if(count($villa_kategoriler)>0){
  967.                     $qb = $em->createQueryBuilder();
  968.                     $villa_kategorileri = $qb->select('k.dilgrup,k.adi,k.seourl,k.sayfabasligi,k.anahtarkelimeler,k.sayfaaciklamasi,k.ustid,k.resim')
  969.                         ->from('PanelBundle:VillaKategori', 'k')
  970.                         ->join('k.dil', 'd')
  971.                         ->where("k.ustid='".$villa_kategoriler[0]['dilgrup']."' and d.id=" . $suankiDil['id'])
  972.                         ->orderBy('k.sira', 'ASC')
  973.                         ->getQuery()
  974.                         ->getScalarResult();
  976.                     return $this->render('@Site/Sites/ilanKategori.html.twig',array('kategori'=>$villa_kategoriler[0],'kategoriler'=>$villa_kategorileri));
  977.                 }else{
  978.                     $qb = $em->createQueryBuilder();
  979.                     $ilan = $qb->select('i.id,i.adi,i.title,i.seo,i.keywords,i.description,i.metin,i.girisTarihi,i.cikisTarihi,i.depozito,i.temizlik,i.havuzbahceBakim,i.konum,i.kisi,i.yatak,i.banyo,i.dilgrup,i.kategoriId,i.resimler,i.durum,i.ozellikler,i.yasaklar,i.il,i.ilce,i.semt')
  980.                         ->from('PanelBundle:Villa', 'i')
  981.                         ->join('i.dil', 'd')
  982.                         ->where("i.seo='" .$seo9. "' and d.id=" . $suankiDil['id'])
  983.                         ->orderBy('i.id', 'DESC')
  984.                         ->getQuery()
  985.                         ->getScalarResult();
  986.                     if(count($ilan)>0) {
  987.                         return $this->render('@Site/Sites/ilan.html.twig', array('ilan' => $ilan[0]));
  988.                     }
  989.                 }
  990.                 if($sayfa['kategori']==0) {
  991.                     // Sayfa İçi
  992.                     $qb = $em->createQueryBuilder();
  993.                     $icerik = $qb->select(implode(',',$icerikalani).',t.dilgrup,t.kategoriId,d.id as did,t.sayfaId')
  994.                         ->from('PanelBundle:' . $sayfa['tabloAdi'], 't')
  995.                         ->join('t.dil', 'd')
  996.                         ->where("t.seourl='" .$seo9. "' and d.id=" . $suankiDil['id'])
  997.                         ->addOrderBy('t.sira', 'ASC')
  998.                         ->addOrderBy('t.id', 'DESC')
  999.                         ->getQuery()
  1000.                         ->getScalarResult();
  1001.                     if(count($icerik)==0){
  1002.                         return $this->redirect($this->ayarlar('siteYolu'));
  1003.                     }
  1004.                     return $this->render('@Site/Sites/'.$view.'_ic.html.twig',array('sayfa'=>$sayfa,'icerik'=>$icerik[0]));
  1005.                 }else{
  1007.                     $qb = $em->createQueryBuilder();
  1008.                     $kategori = $qb->select('k.dilgrup,k.adi,k.seourl,k.sayfabasligi,k.anahtarkelimeler,k.sayfaaciklamasi,k.ustid,k.resim,k.sayfaId')
  1009.                         ->from('PanelBundle:Kategori', 'k')
  1010.                         ->join('k.dil', 'd')
  1011.                         ->where("k.seourl='" .$seo9. "' and d.id=" . $suankiDil['id'])
  1012.                         ->orderBy('k.sira', 'ASC')
  1013.                         ->getQuery()
  1014.                         ->getScalarResult();
  1016.                     if(count($kategori)==0){
  1017.                         $qb = $em->createQueryBuilder();
  1018.                         $kategori = $qb->select('k.dilgrup,k.adi,k.seourl,k.sayfabasligi,k.anahtarkelimeler,k.sayfaaciklamasi,k.ustid,k.resim,k.sayfaId')
  1019.                             ->from('PanelBundle:Kategori', 'k')
  1020.                             ->join('k.dil', 'd')
  1021.                             ->where("k.seourl='" .$seo8. "' and d.id=" . $suankiDil['id'])
  1022.                             ->orderBy('k.sira', 'ASC')
  1023.                             ->getQuery()
  1024.                             ->getScalarResult();
  1027.                         $qb = $em->createQueryBuilder();
  1028.                         $icerik = $qb->select(implode(',', $icerikalani) . ',t.dilgrup,t.kategoriId,d.id as did,t.sayfaId')
  1029.                             ->from('PanelBundle:' . $sayfa['tabloAdi'], 't')
  1030.                             ->join('t.dil', 'd')
  1031.                             ->where("t.kategoriId=" . $kategori[0]['dilgrup'] . " and t.seourl='".$seo9."' and d.id=" . $suankiDil['id'])
  1032.                             ->addOrderBy('t.sira', 'ASC')
  1033.                             ->addOrderBy('t.id', 'DESC')
  1034.                             ->getQuery()
  1035.                             ->getScalarResult();
  1037.                         if(count($kategori)<1 and count($icerik)<1){
  1038.                             return $this->redirect($this->ayarlar('siteYolu'));
  1039.                         }
  1041.                         return $this->render('@Site/Sites/' . $view . '_ic.html.twig', array('sayfa' => $sayfa, 'kategori' => $kategori[0], 'icerik' => $icerik[0]));
  1043.                     } else {
  1044.                         $qb = $em->createQueryBuilder();
  1045.                         $kategoriler = $qb->select('k.dilgrup,k.adi,k.seourl,k.sayfabasligi,k.anahtarkelimeler,k.sayfaaciklamasi,k.ustid,k.resim,k.sayfaId')
  1046.                             ->from('PanelBundle:Kategori', 'k')
  1047.                             ->join('k.dil', 'd')
  1048.                             ->where("k.ustid=" . $kategori[0]['dilgrup'] . " and d.id=" . $suankiDil['id'])
  1049.                             ->orderBy('k.sira', 'ASC')
  1050.                             ->getQuery()
  1051.                             ->getScalarResult();
  1053.                         $qb = $em->createQueryBuilder();
  1054.                         $icerikler = $qb->select(implode(',', $icerikalani) . ',t.dilgrup,t.kategoriId,d.id as did,t.sayfaId')
  1055.                             ->from('PanelBundle:' . $sayfa['tabloAdi'], 't')
  1056.                             ->join('t.dil', 'd')
  1057.                             ->where("t.kategoriId=" . $kategori[0]['dilgrup'] . " and d.id=" . $suankiDil['id'])
  1058.                             ->addOrderBy('t.sira', 'ASC')
  1059.                             ->addOrderBy('t.id', 'DESC')
  1060.                             ->getQuery()
  1061.                             ->getScalarResult();
  1064.                         return $this->render('@Site/Sites/' . $view . '_kategori.html.twig', array('sayfa' => $sayfa, 'kategori' => $kategori[0], 'icerikler' => $icerikler, 'kategoriler' => $kategoriler));
  1066.                     }
  1067.                 }
  1068.             }
  1069.             elseif(empty($seo11)){
  1070.                 $qb = $em->createQueryBuilder();
  1071.                 $villa_kategoriler = $qb->select('k.dilgrup,k.adi,k.seourl,k.sayfabasligi,k.anahtarkelimeler,k.sayfaaciklamasi,k.ustid,k.resim')
  1072.                     ->from('PanelBundle:VillaKategori', 'k')
  1073.                     ->join('k.dil', 'd')
  1074.                     ->where("k.seourl='$seo10' and d.id=" . $suankiDil['id'])
  1075.                     ->orderBy('k.sira', 'ASC')
  1076.                     ->getQuery()
  1077.                     ->getScalarResult();
  1078.                 if(count($villa_kategoriler)>0){
  1079.                     $qb = $em->createQueryBuilder();
  1080.                     $villa_kategorileri = $qb->select('k.dilgrup,k.adi,k.seourl,k.sayfabasligi,k.anahtarkelimeler,k.sayfaaciklamasi,k.ustid,k.resim')
  1081.                         ->from('PanelBundle:VillaKategori', 'k')
  1082.                         ->join('k.dil', 'd')
  1083.                         ->where("k.ustid='".$villa_kategoriler[0]['dilgrup']."' and d.id=" . $suankiDil['id'])
  1084.                         ->orderBy('k.sira', 'ASC')
  1085.                         ->getQuery()
  1086.                         ->getScalarResult();
  1088.                     return $this->render('@Site/Sites/ilanKategori.html.twig',array('kategori'=>$villa_kategoriler[0],'kategoriler'=>$villa_kategorileri));
  1089.                 }else{
  1090.                     $qb = $em->createQueryBuilder();
  1091.                     $ilan = $qb->select('i.id,i.adi,i.title,i.seo,i.keywords,i.description,i.metin,i.girisTarihi,i.cikisTarihi,i.depozito,i.temizlik,i.havuzbahceBakim,i.konum,i.kisi,i.yatak,i.banyo,i.dilgrup,i.kategoriId,i.resimler,i.durum,i.ozellikler,i.yasaklar,i.il,i.ilce,i.semt')
  1092.                         ->from('PanelBundle:Villa', 'i')
  1093.                         ->join('i.dil', 'd')
  1094.                         ->where("i.seo='" .$seo10. "' and d.id=" . $suankiDil['id'])
  1095.                         ->orderBy('i.id', 'DESC')
  1096.                         ->getQuery()
  1097.                         ->getScalarResult();
  1098.                     if(count($ilan)>0) {
  1099.                         return $this->render('@Site/Sites/ilan.html.twig', array('ilan' => $ilan[0]));
  1100.                     }
  1101.                 }
  1102.                 if($sayfa['kategori']==0) {
  1103.                     // Sayfa İçi
  1104.                     $qb = $em->createQueryBuilder();
  1105.                     $icerik = $qb->select(implode(',',$icerikalani).',t.dilgrup,t.kategoriId,d.id as did,t.sayfaId')
  1106.                         ->from('PanelBundle:' . $sayfa['tabloAdi'], 't')
  1107.                         ->join('t.dil', 'd')
  1108.                         ->where("t.seourl='" .$seo10. "' and d.id=" . $suankiDil['id'])
  1109.                         ->addOrderBy('t.sira', 'ASC')
  1110.                         ->addOrderBy('t.id', 'DESC')
  1111.                         ->getQuery()
  1112.                         ->getScalarResult();
  1113.                     if(count($icerik)==0){
  1114.                         return $this->redirect($this->ayarlar('siteYolu'));
  1115.                     }
  1116.                     return $this->render('@Site/Sites/'.$view.'_ic.html.twig',array('sayfa'=>$sayfa,'icerik'=>$icerik[0]));
  1117.                 }else{
  1119.                     $qb = $em->createQueryBuilder();
  1120.                     $kategori = $qb->select('k.dilgrup,k.adi,k.seourl,k.sayfabasligi,k.anahtarkelimeler,k.sayfaaciklamasi,k.ustid,k.resim,k.sayfaId')
  1121.                         ->from('PanelBundle:Kategori', 'k')
  1122.                         ->join('k.dil', 'd')
  1123.                         ->where("k.seourl='" .$seo10. "' and d.id=" . $suankiDil['id'])
  1124.                         ->orderBy('k.sira', 'ASC')
  1125.                         ->getQuery()
  1126.                         ->getScalarResult();
  1128.                     if(count($kategori)==0){
  1129.                         $qb = $em->createQueryBuilder();
  1130.                         $kategori = $qb->select('k.dilgrup,k.adi,k.seourl,k.sayfabasligi,k.anahtarkelimeler,k.sayfaaciklamasi,k.ustid,k.resim,k.sayfaId')
  1131.                             ->from('PanelBundle:Kategori', 'k')
  1132.                             ->join('k.dil', 'd')
  1133.                             ->where("k.seourl='" .$seo9. "' and d.id=" . $suankiDil['id'])
  1134.                             ->orderBy('k.sira', 'ASC')
  1135.                             ->getQuery()
  1136.                             ->getScalarResult();
  1139.                         $qb = $em->createQueryBuilder();
  1140.                         $icerik = $qb->select(implode(',', $icerikalani) . ',t.dilgrup,t.kategoriId,d.id as did,t.sayfaId')
  1141.                             ->from('PanelBundle:' . $sayfa['tabloAdi'], 't')
  1142.                             ->join('t.dil', 'd')
  1143.                             ->where("t.kategoriId=" . $kategori[0]['dilgrup'] . " and t.seourl='".$seo10."' and d.id=" . $suankiDil['id'])
  1144.                             ->addOrderBy('t.sira', 'ASC')
  1145.                             ->addOrderBy('t.id', 'DESC')
  1146.                             ->getQuery()
  1147.                             ->getScalarResult();
  1149.                         if(count($kategori)<1 and count($icerik)<1){
  1150.                             return $this->redirect($this->ayarlar('siteYolu'));
  1151.                         }
  1153.                         return $this->render('@Site/Sites/' . $view . '_ic.html.twig', array('sayfa' => $sayfa, 'kategori' => $kategori[0], 'icerik' => $icerik[0]));
  1155.                     } else {
  1156.                         $qb = $em->createQueryBuilder();
  1157.                         $kategoriler = $qb->select('k.dilgrup,k.adi,k.seourl,k.sayfabasligi,k.anahtarkelimeler,k.sayfaaciklamasi,k.ustid,k.resim,k.sayfaId')
  1158.                             ->from('PanelBundle:Kategori', 'k')
  1159.                             ->join('k.dil', 'd')
  1160.                             ->where("k.ustid=" . $kategori[0]['dilgrup'] . " and d.id=" . $suankiDil['id'])
  1161.                             ->orderBy('k.sira', 'ASC')
  1162.                             ->getQuery()
  1163.                             ->getScalarResult();
  1165.                         $qb = $em->createQueryBuilder();
  1166.                         $icerikler = $qb->select(implode(',', $icerikalani) . ',t.dilgrup,t.kategoriId,d.id as did,t.sayfaId')
  1167.                             ->from('PanelBundle:' . $sayfa['tabloAdi'], 't')
  1168.                             ->join('t.dil', 'd')
  1169.                             ->where("t.kategoriId=" . $kategori[0]['dilgrup'] . " and d.id=" . $suankiDil['id'])
  1170.                             ->addOrderBy('t.sira', 'ASC')
  1171.                             ->addOrderBy('t.id', 'DESC')
  1172.                             ->getQuery()
  1173.                             ->getScalarResult();
  1176.                         return $this->render('@Site/Sites/' . $view . '_kategori.html.twig', array('sayfa' => $sayfa, 'kategori' => $kategori[0], 'icerikler' => $icerikler, 'kategoriler' => $kategoriler));
  1178.                     }
  1179.                 }
  1180.             }
  1181.             elseif(empty($seo12)){
  1182.                 $qb = $em->createQueryBuilder();
  1183.                 $villa_kategoriler = $qb->select('k.dilgrup,k.adi,k.seourl,k.sayfabasligi,k.anahtarkelimeler,k.sayfaaciklamasi,k.ustid,k.resim')
  1184.                     ->from('PanelBundle:VillaKategori', 'k')
  1185.                     ->join('k.dil', 'd')
  1186.                     ->where("k.seourl='$seo11' and d.id=" . $suankiDil['id'])
  1187.                     ->orderBy('k.sira', 'ASC')
  1188.                     ->getQuery()
  1189.                     ->getScalarResult();
  1190.                 if(count($villa_kategoriler)>0){
  1191.                     $qb = $em->createQueryBuilder();
  1192.                     $villa_kategorileri = $qb->select('k.dilgrup,k.adi,k.seourl,k.sayfabasligi,k.anahtarkelimeler,k.sayfaaciklamasi,k.ustid,k.resim')
  1193.                         ->from('PanelBundle:VillaKategori', 'k')
  1194.                         ->join('k.dil', 'd')
  1195.                         ->where("k.ustid='".$villa_kategoriler[0]['dilgrup']."' and d.id=" . $suankiDil['id'])
  1196.                         ->orderBy('k.sira', 'ASC')
  1197.                         ->getQuery()
  1198.                         ->getScalarResult();
  1200.                     return $this->render('@Site/Sites/ilanKategori.html.twig',array('kategori'=>$villa_kategoriler[0],'kategoriler'=>$villa_kategorileri));
  1201.                 }else{
  1202.                     $qb = $em->createQueryBuilder();
  1203.                     $ilan = $qb->select('i.id,i.adi,i.title,i.seo,i.keywords,i.description,i.metin,i.girisTarihi,i.cikisTarihi,i.depozito,i.temizlik,i.havuzbahceBakim,i.konum,i.kisi,i.yatak,i.banyo,i.dilgrup,i.kategoriId,i.resimler,i.durum,i.ozellikler,i.yasaklar,i.il,i.ilce,i.semt')
  1204.                         ->from('PanelBundle:Villa', 'i')
  1205.                         ->join('i.dil', 'd')
  1206.                         ->where("i.seo='" .$seo11. "' and d.id=" . $suankiDil['id'])
  1207.                         ->orderBy('i.id', 'DESC')
  1208.                         ->getQuery()
  1209.                         ->getScalarResult();
  1210.                     if(count($ilan)>0) {
  1211.                         return $this->render('@Site/Sites/ilan.html.twig', array('ilan' => $ilan[0]));
  1212.                     }
  1213.                 }
  1214.                 if($sayfa['kategori']==0) {
  1215.                     // Sayfa İçi
  1216.                     $qb = $em->createQueryBuilder();
  1217.                     $icerik = $qb->select(implode(',',$icerikalani).',t.dilgrup,t.kategoriId,d.id as did,t.sayfaId')
  1218.                         ->from('PanelBundle:' . $sayfa['tabloAdi'], 't')
  1219.                         ->join('t.dil', 'd')
  1220.                         ->where("t.seourl='" .$seo11. "' and d.id=" . $suankiDil['id'])
  1221.                         ->addOrderBy('t.sira', 'ASC')
  1222.                         ->addOrderBy('t.id', 'DESC')
  1223.                         ->getQuery()
  1224.                         ->getScalarResult();
  1225.                     if(count($icerik)==0){
  1226.                         return $this->redirect($this->ayarlar('siteYolu'));
  1227.                     }
  1228.                     return $this->render('@Site/Sites/'.$view.'_ic.html.twig',array('sayfa'=>$sayfa,'icerik'=>$icerik[0]));
  1229.                 }else{
  1231.                     $qb = $em->createQueryBuilder();
  1232.                     $kategori = $qb->select('k.dilgrup,k.adi,k.seourl,k.sayfabasligi,k.anahtarkelimeler,k.sayfaaciklamasi,k.ustid,k.resim,k.sayfaId')
  1233.                         ->from('PanelBundle:Kategori', 'k')
  1234.                         ->join('k.dil', 'd')
  1235.                         ->where("k.seourl='" .$seo11. "' and d.id=" . $suankiDil['id'])
  1236.                         ->orderBy('k.sira', 'ASC')
  1237.                         ->getQuery()
  1238.                         ->getScalarResult();
  1240.                     if(count($kategori)==0){
  1241.                         $qb = $em->createQueryBuilder();
  1242.                         $kategori = $qb->select('k.dilgrup,k.adi,k.seourl,k.sayfabasligi,k.anahtarkelimeler,k.sayfaaciklamasi,k.ustid,k.resim,k.sayfaId')
  1243.                             ->from('PanelBundle:Kategori', 'k')
  1244.                             ->join('k.dil', 'd')
  1245.                             ->where("k.seourl='" .$seo10. "' and d.id=" . $suankiDil['id'])
  1246.                             ->orderBy('k.sira', 'ASC')
  1247.                             ->getQuery()
  1248.                             ->getScalarResult();
  1251.                         $qb = $em->createQueryBuilder();
  1252.                         $icerik = $qb->select(implode(',', $icerikalani) . ',t.dilgrup,t.kategoriId,d.id as did,t.sayfaId')
  1253.                             ->from('PanelBundle:' . $sayfa['tabloAdi'], 't')
  1254.                             ->join('t.dil', 'd')
  1255.                             ->where("t.kategoriId=" . $kategori[0]['dilgrup'] . " and t.seourl='".$seo11."' and d.id=" . $suankiDil['id'])
  1256.                             ->addOrderBy('t.sira', 'ASC')
  1257.                             ->addOrderBy('t.id', 'DESC')
  1258.                             ->getQuery()
  1259.                             ->getScalarResult();
  1261.                         if(count($kategori)<1 and count($icerik)<1){
  1262.                             return $this->redirect($this->ayarlar('siteYolu'));
  1263.                         }
  1265.                         return $this->render('@Site/Sites/' . $view . '_ic.html.twig', array('sayfa' => $sayfa, 'kategori' => $kategori[0], 'icerik' => $icerik[0]));
  1267.                     } else {
  1268.                         $qb = $em->createQueryBuilder();
  1269.                         $kategoriler = $qb->select('k.dilgrup,k.adi,k.seourl,k.sayfabasligi,k.anahtarkelimeler,k.sayfaaciklamasi,k.ustid,k.resim,k.sayfaId')
  1270.                             ->from('PanelBundle:Kategori', 'k')
  1271.                             ->join('k.dil', 'd')
  1272.                             ->where("k.ustid=" . $kategori[0]['dilgrup'] . " and d.id=" . $suankiDil['id'])
  1273.                             ->orderBy('k.sira', 'ASC')
  1274.                             ->getQuery()
  1275.                             ->getScalarResult();
  1277.                         $qb = $em->createQueryBuilder();
  1278.                         $icerikler = $qb->select(implode(',', $icerikalani) . ',t.dilgrup,t.kategoriId,d.id as did,t.sayfaId')
  1279.                             ->from('PanelBundle:' . $sayfa['tabloAdi'], 't')
  1280.                             ->join('t.dil', 'd')
  1281.                             ->where("t.kategoriId=" . $kategori[0]['dilgrup'] . " and d.id=" . $suankiDil['id'])
  1282.                             ->addOrderBy('t.sira', 'ASC')
  1283.                             ->addOrderBy('t.id', 'DESC')
  1284.                             ->getQuery()
  1285.                             ->getScalarResult();
  1288.                         return $this->render('@Site/Sites/' . $view . '_kategori.html.twig', array('sayfa' => $sayfa, 'kategori' => $kategori[0], 'icerikler' => $icerikler, 'kategoriler' => $kategoriler));
  1290.                     }
  1291.                 }
  1292.             }
  1293.             elseif(empty($seo13)){
  1294.                 $qb = $em->createQueryBuilder();
  1295.                 $villa_kategoriler = $qb->select('k.dilgrup,k.adi,k.seourl,k.sayfabasligi,k.anahtarkelimeler,k.sayfaaciklamasi,k.ustid,k.resim')
  1296.                     ->from('PanelBundle:VillaKategori', 'k')
  1297.                     ->join('k.dil', 'd')
  1298.                     ->where("k.seourl='$seo12' and d.id=" . $suankiDil['id'])
  1299.                     ->orderBy('k.sira', 'ASC')
  1300.                     ->getQuery()
  1301.                     ->getScalarResult();
  1302.                 if(count($villa_kategoriler)>0){
  1303.                     $qb = $em->createQueryBuilder();
  1304.                     $villa_kategorileri = $qb->select('k.dilgrup,k.adi,k.seourl,k.sayfabasligi,k.anahtarkelimeler,k.sayfaaciklamasi,k.ustid,k.resim')
  1305.                         ->from('PanelBundle:VillaKategori', 'k')
  1306.                         ->join('k.dil', 'd')
  1307.                         ->where("k.ustid='".$villa_kategoriler[0]['dilgrup']."' and d.id=" . $suankiDil['id'])
  1308.                         ->orderBy('k.sira', 'ASC')
  1309.                         ->getQuery()
  1310.                         ->getScalarResult();
  1312.                     return $this->render('@Site/Sites/ilanKategori.html.twig',array('kategori'=>$villa_kategoriler[0],'kategoriler'=>$villa_kategorileri));
  1313.                 }else{
  1314.                     $qb = $em->createQueryBuilder();
  1315.                     $ilan = $qb->select('i.id,i.adi,i.title,i.seo,i.keywords,i.description,i.metin,i.girisTarihi,i.cikisTarihi,i.depozito,i.temizlik,i.havuzbahceBakim,i.konum,i.kisi,i.yatak,i.banyo,i.dilgrup,i.kategoriId,i.resimler,i.durum,i.ozellikler,i.yasaklar,i.il,i.ilce,i.semt')
  1316.                         ->from('PanelBundle:Villa', 'i')
  1317.                         ->join('i.dil', 'd')
  1318.                         ->where("i.seo='" .$seo12. "' and d.id=" . $suankiDil['id'])
  1319.                         ->orderBy('i.id', 'DESC')
  1320.                         ->getQuery()
  1321.                         ->getScalarResult();
  1322.                     if(count($ilan)>0) {
  1323.                         return $this->render('@Site/Sites/ilan.html.twig', array('ilan' => $ilan[0]));
  1324.                     }
  1325.                 }
  1326.                 if($sayfa['kategori']==0) {
  1327.                     // Sayfa İçi
  1328.                     $qb = $em->createQueryBuilder();
  1329.                     $icerik = $qb->select(implode(',',$icerikalani).',t.dilgrup,t.kategoriId,d.id as did,t.sayfaId')
  1330.                         ->from('PanelBundle:' . $sayfa['tabloAdi'], 't')
  1331.                         ->join('t.dil', 'd')
  1332.                         ->where("t.seourl='" .$seo12. "' and d.id=" . $suankiDil['id'])
  1333.                         ->addOrderBy('t.sira', 'ASC')
  1334.                         ->addOrderBy('t.id', 'DESC')
  1335.                         ->getQuery()
  1336.                         ->getScalarResult();
  1337.                     if(count($icerik)==0){
  1338.                         return $this->redirect($this->ayarlar('siteYolu'));
  1339.                     }
  1340.                     return $this->render('@Site/Sites/'.$view.'_ic.html.twig',array('sayfa'=>$sayfa,'icerik'=>$icerik[0]));
  1341.                 }else{
  1343.                     $qb = $em->createQueryBuilder();
  1344.                     $kategori = $qb->select('k.dilgrup,k.adi,k.seourl,k.sayfabasligi,k.anahtarkelimeler,k.sayfaaciklamasi,k.ustid,k.resim,k.sayfaId')
  1345.                         ->from('PanelBundle:Kategori', 'k')
  1346.                         ->join('k.dil', 'd')
  1347.                         ->where("k.seourl='" .$seo12. "' and d.id=" . $suankiDil['id'])
  1348.                         ->orderBy('k.sira', 'ASC')
  1349.                         ->getQuery()
  1350.                         ->getScalarResult();
  1352.                     if(count($kategori)==0){
  1353.                         $qb = $em->createQueryBuilder();
  1354.                         $kategori = $qb->select('k.dilgrup,k.adi,k.seourl,k.sayfabasligi,k.anahtarkelimeler,k.sayfaaciklamasi,k.ustid,k.resim,k.sayfaId')
  1355.                             ->from('PanelBundle:Kategori', 'k')
  1356.                             ->join('k.dil', 'd')
  1357.                             ->where("k.seourl='" .$seo11. "' and d.id=" . $suankiDil['id'])
  1358.                             ->orderBy('k.sira', 'ASC')
  1359.                             ->getQuery()
  1360.                             ->getScalarResult();
  1363.                         $qb = $em->createQueryBuilder();
  1364.                         $icerik = $qb->select(implode(',', $icerikalani) . ',t.dilgrup,t.kategoriId,d.id as did,t.sayfaId')
  1365.                             ->from('PanelBundle:' . $sayfa['tabloAdi'], 't')
  1366.                             ->join('t.dil', 'd')
  1367.                             ->where("t.kategoriId=" . $kategori[0]['dilgrup'] . " and t.seourl='".$seo12."' and d.id=" . $suankiDil['id'])
  1368.                             ->addOrderBy('t.sira', 'ASC')
  1369.                             ->addOrderBy('t.id', 'DESC')
  1370.                             ->getQuery()
  1371.                             ->getScalarResult();
  1373.                         if(count($kategori)<1 and count($icerik)<1){
  1374.                             return $this->redirect($this->ayarlar('siteYolu'));
  1375.                         }
  1377.                         return $this->render('@Site/Sites/' . $view . '_ic.html.twig', array('sayfa' => $sayfa, 'kategori' => $kategori[0], 'icerik' => $icerik[0]));
  1379.                     } else {
  1380.                         $qb = $em->createQueryBuilder();
  1381.                         $kategoriler = $qb->select('k.dilgrup,k.adi,k.seourl,k.sayfabasligi,k.anahtarkelimeler,k.sayfaaciklamasi,k.ustid,k.resim,k.sayfaId')
  1382.                             ->from('PanelBundle:Kategori', 'k')
  1383.                             ->join('k.dil', 'd')
  1384.                             ->where("k.ustid=" . $kategori[0]['dilgrup'] . " and d.id=" . $suankiDil['id'])
  1385.                             ->orderBy('k.sira', 'ASC')
  1386.                             ->getQuery()
  1387.                             ->getScalarResult();
  1389.                         $qb = $em->createQueryBuilder();
  1390.                         $icerikler = $qb->select(implode(',', $icerikalani) . ',t.dilgrup,t.kategoriId,d.id as did,t.sayfaId')
  1391.                             ->from('PanelBundle:' . $sayfa['tabloAdi'], 't')
  1392.                             ->join('t.dil', 'd')
  1393.                             ->where("t.kategoriId=" . $kategori[0]['dilgrup'] . " and d.id=" . $suankiDil['id'])
  1394.                             ->addOrderBy('t.sira', 'ASC')
  1395.                             ->addOrderBy('t.id', 'DESC')
  1396.                             ->getQuery()
  1397.                             ->getScalarResult();
  1400.                         return $this->render('@Site/Sites/' . $view . '_kategori.html.twig', array('sayfa' => $sayfa, 'kategori' => $kategori[0], 'icerikler' => $icerikler, 'kategoriler' => $kategoriler));
  1402.                     }
  1403.                 }
  1404.             }
  1405.             elseif(empty($seo14)){
  1406.                 $qb = $em->createQueryBuilder();
  1407.                 $villa_kategoriler = $qb->select('k.dilgrup,k.adi,k.seourl,k.sayfabasligi,k.anahtarkelimeler,k.sayfaaciklamasi,k.ustid,k.resim')
  1408.                     ->from('PanelBundle:VillaKategori', 'k')
  1409.                     ->join('k.dil', 'd')
  1410.                     ->where("k.seourl='$seo13' and d.id=" . $suankiDil['id'])
  1411.                     ->orderBy('k.sira', 'ASC')
  1412.                     ->getQuery()
  1413.                     ->getScalarResult();
  1414.                 if(count($villa_kategoriler)>0){
  1415.                     $qb = $em->createQueryBuilder();
  1416.                     $villa_kategorileri = $qb->select('k.dilgrup,k.adi,k.seourl,k.sayfabasligi,k.anahtarkelimeler,k.sayfaaciklamasi,k.ustid,k.resim')
  1417.                         ->from('PanelBundle:VillaKategori', 'k')
  1418.                         ->join('k.dil', 'd')
  1419.                         ->where("k.ustid='".$villa_kategoriler[0]['dilgrup']."' and d.id=" . $suankiDil['id'])
  1420.                         ->orderBy('k.sira', 'ASC')
  1421.                         ->getQuery()
  1422.                         ->getScalarResult();
  1424.                     return $this->render('@Site/Sites/ilanKategori.html.twig',array('kategori'=>$villa_kategoriler[0],'kategoriler'=>$villa_kategorileri));
  1425.                 }else{
  1426.                     $qb = $em->createQueryBuilder();
  1427.                     $ilan = $qb->select('i.id,i.adi,i.title,i.seo,i.keywords,i.description,i.metin,i.girisTarihi,i.cikisTarihi,i.depozito,i.temizlik,i.havuzbahceBakim,i.konum,i.kisi,i.yatak,i.banyo,i.dilgrup,i.kategoriId,i.resimler,i.durum,i.ozellikler,i.yasaklar,i.il,i.ilce,i.semt')
  1428.                         ->from('PanelBundle:Villa', 'i')
  1429.                         ->join('i.dil', 'd')
  1430.                         ->where("i.seo='" .$seo13. "' and d.id=" . $suankiDil['id'])
  1431.                         ->orderBy('i.id', 'DESC')
  1432.                         ->getQuery()
  1433.                         ->getScalarResult();
  1434.                     if(count($ilan)>0) {
  1435.                         return $this->render('@Site/Sites/ilan.html.twig', array('ilan' => $ilan[0]));
  1436.                     }
  1437.                 }
  1438.                 if($sayfa['kategori']==0) {
  1439.                     // Sayfa İçi
  1440.                     $qb = $em->createQueryBuilder();
  1441.                     $icerik = $qb->select(implode(',',$icerikalani).',t.dilgrup,t.kategoriId,d.id as did,t.sayfaId')
  1442.                         ->from('PanelBundle:' . $sayfa['tabloAdi'], 't')
  1443.                         ->join('t.dil', 'd')
  1444.                         ->where("t.seourl='" .$seo13. "' and d.id=" . $suankiDil['id'])
  1445.                         ->addOrderBy('t.sira', 'ASC')
  1446.                         ->addOrderBy('t.id', 'DESC')
  1447.                         ->getQuery()
  1448.                         ->getScalarResult();
  1449.                     if(count($icerik)==0){
  1450.                         return $this->redirect($this->ayarlar('siteYolu'));
  1451.                     }
  1452.                     return $this->render('@Site/Sites/'.$view.'_ic.html.twig',array('sayfa'=>$sayfa,'icerik'=>$icerik[0]));
  1453.                 }else{
  1455.                     $qb = $em->createQueryBuilder();
  1456.                     $kategori = $qb->select('k.dilgrup,k.adi,k.seourl,k.sayfabasligi,k.anahtarkelimeler,k.sayfaaciklamasi,k.ustid,k.resim,k.sayfaId')
  1457.                         ->from('PanelBundle:Kategori', 'k')
  1458.                         ->join('k.dil', 'd')
  1459.                         ->where("k.seourl='" .$seo13. "' and d.id=" . $suankiDil['id'])
  1460.                         ->orderBy('k.sira', 'ASC')
  1461.                         ->getQuery()
  1462.                         ->getScalarResult();
  1464.                     if(count($kategori)==0){
  1465.                         $qb = $em->createQueryBuilder();
  1466.                         $kategori = $qb->select('k.dilgrup,k.adi,k.seourl,k.sayfabasligi,k.anahtarkelimeler,k.sayfaaciklamasi,k.ustid,k.resim,k.sayfaId')
  1467.                             ->from('PanelBundle:Kategori', 'k')
  1468.                             ->join('k.dil', 'd')
  1469.                             ->where("k.seourl='" .$seo12. "' and d.id=" . $suankiDil['id'])
  1470.                             ->orderBy('k.sira', 'ASC')
  1471.                             ->getQuery()
  1472.                             ->getScalarResult();
  1475.                         $qb = $em->createQueryBuilder();
  1476.                         $icerik = $qb->select(implode(',', $icerikalani) . ',t.dilgrup,t.kategoriId,d.id as did,t.sayfaId')
  1477.                             ->from('PanelBundle:' . $sayfa['tabloAdi'], 't')
  1478.                             ->join('t.dil', 'd')
  1479.                             ->where("t.kategoriId=" . $kategori[0]['dilgrup'] . " and t.seourl='".$seo13."' and d.id=" . $suankiDil['id'])
  1480.                             ->addOrderBy('t.sira', 'ASC')
  1481.                             ->addOrderBy('t.id', 'DESC')
  1482.                             ->getQuery()
  1483.                             ->getScalarResult();
  1485.                         if(count($kategori)<1 and count($icerik)<1){
  1486.                             return $this->redirect($this->ayarlar('siteYolu'));
  1487.                         }
  1489.                         return $this->render('@Site/Sites/' . $view . '_ic.html.twig', array('sayfa' => $sayfa, 'kategori' => $kategori[0], 'icerik' => $icerik[0]));
  1491.                     } else {
  1492.                         $qb = $em->createQueryBuilder();
  1493.                         $kategoriler = $qb->select('k.dilgrup,k.adi,k.seourl,k.sayfabasligi,k.anahtarkelimeler,k.sayfaaciklamasi,k.ustid,k.resim,k.sayfaId')
  1494.                             ->from('PanelBundle:Kategori', 'k')
  1495.                             ->join('k.dil', 'd')
  1496.                             ->where("k.ustid=" . $kategori[0]['dilgrup'] . " and d.id=" . $suankiDil['id'])
  1497.                             ->orderBy('k.sira', 'ASC')
  1498.                             ->getQuery()
  1499.                             ->getScalarResult();
  1501.                         $qb = $em->createQueryBuilder();
  1502.                         $icerikler = $qb->select(implode(',', $icerikalani) . ',t.dilgrup,t.kategoriId,d.id as did,t.sayfaId')
  1503.                             ->from('PanelBundle:' . $sayfa['tabloAdi'], 't')
  1504.                             ->join('t.dil', 'd')
  1505.                             ->where("t.kategoriId=" . $kategori[0]['dilgrup'] . " and d.id=" . $suankiDil['id'])
  1506.                             ->addOrderBy('t.sira', 'ASC')
  1507.                             ->addOrderBy('t.id', 'DESC')
  1508.                             ->getQuery()
  1509.                             ->getScalarResult();
  1512.                         return $this->render('@Site/Sites/' . $view . '_kategori.html.twig', array('sayfa' => $sayfa, 'kategori' => $kategori[0], 'icerikler' => $icerikler, 'kategoriler' => $kategoriler));
  1514.                     }
  1515.                 }
  1516.             }
  1517.             elseif(empty($seo15)){
  1518.                 $qb = $em->createQueryBuilder();
  1519.                 $villa_kategoriler = $qb->select('k.dilgrup,k.adi,k.seourl,k.sayfabasligi,k.anahtarkelimeler,k.sayfaaciklamasi,k.ustid,k.resim')
  1520.                     ->from('PanelBundle:VillaKategori', 'k')
  1521.                     ->join('k.dil', 'd')
  1522.                     ->where("k.seourl='$seo14' and d.id=" . $suankiDil['id'])
  1523.                     ->orderBy('k.sira', 'ASC')
  1524.                     ->getQuery()
  1525.                     ->getScalarResult();
  1526.                 if(count($villa_kategoriler)>0){
  1527.                     $qb = $em->createQueryBuilder();
  1528.                     $villa_kategorileri = $qb->select('k.dilgrup,k.adi,k.seourl,k.sayfabasligi,k.anahtarkelimeler,k.sayfaaciklamasi,k.ustid,k.resim')
  1529.                         ->from('PanelBundle:VillaKategori', 'k')
  1530.                         ->join('k.dil', 'd')
  1531.                         ->where("k.ustid='".$villa_kategoriler[0]['dilgrup']."' and d.id=" . $suankiDil['id'])
  1532.                         ->orderBy('k.sira', 'ASC')
  1533.                         ->getQuery()
  1534.                         ->getScalarResult();
  1536.                     return $this->render('@Site/Sites/ilanKategori.html.twig',array('kategori'=>$villa_kategoriler[0],'kategoriler'=>$villa_kategorileri));
  1537.                 }else{
  1538.                     $qb = $em->createQueryBuilder();
  1539.                     $ilan = $qb->select('i.id,i.adi,i.title,i.seo,i.keywords,i.description,i.metin,i.girisTarihi,i.cikisTarihi,i.depozito,i.temizlik,i.havuzbahceBakim,i.konum,i.kisi,i.yatak,i.banyo,i.dilgrup,i.kategoriId,i.resimler,i.durum,i.ozellikler,i.yasaklar,i.il,i.ilce,i.semt')
  1540.                         ->from('PanelBundle:Villa', 'i')
  1541.                         ->join('i.dil', 'd')
  1542.                         ->where("i.seo='" .$seo14. "' and d.id=" . $suankiDil['id'])
  1543.                         ->orderBy('i.id', 'DESC')
  1544.                         ->getQuery()
  1545.                         ->getScalarResult();
  1546.                     if(count($ilan)>0) {
  1547.                         return $this->render('@Site/Sites/ilan.html.twig', array('ilan' => $ilan[0]));
  1548.                     }
  1549.                 }
  1550.                 if($sayfa['kategori']==0) {
  1551.                     // Sayfa İçi
  1552.                     $qb = $em->createQueryBuilder();
  1553.                     $icerik = $qb->select(implode(',',$icerikalani).',t.dilgrup,t.kategoriId,d.id as did,t.sayfaId')
  1554.                         ->from('PanelBundle:' . $sayfa['tabloAdi'], 't')
  1555.                         ->join('t.dil', 'd')
  1556.                         ->where("t.seourl='" .$seo14. "' and d.id=" . $suankiDil['id'])
  1557.                         ->addOrderBy('t.sira', 'ASC')
  1558.                         ->addOrderBy('t.id', 'DESC')
  1559.                         ->getQuery()
  1560.                         ->getScalarResult();
  1561.                     if(count($icerik)==0){
  1562.                         return $this->redirect($this->ayarlar('siteYolu'));
  1563.                     }
  1564.                     return $this->render('@Site/Sites/'.$view.'_ic.html.twig',array('sayfa'=>$sayfa,'icerik'=>$icerik[0]));
  1565.                 }else{
  1567.                     $qb = $em->createQueryBuilder();
  1568.                     $kategori = $qb->select('k.dilgrup,k.adi,k.seourl,k.sayfabasligi,k.anahtarkelimeler,k.sayfaaciklamasi,k.ustid,k.resim,k.sayfaId')
  1569.                         ->from('PanelBundle:Kategori', 'k')
  1570.                         ->join('k.dil', 'd')
  1571.                         ->where("k.seourl='" .$seo14. "' and d.id=" . $suankiDil['id'])
  1572.                         ->orderBy('k.sira', 'ASC')
  1573.                         ->getQuery()
  1574.                         ->getScalarResult();
  1576.                     if(count($kategori)==0){
  1577.                         $qb = $em->createQueryBuilder();
  1578.                         $kategori = $qb->select('k.dilgrup,k.adi,k.seourl,k.sayfabasligi,k.anahtarkelimeler,k.sayfaaciklamasi,k.ustid,k.resim,k.sayfaId')
  1579.                             ->from('PanelBundle:Kategori', 'k')
  1580.                             ->join('k.dil', 'd')
  1581.                             ->where("k.seourl='" .$seo13. "' and d.id=" . $suankiDil['id'])
  1582.                             ->orderBy('k.sira', 'ASC')
  1583.                             ->getQuery()
  1584.                             ->getScalarResult();
  1587.                         $qb = $em->createQueryBuilder();
  1588.                         $icerik = $qb->select(implode(',', $icerikalani) . ',t.dilgrup,t.kategoriId,d.id as did,t.sayfaId')
  1589.                             ->from('PanelBundle:' . $sayfa['tabloAdi'], 't')
  1590.                             ->join('t.dil', 'd')
  1591.                             ->where("t.kategoriId=" . $kategori[0]['dilgrup'] . " and t.seourl='".$seo14."' and d.id=" . $suankiDil['id'])
  1592.                             ->addOrderBy('t.sira', 'ASC')
  1593.                             ->addOrderBy('t.id', 'DESC')
  1594.                             ->getQuery()
  1595.                             ->getScalarResult();
  1597.                         if(count($kategori)<1 and count($icerik)<1){
  1598.                             return $this->redirect($this->ayarlar('siteYolu'));
  1599.                         }
  1601.                         return $this->render('@Site/Sites/' . $view . '_ic.html.twig', array('sayfa' => $sayfa, 'kategori' => $kategori[0], 'icerik' => $icerik[0]));
  1603.                     } else {
  1604.                         $qb = $em->createQueryBuilder();
  1605.                         $kategoriler = $qb->select('k.dilgrup,k.adi,k.seourl,k.sayfabasligi,k.anahtarkelimeler,k.sayfaaciklamasi,k.ustid,k.resim,k.sayfaId')
  1606.                             ->from('PanelBundle:Kategori', 'k')
  1607.                             ->join('k.dil', 'd')
  1608.                             ->where("k.ustid=" . $kategori[0]['dilgrup'] . " and d.id=" . $suankiDil['id'])
  1609.                             ->orderBy('k.sira', 'ASC')
  1610.                             ->getQuery()
  1611.                             ->getScalarResult();
  1613.                         $qb = $em->createQueryBuilder();
  1614.                         $icerikler = $qb->select(implode(',', $icerikalani) . ',t.dilgrup,t.kategoriId,d.id as did,t.sayfaId')
  1615.                             ->from('PanelBundle:' . $sayfa['tabloAdi'], 't')
  1616.                             ->join('t.dil', 'd')
  1617.                             ->where("t.kategoriId=" . $kategori[0]['dilgrup'] . " and d.id=" . $suankiDil['id'])
  1618.                             ->addOrderBy('t.sira', 'ASC')
  1619.                             ->addOrderBy('t.id', 'DESC')
  1620.                             ->getQuery()
  1621.                             ->getScalarResult();
  1624.                         return $this->render('@Site/Sites/' . $view . '_kategori.html.twig', array('sayfa' => $sayfa, 'kategori' => $kategori[0], 'icerikler' => $icerikler, 'kategoriler' => $kategoriler));
  1626.                     }
  1627.                 }
  1628.             }
  1629.             else{
  1630.                 $qb = $em->createQueryBuilder();
  1631.                 $villa_kategoriler = $qb->select('k.dilgrup,k.adi,k.seourl,k.sayfabasligi,k.anahtarkelimeler,k.sayfaaciklamasi,k.ustid,k.resim')
  1632.                     ->from('PanelBundle:VillaKategori', 'k')
  1633.                     ->join('k.dil', 'd')
  1634.                     ->where("k.seourl='$seo15' and d.id=" . $suankiDil['id'])
  1635.                     ->orderBy('k.sira', 'ASC')
  1636.                     ->getQuery()
  1637.                     ->getScalarResult();
  1638.                 if(count($villa_kategoriler)>0){
  1639.                     $qb = $em->createQueryBuilder();
  1640.                     $villa_kategorileri = $qb->select('k.dilgrup,k.adi,k.seourl,k.sayfabasligi,k.anahtarkelimeler,k.sayfaaciklamasi,k.ustid,k.resim')
  1641.                         ->from('PanelBundle:VillaKategori', 'k')
  1642.                         ->join('k.dil', 'd')
  1643.                         ->where("k.ustid='".$villa_kategoriler[0]['dilgrup']."' and d.id=" . $suankiDil['id'])
  1644.                         ->orderBy('k.sira', 'ASC')
  1645.                         ->getQuery()
  1646.                         ->getScalarResult();
  1648.                     return $this->render('@Site/Sites/ilanKategori.html.twig',array('kategori'=>$villa_kategoriler[0],'kategoriler'=>$villa_kategorileri));
  1649.                 }else{
  1650.                     $qb = $em->createQueryBuilder();
  1651.                     $ilan = $qb->select('i.id,i.adi,i.title,i.seo,i.keywords,i.description,i.metin,i.girisTarihi,i.cikisTarihi,i.depozito,i.temizlik,i.havuzbahceBakim,i.konum,i.kisi,i.yatak,i.banyo,i.dilgrup,i.kategoriId,i.resimler,i.durum,i.ozellikler,i.yasaklar,i.il,i.ilce,i.semt')
  1652.                         ->from('PanelBundle:Villa', 'i')
  1653.                         ->join('i.dil', 'd')
  1654.                         ->where("i.seo='" .$seo15. "' and d.id=" . $suankiDil['id'])
  1655.                         ->orderBy('i.id', 'DESC')
  1656.                         ->getQuery()
  1657.                         ->getScalarResult();
  1658.                     if(count($ilan)>0) {
  1659.                         return $this->render('@Site/Sites/ilan.html.twig', array('ilan' => $ilan[0]));
  1660.                     }
  1661.                 }
  1662.                 if($sayfa['kategori']==0) {
  1663.                     // Sayfa İçi
  1664.                     $qb = $em->createQueryBuilder();
  1665.                     $icerik = $qb->select(implode(',',$icerikalani).',t.dilgrup,t.kategoriId,d.id as did,t.sayfaId')
  1666.                         ->from('PanelBundle:' . $sayfa['tabloAdi'], 't')
  1667.                         ->join('t.dil', 'd')
  1668.                         ->where("t.seourl='" .$seo15. "' and d.id=" . $suankiDil['id'])
  1669.                         ->addOrderBy('t.sira', 'ASC')
  1670.                         ->addOrderBy('t.id', 'DESC')
  1671.                         ->getQuery()
  1672.                         ->getScalarResult();
  1673.                     if(count($icerik)==0){
  1674.                         return $this->redirect($this->ayarlar('siteYolu'));
  1675.                     }
  1676.                     return $this->render('@Site/Sites/'.$view.'_ic.html.twig',array('sayfa'=>$sayfa,'icerik'=>$icerik[0]));
  1677.                 }else{
  1679.                     $qb = $em->createQueryBuilder();
  1680.                     $kategori = $qb->select('k.dilgrup,k.adi,k.seourl,k.sayfabasligi,k.anahtarkelimeler,k.sayfaaciklamasi,k.ustid,k.resim,k.sayfaId')
  1681.                         ->from('PanelBundle:Kategori', 'k')
  1682.                         ->join('k.dil', 'd')
  1683.                         ->where("k.seourl='" .$seo15. "' and d.id=" . $suankiDil['id'])
  1684.                         ->orderBy('k.sira', 'ASC')
  1685.                         ->getQuery()
  1686.                         ->getScalarResult();
  1688.                     if(count($kategori)==0){
  1689.                         $qb = $em->createQueryBuilder();
  1690.                         $kategori = $qb->select('k.dilgrup,k.adi,k.seourl,k.sayfabasligi,k.anahtarkelimeler,k.sayfaaciklamasi,k.ustid,k.resim,k.sayfaId')
  1691.                             ->from('PanelBundle:Kategori', 'k')
  1692.                             ->join('k.dil', 'd')
  1693.                             ->where("k.seourl='" .$seo14. "' and d.id=" . $suankiDil['id'])
  1694.                             ->orderBy('k.sira', 'ASC')
  1695.                             ->getQuery()
  1696.                             ->getScalarResult();
  1699.                         $qb = $em->createQueryBuilder();
  1700.                         $icerik = $qb->select(implode(',', $icerikalani) . ',t.dilgrup,t.kategoriId,d.id as did,t.sayfaId')
  1701.                             ->from('PanelBundle:' . $sayfa['tabloAdi'], 't')
  1702.                             ->join('t.dil', 'd')
  1703.                             ->where("t.kategoriId=" . $kategori[0]['dilgrup'] . " and t.seourl='".$seo15."' and d.id=" . $suankiDil['id'])
  1704.                             ->addOrderBy('t.sira', 'ASC')
  1705.                             ->addOrderBy('t.id', 'DESC')
  1706.                             ->getQuery()
  1707.                             ->getScalarResult();
  1709.                         if(count($kategori)<1 and count($icerik)<1){
  1710.                             return $this->redirect($this->ayarlar('siteYolu'));
  1711.                         }
  1713.                         return $this->render('@Site/Sites/' . $view . '_ic.html.twig', array('sayfa' => $sayfa, 'kategori' => $kategori[0], 'icerik' => $icerik[0]));
  1715.                     } else {
  1716.                         $qb = $em->createQueryBuilder();
  1717.                         $kategoriler = $qb->select('k.dilgrup,k.adi,k.seourl,k.sayfabasligi,k.anahtarkelimeler,k.sayfaaciklamasi,k.ustid,k.resim,k.sayfaId')
  1718.                             ->from('PanelBundle:Kategori', 'k')
  1719.                             ->join('k.dil', 'd')
  1720.                             ->where("k.ustid=" . $kategori[0]['dilgrup'] . " and d.id=" . $suankiDil['id'])
  1721.                             ->orderBy('k.sira', 'ASC')
  1722.                             ->getQuery()
  1723.                             ->getScalarResult();
  1725.                         $qb = $em->createQueryBuilder();
  1726.                         $icerikler = $qb->select(implode(',', $icerikalani) . ',t.dilgrup,t.kategoriId,d.id as did,t.sayfaId')
  1727.                             ->from('PanelBundle:' . $sayfa['tabloAdi'], 't')
  1728.                             ->join('t.dil', 'd')
  1729.                             ->where("t.kategoriId=" . $kategori[0]['dilgrup'] . " and d.id=" . $suankiDil['id'])
  1730.                             ->addOrderBy('t.sira', 'ASC')
  1731.                             ->addOrderBy('t.id', 'DESC')
  1732.                             ->getQuery()
  1733.                             ->getScalarResult();
  1736.                         return $this->render('@Site/Sites/' . $view . '_kategori.html.twig', array('sayfa' => $sayfa, 'kategori' => $kategori[0], 'icerikler' => $icerikler, 'kategoriler' => $kategoriler));
  1738.                     }
  1739.                 }
  1740.             }
  1741.         }
  1743.         return new Response('');
  1744.     }
  1746.     public function formKayitAction($dil='',Request $veri){
  1747.         $em = $this->getDoctrine()->getManager();
  1749.         if($dil==''){
  1750.             $qb = $em->createQueryBuilder();
  1751.             $dill=$qb->select('d.id,d.kisa,d.uzun')
  1752.                 ->from('PanelBundle:Dil', 'd')
  1753.                 ->where('d.varsayilan=1 and d.aktif=1')
  1754.                 ->orderBy('d.aktif','DESC')
  1755.                 ->getQuery()
  1756.                 ->getScalarResult();
  1757.             $dil = $dill[0]['id'];
  1758.             $this->get('session')->set('dil',$dill[0]);
  1759.         }else{
  1760.             $qb = $em->createQueryBuilder();
  1761.             $dill=$qb->select('d.id,d.kisa,d.uzun')
  1762.                 ->from('PanelBundle:Dil', 'd')
  1763.                 ->where("d.kisa='$dil' and d.aktif=1")
  1764.                 ->orderBy('d.aktif','DESC')
  1765.                 ->getQuery()
  1766.                 ->getScalarResult();
  1767.             if(count($dill)>0){
  1768.                 $dil = $dill[0]['id'];
  1769.                 $this->get('session')->set('dil',$dill[0]);
  1770.             }else{
  1771.                 return $this->redirect($this->ayarlar('siteYolu'));
  1772.             }
  1773.         }
  1776.         $id = $veri->request->get('id');
  1779.         $response=$veri->request->get("g-recaptcha-response");
  1780.         $secret="6LcPodIUAAAAALHNzkiwoFvECemw3Gu93EfgJFKD";
  1781.         $remoteip=$_SERVER["REMOTE_ADDR"];
  1783.         $ch = curl_init();
  1784.         curl_setopt($ch, CURLOPT_URL, "https://www.google.com/recaptcha/api/siteverify?secret=$secret&response=$response&remoteip=$remoteip");
  1785.         curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
  1786.         $output = curl_exec($ch);
  1787.         curl_close($ch);
  1789.         $result=json_decode($output);
  1790.         if($result->success==1)
  1791.         {
  1793.         $qb = $em->createQueryBuilder();
  1794.         $form=$qb->select('f.adi,f.tip,f.veri,f.alan,f.zorunlu,f.eposta')
  1795.             ->from('PanelBundle:Form', 'f')
  1796.             ->where("f.id =".$id)
  1797.             ->getQuery()
  1798.             ->getScalarResult();
  1800.         $tipler = explode('~',$form[0]['tip']);
  1801.         $alanlar = explode('~',$form[0]['alan']);
  1803.         $kayit=[];
  1804.         $eposta_metin='';
  1806.         foreach ($tipler as $key=>$tip){
  1808.             if($tip=='input'){
  1809.                 $kayit[] = $veri->request->get($this->seo($alanlar[$key]));
  1810.                 $eposta_metin .= '<b>'.$alanlar[$key].'</b>: '.$veri->request->get($this->seo($alanlar[$key])).'<br>';
  1811.             }
  1812.             elseif($tip=='inputPhone'){
  1813.                 $kayit[] = $veri->request->get($this->seo($alanlar[$key]));
  1814.                 $eposta_metin .= '<b>'.$alanlar[$key].'</b>: '.$veri->request->get($this->seo($alanlar[$key])).'<br>';
  1815.             }
  1816.             elseif($tip=='inputEmail'){
  1817.                 $kayit[] = $veri->request->get($this->seo($alanlar[$key]));
  1818.                 $eposta_metin .= '<b>'.$alanlar[$key].'</b>: '.$veri->request->get($this->seo($alanlar[$key])).'<br>';
  1819.             }
  1820.             elseif($tip=='inputNumeric'){
  1821.                 $kayit[] = $veri->request->get($this->seo($alanlar[$key]));
  1822.                 $eposta_metin .= '<b>'.$alanlar[$key].'</b>: '.$veri->request->get($this->seo($alanlar[$key])).'<br>';
  1823.             }
  1824.             elseif($tip=='inputPrice'){
  1825.                 $kayit[] = $veri->request->get($this->seo($alanlar[$key]));
  1826.                 $eposta_metin .= '<b>'.$alanlar[$key].'</b>: '.$veri->request->get($this->seo($alanlar[$key])).'<br>';
  1827.             }
  1828.             elseif($tip=='inputDate'){
  1829.                 $kayit[] = $veri->request->get($this->seo($alanlar[$key]));
  1830.                 $eposta_metin .= '<b>'.$alanlar[$key].'</b>: '.$veri->request->get($this->seo($alanlar[$key])).'<br>';
  1831.             }
  1832.             elseif($tip=='textarea'){
  1833.                 $kayit[] = $veri->request->get($this->seo($alanlar[$key]));
  1834.                 $eposta_metin .= '<b>'.$alanlar[$key].'</b>: '.$veri->request->get($this->seo($alanlar[$key])).'<br>';
  1835.             }
  1836.             elseif($tip=='select'){
  1837.                 $kayit[] = $veri->request->get($this->seo($alanlar[$key]));
  1838.                 $eposta_metin .= '<b>'.$alanlar[$key].'</b>: '.$veri->request->get($this->seo($alanlar[$key])).'<br>';
  1839.             }
  1840.             elseif($tip=='checkbox'){
  1841.                 $kayit[] = implode(',',$veri->request->get($this->seo($alanlar[$key])));
  1842.                 $eposta_metin .= '<b>'.$alanlar[$key].'</b>: '.implode(',',$veri->request->get($this->seo($alanlar[$key]))).'<br>';
  1843.             }
  1844.             elseif($tip=='radio'){
  1845.                 $kayit[] = $veri->request->get($this->seo($alanlar[$key]));
  1846.                 $eposta_metin .= '<b>'.$alanlar[$key].'</b>: '.$veri->request->get($this->seo($alanlar[$key])).'<br>';
  1847.             }
  1848.             elseif($tip=='file'){
  1849.                 if (!empty($_FILES[$this->seo($alanlar[$key])]['name'])) {
  1850.                     $dosya = $this->seo($this->seo($alanlar[$key])) . '_' . time() . '_' . $this->uzantiBul($_FILES[$this->seo($alanlar[$key])]['type']);
  1851.                     move_uploaded_file($_FILES[$this->seo($alanlar[$key])]['tmp_name'], "uploads/" . $dosya . "");
  1852.                     $kayit[] = $dosya;
  1853.                     $eposta_metin .= '<b>'.$alanlar[$key].'</b>: <a target="_blank" href="'.$this->ayarlar('siteYolu').'uploads/'.$dosya.'"><img src="'.$this->ayarlar('siteYolu').'uploads/'.$dosya.'"></a><br>';
  1854.                 }else{
  1855.                     $kayit[] = '';
  1856.                     $eposta_metin .= '<b>'.$alanlar[$key].'</b>:';
  1857.                 }
  1859.             }
  1861.         }
  1863.         $ff = $em->getReference('PanelBundle:Form',$id);
  1864.         $formKayit = new FormKayit();
  1865.         $formKayit->setForm($ff);
  1866.         $formKayit->setOkuma(0);
  1867.         $formKayit->setTarih(new \DateTime('now'));
  1868.         $formKayit->setKayit(implode('~',$kayit));
  1869.         $em->persist($formKayit);
  1870.         $em->flush();
  1872.             if ($form[0]['eposta']==1){
  1873.                 $message = \Swift_Message::newInstance()
  1874.                     ->setSubject($form[0]['adi'].' - '.$this->ayarlar('siteAdi'))
  1875.                     ->setFrom(array($this->ayarlar('sistemPosta')=>$this->ayarlar('siteAdi')))
  1876.                     ->setTo(array($this->iletisimBilgileri('eposta')=>$this->ayarlar('siteAdi')))
  1877.                     ->setBody($this->renderView('@Site/Base/formMail.html.twig', array('konu' => $form[0]['adi'],'icerik'=>$eposta_metin)), 'text/html');
  1878.                 $this->get('mailer')->send($message);
  1880.             }
  1882.             $status=1;
  1883.         }
  1884.         else {
  1885.             $status=0;
  1886.         }
  1888.         return $this->render('@Site/Base/formReturn.html.twig',array('status'=>$status,'referer'=>$_SERVER['HTTP_REFERER']));
  1889.     }
  1892.     public function ilanGetirAction($dil='',Request $request){
  1893.         $em = $this->getDoctrine()->getManager();
  1894.         $dil = $this->get('session')->get('dil');
  1896.         $siralama = $request->request->get('siralama');
  1897.         $ozellik = $request->request->get('ozellik');
  1898.         $minFiyat = $request->request->get('minFiyat');
  1899.         $maxFiyat = $request->request->get('maxFiyat');
  1900.         $kategori = $request->request->get('kategori');
  1901.         $girisTarihi = $request->request->get('girisTarihi');
  1902.         $cikisTarihi = $request->request->get('cikisTarihi');
  1903.         $uc_gun = $request->request->get('uc_gun');
  1905.         $kategoriler = $kategori.$this->villa_kategoriIleri($kategori);
  1906.         $sql  =' and i.kategoriId in('.$kategoriler.')';
  1908.         $semt = $request->request->get('semt');
  1909.         if(!empty($semt)){
  1910.             $sql.=' and i.semt='.$semt;
  1911.         }
  1913.         $yetiskinSayisi = intval($request->request->get('yetiskinSayisi'));
  1914.         $cocukSayisi = floor(intval($request->request->get('cocukSayisi'))/2);
  1915.         $kisiSayisi = $yetiskinSayisi+$cocukSayisi;
  1916.         $sql.=' and i.kisi>='.$kisiSayisi;
  1920.         $qb = $em->createQueryBuilder();
  1921.         $ilanlar = $qb->select('i.adi,i.resimler,i.kisi,i.yatak,i.banyo,i.semt,i.ilce,i.il,i.kategoriId,i.seo,i.dilgrup,i.ozellikler')
  1922.             ->from('PanelBundle:Villa', 'i')
  1923.             ->join('i.dil', 'd')
  1924.             ->where('i.durum=1 and d.id=' . $dil['id'].$sql)
  1925.             ->orderBy('i.id','DESC')
  1926.             ->getQuery()
  1927.             ->setResultCacheId('ilanGetirr')
  1928.             ->setResultCacheLifetime(60)
  1929.             ->getScalarResult();
  1931.         foreach ($ilanlar as $key=>$ilan){
  1932.             $f1 = $this->ilan_fiyatBul($ilan['dilgrup'])[0];
  1933.             $f2 = $this->ilan_fiyatBul($ilan['dilgrup'])[1];
  1934.             $ilanlar[$key]['fiyat1']=$f1;
  1935.             $ilanlar[$key]['fiyat2']=$f2;
  1936.             if ($siralama!='id') {
  1937.                 if ($siralama=='fasc' or $siralama=='fdesc'){
  1938.                     $degisken[$key] = $f1;
  1939.                 }else{
  1940.                     $degisken[$key] = $ilan['adi'];
  1941.                 }
  1942.             }
  1943.         }
  1945.         if ($siralama!='id'){
  1946.             if ($siralama=='idesc' or $siralama=='fdesc') {
  1947.                 array_multisort($degisken, SORT_DESC, $ilanlar);
  1948.             }else{
  1949.                 array_multisort($degisken, SORT_ASC, $ilanlar);
  1950.             }
  1951.         }
  1953.         return $this->render('@Site/Sites/ilanGetir.html.twig',array('ilanlar'=>$ilanlar,'minFiyat'=>doubleval($minFiyat),'maxFiyat'=>doubleval($maxFiyat),'ozellik'=>$ozellik,'girisTarihi'=>$girisTarihi,'cikisTarihi'=>$cikisTarihi,'uc_gun'=>$uc_gun));
  1954.     }
  1956.     public function rezSorgulaAction(Request $request){
  1957.         $em = $this->getDoctrine()->getManager();
  1958.         $dil = $this->get('session')->get('dil');
  1960.         $dilgrup = $request->request->get('dilgrup');
  1962.         $girisTarihi = new \DateTime($request->request->get('girisTarihi').' 00:00:00');
  1963.         $cikisTarihi = new \DateTime($request->request->get('cikisTarihi').' 00:00:00');
  1966.         $fark = date_diff($girisTarihi, $cikisTarihi);
  1968.         $yetiskinSayisi = intval($request->request->get('yetiskinSayisi'));
  1969.         $cocukSayisi = floor(intval($request->request->get('cocukSayisi'))/2);
  1970.         $kisiSayisi = $yetiskinSayisi+$cocukSayisi;
  1972.         /// rezervasyon sorgusu
  1974.         $qb = $em->createQueryBuilder();
  1975.         $ilan = $qb->select('i.kisi')
  1976.             ->from('PanelBundle:Villa', 'i')
  1977.             ->join('i.dil', 'd')
  1978.             ->where('i.durum=1 and d.id=' . $dil['id'].' and i.dilgrup='.$dilgrup)
  1979.             ->orderBy('i.id','DESC')
  1980.             ->getQuery()
  1981.             ->setResultCacheId('rezSor2')
  1982.             ->setResultCacheLifetime(60)
  1983.             ->getScalarResult();
  1984.         if($kisiSayisi>$ilan[0]['kisi']){
  1985.             return new Response('<div class="alert alert-danger">Kişi sayısı çok fazla!</div>');
  1986.         }
  1988.         $qb = $em->createQueryBuilder();
  1989.         $fiyatlar = $qb->select('f.baslangicTarihi,f.bitisTarihi,f.minGece,f.fiyat')
  1990.             ->from('PanelBundle:Fiyat', 'f')
  1991.             ->where('f.ay='.$cikisTarihi->format('m').' and f.icerikId='.$dilgrup)
  1992.             ->orderBy('f.ay','ASC')
  1993.             ->getQuery()
  1994.             ->setResultCacheId('rezSor3')
  1995.             ->setResultCacheLifetime(60)
  1996.             ->getScalarResult();
  1998.        if(count($fiyatlar)==0){
  1999.            return new Response('<div class="alert alert-danger">Belirtilen giriş/çıkış ayında hiç fiyat belirlenmemiş. Kiralanamaz.</div>');
  2000.        }
  2002.        $fiyatt = '';
  2003.        foreach ($fiyatlar as $fiyat){
  2004.           $baslangic=explode('/',$fiyat['baslangicTarihi']);
  2005.           $bitis=explode('/',$fiyat['bitisTarihi']);
  2007.            $baslangicTarihi=new \DateTime(date('Y').'-'.$baslangic[1].'-'.$baslangic[0].' 00:00:00');
  2008.            $bitisTarihi=new \DateTime(date('Y').'-'.$bitis[1].'-'.$bitis[0].' 00:00:00');
  2011.            if ($cikisTarihi->format('U') >= $baslangicTarihi->format('U') and $cikisTarihi->format('U') <= $bitisTarihi->format('U')){
  2012.                 $fiyatt = $fiyat;
  2013.            }
  2015.        }
  2017.        if(!empty($fiyatt)){
  2018.            if ($fark->format('%a') < $fiyatt['minGece']){
  2019.                return new Response('<div class="alert alert-danger">Minimum '.$fiyatt['minGece'].' gece kiralanabilir.</div>');
  2020.            }
  2021.        }
  2027.         return $this->render('@Site/Sites/rezForm.html.twig',array('fiyat'=>$fiyatt,'gunluk'=>$fark->format('%a')));
  2028.     }
  2030.     public function talepGonderAction(Request $request)
  2031.     {
  2032.         $em = $this->getDoctrine()->getManager();
  2033.         $dil = $this->get('session')->get('dil');
  2035.         $ilan = $request->request->get('ilan');
  2037.         $girisTarihi = new \DateTime($request->request->get('girisTarihi') . ' 00:00:00');
  2038.         $cikisTarihi = new \DateTime($request->request->get('cikisTarihi') . ' 00:00:00');
  2040.         $yetiskinSayisi = intval($request->request->get('yetiskinSayisi'));
  2041.         $cocukSayisi = intval($request->request->get('cocukSayisi'));
  2042.         $toplam = $request->request->get('toplam');
  2043.         $kapora = $request->request->get('kapora');
  2044.         $kalan = $request->request->get('kalan');
  2045.         $adsoyad = $request->request->get('adsoyad');
  2046.         $telefon = $request->request->get('telefon');
  2047.         $eposta = $request->request->get('eposta');
  2048.         $odemesekli = $request->request->get('odemesekli');
  2049.         $gece = $request->request->get('gece');
  2050.         $mesaj = $request->request->get('mesaj');
  2051.         if (empty($mesaj)){ $mesaj=null; }
  2053.         $rez = new Rezervasyon();
  2054.         $rez->setIlanId($ilan);
  2055.         $rez->setGirisTarihi($girisTarihi);
  2056.         $rez->setCikisTarihi($cikisTarihi);
  2057.         $rez->setYetiskinSayisi($yetiskinSayisi);
  2058.         $rez->setCocukSayisi($cocukSayisi);
  2059.         $rez->setDurum(0);
  2060.         $rez->setAdsoyad($adsoyad);
  2061.         $rez->setEposta($eposta);
  2062.         $rez->setTelefon($telefon);
  2063.         $rez->setOdemeSekli($odemesekli);
  2064.         $rez->setMesaj($mesaj);
  2065.         $rez->setFiyat($toplam);
  2066.         $rez->setKapora($kapora);
  2067.         $rez->setKalan($kalan);
  2068.         $rez->setGece($gece);
  2069.         $em->persist($rez);
  2070.         $em->flush();
  2073.         return new Response('');
  2075.     }
  2077.     public function rezTakipAction(Request $request)
  2078.     {
  2079.         $em = $this->getDoctrine()->getManager();
  2080.         $dil = $this->get('session')->get('dil');
  2082.         $eposta = $request->request->get('eposta');
  2083.         $onayKodu = $request->request->get('onayKodu');
  2085.         $qb = $em->createQueryBuilder();
  2086.         $rezervasyon=$qb->select('r.girisTarihi,r.cikisTarihi,r.yetiskinSayisi,r.cocukSayisi,r.durum,r.adsoyad,r.eposta,r.telefon,r.odemeSekli,r.mesaj,r.fiyat,r.kapora,r.gece,r.kalan,r.id,r.onayKodu,r.ilanId')
  2087.             ->from('PanelBundle:Rezervasyon', 'r')
  2088.             ->where("r.eposta='$eposta' and r.onayKodu='$onayKodu'")
  2089.             ->getQuery()
  2090.             ->getScalarResult();
  2092.         if (count($rezervasyon)==0){
  2093.             return new Response(1);
  2094.         }
  2096.         return $this->render('@Site/Sites/rezTakip.html.twig',array('rezervasyon'=>$rezervasyon[0]));
  2098.     }
  2100.     public function hizliAramaAction($dil='',Request $request)
  2101.     {
  2102.         $em = $this->getDoctrine()->getManager();
  2103.         $dil = $this->get('session')->get('dil');
  2104.         $arama = [];
  2105.         $arama['bolge'] = $request->request->get('bolge');
  2106.         $arama['girisTarihi'] = $request->request->get('girisTarihi');
  2107.         $arama['cikisTarihi'] = $request->request->get('cikisTarihi');
  2108.         $arama['yetiskinSayisi'] = $request->request->get('yetiskinSayisi');
  2110.         $this->get('session')->set('arama',$arama);
  2111.         return new Response('');
  2113.     }
  2114. }