public function markDuplicateWithMetaData(AreaModel $duplicateArea, AreaModel $originalArea, AreaEditMetaDataModel $areaEditMetaDataModel)
{
global $DB;
if ($duplicateArea->getId() == $originalArea->getId()) {
return;
}
try {
$DB->beginTransaction();
$duplicateArea->setIsDuplicateOfId($originalArea->getId());
$duplicateArea->setIsDeleted(true);
$this->areaDBAccess->update($duplicateArea, array('is_duplicate_of_id', 'is_deleted'), $areaEditMetaDataModel);
// Move Venues
$venueDBAccess = new VenueDBAccess($DB, new \TimeSource());
$vrb = new VenueRepositoryBuilder();
$vrb->setArea($duplicateArea);
$venueEditMetaData = new VenueEditMetaDataModel();
$venueEditMetaData->setUserAccount($areaEditMetaDataModel->getUserAccount());
foreach ($vrb->fetchAll() as $venue) {
$venue->setAreaId($originalArea->getId());
$venueDBAccess->update($venue, array('area_id'), $venueEditMetaData);
}
// Move Events
$eventRepoBuilder = new EventRepositoryBuilder();
$eventRepoBuilder->setArea($duplicateArea);
$eventDBAccess = new EventDBAccess($DB, new \TimeSource());
$eventEditMetaData = new EventEditMetaDataModel();
$eventEditMetaData->setUserAccount($areaEditMetaDataModel->getUserAccount());
foreach ($eventRepoBuilder->fetchAll() as $event) {
// Check Area actually matches here because we may get events at a venue.
// Based on the order we do things in (ie Move Venue, Move Event) we shouldn't but let's be safe.
if ($event->getAreaId() == $duplicateArea->getId() && $event->getVenueId() == null) {
$event->setAreaId($originalArea->getId());
$eventDBAccess->update($event, array('area_id'), $eventEditMetaData);
}
}
// Move Child Areas
$areaRepoBuilder = new AreaRepositoryBuilder();
$areaRepoBuilder->setParentArea($duplicateArea);
$areaRepoBuilder->setIncludeParentLevels(0);
$flag = false;
foreach ($areaRepoBuilder->fetchAll() as $area) {
// lets just double check we haven't got any child areas.
if ($area->getParentAreaId() == $duplicateArea->getId()) {
$area->setParentAreaId($originalArea->getId());
$this->areaDBAccess->update($area, array('parent_area_id'), $areaEditMetaDataModel);
$flag = true;
}
}
if ($flag) {
// now must clear caches
$this->deleteParentCacheForArea($originalArea);
$this->deleteParentCacheForArea($duplicateArea);
}
$DB->commit();
} catch (Exception $e) {
$DB->rollBack();
}
}
function newEventDraft($draftslug, $stepid, Request $request, Application $app)
{
if (!$this->buildDraft($draftslug, $request, $app)) {
return $app->abort(404);
}
$redirectToStep = $this->buildSteps($stepid, $request, $app);
if ($redirectToStep) {
return $app->redirect("/event/new/" . $this->parameters['draft']->getSlug() . "/" . $redirectToStep);
}
if ($this->parameters['currentStep']->getStepID() == 'preview') {
if ($request->request->get('action') == 'CREATE' && $request->request->get('CSFRToken') == $app['websession']->getCSFRToken()) {
//////////////////////////////////////// Actually Create Event
$event = new EventModel();
$event->setSiteId($app['currentSite']->getId());
foreach ($this->parameters['steps'] as $step) {
$step->addDataToEventBeforeSave($event);
}
$eventEditMetaData = new EventEditMetaDataModel();
$eventEditMetaData->setUserAccount($app['currentUser']);
$eventEditMetaData->setCreatedFromNewEventDraftID($this->parameters['draft']->getId());
if ($request->request->get('edit_comment')) {
$eventEditMetaData->setEditComment($request->request->get('edit_comment'));
}
$repo = new EventRepository();
$repo->createWithMetaData($event, $app['currentSite'], $eventEditMetaData);
if ($app['config']->logFileParseDateTimeRange && $this->parameters['draft']->hasDetailsValue('event.start_end_freetext.done') == 'yes') {
$parseStart = $this->parameters['draft']->getDetailsValueAsDateTime('event.start_end_freetext.start');
$parseEnd = $this->parameters['draft']->getDetailsValueAsDateTime('event.start_end_freetext.end');
$success = $parseStart->getTimestamp() == $event->getStartAt()->getTimestamp() && $parseEnd->getTimestamp() == $event->getEndAt()->getTimestamp();
$handle = fopen($app['config']->logFileParseDateTimeRange, "a");
$now = \TimeSource::getDateTime();
fputcsv($handle, array('Site', $app['currentSite']->getId(), $app['currentSite']->getSlug(), 'Event', $event->getSlug(), 'Now', $now->format("c"), 'Wanted Timezone', $event->getTimezone(), 'Wanted Start UTC', $event->getStartAtInUTC()->format("c"), 'Wanted End UTC', $event->getEndAtInUTC()->format("c"), 'Typed', $this->parameters['draft']->getDetailsValue('event.start_end_freetext.text'), 'Got Start UTC', $parseStart->format("c"), 'Got End UTC', $parseEnd->format("c"), $success ? 'SUCCESS' : 'FAIL'));
fclose($handle);
}
$app['flashmessages']->addMessage("Thanks! The event has been created.");
return $app->redirect('/event/' . $event->getSlugForUrl());
} else {
//////////////////////////////////////// Show Final Preview Screen
$this->parameters['stepsUI'] = (new StepsUI($this->parameters['steps'], $this->parameters['currentStep']))->getSteps();
$this->parameters = array_merge($this->parameters, $this->parameters['currentStep']->onThisStepSetUpPageView());
return $app['twig']->render('site/eventnew/eventDraft.preview.html.twig', $this->parameters);
}
} else {
//////////////////////////////////////// Info needed! Show this step
$this->parameters = array_merge($this->parameters, $this->parameters['currentStep']->onThisStepSetUpPage());
if ($this->parameters['currentStep']->onThisStepProcessPage() && 'POST' == $request->getMethod()) {
$repo = new NewEventDraftRepository();
$repo->saveProgress($this->parameters['draft']);
if ($this->parameters['currentStep']->getIsAllInformationGathered()) {
return $app->redirect('/event/new/' . $this->parameters['draft']->getSlug() . "/" . $this->parameters['nextStepID']);
} else {
// we just have some info, but not all for this step. Stay on this step.
return $app->redirect('/event/new/' . $this->parameters['draft']->getSlug() . "/" . $this->parameters['currentStep']->getStepID());
}
}
$this->parameters = array_merge($this->parameters, $this->parameters['currentStep']->onThisStepSetUpPageView());
$this->parameters['stepsUI'] = (new StepsUI($this->parameters['steps'], $this->parameters['currentStep']))->getSteps();
return $app['twig']->render('site/eventnew/eventDraft.html.twig', $this->parameters);
}
}
function rollback($slug, $timestamp, Request $request, Application $app)
{
if (!$this->build($slug, $request, $app)) {
$app->abort(404, "Event does not exist.");
}
if ($this->parameters['event']->getIsImported()) {
die("No");
// TODO
}
$ehr = new EventHistoryRepository();
$this->parameters['eventHistory'] = $ehr->loadByEventAndtimeStamp($this->parameters['event'], $timestamp);
if (!$this->parameters['eventHistory']) {
$app->abort(404, "Event History does not exist.");
}
$newEventState = clone $this->parameters['event'];
$newEventState->setFromHistory($this->parameters['eventHistory']);
$form = $app['form.factory']->create(new EventEditForm($app['currentSite'], $app['currentTimeZone'], $app), $newEventState);
if ('POST' == $request->getMethod()) {
$form->bind($request);
if ($form->isValid()) {
// Because to undelete or uncancel something, you rollback to a valid state, when you rollback you must set these.
$newEventState->setIsCancelled(false);
$newEventState->setIsDeleted(false);
$eventEditMetaData = new EventEditMetaDataModel();
$eventEditMetaData->setUserAccount($app['currentUser']);
if ($form->has('edit_comment')) {
$eventEditMetaData->setEditComment($form->get('edit_comment')->getData());
}
$eventEditMetaData->setRevertedFromHistoryCreatedAt($this->parameters['eventHistory']->getCreatedAt());
$eventEditMetaData->setFromRequest($request);
$eventRepository = new EventRepository();
$eventRepository->editWithMetaData($newEventState, $eventEditMetaData);
return $app->redirect("/event/" . $this->parameters['event']->getSlugForURL());
}
}
$this->parameters['form'] = $form->createView();
return $app['twig']->render('site/event/rollback.html.twig', $this->parameters);
}
function index($siteid, $slug, Request $request, Application $app)
{
global $CONFIG;
$this->build($siteid, $slug, $request, $app);
$form = $app['form.factory']->create(new ActionForm());
if ('POST' == $request->getMethod()) {
$form->bind($request);
if ($form->isValid()) {
$data = $form->getData();
$action = new ActionParser($data['action']);
if ($action->getCommand() == 'addgroup') {
$gr = new GroupRepository();
$group = $gr->loadBySlug($this->parameters['site'], $action->getParam(0));
if ($group) {
$gr->addEventToGroup($this->parameters['event'], $group, $app['currentUser']);
return $app->redirect('/sysadmin/site/' . $this->parameters['site']->getId() . '/event/' . $this->parameters['event']->getSlug());
}
} else {
if ($action->getCommand() == 'removegroup') {
$gr = new GroupRepository();
$group = $gr->loadBySlug($this->parameters['site'], $action->getParam(0));
if ($group) {
$gr->removeEventFromGroup($this->parameters['event'], $group, $app['currentUser']);
return $app->redirect('/sysadmin/site/' . $this->parameters['site']->getId() . '/event/' . $this->parameters['event']->getSlug());
}
} else {
if ($action->getCommand() == 'maingroup') {
$gr = new GroupRepository();
$group = $gr->loadBySlug($this->parameters['site'], $action->getParam(0));
if ($group) {
$gr->setMainGroupForEvent($group, $this->parameters['event'], $app['currentUser']);
return $app->redirect('/sysadmin/site/' . $this->parameters['site']->getId() . '/event/' . $this->parameters['event']->getSlug());
}
} else {
if ($action->getCommand() == 'delete' && !$this->parameters['event']->getIsDeleted()) {
$er = new EventRepository();
$er->delete($this->parameters['event'], $app['currentUser']);
return $app->redirect('/sysadmin/site/' . $this->parameters['site']->getId() . '/event/' . $this->parameters['event']->getSlug());
} else {
if ($action->getCommand() == 'undelete' && $this->parameters['event']->getIsDeleted()) {
$this->parameters['event']->setIsDeleted(false);
$er = new EventRepository();
$er->undelete($this->parameters['event'], $app['currentUser']);
return $app->redirect('/sysadmin/site/' . $this->parameters['site']->getId() . '/event/' . $this->parameters['event']->getSlug());
} else {
if ($action->getCommand() == 'cancel' && !$this->parameters['event']->getIsDeleted()) {
$er = new EventRepository();
$er->cancel($this->parameters['event'], $app['currentUser']);
return $app->redirect('/sysadmin/site/' . $this->parameters['site']->getId() . '/event/' . $this->parameters['event']->getSlug());
} else {
if ($action->getCommand() == 'uncancel' && $this->parameters['event']->getIsCancelled()) {
$er = new EventRepository();
$er->uncancel($this->parameters['event'], $app['currentUser']);
return $app->redirect('/sysadmin/site/' . $this->parameters['site']->getId() . '/event/' . $this->parameters['event']->getSlug());
} else {
if ($action->getCommand() == 'addcuratedlist') {
$clr = new CuratedListRepository();
$curatedList = $clr->loadBySlug($this->parameters['site'], $action->getParam(0));
if ($curatedList) {
$clr->addEventtoCuratedList($this->parameters['event'], $curatedList, $app['currentUser']);
return $app->redirect('/sysadmin/site/' . $this->parameters['site']->getId() . '/curatedlist/' . $curatedList->getSlug());
}
} else {
if ($action->getCommand() == 'removecuratedlist') {
$clr = new CuratedListRepository();
$curatedList = $clr->loadBySlug($this->parameters['site'], $action->getParam(0));
if ($curatedList) {
$clr->removeEventFromCuratedList($this->parameters['event'], $curatedList, $app['currentUser']);
return $app->redirect('/sysadmin/site/' . $this->parameters['site']->getId() . '/curatedlist/' . $curatedList->getSlug());
}
} else {
if ($action->getCommand() == 'isduplicateof') {
$er = new EventRepository();
$originalEvent = $er->loadBySlug($this->parameters['site'], $action->getParam(0));
if ($originalEvent && $originalEvent->getId() != $this->parameters['event']->getId()) {
$er->markDuplicate($this->parameters['event'], $originalEvent, $app['currentUser']);
return $app->redirect('/sysadmin/site/' . $this->parameters['site']->getId() . '/event/' . $this->parameters['event']->getSlug());
}
} else {
if ($action->getCommand() == 'isnotduplicate') {
$er = new EventRepository();
$eventEditMetaData = new EventEditMetaDataModel();
$eventEditMetaData->setUserAccount($app['currentUser']);
$eventEditMetaData->setFromRequest($request);
$er->markNotDuplicateWithMetaData($this->parameters['event'], $eventEditMetaData);
return $app->redirect('/sysadmin/site/' . $this->parameters['site']->getId() . '/event/' . $this->parameters['event']->getSlug());
} else {
if ($action->getCommand() == 'purge' && $CONFIG->sysAdminExtraPurgeEventPassword && $CONFIG->sysAdminExtraPurgeEventPassword == $action->getParam(0)) {
$er = new EventRepository();
$er->purge($this->parameters['event']);
return $app->redirect('/sysadmin/site/' . $this->parameters['site']->getId() . '/event/');
}
}
}
}
}
}
}
}
}
}
}
}
}
}
$groupRB = new GroupRepositoryBuilder();
$groupRB->setEvent($this->parameters['event']);
$this->parameters['groups'] = $groupRB->fetchAll();
$this->parameters['form'] = $form->createView();
return $app['twig']->render('sysadmin/event/index.html.twig', $this->parameters);
}
/**
* @deprecated
*/
public function markDuplicate(EventModel $duplicateEvent, EventModel $originalEvent, UserAccountModel $user = null)
{
$eventEditMetaDataModel = new EventEditMetaDataModel();
$eventEditMetaDataModel->setUserAccount($user);
$this->markDuplicateWithMetaData($duplicateEvent, $originalEvent, $eventEditMetaDataModel);
}
public function markDuplicateWithMetaData(VenueModel $duplicateVenue, VenueModel $originalVenue, VenueEditMetaDataModel $venueEditMetaDataModel)
{
global $DB;
if ($duplicateVenue->getId() == $originalVenue->getId()) {
return;
}
try {
$DB->beginTransaction();
$duplicateVenue->setIsDeleted(true);
$duplicateVenue->setIsDuplicateOfId($originalVenue->getId());
$this->venueDBAccess->update($duplicateVenue, array('is_deleted', 'is_duplicate_of_id'), $venueEditMetaDataModel);
// Move any Events
$eventEditMetaData = new EventEditMetaDataModel();
$eventEditMetaData->setUserAccount($venueEditMetaDataModel->getUserAccount());
$eventRepoBuilder = new EventRepositoryBuilder();
$eventRepoBuilder->setVenue($duplicateVenue);
$eventDBAccess = new EventDBAccess($DB, new \TimeSource());
foreach ($eventRepoBuilder->fetchAll() as $event) {
$event->setVenueId($originalVenue->getId());
$eventDBAccess->update($event, array('venue_id'), $eventEditMetaData);
}
$DB->commit();
} catch (Exception $e) {
$DB->rollBack();
}
}
public function update(EventModel $event, $fields, EventEditMetaDataModel $eventEditMetaDataModel)
{
$alreadyInTransaction = $this->db->inTransaction();
// Make Information Data
$fieldsSQL1 = array();
$fieldsParams1 = array('id' => $event->getId());
foreach ($fields as $field) {
if ($field == 'custom') {
$fieldsSQL1[] = " custom_fields = :custom_fields ";
$fieldsParams1['custom_fields'] = json_encode($event->getCustomFields());
} else {
$fieldsSQL1[] = " " . $field . "=:" . $field . " ";
if ($field == 'summary') {
$fieldsParams1['summary'] = substr($event->getSummary(), 0, VARCHAR_COLUMN_LENGTH_USED);
} else {
if ($field == 'description') {
$fieldsParams1['description'] = $event->getDescription();
} else {
if ($field == 'start_at') {
$fieldsParams1['start_at'] = $event->getStartAt()->format("Y-m-d H:i:s");
} else {
if ($field == 'end_at') {
$fieldsParams1['end_at'] = $event->getEndAt()->format("Y-m-d H:i:s");
} else {
if ($field == 'venue_id') {
$fieldsParams1['venue_id'] = $event->getVenueId();
} else {
if ($field == 'area_id') {
$fieldsParams1['area_id'] = $event->getAreaId();
} else {
if ($field == 'country_id') {
$fieldsParams1['country_id'] = $event->getCountryId();
} else {
if ($field == 'timezone') {
$fieldsParams1['timezone'] = substr($event->getTimezone(), 0, VARCHAR_COLUMN_LENGTH_USED);
} else {
if ($field == 'url') {
$fieldsParams1['url'] = substr($event->getUrl(), 0, VARCHAR_COLUMN_LENGTH_USED);
} else {
if ($field == 'ticket_url') {
$fieldsParams1['ticket_url'] = substr($event->getTicketUrl(), 0, VARCHAR_COLUMN_LENGTH_USED);
} else {
if ($field == 'is_physical') {
$fieldsParams1['is_physical'] = $event->getIsPhysical() ? 1 : 0;
} else {
if ($field == 'is_virtual') {
$fieldsParams1['is_virtual'] = $event->getIsVirtual() ? 1 : 0;
} else {
if ($field == 'is_cancelled') {
$fieldsParams1['is_cancelled'] = $event->getIsCancelled() ? 1 : 0;
} else {
if ($field == 'is_deleted') {
$fieldsParams1['is_deleted'] = $event->getIsDeleted() ? 1 : 0;
} else {
if ($field == 'is_duplicate_of_id') {
$fieldsParams1['is_duplicate_of_id'] = $event->getIsDuplicateOfId();
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
// Make History Data
$fieldsSQL2 = array('event_id', 'user_account_id', 'created_at', 'approved_at', 'from_ip');
$fieldsSQLParams2 = array(':event_id', ':user_account_id', ':created_at', ':approved_at', ':from_ip');
$fieldsParams2 = array('event_id' => $event->getId(), 'user_account_id' => $eventEditMetaDataModel->getUserAccount() ? $eventEditMetaDataModel->getUserAccount()->getId() : null, 'created_at' => $this->timesource->getFormattedForDataBase(), 'approved_at' => $this->timesource->getFormattedForDataBase(), 'from_ip' => $eventEditMetaDataModel->getIp());
if ($eventEditMetaDataModel->getRevertedFromHistoryCreatedAt()) {
$fieldsSQL2[] = ' reverted_from_created_at ';
$fieldsSQLParams2[] = ' :reverted_from_created_at ';
$fieldsParams2['reverted_from_created_at'] = $eventEditMetaDataModel->getRevertedFromHistoryCreatedAt()->format("Y-m-d H:i:s");
}
if ($eventEditMetaDataModel->getEditComment()) {
$fieldsSQL2[] = ' edit_comment ';
$fieldsSQLParams2[] = ' :edit_comment ';
$fieldsParams2['edit_comment'] = $eventEditMetaDataModel->getEditComment();
}
foreach ($this->possibleFields as $field) {
if (in_array($field, $fields) || $field == 'summary') {
$fieldsSQL2[] = " " . $field . " ";
$fieldsSQLParams2[] = " :" . $field . " ";
if ($field == 'summary') {
$fieldsParams2['summary'] = substr($event->getSummary(), 0, VARCHAR_COLUMN_LENGTH_USED);
} else {
if ($field == 'description') {
$fieldsParams2['description'] = $event->getDescription();
} else {
if ($field == 'start_at') {
$fieldsParams2['start_at'] = $event->getStartAt()->format("Y-m-d H:i:s");
} else {
if ($field == 'end_at') {
$fieldsParams2['end_at'] = $event->getEndAt()->format("Y-m-d H:i:s");
} else {
if ($field == 'venue_id') {
$fieldsParams2['venue_id'] = $event->getVenueId();
} else {
if ($field == 'area_id') {
$fieldsParams2['area_id'] = $event->getAreaId();
} else {
if ($field == 'country_id') {
$fieldsParams2['country_id'] = $event->getCountryId();
} else {
if ($field == 'timezone') {
$fieldsParams2['timezone'] = substr($event->getTimezone(), 0, VARCHAR_COLUMN_LENGTH_USED);
} else {
if ($field == 'url') {
$fieldsParams2['url'] = substr($event->getUrl(), 0, VARCHAR_COLUMN_LENGTH_USED);
} else {
if ($field == 'ticket_url') {
$fieldsParams2['ticket_url'] = substr($event->getTicketUrl(), 0, VARCHAR_COLUMN_LENGTH_USED);
} else {
if ($field == 'is_physical') {
$fieldsParams2['is_physical'] = $event->getIsPhysical() ? 1 : 0;
} else {
if ($field == 'is_virtual') {
$fieldsParams2['is_virtual'] = $event->getIsVirtual() ? 1 : 0;
} else {
if ($field == 'is_cancelled') {
$fieldsParams2['is_cancelled'] = $event->getIsCancelled() ? 1 : 0;
} else {
if ($field == 'is_deleted') {
$fieldsParams2['is_deleted'] = $event->getIsDeleted() ? 1 : 0;
} else {
if ($field == 'is_duplicate_of_id') {
$fieldsParams2['is_duplicate_of_id'] = $event->getIsDuplicateOfId();
}
}
}
}
}
}
}
}
}
}
}
}
}
}
}
$fieldsSQL2[] = " " . $field . "_changed ";
$fieldsSQLParams2[] = " 0 ";
} else {
$fieldsSQL2[] = " " . $field . "_changed ";
$fieldsSQLParams2[] = " -2 ";
}
}
if (in_array("custom", $fields)) {
$fieldsSQL2[] = " custom_fields ";
$fieldsSQLParams2[] = " :custom_fields ";
$fieldsParams2['custom_fields'] = json_encode($event->getCustomFields());
$fieldsSQL2[] = " custom_fields_changed ";
$fieldsSQLParams2[] = " 0 ";
} else {
$fieldsSQL2[] = " custom_fields_changed ";
$fieldsSQLParams2[] = " -2 ";
}
try {
if (!$alreadyInTransaction) {
$this->db->beginTransaction();
}
// Information SQL
$stat = $this->db->prepare("UPDATE event_information SET " . implode(",", $fieldsSQL1) . " WHERE id=:id");
$stat->execute($fieldsParams1);
// History SQL
$stat = $this->db->prepare("INSERT INTO event_history (" . implode(",", $fieldsSQL2) . ") VALUES (" . implode(",", $fieldsSQLParams2) . ")");
$stat->execute($fieldsParams2);
if (!$alreadyInTransaction) {
$this->db->commit();
}
} catch (Exception $e) {
if (!$alreadyInTransaction) {
$this->db->rollBack();
}
throw $e;
}
}
public function testCreateEventThenAddCustomFieldThenAddContent()
{
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());
$ecfRepo = new EventCustomFieldDefinitionRepository();
$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");
// CREATE
TimeSource::mock(2014, 5, 1, 7, 1, 0);
$eventRepository = new EventRepository();
$eventRepository->create($event, $site, $user);
$event = $eventRepository->loadByID($event->getId());
$this->assertFalse($event->getIsDeleted());
// ADD CUSTOM FIELD 1
$customFieldDefinition1 = new EventCustomFieldDefinitionModel();
$customFieldDefinition1->setSiteId($site->getId());
$customFieldDefinition1->setExtensionId('org.openacalendar');
$customFieldDefinition1->setType('TextSingleLine');
$customFieldDefinition1->setKey('cats');
$customFieldDefinition1->setLabel('cats');
$ecfRepo->create($customFieldDefinition1, $user);
// EDIT FIELD 1
TimeSource::mock(2014, 5, 1, 7, 2, 0);
$event = $eventRepository->loadByID($event->getId());
$event->setCustomField($customFieldDefinition1, "CATS");
$eemd = new EventEditMetaDataModel();
$eemd->setUserAccount($user);
$eventRepository->editWithMetaData($event, $eemd);
$event = $eventRepository->loadByID($event->getId());
$this->assertEquals(true, $event->hasCustomField($customFieldDefinition1));
$this->assertFalse($event->getIsDeleted());
// ADD CUSTOM FIELD 2
$customFieldDefinition2 = new EventCustomFieldDefinitionModel();
$customFieldDefinition2->setSiteId($site->getId());
$customFieldDefinition2->setExtensionId('org.openacalendar');
$customFieldDefinition2->setType('TextSingleLine');
$customFieldDefinition2->setKey('dogs');
$customFieldDefinition2->setLabel('dogs');
$ecfRepo->create($customFieldDefinition2, $user);
// EDIT FIELD 2
TimeSource::mock(2014, 5, 1, 7, 3, 0);
$event = $eventRepository->loadByID($event->getId());
$event->setCustomField($customFieldDefinition2, "WOOF");
$eemd = new EventEditMetaDataModel();
$eemd->setUserAccount($user);
$eventRepository->editWithMetaData($event, $eemd);
$event = $eventRepository->loadByID($event->getId());
$this->assertEquals(true, $event->hasCustomField($customFieldDefinition1));
$this->assertEquals(true, $event->hasCustomField($customFieldDefinition2));
$this->assertFalse($event->getIsDeleted());
// DELETE
// this is an edit that should mark custom fields change unknown.
TimeSource::mock(2014, 5, 1, 7, 4, 0);
$event = $eventRepository->loadByID($event->getId());
$eemd = new EventEditMetaDataModel();
$eemd->setUserAccount($user);
$eventRepository->deleteWithMetaData($event, $eemd);
$event = $eventRepository->loadByID($event->getId());
$this->assertTrue($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(4, count($histories));
$historyCreate = $histories[0];
// Check isAnyChangeFlagsUnknown() to test https://github.com/OpenACalendar/OpenACalendar-Web-Core/commit/b2beb50c2c95175db74abe5fef0903ce202f91fa
$this->assertFalse($historyCreate->isAnyChangeFlagsUnknown());
$this->assertTrue($historyCreate->getCustomFieldChangedKnown($customFieldDefinition1));
$this->assertFalse($historyCreate->getCustomFieldChanged($customFieldDefinition1));
$this->assertFalse($historyCreate->getCustomFieldChanged($customFieldDefinition2));
$historyEditField1 = $histories[1];
$this->assertFalse($historyEditField1->isAnyChangeFlagsUnknown());
$this->assertTrue($historyEditField1->getCustomFieldChangedKnown($customFieldDefinition1));
$this->assertTrue($historyEditField1->getCustomFieldChanged($customFieldDefinition1));
$this->assertFalse($historyEditField1->getCustomFieldChanged($customFieldDefinition2));
$this->assertFalse($historyEditField1->getIsDeletedChanged());
$historyEditField2 = $histories[2];
$this->assertFalse($historyEditField2->isAnyChangeFlagsUnknown());
$this->assertTrue($historyEditField2->getCustomFieldChangedKnown($customFieldDefinition1));
$this->assertFalse($historyEditField2->getCustomFieldChanged($customFieldDefinition1));
$this->assertTrue($historyEditField2->getCustomFieldChanged($customFieldDefinition2));
$this->assertFalse($historyEditField2->getIsDeletedChanged());
$historyDelete = $histories[3];
$this->assertFalse($historyDelete->isAnyChangeFlagsUnknown());
$this->assertFalse($historyDelete->getCustomFieldChangedKnown($customFieldDefinition1));
$this->assertFalse($historyDelete->getCustomFieldChanged($customFieldDefinition1));
$this->assertFalse($historyDelete->getCustomFieldChanged($customFieldDefinition2));
$this->assertTrue($historyDelete->getIsDeletedChanged());
}
