src/Controller/MainController.php line 384

Open in your IDE?
  1. <?php
  2. /**
  3.  * Created by PhpStorm.
  4.  * User: joakim
  5.  * Date: 2018-02-05
  6.  * Time: 08:38
  7.  */
  9. namespace App\Controller;
  11. use App\Entity\Binocular;
  12. use App\Entity\Chilitexts;
  13. use App\Entity\Drivers;
  14. use App\Entity\Foreignstarts;
  15. use App\Entity\Gambling;
  16. use App\Entity\Horses;
  17. use App\Entity\Legtypecodes;
  18. use App\Entity\Legtypes;
  19. use App\Entity\Meetings;
  20. use App\Entity\Races;
  21. use App\Entity\Ranking;
  22. use App\Entity\Results;
  23. use App\Entity\Starts;
  24. use App\Entity\Swechilitexts;
  25. use App\Entity\Swegambling;
  26. use App\Entity\Swemeetings;
  27. use App\Entity\Trainers;
  28. use App\Repository\RacesRepository;
  29. use Detection\MobileDetect;
  30. use Symfony\Component\HttpFoundation\JsonResponse;
  31. use Symfony\Component\Routing\Annotation\Route;
  32. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  33. // use Symfony\Component\Serializer\SerializerInterface;
  34. // use Symfony\Component\Cache\Adapter\AdapterInterface;
  36. use Symfony\Component\HttpFoundation\Response;
  38. // use Symfony\Component\HttpFoundation\JsonResponse;
  39. use Symfony\Component\HttpFoundation\Request;
  40. // use Symfony\Component\Translation\Translator;
  42. use App\Twig\AppExtension;
  44. class MainController extends AbstractController
  45. {
  47.     private function cookie() {
  48.         if ($_SERVER['APP_ENV'] == 'dev') return true;
  49.         return (isset($_COOKIE['cid_tkr']));
  50.     }
  52.     public function getFooter()
  53.     {
  54.         return $this->render('footer.html.twig', [
  55.             'version' => TGNHESTEFAKTAVERSION,
  56.         ]);
  57.     }
  59.     public function getDDbet($meeting)
  60.     {
  62.         $em = $this->getDoctrine()->getManager();
  64.         // Get races in meeting
  65.         $sql = 'select id from races r
  66.                 where r.rac_mee_id = ' . $meeting . ' and r.rac_legtypes like "%DD%"
  67.                 order by r.rac_raceno';
  68.         $statement = $em->getConnection()->prepare($sql);
  69.         $statement->execute();
  70.         $races_in_legtype = $statement->fetchAll();
  72.         // Get gambling for meeting
  73.         $sql = 'select * from gambling g
  74.                 where g.id = ' . $meeting;
  75.         $statement = $em->getConnection()->prepare($sql);
  76.         $statement->execute();
  77.         $gambling_for_meeting = $statement->fetch();
  78.         $gambling_for_meeting = json_decode($gambling_for_meeting['gam_gambling'],1);
  79.         #dd($gambling_for_meeting);
  80.         $dd_for_legtype = $gambling_for_meeting['DD'];
  81.         #dd($dd_for_legtype);
  83.         $dd[0] = $dd_for_legtype[1];
  84.         $dd[1] = $dd_for_legtype[2];
  86.         foreach ($races_in_legtype as $key => $r) {
  88.             // Get ranking in race
  89.             $sql = 'select * from ranking r
  90.                     where r.id = ' . $r['id'];
  91.             $statement = $em->getConnection()->prepare($sql);
  92.             $statement->execute();
  93.             $ranking_in_race = $statement->fetch();
  94.             $ranking_in_race = explode(',',$ranking_in_race['ran_rank']);
  95.             $ranking_in_race = array_slice($ranking_in_race,0,$dd[$key]);
  96.             #dd($ranking_in_race);
  97.             $ddarr[$key] = $ranking_in_race;
  99.         }
  101.         return $this->render('pages/ddbet.html.twig', [
  102.             'ddarr' => $ddarr,
  103.         ]);
  105.     }
  108.     public function getSweDDbet($meeting)
  109.     {
  111.         $em = $this->getDoctrine()->getManager();
  113.         // Get races in meeting
  114.         $sql = 'select id from sweraces r
  115.                 where r.swemeetings_id = ' . $meeting . ' and r.legtypes like "%DD%"
  116.                 order by r.raceno';
  117.         $statement = $em->getConnection()->prepare($sql);
  118.         $statement->execute();
  119.         $races_in_legtype = $statement->fetchAll();
  121.         // Get gambling for meeting
  122.         $sql = 'select * from swegambling g
  123.                 where g.id = ' . $meeting;
  124.         $statement = $em->getConnection()->prepare($sql);
  125.         $statement->execute();
  126.         $gambling_for_meeting = $statement->fetch();
  127.         $gambling_for_meeting = json_decode($gambling_for_meeting['gam_gambling'],1);
  128.         #dd($gambling_for_meeting);
  129.         $dd_for_legtype = $gambling_for_meeting['DD'];
  131.         $dd[0] = $dd_for_legtype[1];
  132.         $dd[1] = $dd_for_legtype[2];
  134.         foreach ($races_in_legtype as $key => $r) {
  136.             // Get ranking in race
  137.             $sql = 'select * from sweranking r
  138.                     where r.id = ' . $r['id'];
  139.             $statement = $em->getConnection()->prepare($sql);
  140.             $statement->execute();
  141.             $ranking_in_race = $statement->fetch();
  142.             $ranking_in_race = explode(',',$ranking_in_race['ran_rank']);
  143.             $ranking_in_race = array_slice($ranking_in_race,0,$dd[$key]);
  144.             #dd($ranking_in_race);
  145.             $ddarr[$key] = $ranking_in_race;
  147.         }
  149.         return $this->render('pages/ddbet.html.twig', [
  150.             'ddarr' => $ddarr,
  151.         ]);
  153.     }
  156.     /**
  157.      * @Route("/xxx/{meeting}/{legtype}", name="xxx_page")
  158.      */
  159.     public function getStartlist($meeting,$legtype)
  160.     {
  162.         $em = $this->getDoctrine()->getManager();
  164.         // Get races in meeting
  165.         $sql = 'select * from races r
  166.                 where r.rac_mee_id = ' . $meeting . ' and r.rac_legtypes like "%' . $legtype . '%"
  167.                 order by r.rac_raceno';
  168.         #exit($sql);
  169.         $statement = $em->getConnection()->prepare($sql);
  170.         $statement->execute();
  171.         $races_in_legtype = $statement->fetchAll();
  172.         #dd($races_in_legtype);
  174.         // Check if races are V65 or V75 and includes DD
  175.         $sql = 'select * from races r
  176.                 where r.rac_mee_id = ' . $meeting . ' and r.rac_legtypes like "%' . $legtype . '%DD"
  177.                 order by r.rac_raceno';
  178.         #exit($sql);
  179.         $statement = $em->getConnection()->prepare($sql);
  180.         $statement->execute();
  181.         $ddraces_in_legtype = $statement->fetchAll();
  182.         #dd($ddraces_in_legtype);
  183.         if (count($ddraces_in_legtype) > 0) $hasDD = true;
  184.         else $hasDD = false;
  189.         // Get gambling for meeting
  190.         $sql = 'select * from gambling g
  191.                 where g.id = ' . $meeting;
  192.         $statement = $em->getConnection()->prepare($sql);
  193.         $statement->execute();
  194.         $gambling_for_meeting = $statement->fetch();
  195.         $gambling_for_meeting = json_decode($gambling_for_meeting['gam_gambling'],1);
  196.         #dd($gambling_for_meeting);
  197.         $gambling_for_legtype = $gambling_for_meeting[$legtype];
  198.         #dd($gambling_for_legtype);
  200.         foreach ($races_in_legtype as $r) {
  202.             // Get ranking in race
  203.             $sql = 'select * from ranking r
  204.                     where r.id = ' . $r['id'];
  205.             $statement = $em->getConnection()->prepare($sql);
  206.             $statement->execute();
  207.             $ranking_in_race = $statement->fetch();
  208.             #dd($ranking_in_race);
  210.             // Get starts in race
  211.             $sql = 'select s.sta_startno,h.hor_name from starts s
  212.                     left join horses h on s.sta_hor_id = h.id
  213.                     where s.sta_rac_id = ' . $r['id'] . ' and sta_startno in (' . $ranking_in_race['ran_rank'] . ')
  214.                     order by field(s.sta_startno,' . $ranking_in_race['ran_rank'] . ')';
  215.             ;
  216.             $statement = $em->getConnection()->prepare($sql);
  217.             $statement->execute();
  218.             $starts_in_race = $statement->fetchAll();
  219.             #dd($starts_in_race);
  221.             $races[$r['id']]['ranking'] = $starts_in_race;
  222.             #$races[$r['id']]['winningchance'] = explode(',',$ranking_in_race['ran_winningchance']);
  223.         }
  225.         #dd($races);
  227.         return $this->render('pages/startlist.html.twig', [
  228.             'races' => $races,
  229.             'legtype' => $legtype,
  230.             'gambling' => $gambling_for_legtype,
  231.             'hasDD' => $hasDD,
  232.         ]);
  233.     }
  236.     /**
  237.      * @Route("/xxxSWE/{meeting}/{legtype}", name="xxxSWE_page")
  238.      */
  239.     public function getSweStartlist($meeting,$legtype)
  240.     {
  242.         $em = $this->getDoctrine()->getManager();
  244.         // Get races in meeting
  245.         $sql = 'select * from sweraces r
  246.                 where r.swemeetings_id = ' . $meeting . ' and r.legtypes like "%' . $legtype . '%"
  247.                 order by r.raceno';
  248.         $statement = $em->getConnection()->prepare($sql);
  249.         $statement->execute();
  250.         $races_in_legtype = $statement->fetchAll();
  251.         #dd($races_in_legtype);
  253.         // Check if races are V65, V75 or V86 and includes DD
  254.         $sql = 'select * from sweraces r
  255.                 where r.swemeetings_id = ' . $meeting . ' and r.legtypes like "%' . $legtype . '%DD%"
  256.                 order by r.raceno';
  257.         $statement = $em->getConnection()->prepare($sql);
  258.         $statement->execute();
  259.         $ddraces_in_legtype = $statement->fetchAll();
  260.         #dd($ddraces_in_legtype);
  261.         if (count($ddraces_in_legtype) > 0) $hasDD = true;
  262.         else $hasDD = false;
  267.         // Get gambling for meeting
  268.         $sql = 'select * from swegambling g
  269.                 where g.id = ' . $meeting;
  270.         $statement = $em->getConnection()->prepare($sql);
  271.         $statement->execute();
  272.         $gambling_for_meeting = $statement->fetch();
  273.         $gambling_for_meeting = json_decode($gambling_for_meeting['gam_gambling'],1);
  274.         #dd($gambling_for_meeting);
  275.         $gambling_for_legtype = $gambling_for_meeting[$legtype];
  276.         #dd($gambling_for_legtype);
  278.         foreach ($races_in_legtype as $r) {
  280.             // Get ranking in race
  281.             $sql = 'select * from sweranking r
  282.                     where r.id = ' . $r['id'];
  283.             $statement = $em->getConnection()->prepare($sql);
  284.             $statement->execute();
  285.             $ranking_in_race = $statement->fetch();
  286.             #dd($ranking_in_race);
  288.             // Get starts in race
  289.             $sql = 'select s.startno,h.name from swestarts s
  290.                     left join swehorses h on s.swehorses_id = h.id
  291.                     where s.sweraces_id = ' . $r['id'] . ' and startno in (' . $ranking_in_race['ran_rank'] . ')
  292.                     order by field(s.startno,' . $ranking_in_race['ran_rank'] . ')';
  293.             $statement = $em->getConnection()->prepare($sql);
  294.             $statement->execute();
  295.             $starts_in_race = $statement->fetchAll();
  296.             #dd($starts_in_race);
  298.             $races[$r['id']]['ranking'] = $starts_in_race;
  299.             #$races[$r['id']]['winningchance'] = explode(',',$ranking_in_race['ran_winningchance']);
  300.         }
  302.         return $this->render('pages/startlistSWE.html.twig', [
  303.             'races' => $races,
  304.             'legtype' => $legtype,
  305.             'gambling' => $gambling_for_legtype,
  306.             'hasDD' => $hasDD,
  307.         ]);
  308.     }
  315.     public function getDDStartlist($meeting,$legtype)
  316.     {
  318.         $em = $this->getDoctrine()->getManager();
  320.         // Get races in meeting
  321.         $sql = 'select r.id from races r
  322.                 where r.rac_mee_id = ' . $meeting . ' and r.rac_legtypes like "' . $legtype . '%DD"
  323.                 order by r.rac_raceno';
  324.         $statement = $em->getConnection()->prepare($sql);
  325.         $statement->execute();
  326.         $races_in_legtype = $statement->fetchAll();
  328.         // Get gambling for meeting
  329.         $sql = 'select * from gambling g
  330.                 where g.id = ' . $meeting;
  331.         $statement = $em->getConnection()->prepare($sql);
  332.         $statement->execute();
  333.         $gambling_for_meeting = $statement->fetch();
  334.         $gambling_for_meeting = json_decode($gambling_for_meeting['gam_gambling'],1);
  335.         $gambling_for_legtype = $gambling_for_meeting[$legtype];
  337.         foreach ($races_in_legtype as $key => $r) {
  339.             // Get ranking in race
  340.             $sql = 'select * from ranking r
  341.                     where r.id = ' . $r['id'];
  342.             $statement = $em->getConnection()->prepare($sql);
  343.             $statement->execute();
  344.             $ranking_in_race = $statement->fetch();
  346.             // Get starts in race
  347.             $sql = 'select s.sta_startno,h.hor_name from starts s
  348.                     left join horses h on s.sta_hor_id = h.id
  349.                     where s.sta_rac_id = ' . $r['id'] . ' and sta_startno in (' . $ranking_in_race['ran_rank'] . ')
  350.                     order by field(s.sta_startno,' . $ranking_in_race['ran_rank'] . ')';
  351.             ;
  352.             $statement = $em->getConnection()->prepare($sql);
  353.             $statement->execute();
  354.             $starts_in_race = $statement->fetchAll();
  356.             $races[$r['id']]['ranking'] = $starts_in_race;
  357.         }
  359.         return $this->render('pages/startlistDD.html.twig', [
  360.             'races' => $races,
  361.             'legtype' => $legtype,
  362.             'gambling' => $gambling_for_legtype,
  363.         ]);
  364.     }
  375.     /**
  376.      * @Route("/", name="app_homepage")
  377.      */
  378.     public function homepage()
  379.     {
  381.         $allowed = self::cookie();
  382.         if (!$allowed) { return $this->redirect('https://tgn.no/hestefakta-tips-og-spill/'); }
  384.         $em = $this->getDoctrine()->getManager();
  386.         $today = date('Y-m-d');
  388.         $sql = 'select m.id as mee_id,m.mee_date as date,m.mee_firstracestart as firstracestart,m.mee_legtypes as legtypes,t.trk_shortname as shortname,"NOR" as country,c.cht_image as image,c.cht_text as text,c.cht_ready as ready from meetings m
  389.                 left join tracks t on m.mee_tra_id = t.id
  390.                 left join chilitexts c on m.id = c.id
  391.                 where m.mee_date >= "' . $today . '" and m.mee_legtypes != ""
  392.                 union
  393.                 select sm.id as mee_id,sm.date,sm.firstracestart,sm.legtypes,st.shortname,"SWE" as country,sc.cht_image as image,sc.cht_text as text,sc.cht_ready as ready from swemeetings sm
  394.                 left join swetracks st on sm.track_id = st.id
  395.                 left join swechilitexts sc on sm.id = sc.id
  396.                 where sm.date >= "' . $today . '" and sm.legtypes != "" and sc.cht_ready = true
  397.                 order by date asc,firstracestart asc';
  398.         #pre($sql,1);
  399.         $statement = $em->getConnection()->prepare($sql);
  400.         $statement->execute();
  401.         $meetings = $statement->fetchAll();
  403.         $pattern = "#<\s*?p\b[^>]*>(.*?)</p\b[^>]*>#s";
  404.         foreach ($meetings as $key => $m) {
  405.             preg_match($pattern, $m['text'], $matches);
  406.             $meetings[$key]['title'] = isset($matches[1]) ? strip_tags($matches[1]) : '';
  407.             $meetings[$key]['legtypes'] = sortLegtypes($meetings[$key]['legtypes']);
  408.         }
  409.         #dd($meetings);
  411.         return $this->render('homepage2.html.twig', [
  412.             'meetings' => $meetings,
  413.         ]);
  415.     }
  418.     /**
  419.      * @Route("/OLD", name="app_homepageOLD")
  420.      */
  421.     public function homepageOLD()
  422.     {
  424.         $allowed = self::cookie();
  425.         if (!$allowed) { return $this->redirect('https://tgn.no/hestefakta-tips-og-spill/'); }
  427.         $intwodays= new \DateTime('+2 day');
  428.         $tomorrow= new \DateTime('+1 day');
  430.         $months = array('', 'januar', 'februar', 'mars', 'april', 'mai', 'juni', 'juli', 'august', 'september', 'oktober', 'november', 'desember');
  431.         $days = array('', 'mandag', 'tirsdag', 'onsdag', 'torsdag', 'fredag', 'lørdag', 'søndag');
  433.         $products = $this->getDoctrine()->getRepository(Races::class)->listAllObjects();
  434.         #pre($products,1);
  435.         $legtypes = $this->getDoctrine()->getRepository(Races::class) ->getLegTypes();
  437.         $em = $this->getDoctrine()->getManager();
  438.         // Get races in meeting
  439.         // select(array('r.id','r.rac_racetype_code', 'r.rac_name','r.rac_raceno','r.rac_mee_id','m.mee_date','t.trk_trackname','t.trk_shortname','t.id as t_id', 'r.rac_starttime','r.rac_basedist', 'm.mee_firstracestart'))
  441.         $sql = 'select r.id from sweraces r
  442.                 left join swemeetings s on r.swemeetings_id = s.id
  443.                 where s.date >= "' . date('Y-m-d') . '"';
  444.         $statement = $em->getConnection()->prepare($sql);
  445.         $statement->execute();
  446.         $races = $statement->fetchAll();
  447.         #dd($races);
  449.         $binoculars = $this->getDoctrine()->getRepository(Binocular::class)->findActive();
  450.         foreach ($binoculars as $key => $b) {
  451.             $pattern = "#<\s*?p\b[^>]*>(.*?)</p\b[^>]*>#s";
  452.             preg_match($pattern, $b['txt'], $matches);
  453.             $binoculars[$key]['binocular_title'] = $matches[1];
  454.         }
  456.         if ($products) {
  457.             $traName = 'Alle baner';
  458.             $articleContent = 'Info for alle baner';
  459.         } else {
  460.             $traName = 'Ingen info';
  461.             $articleContent = '';
  462.         }
  464.         $arr = array();
  466.         foreach ($products as $prod) {
  467.             $p = $this->getDoctrine()->getRepository(Chilitexts::class)->find($prod['rac_mee_id']);
  468.             if ($p) {
  469.                 if ($p->getChtReady()) {
  470.                     $pattern = "#<\s*?p\b[^>]*>(.*?)</p\b[^>]*>#s";
  471.                     preg_match($pattern, $p->getChtText(), $matches);
  472.                     $tt = $matches[1];
  473.                     $bt = $p->getChtImageCaption();
  474.                 } else {
  475.                     $tt = '<br>';
  476.                     $bt = '';
  477.                 }
  478.                 if ($p->getChtImage() == '/assets/img/noimage.jpg') {
  479.                     $img = '/img/trav.jpg';
  480.                     if ($prod['t_id'] == 207) $img = '/img/galopp.jpg';
  481.                     array_push($arr, array('id'=>$p->getId(),'img'=>$img,'caption'=>$bt,'title'=>$tt));
  482.                 } else {
  483.                     array_push($arr, array('id'=>$p->getId(),'img'=>$p->getChtImage(),'caption'=>$bt,'title'=>$tt));
  484.                 }
  485.             }
  486.         }
  487.         #pre($arr,1);
  489.         return $this->render('homepage.html.twig', [
  490.             'title' =>  $traName,
  491.             'articleContent' => $articleContent,
  492.             'dbData' => $traName,
  493.             'all' => $products,
  494.             'leg' => $legtypes,
  495.             'months' => $months,
  496.             'days' => $days,
  497.             'tomorrow' => $tomorrow,
  498.             'intwodays' => $intwodays,
  499.             'binocular' => $binoculars,
  500.             'pp' => $arr
  501.         ]);
  502.     }
  505.     /**
  506.      * @Route("/images/{query}", name="app_img")
  507.      */
  508.     public function images($query){
  509.         /*
  510.         $ch = new \curl_init('http://fotoweb.raaness.no/fotoweb/archives/5001-bildearkiv/?q=100');
  511.         curl_setopt($ch, CURLOPT_CUSTOMREQUEST, "GET");
  512.         curl_setopt($ch, CURLOPT_HTTPHEADER, array(
  513.                 'Accept: application/vnd.fotoware.assetlist+json'
  514.             )
  515.         );
  516.         curl_setopt($ch, CURLOPT_RETURNTRANSFER,true);
  517.         $result = json_decode(curl_exec($ch), true);
  518.         var_dump($result);
  520.         return $this->render('pages/images.html.twig', ['name' => $result]);
  521.         */
  522.     }
  525.     /**
  526.      * @Route("/horses/{horse}", name="app_horses")
  527.      */
  528.     public function horses($horse)
  529.     {
  531.         $allowed = self::cookie();
  533.         if (!$allowed) { return $this->redirect('https://tgn.no/hestefakta-tips-og-spill/'); }
  535.         if($horse == 'all'){
  536.             $horseSel = 'all';
  537.             $info = '';
  538.             $owners = '';
  539.             $trainers = '';
  540.             $father = '';
  541.             $mother = '';
  542.             $grandfather = '';
  543.             $result = '';
  544.             $comments = '';
  545.             $arr = '';
  546.             $searchfor = '';
  547.         } else {
  550.             $owners = '';
  551.             $trainers = '';
  552.             $searchfor = '';
  555.             $horseSel = $this->getDoctrine()->getRepository(Horses::class)->getObject($horse);
  556.             $info = $this->getDoctrine()->getRepository(Results::class)->getHorseInfo($horse);
  558.             $arr = array();
  562.             for ($x = 0; $x < count($info); $x++) {
  563.                 $m = json_decode($info[$x]['rac_racepurse']);
  564.                 $p = 0;
  565.                 $pL = 0;
  566.                 if($m){
  567.                     foreach ($m as $y) {
  568.                         if(intval($y)>$pL){
  569.                             $p = intval($y);
  570.                         }
  571.                         $pL = intval($y);
  572.                     }
  573.                 }
  574.                 array_push($arr, $p);
  575.             }
  579.             $horseFather = $this->getDoctrine()
  580.                 ->getRepository(Horses::class)
  581.                 ->find($horse)->getHorFatherId();
  584.             if($horseFather){
  585.                 $father = $this->getDoctrine()->getRepository(Horses::class)->find($horseFather);
  586.              } else {
  587.                 $father = '';
  588.             }
  590.             $horseMother = $this->getDoctrine()->getRepository(Horses::class)->find($horse)->getHorMotherId();
  591.             $grandfather = '';
  592.             if($horseMother){
  593.                 $mother = $this->getDoctrine()->getRepository(Horses::class)->find($horseMother);
  594.                if($this->getDoctrine()->getRepository(Horses::class)->find($mother)->getHorFatherId()){
  595.                     $grandfather = $this->getDoctrine()->getRepository(Horses::class)->find($mother->getHorFatherId());
  596.                 }
  599.             } else {
  600.                 $mother = '';
  601.             }
  602. /*
  603.             $result = $this->getDoctrine()
  604.                 ->getRepository(Results::class)
  605.                 ->getResInfo($horse);
  606. */
  607.           $result = '';
  609.             $comments = $this->getDoctrine()
  610.                 ->getRepository(Starts::class)
  611.                 ->getHorseComments($horse);
  612.             }
  615.         return $this->render('pages/searchresult.html.twig', [
  616.             'horse' =>  $horseSel,
  617.             'result' => $result,
  618.             'info' => $info,
  619.             'father' => $father,
  620.             'mother' => $mother,
  621.             'grandfather' => $grandfather,
  622.             'comments' => $comments,
  623.             'arr' => $arr,
  624.             'searchfor' => $searchfor,
  625.         ]);
  627.     }
  629.     /**
  630.      * @Route("/search/{kind}", name="app_search", methods={"GET","POST"})
  631.      */
  632.     public function search($kind) {
  633.         $searchfor = '';
  634.         switch ($kind) {
  635.             case 'horse':
  636.                 if (isset($_POST['horse_name'])) {
  637.                     if($_POST['horse_name'] !== '') {
  638.                         $searchfor = $_POST['horse_name'];
  640.                         $horses = $this->getDoctrine()
  641.                             ->getRepository(Horses::class)
  642.                             ->searchObject($searchfor);
  644.                         $drivers = $this->getDoctrine()
  645.                             ->getRepository(Drivers::class)
  646.                             ->searchObject($searchfor);
  647.                         #dd($drivers);
  649.                         $trainers = $this->getDoctrine()
  650.                             ->getRepository(Trainers::class)
  651.                             ->searchObject($searchfor);
  653.                         $list = ['horses' => $horses, 'drivers' => $drivers, 'trainers' => $trainers];
  654.                     } else {
  655.                         return $this->redirectToRoute('app_horses', ['horse'=>'all','result'=>'']);
  656.                     }
  657.                 } else {
  658.                     return $this->redirectToRoute('app_horses', ['horse'=>'all','result'=>'']);
  659.                 }
  660.                 return $this->render('pages/searchresult.html.twig', [
  661.                     'horse' =>  'all',
  662.                     'result' => $list,
  663.                     'info' => '',
  664.                     'searchfor' => $searchfor,
  665.                 ]);
  666.                 break;
  667.             case 'results':
  668.                 $list = $this->getDoctrine()
  669.                     ->getRepository(Races::class)
  670.                     ->searchObjects($_POST['result']);
  671.                 $title = 'Results';
  672.                 return $this->render('pages/results.html.twig', [
  673.                     'title' => $title,
  674.                     'list' => $list,
  675.                 ]);
  676.                 break;
  677.             default:
  678.                 return $this->render('pages/searchresult.html.twig', [
  679.                     'horse' =>  'all',
  680.                     'result' => $list,
  681.                     'info' => '',
  682.                     'searchfor' => $searchfor,
  683.                 ]);
  684.                 break;
  685.         }
  687.     }
  689.     /**
  690.      * @Route("/tipsSWE/{mee_id}", name="app_tips_swe")
  691.      */
  692.     public function tipsSWE($mee_id){
  694.         $allowed = self::cookie();
  695.         if (!$allowed) { return $this->redirect('https://tgn.no/hestefakta-tips-og-spill/'); }
  697.         $em = $this->getDoctrine()->getManager();
  699.         $sql = 'select s.*,t.shortname from swemeetings s
  700.                  left join swetracks t on s.track_id = t.id
  701.                  where s.id = ' . $mee_id;
  702.         $statement = $em->getConnection()->prepare($sql);
  703.         $statement->execute();
  704.         $meeting = $statement->fetch();
  705.         #dd($meeting);
  707.         $meeting['legtypes'] = sortLegtypes($meeting['legtypes']);
  709.         $text = $em->getRepository(Swechilitexts::class)->find($mee_id);
  711.         $gambling = $em->getRepository(Swegambling::class)->find($mee_id);
  712.         $gambling = json_decode($gambling->getGamGambling(),1);
  714. //        $date = new \DateTime('+2 hours');
  715. //        $intwodays= new \DateTime('+2 day');
  716. //        $tomorrow= new \DateTime('+1 day');
  718. //        if ($meeting == 'all') $products = '';
  719. //        else $products = $this->getDoctrine()->getRepository(Races::class)->getTrack($meeting);
  720. //
  721. //        $races = $this->getDoctrine()->getRepository(Races::class)->listAllObjects();
  722. //        $info = $this->getDoctrine()->getRepository(Chilitexts::class) ->findChiliData($meeting);
  723. //        #dd($info);
  724. //        $legtypes = $this->getDoctrine()->getRepository(Races::class) ->getLegTypes();
  725. //
  726. //        $betting = $this->getDoctrine()->getRepository(Gambling::class)->find($meeting);
  727. //        #dd($betting);
  728. //        if ($betting) $gambling = json_decode($betting->getGamGambling(),1);
  729. //        else $gambling = [];
  730. //        #dd($gambling);
  732.         return $this->render('pages/tipsSWE.html.twig', [
  733.             'meeting' => $meeting,
  734.             'text' => $text,
  735.             'gambling' => $gambling,
  736. //            'title' => $meeting,
  737. //            'all' => $products,
  738. //            'races' => $races,
  739. //            'info' => $info,
  740. //            'tomorrow' => $tomorrow,
  741. //            'intwodays' => $intwodays,
  742. //            'date' => $date,
  743. //            'leg' => $legtypes,
  744. //            'gambling' => $gambling,
  745.         ]);
  746.     }
  748.     /**
  749.      * @Route("/tips/{meeting}", name="app_tips")
  750.      */
  751.     public function tips($meeting){
  753.         $allowed = self::cookie();
  754.         if (!$allowed) { return $this->redirect('https://tgn.no/hestefakta-tips-og-spill/'); }
  756.         $date = new \DateTime('+2 hours');
  757.         $intwodays= new \DateTime('+2 day');
  758.         $tomorrow= new \DateTime('+1 day');
  760.         if ($meeting == 'all') $products = '';
  761.         else $products = $this->getDoctrine()->getRepository(Races::class)->getTrack($meeting);
  763.         $races = $this->getDoctrine()->getRepository(Races::class)->listAllObjects();
  764.         $info = $this->getDoctrine()->getRepository(Chilitexts::class) ->findChiliData($meeting);
  765.         #dd($info);
  766.         $legtypes = $this->getDoctrine()->getRepository(Races::class) ->getLegTypes();
  768.         $betting = $this->getDoctrine()->getRepository(Gambling::class)->find($meeting);
  769.         #dd($betting);
  770.         if ($betting) $gambling = json_decode($betting->getGamGambling(),1);
  771.         else $gambling = [];
  772.         #dd($gambling);
  774.         return $this->render('pages/tips.html.twig', [
  775.             'title' => $meeting,
  776.             'all' => $products,
  777.             'races' => $races,
  778.             'info' => $info,
  779.             'tomorrow' => $tomorrow,
  780.             'intwodays' => $intwodays,
  781.             'date' => $date,
  782.             'leg' => $legtypes,
  783.             'gambling' => $gambling,
  784.         ]);
  785.     }
  787.     /**
  788.      * @Route("/res/{race}", name="app_res", methods={"GET","POST"})
  789.      */
  790.     public function res($race){
  791.         if ($race == 'all') {
  792.             $products = '';
  793.             $results = '';
  794.             $legTypes = '';
  795.         } else {
  796.             $products = $this->getDoctrine()->getRepository(Races::class)->getTrack($race);
  797.             $results = $this->getDoctrine()->getRepository(Results::class)->sortRace($race);
  798.             $legTypes = $this->getDoctrine() ->getRepository(Races::class)->getLegTypesRace($race);
  799.         }
  801.         $r = '1';
  803.         if ($this->request->getRealMethod() == 'get') {
  804.             $r = '2';
  805.         }
  807.         $resultsX = $this->getDoctrine()->getRepository(Results::class)->sortRaceTestRace($race);
  809.         return $this->render('includes/res.html.twig', [
  810.             'all' => $products,
  811.             'results' => $results,
  812.             'legtypes' => $legTypes,
  813.             'race' => $r,
  814.             'new' => $resultsX
  815.         ]);
  816.     }
  818.     /**
  819.      * @Route("/resu/{mee_id}/{lop}", name="app_resu")
  820.      */
  821.     public function resu($mee_id,$lop){
  823.         if ($mee_id=='all') {
  824.             $races = '';
  825.             $results = '';
  826.             $legTypes = '';
  827.             $active = 0;
  828.         } else {
  829.             $races = $this->getDoctrine()->getRepository(Races::class)->getTrack($mee_id);
  830.             $results = $this->getDoctrine()->getRepository(Results::class)->sortRace($mee_id);
  831.             $legTypes = $this->getDoctrine()->getRepository(Races::class)->getLegTypesRace($mee_id);
  833.             $mm = $this->getDoctrine()->getRepository(Meetings::class)->findActive($mee_id);
  834.             $active = $mm[0]['mee_comments_ready'];
  835.         }
  837.         $resultsX = $this->getDoctrine()->getRepository(Results::class)->sortRaceTestRace($mee_id);
  839.         $ff = array_merge($results,$resultsX);
  841.         return $this->render('includes/res.html.twig', [
  842.             'all' => $races,
  843.             'results' => $ff,
  844.             'legtypes' => $legTypes,
  845.             'race' => $lop,
  846.             'new' => $resultsX,
  847.             'active' => $active
  848.         ]);
  849.     }
  851.     /**
  852.      * @Route("/resuX/{mee_id}", name="results_page")
  853.      */
  854.     public function resuX($mee_id) {
  856.         $results = $this->getDoctrine()->getRepository(Results::class)->getAllResultsForMeeting($mee_id);
  857.         #dd($results);
  858.         $resultsArray = [];
  859.         foreach ($results as $result) {
  860.             #dd($result);
  861.             $resultsArray[$result['res_rac_id']]['result'][] = $result;
  862.             $prices = json_decode($result['rac_racepurse'],1);
  863.             $resultsArray[$result['res_rac_id']]['firstprice'] = $prices[1];
  864.         }
  865.         #pre($resultsArray,1);
  867.         $html = $this->renderView('includes/resX.html.twig', [
  868.             'results' => $resultsArray,
  869.         ]);
  871.         return new JsonResponse(array('status' => 'success', 'html' => $html));
  872.     }
  875.     /**
  876.      * @Route("/driver/{driver}", name="app_driver")
  877.      */
  879.     public function driver($driver){
  881.         $results = $this->getDoctrine()
  882.             ->getRepository(Drivers::class)
  883.             ->getDriverInfo($driver);
  885.         $info = $this->getDoctrine()
  886.             ->getRepository(Results::class)
  887.             ->getDriverInfo($driver);
  889.         $arr = array();
  891.         for ($x = 0; $x < count($info); $x++) {
  892.             $m = json_decode($info[$x]['rac_racepurse']);
  893.             $p = 0;
  894.             $pL = 0;
  895.             if($m){
  896.                 foreach ($m as $y) {
  897.                     if(intval($y)>$pL){
  898.                         $p = intval($y);
  899.                     }
  900.                     $pL = intval($y);
  901.                 }
  902.             }
  903.             array_push($arr, $p);
  904.         }
  906.         return $this->render('pages/driver.html.twig', [
  907.             'info' => $info,
  908.             'results' => $results,
  909.             'arr' => $arr,
  910.         ]);
  911.     }
  913.     /**
  914.      * @Route("/trainer/{trainer}", name="app_trainer")
  915.      */
  916.     public function trainer($trainer){
  918.         $results = $this->getDoctrine()
  919.             ->getRepository(Trainers::class)
  920.             ->getTrainerInfo($trainer);
  922.         $info = $this->getDoctrine()
  923.             ->getRepository(Results::class)
  924.             ->getTrainerInfo($trainer);
  926.         $arr = array();
  928.         for ($x = 0; $x < count($info); $x++) {
  929.             $m = json_decode($info[$x]['rac_racepurse']);
  930.             $p = 0;
  931.             $pL = 0;
  932.             if($m) {
  933.                 foreach ($m as $y) {
  934.                     if(intval($y)>$pL){
  935.                         $p = intval($y);
  936.                     }
  937.                     $pL = intval($y);
  938.                 }
  939.             }
  940.             array_push($arr, $p);
  941.         }
  943.         return $this->render('pages/trainer.html.twig', [
  944.             'info' => $info,
  945.             'results' => $results,
  946.             'arr' => $arr,
  947.         ]);
  948.     }
  952.     /**
  953.      * @Route("/latestfiveforhorse/{horse}/{beforedate}", name="getLatestFiveForHorsePAGE")
  954.      */
  955.     public function getLatestFiveForHorse($horse,$beforedate)
  956.     {
  958.         $xx = $this->getDoctrine()->getRepository(Results::class)->getLastFive($horse,$beforedate);
  959.         $xy = $this->getDoctrine()->getRepository(Foreignstarts::class)->getLastFive($horse,$beforedate);
  960.         $newXXX = array_merge($xx, $xy);
  961.         usort($newXXX, function($a, $b) { return $a['mee_date'] <=> $b['mee_date']; });
  962.         dd($newXXX);
  964. //        $last5 = getLatestResultsForHorseBeforeMeeting($meeting,$horse,3,5);
  965. //        dd($last5);
  966.     }
  968.     /**
  969.      * @Route("/latestfiveforrace/{race}", name="getLatestFiveForRacePAGE")
  970.      */
  971.     public function getLatestFiveForRace($race)
  972.     {
  973. //        $last5 = getLatestResultsForHorseBeforeMeeting($meeting,$horse,3,5);
  974. //        dd($last5);
  975.     }
  977.     /**
  978.      * @Route("/progX/{meeting}", name="app_proX")
  979.      */
  980.     public function progX($meeting)
  981.     {
  983.         $md = new MobileDetect();
  985.         $em = $this->getDoctrine()->getManager();
  987.         $chilitext = $em->getRepository(Chilitexts::class)->find($meeting);
  989.         // Get races in meeting
  990.         $sql = 'select * from races r
  991.                 where r.rac_mee_id = ' . $meeting . '
  992.                 order by r.rac_raceno asc';
  993.         $statement = $em->getConnection()->prepare($sql);
  994.         $statement->execute();
  996.         $rim = [];
  997.         while ($race = $statement->fetch()) $rim[$race['id']] = $race;
  998.         #dd($races_in_meeting);
  1000.         // Get starts in meeting
  1001.         $sql = 'select s.id as sta_id,s.*,r.id as rac_id,r.*,h.id as hor_id,h.*,o.id as hos_id,o.* from starts s
  1002.                 left join races r on s.sta_rac_id = r.id
  1003.                 left join horses h on s.sta_hor_id = h.id
  1004.                 left join horsestats o on s.sta_hor_id = o.id
  1005.                 where s.sta_mee_id = ' . $meeting . '
  1006.                 order by r.rac_raceno,r.rac_starttime,s.sta_startno';
  1007.         $statement = $em->getConnection()->prepare($sql);
  1008.         $statement->execute();
  1010.         $races = [];
  1011.         while ($start = $statement->fetch()) {
  1013.             $father = getHorseNameFromId($start['hor_father_id']);
  1014.             $mother = getHorseNameFromId($start['hor_mother_id']);
  1015.             $driver = getDriverNameFromId($start['sta_dri_id']);
  1016.             $trainer = getTrainerNameFromId($start['hor_tra_id']);
  1017.             $start['father'] = $father;
  1018.             $start['mother'] = $mother;
  1019.             $start['driver'] = $driver;
  1020.             $start['trainer'] = $trainer;
  1021.             $beforedate = date('Ymd',strtotime($start['rac_startdate']));
  1022.             $lastFiveDomestic = $this->getDoctrine()->getRepository(Results::class)->getLastFive($start['sta_hor_id'],$beforedate);
  1023.             $lastFiveForeign = $this->getDoctrine()->getRepository(Foreignstarts::class)->getLastFive($start['sta_hor_id'],$beforedate);
  1024.             #if ($start['sta_hor_id'] == 30090831) dd($lastFiveForeign);
  1025.             $lastFive = array_merge($lastFiveDomestic, $lastFiveForeign);
  1026.             usort($lastFive, function($a, $b) { return $a['mee_date'] <=> $b['mee_date']; });
  1027.             $lastFive = array_slice($lastFive,-5);
  1028.             $start['last5'] = $lastFive;
  1030.             $intletter = getInterviewLetter($lastFive,$start['sta_hor_id']);
  1031.             $start['intletter'] = $intletter;
  1033.             $races[$start['sta_rac_id']]['raceno'] = $start['rac_raceno'];
  1034.             $races[$start['sta_rac_id']]['starts'][$start['sta_startno']] = $start;
  1035.         }
  1036.         foreach ($races as $k => $r) {
  1037.             $races[$k]['legtypes'] = getLegtypesForRace($k);
  1038.             $races[$k]['info1'] = '<strong>' . $rim[$k]['rac_basedist'] . ' m. ' . $rim[$k]['rac_startmethod_text'] . '</strong>. Start ca kl. ' . date('H:i',strtotime($rim[$k]['rac_starttime']));
  1039.             $racepurses = json_decode($rim[$k]['rac_racepurse'],1);
  1040.             $firstprice = $racepurses[1];
  1041.             $content = trim($rim[$k]['rac_headtext_1']) . ' Fpr: ' . number_format($firstprice,0,'.',' ');
  1042.             $remove = array("\n", "\r\n", "\r", "<p>", "</p>", "<h1>", "</h1>", "<br>", "<br />", "<br/>");
  1043.             $races[$k]['info2'] = str_replace($remove,' ',$content);
  1045.             $races[$k]['rank'] = getRankForRace($k);
  1047.         }
  1048.         #pre($races,1);
  1050.         return $this->render('includes/program.html.twig', [
  1051.             'races' => $races,
  1052.             'chilitext' => $chilitext,
  1053.             'isMobile' => $md->isMobile(),
  1054.         ]);
  1056.     }
  1058.     /**
  1059.      * @Route("/prog/{meeting}", name="app_pro")
  1060.      */
  1061.     public function prog($meeting)
  1062.     {
  1064.         $races_in_meeting = $this->getDoctrine()->getRepository(Races::class)->getTrack($meeting);
  1066.         $starts = $this->getDoctrine()->getRepository(Starts::class)->listStarts($meeting);
  1067.         $horsestats = $this->getDoctrine()->getRepository(Starts::class)->listHorses($meeting);
  1068.         $legTypes = $this->getDoctrine()->getRepository(Races::class)->getLegTypesRace($meeting);
  1070.         $em = $this->getDoctrine()->getManager();
  1071.         $sql = 'select r.id,r.ran_rank,r.ran_winningchance from ranking r
  1072.                 left join races a on r.id = a.id
  1073.                 left join meetings m on a.rac_mee_id = m.id
  1074.                 where m.id = ' . $meeting . ' order by a.rac_raceno';
  1075.         $statement = $em->getConnection()->prepare($sql);
  1076.         $statement->execute();
  1077.         $result = $statement->fetchAll();
  1078.         foreach ($result as $r) $rankings[$r['id']] = $r;
  1080.         foreach ($races_in_meeting as $key => $r) {
  1081.             if (isset($rankings[$r['rac_id']])) $races_in_meeting[$key]['ranking'] = $rankings[$r['rac_id']];
  1082.         }
  1084.         $curdate = $races_in_meeting[0]['mee_date'];
  1085.         $curdate = date_format($curdate, 'Ymd');
  1087.         $horseinfo = array();
  1088.         for ($x = 0; $x < count($horsestats); $x++) {
  1089.             $m = json_decode($horsestats[$x]['hor_mother_id']);
  1090.             $f = json_decode($horsestats[$x]['hor_father_id']);
  1091.             $mm = $this->getDoctrine()->getRepository(Horses::class)->find($m);
  1092.             $ff = $this->getDoctrine()->getRepository(Horses::class)->find($f);
  1094.             $xx = $this->getDoctrine()->getRepository(Results::class)->getLastFive($horsestats[$x]['hid'],$curdate);
  1095.             $xy = $this->getDoctrine()->getRepository(Foreignstarts::class)->getLastFive($horsestats[$x]['hid'],$curdate);
  1097.             $newXXX = array_merge($xx, $xy);
  1098.             usort($newXXX, function($a, $b) { return $a['mee_date'] <=> $b['mee_date']; });
  1100.             array_push($horseinfo, [$horsestats[$x]['hid'], $mm->getHorName(), $ff->getHorName(), $newXXX]);
  1101.         }
  1103.         return $this->render('includes/prog_dev2.html.twig', [
  1104.             'all' => $races_in_meeting,
  1105.             'starts' => $starts,
  1106.             'legtypes' => $legTypes,
  1107.             'horses' => $horsestats,
  1108.             'horseinfo' => $horseinfo
  1109.         ]);
  1111.     }
  1114.     /**
  1115.      * @Route("/inn/{race}", name="app_inn")
  1116.      */
  1117.     public function inns($race){
  1119.         if($race=='all'){
  1120.             $products = '';
  1121.             $starts = '';
  1122.             $results = '';
  1123.             $legTypes = '';
  1124.         } else {
  1125.             $products = $this->getDoctrine()
  1126.                 ->getRepository(Races::class)
  1127.                 ->getTrack($race);
  1129.             $results = $this->getDoctrine()
  1130.                 ->getRepository(Results::class)
  1131.                 ->sortRace($race);
  1133.             $legTypes = $this->getDoctrine()
  1134.                 ->getRepository(Races::class)
  1135.                 ->getLegTypesRace($race);
  1136.         }
  1138.         $races = $this->getDoctrine()->getRepository(Races::class)->listAllObjects();
  1140.         return $this->render('pages/tips.html.twig', [
  1141.             'title' => $race,
  1142.             'all' => $products,
  1143.             'races' => $races,
  1144.             'results' => $results,
  1145.             'legtypes' => $legTypes,
  1146.         ]);
  1147.     }
  1150.     /**
  1151.      * @Route("/results", name="app_results")
  1152.      */
  1153.     public function results(){
  1155.         $allowed = self::cookie();
  1157.         if (!$allowed) { return $this->redirect('https://tgn.no/hestefakta-tips-og-spill/'); }
  1159.         $meetings = $this->getDoctrine()->getRepository(Meetings::class)->getLatest50meetings();
  1160.         #dd($meetings);
  1162.         return $this->render('pages/results.html.twig', [
  1163.             'meetings' => $meetings,
  1164.         ]);
  1165.     }
  1167.     /**
  1168.      * @Route("/odds/{race}", name="app_odds")
  1169.      */
  1170.     public function getOdds($race){
  1171.         $ftp_username = 'raaness';
  1172.         $ftp_userpass = '8rifw8iw1p';
  1174.         $conn_id = ftp_connect('info.rikstoto.no');
  1176.         ftp_login($conn_id, $ftp_username ,  $ftp_userpass);
  1177.         ftp_pasv($conn_id, true);
  1179.         $file = $race;
  1180.         $file = str_replace('BE', 'BT', $file);
  1181.         $h = fopen('php://temp', 'r+');
  1182.         $html = '';
  1183.         if (ftp_fget($conn_id, $h, 'spillinfo/v3/'.$file, FTP_ASCII)){
  1185.             $fstats = fstat($h);
  1186.             fseek($h, 0);
  1187.             $contents = fread($h, $fstats['size']);
  1189.             $xml = simplexml_load_string($contents);
  1190.             $simpXML = new \SimpleXMLElement($xml->asXML());
  1191.             $simpXML->registerXPathNamespace('tgn', 'http://www.rikstoto.no/betinfo/v3');
  1192.             $xpath = $simpXML->xpath('//tgn:Meeting/tgn:Races/tgn:Race');
  1194.             foreach ($xpath as $x) {
  1195.                 $html .= '<div style="border:1px solid #CCC; border-radius: 6px;padding:15px;margin-bottom: 20px;margin-top: 10px;">';
  1196.                 $html .= '<div class="b_'.$x->RaceNo.'" style="width:100%;white-space: nowrap;">';
  1197.                 $html .= '<div style="margin-right:8px;display: inline;font-size: 1rem;">';
  1198.                 $html .= '<span style="font-size: 30px; font-weight: bold; margin-right: 8px;padding: 8px;">'.$x->RaceNo.'</span>';
  1199.                 $html .= '</div>';
  1200.                 $html .= '</div>';
  1202.                 $html .= '<table class="table table-responsive" style="width: 100%;"><thead><tr><th style="width: 30px;">#</th><th>Navn</th><th style="width: 120px;text-align: right;">V-Odds</th></tr></thead><tbody>';
  1203.                 $n = 0;
  1204.                 foreach ($x->OddsInfo->WinPlaceOdds->WinPlaceOdds as $y){
  1205.                     $attrY = $y->StartInfo->attributes();
  1206.                     $html .= '<tr>';
  1207.                     $html .= '<td>'.$attrY['StartNo'].'</td><td>'.$x->Starts->Start[$n]->Horse->Name.'</td><td style="width: 120px;text-align: right;">'.$y->WinOdds.'</td></tr>';
  1208.                     $n++;
  1209.                 }
  1210.                 $html .= '</tbody></table>';
  1211.                 $html .= '</div>';
  1212.             }
  1213.             fclose($h);
  1214.             ftp_close($conn_id);
  1215.         }
  1216.         else
  1217.         {
  1218.             $xml = '';
  1219.         }
  1220.       return new Response($html);
  1221.     }
  1223.     /**
  1224.      * @Route("/rss", name="app_rss")
  1225.      */
  1226.     public function rss()
  1227.     {
  1229.         $months = array('', 'januar', 'februar', 'mars', 'april', 'mai', 'juni', 'juli', 'august', 'september', 'oktober', 'november', 'desember');
  1230.         $days = array('', 'mandag', 'tirsdag', 'onsdag', 'torsdag', 'fredag', 'lørdag', 'søndag');
  1232.         $products = $this->getDoctrine()->getRepository(Races::class)->listAllObjects();
  1233.         $legtypes = $this->getDoctrine()->getRepository(Races::class) ->getLegTypes();
  1236.         if($products){
  1237.             $traName = 'All tracks';
  1238.             $articleContent = 'Info for all tracks';
  1239.         } else {
  1240.             $traName = 'No info';
  1241.             $articleContent = '';
  1242.         }
  1244.         // menue arrays to this one
  1245.         return $this->render('rss.xml.twig', [
  1246.             'title' =>  $traName,
  1247.             'articleContent' => $articleContent,
  1248.             'dbData' => $traName,
  1249.             'all' => $products,
  1250.             'leg' => $legtypes,
  1251.             'months' => $months,
  1252.             'days' => $days,
  1253.         ]);
  1255.     }
  1258.     /**
  1259.      * @Route("/kikkerten/{id}", name="app_kikkerten")
  1260.      */
  1261.     public function kikkerten($id){
  1263.         $allowed = self::cookie();
  1265.         if(!$allowed){ return $this->redirect('https://tgn.no/hestefakta-tips-og-spill/'); }
  1267.         $kikkerten = $this->getDoctrine()->getRepository(Binocular::class)->find($id);
  1269.         return $this->render('pages/kikkerten.html.twig', [
  1270.             'binocular' =>  $kikkerten,
  1271.             'tittel' => ''
  1272.         ]);
  1274.     }
  1276. }