src/Trinity/ProjectssitesBundle/Controller/ProjectssitesController.php line 729

Open in your IDE?
  1. <?php
  3. namespace App\Trinity\ProjectssitesBundle\Controller;
  5. use DateTime;
  6. use PHPUnit\Exception;
  7. use Doctrine\ORM\EntityManager;
  8. use App\CmsBundle\Entity\Media;
  9. use App\CmsBundle\Classes\Postcode;
  10. use Doctrine\ORM\EntityManagerInterface;
  11. use Symfony\Component\HttpFoundation\Request;
  12. use App\CmsBundle\Controller\StorageController;
  13. use Doctrine\Common\Collections\ArrayCollection;
  14. use Symfony\Component\HttpFoundation\JsonResponse;
  15. use App\Trinity\ProjectssitesBundle\Entity\Config;
  16. use Symfony\Component\HttpFoundation\File\UploadedFile;
  17. use App\Trinity\ProjectssitesBundle\classes\RealEstate;
  18. use App\Trinity\ProjectssitesBundle\classes\RealEstateOption;
  19. use App\Trinity\ProjectssitesBundle\classes\RealEstateMap;
  20. use Symfony\Component\Form\Extension\Core\Type\ChoiceType;
  21. use Symfony\Component\Form\Extension\Core\Type\SubmitType;
  22. use Symfony\Component\Form\Extension\Core\Type\TextType;
  23. use Sensio\Bundle\FrameworkExtraBundle\Configuration\Route;
  24. use Symfony\Component\Form\Extension\Core\Type\CheckboxType;
  25. use Sensio\Bundle\FrameworkExtraBundle\Configuration\Template;
  26. use Symfony\Component\Routing\Generator\UrlGeneratorInterface;
  27. use App\Trinity\ProjectssitesBundle\Entity\RealEstate as RealEstateEntity;
  28. use App\Trinity\ProjectssitesBundle\Entity\RealEstateOption as RealEstateOptionEntity;
  29. use App\Trinity\ProjectssitesBundle\Entity\RealEstateMap as RealEstateMapEntity;
  31. /**
  32.  * Class ProjectensitesController
  33.  * @package App\Trinity\ProjectssitesBundle\Controller
  34.  */
  35. class ProjectssitesController extends StorageController
  36. {
  37.     /**
  38.      * @Route("/admin/realestate", name="admin_mod_projectssites")
  39.      * @Template()
  40.      */
  41.     public function index(Request $request){
  42.         // Initialize StorageController
  43.         parent::init($request);
  45.         $this->breadcrumbs->addRouteItem('Configuratie', 'admin_mod_projectssites_config');
  46.         $this->breadcrumbs->addRouteItem('Real Estate Bundle', 'admin_mod_projectssites');
  48.         $realEstates = $this->getDoctrine()->getRepository('TrinityProjectssitesBundle:RealEstate')->findBy([
  49.             'language'=> $this->language,
  50.             'settings'=> $this->Settings]);
  52.         foreach($realEstates as $realEstate){
  53.             $realEstate->realEstateOptions = $realEstate->getRealEstateOptions();;
  54.         }
  56.         $config = $this->getDoctrine()->getRepository('TrinityProjectssitesBundle:Config')->findOneBy(['language' => $this->language, 'settings' => $this->Settings]);
  58.         return $this->render('@TrinityProjectssites/backend/realestate/overview.html.twig', $this->attributes([
  59.             'realEstates' => $realEstates,
  60.             'config' => $config,
  61.             'settings' => $this->Settings,
  62.         ]));
  63.     }
  65.     /**
  66.      * @Route("/admin/realestateoptions", name="admin_mod_realestateoptions")
  67.      * @Template()
  68.      */
  69.     public function realEstateOptions(Request $request){
  70.         // Initialize StorageController
  71.         parent::init($request);
  73.         $this->breadcrumbs->addRouteItem('Configuratie', 'admin_mod_projectssites_config');
  74.         $this->breadcrumbs->addRouteItem('Real Estate Bundle', 'admin_mod_projectssites');
  76.         $realEstateOptions = $this->getDoctrine()->getRepository('TrinityProjectssitesBundle:RealEstateOption')->findBy([
  77.             'language'=> $this->language,
  78.             'settings'=> $this->Settings]);
  80.         $config = $this->getDoctrine()->getRepository('TrinityProjectssitesBundle:Config')->findOneBy(['language' => $this->language, 'settings' => $this->Settings]);
  82.         return $this->render('@TrinityProjectssites/backend/realestateoption/overview.html.twig', $this->attributes([
  83.             'realEstateOptions' => $realEstateOptions,
  84.             'config' => $config,
  85.             'settings' => $this->Settings,
  86.         ]));
  87.     }
  88.     
  89.     /**
  90.      * Return link data when required within the link form
  91.      *
  92.      * @param object  Doctrine object
  93.      *
  94.      * @return array   Array with config options
  95.      */
  96.     public function getLinkData($em){
  97.         return [
  98.             // Return data to link form
  99.         ];
  100.     }
  102.     /**
  103.      * Show dashboard blocks
  104.      *
  105.      * @return array List of blocks
  106.      */
  107.     public function dashboardBlocks(){
  108.         // Return block data to show on Trinity dashboard in the following format.
  109.         // You can do whatever you want in this function, just return data as below.
  110.         return [
  111.             [
  113.                 'title' => 'Mijn lege module',
  114.                 'class' => '',
  115.                 'content' => '<div style="text-align:center;padding:20px;">Lege module</div>'
  116.             ]
  117.         ];
  118.     }
  120.     /**
  121.      * @Route("/admin/projects/config", name="admin_mod_projectssites_config")
  122.      * @Template()
  123.      */
  124.     public function editConfig(Request $request, EntityManagerInterface $em, $id = null){
  125.         // Initialize StorageController
  126.         parent::init($request);
  128.         $this->breadcrumbs->addRouteItem('Real Estate Bundle', 'admin_mod_projectssites');
  129.         $this->breadcrumbs->addRouteItem('Configuratie', 'admin_mod_projectssites_config');
  131.         $config = $this->getDoctrine()->getRepository('TrinityProjectssitesBundle:Config')->findOneBy(['language' => $this->language, 'settings' => $this->Settings]);
  133.         if (empty($config)) {
  134.             $config = new Config();
  135.             $config->setLanguage($this->language);
  136.             $config->setSettings($this->Settings);
  137.         }
  139.         $errors = [];
  140.         $Form = $this->createFormBuilder($config);
  142.         $pageChoises = [];
  143.         $pages = $this->getDoctrine()->getRepository('CmsBundle:Page')->findBy(['language' => $this->language, 'settings' => $this->Settings]);
  144.         foreach($pages as $page){
  145.             $pageChoises[$page->getTitle()] = $page;
  146.         }
  148.         $Form->add('overview_page', ChoiceType::class, array(
  149.             'choices' => array_merge(['Kies overzichtspagina' => ''],$pageChoises),
  150.             'attr' => ['class' => 'validate'], 'label' => 'Kies overzichtspagina *'
  151.             ,'row_attr' => ['class' => 'form-floating']));
  152.         $Form->add('detail_page_root', ChoiceType::class, array(
  153.             'choices' => array_merge(['Kies pagina detail root pagina' => ''],$pageChoises),
  154.             'attr' => ['class' => 'validate'], 'label' => 'Kies pagina detail root pagina *'
  155.             ,'row_attr' => ['class' => 'form-floating']));
  156.         $Form->add('google_maps_zoom', ChoiceType::class, array(
  157.             'choices' => array_merge(['Kies Google maps zoom level' => ''],array("Level 1"=>1,"Level 2"=>2,"Level 3"=>3,"Level 4"=>4,"Level 5"=>5,"Level 6"=>6,"Level 7"=>7,"Level 8"=>8,"Level 9"=>9,"Level 10"=>10,"Level 11"=>11,"Level 12"=>12,"Level 13"=>13,"Level 14"=>14,"Level 15"=>15,"Level 16"=>16,"Level 17"=>17,"Level 18"=>18)),
  158.             'attr' => array('placeholder' => 'Google maps zoom level'),
  159.             'row_attr' => ['class' => 'form-floating number']));
  160.         $Form->add('is_single_project', CheckboxType::class, array('label' => 'Enkel project', 'required' => false));
  161.         $Form->add('submit', SubmitType::class, ['label' => 'Opslaan','row_attr' => ['class' => 'none'], 'attr' => ['class' => 'btn btn-primary']]);
  162.         
  163.         $Form = $Form->getForm();
  165.         $Form->handleRequest($request);
  166.         if ($Form->isSubmitted() && $Form->isValid()) {
  168.             $em->persist($config);
  169.             $em->flush($config);
  171.             return $this->redirectToRoute('admin_mod_projectssites_config');
  172.         }
  174.         return $this->render('@TrinityProjectssites/backend/config/edit.html.twig', $this->attributes([
  175.             'config' => $config,
  176.             'form' => $Form->createView()
  177.         ]));
  178.     }
  180.     
  181.     /**
  182.      * @Route("/admin/realestate/maps", name="admin_mod_projectssites_real_estate_map")
  183.      * @Template()
  184.      */
  185.     public function realEstateMap(Request $request){
  186.         // Initialize StorageController
  187.         parent::init($request);
  189.         $this->breadcrumbs->addRouteItem('Real Estate Bundle', 'admin_mod_projectssites');
  190.         $this->breadcrumbs->addRouteItem('Kavels mappen', 'admin_mod_projectssites_real_estate_map');
  192.         $realEstateMaps = $this->getDoctrine()->getRepository('TrinityProjectssitesBundle:RealEstateMap')->findBy(['language' => $this->language, 'settings' => $this->Settings]);
  194.         return $this->render('@TrinityProjectssites/backend/realestatemap/index.html.twig', $this->attributes([
  195.             'realEstateMaps' => $realEstateMaps
  196.         ]));
  197.     }
  199.     /**
  200.      * @Route("/admin/realestate/map/add/", name="admin_mod_realestate_map_add")
  201.      * @Route("/admin/realestate/map/edit/{id}", name="admin_mod_realestate_map_edit")
  202.      * @Template()
  203.      */
  204.     public function editRealEstateMap(Request $request, $id = null){
  205.         // Initialize StorageController
  206.         parent::init($request);
  208.         $this->breadcrumbs->addRouteItem('Kavels', 'admin_mod_projectssites');
  209.         $this->breadcrumbs->addRouteItem('Kavels map Wijzigen', 'admin_mod_realestate_map_edit');
  210.         $em = $this->getDoctrine()->getManager();
  211.         
  212.         $realEstateMap = new RealEstateMapEntity();
  213.         $realEstateMapClass = new RealEstateMap();
  214.         $realEstateMapClass->setLanguage($this->language)
  215.             ->setSettings($this->Settings)
  216.             ->setRequest($request)
  217.             ->setLanguage($this->language)
  218.             ->setSettings($this->Settings)
  219.             ->setDoctrine($em);
  220.         $Form = $this->createFormBuilder($realEstateMap); 
  222.         if(!empty($id)){
  223.             $realEstateMap = $this->getDoctrine()->getRepository('TrinityProjectssitesBundle:RealEstateMap')->find($id);
  224.             if(empty($realEstateMap)){
  225.                 return $this->redirectToRoute('admin_mod_projectssites_real_estate_map');
  226.             }
  227.             $Form = $this->createFormBuilder($realEstateMap); 
  229.             if($realEstateMap->getSettings()->getId() != $this->Settings->getId()){
  230.                 return $this->redirectToRoute('admin_mod_projectssites_real_estate_map');
  231.             }
  232.         }
  233.         
  234.         $Form = $realEstateMapClass->setCurrentForm($Form)->getForm();
  235.         if(!empty($request)){
  236.             if ($Form->isSubmitted() && $Form->isValid()){
  237.                 if ($realEstateMapClass->getMessageType() == 'success'){
  238.                     if($_POST["action"] == "submit"){
  239.                         return $this->redirectToRoute('admin_mod_realestate_map_edit',["id" => $realEstateMap->getId()]);
  240.                     }else{
  241.                         return $this->redirectToRoute('admin_mod_projectssites_real_estate_map');
  242.                     }
  243.                     
  244.                 }
  245.                 $this->addFlash($realEstateMapClass->getMessageType(), $realEstateMapClass->getMessage());
  246.             }
  247.         }
  249.         return $this->render('@TrinityProjectssites/backend/realestatemap/edit.html.twig', $this->attributes([
  250.             'realEstateMap' => $realEstateMap,
  251.             'form' => $Form->createView(),
  252.             'maxFileSize' => 10,
  253.             'maxMediaFileSize' => $this->Settings->getMaxMediaSizeInKB()
  254.         ]));
  255.     }
  256.     
  257.     /**
  258.     * @Route("/admin/realestatemap/{id}/delete", name="admin_realestate_map_remove")
  259.     */
  260.     public function deleteRealEstateMap(Request $request, $id = null){
  261.        parent::init($request);
  262.        $em = $this->getDoctrine()->getManager();
  263.        $realestate = $this->getDoctrine()->getRepository('TrinityProjectenBundle:RealEstateMap')->find($id);
  264.        $em->remove($realestate);
  265.        $em->flush();
  267.        return $this->redirectToRoute('admin_mod_projectssites_real_estate_map');
  268.     }
  270.     /**
  271.      * @Route("/ajax/get/address/", name="admin_mod_ajax_get_address")
  272.      */
  273.     public function getAddressInfo(Request $request){
  274.         parent::init($request);
  275.         $addresssInfo = [];
  277.         if(isset($_POST['postcode']) && isset($_POST['housenumber'])){
  278.             $postcode = $_POST['postcode'];
  279.             $housenumber = $_POST['housenumber'];
  281.             $postcodeApi = new Postcode($this->Settings);
  282.             $addresssInfo = $postcodeApi->fetch($postcode, $housenumber);
  284.         }
  285.         return new JsonResponse($addresssInfo);
  286.     }
  288.     /**
  289.      * @Route("/ajax/get/konva/", name="admin_mod_ajax_get_konva")
  290.      */
  291.     public function ajaxGetMapKonva(Request $request){
  292.         parent::init($request);
  294.         if(!empty($_POST["mapId"])){
  295.             $mapId = $_POST["mapId"];
  297.             $realEstateMap = $this->getDoctrine()->getRepository('TrinityProjectssitesBundle:RealEstateMap')->find($mapId);
  298.             
  299.             $convaHtml = $this->renderView('@TrinityProjectssites/frontend/realestate/konva.html.twig', $this->attributes([
  300.                 'realestatemap' => $realEstateMap,                
  301.             ]));
  303.             return new JsonResponse(['status' => true,'realestatemap' => "/".$realEstateMap->getMapimage()->getWebPath(),'convaHtml'=> $convaHtml]);
  304.         }
  306.         return new JsonResponse(['status' => false]);
  307.     }
  309.     /**
  310.      * @Route("/admin/realestate/add/", name="admin_mod_realestate_add")
  311.      * @Route("/admin/realestate/edit/{id}", name="admin_mod_realestate_edit")
  312.      * @Template()
  313.     */
  314.     public function editRealEstate(Request $request, $id = null){
  315.         // Initialize StorageController
  316.         parent::init($request);
  318.         $this->breadcrumbs->addRouteItem('Kavels', 'admin_mod_projectssites');
  320.         if(!empty($id)){
  321.             $this->breadcrumbs->addRouteItem('Kavel Wijzigen', 'admin_mod_realestate_edit');
  322.         }else{
  323.             $this->breadcrumbs->addRouteItem('Kavel Toevoegen', 'admin_mod_realestate_add');
  324.         }
  326.         $em = $this->getDoctrine()->getManager();
  327.         $realEstate = new RealEstateEntity();
  329.         $realEstateClass = new RealEstate();
  330.         $realEstateClass->setLanguage($this->language)
  331.             ->setSettings($this->Settings)
  332.             ->setId($id)
  333.             ->setRequest($request)
  334.             ->setLanguage($this->language)
  335.             ->setSettings($this->Settings)
  336.             ->setDoctrine($em);
  337.         $Form = $this->createFormBuilder($realEstate); 
  339.         
  340.         $config = $this->getDoctrine()->getRepository('TrinityProjectssitesBundle:Config')->findOneBy(['language' => $this->language, 'settings' => $this->Settings]);
  343.         if(!empty($id)){
  344.             $realEstate = $this->getDoctrine()->getRepository('TrinityProjectssitesBundle:RealEstate')->find($id);
  345.             if(empty($realEstate)){
  346.                 return $this->redirectToRoute('admin_mod_projectssites');
  347.             }
  349.             $Form = $this->createFormBuilder($realEstate); 
  351.             if($realEstate->getSettings()->getId() != $this->Settings->getId()){
  352.                 return $this->redirectToRoute('admin_mod_projectssites');
  353.             }
  354.         }
  356.         $Form = $realEstateClass->setCurrentForm($Form)->getForm();
  357.         if(!empty($request)){
  358.             if ($Form->isSubmitted() && $Form->isValid()){
  359.                 if ($realEstateClass->getMessageType() == 'success'){                    
  360.                     if($_POST["action"] == "submit"){
  361.                         return $this->redirectToRoute('admin_mod_realestate_edit',["id" => $realEstate->getId()]);
  362.                     }else{
  363.                         return $this->redirectToRoute('admin_mod_projectssites');
  364.                     }
  365.                 }
  366.                 $this->addFlash($realEstateClass->getMessageType(), $realEstateClass->getMessage());
  367.             }
  368.         }     
  371.         $realEstateMap = null;
  372.         if(!empty($id)){
  373.             $realEstateMap = $realEstate->getRealEstateMap(); 
  374.         }
  376.         $realEstateOptionPrices = $this->getDoctrine()->getRepository('TrinityProjectssitesBundle:RealEstateOptionPrice')->findBy(['real_estate' => $id]);
  378.         
  379.         return $this->render('@TrinityProjectssites/backend/realestate/edit.html.twig', $this->attributes([
  380.             'realestate' => $realEstate,
  381.             'realEstateMap' => $realEstateMap,
  382.             'form' => $Form->createView(),
  383.             'maxFileSize' => 10,
  384.             'maxMediaFileSize' => $this->Settings->getMaxMediaSizeInKB(),
  385.             'config' => $config,
  386.             'realEstateOptionPrices' => $realEstateOptionPrices,
  387.         ]));
  388.     } 
  390.     /**
  391.      * @Route("/admin/realestateoption/add", name="admin_mod_realestate_option_add")
  392.      * @Route("/admin/realestateoption/edit/{id}", name="admin_mod_realestate_option_edit")
  393.      * @Template()
  394.      */
  395.     public function editRealEstateOption(Request $request,$id = null){
  396.         // Initialize StorageController
  397.         parent::init($request);
  399.         $this->breadcrumbs->addRouteItem('Kavels', 'admin_mod_projectssites');
  400.         $this->breadcrumbs->addRouteItem('Kavel optie Wijzigen', 'admin_mod_realestate_edit');
  402.         $em = $this->getDoctrine()->getManager();
  403.         $realEstateOption = new RealEstateOptionEntity();
  404.         $realEstateOptionContent = [];
  405.         $realEstateOptionDownload = [];
  406.         $realEstateAttribute = [];
  408.         $realEstateOptionClass = new RealEstateOption();
  409.         $realEstateOptionClass->setLanguage($this->language)
  410.             ->setSettings($this->Settings)
  411.             ->setRequest($request)
  412.             ->setLanguage($this->language)
  413.             ->setSettings($this->Settings)
  414.             ->setDoctrine($em);
  415.         $Form = $this->createFormBuilder($realEstateOption); 
  417.         if(!empty($id)){
  418.             $realEstateOption = $this->getDoctrine()->getRepository('TrinityProjectssitesBundle:RealEstateOption')->find($id);
  419.             if(empty($realEstateOption)){
  420.                 return $this->redirectToRoute('admin_mod_realestateoptions');
  421.             }
  422.             $Form = $this->createFormBuilder($realEstateOption); 
  424.             if($realEstateOption->getSettings()->getId() != $this->Settings->getId()){
  425.                 return $this->redirectToRoute('admin_mod_realestateoptions');
  426.             }
  428.             $realEstateOptionContent = $this->getDoctrine()->getRepository('TrinityProjectssitesBundle:RealEstateOptionContent')->findBy(['real_estate_option' => $id]);
  429.             $realEstateOptionDownload = $this->getDoctrine()->getRepository('TrinityProjectssitesBundle:RealEstateOptionDownload')->findBy(['real_estate_option' => $id]);
  430.             $realEstateAttribute = $this->getDoctrine()->getRepository('TrinityProjectssitesBundle:RealEstateAttribute')->findBy(['real_estate_option' => $id]);
  431.         }
  433.         $Form = $realEstateOptionClass->setCurrentForm($Form)->getForm();
  434.         if(!empty($request)){
  435.             if ($Form->isSubmitted() && $Form->isValid()){
  436.                 if ($realEstateOptionClass->getMessageType() == 'success'){
  437.                     if($_POST["action"] == "submit"){
  438.                         return $this->redirectToRoute('admin_mod_realestate_option_edit',["id" => $realEstateOption->getId()]);
  439.                     }else{
  440.                         return $this->redirectToRoute('admin_mod_realestateoptions');
  441.                     }
  442.                     
  443.                 }
  444.                 $this->addFlash($realEstateOptionClass->getMessageType(), $realEstateOptionClass->getMessage());
  445.             }
  446.         }
  448.         $realEstateOption = $realEstateOptionClass->setFotos($realEstateOption);
  449.         
  450.         
  451.         return $this->render('@TrinityProjectssites/backend/realestateoption/edit.html.twig', $this->attributes([
  452.             'realEstateOption' => $realEstateOption,
  453.             'realEstateOptionContent' => $realEstateOptionContent,
  454.             'realEstateOptionDownload' => $realEstateOptionDownload,
  455.             'realEstateAttribute' => $realEstateAttribute,
  456.             'form' => $Form->createView(),
  457.             'maxFileSize' => 10,
  458.             'maxMediaFileSize' => $this->Settings->getMaxMediaSizeInKB()
  459.         ]));
  460.     } 
  462.     /**
  463.      * Handle uploaded files
  464.      *
  465.      * @Route("/trinity/projects/upload/", name="trinity_mod_projects_upload")
  466.      */
  467.     public function uploadAction(Request $request){
  468.         parent::init($request);
  470.         if (!empty($_FILES['file'])) {
  471.             $file = $_FILES['file'];
  472.             $uploadedfile = new UploadedFile($file['tmp_name'], $file['name'], $file['type'], (int)$file['error']);
  473.             $em = $this->getDoctrine()->getManager();
  474.             $mediadir = $this->getDoctrine()->getRepository('CmsBundle:Mediadir')->findPathByName($em, (!empty($this->Settings->getHost()) ? $this->Settings->getHost() . '/' : '') .
  475.                 $this->trans('Instructor', [], 'neutral'), $this->language);
  477.             $mediafile = new Media();
  478.             $mediafile->setParent($mediadir);
  479.             $mediafile->setLabel($file['name']);
  480.             $mediafile->setDateAdd();
  481.             $mediafile->setFile($uploadedfile);
  482.             $mediafile->preUpload();
  483.             $mediafile->upload();
  484.             $em->persist($mediafile);
  485.             $em->flush($mediafile);
  487.             $mediafile->webPath = $mediafile->getWebPath();
  488.             $mediafile->createWebP($this->Settings, $mediafile->getPath(), true);
  490.             return new JsonResponse([
  491.                 'status' => true,
  492.                 'mediaid' => $mediafile->getId(),
  493.                 'webpath' => $mediafile->getWebpath(),
  494.             ]);
  495.         }
  496.         if (!empty($_FILES['media'])) {
  497.             $file = $_FILES['media'];
  498.             $uploadedfile = new UploadedFile($file['tmp_name'][0], $file['name'][0], $file['type'][0], (int)$file['error'][0]);
  499.             $em = $this->getDoctrine()->getManager();
  500.             $mediadir = $this->getDoctrine()->getRepository('CmsBundle:Mediadir')->findPathByName($em, (!empty($this->Settings->getHost()) ? $this->Settings->getHost() . '/' : '') .
  501.                 $this->trans('Instructor', [], 'neutral'), $this->language);
  503.             $mediafile = new Media();
  504.             $mediafile->setParent($mediadir);
  505.             $mediafile->setLabel($file['name'][0]);
  506.             $mediafile->setDateAdd();
  507.             $mediafile->setFile($uploadedfile);
  508.             $mediafile->preUpload();
  509.             $mediafile->upload();
  510.             $em->persist($mediafile);
  511.             $em->flush($mediafile);
  513.             $mediafile->webPath = $mediafile->getWebPath();
  514.             $mediafile->createWebP($this->Settings, $mediafile->getPath(), true);
  516.             return new JsonResponse([
  517.                 'status' => true,
  518.                 'mediaid' => $mediafile->getId(),
  519.                 'webpath' => $mediafile->getWebpath(),
  520.             ]);
  521.         }
  523.         return new JsonResponse([
  524.             'status' => false,
  525.             '_FILES' => (!empty($_FILES) ? $_FILES : []),
  526.             '_POST' => (!empty($_POST) ? $_POST : []),
  527.             'error' => 'No file given',
  528.         ]);
  529.     }
  530.     
  531.     /**
  532.      * @Route("/admin/realestate/{id}/delete", name="admin_realestate_remove")
  533.     */
  534.     public function deleteRealEstate(Request $request, $id = null){
  535.        parent::init($request);
  536.        $em = $this->getDoctrine()->getManager();
  537.        $realEstate = $this->getDoctrine()->getRepository('TrinityProjectssitesBundle:RealEstate')->find($id);
  538.        $em->remove($realEstate);
  539.        $em->flush();
  541.        return $this->redirectToRoute('admin_mod_projectssites');
  542.     } 
  543.     
  544.     /**
  545.      * @Route("/admin/realestateoption/{id}/delete", name="admin_realestate_option_remove")
  546.     */
  547.     public function deleteRealEstateOption(Request $request, $id = null){
  548.        parent::init($request);
  549.        $em = $this->getDoctrine()->getManager();
  550.        $realEstateOption = $this->getDoctrine()->getRepository('TrinityProjectssitesBundle:RealEstateOption')->find($id);
  551.        $em->remove($realEstateOption);
  552.        $em->flush();
  554.        return $this->redirectToRoute('admin_mod_realestateoptions');
  555.     }
  556.     
  557.     /**
  558.      * @Route("/admin/realestateoptioncontent/{optionId}/{id}/delete", name="admin_mod_realestatecontent_delete")
  559.      */
  560.     public function deleteRealEstateOptionContent(Request $request, $realEstateId, $optionId, $id = null){
  561.         parent::init($request);
  562.         $em = $this->getDoctrine()->getManager();
  563.         $realestateOptionContent = $this->getDoctrine()->getRepository('TrinityProjectssitesBundle:RealEstateOptionContent')->find($id);
  564.         $em->remove($realestateOptionContent);
  565.         $em->flush();
  566.  
  567.         return $this->redirectToRoute('admin_mod_realestate_option_edit',["id" => $optionId]);
  568.      }
  569.    
  570.     
  571.     /**
  572.      * @Route("/admin/realestateoption/deletemedia/{optionId}/{mediaid}",
  573.      *      name="admin_mod_realestateoption_media_delete",
  574.      *      requirements = {
  575.      *          "id" = "\d+",
  576.      *          "mediaid" = "\d+"
  577.      *      }
  578.      * )
  579.      */
  580.     public function deleteMediaAction(Request $request, $optionId = null, $mediaid = null){
  581.         $em = $this->getDoctrine()->getManager();
  582.         $realEstateOption = $em->getRepository('TrinityProjectssitesBundle:RealEstateOption')->find($optionId);
  584.         if(!empty($realEstateOption)){
  585.             if(!empty($realEstateOption->getHeader()) && $realEstateOption->getHeader()->getId() == $mediaid){
  586.                 $realEstateOption->setHeader(null);
  587.             }elseif(!empty($realEstateOption->getThumbnail()) && $realEstateOption->getThumbnail()->getId() == $mediaid){
  588.                 $realEstateOption->setThumbnail(null);
  589.             }else{
  590.                 $media = $em->getRepository('CmsBundle:Media')->find($mediaid);
  591.                 $ids = $realEstateOption->removeMediaId($media);
  592.                 $realEstateOption->emptyFotoGallery();
  593.                 foreach ($ids as $id) {
  594.                     $realEstateOption->addFotoGalleryItem($em->getRepository('CmsBundle:Media')->find($id));
  595.                 }
  596.                 $realEstateOption->setFotoGallery($realEstateOption->getFotoGalleryCollection());
  598.             }
  600.             $em->persist($realEstateOption);
  601.             $em->flush();
  602.         }
  603.         return $this->redirectToRoute('admin_mod_realestate_option_edit', ['id' => $optionId]);
  604.     }   
  605.    
  606.     /**
  607.       * @Route("/admin/realestatemap/deletemedia/{mapId}/{mediaId}",
  608.       *      name="admin_mod_realestate_map_media_delete",
  609.       *      requirements = {
  610.       *          "id" = "\d+",
  611.       *          "mediaid" = "\d+"
  612.       *      }
  613.       * )
  614.      */
  615.     public function deleteMediaRealEstateMapAction(Request $request, $mapId = null, $mediaId = null){
  616.          $em = $this->getDoctrine()->getManager();
  617.          $realEstateMap = $em->getRepository('TrinityProjectssitesBundle:RealEstateMap')->find($mapId);
  618.  
  619.          if(!empty($realEstateMap) && !empty($mediaId)){
  620.              if(!empty($realEstateMap->getMapImage()) && $realEstateMap->getMapImage()->getId() == $mediaId){
  621.                  $realEstateMap->setMapImage(null);
  622.                  //$media = $em->getRepository('CmsBundle:Media')->find($mediaId);
  623.                  //$realEstateMap->removeMediaId($media);
  624.              }else{
  625.                 $media = $em->getRepository('CmsBundle:Media')->find($mediaId);
  626.                 $em->remove($media);
  627.              }
  628.  
  629.              $em->persist($realEstateMap);
  630.              $em->flush();
  631.          }
  632.          return $this->redirectToRoute('admin_mod_realestate_map_edit', ["id"=> $mapId]);
  633.     } 
  634.     
  635.     /**
  636.      * @Route("/admin/realestateoptiondownload/{optionId}/{id}/delete", name="admin_mod_realestatedownload_delete")
  637.       */
  638.     public function deleteMediaRealEstateDownload(Request $request, $optionId, $id = null){
  639.         parent::init($request);
  640.         $em = $this->getDoctrine()->getManager();
  641.         $realestateOptionDownload = $this->getDoctrine()->getRepository('TrinityProjectssitesBundle:RealEstateOptionDownload')->find($id);
  642.         $em->remove($realestateOptionDownload);
  643.         $em->flush();
  644.  
  645.         return $this->redirectToRoute('admin_mod_realestate_option_edit',["id" => $optionId]);
  646.     }
  647.     
  648.     /**
  649.      * @Route("/admin/realestatecontent/deletemedia/{id}/{mediaid}",
  650.      *      name="admin_mod_realestatecontent_media_delete",
  651.      *      requirements = {
  652.      *          "id" = "\d+",
  653.      *          "mediaid" = "\d+"
  654.      *      }
  655.      * )
  656.      */
  657.     public function deleteMediaRealEstateContentAction(Request $request, $id = null, $mediaid = null){
  658.         $em = $this->getDoctrine()->getManager();
  659.         $realEstateContent = $em->getRepository('TrinityProjectssitesBundle:RealEstateOptionContent')->find($id);
  661.         if(!empty($realEstateContent)){
  662.             if(!empty($realEstateContent->getImage()) && $realEstateContent->getImage()->getId() == $mediaid){
  663.                 $realEstateContent->setImage(null);
  664.                 $media = $em->getRepository('CmsBundle:Media')->find($mediaid);
  665.                 $em->remove($media);
  666.             }
  668.             $em->persist($realEstateContent);
  669.             $em->flush();
  670.         }
  671.         return $this->redirectToRoute('admin_mod_realestate_edit', ['id' => $id]);
  672.     }  
  673.     
  674.     /**
  675.      * @Route("/admin/realestateattribute/{optionId}/{id}/delete", name="admin_mod_realestateattribute_delete")
  676.       */
  677.     public function deleteRealEstateAttribute(Request $request, $optionId, $id = null){
  678.         parent::init($request);
  679.         $em = $this->getDoctrine()->getManager();
  680.         $realestateAttribute = $this->getDoctrine()->getRepository('TrinityProjectssitesBundle:RealEstateAttribute')->find($id);
  681.         $em->remove($realestateAttribute);
  682.         $em->flush();
  683.  
  684.         return $this->redirectToRoute('admin_mod_realestate_option_edit',["id" => $optionId]);
  685.     }
  686.     
  687.     private function getPriceRange($priceFrom = null, $priceTo = null){                
  688.         $priceRange = $this->getDoctrine()->getRepository('TrinityProjectssitesBundle:RealEstateOption')
  689.             ->getPriceRange($this->language,$this->Settings);
  691.         if(!empty($priceRange)){
  692.             $prices = $priceRange[0];
  693.             $priceRange = [0,number_format($prices['max_price'],0,',','.')];
  694.         }   
  696.         if(!empty($priceFrom)){
  697.             $priceRange = [number_format(floor($priceFrom),0,',','.'), number_format(ceil($prices['max_price']),0,',','.')];
  698.         }elseif(!empty($priceTo)){
  699.             $priceRange = [0, number_format(ceil($priceTo),0,',','.')];
  700.         }
  702.         return $priceRange;
  703.     }
  705.     /**
  706.      * Show bundle content to front
  707.      *
  708.      * @param array $config Array with configuration options
  709.      * @param array $params Additional parameters
  710.      *
  711.      * @return string         HTML
  712.      */
  713.     public function showAction($config, $params = [], $request){
  714.         parent::init($request);
  716.         if(isset($config["realestatesmapswidget"]) && $config["realestatesmapswidget"] == "on"){
  717.             return $this->widgetMaps($request);
  718.         }
  719.         if(isset($config["projectssitegooglemapswidget"]) && $config["projectssitegooglemapswidget"] == "on"){
  720.             return $this->widgetOverview($request);
  721.         }
  722.         if(isset($config["projectwidget"]) && $config["projectwidget"] == "on"){
  723.             return $this->widgetDetail($request, $params);
  724.         }
  725.         if(isset($config["realestateswidget"]) && $config["realestateswidget"] == "on"){
  726.             return $this->widgetRealEstates($request, $params);
  727.         }
  728.         if(isset($config["realestateOptionswidget"]) && $config["realestateOptionswidget"] == "on"){
  729.             return $this->widgetRealEstateOptions($request, $params);
  730.         }
  731.     }
  733.     private function widgetOverview($request){
  734.         $realEstateEntity = new RealEstateEntity();
  735.         $realEstateClass = new RealEstate();
  736.         $realEstateOptionClass = new RealEstateOption();
  737.         
  738.         $config = $this->getDoctrine()->getRepository('TrinityProjectssitesBundle:Config')->findOneBy(['language' => $this->language, 'settings' => $this->Settings]);
  739.         $response = $this->realEstateFilter(null, null, null, null, null, 30, 1);
  740.         $realEstates = $response['realestates'];
  741.         $realEstateMap = null;
  742.         $realEstateOptionPrices = [];
  744.         $index = 0;
  745.         foreach ($realEstates as $realEstate) {
  746.             $realEstate = $this->getDoctrine()->getRepository('TrinityProjectssitesBundle:RealEstate')->findOneBy(['id' => $realEstate->getId()]);
  747.             $realestateOptions = $realEstate->getRealEstateOptions();
  748.             $realEstateMap = $realEstate->getRealEstateMap();
  750.             
  751.             if($config->getIsSingleProject()){
  752.                 $realEstate->category_txt = $realEstate->getCategories(true)[$realEstate->getCategory()];
  753.                 $response['realestate_hydrated'][$index]['category_txt'] = $realEstate->category_txt;
  754.                 $realEstate->status_txt = $realEstate->getStatusses(true)[$realEstate->getStatus()];
  755.                 $response['realestate_hydrated'][$index]['status_txt'] = $realEstate->status_txt;
  756.             }
  758.             if(!empty($realestateOptions)){
  759.                 $realEstate->options = $realestateOptions;
  760.                 foreach($realestateOptions as $realestateOption){
  761.                     $realestateOption = $realEstateOptionClass->setDoctrine($this->getDoctrine())->setFotos($realestateOption);
  763.                     $realEstateOptionPrice = $this->getDoctrine()->getRepository('TrinityProjectssitesBundle:RealEstateOptionPrice')->findOneBy([
  764.                         'real_estate' => $realEstate->getId(), 'real_estate_option' => $realestateOption->getId()]);
  765.                     if(!empty($realEstateOptionPrice)){
  766.                         $realEstateOptionPrices[$realEstate->getId()][$realestateOption->getId()] = $realEstateOptionPrice->getCost();
  767.                         //dump($realEstate->getId()." ".$realestateOption->getId()." ".$realEstateOptionPrice->getCost());
  768.                         //dump($realEstates);
  769.                     }
  770.                 }
  771.                 if(!empty($realestateOptions[0])){
  772.                     $response['realestate_hydrated'][$index]['slug'] = $realestateOptions[0]->getSlug();
  773.                     $realEstate->foto = $realestateOptions[0]->getThumbnail();
  774.                     if(!empty($realestateOptions[0]->getThumbnail())){
  775.                         $response['realestate_hydrated'][$index]['foto'] = $realestateOptions[0]->getThumbnail()->getWebPath();
  776.                     }
  777.                 }               
  778.                 //$images = $realestateOptions[0]->getFotoGalleryCollection();
  779.                 //if(!empty($images)){
  780.                     //$realEstate->foto = $images[0];
  781.                 //}
  782.             }
  783.             $index++;
  784.         }
  785.         //die();
  786.         
  787.         $priceRange = $this->getPriceRange();
  788.         
  789.         $latitude = 0;
  790.         $longitude = 0;
  791.         
  792.         $coords = $this->getCoords("Nederland");
  793.         $latitude = $coords['lat'];
  794.         $longitude = $coords['long'];
  795.         $bundlePath = $this->container->get('kernel')->locateResource('@TrinityProjectssitesBundle');
  796.         $projectPath = $this->get('kernel')->getProjectDir();
  797.         $marker = '/bundles/trinityprojectssites/img/marker.png';
  798.         if(file_exists($projectPath."/public/img/placeholder.jpg")){
  799.             $marker = "/img/marker.png";
  800.         }
  802.         $vars = [
  803.             'count' => $response['totalCount'],
  804.             'realestate_hydrated' => $response['realestate_hydrated'],
  805.             'realestates' => $realEstates,
  806.             'marker' => $marker,
  807.             'realEstateEntity' => $realEstateEntity,
  808.             'config' => $config,
  809.             'priceRange' => $priceRange,
  810.             'search_lat' => $latitude, 
  811.             'search_long' => $longitude,
  812.             'googleMapsZoomLvl' => $config->getGoogleMapsZoom(),
  813.             'realEstateOptionPrices' => $realEstateOptionPrices,
  814.         ];
  815.         $vars['realestatemap'] = $realEstateMap;
  817.         return $this->renderView('@TrinityProjectssites/frontend/realestate/widget_overview.html.twig', $vars);
  818.     }
  820.     private function widgetMaps($request){
  821.         $realEstateEntity = new RealEstateEntity();
  822.         $realEstateClass = new RealEstate();
  823.         $realEstateOptionClass = new RealEstateOption();
  824.         
  825.         $response = $this->realEstateFilter(null, null, null, null, null, 30, 1);
  826.         $realEstates = $response['realestates'];
  828.         $index = 0;
  829.         foreach ($realEstates as $realEstate) {
  830.             $realestateOptions = $realEstate->getRealEstateOptions();
  831.             if(!empty($realestateOptions)){
  832.                 $realEstate->options = $realestateOptions;
  833.                 foreach($realestateOptions as $realestateOption){
  834.                     $realestateOption = $realEstateOptionClass->setDoctrine($this->getDoctrine())->setFotos($realestateOption);
  835.                 }
  836.                 if(!empty($realestateOptions[0])){
  837.                     $response['realestate_hydrated'][$index]['slug'] = $realestateOptions[0]->getSlug();
  838.                     $realEstate->foto = $realestateOptions[0]->getThumbnail();
  839.                     if(!empty($realestateOptions[0]->getThumbnail())){
  840.                         $response['realestate_hydrated'][$index]['foto'] = $realestateOptions[0]->getThumbnail()->getWebPath();
  841.                     }
  842.                 }
  843.                 //$images = $realestateOptions[0]->getFotoGalleryCollection();
  844.                 //if(!empty($images)){
  845.                     //$realEstate->foto = $images[0];
  846.                 //}
  847.             }
  848.             $index++;
  849.         }
  850.         
  851.         $config = $this->getDoctrine()->getRepository('TrinityProjectssitesBundle:Config')->findOneBy(['language' => $this->language, 'settings' => $this->Settings]);
  852.         $priceRange = $this->getPriceRange();
  853.         
  854.         $latitude = 0;
  855.         $longitude = 0;
  856.         
  857.         $coords = $this->getCoords("Nederland");
  858.         $latitude = $coords['lat'];
  859.         $longitude = $coords['long'];
  860.         $bundlePath = $this->container->get('kernel')->locateResource('@TrinityProjectssitesBundle');
  861.         $projectPath = $this->get('kernel')->getProjectDir();
  862.         $marker = '/bundles/trinityprojectssites/img/marker.png';
  863.         if(file_exists($projectPath."/public/img/marker.png")){
  864.             $marker = "/img/marker.png";
  865.         }
  867.         $vars = [
  868.             'count' => $response['totalCount'],
  869.             'realestate_hydrated' => $response['realestate_hydrated'],
  870.             'realestates' => $realEstates,
  871.             'realEstateEntity' => $realEstateEntity,
  872.             'config' => $config,
  873.             'marker' => $marker,
  874.             'googleMapsZoomLvl' => $config->getGoogleMapsZoom(),
  875.             'priceRange' => $priceRange,
  876.             'search_lat' => $latitude, 
  877.             'search_long' => $longitude,
  878.         ];
  879.         //if($config->getIsSingleProject()){
  880.             $realestatemap = $this->getDoctrine()->getRepository('TrinityProjectssitesBundle:RealEstateMap')->findOneBy(['language' => $this->language, 'settings' => $this->Settings]);
  881.             $vars['realestatemap'] = $realestatemap;
  882.         //}
  884.         return $this->renderView('@TrinityProjectssites/frontend/realestate/widget_maps.html.twig', $vars);
  885.     }    
  887.     function distance($lat1, $lon1, $lat2, $lon2){
  888.         $theta = $lon1 - $lon2;
  889.         $dist = sin(deg2rad($lat1)) * sin(deg2rad($lat2)) + cos(deg2rad($lat1)) * cos(deg2rad($lat2)) * cos(deg2rad($theta));
  890.         $dist = acos($dist);
  891.         $dist = rad2deg($dist);
  892.         $miles = $dist * 60 * 1.1515;
  893.         return ($miles * 1.609344);
  894.     }
  896.     public function realEstateFilter($place, $province, $priceStart, $priceEnd, $status, $maxDistance, $page = null){
  897.         $latitude = 0;
  898.         $longitude = 0;
  900.         $errorMsg = '';
  901.         if ($place !== "" && strlen($place) > 1) {
  902.             $coords = $this->getCoords($place);
  903.             $latitude = $coords['lat'];
  904.             $longitude = $coords['long'];
  905.         }
  907.         $repo = $this->getDoctrine()->getRepository('TrinityProjectssitesBundle:RealEstate');
  908.         $realEstateArray = $repo->search($place, $province, $priceStart, $priceEnd, $status, null,$this->language,$this->Settings);
  909.         $realestates = $realEstateArray['realestates'];
  910.         $realestatemap = null;
  912.         $maxDistance = (int)$maxDistance;
  913.         $counter = 0;
  914.         foreach ($realestates as $realestate) {
  915.             $realestatemap = $realestate->getRealEstateMap();    
  916.             $realestate = $repo->findOneBy(["id" => $realestate->getId()]);
  917.             if ($maxDistance != "0" && $latitude !== 0) {
  918.                 $calculatedDistance = $this->distance($latitude, $longitude, $realestate->getLatitude(), $realestate->getLongitude());
  919.                 if($calculatedDistance > $maxDistance){
  920.                     unset($realestates[array_search($realestate, $realestates)]);
  921.                     unset($realEstateArray['realestate_hydrated'][$counter]);
  922.                 }
  923.             }
  924.             $counter++;
  925.         }
  927.         $config = $this->getDoctrine()->getRepository('TrinityProjectssitesBundle:Config')->findOneBy(['language' => $this->language, 'settings' => $this->Settings]);
  929.         $vars = [
  930.             'realestates' => $realestates,
  931.             'config' => $config,
  932.             'realestate_hydrated' => $realEstateArray['realestate_hydrated'],
  933.         ];
  935.         $konvaHtml = $this->renderView('@TrinityProjectssites/frontend/realestate/konva.html.twig', $vars);
  937.         $vars = [
  938.             'realestatemap' => $realestatemap,
  939.             'konva' => $konvaHtml,
  940.             'realestates' => $realestates,
  941.             'realestate_hydrated' => $realEstateArray['realestate_hydrated'],
  942.             'errorMsg' => $errorMsg, 
  943.             'totalCount' => count($realestates), 
  944.             'search_lat' => $latitude, 
  945.             'search_long' => $longitude
  946.         ];
  948.         return $vars;
  949.     }
  951.     /**
  952.      * @Route("/ajax/realestate/search/{page}", name="admin_mod_ajax_realestate")
  953.      */
  954.     public function searchAction(Request $request, $page = 1){
  955.         parent::init($request);
  956.         
  957.         $realEstateEntity = new RealEstateEntity();
  958.         $realEstateClass = new RealEstate();
  959.         $realEstateOptionClass = new RealEstateOption();
  960.         $place = $_POST['place'];
  961.         $province = $_POST['province'];
  962.         $priceFrom = $_POST['price_from'];
  963.         $priceTo = $_POST['price_to'];
  964.         $dist = $_POST['max_dist'];
  965.         $status = $_POST['status'];
  967.         $priceRange = $this->getPriceRange($priceFrom, $priceTo);
  969.         $response = $this->realEstateFilter($place, $province, $priceFrom, $priceTo, $status, $dist, $page);
  970.         $realestates = $response['realestates'];
  972.         $index = 0;
  973.         foreach ($realestates as $realEstate) {
  974.             $realestateOptions = $realEstate->getRealEstateOptions();
  975.             
  976.             if(!empty($realestateOptions)){
  977.                 $realEstate->options = $realestateOptions;
  978.                 foreach($realestateOptions as $realestateOption){
  979.                     $realestateOption = $realEstateOptionClass->setDoctrine($this->getDoctrine())->setFotos($realestateOption);
  980.                 }
  981.                 $realEstate->foto = $realestateOptions[0]->getThumbnail();
  982.                 $response['realestate_hydrated'][$index]['foto'] = $realestateOptions[0]->getThumbnail()->getWebPath();
  983.                 //$images = $realestateOptions[0]->getFotoGalleryCollection();
  984.                 //if(!empty($images)){
  985.                     //$realEstate->foto = $images[0];
  986.                 //}
  987.             }
  988.             $index++; 
  989.         }
  991.         $config = $this->getDoctrine()->getRepository('TrinityProjectssitesBundle:Config')->findOneBy(['language' => $this->language, 'settings' => $this->Settings]);
  994.         $html = $this->renderView('@TrinityProjectssites/frontend/realestate/realestates.html.twig', [
  995.             'realestates' => $realestates,
  996.             'config' => $config,
  997.         ]);
  998.         
  999.         $vars = [
  1000.             'konva' => $response['konva'],
  1001.             'html' => $html,
  1002.             'realestates' => $response['realestate_hydrated'],
  1003.             'error' => $response['errorMsg'],
  1004.             'count' => $response['totalCount'],
  1005.             'search_lat' => $response['search_lat'],
  1006.             'search_long' => $response['search_long'],
  1007.             'priceRange' => $priceRange,
  1008.         ];
  1010.         //if($config->getIsSingleProject()){
  1011.             $realestatemap = $this->getDoctrine()->getRepository('TrinityProjectssitesBundle:RealEstateMap')->findOneBy(['language' => $this->language, 'settings' => $this->Settings]);
  1012.             $vars['realestatemap'] = $realestatemap;
  1013.         //}
  1015.         return new JsonResponse($vars);
  1016.     }
  1018.     function getCoords($placename = null){
  1019.         $coords = [];
  1020.         $uri = 'https://maps.googleapis.com/maps/api/geocode/json?address=' . $placename . ',NL&key=AIzaSyC042fMu6ZYNvJfBtKOnhEvlPpAs5XNy18';
  1022.         $curl = curl_init();
  1024.         curl_setopt($curl, CURLOPT_URL, $uri);
  1025.         curl_setopt($curl, CURLOPT_RETURNTRANSFER, true);
  1027.         $response = curl_exec($curl);
  1028.         curl_close($curl);
  1030.         $response = json_decode($response, 1);
  1032.         if(!empty($response['results'])){
  1033.             $coords['lat'] = $response['results'][0]['geometry']['location']['lat'];
  1034.             $coords['long'] = $response['results'][0]['geometry']['location']['lng'];
  1035.         } else {
  1036.             $coords['lat'] = 0;
  1037.             $coords['long'] = 0;
  1038.         }
  1040.         return $coords;
  1041.     }
  1043.     /**
  1044.      * @Route("/kavel/{slug}", name="admin_mod_realestate_detail")
  1045.      */
  1046.     private function widgetDetail(Request $request, $slug = null){        
  1047.         $realEstateOptionEntity = new RealEstateOptionEntity();    
  1048.         $realEstateEntity = new RealEstateEntity();
  1049.         $realEstateOptionClass = new RealEstateOption();
  1050.         $realEstateOption = $this->getDoctrine()->getRepository('TrinityProjectssitesBundle:RealEstateOption')->findOneBy([
  1051.             'language'=> $this->language,
  1052.             'settings'=> $this->Settings,
  1053.             'slug' => $slug]);
  1055.         if(empty($realEstateOption)){
  1056.             return $this->widgetOverview($request);
  1057.         }
  1059.         $realEstateOption = $realEstateOptionClass->setDoctrine($this->getDoctrine())->setFotos($realEstateOption);        
  1060.         $route = $request->attributes->get('_route');
  1061.         $parentPage = $this->getDoctrine()->getRepository('CmsBundle:Page')->findOneBy(['slugkey' => $route]);
  1062.         $config = $this->getDoctrine()->getRepository('TrinityProjectssitesBundle:Config')->findOneBy(['language' => $this->language, 'settings' => $this->Settings]);
  1064.         $realEstateOptionContent = $this->getDoctrine()->getRepository('TrinityProjectssitesBundle:RealEstateOptionContent')->findBy(['real_estate_option' => $realEstateOption->getId()]);
  1065.         $realEstateOptionDownload = $this->getDoctrine()->getRepository('TrinityProjectssitesBundle:RealEstateOptionDownload')->findBy(['real_estate_option' => $realEstateOption->getId()]);
  1066.         $realEstateAttributes = $this->getDoctrine()->getRepository('TrinityProjectssitesBundle:RealEstateAttribute')->findBy(['real_estate_option' => $realEstateOption->getId()]);
  1067.         
  1068.         $vars = [
  1069.             'realEstateAttributes' => $realEstateAttributes,
  1070.             'realEstateOption' => $realEstateOption,
  1071.             'realEstateOptionEntity' => $realEstateOptionEntity,
  1072.             'realEstateEntity' => $realEstateEntity,
  1073.             'parentPage' => $parentPage,
  1074.             'config' => $config,
  1075.             'realEstateOptionContent' => $realEstateOptionContent,
  1076.             'realEstateOptionDownload' => $realEstateOptionDownload,
  1077.         ];
  1079.         //if($config->getIsSingleProject()){
  1080.         $realEstatesHydrated = $this->getDoctrine()->getRepository('TrinityProjectssitesBundle:RealEstate')->hydratedFindBy([
  1081.             'language'=> $this->language,
  1082.             'settings'=> $this->Settings]);
  1083.         $realEstates = $this->getDoctrine()->getRepository('TrinityProjectssitesBundle:RealEstate')->findBy([
  1084.             'language'=> $this->language,
  1085.             'settings'=> $this->Settings]);
  1086.         $realEstatesCarousel = [];
  1088.         foreach ($realEstates as $realEstate) {
  1089.             $realEstateOptions = $realEstate->getRealEstateOptions();
  1090.             if(!empty($realEstateOptions)){
  1091.                 $realEstate->options = $realEstateOptions;
  1092.                 $tmpOptions = [];
  1093.                 $tmpRealEstate = $realEstate;
  1094.                 foreach($realEstateOptions as $tmpRealEstateOption){
  1095.                     $tmpRealEstateOption = $realEstateOptionClass->setDoctrine($this->getDoctrine())->setFotos($tmpRealEstateOption);
  1096.                     if($tmpRealEstateOption->getId() != $realEstateOption->getId()){
  1097.                         $tmpOptions[] = $tmpRealEstateOption;
  1098.                     }
  1099.                 }
  1100.                 if(count($tmpOptions) > 0){
  1101.                     $tmpRealEstate->options = $tmpOptions;
  1102.                     $realEstatesCarousel[] = $tmpRealEstate;
  1103.                 }
  1104.                 
  1105.                 if(!empty($realEstateOptions[0])){
  1106.                     $images = $realEstateOptions[0]->getFotoGalleryCollection();
  1107.                     if(!empty($images)){
  1108.                         //$realEstate->foto = $images[0];
  1109.                         $realEstate->foto = $realEstateOptions[0]->getThumbnail();
  1110.                     }
  1111.                 }
  1112.             }
  1113.         }
  1115.         $vars['realEstatesCarousel'] = $realEstatesCarousel;
  1116.         $vars['realestate_hydrated'] = $realEstatesHydrated;
  1117.         $vars['realEstates'] = $realEstates;
  1119.         return $this->renderView('@TrinityProjectssites/frontend/realestate/detail.html.twig', $vars);
  1121.     }
  1123.     /**
  1124.      * @Route("/kavel/{slug}", name="admin_mod_realestate_detail")
  1125.      */
  1126.     private function widgetRealEstates(Request $request, $slug = null){
  1127.         $realEstateOptionClass = new RealEstateOption();  
  1128.         $realEstateOptionEntity = new RealEstateOptionEntity();
  1129.         $realEstates = $this->getDoctrine()->getRepository('TrinityProjectssitesBundle:RealEstate')->findBy([
  1130.             'language'=> $this->language,
  1131.             'settings'=> $this->Settings]);
  1132.             
  1133.         $route = $request->attributes->get('_route');
  1134.         $parentPage = $this->getDoctrine()->getRepository('CmsBundle:Page')->findOneBy(['slugkey' => $route]);
  1135.         $config = $this->getDoctrine()->getRepository('TrinityProjectssitesBundle:Config')->findOneBy(['language' => $this->language, 'settings' => $this->Settings]);
  1137.         $vars = [
  1138.             'parentPage' => $parentPage,
  1139.             'config' => $config,
  1140.             'realEstateOption' => $realEstateOptionEntity,
  1141.         ];
  1143.         //if($config->getIsSingleProject()){
  1144.             foreach ($realEstates as $realEstate) {
  1145.                 $realestateOptions = $realEstate->getRealEstateOptions();
  1146.                 if(!empty($realestateOptions)){
  1147.                     $realEstate->options = $realestateOptions;
  1148.                     foreach($realestateOptions as $realestateOption){
  1149.                         $realestateOption = $realEstateOptionClass->setDoctrine($this->getDoctrine())->setFotos($realestateOption);
  1150.                         //$realestateOptionPrice = $this->getDoctrine()->getRepository('TrinityProjectssitesBundle:RealEstateOptionPrice')->get();
  1151.                         $realEstateOptionPrice = $this->getDoctrine()->getRepository('TrinityProjectssitesBundle:RealEstateOptionPrice')->findOneBy([
  1152.                             'real_estate' => $realEstate->getId(), 'real_estate_option' => $realestateOption->getId()]);
  1153.                         if(!empty($realEstateOptionPrice)){
  1154.                             $realestateOption->price = $realEstateOptionPrice->getCost();
  1155.                         }
  1156.                     }
  1157.                     $images = $realestateOptions[0]->getFotoGalleryCollection();
  1158.                     if(!empty($images)){
  1159.                         //$realEstate->foto = $images[0];
  1160.                         $realEstate->foto = $realestateOptions[0]->getThumbnail();
  1161.                     }
  1162.                 }
  1163.             }
  1164.             $vars['realEstates'] = $realEstates;
  1165.         //}
  1167.         return $this->renderView('@TrinityProjectssites/frontend/realestate/widget_realestates.html.twig', $vars);
  1169.     }
  1170.     
  1171.     private function widgetRealEstateOptions(Request $request, $slug = null){
  1172.         $realEstateOptionClass = new RealEstateOption();  
  1173.         $realEstateOptionEntity = new RealEstateOptionEntity();
  1174.         $realEstateOptions = $this->getDoctrine()->getRepository('TrinityProjectssitesBundle:RealEstateOption')->findBy([
  1175.             'language'=> $this->language,
  1176.             'settings'=> $this->Settings]);
  1177.             
  1178.         $route = $request->attributes->get('_route');
  1179.         $parentPage = $this->getDoctrine()->getRepository('CmsBundle:Page')->findOneBy(['slugkey' => $route]);
  1180.         $config = $this->getDoctrine()->getRepository('TrinityProjectssitesBundle:Config')->findOneBy(['language' => $this->language, 'settings' => $this->Settings]);
  1182.         $vars = [
  1183.             'parentPage' => $parentPage,
  1184.             'config' => $config,
  1185.             'realEstateOptionEntity' => $realEstateOptionEntity,
  1186.         ];
  1188.         //if($config->getIsSingleProject()){
  1189.             $vars['realEstateOptions'] = $realEstateOptions;
  1190.         //}
  1192.         return $this->renderView('@TrinityProjectssites/frontend/realestate/widget_realestate_options.html.twig', $vars);
  1194.     }
  1195. }