oxrating.php

Go to the documentation of this file.

<?php

class oxRating extends oxBase
{
    protected $_blDisableShopCheck = true;

    protected $_sClassName = 'oxrating';

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

    public function allowRating( $sUserId, $sType, $sObjectId)
    {
        $oDb = oxDb::getDb();
        $myConfig = $this->getConfig();

        if ( $iRatingLogsTimeout = $myConfig->getConfigParam( 'iRatingLogsTimeout' ) ) {
            $sExpDate = date( 'Y-m-d H:i:s', oxRegistry::get("oxUtilsDate")->getTime() - $iRatingLogsTimeout*24*60*60);
            $oDb->execute( "delete from oxratings where oxtimestamp < '$sExpDate'" );
        }
        $sSelect = "select oxid from oxratings where oxuserid = ".$oDb->quote( $sUserId )." and oxtype=".$oDb->quote( $sType )." and oxobjectid = ".$oDb->quote( $sObjectId );
        if ( $oDb->getOne( $sSelect ) ) {
            return false;
        }

        return true;
    }


    public function getRatingAverage( $sObjectId, $sType, $aIncludedObjectsIds = null )
    {
        $oDb = oxDb::getDb();

        $sQuerySnipet = '';
        if ( is_array( $aIncludedObjectsIds ) && count( $aIncludedObjectsIds ) > 0 ) {
            $sQuerySnipet = " AND ( `oxobjectid` = ".$oDb->quote( $sObjectId ) . " OR `oxobjectid` in ('" .implode("', '", $aIncludedObjectsIds). "') )";
        } else {
            $sQuerySnipet = " AND `oxobjectid` = ".$oDb->quote( $sObjectId );
        }

        $sSelect = "
            SELECT
                AVG(`oxrating`)
            FROM `oxreviews`
            WHERE `oxrating` > 0
                 AND `oxtype` = " . $oDb->quote( $sType )
               . $sQuerySnipet . "
            LIMIT 1";

        $fRating = 0;
        if ( $fRating = $oDb->getOne( $sSelect, false, false ) ) {
            $fRating = round( $fRating, 1 );
        }

        return $fRating;
    }

    public function getRatingCount( $sObjectId, $sType, $aIncludedObjectsIds = null )
    {
        $oDb = oxDb::getDb();

        $sQuerySnipet = '';
        if ( is_array( $aIncludedObjectsIds ) && count( $aIncludedObjectsIds ) > 0 ) {
            $sQuerySnipet = " AND ( `oxobjectid` = ".$oDb->quote( $sObjectId ) . " OR `oxobjectid` in ('" .implode("', '", $aIncludedObjectsIds). "') )";
        } else {
            $sQuerySnipet = " AND `oxobjectid` = ".$oDb->quote( $sObjectId );
        }

        $sSelect = "
            SELECT
                COUNT(*)
            FROM `oxreviews`
            WHERE `oxrating` > 0
                AND `oxtype` = " . $oDb->quote( $sType )
               . $sQuerySnipet . "
            LIMIT 1";

        $iCount = 0;
        $iCount = $oDb->getOne( $sSelect, false, false );

        return $iCount;
    }

}