UserGroupAccount.php

Go to the documentation of this file.

<?php

namespace Combu;

class UserGroupAccount extends DataClass {

    const TABLE_NAME = "UserGroupAccount";

    public $IdGroup = 0;
    public $IdAccount = 0;

    public function __construct($src = null, $stripSlashes = false) {
        global $Database;
        if ($src == null)
            return;
        if (is_array($src)) {
            // Load by array
            $this->_loadByRow($src, $stripSlashes);
        }
    }
    
    public static function Exists($idGroup, $idAccount) {
        global $Database;
        $where = sprintf("IdGroup = %d AND IdAccount = %d", $idGroup, $idAccount);
        $recs = self::_load(self::GetTableName(__CLASS__), "", $where);
        return (count($recs) > 0);
    }

    public static function Load ($idGroup = 0, $idAccount = 0, $returnArray = false) {
        $where = NULL;
        if ($idGroup > 0)
            $where .= ($where ? " AND " : "") . sprintf("(IdGroup = %d)", $idGroup);
        if ($idAccount > 0)
            $where .= ($where ? " AND " : "") . sprintf("(IdAccount = %d)", $idAccount);
        return self::_load(self::GetTableName(__CLASS__), ($returnArray ? "" : __CLASS__), $where);
    }

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

    public function Delete() {
        if ($this->IdGroup > 0 && $this->IdAccount > 0) {
            return $this->_Delete(self::GetTableName(__CLASS__), sprintf("IdGroup = %d AND IdAccount = %d", $this->IdGroup, $this->IdAccount));
        }
        return FALSE;
    }
}