/**
* removeUrlHistoryEntry
* @param integer $intUrlId
* @param string $strRelationId
* @return Zend_Db_Table_Rowset_Abstract
* @author Thomas Schedler <*****@*****.**>
* @version 1.0
*/
public function removeUrlHistoryEntry($intUrlId, $strRelationId)
{
$this->core->logger->debug('core->models->Model_Urls->removeUrlHistoryEntry(' . $intUrlId . ', ' . $strRelationId . ')');
$strWhere = $this->getUrlTable()->getAdapter()->quoteInto('relationId = ?', $strRelationId);
$strWhere .= $this->objUrlTable->getAdapter()->quoteInto(' AND id = ?', $intUrlId);
return $this->objUrlTable->delete($strWhere);
}
/**
* loadAllPublicPages
* @return Zend_Db_Table_Rowset_Abstract
* @author Thomas Schedler <*****@*****.**>
* @version 1.0
*/
public function loadAllPublicPages()
{
$this->core->logger->debug('cms->models->Model_Pages->loadAllPublicPages()');
$objSelect = $this->getPageUrlTable()->select();
$objSelect->from($this->objPageUrlTable, array('pageId', 'version', 'idLanguages'));
$objSelect->join('pages', 'pages.pageId = urls.relationId AND pages.version = urls.version', array());
$objSelect->where('pages.idStatus = ?', $this->core->sysConfig->status->live)->where('pages.idPageTypes != ?', $this->core->sysConfig->page_types->link->id);
return $this->objPageUrlTable->fetchAll($objSelect);
}
/**
* loadAllPublicPages
* @return Zend_Db_Table_Rowset_Abstract
* @author Thomas Schedler <*****@*****.**>
* @version 1.0
*/
public function loadAllPublicPages()
{
$this->core->logger->debug('cms->models->Model_Pages->loadAllPublicPages()');
$objSelect = $this->getPageUrlTable()->select()->distinct();
$objSelect->setIntegrityCheck(false);
$objSelect->from($this->objPageUrlTable, array('pages.pageId', 'version', 'idLanguages'));
$objSelect->join('pages', 'pages.pageId = urls.relationId AND pages.version = urls.version AND urls.idUrlTypes = ' . $this->core->sysConfig->url_types->page, array('idParent'));
$objSelect->join('pageProperties', 'pageProperties.pageId = pages.pageId AND pageProperties.version = pages.version AND pageProperties.idLanguages = urls.idLanguages', array());
$objSelect->joinleft('folders', 'pages.idParent = folders.id AND pages.idParentTypes = ' . $this->core->sysConfig->parent_types->folder, array('idRootLevels'));
$objSelect->where('pageProperties.idStatus = ?', $this->core->sysConfig->status->live)->where('pageProperties.idPageTypes != ?', $this->core->sysConfig->page_types->link->id)->where('pageProperties.idPageTypes != ?', $this->core->sysConfig->page_types->external->id);
return $this->objPageUrlTable->fetchAll($objSelect);
}
/**
* loadParentUrl
* @param integer $intGlobalId
* @param boolean $blnIsStartElement
* @return Zend_Db_Table_Rowset_Abstract
* @author Thomas Schedler <*****@*****.**>
* @version 1.0
*/
public function loadParentUrl($intGlobalId, $blnIsStartElement)
{
$this->core->logger->debug('global->models->Model_Globals->loadParentUrl(' . $intGlobalId . ',' . $blnIsStartElement . ')');
$objSelect = $this->getGlobalUrlTable()->select();
$objSelect->setIntegrityCheck(false);
if ($blnIsStartElement == true) {
$objSelect->from($this->objGlobalUrlTable, array('url', 'id'));
$objSelect->join('globals', 'globals.globalId = urls.relationId', array('globalId', 'version', 'isStartglobal'));
$objSelect->join('folders', 'folders.id = (SELECT idParent FROM globals WHERE id = ' . $intGlobalId . ')', array());
$objSelect->where('urls.version = globals.version')->where('urls.idUrlTypes = ?', $this->core->sysConfig->url_types->global)->where('urls.idLanguages = ?', $this->intLanguageId)->where('urls.isMain = 1')->where('globals.idParentTypes = ?', $this->core->sysConfig->parent_types->folder)->where('globals.idParent = folders.idParentFolder')->where('globals.isStartGlobal = 1');
} else {
$objSelect->from($this->objGlobalUrlTable, array('url', 'id'));
$objSelect->join('globals', 'globals.globalId = urls.relationId', array('globalId', 'version', 'isStartglobal'));
$objSelect->where('urls.version = globals.version')->where('urls.idUrlTypes = ?', $this->core->sysConfig->url_types->global)->where('urls.idLanguages = ?', $this->intLanguageId)->where('urls.isMain = 1')->where('globals.idParentTypes = ?', $this->core->sysConfig->parent_types->folder)->where('globals.idParent = (SELECT idParent FROM globals WHERE id = ' . $intGlobalId . ')')->where('globals.isStartGlobal = 1');
}
return $this->objGlobalUrlTable->fetchAll($objSelect);
}
