/** * 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(); }