public function pastEventsCount($data)
{
$erb = new EventRepositoryBuilder();
$erb->setBeforeNow();
$erb->setIncludeCancelled(true);
$erb->setIncludeDeleted(false);
if ($data instanceof \models\AreaModel) {
$erb->setArea($data);
} else {
if ($data instanceof \models\GroupModel) {
$erb->setGroup($data);
} else {
if ($data instanceof \models\TagModel) {
$erb->setTag($data);
}
}
}
return $erb->fetchCount();
}
public static function run(Application $app, $verbose = false)
{
global $CONFIG;
if ($verbose) {
print "Starting " . date("c") . "\n";
}
$userRepo = new UserAccountRepository();
$siteRepo = new SiteRepository();
$groupRepo = new GroupRepository();
$eventRepo = new EventRepository();
$userWatchesGroupRepository = new UserWatchesGroupRepository();
$userWatchesGroupStopRepository = new UserWatchesGroupStopRepository();
$userAccountGeneralSecurityKeyRepository = new UserAccountGeneralSecurityKeyRepository();
$userNotificationRepo = new UserNotificationRepository();
$userHasNoEditorPermissionsInSiteRepo = new UserHasNoEditorPermissionsInSiteRepository();
$userPermissionsRepo = new UserPermissionsRepository($app['extensions']);
/** @var usernotifications/UserWatchesGroupPromptNotificationType **/
$userNotificationType = $app['extensions']->getCoreExtension()->getUserNotificationType('UserWatchesGroupPrompt');
$b = new UserWatchesGroupRepositoryBuilder();
foreach ($b->fetchAll() as $userWatchesGroup) {
$user = $userRepo->loadByID($userWatchesGroup->getUserAccountId());
$group = $groupRepo->loadById($userWatchesGroup->getGroupId());
$site = $siteRepo->loadById($group->getSiteID());
// This is not the most efficient as it involves DB access and the results might not be used. But it'll do for now.
$userPermissions = $userPermissionsRepo->getPermissionsForUserInSite($user, $site, false, true);
if ($verbose) {
print date("c") . " User " . $user->getEmail() . " Site " . $site->getTitle() . " Group " . $group->getTitle() . "\n";
}
// UserWatchesGroupRepositoryBuilder() should only return instances where site is not also watched
if ($site->getIsClosedBySysAdmin()) {
if ($verbose) {
print " ... site is closed\n";
}
} else {
if ($group->getIsDeleted()) {
if ($verbose) {
print " ... group is deleted\n";
}
} else {
if ($userHasNoEditorPermissionsInSiteRepo->isUserInSite($user, $site)) {
if ($verbose) {
print " ... user does not have edit permissions allowed in site\n";
}
} else {
if (!$userPermissions->hasPermission("org.openacalendar", "CALENDAR_CHANGE")) {
if ($verbose) {
print " ... user does not have org.openacalendar/CALENDAR_CHANGE permission in site\n";
}
// Technically UserWatchesSiteRepositoryBuilder() should only return getIsWatching() == true but lets double check
} else {
if ($userWatchesGroup->getIsWatching()) {
if ($verbose) {
print " ... searching for data\n";
}
$lastEvent = $eventRepo->loadLastNonDeletedNonImportedByStartTimeInGroupId($group->getId());
$data = $userWatchesGroup->getPromptEmailData($site, $lastEvent);
if ($data['moreEventsNeeded']) {
if ($verbose) {
print " ... found data\n";
}
///// Notification Class
$userNotification = $userNotificationType->getNewNotification($user, $site);
$userNotification->setGroup($group);
////// Save Notification Class
$userNotificationRepo->create($userNotification);
////// Send Email
if ($userNotification->getIsEmail()) {
$userWatchesGroupStop = $userWatchesGroupStopRepository->getForUserAndGroup($user, $group);
configureAppForSite($site);
configureAppForUser($user);
$userAccountGeneralSecurityKey = $userAccountGeneralSecurityKeyRepository->getForUser($user);
$unsubscribeURL = $CONFIG->getWebIndexDomainSecure() . '/you/emails/' . $user->getId() . '/' . $userAccountGeneralSecurityKey->getAccessKey();
$lastEventsBuilder = new EventRepositoryBuilder();
$lastEventsBuilder->setSite($site);
$lastEventsBuilder->setGroup($group);
$lastEventsBuilder->setOrderByStartAt(true);
$lastEventsBuilder->setIncludeDeleted(false);
$lastEventsBuilder->setIncludeImported(false);
$lastEventsBuilder->setLimit($CONFIG->userWatchesGroupPromptEmailShowEvents);
$lastEvents = $lastEventsBuilder->fetchAll();
$message = \Swift_Message::newInstance();
$message->setSubject("Any news about " . $group->getTitle() . "?");
$message->setFrom(array($CONFIG->emailFrom => $CONFIG->emailFromName));
$message->setTo($user->getEmail());
$messageText = $app['twig']->render('email/userWatchesGroupPromptEmail.txt.twig', array('group' => $group, 'user' => $user, 'lastEvents' => $lastEvents, 'stopCode' => $userWatchesGroupStop->getAccessKey(), 'generalSecurityCode' => $userAccountGeneralSecurityKey->getAccessKey(), 'unsubscribeURL' => $unsubscribeURL));
if ($CONFIG->isDebug) {
file_put_contents('/tmp/userWatchesGroupPromptEmail.txt', $messageText);
}
$message->setBody($messageText);
$messageHTML = $app['twig']->render('email/userWatchesGroupPromptEmail.html.twig', array('group' => $group, 'user' => $user, 'lastEvents' => $lastEvents, 'stopCode' => $userWatchesGroupStop->getAccessKey(), 'generalSecurityCode' => $userAccountGeneralSecurityKey->getAccessKey(), 'unsubscribeURL' => $unsubscribeURL));
if ($CONFIG->isDebug) {
file_put_contents('/tmp/userWatchesGroupPromptEmail.html', $messageHTML);
}
$message->addPart($messageHTML, 'text/html');
$headers = $message->getHeaders();
$headers->addTextHeader('List-Unsubscribe', $unsubscribeURL);
if ($verbose) {
print " ... sending\n";
}
if (!$CONFIG->isDebug) {
$app['mailer']->send($message);
}
$userNotificationRepo->markEmailed($userNotification);
}
$userWatchesGroupRepository->markPromptEmailSent($userWatchesGroup, $data['checkTime']);
}
}
}
}
}
}
}
if ($verbose) {
print "Finished " . date("c") . "\n";
}
}
protected function run()
{
global $CONFIG;
$userRepo = new UserAccountRepository();
$siteRepo = new SiteRepository();
$eventRepo = new EventRepository();
$userWatchesSiteRepository = new UserWatchesSiteRepository();
$userWatchesSiteStopRepository = new UserWatchesSiteStopRepository();
$userAccountGeneralSecurityKeyRepository = new UserAccountGeneralSecurityKeyRepository();
$userNotificationRepo = new UserNotificationRepository();
/** @var usernotifications/UserWatchesSiteGroupPromptNotificationType **/
$userNotificationType = $this->app['extensions']->getCoreExtension()->getUserNotificationType('UserWatchesSiteGroupPrompt');
$b = new UserWatchesSiteRepositoryBuilder();
foreach ($b->fetchAll() as $userWatchesSite) {
$user = $userRepo->loadByID($userWatchesSite->getUserAccountId());
$site = $siteRepo->loadById($userWatchesSite->getSiteId());
$siteRepo->loadLegacyFeaturesOnSite($site);
// to avoid flooding user we only send one group email per run
$anyGroupNotificationsSent = false;
$this->logVerbose(" User " . $user->getEmail() . " Site " . $site->getTitle());
if ($site->getIsClosedBySysAdmin()) {
$this->logVerbose(" ... site is closed");
// Technically UserWatchesSiteRepositoryBuilder() should only return getIsWatching() == true but lets double check
} else {
if ($userWatchesSite->getIsWatching()) {
$groupRepoBuilder = new GroupRepositoryBuilder();
$groupRepoBuilder->setSite($site);
$groupRepoBuilder->setIncludeDeleted(false);
foreach ($groupRepoBuilder->fetchAll() as $group) {
if (!$anyGroupNotificationsSent) {
$this->logVerbose(" ... searching group " . $group->getSlug() . " for data");
$lastEvent = $eventRepo->loadLastNonDeletedNonImportedByStartTimeInGroupId($group->getId());
$data = $userWatchesSite->getGroupPromptEmailData($site, $group, $lastEvent);
if ($data['moreEventsNeeded']) {
$this->logVerbose(" ... found data ");
///// Notification Class
$userNotification = $userNotificationType->getNewNotification($user, $site);
$userNotification->setGroup($group);
////// Save Notification Class
$userNotificationRepo->create($userNotification);
////// Send Email
if ($userNotification->getIsEmail()) {
$userWatchesSiteStop = $userWatchesSiteStopRepository->getForUserAndSite($user, $site);
configureAppForSite($site);
configureAppForUser($user);
$userAccountGeneralSecurityKey = $userAccountGeneralSecurityKeyRepository->getForUser($user);
$unsubscribeURL = $CONFIG->getWebIndexDomainSecure() . '/you/emails/' . $user->getId() . '/' . $userAccountGeneralSecurityKey->getAccessKey();
$lastEventsBuilder = new EventRepositoryBuilder();
$lastEventsBuilder->setSite($site);
$lastEventsBuilder->setGroup($group);
$lastEventsBuilder->setOrderByStartAt(true);
$lastEventsBuilder->setIncludeDeleted(false);
$lastEventsBuilder->setIncludeImported(false);
$lastEventsBuilder->setLimit($CONFIG->userWatchesSiteGroupPromptEmailShowEvents);
$lastEvents = $lastEventsBuilder->fetchAll();
$message = \Swift_Message::newInstance();
$message->setSubject("Any news about " . $group->getTitle() . "?");
$message->setFrom(array($CONFIG->emailFrom => $CONFIG->emailFromName));
$message->setTo($user->getEmail());
$messageText = $this->app['twig']->render('email/userWatchesSiteGroupPromptEmail.txt.twig', array('user' => $user, 'group' => $group, 'lastEvents' => $lastEvents, 'stopCode' => $userWatchesSiteStop->getAccessKey(), 'generalSecurityCode' => $userAccountGeneralSecurityKey->getAccessKey(), 'unsubscribeURL' => $unsubscribeURL));
if ($CONFIG->isDebug) {
file_put_contents('/tmp/userWatchesSiteGroupPromptEmail.txt', $messageText);
}
$message->setBody($messageText);
$messageHTML = $this->app['twig']->render('email/userWatchesSiteGroupPromptEmail.html.twig', array('user' => $user, 'group' => $group, 'lastEvents' => $lastEvents, 'stopCode' => $userWatchesSiteStop->getAccessKey(), 'generalSecurityCode' => $userAccountGeneralSecurityKey->getAccessKey(), 'unsubscribeURL' => $unsubscribeURL));
if ($CONFIG->isDebug) {
file_put_contents('/tmp/userWatchesSiteGroupPromptEmail.html', $messageHTML);
}
$message->addPart($messageHTML, 'text/html');
$headers = $message->getHeaders();
$headers->addTextHeader('List-Unsubscribe', $unsubscribeURL);
$this->logVerbose(" ... sending");
if (!$CONFIG->isDebug) {
$this->app['mailer']->send($message);
}
$userNotificationRepo->markEmailed($userNotification);
}
$userWatchesSiteRepository->markGroupPromptEmailSent($userWatchesSite, $group, $data['checkTime']);
$anyGroupNotificationsSent = true;
}
}
}
}
}
}
return array('result' => 'ok');
}
/**
* This function takes a set of proposed new events in. It looks for any duplicate events already saved and filters them out.
* @return Array New proposed events where duplicates don't exist.
*/
public function filterEventsForExisting(EventModel $sourceEvent, $events)
{
$group = new GroupModel();
$group->setId($sourceEvent->getGroupId());
$out = array();
foreach ($events as $event) {
$erb = new EventRepositoryBuilder();
$erb->setGroup($group);
$erb->setStart($event->getStartAt());
$erb->setEnd($event->getEndAt());
$existingEvents = $erb->fetchAll();
if (count($existingEvents) > 0) {
} else {
$out[] = $event;
}
}
return $out;
}
public function markDuplicateWithMetaData(GroupModel $duplicateGroup, GroupModel $originalGroup, GroupEditMetaDataModel $groupEditMetaDataModel)
{
global $DB;
if ($duplicateGroup->getId() == $originalGroup->getId()) {
return;
}
try {
$DB->beginTransaction();
$duplicateGroup->setIsDeleted(true);
$duplicateGroup->setIsDuplicateOfId($originalGroup->getId());
$this->groupDBAccess->update($duplicateGroup, array('is_deleted', 'is_duplicate_of_id'), $groupEditMetaDataModel);
// Users Watching Group
$ufgr = new UserWatchesGroupRepository();
$usersRepo = new UserAccountRepositoryBuilder();
$usersRepo->setWatchesGroup($duplicateGroup);
foreach ($usersRepo->fetchAll() as $user) {
$ufgr->startUserWatchingGroupIfNotWatchedBefore($user, $originalGroup);
}
// Events in Group
$statCheck = $DB->prepare("SELECT * FROM event_in_group WHERE group_id=:group_id AND " . " event_id=:event_id AND removed_at IS NULL ");
$statAdd = $DB->prepare("INSERT INTO event_in_group (group_id,event_id,added_by_user_account_id,added_at,addition_approved_at,is_main_group) " . "VALUES (:group_id,:event_id,:added_by_user_account_id,:added_at,:addition_approved_at,:is_main_group)");
$erb = new EventRepositoryBuilder();
$erb->setGroup($duplicateGroup);
foreach ($erb->fetchAll() as $event) {
// check event not already in list
$statCheck->execute(array('group_id' => $originalGroup->getId(), 'event_id' => $event->getId()));
if ($statCheck->rowCount() == 0) {
// TODO is_main_group ??????????????????
$statAdd->execute(array('group_id' => $originalGroup->getId(), 'event_id' => $event->getId(), 'is_main_group' => 0, 'added_by_user_account_id' => $user ? $user->getId() : null, 'added_at' => \TimeSource::getFormattedForDataBase(), 'addition_approved_at' => \TimeSource::getFormattedForDataBase()));
}
}
$DB->commit();
} catch (Exception $e) {
$DB->rollBack();
}
}
