SWAT/authDB/AuthUserToProject.php5

<?php

class AuthUserToProject extends AuthModelBase {
    public static $ATTRIBUTES = array(
        'userId' => array(
            'nullable' => false,
            'commit' => SModel2::COMMIT_CHANGED,
            'type' => 'int',
            'foreign' => array('table' => 'User', 'on' => 'id', 'object' => 'user')
        ),
        'projectId' => array(
            'nullable' => false,
            'commit' => SModel2::COMMIT_CHANGED,
            'type' => 'int',
            'foreign' => array('table' => 'Project', 'on' => 'id', 'object' => 'project')
        ),
        'user' => array(
            'commit' => SModel2::COMMIT_FOREIGN,
            'type' => 'AuthUser'
        ),
        'project' => array(
            'commit' => SModel2::COMMIT_FOREIGN,
            'type' => 'AuthProject'
        )
    );

    public function __construct($constraints = null, $multi = false) {
        parent::__construct();

        $this->registerAttributes(self::$ATTRIBUTES);
        $this->registerTableName('UserToProject');
        $this->registerPrimaryKey(array('userId', 'projectId'), false);

        if($constraints !== null)
            $this->populate($constraints, $multi);
    }

    public static function getAttributesStatic() {
        return self::$ATTRIBUTES;
    }

    public static function getTableNameStatic() {
        return 'UserToProject';
    }

    public static function retrieve($constraints = array(), $checkOnly = false) {
        $list = self::getList($constraints, array(1), array(), $checkOnly);
        if(!$list || count($list) == 0)
            return $checkOnly ? false : null;
        else if($checkOnly)
            return $list > 0;
        else
            return $list[0];
    }

    public static function exists($constraints = array()) {
        return self::retrieve($constraints, true);
    }

    public static function retrieveMulti($constraints = array(), $checkOnly = false, $depth = 1) {
        $list = self::getListMulti($constraints, array(1), array(), $checkOnly, $depth);
        if(!$list || count($list) == 0)
            return $checkOnly ? false : null;
        else if($checkOnly)
            return $list > 0;
        else
            return $list[0];
    }

    public static function existsMulti($constraints = array()) {
        return self::retrieveMulti($constraints, true);
    }

    public static function getList($constraints = array(), $limit = array(), $order = array(), $count = false) {
        return parent::getListBase(self::getDBI(), $constraints, $limit, $order, $count, 'AuthUserToProject', true);
    }

    public static function getListMulti($constraints = array(), $limit = array(), $order = array(), $count = false, $depth = 1) {
        return parent::getListBaseMulti(self::getDBI(), $constraints, $limit, $order, $count,
                                            'AuthUserToProject', true, $depth);
    }


    public function getParentUser() {
        return AuthUser::retrieve(array('User.id' => $this->userId));
    }

    public function getParentUserMulti($depth = 1) {
        return AuthUser::retrieveMulti(array('Base.id' => $this->userId), $depth);
    }

    public function getParentProject() {
        return AuthProject::retrieve(array('Project.id' => $this->projectId));
    }

    public function getParentProjectMulti($depth = 1) {
        return AuthProject::retrieveMulti(array('Base.id' => $this->projectId), $depth);
    }
}

?>

---