sdr/update/model/SDRValue.php5

<?php

class SDRValue extends ModelBase {
    public static $ATTRIBUTES = array(
        'id' => array(
            'nullable' => false,
            'commit' => SModel2::COMMIT_NEVER,
            'type' => 'int'
        ),
        'type' => array(
            'type' => 'string'
        )
    );

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

        $this->registerAttributes(self::$ATTRIBUTES);
        $this->registerTableName('SDRValue');
        $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, 'SDRValue', true);
    }

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

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


    public function listSDRVersionFieldValues($constraints = array(), $limit = array(), $order = array(), $count = false) {
        return parent::getListBase(self::getDBI(),
                            array_merge($constraints, array('valueId' => $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.valueId' => $this->id)),
                            $limit, $order, $count, 'SDRVersionFieldValue', true, $depth);
    }

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

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

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

        return $obj;
    }

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

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

    public function addSDRDateValue($entry = '') {
        $obj =  new SDRDateValue();

        $obj->valueId = $this->id;
        $obj->entry = $entry;

        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('valueId' => $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.valueId' => $this->id)),
                            $limit, $order, $count, 'SDRFieldValue', true, $depth);
    }

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

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

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

        return $obj;
    }

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

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

    public function addSDRTextValue($entry) {
        $obj =  new SDRTextValue();

        $obj->valueId = $this->id;
        $obj->entry = $entry;

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

        return $obj;
    }

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

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

    public function addSDRIntValue($entry) {
        $obj =  new SDRIntValue();

        $obj->valueId = $this->id;
        $obj->entry = $entry;

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

        return $obj;
    }
    


    private function valueTableForType($type) {
        switch($type) {
            case SDRField::TYPE_INT:
                return 'SDRIntValue';
            case SDRField::TYPE_TEXT:
                return 'SDRTextValue';
            case SDRField::TYPE_DATE:
                return 'SDRDateValue';
            default:
                self::setStaticError('Unknown type for SDRValue: ' . $type);
                return false;
        }
    }
    
    
    public static function findOrAddValue($entry, $field) {
        $commitSuccess = true;
        if ($field->type == SDRField::TYPE_INT) {
            $valueEntry = SDRTextValue::retrieve(array('LIKE BINARY'=>array('entry' => $entry)));
            if ($valueEntry == null) {
                $value = new SDRValue();
                $value->type = $field->type;
                $value->commit();
                $value->addSDRIntValue($entry);
                $commitSuccess = $value->commit();
            }
            else
                $value = $valueEntry->getParentValue();
        }
        else if ($field->type == SDRField::TYPE_TEXT) {
            // Make sure to do a binary (case sensitive) comparison
            $valueEntry = SDRTextValue::retrieve(array('LIKE BINARY'=>array('entry' => $entry)));
            if ($valueEntry == null) {
                $value = new SDRValue();
                $value->type = $field->type;
                $value->commit();
                $value->addSDRTextValue($entry);
                $commitSuccess = $value->commit();
            }
            else
                $value = $valueEntry->getParentValue();
        }
        else if ($field->type == SDRField::TYPE_DATE) {
            $valueEntry = SDRTextValue::retrieve(array('LIKE BINARY'=>array('entry' => $entry)));
            if ($valueEntry == null) {
                $value = new SDRValue();
                $value->type = $field->type;
                $value->commit();
                $value->addSDRDateValue($entry);
                $commitSuccess = $value->commit();
            }
            else
                $value = $valueEntry->getParentValue();
        }
        
        if ( !$commitSuccess ) {
            self::setStaticError("Could not commit new $type value for $entry");
            return false;
        }
        
        // Add connection between field and value if that connection doesn't exist yet
        $fieldValue = SDRFieldValue::retrieve(array('fieldId'=>$field->id, 'valueId'=>$value->id));
        if ($fieldValue == null) {
            $fieldValue = new SDRFieldValue();
            $fieldValue->fieldId = $field->id;
            $fieldValue->valueId = $value->id;
            if (!$fieldValue->commit()) {
                self::setStaticError("Could not connect field $field->name to value $entry");
                return false;
            }
        }
        return($value);
    }

    public function getValue() {
        $cacheList = SDRValueCache::getList(array('valueId'=>$this->id));
        return $cacheList[0]->value;
    }


}

?>

---