<?php
/*
  $Id$

  osCommerce, Open Source E-Commerce Solutions
  http://www.oscommerce.com

  Copyright (c) 2010 osCommerce

  Released under the GNU General Public License
*/

  require('includes/application_top.php');

  if (!isset($HTTP_GET_VARS['products_id'])) {
    tep_redirect(tep_href_link(FILENAME_REVIEWS));
  }

  $product_info_query = tep_db_query("select p.products_id, p.products_model, p.products_image, p.products_price, p.products_tax_class_id, pd.products_name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "'");
  if (!tep_db_num_rows($product_info_query)) {
    tep_redirect(tep_href_link(FILENAME_REVIEWS));
  } else {
    $product_info = tep_db_fetch_array($product_info_query);
  }

  if ($new_price = tep_get_products_special_price($product_info['products_id'])) {
    $products_price = '<del>' . $currencies->display_price($product_info['products_price'], tep_get_tax_rate($product_info['products_tax_class_id'])) . '</del> <span class="productSpecialPrice">' . $currencies->display_price($new_price, tep_get_tax_rate($product_info['products_tax_class_id'])) . '</span>';
		$sale	= '<div class="sale"></div>';
  } else {
    $products_price = '<span class="productSpecialPrice">' . $currencies->display_price($product_info['products_price'], tep_get_tax_rate($product_info['products_tax_class_id'])) . '</span>';
		$sale	= '';
  }

  if (tep_not_null($product_info['products_model'])) {
    $products_name = $product_info['products_name'] . ' <mark class="products_model">[' . $product_info['products_model'] . ']</mark>';
  } else {
    $products_name = $product_info['products_name'];
  }
		$image_width = REVIEWS_PAGE_IMAGE_WIDTH;
		$image_height = REVIEWS_PAGE_IMAGE_HEIGHT;
  	if (tep_not_null($product_info['products_image'])) {
		$p_pic =  ((REVIEWS_PAGE_SHOW_THUMBS == 'Show') ? '<div class="product_pic_wrapper" style="width:'.$image_width.'px;height:'.$image_height.'px;"><a class="product_img" href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $product_info['products_id']) . '" style="width:'.$image_width.'px;height:'.$image_height.'px;">' .tep_image(DIR_WS_IMAGES . $product_info['products_image'], addslashes($product_info['products_name']), $image_width, $image_height, ' style="width:'.$image_width.'px;height:'.$image_height.'px;"') . '</a>'.$sale.'</div>' : '');
		}
  require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_PRODUCT_REVIEWS);
  $current_page = FILENAME_REVIEWS;
  $breadcrumb->add(NAVBAR_TITLE, tep_href_link(FILENAME_PRODUCT_REVIEWS, tep_get_all_get_params()));

  require(DIR_WS_INCLUDES . 'template_top.php');
?>



<?php echo tep_draw_content_top();?>

<?php echo tep_draw_heading_top();?>
  <h2 class="fl_left"><?php echo $products_name; ?></h2>
  <h2 class="fl_right" style="padding-top:10px;"><?php echo $products_price; ?></h2>
<?php echo tep_draw_heading_bottom();?>
<?php
  if ($messageStack->size('product_reviews') > 0) { 
    echo $messageStack->output('product_reviews');
  }
	
?>
<div class="contentContainer page_reviews">
  <div class="contentBlock">
      <ol id="product_info">
          			<li class="col_10"><?php echo $p_pic;?>
                <?php if (($oscTemplate->hasBlocks('box_info_page')))	{ $width_ext = PROD_INFO_IMAGE_WIDTH;?><div class="bookmarks" style="width:<?php echo PROD_INFO_IMAGE_WIDTH;?>px;"><?php echo $oscTemplate->getBlocks('box_info_page');?></div><?php	} ?>
                            
                                <br class="cl_both" />
                                <div class="buttonSet"><?php echo tep_draw_button1_top();?><?php echo tep_draw_button(IMAGE_BUTTON_IN_CART, 'cart', tep_href_link(basename($PHP_SELF), tep_get_all_get_params(array('action')) . 'action=buy_now')); ?><?php echo tep_draw_button1_bottom();?></div>
       
          			</li>  
<?php
  $reviews_query_raw = "select r.reviews_id, left(rd.reviews_text, ".MAX_REVIEWS_PAGE_DESCR_ROW.") as reviews_text, r.reviews_rating, r.date_added, r.customers_name from " . TABLE_REVIEWS . " r, " . TABLE_REVIEWS_DESCRIPTION . " rd where r.products_id = '" . (int)$product_info['products_id'] . "' and r.reviews_id = rd.reviews_id and rd.languages_id = '" . (int)$languages_id . "' and r.reviews_status = 1 order by r.reviews_id desc";
  $reviews_split = new splitPageResults($reviews_query_raw, MAX_DISPLAY_NEW_REVIEWS);
?>


<?php              
  if ($reviews_split->number_of_rows > 0) {
?>
          			<li class="col_11">
                    <div class="info">
							<?php	  
								if ((PREV_NEXT_BAR_LOCATION == '1') || (PREV_NEXT_BAR_LOCATION == '3')) {
							?>

<?php echo tep_draw_result1_top(); ?> 
					<div class="result_left"><?php echo $reviews_split->display_count(TEXT_DISPLAY_NUMBER_OF_REVIEWS); ?></div>
					<div class="result_right"><?php echo TEXT_RESULT_PAGE . ' ' . $reviews_split->display_links(MAX_DISPLAY_PAGE_LINKS, tep_get_all_get_params(array('page', 'info'))); ?></div>
<?php echo tep_draw_result1_bottom(); ?> 
<?php
	}
?>
                            
                            
                            
							<?php
                                $reviews_query = tep_db_query($reviews_split->sql_query);
                                while ($reviews = tep_db_fetch_array($reviews_query)) {
                            ?>
                            <div class="prods_info"><div>
                              <div class="data"><?php echo sprintf(TEXT_REVIEW_DATE_ADDED, tep_date_long($reviews['date_added'])); ?>
                                <?php echo '<a href="' . tep_href_link(FILENAME_PRODUCT_REVIEWS_INFO, 'products_id=' . $product_info['products_id'] . '&reviews_id=' . $reviews['reviews_id']) . '">' . sprintf(TEXT_REVIEW_BY, tep_output_string_protected($reviews['customers_name'])) . '</a>'; ?>
                              </div>
                            
                              <div class="desc">
                                <?php echo tep_break_string(tep_output_string_protected($reviews['reviews_text']), 60, '-<br />') . ((strlen($reviews['reviews_text']) >= 100) ? '..' : '');?></div>
								
								<?php echo '<div class="stars">' . sprintf(TEXT_REVIEW_RATING, tep_image(DIR_WS_IMAGES . 'icons/stars_' . $reviews['reviews_rating'] . '.png', sprintf(TEXT_OF_5_STARS, $reviews['reviews_rating'])).'<span>', sprintf(TEXT_OF_5_STARS, $reviews['reviews_rating'])) . '</span></div>'; ?>
                              </div>
                            </div>
                            <?php
                                }
                            ?>
                           
							<?php
                              if (($reviews_split->number_of_rows > 0) && ((PREV_NEXT_BAR_LOCATION == '2') || (PREV_NEXT_BAR_LOCATION == '3'))) {
                            ?>
                            <?php echo tep_draw_result2_top(); ?>        
                                        <div class="result_left"><?php echo $reviews_split->display_count(TEXT_DISPLAY_NUMBER_OF_REVIEWS); ?></div>
                                        <div class="result_right"><?php echo TEXT_RESULT_PAGE . ' ' . $reviews_split->display_links(MAX_DISPLAY_PAGE_LINKS, tep_get_all_get_params(array('page', 'info'))); ?></div>
                            <?php echo tep_draw_result2_bottom(); ?> 
                            <?php
                              }
                            ?> 
                  </div>
         				</li>
                            
<?php	
  } else {
?>
         				<li class="starboard_side">
                    <div class="info2"><?php echo TEXT_NO_REVIEWS; ?></div>
         				</li>
<?php
  }
?>
              		
    
      </ol>

                      <div class="buttonSet">
                          <span class="button_left"><?php echo tep_draw_button2_top();?><?php echo tep_draw_button(IMAGE_BUTTON_BACK, '', tep_href_link(FILENAME_PRODUCT_INFO, tep_get_all_get_params())); ?><?php echo tep_draw_button2_bottom();?></span>
              
                          <span class="button_right"><?php echo tep_draw_button1_top();?><?php echo tep_draw_button(IMAGE_BUTTON_WRITE_REVIEW, 'comment', tep_href_link(FILENAME_PRODUCT_REVIEWS_WRITE, tep_get_all_get_params()), ''); ?><?php echo tep_draw_button1_bottom();?></span>
                      </div>
  </div>
</div>

<?php echo tep_draw_content_bottom();?>

<?php
  require(DIR_WS_INCLUDES . 'template_bottom.php');
  require(DIR_WS_INCLUDES . 'application_bottom.php');
?>
