pricealarm_mail.php

Go to the documentation of this file.

<?php

class PriceAlarm_Mail extends oxAdminDetails
{
    public function render()
    {
        $myConfig = $this->getConfig();

        parent::render();
        // #889C - Netto prices in Admin
        $sIndex="";
        if ( $myConfig->getConfigParam( 'blEnterNetPrice' ) )
            $sIndex = " * ". (1+$myConfig->getConfigParam( 'dDefaultVAT' )/100);

        $sShopID = $myConfig->getShopId();
        //articles price in subshop and baseshop can be different
        $this->_aViewData['iAllCnt'] = 0;
        $sQ = "select oxprice, oxartid from oxpricealarm where oxsended = '000-00-00 00:00:00' and oxshopid = '$sShopID' ";
        $rs = oxDb::getDb()->execute($sQ);
        if ($rs != false && $rs->recordCount() > 0) {
            $aSimpleCache = array();
            while (!$rs->EOF) {
                $sPrice = $rs->fields[0];
                $sArtID = $rs->fields[1];
                if (isset($aSimpleCache[$sArtID])) {
                    if ($aSimpleCache[$sArtID] <= $sPrice) {
                        $this->_aViewData['iAllCnt'] += 1;
                    }
                } else {
                    $oArticle = oxNew( "oxarticle" );
                    if ( $oArticle->load($sArtID)) {
                        $dArtPrice = $aSimpleCache[$sArtID] = $oArticle->getPrice()->getBruttoPrice();
                        if ($dArtPrice <= $sPrice) {
                            $this->_aViewData['iAllCnt'] += 1;
                        }
                    }
                }
                $rs->moveNext();
            }
        }
        return "pricealarm_mail.tpl";
    }
}