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