/**
* Rejects a registration.
*
* @param Registration $registration
*/
public function rejectRegistration(Registration $registration)
{
$registration->setPending(false);
$registration->setRejected(true);
$this->em->persist($registration);
$this->em->flush();
}
public function userDataProvider()
{
$pendingRegistration = new Registration();
$pendingRegistration->setBaseId(1);
$pendingRegistration->setUser(new User());
$pendingRegistration->setPending(true);
$pendingRegistration->setRejected(false);
$rejectedRegistration = new Registration();
$rejectedRegistration->setBaseId(1);
$rejectedRegistration->setUser(new User());
$rejectedRegistration->setPending(true);
$rejectedRegistration->setRejected(true);
$databox = current((new \appbox(new Application(Application::ENV_TEST)))->get_databoxes());
$collection = current($databox->get_collections());
$noLimitedPendingRegistration = [[$databox->get_sbas_id() => [$collection->get_base_id() => ['base-id' => $collection->get_base_id(), 'db-name' => 'toto', 'active' => true, 'time-limited' => false, 'in-time' => null, 'registration' => $pendingRegistration]]], 'pending', 1];
$rejectedRegistration = [[$databox->get_sbas_id() => [$collection->get_base_id() => ['base-id' => $collection->get_base_id(), 'db-name' => 'titi', 'active' => true, 'time-limited' => false, 'in-time' => null, 'registration' => $rejectedRegistration]]], 'rejected', 1];
$noActiveRegistration = [[$databox->get_sbas_id() => [$collection->get_base_id() => ['base-id' => 1, 'db-name' => 'tutu', 'active' => false, 'time-limited' => false, 'in-time' => null, 'registration' => $pendingRegistration]]], 'inactive', 1];
$limitedActiveIntimePendingRegistration = [[$databox->get_sbas_id() => [$collection->get_base_id() => ['base-id' => $collection->get_base_id(), 'db-name' => 'tata', 'active' => true, 'time-limited' => true, 'in-time' => true, 'registration' => $pendingRegistration]]], 'in-time', 1];
$limitedActiveOutdatedPendingRegistration = [[$databox->get_sbas_id() => [$collection->get_base_id() => ['base-id' => $collection->get_base_id(), 'db-name' => 'toutou', 'active' => true, 'time-limited' => true, 'in-time' => false, 'registration' => $pendingRegistration]]], 'out-time', 1];
return [$noLimitedPendingRegistration, $noActiveRegistration, $limitedActiveIntimePendingRegistration, $limitedActiveOutdatedPendingRegistration, $rejectedRegistration];
}
/**
* {@inheritdoc}
*/
public function apply(base $appbox, Application $app)
{
$em = $app['orm.em'];
$sql = "SELECT date_modif, usr_id, base_id, en_cours, refuser\n FROM demand";
$rsm = new ResultSetMapping();
$rsm->addScalarResult('base_id', 'base_id');
$rsm->addScalarResult('en_cours', 'en_cours');
$rsm->addScalarResult('refuser', 'refuser');
$rsm->addScalarResult('usr_id', 'usr_id');
$rsm->addScalarResult('date_modif', 'date_modif');
$rs = $em->createNativeQuery($sql, $rsm)->getResult();
$n = 0;
foreach ($rs as $row) {
try {
$user = $em->createQuery('SELECT PARTIAL u.{id} FROM Phraseanet:User s WHERE u.id = :id')->setParameters(['id' => $row['usr_id']])->setHint(Query::HINT_FORCE_PARTIAL_LOAD, true)->getSingleResult();
} catch (NoResultException $e) {
$app['monolog']->addInfo(sprintf('Patch %s : Registration for user (%s) could not be turn into doctrine entity as user could not be found.', $this->get_release(), $row['usr_id']));
continue;
}
try {
$collection = \collection::get_from_base_id($app, $row['base_id']);
} catch (\Exception $e) {
$app['monolog']->addInfo(sprintf('Patch %s : Registration for user (%s) could not be turn into doctrine entity as base with id (%s) could not be found.', $this->get_release(), $row['usr_id'], $row['base_id']));
continue;
}
$registration = new Registration();
$registration->setCollection($collection);
$registration->setUser($user);
$registration->setPending($row['en_cours']);
$registration->setCreated(new \DateTime($row['date_modif']));
$registration->setRejected($row['refuser']);
if ($n % 100 === 0) {
$em->flush();
$em->clear();
}
$n++;
}
$em->flush();
$em->clear();
}
