luigicosta Posted July 24, 2012 Share Posted July 24, 2012 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 More sharing options...
burt Posted July 24, 2012 Share Posted July 24, 2012 http://www.clubosc.com/how-to-show-special-price-more-clearly.html Enjoy. Link to comment Share on other sites More sharing options...
♥14steve14 Posted July 25, 2012 Share Posted July 25, 2012 Have a look here http://www.oscommerce.com/forums/topic/87832-ezier-new-fields/ REMEMBER BACKUP, BACKUP AND BACKUP Link to comment Share on other sites More sharing options...
luigicosta Posted July 26, 2012 Author Share Posted July 26, 2012 Thanks to everyone for the advice! the first solution I believe the most simple and functional. thanks LC Link to comment Share on other sites More sharing options...
luigicosta Posted August 2, 2012 Author Share Posted August 2, 2012 http://www.clubosc.com/how-to-show-special-price-more-clearly.html Enjoy. I found this error Division by zero any idea??? thanks http://www.firstcellular.co.uk/product_info.php/cover-nokia-serie-2100-p-134 Link to comment Share on other sites More sharing options...
multimixer Posted August 2, 2012 Share Posted August 2, 2012 I am not getting any error message. Can you link to a product that has such an error? My community profile | Template system for osCommerce - New: Responsive | Feedback channel Link to comment Share on other sites More sharing options...
luigicosta Posted August 2, 2012 Author Share Posted August 2, 2012 I am not getting any error message. Can you link to a product that has such an error? thanks anyway! but I was able by myself to fix the error. thanks LC Link to comment Share on other sites More sharing options...
multimixer Posted August 2, 2012 Share Posted August 2, 2012 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? My community profile | Template system for osCommerce - New: Responsive | Feedback channel Link to comment Share on other sites More sharing options...
luigicosta Posted August 2, 2012 Author Share Posted August 2, 2012 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 More sharing options...
luigicosta Posted August 2, 2012 Author Share Posted August 2, 2012 <?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 More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.