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) {
}
}
