pricealarm_main.php

Go to the documentation of this file.

<?php

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

            // #1140 R - price must be checked from the object.
            $sql = "select oxarticles.oxid, oxpricealarm.oxprice from oxpricealarm, oxarticles where oxarticles.oxid = oxpricealarm.oxartid and oxpricealarm.oxsended = '000-00-00 00:00:00'";
            $rs = oxDb::getDb()->Execute( $sql);
            $iAllCnt_counting = 0;
            if ($rs != false && $rs->recordCount() > 0) {
                while (!$rs->EOF) {
                    $oArticle = oxNew("oxarticle" );
                    $oArticle->load($rs->fields[0]);
                    if ($oArticle->getPrice()->getBruttoPrice() <= $rs->fields[1])
                        $iAllCnt_counting++;
                    $rs->moveNext();
                }
            }
            $this->_aViewData['iAllCnt'] = $iAllCnt_counting;

        $soxId = oxConfig::getParameter( "oxid");
        // check if we right now saved a new entry
        $sSavedID = oxConfig::getParameter( "saved_oxid");
        if ( ($soxId == "-1" || !isset( $soxId)) && isset( $sSavedID) ) {
            $soxId = $sSavedID;
            oxSession::deleteVar( "saved_oxid");
            $this->_aViewData["oxid"] =  $soxId;
            // for reloading upper frame
            $this->_aViewData["updatelist"] =  "1";
        }

        if ( $soxId != "-1" && isset( $soxId)) {
            // load object
            $oPricealarm = oxNew( "oxpricealarm" );
            $oPricealarm->load( $soxId);

            $oDefCurr = $myConfig->getActShopCurrencyObject();
            $oArticle = oxNew( "oxarticle" );
            $oArticle->load($oPricealarm->oxpricealarm__oxartid->value);

            if ( $oArticle->oxarticles__oxparentid->value && !$oArticle->oxarticles__oxtitle->value) {
                $oParent = oxNew( "oxarticle" );
                $oParent->load($oArticle->oxarticles__oxparentid->value);
                $oArticle->oxarticles__oxtitle->setValue($oParent->oxarticles__oxtitle->value." ".$oArticle->oxarticles__oxvarselect->value);
            }


            $oThisCurr = $myConfig->getCurrencyObject( $oPricealarm->oxpricealarm__oxcurrency->value);

            if ( !$oThisCurr ) {
                $oThisCurr = $oDefCurr;
                $oPricealarm->oxpricealarm__oxcurrency->setValue($oDefCurr->name);
            }

            // #889C - Netto prices in Admin
            // (we have to call $oArticle->getPrice() to get price with VAT)
            $oLang = oxLang::getInstance();
            $oArticle->oxarticles__oxprice->setValue($oArticle->getPrice()->getBruttoPrice() * $oThisCurr->rate);
            $oArticle->fprice = $oLang->formatCurrency( $oArticle->oxarticles__oxprice->value, $oThisCurr);

            $oPricealarm->oxpricealarm__oxprice->setValue( $oLang->formatCurrency( $oPricealarm->oxpricealarm__oxprice->value, $oThisCurr));

            $oPricealarm->oArticle = $oArticle;
            $oCur = $myConfig->getCurrencyObject( $oPricealarm->oxpricealarm__oxcurrency->value);

            // customer info
            $oUser = null;
            if ( $oPricealarm->oxpricealarm__oxuserid->value) {
                $oUser = oxNew( "oxuser" );
                $oUser->load($oPricealarm->oxpricealarm__oxuserid->value);
                $oPricealarm->oUser = $oUser;
            }
            //
            $oShop = oxNew( "oxshop" );
            $oShop->load( $myConfig->getShopId());
            $oShop = $this->addGlobalParams( $oShop);

            $smarty = oxUtilsView::getInstance()->getSmarty();
            $smarty->assign( "shop", $oShop );
            $smarty->assign( "product", $oArticle );
            $smarty->assign( "bidprice", $oPricealarm->oxpricealarm__oxprice->value);
            $smarty->assign( "shopImageDir", $myConfig->getImageUrl( false , false ) );
            $smarty->assign( "currency", $oCur );

            $iLang = @$oPricealarm->oxpricealarm__oxlang->value;
            if (!$iLang)
                $iLang = 0;
            $aLanguages = $oLang->getLanguageNames();
            $this->_aViewData["edit_lang"] = $aLanguages[$iLang];
            // rendering mail message text
            $oLetter = new oxStdClass();
            $aParams = oxConfig::getParameter( "editval");
            if ( isset( $aParams['oxpricealarm__oxlongdesc'] ) && $aParams['oxpricealarm__oxlongdesc'] ) {
                $oLetter->oxpricealarm__oxlongdesc = new oxField( stripslashes( $aParams['oxpricealarm__oxlongdesc'] ), oxField::T_RAW );
            } else {
                $old_iLang = $oLang->getTplLanguage();
                $oLang->setTplLanguage( $iLang );
                $smarty->fetch( "email_pricealarm_customer.tpl");

                $oLetter->oxpricealarm__oxlongdesc = new oxField( $smarty->fetch( "email_pricealarm_customer.tpl"), oxField::T_RAW );
                $oLang->setTplLanguage( $old_iLang );
            }

            $this->_aViewData["editor"]  = $this->_generateTextEditor( "100%", 300, $oLetter, "oxpricealarm__oxlongdesc", "details.tpl.css");
            $this->_aViewData["edit"] =  $oPricealarm;
            $this->_aViewData["oxid"] = $soxId;
            $this->_aViewData["actshop"] = $oShop->getShopId();
        }

        parent::render();

        return "pricealarm_main.tpl";
    }

    public function send()
    {
        // error
        if ( !oxConfig::getParameter( "oxid")) {
            $this->_aViewData["mail_err"] = 1;
            return;
        }

        $oPricealarm = oxNew( "oxpricealarm" );
        $oPricealarm->load( oxConfig::getParameter( "oxid"));

        // Send Email
        $oShop = oxNew( "oxshop" );
        $oShop->load( $oPricealarm->oxpricealarm__oxshopid->value );

        $oArticle = oxNew( "oxarticle" );
        $oArticle->load( $oPricealarm->oxpricealarm__oxartid->value);

        //arranging user email
        $oEmail = oxNew( "oxemail" );
        $oEmail->setFrom( $oShop->oxshops__oxorderemail->value, $oShop->oxshops__oxname->getRawValue() );
        $oEmail->setSmtp( $oShop );

        $aParams = oxConfig::getParameter( "editval" );
        $sContent = isset( $aParams['oxpricealarm__oxlongdesc'] ) ? stripslashes( $aParams['oxpricealarm__oxlongdesc'] ) : '';
        if ( $sContent ) {
            $sContent = oxUtilsView::getInstance()->parseThroughSmarty( $sContent, $oPricealarm->getId() );
        }

        $oEmail->setBody( $sContent );
        $oEmail->setSubject( $oShop->oxshops__oxname->getRawValue() );
        $oEmail->setRecipient( $oPricealarm->oxpricealarm__oxemail->value, $oPricealarm->oxpricealarm__oxemail->value );
        $oEmail->setReplyTo( $oShop->oxshops__oxorderemail->value, $oShop->oxshops__oxname->getRawValue() );

        // setting result message
        if ( $oEmail->send() ) {
            $oPricealarm->oxpricealarm__oxsended->setValue( date( "Y-m-d H:i:s" ) );
            $oPricealarm->save();
            $this->_aViewData["mail_succ"] = 1;
        } else {
            $this->_aViewData["mail_err"] = 1;
        }
    }
}

---