article_overview.php

Go to the documentation of this file.

<?php

class Article_Overview extends oxAdminDetails
{

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

        parent::render();

        $this->_aViewData['edit'] = $oArticle = oxNew('oxarticle');

        $soxId = $this->getEditObjectId();
        if ($soxId != "-1" && isset($soxId)) {

            // load object
            $oArticle->loadInLang(oxRegistry::getConfig()->getRequestParameter("editlanguage"), $soxId);


            $oDB = oxDb::getDb();

            // 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;
            }

            // ordered amount
            $sSelect = "select sum(oxamount) from oxorderarticles ";
            $sSelect .= "where oxartid=" . $oDB->quote($soxId);
            $this->_aViewData["totalordercnt"] = $iTotalOrderCnt = (float) $oDB->getOne($sSelect);

            // sold amount
            $sSelect = "select sum(oxorderarticles.oxamount) from  oxorderarticles, oxorder " .
                       "where (oxorder.oxpaid>0 or oxorder.oxsenddate > 0) and oxorderarticles.oxstorno != '1' " .
                       "and oxorderarticles.oxartid=" . $oDB->quote($soxId) .
                       "and oxorder.oxid =oxorderarticles.oxorderid";
            $this->_aViewData["soldcnt"] = $iSoldCnt = (float) $oDB->getOne($sSelect);

            // canceled amount
            $sSelect = "select sum(oxamount) from oxorderarticles where oxstorno = '1' " .
                       "and oxartid=" . $oDB->quote($soxId);
            $this->_aViewData["canceledcnt"] = $iCanceledCnt = (float) $oDB->getOne($sSelect);

            // not yet processed
            $this->_aViewData["leftordercnt"] = $iTotalOrderCnt - $iSoldCnt - $iCanceledCnt;

            // position in top ten
            $sSelect = "select oxartid,sum(oxamount) as cnt from oxorderarticles " .
                       "group by oxartid order by cnt desc";

            $rs = $oDB->execute($sSelect);
            $iTopPos = 0;
            $iPos = 0;
            if ($rs != false && $rs->recordCount() > 0) {
                while (!$rs->EOF) {
                    $iPos++;
                    if ($rs->fields[0] == $soxId) {
                        $iTopPos = $iPos;
                    }
                    $rs->moveNext();
                }
            }

            $this->_aViewData["postopten"] = $iTopPos;
            $this->_aViewData["toptentotal"] = $iPos;
        }

        $this->_aViewData["afolder"] = $myConfig->getConfigParam('aProductfolder');
        $this->_aViewData["aSubclass"] = $myConfig->getConfigParam('aArticleClasses');

        return "article_overview.tpl";
    }

}