article_review.php

Go to the documentation of this file.

<?php

class Article_Review extends oxAdminDetails
{
    public function render()
    {
        $myConfig = $this->getConfig();

        parent::render();

        $this->_aViewData["edit"] = $oArticle = oxNew( "oxarticle" );

        $soxId    = $this->getEditObjectId();
        $sRevoxId = oxConfig::getParameter( 'rev_oxid' );
        if ( $soxId != "-1" && isset( $soxId)) {

            // load object
            $oArticle->load( $soxId);


            $oRevs = $this->_getReviewList($oArticle);

            foreach ( $oRevs as $oRev ) {
                if ( $oRev->oxreviews__oxid->value == $sRevoxId ) {
                    $oRev->selected = 1;
                    break;
                }
            }
            $this->_aViewData["allreviews"]   = $oRevs;
            $this->_aViewData["editlanguage"] = $this->_iEditLang;

            if ( isset( $sRevoxId ) ) {
                $oReview = oxNew( "oxreview" );
                $oReview->load( $sRevoxId );
                $this->_aViewData["editreview"] = $oReview;

                $oUser = oxNew( "oxuser" );
                $oUser->load( $oReview->oxreviews__oxuserid->value);
                $this->_aViewData["user"] = $oUser;
            }
            //show "active" checkbox if moderating is active
            $this->_aViewData["blShowActBox"] = $myConfig->getConfigParam( 'blGBModerate' );

        }

        return "article_review.tpl";
    }

    protected function _getReviewList($oArticle)
    {
        $oDb = oxDb::getDb();
        $sSelect  = "select oxreviews.* from oxreviews
                     where oxreviews.OXOBJECTID = ".$oDb->quote( $oArticle->oxarticles__oxid->value ) ."
                     and oxreviews.oxtype = 'oxarticle'";

        $aVariantList = $oArticle->getVariants();

        if ( $this->getConfig()->getConfigParam( 'blShowVariantReviews' ) && count( $aVariantList )) {

            // verifying rights
            foreach ( $aVariantList as $oVariant ) {
                $sSelect .= "or oxreviews.oxobjectid = ".$oDb->quote( $oVariant->oxarticles__oxid->value )." ";
            }

        }

        //$sSelect .= "and oxreviews.oxtext".oxRegistry::getLang()->getLanguageTag($this->_iEditLang)." != ''";
        $sSelect .= "and oxreviews.oxlang = '" . $this->_iEditLang . "'";
        $sSelect .= "and oxreviews.oxtext != '' ";

        // all reviews
        $oRevs = oxNew( "oxlist" );
        $oRevs->init( "oxreview" );
        $oRevs->selectString( $sSelect );

        return $oRevs;
    }

    public function save()
    {
        parent::save();

        $aParams = oxConfig::getParameter( "editval");
        // checkbox handling
        if ( $this->getConfig()->getConfigParam( 'blGBModerate' ) && !isset( $aParams['oxreviews__oxactive'] ) ) {
            $aParams['oxreviews__oxactive'] = 0;
        }

        $oReview = oxNew( "oxreview" );
        $oReview->load( oxConfig::getParameter( "rev_oxid" ) );
        $oReview->assign( $aParams );
        $oReview->save();
    }

    public function delete()
    {

        $sRevoxId = oxConfig::getParameter( "rev_oxid" );
        $oReview  = oxNew( "oxreview" );
        $oReview->load( $sRevoxId );
        $oReview->delete();

        // recalculating article average rating
        $oRating = oxNew( "oxRating" );
        $sArticleId = $this->getEditObjectId();

        $oArticle = oxNew( 'oxArticle' );
        $oArticle->load( $sArticleId );

        $oArticle->setRatingAverage( $oRating->getRatingAverage( $sArticleId, 'oxarticle' ) );
        $oArticle->setRatingCount( $oRating->getRatingCount( $sArticleId, 'oxarticle' ) );
        $oArticle->save();

    }
}