models/CSERDmodel/CSERDresponse.php5

<?php

class CSERDresponse extends CSERDModelBase {
    public static $ATTRIBUTES = array(
        'responseId' => array(
            'nullable' => false,
            'commit' => SModel2::COMMIT_NEVER,
            'type' => 'int'
        ),
        'questionId' => array(
            'nullable' => false,
            'commit' => SModel2::COMMIT_FIRST,
            'type' => 'int',
            'foreign' => array('table' => 'question', 'on' => 'questionId', 'object' => 'question')
        ),
        'reviewId' => array(
            'nullable' => false,
            'commit' => SModel2::COMMIT_FIRST,
            'type' => 'int',
            'foreign' => array('table' => 'review', 'on' => 'reviewId', 'object' => 'review')
        ),
        'response' => array(
            'type' => 'string'
        ),
        'review' => array(
            'commit' => SModel2::COMMIT_FOREIGN,
            'type' => 'CSERDreview'
        ),
        'question' => array(
            'commit' => SModel2::COMMIT_FOREIGN,
            'type' => 'CSERDquestion'
        )
    );

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

        $this->registerAttributes(self::$ATTRIBUTES);
        $this->registerTableName('response');
        $this->registerPrimaryKey('responseId', true);

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

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

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

    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, 'CSERDresponse', true);
    }

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


    public function getParentQuestion() {
        return CSERDquestion::retrieve(array('questionId' => $this->questionId));
    }

    public function getParentQuestionMulti($depth = 1) {
        return CSERDquestion::retrieveMulti(array('Base.questionId' => $this->questionId), false, $depth);
    }

    public function getParentReview() {
        return CSERDreview::retrieve(array('reviewId' => $this->reviewId));
    }

    public function getParentReviewMulti($depth = 1) {
        return CSERDreview::retrieveMulti(array('Base.reviewId' => $this->reviewId), false, $depth);
    }
}

?>

---