oxdiscount.php

Go to the documentation of this file.

<?php

class oxDiscount extends oxI18n
{
    protected $_sClassName = 'oxdiscount';

    protected $_dAmount = null;

    protected $_sBasketIdent = null;

    protected $_blIsForArticleOrForCategory = null;

    protected $_aHasArticleDiscounts = array();

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

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


        $oDb = oxDb::getDb();
        $oDb->execute( 'delete from oxobject2discount where oxobject2discount.oxdiscountid = '.$oDb->quote($sOXID) );

        return parent::delete( $sOXID );
    }

    public function isForArticle( $oArticle )
    {

        // item discounts may only be applied for basket
        if ( $this->oxdiscount__oxaddsumtype->value == 'itm' ) {
            return false;
        }

        if ( $this->oxdiscount__oxamount->value || $this->oxdiscount__oxprice->value ) {
            return false;
        }

        if ( $this->oxdiscount__oxpriceto->value && ($this->oxdiscount__oxpriceto->value < $oArticle->getBasePrice()) ) {
            return false;
        }

        $oDb = oxDb::getDb();

        $sDiscountIdQuoted = $oDb->quote($this->oxdiscount__oxid->value);

        //check for global discount (no articles, no categories)
        if ( $this->_blIsForArticleOrForCategory ) {
            return true;
        } elseif ( $this->_blIsForArticleOrForCategory === null ) {

            $this->_blIsForArticleOrForCategory = false;
            $sQ = "select 1 from oxobject2discount where oxdiscountid = $sDiscountIdQuoted and ( oxtype = 'oxarticles' or oxtype = 'oxcategories')";
            if ( ! $oDb->getOne( $sQ ) ) {
                $this->_blIsForArticleOrForCategory = true;
                return true;
            }
        }

        $sArticleId = $oArticle->getProductId();

        if ( !$this->_blIsForArticleAndForCategory && !isset($this->_aHasArticleDiscounts[ $sArticleId ] ) ) {

            $this->_aHasArticleDiscounts[ $sArticleId ] = false ;

            // check if this article is assigned
            $sQ  = "select 1 from oxobject2discount where oxdiscountid = {$sDiscountIdQuoted} and oxtype = 'oxarticles' ";
            $sQ .= $this->_getProductCheckQuery( $oArticle );

            if ( $oDb->getOne( $sQ ) ) {
                $this->_aHasArticleDiscounts[ $sArticleId ] = true;
                return true;
            } else {
                // check if article is in some assigned category
                $aCatIds = $oArticle->getCategoryIds();
                if (!$aCatIds || !count($aCatIds)) {
                    // no categories are set for article, so no discounts from categories..
                    return false;
                }
                $sCatIds = "(".implode(",", oxDb::getInstance()->quoteArray($aCatIds)).")";
                // getOne appends limit 1, so this one should be fast enough
                $sQ = "select 1 from oxobject2discount where oxdiscountid = {$sDiscountIdQuoted} and oxobjectid in $sCatIds and oxtype = 'oxcategories'";
                if ( $oDb->getOne( $sQ ) ) {
                    $this->_aHasArticleDiscounts[ $sArticleId ] = true;
                    return true;
                }
            }
        }

        return $this->_aHasArticleDiscounts[ $sArticleId ];
    }

    public function isForBasketItem( $oArticle )
    {
        if ( $this->oxdiscount__oxamount->value == 0 && $this->oxdiscount__oxprice->value == 0 ) {
            return false;
        }

        // skipping bundle discounts
        if ( $this->oxdiscount__oxaddsumtype->value == 'itm' ) {
            return false;
        }

        $oDb = oxDb::getDb();

        // check if this article is assigned
        $sQ  = "select 1 from oxobject2discount where oxdiscountid = ".$oDb->quote( $this->oxdiscount__oxid->value)." and oxtype = 'oxarticles' ";
        $sQ .= $this->_getProductCheckQuery( $oArticle );
        if ( !( $blOk = ( bool ) $oDb->getOne( $sQ ) ) ) {

            // checking article category
            $blOk = $this->_checkForArticleCategories( $oArticle );
        }

        return $blOk;
    }

    public function isForBasketAmount( $oBasket )
    {
        $dAmount = 0;
        $aBasketItems = $oBasket->getContents();
        foreach ( $aBasketItems as $oBasketItem ) {

            $oBasketArticle = $oBasketItem->getArticle(false);

            $blForBasketItem = false;
            if ( $this->oxdiscount__oxaddsumtype->value != 'itm' ) {
                $blForBasketItem = $this->isForBasketItem( $oBasketArticle );
            } else {
                $blForBasketItem = $this->isForBundleItem( $oBasketArticle );
            }

            if ( $blForBasketItem ) {
                $dRate = $oBasket->getBasketCurrency()->rate;
                if ( $this->oxdiscount__oxprice->value ) {
                    if ( ( $oPrice = $oBasketArticle->getPrice() ) ) {
                        $dAmount += ($oPrice->getPrice() * $oBasketItem->getAmount())/$dRate;
                    }
                } elseif ( $this->oxdiscount__oxamount->value ) {
                    $dAmount += $oBasketItem->getAmount();
                }
            }
        }

        return $this->isForAmount( $dAmount );
    }

    public function isForAmount( $dAmount )
    {
        $blIs = true;

        if ( $this->oxdiscount__oxprice->value &&
            ( $dAmount < $this->oxdiscount__oxprice->value || $dAmount > $this->oxdiscount__oxpriceto->value ) ) {
            $blIs = false;
        } elseif ( $this->oxdiscount__oxamount->value &&
            ( $dAmount < $this->oxdiscount__oxamount->value || $dAmount > $this->oxdiscount__oxamountto->value ) ) {
            $blIs = false;
        }

        return $blIs;
    }

    public function isForBasket( $oBasket )
    {
        // initial configuration check
        if ( $this->oxdiscount__oxamount->value == 0 && $this->oxdiscount__oxprice->value == 0 ) {
            return false;
        }

        $oSummary = $oBasket->getBasketSummary();
        // amounts check
        if ( $this->oxdiscount__oxamount->value && ( $oSummary->iArticleCount < $this->oxdiscount__oxamount->value || $oSummary->iArticleCount > $this->oxdiscount__oxamountto->value ) ) {
            return false;
            // price check
        } elseif ($this->oxdiscount__oxprice->value) {
            $dRate = $oBasket->getBasketCurrency()->rate;
            if ( $oSummary->dArticleDiscountablePrice < $this->oxdiscount__oxprice->value*$dRate || $oSummary->dArticleDiscountablePrice > $this->oxdiscount__oxpriceto->value*$dRate ) {
                return false;
            }
        }

        // oxobject2discount configuration check
        $oDb = oxDb::getDb();
        $sQ = 'select 1 from oxobject2discount where oxdiscountid = ' . $oDb->quote($this->oxdiscount__oxid->value).' and oxtype in ("oxarticles", "oxcategories" ) ';

        return !( (bool) $oDb->getOne( $sQ ) );
    }

    public function isForBundleItem( $oArticle )
    {
        if ( $this->oxdiscount__oxaddsumtype->value != 'itm' ) {
            return false;
        }

        $oDb = oxDb::getDb();
        $sQ  = "select 1 from oxobject2discount where oxdiscountid=".$oDb->quote( $this->getId() );
        $sQ .= $this->_getProductCheckQuery( $oArticle );
        if ( !( $blOk = (bool) $oDb->getOne( $sQ ) ) ) {
            // additional checks for amounts and other dependencies
            $blOk = $this->_checkForArticleCategories( $oArticle );
        }
        return $blOk;
    }

    public function isForBundleBasket( $oBasket )
    {
        if ( $this->oxdiscount__oxaddsumtype->value != 'itm' ) {
            return false;
        }

        return $this->isForBasket( $oBasket );
    }

    public function getAbsValue( $dPrice, $dAmount = 1 )
    {
        if ( $this->oxdiscount__oxaddsumtype->value == '%' ) {
            return $dPrice * ( $this->oxdiscount__oxaddsum->value / 100 );
        } else {
            $oCur = $this->getConfig()->getActShopCurrencyObject();
            return $this->oxdiscount__oxaddsum->value * $dAmount * $oCur->rate;
        }
    }

    public function applyDiscount( $oPrice, $dAmount = 1 )
    {
        if ( $this->oxdiscount__oxaddsumtype->value == 'abs' ) {
            $oCur = $this->getConfig()->getActShopCurrencyObject();
            $oPrice->subtract( $this->oxdiscount__oxaddsum->value * $oCur->rate );
        } else {
            $oPrice->multiply( (100 - $this->oxdiscount__oxaddsum->value) / 100 );
        }

        if ( $oPrice->getBruttoPrice() < 0 || $oPrice->getNettoPrice() < 0 ) {
            $oPrice->setPrice(0);
        }
    }

    public function getPercentage( $dPrice )
    {
        if ( $this->getAddSumType() == 'abs' && $dPrice > 0 ) {
            return $this->getAddSum() / $dPrice * 100;
        } else {
            return $this->getAddSum();
        }
    }



    public function getAddSum()
    {
        if ( $this->oxdiscount__oxaddsumtype->value == 'abs' ) {
            $oCur = $this->getConfig()->getActShopCurrencyObject();
            return $this->oxdiscount__oxaddsum->value * $oCur->rate;
        } else {
            return $this->oxdiscount__oxaddsum->value;
        }
    }

    public function getAddSumType()
    {
        return $this->oxdiscount__oxaddsumtype->value;
    }




    public function getBundleAmount( $dAmount )
    {
        $dItemAmount = $this->oxdiscount__oxitmamount->value;

        // Multiplying bundled articles count, if allowed
        if ( $this->oxdiscount__oxitmmultiple->value && $this->oxdiscount__oxamount->value > 0 ) {
            $dItemAmount = floor( $dAmount / $this->oxdiscount__oxamount->value ) * $this->oxdiscount__oxitmamount->value;
        }

        return $dItemAmount;
    }

    protected function _checkForArticleCategories( $oArticle )
    {
        // check if article is in some assigned category
        $aCatIds = $oArticle->getCategoryIds();
        if (!$aCatIds || !count($aCatIds)) {
            // no categories are set for article, so no discounts from categories..
            return false;
        }

        $sCatIds = "(".implode(",", oxDb::getInstance()->quoteArray($aCatIds)).")";

        $oDb = oxDb::getDb();
        // getOne appends limit 1, so this one should be fast enough
        $sQ = "select oxobjectid from oxobject2discount where oxdiscountid = ".$oDb->quote($this->oxdiscount__oxid->value)." and oxobjectid in $sCatIds and oxtype = 'oxcategories'";

        return $oDb->getOne( $sQ );
    }

    public function getSimpleDiscount()
    {
        $oDiscount = new stdClass();
        $oDiscount->sOXID     = $this->getId();
        $oDiscount->sDiscount = $this->oxdiscount__oxtitle->value;
        $oDiscount->sType     = $this->oxdiscount__oxaddsumtype->value;

        return $oDiscount;
    }

    public function getArticleIds()
    {
        return oxDb::getDb()->getCol("select `oxobjectid` from oxobject2discount where oxdiscountid = '".$this->getId()."' and oxtype = 'oxarticles'");
    }

    public function getCategoryIds()
    {
        return oxDb::getDb()->getCol("select `oxobjectid` from oxobject2discount where oxdiscountid = '".$this->getId()."' and oxtype = 'oxcategories'");
    }

    protected function _getProductCheckQuery( $oProduct )
    {
        $oDb = oxDb::getDb();
        // check if this article is assigned
        if ( ( $sParentId = $oProduct->getProductParentId() ) ) {
            $sArticleId = " and ( oxobjectid = ".$oDb->quote( $oProduct->getProductId() )." or oxobjectid = ".$oDb->quote( $sParentId ) . " )";
        } else {
            $sArticleId = " and oxobjectid = ".$oDb->quote( $oProduct->getProductId() );
        }

        return $sArticleId;
    }


}