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

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