oxshopviewvalidator.php

Go to the documentation of this file.

<?php

class oxShopViewValidator {

    protected $_aMultiLangTables = array();

    protected $_aMultiShopTables = array();

    protected $_aLanguages = array();

    protected $_aAllShopLanguages = 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 setAllShopLanguages( $aAllShopLanguages )
    {
        $this->_aAllShopLanguages = $aAllShopLanguages;
    }

    public function getAllShopLanguages()
    {
        return $this->_aAllShopLanguages;
    }


    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->getAllShopLanguages() 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;
    }

}