/**
* Load configuration values into xml config object
*
* @param Mage_Core_Model_Config $xmlConfig
* @param string $cond
* @return Mage_Core_Model_Mysql4_Config_Collection
*/
public function loadToXml(Mage_Core_Model_Config $xmlConfig, $cond = null)
{
$read = $this->_getReadAdapter();
if (!$read) {
return $this;
}
$websites = array();
$rows = $read->fetchAssoc("select website_id, code, name from " . $this->getTable('website'));
foreach ($rows as $w) {
$xmlConfig->setNode('websites/' . $w['code'] . '/system/website/id', $w['website_id']);
$xmlConfig->setNode('websites/' . $w['code'] . '/system/website/name', $w['name']);
$websites[$w['website_id']] = array('code' => $w['code']);
}
$stores = array();
$rows = $read->fetchAssoc("select store_id, code, name, website_id from " . $this->getTable('store') . " order by sort_order asc");
foreach ($rows as $s) {
$xmlConfig->setNode('stores/' . $s['code'] . '/system/store/id', $s['store_id']);
$xmlConfig->setNode('stores/' . $s['code'] . '/system/store/name', $s['name']);
$xmlConfig->setNode('stores/' . $s['code'] . '/system/website/id', $s['website_id']);
$xmlConfig->setNode('websites/' . $websites[$s['website_id']]['code'] . '/system/stores/' . $s['code'], $s['store_id']);
$stores[$s['store_id']] = array('code' => $s['code']);
$websites[$s['website_id']]['stores'][$s['store_id']] = $s['code'];
}
$subst_from = array();
$subst_to = array();
// load all configuration records from database, which are not inherited
$rows = $read->fetchAll("select scope, scope_id, path, value from " . $this->getMainTable() . ($cond ? ' where ' . $cond : ''));
// set default config values from database
foreach ($rows as $r) {
if ($r['scope'] !== 'default') {
continue;
}
$value = str_replace($subst_from, $subst_to, $r['value']);
$xmlConfig->setNode('default/' . $r['path'], $value);
}
// inherit default config values to all websites
$extendSource = $xmlConfig->getNode('default');
foreach ($websites as $id => $w) {
$websiteNode = $xmlConfig->getNode('websites/' . $w['code']);
$xmlConfig->extendNode($websiteNode, $extendSource);
}
$deleteWebsites = array();
// set websites config values from database
foreach ($rows as $r) {
if ($r['scope'] !== 'websites') {
continue;
}
$value = str_replace($subst_from, $subst_to, $r['value']);
if (isset($websites[$r['scope_id']])) {
$xmlConfig->setNode('websites/' . $websites[$r['scope_id']]['code'] . '/' . $r['path'], $value);
} else {
$deleteWebsites[$r['scope_id']] = $r['scope_id'];
}
}
// extend website config values to all associated stores
foreach ($websites as $website) {
$extendSource = $xmlConfig->getNode('websites/' . $website['code']);
if (isset($website['stores'])) {
foreach ($website['stores'] as $sCode) {
$storeNode = $xmlConfig->getNode('stores/' . $sCode);
/**
* $extendSource DO NOT need overwrite source
*/
$xmlConfig->extendNode($storeNode, $extendSource, false);
}
}
}
$deleteStores = array();
// set stores config values from database
foreach ($rows as $r) {
if ($r['scope'] !== 'stores') {
continue;
}
$value = str_replace($subst_from, $subst_to, $r['value']);
if (isset($stores[$r['scope_id']])) {
$xmlConfig->setNode('stores/' . $stores[$r['scope_id']]['code'] . '/' . $r['path'], $value);
} else {
$deleteStores[$r['scope_id']] = $r['scope_id'];
}
}
if ($deleteWebsites) {
$this->_getWriteAdapter()->delete($this->getMainTable(), array($this->_getWriteAdapter()->quoteInto('scope=?', 'websites'), $this->_getWriteAdapter()->quoteInto('scope_id IN(?)', $deleteWebsites)));
}
if ($deleteStores) {
$this->_getWriteAdapter()->delete($this->getMainTable(), array($this->_getWriteAdapter()->quoteInto('scope=?', 'stores'), $this->_getWriteAdapter()->quoteInto('scope_id IN(?)', $deleteStores)));
}
return $this;
}
