src/Controller/BusinessContactsController.php line 33

  1. <?php
  3. namespace App\Controller;
  5. use App\Entity\BusinessContacts;
  6. use App\Form\BusinessContactsType;
  7. use App\Form\ImportType;
  8. use App\Repository\BusinessContactsRepository;
  9. use App\Repository\BusinessTypesRepository;
  10. use App\Services\ImportBusinessContactsService;
  11. use App\Services\CompanyDetailsService;
  12. use App\Services\CountBusinessContactsService;
  13. use App\Services\PhoneAnalyzer;
  14. use Doctrine\ORM\EntityManagerInterface;
  15. use JeroenDesloovere\VCard\VCard;
  16. use PhpOffice\PhpSpreadsheet\Spreadsheet;
  17. use PhpOffice\PhpSpreadsheet\Writer\Csv;
  18. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  19. use Symfony\Component\HttpFoundation\BinaryFileResponse;
  20. use Symfony\Component\HttpFoundation\File\Exception\FileException;
  21. use Symfony\Component\HttpFoundation\Request;
  22. use Symfony\Component\HttpFoundation\Response;
  23. use Symfony\Component\HttpFoundation\ResponseHeaderBag;
  24. use Symfony\Component\HttpFoundation\StreamedResponse;
  25. use Symfony\Component\Routing\Annotation\Route;
  26. use Symfony\Component\String\Slugger\SluggerInterface;
  28. /**
  29.  * @Route("/businesscontacts")
  30.  */
  31. class BusinessContactsController extends AbstractController
  32. {
  33.     /**
  34.      * @Route("/index", name="business_contacts_index", methods={"GET"})
  35.      */
  36.     public function index(BusinessContactsRepository $businessContactsRepository, BusinessTypesRepository $businessTypesRepository, CountBusinessContactsService $countBusinessContactsService, PhoneAnalyzer $phoneAnalyzer): Response
  37.     {
  38.         $business_contacts = $businessContactsRepository->findAll();
  39. //        $business_contacts = $businessContactsRepository->findBy([
  40. //            'status' => 'Approved'
  41. //        ]);
  43.         foreach ($business_contacts as $business_contact) {
  44.         $business_contact->phoneAnalysis = [
  45.             'mobile' => $business_contact->getMobile() ? $phoneAnalyzer->analyze($business_contact->getMobile()) : null,
  46.             'landline' => $business_contact->getLandline() ? $phoneAnalyzer->analyze($business_contact->getLandline()) : null,
  47.         ];
  48.     }
  49.         if ($this->isGranted('ROLE_ADMIN')) {
  50.             $business_contacts = $businessContactsRepository->findAll();
  51.         }
  53.         $business_types = $businessTypesRepository->findBy([], ['ranking' => 'ASC']);
  55.         return $this->render('business_contacts/index.html.twig', [
  56.             'business_contacts' => $business_contacts,
  57.             'business_types' => $business_types,
  58.             'countBusinessContactsService' => $countBusinessContactsService,
  59.             'list_or_map' => 'list',
  60.             'admin_check' => 'No'
  61.         ]);
  62.     }
  64.     /**
  65.      * @Route("/index_admin_check", name="business_contacts_index_admin_check", methods={"GET"})
  66.      */
  67.     public function indexAdmin_Check(BusinessContactsRepository $businessContactsRepository, BusinessTypesRepository $businessTypesRepository, CountBusinessContactsService $countBusinessContactsService): Response
  68.     {
  69.         $business_contacts = $businessContactsRepository->findAll();
  70.         $business_types = $businessTypesRepository->findBy([], ['ranking' => 'ASC']);
  72.         return $this->render('business_contacts/index_admin_check.html.twig', [
  73.             'business_contacts' => $business_contacts,
  74.             'business_types' => $business_types,
  75.             'countBusinessContactsService' => $countBusinessContactsService,
  76.             'list_or_map' => 'list',
  77.             'admin_check' => 'Yes'
  78.         ]);
  79.     }
  82.     /**
  83.      * @Route("/map/{subset}", name="business_contacts_map", methods={"GET"})
  84.      */
  85.     public function map(Request $request, string $subset, BusinessContactsRepository $businessContactsRepository, BusinessTypesRepository $businessTypesRepository, CountBusinessContactsService $countBusinessContacts): Response
  86.     {
  87.         if ($subset == 'All') {
  89.             $business_contacts = $businessContactsRepository->findBy([
  90.                 'status' => 'Approved'
  91.             ]);
  92.         }
  94.         if ($subset != 'All') {
  95.             $business_type = $businessTypesRepository->findOneBy(['businessType' => $subset]);
  96.             $business_contacts = $businessContactsRepository->findBy([
  97.                 'status' => 'Approved',
  98.                 'businessType' => $business_type
  99.             ]);
  100.         }
  102.         $latitude_total = 0;
  103.         $longitude_total = 0;
  104.         $count = 0;
  105.         $latitude_max = -100;
  106.         $latitude_min = +100;
  107.         $longitude_max = -100;
  108.         $longitude_min = +100;
  110.         foreach ($business_contacts as $business_contact) {
  111.             if ($business_contact->getLocationLatitude() != 0 or $business_contact->getLocationLatitude() != null) {
  112.                 $count = $count + 1;
  113.                 $latitude_total = $latitude_total + $business_contact->getLocationLatitude();
  114.                 $longitude_total = $longitude_total + $business_contact->getLocationLongitude();
  115.                 if ($business_contact->getLocationLatitude() > $latitude_max) {
  116.                     $latitude_max = $business_contact->getLocationLatitude();
  117.                 }
  118.                 if ($business_contact->getLocationLatitude() < $latitude_min) {
  119.                     $latitude_min = $business_contact->getLocationLatitude();
  120.                 }
  121.                 if ($business_contact->getLocationLongitude() > $longitude_max) {
  122.                     $longitude_max = $business_contact->getLocationLongitude();
  123.                 }
  124.                 if ($business_contact->getLocationLongitude() < $longitude_min) {
  125.                     $longitude_min = $business_contact->getLocationLongitude();
  126.                 }
  127.             }
  128.         }
  130.         if ($count == 0) {
  131.             $latitude_average = 'No data';
  132.             $longitude_average = 'No data';
  133.         }
  134.         if ($count >= 1) {
  135.             $latitude_average = $latitude_total / $count;
  136.             $longitude_average = $longitude_total / $count;
  137.         }
  139.         if ($count < 2) {
  140.             $latitude_range = "TBD";
  141.             $longitude_range = "TBD";
  142.         }
  143.         if ($count > 1) {
  144.             $latitude_range = $latitude_max - $latitude_min;
  145.             $longitude_range = $longitude_max - $longitude_min;
  146.         }
  148.         $business_types = $businessTypesRepository->findBy([], ['ranking' => 'ASC']);
  150.         return $this->render('business_contacts/map_of_business_contacts.html.twig', [
  151.             'business_contacts' => $business_contacts,
  152.             'business_types' => $business_types,
  153.             'subset' => $subset,
  154.             'latitude_max' => $latitude_max,
  155.             'latitude_min' => $latitude_min,
  156.             'latitude_average' => $latitude_average,
  157.             'latitude_range' => $latitude_range,
  158.             'longitude_max' => $longitude_max,
  159.             'longitude_min' => $longitude_min,
  160.             'longitude_average' => $longitude_average,
  161.             'longitude_range' => $longitude_range,
  162.             'count' => $count,
  163.             'list_or_map' => 'map',
  164.             'admin_check' => 'No'
  165.         ]);
  166.     }
  168.     /**
  169.      * @Route("/new/{business_type}", name="business_contacts_new", methods={"GET", "POST"})
  170.      */
  171.     public function new(Request $request, string $business_type, BusinessContactsRepository $businessContactsRepository, BusinessTypesRepository $businessTypesRepository, CompanyDetailsService $companyDetails, EntityManagerInterface $entityManager): Response
  172.     {
  173.         $business_type = $businessTypesRepository->find($business_type);
  174.         $default_country = $companyDetails->getCompanyDetails()->getCompanyAddressCountry();
  175.         $businessContact = new BusinessContacts();
  176.         $businessContact->setBusinessType($business_type);
  177.         $businessContact->setAddressCountry($default_country);
  178.         $form = $this->createForm(BusinessContactsType::class, $businessContact);
  179.         $form->handleRequest($request);
  181.         if ($form->isSubmitted() && $form->isValid()) {
  182.             $photo = $form['photo']->getData();
  183.             if ($photo) {
  184.                 $uniqueId = uniqid(); // Generates a unique ID
  185.                 $uniqueId3digits = substr($uniqueId, 10, 3); // Extracts the first 3 digits
  186.                 $files_name = [];
  187.                 $photo_directory = $this->getParameter('business_contacts_photos_directory');
  188.                 $fileName = pathinfo($photo->getClientOriginalName(), PATHINFO_FILENAME);
  189.                 $file_extension = $photo->guessExtension();
  190.                 $newFileName = $businessContact->getCompany() . "_" . $uniqueId3digits . "." . $file_extension;
  191.                 $photo->move($photo_directory, $newFileName);
  192.                 $businessContact->setPhoto($newFileName);
  193.             }
  195.             $file = $form['files']->getData();
  196.             if ($file) {
  197.                 $file_name = [];
  198.                 $file_directory = $this->getParameter('business_contacts_attachments_directory');
  199.                 $fileName = pathinfo($file->getClientOriginalName(), PATHINFO_FILENAME);
  200.                 $file_extension = $file->guessExtension();
  201.                 $newFileName = $fileName . "." . $file_extension;
  202.                 $file->move($file_directory, $newFileName);
  203.                 $businessContact->setFiles($newFileName);
  204.             }
  207.             $businessContactsRepository->add($businessContact, true);
  208.             $firstName = $businessContact->getFirstName();
  209.             $lastName = $businessContact->getLastName();
  210.             $entityManager->persist($businessContact);
  211.             $entityManager->flush();
  212.             return $this->redirectToRoute('business_contacts_index', [], Response::HTTP_SEE_OTHER);
  213.         }
  215.         return $this->renderForm('business_contacts/new.html.twig', [
  216.             'business_contact' => $businessContact,
  217.             'form' => $form,
  218.         ]);
  219.     }
  221.     /**
  222.      * @Route("/suggestion", name="business_contacts_suggestion", methods={"GET", "POST"})
  223.      */
  224.     public function suggestion(Request $request, BusinessContactsRepository $businessContactsRepository): Response
  225.     {
  226.         $businessContact = new BusinessContacts();
  227.         $form = $this->createForm(BusinessContactsType::class, $businessContact);
  228.         $form->handleRequest($request);
  230.         if ($form->isSubmitted() && $form->isValid()) {
  231.             $businessContactsRepository->add($businessContact, true);
  232.             $businessContact->setStatus('Pending');
  234.             return $this->redirectToRoute('business_contacts_index', [], Response::HTTP_SEE_OTHER);
  235.         }
  237.         return $this->renderForm('business_contacts/new.html.twig', [
  238.             'business_contact' => $businessContact,
  239.             'form' => $form,
  240.         ]);
  241.     }
  243.     /**
  244.      * @Route("/show/{id}", name="business_contacts_show", methods={"GET"})
  245.      */
  246.     public function show(BusinessContacts $businessContact): Response
  247.     {
  248.         return $this->render('business_contacts/show.html.twig', [
  249.             'business_contact' => $businessContact,
  250.         ]);
  251.     }
  253.     /**
  254.      * @Route("/edit/{id}", name="business_contacts_edit", methods={"GET", "POST"})
  255.      */
  256.     public function edit(Request $request, BusinessContacts $businessContact, BusinessContactsRepository $businessContactsRepository): Response
  257.     {
  258.         $form = $this->createForm(BusinessContactsType::class, $businessContact);
  259.         $form->handleRequest($request);
  261.         if ($form->isSubmitted() && $form->isValid()) {
  262.             $photo = $form['photo']->getData();
  263.             if ($photo) {
  264.                 $files_name = [];
  265.                 $photo_directory = $this->getParameter('business_contacts_photos_directory');
  266.                 $fileName = pathinfo($photo->getClientOriginalName(), PATHINFO_FILENAME);
  267.                 $file_extension = $photo->guessExtension();
  268.                 if ($businessContact->getFirstName() == '') {
  269.                     $newFileName = $businessContact->getCompany() . "." . $file_extension;
  270.                 } else {
  271.                     $newFileName = $businessContact->getCompany() . "_" . $businessContact->getFirstName() . "_" . $businessContact->getLastName() . "." . $file_extension;
  272.                 }
  274.                 $photo->move($photo_directory, $newFileName);
  275.                 $businessContact->setPhoto($newFileName);
  276.             }
  278.             $file = $form['files']->getData();
  279.             if ($file) {
  280.                 $file_name = [];
  281.                 $file_directory = $this->getParameter('business_contacts_attachments_directory');
  282.                 $fileName = pathinfo($file->getClientOriginalName(), PATHINFO_FILENAME);
  283.                 $file_extension = $file->guessExtension();
  284.                 $newFileName = $fileName . "." . $file_extension;
  285.                 $file->move($file_directory, $newFileName);
  286.                 $businessContact->setFiles($newFileName);
  287.             }
  289.             $businessContactsRepository->add($businessContact, true);
  291.             return $this->redirectToRoute('business_contacts_index', [], Response::HTTP_SEE_OTHER);
  292.         }
  294.         return $this->renderForm('business_contacts/edit.html.twig', [
  295.             'business_contact' => $businessContact,
  296.             'form' => $form,
  297.         ]);
  298.     }
  300.     /**
  301.      * @Route("/delete/{id}", name="business_contacts_delete", methods={"POST"})
  302.      */
  303.     public function delete(Request $request, BusinessContacts $businessContact, BusinessContactsRepository $businessContactsRepository, EntityManagerInterface $entityManager): Response
  304.     {
  305.         $referer = $request->headers->get('referer');
  306.         $file_name = $businessContact->getFiles();
  308.         if ($file_name) {
  309.             $file = $this->getParameter('business_contacts_attachments_directory') . $file_name;
  310.             if (file_exists($file)) {
  311.                 unlink($file);
  312.             }
  313.             $businessContact->setFiles('');
  314.             $entityManager->flush();
  315.         }
  317.         $photo_file_name = $businessContact->getPhoto();
  318.         if ($photo_file_name) {
  319.             $photo_file_name = $this->getParameter('business_contacts_photos_directory') . $photo_file_name;
  320.             if (file_exists($photo_file_name)) {
  321.                 unlink($photo_file_name);
  322.             }
  323.             $businessContact->setPhoto('');
  324.             $entityManager->flush();
  325.         }
  327.         if ($this->isCsrfTokenValid('delete' . $businessContact->getId(), $request->request->get('_token'))) {
  328.             $businessContactsRepository->remove($businessContact, true);
  329.         }
  330.         return $this->redirect($referer);
  331.     }
  334.     /**
  335.      * @Route("/delete_all", name="business_contacts_delete_all")
  336.      */
  337.     public function deleteAllBusinessContacts(BusinessContactsRepository $businessContactsRepository, EntityManagerInterface $entityManager): Response
  338.     {
  339.         $business_contacts = $businessContactsRepository->findAll();
  340.         foreach ($business_contacts as $business_contact) {
  341.             $entityManager->remove($business_contact);
  342.             $entityManager->flush();
  343.         }
  344.         return $this->redirectToRoute('business_contacts_index', [], Response::HTTP_SEE_OTHER);
  345.     }
  348.     /**
  349.      * @Route("/delete_photo_file/{id}", name="business_contact_delete_photo_file", methods={"POST", "GET"})
  350.      */
  351.     public function deleteBusinessContactPhotoFile(int $id, Request $request, BusinessContacts $businessContact, EntityManagerInterface $entityManager)
  352.     {
  353.         $referer = $request->headers->get('referer');
  354.         $photo_file_name = $businessContact->getPhoto();
  355.         if ($photo_file_name) {
  356.             $photo_file_name = $this->getParameter('business_contacts_photos_directory') . "/" . $photo_file_name;
  357.             if (file_exists($photo_file_name)) {
  358.                 unlink($photo_file_name);
  359.             }
  360.             $businessContact->setPhoto('');
  361.             $entityManager->flush();
  362.         }
  363.         return $this->redirect($referer);
  364.     }
  366.     /**
  367.      * @Route("/delete_attachment_file/{id}", name="business_contact_delete_attachment_file", methods={"POST", "GET"})
  368.      */
  369.     public function deleteBusinessContactAttachmentFile(int $id, Request $request, BusinessContacts $businessContact, EntityManagerInterface $entityManager)
  370.     {
  371.         $referer = $request->headers->get('referer');
  372.         $file_name = $businessContact->getFiles();
  373.         if ($file_name) {
  374.             $file = $this->getParameter('business_contacts_attachments_directory') . "/" . $file_name;
  375.             if (file_exists($file)) {
  376.                 unlink($file);
  377.             }
  378.             $businessContact->setFiles('');
  379.             $entityManager->flush();
  380.         }
  381.         return $this->redirect($referer);
  382.     }
  384.     /**
  385.      * @Route ("/view/photo/{id}", name="view_business_contact_photo")
  386.      */
  387.     public function viewBusinessContactPhoto(Request $request, $id, BusinessContactsRepository $businessContactsRepository)
  388.     {
  389.         $business_contact = $businessContactsRepository->find($id);
  390.         return $this->render('business_contacts/view_photo.html.twig', ['business_contact' => $business_contact]);
  391.     }
  394.     /**
  395.      * @Route ("/export/business_contacts", name="business_contacts_export" )
  396.      */
  397.     public function businessContactsExport(BusinessContactsRepository $businessContactsRepository)
  398.     {
  399.         $data = [];
  400.         $exported_date = new \DateTime('now');
  401.         $exported_date_formatted = $exported_date->format('d-M-Y');
  402.         $fileName = 'business_contacts_export_' . $exported_date_formatted . '.csv';
  404.         $count = 0;
  405.         $business_contact_list = $businessContactsRepository->findAll();
  406.         foreach ($business_contact_list as $business_contact) {
  407.             $concatenatedNotes = "Exported on: " . $exported_date_formatted;
  408.             $data[] = [
  409.                 "BusinessContacts",
  410.                 $business_contact->getStatus(),
  411.                 $business_contact->getBusinessOrPerson(),
  412.                 $business_contact->getBusinessType()->getBusinessType(),
  413.                 $business_contact->getCompany(),
  414.                 $business_contact->getFirstName(),
  416.                 $business_contact->getLastName(),
  417.                 $business_contact->getWebsite(),
  418.                 $business_contact->getEmail(),
  419.                 $business_contact->getLandline(),
  420.                 $business_contact->getMobile(),
  422.                 $business_contact->getAddressStreet(),
  423.                 $business_contact->getAddressCity(),
  424.                 $business_contact->getAddressCounty(),
  425.                 $business_contact->getAddressPostCode(),
  426.                 $business_contact->getAddressCountry(),
  428.                 $business_contact->getLocationLongitude(),
  429.                 $business_contact->getLocationLatitude(),
  430.                 $business_contact->getNotes()
  431.             ];
  432.         }
  433.         $spreadsheet = new Spreadsheet();
  434.         $sheet = $spreadsheet->getActiveSheet();
  435.         $sheet->setTitle('Business Contacts');
  436.         $sheet->getCell('A1')->setValue('Entity');
  437.         $sheet->getCell('B1')->setValue('Status');
  438.         $sheet->getCell('C1')->setValue('Business Or Person');
  439.         $sheet->getCell('D1')->setValue('Business Type');
  440.         $sheet->getCell('E1')->setValue('Company');
  441.         $sheet->getCell('F1')->setValue('First Name');
  443.         $sheet->getCell('G1')->setValue('Last Name');
  444.         $sheet->getCell('H1')->setValue('Web Page');
  445.         $sheet->getCell('I1')->setValue('E-mail');
  446.         $sheet->getCell('J1')->setValue('Business Phone');
  447.         $sheet->getCell('K1')->setValue('Mobile Phone');
  449.         $sheet->getCell('L1')->setValue('Business Street');
  450.         $sheet->getCell('M1')->setValue('Business City');
  451.         $sheet->getCell('N1')->setValue('Business County');
  452.         $sheet->getCell('O1')->setValue('Business Postal Code');
  453.         $sheet->getCell('P1')->setValue('Business Country/Region');
  455.         $sheet->getCell('Q1')->setValue('Location Longitude');
  456.         $sheet->getCell('R1')->setValue('Location Latitude');
  458.         $sheet->fromArray($data, null, 'A2', true);
  459.         $total_rows = $sheet->getHighestRow();
  460.         for ($i = 2; $i <= $total_rows; $i++) {
  461.             $cell = "L" . $i;
  462.             $sheet->getCell($cell)->getHyperlink()->setUrl("https://google.com");
  463.         }
  464.         $writer = new Csv($spreadsheet);
  465.         $response = new StreamedResponse(function () use ($writer) {
  466.             $writer->save('php://output');
  467.         });
  468.         $response->headers->set('Content-Type', 'application/vnd.ms-excel');
  469.         $response->headers->set('Content-Disposition', sprintf('attachment;filename="%s"', $fileName));
  470.         $response->headers->set('Cache-Control', 'max-age=0');
  471.         return $response;
  472.     }
  474.     /**
  475.      * @Route ("/export/business_contacts_outlook", name="business_contacts_export_for_outlook" )
  476.      */
  477.     public function businessContactsExportForOutlook(BusinessContactsRepository $businessContactsRepository)
  478.     {
  479.         $data = [];
  480.         $exported_date = new \DateTime('now');
  481.         $exported_date_formatted = $exported_date->format('d-M-Y');
  482.         $fileName = 'business_contacts_export_for_outlook_' . $exported_date_formatted . '.csv';
  484.         $count = 0;
  485.         $business_contact_list = $businessContactsRepository->findAll();
  486.         foreach ($business_contact_list as $business_contact) {
  487.             $concatenatedNotes = "Exported on: " . $exported_date_formatted;
  488.             $data[] = [
  489.                 $business_contact->getStatus(),
  490.                 $business_contact->getBusinessOrPerson(),
  491.                 $business_contact->getBusinessType()->getBusinessType(),
  492.                 $business_contact->getCompany(),
  493.                 $business_contact->getFirstName(),
  495.                 $business_contact->getLastName(),
  496.                 $business_contact->getWebsite(),
  497.                 $business_contact->getEmail(),
  498.                 $business_contact->getLandline(),
  499.                 $business_contact->getMobile(),
  501.                 $business_contact->getAddressStreet(),
  502.                 $business_contact->getAddressCity(),
  503.                 $business_contact->getAddressCounty(),
  504.                 $business_contact->getAddressPostCode(),
  505.                 $business_contact->getAddressCountry(),
  507.                 $business_contact->getLocationLongitude(),
  508.                 $business_contact->getLocationLatitude(),
  509.                 $concatenatedNotes,
  510.                 $business_contact->getId()
  511.             ];
  512.         }
  513.         $spreadsheet = new Spreadsheet();
  514.         $sheet = $spreadsheet->getActiveSheet();
  515.         $sheet->setTitle('Business Contacts');
  516.         $sheet->getCell('A1')->setValue('Status');
  517.         $sheet->getCell('B1')->setValue('Business Or Person');
  518.         $sheet->getCell('C1')->setValue('Business Type');
  519.         $sheet->getCell('D1')->setValue('Company');
  520.         $sheet->getCell('E1')->setValue('First Name');
  522.         $sheet->getCell('F1')->setValue('Last Name');
  523.         $sheet->getCell('G1')->setValue('Web Page');
  524.         $sheet->getCell('H1')->setValue('E-mail');
  525.         $sheet->getCell('I1')->setValue('Business Phone');
  526.         $sheet->getCell('J1')->setValue('Mobile Phone');
  528.         $sheet->getCell('K1')->setValue('Business Street');
  529.         $sheet->getCell('L1')->setValue('Business City');
  530.         $sheet->getCell('M1')->setValue('Business County');
  531.         $sheet->getCell('N1')->setValue('Business Postal Code');
  532.         $sheet->getCell('O1')->setValue('Business Country/Region');
  534.         $sheet->getCell('P1')->setValue('Location Longitude');
  535.         $sheet->getCell('Q1')->setValue('Location Latitude');
  536.         $sheet->getCell('R1')->setValue('Notes');
  537.         $sheet->getCell('S1')->setValue('Id');
  539.         $sheet->fromArray($data, null, 'A2', true);
  540.         $total_rows = $sheet->getHighestRow();
  541.         for ($i = 2; $i <= $total_rows; $i++) {
  542.             $cell = "L" . $i;
  543.             $sheet->getCell($cell)->getHyperlink()->setUrl("https://google.com");
  544.         }
  545.         $writer = new Csv($spreadsheet);
  546.         $response = new StreamedResponse(function () use ($writer) {
  547.             $writer->save('php://output');
  548.         });
  549.         $response->headers->set('Content-Type', 'application/vnd.ms-excel');
  550.         $response->headers->set('Content-Disposition', sprintf('attachment;filename="%s"', $fileName));
  551.         $response->headers->set('Cache-Control', 'max-age=0');
  552.         return $response;
  553.     }
  556.     /**
  557.      * @Route ("/import", name="business_contacts_import" )
  558.      */
  559.     public function businessContactsImport(Request $request, SluggerInterface $slugger, BusinessContactsRepository $businessContactsRepository, ImportBusinessContactsService $businessContactsImportService): Response
  560.     {
  561.         $form = $this->createForm(ImportType::class);
  562.         $form->handleRequest($request);
  563.         if ($form->isSubmitted() && $form->isValid()) {
  564.             $importFile = $form->get('File')->getData();
  565.             if ($importFile) {
  566.                 $originalFilename = pathinfo($importFile->getClientOriginalName(), PATHINFO_FILENAME);
  567.                 $safeFilename = $slugger->slug($originalFilename);
  568.                 $newFilename = $safeFilename . '.' . 'csv';
  569.                 try {
  570.                     $importFile->move(
  571.                         $this->getParameter('business_contacts_import_directory'),
  572.                         $newFilename
  573.                     );
  574.                 } catch (FileException $e) {
  575.                     die('Import failed');
  576.                 }
  577.                 $businessContactsImportService->importBusinessContacts($newFilename);
  578.                 return $this->redirectToRoute('business_contacts_index');
  579.             }
  580.         }
  581.         return $this->render('home/import.html.twig', [
  582.             'form' => $form->createView(),
  583.             'heading' => 'Business Contacts Import',
  584.         ]);
  585.     }
  588.     /**
  589.      * @Route("/create/Vcard/{id}", name="create_vcard")
  590.      */
  591.     public function createVcard(int $id, BusinessContactsRepository $businessContactsRepository)
  592.     {
  593.         $business_contact = $businessContactsRepository->find($id);
  594.         $vcard = new VCard();
  595.         $businessOrPerson = $business_contact->getBusinessOrPerson();
  596.         $business_type = $business_contact->getBusinessType()->getBusinessType();
  597.         $firstName = $business_contact->getFirstName();
  598.         $lastName = $business_contact->getLastName();
  599.         $mobile = $business_contact->getMobile();
  600.         $landline = $business_contact->getLandline();
  601.         $company = $business_contact->getCompany();
  602.         $website = $business_contact->getWebsite();
  603.         $addressStreet = $business_contact->getAddressStreet();
  604.         $addressCity = $business_contact->getAddressCity();
  605.         $addressPostCode = $business_contact->getAddressPostcode();
  606.         $addressCountry = $business_contact->getAddressCountry();
  607.         $longitude = $business_contact->getLocationLongitude();
  608.         $latitude = $business_contact->getLocationLatitude();
  609.         $notes = $business_contact->getNotes();
  611.         if ($businessOrPerson = "Business") {
  612.             $firstNameCard = $company;
  613.             $lastNameCard = $business_type;
  614.             $companyCard = [];
  615.         }
  617.         if ($businessOrPerson = "Person") {
  618.             $firstNameCard = $firstName;
  619.             $lastNameCard = $lastName;
  620.             $companyCard = $company;
  621.         }
  623.         $vcard->addName($lastNameCard, $firstNameCard);
  624.         $vcard->addEmail($business_contact->getEmail())
  625.             ->addPhoneNumber($landline, 'work')
  626.             ->addPhoneNumber($mobile, 'mobile')
  627.             ->addCompany($companyCard)
  628.             ->addURL($website)
  629.             ->addNote($notes)
  630.             ->addAddress($name = '', $extended = '', $street = $addressStreet, $city = $addressCity, $region = '', $zip = $addressPostCode, $country = $addressCountry, $type = 'WORK;POSTAL');
  631.         $vcard->download();
  632.         return new Response(null);
  633.     }
  635.     /**
  636.      * @Route("/gps/GoogleMap/show/{id}", name="show_location_google_maps", methods={"GET"})
  637.      */
  638.     public function showMap(int $id, BusinessContactsRepository $businessContactsRepository): Response
  639.     {
  640.         $business_contact = $businessContactsRepository->find($id);
  641.         $longitude = $business_contact->getLocationLongitude();
  642.         $latitude = $business_contact->getLocationLatitude();
  643.         return $this->render('business_contacts/gpsGoogleMaps.html.twig', [
  644.             'latitude' => $latitude,
  645.             'longitude' => $longitude,
  646.             'business_contact' => $business_contact,
  647.             'admin_check' => 'No'
  648.         ]);
  649.     }
  651.     /**
  652.      * @Route("/update/location", name="update_business_contact_location", methods={"POST"})
  653.      */
  654.     public function updateLocation(BusinessContactsRepository $businessContactsRepository, EntityManagerInterface $manager): Response
  655.     {
  656.         $id = $_POST['id'];
  657.         $latitude = $_POST['latitude'];
  658.         $longitude = $_POST['longitude'];
  659.         $gps = $latitude . ',' . $longitude;
  660.         $business_contact = $businessContactsRepository->find($id);
  661.         $business_contact->setLocationLongitude($longitude)
  662.             ->setLocationLatitude($latitude);
  663.         $manager->flush();
  664.         return new Response(null);
  665.     }
  667.     /**
  668.      * @Route("/gps_location_clear/{id}", name="business_contact_clear_gps_location")
  669.      */
  670.     public
  671.     function clearGPSLocation(Request $request, BusinessContacts $businessContacts, EntityManagerInterface $entityManager)
  672.     {
  673.         $referer = $request->headers->get('referer');
  674.         $businessContacts->setLocationLongitude(null);
  675.         $businessContacts->setLocationLatitude(null);
  676.         $entityManager->flush();
  677.         return $this->redirect($referer);
  678.     }
  681.     /**
  682.      * @Route("/show_attachment/{id}", name="business_contact_show_attachment")
  683.      */
  684.     public function showAttachmentBusinessContact(int $id, BusinessContactsRepository $businessContactsRepository)
  685.     {
  686.         $business_contact = $businessContactsRepository->find($id);
  687.         $filename = $business_contact->getFiles();
  688.         $filepath = $this->getParameter('business_contacts_attachments_directory') . "/" . $filename;
  689.         if (file_exists($filepath)) {
  690.             $response = new BinaryFileResponse($filepath);
  691.             $response->setContentDisposition(
  692.                 ResponseHeaderBag::DISPOSITION_INLINE, //use ResponseHeaderBag::DISPOSITION_ATTACHMENT to save as an attachment
  693.                 $filename
  694.             );
  695.             return $response;
  696.         } else {
  697.             return new Response("file does not exist");
  698.         }
  699.     }
  700. }