oxvoucherserie.php

Go to the documentation of this file.

<?php

class oxVoucherSerie extends oxBase
{

    protected $_oGroups = null;

    protected $_sCoreTbl = 'oxvoucherseries';

    protected $_sClassName = 'oxvoucherserie';

    public function __construct()
    {
        parent::__construct();
        $this->init( $this->_sCoreTbl);
    }

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


        $this->unsetDiscountRelations();
        $this->unsetUserGroups();
        $this->deleteVoucherList();
        return parent::delete( $sOxId );
    }

    public function setUserGroups()
    {
        if ( $this->_oGroups === null ) {
            $this->_oGroups = oxNew( 'oxlist' );
            $this->_oGroups->init( 'oxgroups' );
            $sViewName = getViewName( "oxgroups" );
            $sSelect  = "select gr.* from {$sViewName} as gr, oxobject2group as o2g where
                         o2g.oxobjectid = ". oxDb::getDb()->quote( $this->getId() ) ." and gr.oxid = o2g.oxgroupsid ";
            $this->_oGroups->selectString( $sSelect );
        }

        return $this->_oGroups;
    }

    public function unsetUserGroups()
    {
        $oDB = oxDb::getDb();
        $sDelete = 'delete from oxobject2group where oxobjectid = ' . $oDB->quote( $this->getId() );
        $oDB->execute( $sDelete );
    }

    public function unsetDiscountRelations()
    {
        $oDB = oxDb::getDb();
        $sDelete = 'delete from oxobject2discount where oxobject2discount.oxdiscountid = ' . $oDB->quote( $this->getId() );
        $oDB->execute( $sDelete );
    }

    public function getVoucherList()
    {
        $oVoucherList = oxNew( 'oxvoucherlist' );
        $sSelect = 'select * from oxvouchers where oxvoucherserieid = ' . oxDb::getDb()->quote( $this->getId() );
        $oVoucherList->selectString( $sSelect );
        return $oVoucherList;
    }

    public function deleteVoucherList()
    {
        $oDB = oxDb::getDb();
        $sDelete = 'delete from oxvouchers where oxvoucherserieid = ' . $oDB->quote( $this->getId() );
        $oDB->execute( $sDelete );
    }

    public function countVouchers()
    {
        $aStatus = array();

        $oDB = oxDb::getDb();
        $sQuery = 'select count(*) as total from oxvouchers where oxvoucherserieid = ' .$oDB->quote( $this->getId() );
        $aStatus['total'] = $oDB->getOne( $sQuery );

        $sQuery = 'select count(*) as used from oxvouchers where oxvoucherserieid = ' . $oDB->quote( $this->getId() ) . ' and oxorderid is not NULL and oxorderid != ""';
        $aStatus['used'] = $oDB->getOne( $sQuery );

        $aStatus['available'] = $aStatus['total'] - $aStatus['used'];

        return $aStatus;
    }
}