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;
    }

}