protected function run() { $eventHistoryRepo = new EventHistoryRepository(); $stat = $this->app['db']->prepare("SELECT * FROM event_history"); $stat->execute(); $count = 0; while ($data = $stat->fetch()) { $eventHistory = new EventHistoryModel(); $eventHistory->setFromDataBaseRow($data); $eventHistoryRepo->ensureChangedFlagsAreSet($eventHistory); ++$count; } return array('result' => 'ok', 'count' => $count); }
function editFuture($slug, Request $request, Application $app) { if (!$this->build($slug, $request, $app)) { $app->abort(404, "Event does not exist."); } // Event Recur Set $eventRecurSetRepo = new EventRecurSetRepository(); $this->parameters['eventRecurSet'] = $eventRecurSetRepo->loadForEvent($this->parameters['event']); if (!$this->parameters['eventRecurSet']) { return false; // TODO } $this->parameters['eventRecurSet']->setCustomFields($app['currentSite']->getCachedEventCustomFieldDefinitionsAsModels()); // Load history we are working with $eventHistoryRepo = new EventHistoryRepository(); $this->parameters['eventHistory'] = $eventHistoryRepo->loadByEventAndlastEditByUser($this->parameters['event'], $app['currentUser']); if (!$this->parameters['eventHistory']) { return false; // TODO } $eventHistoryRepo->ensureChangedFlagsAreSet($this->parameters['eventHistory']); $this->parameters['eventRecurSet']->setInitalEventLastChange($this->parameters['eventHistory']); // load event before this edit $eventRepo = new EventRepository(); $this->parameters['eventRecurSet']->setInitialEventJustBeforeLastChange($eventRepo->loadEventJustBeforeEdit($this->parameters['event'], $this->parameters['eventHistory'])); // Event & Future Events $this->parameters['eventRecurSet']->setInitalEvent($this->parameters['event']); $eventRB = new EventRepositoryBuilder(); $eventRB->setStartAfter($this->parameters['event']->getStartAtInUTC()); $eventRB->setInSameRecurEventSet($this->parameters['event']); $eventRB->setIncludeDeleted(false); $this->parameters['eventRecurSet']->setFutureEvents($eventRB->fetchAll()); if (!$this->parameters['eventRecurSet']->getFutureEvents()) { return false; // TODO } // Let's check for upgrades, then apply or show user $this->parameters['eventRecurSet']->applyChangeToFutureEvents(); if ($this->parameters['eventRecurSet']->isAnyProposedChangesPossible()) { if ($request->request->get('submitted') == 'cancel' && $request->request->get('CSFRToken') == $app['websession']->getCSFRToken()) { return $app->redirect("/event/" . $this->parameters['event']->getSlugforURL()); } if ($request->request->get('submitted') == 'yes' && $request->request->get('CSFRToken') == $app['websession']->getCSFRToken()) { $eventRepo = new EventRepository(); $countEvents = 0; foreach ($this->parameters['eventRecurSet']->getFutureEvents() as $futureEvent) { $proposedChanges = $this->parameters['eventRecurSet']->getFutureEventsProposedChangesForEventSlug($futureEvent->getSlug()); if ($proposedChanges->getSummaryChangePossible()) { $proposedChanges->setSummaryChangeSelected($request->request->get("eventSlug" . $futureEvent->getSlug() . 'fieldSummary') == 1); } if ($proposedChanges->getDescriptionChangePossible()) { $proposedChanges->setDescriptionChangeSelected($request->request->get("eventSlug" . $futureEvent->getSlug() . 'fieldDescription') == 1); } if ($proposedChanges->getCountryAreaVenueIdChangePossible()) { $proposedChanges->setCountryAreaVenueIdChangeSelected($request->request->get("eventSlug" . $futureEvent->getSlug() . 'fieldCountryAreaVenue') == 1); } if ($proposedChanges->getTimezoneChangePossible()) { $proposedChanges->setTimezoneChangeSelected($request->request->get("eventSlug" . $futureEvent->getSlug() . 'fieldTimezone') == 1); } if ($proposedChanges->getUrlChangePossible()) { $proposedChanges->setUrlChangeSelected($request->request->get("eventSlug" . $futureEvent->getSlug() . 'fieldUrl') == 1); } if ($proposedChanges->getTicketUrlChangePossible()) { $proposedChanges->setTicketUrlChangeSelected($request->request->get("eventSlug" . $futureEvent->getSlug() . 'fieldTicketUrl') == 1); } if ($proposedChanges->getIsVirtualChangePossible()) { $proposedChanges->setIsVirtualChangeSelected($request->request->get("eventSlug" . $futureEvent->getSlug() . 'fieldIsVirtual') == 1); } if ($proposedChanges->getIsPhysicalChangePossible()) { $proposedChanges->setIsPhysicalChangeSelected($request->request->get("eventSlug" . $futureEvent->getSlug() . 'fieldIsPhysical') == 1); } if ($proposedChanges->getIsCancelledChangePossible()) { $proposedChanges->setIsCancelledChangeSelected($request->request->get("eventSlug" . $futureEvent->getSlug() . 'fieldIsCancelled') == 1); } if ($proposedChanges->getStartEndAtChangePossible()) { $proposedChanges->setStartEndAtChangePossible($request->request->get("eventSlug" . $futureEvent->getSlug() . 'fieldStartEnd') == 1); } foreach ($app['currentSite']->getCachedEventCustomFieldDefinitionsAsModels() as $customField) { if ($proposedChanges->getCustomFieldChangePossible($customField)) { $proposedChanges->setCustomFieldChangeSelected($customField, $request->request->get("eventSlug" . $futureEvent->getSlug() . 'fieldCustom' . $customField->getKey()) == 1); } } if ($proposedChanges->applyToEvent($futureEvent, $this->parameters['event'])) { $eventRepo->edit($futureEvent, $app['currentUser'], $this->parameters['eventHistory']); $countEvents++; } } if ($countEvents > 0) { $app['flashmessages']->addMessage($countEvents > 1 ? $countEvents . " future events edited." : "Future event edited."); return $app->redirect("/event/" . $this->parameters['event']->getSlugforURL()); } } // Only pass $futureEvent to the view layer if there are actually changes that can be made. $futureEvents = array(); foreach ($this->parameters['eventRecurSet']->getFutureEvents() as $futureEvent) { if ($this->parameters['eventRecurSet']->getFutureEventsProposedChangesForEventSlug($futureEvent->getSlug())->isAnyChangesPossible()) { $futureEvents[] = $futureEvent; } } $this->parameters['futureEvents'] = $futureEvents; $this->parameters['futureEventsProposedChanges'] = $this->parameters['eventRecurSet']->getFutureEventsProposedChanges(); return $app['twig']->render('site/event/edit.future.html.twig', $this->parameters); } else { return $app->redirect("/event/" . $this->parameters['event']->getSlugforURL()); } }
protected function makeSureHistoriesAreCorrect($contentsToSend) { $eventHistoryRepository = new EventHistoryRepository(); $groupHistoryRepository = new GroupHistoryRepository(); $areaHistoryRepository = new AreaHistoryRepository(); $venueHistoryRepository = new VenueHistoryRepository(); $importURLHistoryRepository = new ImportURLHistoryRepository(); foreach ($contentsToSend as $contentToSend) { foreach ($contentToSend->getHistories() as $history) { $found = false; if ($history instanceof \models\EventHistoryModel) { $eventHistoryRepository->ensureChangedFlagsAreSet($history); $found = true; } elseif ($history instanceof \models\GroupHistoryModel) { $groupHistoryRepository->ensureChangedFlagsAreSet($history); $found = true; } elseif ($history instanceof \models\VenueHistoryModel) { $venueHistoryRepository->ensureChangedFlagsAreSet($history); $found = true; } elseif ($history instanceof \models\AreaHistoryModel) { $areaHistoryRepository->ensureChangedFlagsAreSet($history); $found = true; } elseif ($history instanceof \models\ImportURLHistoryModel) { $importURLHistoryRepository->ensureChangedFlagsAreSet($history); $found = true; } if (!$found) { foreach ($this->app['extensions']->getExtensions() as $extension) { $extension->makeSureHistoriesAreCorrect($history); } } } } }
function testIntegration1() { \TimeSource::mock(2014, 1, 1, 12, 0, 0); $user = new UserAccountModel(); $user->setEmail("*****@*****.**"); $user->setUsername("test"); $user->setPassword("password"); $userRepo = new UserAccountRepository(); $userRepo->create($user); $site = new SiteModel(); $site->setTitle("Test"); $site->setSlug("test"); $siteRepo = new SiteRepository(); $siteRepo->create($site, $user, array(), $this->getSiteQuotaUsedForTesting()); ## Create Event \TimeSource::mock(2014, 1, 1, 13, 0, 0); $event = new EventModel(); $event->setSummary("test"); $event->setDescription("test test"); $event->setStartAt(getUTCDateTime(2014, 9, 1, 1, 1, 1)); $event->setEndAt(getUTCDateTime(2014, 9, 1, 1, 1, 1)); $eventRepo = new EventRepository(); $eventRepo->create($event, $site, $user); ## Edit event \TimeSource::mock(2014, 1, 1, 14, 0, 0); $event = $eventRepo->loadBySlug($site, $event->getSlug()); $event->setDescription("testy 123"); $eventRepo->edit($event, $user); # delete event \TimeSource::mock(2014, 1, 1, 15, 0, 0); $eventRepo->delete($event, $user); ## Now save changed flags on these ..... $eventHistoryRepo = new EventHistoryRepository(); $stat = $this->app['db']->prepare("SELECT * FROM event_history"); $stat->execute(); while ($data = $stat->fetch()) { $eventHistory = new EventHistoryModel(); $eventHistory->setFromDataBaseRow($data); $eventHistoryRepo->ensureChangedFlagsAreSet($eventHistory); } ## Now load and check $historyRepo = new HistoryRepositoryBuilder(); $historyRepo->setSite($site); $historyRepo->setIncludeEventHistory(true); $histories = $historyRepo->fetchAll(); $this->assertEquals(3, count($histories)); #the delete $this->assertEquals(FALSE, $histories[0]->getSummaryChanged()); $this->assertEquals(false, $histories[0]->getDescriptionChanged()); $this->assertEquals(true, $histories[0]->getIsDeletedChanged()); #the edit $this->assertEquals(FALSE, $histories[1]->getSummaryChanged()); $this->assertEquals(true, $histories[1]->getDescriptionChanged()); $this->assertEquals(false, $histories[1]->getIsDeletedChanged()); #the create $this->assertEquals(true, $histories[2]->getSummaryChanged()); $this->assertEquals(true, $histories[2]->getDescriptionChanged()); $this->assertEquals(false, $histories[2]->getIsDeletedChanged()); ## Now load history at a certain point; this is to test rollback! $history = $eventHistoryRepo->loadByEventAndtimeStamp($event, getUTCDateTime(2014, 1, 1, 15, 0, 0)->getTimestamp()); $this->assertEquals("test", $history->getSummary()); $this->assertEquals("testy 123", $history->getDescription()); }
public function testAddCustomFieldThenCreateEventWithContent() { TimeSource::mock(2014, 5, 1, 7, 0, 0); $user = new UserAccountModel(); $user->setEmail("*****@*****.**"); $user->setUsername("test"); $user->setPassword("password"); $userRepo = new UserAccountRepository(); $userRepo->create($user); $site = new SiteModel(); $site->setTitle("Test"); $site->setSlug("test"); $siteRepo = new SiteRepository(); $siteRepo->create($site, $user, array(), $this->getSiteQuotaUsedForTesting()); $customFieldDefinition1 = new EventCustomFieldDefinitionModel(); $customFieldDefinition1->setSiteId($site->getId()); $customFieldDefinition1->setExtensionId('org.openacalendar'); $customFieldDefinition1->setType('TextSingleLine'); $customFieldDefinition1->setKey('cats'); $customFieldDefinition1->setLabel('cats'); $customFieldDefinition2 = new EventCustomFieldDefinitionModel(); $customFieldDefinition2->setSiteId($site->getId()); $customFieldDefinition2->setExtensionId('org.openacalendar'); $customFieldDefinition2->setType('TextSingleLine'); $customFieldDefinition2->setKey('dogs'); $customFieldDefinition2->setLabel('dogs'); $ecfRepo = new EventCustomFieldDefinitionRepository(); $ecfRepo->create($customFieldDefinition1, $user); $ecfRepo->create($customFieldDefinition2, $user); $event = new EventModel(); $event->setSummary("test"); $event->setDescription("test test"); $event->setStartAt(getUTCDateTime(2014, 5, 10, 19, 0, 0)); $event->setEndAt(getUTCDateTime(2014, 5, 10, 21, 0, 0)); $event->setUrl("http://www.info.com"); $event->setTicketUrl("http://www.tickets.com"); $event->setCustomField($customFieldDefinition1, "CATS"); // CREATE WITH TimeSource::mock(2014, 5, 1, 7, 1, 0); $eventRepository = new EventRepository(); $eventRepository->create($event, $site, $user); $event = $eventRepository->loadByID($event->getId()); $this->assertEquals(true, $event->hasCustomField($customFieldDefinition1)); $this->assertEquals(false, $event->hasCustomField($customFieldDefinition2)); $this->assertFalse($event->getIsDeleted()); // LET's CHECK HISTORY $eventHistoryRepo = new EventHistoryRepository(); $stat = $this->app['db']->prepare("SELECT * FROM event_history"); $stat->execute(); while ($data = $stat->fetch()) { $eventHistory = new EventHistoryModel(); $eventHistory->setFromDataBaseRow($data); $eventHistoryRepo->ensureChangedFlagsAreSet($eventHistory); } $eventHistoryRepoBuilder = new EventHistoryRepositoryBuilder(); $eventHistoryRepoBuilder->setEvent($event); $histories = $eventHistoryRepoBuilder->fetchAll(); $this->assertEquals(1, count($histories)); $historyCreate = $histories[0]; $this->assertTrue($historyCreate->getCustomFieldChangedKnown($customFieldDefinition1)); $this->assertTrue($historyCreate->getCustomFieldChanged($customFieldDefinition1)); $this->assertFalse($historyCreate->getCustomFieldChanged($customFieldDefinition2)); }