Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

integrate two Contribution new and showcase


deltabiri

Recommended Posts

Posted

I wanted to change the list of products on display at the moment have 2 files (right and left) very confusing and low aesthetic impact on oscommerce I found a file to put on the list type page new products only that instead of putting by admin on selected products showcase puts me in listing new products, someone manages to combine the two codes has?

that 's what I wear at:

<?php
/*
 $Id: new_products.php,v 1.34 2003/06/09 22:49:58 hpdl Exp $

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

 Copyright (c) 2003 osCommerce

 Released under the GNU General Public License
*/
$column_location = 'center';
?>
<!-- new_products //-->
<?php
  $info_box_contents = array();
 $info_box_contents[] = array('text' => sprintf(TABLE_HEADING_NEW_PRODUCTS, strftime('%B')));

 new contentBoxHeading($info_box_contents, $column_location);
?>
<?php

 //TotalB2B start
 if ( (!isset($new_products_category_id)) || ($new_products_category_id == '0') ) {
   $new_products_query = tep_db_query("select p.products_id, p.products_image, p.products_tax_class_id, p.products_price from " . TABLE_PRODUCTS . " p where products_status = '1' and vetrina = '1' order by rand() desc limit " . MAX_DISPLAY_NEW_PRODUCTS);
     //   $new_products_query = tep_db_query("select p.products_id, p.products_image, p.products_tax_class_id, if(s.status, s.specials_new_products_price, p.products_price) as products_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where products_status = '1' order by rand() DESC limit " . MAX_DISPLAY_NEW_PRODUCTS); 

 } else {
   $new_products_query = tep_db_query("select distinct p.products_id, p.products_image, p.products_tax_class_id, p.products_price as products_price from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_CATEGORIES . " c where p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and c.parent_id = '" . (int)$new_products_category_id . "' and p.products_status = '1' and vetrina = '1' order by rand() desc limit  " . MAX_DISPLAY_NEW_PRODUCTS);
 }
 //TotalB2B end

 $row = 0;
 $col = 0;
 $info_box_contents = array();


 while ($new_products = tep_db_fetch_array($new_products_query)) {

   $new_products['products_name'] = tep_get_products_name($new_products['products_id']);
   $new_products['products_description'] = tep_get_products_description($new_products['products_id']);

//TotalB2B start & TotalB2B start
if ($new_price = tep_get_products_special_price($new_products['products_id'])) {
     $new_products['products_price'] = $new_price;
  $info_box_contents[$row][$col] = array('align' => 'center',
                                      'text' => '<table align="center" cellspacing="2" cellpadding="2" width="100%"><tr><td class="newProducts" width="100%"><table width="100%" align="center" cellspacing="0" cellpadding="0"><tr ><td class="newProductsHeading"><a class="newProductsHeading" href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $new_products['products_id']) . '">' . $new_products['products_name'] . '</a></td></tr></table><table width="190" align="left" cellpadding="2" cellspacing="2"><tr><td class="NewProducts" align="left"><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $new_products['products_id']) . '">' . tep_image(DIR_WS_IMAGES . $new_products['products_image'], $new_products['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '</a></td><td class="newProducts">' . tep_flatten_product_description($new_products['products_description'],  ' <a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $newproducts['products_id']) . '">' . '...' . '</a>') . '<br /><b>' .  $currencies->display_price_nodiscount($new_products['products_price'], tep_get_tax_rate($new_products['products_tax_class_id'])). '<br />' . '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $new_products['products_id']) . '">' . tep_image_button('aggiungi_cart.gif', IMAGE_BUTTON_BUY_NOW) . '</a>
</b></td></tr></table></td></tr><tr><td></td></tr></table>');

   } else {
     $new_products['products_price'] = tep_xppp_getproductprice($new_products['products_id']);
  $info_box_contents[$row][$col] = array('align' => 'center',
                                      'text' => '<table align="center" cellspacing="2" cellpadding="2" width="100%"><tr><td class="newProducts" width="100%"><table width="100%" align="center" cellspacing="0" cellpadding="0"><tr ><td class="newProductsHeading"><a class="newProductsHeading" href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $new_products['products_id']) . '">' . $new_products['products_name'] . '</a></td></tr></table><table width="190" align="left" cellpadding="2" cellspacing="2"><tr><td class="NewProducts" align="left"><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $new_products['products_id']) . '">' . tep_image(DIR_WS_IMAGES . $new_products['products_image'], $new_products['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '</a></td><td class="newProducts">' . tep_flatten_product_description($new_products['products_description'],  ' <a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $newproducts['products_id']) . '">' . '...' . '</a>') . '<br /><b>' . $currencies->display_price($new_products['products_id'],   $new_products['products_price'], tep_get_tax_rate($new_products['products_tax_class_id'])). '<br />' .' <a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $new_products['products_id']) . '">' . tep_image_button('aggiungi_cart.gif', IMAGE_BUTTON_BUY_NOW) . '</a>
</b></td></tr></table></td></tr><tr><td></td></tr></table>');
   }
//TotalB2B end & TotalB2B end

$col ++;
   if ($col > 1) {
     $col = 0;
     $row ++;

   }
 }

 new contentBox($info_box_contents, $column_location);
$column_location = '';

?>


<!-- new_products_eof //-->

and this one found on osCommerce:

<?php
/*
 $Id: new_products.php v2.8 2009-12-31 22:48:15Z hpdl $
 modified for thumbnail view 2007-07-24
 osCommerce, Open Source E-Commerce Solutions
 http://www.oscommerce.com

 Copyright (c) 2008 osCommerce

 Released under the GNU General Public License
*/
?>
<!-- new_products //-->
<?php

$max_age = tep_not_null( MAX_DISPLAY_PRODUCTS_NEW_AGE ) ?  MAX_DISPLAY_PRODUCTS_NEW_AGE : 60; // set max age of displayed product
$date = strtotime("-" . $max_age . " days"); 
$date = strftime("%Y-%m-%d",$date); 

$new_mode = sprintf(TABLE_HEADING_NEW_PRODUCTS, strftime('%B'));

   $define_list = array('PRODUCT_LIST_MODEL' => PRODUCT_LIST_MODEL,
                        'PRODUCT_LIST_NAME' => PRODUCT_LIST_NAME,
                        'PRODUCT_LIST_MANUFACTURER' => PRODUCT_LIST_MANUFACTURER,
                        'PRODUCT_LIST_PRICE' => PRODUCT_LIST_PRICE,
                        'PRODUCT_LIST_QUANTITY' => PRODUCT_LIST_QUANTITY,
                        'PRODUCT_LIST_WEIGHT' => PRODUCT_LIST_WEIGHT,
                        'PRODUCT_LIST_IMAGE' => PRODUCT_LIST_IMAGE,
                        'PRODUCT_LIST_BUY_NOW' => PRODUCT_LIST_BUY_NOW);

   asort($define_list);

   $column_list = array();
   reset($define_list);
   while (list($key, $value) = each($define_list)) {
     if ($value > 0) $column_list[] = $key;
   }

   $select_column_list = '';

 for ($i=0, $n=sizeof($column_list); $i<$n; $i++) {
     switch ($column_list[$i]) {
       case 'PRODUCT_LIST_MODEL':
         $select_column_list .= 'p.products_model, ';
         break;
       case 'PRODUCT_LIST_NAME':
         $select_column_list .= 'pd.products_name, ';
         break;
       case 'PRODUCT_LIST_MANUFACTURER':
         $select_column_list .= 'm.manufacturers_name, ';
         break;
       case 'PRODUCT_LIST_QUANTITY':
         $select_column_list .= 'p.products_quantity, ';
         break;
       case 'PRODUCT_LIST_WEIGHT':
         $select_column_list .= 'p.products_weight, ';
         break;
     }
   }
$order = ' order by p.products_date_added desc';
// $order = ' order by rand()'; // uncomment if you want products in a random order


 if ( (!isset($new_products_category_id)) || ($new_products_category_id == '0') ) {
   $new_products_query = "select " . $select_column_list . "p.products_id, p.products_image, p.products_tax_class_id, p.products_price, p.products_quantity from " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on (p.manufacturers_id = m.manufacturers_id), " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_date_added > '".$date."' and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "'" . $order;
 } else {
   $new_products_query = "select distinct " . $select_column_list . "p.products_id, p.products_image, p.products_tax_class_id, p.products_price, p.products_quantity from " . TABLE_PRODUCTS . " p  left join " . TABLE_MANUFACTURERS . " m on (p.manufacturers_id = m.manufacturers_id), " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_CATEGORIES . " c where p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and c.parent_id = '" . (int)$new_products_category_id . "' and p.products_status = '1' and p.products_date_added > '".$date."' and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "'" . $order;
 }

$listing_sql = $new_products_query;
include(DIR_WS_MODULES . FILENAME_PRODUCT_LISTING); 
?>
<!-- new_products_eof //-->

Archived

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

×
×
  • Create New...