deltabiri Posted August 27, 2010 Posted August 27, 2010 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 //-->
Recommended Posts
Archived
This topic is now archived and is closed to further replies.