src/Controller/MainController.php line 23

  1. <?php
  3. namespace App\Controller;
  5. use App\Entity\Organisation;
  6. use App\Entity\Signature;
  7. use App\Repository\OrganisationRepository;
  8. use App\Repository\SignatureRepository;
  9. use App\Services\XLSImporter;
  10. use Doctrine\ORM\EntityManager;
  11. use Doctrine\ORM\Exception\ORMException;
  12. use Doctrine\ORM\OptimisticLockException;
  13. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  14. use Symfony\Component\HttpFoundation\JsonResponse;
  15. use Symfony\Component\HttpFoundation\Request;
  16. use Symfony\Component\HttpFoundation\RequestStack;
  17. use Symfony\Component\HttpFoundation\Response;
  18. use Symfony\Component\Routing\Annotation\Route;
  20. class MainController extends AbstractController
  21. {
  22.     #[Route('/', name: 'app_main')]
  23.     public function index(): Response
  24.     {
  25.         return $this->render('main/index.html.twig', [
  26.             'controller_name' => 'MainController',
  27.         ]);
  28.     }
  29.     #[Route('/import', name: 'app_import')]
  30.     public function import(XLSImporter $XLSImporter, OrganisationRepository $organisationRepo): Response
  31.     {
  32.         $parents=[];
  33.         $res= $XLSImporter->import("C:\Users\kille\Desktop\spiclient.xlsx", false, "row");
  34.         foreach ($res as $key=>$r){
  37.             $contacts =[
  38.                 1=>[
  39.                     "val"=>$r[10],
  40.                     "libelle"=>"Téléphone",
  41.                 ],
  42.                 2=>[
  43.                     "val"=>$r[9],
  44.                     "libelle"=>"Email",
  45.                 ],
  46.                 3=>[
  47.                     "val"=>$r[18],
  48.                     "libelle"=>"Email manager",
  49.                 ]
  50.             ];
  52.             
  53.             $etablisement =[
  54.                 "cp"=> $r[8],
  55.                 "nic"=> null,
  56.                 "etat"=> "Actif",
  57.                 "pays"=> "France",
  58.                 "type"=> $r[24]==0?"Siége":"Ets secondaire",
  59.                 "ville"=> $r[7],
  60.                 "region"=> "Île-de-France",
  61.                 "libelle"=> "APSIE Courbevoie",
  62.                 "adresseLigne1"=> $r[5],
  63.                 "adresseLigne2"=> $r[6],
  64.                 "adresseLigne3"=> null
  65.             ];
  66.             $org=$organisationRepo->findOneBy(["libelle"=>$r[4],"siren"=>$r[42]??"" ]);
  67.             if($org!=null)
  68.                 continue;
  69.             $org =  new Organisation();
  70.             $org->setLibelle($r[4])
  71.                 ->setSiren($r[42]??"")
  72.                 ->setContactsOrganisation($contacts)
  73.                 ->setEtablissement($etablisement)
  74.             ;
  75.             if($r[24]!=0 ){
  76.                 if(isset($parents[$r[24]]))
  77.                 {
  78.                     $orgParent =$organisationRepo->find($parents[$r[24]]);
  79.                     $org->setParent($orgParent);
  81.                 }
  82.                 $organisationRepo->save($org, true);
  83.                 $parents[$r[24]]=$org->getId();
  84.             }
  85.             else{
  86.                 $organisationRepo->save($org, true);
  87.             }
  91.         }
  92.         die();
  93.         return $this->render('main/index.html.twig', [
  94.             'controller_name' => 'MainController',
  95.         ]);
  96.     }
  97.     #[Route('/themes', name: 'app_themes')]
  98.     public function test(Request $request, RequestStack $requestStack): Response
  99.     {
  100.         $session = $requestStack->getSession();
  101.         $curTheme=$request->request->get("curTheme");
  102.         if($curTheme!=null)
  103.             $session->set("curTheme", $curTheme);
  105.         $directory ="/css/themes/";
  106.         $files=[];
  108.         if(file_exists(getcwd().$directory))
  109.             $files = array_diff(scandir( getcwd().$directory), array('..', '.'));
  110.         $themes=[];
  111.         foreach ($files as $f){
  112.             $themes[str_replace("-bootstrap.min.css", "" ,$f)]=$f;
  113.         }
  114.         return $this->render('main/test.html.twig', [
  115.             'controller_name' => 'MainController',
  116.             "themes"=>$themes,
  117.         ]);
  118.     }
  119.     #[Route('/dashboard', name: 'app_dashboard')]
  120.     public function showDashboard(Request $request, RequestStack $requestStack): Response{
  121.         return $this->render('main/dashboard.html.twig');
  122.     }
  123.     #[Route('/signature', name: 'app_signature')]
  124.     public function newSignature(Request $request)
  125.     {
  126. //        $form = $this->createForm(AutographType::class);
  127. //        $form->handleRequest($request);
  128. //
  129. //        if ($form->isSubmitted() && $form->isValid()) {
  130. //            $data = $form->getData();
  131. //            $signature = $data['signature'];
  132. //
  133. //            // Save the signature as an image
  134. //            // ...
  135. //
  136. //            return new Response('Signature saved!');
  137. //        }
  139.         return $this->render('main/signature.html.twig');
  140.     }
  142.     /**
  143.      * @throws OptimisticLockException
  144.      * @throws ORMException
  145.      */
  146.     #[Route('/signature/save', name: 'save_signature')]
  147.     public function saveSignature(Request $request, EntityManager $entityManager)
  148.     {
  149.         $signature= new Signature();
  150.         $signer = $request->request->get('signature');
  151.         $donnees = json_decode(file_get_contents('php://input'), false);
  152.         $usager= $this->getUser();
  153.         $userDirectory = '/public/uploads/signatures/'.$usager;
  154.         if (!is_dir($userDirectory)) {
  155.             mkdir($userDirectory);
  156.         }
  157.         list($type, $data) = explode(';', $donnees->image);
  158.         list(, $image) = explode(',', $data);
  159.         $image_decodee = base64_decode($image);
  160.         $fichier = 'signature_' . md5(uniqid()) . '.png';
  161.         $filePath = $this->getParameter('kernel.project_dir') . $userDirectory . $fichier;
  162.         if (file_put_contents($filePath, $image_decodee)) {
  163.             $this->addFlash('success', 'Signature saved successfully');
  164.         } else {
  165.             $this->addFlash('alert', 'Failed to save your signature');
  166.         }
  167.         //insert to db
  168.         $signature->setNomImage($fichier);
  169.         $signature->setUsager($this->getUser());
  170.         //to get the IP address
  172.         if (!empty($_SERVER['HTTP_CLIENT_IP'])) {
  173.             $IP = $_SERVER['HTTP_CLIENT_IP'];
  174.         } elseif (!empty($_SERVER['HTTP_X_FORWARDED_FOR'])) {
  175.             $IP = $_SERVER['HTTP_X_FORWARDED_FOR'];
  176.         } else {
  177.             $IP = $_SERVER['REMOTE_ADDR'];
  178.         }
  179.         $signature->setAdresseIP($IP);
  180.         $entityManager->persist($signature);
  181.         $entityManager->flush();
  182.         return new JsonResponse(['message' => 'Signature saved', 'filePath' => $filePath], 200, ['Content-Type' => 'image/png']);
  183.     }
  185. }