src/StartPlatz/Bundle/EventBundle/Controller/EventPublicController.php line 82

Open in your IDE?
  1. <?php declare(strict_types=1);
  3. namespace App\StartPlatz\Bundle\EventBundle\Controller;
  5. use App\StartPlatz\Bundle\EventBundle\Entity\Event;
  6. use App\StartPlatz\Bundle\EventBundle\Entity\EventRepository;
  7. use App\StartPlatz\Bundle\EventBundle\Model\EventBaseRepository;
  8. use App\StartPlatz\Bundle\EventBundle\Model\EventCommonRepository;
  9. use App\StartPlatz\Bundle\EventBundle\Service\EventViewHelper;
  10. use App\StartPlatz\Bundle\MetaBundle\Entity\Tag;
  11. use App\StartPlatz\Bundle\StartupBundle\Entity\Application;
  12. use App\StartPlatz\Bundle\StartupBundle\Entity\Batch;
  13. use App\StartPlatz\Bundle\WebsiteBundle\MenuTranslationService;
  14. use Doctrine\ORM\EntityManagerInterface;
  15. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  16. use Symfony\Component\Form\Extension\Core\Type\HiddenType;
  17. use Symfony\Component\Form\Extension\Core\Type\SubmitType;
  18. use Symfony\Component\Form\Extension\Core\Type\TextareaType;
  19. use Symfony\Component\Form\Extension\Core\Type\TextType;
  20. use Symfony\Component\Form\FormFactoryInterface;
  21. use Symfony\Component\HttpFoundation\Request;
  22. use Symfony\Component\HttpFoundation\Response;
  23. use Symfony\Component\Routing\Annotation\Route;
  25. class EventPublicController extends AbstractController
  26. {
  27.     public function __construct(
  28.         private readonly EntityManagerInterface $entityManager,
  29.         private readonly EventCommonRepository $eventCommonRepository,
  30.         private readonly EventBaseRepository $eventBaseRepository,
  31.         private readonly MenuTranslationService $menuTranslationService,
  32.         private readonly FormFactoryInterface $formFactory,
  33.         private readonly EventViewHelper $eventViewHelper,
  34.     ) {
  35.     }
  37.     /**
  38.      */
  39.     public function showEventsAction($time = "upcoming", $term='', $title="", $text = '')
  40.     {
  41.         // sanitize variable from wordPress
  42.         $time = str_replace('&#8220;', '', (string) $time);
  43.         $term = str_replace('&#8220;', '', (string) $term);
  44.         $title = str_replace('&#8220;', '', (string) $title);
  45.         $text = str_replace('&#8220;', '', (string) $text);
  47.         $terms = explode('#', $term);
  49.         $events = $this->entityManager->getRepository(Event::class)->findPublicByTerms($terms, [], ($time == 'upcoming') ? 'future' : 'past');
  51.         return $this->render('@StartPlatzEventBundle/Default/show_events.html.twig', [
  52.             'events' => $events,
  53.             'title'  => $title,
  54.             'templateVars' => [],
  55.             'term' => $term,
  56.             'text'=>$text,
  57.         ]);
  58.     }
  60.     /**
  61.      */
  62.     public function showFutureEventsAction($term = 'startup', $variant = 'default')
  63.     {
  65.         $term = ltrim((string) $term, '#');
  66.         $events = $this->entityManager->getRepository(Event::class)->findPublicEventsByTerm($term);
  68.         $view = '@StartPlatzEventBundle/Default/show_future_events.html.twig';
  69.         if ($variant == 'black-rows') {
  70.             $view = '@StartPlatzEventBundle/Default/show_future_events.black-rows.html.twig';
  71.         }
  73.         return $this->render($view, [
  74.             'events' => $events,
  75.             'term'   => $term,
  76.             'templateVars' => [],
  77.         ]);
  78.     }
  80.     /**
  81.      */
  82.     public function showNextEventsAction(Request $request, $limit = 3)
  83.     {
  84.         $events = $this->entityManager->getRepository(Event::class)->findNextEvents($limit);
  86.         return $this->render('@StartPlatzEventBundle/Default/show_next_events.html.twig', [
  87.             'events' => $events,
  88.             'templateVars' => [],
  89.             'lang' =>  $this->menuTranslationService->getLang($request->server->get('REDIRECT_URL')),
  90.         ]);
  91.     }
  93.     /**
  94.      */
  95.     public function showListGroupEventsAction(Request $request, $limit = 15)
  96.     {
  97.         $events = $this->entityManager->getRepository(Event::class)->findNextEvents($limit);
  99.         return $this->render('@StartPlatzEvent/Default/show_list_group_events.html.twig', [
  100.             'events' => $events,
  101.             'templateVars' => [],
  102.             'lang' =>  $this->menuTranslationService->getLang($request->server->get('REDIRECT_URL')),
  103.         ]);
  104.     }
  106.     /**
  107.      */
  108.     public function showPastEventsAction($term)
  109.     {
  110.         $events = $this->entityManager->getRepository(Event::class)->findPastPublicEventsByTerm($term);
  111.         return $this->render('@StartPlatzEventBundle/Default/show_past_events.html.twig', [
  112.             'events' => $events,
  113.             'term' => $term,
  114.             'templateVars' => [],
  115.         ]);
  116.     }
  120.     #[Route('/events', name: 'events_list')]
  121.     #[Route('/en/events', name: 'events_list_english')]
  122.     #[Route('/fr/evenements', name: 'events_list_french')]
  123.     #[Route('/events/bevorstehend/')]
  124.     #[Route('/events/list')]
  125.     #[Route('/en/events/list')]
  126.     #[Route('/fr/evenements/list')]
  127.     #[Route('/events/embed/list')]
  128.     #[Route('/en/events/embed/list')]
  129.     #[Route('/fr/evenements/embed/list')]
  130.     public function eventsAction(Request $request)
  131.     {
  132.         $templateVars = $this->eventCommonRepository->getStartPlatzEventBaseTemplateVars($request);
  133.         $em = $this->entityManager;
  135.         // Get the current path
  136.         $path = $request->getPathInfo();
  138.         // Check if the path starts with '/en/' or '/fr/'
  139.         if (strpos($path, '/en/') === 0) {
  140.             $lang = 'EN';
  141.         } elseif (strpos($path, '/fr/') === 0) {
  142.             $lang = 'FR';
  143.         } else {
  144.             $lang = 'DE';
  145.         }
  147.         // Check if the path contains  '/en/'
  148.         $embed = false;
  149.         if (str_contains($path, '/embed/') ) {
  150.             $embed = true;
  151.         }
  153.         // Fetch u tags
  154.         $uTags = $em->getRepository(Tag::class)->findBy(['domain' => 'event', 'isEditableByUser' => 1], ['tag' => 'ASC']);
  156.         // Convert to key-value array
  157.         $uTagsArray = array_map(function (Tag $entity) {
  158.             return [
  159.                 'tag' => $entity->getTag(),  // Dies entspricht dem 'slug' in deiner URL-Struktur
  160.                 'label' => $entity->getLabel()
  161.             ];
  162.         }, $uTags);
  164.         // Fetch w tags
  165.         $wTags = $em->getRepository(Tag::class)->findBy(['domain' => 'event', 'isUsedInWordPress' => 1], ['tag' => 'ASC']);
  167.         // Convert to key-value array
  168.         $wTagsArray = array_map(function (Tag $entity) {
  169.             return [
  170.                 'tag' => $entity->getTag(),  // Dies entspricht dem 'slug' in deiner URL-Struktur
  171.                 'label' => $entity->getLabel()
  172.             ];
  173.         }, $wTags);
  175.         $additionalEvents = [];
  176.         $queryString = '';
  178.         // Check for location filter first (location-based filtering)
  179.         if (isset($templateVars['location']) and $location = $templateVars['location']) {
  180.             $futureEvents = $this->entityManager->getRepository(Event::class)->findPublicByLocationWithBatches($location, $this->eventCommonRepository->setBaseCriteria($templateVars), 'future');
  181.             $pastEvents   = $this->entityManager->getRepository(Event::class)->findPublicByLocationWithBatches($location, $this->eventCommonRepository->setBaseCriteria($templateVars), 'past');
  182.             $moreFutureEvents = $this->eventBaseRepository->countFutureEvents($this->eventCommonRepository->setBaseCriteria($templateVars));
  183.         }
  184.         // Check for tag filter (tag-based filtering)
  185.         elseif (isset($templateVars['tag']) and $tag = $templateVars['tag']) {
  186.             $futureEvents = $this->entityManager->getRepository(Event::class)->findPublicByTagWithBatches('#' . $tag, $this->eventCommonRepository->setBaseCriteria($templateVars), 'future');
  187. /*
  188.  * falls einer der zielgruppen tags == uTags gewählt ist
  189.  * dann hole auch die events für alle fTags und startplatz-ai-hub
  190.  */
  192. // Extrahiere alle 'tag' Werte aus dem $uTagsArray
  193.             $uTagsSlugs = array_column($uTagsArray, 'tag');
  195. // Überprüfe, ob der gewählte $tag in den $uTagsSlugs enthalten ist
  196.             $isUTag = in_array($tag, $uTagsSlugs);
  199.             if ($isUTag) {
  200.                 // Fetch f tags
  201.                 $fTags = $em->getRepository(Tag::class)->findBy(['domain' => 'event', 'isFavorite' => 1], ['tag' => 'ASC']);
  203.                 // Extract just the tags to a simple array
  204.                 $fTagsList = array_map(function (Tag $entity) {
  205.                     return $entity->getTag(); // Dies gibt nur den 'tag' zurück
  206.                 }, $fTags);
  207.                 $additionalEvents = $this->entityManager->getRepository(Event::class)->findPublicByTagsExcludingTag($fTagsList, '#' . $tag, $this->eventCommonRepository->setBaseCriteria($templateVars), 'future');
  208.             }
  209.             $pastEvents   = $this->entityManager->getRepository(Event::class)->findPublicByTagWithBatches('#' . $tag, $this->eventCommonRepository->setBaseCriteria($templateVars), 'past');
  210.             $moreFutureEvents = $this->eventBaseRepository->countFutureEvents($this->eventCommonRepository->setBaseCriteria($templateVars));
  211.         }
  212.         // No filter - show all events
  213.         else {
  214.             $futureEvents = $this->entityManager->getRepository(Event::class)->findPublicByWithBatches($queryString, $this->eventCommonRepository->setBaseCriteria($templateVars), 'future');
  215.             $moreFutureEvents = $this->eventBaseRepository->countFutureEvents($this->eventCommonRepository->setBaseCriteria($templateVars));
  216.             $pastEvents   = $this->entityManager->getRepository(Event::class)->findPublicByWithBatches($queryString, $this->eventCommonRepository->setBaseCriteria($templateVars), 'past');
  217.         }
  219.         if ($request->get('format') === 'json') {
  220.             $events = [];
  222.             foreach ($futureEvents as $event) {
  223.                 $events[] = $event->toArray();
  224.             }
  226.             return Response::create(
  227.                 json_encode($events),
  228.                 200,
  229.                 [
  230.                     'Content-Type' => 'application/json',
  231.                     'Access-Control-Allow-Origin' => '*',
  232.                 ]
  233.             );
  234.         }
  236.         $targetPath = $request->server->get('REDIRECT_URL');
  239.         if ($this->getUser()) {
  240.             if (!$email = $this->getUser()->getEmail()) {
  241.                 $email = null;
  242.             }
  243.         } else {
  244.             $email = null;
  245.         }
  246.         $form = $this->setFeedbackForm($targetPath, $this->generateUrl('feedback_translation'), $email);
  248.         $eventTypes = $em->getRepository(Tag::class)->findBy(['domain'=>'event', 'isThema'=>1], ['tag'=>'ASC']);
  250.         $eventTypesTags   = array_map(fn (Tag $entity) => $entity->getTag(), $eventTypes);
  251.         $eventTypesLabels = array_map(fn (Tag $entity) => $entity->getLabel(), $eventTypes);
  252.         $eventTypesTagLabel = array_combine($eventTypesTags, $eventTypesLabels);
  254.         // Fetch popular tags
  255.         $popularTags = $em->getRepository(Tag::class)->findBy(['domain' => 'event', 'isModul' => 1], ['tag' => 'ASC']);
  257.         // Convert to key-value array
  258.         $popularTagsArray = array_map(function (Tag $entity) {
  259.             return [
  260.                 'tag' => $entity->getTag(),  // Dies entspricht dem 'slug' in deiner URL-Struktur
  261.                 'label' => $entity->getLabel()
  262.             ];
  263.         }, $popularTags);
  267.         $view = '@StartPlatzEventBundle/Default/events.html.twig';
  268.         if ($embed){
  269.             $view = '@StartPlatzEventBundle/Default/events-embed.html.twig';
  270.         }
  271.         return $this->render($view, [
  272.             'templateVars' => $templateVars,
  273.             'lang'           => $lang,
  274.             'embed'          => $embed,
  275.             'nextConference' => $this->entityManager->getRepository(Event::class)->findNextPublicBy("Konferenz"),
  276.             'nextWorkshop'   => $this->entityManager->getRepository(Event::class)->findNextPublicBy("Workshop"),
  277.             'futureEvents'   => $futureEvents,
  278.             'pastEvents'     => $pastEvents,
  279.             'events'         => $this->entityManager->getRepository(Event::class)->findNextEvents(100),
  280.             'moreFutureEvents' => $moreFutureEvents,
  281.             'additionalEvents' => $additionalEvents,
  282.             'eventArten'         => $eventTypes,
  283.             'eventTypesTagLabel' => $eventTypesTagLabel,
  284.             'popularTagsArray'   => $popularTagsArray,
  285.             'uTagsArray'         => $uTagsArray,
  286.             'wTagsArray'         => $wTagsArray,
  287.             'form'           => $form->createView(),
  288.         ]);
  289.     }
  291.     #[Route('/event-series/{seriesTag}', name: 'event_series')]
  292.     public function eventSeriesAction($seriesTag, Request $request )
  293.     {
  294.         $templateVars = $this->eventCommonRepository->getStartPlatzEventBaseTemplateVars($request);
  295.         $em = $this->entityManager;
  296.         $eventRepo = $em->getRepository(Event::class);
  297.         $batchRepo = $em->getRepository(Batch::class);
  299.         // Retrieve the UTM parameters from the URL
  300.         $utmParameters = [
  301.             'utmSource'   => $request->query->get('utm_source'),
  302.             'utmMedium'   => $request->query->get('utm_medium'),
  303.             'utmCampaign' => $request->query->get('utm_campaign'),
  304.             'utmTerm'     => $request->query->get('utm_term'),
  305.             'utmContent'  => $request->query->get('utm_content'),
  306.         ];
  308.         // Fetch data related to the event series using $seriesName
  309.         // For example, using a repository method:
  310.         $nextEvent = $eventRepo->findNextEventInSeries($seriesTag, new \DateTime());
  312.         // Check if the result is null (no future events)
  313.         if ($nextEvent === null) {
  314.             // Fetch the most recent past event in the series
  315.             $nextEvent = $eventRepo->findMostRecentPastEventInSeries($seriesTag, new \DateTime());
  316.         }
  318.         // Initialize variables with default values
  319.         $noEventsAvailable = false; // Default to false, indicating events are available
  320.         $alternativeContent = ''; // Default empty string or a default alternative message
  321.         $nextBatch = null;
  322.         $futureEventsData = [];
  323.         $pastEventsData = [];
  325.         // Proceed only if there is an event (either upcoming or past)
  326.         if ($nextEvent !== null) {
  327.             // Fetch all future events in the series, excluding the $nextEvent
  328.             $futureEvents = $eventRepo->findAllFutureEventsExcluding($seriesTag, $nextEvent->getId());
  330.             // Fetch all past events in the series, excluding the $nextEvent
  331.             $pastEvents = $eventRepo->findAllPastEventsExcluding($seriesTag, $nextEvent->getId());
  333.             // If the main event is multi-batch, get the next batch
  334.             if ($nextEvent->isMultiBatchEvent()) {
  335.                 $nextBatch = $batchRepo->findNextOpenBatchByEvent($nextEvent);
  336.             }
  338.             // Get batch data for future and past events
  339.             $futureBatches = $eventRepo->findAllFutureBatchesInSeries($seriesTag, $nextEvent->getId());
  340.             $pastBatches = $eventRepo->findAllPastBatchesInSeries($seriesTag, $nextEvent->getId());
  342.             // Merge events and batches data for display
  343.             $futureEventsData = $this->mergeEventsAndBatches($futureEvents, $futureBatches);
  344.             $pastEventsData = $this->mergeEventsAndBatches($pastEvents, $pastBatches);
  345.         } else {
  346.             // No events are available, display alternative content or a message
  347.             $noEventsAvailable = true;
  348.             $alternativeContent = "Sorry, there are no events available for this series.";
  349.             $nextEvent = new Event();
  350.             $futureEvents = [];
  351.             $pastEvents = [];
  352.             // $alternativeContent can also be fetched from a repository if needed
  353.         }
  358.         return $this->render('@StartPlatzEventBundle/Default/event-series.html.twig', [
  359.             'event'             => $nextEvent,
  360.             'nextEvent'         => $nextEvent,          // The next or most recent event
  361.             'nextBatch'         => $nextBatch,          // The next batch for multi-batch events
  362.             'futureEvents'      => $futureEvents,    // Collection of future events, excluding $nextEvent
  363.             'pastEvents'        => $pastEvents,        // Collection of past events, excluding $nextEvent
  364.             'futureEventsData'  => $futureEventsData,  // Combined events and batches data for future
  365.             'pastEventsData'    => $pastEventsData,    // Combined events and batches data for past
  366.             'noEventsAvailable' => $noEventsAvailable,  // Flag for no events availability
  367.             'alternativeContent' => $alternativeContent, // Alternative content when no events are available
  368.             'utmParameters'     => $utmParameters,
  370.             'showTeaser'         => $nextEvent->getTeaser() > '',
  371.             'batch'              => $nextBatch ?: new Batch(),
  372.             'application'        => new Application(),
  373.             'batchIsOpen'        => $nextBatch ? true : false,
  374.             'seriesEvents'       => $futureEvents,
  375.             'promotionUrl'       => "/event-series/{$seriesTag}",
  376.             'templateVars'       => $this->eventCommonRepository->getStartPlatzEventBaseTemplateVars($request),
  378.             'speakers'           => $this->eventViewHelper->getSpeakers($nextEvent),
  379.             'lang' => $lang ?? "DE",  // Default to "DE" if $lang is not set
  380.         ]);
  382.     }
  384.     /**
  385.      * Merge events and batches data for display in series pages
  386.      * Combines single-batch events with multi-batch event batches
  387.      *
  388.      * @param array $events Array of Event entities
  389.      * @param array $batches Array of batch data from raw SQL query
  390.      * @return array Combined and sorted data
  391.      */
  392.     private function mergeEventsAndBatches(array $events, array $batches): array
  393.     {
  394.         $merged = [];
  396.         // Add single-batch events
  397.         foreach ($events as $event) {
  398.             if (!$event->isMultiBatchEvent()) {
  399.                 $merged[] = [
  400.                     'type' => 'event',
  401.                     'event' => $event,
  402.                     'date' => $event->getStartDate(),
  403.                     'endDate' => $event->getEndDate(),
  404.                     'title' => $event->getTitle(),
  405.                     'location' => $event->getLocation(),
  406.                     'slug' => $event->getSlug(),
  407.                     'trainer' => $event->getTrainer()
  408.                 ];
  409.             }
  410.         }
  412.         // Add batches (which are from multi-batch events)
  413.         foreach ($batches as $batch) {
  414.             $merged[] = [
  415.                 'type' => 'batch',
  416.                 'batch_id' => $batch['batch_id'],
  417.                 'event_id' => $batch['event_id'],
  418.                 'date' => new \DateTime($batch['batch_date']),
  419.                 'title' => $batch['event_title'],
  420.                 'batch_name' => $batch['batch_name'],
  421.                 'location' => $batch['location'],
  422.                 'event_slug' => $batch['event_slug'],
  423.                 'batch_slug' => $batch['batch_slug'],
  424.                 'trainer' => $batch['trainer']
  425.             ];
  426.         }
  428.         // Sort by date
  429.         usort($merged, function($a, $b) {
  430.             return $a['date'] <=> $b['date'];
  431.         });
  433.         return $merged;
  434.     }
  438.     private function setFeedbackForm ( $targetPath, $actionPath, $email = NULL ) {
  439.         return $this->formFactory->createNamedBuilder( 'feedback' )
  440.             ->setAction( $actionPath )
  441.             ->add('targetPath', HiddenType::class, array( 'data' => $targetPath, ) )
  442.             ->add('email', TextType::class,  array( 'data' => $email, 'label' => '-', 'required' => false))
  443.             ->add('note', TextareaType::class, array( 'label' => '-', 'required' => true))
  444.             ->add('save', SubmitType::class,array('label'=>'Save'))
  445.             ->getForm();
  446.     }
  448.     #[Route('/events/list/month/{year}/{month}', name: 'events_list_month')]
  449.     public function listMonthAction($year, $month, Request $request)
  450.     {
  451.         $templateVars = $this->eventCommonRepository->getStartPlatzEventBaseTemplateVars($request);
  453.         if (!isset($templateVars['tag'])) {
  454.             $templateVars['tag'] = '';
  455.         }
  456.         $queryString = '';
  457.         if (isset($templateVars['tag']) and $tag = $templateVars['tag']) {
  458.             $events = $this->eventBaseRepository->getEventsByMonth($this->eventCommonRepository->setBaseCriteria($templateVars), $year, $month);
  459.         } else {
  460.             $events = $this->eventBaseRepository->getEventsByMonth($this->eventCommonRepository->setBaseCriteria($templateVars), $year, $month);
  461.         }
  463.         $targetPath = $request->server->get('REDIRECT_URL');
  464.         $lang = $this->menuTranslationService->getLang($targetPath);
  466.         $menuLinksDe2En = $this->menuTranslationService->getMenuLinksSwitcher();
  468.         return $this->render('@StartPlatzEventBundle/Default/list_month.html.twig', [
  469.             'templateVars' => $templateVars,
  470.             'events' => $events,
  471.             'month' => $month,
  472.             'year' => $year,
  473.             'targetPath'      => $targetPath,
  474.             'moreFutureEvents' => $this->eventBaseRepository->countFutureEvents($this->eventCommonRepository->setBaseCriteria($templateVars)),
  475.             'menuLinksDe2En' => $menuLinksDe2En,
  476.             'menuLinksEn2De' => array_flip($menuLinksDe2En) ,
  477.             'menuPhrases'    => $this->menuTranslationService->getMenuPhrases($lang),
  478.             'menuLinks'      => $this->menuTranslationService->getMenuLinks($lang),
  479.             'footerPhrases'  => $this->menuTranslationService->getFooterPhrases($lang),
  480.             'footerLinks'    => $this->menuTranslationService->getFooterLinks($lang),
  481.             'lang'           => $lang,
  482.         ]);
  483.     }
  485.     /** redirecting routes */
  487.     #[Route('/event/corporate-services-event/')]
  488.     public function eventRedirectAction()
  489.     {
  490.         return $this->redirect($this->generateUrl('event_show_single', ['slug' => 'best-practice-digitalisierung']));
  491.     }
  493.     ### section signup starts here ###
  494.     #[Route('/ai-summer-school-single-ticket', name: 'ai-summer-school-single-ticket')]
  495.     public function aisummerschoolSingleTicketAction(Request $request)
  496.     {
  497.         $lang = 'DE';
  498.         if ($targetPath = $request->server->get('REDIRECT_URL')) {
  499.             $lang = $this->menuTranslationService->getLang($targetPath);
  500.         }
  501.         return $this->render('@StartPlatzEventBundle/Default/ai-summer-school-single-ticket.html.twig', [
  502.             'lang'            => $lang,
  503.         ]);
  504.     }
  506.     #[Route('/ai-summer-school-firmen-pakete', name: 'ai-summer-school-firmen-pakete')]
  507.     public function aisummerschoolFirmenPaketeAction(Request $request)
  508.     {
  509.         $lang = 'DE';
  510.         if ($targetPath = $request->server->get('REDIRECT_URL')) {
  511.             $lang = $this->menuTranslationService->getLang($targetPath);
  512.         }
  513.         return $this->render('@StartPlatzEventBundle/Default/ai-summer-school-firmen-pakete.html.twig', [
  514.             'lang'            => $lang,
  515.         ]);
  516.     }
  517.     #[Route('/ai-summer-school-stipendien', name: 'ai-summer-school-stipendien')]
  518.     public function aisummerschoolStipendienAction(Request $request)
  519.     {
  520.         $lang = 'DE';
  521.         if ($targetPath = $request->server->get('REDIRECT_URL')) {
  522.             $lang = $this->menuTranslationService->getLang($targetPath);
  523.         }
  524.         return $this->render('@StartPlatzEventBundle/Default/ai-summer-school-stipendien.html.twig', [
  525.             'lang'            => $lang,
  526.         ]);
  527.     }
  528.     #[Route('/ai-summer-school-volunteers', name: 'ai-summer-school-volunteers')]
  529.     public function aisummerschoolVolunteersAction(Request $request)
  530.     {
  531.         $lang = 'DE';
  532.         if ($targetPath = $request->server->get('REDIRECT_URL')) {
  533.             $lang = $this->menuTranslationService->getLang($targetPath);
  534.         }
  535.         return $this->render('@StartPlatzEventBundle/Default/ai-summer-school-volunteers.html.twig', [
  536.             'lang'            => $lang,
  537.         ]);
  538.     }
  540.     #[Route('/ai-summer-school-sponsoring', name: 'ai-summer-school-sponsoring')]
  541.     public function aisummerschoolSponsoringAction(Request $request)
  542.     {
  543.         $lang = 'DE';
  544.         if ($targetPath = $request->server->get('REDIRECT_URL')) {
  545.             $lang = $this->menuTranslationService->getLang($targetPath);
  546.         }
  547.         return $this->render('@StartPlatzEventBundle/Default/ai-summer-school-sponsoring.html.twig', [
  548.             'lang'            => $lang,
  549.         ]);
  550.     }
  552.     #[Route('/archiv/event/{slug}/', name: 'event_archiv_show')]
  553.     public function showAction(Request $request, $slug)
  554.     {
  555.         if ($slug == '22-rheinland-pitch-mai-2015-2015-04-27-1430300112') {
  556.             return $this->redirect($this->generateUrl('event_archiv_show', ['slug' => '23-rheinland-pitch-juni-2015-finale-duesseldorf']));
  557.         }
  558.         if ($slug == 'rheinland-pitch') {
  559.             return $this->redirect($this->generateUrl('event_archiv_show', ['slug' => '01-rheinland-pitch-april-2013']));
  560.         }
  561.         if ($slug == 'rheinland-pitch-mai') {
  562.             return $this->redirect($this->generateUrl('event_archiv_show', ['slug' => '02-rheinland-pitch-mai-2013']));
  563.         }
  564.         if ($slug == 'rheinland-pitch-juni') {
  565.             return $this->redirect($this->generateUrl('event_archiv_show', ['slug' => '03-rheinland-pitch-juni-2013']));
  566.         }
  567.         if ($slug == 'rheinland-pitch-august') {
  568.             return $this->redirect($this->generateUrl('event_archiv_show', ['slug' => '05-rheinland-pitch-august-2013']));
  569.         }
  570.         if ($slug == 'rheinland-pitch-september') {
  571.             return $this->redirect($this->generateUrl('event_archiv_show', ['slug' => '06-rheinland-pitch-september-2013']));
  572.         }
  573.         if ($slug == 'rheinland-pitch-oktober') {
  574.             return $this->redirect($this->generateUrl('event_archiv_show', ['slug' => '07-rheinland-pitch-oktober-2013']));
  575.         }
  576.         if ($slug == 'rheinland-pitch-november') {
  577.             return $this->redirect($this->generateUrl('event_archiv_show', ['slug' => '08-rheinland-pitch-november-2013']));
  578.         }
  579.         if ($slug == 'rheinland-pitch-januar') {
  580.             return $this->redirect($this->generateUrl('event_archiv_show', ['slug' => '09-rheinland-pitch-januar-2014']));
  581.         }
  582.         if ($slug == 'rheinland-pitch-februar') {
  583.             return $this->redirect($this->generateUrl('event_archiv_show', ['slug' => '10-rheinland-pitch-februar-2014']));
  584.         }
  585.         if ($slug == 'rheinland-pitch-marz') {
  586.             return $this->redirect($this->generateUrl('event_archiv_show', ['slug' => '11-rheinland-pitch-maerz-2014']));
  587.         }
  588.         if ($slug == 'rheinland-pitch-april') {
  589.             return $this->redirect($this->generateUrl('event_archiv_show', ['slug' => '12-rheinland-pitch-april-2014']));
  590.         }
  591.         if ($slug == 'rheinland-pitch-mai-3') {
  592.             return $this->redirect($this->generateUrl('event_archiv_show', ['slug' => '13-rheinland-pitch-mai-2014']));
  593.         }
  594.         if ($slug == 'rheinland-pitch-juni-2') {
  595.             return $this->redirect($this->generateUrl('event_archiv_show', ['slug' => '14-rheinland-pitch-juni-2014']));
  596.         }
  597.         if ($slug == '22-rheinland-pitch-mai-2015-2015-04-27') {
  598.             return $this->redirect($this->generateUrl('event_archiv_show', ['slug' => '22-rheinland-pitch-mai-2015']));
  599.         }
  602.         $templateVars = $this->eventCommonRepository->getStartPlatzEventBaseTemplateVars($request);
  604.         if (!$event = $this->entityManager->getRepository(Event::class)->findOneBy(['slug' => $slug])) {
  605.             $querySlug = '/' . $slug;
  606.             if (!$event = $this->entityManager->getRepository(Event::class)->findOneBy(['slug' => $querySlug])) {
  607.                 $this->addFlash('notice', 'ERROR Veranstaltung nicht gefunden');
  608.                 return $this->redirect($this->generateUrl('events_list'));
  609.             } else {
  610.                 $em = $this->entityManager;
  611.                 $event->setSlug($slug);
  612.                 $em->persist($event);
  613.                 $em->flush();
  614.             }
  615.         }
  617.         if ($event->getStatus() != 'publish') {
  618.             if (!$this->getUser()) {
  619.                 return $this->redirect($this->generateUrl('events_list', $templateVars));
  620.             }
  621.         }
  623.         //previous @StartPlatzEventBundle/Default/show.html.twig
  625.         return $this->render('@StartPlatzEventBundle/Default/event-single.html.twig', [
  626.             'templateVars' => $templateVars,
  627.             'event'        => $event,
  629.             'batch'        => false,
  630.             'speakers'     => [],
  631.         ]);
  632.     }
  634.     /**
  635.      */
  636.     public function eventsThisWeekAction()
  637.     {
  638.         $year = date('Y');
  639.         $month = date('m');
  640.         $moreFutureEvents = $this->eventBaseRepository->getEventsByWeek($this->eventCommonRepository->setBaseCriteria([]), $year, $month);
  642.         return $this->render('@StartPlatzEventBundle/Default/events_this_week.html.twig', [
  643.             'moreFutureEvents' => $moreFutureEvents,
  644.         ]);
  646.     }
  648.     private function getRedirects()
  649.     {
  650.         return [
  651.             'Best-Practice-Digitalisierung-Januar-2018' => 'best-practice-digitalisierung',
  652.             'best-practice-digitalisierung-3' => 'best-practice-digitalisierung',
  653.             'adwords-fuer-einsteiger-' => 'adwords-fuer-einsteiger-koeln-2017-01-24',
  654.             'adwords-fur-einsteiger-'  => 'adwords-fuer-einsteiger-koeln-2016-06-06',
  655.             'adwords-fur-einsteiger-DUS' => 'adwords-fuer-einsteiger-dus-2016-06-07',
  656.             '-adwords-fuer-einsteiger' => 'adwords-fur-einsteiger',
  657.             'adwords-fur-einsteiger-2016-02-16' => 'adwords-fuer-einsteiger-koeln-2016-02-16',
  658.             'digital-networking-week-1611257320' => 'digital-networking-week',
  659.             'chatgpt3-how-to-prompt-duesseldorf' => 'chatgpt-how-to-prompt-duesseldorf'
  660.         ];
  661.     }
  665.     #[Route('/sntm', name: 'legacy_sntm_redirect')]
  666.     #[Route('/sntm/{path}', name: 'legacy_sntm_redirect_sub', requirements: ['path' => '.+'])]
  667.     public function sntmRedirectAction(): Response
  668.     {
  669.         return $this->redirect($this->generateUrl('events_list'), 301);
  670.     }
  672.     #[Route('/mg2019', name: 'legacy_mg2019_redirect')]
  673.     #[Route('/mg2019/{path}', name: 'legacy_mg2019_redirect_sub', requirements: ['path' => '.+'])]
  674.     public function mg2019RedirectAction(): Response
  675.     {
  676.         return $this->redirect($this->generateUrl('events_list'), 301);
  677.     }
  678. }