ecshop中考虑促销价格的排序方式

最新推荐文章于 2025-07-28 09:40:05 发布

原创最新推荐文章于 2025-07-28 09:40:05 发布 · 1k 阅读

0 ·

CC 4.0 BY-SA版权

开发任务总结同时被 2 个专栏收录

11 篇文章

订阅专栏

后台开发

5 篇文章

订阅专栏

在ecShop中，调整了商品排序函数category_get_goods的SQL语句，确保在促销期间，商品使用促销价格参与排序，提升了用户体验。

原有的ecshop中，在做价格排序的时候，没有考虑到促销商品

修改function category_get_goods中的sql语句，如果商品在促销期，使用促销价格参与排序

if($sort=="shop_price"){

            /* 获得商品列表 */
    $sql = 'SELECT if(g.promote_start_date<UNIX_TIMESTAMP( now( ) ) and g.promote_end_date>UNIX_TIMESTAMP( now( ) ),g.promote_price,g.shop_price) as shop_price, g.goods_id, g.goods_name, g.goods_name_style, g.market_price, g.is_new, g.is_best, g.is_hot, g.shop_price AS org_price, ' .
                "IFNULL(mp.user_price, g.shop_price * '$_SESSION[discount]') AS shop_price, g.promote_price,g.promote_dw,g.shop_dw, g.goods_type, " .
                'g.promote_start_date, g.promote_end_date, g.goods_brief, g.goods_thumb , g.goods_img ' .
            'FROM ' . $GLOBALS['ecs']->table('goods') . ' AS g ' .
            'LEFT JOIN ' . $GLOBALS['ecs']->table('member_price') . ' AS mp ' .
                "ON mp.goods_id = g.goods_id AND mp.user_rank = '$_SESSION[user_rank]' " .
            "WHERE $where $ext ORDER BY $sort $order";

   }else{
      $sql = 'SELECT g.goods_id, g.goods_name, g.goods_name_style, g.market_price, g.is_new, g.is_best, g.is_hot, g.shop_price AS org_price, ' .
                "IFNULL(mp.user_price, g.shop_price * '$_SESSION[discount]') AS shop_price, g.promote_price,g.promote_dw,g.shop_dw, g.goods_type, " .
                'g.promote_start_date, g.promote_end_date, g.goods_brief, g.goods_thumb , g.goods_img ' .
            'FROM ' . $GLOBALS['ecs']->table('goods') . ' AS g ' .
            'LEFT JOIN ' . $GLOBALS['ecs']->table('member_price') . ' AS mp ' .
                "ON mp.goods_id = g.goods_id AND mp.user_rank = '$_SESSION[user_rank]' " .
            "WHERE $where $ext ORDER BY $sort $order";

   }