PHP Pimcore\Config Examples

Example #1

File: postupdate.php Project: SeerUK/pimcore-manual-updater

<?php

// STATICROUTES
$file = Pimcore\Config::locateConfigFile("staticroutes");
$db = \Pimcore\Db::get();
$staticRoutes = $db->fetchAll("SELECT * FROM staticroutes");
$json = \Pimcore\Db\JsonFileTable::get($file);
$json->truncate();
foreach ($staticRoutes as $route) {
    $data = $route;
    unset($data["id"]);
    $json->insertOrUpdate($data, $route["id"]);
}
$db->query("RENAME TABLE `staticroutes` TO `PLEASE_DELETE__staticroutes`;");

Example #2

File: preupdate.php Project: SeerUK/pimcore-manual-updater

        if (strpos($file, ".xml")) {
            $name = str_replace(".xml", "", $file);
            $thumbnail = \Pimcore\Model\Tool\Newsletter\Config::getByName($name);
            $thumbnail = object2array($thumbnail);
            $thumbnail["id"] = $thumbnail["name"];
            unset($thumbnail["name"]);
            $json->insertOrUpdate($thumbnail, $thumbnail["id"]);
        }
    }
    // move data
    rename($dir, $legacyFolder . "/newsletter");
}
// TAG SNIPPET MANAGEMENT
$dir = PIMCORE_CONFIGURATION_DIRECTORY . "/tags";
if (is_dir($dir)) {
    $file = Pimcore\Config::locateConfigFile("tag-manager.json");
    $json = \Pimcore\Db\JsonFileTable::get($file);
    $json->truncate();
    $files = scandir($dir);
    foreach ($files as $file) {
        if (strpos($file, ".xml")) {
            $name = str_replace(".xml", "", $file);
            $thumbnail = Pimcore\Model\Tool\Tag\Config::getByName($name);
            $thumbnail = object2array($thumbnail);
            $thumbnail["id"] = $thumbnail["name"];
            unset($thumbnail["name"]);
            $json->insertOrUpdate($thumbnail, $thumbnail["id"]);
        }
    }
    // move data
    rename($dir, $legacyFolder . "/tags");

Example #3

File: preupdate.php Project: SeerUK/pimcore-manual-updater

        if (strpos($file, ".xml")) {
            $name = str_replace(".xml", "", $file);
            $thumbnail = \Pimcore\Model\Tool\Qrcode\Config::getByName($name);
            $thumbnail = object2array($thumbnail);
            $thumbnail["id"] = $thumbnail["name"];
            unset($thumbnail["name"]);
            $json->insertOrUpdate($thumbnail, $thumbnail["id"]);
        }
    }
    // move data
    rename($dir, $legacyFolder . "/qrcodes");
}
// SQL REPORTS
$dir = PIMCORE_CONFIGURATION_DIRECTORY . "/sqlreport";
if (is_dir($dir)) {
    $file = Pimcore\Config::locateConfigFile("custom-reports.json");
    $json = \Pimcore\Db\JsonFileTable::get($file);
    $json->truncate();
    $files = scandir($dir);
    foreach ($files as $file) {
        if (strpos($file, ".xml")) {
            $name = str_replace(".xml", "", $file);
            $thumbnail = \Pimcore\Model\Tool\CustomReport\Config::getByName($name);
            $thumbnail = object2array($thumbnail);
            $thumbnail["id"] = $thumbnail["name"];
            unset($thumbnail["name"]);
            $json->insertOrUpdate($thumbnail, $thumbnail["id"]);
        }
    }
    // move data
    rename($dir, $legacyFolder . "/sqlreport");

Example #4

File: postupdate.php Project: SeerUK/pimcore-manual-updater

$json->truncate();
foreach ($staticRoutes as $route) {
    $data = $route;
    unset($data["id"]);
    $json->insertOrUpdate($data, $route["id"]);
}
$db->query("RENAME TABLE `documents_doctypes` TO `PLEASE_DELETE__documents_doctypes`;");
// PREDEFINED PROPERTIES
$file = Pimcore\Config::locateConfigFile("predefined-properties");
$db = \Pimcore\Db::get();
$staticRoutes = $db->fetchAll("SELECT * FROM properties_predefined");
$json = \Pimcore\Db\JsonFileTable::get($file);
$json->truncate();
foreach ($staticRoutes as $route) {
    $data = $route;
    unset($data["id"]);
    $json->insertOrUpdate($data, $route["id"]);
}
$db->query("RENAME TABLE `properties_predefined` TO `PLEASE_DELETE__properties_predefined`;");
// PREDEFINED PROPERTIES
$file = Pimcore\Config::locateConfigFile("predefined-asset-metadata");
$db = \Pimcore\Db::get();
$staticRoutes = $db->fetchAll("SELECT * FROM assets_metadata_predefined");
$json = \Pimcore\Db\JsonFileTable::get($file);
$json->truncate();
foreach ($staticRoutes as $route) {
    $data = $route;
    unset($data["id"]);
    $json->insertOrUpdate($data, $route["id"]);
}
$db->query("RENAME TABLE `assets_metadata_predefined` TO `PLEASE_DELETE__assets_metadata_predefined`;");

Example #5

File: preupdate.php Project: SeerUK/pimcore-manual-updater

        if (strpos($file, ".xml")) {
            $name = str_replace(".xml", "", $file);
            $thumbnail = Asset\Image\Thumbnail\Config::getByName($name);
            $thumbnail = object2array($thumbnail);
            $thumbnail["id"] = $thumbnail["name"];
            unset($thumbnail["name"]);
            $json->insertOrUpdate($thumbnail, $thumbnail["id"]);
        }
    }
    // move data
    rename($dir, $legacyFolder . "/imagepipelines");
}
// VIDEO THUMBNAILS
$dir = PIMCORE_CONFIGURATION_DIRECTORY . "/videopipelines";
if (is_dir($dir)) {
    $file = Pimcore\Config::locateConfigFile("video-thumbnails");
    $json = \Pimcore\Db\JsonFileTable::get($file);
    $json->truncate();
    $files = scandir($dir);
    foreach ($files as $file) {
        if (strpos($file, ".xml")) {
            $name = str_replace(".xml", "", $file);
            $thumbnail = Asset\Video\Thumbnail\Config::getByName($name);
            $thumbnail = object2array($thumbnail);
            $thumbnail["id"] = $thumbnail["name"];
            unset($thumbnail["name"]);
            $json->insertOrUpdate($thumbnail, $thumbnail["id"]);
        }
    }
    // move data
    rename($dir, $legacyFolder . "/videopipelines");