function execute() { global $currencies, $oscTemplate; $OSCOM_Db = Registry::get('Db'); $OSCOM_Language = Registry::get('Language'); $reviews_box_contents = ''; $sql_query = 'select r.reviews_id from :table_reviews r, :table_reviews_description rd, :table_products p, :table_products_description pd where r.reviews_status = 1 and r.products_id = p.products_id and p.products_status = 1 and r.reviews_id = rd.reviews_id and rd.languages_id = :languages_id and p.products_id = pd.products_id and pd.language_id = rd.languages_id'; if (isset($_GET['products_id'])) { $sql_query .= ' and p.products_id = :products_id'; } $sql_query .= ' order by r.reviews_id desc limit ' . (int) MAX_RANDOM_SELECT_REVIEWS; $Qcheck = $OSCOM_Db->prepare($sql_query); $Qcheck->bindInt(':languages_id', $OSCOM_Language->getId()); if (isset($_GET['products_id'])) { $Qcheck->bindInt(':products_id', $_GET['products_id']); } $Qcheck->execute(); $result = $Qcheck->fetchAll(); if (count($result) > 0) { $result = $result[mt_rand(0, count($result) - 1)]; $Qreview = $OSCOM_Db->prepare('select r.reviews_id, r.reviews_rating, substring(rd.reviews_text, 1, 60) as reviews_text, p.products_id, p.products_image, pd.products_name from :table_reviews r, :table_reviews_description rd, :table_products p, :table_products_description pd where r.reviews_id = :reviews_id and r.reviews_id = rd.reviews_id and rd.languages_id = :languages_id and r.products_id = p.products_id and p.products_id = pd.products_id and pd.language_id = rd.languages_id'); $Qreview->bindInt(':reviews_id', $result['reviews_id']); $Qreview->bindInt(':languages_id', $OSCOM_Language->getId()); $Qreview->execute(); if ($Qreview->fetch() !== false) { // display random review box $rand_review_text = tep_break_string($Qreview->valueProtected('reviews_text'), 15, '-<br />'); $reviews_box_contents = '<div class="text-center"><a href="' . OSCOM::link('product_reviews.php', 'products_id=' . $Qreview->valueInt('products_id')) . '">' . HTML::image(OSCOM::linkImage($Qreview->value('products_image')), $Qreview->value('products_name'), SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '</a></div><div><a href="' . OSCOM::link('product_reviews.php', 'products_id=' . $Qreview->valueInt('products_id')) . '">' . $rand_review_text . '</a>...</div><div class="text-center" title="' . OSCOM::getDef('module_boxes_reviews_box_text_of_5_stars', ['reviews_rating' => $Qreview->valueInt('reviews_rating')]) . '">' . HTML::stars($Qreview->valueInt('reviews_rating')) . '</div>'; } } elseif (isset($_GET['products_id'])) { // display 'write a review' box $reviews_box_contents = '<span class="fa fa-thumbs-up"></span> <a href="' . OSCOM::link('product_reviews_write.php', 'products_id=' . (int) $_GET['products_id']) . '">' . OSCOM::getDef('module_boxes_reviews_box_write_review') . '</a>'; } else { // display 'no reviews' box $reviews_box_contents = '<p>' . OSCOM::getDef('module_boxes_reviews_box_no_reviews') . '</p>'; } ob_start(); include 'includes/modules/boxes/templates/reviews.php'; $data = ob_get_clean(); $oscTemplate->addBlock($data, $this->group); }
function execute() { global $oscTemplate, $_GET; $OSCOM_Db = Registry::get('Db'); $Qreviews = $OSCOM_Db->prepare('select substring_index(rd.reviews_text, " ", 20) as reviews_text, r.reviews_rating, r.reviews_id, r.customers_name, r.date_added, r.reviews_read, p.products_id, p.products_price, p.products_tax_class_id, p.products_image, p.products_model, pd.products_name from :table_reviews r, :table_reviews_description rd, :table_products p, :table_products_description pd where r.products_id = :products_id and r.reviews_status = 1 and r.reviews_id = rd.reviews_id and rd.languages_id = :languages_id and r.products_id = p.products_id and p.products_status = 1 and p.products_id = pd.products_id and pd.language_id = rd.languages_id order by r.reviews_rating desc limit :limit'); $Qreviews->bindInt(':products_id', $_GET['products_id']); $Qreviews->bindInt(':languages_id', $_SESSION['languages_id']); $Qreviews->bindInt(':limit', MODULE_CONTENT_PRODUCT_INFO_REVIEWS_CONTENT_LIMIT); $Qreviews->execute(); if ($Qreviews->fetch() !== false) { $content_width = (int) MODULE_CONTENT_PRODUCT_INFO_REVIEWS_CONTENT_WIDTH; $review_data = ''; do { $review_data .= '<blockquote class="col-sm-6">' . ' <p>' . $Qreviews->valueProtected('reviews_text') . ' ... </p>' . ' <footer>' . sprintf(MODULE_CONTENT_PRODUCT_INFO_REVIEWS_TEXT_RATED, HTML::stars($Qreviews->valueInt('reviews_rating')), $Qreviews->valueProtected('customers_name'), $Qreviews->valueProtected('customers_name')) . '</footer>' . '</blockquote>'; } while ($Qreviews->fetch()); ob_start(); include DIR_WS_MODULES . 'content/' . $this->group . '/templates/reviews.php'; $template = ob_get_clean(); $oscTemplate->addContent($template, $this->group); } }
<?php echo HTML::radioField('rating', '3') . HTML::stars(3, false); ?> </label> </div> <div class="radio"> <label> <?php echo HTML::radioField('rating', '2') . HTML::stars(2, false); ?> </label> </div> <div class="radio"> <label> <?php echo HTML::radioField('rating', '1', null, 'required aria-required="true"') . HTML::stars(1, false) . ' ' . TEXT_BAD; ?> </label> </div> </div> </div> </div> <div class="clearfix"></div> <div class="row"> <div class="col-xs-6 text-right pull-right"><?php echo HTML::button(IMAGE_BUTTON_CONTINUE, 'glyphicon glyphicon-chevron-right', null, 'primary', null, 'btn-success'); ?>
</span> </div> </div> <?php } ?> <div class="contentText"> <div class="reviews"> <?php while ($Qreviews->fetch()) { echo '<blockquote class="col-sm-6">'; echo ' <p><span class="pull-left">' . HTML::image(OSCOM::linkImage($Qreviews->value('products_image')), $Qreviews->value('products_name'), SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '</span>' . $Qreviews->valueProtected('reviews_text') . ' ... </p><div class="clearfix"></div>'; $review_name = $Qreviews->valueProtected('customers_name'); echo '<footer>'; $review_name = $Qreviews->valueProtected('customers_name'); echo OSCOM::getDef('reviews_text_rated', ['reviews_rating' => HTML::stars($Qreviews->value('reviews_rating')), 'review_name' => $review_name]); echo '<a href="' . OSCOM::link('product_reviews.php', 'products_id=' . $Qreviews->valueInt('products_id')) . '">'; echo '<span class="pull-right label label-info">' . OSCOM::getDef('reviews_text_read_more') . '</span>'; echo '</a>'; echo '</footer>'; echo '</blockquote>'; } ?> </div> <div class="clearfix"></div> </div> <?php } else { ?> <div class="alert alert-info">
echo '<a href="' . OSCOM::link('product_reviews.php', 'products_id=' . $Qreviews->valueInt('products_id') . '&reviews_id=' . $Qreviews->valueInt('reviews_id')) . '">' . $Qreviews->value('products_name') . '</a>'; ?> </h4> <blockquote> <p><span class="pull-left"><?php echo HTML::image(DIR_WS_IMAGES . $Qreviews->value('products_image'), $Qreviews->value('products_name'), SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT); ?> </span><?php echo $Qreviews->valueProtected('reviews_text') . ' ... '; ?> </p> <div class="clearfix"></div> <footer> <?php $review_name = $Qreviews->valueProtected('customers_name'); echo sprintf(REVIEWS_TEXT_RATED, HTML::stars($Qreviews->value('reviews_rating')), $review_name, $review_name) . '<a href="' . OSCOM::link('product_reviews.php', 'products_id=' . $Qreviews->valueInt('products_id')) . '"><span class="pull-right label label-info">' . REVIEWS_TEXT_READ_MORE . '</span></a>'; ?> </footer> </blockquote> </div> <?php } ?> </div> <?php if (PREV_NEXT_BAR_LOCATION == '2' || PREV_NEXT_BAR_LOCATION == '3') { ?> <div class="clearfix"></div>
?> </p> <meta itemprop="datePublished" content="<?php echo $Qreviews->value('date_added'); ?> "> <span itemprop="reviewRating" itemscope itemtype="http://schema.org/Rating"> <meta itemprop="ratingValue" content="<?php echo $Qreviews->value('reviews_rating'); ?> "> </span> <footer> <?php $review_name = $Qreviews->valueProtected('customers_name'); echo sprintf(REVIEWS_TEXT_RATED, HTML::stars($Qreviews->value('reviews_rating')), $review_name, $review_name); ?> </footer> </blockquote> <?php } ?> </div> <?php if (PREV_NEXT_BAR_LOCATION == '2' || PREV_NEXT_BAR_LOCATION == '3') { ?> <div class="clearfix"></div>