protected function migrateFileSetManagerPermissions($fsID, FileFolder $folder)
{
$this->output(t('Migrating file set permissions...'));
$r = $this->connection->executeQuery('select fpa.*, pk.pkHandle from FileSetPermissionAssignments fpa inner join PermissionKeys pk on fpa.pkID = pk.pkID where fsID = ?', array($fsID));
$permissionsMap = array('view_file_set_file' => 'view_file_folder_file', 'search_file_set' => 'search_file_folder', 'edit_file_set_file_properties' => 'edit_file_folder_file_properties', 'edit_file_set_file_contents' => 'edit_file_folder_file_contents', 'edit_file_set_permissions' => 'edit_file_folder_permissions', 'copy_file_set_files' => 'copy_file_folder_files', 'delete_file_set' => 'delete_file_folder', 'delete_file_set_files' => 'delete_file_folder_files', '_add_file' => 'add_file');
$count = $this->connection->fetchColumn('select count(*) from TreeNodePermissionAssignments where treeNodeID = ?', array($folder->getTreeNodeID()));
if (!$count) {
$folder->setTreeNodePermissionsToOverride();
$this->connection->executeQuery('delete from TreeNodePermissionAssignments where treeNodeID = ?', array($folder->getTreeNodeID()));
while ($row = $r->fetch()) {
$mapped = $permissionsMap[$row['pkHandle']];
$newPKID = $this->connection->fetchColumn('select pkID from PermissionKeys where pkHandle = ?', array($mapped));
$v = array($folder->getTreeNodeID(), $newPKID, $row['paID']);
$this->connection->executeQuery('insert into TreeNodePermissionAssignments (treeNodeID, pkID, paID) values (?, ?, ?)', $v);
}
// Add edit file folder.
$pk1 = Key::getByHandle('edit_file_folder_permissions');
$pk2 = Key::getByHandle('edit_file_folder');
$pk1->setPermissionObject($folder);
$pk2->setPermissionObject($folder);
$pa = $pk1->getPermissionAccessObject();
if (is_object($pa)) {
$pt = $pk2->getPermissionAssignmentObject();
$pt->clearPermissionAssignment();
$pt->assignPermissionAccess($pa);
}
}
}
public function setFileFolder(FileFolder $folder)
{
$db = Loader::db();
$em = \ORM::entityManager('core');
$this->folderTreeNodeID = $folder->getTreeNodeID();
$em->persist($this);
$em->flush();
}
