oxattributelist.php

Go to the documentation of this file.

<?php

class oxAttributeList extends oxList
{
    public function __construct( $sObjectsInListName = 'oxattribute')
    {
        parent::__construct( 'oxattribute');
    }

    public function loadAttributesByIds( $aIds)
    {
        if (!count($aIds)) {
            return;
        }

        foreach ($aIds as $iKey => $sVal) {
            $aIds[$iKey] = mysql_real_escape_string($sVal);
        }

        $sAttrViewName = getViewName( 'oxattribute' );
        $sLangAdd = oxLang::getInstance()->getLanguageTag();
        $sSelect  = "select $sAttrViewName.oxid, $sAttrViewName.oxtitle$sLangAdd, oxobject2attribute.oxvalue$sLangAdd, oxobject2attribute.oxobjectid ";
        $sSelect .= "from oxobject2attribute ";
        $sSelect .= "left join $sAttrViewName on $sAttrViewName.oxid = oxobject2attribute.oxattrid ";
        $sSelect .= "where oxobject2attribute.oxobjectid in ( '".implode("','", $aIds)."' ) ";
        $sSelect .= "order by oxobject2attribute.oxpos, $sAttrViewName.oxpos";

        return $this->_createAttributeListFromSql( $sSelect);
    }

    protected function _createAttributeListFromSql( $sSelect)
    {
        $aAttributes = array();
        $rs = oxDb::getDb()->Execute( $sSelect);
        if ($rs != false && $rs->recordCount() > 0) {
            while (!$rs->EOF) {
                if ( !isset( $aAttributes[$rs->fields[0]])) {
                    $aAttributes[$rs->fields[0]] = new stdClass();
                }

                $aAttributes[$rs->fields[0]]->title = $rs->fields[1];
                if ( !isset( $aAttributes[$rs->fields[0]]->aProd[$rs->fields[3]])) {
                    $aAttributes[$rs->fields[0]]->aProd[$rs->fields[3]] = new stdClass();
                }
                $aAttributes[$rs->fields[0]]->aProd[$rs->fields[3]]->value = $rs->fields[2];
                $rs->moveNext();
            }
        }
        return $aAttributes;
    }

    public function loadAttributes( $sArtId)
    {
        if ( !$sArtId) {
            return;
        }

        $sSuffix = oxLang::getInstance()->getLanguageTag();

        $sAttrViewName = getViewName( 'oxattribute' );
        $sSelect  = "select $sAttrViewName.*, o2a.* ";
        $sSelect .= "from oxobject2attribute as o2a ";
        $sSelect .= "left join $sAttrViewName on $sAttrViewName.oxid = o2a.oxattrid ";
        $sSelect .= "where o2a.oxobjectid = '$sArtId' and o2a.oxvalue$sSuffix != '' ";
        $sSelect .= "order by o2a.oxpos, $sAttrViewName.oxpos";

        $this->selectString( $sSelect );
    }
}