Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

discount formatted


luigicosta

Recommended Posts

Hello everyone, I would like to implement this change in product info.

addition to the price I would vizualizzare the percentage difference.

example;

 

List Price: $ 29.95

Price: $ 19.95

You Save: $ 10.00 (33% Off)

 

there is some contribution already made​​?

otherwise any ideas or advice where to start modifying the code?

Thanks to all.

LC

Link to comment
Share on other sites

There was an error? Or maybe something you forgot to add in the admin, like eg a price for a product?

 

Would you mind to share what the error was and how you fixed this?

 

hello, unfortunately my English is truly scandalous, however, the first to post I do I do much earlier the entire file.

changes have been made ​​only in product info and I have copied heavily from "burt"

very happy if I can help

Link to comment
Share on other sites

<?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');
 require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_PRODUCT_INFO);
 $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);
 require(DIR_WS_INCLUDES . 'template_top.php');
 /*** Begin Header Tags SEO ***/ 
 echo "<a name=\"\$header_tags_array['title']\"></a>";
 /*** End Header Tags SEO ***/

if ($product_check['total'] < 1) {
?>
<div class="contentContainer">
 <div class="contentText">
   <?php echo TEXT_PRODUCT_NOT_FOUND; ?>
 </div>
 <div style="float: right;">
   <?php echo tep_draw_button(IMAGE_BUTTON_CONTINUE, 'triangle-1-e', tep_href_link(FILENAME_DEFAULT)); ?>
 </div>
</div>
<?php
 } else {
   /*** Begin Header Tags SEO ***/
   $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, pd.products_url, p.products_price, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id, pd.products_head_sub_text 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 . "'");
   /*** End Header Tags SEO ***/
   $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 =  $currencies->display_price($product_info['products_price'], tep_get_tax_rate($product_info['products_tax_class_id'])) . '<BR />' . $currencies->display_price($new_price, tep_get_tax_rate($product_info['products_tax_class_id']));

// inizio

$products_price = '<table width="100%" border="0" cellspacing="3" cellpadding="3"><tr><td width="36%" align="right" class="tab1">' . TEXT_LIST_PRICE . '</td>' . '<td align="left" class="tab2">' . $currencies->display_price($product_info['products_price'], tep_get_tax_rate($product_info['products_tax_class_id'])) . '</td></tr>'
    . '<tr><td align="right" class="tab3">' . TEXT_SPECIAL_PRICE .'</td>' . '<td width="61%" align="left" class="tab4">' . $currencies->display_price($new_price, tep_get_tax_rate($product_info['products_tax_class_id'])) . '</td></tr>'

    . '<tr><td align="right" class="tab5">' . TEXT_YOU_SAVE . '</td>' . '<td align="left class="tab6">' . $currencies->display_price(($product_info['products_price'] -  $new_price), tep_get_tax_rate($product_info['products_tax_class_id'])) . ' (' . number_format(100 - (($new_price / $product_info['products_price']) * 100)) . '%)</td></tr></table>';

// fine

   } 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'];
   } else {
  $products_name = $product_info['products_name'];
   }
?>
<?php echo tep_draw_form('cart_quantity', tep_href_link(FILENAME_PRODUCT_INFO, tep_get_all_get_params(array('action')) . 'action=add_product')); ?>
<div>

 <div class="titolo_descrizione"><?php echo $products_name; ?></div>
</div>


<div class="contentContainer">
 <div class="contentText">
<?php
   if (tep_not_null($product_info['products_image'])) {
  $pi_query = tep_db_query("select image, htmlcontent from " . TABLE_PRODUCTS_IMAGES . " where products_id = '" . (int)$product_info['products_id'] . "' order by sort_order");
  if (tep_db_num_rows($pi_query) > 0) {
?>
   <div id="piGal" style="float: left;">
  <ul>
<?php
    $pi_counter = 0;
    while ($pi = tep_db_fetch_array($pi_query)) {
	  $pi_counter++;
	  $pi_entry = '	    <li><a href="';
	  if (tep_not_null($pi['htmlcontent'])) {
	    $pi_entry .= '#piGalimg_' . $pi_counter;
	  } else {
	    $pi_entry .= tep_href_link(DIR_WS_IMAGES . $pi['image']);
	  }
	  $pi_entry .= '" target="_blank" rel="fancybox">' . tep_image(DIR_WS_IMAGES . $pi['image']) . '</a>';
	  if (tep_not_null($pi['htmlcontent'])) {
	    $pi_entry .= '<div style="display: none;"><div id="piGalimg_' . $pi_counter . '">' . $pi['htmlcontent'] . '</div></div>';
	  }
	  $pi_entry .= '</li>';
	  echo $pi_entry;
    }
?>
  </ul>
   </div>


<script type="text/javascript">
$('#piGal ul').bxGallery({
 maxwidth: 300,
 maxheight: 200,
 thumbwidth: <?php echo (($pi_counter > 1) ? '75' : '0'); ?>,
 thumbcontainer: 300,
 load_image: 'ext/jquery/bxGallery/spinner.gif'
});
</script>
<?php
  } else {
?>
   <table border="0" align="left"cellpadding="3" cellspacing="3">
 <tr><td>
   <div id="piGal" style="float: left;">
  <?php echo '<a href="' . tep_href_link(DIR_WS_IMAGES . $product_info['products_image']) . '" target="_blank" rel="fancybox">' . tep_image(DIR_WS_IMAGES . $product_info['products_image'], addslashes($product_info['products_name']), null, null, 'hspace="5" vspace="5"') . '</a>'; ?>
   </div>
</td></tr>
<tr><td align="center"><?php
  if ($product_check['total'] >= 1) {
  include (DIR_WS_INCLUDES . 'products_next_previous.php');
  }
  ?></td></tr>
</table>
<?php
  }
?>
<script type="text/javascript">
$("#piGal a[rel^='fancybox']").fancybox({
 cyclic: true
});
</script>
<?php
   }
?>


<table width="300" border="0" cellpadding="0" cellspacing="0">
  <tr>
    <td width="80"><h4><b><font face="verdana" color="green"><?php echo $products_price; ?></b></h4></td>
  </tr>
   </table>

  <table width="300" border="1" cellpadding="4" cellspacing="4">
    <tr>
	  <td width="30" align="left"><?php echo TEXT_PRODUCT_INFO_QUANTO ?></td>
	  <td width="32" align="center"><?php echo  tep_draw_input_field('cart_quantity', '1', 'size=2'); ?></td>
	  <td width="110" align="center"><div class="buttonSet"><span class="buttonAction"><?php echo tep_draw_hidden_field('products_id', $product_info['products_id']) . tep_image_submit('buy.jpg'); ?></span></div></td>
    </tr>
    <tr>
	 <td>modello</td>
	 <td align="center"><?php echo '<span class="smallText">[' . $product_info['products_model'] . ']</span>';?></td>
	 <td> </td>
    </tr>
    <tr>
	 <td><?php echo IN_STOK ?></td>
	 <td align="center">
 <?php
  if ($product_info['products_date_available'] > date('Y-m-d H:i:s')) {
  echo TEXT_ROSSO
 ?>

 <?php
  }
  echo TEXT_VERDE
 ?>		 
	 </td>
	 <td> </td>		 
    </tr>
  </table>

  <table width="300" border="0" cellpadding="0" cellspacing="0">
   <tr>
    <td><?php echo tep_image(DIR_WS_IMAGES . '/test_logo.jpg');?></td>
    </tr>
  </table> 

<?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) {
?>


<?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();
//<!-- AJAX Attribute Manager -->
    $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 . "' order by pa.products_options_sort_order");
//<!-- AJAX Attribute Manager end -->
    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 (is_string($HTTP_GET_VARS['products_id']) && 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;
    }
?>
  <strong><?php echo $products_options_name['products_options_name'] . ':'; ?></strong><br /><?php echo tep_draw_pull_down_menu('id[' . $products_options_name['products_options_id'] . ']', $products_options_array, $selected_attribute); ?><br />
<?php
  }
?>

<br>
<?php
   }
?>
   <div style="clear: both;"></div>

 </div>
<?php
   $reviews_query = tep_db_query("select count(*) as count from " . TABLE_REVIEWS . " where products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and reviews_status = 1");
   $reviews = tep_db_fetch_array($reviews_query);
?>


 <table width="100%" border="0" cellspacing="7" cellpadding="7">
   <tr>
  <td><div style="float: left; padding: 10px 2px 3px;"><?php echo tep_image(DIR_WS_IMAGES . '/downArrow.png');?></div>
   <div style="float: left; font-weight: bold; font-size: 12px; padding-top: 5px;"><?php echo TEXT_PRODUCT_DESCRIZIONE ?></div></td>

   </tr>
   <tr><td><?php echo stripslashes($product_info['products_description']); ?></td></tr>
 </table>





   <!--- BEGIN Header Tags SEO Social Bookmarks -->
  <?php
  if (tep_not_null($product_info['products_head_sub_text'])) {
	  echo '<div class="contentText" style="margin-top:5px; text-align:left;">' . $product_info['products_head_sub_text'] . '</div>';
  }
  ?>   
  <!--- BEGIN Header Tags SEO Social Bookmarks -->
  <?php
  if (HEADER_TAGS_DISPLAY_SOCIAL_BOOKMARKS == 'true') {
		    echo '<div style="margin-top:5px;">';
	 include(DIR_WS_MODULES . 'header_tags_social_bookmarks.php');
	 echo '</div>';
  }
  ?>
  <!--- END Header Tags SEO Social Bookmarks --> 
<?php
   if ((USE_CACHE == 'true') && empty($SID)) {
  echo tep_cache_also_purchased(3600);
   } else {
  include(DIR_WS_MODULES . FILENAME_ALSO_PURCHASED_PRODUCTS);
   }
?>
  <?php /*** Begin Header Tags SEO ***/
  if (tep_not_null($product_info['products_head_sub_text'])) {
	  echo '<tr><td><table border="0" cellpadding="0"><tr><td class="hts_sub_text"><div>' . $product_info['products_head_sub_text'] . '</div></td></tr></table></td></tr>';
  }
  if (HEADER_TAGS_DISPLAY_CURRENTLY_VIEWING == 'true') {
	  echo '<div style="margin-top:5px;"><div style="text-align:left" class="smallText">' .TEXT_VIEWING . ' ';
	  if (! tep_not_null($header_tags_array['title'])) $header_tags_array['title'] = $product_info['products_name'];
	  echo '<a title="' . $header_tags_array['title'] . '" href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $product_info['products_id'], 'NONSSL') . '"/# ' . $header_tags_array['title'] . '">' . $header_tags_array['title'] . '</a>';
	  echo '</div></div>';
  }
  /*** End Header Tags SEO ***/
  ?>

</div>
</form>
<?php
 }
 require(DIR_WS_INCLUDES . 'template_bottom.php');
 require(DIR_WS_INCLUDES . 'application_bottom.php');
?>

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...