category.php<\/p>\n
\u6dfb\u52a0\u51fd\u6570\uff1a<\/p>\n
<\/p>\n
\/**
* \u8c03\u7528\u4ea7\u54c1\u5206\u7c7b\u7684\u9500\u552e\u6392\u884c\u699c
*
* @access public
* @param string $cats \u67e5\u8be2\u7684\u5206\u7c7b
* @return array
*\/
function get_pro_top10($cats = ‘1’)
{
$where = !empty($cats) ? “AND (g.cat_id = $cats OR ” . get_extension_goods($cats) . “) ” : ”;
\/* \u6392\u884c\u7edf\u8ba1\u7684\u65f6\u95f4 *\/
switch ($GLOBALS[‘_CFG’][‘top10_time’])
{
case 1: \/\/ \u4e00\u5e74
$top10_time = “AND o.order_sn >= ‘” . date(‘Ymd’, gmtime() – 365 * 86400) . “‘”;
break;
case 2: \/\/ \u534a\u5e74
$top10_time = “AND o.order_sn >= ‘” . date(‘Ymd’, gmtime() – 180 * 86400) . “‘”;
break;
case 3: \/\/ \u4e09\u4e2a\u6708
$top10_time = “AND o.order_sn >= ‘” . date(‘Ymd’, gmtime() – 90 * 86400) . “‘”;
break;
case 4: \/\/ \u4e00\u4e2a\u6708
$top10_time = “AND o.order_sn >= ‘” . date(‘Ymd’, gmtime() – 30 * 86400) . “‘”;
break;
default:
$top10_time = ”;
}
$sql = ‘SELECT g.goods_id, g.goods_name, g.shop_price, g.goods_thumb, SUM(og.goods_number) as goods_number ‘ .
‘FROM ‘ . $GLOBALS[‘ecs’]->table(‘goods’) . ‘ AS g, ‘ .
$GLOBALS[‘ecs’]->table(‘order_info’) . ‘ AS o, ‘ .
$GLOBALS[‘ecs’]->table(‘order_goods’) . ‘ AS og ‘ .
“WHERE g.is_on_sale = 1 AND g.is_alone_sale = 1 AND g.is_delete = 0 $where $top10_time ” ;
\/\/\u5224\u65ad\u662f\u5426\u542f\u7528\u5e93\u5b58\uff0c\u5e93\u5b58\u6570\u91cf\u662f\u5426\u5927\u4e8e0
if ($GLOBALS[‘_CFG’][‘use_storage’] == 1)
{
$sql .= ” AND g.goods_number > 0 “;
}
$sql .= ‘ AND og.order_id = o.order_id AND og.goods_id = g.goods_id ‘ .
“AND o.order_status = ‘” . OS_CONFIRMED . “‘ ” .
“AND (o.pay_status = ‘” . PS_PAYED . “‘ OR o.pay_status = ‘” . PS_PAYING . “‘) ” .
“AND (o.shipping_status = ‘” . SS_SHIPPED . “‘ OR o.shipping_status = ‘” . SS_RECEIVED . “‘) ” .
‘GROUP BY g.goods_id ORDER BY goods_number DESC, g.goods_id DESC LIMIT ‘ . $GLOBALS[‘_CFG’][‘top_number’];
$arr = $GLOBALS[‘db’]->getAll($sql);
for ($i = 0, $count = count($arr); $i < $count; $i++)
{
$arr[$i][‘short_name’] = $GLOBALS[‘_CFG’][‘goods_name_length’] > 0 ?
sub_str($arr[$i][‘goods_name’], $GLOBALS[‘_CFG’][‘goods_name_length’]) : $arr[$i][‘goods_name’];
$arr[$i][‘url’] = build_uri(‘goods’, array(‘gid’ => $arr[$i][‘goods_id’]), $arr[$i][‘goods_name’]);
$arr[$i][‘thumb’] = get_image_path($arr[$i][‘goods_id’], $arr[$i][‘goods_thumb’],true);
$arr[$i][‘price’] = price_format($arr[$i][‘shop_price’]);
}
return $arr;
}<\/p>\n
<\/p>\n
\u67e5\u627e<\/p>\n
<\/p>\n
$smarty->assign(‘top_goods’, get_top10()); \/\/ \u9500\u552e\u6392\u884c<\/p>\n
<\/p>\n
\u4e0b\u9762
\u589e\u52a0\uff1a
$smarty->assign(‘get_pro_top’, get_pro_top10($cat_id)); \/\/ \u9500\u552e\u6392\u884c<\/p>\n
\u6a21\u677f\u8c03\u7528\uff1a
\u9ed8\u8ba4\u6a21\u677f<\/p>\n
<\/p>\n
<div class=”box”>
<div class=”box_2″>
<div class=”top10Tit”><\/div>
<div class=”top10List clearfix”>
<!– {foreach name=top_goods from=$get_pro_top item=goods}–>
<ul class=”clearfix”>
<img src=”..\/images\/top_{$smarty.foreach.top_goods.iteration}.gif” class=”iteration” \/>
<!– {if $smarty.foreach.top_goods.iteration<4}–>
<li class=”topimg”>
<a href=”{$goods.url}”><img src=”{$goods.thumb}” alt=”{$goods.name|escape:html}” class=”samllimg” \/><\/a>
<\/li>
<!– {\/if} –>
<li {if $smarty.foreach.top_goods.iteration<4}class=”iteration1″{\/if}>
<a href=”{$goods.url}” title=”{$goods.name|escape:html}”>{$goods.short_name}<\/a><br \/>
{$lang.shop_price}<font class=”f1″>{$goods.price}<\/font><br \/>
<\/li>
<\/ul>
<!– {\/foreach} –>
<\/div>
<\/div>
<\/div>
<div class=”blank5″><\/div><\/p>\n","protected":false},"excerpt":{"rendered":"
category.php \u6dfb\u52a0\u51fd...<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4925],"tags":[],"class_list":["post-199092","post","type-post","status-publish","format-standard","hentry","category-4925"],"_links":{"self":[{"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/posts\/199092","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/comments?post=199092"}],"version-history":[{"count":0,"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/posts\/199092\/revisions"}],"wp:attachment":[{"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/media?parent=199092"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/categories?post=199092"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/tags?post=199092"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}