sdr/update/model/SDRField.php5

<?php

class SDRField extends ModelBase {
    
    const TYPE_INT = 'int';
    const TYPE_TEXT = 'text';
    const TYPE_DATE = 'date';
    
    public static $ATTRIBUTES = array(
        'id' => array(
            'nullable' => false,
            'commit' => SModel2::COMMIT_NEVER,
            'type' => 'int'
        ),
        'name' => array(
            'nullable' => false,
            'type' => 'string'
        ),
        'description' => array(
            'nullable' => false,
            'type' => 'string'
        ),
        'control' => array(
            'type' => 'string'
        ),
        'type' => array(
            'type' => 'string',
            'default' => 'text'
        ),
        'editable' => array(
            'type' => 'int',
            'default' => 1
        )
    );

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

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

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

    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 getList($constraints = array(), $limit = array(), $order = array(), $count = false) {
        return parent::getListBase(self::getDBI(), $constraints, $limit, $order, $count, 'SDRField', true);
    }

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

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


    public function listSDRVersionFieldValues($constraints = array(), $limit = array(), $order = array(), $count = false) {
        return parent::getListBase(self::getDBI(),
                            array_merge($constraints, array('fieldId' => $this->id)),
                            $limit, $order, $count, 'SDRVersionFieldValue', true);
    }

    public function listSDRVersionFieldValuesMulti($constraints = array(), $limit = array(), $order = array(), $count = false, $depth = 1) {
        return parent::getListBaseMulti(self::getDBI(),
                            array_merge($constraints, array('Base.fieldId' => $this->id)),
                            $limit, $order, $count, 'SDRVersionFieldValue', true, $depth);
    }

    public function addSDRVersionFieldValue($version, $value) {
        $obj =  new SDRVersionFieldValue();

        if(is_object($version))
            $obj->version = $version;
        else
            $obj->versionId = $version;
        $obj->fieldId = $this->id;
        if(is_object($value))
            $obj->value = $value;
        else
            $obj->valueId = $value;

        if(!$obj->commit())
            return null;

        return $obj;
    }

    public function listSDRFieldValues($constraints = array(), $limit = array(), $order = array(), $count = false) {
        return parent::getListBase(self::getDBI(),
                            array_merge($constraints, array('fieldId' => $this->id)),
                            $limit, $order, $count, 'SDRFieldValue', true);
    }

    public function listSDRFieldValuesMulti($constraints = array(), $limit = array(), $order = array(), $count = false, $depth = 1) {
        return parent::getListBaseMulti(self::getDBI(),
                            array_merge($constraints, array('Base.fieldId' => $this->id)),
                            $limit, $order, $count, 'SDRFieldValue', true, $depth);
    }

    public function addSDRFieldValue($value) {
        $obj =  new SDRFieldValue();

        $obj->fieldId = $this->id;
        if(is_object($value))
            $obj->value = $value;
        else
            $obj->valueId = $value;

        if(!$obj->commit())
            return null;

        return $obj;
    }

    public function listSDRSearchWordCounts($constraints = array(), $limit = array(), $order = array(), $count = false) {
        return parent::getListBase(self::getDBI(),
                            array_merge($constraints, array('fieldId' => $this->id)),
                            $limit, $order, $count, 'SDRSearchWordCount', true);
    }

    public function listSDRSearchWordCountsMulti($constraints = array(), $limit = array(), $order = array(), $count = false, $depth = 1) {
        return parent::getListBaseMulti(self::getDBI(),
                            array_merge($constraints, array('Base.fieldId' => $this->id)),
                            $limit, $order, $count, 'SDRSearchWordCount', true, $depth);
    }

    public function addSDRSearchWordCount($searchWord, $cserd, $count) {
        $obj =  new SDRSearchWordCount();

        if(is_object($searchWord))
            $obj->searchWord = $searchWord;
        else
            $obj->searchWordId = $searchWord;
        if(is_object($cserd))
            $obj->cserd = $cserd;
        else
            $obj->cserdId = $cserd;
        $obj->fieldId = $this->id;
        $obj->count = $count;

        if(!$obj->commit())
            return null;

        return $obj;
    }

    public function listSDRProjectFields($constraints = array(), $limit = array(), $order = array(), $count = false) {
        return parent::getListBase(self::getDBI(),
                            array_merge($constraints, array('fieldId' => $this->id)),
                            $limit, $order, $count, 'SDRProjectField', true);
    }

    public function listSDRProjectFieldsMulti($constraints = array(), $limit = array(), $order = array(), $count = false, $depth = 1) {
        return parent::getListBaseMulti(self::getDBI(),
                            array_merge($constraints, array('Base.fieldId' => $this->id)),
                            $limit, $order, $count, 'SDRProjectField', true, $depth);
    }

    public function addSDRProjectField($project, $indexOrder, $required = '') {
        $obj =  new SDRProjectField();

        if(is_object($project))
            $obj->project = $project;
        else
            $obj->projectId = $project;
        $obj->fieldId = $this->id;
        $obj->indexOrder = $indexOrder;
        if($required != '')
            $obj->required = $required;

        if(!$obj->commit())
            return null;

        return $obj;
    }

    public static function findOrAddField($name) {
        // Try to get existing entry for this field
        $field = self::retrieve( array('name'=>$name) );

        // If we couldn't find it, create a new field
        if ($field == null) {
            $field = new SDRField();
            $field->name = $name;
            if ( !$field->commit() ) {
                self::setStaticError('Could not commit new field for ' . $name);
                return false;
            }
        }
        
        return $field;
    }

    public static function getNamesAndIds() {
        $DBI = self::getDBI();
        $result = $DBI->select(self::getTableNameStatic(), array('id', 'name'));
        if (!$result)
            return false;
        $return = array();
        foreach ($result as $r) {
            $return[$r['name']] = $r['id'];
        }
        return $return;
    }
}

?>

---