src/Controller/CourseController.php line 312

Open in your IDE?
  1. <?php
  3. namespace App\Controller;
  5. use App\Form\CourseCreateForm;
  6. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  7. use Symfony\Component\HttpFoundation\Response;
  8. use Symfony\Component\HttpFoundation\Request;
  9. use Symfony\Component\Routing\Annotation\Route;
  10. use Symfony\Component\Security\Http\Authentication\AuthenticationUtils;
  11. use Symfony\Component\HttpFoundation\Session\Session;
  12. use Symfony\Component\HttpFoundation\RequestStack;
  14. use App\Entity\Article;
  15. use App\Entity\ArticleImages;
  16. use App\Entity\Cart;
  17. use App\Entity\CategoryImages;
  18. use App\Entity\CategoryCostplace;
  19. use App\Entity\CourseAdditionalTimes;
  20. use App\Entity\CourseAddPerson;
  21. use App\Entity\CourseCategories;
  22. use App\Entity\CoursePlace;
  23. use App\Entity\CourseTimes;
  24. use App\Entity\CourseImages;
  25. use App\Entity\Course;
  26. use App\Entity\CostPlace;
  27. use App\Entity\Discount;
  28. use App\Entity\ManualAppointment;
  29. use App\Entity\OrderItems;
  30. use App\Entity\Orders;
  31. use App\Entity\User;
  32. use App\Entity\UserCostplace;
  33. use App\Entity\Userlog;
  34. use App\Entity\TrainerPayment;
  35. use App\Entity\Resource;
  37. class CourseController extends AbstractController
  38. {
  39.     private $requestStack;
  41.     public function __construct(RequestStack $requestStack)
  42.     {
  43.         $this->requestStack = $requestStack;
  45.         // Accessing the session in the constructor is *NOT* recommended, since
  46.         // it might not be accessible yet or lead to unwanted side-effects
  47.         // $this->session = $requestStack->getSession();
  48.     }
  50.     function getUsedSlots($id)
  51.     {
  53.         $alreadyUsed = 0;
  54.         $alreadyUsed2 = 0;
  55.         $offline = 0;
  56.         $online = 0;
  57.         
  58.         
  59.         $repository = $this->getDoctrine()->getRepository(orderItems::class);
  60.         $orderItems = $repository->findBy(['oi_tid' => $id ]);
  61.         foreach($orderItems as $o)
  62.         {
  63.         
  64.             $repository = $this->getDoctrine()->getRepository(Orders::class);
  65.             $order = $repository->findOneBy(['id' => $o->getOiOid() ]);
  66.             if($order->getOStatus() == '2'){continue;}
  67.             $pay = $order->getOPayment();
  68.             
  69.             if($pay == '5')
  70.             {
  71.                 $offline++;
  72.             }
  73.             else 
  74.             {
  75.                 $online++;
  76.             }
  78.             if($this->get('security.token_storage')->getToken()->getUser() == 'anon.')
  79.             {
  80.                 if($pay == '5')
  81.                 {
  82.                     continue;
  83.                 }
  84.             }
  85.             else
  86.             {
  88.                 $uid = $this->get('security.token_storage')->getToken()->getUser();
  89.                 $role = $uid->getURole();
  91.                 if($pay == '5' && ($role == 1 || $role == 2) )
  92.                 {
  93.                     continue;
  94.                 }
  95.             }
  97.             $alreadyUsed = $alreadyUsed + ($o->getOiAmount());
  98.         }
  99.         $em = $this->getDoctrine()->getManager();
  100.         $repo2Articles = $em->getRepository(ManualAppointment::class);
  101.         $alreadyUsed2 = $repo2Articles->createQueryBuilder('ma')
  102.         ->select('count(ma.ma_tid)')
  103.         ->where('ma.ma_tid = '. $id)
  104.         ->getQuery()
  105.         ->getSingleScalarResult();
  106.         
  107.         
  108.         $online = $online + $alreadyUsed2;
  109.         
  110.         /*
  111.         $repository = $this->getDoctrine()->getRepository(courseTimes::class);
  112.         $times = $repository->findOneBy(['id' => $id ]);
  113.         $times->setCttOfflineCustomer($offline);
  114.         $times->setCttOnline($online);
  115.         $em->persist($times);
  116.         $em->flush();
  117.         */
  119.         return intval($alreadyUsed + $alreadyUsed2);
  121.     }
  123.     public function checkHoliday($datum) {
  124.         if(function_exists("easter_date")) {
  125.             $teile = explode(".", $datum);
  126.             $tag = intval($teile[0]);
  127.             $monat = intval($teile[1]);
  128.             $jahr = intval($teile[2]);    
  129.             $ostersonntag = date("d.m.Y", easter_date($jahr));
  130.             $osterteile = explode(".", $ostersonntag);
  131.             $ostertag = intval($osterteile[0]);
  132.             $ostermonat = intval($osterteile[1]);
  133.             $karfreitag = date("d.m.Y", mktime(0, 0, 0, $ostermonat, ($ostertag - 2), $jahr));
  134.             $karfreitagteile = explode(".", $karfreitag);
  135.             $karfreitagtag = intval($karfreitagteile[0]);
  136.             $karfreitagmonat = intval($karfreitagteile[1]);
  137.             $ostermontag = date("d.m.Y", mktime(0, 0, 0, $ostermonat, ($ostertag + 1), $jahr));
  138.             $ostermontagteile = explode(".", $ostermontag);
  139.             $ostermontagtag = intval($ostermontagteile[0]);
  140.             $ostermontagmonat = intval($ostermontagteile[1]);
  141.             $christihfahrt = date("d.m.Y", mktime(0, 0, 0, $ostermonat, ($ostertag + 39), $jahr));
  142.             $christihfahrtteile = explode(".", $christihfahrt);
  143.             $christihfahrttag = intval($christihfahrtteile[0]);
  144.             $christihfahrtmonat = intval($christihfahrtteile[1]);
  145.             $pfingsten = date("d.m.Y", mktime(0, 0, 0, $ostermonat, ($ostertag + 50), $jahr));
  146.             $pfingstenteile = explode(".", $pfingsten);
  147.             $pfingstentag = intval($pfingstenteile[0]);
  148.             $pfingstenmonat = intval($pfingstenteile[1]);
  149.             $fronleichnam = date("d.m.Y", mktime(0, 0, 0, $ostermonat, ($ostertag + 60), $jahr));
  150.             $fronleichnamteile = explode(".", $fronleichnam);
  151.             $fronleichnamtag = intval($fronleichnamteile[0]);
  152.             $fronleichnammonat = intval($fronleichnamteile[1]);
  153.             $feiertext = "";
  154.             if($tag == 1 && $monat == 1) {
  155.                 $feiertext = "Neujahr";
  156.             }
  157.             if($tag == $karfreitagtag && $monat == $karfreitagmonat) {
  158.                 if($feiertext != "") $feiertext.= " und ";
  159.                 $feiertext.= "Karfreitag";
  160.             } 
  161.             if($tag == $ostertag && $monat == $ostermonat) {
  162.                 if($feiertext != "") $feiertext.= " und ";
  163.                 $feiertext.= "Ostersonntag";
  164.             }
  165.             if($tag == $ostermontagtag && $monat == $ostermontagmonat) {
  166.                 if($feiertext != "") $feiertext.= " und ";
  167.                 $feiertext.= "Ostermontag";
  168.             }
  169.             if($tag == 1 && $monat == 5) {
  170.                 if($feiertext != "") $feiertext.= " und ";
  171.                 $feiertext.= "Tag der Arbeit";
  172.             }
  173.             if($tag == $christihfahrttag && $monat == $christihfahrtmonat) {
  174.                 if($feiertext != "") $feiertext.= " und ";
  175.                 $feiertext.= "Christi Himmelfahrt";
  176.             }
  177.             if($tag == $pfingstentag && $monat == $pfingstenmonat) {
  178.                 if($feiertext != "") $feiertext.= " und ";
  179.                 $feiertext.= "Pfingstmontag";
  180.             }
  181.             if($tag == 3 && $monat == 10) {
  182.                 if($feiertext != "") $feiertext.= " und ";
  183.                 $feiertext.= "Tag der deutschen Einheit";
  184.             }
  185.             if($tag == 25 && $monat == 12) {
  186.                 if($feiertext != "") $feiertext.= " und ";
  187.                 $feiertext.= "Erster Weihnachtstag";
  188.             }
  189.             if($tag == 26 && $monat == 12) {
  190.                 if($feiertext != "") $feiertext.= " und ";
  191.                 $feiertext.= "Zweiter Weihnachtstag";
  192.             }
  193.             if($feiertext != "") {
  194.                 return $feiertext;
  195.             } else {
  196.                 return false;
  197.             }
  198.         } else {
  199.             return false;
  200.         }
  201.     }
  205.     /**
  206.      * @Route("/", name="homepage")
  207.      */
  208.     public function homepage()
  209.     {
  210.         require_once("./include/global.php");
  211.         
  212.         $em = $this->getDoctrine()->getManager();   
  213.        
  214.         if(!$this->requestStack->getSession())
  215.         {
  216.             $session = new Session();
  217.             $session->start();
  218.         }
  219.         
  220.         $repository = $this->getDoctrine()->getRepository(Cart::class);
  221.         $cart = $repository->findAll();
  222.         foreach($cart as $ca)
  223.         {
  224.             $time = $ca->getCaNow()->format('Y-m-d H:i:s');
  225.             $time = date("Y-m-d H:i:s",strtotime($time));
  226.             if($time < date("Y-m-d H:i:s",strtotime("-".$cartMaxTime." Minutes"))  )
  227.             {
  228.                 if($ca && $ca != null && is_null($ca) == false )
  229.                 {
  230.                     $em->remove($ca);
  231.                     $em->flush();
  232.                 }
  233.             }
  234.         }
  236.         $repository = $this->getDoctrine()->getRepository(CourseCategories::class);
  237.         $categories = $repository->findAll();
  239.         $repository = $this->getDoctrine()->getRepository(CategoryImages::class);
  240.         $categoryImages = $repository->findAll();
  242.         $categoryImgArr = array();
  243.         foreach($categoryImages as $catIm)
  244.         {
  245.             $categoryImgArr[$catIm->getCaiCatid()] = $catIm->getCaiPath();
  246.         }
  248.         $session = $this->requestStack->getSession(); //$session = $this->get('session');
  249.         $session->clear();
  250.         $session->invalidate();
  251.         
  252.         require_once("./include/global.php");
  253.         
  254.         if($company == 'KVO')
  255.         {
  256.     //      return $this->render('course/index.html.twig', ['places' => $costplacePlace, 'categories' => $categories]);
  257.             $placeid = 1;
  258.             $session = $this->requestStack->getSession(); //$session = $this->get('session');
  259.             $session->set('place', $placeid);
  260.             return $this->render('course/index.html.twig', ['places' => $costplacePlace, 'categories' => $categories, 'placeid' => '1', 'url' => $url, "catimg" => $categoryImgArr, 'anzProd' => $globAmnProd]);
  261.     
  262.         }
  263.         else
  264.         {
  265.             return $this->render('course/place.html.twig', ['places' => $costplacePlace, 'categories' => $categories]);
  266.         }
  267.     }
  268.    
  269.     /**
  270.      * @Route("/place/{placeid}/", name="homepage2")
  271.      */
  272.     public function homepage2($placeid)
  273.     {
  274.         include("./include/global.php");
  275.         
  276.         $dir = "./tmp/";
  277.         if(!is_dir($dir)){ mkdir($dir); }
  278.         foreach (glob($dir."*") as $file) 
  279.         {
  280.             if(time() - filemtime($file) > 300)
  281.             {
  282.                 unlink($file);
  283.             }
  284.         }
  286.         $em = $this->getDoctrine()->getManager();   
  287.        
  288.         $query = "UPDATE orders SET o_xml_export = 0 WHERE o_xml_file = '' AND o_xml_export = 1 AND o_xml_storno_file = '' AND o_payment = 2 AND o_price_netto != 0  ";
  289.         $em2 = $this->getDoctrine()->getManager();   
  290.         $em2->getConnection()->executeQuery($query);
  292.         $query = "UPDATE orders SET o_xml_storno_export = 0 WHERE o_xml_storno_file = '' AND o_xml_storno_export = 1  AND o_price_netto != 0 AND o_xml_file = '' AND o_payment = 2  ";
  293.         $em2 = $this->getDoctrine()->getManager();   
  294.         $em2->getConnection()->executeQuery($query);
  295.         $repository = $this->getDoctrine()->getRepository(Coursetimes::class);
  296.         $coursetimes = $repository->findBy(['ctt_active' => 1]);
  297.         foreach($coursetimes as $ctt)
  298.         {
  299.             if($ctt->getCttCid() == '776'){continue;}
  300.             $d = $ctt->getCttDay();
  301.             $d = $d->format('Y-m-d'); 
  302.             
  303.             if($d < date("Y-m-d"))
  304.             {
  305.                 $ctt->setCttActive(0);
  306.                 $em->persist($ctt);
  307.                 $em->flush();
  308.             }
  310.         }
  311.         
  312.         if(!$this->requestStack->getSession())
  313.         {
  314.             $session = new Session();
  315.             $session->start();
  316.         }
  317.         
  318.         $repository = $this->getDoctrine()->getRepository(Cart::class);
  319.         $cart = $repository->findAll();
  320.         foreach($cart as $ca)
  321.         {
  322.             $time = $ca->getCaNow()->format('Y-m-d H:i:s');
  323.             $time = date("Y-m-d H:i:s",strtotime($time));
  324.             if($time < date("Y-m-d H:i:s",strtotime("-".$cartMaxTime." Minutes"))  )
  325.             {
  326.                 if($ca && $ca != null && is_null($ca) == false )
  327.                 {
  328.                     $em->remove($ca);
  329.                     $em->flush();
  330.                 }
  331.             }
  332.         }
  333.         
  335.         $repository = $this->getDoctrine()->getRepository(Course::class);
  336.         $courses = $repository->findBy(['c_active' => 1]);
  337.         foreach($courses as $c)
  338.         {
  339.             $courseActive = 0;
  340.             $repository = $this->getDoctrine()->getRepository(CourseTimes::class);
  341.             $courseTimes = $repository->findBy(['ctt_cid' => $c->getId(), 'ctt_active' => 1]);
  342.             foreach($courseTimes as $ctt)
  343.             {
  344.                 if($ctt->getCttMaxoffline() == $ctt->getCttOfflineCustomer() && $ctt->getCttOnline() == $ctt->getCttMaxonline())
  345.                 {
  346.                     $ctt->setCttActive(0);
  347.                     $em = $this->getDoctrine()->getManager();
  348.                     $em->persist($ctt);
  349.                     $em->flush();
  350.                 }
  351.                 else 
  352.                 {
  353.                     $courseActive = 1;
  354.                 }
  355.             }
  357.             if($courseActive == 0)
  358.             {
  360.                 $c->setCActive(0);
  361.                 $em = $this->getDoctrine()->getManager();
  362.                 $em->persist($c);
  363.                 $em->flush();
  364.             }
  365.         }
  368.         $repository = $this->getDoctrine()->getRepository(CourseCategories::class);
  369.         $categories = $repository->findAll();
  370.         
  371.         $repository = $this->getDoctrine()->getRepository(CategoryImages::class);
  372.         $categoryImages = $repository->findAll();
  373.         
  374.         $repository = $this->getDoctrine()->getRepository(CategoryCostplace::class);
  375.         $categoryCostplaces = $repository->findBy(['cc_cpid' => $placeid]);
  377.         $categoryImgArr = array();
  378.         foreach($categoryImages as $catIm)
  379.         {
  380.             $categoryImgArr[$catIm->getCaiCatid()] = $catIm->getCaiPath();
  381.         }
  383.         $allowedCat = array();
  384.         foreach($categoryCostplaces as $ccp)
  385.         {
  386.             $allowedCat[$ccp->getCcCatid()] = $ccp->getCcActive();
  387.         }
  389.         
  390.         if($company == 'KVO')
  391.         {
  392.             $placeid = 1;
  393.         }
  395.         $session = $this->requestStack->getSession(); //$session = $this->get('session');
  396.         $session->set('place', $placeid);
  397.         
  398.         return $this->render('course/index.html.twig', ['places' => $costplacePlace, 'categories' => $categories, 'placeid' => $placeid, 'url' => $url, "catimg" => $categoryImgArr, 'anzProd' => $globAmnProd, 'allowedCat' => $allowedCat]);
  399.     }
  401.     /**
  402.      * @Route("/setTimesStatus", name="setTimesStatus" , options={"expose"=true})
  403.      */
  404.     public function setTimesStatus()
  405.     {
  406.         if($this->get('security.token_storage')->getToken()->getUser() == 'anon.')
  407.         {
  408.             $response = $this->forward('App\Controller\CourseController::homepage', []);
  409.             return $response;
  410.         }
  412.         require_once("./include/global.php");
  414.         $repository = $this->getDoctrine()->getRepository(CourseTimes::class);
  415.         $times = $repository->findOneBy(['id' => $_POST['id']]);
  417.         if($times->getCttActive() == 1)
  418.         {
  419.             $times->setCttActive(0);
  420.         }
  421.         else
  422.         {
  423.             $times->setCttActive(1);
  424.         }
  425.         $em = $this->getDoctrine()->getManager();
  426.         $em->persist($times);
  427.         $em->flush();
  428.  
  429.        echo '';
  430.        die();
  431.     }
  433.     /**
  434.      * @Route("/backendCourseBlock/{id}", name="backendCourseBlock")
  435.      */
  436.     public function backendCourseBlock($id)
  437.     {
  438.         if($this->get('security.token_storage')->getToken()->getUser() == 'anon.')
  439.         {
  440.             $response = $this->forward('App\Controller\CourseController::homepage', []);
  441.             return $response;
  442.         }
  444.         require_once("./include/global.php");
  446.         $repository = $this->getDoctrine()->getRepository(Course::class);
  447.         $course = $repository->findOneBy(['id' => $id]);
  448.  
  449.         return $this->render('backend/course/course_block.html.twig', ['id' => $id, 'course' => $course , 'today' => date("d.m.Y")]);
  450.     }
  451.    
  452.     /**
  453.      * @Route("/loadBlockTimes", name="loadBlockTimes" , options={"expose"=true})
  454.      */
  455.     public function loadBlockTimes()
  456.     {
  457.         if($this->get('security.token_storage')->getToken()->getUser() == 'anon.')
  458.         {
  459.             $response = $this->forward('App\Controller\CourseController::homepage', []);
  460.             return $response;
  461.         }
  463.         require_once("./include/global.php");
  465.         $date = date("Y-m-d",strtotime($_POST['date']));
  466.         $id = $_POST['id']; 
  468.         $d = new \DateTime(date('Y-m-d',strtotime($date)));
  470.         $repository = $this->getDoctrine()->getRepository(CourseTimes::class);
  471.         $times = $repository->findBy(['ctt_cid' => $id, 'ctt_day' => $d], ['ctt_from' => 'ASC']);
  473.         $output = '';
  476.         $i = 0;
  477.         foreach($times as $time)
  478.         {
  479.             $nd1 = $time->getCttFrom();
  480.             $nd1 = $nd1->format('H:i'); 
  482.             $nd2 = $time->getCttTo();
  483.             $nd2 = $nd2->format('H:i'); 
  485.             if($time->getCttActive() == '0')
  486.             {
  487.                 $output .= '<input class="btn-check" type="button" name="articleTime" id="articleTime'.$i.'" value="'.$time->getid().'" autocomplete="off" onclick="setTimeStatus(\''.$time->getId().'\')" />';
  488.                 $output .= '<label class="btn btn-secondary" for="articleTime'.$i.'" style="'.$defaultColor.'">'.$nd1.' - '.$nd2.'</label> &nbsp;';
  489.             }
  490.             else
  491.             {
  492.                 $output .= '<input class="btn-check" type="button" name="articleTime" id="articleTime'.$i.'" value="'.$time->getid().'" autocomplete="off" onclick="setTimeStatus(\''.$time->getId().'\')" />';
  493.                 $output .= '<label class="btn btn-success" for="articleTime'.$i.'" style="'.$defaultColor.'">'.$nd1.' - '.$nd2.'</label> &nbsp;';
  494.             }
  495.             $i++;
  496.         }
  498.         if(trim($output) == ''){$output = "Es wurden leider keine Eintr&auml;ge gefunden";}
  499.         echo $output;die();
  500.     }
  502.     /**
  503.      * @Route("/backendCourse/", name="backendCourse")
  504.      */
  505.     public function backendCourse()
  506.     {
  507.         if($this->get('security.token_storage')->getToken()->getUser() == 'anon.')
  508.         {
  509.             $response = $this->forward('App\Controller\CourseController::homepage', []);
  510.             return $response;
  511.         }
  513.         require_once("./include/global.php");
  514.         require_once("./include/function.php");
  516.         $uid = $this->get('security.token_storage')->getToken()->getUser();
  517.         $role = $uid->getURole();
  518.         $uid = $uid->getId();
  520.         if($role == 4)
  521.         {
  523.             $repository = $this->getDoctrine()->getRepository(CourseCategories::class);
  524.             $categories = $repository->findAll();
  525.             
  526.             $query = "SELECT * FROM course WHERE c_active = 1";
  527.             $em2 = $this->getDoctrine()->getManager();   
  528.             $course = $em2->getConnection()->executeQuery($query);
  529.             $course2 = $em2->getConnection()->executeQuery($query);
  531.             
  532.             $query = "SELECT * FROM article WHERE a_active = 1";
  533.             $em2 = $this->getDoctrine()->getManager();   
  534.             $articles = $em2->getConnection()->executeQuery($query);
  536.         }
  537.         else
  538.         {
  539.             $repository = $this->getDoctrine()->getRepository(CourseCategories::class);
  540.             $categories = $repository->findAll();
  541.             
  542.             $userArr = array();
  543.             $repository = $this->getDoctrine()->getRepository(UserCostplace::class);
  544.             $userCostplace = $repository->findBy(['ucp_uid' => $uid]);
  545.             foreach($userCostplace as $cp)
  546.             {
  547.                 array_push($userArr,$cp->getUcpPlace());
  548.             }
  549.             array_unique($userArr);
  551.             $repository = $this->getDoctrine()->getRepository(Costplace::class);
  552.             $costplace = $repository->findAll();
  554.             $filter = "";
  555.             $filter2 = "";
  556.             $param = array();
  557.             $i = 0;
  558.             foreach($costplace as $cp)
  559.             {
  561.                 if(in_array($cp->getCpPlace(),$userArr ))
  562.                 {
  563.                     if($i == 0)
  564.                     {
  565.                         $filter .= "c_costplace = :costplace".$i;
  566.                         $filter2 .= "a_costplace = :costplace".$i;
  567.                         
  568.                     }
  569.                     else
  570.                     {
  571.                         $filter .= " OR c_costplace = :costplace".$i;
  572.                         $filter2 .= " OR a_costplace = :costplace".$i;
  573.                     }
  575.                     $param["costplace$i"] = $cp->getId();
  576.                     $i++;
  577.                 }
  578.             }
  580.             if($filter == ""){ $filter = " 1 = 2 ";}
  581.             if($filter2 == ""){ $filter2 = " 1 = 2 ";}
  583.             $query = "SELECT * FROM course WHERE c_active = 1 AND ($filter)";
  584.             $em2 = $this->getDoctrine()->getManager();   
  585.             $course = $em2->getConnection()->executeQuery($query,$param);
  586.             $course2 = $em2->getConnection()->executeQuery($query,$param);
  588.             if($filter2 != "")
  589.             {
  590.                 $query = "SELECT * FROM article WHERE a_active = 1 AND ($filter2)";
  591.             }
  592.             $em2 = $this->getDoctrine()->getManager();   
  593.             $articles = $em2->getConnection()->executeQuery($query,$param);
  595.         }
  596.         
  597.         $minArr = array();
  598.         $maxArr = array();
  599.         foreach($course2 as $c)
  600.         {
  601.             $repository = $this->getDoctrine()->getRepository(CourseTimes::class);
  602.             $min = $repository->findOneBy(['ctt_cid' => $c['id']],['ctt_day' => 'ASC']);
  604.             $repository = $this->getDoctrine()->getRepository(CourseTimes::class);
  605.             $max = $repository->findOneBy(['ctt_cid' => $c['id']],['ctt_day' => 'DESC']);
  606.             if($min)
  607.             {    
  608.                 $minArr[$min->getCttCid()] = $min->getCttDay()->format("d.m.Y");
  609.             }
  610.             if($max)
  611.             {
  612.                 $maxArr[$max->getCttCid()] = $max->getCttDay()->format("d.m.Y");
  613.             }
  614.             
  615.         }
  616.         
  617.         if(!isset($globalPeriods))
  618.         {
  619.             $globalPeriods[1] = "1. Trimester";
  620.             $globalPeriods[2] = "2. Trimester";
  621.             $globalPeriods[3] = "3. Trimester";
  622.             $globalPeriods[4] = "4. Trimester";
  623.             $globalPeriods[5] = "Osterferien";
  624.             $globalPeriods[6] = "Sommerferien";
  625.             $globalPeriods[7] = "Herbstferien";
  626.             $globalPeriods[8] = "Sonstiges";
  627.         }
  629.         return $this->render('backend/course/course.html.twig',[ 'courses' => $course, 'categories' => $categories, 'articles' => $articles, 'min' => $minArr , 'max' => $maxArr, 'periods' => $globalPeriods ]);
  630.     }
  632.     /**
  633.      * @Route("/deleteCourse", name="deleteCourse" , options={"expose"=true})
  634.      */
  635.     public function deleteCourse()
  636.     {
  637.         if($this->get('security.token_storage')->getToken()->getUser() == 'anon.')
  638.         {
  639.             $response = $this->forward('App\Controller\CourseController::homepage', []);
  640.             return $response;
  641.         }
  643.         
  644.         if($_POST['mode'] == '1')
  645.         {
  647.             $repository = $this->getDoctrine()->getRepository(Course::class);
  648.             $course = $repository->findOneBy(['id' => $_POST['id']]);
  649.             $course->setCActive(0);
  650.             $em = $this->getDoctrine()->getManager();
  651.             $em->persist($course);
  652.             $em->flush();
  653.         }
  654.         else if($_POST['mode'] == '2')
  655.         {
  656.             $repository = $this->getDoctrine()->getRepository(Article::class);
  657.             $article = $repository->findOneBy(['id' => $_POST['id']]);
  658.             
  659.             $article->setAActive(0);
  660.             $em = $this->getDoctrine()->getManager();
  661.             $em->persist($article);
  662.             $em->flush();
  664.         }
  665.             
  666.         
  667.         die();
  668.     }
  670.     /**
  671.      * @Route("/copyCourse/{id}/{mode}", name="copyCourse")
  672.      */
  673.     public function copyCourse($id, $mode)
  674.     {
  675.         include("./include/global.php");
  676.         if($this->get('security.token_storage')->getToken()->getUser() == 'anon.')
  677.         {
  678.             $response = $this->forward('App\Controller\CourseController::homepage', []);
  679.             return $response;
  680.         }
  682.         /*      
  683.         $repository = $this->getDoctrine()->getRepository(User::class);
  684.         $trainer = $repository->findBy(["u_role" => "2", "u_locked" => '0']);
  685.         */
  686.         $repository = $this->getDoctrine()->getRepository(CourseCategories::class);
  687.         $categories = $repository->findAll();
  689.         $repository = $this->getDoctrine()->getRepository(Discount::class);
  690.         $discount = $repository->findAll();
  692.         $repository = $this->getDoctrine()->getRepository(User::class);
  693.         $trainer = $repository->findBy(["u_role" => "2", "u_locked" => '0'],['u_lastname' => 'ASC']);
  694.         
  695.         $repository = $this->getDoctrine()->getRepository(Resource::class);
  696.         $rooms = $repository->findAll();
  697.        
  699.         if($mode == '1')
  700.         {
  701.             //course
  702.             $repository = $this->getDoctrine()->getRepository(Course::class);
  703.             $course = $repository->findOneBy(['id' => $id]);
  704.             
  705.             $repository = $this->getDoctrine()->getRepository(CostPlace::class);
  706.             $costplaces = $repository->findAll();
  709.             return $this->render('backend/course/course_new.html.twig',[  'categories' => $categories, 'course' => $course,  'mode' => $mode, 'url' => $url, 'copy' => 1, 'costplaces' => $costplaces, 'discount' => $discount, 'trainer' => $trainer, 'company' => $company, 'rooms' => $rooms, 'periods' => $globalPeriods ]);
  710.         }
  711.         else
  712.         {
  713.             //article 
  714.             $repository = $this->getDoctrine()->getRepository(Article::class);
  715.             $article = $repository->findOneBy(['id' => $id]);
  716.             
  717.             return $this->render('backend/course/course_new.html.twig',[  'categories' => $categories, 'article' => $article,  'mode' => $mode, 'url' => $url, 'copy' => 1, 'discount' => $discount, 'trainer' => $trainer, 'company' => $company, 'rooms' => $rooms ]);
  718.         }
  719.         
  720.     }
  722.     /**
  723.      * @Route("/backendCourseNew/", name="backendCourseNew")
  724.      */
  725.     public function backendCourseNew()
  726.     {
  727.         include("./include/global.php");
  728.         include("./include/function.php");
  729.         if($this->get('security.token_storage')->getToken()->getUser() == 'anon.')
  730.         {
  731.             $response = $this->forward('App\Controller\CourseController::homepage', []);
  732.             return $response;
  733.         }
  736.         $repository = $this->getDoctrine()->getRepository(CourseCategories::class);
  737.         $categories = $repository->findAll();
  738.         
  739.         $repository = $this->getDoctrine()->getRepository(CostPlace::class);
  740.         $costplaces = $repository->findAll();
  741.          
  742.         $repository = $this->getDoctrine()->getRepository(User::class);
  743.         $trainer = $repository->findBy(["u_role" => "2", "u_locked" => '0'],['u_lastname' => 'ASC']);
  744.         
  747.         $number = 0;
  748.         $maxnumber = 0;
  749.         $query = "SELECT c_number FROM course WHERE c_number LIKE :year ";
  750.         $em2 = $this->getDoctrine()->getManager();   
  751.         $resultSet = $em2->getConnection()->executeQuery($query,['year' => date("y").'%' ]);
  752.         
  753.         foreach($resultSet as $rs)
  754.         {
  755.             $tmp = substr($rs['c_number'],-3);
  756.             if(intval($tmp) > $maxnumber){ $maxnumber = $tmp; }
  757.         }
  759.         $month = date("m");
  760.         $maxnumber = $maxnumber+1;
  763.         if($maxnumber < 10 )
  764.         {
  765.             $maxnumber = "00".$maxnumber;
  766.         }
  767.         else if($maxnumber < 100)
  768.         {
  769.             $maxnumber = "0".$maxnumber;
  770.         }
  772.         if($month  <= 4){ $number = date("y")."1".$maxnumber; }
  773.         else if($month >= 9){$number = date("y")."3".$maxnumber ;}
  774.         else{ $number = date("y")."2".$maxnumber; }
  776.         $repository = $this->getDoctrine()->getRepository(Resource::class);
  777.         $rooms = $repository->findAll();
  778.        
  779.         $repository = $this->getDoctrine()->getRepository(Discount::class);
  780.         $discount = $repository->findAll();
  782.         return $this->render('backend/course/course_new.html.twig',[  'categories' => $categories, 'url' => $url, 'costplaces' => $costplaces, 'trainer' => $trainer, 'coursenumber2' => $number, 'company' => $company, 'rooms' => $rooms, 'discount' => $discount, 'periods' => $globalPeriods  ]);
  783.     }
  785.     /**
  786.     * @Route("/backendEditCourse/{id}/{mode}", name="backendEditCourse")
  787.     */
  788.     public function backendEditCourse($id,$mode)
  789.     {
  790.         include("./include/global.php");
  791.         if($this->get('security.token_storage')->getToken()->getUser() == 'anon.')
  792.         {
  793.             $response = $this->forward('App\Controller\CourseController::homepage', []);
  794.             return $response;
  795.         }
  797.         if($mode == 1)
  798.         {
  799.             $repository = $this->getDoctrine()->getRepository(Course::class);
  800.             $course = $repository->findBy(['id' => $id]);
  802.             $repository = $this->getDoctrine()->getRepository(CourseImages::class);
  803.             $images = $repository->findBy(['ci_cid' => $id]);
  804.         }
  805.         else if($mode == 2)
  806.         {
  807.             $repository = $this->getDoctrine()->getRepository(Article::class);
  808.             $article = $repository->findBy(['id' => $id]);
  810.             $repository = $this->getDoctrine()->getRepository(ArticleImages::class);
  811.             $images = $repository->findBy(['ai_aid' => $id]);
  812.         }
  814.         $repository = $this->getDoctrine()->getRepository(CostPlace::class);
  815.         $costplaces = $repository->findAll();
  817.         $repository = $this->getDoctrine()->getRepository(CourseCategories::class);
  818.         $categories = $repository->findAll();
  820.         $repository = $this->getDoctrine()->getRepository(Resource::class);
  821.         $rooms = $repository->findAll();
  823.         $repository = $this->getDoctrine()->getRepository(Discount::class);
  824.         $discount = $repository->findAll();
  826.         if($mode == 1)
  827.         {
  828.             $repository = $this->getDoctrine()->getRepository(CourseAdditionalTimes::class);
  829.             $addTimes = $repository->findBy(['cat_cid' => $id]);
  831.             $atArr = array();
  832.             $atArr['number'] = "0";
  833.             $atArr['from'] = "00:00";
  834.             $atArr['to'] = "00:00";
  835.             $atArr['days'] = "";
  836.             $atArr['leader'] = "0";
  837.             $atArr['booking'] = "0";
  838.             $atArr['offline'] = "0";
  839.             $atArr['online'] = "0";
  840.             foreach($addTimes as $at)
  841.             {
  842.                 if($at->getCatItem() == '0')
  843.                 {
  845.                     $atArr['number'] = $at->getCatNumber();
  846.                     $atArr['from'] = $at->getCatFrom()->format('H:i');
  847.                     $atArr['to'] = $at->getCatTo()->format('H:i');
  848.                     $atArr['days'] = $at->getCatDays();
  849.                     $atArr['leader'] = $at->getCatLeader();
  850.                     $atArr['booking'] = $at->getCatBookingOption();
  851.                     $atArr['offline'] = $at->getCatMaxOffline();
  852.                     $atArr['online'] = $at->getCatMaxOnline();
  854.                 }
  855.             }
  857.             $repository = $this->getDoctrine()->getRepository(User::class);
  858.             $trainer = $repository->findBy(["u_role" => "2", "u_locked" => '0'],['u_lastname' => 'ASC']);
  860.             return $this->render('backend/course/course_edit.html.twig',[ 'categories' => $categories,'discount' => $discount,'at' => $atArr, 'rooms' => $rooms, 'course' => $course, 'image' =>  $images ,'id' => $id, 'mode' => $mode , 'url' => $url, 'addtimer' => $addTimes, 'costplaces' => $costplaces, 'trainer' => $trainer, 'company' => $company, 'periods' => $globalPeriods ]);
  861.         }
  862.         else if($mode == 2)
  863.         {
  864.             return $this->render('backend/course/course_edit.html.twig',[ 'categories' => $categories,'discount' => $discount,'rooms' => $rooms, 'article' => $article, 'image' =>  $images ,'id' => $id, 'mode' => $mode , 'url' => $url, 'costplaces' => $costplaces , 'company' => $company, 'periods' => $globalPeriods]);
  865.         }
  866.     }
  867.      
  868.     /**
  869.     * @Route("/backendCourseNewSave/", name="backendCourseNewSave")
  870.     */
  871.     public function backendCourseNewSave(Request $request)
  872.     {
  873.         include("./include/global.php");
  874.         include("./include/function.php");
  875.         if($this->get('security.token_storage')->getToken()->getUser() == 'anon.')
  876.         {
  877.             $response = $this->forward('App\Controller\CourseController::homepage', []);
  878.             return $response;
  879.         }
  881.         // save Course
  882.         
  883.         if($request->get('productKind') == '1' || $request->get('productKind') == 1)
  884.         {
  885.             $start = new \DateTime(date("H:i:s",strtotime($request->get('starttime'))));
  886.             $end = new \DateTime(date('H:i:s', strtotime($request->get('endtime'))));
  887.             $visible_from = new \DateTime(date('Y-m-d H:i:00', strtotime($request->get('visible_from'). ' '. $request->get('visible_time').':00')));
  889.             $price = str_replace(".","#",$request->get('price'));
  890.             $price = str_replace(",",".",$price);
  891.             $price = str_replace("#",",",$price);
  892.             $price = number_format($price,2,'.',',');
  893.            
  894.             $tax = number_format((float)$request->get('tax'),2,'.',',');
  895.             $adminFee = number_format((float)$request->get('admin_fee'),2,'.',',');
  897.             if($request->get('yoga') == null)
  898.             {
  899.                 $yoga = 0;
  900.             }
  901.             else
  902.             {
  903.                 $yoga = $request->get('yoga');
  904.             }
  906.             if($request->get('sibling_discount') == null)
  907.             {
  908.                 $siblingDiscount = 0;
  909.             }
  910.             else
  911.             {
  912.                 $siblingDiscount = $request->get('sibling_discount');
  913.             }
  915.             if($request->get('studio_discount') == null)
  916.             {
  917.                 $studioDiscount = 0;
  918.             }
  919.             else
  920.             {
  921.                 $studioDiscount = $request->get('studio_discount');
  922.             }
  923.             
  924.             if($request->get('visible') == null)
  925.             {
  926.                 $visible = 0;
  927.             }
  928.             else
  929.             {
  930.                 $visible = $request->get('visible');
  931.             }
  933.             if($request->get('discount') == null)
  934.             {
  935.                 $discount = 0;
  936.             }
  937.             else
  938.             {
  939.                 $discount = $request->get('discount');
  940.             }
  941.             if($discount == null){$discount = 0;}
  943.             $course = new Course();
  944.             $course->setCName($request->get('coursename'));
  945.             $course->setCVisible($visible);
  946.             $course->setCNumber($request->get('coursenumber'));
  947.             if( is_null($request->get('coursesbnumber')) )
  948.             {
  949.                 $course->setCSbNumber(0);
  950.             }
  951.             else
  952.             {
  953.                 $course->setCSbNumber($request->get('coursesbnumber'));
  954.             }
  956.             $course->setCLeader($request->get('courseleader'));
  957.             $course->setCCategory($request->get('coursecategory'));
  958.             $course->setCMaxcustomer($request->get('maxcustomer'));
  959.             $course->setCOfflineCustomer($request->get('offlinecustomer'));
  960.             $course->setCStart($start);
  961.             $course->setCEnd($end);
  962.             if( is_null($request->get('duration')) )
  963.             {
  964.                 $course->setCDuration(0);
  965.             }
  966.             else
  967.             {
  968.                 $course->setCDuration($request->get('duration'));
  969.             }
  970.             $course->setCBreakBefore($request->get('break_before'));
  971.             $course->setCBreakAfter($request->get('break_after'));
  972.             $course->setCDescription($request->get('description'));
  973.             $course->setCPrice($price);
  974.             $course->setCAdminFee( $adminFee );
  975.             $course->setCTax($tax);
  976.             $course->setCActive(1);
  977.             $course->setCDiscount($discount);
  978.             $course->setCSiblingDiscount($siblingDiscount);
  979.             $course->setCStudioDiscount($studioDiscount);
  981.             $course->setCPeriod($request->get('courseperiod'));
  983.             $course->setCVisibleFrom($visible_from);
  984.             
  985.             if($company == "KVO")
  986.             {
  987.                 $course->setCRoom($request->get('room'));
  988.             }
  989.             else
  990.             {
  991.                 $course->setCRoom(0);
  992.             }
  993.             $course->setCYoga($yoga);
  994.             $course->setCCostplace($request->get('costplace'));
  995.             $course->setCAppointmentSeries($request->get('series'));
  996.             $course->setCAppointmentSeriesDays($request->get('seriesDays'));
  997.         
  998.             $mon = $request->get('monday');
  999.             if(is_null($mon)) {$mon = 0;}
  1000.             $tue = $request->get('tuesday');
  1001.             if(is_null($tue)) {$tue = 0;}
  1002.             $wed = $request->get('wednesday');
  1003.             if(is_null($wed)) {$wed = 0;}
  1004.             $thu = $request->get('thursday');
  1005.             if(is_null($thu)) {$thu = 0;}
  1006.             $fri = $request->get('friday');
  1007.             if(is_null($fri)) {$fri = 0;}
  1008.             $sat = $request->get('saturday');
  1009.             if(is_null($sat)) {$sat = 0;}
  1010.             $sun = $request->get('sunday');
  1011.             if(is_null($sun)) {$sun = 0;}
  1013.             $course->setCMonday($mon);
  1014.             $course->setCTuesday($tue);
  1015.             $course->setCWednesday($wed);
  1016.             $course->setCThursday($thu);
  1017.             $course->setCFriday($fri);
  1018.             $course->setCSaturday($sat);
  1019.             $course->setCSunday($sun);
  1020.             
  1021.             $course->setCPlace(1);
  1023.             $d = new \DateTime(date('Y-m-d H:i:s',strtotime($request->get('activeUntill'))));
  1024.             $course->setCActiveUntill($d);
  1026.             $d2 = new \DateTime(date('Y-m-d H:i:s',strtotime($request->get('activeFrom'))));
  1027.             $course->setCActiveFrom($d2);
  1029.             $em = $this->getDoctrine()->getManager();
  1030.             $em->persist($course);
  1031.             $em->flush();
  1033.             $id = $course->getId();
  1035.             //save Images  
  1037.             $pic = $request->files->get('courseImage');
  1038.             $pic_full = $request->files->get('courseImageFull');
  1039.             
  1040.             $folder =  $this->getParameter('kernel.project_dir')."/public/courseImages/";
  1041.             if(!file_exists($folder)){mkdir($folder);}
  1042.             
  1043.             $subfolder = $folder.$id."/";
  1044.             if(!file_exists($subfolder)){mkdir($subfolder);}
  1046.             $uniqid = uniqid();
  1048.             $path = $subfolder.$uniqid."_".$pic->getClientOriginalName();
  1049.             if(file_exists($path)){unlink($path);}
  1051.             $newFilename = $uniqid.'_'.$pic->getClientOriginalName();
  1052.             $pic->move($subfolder, $newFilename);
  1054.             $uniqid = uniqid();
  1056.             $path2 = $subfolder.$uniqid."_".$pic_full->getClientOriginalName();
  1057.             if(file_exists($path2)){unlink($path2);}
  1059.             $newFilename2 = $uniqid.'_'.$pic_full->getClientOriginalName();
  1060.             $pic_full->move($subfolder, $newFilename2);
  1062.             $courseImages = new CourseImages();
  1063.             $courseImages->setCiCid($id);
  1064.             $courseImages->setCiPath(str_replace($publicImagePath,'.',$path));
  1065.             $courseImages->setCiFullPath(str_replace($publicImagePath,'.',$path2));
  1066.             $em->persist($courseImages);
  1067.             $em->flush();
  1069.             // save Course Times 
  1070.             if($company == 'KVO')
  1071.             {
  1073.                 $begin = new \DateTime(date("Y-m-d",strtotime($request->get('activeFrom'))));
  1074.                 $endDate = new \DateTime(date('Y-m-d',strtotime('+1 day',strtotime($request->get('activeUntill')))));
  1075.                 
  1076.                 $interval = \DateInterval::createFromDateString('1 day');
  1077.                 $period = new \DatePeriod($begin, $interval, $endDate);
  1078.                 
  1079.                 //each day from start to activeUntill
  1080.                 foreach ($period as $dt) //days
  1081.                 {
  1082.                     $day1 = $dt->format("Y-m-d \n"); 
  1083.                     $day = new \DateTime(date("Y-m-d", strtotime($day1)));
  1084.                     
  1085.                     
  1086.                     if($this->checkHoliday($dt->format("d.m.Y")) != false ){ continue; }
  1087.                     if(date('w', strtotime($dt->format("d.m.Y"))) == 0 && $course->getCSunday() == 0) {continue; }
  1088.                     if(date('w', strtotime($dt->format("d.m.Y"))) == 1 && $course->getCMonday() == 0) {continue; }
  1089.                     if(date('w', strtotime($dt->format("d.m.Y"))) == 2 && $course->getCTuesday() == 0) {continue; }
  1090.                     if(date('w', strtotime($dt->format("d.m.Y"))) == 3 && $course->getCWednesday() == 0) {continue; }
  1091.                     if(date('w', strtotime($dt->format("d.m.Y"))) == 4 && $course->getCThursday() == 0) {continue; }
  1092.                     if(date('w', strtotime($dt->format("d.m.Y"))) == 5 && $course->getCFriday() == 0) {continue; }
  1093.                     if(date('w', strtotime($dt->format("d.m.Y"))) == 6 && $course->getCSaturday() == 0) {continue; }
  1094.                     
  1095.                     //day Times
  1096.                     $d1 = new \DateTime(date("H:i:s",strtotime($request->get('starttime'))));
  1097.                 
  1098.                 
  1099.                     while($d1 < $end)
  1100.                     {
  1101.                         
  1102.                         $d1orig = new \DateTime(date('H:i:s',strtotime($d1->format('H:i:s')))); 
  1103.                         
  1104.                         $d1->add(new \DateInterval('PT' . $request->get('duration') . 'M'));
  1105.                         
  1106.                         $courseTimes = new CourseTimes();
  1107.                         $courseTimes->setCttDay($day);
  1108.                         $courseTimes->setCttFrom($d1orig);
  1109.                         $courseTimes->setCttTo($d1);
  1110.                         $courseTimes->setCttCid($id);
  1111.                         $courseTimes->setCttNote('');
  1112.                         $courseTimes->setCttOfflineCustomer(0);
  1113.                         $courseTimes->setCttNumber($request->get('coursenumber'));
  1114.                         $courseTimes->setCttRoom($request->get('room'));
  1115.                         
  1116.                         $em->persist($courseTimes);
  1117.                         
  1118.                         $em->flush();
  1119.                         
  1120.                         $bb = $request->get('break_before');
  1121.                         $ba = $request->get('break_after');
  1122.                         
  1123.                         if(intval($bb) < 0){$bb = 0 ;}
  1124.                         if(intval($ba) < 0){$ba = 0 ;}
  1125.                         
  1126.                         $d1->add(new \DateInterval('PT' . $bb . 'M'));
  1127.                         $d1->add(new \DateInterval('PT' . $ba . 'M'));
  1128.                     }
  1129.                 
  1130.                     if($request->get('timesArr') != "")
  1131.                     {
  1132.                         //additional Times
  1133.                         $timesArr = explode(',',$request->get('timesArr'));
  1134.                         foreach($timesArr as $time)
  1135.                         {
  1136.                             /*
  1137.                             if($company != "KVO")
  1138.                             {
  1139.                                 if($request->get('starttime'.$time) == $request->get('starttime') && $request->get('endtime'.$time) == $request->get('endtime')){continue;}
  1140.                             }
  1141.                             */
  1142.                             
  1143.                             if($request->get('starttime'.$time) != "" && $request->get('endtime'.$time) != "")
  1144.                             {
  1145.                                 $d1 = new \DateTime(date("H:i:s",strtotime($request->get('starttime'.$time))));
  1146.                                 $d2 = new \DateTime(date("H:i:s",strtotime($request->get('endtime'.$time))));
  1147.                                 
  1148.                                 while($d1 < $d2)
  1149.                                 {
  1150.                                     
  1151.                                     $d1orig = new \DateTime(date('H:i:s',strtotime($d1->format('H:i:s')))); 
  1152.                                     
  1153.                                     $d1->add(new \DateInterval('PT' . $request->get('duration') . 'M'));
  1154.                                     
  1155.                                     $repository = $this->getDoctrine()->getRepository(CourseTimes::class);
  1156.                                     $timetest = $repository->findOneBy(['ctt_cid' => $id, 'ctt_day' => $day, 'ctt_from' => $d1orig, 'ctt_to' => $d1, 'ctt_room' => $request->get('room'.$time) ]);
  1157.                                     if($timetest)
  1158.                                     {
  1159.                                         $d1->add(new \DateInterval('PT' . $request->get('break_before') . 'M'));
  1160.                                         $d1->add(new \DateInterval('PT' . $request->get('break_after') . 'M'));
  1161.                                         continue;
  1162.                                     }
  1163.                                     
  1164.                                     $courseTimes = new CourseTimes();
  1165.                                     $courseTimes->setCttDay($day);
  1166.                                     $courseTimes->setCttFrom($d1orig);
  1167.                                     $courseTimes->setCttTo($d1);
  1168.                                     $courseTimes->setCttCid($id);
  1169.                                     $courseTimes->setCttNote('');
  1170.                                     $courseTimes->setCttOfflineCustomer(0);
  1171.                                     $courseTimes->setCttOnline(0);
  1172.                                     $courseTimes->setCttNumber($request->get('coursenumber'.$time));
  1173.                                     $courseTimes->setCttRoom($request->get('room'.$time));
  1174.                                     $courseTimes->setCttMaxonline($request->get('maxcustomer'));
  1175.                                     $courseTimes->setCttMaxoffline($request->get('offlinecustomer'));
  1176.                                     
  1177.                                     $em->persist($courseTimes);
  1178.                                     
  1179.                                     $em->flush();
  1180.                                     
  1181.                                     $d1->add(new \DateInterval('PT' . $request->get('break_before') . 'M'));
  1182.                                     $d1->add(new \DateInterval('PT' . $request->get('break_after') . 'M'));
  1183.                                 }
  1184.                                 
  1185.                             }
  1186.                         }
  1187.                     }
  1188.                 }
  1189.             }
  1190.             else
  1191.             {
  1194.                 $days = $request->get('courseDays');
  1195.                 $days = explode(',',$days);
  1196.                 
  1197.                 foreach($days as $day)
  1198.                 {
  1199.                     $day = new \DateTime(date("Y-m-d", strtotime($day)));
  1200.                     if($request->get('starttime') != "" && $request->get('endtime') != "")
  1201.                     {
  1202.                         $d1 = new \DateTime(date("H:i:s",strtotime($request->get('starttime'))));
  1203.                         $d2 = new \DateTime(date("H:i:s",strtotime($request->get('endtime'))));
  1204.                         
  1205.                         $courseTimes = new CourseTimes();
  1206.                         $courseTimes->setCttDay($day);
  1207.                         $courseTimes->setCttFrom($d1);
  1208.                         $courseTimes->setCttTo($d2);
  1209.                         $courseTimes->setCttCid($id);
  1210.                         $courseTimes->setCttNote('');
  1211.                         $courseTimes->setCttOfflineCustomer(0);
  1212.                         $courseTimes->setCttOnline(0);
  1213.                         $courseTimes->setCttNumber($request->get('coursenumber'));
  1214.                         $courseTimes->setCttRoom($request->get('room'));
  1215.                         //$courseTimes->setCttMaxonline($request->get('maxcustomer'));
  1216.                         //$courseTimes->setCttMaxoffline($request->get('offlinecustomer'));
  1217.                         $courseTimes->setCttMaxonline($request->get('courseMaxOnline'));
  1218.                         $courseTimes->setCttMaxoffline($request->get('courseMaxOffline'));
  1219.                         
  1220.                         $em->persist($courseTimes);
  1221.                         $em->flush();
  1222.                     }
  1223.                 }
  1224.                 if($request->get('courseTimesArr') != "")
  1225.                 {
  1226.                     //additional Times
  1227.                     $timesArr = explode(',',$request->get('courseTimesArr'));
  1228.                     foreach($timesArr as $time)
  1229.                     {
  1230.                         
  1231.                         //GET Days
  1232.                         $days = $request->get('courseDays'.$time);
  1233.                         $days = explode(',',$days);
  1234.                         
  1235.                         foreach($days as $day)
  1236.                         {
  1237.                             $day = new \DateTime(date("Y-m-d", strtotime($day)));
  1238.                             //if($request->get('starttime'.$time) == $request->get('starttime') && $request->get('endtime'.$time) == $request->get('endtime')){continue;}
  1239.                             
  1240.                             if($request->get('starttime'.$time) != "" && $request->get('endtime'.$time) != "")
  1241.                             {
  1242.                                 $d1 = new \DateTime(date("H:i:s",strtotime($request->get('starttime'.$time))));
  1243.                                 $d2 = new \DateTime(date("H:i:s",strtotime($request->get('endtime'.$time))));
  1244.                                 
  1245.                                 $courseTimes = new CourseTimes();
  1246.                                 $courseTimes->setCttDay($day);
  1247.                                 $courseTimes->setCttFrom($d1);
  1248.                                 $courseTimes->setCttTo($d2);
  1249.                                 $courseTimes->setCttCid($id);
  1250.                                 $courseTimes->setCttNote('');
  1251.                                 $courseTimes->setCttOfflineCustomer(0);
  1252.                                 $courseTimes->setCttOnline(0);
  1253.                                 $courseTimes->setCttNumber($request->get('coursenumber'.$time));
  1254.                                 $courseTimes->setCttRoom($request->get('room'.$time));
  1255.                                 //$courseTimes->setCttMaxonline($request->get('maxcustomer'));
  1256.                                 //$courseTimes->setCttMaxoffline($request->get('offlinecustomer'));
  1257.                                 $courseTimes->setCttMaxonline($request->get('courseMaxOnline'.$time));
  1258.                                 $courseTimes->setCttMaxoffline($request->get('courseMaxOffline'.$time));
  1259.                                 
  1260.                                 $em->persist($courseTimes);
  1261.                                 
  1262.                                 $em->flush();
  1263.                             }
  1264.                         }
  1265.                     }
  1266.                 }
  1269.             }
  1271.             if($company == "KVO")
  1272.             {
  1273.                 $timesArr = explode(',',$request->get('timesArr'));
  1274.             }
  1275.             else
  1276.             {
  1277.                 $timesArr = explode(',',$request->get('courseTimesArr'));
  1278.             }
  1281.           
  1282.             foreach($timesArr as $time)
  1283.             {
  1284.                 if($time == ""){ continue; }      
  1285.                 if($request->get('starttime'.$time) != "" && $request->get('endtime'.$time) != "")
  1286.                 {
  1287.                     //$d1 = new \DateTime(date("H:i:s",strtotime($request->get('starttime'.$time))));
  1288.                     //$d2 = new \DateTime(date("H:i:s",strtotime($request->get('endtime'.$time))));
  1289.                     $d1 = new \DateTime(date("H:i:s",strtotime($request->get('starttime'.$time))));
  1290.                     $d2 = new \DateTime(date("H:i:s",strtotime($request->get('endtime'.$time))));
  1291.                 
  1292.                     $repository = $this->getDoctrine()->getRepository(CourseAdditionalTimes::class);
  1293.                     if($company == "KVO")
  1294.                     {
  1295.                         $timetest = $repository->findOneBy(['cat_cid' => $id, 'cat_from' => $d1, 'cat_to' => $d2, 'cat_room' => $request->get('room'.$time) ]);
  1296.                         if($timetest)
  1297.                         {
  1298.                             continue;
  1299.                         }
  1300.                     }
  1301.                     /*else
  1302.                     {
  1303.                         $timetest = $repository->findOneBy(['cat_cid' => $id, 'cat_from' => $d1, 'cat_to' => $d2, 'cat_room' => 0 ]);
  1304.                     }*/
  1306.                     
  1308.                     $courseAddTimes = new CourseAdditionalTimes();
  1309.                     $courseAddTimes->setCatCid($id);
  1310.                     $courseAddTimes->setCatFrom($d1);
  1311.                     $courseAddTimes->setCatTo($d2);
  1312.                     $courseAddTimes->setCatItem($time);
  1313.                     if($company == 'KVO')
  1314.                     {
  1315.                         if(!is_null($request->get('room'.$time)))
  1316.                         {
  1317.                             $courseAddTimes->setCatRoom($request->get('room'.$time));
  1318.                         }
  1319.                         else
  1320.                         {
  1321.                            $courseAddTimes->setCatRoom(0);
  1322.                         }
  1323.                         $courseAddTimes->setCatLeader(0);
  1324.                         $courseAddTimes->setCatDays('');
  1325.                         $courseAddTimes->setCatNumber(0);
  1326.                     }
  1327.                     else
  1328.                     {
  1329.                         $courseAddTimes->setCatRoom(0);
  1330.                         $courseAddTimes->setCatLeader($request->get('courseleader'.$time));
  1331.                         $courseAddTimes->setCatDays($request->get('courseDays'.$time));
  1332.                         $courseAddTimes->setCatNumber($request->get('coursenumber'.$time));
  1333.                         $courseAddTimes->setCatBookingOption($request->get('booking_option'.$time));
  1334.                     }
  1335.                     $courseAddTimes->setCatMaxOnline($request->get('courseMaxOnline'.$time));
  1336.                     $courseAddTimes->setCatMaxOffline($request->get('courseMaxOffline'.$time));
  1338.                     $em->persist($courseAddTimes);
  1339.                     $em->flush();
  1340.                 }
  1341.             }
  1342.             if($company != "KVO")
  1343.             {
  1344.                 //$d1 = new \DateTime(date("H:i:s",strtotime($request->get('starttime'))));
  1345.                 //$d2 = new \DateTime(date("H:i:s",strtotime($request->get('endtime'))));
  1346.                 $d1 = new \DateTime(date("H:i:s",strtotime($request->get('starttime'))));
  1347.                 $d2 = new \DateTime(date("H:i:s",strtotime($request->get('endtime'))));
  1348.                 $courseAddTimes = new CourseAdditionalTimes();
  1349.                 $courseAddTimes->setCatCid($id);
  1350.                 $courseAddTimes->setCatFrom($d1);
  1351.                 $courseAddTimes->setCatTo($d2);
  1352.                 $courseAddTimes->setCatItem(0);
  1353.                 $courseAddTimes->setCatRoom(0);
  1354.                 $courseAddTimes->setCatLeader($request->get('courseleader'));
  1355.                 $courseAddTimes->setCatDays($request->get('courseDays'));
  1356.                 $courseAddTimes->setCatNumber($request->get('coursenumber'));
  1357.                 $courseAddTimes->setCatBookingOption($request->get('booking_option'));
  1358.                 $courseAddTimes->setCatMaxOnline($request->get('courseMaxOnline'));
  1359.                 $courseAddTimes->setCatMaxOffline($request->get('courseMaxOffline'));
  1360.                 
  1361.                 $em->persist($courseAddTimes);
  1362.                 $em->flush();
  1363.             }
  1365.         }
  1366.         else if($request->get('productKind') == '2' || $request->get('productKind') == 2)
  1367.         {
  1368.             $price = str_replace(".","#",$request->get('price'));
  1369.             $price = str_replace(",",".",$price);
  1370.             $price = str_replace("#",",",$price);
  1371.             $price = number_format($price,2,'.',',');
  1372.             $tax = number_format((float)$request->get('tax2'),2,'.',',');
  1374.             $article = new Article();
  1375.             $article->setAName($request->get('articlename'));
  1376.             $article->setASbNumber($request->get('coursesbnumber2'));
  1377.             $article->setACategory($request->get('coursecategory2'));
  1378.             $article->setADescription($request->get('description2'));
  1379.             $article->setAPrice($price);
  1380.             $article->setATax($tax);
  1381.             $article->setAActive(1);
  1382.             $article->setAPlace(1);
  1383.             $article->setADiscount($request->get('discount2'));
  1384.             $article->setACostplace($request->get('costplace2'));
  1386.             $em = $this->getDoctrine()->getManager();
  1387.             $em->persist($article);
  1388.             $em->flush();
  1389.             $id = $article->getId();
  1391.             //image
  1392.             $pic = $request->files->get('courseImage2');
  1393.             
  1394.             $folder =  $this->getParameter('kernel.project_dir')."/public/courseImages/";
  1395.             if(!file_exists($folder)){mkdir($folder);}
  1396.             
  1397.             $subfolder = $folder.$id."/";
  1398.             if(!file_exists($subfolder)){mkdir($subfolder);}
  1400.             $uniqid = uniqid();
  1402.             $path = $subfolder.$uniqid."_".$pic->getClientOriginalName();
  1403.             if(file_exists($path)){unlink($path);}
  1405.             $newFilename = $uniqid.'_'.$pic->getClientOriginalName();
  1406.             $pic->move($subfolder, $newFilename);
  1408.             $articleImages = new ArticleImages();
  1409.             $articleImages->setAiAid($id);
  1410.             $articleImages->setAiPath(str_replace($publicImagePath,'.',$path));
  1411.             $em->persist($articleImages);
  1412.             $em->flush();
  1415.         }
  1416.         
  1417.         if($request->get('productKind') == '1' || $request->get('productKind') == 1)
  1418.         {
  1420.             $response = $this->forward('App\Controller\CourseController::backendTrainerPayment', ['id' => $id]);
  1421.             return $response;
  1422.         }
  1423.         else
  1424.         {
  1425.             $response = $this->forward('App\Controller\CourseController::backendCourse', []);
  1426.             return $response;
  1427.         }
  1428.         
  1429.     }
  1432.     /**
  1433.     * @Route("/backendCourseEditSave/", name="backendCourseEditSave")
  1434.     */
  1435.     public function backendCourseEditSave(Request $request)
  1436.     {
  1437.         include("./include/global.php");
  1438.         include("./include/function.php");
  1439.         if($this->get('security.token_storage')->getToken()->getUser() == 'anon.')
  1440.         {
  1441.             
  1442.             $response = $this->forward('App\Controller\CourseController::homepage', []);
  1443.             return $response;
  1444.         }
  1446.         if($request->get('mode') == '1' || $request->get('mode') == 1)
  1447.         {
  1448.             // save Course
  1449.             $start = new \DateTime(date("H:i:s",strtotime($request->get('starttime'))));
  1450.             $end = new \DateTime(date('H:i:s', strtotime($request->get('endtime'))));
  1451.             $visible_from = new \DateTime(date('Y-m-d H:i:00', strtotime($request->get('visible_from'). ' '. $request->get('visible_time').':00')));
  1453.             $price = str_replace(".","#",$request->get('price'));
  1454.             $price = str_replace(",",".",$price);
  1455.             $price = str_replace("#",",",$price);
  1456.             $price = number_format($price,2,'.',',');
  1457.             
  1458.             $tax = number_format((float)$request->get('tax'),2,'.',',');
  1459.             $adminFee = number_format((float)$request->get('admin_fee'),2,'.',',');
  1461.             $repository = $this->getDoctrine()->getRepository(Course::class);
  1462.             $course = $repository->findOneBy(['id' => $request->get('courseID')]);
  1464.             $id = $request->get('courseID');
  1466.             if($request->get('yoga') == null)
  1467.             {
  1468.                 $yoga = 0;
  1469.             }
  1470.             else
  1471.             {
  1472.                 $yoga = $request->get('yoga');
  1473.             }
  1474.             
  1475.             if($request->get('sibling_discount') == null)
  1476.             {
  1477.                 $siblingDiscount = 0;
  1478.             }
  1479.             else
  1480.             {
  1481.                 $siblingDiscount = $request->get('sibling_discount');
  1482.             }
  1484.             if($request->get('studio_discount') == null)
  1485.             {
  1486.                 $studioDiscount = 0;
  1487.             }
  1488.             else
  1489.             {
  1490.                 $studioDiscount = $request->get('studio_discount');
  1491.             }
  1493.             if($request->get('visible') == null)
  1494.             {
  1495.                 $visible = 0;
  1496.             }
  1497.             else
  1498.             {
  1499.                 $visible = $request->get('visible');
  1500.             }
  1502.             if($request->get('discount') == null)
  1503.             {
  1504.                 $discount = 0;
  1505.             }
  1506.             else
  1507.             {
  1508.                 $discount = $request->get('discount');
  1509.             }
  1511.             $course->setCName($request->get('coursename'));
  1512.             $course->setCNumber($request->get('coursenumber'));
  1513.             if( is_null($request->get('coursesbnumber')) )
  1514.             {
  1515.                 $course->setCSbNumber(0);
  1516.             }
  1517.             else
  1518.             {
  1519.                 $course->setCSbNumber($request->get('coursesbnumber'));
  1520.             }
  1521.             $course->setCYoga($yoga);
  1522.             $course->setCLeader($request->get('courseleader'));
  1523.             $course->setCCategory($request->get('coursecategory'));
  1524.             $course->setCMaxcustomer($request->get('maxcustomer'));
  1525.             $course->setCOfflineCustomer($request->get('offlinecustomer'));
  1526.             $course->setCStart($start);
  1527.             $course->setCEnd($end);
  1528.             if( is_null($request->get('duration')) )
  1529.             {
  1530.                 $course->setCDuration(0);
  1531.             }
  1532.             else
  1533.             {
  1534.                 $course->setCDuration($request->get('duration'));
  1535.             }
  1536.             $course->setCDiscount($discount);
  1537.             $course->setCSiblingDiscount($siblingDiscount);
  1538.             $course->setCStudioDiscount($studioDiscount);
  1539.             $course->setCVisibleFrom($visible_from);
  1540.             $course->setCVisible($visible);
  1542.             $course->setCPeriod($request->get('courseperiod'));
  1543.             
  1544.             $bb = $request->get('break_before');
  1545.             $ba = $request->get('break_after');
  1546.             if(intval($bb) < 0){$bb = 0;}
  1547.             if(intval($ba) < 0){$ba = 0;}
  1549.             $course->setCBreakBefore($bb);
  1550.             $course->setCBreakAfter($ba);
  1551.             $course->setCDescription($request->get('description'));
  1552.             $course->setCPrice($price);
  1553.             $course->setCAdminFee( $adminFee );
  1554.             $course->setCTax($tax);
  1555.             $course->setCActive(1);
  1556.             if($company == 'KVO')
  1557.             {
  1558.                 $course->setCRoom($request->get('room'));
  1559.             }
  1560.             else
  1561.             {
  1562.                 $course->setCRoom(0);
  1563.             }
  1564.             $course->setCCostplace($request->get('costplace'));
  1565.             $course->setCAppointmentSeries($request->get('series'));
  1566.             $course->setCAppointmentSeriesDays($request->get('seriesDays'));
  1567.             
  1568.             $mon = $request->get('monday');
  1569.             if(is_null($mon)) {$mon = 0;}
  1570.             $tue = $request->get('tuesday');
  1571.             if(is_null($tue)) {$tue = 0;}
  1572.             $wed = $request->get('wednesday');
  1573.             if(is_null($wed)) {$wed = 0;}
  1574.             $thu = $request->get('thursday');
  1575.             if(is_null($thu)) {$thu = 0;}
  1576.             $fri = $request->get('friday');
  1577.             if(is_null($fri)) {$fri = 0;}
  1578.             $sat = $request->get('saturday');
  1579.             if(is_null($sat)) {$sat = 0;}
  1580.             $sun = $request->get('sunday');
  1581.             if(is_null($sun)) {$sun = 0;}
  1583.             $course->setCMonday($mon);
  1584.             $course->setCTuesday($tue);
  1585.             $course->setCWednesday($wed);
  1586.             $course->setCThursday($thu);
  1587.             $course->setCFriday($fri);
  1588.             $course->setCSaturday($sat);
  1589.             $course->setCSunday($sun);
  1590.             
  1591.             $course->setCPlace(1);
  1592.             $d = new \DateTime(date('Y-m-d H:i:s',strtotime($request->get('activeUntill'))));
  1593.             $course->setCActiveUntill($d);
  1594.             
  1595.             $d2 = new \DateTime(date('Y-m-d H:i:s',strtotime($request->get('activeFrom'))));
  1596.             $course->setCActiveFrom($d2);
  1598.             $em = $this->getDoctrine()->getManager();
  1599.             $em->persist($course);
  1600.             $em->flush();
  1603.             //save Images  
  1604.             $pic = $request->files->get('courseImage');
  1605.             $pic2 = $request->files->get('courseImageFull');
  1606.             if($pic != "")
  1607.             {
  1608.                 $repository = $this->getDoctrine()->getRepository(CourseImages::class);
  1609.                 $pics = $repository->findOneBy(['ci_cid' => $id]);
  1611.                 $full = $pics->getCiFullPath();
  1613.                 $em = $this->getDoctrine()->getManager();
  1614.                 $em->remove($pics);
  1615.                 $em->flush();
  1617.                 $folder =  $this->getParameter('kernel.project_dir')."/public/courseImages/";
  1618.                 if(!file_exists($folder)){mkdir($folder);}
  1619.                 
  1620.                 $subfolder = $folder.$id."/";
  1621.                 if(!file_exists($subfolder)){ mkdir($subfolder); }
  1623.                 $uniqid = uniqid();
  1625.                 $path = $subfolder.$uniqid."_".$pic->getClientOriginalName();
  1626.                 if(file_exists($path)){unlink($path);}
  1628.                 $newFilename = $uniqid.'_'.$pic->getClientOriginalName();
  1629.                 $pic->move($subfolder, $newFilename);
  1633.                 $courseImages = new CourseImages();
  1634.                 $courseImages->setCiCid($id);
  1635.                 $courseImages->setCiPath(str_replace($publicImagePath,'.',$path));
  1636.                 $courseImages->setCiFullPath($full);
  1637.                 $em->persist($courseImages);
  1638.                 $em->flush();
  1639.             }
  1640.             if($pic2 != "")
  1641.             {
  1642.                 $repository = $this->getDoctrine()->getRepository(CourseImages::class);
  1643.                 $pics = $repository->findOneBy(['ci_cid' => $id]);
  1645.                 $path1 = $pics->getCiPath();
  1647.                 $em = $this->getDoctrine()->getManager();
  1648.                 $em->remove($pics);
  1649.                 $em->flush();
  1651.                 $folder =  $this->getParameter('kernel.project_dir')."/public/courseImages/";
  1652.                 if(!file_exists($folder)){mkdir($folder);}
  1653.                 
  1654.                 $subfolder = $folder.$id."/";
  1655.                 if(!file_exists($subfolder)){ mkdir($subfolder); }
  1657.                 $uniqid = uniqid();
  1659.                 $path2 = $subfolder.$uniqid."_".$pic2->getClientOriginalName();
  1660.                 if(file_exists($path2)){unlink($path2);}
  1662.                 $newFilename2 = $uniqid.'_'.$pic2->getClientOriginalName();
  1663.                 $pic2->move($subfolder, $newFilename2);
  1665.                 $courseImages = new CourseImages();
  1666.                 $courseImages->setCiCid($id);
  1667.                 $courseImages->setCiPath($path1);
  1668.                 $courseImages->setCiFullPath(str_replace($publicImagePath,'.',$path2));
  1669.                 $em->persist($courseImages);
  1670.                 $em->flush();
  1671.             }
  1673.             // save Course Times 
  1675.             $repository = $this->getDoctrine()->getRepository(CourseTimes::class);
  1676.             $times = $repository->findBy(['ctt_cid' => $id, 'ctt_offline_customer' => 0, 'ctt_online' => 0]);
  1677.             
  1678.             $em = $this->getDoctrine()->getManager();
  1680.             $repository = $this->getDoctrine()->getRepository(CourseAdditionalTimes::class);
  1681.             $courseAddTimes = $repository->findBy(['cat_cid' => $id]);
  1682.             foreach($courseAddTimes as $cat)
  1683.             {
  1684.                
  1685.                 $em->remove($cat);
  1686.                 $em->flush();
  1687.             }
  1689.             foreach($times as $time)
  1690.             {
  1691.                 $repository = $this->getDoctrine()->getRepository(OrderItems::class);
  1692.                 $item = $repository->findBy(['oi_tid' => $time->getId()]);
  1693.         
  1694.                 $repository = $this->getDoctrine()->getRepository(ManualAppointment::class);
  1695.                 $ma = $repository->findBy(['ma_tid' => $time->getId()]);
  1696.         
  1697.                 if(!$item && !$ma)
  1698.                 {   
  1699.                     $em = $this->getDoctrine()->getManager();
  1700.                     $em->remove($time);
  1701.                     $em->flush();
  1702.                 }
  1703.             }
  1705.             if($company == 'KVO')
  1706.             {
  1707.                 $begin = new \DateTime(date("Y-m-d",strtotime($request->get('activeFrom'))));
  1708.                 $endDate = new \DateTime(date('Y-m-d',strtotime('+1 day',strtotime($request->get('activeUntill')))));
  1711.                 $interval = \DateInterval::createFromDateString('1 day');
  1712.                 $period = new \DatePeriod($begin, $interval, $endDate);
  1714.                 //each day from start to activeUntill
  1715.                 foreach ($period as $dt) 
  1716.                 {
  1717.                 
  1718.                     $day1 = $dt->format("Y-m-d \n"); 
  1719.                     $day = new \DateTime(date("Y-m-d", strtotime($day1)));
  1720.                     
  1721.                     
  1722.                     if($this->checkHoliday($dt->format("d.m.Y")) != false ){ continue; }
  1723.                     if(date('w', strtotime($dt->format("d.m.Y"))) == 0 && $course->getCSunday() == 0) {continue; }
  1724.                     if(date('w', strtotime($dt->format("d.m.Y"))) == 1 && $course->getCMonday() == 0) {continue; }
  1725.                     if(date('w', strtotime($dt->format("d.m.Y"))) == 2 && $course->getCTuesday() == 0) {continue; }
  1726.                     if(date('w', strtotime($dt->format("d.m.Y"))) == 3 && $course->getCWednesday() == 0) {continue; }
  1727.                     if(date('w', strtotime($dt->format("d.m.Y"))) == 4 && $course->getCThursday() == 0) {continue; }
  1728.                     if(date('w', strtotime($dt->format("d.m.Y"))) == 5 && $course->getCFriday() == 0) {continue; }
  1729.                     if(date('w', strtotime($dt->format("d.m.Y"))) == 6 && $course->getCSaturday() == 0) {continue; }
  1732.                     $d1 = new \DateTime(date("H:i:s",strtotime($request->get('starttime'))));
  1733.                 
  1735.                     while($d1 < $end)
  1736.                     {
  1737.                     
  1738.                         $d1orig = new \DateTime(date('H:i:s',strtotime($d1->format('H:i:s')))); 
  1739.                         
  1740.                         $d1->add(new \DateInterval('PT' . $request->get('duration') . 'M'));
  1741.                         
  1742.                         $repository = $this->getDoctrine()->getRepository(CourseTimes::class);
  1743.                         $time2 = $repository->findBy(['ctt_cid' => $id, 'ctt_day' => $day, 'ctt_from' => $d1orig, 'ctt_to' => $d1, 'ctt_room' => $request->get('room')]);
  1744.                         
  1745.                         if(!$time2)
  1746.                         {
  1748.                             $courseTimes = new CourseTimes();
  1749.                             $courseTimes->setCttDay($day);
  1750.                             $courseTimes->setCttFrom($d1orig);
  1751.                             $courseTimes->setCttTo($d1);
  1752.                             $courseTimes->setCttCid($id);
  1753.                             $courseTimes->setCttNote('');
  1754.                             $courseTimes->setCttRoom($request->get('room'));
  1755.                             $courseTimes->setCttOfflineCustomer(0);
  1756.                             $courseTimes->setCttOnline(0);
  1757.                             $courseTimes->setCttNumber($request->get('coursenumber'));
  1758.                             $courseTimes->setCttMaxonline($request->get('maxcustomer'));
  1759.                             $courseTimes->setCttMaxoffline($request->get('offlinecustomer'));
  1760.                             
  1761.                             $em = $this->getDoctrine()->getManager();
  1762.                             $em->persist($courseTimes);
  1763.                             $em->flush();
  1764.                         }
  1765.                 
  1766.                         $bb = $request->get('break_before');
  1767.                         $ba = $request->get('break_after');
  1768.                         if(intval($bb) < 0){$bb = 0;}
  1769.                         if(intval($ba) < 0){$ba = 0;}
  1771.                         $d1->add(new \DateInterval('PT' . $bb . 'M'));
  1772.                         $d1->add(new \DateInterval('PT' . $ba . 'M'));
  1773.                         
  1775.                     }
  1777.                     if($request->get('timesArr') != "")
  1778.                     {
  1779.                         //additional Times
  1780.                         $timesArr = explode(',',$request->get('timesArr'));
  1781.                         foreach($timesArr as $time)
  1782.                         {
  1783.                             /*
  1784.                             if($company != "KVO")
  1785.                             {
  1786.                                 if($request->get('starttime'.$time) == $request->get('starttime') && $request->get('endtime'.$time) == $request->get('endtime')){continue;}
  1787.                             }
  1788.                             */
  1790.                             if($request->get('starttime'.$time) != "" && $request->get('endtime'.$time) != "")
  1791.                             {
  1792.                                 $d1 = new \DateTime(date("H:i:s",strtotime($request->get('starttime'.$time))));
  1793.                                 $d2 = new \DateTime(date("H:i:s",strtotime($request->get('endtime'.$time))));
  1794.                                 
  1795.                                 //if($compare1 == $d1 && $compare2 == $d2){continue;}
  1796.                                 
  1797.                                 while($d1 < $d2)
  1798.                                 {
  1799.                                     
  1800.                                     $d1orig = new \DateTime(date('H:i:s',strtotime($d1->format('H:i:s')))); 
  1801.                                     
  1802.                                     $d1->add(new \DateInterval('PT' . $request->get('duration') . 'M'));
  1803.                                     
  1804.                                     $repository = $this->getDoctrine()->getRepository(CourseTimes::class);
  1805.                                     $timetest = $repository->findOneBy(['ctt_cid' => $id, 'ctt_day' => $day, 'ctt_from' => $d1orig, 'ctt_to' => $d1, 'ctt_room' => $request->get('room'.$time) ]);
  1806.                                     if($timetest)
  1807.                                     {
  1808.                 
  1809.                                         $bb = $request->get('break_before');
  1810.                                         $ba = $request->get('break_after');
  1811.                                         if(intval($bb) < 0){$bb = 0;}
  1812.                                         if(intval($ba) < 0){$ba = 0;}
  1813.         
  1814.                                         $d1->add(new \DateInterval('PT' . $bb . 'M'));
  1815.                                         $d1->add(new \DateInterval('PT' . $ba . 'M'));
  1816.                                         continue;
  1817.                                     }
  1819.                                     $courseTimes = new CourseTimes();
  1820.                                     $courseTimes->setCttDay($day);
  1821.                                     $courseTimes->setCttFrom($d1orig);
  1822.                                     $courseTimes->setCttTo($d1);
  1823.                                     $courseTimes->setCttCid($id);
  1824.                                     $courseTimes->setCttNote('');
  1825.                                     $courseTimes->setCttOfflineCustomer(0);
  1826.                                     $courseTimes->setCttNumber($request->get('coursenumber'.$time));
  1827.                                     $courseTimes->setCttRoom($request->get('room'.$time));
  1828.                                     
  1829.                                     $em->persist($courseTimes);
  1830.                                     
  1831.                                     $em->flush();
  1832.                 
  1833.                                     $bb = $request->get('break_before');
  1834.                                     $ba = $request->get('break_after');
  1835.                                     if(intval($bb) < 0){$bb = 0;}
  1836.                                     if(intval($ba) < 0){$ba = 0;}
  1838.                                     $d1->add(new \DateInterval('PT' . $bb . 'M'));
  1839.                                     $d1->add(new \DateInterval('PT' . $ba . 'M'));
  1840.                                 }
  1841.                             
  1842.                             }
  1843.                         }
  1844.                     }
  1845.                 }
  1846.             }
  1847.             else
  1848.             {
  1851.                 $days = $request->get('courseDays');
  1852.                 $days = explode(',',$days);
  1853.                 
  1854.                 foreach($days as $day)
  1855.                 {
  1856.                     $day = new \DateTime(date("Y-m-d", strtotime($day)));
  1857.                     if($request->get('starttime') != "" && $request->get('endtime') != "")
  1858.                     {
  1859.                         $d1 = new \DateTime(date("H:i:s",strtotime($request->get('starttime'))));
  1860.                         $d2 = new \DateTime(date("H:i:s",strtotime($request->get('endtime'))));
  1861.                         
  1862.                         $repository = $this->getDoctrine()->getRepository(CourseTimes::class);
  1863.                         $timetest = $repository->findOneBy(['ctt_cid' => $id, 'ctt_day' => $day, 'ctt_from' => $d1, 'ctt_to' => $d2, 'ctt_room' => $request->get('room') ]);
  1864.                         if($timetest)
  1865.                         {
  1866.                             continue;
  1867.                         }
  1868.                         $repository = $this->getDoctrine()->getRepository(CourseTimes::class);
  1869.                         $timetest = $repository->findOneBy(['ctt_cid' => $id, 'ctt_day' => $day, 'ctt_from' => $d1, 'ctt_to' => $d1, 'ctt_number' => $request->get('coursenumber') ]);
  1870.                         if($timetest){ continue; }
  1871.                         $courseTimes = new CourseTimes();
  1872.                         $courseTimes->setCttDay($day);
  1873.                         $courseTimes->setCttFrom($d1);
  1874.                         $courseTimes->setCttTo($d2);
  1875.                         $courseTimes->setCttCid($id);
  1876.                         $courseTimes->setCttNote('');
  1877.                         $courseTimes->setCttOfflineCustomer(0);
  1878.                         $courseTimes->setCttOnline(0);
  1879.                         $courseTimes->setCttNumber($request->get('coursenumber'));
  1880.                         $courseTimes->setCttRoom($request->get('room'));
  1881.                         $courseTimes->setCttMaxonline($request->get('courseMaxOnline'));
  1882.                         $courseTimes->setCttMaxoffline($request->get('courseMaxOffline'));
  1883.                         
  1884.                         $em->persist($courseTimes);
  1885.                         $em->flush();
  1886.                     }
  1887.                 }
  1888.                 if($request->get('courseTimesArr') != "")
  1889.                 {
  1890.                     //additional Times
  1891.                     $timesArr = explode(',',$request->get('courseTimesArr'));
  1892.                     foreach($timesArr as $time)
  1893.                     {
  1894.                         
  1895.                         //GET Days
  1896.                         $days = $request->get('courseDays'.$time);
  1897.                         $days = explode(',',$days);
  1898.                         
  1899.                         foreach($days as $day)
  1900.                         {
  1901.                             $day = new \DateTime(date("Y-m-d", strtotime($day)));
  1902.                             //if($request->get('starttime'.$time) == $request->get('starttime') && $request->get('endtime'.$time) == $request->get('endtime')){continue;}
  1903.                             
  1904.                             if($request->get('starttime'.$time) != "" && $request->get('endtime'.$time) != "")
  1905.                             {
  1906.                                 $d1 = new \DateTime(date("H:i:s",strtotime($request->get('starttime'.$time))));
  1907.                                 $d2 = new \DateTime(date("H:i:s",strtotime($request->get('endtime'.$time))));
  1908.                                 
  1909.                                 $repository = $this->getDoctrine()->getRepository(CourseTimes::class);
  1910.                                 $timetest = $repository->findOneBy(['ctt_cid' => $id, 'ctt_day' => $day, 'ctt_from' => $d1, 'ctt_to' => $d2, 'ctt_room' => $request->get('room'.$time) ]);
  1911.                                 if($timetest)
  1912.                                 {
  1913.                                     continue;
  1914.                                 }
  1915.                                 $repository = $this->getDoctrine()->getRepository(CourseTimes::class);
  1916.                                 $timetest = $repository->findOneBy(['ctt_cid' => $id, 'ctt_day' => $day, 'ctt_from' => $d1, 'ctt_to' => $d1, 'ctt_number' => $request->get('coursenumber'.$time) ]);
  1917.                                 if($timetest){ continue; }
  1918.                                 $courseTimes = new CourseTimes();
  1919.                                 $courseTimes->setCttDay($day);
  1920.                                 $courseTimes->setCttFrom($d1);
  1921.                                 $courseTimes->setCttTo($d2);
  1922.                                 $courseTimes->setCttCid($id);
  1923.                                 $courseTimes->setCttNote('');
  1924.                                 $courseTimes->setCttOfflineCustomer(0);
  1925.                                 $courseTimes->setCttOnline(0);
  1926.                                 $courseTimes->setCttNumber($request->get('coursenumber'.$time));
  1927.                                 $courseTimes->setCttRoom($request->get('room'.$time));
  1928.                                 $courseTimes->setCttMaxonline($request->get('courseMaxOnline'.$time));
  1929.                                 $courseTimes->setCttMaxoffline($request->get('courseMaxOffline'.$time));
  1930.                                 
  1931.                                 $em->persist($courseTimes);
  1932.                                 
  1933.                                 $em->flush();
  1934.                             }
  1935.                         }
  1936.                     }
  1937.                 }
  1938.             }
  1940.             if($company == "KVO")
  1941.             {
  1942.                 $timesArr = explode(',',$request->get('timesArr'));
  1943.             }
  1944.             else
  1945.             {
  1946.                 $timesArr = explode(',',$request->get('courseTimesArr'));
  1947.             }
  1948.             foreach($timesArr as $time)
  1949.             {
  1950.                 if($time == ""){ continue; }
  1951.                 /*
  1952.                 if($company != "KVO")
  1953.                 {
  1954.                     if($request->get('starttime'.$time) == $request->get('starttime') && $request->get('endtime'.$time) == $request->get('endtime')){continue;}
  1955.                 }
  1956.                 */
  1957.                 if($request->get('starttime'.$time) != "" && $request->get('endtime'.$time) != "")
  1958.                 {
  1959.                     //$d1 = new \DateTime(date("H:i:s",strtotime($request->get('starttime'.$time))));
  1960.                     //$d2 = new \DateTime(date("H:i:s",strtotime($request->get('endtime'.$time))));
  1961.                     $d1 = new \DateTime(date("H:i:s",strtotime($request->get('starttime'.$time))));
  1962.                     $d2 = new \DateTime(date("H:i:s",strtotime($request->get('endtime'.$time))));
  1963.                 
  1964.                     $repository = $this->getDoctrine()->getRepository(CourseAdditionalTimes::class);
  1965.                     if($company == "KVO")
  1966.                     {
  1967.                         $timetest = $repository->findOneBy(['cat_cid' => $id, 'cat_from' => $d1, 'cat_to' => $d2, 'cat_room' => $request->get('room'.$time) ]);
  1968.                         if($timetest)
  1969.                         {
  1970.                             continue;
  1971.                         }
  1972.                     }
  1973.                     /*else
  1974.                     {
  1975.                         $timetest = $repository->findOneBy(['cat_cid' => $id, 'cat_from' => $d1, 'cat_to' => $d2, 'cat_room' => 0 ]);
  1976.                     }
  1977.                     */
  1979.                     
  1981.                     $courseAddTimes = new CourseAdditionalTimes();
  1982.                     $courseAddTimes->setCatCid($id);
  1983.                     $courseAddTimes->setCatFrom($d1);
  1984.                     $courseAddTimes->setCatTo($d2);
  1985.                     $courseAddTimes->setCatItem($time);
  1986.                     if($company == 'KVO')
  1987.                     {
  1988.                         if(!is_null($request->get('room'.$time)))
  1989.                         {
  1990.                             $courseAddTimes->setCatRoom($request->get('room'.$time));
  1991.                         }
  1992.                         else
  1993.                         {
  1994.                             $courseAddTimes->setCatRoom(0);
  1995.                         }    
  1996.                         $courseAddTimes->setCatLeader(0);
  1997.                         $courseAddTimes->setCatDays('');
  1998.                         $courseAddTimes->setCatNumber(0);
  1999.                         $courseAddTimes->setCatBookingOption(0);
  2000.                     }
  2001.                     else
  2002.                     {
  2003.                         $courseAddTimes->setCatRoom(0);
  2005.                         $courseAddTimes->setCatLeader($request->get('courseleader'.$time));
  2006.                         $courseAddTimes->setCatDays($request->get('courseDays'.$time));
  2007.                         $courseAddTimes->setCatNumber($request->get('coursenumber'.$time));
  2008.                         $courseAddTimes->setCatBookingOption($request->get('booking_option'.$time));
  2009.                         
  2010.                     }
  2011.                     $courseAddTimes->setCatMaxOnline($request->get('courseMaxOnline'.$time));
  2012.                     $courseAddTimes->setCatMaxOffline($request->get('courseMaxOffline'.$time));
  2013.                     $em->persist($courseAddTimes);
  2014.                     $em->flush();
  2015.                 }
  2016.             }
  2017.             if($company != "KVO")
  2018.             {
  2019.                 //$d1 = new \DateTime(date("H:i:s",strtotime($request->get('starttime'))));
  2020.                 //$d2 = new \DateTime(date("H:i:s",strtotime($request->get('endtime'))));
  2021.                 $d1 = new \DateTime(date("H:i:s",strtotime($request->get('starttime'))));
  2022.                 $d2 = new \DateTime(date("H:i:s",strtotime($request->get('endtime'))));
  2023.                 $courseAddTimes = new CourseAdditionalTimes();
  2024.                 $courseAddTimes->setCatCid($id);
  2025.                 $courseAddTimes->setCatFrom($d1);
  2026.                 $courseAddTimes->setCatTo($d2);
  2027.                 $courseAddTimes->setCatItem(0);
  2028.                 $courseAddTimes->setCatRoom(0);
  2029.                 $courseAddTimes->setCatLeader($request->get('courseleader'));
  2030.                 $courseAddTimes->setCatDays($request->get('courseDays'));
  2031.                 $courseAddTimes->setCatNumber($request->get('coursenumber'));
  2032.                 $courseAddTimes->setCatBookingOption($request->get('booking_option'));
  2033.                 $courseAddTimes->setCatMaxOnline($request->get('courseMaxOnline'));
  2034.                 $courseAddTimes->setCatMaxOffline($request->get('courseMaxOffline'));
  2035.                 
  2036.                 $em->persist($courseAddTimes);
  2037.                 $em->flush();
  2038.             }
  2039.         } 
  2040.         else if($request->get('mode') == '2' || $request->get('mode') == 2)
  2041.         {
  2042.             $price = str_replace(".","#",$request->get('price2'));
  2043.             $price = str_replace(",",".",$price);
  2044.             $price = str_replace("#",",",$price);
  2045.             $price = number_format($price,2,'.',',');
  2046.             $tax = number_format((float)$request->get('tax2'),2,'.',',');
  2048.             $repository = $this->getDoctrine()->getRepository(Article::class);
  2049.             $article = $repository->findOneBy(['id' => $request->get('articleID')]);
  2051.             $id = $request->get('articleID');
  2053.             $article->setAName($request->get('articlename'));
  2054.             $article->setASbNumber($request->get('coursesbnumber2'));
  2055.             $article->setACategory($request->get('coursecategory2'));
  2056.             $article->setADescription($request->get('description2'));
  2057.             $article->setAPrice($price);
  2058.             $article->setATax($tax);
  2059.             $article->setAActive(1);
  2060.             $article->setAPlace(1);
  2061.             $article->setACostplace($request->get('costplace2'));
  2062.             $article->setADiscount($request->get('discount2'));
  2063.             
  2064.             $em = $this->getDoctrine()->getManager();
  2065.             $em->persist($article);
  2066.             $em->flush();
  2067.         
  2068.              //save Images  
  2069.              $pic = $request->files->get('courseImage2');
  2070.              if($pic != "")
  2071.              {
  2072.                  $repository = $this->getDoctrine()->getRepository(ArticleImages::class);
  2073.                  $pics = $repository->findOneBy(['ai_aid' => $id]);
  2074.  
  2075.                  $em = $this->getDoctrine()->getManager();
  2076.                  $em->remove($pics);
  2077.                  $em->flush();
  2078.  
  2079.                  $folder =  $this->getParameter('kernel.project_dir')."/public/courseImages/";
  2080.                  if(!file_exists($folder)){mkdir($folder);}
  2081.                  
  2082.                  $subfolder = $folder.$id."/";
  2083.                  if(!file_exists($subfolder)){mkdir($subfolder);}
  2084.  
  2085.                  $uniqid = uniqid();
  2086.  
  2087.                  $path = $subfolder.$uniqid."_".$pic->getClientOriginalName();
  2088.                  if(file_exists($path)){unlink($path);}
  2089.  
  2090.                  $newFilename = $uniqid.'_'.$pic->getClientOriginalName();
  2091.                  $pic->move($subfolder, $newFilename);
  2092.  
  2093.                  $articleImages = new ArticleImages();
  2094.                  $articleImages->setAiAid($id);
  2095.                  $articleImages->setAiPath(str_replace($publicImagePath,'.',$path));
  2096.                  $em->persist($articleImages);
  2097.                  $em->flush();
  2098.              }
  2099.             
  2100.         }
  2101.         $response = $this->forward('App\Controller\CourseController::backendCourse', []);
  2102.         return $response;
  2103.         
  2104.     }
  2106.     /**
  2107.     * @Route("/loadContent/{category}/{period}", name="loadContent")
  2108.     */
  2109.     public function loadContent($category,$period)
  2110.     {
  2111.         include("./include/global.php");
  2112.         include("./include/function.php");
  2113.         
  2114.         if($category == ""){$category = '0';}
  2115.         $place = '0';
  2117.         if($place == '0')
  2118.         {
  2119.             $session = $this->requestStack->getSession(); //$session = $this->get('session');
  2120.             $place = $session->get('place');
  2121.         } 
  2123.         $d1 = new \DateTime(date("Y-m-d"));
  2124.         
  2125.         $em2 = $this->getDoctrine()->getManager();   
  2126.                     
  2127.         
  2128.         if($company == 'KVO')
  2129.         {
  2130.             $query = "UPDATE course SET c_active = 0  WHERE c_active_untill < :date ";
  2131.             $statement = $em2->getConnection()->prepare($query);
  2132.             $statement->bindValue('date',date("Y-m-d"));
  2133.             $statement->execute();
  2134.             
  2135.         }
  2136.         else
  2137.         {
  2138.   /*
  2139.             $query = "SELECT * FROM course WHERE c_active = 1";
  2140.             
  2141.             $course = $em2->getConnection()->prepare($query);
  2142.             $course->bindValue('category',$category);
  2143.             $course->execute();
  2144.             $course2 = $course->fetchAll();
  2145. */
  2146.             if($period == 0)
  2147.             {
  2148.                 $repository = $this->getDoctrine()->getRepository(Course::class);
  2149.                 $course = $repository->findBy(['c_active' => '1','c_category' => $category]);
  2150.             }
  2151.             else
  2152.             {
  2153.                 $repository = $this->getDoctrine()->getRepository(Course::class);
  2154.                 $course = $repository->findBy(['c_active' => '1','c_category' => $category, 'c_period' => $period]);
  2155.             }
  2157.             //            foreach($course2 as $cours)
  2158.             foreach($course as $cours)
  2159.             {
  2160.                 $repository = $this->getDoctrine()->getRepository(CourseTimes::class);
  2161.                 $times = $repository->findOneBy(['ctt_cid' => $cours->getId()],['ctt_day' => 'DESC']);
  2162.                 if($times)
  2163.                 {
  2165.                     $tmp = $times->getCttDay();
  2166.                     $tmp = $tmp->format('Y-m-d');
  2167.                     
  2168.                     if($tmp < date("Y-m-d"))
  2169.                     {
  2170.                         $query = "UPDATE course SET c_active = 0  WHERE id = :id ";
  2171.                         $statement = $em2->getConnection()->prepare($query);
  2172.                         $statement->bindValue('id',$times->getCttCid());
  2173.                         $statement->execute();
  2174.                     }
  2175.                 }
  2176.             }
  2177.         }
  2178.         
  2181.         $em2 = $this->getDoctrine()->getManager();   
  2182.         if($company != "KVO")
  2183.         {
  2184.             if($period == 0)
  2185.             {
  2186.                 //$query = "SELECT * FROM course WHERE c_category = :category AND c_active = 1  AND c_visible_from <= :visible ORDER BY c_period DESC, c_name ASC";
  2187.                 $query = "SELECT * FROM course WHERE c_category = :category AND c_visible_from <= :visible ORDER BY c_period DESC, c_name ASC";
  2188.                 $course = $em2->getConnection()->executeQuery($query,['category' => $category, 'visible' => date("Y-m-d H:i:s") ]);
  2189.             }
  2190.             else
  2191.             {
  2192.                 //$query = "SELECT * FROM course WHERE c_category = :category AND c_active = 1  AND c_visible_from <= :visible  ORDER BY c_period DESC, c_name ASC";
  2193.                 $query = "SELECT * FROM course WHERE c_category = :category AND c_visible_from <= :visible  ORDER BY c_period DESC, c_name ASC";
  2194.                 $course = $em2->getConnection()->executeQuery($query,['category' => $category, 'visible' => date("Y-m-d H:i:s") ]);
  2195.             }
  2196.         }
  2197.         else
  2198.         {
  2199.             $query = "SELECT * FROM course WHERE c_category = :category AND c_active = 1 ORDER BY c_name ASC";
  2200.             $course = $em2->getConnection()->executeQuery($query,['category' => $category ]);
  2202.         }
  2204.                                 
  2205.         
  2206.         $output = '';
  2207.         $output .= '<div class="class">';
  2208.         $output .= '<div class="container">';
  2209.         
  2210.         $output .= '<div class="section-header text-center wow zoomIn" data-wow-delay="0.1s" style="visibility: visible; animation-delay: 0.1s; animation-name: zoomIn;">';
  2211.         $output .= '    <p>Unsere Kurse</p>';
  2212.         $output .= '</div>';
  2213.         
  2214.         $lastperiod = 0;
  2215.         $output .= '<div class="row" id="periodFilter">';
  2216.         $output .= '<div class="col-12">';
  2217.         $output .= '    <ul id="class-filter">';
  2218.         if($period == 0)
  2219.         {
  2220.             $output .= '        <li data-filter="*" class="filter-active">Alle Perioden</li>';
  2221.         }
  2222.         else
  2223.         {
  2224.             $output .= '        <li data-filter="*" onclick="periodFilter(\''.$url.'\',0);" >Alle Perioden</li>';
  2225.         }
  2226.         foreach($course as $cours)
  2227.         {
  2228.             if($cours['c_period'] == 0){ continue; }
  2229.             $cont = false;
  2230.             if($place != "0")
  2231.             {
  2232.                 
  2233.                 $repository = $this->getDoctrine()->getRepository(CostPlace::class);
  2234.                 $costplace = $repository->findBy(['cp_active' => 1, 'cp_place' => $place]);
  2235.                 foreach($costplace as $cp)
  2236.                 {
  2237.                     if($cours['c_costplace'] == $cp->getId() )
  2238.                     {
  2239.                        $cont = true;
  2240.                     }
  2241.                 }
  2242.             }
  2243.             if(!$cont)
  2244.             {
  2245.                 continue;
  2246.             }
  2248.             $repository = $this->getDoctrine()->getRepository(CourseTimes::class);
  2249.             $times = $repository->findOneBy(['ctt_cid' => $cours['id']],['ctt_day' => 'DESC']);
  2250.             $contTime = false;
  2251.             if($times)
  2252.             {
  2253.                 $tmp = $times->getCttDay();
  2254.                 $tmp = $tmp->format('Y-m-d');
  2255.                 
  2256.                 if($tmp < date("Y-m-d"))
  2257.                 {
  2258.                     $contTime = true;
  2259.                 }
  2260.             }
  2261.             if($contTime == true){ continue; }
  2262.             
  2263.             if($lastperiod == 0 || $lastperiod != $cours['c_period'])
  2264.             {
  2265.                 // show period
  2266.                 if($period == $cours['c_period'])
  2267.                 {
  2268.                     $output .= '        <li data-filter="*" class="filter-active" >'.$globalPeriods[$cours['c_period']].'</li>';
  2269.                 }
  2270.                 else
  2271.                 {
  2272.                     $output .= '        <li data-filter="*" onclick="periodFilter(\''.$url.'\','.$cours['c_period'].');">'.$globalPeriods[$cours['c_period']].'</li>';
  2273.                 }
  2274.             }
  2275.             $lastperiod = $cours['c_period'];
  2276.             
  2277.         }
  2278.         $output .= '</ul>';
  2279.         $output .= '</div>';
  2280.         $output .= '</div>';
  2282.         $anzProd = $globAmnProd;
  2283.         $i = 0;
  2284.         $firstUsed = false;
  2285.         //foreach($course as $cours)
  2286.         $lastperiod = 0;
  2289.         if($company != "KVO")
  2290.         {
  2291.             if($period == 0)
  2292.             {
  2293.                 $query = "SELECT id FROM course WHERE c_category = :category AND  (c_active_untill = '1970-01-01' OR c_active_from = '1970-01-01')  AND c_visible_from <= :visible ORDER BY  c_period DESC, c_name ASC";
  2294.                 $course = $em2->getConnection()->executeQuery($query,['category' => $category, 'visible' => date("Y-m-d H:i:s") ]);
  2295.             }
  2296.             else
  2297.             {
  2298.                 $query = "SELECT id FROM course WHERE c_category = :category AND  (c_active_untill = '1970-01-01' OR c_active_from = '1970-01-01')  AND c_visible_from <= :visible AND c_period = :period ORDER BY  c_period DESC, c_name ASC";
  2299.                 $course = $em2->getConnection()->executeQuery($query,['category' => $category, 'visible' => date("Y-m-d H:i:s"), 'period' => $period ]);
  2300.             }
  2302.             foreach($course as $cours)
  2303.             {
  2304.                 $query3 = "SELECT MIN(ctt_day) AS mindat, MAX(ctt_day) AS maxdat FROM course_times WHERE ctt_cid = :cid ";
  2305.                 $result = $em2->getConnection()->executeQuery($query3,['cid' => $cours['id'] ]);
  2306.                 while (($row = $result->fetchAssociative()) !== false)
  2307.                 {
  2308.                     $query4 = "UPDATE course SET c_active_from = :min , c_active_untill = :max  WHERE id = :id ";
  2309.                     $statement = $em2->getConnection()->prepare($query4);
  2310.                     $statement->bindValue('min',$row['mindat']);
  2311.                     $statement->bindValue('max',$row['maxdat']);
  2312.                     $statement->bindValue('id',$cours['id']);
  2313.                     $statement->execute();
  2314.                 }
  2315.             }
  2317.         }
  2321.         $query = "SELECT * FROM course WHERE c_category = :category AND c_visible_from <= :visible AND c_period = :period ORDER BY  c_period DESC, c_name ASC";
  2322.         $course = $em2->getConnection()->executeQuery($query,['category' => $category, 'visible' => date("Y-m-d H:i:s"), 'period' => $period ]);
  2323.     
  2324.         if($company != "KVO")
  2325.         {
  2326.             if($period == 0)
  2327.             {
  2328.                 $query = "SELECT * FROM course WHERE c_category = :category AND  c_visible_from <= :visible ORDER BY c_active_from DESC, c_period DESC, c_name ASC";
  2329.                 $course = $em2->getConnection()->executeQuery($query,['category' => $category, 'visible' => date("Y-m-d H:i:s") ]);
  2330.             }
  2331.             else
  2332.             {
  2333.                 $query = "SELECT * FROM course WHERE c_category = :category AND c_visible_from <= :visible AND c_period = :period ORDER BY c_active_from DESC, c_period DESC, c_name ASC";
  2334.                 $course = $em2->getConnection()->executeQuery($query,['category' => $category, 'visible' => date("Y-m-d H:i:s"), 'period' => $period ]);
  2335.             }
  2336.         }
  2337.         else
  2338.         {
  2339.             $query = "SELECT * FROM course WHERE c_category = :category AND c_active = 1 ORDER BY c_name ASC";
  2340.             $course = $em2->getConnection()->executeQuery($query,['category' => $category ]);
  2341.         }
  2344.         foreach($course as $cours)
  2345.         {
  2347.             $repository = $this->getDoctrine()->getRepository(CourseTimes::class);
  2348.             $times = $repository->findOneBy(['ctt_cid' => $cours['id']],['ctt_day' => 'DESC']);
  2349.             $contTime = false;
  2350.             if($times)
  2351.             {
  2352.                 $tmp = $times->getCttDay();
  2353.                 $tmp = $tmp->format('Y-m-d');
  2354.                 
  2355.                 if($tmp < date("Y-m-d"))
  2356.                 {
  2357.                     $contTime = true;
  2358.                 }
  2359.             }
  2360.             if($contTime == true){ continue; }
  2362.             if($cours['c_period'] == 0){ continue; }
  2364.             $cont = false;
  2365.             if($place != "0")
  2366.             {
  2367.                 
  2368.                 $repository = $this->getDoctrine()->getRepository(CostPlace::class);
  2369.                 $costplace = $repository->findBy(['cp_active' => 1, 'cp_place' => $place]);
  2370.                 foreach($costplace as $cp)
  2371.                 {
  2372.                     if($cours['c_costplace'] == $cp->getId() )
  2373.                     {
  2374.                        $cont = true;
  2375.                     }
  2376.                 }
  2377.             }
  2378.             if(!$cont)
  2379.             {
  2380.                 continue;
  2381.             }
  2383.             
  2384.             //only employee
  2385.             if($cours['c_visible'] == '1')
  2386.             {
  2387.                 if($this->get('security.token_storage')->getToken()->getUser() == 'anon.')
  2388.                 {
  2389.                     //Guest
  2390.                     continue;
  2391.                 }
  2392.                 else
  2393.                 {
  2394.                     $uid2 = $this->get('security.token_storage')->getToken()->getUser();
  2395.                     $role = $uid2->getURole();
  2396.                     
  2397.                     if($role == 1 || $role == 2)
  2398.                     {
  2399.                         //Customer
  2400.                         continue;
  2401.                     }
  2402.                 }
  2403.             }
  2404.                         
  2405.             //if first entries of the course are full then skip course. 
  2406.             $repository = $this->getDoctrine()->getRepository(CourseTimes::class);
  2407.             $cit = $repository->findBy(['ctt_cid' => $cours['id']],['ctt_day' => 'ASC']);
  2408.             $weekdays = array();
  2409.             $stopit = false;
  2410.             $weekday_counter = array();
  2411.             $active = 0;
  2412.             $active2 = 0;
  2413.             foreach($cit as $days )
  2414.             {
  2415.                 if($days->getCttDay()->format('Y-m-d') < date('Y-m-d')){ continue; }
  2416.                 $tmp = $days->getCttDay();
  2417.                 $tmp = $tmp->format('d-m-Y');
  2418.                 if(array_key_exists(date('N', strtotime($tmp)),$weekday_counter))
  2419.                 {
  2420.                     if($weekday_counter[date('N', strtotime($tmp))] == 2){ continue; }
  2421.                 }
  2422.                 //if($weekday_counter[date('N', strtotime($tmp))] == ""){ $weekday_counter[date('N', strtotime($tmp))] = 0; }
  2423.                 if(!array_key_exists(date('N', strtotime($tmp)),$weekday_counter)){  $weekday_counter[date('N', strtotime($tmp))] = 0; }
  2425.                 if( $days->getCttOnline() <  $days->getCttMaxonline())
  2426.                 {
  2427.                     $active = 1; 
  2428.                 }
  2429.                 if($days->getCttOfflineCustomer() <  $days->getCttMaxoffline() && $days->getCttOnline() >=  $days->getCttMaxonline())
  2430.                 {
  2431.                     $active2 = 1;
  2432.                 }
  2434.                 if($days->getCttOfflineCustomer() >=  $days->getCttMaxoffline() && $days->getCttOnline() >=  $days->getCttMaxonline())
  2435.                 {
  2436.                     $weekdays[date('N', strtotime($tmp))] = 1;
  2438.                     $weekday_counter[date('N', strtotime($tmp))] = $weekday_counter[date('N', strtotime($tmp))] + 1;
  2439.                 }
  2440.                 else
  2441.                 {
  2442.                     $weekdays[date('N', strtotime($tmp))] = 0;
  2443.                     $weekday_counter[date('N', strtotime($tmp))] = $weekday_counter[date('N', strtotime($tmp))] + 1;
  2444.                     //break;                    
  2445.                 }
  2446.             }
  2448.             foreach($weekdays as $we)
  2449.             {
  2450.                 if($we == 1){ $stopit = true; break; }
  2451.             }
  2453.             if($stopit == true)
  2454.             {
  2455.                 //continue;
  2456.             }
  2457.             
  2458.             $repository = $this->getDoctrine()->getRepository(CourseTimes::class);
  2459.             $cit = $repository->findBy(['ctt_cid' => $cours['id']],['ctt_day' => 'ASC']);
  2460.             foreach($cit as $days )
  2461.             {
  2462.                 if( $days->getCttOnline() <  $days->getCttMaxonline())
  2463.                 {
  2464.                     $active = 1; 
  2465.                 }
  2466.                 if($days->getCttOfflineCustomer() <  $days->getCttMaxoffline() && $days->getCttOnline() >=  $days->getCttMaxonline())
  2467.                 {
  2468.                     $active2 = 1;
  2469.                 }
  2470.             }
  2471.             
  2472.             //display
  2473.             $repository = $this->getDoctrine()->getRepository(CourseImages::class);
  2474.             $image = $repository->findOneBy(['ci_cid' => $cours['id']]);
  2475.             
  2477.             if($lastperiod == 0 || $lastperiod != $cours['c_period'])
  2478.             {
  2479.                 // show period
  2480.                 if($lastperiod != 0)
  2481.                 {
  2482.                     $output .= '</div>';
  2483.                 }
  2484.                 $output .= '<h3>'.$globalPeriods[$cours['c_period']].' '.date("Y",strtotime($cours['c_active_from'])).'</h3>';
  2485.                 $output .= '<div class="row class-container">';
  2486.                 $i = 0;
  2487.             }
  2490.             $lastperiod = $cours['c_period'];
  2492.             if($i == 0)
  2493.             {
  2494.                 $firstUsed = true;
  2495.                 if($active == '1')
  2496.                 {
  2497.                     $output .= '<div id="first" class="col-lg-4 col-md-6 col-sm-12 class-item filter-1 wow fadeInUp" data-wow-delay="0.0s" style="cursor:pointer" onclick="openArticle('.$cours['id'].',\''.$url.'\',\'1\' )">';
  2498.                 }
  2499.                 else
  2500.                 {
  2501.                     $uid2 = $this->get('security.token_storage')->getToken()->getUser();
  2502.                     if(is_object($uid2))
  2503.                     {
  2504.                         $role = $uid2->getURole();
  2505.                     }
  2506.                     else
  2507.                     {
  2508.                         $role = 0;
  2509.                     }
  2510.                     
  2511.                     if($active2 = '1' && $role >= 3 )
  2512.                     {
  2513.                         $output .= '<div id="first" class="col-lg-4 col-md-6 col-sm-12 class-item filter-1 wow fadeInUp" data-wow-delay="0.0s" style="cursor:pointer" onclick="openArticle('.$cours['id'].',\''.$url.'\',\'1\' )">';
  2514.                     }
  2515.                     else
  2516.                     {
  2517.                         $output .= '<div id="first" class="col-lg-4 col-md-6 col-sm-12 class-item filter-1 wow fadeInUp" data-wow-delay="0.0s" style="cursor:pointer">';
  2518.                     }
  2519.                 }
  2520.             }
  2521.             else
  2522.             {
  2523.                 if($active == '1')
  2524.                 {
  2525.                     $output .= '<div class="col-lg-4 col-md-6 col-sm-12 class-item filter-1 wow fadeInUp" data-wow-delay="0.0s" style="cursor:pointer" onclick="openArticle('.$cours['id'].',\''.$url.'\',\'1\' )">';
  2526.                 }
  2527.                 else
  2528.                 {
  2529.                     $uid2 = $this->get('security.token_storage')->getToken()->getUser();
  2530.                     if(is_object($uid2))
  2531.                     {
  2532.                         $role = $uid2->getURole();
  2533.                     }
  2534.                     else
  2535.                     {
  2536.                         $role = 0;
  2537.                     }
  2539.                     if($active2 = '1' && $role >= 3 )
  2540.                     {
  2541.                         $output .= '<div class="col-lg-4 col-md-6 col-sm-12 class-item filter-1 wow fadeInUp" data-wow-delay="0.0s" style="cursor:pointer" onclick="openArticle('.$cours['id'].',\''.$url.'\',\'1\' )">';
  2542.                     }
  2543.                     else 
  2544.                     {
  2545.                         $output .= '<div class="col-lg-4 col-md-6 col-sm-12 class-item filter-1 wow fadeInUp" data-wow-delay="0.0s" style="cursor:pointer">';
  2546.                     }
  2547.                 }
  2548.             }
  2549.             $output .= '<div class="class-wrap">';
  2550.             $output .= '<div class="class-img">';
  2551.             if($active == '1')
  2552.             {
  2553.                 $output .= '<img src="'.$url.$image->getCiPath().'">';
  2554.             }
  2555.             else
  2556.             {
  2557.                 $output .= '<img src="'.$url.$image->getCiFullPath().'">';
  2558.             }
  2559.             $output .= '</div>';
  2562.           //  $output .= '<span style="'.$defaultColor.'" >'.$cours['c_name'].'</span><br>';
  2564.             $output .= '<div class="class-text">';
  2565.             //$output .= '<div class="class-teacher">';
  2566.             //$output .= '    <img src="" alt="Image">';
  2567.             //$output .= '    <h3>Johannes der Täufer</h3>';
  2568.             //$output .= '    <a href="">+</a>';
  2569.             //$output .= '</div>';
  2570.             $output .= '<h2>'.$cours['c_name'].'</h2>';
  2571.             $output .= '<div class="class-meta">';
  2572.             //$output .= '    <p><i class="far fa-calendar-alt"></i>Sun, Tue, Thu</p>';
  2573.             //$output .= '    <p><i class="far fa-clock"></i>9:00 - 10:00</p>';
  2574.         
  2575.             $output .= '</div>';
  2576.             $output .= '</div>';
  2577.             $output .= '</div>';
  2578.             $output .= '</div>';
  2579.             
  2581.             $i++;
  2582.         }
  2584.         $repository = $this->getDoctrine()->getRepository(Article::class);
  2585.         /*
  2586.         if($place == '0' && $category != '0')
  2587.         {
  2588.             $article = $repository->findBy(['a_category' => $category, 'a_active' => 1]);
  2589.         }
  2590.         else
  2591.         {
  2592.             $article = $repository->findBy(['a_active' => 1]);
  2593.         }
  2594.         */
  2595.         $article = $repository->findBy(['a_category' => $category, 'a_active' => 1]);
  2596.         
  2597.         foreach($article as $art)
  2598.         {
  2599.             $cont = false;
  2600.             if($place != "0")
  2601.             {
  2602.                 
  2603.                 $repository = $this->getDoctrine()->getRepository(CostPlace::class);
  2604.                 $costplace = $repository->findBy(['cp_active' => 1, 'cp_place' => $place]);
  2606.                 foreach($costplace as $cp)
  2607.                 {
  2608.                     if($art->getACostplace() == $cp->getId() )
  2609.                     {
  2610.                        $cont = true;
  2611.                     }
  2612.                 }
  2613.             }
  2614.             /*
  2615.             else
  2616.             {
  2617.                 $cont = true; 
  2618.             }
  2619.             */
  2620.             if(!$cont)
  2621.             {
  2622.                 continue;
  2623.             }
  2625.             $repository = $this->getDoctrine()->getRepository(ArticleImages::class);
  2626.             $image = $repository->findOneBy(['ai_aid' => $art->getid()]);
  2628.             if($i == 0 && $firstUsed == false)
  2629.             {
  2630.                 $firstUsed = true;
  2631.                 $output .= '<div id="first" class="col-sm" align="left" style="cursor:pointer" onclick="openArticle('.$art->getid().',\''.$url.'\', \'2\' )">';
  2632.             }
  2633.             else
  2634.             {
  2635.                 $output .= '<div class="col-sm" align="left" style="cursor:pointer" onclick="openArticle('.$art->getid().',\''.$url.'\', \'2\' )">';
  2636.             }
  2637.             $output .= '<div  style="max-width: 200px;background-color: '.$mainboxColor.'">';
  2638.             $output .= '<img class="imgWithHighlightBorder" width="200px" height="200px" src="'.$url.$image->getAiPath().'">';
  2639.             $output .= '<br />';
  2640.             $output .= '<span style="'.$defaultColor.'" >'.$art->getAName().'</span><br>';
  2641.             $output .= '<span style="'.$defaultColor.'" >'.number_format($art->getAPrice(),2,',','.').' &euro;</span>';
  2643.             $output .= '</div>';
  2644.             $output .= '</div>';
  2645.            
  2646.             
  2647.             $i++;
  2648.         }
  2649.         $output .= '</div>';
  2650.         if(!$course && !$article)
  2651.         {   
  2652.             if($category == '0' || $category == '')
  2653.             {
  2654.                 $output = '<span style="'.$defaultColor.'">Bitte wählen Sie eine Kategorie aus</span>';
  2655.             }
  2656.             else
  2657.             {
  2658.                 $output = '<span style="'.$defaultColor.'">Es wurden leider keine Kurse / Produkte gefunden</span>';
  2659.             }
  2660.         }
  2661.         else 
  2662.         {
  2663.             if($i == 0)
  2664.             {
  2665.                 $output = '<span style="'.$defaultColor.'">Es wurden leider keine Kurse / Produkte gefunden</span>';
  2666.             } 
  2667.         }
  2668.         $output .= '</div>';
  2669.         $output .= '</div>';
  2670.         return new Response($output);
  2671.         die();
  2672.     }
  2674.     /**
  2675.     * @Route("/openArticle/{id}/{mode}", name="openArticle")
  2676.     */
  2677.     public function openArticle($id, $mode)
  2678.     {
  2679.         require_once("./include/global.php");
  2680.         require_once("./include/function.php");
  2681.         
  2682.         $em = $this->getDoctrine()->getManager();   
  2683.        
  2684.         
  2685.         $repository = $this->getDoctrine()->getRepository(Cart::class);
  2686.         $cart = $repository->findAll();
  2687.         foreach($cart as $ca)
  2688.         {
  2689.             $time = $ca->getCaNow()->format('Y-m-d H:i:s');
  2690.             $time = date("Y-m-d H:i:s",strtotime($time));
  2691.             if($time < date("Y-m-d H:i:s",strtotime("-".$cartMaxTime." Minutes"))  )
  2692.             {
  2693.                 if($ca && $ca != null && is_null($ca) == false )
  2694.                 {
  2695.                     $em->remove($ca);
  2696.                     $em->flush();
  2697.                 }
  2698.             }
  2699.         }
  2700.         
  2702.         $discount = "0";
  2703.         $siblingdiscount = "0";
  2704.         $costplace = "";
  2705.         $period = "0";
  2706.         $price = "0";
  2707.         if($mode == '1')
  2708.         {
  2710.             $repository = $this->getDoctrine()->getRepository(Course::class);
  2711.             $course = $repository->findOneBy(['id' => $id]);
  2712.             
  2713.             $costplace = $course->getCCostplace();
  2714.             $period = $course->getCPeriod();
  2715.             $discount = $course->getCDiscount();
  2716.             $siblingdiscount = $course->getCSiblingDiscount();
  2717.             $price = $course->getCPrice();
  2718.             
  2719.             $repository = $this->getDoctrine()->getRepository(CourseImages::class);
  2720.             $images = $repository->findOneBy(['ci_cid' => $id]);
  2721.             
  2722.             $repository = $this->getDoctrine()->getRepository(CourseCategories::class);
  2723.             $cat = $repository->findOneBy(['id' => $course->getCCategory()]);
  2724.             $maxBuy = $cat->getCcMaxamount();
  2725.             
  2726.             $daysString = "";
  2727.             $daysArr = array();
  2728.             $repository = $this->getDoctrine()->getRepository(CourseTimes::class);
  2729.             $cit = $repository->findBy(['ctt_cid' => $course->getId()]);
  2730.             
  2731.             $weekdays = array();
  2733.             foreach($cit as $days )
  2734.             {
  2736.                 $tmp = $days->getCttDay();
  2737.                 $tmp = $tmp->format('d-m-Y');
  2738.                 $weekdays[date('N', strtotime($tmp))] = 1;
  2740.                 array_push($daysArr,$tmp); 
  2741.             }
  2742.             $daysArr = array_unique($daysArr);
  2743.             $daysString = '';
  2744.             foreach($daysArr as $day)
  2745.             {
  2746.                 $daysString .= $day.',';
  2747.             }
  2748.             $daysString  = substr($daysString,0,-1);
  2749.             ksort($weekdays);
  2750.         }
  2751.         else if($mode == '2')
  2752.         {
  2753.             
  2754.             $repository = $this->getDoctrine()->getRepository(Article::class);
  2755.             $article = $repository->findOneBy(['id' => $id]);
  2756.             $price = $article->getAPrice();
  2757.             $discount = $article ->getADiscount();
  2758.             
  2759.             $costplace = $article->getACostplace();
  2761.             $repository = $this->getDoctrine()->getRepository(ArticleImages::class);
  2762.             $images = $repository->findOneBy(['ai_aid' => $id]);
  2763.             
  2764.             $repository = $this->getDoctrine()->getRepository(CourseCategories::class);
  2765.             $cat = $repository->findOneBy(['id' => $article->getACategory()]);
  2766.             $maxBuy = $cat->getCcMaxamount();
  2767.         }
  2769.         if($discount != "0")
  2770.         {
  2772.            if($this->get('security.token_storage')->getToken()->getUser() == 'anon.')
  2773.            {
  2774.                 //Guest, check only cart. if > 1 Item and not highest price then Discount 
  2775.                 
  2776.                 $session = $this->requestStack->getSession(); //$session = $this->get('session');
  2777.             
  2778.                 if(!$session->get('cartitems')){$session->set('cartitems', 0);}
  2779.                 
  2780.                 $cartitems = $session->get('cartitems');
  2781.                 if($cartitems > 0)
  2782.                 {
  2783.                     //check if other prices higher / lower
  2784.                     $x = 0;
  2785.                     $end = $session->get('cartitems');
  2786.                     for($i = 1; $i <= $end; $i++ )
  2787.                     {
  2788.                         $mode2 = $session->get('cartItemMode'.$i);
  2789.                         if($mode2 == '1')
  2790.                         {
  2791.                             //course
  2792.                             $repository = $this->getDoctrine()->getRepository(Course::class);
  2793.                             $tmp = $repository->findOneBy(['id' => $session->get('cartCourse'.$i)]);
  2794.                             $price2 = $tmp->GetCPrice();
  2795.                         }
  2796.                         else
  2797.                         {
  2798.                             //article
  2799.                             $repository = $this->getDoctrine()->getRepository(Article::class);
  2800.                             $tmp = $repository->findOneBy(['id' => $session->get('cartArticle'.$i)]);
  2801.                             $price2 = $tmp->GetAPrice();
  2802.                         }
  2804.                         
  2805.                         if($price <= $price2)
  2806.                         {
  2807.                             $x++;
  2808.                         }
  2809.                     
  2810.                        
  2811.                     }           
  2812.                     
  2813.                     // x == amount of orders with higher price
  2815.                     $repository = $this->getDoctrine()->getRepository(Costplace::class);
  2816.                     $tmp = $repository->findOneBy(['id' => $costplace]);
  2817.                     $place = $tmp->getCpPlace();
  2819.                     $y = 0;
  2820.                     $discountArr = array();
  2821.                     $repository = $this->getDoctrine()->getRepository(Discount::class);
  2822.                     $discount = $repository->findBy(['d_place' => $place],['d_amount' => 'ASC']);
  2823.                     foreach($discount as $d)
  2824.                     {
  2825.                         $discountArr[$y] = $d->getDAmount();
  2826.                         $y++;
  2827.                     }
  2828.                     
  2829.                     if($x == 2) // middle discount
  2830.                     {
  2831.                         $discount = $discountArr[1];
  2832.                     } 
  2833.                     else if($x >= 3) // highest discount
  2834.                     {
  2835.                         $discount = $discountArr[2];
  2836.                     }
  2837.                     else // lowest discount
  2838.                     {
  2839.                         $discount = $discountArr[0];
  2840.                     }
  2842.                 }
  2843.                 else
  2844.                 {
  2845.                     $discount  = 0;
  2846.                 }
  2848.             }
  2849.             else
  2850.             {
  2851.                 // existing user
  2853.                 // check only cart & all order in the same period. if > 1 Item then Discount 
  2854.                 $session = $this->requestStack->getSession(); //$session = $this->get('session');
  2855.                 if(!$session->get('cartitems')){$session->set('cartitems', 0);}
  2856.                 $cartitems = $session->get('cartitems');
  2857.                 
  2858.                 //check if other prices higher / lower
  2859.                 $x = 0;
  2860.                 for($i = 1; $i <= $cartitems; $i++ )
  2861.                 {
  2862.                     $mode2 = $session->get('cartItemMode'.$i);
  2863.                     if($mode2 == '1')
  2864.                     {
  2865.                         //course
  2866.                         $repository = $this->getDoctrine()->getRepository(Course::class);
  2867.                         $tmp = $repository->findOneBy(['id' => $session->get('cartCourse'.$i)]);
  2868.                         $price2 = $tmp->GetCPrice();
  2869.                     }
  2870.                     else
  2871.                     {
  2872.                         //article
  2873.                         $repository = $this->getDoctrine()->getRepository(Article::class);
  2874.                         $tmp = $repository->findOneBy(['id' => $session->get('cartArticle'.$i)]);
  2875.                         $price2 = $tmp->GetAPrice();
  2876.                     }
  2878.                     
  2879.                     if($price <= $price2)
  2880.                     {
  2881.                         $x++;
  2882.                     }
  2883.                 
  2884.                 }           
  2885.                 
  2886.                 $curId = "0";
  2887.                 $curItem = "0";
  2888.                 
  2889.                 $usr = $this->get('security.token_storage')->getToken()->getUser();
  2890.                 $repository = $this->getDoctrine()->getRepository(Orders::class);
  2891.                 $orders = $repository->findBy(['o_uid' =>  $usr->getId()]);
  2892.                 
  2893.                 foreach($orders as $order)
  2894.                 {
  2895.                     $repository = $this->getDoctrine()->getRepository(OrderItems::class);
  2896.                     $orderItems = $repository->findBy(['oi_oid' =>  $order->getId()]);
  2898.                     foreach($orderItems as $orderItem)
  2899.                     {
  2900.                         if($orderItem->getOiCid() == 0){continue;}
  2901.                         
  2902.                         if($curId == $order->getId() && $orderItem->getOiItem() == $curItem)
  2903.                         {
  2904.                             continue;
  2905.                         }
  2906.                         
  2907.                         
  2908.                         if($orderItem->getOiPeriod() != $period){ continue; }
  2909.                         
  2910.                         if($orderItem->getOiPrice() >= $price){ $x++; }
  2911.                         $curId = $order->getId();
  2912.                         $curItem = $orderItem->getOiItem();
  2913.                     }
  2914.                 }
  2916.                 // x == amount of orders with higher price
  2918.                 $repository = $this->getDoctrine()->getRepository(Costplace::class);
  2919.                 $tmp = $repository->findOneBy(['id' => $costplace]);
  2920.                 $place = $tmp->getCpPlace();
  2922.                 $y = 0;
  2923.                 $discountArr = array();
  2924.                 $repository = $this->getDoctrine()->getRepository(Discount::class);
  2925.                 $discount = $repository->findBy(['d_place' => $place],['d_amount' => 'ASC']);
  2926.                 foreach($discount as $d)
  2927.                 {
  2928.                     $discountArr[$y] = $d->getDAmount();
  2929.                     $y++;
  2930.                 }
  2931.                 
  2932.                 if($x == 2) // middle discount
  2933.                 {
  2934.                     $discount = $discountArr[1];
  2935.                 } 
  2936.                 else if($x == 3) // highest discount
  2937.                 {
  2938.                     $discount = $discountArr[2];
  2939.                 }
  2940.                 else if($x > 3) // lowest discount
  2941.                 {
  2942.                     $discount = $discountArr[0];
  2943.                 }
  2944.                 else // lowest discount
  2945.                 {
  2946.                     $discount = $discountArr[0];
  2947.                 }
  2948.            }
  2949.         }
  2950.         $discount = 0;
  2951.             
  2952.         if($mode == '1')
  2953.         {
  2954.             $followDays = false;
  2955.             $repository = $this->getDoctrine()->getRepository(CourseAdditionalTimes::class);
  2956.             $tmp = $repository->findBy(['cat_cid' => $course->getId()]);
  2957.             foreach($tmp as $t)
  2958.             {
  2959.                 if($t->getCatBookingOption() == '2')
  2960.                 {
  2961.                     $followDays = true; break;
  2962.                 }
  2963.             }
  2965.             return $this->render('course/article_detail.html.twig',[ 'course' => $course, 'image' =>  $images ,'id' => $id, 'mode' => $mode, 'max' => $maxBuy, 'url' => $url, 'days' => $daysString, 'discount' => $discount, 'siblingDiscount' => $siblingdiscount, 'weekdays' => $weekdays, 'followDays' => $followDays]);
  2966.         }
  2967.         else if($mode == '2')
  2968.         {
  2969.             return $this->render('course/article_detail.html.twig',[ 'article' => $article, 'image' =>  $images ,'id' => $id, 'mode' => $mode, 'max' => $maxBuy, 'url' => $url, 'discount' => $discount, 'siblingDiscount' => $siblingdiscount]);
  2970.         }
  2971.         else
  2972.         {
  2973.             return $this->render('checkout/error.html.twig', [ ]);
  2974.         }
  2975.     }
  2977.      /**
  2978.      * @Route("/loadTimes/{id}/{date}/{manualEntry}/{minAmount}" , name="loadTimes", options={"expose"=true})
  2979.      */
  2980.     public function loadTimes($id, $date, $manualEntry, $minAmount )
  2981.     {
  2982.         require_once("./include/function.php");
  2983.         require_once("./include/global.php");
  2984.         
  2985.         $d1 = new \DateTime(date("Y-m-d",strtotime(checkUserInput($date))));
  2986.        
  2988.         $repository = $this->getDoctrine()->getRepository(CourseTimes::class);
  2989.         $times = $repository->findBy([
  2990.             'ctt_cid' => trim(checkUserInput($id)), 
  2991.             'ctt_day' => $d1
  2992.         ], ['ctt_from' => 'ASC']);
  2993.         
  2994.         $session = $this->requestStack->getSession(); //$session = $this->get('session');
  2996.         $output = '';
  2997.         $i = 0;
  2998.         $timesArr = array();
  3001.         foreach($times as $time)
  3002.         {
  3003.             $nd1 = $time->getCttFrom();
  3004.             $nd1 = $nd1->format('H:i'); 
  3006.             $nd2 = $time->getCttTo();
  3007.             $nd2 = $nd2->format('H:i'); 
  3009.             $nd3 = $time->getCttDay();
  3010.             $nd3 = $nd3->format('d.m.Y'); 
  3012.             if(!isset( $timesArr[$nd3][$nd1.' '.$nd2] )){$timesArr[$nd3][$nd1.' '.$nd2] = 0;}
  3013.             
  3014.             $tmp = 0;
  3015.             //$tmp = $this->getUsedSlots(trim(checkUserInput($time->getId())));
  3016.             $tmp = $time->getCttOnline() + $time->getCttOfflineCustomer();
  3018.             $maxCustomer = 0;
  3019.             $maxCustomer = $time->getCttMaxonline();
  3020.             if($this->get('security.token_storage')->getToken()->getUser() == 'anon.')
  3021.             {
  3022.                 //Guest
  3023.             }
  3024.             else
  3025.             {
  3027.                 $uid2 = $this->get('security.token_storage')->getToken()->getUser();
  3028.                 $role = $uid2->getURole();
  3030.                 if($role == 1 || $role == 2)
  3031.                 {
  3032.                     //Customer
  3033.                 }
  3034.                 else 
  3035.                 {
  3036.                     //employee
  3037.                     $maxCustomer = $maxCustomer + $time->getCttMaxoffline();
  3038.                 }
  3039.             }
  3040.             $tmp = $maxCustomer - $tmp;
  3041.             
  3042.             $timesArr[$nd3][$nd1.' '.$nd2] = $timesArr[$nd3][$nd1.' '.$nd2] + $tmp;
  3043.             
  3044.         }
  3045.         $usedArr = array();
  3046.         foreach($times as $time)
  3047.         {
  3048.             $nd1 = $time->getCttFrom();
  3049.             $nd1 = $nd1->format('H:i'); 
  3050.             
  3051.             $nd2 = $time->getCttTo();
  3052.             $nd2 = $nd2->format('H:i'); 
  3054.             $nd3 = $time->getCttDay();
  3055.             $nd3 = $nd3->format('d.m.Y'); 
  3056.             
  3057.             if(!isset( $usedArr[$nd3][$nd1.' '.$nd2] )){$usedArr[$nd3][$nd1.' '.$nd2] = 0;}
  3058.             
  3059.             
  3060.             $found = false;
  3062.             //already in Cart
  3063.             $items = $session->get('cartitems');
  3064.             for($j = 0; $j <= $items; $j++)
  3065.             {
  3066.                $tid = $session->get('cartTime'.$j);
  3067.                if(!empty($tid) && $tid == $time->getId() ){$found = true;} 
  3068.             }
  3069.             if($usedArr[$nd3][$nd1.' '.$nd2] == 0 )
  3070.             {
  3071.                 $tmp = $timesArr[$nd3][$nd1.' '.$nd2];
  3072.                 $tmp2 = $timesArr[$nd3][$nd1.' '.$nd2];
  3073.                 switch($tmp)
  3074.                 {
  3075.                     case '0': $tmp = "Leider keine Plätze mehr verfügbar";break;
  3076.                     case '1': $tmp = $tmp. " Platz offen";break;
  3077.                     default: $tmp = $tmp." Plätze offen";break;
  3078.                 }
  3080.                 if($found ==  true)
  3081.                 {
  3082.                     $output .= '<input class="btn-check" type="radio" name="articleTime" id="articleTime'.$i.'" value="'.$time->getId().'" autocomplete="off" disabled />';
  3083.                     $output .= '<label class="btn btn-secondary timeTooltip" title="'.$tmp.'" for="articleTime'.$i.'" style="'.$defaultColor2.' margin: 0 0 1rem 0;" disabled>'.$nd1.' - '.$nd2.' </label> &nbsp;';
  3084.                     
  3085.                 }
  3086.                 else if($time->getCttActive() == '0' && $tmp2 > 0)
  3087.                 {
  3088.                     continue;
  3089.                 }
  3090.                 else if($time->getCttActive() == '0' || $found == true)
  3091.                 {
  3092.                     $output .= '<input class="btn-check" type="radio" name="articleTime" id="articleTime'.$i.'" value="'.$time->getId().'" autocomplete="off" disabled />';
  3093.                     $output .= '<label class="btn btn-secondary timeTooltip" title="'.$tmp.'" for="articleTime'.$i.'" style="'.$defaultColor2.' margin: 0 0 1rem 0;" disabled>'.$nd1.' - '.$nd2.' </label> &nbsp;';
  3094.                 }
  3095.                 else
  3096.                 {
  3097.                     if($minAmount == '0')
  3098.                     {
  3099.                         if($tmp2 == 0)
  3100.                         {
  3101.                             $output .= '<input class="btn-check" type="radio" name="articleTime" id="articleTime'.$i.'" value="'.$time->getId().'" autocomplete="off" onclick="getAmount('.$time->getId().','.$time->getCttCid().')" disabled />';
  3102.                             $output .= '<label class="btn btn-success timeTooltip" title="'.$tmp.'"  for="articleTime'.$i.'" style="'.$defaultColor2.' margin: 0 0 1rem 0;" disabled>'.$nd1.' - '.$nd2.'</label> &nbsp;';
  3103.                         }
  3104.                         else
  3105.                         {
  3106.                             $output .= '<input class="btn-check" type="radio" name="articleTime" id="articleTime'.$i.'" value="'.$time->getId().'" autocomplete="off" onclick="getAmount('.$time->getId().','.$time->getCttCid().')"  />';
  3107.                             $output .= '<label class="btn btn-success timeTooltip" title="'.$tmp.'"  for="articleTime'.$i.'" style="'.$defaultColor2.' margin: 0 0 1rem 0;">'.$nd1.' - '.$nd2.'</label> &nbsp;';
  3109.                         }
  3110.                     }
  3111.                     else
  3112.                     {
  3113.                         if($tmp2 < $minAmount )
  3114.                         {
  3115.                             $output .= '<input class="btn-check" type="radio" name="articleTime" id="articleTime'.$i.'" value="'.$time->getId().'" autocomplete="off" disabled />';
  3116.                             $output .= '<label class="btn btn-success timeTooltip" title="'.$tmp.'"  for="articleTime'.$i.'" style="'.$defaultColor2.' margin: 0 0 1rem 0;" disabled>'.$nd1.' - '.$nd2.'</label> &nbsp;';
  3117.                         }
  3118.                         else
  3119.                         {
  3120.                             if($tmp2 == 0)
  3121.                             {
  3122.                                 $output .= '<input class="btn-check" type="radio" name="articleTime" id="articleTime'.$i.'" value="'.$time->getId().'" autocomplete="off" onclick="getAmount('.$time->getId().','.$time->getCttCid().')" disabled />';
  3123.                                 $output .= '<label class="btn btn-success timeTooltip" title="'.$tmp.'"  for="articleTime'.$i.'" style="'.$defaultColor2.' margin: 0 0 1rem 0;" disabled>'.$nd1.' - '.$nd2.'</label> &nbsp;';
  3124.                             }
  3125.                             else
  3126.                             {
  3127.                                 $output .= '<input class="btn-check" type="radio" name="articleTime" id="articleTime'.$i.'" value="'.$time->getId().'" autocomplete="off" onclick="getAmount('.$time->getId().','.$time->getCttCid().')" />';
  3128.                                 $output .= '<label class="btn btn-success timeTooltip" title="'.$tmp.'"  for="articleTime'.$i.'" style="'.$defaultColor2.' margin: 0 0 1rem 0;">'.$nd1.' - '.$nd2.'</label> &nbsp;';
  3129.                             }
  3130.                         }
  3131.                     }
  3132.                 } 
  3133.                 $usedArr[$nd3][$nd1.' '.$nd2] = 1;
  3134.                 $i++;
  3135.             }
  3136.         }
  3138.         if($output == "")
  3139.         {
  3140.             if($manualEntry == 1)
  3141.             {
  3142.                 $output = '<p>Es sind leider keine Termine mehr Verf&uuml;gbar. <br>Bitte w&auml;hlen Sie einen anderen Termin.</p>';
  3143.             }
  3144.             else
  3145.             {
  3146.                 $output = '<p style="'.$defaultColor.'">Es sind leider keine Termine mehr Verf&uuml;gbar. <br>Bitte w&auml;hlen Sie einen anderen Termin.</p>';
  3147.             }
  3148.         }
  3150.         return new Response($output);
  3151.     }
  3153.     /**
  3154.     * @Route("/loadWeekdayTimes/{id}/{weekday}/{manualEntry}/{minAmount}" , name="loadWeekdayTimes", options={"expose"=true})
  3155.     */
  3156.     public function loadWeekdayTimes($id, $weekday, $manualEntry, $minAmount )
  3157.     {
  3158.         require_once("./include/function.php");
  3159.         require_once("./include/global.php");
  3160.         
  3161.            if($weekday == 0){ $order = 'DESC'; }
  3162.         else { $order = 'ASC'; }
  3163.         
  3164.         $query = "SELECT * FROM course_times WHERE ctt_cid = :cid AND  ctt_day >= :day ORDER BY ctt_day ".$order;
  3165.         $em2 = $this->getDoctrine()->getManager();   
  3166.         
  3167.         $nextday = "";
  3168.         $tmp = "";
  3169.         $resultSet = $em2->getConnection()->executeQuery($query,['cid' => $id, 'day' => date("Y-m-d")]);
  3170.         foreach($resultSet as $res) 
  3171.         {
  3172.             $tmp = $res['ctt_day'];
  3173.             if($weekday != 0)
  3174.             {
  3176.                 if(date("N",strtotime($tmp)) == $weekday)
  3177.                 {
  3178.                     break;
  3179.                 }
  3180.             }
  3181.         }
  3183.         $session = $this->requestStack->getSession(); //$session = $this->get('session');
  3185.         $output = '<br>';
  3186.         $i = 0;
  3187.         $timesArr = array();
  3189.         /*
  3190.         $d1 = new \DateTime(date("Y-m-d",strtotime(checkUserInput($tmp))));
  3191.         $repository = $this->getDoctrine()->getRepository(CourseTimes::class);
  3192.         $times = $repository->findBy([
  3193.             'ctt_cid' => trim(checkUserInput($id)), 
  3194.             'ctt_day' => $d1
  3195.         ], ['ctt_from' => 'ASC']);
  3196.         */
  3197.         if($tmp == ""){ $tmp = date('Y-m-d'); } 
  3198.         $tmpTime = $tmp;
  3199.         $d2 = date('d.m.Y', strtotime('+1 week', strtotime(checkUserInput($tmpTime))));
  3200.         $d3 = date('d.m.Y', strtotime('+2 week', strtotime(checkUserInput($tmpTime))));
  3202.         //debugText( date("Y-m-d",strtotime(checkUserInput($tmpTime))));
  3203.         //debugText( date("Y-m-d",strtotime($d2)));
  3205.         //$query = "SELECT * FROM course_times WHERE ctt_cid = :cid AND  (ctt_day = :day OR ctt_day = :day2) GROUP BY ctt_number ORDER BY ctt_day ASC , ctt_from ASC";
  3206.         $query = "SELECT * FROM ( SELECT * FROM course_times WHERE ctt_cid = :cid AND (ctt_day = :day OR ctt_day = :day2 OR ctt_day = :day3) ORDER BY ctt_day ASC, ctt_from ASC LIMIT 18446744073709551615 ) AS sub GROUP BY ctt_number; ";
  3207.         $em2 = $this->getDoctrine()->getManager();   
  3208.         $times = $em2->getConnection()->executeQuery($query,['cid' => $id, 'day' => date("Y-m-d",strtotime(checkUserInput($tmpTime))), 'day2' =>  date("Y-m-d",strtotime($d2)), 'day3' =>  date("Y-m-d",strtotime($d3)) ]);
  3209.         
  3210.         $i = 0;
  3211.         foreach($times as $time)
  3212.         {
  3213.             $i++;
  3214.             //$nd1 = $time->getCttFrom();
  3215.             $nd1 = $time['ctt_from'];
  3216.             //$nd1 = $nd1->format('H:i'); 
  3217.             $nd1 = date('H:i',strtotime($nd1)); 
  3218.             
  3219.             //$nd2 = $time->getCttTo();
  3220.             $nd2 = $time['ctt_to'];
  3221.             //$nd2 = $nd2->format('H:i'); 
  3222.             $nd2 = date('H:i',strtotime($nd2)); 
  3223.             
  3224.             //$nd3 = $time->getCttDay();
  3225.             $nd3 = $time['ctt_day'];
  3226.             //$nd3 = $nd3->format('d.m.Y'); 
  3227.             $nd3 = date('d.m.Y',strtotime($nd3)); 
  3229.             if(!isset( $timesArr[$nd3][$nd1.' '.$nd2] )){$timesArr[$nd3][$nd1.' '.$nd2] = 0;}
  3230.             
  3231.             $tmp = 0;
  3232.             
  3233.             $checkCart = true;
  3234.             if($this->get('security.token_storage')->getToken()->getUser() != 'anon.')
  3235.             {
  3236.                 $uid2 = $this->get('security.token_storage')->getToken()->getUser();
  3237.                 $role2 = $uid2->getURole();
  3238.                 if($role2 == '3' || $role2 == '4' || $role2 == '5')
  3239.                 {
  3240.                     $checkCart = false;
  3241.                 }
  3242.             }
  3243.             if($checkCart == true)
  3244.             {
  3245.                 $repository = $this->getDoctrine()->getRepository(Cart::class);
  3246.                 //$cartItems = $repository->findBy(['ca_tid' => trim(checkUserInput($time->getId()))]);
  3247.                 $cartItems = $repository->findBy(['ca_tid' => trim(checkUserInput($time['id']))]);
  3248.                 foreach($cartItems as $ci)
  3249.                 {
  3250.                     $tmp = $tmp + $ci->getCaAmount();
  3251.                 }
  3252.             }
  3254.             $maxCustomer = 0;
  3255.             //$maxCustomer = $time->getCttMaxonline();
  3256.             $maxCustomer = $time['ctt_maxonline'];
  3257.             if($this->get('security.token_storage')->getToken()->getUser() == 'anon.')
  3258.             {
  3259.                 //Guest
  3260.                 //$tmp = $tmp + $time->getCttOnline();
  3261.                 $tmp = $tmp + $time['ctt_online'];
  3262.             }
  3263.             else
  3264.             {
  3265.                 
  3266.                 $uid2 = $this->get('security.token_storage')->getToken()->getUser();
  3267.                 $role = $uid2->getURole();
  3268.                 
  3269.                 //$tmp = $tmp + $time->getCttOnline();
  3270.                 $tmp = $tmp + $time['ctt_online'];
  3271.                 if($role == 1 || $role == 2)
  3272.                 {
  3273.                     //Customer
  3274.                 }
  3275.                 else 
  3276.                 {
  3277.                     //$tmp = $tmp + $time->getCttOfflineCustomer();
  3278.                     $tmp = $tmp + $time['ctt_offline_customer'];
  3279.                     //employee
  3280.                     //$maxCustomer = $maxCustomer + $time->getCttMaxoffline();
  3281.                     $maxCustomer = $maxCustomer + $time['ctt_maxoffline'];
  3282.                 }
  3283.             }
  3284.             $tmp = $maxCustomer - $tmp;
  3285.             //if($time->getCttActive() == '0'){  continue; }
  3286.             if($time['ctt_active'] == '0'){  continue; }
  3287.             $timesArr[$nd3][$nd1.' '.$nd2] = $timesArr[$nd3][$nd1.' '.$nd2] + $tmp;
  3288.             
  3289.         }
  3291.         $d2 = date('d.m.Y', strtotime('+1 week', strtotime(checkUserInput($tmpTime))));
  3292.         $d3 = date('d.m.Y', strtotime('+2 week', strtotime(checkUserInput($tmpTime))));
  3294.         //$query = "SELECT * FROM course_times WHERE ctt_cid = :cid AND  (ctt_day = :day OR ctt_day = :day2) GROUP BY ctt_number ORDER BY ctt_day ASC ,ctt_from ASC ";
  3295.         $query = "SELECT * FROM ( SELECT * FROM course_times WHERE ctt_cid = :cid AND (ctt_day = :day OR ctt_day = :day2 OR ctt_day = :day3) ORDER BY ctt_day ASC, ctt_from ASC LIMIT 18446744073709551615 ) AS sub GROUP BY ctt_number;  ";
  3296.         $em2 = $this->getDoctrine()->getManager();   
  3297.         $times = $em2->getConnection()->executeQuery($query,['cid' => $id, 'day' => date("Y-m-d",strtotime(checkUserInput($tmpTime))), 'day2' =>  date("Y-m-d",strtotime($d2)) , 'day3' =>  date("Y-m-d",strtotime($d3)) ]);
  3298.         
  3300.         $usedArr = array();
  3301.         foreach($times as $time)
  3302.         {
  3303.             //$nd1 = $time->getCttFrom();
  3304.             $nd1 = $time['ctt_from'];
  3305.             //$nd1 = $nd1->format('H:i'); 
  3306.             $nd1 = date("H:i",strtotime($nd1)); 
  3307.             
  3308.             //$nd2 = $time->getCttTo();
  3309.             $nd2 = $time['ctt_to'];
  3310.             //$nd2 = $nd2->format('H:i'); 
  3311.             $nd2 = date("H:i",strtotime($nd2)); 
  3312.             
  3313.             //$nd3 = $time->getCttDay();
  3314.             $nd3 = $time['ctt_day'];
  3315.             //$nd3 = $nd3->format('d.m.Y'); 
  3316.             $nd3 = date("d.m.Y",strtotime($nd3)); 
  3317.             
  3318.             if(!isset( $usedArr[$nd3][$nd1.' '.$nd2] )){$usedArr[$nd3][$nd1.' '.$nd2] = 0;}
  3319.             
  3320.             
  3321.             $found = false;
  3323.             //already in Cart
  3324.             $items = $session->get('cartitems');
  3325.             for($j = 0; $j <= $items; $j++)
  3326.             {
  3327.                $tid = $session->get('cartTime'.$j);
  3328.                //if(!empty($tid) && $tid == $time->getId() ){$found = true;} 
  3329.                if(!empty($tid) && $tid == $time['id'] ){$found = true;} 
  3330.             }
  3331.             if($usedArr[$nd3][$nd1.' '.$nd2] == 0 )
  3332.             {
  3333.                 $tmp = $timesArr[$nd3][$nd1.' '.$nd2];
  3334.                 $tmp2 = $timesArr[$nd3][$nd1.' '.$nd2];
  3335.                 if($tmp < 0 ){$tmp = 0;}
  3336.                 if($tmp2 < 0 ){$tmp2 = 0;}
  3337.                 switch($tmp)
  3338.                 {
  3339.                     case '0': $tmp = "Leider keine Plätze mehr verfügbar";break;
  3340.                     case '1': $tmp = $tmp. " Platz offen";break;
  3341.                     default: $tmp = $tmp." Plätze offen";break;
  3342.                 }
  3344.                 if($found ==  true)
  3345.                 {
  3346.                     $output .= '<label class="labl timeTooltip" title="'.$tmp.'" for="articleTime'.$i.'" style="'.$defaultColor2.' margin: 0 0 1rem 0;" disabled><a class="btn-disabled">'.$nd1.' - '.$nd2.'</a>';
  3347.                     //$output .= '<input class="btn-check" type="radio" name="articleTime" id="articleTime'.$i.'" value="'.$time->getId().'" autocomplete="off" disabled />';
  3348.                     $output .= '<input class="btn-check" type="radio" name="articleTime" id="articleTime'.$i.'" value="'.$time['id'].'" autocomplete="off" disabled />';
  3349.                     $output .= '</label>';
  3350.                 }
  3351.                 //else if($time->getCttActive() == '0' && $tmp2 > 0)
  3352.                 else if($time['ctt_active'] == '0' && $tmp2 > 0)
  3353.                 {
  3354.                     continue;
  3355.                 }
  3356.                 //else if($time->getCttActive() == '0' || $found == true)
  3357.                 else if($time['ctt_active'] == '0' || $found == true)
  3358.                 {
  3359.                     $output .= '<label class="labl timeTooltip" title="'.$tmp.'" for="articleTime'.$i.'" style="'.$defaultColor2.' margin: 0 0 1rem 0;" disabled><a class="btn-disabled">'.$nd1.' - '.$nd2.' </a> &nbsp;';
  3360.                     //$output .= '<input class="btn-check" type="radio" name="articleTime" id="articleTime'.$i.'" value="'.$time->getId().'" autocomplete="off" disabled />';
  3361.                     $output .= '<input class="btn-check" type="radio" name="articleTime" id="articleTime'.$i.'" value="'.$time['id'].'" autocomplete="off" disabled />';
  3362.                     $output .= '</label>';
  3363.                 }
  3364.                 else
  3365.                 {
  3366.                     if($minAmount == '0')
  3367.                     {
  3368.                         if($tmp2 == '0')
  3369.                         {
  3370.                             $output .= '<label class="labl timeTooltip" title="'.$tmp.'"  for="articleTime'.$i.'" style="'.$defaultColor2.' margin: 0 0 1rem 0;" disabled><a class="btn-disabled">'.$nd1.' - '.$nd2.'</a> &nbsp;';
  3371.                             //$output .= '<input class="btn-check" type="radio" name="articleTime" id="articleTime'.$i.'" value="'.$time->getId().'" autocomplete="off" onclick="getAmount('.$time->getId().','.$time->getCttCid().')" disabled />';
  3372.                             $output .= '<input class="btn-check" type="radio" name="articleTime" id="articleTime'.$i.'" value="'.$time['id'].'" autocomplete="off" onclick="getAmount('.$time['id'].','.$time['ctt_cid'].')" disabled />';
  3373.                             $output .= '</label>';
  3374.                         }
  3375.                         else
  3376.                         {
  3377.                             $output .= '<label class="labl timeTooltip" title="'.$tmp.'"  for="articleTime'.$i.'" style="'.$defaultColor2.' margin: 0 0 1rem 0;"><a class="btn">'.$nd1.' - '.$nd2.'</a> &nbsp;';
  3378.                             //$output .= '<input class="btn-check" type="radio" name="articleTime" id="articleTime'.$i.'" value="'.$time->getId().'" autocomplete="off" onclick="getAmount('.$time->getId().','.$time->getCttCid().')" />';
  3379.                             $output .= '<input class="btn-check" type="radio" name="articleTime" id="articleTime'.$i.'" value="'.$time['id'].'" autocomplete="off" onclick="getAmount('.$time['id'].','.$time['ctt_cid'].')" />';
  3380.                             $output .= '</label>';
  3381.                         }
  3382.                     }
  3383.                     else
  3384.                     {
  3385.                         if($tmp2 < $minAmount )
  3386.                         {
  3387.                             $output .= '<label class="labl btn-success timeTooltip" title="'.$tmp.'"  for="articleTime'.$i.'" style="'.$defaultColor2.' margin: 0 0 1rem 0;"><a class="btn-disabled">'.$nd1.' - '.$nd2.'</a> &nbsp;';
  3388.                             //$output .= '<input class="btn-check" type="radio" name="articleTime" id="articleTime'.$i.'" value="'.$time->getId().'" autocomplete="off" disabled />';
  3389.                             $output .= '<input class="btn-check" type="radio" name="articleTime" id="articleTime'.$i.'" value="'.$time['id'].'" autocomplete="off" disabled />';
  3390.                             $output .= '</label>';
  3391.                         }
  3392.                         else
  3393.                         {
  3394.                             if($tmp2 == '0')
  3395.                             {
  3396.                                 $output .= '<label class="labl timeTooltip" title="'.$tmp.'"  for="articleTime'.$i.'" style="'.$defaultColor2.' margin: 0 0 1rem 0;" disabled><a class="btn-disabled">'.$nd1.' - '.$nd2.'</a> &nbsp;';
  3397.                                 //$output .= '<input class="btn-check" type="radio" name="articleTime" id="articleTime'.$i.'" value="'.$time->getId().'" autocomplete="off" onclick="getAmount('.$time->getId().','.$time->getCttCid().')" disabled />';
  3398.                                 $output .= '<input class="btn-check" type="radio" name="articleTime" id="articleTime'.$i.'" value="'.$time['id'].'" autocomplete="off" onclick="getAmount('.$time['id'].','.$time['ctt_cid'].')" disabled />';
  3399.                                 $output .= '</label>';
  3400.                             }
  3401.                             else
  3402.                             {
  3403.                                 $output .= '<label class="labl timeTooltip" title="'.$tmp.'"  for="articleTime'.$i.'" style="'.$defaultColor2.' margin: 0 0 1rem 0;"><a class="btn">'.$nd1.' - '.$nd2.'</a> &nbsp;';
  3404.                                 //$output .= '<input class="btn-check" type="radio" name="articleTime" id="articleTime'.$i.'" value="'.$time->getId().'" autocomplete="off" onclick="getAmount('.$time->getId().','.$time->getCttCid().')" />';
  3405.                                 $output .= '<input class="btn-check" type="radio" name="articleTime" id="articleTime'.$i.'" value="'.$time['id'].'" autocomplete="off" onclick="getAmount('.$time['id'].','.$time['ctt_cid'].')" />';
  3406.                                 $output .= '</label>';
  3407.                             }
  3408.                         }
  3409.                     }
  3410.                 } 
  3411.                 $usedArr[$nd3][$nd1.' '.$nd2] = 1;
  3412.                 $i++;
  3413.             }
  3414.         }
  3416.         if($output == "")
  3417.         {
  3418.             if($manualEntry == 1)
  3419.             {
  3420.                 $output = '<p>Es sind leider keine Termine mehr Verf&uuml;gbar. <br>Bitte w&auml;hlen Sie einen anderen Termin.</p>';
  3421.             }
  3422.             else
  3423.             {
  3424.                 $output = '<p>Es sind leider keine Termine mehr Verf&uuml;gbar. <br>Bitte w&auml;hlen Sie einen anderen Termin.</p>';
  3425.             }
  3426.         }
  3428.         return new Response($output);
  3429.     }
  3431.     /**
  3432.     * @Route("/addToCart/{id}/{date}/{time}/{amount}/{addPerson}/{sibling}" , name="addToCart", options={"expose"=true})
  3433.     */
  3434.     public function addToCart($id, $date, $time, $amount, $addPerson , $sibling)
  3435.     {
  3436.         require_once("./include/function.php");
  3437.         
  3438.         $session = $this->requestStack->getSession(); //$session = $this->get('session');
  3439.        
  3440.         if(!$session->get('cartitems')){$session->set('cartitems', 0);}
  3441.         
  3442.         $cartitems = $session->get('cartitems');
  3444.         $i = $cartitems + 1;
  3445.         
  3446.         if($date == "" || $date == "undefined")
  3447.         {
  3448.             $repository = $this->getDoctrine()->getRepository(CourseTimes::class);
  3449.             $times = $repository->findOneBy(['id' => trim(checkUserInput($time))  ]);
  3450.             if($times)
  3451.             {
  3452.                 $date = $times->getCttDay()->format("d.m.Y");
  3453.             }
  3454.             else
  3455.             {
  3456.                 debugText("addtocart error ");
  3457.                 return $this->render('checkout/error.html.twig', [ ]);
  3458.             }
  3459.         }
  3461.         $session->set('cartitems', $i);
  3462.         $session->set('cartAddPerson'.$i, $addPerson);
  3464.         $session->set('cartTime'.$i, $time);
  3465.         $session->set('cartCourse'.$i, $id);
  3466.         $session->set('cartDate'.$i, $date);
  3467.         $session->set('cartItemMode'.$i, '1');
  3468.         $session->set('cartAmount'.$i, $amount);
  3469.         $session->set('cartSibling'.$i, $sibling);
  3470.         
  3471.         $placeid = $session->get('place');
  3473.         $user = $this->get('security.token_storage')->getToken()->getUser();
  3474.        
  3475.         $log = new Userlog();
  3476.         if($this->get('security.token_storage')->getToken()->getUser() == 'anon.'){
  3477.             $log->setUlUid(0);
  3478.         }
  3479.         else{
  3480.             $log->setUlUid( $user->getId());
  3481.         }
  3483.         $log->setUlSessionid($session->getId());
  3484.         $log->setUlBrowser($_SERVER['HTTP_USER_AGENT']);
  3485.         $log->setUlIp($_SERVER['REMOTE_ADDR']);
  3486.         
  3487.         $now = new \DateTime(date("Y-m-d H:i:s"));
  3488.         $log->setUlNow($now);
  3489.         if($placeid == NULL)
  3490.         {
  3491.             $log->setUlPlace(0);
  3492.         }
  3493.         else
  3494.         {
  3495.             $log->setUlPlace($placeid);
  3496.         }
  3497.         $log->setUlAction(5);
  3498.         $log->setUlReferer($_SERVER['HTTP_REFERER']);
  3499.         $log->setUlCurrentPage($_SERVER['REQUEST_URI']);
  3501.         $em = $this->getDoctrine()->getManager();
  3502.         $em->persist($log);
  3503.         $em->flush();
  3504.         
  3505.         return new Response("");
  3506.     }
  3507.     
  3508.     /**
  3509.      * @Route("/addToCart2/{id}/{amount}" , name="addToCart2", options={"expose"=true})
  3510.      */
  3511.     public function addToCart2($id, $amount )
  3512.     {
  3513.         require_once("./include/function.php");
  3514.         
  3515.         $session = $this->requestStack->getSession(); //$session = $this->get('session');
  3516.         
  3517.         if(!$session->get('cartitems')){$session->set('cartitems', 0);}
  3518.         
  3519.         $cartitems = $session->get('cartitems');
  3520.         
  3521.         $i = $cartitems + 1;
  3522.         
  3523.         $session->set('cartitems', $i);
  3524.         
  3525.         $session->set('cartAmount'.$i, $amount);
  3526.         $session->set('cartArticle'.$i, $id);
  3527.         $session->set('cartItemMode'.$i, '2');
  3528.         
  3529.         $placeid = $session->get('place');
  3530.         $user = $this->get('security.token_storage')->getToken()->getUser();
  3531.         $log = new Userlog();
  3532.         if($this->get('security.token_storage')->getToken()->getUser() == 'anon.'){
  3533.             $log->setUlUid(0);
  3534.         }
  3535.         else{
  3536.             $log->setUlUid( $user->getId());
  3537.         }
  3538.         $log->setUlSessionid($session->getId());
  3539.         $log->setUlBrowser($_SERVER['HTTP_USER_AGENT']);
  3540.         $log->setUlIp($_SERVER['REMOTE_ADDR']);
  3541.         
  3542.         $now = new \DateTime(date("Y-m-d H:i:s"));
  3543.         $log->setUlNow($now);
  3544.         if($placeid == NULL)
  3545.         {
  3546.             $log->setUlPlace(0);
  3547.         }
  3548.         else
  3549.         {
  3550.             $log->setUlPlace($placeid);
  3551.         }
  3552.         $log->setUlAction(5);
  3553.         $log->setUlReferer($_SERVER['HTTP_REFERER']);
  3554.         $log->setUlCurrentPage($_SERVER['REQUEST_URI']);
  3556.         $em = $this->getDoctrine()->getManager();
  3557.         $em->persist($log);
  3558.         $em->flush();
  3560.         
  3561.         return new Response("");
  3562.     }
  3564.     /**
  3565.     * @Route("/cart/" , name="cart")
  3566.     */
  3567.     public function cart()
  3568.     {
  3569.         require_once("./include/function.php");
  3570.         require_once("./include/global.php");
  3572.         $session = $this->requestStack->getSession(); //$session = $this->get('session');
  3574.         $end = $session->get('cartitems');
  3575.         
  3576.         $outputArr = array();
  3577.         $outputArr2 = array();
  3580.         $fullprice = 0;
  3581.         $fullpriceTax = 0;
  3582.         $taxArr = array();
  3583.         $adminFee = 0;
  3585.         if($this->get('security.token_storage')->getToken()->getUser() != 'anon.')
  3586.         {
  3588.             $uid = $this->get('security.token_storage')->getToken()->getUser();
  3589.             $role = $uid->getURole();
  3590.             $uid = $uid->getId();
  3591.             
  3592.             $em = $this->getDoctrine()->getManager();
  3594.             $repository = $this->getDoctrine()->getRepository(Cart::class);
  3595.             $cart = $repository->findBy(['ca_uid' => $uid ]);
  3596.         
  3597.             //first clear cart to prevent duplicates
  3598.             foreach($cart as $ca)
  3599.             {
  3600.                 if($ca && $ca != null && is_null($ca) == false )
  3601.                 {
  3602.                     $em->remove($ca);
  3603.                     $em->flush();
  3604.                 }
  3605.             }
  3606.             
  3607.         }
  3608.         else
  3609.         {
  3610.             $repository = $this->getDoctrine()->getRepository(Cart::class);
  3611.             $cart = $repository->findBy(['ca_session' => $session->getId() ]);
  3612.     
  3613.             $em = $this->getDoctrine()->getManager();
  3615.             //first clear cart to prevent duplicates
  3616.             foreach($cart as $ca)
  3617.             {
  3618.                 if($ca && $ca != null && is_null($ca) == false )
  3619.                 {
  3620.                     $em->remove($ca);
  3621.                     $em->flush();
  3622.                 }
  3623.             }
  3624.         }
  3626.         $xPerson = array();
  3628.         $anzPersons = 0;
  3629.         for($i = 1; $i <= $end; $i++ )
  3630.         {
  3631.             $anzPersons = $anzPersons + $session->get('cartAmount'.$i);
  3632.         }
  3633.         
  3634.         $showStudioDiscount = false;
  3635.         $showSiblingDiscount = false;
  3636.         $siblingDiscountGranted = false;
  3637.         $periodArr = array();
  3639.         //change session items order from expensive --> cheap
  3640.         $sTimesArr = array();
  3641.         $sAmountArr = array();
  3642.         $sCourseArr = array();
  3643.         $sPersonArr = array();
  3644.         $sDateArr = array();
  3645.         $sModeArr = array();
  3646.         $sSiblingArr = array();
  3647.         $sDatesArr = array();
  3649.         for($i = 1; $i <= $end; $i++ )
  3650.         {
  3651.             $sTimesArr[$i] = $session->get('cartTime'.$i);
  3652.             $sAmountArr[$i] = $session->get('cartAmount'.$i);
  3653.             $sCourseArr[$i] = $session->get('cartCourse'.$i);
  3654.             $sPersonArr[$i] = $session->get('cartAddPerson'.$i);
  3655.             $sDateArr[$i] = $session->get('cartDate'.$i);
  3656.             $sModeArr[$i] = $session->get('cartItemMode'.$i);
  3657.             $sSiblingArr[$i] = $session->get('cartSibling'.$i);
  3659.             //first get how many dates (Einheiten) the course has
  3660.             $courseId = $session->get('cartCourse'.$i);
  3661.             if($courseId == NULL){continue;}
  3662.             $date = $session->get('cartDate'.$i);
  3664.             $repository = $this->getDoctrine()->getRepository(CourseTimes::class);
  3665.             $courseTime = $repository->findOneBy(['id' => trim(checkUserInput($session->get("cartTime".$i))) ]);
  3667.             if(!$courseTime){continue;}
  3668.             $weekday = date("N",strtotime($courseTime->getCttDay()->format("Y-m-d")));
  3671.             $repository = $this->getDoctrine()->getRepository(CourseImages::class);
  3672.             $courseImage = $repository->findOneBy(['ci_cid' => trim(checkUserInput($courseId)) ]);
  3674.             $repository = $this->getDoctrine()->getRepository(Course::class);
  3675.             $course = $repository->findOneBy(['id' => trim(checkUserInput($courseId)) ]);
  3677.             $repository = $this->getDoctrine()->getRepository(CourseAdditionalTimes::class);
  3678.             $courseAddTime = $repository->findOneBy(['cat_number' => $courseTime->getCttNumber()]);
  3679.             $bookingOption = $courseAddTime->getCatBookingOption();
  3683.             $nd1 = $courseTime->getCttFrom();
  3684.             $nd1 = $nd1->format('H:i'); 
  3686.             $nd2 = $courseTime->getCttTo();
  3687.             $nd2 = $nd2->format('H:i'); 
  3689.             if($course->getCAppointmentSeries() == 1)
  3690.             {
  3691.                 $t1 = $courseTime->getCttDay();
  3692.                 $t1 = $t1->format('Y-m-d'); 
  3693.                 
  3694.                 $t2 = $courseTime->getCttFrom();
  3695.                 $t2 = $t2->format('H:i:s'); 
  3696.                 
  3697.                 $query = "SELECT id, ctt_day, ctt_cid FROM course_times WHERE ctt_cid = :cid AND ctt_active = 1  AND ctt_from = :from AND ctt_day >= :day AND ctt_number = :number  ORDER BY ctt_day ASC ";
  3698.                 $em2 = $this->getDoctrine()->getManager();   
  3699.                 
  3700.                 $resultSet = $em2->getConnection()->executeQuery($query,['cid' => $course->getId(), 'from' => $t2 , "day" => $t1, "number" => $courseTime->getCttNumber()]);
  3701.                 
  3702.                 $dates = 0;
  3703.                 //write new entries
  3704.                 foreach($resultSet as $res) 
  3705.                 {
  3706.                     
  3707.                     if($bookingOption == 1)
  3708.                     {
  3709.                         //check if same weekdays
  3710.                         $tmp = date("N",strtotime($res['ctt_day']));
  3711.                         if($tmp != $weekday ){ continue; }
  3712.                     }
  3713.                     
  3714.                     $checkCart = true;
  3715.                     if($this->get('security.token_storage')->getToken()->getUser() != 'anon.')
  3716.                     {
  3717.                         $uid2 = $this->get('security.token_storage')->getToken()->getUser();
  3718.                         $role2 = $uid2->getURole();
  3719.                         if($role2 == '3' || $role2 == '4' || $role2 == '5')
  3720.                         {
  3721.                             $checkCart = false;
  3722.                         }
  3723.                     }
  3724.                     
  3725.                     //check if coursetime still available
  3726.                     $alreadyUsed = 0;
  3727.                     $maxCustomer = 0;
  3729.                     $repository = $this->getDoctrine()->getRepository(CourseTimes::class);
  3730.                     $time = $repository->findOneBy(['id' => $res['id']]);
  3732.                     $maxCustomer = $time->getCttMaxonline();
  3733.                     if($this->get('security.token_storage')->getToken()->getUser() == 'anon.')
  3734.                     {
  3735.                         //Guest
  3736.                     }
  3737.                     else
  3738.                     {
  3740.                         $uid2 = $this->get('security.token_storage')->getToken()->getUser();
  3741.                         $role = $uid2->getURole();
  3743.                         if($role == 1 || $role == 2)
  3744.                         {
  3745.                             //Customer
  3746.                         }
  3747.                         else 
  3748.                         {
  3749.                             //employee
  3750.                             $maxCustomer = $maxCustomer + $time->getCttMaxoffline();
  3751.                         }
  3752.                     }
  3753.                     
  3754.                     $dates++;
  3755.                     if($dates >= 1 && $bookingOption == 0){ break; }
  3756.                 }
  3757.             }
  3758.             else
  3759.             {
  3760.                 $dates = 1;
  3761.             }
  3763.             $sDatesArr[$i] = $dates;
  3764.         }
  3766.         $sPriceArr = array();
  3767.         foreach($sCourseArr as $k => $v)
  3768.         {
  3769.            
  3770.             $repository = $this->getDoctrine()->getRepository(Course::class);
  3771.             $course = $repository->findOneBy(['id' => trim(checkUserInput($v)) ]);
  3772.             $dates = $sDatesArr[$k]; 
  3773.             $sPriceArr[$k] = ($course->getCPrice() * $dates);
  3774.         }
  3776.         arsort($sPriceArr);
  3778.         $i = 1;
  3779.         foreach($sPriceArr as $k => $v)
  3780.         {
  3781.         
  3782.             $session->set('cartItemDates'.$i, $sDatesArr[$k]);
  3783.             $session->set('cartAddPerson'.$i, $sPersonArr[$k]);
  3784.             $session->set('cartAmount'.$i, $sAmountArr[$k]);
  3785.             $session->set('cartCourse'.$i, $sCourseArr[$k]);
  3786.             $session->set('cartDate'.$i, $sDateArr[$k]);
  3787.             $session->set('cartItemMode'.$i, $sModeArr[$k]);
  3788.             $session->set('cartSibling'.$i, $sSiblingArr[$k]);
  3789.             $session->set('cartTime'.$i, $sTimesArr[$k]);
  3790.             $i++;
  3792.             /*
  3793.                 $sTimesArr = array();
  3794.                 $sAmountArr = array();
  3795.                 $sCourseArr = array();
  3796.                 $sPersonArr = array();
  3797.                 $sDateArr = array();
  3798.                 $sModeArr = array();
  3799.                 $sSiblingArr = array();
  3800.                 $sDatesArr = array();
  3801.             */
  3803.         }
  3805.         
  3806.         // start with all cart items
  3807.         for($i = 1; $i <= $end; $i++ )
  3808.         {
  3809.             if($session->get('cartItemMode'.$i) == '1')
  3810.             {
  3811.                 $dates = $session->get('cartItemDates'.$i);
  3812.                 $courseId = $session->get('cartCourse'.$i);
  3813.                 if($courseId == NULL){continue;} 
  3814.                 $date = $session->get('cartDate'.$i);
  3815.                 
  3816.                 $repository = $this->getDoctrine()->getRepository(CourseTimes::class);
  3817.                 $courseTime = $repository->findOneBy(['id' => trim(checkUserInput($session->get("cartTime".$i))) ]);
  3818.                 if(!$courseTime){continue;}
  3819.                 $weekday = date("N",strtotime($courseTime->getCttDay()->format("Y-m-d")));
  3820.                 
  3821.                 $repository = $this->getDoctrine()->getRepository(CourseAdditionalTimes::class);
  3822.                 $courseAddTime = $repository->findOneBy(['cat_number' => $courseTime->getCttNumber(), 'cat_cid' => $courseTime->getCttCid()]);
  3823.                 if(!$courseAddTime){continue;}
  3824.                 $bookingOption = $courseAddTime->getCatBookingOption();
  3825.                 
  3826.                 $repository = $this->getDoctrine()->getRepository(CourseImages::class);
  3827.                 $courseImage = $repository->findOneBy(['ci_cid' => trim(checkUserInput($courseId)) ]);
  3828.                 
  3829.                 $repository = $this->getDoctrine()->getRepository(Course::class);
  3830.                 $course = $repository->findOneBy(['id' => trim(checkUserInput($courseId)) ]);
  3831.                 
  3832.                 $period = $course->getCPeriod();
  3833.                 $amount = 0;
  3834.                 $amount = $session->get('cartAmount'.$i);
  3835.                 
  3836.                 $siblingDiscountGranted = false;
  3837.                 for($j = 1; $j <= $amount; $j++)
  3838.                 {
  3840.                     $first = "";
  3841.                     $last = "";
  3842.                     $person = "";
  3843.                     //go through all Persons 
  3844.                     // amount  == persons
  3845.                     
  3846.                         $x = 1;
  3847.                         $tmpperson = $session->get('cartAddPerson'.$i); 
  3848.                         $tmpperson = explode("***",$tmpperson);
  3849.                         foreach($tmpperson as $tmppers)
  3850.                         {
  3851.                             if($x == $j)
  3852.                             {
  3853.                                 $person2 = explode(";;;",$tmppers);
  3854.                                 $z = 0;
  3855.                                 foreach($person2 as $p)
  3856.                                 {
  3857.                                     if($z == 0){ $person = $p. ' '; }
  3858.                                     if($z == 1){ $person .= $p; }
  3859.                                     if($z == 2){ continue; }
  3861.                                     $z++;
  3862.                                 }
  3863.                                 
  3864.                             }
  3865.                             $x++;
  3866.                         }
  3867.                     
  3868.                     if(!array_key_exists($person,$xPerson)){ $xPerson[$person] = 0; }
  3870.                     $outdays = ""; 
  3871.                     $seriesCounter = 0;
  3872.                     if($company == "KVO")
  3873.                     {
  3874.                         if($course->getCAppointmentSeries() == '1')
  3875.                         {
  3876.                             
  3877.                             $t1 = $courseTime->getCttDay();
  3878.                             $t1 = $t1->format('Y-m-d'); 
  3879.                             
  3880.                             $t2 = $courseTime->getCttFrom();
  3881.                             $t2 = $t2->format('H:i:s'); 
  3882.                                 
  3883.                             $query = "SELECT * FROM course_times WHERE ctt_cid = :cid AND ctt_active = 1  AND ctt_from = :from AND ctt_day >= :day  ORDER BY ctt_day ASC LIMIT " . $course->getCAppointmentSeriesDays();
  3884.                             $em2 = $this->getDoctrine()->getManager();   
  3885.                             
  3886.                             $resultSet = $em2->getConnection()->executeQuery($query,['cid' => $course->getId(), 'from' => $t2 , "day" => $t1]);
  3887.                             foreach($resultSet as $res) 
  3888.                             {
  3889.                                 //here remove from series if neccessary
  3890.                                 $outdays .=  date("d.m.Y",strtotime( $res['ctt_day'])) . "<br />";
  3891.                                 $seriesCounter++;
  3892.                             }
  3893.                             
  3894.                         }
  3895.                         else
  3896.                         {
  3897.                             $seriesCounter = 1;
  3898.                         }
  3899.                     }
  3900.                     else
  3901.                     {
  3902.                     
  3903.                         
  3904.                         $t1 = $courseTime->getCttDay();
  3905.                         $t1 = $t1->format('Y-m-d'); 
  3906.                         
  3907.                         $t2 = $courseTime->getCttFrom();
  3908.                         $t2 = $t2->format('H:i:s'); 
  3909.                         
  3910.                         $query = "SELECT * FROM course_times WHERE ctt_cid = :cid AND ctt_active = 1  AND ctt_from = :from AND ctt_day >= :day AND ctt_number = :number  ORDER BY ctt_day ASC ";
  3911.                         $em2 = $this->getDoctrine()->getManager();   
  3912.                         
  3913.                         $resultSet = $em2->getConnection()->executeQuery($query,['cid' => $course->getId(), 'from' => $t2 , "day" => $t1, "number" => $courseTime->getCttNumber()]);
  3914.                         $dates = 0;
  3915.                         foreach($resultSet as $res) 
  3916.                         {
  3917.                             
  3918.                             if($bookingOption == 1)
  3919.                             {
  3920.                                 //check if same weekdays
  3921.                                 $tmp = date("N",strtotime($res['ctt_day']));
  3922.                                 if($tmp != $weekday ){ continue; }
  3923.                             }
  3924.                             //here remove from series if neccessary
  3925.                             $outdays .=  date("d.m.Y",strtotime( $res['ctt_day'])) . "<br />";
  3926.                             $seriesCounter++;
  3927.                             $dates++;
  3928.                             if($dates >= 1 && $bookingOption == 0){ break; }
  3929.                         }
  3930.                         
  3931.                     }   
  3932.                     
  3933.                     //discount
  3934.                     if($course->getCSiblingDiscount() == '1' && $session->get("cartSibling".$i) == '1'  )
  3935.                     {
  3936.                         $discount = $siblingDiscountGlob;
  3937.         
  3938.                     }
  3939.                     else
  3940.                     {
  3941.                         //debugText("test");
  3942.                         $discount = $course->getCDiscount();
  3943.                         $price = ($course->getCPrice() * $dates);
  3944.                         if($discount != 0)
  3945.                         {
  3946.                             //check if other prices higher / lower
  3947.                             $x = 0;
  3948.                             $ord = false; 
  3949.                             // if logged in check earlier orders first
  3950.                             if($this->get('security.token_storage')->getToken()->getUser() != 'anon.')
  3951.                             {
  3952.                     
  3953.                                 $curId = "0";
  3954.                                 $curItem = "0";
  3955.                                 $usr = $this->get('security.token_storage')->getToken()->getUser();
  3956.                                 //if($usr == '28'){$usr = 60;}
  3957.                                 //debugText($usr);
  3958.                                 $repository = $this->getDoctrine()->getRepository(Orders::class);
  3959.                                 $orders = $repository->findBy(['o_uid' =>  $usr->getId()]);
  3960.                                 
  3961.                                 foreach($orders as $order)
  3962.                                 {
  3963.                                     if($order->getONow()->format("Y-m-d") < date("Y-01-01")  ){ continue; }
  3964.                                     $repository = $this->getDoctrine()->getRepository(OrderItems::class);
  3965.                                     $orderItems = $repository->findBy(['oi_oid' =>  $order->getId()]);
  3966.                 
  3967.                                     foreach($orderItems as $orderItem)
  3968.                                     {
  3969.                                         if($orderItem->getOiCid() == 0){continue;}
  3970.                                         
  3971.                                         if($curId == $order->getId() && $orderItem->getOiItem() == $curItem)
  3972.                                         {
  3973.                                             continue;
  3974.                                         }
  3975.                                         $personFound = false;
  3976.                                         $repository = $this->getDoctrine()->getRepository(CourseAddPerson::class);
  3977.                                         $courseAddPerson = $repository->findBy(['cap_oid' => $orderItem->getId()]);
  3978.                                         foreach($courseAddPerson as $cap)
  3979.                                         {
  3980.                                             if( ($cap->getCapFirstname() .' '.$cap->getCapLastname()) == $person)
  3981.                                             {
  3982.                                                 
  3983.                                                 $personFound = true;
  3984.                                             }
  3985.                                         }
  3987.                                         if($personFound == false){continue;}
  3988.                                         if($orderItem->getOiCid() == '0'){ continue; }
  3989.                                         if($orderItem->getOiPeriod() != $period){ continue; }
  3990.                                         $repository = $this->getDoctrine()->getRepository(Course::class);
  3991.                                         $c = $repository->findOneBy(['id' =>  $orderItem->getOiCid()]);
  3992.                                         if(!$c){continue;}
  3993.                                         
  3994.                                         if($c->getCDiscount() == '0'){continue;}
  3995.                                         //$testtime = $c->getCActiveFrom()->format("Y");
  3996.                                         
  3997.                                         $repository = $this->getDoctrine()->getRepository(CourseTimes::class);
  3998.                                         $c2 = $repository->findBy(['ctt_cid' =>  $orderItem->getOiCid()], ['ctt_day' => 'asc']);
  3999.                                         foreach($c2 as $cc2)
  4000.                                         {
  4001.                                             $testtime = $cc2->getCttDay()->format("Y");
  4002.                                             break;
  4003.                                         }
  4004.                                         //debugText($order->getOUid().': '.$testtime);
  4005.                                         if($testtime != date('Y')){continue;}
  4006.                                          
  4007.                                         if(!array_key_exists($c->getCPeriod(),$periodArr))
  4008.                                         {
  4009.                                             $periodArr[$c->getCPeriod()] = 0; 
  4010.                                         }
  4011.                                         $periodArr[$c->getCPeriod()] = $periodArr[$c->getCPeriod()] + 1;
  4012.                                             
  4013.                                         if($orderItem->getOiPrice() >= $price)
  4014.                                         { 
  4015.                                             
  4016.                                             $x++; 
  4017.                                         }
  4018.                                         $ord = true;
  4019.                                        
  4020.                                         $curId = $order->getId();
  4021.                                         $curItem = $orderItem->getOiItem();
  4022.                                     }
  4023.                                 }
  4024.                             }
  4025.                             
  4026.                             // then check cart
  4027.                             $end2 = $session->get('cartitems');
  4028.                             for($i2 = 1; $i2 <= $end2; $i2++ )
  4029.                             {
  4030.                                 
  4031.                                 $mode2 = $session->get('cartItemMode'.$i);
  4032.                                 if($mode2 == '1') 
  4033.                                 {
  4034.                                     //course
  4035.                                     $repository = $this->getDoctrine()->getRepository(Course::class);
  4036.                                     $tmp = $repository->findOneBy(['id' => $session->get('cartCourse'.$i)]);
  4037.                                     $price2 = ($tmp->GetCPrice() * $dates);
  4038.                                     if(!array_key_exists($tmp->getCPeriod(),$periodArr))
  4039.                                     {
  4040.                                         $periodArr[$tmp->getCPeriod()] = 0; 
  4041.                                     }
  4042.                                     $periodArr[$tmp->getCPeriod()] = $periodArr[$tmp->getCPeriod()] + 1;
  4043.                                     if($tmp->getCDiscount() == '0'){continue;}
  4045.                                 }
  4046.                                 else
  4047.                                 {
  4048.                                     continue;
  4049.                                 }
  4050.                                 
  4051.                                 if($price <= $price2)
  4052.                                 {
  4053.                                     if($ord != true)
  4054.                                     {
  4055.                                         if($x >= $i ){ continue;}
  4057.                                     }
  4058.                                     else
  4059.                                     {
  4060.                                         if($i2 > $i ){ continue;}
  4061.                                     }                                
  4062.                                     $x++; break;
  4063.                                 }
  4064.                             }   
  4065.                             
  4066.                             $xPerson[$person] = $xPerson[$person] + $x;
  4067.                             
  4068.                             // x == amount of orders with higher price
  4069.                             $repository = $this->getDoctrine()->getRepository(Costplace::class);
  4070.                             $tmp = $repository->findOneBy(['id' => $course->getCCostplace()]);
  4071.                             $place = $tmp->getCpPlace();
  4072.                             
  4073.                             $y = 0;
  4074.                             $discountArr = array();
  4075.                             $repository = $this->getDoctrine()->getRepository(Discount::class);
  4076.                             $discount = $repository->findBy(['d_place' => $place],['d_amount' => 'ASC']);
  4077.                             foreach($discount as $d)
  4078.                             {
  4079.                                 $discountArr[$y] = $d->getDAmount();
  4080.                                 $y++;
  4081.                             }
  4082.                             
  4083.                             if($periodArr[$course->getCPeriod()] > 1)
  4084.                             {
  4085.                                 if($xPerson[$person] == 2) // lowest discount
  4086.                                 {
  4087.                                     $discount = $discountArr[0];
  4088.                                 } 
  4089.                                 else if($xPerson[$person] == 3) // middle discount
  4090.                                 {
  4091.                                     $discount = $discountArr[1];
  4092.                                 }
  4093.                                 else if($xPerson[$person] >= 4) // highest discount
  4094.                                 {
  4095.                                     $discount = $discountArr[2];
  4096.                                 }
  4097.                                 else // no discount
  4098.                                 {
  4099.                                     $discount = 0;
  4100.                                 }
  4101.                             }
  4102.                             else
  4103.                             {
  4104.                                 
  4105.                                 $discount = 0;
  4106.                             }
  4107.                         }
  4108.                     }
  4109.                     
  4110.                     // check sibling Discount here 
  4111.                     if($course->getCSiblingDiscount() == '1' && $anzPersons >= 2)
  4112.                     {
  4113.                         $showSiblingDiscount = true;
  4114.                     }
  4117.                     if($course->getCSiblingDiscount() == '1' && $anzPersons >= 2 && $session->get('siblingDiscount') == '1' && $siblingDiscountGranted == false)
  4118.                     {
  4119.                         $discount = $siblingDiscountGlob;
  4120.                         $siblingDiscountGranted = true;
  4121.                     }
  4123.                     // check studio discount
  4124.                     if($course->getCStudioDiscount() == '1')
  4125.                     {
  4126.                         $showStudioDiscount = true;
  4127.                     }
  4128.                     if($course->getCStudioDiscount() == '1' && $session->get('studioDiscount') == '1')
  4129.                     {
  4130.                         $discount = $studioDiscountGlob;
  4131.                     }
  4134.                     //$fullprice = $fullprice + ( (($course->getCPrice() * $amount) * $seriesCounter) * (1 - ($discount / 100))   ) + $course->getCAdminFee();
  4135.                     $fullprice = $fullprice + ( (($course->getCPrice() *  $seriesCounter)+ $course->getCAdminFee())  * (1 - ($discount / 100))   ) ;
  4137.                     if(empty($taxArr[$course->getCTax()])){ $taxArr[$course->getCTax()] = 0;}
  4138.                     //$taxArr[$course->getCTax()] = $taxArr[$course->getCTax()] + (   ((   (number_format($course->getCPrice() * $amount,2,'.',',') * (($course->getCTax()/100))  ) * $seriesCounter) * ( 1 - ($discount / 100)) )  + number_format( ($course->getCAdminFee() * (($course->getCTax()/100)) ),2,'.',',') ); 
  4139.                     $taxArr[$course->getCTax()] = $taxArr[$course->getCTax()] + (   ((number_format($course->getCPrice(),2,'.',',') * (($course->getCTax()/100))  * $seriesCounter  )  * ( 1 - ($discount / 100)) )  + number_format( ($course->getCAdminFee() * (($course->getCTax()/100)) ),2,'.',',') ); 
  4142.                     if($person != "")
  4143.                     {
  4144.                         
  4145.                         $outputArr2[$person][$i]['course'] = $course->getCName();
  4146.                         $outputArr2[$person][$i]['coursePrice'] = ( ((  $course->getCPrice() * $seriesCounter) + $course->getCAdminFee()) * ( 1 - ($discount / 100)) ) ;
  4147.                         $outputArr2[$person][$i]['courseTax'] = $course->getCTax();
  4148.                         $outputArr2[$person][$i]['itemMode'] = '1';
  4149.                         $outputArr2[$person][$i]['discount'] = $discount;
  4150.                        
  4151.                         $outputArr2[$person][$i]['i'] = $i;
  4152.                         
  4153.                     }
  4154.                         
  4155.                     $outputArr[$i]['course'] = $course->getCName();
  4156.                     $outputArr[$i]['coursePrice'] = number_format( (  (($course->getCPrice() * $seriesCounter) + $course->getCAdminFee()) * ( 1 - ($discount / 100)) ) ,2,',','.'). " €";
  4157.                     $outputArr[$i]['courseTax'] = number_format($course->getCTax(),2,',','.'). " %";
  4158.                     $outputArr[$i]['itemMode'] = "1";
  4159.                     $outputArr[$i]['courseAmount'] = $session->get('cartAmount'.$i);
  4160.                     $adminFee  = $adminFee + $course->getCAdminFee();
  4161.                     $nd1 = $courseTime->getCttFrom();
  4162.                     $nd1 = $nd1->format('H:i'); 
  4164.                     $nd2 = $courseTime->getCttTo();
  4165.                     $nd2 = $nd2->format('H:i'); 
  4167.                     $outputArr[$i]['time'] = $nd1 . " - " . $nd2;
  4168.                     if($person != "")
  4169.                     {
  4170.                         $outputArr2[$person][$i]['time'] = $nd1 . " - " . $nd2;
  4171.                     }
  4172.                     $outputArr[$i]['image'] = $courseImage->getCiPath();
  4173.                     if($outdays != "")
  4174.                     {
  4175.                         $outputArr[$i]['date'] = $outdays;
  4176.                         if($person != "")
  4177.                         {
  4178.                             $outputArr2[$person][$i]['date'] = $outdays;
  4179.                         }
  4180.                     }
  4181.                     else
  4182.                     {
  4183.                         $outputArr[$i]['date'] = $date;
  4184.                         if($person != "")
  4185.                         {
  4186.                             $outputArr2[$person][$i]['date'] = $date;
  4187.                         }
  4188.                     }
  4190.                     // end mode 1
  4191.                 }
  4192.             }
  4193.             else if($session->get('cartItemMode'.$i) == '2')
  4194.             {
  4195.                 $articleId = $session->get('cartArticle'.$i);
  4197.                 $repository = $this->getDoctrine()->getRepository(Article::class);
  4198.                 $article = $repository->findOneBy(['id' => trim(checkUserInput($articleId)) ]);
  4200.                 $repository = $this->getDoctrine()->getRepository(ArticleImages::class);
  4201.                 $articleImage = $repository->findOneBy(['ai_aid' => trim(checkUserInput($articleId)) ]);
  4202.                 
  4203.                 $discount = $article->getADiscount();
  4204.                 if($discount != 0)
  4205.                 {
  4207.                    $repository = $this->getDoctrine()->getRepository(Discount::class);
  4208.                    $discount = $repository->findOneBy(['id' => $discount ]);  
  4209.                    
  4210.                    $discount = $discount->getDAmount();
  4211.                 }
  4214.                 $outputArr[$i]['article'] = $article->getAName();
  4215.                 $outputArr[$i]['articlePrice'] = number_format(($article->getAPrice() * ( 1 - ($discount / 100))),2,',','.'). " €";
  4216.                 $outputArr[$i]['articleTax'] = number_format($article->getATax(),2,',','.'). " %";
  4217.                 $outputArr[$i]['itemMode'] = "2";
  4218.                 $outputArr[$i]['articleAmount'] = $session->get('cartAmount'.$i);
  4219.                 
  4220.                 $outputArr[$i]['image'] = $articleImage->getAiPath();
  4222.                 if($company != 'KVO')
  4223.                 {
  4224.                     $first = $this->get('security.token_storage')->getToken()->getUser()->getUFirstname();
  4225.                     $last = $this->get('security.token_storage')->getToken()->getUser()->getULastname();
  4226.                     $person = $first . " " . $last;
  4227.                     $outputArr2[$i][$person]['article'] = $article->getAName();
  4228.                     $outputArr2[$i][$person]['articlePrice'] = number_format(($article->getAPrice() * ( 1 - ($discount / 100))),2,',','.'). " €";
  4229.                     $outputArr2[$i][$person]['articleTax'] = number_format($article->getATax(),2,',','.'). " %";
  4230.                     $outputArr2[$i][$person]['itemMode'] = "2";
  4231.                     $outputArr2[$i][$person]['articleAmount'] = $session->get('cartAmount'.$i);
  4232.                 }
  4233.                 
  4237.                 $amount = 0;
  4238.                 $amount = $session->get('cartAmount'.$i);
  4240.                 $fullprice = $fullprice + ( ($article->getAPrice() * $amount)  * ( 1 - ($discount / 100)) );
  4241.                 if(empty($taxArr[$article->getATax()])){ $taxArr[$article->getATax()] = 0;}
  4242.                 $taxArr[$article->getATax()] = $taxArr[$article->getATax()] + ( number_format( (($article->getAPrice() * $amount)  * ( 1 - ($discount / 100))),2,'.',',') * (($article->getATax()/100))  ); 
  4244.             }
  4245.             $outputArr[$i]['i'] = $i;
  4246.             
  4247.         }
  4249.         
  4250.         $fullpriceTax = $fullprice;
  4251.         foreach($taxArr as $k => $v)
  4252.         {
  4253.             $fullpriceTax = $fullpriceTax - $v;
  4254.             $taxArr[$k] = number_format($v,2,',','.') . " €";
  4255.         }
  4256.         
  4257.         
  4258.         $anonBuy = 0;
  4259.         if($this->get('security.token_storage')->getToken()->getUser() == 'anon.')
  4260.         {
  4261.             $anonBuy = 1;
  4262.         }
  4263.         
  4264.         
  4265.         /* add to cart database table // begin */ 
  4266.         if($this->get('security.token_storage')->getToken()->getUser() != 'anon.')
  4267.         {
  4268.             $uid = $this->get('security.token_storage')->getToken()->getUser();
  4269.             $role = $uid->getURole();
  4270.             $uid = $uid->getId();
  4271.             
  4272.         }
  4273.         else
  4274.         {
  4275.             $uid = 0;
  4276.         }
  4277.                 
  4278.         $session = $this->requestStack->getSession(); //$session = $this->get('session');
  4279.         $end = $session->get('cartitems');
  4280.         
  4281.         for($i = 1; $i <= $end; $i++ )
  4282.         {
  4283.             if($session->get('cartItemMode'.$i) == '1')
  4284.             {
  4285.                 $courseId = $session->get('cartCourse'.$i);
  4286.                 if($courseId == NULL){continue;}
  4287.                 $date = $session->get('cartDate'.$i);
  4288.     
  4289.                 $repository = $this->getDoctrine()->getRepository(CourseTimes::class);
  4290.                 $courseTime = $repository->findOneBy(['id' => trim(checkUserInput($session->get("cartTime".$i))) ]);
  4291.                 
  4292.                 if(!$courseTime){continue;}
  4293.                 $weekday = date("N",strtotime($courseTime->getCttDay()->format("Y-m-d")));
  4294.                 
  4296.                 $repository = $this->getDoctrine()->getRepository(CourseImages::class);
  4297.                 $courseImage = $repository->findOneBy(['ci_cid' => trim(checkUserInput($courseId)) ]);
  4298.                 
  4299.                 $repository = $this->getDoctrine()->getRepository(Course::class);
  4300.                 $course = $repository->findOneBy(['id' => trim(checkUserInput($courseId)) ]);
  4301.                 
  4302.                 $repository = $this->getDoctrine()->getRepository(CourseAdditionalTimes::class);
  4303.                 $courseAddTime = $repository->findOneBy(['cat_number' => $courseTime->getCttNumber()]);
  4304.                 $bookingOption = $courseAddTime->getCatBookingOption();
  4306.                 $amount = 0;
  4307.                 $amount = $session->get('cartAmount'.$i);
  4308.                 
  4309.     
  4310.                 $nd1 = $courseTime->getCttFrom();
  4311.                 $nd1 = $nd1->format('H:i'); 
  4312.     
  4313.                 $nd2 = $courseTime->getCttTo();
  4314.                 $nd2 = $nd2->format('H:i'); 
  4315.                 
  4316.                 if($course->getCAppointmentSeries() == 1)
  4317.                 {
  4318.                     $t1 = $courseTime->getCttDay();
  4319.                     $t1 = $t1->format('Y-m-d'); 
  4321.                     $t2 = $courseTime->getCttFrom();
  4322.                     $t2 = $t2->format('H:i:s'); 
  4323.                     
  4324.                     $query = "SELECT id, ctt_day, ctt_cid FROM course_times WHERE ctt_cid = :cid AND ctt_active = 1  AND ctt_from = :from AND ctt_day >= :day AND ctt_number = :number  ORDER BY ctt_day ASC ";
  4325.                     $em2 = $this->getDoctrine()->getManager();   
  4326.                     
  4327.                     $resultSet = $em2->getConnection()->executeQuery($query,['cid' => $course->getId(), 'from' => $t2 , "day" => $t1, "number" => $courseTime->getCttNumber()]);
  4328.                     
  4329.                     $dates = 0;
  4330.                     //write new entries
  4331.                     foreach($resultSet as $res) 
  4332.                     {
  4333.                         
  4334.                         if($bookingOption == 1)
  4335.                         {
  4336.                             //check if same weekdays
  4337.                             $tmp = date("N",strtotime($res['ctt_day']));
  4338.                             if($tmp != $weekday ){ continue; }
  4339.                         }
  4340.                         
  4341.                         $checkCart = true;
  4342.                         if($this->get('security.token_storage')->getToken()->getUser() != 'anon.')
  4343.                         {
  4344.                             $uid2 = $this->get('security.token_storage')->getToken()->getUser();
  4345.                             $role2 = $uid2->getURole();
  4346.                             if($role2 == '3' || $role2 == '4' || $role2 == '5')
  4347.                             {
  4348.                                 $checkCart = false;
  4349.                             }
  4350.                         }
  4351.                         if($checkCart == true)
  4352.                         {
  4353.                             $cart = new Cart();
  4354.                             $cart->setCaUid($uid);
  4355.                             $cart->setCaCid($course->getId());
  4356.                             $cart->setCaTid($res['id']);
  4357.                             $cart->setCaAmount($session->get('cartAmount'.$i));
  4358.                             $now = new \DateTime(date("Y-m-d H:i:s"));
  4359.                             $cart->setCaNow($now);
  4360.                             $cart->setCaSession($session->getId());
  4361.                             
  4362.                             $em = $this->getDoctrine()->getManager();
  4363.                     
  4364.                             $em->persist($cart);
  4365.                             $em->flush();
  4366.                         }
  4367.                         //check if coursetime still available
  4368.                         $alreadyUsed = 0;
  4369.                         $maxCustomer = 0;
  4370.         
  4371.                         $repository = $this->getDoctrine()->getRepository(CourseTimes::class);
  4372.                         $time = $repository->findOneBy(['id' => $res['id']]);
  4373.                 
  4374.                         $maxCustomer = $time->getCttMaxonline();
  4375.                         if($this->get('security.token_storage')->getToken()->getUser() == 'anon.')
  4376.                         {
  4377.                             //Guest
  4378.                         }
  4379.                         else
  4380.                         {
  4381.             
  4382.                             $uid2 = $this->get('security.token_storage')->getToken()->getUser();
  4383.                             $role = $uid2->getURole();
  4384.             
  4385.                             if($role == 1 || $role == 2)
  4386.                             {
  4387.                                 //Customer
  4388.                             }
  4389.                             else 
  4390.                             {
  4391.                                 //employee
  4392.                                 $maxCustomer = $maxCustomer + $time->getCttMaxoffline();
  4393.                             }
  4394.                         }
  4395.                         
  4396.                         $dates++;
  4397.                         if($dates >= 1 && $bookingOption == 0){ break; }
  4398.                     }
  4399.                 }
  4400.                 else
  4401.                 {
  4402.                     $checkCart = true;
  4403.                     if($this->get('security.token_storage')->getToken()->getUser() != 'anon.')
  4404.                     {
  4405.                         $uid2 = $this->get('security.token_storage')->getToken()->getUser();
  4406.                         $role2 = $uid2->getURole();
  4407.                         if($role2 == '3' || $role2 == '4' || $role2 == '5')
  4408.                         {
  4409.                             $checkCart = false;
  4410.                         }
  4411.                     }
  4412.                     if($checkCart == true)
  4413.                     {
  4414.                         $cart = new Cart();
  4415.                         $cart->setCaUid($uid);
  4416.                         $cart->setCaCid($course->getId());
  4417.                         $cart->setCaTid($session->get("cartTime".$i));
  4418.                         $cart->setCaAmount($session->get('cartAmount'.$i));
  4419.                         $now = new \DateTime(date("Y-m-d H:i:s"));
  4420.                         $cart->setCaNow($now);
  4421.                         $cart->setCaSession($session->getId());
  4423.                         $em->persist($cart);
  4424.                         $em->flush();
  4425.                     }
  4426.                     //check if coursetime still available
  4427.                     $alreadyUsed = 0;
  4428.                     $maxCustomer = 0;
  4429.     
  4430.                     $repository = $this->getDoctrine()->getRepository(CourseTimes::class);
  4431.                     $time = $repository->findOneBy(['id' => $res['id']]);
  4432.                 
  4433.                     $maxCustomer = $time->getCttMaxonline();
  4434.                     if($this->get('security.token_storage')->getToken()->getUser() == 'anon.')
  4435.                     {
  4436.                         //Guest
  4437.                     }
  4438.                     else
  4439.                     {
  4440.         
  4441.                         $uid2 = $this->get('security.token_storage')->getToken()->getUser();
  4442.                         $role = $uid2->getURole();
  4443.         
  4444.                         if($role == 1 || $role == 2)
  4445.                         {
  4446.                             //Customer
  4447.                         }
  4448.                         else 
  4449.                         {
  4450.                             //employee
  4451.                             $maxCustomer = $maxCustomer + $time->getCttMaxoffline();
  4452.                         }
  4453.                     }
  4455.                     
  4456.                 }
  4457.             }
  4458.         }
  4459.         
  4460.         /* add to cart database table // end */ 
  4463.         //check if course was already bought. send warning if so.
  4464.         $warning = "";
  4465.         $warningCount = 0;
  4466.         $z = 0;
  4467.         if($this->get('security.token_storage')->getToken()->getUser() != 'anon.')
  4468.         {
  4469.             $uid2 = $this->get('security.token_storage')->getToken()->getUser();
  4470.             $role = $uid2->getURole();
  4471.             $uid = $uid2->getId();
  4473.             if($role == 1 || $role == 2)
  4474.             {
  4475.                 $end = $session->get('cartitems');
  4476.                 for($i = 1; $i <= $end; $i++ )
  4477.                 {
  4478.                     if($session->get('cartItemMode'.$i) == '1')
  4479.                     {
  4480.                         
  4481.                         
  4482.                         $courseId = $session->get('cartCourse'.$i);
  4483.                         if($courseId == NULL){continue;} 
  4484.                         $date = $session->get('cartDate'.$i);
  4485.                         
  4486.                         $repository = $this->getDoctrine()->getRepository(CourseTimes::class);
  4487.                         $courseTime = $repository->findOneBy(['id' => trim(checkUserInput($session->get("cartTime".$i))) ]);
  4488.                         $weekday = date("N",strtotime($courseTime->getCttDay()->format("Y-m-d")));
  4489.                         
  4490.                         $repository = $this->getDoctrine()->getRepository(CourseAdditionalTimes::class);
  4491.                         $courseAddTime = $repository->findOneBy(['cat_number' => $courseTime->getCttNumber(), 'cat_cid' => $courseTime->getCttCid()]);
  4492.                         $bookingOption = $courseAddTime->getCatBookingOption();
  4493.                         
  4494.                         $repository = $this->getDoctrine()->getRepository(CourseImages::class);
  4495.                         $courseImage = $repository->findOneBy(['ci_cid' => trim(checkUserInput($courseId)) ]);
  4496.                         
  4497.                         $repository = $this->getDoctrine()->getRepository(Course::class);
  4498.                         $course = $repository->findOneBy(['id' => trim(checkUserInput($courseId)) ]);
  4499.                         
  4500.                         $amount = 0;
  4501.                         $amount = $session->get('cartAmount'.$i);
  4502.                         
  4503.                         $siblingDiscountGranted = false;
  4504.                         for($j = 1; $j <= $amount; $j++)
  4505.                         {
  4506.                             $first = "";
  4507.                             $last = "";
  4508.                             $person = "";
  4509.                             //go through all Persons 
  4510.                             // amount  == persons
  4511.                             
  4512.                                 $x = 1;
  4513.                                 $tmpperson = $session->get('cartAddPerson'.$i); 
  4514.                                 $tmpperson = explode("***",$tmpperson);
  4515.                                 foreach($tmpperson as $tmppers)
  4516.                                 {
  4517.                                     if($x == $j)
  4518.                                     {
  4519.                                         $person2 = explode(";;;",$tmppers);
  4520.                                         $z = 0;
  4521.                                         foreach($person2 as $p)
  4522.                                         {
  4523.                                             if($z == 0){ $person = $p. ' '; }
  4524.                                             if($z == 1){ $person .= $p; }
  4525.                                             if($z == 2){ continue; }
  4526.         
  4527.                                             $z++;
  4528.                                         }
  4529.                                         
  4530.                                     }
  4531.                                     $x++;
  4532.                                 }
  4533.                             
  4534.                             $repository = $this->getDoctrine()->getRepository(Orders::class);
  4535.                             $orders = $repository->findBy(['o_uid' => trim($uid) ]);
  4536.                             foreach($orders as $order )
  4537.                             {
  4538.                                 $repository = $this->getDoctrine()->getRepository(OrderItems::class);
  4539.                                 $orderItems = $repository->findBy(['oi_oid' => trim($order->getId()) ]);
  4540.                                 foreach($orderItems as $orderItem )
  4541.                                 {
  4542.                                     //check if exact course and time was already bought
  4543.                                     if($orderItem->getOiTid() == $courseTime->getId() && $orderItem->getOiCid() == $course->getId())
  4544.                                     {
  4545.                                         //last check the names
  4546.                                         $repository = $this->getDoctrine()->getRepository(CourseAddPerson::class);
  4547.                                         $addPersons = $repository->findBy(['cap_oid' => trim($orderItem->getId()) ]);
  4548.                                         foreach($addPersons as $addPerson )
  4549.                                         {
  4550.                                             if(($addPerson->getCapFirstname()." ". $addPerson->getCapLastname()) == $person)
  4551.                                             {
  4552.                                                 //warning
  4553.                                                 $warningCount++;
  4554.                                                 if($warningCount == 1)
  4555.                                                 {
  4556.                                                     $warning = "Achtung! Sie haben bereits f&uuml;r folgende Personen diesen Kurs zur gleichen Zeit gebucht.";
  4557.                                                     $warning .= "<table>";
  4558.                                                     $warning .= "<tr>";
  4559.                                                     $warning .= "<th>Kurs</th>";
  4560.                                                     $warning .= "<th>Kurszeit</th>";
  4561.                                                     $warning .= "<th>Name</th>";
  4562.                                                     $warning .= "</tr>";
  4563.                                                     
  4564.                                                 }
  4566.                                                 $warning .= "<tr>";
  4567.                                                 $warning .= "<td>".$course->getCName()."</td>";
  4568.                                                 $warning .= "<td>".$courseTime->getCttFrom()->format('H:i') ." - ". $courseTime->getCttTo()->format('H:i') ."</td>";
  4569.                                                 $warning .= "<td>".$person."</td>";
  4570.                                                 $warning .= "</tr>";
  4572.                                             }
  4573.                                         }
  4574.                                     }
  4575.                                 }
  4576.                             }
  4577.                         }
  4578.                     }
  4579.                 }
  4580.             }
  4581.         }
  4583.         if($warning != "" ){$warning .= "</table>";}
  4584.         $sib = $session->get('siblingDiscount');
  4585.         $studio = $session->get('studioDiscount');
  4586.         
  4588.         $fullprice = number_format($fullprice, 2, ',','.')." €";
  4589.         $fullpriceTax = number_format($fullpriceTax, 2, ',','.')." €";
  4590.         return $this->render('course/cart.html.twig',[ 'warning' => $warning,'data' => $outputArr,'sib' => $sib ,'showSibling' => $showSiblingDiscount,'studio' => $studio,'showStudio' => $showStudioDiscount,'data2' => $outputArr2,"fullprice" => $fullprice , 'taxes' => $taxArr, 'fullpricetax' => $fullpriceTax, 'anonBuy' => $anonBuy, 'adminFee' => $adminFee] );
  4591.     }
  4593.     /**
  4594.      * @Route("/loadCartSiblingDiscount/{sib}" , name="loadCartSiblingDiscount")
  4595.     */
  4596.     public function loadCartSiblingDiscount($sib)
  4597.     {
  4598.         require_once("./include/function.php");
  4599.         require_once("./include/global.php");
  4601.         $session = $this->requestStack->getSession(); //$session = $this->get('session');
  4602.         $session->set('siblingDiscount',$sib);
  4604.         $response = $this->redirect($url ."cart");
  4605.         return $response;
  4606.     }
  4608.     /**
  4609.      * @Route("/loadStudioDiscount/{sib}" , name="loadStudioDiscount")
  4610.     */
  4611.     public function loadStudioDiscount($sib)
  4612.     {
  4613.         require_once("./include/function.php");
  4614.         require_once("./include/global.php");
  4616.         $session = $this->requestStack->getSession(); //$session = $this->get('session');
  4617.         $session->set('studioDiscount',$sib);
  4619.         $response = $this->redirect($url ."cart");
  4620.         return $response;
  4621.     }
  4623.     
  4624.     /**
  4625.      * @Route("/dropArticle/{id}" , name="dropArticle")
  4626.     */
  4627.     public function dropArticle($id)
  4628.     {
  4629.         require_once("./include/function.php");
  4630.         require_once("./include/global.php");
  4632.         $session = $this->requestStack->getSession(); //$session = $this->get('session');
  4634.         $outputArr = array();
  4636.         $end = $session->get('cartitems');
  4637.         
  4638.         $tmp1Arr = array();
  4639.         $tmp2Arr = array();
  4640.         $tmp3Arr = array();
  4641.         $tmp4Arr = array();
  4642.         $tmp5Arr = array();
  4643.         $tmp6Arr = array();
  4644.         $tmp7Arr = array();
  4645.         $tmp8Arr = array();
  4646.         $j = 0;
  4648.         for($i = 1; $i <= $end; $i++ )
  4649.         {
  4650.             if($i == $id){continue;}
  4651.             $j++;
  4652.             $tmp1Arr[$j] =  $session->get('cartTime'.$i);
  4653.             $tmp2Arr[$j] =  $session->get('cartCourse'.$i);
  4654.             $tmp3Arr[$j] =  $session->get('cartDate'.$i);
  4655.             $tmp4Arr[$j] =  $session->get('cartAmount'.$i);
  4656.             $tmp5Arr[$j] =  $session->get('cartArticle'.$i);
  4657.             $tmp6Arr[$j] =  $session->get('cartItemMode'.$i);
  4658.             $tmp7Arr[$j] =  $session->get('cartAddPerson'.$i);
  4659.             $tmp8Arr[$j] =  $session->get('cartSibling'.$i);
  4660.         }
  4662.         $anz = $session->get('cartitems');
  4663.         for($i = 1; $i <= $end; $i++ )
  4664.         {
  4665.             $session->remove('cartTime'.$i);
  4666.             $session->remove('cartCourse'.$i);
  4667.             $session->remove('cartDate'.$i);
  4668.             $session->remove('cartAmount'.$i);
  4669.             $session->remove('cartArticle'.$i);
  4670.             $session->remove('cartItemMode'.$i);
  4671.             $session->remove('cartAddPerson'.$i);
  4672.             $session->remove('cartSibling'.$i);
  4673.         }
  4677.         $anz = $anz - 1;
  4678.         $session->set('cartitems', $anz);
  4680.         for($i = 1; $i <= $j; $i++ )
  4681.         {
  4682.             $session->set('cartTime'.$i, $tmp1Arr[$i]);
  4683.             $session->set('cartCourse'.$i, $tmp2Arr[$i]);
  4684.             $session->set('cartDate'.$i, $tmp3Arr[$i]);
  4685.             $session->set('cartAmount'.$i, $tmp4Arr[$i]);
  4686.             $session->set('cartArticle'.$i, $tmp5Arr[$i]);
  4687.             $session->set('cartItemMode'.$i, $tmp6Arr[$i]);
  4688.             $session->set('cartAddPerson'.$i, $tmp7Arr[$i]);
  4689.             $session->set('cartSibling'.$i, $tmp8Arr[$i]);
  4690.         
  4691.         }
  4693.  
  4694.         $uname = $this->get('security.token_storage')->getToken()->getUser();
  4695.         $uid = 0;
  4696.         if(is_object($uname))
  4697.         {
  4698.            if($uname->getId() != 0 )
  4699.             {
  4700.                 $repository = $this->getDoctrine()->getRepository(User::class);
  4701.                 $user = $repository->findOneBy(['id' => $uname->getId()]);
  4702.                 $uid = $user->getId();
  4703.             
  4704.                 $em = $this->getDoctrine()->getManager();
  4705.                 $repository = $this->getDoctrine()->getRepository(Cart::class);
  4706.                 $cart = $repository->findBy(['ca_uid' => $uid ]);
  4707.                 foreach($cart as $ca)
  4708.                 {
  4709.                     if($ca && $ca != null && is_null($ca) == false )
  4710.                     {
  4711.                         $em->remove($ca);
  4712.                         $em->flush();
  4713.                     }
  4714.                 }
  4715.             }
  4716.         }
  4717.         else
  4718.         {
  4719.             $session = $this->requestStack->getSession(); //$session = $this->get('session');
  4720.             
  4721.             $em = $this->getDoctrine()->getManager();
  4722.             $repository = $this->getDoctrine()->getRepository(Cart::class);
  4723.             $cart = $repository->findBy(['ca_session' => $session->getId() ]);
  4724.             foreach($cart as $ca)
  4725.             {
  4726.                 if($ca && $ca != null && is_null($ca) == false )
  4727.                 {
  4728.                     $em->remove($ca);
  4729.                     $em->flush();
  4730.                 }
  4731.             }
  4732.         }
  4733.         
  4735.         $placeid = $session->get('place');
  4737.         $log = new Userlog();
  4738.         if($this->get('security.token_storage')->getToken()->getUser() == 'anon.'){
  4739.             $log->setUlUid(0);
  4740.         }
  4741.         else{
  4742.             $log->setUlUid( $user->getId());
  4743.         }
  4744.         $log->setUlSessionid($session->getId());
  4745.         $log->setUlBrowser($_SERVER['HTTP_USER_AGENT']);
  4746.         $log->setUlIp($_SERVER['REMOTE_ADDR']);
  4747.         
  4748.         $now = new \DateTime(date("Y-m-d H:i:s"));
  4749.         $log->setUlNow($now);
  4750.         if($placeid == NULL)
  4751.         {
  4752.             $log->setUlPlace(0);
  4753.         }
  4754.         else
  4755.         {
  4756.             $log->setUlPlace($placeid);
  4757.         }
  4758.         $log->setUlAction(6);
  4759.         $log->setUlReferer($_SERVER['HTTP_REFERER']);
  4760.         $log->setUlCurrentPage($_SERVER['REQUEST_URI']);
  4762.         $em = $this->getDoctrine()->getManager();
  4763.         $em->persist($log);
  4764.         $em->flush();
  4767.         $response = $this->redirect($url ."cart");
  4768.         return $response;
  4769.     }
  4770.     
  4772.     /**
  4773.      * @Route("/dropArticle2/{id}/{person}" , name="dropArticle2")
  4774.     */
  4775.     public function dropArticle2($id,$person)
  4776.     {
  4777.         require_once("./include/function.php");
  4778.         require_once("./include/global.php");
  4780.         $session = $this->requestStack->getSession(); //$session = $this->get('session');
  4782.         $outputArr = array();
  4784.         $end = $session->get('cartitems');
  4785.         
  4786.         $tmp1Arr = array();
  4787.         $tmp2Arr = array();
  4788.         $tmp3Arr = array();
  4789.         $tmp4Arr = array();
  4790.         $tmp5Arr = array();
  4791.         $tmp6Arr = array();
  4792.         $tmp7Arr = array();
  4793.         $tmp8Arr = array();
  4794.         $j = 0;
  4796.         if($person != "" && $session->get('cartItemMode'.$id) == '1' && $session->get('cartAmount'.$id) >= 2)
  4797.         {
  4798.             $amt = $session->get('cartAmount'.$id);
  4799.             $session->set('cartAmount'.$id, ($amt - 1 ));
  4800.             $personItem =  $session->get('cartAddPerson'.$id);
  4801.             // *** = each person
  4802.             // ;;; = person data
  4803.             $personItemArr = explode("***",$personItem);
  4804.             $newPersonItem = "";
  4805.             foreach($personItemArr as $pia)
  4806.             {
  4807.                 $personDataArr = explode(";;;",$pia);
  4808.                 $pdaTmp = "";
  4809.                 $x = 0;
  4810.                 foreach($personDataArr as $pda)
  4811.                 {
  4812.                     if($x == 2){ continue; }
  4813.                     $pdaTmp = $pda;
  4814.                     $x++;
  4815.                 }
  4816.                 
  4817.                 if($pdaTmp == $person){ continue; }
  4818.                 else
  4819.                 {
  4820.                     $newPersonItem .= $pia.'***';
  4821.                 }
  4822.                 
  4823.             }
  4824.             $session->set('cartAddPerson'.$id,$newPersonItem);
  4825.         }
  4826.         else
  4827.         {
  4828.             
  4829.             for($i = 1; $i <= $end; $i++ )
  4830.             {
  4831.                 if($i == $id){continue;}
  4832.                 $j++;
  4833.                 $tmp1Arr[$j] =  $session->get('cartTime'.$i);
  4834.                 $tmp2Arr[$j] =  $session->get('cartCourse'.$i);
  4835.                 $tmp3Arr[$j] =  $session->get('cartDate'.$i);
  4836.                 $tmp4Arr[$j] =  $session->get('cartAmount'.$i);
  4837.                 $tmp5Arr[$j] =  $session->get('cartArticle'.$i);
  4838.                 $tmp6Arr[$j] =  $session->get('cartItemMode'.$i);
  4839.                 $tmp7Arr[$j] =  $session->get('cartAddPerson'.$i);
  4840.                 $tmp8Arr[$j] =  $session->get('cartSibling'.$i);
  4841.             }
  4842.             
  4843.             $anz = $session->get('cartitems');
  4844.             for($i = 1; $i <= $end; $i++ )
  4845.             {
  4846.                 $session->remove('cartTime'.$i);
  4847.                 $session->remove('cartCourse'.$i);
  4848.                 $session->remove('cartDate'.$i);
  4849.                 $session->remove('cartAmount'.$i);
  4850.                 $session->remove('cartArticle'.$i);
  4851.                 $session->remove('cartItemMode'.$i);
  4852.                 $session->remove('cartAddPerson'.$i);
  4853.                 $session->remove('cartSibling'.$i);
  4854.             }
  4855.             
  4856.             
  4857.             
  4858.             $anz = $anz - 1;
  4859.             $session->set('cartitems', $anz);
  4860.             
  4861.             for($i = 1; $i <= $j; $i++ )
  4862.             {
  4863.                 $session->set('cartTime'.$i, $tmp1Arr[$i]);
  4864.                 $session->set('cartCourse'.$i, $tmp2Arr[$i]);
  4865.                 $session->set('cartDate'.$i, $tmp3Arr[$i]);
  4866.                 $session->set('cartAmount'.$i, $tmp4Arr[$i]);
  4867.                 $session->set('cartArticle'.$i, $tmp5Arr[$i]);
  4868.                 $session->set('cartItemMode'.$i, $tmp6Arr[$i]);
  4869.                 $session->set('cartAddPerson'.$i, $tmp7Arr[$i]);
  4870.                 $session->set('cartSibling'.$i, $tmp8Arr[$i]);
  4871.                 
  4872.             }
  4873.         }
  4874.         
  4875.         
  4876.         $uname = $this->get('security.token_storage')->getToken()->getUser();
  4877.         $uid = 0;
  4878.         if(is_object($uname))
  4879.         {
  4880.            if($uname->getId() != 0 )
  4881.             {
  4882.                 $repository = $this->getDoctrine()->getRepository(User::class);
  4883.                 $user = $repository->findOneBy(['id' => $uname->getId()]);
  4884.                 $uid = $user->getId();
  4885.             
  4886.                 $em = $this->getDoctrine()->getManager();
  4887.                 $repository = $this->getDoctrine()->getRepository(Cart::class);
  4888.                 $cart = $repository->findBy(['ca_uid' => $uid ]);
  4889.                 foreach($cart as $ca)
  4890.                 {
  4891.                     if($ca && $ca != null && is_null($ca) == false )
  4892.                     {
  4893.                         $em->remove($ca);
  4894.                         $em->flush();
  4895.                     }
  4896.                 }
  4897.             }
  4898.         }
  4899.         else
  4900.         {
  4901.             $session = $this->requestStack->getSession(); //$session = $this->get('session');
  4902.             
  4903.             $em = $this->getDoctrine()->getManager();
  4904.             $repository = $this->getDoctrine()->getRepository(Cart::class);
  4905.             $cart = $repository->findBy(['ca_session' => $session->getId() ]);
  4906.             foreach($cart as $ca)
  4907.             {
  4908.                 if($ca && $ca != null && is_null($ca) == false )
  4909.                 {
  4910.                     $em->remove($ca);
  4911.                     $em->flush();
  4912.                 }
  4913.             }
  4914.         }
  4917.                 
  4918.         $placeid = $session->get('place');
  4920.         $user = $this->get('security.token_storage')->getToken()->getUser();
  4921.         $log = new Userlog();
  4922.         if($this->get('security.token_storage')->getToken()->getUser() == 'anon.'){
  4923.             $log->setUlUid(0);
  4924.         }
  4925.         else{
  4926.             $log->setUlUid( $user->getId());
  4927.         }
  4928.         $log->setUlSessionid($session->getId());
  4929.         $log->setUlBrowser($_SERVER['HTTP_USER_AGENT']);
  4930.         $log->setUlIp($_SERVER['REMOTE_ADDR']);
  4931.         
  4932.         $now = new \DateTime(date("Y-m-d H:i:s"));
  4933.         $log->setUlNow($now);
  4934.         if($placeid == NULL)
  4935.         {
  4936.             $log->setUlPlace(0);
  4937.         }
  4938.         else
  4939.         {
  4940.             $log->setUlPlace($placeid);
  4941.         }
  4942.         $log->setUlAction(6);
  4943.         $log->setUlReferer($_SERVER['HTTP_REFERER']);
  4944.         $log->setUlCurrentPage($_SERVER['REQUEST_URI']);
  4946.         $em = $this->getDoctrine()->getManager();
  4947.         $em->persist($log);
  4948.         $em->flush();
  4949.         
  4950.         $response = $this->redirect($url ."cart");
  4951.         return $response;
  4952.     
  4953.     }
  4955.     /**
  4956.      * @Route("/checkDuplicateCourse" , name="checkDuplicateCourse", options={"expose"=true})
  4957.      */
  4958.     public function checkDuplicateCourse()
  4959.     {
  4960.         require_once("./include/function.php");
  4961.         
  4962.         if($this->get('security.token_storage')->getToken()->getUser() == 'anon.')
  4963.         {
  4964.             $response = $this->forward('App\Controller\CourseController::homepage', []);
  4965.             return $response;
  4966.         }
  4968.         $name = checkUserInput($_POST['name']);
  4969.         $starttime = checkUserInput($_POST['starttime']);
  4970.         $endtime = checkUserInput($_POST['endtime']);
  4971.         $activeFrom = checkUserInput($_POST['activefrom']);
  4972.         $activeUntill = checkUserInput($_POST['activeuntill']);
  4974.         $breakbefore = checkUserInput($_POST['breakbefore']);
  4975.         $breakafter = checkUserInput($_POST['breakafter']);
  4976.         $duration = checkUserInput($_POST['duration']);
  4977.         
  4978.         $costplace = checkUserInput($_POST['costplace']);
  4981.         $mon = checkUserInput($_POST['mon']);
  4982.         $tue = checkUserInput($_POST['tue']);
  4983.         $wed = checkUserInput($_POST['wed']);
  4984.         $thu = checkUserInput($_POST['thu']);
  4985.         $fri = checkUserInput($_POST['fri']);
  4986.         $sat = checkUserInput($_POST['sat']);
  4987.         $sun = checkUserInput($_POST['sun']);
  4988.         $exists = false;
  4989.         $repository = $this->getDoctrine()->getRepository(Course::class);
  4990.         $course = $repository->findBy(['c_name' => trim(checkUserInput($name)), 'c_active' => 1, 'c_costplace' => $costplace ]);
  4991.         if($course)
  4992.         {
  4993.             //name found
  4994.             //loop every course and check if same timeslot found, if yes forbid
  4995.             foreach($course as $c)
  4996.             {
  4998.                 $start = new \DateTime(date('H:i:s', strtotime($starttime)));
  4999.                 $end = new \DateTime(date('H:i:s', strtotime($endtime)));
  5001.                 $begin = new \DateTime(date("Y-m-d",strtotime($activeFrom)));
  5002.                 $endDate = new \DateTime(date('Y-m-d',strtotime($activeUntill)));
  5003.                 
  5004.                 $interval = \DateInterval::createFromDateString('1 day');
  5005.                 $period = new \DatePeriod($begin, $interval, $endDate);
  5006.                 
  5007.                 //each day from start to activeUntill
  5008.                 foreach ($period as $dt) 
  5009.                 {
  5010.                     $day1 = $dt->format("Y-m-d \n"); 
  5011.                     $day = new \DateTime(date("Y-m-d", strtotime($day1)));
  5012.                     
  5013.                     
  5014.                     if($this->checkHoliday($dt->format("d.m.Y")) != false ){ continue; }
  5015.                     if(date('w', strtotime($dt->format("d.m.Y"))) == 0 && $sun == 0) {continue; }
  5016.                     if(date('w', strtotime($dt->format("d.m.Y"))) == 1 && $mon == 0) {continue; }
  5017.                     if(date('w', strtotime($dt->format("d.m.Y"))) == 2 && $tue == 0) {continue; }
  5018.                     if(date('w', strtotime($dt->format("d.m.Y"))) == 3 && $wed == 0) {continue; }
  5019.                     if(date('w', strtotime($dt->format("d.m.Y"))) == 4 && $thu == 0) {continue; }
  5020.                     if(date('w', strtotime($dt->format("d.m.Y"))) == 5 && $fri == 0) {continue; }
  5021.                     if(date('w', strtotime($dt->format("d.m.Y"))) == 6 && $sat == 0) {continue; }
  5022.                     
  5023.                     
  5024.                     $d1 = new \DateTime(date("H:i:s",strtotime($starttime)));
  5025.                     
  5026.                     
  5027.                     while($d1 < $end)
  5028.                     {
  5029.                         
  5030.                         $d1orig = new \DateTime(date('H:i:s',strtotime($d1->format('H:i:s')))); 
  5031.                         
  5032.                         $d1->add(new \DateInterval('PT' . $duration . 'M'));
  5033.                         
  5034.                         $repository = $this->getDoctrine()->getRepository(CourseTimes::class);
  5035.                         $courseTime = $repository->findBy([
  5036.                             'ctt_cid' => trim($c->getId()), 
  5037.                             'ctt_day' => $day, 
  5038.                             'ctt_from' => $d1orig, 
  5039.                             'ctt_to' => $d1, 
  5040.                         ]);
  5041.                         if($courseTime)
  5042.                         {
  5043.                             $exists = true;
  5044.                         }
  5045.                         
  5046.                         $d1->add(new \DateInterval('PT' . $breakbefore . 'M'));
  5047.                         $d1->add(new \DateInterval('PT' . $breakafter . 'M'));
  5048.                         
  5049.                         
  5050.                     }
  5051.                 }
  5052.             }
  5053.             if($exists == true)
  5054.             {
  5055.                 return new Response("nok");
  5056.             }
  5057.             else
  5058.             {
  5059.                 return new Response("ok");
  5060.             }
  5061.         }   
  5062.         else
  5063.         {
  5064.             // OK 
  5065.             return new Response("ok");
  5067.         }   
  5068.     }
  5071.     
  5072.     /**
  5073.      * @Route("/getCourseAmount" , name="getCourseAmount", options={"expose"=true})
  5074.      */
  5075.     public function getCourseAmount()
  5076.     {
  5077.         require_once("./include/function.php");
  5078.         
  5079.         
  5081.         $id = $_POST['id'];
  5083.         $repository = $this->getDoctrine()->getRepository(CourseTimes::class);
  5084.         $courseTime = $repository->findOneBy(['id' => $id]);
  5086.         $repository = $this->getDoctrine()->getRepository(Course::class);
  5087.         $course = $repository->findOneBy(['id' => $courseTime->getCttCid()]);
  5089.         $maxCustomer = 0;
  5090.         $usedSlots = 0;
  5092.         $maxCustomer = $courseTime->getCttMaxonline();
  5093.         if($this->get('security.token_storage')->getToken()->getUser() == 'anon.')
  5094.         {
  5095.             //Guest
  5096.         }
  5097.         else
  5098.         {
  5100.             $uid2 = $this->get('security.token_storage')->getToken()->getUser();
  5101.             $role = $uid2->getURole();
  5103.             if($role == 1 || $role == 2)
  5104.             {
  5105.                 //Customer
  5106.             }
  5107.             else 
  5108.             {
  5109.                 //employee
  5110.                 $maxCustomer = $maxCustomer + $courseTime->getCttMaxoffline();
  5111.             }
  5112.         }
  5115.         //$usedSlots = $this->getUsedSlots($id);
  5116.         if($this->get('security.token_storage')->getToken()->getUser() == 'anon.')
  5117.         {
  5118.             $usedSlots = $courseTime->getCttOnline() ;
  5119.         }
  5120.         else
  5121.         {
  5122.             $uid2 = $this->get('security.token_storage')->getToken()->getUser();
  5123.             $role = $uid2->getURole();
  5125.             if($role == 1 || $role == 2)
  5126.             {
  5127.                 //Customer
  5128.                 $usedSlots = $courseTime->getCttOnline();
  5129.             }
  5130.             else 
  5131.             {
  5132.                 //employee
  5133.                 $usedSlots = $courseTime->getCttOnline() + $courseTime->getCttOfflineCustomer();
  5134.             }
  5135.         }
  5137.         $checkCart = true;
  5138.         if($this->get('security.token_storage')->getToken()->getUser() != 'anon.')
  5139.         {
  5140.             $uid2 = $this->get('security.token_storage')->getToken()->getUser();
  5141.             $role2 = $uid2->getURole();
  5142.             if($role2 == '3' || $role2 == '4' || $role2 == '5')
  5143.             {
  5144.                 $checkCart = false;
  5145.             }
  5146.         }
  5147.         if($checkCart == true)
  5148.         {
  5149.             $repository = $this->getDoctrine()->getRepository(Cart::class);
  5150.             $ca = $repository->findBy(['ca_cid' => $courseTime->getCttCid(), 'ca_tid' => $id]);
  5151.             foreach($ca as $c)
  5152.             {
  5153.                 $usedSlots = $usedSlots + $c->getCaAmount();
  5154.             }
  5155.         }
  5157.         $diff = $maxCustomer - $usedSlots;
  5158.         
  5159.         return new Response($diff);
  5160.     }
  5161.     
  5162.     /**
  5163.      * @Route("/getSeriesDays" , name="getSeriesDays", options={"expose"=true})
  5164.      */
  5165.     public function getSeriesDays()
  5166.     {
  5167.         require_once("./include/function.php");
  5168.         require_once("./include/global.php");
  5169.         
  5170.         
  5172.         $id = $_POST['id'];
  5174.         $repository = $this->getDoctrine()->getRepository(CourseTimes::class);
  5175.         $courseTime = $repository->findOneBy(['id' => $id]);
  5177.         $repository = $this->getDoctrine()->getRepository(Course::class);
  5178.         $course = $repository->findOneBy(['id' => $courseTime->getCttCid()]);
  5180.         $t1 = $courseTime->getCttDay();
  5181.         $t1 = $t1->format('Y-m-d'); 
  5183.         $t2 = $courseTime->getCttFrom();
  5184.         $t2 = $t2->format('H:i:s'); 
  5186.         $query = "SELECT * FROM course_times WHERE ctt_cid = :cid AND ctt_active = 1  AND ctt_from = :from AND ctt_day >= :day  ORDER BY ctt_day ASC LIMIT " . $course->getCAppointmentSeriesDays();
  5187.         $em2 = $this->getDoctrine()->getManager();   
  5189.         $resultSet = $em2->getConnection()->executeQuery($query,['cid' => $course->getId(), 'from' => $t2 , "day" => $t1]);
  5191.         
  5192.         $output = "Termine:<br>";
  5193.         $i = 0;
  5194.         
  5195.         foreach($resultSet as $res) 
  5196.         {
  5197.             $button = "";
  5198.             $button .= '<svg xmlns="http://www.w3.org/2000/svg" width="'.$defaultIconWidth.'" height="'.$defaultIconHeight.'" fill="currentColor" class="bi bi-x-lg" viewBox="0 0 16 16">';
  5199.             $button .= '<path fill-rule="evenodd" d="M13.854 2.146a.5.5 0 0 1 0 .708l-11 11a.5.5 0 0 1-.708-.708l11-11a.5.5 0 0 1 .708 0Z"/>';
  5200.             $button .= '<path fill-rule="evenodd" d="M2.146 2.146a.5.5 0 0 0 0 .708l11 11a.5.5 0 0 0 .708-.708l-11-11a.5.5 0 0 0-.708 0Z"/>';
  5201.             $button .= '</svg>';
  5203.             $i++;
  5204.             $output .= $i. ". ". date("d.m.Y",strtotime($res['ctt_day'])) . " ". date("H:i",strtotime($res['ctt_from'])). " - ". date("H:i",strtotime($res['ctt_to'])). "<br>";
  5205.         }
  5207.         
  5208.         return new Response($output);
  5209.     }
  5210.     
  5211.     /**
  5212.      * @Route("/getSeriesWeekDays" , name="getSeriesWeekDays", options={"expose"=true})
  5213.      */
  5214.     public function getSeriesWeekDays()
  5215.     {
  5216.         require_once("./include/function.php");
  5217.         require_once("./include/global.php");
  5218.         
  5219.         $id = $_POST['id'];
  5221.         $repository = $this->getDoctrine()->getRepository(CourseTimes::class);
  5222.         $courseTime = $repository->findOneBy(['id' => $id]);
  5223.         $weekday = date("N",strtotime($courseTime->getCttDay()->format("Y-m-d")));
  5225.         $repository = $this->getDoctrine()->getRepository(CourseAdditionalTimes::class);
  5226.         $courseAddTime = $repository->findOneBy(['cat_number' => $courseTime->getCttNumber(), 'cat_cid' => $courseTime->getCttCid()]);
  5227.         if(!$courseAddTime)
  5228.         {
  5229.             return $this->render('checkout/error.html.twig', [ ]);
  5230.         }
  5231.         $bookingOption = $courseAddTime->getCatBookingOption();
  5232.         
  5233.         $repository = $this->getDoctrine()->getRepository(Course::class);
  5234.         $course = $repository->findOneBy(['id' => $courseTime->getCttCid()]);
  5236.         $t1 = $courseTime->getCttDay();
  5237.         $t1 = $t1->format('Y-m-d'); 
  5239.         $t2 = $courseTime->getCttFrom();
  5240.         $t2 = $t2->format('H:i:s'); 
  5242.         $query = "SELECT * FROM course_times WHERE  ctt_active = 1 AND ctt_cid = :cid AND ctt_active = 1  AND ctt_from = :from AND ctt_day >= :day AND ctt_number = :number  ORDER BY ctt_day ASC";
  5243.         $em2 = $this->getDoctrine()->getManager();   
  5245.         $resultSet = $em2->getConnection()->executeQuery($query,['cid' => $course->getId(), 'from' => $t2 , "day" => $t1, "number" => $courseTime->getCttNumber()]);
  5246.         
  5248.         $output = "Termine:<br>";
  5249.         $i = 0;
  5250.         $dates = 0;
  5251.         foreach($resultSet as $res) 
  5252.         {
  5253.             if($bookingOption == 1)
  5254.             {
  5255.                 //check if same weekdays
  5256.                 $tmp = date("N",strtotime($res['ctt_day']));
  5257.                 if($tmp != $weekday ){ continue; }
  5258.             }
  5259.             
  5260.             $button = "";
  5261.             $button .= '<svg xmlns="http://www.w3.org/2000/svg" width="'.$defaultIconWidth.'" height="'.$defaultIconHeight.'" fill="currentColor" class="bi bi-x-lg" viewBox="0 0 16 16">';
  5262.             $button .= '<path fill-rule="evenodd" d="M13.854 2.146a.5.5 0 0 1 0 .708l-11 11a.5.5 0 0 1-.708-.708l11-11a.5.5 0 0 1 .708 0Z"/>';
  5263.             $button .= '<path fill-rule="evenodd" d="M2.146 2.146a.5.5 0 0 0 0 .708l11 11a.5.5 0 0 0 .708-.708l-11-11a.5.5 0 0 0-.708 0Z"/>';
  5264.             $button .= '</svg>';
  5265.             
  5266.             $i++;
  5267.             $output .= $i. ". ". date("d.m.Y",strtotime($res['ctt_day'])) . " ". date("H:i",strtotime($res['ctt_from'])). " - ". date("H:i",strtotime($res['ctt_to'])). "<br>";
  5269.             $dates++;
  5270.             if($dates >= 1 && $bookingOption == 0){ break; }
  5272.         }
  5274.         
  5275.         return new Response($output);
  5276.     }
  5277.     
  5278.     /**
  5279.      * @Route("/getSeriesDaysPrice" , name="getSeriesDaysPrice", options={"expose"=true})
  5280.      */
  5281.     public function getSeriesDaysPrice()
  5282.     {
  5283.         require_once("./include/function.php");
  5284.         require_once("./include/global.php");
  5285.         
  5286.         $id = $_POST['id'];
  5288.         $repository = $this->getDoctrine()->getRepository(CourseTimes::class);
  5289.         $courseTime = $repository->findOneBy(['id' => $id]);
  5291.         $repository = $this->getDoctrine()->getRepository(Course::class);
  5292.         $course = $repository->findOneBy(['id' => $courseTime->getCttCid()]);
  5294.         $coursePrice = $course->getCPrice();
  5295.         $adminFee = $course->getCAdminFee();
  5297.         $t1 = $courseTime->getCttDay();
  5298.         $t1 = $t1->format('Y-m-d'); 
  5300.         $t2 = $courseTime->getCttFrom();
  5301.         $t2 = $t2->format('H:i:s'); 
  5303.         $query = "SELECT * FROM course_times WHERE ctt_cid = :cid AND ctt_active = 1  AND ctt_from = :from AND ctt_day >= :day  ORDER BY ctt_day ASC LIMIT " . $course->getCAppointmentSeriesDays();
  5304.         $em2 = $this->getDoctrine()->getManager();   
  5306.         $resultSet = $em2->getConnection()->executeQuery($query,['cid' => $course->getId(), 'from' => $t2 , "day" => $t1]);
  5308.         if($_POST['sibling'] == '1')
  5309.         {
  5310.             $discount = $siblingDiscountGlob;
  5311.         }
  5312.         else
  5313.         {
  5314.             $discount = $_POST['discount'];
  5315.         }
  5319.         $output = "Termine:<br>";
  5320.         $i = 0;
  5321.         $outprice = 0;
  5322.         foreach($resultSet as $res) 
  5323.         {
  5324.             $i++;
  5325.             $outprice = $outprice + $coursePrice;
  5326.         }
  5327.         $outprice = $outprice + $adminFee;
  5328.         $outprice = $outprice * (1 - ($discount / 100));
  5329.         $outprice = number_format($outprice, 2, ',','.'). " €"; 
  5330.         
  5331.         return new Response($outprice);
  5332.     }
  5333.     
  5334.     /**
  5335.      * @Route("/getSeriesWeekDaysPrice" , name="getSeriesWeekDaysPrice", options={"expose"=true})
  5336.      */
  5337.     public function getSeriesWeekDaysPrice()
  5338.     {
  5339.         require_once("./include/function.php");
  5340.         require_once("./include/global.php");
  5341.         
  5342.         $id = $_POST['id'];
  5344.         $repository = $this->getDoctrine()->getRepository(CourseTimes::class);
  5345.         $courseTime = $repository->findOneBy(['id' => $id]);
  5346.         $weekday = date("N",strtotime($courseTime->getCttDay()->format("Y-m-d")));
  5348.         $repository = $this->getDoctrine()->getRepository(CourseAdditionalTimes::class);
  5349.         $courseAddTime = $repository->findOneBy(['cat_number' => $courseTime->getCttNumber(), 'cat_cid' => $courseTime->getCttCid()]);
  5350.         $bookingOption = $courseAddTime->getCatBookingOption();
  5352.         $repository = $this->getDoctrine()->getRepository(Course::class);
  5353.         $course = $repository->findOneBy(['id' => $courseTime->getCttCid()]);
  5355.         $coursePrice = $course->getCPrice();
  5356.         $adminFee = $course->getCAdminFee();
  5358.         $t1 = $courseTime->getCttDay();
  5359.         $t1 = $t1->format('Y-m-d'); 
  5361.         $t2 = $courseTime->getCttFrom();
  5362.         $t2 = $t2->format('H:i:s'); 
  5364.         $query = "SELECT * FROM course_times WHERE ctt_cid = :cid AND ctt_active = 1  AND ctt_from = :from AND ctt_day >= :day AND ctt_number = :number  ORDER BY ctt_day ASC";
  5365.         $em2 = $this->getDoctrine()->getManager();   
  5367.         $resultSet = $em2->getConnection()->executeQuery($query,['cid' => $course->getId(), 'from' => $t2 , "day" => $t1, "number" => $courseTime->getCttNumber()]);
  5369.         if($_POST['sibling'] == '1')
  5370.         {
  5371.             $discount = $siblingDiscountGlob;
  5372.         }
  5373.         else
  5374.         {
  5375.             $discount = $_POST['discount'];
  5376.         }
  5380.         $output = "Termine:<br>";
  5381.         $i = 0;
  5382.         $outprice = 0;
  5383.         $dates = 0;
  5384.         foreach($resultSet as $res) 
  5385.         {
  5386.             
  5387.             if($bookingOption == 1)
  5388.             {
  5389.                 //check if same weekdays
  5390.                 $tmp = date("N",strtotime($res['ctt_day']));
  5391.                 if($tmp != $weekday ){ continue; }
  5392.             }
  5393.             $i++;
  5394.             $outprice = $outprice + $coursePrice;
  5395.             
  5396.             $dates++;
  5397.             if($dates >= 1 && $bookingOption == 0){ break; }
  5398.         }
  5399.         $outprice = $outprice + $adminFee;
  5400.         $outprice = $outprice * (1 - ($discount / 100));
  5401.         $outprice = number_format($outprice, 2, ',','.'). " €"; 
  5402.         
  5403.         return new Response($outprice);
  5404.     }
  5406.     /**
  5407.      * @Route("/calcDaysBackend" , name="calcDaysBackend", options={"expose"=true})
  5408.      */
  5409.     public function calcDaysBackend()
  5410.     {
  5411.         require_once("./include/function.php");
  5412.         
  5413.         $mon = $_POST['mon'];
  5414.         $tue = $_POST['tue'];
  5415.         $wed = $_POST['wed'];
  5416.         $thu = $_POST['thu'];
  5417.         $fri = $_POST['fri'];
  5418.         $sat = $_POST['sat'];
  5419.         $sun = $_POST['sun'];
  5420.         $from = $_POST['from'] ;
  5421.         $to = date("Y-m-d",strtotime('+1 day',strtotime($_POST['to'])));
  5422.         
  5423.         $begin = new \DateTime(date("Y-m-d",strtotime($from)));
  5424.         $endDate = new \DateTime(date('Y-m-d',strtotime($to)));
  5425.         
  5426.         $interval = \DateInterval::createFromDateString('1 day');
  5427.         $period = new \DatePeriod($begin, $interval, $endDate);
  5429.         $i = 0;
  5431.         //each day from start to activeUntill
  5432.         foreach ($period as $dt) 
  5433.         {
  5434.             $day1 = $dt->format("Y-m-d \n"); 
  5435.             $day = new \DateTime(date("Y-m-d", strtotime($day1)));
  5436.             
  5437.             if($this->checkHoliday($dt->format("d.m.Y")) != false ){ continue; }
  5438.             if(date('w', strtotime($dt->format("d.m.Y"))) == 0 && $sun == 0) {continue; }
  5439.             if(date('w', strtotime($dt->format("d.m.Y"))) == 1 && $mon == 0) {continue; }
  5440.             if(date('w', strtotime($dt->format("d.m.Y"))) == 2 && $tue == 0) {continue; }
  5441.             if(date('w', strtotime($dt->format("d.m.Y"))) == 3 && $wed == 0) {continue; }
  5442.             if(date('w', strtotime($dt->format("d.m.Y"))) == 4 && $thu == 0) {continue; }
  5443.             if(date('w', strtotime($dt->format("d.m.Y"))) == 5 && $fri == 0) {continue; }
  5444.             if(date('w', strtotime($dt->format("d.m.Y"))) == 6 && $sat == 0) {continue; }
  5445.             $i++;    
  5446.         }            
  5448.         return new Response($i);
  5449.     }
  5450.    
  5451.     /**
  5452.      * @Route("/backendTrainerPayment/{id}", name="backendTrainerPayment")
  5453.      */
  5454.     public function backendTrainerPayment($id)
  5455.     {
  5456.         if($this->get('security.token_storage')->getToken()->getUser() == 'anon.')
  5457.         {
  5458.             $response = $this->forward('App\Controller\CourseController::homepage', []);
  5459.             return $response;
  5460.         }
  5462.         require_once("./include/global.php");
  5464.         $repository = $this->getDoctrine()->getRepository(User::class);
  5465.         $trainer = $repository->findBy(['u_role' => 2]);
  5467.         $repository = $this->getDoctrine()->getRepository(TrainerPayment::class);
  5468.         $trainerPayment = $repository->findBy(['tp_cid' => $id]);
  5470.         
  5471.         $repository = $this->getDoctrine()->getRepository(Course::class);
  5472.         $course = $repository->findOneBy(['id' => $id]);
  5475.         return $this->render('backend/course/trainer_payment.html.twig', ['id' => $id,'course' => $course,  'trainer' => $trainer, 'payment' => $trainerPayment ]);
  5476.     }
  5478.         /**
  5479.     * @Route("/backendTrainerMoneySave/", name="backendTrainerMoneySave")
  5480.     */
  5481.     public function backendTrainerMoneySave(Request $request)
  5482.     {
  5483.         include("./include/global.php");
  5484.         if($this->get('security.token_storage')->getToken()->getUser() == 'anon.')
  5485.         {
  5486.             $response = $this->forward('App\Controller\CourseController::homepage', []);
  5487.             return $response;
  5488.         }
  5490.         $em = $this->getDoctrine()->getManager();
  5491.         
  5492.         $id = $request->get('id');
  5494.         $repository = $this->getDoctrine()->getRepository(TrainerPayment::class);
  5495.         $trainerPayment = $repository->findBy(['tp_cid' => $id]);
  5497.         foreach($trainerPayment as $tp)
  5498.         {
  5499.             $em->remove($tp);
  5500.             $em->flush();
  5501.         }
  5503.         $repository = $this->getDoctrine()->getRepository(User::class);
  5504.         $trainer = $repository->findBy(['u_role' => 2]);
  5506.         foreach($trainer as $train)
  5507.         {
  5508.             $name = "money_". $train->getId();
  5509.             
  5510.             $pay = $request->get($name);
  5511.             if(!$pay){$pay = 0;}
  5513.             $tp = new TrainerPayment();
  5514.             
  5515.             $tp->setTpCid($id);
  5516.             $tp->setTpPayment($pay);
  5517.             $tp->setTpUid($train->getId());
  5519.             $em->persist($tp);
  5520.             $em->flush();            
  5522.         }
  5524.         $response = $this->forward('App\Controller\CourseController::backendCourse', []);
  5525.         return $response;
  5526.     }
  5528.         /**
  5529.     * @Route("/loadResource", name="loadResource", options={"expose"=true})
  5530.     */
  5531.     public function loadResource(Request $request)
  5532.     {
  5533.         include("./include/global.php");
  5534.         if($this->get('security.token_storage')->getToken()->getUser() == 'anon.')
  5535.         {
  5536.             $response = $this->forward('App\Controller\CourseController::homepage', []);
  5537.             return $response;
  5538.         }
  5539.         $room = $_POST['room'];
  5540.         $output = "";
  5541.         $repository = $this->getDoctrine()->getRepository(Resource::class);
  5542.         $resource = $repository->findAll();
  5543.         foreach($resource as $res)
  5544.         {
  5545.             if($res->getId() == $room)
  5546.             {
  5547.                 $output .= '<option value="'.$res->getId().'" selected>'.$res->getRName().'</option>';    
  5548.             }
  5549.             else
  5550.             {
  5551.                 $output .= '<option value="'.$res->getId().'">'.$res->getRName().'</option>';    
  5552.             }
  5553.         }
  5554.         return new Response($output);
  5555.     }
  5556.     
  5557.     /**
  5558.     * @Route("/getTrainer", name="getTrainer", options={"expose"=true})
  5559.     */
  5560.     public function getTrainer(Request $request)
  5561.     {
  5562.         include("./include/global.php");
  5563.         if($this->get('security.token_storage')->getToken()->getUser() == 'anon.')
  5564.         {
  5565.             $response = $this->forward('App\Controller\CourseController::homepage', []);
  5566.             return $response;
  5567.         }
  5568.         $times = $_POST['times'];
  5569.         $leader = $_POST['leader'];
  5570.         $output = "";
  5571.         $output .= '<select id="courseleader'.$times.'" name="courseleader'.$times.'" class="form-control">';
  5572.         if($leader == "" || $leader == "0")
  5573.         {
  5574.            $output .= '<option value="0" selected>-</option>';
  5575.         }
  5576.         else{
  5577.             $output .= '<option value="0">-</option>';
  5578.         }
  5579.         
  5580.         $repository = $this->getDoctrine()->getRepository(User::class);
  5581.         $user = $repository->findby(['u_role' => '2']);
  5582.         foreach($user as $u)
  5583.         {
  5584.             if($leader == $u->getId() )
  5585.             {
  5586.                 $output .= '<option value="'.$u->getId().'" selected>'.$u->getULastname().', '.$u->getUFirstname().'</option>';    
  5587.             }
  5588.             else{
  5589.                 $output .= '<option value="'.$u->getId().'">'.$u->getULastname().', '.$u->getUFirstname().'</option>';    
  5590.             }
  5591.         }
  5592.         $output .= '</select>';
  5593.         return new Response($output);
  5594.     }
  5597.     /**
  5598.     * @Route("/saveBackendCourseSearch/", name="saveBackendCourseSearch", options={"expose"=true})
  5599.     */
  5600.     public function saveBackendCourseSearch(AuthenticationUtils $authenticationUtils): Response
  5601.     {
  5602.         require_once("./include/function.php");
  5603.         require_once("./include/global.php");
  5605.         if($this->get('security.token_storage')->getToken()->getUser() == 'anon.')
  5606.         {
  5607.             $response = $this->redirect($url ."login");
  5608.             return $response;
  5609.         }
  5610.         else
  5611.         {
  5612.             $session = $this->requestStack->getSession(); //$session = $this->get('session');
  5613.             
  5614.             $session->set('backendCourseSearch',$_POST['search']);
  5615.             $session->set('backendCoursePeriod',$_POST['period']);
  5619.             $output = "";
  5620.             return new Response($output);
  5621.         }
  5622.     }
  5624.     /**
  5625.     * @Route("/loadBackendCourseSearch/", name="loadBackendCourseSearch", options={"expose"=true})
  5626.     */
  5627.     public function loadBackendCourseSearch(AuthenticationUtils $authenticationUtils): Response
  5628.     {
  5629.         require_once("./include/function.php");
  5630.         require_once("./include/global.php");
  5632.         if($this->get('security.token_storage')->getToken()->getUser() == 'anon.')
  5633.         {
  5634.             $response = $this->redirect($url ."login");
  5635.             return $response;
  5636.         }
  5637.         else
  5638.         {
  5639.             $session = $this->requestStack->getSession(); //$session = $this->get('session');
  5640.             
  5641.             $output = "";
  5643.             $output .= $session->get('backendCourseSearch');
  5644.             $output .= '###'.$session->get('backendCoursePeriod');
  5646.             return new Response($output);
  5647.         }
  5648.     }
  5650.     /**
  5651.     * @Route("/checkCoursenumber/", name="checkCoursenumber", options={"expose"=true})
  5652.     */
  5653.     public function checkCoursenumber(AuthenticationUtils $authenticationUtils): Response
  5654.     {
  5655.         require_once("./include/function.php");
  5656.         require_once("./include/global.php");
  5658.         if($this->get('security.token_storage')->getToken()->getUser() == 'anon.')
  5659.         {
  5660.             $response = $this->redirect($url ."login");
  5661.             return $response;
  5662.         }
  5663.         else
  5664.         {
  5665.             $courseid = $_POST['courseid'];
  5666.             $number = $_POST['number'];
  5668.             $repository = $this->getDoctrine()->getRepository(CourseTimes::class);
  5669.             $ctt = $repository->findOneBy(['ctt_number' => $number]);
  5670.             if($ctt)
  5671.             {
  5672.                 if($courseid == '0')
  5673.                 {
  5674.                     // same number as existing course
  5675.                     $output = "nok";
  5676.                 }
  5677.                 else
  5678.                 {
  5679.                     if($courseid == $ctt->getCttCid())
  5680.                     {
  5681.                         $output = "ok";
  5682.                     }
  5683.                     else
  5684.                     {
  5685.                         $output = "nok";
  5686.                     }
  5687.                 }
  5688.             }
  5689.             else
  5690.             {   
  5691.                 $output = "ok";
  5692.             }
  5695.             return new Response($output);
  5696.         }
  5697.     }
  5702. }