oxnewssubscribed.php

Go to the documentation of this file.

<?php

class oxNewsSubscribed extends oxBase
{
    protected $_blWasSubscribed = false;

    protected $_sClassName = 'oxnewssubscribed';


    public function __construct()
    {

        parent::__construct();

        $this->init( 'oxnewssubscribed' );
    }


    public function load( $oxId )
    {
        $blRet = parent::load( $oxId );

        if ( $this->oxnewssubscribed__oxdboptin->value == 1) {
            $this->_blWasSubscribed = true;
        }

        return $blRet;
    }

    public function loadFromEmail( $sEmailAddress )
    {
        $oDb = oxDb::getDb();
        $sEmailAddressQuoted = $oDb->quote( $sEmailAddress );
            $sOxId = $oDb->getOne( "select oxid from oxnewssubscribed where oxemail = {$sEmailAddressQuoted} " );

        return $this->load( $sOxId );
    }

    public function loadFromUserId( $sOxUserId )
    {
        $oDb = oxDb::getDb( true );
        $sOxId = $oDb->getOne( "select oxid from oxnewssubscribed where oxuserid = " . $oDb->quote( $sOxUserId ) );
        return $this->load( $sOxId );
    }

    protected function _insert()
    {
        // set subscription date
        $this->oxnewssubscribed__oxsubscribed = new oxField(date( 'Y-m-d H:i:s' ), oxField::T_RAW);
        return parent::_insert();
    }

    protected function _update()
    {
        if ( $this->_blWasSubscribed && !$this->oxnewssubscribed__oxdboptin->value ) {
            // set unsubscription date
            $this->oxnewssubscribed__oxunsubscribed->setValue(date( 'Y-m-d H:i:s' ));
        } else {
            // don't update date
            $this->_aSkipSaveFields[] = 'oxunsubscribed';
        }

        return parent::_update();
    }

    public function getOptInStatus()
    {
        return $this->oxnewssubscribed__oxdboptin->value;
    }

    public function setOptInStatus( $iStatus )
    {
        $this->oxnewssubscribed__oxdboptin = new oxField($iStatus, oxField::T_RAW);
        $this->save();
    }

    public function getOptInEmailStatus()
    {
        return $this->oxnewssubscribed__oxemailfailed->value;
    }

    public function setOptInEmailStatus( $iStatus )
    {
        $this->oxnewssubscribed__oxemailfailed = new oxField($iStatus, oxField::T_RAW);
        $this->save();
    }

    public function updateSubscription( $oUser )
    {
        // user email changed ?
        if ( $oUser->oxuser__oxusername->value && $this->oxnewssubscribed__oxemail->value != $oUser->oxuser__oxusername->value ) {
            $this->oxnewssubscribed__oxemail = new oxField( $oUser->oxuser__oxusername->value, oxField::T_RAW );
        }

        // updating some other fields
        $this->oxnewssubscribed__oxsal   = new oxField( $oUser->oxuser__oxsal->value, oxField::T_RAW );
        $this->oxnewssubscribed__oxfname = new oxField( $oUser->oxuser__oxfname->value, oxField::T_RAW );
        $this->oxnewssubscribed__oxlname = new oxField( $oUser->oxuser__oxlname->value, oxField::T_RAW );

        return (bool) $this->save();
    }
}