manufacturer_main_ajax.php

Go to the documentation of this file.

<?php

class manufacturer_main_ajax extends ajaxListComponent
{
    protected $_blAllowExtColumns = true;

    protected $_aColumns = array( 'container1' => array(    // field , table,       visible, multilanguage, ident
                                        array( 'oxartnum', 'oxarticles', 1, 0, 0 ),
                                        array( 'oxtitle',  'oxarticles', 1, 1, 0 ),
                                        array( 'oxean',    'oxarticles', 1, 0, 0 ),
                                        array( 'oxmpn',    'oxarticles', 0, 0, 0 ),
                                        array( 'oxprice',  'oxarticles', 0, 0, 0 ),
                                        array( 'oxstock',  'oxarticles', 0, 0, 0 ),
                                        array( 'oxid',     'oxarticles', 0, 0, 1 )
                                        ),
                                    'container2' => array(
                                        array( 'oxartnum', 'oxarticles', 1, 0, 0 ),
                                        array( 'oxtitle',  'oxarticles', 1, 1, 0 ),
                                        array( 'oxean',    'oxarticles', 1, 0, 0 ),
                                        array( 'oxmpn',    'oxarticles', 0, 0, 0 ),
                                        array( 'oxprice',  'oxarticles', 0, 0, 0 ),
                                        array( 'oxstock',  'oxarticles', 0, 0, 0 ),
                                        array( 'oxid',     'oxarticles', 0, 0, 1 )
                                        )
                                );

    protected function _getQuery()
    {
        $myConfig = $this->getConfig();

        // looking for table/view
        $sArtTable = $this->_getViewName('oxarticles');
        $sO2CView  = $this->_getViewName('oxobject2category');
        $oDb = oxDb::getDb();

        $sManufacturerId      = $myConfig->getRequestParameter( 'oxid' );
        $sSynchManufacturerId = $myConfig->getRequestParameter( 'synchoxid' );

        // Manufacturer selected or not ?
        if ( !$sManufacturerId ) {
            // dodger performance
            $sQAdd  = ' from '.$sArtTable.' where '.$sArtTable.'.oxshopid="'.$myConfig->getShopId().'" and 1 ';
            $sQAdd .= $myConfig->getRequestParameter( 'blVariantsSelection' ) ?'':" and $sArtTable.oxparentid = '' and $sArtTable.oxmanufacturerid != ".$oDb->quote( $sSynchManufacturerId );
        } elseif ( $sSynchManufacturerId && $sSynchManufacturerId != $sManufacturerId ) {
            // selected category ?
            $sQAdd  = " from $sO2CView left join $sArtTable on ";
            $sQAdd .= $myConfig->getRequestParameter( 'blVariantsSelection' )?" ( $sArtTable.oxid = $sO2CView.oxobjectid or $sArtTable.oxparentid = $sO2CView.oxobjectid )":" $sArtTable.oxid = $sO2CView.oxobjectid ";
            $sQAdd .= 'where '.$sArtTable.'.oxshopid="'.$myConfig->getShopId().'" and '.$sO2CView.'.oxcatnid = '.$oDb->quote( $sManufacturerId ).' and '.$sArtTable.'.oxmanufacturerid != '.$oDb->quote( $sSynchManufacturerId );
            $sQAdd .= $myConfig->getRequestParameter( 'blVariantsSelection' )?'':" and $sArtTable.oxparentid = '' ";
        } else {
            $sQAdd  = " from $sArtTable where $sArtTable.oxmanufacturerid = ".$oDb->quote( $sManufacturerId );
            $sQAdd .= $myConfig->getRequestParameter( 'blVariantsSelection' )?'':" and $sArtTable.oxparentid = '' ";
        }
        return $sQAdd;
    }

    protected function _addFilter( $sQ )
    {
        $sArtTable = $this->_getViewName('oxarticles');
        $sQ = parent::_addFilter( $sQ );

        // display variants or not ?
        $sQ .= $this->getConfig()->getRequestParameter( 'blVariantsSelection' ) ? ' group by '.$sArtTable.'.oxid ' : '';
        return $sQ;
    }

    public function removeManufacturer()
    {
        $myConfig   = $this->getConfig();
        $aRemoveArt = $this->_getActionIds( 'oxarticles.oxid' );
        $sOxid = $myConfig->getRequestParameter( 'oxid' );

        if ( $this->getConfig()->getRequestParameter( "all" ) ) {
            $sArtTable = $this->_getViewName( 'oxarticles' );
            $aRemoveArt = $this->_getAll( $this->_addFilter( "select $sArtTable.oxid ".$this->_getQuery() ) );
        }
        
        if ( is_array(  $aRemoveArt ) && !empty( $aRemoveArt ) ) {
            $sSelect = "update oxarticles set oxmanufacturerid = null where oxid in ( ".implode(", ", oxDb::getInstance()->quoteArray( $aRemoveArt ) ).") ";
            oxDb::getDb()->Execute( $sSelect);

            $this->resetCounter( "manufacturerArticle", $sOxid );
        }
    }

    public function addManufacturer()
    {
        $myConfig = $this->getConfig();

        $aAddArticle = $this->_getActionIds( 'oxarticles.oxid' );
        $sSynchOxid       = $myConfig->getRequestParameter( 'synchoxid' );

        if ( $myConfig->getRequestParameter( 'all' ) ) {
            $sArtTable = $this->_getViewName( 'oxarticles' );
            $aAddArticle = $this->_getAll( $this->_addFilter( "select $sArtTable.oxid ".$this->_getQuery() ) );
        }

        if ( $sSynchOxid && $sSynchOxid != "-1" && is_array( $aAddArticle ) ) {
            $oDb = oxDb::getDb();
            $sSelect = "update oxarticles set oxmanufacturerid = ".$oDb->quote( $sSynchOxid )." where oxid in ( ".implode(", ", oxDb::getInstance()->quoteArray( $aAddArticle ) )." )";

            $oDb->Execute( $sSelect);
            $this->resetCounter( "manufacturerArticle", $sSynchOxid );
        }
    }
}