newsletter_selection.php

Go to the documentation of this file.

<?php

class Newsletter_Selection extends oxAdminDetails
{
    protected $_iUserCount = null;

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

        $soxId = $this->_aViewData["oxid"] = $this->getEditObjectId();
        if ( $soxId != "-1" && isset( $soxId ) ) {
            // load object
            $oNewsletter = oxNew( "oxnewsletter" );
            if ( $oNewsletter->load( $soxId ) ) {
                $this->_aViewData["edit"] = $oNewsletter;

                if ( oxConfig::getParameter("aoc") ) {
                    $aColumns = array();
                    include_once 'inc/'.strtolower(__CLASS__).'.inc.php';
                    $this->_aViewData['oxajax'] = $aColumns;
                    return "popups/newsletter_selection.tpl";
                }
            }
        }

        return "newsletter_selection.tpl";
    }

    public function getUserCount()
    {
        if ( $this->_iUserCount === null ) {
            $this->_iUserCount = 0;

            // load object
            $oNewsletter = oxNew( "oxnewsletter" );
            if ( $oNewsletter->load( $this->getEditObjectId() ) ) {
                // get nr. of users in these groups
                // we do not use lists here as we dont need this overhead right now
                $oDB = oxDb::getDb();
                $blSep = false;
                $sSelectGroups = " ( oxobject2group.oxgroupsid in ( ";

                // remove already added groups
                foreach ( $oNewsletter->getGroups() as $oInGroup ) {
                    if ( $blSep ) {
                        $sSelectGroups .= ",";
                    }
                    $sSelectGroups .= $oDB->quote( $oInGroup->oxgroups__oxid->value );
                    $blSep = true;
                }

                $sSelectGroups .= " ) ) ";

                // no group selected
                if ( !$blSep ) {
                    $sSelectGroups = " oxobject2group.oxobjectid is null ";
                }

                $sQ = "select count(*) from ( select oxnewssubscribed.oxemail as _icnt from oxnewssubscribed left join
                       oxobject2group on oxobject2group.oxobjectid = oxnewssubscribed.oxuserid
                       where ( oxobject2group.oxshopid = '".$this->getConfig()->getShopID()."'
                       or oxobject2group.oxshopid is null ) and {$sSelectGroups} and
                       oxnewssubscribed.oxdboptin = 1 and ( not ( oxnewssubscribed.oxemailfailed = '1') )
                       and (not(oxnewssubscribed.oxemailfailed = '1')) group by oxnewssubscribed.oxemail ) as _tmp";

                $this->_iUserCount = $oDB->getOne( $sQ );
            }
        }
        return $this->_iUserCount;
    }

    public function save()
    {
        $soxId = $this->getEditObjectId();
        $aParams = oxConfig::getParameter( "editval");
        $aParams['oxnewsletter__oxshopid'] = $this->getConfig()->getShopId();

        $oNewsletter = oxNew( "oxNewsLetter" );
        if ( $soxId != "-1" ) {
            $oNewsletter->load( $soxId );
        } else {
            $aParams['oxnewsletter__oxid'] = null;
        }

        $oNewsletter->assign( $aParams );
        $oNewsletter->save();

        // set oxid if inserted
        $this->setEditObjectId( $oNewsletter->getId() );
    }
}