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