/**
* Returns the list of pages and folders, so containing both object types, being located
* under a given systemid.
*
* @param string $strFolderid
* @param bool $bitOnlyActive
*
* @return int
*/
public static function getPagesAndFolderListCount($strFolderid = "", $bitOnlyActive = false)
{
if (!validateSystemid($strFolderid)) {
$strFolderid = class_module_system_module::getModuleByName("pages")->getSystemid();
}
$objORM = new class_orm_objectlist();
$strQuery = "SELECT COUNT(*)\n\t\t\t\t\t\tFROM " . _dbprefix_ . "system\n\t\t\t\t\t\tWHERE system_prev_id=?\n AND (system_module_nr = ? OR system_module_nr = ? )\n " . $objORM->getDeletedWhereRestriction() . "\n\t " . ($bitOnlyActive ? " AND system_status = 1 " : "");
$arrRow = class_carrier::getInstance()->getObjDB()->getPRow($strQuery, array($strFolderid, _pages_modul_id_, _pages_folder_id_));
return $arrRow["COUNT(*)"];
}
/**
* Loads a list of assigned records and creates the concrete instances.
*
* @param int $intStart
* @param int $intEnd
* @return class_model[]
*/
public function getArrAssignedRecords($intStart = null, $intEnd = null)
{
$objORM = new class_orm_objectlist();
$strQuery = "SELECT system.system_id\n FROM " . _dbprefix_ . "tags_member as member,\n " . _dbprefix_ . "tags_tag,\n " . _dbprefix_ . "system as system\n WHERE tags_tagid = ?\n AND tags_tagid = tags_tag_id\n AND system.system_id = member.tags_systemid\n " . $objORM->getDeletedWhereRestriction() . "\n AND (tags_tag_private IS NULL OR tags_tag_private != 1 OR (tags_owner IS NULL OR tags_owner = '' OR tags_owner = ?))\n ORDER BY system_comment ASC";
$arrRecords = $this->objDB->getPArray($strQuery, array($this->getSystemid(), $this->objSession->getUserID()), $intStart, $intEnd);
$arrReturn = array();
foreach ($arrRecords as $arrOneRecord) {
$arrReturn[] = class_objectfactory::getInstance()->getObject($arrOneRecord["system_id"]);
}
return $arrReturn;
}
/**
* Return an on-lick link for the passed object.
* This link is rendered by the portal search result generator, so
* make sure the link is a valid portal page.
* If you want to suppress the entry from the result, return an empty string instead.
*
* @param class_search_result $objResult
*
* @see getLinkPortalHref()
* @return mixed
*/
public function updateSearchResult(class_search_result $objResult)
{
$objORM = new class_orm_objectlist();
//load the matching site of the current page-element
$strQuery = "SELECT page_name, page_id, pageproperties_browsername\n\t\t\t\t\t\t FROM " . _dbprefix_ . "page_element,\n\t\t\t\t\t\t " . _dbprefix_ . "page_properties,\n\t\t\t\t\t\t " . _dbprefix_ . "page,\n\t\t\t\t\t\t " . _dbprefix_ . "system\n\t\t\t\t\t\t WHERE system_prev_id = page_id\n\t\t\t\t\t\t AND pageproperties_id = page_id\n\t\t\t\t\t\t AND system_id = page_element_id\n\t\t\t\t\t\t AND page_element_id = ?\n\t\t\t\t\t\t " . $objORM->getDeletedWhereRestriction() . "\n\t\t\t\t\t\t AND system_status = 1";
$arrPage = class_carrier::getInstance()->getObjDB()->getPRow($strQuery, array($this->getSystemid()));
if (isset($arrPage["page_name"])) {
$objResult->setStrPagelink(class_link::getLinkPortal($arrPage["page_name"], "", "_self", $arrPage["pageproperties_browsername"], "", "&highlight=" . urlencode(html_entity_decode($objResult->getObjSearch()->getStrQuery(), ENT_QUOTES, "UTF-8"))));
$objResult->setStrPagename($arrPage["page_name"]);
}
}
/**
* Updates placeholders in the db. Replaces all placeholders with a new one, if the template of elements' page
* corresponds to the given one
*
* @param string $strTemplate
* @param string $strOldPlaceholder
* @param string $strNewPlaceholder
*
* @return bool
*/
public static function updatePlaceholders($strTemplate, $strOldPlaceholder, $strNewPlaceholder)
{
$bitReturn = true;
//Fetch all pages
$objORM = new class_orm_objectlist();
$arrObjPages = class_module_pages_page::getAllPages();
foreach ($arrObjPages as $objOnePage) {
if ($objOnePage->getStrTemplate() == $strTemplate || $strTemplate == "-1") {
//Search for matching elements
$strQuery = "SELECT system_id\n\t\t\t\t\t\t FROM " . _dbprefix_ . "page_element,\n\t\t\t\t\t\t " . _dbprefix_ . "element,\n\t\t\t\t\t\t " . _dbprefix_ . "system\n\t\t\t\t\t\t WHERE system_prev_id= ?\n\t\t\t\t\t\t AND page_element_ph_element = element_name\n\t\t\t\t\t\t AND system_id = page_element_id\n\t\t\t\t\t\t " . $objORM->getDeletedWhereRestriction() . "\n\t\t\t\t\t\t ORDER BY page_element_ph_placeholder ASC,\n\t\t\t\t\t\t \t\tsystem_sort ASC";
$arrIds = class_carrier::getInstance()->getObjDB()->getPArray($strQuery, array($objOnePage->getSystemid()));
/** @var class_module_pages_pageelement[] $arrPageElements */
$arrPageElements = array();
foreach ($arrIds as $arrOneRow) {
$arrPageElements[] = new class_module_pages_pageelement($arrOneRow["system_id"]);
}
foreach ($arrPageElements as $objOnePageelement) {
if ($objOnePageelement->getStrPlaceholder() == $strOldPlaceholder) {
$objOnePageelement->setStrPlaceholder($strNewPlaceholder);
if (!$objOnePageelement->updateObjectToDb()) {
$bitReturn = false;
}
}
}
}
}
return $bitReturn;
}
/**
* Return an on-lick link for the passed object.
* This link is rendered by the portal search result generator, so
* make sure the link is a valid portal page.
* If you want to suppress the entry from the result, return an empty string instead.
* If you want to add additional entries to the result set, clone the result and modify
* the new instance to your needs. Pack them in an array and they'll be merged
* into the result set afterwards.
* Make sure to return the passed result-object in this array, too.
*
* @param class_search_result $objResult
*
* @see getLinkPortalHref()
* @return mixed
*/
public function updateSearchResult(class_search_result $objResult)
{
$objORM = new class_orm_objectlist();
$strQuery = "SELECT page_name, guestbook_amount, page_id\n FROM " . _dbprefix_ . "element_guestbook,\n " . _dbprefix_ . "page_element,\n " . _dbprefix_ . "page,\n " . _dbprefix_ . "system\n WHERE guestbook_id = ?\n AND content_id = page_element_id\n AND content_id = system_id\n AND system_prev_id = page_id\n AND system_status = 1\n " . $objORM->getDeletedWhereRestriction() . "\n AND page_element_ph_language = ? ";
$arrRows = $this->objDB->getPArray($strQuery, array($this->getPrevId(), $objResult->getObjSearch()->getStrPortalLangFilter()));
$arrReturn = array();
foreach ($arrRows as $arrOnePage) {
//check, if the post is available on a page using the current language
if (!isset($arrOnePage["page_name"]) || $arrOnePage["page_name"] == "") {
continue;
}
//search pv position
$intAmount = $arrOnePage["guestbook_amount"];
$arrPostsInGB = class_module_guestbook_post::getPosts($this->getPrevId(), true);
$intCounter = 0;
foreach ($arrPostsInGB as $objOnePostInGb) {
$intCounter++;
if ($objOnePostInGb->getSystemid() == $this->getSystemid()) {
break;
}
}
//calculate pv
$intPvPos = ceil($intCounter / $intAmount);
$objNewResult = clone $objResult;
$objNewResult->setStrPagelink(class_link::getLinkPortal($arrOnePage["page_name"], "", "_self", $arrOnePage["page_name"], "", "&highlight=" . urlencode(html_entity_decode($objResult->getObjSearch()->getStrQuery(), ENT_QUOTES, "UTF-8")) . "&pv=" . $intPvPos));
$objNewResult->setStrPagename($arrOnePage["page_name"]);
$objNewResult->setStrDescription($this->getStrGuestbookPostText());
$arrReturn[] = $objNewResult;
}
return $arrReturn;
}
/**
* Return an on-lick link for the passed object.
* This link is rendered by the portal search result generator, so
* make sure the link is a valid portal page.
* If you want to suppress the entry from the result, return an empty string instead.
*
* @param class_search_result $objResult
*
* @see getLinkPortalHref()
* @return mixed
*/
public function updateSearchResult(class_search_result $objResult)
{
$objORM = new class_orm_objectlist();
//search for matching pages
$strQuery = "SELECT page_name, page_id\n FROM " . _dbprefix_ . "element_faqs,\n " . _dbprefix_ . "faqs\n LEFT JOIN " . _dbprefix_ . "faqs_member\n ON (faqsmem_faq = faqs_id),\n " . _dbprefix_ . "page_element,\n " . _dbprefix_ . "page,\n " . _dbprefix_ . "system\n WHERE faqs_id = ?\n AND content_id = page_element_id\n AND content_id = system_id\n AND (\n faqs_category IS NULL OR (\n faqs_category = '0' OR faqs_category = faqsmem_category\n )\n )\n AND system_prev_id = page_id\n AND system_status = 1\n " . $objORM->getDeletedWhereRestriction() . "\n AND page_element_ph_language = ? ";
$arrRows = $this->objDB->getPArray($strQuery, array($this->getSystemid(), $objResult->getObjSearch()->getStrPortalLangFilter()));
$arrReturn = array();
foreach ($arrRows as $arrOnePage) {
//check, if the post is available on a page using the current language
if (!isset($arrOnePage["page_name"]) || $arrOnePage["page_name"] == "") {
continue;
}
$objCurResult = clone $objResult;
$objCurResult->setStrPagelink(class_link::getLinkPortal($arrOnePage["page_name"], "", "_self", $arrOnePage["page_name"], "", "&highlight=" . urlencode(html_entity_decode($objResult->getObjSearch()->getStrQuery(), ENT_QUOTES, "UTF-8"))));
$objCurResult->setStrPagename($arrOnePage["page_name"]);
$objCurResult->setStrDescription($this->getStrQuestion());
$arrReturn[] = $objCurResult;
}
return $arrReturn;
}
/**
* Return an on-lick link for the passed object.
* This link is rendered by the portal search result generator, so
* make sure the link is a valid portal page.
* If you want to suppress the entry from the result, return an empty string instead.
* If you want to add additional entries to the result set, clone the result and modify
* the new instance to your needs. Pack them in an array and they'll be merged
* into the result set afterwards.
* Make sure to return the passed result-object in this array, too.
*
* @param class_search_result $objResult
*
* @see getLinkPortalHref()
* @return mixed
*/
public function updateSearchResult(class_search_result $objResult)
{
$objLanguages = new class_module_languages_language();
$objORM = new class_orm_objectlist();
$strQuery = "SELECT page_name, page_id\r\n FROM " . _dbprefix_ . "element_downloads,\r\n " . _dbprefix_ . "page_element,\r\n " . _dbprefix_ . "page,\r\n " . _dbprefix_ . "system\r\n WHERE download_id = ?\r\n AND content_id = page_element_id\r\n AND content_id = system_id\r\n AND system_prev_id = page_id\r\n AND system_status = 1\r\n " . $objORM->getDeletedWhereRestriction() . "\r\n AND page_element_ph_language = ? ";
$arrRows = $this->objDB->getPArray($strQuery, array($this->getRepositoryId(), $objResult->getObjSearch()->getStrPortalLangFilter()));
$strQuery = "SELECT page_name, page_id\r\n FROM " . _dbprefix_ . "element_gallery,\r\n " . _dbprefix_ . "page_element,\r\n " . _dbprefix_ . "page,\r\n " . _dbprefix_ . "system\r\n WHERE gallery_id = ?\r\n AND content_id = page_element_id\r\n AND content_id = system_id\r\n AND system_prev_id = page_id\r\n AND system_status = 1\r\n " . $objORM->getDeletedWhereRestriction() . "\r\n AND page_element_ph_language = ? ";
$arrRows = array_merge($arrRows, $this->objDB->getPArray($strQuery, array($this->getRepositoryId(), $objLanguages->getStrPortalLanguage())));
$arrReturn = array();
foreach ($arrRows as $arrOnePage) {
if (!isset($arrOnePage["page_name"]) || $arrOnePage["page_name"] == "") {
continue;
}
$objOneResult = clone $objResult;
$objOneResult->setStrPagelink(class_link::getLinkPortal($arrOnePage["page_name"], "", "_self", $this->getStrDisplayName(), "mediaFolder", "&highlight=" . urlencode(html_entity_decode($objResult->getObjSearch()->getStrQuery(), ENT_QUOTES, "UTF-8")), $this->getPrevId(), "", "", $this->getStrDisplayName()));
$objOneResult->setStrPagename($arrOnePage["page_name"]);
$objOneResult->setStrDescription($this->getStrDescription());
$arrReturn[] = $objOneResult;
}
return $arrReturn;
}
/**
* Fetches the records placed as child nodes of the current / passed id.
* <b> Only the IDs are fetched since the current object-context is not available!!! </b>
*
* @param string $strSystemid
* @return string[]
* @deprecated
*/
public function getChildNodesAsIdArray($strSystemid = "")
{
if ($strSystemid == "") {
$strSystemid = $this->getSystemid();
}
$objORM = new class_orm_objectlist();
$strQuery = "SELECT system_id\n FROM " . _dbprefix_ . "system\n WHERE system_prev_id=?\n AND system_id != '0'\n " . $objORM->getDeletedWhereRestriction() . "\n ORDER BY system_sort ASC";
$arrReturn = array();
$arrTemp = $this->objDB->getPArray($strQuery, array($strSystemid));
if (count($arrTemp) > 0) {
foreach ($arrTemp as $arrOneRow) {
$arrReturn[] = $arrOneRow["system_id"];
}
}
return $arrReturn;
}
/**
* Returns the number of tags available
*
* @param string $strUserid
*
* @return int
*/
public static function getNumberOfFavoritesForUser($strUserid)
{
$objORM = new class_orm_objectlist();
$strQuery = "SELECT COUNT(*)\n FROM " . _dbprefix_ . "tags_favorite,\n " . _dbprefix_ . "tags_tag,\n " . _dbprefix_ . "system\n WHERE tags_fav_id = system_id\n AND tags_fav_userid = ?\n AND tags_fav_tagid = tags_tag_id\n " . $objORM->getDeletedWhereRestriction() . "\n ";
$arrRow = class_carrier::getInstance()->getObjDB()->getPRow($strQuery, array($strUserid));
return $arrRow["COUNT(*)"];
}
/**
* Checks, how many locked elements are on this page
*
* @return int
*/
public function getNumberOfLockedElementsOnPage()
{
$objORM = new class_orm_objectlist();
//Check, if there are any Elements on this page
$strQuery = "SELECT COUNT(*)\n\t\t\t\t\t\t FROM " . _dbprefix_ . "system as system\n\t\t\t\t\t\t WHERE system_prev_id=?\n\t\t\t\t\t\t\tAND system_lock_id != ?\n\t\t\t\t\t\t\t" . $objORM->getDeletedWhereRestriction() . "\n\t\t\t\t\t\t\tAND system_lock_id != ? ";
$arrRow = $this->objDB->getPRow($strQuery, array($this->getSystemid(), $this->objSession->getUserID(), "0"));
return $arrRow["COUNT(*)"];
}
/**
* Loads all news from the database
* if passed, the filter is used to load the news of the given category
*
* @param string $strFilter
* @param int $intAmount
*
* @return mixed
* @static
*/
public static function getNewsList($strFilter = "", $intAmount = 0)
{
$objORM = new class_orm_objectlist();
$intNow = class_date::getCurrentTimestamp();
$arrParams = array($intNow, $intNow, $intNow);
if ($strFilter != "") {
$strQuery = "SELECT *\n\t\t\t\t\t\t\tFROM " . _dbprefix_ . "news,\n\t\t\t\t\t\t\t " . _dbprefix_ . "news_member,\n\t\t\t\t\t\t\t " . _dbprefix_ . "system_right,\n\t\t\t\t\t\t\t " . _dbprefix_ . "system\n\t\t\t\t\t LEFT JOIN " . _dbprefix_ . "system_date\n\t\t\t\t\t ON system_id = system_date_id\n\t\t\t\t\t\t\tWHERE system_id = news_id\n\t\t\t\t\t\t\t AND news_id = newsmem_news\n\t\t\t\t\t\t\t AND system_id = right_id\n\t\t\t\t\t\t\t AND system_status = 1\n\t\t\t\t\t\t\t AND (system_date_special IS NULL OR (system_date_special > ? OR system_date_special = 0))\n\t\t\t\t\t\t\t AND (system_date_start IS NULL or(system_date_start < ? OR system_date_start = 0))\n\t\t\t\t\t\t\t AND (system_date_end IS NULL or (system_date_end > ? OR system_date_end = 0))\n\t\t\t\t\t\t\t AND newsmem_category = ?\n\t\t\t\t\t\t\t " . $objORM->getDeletedWhereRestriction() . "\n\t\t\t\t\t\t\tORDER BY system_date_start DESC";
$arrParams[] = $strFilter;
} else {
$strQuery = "SELECT *\n\t\t\t\t\t\t\tFROM " . _dbprefix_ . "news,\n\t\t\t\t\t\t\t " . _dbprefix_ . "system_right,\n\t\t\t\t\t\t\t " . _dbprefix_ . "system\n\t\t\t\t\t\tLEFT JOIN " . _dbprefix_ . "system_date\n\t\t\t\t\t ON system_id = system_date_id\n\t\t\t\t\t\t\tWHERE system_id = news_id\n\t\t\t\t\t\t\t AND system_status = 1\n\t\t\t\t\t\t\t AND system_id = right_id\n\t\t\t\t\t\t\t AND (system_date_special IS NULL OR (system_date_special > ? OR system_date_special = 0))\n\t\t\t\t\t\t\t AND (system_date_start IS NULL or(system_date_start < ? OR system_date_start = 0))\n\t\t\t\t\t\t\t AND (system_date_end IS NULL or (system_date_end > ? OR system_date_end = 0))\n\t\t\t\t\t\t\t " . $objORM->getDeletedWhereRestriction() . "\n\t\t\t\t\t\t\tORDER BY system_date_start DESC";
}
$intStart = null;
$intEnd = null;
if ($intAmount > 0) {
$intStart = 0;
$intEnd = $intAmount - 1;
}
$arrIds = class_carrier::getInstance()->getObjDB()->getPArray($strQuery, $arrParams, $intStart, $intEnd);
class_orm_rowcache::addArrayOfInitRows($arrIds);
$arrReturn = array();
foreach ($arrIds as $arrOneId) {
$arrReturn[] = class_objectfactory::getInstance()->getObject($arrOneId["system_id"]);
}
return $arrReturn;
}
/**
* Return an on-lick link for the passed object.
* This link is rendered by the portal search result generator, so
* make sure the link is a valid portal page.
* If you want to suppress the entry from the result, return an empty string instead.
* If you want to add additional entries to the result set, clone the result and modify
* the new instance to your needs. Pack them in an array and they'll be merged
* into the result set afterwards.
* Make sure to return the passed result-object in this array, too.
*
* @param class_search_result $objResult
*
* @see getLinkPortalHref()
* @return mixed
*/
public function updateSearchResult(class_search_result $objResult)
{
$objORM = new class_orm_objectlist();
$strQuery = "SELECT news_detailspage\n FROM " . _dbprefix_ . "element_news,\n " . _dbprefix_ . "news_member,\n " . _dbprefix_ . "news,\n " . _dbprefix_ . "page_element,\n " . _dbprefix_ . "page,\n " . _dbprefix_ . "system\n WHERE news_id = ?\n AND content_id = page_element_id\n AND content_id = system_id\n AND ( news_category = '0' OR (\n news_category = newsmem_category\n AND newsmem_news = news_id\n )\n )\n AND system_prev_id = page_id\n AND system_status = 1\n AND news_view = 0\n " . $objORM->getDeletedWhereRestriction() . "\n AND page_element_ph_language = ? ";
$arrRows = $this->objDB->getPArray($strQuery, array($this->getSystemid(), $objResult->getObjSearch()->getStrPortalLangFilter()));
$arrReturn = array();
foreach ($arrRows as $arrOnePage) {
//check, if the post is available on a page using the current language
if (!isset($arrOnePage["news_detailspage"]) || $arrOnePage["news_detailspage"] == "") {
continue;
}
$objDetails = class_module_pages_page::getPageByName($arrOnePage["news_detailspage"]);
if ($objDetails == null) {
continue;
}
//TODO: PV position
$objOneResult = clone $objResult;
$objOneResult->setStrPagelink(class_link::getLinkPortal($arrOnePage["news_detailspage"], "", "_self", $this->getStrTitle(), "newsDetail", "&highlight=" . urlencode(html_entity_decode($objResult->getObjSearch()->getStrQuery(), ENT_QUOTES, "UTF-8")), $this->getSystemid()));
$objOneResult->setStrPagename($arrOnePage["news_detailspage"]);
$objOneResult->setStrDescription($this->getStrIntro());
$arrReturn[] = $objOneResult;
}
return $arrReturn;
}
