ECShop 增加收藏商品排行榜功能

最新推荐文章于 2017-04-03 16:06:16 发布

weixin_33805992

最新推荐文章于 2017-04-03 16:06:16 发布

阅读量211

点赞数

文章标签： php

关于这个函数的说明：
这个函数可以放在 /includes/lib_goods.php 或
/includes/lib_main.php 文件中，本人更喜欢放在前者。

关于这个函数的默认值：
时间：三个月（收藏商品统计时间）；
获取数据的条数：5条；
如果这两个在后台修改的话，可自行在

ECShop 后台 ‘商店设置’ =》 ‘显示设置’中添加这个两选项。

/**
*
收藏商品排行榜
* @author Seven2
* @license
* @version v.10
*
@since   2010-08-19
* @access public
*
@return array
*/

function get_collect_goods()
{

    switch
($GLOBALS['_CFG']['collect_time'])
    {
        case 1: // 一年

    $base_where = '`c`.`add_time` >= "' . (gmtime() - 365 * 86400) . '"
';
            break;

        case 2: // 半年
            $base_where
= '`c`.`add_time` >= "' . (gmtime() - 180 * 86400) . '" ';

break;

        case 3: // 三个月
            $base_where =
'`c`.`add_time` >= "' . (gmtime() - 90 * 86400) . '" ';

break;

        case 4: // 一个月
            $base_where =
'`c`.`add_time` >= "' . (gmtime() - 30 * 86400) . '" ';

break;

        default:
            $base_where = '`c`.`add_time`
>= "' . (gmtime() - 90 * 86400) . '" ';
    }

    $row       =
array();
    $arr       = array();
    $limit_num =
isset($GLOBALS['_CFG']['collect_number']) ? (int)
$GLOBALS['_CFG']['collect_number'] : 5;
    $sql = 'SELECT `c`.`goods_id`,
COUNT(`c`.`goods_id`) AS `total`, `g`.`cat_id`, ' .

   '`g`.`goods_name`, `g`.`shop_price`, `g`.`goods_thumb` FROM ' .

   $GLOBALS['ecs']->table('collect_goods') . ' AS `c` LEFT JOIN ' .

      $GLOBALS['ecs']->table('goods') . ' AS `g` ON `c`.`goods_id` =
`g`.`goods_id` ' .
           'WHERE ' . $base_where . 'AND `g`.`is_on_sale`
= "1" AND ' .
           '`g`.`is_alone_sale` = "1" AND `g`.`is_delete` = "0"
GROUP BY `c`.`goods_id` ' .
           'ORDER BY `total` DESC LIMIT '
. $limit_num;

    $res = $GLOBALS['db']->query($sql);
    while
($row = $GLOBALS['db']->fetchRow($res))
    {

   $arr[$row['goods_id']]['goods_id']          = $row['goods_id'];

   $arr[$row['goods_id']]['total']             = $row['total'];

   $arr[$row['goods_id']]['goods_name']        = $row['goods_name'];

   $arr[$row['goods_id']]['shop_price']        = $row['shop_price'];

   $arr[$row['goods_id']]['format_shop_price'] =
price_format($row['shop_price']);

   $arr[$row['goods_id']]['goods_thumb']       = $row['goods_thumb'];

   $arr[$row['goods_id']]['url']               = build_uri('goods', array('gid'
=> $row['goods_id']), $row['goods_name']);
    }

    return
$arr;
}