oxnewsletter.php

Go to the documentation of this file.

<?php

class oxNewsletter extends oxBase
{
    protected $_oSmarty = null;

    protected $_sHtmlText = null;

    protected $_sPlainText = null;

    protected $_oGroups = null;

    protected $_oUser = null;

    protected $_sClassName = 'oxnewsletter';

    public function __construct()
    {
        parent::__construct();

        $this->init( 'oxnewsletter' );

        $this->_oSmarty = oxUtilsView::getInstance()->getSmarty();
        $this->_oSmarty->force_compile = true;
    }

    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 );

        $myConfig = $this->getConfig();

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

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

        $this->_setParams( $oShop, $myConfig->getActShopCurrencyObject(), $blPerfLoadAktion );

        $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( $oShop, $oCurrency, $blPerfLoadAktion = false )
    {
        $this->_oSmarty->assign( 'myshop', $oShop );
        $this->_oSmarty->assign( 'shop', $oShop );
        $this->_oSmarty->assign( 'mycurrency', $oCurrency );
        $this->_oSmarty->assign( 'myuser', $this->_oUser );

        $this->_assignProducts( $blPerfLoadAktion );

        // set for smarty
        // actually I think this should solve our problems with newsletter
        // AFAIK the problem was that I always used the same name for fetching so smarty caches this template then
        $this->_oSmarty->oxidcache = clone $this->oxnewsletter__oxtemplate;
        $this->_sHtmlText  = $this->_oSmarty->fetch( 'ox:'.$this->oxnewsletter__oxid->value.'oxnewsletter__oxtemplate' );

        $this->_oSmarty->oxidcache = clone $this->oxnewsletter__oxplaintemplate;
        $this->_sPlainText = $this->_oSmarty->fetch( 'ox:'.$this->oxnewsletter__oxid->value.'oxnewsletter__oxplaintemplate' );
    }

    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( $blPerfLoadAktion = false )
    {
        if ( $blPerfLoadAktion ) {
            $oArtList = oxNew( 'oxarticlelist' );
            $oArtList->loadAktionArticles( 'OXNEWSLETTER' );
            $this->_oSmarty->assign( '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";

            $oArtList = oxNew( 'oxarticlelist' );
            $oArtList->selectString( $sSelect );

            $oOneArt   = null;
            $oOneOrder = null;
            $aSimList  = array();

            if ( $oArtList->count() ) {
                $oOneArt = $oArtList->current();
            }

            if ( $oOneArt ) {
                $oSimList = $oOneArt->getSimilarProducts();
            }

            if ( $oSimList && $oSimList->count() ) {
                $this->_oSmarty->assign( 'simlist', $oSimList );
                $iCnt = 0;
                foreach ( $oSimList as $oArt ) {
                    $sName = "simarticle$iCnt";
                    $this->_oSmarty->assign( $sName, $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);
    }
}

---