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 = oxRegistry::getLang()->getLanguageIds();
00059
00060 $aTables = $aMultilangTables = oxRegistry::getLang()->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 $bSuccess = true;
00076 foreach ($aQ as $sQ) {
00077 if ( !$oDb->execute( $sQ ) ) {
00078 $bSuccess = false;
00079 }
00080 }
00081 return $bSuccess;
00082 }
00083
00092 protected function _getViewSelect($sTable,$iLang)
00093 {
00094 $oMetaData = oxNew('oxDbMetaDataHandler');
00095 $aFields = $oMetaData->getSinglelangFields($sTable, $iLang);
00096 foreach ($aFields as $sCoreField => $sField) {
00097 if ($sCoreField !== $sField) {
00098 $aFields[$sCoreField] = $sField.' AS '.$sCoreField;
00099 }
00100 }
00101
00102 return implode(',', $aFields);
00103 }
00104
00112 protected function _getViewJoinAll($sTable)
00113 {
00114 $sJoin = ' ';
00115 $oMetaData = oxNew('oxDbMetaDataHandler');
00116 $aTables = $oMetaData->getAllMultiTables($sTable);
00117 if (count($aTables)) {
00118 foreach ($aTables as $sTableKey => $sTableName) {
00119 $sJoin .= "LEFT JOIN {$sTableName} USING (OXID) ";
00120 }
00121 }
00122 return $sJoin;
00123 }
00124
00133 protected function _getViewJoinLang($sTable,$iLang)
00134 {
00135 $sJoin = ' ';
00136 $sLangTable = getLangTableName($sTable, $iLang);
00137 if ($sLangTable && $sLangTable !== $sTable) {
00138 $sJoin .= "LEFT JOIN {$sLangTable} USING (OXID) ";
00139 }
00140 return $sJoin;
00141 }
00142
00143
00149 public function getDefaultCategory()
00150 {
00151 return $this->oxshops__oxdefcat->value;
00152 }
00153
00154 }