Merge pull request #5989 from WoltLab/wsc-rpc-api-const

[GitHub/WoltLab/WCF.git] / wcfsetup / install / files / lib / system / importer / AbstractImporter.class.php

<?php

namespace wcf\system\importer;

use wcf\data\package\PackageCache;
use wcf\system\WCF;

/**
 * Basic implementation of IImporter.
 *
 * @author  Marcel Werk
 * @copyright   2001-2019 WoltLab GmbH
 * @license GNU Lesser General Public License <http://opensource.org/licenses/lgpl-license.php>
 */
abstract class AbstractImporter implements IImporter
{
    /**
     * database object class name
     * @var string
     */
    protected $className = '';

    /**
     * @inheritDoc
     */
    public function getClassName()
    {
        return $this->className;
    }

    /**
     * Imports a list of language items.
     *
     * @param string[][] $items
     * @param string $languageCategory
     * @param string $package
     */
    protected function importI18nValues(array $items, $languageCategory, $package)
    {
        // get package id
        $packageID = PackageCache::getInstance()->getPackageID($package);

        $sql = "INSERT INTO             wcf" . WCF_N . "_language_item
                                        (languageID, languageItem, languageItemValue, languageCategoryID, packageID)
                VALUES                  (?, ?, ?, ?, ?)
                ON DUPLICATE KEY UPDATE languageItemValue = VALUES(languageItemValue)";
        $statement = WCF::getDB()->prepareStatement($sql);
        WCF::getDB()->beginTransaction();
        foreach ($items as $itemData) {
            $statement->execute([
                $itemData['languageID'],
                $itemData['languageItem'],
                $itemData['languageItemValue'],
                $this->getLanguageCategoryID($languageCategory),
                $packageID,
            ]);
        }
        WCF::getDB()->commitTransaction();
    }

    /**
     * Returns the language category id.
     *
     * @param string $languageCategory
     * @return      int
     */
    protected function getLanguageCategoryID($languageCategory)
    {
        static $languageCategoryIDs = [];

        if (!isset($languageCategoryIDs[$languageCategory])) {
            // get language category id
            $sql = "SELECT  languageCategoryID
                    FROM    wcf" . WCF_N . "_language_category
                    WHERE   languageCategory = ?";
            $statement = WCF::getDB()->prepareStatement($sql);
            $statement->execute([$languageCategory]);

            $languageCategoryIDs[$languageCategory] = $statement->fetchSingleColumn();
        }

        return $languageCategoryIDs[$languageCategory];
    }
}