Esempio n. 1
0
 public function fillData($period, $defaultSchedules)
 {
     $usersDao = BOL_UserDao::getInstance();
     $scheduleDao = NOTIFICATIONS_BOL_ScheduleDao::getInstance();
     $query = "REPLACE INTO " . $this->getTableName() . " (`userId`, `timeStamp`) SELECT DISTINCT u.id, UNIX_TIMESTAMP() FROM " . $usersDao->getTableName() . " u\n                    LEFT JOIN " . $scheduleDao->getTableName() . " s ON u.id = s.userId\n                    WHERE (IF( s.schedule IS NULL, :ds, s.schedule )=:as  AND u.activityStamp < :as ) OR IF( s.schedule IS NULL, :ds, s.schedule )=:is ORDER BY u.activityStamp DESC";
     return $this->dbo->query($query, array('as' => time() - $period, 'ds' => $defaultSchedules, 'is' => NOTIFICATIONS_BOL_Service::SCHEDULE_IMMEDIATELY, 'as' => NOTIFICATIONS_BOL_Service::SCHEDULE_AUTO));
 }
Esempio n. 2
0
 public function __construct()
 {
     $this->ruleDao = NOTIFICATIONS_BOL_RuleDao::getInstance();
     $this->unsubscribeDao = NOTIFICATIONS_BOL_UnsubscribeDao::getInstance();
     $this->notificationDao = NOTIFICATIONS_BOL_NotificationDao::getInstance();
     $this->scheduleDao = NOTIFICATIONS_BOL_ScheduleDao::getInstance();
     $this->sendQueueDao = NOTIFICATIONS_BOL_SendQueueDao::getInstance();
 }