public function onVersionMigrate(\Club\InstallerBundle\Event\FilterVersionEvent $event) { if ($event->getVersion()->getVersion() != '20121016161300') { // fit to this version only return; } $repeats = $this->em->getRepository('ClubBookingBundle:PlanRepeat')->findAll(); if (count($repeats) > 0) { // if we already has migrate our booking plans return; } $plans = $this->em->getRepository('ClubBookingBundle:Plan')->findAll(); foreach ($plans as $plan) { $repeat = new \Club\BookingBundle\Entity\PlanRepeat(); $repeat->setPlan($plan); $repeat->setRepeats('weekly'); $repeat->setRepeatOn($plan->getDay()); $repeat->setEndsType('on'); $repeat->setEndsOn($plan->getPeriodEnd()); $repeat->setRepeatEvery(1); $start = clone $plan->getPeriodStart(); $start->setTime($plan->getFirstTime()->format('H'), $plan->getFirstTime()->format('i'), $plan->getFirstTime()->format('s')); $end = clone $plan->getPeriodStart(); $end->setTime($plan->getEndTime()->format('H'), $plan->getEndTime()->format('i'), $plan->getEndTime()->format('s')); $plan->setStart($start); $plan->setEnd($end); $plan->setRepeating(true); $plan->addPlanRepeat($repeat); $this->em->persist($plan); } $dql = "UPDATE ClubBookingBundle:Booking b SET b.status=2"; $r = $this->em->createQuery($dql)->execute(); }
public function onVersionMigrate(\Club\InstallerBundle\Event\FilterVersionEvent $event) { if ($event->getVersion()->getVersion() != '20121016161300') { // fit to this version only return; } $task = $this->em->getRepository('ClubTaskBundle:Task')->findOneBy(array('method' => 'onLogTask')); if ($task) { $this->em->remove($task); } $task = $this->em->getRepository('ClubTaskBundle:Task')->findOneBy(array('method' => 'onLoginAttemptTask')); if ($task) { $this->em->remove($task); } $task = $this->em->getRepository('ClubTaskBundle:Task')->findOneBy(array('method' => 'onBanTask')); if ($task) { $this->em->remove($task); } $tasks = array(array('name' => 'Booking cleanup', 'interval' => 'T1M', 'method' => 'onBookingCleanup'), array('name' => 'Task cleanup', 'interval' => 'T1M', 'method' => 'onTaskCleanup')); foreach ($tasks as $task) { $r = $this->em->getRepository('ClubTaskBundle:Task')->findOneBy(array('method' => $task['method'])); if (!$r) { $t = new \Club\TaskBundle\Entity\Task(); $t->setTaskName($task['name']); $t->setEnabled(1); $t->setLocked(0); $t->setNextRunAt(new \DateTime()); $t->setTaskInterval($task['interval']); $t->setEvent('\\Club\\TaskBundle\\Event\\Events'); $t->setMethod($task['method']); $this->em->persist($t); } } }
public function onVersionMigrate(\Club\InstallerBundle\Event\FilterVersionEvent $event) { if ($event->getVersion()->getVersion() != '20121016161300') { // fit to this version only return; } $rules = $this->em->getRepository('ClubMatchBundle:Rule')->findAll(); foreach ($rules as $r) { $r2 = new \Club\RankingBundle\Entity\Rule(); $r2->setName($r->getName()); $r2->setPointWon($r->getPointWon()); $r2->setPointLost($r->getPointLost()); $r2->setSamePlayer($r->getSamePlayer()); $this->em->persist($r2); } $this->em->flush(); $leagues = $this->em->getRepository('ClubMatchBundle:League')->findAll(); foreach ($leagues as $l) { $r = new \Club\RankingBundle\Entity\Ranking(); $r->setName($l->getName()); $r->setGendeR($l->getGender()); $r->setInviteOnly($l->getInviteOnly()); $r->setGameSet($l->getGameSet()); $r->setType($l->getType()); $r->setStartDate($l->getStartDate()); $r->setEndDate($l->getEndDate()); $rule = $this->em->getRepository('ClubRankingBundle:Rule')->findOneBy(array('name' => $l->getRule()->getName())); $r->setRule($rule); foreach ($r->getUsers() as $u) { $r->addUser($u); } foreach ($l->getMatches() as $m) { $match = new \Club\RankingBundle\Entity\Match(); $match->setMatch($m); $match->setRanking($r); $match->setProcessed(true); $this->em->persist($match); $r->addMatch($match); } $tables = $this->em->getRepository('ClubMatchBundle:LeagueTable')->findBy(array('league' => $l->getId())); foreach ($tables as $t) { $e = new \Club\RankingBundle\Entity\RankingEntry(); $e->setRanking($r); $e->setPlayed($t->getPlayed()); $e->setWon($t->getWon()); $e->setLost($t->getLost()); $e->setPoint($t->getPoint()); $e->setTeam($t->getTeam()); $this->em->persist($e); } $this->em->persist($r); } }
public function onVersionMigrate(\Club\InstallerBundle\Event\FilterVersionEvent $event) { try { if ($event->getVersion()->getVersion() != '20121016161300') { // fit to this version only return; } $products = $this->em->getRepository('ClubShopBundle:Product')->findAll(); foreach ($products as $product) { $product->setActive(true); $this->em->persist($product); } } catch (\Exception $e) { } }
public function onVersionMigrate(\Club\InstallerBundle\Event\FilterVersionEvent $event) { if ($event->getVersion()->getVersion() != '20121016161300') { // fit to this version only return; } try { $events = $this->em->getRepository('ClubEventBundle:Event')->findAll(); foreach ($events as $event) { $date = clone $event->getStartDate(); $date->modify('-1 week'); $event->setLastSubscribe($date); $this->em->persist($event); } } catch (\Exception $e) { } }