oxshop.php

Go to the documentation of this file.

<?php

class oxShop extends oxI18n
{
    protected $_sClassName = 'oxshop';

    protected $_aMultiShopTables = array();


    public function __construct()
    {
        parent::__construct();
        $this->init( 'oxshops' );
    }

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


    public function generateViews( $blMultishopInheritCategories = false, $aMallInherit = null )
    {
        $oDb        = oxDb::getDb();
        $aLanguages = oxLang::getInstance()->getLanguageIds();

        $aTables = $aMultilangTables = oxLang::getInstance()->getMultiLangTables();

        $aQ = array();

        // Generate multitable views
        foreach ( $aTables as $sTable ) {
            $aQ[] = 'CREATE OR REPLACE SQL SECURITY INVOKER VIEW oxv_'.$sTable.' AS SELECT * FROM '.$sTable.' '.$this->_getViewJoinAll($sTable);

            if (in_array($sTable, $aMultilangTables)) {
                foreach ($aLanguages as $iLang => $sLang) {
                    $aQ[] = 'CREATE OR REPLACE SQL SECURITY INVOKER VIEW oxv_'.$sTable.'_'.$sLang.' AS SELECT '.$this->_getViewSelect($sTable, $iLang).' FROM '.$sTable.' '.$this->_getViewJoinLang($sTable, $iLang);
                }
            }
        }

        $bSuccess = true;
        foreach ($aQ as $sQ) {
            if ( !$oDb->execute( $sQ ) ) {
                $bSuccess = false;
            }
        }

        $oViewsValidator = oxNew( 'oxShopViewValidator' );

        $oViewsValidator->setShopId( $this->getConfig()->getShopId() );
        $oViewsValidator->setLanguages( $aLanguages );
        $oViewsValidator->setMultiLangTables( $aMultilangTables );
        $oViewsValidator->setMultiShopTables( $aMultishopTables );

        $aViews = $oViewsValidator->getInvalidViews();

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

        return $bSuccess;
    }

    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 _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;
    }

}