src/Controller/Frontend/AjaxController.php line 336

  1. <?php
  2. namespace App\Controller\Frontend;
  4. use App\Lib\HolidayWrapper;
  5. use Webbamboo\SpinnerBundle\Entity\Zip;
  6. use Doctrine\ORM\EntityManagerInterface;
  7. use Webbamboo\SpinnersCommon\Entity\Company;
  8. use Symfony\Component\HttpFoundation\Request;
  9. use Symfony\Component\HttpFoundation\Response;
  10. use Symfony\Component\Routing\Annotation\Route;
  11. use Symfony\Component\HttpFoundation\JsonResponse;
  12. use Webbamboo\SpinnersCommon\Entity\Presubmission;
  13. use Webbamboo\SpinnersCommon\Repository\ZipRepository;
  14. use Webbamboo\SpinnersCommon\Repository\CityRepository;
  15. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  17. class AjaxController extends AbstractController
  18. {
  19.     protected EntityManagerInterface $em;
  20.     protected CityRepository $cityRepository;
  22.     public function __construct(
  23.         EntityManagerInterface $em,
  24.         CityRepository $cityRepository
  25.     )
  26.     {
  27.         $this->em = $em;        
  28.         $this->cityRepository = $cityRepository;
  29.     }
  31.     #[Route('/endpoints/presubmissions', name:"endpoints_presubmissions", methods:['GET'])]
  32.     public function presubmissionsAction(Request $request) 
  33.     {
  34.         $remoteIP = '178.79.154.17';
  35.         $remoteIP2 = '139.162.163.203';
  36.         if(
  37.             $request->getClientIp() === $remoteIP || 
  38.             $request->getClientIp() === '78.83.25.137' ||
  39.             $request->getClientIp() === $remoteIP2
  40.         )
  41.         {
  42.             $first = $request->query->get('first');
  43.             $presubmissions = $this->em->getRepository(Presubmission::class)
  44.                 ->createQueryBuilder('p')
  45.                 ->where('p.id > :id')->setParameter('id', $first)
  46.                 ->orderBy('p.id', 'ASC')->getQuery()->getResult();
  47.             $responseArray = [];
  48.             foreach($presubmissions as $presubmission)
  49.             {
  50.                 $responseArray[] = [
  51.                     'remote_id' => $presubmission->getId(),
  52.                     'content' => $presubmission->getContent(),
  53.                     'date' => $presubmission->getCreated()->format("Y-m-d H:i:s"),
  54.                     'ip' => $presubmission->getIp(),
  55.                     'siteVersion' => $presubmission->getSiteVersion(),
  56.                     'site_id' => 'FSD',
  57.                     'url' => $presubmission->getUrl()
  58.                 ];
  59.             }
  61.             return new JsonResponse($responseArray);
  62.         }
  63.         else
  64.         {
  65.             return new JsonResponse(['error' => 'FORBIDDEN']);
  66.         }
  68.     }
  69.     
  70.     #[Route('/ajax/zip', name:"ajax_zip", methods:['GET'])]
  71.     public function zipAction(Request $request, ZipRepository $zipRepository)
  72.     {
  73.         $results = $zipRepository->findByQuery($request->query->get('q'));
  75.         $formattedResults = function() use($results){
  76.             $response = [];
  77.             foreach($results as &$result)
  78.             {
  79.                 $response[] = [
  80.                     'zip' => $result->getZip(),
  81.                     'city' => $result->getCity(),
  82.                     'display' => $result->getZip().' '.$result->getCity()
  83.                 ];
  84.             }
  85.             return $response;
  86.         };
  87.         return new JsonResponse($formattedResults());
  88.     }
  90.     #[Route('/ajax/presubmission', name:"spinner_ajax_presubmission", methods:['GET'])]
  91.     public function createPresubmissionAction(Request $request)
  92.     {
  93.         $postParameters = $request->query->all();
  94.         $presubmission = new Presubmission();
  95.         $presubmission->setContent(print_r($postParameters, true));
  96.         $presubmission->setCreated(new \DateTime('now', new \DateTimeZone('Europe/Stockholm')));
  97.         $presubmission->setIp($request->getClientIp());
  98.         $presubmission->setUrl($request->query->get("url"));
  99.         $presubmission->setSiteVersion(isset($postParameters['form']['siteVersion']) ? $postParameters['form']['siteVersion'] : '');
  100.         
  101.         $this->em->persist($presubmission);
  102.         $this->em->flush();
  104.         return new JsonResponse(['success' => true]);
  105.     }
  107.     /*
  108.     Error codes:
  109.     400 - Bad request
  110.     */
  111.     public function sanitizepermalinkAction(Request $request)
  112.     {
  113.         if ($request->getMethod() == 'POST') {
  114.             $title = $request->request->get('title', '');
  115.             $response = new Response(json_encode(array('sanitized' => $this->generatePermalink($title))));
  116.         } else {
  117.             $response = new Response(json_encode(array('error' => '400')));
  118.         }
  119.         $response->headers->set('Content-Type', 'application/json');
  120.         return $response;
  121.     }
  123.     private function generatePermalink($text, $delimiter='-')
  124.     {
  125.         $t = strtolower($text);
  126.         $url=array(
  127.             "%C3%A5","%C3%A5",
  128.             "%C3%A4","%C3%A4",
  129.             "%C3%B6","%C3%B6",
  130.             "%26","-",
  131.             "", "",
  132.             "%E9", "",
  133.             "", ""
  134.         );
  135.         $char=array(
  136.             "Å","å",
  137.             "Ä","ä",
  138.             "Ö","ö",
  139.             "&amp;",":",
  140.             ".", "'",
  141.             "é", ",",
  142.             "(", ")"
  143.         );
  145.         $str = str_replace($char, $url, $t);
  147.         //$clean = preg_replace("/[^a-zA-Z0-9\/_|+ -]/", '', $str);
  148.         $clean = trim($str, '-');
  149.         $clean = preg_replace("/[\/_|+ -]+/", $delimiter, $clean);
  151.         return $clean;
  152.     }
  154.     #[Route('/ajax/querycity', name:"spinner_ajax_autocomplete", methods: ['GET'])]
  155.     public function querycityAction(Request $request)
  156.     {
  157.         $cityName = $this->mb_ucfirst($request->query->get('name'));
  158.         if ($cityName && !empty($cityName)) {
  159.             $response = array();
  160.             $query = $this->cityRepository->createQueryBuilder('c')
  161.                    ->where('c.name LIKE :name')
  162.                    ->setParameter('name', $cityName.'%')
  163.                    ->getQuery();
  164.             $result = $query->getResult();
  165.             $duplicates = $this->getDuplicates($result);
  166.             foreach ($result as $city) {
  167.                 $data = array();
  168.                 $name = isset($duplicates[$city->getName()]) ? $this->mb_ucfirst($city->getName()).'( '.$city->getCounty()->getName().' län )' : $this->mb_ucfirst($city->getName());
  169.                 $data['name'] = $name;
  170.                 $data['id'] = $this->generateUrl('spinner_front_city', array('countypermalink' => $this->mb_ucfirst($city->getCounty()->getPermalinkP()), 'citypermalink' => $this->mb_ucfirst($city->getPermalinkP()) ), true);
  171.                 
  172.                 if ($city->getName() == $cityName) {
  173.                     array_unshift($response, $data);
  174.                 } else {
  175.                     $response[] = $data;
  176.                 }
  177.             }
  178.             return new JsonResponse($response);
  179.         } else {
  180.             return new JsonResponse(array('error' => 'Empty query...No funny business!'));
  181.         }
  182.     }
  183.     
  184.     #[Route('/ajax/querycitycreate', name:"spinner_ajax_autocomplete_create", methods:['GET'])]
  185.     public function querycitycreateAction(Request $request)
  186.     {
  187.         $cityName = $this->mb_ucfirst($request->query->get('name'));
  188.         if ($cityName && !empty($cityName)) {
  189.             $response = array();
  190.             $query = $this->cityRepository->createQueryBuilder('c')
  191.                    ->where('c.name LIKE :name')
  192.                    ->setParameter('name', $cityName.'%')
  193.                    ->getQuery();
  194.             $result = $query->getResult();
  195.             $duplicates = $this->getDuplicates($result);
  196.             foreach ($result as $city) {
  197.                 $data = array();
  198.                 $name = isset($duplicates[$city->getName()]) ? $this->mb_ucfirst($city->getName()).'( '.$city->getCounty()->getName().' län )' : $this->mb_ucfirst($city->getName());
  199.                 $data['name'] = $name;
  200.                 $data['id'] = $city->getID();
  201.                 $data['longitude'] = $city->getLongitude();
  202.                 $data['latitude'] = $city->getLatitude();
  203.                 
  204.                 if ($city->getName() == $cityName) {
  205.                     array_unshift($response, $data);
  206.                 } else {
  207.                     $response[] = $data;
  208.                 }
  209.             }
  210.             return new JsonResponse($response);
  211.         } else {
  212.             return new JsonResponse(array('error' => 'Empty query...No funny business!'));
  213.         }
  214.     }
  215.     
  216.     private function getDuplicates($input)
  217.     {
  218.         $registry = array();
  219.         $duplicates = array();
  220.         foreach ($input as $city) {
  221.             if (isset($registry[$city->getName()])) {
  222.                 $duplicates[$city->getName()] = true;
  223.             } else {
  224.                 $registry[$city->getName()] = true;
  225.             }
  226.         }
  227.         return $duplicates;
  228.     }
  230.     #[Route('/ajax/querycitymanual', name:"spinner_ajax_autocomplete_backend", methods:['GET'])]
  231.     public function querycitymanualAction(Request $request)
  232.     {
  233.         $cityName = $this->mb_ucfirst($request->query->get('name'));
  234.         if ($cityName && !empty($cityName)) {
  235.             $response = array();
  236.             $query = $this->cityRepository->createQueryBuilder('c')
  237.                    ->where('c.name LIKE :name')
  238.                    ->setParameter('name', $cityName.'%')
  239.                    ->getQuery();
  240.             $result = $query->getResult();
  241.             $duplicates = $this->getDuplicates($result);
  242.             foreach ($result as $city) {
  243.                 $data = array();
  244.                 $name = isset($duplicates[$city->getName()]) ? $this->mb_ucfirst($city->getName()).'( '.$city->getCounty()->getName().' län )' : $this->mb_ucfirst($city->getName());
  245.                 $data['name'] = $name;
  246.                 $data['id'] = $this->generateUrl('spinner_backend_citymanual', array( 'cityid' => $city->getId() ), true);
  247.                 
  248.                 if ($city->getName() == $cityName) {
  249.                     array_unshift($response, $data);
  250.                 } else {
  251.                     $response[] = $data;
  252.                 }
  253.             }
  254.             return new JsonResponse($response);
  255.         }
  256.     }
  258.     #[Route('/ajax/querycompanymanual', name:"spinner_ajax_autocomplete_backend_company", methods:['GET'])]
  259.     public function querycompanymanualAction(Request $request)
  260.     {
  261.         $companyName = $this->mb_ucfirst($request->query->get('name'));
  262.         if ($companyName && !empty($companyName)) {
  263.             $repository = $this->em->getRepository(Company::class);
  264.             $response = array();
  265.             $query = $repository->createQueryBuilder('c')
  266.                    ->where('c.name LIKE :name')
  267.                    ->setParameter('name', $companyName.'%')
  268.                    ->getQuery();
  269.             $result = $query->getResult();
  270.             //Preformat
  271.             
  272.             foreach ($result as $company) {
  273.                 $single = array();
  274.                 $single['id'] = $this->generateUrl('spinner_backend_companymanual', array( 'companyid' => $company->getId() ), true);
  275.                 $single['name'] = $company->getName();
  276.                 $response[] = $single;
  277.             }
  278.             //die();
  279.             return new JsonResponse($response);
  280.         } else {
  281.             return new JsonResponse(array('error' => 'Empty query...No funny business!'));
  282.         }
  283.     }
  285.     #[Route('/ajax/querycountymanual', name:"spinner_ajax_autocomplete_county_backend", methods:['GET'])]
  286.     public function querycountymanualAction(Request $request)
  287.     {
  288.         $countyName = $this->mb_ucfirst($request->query->get('name'));
  289.         if ($countyName && !empty($countyName)) {
  290.             $repository = $this->em->getRepository(Counties::class);
  291.             $response = array();
  292.             $query = $repository->createQueryBuilder('c')
  293.                    ->where('c.name LIKE :name')
  294.                    ->setParameter('name', $countyName.'%')
  295.                    ->getQuery();
  296.             $result = $query->getResult();
  297.             //Preformat
  298.             
  299.             foreach ($result as $county) {
  300.                 $single = array();
  301.                 $single['id'] = $this->generateUrl('spinner_backend_countymanual', array( 'countyid' => $county->getId() ), true);
  302.                 $single['name'] = $county->getName();
  303.                 $response[] = $single;
  304.             }
  305.             //die();
  306.             return new JsonResponse($response);
  307.         } else {
  308.             return new JsonResponse(array('error' => 'Empty query...No funny business!'));
  309.         }
  310.     }
  312.     #[Route('/ajax/querycounty', name:"spinner_ajax_autocomplete_county", methods:['GET'])]
  313.     public function querycountyAction()
  314.     {
  315.         $repository = $this->em->getRepository(Counties::class);
  316.         //source: [{% for city in all_cities.get %}{"id":"{{ path('spinner_front_city', {'countypermalink': city.getCounty.getPermalinkP|capitalize, 'citypermalink': city.getPermalinkP|capitalize})|base64_encode}}","name":"{{city.getName|capitalize}}" }, {% endfor %}]
  317.         //$this->generateUrl('spinner_front_city', array('countypermalink' => $city->getCounty()->getPermalinkP(), 'citypermalink' => $city->city.getPermalinkP()), true);
  318.         //path('spinner_front_county', {'countypermalink': activecounty.getPermalinkP|capitalize})
  319.         $result = $repository->findAll();
  320.         foreach ($result as $county) {
  321.             $single = array();
  322.             $single['id'] = $this->generateUrl('spinner_front_county', array('countypermalink' => $this->mb_ucfirst($county->getPermalinkP()) ), true);
  323.             $single['name'] = $this->mb_ucfirst($county->getName());
  324.             $response[] = $single;
  325.         }
  326.         return new JsonResponse($response);
  327.     }
  329.     private function mb_ucfirst($str)
  330.     {
  331.         $fc = mb_strtoupper(mb_substr($str, 0, 1, 'UTF-8'), 'UTF-8');
  332.         return $fc.mb_substr($str, 1, mb_strlen($str), 'UTF-8');
  333.     }
  335.     #[Route("/ajax/holidays", name: 'spinner_ajax_holidays', methods: ['GET'])]
  336.     public function holidaysajaxAction()
  337.     {
  338.         $wrapper = new HolidayWrapper();
  339.         $response = new Response();
  340.         $response->setContent($wrapper->getHolidaysJSON());
  341.         $response->headers->set('Content-Type', 'application/json');
  342.         
  343.         return $response;
  344.     }
  345. }