public function testCopyPage()
{
$strTitle = generateSystemid();
$objPage = new class_module_pages_page();
$objPage->setStrName($strTitle);
$objPage->setStrBrowsername(generateSystemid());
$objPage->setStrSeostring(generateSystemid());
$objPage->setStrDesc(generateSystemid());
$objPage->setStrTemplate("standard.tpl");
$objPage->updateObjectToDb();
$strOldSystemid = $objPage->getSystemid();
$objPagelement = new class_module_pages_pageelement();
$objPagelement->setStrPlaceholder("text_paragraph");
$objPagelement->setStrName("text");
$objPagelement->setStrElement("paragraph");
$objPagelement->updateObjectToDb($objPage->getSystemid());
$objPagelement = new class_module_pages_pageelement($objPagelement->getSystemid());
//and finally create the object
/** @var $objElement class_element_paragraph_admin */
$objElement = $objPagelement->getConcreteAdminInstance();
$objElement->setStrTitle("autotest");
$objElement->doBeforeSaveToDb();
$objElement->updateForeignElement();
$objElement->doAfterSaveToDb();
//copy the page itself
$objPage->copyObject();
$strNewSystemid = $objPage->getSystemid();
$this->flushDBCache();
$objOldPage = new class_module_pages_page($strOldSystemid);
$objNewPage = new class_module_pages_page($strNewSystemid);
$this->assertNotEquals($objOldPage->getStrName(), $objNewPage->getStrName());
$this->assertEquals($objOldPage->getStrBrowsername(), $objNewPage->getStrBrowsername());
$this->assertEquals($objOldPage->getStrSeostring(), $objNewPage->getStrSeostring());
$this->assertEquals($objOldPage->getStrDesc(), $objNewPage->getStrDesc());
$this->assertEquals($objOldPage->getStrTemplate(), $objNewPage->getStrTemplate());
$arrOldElements = class_module_pages_pageelement::getAllElementsOnPage($strOldSystemid);
$arrNewElements = class_module_pages_pageelement::getAllElementsOnPage($strNewSystemid);
$this->assertEquals(count($arrOldElements), count($arrNewElements));
$this->assertEquals(1, count($arrOldElements));
$this->assertEquals(1, count($arrNewElements));
$objOldElement = $arrOldElements[0];
$objNewElement = $arrNewElements[0];
$this->assertEquals($objOldElement->getStrPlaceholder(), $objNewElement->getStrPlaceholder());
$this->assertEquals($objOldElement->getStrLanguage(), $objNewElement->getStrLanguage());
$this->assertEquals($objOldElement->getStrElement(), $objNewElement->getStrElement());
/** @var class_element_paragraph_admin $objOldElementInstance */
$objOldElementInstance = $objOldElement->getConcreteAdminInstance();
$arrOldElementData = $objOldElementInstance->loadElementData();
/** @var class_element_paragraph_admin $objNewElementInstance */
$objNewElementInstance = $objNewElement->getConcreteAdminInstance();
$arrNewElementData = $objNewElementInstance->loadElementData();
$this->assertNotEquals($arrOldElementData["content_id"], $arrNewElementData["content_id"]);
$this->assertEquals($arrOldElementData["paragraph_title"], $arrNewElementData["paragraph_title"]);
$this->assertEquals($objOldElementInstance->getStrTitle(), $objNewElementInstance->getStrTitle());
$this->assertEquals($objOldElementInstance->getStrTitle(), "autotest");
$this->assertEquals($objNewElementInstance->getStrTitle(), "autotest");
$objNewPage->deleteObjectFromDatabase();
$objOldPage->deleteObjectFromDatabase();
}
public function testImportExport()
{
class_carrier::getInstance()->getObjRights()->setBitTestMode(true);
$strName = generateSystemid();
$strBrowsername = generateSystemid();
$strSeoString = generateSystemid();
$strDesc = generateSystemid();
$objPage = new class_module_pages_page();
$objPage->setStrName($strName);
$objPage->setStrBrowsername($strBrowsername);
$objPage->setStrSeostring($strSeoString);
$objPage->setStrDesc($strDesc);
$objPage->setStrTemplate("standard.tpl");
$objPage->updateObjectToDb();
$strPagesystemid = $objPage->getSystemid();
$objPagelement = new class_module_pages_pageelement();
$objPagelement->setStrPlaceholder("text_paragraph");
$objPagelement->setStrName("text");
$objPagelement->setStrElement("paragraph");
$objPagelement->updateObjectToDb($objPage->getSystemid());
$objElement = new class_element_paragraph_admin($objPagelement->getSystemid());
$objElement->setSystemid($objPagelement->getSystemid());
$objElement->loadElementData();
$objElement->setStrTitle("para_title");
$objElement->updateForeignElement();
$objPagelement = new class_module_pages_pageelement($objPagelement->getSystemid());
class_carrier::getInstance()->setParam("pageExport", $strName);
$objPageExport = new class_systemtask_pageexport();
$objPageExport->executeTask();
$objPage->deleteObjectFromDatabase();
class_orm_rowcache::flushCache();
class_db::getInstance()->flushQueryCache();
$this->assertNull(class_module_pages_page::getPageByName($strName));
$this->assertFileExists(_realpath_ . _projectpath_ . "/temp/" . $strPagesystemid . ".xml");
class_carrier::getInstance()->setParam("pageimport_file", _projectpath_ . "/temp/" . $strPagesystemid . ".xml");
$objImport = new class_systemtask_pageimport();
$objImport->executeTask();
$objPage = class_module_pages_page::getPageByName($strName);
$this->assertNotNull($objPage);
$this->assertEquals($objPage->getStrName(), $strName);
$this->assertEquals($objPage->getStrDesc(), $strDesc);
$this->assertEquals($objPage->getStrSeostring(), $strSeoString);
$this->assertEquals($objPage->getStrBrowsername(), $strBrowsername);
$objElements = class_module_pages_pageelement::getAllElementsOnPage($objPage->getSystemid());
$this->assertEquals(1, count($objElements));
$objElements = $objElements[0];
$this->assertEquals($objElements->getStrClassAdmin(), "class_element_paragraph_admin.php");
$objElement = $objElements->getConcreteAdminInstance();
$objElement->setSystemid($objElements->getSystemid());
$objElement->loadElementData();
$this->assertEquals("para_title", $objElement->getStrTitle());
$objPage->deleteObjectFromDatabase();
}
private function processSinglePage($arrPage, $bitReplaceExisting, $strTopFolderId)
{
$strReturn = "";
$arrMetadata = $arrPage["metadata"][0];
$arrElements = $arrPage["elements"][0]["element"];
//create page itself
$strPagename = $arrMetadata["pagename"][0]["value"];
$strPrevId = "";
//check if the exported prev-values may be used
$strImportPrevName = $arrMetadata["prevname"][0]["value"];
if ($strImportPrevName != "") {
$objPage = class_module_pages_page::getPageByName($strImportPrevName);
if ($objPage !== null) {
$strPrevId = $objPage->getSystemid();
}
} elseif (validateSystemid($arrMetadata["previd"][0]["value"])) {
$objRoot = class_objectfactory::getInstance()->getObject($arrMetadata["previd"][0]["value"]);
if ($objRoot !== null) {
$strPrevId = $arrMetadata["previd"][0]["value"];
}
}
if ($strPrevId == "") {
$strPrevId = $strTopFolderId;
}
//check if an existing page should be replaced
if ($bitReplaceExisting) {
$objPage = class_module_pages_page::getPageByName($strPagename);
if ($objPage !== null) {
$strPrevId = $objPage->getPrevId();
$objPage->deleteObject();
}
class_carrier::getInstance()->getObjDB()->flushQueryCache();
}
$objPage = new class_module_pages_page();
$objPage->setStrName($strPagename);
$objPage->updateObjectToDb($strPrevId);
$strPageId = $objPage->getSystemid();
$strReturn .= "created page " . $objPage->getStrName() . "\n";
//save propertysets
$objLanguages = new class_module_languages_language();
$strCurrentLanguage = $objLanguages->getStrAdminLanguageToWorkOn();
$arrPropertysets = $arrMetadata["pageproperties"][0]["propertyset"];
foreach ($arrPropertysets as $arrOnePropSet) {
class_carrier::getInstance()->getObjDB()->flushQueryCache();
$objLanguages->setStrAdminLanguageToWorkOn($arrOnePropSet["attributes"]["language"]);
//reload page to save correct prop-sets
$objPage = new class_module_pages_page($strPageId);
$objPage->setStrLanguage($arrOnePropSet["language"][0]["value"]);
$objPage->setStrBrowsername($arrOnePropSet["browsername"][0]["value"]);
$objPage->setStrDesc($arrOnePropSet["description"][0]["value"]);
$objPage->setStrKeywords($arrOnePropSet["keywords"][0]["value"]);
$objPage->setStrTemplate($arrOnePropSet["template"][0]["value"]);
$objPage->setStrSeostring($arrOnePropSet["seostring"][0]["value"]);
$objPage->setStrLanguage($arrOnePropSet["language"][0]["value"]);
$objPage->setStrAlias($arrOnePropSet["alias"][0]["value"]);
$objPage->setStrTarget($arrOnePropSet["target"][0]["value"]);
$objPage->setStrPath($arrOnePropSet["path"][0]["value"]);
$objPage->updateObjectToDb();
$strReturn .= "saved propertyset for language " . $objPage->getStrLanguage() . "\n";
}
$objLanguages->setStrAdminLanguageToWorkOn($strCurrentLanguage);
//and import each element
foreach ($arrElements as $arrSingleElement) {
//validate if element exists
$strElementName = $arrSingleElement["metadata"][0]["element"][0]["value"];
if (class_module_pages_element::getElement($strElementName) !== null) {
$objElement = new class_module_pages_pageelement();
$objElement->setStrPlaceholder($arrSingleElement["metadata"][0]["placeholder"][0]["value"]);
$objElement->setStrName($arrSingleElement["metadata"][0]["name"][0]["value"]);
$objElement->setStrElement($arrSingleElement["metadata"][0]["element"][0]["value"]);
$objElement->setStrTitle($arrSingleElement["metadata"][0]["title"][0]["value"]);
$objElement->setStrLanguage($arrSingleElement["metadata"][0]["language"][0]["value"]);
$objElement->updateObjectToDb($strPageId);
//and the foreign table
$strTable = $arrSingleElement["foreignTable"][0]["attributes"]["table"];
$arrValues = array();
foreach ($arrSingleElement["foreignTable"][0]["column"] as $arrColumn) {
$arrValues[$arrColumn["attributes"]["name"]] = isset($arrColumn["value"]) ? $arrColumn["value"] : "";
}
unset($arrValues["content_id"]);
//and build the query itself
$strQuery = "UPDATE " . class_carrier::getInstance()->getObjDB()->encloseTableName(_dbprefix_ . $strTable) . " SET ";
$arrInsertValues = array();
$arrEscapes = array();
$arrColumns = class_carrier::getInstance()->getObjDB()->getColumnsOfTable(_dbprefix_ . $strTable);
$arrColumns = array_map(function ($arrColumn) {
return $arrColumn["columnName"];
}, $arrColumns);
foreach ($arrValues as $strColumn => $strValue) {
if (!in_array($strColumn, $arrColumns)) {
continue;
}
$strQuery .= class_carrier::getInstance()->getObjDB()->encloseColumnName($strColumn) . " = ? ,";
$arrInsertValues[] = $strValue;
$arrEscapes[] = false;
}
$strQuery = uniSubstr($strQuery, 0, -1);
$strQuery .= " WHERE content_id = ?";
$arrInsertValues[] = $objElement->getSystemid();
class_carrier::getInstance()->getObjDB()->_pQuery($strQuery, $arrInsertValues, $arrEscapes);
$strReturn .= "created element " . $objElement->getStrName() . "\n";
} else {
$strReturn .= "error: element " . $strElementName . " not existing";
}
}
return $this->objToolkit->getPreformatted(array($strReturn));
}
