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