oxattribute.php

Go to the documentation of this file.

<?php

class oxAttribute extends oxI18n
{
    protected $_sClassName = 'oxattribute';

    protected $_sCoreTbl = 'oxattribute';


    protected $_sActiveValue = null;

    protected $_sTitle = null;

    protected $_aValues = null;

    public function __construct()
    {
        parent::__construct();
        $this->init( $this->_sCoreTbl);
    }

    public function delete( $sOXID = null )
    {
        if( !$sOXID)
            $sOXID = $this->getId();
        if( !$sOXID)
            return false;


        // remove attributes from articles also
        $oDB = oxDb::getDb();
        $sOxidQuoted = $oDB->quote($sOXID);
        $sDelete = "delete from oxobject2attribute where oxattrid = ".$sOxidQuoted;
        $rs = $oDB->execute( $sDelete);

        // #657 ADDITIONAL removes attribute connection to category
        $sDelete = "delete from oxcategory2attribute where oxattrid = ".$sOxidQuoted;
        $rs = $oDB->execute( $sDelete);

        return parent::delete( $sOXID);
    }

    public function assignVarToAttribute( $aMDVariants, $aSelTitle )
    {
        $myLang    = oxLang::getInstance();
        $aConfLanguages = $myLang->getLanguageIds();
        $sAttrId = $this->_getAttrId( $aSelTitle[0] );
        if ( !$sAttrId ) {
            $sAttrId = $this->_createAttribute( $aSelTitle );
        }
        foreach ( $aMDVariants as $sVarId => $oValue ) {
            if ( strpos( $sVarId, "mdvar_" ) === 0 ) {
                foreach ( $oValue as $sId ) {
                    //var_dump($sVarId, $oAttribute->oxattribute__oxid->value);
                    $sVarId = substr($sVarId, 6);
                    $oNewAssign = oxNew( "oxbase" );
                    $oNewAssign->init( "oxobject2attribute" );
                    $sNewId = oxUtilsObject::getInstance()->generateUID();
                    if ($oNewAssign->load($sId)) {
                        $oNewAssign->oxobject2attribute__oxobjectid = new oxField($sVarId);
                        $oNewAssign->setId($sNewId);
                        $oNewAssign->save();
                    }
                }
            } else {
                $oNewAssign = oxNew( "oxi18n" );
                $oNewAssign->setEnableMultilang( false );
                $oNewAssign->init( "oxobject2attribute" );
                $oNewAssign->oxobject2attribute__oxobjectid = new oxField($sVarId);
                $oNewAssign->oxobject2attribute__oxattrid   = new oxField($sAttrId);
                foreach ($aConfLanguages as $sKey => $sLang) {
                    $sPrefix = $myLang->getLanguageTag($sKey);
                    $oNewAssign->{'oxobject2attribute__oxvalue'.$sPrefix} = new oxField($oValue[$sKey]->name);
                }
                $oNewAssign->save();
            }
        }
    }

    protected function _getAttrId( $sSelTitle )
    {
        $oDb = oxDb::getDB();
        $sAttViewName = getViewName('oxattribute');
        return $oDb->getOne("select oxid from $sAttViewName where LOWER(oxtitle) = " . $oDb->quote(getStr()->strtolower($sSelTitle)));
    }

    protected function _createAttribute( $aSelTitle )
    {
        $myLang = oxLang::getInstance();
        $aConfLanguages = $myLang->getLanguageIds();
        $oAttr = oxNew('oxI18n');
        $oAttr->setEnableMultilang( false );
        $oAttr->init('oxattribute');
        foreach ($aConfLanguages as $sKey => $sLang) {
           $sPrefix = $myLang->getLanguageTag($sKey);
           $oAttr->{'oxattribute__oxtitle'.$sPrefix} = new oxField($aSelTitle[$sKey]);
        }
        $oAttr->save();
        return $oAttr->getId();
    }

    public function getAttributeAssigns( $sArtId )
    {
        if ( $sArtId ) {
            $oDb = oxDb::getDb();

            $sSelect  = "select o2a.oxid from oxobject2attribute as o2a ";
            $sSelect .= "where o2a.oxobjectid = ".$oDb->quote( $sArtId )." order by o2a.oxpos";

            $aIds = array();
            $rs = $oDb->execute( $sSelect );
            if ($rs != false && $rs->recordCount() > 0) {
                while (!$rs->EOF) {
                    $aIds[] = $rs->fields[0];
                    $rs->moveNext();
                }
            }
            return $aIds;
        }
    }



    public function setTitle( $sTitle )
    {
        $this->_sTitle = getStr()->htmlspecialchars( $sTitle );
    }

    public function getTitle()
    {
        return $this->_sTitle;
    }

    public function addValue( $sValue )
    {
        $this->_aValues[] = getStr()->htmlspecialchars( $sValue );
    }

    public function setActiveValue( $sValue )
    {
        $this->_sActiveValue = getStr()->htmlspecialchars( $sValue );
    }

    public function getActiveValue()
    {

        return $this->_sActiveValue;
    }

    public function getValues()
    {
        return $this->_aValues;
    }

}