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 ".getViewName( "oxgroups", $this->_iEditLang ) );


        $soxId = $this->_aViewData["oxid"] = $this->getEditObjectId();
        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 = $this->getEditObjectId();
        $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
        $this->setEditObjectId( $oNewsletter->getId() );
    }
}