Go to the documentation of this file.00001 <?php
00002
00008 class oxShop extends oxI18n
00009 {
00015 protected $_sClassName = 'oxshop';
00016
00022 protected $_aMultiShopTables = array();
00023
00024
00028 public function __construct()
00029 {
00030 parent::__construct();
00031 $this->init( 'oxshops' );
00032 }
00033
00041 public function setMultiShopTables( $aMultiShopTables )
00042 {
00043 $this->_aMultiShopTables = $aMultiShopTables;
00044 }
00045
00046
00055 public function generateViews( $blMultishopInheritCategories = false, $aMallInherit = null )
00056 {
00057 $oDb = oxDb::getDb();
00058 $aLanguages = oxLang::getInstance()->getLanguageIds();
00059
00060 $aTables = $aMultilangTables = oxLang::getInstance()->getMultiLangTables();
00061
00062 $aQ = array();
00063
00064
00065 foreach ( $aTables as $sTable ) {
00066 $aQ[] = 'CREATE OR REPLACE SQL SECURITY INVOKER VIEW oxv_'.$sTable.' AS SELECT * FROM '.$sTable.' '.$this->_getViewJoinAll($sTable);
00067
00068 if (in_array($sTable, $aMultilangTables)) {
00069 foreach ($aLanguages as $iLang => $sLang) {
00070 $aQ[] = 'CREATE OR REPLACE SQL SECURITY INVOKER VIEW oxv_'.$sTable.'_'.$sLang.' AS SELECT '.$this->_getViewSelect($sTable, $iLang).' FROM '.$sTable.' '.$this->_getViewJoinLang($sTable, $iLang);
00071 }
00072 }
00073 }
00074
00075 foreach ($aQ as $sQ) {
00076 $oDb->execute( $sQ );
00077 }
00078 }
00079
00088 protected function _getViewSelect($sTable,$iLang)
00089 {
00090 $oMetaData = oxNew('oxDbMetaDataHandler');
00091 $aFields = $oMetaData->getSinglelangFields($sTable, $iLang);
00092 foreach ($aFields as $sCoreField => $sField) {
00093 if ($sCoreField !== $sField) {
00094 $aFields[$sCoreField] = $sField.' AS '.$sCoreField;
00095 }
00096 }
00097
00098 return implode(',', $aFields);
00099 }
00100
00108 protected function _getViewJoinAll($sTable)
00109 {
00110 $sJoin = ' ';
00111 $oMetaData = oxNew('oxDbMetaDataHandler');
00112 $aTables = $oMetaData->getAllMultiTables($sTable);
00113 if (count($aTables)) {
00114 foreach ($aTables as $sTableKey => $sTableName) {
00115 $sJoin .= "LEFT JOIN {$sTableName} USING (OXID) ";
00116 }
00117 }
00118 return $sJoin;
00119 }
00120
00129 protected function _getViewJoinLang($sTable,$iLang)
00130 {
00131 $sJoin = ' ';
00132 $sLangTable = getLangTableName($sTable, $iLang);
00133 if ($sLangTable && $sLangTable !== $sTable) {
00134 $sJoin .= "LEFT JOIN {$sLangTable} USING (OXID) ";
00135 }
00136 return $sJoin;
00137 }
00138
00139 }