src/Controller/BusinessContactsController.php line 48

  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. {
  34.     /**
  35.      * @Route("/index", name="business_contacts_index", methods={"GET"})
  36.      */
  37.     public function index(Request $request, BusinessContactsRepository $businessContactsRepository, BusinessTypesRepository $businessTypesRepository, CountBusinessContactsService $countBusinessContactsService, PhoneAnalyzer $phoneAnalyzer): Response
  38.     {
  39.         $business_types_all = $businessTypesRepository->findAll();
  40.         usort($business_types_all, function($a, $b) {
  41.             return strcmp($a->getBusinessType(), $b->getBusinessType());
  42.         });
  44.         $businessTypeName = $request->query->get('business_type');
  45.         $adminView = $request->query->get('admin_view'); // <-- New
  47.         if ($businessTypeName) {
  48.             // Look up the type entity
  49.             $businessType = $businessTypesRepository->findOneBy(['businessType' => $businessTypeName]);
  51.             if ($businessType) {
  52.                 // Filtered: only contacts and types for this type
  53.                 $business_contacts = $businessContactsRepository->findBy(
  54.                     ['businessType' => $businessType],
  55.                     ['id' => 'ASC']
  56.                 );
  57.                 $business_types = [$businessType]; // ONLY this type for headings
  58.             } else {
  59.                 // Invalid filter: fallback to all
  60.                 $business_contacts = $businessContactsRepository->findAll();
  61.                 $business_types = $businessTypesRepository->findBy([], ['ranking' => 'ASC']);
  62.             }
  63.         } else {
  64.             // No filter: show everything
  65.             $business_contacts = $businessContactsRepository->findAll();
  66.             $business_types = $businessTypesRepository->findBy([], ['ranking' => 'ASC']);
  67.         }
  69.         // Analyze phones
  70.         foreach ($business_contacts as $business_contact) {
  71.             $business_contact->phoneAnalysis = [
  72.                 'mobile' => $business_contact->getMobile() ? $phoneAnalyzer->analyze($business_contact->getMobile()) : null,
  73.                 'landline' => $business_contact->getLandline() ? $phoneAnalyzer->analyze($business_contact->getLandline()) : null,
  74.             ];
  75.         }
  77.         return $this->render('business_contacts/index.html.twig', [
  78.             'business_contacts' => $business_contacts,
  79.             'business_types' => $business_types,
  80.             'business_types_all' => $business_types_all,
  81.             'countBusinessContactsService' => $countBusinessContactsService,
  82.             'list_or_map' => 'list',
  83.             'admin_check' => $adminView === 'Admin' ? 'Yes' : 'No', // <-- Change
  84.             'current_business_type' => $businessTypeName,
  85.         ]);
  86.     }
  90.     /**
  91.      * @Route("/map/{subset}", name="business_contacts_map", methods={"GET"})
  92.      */
  93.     public function map(Request $request, string $subset, BusinessContactsRepository $businessContactsRepository, BusinessTypesRepository $businessTypesRepository, CountBusinessContactsService $countBusinessContacts): Response
  94.     {
  95.         if ($subset == 'All') {
  96.             $business_contacts = $businessContactsRepository->findBy([
  97.                 'status' => 'Approved'
  98.             ]);
  99.         }
  101.         if ($subset != 'All') {
  102.             $business_type = $businessTypesRepository->findOneBy(['businessType' => $subset]);
  103.             $business_contacts = $businessContactsRepository->findBy([
  104.                 'status' => 'Approved',
  105.                 'businessType' => $business_type
  106.             ]);
  107.         }
  109.         $latitude_total = 0;
  110.         $longitude_total = 0;
  111.         $count = 0;
  112.         $latitude_max = -100;
  113.         $latitude_min = +100;
  114.         $longitude_max = -100;
  115.         $longitude_min = +100;
  117.         foreach ($business_contacts as $business_contact) {
  118.             if ($business_contact->getLocationLatitude() != 0 or $business_contact->getLocationLatitude() != null) {
  119.                 $count = $count + 1;
  120.                 $latitude_total = $latitude_total + $business_contact->getLocationLatitude();
  121.                 $longitude_total = $longitude_total + $business_contact->getLocationLongitude();
  122.                 if ($business_contact->getLocationLatitude() > $latitude_max) {
  123.                     $latitude_max = $business_contact->getLocationLatitude();
  124.                 }
  125.                 if ($business_contact->getLocationLatitude() < $latitude_min) {
  126.                     $latitude_min = $business_contact->getLocationLatitude();
  127.                 }
  128.                 if ($business_contact->getLocationLongitude() > $longitude_max) {
  129.                     $longitude_max = $business_contact->getLocationLongitude();
  130.                 }
  131.                 if ($business_contact->getLocationLongitude() < $longitude_min) {
  132.                     $longitude_min = $business_contact->getLocationLongitude();
  133.                 }
  134.             }
  135.         }
  137.         if ($count == 0) {
  138.             $latitude_average = 'No data';
  139.             $longitude_average = 'No data';
  140.         }
  141.         if ($count >= 1) {
  142.             $latitude_average = $latitude_total / $count;
  143.             $longitude_average = $longitude_total / $count;
  144.         }
  146.         if ($count < 2) {
  147.             $latitude_range = "TBD";
  148.             $longitude_range = "TBD";
  149.         }
  150.         if ($count > 1) {
  151.             $latitude_range = $latitude_max - $latitude_min;
  152.             $longitude_range = $longitude_max - $longitude_min;
  153.         }
  155.         $business_types = $businessTypesRepository->findBy([], ['ranking' => 'ASC']);
  157.         return $this->render('business_contacts/map_of_business_contacts.html.twig', [
  158.             'business_contacts' => $business_contacts,
  159.             'business_types' => $business_types,
  160.             'subset' => $subset,
  161.             'latitude_max' => $latitude_max,
  162.             'latitude_min' => $latitude_min,
  163.             'latitude_average' => $latitude_average,
  164.             'latitude_range' => $latitude_range,
  165.             'longitude_max' => $longitude_max,
  166.             'longitude_min' => $longitude_min,
  167.             'longitude_average' => $longitude_average,
  168.             'longitude_range' => $longitude_range,
  169.             'count' => $count,
  170.             'list_or_map' => 'map',
  171.             'admin_check' => 'No'
  172.         ]);
  173.     }
  175.     /**
  176.      * @Route("/new/{business_type}", name="business_contacts_new", methods={"GET", "POST"})
  177.      */
  178.     public function new(Request $request, string $business_type, BusinessContactsRepository $businessContactsRepository, BusinessTypesRepository $businessTypesRepository, CompanyDetailsService $companyDetails, EntityManagerInterface $entityManager): Response
  179.     {
  180.         $business_type = $businessTypesRepository->find($business_type);
  181.         $default_country = $companyDetails->getCompanyDetails()->getCompanyAddressCountry();
  182.         $businessContact = new BusinessContacts();
  183.         $businessContact->setBusinessType($business_type);
  184.         $businessContact->setAddressCountry($default_country);
  185.         $form = $this->createForm(BusinessContactsType::class, $businessContact);
  186.         $form->handleRequest($request);
  188.         if ($form->isSubmitted() && $form->isValid()) {
  189.             $photo = $form['photo']->getData();
  190.             if ($photo) {
  191.                 $uniqueId = uniqid(); // Generates a unique ID
  192.                 $uniqueId3digits = substr($uniqueId, 10, 3); // Extracts the first 3 digits
  193.                 $files_name = [];
  194.                 $photo_directory = $this->getParameter('business_contacts_photos_directory');
  195.                 $fileName = pathinfo($photo->getClientOriginalName(), PATHINFO_FILENAME);
  196.                 $file_extension = $photo->guessExtension();
  197.                 $newFileName = $businessContact->getCompany() . "_" . $uniqueId3digits . "." . $file_extension;
  198.                 $photo->move($photo_directory, $newFileName);
  199.                 $businessContact->setPhoto($newFileName);
  200.             }
  202.             $file = $form['files']->getData();
  203.             if ($file) {
  204.                 $file_name = [];
  205.                 $file_directory = $this->getParameter('business_contacts_attachments_directory');
  206.                 $fileName = pathinfo($file->getClientOriginalName(), PATHINFO_FILENAME);
  207.                 $file_extension = $file->guessExtension();
  208.                 $newFileName = $fileName . "." . $file_extension;
  209.                 $file->move($file_directory, $newFileName);
  210.                 $businessContact->setFiles($newFileName);
  211.             }
  214.             $businessContactsRepository->add($businessContact, true);
  215.             $firstName = $businessContact->getFirstName();
  216.             $lastName = $businessContact->getLastName();
  217.             $entityManager->persist($businessContact);
  218.             $entityManager->flush();
  219.             return $this->redirectToRoute('business_contacts_index', [], Response::HTTP_SEE_OTHER);
  220.         }
  222.         return $this->renderForm('business_contacts/new.html.twig', [
  223.             'business_contact' => $businessContact,
  224.             'form' => $form,
  225.         ]);
  226.     }
  228.     /**
  229.      * @Route("/suggestion", name="business_contacts_suggestion", methods={"GET", "POST"})
  230.      */
  231.     public function suggestion(Request $request, BusinessContactsRepository $businessContactsRepository): Response
  232.     {
  233.         $businessContact = new BusinessContacts();
  234.         $form = $this->createForm(BusinessContactsType::class, $businessContact);
  235.         $form->handleRequest($request);
  237.         if ($form->isSubmitted() && $form->isValid()) {
  238.             $businessContactsRepository->add($businessContact, true);
  239.             $businessContact->setStatus('Pending');
  241.             return $this->redirectToRoute('business_contacts_index', [], Response::HTTP_SEE_OTHER);
  242.         }
  244.         return $this->renderForm('business_contacts/new.html.twig', [
  245.             'business_contact' => $businessContact,
  246.             'form' => $form,
  247.         ]);
  248.     }
  250.     /**
  251.      * @Route("/show/{id}", name="business_contacts_show", methods={"GET"})
  252.      */
  253.     public function show(BusinessContacts $businessContact): Response
  254.     {
  255.         $longitude = $businessContact->getLocationLongitude();
  256.         $latitude = $businessContact->getLocationLatitude();
  257.         return $this->render('business_contacts/show.html.twig', [
  258.             'business_contact' => $businessContact,
  259.             'longitude' => $longitude,
  260.             'latitude' => $latitude,
  261.         ]);
  262.     }
  264.     /**
  265.      * @Route("/edit/{id}", name="business_contacts_edit", methods={"GET", "POST"})
  266.      */
  267.     public function edit(Request $request, BusinessContacts $businessContact, BusinessContactsRepository $businessContactsRepository): Response
  268.     {
  269.         $form = $this->createForm(BusinessContactsType::class, $businessContact);
  270.         $form->handleRequest($request);
  272.         if ($form->isSubmitted() && $form->isValid()) {
  273.             $photo = $form['photo']->getData();
  274.             if ($photo) {
  275.                 $files_name = [];
  276.                 $photo_directory = $this->getParameter('business_contacts_photos_directory');
  277.                 $fileName = pathinfo($photo->getClientOriginalName(), PATHINFO_FILENAME);
  278.                 $file_extension = $photo->guessExtension();
  279.                 if ($businessContact->getFirstName() == '') {
  280.                     $newFileName = $businessContact->getCompany() . "." . $file_extension;
  281.                 } else {
  282.                     $newFileName = $businessContact->getCompany() . "_" . $businessContact->getFirstName() . "_" . $businessContact->getLastName() . "." . $file_extension;
  283.                 }
  285.                 $photo->move($photo_directory, $newFileName);
  286.                 $businessContact->setPhoto($newFileName);
  287.             }
  289.             $file = $form['files']->getData();
  290.             if ($file) {
  291.                 $file_name = [];
  292.                 $file_directory = $this->getParameter('business_contacts_attachments_directory');
  293.                 $fileName = pathinfo($file->getClientOriginalName(), PATHINFO_FILENAME);
  294.                 $file_extension = $file->guessExtension();
  295.                 $newFileName = $fileName . "." . $file_extension;
  296.                 $file->move($file_directory, $newFileName);
  297.                 $businessContact->setFiles($newFileName);
  298.             }
  300.             $businessContactsRepository->add($businessContact, true);
  302.             return $this->redirectToRoute('business_contacts_index', [], Response::HTTP_SEE_OTHER);
  303.         }
  305.         return $this->renderForm('business_contacts/edit.html.twig', [
  306.             'business_contact' => $businessContact,
  307.             'form' => $form,
  308.         ]);
  309.     }
  311.     /**
  312.      * @Route("/delete/{id}", name="business_contacts_delete", methods={"POST"})
  313.      */
  314.     public function delete(Request $request, BusinessContacts $businessContact, BusinessContactsRepository $businessContactsRepository, EntityManagerInterface $entityManager): Response
  315.     {
  316.         $referer = $request->headers->get('referer');
  317.         $file_name = $businessContact->getFiles();
  319.         if ($file_name) {
  320.             $file = $this->getParameter('business_contacts_attachments_directory') . $file_name;
  321.             if (file_exists($file)) {
  322.                 unlink($file);
  323.             }
  324.             $businessContact->setFiles('');
  325.             $entityManager->flush();
  326.         }
  328.         $photo_file_name = $businessContact->getPhoto();
  329.         if ($photo_file_name) {
  330.             $photo_file_name = $this->getParameter('business_contacts_photos_directory') . $photo_file_name;
  331.             if (file_exists($photo_file_name)) {
  332.                 unlink($photo_file_name);
  333.             }
  334.             $businessContact->setPhoto('');
  335.             $entityManager->flush();
  336.         }
  338.         if ($this->isCsrfTokenValid('delete' . $businessContact->getId(), $request->request->get('_token'))) {
  339.             $businessContactsRepository->remove($businessContact, true);
  340.         }
  341.         return $this->redirect($referer);
  342.     }
  344.     /**
  345.      * @Route("/delete_GPS_location/{id}", name="business_contacts_delete_GPS_location", methods={"GET","POST"})
  346.      */
  347.     public function deleteGPSLocation(Request $request, int $id, BusinessContactsRepository $businessContactsRepository, EntityManagerInterface $entityManager): Response {
  348.         $referer = $request->headers->get('referer');
  349.         $businessContact=$businessContactsRepository->find($id);
  350.         // Optional CSRF check
  351. //        if (!$this->isCsrfTokenValid('delete_gps' . $businessContact->getId(), $request->request->get('_token'))) {
  352. //            throw $this->createAccessDeniedException('Invalid CSRF token.');
  353. //        }
  355.         // Delete GPS coords
  356.         $businessContact->setLocationLatitude(null);
  357.         $businessContact->setLocationLongitude(null);
  358.         $entityManager->flush();
  360.         // Redirect back to the page user came from
  362.         return $this->redirect($referer ?: $this->generateUrl('business_contacts_index'));
  363.     }
  367.     /**
  368.      * @Route("/delete_all_GPS_locations", name="business_contacts_delete_all_GPS_locations")
  369.      */
  370.     public function deleteAllBusinessContactsGPSLocations(Request $request, BusinessContactsRepository $businessContactsRepository, EntityManagerInterface $entityManager): Response
  371.     {
  372.         $referer = $request->headers->get('referer');
  373.         $business_contacts = $businessContactsRepository->findAll();
  374.         foreach ($business_contacts as $business_contact) {
  375.             $business_contact->setLocationLongitude(null);
  376.             $business_contact->setLocationLatitude(null);
  377.             $entityManager->flush();
  378.         }
  379.         return $this->redirect($referer ?: $this->generateUrl('business_contacts_index'));
  380.     }
  385.     /**
  386.      * @Route("/delete_all", name="business_contacts_delete_all")
  387.      */
  388.     public function deleteAllBusinessContacts(BusinessContactsRepository $businessContactsRepository, EntityManagerInterface $entityManager): Response
  389.     {
  390.         $business_contacts = $businessContactsRepository->findAll();
  391.         foreach ($business_contacts as $business_contact) {
  392.             $entityManager->remove($business_contact);
  393.             $entityManager->flush();
  394.         }
  395.         return $this->redirectToRoute('business_contacts_index', [], Response::HTTP_SEE_OTHER);
  396.     }
  399.     /**
  400.      * @Route("/delete_photo_file/{id}", name="business_contact_delete_photo_file", methods={"POST", "GET"})
  401.      */
  402.     public function deleteBusinessContactPhotoFile(int $id, Request $request, BusinessContacts $businessContact, EntityManagerInterface $entityManager)
  403.     {
  404.         $referer = $request->headers->get('referer');
  405.         $photo_file_name = $businessContact->getPhoto();
  406.         if ($photo_file_name) {
  407.             $photo_file_name = $this->getParameter('business_contacts_photos_directory') . "/" . $photo_file_name;
  408.             if (file_exists($photo_file_name)) {
  409.                 unlink($photo_file_name);
  410.             }
  411.             $businessContact->setPhoto('');
  412.             $entityManager->flush();
  413.         }
  414.         return $this->redirect($referer);
  415.     }
  417.     /**
  418.      * @Route("/delete_attachment_file/{id}", name="business_contact_delete_attachment_file", methods={"POST", "GET"})
  419.      */
  420.     public function deleteBusinessContactAttachmentFile(int $id, Request $request, BusinessContacts $businessContact, EntityManagerInterface $entityManager)
  421.     {
  422.         $referer = $request->headers->get('referer');
  423.         $file_name = $businessContact->getFiles();
  424.         if ($file_name) {
  425.             $file = $this->getParameter('business_contacts_attachments_directory') . "/" . $file_name;
  426.             if (file_exists($file)) {
  427.                 unlink($file);
  428.             }
  429.             $businessContact->setFiles('');
  430.             $entityManager->flush();
  431.         }
  432.         return $this->redirect($referer);
  433.     }
  435.     /**
  436.      * @Route ("/view/photo/{id}", name="view_business_contact_photo")
  437.      */
  438.     public function viewBusinessContactPhoto(Request $request, $id, BusinessContactsRepository $businessContactsRepository)
  439.     {
  440.         $business_contact = $businessContactsRepository->find($id);
  441.         return $this->render('business_contacts/view_photo.html.twig', ['business_contact' => $business_contact]);
  442.     }
  445.     /**
  446.      * @Route ("/business_contacts_export", name="business_contacts_export" )
  447.      */
  448.     public function businessContactsExport(BusinessContactsRepository $businessContactsRepository)
  449.     {
  450.         $data = [];
  451.         $exported_date = new \DateTime('now');
  452.         $exported_date_formatted = $exported_date->format('d-M-Y');
  453.         $fileName = 'business_contacts_export_' . $exported_date_formatted . '.csv';
  455.         $count = 0;
  456.         $business_contact_list = $businessContactsRepository->findAll();
  457.         foreach ($business_contact_list as $business_contact) {
  458.             $concatenatedNotes = "Exported on: " . $exported_date_formatted;
  459.             $data[] = [
  460.                 "BusinessContacts",
  461.                 $business_contact->getStatus(),
  462.                 $business_contact->getBusinessOrPerson(),
  463.                 $business_contact->getBusinessType()->getBusinessType(),
  464.                 $business_contact->getCompany(),
  465.                 $business_contact->getFirstName(),
  467.                 $business_contact->getLastName(),
  468.                 $business_contact->getWebsite(),
  469.                 $business_contact->getEmail(),
  470.                 $business_contact->getLandline(),
  471.                 $business_contact->getMobile(),
  473.                 $business_contact->getAddressStreet(),
  474.                 $business_contact->getAddressCity(),
  475.                 $business_contact->getAddressCounty(),
  476.                 $business_contact->getAddressPostCode(),
  477.                 $business_contact->getAddressCountry(),
  479.                 $business_contact->getLocationLongitude(),
  480.                 $business_contact->getLocationLatitude(),
  481.                 $business_contact->getNotes()
  482.             ];
  483.         }
  484.         $spreadsheet = new Spreadsheet();
  485.         $sheet = $spreadsheet->getActiveSheet();
  486.         $sheet->setTitle('Business Contacts');
  487.         $sheet->getCell('A1')->setValue('Entity');
  488.         $sheet->getCell('B1')->setValue('Status');
  489.         $sheet->getCell('C1')->setValue('Business Or Person');
  490.         $sheet->getCell('D1')->setValue('Business Type');
  491.         $sheet->getCell('E1')->setValue('Company');
  492.         $sheet->getCell('F1')->setValue('First Name');
  494.         $sheet->getCell('G1')->setValue('Last Name');
  495.         $sheet->getCell('H1')->setValue('Web Page');
  496.         $sheet->getCell('I1')->setValue('E-mail');
  497.         $sheet->getCell('J1')->setValue('Business Phone');
  498.         $sheet->getCell('K1')->setValue('Mobile Phone');
  500.         $sheet->getCell('L1')->setValue('Business Street');
  501.         $sheet->getCell('M1')->setValue('Business City');
  502.         $sheet->getCell('N1')->setValue('Business County');
  503.         $sheet->getCell('O1')->setValue('Business Postal Code');
  504.         $sheet->getCell('P1')->setValue('Business Country/Region');
  506.         $sheet->getCell('Q1')->setValue('Location Longitude');
  507.         $sheet->getCell('R1')->setValue('Location Latitude');
  509.         $sheet->fromArray($data, null, 'A2', true);
  510.         $total_rows = $sheet->getHighestRow();
  511.         for ($i = 2; $i <= $total_rows; $i++) {
  512.             $cell = "L" . $i;
  513.             $sheet->getCell($cell)->getHyperlink()->setUrl("https://google.com");
  514.         }
  515.         $writer = new Csv($spreadsheet);
  516.         $response = new StreamedResponse(function () use ($writer) {
  517.             $writer->save('php://output');
  518.         });
  519.         $response->headers->set('Content-Type', 'application/vnd.ms-excel');
  520.         $response->headers->set('Content-Disposition', sprintf('attachment;filename="%s"', $fileName));
  521.         $response->headers->set('Cache-Control', 'max-age=0');
  522.         return $response;
  523.     }
  525.     /**
  526.      * @Route ("/export/business_contacts_outlook", name="business_contacts_export_for_outlook" )
  527.      */
  528.     public function businessContactsExportForOutlook(BusinessContactsRepository $businessContactsRepository)
  529.     {
  530.         $data = [];
  531.         $exported_date = new \DateTime('now');
  532.         $exported_date_formatted = $exported_date->format('d-M-Y');
  533.         $fileName = 'business_contacts_export_for_outlook_' . $exported_date_formatted . '.csv';
  535.         $count = 0;
  536.         $business_contact_list = $businessContactsRepository->findAll();
  537.         foreach ($business_contact_list as $business_contact) {
  538.             $concatenatedNotes = "Exported on: " . $exported_date_formatted;
  539.             $data[] = [
  540.                 $business_contact->getStatus(),
  541.                 $business_contact->getBusinessOrPerson(),
  542.                 $business_contact->getBusinessType()->getBusinessType(),
  543.                 $business_contact->getCompany(),
  544.                 $business_contact->getFirstName(),
  546.                 $business_contact->getLastName(),
  547.                 $business_contact->getWebsite(),
  548.                 $business_contact->getEmail(),
  549.                 $business_contact->getLandline(),
  550.                 $business_contact->getMobile(),
  552.                 $business_contact->getAddressStreet(),
  553.                 $business_contact->getAddressCity(),
  554.                 $business_contact->getAddressCounty(),
  555.                 $business_contact->getAddressPostCode(),
  556.                 $business_contact->getAddressCountry(),
  558.                 $business_contact->getLocationLongitude(),
  559.                 $business_contact->getLocationLatitude(),
  560.                 $concatenatedNotes,
  561.                 $business_contact->getId()
  562.             ];
  563.         }
  564.         $spreadsheet = new Spreadsheet();
  565.         $sheet = $spreadsheet->getActiveSheet();
  566.         $sheet->setTitle('Business Contacts');
  567.         $sheet->getCell('A1')->setValue('Status');
  568.         $sheet->getCell('B1')->setValue('Business Or Person');
  569.         $sheet->getCell('C1')->setValue('Business Type');
  570.         $sheet->getCell('D1')->setValue('Company');
  571.         $sheet->getCell('E1')->setValue('First Name');
  573.         $sheet->getCell('F1')->setValue('Last Name');
  574.         $sheet->getCell('G1')->setValue('Web Page');
  575.         $sheet->getCell('H1')->setValue('E-mail');
  576.         $sheet->getCell('I1')->setValue('Business Phone');
  577.         $sheet->getCell('J1')->setValue('Mobile Phone');
  579.         $sheet->getCell('K1')->setValue('Business Street');
  580.         $sheet->getCell('L1')->setValue('Business City');
  581.         $sheet->getCell('M1')->setValue('Business County');
  582.         $sheet->getCell('N1')->setValue('Business Postal Code');
  583.         $sheet->getCell('O1')->setValue('Business Country/Region');
  585.         $sheet->getCell('P1')->setValue('Location Longitude');
  586.         $sheet->getCell('Q1')->setValue('Location Latitude');
  587.         $sheet->getCell('R1')->setValue('Notes');
  588.         $sheet->getCell('S1')->setValue('Id');
  590.         $sheet->fromArray($data, null, 'A2', true);
  591.         $total_rows = $sheet->getHighestRow();
  592.         for ($i = 2; $i <= $total_rows; $i++) {
  593.             $cell = "L" . $i;
  594.             $sheet->getCell($cell)->getHyperlink()->setUrl("https://google.com");
  595.         }
  596.         $writer = new Csv($spreadsheet);
  597.         $response = new StreamedResponse(function () use ($writer) {
  598.             $writer->save('php://output');
  599.         });
  600.         $response->headers->set('Content-Type', 'application/vnd.ms-excel');
  601.         $response->headers->set('Content-Disposition', sprintf('attachment;filename="%s"', $fileName));
  602.         $response->headers->set('Cache-Control', 'max-age=0');
  603.         return $response;
  604.     }
  607.     /**
  608.      * @Route ("/business_contacts_import", name="business_contacts_import" )
  609.      */
  610.     public function businessContactsImport(Request $request, SluggerInterface $slugger, BusinessContactsRepository $businessContactsRepository, ImportBusinessContactsService $businessContactsImportService): Response
  611.     {
  612.         $form = $this->createForm(ImportType::class);
  613.         $form->handleRequest($request);
  614.         if ($form->isSubmitted() && $form->isValid()) {
  615.             $importFile = $form->get('File')->getData();
  616.             if ($importFile) {
  617.                 $originalFilename = pathinfo($importFile->getClientOriginalName(), PATHINFO_FILENAME);
  618.                 $safeFilename = $slugger->slug($originalFilename);
  619.                 $newFilename = $safeFilename . '.' . 'csv';
  620.                 try {
  621.                     $importFile->move(
  622.                         $this->getParameter('business_contacts_import_directory'),
  623.                         $newFilename
  624.                     );
  625.                 } catch (FileException $e) {
  626.                     die('Import failed');
  627.                 }
  628.                 $businessContactsImportService->importBusinessContacts($newFilename);
  629.                 return $this->redirectToRoute('business_contacts_index');
  630.             }
  631.         }
  632.         return $this->render('home/import.html.twig', [
  633.             'form' => $form->createView(),
  634.             'heading' => 'Business Contacts Import',
  635.         ]);
  636.     }
  639.     /**
  640.      * @Route("/create/Vcard/{id}", name="create_vcard")
  641.      */
  642.     public function createVcard(int $id, BusinessContactsRepository $businessContactsRepository)
  643.     {
  644.         $business_contact = $businessContactsRepository->find($id);
  645.         $vcard = new VCard();
  646.         $businessOrPerson = $business_contact->getBusinessOrPerson();
  647.         $business_type = $business_contact->getBusinessType()->getBusinessType();
  648.         $firstName = $business_contact->getFirstName();
  649.         $lastName = $business_contact->getLastName();
  650.         $mobile = $business_contact->getMobile();
  651.         $landline = $business_contact->getLandline();
  652.         $company = $business_contact->getCompany();
  653.         $website = $business_contact->getWebsite();
  654.         $addressStreet = $business_contact->getAddressStreet();
  655.         $addressCity = $business_contact->getAddressCity();
  656.         $addressPostCode = $business_contact->getAddressPostcode();
  657.         $addressCountry = $business_contact->getAddressCountry();
  658.         $longitude = $business_contact->getLocationLongitude();
  659.         $latitude = $business_contact->getLocationLatitude();
  660.         $notes = $business_contact->getNotes();
  662.         if ($businessOrPerson = "Business") {
  663.             $firstNameCard = $company;
  664.             $lastNameCard = $business_type;
  665.             $companyCard = [];
  666.         }
  668.         if ($businessOrPerson = "Person") {
  669.             $firstNameCard = $firstName;
  670.             $lastNameCard = $lastName;
  671.             $companyCard = $company;
  672.         }
  674.         $vcard->addName($lastNameCard, $firstNameCard);
  675.         $vcard->addEmail($business_contact->getEmail())
  676.             ->addPhoneNumber($landline, 'work')
  677.             ->addPhoneNumber($mobile, 'mobile')
  678.             ->addCompany($companyCard)
  679.             ->addURL($website)
  680.             ->addNote($notes)
  681.             ->addAddress($name = '', $extended = '', $street = $addressStreet, $city = $addressCity, $region = '', $zip = $addressPostCode, $country = $addressCountry, $type = 'WORK;POSTAL');
  682.         $vcard->download();
  683.         return new Response(null);
  684.     }
  688.     /**
  689.      * @Route("/update/location", name="update_business_contact_location", methods={"POST"})
  690.      */
  691.     public function updateLocation(BusinessContactsRepository $businessContactsRepository, EntityManagerInterface $manager): Response
  692.     {
  693.         $id = $_POST['id'];
  694.         $latitude = $_POST['latitude'];
  695.         $longitude = $_POST['longitude'];
  696.         $gps = $latitude . ',' . $longitude;
  697.         $business_contact = $businessContactsRepository->find($id);
  698.         $business_contact->setLocationLongitude($longitude)
  699.             ->setLocationLatitude($latitude);
  700.         $manager->flush();
  701.         return new Response(null);
  702.     }
  704.     /**
  705.      * @Route("/gps_location_clear/{id}", name="business_contact_clear_gps_location")
  706.      */
  707.     public
  708.     function clearGPSLocation(Request $request, BusinessContacts $businessContacts, EntityManagerInterface $entityManager)
  709.     {
  710.         $referer = $request->headers->get('referer');
  711.         $businessContacts->setLocationLongitude(null);
  712.         $businessContacts->setLocationLatitude(null);
  713.         $entityManager->flush();
  714.         return $this->redirect($referer);
  715.     }
  718.     /**
  719.      * @Route("/show_attachment/{id}", name="business_contact_show_attachment")
  720.      */
  721.     public function showAttachmentBusinessContact(int $id, BusinessContactsRepository $businessContactsRepository)
  722.     {
  723.         $business_contact = $businessContactsRepository->find($id);
  724.         $filename = $business_contact->getFiles();
  725.         $filepath = $this->getParameter('business_contacts_attachments_directory') . "/" . $filename;
  726.         if (file_exists($filepath)) {
  727.             $response = new BinaryFileResponse($filepath);
  728.             $response->setContentDisposition(
  729.                 ResponseHeaderBag::DISPOSITION_INLINE, //use ResponseHeaderBag::DISPOSITION_ATTACHMENT to save as an attachment
  730.                 $filename
  731.             );
  732.             return $response;
  733.         } else {
  734.             return new Response("file does not exist");
  735.         }
  736.     }
  737. }