src/Controller/AddressesListController.php line 398

Open in your IDE?
  1. <?php
  3. namespace App\Controller;
  5. use App\Classes\oAddress;
  6. use App\Entity\Addresse;
  7. use App\Entity\AddressesList;
  8. use App\Entity\Computing;
  9. use App\Form\AddressesListType;
  10. use App\Repository\AddresseRepository;
  11. use App\Repository\AddressesListRepository;
  12. use App\Repository\CityRepository;
  13. use App\Repository\ComputingRepository;
  14. use App\Repository\TimingRepository;
  15. use App\Service\GeoLocService;
  16. use Composer\Util\Filesystem;
  17. use Doctrine\ORM\EntityManagerInterface;
  18. use PhpOffice\PhpSpreadsheet\IOFactory;
  19. use Shapefile\Geometry\Point;
  20. use Shapefile\Shapefile;
  21. use Shapefile\ShapefileException;
  22. use Shapefile\ShapefileWriter;
  23. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  24. use Symfony\Component\HttpFoundation\BinaryFileResponse;
  25. use Symfony\Component\HttpFoundation\Request;
  26. use Symfony\Component\HttpFoundation\Response;
  27. use Symfony\Component\Routing\Annotation\Route;
  31. use Symfony\Component\HttpFoundation\JsonResponse;
  33. /**
  34.  * @Route("/addresses/list")
  35.  */
  36. class AddressesListController extends AbstractController
  37. {
  38.     /**
  39.      * @Route("/", name="app_addresses_list_index", methods={"GET"})
  40.      */
  41.     public function index(AddressesListRepository $addressesListRepository): Response
  42.     {
  45.         $addressesLists =  $addressesListRepository->findAll();
  48.         // Surement inutiles - a Vérifier au cas ou
  49.         foreach ($addressesLists as $addressesList)
  50.         {
  51.           //  $addressesListRepository->updateAddressesListStatus($addressesList);
  52.         }
  54.         return $this->render('addresses_list/index.html.twig', [
  55.             'addresses_lists' =>$addressesLists,
  56.         ]);
  57.     }
  59.     /**
  60.      * @Route("/app_addresses_list_geofile/{id}", name="app_addresses_list_geofile_download", methods={"GET"})
  61.      */
  62.     public function geofileDownload(Request $request, AddressesListRepository $addressesListRepository): Response
  63.     {
  66.         echo $this->getParameter('kernel.project_dir').'/public/generated/export.shp';
  67.         $Shapefile = new ShapefileWriter([
  68.             Shapefile::FILE_SHP => fopen($this->getParameter('kernel.project_dir').'/public/generated/export.shp' , 'c+b'),
  69.         ]);
  72.        // die("test");
  74.         try {
  77.             // Open Shapefile
  78.             $Shapefile = new ShapefileWriter([
  79.                 Shapefile::FILE_SHP => fopen($this->getParameter('kernel.project_dir').'/public/generated/export.shp', 'rw'),
  80.             ]);
  83.             // Set shape type
  84.             $Shapefile->setShapeType(Shapefile::SHAPE_TYPE_POINT);
  86.             // Create field structure
  87.             $Shapefile->addNumericField('ID', 10);
  88.             $Shapefile->addCharField('DESC', 25);
  91.             $Point = new Point(12, 18);
  92.             // Set its data
  93.             $Point->setData('ID', 1);
  94.             $Point->setData('DESC', "Point number 1");
  95.             // Write the record to the Shapefile
  96.             $Shapefile->writeRecord($Point);
  100.             $Shapefile = null;
  101.         } catch (ShapefileException $e) {
  103.             var_dump($e);
  104.             die();
  105.         }
  108.         //die();
  109.         //return  new Response('Contact us2');
  112.         // This should return the file located in /mySymfonyProject/web/public-resources/TextFile.txt
  113.         // to being viewed in the Browser
  114.         return new BinaryFileResponse($this->getParameter('kernel.project_dir')."/public/generated/export.shp");
  116.     }
  118.     /**
  119.      * @Route("/new", name="app_addresses_list_new", methods={"GET", "POST"})
  120.      */
  121.     public function new(Request $request, AddressesListRepository $addressesListRepository): Response
  122.     {
  123.         $addressesList = new AddressesList();
  124.         $form = $this->createForm(AddressesListType::class, $addressesList);
  125.         $form->handleRequest($request);
  127.         if ($form->isSubmitted() && $form->isValid()) {
  128.             $addressesList->setStatus(AddressesList::STATUT_VIDE);
  129.             $addressesList->setLocked(false);
  130.             $addressesListRepository->add($addressesList);
  131.             return $this->redirectToRoute('app_addresses_list_index', [], Response::HTTP_SEE_OTHER);
  132.         }
  134.         return $this->renderForm('addresses_list/new.html.twig', [
  135.             'addresses_list' => $addressesList,
  136.             'form' => $form,
  137.         ]);
  138.     }
  140.     /**
  141.      * @Route("/{id}", name="app_addresses_list_show", methods={"GET"})
  142.      */
  143.     public function show(AddressesList $addressesList): Response
  144.     {
  145.         return $this->render('addresses_list/show_addresses.html.twig', [
  146.             'addresses_list' => $addressesList,
  147.         ]);
  148.     }
  150.     /**
  151.      * @Route("/{id}/edit", name="app_addresses_list_edit", methods={"GET", "POST"})
  152.      */
  153.     public function edit(Request $request, AddressesList $addressesList, AddressesListRepository $addressesListRepository): Response
  154.     {
  155.         $form = $this->createForm(AddressesListType::class, $addressesList);
  156.         $form->handleRequest($request);
  158.         if ($form->isSubmitted() && $form->isValid()) {
  159.             $addressesListRepository->add($addressesList);
  160.             return $this->redirectToRoute('app_addresses_list_index', [], Response::HTTP_SEE_OTHER);
  161.         }
  163.         return $this->renderForm('addresses_list/edit.html.twig', [
  164.             'addresses_list' => $addressesList,
  165.             'form' => $form,
  166.         ]);
  167.     }
  169.     /**
  170.      * @Route("/{id}/delete", name="app_addresses_list_delete", methods={ "POST"})
  171.      */
  172.     public function delete(Request $request, AddressesList $addressesList, AddressesListRepository $addressesListRepository, AddresseRepository $addresseRepository): Response
  173.     {
  175.         if ($this->isCsrfTokenValid('delete'.$addressesList->getId(), $request->request->get('_token'))) {
  177.             $addresses = $addressesList->getAddresses();
  178.             foreach ($addresses as $address){
  179.                 $addresseRepository->remove($address);
  180.             }
  182.             $addressesListRepository->remove($addressesList);
  183.         }
  185.         return $this->redirectToRoute('app_addresses_list_index', [], Response::HTTP_SEE_OTHER);
  186.     }
  188.     /**
  189.      * @Route("/{id}/lock", name="app_addresses_list_lock", methods={ "GET"})
  190.      */
  191.     public function lock(Request $request, AddressesList $addressesList, AddressesListRepository $addressesListRepository): Response
  192.     {
  194.         if($addressesList->getStatus() == AddressesList::STATUT_GEOCODED){
  195.             $addressesList->setLocked(true);
  196.             $addressesListRepository->add($addressesList);
  197.         }
  199.         return $this->redirectToRoute('app_addresses_list_index', [], Response::HTTP_SEE_OTHER);
  200.     }
  202.     /**
  203.      * @Route("/{id}/unlock", name="app_addresses_list_unlock", methods={ "GET", "POST"})
  204.      */
  205.     public function unlock(Request $request, AddressesList $addressesList, AddressesListRepository $addressesListRepository, ComputingRepository $computingRepository, TimingRepository $timingRepository): Response
  206.     {
  208.         if ($this->isCsrfTokenValid('unlock'.$addressesList->getId(), $request->request->get('_token'))) {
  211.             // On supprime tous les timings calculés
  213.             // Recup de toutes les computing lié
  216.             $computings = $computingRepository->findByAddressGroup($addressesList);
  218.             foreach ($computings as $computing)
  219.             {
  220.                 $timingRepository->purgeComputingTiming($computing);
  221.                 $computing->setStatus(Computing::STATUT_GROUPE_ADRESSE_NON_VERROUILLE);
  222.                 $computingRepository->add($computing);
  223.             }
  225.             $addressesList->setLocked(false);
  226.             $addressesListRepository->add($addressesList);
  228.             return $this->redirectToRoute('app_addresses_list_index', [], Response::HTTP_SEE_OTHER);
  229.         }
  231.         return $this->renderForm('addresses_list/unlock.html.twig', [
  232.             'addresses_list' => $addressesList,
  233.         ]);
  234.     }
  238.     /**
  239.      * @Route("/{id}/import", name="app_addresse_import", methods={"GET", "POST"})
  240.      */
  241.     public function import(Request $request, AddressesList $addressesList, AddressesListRepository $addressesListRepository , AddresseRepository $addresseRepository): Response
  242.     {
  243.         if ($this->isCsrfTokenValid('import'.$addressesList->getId(), $request->request->get('_token'))) {
  245.             $filename = $request->request->get('inputAddressesFile');
  246.             $file =  $request->files->get('inputAddressesFile');
  247.             $pathname  = $file->getPathname();
  249.             $reader = new \PhpOffice\PhpSpreadsheet\Reader\Xlsx();
  250.             $reader->setReadDataOnly(true);
  251.             $spreadsheet = $reader->load($pathname);
  253.             $sheet = $spreadsheet->getSheet($spreadsheet->getFirstSheetIndex());
  254.             $data = $sheet->toArray();
  256.             foreach ($data as $key => $elt){
  258.                 if($key == 0){ continue;}
  260.                 $adresse_txt = $elt[1];
  261.                 $cp_txt = $elt[2];
  262.                 $ville_txt = $elt[3];
  263.                 $lon_text = $elt[4] ?? null;
  264.                 $lat_text = $elt[5] ?? null;
  266.                 $addresse = new Addresse();
  267.                 $addresse->setAddress($adresse_txt);
  268.                 $addresse->setZipcode($cp_txt);
  269.                 $addresse->setCity($ville_txt);
  270.                 $addresse->setAddressesGroup($addressesList);
  272.                 if($lon_text != null){$addresse->setLon($lon_text);}
  273.                 if($lat_text != null){$addresse->setLat($lat_text);}
  275.                 if($lon_text != null && $lat_text != null)
  276.                 {
  277.                     $addresse->setStatus(Addresse::STATUT_GEOCODED);
  278.                 }
  279.                 else
  280.                 {
  281.                     $addresse->setStatus(Addresse::STATUT_NON_GEOCODED);
  282.                 }
  284.                 $addresseRepository->add($addresse);
  286.             }
  288.             return $this->redirectToRoute('app_addresses_list_show', ['id'=>$addressesList->getId()],  Response::HTTP_SEE_OTHER);
  290.         }
  292.         return $this->renderForm('addresses_list/import.html.twig', [
  293.             'addresses_list' => $addressesList,
  294.         ]);
  297.     }
  300.     /**
  301.      * @Route("/{id}/update_status", name="app_addresses_list_update_status", methods={ "GET"})
  302.      */
  303.     public function updateStatus(Request $request, AddressesList $addressesList, AddressesListRepository $addressesListRepository): Response
  304.     {
  305.         $addressesListRepository->updateAddressesListStatus($addressesList);
  306.         die("You should not be there");
  308.         return $this->redirectToRoute('app_addresses_list_show', ['id'=>$addressesList->getId()], Response::HTTP_SEE_OTHER);
  309.     }
  311.     /**
  312.      * @Route("/{id}/maps", name="app_addresses_list_maps", methods={"GET"})
  313.      */
  314.     public function maps(AddressesList $addressesList): Response
  315.     {
  316.         return $this->render('addresses_list/show_addresses_maps.html.twig', [
  317.             'addresses_list' => $addressesList,
  318.         ]);
  319.     }
  321.     /**
  322.      * @Route("/{id}/ajax_geocode/{threshold}/{limit}/{offset}", name="app_addresses_list_ajax_geocode", methods={"GET"})
  323.      */
  324.     public function ajax_geocode(AddressesList $addressesList, AddresseRepository $addresseRepository , EntityManagerInterface $entityManager, CityRepository  $cityRepository, int $threshold, int $limit, int $offset): Response
  325.     {
  329.         $threshold = $threshold/100;
  331.         $output = [];
  332.         $output['continue'] = true;
  334.         $count = $addresseRepository->coundByAddressGroup($addressesList->getId());
  337.         if($offset + $limit > $count){
  338.             $output['continue'] = false;
  339.         }
  340.         $addresses = $addresseRepository->findByAddressGroup($addressesList->getId(), $limit, $offset);
  344.         foreach ($addresses as $address)
  345.         {
  347.             if($address->getStatus()  == Addresse::STATUT_GEOCODED){
  348.                continue;
  349.             }
  351.             $oAddresse = new oAddress();
  352.             $oAddresse->setAddress($address->getAddress());
  353.             $oAddresse->setCity($address->getCity());
  354.             $oAddresse->setPostcode($address->getZipcode());
  355.             $possibilites = GeoLocService::geolocAddress($oAddresse, $cityRepository);
  359.           // $possibilites = GeoLocService::geolocAddress($address->getAddressLine());
  361.            if(isset($possibilites[0])){
  362.                if( $possibilites[0]['score'] >= $threshold)
  363.                {
  364.                    $address->setLat($possibilites[0]['lat'] );
  365.                    $address->setLon($possibilites[0]['lon']);
  366.                    $address->setStatus(Addresse::STATUT_GEOCODED);
  367.                }
  368.                else
  369.                {
  370.                    $address->setLat( NULL);
  371.                    $address->setLon( NULL);
  372.                    $address->setStatus(Addresse::STATUT_MULTIPLE_GEOCODING_MATCHES);
  373.                }
  374.            }
  375.            else
  376.            {
  377.                $address->setLat( NULL);
  378.                $address->setLon( NULL);
  379.                $address->setStatus(Addresse::STATUT_GEOCODING_ERROR);
  380.            }
  382.             $entityManager->persist($address);
  385.         }
  387.         $entityManager->flush();
  389.         $output['percentage'] = round(($offset+$limit)/$count *100 , 0 );
  390.         if($output['percentage']>100) {$output['percentage'] = 100;}
  391.         return new JsonResponse($output);
  393.     }
  395.     /**
  396.      * @Route("/{id}/bulk_geoloc", name="app_addresse_bulk_geoloc", methods={"GET"})
  397.      */
  398.     public function bulk_geoloc(AddressesList $addressesList): Response
  399.     {
  400.         return $this->render('addresses_list/bulk_geoloc.html.twig', [
  401.             'addresses_list' => $addressesList,
  402.         ]);
  403.     }
  407. }