src/Controller/LocationsFossilController.php line 164

Open in your IDE?
  1. <?php
  2. namespace App\Controller;
  4. use Symfony\Component\Routing\Annotation\Route;
  5. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  6. use Symfony\Component\HttpFoundation\Session\SessionInterface;
  7. use Sensio\Bundle\FrameworkExtraBundle\Configuration\Method;
  8. use Doctrine\ORM\EntityManagerInterface;
  9. use Symfony\Component\HttpFoundation\Request;
  10. use JMS\Serializer\SerializerBuilder;
  11. use Symfony\Component\HttpFoundation\Response;
  12. use Symfony\Component\Routing\RouterInterface;
  14. use App\Entity\LocationsFossil;
  15. use App\Entity\Countries;
  16. use App\Entity\Newsfeed;
  17. use App\Entity\User;
  18. use App\Entity\UserProfile;
  19. use App\Entity\LocationsGIS;
  20. use App\Entity\LocationsGISNearby;
  21. use App\Entity\Spool;
  22. use App\Entity\SearchItems;
  24. use App\Repository\LocationsFossilRepository;
  26. use App\Form\LocationsFossilFormType;
  27. use App\Form\LocationsUserFossilFormType;
  28. use App\Form\LocationFilterSearchFormType;
  30. use Symfony\Contracts\Translation\TranslatorInterface;
  32. class LocationsFossilController extends AbstractController 
  33. {
  34.     private $session;
  35.     private $em;
  36.     private $translator;
  37.     private $router;
  39.     public function __construct(EntityManagerInterface $em, TranslatorInterface $translator, RouterInterface $router, SessionInterface $session)
  40.     {
  41.         $this->em = $em;
  42.         $this->translator = $translator;
  43.         $this->router = $router;
  44.         $this->session = $session;
  45.     }
  47.     private function get_locations_fossil_new(TranslatorInterface $translator) {
  48.         $repository = $this->getDoctrine()->getRepository(LocationsFossil::class);
  49.         $new = $repository->findBy(array('approved' => 0),array('num_new_photos' => 'DESC', 'num_reviews' => 'DESC', 'location' => 'ASC'));
  50.         return $new;
  51.     }
  53.     private function get_locations_fossil_approved(TranslatorInterface $translator) {
  54.         $repository = $this->getDoctrine()->getRepository(LocationsFossil::class);
  55.         $approved = $repository->findBy(array('approved' => 1),array('num_new_photos' => 'DESC', 'num_reviews' => 'DESC', 'location' => 'ASC'));
  56.         return $approved;
  57.     }
  59.     private function get_locations_fossil_filtered($filter) {
  60.         $qb = $this->em->createQueryBuilder('l')
  61.             ->from('App\Entity\LocationsFossil', 'l')
  62.             ->addSelect('l')
  63.             ->orderBy('l.id','DESC')
  64.             ->AddOrderBy('l.approved','DESC')
  65.             ->AddOrderBy('l.num_new_photos','DESC')
  66.             ->AddOrderBy('l.num_reviews','ASC')
  67.         ;
  69.         if($filter['property'] == 'new') {
  70.             $qb->andWhere("l.approved = 0");
  71.         }
  72.         elseif($filter['property'] == 'reviews') {
  73.             $qb->andWhere("l.num_reviews > 0");
  74.         }
  75.         elseif($filter['property'] == 'photos') {
  76.             $qb->andWhere("l.num_new_photos > 0");
  77.         }
  79.         $result = $qb->getQuery()->getResult();
  80.         return $result;
  81.     }
  83.     private function get_locations_fossil_by_id(int $id) {
  84.         $repository = $this->getDoctrine()->getRepository(LocationsFossil::class);
  85.         $item = $repository->findOneBy(array('id'=>$id));
  86.         return $item;
  87.     }
  89.     /**
  90.      * @Route("/locations/fossil/{id}" , name="locations_fossil")
  91.      */
  92.     public function index(LocationsFossil $fossil, TranslatorInterface $translator, EntityManagerInterface $em)
  93.     {
  94.         if($this->getUser() == null){
  95.             $filterby['vulnerability'] = array('public');
  96.         } else {
  97.             $vulnerability = $this->getUser()->getCanSeeVulnerability();
  98.             if($vulnerability == 'very') { $filterby['vulnerability'] = array('public','slightly','moderate','very'); }
  99.             elseif($vulnerability == 'moderate') { $filterby['vulnerability'] = array('public','slightly','moderate'); }
  100.             elseif($vulnerability == 'slightly') { $filterby['vulnerability'] = array('public','slightly'); }
  101.             else { $filterby['vulnerability'] = array('public'); }
  102.         }
  103.         $filterby['approved'] = 1;
  104.         $filterby['fossil'] = $fossil;
  106.         $repository = $this->getDoctrine()->getRepository(LocationsGIS::class);
  107.         $gis = $repository->findBy($filterby);
  109.         if($fossil->getApproved() == 0 || empty($gis) ) {
  110.             return $this->render('error_message.html.twig', [
  111.                 'error_title' => $translator->trans("Fout"),
  112.                 'error_message' => $translator->trans("Deze locatie bestaat niet of je hebt geen rechten deze in te zien."),
  113.             ]);
  114.         }
  116.         #ToDo-Ante: alleen voor deze locatie, niet voor allen
  117.         $qb = $em->createQueryBuilder('f')
  118.             ->from('App\Entity\FossildbFossil', 'f')
  119.             ->select('count(f.id)')
  120.             ->andWhere('f.location_fossil = (:fossil_id)')
  121.             ->andWhere('f.approved = 1')
  122.             ->setParameter('fossil_id', $fossil->getId());
  123.         $fossils_found = $qb->getQuery()->getSingleScalarResult();
  125.         /*$query = $em->createQuery('SELECT lg FROM App\Entity\LocationsGIS lg WHERE lg.center_lat BETWEEN :find_latmin AND :find_latmax AND lg.center_lng BETWEEN :find_lngmin AND :find_lngmax ORDER BY lg.type'); //AND lg.fossil != :fossil_id
  126.         $query->setParameter('find_latmin', $gis[0]->getCenterLat()-0.5);
  127.         $query->setParameter('find_latmax', $gis[0]->getCenterLat()+0.5);
  128.         $query->setParameter('find_lngmin', $gis[0]->getCenterLng()-0.5);
  129.         $query->setParameter('find_lngmax', $gis[0]->getCenterLng()+0.5);
  130.         //$query->setParameter('fossil_id', $fossil->getId());
  131.         $gis_locations_nearby = $query->getResult();
  132.         dd($gis_locations_nearby);*/
  133.         
  134.         $locations_nearby=array();
  135.         $repository = $this->getDoctrine()->getRepository(LocationsGISNearby::class);
  136.         $gis_nearby = $repository->findBy(array('gis' => $gis[0]->getId()),array('type' => 'ASC'));
  137.         if(count($gis_nearby) == 0) {
  138.             $locations = $fossil->getLocationsGIS()->toArray();
  139.             $this->forward('App\Controller\LocationsController:find_nearby', [
  140.                 'item' => $locations[0],
  141.                 'em' => $em,
  142.                 ]);
  143.             $gis_nearby = $repository->findBy(array('gis' => $gis[0]->getId()),array('type' => 'ASC'));
  144.         }
  146.         foreach ($gis_nearby as $key => $location) {
  147.             $repository = $this->getDoctrine()->getRepository(LocationsGIS::class);
  148.             $filternearby['vulnerability']=$filterby['vulnerability'];
  149.             $filternearby['approved']=$filterby['approved'];
  150.             $filternearby['id']=$location->getNearbyGIS()->getId();
  151.             $locations_nearby[] = $repository->findOneBy($filternearby);
  152.         }
  154.         return $this->render('locations_fossil.html.twig', [
  155.             'fossil' => $fossil,
  156.             //'gis' => $gis,
  157.             'locations_nearby' => $locations_nearby,
  158.             'type' => 'fossil',
  159.             'id' => $fossil->getId(),
  160.             'all_locations' => false,
  161.             'filterby' => $filterby,
  162.             'types' => array('fossil'),
  163.             'country' => null,
  164.             'fossils_found' => $fossils_found,
  165.         ]);
  166.     }
  168.     /**
  169.      * @Route("/moderate/fossils", name="locations_fossil_moderate")
  170.      */
  171.     public function moderate(Request $request, TranslatorInterface $translator)
  172.     {
  173.         $this->denyAccessUnlessGranted('ROLE_MOD_LOCATIONS');
  175.         $form = $this->createForm(LocationFilterSearchFormType::class);
  176.         $form->handleRequest($request);
  177.         if ($form->isSubmitted() && $form->isValid()){
  178.             $filter = $form->getData();
  179.         } else {
  180.             $filter=array('property' => array());
  181.         }
  182.         $locations = $this->get_locations_fossil_filtered($filter);
  184.         return $this->render('locations_fossil_moderate.html.twig', [
  185.             'items' => $locations,
  186.             'form' => $form->createView()
  187.         ]);
  188.     }
  190.     /**
  191.      * @Route("/fossil/add", name="locations_fossil_user_add")
  192.      */
  193.     public function user_add(EntityManagerInterface $em, Request $request, TranslatorInterface $translator)
  194.     {
  195.         $this->denyAccessUnlessGranted('ROLE_USER');
  196.         if($_ENV['DISABLE_FORMS'] == "true") { return $this->render('maintenance_form_disabled.html.twig'); }
  198.         $repository = $this->getDoctrine()->getRepository(Countries::class);
  199.         $countries = $repository->findAll();
  201.         $form = $this->createForm(LocationsUserFossilFormType::class);
  202.         
  203.         $form->handleRequest($request);
  204.         if ($form->isSubmitted() && $form->isValid()){
  205.             $form_data = $form->getData();
  207.             $fossil = new LocationsFossil();
  208.             $fossil->setNameNl($form_data["name_nl"]);
  209.             $fossil->setNameEn($form_data["name_en"]);
  210.             $fossil->setDescriptionEn($form_data["description_en"]);
  211.             $fossil->getLocation($form_data["location"]);
  212.             $fossil->setDescriptionNl($form_data["description_nl"]);
  213.             $fossil->setDescriptionEn($form_data["description_en"]);
  214.             $fossil->setLocation($form_data["location"]);
  215.             $fossil->setCountry($form_data["country"]);
  216.             $fossil->setClosed($form_data["closed"]);
  218.             $fossil->setIsQuaternary($form_data["is_quaternary"]);
  219.             $fossil->setIsNeogene($form_data["is_neogene"]);
  220.             $fossil->setIsPaleogene($form_data["is_paleogene"]);
  221.             $fossil->setIsCretaceous($form_data["is_cretaceous"]);
  222.             $fossil->setIsJurassic($form_data["is_jurassic"]);
  223.             $fossil->setIsTriassic($form_data["is_triassic"]);
  224.             $fossil->setIsPermian($form_data["is_permian"]);
  225.             $fossil->setIsCarboniferous($form_data["is_carboniferous"]);
  226.             $fossil->setIsDevonian($form_data["is_devonian"]);
  227.             $fossil->setIsSilurian($form_data["is_silurian"]);
  228.             $fossil->setIsOrdovician($form_data["is_ordovician"]);
  229.             $fossil->setIsCambrian($form_data["is_cambrian"]);
  230.             $fossil->setIsPrecambrian($form_data["is_precambrian"]);
  232.             $fossil->setHasDinosauria($form_data["has_dinosauria"]);
  233.             $fossil->setHasChlorophyta($form_data["has_chlorophyta"]);
  234.             $fossil->setHasBelemnoidea($form_data["has_belemnoidea"]);
  235.             $fossil->setHasBivalvia($form_data["has_bivalvia"]);
  236.             $fossil->setHasBrachiopoda($form_data["has_brachiopoda"]);
  237.             $fossil->setHasBryozoa($form_data["has_bryozoa"]);
  238.             $fossil->setHasAmmonitida($form_data["has_ammonitida"]);
  239.             $fossil->setHasNautiloidea($form_data["has_nautiloidea"]);
  240.             $fossil->setHasCrinoidea($form_data["has_crinoidea"]);
  241.             $fossil->setHasForaminifera($form_data["has_foraminifera"]);
  242.             $fossil->setHasGastropoda($form_data["has_gastropoda"]);
  243.             $fossil->setHasHemichordata($form_data["has_hemichordata"]);
  244.             $fossil->setHasHexapoda($form_data["has_hexapoda"]);
  245.             $fossil->setHasAnthozoa($form_data["has_anthozoa"]);
  246.             $fossil->setHasCrustacea($form_data["has_crustacea"]);
  247.             $fossil->setHasMammaliaterrestrium($form_data["has_mammaliaterrestrium"]);
  248.             $fossil->setHasOstracoda($form_data["has_ostracoda"]);
  249.             $fossil->setHasAngiospermae($form_data["has_angiospermae"]);
  250.             $fossil->setHasConiferophyta($form_data["has_coniferophyta"]);
  251.             $fossil->setHasCycadophyta($form_data["has_cycadophyta"]);
  252.             $fossil->setHasLycophyta($form_data["has_lycophyta"]);
  253.             $fossil->setHasPteridophyta($form_data["has_pteridophyta"]);
  254.             $fossil->setHasPteridospermophyta($form_data["has_pteridospermophyta"]);
  255.             $fossil->setHasSphenophyta($form_data["has_sphenophyta"]);
  256.             $fossil->setHasRudista($form_data["has_rudista"]);
  257.             $fossil->setHasPolychaeta($form_data["has_polychaeta"]);
  258.             $fossil->setHasPorifera($form_data["has_porifera"]);
  259.             $fossil->setHasIchnofossilia($form_data["has_ichnofossilia"]);
  260.             $fossil->setHasTrilobita($form_data["has_trilobita"]);
  261.             $fossil->setHasElasmobranchii($form_data["has_elasmobranchii"]);
  262.             $fossil->setHasBatoidea($form_data["has_batoidea"]);
  263.             $fossil->setHasAves($form_data["has_aves"]);
  264.             $fossil->setHasEchinoidea($form_data["has_echinoidea"]);
  265.             $fossil->setHasMammaliamarinis($form_data["has_mammaliamarinis"]);
  266.             $fossil->setHasBacteria($form_data["has_bacteria"]);
  267.             $fossil->setHasArchaebacteria($form_data["has_archaebacteria"]);
  268.             $fossil->setHasPhaeophyceae($form_data["has_phaeophyceae"]);
  269.             $fossil->setHasDiatomophyceae($form_data["has_diatomophyceae"]);
  270.             $fossil->setHasRadiolaria($form_data["has_radiolaria"]);
  271.             $fossil->setHasChoanoflagellata($form_data["has_choanoflagellata"]);
  272.             $fossil->setHasMedusozoa($form_data["has_medusozoa"]);
  273.             $fossil->setHasAsterozoa($form_data["has_asterozoa"]);
  274.             $fossil->setHasBlastoidea($form_data["has_blastoidea"]);
  275.             $fossil->setHasCystoidea($form_data["has_cystoidea"]);
  276.             $fossil->setHasAgnatha($form_data["has_agnatha"]);
  277.             $fossil->setHasPlacodermi($form_data["has_placodermi"]);
  278.             $fossil->setHasChimaeriformes($form_data["has_chimaeriformes"]);
  279.             $fossil->setHasActinopterygii($form_data["has_actinopterygii"]);
  280.             $fossil->setHasSarcopterygii($form_data["has_sarcopterygii"]);
  281.             $fossil->setHasDipnoi($form_data["has_dipnoi"]);
  282.             $fossil->setHasAmphibia($form_data["has_amphibia"]);
  283.             $fossil->setHasAnapsida($form_data["has_anapsida"]);
  284.             $fossil->setHasSquamata($form_data["has_squamata"]);
  285.             $fossil->setHasSauropterygia($form_data["has_sauropterygia"]);
  286.             $fossil->setHasIchthyosauria($form_data["has_ichthyosauria"]);
  287.             $fossil->setHasCrocodylomorpha($form_data["has_crocodylomorpha"]);
  288.             $fossil->setHasPterosauria($form_data["has_pterosauria"]);
  289.             $fossil->setHasPlatyzoa($form_data["has_platyzoa"]);
  290.             $fossil->setHasAnnelida($form_data["has_annelida"]);
  291.             $fossil->setHasPolyplacophora($form_data["has_polyplacophora"]);
  292.             $fossil->setHasScaphopoda($form_data["has_scaphopoda"]);
  293.             $fossil->setHasNautilida($form_data["has_nautilida"]);
  294.             $fossil->setHasGoniatitida($form_data["has_goniatitida"]);
  295.             $fossil->setHasCeratitida($form_data["has_ceratitida"]);
  296.             $fossil->setHasNeocoleoidea($form_data["has_neocoleoidea"]);
  297.             $fossil->setHasArachnida($form_data["has_arachnida"]);
  298.             $fossil->setHasMerostomata($form_data["has_merostomata"]);
  299.             $fossil->setHasMyriapoda($form_data["has_myriapoda"]);
  300.             $fossil->setHasFungi($form_data["has_fungi"]);
  301.             $fossil->setHasMycetozoa($form_data["has_mycetozoa"]);
  302.             $fossil->setHasGinkgophyta($form_data["has_ginkgophyta"]);
  303.             $fossil->setHasBryophyta($form_data["has_bryophyta"]);
  304.             $fossil->setHasIncertaesedis($form_data["has_incertaesedis"]);
  306.             $fossil->setVulnerability($form_data["vulnerability"]);
  307.             $fossil->setUserId($this->getUser()->getId());
  308.             $fossil->setUsername($this->getUser()->getUsername());
  309.             $fossil->setDateAdded(new \DateTime());
  310.             $fossil->setApproved(0);
  311.             $fossil->setNumReviews(0);
  312.             $fossil->setNumNewPhotos(0);
  313.             $em->persist($fossil);
  314.             $em->flush();
  316.             $gis = new LocationsGIS();
  317.             $gis->setNameNl($fossil->getLocation());
  318.             $gis->setNameEn($fossil->getLocation());
  319.             $gis->setShape($form_data["shape"]);
  320.             $gis->setData($form_data["data"]);
  321.             $gis->setRadius($form_data["radius"]);
  322.             $gis->setCenterLat($form_data["center_lat"]);
  323.             $gis->setCenterLng($form_data["center_lng"]);
  324.             $gis->setVulnerability($form_data["vulnerability"]);
  325.             $gis->setCountry($fossil->getCountry());
  326.             $gis->setUserId($this->getUser()->getId());
  327.             $gis->setUsername($this->getUser()->getUsername());
  328.             $gis->setApproved('0');
  329.             $gis->setType('fossil');
  330.             $gis->setFossil($fossil);
  331.             $em->persist($gis);
  332.             $em->flush();
  334.             $this->addFlash('success', $translator->trans("Fossielenlocatie toegevoegd aan de wachtlijst voor goedkeuring."));
  335.             return $this->redirectToRoute('locations_user_add');
  336.         }
  338.         return $this->render('locations_add_location_fossil.html.twig', [
  339.             'title' => $translator->trans("Fossielenlocatie toevoegen"),
  340.             'form' => $form->createView(),
  341.             'gis' => array(),
  342.             'countries' => $countries,
  343.             'type' => 'user_fossil',
  344.             'form_name' => 'locations_user_fossil',
  345.             'show_map' => true
  346.         ]);
  347.     }
  349.     /**
  350.      * @Route("/moderate/fossil/add", name="locations_fossil_moderate_add")
  351.      */
  352.     public function add( EntityManagerInterface $em, Request $request, TranslatorInterface $translator)
  353.     {
  354.         $this->denyAccessUnlessGranted('ROLE_MOD_LOCATIONS');
  356.         $form = $this->createForm(LocationsFossilFormType::class);
  358.         $form->handleRequest($request);
  359.         if ($form->isSubmitted() && $form->isValid()){
  360.             $fossil = $form->getData();
  361.             $fossil->setUserId($this->getUser()->getId());
  362.             $fossil->setUsername($this->getUser()->getUsername());
  363.             $fossil->setDateAdded(new \DateTime());
  364.             $fossil->setApproved(0);
  365.             $fossil->setNumReviews(0);
  366.             $fossil->setNumNewPhotos(0);
  367.             $em->persist($fossil);
  368.             $em->flush();
  369.             $this->addFlash('success', $translator->trans("Fossielenlocatie toegevoegd"));
  370.             return $this->redirectToRoute('locations_gis_item_moderate',  array('type' => 'fossil', 'id' => $fossil->getId()));
  371.         }
  373.         return $this->render('locations_add_location_fossil.html.twig', [
  374.             'title' => $translator->trans("Fossielenlocatie toevoegen"),
  375.             'form' => $form->createView(),
  376.             'gis' => array(),
  377.             'countries' => array(),
  378.             'type' => 'fossil',
  379.             'form_name' => 'location_fossil',
  380.             'button_text' => $translator->trans("Toevoegen")
  381.         ]);
  382.     }
  384.     /**
  385.      * @Route("/moderate/fossil/{id}/edit", name="locations_fossil_moderate_edit")
  386.      */
  387.     public function edit(int $id, LocationsFossil $fossil, EntityManagerInterface $em, Request $request, TranslatorInterface $translator)
  388.     {
  389.         $this->denyAccessUnlessGranted('ROLE_MOD_LOCATIONS');
  391.         $fossil = $this->get_locations_fossil_by_id($id);
  392.         $old_vulnerability = $fossil->getVulnerability();
  394.         $form = $this->createForm(LocationsFossilFormType::class, $fossil);
  396.         $form->handleRequest($request);
  397.         if ($form->isSubmitted() && $form->isValid()) {
  398.             $fossil = $form->getData();
  400.             $fossil->setDateReviewed(new \DateTime());
  401.             $em->persist($fossil);
  402.             $em->flush();
  404.             $spool = new Spool();
  405.             $spool->setCommand("geojson:locations");
  406.             $spool->setArguments(serialize(array('vulnerability' => $fossil->getVulnerability(), 'type' => 'fossil')));
  407.             $em->persist($spool);
  408.             $em->flush();
  410.             if($fossil->getVulnerability() != $old_vulnerability) {
  411.                 $vulnerability = '';
  412.                 $spool = new Spool();
  413.                 $spool->setCommand("geojson:locations");
  414.                 $spool->setArguments(serialize(array('vulnerability' => $old_vulnerability, 'type' => 'fossil')));
  415.                 $em->persist($spool);
  416.                 $em->flush();
  417.             }
  419.             if ($fossil->getApproved() == 1){
  420.                 $fossil->setApprovedUserId($this->getUser()->getId());
  421.                 $fossil->setApprovedUsername($this->getUser()->getUsername());
  422.                 $newsfeed = new Newsfeed();
  423.                 $newsfeed->setTitleNl($fossil->getLocation());
  424.                 $newsfeed->setTitleEn($fossil->getLocation());
  425.                 $newsfeed->setRemoteId($fossil->getId());
  426.                 $newsfeed->setType('locations_fossil');
  427.                 $newsfeed->setIsUpdate(1);
  428.                 $newsfeed->setTime(new \DateTime());
  429.                 $em = $this->getDoctrine()->getManager();
  430.                 $em->persist($newsfeed);
  431.                 $em->flush();
  433.                 $repository = $em->getRepository(SearchItems::class);
  434.                 $searchitem = $repository->findOneBy(array('path' => $this->router->generate('locations_fossil', [ 'id' => $fossil->getId()]) ));
  436.                 if(!$searchitem) {
  437.                     $searchitem = new SearchItems();
  438.                 }
  439.     
  440.                 $searchitem->setType('locations_fossil');
  441.                 $searchitem->setPath($this->router->generate('locations_fossil', [ 'id' => $fossil->getId()]));
  442.                 $searchitem->setNameNl($fossil->getNameNl());
  443.                 $searchitem->setNameEn($fossil->getNameEn());
  444.                 $searchitem->setKeywordsNl($fossil->getNameNl());
  445.                 $searchitem->setKeywordsEn($fossil->getNameEn());
  446.                 if(empty($fossil->getDateReviewed())) {
  447.                     $searchitem->setLastUpdateTime($fossil->getDateAdded());
  448.                 } else {
  449.                     $searchitem->setLastUpdateTime($fossil->getDateReviewed());
  450.                 }
  451.                 $this->em->persist($searchitem);
  453.                 $repository = $em->getRepository(LocationsFossil::class);
  454.                 $totalsubmissions = $repository->createQueryBuilder('a')
  455.                     ->select('count(a.id)')
  456.                     ->andWhere("a.user_id = (:user)")
  457.                     ->andWhere("a.approved = 1")
  458.                     ->setParameter('user', $fossil->getUserId())
  459.                     ->getQuery()
  460.                     ->getSingleScalarResult();
  461.         
  462.                 $repository = $em->getRepository(User::class);
  463.                 $user = $repository->findOneBy(array('id' => $fossil->getUserId()));
  464.         
  465.                 $repository = $this->getDoctrine()->getRepository(UserProfile::class);
  466.                 $userprofile = $repository->findOneBy(array('user' => $user));
  467.                 if(!$userprofile) {
  468.                     $userprofile = new UserProfile();
  469.                     $userprofile->setUser($user);
  470.                 }
  471.                 $userprofile->setLocationFossilSubmissions($totalsubmissions);
  472.                 $em->persist($userprofile);
  473.                 $em->flush();
  474.             }
  475.             $this->addFlash('success', $translator->trans("Fossielenlocatie bijgewerkt"));
  476.             return $this->redirectToRoute('locations_fossil_moderate');
  477.         }
  479.         return $this->render('locations_add_location_fossil.html.twig', [
  480.             'title' => $translator->trans("Fossielenlocatie bewerken"),
  481.             'form' => $form->createView(),
  482.             'gis' => array(),
  483.             'countries' => array(),
  484.             'type' => 'fossil',
  485.             'form_name' => 'locations_fossil',
  486.             'button_text' => $translator->trans("Bewerken")
  487.         ]);
  488.     }
  490.     /**
  491.      * @Route("/moderate/fossil/{id}/revoke", name="locations_fossil_moderate_revoke")
  492.      */
  493.     public function moderate_revoke(int $id, LocationsFossil $fossil, EntityManagerInterface $em, TranslatorInterface $translator)
  494.     {
  495.         $this->denyAccessUnlessGranted('ROLE_MOD_LOCATIONS');
  497.         $fossil->setApprovedUserId($this->getUser()->getId());
  498.         $fossil->setApprovedUsername($this->getUser()->getUsername());
  499.         $fossil->setApproved('0');
  500.         $em->persist($fossil);
  501.         $em->flush();
  503.         $repository = $this->getDoctrine()->getRepository(LocationsGIS::class);
  504.         $gis = $repository->findBy(array('fossil' => $fossil));
  505.         foreach ($gis as $key => $location) {
  506.             $this->forward('App\Controller\LocationsController:remove_nearby', [
  507.                 'item' => $location,
  508.                 'em' => $em,
  509.                 ]);
  510.                 
  511.             $location->setApproved('0');
  512.             $em->persist($location);
  513.             $em->flush();
  514.         }
  516.         $spool = new Spool();
  517.         $spool->setCommand("geojson:locations");
  518.         $spool->setArguments(serialize(array('vulnerability' => $fossil->getVulnerability(), 'type' => 'fossil')));
  519.         $em->persist($spool);
  520.         $em->flush();
  522.         $repository = $em->getRepository(SearchItems::class);
  523.         $searchitem = $repository->findOneBy(array('path' => $this->router->generate('locations_fossil', [ 'id' => $fossil->getId()]) ));
  524.         if($searchitem){
  525.             $em->remove($searchitem);
  526.             $em->flush();
  527.         }
  529.         $repository = $em->getRepository(LocationsFossil::class);
  530.         $totalsubmissions = $repository->createQueryBuilder('a')
  531.             ->select('count(a.id)')
  532.             ->andWhere("a.user_id = (:user)")
  533.             ->andWhere("a.approved = 1")
  534.             ->setParameter('user', $fossil->getUserId())
  535.             ->getQuery()
  536.             ->getSingleScalarResult();
  538.         $repository = $em->getRepository(User::class);
  539.         $user = $repository->findOneBy(array('id' => $fossil->getUserId()));
  541.         $repository = $this->getDoctrine()->getRepository(UserProfile::class);
  542.         $userprofile = $repository->findOneBy(array('user' => $user));
  543.         if(!$userprofile) {
  544.             $userprofile = new UserProfile();
  545.             $userprofile->setUser($user);
  546.         }
  547.         $userprofile->setLocationFossilSubmissions($totalsubmissions);
  548.         $em->persist($userprofile);
  549.         $em->flush();
  551.         $this->addFlash('success', $translator->trans("Fossielenlocatie ingetrokken"));
  552.         return $this->redirectToRoute('locations_fossil_moderate');
  553.     }
  555.     /**
  556.      * @Route("/moderate/fossil/{id}/approve", name="locations_fossil_moderate_approve")
  557.      */
  558.     public function moderate_approve(int $id, LocationsFossil $fossil, EntityManagerInterface $em, TranslatorInterface $translator)
  559.     {
  560.         $this->denyAccessUnlessGranted('ROLE_MOD_LOCATIONS');
  562.         $LocationsGIS = $fossil->getLocationsGIS()->toArray();
  563.         $has_approved_locations=0;
  564.         foreach ($LocationsGIS as $key => $item) {
  565.             if($item->getApproved() == true ){
  566.                 $has_approved_locations++;
  567.             }
  568.         }
  569.         if (count($fossil->getLocationsGIS()) <= 0) {
  570.             $this->addFlash('error', $translator->trans("Locatie heeft geen coördinaten en kan daarom niet goedgekeurd worden"));
  571.             return $this->redirectToRoute('locations_fossil_moderate');
  572.         } elseif ($has_approved_locations <= 0) {
  573.             $this->addFlash('error', $translator->trans("Locatie heeft geen goedgekeurde coördinaten en kan daarom niet goedgekeurd worden"));
  574.             return $this->redirectToRoute('locations_fossil_moderate');
  575.         } else {
  576.             $fossil->setApprovedUserId($this->getUser()->getId());
  577.             $fossil->setApprovedUsername($this->getUser()->getUsername());
  578.             $fossil->setApproved('1');
  579.             $em->persist($fossil);
  580.             $em->flush();
  582.             $spool = new Spool();
  583.             $spool->setCommand("geojson:locations");
  584.             $spool->setArguments(serialize(array('vulnerability' => $fossil->getVulnerability(), 'type' => 'fossil')));
  585.             $em->persist($spool);
  586.             $em->flush();
  587.             
  588.             $newsfeed = new Newsfeed();
  589.             $newsfeed->setTitleNl($fossil->getLocation());
  590.             $newsfeed->setTitleEn($fossil->getLocation());
  591.             $newsfeed->setRemoteId($fossil->getId());
  592.             $newsfeed->setType('locations_fossil');
  593.             $newsfeed->setTime(new \DateTime());
  594.             $newsfeed->setIsUpdate(0);
  595.             $em = $this->getDoctrine()->getManager();
  596.             $em->persist($newsfeed);
  597.             $em->flush();
  599.             $repository = $em->getRepository(SearchItems::class);
  600.             $searchitem = $repository->findOneBy(array('path' => $this->router->generate('locations_fossil', [ 'id' => $fossil->getId()]) ));
  602.             if(!$searchitem) {
  603.                 $searchitem = new SearchItems();
  604.             }
  606.             $searchitem->setType('locations_fossil');
  607.             $searchitem->setPath($this->router->generate('locations_fossil', [ 'id' => $fossil->getId()]));
  608.             $searchitem->setNameNl($fossil->getNameNl());
  609.             $searchitem->setNameEn($fossil->getNameEn());
  610.             $searchitem->setKeywordsNl($fossil->getNameNl());
  611.             $searchitem->setKeywordsEn($fossil->getNameEn());
  612.             if(empty($fossil->getDateReviewed())) {
  613.                 $searchitem->setLastUpdateTime($fossil->getDateAdded());
  614.             } else {
  615.                 $searchitem->setLastUpdateTime($fossil->getDateReviewed());
  616.             }
  617.             $this->em->persist($searchitem);
  619.             $repository = $em->getRepository(LocationsFossil::class);
  620.             $totalsubmissions = $repository->createQueryBuilder('a')
  621.                 ->select('count(a.id)')
  622.                 ->andWhere("a.user_id = (:user)")
  623.                 ->andWhere("a.approved = 1")
  624.                 ->setParameter('user', $fossil->getUserId())
  625.                 ->getQuery()
  626.                 ->getSingleScalarResult();
  627.     
  628.             $repository = $em->getRepository(User::class);
  629.             $user = $repository->findOneBy(array('id' => $fossil->getUserId()));
  630.     
  631.             $repository = $this->getDoctrine()->getRepository(UserProfile::class);
  632.             $userprofile = $repository->findOneBy(array('user' => $user));
  633.             if(!$userprofile) {
  634.                 $userprofile = new UserProfile();
  635.                 $userprofile->setUser($user);
  636.             }
  637.             $userprofile->setLocationFossilSubmissions($totalsubmissions);
  638.             $em->persist($userprofile);
  639.             $em->flush();
  641.             $locations = $fossil->getLocationsGIS()->toArray();
  642.             $this->forward('App\Controller\LocationsController:find_nearby', [
  643.                 'item' => $locations[0],
  644.                 'em' => $em,
  645.                 ]);
  646.             
  647.             $this->addFlash('success', $translator->trans("Fossielenlocatie goedgekeurd"));
  648.             return $this->redirectToRoute('locations_fossil_moderate');
  649.         }
  650.     }
  652.     /**
  653.      * @Route("/moderate/fossil/{id}/delete", name="locations_fossil_moderate_delete")
  654.      */
  655.     public function moderate_delete(int $id, LocationsFossil $fossil, EntityManagerInterface $em, TranslatorInterface $translator)
  656.     {
  657.         $this->denyAccessUnlessGranted('ROLE_MOD_LOCATIONS');
  659.         $old_vulnerability = $fossil->getVulnerability();
  661.         $repository = $em->getRepository(SearchItems::class);
  662.         $searchitem = $repository->findOneBy(array('path' => $this->router->generate('locations_fossil', [ 'id' => $fossil->getId()]) ));
  663.         if($searchitem){
  664.             $em->remove($searchitem);
  665.             $em->flush();
  666.         }
  668.         $repository = $this->getDoctrine()->getRepository(LocationsGIS::class);
  669.         $gis = $repository->findBy(array('fossil' => $fossil));
  670.         foreach ($gis as $key => $location) {
  671.             $this->forward('App\Controller\LocationsController:remove_nearby', [
  672.                 'item' => $location,
  673.                 'em' => $em,
  674.                 ]);
  675.                 
  676.             $em->remove($location);
  677.             $em->flush();
  678.         }
  679.         $em->remove($fossil);
  680.         $em->flush();
  682.         $spool = new Spool();
  683.         $spool->setCommand("geojson:locations");
  684.         $spool->setArguments(serialize(array('vulnerability' => $old_vulnerability, 'type' => 'fossil')));
  685.         $em->persist($spool);
  686.         $em->flush();
  688.         $repository = $em->getRepository(LocationsFossil::class);
  689.         $totalsubmissions = $repository->createQueryBuilder('a')
  690.             ->select('count(a.id)')
  691.             ->andWhere("a.user_id = (:user)")
  692.             ->andWhere("a.approved = 1")
  693.             ->setParameter('user', $fossil->getUserId())
  694.             ->getQuery()
  695.             ->getSingleScalarResult();
  697.         $repository = $em->getRepository(User::class);
  698.         $user = $repository->findOneBy(array('id' => $fossil->getUserId()));
  700.         $repository = $this->getDoctrine()->getRepository(UserProfile::class);
  701.         $userprofile = $repository->findOneBy(array('user' => $user));
  702.         if(!$userprofile) {
  703.             $userprofile = new UserProfile();
  704.             $userprofile->setUser($user);
  705.         }
  706.         $userprofile->setLocationFossilSubmissions($totalsubmissions);
  707.         $em->persist($userprofile);
  708.         $em->flush();
  710.         $this->addFlash('success', $translator->trans("Fossielenlocatie en coördinaten verwijderd"));
  711.         return $this->redirectToRoute('locations_fossil_moderate');
  712.     }
  714.     /**
  715.      * @Route("/api/v1/locations/fossil", methods="GET", name="api_locations_fossil")
  716.      */
  717.     public function api_locations_fossil(LocationsFossilRepository $LocationsFossilRepository, Request $request, TranslatorInterface $translator)
  718.     {
  719.         $articles = $LocationsFossilRepository->findAllMatching($request->query->get('query'));
  720.         $return = array();
  721.         foreach($articles as $item) {
  722.             if($translator->getLocale() == 'nl') {
  723.                 $name = $item->getNameNl();
  724.             } else {
  725.                 $name = $item->getNameEn();
  726.             }
  727.             $return[] = array(
  728.                 'id' => $item->getId(),
  729.                 'value' => $name,
  730.             );
  731.         }
  732.         return $this->json($return, 200, [], ['groups' => ['main']]);
  733.     }
  734. }