zen cart 特价商品页加入排序选择

 

首先在tpl_specials_default.php合适位置加入
require($template->get_template_dir('/tpl_modules_listing_display_order.php',DIR_WS_TEMPLATE, $current_page_base,'templates'). '/tpl_modules_listing_display_order.php');
?>
现在在特价商品页显示下拉框了，可是这时点击排序是没有变化的，对比includes/modules/pages/specials/main_template_vars.php和includes/modules/pages/products_new/header_php.php，修改main_template_vars.php中的sql语句代码，

 

.....AND pd.language_id = :languagesID " . $display_limit . $order_by;在加上products_new/header_php.php的头部就ok了

 

在新进商品里调用该文件，选择排序会传递参数，参数传进查询语句sql里面了，但是特价商品里面的sql没有接收该参数的变量，所以要排序有变化的话，要修改特价商品里面的sql语句。
这是新进商品的查询语句。
$products_new_query_raw = "SELECT p.products_id, p.products_type, pd.products_name, p.products_image, p.products_price,
p.products_tax_class_id, p.products_date_added, m.manufacturers_name, p.products_model,
p.products_quantity, p.products_weight, p.product_is_call,
p.product_is_always_free_shipping, p.products_qty_box_status,
p.master_categories_id
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_id = pd.products_id
AND pd.language_id = :languageID " . $display_limit . $order_by;

这是特价商品的查询语句。
$specials_query_raw = "SELECT p.products_id, p.products_image, pd.products_name, pd.products_description,
p.master_categories_id
FROM (" . TABLE_PRODUCTS . " p
LEFT JOIN " . TABLE_SPECIALS . " s on p.products_id = s.products_id
LEFT JOIN " . TABLE_PRODUCTS_DESCRIPTION . " pd on p.products_id = pd.products_id )
WHERE p.products_id = s.products_id and p.products_id = pd.products_id and p.products_status = '1'
AND s.status = 1
AND pd.language_id = :languagesID
ORDER BY s.specials_date_added DESC";
对比一下，最后一句改为 " . $display_limit . $order_by;试一下
在includes/modules/pages/specials/main_template_vars.php 文件
希望你能成功。