ecshop微信商城
??官方微博: 腾讯 ?
首页 > ECSHOP教程 > ECSHOP亚博体育手机游戏送教程 > ECSHOP商品详情页修改 > ECSHOP商品属性相关属性商品由新到旧排序

ECSHOP商品属性相关属性商品由新到旧排序

ECSHOP教程 / ecshop 教程网(www.ecshop119.com) 2015-09-14

ECSHOP商品属性相关属性商品由新到旧排序

打开文件 includes/lib_goods.php

查找以下代码

/*?查找符合条件的商品?*/
????????????$sql?=?'SELECT?g.goods_id,?g.goods_name,?g.goods_thumb,?g.goods_img,?g.shop_price?AS?org_price,?'?.
????????????????????????"IFNULL(mp.user_price,?g.shop_price?*?'$_SESSION[discount]')?AS?shop_price,?".
????????????????????????'g.market_price,?g.promote_price,?g.promote_start_date,?g.promote_end_date?'?.
????????????????????'FROM?'?.?$GLOBALS['ecs']->table('goods')?.?'?AS?g?'?.
????????????????????'LEFT?JOIN?'?.?$GLOBALS['ecs']->table('goods_attr')?.?'?as?a?ON?g.goods_id?=?a.goods_id?'?.
????????????????????"LEFT?JOIN?"?.?$GLOBALS['ecs']->table('member_price')?.?"?AS?mp?".
????????????????????????"ON?mp.goods_id?=?g.goods_id?AND?mp.user_rank?=?'$_SESSION[user_rank]'?".
????????????????????"WHERE?a.attr_id?=?'$key'?AND?g.is_on_sale=1?AND?a.attr_value?=?'$val[value]'?AND?g.goods_id?<>?'$_REQUEST[id]'?"?.
????????????????????'LIMIT?'?.?$GLOBALS['_CFG']['attr_related_number'];
????????????$res?=?$GLOBALS['db']->getAll($sql);


修改成:

/*?查找符合条件的商品?*/
????????????$sql?=?'SELECT?DISTINCT??g.goods_id,?g.goods_name,?g.goods_thumb,?g.goods_img,?g.shop_price?AS?org_price,?'?.
????????????????????????"IFNULL(mp.user_price,?g.shop_price?*?'$_SESSION[discount]')?AS?shop_price,?".
????????????????????????'g.market_price,?g.promote_price,?g.promote_start_date,?g.promote_end_date?'?.
????????????????????'FROM?'?.?$GLOBALS['ecs']->table('goods')?.?'?AS?g?'?.
????????????????????'LEFT?JOIN?'?.?$GLOBALS['ecs']->table('goods_attr')?.?'?as?a?ON?g.goods_id?=?a.goods_id?'?.
????????????????????"LEFT?JOIN?"?.?$GLOBALS['ecs']->table('member_price')?.?"?AS?mp?".
????????????????????????"ON?mp.goods_id?=?g.goods_id?AND?mp.user_rank?=?'$_SESSION[user_rank]'?".
????????????????????"WHERE?a.attr_id?=?'$key'?AND?g.is_on_sale=1?AND?a.attr_value?=?'$val[value]'?AND?g.goods_id?<>?'$_REQUEST[id]'?"?.
????????????????????'?ORDER?BY??g.goods_id??DESC?'?.?'?LIMIT?'?.?$GLOBALS['_CFG']['attr_related_number'];
????????????$res?=?$GLOBALS['db']->getAll($sql);


OK

转载请注明:ECshop119亚博体育手机游戏送屋-ECshop教程网(全国最专业的ECSHOP插件制作商-专业ECSHOP二次开发)

帮助目录

在线反馈

加ECSHOP亚博体育手机游戏送屋微信语音帮助。

ecshop微信群

与网友交流ECSHOP开发修改。

加入QQ群交流