article_extend_ajax.php

Go to the documentation of this file.

<?php

class article_extend_ajax extends ajaxListComponent
{

    protected $_aColumns = array('container1' => array( // field , table,         visible, multilanguage, ident
        array('oxtitle', 'oxcategories', 1, 1, 0),
        array('oxdesc', 'oxcategories', 1, 1, 0),
        array('oxid', 'oxcategories', 0, 0, 0),
        array('oxid', 'oxcategories', 0, 0, 1)
    ),
                                 'container2' => array(
                                     array('oxtitle', 'oxcategories', 1, 1, 0),
                                     array('oxdesc', 'oxcategories', 1, 1, 0),
                                     array('oxid', 'oxcategories', 0, 0, 0),
                                     array('oxid', 'oxobject2category', 0, 0, 1),
                                     array('oxtime', 'oxobject2category', 0, 0, 1),
                                     array('oxid', 'oxcategories', 0, 0, 1)
                                 ),
    );

    protected function _getQuery()
    {
        $sCategoriesTable = $this->_getViewName('oxcategories');
        $sO2CView = $this->_getViewName('oxobject2category');
        $oDb = oxDb::getDb();

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

        if ($sOxid) {
            // all categories article is in
            $sQAdd = " from $sO2CView left join $sCategoriesTable on $sCategoriesTable.oxid=$sO2CView.oxcatnid ";
            $sQAdd .= " where $sO2CView.oxobjectid = " . $oDb->quote($sOxid)
                      . " and $sCategoriesTable.oxid is not null ";
        } else {
            $sQAdd = " from $sCategoriesTable where $sCategoriesTable.oxid not in ( ";
            $sQAdd .= " select $sCategoriesTable.oxid from $sO2CView "
                      . "left join $sCategoriesTable on $sCategoriesTable.oxid=$sO2CView.oxcatnid ";
            $sQAdd .= " where $sO2CView.oxobjectid = " . $oDb->quote($sSynchOxid)
                      . " and $sCategoriesTable.oxid is not null ) and $sCategoriesTable.oxpriceto = '0'";
        }

        return $sQAdd;
    }

    protected function _getDataFields($sQ)
    {
        $aDataFields = parent::_getDataFields($sQ);
        if (oxRegistry::getConfig()->getRequestParameter('oxid') && is_array($aDataFields) && count($aDataFields)) {

            // looking for smallest time value to mark record as main category ..
            $iMinPos = null;
            $iMinVal = null;
            reset($aDataFields);
            while (list($iPos, $aField) = each($aDataFields)) {

                // already set ?
                if ($aField['_3'] == '0') {
                    $iMinPos = null;
                    break;
                }

                if (!$iMinVal) {
                    $iMinVal = $aField['_3'];
                    $iMinPos = $iPos;
                } elseif ($iMinVal > $aField['_3']) {
                    $iMinPos = $iPos;
                }
            }

            // setting primary category
            if (isset($iMinPos)) {
                $aDataFields[$iMinPos]['_3'] = '0';
            }
        }

        return $aDataFields;
    }

    public function removeCat()
    {
        $myConfig = $this->getConfig();
        $aRemoveCat = $this->_getActionIds('oxcategories.oxid');

        $soxId = oxRegistry::getConfig()->getRequestParameter('oxid');
        $sShopID = $myConfig->getShopId();
        $oDb = oxDb::getDb();

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

        // removing all
        if (is_array($aRemoveCat) && count($aRemoveCat)) {

            $sQ = "delete from oxobject2category where oxobject2category.oxobjectid= "
                  . oxDb::getDb()->quote($soxId) . " and ";
            $sQ .= " oxcatnid in (" . implode(', ', oxDb::getInstance()->quoteArray($aRemoveCat)) . ')';
            $oDb->Execute($sQ);

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

        $this->resetArtSeoUrl($soxId, $aRemoveCat);
        $this->resetContentCache();

    }

    public function addCat()
    {
        $myConfig = $this->getConfig();
        $oDb = oxDb::getDb();
        $aAddCat = $this->_getActionIds('oxcategories.oxid');
        $soxId = oxRegistry::getConfig()->getRequestParameter('synchoxid');
        $sShopID = $myConfig->getShopId();
        $sO2CView = $this->_getViewName('oxobject2category');

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

        if (isset($aAddCat) && is_array($aAddCat)) {

            $oDb = oxDb::getDb();

            $oNew = oxNew('oxobject2category');
            $myUtilsObj = oxUtilsObject::getInstance();

            foreach ($aAddCat 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($sAdd) . " and oxobject2category.oxobjectid = " . $oDb->quote($soxId) . " ";
                if ($oDb->getOne($sSelect, false, false)) {
                    continue;
                }

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

                $oNew->save();
            }

            $this->_updateOxTime($soxId);

            $this->resetArtSeoUrl($soxId);
            $this->resetContentCache();

        }
    }

    protected function _updateOxTime($soxId)
    {
        $oDb = oxDb::getDb();
        $sO2CView = $this->_getViewName('oxobject2category');
        $soxId = $oDb->quote($soxId);
        $sSqlShopFilter = "";
        // updating oxtime values
        $sQ = "update oxobject2category set oxtime = 0 where oxobjectid = {$soxId} {$sSqlShopFilter} and oxid = (
                    select oxid from (
                        select oxid from {$sO2CView} where oxobjectid = {$soxId} {$sSqlShopFilter}
                        order by oxtime limit 1
                    ) as _tmp
                )";
        $oDb->execute($sQ);
    }

    public function setAsDefault()
    {
        $sDefCat = oxRegistry::getConfig()->getRequestParameter("defcat");
        $soxId = oxRegistry::getConfig()->getRequestParameter("oxid");
        $oDb = oxDb::getDb();

        $sQuotedOxId = $oDb->quote($soxId);
        $sQuotedDefCat = $oDb->quote($sDefCat);

        $sSqlShopFilter = "";

        // #0003650: increment all product references independent to active shop
        $sQ = "update oxobject2category set oxtime = oxtime + 10 where oxobjectid = {$sQuotedOxId} {$sSqlShopFilter}";
        oxDb::getInstance()->getDb()->Execute($sQ);

        // set main category for active shop
        $sQ = "update oxobject2category set oxtime = 0 where oxobjectid = {$sQuotedOxId} " .
              "and oxcatnid = {$sQuotedDefCat} {$sSqlShopFilter}";
        oxDb::getInstance()->getDb()->Execute($sQ);
        //echo "\n$sQ\n";

        // #0003366: invalidate article SEO for all shops
        oxRegistry::get("oxSeoEncoder")->markAsExpired($soxId, null, 1, null, "oxtype='oxarticle'");
        $this->resetContentCache();
    }
}