src/StartPlatz/Bundle/AlphaBundle/Controller/StartupController.php line 564

Open in your IDE?
  1. <?php declare(strict_types=1);
  3. namespace App\StartPlatz\Bundle\AlphaBundle\Controller;
  5. use App\StartPlatz\Bundle\AlphaBundle\Entity\Feed;
  6. use App\StartPlatz\Bundle\AlphaBundle\Entity\Page;
  7. use App\StartPlatz\Bundle\MemberBundle\Entity\Member;
  8. use App\StartPlatz\Bundle\MemberBundle\Entity\MemberTeam;
  9. use App\StartPlatz\Bundle\MemberBundle\Entity\Option;
  10. use App\StartPlatz\Bundle\MemberBundle\Entity\Team;
  11. use App\StartPlatz\Bundle\StartupBundle\Entity\Application;
  12. use App\StartPlatz\Bundle\StartupBundle\Entity\Batch;
  13. use App\StartPlatz\Bundle\StartupBundle\Entity\Startup;
  14. use App\StartPlatz\Bundle\StartupBundle\Entity\StartupAttribute;
  15. use App\StartPlatz\Bundle\StartupBundle\Entity\StartupLifecycleEvent;
  16. use App\StartPlatz\Bundle\StartupBundle\Entity\StartupRelevance;
  17. use App\StartPlatz\Bundle\StartupBundle\Form\LivecycleEventType;
  18. use App\StartPlatz\Bundle\WebsiteBundle\Utility\Utility;
  19. use DateTime;
  20. use Eckinox\TinymceBundle\Form\Type\TinymceType;
  21. use Speicher210\CloudinaryBundle\Cloudinary\Api;
  22. use Symfony\Component\HttpFoundation\Response;
  23. use stdClass;
  24. use Symfony\Component\Mailer\Exception\TransportExceptionInterface;
  25. use Symfony\Component\Mime\Address;
  26. use Symfony\Component\Mime\Email;
  27. use Symfony\Component\Routing\Annotation\Route;
  28. use Sensio\Bundle\FrameworkExtraBundle\Configuration\IsGranted;
  29. use App\StartPlatz\Bundle\FeedbackBundle\FeedbackService;
  30. use App\StartPlatz\Bundle\StartupBundle\Form\StartupType;
  31. use App\StartPlatz\Bundle\UserBundle\Entity\User;
  32. use App\StartPlatz\Bundle\MentorsBundle\Service\WordPressMenuService;
  33. use Doctrine\ORM\EntityManagerInterface;
  34. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  35. use Symfony\Component\Form\Extension\Core\Type\SubmitType;
  36. use Symfony\Component\Form\Extension\Core\Type\TextareaType;
  37. use Symfony\Component\Form\FormFactoryInterface;
  38. use Symfony\Component\Mailer\MailerInterface;
  39. use Symfony\Component\HttpFoundation\Request;
  41. class StartupController extends AbstractController
  42. {
  43.     public function __construct(
  44.         private readonly EntityManagerInterface $entityManager,
  45.         private readonly FormFactoryInterface $formFactory,
  46.         private readonly FeedbackService $feedbackService,
  47.         private readonly Api $cloudinary,
  48.         private readonly MailerInterface $mailer,
  49.         private readonly WordPressMenuService $wordPressMenuService
  50.     ) {
  51.     }
  53.     // NOTE: AcceleratorStartupsIndexAction was moved to AcceleratorStartupController
  54.     // Routes: /accelerator/startups and /en/accelerator/startups
  56.     #[Route('/x/connect/startups/home', name: 'connect_startup_index')]
  57.     /**
  58.      * @IsGranted("ROLE_USER")
  59.      */
  60.     public function indexStartupsSpconnectAction(Request $request): Response
  61.     {
  62.         return $this->redirectToRoute('connect_startup_index', $request->query->all(), 301);
  63.     }
  65.     #[Route('/startups', name: 'homepage_startups_home')]
  66.     #[Route('/en/startups', name: 'homepage_startups_home_english')]
  67.     #[Route('/fr/startups', name: 'homepage_startups_home_french')]
  68.     public function indexStartupsHomepageAction(Request $request)
  69.     {
  70.                 $redirect     = json_decode(base64_decode((string) $request->get('redirect')));
  71.         $redirectUrl  = $request->get('redirect');
  72.         $templateVars = $this->entityManager->getRepository(Startup::class)->getTemplateVars($request);
  74.         $orderBy = $templateVars['dimensions'] ?: ['lastModified' => 'DESC'];
  75.         $visibility   = 'public';
  76.         $criteria     = ['visibility' => $visibility] + $templateVars['criteria'];
  77.         $lang         = Utility::getLangByPathInfo($request->getPathInfo());
  79.         $teamId = 0;
  80.         if ($user = $this->getUser()) {
  81.             $teamId = $user->getMemberId();
  82.             $this->entityManager->getRepository(User::class)->writeActivity($user);
  83.         }
  85.         $total = $this->entityManager->getRepository(Startup::class)->countByCriteria($criteria, $teamId);
  87.         if ($total > 2560) {
  88.             $limit = 2560;
  89.         } else {
  90.             $limit = $total ?: 1;
  91.         }
  92.         if (!$page = $request->get('page')) {
  93.             $page = 1;
  94.         }
  96.         $startups = $this->entityManager->getRepository(Startup::class)->findPaginated($criteria, $teamId, $orderBy, $page, $limit);
  97.         // UP-024: startplatz field removed from Startup entity
  98.         $startupsExtern = [];
  100.         $rheinlandPitchBatches = [];
  101.         $rheinlandPitchWinnerApplications = [];
  102.         $rheinlandPitchWinnerStartups = [];
  104.         if (array_key_exists("rheinlandPitchBestResult", $criteria)) {
  105.             /*
  106.              * now use a totally different logic
  107.              * first we find all rheinlandPitchBatches
  108.              * then we find all winnerApplications
  109.              * then we find all related startups
  110.              */
  112.             $rheinlandPitchBatches = $this->entityManager->getRepository(Batch::class)->findBy(['programId'=>1,'focusStatus'=>['4_past','3_previous','2_current']], ['pitchDate'=>'DESC']);
  113.             $rheinlandPitchWinnerApplications = $this->entityManager->getRepository(Application::class)->findBy(['programId'=>1,'pitchPosition'=>1], ['batchId'=>'DESC']);
  114.             $rheinlandPitchWinnerStartupIds = array_map(fn (Application $entity) => $entity->getStartupId(), $rheinlandPitchWinnerApplications);
  115.             $rheinlandPitchWinnerStartups = $this->entityManager->getRepository(Startup::class)->findBy(['id'=>$rheinlandPitchWinnerStartupIds]);
  116.             $rheinlandPitchWinnerStartupIds = array_map(fn (Startup $entity) => $entity->getId(), $rheinlandPitchWinnerStartups);
  117.             $rheinlandPitchWinnerStartups  = array_combine($rheinlandPitchWinnerStartupIds, $rheinlandPitchWinnerStartups);
  118.         }
  120.         $parentPageSlug = "startups";
  121.         if (!$parentPage = $this->entityManager->getRepository(Page::class)->findOneBy(['slug' => $parentPageSlug])) {
  122.             $parentPage = new Page();
  123.             $parentPage->setTitle('Die STARTPLATZ Startups');
  124.             $parentPage->setTeaser('Die erfolgreichen Startups starten hier durch');
  125.             $parentPage->setDescription('Page Description');
  126.         }
  128.         $acceleratorCurrentBatchNumber = $this->entityManager->getRepository(Option::class)->getAcceleratorCurrentBatchNumber();
  130.         $startupsCurrentBatch = $this->entityManager->getRepository(Startup::class)->findPaginated($criteria + ['batch' => $acceleratorCurrentBatchNumber], $teamId, $orderBy, 1, 128);
  131.         $startupsLastBatch = $this->entityManager->getRepository(Startup::class)->findPaginated($criteria + ['batch' => $acceleratorCurrentBatchNumber -1 ], $teamId, $orderBy, 1, 128);
  132.         $startupsBatch20 = $this->entityManager->getRepository(Startup::class)->findPaginated($criteria + ['batch' => $acceleratorCurrentBatchNumber -2], $teamId, $orderBy, 1, 128);
  133.         // UP-024: startplatz field removed from Startup entity - these sections now empty
  134.         $startupsSpCgn = [];
  135.         $startupsSpDus = [];
  136.         $startupsAlumni = [];
  138.         // UP-024: pitchNumber, rheinlandPitch, rheinlandPitchBestResult fields removed from Startup entity
  139.         $startupsRheinlandPitch = [];
  140.         // Use findCurrentRheinlandPitchStartups() which queries via Application/Batch instead:
  141.         // $startupsRheinlandPitch = $this->entityManager->getRepository(Startup::class)->findCurrentRheinlandPitchStartups('2_current');
  143.         $startupsGruenderstipendium = [];
  144.         $startupsGruenderstipendium = $this->entityManager->getRepository(Startup::class)->findPaginated($criteria + ['gsStatus' => ['funded','recommended']], $teamId, $orderBy, 1, 1280);
  146.         $startupsGruenderstipendiumAlumni = [];
  147.         $startupsGruenderstipendiumAlumni = $this->entityManager->getRepository(Startup::class)->findPaginated($criteria + ['gsStatus' => ['alumni']], $teamId, $orderBy, 1, 1280);
  149.         $industries = $this->entityManager->getRepository(Startup::class)->getAggregateByGroup('industry', $criteria);
  151.         // get teamIds
  152.         $teamIds = array_map(fn ($entity) => $entity['teamId'], $startups);
  153.         $teamIds = $teamIds + array_map(fn ($entity) => $entity['teamId'], $startupsCurrentBatch);
  154.         $teamIds = $teamIds + array_map(fn ($entity) => $entity['teamId'], $startupsLastBatch);
  155.         $teamIds = $teamIds + array_map(fn ($entity) => $entity['teamId'], $startupsBatch20);
  156.         $teamIds = $teamIds + array_map(fn ($entity) => $entity['teamId'], $startupsSpCgn);
  157.         $teamIds = $teamIds + array_map(fn ($entity) => $entity['teamId'], $startupsSpDus);
  158.         $teamIds = $teamIds + array_map(fn ($entity) => $entity['teamId'], $startupsAlumni);
  159.         $teamIds = $teamIds + array_map(fn ($entity) => $entity['teamId'], $startupsExtern);
  160.         $teamIds = $teamIds + array_map(fn ($entity) => $entity['teamId'], $startupsRheinlandPitch);
  161.         $teamIds = $teamIds + array_map(fn ($entity) => $entity['teamId'], $startupsGruenderstipendium);
  162.         $teamIds = $teamIds + array_map(fn ($entity) => $entity['teamId'], $startupsGruenderstipendiumAlumni);
  164.         $teams = $this->entityManager->getRepository(Team::class)->findBy(['id'=>$teamIds]);
  165.         $teamIds = array_map(fn ($entity) => $entity->getId(), $teams);
  166.         $teams = array_combine($teamIds, $teams);
  168.         return $this->render('@StartPlatzAlphaBundle/Startup/startups.sp-public-spring-26.html.twig', [
  169.             'startups' => $startups,
  170.             'startupsCurrentBatch' => $startupsCurrentBatch,
  171.             'startupsLastBatch' => $startupsLastBatch,
  172.             'startupsBatch20' => $startupsBatch20,
  173.             'startupsSpCgn' => $startupsSpCgn,
  174.             'startupsSpDus' => $startupsSpDus,
  175.             'startupsAlumni' => $startupsAlumni,
  176.             'startupsExtern' => $startupsExtern,
  177.             'startupsRheinlandPitch'     => $startupsRheinlandPitch,
  178.             'startupsGruenderstipendium'       => $startupsGruenderstipendium,
  179.             'startupsGruenderstipendiumAlumni' => $startupsGruenderstipendiumAlumni,
  180.             'teams'              => $teams,
  181.             'currentBatchNumber' => $acceleratorCurrentBatchNumber,
  182.             'industries'         => $industries,
  183.             'parentPage'         => $parentPage,
  184.             'pageType'           => 'startup',
  185.             'topic'              => 'deepTech',
  186.             'lang' => $lang,
  188.             'rheinlandPitchBatches' => $rheinlandPitchBatches,
  189.             'rheinlandPitchWinnerApplications' => $rheinlandPitchWinnerApplications,
  190.             'rheinlandPitchWinnerStartups' => $rheinlandPitchWinnerStartups,
  192.         'maxPages' => ceil($total / $limit),
  193.             'thisPage' => $page,
  194.             'total' => $total,
  195.             'limit' => $limit,
  196.             'criteria' => $criteria,
  197.             'visibility' => $visibility,
  199.             'templateVars' => $templateVars,
  201.             'backUrl' => $redirectUrl,
  203.             'redirectUrl' => base64_encode(json_encode(['path' => 'website_startups_list', 'parameters' => $templateVars])),
  204.         ]);
  205.     }
  207.     #[Route('/x/startups/industries/list', name: 'x_startups_industries_list')]
  208.     public function listIndustriesAjaxAction(Request $request)
  209.     {
  210.                 $redirect = json_decode(base64_decode((string) $request->get('redirect')));
  211.         $templateVars = $this->entityManager->getRepository(Startup::class)->getTemplateVars($request);
  212.         $currentCriteria = $templateVars['criteria'];
  213.         if (isset($templateVars['criteria']['industry'])) {
  214.             unset($templateVars['criteria']['industry']);
  215.         }
  216.         if (isset($templateVars['criteria']['isBookmarked'])) {
  217.             unset($templateVars['criteria']['isBookmarked']);
  218.         }
  220.         if (!$source = $request->get('source')) {
  221.             $visibility = 'sp-connect';
  222.             $targetPath = "connect_startup_index";
  223.         } else {
  224.             $visibility = 'public';
  225.             $targetPath = "homepage_startups_home";
  226.         }
  228.         $criteria = ['visibility' => $visibility, 'status' => 'active', 'team' => 'exists'] + $templateVars['criteria'];
  229.         if ($user = $this->getUser()) {
  230.             $teamId = $user->getMemberId();
  231.         } else {
  232.             $teamId = 0;
  233.         }
  235.         $industries = $this->entityManager->getRepository(Startup::class)->findIndustries($criteria, $teamId);
  237.         return $this->render('@StartPlatzAlpha/Default/list.startupIndustries.modal.html.twig', [
  238.             'title' => "Available Industries",
  239.             'industries' => $industries,
  241.             'targetPath'      => $targetPath,
  242.             'currentCriteria' => $currentCriteria,
  243.             'templateVars'    => $templateVars,
  244.             'redirectUrl' => $request->get('redirect'),
  245.         ]);
  246.     }
  248.     #[Route('/x/startups/tags/list', name: 'x_startups_tags_list')]
  249.     public function listTagsAjaxAction(Request $request)
  250.     {
  251.                 $redirect = json_decode(base64_decode((string) $request->get('redirect')));
  252.         $templateVars = $this->entityManager->getRepository(Startup::class)->getTemplateVars($request);
  253.         $currentCriteria = $templateVars['criteria'];
  254.         if (isset($templateVars['criteria']['tags'])) {
  255.             unset($templateVars['criteria']['tags']);
  256.         }
  257.         if (isset($templateVars['criteria']['isBookmarked'])) {
  258.             unset($templateVars['criteria']['isBookmarked']);
  259.         }
  261.         if (!$source = $request->get('source')) {
  262.             $visibility = 'sp-connect';
  263.             $targetPath = "connect_startup_index";
  264.         } else {
  265.             $visibility = 'public';
  266.             $targetPath = "homepage_startups_home";
  267.         }
  269.         $criteria = ['visibility' => $visibility, 'status' => 'active', 'team' => 'exists'] + $templateVars['criteria'];
  270.         if ($user = $this->getUser()) {
  271.             $teamId = $user->getMemberId();
  272.         } else {
  273.             $teamId = 0;
  274.         }
  276.         $entities = $this->entityManager->getRepository(Startup::class)->findTags($criteria, $teamId);
  278.         return $this->render('@StartPlatzAlpha/Default/list.tags.modal.html.twig', [
  279.             'title' => "Tags",
  280.             'entities' => $entities,
  281.             'btnClass' => "btn-outline-info",
  282.             'targetEntity' => "tags",
  283.             'targetPath' => $targetPath,
  284.             'currentCriteria' => $currentCriteria,
  285.             'templateVars' => $templateVars,
  286.             'redirect' => $redirect,
  287.             'redirectUrl' => $request->get('redirect'),
  288.         ]);
  289.     }
  291.     #[Route('/x/startups/filter/rheinland-pitch', name: 'x_startups_filter_rheinland-pitch')]
  292.     public function selectFilterRheinlandPitchAction(Request $request)
  293.     {
  294.                 $redirect = json_decode(base64_decode((string) $request->get('redirect')));
  295.         $templateVars = $this->entityManager->getRepository(Startup::class)->getTemplateVars($request);
  296.         if (!$source = $request->get('source')) {
  297.             $visibility = 'sp-connect';
  298.             $targetPath = "connect_startup_index";
  299.         } else {
  300.             $visibility = 'public';
  301.             $targetPath = "homepage_startups_home";
  302.         }
  304.         $criteria = ['visibility' => $visibility, 'status' => 'active', 'team' => 'exists'] + $templateVars['criteria'];
  305.         if ($user = $this->getUser()) {
  306.             $teamId = $user->getMemberId();
  307.         } else {
  308.             $teamId = 0;
  309.         }
  311.         $filter = $request->get('filter');
  313.         // UP-024: rheinlandPitchStatus, rheinlandPitchBestResult fields removed from Startup entity
  314.         $group1 = "";
  315.         $aggregates1 = [];
  317.         $group2 = "";
  318.         $aggregates2 = [];
  320.         // batches
  321.         $aggregatesBatches = $this->entityManager->getRepository(Startup::class)->findApplicationsByProgramId(1);
  323.         return $this->render('@StartPlatzAlpha/Default/list.rheinland-pitch.modal.html.twig', [
  324.             'title'             => "Set Filter on {$filter}",
  325.             'btnClass'          => "btn-outline-info",
  326.             'group1'            => $group1,
  327.             'group2'            => $group2,
  328.             'aggregates1'       => $aggregates1,
  329.             'aggregates2'       => $aggregates2,
  330.             'aggregatesBatches' => $aggregatesBatches,
  331.             'targetPath'        => $targetPath,
  332.             'templateVars'      => $templateVars,
  333.             'redirect'          => $redirect,
  334.             'redirectUrl'       => $request->get('redirect'),
  335.         ]);
  336.     }
  338.     #[Route('/x/startups/filter', name: 'x_startups_filter')]
  339.     public function selectFilterAction(Request $request)
  340.     {
  341.                 $redirect = json_decode(base64_decode((string) $request->get('redirect')));
  342.         $templateVars = $this->entityManager->getRepository(Startup::class)->getTemplateVars($request);
  343.         if (!$source = $request->get('source')) {
  344.             $visibility = 'sp-connect';
  345.         } else {
  346.             $visibility = 'public';
  347.         }
  348.         if (!$targetPath = $request->get('targetPath')) {
  349.             if ($visibility == 'sp-connect') {
  350.                 $targetPath = "connect_startup_index";
  351.             } else {
  352.                 $targetPath = "homepage_startups_home";
  353.             }
  354.         }
  355.         $criteria = ['visibility' => $visibility, 'status' => 'active', 'team' => 'exists'] + $templateVars['criteria'];
  356.         if ($user = $this->getUser()) {
  357.             $teamId = $user->getMemberId();
  358.         } else {
  359.             $teamId = 0;
  360.         }
  362.         $group = $request->get('filter');
  363.         $aggregates = $this->entityManager->getRepository(Startup::class)->getAggregateByGroup($group, $criteria);
  365.         $group2 = "";
  366.         $aggregates2 = [];
  368.         // UP-024: accelerator, batch, batchYear, rheinlandPitch, pitchNumber fields removed from Startup entity
  369.         if ($group == 'accelerator') {
  370.             $aggregates = []; // Field removed
  371.         }
  372.         if ($group == 'rheinlandPitch') {
  373.             $aggregates = []; // Field removed
  374.         }
  376.         return $this->render('@StartPlatzAlpha/Default/list.aggregates.modal.html.twig', [
  377.             'title'        => "Set Filter on {$group}",
  378.             'aggregates'   => $aggregates,
  379.             'btnClass'     => "btn-outline-info",
  380.             'group'        => $group,
  381.             'group2'       => $group2,
  382.             'aggregates2'  => $aggregates2,
  383.             'targetPath'   => $targetPath,
  384.             'templateVars' => $templateVars,
  385.             'redirect'     => $redirect,
  386.             'redirectUrl'  => $request->get('redirect'),
  387.         ]);
  388.     }
  390.     #[Route('/startups-legacy', name: 'extern_startups_home')]
  391.     public function indexLegacyAction(Request $request)
  392.     {
  393.                 $member = $this->entityManager->getRepository(Member::class)->findOneBy([]);
  394.         $fields = $this->feedbackService->getEntityMethodsArray($member, ['teams']);
  395.         $templateVars = $this->entityManager->getRepository(Member::class)->getTemplateVars($request);
  396.         if ($user = $this->getUser()) {
  397.             $this->entityManager->getRepository(User::class)->writeActivity($user);
  398.         }
  400.         $metaNameSectionBatch21 = 'website.startups.section.batch21';
  401.         $metaNameSectionBatch20 = 'website.startups.section.batch20';
  402.         $metaNameSectionBatch19 = 'website.startups.section.batch19';
  403.         $metaNameSectionBatch18 = 'website.startups.section.batch18';
  404.         $metaNameSectionBatch17 = 'website.startups.section.batch17';
  405.         $metaNameSectionKoeln = 'website.startups.section.koeln';
  406.         $metaNameSectionDus = 'website.startups.section.dus';
  407.         $metaNameSectionAlumni = 'website.startups.section.alumni';
  409.         $edit = $request->get('edit');
  410.         if (!in_array($edit, ['updateBatch21', 'updateBatch20', 'updateBatch19', 'updateBatch18', 'updateBatch17', 'updateKoeln', 'updateDus', 'updateAlumni'])) {
  411.             $edit = null;
  412.         }
  414.         $sectionBatch21 = $this->getSection($metaNameSectionBatch21);
  415.         $sectionBatch20 = $this->getSection($metaNameSectionBatch20);
  416.         $sectionBatch19 = $this->getSection($metaNameSectionBatch19);
  417.         $sectionBatch18 = $this->getSection($metaNameSectionBatch18);
  418.         $sectionBatch17 = $this->getSection($metaNameSectionBatch17);
  419.         $sectionKoeln = $this->getSection($metaNameSectionKoeln);
  420.         $sectionDus = $this->getSection($metaNameSectionDus);
  421.         $sectionAlumni = $this->getSection($metaNameSectionAlumni);
  423.         switch ($edit) {
  424.             case 'updateBatch21':
  425.                 $content = $this->transformArrayIntoCsvString($sectionBatch21['content']);
  426.                 $form = $this->setPlainEditorForm($content);
  427.                 break;
  428.             case 'updateBatch20':
  429.                 $content = $this->transformArrayIntoCsvString($sectionBatch20['content']);
  430.                 $form = $this->setPlainEditorForm($content);
  431.                 break;
  432.             case 'updateBatch19':
  433.                 $content = $this->transformArrayIntoCsvString($sectionBatch19['content']);
  434.                 $form = $this->setPlainEditorForm($content);
  435.                 break;
  436.             case 'updateBatch18':
  437.                 $content = $this->transformArrayIntoCsvString($sectionBatch18['content']);
  438.                 $form = $this->setPlainEditorForm($content);
  439.                 break;
  440.             case 'updateBatch17':
  441.                 $content = $this->transformArrayIntoCsvString($sectionBatch17['content']);
  442.                 $form = $this->setPlainEditorForm($content);
  443.                 break;
  444.             case 'updateKoeln':
  445.                 $content = $this->transformArrayIntoCsvString($sectionKoeln['content']);
  446.                 $form = $this->setPlainEditorForm($content);
  447.                 break;
  448.             case 'updateDus':
  449.                 $content = $this->transformArrayIntoCsvString($sectionDus['content']);
  450.                 $form = $this->setPlainEditorForm($content);
  451.                 break;
  452.             case 'updateAlumni':
  453.                 $content = $this->transformArrayIntoCsvString($sectionAlumni['content']);
  454.                 $form = $this->setPlainEditorForm($content);
  455.                 break;
  456.             default:
  457.                 $content = "";
  458.                 $form = $this->setEditorForm($content);
  459.         }
  461.         $form->handleRequest($request);
  463.         if ($form->isSubmitted() && $form->isValid()) {
  465.             $data = $form->getData();
  467.             $importString = $data['content'];
  468.             $rows = explode(PHP_EOL, (string) $importString);
  470.             switch ($edit) {
  471.                 case 'updateBatch21':
  472.                     $sectionBatch21['content'] = [];
  473.                     foreach ($rows as $row) {
  474.                         $sectionBatch21['content'][] = str_getcsv($row, "\t");
  475.                     }
  476.                     $this->entityManager->getRepository(Option::class)->setOptionMetaValueJsonEncoded($metaNameSectionBatch21, null, $sectionBatch21);
  477.                     break;
  478.                 case 'updateBatch20':
  479.                     $sectionBatch20['content'] = [];
  480.                     foreach ($rows as $row) {
  481.                         $sectionBatch20['content'][] = str_getcsv($row, "\t");
  482.                     }
  483.                     $this->entityManager->getRepository(Option::class)->setOptionMetaValueJsonEncoded($metaNameSectionBatch20, null, $sectionBatch20);
  484.                     break;
  485.                 case 'updateBatch19':
  486.                     $sectionBatch19['content'] = [];
  487.                     foreach ($rows as $row) {
  488.                         $sectionBatch19['content'][] = str_getcsv($row, "\t");
  489.                     }
  490.                     $this->entityManager->getRepository(Option::class)->setOptionMetaValueJsonEncoded($metaNameSectionBatch19, null, $sectionBatch19);
  491.                     break;
  492.                 case 'updateBatch18':
  493.                     $sectionBatch18['content'] = [];
  494.                     foreach ($rows as $row) {
  495.                         $sectionBatch18['content'][] = str_getcsv($row, "\t");
  496.                     }
  497.                     $this->entityManager->getRepository(Option::class)->setOptionMetaValueJsonEncoded($metaNameSectionBatch18, null, $sectionBatch18);
  498.                     break;
  499.                 case 'updateBatch17':
  500.                     $sectionBatch17['content'] = [];
  501.                     foreach ($rows as $row) {
  502.                         $sectionBatch17['content'][] = str_getcsv($row, "\t");
  503.                     }
  504.                     $this->entityManager->getRepository(Option::class)->setOptionMetaValueJsonEncoded($metaNameSectionBatch17, null, $sectionBatch17);
  505.                     break;
  506.                 case 'updateKoeln':
  507.                     $sectionKoeln['content'] = [];
  508.                     foreach ($rows as $row) {
  509.                         $sectionKoeln['content'][] = str_getcsv($row, "\t");
  510.                     }
  511.                     $this->entityManager->getRepository(Option::class)->setOptionMetaValueJsonEncoded($metaNameSectionKoeln, null, $sectionKoeln);
  512.                     break;
  513.                 case 'updateDus':
  514.                     $sectionDus['content'] = [];
  515.                     foreach ($rows as $row) {
  516.                         $sectionDus['content'][] = str_getcsv($row, "\t");
  517.                     }
  518.                     $this->entityManager->getRepository(Option::class)->setOptionMetaValueJsonEncoded($metaNameSectionDus, null, $sectionDus);
  519.                     break;
  520.                 case 'updateAlumni':
  521.                     $sectionAlumni['content'] = [];
  522.                     foreach ($rows as $row) {
  523.                         $sectionAlumni['content'][] = str_getcsv($row, "\t");
  524.                     }
  525.                     $this->entityManager->getRepository(Option::class)->setOptionMetaValueJsonEncoded($metaNameSectionAlumni, null, $sectionAlumni);
  526.                     break;
  527.             }
  529.             $this->addFlash('notice', 'SUCCESS data saved');
  531.         }
  533.         $sectionBatch21 = $this->getSection($metaNameSectionBatch21);
  534.         $sectionBatch20 = $this->getSection($metaNameSectionBatch20);
  535.         $sectionBatch19 = $this->getSection($metaNameSectionBatch19);
  536.         $sectionBatch18 = $this->getSection($metaNameSectionBatch18);
  537.         $sectionBatch17 = $this->getSection($metaNameSectionBatch17);
  538.         $sectionKoeln = $this->getSection($metaNameSectionKoeln);
  539.         $sectionDus = $this->getSection($metaNameSectionDus);
  540.         $sectionAlumni = $this->getSection($metaNameSectionAlumni);
  542.         return $this->render('@StartPlatzAlphaBundle/Startup/index.legacy.html.twig', [
  543.             'templateVars' => [],
  545.             'form' => $form->createView(),
  546.             'sectionBatch21' => $sectionBatch21,
  547.             'sectionBatch20' => $sectionBatch20,
  548.             'sectionBatch19' => $sectionBatch19,
  549.             'sectionBatch18' => $sectionBatch18,
  550.             'sectionBatch17' => $sectionBatch17,
  551.             'sectionKoeln' => $sectionKoeln,
  552.             'sectionDus' => $sectionDus,
  553.             'sectionAlumni' => $sectionAlumni,
  554.             'edit' => $edit,
  557.             'redirectUrl' => base64_encode(json_encode(['path' => 'extern_startups_home', 'parameters' => []])),
  558.         ]);
  560.     }
  562.     #[Route('/startup/{slug}', name: 'homepage_startup_single')]
  563.     #[Route('/en/startup/{slug}', name: 'homepage_startup_single_english')]
  564.     public function singleAction(Request $request, $slug)
  565.     {
  566.                 $templateVars = $this->entityManager->getRepository(Team::class)->getTemplateVars($request);
  567.         /** @var User $user */
  568.         if ($user = $this->getUser()) {
  569.             $this->entityManager->getRepository(User::class)->writeActivity($user);
  570.         }
  572.         $id = explode('-', (string) $slug)[0];
  573.         $slug = explode('-', (string) $slug)[1];
  575.         /** @var Startup $startup */
  576.         if (!$startup = $this->entityManager->getRepository(Startup::class)->findOneBy(['id' => $id])) {
  577.             $this->addFlash('notice', 'ERROR slug not found');
  578.             return $this->redirect($this->generateUrl('homepage_startups_home'));
  579.         }
  580.         if (!$team = $this->entityManager->getRepository(Team::class)->findOneBy(['id' => $startup->getTeamId()])) {
  581.             $this->addFlash('notice', 'ERROR insufficient data');
  582.             return $this->redirect($this->generateUrl('homepage_startups_home'));
  583.         }
  585.         $feedItems = [];
  586.         $entities = [];
  588.         if ($startup->getSlug()) {
  589.             // feedTags are expected to be a jsonArray
  590.             $feedTags = json_encode([$startup->getSlug()]);
  591.             $feedItems = $this->entityManager->getRepository(Feed::class)->findByFeedTag($feedTags);
  592.             $entities = $this->entityManager->getRepository(Feed::class)->getEntitiesByFeedItems($feedItems);
  593.         }
  595.         // rheinlandPitch has programId == 1
  596.         $rheinlandPitches = $this->entityManager->getRepository(Application::class)->findApplicationsAndBatchesByStartupIdAndProgramId($id, 1);
  598.         $memberTypes = [];
  599.         $teamIndustries   = [];
  600.         $teamIndustryList = "";
  601.         $applications     = [];
  602.         if ($team) {
  603.             if ($team->getType() == 'Partner') {
  604.                 $memberTypes = ['GF', 'AP'];
  605.             }
  606.             $teamIndustries = $team->getIndustries();
  607.             $teamIndustryList = explode("#", (string) $teamIndustries);
  608.             // plausibility checks for members of that team
  609.             $this->entityManager->getRepository(Member::class)->checkIfDescriptionIsEmptyButMentorProfileIsFilled($team);
  610.             $relevantProgramIds = ['1','2','3'];
  611.             $applications = $this->entityManager->getRepository(Application::class)->findBy(['teamId'=>$team->getId(),'programId'=>$relevantProgramIds]);
  612.         }
  614.         $members = $this->entityManager->getRepository(MemberTeam::class)->getTeamMembers($id, $memberTypes);
  616.         $allowEdit = false;
  617.         $teamMember = false;
  618.         if($user) {
  619.             $userEmail = $this->getUser()->getEmail();
  620.             foreach ($members as $member) {
  621.                 if ($member['email'] == $userEmail) {
  622.                     $teamMember = true;
  623.                     if ($member['type'] == 'AP' || $member['type'] == 'GF') {
  624.                         $allowEdit = true;
  625.                     }
  626.                 }
  627.             }
  628.         }
  630.         // create slugs from team on the fly and from startup, what is stored there
  631.         if ($team) {
  632.             $slugs[] = Utility::generateSlug($team->getShortName());
  633.         }
  634.         if ($startup->getSlug()) {
  635.             $slugs[] = $startup->getSlug();
  636.         }
  637.         $feedTags = json_encode(array_values(array_unique($slugs)));
  639.         if ($feedTags) {
  640.             $feedItems = $this->entityManager->getRepository(Feed::class)->findByFeedTag($feedTags);
  641.             $entities = $this->entityManager->getRepository(Feed::class)->getEntitiesByFeedItems($feedItems);
  642.         }
  644.         $hasVisibleApplication = false;
  645.         foreach ($applications as $application) {
  646.             if($application->getVisibility() == 'sp-connect') {
  647.                 $hasVisibleApplication = true;
  648.                 break;
  649.             }
  650.         }
  652.         $lang = Utility::getLangByPathInfo($request->getPathInfo());
  654.         if ($startup->getVisibility() == 'public') {
  655.             return $this->render('@StartPlatzAlphaBundle/Startup/single.homepage.html.twig', [
  657.                 'id' => $id,
  658.                 'startup' => $startup,
  659.                 'team' => $team,
  660.                 'feedItems' => $feedItems,
  661.                 'entities' => $entities,
  662.                 'lang' => $lang,
  663.                 'rheinlandPitches' => $rheinlandPitches,
  665.                 'redirectUrl' => base64_encode(json_encode(['path' => 'homepage_startup_single', 'parameters' => ['slug' => $id . '-' . $slug]])),
  666.     
  667.                 'applications' => $applications,
  668.                 'hasVisibleApplication' => $hasVisibleApplication,
  669.                 'methodsTeam'           => $team ? $this->feedbackService->getEntityMethodsArray($team, ['services', 'members']) : [],
  670.                 'methodsStartup' => $startup ? $this->feedbackService->getEntityMethodsArray($startup, []) : [],
  671.                 'feedTags' => $feedTags,
  673.                 'templateVars' => $templateVars,
  674.                 'queryString' => '',
  675.                 //  'members' => $members,
  676.                 'memberTypes' => $memberTypes,
  677.                 'teamIndustryList' => $teamIndustryList,
  678.                 'allowEdit' => $allowEdit,
  679.                 'teamMember' => $teamMember,
  680.                 'memberTypeLabels' => $this->entityManager->getRepository(MemberTeam::class)->getMemberTypeLabels(),
  681.                 'currentPath' => '/x/connect/team/{id}',
  682.                 'backUrl' => $request->get('redirect') ?: base64_encode(json_encode(['path' => 'connect_startup_index', 'parameters' => $templateVars])),
  683.             ]);
  684.         } else {
  685.             return $this->render('@StartPlatzAlphaBundle/Startup/single.homepage.sorry.html.twig', [
  687.                 'lang' => $lang,
  688.     
  690.                 'redirectUrl' => base64_encode(json_encode(['path' => 'homepage_startup_single', 'parameters' => ['slug' => $id . '-' . $slug]])),
  692.              ]);
  693.         }
  695.     }
  697.     #[Route('/x/community/startups/home/', name: 'x_startups_home')]
  698.     /**
  699.      * @IsGranted("ROLE_USER")
  700.      */
  701.     public function indexStartupsAction(Request $request)
  702.     {
  703.                 $redirect = json_decode(base64_decode((string) $request->get('redirect')));
  704.         $redirectUrl = $request->get('redirect');
  705.         $templateVars = $this->entityManager->getRepository(Startup::class)->getTemplateVars($request);
  706.         $orderBy = $templateVars['dimensions'] ?: [];
  707.         $visibility = 'sp-connect';
  708.         $criteria = ['visibility' => $visibility] + $templateVars['criteria'];
  709.         $teamId = 0;
  711.         if ($user = $this->getUser()) {
  712.             $teamId = $user->getMemberId();
  713.             $this->entityManager->getRepository(User::class)->writeActivity($user);
  714.             $member = $this->entityManager->getRepository(Member::class)->find($user->getMemberId());
  715.         }
  717.         $total = $this->entityManager->getRepository(Startup::class)->countByCriteria($criteria, $teamId);
  719.         if ($total > 12) {
  720.             $limit = 12;
  721.         } else {
  722.             $limit = $total ?: 1;
  723.         }
  724.         if (!$page = $request->get('page')) {
  725.             $page = 1;
  726.         }
  728.         $startups = $this->entityManager->getRepository(Startup::class)->findPaginated($criteria, $teamId, $orderBy, $page, $limit);
  730.         $lang = $request->get('lang');
  732.         if (str_contains((string) $member->getTags(), 'beta')) {
  733.             $view = '@StartPlatzAlphaBundle/Startup/Startups__index.twig';
  735.         } else {
  736.             $view = '@StartPlatzAlphaBundle/Startup/Startups__index_old.twig';
  737.         }
  739.         return $this->render($view, [
  741.             'maxPages' => ceil($total / $limit),
  742.             'thisPage' => $page,
  743.             'total' => $total,
  744.             'criteria' => $criteria,
  745.             'visibility' => $visibility,
  747.             'templateVars' => $templateVars,
  749.             'startups' => $startups,
  750.             'backUrl' => $redirectUrl,
  752.             'redirectUrl' => base64_encode(json_encode(['path' => 'website_startups_list', 'parameters' => $templateVars])),
  753.         ]);
  754.     }
  756.     #[Route('/startup-database/list/', name: 'website_startups_list')]
  757.     #[Route('/startup-database/list/', name: 'extern_startups_list')]
  758.     /**
  759.      * @IsGranted("ROLE_USER")
  760.      */
  761.     public function listAction(Request $request)
  762.     {
  763.                 $redirect = json_decode(base64_decode((string) $request->get('redirect')));
  764.         $redirectUrl = $request->get('redirect');
  765.         $templateVars = $this->entityManager->getRepository(Startup::class)->getTemplateVars($request);
  766.         $orderBy = $templateVars['dimensions'] ?: [];
  767.         $visibility = 'public';
  768.         $criteria = ['visibility' => $visibility] + $templateVars['criteria'];
  769.         $teamId = 0;
  770.         if ($user = $this->getUser()) {
  771.             $teamId = $user->getMemberId();
  772.             $this->entityManager->getRepository(User::class)->writeActivity($user);
  773.         }
  775.         $total = $this->entityManager->getRepository(Startup::class)->countByCriteria($criteria, $teamId);
  777.         if ($total > 12) {
  778.             $limit = 12;
  779.         } else {
  780.             $limit = $total ?: 1;
  781.         }
  782.         if (!$page = $request->get('page')) {
  783.             $page = 1;
  784.         }
  786.         $startups = $this->entityManager->getRepository(Startup::class)->findPaginated($criteria, $teamId, $orderBy, $page, $limit);
  788.         $lang = $request->get('lang');
  789.         $targetPath = $request->server->get('REQUEST_URI');
  791.         return $this->render('@StartPlatzAlphaBundle/Startup/list.html.twig', [
  792.             'targetPath' => $targetPath,
  793.             'lang' => $lang,
  795.             'maxPages' => ceil($total / $limit),
  796.             'thisPage' => $page,
  797.             'total' => $total,
  798.             'criteria' => $criteria,
  799.             'visibility' => $visibility,
  800.             'templateVars' => $templateVars,
  802.             'startups' => $startups,
  803.             'backUrl' => $redirectUrl,
  805.             'redirectUrl' => base64_encode(json_encode(['path' => 'website_startups_list', 'parameters' => $templateVars])),
  806.         ]);
  807.     }
  809.     #[Route('/startup-database/show/{id}/{slug}', name: 'extern_startups_single')]
  810.     public function singleExternAction(Request $request, $id, $slug)
  811.     {
  812.                 if ($user = $this->getUser()) {
  813.             $this->entityManager->getRepository(User::class)->writeActivity($user);
  814.         }
  815.         if (!$redirect = json_decode(base64_decode((string) $request->get('redirect')))) {
  816.             $redirect = new stdClass();
  817.             $redirect->path = 'website_startups_list';
  818.             $redirect->parameters = [];
  819.         }
  821.         $redirectUrl = $request->get('redirect');
  823.         if (!$startup = $this->entityManager->getRepository(Startup::class)->findOneBy(['id' => $id, 'visibility' => 'public'])) {
  824.             $this->addFlash('notice', 'ERROR 10 entity not found');
  825.             return $this->redirect($this->generateUrl($redirect->path, (array)$redirect->parameters));
  826.         }
  828.         if ($slug != $startup->getSlug()) {
  829.             return $this->redirect($this->generateUrl('extern_startups_single', ['id' => $id, 'slug' => $startup->getSlug(), 'redirect' => $redirectUrl]));
  830.         }
  832.         $rightToAccessTeam = false;
  833.         $team = false;
  834.         $memberId = 0;
  835.         $teamId = $startup->getTeamId();
  836.         if ($user = $this->getUser()) {
  837.             $memberId = $user->getMemberId();
  838.             if (!$member = $this->entityManager->getRepository(Member::class)->findOneBy(['id' => $memberId])) {
  839.                 $this->addFlash('notice', 'ERROR There is a problem with your account please contact support@startplatz.de');
  840.                 return $this->redirect($this->generateUrl($redirect->path, (array)$redirect->parameters));
  841.             }
  842.             if ($team = $this->entityManager->getRepository(Team::class)->findOneBy(['id' => $teamId])) {
  843.                 $rightToAccessTeam = $this->entityManager->getRepository(MemberTeam::class)->checkAccessRight($member, $team);
  844.                 $team = $this->entityManager->getRepository(Team::class)->checkConsistencyWithStartup($team, $startup);
  845.             }
  846.         }
  848.         // the use of memberId is on purpose
  849.         $startupAttributes = $this->entityManager->getRepository(StartupAttribute::class)->findOneBy(['startupId' => $startup->getId(), 'teamId' => $memberId]);
  850.         $startupLivecycleEvents = $this->entityManager->getRepository(StartupLifecycleEvent::class)->findBy(['startupId' => $startup->getId()], ['eventDate' => 'ASC']);
  852.         $this->entityManager->getRepository(StartupRelevance::class)->updateByUserAction($id, 'click');
  854.         $rheinlandPitches = $this->entityManager->getRepository(Application::class)->findBy(['startupId' => $id], ['batchId' => 'DESC']);
  856.         return $this->render('@StartPlatzAlphaBundle/Startup/single.extern.twig', [
  858.             'templateVars' => [],
  860.             'startup' => $startup,
  861.             'rightToAccessTeam' => $rightToAccessTeam,
  862.             'startupAttributes' => $startupAttributes,
  863.             'rheinlandPitches' => $rheinlandPitches,
  864.             'startupLivecycleEvents' => $startupLivecycleEvents,
  866.             'backUrl' => $redirectUrl,
  868.             'redirectUrl' => base64_encode(json_encode(['path' => 'extern_startups_single', 'parameters' => ['id' => $id, 'slug' => $startup->getSlug()]])),
  869.         ]);
  870.     }
  872.     #[Route('/x/community/startup/single/{id}', name: 'x_community_startup_single')]
  873.     /**
  874.      * @IsGranted("ROLE_USER")
  875.      */
  876.     public function singleCommunityAction(Request $request, $id)
  877.     {
  878.                 if ($user = $this->getUser()) {
  879.             $this->entityManager->getRepository(User::class)->writeActivity($user);
  880.         }
  881.         if (!$redirect = json_decode(base64_decode((string) $request->get('redirect')))) {
  882.             $redirect = new stdClass();
  883.             $redirect->path = 'x_home';
  884.             $redirect->parameters = [];
  885.         }
  887.         $redirectUrl = $request->get('redirect');
  889.         if (!$startup = $this->entityManager->getRepository(Startup::class)->findSingleStartupByVisibility($id, 'sp-connect')) {
  890.             $this->addFlash('notice', 'ERROR 20 entity not found');
  891.             return $this->redirect($this->generateUrl($redirect->path, (array)$redirect->parameters));
  892.         }
  894.         $rightToAccessTeam = false;
  895.         $team = false;
  896.         $memberId = 0;
  897.         $teamId = $startup->getTeamId();
  898.         if ($user = $this->getUser()) {
  899.             $memberId = $user->getMemberId();
  900.             if (!$member = $this->entityManager->getRepository(Member::class)->findOneBy(['id' => $memberId])) {
  901.                 $this->addFlash('notice', 'ERROR There is a problem with your account please contact support@startplatz.de');
  902.                 return $this->redirect($this->generateUrl($redirect->path, (array)$redirect->parameters));
  903.             }
  904.             if ($team = $this->entityManager->getRepository(Team::class)->findOneBy(['id' => $teamId])) {
  905.                 $rightToAccessTeam = $this->entityManager->getRepository(MemberTeam::class)->checkAccessRight($member, $team);
  906.                 $team = $this->entityManager->getRepository(Team::class)->checkConsistencyWithStartup($team, $startup);
  907.             }
  908.         }
  910.         // the use of memberId is on purpose
  911.         $startupAttributes = $this->entityManager->getRepository(StartupAttribute::class)->findOneBy(['startupId' => $startup->getId(), 'teamId' => $memberId]);
  912.         $startupLivecycleEvents = $this->entityManager->getRepository(StartupLifecycleEvent::class)->findBy(['startupId' => $startup->getId()], ['eventDate' => 'ASC']);
  914.         $this->entityManager->getRepository(StartupRelevance::class)->updateByUserAction($id, 'click');
  916.         $rheinlandPitches = $this->entityManager->getRepository(Application::class)->findBy(['startupId' => $id], ['batchId' => 'DESC']);
  918.         $lang = $request->get('lang');
  919.         $targetPath = $request->server->get('REQUEST_URI');
  921.         return $this->render('@StartPlatzAlphaBundle/Startup/single.sp-connect.html.twig', [
  922.             'targetPath' => $targetPath,
  923.             'lang' => $lang,
  925.             'templateVars' => [],
  927.             'startup' => $startup,
  928.             'rightToAccessTeam' => $rightToAccessTeam,
  929.             'startupAttributes' => $startupAttributes,
  930.             'rheinlandPitches' => $rheinlandPitches,
  931.             'startupLivecycleEvents' => $startupLivecycleEvents,
  933.             'backUrl' => $redirectUrl,
  935.             'redirectUrl' => base64_encode(json_encode(['path' => 'extern_startups_single', 'parameters' => ['id' => $id, 'slug' => $startup->getSlug()]])),
  936.         ]);
  937.     }
  939.     #[Route('/allmeda/startups/toggle-ajax/{id}/{field}/{action}', name: 'startup_edit_field_ajax')]
  940.     /**
  941.      * @IsGranted("ROLE_ADMIN")
  942.      */
  943.     public function setToggleAjaxAction($id, $field, $action)
  944.     {
  945.                 $response = $this->entityManager->getRepository(Startup::class)->setField($field, $action, $id);
  947.         if (str_starts_with((string) $response, 'field ')) {
  948.             $response = "SUCCESS $response";
  949.         }
  951.         return new Response($response);
  952.     }
  954.     #[Route('/x/connect/startup/edit/{id}/set-with-data', name: 'x_connect_startup_set_field_ajax_with_data')]
  955.     #[Route('/x/connect/startup/edit/{id}/set/{field}/{action}', name: 'x_connect_startup_set_field_ajax')]
  956.     /**
  957.      * @IsGranted("ROLE_USER")
  958.      */
  959.     public function setAjaxAction(Request $request, $id = null, $field = null, $action = null): Response
  960.     {
  961.         $params = ['id' => $id];
  962.         if ($field && $action) {
  963.             $params['field'] = $field;
  964.             $params['action'] = $action;
  965.             return $this->redirectToRoute('connect_startup_set_field_ajax', $params, 301);
  966.         }
  967.         return $this->redirectToRoute('connect_startup_set_field_data_ajax', $params, 301);
  968.     }
  970.     #[Route('/x/connect/startup/edit/{id}/{slug}', name: 'x_startup_edit')]
  971.     /**
  972.      * @IsGranted("ROLE_USER")
  973.      */
  974.     public function editStartupAction(Request $request, $id, $slug): Response
  975.     {
  976.         return $this->redirectToRoute('connect_startup_show', ['id' => $id, 'slug' => $slug, 'redirect' => $request->get('redirect')], 301);
  977.     }
  979.     private function removeOldResourcesFromCloudinary($uploadTag, $link): void
  980.     {
  981.         $result = $this->cloudinary->resources_by_tag($uploadTag);
  982.         $filter = fn ($res) => $res['secure_url'] != $link;
  983.         $oldRefs = array_filter($result['resources'], $filter);
  984.         $oldIds = array_map(fn ($res) => $res['public_id'], $oldRefs);
  985.         if (!empty($oldIds)) {
  986.             $result = $this->cloudinary->delete_resources($oldIds);
  987.         }
  988.     }
  990.     #[Route('/startup-database/edit/{id}/{slug}', name: 'extern_startups_edit')]
  991.     /**
  992.      * @IsGranted("ROLE_USER")
  993.      */
  994.     public function editAction(Request $request, $id, $slug)
  995.     {
  996.                 $redirect = json_decode(base64_decode((string) $request->get('redirect')));
  997.         $redirectUrl = $request->get('redirect');
  999.         /** @var Startup $startup */
  1000.         if (!$startup = $this->entityManager->getRepository(Startup::class)->findOneBy(['id' => $id])) {
  1001.             $this->addFlash('notice', 'ERROR 40 entity not found');
  1002.             return $this->redirect($this->generateUrl($redirect->path, (array)$redirect->parameters));
  1003.         }
  1005.         if ($slug != $startup->getSlug()) {
  1006.             return $this->redirect($this->generateUrl('extern_startups_single', ['id' => $id, 'slug' => $startup->getSlug(), 'redirect' => $redirectUrl]));
  1007.         }
  1009.         $rightToAccessTeam = false;
  1010.         $team = false;
  1011.         $memberId = 0;
  1012.         $teamId = $startup->getTeamId();
  1013.         /** @var User $user */
  1014.         if ($user = $this->getUser()) {
  1015.             $this->entityManager->getRepository(User::class)->writeActivity($user);
  1017.             $memberId = $user->getMemberId();
  1018.             if (!$member = $this->entityManager->getRepository(Member::class)->findOneBy(['id' => $memberId])) {
  1019.                 $this->addFlash('notice', 'ERROR There is a problem with your account please contact support@startplatz.de');
  1020.                 return $this->redirect($this->generateUrl($redirect->path, (array)$redirect->parameters));
  1021.             }
  1022.             /** @var Team $team */
  1023.             if ($team = $this->entityManager->getRepository(Team::class)->findOneBy(['id' => $teamId])) {
  1024.                 $rightToAccessTeam = $this->entityManager->getRepository(MemberTeam::class)->checkAccessRight($member, $team);
  1025.             }
  1026.         }
  1028.         $admin = $user->getIsAdmin();
  1029.         if (!$rightToAccessTeam and !$admin) {
  1030.             $this->addFlash('notice', 'ERROR There is a problem with your account-3 please contact support@startplatz.de');
  1031.             return $this->redirect($this->generateUrl($redirect->path, (array)$redirect->parameters));
  1032.         }
  1034.         // the use of memberId is on purpose
  1035.         $startupAttributes = $this->entityManager->getRepository(StartupAttribute::class)->findOneBy(['startupId' => $startup->getId(), 'teamId' => $memberId]);
  1037.         $this->entityManager->getRepository(StartupRelevance::class)->updateByUserAction($id, 'edit');
  1039.         $rheinlandPitches = $this->entityManager->getRepository(Application::class)->findBy(['startupId' => $id], ['batchId' => 'DESC']);
  1041.         $fields = Utility::getEntityFieldsArray($startup);
  1042.         $storedData = Utility::fillDataByObject($startup, $fields);
  1044.         $industries = $this->entityManager->getRepository(Startup::class)->getListOfIndustries();
  1046.         $form = $this->createForm(StartupType::class, $startup, ['industries' => $industries, 'editForm' => 'extern']);
  1047.         $form->handleRequest($request);
  1048.         if ($form->isSubmitted() && $form->isValid()) {
  1050.             $data = $form->getData();
  1052.             $updatedData = Utility::fillDataByObject($startup, $fields);
  1053.             $differences = array_diff_assoc($updatedData, $storedData);
  1055.             if ($differences) {
  1056.                 $startup = $this->entityManager->getRepository(Startup::class)->updateByEdit($startup, $differences, $user->getEmail());
  1057.                 if ($team) {
  1058.                     $team = $this->entityManager->getRepository(Team::class)->syncDataWithStartup($team, $startup);
  1059.                 }
  1060.             }
  1061.         }
  1063.         return $this->render('@StartPlatzAlphaBundle/Startup/edit.html.twig', [
  1065.             'templateVars' => [],
  1067.             'form' => $form->createView(),
  1068.             'startup' => $startup,
  1069.             'rightToAccessTeam' => $rightToAccessTeam,
  1070.             'startupAttributes' => $startupAttributes,
  1071.             'rheinlandPitches' => $rheinlandPitches,
  1073.             'backUrl' => $redirectUrl,
  1075.             'redirectUrl' => base64_encode(json_encode(['path' => 'extern_startups_single', 'parameters' => ['id' => $id, 'slug' => $startup->getSlug()]])),
  1076.         ]);
  1077.     }
  1079.     #[Route('/startup-database/event/{id}/{slug}/{eventId}', name: 'extern_startups_event')]
  1080.     /**
  1081.      * @IsGranted("ROLE_USER")
  1082.      */
  1083.     public function startupLivecycleEventAction(Request $request, $id, $slug, $eventId)
  1084.     {
  1085.                 $now = new DateTime();
  1086.         $redirect = json_decode(base64_decode((string) $request->get('redirect')));
  1087.         $redirectUrl = $request->get('redirect');
  1089.         if (!$startup = $this->entityManager->getRepository(Startup::class)->findOneBy(['id' => $id])) {
  1090.             $this->addFlash('notice', 'ERROR 50 entity not found');
  1091.             return $this->redirect($this->generateUrl($redirect->path, (array)$redirect->parameters));
  1092.         }
  1094.         if ($slug != $startup->getSlug()) {
  1095.             return $this->redirect($this->generateUrl('extern_startups_single', ['id' => $id, 'slug' => $startup->getSlug(), 'redirect' => $redirectUrl]));
  1096.         }
  1098.         $rightToAccessTeam = false;
  1099.         $team = false;
  1100.         $memberId = 0;
  1101.         $teamId = $startup->getTeamId();
  1102.         /** @var User $user */
  1103.         if ($user = $this->getUser()) {
  1104.             $this->entityManager->getRepository(User::class)->writeActivity($user);
  1106.             $memberId = $user->getMemberId();
  1107.             if (!$member = $this->entityManager->getRepository(Member::class)->findOneBy(['id' => $memberId])) {
  1108.                 $this->addFlash('notice', 'ERRORThere is a problem with your account please contact support@startplatz.de');
  1109.                 return $this->redirect($this->generateUrl($redirect->path, (array)$redirect->parameters));
  1110.             }
  1111.             if ($team = $this->entityManager->getRepository(Team::class)->findOneBy(['id' => $teamId])) {
  1112.                 $rightToAccessTeam = $this->entityManager->getRepository(MemberTeam::class)->checkAccessRight($member, $team);
  1113.             }
  1114.         }
  1116.         $admin = $user->getIsAdmin();
  1117.         if (!$rightToAccessTeam and !$admin) {
  1118.             $this->addFlash('notice', 'ERROR There is a problem with your account-4 please contact support@startplatz.de');
  1119.             return $this->redirect($this->generateUrl($redirect->path, (array)$redirect->parameters));
  1120.         }
  1122.         // the use of memberId is on purpose
  1123.         $startupAttributes = $this->entityManager->getRepository(StartupAttribute::class)->findOneBy(['startupId' => $startup->getId(), 'teamId' => $memberId]);
  1124.         $this->entityManager->getRepository(StartupRelevance::class)->updateByUserAction($id, 'edit');
  1126.         $rheinlandPitches = $this->entityManager->getRepository(Application::class)->findBy(['startupId' => $id], ['batchId' => 'DESC']);
  1127.         $startupLivecycleEvents = $this->entityManager->getRepository(StartupLifecycleEvent::class)->findBy(['startupId' => $startup->getId()], ['eventDate' => 'ASC']);
  1129.         if (!$livecycleEvent = $this->entityManager->getRepository(StartupLifecycleEvent::class)->findOneBy(['id' => $eventId])) {
  1130.             $livecycleEvent = new StartupLifecycleEvent();
  1131.             $livecycleEvent->setEventDate($now);
  1132.             $livecycleEvent->setStartupId($id);
  1133.         }
  1135.         // set array oldData value, nr, text
  1136.         $fields = ['eventWhat', 'eventDate', 'linkText', 'link'];
  1137.         $oldData = $this->getDataAsArray($fields, $livecycleEvent);
  1139.         $form = $this->createForm(LivecycleEventType::class, $livecycleEvent);
  1140.         $form->handleRequest($request);
  1141.         if ($form->isSubmitted() && $form->isValid()) {
  1142.             $newData = $this->getDataAsArray($fields, $livecycleEvent);
  1143.             $differences = array_diff_assoc($newData, $oldData);
  1145.             if ($differences) {
  1146.                 $livecycleEvent = $this->entityManager->getRepository(StartupLifecycleEvent::class)->updateByEdit($livecycleEvent, $differences, $user->getEmail());
  1147.                 $this->addFlash('notice', 'SUCCESSData has been saved');
  1148.             }
  1149.             return $this->redirect($this->generateUrl($redirect->path, (array)$redirect->parameters));
  1150.         }
  1152.         return $this->render('@StartPlatzAlphaBundle/Startup/editLivecycleEvent.html.twig', [
  1154.             'templateVars' => [],
  1156.             'form' => $form->createView(),
  1157.             'startup' => $startup,
  1158.             'rightToAccessTeam' => $rightToAccessTeam,
  1159.             'startupAttributes' => $startupAttributes,
  1160.             'rheinlandPitches' => $rheinlandPitches,
  1161.             'livecycleEvent' => $livecycleEvent,
  1162.             'startupLivecycleEvents' => $startupLivecycleEvents,
  1164.             'backUrl' => $redirectUrl,
  1166.             'redirectUrl' => base64_encode(json_encode(['path' => 'extern_startups_single', 'parameters' => ['id' => $id, 'slug' => $startup->getSlug()]])),
  1167.         ]);
  1168.     }
  1170.     #[Route('/startup-database/show-event/{id}/{slug}/{eventId}', name: 'extern_startups_show-event')]
  1171.     /**
  1172.      * @IsGranted("ROLE_USER")
  1173.      */
  1174.     public function showStartupLivecycleEventAction(Request $request, $id, $slug, $eventId)
  1175.     {
  1176.                 $now = new DateTime();
  1177.         $redirect = json_decode(base64_decode((string) $request->get('redirect')));
  1178.         $redirectUrl = $request->get('redirect');
  1180.         if (!$startup = $this->entityManager->getRepository(Startup::class)->findOneBy(['id' => $id])) {
  1181.             $this->addFlash('notice', 'ERROR 60 entity not found');
  1182.             return $this->redirect($this->generateUrl($redirect->path, (array)$redirect->parameters));
  1183.         }
  1185.         if ($slug != $startup->getSlug()) {
  1186.             return $this->redirect($this->generateUrl('extern_startups_single', ['id' => $id, 'slug' => $startup->getSlug(), 'redirect' => $redirectUrl]));
  1187.         }
  1189.         /** @var User $user */
  1190.         if (!$user = $this->getUser()) {
  1191.             $this->addFlash('notice', 'SUCCESSplease register or login');
  1192.             return $this->redirect($this->generateUrl($redirect->path, (array)$redirect->parameters));
  1193.         }
  1194.         $this->entityManager->getRepository(User::class)->writeActivity($user);
  1196.         $this->entityManager->getRepository(StartupRelevance::class)->updateByUserAction($id, 'edit');
  1198.         if (!$startupLivecycleEvent = $this->entityManager->getRepository(StartupLifecycleEvent::class)->findOneBy(['id' => $eventId])) {
  1199.             $this->addFlash('notice', 'ERRORError - no event found');
  1200.             return $this->redirect($this->generateUrl($redirect->path, (array)$redirect->parameters));
  1201.         }
  1203.         return $this->render('@StartPlatzAlphaBundle/Startup/showLivecycleEvent.html.twig', [
  1205.             'templateVars' => [],
  1207.             'startup' => $startup,
  1208.             'startupLivecycleEvent' => $startupLivecycleEvent,
  1210.             'backUrl' => $redirectUrl,
  1212.             'redirectUrl' => base64_encode(json_encode(['path' => 'extern_startups_single', 'parameters' => ['id' => $id, 'slug' => $startup->getSlug()]])),
  1213.         ]);
  1214.     }
  1216.     private function getDataAsArray($fields, $entity)
  1217.     {
  1218.         foreach ($fields as $field) {
  1219.             $method = 'get' . ucfirst((string) $field);
  1220.             if (method_exists($entity, $method)) {
  1221.                 if ($entity->$method() instanceof DateTime) {
  1222.                     $data[$field] = $entity->$method()->format('Y-m-d');
  1223.                 } else {
  1224.                     $data[$field] = $entity->$method();
  1225.                 }
  1226.             } else {
  1227.                 $data[$field] = "";
  1228.             }
  1229.         }
  1230.         return $data;
  1231.     }
  1233.     #[Route('/startup-database/get-in-contact/{id}', name: 'extern_startups_get-in-contact')]
  1234.     public function getInContactAjaxAction(Request $request, $id)
  1235.     {
  1236.                 $redirect = json_decode(base64_decode((string) $request->get('redirect')));
  1238.         return $this->render('@StartPlatzAlphaBundle/Startup/modal.register.html.twig', [
  1239.             'title' => "Get in contact",
  1240.             'btnClass' => "btn-outline-info",
  1241.             'id' => $id,
  1243.             'redirect' => $redirect,
  1244.             'redirectUrl' => $request->get('redirect'),
  1245.         ]);
  1246.     }
  1248.     #[Route('/startup-database/register/{id}', name: 'extern_startups_register')]
  1249.     public function registerAjaxAction(Request $request, $id)
  1250.     {
  1251.                 $redirect = json_decode(base64_decode((string) $request->get('redirect')));
  1253.         return $this->render('@StartPlatzAlphaBundle/Startup/modal.register.html.twig', [
  1254.             'title' => "Please register",
  1255.             'btnClass' => "btn-outline-info",
  1256.             'id' => $id,
  1258.             'redirect' => $redirect,
  1259.             'redirectUrl' => $request->get('redirect'),
  1260.         ]);
  1261.     }
  1263.     #[Route('/x/community/startups/missions/', name: 'x_startups_missions')]
  1264.     /**
  1265.      * @IsGranted("ROLE_USER")
  1266.      */
  1267.     public function indexMissionsForBadge(Request $request)
  1268.     {
  1269.                 $redirect = json_decode(base64_decode((string) $request->get('redirect')));
  1270.         $redirectUrl = $request->get('redirect');
  1271.         $templateVars = $this->entityManager->getRepository(Startup::class)->getTemplateVars($request);
  1273.         /** @var User $user */
  1274.         $user = $this->getUser();
  1275.         $this->entityManager->getRepository(User::class)->writeActivity($user, '/x/community/startups/');
  1277.         $id = $user->getTeamId();
  1279.         /** @var Team $team */
  1280.         $team = $this->entityManager->getRepository(Team::class)->find($id);
  1282.         if (!$startup = $this->entityManager->getRepository(Startup::class)->findOneBy(['id' => $team->getStartupId()])) {
  1283.             $startup = new Startup();
  1284.         } else {
  1285.             // increase relevance score every time a startup team is shown
  1286.             $this->entityManager->getRepository(StartupRelevance::class)->updateByUserAction($startup->getId(), 'click');
  1287.         }
  1289.         $lang = $request->get('lang');
  1291.         $view = '@StartPlatzAlphaBundle/Startup/index.missionsForBadge.html.twig';
  1293.         return $this->render($view, [
  1294.             'team' => $team,
  1295.             'startup' => $startup,
  1296.             'templateVars' => $templateVars,
  1298.             'backUrl' => $redirectUrl,
  1300.             'redirectUrl' => base64_encode(json_encode(['path' => 'website_startups_list', 'parameters' => $templateVars])),
  1301.         ]);
  1302.     }
  1304.     private function setEditorForm($content)
  1305.     {
  1306.         return $this->formFactory->createNamedBuilder('editor')
  1307.             ->add(
  1308.                 'content',
  1309.                 TinymceType::class,
  1310.                 [
  1311.                     'label' => 'Content',
  1312.                     'data' => $content,
  1313.                     'required' => false,
  1314.                 ]
  1315.             )
  1316.             ->add('save', SubmitType::class, ['label' => 'Save'])
  1317.             ->getForm();
  1318.     }
  1320.     private function setPlainEditorForm($content)
  1321.     {
  1322.         return $this->formFactory->createNamedBuilder('editor')
  1323.             ->add(
  1324.                 'content',
  1325.                 TextareaType::class,
  1326.                 [
  1327.                     'label' => 'Content',
  1328.                     'data' => $content,
  1329.                     'attr' => ['rows' => '17', 'cols' => '180'],
  1330.                     'required' => false,
  1331.                 ]
  1332.             )
  1333.             ->add('save', SubmitType::class, ['label' => 'Save'])
  1334.             ->getForm();
  1335.     }
  1337.     private function getSection($metaName)
  1338.     {
  1339.                 if (!$section = $this->entityManager->getRepository(Option::class)->getOptionMetaValue($metaName)) {
  1340.             $section['fields'] = $this->setSectionFields();
  1341.             $section['content'][] = [
  1342.                 "https://www.startplatz.de/wp-content/uploads/2012/11/golfpost_225x225.jpg",
  1343.                 "http://www.golfpost.de",
  1344.                 "Golf Post",
  1345.                 "Das Online-Magazin Golf Post ist Vorreiter und inzwischen zur größten unabhängigen Golf-Plattform im deutschsprachigen Raum gereift. Ziel ist es, das elitäre Image des Golfsports zu entstauben.",
  1346.                 "#golfistbesseralsdudenkst #wirsindanders #unsereweltistgrün",
  1347.                 "99999",
  1348.             ];
  1349.             $this->entityManager->getRepository(Option::class)->setOptionMetaValueJsonEncoded($metaName, null, $section);
  1350.         }
  1351.         $section['entities'] = $this->setSectionEntities($section);
  1352.         return $section;
  1353.     }
  1355.     private function setSectionEntities($section)
  1356.     {
  1357.         $entities = [];
  1358.         foreach ($section['content'] as $row) {
  1359.             if ((is_countable($section['fields']) ? count($section['fields']) : 0) != (is_countable($row) ? count($row) : 0)) {
  1360.                 $i = 0;
  1361.                 foreach ($section['fields'] as $field) {
  1362.                     $entity[$field] = $row[$i] ?? $field;
  1363.                     $i++;
  1364.                 }
  1365.                 $entities[] = $entity;
  1366.             } else {
  1367.                 $entities[] = array_combine($section['fields'], $row);
  1368.             }
  1369.         }
  1370.         return $entities;
  1371.     }
  1373.     private function transformArrayIntoCsvString($rows)
  1374.     {
  1375.         $content = '';
  1376.         foreach ($rows as $row) {
  1377.             $content .= implode("\t", $row) . PHP_EOL;
  1378.         }
  1379.         return $content;
  1380.     }
  1382.     private function setSectionFields()
  1383.     {
  1384.         $fields = ['logo', 'url', 'name', 'desc', 'tags', 'teamId'];
  1385.         return $fields;
  1386.     }
  1388. }