/**
* Searches for tags assigned to the systemid to be deleted.
*
* @param string $strEventName
* @param array $arrArguments
*
* @return bool
*/
public function handleEvent($strEventName, array $arrArguments)
{
//unwrap arguments
list($strSystemid, $strSourceClass) = $arrArguments;
$bitReturn = true;
if ($strSourceClass == "class_module_tags_tag" && class_module_system_module::getModuleByName("tags") != null) {
//delete matching favorites
class_orm_base::setObjHandleLogicalDeletedGlobal(class_orm_deletedhandling_enum::INCLUDED());
$arrFavorites = class_module_tags_favorite::getAllFavoritesForTag($strSystemid);
foreach ($arrFavorites as $objOneFavorite) {
if ($strEventName == class_system_eventidentifier::EVENT_SYSTEM_RECORDDELETED_LOGICALLY) {
$bitReturn = $bitReturn && $objOneFavorite->deleteObject();
}
if ($strEventName == class_system_eventidentifier::EVENT_SYSTEM_RECORDDELETED) {
$bitReturn = $bitReturn && $objOneFavorite->deleteObjectFromDatabase();
$bitReturn = $bitReturn && class_carrier::getInstance()->getObjDB()->_pQuery("DELETE FROM " . _dbprefix_ . "tags_member WHERE tags_tagid=?", array($strSystemid));
}
}
class_orm_base::setObjHandleLogicalDeletedGlobal(class_orm_deletedhandling_enum::EXCLUDED());
}
//delete memberships. Fire a plain query, faster then searching.
if ($strEventName == class_system_eventidentifier::EVENT_SYSTEM_RECORDDELETED) {
$bitReturn = $bitReturn && class_carrier::getInstance()->getObjDB()->_pQuery("DELETE FROM " . _dbprefix_ . "tags_member WHERE tags_systemid=?", array($strSystemid));
}
return $bitReturn;
}
/**
* Fetches a list of records currently marked as deleted
*
* @return class_model[]
*/
public static function getDeletedRecords($intStart = null, $intEnd = null)
{
class_orm_base::setObjHandleLogicalDeletedGlobal(class_orm_deletedhandling_enum::INCLUDED());
$strQuery = "SELECT system_id FROM " . _dbprefix_ . "system WHERE system_deleted = 1 ORDER BY system_id DESC";
$arrRows = class_carrier::getInstance()->getObjDB()->getPArray($strQuery, array(), $intStart, $intEnd);
$arrReturn = array();
foreach ($arrRows as $arrOneRow) {
$arrReturn[] = class_objectfactory::getInstance()->getObject($arrOneRow["system_id"]);
}
class_orm_base::setObjHandleLogicalDeletedGlobal(class_orm_deletedhandling_enum::EXCLUDED());
return $arrReturn;
}
/**
* Implementing callback to react on user-delete events
*
* Called whenever a record was deleted using the common methods.
* Implement this method to be notified when a record is deleted, e.g. to to additional cleanups afterwards.
* There's no need to register the listener, this is done automatically.
*
* Make sure to return a matching boolean-value, otherwise the transaction may be rolled back.
*
* @param string $strEventName
* @param array $arrArguments
*
* @return bool
*/
public function handleEvent($strEventName, array $arrArguments)
{
//unwrap arguments
list($strSystemid, $strSourceClass) = $arrArguments;
if ($strSourceClass == "class_module_user_user" && validateSystemid($strSystemid)) {
$objORM = new class_orm_objectlist();
$objORM->addWhereRestriction(new class_orm_objectlist_property_restriction("strUser", class_orm_comparator_enum::Equal(), $strSystemid));
$objORM->setObjHandleLogicalDeleted(class_orm_deletedhandling_enum::INCLUDED());
$arrWidgets = $objORM->getObjectList("class_module_dashboard_widget");
foreach ($arrWidgets as $objWidget) {
$objWidget->deleteObjectFromDatabase();
}
}
return true;
}
/**
* Called whenever a records was deleted using the common methods.
* Implement this method to be notified when a record is deleted, e.g. to to additional cleanups afterwards.
* There's no need to register the listener, this is done automatically.
*
* Make sure to return a matching boolean-value, otherwise the transaction may be rolled back.
*
* @param string $strEventName
* @param array $arrArguments
*
* @return bool
*/
public function handleEvent($strEventName, array $arrArguments)
{
//unwrap arguments
list($strSystemid, $strSourceClass) = $arrArguments;
$bitReturn = true;
//module installed?
if ($strSourceClass == "class_module_postacomment_post" || class_module_system_module::getModuleByName("postacomment") == null) {
return true;
}
$objOrm = new class_orm_objectlist();
$objOrm->setObjHandleLogicalDeleted(class_orm_deletedhandling_enum::INCLUDED());
$objOrm->addWhereRestriction(new class_orm_objectlist_restriction(" AND (postacomment_page = ? OR postacomment_systemid = ? ) ", array($strSystemid, $strSystemid)));
$arrComments = $objOrm->getObjectList("class_module_postacomment_post");
foreach ($arrComments as $objPost) {
if ($strEventName == class_system_eventidentifier::EVENT_SYSTEM_RECORDDELETED_LOGICALLY) {
$objPost->deleteObject();
}
if ($strEventName == class_system_eventidentifier::EVENT_SYSTEM_RECORDDELETED) {
$objPost->deleteObjectFromDatabase();
}
}
return $bitReturn;
}
/**
* Searches for workflows assigned to the systemid to be deleted.
*
* @param string $strEventName
* @param array $arrArguments
*
* @return bool
*/
public function handleEvent($strEventName, array $arrArguments)
{
//unwrap arguments
list($strSystemid, $strSourceClass) = $arrArguments;
$bitReturn = true;
$objORM = new class_orm_objectlist();
$objORM->setObjHandleLogicalDeleted(class_orm_deletedhandling_enum::INCLUDED());
$objORM->addWhereRestriction(new class_orm_objectlist_restriction(" AND workflows_systemid = ?", $strSystemid));
if ($objORM->getObjectCount("class_module_workflows_workflow") == 0) {
return true;
}
class_orm_base::setObjHandleLogicalDeletedGlobal(class_orm_deletedhandling_enum::INCLUDED());
$arrWorkflows = class_module_workflows_workflow::getWorkflowsForSystemid($strSystemid, false);
foreach ($arrWorkflows as $objOneWorkflow) {
if ($strEventName == class_system_eventidentifier::EVENT_SYSTEM_RECORDDELETED_LOGICALLY) {
$bitReturn = $bitReturn && $objOneWorkflow->deleteObject();
}
if ($strEventName == class_system_eventidentifier::EVENT_SYSTEM_RECORDDELETED) {
$bitReturn = $bitReturn && $objOneWorkflow->deleteObjectFromDatabase();
}
}
class_orm_base::setObjHandleLogicalDeletedGlobal(class_orm_deletedhandling_enum::EXCLUDED());
return $bitReturn;
}
public function testLogicalDelete()
{
class_orm_base::setObjHandleLogicalDeletedGlobal(class_orm_deletedhandling_enum::INCLUDED());
$intCountTotal = class_module_system_aspect::getObjectCount();
class_orm_base::setObjHandleLogicalDeletedGlobal(class_orm_deletedhandling_enum::EXCLUDED());
$intCountActive = class_module_system_aspect::getObjectCount();
class_orm_base::setObjHandleLogicalDeletedGlobal(class_orm_deletedhandling_enum::EXCLUSIVE());
$intCountDeleted = class_module_system_aspect::getObjectCount();
class_orm_base::setObjHandleLogicalDeletedGlobal(class_orm_deletedhandling_enum::EXCLUDED());
echo "Creating aspect\n";
$objAspect1 = new class_module_system_aspect();
$objAspect1->setStrName("Dummy");
$objAspect1->updateObjectToDb();
$objAspect = new class_module_system_aspect();
$objAspect->setStrName("logical delete");
$objAspect->updateObjectToDb();
$strAspectId = $objAspect->getSystemid();
$this->assertEquals($intCountActive + 2, class_module_system_aspect::getObjectCount());
$arrAspects = class_module_system_aspect::getObjectList();
$arrAspects = array_filter($arrAspects, function (class_module_system_aspect $objAspect) use($strAspectId) {
return $objAspect->getSystemid() == $strAspectId;
});
$this->assertEquals(1, count($arrAspects));
echo "Deleting logically\n";
$this->assertEquals($objAspect->getIntRecordDeleted(), 0);
$objAspect->deleteObject();
$this->assertEquals($objAspect->getIntRecordDeleted(), 1);
$this->assertEquals($objAspect->getIntSort(), -1);
class_orm_base::setObjHandleLogicalDeletedGlobal(class_orm_deletedhandling_enum::EXCLUDED());
echo "Loading non-deleted only\n";
$this->assertEquals($intCountActive + 1, class_module_system_aspect::getObjectCount());
$arrAspects = class_module_system_aspect::getObjectList();
$arrAspects = array_filter($arrAspects, function (class_module_system_aspect $objAspect) use($strAspectId) {
return $objAspect->getSystemid() == $strAspectId;
});
$this->assertEquals(0, count($arrAspects));
echo "Loading deleted only\n";
class_orm_base::setObjHandleLogicalDeletedGlobal(class_orm_deletedhandling_enum::EXCLUSIVE());
$arrAspects = class_module_system_aspect::getObjectList();
$arrAspects = array_filter($arrAspects, function (class_module_system_aspect $objAspect) use($strAspectId) {
return $objAspect->getSystemid() == $strAspectId;
});
$this->assertEquals($intCountDeleted + 1, class_module_system_aspect::getObjectCount());
$this->assertEquals(1, count($arrAspects));
echo "Loading mixed deleted and non-deleted\n";
class_orm_base::setObjHandleLogicalDeletedGlobal(class_orm_deletedhandling_enum::INCLUDED());
$arrAspects = class_module_system_aspect::getObjectList();
$arrAspects = array_filter($arrAspects, function (class_module_system_aspect $objAspect) use($strAspectId) {
return $objAspect->getSystemid() == $strAspectId;
});
$this->assertEquals($intCountTotal + 2, class_module_system_aspect::getObjectCount());
$this->assertEquals(1, count($arrAspects));
echo "Deleting from database\n";
$objAspect->deleteObjectFromDatabase();
class_orm_base::setObjHandleLogicalDeletedGlobal(class_orm_deletedhandling_enum::EXCLUDED());
echo "Loading non-deleted only\n";
$this->assertEquals($intCountActive + 1, class_module_system_aspect::getObjectCount());
$arrAspects = class_module_system_aspect::getObjectList();
$arrAspects = array_filter($arrAspects, function (class_module_system_aspect $objAspect) use($strAspectId) {
return $objAspect->getSystemid() == $strAspectId;
});
$this->assertEquals(0, count($arrAspects));
echo "Loading deleted only\n";
class_orm_base::setObjHandleLogicalDeletedGlobal(class_orm_deletedhandling_enum::EXCLUSIVE());
$arrAspects = class_module_system_aspect::getObjectList();
$arrAspects = array_filter($arrAspects, function (class_module_system_aspect $objAspect) use($strAspectId) {
return $objAspect->getSystemid() == $strAspectId;
});
$this->assertEquals($intCountDeleted, class_module_system_aspect::getObjectCount());
$this->assertEquals(0, count($arrAspects));
echo "Deleting dummy node directly\n";
$objAspect1->deleteObjectFromDatabase();
echo "Loading non-deleted only\n";
class_orm_base::setObjHandleLogicalDeletedGlobal(class_orm_deletedhandling_enum::EXCLUDED());
$this->assertEquals($intCountActive, class_module_system_aspect::getObjectCount());
echo "Loading deleted only\n";
class_orm_base::setObjHandleLogicalDeletedGlobal(class_orm_deletedhandling_enum::EXCLUSIVE());
$this->assertEquals($intCountDeleted, class_module_system_aspect::getObjectCount());
}
/**
* Triggers the update sequence for assignment properties
* @return bool
*/
private function updateAssignments()
{
$bitReturn = true;
$objReflection = new class_reflection($this->getObjObject());
//get the mapped properties
$arrProperties = $objReflection->getPropertiesWithAnnotation(class_orm_base::STR_ANNOTATION_OBJECTLIST, class_reflection_enum::PARAMS());
foreach ($arrProperties as $strPropertyName => $arrValues) {
$objCfg = class_orm_assignment_config::getConfigForProperty($this->getObjObject(), $strPropertyName);
//try to load the orm config of the arrayObject - if given
$strGetter = $objReflection->getGetter($strPropertyName);
$arrValues = null;
if ($strGetter !== null) {
$arrValues = call_user_func(array($this->getObjObject(), $strGetter));
}
$objAssignmentDeleteHandling = $this->getIntCombinedLogicalDeletionConfig();
if ($arrValues != null && $arrValues instanceof class_orm_assignment_array) {
$objAssignmentDeleteHandling = $arrValues->getObjDeletedHandling();
}
//try to restore the object-set from the database using the same config as when initializing the object
$objOldHandling = $this->getIntCombinedLogicalDeletionConfig();
$this->setObjHandleLogicalDeleted($objAssignmentDeleteHandling);
$arrAssignmentsFromObject = $this->getAssignmentValuesFromObject($strPropertyName, $objCfg->getArrTypeFilter());
$arrAssignmentsFromDatabase = $this->getAssignmentsFromDatabase($strPropertyName);
$this->setObjHandleLogicalDeleted($objOldHandling);
//if the delete handling was set to excluded when loading the assignment, the logically deleted nodes should be merged with the values from db
if ($objAssignmentDeleteHandling->equals(class_orm_deletedhandling_enum::EXCLUDED())) {
$this->setObjHandleLogicalDeleted(class_orm_deletedhandling_enum::EXCLUSIVE());
$arrDeletedIds = $this->getAssignmentsFromDatabase($strPropertyName);
$this->setObjHandleLogicalDeleted($objOldHandling);
foreach ($arrDeletedIds as $strOneId) {
if (!in_array($strOneId, $arrAssignmentsFromDatabase)) {
$arrAssignmentsFromDatabase[] = $strOneId;
}
if (!in_array($strOneId, $arrAssignmentsFromObject)) {
$arrAssignmentsFromObject[] = $strOneId;
}
}
}
sort($arrAssignmentsFromObject);
sort($arrAssignmentsFromDatabase);
//only do s.th. if the array differs
$arrNewAssignments = array_diff($arrAssignmentsFromObject, $arrAssignmentsFromDatabase);
$arrDeletedAssignments = array_diff($arrAssignmentsFromDatabase, $arrAssignmentsFromObject);
//skip in case there's nothing to do
if (count($arrNewAssignments) == 0 && count($arrDeletedAssignments) == 0) {
continue;
}
$objDB = class_carrier::getInstance()->getObjDB();
$arrInserts = array();
foreach ($arrAssignmentsFromObject as $strOneTargetId) {
$arrInserts[] = array($this->getObjObject()->getSystemid(), $strOneTargetId);
}
$bitReturn = $bitReturn && $objDB->_pQuery("DELETE FROM " . $objDB->encloseTableName(_dbprefix_ . $objCfg->getStrTableName()) . " WHERE " . $objDB->encloseColumnName($objCfg->getStrSourceColumn()) . " = ?", array($this->getObjObject()->getSystemid()));
$bitReturn = $bitReturn && $objDB->multiInsert($objCfg->getStrTableName(), array($objCfg->getStrSourceColumn(), $objCfg->getStrTargetColumn()), $arrInserts);
$bitReturn = $bitReturn && class_core_eventdispatcher::getInstance()->notifyGenericListeners(class_system_eventidentifier::EVENT_SYSTEM_OBJECTASSIGNMENTSUPDATED, array(array_values($arrNewAssignments), array_values($arrDeletedAssignments), array_values($arrAssignmentsFromObject), $this->getObjObject(), $strPropertyName));
if ($objReflection->hasPropertyAnnotation($strPropertyName, class_module_system_changelog::ANNOTATION_PROPERTY_VERSIONABLE)) {
$objChanges = new class_module_system_changelog();
$objChanges->setOldValueForSystemidAndProperty($this->getObjObject()->getSystemid(), $strPropertyName, implode(",", $arrAssignmentsFromDatabase));
}
}
return $bitReturn;
}
/**
* Generates the where restriction for queries, based on the current config.
* Currently the methods returns a string based where restriction.
*
* @param string $strSystemTablePrefix
* @param string $strConjunction
* @return string
*/
public function getDeletedWhereRestriction($strSystemTablePrefix = "", $strConjunction = "AND")
{
$strQuery = "";
if ($strSystemTablePrefix != "") {
$strSystemTablePrefix = $strSystemTablePrefix . ".";
}
if (self::$bitLogcialDeleteAvailable) {
if ($this->getIntCombinedLogicalDeletionConfig()->equals(class_orm_deletedhandling_enum::EXCLUDED())) {
$strQuery .= " " . $strConjunction . " {$strSystemTablePrefix}system_deleted = 0 ";
} else {
if ($this->getIntCombinedLogicalDeletionConfig()->equals(class_orm_deletedhandling_enum::EXCLUSIVE())) {
$strQuery .= " " . $strConjunction . " {$strSystemTablePrefix}system_deleted = 1 ";
}
}
}
return $strQuery;
}
/**
* Removes the current package, if possible, from the system
*
* @param string &$strLog
*
* @return bool
*/
public function remove(&$strLog)
{
class_orm_base::setObjHandleLogicalDeletedGlobal(class_orm_deletedhandling_enum::INCLUDED());
if (!$this->isRemovable()) {
return false;
}
/** @var class_module_packagemanager_template[] $arrTemplates */
$arrTemplates = class_module_packagemanager_template::getObjectList();
foreach ($arrTemplates as $objOneTemplate) {
if ($objOneTemplate->getStrName() == $this->getObjMetadata()->getStrTitle()) {
return $objOneTemplate->deleteObjectFromDatabase();
}
}
class_orm_base::setObjHandleLogicalDeletedGlobal(class_orm_deletedhandling_enum::EXCLUDED());
return false;
}
public function testLogicalDeleteLoadHandling()
{
$objDB = class_carrier::getInstance()->getObjDB();
/** @var orm_objectlist_testclass $objTestobject */
$objTestobject = $this->getObject("testobject");
$arrAspects = array($this->getObject("aspect1"), $this->getObject("aspect2"), $this->getObject("aspect3"));
$objTestobject->setArrObject1($arrAspects);
$objTestobject->updateObjectToDb();
$arrRow = $objDB->getPRow("SELECT COUNT(*) FROM " . _dbprefix_ . "testclass_rel WHERE testclass_source_id = ?", array($objTestobject->getSystemid()));
$this->assertEquals(3, $arrRow["COUNT(*)"]);
//delete one aspect logically
$arrAspects[1]->deleteObject();
$objTestobject = new orm_objectlist_testclass($objTestobject->getSystemid());
$this->assertEquals(count($objTestobject->getArrObject1()), 2);
class_orm_base::setObjHandleLogicalDeletedGlobal(class_orm_deletedhandling_enum::INCLUDED());
$objTestobject = new orm_objectlist_testclass($objTestobject->getSystemid());
class_orm_base::setObjHandleLogicalDeletedGlobal(null);
$this->assertEquals(count($objTestobject->getArrObject1()), 3);
class_orm_base::setObjHandleLogicalDeletedGlobal(class_orm_deletedhandling_enum::EXCLUSIVE());
$objTestobject = new orm_objectlist_testclass($objTestobject->getSystemid());
class_orm_base::setObjHandleLogicalDeletedGlobal(null);
$this->assertEquals(count($objTestobject->getArrObject1()), 1);
$this->assertEquals($objTestobject->getArrObject1()[0]->getSystemid(), $arrAspects[1]->getSystemid());
class_orm_base::setObjHandleLogicalDeletedGlobal(null);
$objTestobject = new orm_objectlist_testclass($objTestobject->getSystemid());
class_orm_base::setObjHandleLogicalDeletedGlobal(null);
$this->assertEquals(count($objTestobject->getArrObject1()), 2);
$this->assertTrue(in_array($objTestobject->getArrObject1()[0]->getSystemid(), array($arrAspects[0]->getSystemid(), $arrAspects[2]->getSystemid())));
}
/**
* Restores a single object
*
* @permissions right1,delete
* @return string
* @throws class_exception
*/
protected function actionFinalDeleteRecord()
{
if ($this->getParam("delete") == "") {
class_orm_base::setObjHandleLogicalDeletedGlobal(class_orm_deletedhandling_enum::INCLUDED());
$objRecord = class_objectfactory::getInstance()->getObject($this->getSystemid());
$strReturn = $this->objToolkit->formHeader(class_link::getLinkAdminHref($this->getArrModule("modul"), "finalDeleteRecord"));
$strReturn .= $this->objToolkit->warningBox($this->getLang("final_delete_question", array($objRecord->getStrDisplayName())), "alert-danger");
$strReturn .= $this->objToolkit->formInputSubmit($this->getLang("final_delete_submit"));
$strReturn .= $this->objToolkit->formInputHidden("systemid", $this->getParam("systemid"));
$strReturn .= $this->objToolkit->formInputHidden("delete", "1");
$strReturn .= $this->objToolkit->formClose();
return $strReturn;
} else {
class_orm_base::setObjHandleLogicalDeletedGlobal(class_orm_deletedhandling_enum::INCLUDED());
$objRecord = class_objectfactory::getInstance()->getObject($this->getSystemid());
if ($objRecord !== null && !$objRecord->rightDelete()) {
throw new class_exception($this->getLang("commons_error_permissions"), class_exception::$level_ERROR);
}
$objRecord->deleteObjectFromDatabase();
$this->adminReload(class_link::getLinkAdminHref($this->getArrModule("modul"), "deletedRecords"));
}
return "";
}
/**
* @param class_module_packagemanager_metadata $objMetadata
*
* @throws class_exception
* @return string
*/
public function removePackage(class_module_packagemanager_metadata $objMetadata)
{
$strLog = "";
class_orm_base::setObjHandleLogicalDeletedGlobal(class_orm_deletedhandling_enum::INCLUDED());
$objHandler = $this->getPackageManagerForPath($objMetadata->getStrPath());
if ($objHandler->isRemovable()) {
$objHandler->remove($strLog);
}
class_orm_base::setObjHandleLogicalDeletedGlobal(class_orm_deletedhandling_enum::EXCLUDED());
class_resourceloader::getInstance()->flushCache();
return $strLog;
}
