Сообщений в теме: 2

[Cruelten]

Всем привет. Есть такая переменная в подробном отображении товара - {$product_info.min_order_amount}
Какой ее аналог в спецпредложениях? И как это сделать? Спасибо.

[namer]

core\includes\home.php

//special offers
	    $result = array();
	    $q = db_query("select s.productID, s.categoryID, s.name, s.Price, s.brief_description, s.product_code,
	    s.default_picture, s.enabled, b.productID, t.filename FROM ".SPECIAL_OFFERS_TABLE."
	    AS b INNER JOIN ".PRODUCTS_TABLE." AS s on (b.productID=s.productID) INNER JOIN ".PRODUCT_PICTURES." AS
	    t on (s.default_picture=t.photoID AND s.productID=t.productID) WHERE s.enabled=1 order by b.sort_order");

замените на

//special offers
	    $result = array();
	    $q = db_query("select s.productID, s.categoryID, s.name, s.Price, s.brief_description, s.product_code,
	    s.default_picture, s.enabled, b.productID, t.filename, s.min_order_amount FROM ".SPECIAL_OFFERS_TABLE."
	    AS b INNER JOIN ".PRODUCTS_TABLE." AS s on (b.productID=s.productID) INNER JOIN ".PRODUCT_PICTURES." AS
	    t on (s.default_picture=t.photoID AND s.productID=t.productID) WHERE s.enabled=1 order by b.sort_order");

ну и используйте min_order_amount в шаблонах

[Cruelten]

core\includes\home.php

//special offers
		$result = array();
		$q = db_query("select s.productID, s.categoryID, s.name, s.Price, s.brief_description, s.product_code,
		s.default_picture, s.enabled, b.productID, t.filename FROM ".SPECIAL_OFFERS_TABLE."
		AS b INNER JOIN ".PRODUCTS_TABLE." AS s on (b.productID=s.productID) INNER JOIN ".PRODUCT_PICTURES." AS
		t on (s.default_picture=t.photoID AND s.productID=t.productID) WHERE s.enabled=1 order by b.sort_order");

замените на

//special offers
		$result = array();
		$q = db_query("select s.productID, s.categoryID, s.name, s.Price, s.brief_description, s.product_code,
		s.default_picture, s.enabled, b.productID, t.filename, s.min_order_amount FROM ".SPECIAL_OFFERS_TABLE."
		AS b INNER JOIN ".PRODUCTS_TABLE." AS s on (b.productID=s.productID) INNER JOIN ".PRODUCT_PICTURES." AS
		t on (s.default_picture=t.photoID AND s.productID=t.productID) WHERE s.enabled=1 order by b.sort_order");

ну и используйте min_order_amount в шаблонах

Благодарю! Спасибо.