article_attribute.inc.php

Go to the documentation of this file.

<?php

$aColumns = array( 'container1' => array(    // field , table,         visible, multilanguage, ident
                                        array( 'oxtitle', 'oxattribute', 1, 1, 0 ),
                                        array( 'oxid',    'oxattribute', 0, 0, 1 )
                                        ),
                     'container2' => array(
                                        array( 'oxtitle', 'oxattribute', 1, 1, 0 ),
                                        array( 'oxid',    'oxobject2attribute', 0, 0, 1 ),
                                        array( 'oxvalue', 'oxobject2attribute', 0, 1, 1 ),
                                        array( 'oxattrid', 'oxobject2attribute', 0, 0, 1 ),
                                        )
                    );
class ajaxComponent extends ajaxListComponent
{
    protected function _getQuery()
    {
        $oDb         = oxDb::getDb();
        $sArtId      = oxConfig::getParameter( 'oxid' );
        $sSynchArtId = oxConfig::getParameter( 'synchoxid' );

        $sAttrViewName = $this->_getViewName('oxattribute');
        $sO2AViewName  = $this->_getViewName('oxobject2attribute');
        if ( $sArtId ) {
            // all categories article is in
            $sQAdd  = " from $sO2AViewName left join $sAttrViewName on $sAttrViewName.oxid=$sO2AViewName.oxattrid ";
            $sQAdd .= " where $sO2AViewName.oxobjectid = " . $oDb->quote( $sArtId ) . " ";
        } else {
            $sQAdd  = " from $sAttrViewName where $sAttrViewName.oxid not in ( select $sO2AViewName.oxattrid from $sO2AViewName left join $sAttrViewName on $sAttrViewName.oxid=$sO2AViewName.oxattrid ";
            $sQAdd .= " where $sO2AViewName.oxobjectid = " . $oDb->quote( $sSynchArtId ) . " ) ";
        }

        return $sQAdd;
    }

    public function removeattr()
    {
        $aChosenArt = $this->_getActionIds( 'oxobject2attribute.oxid' );
        $sOxid = oxConfig::getParameter( 'oxid' );
        if ( oxConfig::getParameter( 'all' ) ) {
            $sO2AViewName  = $this->_getViewName('oxobject2attribute');
            $sQ = $this->_addFilter( "delete $sO2AViewName.* ".$this->_getQuery() );
            oxDb::getDb()->Execute( $sQ );

        } elseif ( is_array( $aChosenArt ) ) {
            $sQ = "delete from oxobject2attribute where oxobject2attribute.oxid in (" . implode( ", ", oxDb::getInstance()->quoteArray( $aChosenArt ) ) . ") ";
            oxDb::getDb()->Execute( $sQ );
        }
    }

    public function addattr()
    {
        $aAddCat = $this->_getActionIds( 'oxattribute.oxid' );
        $soxId   = oxConfig::getParameter( 'synchoxid');

        if ( oxConfig::getParameter( 'all' ) ) {
            $sAttrViewName = $this->_getViewName('oxattribute');
            $aAddCat = $this->_getAll( $this->_addFilter( "select $sAttrViewName.oxid ".$this->_getQuery() ) );
        }

        if ( $soxId && $soxId != "-1" && is_array( $aAddCat ) ) {
            foreach ($aAddCat as $sAdd) {
                $oNew = oxNew( "oxbase" );
                $oNew->init( "oxobject2attribute" );
                $oNew->oxobject2attribute__oxobjectid = new oxField($soxId);
                $oNew->oxobject2attribute__oxattrid   = new oxField($sAdd);
                $oNew->save();
            }
        }
    }

    public function saveAttributeValue ()
    {
        $oDb = oxDb::getDb();

        $soxId = oxConfig::getParameter( "oxid");
        $sAttributeId = oxConfig::getParameter( "attr_oxid");
        $sAttributeValue      = oxConfig::getParameter( "attr_value");
        if (!$this->getConfig()->isUtf()) {
            $sAttributeValue = iconv( 'UTF-8', oxLang::getInstance()->translateString("charset"), $sAttributeValue );
        }

        $oArticle = oxNew( "oxarticle" );
        if ( $oArticle->load( $soxId ) ) {


            if ( isset( $sAttributeId) && ("" != $sAttributeId ) ) {
                $sO2AViewName = $this->_getViewName( "oxobject2attribute" );
                $sSelect = "select * from $sO2AViewName where $sO2AViewName.oxobjectid= " . $oDb->quote( $oArticle->oxarticles__oxid->value ) . " and
                            $sO2AViewName.oxattrid= " . $oDb->quote( $sAttributeId );
                $oO2A = oxNew( "oxi18n" );
                $oO2A->setLanguage( oxConfig::getParameter( 'editlanguage' ) );
                $oO2A->init( "oxobject2attribute" );
                if ( $oO2A->assignRecord( $sSelect ) ) {
                    $oO2A->oxobject2attribute__oxvalue->setValue( $sAttributeValue );
                    $oO2A->save();
                }
            }
        }
    }
}