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

Open in your IDE?
  1. <?php declare(strict_types=1);
  3. namespace App\StartPlatz\Bundle\AlphaBundle\Controller;
  5. use App\StartPlatz\Bundle\AlphaBundle\Entity\Actor;
  6. use App\StartPlatz\Bundle\AlphaBundle\Entity\Feed;
  7. use App\StartPlatz\Bundle\AlphaBundle\Entity\Page;
  8. use App\StartPlatz\Bundle\MemberBundle\Entity\Member;
  9. use App\StartPlatz\Bundle\MemberBundle\Entity\MemberTeam;
  10. use App\StartPlatz\Bundle\MemberBundle\Entity\Option;
  11. use App\StartPlatz\Bundle\MemberBundle\Entity\Team;
  12. use App\StartPlatz\Bundle\StartupBundle\Entity\Application;
  13. use App\StartPlatz\Bundle\StartupBundle\Entity\Batch;
  14. use App\StartPlatz\Bundle\StartupBundle\Entity\Startup;
  15. use App\StartPlatz\Bundle\StartupBundle\Entity\StartupAttribute;
  16. use App\StartPlatz\Bundle\StartupBundle\Entity\StartupLifecycleEvent;
  17. use App\StartPlatz\Bundle\StartupBundle\Entity\StartupRelevance;
  18. use App\StartPlatz\Bundle\StartupBundle\Form\LivecycleEventType;
  19. use App\StartPlatz\Bundle\WebsiteBundle\Utility\Utility;
  20. use DateTime;
  21. use Eckinox\TinymceBundle\Form\Type\TinymceType;
  22. use Speicher210\CloudinaryBundle\Cloudinary\Api;
  23. use Symfony\Component\HttpFoundation\Response;
  24. use Sensio\Bundle\FrameworkExtraBundle\Configuration\Security;
  25. use stdClass;
  26. use Symfony\Component\Mailer\Exception\TransportExceptionInterface;
  27. use Symfony\Component\Mime\Address;
  28. use Symfony\Component\Mime\Email;
  29. use Symfony\Component\Routing\Annotation\Route;
  30. use App\StartPlatz\Bundle\FeedbackBundle\FeedbackService;
  31. use App\StartPlatz\Bundle\StartupBundle\Form\StartupType;
  32. use App\StartPlatz\Bundle\UserBundle\Entity\User;
  33. use App\StartPlatz\Bundle\WebsiteBundle\MenuTranslationService;
  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;
  40. use Symfony\Component\HttpFoundation\Session\SessionInterface;
  42. class StartupController extends AbstractController
  43. {
  44.     public function __construct(
  45.         private readonly SessionInterface $session,
  46.         private readonly FormFactoryInterface $formFactory,
  47.         private readonly FeedbackService $feedbackService,
  48.         private readonly MenuTranslationService $menuTranslationService,
  49.         private readonly Api $cloudinary,
  50.         private readonly MailerInterface $mailer
  51.     ) {
  52.     }
  54.     /**
  55.      * @Route("/accelerator/startups", name="accelerator_startups")
  56.      */
  57.     public function AcceleratorStartupsIndexAction(Request $request)
  58.     {
  59.         $em = $this->getDoctrine()->getManager();
  61.         $startups = $em->getRepository(Startup::class)->findAcceleratorAlumnis();
  63.         $teamIds = array_map(fn ($entity) => $entity->getTeamId(), $startups);
  65.         $teams   = $em->getRepository(Team::class)->findBy(['id'=>$teamIds]);
  66.         $teamIds = array_map(fn ($entity) => $entity->getId(), $teams);
  67.         $teams   = array_combine($teamIds, $teams);
  69.         return $this->render('@StartPlatzAlphaBundle/Startup/index.startups.alumni.html.twig', [
  70.             'startups'   => $startups,
  71.             'teams'      => $teams,
  73.         ]);
  76.     }
  78.     /**
  79.      * @Route("/x/connect/startups/home", name="x_connect_startups_home")
  80.      * @Security("is_granted('ROLE_USER')")
  81.      */
  82.     public function indexStartupsSpconnectAction(Request $request)
  83.     {
  84.         $em = $this->getDoctrine()->getManager();
  85.         $templateVars = $em->getRepository(Startup::class)->getTemplateVars($request);
  86.         $route = $request->get('_route');
  87.         $responseContent = [];
  89.         /** @var User $user */
  90.         $user = $this->getUser();
  91.         $em->getRepository(User::class)->writeActivity($user);
  92.         $teamId = $user->getMemberId();
  93.         $userMember = $em->getRepository(Member::class)->find($user->getMemberId());
  95.         if (!$ajax = $request->get('ajax')) {
  96.             // do whatever has to be done with first access
  97.         }
  99.         $orderBy = $templateVars['dimensions'] ?: ['score' => 'DESC'];
  100.         $visibility = 'sp-connect';
  101.         $criteria = ['visibility' => $visibility, 'status' => 'active', 'team' => 'exists'] + $templateVars['criteria'];
  103.         //remove location from criteria for location-button hrefs so not both CGN or DUS can be selected at the same time
  104.         $templateVarsLocation = $templateVars;
  105.         if(array_key_exists('criteria', $templateVarsLocation) && array_key_exists('location', $templateVarsLocation['criteria'])) {
  106.             unset($templateVarsLocation['criteria']['location']);
  107.         }
  110.         $total = $em->getRepository(Startup::class)->countByCriteria($criteria, $teamId);
  112.         if ($total > 72) {
  113.             $limit = 72;
  114.         } else {
  115.             $limit = $total ?: 1;
  116.         }
  117.         if (!$page = $request->get('page')) {
  118.             $page = 1;
  119.         }
  121.         $startups = $em->getRepository(Startup::class)->findPaginated($criteria, $teamId, $orderBy, $page, $limit);
  122.         $maxPages = $total;
  124.         $id = $user->getTeamId();
  126.         $acceleratorCurrentBatchNumber = $em->getRepository(Option::class)->getAcceleratorCurrentBatchNumber();
  128.         $startupsCurrentBatch = $em->getRepository(Startup::class)->findPaginated($criteria + ['batch' => $acceleratorCurrentBatchNumber], $teamId, $orderBy, 1, 128);
  129.         $startupsLastBatch = $em->getRepository(Startup::class)->findPaginated($criteria + ['batch' => $acceleratorCurrentBatchNumber -1 ], $teamId, $orderBy, 1, 128);
  130.         $startupsBatch20 = $em->getRepository(Startup::class)->findPaginated($criteria + ['batch' => $acceleratorCurrentBatchNumber -2], $teamId, $orderBy, 1, 128);
  131.         $startupsSpCgn = $em->getRepository(Startup::class)->findPaginated($criteria + ['startplatz' => 'sp-cgn'], $teamId, $orderBy, 1, 128);
  132.         $startupsSpDus = $em->getRepository(Startup::class)->findPaginated($criteria + ['startplatz' => 'sp-dus'], $teamId, $orderBy, 1, 128);
  133.         $startupsAlumni = $em->getRepository(Startup::class)->findPaginated($criteria + ['startplatz' => 'alumni'], $teamId, $orderBy, 1, 128);
  134.         $startupsExtern = $em->getRepository(Startup::class)->findPaginated($criteria + ['startplatz' => 'extern'], $teamId, $orderBy, $page, $limit);
  136.         $startupsRheinlandPitch = [];
  137.         $startupsRheinlandPitch = $em->getRepository(Startup::class)->findPaginated($criteria + ['pitchNumber' => 'rheinland-pitch-web3-edition-112'], $teamId, $orderBy, 1, 128);
  139.         $startupsGruenderstipendium = [];
  140.         $startupsGruenderstipendium = $em->getRepository(Startup::class)->findPaginated($criteria + ['gsStatus' => ['funded','recommended']], $teamId, $orderBy, 1, 128);
  142.         $startupsGruenderstipendiumAlumni = [];
  143.         $startupsGruenderstipendiumAlumni = $em->getRepository(Startup::class)->findPaginated($criteria + ['gsStatus' => ['alumni']], $teamId, $orderBy, 1, 128);
  145.         // get teamIds
  146.         $teamIds = array_map(fn ($entity) => $entity['teamId'], $startups);
  147.         $teamIds = $teamIds + array_map(fn ($entity) => $entity['teamId'], $startupsCurrentBatch);
  148.         $teamIds = $teamIds + array_map(fn ($entity) => $entity['teamId'], $startupsLastBatch);
  149.         $teamIds = $teamIds + array_map(fn ($entity) => $entity['teamId'], $startupsBatch20);
  150.         $teamIds = $teamIds + array_map(fn ($entity) => $entity['teamId'], $startupsSpCgn);
  151.         $teamIds = $teamIds + array_map(fn ($entity) => $entity['teamId'], $startupsSpDus);
  152.         $teamIds = $teamIds + array_map(fn ($entity) => $entity['teamId'], $startupsAlumni);
  153.         $teamIds = $teamIds + array_map(fn ($entity) => $entity['teamId'], $startupsExtern);
  154.         $teamIds = $teamIds + array_map(fn ($entity) => $entity['teamId'], $startupsRheinlandPitch);
  155.         $teamIds = $teamIds + array_map(fn ($entity) => $entity['teamId'], $startupsGruenderstipendium);
  156.         $teamIds = $teamIds + array_map(fn ($entity) => $entity['teamId'], $startupsGruenderstipendiumAlumni);
  158.         $teams = $em->getRepository(Team::class)->findBy(['id'=>$teamIds]);
  159.         $teamIds = array_map(fn ($entity) => $entity->getId(), $teams);
  160.         $teams = array_combine($teamIds, $teams);
  162.         /** @var Team $team */
  163.         $team = $em->getRepository(Team::class)->find($id);
  165.         $view = '@StartPlatzAlphaBundle/Startup/index.startups.sp-connect.html.twig';
  166.         $viewFeed = '@StartPlatzAlphaBundle/Startup/_feed.startups.sp-connect.html.twig';
  169.         if ($ajax) {
  170.             return $this->render($viewFeed, [
  171.                 'startups'   => $startups,
  172.                 'userMember' => $userMember,
  173.                 'startupsCurrentBatch' => $startupsCurrentBatch,
  174.                 'startupsLastBatch' => $startupsLastBatch,
  175.                 'startupsBatch20' => $startupsBatch20,
  176.                 'startupsSpCgn' => $startupsSpCgn,
  177.                 'startupsSpDus' => $startupsSpDus,
  178.                 'startupsAlumni' => $startupsAlumni,
  179.                 'startupsExtern' => $startupsExtern,
  180.                 'startupsRheinlandPitch'     => $startupsRheinlandPitch,
  181.                 'startupsGruenderstipendium'       => $startupsGruenderstipendium,
  182.                 'startupsGruenderstipendiumAlumni' => $startupsGruenderstipendiumAlumni,
  183.                 'team'       => $team,
  184.                 'teams'      => $teams,
  186.                 'maxPages'   => $maxPages,
  187.                 'thisPage'   => $page,
  188.                 'ajax'       => $ajax,
  190.                 'redirectUrl' => base64_encode(json_encode(['path' => $route, 'parameters' => $templateVars])),
  191.                 'templateVars' => $templateVars,
  192.                 'templateVarsLocation' => $templateVarsLocation,
  193.             ]);
  194.         } else {
  195.             return $this->render($view, [
  196.                 'startups'   => $startups,
  197.                 'userMember' => $userMember,
  198.                 'title'      => "Startups",
  199.                 'startupsCurrentBatch' => $startupsCurrentBatch,
  200.                 'startupsLastBatch' => $startupsLastBatch,
  201.                 'startupsBatch20' => $startupsBatch20,
  202.                 'startupsSpCgn' => $startupsSpCgn,
  203.                 'startupsSpDus' => $startupsSpDus,
  204.                 'startupsAlumni' => $startupsAlumni,
  205.                 'startupsExtern' => $startupsExtern,
  206.                 'startupsRheinlandPitch'     => $startupsRheinlandPitch,
  207.                 'startupsGruenderstipendium'       => $startupsGruenderstipendium,
  208.                 'startupsGruenderstipendiumAlumni' => $startupsGruenderstipendiumAlumni,
  209.                 'team'       => $team,
  210.                 'teams'      => $teams,
  213.                 'maxPages'   => $maxPages,
  214.                 'thisPage'   => $page,
  215.                 'ajax'       => $ajax,
  218.                 'redirectUrl' => base64_encode(json_encode(['path' => $route, 'parameters' => $templateVars])),
  219.                 'templateVars' => $templateVars,
  220.                 'templateVarsLocation' => $templateVarsLocation,
  221.                 'menuLinksAndPhrases' => $this->menuTranslationService->getMenuLinksAndPhrases($request->server->get('REQUEST_URI')),
  222.             ]);
  223.         }
  224.     }
  226.     /**
  227.      * @Route("/startups", name="homepage_startups_home")
  228.      * @Route("/en/startups", name="homepage_startups_home_english")
  229.      * @Route("/fr/startups", name="homepage_startups_home_french")
  230.      */
  231.     public function indexStartupsHomepageAction(Request $request)
  232.     {
  233.         $em = $this->getDoctrine()->getManager();
  234.         $redirect     = json_decode(base64_decode((string) $request->get('redirect')));
  235.         $redirectUrl  = $request->get('redirect');
  236.         $templateVars = $em->getRepository(Startup::class)->getTemplateVars($request);
  238.         $orderBy      = $templateVars['dimensions'] ?: ['score' => 'DESC'];
  239.         // Neue Zeile - Sortierung nach lastModified (neueste zuerst)
  240.         $orderBy = $templateVars['dimensions'] ?: ['lastModified' => 'DESC'];
  241.         $visibility   = 'public';
  242.         $criteria     = ['visibility' => $visibility] + $templateVars['criteria'];
  243.         $lang         = Utility::getLangByPathInfo($request->getPathInfo());
  245.         $teamId = 0;
  246.         if ($user = $this->getUser()) {
  247.             $teamId = $user->getMemberId();
  248.             $em->getRepository(User::class)->writeActivity($user);
  249.         }
  251.         $total = $em->getRepository(Startup::class)->countByCriteria($criteria, $teamId);
  253.         if ($total > 2560) {
  254.             $limit = 2560;
  255.         } else {
  256.             $limit = $total ?: 1;
  257.         }
  258.         if (!$page = $request->get('page')) {
  259.             $page = 1;
  260.         }
  262.         $startups = $em->getRepository(Startup::class)->findPaginated($criteria, $teamId, $orderBy, $page, $limit);
  263.         $startupsExtern = $em->getRepository(Startup::class)->findPaginated($criteria + ['startplatz' => 'extern'], $teamId, $orderBy, $page, $limit);
  265.         $rheinlandPitchBatches = [];
  266.         $rheinlandPitchWinnerApplications = [];
  267.         $rheinlandPitchWinnerStartups = [];
  269.         if (array_key_exists("rheinlandPitchBestResult", $criteria)) {
  270.             /*
  271.              * now use a totally different logic
  272.              * first we find all rheinlandPitchBatches
  273.              * then we find all winnerApplications
  274.              * then we find all related startups
  275.              */
  277.             $rheinlandPitchBatches = $em->getRepository(Batch::class)->findBy(['programId'=>1,'focusStatus'=>['4_past','3_previous','2_current']], ['pitchDate'=>'DESC']);
  278.             $rheinlandPitchWinnerApplications = $em->getRepository(Application::class)->findBy(['programId'=>1,'pitchPosition'=>1], ['batchId'=>'DESC']);
  279.             $rheinlandPitchWinnerStartupIds = array_map(fn (Application $entity) => $entity->getStartupId(), $rheinlandPitchWinnerApplications);
  280.             $rheinlandPitchWinnerStartups = $em->getRepository(Startup::class)->findBy(['id'=>$rheinlandPitchWinnerStartupIds]);
  281.             $rheinlandPitchWinnerStartupIds = array_map(fn (Startup $entity) => $entity->getId(), $rheinlandPitchWinnerStartups);
  282.             $rheinlandPitchWinnerStartups  = array_combine($rheinlandPitchWinnerStartupIds, $rheinlandPitchWinnerStartups);
  283.         }
  285.         $parentPageSlug = "startups";
  286.         if (!$parentPage = $em->getRepository(Page::class)->findOneBy(['slug' => $parentPageSlug])) {
  287.             $parentPage = new Page();
  288.             $parentPage->setTitle('Die STARTPLATZ Startups');
  289.             $parentPage->setTeaser('Die erfolgreichen Startups starten hier durch');
  290.             $parentPage->setDescription('Page Description');
  291.         }
  294.         $acceleratorCurrentBatchNumber = $em->getRepository(Option::class)->getAcceleratorCurrentBatchNumber();
  296.         $startupsCurrentBatch = $em->getRepository(Startup::class)->findPaginated($criteria + ['batch' => $acceleratorCurrentBatchNumber], $teamId, $orderBy, 1, 128);
  297.         $startupsLastBatch = $em->getRepository(Startup::class)->findPaginated($criteria + ['batch' => $acceleratorCurrentBatchNumber -1 ], $teamId, $orderBy, 1, 128);
  298.         $startupsBatch20 = $em->getRepository(Startup::class)->findPaginated($criteria + ['batch' => $acceleratorCurrentBatchNumber -2], $teamId, $orderBy, 1, 128);
  299.         $startupsSpCgn = $em->getRepository(Startup::class)->findPaginated($criteria + ['startplatz' => 'sp-cgn'], $teamId, $orderBy, 1, 128);
  300.         $startupsSpDus = $em->getRepository(Startup::class)->findPaginated($criteria + ['startplatz' => 'sp-dus'], $teamId, $orderBy, 1, 128);
  301.         $startupsAlumni = $em->getRepository(Startup::class)->findPaginated($criteria + ['startplatz' => 'alumni'], $teamId, $orderBy, 1, 128);
  303.         $startupsRheinlandPitch = [];
  304.         $rheinlandPitchOrderBy      = $templateVars['dimensions'] ? $templateVars['dimensions']+ ['rheinlandPitch' => 'ASC','rheinlandPitchBestResult' => 'DESC'] : ['rheinlandPitch' => 'ASC','rheinlandPitchBestResult' => 'DESC'];
  306.         $rheinlandPitchCurrentPitchNumber = $em->getRepository(Option::class)->getRheinlandPitchCurrentPitchNumber();
  307.         $startupsRheinlandPitch = $em->getRepository(Startup::class)->findPaginated($criteria + ['pitchNumber' => $rheinlandPitchCurrentPitchNumber], $teamId, $rheinlandPitchOrderBy, 1, 1280);
  308.         // startups of current rheinland pitch
  309.         // $startupsRheinlandPitch = $em->getRepository(Startup::class)->findCurrentRheinlandPitchStartups('2_current');
  311.         $startupsGruenderstipendium = [];
  312.         $startupsGruenderstipendium = $em->getRepository(Startup::class)->findPaginated($criteria + ['gsStatus' => ['funded','recommended']], $teamId, $orderBy, 1, 1280);
  314.         $startupsGruenderstipendiumAlumni = [];
  315.         $startupsGruenderstipendiumAlumni = $em->getRepository(Startup::class)->findPaginated($criteria + ['gsStatus' => ['alumni']], $teamId, $orderBy, 1, 1280);
  317.         $industries = $em->getRepository(Startup::class)->getAggregateByGroup('industry', $criteria);
  319.         // get teamIds
  320.         $teamIds = array_map(fn ($entity) => $entity['teamId'], $startups);
  321.         $teamIds = $teamIds + array_map(fn ($entity) => $entity['teamId'], $startupsCurrentBatch);
  322.         $teamIds = $teamIds + array_map(fn ($entity) => $entity['teamId'], $startupsLastBatch);
  323.         $teamIds = $teamIds + array_map(fn ($entity) => $entity['teamId'], $startupsBatch20);
  324.         $teamIds = $teamIds + array_map(fn ($entity) => $entity['teamId'], $startupsSpCgn);
  325.         $teamIds = $teamIds + array_map(fn ($entity) => $entity['teamId'], $startupsSpDus);
  326.         $teamIds = $teamIds + array_map(fn ($entity) => $entity['teamId'], $startupsAlumni);
  327.         $teamIds = $teamIds + array_map(fn ($entity) => $entity['teamId'], $startupsExtern);
  328.         $teamIds = $teamIds + array_map(fn ($entity) => $entity['teamId'], $startupsRheinlandPitch);
  329.         $teamIds = $teamIds + array_map(fn ($entity) => $entity['teamId'], $startupsGruenderstipendium);
  330.         $teamIds = $teamIds + array_map(fn ($entity) => $entity['teamId'], $startupsGruenderstipendiumAlumni);
  332.         $teams = $em->getRepository(Team::class)->findBy(['id'=>$teamIds]);
  333.         $teamIds = array_map(fn ($entity) => $entity->getId(), $teams);
  334.         $teams = array_combine($teamIds, $teams);
  336.         return $this->render('@StartPlatzAlphaBundle/Startup/index.startups.homepage.html.twig', [
  337.             'startups' => $startups,
  338.             'startupsCurrentBatch' => $startupsCurrentBatch,
  339.             'startupsLastBatch' => $startupsLastBatch,
  340.             'startupsBatch20' => $startupsBatch20,
  341.             'startupsSpCgn' => $startupsSpCgn,
  342.             'startupsSpDus' => $startupsSpDus,
  343.             'startupsAlumni' => $startupsAlumni,
  344.             'startupsExtern' => $startupsExtern,
  345.             'startupsRheinlandPitch'     => $startupsRheinlandPitch,
  346.             'startupsGruenderstipendium'       => $startupsGruenderstipendium,
  347.             'startupsGruenderstipendiumAlumni' => $startupsGruenderstipendiumAlumni,
  348.             'teams'              => $teams,
  349.             'currentBatchNumber' => $acceleratorCurrentBatchNumber,
  350.             'industries'         => $industries,
  351.             'parentPage'         => $parentPage,
  352.             'pageType'           => 'startup',
  353.             'topic'              => 'deepTech',
  354.             'lang' => $lang,
  356.             'rheinlandPitchBatches' => $rheinlandPitchBatches,
  357.             'rheinlandPitchWinnerApplications' => $rheinlandPitchWinnerApplications,
  358.             'rheinlandPitchWinnerStartups' => $rheinlandPitchWinnerStartups,
  361.         'maxPages' => ceil($total / $limit),
  362.             'thisPage' => $page,
  363.             'total' => $total,
  364.             'limit' => $limit,
  365.             'criteria' => $criteria,
  366.             'visibility' => $visibility,
  368.             'templateVars' => $templateVars,
  370.             'backUrl' => $redirectUrl,
  371.             'menuLinksAndPhrases' => $this->menuTranslationService->getMenuLinksAndPhrases($request->server->get('REQUEST_URI')),
  372.             'redirectUrl' => base64_encode(json_encode(['path' => 'website_startups_list', 'parameters' => $templateVars])),
  373.         ]);
  374.     }
  376.     /**
  377.      * @Route("/x/startups/industries/list", name="x_startups_industries_list")
  378.      */
  379.     public function listIndustriesAjaxAction(Request $request)
  380.     {
  381.         $em = $this->getDoctrine()->getManager();
  382.         $redirect = json_decode(base64_decode((string) $request->get('redirect')));
  383.         $templateVars = $em->getRepository(Startup::class)->getTemplateVars($request);
  384.         $currentCriteria = $templateVars['criteria'];
  385.         if (isset($templateVars['criteria']['industry'])) {
  386.             unset($templateVars['criteria']['industry']);
  387.         }
  388.         if (isset($templateVars['criteria']['isBookmarked'])) {
  389.             unset($templateVars['criteria']['isBookmarked']);
  390.         }
  392.         if (!$source = $request->get('source')) {
  393.             $visibility = 'sp-connect';
  394.             $targetPath = "x_connect_startups_home";
  395.         } else {
  396.             $visibility = 'public';
  397.             $targetPath = "homepage_startups_home";
  398.         }
  400.         $criteria = ['visibility' => $visibility, 'status' => 'active', 'team' => 'exists'] + $templateVars['criteria'];
  401.         if ($user = $this->getUser()) {
  402.             $teamId = $user->getMemberId();
  403.         } else {
  404.             $teamId = 0;
  405.         }
  407.         $industries = $em->getRepository(Startup::class)->findIndustries($criteria, $teamId);
  409.         return $this->render('@StartPlatzAlpha/Default/list.startupIndustries.modal.html.twig', [
  410.             'title' => "Available Industries",
  411.             'industries' => $industries,
  413.             'targetPath'      => $targetPath,
  414.             'currentCriteria' => $currentCriteria,
  415.             'templateVars'    => $templateVars,
  416.             'redirectUrl' => $request->get('redirect'),
  417.         ]);
  418.     }
  421.     /**
  422.      * @Route("/x/startups/tags/list", name="x_startups_tags_list")
  423.      */
  424.     public function listTagsAjaxAction(Request $request)
  425.     {
  426.         $em = $this->getDoctrine()->getManager();
  427.         $redirect = json_decode(base64_decode((string) $request->get('redirect')));
  428.         $templateVars = $em->getRepository(Startup::class)->getTemplateVars($request);
  429.         $currentCriteria = $templateVars['criteria'];
  430.         if (isset($templateVars['criteria']['tags'])) {
  431.             unset($templateVars['criteria']['tags']);
  432.         }
  433.         if (isset($templateVars['criteria']['isBookmarked'])) {
  434.             unset($templateVars['criteria']['isBookmarked']);
  435.         }
  437.         if (!$source = $request->get('source')) {
  438.             $visibility = 'sp-connect';
  439.             $targetPath = "x_connect_startups_home";
  440.         } else {
  441.             $visibility = 'public';
  442.             $targetPath = "homepage_startups_home";
  443.         }
  445.         $criteria = ['visibility' => $visibility, 'status' => 'active', 'team' => 'exists'] + $templateVars['criteria'];
  446.         if ($user = $this->getUser()) {
  447.             $teamId = $user->getMemberId();
  448.         } else {
  449.             $teamId = 0;
  450.         }
  452.         $entities = $em->getRepository(Startup::class)->findTags($criteria, $teamId);
  454.         return $this->render('@StartPlatzAlpha/Default/list.tags.modal.html.twig', [
  455.             'title' => "Tags",
  456.             'entities' => $entities,
  457.             'btnClass' => "btn-outline-info",
  458.             'targetEntity' => "tags",
  459.             'targetPath' => $targetPath,
  460.             'currentCriteria' => $currentCriteria,
  461.             'templateVars' => $templateVars,
  462.             'redirect' => $redirect,
  463.             'redirectUrl' => $request->get('redirect'),
  464.         ]);
  465.     }
  467.     /**
  468.      * @Route("/x/startups/filter/rheinland-pitch", name="x_startups_filter_rheinland-pitch")
  469.      */
  470.     public function selectFilterRheinlandPitchAction(Request $request)
  471.     {
  472.         $em = $this->getDoctrine()->getManager();
  473.         $redirect = json_decode(base64_decode((string) $request->get('redirect')));
  474.         $templateVars = $em->getRepository(Startup::class)->getTemplateVars($request);
  475.         if (!$source = $request->get('source')) {
  476.             $visibility = 'sp-connect';
  477.             $targetPath = "x_connect_startups_home";
  478.         } else {
  479.             $visibility = 'public';
  480.             $targetPath = "homepage_startups_home";
  481.         }
  483.         $criteria = ['visibility' => $visibility, 'status' => 'active', 'team' => 'exists'] + $templateVars['criteria'];
  484.         if ($user = $this->getUser()) {
  485.             $teamId = $user->getMemberId();
  486.         } else {
  487.             $teamId = 0;
  488.         }
  490.         $filter = $request->get('filter');
  492.         $group1 = "rheinlandPitchStatus";
  493.         $aggregates1 = $em->getRepository(Startup::class)->getAggregateByGroup($group1, $criteria);
  495.         $group2 = "rheinlandPitchBestResult";
  496.         $aggregates2 = $em->getRepository(Startup::class)->getAggregateByGroup($group2, $criteria);
  498.         // batches
  499.         $aggregatesBatches = $em->getRepository(Startup::class)->findApplicationsByProgramId(1);
  501.         return $this->render('@StartPlatzAlpha/Default/list.rheinland-pitch.modal.html.twig', [
  502.             'title'             => "Set Filter on {$filter}",
  503.             'btnClass'          => "btn-outline-info",
  504.             'group1'            => $group1,
  505.             'group2'            => $group2,
  506.             'aggregates1'       => $aggregates1,
  507.             'aggregates2'       => $aggregates2,
  508.             'aggregatesBatches' => $aggregatesBatches,
  509.             'targetPath'        => $targetPath,
  510.             'templateVars'      => $templateVars,
  511.             'redirect'          => $redirect,
  512.             'redirectUrl'       => $request->get('redirect'),
  513.         ]);
  514.     }
  516.     /**
  517.      * @Route("/x/startups/filter", name="x_startups_filter")
  518.      */
  519.     public function selectFilterAction(Request $request)
  520.     {
  521.         $em = $this->getDoctrine()->getManager();
  522.         $redirect = json_decode(base64_decode((string) $request->get('redirect')));
  523.         $templateVars = $em->getRepository(Startup::class)->getTemplateVars($request);
  524.         if (!$source = $request->get('source')) {
  525.             $visibility = 'sp-connect';
  526.         } else {
  527.             $visibility = 'public';
  528.         }
  529.         if (!$targetPath = $request->get('targetPath')) {
  530.             if ($visibility == 'sp-connect') {
  531.                 $targetPath = "x_connect_startups_home";
  532.             } else {
  533.                 $targetPath = "homepage_startups_home";
  534.             }
  535.         }
  536.         $criteria = ['visibility' => $visibility, 'status' => 'active', 'team' => 'exists'] + $templateVars['criteria'];
  537.         if ($user = $this->getUser()) {
  538.             $teamId = $user->getMemberId();
  539.         } else {
  540.             $teamId = 0;
  541.         }
  544.         $group = $request->get('filter');
  545.         $aggregates = $em->getRepository(Startup::class)->getAggregateByGroup($group, $criteria);
  547.         $group2 = "";
  548.         $aggregates2 = [];
  550.         if ($group == 'accelerator') {
  551.             $group2 = "batch";
  552.             $aggregates2 = $em->getRepository(Startup::class)->getAggregateByGroup($group2, $criteria, ['batchYear' => 'ASC'], true);
  553.         }
  554.         if ($group == 'rheinlandPitch') {
  555.             $group2 = "pitchNumber";
  556.             $aggregates2 = $em->getRepository(Startup::class)->findAndExpandAggregatesByField($group2, $criteria, $teamId, $group);
  557.         }
  560.         return $this->render('@StartPlatzAlpha/Default/list.aggregates.modal.html.twig', [
  561.             'title'        => "Set Filter on {$group}",
  562.             'aggregates'   => $aggregates,
  563.             'btnClass'     => "btn-outline-info",
  564.             'group'        => $group,
  565.             'group2'       => $group2,
  566.             'aggregates2'  => $aggregates2,
  567.             'targetPath'   => $targetPath,
  568.             'templateVars' => $templateVars,
  569.             'redirect'     => $redirect,
  570.             'redirectUrl'  => $request->get('redirect'),
  571.         ]);
  572.     }
  574.     /**
  575.      * @Route("/startups-legacy", name="extern_startups_home")
  576.      */
  577.     public function indexLegacyAction(Request $request)
  578.     {
  579.         $em = $this->getDoctrine()->getManager();
  580.         $member = $em->getRepository(Member::class)->findOneBy([]);
  581.         $fields = $this->feedbackService->getEntityMethodsArray($member, ['teams']);
  582.         $templateVars = $em->getRepository(Member::class)->getTemplateVars($request);
  583.         if ($user = $this->getUser()) {
  584.             $em->getRepository(User::class)->writeActivity($user);
  585.         }
  587.         $metaNameSectionBatch21 = 'website.startups.section.batch21';
  588.         $metaNameSectionBatch20 = 'website.startups.section.batch20';
  589.         $metaNameSectionBatch19 = 'website.startups.section.batch19';
  590.         $metaNameSectionBatch18 = 'website.startups.section.batch18';
  591.         $metaNameSectionBatch17 = 'website.startups.section.batch17';
  592.         $metaNameSectionKoeln = 'website.startups.section.koeln';
  593.         $metaNameSectionDus = 'website.startups.section.dus';
  594.         $metaNameSectionAlumni = 'website.startups.section.alumni';
  596.         $edit = $request->get('edit');
  597.         if (!in_array($edit, ['updateBatch21', 'updateBatch20', 'updateBatch19', 'updateBatch18', 'updateBatch17', 'updateKoeln', 'updateDus', 'updateAlumni'])) {
  598.             $edit = null;
  599.         }
  601.         $sectionBatch21 = $this->getSection($metaNameSectionBatch21);
  602.         $sectionBatch20 = $this->getSection($metaNameSectionBatch20);
  603.         $sectionBatch19 = $this->getSection($metaNameSectionBatch19);
  604.         $sectionBatch18 = $this->getSection($metaNameSectionBatch18);
  605.         $sectionBatch17 = $this->getSection($metaNameSectionBatch17);
  606.         $sectionKoeln = $this->getSection($metaNameSectionKoeln);
  607.         $sectionDus = $this->getSection($metaNameSectionDus);
  608.         $sectionAlumni = $this->getSection($metaNameSectionAlumni);
  610.         switch ($edit) {
  611.             case 'updateBatch21':
  612.                 $content = $this->transformArrayIntoCsvString($sectionBatch21['content']);
  613.                 $form = $this->setPlainEditorForm($content);
  614.                 break;
  615.             case 'updateBatch20':
  616.                 $content = $this->transformArrayIntoCsvString($sectionBatch20['content']);
  617.                 $form = $this->setPlainEditorForm($content);
  618.                 break;
  619.             case 'updateBatch19':
  620.                 $content = $this->transformArrayIntoCsvString($sectionBatch19['content']);
  621.                 $form = $this->setPlainEditorForm($content);
  622.                 break;
  623.             case 'updateBatch18':
  624.                 $content = $this->transformArrayIntoCsvString($sectionBatch18['content']);
  625.                 $form = $this->setPlainEditorForm($content);
  626.                 break;
  627.             case 'updateBatch17':
  628.                 $content = $this->transformArrayIntoCsvString($sectionBatch17['content']);
  629.                 $form = $this->setPlainEditorForm($content);
  630.                 break;
  631.             case 'updateKoeln':
  632.                 $content = $this->transformArrayIntoCsvString($sectionKoeln['content']);
  633.                 $form = $this->setPlainEditorForm($content);
  634.                 break;
  635.             case 'updateDus':
  636.                 $content = $this->transformArrayIntoCsvString($sectionDus['content']);
  637.                 $form = $this->setPlainEditorForm($content);
  638.                 break;
  639.             case 'updateAlumni':
  640.                 $content = $this->transformArrayIntoCsvString($sectionAlumni['content']);
  641.                 $form = $this->setPlainEditorForm($content);
  642.                 break;
  643.             default:
  644.                 $content = "";
  645.                 $form = $this->setEditorForm($content);
  646.         }
  648.         $form->handleRequest($request);
  650.         if ($form->isSubmitted() && $form->isValid()) {
  652.             $data = $form->getData();
  654.             $importString = $data['content'];
  655.             $rows = explode(PHP_EOL, (string) $importString);
  657.             switch ($edit) {
  658.                 case 'updateBatch21':
  659.                     $sectionBatch21['content'] = [];
  660.                     foreach ($rows as $row) {
  661.                         $sectionBatch21['content'][] = str_getcsv($row, "\t");
  662.                     }
  663.                     $em->getRepository(Option::class)->setOptionMetaValueJsonEncoded($metaNameSectionBatch21, null, $sectionBatch21);
  664.                     break;
  665.                 case 'updateBatch20':
  666.                     $sectionBatch20['content'] = [];
  667.                     foreach ($rows as $row) {
  668.                         $sectionBatch20['content'][] = str_getcsv($row, "\t");
  669.                     }
  670.                     $em->getRepository(Option::class)->setOptionMetaValueJsonEncoded($metaNameSectionBatch20, null, $sectionBatch20);
  671.                     break;
  672.                 case 'updateBatch19':
  673.                     $sectionBatch19['content'] = [];
  674.                     foreach ($rows as $row) {
  675.                         $sectionBatch19['content'][] = str_getcsv($row, "\t");
  676.                     }
  677.                     $em->getRepository(Option::class)->setOptionMetaValueJsonEncoded($metaNameSectionBatch19, null, $sectionBatch19);
  678.                     break;
  679.                 case 'updateBatch18':
  680.                     $sectionBatch18['content'] = [];
  681.                     foreach ($rows as $row) {
  682.                         $sectionBatch18['content'][] = str_getcsv($row, "\t");
  683.                     }
  684.                     $em->getRepository(Option::class)->setOptionMetaValueJsonEncoded($metaNameSectionBatch18, null, $sectionBatch18);
  685.                     break;
  686.                 case 'updateBatch17':
  687.                     $sectionBatch17['content'] = [];
  688.                     foreach ($rows as $row) {
  689.                         $sectionBatch17['content'][] = str_getcsv($row, "\t");
  690.                     }
  691.                     $em->getRepository(Option::class)->setOptionMetaValueJsonEncoded($metaNameSectionBatch17, null, $sectionBatch17);
  692.                     break;
  693.                 case 'updateKoeln':
  694.                     $sectionKoeln['content'] = [];
  695.                     foreach ($rows as $row) {
  696.                         $sectionKoeln['content'][] = str_getcsv($row, "\t");
  697.                     }
  698.                     $em->getRepository(Option::class)->setOptionMetaValueJsonEncoded($metaNameSectionKoeln, null, $sectionKoeln);
  699.                     break;
  700.                 case 'updateDus':
  701.                     $sectionDus['content'] = [];
  702.                     foreach ($rows as $row) {
  703.                         $sectionDus['content'][] = str_getcsv($row, "\t");
  704.                     }
  705.                     $em->getRepository(Option::class)->setOptionMetaValueJsonEncoded($metaNameSectionDus, null, $sectionDus);
  706.                     break;
  707.                 case 'updateAlumni':
  708.                     $sectionAlumni['content'] = [];
  709.                     foreach ($rows as $row) {
  710.                         $sectionAlumni['content'][] = str_getcsv($row, "\t");
  711.                     }
  712.                     $em->getRepository(Option::class)->setOptionMetaValueJsonEncoded($metaNameSectionAlumni, null, $sectionAlumni);
  713.                     break;
  714.             }
  717.             $this->session->getFlashBag()->add('notice', 'SUCCESS data saved');
  719.         }
  721.         $sectionBatch21 = $this->getSection($metaNameSectionBatch21);
  722.         $sectionBatch20 = $this->getSection($metaNameSectionBatch20);
  723.         $sectionBatch19 = $this->getSection($metaNameSectionBatch19);
  724.         $sectionBatch18 = $this->getSection($metaNameSectionBatch18);
  725.         $sectionBatch17 = $this->getSection($metaNameSectionBatch17);
  726.         $sectionKoeln = $this->getSection($metaNameSectionKoeln);
  727.         $sectionDus = $this->getSection($metaNameSectionDus);
  728.         $sectionAlumni = $this->getSection($metaNameSectionAlumni);
  731.         return $this->render('@StartPlatzAlphaBundle/Startup/index.legacy.html.twig', [
  732.             'templateVars' => [],
  734.             'form' => $form->createView(),
  735.             'sectionBatch21' => $sectionBatch21,
  736.             'sectionBatch20' => $sectionBatch20,
  737.             'sectionBatch19' => $sectionBatch19,
  738.             'sectionBatch18' => $sectionBatch18,
  739.             'sectionBatch17' => $sectionBatch17,
  740.             'sectionKoeln' => $sectionKoeln,
  741.             'sectionDus' => $sectionDus,
  742.             'sectionAlumni' => $sectionAlumni,
  743.             'edit' => $edit,
  746.             'menuLinksAndPhrases' => $this->menuTranslationService->getMenuLinksAndPhrases($request->server->get('REQUEST_URI')),
  747.             'redirectUrl' => base64_encode(json_encode(['path' => 'extern_startups_home', 'parameters' => []])),
  748.         ]);
  750.     }
  752.     /**
  753.      * @Route("/startup/{slug}", name="homepage_startup_single")
  754.      * @Route("/en/startup/{slug}", name="homepage_startup_single_english")
  755.      */
  756.     public function singleAction(Request $request, $slug)
  757.     {
  758.         $em = $this->getDoctrine()->getManager();
  759.         $templateVars = $em->getRepository(Team::class)->getTemplateVars($request);
  760.         /** @var User $user */
  761.         if ($user = $this->getUser()) {
  762.             $em->getRepository(User::class)->writeActivity($user);
  763.         }
  765.         $id = explode('-', (string) $slug)[0];
  766.         $slug = explode('-', (string) $slug)[1];
  768.         /** @var Startup $startup */
  769.         if (!$startup = $em->getRepository(Startup::class)->findOneBy(['id' => $id])) {
  770.             $this->session->getFlashBag()->add('notice', 'ERROR slug not found');
  771.             return $this->redirect($this->generateUrl('homepage_startups_home'));
  772.         }
  773.         if (!$team = $em->getRepository(Team::class)->findOneBy(['id' => $startup->getTeamId()])) {
  774.             $this->session->getFlashBag()->add('notice', 'ERROR insufficient data');
  775.             return $this->redirect($this->generateUrl('homepage_startups_home'));
  776.         }
  778.         $feedItems = [];
  779.         $entities = [];
  781.         if ($startup->getSlug()) {
  782.             // feedTags are expected to be a jsonArray
  783.             $feedTags = json_encode([$startup->getSlug()]);
  784.             $feedItems = $em->getRepository(Feed::class)->findByFeedTag($feedTags);
  785.             $entities = $em->getRepository(Feed::class)->getEntitiesByFeedItems($feedItems);
  786.         }
  788.         // rheinlandPitch has programId == 1
  789.         $rheinlandPitches = $em->getRepository(Application::class)->findApplicationsAndBatchesByStartupIdAndProgramId($id, 1);
  791.         $memberTypes = [];
  792.         $teamIndustries   = [];
  793.         $teamIndustryList = "";
  794.         $applications     = [];
  795.         if ($team) {
  796.             if ($team->getType() == 'Partner') {
  797.                 $memberTypes = ['GF', 'AP'];
  798.             }
  799.             $teamIndustries = $team->getIndustries();
  800.             $teamIndustryList = explode("#", (string) $teamIndustries);
  801.             // plausibility checks for members of that team
  802.             $em->getRepository(Member::class)->checkIfDescriptionIsEmptyButMentorProfileIsFilled($team);
  803.             $relevantProgramIds = ['1','2','3'];
  804.             $applications = $em->getRepository(Application::class)->findBy(['teamId'=>$team->getId(),'programId'=>$relevantProgramIds]);
  805.         }
  807.         $members = $em->getRepository(MemberTeam::class)->getTeamMembers($id, $memberTypes);
  809.         $allowEdit = false;
  810.         $teamMember = false;
  811.         if($user) {
  812.             $userEmail = $this->getUser()->getEmail();
  813.             foreach ($members as $member) {
  814.                 if ($member['email'] == $userEmail) {
  815.                     $teamMember = true;
  816.                     if ($member['type'] == 'AP' || $member['type'] == 'GF') {
  817.                         $allowEdit = true;
  818.                     }
  819.                 }
  820.             }
  821.         }
  824.         // create slugs from team on the fly and from startup, what is stored there
  825.         if ($team) {
  826.             $slugs[] = Utility::generateSlug($team->getShortName());
  827.         }
  828.         if ($startup->getSlug()) {
  829.             $slugs[] = $startup->getSlug();
  830.         }
  831.         $feedTags = json_encode(array_values(array_unique($slugs)));
  833.         if ($feedTags) {
  834.             $feedItems = $em->getRepository(Feed::class)->findByFeedTag($feedTags);
  835.             $em->getRepository(Actor::class)->updateScoreByFeedItems(is_countable($feedItems) ? count($feedItems) : 0, $startup->getId());
  836.             $entities = $em->getRepository(Feed::class)->getEntitiesByFeedItems($feedItems);
  837.         }
  839.         $hasVisibleApplication = false;
  840.         foreach ($applications as $application) {
  841.             if($application->getVisibility() == 'sp-connect') {
  842.                 $hasVisibleApplication = true;
  843.                 break;
  844.             }
  845.         }
  847.         $lang = Utility::getLangByPathInfo($request->getPathInfo());
  849.         if ($startup->getVisibility() == 'public') {
  850.             return $this->render('@StartPlatzAlphaBundle/Startup/single.homepage.html.twig', [
  852.                 'id' => $id,
  853.                 'startup' => $startup,
  854.                 'team' => $team,
  855.                 'feedItems' => $feedItems,
  856.                 'entities' => $entities,
  857.                 'lang' => $lang,
  858.                 'rheinlandPitches' => $rheinlandPitches,
  860.                 'redirectUrl' => base64_encode(json_encode(['path' => 'homepage_startup_single', 'parameters' => ['slug' => $id . '-' . $slug]])),
  861.                 'menuLinksAndPhrases' => $this->menuTranslationService->getMenuLinksAndPhrases($request->server->get('REQUEST_URI')),
  862.                 'applications' => $applications,
  863.                 'hasVisibleApplication' => $hasVisibleApplication,
  864.                 'methodsTeam'           => $team ? $this->feedbackService->getEntityMethodsArray($team, ['services', 'members']) : [],
  865.                 'methodsStartup' => $startup ? $this->feedbackService->getEntityMethodsArray($startup, []) : [],
  866.                 'feedTags' => $feedTags,
  867.                 'actor' => $em->getRepository(Actor::class)->findOneBy(['externalId' => $startup->getId()]),
  869.                 'templateVars' => $templateVars,
  870.                 'queryString' => '',
  871.                 //  'members' => $members,
  872.                 'memberTypes' => $memberTypes,
  873.                 'teamIndustryList' => $teamIndustryList,
  874.                 'allowEdit' => $allowEdit,
  875.                 'teamMember' => $teamMember,
  876.                 'memberTypeLabels' => $em->getRepository(MemberTeam::class)->getMemberTypeLabels(),
  877.                 'currentPath' => '/x/connect/team/{id}',
  878.                 'backUrl' => $request->get('redirect') ?: base64_encode(json_encode(['path' => 'x_connect_startups_home', 'parameters' => $templateVars])),
  879.             ]);
  880.         } else {
  881.             return $this->render('@StartPlatzAlphaBundle/Startup/single.homepage.sorry.html.twig', [
  883.                 'lang' => $lang,
  884.                 'menuLinksAndPhrases' => $this->menuTranslationService->getMenuLinksAndPhrases($request->server->get('REQUEST_URI')),
  886.                 'redirectUrl' => base64_encode(json_encode(['path' => 'homepage_startup_single', 'parameters' => ['slug' => $id . '-' . $slug]])),
  888.              ]);
  889.         }
  891.     }
  894.     /**
  895.      * @Route("/x/community/startups/home/", name="x_startups_home")
  896.      * @Security("is_granted('ROLE_USER')")
  897.      */
  898.     public function indexStartupsAction(Request $request)
  899.     {
  900.         $em = $this->getDoctrine()->getManager();
  901.         $redirect = json_decode(base64_decode((string) $request->get('redirect')));
  902.         $redirectUrl = $request->get('redirect');
  903.         $templateVars = $em->getRepository(Startup::class)->getTemplateVars($request);
  904.         $orderBy = $templateVars['dimensions'] ?: [];
  905.         $visibility = 'sp-connect';
  906.         $criteria = ['visibility' => $visibility] + $templateVars['criteria'];
  907.         $teamId = 0;
  909.         if ($user = $this->getUser()) {
  910.             $teamId = $user->getMemberId();
  911.             $em->getRepository(User::class)->writeActivity($user);
  912.             $member = $em->getRepository(Member::class)->find($user->getMemberId());
  913.         }
  915.         $total = $em->getRepository(Startup::class)->countByCriteria($criteria, $teamId);
  917.         if ($total > 12) {
  918.             $limit = 12;
  919.         } else {
  920.             $limit = $total ?: 1;
  921.         }
  922.         if (!$page = $request->get('page')) {
  923.             $page = 1;
  924.         }
  926.         $startups = $em->getRepository(Startup::class)->findPaginated($criteria, $teamId, $orderBy, $page, $limit);
  929.         $lang = $request->get('lang');
  931.         if (str_contains((string) $member->getTags(), 'beta')) {
  932.             $view = '@StartPlatzAlphaBundle/Startup/Startups__index.twig';
  934.         } else {
  935.             $view = '@StartPlatzAlphaBundle/Startup/Startups__index_old.twig';
  936.         }
  938.         return $this->render($view, [
  940.             'maxPages' => ceil($total / $limit),
  941.             'thisPage' => $page,
  942.             'total' => $total,
  943.             'criteria' => $criteria,
  944.             'visibility' => $visibility,
  946.             'templateVars' => $templateVars,
  948.             'startups' => $startups,
  949.             'backUrl' => $redirectUrl,
  950.             'menuLinksAndPhrases' => $this->menuTranslationService->getMenuLinksAndPhrases($request->server->get('REQUEST_URI')),
  951.             'redirectUrl' => base64_encode(json_encode(['path' => 'website_startups_list', 'parameters' => $templateVars])),
  952.         ]);
  953.     }
  955.     /**
  956.      * @Route("/startup-database/list/", name="website_startups_list")
  957.      * @Route("/startup-database/list/", name="extern_startups_list")
  958.      * @Security("is_granted('ROLE_USER')")
  959.      */
  960.     public function listAction(Request $request)
  961.     {
  962.         $em = $this->getDoctrine()->getManager();
  963.         $redirect = json_decode(base64_decode((string) $request->get('redirect')));
  964.         $redirectUrl = $request->get('redirect');
  965.         $templateVars = $em->getRepository(Startup::class)->getTemplateVars($request);
  966.         $orderBy = $templateVars['dimensions'] ?: [];
  967.         $visibility = 'public';
  968.         $criteria = ['visibility' => $visibility] + $templateVars['criteria'];
  969.         $teamId = 0;
  970.         if ($user = $this->getUser()) {
  971.             $teamId = $user->getMemberId();
  972.             $em->getRepository(User::class)->writeActivity($user);
  973.         }
  975.         $total = $em->getRepository(Startup::class)->countByCriteria($criteria, $teamId);
  977.         if ($total > 12) {
  978.             $limit = 12;
  979.         } else {
  980.             $limit = $total ?: 1;
  981.         }
  982.         if (!$page = $request->get('page')) {
  983.             $page = 1;
  984.         }
  986.         $startups = $em->getRepository(Startup::class)->findPaginated($criteria, $teamId, $orderBy, $page, $limit);
  989.         $lang = $request->get('lang');
  990.         $targetPath = $request->server->get('REQUEST_URI');
  992.         return $this->render('@StartPlatzAlphaBundle/Startup/list.html.twig', [
  993.             'targetPath' => $targetPath,
  994.             'lang' => $lang,
  996.             'maxPages' => ceil($total / $limit),
  997.             'thisPage' => $page,
  998.             'total' => $total,
  999.             'criteria' => $criteria,
  1000.             'visibility' => $visibility,
  1001.             'templateVars' => $templateVars,
  1003.             'startups' => $startups,
  1004.             'backUrl' => $redirectUrl,
  1005.             'menuLinksAndPhrases' => $this->menuTranslationService->getMenuLinksAndPhrases($request->server->get('REQUEST_URI')),
  1006.             'redirectUrl' => base64_encode(json_encode(['path' => 'website_startups_list', 'parameters' => $templateVars])),
  1007.         ]);
  1008.     }
  1010.     /**
  1011.      * @Route("/startup-database/show/{id}/{slug}", name="extern_startups_single")
  1012.      */
  1013.     public function singleExternAction(Request $request, $id, $slug)
  1014.     {
  1015.         $em = $this->getDoctrine()->getManager();
  1016.         if ($user = $this->getUser()) {
  1017.             $em->getRepository(User::class)->writeActivity($user);
  1018.         }
  1019.         if (!$redirect = json_decode(base64_decode((string) $request->get('redirect')))) {
  1020.             $redirect = new stdClass();
  1021.             $redirect->path = 'website_startups_list';
  1022.             $redirect->parameters = [];
  1023.         }
  1025.         $redirectUrl = $request->get('redirect');
  1027.         if (!$startup = $em->getRepository(Startup::class)->findOneBy(['id' => $id, 'visibility' => 'public'])) {
  1028.             $this->session->getFlashBag()->add('notice', 'ERROR 10 entity not found');
  1029.             return $this->redirect($this->generateUrl($redirect->path, (array)$redirect->parameters));
  1030.         }
  1033.         if ($slug != $startup->getSlug()) {
  1034.             return $this->redirect($this->generateUrl('extern_startups_single', ['id' => $id, 'slug' => $startup->getSlug(), 'redirect' => $redirectUrl]));
  1035.         }
  1037.         $rightToAccessTeam = false;
  1038.         $team = false;
  1039.         $memberId = 0;
  1040.         $teamId = $startup->getTeamId();
  1041.         if ($user = $this->getUser()) {
  1042.             $memberId = $user->getMemberId();
  1043.             if (!$member = $em->getRepository(Member::class)->findOneBy(['id' => $memberId])) {
  1044.                 $this->session->getFlashBag()->add('notice', 'ERROR There is a problem with your account please contact support@startplatz.de');
  1045.                 return $this->redirect($this->generateUrl($redirect->path, (array)$redirect->parameters));
  1046.             }
  1047.             if ($team = $em->getRepository(Team::class)->findOneBy(['id' => $teamId])) {
  1048.                 $rightToAccessTeam = $em->getRepository(MemberTeam::class)->checkAccessRight($member, $team);
  1049.                 $team = $em->getRepository(Team::class)->checkConsistencyWithStartup($team, $startup);
  1050.             }
  1051.         }
  1053.         // the use of memberId is on purpose
  1054.         $startupAttributes = $em->getRepository(StartupAttribute::class)->findOneBy(['startupId' => $startup->getId(), 'teamId' => $memberId]);
  1055.         $startupLivecycleEvents = $em->getRepository(StartupLifecycleEvent::class)->findBy(['startupId' => $startup->getId()], ['eventDate' => 'ASC']);
  1058.         $em->getRepository(StartupRelevance::class)->updateByUserAction($id, 'click');
  1060.         $rheinlandPitches = $em->getRepository(Application::class)->findBy(['startupId' => $id], ['batchId' => 'DESC']);
  1063.         return $this->render('@StartPlatzAlphaBundle/Startup/single.extern.twig', [
  1065.             'templateVars' => [],
  1067.             'startup' => $startup,
  1068.             'rightToAccessTeam' => $rightToAccessTeam,
  1069.             'startupAttributes' => $startupAttributes,
  1070.             'rheinlandPitches' => $rheinlandPitches,
  1071.             'startupLivecycleEvents' => $startupLivecycleEvents,
  1073.             'backUrl' => $redirectUrl,
  1074.             'menuLinksAndPhrases' => $this->menuTranslationService->getMenuLinksAndPhrases($request->server->get('REQUEST_URI')),
  1075.             'redirectUrl' => base64_encode(json_encode(['path' => 'extern_startups_single', 'parameters' => ['id' => $id, 'slug' => $startup->getSlug()]])),
  1076.         ]);
  1077.     }
  1079.     /**
  1080.      * @Route("/x/community/startup/single/{id}", name="x_community_startup_single")
  1081.      * @Security("is_granted('ROLE_USER')")
  1082.      */
  1083.     public function singleCommunityAction(Request $request, $id)
  1084.     {
  1085.         $em = $this->getDoctrine()->getManager();
  1086.         if ($user = $this->getUser()) {
  1087.             $em->getRepository(User::class)->writeActivity($user);
  1088.         }
  1089.         if (!$redirect = json_decode(base64_decode((string) $request->get('redirect')))) {
  1090.             $redirect = new stdClass();
  1091.             $redirect->path = 'x_home';
  1092.             $redirect->parameters = [];
  1093.         }
  1095.         $redirectUrl = $request->get('redirect');
  1097.         if (!$startup = $em->getRepository(Startup::class)->findSingleStartupByVisibility($id, 'sp-connect')) {
  1098.             $this->session->getFlashBag()->add('notice', 'ERROR 20 entity not found');
  1099.             return $this->redirect($this->generateUrl($redirect->path, (array)$redirect->parameters));
  1100.         }
  1102.         $rightToAccessTeam = false;
  1103.         $team = false;
  1104.         $memberId = 0;
  1105.         $teamId = $startup->getTeamId();
  1106.         if ($user = $this->getUser()) {
  1107.             $memberId = $user->getMemberId();
  1108.             if (!$member = $em->getRepository(Member::class)->findOneBy(['id' => $memberId])) {
  1109.                 $this->session->getFlashBag()->add('notice', 'ERROR There is a problem with your account please contact support@startplatz.de');
  1110.                 return $this->redirect($this->generateUrl($redirect->path, (array)$redirect->parameters));
  1111.             }
  1112.             if ($team = $em->getRepository(Team::class)->findOneBy(['id' => $teamId])) {
  1113.                 $rightToAccessTeam = $em->getRepository(MemberTeam::class)->checkAccessRight($member, $team);
  1114.                 $team = $em->getRepository(Team::class)->checkConsistencyWithStartup($team, $startup);
  1115.             }
  1116.         }
  1118.         // the use of memberId is on purpose
  1119.         $startupAttributes = $em->getRepository(StartupAttribute::class)->findOneBy(['startupId' => $startup->getId(), 'teamId' => $memberId]);
  1120.         $startupLivecycleEvents = $em->getRepository(StartupLifecycleEvent::class)->findBy(['startupId' => $startup->getId()], ['eventDate' => 'ASC']);
  1123.         $em->getRepository(StartupRelevance::class)->updateByUserAction($id, 'click');
  1125.         $rheinlandPitches = $em->getRepository(Application::class)->findBy(['startupId' => $id], ['batchId' => 'DESC']);
  1127.         $lang = $request->get('lang');
  1128.         $targetPath = $request->server->get('REQUEST_URI');
  1130.         return $this->render('@StartPlatzAlphaBundle/Startup/single.sp-connect.html.twig', [
  1131.             'targetPath' => $targetPath,
  1132.             'lang' => $lang,
  1134.             'templateVars' => [],
  1136.             'startup' => $startup,
  1137.             'rightToAccessTeam' => $rightToAccessTeam,
  1138.             'startupAttributes' => $startupAttributes,
  1139.             'rheinlandPitches' => $rheinlandPitches,
  1140.             'startupLivecycleEvents' => $startupLivecycleEvents,
  1142.             'backUrl' => $redirectUrl,
  1143.             'menuLinksAndPhrases' => $this->menuTranslationService->getMenuLinksAndPhrases($request->server->get('REQUEST_URI')),
  1144.             'redirectUrl' => base64_encode(json_encode(['path' => 'extern_startups_single', 'parameters' => ['id' => $id, 'slug' => $startup->getSlug()]])),
  1145.         ]);
  1146.     }
  1148.     /**
  1149.      * @Route("/allmeda/startups/toggle-ajax/{id}/{field}/{action}", name="startup_edit_field_ajax")
  1150.      * @Security("is_granted('ROLE_ADMIN')")
  1151.      */
  1152.     public function setToggleAjaxAction($id, $field, $action)
  1153.     {
  1154.         $em = $this->getDoctrine()->getManager();
  1155.         $response = $em->getRepository(Startup::class)->setField($field, $action, $id);
  1157.         if (str_starts_with((string) $response, 'field ')) {
  1158.             $response = "SUCCESS $response";
  1159.         }
  1161.         return new Response($response);
  1162.     }
  1164.     /**
  1165.      * @Route("/x/connect/startup/edit/{id}/set-with-data", name="x_connect_startup_set_field_ajax_with_data")
  1166.      * @Route("/x/connect/startup/edit/{id}/set/{field}/{action}", name="x_connect_startup_set_field_ajax")
  1167.      * @Security("is_granted('ROLE_USER')")
  1168.      */
  1169.     public function setAjaxAction(Request $request, $id = null, $field = null, $action = null)
  1170.     {
  1171.         $em = $this->getDoctrine()->getManager();
  1172.         $adminEmail = $this->getUser()->getIsAdmin() ? $this->getUser()->getEmail() : null;
  1174.         $id ?? $id = $request->get('id');
  1175.         $field ?? $field = $request->get('field');
  1176.         $action ?? $action = $request->get('action');
  1178.         if(!$id or !$field or !$action) {
  1179.             $response = 'ERROR some data is missing';
  1180.         } elseif (!$startup = $em->getRepository(Startup::class)->findOneBy(['id' => $id])) {
  1181.             $response = 'ERROR No entity found for id=' . $id;
  1182.         } else {
  1183.             $response = $em->getRepository(Startup::class)->setFieldByAjaxConnect($field, $action, $startup, $this->getUser());
  1184.             if (str_starts_with((string) $response, 'Updated ')) {
  1185.                 if($field == 'imageLink') {
  1186.                     $this->removeOldResourcesFromCloudinary("startup-banner-{$startup->getTeamId()}", $action);
  1187.                 } elseif($field == 'logoUrl') {
  1188.                     $this->removeOldResourcesFromCloudinary("startup-logo-{$startup->getTeamId()}", $action);
  1189.                 }
  1191.                 $response = "SUCCESS $response";
  1192.             }
  1193.         }
  1194.         return new Response($response);
  1195.     }
  1197.     /**
  1198.      * @Route("/x/connect/startup/edit/{id}/{slug}", name="x_startup_edit")
  1199.      * @Security("is_granted('ROLE_USER')")
  1200.      */
  1201.     public function editStartupAction(Request $request, $id, $slug)
  1202.     {
  1203.         $em = $this->getDoctrine()->getManager();
  1204.         $redirect = json_decode(base64_decode((string) $request->get('redirect')));
  1205.         $redirectUrl = $request->get('redirect');
  1207.         /** @var Startup $startup */
  1208.         if (!$startup = $em->getRepository(Startup::class)->findOneBy(['id' => $id])) {
  1209.             $this->session->getFlashBag()->add('notice', 'ERROR 30 entity not found');
  1210.             return $this->redirect($this->generateUrl($redirect->path, (array)$redirect->parameters));
  1211.         }
  1213.         $teamId = $startup->getTeamId();
  1215.         /** @var Team $team */
  1216.         $team = $em->getRepository(Team::class)->findOneBy(['id' => $teamId]);
  1218.         /** @var User $user */
  1219.         $user = $this->getUser();
  1221.         $teamRights = $em->getRepository(MemberTeam::class)->getTeamRights();
  1223.         if(!$user->getIsAdmin()) {
  1224.             if (!$userObjects = $em->getRepository(User::class)->getUserObjectsByTeamId($user, $teamId)) {
  1225.                 $this->session->getFlashBag()->add('notice', 'ERROR: you are not allowed to access this team');
  1226.                 return $this->redirect($this->generateUrl('x_home'));
  1227.             }
  1228.             /** @var Team $team */
  1229.             $team = $em->getRepository(Team::class)->findOneBy(['id' => $teamId]);
  1231.             $teamRight = $teamRights[$userObjects['accessRight']->getType()];
  1232.         } else {
  1233.             $teamRight = 'SP-Admin';
  1234.         }
  1236.         if($request->get('memberId') && $user->getIsAdmin()) {
  1237.             $memberId = $request->get('memberId');
  1238.         } else {
  1239.             $memberId = $user->getMemberId();
  1240.         }
  1241.         /** @var Member $member */
  1242.         $member = $em->getRepository(Member::class)->findOneBy(['id' => $user->getMemberId()]);
  1243.         $memberTeam = $em->getRepository(MemberTeam::class)->findOneBy(['member' => $member, 'team' => $team]);
  1244.         $teamRight = $memberTeam ? $teamRights[$memberTeam->getType()] : false;
  1246.         if ($errorMessage = $em->getRepository(Member::class)->hasValidMembership($member)) {
  1247.             $this->session->getFlashBag()->add('notice', 'ERROR ' . $errorMessage);
  1248.             return $this->redirect($this->generateUrl($redirect->path, (array)$redirect->parameters));
  1249.         }
  1250.         if (!$em->getRepository(MemberTeam::class)->checkAccessRight($member, $team) and !$user->getIsAdmin()) {
  1251.             $this->session->getFlashBag()->add('notice', 'ERROR There is a problem with your account, please contact support@startplatz.de');
  1252.             return $this->redirect($this->generateUrl($redirect->path, (array)$redirect->parameters));
  1253.         }
  1255.         $fields = Utility::getEntityFieldsArray($startup);
  1256.         $storedData = Utility::fillDataByObject($startup, $fields);
  1257.         $uploadTagLogo = "team-logo-{$teamId}";
  1258.         $uploadTagBanner = "startup-banner-{$teamId}";
  1260.         $industries = $em->getRepository(Startup::class)->getListOfIndustries();
  1262.         $form = $this->createForm(StartupType::class, $startup, ['industries' => $industries, 'editForm' => 'spConnect']);
  1263.         $form->handleRequest($request);
  1264.         if ($form->isSubmitted() && $form->isValid()) {
  1266.             $data = $form->getData();
  1268.             $updatedData = Utility::fillDataByObject($startup, $fields);
  1269.             $differences = array_diff_assoc($updatedData, $storedData);
  1271.             if ($differences) {
  1272.                 if (array_key_exists("imageLink", $differences) && $imageLink = $differences['imageLink']) {
  1273.                     $this->removeOldResourcesFromCloudinary($uploadTagBanner, $imageLink);
  1274.                 }
  1275.                 if (array_key_exists("logoUrl", $differences) && $imageLink = $differences['logoUrl']) {
  1276.                     $this->removeOldResourcesFromCloudinary($uploadTagLogo, $imageLink);
  1277.                 }
  1278.                 $startupScoreBefore = $startup->getScore();
  1279.                 $startup = $em->getRepository(Startup::class)->updateByEdit($startup, $differences, $user->getEmail());
  1280.                 if ($team) {
  1281.                     $team = $em->getRepository(Team::class)->syncDataWithStartup($team, $startup);
  1282.                 }
  1284.                 if ($startup->getVisibility() != "public" && $startup->getVisibility() != "sp-connect" && $startupScoreBefore < 250 && $startup->getScore() >= 250) {
  1285.                     $memberName = $member->getName();
  1286.                     $profileUrl = $request->getSchemeAndHttpHost() . $this->generateUrl("allmeda_startup_edit", ["id" => $startup->getId()]);
  1287.                     $mail = new Email();
  1288.                     $mail->subject("Startup profile filled in: {$startup->getName()}");
  1289.                     $mail->from(new Address("support@startplatz.de", "Startup profile complete"));
  1290.                     $mail->to(new Address("community-membership@startplatz.de", "Membership Profile"));
  1291.                     $mail->text("
  1292.                         Das Profil von Startup {$startup->getName()} (Id: {$startup->getId()}) wurde ausgefüllt und könnte nun veröffentlicht werden.
  1293.                         
  1294.                         The profile of startup {$startup->getName()} (Id: {$startup->getId()}) was filled in and could be set to public now.
  1295.                         
  1296.                         Link: {$profileUrl}
  1297.                         ");
  1298.                     try {
  1299.                         $this->mailer->send($mail);
  1300.                     } catch (TransportExceptionInterface) {
  1301.                         return new Response("ERROR Email couldn't be sent", 503);
  1302.                     }
  1307.                 }
  1308.                 // give bonus when edited
  1309.                 $em->getRepository(StartupRelevance::class)->updateRelevanceScoreByStartup($startup->getId(), $storedData['score'], $startup->getScore());
  1310.                 //sync actors
  1311.                 return $this->redirect($this->generateUrl('x_connect_team_show', ['id' => $teamId, 'toast' => base64_encode("Data have been saved."), 'toastType' => base64_encode('SUCCESS')]));
  1312.             } else {
  1313.                 return $this->redirect($this->generateUrl('x_connect_team_show', ['id' => $teamId, 'toast' => base64_encode("No data have been saved")]));
  1314.             }
  1315.         }
  1317.         $teamIndustries = (string) $team->getIndustries(); // Cast to string to ensure $teamIndustries is not null
  1318.         $teamIndustryList = explode("#", (string) $teamIndustries);
  1320.         // create slugs from team on the fly and from startup, what is stored there
  1321.         $slugs[] = Utility::generateSlug($team->getShortName());
  1322.         if ($startup->getSlug()) {
  1323.             $slugs[] = $startup->getSlug();
  1324.         }
  1325.         $feedTags = json_encode(array_values(array_unique($slugs)));
  1327.         return $this->render('@StartPlatzAlphaBundle/Startup/edit.startup-profile.html.twig', [
  1328.             'templateVars' => [],
  1330.             'form' => $form->createView(),
  1331.             'startup' => $startup,
  1332.             'team' => $team,
  1333.             'feedTags' => $feedTags,
  1334.             'teamIndustryList' => $teamIndustryList,
  1335.             'actor' => $em->getRepository(Actor::class)->findOneBy(['externalId' => $startup->getId()]),
  1336.             'members' => $members = $em->getRepository(MemberTeam::class)->findByTeam($team),
  1338.             'teamRights' => $teamRights,
  1339.             'teamRight' => $teamRight,
  1341.             'methodsTeam' => $this->feedbackService->getEntityMethodsArray($team, ['services', 'members']),
  1342.             'methodsStartup' => $startup ? $this->feedbackService->getEntityMethodsArray($startup, []) : [],
  1344.             'redirectUrl' => $redirectUrl,
  1345.             'menuLinksAndPhrases' => $this->menuTranslationService->getMenuLinksAndPhrases($request->server->get('REQUEST_URI')),
  1347.             'member' => $member,
  1348.             'uploadTagBanner' => $uploadTagBanner,
  1349.             'uploadTagLogo' => $uploadTagLogo,
  1350.             'ownMemberId' => $member->getId(),
  1351.         ]);
  1352.     }
  1354.     private function removeOldResourcesFromCloudinary($uploadTag, $link): void
  1355.     {
  1356.         $result = $this->cloudinary->resources_by_tag($uploadTag);
  1357.         $filter = fn ($res) => $res['secure_url'] != $link;
  1358.         $oldRefs = array_filter($result['resources'], $filter);
  1359.         $oldIds = array_map(fn ($res) => $res['public_id'], $oldRefs);
  1360.         if (!empty($oldIds)) {
  1361.             $result = $this->cloudinary->delete_resources($oldIds);
  1362.         }
  1363.     }
  1365.     /**
  1366.      * @Route("/startup-database/edit/{id}/{slug}", name="extern_startups_edit")
  1367.      * @Security("is_granted('ROLE_USER')")
  1368.      */
  1369.     public function editAction(Request $request, $id, $slug)
  1370.     {
  1371.         $em = $this->getDoctrine()->getManager();
  1372.         $redirect = json_decode(base64_decode((string) $request->get('redirect')));
  1373.         $redirectUrl = $request->get('redirect');
  1375.         /** @var Startup $startup */
  1376.         if (!$startup = $em->getRepository(Startup::class)->findOneBy(['id' => $id])) {
  1377.             $this->session->getFlashBag()->add('notice', 'ERROR 40 entity not found');
  1378.             return $this->redirect($this->generateUrl($redirect->path, (array)$redirect->parameters));
  1379.         }
  1381.         if ($slug != $startup->getSlug()) {
  1382.             return $this->redirect($this->generateUrl('extern_startups_single', ['id' => $id, 'slug' => $startup->getSlug(), 'redirect' => $redirectUrl]));
  1383.         }
  1385.         $rightToAccessTeam = false;
  1386.         $team = false;
  1387.         $memberId = 0;
  1388.         $teamId = $startup->getTeamId();
  1389.         /** @var User $user */
  1390.         if ($user = $this->getUser()) {
  1391.             $em->getRepository(User::class)->writeActivity($user);
  1393.             $memberId = $user->getMemberId();
  1394.             if (!$member = $em->getRepository(Member::class)->findOneBy(['id' => $memberId])) {
  1395.                 $this->session->getFlashBag()->add('notice', 'ERROR There is a problem with your account please contact support@startplatz.de');
  1396.                 return $this->redirect($this->generateUrl($redirect->path, (array)$redirect->parameters));
  1397.             }
  1398.             /** @var Team $team */
  1399.             if ($team = $em->getRepository(Team::class)->findOneBy(['id' => $teamId])) {
  1400.                 $rightToAccessTeam = $em->getRepository(MemberTeam::class)->checkAccessRight($member, $team);
  1401.             }
  1402.         }
  1404.         $admin = $user->getIsAdmin();
  1405.         if (!$rightToAccessTeam and !$admin) {
  1406.             $this->session->getFlashBag()->add('notice', 'ERROR There is a problem with your account-3 please contact support@startplatz.de');
  1407.             return $this->redirect($this->generateUrl($redirect->path, (array)$redirect->parameters));
  1408.         }
  1411.         // the use of memberId is on purpose
  1412.         $startupAttributes = $em->getRepository(StartupAttribute::class)->findOneBy(['startupId' => $startup->getId(), 'teamId' => $memberId]);
  1414.         $em->getRepository(StartupRelevance::class)->updateByUserAction($id, 'edit');
  1416.         $rheinlandPitches = $em->getRepository(Application::class)->findBy(['startupId' => $id], ['batchId' => 'DESC']);
  1418.         $fields = Utility::getEntityFieldsArray($startup);
  1419.         $storedData = Utility::fillDataByObject($startup, $fields);
  1421.         $industries = $em->getRepository(Startup::class)->getListOfIndustries();
  1423.         $form = $this->createForm(StartupType::class, $startup, ['industries' => $industries, 'editForm' => 'extern']);
  1424.         $form->handleRequest($request);
  1425.         if ($form->isSubmitted() && $form->isValid()) {
  1427.             $data = $form->getData();
  1430.             $updatedData = Utility::fillDataByObject($startup, $fields);
  1431.             $differences = array_diff_assoc($updatedData, $storedData);
  1433.             if ($differences) {
  1434.                 $startup = $em->getRepository(Startup::class)->updateByEdit($startup, $differences, $user->getEmail());
  1435.                 if ($team) {
  1436.                     $team = $em->getRepository(Team::class)->syncDataWithStartup($team, $startup);
  1437.                 }
  1438.             }
  1439.         }
  1442.         return $this->render('@StartPlatzAlphaBundle/Startup/edit.html.twig', [
  1444.             'templateVars' => [],
  1446.             'form' => $form->createView(),
  1447.             'startup' => $startup,
  1448.             'rightToAccessTeam' => $rightToAccessTeam,
  1449.             'startupAttributes' => $startupAttributes,
  1450.             'rheinlandPitches' => $rheinlandPitches,
  1452.             'backUrl' => $redirectUrl,
  1453.             'menuLinksAndPhrases' => $this->menuTranslationService->getMenuLinksAndPhrases($request->server->get('REQUEST_URI')),
  1454.             'redirectUrl' => base64_encode(json_encode(['path' => 'extern_startups_single', 'parameters' => ['id' => $id, 'slug' => $startup->getSlug()]])),
  1455.         ]);
  1456.     }
  1458.     /**
  1459.      * @Route("/startup-database/event/{id}/{slug}/{eventId}", name="extern_startups_event")
  1460.      * @Security("is_granted('ROLE_USER')")
  1461.      */
  1462.     public function startupLivecycleEventAction(Request $request, $id, $slug, $eventId)
  1463.     {
  1464.         $em = $this->getDoctrine()->getManager();
  1465.         $now = new DateTime();
  1466.         $redirect = json_decode(base64_decode((string) $request->get('redirect')));
  1467.         $redirectUrl = $request->get('redirect');
  1469.         if (!$startup = $em->getRepository(Startup::class)->findOneBy(['id' => $id])) {
  1470.             $this->session->getFlashBag()->add('notice', 'ERROR 50 entity not found');
  1471.             return $this->redirect($this->generateUrl($redirect->path, (array)$redirect->parameters));
  1472.         }
  1474.         if ($slug != $startup->getSlug()) {
  1475.             return $this->redirect($this->generateUrl('extern_startups_single', ['id' => $id, 'slug' => $startup->getSlug(), 'redirect' => $redirectUrl]));
  1476.         }
  1478.         $rightToAccessTeam = false;
  1479.         $team = false;
  1480.         $memberId = 0;
  1481.         $teamId = $startup->getTeamId();
  1482.         /** @var User $user */
  1483.         if ($user = $this->getUser()) {
  1484.             $em->getRepository(User::class)->writeActivity($user);
  1486.             $memberId = $user->getMemberId();
  1487.             if (!$member = $em->getRepository(Member::class)->findOneBy(['id' => $memberId])) {
  1488.                 $this->session->getFlashBag()->add('notice', 'ERRORThere is a problem with your account please contact support@startplatz.de');
  1489.                 return $this->redirect($this->generateUrl($redirect->path, (array)$redirect->parameters));
  1490.             }
  1491.             if ($team = $em->getRepository(Team::class)->findOneBy(['id' => $teamId])) {
  1492.                 $rightToAccessTeam = $em->getRepository(MemberTeam::class)->checkAccessRight($member, $team);
  1493.             }
  1494.         }
  1496.         $admin = $user->getIsAdmin();
  1497.         if (!$rightToAccessTeam and !$admin) {
  1498.             $this->session->getFlashBag()->add('notice', 'ERROR There is a problem with your account-4 please contact support@startplatz.de');
  1499.             return $this->redirect($this->generateUrl($redirect->path, (array)$redirect->parameters));
  1500.         }
  1503.         // the use of memberId is on purpose
  1504.         $startupAttributes = $em->getRepository(StartupAttribute::class)->findOneBy(['startupId' => $startup->getId(), 'teamId' => $memberId]);
  1505.         $em->getRepository(StartupRelevance::class)->updateByUserAction($id, 'edit');
  1507.         $rheinlandPitches = $em->getRepository(Application::class)->findBy(['startupId' => $id], ['batchId' => 'DESC']);
  1508.         $startupLivecycleEvents = $em->getRepository(StartupLifecycleEvent::class)->findBy(['startupId' => $startup->getId()], ['eventDate' => 'ASC']);
  1510.         if (!$livecycleEvent = $em->getRepository(StartupLifecycleEvent::class)->findOneBy(['id' => $eventId])) {
  1511.             $livecycleEvent = new StartupLifecycleEvent();
  1512.             $livecycleEvent->setEventDate($now);
  1513.             $livecycleEvent->setStartupId($id);
  1514.         }
  1516.         // set array oldData value, nr, text
  1517.         $fields = ['eventWhat', 'eventDate', 'linkText', 'link'];
  1518.         $oldData = $this->getDataAsArray($fields, $livecycleEvent);
  1520.         $form = $this->createForm(LivecycleEventType::class, $livecycleEvent);
  1521.         $form->handleRequest($request);
  1522.         if ($form->isSubmitted() && $form->isValid()) {
  1523.             $newData = $this->getDataAsArray($fields, $livecycleEvent);
  1524.             $differences = array_diff_assoc($newData, $oldData);
  1526.             if ($differences) {
  1527.                 $livecycleEvent = $em->getRepository(StartupLifecycleEvent::class)->updateByEdit($livecycleEvent, $differences, $user->getEmail());
  1528.                 $this->session->getFlashBag()->add('notice', 'SUCCESSData has been saved');
  1529.             }
  1530.             return $this->redirect($this->generateUrl($redirect->path, (array)$redirect->parameters));
  1531.         }
  1534.         return $this->render('@StartPlatzAlphaBundle/Startup/editLivecycleEvent.html.twig', [
  1536.             'templateVars' => [],
  1538.             'form' => $form->createView(),
  1539.             'startup' => $startup,
  1540.             'rightToAccessTeam' => $rightToAccessTeam,
  1541.             'startupAttributes' => $startupAttributes,
  1542.             'rheinlandPitches' => $rheinlandPitches,
  1543.             'livecycleEvent' => $livecycleEvent,
  1544.             'startupLivecycleEvents' => $startupLivecycleEvents,
  1546.             'backUrl' => $redirectUrl,
  1547.             'menuLinksAndPhrases' => $this->menuTranslationService->getMenuLinksAndPhrases($request->server->get('REQUEST_URI')),
  1548.             'redirectUrl' => base64_encode(json_encode(['path' => 'extern_startups_single', 'parameters' => ['id' => $id, 'slug' => $startup->getSlug()]])),
  1549.         ]);
  1550.     }
  1552.     /**
  1553.      * @Route("/startup-database/show-event/{id}/{slug}/{eventId}", name="extern_startups_show-event")
  1554.      * @Security("is_granted('ROLE_USER')")
  1555.      */
  1556.     public function showStartupLivecycleEventAction(Request $request, $id, $slug, $eventId)
  1557.     {
  1558.         $em = $this->getDoctrine()->getManager();
  1559.         $now = new DateTime();
  1560.         $redirect = json_decode(base64_decode((string) $request->get('redirect')));
  1561.         $redirectUrl = $request->get('redirect');
  1563.         if (!$startup = $em->getRepository(Startup::class)->findOneBy(['id' => $id])) {
  1564.             $this->session->getFlashBag()->add('notice', 'ERROR 60 entity not found');
  1565.             return $this->redirect($this->generateUrl($redirect->path, (array)$redirect->parameters));
  1566.         }
  1568.         if ($slug != $startup->getSlug()) {
  1569.             return $this->redirect($this->generateUrl('extern_startups_single', ['id' => $id, 'slug' => $startup->getSlug(), 'redirect' => $redirectUrl]));
  1570.         }
  1572.         /** @var User $user */
  1573.         if (!$user = $this->getUser()) {
  1574.             $this->session->getFlashBag()->add('notice', 'SUCCESSplease register or login');
  1575.             return $this->redirect($this->generateUrl($redirect->path, (array)$redirect->parameters));
  1576.         }
  1577.         $em->getRepository(User::class)->writeActivity($user);
  1579.         $em->getRepository(StartupRelevance::class)->updateByUserAction($id, 'edit');
  1581.         if (!$startupLivecycleEvent = $em->getRepository(StartupLifecycleEvent::class)->findOneBy(['id' => $eventId])) {
  1582.             $this->session->getFlashBag()->add('notice', 'ERRORError - no event found');
  1583.             return $this->redirect($this->generateUrl($redirect->path, (array)$redirect->parameters));
  1584.         }
  1587.         return $this->render('@StartPlatzAlphaBundle/Startup/showLivecycleEvent.html.twig', [
  1589.             'templateVars' => [],
  1591.             'startup' => $startup,
  1592.             'startupLivecycleEvent' => $startupLivecycleEvent,
  1594.             'backUrl' => $redirectUrl,
  1595.             'menuLinksAndPhrases' => $this->menuTranslationService->getMenuLinksAndPhrases($request->server->get('REQUEST_URI')),
  1596.             'redirectUrl' => base64_encode(json_encode(['path' => 'extern_startups_single', 'parameters' => ['id' => $id, 'slug' => $startup->getSlug()]])),
  1597.         ]);
  1598.     }
  1600.     private function getDataAsArray($fields, $entity)
  1601.     {
  1602.         foreach ($fields as $field) {
  1603.             $method = 'get' . ucfirst((string) $field);
  1604.             if (method_exists($entity, $method)) {
  1605.                 if ($entity->$method() instanceof DateTime) {
  1606.                     $data[$field] = $entity->$method()->format('Y-m-d');
  1607.                 } else {
  1608.                     $data[$field] = $entity->$method();
  1609.                 }
  1610.             } else {
  1611.                 $data[$field] = "";
  1612.             }
  1613.         }
  1614.         return $data;
  1615.     }
  1617.     /**
  1618.      * @Route("/startup-database/get-in-contact/{id}", name="extern_startups_get-in-contact")
  1619.      */
  1620.     public function getInContactAjaxAction(Request $request, $id)
  1621.     {
  1622.         $em = $this->getDoctrine()->getManager();
  1623.         $redirect = json_decode(base64_decode((string) $request->get('redirect')));
  1625.         return $this->render('@StartPlatzAlphaBundle/Startup/modal.register.html.twig', [
  1626.             'title' => "Get in contact",
  1627.             'btnClass' => "btn-outline-info",
  1628.             'id' => $id,
  1630.             'redirect' => $redirect,
  1631.             'redirectUrl' => $request->get('redirect'),
  1632.         ]);
  1633.     }
  1635.     /**
  1636.      * @Route("/startup-database/register/{id}", name="extern_startups_register")
  1637.      */
  1638.     public function registerAjaxAction(Request $request, $id)
  1639.     {
  1640.         $em = $this->getDoctrine()->getManager();
  1641.         $redirect = json_decode(base64_decode((string) $request->get('redirect')));
  1644.         return $this->render('@StartPlatzAlphaBundle/Startup/modal.register.html.twig', [
  1645.             'title' => "Please register",
  1646.             'btnClass' => "btn-outline-info",
  1647.             'id' => $id,
  1649.             'redirect' => $redirect,
  1650.             'redirectUrl' => $request->get('redirect'),
  1651.         ]);
  1652.     }
  1654.     /**
  1655.      * @Route("/x/community/startups/missions/", name="x_startups_missions")
  1656.      * @Security("is_granted('ROLE_USER')")
  1657.      */
  1658.     public function indexMissionsForBadge(Request $request)
  1659.     {
  1660.         $em = $this->getDoctrine()->getManager();
  1661.         $redirect = json_decode(base64_decode((string) $request->get('redirect')));
  1662.         $redirectUrl = $request->get('redirect');
  1663.         $templateVars = $em->getRepository(Startup::class)->getTemplateVars($request);
  1666.         /** @var User $user */
  1667.         $user = $this->getUser();
  1668.         $em->getRepository(User::class)->writeActivity($user, '/x/community/startups/');
  1670.         $id = $user->getTeamId();
  1673.         /** @var Team $team */
  1674.         $team = $em->getRepository(Team::class)->find($id);
  1676.         if (!$startup = $em->getRepository(Startup::class)->findOneBy(['id' => $team->getStartupId()])) {
  1677.             $startup = new Startup();
  1678.         } else {
  1679.             // increase relevance score every time a startup team is shown
  1680.             $em->getRepository(StartupRelevance::class)->updateByUserAction($startup->getId(), 'click');
  1681.         }
  1684.         $lang = $request->get('lang');
  1686.         $view = '@StartPlatzAlphaBundle/Startup/index.missionsForBadge.html.twig';
  1690.         return $this->render($view, [
  1691.             'team' => $team,
  1692.             'startup' => $startup,
  1693.             'templateVars' => $templateVars,
  1695.             'backUrl' => $redirectUrl,
  1696.             'menuLinksAndPhrases' => $this->menuTranslationService->getMenuLinksAndPhrases($request->server->get('REQUEST_URI')),
  1697.             'redirectUrl' => base64_encode(json_encode(['path' => 'website_startups_list', 'parameters' => $templateVars])),
  1698.         ]);
  1699.     }
  1702.     private function setEditorForm($content)
  1703.     {
  1704.         return $this->formFactory->createNamedBuilder('editor')
  1705.             ->add(
  1706.                 'content',
  1707.                 TinymceType::class,
  1708.                 [
  1709.                     'label' => 'Content',
  1710.                     'data' => $content,
  1711.                     'required' => false,
  1712.                 ]
  1713.             )
  1714.             ->add('save', SubmitType::class, ['label' => 'Save'])
  1715.             ->getForm();
  1716.     }
  1718.     private function setPlainEditorForm($content)
  1719.     {
  1720.         return $this->formFactory->createNamedBuilder('editor')
  1721.             ->add(
  1722.                 'content',
  1723.                 TextareaType::class,
  1724.                 [
  1725.                     'label' => 'Content',
  1726.                     'data' => $content,
  1727.                     'attr' => ['rows' => '17', 'cols' => '180'],
  1728.                     'required' => false,
  1729.                 ]
  1730.             )
  1731.             ->add('save', SubmitType::class, ['label' => 'Save'])
  1732.             ->getForm();
  1733.     }
  1736.     private function getSection($metaName)
  1737.     {
  1738.         $em = $this->getDoctrine()->getManager();
  1739.         if (!$section = $em->getRepository(Option::class)->getOptionMetaValue($metaName)) {
  1740.             $section['fields'] = $this->setSectionFields();
  1741.             $section['content'][] = [
  1742.                 "https://www.startplatz.de/wp-content/uploads/2012/11/golfpost_225x225.jpg",
  1743.                 "http://www.golfpost.de",
  1744.                 "Golf Post",
  1745.                 "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.",
  1746.                 "#golfistbesseralsdudenkst #wirsindanders #unsereweltistgrün",
  1747.                 "99999",
  1748.             ];
  1749.             $em->getRepository(Option::class)->setOptionMetaValueJsonEncoded($metaName, null, $section);
  1750.         }
  1751.         $section['entities'] = $this->setSectionEntities($section);
  1752.         return $section;
  1753.     }
  1755.     private function setSectionEntities($section)
  1756.     {
  1757.         $entities = [];
  1758.         foreach ($section['content'] as $row) {
  1759.             if ((is_countable($section['fields']) ? count($section['fields']) : 0) != (is_countable($row) ? count($row) : 0)) {
  1760.                 $i = 0;
  1761.                 foreach ($section['fields'] as $field) {
  1762.                     $entity[$field] = $row[$i] ?? $field;
  1763.                     $i++;
  1764.                 }
  1765.                 $entities[] = $entity;
  1766.             } else {
  1767.                 $entities[] = array_combine($section['fields'], $row);
  1768.             }
  1769.         }
  1770.         return $entities;
  1771.     }
  1774.     private function transformArrayIntoCsvString($rows)
  1775.     {
  1776.         $content = '';
  1777.         foreach ($rows as $row) {
  1778.             $content .= implode("\t", $row) . PHP_EOL;
  1779.         }
  1780.         return $content;
  1781.     }
  1784.     private function setSectionFields()
  1785.     {
  1786.         $fields = ['logo', 'url', 'name', 'desc', 'tags', 'teamId'];
  1787.         return $fields;
  1788.     }
  1791. }