{"id":199017,"date":"2025-05-03T10:14:18","date_gmt":"2025-05-03T02:14:18","guid":{"rendered":"https:\/\/server.hk\/cnblog\/199017\/"},"modified":"2025-05-03T10:14:18","modified_gmt":"2025-05-03T02:14:18","slug":"%e5%9c%a8ecshop%e9%a6%96%e9%a1%b5%e6%af%8f%e4%b8%aa%e5%95%86%e5%93%81%e4%b8%8b%e6%98%be%e7%a4%ba%e5%b7%b2%e9%94%80%e5%94%ae%e9%87%8f","status":"publish","type":"post","link":"https:\/\/server.hk\/cnblog\/199017\/","title":{"rendered":"\u5728ECSHOP\u9996\u9875\u6bcf\u4e2a\u5546\u54c1\u4e0b\u663e\u793a\u5df2\u9500\u552e\u91cf"},"content":{"rendered":"

\u95ee\u9898\uff1a\u60f3\u5728\u9996\u9875\u6bcf\u4e2a\u5546\u54c1\u4e0b\u663e\u793a\u201c\u5df2\u9500\u552eXX\u4e2a\u201d\uff0c\u8be5\u5982\u4f55\u64cd\u4f5c\u5462\uff1f<\/p>\n

\u6559\u7a0b\uff1a
\u7b2c1\u6b65\uff1a\u6253\u5f00\u6587\u4ef6  includes\/lib_goods.php
\u5728\u8be5\u6587\u4ef6\u7684\u672b\u5c3e\u6dfb\u52a0\u5982\u4e0b\u4ee3\u7801\u7247\u6bb5 <\/p>\n\n\n\n
function get_buy_sum($goods_id)<\/span> <\/p>\n

{<\/p>\n

$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<\/p>\n

    return $GLOBALS[‘db’]->getOne($sql);<\/p>\n

}<\/p>\n

<\/font><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\u7136\u540e\u5f80\u4e0a\u627e\u5230317\u884c\u5de6\u53f3\uff0c \u627e\u5230 <\/p>\n\n\n\n
$goods[$idx][‘brand_name’]   = isset($goods_data[‘brand’][$row[‘goods_id’]]) ? $goods_data[‘brand’][$row[‘goods_id’]] : ”;<\/font><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\u5728\u5b83\u4e0b\u9762\u6dfb\u52a0 <\/p>\n\n\n\n
$goods[$idx][‘buy_num’]= get_buy_sum($row[‘goods_id’]);<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\u6700\u540e\u5c31\u662f\u901a\u8fc7\u5728\u6a21\u677f\u6587\u4ef6\u4e2d\u8c03\u7528\u4e86\uff0c\u5982\u4e0b\u8fd9\u822c\u8c03\u7528 <\/p>\n\n\n\n
{if $goods.buy_num}
{$goods.buy_num}
{else}
0
{\/if}<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

  <\/p>\n","protected":false},"excerpt":{"rendered":"

\u95ee\u9898\uff1a\u60f3\u5728\u9996\u9875\u6bcf\u4e2a\u5546\u54c1\u4e0b\u663e\u793a\u201c\u5df2...<\/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-199017","post","type-post","status-publish","format-standard","hentry","category-4925"],"_links":{"self":[{"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/posts\/199017","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=199017"}],"version-history":[{"count":0,"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/posts\/199017\/revisions"}],"wp:attachment":[{"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/media?parent=199017"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/categories?post=199017"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/tags?post=199017"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}