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
            if ( isset($aParams["oxarticles__oxprice"]) && $aParams["oxarticles__oxprice"] != $oArticle->oxarticles__oxprice->value) {
                $this->resetCounter( "priceCatArticle", $oArticle->oxarticles__oxprice->value );
            }

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

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

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

            // manufacturers
            if ( isset($aParams['oxarticles__oxmanufacturerid']) && $aParams['oxarticles__oxmanufacturerid'] != $oArticle->oxarticles__oxmanufacturerid->value ) {
                $aResetIds['manufacturer'][$aParams['oxarticles__oxmanufacturerid']] = 1;
                $aResetIds['manufacturer'][$oArticle->oxarticles__oxmanufacturerid->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 );


            $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
                if ( $myConfig->getConfigParam( 'blWarnOnSameArtNums' ) &&
                     $oArticle->oxarticles__oxartnum->value && oxConfig::getParameter( 'fnc' ) == 'copyArticle' ) {
                    $sSelect = "select oxid from ".$oArticle->getCoreTableName()."
                                where oxartnum = ".$oDb->quote( $oArticle->oxarticles__oxartnum->value )." and oxid != ".$oDb->quote( $sNewId );

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

    protected function _copyCategories( $sOldId, $sNewId )
    {
        $myUtilsObject = oxUtilsObject::getInstance();
        $oShopMetaData = oxRegistry::get("oxShopMetaData");
        $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];


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

                $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];
                $oDb->execute( "insert into oxobject2selectlist (oxid, oxobjectid, oxselnid) VALUES (".$oDb->quote( $sUid ).", ".$oDb->quote( $sNewId ).", ".$oDb->quote( $sId ).") " );
                $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];
                $oDb->execute("insert into oxobject2article (oxid, oxobjectid, oxarticlenid) VALUES (".$oDb->quote( $sUid ).", ".$oDb->quote( $sId ).", ".$oDb->quote( $sNewId )." ) ");
                $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];
                $oDb->execute( "insert into oxaccessoire2article (oxid, oxobjectid, oxarticlenid) VALUES (".$oDb->quote( $sUId ).", ".$oDb->quote( $sId ).", ".$oDb->quote( $sNewId ).") " );
                $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
        if ( isset( $oParentArticle ) ) {
            $aJumpList[] = array( $oParentArticle->oxarticles__oxid->value, $this->_getTitle( $oParentArticle ) );
            $oParentVariants = $oParentArticle->getAdminVariants( oxConfig::getParameter( "editlanguage" ) );
            if ( $oParentVariants->count()) {
                foreach ( $oParentVariants as $oVar) {
                    $aJumpList[] = array( $oVar->oxarticles__oxid->value, " - ".$this->_getTitle( $oVar ) );
                    if ( $oVar->oxarticles__oxid->value == $oArticle->oxarticles__oxid->value ) {
                        $oVariants = $oArticle->getAdminVariants(oxConfig::getParameter( "editlanguage"));
                        if ( $oVariants->count() ) {
                            foreach ( $oVariants as $oVVar) {
                                $aJumpList[] = array( $oVVar->oxarticles__oxid->value, " -- ".$this->_getTitle( $oVVar));
                            }
                        }
                    }
                }
            }
        } else {
            $aJumpList[] = array( $oArticle->oxarticles__oxid->value, $this->_getTitle( $oArticle));
            //fetching this article variants data
            $oVariants = $oArticle->getAdminVariants(oxConfig::getParameter( "editlanguage"));
            if ( $oVariants && $oVariants->count())
                foreach ($oVariants as $oVar) {
                    $aJumpList[] = array( $oVar->oxarticles__oxid->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;
    }
}