source/Application/Controller/Admin/DynamicExportBaseController.php
protected function _removeParentArticles($sHeapTable)
    {
        if (!(\OxidEsales\Eshop\Core\Registry::getConfig()->getRequestParameter("blExportMainVars"))) {
            $oDB = \OxidEsales\Eshop\Core\DatabaseProvider::getDb();
            $sArticleTable = getViewName('oxarticles');

            // we need to remove again parent articles so that we only have the variants itself
            $sQ = "select $sHeapTable.oxid from $sHeapTable, $sArticleTable where
                          $sHeapTable.oxid = $sArticleTable.oxparentid group by $sHeapTable.oxid";

            $oRs = $oDB->select($sQ);
            $sDel = "delete from $sHeapTable where oxid in ( ";
            $blSep = false;
            if ($oRs != false && $oRs->count() > 0) {
                while (!$oRs->EOF) {
                    if ($blSep) {
                        $sDel .= ",";
                    }
                    $sDel .= $oDB->quote($oRs->fields[0]);
                    $blSep = true;
                    $oRs->fetchRow();
                }
            }
            $sDel .= " )";
            $oDB->execute($sDel);
        }
    }
protected function _removeParentArticles($sHeapTable)
    {
        if (!(\OxidEsales\Eshop\Core\Registry::getConfig()->getRequestParameter("blExportMainVars"))) {
            $oDB = \OxidEsales\Eshop\Core\DatabaseProvider::getDb();
            $sArticleTable = getViewName('oxarticles');

            // we need to remove again parent articles so that we only have the variants itself
            $sQ = "select $sHeapTable.oxid from $sHeapTable, $sArticleTable where
                          $sHeapTable.oxid = $sArticleTable.oxparentid group by $sHeapTable.oxid";

            $oRs = $oDB->select($sQ);
            $sDel = "delete from $sHeapTable where oxid in ( ";
            $blSep = false;
            if ($oRs != false && $oRs->count() > 0) {
                while (!$oRs->EOF) {
                    if ($blSep) {
                        $sDel .= ",";
                    }
                    $sDel .= $oDB->quote($oRs->fields[0]);
                    $blSep = true;
                    $oRs->fetchRow();
                }
            }
            $sDel .= " )";
            $oDB->execute($sDel);
        }
    }
protected function _removeParentArticles ( $ sHeapTable ) { if ( ! ( \ OxidEsales \ Eshop \ Core \ Registry :: getConfig ( ) -> getRequestParameter ( "blExportMainVars" ) ) ) { $ oDB = \ OxidEsales \ Eshop \ Core \ DatabaseProvider :: getDb ( ) ; $ sArticleTable = getViewName ( 'oxarticles' ) ; // we need to remove again parent articles so that we only have the variants itself $ sQ = "select $sHeapTable.oxid from $sHeapTable, $sArticleTable where
                          $sHeapTable.oxid = $sArticleTable.oxparentid group by $sHeapTable.oxid" ; $ oRs = $ oDB -> select ( $ sQ ) ; $ sDel = "delete from $sHeapTable where oxid in ( " ; $ blSep = false ; if ( $ oRs != false && $ oRs -> count ( ) > 0 ) { while ( ! $ oRs -> EOF ) { if ( $ blSep ) { $ sDel .= "," ; } $ sDel .= $ oDB -> quote ( $ oRs -> fields [ 0 ] ) ; $ blSep = true ; $ oRs -> fetchRow ( ) ; } } $ sDel .= " )" ; $ oDB -> execute ( $ sDel ) ; } }
removes parent articles so that we only have variants itself

@param string $sHeapTable table name
removes parent articles so that we only have variants itself