Friend.php

Go to the documentation of this file.

<?php

namespace Combu;

class Friend extends DataClass {

    const TABLE_NAME = "Friend";

    public $IdAccount = 0;
    public $IdFriend = 0;
    public $State = FRIEND_STATE_ACCEPTED;

    public function __construct($src = null, $stripSlashes = false) {
        if (!empty($src)) {
            if (is_array($src)) {
                // Load by array
                $this->_loadByRow($src, $stripSlashes);
            }
        }
    }

    public static function Load ($idAccount, $state = NULL, $limit = null, $offset = null, &$count = null, $returnArray = false) {
        if ($state === FRIEND_STATE_REQUEST_PENDING) {
            $where = sprintf("(IdFriend = %d) AND (State = %d)", $idAccount, FRIEND_STATE_REQUEST);
        } else {
            $where = sprintf("(IdAccount = %d)", $idAccount);
            if ($state !== NULL) {
                $where .= sprintf(" AND (State = %d)", $state);
            }
        }
        return self::_load(self::GetTableName(__CLASS__), ($returnArray ? "" : __CLASS__), $where, NULL, $limit, $offset, $count);
    }

    public function Save() {
        global $Database;
        $query = sprintf("REPLACE INTO %s (IdAccount, IdFriend, State) VALUES (%d, %d, %d)",
                self::GetTableName(__CLASS__),
                $this->IdAccount,
                $this->IdFriend,
                $this->State);
        return $Database->Query($query);
    }

    public function Delete() {
        if ($this->IdAccount < 1 || $this->IdFriend < 1)
            return FALSE;
        return $this->_Delete(self::GetTableName(__CLASS__), sprintf("IdAccount = %d AND IdFriend = %d", $this->IdAccount, $this->IdFriend));
    }
    
    public static function DeleteBoth($idUser1, $idUser2) {
        if ($idUser1 > 0 && $idUser2 > 0) {
            $where = sprintf("(IdAccount = %d AND IdFriend = %d) OR (IdAccount = %d AND IdFriend = %d)", $idUser1, $idUser2, $idUser2, $idUser1);
            $self = new self();
            return $self->_Delete(self::GetTableName(__CLASS__), $where);
        }
        return FALSE;
    }
}