123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176 |
- <?php
- defined('GNUSOCIAL') || die();
- class Profile_prefs extends Managed_DataObject
- {
- public $__table = 'profile_prefs';
- public $profile_id;
- public $namespace;
- public $topic;
- public $data;
- public $created;
- public $modified;
- public static function schemaDef()
- {
- return array(
- 'fields' => array(
- 'profile_id' => array('type' => 'int', 'not null' => true, 'description' => 'user'),
- 'namespace' => array('type' => 'varchar', 'length' => 191, 'not null' => true, 'description' => 'namespace, like pluginname or category'),
- 'topic' => array('type' => 'varchar', 'length' => 191, 'not null' => true, 'description' => 'preference key, i.e. description, age...'),
- 'data' => array('type' => 'blob', 'description' => 'topic data, may be anything'),
- 'created' => array('type' => 'datetime', 'not null' => true, 'default' => '0000-00-00 00:00:00', 'description' => 'date this record was created'),
- 'modified' => array('type' => 'datetime', 'not null' => true, 'default' => 'CURRENT_TIMESTAMP', 'description' => 'date this record was modified'),
- ),
- 'primary key' => array('profile_id', 'namespace', 'topic'),
- 'foreign keys' => array(
- 'profile_prefs_profile_id_fkey' => array('profile', array('profile_id' => 'id')),
- ),
- 'indexes' => array(
- 'profile_prefs_profile_id_idx' => array('profile_id'),
- ),
- );
- }
- public static function getNamespacePrefs(Profile $profile, $namespace, array $topic = [])
- {
- if (empty($topic)) {
- $prefs = new Profile_prefs();
- $prefs->profile_id = $profile->getID();
- $prefs->namespace = $namespace;
- $prefs->find();
- } else {
- $prefs = self::pivotGet('profile_id', $profile->getID(), array('namespace'=>$namespace, 'topic'=>$topic));
- }
- if (empty($prefs->N)) {
- throw new NoResultException($prefs);
- }
- return $prefs;
- }
- public static function getNamespace(Profile $profile, $namespace, array $topic = [])
- {
- $prefs = self::getNamespacePrefs($profile, $namespace, $topic);
- return $prefs->fetchAll();
- }
- public static function getAll(Profile $profile)
- {
- try {
- $prefs = self::listFind('profile_id', array($profile->getID()));
- } catch (NoResultException $e) {
- return array();
- }
- $list = array();
- while ($prefs->fetch()) {
- if (!isset($list[$prefs->namespace])) {
- $list[$prefs->namespace] = array();
- }
- $list[$prefs->namespace][$prefs->topic] = $prefs->data;
- }
- return $list;
- }
- public static function getTopic(Profile $profile, $namespace, $topic)
- {
- return Profile_prefs::getByPK(array('profile_id' => $profile->getID(),
- 'namespace' => $namespace,
- 'topic' => $topic));
- }
- public static function getData(Profile $profile, $namespace, $topic, $def = null)
- {
- try {
- $pref = self::getTopic($profile, $namespace, $topic);
- } catch (NoResultException $e) {
- if ($def === null) {
-
- throw $e;
- }
-
- return $def;
- }
- return $pref->data;
- }
- public static function getConfigData(Profile $profile, $namespace, $topic)
- {
- try {
- $data = self::getData($profile, $namespace, $topic);
- } catch (NoResultException $e) {
- $data = common_config($namespace, $topic);
- }
- return $data;
- }
-
- public static function setData(Profile $profile, $namespace, $topic, $data = null)
- {
- try {
- $pref = self::getTopic($profile, $namespace, $topic);
- if (is_null($data)) {
- $pref->delete();
- } else {
- $orig = clone($pref);
- $pref->data = DB_DataObject_Cast::blob($data);
- $pref->update($orig);
- }
- return true;
- } catch (NoResultException $e) {
- if (is_null($data)) {
- return false;
- }
- }
- $pref = new Profile_prefs();
- $pref->profile_id = $profile->getID();
- $pref->namespace = $namespace;
- $pref->topic = $topic;
- $pref->data = DB_DataObject_Cast::blob($data);
- $pref->created = common_sql_now();
-
- if ($pref->insert() === false) {
- throw new ServerException('Could not save profile preference.');
- }
- return true;
- }
- }
|