vendor/pimcore/pimcore/bundles/AdminBundle/Controller/Admin/SettingsController.php line 60

Open in your IDE?
  1. <?php
  2. /**
  3.  * Pimcore
  4.  *
  5.  * This source file is available under two different licenses:
  6.  * - GNU General Public License version 3 (GPLv3)
  7.  * - Pimcore Enterprise License (PEL)
  8.  * Full copyright and license information is available in
  9.  * LICENSE.md which is distributed with this source code.
  10.  *
  11.  * @copyright  Copyright (c) Pimcore GmbH (http://www.pimcore.org)
  12.  * @license    http://www.pimcore.org/license     GPLv3 and PEL
  13.  */
  15. namespace Pimcore\Bundle\AdminBundle\Controller\Admin;
  17. use Pimcore\Bundle\AdminBundle\Controller\AdminController;
  18. use Pimcore\Cache;
  19. use Pimcore\Cache\Core\CoreHandlerInterface;
  20. use Pimcore\Cache\Symfony\CacheClearer;
  21. use Pimcore\Config;
  22. use Pimcore\Db\ConnectionInterface;
  23. use Pimcore\Event\SystemEvents;
  24. use Pimcore\File;
  25. use Pimcore\Localization\LocaleServiceInterface;
  26. use Pimcore\Model;
  27. use Pimcore\Model\Asset;
  28. use Pimcore\Model\Document;
  29. use Pimcore\Model\Element;
  30. use Pimcore\Model\Glossary;
  31. use Pimcore\Model\Metadata;
  32. use Pimcore\Model\Property;
  33. use Pimcore\Model\Staticroute;
  34. use Pimcore\Model\Tool\Tag;
  35. use Pimcore\Model\WebsiteSetting;
  36. use Pimcore\Tool;
  37. use Symfony\Component\EventDispatcher\EventDispatcherInterface;
  38. use Symfony\Component\Filesystem\Filesystem;
  39. use Symfony\Component\HttpFoundation\BinaryFileResponse;
  40. use Symfony\Component\HttpFoundation\JsonResponse;
  41. use Symfony\Component\HttpFoundation\Request;
  42. use Symfony\Component\HttpFoundation\Response;
  43. use Symfony\Component\HttpKernel\KernelEvents;
  44. use Symfony\Component\HttpKernel\KernelInterface;
  45. use Symfony\Component\Routing\Annotation\Route;
  46. use Symfony\Component\Yaml\Yaml;
  48. /**
  49.  * @Route("/settings")
  50.  */
  51. class SettingsController extends AdminController
  52. {
  53.     /**
  54.      * @Route("/display-custom-logo", name="pimcore_settings_display_custom_logo", methods={"GET"})
  55.      *
  56.      * @param Request $request
  57.      *
  58.      * @return BinaryFileResponse
  59.      */
  60.     public function displayCustomLogoAction(Request $request)
  61.     {
  62.         // default logo
  63.         $logo = PIMCORE_WEB_ROOT . '/bundles/pimcoreadmin/img/logo-claim-gray.svg';
  64.         if ($request->get('white')) {
  65.             $logo = PIMCORE_WEB_ROOT . '/bundles/pimcoreadmin/img/logo-claim-white.svg';
  66.         }
  68.         $mime = 'image/svg+xml';
  69.         $customLogoPath = PIMCORE_CONFIGURATION_DIRECTORY . '/custom-logo.';
  71.         foreach (['svg', 'png', 'jpg'] as $format) {
  72.             $customLogoFile = $customLogoPath . $format;
  73.             if (file_exists($customLogoFile)) {
  74.                 try {
  75.                     $mime = Tool\Mime::detect($customLogoFile);
  76.                     $logo = $customLogoFile;
  77.                     break;
  78.                 } catch (\Exception $e) {
  79.                     // do nothing
  80.                 }
  81.             }
  82.         }
  84.         return new BinaryFileResponse($logo, 200, ['Content-Type' => $mime]);
  85.     }
  87.     /**
  88.      * @Route("/upload-custom-logo", name="pimcore_admin_settings_uploadcustomlogo", methods={"POST"})
  89.      *
  90.      * @param Request $request
  91.      *
  92.      * @return JsonResponse
  93.      *
  94.      * @throws \Exception
  95.      */
  96.     public function uploadCustomLogoAction(Request $request)
  97.     {
  98.         $fileExt = File::getFileExtension($_FILES['Filedata']['name']);
  99.         if (!in_array($fileExt, ['svg', 'png', 'jpg'])) {
  100.             throw new \Exception('Unsupported file format');
  101.         }
  102.         $customLogoPath = PIMCORE_CONFIGURATION_DIRECTORY . '/custom-logo.' . $fileExt;
  104.         copy($_FILES['Filedata']['tmp_name'], $customLogoPath);
  105.         @chmod($customLogoPath, File::getDefaultMode());
  107.         // set content-type to text/html, otherwise (when application/json is sent) chrome will complain in
  108.         // Ext.form.Action.Submit and mark the submission as failed
  110.         $response = $this->adminJson(['success' => true]);
  111.         $response->headers->set('Content-Type', 'text/html');
  113.         return $response;
  114.     }
  116.     /**
  117.      * @Route("/delete-custom-logo", name="pimcore_admin_settings_deletecustomlogo", methods={"DELETE"})
  118.      *
  119.      * @param Request $request
  120.      *
  121.      * @return JsonResponse
  122.      */
  123.     public function deleteCustomLogoAction(Request $request)
  124.     {
  125.         $customLogoPath = PIMCORE_CONFIGURATION_DIRECTORY . '/custom-logo.*';
  127.         $files = glob($customLogoPath);
  128.         foreach ($files as $file) {
  129.             unlink($file);
  130.         }
  132.         return $this->adminJson(['success' => true]);
  133.     }
  135.     /**
  136.      * Used by the predefined metadata grid
  137.      *
  138.      * @Route("/predefined-metadata", name="pimcore_admin_settings_metadata", methods={"POST"})
  139.      *
  140.      * @param Request $request
  141.      *
  142.      * @return JsonResponse
  143.      */
  144.     public function metadataAction(Request $request)
  145.     {
  146.         if ($request->get('data')) {
  147.             $this->checkPermission('asset_metadata');
  149.             if ($request->get('xaction') == 'destroy') {
  150.                 $data = $this->decodeJson($request->get('data'));
  151.                 $id = $data['id'];
  152.                 $metadata = Metadata\Predefined::getById($id);
  153.                 $metadata->delete();
  155.                 return $this->adminJson(['success' => true, 'data' => []]);
  156.             } elseif ($request->get('xaction') == 'update') {
  157.                 $data = $this->decodeJson($request->get('data'));
  159.                 // save type
  160.                 $metadata = Metadata\Predefined::getById($data['id']);
  162.                 $metadata->setValues($data);
  164.                 $existingItem = Metadata\Predefined\Listing::getByKeyAndLanguage($metadata->getName(), $metadata->getLanguage(), $metadata->getTargetSubtype());
  165.                 if ($existingItem && $existingItem->getId() != $metadata->getId()) {
  166.                     return $this->adminJson(['message' => 'rule_violation', 'success' => false]);
  167.                 }
  169.                 $metadata->minimize();
  170.                 $metadata->save();
  171.                 $metadata->expand();
  173.                 return $this->adminJson(['data' => $metadata, 'success' => true]);
  174.             } elseif ($request->get('xaction') == 'create') {
  175.                 $data = $this->decodeJson($request->get('data'));
  176.                 unset($data['id']);
  178.                 // save type
  179.                 $metadata = Metadata\Predefined::create();
  181.                 $metadata->setValues($data);
  183.                 $existingItem = Metadata\Predefined\Listing::getByKeyAndLanguage($metadata->getName(), $metadata->getLanguage(), $metadata->getTargetSubtype());
  184.                 if ($existingItem) {
  185.                     return $this->adminJson(['message' => 'rule_violation', 'success' => false]);
  186.                 }
  188.                 $metadata->save();
  190.                 return $this->adminJson(['data' => $metadata, 'success' => true]);
  191.             }
  192.         } else {
  193.             // get list of types
  195.             $list = new Metadata\Predefined\Listing();
  197.             if ($request->get('filter')) {
  198.                 $filter = $request->get('filter');
  199.                 $list->setFilter(function ($row) use ($filter) {
  200.                     foreach ($row as $value) {
  201.                         if (strpos($value, $filter) !== false) {
  202.                             return true;
  203.                         }
  204.                     }
  206.                     return false;
  207.                 });
  208.             }
  210.             $list->load();
  212.             $properties = [];
  213.             if (is_array($list->getDefinitions())) {
  214.                 foreach ($list->getDefinitions() as $metadata) {
  215.                     $metadata->expand();
  216.                     $properties[] = $metadata;
  217.                 }
  218.             }
  220.             return $this->adminJson(['data' => $properties, 'success' => true, 'total' => $list->getTotalCount()]);
  221.         }
  223.         return $this->adminJson(['success' => false]);
  224.     }
  226.     /**
  227.      * @Route("/get-predefined-metadata", name="pimcore_admin_settings_getpredefinedmetadata", methods={"GET"})
  228.      *
  229.      * @param Request $request
  230.      *
  231.      * @return JsonResponse
  232.      */
  233.     public function getPredefinedMetadataAction(Request $request)
  234.     {
  235.         $type = $request->get('type');
  236.         $subType = $request->get('subType');
  237.         $list = Metadata\Predefined\Listing::getByTargetType($type, [$subType]);
  238.         $result = [];
  239.         /** @var Metadata\Predefined $item */
  240.         foreach ($list as $item) {
  241.             $item->expand();
  242.             $result[] = $item;
  243.         }
  245.         return $this->adminJson(['data' => $result, 'success' => true]);
  246.     }
  248.     /**
  249.      * @Route("/properties", name="pimcore_admin_settings_properties", methods={"POST"})
  250.      *
  251.      * @param Request $request
  252.      *
  253.      * @return JsonResponse
  254.      */
  255.     public function propertiesAction(Request $request)
  256.     {
  257.         if ($request->get('data')) {
  258.             $this->checkPermission('predefined_properties');
  260.             if ($request->get('xaction') == 'destroy') {
  261.                 $data = $this->decodeJson($request->get('data'));
  262.                 $id = $data['id'];
  263.                 $property = Property\Predefined::getById($id);
  264.                 $property->delete();
  266.                 return $this->adminJson(['success' => true, 'data' => []]);
  267.             } elseif ($request->get('xaction') == 'update') {
  268.                 $data = $this->decodeJson($request->get('data'));
  270.                 // save type
  271.                 $property = Property\Predefined::getById($data['id']);
  272.                 if (is_array($data['ctype'])) {
  273.                     $data['ctype'] = implode(',', $data['ctype']);
  274.                 }
  275.                 $property->setValues($data);
  277.                 $property->save();
  279.                 return $this->adminJson(['data' => $property, 'success' => true]);
  280.             } elseif ($request->get('xaction') == 'create') {
  281.                 $data = $this->decodeJson($request->get('data'));
  282.                 unset($data['id']);
  284.                 // save type
  285.                 $property = Property\Predefined::create();
  286.                 $property->setValues($data);
  288.                 $property->save();
  290.                 return $this->adminJson(['data' => $property, 'success' => true]);
  291.             }
  292.         } else {
  293.             // get list of types
  294.             $list = new Property\Predefined\Listing();
  296.             if ($request->get('filter')) {
  297.                 $filter = $request->get('filter');
  298.                 $list->setFilter(function ($row) use ($filter) {
  299.                     foreach ($row as $value) {
  300.                         if ($value) {
  301.                             $cellValues = is_array($value) ? $value : [$value];
  303.                             foreach ($cellValues as $cellValue) {
  304.                                 if (strpos($cellValue, $filter) !== false) {
  305.                                     return true;
  306.                                 }
  307.                             }
  308.                         }
  309.                     }
  311.                     return false;
  312.                 });
  313.             }
  315.             $list->load();
  317.             $properties = [];
  318.             if (is_array($list->getProperties())) {
  319.                 foreach ($list->getProperties() as $property) {
  320.                     $properties[] = $property;
  321.                 }
  322.             }
  324.             return $this->adminJson(['data' => $properties, 'success' => true, 'total' => $list->getTotalCount()]);
  325.         }
  327.         return $this->adminJson(['success' => false]);
  328.     }
  330.     /**
  331.      * @Route("/get-system", name="pimcore_admin_settings_getsystem", methods={"GET"})
  332.      *
  333.      * @param Request $request
  334.      *
  335.      * @return JsonResponse
  336.      */
  337.     public function getSystemAction(Request $request)
  338.     {
  339.         $this->checkPermission('system_settings');
  341.         //TODO use Pimcore\Config service when legacy mapping is removed
  342.         $values = Config::getSystemConfig();
  344.         $timezones = \DateTimeZone::listIdentifiers();
  346.         $locales = Tool::getSupportedLocales();
  347.         $languageOptions = [];
  348.         $validLanguages = [];
  349.         foreach ($locales as $short => $translation) {
  350.             if (!empty($short)) {
  351.                 $languageOptions[] = [
  352.                     'language' => $short,
  353.                     'display' => $translation . " ($short)",
  354.                 ];
  355.                 $validLanguages[] = $short;
  356.             }
  357.         }
  359.         $valueArray = $values->toArray();
  360.         $valueArray['general']['validLanguage'] = explode(',', $valueArray['general']['validLanguages']);
  362.         //for "wrong" legacy values
  363.         if (is_array($valueArray['general']['validLanguage'])) {
  364.             foreach ($valueArray['general']['validLanguage'] as $existingValue) {
  365.                 if (!in_array($existingValue, $validLanguages)) {
  366.                     $languageOptions[] = [
  367.                         'language' => $existingValue,
  368.                         'display' => $existingValue,
  369.                     ];
  370.                 }
  371.             }
  372.         }
  374.         //cache exclude patterns - add as array
  375.         if (!empty($valueArray['full_page_cache']['excludePatterns'])) {
  376.             $patterns = explode(',', $valueArray['full_page_cache']['excludePatterns']);
  377.             if (is_array($patterns)) {
  378.                 foreach ($patterns as $pattern) {
  379.                     $valueArray['full_page_cache']['excludePatternsArray'][] = ['value' => $pattern];
  380.                 }
  381.             }
  382.         }
  384.         //remove password from values sent to frontend
  385.         unset($valueArray['database']);
  386.         foreach (['email', 'newsletter'] as $type) {
  387.             $valueArray[$type]['smtp']['auth']['password'] = '#####SUPER-SECRET-VALUE-PLACEHOLDER######';
  388.         }
  390.         // inject debug mode
  391.         $debugModeFile = PIMCORE_CONFIGURATION_DIRECTORY . '/debug-mode.php';
  392.         $debugMode = [];
  393.         if (file_exists($debugModeFile)) {
  394.             $debugMode = include $debugModeFile;
  395.         }
  396.         $valueArray['general']['debug'] = $debugMode['active'] ?? false;
  397.         $valueArray['general']['debug_ip'] = $debugMode['ip'] ?? '';
  398.         $valueArray['general']['devmode'] = $debugMode['devmode'] ?? false;
  400.         $response = [
  401.             'values' => $valueArray,
  402.             'config' => [
  403.                 'timezones' => $timezones,
  404.                 'languages' => $languageOptions,
  405.                 'client_ip' => $request->getClientIp(),
  406.                 'google_private_key_exists' => file_exists(\Pimcore\Google\Api::getPrivateKeyPath()),
  407.                 'google_private_key_path' => \Pimcore\Google\Api::getPrivateKeyPath(),
  408.                 'path_separator' => PATH_SEPARATOR,
  409.             ],
  410.         ];
  412.         return $this->adminJson($response);
  413.     }
  415.     /**
  416.      * @Route("/set-system", name="pimcore_admin_settings_setsystem", methods={"PUT"})
  417.      *
  418.      * @param Request $request
  419.      * @param LocaleServiceInterface $localeService
  420.      *
  421.      * @return JsonResponse
  422.      */
  423.     public function setSystemAction(Request $request, LocaleServiceInterface $localeService)
  424.     {
  425.         $this->checkPermission('system_settings');
  427.         $values = $this->decodeJson($request->get('data'));
  429.         $existingValues = [];
  430.         try {
  431.             $file = Config::locateConfigFile('system.yml');
  432.             $existingValues = Config::getConfigInstance($file, true);
  433.         } catch (\Exception $e) {
  434.             // nothing to do
  435.         }
  437.         // fallback languages
  438.         $fallbackLanguages = [];
  439.         $existingValues['pimcore']['general']['fallback_languages'] = [];
  440.         $languages = explode(',', $values['general.validLanguages']);
  441.         $filteredLanguages = [];
  442.         foreach ($languages as $language) {
  443.             if (isset($values['general.fallbackLanguages.' . $language])) {
  444.                 $fallbackLanguages[$language] = str_replace(' ', '', $values['general.fallbackLanguages.' . $language]);
  445.             }
  447.             if ($localeService->isLocale($language)) {
  448.                 $filteredLanguages[] = $language;
  449.             }
  450.         }
  452.         // check if there's a fallback language endless loop
  453.         foreach ($fallbackLanguages as $sourceLang => $targetLang) {
  454.             $this->checkFallbackLanguageLoop($sourceLang, $fallbackLanguages);
  455.         }
  457.         $cacheExcludePatterns = $values['full_page_cache.excludePatterns'];
  458.         if (is_array($cacheExcludePatterns)) {
  459.             $cacheExcludePatterns = implode(',', $cacheExcludePatterns);
  460.         }
  462.         $settings['pimcore'] = [
  463.             'general' => [
  464.                 'timezone' => $values['general.timezone'],
  465.                 'path_variable' => $values['general.path_variable'],
  466.                 'domain' => $values['general.domain'],
  467.                 'redirect_to_maindomain' => $values['general.redirect_to_maindomain'],
  468.                 'language' => $values['general.language'],
  469.                 'valid_languages' => implode(',', $filteredLanguages),
  470.                 'fallback_languages' => $fallbackLanguages,
  471.                 'default_language' => $values['general.defaultLanguage'],
  472.                 'disable_usage_statistics' => $values['general.disableusagestatistics'],
  473.                 'debug_admin_translations' => $values['general.debug_admin_translations'],
  474.                 'instance_identifier' => $values['general.instanceIdentifier'],
  475.                 'show_cookie_notice' => $values['general.show_cookie_notice'],
  476.             ],
  477.             'documents' => [
  478.                 'versions' => [
  479.                     'days' => $values['documents.versions.days'] ?? null,
  480.                     'steps' => $values['documents.versions.steps'] ?? null,
  481.                 ],
  482.                 'error_pages' => [
  483.                     'default' => $values['documents.error_pages.default'],
  484.                 ],
  485.                 'allow_trailing_slash' => $values['documents.allowtrailingslash'],
  486.                 'generate_preview' => $values['documents.generatepreview'],
  487.             ],
  488.             'objects' => [
  489.                 'versions' => [
  490.                     'days' => $values['objects.versions.days'] ?? null,
  491.                     'steps' => $values['objects.versions.steps'] ?? null,
  492.                 ],
  493.             ],
  494.             'assets' => [
  495.                 'versions' => [
  496.                     'days' => $values['assets.versions.days'] ?? null,
  497.                     'steps' => $values['assets.versions.steps'] ?? null,
  498.                 ],
  499.                 'icc_rgb_profile' => $values['assets.icc_rgb_profile'],
  500.                 'icc_cmyk_profile' => $values['assets.icc_cmyk_profile'],
  501.                 'hide_edit_image' => $values['assets.hide_edit_image'],
  502.                 'disable_tree_preview' => $values['assets.disable_tree_preview'],
  503.             ],
  504.             'services' => [
  505.                 'google' => [
  506.                     'client_id' => $values['services.google.client_id'],
  507.                     'email' => $values['services.google.email'],
  508.                     'simple_api_key' => $values['services.google.simpleapikey'],
  509.                     'browser_api_key' => $values['services.google.browserapikey'],
  510.                 ],
  511.             ],
  512.             'full_page_cache' => [
  513.                 'enabled' => $values['full_page_cache.enabled'],
  514.                 'lifetime' => $values['full_page_cache.lifetime'],
  515.                 'exclude_patterns' => $cacheExcludePatterns,
  516.                 'exclude_cookie' => $values['full_page_cache.excludeCookie'],
  517.             ],
  518.             'webservice' => [
  519.                 'enabled' => $values['webservice.enabled'],
  520.             ],
  521.             'httpclient' => [
  522.                 'adapter' => $values['httpclient.adapter'],
  523.                 'proxy_host' => $values['httpclient.proxy_host'],
  524.                 'proxy_port' => $values['httpclient.proxy_port'],
  525.                 'proxy_user' => $values['httpclient.proxy_user'],
  526.                 'proxy_pass' => $values['httpclient.proxy_pass'],
  527.             ],
  528.             'applicationlog' => [
  529.                 'mail_notification' => [
  530.                     'send_log_summary' => $values['applicationlog.mail_notification.send_log_summary'],
  531.                     'filter_priority' => $values['applicationlog.mail_notification.filter_priority'],
  532.                     'mail_receiver' => $values['applicationlog.mail_notification.mail_receiver'],
  533.                 ],
  534.                 'archive_treshold' => $values['applicationlog.archive_treshold'],
  535.                 'archive_alternative_database' => $values['applicationlog.archive_alternative_database'],
  536.             ],
  537.         ];
  539.         //branding
  540.         $settings['pimcore_admin'] = [
  541.             'branding' =>
  542.                 [
  543.                     'login_screen_invert_colors' => $values['branding.login_screen_invert_colors'],
  544.                     'color_login_screen' => $values['branding.color_login_screen'],
  545.                     'color_admin_interface' => $values['branding.color_admin_interface'],
  546.                     'login_screen_custom_image' => $values['general.loginscreencustomimage'],
  547.                 ],
  548.         ];
  550.         // email & newsletter (swiftmailer settings)
  551.         foreach (['email' => 'pimcore_mailer', 'newsletter' => 'newsletter_mailer'] as $type => $group) {
  552.             $settings['pimcore'][$type] = [
  553.                 'sender' => [
  554.                     'name' => $values[$type . '.sender.name'],
  555.                     'email' => $values[$type . '.sender.email'], ],
  556.                 'return' => [
  557.                     'name' => $values[$type . '.return.name'],
  558.                     'email' => $values[$type . '.return.email'], ],
  559.                 'method' => $values[$type . '.method'],
  560.             ];
  562.             $settings['swiftmailer']['mailers'][$group] = [
  563.                 'transport' => $values[$type . '.method'],
  564.                 'host' => $values[$type . '.smtp.host'],
  565.                 'username' => $values[$type . '.smtp.auth.username'],
  566.                 'port' => $values[$type . '.smtp.port'],
  567.                 'encryption' => $values[$type . '.smtp.ssl'] ? $values[$type . '.smtp.ssl'] : null,
  568.                 'auth_mode' => $values[$type . '.smtp.auth.method'] ? $values[$type . '.smtp.auth.method'] : null,
  569.             ];
  571.             $smtpPassword = $values[$type . '.smtp.auth.password'];
  572.             if ($smtpPassword !== '#####SUPER-SECRET-VALUE-PLACEHOLDER######') {
  573.                 if (!empty($smtpPassword)) {
  574.                     $settings['swiftmailer']['mailers'][$group]['password'] = $smtpPassword;
  575.                 } else {
  576.                     $settings['swiftmailer']['mailers'][$group]['password'] = null;
  577.                 }
  578.             }
  579.             if (array_key_exists('email.debug.emailAddresses', $values) && $values['email.debug.emailAddresses']) {
  580.                 $settings['swiftmailer']['mailers'][$group]['delivery_addresses'] = [$values['email.debug.emailAddresses']];
  581.                 $settings['pimcore'][$type]['debug']['email_addresses'] = $values['email.debug.emailAddresses'];
  582.             } else {
  583.                 $settings['swiftmailer']['mailers'][$group]['delivery_addresses'] = [];
  584.                 $settings['pimcore'][$type]['debug']['email_addresses'] = null;
  585.             }
  586.         }
  587.         $settings['pimcore']['newsletter']['use_specific'] = $values['newsletter.usespecific'];
  589.         $settings = array_replace_recursive($existingValues, $settings);
  591.         $settingsYml = Yaml::dump($settings, 5);
  592.         $configFile = Config::locateConfigFile('system.yml');
  593.         File::put($configFile, $settingsYml);
  595.         $debugModeFile = PIMCORE_CONFIGURATION_DIRECTORY . '/debug-mode.php';
  596.         File::putPhpFile($debugModeFile, to_php_data_file_format([
  597.             'active' => $values['general.debug'],
  598.             'ip' => $values['general.debug_ip'],
  599.             'devmode' => $values['general.devmode'],
  600.         ]));
  602.         // clear all caches
  603.         $this->forward(self::class . '::clearCacheAction', [
  604.             'only_symfony_cache' => false,
  605.             'only_pimcore_cache' => false,
  606.             'env' => [\Pimcore::getKernel()->getEnvironment()],
  607.         ]);
  609.         return $this->adminJson(['success' => true]);
  610.     }
  612.     /**
  613.      * @param string $source
  614.      * @param array $definitions
  615.      * @param array $fallbacks
  616.      *
  617.      * @throws \Exception
  618.      */
  619.     protected function checkFallbackLanguageLoop($source, $definitions, $fallbacks = [])
  620.     {
  621.         if (isset($definitions[$source])) {
  622.             $targets = explode(',', $definitions[$source]);
  623.             foreach ($targets as $l) {
  624.                 $target = trim($l);
  625.                 if ($target) {
  626.                     if (in_array($target, $fallbacks)) {
  627.                         throw new \Exception("Language `$source` | `$target` causes an infinte loop.");
  628.                     }
  629.                     $fallbacks[] = $target;
  631.                     $this->checkFallbackLanguageLoop($target, $definitions, $fallbacks);
  632.                 }
  633.             }
  634.         } else {
  635.             throw new \Exception("Language `$source` doesn't exist");
  636.         }
  637.     }
  639.     /**
  640.      * @Route("/get-web2print", name="pimcore_admin_settings_getweb2print", methods={"GET"})
  641.      *
  642.      * @param Request $request
  643.      *
  644.      * @return JsonResponse
  645.      */
  646.     public function getWeb2printAction(Request $request)
  647.     {
  648.         $this->checkPermission('web2print_settings');
  650.         $values = Config::getWeb2PrintConfig();
  651.         $valueArray = $values->toArray();
  653.         $optionsString = [];
  654.         if ($valueArray['wkhtml2pdfOptions']) {
  655.             foreach ($valueArray['wkhtml2pdfOptions'] as $key => $value) {
  656.                 $tmpStr = '--'.$key;
  657.                 if ($value !== null && $value !== '') {
  658.                     $tmpStr .= ' '.$value;
  659.                 }
  660.                 $optionsString[] = $tmpStr;
  661.             }
  662.         }
  663.         $valueArray['wkhtml2pdfOptions'] = implode("\n", $optionsString);
  665.         $response = [
  666.             'values' => $valueArray,
  667.         ];
  669.         return $this->adminJson($response);
  670.     }
  672.     /**
  673.      * @Route("/set-web2print", name="pimcore_admin_settings_setweb2print", methods={"PUT"})
  674.      *
  675.      * @param Request $request
  676.      *
  677.      * @return JsonResponse
  678.      */
  679.     public function setWeb2printAction(Request $request)
  680.     {
  681.         $this->checkPermission('web2print_settings');
  683.         $values = $this->decodeJson($request->get('data'));
  685.         if ($values['wkhtml2pdfOptions']) {
  686.             $optionArray = [];
  687.             $lines = explode("\n", $values['wkhtml2pdfOptions']);
  688.             foreach ($lines as $line) {
  689.                 $parts = explode(' ', substr($line, 2));
  690.                 $key = trim($parts[0]);
  691.                 if ($key) {
  692.                     $value = trim($parts[1] ?? '');
  693.                     $optionArray[$key] = $value;
  694.                 }
  695.             }
  696.             $values['wkhtml2pdfOptions'] = $optionArray;
  697.         }
  699.         $configFile = \Pimcore\Config::locateConfigFile('web2print.php');
  700.         File::putPhpFile($configFile, to_php_data_file_format($values));
  702.         return $this->adminJson(['success' => true]);
  703.     }
  705.     /**
  706.      * @Route("/clear-cache", name="pimcore_admin_settings_clearcache", methods={"DELETE"})
  707.      *
  708.      * @param Request $request
  709.      * @param KernelInterface $kernel
  710.      * @param EventDispatcherInterface $eventDispatcher
  711.      * @param CoreHandlerInterface $cache
  712.      * @param ConnectionInterface $db
  713.      * @param Filesystem $filesystem
  714.      * @param CacheClearer $symfonyCacheClearer
  715.      *
  716.      * @return JsonResponse
  717.      */
  718.     public function clearCacheAction(
  719.         Request $request,
  720.         KernelInterface $kernel,
  721.         EventDispatcherInterface $eventDispatcher,
  722.         CoreHandlerInterface $cache,
  723.         ConnectionInterface $db,
  724.         Filesystem $filesystem,
  725.         CacheClearer $symfonyCacheClearer
  726.     ) {
  727.         $this->checkPermissionsHasOneOf(['clear_cache', 'system_settings']);
  729.         $result = [
  730.             'success' => true,
  731.         ];
  733.         $clearPimcoreCache = !(bool)$request->get('only_symfony_cache');
  734.         $clearSymfonyCache = !(bool)$request->get('only_pimcore_cache');
  736.         if ($clearPimcoreCache) {
  737.             // empty document cache
  738.             $cache->clearAll();
  740.             $db->query('truncate table cache_tags');
  741.             $db->query('truncate table cache');
  743.             if ($filesystem->exists(PIMCORE_CACHE_DIRECTORY)) {
  744.                 $filesystem->remove(PIMCORE_CACHE_DIRECTORY);
  745.             }
  747.             // PIMCORE-1854 - recreate .dummy file => should remain
  748.             File::put(PIMCORE_CACHE_DIRECTORY . '/.gitkeep', '');
  750.             $eventDispatcher->dispatch(SystemEvents::CACHE_CLEAR);
  751.         }
  753.         if ($clearSymfonyCache) {
  754.             // pass one or move env parameters to clear multiple envs
  755.             // if no env is passed it will use the current one
  756.             $environments = $request->get('env', $kernel->getEnvironment());
  758.             if (!is_array($environments)) {
  759.                 $environments = trim((string)$environments);
  761.                 if (empty($environments)) {
  762.                     $environments = [];
  763.                 } else {
  764.                     $environments = [$environments];
  765.                 }
  766.             }
  768.             if (empty($environments)) {
  769.                 $environments = [$kernel->getEnvironment()];
  770.             }
  772.             $result['environments'] = $environments;
  774.             if (in_array($kernel->getEnvironment(), $environments)) {
  775.                 // remove terminate and exception event listeners for the current env as they break with a
  776.                 // cleared container - see #2434
  777.                 foreach ($eventDispatcher->getListeners(KernelEvents::TERMINATE) as $listener) {
  778.                     $eventDispatcher->removeListener(KernelEvents::TERMINATE, $listener);
  779.                 }
  781.                 foreach ($eventDispatcher->getListeners(KernelEvents::EXCEPTION) as $listener) {
  782.                     $eventDispatcher->removeListener(KernelEvents::EXCEPTION, $listener);
  783.                 }
  784.             }
  786.             foreach ($environments as $environment) {
  787.                 try {
  788.                     $symfonyCacheClearer->clear($environment);
  789.                 } catch (\Throwable $e) {
  790.                     $errors = $result['errors'] ?? [];
  791.                     $errors[] = $e->getMessage();
  793.                     $result = array_merge($result, [
  794.                         'success' => false,
  795.                         'errors' => $errors,
  796.                     ]);
  797.                 }
  798.             }
  799.         }
  801.         $response = new JsonResponse($result);
  803.         if ($clearSymfonyCache) {
  804.             // we send the response directly here and exit to make sure no code depending on the stale container
  805.             // is running after this
  806.             $response->sendHeaders();
  807.             $response->sendContent();
  808.             exit;
  809.         }
  811.         return $response;
  812.     }
  814.     /**
  815.      * @Route("/clear-output-cache", name="pimcore_admin_settings_clearoutputcache", methods={"DELETE"})
  816.      *
  817.      * @param EventDispatcherInterface $eventDispatcher
  818.      *
  819.      * @return JsonResponse
  820.      */
  821.     public function clearOutputCacheAction(EventDispatcherInterface $eventDispatcher)
  822.     {
  823.         $this->checkPermission('clear_fullpage_cache');
  825.         // remove "output" out of the ignored tags, if a cache lifetime is specified
  826.         Cache::removeIgnoredTagOnClear('output');
  828.         // empty document cache
  829.         Cache::clearTags(['output', 'output_lifetime']);
  831.         $eventDispatcher->dispatch(SystemEvents::CACHE_CLEAR_FULLPAGE_CACHE);
  833.         return $this->adminJson(['success' => true]);
  834.     }
  836.     /**
  837.      * @Route("/clear-temporary-files", name="pimcore_admin_settings_cleartemporaryfiles", methods={"DELETE"})
  838.      *
  839.      * @param EventDispatcherInterface $eventDispatcher
  840.      *
  841.      * @return JsonResponse
  842.      */
  843.     public function clearTemporaryFilesAction(EventDispatcherInterface $eventDispatcher)
  844.     {
  845.         $this->checkPermission('clear_temp_files');
  847.         // public files
  848.         recursiveDelete(PIMCORE_TEMPORARY_DIRECTORY, false);
  850.         // system files
  851.         recursiveDelete(PIMCORE_SYSTEM_TEMP_DIRECTORY, false);
  853.         // recreate .dummy files # PIMCORE-2629
  854.         File::put(PIMCORE_TEMPORARY_DIRECTORY . '/.dummy', '');
  855.         File::put(PIMCORE_SYSTEM_TEMP_DIRECTORY . '/.dummy', '');
  857.         $eventDispatcher->dispatch(SystemEvents::CACHE_CLEAR_TEMPORARY_FILES);
  859.         return $this->adminJson(['success' => true]);
  860.     }
  862.     /**
  863.      * @Route("/staticroutes", name="pimcore_admin_settings_staticroutes", methods={"POST"})
  864.      *
  865.      * @param Request $request
  866.      *
  867.      * @return JsonResponse
  868.      */
  869.     public function staticroutesAction(Request $request)
  870.     {
  871.         if ($request->get('data')) {
  872.             $this->checkPermission('routes');
  874.             $data = $this->decodeJson($request->get('data'));
  876.             if (is_array($data)) {
  877.                 foreach ($data as &$value) {
  878.                     if (is_string($value)) {
  879.                         $value = trim($value);
  880.                     }
  881.                 }
  882.             }
  884.             if ($request->get('xaction') == 'destroy') {
  885.                 $data = $this->decodeJson($request->get('data'));
  886.                 $id = $data['id'];
  887.                 $route = Staticroute::getById($id);
  888.                 $route->delete();
  890.                 return $this->adminJson(['success' => true, 'data' => []]);
  891.             } elseif ($request->get('xaction') == 'update') {
  892.                 // save routes
  893.                 $route = Staticroute::getById($data['id']);
  894.                 $route->setValues($data);
  896.                 $route->save();
  898.                 return $this->adminJson(['data' => $route, 'success' => true]);
  899.             } elseif ($request->get('xaction') == 'create') {
  900.                 unset($data['id']);
  902.                 // save route
  903.                 $route = new Staticroute();
  904.                 $route->setValues($data);
  906.                 $route->save();
  908.                 return $this->adminJson(['data' => $route, 'success' => true]);
  909.             }
  910.         } else {
  911.             // get list of routes
  913.             $list = new Staticroute\Listing();
  915.             if ($request->get('filter')) {
  916.                 $filter = $request->get('filter');
  917.                 $list->setFilter(function ($row) use ($filter) {
  918.                     foreach ($row as $value) {
  919.                         if (! is_scalar($value)) {
  920.                             continue;
  921.                         }
  922.                         if (strpos((string)$value, $filter) !== false) {
  923.                             return true;
  924.                         }
  925.                     }
  927.                     return false;
  928.                 });
  929.             }
  931.             $list->load();
  933.             $routes = [];
  934.             /** @var Staticroute $route */
  935.             foreach ($list->getRoutes() as $route) {
  936.                 if (is_array($route->getSiteId())) {
  937.                     $route = json_encode($route);
  938.                     $route = json_decode($route, true);
  939.                     $route['siteId'] = implode(',', $route['siteId']);
  940.                 }
  941.                 $routes[] = $route;
  942.             }
  944.             return $this->adminJson(['data' => $routes, 'success' => true, 'total' => $list->getTotalCount()]);
  945.         }
  947.         return $this->adminJson(['success' => false]);
  948.     }
  950.     /**
  951.      * @Route("/get-available-admin-languages", name="pimcore_admin_settings_getavailableadminlanguages", methods={"GET"})
  952.      *
  953.      * @param Request $request
  954.      *
  955.      * @return JsonResponse
  956.      */
  957.     public function getAvailableAdminLanguagesAction(Request $request)
  958.     {
  959.         $langs = [];
  960.         $availableLanguages = Tool\Admin::getLanguages();
  961.         $locales = Tool::getSupportedLocales();
  963.         foreach ($availableLanguages as $lang) {
  964.             if (array_key_exists($lang, $locales)) {
  965.                 $langs[] = [
  966.                     'language' => $lang,
  967.                     'display' => $locales[$lang],
  968.                 ];
  969.             }
  970.         }
  972.         usort($langs, function ($a, $b) {
  973.             return strcmp($a['display'], $b['display']);
  974.         });
  976.         return $this->adminJson($langs);
  977.     }
  979.     /**
  980.      * @Route("/glossary", name="pimcore_admin_settings_glossary", methods={"POST"})
  981.      *
  982.      * @param Request $request
  983.      *
  984.      * @return JsonResponse
  985.      */
  986.     public function glossaryAction(Request $request)
  987.     {
  988.         if ($request->get('data')) {
  989.             $this->checkPermission('glossary');
  991.             Cache::clearTag('glossary');
  993.             if ($request->get('xaction') == 'destroy') {
  994.                 $data = $this->decodeJson($request->get('data'));
  995.                 $id = $data['id'];
  996.                 $glossary = Glossary::getById($id);
  997.                 $glossary->delete();
  999.                 return $this->adminJson(['success' => true, 'data' => []]);
  1000.             } elseif ($request->get('xaction') == 'update') {
  1001.                 $data = $this->decodeJson($request->get('data'));
  1003.                 // save glossary
  1004.                 $glossary = Glossary::getById($data['id']);
  1006.                 if ($data['link']) {
  1007.                     if ($doc = Document::getByPath($data['link'])) {
  1008.                         $data['link'] = $doc->getId();
  1009.                     }
  1010.                 }
  1012.                 $glossary->setValues($data);
  1014.                 $glossary->save();
  1016.                 if ($link = $glossary->getLink()) {
  1017.                     if (intval($link) > 0) {
  1018.                         if ($doc = Document::getById(intval($link))) {
  1019.                             $glossary->setLink($doc->getRealFullPath());
  1020.                         }
  1021.                     }
  1022.                 }
  1024.                 return $this->adminJson(['data' => $glossary, 'success' => true]);
  1025.             } elseif ($request->get('xaction') == 'create') {
  1026.                 $data = $this->decodeJson($request->get('data'));
  1027.                 unset($data['id']);
  1029.                 // save glossary
  1030.                 $glossary = new Glossary();
  1032.                 if ($data['link']) {
  1033.                     if ($doc = Document::getByPath($data['link'])) {
  1034.                         $data['link'] = $doc->getId();
  1035.                     }
  1036.                 }
  1038.                 $glossary->setValues($data);
  1040.                 $glossary->save();
  1042.                 if ($link = $glossary->getLink()) {
  1043.                     if (intval($link) > 0) {
  1044.                         if ($doc = Document::getById(intval($link))) {
  1045.                             $glossary->setLink($doc->getRealFullPath());
  1046.                         }
  1047.                     }
  1048.                 }
  1050.                 return $this->adminJson(['data' => $glossary, 'success' => true]);
  1051.             }
  1052.         } else {
  1053.             // get list of glossaries
  1055.             $list = new Glossary\Listing();
  1056.             $list->setLimit($request->get('limit'));
  1057.             $list->setOffset($request->get('start'));
  1059.             $sortingSettings = \Pimcore\Bundle\AdminBundle\Helper\QueryParams::extractSortingSettings(array_merge($request->request->all(), $request->query->all()));
  1060.             if ($sortingSettings['orderKey']) {
  1061.                 $list->setOrderKey($sortingSettings['orderKey']);
  1062.                 $list->setOrder($sortingSettings['order']);
  1063.             }
  1065.             if ($request->get('filter')) {
  1066.                 $list->setCondition('`text` LIKE ' . $list->quote('%'.$request->get('filter').'%'));
  1067.             }
  1069.             $list->load();
  1071.             $glossaries = [];
  1072.             foreach ($list->getGlossary() as $glossary) {
  1073.                 if ($link = $glossary->getLink()) {
  1074.                     if (intval($link) > 0) {
  1075.                         if ($doc = Document::getById(intval($link))) {
  1076.                             $glossary->setLink($doc->getRealFullPath());
  1077.                         }
  1078.                     }
  1079.                 }
  1081.                 $glossaries[] = $glossary;
  1082.             }
  1084.             return $this->adminJson(['data' => $glossaries, 'success' => true, 'total' => $list->getTotalCount()]);
  1085.         }
  1087.         return $this->adminJson(['success' => false]);
  1088.     }
  1090.     /**
  1091.      * @Route("/get-available-sites", name="pimcore_admin_settings_getavailablesites", methods={"GET"})
  1092.      *
  1093.      * @param Request $request
  1094.      *
  1095.      * @return JsonResponse
  1096.      */
  1097.     public function getAvailableSitesAction(Request $request)
  1098.     {
  1099.         $excludeMainSite = $request->get('excludeMainSite');
  1101.         $sitesList = new Model\Site\Listing();
  1102.         $sitesObjects = $sitesList->load();
  1103.         $sites = [];
  1104.         if (!$excludeMainSite) {
  1105.             $sites[] = [
  1106.                 'id' => 'default',
  1107.                 'rootId' => 1,
  1108.                 'domains' => '',
  1109.                 'rootPath' => '/',
  1110.                 'domain' => $this->trans('main_site'),
  1111.             ];
  1112.         }
  1114.         foreach ($sitesObjects as $site) {
  1115.             if ($site->getRootDocument()) {
  1116.                 if ($site->getMainDomain()) {
  1117.                     $sites[] = [
  1118.                         'id' => $site->getId(),
  1119.                         'rootId' => $site->getRootId(),
  1120.                         'domains' => implode(',', $site->getDomains()),
  1121.                         'rootPath' => $site->getRootPath(),
  1122.                         'domain' => $site->getMainDomain(),
  1123.                     ];
  1124.                 }
  1125.             } else {
  1126.                 // site is useless, parent doesn't exist anymore
  1127.                 $site->delete();
  1128.             }
  1129.         }
  1131.         return $this->adminJson($sites);
  1132.     }
  1134.     /**
  1135.      * @Route("/get-available-countries", name="pimcore_admin_settings_getavailablecountries", methods={"GET"})
  1136.      *
  1137.      * @param LocaleServiceInterface $localeService
  1138.      *
  1139.      * @return JsonResponse
  1140.      */
  1141.     public function getAvailableCountriesAction(LocaleServiceInterface $localeService)
  1142.     {
  1143.         $countries = $localeService->getDisplayRegions();
  1144.         asort($countries);
  1146.         $options = [];
  1148.         foreach ($countries as $short => $translation) {
  1149.             if (strlen($short) == 2) {
  1150.                 $options[] = [
  1151.                     'key' => $translation . ' (' . $short . ')',
  1152.                     'value' => $short,
  1153.                 ];
  1154.             }
  1155.         }
  1157.         $result = ['data' => $options, 'success' => true, 'total' => count($options)];
  1159.         return $this->adminJson($result);
  1160.     }
  1162.     /**
  1163.      * @Route("/thumbnail-adapter-check", name="pimcore_admin_settings_thumbnailadaptercheck", methods={"GET"})
  1164.      *
  1165.      * @param Request $request
  1166.      *
  1167.      * @return Response
  1168.      */
  1169.     public function thumbnailAdapterCheckAction(Request $request)
  1170.     {
  1171.         $content = '';
  1173.         $instance = \Pimcore\Image::getInstance();
  1174.         if ($instance instanceof \Pimcore\Image\Adapter\GD) {
  1175.             $content = '<span style="color: red; font-weight: bold;padding: 10px;margin:0 0 20px 0;border:1px solid red;display:block;">' .
  1176.                 $this->trans('important_use_imagick_pecl_extensions_for_best_results_gd_is_just_a_fallback_with_less_quality') .
  1177.                 '</span>';
  1178.         }
  1180.         return new Response($content);
  1181.     }
  1183.     /**
  1184.      * @Route("/thumbnail-tree", name="pimcore_admin_settings_thumbnailtree", methods={"GET", "POST"})
  1185.      *
  1186.      * @param Request $request
  1187.      *
  1188.      * @return JsonResponse
  1189.      */
  1190.     public function thumbnailTreeAction(Request $request)
  1191.     {
  1192.         $this->checkPermission('thumbnails');
  1194.         $thumbnails = [];
  1196.         $list = new Asset\Image\Thumbnail\Config\Listing();
  1197.         $items = $list->getThumbnails();
  1199.         $groups = [];
  1200.         /** @var Asset\Image\Thumbnail\Config $item */
  1201.         foreach ($items as $item) {
  1202.             if ($item->getGroup()) {
  1203.                 if (empty($groups[$item->getGroup()])) {
  1204.                     $groups[$item->getGroup()] = [
  1205.                         'id' => 'group_' . $item->getName(),
  1206.                         'text' => $item->getGroup(),
  1207.                         'expandable' => true,
  1208.                         'leaf' => false,
  1209.                         'allowChildren' => true,
  1210.                         'iconCls' => 'pimcore_icon_folder',
  1211.                         'group' => $item->getGroup(),
  1212.                         'children' => [],
  1213.                         ];
  1214.                 }
  1215.                 $groups[$item->getGroup()]['children'][] =
  1216.                     [
  1217.                         'id' => $item->getName(),
  1218.                         'text' => $item->getName(),
  1219.                         'leaf' => true,
  1220.                         'iconCls' => 'pimcore_icon_thumbnails',
  1221.                     ];
  1222.             } else {
  1223.                 $thumbnails[] = [
  1224.                     'id' => $item->getName(),
  1225.                     'text' => $item->getName(),
  1226.                     'leaf' => true,
  1227.                     'iconCls' => 'pimcore_icon_thumbnails',
  1228.                 ];
  1229.             }
  1230.         }
  1232.         foreach ($groups as $group) {
  1233.             $thumbnails[] = $group;
  1234.         }
  1236.         return $this->adminJson($thumbnails);
  1237.     }
  1239.     /**
  1240.      * @Route("/thumbnail-downloadable", name="pimcore_admin_settings_thumbnaildownloadable", methods={"GET"})
  1241.      *
  1242.      * @param Request $request
  1243.      *
  1244.      * @return JsonResponse
  1245.      */
  1246.     public function thumbnailDownloadableAction(Request $request)
  1247.     {
  1248.         $thumbnails = [];
  1250.         $list = new Asset\Image\Thumbnail\Config\Listing();
  1251.         $list->setFilter(function (array $config) {
  1252.             return array_key_exists('downloadable', $config) ? $config['downloadable'] : false;
  1253.         });
  1254.         $items = $list->getThumbnails();
  1256.         /** @var Asset\Image\Thumbnail\Config $item */
  1257.         foreach ($items as $item) {
  1258.             $thumbnails[] = [
  1259.                 'id' => $item->getName(),
  1260.                 'text' => $item->getName(),
  1261.             ];
  1262.         }
  1264.         return $this->adminJson($thumbnails);
  1265.     }
  1267.     /**
  1268.      * @Route("/thumbnail-add", name="pimcore_admin_settings_thumbnailadd", methods={"POST"})
  1269.      *
  1270.      * @param Request $request
  1271.      *
  1272.      * @return JsonResponse
  1273.      */
  1274.     public function thumbnailAddAction(Request $request)
  1275.     {
  1276.         $this->checkPermission('thumbnails');
  1278.         $success = false;
  1280.         $pipe = Asset\Image\Thumbnail\Config::getByName($request->get('name'));
  1282.         if (!$pipe) {
  1283.             $pipe = new Asset\Image\Thumbnail\Config();
  1284.             $pipe->setName($request->get('name'));
  1285.             $pipe->save();
  1287.             $success = true;
  1288.         }
  1290.         return $this->adminJson(['success' => $success, 'id' => $pipe->getName()]);
  1291.     }
  1293.     /**
  1294.      * @Route("/thumbnail-delete", name="pimcore_admin_settings_thumbnaildelete", methods={"DELETE"})
  1295.      *
  1296.      * @param Request $request
  1297.      *
  1298.      * @return JsonResponse
  1299.      */
  1300.     public function thumbnailDeleteAction(Request $request)
  1301.     {
  1302.         $this->checkPermission('thumbnails');
  1304.         $pipe = Asset\Image\Thumbnail\Config::getByName($request->get('name'));
  1305.         $pipe->delete();
  1307.         return $this->adminJson(['success' => true]);
  1308.     }
  1310.     /**
  1311.      * @Route("/thumbnail-get", name="pimcore_admin_settings_thumbnailget", methods={"GET"})
  1312.      *
  1313.      * @param Request $request
  1314.      *
  1315.      * @return JsonResponse
  1316.      */
  1317.     public function thumbnailGetAction(Request $request)
  1318.     {
  1319.         $this->checkPermission('thumbnails');
  1321.         $pipe = Asset\Image\Thumbnail\Config::getByName($request->get('name'));
  1323.         return $this->adminJson($pipe);
  1324.     }
  1326.     /**
  1327.      * @Route("/thumbnail-update", name="pimcore_admin_settings_thumbnailupdate", methods={"PUT"})
  1328.      *
  1329.      * @param Request $request
  1330.      *
  1331.      * @return JsonResponse
  1332.      */
  1333.     public function thumbnailUpdateAction(Request $request)
  1334.     {
  1335.         $this->checkPermission('thumbnails');
  1337.         $pipe = Asset\Image\Thumbnail\Config::getByName($request->get('name'));
  1338.         $settingsData = $this->decodeJson($request->get('settings'));
  1339.         $mediaData = $this->decodeJson($request->get('medias'));
  1340.         $mediaOrder = $this->decodeJson($request->get('mediaOrder'));
  1342.         foreach ($settingsData as $key => $value) {
  1343.             $setter = 'set' . ucfirst($key);
  1344.             if (method_exists($pipe, $setter)) {
  1345.                 $pipe->$setter($value);
  1346.             }
  1347.         }
  1349.         $pipe->resetItems();
  1351.         uksort($mediaData, function ($a, $b) use ($mediaOrder) {
  1352.             if ($a === 'default') {
  1353.                 return -1;
  1354.             }
  1356.             return ($mediaOrder[$a] < $mediaOrder[$b]) ? -1 : 1;
  1357.         });
  1359.         foreach ($mediaData as $mediaName => $items) {
  1360.             foreach ($items as $item) {
  1361.                 $type = $item['type'];
  1362.                 unset($item['type']);
  1364.                 $pipe->addItem($type, $item, $mediaName);
  1365.             }
  1366.         }
  1368.         $pipe->save();
  1370.         return $this->adminJson(['success' => true]);
  1371.     }
  1373.     /**
  1374.      * @Route("/video-thumbnail-adapter-check", name="pimcore_admin_settings_videothumbnailadaptercheck", methods={"GET"})
  1375.      *
  1376.      * @param Request $request
  1377.      *
  1378.      * @return Response
  1379.      */
  1380.     public function videoThumbnailAdapterCheckAction(Request $request)
  1381.     {
  1382.         $content = '';
  1384.         if (!\Pimcore\Video::isAvailable()) {
  1385.             $content = '<span style="color: red; font-weight: bold;padding: 10px;margin:0 0 20px 0;border:1px solid red;display:block;">' .
  1386.                 $this->trans('php_cli_binary_and_or_ffmpeg_binary_setting_is_missing') .
  1387.                 '</span>';
  1388.         }
  1390.         return new Response($content);
  1391.     }
  1393.     /**
  1394.      * @Route("/video-thumbnail-tree", name="pimcore_admin_settings_videothumbnailtree", methods={"GET", "POST"})
  1395.      *
  1396.      * @param Request $request
  1397.      *
  1398.      * @return JsonResponse
  1399.      */
  1400.     public function videoThumbnailTreeAction(Request $request)
  1401.     {
  1402.         $this->checkPermission('thumbnails');
  1404.         $thumbnails = [];
  1406.         $list = new Asset\Video\Thumbnail\Config\Listing();
  1407.         $items = $list->getThumbnails();
  1409.         $groups = [];
  1410.         /** @var Asset\Image\Thumbnail\Config $item */
  1411.         foreach ($items as $item) {
  1412.             if ($item->getGroup()) {
  1413.                 if (!$groups[$item->getGroup()]) {
  1414.                     $groups[$item->getGroup()] = [
  1415.                         'id' => 'group_' . $item->getName(),
  1416.                         'text' => $item->getGroup(),
  1417.                         'expandable' => true,
  1418.                         'leaf' => false,
  1419.                         'allowChildren' => true,
  1420.                         'iconCls' => 'pimcore_icon_folder',
  1421.                         'group' => $item->getGroup(),
  1422.                         'children' => [],
  1423.                     ];
  1424.                 }
  1425.                 $groups[$item->getGroup()]['children'][] =
  1426.                     [
  1427.                         'id' => $item->getName(),
  1428.                         'text' => $item->getName(),
  1429.                         'leaf' => true,
  1430.                         'iconCls' => 'pimcore_icon_videothumbnails',
  1431.                     ];
  1432.             } else {
  1433.                 $thumbnails[] = [
  1434.                     'id' => $item->getName(),
  1435.                     'text' => $item->getName(),
  1436.                     'leaf' => true,
  1437.                     'iconCls' => 'pimcore_icon_videothumbnails',
  1438.                 ];
  1439.             }
  1440.         }
  1442.         foreach ($groups as $group) {
  1443.             $thumbnails[] = $group;
  1444.         }
  1446.         return $this->adminJson($thumbnails);
  1447.     }
  1449.     /**
  1450.      * @Route("/video-thumbnail-add", name="pimcore_admin_settings_videothumbnailadd", methods={"POST"})
  1451.      *
  1452.      * @param Request $request
  1453.      *
  1454.      * @return JsonResponse
  1455.      */
  1456.     public function videoThumbnailAddAction(Request $request)
  1457.     {
  1458.         $this->checkPermission('thumbnails');
  1460.         $success = false;
  1462.         $pipe = Asset\Video\Thumbnail\Config::getByName($request->get('name'));
  1464.         if (!$pipe) {
  1465.             $pipe = new Asset\Video\Thumbnail\Config();
  1466.             $pipe->setName($request->get('name'));
  1467.             $pipe->save();
  1469.             $success = true;
  1470.         }
  1472.         return $this->adminJson(['success' => $success, 'id' => $pipe->getName()]);
  1473.     }
  1475.     /**
  1476.      * @Route("/video-thumbnail-delete", name="pimcore_admin_settings_videothumbnaildelete", methods={"DELETE"})
  1477.      *
  1478.      * @param Request $request
  1479.      *
  1480.      * @return JsonResponse
  1481.      */
  1482.     public function videoThumbnailDeleteAction(Request $request)
  1483.     {
  1484.         $this->checkPermission('thumbnails');
  1486.         $pipe = Asset\Video\Thumbnail\Config::getByName($request->get('name'));
  1487.         $pipe->delete();
  1489.         return $this->adminJson(['success' => true]);
  1490.     }
  1492.     /**
  1493.      * @Route("/video-thumbnail-get", name="pimcore_admin_settings_videothumbnailget", methods={"GET"})
  1494.      *
  1495.      * @param Request $request
  1496.      *
  1497.      * @return JsonResponse
  1498.      */
  1499.     public function videoThumbnailGetAction(Request $request)
  1500.     {
  1501.         $this->checkPermission('thumbnails');
  1503.         $pipe = Asset\Video\Thumbnail\Config::getByName($request->get('name'));
  1505.         return $this->adminJson($pipe);
  1506.     }
  1508.     /**
  1509.      * @Route("/video-thumbnail-update", name="pimcore_admin_settings_videothumbnailupdate", methods={"PUT"})
  1510.      *
  1511.      * @param Request $request
  1512.      *
  1513.      * @return JsonResponse
  1514.      */
  1515.     public function videoThumbnailUpdateAction(Request $request)
  1516.     {
  1517.         $this->checkPermission('thumbnails');
  1519.         $pipe = Asset\Video\Thumbnail\Config::getByName($request->get('name'));
  1520.         $data = $this->decodeJson($request->get('configuration'));
  1522.         $items = [];
  1523.         foreach ($data as $key => $value) {
  1524.             $setter = 'set' . ucfirst($key);
  1525.             if (method_exists($pipe, $setter)) {
  1526.                 $pipe->$setter($value);
  1527.             }
  1529.             if (strpos($key, 'item.') === 0) {
  1530.                 $cleanKeyParts = explode('.', $key);
  1531.                 $items[$cleanKeyParts[1]][$cleanKeyParts[2]] = $value;
  1532.             }
  1533.         }
  1535.         $pipe->resetItems();
  1536.         foreach ($items as $item) {
  1537.             $type = $item['type'];
  1538.             unset($item['type']);
  1540.             $pipe->addItem($type, $item);
  1541.         }
  1543.         $pipe->save();
  1545.         return $this->adminJson(['success' => true]);
  1546.     }
  1548.     /**
  1549.      * @Route("/robots-txt", name="pimcore_admin_settings_robotstxtget", methods={"GET"})
  1550.      *
  1551.      * @return JsonResponse
  1552.      */
  1553.     public function robotsTxtGetAction()
  1554.     {
  1555.         $this->checkPermission('robots.txt');
  1557.         $config = Config::getRobotsConfig();
  1558.         $config = $config->toArray();
  1560.         return $this->adminJson([
  1561.             'success' => true,
  1562.             'data' => $config,
  1563.             'onFileSystem' => file_exists(PIMCORE_WEB_ROOT . '/robots.txt'),
  1564.         ]);
  1565.     }
  1567.     /**
  1568.      * @Route("/robots-txt", name="pimcore_admin_settings_robotstxtput", methods={"PUT"})
  1569.      *
  1570.      * @param Request $request
  1571.      *
  1572.      * @return JsonResponse
  1573.      */
  1574.     public function robotsTxtPutAction(Request $request)
  1575.     {
  1576.         $this->checkPermission('robots.txt');
  1578.         $values = $request->get('data');
  1579.         if (!is_array($values)) {
  1580.             $values = [];
  1581.         }
  1583.         File::putPhpFile(
  1584.             Config::locateConfigFile('robots.php'),
  1585.             to_php_data_file_format($values)
  1586.         );
  1588.         return $this->adminJson([
  1589.             'success' => true,
  1590.         ]);
  1591.     }
  1593.     /**
  1594.      * @Route("/tag-management-tree", name="pimcore_admin_settings_tagmanagementtree", methods={"GET", "POST"})
  1595.      *
  1596.      * @param Request $request
  1597.      *
  1598.      * @return JsonResponse
  1599.      */
  1600.     public function tagManagementTreeAction(Request $request)
  1601.     {
  1602.         $this->checkPermission('tag_snippet_management');
  1604.         $tags = [];
  1606.         $list = new Tag\Config\Listing();
  1607.         $items = $list->load();
  1609.         foreach ($items as $item) {
  1610.             $tags[] = [
  1611.                 'id' => $item->getName(),
  1612.                 'text' => $item->getName(),
  1613.             ];
  1614.         }
  1616.         return $this->adminJson($tags);
  1617.     }
  1619.     /**
  1620.      * @Route("/tag-management-add", name="pimcore_admin_settings_tagmanagementadd", methods={"POST"})
  1621.      *
  1622.      * @param Request $request
  1623.      *
  1624.      * @return JsonResponse
  1625.      */
  1626.     public function tagManagementAddAction(Request $request)
  1627.     {
  1628.         $this->checkPermission('tag_snippet_management');
  1630.         $success = false;
  1632.         $tag = Model\Tool\Tag\Config::getByName($request->get('name'));
  1634.         if (!$tag) {
  1635.             $tag = new Model\Tool\Tag\Config();
  1636.             $tag->setName($request->get('name'));
  1637.             $tag->save();
  1639.             $success = true;
  1640.         }
  1642.         return $this->adminJson(['success' => $success, 'id' => $tag->getName()]);
  1643.     }
  1645.     /**
  1646.      * @Route("/tag-management-delete", name="pimcore_admin_settings_tagmanagementdelete", methods={"DELETE"})
  1647.      *
  1648.      * @param Request $request
  1649.      *
  1650.      * @return JsonResponse
  1651.      */
  1652.     public function tagManagementDeleteAction(Request $request)
  1653.     {
  1654.         $this->checkPermission('tag_snippet_management');
  1656.         $tag = Model\Tool\Tag\Config::getByName($request->get('name'));
  1657.         $tag->delete();
  1659.         return $this->adminJson(['success' => true]);
  1660.     }
  1662.     /**
  1663.      * @Route("/tag-management-get", name="pimcore_admin_settings_tagmanagementget", methods={"GET"})
  1664.      *
  1665.      * @param Request $request
  1666.      *
  1667.      * @return JsonResponse
  1668.      */
  1669.     public function tagManagementGetAction(Request $request)
  1670.     {
  1671.         $this->checkPermission('tag_snippet_management');
  1673.         $tag = Model\Tool\Tag\Config::getByName($request->get('name'));
  1675.         return $this->adminJson($tag);
  1676.     }
  1678.     /**
  1679.      * @Route("/tag-management-update", name="pimcore_admin_settings_tagmanagementupdate", methods={"PUT"})
  1680.      *
  1681.      * @param Request $request
  1682.      *
  1683.      * @return JsonResponse
  1684.      */
  1685.     public function tagManagementUpdateAction(Request $request)
  1686.     {
  1687.         $this->checkPermission('tag_snippet_management');
  1689.         $tag = Model\Tool\Tag\Config::getByName($request->get('name'));
  1690.         $data = $this->decodeJson($request->get('configuration'));
  1692.         $items = [];
  1693.         foreach ($data as $key => $value) {
  1694.             $setter = 'set' . ucfirst($key);
  1695.             if (method_exists($tag, $setter)) {
  1696.                 $tag->$setter($value);
  1697.             }
  1699.             if (strpos($key, 'item.') === 0) {
  1700.                 $cleanKeyParts = explode('.', $key);
  1702.                 if ($cleanKeyParts[2] == 'date') {
  1703.                     $date = $value;
  1704.                     $value = null;
  1706.                     if (!empty($date) && !empty($data[$cleanKeyParts[0].'.'.$cleanKeyParts[1].'.time'])) {
  1707.                         $time = $data[$cleanKeyParts[0].'.'.$cleanKeyParts[1].'.time'];
  1708.                         $time = explode('T', $time);
  1709.                         $date = explode('T', $date);
  1710.                         $value = strtotime($date[0].'T'.$time[1]);
  1711.                     }
  1712.                 } elseif ($cleanKeyParts[2] == 'time') {
  1713.                     continue;
  1714.                 }
  1716.                 $items[$cleanKeyParts[1]][$cleanKeyParts[2]] = $value;
  1717.             }
  1718.         }
  1720.         $tag->resetItems();
  1721.         foreach ($items as $item) {
  1722.             $tag->addItem($item);
  1723.         }
  1725.         // parameters get/post
  1726.         $params = [];
  1727.         for ($i = 0; $i < 5; $i++) {
  1728.             $params[] = [
  1729.                 'name' => $data['params.name' . $i],
  1730.                 'value' => $data['params.value' . $i],
  1731.             ];
  1732.         }
  1733.         $tag->setParams($params);
  1735.         if ($request->get('name') != $data['name']) {
  1736.             $tag->setName($request->get('name')); // set the old name again, so that the old file get's deleted
  1737.             $tag->delete(); // delete the old config / file
  1738.             $tag->setName($data['name']);
  1739.         }
  1741.         $tag->save();
  1743.         return $this->adminJson(['success' => true]);
  1744.     }
  1746.     /**
  1747.      * @Route("/website-settings", name="pimcore_admin_settings_websitesettings", methods={"POST"})
  1748.      *
  1749.      * @param Request $request
  1750.      *
  1751.      * @return JsonResponse
  1752.      *
  1753.      * @throws \Exception
  1754.      */
  1755.     public function websiteSettingsAction(Request $request)
  1756.     {
  1757.         if ($request->get('data')) {
  1758.             $this->checkPermission('website_settings');
  1760.             $data = $this->decodeJson($request->get('data'));
  1762.             if (is_array($data)) {
  1763.                 foreach ($data as &$value) {
  1764.                     $value = trim($value);
  1765.                 }
  1766.             }
  1768.             if ($request->get('xaction') == 'destroy') {
  1769.                 $id = $data['id'];
  1770.                 $setting = WebsiteSetting::getById($id);
  1771.                 if ($setting instanceof WebsiteSetting) {
  1772.                     $setting->delete();
  1774.                     return $this->adminJson(['success' => true, 'data' => []]);
  1775.                 }
  1776.             } elseif ($request->get('xaction') == 'update') {
  1777.                 // save routes
  1778.                 $setting = WebsiteSetting::getById($data['id']);
  1779.                 if ($setting instanceof WebsiteSetting) {
  1780.                     switch ($setting->getType()) {
  1781.                         case 'document':
  1782.                         case 'asset':
  1783.                         case 'object':
  1784.                             if (isset($data['data'])) {
  1785.                                 $element = Element\Service::getElementByPath($setting->getType(), $data['data']);
  1786.                                 $data['data'] = $element;
  1787.                             }
  1788.                             break;
  1789.                     }
  1791.                     $setting->setValues($data);
  1792.                     $setting->save();
  1794.                     $data = $this->getWebsiteSettingForEditMode($setting);
  1796.                     return $this->adminJson(['data' => $data, 'success' => true]);
  1797.                 }
  1798.             } elseif ($request->get('xaction') == 'create') {
  1799.                 unset($data['id']);
  1801.                 // save route
  1802.                 $setting = new WebsiteSetting();
  1803.                 $setting->setValues($data);
  1805.                 $setting->save();
  1807.                 return $this->adminJson(['data' => $setting->getObjectVars(), 'success' => true]);
  1808.             }
  1809.         } else {
  1810.             // get list of routes
  1812.             $list = new WebsiteSetting\Listing();
  1814.             $limit = $request->get('limit');
  1815.             $start = $request->get('start');
  1817.             $sortingSettings = \Pimcore\Bundle\AdminBundle\Helper\QueryParams::extractSortingSettings(array_merge($request->request->all(), $request->query->all()));
  1819.             if ($request->get('filter')) {
  1820.                 $filter = $request->get('filter');
  1821.                 $list->setFilter(function ($row) use ($filter) {
  1822.                     foreach ($row as $value) {
  1823.                         if (strpos($value, $filter) !== false) {
  1824.                             return true;
  1825.                         }
  1826.                     }
  1828.                     return false;
  1829.                 });
  1830.             }
  1832.             $list->setOrder(static function ($a, $b) use ($sortingSettings) {
  1833.                 if (!$sortingSettings) {
  1834.                     return 0;
  1835.                 }
  1836.                 $orderKey = $sortingSettings['orderKey'];
  1837.                 $aValue = $a[$orderKey] ?? null;
  1838.                 $bValue = $b[$orderKey] ?? null;
  1839.                 if ($aValue == $bValue) {
  1840.                     return 0;
  1841.                 }
  1843.                 $result = $aValue < $bValue ? -1 : 1;
  1844.                 if ($sortingSettings['order'] === 'DESC') {
  1845.                     $result = -1 * $result;
  1846.                 }
  1848.                 return $result;
  1849.             });
  1851.             $totalCount = $list->getTotalCount();
  1852.             $list = $list->load();
  1854.             $list = array_slice($list, $start, $limit);
  1856.             $settings = [];
  1857.             foreach ($list as $item) {
  1858.                 $resultItem = $this->getWebsiteSettingForEditMode($item);
  1859.                 $settings[] = $resultItem;
  1860.             }
  1862.             return $this->adminJson(['data' => $settings, 'success' => true, 'total' => $totalCount]);
  1863.         }
  1865.         return $this->adminJson(['success' => false]);
  1866.     }
  1868.     /**
  1869.      * @param WebsiteSetting $item
  1870.      *
  1871.      * @return array
  1872.      */
  1873.     private function getWebsiteSettingForEditMode($item)
  1874.     {
  1875.         $resultItem = [
  1876.             'id' => $item->getId(),
  1877.             'name' => $item->getName(),
  1878.             'language' => $item->getLanguage(),
  1879.             'type' => $item->getType(),
  1880.             'data' => null,
  1881.             'siteId' => $item->getSiteId(),
  1882.             'creationDate' => $item->getCreationDate(),
  1883.             'modificationDate' => $item->getModificationDate(),
  1884.         ];
  1886.         switch ($item->getType()) {
  1887.             case 'document':
  1888.             case 'asset':
  1889.             case 'object':
  1890.                 $element = $item->getData();
  1891.                 if ($element) {
  1892.                     $resultItem['data'] = $element->getRealFullPath();
  1893.                 }
  1894.                 break;
  1895.             default:
  1896.                 $resultItem['data'] = $item->getData();
  1897.                 break;
  1898.         }
  1900.         return $resultItem;
  1901.     }
  1903.     /**
  1904.      * @Route("/get-available-algorithms", name="pimcore_admin_settings_getavailablealgorithms", methods={"GET"})
  1905.      *
  1906.      * @param Request $request
  1907.      *
  1908.      * @return JsonResponse
  1909.      */
  1910.     public function getAvailableAlgorithmsAction(Request $request)
  1911.     {
  1912.         $options = [
  1913.             [
  1914.                 'key' => 'password_hash',
  1915.                 'value' => 'password_hash',
  1916.             ],
  1917.         ];
  1919.         $algorithms = hash_algos();
  1920.         foreach ($algorithms as $algorithm) {
  1921.             $options[] = [
  1922.                 'key' => $algorithm,
  1923.                 'value' => $algorithm,
  1924.             ];
  1925.         }
  1927.         $result = ['data' => $options, 'success' => true, 'total' => count($options)];
  1929.         return $this->adminJson($result);
  1930.     }
  1932.     /**
  1933.      * deleteViews
  1934.      * delete views for localized fields when languages are removed to
  1935.      * prevent mysql errors
  1936.      *
  1937.      * @param string $language
  1938.      * @param string $dbName
  1939.      */
  1940.     protected function deleteViews($language, $dbName)
  1941.     {
  1942.         $db = \Pimcore\Db::get();
  1943.         $views = $db->fetchAll('SHOW FULL TABLES IN ' . $db->quoteIdentifier($dbName) . " WHERE TABLE_TYPE LIKE 'VIEW'");
  1945.         foreach ($views as $view) {
  1946.             if (preg_match('/^object_localized_[0-9]+_' . $language . '$/', $view['Tables_in_' . $dbName])) {
  1947.                 $sql = 'DROP VIEW ' . $db->quoteIdentifier($view['Tables_in_' . $dbName]);
  1948.                 $db->query($sql);
  1949.             }
  1950.         }
  1951.     }
  1953.     /**
  1954.      * @Route("/test-web2print", name="pimcore_admin_settings_testweb2print", methods={"GET"})
  1955.      *
  1956.      * @param Request $request
  1957.      *
  1958.      * @return Response
  1959.      */
  1960.     public function testWeb2printAction(Request $request)
  1961.     {
  1962.         $this->checkPermission('web2print_settings');
  1964.         $response = $this->render('PimcoreAdminBundle:Admin/Settings:testWeb2print.html.php');
  1965.         $html = $response->getContent();
  1967.         $adapter = \Pimcore\Web2Print\Processor::getInstance();
  1968.         $params = [];
  1970.         if ($adapter instanceof \Pimcore\Web2Print\Processor\WkHtmlToPdf) {
  1971.             $params['adapterConfig'] = '-O landscape';
  1972.         } elseif ($adapter instanceof \Pimcore\Web2Print\Processor\PdfReactor8) {
  1973.             $params['adapterConfig'] = [
  1974.                 'javaScriptMode' => 0,
  1975.                 'addLinks' => true,
  1976.                 'appendLog' => true,
  1977.                 'enableDebugMode' => true,
  1978.             ];
  1979.         }
  1981.         $responseOptions = [
  1982.             'Content-Type' => 'application/pdf',
  1983.         ];
  1985.         $pdfData = $adapter->getPdfFromString($html, $params);
  1987.         return new \Symfony\Component\HttpFoundation\Response(
  1988.             $pdfData,
  1989.             200,
  1990.             $responseOptions
  1992.         );
  1993.     }
  1994. }