src/Controller/DefaultController.php line 19

Open in your IDE?
  1. <?php
  3. namespace App\Controller;
  5. use App\Entity\ZonaCalore;
  6. use App\Entity\ZonaSismica;
  7. use App\Repository\ZonaCaloreRepository;
  8. use App\Repository\ZonaSismicaRepository;
  9. use Doctrine\ORM\EntityManagerInterface;
  10. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  11. use Symfony\Component\HttpFoundation\Response;
  12. use Symfony\Component\Routing\Annotation\Route;
  14. class DefaultController extends AbstractController
  15. {
  16.     /**
  17.      * @Route("/", name="home")
  18.      */
  19.     public function index(): Response
  20.     {
  22.         $this->denyAccessUnlessGranted("ROLE_USER");
  24.         return $this->redirectToRoute("domanda_home");
  26.         return $this->render('default/index.html.twig', [
  27.             'controller_name' => 'DefaultController',
  28.         ]);
  29.     }
  31.     /**
  32.      * @Route("/importa/zone", name="importa_zone")
  33.      */
  34.     public function importaZone(ZonaSismicaRepository $zonaSismicaRepository, ZonaCaloreRepository $zonaCaloreRepository, EntityManagerInterface $entityManager): Response
  35.     {
  37.         $zoneSismiche = $zonaSismicaRepository->findAll();
  39.         $row = 1;
  40.         if (($handle = fopen("doc/sismica.csv", "r")) !== FALSE) {
  41.             while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
  42.                 $num = count($data);
  43.                 if ($num == 5 && $data[0] != "Regione") {
  44.                     $find = false;
  45.                     foreach ($zoneSismiche as $zonaSismica) {
  46.                         if ($zonaSismica->getNome() == trim($data[3])) {
  47.                             $find = true;
  48.                             break;
  49.                         }
  50.                     }
  51.                     if (!$find) {
  52.                         $zonaSismica = new ZonaSismica();
  53.                         $zonaSismica->setRegione(trim($data[0]));
  54.                         $zonaSismica->setProvincia(trim($data[1]));
  55.                         $zonaSismica->setCodiceIstat(trim($data[2]));
  56.                         $zonaSismica->setNome(strtolower(trim($data[3])));
  57.                         $zonaSismica->setZona(intval(trim($data[4])));
  58.                         $entityManager->persist($zonaSismica);
  59.                     }
  60.                 }
  61.             }
  62.             $entityManager->flush();
  63.             fclose($handle);
  64.         }
  66.         $zoneCalore = $zonaCaloreRepository->findAll();
  68.         $row = 1;
  69.         if (($handle = fopen("doc/calore.csv", "r")) !== FALSE) {
  70.             while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
  71.                 $num = count($data);
  72.                 if ($num == 5 && $data[0] != "pr") {
  73.                     $find = false;
  74.                     foreach ($zoneCalore as $zonaCalore) {
  75.                         if ($zonaCalore->getNome() == trim($data[4])) {
  76.                             $find = true;
  77.                             break;
  78.                         }
  79.                     }
  80.                     if (!$find) {
  81.                         if (trim($data[4]) > "" && trim($data[1]) > "") {
  82.                             $data[4] = preg_replace("/\(.*\)/", "", $data[4]);
  83.                             $zoneCalore = new ZonaCalore();
  84.                             $zoneCalore->setProvincia(trim($data[0]));
  85.                             $zoneCalore->setNome(strtolower(trim($data[4])));
  86.                             $zoneCalore->setZona(trim($data[1]));
  87.                             $entityManager->persist($zoneCalore);
  88.                         }
  89.                     }
  90.                 }
  91.             }
  92.             $entityManager->flush();
  93.             fclose($handle);
  94.         }
  96.         exit();
  97.     }
  98. }