src/Controller/LocationsController.php line 916

Open in your IDE?
  1. <?php
  2. namespace App\Controller;
  4. use Symfony\Component\HttpFoundation\Response;
  5. use Symfony\Component\Routing\Annotation\Route;
  6. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  7. use Symfony\Component\HttpFoundation\Request;
  8. use Doctrine\ORM\EntityManagerInterface;
  9. use Symfony\Contracts\Translation\TranslatorInterface;
  10. use Symfony\Component\Routing\RouterInterface;
  11. use Symfony\Component\Filesystem\Filesystem;
  12. use Symfony\Component\Finder\Finder;
  14. use App\Entity\User;
  15. use App\Entity\Countries;
  16. use App\Entity\LocationReviews;
  17. use App\Entity\LocationsGIS;
  18. use App\Entity\LocationsGISNearby;
  19. use App\Entity\LocationsFossil;
  20. use App\Entity\LocationsGeology;
  21. use App\Entity\LocationsMuseum;
  22. use App\Entity\LocationsSociety;
  23. use App\Entity\LocationPhotos;
  25. use App\Repository\LocationsFossilRepository;
  27. use App\Form\LocationGISCoordinateFormType;
  28. use App\Form\LocationGISFilterFormType;
  29. use App\Form\LocationReviewFormType;
  30. use App\Form\LocationPhotoAddFormType;
  32. class LocationsController extends AbstractController
  33. {
  34.     public function find_nearby(LocationsGIS $item, EntityManagerInterface $em) {
  35.         $locations_nearby = array();
  36.         $query = $em->createQuery('SELECT lg FROM App\Entity\LocationsGIS lg WHERE (lg.center_lat BETWEEN :latmin AND :latmax) AND (lg.center_lng BETWEEN :lngmin AND :lngmax) ORDER BY lg.type ASC');
  37.         $query->setParameter('latmin', $item->getCenterLat()-0.5);
  38.         $query->setParameter('latmax', $item->getCenterLat()+0.5);
  39.         $query->setParameter('lngmin', $item->getCenterLng()-0.5);
  40.         $query->setParameter('lngmax', $item->getCenterLng()+0.5);
  41.         foreach ($query->getResult() as $key => $location) {
  42.             if($location->getType() == $item->getType()){
  43.                 if ($location->getType() == 'fossil') {
  44.                     if ($item->getFossil()->getId() != $location->getFossil()->getId()){
  45.                         $locations_nearby[] = $location;
  46.                     }
  47.                 } elseif ($location->getType() == 'geology') {
  48.                     if ($item->getGeology()->getId() != $location->getGeology()->getId()){
  49.                         $locations_nearby[] = $location;
  50.                     }
  51.                 } elseif ($location->getType() == 'museum') {
  52.                     if ($item->getMuseum()->getId() != $location->getMuseum()->getId()){
  53.                         $locations_nearby[] = $location;
  54.                     }
  55.                 } elseif ($location->getType() == 'society') {
  56.                     if ($item->getSociety()->getId() != $location->getSociety()->getId()){
  57.                         $locations_nearby[] = $location;
  58.                     }
  59.                 }
  60.             } else {
  61.                 $locations_nearby[] = $location;
  62.             }
  63.         }
  65.         $repository = $this->getDoctrine()->getRepository(LocationsGISNearby::class);
  66.         $fossil_allready=array(); $fossil_allready_reverse=array();
  67.         $geology_allready=array(); $geology_allready_reverse=array();
  68.         $museum_allready=array(); $museum_allready_reverse=array();
  69.         $society_allready=array(); $society_allready_reverse=array();
  70.         foreach ($locations_nearby as $key => $location) {
  71.             //forward
  72.             $is_location_present = $repository->findOneBy(array('gis' => $item->getId(), 'nearby_gis' => $location->getId()));
  73.             if(!$is_location_present) {
  74.                 if($location->getType() == 'fossil') {
  75.                     $remote_gis_locations = $repository->findBy(array('gis' => $item->getId(), 'type' => 'fossil'));
  76.                     if (count($remote_gis_locations) > 0) {
  77.                         foreach ($remote_gis_locations as $key => $remote_gis_location) {
  78.                             $fossil_allready[] = $remote_gis_location->getNearbyGis()->getFossil()->getId();
  79.                         }
  80.                         foreach ($remote_gis_locations as $key => $remote_gis_location) {
  81.                             if(!in_array($location->getFossil()->getId(), $fossil_allready)){
  82.                                 $this->add_nearby($item, $location, $em);
  83.                                 $this->add_nearby($location, $item, $em);
  84.                                 $fossil_allready[] = $location->getFossil()->getId();
  85.                             } else {
  86.                                 $fossil_allready[] = $location->getFossil()->getId();
  87.                             }
  88.                         }
  89.                     } else {
  90.                         $this->add_nearby($item, $location, $em);
  91.                         $this->add_nearby($location, $item, $em);
  92.                     }
  93.                 } elseif($location->getType() == 'geology') {
  94.                     $remote_gis_locations = $repository->findBy(array('gis' => $item->getId(), 'type' => 'geology'));
  95.                     if (count($remote_gis_locations) > 0) {
  96.                         foreach ($remote_gis_locations as $key => $remote_gis_location) {
  97.                             $geology_allready[] = $remote_gis_location->getNearbyGis()->getGeology()->getId();
  98.                         }
  99.                         foreach ($remote_gis_locations as $key => $remote_gis_location) {
  100.                             if(!in_array($location->getGeology()->getId(), $geology_allready)){
  101.                                 $this->add_nearby($item, $location, $em);
  102.                                 $this->add_nearby($location, $item, $em);
  103.                                 $geology_allready[] = $location->getGeology()->getId();
  104.                             } else {
  105.                                 $geology_allready[] = $location->getGeology()->getId();
  106.                             }
  107.                         }
  108.                     } else {
  109.                         $this->add_nearby($item, $location, $em);
  110.                         $this->add_nearby($location, $item, $em);
  111.                     }
  112.                 } elseif($location->getType() == 'museum') {
  113.                     $remote_gis_locations = $repository->findBy(array('gis' => $item->getId(), 'type' => 'museum'));
  114.                     if (count($remote_gis_locations) > 0) {
  115.                         foreach ($remote_gis_locations as $key => $remote_gis_location) {
  116.                             $museum_allready[] = $remote_gis_location->getNearbyGis()->getMuseum()->getId();
  117.                         }
  118.                         foreach ($remote_gis_locations as $key => $remote_gis_location) {
  119.                             if(!in_array($location->getMuseum()->getId(), $museum_allready)){
  120.                                 $this->add_nearby($item, $location, $em);
  121.                                 $this->add_nearby($location, $item, $em);
  122.                                 $museum_allready[] = $location->getMuseum()->getId();
  123.                             } else {
  124.                                 $museum_allready[] = $location->getMuseum()->getId();
  125.                             }
  126.                         }
  127.                     } else {
  128.                         $this->add_nearby($item, $location, $em);
  129.                         $this->add_nearby($location, $item, $em);
  130.                     }
  131.                 } elseif($location->getType() == 'society') {
  132.                     $remote_gis_locations = $repository->findBy(array('gis' => $item->getId(), 'type' => 'society'));
  133.                     if (count($remote_gis_locations) > 0) {
  134.                         foreach ($remote_gis_locations as $key => $remote_gis_location) {
  135.                             $society_allready[] = $remote_gis_location->getNearbyGis()->getSociety()->getId();
  136.                         }
  137.                         foreach ($remote_gis_locations as $key => $remote_gis_location) {
  138.                             if(!in_array($location->getSociety()->getId(), $society_allready)){
  139.                                 $this->add_nearby($item, $location, $em);
  140.                                 $this->add_nearby($location, $item, $em);
  141.                                 $society_allready[] = $location->getSociety()->getId();
  142.                             } else {
  143.                                 $society_allready[] = $location->getSociety()->getId();
  144.                             }
  145.                         }
  146.                     } else {
  147.                         $this->add_nearby($item, $location, $em);
  148.                         $this->add_nearby($location, $item, $em);
  149.                     }
  150.                 }
  151.             }
  152.            
  153.         }
  154.         return new Response;
  155.     }
  157.     private function add_nearby($item, $location, $em) {
  158.         $add_location = new LocationsGISNearby();
  159.         $add_location->setGis($item);
  160.         $add_location->setNearbyGis($location);
  161.         $add_location->setType($location->getType());
  162.         $em->persist($add_location);
  163.         $em->flush();
  164.     }
  166.     public function remove_nearby(LocationsGIS $item, EntityManagerInterface $em){
  167.         $repository = $this->getDoctrine()->getRepository(LocationsGISNearby::class);
  168.         $gis_nearby = $repository->findBy(array('gis' => $item->getId()));
  169.         foreach ($gis_nearby as $key => $gis) {
  170.             $em->remove($gis);
  171.             $em->flush();
  172.         }
  173.         $gis_nearby = $repository->findBy(array('nearby_gis' => $item->getId()));
  174.         foreach ($gis_nearby as $key => $gis) {
  175.             $em->remove($gis);
  176.             $em->flush();
  177.         }
  178.     }
  180.     public function find_new_nearby($item_id, $type, EntityManagerInterface $em, TranslatorInterface $translator){    
  181.         $gis_repository = $this->getDoctrine()->getRepository(LocationsGIS::class);
  182.         $gis_locations = $gis_repository->findBy(array($type => $item_id, 'type' => $type, 'approved' => '1'));
  183.         $foundGISNearby = null;
  184.         $repository = $this->getDoctrine()->getRepository(LocationsGISNearby::class);
  185.         foreach ($gis_locations as $key => $gis_location) {
  186.             $gis_locations_used = $repository->findOneBy(array('gis' => $gis_location->getId()));
  187.             if($gis_locations_used) {
  188.                 $foundGISNearby = $gis_locations_used;
  189.             }
  190.         }
  191.         if(!$foundGISNearby) {
  192.             $gis_location = $gis_repository->findOneBy(array($type => $item_id, 'type' => $type, 'approved' => '1'));
  193.             if($gis_location) {
  194.                 $this->find_nearby($gis_location, $em);
  195.             } else {
  196.                 if ($type == 'fossil') {
  197.                     $repository = $this->getDoctrine()->getRepository(LocationsFossil::class);
  198.                 } elseif ($type == 'geology') {
  199.                     $repository = $this->getDoctrine()->getRepository(LocationsGeology::class);
  200.                 } elseif ($type == 'museum') {
  201.                     $repository = $this->getDoctrine()->getRepository(LocationsMuseum::class);
  202.                 } elseif ($type == 'society') {
  203.                     $repository = $this->getDoctrine()->getRepository(LocationsSociety::class);
  204.                 }
  206.                 $item = $repository->findOneBy(array('id' => $item_id));
  207.                 $item->setApproved('0');
  208.                 $em->persist($item);
  209.                 $em->flush();
  210.                 $this->addFlash('error', $translator->trans("Er zijn geen goedgekeurde coördinaten meer, locatie ingetrokken"));
  211.             }
  212.         }
  213.     }
  215.     private function get_location_by_id(string $type, int $id) {
  216.         if($type == 'fossil') {
  217.             $repository = $this->getDoctrine()->getRepository(LocationsFossil::class);
  218.         } elseif($type == 'geology') {
  219.             $repository = $this->getDoctrine()->getRepository(LocationsGeology::class);
  220.         } elseif($type == 'museum') {
  221.             $repository = $this->getDoctrine()->getRepository(LocationsMuseum::class);
  222.         } elseif($type == 'society') {
  223.             $repository = $this->getDoctrine()->getRepository(LocationsSociety::class);
  224.         }
  225.         $location = $repository->findOneBy(array('id'=>$id));
  226.         return $location;
  227.     }
  228.     
  229.     /**
  230.      * @Route("/locations/", name="locations_gis")
  231.      * @Route("/locations/user/{user}/{type}", name="locations_gis_user")
  232.      */
  233.     public function index(Request $request, TranslatorInterface $translator, User $user = null, String $type = null)
  234.     {
  235.         $repository = $this->getDoctrine()->getRepository(LocationsGIS::class);
  236.         $filters=array();
  237.         if($request->query->get('country') != null ) { $filterby['country'] = $request->query->get('country'); }
  238.         if($request->query->get('type') != null ) { $filterby['type'] = $request->query->get('type'); }
  240.         if ($routeName = $request->get('_route') == 'locations_gis_user') {
  241.             if($type != null) { $filterby['type'] = $type; }
  242.         }
  244.         if($this->getUser() == null){
  245.             $filterby['vulnerability'] = array('public');
  246.         } else {
  247.             $vulnerability = $this->getUser()->getCanSeeVulnerability();
  248.             if($vulnerability == 'very') { $filterby['vulnerability'] = array('public','slightly','moderate','very'); }
  249.             elseif($vulnerability == 'moderate') { $filterby['vulnerability'] = array('public','slightly','moderate'); }
  250.             elseif($vulnerability == 'slightly') { $filterby['vulnerability'] = array('public','slightly'); }
  251.             else { $filterby['vulnerability'] = array('public'); }
  252.         }
  254.         $form = $this->createForm(LocationGISFilterFormType::class, null, [
  255.             'action' => $request->getPathInfo('_route'),
  256.         ]);
  258.         $form->handleRequest($request);
  259.         if ($form->isSubmitted() && $form->isValid()){
  260.             $filters = $form->getData();
  261.             if($filters->getType() != null) {
  262.                 $filterby['type'] = $filters->getType();
  263.             }
  264.             if($filters->getCountry() != null) {
  265.                 $filterby['country'] = $filters->getCountry()->getId();
  266.             }
  267.         }
  268.         $filterby['approved'] = 1;
  270.         //$gis = $repository->findBy($filterby,array('type' => 'ASC'));
  272.         if($translator->getLocale() == 'nl') {
  273.             $oder_field = 'name_nl';
  274.         } else {
  275.             $oder_field = 'name_en';
  276.         }
  277.         
  278.         $locations_filterby=array();
  280.         if ($routeName = $request->get('_route') == 'locations_gis_user') {
  281.             if($user != null) { $locations_filterby['user_id'] = $user->getId(); }
  282.             $user_only = $user->getId();
  283.             if(empty($filters)) { $filters = array('user_filter'); }
  284.         } else {
  285.             $user_only = false;
  286.         }
  288.         $repository = $this->getDoctrine()->getRepository(Countries::class);
  289.         
  290.         if(isset($filterby['country'])) {
  291.             $locations_filterby['country'] = $filterby['country'];
  292.             $country = $repository->findOneBy(array('id' => $filterby['country']));
  293.         } else {
  294.             $country = null;
  295.         }
  296.         /*if(isset($filterby['vulnerability'])) {
  297.             $locations_filterby['vulnerability'] = $filterby['vulnerability'];
  298.             if (($key = array_search('none', $locations_filterby['vulnerability'])) === true ) {
  299.                 unset($locations_filterby['vulnerability'][$key]);
  300.                 $locations_filterby['vulnerability'][] = 'public';
  301.             }
  302.         }*/
  304.         $fossil_locations=array();
  305.         if(!isset($filterby['type']) || $filterby['type'] == 'fossil') {
  306.             $repository = $this->getDoctrine()->getRepository(LocationsFossil::class);
  307.             $fossil_locations = $repository->findBy($locations_filterby,array('location' => 'ASC'));
  308.         }
  309.         $geology_locations=array();
  310.         if(!isset($filterby['type']) || $filterby['type'] == 'geology') {
  311.             $repository = $this->getDoctrine()->getRepository(LocationsGeology::class);
  312.             $geology_locations = $repository->findBy($locations_filterby,array('location' => 'ASC'));
  313.         }
  314.         unset($locations_filterby['vulnerability']);
  315.         $museum_locations=array();
  316.         if(!isset($filterby['type']) || $filterby['type'] == 'museum') {
  317.             $repository = $this->getDoctrine()->getRepository(LocationsMuseum::class);
  318.             $museum_locations = $repository->findBy($locations_filterby,array($oder_field => 'ASC'));
  319.         }
  320.         $society_locations=array();
  321.         if(!isset($filterby['type']) || $filterby['type'] == 'society') {
  322.             $repository = $this->getDoctrine()->getRepository(LocationsSociety::class);
  323.             $society_locations = $repository->findBy($locations_filterby,array($oder_field => 'ASC'));
  324.         }
  326.         if(!isset($filterby['type'])) {
  327.             $filterby_types = array('fossil','geology','museum','society');
  328.         } else {
  329.             $filterby_types = array($filterby['type']);
  330.         }
  331.         
  332.         if(!empty($filters)) { $filter_set = 1; } else { $filter_set = 0; }
  334.         return $this->render('locations.html.twig', [
  335.             'form' => $form->createView(),
  336.             'filterby' => $filterby,
  337.             'filter_set' => $filter_set,
  338.             'types' => $filterby_types,
  339.             'country' => $country,
  340.             'fossil_locations' => $fossil_locations,
  341.             'geology_locations' => $geology_locations,
  342.             'museum_locations' => $museum_locations,
  343.             'society_locations' => $society_locations,
  344.             'all_locations' => true,
  345.             'user_only' => $user_only,
  346.         ]);
  347.     }
  349.     /**
  350.      * @Route("/locations/geojson/protected/{type}/{vulnerability}", name="locations_gis_protected_geojson")
  351.      */
  352.     public function locations_gis_protected_geojson(string $vulnerability, string $type, TranslatorInterface $translator)
  353.     {
  354.         $this->denyAccessUnlessGranted('ROLE_USER');
  355.         $uservulnerability = $this->getUser()->getCanSeeVulnerability();
  356.         $filterby = array();
  358.         if($uservulnerability == 'very') { $filterby['vulnerability'] = array('slightly','moderate','very'); }
  359.         elseif($uservulnerability == 'moderate') { $filterby['vulnerability'] = array('slightly','moderate'); }
  360.         elseif($uservulnerability == 'slightly') { $filterby['vulnerability'] = array('slightly'); }
  361.         else { $filterby['vulnerability'] = array('none'); }
  363.         $fileContent = '{"type":"FeatureCollection","features":[]}';
  365.         if(in_array($vulnerability ,$filterby['vulnerability'])) {
  366.             $finder = new Finder();
  367.             $finder->files()->name('locations.'.$vulnerability.'.'.$type.'.'.$translator->getLocale().'.geojson')->in(__DIR__.'/../../templates/generated');
  368.             foreach ($finder as $file) {
  369.                 $fileContent = $file->getContents();
  370.             }
  371.         }
  373.         $response = new Response($fileContent);
  374.         $response->headers->set('Content-Type', 'application/json');
  375.         return $response;
  376.     }
  378.     /**
  379.      * @Route("/locations/geojson/user/{user}/{type}/{vulnerability}", name="locations_gis_user_geojson")
  380.      */
  381.     public function locations_gis_user_geojson(User $user, string $type, string $vulnerability, TranslatorInterface $translator, RouterInterface $router)
  382.     {
  383.         if ($this->isGranted('IS_AUTHENTICATED')) {
  384.             $uservulnerability = $this->getUser()->getCanSeeVulnerability();
  385.         } else {
  386.             $uservulnerability=array('public');
  387.         }
  388.         $filterby = array();
  390.         if($uservulnerability == 'very') { $filterby['vulnerability'] = array('public','slightly','moderate','very'); }
  391.         elseif($uservulnerability == 'moderate') { $filterby['vulnerability'] = array('public','slightly','moderate'); }
  392.         elseif($uservulnerability == 'slightly') { $filterby['vulnerability'] = array('public','slightly'); }
  393.         else { $filterby['vulnerability'] = array('public'); }
  395.         $fileContent = '{"type":"FeatureCollection","features":[';
  397.         $gis = '';
  398.         if($type == 'fossil') {
  399.             $repository = $this->getDoctrine()->getRepository(LocationsGIS::class);
  400.             $gis = $repository->findBy(array('user_id' => $user, 'approved' => '1', 'vulnerability' => $filterby['vulnerability']));
  401.         }
  402.         if($type == 'geology') {
  403.             $repository = $this->getDoctrine()->getRepository(LocationsGIS::class);
  404.             $gis = $repository->findBy(array('user_id' => $user, 'approved' => '1', 'vulnerability' => $filterby['vulnerability']));
  405.         }
  406.         if($type == 'museum') {
  407.             $repository = $this->getDoctrine()->getRepository(LocationsGIS::class);
  408.             $gis = $repository->findBy(array('user_id' => $user, 'approved' => '1', 'vulnerability' => $filterby['vulnerability']));
  409.         }
  410.         if($type == 'society') {
  411.             $repository = $this->getDoctrine()->getRepository(LocationsGIS::class);
  412.             $gis = $repository->findBy(array('user_id' => $user, 'approved' => '1', 'vulnerability' => $filterby['vulnerability']));
  413.         }
  415.         $length = count($gis);
  416.         $counter = 0;
  417.         foreach($gis as $location){
  418.             $popupContent = '';
  419.             if($location->getType() == 'fossil') { $popupContent .= "<b>".$location->getNameEn()."</b><br><br>".$translator->trans('Fossielenlocatie')."<br>";
  420.             if($location->GetFossil()->getClosed() == '1') { $popupContent .= "<span style='color: #FF0000;'>".$translator->trans('Gesloten')."</span><br>"; }
  421.             $popupContent .= "<a href='".$router->generate('locations_fossil', array('id'=>$location->GetFossil()->getId()))."'>".$translator->trans('Locatie bekijken')."</a>"; }
  423.             if($location->getType() == 'geology') { $popupContent .= "<b>".$location->getNameEn()."</b><br><br>".$translator->trans('Geologisch excursiepunt')."<br>";
  424.             if($location->GetGeology()->getClosed() == '1') { $popupContent .= "<span style='color: #FF0000;'>".$translator->trans('Gesloten')."</span><br>"; }
  425.             $popupContent .= "<a href='".$router->generate('locations_geology', array('id'=>$location->GetGeology()->getId()))."'>".$translator->trans('Locatie bekijken')."</a>"; }
  427.             if($location->getType() == 'museum') { $popupContent .= "<b>".$location->getNameEn()."</b><br><br>".$translator->trans('Museum')."<br>";
  428.             $popupContent .= "<a href='".$router->generate('locations_museum', array('id'=>$location->GetMuseum()->getId()))."'>".$translator->trans('Locatie bekijken')."</a>"; }
  430.             if($location->getType() == 'society') { $popupContent .= "<b>".$location->getNameEn()."</b><br><br>".$translator->trans('Vereniging')."<br>";
  431.             $popupContent .= "<a href='".$router->generate('locations_society', array('id'=>$location->GetSociety()->getId()))."'>".$translator->trans('Locatie bekijken')."</a>"; }
  433.             if ($translator->getLocale() == 'nl'){
  434.                 $name = $location->getNameEn();
  435.             } else {
  436.                 $name = $location->getNameNl();
  437.             }
  438.             $fileContent .= '
  439.             {
  440.               "type": "Feature",
  441.               "id": "'.$location->getId().'",
  442.               "properties": {
  443.                 "name": "'.$name.'",
  444.                 "popupContent":"'.$popupContent.'",
  445.                 "type": "'.$location->getType().'",
  446.                 "icon": "'.$location->getType().'Icon"
  447.               },
  448.               "geometry" :
  449.               {
  450.                 "type":"'.$location->getShape().'",
  451.                 "coordinates":'.str_replace('"', "", $location->getData()).',
  452.                 "center": ['.$location->getCenterLng().','.$location->getCenterLat().']
  453.               }
  454.             }';
  455.             if($counter != ($length-1)) {$fileContent .= ',';}
  456.             $counter++;
  458.         }
  459.         $fileContent .= ']}';
  461.         $response = new Response($fileContent);
  462.         $response->headers->set('Content-Type', 'application/json');
  463.         return $response;
  464.     }
  466.     /**
  467.      * @Route("/locations/geojson/locations/{type}/{id}", name="locations_gis_geojson_locations")
  468.      */
  469.     public function locations_gis_geojson_locations(string $type, int $id, TranslatorInterface $translator, RouterInterface $router)
  470.     {
  471.         if ($this->isGranted('IS_AUTHENTICATED')) {
  472.             $uservulnerability = $this->getUser()->getCanSeeVulnerability();
  473.         } else {
  474.             $uservulnerability=array('public');
  475.         }
  476.         $filterby = array();
  478.         if($uservulnerability == 'very') { $filterby['vulnerability'] = array('public','slightly','moderate','very'); }
  479.         elseif($uservulnerability == 'moderate') { $filterby['vulnerability'] = array('public','slightly','moderate'); }
  480.         elseif($uservulnerability == 'slightly') { $filterby['vulnerability'] = array('public','slightly'); }
  481.         else { $filterby['vulnerability'] = array('public'); }
  483.         $fileContent = '{"type":"FeatureCollection","features":[';
  485.         $gis = '';
  486.         if($type == 'fossil') {
  487.             $repository = $this->getDoctrine()->getRepository(LocationsGIS::class);
  488.             $gis = $repository->findBy(array('fossil' => $id, 'approved' => '1', 'vulnerability' => $filterby['vulnerability']));
  489.         }
  490.         if($type == 'geology') {
  491.             $repository = $this->getDoctrine()->getRepository(LocationsGIS::class);
  492.             $gis = $repository->findBy(array('geology' => $id, 'approved' => '1', 'vulnerability' => $filterby['vulnerability']));
  493.         }
  494.         if($type == 'museum') {
  495.             $repository = $this->getDoctrine()->getRepository(LocationsGIS::class);
  496.             $gis = $repository->findBy(array('museum' => $id, 'approved' => '1', 'vulnerability' => $filterby['vulnerability']));
  497.         }
  498.         if($type == 'society') {
  499.             $repository = $this->getDoctrine()->getRepository(LocationsGIS::class);
  500.             $gis = $repository->findBy(array('society' => $id, 'approved' => '1', 'vulnerability' => $filterby['vulnerability']));
  501.         }
  503.         $length = count($gis);
  504.         $counter = 0;
  505.         foreach($gis as $location){
  506.             $popupContent = '';
  507.             if($location->getType() == 'fossil') { $popupContent .= "<b>".$location->getNameEn()."</b><br><br>".$translator->trans('Fossielenlocatie')."<br>";
  508.             if($location->GetFossil()->getClosed() == '1') { $popupContent .= "<span style='color: #FF0000;'>".$translator->trans('Gesloten')."</span><br>"; }
  509.             $popupContent .= "<a href='".$router->generate('locations_fossil', array('id'=>$location->GetFossil()->getId()))."'>".$translator->trans('Locatie bekijken')."</a>"; }
  511.             if($location->getType() == 'geology') { $popupContent .= "<b>".$location->getNameEn()."</b><br><br>".$translator->trans('Geologisch excursiepunt')."<br>";
  512.             if($location->GetGeology()->getClosed() == '1') { $popupContent .= "<span style='color: #FF0000;'>".$translator->trans('Gesloten')."</span><br>"; }
  513.             $popupContent .= "<a href='".$router->generate('locations_geology', array('id'=>$location->GetGeology()->getId()))."'>".$translator->trans('Locatie bekijken')."</a>"; }
  515.             if($location->getType() == 'museum') { $popupContent .= "<b>".$location->getNameEn()."</b><br><br>".$translator->trans('Museum')."<br>";
  516.             $popupContent .= "<a href='".$router->generate('locations_museum', array('id'=>$location->GetMuseum()->getId()))."'>".$translator->trans('Locatie bekijken')."</a>"; }
  518.             if($location->getType() == 'society') { $popupContent .= "<b>".$location->getNameEn()."</b><br><br>".$translator->trans('Vereniging')."<br>";
  519.             $popupContent .= "<a href='".$router->generate('locations_society', array('id'=>$location->GetSociety()->getId()))."'>".$translator->trans('Locatie bekijken')."</a>"; }
  521.             if ($translator->getLocale() == 'nl'){
  522.                 $name = $location->getNameEn();
  523.             } else {
  524.                 $name = $location->getNameNl();
  525.             }
  526.             $fileContent .= '
  527.             {
  528.               "type": "Feature",
  529.               "id": "'.$location->getId().'",
  530.               "properties": {
  531.                 "name": "'.$name.'",
  532.                 "popupContent":"'.$popupContent.'",
  533.                 "type": "'.$location->getType().'",
  534.                 "icon": "'.$location->getType().'Icon"
  535.               },
  536.               "geometry" :
  537.               {
  538.                 "type":"'.$location->getShape().'",
  539.                 "coordinates":'.str_replace('"', "", $location->getData()).',
  540.                 "center": ['.$location->getCenterLng().','.$location->getCenterLat().']
  541.               }
  542.             }';
  543.             if($counter != ($length-1)) {$fileContent .= ',';}
  544.             $counter++;
  546.         }
  547.         $fileContent .= ']}';
  549.         $response = new Response($fileContent);
  550.         $response->headers->set('Content-Type', 'application/json');
  551.         return $response;
  552.     }
  554.     /**
  555.      * @Route("/locations/geojson/moderate/location/{id}", name="locations_gis_geojson_moderate_location")
  556.      */
  557.     /*public function locations_gis_geojson_moderate_location( int $id, TranslatorInterface $translator)
  558.     {
  559.         $this->denyAccessUnlessGranted('ROLE_MOD_LOCATIONS');
  560.         
  561.         $uservulnerability = $this->getUser()->getCanSeeVulnerability();
  562.         $filterby = array();
  564.         if($uservulnerability == 'very') { $filterby['vulnerability'] = array('public','slightly','moderate','very'); }
  565.         elseif($uservulnerability == 'moderate') { $filterby['vulnerability'] = array('public','slightly','moderate'); }
  566.         elseif($uservulnerability == 'slightly') { $filterby['vulnerability'] = array('public','slightly'); }
  567.         else { $filterby['vulnerability'] = array('public'); }
  569.         $fileContent = '{"type":"FeatureCollection","features":[';
  571.         $repository = $this->getDoctrine()->getRepository(LocationsGIS::class);
  572.         $location = $repository->findOneBy(array('id' => $id));
  573.         
  574.         if ($translator->getLocale() == 'nl'){
  575.             $name = $location->getNameEn();
  576.         } else {
  577.             $name = $location->getNameNl();
  578.         }
  579.         $fileContent .= '
  580.         {
  581.             "type":"Feature",
  582.             "id":"'.$location->getId().'",
  583.             "properties": {
  584.             "name":"'.$name.'"
  585.             },
  586.             "geometry":
  587.             {
  588.             "type":"'.$location->getShape().'",
  589.             "coordinates":'.str_replace('"', "", $location->getData()).'
  590.             }
  591.         }';
  593.         $fileContent .= ']}';
  595.         $response = new Response($fileContent);
  596.         $response->headers->set('Content-Type', 'application/json');
  597.         return $response;
  598.     }*/
  600.     /**
  601.      * @Route("/moderate/gis/", name="locations_gis_moderate")
  602.      */
  603.     public function locations_gis()
  604.     {
  605.         $this->denyAccessUnlessGranted('ROLE_MOD_LOCATIONS');
  607.         $repository = $this->getDoctrine()->getRepository(LocationsGIS::class);
  608.         $gis = $repository->findBy(array('approved' => '0'));
  610.         return $this->render('locations_gis_moderate.html.twig', [
  611.             'gis' => $gis,
  612.         ]);
  613.     }
  615.     /**
  616.      * @Route("/locations/add", name="locations_user_add")
  617.      */
  618.     public function locations_user_add()
  619.     {
  620.         $this->denyAccessUnlessGranted('ROLE_USER');
  621.         if($_ENV['DISABLE_FORMS'] == "true") { return $this->render('maintenance_form_disabled.html.twig'); }
  623.         return $this->render('locations_user_add.html.twig');
  624.     }
  626.     /**
  627.      * @Route("/locations/photo/add/{type}/{id}", name="locations_photo_add")
  628.      */
  629.     public function locations_photo_add(string $type, int $id, EntityManagerInterface $em, Request $request, TranslatorInterface $translator)
  630.     {
  631.         $this->denyAccessUnlessGranted('ROLE_USER');
  633.         if($_ENV['DISABLE_FORMS'] == "true") { return $this->render('maintenance_form_disabled.html.twig'); }
  635.         $form = $this->createForm(LocationPhotoAddFormType::class);
  636.         $form->handleRequest($request);
  637.         if ($form->isSubmitted() && $form->isValid()){
  638.             $item = $form->getData();
  639.             $locationImage = $form->get('filename')->getData();
  641.             if($locationImage) {
  642.                 $get_valid_name = $this->forward('App\Controller\FileUploadController:get_valid_name', [
  643.                     'basePath' => $this->getParameter('locationphoto_directory'),
  644.                     'name' => $locationImage->getClientOriginalName(),
  645.                     ]);
  646.                 $newFilename = $get_valid_name->getContent();
  648.                 try {
  649.                     $locationImage->move(
  650.                         $this->getParameter('locationphoto_directory')."/".substr($newFilename,0,2),
  651.                         $newFilename
  652.                     );
  653.                 } catch (FileException $e) {
  654.                     //ToDo-Ante
  655.                     // ... handle exception if something happens during file upload
  656.                 }
  657.                 if($type == 'fossil') {
  658.                     $repository = $this->getDoctrine()->getRepository(LocationsFossil::class);
  659.                 } elseif($type == 'geology') {
  660.                     $repository = $this->getDoctrine()->getRepository(LocationsGeology::class);
  661.                 } elseif($type == 'museum') {
  662.                     $repository = $this->getDoctrine()->getRepository(LocationsMuseum::class);
  663.                 } elseif($type == 'society') {
  664.                     $repository = $this->getDoctrine()->getRepository(LocationsSociety::class);
  665.                 }
  666.                 $location = $repository->findOneBy(array('id' => $id));
  667.                 if($type == 'fossil') {
  668.                     $item->setFossil($location);
  669.                     $num_new_photos = $item->getFossil()->getNumNewPhotos();
  670.                     $item->getFossil()->setNumNewPhotos($num_new_photos+1);
  671.                 } elseif($type == 'geology') {
  672.                     $item->setGeology($location);
  673.                     $num_new_photos = $item->getGeology()->getNumNewPhotos();
  674.                     $item->getGeology()->setNumNewPhotos($num_new_photos+1);
  675.                 } elseif($type == 'museum') {
  676.                     $item->setMuseum($location);
  677.                     $num_new_photos = $item->getMuseum()->getNumNewPhotos();
  678.                     $item->getMuseum()->setNumNewPhotos($num_new_photos+1);
  679.                 } elseif($type == 'society') {
  680.                     $item->setSociety($location);
  681.                     $num_new_photos = $item->getSociety()->getNumNewPhotos();
  682.                     $item->getSociety()->setNumNewPhotos($num_new_photos+1);
  683.                 }
  684.                 $item->setFilename($newFilename);
  685.                 $item->setType($type);
  686.                 $item->setDate(new \DateTime());
  687.                 $item->setUserId($this->getUser()->getId());
  688.                 $item->setUsername($this->getUser()->getUsername());
  689.                 $item->setApproved('0');
  690.                 $em->persist($item);
  691.                 $em->flush();
  693.                 $this->addFlash('success', $translator->trans("Afbeelding toegevoegd en wacht op goedkeuring"));
  695.                 if($type == 'fossil') {
  696.                     return $this->redirectToRoute('locations_fossil', array('id' => $id) );
  697.                 } elseif($type == 'geology') {
  698.                     return $this->redirectToRoute('locations_geology', array('id' => $id) );
  699.                 } elseif($type == 'museum') {
  700.                     return $this->redirectToRoute('locations_museum', array('id' => $id) );
  701.                 } elseif($type == 'society') {
  702.                     return $this->redirectToRoute('locations_society', array('id' => $id) );
  703.                 }
  704.             } else {
  705.                 $this->addFlash('error', $translator->trans("Geen afbeelding geselecteerd"));
  706.             }
  707.         }
  709.         return $this->render('form_edit.html.twig', [
  710.             'form' => $form->createView(),
  711.             'title' => $translator->trans("Locatie afbeelding toevoegen"),
  712.         ]);
  713.     }
  715.     /**
  716.      * @Route("/locations/gis/add/{return_type}/{return_id}", name="locations_gis_add")
  717.      */
  718.     public function add(string $return_type, int $return_id, EntityManagerInterface $em, Request $request, TranslatorInterface $translator)
  719.     {
  720.         $this->denyAccessUnlessGranted('ROLE_USER');
  722.         if($return_type && $return_id) {
  723.             $repository = $this->getDoctrine()->getRepository(LocationsGIS::class);
  724.             $gis = $repository->findBy(array('type' => $return_type, $return_type => $return_id));
  725.             if($return_type == 'fossil') {
  726.                 $repository = $this->getDoctrine()->getRepository(LocationsFossil::class);
  727.             } elseif($return_type == 'geology') {
  728.                 $repository = $this->getDoctrine()->getRepository(LocationsGeology::class);
  729.             } elseif($return_type == 'museum') {
  730.                 $repository = $this->getDoctrine()->getRepository(LocationsMuseum::class);
  731.             } elseif($return_type == 'society') {
  732.                 $repository = $this->getDoctrine()->getRepository(LocationsSociety::class);
  733.             }
  734.             $location = $repository->findOneBy(array('id' => $return_id));
  735.             $country = $location->getCountry();
  736.         } else {
  737.             $gis = array();
  738.         }
  740.         $form = $this->createForm(LocationGISCoordinateFormType::class);
  742.         $form->handleRequest($request);
  743.         if ($form->isSubmitted() && $form->isValid()){
  744.             $item = $form->getData();
  745.             $item->setCountry($country);
  746.             $item->setUserId($this->getUser()->getId());
  747.             $item->setUsername($this->getUser()->getUsername());
  748.             $item->setApproved('0');
  749.             $item->setType($return_type);
  750.             if($return_type == 'fossil') { $item->setFossil($location); }
  751.             elseif($return_type == 'geology') { $item->setGeology($location); }
  752.             elseif($return_type == 'museum') { $item->setMuseum($location); }
  753.             elseif($return_type == 'society') { $item->setSociety($location); }
  754.             $em->persist($item);
  755.             $em->flush();
  757.             $this->addFlash('success', $translator->trans("Coördinaat toegevoegd"));
  758.            
  759.             return $this->redirectToRoute('locations_gis_item_moderate', array('type' => $return_type, 'id' => $return_id) );
  760.         }
  761.         return $this->render('locations_gis_edit.html.twig', [
  762.             'form' => $form->createView(),
  763.             'form_name' => 'location_gis_coordinate',
  764.             'gis' => $gis,
  765.         ]);
  766.     }
  768.     /**
  769.      * @Route("/moderate/gis/{type}/{id}", name="locations_gis_item_moderate")
  770.      */
  771.     public function locations_item_gis(string $type, int $id)
  772.     {
  773.         $this->denyAccessUnlessGranted('ROLE_MOD_LOCATIONS');
  775.         $repository = $this->getDoctrine()->getRepository(LocationsGIS::class);
  776.         $gis = $repository->findBy(array($type => $id));
  778.         return $this->render('locations_gis_item_moderate.html.twig', [
  779.             'gis' => $gis,
  780.             'return_type' => $type,
  781.             'return_id' => $id,
  782.             'type' => $type,
  783.             'id' => $id,
  784.             'all_locations' => false,
  785.             'types' => array($type),
  786.             'filterby' => array('vulnerability' => array('public','slightly','moderate','very')),
  787.             'country' => null
  788.         ]);
  789.     }
  791.     /**
  792.      * @Route("/moderate/gis/edit/{id}/{return_type}/{return_id}", name="locations_gis_moderate_edit") 
  793.      */
  794.     public function edit(int $id, string $return_type, int $return_id, LocationsGIS $LocationsGIS, EntityManagerInterface $em, Request $request, TranslatorInterface $translator)
  795.     {
  796.         $this->denyAccessUnlessGranted('ROLE_MOD_LOCATIONS');
  798.         $repository = $this->getDoctrine()->getRepository(LocationsGIS::class);
  799.         $gis = $repository->findBy(array('type' => $return_type, $return_type => $return_id));
  801.         $form = $this->createForm(LocationGISCoordinateFormType::class, $LocationsGIS);
  803.         $form->handleRequest($request);
  804.         if ($form->isSubmitted() && $form->isValid()){
  805.             $item = $form->getData();
  806.             $em->persist($item);
  807.             $em->flush();
  809.             $this->addFlash('success', $translator->trans("Coördinaat bijgewerkt"));
  810.             
  811.             return $this->redirectToRoute('locations_gis_item_moderate', array('type' => $return_type, 'id' => $return_id) );
  812.         }
  813.         return $this->render('locations_gis_edit.html.twig', [
  814.             'form' => $form->createView(),
  815.             'return_type' => $return_type,
  816.             'return_id' => $return_id,
  817.             'edit_id' => $id,
  818.             'gis' => $gis,
  819.             'form_name' => 'location_gis_coordinate'
  820.         ]);
  821.     }
  823.     /**
  824.      * @Route("/moderate/gis/{id}/revoke/{return_type}/{return_id}", name="locations_gis_moderate_revoke")
  825.      */
  826.     public function moderate_revoke(int $id, string $return_type, int $return_id, LocationsGIS $LocationsGIS, EntityManagerInterface $em, TranslatorInterface $translator)
  827.     {
  828.         $this->denyAccessUnlessGranted('ROLE_MOD_LOCATIONS');
  830.         $LocationsGIS->setApprovedUserId($this->getUser()->getId());
  831.         $LocationsGIS->setApprovedUsername($this->getUser()->getUsername());
  832.         $LocationsGIS->setApproved('0');
  833.         $em->persist($LocationsGIS);
  834.         $em->flush();
  836.         $this->remove_nearby($LocationsGIS, $em);
  838.         $type = $LocationsGIS->getType();
  839.         if ($LocationsGIS->getType() == 'fossil') {
  840.             $location_id = $LocationsGIS->getFossil()->getId();
  841.         } elseif ($LocationsGIS->getType() == 'geology') {
  842.             $location_id = $LocationsGIS->getGeology()->getId();
  843.         } elseif ($LocationsGIS->getType() == 'museum') {
  844.             $location_id = $LocationsGIS->getMuseum()->getId();
  845.         } elseif ($LocationsGIS->getType() == 'society') {
  846.             $location_id = $LocationsGIS->getSociety()->getId();
  847.         }
  849.         $this->find_new_nearby($location_id, $type, $em, $translator);
  851.         $this->addFlash('success', $translator->trans("Coördinaat ingetrokken"));
  852.         return $this->redirectToRoute('locations_gis_item_moderate', array('type' => $return_type, 'id' => $return_id) );
  853.     }
  855.     /**
  856.      * @Route("/moderate/gis/{id}/approve/{return_type}/{return_id}", name="locations_gis_moderate_approve")
  857.      */
  858.     public function moderate_approve(int $id, string $return_type, int $return_id, LocationsGIS $LocationsGIS, EntityManagerInterface $em, TranslatorInterface $translator)
  859.     {
  860.         $this->denyAccessUnlessGranted('ROLE_MOD_LOCATIONS');
  862.         $LocationsGIS->setApprovedUserId($this->getUser()->getId());
  863.         $LocationsGIS->setApprovedUsername($this->getUser()->getUsername());
  864.         $LocationsGIS->setApproved('1');
  865.         $em->persist($LocationsGIS);
  866.         $em->flush();
  868.         $type = $LocationsGIS->getType();
  869.         if ($LocationsGIS->getType() == 'fossil') {
  870.             $location_id = $LocationsGIS->getFossil()->getId();
  871.         } elseif ($LocationsGIS->getType() == 'geology') {
  872.             $location_id = $LocationsGIS->getGeology()->getId();
  873.         } elseif ($LocationsGIS->getType() == 'museum') {
  874.             $location_id = $LocationsGIS->getMuseum()->getId();
  875.         } elseif ($LocationsGIS->getType() == 'society') {
  876.             $location_id = $LocationsGIS->getSociety()->getId();
  877.         }
  878.         $this->find_new_nearby($location_id, $type, $em, $translator);
  880.         $this->addFlash('success', $translator->trans("Coördinaat goedgekeurd"));
  881.         return $this->redirectToRoute('locations_gis_item_moderate', array('type' => $return_type, 'id' => $return_id) );
  882.     }
  884.     /**
  885.      * @Route("/moderate/gis/{id}/delete/{return_type}/{return_id}", name="locations_gis_moderate_delete")
  886.      */
  887.     public function moderate_delete(int $id, string $return_type, int $return_id, LocationsGIS $LocationsGIS, EntityManagerInterface $em, TranslatorInterface $translator)
  888.     {
  889.         $this->denyAccessUnlessGranted('ROLE_MOD_LOCATIONS');
  891.         $this->remove_nearby($LocationsGIS, $em);
  893.         $type = $LocationsGIS->getType();
  894.         if ($LocationsGIS->getType() == 'fossil') {
  895.             $location_id = $LocationsGIS->getFossil()->getId();
  896.         } elseif ($LocationsGIS->getType() == 'geology') {
  897.             $location_id = $LocationsGIS->getGeology()->getId();
  898.         } elseif ($LocationsGIS->getType() == 'museum') {
  899.             $location_id = $LocationsGIS->getMuseum()->getId();
  900.         } elseif ($LocationsGIS->getType() == 'society') {
  901.             $location_id = $LocationsGIS->getSociety()->getId();
  902.         }
  904.         $em->remove($LocationsGIS);
  905.         $em->flush();
  907.         $this->find_new_nearby($location_id, $type, $em, $translator);
  909.         $this->addFlash('success', $translator->trans("Coördinaat verwijderd"));
  910.         return $this->redirectToRoute('locations_gis_item_moderate', array('type' => $return_type, 'id' => $return_id) );
  911.     }
  913.     /**
  914.      * @Route("/locations/{type}/{id}/review", name="locations_review_add")
  915.      */
  916.     public function review_add(string $type, int $id, Request $request, EntityManagerInterface $em, TranslatorInterface $translator)
  917.     {
  918.         $this->denyAccessUnlessGranted('ROLE_USER');
  920.         $form = $this->createForm(LocationReviewFormType::class);
  922.         $form->handleRequest($request);
  923.         if ($form->isSubmitted() && $form->isValid()){
  924.             $location = $this->get_location_by_id($type, $id);
  926.             $review = $form->getData();
  927.             $review->setUserId($this->getUser()->getId());
  928.             $review->setUsername($this->getUser()->getUsername());
  929.             $review->setType($type);
  930.             if($type == 'fossil') {
  931.                 $review->setFossil($location);
  932.                 $num_reviews = $review->getFossil()->getNumReviews();
  933.                 $review->getFossil()->setNumReviews($num_reviews+1);
  934.             } elseif($type == 'geology') {
  935.                 $review->setGeology($location);
  936.                 $num_reviews = $review->getGeology()->getNumReviews();
  937.                 $review->getGeology()->setNumReviews($num_reviews+1);
  938.             } elseif($type == 'museum') {
  939.                 $review->setMuseum($location);
  940.                 $num_reviews = $review->getMuseum()->getNumReviews();
  941.                 $review->getMuseum()->setNumReviews($num_reviews+1);
  942.             } elseif($type == 'society') {
  943.                 $review->setSociety($location);
  944.                 $num_reviews = $review->getSociety()->getNumReviews();
  945.                 $review->getSociety()->setNumReviews($num_reviews+1);
  946.             }
  947.             $em->persist($review);
  948.             $em->flush();
  949.             $this->addFlash('success', $translator->trans("Feedback doorgegeven"));
  951.             if($type = 'museum') {
  952.                 return $this->redirectToRoute('locations_museum', array('id' => $id ) );
  953.             }
  954.             
  955.         }
  957.         return $this->render('form_edit.html.twig', [
  958.             'title' => $translator->trans("Feedback doorgeven"),
  959.             'button_text' => $translator->trans("Insturen"),
  960.             'form' => $form->createView()
  961.         ]);
  962.     }
  964.     /**
  965.      * @Route("/moderate/locations/{type}/{id}/reviews", name="locations_moderate_reviews")
  966.      */
  967.     public function moderate_review(string $type, int $id, EntityManagerInterface $em, TranslatorInterface $translator)
  968.     {
  969.         $this->denyAccessUnlessGranted('ROLE_MOD_LOCATIONS');
  971.         return $this->render('locationreviews_moderate.html.twig', [
  972.             'location' => $this->get_location_by_id($type, $id),
  973.             'type' => $type,
  974.         ]);
  975.     }
  977.     /**
  978.      * @Route("/moderate/locations/review/{id}/read/{type}/{location_id}", name="locationsreviews_moderate_read")
  979.      */
  980.     public function review_read(int $location_id, string $type, LocationReviews $locationreview, EntityManagerInterface $em, TranslatorInterface $translator)
  981.     {
  982.         $this->denyAccessUnlessGranted('ROLE_MOD_LOCATIONS');
  984.         return $this->render('locationreview.html.twig', [
  985.             'review' => $locationreview,
  986.             'type' => $type,
  987.             'location_id' => $location_id,
  988.         ]);
  989.     }
  991.     /**
  992.      * @Route("/moderate/locations/review/{id}/delete/{type}/{location_id}", name="locationsreviews_moderate_delete")
  993.      */
  994.     public function review_delete(int $location_id, string $type, LocationReviews $locationreview, EntityManagerInterface $em, TranslatorInterface $translator)
  995.     {
  996.         $this->denyAccessUnlessGranted('ROLE_MOD_LOCATIONS');
  998.         if($type == 'fossil') {
  999.             $num_reviews = $locationreview->getFossil()->getNumReviews();
  1000.             $locationreview->getFossil()->setNumReviews($num_reviews-1);
  1001.         } elseif($type == 'geology') {
  1002.             $num_reviews = $locationreview->getGeology()->getNumReviews();
  1003.             $locationreview->getGeology()->setNumReviews($num_reviews-1);
  1004.         } elseif($type == 'museum') {
  1005.             $num_reviews = $locationreview->getMuseum()->getNumReviews();
  1006.             $locationreview->getMuseum()->setNumReviews($num_reviews-1);
  1007.         } elseif($type == 'society') {
  1008.             $num_reviews = $locationreview->getSociety()->getNumReviews();
  1009.             $locationreview->getSociety()->setNumReviews($num_reviews-1);
  1010.         }
  1011.         $em->persist($locationreview);
  1012.         $em->flush();
  1014.         $em->remove($locationreview);
  1015.         $em->flush();
  1017.         $this->addFlash('success', $translator->trans("Locatie review verwijderd"));
  1018.         return $this->redirectToRoute('locations_moderate_reviews', array('type' => $type,'id' => $location_id, ));
  1019.     }
  1021.     /**
  1022.      * @Route("/moderate/locations/{type}/{id}/photos", name="locations_moderate_photos")
  1023.      */
  1024.     public function moderate_photos(string $type, int $id, EntityManagerInterface $em, TranslatorInterface $translator)
  1025.     {
  1026.         $this->denyAccessUnlessGranted('ROLE_MOD_LOCATIONS');
  1028.         return $this->render('locationphotos_moderate.html.twig', [
  1029.             'location' => $this->get_location_by_id($type, $id),
  1030.             'type' => $type,
  1031.             'location_id' => $id,
  1032.         ]);
  1033.     }
  1035.     /**
  1036.      * @Route("/moderate/locations/photos/{id}/approve/{return_type}/{return_id}", name="locations_photos_moderate_approve")
  1037.      */
  1038.     public function moderate_photos_approve(string $return_type, int $return_id, LocationPhotos $locationphoto, EntityManagerInterface $em, TranslatorInterface $translator)
  1039.     {
  1040.         $this->denyAccessUnlessGranted('ROLE_MOD_LOCATIONS');
  1042.         $locationphoto->setApprovedUserId($this->getUser()->getId());
  1043.         $locationphoto->setApprovedUsername($this->getUser()->getUsername());
  1044.         $locationphoto->setApproved('1');
  1045.         $em->persist($locationphoto);
  1046.         $em->flush();
  1048.         $type = $locationphoto->getType();
  1049.         if ($locationphoto->getType() == 'fossil') {
  1050.             $location_id = $locationphoto->getFossil()->getId();
  1051.         } elseif ($locationphoto->getType() == 'geology') {
  1052.             $location_id = $locationphoto->getGeology()->getId();
  1053.         } elseif ($locationphoto->getType() == 'museum') {
  1054.             $location_id = $locationphoto->getMuseum()->getId();
  1055.         } elseif ($locationphoto->getType() == 'society') {
  1056.             $location_id = $locationphoto->getSociety()->getId();
  1057.         }
  1059.         $this->addFlash('success', $translator->trans("Locatie foto goedgekeurd"));
  1060.         return $this->redirectToRoute('locations_moderate_photos', array('type' => $return_type, 'id' => $return_id) );
  1061.     }
  1063.     /**
  1064.      * @Route("/moderate/locations/photos/{id}/delete/{return_type}/{return_id}", name="locations_photos_moderate_delete")
  1065.      */
  1066.     public function moderate_photo_delete(string $return_type, string $return_id, LocationPhotos $locationphoto, EntityManagerInterface $em, TranslatorInterface $translator)
  1067.     {
  1068.         //, UploaderHelper $uploaderHelper
  1069.         $this->denyAccessUnlessGranted('ROLE_MOD_LOCATIONS');
  1071.         $type = $locationphoto->getType();
  1073.         if($photo->getApproved() == 0){
  1074.             if ($locationphoto->getType() == 'fossil') {
  1075.                 $locationphoto->getFossil()->setNumNewPhotos($locationphoto->getFossil()->getNumNewPhotos()-1);
  1076.             } elseif ($locationphoto->getType() == 'geology') {
  1077.                 $locationphoto->getGeology()->setNumNewPhotos($locationphoto->getGeology()->getNumNewPhotos()-1);
  1078.             } elseif ($locationphoto->getType() == 'museum') {
  1079.                 $locationphoto->getMuseum()->setNumNewPhotos($locationphoto->getMuseum()->getNumNewPhotos()-1);
  1080.             } elseif ($locationphoto->getType() == 'society') {
  1081.                 $locationphoto->getSociety()->setNumNewPhotos($locationphoto->getSociety()->getNumNewPhotos()-1);
  1082.             }
  1083.             $em->persist($item);
  1084.         }
  1085.       
  1086.         $filename = $this->getParameter('locationphoto_directory')."/".substr($locationphoto->getFilename(),0,2)."/".$locationphoto->getFilename();
  1087.         $filename_thumbnail = $this->getParameter('locationphotothumbnail_directory')."/".substr($locationphoto->getFilename(),0,2)."/".$locationphoto->getFilename();
  1088.         $filesystem = new Filesystem();
  1089.         $filesystem->remove($filename);
  1090.         $filesystem->remove($filename_thumbnail);
  1092.         $em->remove($locationphoto);
  1093.         $em->flush();
  1094.         
  1095.         $this->addFlash('success', $translator->trans("Locatie foto verwijderd"));
  1096.         return $this->redirectToRoute('locations_moderate_photos', array('type' => $return_type,'id' => $return_id, ));
  1097.     }
  1098. }