src/Controller/MainController.php line 63

  1. <?php
  3. namespace App\Controller;
  5. use App\AppHelper\Helper;
  6. use App\AppHelper\Settings;
  7. use App\Entity\AppSites;
  8. use App\Entity\EmailTemplates;
  9. use App\Entity\MediaCategory;
  10. use App\Entity\Mediathek;
  11. use App\Entity\SystemSettings;
  12. use App\Entity\User;
  13. use App\Entity\UserDetails;
  14. use App\MakeQrcode\ImageWithLogo;
  15. use chillerlan\QRCode\{QRCode, QROptions};
  16. use Doctrine\DBAL\Exception;
  17. use Doctrine\ORM\EntityManagerInterface;
  19. use Sensio\Bundle\FrameworkExtraBundle\Configuration\IsGranted;
  20. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  21. use Symfony\Component\HttpFoundation\BinaryFileResponse;
  22. use Symfony\Component\HttpFoundation\Request;
  23. use Symfony\Component\HttpFoundation\RequestStack;
  24. use Symfony\Component\HttpFoundation\Response;
  25. use Symfony\Component\HttpKernel\KernelInterface;
  26. use Symfony\Component\PasswordHasher\Hasher\UserPasswordHasherInterface;
  27. use Symfony\Component\Routing\Annotation\Route;
  28. use Symfony\Component\Uid\Ulid;
  29. use Symfony\Component\Uid\UuidV1;
  30. use Symfony\Contracts\Translation\TranslatorInterface;
  31. use Ramsey\Uuid\Uuid;
  32. class MainController extends AbstractController
  33. {
  35.     use Settings;
  37.     private array $site_settings;
  39.     public function __construct(
  40.         private readonly EntityManagerInterface $em,
  41.         private readonly KernelInterface $kernel,
  42.         private RequestStack $requestStack,
  43.         private readonly TranslatorInterface $translator,
  44.         private readonly ImageWithLogo $imageWithLogo
  45.     )
  46.     {
  47.         $this->requestStack = $requestStack;
  48.         $ss = $this->em->getRepository(SystemSettings::class)->getSettings('site_settings');
  49.         if ($ss && isset($ss->record)) {
  50.             $this->site_settings = $ss->record;
  51.         } else {
  52.             $this->site_settings = [];
  53.         }
  54.     }
  55.     #[Route('/nelmio/csp/report', name: 'app_csp_report')]
  56.     public function csp_report(Request $request): Response
  57.     {
  58.         return $this->render('main/404.html.twig', [
  59.         ]);
  60.     }
  62.     #[Route('/', name: 'app_main')]
  63.     public function index_main(Request $request, UserPasswordHasherInterface $passEncoder): Response
  64.     {
  65.       //  dd($this->getParameter('projectDir'),$_SERVER, $this->getParameter('projectDir'));
  66.        $this->imageWithLogo->make_qrcode_with_logo();
  67.        // dd($result);
  68.        // return new Response($result, 200, ['Content-Type' => 'image/png']);
  69.         $uuid = new Ulid();
  70.         //dd($uuid->toRfc4122());
  71.         $locale = $request->getLocale();
  72.         // $request->setLocale('de');
  75.         $u = $this->em->getRepository(UserDetails::class)->findAll();
  76.         if (!$u) {
  77.             $this->set_default_settings($request, $passEncoder, $request->getUri());
  78.         }
  80.         $siteSettings = $this->em->getRepository(SystemSettings::class)->getSettings('site_settings');
  81.         if (strtolower(php_uname('s')) == 'linux'){
  82.             $dev = '> /dev/null 2>&1';
  83.         } else {
  84.             $dev = '';
  85.         }
  87.         $dirSrc = $this->getParameter('projectDir');
  88.         $command = sprintf('php %s/bin/console league:oauth2-server:clear-expired-tokens %s', $dirSrc, $dev);
  89.         passthru($command);
  91.         return $this->render('main/index.html.twig', [
  92.             'settings' => $siteSettings->record,
  93.             'title' => $this->translator->trans('Homepage'),
  94.             'testImg' => ''
  95.         ]);
  96.     }
  98.     #[Route('/site/{slug}', name: 'site_slug')]
  99.     public function get_public_site(Request $request): Response
  100.     {
  101.         $slug = $request->get('slug');
  102.         $site = $this->em->getRepository(AppSites::class)->findOneBy(['site_slug' => $slug]);
  103.         if (!$site) {
  104.             return $this->render('main/404.html.twig', [
  105.             ]);
  106.         }
  107.         return $this->render('main/public-site-by-slug.html.twig', [
  108.             'title' => $site->getSiteTitle(),
  109.             'site_slug' => $site->getSiteSlug(),
  110.             'site_content' => html_entity_decode($site->getSiteContent()),
  111.             'site_excerpt' => html_entity_decode($site->getSiteExcerpt()),
  112.             'site_status' => $site->getSiteStatus(),
  113.             'site_comment_status' => $site->isSiteCommentStatus(),
  114.             'site_type' => $site->getSiteType(),
  115.             'site_created' => $site->getCreatedAt(),
  116.         ]);
  117.     }
  119.     /**
  120.      * @param $size
  121.      * @param Request $request
  122.      * @param Mediathek $mediathek
  123.      * @return BinaryFileResponse|void
  124.      */
  125.     #[Route('/media{id}/{size}', name: 'media_image')]
  126.     public function get_media_file($size, Request $request, Mediathek $mediathek)
  127.     {
  128.         $dtaType = $mediathek->getType();
  129.         $filename = $mediathek->getBezeichnung();
  130.         if ($dtaType == 'data') {
  131.             $path = 'data';
  132.         } else {
  133.             $path = $size;
  134.         }
  135.         $file = $this->getParameter('uploads') . '/' . $path . '/' . $filename;
  136.         if (is_file($file)) {
  137.             return new BinaryFileResponse($file);
  138.         }
  139.     }
  141.     #[Route('/dashboard', name: 'app_app_main')]
  142.     #[IsGranted('ROLE_USER')]
  143.     public function app_main(Request $request): Response
  144.     {
  145.         $hasAccess = $this->isGranted('ROLE_ADMIN');
  146.         if ($hasAccess) {
  147.             return $this->redirect($this->generateUrl('dashboard_app_dashboard'));
  148.         }
  150.         $hasAccess = $this->isGranted('ROLE_USER');
  151.         if ($hasAccess) {
  152.             return $this->redirect($this->generateUrl('app_profile_profile'));
  153.         }
  155.         return $this->redirect($this->generateUrl('app_main'));
  156.     }
  158.     /**
  159.      * @throws Exception
  160.      */
  161.     private function set_default_settings($request, $passEncoder, $uri): void
  162.     {
  164.         //TODO set default settings
  165.         $defaultSettings = $this->get_app_default_settings();
  166.         $ifSettings = $this->em->getRepository(SystemSettings::class)->findAll();
  167.         if (!$ifSettings) {
  168.             $settings = new SystemSettings();
  169.             $settings->setSettingsId(SystemSettingsController::SETTINGS_ID);
  170.             $settings->setEmailSettings(['data' => json_encode($defaultSettings['email_settings'])]);
  171.             $settings->setUploadSettings(['data' => json_encode($defaultSettings['upload_settings'])]);
  172.             $settings->setSiteSettings(['data' => json_encode($defaultSettings['site_settings'])]);
  173.             $settings->setOauthServerSettings(['data' => json_encode($defaultSettings['oauth_server_settings'])]);
  174.             $settings->setHeader(['data' => json_encode($defaultSettings['header'])]);
  175.             $this->em->persist($settings);
  176.             $this->em->flush();
  177.         }
  178.         $isMediaCat = $this->em->getRepository(MediaCategory::class)->findAll();
  179.         if (!$isMediaCat) {
  180.             $mediaCat = new MediaCategory();
  181.             $mediaCat->setPosition(0);
  182.             $mediaCat->setBezeichnung('Allgemein');
  183.             $mediaCat->setDescription('Allgemeine Kategorie');
  184.             $mediaCat->setFirstCat(1);
  185.             $this->em->persist($mediaCat);
  186.             $this->em->flush();
  187.         }
  188.         $helper = Helper::instance();
  189.         $tempDir = $this->getParameter('email_templates_dir');
  191.         $eTemplates = [
  192.             '0' => [
  193.                 'bezeichnung' => 'Aktivierungslink',
  194.                 'subject' => 'Konto aktivieren',
  195.                 'type' => 'system',
  196.                 'content' => htmlspecialchars($helper->replace_template(file_get_contents($tempDir . 'aktivierungslink.html'))),
  197.                 'position' => 1
  198.             ],
  199.             '1' => [
  200.                 'bezeichnung' => 'Link zum Passwort erstellen',
  201.                 'subject' => 'Passwort erstellen',
  202.                 'type' => 'system',
  203.                 'content' => htmlspecialchars($helper->replace_template(file_get_contents($tempDir . 'link-zum-pw-erstellen.html'))),
  204.                 'position' => 2
  205.             ],
  206.             '2' => [
  207.                 'bezeichnung' => 'E-Mail geändert (Bestätigung)',
  208.                 'subject' => 'E-Mail bestätigen',
  209.                 'type' => 'system',
  210.                 'content' => htmlspecialchars($helper->replace_template(file_get_contents($tempDir . 'email-change.html'))),
  211.                 'position' => 3
  212.             ],
  213.             '3' => [
  214.                 'bezeichnung' => 'Passwort vergessen',
  215.                 'subject' => 'neues Passwort erstellen',
  216.                 'type' => 'system',
  217.                 'content' => htmlspecialchars($helper->replace_template(file_get_contents($tempDir . 'passwort-vergessen.html'))),
  218.                 'position' => 4
  219.             ],
  220.             '4' => [
  221.                 'bezeichnung' => 'Signatur',
  222.                 'subject' => 'Signatur',
  223.                 'type' => 'signature',
  224.                 'content' => htmlspecialchars($helper->replace_template(file_get_contents($tempDir . 'signature-default.html'))),
  225.                 'position' => 5
  226.             ],
  227.             '5' => [
  228.                 'bezeichnung' => 'Autoresponder',
  229.                 'subject' => 'Automatische Antwort',
  230.                 'type' => 'responder',
  231.                 'content' => 'Autoresponder',
  232.                 'position' => 6
  233.             ],
  234.         ];
  235.         $isEmailTemplate = $this->em->getRepository(EmailTemplates::class)->findAll();
  236.         if (!$isEmailTemplate) {
  237.             foreach ($eTemplates as $tmp) {
  238.                 $emailTemplate = new EmailTemplates();
  239.                 $emailTemplate->setBezeichnung($tmp['bezeichnung']);
  240.                 $emailTemplate->setType($tmp['type']);
  241.                 $emailTemplate->setSubject($tmp['subject']);
  242.                 $emailTemplate->setContent($tmp['content']);
  243.                 $emailTemplate->setPosition($tmp['position']);
  244.                 $this->em->persist($emailTemplate);
  245.                 $this->em->flush();
  246.             }
  247.         }
  250.         $uuid = new Ulid();
  251.         $id = $uuid->toBase32();
  252.         $clientId = $helper->generate_identifier($id);
  253.         //$clientId = $helper->generate_callback_pw(32,0,16);
  254.         //Todo set SU-Admin
  255.         $suUserDetails = new UserDetails();
  256.         $suUserDetails->setRegisterIp($request->getClientIp());
  257.         $suUserDetails->setChangePw(true);
  258.         $suUserDetails->setAktiv(true);
  259.         $suUserDetails->setMustValidated(0);
  260.         $this->em->persist($suUserDetails);
  261.         $this->em->flush();
  263.         $uuid1 = Uuid::uuid1();
  264.         $suUser = new User();
  265.         $suUser->setRoles(['ROLE_ADMIN', 'ROLE_SUPER_ADMIN']);
  266.         $suUser->setPassword(
  267.             $passEncoder->hashPassword($suUser, $this->su_administrator_passwort)
  268.         );
  271.         $suUser->setUserdetails($suUserDetails);
  272.         $suUser->setEmail($this->su_administrator_email);
  273.         $suUser->setUuid(new UuidV1());
  274.         $this->em->persist($suUser);
  275.         $this->em->flush($suUser);
  277.         // Todo Set oAuth2
  278.         $clientSecret = $helper->generate_callback_pw(128, 0, 64);
  279.         $scopes = ['SUPER_USER'];
  280.         $grantTypes = ['authorization_code', 'refresh_token', 'client_credentials'];
  281.         $redirectUris = ['http://localhost:8080/callback', $uri . 'intern-callback'];
  283.         $conn = $this->em->getConnection();
  284.         $conn->insert('oauth2_client', [
  285.             'identifier' => $clientId,
  286.             'secret' => $clientSecret,
  287.             'name' => $suUser->getEmail(),
  288.             'redirect_uris' => implode(' ',$redirectUris),
  289.             'grants' => implode(' ', $grantTypes),
  290.             'scopes' => implode(' ', $scopes),
  291.             'active' => 1,
  292.             'allow_plain_text_pkce' => 0,
  293.         ]);
  295.         $uuid = new Ulid();
  296.         $id = $uuid->toBase32();
  297.         $clientId = $helper->generate_identifier($id);
  298.         //$clientId = $helper->generate_callback_pw(32,0,16);
  299.         //Todo set Admin
  300.         $userDetails = new UserDetails();
  301.         $userDetails->setRegisterIp($request->getClientIp());
  302.         $userDetails->setChangePw(true);
  303.         $userDetails->setAktiv(true);
  304.         $userDetails->setMustValidated(0);
  305.         $this->em->persist($userDetails);
  306.         $this->em->flush();
  309.         $uuid1 = Uuid::uuid1();
  310.         $user = new User();
  311.         $user->setRoles(['ROLE_ADMIN']);
  312.         $user->setPassword(
  313.             $passEncoder->hashPassword($user, $this->administrator_passwort)
  314.         );
  315.         $user->setUserdetails($userDetails);
  316.         $user->setEmail($this->administrator_email);
  317.         $user->setUuid(new UuidV1());
  318.         $this->em->persist($user);
  319.         $this->em->flush($user);
  321.         // Todo Set oAuth2
  322.         $clientSecret = $helper->generate_callback_pw(128, 0, 64);
  323.         $scopes = ['ADMIN'];
  325.         //$redirectUris = ['http://localhost:8080/callback', $uri . 'intern-callback'];
  326.         $conn = $this->em->getConnection();
  327.         $conn->insert('oauth2_client', [
  328.             'identifier' => $clientId,
  329.             'secret' => $clientSecret,
  330.             'name' => $user->getEmail(),
  331.             'redirect_uris' => implode(' ', $redirectUris),
  332.             'grants' => implode(' ', $grantTypes),
  333.             'scopes' => implode(' ', $scopes),
  334.             'active' => 1,
  335.             'allow_plain_text_pkce' => 0,
  336.         ]);
  337.     }
  339.     public function get_public_pages($id = NULL): array
  340.     {
  341.         $public = [
  342.             '0' => [
  343.                 'id' => 1,
  344.                 'route_name' => '_public_agb',
  345.                 'route' => '/agb',
  346.                 'template' => 'agb.html.twig',
  347.                 'name' => $this->translator->trans('AGB')
  348.             ],
  349.             '1' => [
  350.                 'id' => 2,
  351.                 'route_name' => '_public_impressum',
  352.                 'route' => '/impressum',
  353.                 'template' => 'impressum.html.twig',
  354.                 'name' => $this->translator->trans('Imprint')
  355.             ],
  356.             '2' => [
  357.                 'id' => 3,
  358.                 'route_name' => '_public_datenschutz',
  359.                 'route' => '/datenschutz',
  360.                 'template' => 'datenschutz.html.twig',
  361.                 'name' => $this->translator->trans('Privacy')
  362.             ],
  363.         ];
  365.         if ($id) {
  366.             foreach ($public as $tmp) {
  367.                 if ($tmp['id'] == $id) {
  368.                     return $tmp;
  369.                 }
  370.             }
  371.         }
  373.         return $public;
  374.     }
  375. }