category_main_ajax.php

Go to the documentation of this file.

<?php

class category_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();

        $sArticleTable = $this->_getViewName('oxarticles');
        $sO2CView = $this->_getViewName('oxobject2category');

        $sOxid = oxRegistry::getConfig()->getRequestParameter('oxid');
        $sSynchOxid = oxRegistry::getConfig()->getRequestParameter('synchoxid');
        $oDb = oxDb::getDb();

        $sShopID = $myConfig->getShopId();

        // category selected or not ?
        if (!$sOxid && $sSynchOxid) {

            // dodger performance
            $sQAdd = ' from ' . $sArticleTable . ' where 1 ';
        } else {

            // copied from oxadminview
            $sJoin = " {$sArticleTable}.oxid={$sO2CView}.oxobjectid ";

            $sSubSelect = '';
            if ($sSynchOxid && $sOxid != $sSynchOxid) {

                $sSubSelect = ' and ' . $sArticleTable . '.oxid not in ( ';
                $sSubSelect .= "select $sArticleTable.oxid from $sO2CView left join $sArticleTable ";
                $sSubSelect .= "on $sJoin where $sO2CView.oxcatnid =  " . $oDb->quote($sSynchOxid) . " ";
                $sSubSelect .= 'and ' . $sArticleTable . '.oxid is not null ) ';
            }

            $sQAdd = " from $sO2CView join $sArticleTable ";
            $sQAdd .= " on $sJoin where $sO2CView.oxcatnid = " . $oDb->quote($sOxid);
            $sQAdd .= " and $sArticleTable.oxid is not null $sSubSelect ";
        }

        return $sQAdd;
    }

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

        // display variants or not ?
        if (!$this->getConfig()->getConfigParam('blVariantsSelection')) {
            $sQ .= " and {$sArtTable}.oxparentid = '' ";
        }

        return $sQ;
    }

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

        $aArticles = $this->_getActionIds('oxarticles.oxid');
        $sCategoryID = oxRegistry::getConfig()->getRequestParameter('synchoxid');
        $sShopID = $myConfig->getShopId();
        $oDb = oxDb::getDb();
        $sArticleTable = $this->_getViewName('oxarticles');

        // adding
        if (oxRegistry::getConfig()->getRequestParameter('all')) {
            $aArticles = $this->_getAll($this->_addFilter("select $sArticleTable.oxid " . $this->_getQuery()));
        }

        if (is_array($aArticles)) {

            $sO2CView = $this->_getViewName('oxobject2category');

            $oNew = oxNew('oxobject2category');
            $myUtilsObject = oxUtilsObject::getInstance();
            $oActShop = $myConfig->getActiveShop();

            $sProdIds = "";
            foreach ($aArticles as $sAdd) {

                // check, if it's already in, then don't add it again
                $sSelect = "select 1 from $sO2CView as oxobject2category where oxobject2category.oxcatnid= "
                           . $oDb->quote($sCategoryID) . " and oxobject2category.oxobjectid = " . $oDb->quote($sAdd) . "";
                if ($oDb->getOne($sSelect, false, false)) {
                    continue;
                }

                $oNew->oxobject2category__oxid = new oxField($oNew->setId(md5($sAdd . $sCategoryID . $sShopID)));
                $oNew->oxobject2category__oxobjectid = new oxField($sAdd);
                $oNew->oxobject2category__oxcatnid = new oxField($sCategoryID);
                $oNew->oxobject2category__oxtime = new oxField(time());

                $oNew->save();

                if ($sProdIds) {
                    $sProdIds .= ",";
                }
                $sProdIds .= $oDb->quote($sAdd);
            }

            // updating oxtime values
            $this->_updateOxTime($sProdIds);

            $this->resetArtSeoUrl($aArticles);
            $this->resetCounter("catArticle", $sCategoryID);

        }
    }

    protected function _updateOxTime($sProdIds)
    {
        if ($sProdIds) {
            $sO2CView = $this->_getViewName('oxobject2category');
            $sSqlShopFilter = "";
            $sSqlWhereShopFilter = "";
            $sQ = "update oxobject2category set oxtime = 0 where oxid in (
                      select _tmp.oxid from (
                          select oxobject2category.oxid from (
                              select min(oxtime) as oxtime, oxobjectid from {$sO2CView}
                              where oxobjectid in ( {$sProdIds} ) {$sSqlShopFilter} group by oxobjectid
                          ) as _subtmp
                          left join oxobject2category on oxobject2category.oxtime = _subtmp.oxtime
                           and oxobject2category.oxobjectid = _subtmp.oxobjectid
                           {$sSqlWhereShopFilter}
                      ) as _tmp
                   ) {$sSqlShopFilter}";

            oxDb::getDb()->execute($sQ);
        }
    }

    public function removeArticle()
    {
        $aArticles = $this->_getActionIds('oxarticles.oxid');
        $sCategoryID = oxRegistry::getConfig()->getRequestParameter('oxid');
        $sShopID = $this->getConfig()->getShopId();
        $oDb = oxDb::getDb();

        // adding
        if (oxRegistry::getConfig()->getRequestParameter('all')) {
            $sArticleTable = $this->_getViewName('oxarticles');
            $aArticles = $this->_getAll($this->_addFilter("select $sArticleTable.oxid " . $this->_getQuery()));
        }

        // adding
        if (is_array($aArticles) && count($aArticles)) {
            $sProdIds = implode(", ", oxDb::getInstance()->quoteArray($aArticles));

            $sDelete = "delete from oxobject2category where";
            $sWhere = " oxcatnid=" . $oDb->quote($sCategoryID);
            if (!$this->getConfig()->getConfigParam('blVariantsSelection')) {
                $sQ = $sDelete . $sWhere . " and oxobjectid in
                    ( select oxid from oxarticles where oxparentid in ( {$sProdIds} ) )";
                $oDb->execute($sQ);
            }
            $sQ = $sDelete . $sWhere . " and oxobjectid in ( {$sProdIds} )";
            $oDb->execute($sQ);

            // updating oxtime values
            $this->_updateOxTime($sProdIds);
        }

        $this->resetArtSeoUrl($aArticles, $sCategoryID);
        $this->resetCounter("catArticle", $sCategoryID);

    }
}