function test1()
{
$userOwner = new UserAccountModel();
$userOwner->setEmail("*****@*****.**");
$userOwner->setUsername("test2");
$userOwner->setPassword("password");
$user = new UserAccountModel();
$user->setEmail("*****@*****.**");
$user->setUsername("test");
$user->setPassword("password");
$userRepo = new UserAccountRepository();
$userRepo->create($user);
$userRepo->create($userOwner);
$site = new SiteModel();
$site->setTitle("Test");
$site->setSlug("test");
$siteRepo = new SiteRepository();
$siteRepo->create($site, $userOwner, array(), $this->getSiteQuotaUsedForTesting());
$userWatchesSiteRepo = new UserWatchesSiteRepository();
# Part 1: User does not watch site
$t = $userWatchesSiteRepo->loadByUserAndSite($user, $site);
$this->assertNull($t);
$b = new UserWatchesSiteRepositoryBuilder();
$t = $b->fetchAll();
$this->assertEquals(1, count($t));
# Part 2: Watches!
$userWatchesSiteRepo->startUserWatchingSite($user, $site);
$t = $userWatchesSiteRepo->loadByUserAndSite($user, $site);
$this->assertEquals($user->getId(), $t->getUserAccountId());
$this->assertEquals(true, $t->getIsWatching());
$this->assertEquals(true, $t->getIsWasOnceWatching());
$b = new UserWatchesSiteRepositoryBuilder();
$t = $b->fetchAll();
$this->assertEquals(2, count($t));
# Part 3: Stops Watching!
$userWatchesSiteRepo->stopUserWatchingSite($user, $site);
$t = $userWatchesSiteRepo->loadByUserAndSite($user, $site);
$this->assertEquals(false, $t->getIsWatching());
$this->assertEquals(true, $t->getIsWasOnceWatching());
$b = new UserWatchesSiteRepositoryBuilder();
$t = $b->fetchAll();
$this->assertEquals(1, count($t));
}
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();
$userHasNoEditorPermissionsInSiteRepo = new UserHasNoEditorPermissionsInSiteRepository();
$userPermissionsRepo = new UserPermissionsRepository($this->app['extensions']);
/** @var usernotifications/UserWatchesSiteGroupPromptNotificationType **/
$userNotificationType = $this->app['extensions']->getCoreExtension()->getUserNotificationType('UserWatchesSitePrompt');
$b = new UserWatchesSiteRepositoryBuilder();
foreach ($b->fetchAll() as $userWatchesSite) {
$user = $userRepo->loadByID($userWatchesSite->getUserAccountId());
$site = $siteRepo->loadById($userWatchesSite->getSiteId());
$siteRepo->loadLegacyFeaturesOnSite($site);
// 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);
$this->logVerbose(" User " . $user->getEmail() . " Site " . $site->getTitle());
if ($site->getIsClosedBySysAdmin()) {
$this->logVerbose(" ... site is closed");
} else {
if ($userHasNoEditorPermissionsInSiteRepo->isUserInSite($user, $site)) {
$this->logVerbose(" ... user does not have edit permissions allowed in site");
} else {
if (!$userPermissions->hasPermission("org.openacalendar", "CALENDAR_CHANGE")) {
$this->logVerbose(" ... user does not have org.openacalendar/CALENDAR_CHANGE permission in site");
// Technically UserWatchesSiteRepositoryBuilder() should only return getIsWatching() == true but lets double check
} else {
if ($userWatchesSite->getIsWatching()) {
$this->logVerbose(" ... searching for data");
$lastEvent = $eventRepo->loadLastNonDeletedNonImportedByStartTimeInSiteId($site->getId());
$data = $userWatchesSite->getPromptEmailData($site, $lastEvent);
if ($data['moreEventsNeeded']) {
$this->logVerbose(" ... found data");
///// Notification Class
$userNotification = $userNotificationType->getNewNotification($user, $site);
////// 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->setOrderByStartAt(true);
$lastEventsBuilder->setIncludeDeleted(false);
$lastEventsBuilder->setIncludeImported(false);
$lastEventsBuilder->setLimit($CONFIG->userWatchesGroupPromptEmailShowEvents);
$lastEvents = $lastEventsBuilder->fetchAll();
$message = \Swift_Message::newInstance();
$message->setSubject("Any news about " . $site->getTitle() . "?");
$message->setFrom(array($CONFIG->emailFrom => $CONFIG->emailFromName));
$message->setTo($user->getEmail());
$messageText = $this->app['twig']->render('email/userWatchesSitePromptEmail.txt.twig', array('user' => $user, 'lastEvents' => $lastEvents, 'stopCode' => $userWatchesSiteStop->getAccessKey(), 'generalSecurityCode' => $userAccountGeneralSecurityKey->getAccessKey(), 'unsubscribeURL' => $unsubscribeURL));
if ($CONFIG->isDebug) {
file_put_contents('/tmp/userWatchesSitePromptEmail.txt', $messageText);
}
$message->setBody($messageText);
$messageHTML = $this->app['twig']->render('email/userWatchesSitePromptEmail.html.twig', array('user' => $user, 'lastEvents' => $lastEvents, 'stopCode' => $userWatchesSiteStop->getAccessKey(), 'generalSecurityCode' => $userAccountGeneralSecurityKey->getAccessKey(), 'unsubscribeURL' => $unsubscribeURL));
if ($CONFIG->isDebug) {
file_put_contents('/tmp/userWatchesSitePromptEmail.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->markPromptEmailSent($userWatchesSite, $data['checkTime']);
}
}
}
}
}
}
return array('result' => 'ok');
}
function stopWatchingFromEmail($userid, $code, Request $request, Application $app)
{
$userRepo = new UserAccountRepository();
$user = $userRepo->loadByID($userid);
if (!$user) {
$app['monolog']->addError("Failed stop watching site from email - user not known");
die("NO");
// TODO
}
$userWatchesSiteStopRepo = new UserWatchesSiteStopRepository();
$userWatchesSiteStop = $userWatchesSiteStopRepo->loadByUserAccountIDAndSiteIDAndAccessKey($user->getId(), $app['currentSite']->getId(), $code);
if (!$userWatchesSiteStop) {
$app['monolog']->addError("Failed stop watching site from email - user " . $user->getId() . " - code wrong");
die("NO");
// TODO
}
$userWatchesSiteRepo = new UserWatchesSiteRepository();
$userWatchesSite = $userWatchesSiteRepo->loadByUserAndSite($user, $app['currentSite']);
if (!$userWatchesSite || !$userWatchesSite->getIsWatching()) {
$app['monolog']->addError("Failed stop watching site from email - user " . $user->getId() . " - not watching");
die("You don't watch this site");
// TODO
}
if ($request->request->get('action') == 'unwatch' && $request->request->get('CSFRToken') == $app['websession']->getCSFRToken()) {
$userWatchesSiteRepo->stopUserWatchingSite($user, $app['currentSite']);
// redirect here because if we didn't the twig global and $app vars would be wrong (the old state)
// this is an easy way to get round that.
$app['flashmessages']->addMessage("You have stopped watching this.");
return $app->redirect('/');
}
return $app['twig']->render('site/index/stopWatchingFromEmail.html.twig', array('user' => $user));
}
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');
}
}
# ////////////// Features
$siteFeaturesRepo = new repositories\SiteFeatureRepository($app);
$app['currentSiteFeatures'] = new SiteFeaturesList($siteFeaturesRepo->getForSiteAsTree($app['currentSite']));
$app['twig']->addGlobal('currentSiteFeatures', $app['currentSiteFeatures']);
$app['currentSiteFeatures']->setFeaturesOnSite($app['currentSite']);
# ////////////// Permissions and Watch
$userPermissionsRepo = new \repositories\UserPermissionsRepository($app['extensions']);
// We do not check UserHasNoEditorPermissionsInSiteRepository(); because that is site mode only.
// In Single Site mode sysadmins can remove this right.
$app['currentUserPermissions'] = $userPermissionsRepo->getPermissionsForUserInSite($app['currentUser'], $app['currentSite'], false, true);
# ////////////// User and their watch and perms
$app['currentUserActions'] = new UserActionsSiteList($app['currentSite'], $app['currentUserPermissions']);
$app['currentUserWatchesSite'] = false;
if ($app['currentUser']) {
$uwsr = new UserWatchesSiteRepository();
$uws = $uwsr->loadByUserAndSite($app['currentUser'], $app['currentSite']);
$app['currentUserWatchesSite'] = $uws && $uws->getIsWatching();
}
$app['twig']->addGlobal('currentUserActions', $app['currentUserActions']);
$app['twig']->addGlobal('currentUserWatchesSite', $app['currentUserWatchesSite']);
# ////////////// if not current user, let templates see what currentUser could do
if (!$app['currentUser']) {
// We don't pass $removeEditorPermissions here because that is about specific users being banned and this is potential users
$app['anyVerifiedUserPermissions'] = $userPermissionsRepo->getPermissionsForAnyVerifiedUserInSite($app['currentSite'], false, true);
$app['anyVerifiedUserActions'] = new UserActionsSiteList($app['currentSite'], $app['anyVerifiedUserPermissions']);
$app['twig']->addGlobal('anyVerifiedUserActions', $app['anyVerifiedUserActions']);
}
# ////////////// Timezone
$timezone = "";
if (isset($_GET['mytimezone']) && in_array($_GET['mytimezone'], $app['currentSite']->getCachedTimezonesAsList())) {
/**
* One event, 31 days from now, then 30 days, then 29 days, etc, only 1 email sent
* @global type $CONFIG
*/
function test6()
{
global $CONFIG;
$CONFIG->userWatchesPromptEmailSafeGapDays = 30;
\TimeSource::mock(2013, 1, 1, 0, 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());
$group = new GroupModel();
$group->setTitle("Group");
$groupRepo = new GroupRepository();
$groupRepo->create($group, $site, $user);
$event = new EventModel();
$start = \TimeSource::getDateTime();
$start->setDate(2013, 30, 9);
$start->setTime(9, 0, 0);
$event->setStartAt($start);
$end = \TimeSource::getDateTime();
$end->setDate(2013, 30, 9);
$end->setTime(12, 0, 0);
$event->setEndAt($end);
$eventRepo = new EventRepository();
$eventRepo->create($event, $site, $user, $group);
// User will watch site automatically in site->create()
// We don't want that, we want the group instead
$userWatchesSiteRepo = new UserWatchesSiteRepository();
$userWatchesSiteRepo->stopUserWatchingSite($user, $site);
$userWatchesGroupRepo = new UserWatchesGroupRepository();
$userWatchesGroupRepo->startUserWatchingGroup($user, $group);
#Before email sent!
for ($day = 1; $day <= 29; $day++) {
\TimeSource::mock(2013, $day, 8, 1, 0, 0);
$userWatchesGroup = $userWatchesGroupRepo->loadByUserAndGroup($user, $group);
$data = $userWatchesGroup->getPromptEmailData($site, $eventRepo->loadLastNonDeletedNonImportedByStartTimeInGroupId($group->getId()));
$this->assertFalse($data['moreEventsNeeded']);
}
#Email sent!
\TimeSource::mock(2013, 30, 8, 1, 0, 0);
$userWatchesGroup = $userWatchesGroupRepo->loadByUserAndGroup($user, $group);
$data = $userWatchesGroup->getPromptEmailData($site, $eventRepo->loadLastNonDeletedNonImportedByStartTimeInGroupId($group->getId()));
$this->assertTrue($data['moreEventsNeeded']);
$userWatchesGroupRepo->markPromptEmailSent($userWatchesGroup, \TimeSource::getDateTime());
#After email sent
\TimeSource::mock(2013, 31, 8, 1, 0, 0);
$userWatchesGroup = $userWatchesGroupRepo->loadByUserAndGroup($user, $group);
$data = $userWatchesGroup->getPromptEmailData($site, $eventRepo->loadLastNonDeletedNonImportedByStartTimeInGroupId($group->getId()));
$this->assertFalse($data['moreEventsNeeded']);
for ($day = 1; $day <= 30; $day++) {
\TimeSource::mock(2013, $day, 9, 1, 0, 0);
$userWatchesGroup = $userWatchesGroupRepo->loadByUserAndGroup($user, $group);
$data = $userWatchesGroup->getPromptEmailData($site, $eventRepo->loadLastNonDeletedNonImportedByStartTimeInGroupId($group->getId()));
$this->assertFalse($data['moreEventsNeeded']);
}
for ($day = 1; $day <= 31; $day++) {
\TimeSource::mock(2013, $day, 10, 1, 0, 0);
$userWatchesGroup = $userWatchesGroupRepo->loadByUserAndGroup($user, $group);
$data = $userWatchesGroup->getPromptEmailData($site, $eventRepo->loadLastNonDeletedNonImportedByStartTimeInGroupId($group->getId()));
$this->assertFalse($data['moreEventsNeeded']);
}
for ($day = 1; $day <= 30; $day++) {
\TimeSource::mock(2013, $day, 11, 1, 0, 0);
$userWatchesGroup = $userWatchesGroupRepo->loadByUserAndGroup($user, $group);
$data = $userWatchesGroup->getPromptEmailData($site, $eventRepo->loadLastNonDeletedNonImportedByStartTimeInGroupId($group->getId()));
$this->assertFalse($data['moreEventsNeeded']);
}
for ($day = 1; $day <= 31; $day++) {
\TimeSource::mock(2013, $day, 12, 1, 0, 0);
$userWatchesGroup = $userWatchesGroupRepo->loadByUserAndGroup($user, $group);
$data = $userWatchesGroup->getPromptEmailData($site, $eventRepo->loadLastNonDeletedNonImportedByStartTimeInGroupId($group->getId()));
$this->assertFalse($data['moreEventsNeeded']);
}
}
function test2()
{
$userOwner = new UserAccountModel();
$userOwner->setEmail("*****@*****.**");
$userOwner->setUsername("test2");
$userOwner->setPassword("password");
$user = new UserAccountModel();
$user->setEmail("*****@*****.**");
$user->setUsername("test");
$user->setPassword("password");
$userRepo = new UserAccountRepository();
$userRepo->create($user);
$userRepo->create($userOwner);
$site = new SiteModel();
$site->setTitle("Test");
$site->setSlug("test");
$siteRepo = new SiteRepository();
$siteRepo->create($site, $userOwner, array(), $this->getSiteQuotaUsedForTesting());
$group = new GroupModel();
$group->setTitle("test");
$group->setDescription("test test");
$group->setUrl("http://www.group.com");
$groupRepo = new GroupRepository();
$groupRepo->create($group, $site, $userOwner);
$userWatchesgroupRepo = new UserWatchesGroupRepository();
# Part 1: User does not watch group
$t = $userWatchesgroupRepo->loadByUserAndGroup($user, $group);
$this->assertNull($t);
$b = new UserWatchesGroupRepositoryBuilder();
$b->setGroup($group);
$b->setUser($user);
$t = $b->fetchAll();
$this->assertEquals(0, count($t));
# Part 2: Watches!
$userWatchesgroupRepo->startUserWatchingGroup($user, $group);
$t = $userWatchesgroupRepo->loadByUserAndGroup($user, $group);
$this->assertEquals($user->getId(), $t->getUserAccountId());
$this->assertEquals(true, $t->getIsWatching());
$this->assertEquals(true, $t->getIsWasOnceWatching());
$b = new UserWatchesGroupRepositoryBuilder();
$b->setGroup($group);
$b->setUser($user);
$t = $b->fetchAll();
$this->assertEquals(1, count($t));
# Part 3: Starts watching site, automatically stops Watching group as reported by UserWatchesGroupRepositoryBuilder!
$userWatchesSiteRepo = new UserWatchesSiteRepository();
$userWatchesSiteRepo->startUserWatchingSite($user, $site);
$b = new UserWatchesGroupRepositoryBuilder();
$b->setGroup($group);
$b->setUser($user);
$t = $b->fetchAll();
$this->assertEquals(0, count($t));
}
public function markNotificationSent(\DateTime $checkTime)
{
$userWatchesSiteRepository = new UserWatchesSiteRepository();
$userWatchesSite = $userWatchesSiteRepository->loadByUserAndSite($this->userAccount, $this->site);
$userWatchesSiteRepository->markNotifyEmailSent($userWatchesSite, $checkTime);
}
public function getSinceDateForGroupPromptChecking(GroupModel $group)
{
$dates = array($this->created_at);
$userWatchesSiteRepo = new UserWatchesSiteRepository();
$r = $userWatchesSiteRepo->getLastGroupPromptEmailSent($this, $group);
if ($r) {
$dates[] = $r;
}
if ($this->last_watch_started) {
$dates[] = $this->last_watch_started;
}
$date = max($dates);
return $date;
}
