private function insertRoles()
{
/** @var \Doctrine\ORM\EntityManager $em */
$em = $this->getDoctrine()->getManager();
$roles = $this->container->getParameter('roles');
$role_repo = $em->getRepository('OjsUserBundle:Role');
$return = [];
foreach ($roles as $role) {
$new_role = new Role();
$check = $role_repo->findOneBy(array('role' => $role['role']));
if (!empty($check)) {
continue;
}
$return[] = "Added : {$role['role']}";
$new_role->setName($role['desc']);
$new_role->setRole($role['role']);
$em->persist($new_role);
}
$em->flush();
return implode("\n", $return);
}
/**
* Imports users of the given journal
* @param int $newJournalId New journal's ID
* @param int $oldJournalId Old journal's ID
* @param UserImporter $userImporter User importer class
* @throws \Doctrine\DBAL\DBALException
*/
public function importJournalUsers($newJournalId, $oldJournalId, $userImporter)
{
$this->em->clear();
$journal = $this->em->getRepository('OjsJournalBundle:Journal')->find($newJournalId);
$roleMap = ['1' => "ROLE_ADMIN", '2' => "ROLE_USER", '10' => "ROLE_JOURNAL_MANAGER", '100' => "ROLE_EDITOR", '200' => 'ROLE_SECTION_EDITOR', '300' => 'ROLE_LAYOUT_EDITOR', '1000' => "ROLE_REVIEWER", '2000' => 'ROLE_COPYEDITOR', '3000' => "ROLE_PROOFREADER", '10000' => "ROLE_AUTHOR", '100000' => 'ROLE_READER', '200000' => "ROLE_SUBSCRIPTION_MANAGER"];
// Replace role names with role entities
foreach ($roleMap as $id => $name) {
$role = $this->em->getRepository('OjsUserBundle:Role')->findOneBy(['role' => $name]);
if (!$role) {
$role = new Role();
$role->setName($name);
$role->setRole($name);
}
$roleMap[$id] = $role;
}
$roleStatement = $this->dbalConnection->prepare("SELECT roles.journal_id, roles.user_id, roles.role_id, users.email FROM " . "roles JOIN users ON roles.user_id = users.user_id WHERE roles.journal_id" . "= :id " . ImportHelper::spamUsersFilterSql());
$roleStatement->bindValue('id', $oldJournalId);
$roleStatement->execute();
$roles = $roleStatement->fetchAll();
$cache = array();
foreach ($roles as $role) {
$email = $role['email'];
// Put the user from DB to cache
if (empty($cache[$email]['user'])) {
$cache[$email]['user'] = $this->em->getRepository('OjsUserBundle:User')->findOneBy(['email' => $email]);
}
// Create the user and put it to cache
if (empty($cache[$email]['user'])) {
$cache[$email]['user'] = $userImporter->importUser($role['user_id'], false);
}
/** @var JournalUser $journalUser */
$journalUser = $this->getJournalUser($cache, $email, $journal);
$journalUser->addRole($roleMap[dechex($role['role_id'])]);
}
$this->consoleOutput->writeln("Writing data...");
$this->em->flush();
$this->consoleOutput->writeln("Imported users.");
}
/**
* @param OutputInterface $output
*/
public function insertRoles(OutputInterface $output)
{
$doctrine = $this->getContainer()->get('doctrine');
$em = $doctrine->getManager();
$roles = $this->getContainer()->getParameter('roles');
$role_repo = $doctrine->getRepository('OjsUserBundle:Role');
foreach ($roles as $role) {
$new_role = new Role();
$check = $role_repo->findOneBy(array('role' => $role['role']));
if (!empty($check)) {
$output->writeln('<error> This role record already exists on db </error> : <info>' . $role['role'] . '</info>');
continue;
}
$output->writeln('<info>Added : ' . $role['role'] . '</info>');
$new_role->setName($role['desc']);
$new_role->setRole($role['role']);
$em->persist($new_role);
}
$em->flush();
}
