oxactionlist.php

Go to the documentation of this file.

<?php

class oxActionList extends oxList
{
    protected $_sObjectsInListName = 'oxactions';

    public function loadFinishedByCount($iCount)
    {
        $sDate = date( 'Y-m-d H:i:s', oxUtilsDate::getInstance()->getTime() );
        $sQ = "select * from oxactions where oxtype=2 and oxactive=1 and oxshopid='".$this->getConfig()->getShopId()."' and oxactiveto>0 and oxactiveto < ".oxDb::getDb()->quote($sDate)."
               ".$this->_getUserGroupFilter()."
               order by oxactiveto desc, oxactivefrom desc limit ".(int)$iCount;
        $this->selectString( $sQ );
        $this->_aArray = array_reverse( $this->_aArray, true );
    }

    public function loadFinishedByTimespan($iTimespan)
    {
        $sDateTo   = date( 'Y-m-d H:i:s', oxUtilsDate::getInstance()->getTime() );
        $sDateFrom = date( 'Y-m-d H:i:s', oxUtilsDate::getInstance()->getTime()-$iTimespan );
        $sQ = "select * from oxactions where oxtype=2 and oxactive=1 and oxshopid='".$this->getConfig()->getShopId()."' and oxactiveto < ".oxDb::getDb()->quote($sDateTo)." and oxactiveto > ".oxDb::getDb()->quote($sDateFrom)."
               ".$this->_getUserGroupFilter()."
               order by oxactiveto, oxactivefrom";
        $this->selectString( $sQ );
    }

    public function loadCurrent()
    {
        $sDate = date( 'Y-m-d H:i:s', oxUtilsDate::getInstance()->getTime() );
        $sQ = "select * from oxactions where oxtype=2 and oxactive=1 and oxshopid='".$this->getConfig()->getShopId()."' and (oxactiveto > ".oxDb::getDb()->quote($sDate)." or oxactiveto=0) and oxactivefrom != 0 and oxactivefrom < ".oxDb::getDb()->quote($sDate)."
               ".$this->_getUserGroupFilter()."
               order by oxactiveto, oxactivefrom";
        $this->selectString( $sQ );
    }

    public function loadFutureByCount($iCount)
    {
        $sDate = date( 'Y-m-d H:i:s', oxUtilsDate::getInstance()->getTime() );
        $sQ = "select * from oxactions where oxtype=2 and oxactive=1 and oxshopid='".$this->getConfig()->getShopId()."' and (oxactiveto > ".oxDb::getDb()->quote($sDate)." or oxactiveto=0) and oxactivefrom > ".oxDb::getDb()->quote($sDate)."
               ".$this->_getUserGroupFilter()."
               order by oxactiveto, oxactivefrom limit ".(int)$iCount;
        $this->selectString( $sQ );
    }

    public function loadFutureByTimespan($iTimespan)
    {
        $sDate = date( 'Y-m-d H:i:s', oxUtilsDate::getInstance()->getTime() );
        $sDateTo = date( 'Y-m-d H:i:s', oxUtilsDate::getInstance()->getTime()+$iTimespan );
        $sQ = "select * from oxactions where oxtype=2 and oxactive=1 and oxshopid='".$this->getConfig()->getShopId()."' and (oxactiveto > ".oxDb::getDb()->quote($sDate)." or oxactiveto=0) and oxactivefrom > ".oxDb::getDb()->quote($sDate)." and oxactivefrom < ".oxDb::getDb()->quote($sDateTo)."
               ".$this->_getUserGroupFilter()."
               order by oxactiveto, oxactivefrom";
        $this->selectString( $sQ );
    }

    protected function _getUserGroupFilter( $oUser = null )
    {
        $oUser = ( $oUser == null ) ? $this->getUser() : $oUser;
        $sTable      = getViewName( 'oxactions' );
        $sGroupTable = getViewName( 'oxgroups' );

        $aIds = array();
        // checking for current session user which gives additional restrictions for user itself, users group and country
        if ( $oUser && count( $aGroupIds = $oUser->getUserGroups() ) ) {
            foreach ( $aGroupIds as $oGroup ) {
                $aIds[] = $oGroup->getId();
            }
        }

        $sGroupSql = count( $aIds ) ?"EXISTS(select oxobject2action.oxid from oxobject2action where oxobject2action.oxactionid=$sTable.OXID and oxobject2action.oxclass='oxgroups' and oxobject2action.OXOBJECTID in (".implode(', ', oxDb::getInstance()->quoteArray($aIds) ).") )":'0';
        $sQ = " and (
            select
                if(EXISTS(select 1 from oxobject2action, $sGroupTable where $sGroupTable.oxid=oxobject2action.oxobjectid and oxobject2action.oxactionid=$sTable.OXID and oxobject2action.oxclass='oxgroups' LIMIT 1),
                    $sGroupSql,
                    1)
            ) ";

        return $sQ;
    }

    public function areAnyActivePromotions()
    {
        return (bool) oxDb::getDb()->getOne("select 1 from ".getViewName( 'oxactions' )." where oxtype=2 and oxactive=1 and oxshopid='".$this->getConfig()->getShopId()."' limit 1");
    }
}