Рекомендуемые товары на главной

[pal-palich 6]

Как на главной странице отсортировать по умолчанию товары по цене?

[support 447]

В /includes/modules/featured.php меняйте order by p.products_date_added на order by p.products_price

[pal-palich 6]

5 минут назад, VaM сказал:

В /includes/modules/featured.php меняйте order by p.products_date_added на order by p.products_price

Нет там такой строчки.

<?php
/* -----------------------------------------------------------------------------------------
   $Id: featured.php 1292 2007-02-06 20:41:56 VaM $   

   VaM Shop - open source ecommerce solution
   http://vamshop.ru
   http://vamshop.com

   Copyright (c) 2007 VaM Shop
   -----------------------------------------------------------------------------------------
   based on: 
   (c) 2000-2001 The Exchange Project  (earlier name of osCommerce)
   (c) 2002-2003 osCommerce(new_products.php,v 1.33 2003/02/12); www.oscommerce.com
   (c) 2003	 nextcommerce (new_products.php,v 1.9 2003/08/17); www.nextcommerce.org
   (c) 2004	 xt:Commerce (new_products.php,v 1.9 2003/08/17); xt-commerce.com

   Released under the GNU General Public License 
   -----------------------------------------------------------------------------------------
   Third Party contributions:
   Enable_Disable_Categories 1.3        	Autor: Mikel Williams | mikel@ladykatcostumes.com

   Released under the GNU General Public License
   ---------------------------------------------------------------------------------------*/

$module = new vamTemplate;
$module->assign('tpl_path', 'templates/'.CURRENT_TEMPLATE.'/');

//fsk18 lock
$fsk_lock = '';
if ($_SESSION['customers_status']['customers_fsk18_display'] == '0')
	$fsk_lock = ' and p.products_fsk18!=1';

if ((!isset ($featured_products_category_id)) || ($featured_products_category_id == '0')) {
	if (GROUP_CHECK == 'true')
		$group_check = " and p.group_permission_".$_SESSION['customers_status']['customers_status_id']."=1 ";

	$featured_products_query = "SELECT * FROM
	                                         ".TABLE_PRODUCTS." p left join " . TABLE_PRODUCTS_DESCRIPTION . " pd on pd.products_id = p.products_id,
	                                         ".TABLE_FEATURED." f where
	                                         p.products_id=f.products_id ".$group_check."
	                                         ".$fsk_lock."
	                                         and p.products_status = '1' and f.status = '1' and pd.language_id = '".(int) $_SESSION['languages_id']."'
	                                         group by p.products_id order by p.products_id DESC limit ".MAX_DISPLAY_FEATURED_PRODUCTS;
} else {

	if (GROUP_CHECK == 'true')
		$group_check = "and p.group_permission_".$_SESSION['customers_status']['customers_status_id']."=1 ";

	$featured_products_query = "SELECT * FROM
	                                         ".TABLE_PRODUCTS." p left join " . TABLE_PRODUCTS_DESCRIPTION . " pd on pd.products_id = p.products_id,
	                                         ".TABLE_FEATURED." f,
	                                        ".TABLE_PRODUCTS_TO_CATEGORIES." p2c,
	                                        ".TABLE_CATEGORIES." c
	                                        where c.categories_status='1'
	                                        and p.products_id = p2c.products_id and p.products_id=f.products_id
	                                        and p2c.categories_id = c.categories_id
	                                        ".$group_check."
	                                        ".$fsk_lock."
	                                        and c.parent_id = '".$featured_products_category_id."'
	                                        and p.products_status = '1' and f.status = '1' and pd.language_id = '".(int) $_SESSION['languages_id']."'
	                                        group by p.products_id order by p.products_id DESC limit ".MAX_DISPLAY_FEATURED_PRODUCTS;
}
$row = 0;
$module_content = array ();
$featured_products_query = vamDBquery($featured_products_query);
while ($featured_products = vam_db_fetch_array($featured_products_query, true)) {
	$module_content[] = $product->buildDataArray($featured_products);

}
if (sizeof($module_content) >= 1) {
   $module->assign('FEATURED_LINK', vam_href_link(FILENAME_FEATURED));
	$module->assign('language', $_SESSION['language']);
	$module->assign('module_content', $module_content);
	
	// set cache ID
	 if (!CacheCheck()) {
		$module->caching = 0;
		if ((!isset ($featured_products_category_id)) || ($featured_products_category_id == '0')) {
			$module = $module->fetch(CURRENT_TEMPLATE.'/module/featured_products_default.html');
		} else {
			$module = $module->fetch(CURRENT_TEMPLATE.'/module/featured_products_category.html');
		}
	} else {
		$module->caching = 1;
		$module->cache_lifetime = CACHE_LIFETIME;
		$module->cache_modified_check = CACHE_CHECK;
		$cache_id = $featured_products_category_id.$_SESSION['language'].$_SESSION['customers_status']['customers_status_name'].$_SESSION['currency'];
		if ((!isset ($featured_products_category_id)) || ($featured_products_category_id == '0')) {
			$module = $module->fetch(CURRENT_TEMPLATE.'/module/featured_products_default.html', $cache_id);
		} else {
			$module = $module->fetch(CURRENT_TEMPLATE.'/module/featured_products_category.html', $cache_id);
		}
	}
	$default->assign('MODULE_featured_products', $module);
}
?>

 

[support 447]

Меняйте order by p.products_id

[pal-palich 6]

19 минуту назад, VaM сказал:

Меняйте order by p.products_id

Спасибо Саш. Все работает.

[support 447]

Не за что

[pal-palich 6]

Саш, привет! Как можно сделать, что бы на главной странице выводились рекомендуемые товары - максимум 30 штук, но при этом всегда в рандомном порядке. Сейчас товаров 300 штук, портянку большую не хочется выводить.

[support 447]

В Админке - Настройки - Максимальные в опции Рекомендуемые указать 30

А в /includes/modules/featured.php изменить значение order by на order by rand()

[pal-palich 6]

17 минуту назад, VaM сказал:

В Админке - Настройки - Максимальные в опции Рекомендуемые указать 30

А в /includes/modules/featured.php изменить значение order by на order by rand()

Спасибо брат

[support 447]

Надеюсь, что разобрались.

[meoita 0]

Спасибо.

Все работает.

[support 447]

Не за что