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();
        parent::delete( $sOxId );
    }

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

        return $this->_oGroups;
    }

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

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

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

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

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

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

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

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

        return $aStatus;
    }
}