src/Controller/CompanyDetailsController.php line 160

  1. <?php
  3. namespace App\Controller;
  5. use App\Entity\CompanyDetails;
  6. use App\Form\CompanyDetailsType;
  7. use App\Form\ImportType;
  8. use App\Repository\CompanyDetailsRepository;
  9. use App\Services\ImportCompanyDetailsService;
  10. use Doctrine\ORM\EntityManagerInterface;
  11. use PhpOffice\PhpSpreadsheet\Spreadsheet;
  12. use PhpOffice\PhpSpreadsheet\Writer\Csv;
  13. use Sensio\Bundle\FrameworkExtraBundle\Configuration\Security;
  14. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  15. use Symfony\Component\HttpFoundation\File\Exception\FileException;
  16. use Symfony\Component\HttpFoundation\Request;
  17. use Symfony\Component\HttpFoundation\Response;
  18. use Symfony\Component\HttpFoundation\StreamedResponse;
  19. use Symfony\Component\Routing\Annotation\Route;
  20. use Symfony\Component\String\Slugger\SluggerInterface;
  22. /**
  23.  * @Route("/company_details")
  24.  */
  25. class CompanyDetailsController extends AbstractController
  26. {
  27.     /**
  28.      * @Route("/index", name="company_details_index", methods={"GET"})
  29.      * @Security("is_granted('ROLE_ADMIN')")
  30.      */
  31.     public function index(CompanyDetailsRepository $companyDetailsRepository): Response
  32.     {
  33.         return $this->render('company_details/index.html.twig', [
  34.             'company_details' => $companyDetailsRepository->findAll()
  35.         ]);
  36.     }
  38.     /**
  39.      * @Route("/new", name="company_details_new", methods={"GET", "POST"})
  40.      * @Security("is_granted('ROLE_ADMIN')")
  41.      */
  42.     public function new(Request $request, CompanyDetailsRepository $companyDetailsRepository): Response
  43.     {
  44.         $companyDetails = new CompanyDetails();
  45.         $form = $this->createForm(CompanyDetailsType::class, $companyDetails);
  46.         $form->handleRequest($request);
  48.         if ($form->isSubmitted() && $form->isValid()) {
  49.             $faviconDev = $form['faviconDev']->getData();
  50.             $faviconLive = $form['faviconLive']->getData();
  51.             $qrCode = $form['companyQrCode']->getData();
  53.             if ($faviconDev) {
  54.                 $originalFilename = pathinfo($faviconDev->getClientOriginalName(), PATHINFO_FILENAME);
  55.                 $newFilename = $companyDetails->getCompanyName() . '_dev.' . $faviconDev->guessExtension();
  56.                 $faviconDev->move(
  57.                     $this->getParameter('favicons_directory'),
  58.                     $newFilename
  59.                 );
  60.                 $companyDetails->setFaviconDev($newFilename);
  61.             }
  62.             if ($faviconLive) {
  63.                 $originalFilenameLive = pathinfo($faviconLive->getClientOriginalName(), PATHINFO_FILENAME);
  64.                 $newFilenameLive = $companyDetails->getCompanyName() . '_live.' . $faviconLive->guessExtension();
  65.                 $faviconLive->move(
  66.                     $this->getParameter('favicons_directory'),
  67.                     $newFilenameLive
  68.                 );
  69.                 $companyDetails->setFaviconLive($newFilenameLive);
  70.             }
  71.             if ($qrCode) {
  72.                 $originalFilenameQR = pathinfo($qrCode->getClientOriginalName(), PATHINFO_FILENAME);
  73.                 $newFilenameQR = $companyDetails->getCompanyName() . '_qr_code.' . $qrCode->guessExtension();
  74.                 $qrCode->move(
  75.                     $this->getParameter('favicons_directory'),
  76.                     $newFilenameQR
  77.                 );
  78.                 $companyDetails->setCompanyQrCode($newFilenameQR);
  79.             }
  80.             $companyDetailsRepository->add($companyDetails, true);
  82.             return $this->redirectToRoute('company_details_index', [], Response::HTTP_SEE_OTHER);
  83.         }
  85.         return $this->render('company_details/new.html.twig', [
  86.             'company_details' => $companyDetails,
  87.             'form' => $form->createView(),
  88.         ]);
  89.     }
  91.     /**
  92.      * @Route("/show/{id}", name="company_details_show", methods={"GET"})
  93.      * @Security("is_granted('ROLE_ADMIN')")
  94.      */
  95.     public function show(CompanyDetails $companyDetails): Response
  96.     {
  97.         $faviconsDirectory = str_replace($this->getParameter('kernel.project_dir') . '/public', '', $this->getParameter('favicons_directory'));
  99.         return $this->render('company_details/show.html.twig', [
  100.             'company_detail' => $companyDetails,
  101.             'hide_for_qr_code' => '0',
  102.             'favicons_directory' => $faviconsDirectory,
  103.         ]);
  104.     }
  106.     /**
  107.      * @Route("/show_qr_build/{id}", name="company_details_show_qr_build", methods={"GET"})
  108.      *
  109.      */
  110.     public function showQRBuild(CompanyDetails $companyDetails): Response
  111.     {
  112.         return $this->render('company_details/show_qr_build.html.twig', [
  113.             'company_detail' => $companyDetails,
  114.             'hide_for_qr_code' => '1'
  115.         ]);
  116.     }
  118.     /**
  119.      * @Route("/edit/{id}", name="company_details_edit", methods={"GET", "POST"})
  120.      * @Security("is_granted('ROLE_ADMIN')")
  121.      */
  122.     public function edit(Request $request, CompanyDetails $companyDetails, CompanyDetailsRepository $companyDetailsRepository): Response
  123.     {
  124.         $faviconsDirectory = str_replace($this->getParameter('kernel.project_dir') . '/public', '', $this->getParameter('favicons_directory'));
  126.         $form = $this->createForm(CompanyDetailsType::class, $companyDetails);
  127.         $form->handleRequest($request);
  129.         if ($form->isSubmitted() && $form->isValid()) {
  130.             $faviconDev = $form['faviconDev']->getData();
  131.             $faviconLive = $form['faviconLive']->getData();
  132.             $qrCode = $form['companyQrCode']->getData();
  134.             if ($faviconDev) {
  135.                 $originalFilename = pathinfo($faviconDev->getClientOriginalName(), PATHINFO_FILENAME);
  136.                 $newFilename = $companyDetails->getCompanyName() . '_dev.' . $faviconDev->guessExtension();
  137.                 $faviconDev->move(
  138.                     $this->getParameter('favicons_directory'),
  139.                     $newFilename
  140.                 );
  141.                 $companyDetails->setFaviconDev($newFilename);
  142.             }
  143.             if ($faviconLive) {
  144.                 $originalFilenameLive = pathinfo($faviconLive->getClientOriginalName(), PATHINFO_FILENAME);
  145.                 $newFilenameLive = $companyDetails->getCompanyName() . '_live.' . $faviconLive->guessExtension();
  146.                 $faviconLive->move(
  147.                     $this->getParameter('favicons_directory'),
  148.                     $newFilenameLive
  149.                 );
  150.                 $companyDetails->setFaviconLive($newFilenameLive);
  151.             }
  152.             if ($qrCode) {
  153.                 $originalFilenameQR = pathinfo($qrCode->getClientOriginalName(), PATHINFO_FILENAME);
  154.                 $newFilenameQR = $companyDetails->getCompanyName() . '_qr_code.' . $qrCode->guessExtension();
  155.                 $qrCode->move(
  156.                     $this->getParameter('favicons_directory'),
  157.                     $newFilenameQR
  158.                 );
  159.                 $companyDetails->setCompanyQrCode($newFilenameQR);
  160.             }
  162.             $companyDetailsRepository->add($companyDetails, true);
  164.             return $this->redirectToRoute('company_details_index', [], Response::HTTP_SEE_OTHER);
  165.         }
  167.         return $this->render('company_details/edit.html.twig', [
  168.             'favicons_directory' => $faviconsDirectory,
  169.             'company_details' => $companyDetails,
  170.             'form' => $form->createView(),
  171.         ]);
  172.     }
  174.     /**
  175.      * @Route("/delete/{id}", name="company_details_delete", methods={"POST"})
  176.      * @Security("is_granted('ROLE_ADMIN')")
  177.      */
  178.     public function delete(Request $request, CompanyDetails $companyDetails, CompanyDetailsRepository $companyDetailsRepository): Response
  179.     {
  180.         if ($this->isCsrfTokenValid('delete' . $companyDetails->getId(), $request->request->get('_token'))) {
  181.             $companyDetailsRepository->remove($companyDetails, true);
  182.         }
  184.         return $this->redirectToRoute('company_details_index', [], Response::HTTP_SEE_OTHER);
  185.     }
  188.     /**
  189.      * @Route("/office_address", name="office_address", methods={"GET"})
  190.      */
  191.     public function officeAddress(CompanyDetailsRepository $companyDetailsRepository): Response
  192.     {
  193.         return $this->render('home/officeAddress.html.twig');
  194.     }
  196.     /**
  197.      * @Route("/delete_favicon/{live_or_dev}/{id}", name="company_details_delete_favicon", methods={"POST", "GET"})
  198.      * @Security("is_granted('ROLE_ADMIN')")
  199.      */
  200.     public function deleteLiveDevFavicon(Request $request, int $id, string $live_or_dev, CompanyDetails $companyDetails, EntityManagerInterface $entityManager)
  201.     {
  202.         $referer = $request->headers->get('referer');
  203.         if ($live_or_dev == 'live') {
  204.             $companyDetails->setFaviconLive(null);
  205.             $entityManager->flush();
  206.             $files = glob($this->getParameter('favicons_directory') . "*live*");
  207.             foreach ($files as $file) {
  208.                 unlink($file);
  209.             }
  210.         }
  211.         if ($live_or_dev == 'dev') {
  212.             $companyDetails->setFaviconDev(null);
  213.             $entityManager->flush();
  214.             $files = glob($this->getParameter('favicons_directory') . "*dev*");
  215.             foreach ($files as $file) {
  216.                 unlink($file);
  217.             }
  218.         }
  219.         $entityManager->flush();
  220.         return $this->redirect($referer);
  221.     }
  224.     /**
  225.      * @Route("/delete_qr_code/{id}", name="company_details_delete_qr_code", methods={"POST", "GET"})
  226.      * @Security("is_granted('ROLE_ADMIN')")
  227.      */
  228.     public function deleteQRCodeLiveFavicon(Request $request, int $id, CompanyDetails $companyDetails, EntityManagerInterface $entityManager)
  229.     {
  230.         $referer = $request->headers->get('referer');
  231.         $companyDetails->setCompanyQrCode(null);
  232.         $entityManager->flush();
  233.         $files = glob($this->getParameter('favicons_directory') . "/*qr*");
  234.         foreach ($files as $file) {
  235.             unlink($file);
  236.         }
  237.         $entityManager->flush();
  238.         return $this->redirect($referer);
  239.     }
  241.     /**
  242.      * @Route("/export/database", name="export_database", methods={"POST", "GET"})
  243.      * @Security("is_granted('ROLE_ADMIN')")
  244.      */
  245.     public function exportDatabase(Request $request, EntityManagerInterface $entityManager, \App\Services\CompanyDetailsService $companyDetails)
  246.     {
  247.         $sqlDatabase = $companyDetails->getCompanyDetails()->getSqlDatabase() . '.sql';
  248.         $sqlPassword = $companyDetails->getCompanyDetails()->getDatabasePassword();
  249.         $publicPath = $this->getParameter('public');
  250.         $filePath = $publicPath . '/' . $sqlDatabase;
  252.         if ($_ENV['APP_SERVER'] == "local") {
  253.             exec('mysqldump --user=root --password= --host=localhost ' . escapeshellarg($sqlDatabase) . ' > ' . escapeshellarg($filePath));
  254.         } else {
  255.             exec('mysqldump --user=stephen --password=' . escapeshellarg($sqlPassword) . ' --host=localhost ' . escapeshellarg($sqlDatabase) . ' > ' . escapeshellarg($filePath));
  256.         }
  258.         if (file_exists($filePath)) {
  259.             return $this->file($filePath)->deleteFileAfterSend(true); // Symfony helper to download files
  260.         }
  262.         // If file doesn't exist, redirect back with an error message
  263.         $this->addFlash('error', 'Failed to export the database.');
  264.         $referer = $request->headers->get('Referer');
  265.         return $this->redirect($referer ?? $this->generateUrl('app_home'));
  266.     }
  268.     /**
  269.      * @Route("/edit/update/location", name="update_company_details_location", methods={"POST"})
  270.      * @Security("is_granted('ROLE_ADMIN')")
  271.      */
  272.     public function updateLocation(CompanyDetailsRepository $companyDetailsRepository, EntityManagerInterface $manager): Response
  273.     {
  274.         $id = $_POST['id'];
  275.         $latitude = $_POST['latitude'];
  276.         $longitude = $_POST['longitude'];
  277.         $company_details = $companyDetailsRepository->find($id);
  278.         $company_details->setCompanyAddressLongitude($longitude)
  279.             ->setCompanyAddressLatitude($latitude);
  280.         $manager->flush();
  281.         return new Response(null);
  282.     }
  285.     /**
  286.      * @Route("/company_details_change_field_status/{input}", name="company_details_change_field_status", methods={"GET", "POST"})
  287.      */
  288.     public function changeStatus(Request $request, string $input, CompanyDetailsRepository $companyDetailsRepository, EntityManagerInterface $manager): Response
  289.     {
  290.         $referer = $request->headers->get('Referer');
  291.         $company_details = $companyDetailsRepository->find('1');
  293.         if ($input === 'testingMode') {
  294.             // Special case for 'testingMode' field (string toggle)
  295.             $currentMode = $company_details->getTestingMode();
  296.             $newMode = ($currentMode === 'Testing') ? 'Live' : 'Testing';
  297.             $company_details->setTestingMode($newMode);
  298.         } else {
  299.             // Default behavior for boolean fields
  300.             $fieldname = $input;
  301.             $getter = 'is' . ucfirst($fieldname);
  302.             $setter = 'set' . ucfirst($fieldname);
  304.             if (method_exists($company_details, $getter) && method_exists($company_details, $setter)) {
  305.                 $newValue = !$company_details->$getter();
  306.                 $company_details->$setter($newValue);
  307.             }
  308.         }
  310.         $manager->persist($company_details);
  311.         $manager->flush();
  312.         return $this->redirect($referer);
  313.     }
  316.     /**
  317.      * @Route ("/export", name="company_details_export" )
  318.      */
  319.     public function companyDetailsExport(CompanyDetailsRepository $companyDetailsRepository)
  320.     {
  321.         $data = [];
  322.         $exported_date = new \DateTime('now');
  323.         $exported_date_formatted = $exported_date->format('d-M-Y');
  324.         $fileName = 'company_details_export_' . $exported_date_formatted . '.csv';
  325.         $company_details_list = $companyDetailsRepository->findAll();
  326.         $count = 0;
  328.         foreach ($company_details_list as $company_details) {
  329.             $data[] = [
  330.                 'CompanyDetails',
  331.                 $company_details->getCompanyName(),
  332.                 $company_details->getCompanyWebsite(),
  333.                 $company_details->getContactFirstName(),
  334.                 $company_details->getContactLastName(),
  335.                 $company_details->getCompanyTel(),
  336.                 $company_details->getCompanyMobile(),
  337.                 '',
  339.                 $company_details->getFaviconLive(),
  340.                 $company_details->getFaviconDev(),
  341.                 $company_details->getCompanyQrCode(),
  343.                 $company_details->getCompanyEmail(),
  344.                 $company_details->getCompanyEmailPassword(),
  345.                 $company_details->getCompanyEmailImportDirectory(),
  346.                 $company_details->getCompanyEmailImportProcessedDirectory(),
  347.                 $company_details->getSqlDatabase(),
  348.                 $company_details->getDatabasePassword(),
  350.                 $company_details->getCompanyAddressStreet(),
  351.                 $company_details->getCompanyAddressTown(),
  352.                 $company_details->getCompanyAddressCity(),
  353.                 $company_details->getCompanyAddressPostalCode(),
  354.                 $company_details->getCompanyAddressCountry(),
  355.                 $company_details->getCompanyAddressMapLink(),
  356.                 $company_details->getCompanyAddressLongitude(),
  357.                 $company_details->getCompanyAddressLatitude(),
  358.                 $company_details->getCompanyAddressInstructions(),
  360.                 $company_details->getWeatherLocation(),
  361.                 $company_details->getCompanyTimeZone(),
  362.                 $company_details->getCurrency(),
  364.                 $company_details->getFacebook(),
  365.                 $company_details->getTwitter(),
  366.                 $company_details->getInstagram(),
  367.                 $company_details->getLinkedIn(),
  369.                 $company_details->isHomePagePhotosOnly(),
  370.                 $company_details->isIncludeContactFormHomePage(),
  371.                 $company_details->isIncludeQRCodeHomePage(),
  372.                 $company_details->isMultiLingual(),
  374.                 $company_details->getTitleProducts(),
  375.                 $company_details->getTitleSubProducts(),
  376.                 $company_details->getTitleUsefulLinks(),
  378.                 $company_details->isHeaderDisplayProducts(),
  379.                 $company_details->isHeaderDisplaySubProducts(),
  380.                 $company_details->isHeaderDisplayPhotos(),
  381.                 $company_details->isHeaderDisplayLogin(),
  383.                 $company_details->isHeaderDisplayContactDetails(),
  384.                 $company_details->isHeaderDisplayTelNumbers(),
  385.                 $company_details->isHeaderDisplayAddress(),
  388.                 $company_details->isHeaderDisplayTandCs(),
  390.                 $company_details->isHeaderDisplayBusinessContacts(),
  391.                 $company_details->isHeaderDisplayFacebookPages(),
  392.                 $company_details->getFacebookReviewsHistoryShowMonths(),
  393.                 $company_details->isHeaderDisplayCompetitors(),
  394.                 $company_details->isHeaderDisplayWeather(),
  396.                 $company_details->isFooterDisplayContactDetails(),
  397.                 $company_details->isFooterDisplayAddress(),
  398.                 $company_details->isFooterDisplayTelNumbers(),
  399.                 $company_details->isFooterDisplaySocialMedia(),
  400.                 $company_details->isFooterDisplayProducts(),
  401.                 $company_details->isFooterDisplaySubProducts(),
  403.                 $company_details->isEnableUserRegistration(),
  404.                 $company_details->isWebsiteContactsEmailAlert(),
  405.                 $company_details->getWebsiteContactsAutoReply(),
  406.                 $company_details->getRegistrationEmail(),
  408.                 $company_details->getDefaultUserPassword(),
  409.                 $company_details->getContactFromResponse(),
  410.                 $company_details->getContactFromResponseDuplicateVerified(),
  411.                 $company_details->getContactFromResponseDuplicateUnverified(),
  414.                 $company_details->isUserIncludeHomeAddress(),
  415.                 $company_details->isUserIncludeBusinessAddress(),
  416.                 $company_details->isUserIncludePersonalDetails(),
  417.                 $company_details->isUserIncludeJobDetails(),
  418.             ];
  419.         }
  420.         $company_details_list = $companyDetailsRepository->findAll();
  421.         $concatenatedNotes = "Exported on: " . $exported_date_formatted;
  422.         $spreadsheet = new Spreadsheet();
  423.         $sheet = $spreadsheet->getActiveSheet();
  424.         $sheet->setTitle('Company Details');
  426.         $sheet->getCell('A1')->setValue('Entity');
  428.         $sheet->getCell('B1')->setValue('CompanyName');
  429.         $sheet->getCell('C1')->setValue('CompanyWebsite');
  430.         $sheet->getCell('D1')->setValue('ContactFirstName');
  431.         $sheet->getCell('E1')->setValue('ContactLastName');
  432.         $sheet->getCell('F1')->setValue('CompanyTel');
  433.         $sheet->getCell('G1')->setValue('CompanyMobile');
  435.         $sheet->getCell('I1')->setValue('FaviconLive');
  436.         $sheet->getCell('J1')->setValue('FaviconDev');
  437.         $sheet->getCell('K1')->setValue('CompanyQrCode');
  439.         $sheet->getCell('L1')->setValue('CompanyEmail');
  440.         $sheet->getCell('M1')->setValue('CompanyEmailPassword');
  441.         $sheet->getCell('N1')->setValue('CompanyEmailImportDirectory');
  442.         $sheet->getCell('O1')->setValue('CompanyEmailImportProcessedDirectory');
  443.         $sheet->getCell('P1')->setValue('SqlDatabase');
  444.         $sheet->getCell('Q1')->setValue('DatabasePassword');
  446.         $sheet->getCell('R1')->setValue('CompanyAddressStreet');
  447.         $sheet->getCell('S1')->setValue('CompanyAddressTown');
  448.         $sheet->getCell('T1')->setValue('CompanyAddressCity');
  449.         $sheet->getCell('U1')->setValue('CompanyAddressPostalCode');
  450.         $sheet->getCell('V1')->setValue('CompanyAddressCountry');
  451.         $sheet->getCell('W1')->setValue('CompanyAddressMapLink');
  452.         $sheet->getCell('X1')->setValue('CompanyAddressLongitude');
  453.         $sheet->getCell('Y1')->setValue('CompanyAddressLatitude');
  454.         $sheet->getCell('Z1')->setValue('CompanyAddressInstructions');
  456.         $sheet->getCell('AA1')->setValue('WeatherLocation');
  457.         $sheet->getCell('AB1')->setValue('CompanyTimeZone');
  458.         $sheet->getCell('AC1')->setValue('Currency');
  460.         $sheet->getCell('AD1')->setValue('Facebook');
  461.         $sheet->getCell('AE1')->setValue('Twitter');
  462.         $sheet->getCell('AF1')->setValue('Instagram');
  463.         $sheet->getCell('AG1')->setValue('LinkedIn');
  465.         $sheet->getCell('AH1')->setValue('HomePagePhotosOnly');
  466.         $sheet->getCell('AI1')->setValue('IncludeContactFormHomePage');
  467.         $sheet->getCell('AJ1')->setValue('IncludeQRCodeHomePage');
  468.         $sheet->getCell('AK1')->setValue('MultiLingual');
  470.         $sheet->getCell('AL1')->setValue('TitleProducts');
  471.         $sheet->getCell('AM1')->setValue('TitleSubProducts');
  472.         $sheet->getCell('AN1')->setValue('TitleUsefulLinks');
  474.         $sheet->getCell('AO1')->setValue('HeaderDisplayProducts');
  475.         $sheet->getCell('AP1')->setValue('HeaderDisplaySubProducts');
  476.         $sheet->getCell('AQ1')->setValue('HeaderDisplayPhotos');
  477.         $sheet->getCell('AR1')->setValue('HeaderDisplayLogin');
  479.         $sheet->getCell('AS1')->setValue('HeaderDisplayContactDetails');
  480.         $sheet->getCell('AT1')->setValue('HeaderDisplayTelNumbers');
  481.         $sheet->getCell('AU1')->setValue('HeaderDisplayAddress');
  483.         $sheet->getCell('AV1')->setValue('HeaderDisplayTandCs');
  485.         $sheet->getCell('AW1')->setValue('HeaderDisplayBusinessContacts');
  486.         $sheet->getCell('AX1')->setValue('HeaderDisplayFacebookPages');
  487.         $sheet->getCell('AY1')->setValue('FacebookReviewsHistoryShowMonths');
  488.         $sheet->getCell('AZ1')->setValue('HeaderDisplayCompetitors');
  489.         $sheet->getCell('BA1')->setValue('HeaderDisplayWeather');
  491.         $sheet->getCell('BB1')->setValue('FooterDisplayContactDetails');
  492.         $sheet->getCell('BC1')->setValue('FooterDisplayAddress');
  493.         $sheet->getCell('BD1')->setValue('FooterDisplayTelNumbers');
  494.         $sheet->getCell('BE1')->setValue('FooterDisplaySocialMedia');
  495.         $sheet->getCell('BF1')->setValue('FooterDisplayProducts');
  496.         $sheet->getCell('BG1')->setValue('FooterDisplaySubProducts');
  498.         $sheet->getCell('BH1')->setValue('EnableUserRegistration');
  499.         $sheet->getCell('BI1')->setValue('WebsiteContactsEmailAlert');
  500.         $sheet->getCell('BJ1')->setValue('WebsiteContactsAutoReply');
  501.         $sheet->getCell('BK1')->setValue('RegistrationEmail');
  503.         $sheet->getCell('BL1')->setValue('getDefaultUserPassword');
  504.         $sheet->getCell('BM1')->setValue('getContactFromResponse');
  505.         $sheet->getCell('BN1')->setValue('getContactFromResponseDuplicateVerified');
  506.         $sheet->getCell('BO1')->setValue('getContactFromResponseDuplicateUnverified');
  508.         $sheet->getCell('BP1')->setValue('userIncludeHomeAddress');
  509.         $sheet->getCell('BQ1')->setValue('userIncludeBusinessAddress');
  510.         $sheet->getCell('BR1')->setValue('userIncludePersonalDetails');
  511.         $sheet->getCell('BS1')->setValue('userIncludeJobDetails');
  513.         $sheet->fromArray($data, null, 'A2', true);
  514.         $total_rows = $sheet->getHighestRow();
  515.         for ($i = 2; $i <= $total_rows; $i++) {
  516.             $cell = "L" . $i;
  517.             $sheet->getCell($cell)->getHyperlink()->setUrl("https://google.com");
  518.         }
  519.         $writer = new Csv($spreadsheet);
  520.         $response = new StreamedResponse(function () use ($writer) {
  521.             $writer->save('php://output');
  522.         });
  523.         $response->headers->set('Content-Type', 'application/vnd.ms-excel');
  524.         $response->headers->set('Content-Disposition', sprintf('attachment;filename="%s"', $fileName));
  525.         $response->headers->set('Cache-Control', 'max-age=0');
  526.         return $response;
  527.     }
  529.     /**
  530.      * @Route ("/import", name="company_details_import" )
  531.      */
  532.     public function companyDetailsImport(Request $request, SluggerInterface $slugger, CompanyDetailsRepository $companyDetailsRepository, ImportCompanyDetailsService $importCompanyDetailsService): Response
  533.     {
  534.         $form = $this->createForm(ImportType::class);
  535.         $form->handleRequest($request);
  536.         if ($form->isSubmitted() && $form->isValid()) {
  537.             $importFile = $form->get('File')->getData();
  538.             if ($importFile) {
  539.                 $originalFilename = pathinfo($importFile->getClientOriginalName(), PATHINFO_FILENAME);
  540.                 $safeFilename = $slugger->slug($originalFilename);
  541.                 $newFilename = $safeFilename . '.' . 'csv';
  542.                 try {
  543.                     $importFile->move(
  544.                         $this->getParameter('company_details_import_directory'),
  545.                         $newFilename
  546.                     );
  547.                 } catch (FileException $e) {
  548.                     die('Import failed');
  549.                 }
  550.                 $importCompanyDetailsService->importCompanyDetails($newFilename);
  551.                 return $this->redirectToRoute('company_details_index');
  552.             }
  553.         }
  554.         return $this->render('home/import.html.twig', [
  555.             'form' => $form->createView(),
  556.             'heading' => 'Company Details',
  557.         ]);
  558.     }
  561. }