oxshopviewvalidator.php

Go to the documentation of this file.

<?php

class oxShopViewValidator {

    protected $_aMultiLangTables = array();

    protected $_aMultiShopTables = array();

    protected $_aLanguages = array();

    protected $_iShopId = null;

    protected $_aAllViews = array();

    protected $_aShopViews = array();

    protected $_aValidShopViews = array();

    public function setMultiLangTables( $aMultiLangTables )
    {
        $this->_aMultiLangTables = $aMultiLangTables;
    }

    public function getMultiLangTables()
    {
        return $this->_aMultiLangTables;
    }


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

    public function getMultiShopTables()
    {
        return $this->_aMultiShopTables;
    }

    public function setLanguages( $aLanguages )
    {
        $this->_aLanguages = $aLanguages;
    }

    public function getLanguages()
    {
        return $this->_aLanguages;
    }


    public function setShopId( $iShopId )
    {
        $this->_iShopId = $iShopId;
    }

    public function getShopId()
    {
        return $this->_iShopId;
    }

    protected function _getAllViews()
    {
        if ( empty( $this->_aAllViews ) ) {
            $this->_aAllViews = oxDb::getDb()->getCol( "SHOW TABLES LIKE  'oxv_%'" );
        }

        return  $this->_aAllViews;
    }

    protected function _isCurrentShopView( $sViewName )
    {
        $blResult = false;

        $blEndsWithShopId = preg_match( "/[_]([0-9]+)$/",$sViewName, $aMatchEndsWithShopId );
        $blContainsShopId = preg_match( "/[_]([0-9]+)[_]/",$sViewName, $aMatchContainsShopId );

        if ( ( !$blEndsWithShopId && !$blContainsShopId ) ||
             ( $blEndsWithShopId && $aMatchEndsWithShopId[1] == $this->getShopId() ) ||
             ( $blContainsShopId && $aMatchContainsShopId[1] == $this->getShopId() ) ) {

            $blResult = true;
        }

        return $blResult;
    }


    protected function _getShopViews()
    {
        if ( empty( $this->_aShopViews ) ) {

            $this->_aShopViews = array();
            $aAllViews = $this->_getAllViews();

            foreach ( $aAllViews as $sView ) {

                if ( $this->_isCurrentShopView( $sView ) ){
                    $this->_aShopViews[] = $sView;
                }
            }
        }

        return $this->_aShopViews;
    }

    protected function _getValidShopViews()
    {
        if ( empty( $this->_aValidShopViews ) ) {

            $aTables = $this->getMultilangTables();


            $this->_aValidShopViews = array();

            foreach ( $aTables as $sTable ) {
                $this->_aValidShopViews[] = 'oxv_'.$sTable;;

                if ( in_array( $sTable, $this->getMultiLangTables() ) ) {
                    foreach ( $this->_getAllShopLanguageIds() as $sLang ) {
                        $this->_aValidShopViews[] ='oxv_'.$sTable.'_'.$sLang;
                    }
                }

            }
        }

        return $this->_aValidShopViews;
    }

    protected function _isViewValid( $sViewName ){
        return in_array( $sViewName, $this->_getValidShopViews() );
    }

    public function getInvalidViews()
    {
        $aInvalidViews = array();
        $aShopViews = $this->_getShopViews();

        foreach ( $aShopViews as $sView ) {
            if ( !$this->_isViewValid( $sView ) ){
                $aInvalidViews[] = $sView;
            }
        }

        return $aInvalidViews;
    }

    private function _getAllShopLanguageIds()
    {
            $aLanguages = oxRegistry::getLang()->getLanguageIds();

        return $aLanguages;
    }

    private function _getAllLanguageParamValues( $sParamName )
    {
        $oDb = oxDb::getDb( oxDb::FETCH_MODE_ASSOC );
        $oConfig = oxRegistry::getConfig();

        $sQuery = "
            select ".$oConfig->getDecodeValueQuery()." as oxvarvalue
            from oxconfig
            where oxvarname = '{$sParamName}' ";

        return $oDb->getArray( $sQuery );
    }

    private function _getConfigLanguageParamValues()
    {
        $aConfigValues = $this->_getAllLanguageParamValues( 'aLanguageParams' );
        $aConfigDecodedValues = array();

        foreach ( $aConfigValues as $sConfigValue )
        {
            $aConfigLanguageParams = unserialize( $sConfigValue['oxvarvalue'] );
            $aLanguages = $this->_processLanguageParamsArray( $aConfigLanguageParams );

            $aConfigDecodedValues = array_unique( array_merge( $aConfigDecodedValues, $aLanguages ) );
        }

        return $aConfigDecodedValues;
    }

    private function _processLanguageParamsArray( $aLanguageParams )
    {
        $aLanguages = array();
        foreach ( $aLanguageParams as $sAbbr => $aValue ) {
            $iBaseId = (int) $aValue[ 'baseId' ];
            $aLanguages[ $iBaseId ] = $sAbbr;
        }

        return $aLanguages;
    }


    private function _getConfigLanguageValues()
    {
        $aConfigValues = $this->_getAllLanguageParamValues( 'aLanguages' );
        $aConfigDecodedValues = array();

        foreach ( $aConfigValues as $sConfigValue )
        {
            $aConfigLanguages = unserialize( $sConfigValue['oxvarvalue'] );

            $aLanguages = array_keys( $aConfigLanguages );

            $aConfigDecodedValues = array_unique( array_merge( $aConfigDecodedValues, $aLanguages ) );
        }

        return $aConfigDecodedValues;
    }


}