src/Controller/DashboardController.php line 20

  1. <?php
  3. namespace App\Controller;
  5. use Doctrine\ORM\EntityManagerInterface;
  6. use PhpOffice\PhpSpreadsheet\Exception;
  7. use PhpOffice\PhpSpreadsheet\IOFactory;
  8. use Symfony\Component\HttpFoundation\File\Exception\FileException;
  9. use Symfony\Component\HttpFoundation\Request;
  10. use Symfony\Component\HttpFoundation\Response;
  11. use Symfony\Component\Routing\Annotation\Route;
  12. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  14. ##[Route('/admin')]
  15. class DashboardController extends AbstractController
  16. {
  17.     /**
  18.      * @Route("/", name="app_redirect_admin")
  19.      */
  20.     public function redirectAdmin()
  21.     {
  22.         return $this->redirectToRoute('app_login');
  23.     }
  25.     #[Route('/admin', name: 'app_admin')]
  26.     public function dashboard(): Response
  27.     {
  28.         $user = $this->getUser();
  29.         return $this->render('/dashboard/index.html.twig', [
  30.             'user' => $user,
  31.         ]);
  32.     }
  34.     /**
  35.      * @param Request $request
  36.      * @throws Exception
  37.      */
  38.     #[Route('/upload-excel', name: 'app_xlsx')]
  39.     public function xslx(Request $request)
  40.     {
  41.         $file = $request->files->get('file');
  42.         $fileFolder = __DIR__ . '/../../public/upload/excel/';
  43.         $filePathName = md5(uniqid()) . $file->getClientOriginalName();
  45.         try {
  46.             $file->move($fileFolder, $filePathName);
  47.         } catch (FileException $e) {
  48.             dd($e);
  49.         }
  51.         $spreadsheet = IOFactory::load($fileFolder . $filePathName);
  52.         $ColumsNames = $spreadsheet->getActiveSheet()->toArray(null, true, true, true);
  53.         $sheetData = $spreadsheet->getActiveSheet()->removeRow(1);
  54.         $ColumsValues = $spreadsheet->getActiveSheet()->toArray(null, true, true, true);
  56.         dd($ColumsNames[1]);
  57.     }
  58. }