classes/conference/NotificationStatusDAO.inc.php

Go to the documentation of this file.

<?php

//$Id$

class NotificationStatusDAO extends DAO {
   function &getSchedConfNotifications($userId) {
      $returner = array();

      $result =& $this->retrieve(
         'SELECT j.sched_conf_id AS sched_conf_id, n.sched_conf_id AS notification FROM sched_confs j LEFT JOIN notification_status n ON j.sched_conf_id = n.sched_conf_id AND n.user_id = ? ORDER BY j.seq',
         $userId
      );

      while (!$result->EOF) {
         $row =& $result->GetRowAssoc(false);
         $returner[$row['sched_conf_id']] = $row['notification'];
         $result->moveNext();
      }

      $result->Close();
      unset($result);

      return $returner;
   }

   function setSchedConfNotifications($schedConfId, $userId, $notificationStatus) {
      return $this->update(
         ($notificationStatus?'INSERT INTO notification_status (user_id, sched_conf_id) VALUES (?, ?)':
         'DELETE FROM notification_status WHERE user_id = ? AND sched_conf_id = ?'),
         array($userId, $schedConfId)
      );
   }

   function deleteNotificationStatusBySchedConf($schedConfId) {
      return $this->update(
         'DELETE FROM notification_status WHERE sched_conf_id = ?', $schedConfId
      );
   }

   function deleteNotificationStatusByUserId($userId) {
      return $this->update(
         'DELETE FROM notification_status WHERE user_id = ?', $userId
      );
   }

   function &getNotifiableUsersBySchedConfId($schedConfId) {
      $userDao =& DAORegistry::getDAO('UserDAO');

      $result =& $this->retrieve(
         'SELECT u.* FROM users u, notification_status n WHERE u.user_id = n.user_id AND n.sched_conf_id = ?',
         $schedConfId
      );

      $returner = new DAOResultFactory($result, $userDao, '_returnUserFromRow');
      return $returner;
   }

   function getNotifiableUsersCount($schedConfId) {
      $userDao =& DAORegistry::getDAO('UserDAO');

      $result =& $this->retrieve(
         'SELECT count(*) FROM notification_status n WHERE n.sched_conf_id = ?',
         $schedConfId
      );

      $returner = $result->fields[0];

      $result->Close();
      unset($result);

      return $returner;
   }
}

?>

---