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

最新推荐文章于 2022-01-02 10:33:32 发布

warran21

最新推荐文章于 2022-01-02 10:33:32 发布

阅读量981

点赞数

分类专栏：开发任务总结后台开发

本文链接：https://blog.csdn.net/warran21/article/details/8241793

版权

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

11 篇文章 0 订阅

订阅专栏

后台开发

5 篇文章 0 订阅

订阅专栏

原有的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";

   }