oxuserpayment.php

Go to the documentation of this file.

<?php

class oxUserPayment extends oxBase
{

    // you can change this if you want more security
    // DO NOT !! CHANGE THIS FILE AND STORE CREDIT CARD INFORMATION
    // THIS IS MORE THAN LIKELY ILLEGAL !!
    // CHECK YOUR CREDIT CARD CONTRACT

    protected $_sPaymentKey = 'fq45QS09_fqyx09239QQ';

    protected $_sClassName = 'oxuserpayment';

    protected $_blStoreCreditCardInfo = null;

    protected $_oPayment = null;

    protected $_aDynValues = null;

    protected $_aSkipSaveFields = array( "oxid" );

    public function __get( $sName )
    {
        //due to compatibility with templates
        if ( $sName == 'oxpayments__oxdesc' ) {
            if ( $this->_oPayment === null ) {
                $this->_oPayment = oxNew( 'oxpayment' );
                $this->_oPayment->load( $this->oxuserpayments__oxpaymentsid->value );
            }
            return $this->_oPayment->oxpayments__oxdesc;
        }

        if ( $sName == 'aDynValues' ) {
            if ( $this->_aDynValues === null ) {
                $this->_aDynValues = $this->getDynValues();
            }
            return $this->_aDynValues;
        }

        return parent::__get( $sName );
    }

    public function __construct()
    {
        parent::__construct();
        $this->init( 'oxuserpayments' );
        $this->_sPaymentKey = oxUtils::getInstance()->strRot13( $this->_sPaymentKey );
        $this->setStoreCreditCardInfo( $this->getConfig()->getConfigParam( 'blStoreCreditCardInfo' ) );
    }

    public function getPaymentKey()
    {
        return $this->_sPaymentKey;
    }

    public function load( $sOxId )
    {
        $sSelect = 'select oxid, oxuserid, oxpaymentsid, DECODE( oxvalue, "'.$this->getPaymentKey().'" ) as oxvalue
                    from oxuserpayments where oxid = '. oxDb::getDb()->quote( $sOxId );

        return $this->assignRecord( $sSelect );
    }


    protected function _insert()
    {
        // we do not store credit card information
        // check and in case skip it
        if ( !$this->getStoreCreditCardInfo() && $this->oxuserpayments__oxpaymentsid->value == 'oxidcreditcard' ) {
            return true;
        }

        //encode sensitive data
        if ( $sValue = $this->oxuserpayments__oxvalue->value ) {
            $sEncodedValue = oxDb::getDb()->getOne( "select encode( " . oxDb::getDb()->quote( $sValue ) . ", '" . $this->getPaymentKey() . "' )" );
            $this->oxuserpayments__oxvalue->setValue($sEncodedValue);
        }

        $blRet = parent::_insert();

        //restore, as encoding was needed only for saving
        if ( $sEncodedValue ) {
            $this->oxuserpayments__oxvalue->setValue( $sValue );
        }

        return $blRet;
    }

    protected function _update()
    {
        //encode sensitive data
        if ( $sValue = $this->oxuserpayments__oxvalue->value ) {
            $sEncodedValue = oxDb::getDb()->getOne( "select encode( " . oxDb::getDb()->quote( $sValue ) . ", '" . $this->getPaymentKey() . "' )" );
            $this->oxuserpayments__oxvalue->setValue($sEncodedValue);
        }

        // replace (not update) existing record
        //do not allow derived item update
        if ( !$this->allowDerivedUpdate() ) {
            return false;
        }


        $oDb = oxDB::getDb();
        $sUpdate =  "update {$this->_sCoreTable} set ".$this->_getUpdateFields()
                  . " where {$this->_sCoreTable}.oxuserid = " . $oDb->quote( $this->oxuserpayments__oxuserid->value )
                  . " and oxpaymentsid = " . $oDb->quote( $this->oxuserpayments__oxpaymentsid->value )
                  . " limit 1";

        //trigger event
        $this->beforeUpdate();

        $blRet = (bool) $oDb->execute( $sUpdate );
        $this->_rebuildCache();

        //restore, as encoding was needed only for saving
        if ( $sEncodedValue ) {
            $this->oxuserpayments__oxvalue->setValue( $sValue );
        }

        return $blRet;
    }

    public function exists( $sOXID = null )
    {
        if ( !$this->oxuserpayments__oxpaymentsid->value || !$this->oxuserpayments__oxuserid->value ) {
            return false;
        }

        // generating new id..
        if ( !$this->getId() ) {
            $this->setId();
        }

        $oDB = oxDb::getDb( true );
        $sSelect  = "select 1 from oxuserpayments where oxuserid = " . $oDB->quote( $this->oxuserpayments__oxuserid->value );
        $sSelect .= " and oxpaymentsid = " . $oDB->quote( $this->oxuserpayments__oxpaymentsid->value );

        return ( bool ) $oDB->getOne( $sSelect );
    }

    public function delete( $sOXID = null)
    {
        if ( !$sOXID ) {
            $sOXID = $this->getId();

            //do not allow derived deletion
            if ( !$this->allowDerivedDelete() ) {
                return false;
            }
        }

        if ( !$sOXID || !$this->oxuserpayments__oxpaymentsid->value || !$this->oxuserpayments__oxuserid->value  ) {
            return false;
        }


        $oDB = oxDb::getDb(true);
        $sDelete  = "delete from $this->_sCoreTable where oxuserid = " . $oDB->quote( $this->oxuserpayments__oxuserid->value );
        $sSelect .= " and oxpaymentsid = " . $oDB->quote( $this->oxuserpayments__oxpaymentsid->value );

        $rs = $oDB->execute( $sDelete );
        if ( $blDelete = ( bool ) $oDB->affected_Rows() ) {
            $this->onChange(ACTION_DELETE, $sOXID);
        }

        return $blDelete;
    }

    public function setStoreCreditCardInfo( $blStoreCreditCardInfo )
    {
        $this->_blStoreCreditCardInfo = $blStoreCreditCardInfo;
    }

    public function getStoreCreditCardInfo()
    {
        return $this->_blStoreCreditCardInfo;
    }

    public function getPaymentByPaymentType( $oUser = null, $sPaymentType = null )
    {
        $blGet = false;
        if ( $oUser && $sPaymentType != null ) {
            $sSelect  = 'select oxid from oxuserpayments where oxpaymentsid=' . oxDb::getDb()->quote( $sPaymentType ) . ' and oxuserid="' . $oUser->getId() . '" ';
            if ( ( $sOxId = oxDb::getDb()->getOne( $sSelect ) ) ) {
                $blGet = $this->load( $sOxId );
            }
        }

        return $blGet;
    }

    public function getDynValues()
    {
        if ( !$this->getStoreCreditCardInfo() && $this->oxuserpayments__oxpaymentsid->value == 'oxidcreditcard' ) {
            return null;
        }

        if ( !$this->_aDynValues ) {

            $sRawDynValue = null;
            if ( is_object($this->oxuserpayments__oxvalue) ) {
                $sRawDynValue = $this->oxuserpayments__oxvalue->getRawValue();
            }

            $this->_aDynValues = oxUtils::getInstance()->assignValuesFromText( $sRawDynValue );
        }
        return $this->_aDynValues;
    }

    public function setDynValues( $aDynValues )
    {
        $this->_aDynValues = $aDynValues;
    }

}