UserGroup.php

Go to the documentation of this file.

<?php

namespace Combu;

class UserGroup extends DataClass {

    const TABLE_NAME = "UserGroup";

    public $Id = 0;
    public $Name = "";
    public $IdOwner = 0;
    public $Public = 0;
    public $CustomData = "";

    public function __construct($src = null, $stripSlashes = false) {
        global $Database;
        if ($src == null)
            return;
        if (is_array($src)) {
            // Load by array
            $this->_loadByRow($src, $stripSlashes);
        } else if (is_numeric($src) && intval($src) > 0) {
            // Load by Id
            $this->_loadFilter(self::GetTableName(__CLASS__), "Id = " . intval($src));
        }
    }

    public function Exists() {
        global $Database;
        $sql = "IdOwner = " . $this->IdOwner . " AND Name = '" . $Database->Escape($this->Name) . "'";
        if ($this->Id > 0)
            $sql .= " AND Id <> " . $this->Id;
        $recs = self::_load(self::GetTableName(__CLASS__), "", $sql);
        if (count($recs) > 0)
            return TRUE;
        return FALSE;
    }

    public static function Load ($name = NULL, $idOwner = 0, $idAccount = 0, $limit = null, $offset = null, &$count = null, $returnArray = false) {
        global $Database;
        $where = "(Public = 1)";
        if ($name)
            $where .= ($where ? " AND " : "") . sprintf("(Name REGEXP '%s')", $Database->Escape($name));
        if ($idOwner > 0 && $idOwner == $idAccount) {
            $where .= ($where ? " AND " : "") . "(" .
                    sprintf("(IdOwner = %d)", $idOwner) .
                    " OR " . sprintf("(Id IN (SELECT IdGroup FROM %s WHERE IdAccount = %d))", self::GetTableName(UserGroupAccount::class), $idAccount) .
                    ")";
        } else {
            if ($idOwner > 0)
                $where .= ($where ? " AND " : "") . sprintf("(IdOwner = %d)", $idOwner);
            if ($idAccount > 0)
                $where .= ($where ? " AND " : "") . sprintf("(Id IN (SELECT IdGroup FROM %s WHERE IdAccount = %d))", self::GetTableName(UserGroupAccount::class), $idAccount);
        }
        return self::_load(self::GetTableName(__CLASS__), ($returnArray ? "" : __CLASS__), $where, "Name", $limit, $offset, $count);
    }

    public function Save() {
        global $Database;
        if ($this->Id > 0) {
            $query = sprintf("UPDATE %s SET Name = '%s', IdOwner = %d, CustomData = '%s' WHERE Id = %d",
                    self::GetTableName(__CLASS__),
                    $Database->Escape($this->Name),
                    $this->IdOwner,
                    $Database->Escape($this->CustomData),
                    $this->Id);
        } else {
            $query = sprintf("INSERT INTO %s (Name, IdOwner, Public, CustomData) VALUES ('%s', %d, %d, '%s')",
                    self::GetTableName(__CLASS__),
                    $Database->Escape($this->Name),
                    $this->IdOwner,
                    $this->Public,
                    $Database->Escape($this->CustomData));
        }
        if ($Database->Query($query)) {
            if ($this->Id < 1)
                $this->Id = $Database->InsertedId();
            return TRUE;
        }
        return FALSE;
    }

    public function Delete() {
        if ($this->Id < 1)
            return FALSE;
        if ($this->_Delete(self::GetTableName(__CLASS__), "Id = " . $this->Id)) {
            // Delete all memberships
            $this->_Delete(self::GetTableName(UserGroupAccount::class), "IdGroup = " . $this->Id);
            // Delete all messages
            $this->_Delete(self::GetTableName(GameMail::class), "IdGroup = " . $this->Id);
            return TRUE;
        }
        return FALSE;
    }
    
    public function GetMembers() {
        $members = array();
        if ($this->Id > 0) {
            $members = UserGroupAccount::Load($this->Id);
        }
        return $members;
    }
    
    public function GetMembersAccount() {
        $members = array();
        $recs = $this->GetMembers();
        foreach ($recs as $member) {
            $user = new Account($member->IdAccount);
            if ($user->Id > 0)
                $members[] = $user;
        }
        return $members;
    }
    
    public function ToArray() {
        $array = Utils::ObjectToArray($this);
        $array["Owner"] = new Account($this->IdOwner);
        $array["Owner"] = $array["Owner"]->ToJson();
        $array["Users"] = array();
        $members = $this->GetMembersAccount();
        foreach ($members as $user) {
            $array["Users"][] = $user->ToArray();
        }
        return $array;
    }
}