oxgbentry.php

Go to the documentation of this file.

<?php

class oxGbEntry extends oxBase
{
    //to skip oxcreate we must change this field to 'CURRENT_TIMESTAMP'
    //protected $_aSkipSaveFields = array( 'oxcreate' );

    protected $_sClassName = 'oxgbentry';

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

    public function assign( $dbRecord )
    {

        $blRet = parent::assign( $dbRecord );

        if ( isset( $this->oxgbentries__oxuserid ) && $this->oxgbentries__oxuserid->value ) {
            $oDb = oxDb::getDb();
            $this->oxuser__oxfname = new oxField( $oDb->getOne( "select oxfname from oxuser where oxid=".$oDb->quote( $this->oxgbentries__oxuserid->value ) ));
        }

        return $blRet;
    }

    protected function _insert()
    {
        // set oxcreate
        $this->oxgbentries__oxcreate = new oxField( date( 'Y-m-d H:i:s', oxRegistry::get("oxUtilsDate")->getTime() ));
        return parent::_insert();
    }

    public function getAllEntries( $iStart, $iNrofCatArticles, $sSortBy)
    {
        $myConfig = $this->getConfig();

        // loading entries
        $sSelect  = 'select oxgbentries.*, oxuser.oxfname,
                    `oxuser`.`oxusername` AS `author`, `oxgbentries`.`oxcreate` AS `date`
            from oxgbentries left join oxuser on oxgbentries.oxuserid = oxuser.oxid ';
        $sSelect .= 'where oxuser.oxid is not null and oxgbentries.oxshopid = "'.$myConfig->getShopId().'" ';

        // setting GB entry view restirction rules
        if ( $myConfig->getConfigParam( 'blGBModerate') ) {
            $oUser = $this->getUser();
            $sSelect .= " and ( oxgbentries.oxactive = '1' ";
            $sSelect .= $oUser?" or oxgbentries.oxuserid = " . oxDb::getDb()->quote( $oUser->getId() ) : '';
            $sSelect .= " ) ";
        }

        // setting sort
        if ( $sSortBy ) {
            $sSelect .= "order by $sSortBy ";
        }


        $oEntries = oxNew( 'oxlist' );
        $oEntries->init( 'oxgbentry' );

        $oEntries->setSqlLimit( $iStart, $iNrofCatArticles );
        $oEntries->selectString( $sSelect );

        return $oEntries;
    }

    public function getEntryCount()
    {
        $myConfig = $this->getConfig();
        $oDb = oxDb::getDb();

        // loading entries
        $sSelect  = 'select count(*) from oxgbentries left join oxuser on oxgbentries.oxuserid = oxuser.oxid ';
        $sSelect .= 'where oxuser.oxid is not null and oxgbentries.oxshopid = "'.$myConfig->getShopId().'" ';

        // setting GB entry view restirction rules
        if ( $myConfig->getConfigParam( 'blGBModerate') ) {
            $oUser = $this->getUser();
            $sSelect .= " and ( oxgbentries.oxactive = '1' ";
            $sSelect .= $oUser?" or oxgbentries.oxuserid = ".$oDb->quote( $oUser->getId() ):'';
            $sSelect .= " ) ";
        }

        // loading only if there is some data
        $iRecCnt = (int) $oDb->getOne( $sSelect );
        return $iRecCnt;
    }

    public function floodProtection( $sShopid = 0, $sUserId = null )
    {
        $result = true;
        if ( $sUserId && $sShopid) {
            $oDb = oxDb::getDb();
            $sToday = date( 'Y-m-d' );
            $sSelect  = "select count(*) from oxgbentries ";
            $sSelect .= "where oxgbentries.oxuserid = " . $oDb->quote( $sUserId ) . " and oxgbentries.oxshopid = " . $oDb->quote( $sShopid ) . " ";
            $sSelect .= "and oxgbentries.oxcreate >= '$sToday 00:00:00' and oxgbentries.oxcreate <= '$sToday 23:59:59' ";
            $iCnt = $oDb->getOne( $sSelect );

            $myConfig = $this->getConfig();
            if ( ( !$myConfig->getConfigParam( 'iMaxGBEntriesPerDay' ) ) || ( $iCnt < $myConfig->getConfigParam( 'iMaxGBEntriesPerDay' ) ) ) {
                $result = false;
            }
        }
        return $result;
    }

}