oxattribute.php

Go to the documentation of this file.

<?php

class oxAttribute extends oxI18n
{

    protected $_sClassName = 'oxattribute';

    protected $_sActiveValue = null;

    protected $_sTitle = null;

    protected $_aValues = null;

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

    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 = oxRegistry::getLang();
        $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 = oxRegistry::getLang();
        $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->select($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;
    }

}