function fetchRoles($sectionID)
{
$policies = $roleIDs = $usedRoleIDs = $roles = $roleLimitations = array();
$limitations = eZPolicyLimitation::findByType('Section', $sectionID, true, false);
foreach ($limitations as $policyEntry) {
$policy = $policyEntry->policy();
$policies[] = $policy;
$roleID = $policy->attribute('role_id');
$roleIDs[] = $roleID;
if (!isset($roleLimitations[$roleID])) {
$roleLimitations[$roleID] = array();
}
$roleLimitations[$roleID][] = $policy;
}
foreach ($policies as $policy) {
$roleID = $policy->attribute('role_id');
if (in_array($roleID, $roleIDs) && !in_array($roleID, $usedRoleIDs)) {
$roles[] = $policy->attribute('role');
$usedRoleIDs[] = $roleID;
}
}
return array('result' => array('roles' => $roles, 'limited_policies' => $roleLimitations));
}
function move($newParentNodeID, $nodeID = 0)
{
if ($nodeID == 0) {
$node = $this;
$nodeID = $node->attribute('node_id');
} else {
$node = eZContentObjectTreeNode::fetch($nodeID);
}
$oldPath = $node->attribute('path_string');
$oldParentNodeID = $node->attribute('parent_node_id');
$newParentNodeID = (int) $newParentNodeID;
if ($oldParentNodeID != $newParentNodeID) {
$node->updateAndStoreModified();
// Who moves which content should be logged.
$object = $node->object();
eZAudit::writeAudit('content-move', array('Node ID' => $node->attribute('node_id'), 'Old parent node ID' => $oldParentNodeID, 'New parent node ID' => $newParentNodeID, 'Object ID' => $object->attribute('id'), 'Content Name' => $object->attribute('name'), 'Comment' => 'Moved the node to the given node: eZContentObjectTreeNode::move()'));
$newParentNode = eZContentObjectTreeNode::fetch($newParentNodeID);
$newParentPath = $newParentNode->attribute('path_string');
$newParentDepth = $newParentNode->attribute('depth');
$newPath = $newParentPath . $nodeID;
$oldDepth = $node->attribute('depth');
$oldPathLength = strlen($oldPath);
$moveQuery = "UPDATE\n ezcontentobject_tree\n SET\n parent_node_id = {$newParentNodeID}\n WHERE\n node_id = {$nodeID}";
$db = eZDB::instance();
$subStringString = $db->subString('path_string', $oldPathLength);
$newPathString = $db->concatString(array("'{$newPath}'", $subStringString));
$moveQuery1 = "UPDATE\n ezcontentobject_tree\n SET\n path_identification_string = " . $db->concatString(array("'" . $db->escapeString($newParentNode->PathIdentificationString) . "'", $db->subString("path_identification_string", mb_strlen($node->PathIdentificationString) + 1))) . ",\n path_string = {$newPathString},\n depth = depth + {$newParentDepth} - {$oldDepth} + 1\n WHERE\n path_string LIKE '{$oldPath}%'";
$db->begin();
$db->query($moveQuery);
$db->query($moveQuery1);
/// role system clean up
// Clean up policies and limitations
$expireRoleCache = false;
$limitationsToFix = eZPolicyLimitation::findByType('SubTree', $node->attribute('path_string'), false);
if (count($limitationsToFix) > 0) {
$limitationIDString = $db->generateSQLINStatement($limitationsToFix, 'limitation_id');
$subStringString = $db->subString('value', $oldPathLength);
$newValue = $db->concatString(array("'{$newPath}'", $subStringString));
$query = "UPDATE\n ezpolicy_limitation_value\n SET\n value = {$newValue}\n WHERE\n value LIKE '{$oldPath}%' AND {$limitationIDString}";
$db->query($query);
$expireRoleCache = true;
}
// clean up limitations on role assignment level
$countRows = $db->arrayQuery("SELECT COUNT(*) AS row_count FROM ezuser_role WHERE limit_identifier='Subtree' AND limit_value LIKE '{$oldPath}%'");
$assignmentsToFixCount = $countRows[0]['row_count'];
if ($assignmentsToFixCount > 0) {
$subStringString = $db->subString('limit_value', $oldPathLength);
$newValue = $db->concatString(array("'{$newPath}'", $subStringString));
$db->query("UPDATE\n ezuser_role\n SET\n limit_value = {$newValue}\n WHERE\n limit_identifier='Subtree' AND limit_value LIKE '{$oldPath}%'");
$expireRoleCache = true;
}
if ($expireRoleCache) {
eZRole::expireCache();
}
// Update "is_invisible" node attribute.
$newNode = eZContentObjectTreeNode::fetch($nodeID);
eZContentObjectTreeNode::updateNodeVisibility($newNode, $newParentNode);
$db->commit();
}
}
function canBeRemoved($sectionID = false)
{
if ($sectionID === false) {
$sectionID = $this->attribute('id');
}
$objects = eZPersistentObject::fetchObjectList(eZContentObject::definition(), null, array('section_id' => $sectionID));
$limitations = eZPolicyLimitation::findByType('Section', $sectionID, true, false);
$userRoles = eZRole::fetchRolesByLimitation('section', $sectionID);
if (count($objects) > 0 or count($limitations) > 0 or count($userRoles) > 0) {
return false;
} else {
return true;
}
}
static function cleanupByNode($node)
{
// Clean up role assignments with limitations related to this object
$db = eZDB::instance();
$db->begin();
$pathString = $node->attribute('path_string');
$nodeID = $node->attribute('node_id');
$db->query("DELETE FROM ezuser_role\n WHERE limit_value LIKE '{$pathString}%' AND limit_identifier='Subtree'");
// Clean up subtree limitations related to this object
$limitationsToFix = eZPolicyLimitation::findByType('SubTree', $node->attribute('path_string'), true, true);
foreach ($limitationsToFix as $limitation) {
$values = $limitation->attribute('values');
$valueCount = count($values);
if ($valueCount > 0) {
foreach ($values as $value) {
if (strpos($value->attribute('value'), $node->attribute('path_string')) === 0) {
$value->remove();
$valueCount--;
}
}
}
if ($valueCount == 0) {
$policy = eZPolicy::fetch($limitation->attribute('policy_id'));
if (is_object($policy)) {
$policy->removeThis();
}
}
}
$limitationsToFixNode = eZPolicyLimitation::findByType('Node', $node->attribute('node_id'));
foreach ($limitationsToFixNode as $limitation) {
$values = $limitation->attribute('values');
$valueCount = count($values);
if ($valueCount > 0) {
foreach ($values as $value) {
if ($value->attribute('value') == $node->attribute('node_id')) {
$value->remove();
$valueCount--;
}
}
}
if ($valueCount == 0) {
$policy = eZPolicy::fetch($limitation->attribute('policy_id'));
if (is_object($policy)) {
$policy->removeThis();
}
}
}
eZRole::expireCache();
$db->commit();
}
