article_main.php

Go to the documentation of this file.

<?php

class Article_Main extends oxAdminDetails
{

    public function render()
    {
        parent::render();

        $this->getConfig()->setConfigParam('bl_perfLoadPrice', true);

        $oArticle = oxNew('oxArticle');
        $oArticle->enablePriceLoad();

        $this->_aViewData['edit'] = $oArticle;

        $sOxId = $this->getEditObjectId();
        $sVoxId = $this->getConfig()->getRequestParameter("voxid");
        $sOxParentId = $this->getConfig()->getRequestParameter("oxparentid");

        // new variant ?
        if (isset($sVoxId) && $sVoxId == "-1" && isset($sOxParentId) && $sOxParentId && $sOxParentId != "-1") {
            $oParentArticle = oxNew("oxArticle");
            $oParentArticle->load($sOxParentId);
            $this->_aViewData["parentarticle"] = $oParentArticle;
            $this->_aViewData["oxparentid"] = $sOxParentId;

            $this->_aViewData["oxid"] = $sOxId = "-1";
        }

        if ($sOxId && $sOxId != "-1") {

            // load object
            $oArticle->loadInLang($this->_iEditLang, $sOxId);


            // load object in other languages
            $oOtherLang = $oArticle->getAvailableInLangs();
            if (!isset($oOtherLang[$this->_iEditLang])) {
                // echo "language entry doesn't exist! using: ".key($oOtherLang);
                $oArticle->loadInLang(key($oOtherLang), $sOxId);
            }

            // variant handling
            if ($oArticle->oxarticles__oxparentid->value) {
                $oParentArticle = oxNew("oxArticle");
                $oParentArticle->load($oArticle->oxarticles__oxparentid->value);
                $this->_aViewData["parentarticle"] = $oParentArticle;
                $this->_aViewData["oxparentid"] = $oArticle->oxarticles__oxparentid->value;
                $this->_aViewData["issubvariant"] = 1;
            }

            // #381A
            $this->_formJumpList($oArticle, $oParentArticle);

            //loading tags
            $oArticleTagList = oxNew("oxArticleTagList");
            $oArticleTagList->loadInLang($this->_iEditLang, $oArticle->getId());
            $oArticle->tags = $oArticleTagList->get();

            $aLang = array_diff(oxRegistry::getLang()->getLanguageNames(), $oOtherLang);
            if (count($aLang)) {
                $this->_aViewData["posslang"] = $aLang;
            }

            foreach ($oOtherLang as $id => $language) {
                $oLang = new stdClass();
                $oLang->sLangDesc = $language;
                $oLang->selected = ($id == $this->_iEditLang);
                $this->_aViewData["otherlang"][$id] = clone $oLang;
            }
        }

        $this->_aViewData["editor"] = $this->_generateTextEditor(
            "100%",
            300,
            $oArticle,
            "oxarticles__oxlongdesc",
            "details.tpl.css"
        );
        $this->_aViewData["blUseTimeCheck"] = $this->getConfig()->getConfigParam('blUseTimeCheck');

        return "article_main.tpl";
    }

    protected function _getEditValue($oObject, $sField)
    {
        $sEditObjectValue = '';
        if ($oObject) {
            $oDescField = $oObject->getLongDescription();
            $sEditObjectValue = $this->_processEditValue($oDescField->getRawValue());
            $oDescField = new oxField($sEditObjectValue, oxField::T_RAW);
        }

        return $sEditObjectValue;
    }

    public function save()
    {
        parent::save();

        $oConfig = $this->getConfig();
        $soxId = $this->getEditObjectId();
        $aParams = $oConfig->getRequestParameter("editval");

        // default values
        $aParams = $this->addDefaultValues($aParams);

        // null values
        if (isset($aParams['oxarticles__oxvat']) && $aParams['oxarticles__oxvat'] === '') {
            $aParams['oxarticles__oxvat'] = null;
        }

        // varianthandling
        $soxparentId = $oConfig->getRequestParameter("oxparentid");
        if (isset($soxparentId) && $soxparentId && $soxparentId != "-1") {
            $aParams['oxarticles__oxparentid'] = $soxparentId;
        } else {
            unset($aParams['oxarticles__oxparentid']);
        }

        $oArticle = oxNew("oxarticle");
        $oArticle->setLanguage($this->_iEditLang);

        if ($soxId != "-1") {
            $oArticle->loadInLang($this->_iEditLang, $soxId);
        } else {
            $aParams['oxarticles__oxid'] = null;
            $aParams['oxarticles__oxissearch'] = 1;
            $aParams['oxarticles__oxstockflag'] = 1;
            if (empty($aParams['oxarticles__oxstock'])) {
                $aParams['oxarticles__oxstock'] = 0;
            }

            // shopid
            $aParams['oxarticles__oxshopid'] = oxRegistry::getSession()->getVariable("actshop");

            if (!isset($aParams['oxarticles__oxactive'])) {
                $aParams['oxarticles__oxactive'] = 0;
            }
        }

        //article number handling, warns for artnum dublicates
        if (isset($aParams['oxarticles__oxartnum']) && strlen($aParams['oxarticles__oxartnum']) > 0 &&
            $oConfig->getConfigParam('blWarnOnSameArtNums') &&
            $oArticle->oxarticles__oxartnum->value != $aParams['oxarticles__oxartnum']
        ) {
            $sSelect = "select oxid from " . getViewName('oxarticles');
            $sSelect .= " where oxartnum = '" . $aParams['oxarticles__oxartnum'] . "'";
            $sSelect .= " and oxid != '" . $aParams['oxarticles__oxid'] . "'";
            if ($oArticle->assignRecord($sSelect)) {
                $this->_aViewData["errorsavingatricle"] = 1;
            }
        }


        // #905A resetting article count in price categories if price has been changed
        $sOxIdField = 'oxarticles__oxid';
        $sPriceField = 'oxarticles__oxprice';
        $sActiveField = 'oxarticles__oxactive';
        $sVendorField = 'oxarticles__oxvendorid';
        $sManufacturerField = 'oxarticles__oxmanufacturerid';
        if (isset($aParams[$sPriceField]) && $aParams[$sPriceField] != $oArticle->$sPriceField->value) {
            $this->resetCounter("priceCatArticle", $oArticle->$sPriceField->value);
        }

        $aResetIds = array();
        if (isset($aParams[$sActiveField]) && $aParams[$sActiveField] != $oArticle->$sActiveField->value) {
            //check categories
            $this->_resetCategoriesCounter($oArticle->$sOxIdField->value);

            // vendors
            $aResetIds['vendor'][$oArticle->$sVendorField->value] = 1;
            $aResetIds['manufacturer'][$oArticle->$sManufacturerField->value] = 1;
        }

        // vendors
        if (isset($aParams[$sVendorField]) && $aParams[$sVendorField] != $oArticle->$sVendorField->value) {
            $aResetIds['vendor'][$aParams[$sVendorField]] = 1;
            $aResetIds['vendor'][$oArticle->$sVendorField->value] = 1;
        }

        // manufacturers
        if (isset($aParams[$sManufacturerField]) &&
            $aParams[$sManufacturerField] != $oArticle->$sManufacturerField->value) {

            $aResetIds['manufacturer'][$aParams[$sManufacturerField]] = 1;
            $aResetIds['manufacturer'][$oArticle->$sManufacturerField->value] = 1;
        }

        // resetting counts
        $this->_resetCounts($aResetIds);

        $oArticle->setLanguage(0);

        //triming spaces from article title (M:876)
        if (isset($aParams['oxarticles__oxtitle'])) {
            $aParams['oxarticles__oxtitle'] = trim($aParams['oxarticles__oxtitle']);
        }

        $oArticle->assign($aParams);
        $oArticle->setArticleLongDesc($this->_processLongDesc($aParams['oxarticles__oxlongdesc']));
        $oArticle->setLanguage($this->_iEditLang);
        $oArticle = oxRegistry::get("oxUtilsFile")->processFiles($oArticle);
        $oArticle->save();

        // set oxid if inserted
        if ($soxId == "-1") {
            $sFastCat = $oConfig->getRequestParameter("art_category");
            if ($sFastCat != "-1") {
                $this->addToCategory($sFastCat, $oArticle->getId());
            }
        }

        //saving tags
        if (isset($aParams['tags'])) {
            $sTags = $aParams['tags'];
            if (!trim($sTags)) {
                $sTags = $oArticle->oxarticles__oxsearchkeys->value;
            }
            $aInvalidTags = $this->_setTags($sTags, $oArticle->getId());
            if (!empty($aInvalidTags)) {
                $this->_aViewData["invalid_tags"] = implode(', ', $aInvalidTags);
            }
        }

        $this->setEditObjectId($oArticle->getId());
    }

    protected function _processLongDesc($sValue)
    {
        // TODO: the code below is redundant, optimize it, assignments should go smooth without conversions
        // hack, if editor screws up text, htmledit tends to do so
        $sValue = str_replace('&amp;nbsp;', '&nbsp;', $sValue);
        $sValue = str_replace('&amp;', '&', $sValue);
        $sValue = str_replace('&quot;', '"', $sValue);
        $sValue = str_replace('&lang=', '&amp;lang=', $sValue);
        $sValue = str_replace('<p>&nbsp;</p>', '', $sValue);
        $sValue = str_replace('<p>&nbsp; </p>', '', $sValue);

        return $sValue;
    }

    protected function _resetCategoriesCounter($sArticleId)
    {
        $oDb = oxDb::getDb();
        $sQ = "select oxcatnid from oxobject2category where oxobjectid = " . $oDb->quote($sArticleId);
        $oRs = $oDb->execute($sQ);
        if ($oRs !== false && $oRs->recordCount() > 0) {
            while (!$oRs->EOF) {
                $this->resetCounter("catArticle", $oRs->fields[0]);
                $oRs->moveNext();
            }
        }
    }

    protected function _setTags($sTags, $sArticleId)
    {
        $oArticleTagList = oxNew('oxarticletaglist');
        $oArticleTagList->loadInLang($this->_iEditLang, $sArticleId);
        $oArticleTagList->set($sTags);
        $oArticleTagList->save();

        return $oArticleTagList->get()->getInvalidTags();
    }

    public function addToCategory($sCatID, $sOXID)
    {
        $myConfig = $this->getConfig();

        $oNew = oxNew("oxbase");
        $oNew->init("oxobject2category");
        $oNew->oxobject2category__oxtime = new oxField(0);
        $oNew->oxobject2category__oxobjectid = new oxField($sOXID);
        $oNew->oxobject2category__oxcatnid = new oxField($sCatID);

        $oNew->save();

        // resetting amount of articles in category
        $this->resetCounter("catArticle", $sCatID);
    }

    public function copyArticle($sOldId = null, $sNewId = null, $sParentId = null)
    {
        $myConfig = $this->getConfig();

        $sOldId = $sOldId ? $sOldId : $this->getEditObjectId();
        $sNewId = $sNewId ? $sNewId : oxUtilsObject::getInstance()->generateUID();

        $oArticle = oxNew('oxbase');
        $oArticle->init('oxarticles');
        if ($oArticle->load($sOldId)) {

            if ($myConfig->getConfigParam('blDisableDublArtOnCopy')) {
                $oArticle->oxarticles__oxactive->setValue(0);
                $oArticle->oxarticles__oxactivefrom->setValue(0);
                $oArticle->oxarticles__oxactiveto->setValue(0);
            }

            // setting parent id
            if ($sParentId) {
                $oArticle->oxarticles__oxparentid->setValue($sParentId);
            }

            // setting oxinsert/oxtimestamp
            $iNow = date('Y-m-d H:i:s', oxRegistry::get("oxUtilsDate")->getTime());
            $oArticle->oxarticles__oxinsert = new oxField($iNow);

            // mantis#0001590: OXRATING and OXRATINGCNT not set to 0 when copying article
            $oArticle->oxarticles__oxrating = new oxField(0);
            $oArticle->oxarticles__oxratingcnt = new oxField(0);

            $oArticle->setId($sNewId);
            $oArticle->save();

            //copy categories
            $this->_copyCategories($sOldId, $sNewId);

            //atributes
            $this->_copyAttributes($sOldId, $sNewId);

            //sellist
            $this->_copySelectlists($sOldId, $sNewId);

            //crossseling
            $this->_copyCrossseling($sOldId, $sNewId);

            //accessoire
            $this->_copyAccessoires($sOldId, $sNewId);

            // #983A copying staffelpreis info
            $this->_copyStaffelpreis($sOldId, $sNewId);

            //copy article extends (longdescription, tags)
            $this->_copyArtExtends($sOldId, $sNewId);

            //files
            $this->_copyFiles($sOldId, $sNewId);

            // resetting
            $aResetIds['vendor'][$oArticle->oxarticles__oxvendorid->value] = 1;
            $aResetIds['manufacturer'][$oArticle->oxarticles__oxmanufacturerid->value] = 1;
            $this->_resetCounts($aResetIds);

            $this->resetContentCache();

            $myUtilsObject = oxUtilsObject::getInstance();
            $oDb = oxDb::getDb();

            //copy variants
            $sQ = "select oxid from oxarticles where oxparentid = " . $oDb->quote($sOldId);
            $oRs = $oDb->execute($sQ);
            if ($oRs !== false && $oRs->recordCount() > 0) {
                while (!$oRs->EOF) {
                    $this->copyArticle($oRs->fields[0], $myUtilsObject->generateUid(), $sNewId);
                    $oRs->moveNext();
                }
            }

            // only for top articles
            if (!$sParentId) {

                $this->setEditObjectId($oArticle->getId());

                //article number handling, warns for artnum dublicates
                $sFncParameter = oxRegistry::getConfig()->getRequestParameter('fnc');
                $sArtNumField = 'oxarticles__oxartnum';
                if ($myConfig->getConfigParam('blWarnOnSameArtNums') &&
                    $oArticle->$sArtNumField->value && $sFncParameter == 'copyArticle'
                ) {
                    $sSelect = "select oxid from " . $oArticle->getCoreTableName() .
                               " where oxartnum = " . $oDb->quote($oArticle->$sArtNumField->value) .
                               " and oxid != " . $oDb->quote($sNewId);

                    if ($oArticle->assignRecord($sSelect)) {
                        $this->_aViewData["errorsavingatricle"] = 1;
                    }
                }
            }
        }
    }

    protected function _copyCategories($sOldId, $sNewId)
    {
        $myUtilsObject = oxUtilsObject::getInstance();
        $oDb = oxDb::getDb();

        $sO2CView = getViewName('oxobject2category');
        $sQ = "select oxcatnid, oxtime from {$sO2CView} where oxobjectid = " . $oDb->quote($sOldId);
        $oRs = $oDb->execute($sQ);
        if ($oRs !== false && $oRs->recordCount() > 0) {
            while (!$oRs->EOF) {
                $sUid = $myUtilsObject->generateUid();
                $sCatId = $oRs->fields[0];
                $sTime = $oRs->fields[1];


                $sSql = "insert into oxobject2category (oxid, oxobjectid, oxcatnid, oxtime) " .
                        "VALUES (" . $oDb->quote($sUid) . ", " . $oDb->quote($sNewId) . ", " .
                        $oDb->quote($sCatId) . ", " . $oDb->quote($sTime) . ") ";
                $oDb->execute($sSql);

                $oRs->moveNext();

                // resetting article count in category
                $this->resetCounter("catArticle", $sCatId);
            }
        }
    }

    protected function _copyAttributes($sOldId, $sNewId)
    {
        $myUtilsObject = oxUtilsObject::getInstance();
        $oDb = oxDb::getDb();

        $sQ = "select oxid from oxobject2attribute where oxobjectid = " . $oDb->quote($sOldId);
        $oRs = $oDb->execute($sQ);
        if ($oRs !== false && $oRs->recordCount() > 0) {
            while (!$oRs->EOF) {
                // #1055A
                $oAttr = oxNew("oxbase");
                $oAttr->init("oxobject2attribute");
                $oAttr->load($oRs->fields[0]);
                $oAttr->setId($myUtilsObject->generateUID());
                $oAttr->oxobject2attribute__oxobjectid->setValue($sNewId);
                $oAttr->save();
                $oRs->moveNext();
            }
        }
    }

    protected function _copyFiles($sOldId, $sNewId)
    {
        $myUtilsObject = oxUtilsObject::getInstance();
        $oDb = oxDb::getDb(oxDB::FETCH_MODE_ASSOC);

        $sQ = "SELECT * FROM `oxfiles` WHERE `oxartid` = " . $oDb->quote($sOldId);
        $oRs = $oDb->execute($sQ);
        if ($oRs !== false && $oRs->recordCount() > 0) {
            while (!$oRs->EOF) {

                $oFile = oxNew("oxfile");
                $oFile->setId($myUtilsObject->generateUID());
                $oFile->oxfiles__oxartid = new oxField($sNewId);
                $oFile->oxfiles__oxfilename = new oxField($oRs->fields['OXFILENAME']);
                $oFile->oxfiles__oxfilesize = new oxField($oRs->fields['OXFILESIZE']);
                $oFile->oxfiles__oxstorehash = new oxField($oRs->fields['OXSTOREHASH']);
                $oFile->oxfiles__oxpurchasedonly = new oxField($oRs->fields['OXPURCHASEDONLY']);
                $oFile->save();
                $oRs->moveNext();
            }
        }
    }

    protected function _copySelectlists($sOldId, $sNewId)
    {
        $myUtilsObject = oxUtilsObject::getInstance();
        $oDb = oxDb::getDb();

        $sQ = "select oxselnid from oxobject2selectlist where oxobjectid = " . $oDb->quote($sOldId);
        $oRs = $oDb->execute($sQ);
        if ($oRs !== false && $oRs->recordCount() > 0) {
            while (!$oRs->EOF) {
                $sUid = $myUtilsObject->generateUID();
                $sId = $oRs->fields[0];
                $sSql = "insert into oxobject2selectlist (oxid, oxobjectid, oxselnid) " .
                        "VALUES (" . $oDb->quote($sUid) . ", " . $oDb->quote($sNewId) . ", " . $oDb->quote($sId) . ") ";
                $oDb->execute($sSql);
                $oRs->moveNext();
            }
        }
    }

    protected function _copyCrossseling($sOldId, $sNewId)
    {
        $myUtilsObject = oxUtilsObject::getInstance();
        $oDb = oxDb::getDb();

        $sQ = "select oxobjectid from oxobject2article where oxarticlenid = " . $oDb->quote($sOldId);
        $oRs = $oDb->execute($sQ);
        if ($oRs !== false && $oRs->recordCount() > 0) {
            while (!$oRs->EOF) {
                $sUid = $myUtilsObject->generateUID();
                $sId = $oRs->fields[0];
                $sSql = "insert into oxobject2article (oxid, oxobjectid, oxarticlenid) " .
                       "VALUES (" . $oDb->quote($sUid) . ", " . $oDb->quote($sId) . ", " . $oDb->quote($sNewId) . " ) ";
                $oDb->execute($sSql);
                $oRs->moveNext();
            }
        }
    }

    protected function _copyAccessoires($sOldId, $sNewId)
    {
        $myUtilsObject = oxUtilsObject::getInstance();
        $oDb = oxDb::getDb();

        $sQ = "select oxobjectid from oxaccessoire2article where oxarticlenid= " . $oDb->quote($sOldId);
        $oRs = $oDb->execute($sQ);
        if ($oRs !== false && $oRs->recordCount() > 0) {
            while (!$oRs->EOF) {
                $sUId = $myUtilsObject->generateUid();
                $sId = $oRs->fields[0];
                $sSql = "insert into oxaccessoire2article (oxid, oxobjectid, oxarticlenid) " .
                        "VALUES (" . $oDb->quote($sUId) . ", " . $oDb->quote($sId) . ", " . $oDb->quote($sNewId) . ") ";
                $oDb->execute($sSql);
                $oRs->moveNext();
            }
        }
    }

    protected function _copyStaffelpreis($sOldId, $sNewId)
    {
        $sShopId = $this->getConfig()->getShopId();
        $oPriceList = oxNew("oxlist");
        $oPriceList->init("oxbase", "oxprice2article");
        $sQ = "select * from oxprice2article where oxartid = '{$sOldId}' and oxshopid = '{$sShopId}' " .
              "and (oxamount > 0 or oxamountto > 0) order by oxamount ";
        $oPriceList->selectString($sQ);
        if ($oPriceList->count()) {
            foreach ($oPriceList as $oItem) {
                $oItem->oxprice2article__oxid->setValue($oItem->setId());
                $oItem->oxprice2article__oxartid->setValue($sNewId);
                $oItem->save();
            }
        }
    }

    protected function _copyArtExtends($sOldId, $sNewId)
    {
        $oExt = oxNew("oxbase");
        $oExt->init("oxartextends");
        $oExt->load($sOldId);
        $oExt->setId($sNewId);
        $oExt->save();
    }


    public function saveinnlang()
    {
        $this->save();
    }

    public function addDefaultValues($aParams)
    {
        return $aParams;
    }

    protected function _formJumpList($oArticle, $oParentArticle)
    {
        $aJumpList = array();
        //fetching parent article variants
        $sOxIdField = 'oxarticles__oxid';
        if (isset($oParentArticle)) {
            $aJumpList[] = array($oParentArticle->$sOxIdField->value, $this->_getTitle($oParentArticle));
            $sEditLanguageParameter = oxRegistry::getConfig()->getRequestParameter("editlanguage");
            $oParentVariants = $oParentArticle->getAdminVariants($sEditLanguageParameter);
            if ($oParentVariants->count()) {
                foreach ($oParentVariants as $oVar) {
                    $aJumpList[] = array($oVar->$sOxIdField->value, " - " . $this->_getTitle($oVar));
                    if ($oVar->$sOxIdField->value == $oArticle->$sOxIdField->value) {
                        $oVariants = $oArticle->getAdminVariants($sEditLanguageParameter);
                        if ($oVariants->count()) {
                            foreach ($oVariants as $oVVar) {
                                $aJumpList[] = array($oVVar->$sOxIdField->value, " -- " . $this->_getTitle($oVVar));
                            }
                        }
                    }
                }
            }
        } else {
            $aJumpList[] = array($oArticle->$sOxIdField->value, $this->_getTitle($oArticle));
            //fetching this article variants data
            $oVariants = $oArticle->getAdminVariants(oxRegistry::getConfig()->getRequestParameter("editlanguage"));
            if ($oVariants && $oVariants->count()) {
                foreach ($oVariants as $oVar) {
                    $aJumpList[] = array($oVar->$sOxIdField->value, " - " . $this->_getTitle($oVar));
                }
            }
        }
        if (count($aJumpList) > 1) {
            $this->_aViewData["thisvariantlist"] = $aJumpList;
        }
    }

    protected function _getTitle($oObj)
    {
        $sTitle = $oObj->oxarticles__oxtitle->value;
        if (!strlen($sTitle)) {
            $sTitle = $oObj->oxarticles__oxvarselect->value;
        }

        return $sTitle;
    }

    public function getCategoryList()
    {
        $oCatTree = oxNew("oxCategoryList");
        $oCatTree->loadList();

        return $oCatTree;
    }

    public function getVendorList()
    {
        $oVendorlist = oxNew("oxvendorlist");
        $oVendorlist->loadVendorList();

        return $oVendorlist;
    }

    public function getManufacturerList()
    {
        $oManufacturerList = oxNew("oxmanufacturerlist");
        $oManufacturerList->loadManufacturerList();

        return $oManufacturerList;
    }
}