<?php
/*
  $Id: product_info.php,v 1.97 2003/07/01 14:34:54 hpdl Exp $

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

  Copyright (c) 2003 osCommerce

  Released under the GNU General Public License
*/
echo "<?php require('../../includes/application_top_static.php');?>\n";

  require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_PRODUCT_INFO);
  require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_REVIEWS);

$HTTP_GET_VARS['products_id']=$products_id;

  $product_check_query = tep_db_query("select count(*) as total from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "'");
  $product_check = tep_db_fetch_array($product_check_query);
    if ($product_check['total'] >= 1) { 
    $product_info_query = tep_db_query("select p.products_id,p.code, pd.products_name, pd.products_description, p.products_model, p.products_quantity, p.products_image, p.products_imagebig, pd.products_url, p.products_price, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "'");
	$product_info = tep_db_fetch_array($product_info_query);
  }
?>
<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">
<html <?php echo HTML_PARAMS; ?>>
<head>
<title><?php echo IND_TITLE_A.$product_info['products_name']." ".$product_info['products_model'].IND_TITLE_B.TEXT_DOMAIN_NAME.IND_TITLE_D; ?></title>
<meta name="description" content="<?php
if (tep_not_null($product_info['optimize_description']))
	echo $product_info['optimize_description'];
else
	echo IND_TITLE_A.$product_info['products_name']." ".$product_info['products_model'].IND_TITLE_B.DOMAIN_COM;
?>">
<meta name="keywords" content="<?php
if (tep_not_null($product_info['optimize_keywords1']))
	echo $product_info['optimize_keywords1'];
else
	echo IND_TITLE_A.$product_info['products_name'].",".$product_info['products_name'].",".$product_info['products_name']." for sale";
?>">

<link rel="stylesheet" type="text/css" href="../../stylesheet.css">
<base href="<?php echo (($request_type == 'SSL') ? HTTPS_SERVER : HTTP_SERVER) . DIR_WS_CATALOG; ?>">
<meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>">
<script language="javascript"><!--
function popupWindow(url) {
  window.open(url,'popupWindow','toolbar=no,location=no,directories=no,status=no,menubar=no,scrollbars=no,resizable=yes,copyhistory=no,width=100,height=100,screenX=150,screenY=150,top=150,left=150')
}
//--></script>
<link   rel="Shortcut   Icon"   href="../../favicon.ico">
<link   rel="Bookmark"   href="../../favicon.ico">
</head>
<body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0">
<!-- header //-->
<?php echo "<?php require('../../header.html');?>";?>
<!-- header_eof //-->
<table width="985" border="0" cellpadding="0" cellspacing="0">
  <tr>
    <td width="698" height="22">
		<table width="98%"  border="0" cellspacing="0" cellpadding="0">
		  <tr>
			<td > <span class="catalog_zi_item_link"> &nbsp;&nbsp; <?php echo $breadcrumb->trail(' &raquo; ');?></span></td>
		  </tr>
    	</table>
	</td>
    <td width="10">
			<table width="98%"  border="0" cellspacing="0" cellpadding="0">
			  <tr>
				<td ></td>
			  </tr>
			</table>
	</td>
    <td width="11"><span class="style18"> </span></td>
    <td width="266"><?php echo '<a href="' . tep_href_link('conditions_output.php') . '" class="catalog_zi_link">' . TOP_TEXT_SEECONTION. '</a>' ?></td>
  </tr>
</table>
<!-- body //-->
<table width="985" border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
  <tr>
    <td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="0">
<!-- left_navigation //-->
<?php require(DIR_WS_INCLUDES . 'column_left_output.php'); ?>
<!-- left_navigation_eof //-->
    </table></td>
<!-- body_text //-->
    <td width="100%" valign="top"><?php echo tep_draw_form('cart_quantity', tep_href_link('product_info_static.php', tep_get_all_get_params(array('action')) . 'action=add_product_s')); ?>
      <table border="0" width="100%" cellspacing="0" cellpadding="8" bgcolor="#FFFFFF">
        <tr> 
          <td height="1" colspan="2"></td>
        </tr>
        <?php
  if ($product_check['total'] < 1) {
?>
        <tr> 
          <td colspan="2"> 
            <?php new infoBox(array(array('text' => TEXT_PRODUCT_NOT_FOUND))); ?>
          </td>
        </tr>
        <tr> 
          <td colspan="2"><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
        </tr>
        <tr> 
          <td colspan="2"><table border="0" width="100%" cellspacing="1" cellpadding="2" class="infoBox">
              <tr class="infoBoxContents"> 
                <td><table border="0" width="100%" cellspacing="0" cellpadding="2">
                    <tr> 
                      <td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td>
                      <td align="right"><?php echo '<a href="' . HTTP_SERVER . '">' . tep_image_button('button_continue.gif', IMAGE_BUTTON_CONTINUE) . '</a>'; ?></td>
                      <td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td>
                    </tr>
                  </table></td>
              </tr>
            </table></td>
        </tr>
        <?php
  } else {
    //$product_info_query = tep_db_query("select p.products_id, pd.products_name, pd.products_description, p.products_model, p.products_quantity, p.products_image, p.products_imagebig, pd.products_url, p.products_price, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id,p.code from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "'");
    //$product_info = tep_db_fetch_array($product_info_query);

    tep_db_query("update " . TABLE_PRODUCTS_DESCRIPTION . " set products_viewed = products_viewed+1 where products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and language_id = '" . (int)$languages_id . "'");

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

    if (tep_not_null($product_info['products_model'])) {
      $products_name = $product_info['products_name'] . '<br><span class="smallText">[' . $product_info['products_model'] . ']</span>';
      $products_code = $product_info['code'];
    } else {
      $products_name = $product_info['products_name'];
      $products_code = $product_info['code'];
    }
?>
       
        <?php
    if (tep_not_null($product_info['products_imagebig'])) {
//    $path_categories_query=tep_db_query("select distinct cd.categories_name from " . TABLE_CATEGORIES_DESCRIPTION . " cd, " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where p2c.products_id =" . (int)$HTTP_GET_VARS['products_id'] . " and p2c.categories_id = cd.categories_id");
/*
	$sql='select p2c.categories_id from products_to_categories p2c where p2c.products_id ='.(int)$HTTP_GET_VARS['products_id'].' order by p2c.categories_id limit 1';
	$c_query = tep_db_query($sql);
	$c_result = tep_db_fetch_array($c_query);
	$cid=$c_result['categories_id'];
	$cid=soobic_get_categoryid($cid);
			
	$sql="select categories_name from " . TABLE_CATEGORIES_DESCRIPTION . " where categories_id=".$cid." and language_id=4 limit 1";
	$path_categories_query=tep_db_query($sql);

    $path_categories=tep_db_fetch_array($path_categories_query);
*/	
		if(file_exists(DIR_FS_PRODUCTS_MAX_IMAGES.$product_info['products_imagebig'])==0)
			$picture_url = "nopicture.gif";
		else 
			$picture_url = 'products_images/unfurl/'. $product_info['products_imagebig'];
?>
        <tr> 
          <td width="240" align="left"> 
            <?php
 echo tep_image(DIR_WS_IMAGES . $picture_url, $product_info['products_name'], $width = '',  $height = '', 'hspace="0" vspace="2"'); 
?></td><td width="69%" align="left" valign="top"><table width="100%" height="19" border="0" cellpadding="0" cellspacing="0">
              <tr> 
                <td height="19" valign="top" class="pageHeading"><?php echo $products_name; ?>&nbsp;</td>
              </tr>
            </table>
            <table width="100%" height="10" border="0" cellpadding="0" cellspacing="0">
              <tr> 
                <td height="8" valign="top" class="pageHeading"></td>
              </tr>
            </table>
            <table width="100%" height="38" border="0" cellpadding="0" cellspacing="0">
              <tr> 
                <td height="9" valign="top" class="pageHeadingprice"><?php echo PRO_PRICE; ?>&nbsp;<?php echo $products_price; ?></td>
              </tr>
              <tr>
                <td height="10" valign="top" class="text_4"><b><?php echo PRO_CODE; ?></b>&nbsp;<?php echo $products_code;?></td>
              </tr>
            </table>
            <table width="100%" height="10" border="0" cellpadding="0" cellspacing="0">
              <tr> 
                <td height="8" valign="top" class="pageHeading"></td>
              </tr>
            </table>
            <table width="100%" height="70" border="0" cellpadding="0" cellspacing="0">
              <tr> 
                <td valign="top" class="text_4"><?php echo PRO_AD_SALE; ?><?php echo $products_name; ?>&nbsp;&nbsp;<?php echo PRO_AD_SALE3_OUPUT; ?></td>
              </tr>
			  <tr><td><br></td></tr>
              <tr>
                <td class="main" align="right"><?php echo tep_draw_hidden_field('products_id', $product_info['products_id']) . tep_image_submit('button_in_cart.gif', IMAGE_BUTTON_IN_CART); ?></td>                
				<td>&nbsp;&nbsp;</td>
              </tr>
             </table></td>
        </tr>
        <?php
    }
?>
        <?php 
			$category_links = array_reverse($cPath_array);
			$cccc_id=soobic_get_p_categoryid((int)$HTTP_GET_VARS['products_id']);
			if ($cccc_id=='103' || $cccc_id=='70' || $cccc_id=='138' || $cccc_id=='139' || $cccc_id=='140' || $cccc_id=='77' || $cccc_id=='71' || $cccc_id=='72' ) {
		?>
		<tr> 
          <td colspan="2" class="text_2"><? //echo PRO_NOTICE;?></td>
        </tr>
		<? }?>	
        <tr> 
          <td colspan="2" class="text_2"  style="WORD-BREAK: break-all; BORDER-COLLAPSE: collapse"><?php echo stripslashes($product_info['products_description']); ?></td>
        </tr>
        <?php 
			$category_links = array_reverse($cPath_array);
			$cccc_id=soobic_get_p_categoryid((int)$HTTP_GET_VARS['products_id']);
			if ($cccc_id=='103' || $cccc_id=='70' || $cccc_id=='138' || $cccc_id=='139' || $cccc_id=='140' || $cccc_id=='77' || $cccc_id=='71' || $cccc_id=='72' ) {
		?>
		<tr> 
          <td colspan="2" class="text_2"><? //echo PRO_NOTICE;?></td>
        </tr>
		<? }?>	
        <tr> 
          <td colspan="2" class="main"> 
            <?php
    $products_attributes_query = tep_db_query("select count(*) as total from " . TABLE_PRODUCTS_OPTIONS . " popt, " . TABLE_PRODUCTS_ATTRIBUTES . " patrib where patrib.products_id='" . (int)$HTTP_GET_VARS['products_id'] . "' and patrib.options_id = popt.products_options_id and popt.language_id = '" . (int)$languages_id . "'");
    $products_attributes = tep_db_fetch_array($products_attributes_query);
    if ($products_attributes['total'] > 0) {
?>
            <table border="0" cellspacing="0" cellpadding="2">
              <tr> 
                <td class="main" colspan="2"><?php echo TEXT_PRODUCT_OPTIONS; ?></td>
              </tr>
              <?php
      $products_options_name_query = tep_db_query("select distinct popt.products_options_id, popt.products_options_name from " . TABLE_PRODUCTS_OPTIONS . " popt, " . TABLE_PRODUCTS_ATTRIBUTES . " patrib where patrib.products_id='" . (int)$HTTP_GET_VARS['products_id'] . "' and patrib.options_id = popt.products_options_id and popt.language_id = '" . (int)$languages_id . "' order by popt.products_options_name");
      while ($products_options_name = tep_db_fetch_array($products_options_name_query)) {
        $products_options_array = array();
        $products_options_query = tep_db_query("select pov.products_options_values_id, pov.products_options_values_name, pa.options_values_price, pa.price_prefix from " . TABLE_PRODUCTS_ATTRIBUTES . " pa, " . TABLE_PRODUCTS_OPTIONS_VALUES . " pov where pa.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pa.options_id = '" . (int)$products_options_name['products_options_id'] . "' and pa.options_values_id = pov.products_options_values_id and pov.language_id = '" . (int)$languages_id . "'");
        while ($products_options = tep_db_fetch_array($products_options_query)) {
          $products_options_array[] = array('id' => $products_options['products_options_values_id'], 'text' => $products_options['products_options_values_name']);
          if ($products_options['options_values_price'] != '0') {
            $products_options_array[sizeof($products_options_array)-1]['text'] .= ' (' . $products_options['price_prefix'] . $currencies->display_price($products_options['options_values_price'], tep_get_tax_rate($product_info['products_tax_class_id'])) .') ';
          }
        }

        if (isset($cart->contents[$HTTP_GET_VARS['products_id']]['attributes'][$products_options_name['products_options_id']])) {
          $selected_attribute = $cart->contents[$HTTP_GET_VARS['products_id']]['attributes'][$products_options_name['products_options_id']];
        } else {
          $selected_attribute = false;
        }
?>
              <tr> 
                <td class="main"><?php echo $products_options_name['products_options_name'] . ':'; ?></td>
                <td class="main"><?php echo tep_draw_pull_down_menu('id[' . $products_options_name['products_options_id'] . ']', $products_options_array, $selected_attribute); ?></td>
              </tr>
              <?php
      }
?>
            </table>
            <?php
    }
?>
          </td>
        </tr>
        <tr> 
          <td colspan="2"><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
        </tr>
        <?php

    if (tep_not_null($product_info['products_url'])) {
?>
        <tr> 
          <td colspan="2" class="main"><?php echo sprintf(TEXT_MORE_INFORMATION, tep_href_link('redirect_output.php', 'action=url&goto=' . urlencode($product_info['products_url']), 'NONSSL', true, false)); ?></td>
        </tr>
        <tr> 
          <td colspan="2"><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
        </tr>
        <?php
    }

    if ($product_info['products_date_available'] > date('Y-m-d H:i:s')) {
?>
        <tr> 
          <td colspan="2" align="center" class="smallText"><?php echo sprintf(TEXT_DATE_AVAILABLE, tep_date_long($product_info['products_date_available'])); ?></td>
        </tr>
        <?php
    } else {
?>
        <tr> 
          <td colspan="2" align="center" class="smallText"><?php echo sprintf(TEXT_DATE_ADDED_OUTPUT, tep_date_long($product_info['products_date_added'])); ?></td>
        </tr>
        <?php
    }
?>
        <tr> 
          <td colspan="2"><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
        </tr>
        <tr> 
          <td colspan="2"><table border="0" width="100%" cellspacing="0" cellpadding="0" class="infoBox">
              <tr class="infoBoxContents"> 
                <td><table width="100%" border="0" cellpadding="2" cellspacing="0" bgcolor="#FFFFFF">
                    <tr> 
                      <td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td>
                      <td class="main"><?php echo '<a href="' . tep_href_link('product_reviews_output.php', tep_get_all_get_params()) . '">' . tep_image_button('button_reviews.gif', IMAGE_BUTTON_REVIEWS) . '</a>'; ?></td>
                      <td class="main" align="right"><?php echo tep_draw_hidden_field('products_id', $product_info['products_id']) . tep_image_submit('button_in_cart.gif', IMAGE_BUTTON_IN_CART); ?></td>
                      <td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td>
                    </tr>
                  </table></td>
              </tr>
            </table></td>
        </tr>
        <tr> 
          <td colspan="2"><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
        </tr>
        
<?php
//  $reviews_query = tep_db_query("select count(*) as count from " . TABLE_REVIEWS . " where products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "'");
	$reviews_query = tep_db_query("select count(*) as count from " . TABLE_REVIEWS . " r, " . TABLE_REVIEWS_DESCRIPTION . " rd where r.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and r.reviews_id = rd.reviews_id and rd.languages_id = '" . (int)$languages_id . "'");
    $reviews = tep_db_fetch_array($reviews_query);
    if ($reviews['count'] > 0) {
?>
        <tr> 
          <td colspan="2" class="main"><?php echo TEXT_CURRENT_REVIEWS . ' ' . $reviews['count']; ?></td>
        </tr>
        <?php
    }?>

	  <tr>	
	    <td colspan="2">
	<?php 
		//List Best Customers Reviews
		include(DIR_WS_MODULES . 'list_best_reviews_output.php');
	?>
		</td>
	  </tr>	
      <tr>
        <td colspan="2"><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
      </tr>
	  <tr>	
	    <td colspan="2">
	<?php 
		//List Best Customers Reviews
		include(DIR_WS_MODULES . 'relative_products_output.php');
	?>
		</td>
	  </tr>	
      <tr>
        <td ><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
      </tr>		
		
		
		<tr> 
          <td colspan="2"> 
            <?php
    if ((USE_CACHE == 'true') && empty($SID)) {
      echo tep_cache_also_purchased(3600);
    } else {
      include(DIR_WS_MODULES . FILENAME_ALSO_PURCHASED_PRODUCTS);
    }
  }
?>
          </td>
        </tr>
      </table>
      </form></td>
<!-- body_text_eof //-->
    <td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="0">
<!-- right_navigation //-->
<?php require(DIR_WS_INCLUDES . 'column_right_output.php'); ?>
<!-- right_navigation_eof //-->
    </table></td>
  </tr>
</table>
<!-- body_eof //--><br>

<!-- footer //-->
<?php echo "<?php require('../../footer.html');?>";?>
<!-- footer_eof //-->
</body>
</html>
<?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>
