public function importDirectoriesFromCsv($file)
{
$data = file_get_contents($file);
$data = $this->container->get('claroline.utilities.misc')->formatCsvOutput($data);
$lines = str_getcsv($data, PHP_EOL);
$this->om->startFlushSuite();
$i = 0;
$resourceType = $this->om->getRepository('ClarolineCoreBundle:Resource\\ResourceType')->findOneByName('directory');
foreach ($lines as $line) {
$values = str_getcsv($line, ';');
$code = $values[0];
$workspace = $this->om->getRepository('ClarolineCoreBundle:Workspace\\Workspace')->findOneByCode($code);
$name = $values[1];
$directory = $this->om->getRepository('ClarolineCoreBundle:Resource\\ResourceNode')->findOneBy(['workspace' => $workspace, 'name' => $name, 'resourceType' => $resourceType]);
if (!$directory) {
$directory = new Directory();
$directory->setName($name);
$this->log("Create directory {$name} for workspace {$code}");
$this->create($directory, $resourceType, $workspace->getCreator(), $workspace, $this->getWorkspaceRoot($workspace));
++$i;
} else {
$this->log("Directory {$name} already exists for workspace {$code}");
}
if ($i % 100 === 0) {
$this->om->forceFlush();
$this->om->clear();
$resourceType = $this->om->getRepository('ClarolineCoreBundle:Resource\\ResourceType')->findOneByName('directory');
$this->om->merge($resourceType);
}
}
$this->om->endFlushSuite();
}
public function checkIntegrity()
{
$this->log('Checking roles integrity for resources... This may take a while.');
$workspaceManager = $this->container->get('claroline.manager.workspace_manager');
$workspaces = $this->om->getRepository('Claroline\\CoreBundle\\Entity\\Workspace\\Workspace')->findAll();
$this->om->startFlushSuite();
$i = 0;
foreach ($workspaces as $workspace) {
$this->log('Checking ' . $workspace->getCode() . '...');
$roles = $workspace->getRoles();
$root = $this->container->get('claroline.manager.resource_manager')->getWorkspaceRoot($workspace);
$collaboratorRole = $this->roleManager->getCollaboratorRole($workspace);
if ($root && $collaboratorRole) {
$collaboratorFound = false;
foreach ($root->getRights() as $right) {
if ($right->getRole()->getName() == $this->roleManager->getCollaboratorRole($workspace)->getName()) {
$collaboratorFound = true;
}
}
if (!$collaboratorFound) {
$this->log('Adding missing right on root for ' . $workspace->getCode() . '.', LogLevel::DEBUG);
$collaboratorRole = $this->roleManager->getCollaboratorRole($workspace);
$this->editPerms(5, $collaboratorRole, $root, true, array(), true);
$i++;
if ($i % 3 === 0) {
$this->log('flushing...');
$this->om->forceFlush();
$this->om->clear();
}
}
}
}
$this->om->endFlushSuite();
}
/**
* Import a workspace list from a csv data.
*
* @param array $workspaces
*/
public function importWorkspaces(array $workspaces, $logger = null)
{
//$this->om->clear();
$ds = DIRECTORY_SEPARATOR;
$i = 0;
$j = 0;
$workspaceModelManager = $this->container->get('claroline.manager.workspace_model_manager');
foreach ($workspaces as $workspace) {
$this->om->startFlushSuite();
$model = null;
$name = $workspace[0];
$code = $workspace[1];
$isVisible = $workspace[2];
$selfRegistration = $workspace[3];
$registrationValidation = $workspace[4];
$selfUnregistration = $workspace[5];
$errors = array();
if (isset($workspace[6]) && trim($workspace[6]) !== '') {
$user = $this->om->getRepository('ClarolineCoreBundle:User')->findOneByUsername($workspace[6]);
} else {
$user = $this->container->get('security.context')->getToken()->getUser();
}
if (isset($workspace[7])) {
$model = $this->om->getRepository('ClarolineCoreBundle:Model\\WorkspaceModel')->findOneByName($workspace[7]);
}
if ($model) {
$guid = $this->ut->generateGuid();
$workspace = new Workspace();
$this->createWorkspace($workspace);
$workspace->setName($name);
$workspace->setCode($code);
$workspace->setDisplayable($isVisible);
$workspace->setSelfRegistration($selfRegistration);
$workspace->setSelfUnregistration($selfUnregistration);
$workspace->setRegistrationValidation($registrationValidation);
$workspace->setGuid($guid);
$date = new \Datetime(date('d-m-Y H:i'));
$workspace->setCreationDate($date->getTimestamp());
$workspace->setCreator($user);
$workspaceModelManager->addDataFromModel($model, $workspace, $user, $errors);
} else {
//this should be changed later
$configuration = new Configuration($this->templateDir . $ds . 'default.zip');
$configuration->setWorkspaceName($name);
$configuration->setWorkspaceCode($code);
$configuration->setDisplayable($isVisible);
$configuration->setSelfRegistration($selfRegistration);
$configuration->setSelfUnregistration($registrationValidation);
$this->container->get('claroline.manager.transfert_manager')->createWorkspace($configuration, $user);
}
$i++;
$j++;
if ($i % self::MAX_WORKSPACE_BATCH_SIZE === 0) {
$this->om->forceFlush();
$this->om->clear();
}
$this->om->endFlushSuite();
}
}
public function import(array $data)
{
$this->om->startFlushSuite();
//this is the root of the unzipped archive
$rootPath = $this->getRootPath();
$exoPath = $data['data']['exercise']['path'];
$newExercise = $this->createExo($data['data']['exercise'], $this->qtiRepository->getQtiUser());
if (file_exists($rootPath . '/' . $exoPath)) {
$this->createQuestion($data['data']['steps'], $newExercise, $rootPath . '/' . $exoPath);
}
$this->om->endFlushSuite();
$this->om->forceFlush();
return $newExercise;
}
/**
* Insert the resource $resource at the 'index' position
*
* @param ResourceNode $node
* @param integer $next
*
* @return ResourceNode
*/
public function insertAtIndex(ResourceNode $node, $index)
{
//throw new \Exception($index);
$this->om->startFlushSuite();
if ($index > $node->getIndex()) {
$this->shiftLeftAt($node->getParent(), $index);
$node->setIndex($index);
} else {
$this->shiftRightAt($node->getParent(), $index);
$node->setIndex($index);
}
$this->om->persist($node);
$this->om->forceFlush();
$this->reorder($node->getParent());
$this->om->endFlushSuite();
}
public function createOrderedToolByToolForAllUsers(LoggerInterface $logger, Tool $tool, $type = 0, $isVisible = true)
{
$toolName = $tool->getName();
$usersQuery = $this->userRepo->findAllEnabledUsers(false);
$users = $usersQuery->iterate();
$this->om->startFlushSuite();
$index = 0;
$countUser = $this->userRepo->countAllEnabledUsers();
$logger->info(sprintf("%d users to check tools on.", $countUser));
foreach ($users as $row) {
$user = $row[0];
/** @var \Claroline\CoreBundle\Entity\Tool\OrderedTool[] $orderedTools */
$orderedTools = $this->orderedToolRepo->findOrderedToolsByToolAndUser($tool, $user, $type);
if (count($orderedTools) === 0) {
$orderedTool = new OrderedTool();
$orderedTool->setName($toolName);
$orderedTool->setTool($tool);
$orderedTool->setUser($user);
$orderedTool->setVisibleInDesktop($isVisible);
$orderedTool->setOrder(1);
$orderedTool->setType($type);
$this->om->persist($orderedTool);
$index++;
if ($index % 100 === 0) {
$this->om->forceFlush();
$this->om->clear($orderedTool);
$logger->info(sprintf(" %d users checked.", 100));
}
} else {
$orderedTool = $orderedTools[0];
if ($orderedTool->isVisibleInDesktop() !== $isVisible) {
$orderedTool->setVisibleInDesktop($isVisible);
$this->om->persist($orderedTool);
$index++;
if ($index % 100 === 0) {
$this->om->forceFlush();
$this->om->clear($orderedTool);
$logger->info(sprintf(" %d users checked.", 100));
}
}
}
}
if ($index % 100 !== 0) {
$logger->info(sprintf(" %d users checked.", 100 - $index));
}
$this->om->endFlushSuite();
}
/**
* Import a workspace list from a csv data.
*
* @param array $workspaces
*/
public function importWorkspaces(array $workspaces, $logger = null, $update = false)
{
$i = 0;
$workspaceModelManager = $this->container->get('claroline.manager.workspace_model_manager');
foreach ($workspaces as $workspace) {
++$i;
$this->om->startFlushSuite();
$endDate = null;
$model = null;
$name = $workspace[0];
$code = $workspace[1];
$isVisible = $workspace[2];
$selfRegistration = $workspace[3];
$registrationValidation = $workspace[4];
$selfUnregistration = $workspace[5];
if (isset($workspace[6]) && trim($workspace[6]) !== '') {
$user = $this->om->getRepository('ClarolineCoreBundle:User')->findOneByUsername($workspace[6]);
} else {
$user = $this->container->get('security.context')->getToken()->getUser();
}
if (isset($workspace[7])) {
$model = $this->om->getRepository('ClarolineCoreBundle:Model\\WorkspaceModel')->findOneByName($workspace[7]);
}
if (isset($workspace[8])) {
$endDate = new \DateTime();
$endDate->setTimestamp($workspace[8]);
}
if ($update) {
$workspace = $this->getOneByCode($code);
if (!$workspace) {
//if the workspace doesn't exists, just keep going...
continue;
}
if ($logger) {
$logger('Updating ' . $code . ' (' . $i . '/' . count($workspaces) . ') ...');
}
} else {
$workspace = new Workspace();
}
$workspace->setName($name);
$workspace->setCode($code);
$workspace->setDisplayable($isVisible);
$workspace->setSelfRegistration($selfRegistration);
$workspace->setSelfUnregistration($selfUnregistration);
$workspace->setRegistrationValidation($registrationValidation);
$workspace->setCreator($user);
if ($endDate) {
$workspace->setEndDate($endDate);
}
if (!$update) {
if ($logger) {
$logger('Creating ' . $code . ' (' . $i . '/' . count($workspaces) . ') ...');
}
if ($model) {
$guid = $this->ut->generateGuid();
$this->createWorkspace($workspace);
$workspace->setGuid($guid);
$date = new \Datetime(date('d-m-Y H:i'));
$workspace->setCreationDate($date->getTimestamp());
$workspaceModelManager->addDataFromModel($model, $workspace, $user);
} else {
$template = new File($this->container->getParameter('claroline.param.default_template'));
$this->container->get('claroline.manager.transfer_manager')->createWorkspace($workspace, $template, true);
}
} else {
if ($model) {
$workspaceModelManager->updateDataFromModel($model, $workspace);
}
}
$this->om->persist($workspace);
$logger('UOW: ' . $this->om->getUnitOfWork()->size());
if ($i % 100 === 0) {
$this->om->forceFlush();
$user = $this->om->getRepository('ClarolineCoreBundle:User')->find($user->getId());
$this->om->merge($user);
$this->om->refresh($user);
}
}
$logger('Final flush...');
$this->om->endFlushSuite();
}
