oxnewsletter.php

Go to the documentation of this file.

<?php

class oxNewsletter extends oxBase
{
    protected $_sHtmlText = null;

    protected $_sPlainText = null;

    protected $_oGroups = null;

    protected $_oUser = null;

    protected $_sClassName = 'oxnewsletter';

    public function __construct()
    {
        parent::__construct();
        $this->init( 'oxnewsletter' );
    }

    public function delete( $sOxId = null )
    {
        if ( !$sOxId) {
            $sOxId = $this->getId();
        }
        if ( !$sOxId) {
            return false;
        }

        $blDeleted = parent::delete( $sOxId );

        if ( $blDeleted ) {
            $sDelete = "delete from oxobject2group where oxobject2group.oxshopid = '".$this->getShopId()."' and oxobject2group.oxobjectid = '$sOxId' ";
            oxDb::getDb()->execute( $sDelete );
        }

        return $blDeleted;
    }

    public function getGroups()
    {
        if ( isset( $this->_oGroups ) ) {
            return $this->_oGroups;
        }

        // usergroups
        $this->_oGroups = oxNew( "oxList", "oxgroups" );

        // performance
        $sSelect  = 'select oxgroups.* from oxgroups, oxobject2group ';
        $sSelect .= 'where oxobject2group.oxobjectid="'.$this->getId().'" ';
        $sSelect .= 'and oxobject2group.oxgroupsid=oxgroups.oxid ';
        $this->_oGroups->selectString( $sSelect );

        return $this->_oGroups;
    }

    public function getHtmlText()
    {
        return $this->_sHtmlText;
    }

    public function getPlainText()
    {
        return $this->_sPlainText;
    }

    public function prepare( $sUserid, $blPerfLoadAktion = false )
    {
        // switching off admin
        $blAdmin = $this->isAdmin();
        $this->setAdminMode( false );

        // add currency
        $this->_setUser( $sUserid );

        $this->_setParams( $blPerfLoadAktion );

        // restoring mode ..
        $this->setAdminMode( $blAdmin );
    }

    public function send()
    {
        $oxEMail = oxNew( 'oxemail' );
        $blSend = $oxEMail->sendNewsletterMail( $this, $this->_oUser );
        //print_r($oxEMail);
        // store failed info
        if ( !$blSend ) {
            oxDb::getDb()->Execute( "update oxnewssubscribed set oxemailfailed = '1' where oxemail = '".$this->_oUser->oxuser__oxusername->value."'");
        }

        return $blSend;
    }

    protected function _setParams( $blPerfLoadAktion = false )
    {
        $myConfig = $this->getConfig();

        $oShop = oxNew( 'oxshop' );
        $oShop->load( $myConfig->getShopId() );

        $oView = oxNew( 'oxubase' );
        $oShop = $oView->addGlobalParams( $oShop );

        $oView->addTplParam( 'myshop', $oShop );
        $oView->addTplParam( 'shop', $oShop );
        $oView->addTplParam( 'oViewConf', $oShop );
        $oView->addTplParam( 'oView', $oView );
        $oView->addTplParam( 'mycurrency', $myConfig->getActShopCurrencyObject() );
        $oView->addTplParam( 'myuser', $this->_oUser );

        $this->_assignProducts( $oView, $blPerfLoadAktion );

        $aInput[] = array( $this->getId().'html', $this->oxnewsletter__oxtemplate->value );
        $aInput[] = array( $this->getId().'plain', $this->oxnewsletter__oxplaintemplate->value );
        $aRes = oxUtilsView::getInstance()->parseThroughSmarty( $aInput, null, $oView, true );

        $this->_sHtmlText  = $aRes[0];
        $this->_sPlainText = $aRes[1];
    }

    protected function _setUser( $sUserid )
    {
        if ( is_string( $sUserid )) {
            $oUser = oxNew( 'oxuser' );
            if ( $oUser->load( $sUserid ) ) {
                $this->_oUser = $oUser;
            }
        } else {
            $this->_oUser = $sUserid;   // we expect a full and valid user object
        }
    }

    protected function _assignProducts( $oView, $blPerfLoadAktion = false )
    {
        if ( $blPerfLoadAktion ) {
            $oArtList = oxNew( 'oxarticlelist' );
            $oArtList->loadAktionArticles( 'OXNEWSLETTER' );
            $oView->addTplParam( 'articlelist', $oArtList );
        }

        if ( $this->_oUser->getId() ) {
            $oArticle = oxNew( 'oxarticle' );
            $sArticleTable = $oArticle->getViewName();

            // add products which fit to the last order of this user
            $sSelect  = "select $sArticleTable.* from oxorder left join oxorderarticles on oxorderarticles.oxorderid = oxorder.oxid";
            $sSelect .= " left join $sArticleTable on oxorderarticles.oxartid = $sArticleTable.oxid";
            $sSelect .= " where ".$oArticle->getSqlActiveSnippet();
            $sSelect .= " and oxorder.oxuserid = '".$this->_oUser->oxuser__oxid->value."' order by oxorder.oxorderdate desc";

            if ( $oArticle->assignRecord( $sSelect ) ) {
                $oSimList = $oArticle->getSimilarProducts();
                if ( $oSimList && $oSimList->count() ) {
                    $oView->addTplParam( 'simlist', $oSimList );
                    $iCnt = 0;
                    foreach ( $oSimList as $oArt ) {
                        $oView->addTplParam( "simarticle$iCnt", $oArt );
                        $iCnt++;
                    }
                }
            }
        }
    }

    protected function _setFieldData( $sFieldName, $sValue, $iDataType = oxField::T_TEXT )
    {
        if ( 'oxtemplate' === $sFieldName || 'oxplaintemplate' === $sFieldName ) {
            $iDataType = oxField::T_RAW;
        }
        return parent::_setFieldData($sFieldName, $sValue, $iDataType);
    }
}

---