\u5728Ecshop\u9996\u9875\u5546\u54c1\u548c\u5546\u54c1\u5206\u7c7b\u9875\u663e\u793a\u5546\u54c1\u5df2\u9500\u552e\u6570\u91cf\u7684\u65b9\u6cd5\u3002<\/p>\n
ecshop\u9996\u9875\uff1a<\/p>\n
\u8fd9\u4e2a\u9700\u8981\u4fee\u6539\u4e00\u4e2a\u7a0b\u5e8f\u6587\u4ef6 lib_goods.php
\u5b9e\u73b0\u5728\u6587\u4ef6\u672b\u5c3e\u6dfb\u52a0\u4e00\u4e2a\u51fd\u6570<\/p>\n
function get_buy_sum($goods_id)
{
$sql = “select sum(goods_number) from ” . $GLOBALS[‘ecs’]->table(‘order_goods’) . ” AS g ,”.$GLOBALS[‘ecs’]->table(‘order_info’) . ” AS o WHERE o.order_id=g.order_id and g.goods_id = ” . $goods_id . ” and o.order_status=1 ” ;\/\/o.order_status=1 \u8868\u793a\u786e\u8ba4\u4e86\u7684\u8ba2\u5355\u624d\u7b97
return $GLOBALS[‘db’]->getOne($sql);
}<\/p>\n
\u7136\u540e\u627e\u5230 \u5728get_recommend_goods\u51fd\u6570\u4e2d \u5927\u81f4325\u884c<\/p>\n
$goods[$idx][‘url’] = build_uri(‘goods’, array(‘gid’ => $row[‘goods_id’]), $row[‘goods_name’]);<\/p>\n
\u5176\u540e\u6dfb\u52a0<\/p>\n
$goods[$idx][‘buy_num’] = get_buy_sum($row[‘goods_id’]);<\/p>\n
\u5269\u4e0b\u7684\u5c31\u662f\u901a\u8fc7\u5728\u6a21\u677f\u4e2d\u7528
{if $goods.buy_num}
{$goods.buy_num}
{else}
0
{\/if}
\u8c03\u7528\u4e86 <\/p>\n
ECSHOP\u5546\u54c1\u5206\u7c7b\u9875\uff1a<\/p>\n
\u4fee\u6539 category.php \u6587\u4ef6
\u5728
$arr[$row[‘goods_id’]][‘goods_id’] = $row[‘goods_id’];
\u4e0b\u589e\u52a0
$sql=”selectNULL(goods_number),0) from “. $GLOBALS[‘ecs’]->table(‘order_goods’) . ” AS og , “. $GLOBALS[‘ecs’]->table(‘order_info’) .” AS o where o.order_id =og.order_id and o.order_status >0 and og.goods_id=”.$row[‘goods_id’];
$arr[$row[‘goods_id’]][‘count_sell’]=$GLOBALS[‘db’]->getOne($sql);<\/p>\n
\u7136\u540e\u4fee\u6539 library\/goods_list.lbi
\u5728\u4f60\u60f3\u663e\u793a\u8d2d\u4e70\u6570\u91cf\u7684\u5730\u65b9\u52a0\u5165\u4e0b\u9762\u4ee3\u7801\uff1a
\u9500\u552e\u6570\u91cf\uff1a{$goods.count_sell}
<\/p>\n","protected":false},"excerpt":{"rendered":"
\u5728Ecshop\u9996\u9875\u5546\u54c1\u548c\u5546\u54c1\u5206\u7c7b...<\/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-199502","post","type-post","status-publish","format-standard","hentry","category-4925"],"_links":{"self":[{"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/posts\/199502","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=199502"}],"version-history":[{"count":0,"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/posts\/199502\/revisions"}],"wp:attachment":[{"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/media?parent=199502"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/categories?post=199502"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/tags?post=199502"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}