/**
* returns reviews list for article
*
* @param oxArticle $oArticle Article object
*
* @return oxList
*/
protected function _getReviewList($oArticle)
{
$oDb = oxDb::getDb();
$sSelect = "select oxreviews.* from oxreviews\n where oxreviews.OXOBJECTID = " . $oDb->quote($oArticle->oxarticles__oxid->value) . "\n 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".oxLang::getInstance()->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;
}
/**
* returns reviews list for article
*
* @param oxArticle $article Article object
*
* @return oxList
*/
protected function _getReviewList($article)
{
$database = oxDb::getDb();
$query = "select oxreviews.* from oxreviews\n where oxreviews.OXOBJECTID = " . $database->quote($article->oxarticles__oxid->value) . "\n and oxreviews.oxtype = 'oxarticle'";
$variantList = $article->getVariants();
if ($this->getConfig()->getConfigParam('blShowVariantReviews') && count($variantList)) {
// verifying rights
foreach ($variantList as $variant) {
$query .= "or oxreviews.oxobjectid = " . $database->quote($variant->oxarticles__oxid->value) . " ";
}
}
//$sSelect .= "and oxreviews.oxtext".oxRegistry::getLang()->getLanguageTag($this->_iEditLang)." != ''";
$query .= "and oxreviews.oxlang = '" . $this->_iEditLang . "'";
$query .= "and oxreviews.oxtext != '' ";
// all reviews
$reviewList = oxNew("oxlist");
$reviewList->init("oxreview");
$reviewList->selectString($query);
return $reviewList;
}
