oxattribute.php

Go to the documentation of this file.

<?php

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

    protected $_sCoreTbl = 'oxattribute';

    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( "oxbase" );
                $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('oxbase');
        $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) {
            return;
        }
        $sSelect  = "select o2a.oxid ";
        $sSelect .= "from oxobject2attribute as o2a ";
        $sSelect .= "where o2a.oxobjectid = '$sArtId' ";
        $sSelect .= "order by o2a.oxpos";

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