UserSettingsDAO.inc.php

<?php
 
class UserSettingsDAO extends DAO {
   function getSetting($userId, $name, $contextId = CONTEXT_SITE) {
      $result = $this->retrieve(
         'SELECT  setting_value,
            setting_type
         FROM  user_settings
         WHERE user_id = ? AND
            setting_name = ? AND
            assoc_type = ? AND
            assoc_id = ?',
         array(
            (int) $userId,
            $name,
            Application::getContextAssocType(),
            (int) $contextId
         )
      );
 
      if ($result->RecordCount() != 0) {
         $row = $result->getRowAssoc(false);
         $returner = $this->convertFromDB($row['setting_value'], $row['setting_type']);
      } else {
         $returner = null;
      }
      $result->Close();
      return $returner;
   }
 
   function getUsersBySetting($name, $value, $type = null, $contextId = CONTEXT_SITE) {
      $value = $this->convertToDB($value, $type);
      $result = $this->retrieve(
         'SELECT  u.*
         FROM  users u,
            user_settings s
         WHERE u.user_id = s.user_id AND
            s.setting_name = ? AND
            s.setting_value = ? AND
            s.assoc_type = ? AND
            s.assoc_id = ?',
         array($name, $value, Application::getContextAssocType(), (int) $contextId)
      );
 
      $userDao = DAORegistry::getDAO('UserDAO'); /* @var $userDao UserDAO */
      return new DAOResultFactory($result, $userDao, '_returnUserFromRow');
   }
 
   function getSettingsByContextId($userId, $contextId = CONTEXT_SITE) {
      $result = $this->retrieve(
         'SELECT  setting_name,
            setting_value,
            setting_type
         FROM  user_settings
         WHERE user_id = ? AND
            assoc_type = ?
            AND assoc_id = ?',
         array((int) $userId, Application::getContextAssocType(), (int) $contextId)
      );
 
      $userSettings = array();
      while (!$result->EOF) {
         $row = $result->getRowAssoc(false);
         $value = $this->convertFromDB($row['setting_value'], $row['setting_type']);
         $userSettings[$row['setting_name']] = $value;
         $result->MoveNext();
      }
      $result->Close();
      return $userSettings;
   }
 
   function updateSetting($userId, $name, $value, $type = null, $contextId = CONTEXT_SITE) {
      $result = $this->retrieve(
         'SELECT  COUNT(*)
         FROM  user_settings
         WHERE user_id = ? AND
            setting_name = ?
            AND assoc_type = ?
            AND assoc_id = ?',
         array((int) $userId, $name, Application::getContextAssocType(), (int) $contextId)
      );
 
      $value = $this->convertToDB($value, $type);
      if ($result->fields[0] == 0) {
         $this->update(
            'INSERT INTO user_settings
               (user_id, setting_name, assoc_type, assoc_id, setting_value, setting_type)
            VALUES
               (?, ?, ?, ?, ?, ?)',
            array(
               (int) $userId,
               $name,
               Application::getContextAssocType(),
               (int) $contextId,
               $value,
               $type
            )
         );
      } else {
         $this->update(
            'UPDATE user_settings
            SET   setting_value = ?,
               setting_type = ?
            WHERE user_id = ? AND
               setting_name = ? AND
               assoc_type = ? AND
               assoc_id = ?',
            array(
               $value,
               $type,
               (int) $userId,
               $name,
               Application::getContextAssocType(),
               (int) $contextId
            )
         );
      }
 
      $result->Close();
   }
 
   function deleteSetting($userId, $name, $contextId = CONTEXT_SITE) {
      $this->update(
         'DELETE FROM user_settings WHERE user_id = ? AND setting_name = ? AND assoc_type = ? AND assoc_id = ?',
         array((int) $userId, $name, Application::getContextAssocType(), (int) $contextId)
      );
   }
 
   function deleteSettings($userId) {
      return $this->update(
         'DELETE FROM user_settings WHERE user_id = ?', (int) $userId
      );
   }
}