src/Controller/Frontend/FrontendController.php line 834

  1. <?php
  2. namespace App\Controller\Frontend;
  4. use App\Traits\UrlTrait;
  5. use ReCaptcha\ReCaptcha;
  6. use Symfony\Component\Mime\Address;
  7. use Doctrine\ORM\EntityManagerInterface;
  8. use Doctrine\ORM\Query\ResultSetMapping;
  9. use Webbamboo\SpinnersCommon\Entity\City;
  10. use Webbamboo\SpinnersCommon\Entity\Page;
  11. use Symfony\Bridge\Twig\Mime\TemplatedEmail;
  12. use Webbamboo\SpinnersCommon\Entity\Article;
  13. use Webbamboo\SpinnersCommon\Entity\Company;
  14. use Symfony\Component\HttpFoundation\Request;
  15. use Symfony\Component\Mailer\MailerInterface;
  16. use Webbamboo\SpinnersCommon\Entity\Counties;
  17. use Symfony\Component\HttpFoundation\Response;
  18. use Symfony\Component\Routing\Annotation\Route;
  19. use Symfony\Component\HttpKernel\KernelInterface;
  20. use Webbamboo\SpinnersCommon\Entity\Allpagesmeta;
  21. use Symfony\Component\HttpFoundation\RequestStack;
  22. use Webbamboo\SpinnersCommon\Entity\Generalsettings;
  23. use Webbamboo\SpinnersCommon\Manager\RedirectManager;
  24. use Symfony\Component\Form\Extension\Core\Type\TextType;
  25. use Symfony\Component\Form\Extension\Core\Type\HiddenType;
  26. use Webbamboo\SpinnersCommon\Repository\ArticleRepository;
  27. use Symfony\Component\Form\Extension\Core\Type\TextareaType;
  28. use Symfony\Component\HttpFoundation\Session\SessionInterface;
  29. use Symfony\Component\Security\Csrf\CsrfTokenManagerInterface;
  30. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  32. class FrontendController extends AbstractController
  33. {
  34.     use UrlTrait;
  36.     protected EntityManagerInterface $em;
  37.     protected SessionInterface $session;
  38.     protected MailerInterface $mailer;
  39.     protected CsrfTokenManagerInterface $csrfTokenManager;
  40.     protected ArticleRepository $articleRepository;
  42.     public function __construct(
  43.         EntityManagerInterface $em, 
  44.         RequestStack $requestStack, 
  45.         MailerInterface $mailer,
  46.         CsrfTokenManagerInterface $csrfTokenManager,
  47.         ArticleRepository $articleRepository
  48.     )
  49.     {
  50.         $this->em = $em;    
  51.         $this->session = $requestStack->getSession();
  52.         $this->mailer = $mailer;
  53.         $this->csrfTokenManager = $csrfTokenManager;
  54.         $this->articleRepository = $articleRepository;
  55.     }
  56.     
  57.     protected $contactForm = null;
  58.     protected $fields = array(
  59.         'name' => 'Namn',
  60.         'email' => 'Email',
  61.         'recaptcha' => 'ReCaptcha'
  62.     );
  63.     protected $submittedData = array();
  64.     protected $articlesDefaults = null;
  66.     private function constructForm(Request $request)
  67.     {
  68.         $session = $request->getSession();
  69.         $data = $session->get('form-data') ? $session->get('form-data') : $this->submittedData;
  70.         $errors = $session->get('form-errors') ? $session->get('form-errors') : array();
  71.         $token = $this->csrfTokenManager->getToken('form_csrf');
  73.         $form = $this->createFormBuilder($data)
  74.             ->add('name', TextType::class, array('required' => false, 'attr' => array('class' => in_array('Namn', $errors) ? 'form-control input-sm req-error' : 'form-control input-sm')))
  75.             ->add('email', TextType::class, array('required' => false, 'attr' => array('class' => in_array('Email', $errors) ? 'form-control input-sm req-error' : 'form-control input-sm')))
  76.             ->add('emailConfirmation', TextType::class, array('required' => false, 'attr' => array('class' => in_array('Email', $errors) ? 'form-control input-sm req-error' : 'form-control input-sm')))
  77.             ->add('date', TextType::class, array('required' => false, 'attr' => array('class' => in_array('Datum', $errors) ? 'form-control input-sm req-error' : 'form-control input-sm')))
  78.             ->add('sqfeet', TextType::class, array('required' => false, 'attr' => array('class' => in_array('Meter', $errors) ? 'form-control input-sm req-error' : 'form-control input-sm')))
  79.             ->add('zip', TextType::class, array('required' => false, 'attr' => array('class' => in_array('Postnr', $errors) ? 'form-control input-sm req-error zipSelect2' : 'form-control input-sm zipSelect2')))
  80.             ->add('other', TextareaType::class, array('required' => false))
  81.             ->add('token', HiddenType::class, array('data' => $token))
  82.             ->add('route', HiddenType::class)
  83.             ->add('routeparams', HiddenType::class)
  84.             ->add('siteVersion', HiddenType::class)
  85.             ->getForm();
  86.         $this->contactForm = $form;
  87.         $session->set('form-errors', array());
  88.     }
  89.     private function getFormView(Request $request)
  90.     {
  91.         if (is_null($this->contactForm)) {
  92.             $this->constructForm($request);
  93.         }
  94.         return $this->contactForm->createView();
  95.     }
  96.     private function getForm(Request $request)
  97.     {
  98.         if (is_null($this->contactForm)) {
  99.             $this->constructForm($request);
  100.         }
  101.         return $this->contactForm;
  102.     }
  104.     private function validateEmail($email)
  105.     {
  106.         $email = str_replace(" ", "", $email);
  107.         if (
  108.             filter_var($email, FILTER_VALIDATE_EMAIL) && 
  109.             strpos($email, "mail.ru") === false &&
  110.             strpos($email, "enersets") === false &&
  111.             strpos($email, "avalins") === false &&
  112.             strpos($email, "efastes") === false &&
  113.             strpos($email, "eric.jones.z.mail@gmail.com") === false
  114.         ) {
  115.             return true;
  116.         } else {
  117.             return false;
  118.         }
  119.     }
  121.     private function isSpamBody($string) 
  122.     {
  123.         $lowercasedContent = strtolower($string);
  125.         $dictionary = ['viagra'];
  126.         $isInSpamDictionary = function() use($dictionary, $lowercasedContent) {
  127.             foreach($dictionary as $word)
  128.             {
  129.                 if(strpos($lowercasedContent, $word) !== false)
  130.                 {
  131.                     return true;
  132.                 }
  133.             }
  134.             return false;
  135.         };
  136.         $contains_cyrillic = (bool) preg_match('/[\p{Cyrillic}]/u', $lowercasedContent);
  137.         if($isInSpamDictionary() || $contains_cyrillic)
  138.         {
  139.             return true;
  140.         }
  141.         return false;
  142.     }
  144.     private function getErrorMessages($data = array())
  145.     {
  146.         //Run basic spam filtering
  147.         $fields = $this->fields;
  148.         $errors = array();
  149.         foreach($data as $key => $value)
  150.         {
  151.             if(strpos($value, '>>>_') !== false)
  152.             {
  153.                 $errors[] = 'Spam';
  154.             } elseif ($key == 'other') {
  155.                 if ($this->isSpamBody($value)) {
  156.                     $errors[] = 'Spam';
  157.                 }
  158.             }
  159.         }
  161.         //Validate required fields
  162.         foreach ($fields as $name => $string) {
  163.             if ($name == 'email') {
  164.                 if (!$this->validateEmail($data['email']) || $data['email'] !== $data['emailConfirmation']) {
  165.                     $errors[] = $string;
  166.                 }
  167.             } else {
  168.                 if (is_null($data[$name])) {
  169.                     $errors[] = $string;
  170.                 }
  171.             }
  172.         }
  173.         return array_unique($errors);
  174.     }
  175.     private function afterSuccessfulSubmit($data, $sourceUrl, $ip, $userAgent)
  176.     {
  177.         $noSpaceMail = str_replace(" ", "", $data['email']);
  178.         $url = 'https://stat.webbamboo.net/item';
  179.         $data = array(
  180.             'target' => $sourceUrl,
  181.             'name' => $data["name"],
  182.             'email' => $noSpaceMail,
  183.             'data' => $data,
  184.             'ip' => $ip,
  185.             'user_agent' => $userAgent
  186.         );
  188.         // use key 'http' even if you send the request to https://...
  189.         $options = array(
  190.             'http' => array(
  191.                 'header'  => "Content-type: application/x-www-form-urlencoded\r\n",
  192.                 'method'  => 'POST',
  193.                 'content' => http_build_query($data)
  194.             )
  195.         );
  196.         $context  = stream_context_create($options);
  197.         $result = file_get_contents($url, false, $context);
  198.     }
  199.     private function sendConfirmation($data)
  200.     {
  201.         $fromEmail = "kundtjanst@flyttstadning-direkt.se";
  202.         $formName = "www.Flyttstadning-Direkt.se";
  203.         $subject = "Tack för att du har kontaktat Flyttstadning-Direkt kundservice";
  205.         $email = (new TemplatedEmail())
  206.             ->from(new Address($fromEmail, $formName))
  207.             ->to(new Address($data['email'], $data['name']))
  208.             ->subject($subject)
  210.             // path of the Twig template to render
  211.             ->htmlTemplate('Frontend/confirmation.email.twig')
  213.             // pass variables (name => value) to the template
  214.             ->context([
  215.                 'data' => $data,
  216.                 'subject' => $subject
  217.             ])
  218.         ;
  219.         $email->getHeaders()->addTextHeader('X-MC-ReturnPathDomain', 'return-path.flyttstadning-direkt.se');
  220.         $this->mailer->send($email);
  221.     }
  223.     #[Route("/form/parse", name: 'spinner_form_parse', methods: ['POST'])]
  224.     public function parseformAction(Request $request)
  225.     {
  226.         $this->constructForm($request);
  227.         $form = $this->contactForm;
  228.         $session = $request->getSession();
  230.         if ($request->isMethod('POST')) {
  231.             $form->handleRequest($request);
  232.             $data = $form->getData();
  233.             $noSpaceMail = str_replace(" ", "", $data['email']);
  234.             //var_dump($this->get('request')->request->get('g-recaptcha-response'));die();
  235.             $recaptchaResponse = $request->request->get('g-recaptcha-response');
  236.             $recaptcha = new ReCaptcha('6LekmfwSAAAAAEczRJjfsornV2iFtgANNFocb7LV');
  237.             $resp = $recaptcha->verify($recaptchaResponse);
  238.             if ($resp->isSuccess()) {
  239.                 // verified!
  240.                 $data['recaptcha'] = 'ReCaptcha';
  241.             } else {
  242.                 $data['recaptcha'] = null;
  243.                 //var_dump($errors = $resp->getErrorCodes());die();
  244.             }
  246.             $routeParameters = array();
  247.             parse_str($data['routeparams'], $routeParameters);
  249.             $errors = $this->getErrorMessages($data);
  250.             if (empty($errors)) {
  251.                 $url = array(
  252.                     "%C3%85", "%C3%A5",
  253.                     "%C3%84", "%C3%A4",
  254.                     "%C3%96", "%C3%B6",
  255.                 );
  256.                 $char = array(
  257.                     "Å", "å",
  258.                     "Ä", "ä",
  259.                     "Ö", "ö",
  260.                 );
  261.                 $currentUrl = 'http://flyttstadning-direkt.se' . str_replace($url, $char, $this->generateUrl($data['route'], $routeParameters)) . '#contactForm';
  262.                 
  263.                 $cleanZip = trim(str_replace(" ", "", $data['zip']));
  264.                 $subject = 'Offert - Flyttstädning: '.$data['name'].' - '.intval($cleanZip).' ()';
  265.                 
  266.                 $email = (new TemplatedEmail())
  267.                     ->from(new Address('form@flyttstadning-direkt.se', 'Flyttstadning-Direkt.se'))
  268.                     ->to('smoth3r3d@gmail.com', 'mats@alyhr.se', 'lokedesu@gmail.com', 'oskar@alyhr.se')
  269.                     ->replyTo(new Address($noSpaceMail, $data['name']))
  270.                     ->subject($subject)
  272.                     // path of the Twig template to render
  273.                     ->htmlTemplate('Frontend/email.html.twig')
  275.                     // pass variables (name => value) to the template
  276.                     ->context([
  277.                         'data' => $data,
  278.                         'url' => $currentUrl,
  279.                         'ip' => $request->getClientIp(),
  280.                         'subject' => $subject
  281.                     ])
  282.                 ;
  283.                 $email->getHeaders()->addTextHeader('X-MC-ReturnPathDomain', 'return-path.flyttstadning-direkt.se');
  284.                 $this->mailer->send($email);
  285.                 //Success message in Flashbag
  286.                 //
  287.                 
  288.                 $session->set('form-errors', array());
  289.                 $session->set('form-data', array());
  290.                 $succString = 'Flyttstadning Direkt tackar dig för ditt intresse!';
  291.                 $this->addFlash('form-success', $succString);
  292.                 try
  293.                 {
  294.                     $this->afterSuccessfulSubmit($data, $currentUrl, $request->getClientIp(), $request->headers->get('User-Agent'));
  295.                     $this->sendConfirmation($data);
  296.                 } catch (\Exception $ex) {
  298.                 }
  299.             } else {
  300.                 $session->set('form-errors', $errors);
  301.                 $session->set('form-data', $data);
  302.                 //Error messages in Flashbag
  303.                 $errString = 'Vänligen fyll i dom obligatoriska fälten: ' . implode(', ', $errors);
  304.                 $this->addFlash('form-error', $errString);
  305.             }
  306.             //Render the controller
  307.             switch ($data['route']) {
  308.                 case 'spinner_front_city':
  309.                     $countypermalink = $routeParameters['countypermalink'];
  310.                     $citypermalink = $routeParameters['citypermalink'];
  311.                     return $this->redirect($this->generateUrl('spinner_front_city', array(
  312.                                         'citypermalink' => $citypermalink,
  313.                                         'countypermalink' => $countypermalink
  314.                                     )) . '#contactForm');
  315.                     break;
  316.                 case 'spinner_front_county':
  317.                     $countypermalink = $routeParameters['countypermalink'];
  318.                     return $this->redirect($this->generateUrl('spinner_front_county', array(
  319.                                         'countypermalink' => $countypermalink
  320.                                     )) . '#contactForm');
  321.                     break;
  322.                 case 'spinner_front_company':
  323.                     $citypermalink = $routeParameters['citypermalink'];
  324.                     $companypermalink = $routeParameters['companypermalink'];
  325.                     return $this->redirect($this->generateUrl('spinner_front_company', array(
  326.                                         'citypermalink' => $citypermalink,
  327.                                         'companypermalink' => $companypermalink
  328.                                     )) . '#contactForm');
  329.                     break;
  330.                 case 'spinner_front_index':
  331.                     return $this->redirect($this->generateUrl('spinner_front_index', array()) . '#contactForm');
  332.                     break;
  333.                 case 'spinner_front_pages':
  334.                     $pagepermalink = $routeParameters['pagepermalink'];
  335.                     return $this->redirect($this->generateUrl('spinner_front_pages', array('pagepermalink' => $pagepermalink)) . '#contactForm');
  336.                     break;
  337.                 case 'spinner_front_articles_single':
  338.                     return $this->redirect($this->generateUrl('spinner_front_articles_single', array('articlepermalink' => $routeParameters['articlepermalink'])) . '#contactForm');
  339.                     break;
  340.             }
  341.         }
  342.     }
  343.     //Common functions
  344.     private function distance($lat1, $lon1, $lat2, $lon2, $unit)
  345.     {
  346.         $theta = $lon1 - $lon2;
  347.         $dist = sin(deg2rad($lat1)) * sin(deg2rad($lat2)) +  cos(deg2rad($lat1)) * cos(deg2rad($lat2)) * cos(deg2rad($theta));
  348.         $dist = acos($dist);
  349.         $dist = rad2deg($dist);
  350.         $miles = $dist * 60 * 1.1515;
  351.         $unit = strtoupper($unit);
  353.         if ($unit == "K") {
  354.             return ($miles * 1.609344);
  355.         } elseif ($unit == "N") {
  356.             return ($miles * 0.8684);
  357.         } else {
  358.             return $miles;
  359.         }
  360.     }
  362.     private function generatePermalink($text)
  363.     {
  364.         $t = strtolower($text);
  365.         $url=array(
  366.             "%C3%85","%C3%A5",
  367.             "%C3%84","%C3%A4",
  368.             "%C3%96","%C3%B6",
  369.             "%E9","%E9"
  370.         );
  371.         $char=array(
  372.             "Å","å",
  373.             "Ä","ä",
  374.             "Ö","ö",
  375.             "é","é"
  376.         );
  378.         $str = str_replace($char, $url, $t);
  379.         $str_new = str_replace(array(" ", ","), "", $str);
  380.         return $str_new;
  381.     }
  383.     private function getMenuHeading()
  384.     {
  385.         return $this->em->getRepository(Generalsettings::class)->findOneBySetting('MenuHeading');
  386.     }
  387.     private function getAnalytics()
  388.     {
  389.         $AnalyticsCode = $this->em->getRepository(Generalsettings::class)->findOneBySetting('Analytics');
  390.         return str_replace(array('<p>', '</p>', '<br />'), '', html_entity_decode($AnalyticsCode->getValueSanitized()));
  391.     }
  392.     private function getFormLabels()
  393.     {
  394.         $formData = $this->em->getRepository(Generalsettings::class)->findOneBySetting('formData');
  395.         return unserialize($formData->getValue());
  396.     }
  397.     private function getCounties()
  398.     {
  399.         return $this->em->getRepository(Counties::class)->findAll();
  400.     }
  401.     private function getPages()
  402.     {
  403.         return $this->em->getRepository(Page::class)->findAll();
  404.     }
  405.     private function getHeaderAlt()
  406.     {
  407.         $HeaderAltObj = $this->em->getRepository(Generalsettings::class)->findOneBySetting('HeaderAlt');
  408.         return str_replace(array('<p>', '</p>', '<br />'), '', html_entity_decode($HeaderAltObj->getValue()));
  409.     }
  410.     private function getCities($cid)
  411.     {
  412.         $query = $this->em->createQuery("SELECT c FROM Webbamboo\SpinnersCommon\Entity\City c WHERE c.county = $cid ORDER BY c.name ASC");
  413.         return $query->getResult();
  414.     }
  416.     private function getMostPopulatedCities($county)
  417.     {
  418.         $cid = $county->getId();
  419.         $query = $this->em->createQuery("SELECT c FROM Webbamboo\SpinnersCommon\Entity\City c WHERE c.county = $cid ORDER BY c.population DESC")->setMaxResults(10);
  420.         return $query->getResult();
  421.     }
  422.     private function getClosestCities($city)
  423.     {
  424.         $ID = $city->getId();
  425.         //var_dump($ID, $city->getName());die();
  426.         $latitude = $city->getLatitude();
  427.         $longitude = $city->getLongitude();
  428.         $cityResponse = array();
  430.         $limit = 5;
  431.         ///Do the dew
  432.         $rsm = new ResultSetMapping();
  433.         // build rsm here
  434.         $sqlT = "SELECT *, latitude, longitude, SQRT( POW(69.1 * (latitude - :lat), 2) + POW(69.1 * (:lon - longitude) * COS(latitude / 57.3), 2)) AS distance FROM City WHERE id != $ID ORDER BY distance LIMIT 0, $limit";
  435.         $params = array(
  436.             'lat' => $latitude,
  437.             'lon' => $longitude,
  438.         );
  440.         $stmt = $this->em->getConnection()->prepare($sqlT);
  442.         if (version_compare(phpversion(), '7.3', '<')) {
  443.             $result = $stmt->executeQuery($params);
  444.             
  445.             $citiesDistant = $result->fetchAllAssociative();    
  446.         }
  447.         else
  448.         {
  449.             $result = $stmt->executeQuery($params);
  450.             $citiesDistant = $result->fetchAllAssociative();
  451.         }
  452.         foreach ($citiesDistant as $city) {
  453.             $objectCity = $this->em->getRepository(City::class)->findOneById($city['id']);
  454.             $cityResponse[] = $objectCity;
  455.         }
  456.         return $cityResponse;
  457.     }
  458.     private function getCompanyResponse($city)
  459.     {
  460.         $companies = $city->getCompanies();
  461.         $latitude = $city->getLatitude();
  462.         $longitude = $city->getLongitude();
  463.         $companyResponse = array();
  464.         if (count($companies) < 20) {
  465.             $limit = 20;
  466.             ///Do the dew
  467.             $rsm = new ResultSetMapping();
  468.             // build rsm here
  469.             $sqlT = "SELECT *, latitude, longitude, SQRT( POW(69.1 * (latitude - :lat), 2) + POW(69.1 * (:lon - longitude) * COS(latitude / 57.3), 2)) AS distance FROM Company ORDER BY distance LIMIT 0, $limit";
  470.             $params = array(
  471.                 'lat' => $latitude,
  472.                 'lon' => $longitude,
  473.             );
  475.             $stmt = $this->em->getConnection()->prepare($sqlT);
  476.             if (version_compare(phpversion(), '7.3', '<')) {
  477.                 $result = $stmt->executeQuery($params);
  478.                 $companiesDistant = $result->fetchAllAssociative();    
  479.             }
  480.             else
  481.             {
  482.                 $result = $stmt->executeQuery($params);
  483.                 $companiesDistant = $result->fetchAllAssociative();
  484.             }
  485.         }
  487.         foreach ($companies as $company) {
  488.             $ccity = $company->getCityobj();
  489.             $c = array();
  490.             $c['id'] = $company->getId();
  491.             $c['name'] = $company->getName();
  492.             $c['phone'] = $company->getPhone();
  493.             $c['street'] = $company->getStreet();
  494.             $c['zip'] = $company->getZip();
  495.             $c['cityname'] = $ccity->getName();
  496.             //$c['distance'] = round($this->distance($company->getLatitude(), $company->getLongitude(), $city->getLatitude(), $city->getLongitude(), 'K'), 0);
  497.             $c['distance'] = '';
  498.             $c['permalink'] = $company->getPermalinkP();
  499.             $c['citypermalink'] = $ccity->getPermalinkP();
  500.             $c['countypermalink'] = $ccity->getCounty()->getPermalinkP();
  501.             $c['description'] = $company->getDescription();
  503.             //echo '<pre>';
  504.             //var_dump($c['name'], $company->getLatitude(), $company->getLongitude(), $city->getLatitude(), $city->getLongitude(),$this->distance($company->getLatitude(), $company->getLongitude(), $city->getLatitude(), $city->getLongitude(), 'K'));
  505.             $companyResponse[$company->getName()] = $c;
  506.         }
  507.         //Simupate getPermalinkP
  508.         $url=array(
  509.         "%C3%85","%C3%A5",
  510.         "%C3%84","%C3%A4",
  511.         "%C3%96","%C3%B6",
  513.         );
  514.         $char=array(
  515.          "Å","å",
  516.          "Ä","ä",
  517.          "Ö","ö",
  518.         );
  519.         if (isset($companiesDistant)) {
  520.             foreach ($companiesDistant as $company) {
  521.                 //var_dump($company['cityobj_id']);
  522.                 if (!is_null($company['cityobj_id'])) {
  523.                     $ccity = $this->em->getRepository(City::class)->findOneById($company['cityobj_id']);
  524.                     $c = array();
  525.                     $c['id'] = (int)$company['id'];
  526.                     $c['name'] = $company['name'];
  527.                     $c['phone'] = $company['phone'];
  528.                     $c['street'] = $company['street'];
  529.                     $c['zip'] = $company['zip'];
  530.                     $c['cityname'] = $ccity->getName();
  531.                     $c['distance'] = round($this->distance($company['latitude'], $company['longitude'], $city->getLatitude(), $city->getLongitude(), 'K'), 0);
  532.                     $c['permalink'] = str_replace($url, $char, $company['permalink']);
  533.                     $c['citypermalink'] =  $ccity->getPermalinkP();
  534.                     $c['countypermalink'] = $ccity->getCounty()->getPermalinkP();
  535.                     $c['description'] = $company['description'] == 'none' ? '' : $company['description'];
  536.                     if (!isset($companyResponse[$company['name']]) && count($companyResponse) <= 20) {
  537.                         $companyResponse[$company['name']] = $c;
  538.                     }
  539.                 }
  540.             }
  541.         }
  542.         return $companyResponse;
  543.     }
  544.     private function getCurrentCounty($countypermalink)
  545.     {
  546.         return $this->em->getRepository(Counties::class)->findOneByPermalink($this->generatePermalink(strtolower($countypermalink)));
  547.     }
  548.     private function getCurrentCity($citypermalink, $county)
  549.     {
  550.         //with join maybe
  551.         $query = $this->em->getRepository(City::class)->createQueryBuilder('c')
  552.             ->innerJoin('c.county', 'co')
  553.             ->where('co.id = :countyId')
  554.             ->andWhere('c.permalink = :permalink')
  555.             ->setParameters(array(
  556.                 'countyId' => $county->getId(),
  557.                 'permalink' => $this->generatePermalink(strtolower(str_replace(array("Å","Ä","Ö"), array("å","ä","ö",), $citypermalink))),
  558.             ))
  559.             ->getQuery();
  560.         $city = $query->getResult();
  561.         return $city[0];
  563.         //return $this->em->getRepository('SpinnerBundle:City')->findOneByPermalink($this->generatePermalink(strtolower(str_replace(array("Å","Ä","Ö"),array("å","ä","ö",),$citypermalink))));
  564.     }
  565.     private function getCurrentPage($pagepermalink)
  566.     {
  567.         return $this->em->getRepository(Page::class)->findOneByPermalink($this->generatePermalink($pagepermalink));
  568.     }
  569.     private function getCurrentArticle($articlepermalink)
  570.     {
  571.         //var_dump($this->generatePermalink($articlepermalink));
  572.         return $this->em->getRepository(Article::class)->findOneByPermalink($articlepermalink);
  573.     }
  575.     private function getCurrentCompany($companypermalink)
  576.     {
  577.         return $this->em->getRepository(Company::class)->findOneByPermalink($this->generatePermalink(strtolower(str_replace(array("Å","Ä","Ö"), array("å","ä","ö",), $companypermalink))));
  578.     }
  580.     private function paginate($query)
  581.     {
  582.         $paginator = new \Doctrine\ORM\Tools\Pagination\Paginator($query, $fetchJoinCollection = false);
  584.         //$paginator
  585.         //    ->getQuery()
  586.         //    ->setFirstResult($pageSize * ($currentPage - 1)) // set the offset
  587.         //    ->setMaxResults($pageSize); // set the limit
  589.         return $paginator;
  590.     }
  591.     
  592.     private function getArticlesDefaults()
  593.     {
  594.         $settings = $this->em->getRepository('Webbamboo\SpinnersCommon\Entity\Articlesettings')->findAll();
  595.         $defaults = array();
  596.         foreach ($settings as $s) {
  597.             $defaults[$s->getSetting()] = $s->getValue();
  598.         }
  599.         return $defaults;
  600.     }
  602.     #[Route("/", name: 'spinner_front_index', methods: ['GET'], options: ['utf8' => true])]
  603.     public function indexAction(Request $request)
  604.     {
  605.         $h1 = $this->em->getRepository(Generalsettings::class)->findOneBySetting('H1Index');
  606.         $metatitle = $this->em->getRepository(Generalsettings::class)->findOneBySetting('MetaTitleIndex');
  607.         $metadescription = $this->em->getRepository(Generalsettings::class)->findOneBySetting('MetaDescriptionIndex');
  608.         $content = $this->em->getRepository(Generalsettings::class)->findOneBySetting('ContentIndex')->getValue();
  609.         $WTMeta = $this->em->getRepository(Generalsettings::class)->findOneBySetting('WebmasterToolsMeta');
  610.         $wt = str_replace(array('&lt;', '&gt;', '<p>', '</p>'), array('<', '>', '', ''), $WTMeta->getValue());
  613.         return $this->render(
  614.             'Frontend/index.html.twig',
  615.                 array(
  616.                     'menuHeading' => $this->getMenuHeading(),
  617.                     'counties' => $this->getCounties(),
  618.                     'h1' => $h1->getValue(),
  619.                     'metatitle' => $metatitle->getValue(),
  620.                     'metadescription' => $metadescription->getValue(),
  621.                     'content' => $content,
  622.                     'pages'   => $this->getPages(),
  623.                     'WTMeta'    => $wt,
  624.                     'Analytics'    => $this->getAnalytics(),
  625.                     'headerAlt'    => $this->getHeaderAlt(),
  626.                     'form'    => $this->getFormView($request),
  627.                     'formLabels' => $this->getFormLabels(),
  628.                     'defaults'      => $this->getArticlesDefaults(),
  629.                     )
  630.                 );
  631.     }
  633.     #[Route('/Flyttstädning-{countypermalink}', name: 'spinner_front_county', methods: ['GET'], options: ['utf8' => true])]
  634.     #[Route('/flyttstädning-{countypermalink}', name: 'spinner_front_county_lowercase', methods: ['GET'], options: ['utf8' => true])]
  635.     public function countyAction($countypermalink, Request $request)
  636.     {
  637.         return $this->render(
  638.             'Frontend/county.html.twig',
  639.             array(
  640.                 'counties' => $this->getCounties(),
  641.                 'activecounty' => $this->getCurrentCounty($countypermalink),
  642.                 'cities' => $this->getCities($this->getCurrentCounty($countypermalink)->getId()),
  643.                 'menuHeading' => $this->getMenuHeading(),
  644.                 'pages'   => $this->getPages(),
  645.                 'Analytics'    => $this->getAnalytics(),
  646.                 'headerAlt'    => $this->getHeaderAlt(),
  647.                 'form'    => $this->getFormView($request),
  648.                 'formLabels' => $this->getFormLabels(),
  649.                 'defaults'      => $this->getArticlesDefaults(),
  650.                 'mostpopulated' => $this->getMostPopulatedCities($this->getCurrentCounty($countypermalink))
  651.             )
  652.         );
  653.     }
  655.     #[Route('/Flyttstädning-{countypermalink}/Alla-orter', name: 'spinner_front_county_all', methods: ['GET'], options: ['utf8' => true], priority: 15)]
  656.     public function countyallAction($countypermalink, Request $request)
  657.     {
  658.         $currentCounty = $this->getCurrentCounty($countypermalink);
  659.         $data = $this->em->getRepository('Webbamboo\SpinnersCommon\Entity\Allcitiesmeta')->findOneByCountyid($currentCounty->getId());
  661.         return $this->render(
  662.             'Frontend/countyall.html.twig',
  663.             array(
  664.                 'counties' => $this->getCounties(),
  665.                 'data' => $data,
  666.                 'activecounty' => $currentCounty,
  667.                 'cities' => $this->getCities($currentCounty->getId()),
  668.                 'menuHeading' => $this->getMenuHeading(),
  669.                 'pages'   => $this->getPages(),
  670.                 'Analytics'    => $this->getAnalytics(),
  671.                 'headerAlt'    => $this->getHeaderAlt(),
  672.                 'form'    => $this->getFormView($request),
  673.                 'formLabels' => $this->getFormLabels(),
  674.                 'defaults'      => $this->getArticlesDefaults()
  675.             )
  676.         );
  677.     }
  679.     #[Route('/Flyttstädning-{countypermalink}/image/{imagename}', name: 'spinner_front_county_thumbnail', methods: ['GET'], options: ['utf8' => true])]
  680.     public function countythumbnailAction(Request $request, $countypermalink, $imagename, KernelInterface $appKernel)
  681.     {
  682.         $county = $this->getCurrentCounty($countypermalink);
  683.         if ($request->query->get('preview')) {
  684.             $manual = true;
  685.         } else {
  686.             $manual = $county->getManual();
  687.         }
  688.         $imagename = $manual ? $county->getManualThumbnail().'-thumbnail.png' : $county->getThumbnail()->getPath().'-thumbnail.png';
  689.         $imagepath = $appKernel->getProjectDir().'/public/county/'.$imagename;
  691.         $headers = array(
  692.             'Content-Type' => 'image/png',
  693.             'Content-Disposition' => 'inline; filename="'.$imagename.'"'
  694.         );
  695.         return new Response(file_get_contents($imagepath), 200, $headers);
  696.     }
  698.     #[Route('/Flyttstädning-{citypermalink}/{companypermalink}/image/{imagename}', name: 'spinner_front_company_thumbnail', methods: ['GET'], options: ['utf8' => true])]
  699.     public function companythumbnailAction(
  700.         Request $request, 
  701.         $citypermalink, 
  702.         $companypermalink, 
  703.         $imagename, 
  704.         KernelInterface $appKernel
  705.     )
  706.     {
  707.         $company = $this->getCurrentCompany($companypermalink, $citypermalink);
  708.         if ($request->query->get('preview')) {
  709.             $manual = true;
  710.         } else {
  711.             $manual = $company->getManual();
  712.         }
  713.         $imagename = $manual ? $company->getManualThumbnail().'-thumbnail.png' : $company->getThumbnail()->getPath().'-thumbnail.png';
  714.         $imagepath = $appKernel->getProjectDir().'/public/company/'.$imagename;
  716.         $headers = array(
  717.              'Content-Type' => 'image/png',
  718.              'Content-Disposition' => 'inline; filename="'.$imagename.'"'
  719.          );
  720.         return new Response(file_get_contents($imagepath), 200, $headers);
  721.     }
  723.     #[Route('/{countypermalink}/Flyttstädning-{citypermalink}', name: 'spinner_front_city', methods: ['GET'], options: ['utf8' => true])]
  724.     #[Route('/{countypermalink}/flyttstädning-{citypermalink}', name: 'spinner_front_city_lowercase', methods: ['GET'], options: ['utf8' => true])]
  725.     public function cityAction($countypermalink, $citypermalink, Request $request)
  726.     {
  727.         $currentCounty = $this->getCurrentCounty($countypermalink);
  728.         $currentCity = $this->getCurrentCity($citypermalink, $currentCounty);
  730.         $stickyCompany = $this->em->getRepository(Company::class)->findOneByName('FlyttstädningsAkuten AB');
  732.         return $this->render(
  733.             'Frontend/city.html.twig',
  734.             array(
  735.                 'menuHeading' => $this->getMenuHeading(),
  736.                 'counties' => $this->getCounties(),
  737.                 'activecounty' => $currentCounty,
  738.                 'city' => $currentCity,
  739.                 'companies' => $this->getCompanyResponse($currentCity),
  740.                 'pages'   => $this->getPages(),
  741.                 'Analytics'    => $this->getAnalytics(),
  742.                 'headerAlt'    => $this->getHeaderAlt(),
  743.                 'cities' => $this->getCities($currentCounty->getId()),
  744.                 'form'    => $this->getFormView($request),
  745.                 'formLabels' => $this->getFormLabels(),
  746.                 'defaults'      => $this->getArticlesDefaults(),
  747.                 'closestcities' => $this->getClosestCities($currentCity),
  748.                 'sticky' => $stickyCompany
  749.                 )
  750.             );
  751.     }
  753.     #[Route('/{countypermalink}/Flyttstädning-{citypermalink}/image/{imagename}', name: 'spinner_front_city_thumbnail', methods: ['GET'], options: ['utf8' => true])]
  754.     public function citythumbnailAction(
  755.         Request $request, 
  756.         $countypermalink, 
  757.         $citypermalink, 
  758.         $imagename,
  759.         KernelInterface $appKernel
  760.     )
  761.     {
  762.         $currentCounty = $this->getCurrentCounty($countypermalink);
  763.         $city = $this->getCurrentCity($citypermalink, $currentCounty);
  764.         if ($request->query->get('preview')) {
  765.             $manual = true;
  766.         } else {
  767.             $manual = $city->getManual();
  768.         }
  769.         $imagename = ( $manual && $city->getManualThumbnail() ) ? $city->getManualThumbnail().'-thumbnail.png' : $city->getThumbnail()->getPath().'-thumbnail.png';
  770.         $imagepath = $appKernel->getProjectDir().'/public/city/'.$imagename;
  772.         $headers = array(
  773.             'Content-Type' => 'image/png',
  774.             'Content-Disposition' => 'inline; filename="'.$imagename.'"'
  775.         );
  776.         return new Response(file_get_contents($imagepath), 200, $headers);
  777.     }
  779.     #[Route('/p/{pagepermalink}', name: 'spinner_front_pages', methods: ['GET'], options: ['utf8' => true], priority: 1)]
  780.     public function pageAction($pagepermalink, Request $request)
  781.     {
  782.         return $this->render(
  783.             'Frontend/page.html.twig',
  784.             array(
  785.                 'menuHeading' => $this->getMenuHeading(),
  786.                 'page' => $this->getCurrentPage($pagepermalink),
  787.                 'counties' => $this->getCounties(),
  788.                 'pages'   => $this->getPages(),
  789.                 'Analytics'    => $this->getAnalytics(),
  790.                 'headerAlt'    => $this->getHeaderAlt(),
  791.                 'form'    => $this->getFormView($request),
  792.                 'formLabels' => $this->getFormLabels(),
  793.                 'defaults'      => $this->getArticlesDefaults(),
  794.                 'isPage' => true
  795.                 )
  796.             );
  797.     }
  798.     private function getCompanyCity($latitude, $longitude, $citypermalink)
  799.     {
  800.         //var_dump($latitude, $longitude, $citypermalink);die();
  801.         $cityResponse = array();
  803.         $limit = 1;
  804.         ///Do the dew
  805.         $rsm = new ResultSetMapping();
  806.         // build rsm here
  807.         //var_dump($citypermalink, $latitude, $longitude);
  808.         $lowerPermalink = strtolower($citypermalink);
  809.         $sqlT = "SELECT *, latitude, longitude, SQRT( POW(69.1 * (latitude - :lat), 2) + POW(69.1 * (:lon - longitude) * COS(latitude / 57.3), 2)) AS distance FROM City WHERE permalink = :permalink OR permalink = :lower ORDER BY distance LIMIT 0, $limit";
  810.         $params = array(
  811.             'lat' => $latitude,
  812.             'lon' => $longitude,
  813.             'permalink' => $this->generatePermalink(str_replace(array("Å","Ä","Ö"), array("å","ä","ö",), $citypermalink)),
  814.             'lower' => $this->generatePermalink(strtolower(str_replace(array("Å","Ä","Ö"), array("å","ä","ö",), $citypermalink)))
  816.         );
  818.         $stmt = $this->em->getConnection()->prepare($sqlT);
  819.         if (version_compare(phpversion(), '7.3', '<')) {
  820.             $result = $stmt->executeQuery($params);
  821.             $citiesDistant = $result->fetchAllAssociative();    
  822.         }
  823.         else
  824.         {
  825.             $result = $stmt->executeQuery($params);
  826.             $citiesDistant = $result->fetchAllAssociative();
  827.         }
  828.         
  829.         $cityID = $citiesDistant[0]['id'];
  830.         return $this->em->getRepository(City::class)->findOneById($cityID);
  831.     }
  833.     #[Route('/Flyttstädning-{citypermalink}/{companypermalink}', name: 'spinner_front_company', methods: ['GET'], options: ['utf8' => true])]
  834.     public function companyAction(
  835.         $citypermalink, 
  836.         $companypermalink, 
  837.         Request $request,
  838.         RedirectManager $redirectManager
  839.     )
  840.     {
  841.         $company = $this->getCurrentCompany($companypermalink, $citypermalink);
  842.         if ($company->getCityobj()->getPermalink() == $this->generatePermalink(strtolower(str_replace(array("Å","Ä","Ö"), array("å","ä","ö",), $citypermalink)))) {
  843.             $currentCity = $company->getCityobj();
  844.         } else {
  845.             $currentCity = $this->getCompanyCity($company->getLatitude(), $company->getLongitude(), $citypermalink);
  846.         }
  848.         if ($redirectManager = $redirectManager->work($company->getId(), $currentCity->getId())) {
  849.             return $this->redirect($redirectManager, 301);
  850.         }
  851.         
  852.         //FlyttstädningsAkuten AB entry
  853.         $stickyCompany = $this->em->getRepository(Company::class)->findOneByName('FlyttstädningsAkuten AB');
  855.         return $this->render(
  856.             'Frontend/company.html.twig',
  857.             array(
  858.                 'menuHeading' => $this->getMenuHeading(),
  859.                 'counties' => $this->getCounties(),
  860.                 'activecounty' => $currentCity->getCounty(),
  861.                 'city' => $currentCity,
  862.                 'company' => $company,
  863.                 'pages'   => $this->getPages(),
  864.                 'Analytics'    => $this->getAnalytics(),
  865.                 'headerAlt'    => $this->getHeaderAlt(),
  866.                 'cities' => $this->getCities($currentCity->getCounty()->getId()),
  867.                 'form'    => $this->getFormView($request),
  868.                 'formLabels' => $this->getFormLabels(),
  869.                 'defaults'      => $this->getArticlesDefaults(),
  870.                 'closestcities' => $this->getClosestCities($currentCity),
  871.                 'sticky' => $stickyCompany
  872.                 )
  873.             );
  874.     }
  876.     #[Route('/a/', name: 'spinner_front_articles', methods: ['GET'], options: ['utf8' => true])]
  877.     #[Route('/a/page{pagenumber}', name: 'spinner_front_articles_pages', methods: ['GET'], options: ['utf8' => true])]
  878.     public function articlesloopAction($pagenumber=1)
  879.     {
  880.         $paginator = $this->articleRepository->findPaginated($pagenumber);
  881.         $metaData = $this->em->getRepository(Allpagesmeta::class)->findOneByPagenumber($pagenumber);
  882.         $defaults = $this->getArticlesDefaults();
  883.         if ($metaData) {
  884.             $metaDescription = $metaData->getMetadescription() ? $metaData->getMetadescription() : $defaults['MetaDescriptionArticlesLoop'];
  885.             $metaTitle = $metaData->getMetatitle() ? $metaData->getMetatitle() : $defaults['MetaTitleArticlesLoop'];
  886.         } else {
  887.             $metaDescription = $defaults['MetaDescriptionArticlesLoop'];
  888.             $metaTitle = $defaults['MetaTitleArticlesLoop'];
  889.         }
  891.         return $this->render(
  892.             'Frontend/articlesloop.html.twig',
  893.             array(
  894.                 'articles'  => $paginator->getIterator(),
  895.                 'totalItems'    => $paginator->count(),
  896.                 'pagesCount'    => ceil(count($paginator) / 20),
  897.                 'defaults'      => $defaults,
  898.                 'currentPage'   => $pagenumber,
  899.                 'counties' => $this->getCounties(),
  900.                 'pages'   => $this->getPages(),
  901.                 'Analytics'    => $this->getAnalytics(),
  902.                 'headerAlt'    => htmlentities($this->getHeaderAlt()),
  903.                 'metaDescription' => $metaDescription,
  904.                 'metaTitle' => $metaTitle
  905.             )
  906.         );
  907.     }
  909.     #[Route('/a/{articlepermalink}', name: 'spinner_front_articles_single', methods: ['GET'], options: ['utf8' => true])]
  910.     public function articleAction($articlepermalink, Request $request)
  911.     {
  912.         $article = $this->getCurrentArticle($articlepermalink);
  913.         if($article->getStatus() === Article::STATUS_DRAFT)
  914.         {
  915.             $this->denyAccessUnlessGranted('ROLE_ADMIN');
  916.         }
  917.         return $this->render(
  918.             'Frontend/page.html.twig',
  919.             array(
  920.                 'menuHeading' => $this->getMenuHeading(),
  921.                 'page' => $article,
  922.                 'counties' => $this->getCounties(),
  923.                 'pages'   => $this->getPages(),
  924.                 'Analytics'    => $this->getAnalytics(),
  925.                 'headerAlt'    => $this->getHeaderAlt(),
  926.                 'defaults'      => $this->getArticlesDefaults(),
  927.                 'isPage' => false,
  928.                 'form'    => $this->getFormView($request),
  929.                 'formLabels' => $this->getFormLabels()
  930.                 )
  931.             );
  932.     }
  933. }