sdr/update/model/SDRProjectField.php5

<?php

class SDRProjectField extends ModelBase {
    public static $ATTRIBUTES = array(
        'projectId' => array(
            'nullable' => false,
            'commit' => SModel2::COMMIT_CHANGED,
            'type' => 'int',
            'foreign' => array('table' => 'SDRProject', 'on' => 'id', 'object' => 'project')
        ),
        'fieldId' => array(
            'nullable' => false,
            'commit' => SModel2::COMMIT_CHANGED,
            'type' => 'int',
            'foreign' => array('table' => 'SDRField', 'on' => 'id', 'object' => 'field')
        ),
        'indexOrder' => array(
            'nullable' => false,
            'type' => 'int'
        ),
        'required' => array(
            'type' => 'string'
        ),
        'project' => array(
            'commit' => SModel2::COMMIT_FOREIGN,
            'type' => 'SDRProject'
        ),
        'field' => array(
            'commit' => SModel2::COMMIT_FOREIGN,
            'type' => 'SDRField'
        )
    );

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

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

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

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

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

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

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


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

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

    public function getParentField() {
        return SDRField::retrieve(array('id' => $this->fieldId));
    }

    public function getParentFieldMulti($depth = 1) {
        return SDRField::retrieveMulti(array('Base.id' => $this->fieldId), false, $depth);
    }


    public static function findOrAddProjectField($fieldId, $projectId) {
        $DBI = self::getDBI();
        $results = self::getList(array('projectId' => $projectId, 'fieldId' => $fieldId));
        if ($results === false)
            return false;
        // If we've found a field, return it
        if (count($results) > 0) {
            $projectField = $results[0];
        // If we didn't find a field, create a new one
        } else {
            // Create a new ProjectField object and connect it up
            $projectField = new SDRProjectField();
            $projectField->projectId = $projectId;
            $projectField->fieldId = $fieldId;
            $projectField->indexOrder = 0;
            $projectField->required = 0;

            if (!$projectField->commit()) {
                self::setStaticError("Could not add field $name to $project");
                return false;
            }
        }
        // Return the found or created value
        return $projectField;
    }
    
}
?>

---