123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161 |
- <?php
- require_once INSTALLDIR.'/classes/Memcached_DataObject.php';
- class Foreign_link extends Managed_DataObject
- {
-
-
- public $__table = 'foreign_link';
- public $user_id;
- public $foreign_id;
- public $service;
- public $credentials;
- public $noticesync;
- public $friendsync;
- public $profilesync;
- public $last_noticesync;
- public $last_friendsync;
- public $created;
- public $modified;
-
-
- public static function schemaDef()
- {
- return array(
- 'fields' => array(
- 'user_id' => array('type' => 'int', 'not null' => true, 'description' => 'link to user on this system, if exists'),
- 'foreign_id' => array('type' => 'int', 'size' => 'big', 'unsigned' => true, 'not null' => true, 'description' => 'link to user on foreign service, if exists'),
- 'service' => array('type' => 'int', 'not null' => true, 'description' => 'foreign key to service'),
- 'credentials' => array('type' => 'varchar', 'length' => 255, 'description' => 'authc credentials, typically a password'),
- 'noticesync' => array('type' => 'int', 'size' => 'tiny', 'not null' => true, 'default' => 1, 'description' => 'notice synchronization, bit 1 = sync outgoing, bit 2 = sync incoming, bit 3 = filter local replies'),
- 'friendsync' => array('type' => 'int', 'size' => 'tiny', 'not null' => true, 'default' => 2, 'description' => 'friend synchronization, bit 1 = sync outgoing, bit 2 = sync incoming'),
- 'profilesync' => array('type' => 'int', 'size' => 'tiny', 'not null' => true, 'default' => 1, 'description' => 'profile synchronization, bit 1 = sync outgoing, bit 2 = sync incoming'),
- 'last_noticesync' => array('type' => 'datetime', 'description' => 'last time notices were imported'),
- 'last_friendsync' => array('type' => 'datetime', 'description' => 'last time friends were imported'),
- 'created' => array('type' => 'datetime', 'not null' => true, 'description' => 'date this record was created'),
- 'modified' => array('type' => 'timestamp', 'not null' => true, 'description' => 'date this record was modified'),
- ),
- 'primary key' => array('user_id', 'foreign_id', 'service'),
- 'foreign keys' => array(
- 'foreign_link_user_id_fkey' => array('user', array('user_id' => 'id')),
- 'foreign_link_foreign_id_fkey' => array('foreign_user', array('foreign_id' => 'id', 'service' => 'service')),
- 'foreign_link_service_fkey' => array('foreign_service', array('service' => 'id')),
- ),
- 'indexes' => array(
- 'foreign_user_user_id_idx' => array('user_id'),
- ),
- );
- }
- static function getByUserID($user_id, $service)
- {
- if (empty($user_id) || empty($service)) {
- return null;
- }
- $flink = new Foreign_link();
- $flink->service = $service;
- $flink->user_id = $user_id;
- $flink->limit(1);
- $result = $flink->find(true);
- return empty($result) ? null : $flink;
- }
- static function getByForeignID($foreign_id, $service)
- {
- if (empty($foreign_id) || empty($service)) {
- return null;
- } else {
- $flink = new Foreign_link();
- $flink->service = $service;
- $flink->foreign_id = $foreign_id;
- $flink->limit(1);
- $result = $flink->find(true);
- return empty($result) ? null : $flink;
- }
- }
- function set_flags($noticesend, $noticerecv, $replysync, $friendsync)
- {
- if ($noticesend) {
- $this->noticesync |= FOREIGN_NOTICE_SEND;
- } else {
- $this->noticesync &= ~FOREIGN_NOTICE_SEND;
- }
- if ($noticerecv) {
- $this->noticesync |= FOREIGN_NOTICE_RECV;
- } else {
- $this->noticesync &= ~FOREIGN_NOTICE_RECV;
- }
- if ($replysync) {
- $this->noticesync |= FOREIGN_NOTICE_SEND_REPLY;
- } else {
- $this->noticesync &= ~FOREIGN_NOTICE_SEND_REPLY;
- }
- if ($friendsync) {
- $this->friendsync |= FOREIGN_FRIEND_RECV;
- } else {
- $this->friendsync &= ~FOREIGN_FRIEND_RECV;
- }
- $this->profilesync = 0;
- }
-
- function getForeignUser()
- {
- $fuser = new Foreign_user();
- $fuser->service = $this->service;
- $fuser->id = $this->foreign_id;
- $fuser->limit(1);
- if ($fuser->find(true)) {
- return $fuser;
- }
- return null;
- }
- function getUser()
- {
- return User::getKV($this->user_id);
- }
- function getProfile()
- {
- return Profile::getKV('id', $this->user_id);
- }
-
- function safeDelete()
- {
- if (!empty($this->user_id)
- && !empty($this->foreign_id)
- && !empty($this->service))
- {
- return $this->delete();
- } else {
- common_debug(LOG_WARNING,
- 'Foreign_link::safeDelete() tried to delete a '
- . 'Foreign_link without a fully specified compound key: '
- . var_export($this, true));
- return false;
- }
- }
- }
|