src/Controller/MainController.php line 69

  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\Licences;
  10. use App\Entity\MediaCategory;
  11. use App\Entity\Mediathek;
  12. use App\Entity\Product;
  13. use App\Entity\SystemSettings;
  14. use App\Entity\User;
  15. use App\Entity\UserDetails;
  16. use App\MakeQrcode\ImageWithLogo;
  17. use App\Services\CurlManager;
  18. use chillerlan\QRCode\{Data\QRCodeDataException, QRCode, QRCodeException, QROptions};
  19. use Doctrine\DBAL\Exception;
  20. use Doctrine\ORM\EntityManagerInterface;
  22. use Sensio\Bundle\FrameworkExtraBundle\Configuration\IsGranted;
  23. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  24. use Symfony\Component\HttpFoundation\BinaryFileResponse;
  25. use Symfony\Component\HttpFoundation\JsonResponse;
  26. use Symfony\Component\HttpFoundation\Request;
  27. use Symfony\Component\HttpFoundation\RequestStack;
  28. use Symfony\Component\HttpFoundation\Response;
  29. use Symfony\Component\HttpKernel\KernelInterface;
  30. use Symfony\Component\PasswordHasher\Hasher\UserPasswordHasherInterface;
  31. use Symfony\Component\Routing\Annotation\Route;
  32. use Symfony\Component\Uid\Ulid;
  33. use Symfony\Component\Uid\UuidV1;
  34. use Symfony\Contracts\Translation\TranslatorInterface;
  35. use Ramsey\Uuid\Uuid;
  37. class MainController extends AbstractController
  38. {
  40.     use Settings;
  42.     private array $site_settings;
  44.     public function __construct(
  45.         private readonly EntityManagerInterface $em,
  46.         private readonly KernelInterface        $kernel,
  47.         private RequestStack                    $requestStack,
  48.         private readonly TranslatorInterface    $translator,
  49.         private readonly ImageWithLogo          $imageWithLogo,
  50.         private readonly CurlManager            $curlManager
  51.     )
  52.     {
  53.         $this->requestStack = $requestStack;
  54.         $ss = $this->em->getRepository(SystemSettings::class)->getSettings('site_settings');
  55.         if ($ss && isset($ss->record)) {
  56.             $this->site_settings = $ss->record;
  57.         } else {
  58.             $this->site_settings = [];
  59.         }
  60.     }
  63.     /**
  64.      * @throws QRCodeException
  65.      * @throws QRCodeDataException
  66.      * @throws Exception
  67.      */
  68.     #[Route('/', name: 'app_main')]
  69.     public function index_main(Request $request, UserPasswordHasherInterface $passEncoder): Response
  70.     {
  72.         $this->imageWithLogo->make_qrcode_with_logo();
  73.         // dd($result);
  74.         // return new Response($result, 200, ['Content-Type' => 'image/png']);
  75.         $uuid = new Ulid();
  76.         //dd($uuid->toRfc4122());
  77.         $locale = $request->getLocale();
  78.         // $request->setLocale('de');
  80.         $u = $this->em->getRepository(UserDetails::class)->findAll();
  81.         if (!$u) {
  82.             $this->set_default_settings($request, $passEncoder, $request->getUri());
  83.         }
  85.         $siteSettings = $this->em->getRepository(SystemSettings::class)->getSettings('site_settings');
  86.         if (strtolower(php_uname('s')) == 'linux') {
  87.             $dev = '> /dev/null 2>&1';
  88.         } else {
  89.             $dev = '';
  90.         }
  92.         $dirSrc = $this->getParameter('projectDir');
  93.         $command = sprintf('php81 %s/bin/console league:oauth2-server:clear-expired-tokens %s', $dirSrc, $dev);
  94.          passthru($command);
  96.         $isCronStartet = shell_exec("pgrep -fa 'cron --demand'");
  97.         if (!$isCronStartet) {
  98.            // $md = 'php /var/www/html/bin/console okvpn:cron --demand > /dev/null 2>&1';
  99.         }
  101.         return $this->render('main/index.html.twig', [
  102.             'settings' => $siteSettings->record,
  103.             'title' => $this->translator->trans('Homepage'),
  104.             'testImg' => ''
  105.         ]);
  106.     }
  108.     #[Route('/site/{slug}', name: 'site_slug')]
  109.     public function get_public_site(Request $request): Response
  110.     {
  111.         $slug = $request->get('slug');
  112.         $site = $this->em->getRepository(AppSites::class)->findOneBy(['site_slug' => $slug]);
  113.         if (!$site) {
  114.             return $this->render('main/404.html.twig', [
  115.             ]);
  116.         }
  117.         return $this->render('main/public-site-by-slug.html.twig', [
  118.             'title' => $site->getSiteTitle(),
  119.             'site_slug' => $site->getSiteSlug(),
  120.             'site_content' => html_entity_decode($site->getSiteContent()),
  121.             'site_excerpt' => html_entity_decode($site->getSiteExcerpt()),
  122.             'site_status' => $site->getSiteStatus(),
  123.             'site_comment_status' => $site->isSiteCommentStatus(),
  124.             'site_type' => $site->getSiteType(),
  125.             'site_created' => $site->getCreatedAt(),
  126.         ]);
  127.     }
  129.     #[Route('/theme/{slug}', name: 'theme_details')]
  130.     public function theme_details(Request $request): Response
  131.     {
  132.         $site = $this->em->getRepository(AppSites::class)->findOneBy(['site_slug' => $request->get('slug')]);
  133.         if (!$site) {
  134.             return $this->render('theme_plugin/theme_details/update-checker-404.html.twig', [
  135.             ]);
  136.         }
  137.         $helper = Helper::instance();
  138.         return $this->render('theme_plugin/theme_details/update-checker-details-theme.html.twig', [
  139.             'site_content' => $helper->replace_template(html_entity_decode($site->getSiteContent())),
  140.             'title' => $site->getSiteTitle()
  141.         ]);
  142.     }
  144.     #[Route('/{token}/cron', name: 'cron_job')]
  145.     public function make_cronjob(Request $request): JsonResponse
  146.     {
  148.         $cjToken = $this->cron_token;
  149.         if ($cjToken == $request->get('token')) {
  150.             $dirSrc = $this->getParameter('projectDir');
  151.             if (strtolower(php_uname('s')) == 'linux') {
  152.                 $dev = '> /dev/null 2>&1';
  153.             } else {
  154.                 $dev = '';
  155.             }
  156.             $cmdCron = sprintf('php %s/bin/console okvpn:cron --env=prod %s', $dirSrc, $dev);
  157.             $league = sprintf('php %s/bin/console league:oauth2-server:clear-expired-tokens %s', $dirSrc, $dev);
  158.             passthru($league);
  159.             passthru($cmdCron);
  160.             $response = [
  161.                 'status' => 1,
  162.                 'cron' => ['league', 'okvpn']
  163.             ];
  164.         } else {
  165.             $response = [
  166.                 'status' => 0,
  167.                 'cron' => 'ungültiger Token'
  168.             ];
  169.         }
  170.         return new JsonResponse(
  171.             $response,
  172.             200);
  173.     }
  175.     /**
  176.      * @param $size
  177.      * @param Request $request
  178.      * @param Mediathek $mediathek
  179.      * @return BinaryFileResponse|void
  180.      */
  181.     #[Route('/media{id}/{size}', name: 'media_image')]
  182.     public function get_media_file($size, Request $request, Mediathek $mediathek)
  183.     {
  184.         $dtaType = $mediathek->getType();
  185.         $filename = $mediathek->getBezeichnung();
  186.         if ($dtaType == 'data') {
  187.             $path = 'data';
  188.         } else {
  189.             $path = $size;
  190.         }
  191.         $file = $this->getParameter('uploads') . '/' . $path . '/' . $filename;
  192.         if (is_file($file)) {
  193.             return new BinaryFileResponse($file);
  194.         }
  195.     }
  197.     #[Route('/dashboard', name: 'app_app_main')]
  198.     #[IsGranted('ROLE_USER')]
  199.     public function app_main(Request $request): Response
  200.     {
  201.         $hasAccess = $this->isGranted('ROLE_ADMIN');
  202.         if ($hasAccess) {
  203.             return $this->redirect($this->generateUrl('dashboard_app_dashboard'));
  204.         }
  206.         $hasAccess = $this->isGranted('ROLE_USER');
  207.         if ($hasAccess) {
  208.             return $this->redirect($this->generateUrl('app_profile_profile'));
  209.         }
  211.         return $this->redirect($this->generateUrl('app_main'));
  212.     }
  214.     /**
  215.      * @throws Exception
  216.      */
  217.     private function set_default_settings($request, $passEncoder, $uri): void
  218.     {
  220.         $cronDir = $this->getParameter('cron_dir');
  221.         if (is_file($cronDir . 'cron.sh')) {
  222.             chmod($cronDir . 'cron.sh', 0777);
  223.         }
  224.         $createShellSh = '';
  225.         //TODO set default settings
  226.         $defaultSettings = $this->get_app_default_settings();
  227.         $ifSettings = $this->em->getRepository(SystemSettings::class)->findAll();
  228.         if (!$ifSettings) {
  229.             $settings = new SystemSettings();
  230.             $settings->setSettingsId(SystemSettingsController::SETTINGS_ID);
  231.             $settings->setEmailSettings(['data' => json_encode($defaultSettings['email_settings'])]);
  232.             $settings->setUploadSettings(['data' => json_encode($defaultSettings['upload_settings'])]);
  233.             $settings->setSiteSettings(['data' => json_encode($defaultSettings['site_settings'])]);
  234.             $settings->setOauthServerSettings(['data' => json_encode($defaultSettings['oauth_server_settings'])]);
  235.             $settings->setHeader(['data' => json_encode($defaultSettings['header'])]);
  236.             $this->em->persist($settings);
  237.             $this->em->flush();
  238.         }
  239.         $isMediaCat = $this->em->getRepository(MediaCategory::class)->findAll();
  240.         if (!$isMediaCat) {
  241.             $mediaCat = new MediaCategory();
  242.             $mediaCat->setPosition(0);
  243.             $mediaCat->setBezeichnung('Allgemein');
  244.             $mediaCat->setDescription('Allgemeine Kategorie');
  245.             $mediaCat->setFirstCat(1);
  246.             $this->em->persist($mediaCat);
  247.             $this->em->flush();
  248.         }
  249.         $helper = Helper::instance();
  250.         $tempDir = $this->getParameter('email_templates_dir');
  252.         $eTemplates = [
  253.             '0' => [
  254.                 'bezeichnung' => 'Aktivierungslink',
  255.                 'subject' => 'Konto aktivieren',
  256.                 'type' => 'system',
  257.                 'content' => htmlspecialchars($helper->replace_template(file_get_contents($tempDir . 'aktivierungslink.html'))),
  258.                 'position' => 1
  259.             ],
  260.             '1' => [
  261.                 'bezeichnung' => 'Link zum Passwort erstellen',
  262.                 'subject' => 'Passwort erstellen',
  263.                 'type' => 'system',
  264.                 'content' => htmlspecialchars($helper->replace_template(file_get_contents($tempDir . 'link-zum-pw-erstellen.html'))),
  265.                 'position' => 2
  266.             ],
  267.             '2' => [
  268.                 'bezeichnung' => 'E-Mail geändert (Bestätigung)',
  269.                 'subject' => 'E-Mail bestätigen',
  270.                 'type' => 'system',
  271.                 'content' => htmlspecialchars($helper->replace_template(file_get_contents($tempDir . 'email-change.html'))),
  272.                 'position' => 3
  273.             ],
  274.             '3' => [
  275.                 'bezeichnung' => 'Passwort vergessen',
  276.                 'subject' => 'neues Passwort erstellen',
  277.                 'type' => 'system',
  278.                 'content' => htmlspecialchars($helper->replace_template(file_get_contents($tempDir . 'passwort-vergessen.html'))),
  279.                 'position' => 4
  280.             ],
  281.             '4' => [
  282.                 'bezeichnung' => 'Signatur',
  283.                 'subject' => 'Signatur',
  284.                 'type' => 'signature',
  285.                 'content' => htmlspecialchars($helper->replace_template(file_get_contents($tempDir . 'signature-default.html'))),
  286.                 'position' => 5
  287.             ],
  288.             '5' => [
  289.                 'bezeichnung' => 'Autoresponder',
  290.                 'subject' => 'Automatische Antwort',
  291.                 'type' => 'responder',
  292.                 'content' => 'Autoresponder',
  293.                 'position' => 6
  294.             ],
  295.         ];
  296.         $isEmailTemplate = $this->em->getRepository(EmailTemplates::class)->findAll();
  297.         if (!$isEmailTemplate) {
  298.             foreach ($eTemplates as $tmp) {
  299.                 $emailTemplate = new EmailTemplates();
  300.                 $emailTemplate->setBezeichnung($tmp['bezeichnung']);
  301.                 $emailTemplate->setType($tmp['type']);
  302.                 $emailTemplate->setSubject($tmp['subject']);
  303.                 $emailTemplate->setContent($tmp['content']);
  304.                 $emailTemplate->setPosition($tmp['position']);
  305.                 $this->em->persist($emailTemplate);
  306.                 $this->em->flush();
  307.             }
  308.         }
  310.         $lizenz = new Licences();
  311.         $lizenz->setTimeLimit(0);
  312.         $lizenz->setBezeichnung('Standard Lizenz 2 URL kein Zeit Limit');
  313.         $lizenz->setBeschreibung('Lizenz mit 2 URL Freigaben ohne Zeitliche Begrenzung.');
  314.         $lizenz->setUrlLimit(2);
  315.         $lizenz->setType('default');
  316.         $lizenz->setPayId(0);
  317.         $lizenz->setPosition(0);
  318.         $this->em->persist($lizenz);
  319.         $this->em->flush();
  320.         $uuid = new Ulid();
  321.         $id = $uuid->toBase32();
  322.         $clientId = $helper->generate_identifier($id);
  323.         //$clientId = $helper->generate_callback_pw(32,0,16);
  324.         //Todo set SU-Admin
  325.         $suUserDetails = new UserDetails();
  326.         $suUserDetails->setRegisterIp($request->getClientIp());
  327.         $suUserDetails->setChangePw(true);
  328.         $suUserDetails->setAktiv(true);
  329.         $suUserDetails->setMustValidated(0);
  330.         $this->em->persist($suUserDetails);
  331.         $this->em->flush();
  333.         $uuid1 = Uuid::uuid1();
  334.         $suUser = new User();
  335.         $suUser->setRoles(['ROLE_ADMIN', 'ROLE_SUPER_ADMIN']);
  336.         $suUser->setPassword(
  337.             $passEncoder->hashPassword($suUser, $this->su_administrator_passwort)
  338.         );
  341.         $suUser->setUserdetails($suUserDetails);
  342.         $suUser->setEmail($this->su_administrator_email);
  343.         $suUser->setUuid(new UuidV1());
  344.         $this->em->persist($suUser);
  345.         $this->em->flush($suUser);
  347.         // Todo Set oAuth2
  348.         $clientSecret = $helper->generate_callback_pw(128, 0, 64);
  349.         $scopes = ['SUPER_USER'];
  350.         $grantTypes = ['authorization_code', 'refresh_token', 'client_credentials'];
  351.         $redirectUris = ['http://localhost:8080/callback', $uri . 'intern-callback'];
  353.         $conn = $this->em->getConnection();
  354.         $conn->insert('oauth2_client', [
  355.             'identifier' => $clientId,
  356.             'secret' => $clientSecret,
  357.             'name' => $suUser->getEmail(),
  358.             'redirect_uris' => implode(' ', $redirectUris),
  359.             'grants' => implode(' ', $grantTypes),
  360.             'scopes' => implode(' ', $scopes),
  361.             'active' => 1,
  362.             'allow_plain_text_pkce' => 0,
  363.         ]);
  365.         $uuid = new Ulid();
  366.         $id = $uuid->toBase32();
  367.         $clientId = $helper->generate_identifier($id);
  368.         //$clientId = $helper->generate_callback_pw(32,0,16);
  369.         //Todo set Admin
  370.         $userDetails = new UserDetails();
  371.         $userDetails->setRegisterIp($request->getClientIp());
  372.         $userDetails->setChangePw(true);
  373.         $userDetails->setAktiv(true);
  374.         $userDetails->setMustValidated(0);
  375.         $this->em->persist($userDetails);
  376.         $this->em->flush();
  379.         $uuid1 = Uuid::uuid1();
  380.         $user = new User();
  381.         $user->setRoles(['ROLE_ADMIN']);
  382.         $user->setPassword(
  383.             $passEncoder->hashPassword($user, $this->administrator_passwort)
  384.         );
  385.         $user->setUserdetails($userDetails);
  386.         $user->setEmail($this->administrator_email);
  387.         $user->setUuid(new UuidV1());
  388.         $this->em->persist($user);
  389.         $this->em->flush($user);
  391.         // Todo Set oAuth2
  392.         $clientSecret = $helper->generate_callback_pw(128, 0, 64);
  393.         $scopes = ['ADMIN'];
  395.         //$redirectUris = ['http://localhost:8080/callback', $uri . 'intern-callback'];
  396.         $conn = $this->em->getConnection();
  397.         $conn->insert('oauth2_client', [
  398.             'identifier' => $clientId,
  399.             'secret' => $clientSecret,
  400.             'name' => $user->getEmail(),
  401.             'redirect_uris' => implode(' ', $redirectUris),
  402.             'grants' => implode(' ', $grantTypes),
  403.             'scopes' => implode(' ', $scopes),
  404.             'active' => 1,
  405.             'allow_plain_text_pkce' => 0,
  406.         ]);
  407.     }
  409.     public function get_public_pages($id = NULL): array
  410.     {
  411.         $public = [
  412.             '0' => [
  413.                 'id' => 1,
  414.                 'route_name' => '_public_agb',
  415.                 'route' => '/agb',
  416.                 'template' => 'agb.html.twig',
  417.                 'name' => $this->translator->trans('AGB')
  418.             ],
  419.             '1' => [
  420.                 'id' => 2,
  421.                 'route_name' => '_public_impressum',
  422.                 'route' => '/impressum',
  423.                 'template' => 'impressum.html.twig',
  424.                 'name' => $this->translator->trans('Imprint')
  425.             ],
  426.             '2' => [
  427.                 'id' => 3,
  428.                 'route_name' => '_public_datenschutz',
  429.                 'route' => '/datenschutz',
  430.                 'template' => 'datenschutz.html.twig',
  431.                 'name' => $this->translator->trans('Privacy')
  432.             ],
  433.         ];
  435.         if ($id) {
  436.             foreach ($public as $tmp) {
  437.                 if ($tmp['id'] == $id) {
  438.                     return $tmp;
  439.                 }
  440.             }
  441.         }
  443.         return $public;
  444.     }
  445. }