newsletter_selection.php

Go to the documentation of this file.

<?php

class Newsletter_Selection extends oxAdminDetails
{
    public function render()
    {
        parent::render();

        // all newslettergroups
        $oGroups = oxNew( "oxlist" );
        $oGroups->init( "oxgroups" );
        $oGroups->selectString( "select * from oxgroups" );


        $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
            $oNewsletter = oxNew( "oxnewsletter" );
            $oNewsletter->load( $soxId );
            $oNewsletterGroups = $oNewsletter->getGroups();
            $this->_aViewData["edit"] =  $oNewsletter;

            // remove already added groups
            foreach ( $oNewsletterGroups as $oInGroup ) {
                foreach ( $oGroups as $sKey => $oGroup ) {
                    if ( $oGroup->oxgroups__oxid->value == $oInGroup->oxgroups__oxid->value ) {
                        // already in, so lets remove it
                        $oGroups->offsetUnset( $sKey );
                        break;
                    }
                }
            }

            // get nr. of users in these groups
            // we do not use lists here as we dont need this overhead right now
            $oDB = oxDb::getDb();
            $sSelectGroups =  "  ( oxobject2group.oxgroupsid in ( ";
            $blSep = false;
            foreach ( $oNewsletterGroups as $sInGroup) {
                $sSearchKey = $sInGroup->oxgroups__oxid->value;
                if ( $blSep)
                    $sSelectGroups .= ",";
                $sSelectGroups .= $oDB->quote( $sSearchKey );
                $blSep = true;
            }
            $sSelectGroups .= ") ) ";
            // no group selected
            if ( !$blSep)
                $sSelectGroups = " oxobject2group.oxobjectid is null ";

            $sSelect = "select oxnewssubscribed.oxemail 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";

            $rs = $oDB->execute( $sSelect);
            $iCnt = 0;
            if ($rs != false && $rs->recordCount() > 0) {
                while (!$rs->EOF) {
                    $iCnt++;
                    $rs->moveNext();
                }
            }
            $this->_aViewData["user"] =  $iCnt;


            if ( oxConfig::getParameter("aoc") ) {

                $aColumns = array();
                include_once 'inc/'.strtolower(__CLASS__).'.inc.php';
                $this->_aViewData['oxajax'] = $aColumns;

                return "popups/newsletter_selection.tpl";
            }
        }

        $this->_aViewData["allgroups"] =  $oGroups;

        return "newsletter_selection.tpl";
    }

    public function save()
    {
        $soxId      = oxConfig::getParameter( "oxid");
        $aParams    = oxConfig::getParameter( "editval");

        // shopid
        $sShopID = oxSession::getVar( "actshop");
        $aParams['oxnewsletter__oxshopid'] = $sShopID;

        $oNewsletter = oxNew( "oxNewsLetter" );
        if( $soxId != "-1")
            $oNewsletter->load( $soxId );
        else
            $aParams['oxnewsletter__oxid'] = null;
        //$aParams = $oNewsletter->ConvertNameArray2Idx( $aParams);
        $oNewsletter->assign( $aParams );
        $oNewsletter->save();
        // set oxid if inserted
        if ( $soxId == "-1")
            oxSession::setVar( "saved_oxid", $oNewsletter->oxnewsletter__oxid->value);
    }
}