oxreview.php

Go to the documentation of this file.

<?php

class oxReview extends oxBase
{
    protected $_blDisableShopCheck = true;

    protected $_sClassName = 'oxreview';

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

    public function assign( $dbRecord )
    {
        $blRet = parent::assign( $dbRecord );

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

        return $blRet;
    }

    public function load( $oxId )
    {
        if ( $blRet = parent::load( $oxId ) ) {
            // convert date's to international format
            $this->oxreviews__oxcreate->setValue(oxUtilsDate::getInstance()->formatDBDate( $this->oxreviews__oxcreate->value ));
        }

        return $blRet;
    }

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


    public function loadList($sType, $aIds, $blLoadEmpty = false, $iLoadInLang = null)
    {
        $oDb = oxDb::getDb();

        $oRevs = oxNew( 'oxlist' );
        $oRevs->init( 'oxreview' );

        $sObjectIdWhere = '';
        if ( is_array( $aIds ) && count( $aIds ) ) {
            $sObjectIdWhere = "oxreviews.oxobjectid in ( ".implode(", ", oxDb::getInstance()->quoteArray( $aIds ))." )";
        } elseif ( is_string( $aIds ) && $aIds ) {
            $sObjectIdWhere = "oxreviews.oxobjectid = ".$oDb->quote( $aIds );
        } else {
            return $oRevs;
        }

        $iLoadInLang = is_null( $iLoadInLang ) ? (int) oxLang::getInstance()->getBaseLanguage() : (int) $iLoadInLang;

        $sSelect = "select oxreviews.* from oxreviews where oxreviews.oxtype = ".$oDb->quote( $sType )." and $sObjectIdWhere and oxreviews.oxlang = '$iLoadInLang'";

        if ( !$blLoadEmpty ) {
            $sSelect .= ' and oxreviews.oxtext != "" ';
        }

        if ( $this->getConfig()->getConfigParam( 'blGBModerate' ) ) {
            $sSelect .= ' and ( oxreviews.oxactive = "1" ';
            $sSelect .= ( $oUser = $this->getUser() ) ? 'or  oxreviews.oxuserid = ' . $oDb->quote( $oUser->getId() ) . ' )' :  ')';
        }

        $sSelect .= ' order by oxreviews.oxcreate desc ';

        $oRevs->selectString( $sSelect );

        // change date
        foreach ( $oRevs as $oItem ) {
            $oItem->oxreviews__oxcreate->convertToFormattedDbDate();
            $oItem->oxreviews__oxtext->convertToPseudoHtml();
        }

        return $oRevs;
    }
}