src/StartPlatz/Bundle/EventBundle/Controller/DefaultController.php line 168

Open in your IDE?
  1. <?php declare(strict_types=1);
  3. namespace App\StartPlatz\Bundle\EventBundle\Controller;
  5. /**
  6.  * CRITICAL DEPENDENCY WARNING - APPLICATION SYSTEM INTEGRATION
  7.  * 
  8.  * This controller has HEAVY DEPENDENCIES on the Application system from StartupBundle.
  9.  * Event registration is the MOST IMPORTANT registration method for events and relies
  10.  * extensively on the Application infrastructure.
  11.  * 
  12.  * DO NOT modify Application-related code without testing ALL event registration scenarios:
  13.  * - Anonymous (non-member) event registration
  14.  * - Member event registration  
  15.  * - Paid event registration with Stripe
  16.  * - Free event registration
  17.  * - Multi-batch event registration
  18.  * - Event registration with validation workflows
  19.  * 
  20.  * Critical dependencies:
  21.  * 1. Application Entity & Repository (30+ method calls)
  22.  *    - createApplicationByApplyForm()
  23.  *    - setApplication()
  24.  *    - updateApplicationByMember()
  25.  *    - setApplicationDone()
  26.  *    - cleanApplicationData()
  27.  *    - And many more...
  28.  * 
  29.  * 2. ApplicationType Form
  30.  *    - Used for all event registration forms
  31.  *    - Field definitions must remain compatible
  32.  * 
  33.  * 3. RheinlandPitchBundle Templates
  34.  *    - StartPlatzRheinlandPitchBundle/Apply/_edit.registration.event.widget.html.twig
  35.  *    - Shared validation and workflow logic
  36.  * 
  37.  * 4. Shared Workflows
  38.  *    - Email validation (validateEmail/validateLogin)
  39.  *    - Member creation and assignment
  40.  *    - Payment processing
  41.  *    - Confirmation emails
  42.  * 
  43.  * Key methods with Application dependencies:
  44.  * - eventSingleAction() - Main event page with registration
  45.  * - getOrCreateApplication() - Application creation/retrieval
  46.  * - updateApplicationWithMemberIdAndTeamId() - Member linking
  47.  * - validateEventApplication() - Validation workflows
  48.  * - setEventApplicationDone() - Completion logic
  49.  * - handleAction() - Payment and status management
  50.  * 
  51.  * See also:
  52.  * - StartupBundle/Repository/ApplicationRepository.php
  53.  * - RheinlandPitchBundle/Controller/ApplyController.php
  54.  * - Documentation: /doc/claude-files/application-process.md#event-integration
  55.  */
  57. use App\StartPlatz\Bundle\AlphaBundle\Entity\Page;
  58. use App\StartPlatz\Bundle\ApiBundle\MemberHubspotService;
  59. use App\StartPlatz\Bundle\FeedbackBundle\CallbackService;
  60. use App\StartPlatz\Bundle\FeedbackBundle\Form\ImportFormType;
  61. use App\StartPlatz\Bundle\MailmanBundle\Entity\MailTemplate;
  62. use App\StartPlatz\Bundle\MemberBundle\Entity\Member;
  63. use App\StartPlatz\Bundle\MemberBundle\Entity\Option;
  64. use App\StartPlatz\Bundle\MemberBundle\Entity\Product;
  65. use App\StartPlatz\Bundle\MemberBundle\Entity\Service;
  66. use App\StartPlatz\Bundle\MemberBundle\Entity\Team;
  67. use App\StartPlatz\Bundle\MetaBundle\Entity\Attribute;
  68. use App\StartPlatz\Bundle\MetaBundle\Entity\Tag;
  69. use App\StartPlatz\Bundle\MonsumBundle\Entity\Customer;
  70. use App\StartPlatz\Bundle\StartupBundle\Entity\Application;
  71. use App\StartPlatz\Bundle\StartupBundle\Entity\Batch;
  72. use App\StartPlatz\Bundle\StartupBundle\Entity\Program;
  73. use App\StartPlatz\Bundle\StartupBundle\Form\ApplicationType;
  74. use App\StartPlatz\Bundle\StatisticBundle\Entity\Statistic;
  75. use App\StartPlatz\Bundle\UserBundle\Entity\User;
  76. use App\StartPlatz\Bundle\UserBundle\LoginService;
  77. use App\StartPlatz\Bundle\WebsiteBundle\Utility\Utility;
  78. use DateTime;
  79. use Symfony\Component\HttpFoundation\Session\SessionInterface;
  80. use Symfony\Component\Mailer\MailerInterface;
  81. use Symfony\Component\Routing\Annotation\Route;
  82. use Sensio\Bundle\FrameworkExtraBundle\Configuration\Security;
  83. use App\StartPlatz\Bundle\EventBundle\Entity\Event;
  84. use App\StartPlatz\Bundle\EventBundle\Entity\EventRepository;
  85. use App\StartPlatz\Bundle\EventBundle\Model\EventBaseRepository;
  86. use App\StartPlatz\Bundle\EventBundle\Model\EventCommonRepository;
  87. use App\StartPlatz\Bundle\WebsiteBundle\MenuTranslationService;
  88. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  89. use Symfony\Component\Form\Extension\Core\Type\HiddenType;
  90. use Symfony\Component\Form\Extension\Core\Type\SubmitType;
  91. use Symfony\Component\Form\Extension\Core\Type\TextareaType;
  92. use Symfony\Component\Form\Extension\Core\Type\TextType;
  93. use Symfony\Component\Form\FormFactoryInterface;
  94. use Symfony\Component\HttpFoundation\Request;
  95. use Symfony\Component\HttpFoundation\Response;
  96. use Symfony\Component\HttpFoundation\JsonResponse;
  97. use Symfony\Component\Routing\Generator\UrlGeneratorInterface;
  98. use Psr\Log\LoggerInterface;
  99. use App\StartPlatz\Bundle\EventBundle\Service\MailTemplateService;
  101. class DefaultController extends AbstractController
  102. {
  103.     public function __construct(
  104.         private readonly SessionInterface $session,
  105.         private readonly FormFactoryInterface $formFactory,
  106.         private readonly MenuTranslationService $menuTranslationService,
  107.         private readonly CallbackService $callbackService,
  108.         private readonly MemberHubspotService $memberHubspotService,
  109.         private readonly MailerInterface $mailer,
  110.         private readonly LoginService $loginService,
  111.         private readonly EventCommonRepository $eventCommonRepository,
  112.         private readonly UrlGeneratorInterface  $urlGenerator,
  113.         private readonly EventBaseRepository $eventBaseRepository,
  114.         private readonly LoggerInterface $logger,
  115.         private readonly MailTemplateService $mailTemplateService
  116.     ) {
  117.     }
  119.     /**
  120.      * @return EventCommonRepository
  121.      */
  122.     protected function getEventComRep()
  123.     {
  124.         return $this->eventCommonRepository;
  125.     }
  127.     /**
  128.      * @return EventBaseRepository
  129.      */
  130.     protected function getEventBaseRepository()
  131.     {
  132.         return $this->eventBaseRepository;
  133.     }
  135.     /** @return EventRepository */
  136.     protected function getEventRepository(): EventRepository
  137.     {
  138.         $em = $this->getDoctrine()->getManager();
  140.         return $em->getRepository(Event::class);
  141.     }
  143.     /**
  144.      */
  145.     public function showEventsAction($time = "upcoming", $term='', $title="", $text = '')
  146.     {
  147.         // sanitize variable from wordPress
  148.         $time = str_replace('&#8220;', '', (string) $time);
  149.         $term = str_replace('&#8220;', '', (string) $term);
  150.         $title = str_replace('&#8220;', '', (string) $title);
  151.         $text = str_replace('&#8220;', '', (string) $text);
  153.         $terms = explode('#', $term);
  155.         $events = $this->getEventRepository()->findPublicByTerms($terms, [], ($time == 'upcoming') ? 'future' : 'past');
  157.         return $this->render('@StartPlatzEventBundle/Default/show_events.html.twig', [
  158.             'events' => $events,
  159.             'title'  => $title,
  160.             'templateVars' => [],
  161.             'term' => $term,
  162.             'text'=>$text,
  163.         ]);
  164.     }
  166.     /**
  167.      */
  168.     public function showFutureEventsAction($term = 'startup', $variant = 'default')
  169.     {
  171.         $term = ltrim((string) $term, '#');
  172.         $events = $this->getEventRepository()->findPublicEventsByTerm($term);
  174.         $view = '@StartPlatzEventBundle/Default/show_future_events.html.twig';
  175.         if ($variant == 'black-rows') {
  176.             $view = '@StartPlatzEventBundle/Default/show_future_events.black-rows.html.twig';
  177.         }
  179.         return $this->render($view, [
  180.             'events' => $events,
  181.             'term'   => $term,
  182.             'templateVars' => [],
  183.         ]);
  184.     }
  186.     /**
  187.      */
  188.     public function showNextEventsAction(Request $request, $limit = 3)
  189.     {
  190.         $events = $this->getEventRepository()->findNextEvents($limit);
  192.         return $this->render('@StartPlatzEventBundle/Default/show_next_events.html.twig', [
  193.             'events' => $events,
  194.             'templateVars' => [],
  195.             'lang' =>  $this->menuTranslationService->getLang($request->server->get('REDIRECT_URL')),
  196.         ]);
  197.     }
  199.     /**
  200.      */
  201.     public function showListGroupEventsAction(Request $request, $limit = 15)
  202.     {
  203.         $events = $this->getEventRepository()->findNextEvents($limit);
  205.         return $this->render('@StartPlatzEvent/Default/show_list_group_events.html.twig', [
  206.             'events' => $events,
  207.             'templateVars' => [],
  208.             'lang' =>  $this->menuTranslationService->getLang($request->server->get('REDIRECT_URL')),
  209.         ]);
  210.     }
  212.     /**
  213.      */
  214.     public function showPastEventsAction($term)
  215.     {
  216.         $events = $this->getEventRepository()->findPastPublicEventsByTerm($term);
  217.         return $this->render('@StartPlatzEventBundle/Default/show_past_events.html.twig', [
  218.             'events' => $events,
  219.             'term' => $term,
  220.             'templateVars' => [],
  221.         ]);
  222.     }
  226.     /**
  227.      * @Route("/events", name="events_list")
  228.      * @Route("/en/events", name="events_list_english")
  229.      * @Route("/fr/evenements", name="events_list_french")
  230.      * @Route("/events/bevorstehend/")
  231.      * @Route("/events/list")
  232.      * @Route("/en/events/list")
  233.      * @Route("/fr/evenements/list")
  234.      * @Route("/events/embed/list")
  235.      * @Route("/en/events/embed/list")
  236.      * @Route("/fr/evenements/embed/list")     */
  237.     public function eventsAction(Request $request)
  238.     {
  239.         $templateVars = $this->getEventComRep()->getStartPlatzEventBaseTemplateVars($request);
  240.         $em = $this->getDoctrine()->getManager();
  242.         // Get the current path
  243.         $path = $request->getPathInfo();
  245.         // Check if the path starts with '/en/' or '/fr/'
  246.         if (strpos($path, '/en/') === 0) {
  247.             $lang = 'EN';
  248.         } elseif (strpos($path, '/fr/') === 0) {
  249.             $lang = 'FR';
  250.         } else {
  251.             $lang = 'DE';
  252.         }
  254.         // Check if the path contains  '/en/'
  255.         $embed = false;
  256.         if (str_contains($path, '/embed/') ) {
  257.             $embed = true;
  258.         }
  260.         // Fetch u tags
  261.         $uTags = $em->getRepository(Tag::class)->findBy(['domain' => 'event', 'isEditableByUser' => 1], ['tag' => 'ASC']);
  263.         // Convert to key-value array
  264.         $uTagsArray = array_map(function (Tag $entity) {
  265.             return [
  266.                 'tag' => $entity->getTag(),  // Dies entspricht dem 'slug' in deiner URL-Struktur
  267.                 'label' => $entity->getLabel()
  268.             ];
  269.         }, $uTags);
  271.         // Fetch w tags
  272.         $wTags = $em->getRepository(Tag::class)->findBy(['domain' => 'event', 'isUsedInWordPress' => 1], ['tag' => 'ASC']);
  274.         // Convert to key-value array
  275.         $wTagsArray = array_map(function (Tag $entity) {
  276.             return [
  277.                 'tag' => $entity->getTag(),  // Dies entspricht dem 'slug' in deiner URL-Struktur
  278.                 'label' => $entity->getLabel()
  279.             ];
  280.         }, $wTags);
  282.         $additionalEvents = [];
  283.         $queryString = '';
  285.         // Check for location filter first (location-based filtering)
  286.         if (isset($templateVars['location']) and $location = $templateVars['location']) {
  287.             $futureEvents = $this->getEventRepository()->findPublicByLocationWithBatches($location, $this->getEventComRep()->setBaseCriteria($templateVars), 'future');
  288.             $pastEvents   = $this->getEventRepository()->findPublicByLocationWithBatches($location, $this->getEventComRep()->setBaseCriteria($templateVars), 'past');
  289.             $moreFutureEvents = $this->getEventBaseRepository()->countFutureEvents($this->getEventComRep()->setBaseCriteria($templateVars));
  290.         }
  291.         // Check for tag filter (tag-based filtering)
  292.         elseif (isset($templateVars['tag']) and $tag = $templateVars['tag']) {
  293.             $futureEvents = $this->getEventRepository()->findPublicByTagWithBatches('#' . $tag, $this->getEventComRep()->setBaseCriteria($templateVars), 'future');
  294. /*
  295.  * falls einer der zielgruppen tags == uTags gewählt ist
  296.  * dann hole auch die events für alle fTags und startplatz-ai-hub
  297.  */
  299. // Extrahiere alle 'tag' Werte aus dem $uTagsArray
  300.             $uTagsSlugs = array_column($uTagsArray, 'tag');
  302. // Überprüfe, ob der gewählte $tag in den $uTagsSlugs enthalten ist
  303.             $isUTag = in_array($tag, $uTagsSlugs);
  306.             if ($isUTag) {
  307.                 // Fetch f tags
  308.                 $fTags = $em->getRepository(Tag::class)->findBy(['domain' => 'event', 'isFavorite' => 1], ['tag' => 'ASC']);
  310.                 // Extract just the tags to a simple array
  311.                 $fTagsList = array_map(function (Tag $entity) {
  312.                     return $entity->getTag(); // Dies gibt nur den 'tag' zurück
  313.                 }, $fTags);
  314.                 $additionalEvents = $this->getEventRepository()->findPublicByTagsExcludingTag($fTagsList, '#' . $tag, $this->getEventComRep()->setBaseCriteria($templateVars), 'future');
  315.             }
  316.             $pastEvents   = $this->getEventRepository()->findPublicByTagWithBatches('#' . $tag, $this->getEventComRep()->setBaseCriteria($templateVars), 'past');
  317.             $moreFutureEvents = $this->getEventBaseRepository()->countFutureEvents($this->getEventComRep()->setBaseCriteria($templateVars));
  318.         }
  319.         // No filter - show all events
  320.         else {
  321.             $futureEvents = $this->getEventRepository()->findPublicByWithBatches($queryString, $this->getEventComRep()->setBaseCriteria($templateVars), 'future');
  322.             $moreFutureEvents = $this->getEventBaseRepository()->countFutureEvents($this->getEventComRep()->setBaseCriteria($templateVars));
  323.             $pastEvents   = $this->getEventRepository()->findPublicByWithBatches($queryString, $this->getEventComRep()->setBaseCriteria($templateVars), 'past');
  324.         }
  326.         if ($request->get('format') === 'json') {
  327.             $events = [];
  329.             foreach ($futureEvents as $event) {
  330.                 $events[] = $event->toArray();
  331.             }
  333.             return Response::create(
  334.                 json_encode($events),
  335.                 200,
  336.                 [
  337.                     'Content-Type' => 'application/json',
  338.                     'Access-Control-Allow-Origin' => '*',
  339.                 ]
  340.             );
  341.         }
  343.         $targetPath = $request->server->get('REDIRECT_URL');
  346.         if ($this->getUser()) {
  347.             if (!$email = $this->getUser()->getEmail()) {
  348.                 $email = null;
  349.             }
  350.         } else {
  351.             $email = null;
  352.         }
  353.         $form = $this->setFeedbackForm($targetPath, $this->generateUrl('feedback_translation'), $email);
  355.         $eventTypes = $em->getRepository(Tag::class)->findBy(['domain'=>'event', 'isThema'=>1], ['tag'=>'ASC']);
  357.         $eventTypesTags   = array_map(fn (Tag $entity) => $entity->getTag(), $eventTypes);
  358.         $eventTypesLabels = array_map(fn (Tag $entity) => $entity->getLabel(), $eventTypes);
  359.         $eventTypesTagLabel = array_combine($eventTypesTags, $eventTypesLabels);
  361.         // Fetch popular tags
  362.         $popularTags = $em->getRepository(Tag::class)->findBy(['domain' => 'event', 'isModul' => 1], ['tag' => 'ASC']);
  364.         // Convert to key-value array
  365.         $popularTagsArray = array_map(function (Tag $entity) {
  366.             return [
  367.                 'tag' => $entity->getTag(),  // Dies entspricht dem 'slug' in deiner URL-Struktur
  368.                 'label' => $entity->getLabel()
  369.             ];
  370.         }, $popularTags);
  374.         $view = '@StartPlatzEventBundle/Default/events.html.twig';
  375.         if ($embed){
  376.             $view = '@StartPlatzEventBundle/Default/events-embed.html.twig';
  377.         }
  378.         return $this->render($view, [
  379.             'templateVars' => $templateVars,
  380.             'lang'           => $lang,
  381.             'embed'          => $embed,
  382.             'nextConference' => $this->getEventRepository()->findNextPublicBy("Konferenz"),
  383.             'nextWorkshop'   => $this->getEventRepository()->findNextPublicBy("Workshop"),
  384.             'futureEvents'   => $futureEvents,
  385.             'pastEvents'     => $pastEvents,
  386.             'events'         => $this->getEventRepository()->findNextEvents(100),
  387.             'moreFutureEvents' => $moreFutureEvents,
  388.             'additionalEvents' => $additionalEvents,
  389.             'eventArten'         => $eventTypes,
  390.             'eventTypesTagLabel' => $eventTypesTagLabel,
  391.             'popularTagsArray'   => $popularTagsArray,
  392.             'uTagsArray'         => $uTagsArray,
  393.             'wTagsArray'         => $wTagsArray,
  394.             'form'           => $form->createView(),
  395.             'menuLinksAndPhrases' => $this->menuTranslationService->getMenuLinksAndPhrases($request->server->get('REQUEST_URI')),
  396.         ]);
  397.     }
  399.     /**
  400.      * @Route("/event-series/{seriesTag}", name="event_series")
  401.      */
  402.     public function eventSeriesAction($seriesTag, Request $request )
  403.     {
  404.         $templateVars = $this->getEventComRep()->getStartPlatzEventBaseTemplateVars($request);
  405.         $em = $this->getDoctrine()->getManager();
  406.         $eventRepo = $em->getRepository(Event::class);
  407.         $batchRepo = $em->getRepository(Batch::class);
  409.         // Retrieve the UTM parameters from the URL
  410.         $utmParameters = [
  411.             'utmSource'   => $request->query->get('utm_source'),
  412.             'utmMedium'   => $request->query->get('utm_medium'),
  413.             'utmCampaign' => $request->query->get('utm_campaign'),
  414.             'utmTerm'     => $request->query->get('utm_term'),
  415.             'utmContent'  => $request->query->get('utm_content'),
  416.         ];
  418.         // Fetch data related to the event series using $seriesName
  419.         // For example, using a repository method:
  420.         $nextEvent = $eventRepo->findNextEventInSeries($seriesTag, new \DateTime());
  422.         // Check if the result is null (no future events)
  423.         if ($nextEvent === null) {
  424.             // Fetch the most recent past event in the series
  425.             $nextEvent = $eventRepo->findMostRecentPastEventInSeries($seriesTag, new \DateTime());
  426.         }
  428.         // Initialize variables with default values
  429.         $noEventsAvailable = false; // Default to false, indicating events are available
  430.         $alternativeContent = ''; // Default empty string or a default alternative message
  431.         $nextBatch = null;
  432.         $futureEventsData = [];
  433.         $pastEventsData = [];
  435.         // Proceed only if there is an event (either upcoming or past)
  436.         if ($nextEvent !== null) {
  437.             // Fetch all future events in the series, excluding the $nextEvent
  438.             $futureEvents = $eventRepo->findAllFutureEventsExcluding($seriesTag, $nextEvent->getId());
  440.             // Fetch all past events in the series, excluding the $nextEvent
  441.             $pastEvents = $eventRepo->findAllPastEventsExcluding($seriesTag, $nextEvent->getId());
  443.             // If the main event is multi-batch, get the next batch
  444.             if ($nextEvent->isMultiBatchEvent()) {
  445.                 $nextBatch = $batchRepo->findNextOpenBatchByEvent($nextEvent);
  446.             }
  448.             // Get batch data for future and past events
  449.             $futureBatches = $eventRepo->findAllFutureBatchesInSeries($seriesTag, $nextEvent->getId());
  450.             $pastBatches = $eventRepo->findAllPastBatchesInSeries($seriesTag, $nextEvent->getId());
  452.             // Merge events and batches data for display
  453.             $futureEventsData = $this->mergeEventsAndBatches($futureEvents, $futureBatches);
  454.             $pastEventsData = $this->mergeEventsAndBatches($pastEvents, $pastBatches);
  455.         } else {
  456.             // No events are available, display alternative content or a message
  457.             $noEventsAvailable = true;
  458.             $alternativeContent = "Sorry, there are no events available for this series.";
  459.             $nextEvent = new Event();
  460.             $futureEvents = [];
  461.             $pastEvents = [];
  462.             // $alternativeContent can also be fetched from a repository if needed
  463.         }
  468.         return $this->render('@StartPlatzEventBundle/Default/event-series.html.twig', [
  469.             'event'             => $nextEvent,
  470.             'nextEvent'         => $nextEvent,          // The next or most recent event
  471.             'nextBatch'         => $nextBatch,          // The next batch for multi-batch events
  472.             'futureEvents'      => $futureEvents,    // Collection of future events, excluding $nextEvent
  473.             'pastEvents'        => $pastEvents,        // Collection of past events, excluding $nextEvent
  474.             'futureEventsData'  => $futureEventsData,  // Combined events and batches data for future
  475.             'pastEventsData'    => $pastEventsData,    // Combined events and batches data for past
  476.             'noEventsAvailable' => $noEventsAvailable,  // Flag for no events availability
  477.             'alternativeContent' => $alternativeContent, // Alternative content when no events are available
  478.             'utmParameters'     => $utmParameters,
  480.             'showTeaser'         => $nextEvent->getTeaser() > '',
  481.             'batch'              => $nextBatch ?: new Batch(),
  482.             'application'        => new Application(),
  483.             'batchIsOpen'        => $nextBatch ? true : false,
  484.             'seriesEvents'       => $futureEvents,
  485.             'promotionUrl'       => "/event-series/{$seriesTag}",
  486.             'templateVars'       => $this->getEventComRep()->getStartPlatzEventBaseTemplateVars($request),
  488.             'speakers'           => $this->getSpeakers($nextEvent),
  489.             'lang' => $lang ?? "DE",  // Default to "DE" if $lang is not set
  490.             'menuLinksAndPhrases' => $this->menuTranslationService->getMenuLinksAndPhrases( $request->server->get('REQUEST_URI')  ),
  491.         ]);
  493.     }
  495.     /**
  496.      * Merge events and batches data for display in series pages
  497.      * Combines single-batch events with multi-batch event batches
  498.      * 
  499.      * @param array $events Array of Event entities
  500.      * @param array $batches Array of batch data from raw SQL query
  501.      * @return array Combined and sorted data
  502.      */
  503.     private function mergeEventsAndBatches(array $events, array $batches): array
  504.     {
  505.         $merged = [];
  506.         
  507.         // Add single-batch events
  508.         foreach ($events as $event) {
  509.             if (!$event->isMultiBatchEvent()) {
  510.                 $merged[] = [
  511.                     'type' => 'event',
  512.                     'event' => $event,
  513.                     'date' => $event->getStartDate(),
  514.                     'endDate' => $event->getEndDate(),
  515.                     'title' => $event->getTitle(),
  516.                     'location' => $event->getLocation(),
  517.                     'slug' => $event->getSlug(),
  518.                     'trainer' => $event->getTrainer()
  519.                 ];
  520.             }
  521.         }
  522.         
  523.         // Add batches (which are from multi-batch events)
  524.         foreach ($batches as $batch) {
  525.             $merged[] = [
  526.                 'type' => 'batch',
  527.                 'batch_id' => $batch['batch_id'],
  528.                 'event_id' => $batch['event_id'],
  529.                 'date' => new \DateTime($batch['batch_date']),
  530.                 'title' => $batch['event_title'],
  531.                 'batch_name' => $batch['batch_name'],
  532.                 'location' => $batch['location'],
  533.                 'event_slug' => $batch['event_slug'],
  534.                 'batch_slug' => $batch['batch_slug'],
  535.                 'trainer' => $batch['trainer']
  536.             ];
  537.         }
  538.         
  539.         // Sort by date
  540.         usort($merged, function($a, $b) {
  541.             return $a['date'] <=> $b['date'];
  542.         });
  543.         
  544.         return $merged;
  545.     }
  547.   
  549.     private function setFeedbackForm ( $targetPath, $actionPath, $email = NULL ) {
  550.         return $this->formFactory->createNamedBuilder( 'feedback' )
  551.             ->setAction( $actionPath )
  552.             ->add('targetPath', HiddenType::class, array( 'data' => $targetPath, ) )
  553.             ->add('email', TextType::class,  array( 'data' => $email, 'label' => '-', 'required' => false))
  554.             ->add('note', TextareaType::class, array( 'label' => '-', 'required' => true))
  555.             ->add('save', SubmitType::class,array('label'=>'Save'))
  556.             ->getForm();
  557.     }
  559.     /**
  560.      * @Route("/events/list/month/{year}/{month}", name="events_list_month")
  561.      */
  562.     public function listMonthAction($year, $month, Request $request)
  563.     {
  564.         $templateVars = $this->getEventComRep()->getStartPlatzEventBaseTemplateVars($request);
  566.         if (!isset($templateVars['tag'])) {
  567.             $templateVars['tag'] = '';
  568.         }
  569.         $queryString = '';
  570.         if (isset($templateVars['tag']) and $tag = $templateVars['tag']) {
  571.             $events = $this->getEventBaseRepository()->getEventsByMonth($this->getEventComRep()->setBaseCriteria($templateVars), $year, $month);
  572.         } else {
  573.             $events = $this->getEventBaseRepository()->getEventsByMonth($this->getEventComRep()->setBaseCriteria($templateVars), $year, $month);
  574.         }
  576.         $targetPath = $request->server->get('REDIRECT_URL');
  577.         $lang = $this->menuTranslationService->getLang($targetPath);
  579.         $menuLinksDe2En = $this->menuTranslationService->getMenuLinksSwitcher();
  581.         return $this->render('@StartPlatzEventBundle/Default/list_month.html.twig', [
  582.             'templateVars' => $templateVars,
  583.             'events' => $events,
  584.             'month' => $month,
  585.             'year' => $year,
  586.             'targetPath'      => $targetPath,
  587.             'moreFutureEvents' => $this->getEventBaseRepository()->countFutureEvents($this->getEventComRep()->setBaseCriteria($templateVars)),
  588.             'menuLinksDe2En' => $menuLinksDe2En,
  589.             'menuLinksEn2De' => array_flip($menuLinksDe2En) ,
  590.             'menuPhrases'    => $this->menuTranslationService->getMenuPhrases($lang),
  591.             'menuLinks'      => $this->menuTranslationService->getMenuLinks($lang),
  592.             'footerPhrases'  => $this->menuTranslationService->getFooterPhrases($lang),
  593.             'footerLinks'    => $this->menuTranslationService->getFooterLinks($lang),
  594.             'lang'           => $lang,
  595.         ]);
  596.     }
  598.     /** redirecting routes */
  600.     /**
  601.      * @Route("/event/corporate-services-event/")
  602.      */
  603.     public function eventRedirectAction()
  604.     {
  605.         return $this->redirect($this->generateUrl('event_show_single', ['slug' => 'best-practice-digitalisierung']));
  606.     }
  608.     private function findEventBySlug($slug)
  609.     {
  610.         $eventRepository = $this->getEventRepository();
  611.         $event = $eventRepository->findOneBy(['slug' => $slug]);
  613.         if (!$event) {
  614.             $querySlug = '/' . $slug;
  615.             $event = $eventRepository->findOneBy(['slug' => $querySlug]);
  616.             if (!$event) {
  617.                 return false;
  618.             } else {
  619.                 $em = $this->getDoctrine()->getManager();
  620.                 $event->setSlug($slug);
  621.                 $em->persist($event);
  622.                 $em->flush();
  623.             }
  624.         }
  626.         return $event;
  627.     }
  629.     private function findEventBySlugError($slug)
  630.     {
  631.         $eventRepository = $this->getEventRepository();
  632.         $event = $eventRepository->findOneBy(['slug' => $slug]);
  634.         if (!$event) {
  635.             $querySlug = '/' . $slug;
  636.             $event = $eventRepository->findOneBy(['slug' => $querySlug]);
  637.             if (!$event) {
  638.                 $this->session->getFlashBag()->add('notice', 'ERROR Veranstaltung nicht gefunden');
  639.                 return $this->redirectToRoute('events_list');
  640.             } else {
  641.                 $em = $this->getDoctrine()->getManager();
  642.                 $event->setSlug($slug);
  643.                 $em->persist($event);
  644.                 $em->flush();
  645.             }
  646.         }
  648.         return $event;
  649.     }
  651.     private function handleEventStatus(Event $event, Request $request)
  652.     {
  653.         // SEO-optimized handling: Archive events are displayed normally (no redirect)
  654.         // Template will show archive banner and hide registration forms
  655.         // This preserves 100% SEO juice and backlinks
  657.         if ($event->getStatus() != 'publish' and $event->getStatus() != 'archive' and !$request->get('preview')) {
  658.             // Draft and trash events require authentication
  659.             if (!$this->getUser()) {
  660.                 $this->addFlash('notice', 'ERROR Veranstaltung ist nicht verfügbar');
  661.                 return $this->redirectToRoute('events_list');
  662.             }
  663.         }
  664.         return null;
  665.     }
  667.     /**
  668.      * @Route("/events/repair/", name="events_repair_format")
  669.      */
  670.     public function repairFormatAction()
  671.     {
  672.         // Format-Umwandlung - deprecated - we need to check by mysql research
  673.         $em = $this->getDoctrine()->getManager();
  674.         $events = $em->getRepository(Event::class)->repairContent();
  676.         $responseContent = '<html><head><title>Repair Progress</title></head><body><ul>';
  678.         foreach ($events as $event) {
  679.             $responseContent .= "<li>{$event}</li>";
  680.         }
  682.         $responseContent .= '</ul></body></html>';
  684.         return new Response($responseContent);
  686.     }
  688.     ### section signup starts here ###
  689.     /**
  690.      * @Route("/ai-summer-school-single-ticket", name="ai-summer-school-single-ticket")
  691.      */
  692.     public function aisummerschoolSingleTicketAction(Request $request)
  693.     {
  694.         $em = $this->getDoctrine()->getManager();
  696.         $lang = 'DE';
  697.         if ($targetPath = $request->server->get('REDIRECT_URL')) {
  698.             $lang = $this->menuTranslationService->getLang($targetPath);
  699.         }
  700.         return $this->render('@StartPlatzEventBundle/Default/ai-summer-school-single-ticket.html.twig', [
  702.             'menuLinksAndPhrases' => $this->menuTranslationService->getMenuLinksAndPhrases($request->server->get('REQUEST_URI')),
  703.             'lang'            => $lang,
  704.         ]);
  705.     }
  707.     /**
  708.      * @Route("/ai-summer-school-firmen-pakete", name="ai-summer-school-firmen-pakete")
  709.      */
  710.     public function aisummerschoolFirmenPaketeAction(Request $request)
  711.     {
  712.         $em = $this->getDoctrine()->getManager();
  714.         $lang = 'DE';
  715.         if ($targetPath = $request->server->get('REDIRECT_URL')) {
  716.             $lang = $this->menuTranslationService->getLang($targetPath);
  717.         }
  718.         return $this->render('@StartPlatzEventBundle/Default/ai-summer-school-firmen-pakete.html.twig', [
  720.             'menuLinksAndPhrases' => $this->menuTranslationService->getMenuLinksAndPhrases($request->server->get('REQUEST_URI')),
  721.             'lang'            => $lang,
  722.         ]);
  723.     }
  724.     /**
  725.      * @Route("/ai-summer-school-stipendien", name="ai-summer-school-stipendien")
  726.      */
  727.     public function aisummerschoolStipendienAction(Request $request)
  728.     {
  729.         $em = $this->getDoctrine()->getManager();
  731.         $lang = 'DE';
  732.         if ($targetPath = $request->server->get('REDIRECT_URL')) {
  733.             $lang = $this->menuTranslationService->getLang($targetPath);
  734.         }
  735.         return $this->render('@StartPlatzEventBundle/Default/ai-summer-school-stipendien.html.twig', [
  737.             'menuLinksAndPhrases' => $this->menuTranslationService->getMenuLinksAndPhrases($request->server->get('REQUEST_URI')),
  738.             'lang'            => $lang,
  739.         ]);
  740.     }
  741.     /**
  742.      * @Route("/ai-summer-school-volunteers", name="ai-summer-school-volunteers")
  743.      */
  744.     public function aisummerschoolVolunteersAction(Request $request)
  745.     {
  746.         $em = $this->getDoctrine()->getManager();
  748.         $lang = 'DE';
  749.         if ($targetPath = $request->server->get('REDIRECT_URL')) {
  750.             $lang = $this->menuTranslationService->getLang($targetPath);
  751.         }
  752.         return $this->render('@StartPlatzEventBundle/Default/ai-summer-school-volunteers.html.twig', [
  754.             'menuLinksAndPhrases' => $this->menuTranslationService->getMenuLinksAndPhrases($request->server->get('REQUEST_URI')),
  755.             'lang'            => $lang,
  756.         ]);
  757.     }
  759.     /**
  760.      * @Route("/ai-summer-school-sponsoring", name="ai-summer-school-sponsoring")
  761.      */
  762.     public function aisummerschoolSponsoringAction(Request $request)
  763.     {
  764.         $em = $this->getDoctrine()->getManager();
  766.         $lang = 'DE';
  767.         if ($targetPath = $request->server->get('REDIRECT_URL')) {
  768.             $lang = $this->menuTranslationService->getLang($targetPath);
  769.         }
  770.         return $this->render('@StartPlatzEventBundle/Default/ai-summer-school-sponsoring.html.twig', [
  772.             'menuLinksAndPhrases' => $this->menuTranslationService->getMenuLinksAndPhrases($request->server->get('REQUEST_URI')),
  773.             'lang'            => $lang,
  774.         ]);
  775.     }
  777.     /**
  778.      * @Route("/signup/{slug}", name="signup_show_single")
  779.      */
  780.     public function signupSingleAction(Request $request, $slug)
  781.     {
  782.         $em = $this->getDoctrine()->getManager();
  784.         /** @var Program $program */
  785.         if (!$program = $em->getRepository(Program::class /*Startup Program*/)->findOneBy(['slug' => 'sign-up'])) {
  786.             $this->session->getFlashBag()->add('notice', 'ERROR Sorry, no program found');
  787.             return $this->redirect($this->generateUrl('apply_home', []));
  788.         }
  789.         /** @var Batch $batch */
  790.         if (!$batch = $em->getRepository(Batch::class)->findOneBy(['slug' => $slug, 'program' => $program])) {
  791.             $this->session->getFlashBag()->add('notice', 'ERROR Sorry, no batch found');
  792.             return $this->redirect($this->generateUrl('apply_home', []));
  793.         }
  795.         // Retrieve the UTM parameters from the URL
  796.         $utmParameters = [
  797.             'utmSource'   => $request->query->get('utm_source'),
  798.             'utmMedium'   => $request->query->get('utm_medium'),
  799.             'utmCampaign' => $request->query->get('utm_campaign'),
  800.             'utmTerm'     => $request->query->get('utm_term'),
  801.             'utmContent'  => $request->query->get('utm_content'),
  802.         ];
  805.         $lang = 'DE';
  806.         if ($targetPath = $request->server->get('REDIRECT_URL')) {
  807.             $lang = $this->menuTranslationService->getLang($targetPath);
  808.         }
  810.         $batchIsOpen = $batch && $em->getRepository(Batch::class)->isBatchApplicationOpen($batch);
  812.         $form    = null;
  813.         $program = null;
  814.         $member  = null;
  815.         $application = null;
  816.         $product     = null;
  817.         $editFeedback = "";
  818.         $settings     = [];
  819.         $action       = "";
  820.         $customersArr = [];
  823.         if ($batchIsOpen) {
  824.             $program = $batch->getProgram();
  825.             $settings = $this->getProgramSettings($program, $batch);
  826.             $batch = $em->getRepository(Batch::class)->updateNumbers($batch);
  827.             /** @var User $user */
  828.             if ($user = $this->getUser()) {
  829.                 $member = $em->getRepository(Member::class)->find($user->getMemberId());
  830.             }
  832.             $action   = $request->get('action');
  834.             $application = $this->getOrCreateApplication($request, $batch, $program, $member, $lang, $settings, $utmParameters, null);
  837.             if ($batch->getPriceInEuroCent() > 0) {
  838.                 $route                   = "signup_show_single";
  839.                 $routeParameters["slug"] = $batch->getSlug();
  840.                 $application = $this->handleAction($request, $member, $application, $batch, $lang, $route, $routeParameters, $settings);
  842.                 if (is_string($application)) {
  843.                     // Handle redirect
  844.                     return $this->redirect($application);
  845.                 }
  846.             }
  848.             if ($user && in_array($action, ["needsloginvalidation", "needsemailverification"])) {
  849.                 $response = $this->validateEventApplication($application, $member, $settings, $batch, $lang);
  850.                 $application = $response['data']['application'];
  851.             }
  853.             if ($batch->getPriceInEuroCent() > 0 && $batch->getProductId()) {
  854.                 if (!$product = $em->getRepository(Product::class /*Product Member*/)->find($batch->getProductId())) {
  855.                     $this->session->getFlashBag()->add('notice', 'ERROR configuration not found');
  856.                     return $this->redirect($this->generateUrl('events_list'));
  857.                 }
  858.                 if ($application->getId() && isset($member) && $member->getId()) {
  859.                     $customersArr = $em->getRepository(Customer::class)->findValidMonsumCustomersByMemberAndAccount($member, $product->getAccount(), false);
  860.                 }
  861.             }
  863.             $form = $this->createForm(ApplicationType::class, $application, ['settings' => $settings, 'program' => $program, 'batch' => $batch]);
  865.             $form->handleRequest($request);
  866.             ##############################################################
  867.             ##   form validation starts here                            ##
  868.             ##############################################################
  869.             if ($form->isSubmitted() && $form->isValid()) {
  871.                 $application = $em->getRepository(Application::class)->cleanApplicationData($application);
  872.                 $adminEmail  = $application->getEmail();
  874.                 if ($member) {
  875.                     $memberToBeRegistered = $member;
  876.                     $isExistingMember     = true;
  877.                 } else {
  878.                     $response = $this->processRegistrationCheckMembershipExistence($application);
  879.                     $isExistingMember     = $response['data']['isExistingMember'];
  880.                     $memberToBeRegistered = $response['data']['memberToBeRegistered'];
  881.                 }
  882.                 $memberToBeRegistered->setIsExistingMember($isExistingMember);
  884.                 // fill application with memberId and teamId and discount information
  885.                 $application = $this->updateApplicationWithMemberIdAndTeamId($application, $memberToBeRegistered, $batch);
  887.                 if (!$batch->isMultipleApplicationsPerMember()) {
  888.                     // check if there is already an application to this event == batch with that batchId and memberId
  889.                     if ($existingApplication = $em->getRepository(Application::class)->findOneBy(['batchId' => $batch->getId(), 'memberId' => $memberToBeRegistered->getId()])) {
  890.                         // there are two applications - the latest application will always win
  891.                         $fields     = Utility::getEntityFieldsArray($application, ['id','assessments', 'votesRegistered', 'applicationStatus', 'editStatus', 'editMessage', 'lastChangeUser','history','extraFields','lastModified','createdAt']);
  892.                         $storedData = Utility::fillDataByObject($existingApplication, $fields);
  893.                         $updatedData = Utility::fillDataByObject($application, $fields);
  895.                         $differences = array_diff_assoc($updatedData, $storedData);
  896.                         $application = $existingApplication;
  897.                         $application = $this->updateApplication($application, $differences);
  899.                         $application->setIsExistingApplication(true);
  900.                     }
  901.                 }
  903.                 if (isset($settings['extraFields'])) {
  904.                     $application = $this->getExtraFieldsData($application, $settings, $form);
  905.                 }
  907.                 $dummyEvent = new Event();
  908.                 $isPaidEvent = $this->checkPaidEvent($application, $batch, $dummyEvent);
  909.                 $hasToPay    = $this->checkPaymentException($application, $memberToBeRegistered, $dummyEvent, $settings, $batch);
  911.                 if ($isPaidEvent && $hasToPay) {
  912.                     // falls es bereits einen zugänglichen Monsum Account für diese Person gibt
  914.                     $customersArr = $em->getRepository(Customer::class)->findValidMonsumCustomersByMemberAndAccount($memberToBeRegistered, $product->getAccount(), false);
  916.                     $dummyEvent = new Event();
  917.                     $application  = $this->updateApplicationWithStepOneInformation($application, $memberToBeRegistered, $dummyEvent);
  918.                     // Application in Datenbank schreiben, sonst kann im nächsten Schritt keine appId übergeben werden
  919.                     $application = $em->getRepository(Application::class)->setApplication($application);
  920.                 } else {
  921.                     $route = 'signup_show_single';
  922.                     $routeParameters = $request->get('_route_params');
  924.                     $response = $this->processRegistrationWithoutPaymentSimpleOptimized($isExistingMember, $user, $memberToBeRegistered, $application, $settings, $lang, $adminEmail, $batch, $route, $routeParameters);
  926.                     // Bei SignUps: Prüfe ob goToPage gesetzt ist
  927.                     if ($batch->getGoToPage()) {
  928.                         // Weiterleitung zu goToPage (kann URL oder interner Pfad sein)
  929.                         return $this->redirect($batch->getGoToPage());
  930.                     }
  931.                     // Ansonsten auf SignUp-Seite bleiben - keine Weiterleitung
  932.                     $application  = $response['data']['application'];
  933.                     $member       = $response['data']['member'];
  934.                 }
  935.             }
  936.         }
  938.         // Default to legacy template for backward compatibility
  939.         $view = '@StartPlatzEventBundle/Default/signup-single.html.twig';
  941.         // Check for pageTemplate field (new approach)
  942.         if ($batch->getPageTemplate()) {
  943.             switch ($batch->getPageTemplate()) {
  944.                 case 'modern':
  945.                 case 'flexible':
  946.                     $view = '@StartPlatzEventBundle/Default/signup-single.modern.html.twig';
  947.                     break;
  948.                 case 'petition':
  949.                     $view = '@StartPlatzEventBundle/Default/signup-single.deepSeekPetition.html.twig';
  950.                     break;
  951.                 case 'legacy':
  952.                 default:
  953.                     $view = '@StartPlatzEventBundle/Default/signup-single.html.twig';
  954.                     break;
  955.             }
  956.         }
  957.         // Keep backward compatibility for existing petition SignUps using JSON settings
  958.         elseif (array_key_exists('signupTemplate', $settings)) {
  959.             $view = '@StartPlatzEventBundle/Default/signup-single.deepSeekPetition.html.twig';
  960.         }
  962. // Build the metaData array using only the $batch object (landing page fields)
  963.         $metaData = [
  964.             // SEO Tag: Description (using landingPageDescription)
  965.             'description'       => $batch->getLandingPageDescription(),
  967.             // Canonical URL (the domain remains lowercase)
  968.             'canonical'         => 'https://www.startplatz.de/signup/' . urlencode($batch->getSlug()),
  970.             // Open Graph Tags for Social Sharing (using landingPage fields)
  971.             'ogTitle'           => $batch->getLandingPageTitle(),
  972.             'ogDescription'     => $batch->getLandingPageDescription(),
  973.             'ogImage'           => $batch->getLandingPageSocialImage(),
  974.             'ogUrl'             => 'https://www.startplatz.de/signup/' . urlencode($batch->getSlug()),
  975.             'ogType'            => 'website',
  976.             'ogSiteName'        => 'STARTPLATZ', // Protected trademark must be uppercase
  978.             // Twitter Card Tags (using landingPage fields)
  979.             'twitterCard'       => 'summary', // or "summary_large_image" if preferred
  980.             'twitterTitle'      => $batch->getLandingPageTitle(),
  981.             'twitterDescription'=> $batch->getLandingPageDescription(),
  982.             'twitterImage'      => $batch->getLandingPageSocialImage(),
  983.             'twitterSite'       => '@STARTPLATZ', // Protected trademark must be uppercase
  985.             // Title for the page (taken from landingPageTitle)
  986.             'title'             => $batch->getLandingPageTitle(),
  988.             // Additional Landing Page Fields
  989.             'landingPageCss'            => $batch->getLandingPageCss(),
  990.             'landingPageContent'        => $batch->getLandingPageContent(),
  991.             'landingPageJs'             => $batch->getLandingPageJs(),
  992.             'landingPageFooterTemplate' => $batch->getLandingPageFooterTemplate(),
  993.         ];
  995.         return $this->render($view, [
  996.             'batch'          => $batch,
  997.             'program'        => $program,
  998.             'settings'       => $settings,
  999.             'metaData'       => $metaData,
  1000.             'form'           => $form ? $form->createView() : $form,
  1001.             'application'    => $application,
  1002.             'action'         => $action,
  1003.             'batchIsOpen'    => $batchIsOpen,
  1004.             'customersArr'   => $customersArr,
  1005.             'member'         => $member,
  1006.             'isMultiBatchEvent' => false,  // Signups have no event, so no multi-batch
  1008.             'utmParameters'  => $utmParameters,
  1010.             'phrases'        => $em->getRepository(Option::class)->getApplicationPhrases($program, $batch, false, $lang),
  1013.             'editFeedback'   => $editFeedback,
  1014.             'templateVars'   => [],
  1016.             'preview'             => $request->get('preview'),
  1017.             'menuLinksAndPhrases' => $this->menuTranslationService->getMenuLinksAndPhrases($request->server->get('REQUEST_URI')),
  1018.             'lang'            => $lang,
  1019.             'targetRoute'     => "signup_show_single",
  1020.             'targetRouteSlug' => $batch->getSlug(),
  1021.             'targetPath'      => $targetPath,
  1022.         ]);
  1024.     }
  1026.     ### section signup ends here ###
  1027.     private function getProgramSettings($program, $batch)
  1028.     {
  1029.         $em = $this->getDoctrine()->getManager();
  1030.         $settings = $em->getRepository(Application::class)->getSettingsProgram($program, $batch);        return $settings;
  1031.     }
  1033.     private function getOrCreateApplication(Request $request, $batch, $program, $member, $lang, $settings, $utmParameters, $event = null)
  1034.     {
  1035.         $em = $this->getDoctrine()->getManager();
  1036.         $application = null;
  1037.         // process:stripeStarted
  1038.         // Check if the application ID is provided
  1039.         if ($applicationId = $request->get('app')) {
  1040.             $application = $em->getRepository(Application::class)->find($applicationId);
  1041.         }
  1043.         // Check if an application exists if there is a member
  1044.         if ($member) {
  1045.             $application = $em->getRepository(Application::class)->findOneBy(['batchId' => $batch->getId(), 'memberId' => $member->getId()]);
  1046.         }
  1048.         // check if stripe was not finished and therefore we need to delete that application
  1049.         $action = $request->get('action');
  1050.         if ($application && $application->getEditStatus() == 'process:stripeStarted' && $action != 'checkSuccess'){
  1052.             $responseText = $em->getRepository(Application::class)->deleteApplication($application->getId());
  1054.             $application = null;
  1055.             $applicationId = null;
  1056.         }
  1057.         // If no application is found, create a new one
  1058.         if (!$application) {
  1059.             $priceAndDiscount = $em->getRepository(Member::class)->getPriceAndDiscountByBatch($member, $batch);
  1060.             // Pass the UTM parameters along with other necessary arguments to the createApplicationByApplyForm method
  1061.             $application = $em->getRepository(Application::class)->createApplicationByApplyForm(
  1062.                 $program,
  1063.                 $batch,
  1064.                 $lang,
  1065.                 $priceAndDiscount,
  1066.                 $utmParameters  // This is the array you created earlier
  1067.             );
  1068.             if ($member) {
  1069.                 $application = $em->getRepository(Application::class)->updateApplicationByMember($application, $member);
  1070.             }
  1071.         } else {
  1072.             // Update lang on existing application if it differs
  1073.             // This ensures language preference is maintained throughout the user journey
  1074.             if ($lang && $application->getLang() !== $lang) {
  1075.                 $application->setLang($lang);
  1076.                 $em->persist($application);
  1077.                 $em->flush();
  1078.             }
  1079.         }
  1080.         
  1081.         // Fix for single events with event-level pricing: 
  1082.         // If batch has no price but event has price, use event price
  1083.         if ($batch && $event && !$batch->getPriceInEuroCent() && $event->getPriceInEuroCent() > 0) {
  1084.             $application->setPriceInEuroCent($event->getPriceInEuroCent());
  1085.             $discountPercent = $application->getDiscountPercent() ?: 0;
  1086.             $realPrice = $event->getPriceInEuroCent() - ($event->getPriceInEuroCent() * ($discountPercent / 100));
  1087.             $application->setRealPriceInEuroCent($realPrice);
  1088.         }
  1090.         if ($member and $application->getApplicationStatus() == 'started') {
  1091.             $priceAndDiscount = $em->getRepository(Member::class)->getPriceAndDiscountByBatch($member, $batch);
  1092.             if ($application->getRealPriceinEuroCent() != $priceAndDiscount["realPriceinEuroCent"]) {
  1093.                 $application = $em->getRepository(Application::class)->setDiscountAndRealPrice($application, $priceAndDiscount);
  1094.                 if ($application->getRealPriceinEuroCent() == 0) {
  1095.                     $application = $this->setEventApplicationDone($application, $member, $batch, $lang, $settings);
  1096.                 }
  1097.             }
  1099.         }
  1101.         // Gib das Application-Objekt zurück
  1102.         return $application;
  1103.     }
  1106.     /**
  1107.      * @Route("/allmeda/event/application/send-confirmation-mail/{applicationId}", name="allmeda_event_send-confirmation-mail")
  1108.      * @Security("is_granted('ROLE_ADMIN')")
  1109.      */
  1110.     public function sendConfirmationMailViaPublicFunction($applicationId)
  1111.     {
  1112.         $em = $this->getDoctrine()->getManager();
  1114.         $application = $em->getRepository(Application::class)->find($applicationId);
  1115.         $member = $em->getRepository(Member::class)->find($application->getMemberId());
  1116.         $batch = $em->getRepository(Batch::class)->find($application->getBatchId());
  1118.         $feedback = $this->sendConfirmationMailToApplicant(null, $member, [], $application, $batch);
  1120.         $response = "SUCCESS Confirmation Mail has been sent";
  1122.         return new Response($response);
  1123.     }
  1124.     private function setEventApplicationDone($application, $member, $batch, $lang, $settings)
  1125.     {
  1126.         $em = $this->getDoctrine()->getManager();
  1127.         $application = $em->getRepository(Application::class)->setApplicationDone($application);
  1128.         $phrases = $em->getRepository(Option::class)->getApplicationPhrases($batch->getProgram(), $batch, false, $lang);
  1130.         switch ($lang) {
  1131.             case "DE":
  1132.                 $message = $phrases['event_application_thankyou_sent_confirmationmail'] ?? "Danke für Deine Anmeldung.<br>Wir haben Dir eine Bestätigungsmail geschickt. Wir freuen uns auf Dich!";
  1133.                 break;
  1134.             case "EN":
  1135.                 $message = $phrases['event_application_thankyou_sent_confirmationmail'] ?? "Thanks, Your application is now approved.<br>We have sent you a confirmation mal and we are looking forward to having you!";
  1136.                 break;
  1137.         }
  1138.         $this->session->getFlashBag()->add('notice', "SUCCESS {$message}");
  1140.         $application = $em->getRepository(Application::class)->setApplication($application, $member);
  1141.         $this->sendConfirmationMailToApplicant(null, $member, $settings, $application, $batch);
  1143.         return $application;
  1144.     }
  1146.     private function updateApplicationWithMemberIdAndTeamId(Application $application, Member $memberToBeRegistered, $batch)
  1147.     {
  1148.         $em = $this->getDoctrine()->getManager();
  1149.         if (!$application->getMemberId()) {
  1150.             $application->setMemberId($memberToBeRegistered->getId());
  1151.             if ($application->getRealPriceinEuroCent() > 0) {
  1152.                 $priceAndDiscount = $em->getRepository(Member::class)->getPriceAndDiscountByBatch($memberToBeRegistered, $batch);
  1153.                 $application = $em->getRepository(Application::class)->setDiscountAndRealPrice($application, $priceAndDiscount);
  1154.             }
  1155.         }
  1156.         if (!$application->getTeamId()) {
  1157.             $application->setTeamId($memberToBeRegistered->getTeamId());
  1158.             $application->setStartupName($memberToBeRegistered->getTeamName());
  1159.         }
  1161.         if (!$application->getLinkedin() && $memberToBeRegistered->getLinkedin()) {
  1162.             $application->setLinkedin($memberToBeRegistered->getLinkedin());
  1163.         }
  1165.         if (!$application->getPhone() && $memberToBeRegistered->getPhone()) {
  1166.             $application->setPhone($memberToBeRegistered->getPhone());
  1167.         }
  1169.         if (!$memberToBeRegistered->getIsExistingMember()){
  1170.             $application->setIsNewMember(true);
  1171.         } else {
  1172.             $application->setIsNewMember(false);
  1173.         }
  1175.         // Transfer UTM parameters if not already set in the Member object and if they exist in the Application object
  1176.         $memberToBeRegistered = $em->getRepository(Member::class)->updateMemberWithUtmParametersFromApplication($memberToBeRegistered, $application);
  1178.         return $application;
  1179.     }
  1182.     /**
  1183.      * handleAction - Handles various actions for the application
  1184.      *
  1185.      * This function is called in the following contexts:
  1186.      * 1. During Signup (Line 549)
  1187.      *    - With route "signup_show_single"
  1188.      *    - Parameters include batch slug, language, etc.
  1189.      *
  1190.      * 2. During Event Handling (Line 968)
  1191.      *    - With route "event_show_single"
  1192.      *    - Parameters include event slug, language, etc.
  1193.      */
  1195.     private function handleAction(Request $request, $member,Application $application, Batch $batch, $lang, $route, $routeParameters, $settings)
  1196.     {
  1197.         $action = $request->get("action");
  1198.         $em = $this->getDoctrine()->getManager();
  1200.         switch ($action) {
  1201.             case "checkSuccess":
  1202.                 $provider = $request->get('provider');
  1203.                 if ($provider == 'stripe'){
  1204.                     $application->setEditStatus("success:stripePaid");
  1205.                 }
  1206.                 $application->setApplicationStatus('applied');
  1207.                 $application->setHasPaid(true);
  1208.                 $application = $em->getRepository(Application::class)->setApplication($application);
  1209.                 switch ($lang) {
  1210.                     case "DE":
  1211.                         $message = "Danke für Deine Anmeldung.<br>Wir freuen uns auf Dich!";
  1212.                         break;
  1213.                     case "EN":
  1214.                         $message = "Thanks, Your application is now approved.<br>We are looking forward to having you!";
  1215.                         break;
  1216.                 }
  1217.                 if ($productNumber = $request->get('productnumber') or $provider == 'stripe'){
  1218.                     ## productNumber is only given in case of sign up
  1219.                     switch ($lang) {
  1220.                         case "DE":
  1221.                             $message = "Danke für Deine Buchung.<br>Wir freuen uns auf Dich!";
  1222.                             break;
  1223.                         case "EN":
  1224.                             $message = "Thanks, Your booking was successful.<br>We are looking forward to having you!";
  1225.                             break;
  1226.                     }
  1227.                     $account      = $request->get('account');
  1228.                     $customerHash = $request->get('customerId');
  1229.                     $subscriptionHash = $request->get('subscriptionId');
  1231.                     if (!$member) {
  1232.                         $member = $em->getRepository(Member::class)->find($application->getMemberId());
  1233.                     }
  1235.                     if (array_key_exists("setAiHubMembership", $settings)) {
  1236.                         // Hole den Status aus den Einstellungen
  1237.                         $aiMembershipStatus = $settings["setAiHubMembership"];
  1239.                         // Setze das Start- und Enddatum basierend auf dem aktuellen Datum und dem Status
  1240.                         $aiMembershipStartDate = new DateTime();  // Setze auf aktuelles Datum und Uhrzeit
  1241.                         $aiMembershipEndDate = clone $aiMembershipStartDate;
  1242.                         if ($aiMembershipStatus === 'trial') {
  1243.                             $aiMembershipEndDate->modify('+1 month');
  1244.                         } elseif ($aiMembershipStatus === 'active') {
  1245.                             $aiMembershipEndDate->modify('+3 months');
  1246.                         }
  1248.                         // Setze den Grund für die Mitgliedschaft
  1249.                         $reason = "Buy of {$productNumber}";
  1251.                         // Erstelle oder aktualisiere das Service-Objekt mit den neuen Daten
  1252.                         // (Du müsstest diese Logik entsprechend deiner Anwendung implementieren)
  1253.                         $service = new Service();  // oder hole ein existierendes Service-Objekt
  1254.                         $service->setStatus($aiMembershipStatus);
  1255.                         $service->setStartDate($aiMembershipStartDate);
  1256.                         $service->setEndDate($aiMembershipEndDate);
  1258.                         // Rufe die setAiHubMembership Funktion auf
  1259.                         $successContent[] = $em->getRepository(Member::class)->setAiHubMembership($service, $member, $reason);
  1260.                     }
  1262.                     $loginLink = null;
  1263.                     $targetPath = $this->generateUrl('x_membership_first-steps', ['productNumber' => $productNumber, 'account' => $account]);
  1265.                     $this->session->getFlashBag()->add('notice', $message);
  1267.                     if (!$user = $this->getUser()) {
  1268.                         $loginLink = $this->loginService->getLoginLinkByTargetPath($member->getEmail(), $targetPath);
  1269.                         $user = $em->getRepository(User::class)->findOneBy(['memberId'=>$member->getId()]);
  1270.                     }
  1272.                     $feedback = $this->sendConfirmationMailToApplicant($user, null, $settings, $application, $batch);
  1274.                     if ($provider == 'stripe'){
  1275.                         $mailContent = [
  1276.                             'applicationId' => $application->getId(),
  1277.                             'memberId' => $application->getMemberId(),
  1278.                             'editStatus' => $application->getEditStatus(),
  1279.                             'applicationStatus' => $application->getApplicationStatus(),
  1280.                             'person' => $application->getPerson(),
  1281.                             'email' => $application->getEmail(),
  1282.                             'utmSource' => $application->getUtmSource(),
  1283.                             'batchSlug' => $application->getBatchSlug(),
  1284.                         ];
  1285.                         $response = Utility::sendDirectMail($this->mailer, "stripe step two {$application->getBatchId()} {$application->getEmail()}", 'support@startplatz.de', 'Monitoring Stripe', 'lorenz.graef@startplatz.de', 'Lorenz', print_r($mailContent,true), false);
  1287.                         return $application;
  1288.                     } else {
  1289.                         return isset($loginLink) ? $loginLink : $targetPath;
  1290.                     }
  1293.                 } else { // if productNumber is not defined
  1294.                     if (!$user = $this->getUser()) {
  1295.                         $user = $em->getRepository(User::class)->findOneBy(['memberId'=>$member->getId()]);
  1296.                     }
  1298.                     $feedback = $this->sendConfirmationMailToApplicant($user, null, $settings, $application, $batch);
  1299.                 }
  1302.                 break;
  1303.             case "sendMagicLinkForPayment":
  1304.                 // create LoginLink and send email
  1305.                 $customerId  = $request->get('customerId');
  1307.                 $feedbackUrl = $this->sendMagicLinkForPayment($application, $batch, $customerId, $route, $routeParameters);
  1308.                 return $feedbackUrl;
  1309.             case "createConsumerMonsumAccount":
  1310.             case "useExistingCustomerAccount":
  1311.                 $customerId  = $request->get('customerId');
  1312.                 $checkoutUrl = $this->prepareMonsumCheckoutNewMonsumAccount($application, $batch, $action, $route, $routeParameters, $customerId);
  1313.                 return $checkoutUrl;
  1314.         }
  1316.         // Return the modified $application object to the main controller
  1317.         return $application;
  1318.     }
  1320.     private function validateEventApplication(Application $application, Member $member, $settings, $batch, string $lang): array
  1321.     {
  1322.         $em = $this->getDoctrine()->getManager();
  1323.         $message = "";
  1324.         $status = "";
  1325.         // Check if a confirmation email needs to be sent
  1326.         $shouldSendConfirmationMail = false;
  1327.         $feedback = null;
  1329.         switch ($application->getEditStatus()) {
  1330.             case "error:validateLogin":
  1331.                 $application->setEditStatus('success:validatedLogin');
  1332.                 $application->setEditMessage("Application has been validated by {$member->getEmail()}");
  1333.                 $application = $em->getRepository(Application::class)->setHistory($application, $application->getEditMessage());
  1334.                 $application = $em->getRepository(Application::class)->setApplication($application, $member);
  1335.                 $status = "success";
  1336.                 $shouldSendConfirmationMail = true;
  1337.                 break;
  1338.             case "error:validateEmail":
  1339.                 $application->setEditStatus('success:validatedEmail');
  1340.                 $application->setEditMessage("Email of this Application has been validated by {$member->getEmail()}");
  1342.                 $application = $em->getRepository(Application::class)->setHistory($application, $application->getEditMessage());
  1343.                 if ($application->getApplicationStatus() == 'started') {
  1344.                     $application->setApplicationStatus('applied');
  1345.                 }
  1346.                 $application = $em->getRepository(Application::class)->setApplication($application, $member);
  1347.                 $status = "success";
  1348.                 $shouldSendConfirmationMail = true;
  1349.                 break;
  1350.         }
  1352.         if ($shouldSendConfirmationMail) {
  1353.             // Logic to send confirmation mail
  1354.             $feedback = $this->sendConfirmationMailToApplicant(null, $member, $settings, $application, $batch);
  1355.         }
  1357.         if ($status == "success") {
  1358.             $application = $em->getRepository(Application::class)->setApplicationApplied($application, $member);
  1359.             switch ($lang) {
  1360.                 case "DE":
  1361.                     $message = "SUCCESS Danke, Deine Anmeldung ist jetzt bestätigt. Wir freuen uns auf Dich!";
  1362.                     if ($feedback){
  1363.                         $message .= "<br>Wir haben Dir eine Bestätigungsmail geschickt. Bitte prüfe Deinen Posteingang.";
  1364.                     }
  1365.                     break;
  1366.                 case "EN":
  1367.                     $message = "SUCCESS Thanks, Your application is now approved. We are looking forward to having you!";
  1368.                     if ($feedback){
  1369.                         $message .= "<br>We have sent you a confirmation mail. Please check your inbox!";
  1370.                     }
  1371.                     break;
  1372.             }
  1373.             $this->session->getFlashBag()->add('notice', $message);
  1374.         }
  1375.         return [
  1376.             'data' => [
  1377.                 'application' => $application,
  1378.             ],
  1379.             'message' => $message,
  1380.             'status' => $status,
  1381.         ];
  1382.     }
  1384.     private function checkPaidEvent(Application $application, $batch = false, $event = false): bool
  1385.     {
  1386.         // First check: Application has a price (Monsum payment)
  1387.         if ($application->getRealPriceInEuroCent() !== null && $application->getRealPriceInEuroCent() > 0) {
  1388.             return true;
  1389.         }
  1390.         
  1391.         // Always prioritize batch payment settings
  1392.         if ($batch) {
  1393.             // Check if batch has a price or Stripe price ID
  1394.             if ($batch->getPriceInEuroCent() > 0 || $batch->getStripePriceId() > '') {
  1395.                 return true;
  1396.             }
  1397.         }
  1398.         
  1399.         // Legacy fallback: Check event payment settings for backward compatibility
  1400.         // This can be removed after all single-batch events are migrated
  1401.         if ($event) {
  1402.             if ($event->getStripePriceId() > '' || $event->getPriceInEuroCent() > 0) {
  1403.                 return true;
  1404.             }
  1405.         }
  1407.         return false;
  1408.     }
  1410.     private function checkPaymentException(Application $application, $member = false, $event = false, $settings = false, $batch = false): bool
  1411.     {
  1412.         if ($member) {
  1413.             // Check batch-specific KI Campus setting first for multi-batch events
  1414.             $isFreeForKiCampus = false;
  1415.             if ($batch && $batch->getIsFreeForKiCampus() !== null) {
  1416.                 // Use batch-specific setting if available
  1417.                 $isFreeForKiCampus = $batch->getIsFreeForKiCampus();
  1418.             } elseif ($event) {
  1419.                 // Fall back to event setting
  1420.                 $isFreeForKiCampus = $event->getIsFreeForKiCampus();
  1421.             }
  1422.             
  1423.             $this->logger->info('checkPaymentException: KI Campus check', [
  1424.                 'member_id' => $member->getId(),
  1425.                 'member_email' => $member->getEmail(),
  1426.                 'member_tags' => $member->getTags(),
  1427.                 'has_ki_campus_tag' => str_contains($member->getTags() ?? '', "#ki-campus"),
  1428.                 'isFreeForKiCampus' => $isFreeForKiCampus,
  1429.                 'batch_setting' => $batch ? $batch->getIsFreeForKiCampus() : 'no batch',
  1430.                 'event_setting' => $event ? $event->getIsFreeForKiCampus() : 'no event',
  1431.             ]);
  1432.             
  1433.             if ($isFreeForKiCampus) {
  1434.                 if (str_contains($member->getTags() ?? '', "#ki-campus")) {
  1435.                     $this->session->getFlashBag()->add('notice', "SUCCESS Du bist Mitglied im KI Campus und kannst kostenlos teilnehmen");
  1436.                     $this->logger->info('Payment exception granted: KI Campus member');
  1437.                     return false; // no payment necessary for ki campus members
  1438.                 }
  1439.             }
  1441.             // Check batch-specific Community setting first for multi-batch events
  1442.             $isFreeForCommunity = false;
  1443.             if ($batch && $batch->getIsFreeForCommunity() !== null) {
  1444.                 // Use batch-specific setting if available
  1445.                 $isFreeForCommunity = $batch->getIsFreeForCommunity();
  1446.             } elseif ($event) {
  1447.                 // Fall back to event setting
  1448.                 $isFreeForCommunity = $event->getIsFreeForCommunity();
  1449.             }
  1450.             
  1451.             $this->logger->info('checkPaymentException: Community check', [
  1452.                 'member_id' => $member->getId(),
  1453.                 'member_email' => $member->getEmail(),
  1454.                 'member_tags' => $member->getTags(),
  1455.                 'isFreeForCommunity' => $isFreeForCommunity,
  1456.                 'batch_setting' => $batch ? $batch->getIsFreeForCommunity() : 'no batch',
  1457.                 'event_setting' => $event ? $event->getIsFreeForCommunity() : 'no event',
  1458.             ]);
  1459.             
  1460.             if ($isFreeForCommunity) {
  1461.                 $communityTags = ['#physical-member', '#community-member', '#can-get-transponder'];
  1462.                 $memberTags = $member->getTags() ?? '';
  1463.                 
  1464.                 foreach ($communityTags as $tag) {
  1465.                     if (str_contains($memberTags, $tag)) {
  1466.                         $this->session->getFlashBag()->add('notice', 
  1467.                             "SUCCESS: Du bist Community-Mitglied und kannst kostenlos teilnehmen");
  1468.                         $this->logger->info('Payment exception granted: Community member', [
  1469.                             'member_id' => $member->getId(),
  1470.                             'matched_tag' => $tag
  1471.                         ]);
  1472.                         return false; // no payment necessary for community members
  1473.                     }
  1474.                 }
  1475.             }
  1477.             if ($event && isset($settings['freeIfTagMatches'])) {
  1478.                 if (str_contains($member->getTags() ?? '', $settings['freeIfTagMatches'])) {
  1479.                     $tagName = str_replace('#', '', $settings['freeIfTagMatches']); // Entferne '#' falls vorhanden
  1480.                     $this->session->getFlashBag()->add('notice', "SUCCESS Du bist Mitglied und in unserer Datenbank mit dem Tag {$tagName} vermerkt und kannst daher kostenlos teilnehmen");
  1481.                     return false; // no payment necessary for members with matching tag
  1482.                 }
  1483.             }
  1485.             if ($application->getHasVolunteerAgreed()) {
  1486.                 $this->session->getFlashBag()->add('notice', "SUCCESS Du bist als Volunteer angemeldet und kannst kostenlos teilnehmen");
  1487.                 return false; // no payment necessary for volunteers
  1488.             }
  1489.             if ($application->getDiscountPercent() == 100) {
  1490.                 $this->session->getFlashBag()->add('notice', "SUCCESS Du hast einen 100% Discount Code und kannst kostenlos teilnehmen");
  1491.                 return false; // no payment necessary with 100% discount
  1492.             }
  1493.         }
  1494.         $this->logger->info('checkPaymentException: Payment required', [
  1495.             'member_exists' => $member ? true : false,
  1496.             'reason' => 'No payment exception criteria met'
  1497.         ]);
  1498.         return true; // payment necessary for all other cases
  1499.     }
  1501.     /**
  1502.      * @Route("/event-confirmation/{slug}/", name="event_confirmation")
  1503.      */
  1504.     public function eventConfirmationAction(Request $request, $slug)
  1505.     {
  1506.         $em = $this->getDoctrine()->getManager();
  1508.         $event = $this->findEventBySlug($slug);
  1509.         if (!$event) {
  1510.             $this->addFlash('notice', 'ERROR Event not found');
  1511.             return $this->redirectToRoute('events_list');
  1512.         }
  1514.         $seriesEvents = [];
  1515.         if ($seriesTag = $event->getSeriesTag()) {
  1516.             $seriesEvents = $this->getEventRepository()->findBySeriesTag($seriesTag, '', ['startDate' => 'DESC']);
  1517.         }
  1519.         $embed = $request->get('embed');
  1521.         $batch = $em->getRepository(Batch::class)->findOneBy(['programId'=>27, 'eventId'=>$event->getId(), 'status'=>'active', 'access' =>'anonymous']);
  1522.         $program = $batch->getProgram();
  1524.         $action   = $request->get('action');
  1525.         $applicationId = $request->get('app');
  1527.         $route                   = "event_confirmation";
  1528.         $routeParameters["slug"] = $event->getSlug();
  1529.         $settings = [];
  1530.         $member   = false;
  1531.         $application = new Application();
  1533.         // Load application first, then determine language
  1534.         if ($applicationId){
  1535.             if (!$application = $em->getRepository(Application::class)->find($applicationId)){
  1536.                 $this->addFlash('notice', 'ERROR Application with ID '.$applicationId.' not found');
  1537.                 return $this->redirectToRoute('events_list');
  1538.             }
  1539.         }
  1541.         // Language detection: Priority is Application > Event > Default DE
  1542.         // This ensures user's language choice persists through Stripe redirect
  1543.         $lang = ($application && $application->getId() && $application->getLang())
  1544.             ? $application->getLang()
  1545.             : ($event->getLang() ?? 'DE');
  1547.         // Handle action after language is determined
  1548.         if ($applicationId && $action){
  1549.             $application = $this->handleAction($request, $member, $application, $batch, $lang, $route, $routeParameters, $settings);
  1551.             if (is_string($application)) {
  1552.                 // Handle redirect
  1553.                 return $this->redirect($application);
  1554.             }
  1555.         }
  1557.         // Generate the absolute base URL based on the route and parameters
  1558.         $baseURL = $this->generateUrl('event_show_single', ['slug' => $slug], UrlGeneratorInterface::ABSOLUTE_URL);
  1560.         // UTM parameters for the promotion URL
  1561.         $promotionUtmParameters = [
  1562.             'utm_source'   => 'affiliate',
  1563.             'utm_medium'   => is_numeric($application->getMemberId()) ? $application->getMemberId() : '',
  1564.             'utm_campaign' => 'event:' . $event->getId(),
  1565.             'utm_term'     => '',
  1566.             'utm_content'  => '',
  1567.         ];
  1569.         $promotionUrl = $em->getRepository(Batch::class)->generatePromotionUrl($baseURL, $promotionUtmParameters);
  1571.         $view = '@StartPlatzEventBundle/Default/event-confirmation.html.twig';
  1572.         if ($embed){
  1573.             $view = '@StartPlatzEventBundle/Default/event-confirmation.embed.html.twig';
  1574.         }
  1576.         if ($event->getTwigFile() == 'winter-2025' ){
  1577.             $view = '@StartPlatzEventBundle/Default/event-confirmation.winter-2025.html.twig';
  1578.         }
  1580.         if ($event->getTwigFile() == 'style-ecodynamics' ){
  1581.             $view = '@StartPlatzEventBundle/Default/event-confirmation.style-ecodynamics.html.twig';
  1582.         }
  1584.         if ($event->getTwigFile() == 'style-ai-hub' ){
  1585.             $view = '@StartPlatzEventBundle/Default/event-confirmation.style-ai-hub.html.twig';
  1586.         }
  1588.         if ($event->getTwigFile() == 'style-startplatz' ){
  1589.             $view = '@StartPlatzEventBundle/Default/event-confirmation.style-ai-hub.html.twig';
  1590.         }
  1592.         return $this->render($view, [
  1593.             'event'         => $event,
  1594.             'seriesEvents'  => $seriesEvents,
  1596.             'promotionUrl'   => $promotionUrl,
  1598.             'batch'          => $batch,
  1599.             'settings'       => $settings,
  1600.             'application'    => $application,
  1601.             'action'         => $action,
  1602.             'member'         => $member,
  1604.             'speakers'       => $this->getSpeakers($event),
  1605.             'phrases'        => $em->getRepository(Option::class)->getApplicationPhrases($program, $batch, false, $lang),
  1607.             'templateVars'   => [],
  1608.             'embed'          => $embed,
  1610.             'menuLinksAndPhrases' => $this->menuTranslationService->getMenuLinksAndPhrases($request->server->get('REQUEST_URI')),
  1611.             'lang'            => $lang,
  1612.             'isMultiBatchEvent' => $event->isMultiBatchEvent(),
  1613.         ]);
  1615.     }
  1617.     /**
  1618.      * @Route("/event/{slug}/", name="event_show_single")
  1619.      * @Route("/event/{slug}/{date}", name="event_show_single_by_date", requirements={"date"="\d{4}-\d{2}-\d{2}"})
  1620.      */
  1621.     public function eventSingleAction(Request $request, $slug, $date = null)
  1622.     {
  1623.         ##event-single
  1624.         if ($slug == 'ai-bootcamp-koeln-2024-01-18') return $this->redirect( $this->generateUrl('event_show_single', array('slug' => 'ai-bootcamp-koeln-2024-01-29')) );
  1625.         if ($slug == 'ai-summer-school-koeln-2208') return $this->redirect( $this->generateUrl('event_show_single', array('slug' => 'ai-bootcamp-koeln-1109')) );
  1626.         if ($slug == 'ai-summer-school-duesseldorf-2908') return $this->redirect( $this->generateUrl('event_show_single', array('slug' => 'ai-bootcamp-duesseldorf-2609')) );
  1627.         if ($slug == 'ai-disruptme-marketing-in-unternehmen-koeln-2023-10-19') return $this->redirect( $this->generateUrl('event_show_single', array('slug' => 'ai-disruptme-marketing-in-unternehmen-koeln-2024-01-31')) );
  1628.         if ($slug == 'ai-disruptme-publisher-koeln-2023-10-18') return $this->redirect( $this->generateUrl('event_show_single', array('slug' => 'ai-disruptme-publisher-duesseldorf-2024-03-20')) );
  1629.         if ($slug == 'ai-disruptme-travel-tourismus-duesseldorf-2023-11-09') return $this->redirect( $this->generateUrl('event_show_single', array('slug' => 'ai-disruptme-travel-tourismus-duesseldorf-2024-02-22')) );
  1630.         if ($slug == 'genai-ki-app-no-code-backend-fuer-ki-anwendung-2024-05-28') return $this->redirect( $this->generateUrl('event_show_single', array('slug' => 'genai-ki-anwendung-bauen-frontend-ux-ui-2024-05-21')) );
  1631.         if ($slug == 'ai-barcamp-generative-ki') return $this->redirect( $this->generateUrl('event_show_single', array('slug' => 'ai-barcamp-logistik')) );
  1632.         if ($slug == 'genai-generative-ki-zertifikat-ki-kompetenz-erwerben-2025-05-20') return $this->redirect( $this->generateUrl('event_show_single', array('slug' => 'ki-kompetenzpflicht-zertifikat-artikel-4-2025-05-20')) );
  1635.         // Retrieve the UTM parameters from the URL
  1636.         $utmParameters = [
  1637.             'utmSource'   => $request->query->get('utm_source') ?? 'homepage',
  1638.             'utmMedium'   => $request->query->get('utm_medium'),
  1639.             'utmCampaign' => $request->query->get('utm_campaign'),
  1640.             'utmTerm'     => $request->query->get('utm_term'),
  1641.             'utmContent'  => $request->query->get('utm_content'),
  1642.         ];
  1644.         $em = $this->getDoctrine()->getManager();
  1646.         /** @var Event $event */
  1647.         $event = $this->findEventBySlug($slug);
  1648.         if (!$event) {
  1649.             $this->addFlash('notice', 'ERROR Veranstaltung nicht gefunden');
  1650.             return $this->redirectToRoute('events_list');
  1651.         }
  1653.         // Handle event visibility: redirect if not published or previewed without user session.
  1654.         $response = $this->handleEventStatus($event, $request);
  1655.         if ($response) {
  1656.             return $response;
  1657.         }
  1659.         $seriesEvents = [];
  1660.         if ($seriesTag = $event->getSeriesTag()) {
  1661.             $seriesEvents = $this->getEventRepository()->findBySeriesTag($seriesTag, '', ['startDate' => 'DESC']);
  1662.         }
  1664.         // Language detection with priority: URL parameter > Event default
  1665.         // This ensures ?lang=en parameter works for bilingual events
  1666.         $lang = strtoupper($request->query->get('lang', '')) ?: ($event->getLang() ?? 'DE');
  1668.         $embed = $request->get('embed');
  1670.         $eventbriteId   = $event->getEventbriteId();
  1671.         $isEventbriteOnly = $event->getTicketing() > '';
  1672.         $applicationUrl = $event->getApplicationUrl();
  1673.         
  1674.         // Multi-batch aware logic
  1675.         $futureBatches = [];
  1676.         $allBatches = [];
  1677.         
  1678.         if ($event->isMultiBatchEvent()) {
  1679.             $allBatches = $em->getRepository(Batch::class)->findAllBatchesByEvent($event);
  1680.             
  1681.             if ($date) {
  1682.                 // User selected a specific date
  1683.                 $batch = $em->getRepository(Batch::class)->findBatchByEventAndDate($event, $date);
  1684.                 if (!$batch) {
  1685.                     // Invalid date, redirect to main event page
  1686.                     $this->addFlash('notice', 'Der gewählte Termin ist nicht verfügbar.');
  1687.                     return $this->redirectToRoute('event_show_single', ['slug' => $slug]);
  1688.                 }
  1689.             } else {
  1690.                 // No date selected, show next upcoming batch
  1691.                 $batch = $em->getRepository(Batch::class)->findNextOpenBatchByEvent($event);
  1692.             }
  1693.             
  1694.             // Get all future batches for the selector
  1695.             $futureBatches = $em->getRepository(Batch::class)->findFutureBatchesByEvent($event, 10);
  1697.             // Get past batches for archive display
  1698.             $pastBatches = $em->getRepository(Batch::class)->findPastBatchesByEvent($event, 10);
  1699.         } else {
  1700.             // Single batch event - keep existing logic
  1701.             // Try to find active batch first, then fall back to completed batch for display
  1702.             $batch = $em->getRepository(Batch::class)->findOneBy(['programId'=>27, 'eventId'=>$event->getId(), 'status'=>'active', 'access' =>'anonymous']);
  1703.             if (!$batch) {
  1704.                 // No active batch found, look for completed batch (for past events that need to display)
  1705.                 $batch = $em->getRepository(Batch::class)->findOneBy(['programId'=>27, 'eventId'=>$event->getId(), 'status'=>'completed', 'access' =>'anonymous']);
  1706.             }
  1707.             if ($batch) {
  1708.                 $allBatches = [$batch];
  1709.             }
  1710.         }
  1711.         
  1712.         $batchIsOpen = $batch && $em->getRepository(Batch::class)->isBatchApplicationOpen($batch);
  1714.         $form    = null;
  1715.         $program = null;
  1716.         $application = null;
  1717.         $product     = null;
  1718.         $editFeedback = "";
  1719.         $settings     = [];
  1720.         $action       = "";
  1721.         $customersArr = [];
  1723.         $member = null;
  1724.         /** @var User $user */
  1725.         if ($user = $this->getUser()) {
  1726.             $member = $em->getRepository(Member::class)->find($user->getMemberId());
  1727.         }
  1729.         if ($batch && !$isEventbriteOnly) {
  1730.             $program = $batch->getProgram();
  1731.         }
  1733.         if ($batchIsOpen && !$isEventbriteOnly) {
  1734.             $settings = $this->getProgramSettings($program, $batch);
  1735.             $batch = $em->getRepository(Batch::class)->updateNumbers($batch);
  1737.             $action   = $request->get('action');
  1738.             $referral = $request->get('referral');
  1740.             // do some exceptions
  1741.             if ($member && isset($settings['batchType'])) {
  1742.                 if ($settings['batchType'] == 'memberDocumentation'){
  1743.                     // check if member
  1745.                     if ($em->getRepository(Application::class)->findApplicationsByAiFridayBatchSlugAndMemberId($member->getId()))
  1746.                     {
  1747.                         if (!$em->getRepository(Application::class)->findOneBy(['memberId'=>$member->getId(), 'batchId' => $batch->getId()])){
  1749.                             $memberTeam  = $em->getRepository(Team::class)->find($member->getTeamId());
  1750.                             $adminEmail  = $member->getEmail();
  1751.                             $application = $em->getRepository(Application::class)->createApplicationIfNotExists($program, $batch, $memberTeam, $member, $adminEmail);
  1752.                             $application->setBatchStatus('applicant');
  1753.                             $application->setApplicationStatus('applied');
  1755.                             $em->persist($application);
  1756.                             $em->flush();
  1757.                             $batch = $em->getRepository(Batch::class)->updateNumbers($batch);
  1759.                         }
  1760.                     }
  1761.                 }
  1762.             }
  1764.             $application = $this->getOrCreateApplication($request, $batch, $program, $member, $lang, $settings, $utmParameters, $event);
  1766.             if ($referral && $application->getRealPriceinEuroCent() > 0) {
  1767.                 if ($recommendedByMember = $em->getRepository(Member::class)->find($referral)) {
  1768.                     if ($neededTag = $settings['isRecommendedBy'] ?? '') {
  1769.                         if (Utility::contains($recommendedByMember->getTags(), $neededTag)) {
  1770.                             $application->setRealPriceinEuroCent(0);
  1771.                             $application->setDiscountReason("geworben durch {$recommendedByMember->getName()}");
  1772.                             $application->setDiscountPercent(100);
  1773.                         }
  1774.                     }
  1775.                 }
  1776.             }
  1778.             if ($user && in_array($action, ["needsloginvalidation", "needsemailverification"])) {
  1779.                 $response = $this->validateEventApplication($application, $member, $settings, $batch, $lang);
  1780.                 $application = $response['data']['application'];
  1781.             }
  1783.             // Only check for Monsum product if we're not using Stripe
  1784.             $hasStripeConfig = ($batch && $batch->getStripePriceId()) || ($event && $event->getStripePriceId());
  1785.             
  1786.             if ($batch->getPriceInEuroCent() > 0 && $batch->getProductId() && !$hasStripeConfig) {
  1787.                 if (!$product = $em->getRepository(Product::class /*Product Member*/)->find($batch->getProductId())) {
  1788.                     $this->session->getFlashBag()->add('notice', 'ERROR configuration not found');
  1789.                     return $this->redirect($this->generateUrl('events_list'));
  1790.                 }
  1791.             }
  1793.             $form = $this->createForm(ApplicationType::class, $application, [
  1794.                 'settings' => $settings,
  1795.                 'program' => $program,
  1796.                 'batch' => $batch,
  1797.                 'csrf_protection' => $embed ? false : true,
  1798.                 ]);
  1800.             $form->handleRequest($request);
  1801.             ##############################################################
  1802.             ##   form validation starts here                            ##
  1803.             ##############################################################
  1804.             if ($form->isSubmitted() && $form->isValid()) {
  1806.                 $application = $em->getRepository(Application::class)->cleanApplicationData($application);
  1807.                 $adminEmail = $application->getEmail();
  1809.                 $email = $application->getEmail();
  1811.                 if (!Utility::validateEmail($email)){
  1812.                     $this->addFlash('notice', 'ERROR Incorrect email adress. Please check your email adress!');
  1813.                 } else {
  1815.                     // maxApplicants
  1816.                     if (isset($settings['maxApplicants'])) {
  1817.                         $applicants = $em->getRepository(Application::class)->findBy(['batchId' => $batch->getId(), 'applicationStatus' => 'applied']);
  1818.                         $currentApplicantsCount = count($applicants);
  1819.                         if ($currentApplicantsCount >= $settings['maxApplicants']) {
  1820.                             $this->addFlash('notice', 'ERROR Leider sind alle verfügbaren Plätze bereits vergeben.');
  1821.                             return $this->redirectToRoute('event_show_single', ['slug' => $slug]);
  1822.                         }
  1823.                     }
  1825.                     // isErrorDetectionOn
  1826.                     if (isset($settings['isErrorDetectionOn']) and $settings['isErrorDetectionOn']) {
  1827.                         $this->addFlash('notice', 'ERROR There was a problem in processing your application. Please contact support@startplatz.de');
  1828.                         return $this->redirectToRoute('event_show_single', ['slug' => $slug]);
  1829.                     }
  1831.                     if ($member) {
  1832.                         $memberToBeRegistered = $member;
  1833.                         $isExistingMember = true;
  1834.                     } else {
  1835.                         $response = $this->processRegistrationCheckMembershipExistence($application);
  1836.                         $isExistingMember = $response['data']['isExistingMember'];
  1837.                         $memberToBeRegistered = $response['data']['memberToBeRegistered'];
  1838.                     }
  1839.                     $memberToBeRegistered->setIsExistingMember($isExistingMember);
  1841.                     // fill application with memberId and teamId and discount information
  1842.                     $application = $this->updateApplicationWithMemberIdAndTeamId($application, $memberToBeRegistered, $batch);
  1844.                     if (!$batch->isMultipleApplicationsPerMember()) {
  1845.                         // check if there is already an application to this event == batch with that batchId and memberId
  1846.                         if ($existingApplication = $em->getRepository(Application::class)->findOneBy(['batchId' => $batch->getId(), 'memberId' => $memberToBeRegistered->getId()])) {
  1847.                             // there are two applications - the latest application will always win
  1848.                             $fields = Utility::getEntityFieldsArray($application, ['id', 'assessments', 'votesRegistered', 'applicationStatus', 'editStatus', 'editMessage', 'lastChangeUser', 'history', 'extraFields', 'lastModified', 'createdAt']);
  1849.                             $storedData = Utility::fillDataByObject($existingApplication, $fields);
  1850.                             $updatedData = Utility::fillDataByObject($application, $fields);
  1852.                             $differences = array_diff_assoc($updatedData, $storedData);
  1853.                             $application = $existingApplication;
  1854.                             $application = $this->updateApplication($application, $differences);
  1856.                             $application->setIsExistingApplication(true);
  1857.                         }
  1858.                     }
  1860.                     if (isset($settings['extraFields'])) {
  1861.                         $application = $this->getExtraFieldsData($application, $settings, $form);
  1862.                     }
  1864.                     $isPaidEvent = $this->checkPaidEvent($application, $batch, $event);
  1866.                     // Debug logging for ki-campus payment exception
  1867.                     $this->logger->info('Payment exception check', [
  1868.                         'member_exists' => $member ? true : false,
  1869.                         'member_id' => $member ? $member->getId() : null,
  1870.                         'member_email' => $member ? $member->getEmail() : null,
  1871.                         'member_tags' => $member ? $member->getTags() : null,
  1872.                         'memberToBeRegistered_id' => $memberToBeRegistered->getId(),
  1873.                         'memberToBeRegistered_email' => $memberToBeRegistered->getEmail(),
  1874.                         'memberToBeRegistered_tags' => $memberToBeRegistered->getTags(),
  1875.                         'batch_isFreeForKiCampus' => $batch ? $batch->getIsFreeForKiCampus() : null,
  1876.                         'event_isFreeForKiCampus' => $event ? $event->getIsFreeForKiCampus() : null,
  1877.                     ]);
  1878.                     
  1879.                     // Always use memberToBeRegistered for payment exception check
  1880.                     $hasToPay = $this->checkPaymentException($application, $memberToBeRegistered, $event, $settings, $batch);
  1882.                     if ($isPaidEvent && $hasToPay) {
  1883.                         $application = $this->updateApplicationWithStepOneInformation($application, $memberToBeRegistered, $event);
  1884.                         
  1885.                         // Always use batch payment settings first
  1886.                         $stripePriceId = null;
  1887.                         $stripeAccount = null;
  1888.                         
  1889.                         if ($batch) {
  1890.                             // Use batch-specific Stripe settings
  1891.                             $stripePriceId = $batch->getStripePriceId();
  1892.                             $stripeAccount = $batch->getStripeAccount();
  1893.                         }
  1894.                         
  1895.                         // Legacy fallback to event settings if batch has no payment info
  1896.                         if (!$stripePriceId && $event) {
  1897.                             $stripePriceId = $event->getStripePriceId();
  1898.                         }
  1899.                         if (!$stripeAccount && $event) {
  1900.                             $stripeAccount = $event->getStripeAccount();
  1901.                         }
  1902.                         
  1903.                         if ($stripePriceId > '') {
  1904.                             // Application in Datenbank schreiben, sonst kann im nächsten Schritt keine appId übergeben werden
  1906.                             $application = $em->getRepository(Application::class)->setApplication($application);
  1908.                             $clientReferenceId = $memberToBeRegistered->getId();
  1909.                             $clientEmail = $memberToBeRegistered->getEmail();
  1911.                             $successUrlParameters = [
  1912.                                 'slug' => $event->getSlug(),
  1913.                                 'app' => $application->getId(),
  1914.                                 'action' => "checkSuccess",
  1915.                                 'provider' => 'stripe',
  1916.                                 'embed' => $embed,
  1917.                             ];
  1918.                             $route = 'event_confirmation';
  1920.                             $successPage = $this->generateUrl($route, $successUrlParameters, UrlGeneratorInterface::ABSOLUTE_URL);
  1921.                             //$successUrl = urlencode($successPage);
  1922.                             $successUrl = $successPage;
  1924.                             // Check STRIPE_MODE first, fallback to APP_ENV for backwards compatibility
  1925.                             $stripeMode = $_ENV['STRIPE_MODE'] ?? ($_ENV['APP_ENV'] === 'prod' ? 'live' : 'test');
  1926.                             $isLiveEnvironment = $stripeMode === 'live';
  1927.                             $stripeAccount = $stripeAccount ?: "STARTPLATZ";
  1928.                             $stripeApiKey  = $em->getRepository(Option::class)->getStripeApiKey($stripeAccount, $isLiveEnvironment);
  1929.                             
  1930.                             // In dev environment, use a test price ID instead of live one
  1931.                             if (!$isLiveEnvironment && $stripePriceId && strpos($stripePriceId, '_test_') === false) {
  1932.                                 // This is a live price ID in test mode - use a generic test price
  1933.                                 $originalPriceId = $stripePriceId;
  1934.                                 $stripePriceId = 'price_1RnzWKHegJLrFARi6RzQ9D8Q'; // Generic test price for 90 EUR
  1935.                                 
  1936.                                 // Log the mapping
  1937.                                 file_put_contents('/var/www/html/var/log/stripe_debug_controller.log', 
  1938.                                     date('Y-m-d H:i:s') . " - Mapped live price $originalPriceId to test price $stripePriceId\n", 
  1939.                                     FILE_APPEND);
  1940.                             }
  1942.                             // Generate cancel URL - back to the event page
  1943.                             $cancelUrl = $this->generateUrl('event_show_single', ['slug' => $event->getSlug()], UrlGeneratorInterface::ABSOLUTE_URL);
  1944.                             
  1945.                             // Debug logging
  1946.                             $debugInfo = [
  1947.                                 'stripePriceId' => $stripePriceId,
  1948.                                 'clientReferenceId' => $clientReferenceId,
  1949.                                 'clientEmail' => $clientEmail,
  1950.                                 'stripeAccount' => $stripeAccount,
  1951.                                 'successUrl' => $successUrl,
  1952.                                 'cancelUrl' => $cancelUrl,
  1953.                                 'isLiveEnvironment' => $isLiveEnvironment,
  1954.                             ];
  1955.                             file_put_contents('/var/www/html/var/log/stripe_debug_controller.log', 
  1956.                                 date('Y-m-d H:i:s') . " - Payment parameters: " . json_encode($debugInfo, JSON_PRETTY_PRINT) . "\n", 
  1957.                                 FILE_APPEND);
  1959.                             $paymentLink = $this->callbackService->curl_stripe_paymentlink($stripePriceId, $clientReferenceId, $clientEmail, $stripeApiKey, $successUrl, $cancelUrl);
  1960.                             // Überprüfen, ob die Antwort ein gültiger Zahlungslink ist
  1961.                             if (filter_var($paymentLink, FILTER_VALIDATE_URL)) {
  1962.                                 // Erfolgsfall: Weiterleitung des Benutzers zum Zahlungslink oder Anzeigen des Links
  1963.                                 // Zum Beispiel könnten Sie den Benutzer weiterleiten:
  1964.                                 // Note: Stripe payment links handle email prefilling differently
  1965.                                 // The email is already passed during payment link creation
  1966.                                 // Adding parameters to the URL can break the payment link
  1967.                                 if ($user && $user->getIsAdmin()) {
  1968.                                     $this->session->getFlashBag()->add('notice', "SUCCESS paymentLink: {$paymentLink}");
  1969.                                 }
  1970.                                 $mailContent = [
  1971.                                     'applicationId' => $application->getId(),
  1972.                                     'memberId' => $application->getMemberId(),
  1973.                                     'editStatus' => $application->getEditStatus(),
  1974.                                     'applicationStatus' => $application->getApplicationStatus(),
  1975.                                     'person' => $application->getPerson(),
  1976.                                     'email' => $application->getEmail(),
  1977.                                     'utmSource' => $application->getUtmSource(),
  1978.                                     'eventTitle' => $event->getTitle(),
  1979.                                     'eventSlug' => $event->getSlug(),
  1980.                                 ];
  1981.                                 $response = Utility::sendDirectMail($this->mailer, "stripe {$event->getId()} step one {$application->getId()} {$application->getEmail()}", 'support@startplatz.de', 'Monitoring Stripe', 'lorenz.graef@startplatz.de', 'Lorenz', print_r($mailContent,true), false);
  1983.                                 // call stripe and let applicant pay for the ticket
  1984.                                 if ($embed){
  1985.                                     return $this->render('@StartPlatzEventBundle/Default/iframe_redirect.html.twig', [
  1986.                                         'targetUrl' => $paymentLink
  1987.                                     ]);
  1988.                                 } else {
  1989.                                     return $this->redirect($paymentLink);
  1990.                                 }
  1991.                             } else {
  1992.                                 // Fehlerfall: Anzeigen der Fehlermeldung
  1993.                                 // Loggen der Fehlermeldung oder Anzeigen einer Fehlerseite
  1994.                                 // Zum Beispiel könnten Sie eine Fehlerseite rendern:
  1995.                                 $this->session->getFlashBag()->add('notice', "ERROR paymentLink: {$paymentLink}");
  1996.                                 $paymentLink = false;
  1997.                             }
  1999.                         } else {
  2000.                             // falls es bereits einen zugänglichen Monsum Account für diese Person gibt
  2001.                             if ($product) {
  2002.                                 $customersArr = $em->getRepository(Customer::class)->findValidMonsumCustomersByMemberAndAccount($memberToBeRegistered, $product->getAccount(), false);
  2003.                             }
  2004.                         }
  2005.                         // Application in Datenbank schreiben, sonst kann im nächsten Schritt keine appId übergeben werden
  2006.                         $application = $em->getRepository(Application::class)->setApplication($application);
  2007.                     } else {
  2008.                         $route = 'event_show_single';
  2009.                         $routeParameters = $request->get('_route_params');
  2010.                         if (!array_key_exists('slug', $routeParameters)) {
  2011.                             $routeParameters['slug'] = $event->getSlug();
  2012.                         }
  2014.                         $response = $this->processRegistrationWithoutPaymentSimpleOptimized($isExistingMember, $user, $memberToBeRegistered, $application, $settings, $lang, $adminEmail, $batch, $route, $routeParameters);
  2016.                         if ($response['status'] == 'error') {
  2017.                             $targetPath = $response['data']['targetPath'];
  2018.                             return $this->redirect($targetPath);
  2019.                         }
  2020.                         $application = $response['data']['application'];
  2021.                         $member = $response['data']['member'];
  2023.                         if ($this->shouldSetAiHubMembership($settings, $application->getApplicationStatus())) {
  2024.                             $aiHubStatus = $settings["setAiHubMembership"];
  2025.                             $service = $this->configureServiceForAiHub($aiHubStatus, $event->getStartDate());
  2027.                             $reason = "participated in event with id={$event->getId()} and title={$event->getTitle()}";
  2028.                             $em->getRepository(Member::class)->setAiHubMembership($service, $member, $reason);
  2029.                         }
  2030.                     }
  2031.                 }
  2032.             }
  2034.         }
  2036.         $promotionUrl = null;
  2037.         if ($user && $batch) {
  2038.             // Generate the absolute base URL based on the route and parameters
  2039.             $baseURL = $this->generateUrl('event_show_single', ['slug' => $slug], UrlGeneratorInterface::ABSOLUTE_URL);
  2041.             // UTM parameters for the promotion URL
  2042.             $promotionUtmParameters = [
  2043.                 'utm_source' => 'affiliate',
  2044.                 'utm_medium' => $member->getId(),
  2045.                 'utm_campaign' => 'event:' . $event->getId(),
  2046.                 'utm_term'     => '',
  2047.                 'utm_content'  => '',
  2048.             ];
  2050.             $promotionUrl = $em->getRepository(Batch::class)->generatePromotionUrl($baseURL, $promotionUtmParameters);
  2051.         }
  2053.         // Überprüfen Sie den Wert des Teaserfeldes, um showTeaser zu setzen
  2054.         $showTeaser = !empty($event->getTeaser());
  2056.         $paymentLink = false;
  2058.         $view = '@StartPlatzEventBundle/Default/event-single.html.twig';
  2059.         if ($event->isSinglePage() or $embed){
  2060.             $view = '@StartPlatzEventBundle/Default/event-single.lp.html.twig';
  2061.         }
  2063.         if ($event->getTwigFile() == 'winter-2025' ){
  2064.             $view = '@StartPlatzEventBundle/Default/event-single.winter-2025.html.twig';
  2065.         }
  2067.         if ($event->getTwigFile() == 'style-ecodynamics' ){
  2068.             $view = '@StartPlatzEventBundle/Default/event-single.style-ecodynamics.html.twig';
  2069.         }
  2071.         if ($event->getTwigFile() == 'style-ai-hub' ){
  2072.             $view = '@StartPlatzEventBundle/Default/event-single.style-ai-hub.html.twig';
  2073.         }
  2075.         if ($event->getTwigFile() == 'style-startplatz' ){
  2076.             $view = '@StartPlatzEventBundle/Default/event-single.style-ai-hub.html.twig';
  2077.         }
  2081.         return $this->render($view, [
  2082.             'event'         => $event,
  2083.             'seriesEvents'  => $seriesEvents,
  2084.             'showTeaser'    => $showTeaser,
  2086.             'utmParameters'  => $utmParameters,
  2087.             'promotionUrl'   => $promotionUrl,
  2088.             'eventbriteId'   => $eventbriteId,
  2089.             'isEventbriteOnly' => $isEventbriteOnly,
  2090.             'applicationUrl' => $applicationUrl,
  2091.             'batch'          => $batch,
  2092.             'settings'       => $settings,
  2093.             'form'           => $form ? $form->createView() : $form,
  2094.             'application'    => $application,
  2095.             'action'         => $action,
  2096.             'batchIsOpen'    => $batchIsOpen,
  2097.             'customersArr'   => $customersArr,
  2098.             'member'         => $member,
  2099.             'paymentLink'    => $paymentLink,
  2100.             
  2101.             // Multi-batch event support
  2102.             'futureBatches'  => $futureBatches,
  2103.             'pastBatches'    => $pastBatches ?? [],
  2104.             'allBatches'     => $allBatches,
  2105.             'selectedDate'   => $date,
  2106.             'isMultiBatchEvent' => $event->isMultiBatchEvent(),
  2108.             'speakers'       => $this->getSpeakers($event),
  2109.             'phrases'        => $em->getRepository(Option::class)->getApplicationPhrases($program, $batch, false, $lang),
  2111.             'editFeedback'   => $editFeedback,
  2112.             'templateVars'   => [],
  2114.             'preview'             => $request->get('preview'),
  2115.             'menuLinksAndPhrases' => $this->menuTranslationService->getMenuLinksAndPhrases($request->server->get('REQUEST_URI')),
  2116.             'lang'           => $lang,
  2117.             'isEnglish'      => $lang === 'EN',
  2118.             'embed'          => $embed,
  2119.             'targetRoute'     => "event_show_single",
  2120.             'targetRouteSlug' => $event->getSlug(),
  2121.         ]);
  2123.     }
  2125.     /**
  2126.      * @Route("/api/event/participant-by-linkedin", name="add_participant-by-linkedin", methods={"POST"})
  2127.      * */
  2128.     public function addParticipantByLinkedIn(Request $request)
  2129.     {
  2130.         $authorizedIdentifier = 'IhrGeheimerIdentifier'; // Set your identifier here
  2132.         // Check the identifier
  2133.         if ($request->headers->get('X-CUSTOM-IDENTIFIER') !== $authorizedIdentifier) {
  2134.             //return new Response('Unauthorized', Response::HTTP_UNAUTHORIZED);
  2135.         }
  2137.         $data = json_decode($request->getContent(), true);
  2139.         $em = $this->getDoctrine()->getManager();
  2141.         if (empty($data['email'])) {
  2142.             return new Response('Required data missing: email', Response::HTTP_BAD_REQUEST);
  2143.         }
  2145.         if (empty($data['formName'])) {
  2146.             return new Response('Required data missing: formName', Response::HTTP_BAD_REQUEST);
  2147.         }
  2149.         // Retrieve the UTM parameters from the URL
  2151.         $utmParameters = [
  2152.             'utmSource'   => $data['utmSource'] ?? null,
  2153.             'utmMedium'   => $data['utmMedium'] ?? null,
  2154.             'utmCampaign' => $data['utmCampaign'] ?? null,
  2155.             'utmTerm'     => $data['utmTerm'] ?? null,
  2156.             'utmContent'  => $data['utmContent'] ?? null,
  2157.         ];
  2160.         $formName = $data['formName'];
  2161.         // contains eventTitle
  2162.         // search for event with event Titel latest startDate
  2164.         if (!$event = $em->getRepository(Event::class)->findOneBy(['title'=>$formName], ['startDate'=>'DESC'])) {
  2165.             return new Response('Event not found', Response::HTTP_NOT_FOUND);
  2166.         }
  2167.         $eventId = $event->getId();
  2170.         if (!$batch = $em->getRepository(Batch::class)->findOneBy(['eventId' => $eventId],['start'=>'DESC'])) {
  2171.             return new Response('Associated batch with event ID not found', Response::HTTP_NOT_FOUND);
  2172.         }
  2174.         if (!$em->getRepository(Batch::class)->isBatchApplicationOpen($batch)) {
  2175.             return new Response('Batch application is closed', Response::HTTP_FORBIDDEN);
  2176.         }
  2178.         $member = $em->getRepository(Member::class)->createGuestMemberIfNotExists($data, false,$data['email'], "MA");
  2180.         if (empty($member->getPhone()) && !empty($data['phone'])) {
  2181.             $phone = Utility::cleanAndFormatPhoneNumber($data['phone']);
  2182.             $member = $em->getRepository(Member::class)->setPhone($member, $phone, $member->getEmail());
  2183.         }
  2185.         /** @var Application $application */
  2186.         $application = $em->getRepository(Application::class)->findOneBy(['batchId' => $batch->getId(), 'memberId' => $member->getId()]);
  2188.         if (!$application) {
  2189.             $application = $em->getRepository(Application::class)->createApplicationByApplyForm(
  2190.                 $batch->getProgram(),
  2191.                 $batch,
  2192.                 false,
  2193.                 [],
  2194.                 $utmParameters
  2195.             );
  2196.         }
  2200.         $application = $em->getRepository(Application::class)->updateApplicationByMember($application, $member);
  2202.         $application->setHasNewsletterPermissionGiven(1);
  2204.         $extraFields['jobTitle'] = $data['jobTitle'] ?? 'n.a.';
  2205.         $extraFields['company'] = $data['company'] ?? 'n.a.';
  2206.         $extraFields['country'] = $data['country'] ?? 'n.a.';
  2208.         if ($extraFields) {
  2209.             $application->setExtraFields(json_encode($extraFields)) ;
  2210.         }
  2212.         $application = $em->getRepository(Application::class)->setApplicationApplied($application, $member);
  2214.         $this->sendConfirmationMailToApplicant(null, $member, null, $application, $batch);
  2216.         return new Response('Participant added', Response::HTTP_CREATED);
  2217.     }
  2219.     /**
  2220.      * @Route("/api/event/participant-by-facebook", name="add_participant-by-facebook", methods={"POST"})
  2221.      * @Route("/api/event/participant-by-tiktok", name="add_participant-by-tiktok", methods={"POST"})
  2222.      * */
  2223.     public function addParticipantByFacebook(Request $request)
  2224.     {
  2225.         set_time_limit(0);
  2226.         $authorizedIdentifier = 'IhrGeheimerIdentifier'; // Set your identifier here
  2227.         $em = $this->getDoctrine()->getManager();
  2228.         
  2229.         try {
  2230.             // Check the identifier
  2231.             if ($request->headers->get('X-CUSTOM-IDENTIFIER') !== $authorizedIdentifier) {
  2232.                 //return new JsonResponse(['error' => 'Unauthorized'], Response::HTTP_UNAUTHORIZED);
  2233.             }
  2235.             // Parse and validate JSON payload
  2236.             $data = json_decode($request->getContent(), true);
  2237.             if (json_last_error() !== JSON_ERROR_NONE) {
  2238.                 return new JsonResponse([
  2239.                     'error' => 'Invalid JSON payload',
  2240.                     'details' => json_last_error_msg()
  2241.                 ], Response::HTTP_BAD_REQUEST);
  2242.             }
  2244.             // Validate required fields
  2245.             if (empty($data['email'])) {
  2246.                 return new JsonResponse([
  2247.                     'error' => 'Required data missing: email',
  2248.                     'field' => 'email'
  2249.                 ], Response::HTTP_BAD_REQUEST);
  2250.             }
  2252.             if (empty($data['formName'])) {
  2253.                 return new JsonResponse([
  2254.                     'error' => 'Required data missing: formName',
  2255.                     'field' => 'formName'
  2256.                 ], Response::HTTP_BAD_REQUEST);
  2257.             }
  2259.             // Save raw webhook data for debugging
  2260.             $currentTimestamp = date('Y-m-d_H:i:s');
  2261.             $em->getRepository(Option::class)->createOptionIfNotExists(
  2262.                 'sp.event.api.add-participant-by-facebook.' . $currentTimestamp, 
  2263.                 $request->getContent(), 
  2264.                 'facebook-import'
  2265.             );
  2267.             // Extract UTM parameters
  2268.             $utmParameters = [
  2269.                 'utmSource'   => $data['utmSource'] ?? null,
  2270.                 'utmMedium'   => $data['utmMedium'] ?? null,
  2271.                 'utmCampaign' => $data['utmCampaign'] ?? null,
  2272.                 'utmTerm'     => $data['utmTerm'] ?? null,
  2273.                 'utmContent'  => $data['utmContent'] ?? null,
  2274.             ];
  2276.             // Parse formName safely
  2277.             $formName = $data['formName'];
  2278.             $parts = explode("|", $formName);
  2279.             
  2280.             if (count($parts) < 3) {
  2281.                 return new JsonResponse([
  2282.                     'error' => 'Invalid formName format',
  2283.                     'details' => 'Expected format: "Type | Name | Slug"',
  2284.                     'received' => $formName
  2285.                 ], Response::HTTP_BAD_REQUEST);
  2286.             }
  2288.             // Extract and normalize slug
  2289.             $slug = trim($parts[2], " /");
  2290.             $slug = strtolower($slug);
  2292.             // Begin database transaction
  2293.             $em->getConnection()->beginTransaction();
  2294.             
  2295.             try {
  2296.                 // Find the appropriate event
  2297.                 $event = null;
  2298.                 
  2299.                 // Check if this is a multi-batch/evergreen event
  2300.                 if (str_contains(strtolower($parts[0]), 'evergreen')) {
  2301.                     $now = new \DateTime();
  2302.                     $event = $em->getRepository(Event::class)->findNextEventByPartOfSlug($slug, $now);
  2303.                     
  2304.                     if (!$event) {
  2305.                         throw new \Exception("No upcoming evergreen event found with slug containing: {$slug}");
  2306.                     }
  2307.                 } else {
  2308.                     $event = $em->getRepository(Event::class)->findOneBy(['slug' => $slug]);
  2309.                     
  2310.                     if (!$event) {
  2311.                         throw new \Exception("Event not found with slug: {$slug}");
  2312.                     }
  2313.                 }
  2315.                 // Find the appropriate batch
  2316.                 $batch = null;
  2317.                 
  2318.                 if ($event->getIsMultiBatchEvent()) {
  2319.                     // Multi-batch event: find next open batch
  2320.                     $batch = $em->getRepository(Batch::class)->findNextOpenBatchByEvent($event);
  2321.                     
  2322.                     if (!$batch) {
  2323.                         // Fallback: try to find any open batch
  2324.                         $batches = $em->getRepository(Batch::class)->findBy([
  2325.                             'eventId' => $event->getId(),
  2326.                             'status' => 'active'
  2327.                         ]);
  2328.                         
  2329.                         foreach ($batches as $b) {
  2330.                             if ($em->getRepository(Batch::class)->isBatchApplicationOpen($b)) {
  2331.                                 $batch = $b;
  2332.                                 break;
  2333.                             }
  2334.                         }
  2335.                     }
  2336.                     
  2337.                     if (!$batch) {
  2338.                         throw new \Exception('No open batches available for this multi-batch event');
  2339.                     }
  2340.                 } else {
  2341.                     // Single-batch event
  2342.                     $batch = $em->getRepository(Batch::class)->findOneBy(['eventId' => $event->getId()]);
  2343.                     
  2344.                     if (!$batch) {
  2345.                         throw new \Exception('No batch found for this event');
  2346.                     }
  2347.                 }
  2349.                 // Verify batch is open for registration
  2350.                 if (!$em->getRepository(Batch::class)->isBatchApplicationOpen($batch)) {
  2351.                     throw new \Exception('Registration is closed for this batch');
  2352.                 }
  2354.                 // Create or update member
  2355.                 // Transform data to match expected field names
  2356.                 $memberData = $data;
  2357.                 if (isset($data['firstname'])) {
  2358.                     $memberData['firstName'] = $data['firstname'];
  2359.                 }
  2360.                 if (isset($data['lastname'])) {
  2361.                     $memberData['lastName'] = $data['lastname'];
  2362.                 }
  2363.                 
  2364.                 $member = $em->getRepository(Member::class)->createGuestMemberIfNotExists(
  2365.                     $memberData, 
  2366.                     false, 
  2367.                     $data['email'], 
  2368.                     "MA"
  2369.                 );
  2371.                 // Update phone if provided
  2372.                 if (empty($member->getPhone()) && !empty($data['phone'])) {
  2373.                     $phone = Utility::cleanAndFormatPhoneNumber($data['phone']);
  2374.                     $member = $em->getRepository(Member::class)->setPhone($member, $phone, $member->getEmail());
  2375.                 }
  2377.                 // Check for existing application
  2378.                 $application = $em->getRepository(Application::class)->findOneBy([
  2379.                     'batchId' => $batch->getId(), 
  2380.                     'memberId' => $member->getId()
  2381.                 ]);
  2383.                 // Create new application if needed
  2384.                 if (!$application) {
  2385.                     $application = $em->getRepository(Application::class)->createApplicationByApplyForm(
  2386.                         $batch->getProgram(),
  2387.                         $batch,
  2388.                         false,
  2389.                         [],
  2390.                         $utmParameters
  2391.                     );
  2392.                 } else {
  2393.                     // Log duplicate application attempt
  2394.                     $this->logger->info('Facebook webhook: Duplicate application attempt', [
  2395.                         'email' => $data['email'],
  2396.                         'eventSlug' => $slug,
  2397.                         'batchId' => $batch->getId()
  2398.                     ]);
  2399.                 }
  2401.                 // Update application with member data
  2402.                 $application = $em->getRepository(Application::class)->updateApplicationByMember($application, $member);
  2403.                 $application->setHasNewsletterPermissionGiven(1);
  2404.                 $application = $em->getRepository(Application::class)->setApplicationApplied($application, $member);
  2406.                 // Commit transaction before sending emails
  2407.                 $em->getConnection()->commit();
  2409.                 // Send confirmation email (includes HubSpot sync)
  2410.                 // Disable newsletter registration for Facebook webhook participants
  2411.                 try {
  2412.                     $this->sendConfirmationMailToApplicant(null, $member, null, $application, $batch, false);
  2413.                 } catch (\Exception $emailException) {
  2414.                     // Log email error but don't fail the webhook
  2415.                     $this->logger->error('Facebook webhook: Failed to send confirmation email', [
  2416.                         'error' => $emailException->getMessage(),
  2417.                         'memberId' => $member->getId(),
  2418.                         'applicationId' => $application->getId()
  2419.                     ]);
  2420.                 }
  2422.                 // Return success with details
  2423.                 return new JsonResponse([
  2424.                     'status' => 'success',
  2425.                     'message' => 'Participant added successfully',
  2426.                     'data' => [
  2427.                         'memberId' => $member->getId(),
  2428.                         'applicationId' => $application->getId(),
  2429.                         'eventId' => $event->getId(),
  2430.                         'eventSlug' => $event->getSlug(),
  2431.                         'batchId' => $batch->getId(),
  2432.                         'batchDate' => $batch->getStartDate() ? $batch->getStartDate()->format('Y-m-d') : null
  2433.                     ]
  2434.                 ], Response::HTTP_CREATED);
  2435.                 
  2436.             } catch (\Exception $e) {
  2437.                 // Rollback transaction on error
  2438.                 $em->getConnection()->rollback();
  2439.                 throw $e;
  2440.             }
  2441.             
  2442.         } catch (\Exception $e) {
  2443.             // Log the error
  2444.             $this->logger->error('Facebook webhook error', [
  2445.                 'error' => $e->getMessage(),
  2446.                 'trace' => $e->getTraceAsString(),
  2447.                 'payload' => $data ?? null
  2448.             ]);
  2450.             // Return error response
  2451.             return new JsonResponse([
  2452.                 'error' => 'Failed to process participant',
  2453.                 'details' => $e->getMessage()
  2454.             ], Response::HTTP_INTERNAL_SERVER_ERROR);
  2455.         }
  2456.     }
  2458.     /**
  2459.      * @Route("/allmeda/events/participants/import/{batchId}", name="allmeda_participants_import")
  2460.      * @Security("is_granted('ROLE_ADMIN')")
  2461.      */
  2462.     public function importParticipantsAction(Request $request, $batchId)
  2463.     {
  2464.         $em = $this->getDoctrine()->getManager();
  2465.         $templateVars = $em->getRepository(Application::class)->getTemplateVars($request);
  2466.         $feedback = [];
  2467.         $adminEmail = $this->getUser()->getEmail();
  2468.         $responseContent = [];
  2470.         $redirect = Utility::getRedirectTarget($request);
  2472.         $batch = $em->getRepository(Batch::class)->find($batchId);
  2474.         $fields = ['name', 'phone', 'email', 'utmSource','sendConfirmationMail'];
  2476.         $importString = Utility::setDataList($fields);
  2478.         $form = $this->createForm(ImportFormType::class, ['importString' => $importString]);
  2479.         $form->handleRequest($request);
  2481.         if ($form->isSubmitted() && $form->isValid()) {
  2482.             // perform some action, such as saving the task to the database
  2484.             $inputVars = $form->getData();
  2485.             $importString = $inputVars['importString'];
  2487.             $rows = explode(PHP_EOL, $importString);
  2488.             $firstRow = array_shift($rows);
  2489.             $fields = str_getcsv($firstRow, "\t");
  2491.             // fields need to be
  2492.             // $fields = ['name', 'phone', 'email', 'utmSource'];
  2494.             foreach ($rows as $row) {
  2495.                 $feedback[] = str_getcsv($row, "\t");
  2496.             }
  2498.             if ($form->get('import')->isClicked()) {
  2500.                 $now = new DateTime();
  2502.                 // find virtual team for that batch
  2503.                 // http://dev.startplatz.de/apply-add-application/80488/653
  2504.                 //      * @Route("/apply-add-application/{memberId}/{batchId}/", name="apply_add-application")
  2506.                 /** @var Program $program */
  2507.                 $program = $batch->getProgram();
  2509.                 // check if settings contains necessary setters
  2510.                 $batch = $em->getRepository(Batch::class)->checkLegacyData($batch);
  2511.                 $settings = $em->getRepository(Application::class)->getSettingsProgram($program, $batch);
  2513.                 $virtualTeam = array_key_exists('virtualTeam', $settings) ? $settings['virtualTeam'] : 'applicants-' . $program->getSlug() . '-' . $batch->getSlug();
  2514.                 $applicantsTeam = $em->getRepository(Team::class)->getVirtualTeamByName($virtualTeam);
  2517.                 foreach ($feedback as $row) {
  2519.                     $row = array_combine($fields, $row);
  2521.                     if (in_array('utmSource', $fields)){
  2522.                         $data['email']= $row['email'];
  2523.                         $data['name']= $row['name']?? null;
  2524.                         $data['firstName']= $row['firstName']?? null;
  2525.                         $data['lastName']= $row['lastName']?? null;
  2526.                         $data['phone']= $row['phone'] ?? null;
  2527.                         $data['utmSource'] = $row['utmSource'];
  2529.                         $utmParameters = [
  2530.                             'utmSource'   => $data['utmSource'] ?? null,
  2531.                             'utmMedium'   => $data['utmMedium'] ?? null,
  2532.                             'utmCampaign' => $data['utmCampaign'] ?? null,
  2533.                             'utmTerm'     => $data['utmTerm'] ?? null,
  2534.                             'utmContent'  => $data['utmContent'] ?? null,
  2535.                         ];
  2537.                         if (!Utility::validateEmail($data['email'])) {
  2538.                             $this->session->getFlashBag()->add('notice', 'ERROR email is not valid, please check ' . $data['email']);
  2539.                             return $this->redirect($this->generateUrl($redirect->path, (array)$redirect->parameters));
  2540.                         }
  2543.                         $member = $em->getRepository(Member::class)->createGuestMemberIfNotExists($data, false,$data['email'], "MA");
  2545.                         $application = $em->getRepository(Application::class)->findOneBy(['batchId' => $batch->getId(), 'memberId' => $member->getId()]);
  2547.                         if (empty($member->getPhone()) && !empty($data['phone'])) {
  2548.                             $member = $em->getRepository(Member::class)->setPhone($member, $data['phone'], $member->getEmail());
  2549.                         }
  2552.                         if (!$application) {
  2553.                             $application = $em->getRepository(Application::class)->createApplicationByApplyForm(
  2554.                                 $batch->getProgram(),
  2555.                                 $batch,
  2556.                                 false,
  2557.                                 [],
  2558.                                 $utmParameters
  2559.                             );
  2560.                             $application = $em->getRepository(Application::class)->updateApplicationByMember($application, $member);
  2562.                             $application = $em->getRepository(Application::class)->setApplicationApplied($application, $member);
  2564.                             if (array_key_exists('sendConfirmationMail', $row) && $row['sendConfirmationMail'] === 'yes') {
  2565.                                 $this->sendConfirmationMailToApplicant(null, $member, null, $application, $batch);
  2566.                                 $this->session->getFlashBag()->add('notice', 'SUCCESS confirmationMail has been sent to ' . $data['email']);
  2567.                             }
  2569.                         } else {
  2570.                             if (empty($application->getPhone()) && !empty($member->getPhone())) {
  2571.                                 $application->setPhone($member->getPhone());
  2572.                                 $em->persist($application);
  2573.                                 $em->flush();
  2574.                             }
  2575.                         }
  2578.                     } else {
  2579.                         $email = $row['email'];
  2580.                         $firstName = $row['firstName'];
  2583.                         // find member by email
  2584.                         $member = $em->getRepository(Member::class)->createGuestMemberIfNotExists($row, $applicantsTeam, $adminEmail, $memberType = "MA");
  2585.                         $application = $em->getRepository(Application::class)->createApplicationIfNotExists($program, $batch, $applicantsTeam, $member, $adminEmail);
  2587.                     }
  2589.                     $responseContent[] = "Application created or updated for {$application->getPerson()} with email={$application->getEmail()}";
  2590.                 }
  2593.                 $batch = $em->getRepository(Batch::class)->updateNumbers($batch);
  2595.                 $this->session->getFlashBag()->add('notice', 'SUCCESS data has been imported ' . print_r($responseContent, true));
  2597.                 return $this->redirect($this->generateUrl($redirect->path, (array)$redirect->parameters));
  2598.             }
  2599.         } else {
  2600.             $importString = 'leer';
  2601.         }
  2603.         return $this->render('@StartPlatzWebsiteBundle/Import/import.html.twig', [
  2604.             'importString' => $importString,
  2605.             'feedback' => $feedback,
  2606.             'templateVars' => $templateVars,
  2607.             'form' => $form->createView(),
  2608.             'fields' => $fields,
  2609.             'title' => "Import Applications Template: default",
  2610.             'hint'  => "Write 'yes' in the column 'sendConfirmationMail' if a confirmation mail should be sent",
  2611.             'menuLinksAndPhrases' => $this->menuTranslationService->getMenuLinksAndPhrases($request->server->get('REQUEST_URI')),
  2612.         ]);
  2613.     }
  2616.     private function shouldSetAiHubMembership($settings, $applicationStatus)
  2617.     {
  2618.         return array_key_exists("setAiHubMembership", $settings) && $applicationStatus === 'applied';
  2619.     }
  2621.     private function configureServiceForAiHub($status, DateTime $startDate)
  2622.     {
  2623.         $service = new Service();  // oder hole ein existierendes Service-Objekt
  2624.         $endDate = clone $startDate;
  2626.         if ($status === 'trial') {
  2627.             $endDate->modify('+1 month');
  2628.         } elseif ($status === 'active') {
  2629.             $endDate->modify('+3 months');
  2630.         }
  2632.         $service->setStatus($status);
  2633.         $service->setStartDate($startDate);
  2634.         $service->setEndDate($endDate);
  2636.         return $service;
  2637.     }
  2639.     /**
  2640.      * @Route("/allmeda/admin/event/add-participant/{id}/{batchId}", name="allmeda_admin_event_add_participant_modal", defaults={"batchId"=null})
  2641.      * @Security("is_granted('ROLE_ADMIN')")
  2642.      */
  2643.     public function addParticipantAction(Request $request, $id, $batchId = null)
  2644.     {
  2645.         $em = $this->getDoctrine()->getManager();
  2646.         /** @var User $user */
  2647.         $user = $this->getUser();
  2648.         $adminEmail = $user->getEmail();
  2650.         $returnPath = ['path' => 'admin_event_participants', 'parameters' => ['id'=>$id, 'batchId'=>$batchId]];
  2651.         $redirectUrl = base64_encode(json_encode($returnPath));
  2653.         if (!$event = $this->getEventRepository()->findOneBy(['id' => $id])) {
  2654.             $this->addFlash('notice', 'ERROR Veranstaltung nicht gefunden');
  2655.             return $this->redirectToRoute('admin_event_participants', ['id'=>$id, 'batchId'=>$batchId]);
  2656.         }
  2658.         // Retrieve the UTM parameters from the URL
  2659.         $utmParameters = [
  2660.             'utmSource' => $request->query->get('utm_source') ?? 'admin',
  2661.             'utmMedium'   => $request->query->get('utm_medium'),
  2662.             'utmCampaign' => $request->query->get('utm_campaign'),
  2663.             'utmTerm'     => $request->query->get('utm_term'),
  2664.             'utmContent'  => $request->query->get('utm_content'),
  2665.         ];
  2668.         $lang = 'DE';
  2669.         if ($targetPath = $request->server->get('REDIRECT_URL')) {
  2670.             $lang = $this->menuTranslationService->getLang($targetPath);
  2671.         }
  2673.         $eventbriteId   = $event->getEventbriteId();
  2674.         $isEventbriteOnly = $event->getTicketing() > '';
  2675.         $applicationUrl = $event->getApplicationUrl();
  2676.         
  2677.         // Handle batch selection - use provided batchId or find appropriate batch
  2678.         if ($batchId) {
  2679.             $batch = $em->getRepository(Batch::class)->find($batchId);
  2680.             // Verify batch belongs to this event
  2681.             if (!$batch || $batch->getEventId() != $event->getId()) {
  2682.                 $this->addFlash('notice', 'ERROR: Selected batch does not belong to this event');
  2683.                 // Fallback to finding next open batch
  2684.                 if ($event->isMultiBatchEvent()) {
  2685.                     $batch = $em->getRepository(Batch::class)->findNextOpenBatchByEvent($event);
  2686.                 } else {
  2687.                     $batch = $em->getRepository(Batch::class)->findOneBy(['programId'=>27, 'eventId'=>$event->getId()]);
  2688.                 }
  2689.                 // Update batchId to the fallback batch's ID
  2690.                 if ($batch) {
  2691.                     $batchId = $batch->getId();
  2692.                 }
  2693.             }
  2694.         } else {
  2695.             // No batch specified - find appropriate batch
  2696.             if ($event->isMultiBatchEvent()) {
  2697.                 $batch = $em->getRepository(Batch::class)->findNextOpenBatchByEvent($event);
  2698.             } else {
  2699.                 $batch = $em->getRepository(Batch::class)->findOneBy(['programId'=>27, 'eventId'=>$event->getId()]);
  2700.             }
  2701.             // Set batchId to the found batch's ID
  2702.             if ($batch) {
  2703.                 $batchId = $batch->getId();
  2704.             }
  2705.         }
  2706.         
  2707.         $batchIsOpen = $batch && $em->getRepository(Batch::class)->isBatchApplicationOpen($batch);
  2710.         $program = $batch->getProgram();
  2711.         $settings = $this->getProgramSettings($program, $batch);
  2713.         $member      = false;
  2714.         $application = $this->getOrCreateApplication($request, $batch, $program, $member, $lang, $settings, $utmParameters, null);
  2716.         $form = $this->createForm(ApplicationType::class, $application, ['settings' => $settings, 'program' => $program, 'batch' => $batch]);
  2717.         $form->handleRequest($request);
  2718.         ##############################################################
  2719.         ##   form validation starts here                            ##
  2720.         ##############################################################
  2721.         if ($form->isSubmitted() && $form->isValid()) {
  2723.             $application = $em->getRepository(Application::class)->cleanApplicationData($application);
  2724.             $adminEmail  = $application->getEmail();
  2726.             if ($member) {
  2727.                 $memberToBeRegistered = $member;
  2728.                 $isExistingMember     = true;
  2729.             } else {
  2730.                 $response = $this->processRegistrationCheckMembershipExistence($application);
  2731.                 $isExistingMember     = $response['data']['isExistingMember'];
  2732.                 $memberToBeRegistered = $response['data']['memberToBeRegistered'];
  2733.             }
  2734.             $memberToBeRegistered->setIsExistingMember($isExistingMember);
  2736.             // fill application with memberId and teamId and discount information
  2737.             $application = $this->updateApplicationWithMemberIdAndTeamId($application, $memberToBeRegistered, $batch);
  2739.             if (!$batch->isMultipleApplicationsPerMember()) {
  2740.                 // check if there is already an application to this event == batch with that batchId and memberId
  2741.                 if ($existingApplication = $em->getRepository(Application::class)->findOneBy(['batchId' => $batch->getId(), 'memberId' => $memberToBeRegistered->getId()])) {
  2742.                     // there are two applications - the latest application will always win
  2743.                     $fields     = Utility::getEntityFieldsArray($application, ['id','assessments', 'votesRegistered', 'applicationStatus', 'editStatus', 'editMessage', 'lastChangeUser','history','extraFields','lastModified','createdAt']);
  2744.                     $storedData = Utility::fillDataByObject($existingApplication, $fields);
  2745.                     $updatedData = Utility::fillDataByObject($application, $fields);
  2747.                     $differences = array_diff_assoc($updatedData, $storedData);
  2748.                     $application = $existingApplication;
  2749.                     $application = $this->updateApplication($application, $differences);
  2751.                     $application->setIsExistingApplication(true);
  2752.                 }
  2753.             }
  2755.             if (isset($settings['extraFields'])) {
  2756.                 $application = $this->getExtraFieldsData($application, $settings, $form);
  2757.             }
  2759.             $settings['isNeedsLoginValidation'] = 0;
  2760.             $settings['isNeedsEmailValidation'] = 0;
  2761.             $settings['isSendConfirmationMail'] = 0;
  2763.             $route = 'event_show_single';
  2764.             $routeParameters = $request->get('_route_params');
  2765.             if (!array_key_exists('slug', $routeParameters)) {
  2766.                 $routeParameters['slug'] = $event->getSlug();
  2767.             }
  2769.             $application->setApplicationStatus('applied');
  2770.             $application = $em->getRepository(Application::class)->setApplication($application, $memberToBeRegistered);
  2772.             $this->session->getFlashBag()->add('notice', "SUCCESS {$application->getPerson()} wurde hinzugefügt mit Status == {$application->getApplicationStatus()}");
  2774.             return $this->redirectToRoute('admin_event_participants', ['id'=>$id, 'batchId'=>$batchId]);
  2776.         }
  2779.         return $this->render('@StartPlatzEvent/Admin/edit.add-participant.html.twig', [
  2780.             'event'         => $event,
  2782.             'eventbriteId'   => $eventbriteId,
  2783.             'isEventbriteOnly' => $isEventbriteOnly,
  2784.             'applicationUrl' => $applicationUrl,
  2785.             'batch'          => $batch,
  2786.             'settings'       => $settings,
  2787.             'form'           => $form ? $form->createView() : $form,
  2788.             'application'    => $application,
  2789.             'batchIsOpen'    => $batchIsOpen,
  2790.             'member'         => $member,
  2792.             'speakers'       => $this->getSpeakers($event),
  2793.             'phrases'        => $em->getRepository(Option::class)->getApplicationPhrases($program, $batch, false, $lang),
  2795.             'templateVars'   => [],
  2797.             'preview'             => $request->get('preview'),
  2798.             'menuLinksAndPhrases' => $this->menuTranslationService->getMenuLinksAndPhrases($request->server->get('REQUEST_URI')),
  2799.             'lang'           => $lang,
  2800.             'targetRoute'     => "event_show_single",
  2801.             'targetRouteSlug' => $event->getSlug(),
  2802.             'targetPath'      => $targetPath,
  2803.             ]);
  2804.     }
  2807.     public function updateApplication(Application $application, $differences)
  2808.     {
  2809.         foreach ($differences as $diff => $value) {
  2810.             $method = 'set' . ucfirst((string) $diff);
  2811.             if (method_exists($application, $method)) {
  2812.                 $application->$method($value);
  2813.             }
  2814.         }
  2815.         return $application;
  2816.     }
  2818.     private function getExtraFieldsData(Application $application, $settings, $form)
  2819.     {
  2820.         $extraFields = $settings['extraFields'];
  2821.         $data = [];
  2822.         $i = 0;
  2823.         foreach ($extraFields as $extraField) {
  2824.             $data[$extraField['field']] = $form->get($extraField['field'])->getData();
  2825.             $i++;
  2826.         }
  2828.         if ($data) {
  2829.             $application->setExtraFields(json_encode($data)) ;
  2830.         }
  2832.         return $application;
  2833.     }
  2835.     private function getExtraFieldsAttributes($settings)
  2836.     {
  2837.         if (!isset($settings['extraFields'])) {
  2838.             return $settings;
  2839.         }
  2841.         $em = $this->getDoctrine()->getManager();
  2842.         $extraFields = $settings['extraFields'];
  2843.         $i = 0;
  2844.         foreach ($extraFields as $extraField) {
  2845.             if ($extraField['type'] == 'choice') {
  2846.                 $choices = [];
  2847.                 if (isset($extraField['arr'])) {
  2848.                     $choices = $em->getRepository(Attribute::class)->findCodesByAttributeName($extraField['arr']);
  2849.                 }
  2850.                 $settings['extraFields'][$i]['choices'] = $choices;
  2852.             }
  2853.             $i++;
  2854.         }
  2856.         return $settings;
  2857.     }
  2860.     private function sendMagicLinkForPayment(Application $application, Batch $batch, $customerId, $route, $routeParameters)
  2861.     {
  2862.         if (!$application) {
  2863.             $this->session->getFlashBag()->add('notice', 'ERROR application not found');
  2864.             return $this->generateUrl($route, $routeParameters);
  2865.         }
  2867.         $em = $this->getDoctrine()->getManager();
  2869.         if (!$product = $em->getRepository(Product::class /*Product Member*/)->find($batch->getProductId())) {
  2870.             $this->session->getFlashBag()->add('notice', 'ERROR configuration not found');
  2871.             return $this->generateUrl($route, $routeParameters);
  2872.         }
  2874.         if (!$memberToBeRegistered = $this->getExistingMemberAccount($application)) {
  2875.             $this->session->getFlashBag()->add('notice', 'ERROR member not found');
  2876.             return $this->generateUrl($route, $routeParameters);
  2877.         }
  2879.         if (!$customer = $em->getRepository(Customer::class)->findOneBy(['hash'=>$customerId])) {
  2880.             $this->session->getFlashBag()->add('notice', 'ERROR customer not found');
  2881.             return $this->generateUrl($route, $routeParameters);
  2882.         }
  2884.         $routeParameters["app"]        = $application->getId();
  2885.         $routeParameters['action']     = "useExistingCustomerAccount";
  2886.         $routeParameters['customerId'] = $customerId;
  2887.         $targetPath = $this->generateUrl($route, $routeParameters);
  2889.         $loginLink = $this->loginService->getLoginLinkByTargetPath($memberToBeRegistered->getEmail(), $targetPath);
  2890.         $mailTemplate = $em->getRepository(MailTemplate::class)->getPaymentLoginMailTemplateByBatch($batch, $application, $loginLink);
  2892.         $feedback = Utility::sendAlertMailPerZapier($mailTemplate['recipientEmail'], $mailTemplate['mailText'], $mailTemplate['mailSubject'], $mailTemplate['replyToEmail'], $mailTemplate['fromName'], $mailTemplate['bodyType']);
  2894.         $routeParameters["app"]        = $application->getId();
  2895.         $routeParameters['action']     = "MagicLinkForPaymentSent";
  2896.         $targetPath = $this->generateUrl($route, $routeParameters);
  2898.         return $targetPath;
  2899.     }
  2901.     private function getSpeakers($event)
  2902.     {
  2903.         $em = $this->getDoctrine()->getManager();
  2904.         $speakers = [];
  2905.         if ($rows = json_decode((string) $event->getSpeakers())) {
  2906.             foreach ($rows as $row) {
  2907.                 switch (strtolower((string) $row[1])) {
  2908.                     case "partner":
  2909.                         // find partner page
  2910.                         if ($partner = $em->getRepository(Page::class)->find($row[2])) {
  2911.                             $speakers['partners'][] = $partner;
  2912.                         }
  2913.                         break;
  2914.                     case "speaker":
  2915.                         // find member
  2916.                         if ($member = $em->getRepository(Member::class)->find($row[2])) {
  2917.                             $speakers['members'][] = $member;
  2918.                         }
  2919.                         break;
  2920.                     default:
  2921.                         $speakers['legacy'][] = $row;
  2922.                         break;
  2923.                 }
  2924.             }
  2925.         }
  2927.         return $speakers;
  2928.     }
  2931.     private function prepareMonsumCheckoutNewMonsumAccount(Application $application, Batch $batch, $action, $route, $routeParameters, $customerId = 0)
  2932.     {
  2933.         if (!$application) {
  2934.             $this->session->getFlashBag()->add('notice', 'ERROR application not found');
  2935.             return $this->generateUrl($route, $routeParameters);
  2936.         }
  2938.         $em = $this->getDoctrine()->getManager();
  2940.         if (!$product = $em->getRepository(Product::class /*Product Member*/)->find($batch->getProductId())) {
  2941.             $this->session->getFlashBag()->add('notice', 'ERROR configuration not found');
  2942.             return $this->generateUrl($route, $routeParameters);
  2943.         }
  2945.         if (!$memberToBeRegistered = $this->getExistingMemberAccount($application)) {
  2946.             return $this->generateUrl($route, $routeParameters);
  2947.         }
  2949.         if ($action == "useExistingCustomerAccount") {
  2951.             if (!$customerArray = $em->getRepository(Customer::class)->isMonsumCustomerValidByMemberAndCustomerId($memberToBeRegistered, $customerId)) {
  2952.                 $this->session->getFlashBag()->add('notice', 'ERROR customer account not found');
  2953.                 return $this->generateUrl($route, $routeParameters);
  2954.             }
  2956.             if (!$customer = $em->getRepository(Customer::class)->findOneBy(['customerId'=>$customerArray['customerId'] ])) {
  2957.                 $this->session->getFlashBag()->add('notice', 'ERROR customer account not found');
  2958.                 return $this->generateUrl($route, $routeParameters);
  2959.             }
  2960.         } else {
  2961.             $team     = $em->getRepository(Team::class)->createNewMonsumAccountTeamByMembershipApplicant($memberToBeRegistered);
  2962.             $customer = $this->setMonsumAccountIfNotExists($memberToBeRegistered, $team, $application, $product->getAccount());
  2963.         }
  2965.         $customer = $em->getRepository(Customer::class)->setCheckoutData($customer, $product->getAccount(), $product->getProductNumber(), $memberToBeRegistered->getId());
  2967.         $successUrlParameters = [
  2968.             'slug' => $routeParameters['slug'],
  2969.             'app' => $application->getId(),
  2970.             'action' => "checkSuccess",
  2971.             'provider' => 'monsum',
  2972.         ];
  2974.         if ($product->getLandingPageSnippet() > '') {
  2975.             $successUrlParameters['account']       = $product->getAccount();
  2976.             $successUrlParameters['productnumber'] = $product->getProductNumber();
  2977.         }
  2979.         $successPage = $this->generateUrl($route, $successUrlParameters, UrlGeneratorInterface::ABSOLUTE_URL);
  2980.         $successUrl = urlencode($successPage);
  2981.         $successUrl = urlencode($successUrl); // that is strange but monsum wants double encoding
  2983.         $subscription_title = $routeParameters['slug'];
  2985.         $promocode = "";
  2986.         switch ($application->getDiscountPercent()) {
  2987.             case "100":
  2988.                 $promocode = "100_system";
  2989.                 break;
  2990.             case "50":
  2991.                 $promocode = "community";
  2992.                 break;
  2993.             case "20":
  2994.                 //$promocode = "20_system"; wegen AI ausser Kraft gesetzt
  2995.                 break;
  2996.         }
  2998.         if ($application->getUtmTerm()) {
  2999.             $promocode = $application->getUtmTerm();
  3000.         }
  3001.         $accountHash   = $customer->getAccountHash();
  3002.         $customerHash  = $customer->getHash();
  3003.         $productNumber = $product->getProductNumber();
  3005.         return "https://app.monsum.com/checkout/0/{$accountHash}/{$customerHash}/{$productNumber}&success_url={$successUrl}&promocode={$promocode}&subscription_title={$subscription_title}&x_applicationId={$application->getId()}";
  3006.     }
  3009.     private function prepareMonsumCheckout($application, $product, $member, $event, $customer)
  3010.     {
  3012.         $successPage = $this->generateUrl('event_show_single', [
  3013.             'slug' => $event->getSlug(),
  3014.             'app' => $application->getId(),
  3015.             'action' => "checkSuccess",
  3016.             'provider' => 'monsum',
  3017.         ], UrlGeneratorInterface::ABSOLUTE_URL);
  3018.         $successUrl = urlencode($successPage);
  3019.         $successUrl = urlencode($successUrl); // that is strange but monsum wants double encoding
  3021.         $subscription_title = $event->getTitle();
  3022.         $promocode = $member->getHasCommunityMembership() ? "community" : "";
  3024.         $accountHash   = $customer->getAccountHash();
  3025.         $customerHash  = $customer->getHash();
  3026.         $productNumber = $product->getProductNumber();
  3028.         return "https://app.monsum.com/checkout/0/{$accountHash}/{$customerHash}/{$productNumber}&success_url={$successUrl}&promocode={$promocode}&subscription_title={$subscription_title}&x_applicationId={$application->getId()}";
  3029.     }
  3032.     private function updateApplicationWithStepOneInformation(Application $application,Member $memberToBeRegistered, Event $event)
  3033.     {
  3034.         $status  = "process";
  3036.         // Check for Stripe payment configuration
  3037.         $hasStripePayment = false;
  3038.         if ($event->getStripePriceId() > '') {
  3039.             $hasStripePayment = true;
  3040.         }
  3041.         
  3042.         // For multi-batch events, also check batch-specific Stripe settings
  3043.         if ($event->isMultiBatchEvent() && $application->getBatchId()) {
  3044.             $em = $this->getDoctrine()->getManager();
  3045.             $batch = $em->getRepository(Batch::class)->find($application->getBatchId());
  3046.             if ($batch && $batch->getStripePriceId() > '') {
  3047.                 $hasStripePayment = true;
  3048.             }
  3049.         }
  3051.         if ($hasStripePayment){
  3052.             $todo    = "stripeStarted";
  3053.         } else {
  3054.             $todo    = "do next step";
  3055.         }
  3056.         $message = "Next step is needed";
  3058.         $application->setEditStatus("{$status}:{$todo}");
  3059.         $application->setEditMessage($message);
  3060.         $application->setApplicationStatus('started');
  3062.         $application->setMemberId($memberToBeRegistered->getId());
  3064.         return $application;
  3065.     }
  3067.     private function getOrCreateMemberAccount($application)
  3068.     {
  3069.         if (!$memberToBeRegistered = $this->getExistingMemberAccount($application)) {
  3070.             $memberToBeRegistered  =  $this->createGuestMember($application);
  3071.         }
  3072.         return $memberToBeRegistered;
  3073.     }
  3075.     private function processRegistrationCheckMembershipExistence($application)
  3076.     {
  3077.         $em = $this->getDoctrine()->getManager();
  3078.         $status  = "success";
  3079.         $message = "nothing to be reported";
  3081.         // does a memberAccount exist with that email?
  3082.         if ($memberToBeRegistered = $this->getExistingMemberAccount($application)) {
  3083.             $isExistingMember = true;
  3084.         } else {
  3085.             $isExistingMember = false;
  3086.             $memberToBeRegistered = $this->createGuestMember($application);
  3087.         }
  3089.         $response = [
  3090.             'status'  => $status,
  3091.             'message' => $message,
  3092.             'data'    => [
  3093.                 'isExistingMember'          => $isExistingMember,
  3094.                 'memberToBeRegistered'      => $memberToBeRegistered,
  3095.             ],
  3096.         ];
  3098.         return $response;
  3100.     }
  3102.     private function processRegistrationWithPayment($application, $memberToBeRegistered, $account)
  3103.     {
  3104.         $em = $this->getDoctrine()->getManager();
  3105.         $status  = "success";
  3106.         $message = "nothing to be reported";
  3107.         $data    = [];
  3109.         // does a customerAccount exist with that member?
  3110.         if ($customer = $em->getRepository(Customer::class)->findPrimaryMonsumAccount($memberToBeRegistered, $account)) {
  3111.             $isExistingCustomerAccount = true;
  3112.         } else {
  3113.             $isExistingCustomerAccount = false;
  3114.             $team = $em->getRepository(Team::class)->createTeamByMembershipApplicant($memberToBeRegistered);
  3115.             $customer = $this->setMonsumAccountIfNotExists($memberToBeRegistered, $team, $application, $account);
  3116.         }
  3119.         $response = [
  3120.             'status'  => $status,
  3121.             'message' => $message,
  3122.             'data'    => [
  3123.                 'isExistingCustomerAccount' => $isExistingCustomerAccount,
  3124.                 'customer'                  => $customer,
  3125.             ],
  3126.         ];
  3128.         return $response;
  3129.     }
  3131.     private function getExistingMemberAccount($application)
  3132.     {
  3133.         $em = $this->getDoctrine()->getManager();
  3134.         $existingMember = false;
  3136.         if ($application->getEmail()) {
  3137.             $existingMember = $em->getRepository(Member::class)->findOneBy(['email' => $application->getEmail()]);
  3138.         }
  3140.         return $existingMember;
  3141.     }
  3143.     private function createGuestMember($application)
  3144.     {
  3145.         $em = $this->getDoctrine()->getManager();
  3146.         $guestMember = false;
  3148.         $data['email']     = $application->getEmail();
  3149.         $data['firstName'] = $application->getFirstName();
  3150.         $data['lastName']  = $application->getLastName();
  3151.         $data['name']      = $application->getPerson();
  3152.         $adminEmail        = $application->getEmail();
  3153.         // we create an guest membership, memberType needs to be only "MA"
  3154.         $memberType = "MA";
  3156.         $guestMember = $em->getRepository(Member::class)->createGuestMemberIfNotExists($data, false, $adminEmail, $memberType);
  3158.         return $guestMember;
  3159.     }
  3162.     private function processRegistrationWithoutPaymentSimpleOptimized($isExistingMember, $user, $member, Application $application, $settings, $lang, $adminEmail, Batch $batch, $route, $routeParameters)
  3163.     {
  3164.         $em = $this->getDoctrine()->getManager();
  3165.         $status = "error";
  3166.         $message = "";
  3167.         $action  = "";
  3168.         $mailTemplate = "";
  3169.         $targetPath   = "";
  3171.         if ($user) {
  3172.             $application->setApplicationStatus('applied');
  3173.             $application = $em->getRepository(Application::class)->setApplication($application, $member);
  3174.             if ($batch->getProgramId() == 30 && !in_array($batch->getGoToPage(), ['landingPage','editMentorsProfile'])) {
  3175.                 $status  = "error";
  3176.                 $targetPath = $batch->getGoToPage();
  3177.                 $response = [
  3178.                     'status' => $status,
  3179.                     'message' => $message,
  3180.                     'data' => [
  3181.                         'targetPath'   => $targetPath,
  3182.                         'application'  => $application,
  3183.                         'member'       => $member,
  3184.                     ],
  3185.                 ];
  3187.                 return $response;
  3188.             }
  3190.             $feedback = $this->sendConfirmationMailToApplicant($user, null, $settings, $application, $batch);
  3191.             if ($lang == 'EN') {
  3192.                 $message = "Thank you for your registration.<br>We have sent you a confirmation email.";
  3193.             } else {
  3194.                 $message = "Danke für Deine Registrierung.<br>Wir haben Dir eine Bestätigungsmail geschickt.";
  3195.             }
  3196.             $status  = "success";
  3197.             $response = [
  3198.                 'status' => $status,
  3199.                 'message' => $message,
  3200.                 'data' => [
  3201.                     'targetPath'   => $targetPath,
  3202.                     'application'  => $application,
  3203.                     'member'       => $member,
  3204.                 ],
  3205.             ];
  3207.             $status = strtoupper($status);
  3208.             $this->session->getFlashBag()->add('notice', "{$status} {$message}");
  3210.             return $response;
  3212.         }
  3214.         if ($isExistingMember && $settings['isNeedsLoginValidation']) {
  3215.             $status  = "error";
  3216.             $todo    = "validateLogin";
  3217.             $action  = "needsLoginValidation";
  3218.             $message = "This email address is already in use. Please login to make your application valid.";
  3219.         } elseif ($isExistingMember && !$settings['isNeedsLoginValidation']) {
  3220.             $status  = "process";
  3221.             $todo    = "notValidatedLogin";
  3222.             $action  = "applied";
  3223.             $message = "This email address is already in use. Application will be processed without login being validated";
  3224.         } elseif (!$isExistingMember && $settings['isNeedsEmailValidation']) {
  3225.             $status  = "error";
  3226.             $todo    = "validateEmail";
  3227.             $action  = "needsEmailVerification";
  3228.             $message = "Email is not yet registered. Email needs to be validated";
  3229.         } elseif (!$isExistingMember && !$settings['isNeedsEmailValidation']) {
  3230.             $status  = "process";
  3231.             $todo    = "notValidateEmail";
  3232.             $action  = "registered";
  3233.             $message = "Email is not yet registered. Application will be processed without email being validated";
  3234.         }
  3236.         $application = $em->getRepository(Application::class)->setEditStatus($application, $status, $todo, $message);
  3238.         if ($batch->getProgramId() == 30 && !in_array($batch->getGoToPage(), ['landingPage','editMentorsProfile'])) {
  3239.             $application->setApplicationStatus('applied');
  3240.             $application = $em->getRepository(Application::class)->setApplication($application, $member);
  3241.             $status  = "error";
  3242.             $targetPath = $batch->getGoToPage();
  3243.             $loginLink = $this->loginService->getLoginLinkByTargetPath($member->getEmail(), $targetPath);
  3244.             $response = [
  3245.                 'status' => $status,
  3246.                 'message' => $message,
  3247.                 'data' => [
  3248.                     'targetPath'   => $loginLink,
  3249.                     'application'  => $application,
  3250.                     'member'       => $member,
  3251.                 ],
  3252.             ];
  3254.             return $response;
  3255.         }
  3256.         $phrases = $em->getRepository(Option::class)->getApplicationPhrases($batch->getProgram(), $batch, false, $lang);
  3258.         if ($status == 'process') {
  3259.             $application->setApplicationStatus('applied');
  3260.             switch ($lang) {
  3261.                 case "DE":
  3262.                     $message = $phrases['event_application_thankyou_sent_confirmationmail'] ?? "Danke für Deine Anmeldung.<br>Wir haben Dir eine Bestätigungsmail geschickt. Wir freuen uns auf Dich!";
  3263.                     break;
  3264.                 case "EN":
  3265.                     $message = $phrases['event_application_thankyou_sent_confirmationmail'] ?? "Thanks, Your application is now approved.<br>We have sent you a confirmation mal and we are looking forward to having you!";
  3266.                     break;
  3267.             }
  3268.         } else {
  3269.             $application->setApplicationStatus('started');
  3270.             switch ($lang) {
  3271.                 case "DE":
  3272.                     $message = "Danke für Deine Registrierung. Du bist vorgemerkt<br>Wir haben Dir eine Mail zur Bestätigung Deiner E-Mail Adresse geschickt. Bitte klicke den Bestätigungslink in dieser Mail, um Dich endgültig anzumelden";
  3273.                     break;
  3274.                 case "EN":
  3275.                     $message = "Thank you for your registration. You are pre-registered.<br>We have sent you an email to confirm your email address. Please click the confirmation link in that email to complete your registration.";
  3276.                     break;
  3277.             }
  3278.         }
  3280.         $this->session->getFlashBag()->add('notice', "SUCCESS {$message}");
  3282.         $application = $em->getRepository(Application::class)->setApplication($application, $member);
  3284.         $routeParameters['action'] = $action;
  3285.         $routeParameters['lang']   = $lang;
  3287.         $targetPath = strtolower($this->generateUrl($route, $routeParameters));
  3289.         $loginLink = $this->loginService->getLoginLinkByTargetPath($member->getEmail(), $targetPath);
  3291.         if ($isExistingMember && $settings['isNeedsLoginValidation']) {
  3292.             $mailTemplate = $em->getRepository(MailTemplate::class)->getValidateLoginMailTemplateByBatch($batch, $application, $loginLink);
  3293.             $feedback = Utility::sendAlertMailPerZapier($mailTemplate['recipientEmail'], $mailTemplate['mailText'], $mailTemplate['mailSubject'], $mailTemplate['replyToEmail'], $mailTemplate['fromName'], $mailTemplate['bodyType']);
  3294.         } elseif ($isExistingMember && !$settings['isNeedsLoginValidation']) {
  3295.             $this->sendConfirmationMailToApplicant(null, $member, $settings, $application, $batch);
  3296.         } elseif (!$isExistingMember && $settings['isNeedsEmailValidation']) {
  3297.             $mailTemplate = $em->getRepository(MailTemplate::class)->getValidateEmailMailTemplateByBatch($batch, $application, $loginLink);
  3298.             $feedback = Utility::sendAlertMailPerZapier($mailTemplate['recipientEmail'], $mailTemplate['mailText'], $mailTemplate['mailSubject'], $mailTemplate['replyToEmail'], $mailTemplate['fromName'], $mailTemplate['bodyType']);
  3299.         } elseif (!$isExistingMember && !$settings['isNeedsEmailValidation']) {
  3300.             $this->sendConfirmationMailToApplicant(null, $member, $settings, $application, $batch);
  3301.         }
  3304.         $response = [
  3305.             'status' => $status,
  3306.             'message' => $message,
  3307.             'data' => [
  3308.                 'targetPath'   => $targetPath,
  3309.                 'application'  => $application,
  3310.                 'member'       => $member,
  3311.             ],
  3312.         ];
  3314.         return $response;
  3315.     }
  3317.     private function processRegistrationWithoutPayment($isMemberloggedIn, $member, $application, $settings, $request, $lang, $adminEmail, $batch)
  3318.     {
  3319.         $em = $this->getDoctrine()->getManager();
  3321.         if ($existingMember = $em->getRepository(Member::class)->findOneBy(['email' => $application->getEmail()])) {
  3322.             $status = "error";
  3323.             $todo   = "validateLogin";
  3325.             if ($existingApplication = $em->getRepository(Application::class)->findOneBy(['memberId'=>$existingMember->getId(), 'batchId'=>$batch->getId()])) {
  3326.                 $application = $existingApplication;
  3327.                 $message = "You have already applied. Please login with the magic link.";
  3328.             } else {
  3329.                 $application->setMemberId($existingMember->getId());
  3330.                 $message = "This email address is already in use. Please login to make your application valid.";
  3331.             }
  3332.             $application = $em->getRepository(Application::class)->setEditStatus($application, $status, $todo, $message);
  3333.             if (!$application->getApplicationStatus()) {
  3334.                 $application->setApplicationStatus('started');
  3335.             }
  3336.             // set this application i.e. save to database
  3337.             $application = $em->getRepository(Application::class)->setApplication($application);
  3338.             $member = $em->getRepository(Member::class)->updateMemberWithApplication($existingMember, $application, $adminEmail);
  3340.             $routeParameters = $request->get('_route_params');
  3341.             $routeParameters["app"]    = $application->getId();
  3342.             $routeParameters['action'] = "needsLoginValidation";
  3344.             $targetPath = strtolower($this->generateUrl('event_show_single', $routeParameters));
  3346.             $loginLink = $this->loginService->getLoginLinkByTargetPath($existingMember->getEmail(), $targetPath);
  3347.             $mailTemplate = $em->getRepository(MailTemplate::class)->getValidateLoginMailTemplateByBatch($batch, $application, $loginLink);
  3349.             /*
  3350.                 if ($lang == 'DE'){
  3351.                     $this->session->getFlashBag()->add('notice', 'SUCCESS Danke für Deine Anmeldung. Du bist vorgemerkt. Wir haben Dir eine Mail zur Überprüfung geschickt. Sobald Du Deine Anmeldung bestätigt hast, wird die Anmeldung gültig.' );
  3352.                 } else {
  3353.                     $this->session->getFlashBag()->add('notice', 'SUCCESS Thank you for your registration. You are registered. As soon as you have confirmed your registration, the registration will be valid.' );
  3354.                 }
  3355.             */
  3357.             $response = [
  3358.                 'status'  => $status,
  3359.                 'message' => $message,
  3360.                 'data'    => [
  3361.                     'mailTemplate' => $mailTemplate,
  3362.                     'targetPath'   => $targetPath,
  3363.                 ],
  3364.             ];
  3366.             return $response;
  3369.         } else {
  3370.             $status = "error";
  3371.             $todo   = "validateEmail";
  3372.             $message = "Email is not yet registered. Email needs to be validated";
  3373.             $application = $em->getRepository(Application::class)->setErrorValidateEmail($application);
  3374.             $data['email']     = $application->getEmail();
  3375.             $data['firstName'] = $application->getFirstName();
  3376.             $data['lastName']  = $application->getLastName();
  3377.             $data['name']      = $application->getPerson();
  3378.             $adminEmail        = $application->getEmail();
  3379.             if ($settings['isTeamNeeded']) {
  3380.                 $memberType = "GF";
  3381.             } else {
  3382.                 $memberType = "MA";
  3383.             }
  3385.             $member = $em->getRepository(Member::class)->createGuestMemberIfNotExists($data, false, $adminEmail, $memberType);
  3386.             $application->setMemberId($member->getId());
  3387.             $application->setTeamId($member->getTeamId());
  3389.             $application = $em->getRepository(Application::class)->setEditStatus($application, $status, $todo, $message);
  3390.             if (!$application->getApplicationStatus()) {
  3391.                 $application->setApplicationStatus('started');
  3392.             }
  3393.             // set this application i.e. save to database
  3394.             $application = $em->getRepository(Application::class)->setApplication($application);
  3395.             $member = $em->getRepository(Member::class)->updateMemberWithApplication($member, $application, $adminEmail);
  3397.             $routeParameters = $request->get('_route_params');
  3398.             $routeParameters["app"]    = $application->getId();
  3399.             $routeParameters['action'] = "needsEmailVerification";
  3401.             $targetPath = strtolower($this->generateUrl('event_show_single', $routeParameters));
  3403.             $loginLink = $this->loginService->getLoginLinkByTargetPath($member->getEmail(), $targetPath);
  3404.             $mailTemplate = $em->getRepository(MailTemplate::class)->getValidateEmailMailTemplateByBatch($batch, $application, $loginLink);
  3406.             /*
  3407.             if ($lang == 'DE'){
  3408.                 $this->session->getFlashBag()->add('notice', 'SUCCESS Danke für Deine Anmeldung. Du bist vorgemerkt. Wir haben Dir eine Mail zur Überprüfung geschickt. Sobald Du Deine E-Mail Adresse bestätigt hast, wird die Anmeldung gültig.' );
  3409.             } else {
  3410.                 $this->session->getFlashBag()->add('notice', 'SUCCESS Thank you for your registration. You are registered. As soon as you have confirmed your e-mail address, the registration will be valid.' );
  3411.             }
  3412.             */
  3414.             $response = [
  3415.                 'status'  => $status,
  3416.                 'message' => $message,
  3417.                 'data'    => [
  3418.                     'mailTemplate' => $mailTemplate,
  3419.                     'targetPath'   => $targetPath,
  3420.                 ],
  3421.             ];
  3423.             return $response;
  3424.         }
  3426.     }
  3428.     /**
  3429.      * @Route("/event-ics/download/{eventId}", name="event_download")
  3430.      */
  3431.     public function downloadCalendarEventByEventId($eventId)
  3432.     {
  3433.         $em = $this->getDoctrine()->getManager();
  3434.         if (!$event = $em->getRepository(Event::class)->findOneBy(['id' => $eventId])) {
  3435.             return "";
  3436.         }
  3437.         if (!$batch = $em->getRepository(Batch::class)->findOneBy(['eventId' => $eventId])) {
  3438.             return "";
  3439.         }
  3441.         $zoomLink  = $batch->getZoomlink();
  3442.         $description = $zoomLink ? "Teilnehmen mit {$zoomLink}" : "";
  3443.         $summary = $event->getTitle();
  3445.         // Zeitzone für Berlin und UTC einrichten
  3446.         $timezoneBerlin = new \DateTimeZone('Europe/Berlin');
  3447.         $timezoneUTC = new \DateTimeZone('UTC');
  3449.         // Start- und Endzeit des Events konvertieren
  3450.         $startDate = $event->getStartDate();
  3451.         $startDate->setTimezone($timezoneUTC);
  3452.         $icsStartDate = $startDate->format('Ymd\THis\Z');
  3454.         $endDate = $event->getEndDate();
  3455.         $endDate->setTimezone($timezoneUTC);
  3456.         $icsEndDate = $endDate->format('Ymd\THis\Z');
  3458.         // Erstellen des iCal-Inhalts mit den konvertierten Zeiten
  3459.         $icsContent = "BEGIN:VCALENDAR\r\n";
  3460.         $icsContent .= "VERSION:2.0\r\n";
  3461.         $icsContent .= "BEGIN:VEVENT\r\n";
  3462.         $icsContent .= "DTSTART:{$icsStartDate}\r\n";
  3463.         $icsContent .= "DTEND:{$icsEndDate}\r\n";
  3464.         $icsContent .= "SUMMARY:{$summary}\r\n";
  3465.         $icsContent .= "DESCRIPTION:{$description}\r\n";
  3466.         $icsContent .= "END:VEVENT\r\n";
  3467.         $icsContent .= "END:VCALENDAR";
  3469.         header('Content-Type: text/calendar; charset=utf-8');
  3470.         header('Content-Disposition: attachment; filename="calendar_' . $event->getSlug() . '.ics"');
  3471.         echo $icsContent;
  3472.         exit;
  3473.     }
  3475.     /**
  3476.      * Download ICS calendar file using Batch dates for multi-batch events
  3477.      *
  3478.      * @Route("/event-ics/download/batch/{batchId}", name="event_download_batch")
  3479.      */
  3480.     public function downloadCalendarEventByBatchId($batchId)
  3481.     {
  3482.         $em = $this->getDoctrine()->getManager();
  3484.         // Find batch
  3485.         if (!$batch = $em->getRepository(Batch::class)->find($batchId)) {
  3486.             return new Response("Batch not found", Response::HTTP_NOT_FOUND);
  3487.         }
  3489.         // Find event
  3490.         if (!$event = $em->getRepository(Event::class)->find($batch->getEventId())) {
  3491.             return new Response("Event not found", Response::HTTP_NOT_FOUND);
  3492.         }
  3494.         // Determine which dates to use: Batch dates for multi-batch events, Event dates otherwise
  3495.         if ($event->isMultiBatchEvent() && $batch->getStartDate()) {
  3496.             $startDate = clone $batch->getStartDate();
  3497.             $endDate = $batch->getEndDate() ? clone $batch->getEndDate() : (clone $startDate)->modify('+2 hours');
  3498.         } else {
  3499.             $startDate = clone $event->getStartDate();
  3500.             $endDate = clone $event->getEndDate();
  3501.         }
  3503.         // Prepare description
  3504.         $zoomLink = $batch->getZoomlink();
  3505.         $description = $zoomLink ? "Teilnehmen mit {$zoomLink}" : "";
  3506.         $summary = $event->getTitle();
  3508.         // Convert to UTC
  3509.         $timezoneUTC = new \DateTimeZone('UTC');
  3510.         $startDate->setTimezone($timezoneUTC);
  3511.         $endDate->setTimezone($timezoneUTC);
  3513.         $icsStartDate = $startDate->format('Ymd\THis\Z');
  3514.         $icsEndDate = $endDate->format('Ymd\THis\Z');
  3516.         // Generate ICS content
  3517.         $icsContent = "BEGIN:VCALENDAR\r\n";
  3518.         $icsContent .= "VERSION:2.0\r\n";
  3519.         $icsContent .= "BEGIN:VEVENT\r\n";
  3520.         $icsContent .= "DTSTART:{$icsStartDate}\r\n";
  3521.         $icsContent .= "DTEND:{$icsEndDate}\r\n";
  3522.         $icsContent .= "SUMMARY:{$summary}\r\n";
  3523.         $icsContent .= "DESCRIPTION:{$description}\r\n";
  3524.         $icsContent .= "END:VEVENT\r\n";
  3525.         $icsContent .= "END:VCALENDAR";
  3527.         header('Content-Type: text/calendar; charset=utf-8');
  3528.         header('Content-Disposition: attachment; filename="calendar_' . $event->getSlug() . '_batch_' . $batch->getId() . '.ics"');
  3529.         echo $icsContent;
  3530.         exit;
  3531.     }
  3534.     private function sendConfirmationMailToApplicant(User $user = null, Member $member = null, $settings, Application $application, Batch $batch, bool $allowNewsletterRegistration = true) {
  3535.         if (isset($settings['isSendConfirmationMail']) && !$settings['isSendConfirmationMail']) {
  3536.             return false;
  3537.         }
  3538.         if ($user === null && $member === null) {
  3539.             return false;
  3540.         }
  3542.         $feedback = "no mail";
  3543.         $em = $this->getDoctrine()->getManager();
  3545.         if ($user === null) {
  3546.             $user = $em->getRepository(User::class)->findOneBy(['memberId'=>$member->getId()]);
  3547.         }
  3549.         if ($member === null) {
  3550.             $member = $em->getRepository(Member::class)->find($user->getMemberId());
  3551.         }
  3553.         $email = $member->getEmail();
  3555.         if (!Utility::validateEmail($email)) {
  3556.             return false;
  3557.         }
  3559.         if (!$user->getisNoBulkMail() && $allowNewsletterRegistration){
  3560.             if (!$member->getHasKiNewsletter()){
  3561.                 $action = "on";
  3562.                 $payload = json_encode([
  3563.                     'firstName'   => $member->getFirstName(),
  3564.                     'lastName'    => $member->getLastName(),
  3565.                     'email'       => $member->getEmail(),
  3566.                     'phone'       => $member->getPhone(),
  3567.                     'linkedIn'    => $member->getLinkedin(),
  3568.                     'utmSource'   => 'Allmeda',
  3569.                     'utmMedium'   => $application->getBatchSlug(),
  3570.                     'utmCampaign' => '',
  3571.                     'action'      => $action
  3572.                 ]);
  3573.                 ##todo newsletter anmeldung neu denken
  3574.                 if ($batch->getProgramId() != 30) {
  3575.                     $response = Utility::curl_callback("https://hook.eu2.make.com/8258grek86fuwqjgi7dh3npvowxjvfk5", $payload);
  3576.                     if ($action == 'on') {
  3577.                         $action = true;
  3578.                     }
  3579.                     $member->setHasKiNewsletter((bool)$action);
  3580.                     $em->persist($member);
  3581.                 }
  3582.             }
  3583.         }
  3585.         if (!$settings) {
  3586.             $application->setStartupName("Test Startup");
  3587.             $application->setEmail($user->getEmail());
  3588.         }
  3590.         $lang = $batch->getLang();
  3592.         $program = $batch->getProgram();
  3593.         $routeParameters = [
  3594.             'programSlug' => $program->getSlug(),
  3595.             'batchSlug' => $batch->getSlug(),
  3596.             'lang'      => $lang,
  3597.         ];
  3599.         $targetPath = $this->generateUrl('apply_program_home', $routeParameters);
  3600.         $loginLink  = $this->loginService->getLoginLinkByTargetPath($application->getEmail(), $targetPath);
  3602.         // Get event for multi-batch check
  3603.         $event = null;
  3604.         if ($batch->getEventId()) {
  3605.             $event = $em->getRepository(Event::class)->find($batch->getEventId());
  3606.         }
  3608.         // Use MailTemplateService for confirmation mail
  3609.         $confirmationMail = $this->mailTemplateService->renderConfirmationMail(
  3610.             $batch,
  3611.             $user,
  3612.             $application,
  3613.             $loginLink,
  3614.             $event
  3615.         );
  3617.         $feedback = Utility::sendAlertMailPerZapier(
  3618.             $application->getEmail(), 
  3619.             $confirmationMail['html'], 
  3620.             $confirmationMail['subject'], 
  3621.             $batch->getSenderMail(), 
  3622.             $batch->getFromName(), 
  3623.             'html'
  3624.         );
  3625.         $application->setHasConfirmationMailSent(true);
  3626.         $application = $em->getRepository(Application::class)->setApplicationDoneWithoutWorkflow($application);
  3628.         // Use MailTemplateService for admin notification mail
  3629.         $adminMail = $this->mailTemplateService->renderAdminNotificationMail(
  3630.             $batch,
  3631.             $user,
  3632.             $application
  3633.         );
  3635.         // Send admin notification mail
  3636.         if ($batch->getRecipientMonitoringMail()) {
  3637.             Utility::sendDirectMail(
  3638.                 $this->mailer, 
  3639.                 $adminMail['subject'], 
  3640.                 $application->getEmail(), 
  3641.                 '', 
  3642.                 $batch->getRecipientMonitoringMail(), 
  3643.                 '', 
  3644.                 $adminMail['body'], 
  3645.                 false
  3646.             );
  3647.         }
  3649.         // sanitize title field
  3650.         if (!$em->getRepository(Member::class)->isTitleValid($member->getTitle())) {
  3651.             // Titel sanitizen, z. B. auf null setzen oder einen Standardwert zuweisen
  3652.             $member->setTitle("") ;
  3653.         }
  3655.         // Update member statistics and sync with hubspot
  3656.         $this->memberHubspotService->updateMemberStatisticsAndSyncWithHubspot($member, false);
  3658.         // Assuming updateMemberStatistics directly updates and persists the member entity
  3659.         $em->flush();
  3660.         $em->refresh($member);
  3662.         if ($batch->getSkoolWebhook() > ''){
  3663.             $feedback = $this->callbackService->sendPostRequest($batch->getSkoolWebhook(), $application->getEmail());
  3664.         }
  3666.         if ($batch->getZapierWebhook() > ''){
  3667.             $payload = json_encode($em->getRepository(Event::class)->setPayloadSingleApplicationAndBatch($application, $batch));
  3668.             $callbackUrl = $batch->getZapierWebhook();
  3669.             $feedback = $this->callbackService->curl_callback($callbackUrl, $payload);
  3670.         }
  3672.         return $feedback;
  3673.     }
  3676.     /**
  3677.      * @Route("/archiv/event/{slug}/", name="event_archiv_show")
  3678.      */
  3679.     public function showAction(Request $request, $slug)
  3680.     {
  3681.         if ($slug == '22-rheinland-pitch-mai-2015-2015-04-27-1430300112') {
  3682.             return $this->redirect($this->generateUrl('event_archiv_show', ['slug' => '23-rheinland-pitch-juni-2015-finale-duesseldorf']));
  3683.         }
  3684.         if ($slug == 'rheinland-pitch') {
  3685.             return $this->redirect($this->generateUrl('event_archiv_show', ['slug' => '01-rheinland-pitch-april-2013']));
  3686.         }
  3687.         if ($slug == 'rheinland-pitch-mai') {
  3688.             return $this->redirect($this->generateUrl('event_archiv_show', ['slug' => '02-rheinland-pitch-mai-2013']));
  3689.         }
  3690.         if ($slug == 'rheinland-pitch-juni') {
  3691.             return $this->redirect($this->generateUrl('event_archiv_show', ['slug' => '03-rheinland-pitch-juni-2013']));
  3692.         }
  3693.         if ($slug == 'rheinland-pitch-august') {
  3694.             return $this->redirect($this->generateUrl('event_archiv_show', ['slug' => '05-rheinland-pitch-august-2013']));
  3695.         }
  3696.         if ($slug == 'rheinland-pitch-september') {
  3697.             return $this->redirect($this->generateUrl('event_archiv_show', ['slug' => '06-rheinland-pitch-september-2013']));
  3698.         }
  3699.         if ($slug == 'rheinland-pitch-oktober') {
  3700.             return $this->redirect($this->generateUrl('event_archiv_show', ['slug' => '07-rheinland-pitch-oktober-2013']));
  3701.         }
  3702.         if ($slug == 'rheinland-pitch-november') {
  3703.             return $this->redirect($this->generateUrl('event_archiv_show', ['slug' => '08-rheinland-pitch-november-2013']));
  3704.         }
  3705.         if ($slug == 'rheinland-pitch-januar') {
  3706.             return $this->redirect($this->generateUrl('event_archiv_show', ['slug' => '09-rheinland-pitch-januar-2014']));
  3707.         }
  3708.         if ($slug == 'rheinland-pitch-februar') {
  3709.             return $this->redirect($this->generateUrl('event_archiv_show', ['slug' => '10-rheinland-pitch-februar-2014']));
  3710.         }
  3711.         if ($slug == 'rheinland-pitch-marz') {
  3712.             return $this->redirect($this->generateUrl('event_archiv_show', ['slug' => '11-rheinland-pitch-maerz-2014']));
  3713.         }
  3714.         if ($slug == 'rheinland-pitch-april') {
  3715.             return $this->redirect($this->generateUrl('event_archiv_show', ['slug' => '12-rheinland-pitch-april-2014']));
  3716.         }
  3717.         if ($slug == 'rheinland-pitch-mai-3') {
  3718.             return $this->redirect($this->generateUrl('event_archiv_show', ['slug' => '13-rheinland-pitch-mai-2014']));
  3719.         }
  3720.         if ($slug == 'rheinland-pitch-juni-2') {
  3721.             return $this->redirect($this->generateUrl('event_archiv_show', ['slug' => '14-rheinland-pitch-juni-2014']));
  3722.         }
  3723.         if ($slug == '22-rheinland-pitch-mai-2015-2015-04-27') {
  3724.             return $this->redirect($this->generateUrl('event_archiv_show', ['slug' => '22-rheinland-pitch-mai-2015']));
  3725.         }
  3728.         $templateVars = $this->getEventComRep()->getStartPlatzEventBaseTemplateVars($request);
  3730.         if (!$event = $this->getEventRepository()->findOneBy(['slug' => $slug])) {
  3731.             $querySlug = '/' . $slug;
  3732.             if (!$event = $this->getEventRepository()->findOneBy(['slug' => $querySlug])) {
  3733.                 $this->session->getFlashBag()->add('notice', 'ERROR Veranstaltung nicht gefunden');
  3734.                 return $this->redirect($this->generateUrl('events_list'));
  3735.             } else {
  3736.                 $em = $this->getDoctrine()->getManager();
  3737.                 $event->setSlug($slug);
  3738.                 $em->persist($event);
  3739.                 $em->flush();
  3740.             }
  3741.         }
  3743.         if ($event->getStatus() != 'publish') {
  3744.             if (!$this->getUser()) {
  3745.                 return $this->redirect($this->generateUrl('events_list', $templateVars));
  3746.             }
  3747.         }
  3749.         //previous @StartPlatzEventBundle/Default/show.html.twig
  3751.         return $this->render('@StartPlatzEventBundle/Default/event-single.html.twig', [
  3752.             'templateVars' => $templateVars,
  3753.             'event'        => $event,
  3755.             'batch'        => false,
  3756.             'speakers'     => [],
  3759.             'menuLinksAndPhrases' => $this->menuTranslationService->getMenuLinksAndPhrases($request->server->get('REQUEST_URI')),
  3760.         ]);
  3761.     }
  3763.     /**
  3764.      */
  3765.     public function eventsThisWeekAction()
  3766.     {
  3767.         $year = date('Y');
  3768.         $month = date('m');
  3769.         $moreFutureEvents = $this->getEventBaseRepository()->getEventsByWeek($this->getEventComRep()->setBaseCriteria([]), $year, $month);
  3771.         return $this->render('@StartPlatzEventBundle/Default/events_this_week.html.twig', [
  3772.             'moreFutureEvents' => $moreFutureEvents,
  3773.         ]);
  3775.     }
  3777.     private function getRedirects()
  3778.     {
  3779.         return [
  3780.             'Best-Practice-Digitalisierung-Januar-2018' => 'best-practice-digitalisierung',
  3781.             'best-practice-digitalisierung-3' => 'best-practice-digitalisierung',
  3782.             'adwords-fuer-einsteiger-' => 'adwords-fuer-einsteiger-koeln-2017-01-24',
  3783.             'adwords-fur-einsteiger-'  => 'adwords-fuer-einsteiger-koeln-2016-06-06',
  3784.             'adwords-fur-einsteiger-DUS' => 'adwords-fuer-einsteiger-dus-2016-06-07',
  3785.             '-adwords-fuer-einsteiger' => 'adwords-fur-einsteiger',
  3786.             'adwords-fur-einsteiger-2016-02-16' => 'adwords-fuer-einsteiger-koeln-2016-02-16',
  3787.             'digital-networking-week-1611257320' => 'digital-networking-week',
  3788.             'chatgpt3-how-to-prompt-duesseldorf' => 'chatgpt-how-to-prompt-duesseldorf'
  3789.         ];
  3790.     }
  3794.     private function setMonsumAccountIfNotExists(Member $member, Team $team, Application $application, $account)
  3795.     {
  3796.         $em = $this->getDoctrine()->getManager();
  3797.         $adminEmail = $member->getEmail();
  3798.         $responseContent = [];
  3799.         $teamId = $team->getId();
  3800.         $customer = null;
  3801.         $monsumCustomer = null;
  3803.         $settings = ['adminEmail' => $adminEmail, 'location' => $em->getRepository(Customer::class)->getLocationByAccount($account), 'account' => $account, 'accountHash' => $em->getRepository(Customer::class)->getAccountHashByAccount($account)];
  3805.         $login = $em->getRepository(Customer::class)->getLoginByAccount($account);
  3807.         $payload = json_encode(['SERVICE' => "customer.get", 'FILTER' => ['CUSTOMER_EXT_UID' => "{$team->getId()}"]]);
  3809.         $feedback = $this->callbackService->curl_get_monsum_all($payload, $login);
  3810.         $feedback = json_decode((string) $feedback);
  3812.         if (isset($feedback->RESPONSE->CUSTOMERS[0])) {
  3813.             $responseContent[] = "Team {$teamId} has already account in Monsum";
  3814.             $customer = $feedback->RESPONSE->CUSTOMERS[0];
  3815.         } else {
  3816.             $responseContent[] = "New account will be created for team {$teamId} in Monsum";
  3818.             $customerSettings = $em->getRepository(Customer::class)->getCustomerSettingsByTeamAndMember($team, $member);
  3819.             $payload = json_encode(['SERVICE' => "customer.create", 'DATA' => $customerSettings]);
  3821.             $feedback = $this->callbackService->curl_get_monsum_all($payload, $login);
  3822.             $feedback = json_decode((string) $feedback);
  3823.             $monsumResponse = $feedback->RESPONSE;
  3824.             if (isset($monsumResponse->ERRORS)) {
  3825.                 $responseContent[] = "ERROR ======== ERROR";
  3826.                 $responseContent[] = $monsumResponse->ERRORS;
  3827.                 $responseContent[] = $feedback;
  3828.             } else {
  3829.                 $responseContent[] = $monsumResponse;
  3830.                 if ($monsumResponse->STATUS == "success") {
  3831.                     $customerId = $monsumResponse->CUSTOMER_ID;
  3832.                     $payload = $em->getRepository(Customer::class)->getPayloadSingleCustomerByCustomerId($customerId);
  3833.                     $feedback = $this->callbackService->curl_get_monsum_all($payload, $login);
  3834.                     if ($feedback = json_decode((string) $feedback)) {
  3835.                         $customer = $feedback->RESPONSE->CUSTOMERS[0];
  3836.                     } else {
  3837.                         $responseContent[] = "ERROR: could not decode feedback from monsum";
  3838.                         $responseContent[] = $feedback;
  3839.                     }
  3840.                 }
  3841.             }
  3842.         }
  3844.         if ($customer) {
  3845.             $monsumCustomer = $em->getRepository(Customer::class)->createOrUpdateMonsumCustomerByTeam($customer, $settings, $team);
  3846.         }
  3848.         return $monsumCustomer;
  3849.     }
  3852.     private function prepareCustomerForMonsumCheckout(Application $application, Product $product, $memberToBeRegistered)
  3853.     {
  3854.         // see applyController $this->goToMonsum( ... )
  3855.         $em = $this->getDoctrine()->getManager();
  3857.         // save member, assign member to team, save application
  3858.         $data['email'] = $application->getEmail();
  3859.         $data['name']  = $application->getPerson();
  3860.         $adminEmail    = $application->getEmail();
  3862.         if (!$memberToBeRegistered) {
  3863.             $memberToBeRegistered = $this->createGuestMember($application);
  3864.         }
  3866.         $team     = $em->getRepository(Team::class)->createNewMonsumAccountTeamByMembershipApplicant($memberToBeRegistered);
  3868.         $customer = $this->setMonsumAccountIfNotExists($memberToBeRegistered, $team, $application, $product->getAccount());
  3870.         $productNumber = $product->getProductNumber();
  3872.         $customer = $em->getRepository(Customer::class)->setCheckoutData($customer, $product->getAccount(), $productNumber, $memberToBeRegistered->getId());
  3874.         $response = [
  3875.             'status'  => 'success',
  3876.             'message' => 'accounts created',
  3877.             'data'    => [
  3878.                 'memberToBeRegistered'      => $memberToBeRegistered,
  3879.                 'customer'                  => $customer,
  3880.                 'team'                      => $team,
  3881.             ],
  3882.         ];
  3884.         return $response;
  3885.     }
  3888.     private function legacyPaymentProcess($application, $isMemberloggedIn, $em, $batch, $member, $event){
  3889.         if ($application->getRealPriceinEuroCent()){
  3890.             if ($isMemberloggedIn){
  3891.                 // bei monsum zahlen
  3893.                 if (!$product = $em->getRepository(Product::class /*Product Member*/)->find($batch->getProductId())) {
  3894.                     $this->session->getFlashBag()->add('notice', 'ERROR configuration not found');
  3895.                     return $this->redirect($this->generateUrl('events_list'));
  3896.                 }
  3898.                 $account = $product->getAccount();
  3900.                 if (!$customer = $em->getRepository(Customer::class)->findPrimaryMonsumAccount($member, $account)) {
  3901.                     $this->session->getFlashBag()->add('notice', 'ERROR monsum customer not found');
  3902.                     return $this->redirect($this->generateUrl('events_list'));
  3903.                     //$team = $em->getRepository(Team::class)->createTeamByMembershipApplicant($member);
  3904.                     //$customer = $this->setMonsumAccountIfNotExists($member, $team, $application, $account);
  3905.                 }
  3907.                 $productNumber = $product->getProductNumber();
  3908.                 $customer = $em->getRepository(Customer::class)->setCheckoutData($customer, $account, $productNumber, $member->getId());
  3910.                 $unitPrice = $application->getRealPriceinEuroCent() / 100;
  3911.                 $login = $em->getRepository(Customer::class)->getLoginByAccount($customer->getAccount());
  3912.                 $payload = json_encode(['SERVICE' => "subscription.create", 'DATA' => ['CUSTOMER_ID'    => "{$customer->getCustomerId()}", 'ARTICLE_NUMBER' => "31011", 'UNIT_PRICE'     => "{$unitPrice}", 'TITLE'          => "Teilnahme an STARTPLATZ Event", 'DESCRIPTION'    => "{$event->getTitle()} am {$event->getStartDate()->format('d.m.Y')}", 'START_DATE'     => "{$event->getStartDate()->format('Y-m-d')}"]]);
  3913.                 // Set URL to call back
  3914.                 $callbackUrl = "https://app.monsum.com/api/1.0/api.php";
  3916.                 $feedback = Utility::curl_callback($callbackUrl, $payload, $login);
  3918.                 $feedback = json_decode((string) $feedback);
  3920.                 if (isset($feedback->RESPONSE->STATUS) and $feedback->RESPONSE->STATUS == "success") {
  3921.                     $subscriptionId = $feedback->RESPONSE->SUBSCRIPTION_ID;
  3922.                     $application->setEditStatus("sucess:subscriptionId=={$subscriptionId}");
  3923.                     $application = $em->getRepository(Application::class)->setHistory($application, $application->getEditMessage());
  3924.                     $application->setApplicationStatus('applied');
  3925.                     $em->persist($application);
  3926.                     $em->flush();
  3928.                 } else {
  3929.                     $application->setEditStatus("error:monsum-purchase-failed");
  3930.                     $em->persist($application);
  3931.                     $em->flush();
  3933.                     $action = "error";
  3934.                 }
  3935.             }
  3936.         }
  3937.     }
  3939. }