oxshop.php

Go to the documentation of this file.

<?php

class oxShop extends oxI18n
{

    protected $_sClassName = 'oxshop';

    protected $_aMultiShopTables = null;


    protected $_aQueries = array();

    protected $_aTables = null;

    protected $_blMultiShopInheritCategories = false;

    public function setTables($aTables)
    {
        $this->_aTables = $aTables;
    }

    public function getTables()
    {
        if (is_null($this->_aTables)) {
            $aMultilangTables = oxRegistry::getLang()->getMultiLangTables();
            $aTables = array_unique($aMultilangTables);
            $this->setTables($aTables);
        }

        return $this->_aTables;
    }

    public function setQueries($aQueries)
    {
        $this->_aQueries = $aQueries;
    }

    public function getQueries()
    {
        return $this->_aQueries;
    }

    public function addQuery($sQuery)
    {
        $this->_aQueries[] = $sQuery;
    }

    public function __construct()
    {
        parent::__construct();


        $this->init('oxshops');

        if ($iMax = $this->getConfig()->getConfigParam('iMaxShopId')) {
            $this->setMaxShopId($iMax);
        }

    }

    public function setMultiShopTables($aMultiShopTables)
    {
        $this->_aMultiShopTables = $aMultiShopTables;
    }

    public function getMultiShopTables()
    {
        if (is_null($this->_aMultiShopTables)) {
            $this->_aMultiShopTables = array();
        }

        return $this->_aMultiShopTables;
    }


    public function generateViews($blMultishopInheritCategories = false, $aMallInherit = null)
    {
        $this->_prepareViewsQueries();
        $blSuccess = $this->_runQueries();

        $this->_cleanInvalidViews();

        return $blSuccess;
    }

    protected function _getViewSelect($sTable, $iLang)
    {
        $oMetaData = oxNew('oxDbMetaDataHandler');
        $aFields = $oMetaData->getSinglelangFields($sTable, $iLang);
        foreach ($aFields as $sCoreField => $sField) {
            if ($sCoreField !== $sField) {
                $aFields[$sCoreField] = $sField . ' AS ' . $sCoreField;
            }
        }

        return implode(',', $aFields);
    }

    protected function _getViewSelectMultilang($sTable)
    {
        $aFields = array();

        $oMetaData = oxNew('oxDbMetaDataHandler');
        $aTables = array_merge(array($sTable), $oMetaData->getAllMultiTables($sTable));
        foreach ($aTables as $sTableKey => $sTableName) {
            $aTableFields = $oMetaData->getFields($sTableName);
            foreach ($aTableFields as $sCoreField => $sField) {
                if (!isset($aFields[$sCoreField])) {
                    $aFields[$sCoreField] = $sField;
                }
            }
        }

        return implode(',', $aFields);
    }

    protected function _getViewJoinAll($sTable)
    {
        $sJoin = ' ';
        $oMetaData = oxNew('oxDbMetaDataHandler');
        $aTables = $oMetaData->getAllMultiTables($sTable);
        if (count($aTables)) {
            foreach ($aTables as $sTableKey => $sTableName) {
                $sJoin .= "LEFT JOIN {$sTableName} USING (OXID) ";
            }
        }

        return $sJoin;
    }

    protected function _getViewJoinLang($sTable, $iLang)
    {
        $sJoin = ' ';
        $sLangTable = getLangTableName($sTable, $iLang);
        if ($sLangTable && $sLangTable !== $sTable) {
            $sJoin .= "LEFT JOIN {$sLangTable} USING (OXID) ";
        }

        return $sJoin;
    }


    public function getDefaultCategory()
    {
        return $this->oxshops__oxdefcat->value;
    }

    public function isProductiveMode()
    {
        return (bool) $this->oxshops__oxproductive->value;
    }

    protected function _cleanInvalidViews()
    {
        $oDb = oxDb::getDb();
        $oLang = oxRegistry::getLang();
        $aLanguages = $oLang->getLanguageIds($this->getId());

        $aMultilangTables = oxRegistry::getLang()->getMultiLangTables();
        $aMultishopTables = $this->getMultiShopTables();

        $oLang = oxRegistry::getLang();
        $aAllShopLanguages = $oLang->getAllShopLanguageIds();

        $oViewsValidator = oxNew('oxShopViewValidator');

        $oViewsValidator->setShopId($this->getId());
        $oViewsValidator->setLanguages($aLanguages);
        $oViewsValidator->setAllShopLanguages($aAllShopLanguages);
        $oViewsValidator->setMultiLangTables($aMultilangTables);
        $oViewsValidator->setMultiShopTables($aMultishopTables);

        $aViews = $oViewsValidator->getInvalidViews();

        foreach ($aViews as $sView) {
            $oDb->execute('DROP VIEW IF EXISTS ' . $sView);
        }
    }

    protected function _prepareViewsQueries()
    {
        $oLang = oxRegistry::getLang();
        $aLanguages = $oLang->getLanguageIds($this->getId());

        $aMultilangTables = oxRegistry::getLang()->getMultiLangTables();
        $aTables = $this->getTables();
        $iShopId = $this->getId();
        foreach ($aTables as $sTable) {
            $this->createViewQuery($sTable);
            if (in_array($sTable, $aMultilangTables)) {
                $this->createViewQuery($sTable, $aLanguages);
            }
        }
    }

    public function createViewQuery($sTable, $aLanguages = null)
    {
        $sDefaultLangAddition = '';
        $sShopAddition = '';
        $sStart = 'CREATE OR REPLACE SQL SECURITY INVOKER VIEW';

        if (!is_array($aLanguages)) {
            $aLanguages = array(null => null);
        }

        foreach ($aLanguages as $iLang => $sLang) {
            $sLangAddition = $sLang === null ? $sDefaultLangAddition : "_{$sLang}";

            $sViewTable = "oxv_{$sTable}{$sLangAddition}";

            if ($sLang === null) {
                $sFields = $this->_getViewSelectMultilang($sTable);
                $sJoin = $this->_getViewJoinAll($sTable);
            } else {
                $sFields = $this->_getViewSelect($sTable, $iLang);
                $sJoin = $this->_getViewJoinLang($sTable, $iLang);
            }

            $sQuery = "{$sStart} `{$sViewTable}` AS SELECT {$sFields} FROM {$sTable}{$sJoin}";
            $this->addQuery($sQuery);

        }

    }

    protected function _runQueries()
    {
        $oDb = oxDb::getDb();
        $aQueries = $this->getQueries();
        $bSuccess = true;
        foreach ($aQueries as $sQuery) {
            if (!$oDb->execute($sQuery)) {
                $bSuccess = false;
            }
        }

        return $bSuccess;
    }

}