{"id":199381,"date":"2025-05-03T13:06:46","date_gmt":"2025-05-03T05:06:46","guid":{"rendered":"https:\/\/server.hk\/cnblog\/199381\/"},"modified":"2025-05-03T13:06:46","modified_gmt":"2025-05-03T05:06:46","slug":"%e5%a2%9e%e5%8a%a0ecshop%e8%ae%a2%e5%8d%95%e6%89%93%e5%8d%b0%e9%a1%b5%e6%98%be%e7%a4%ba%e5%95%86%e5%93%81%e7%bc%a9%e7%95%a5%e5%9b%be","status":"publish","type":"post","link":"https:\/\/server.hk\/cnblog\/199381\/","title":{"rendered":"\u589e\u52a0ecshop\u8ba2\u5355\u6253\u5370\u9875\u663e\u793a\u5546\u54c1\u7f29\u7565\u56fe"},"content":{"rendered":"

ecshop\u540e\u53f0\u6253\u5370\u8ba2\u5355\u7684\u65f6\u5019\uff0c\u6253\u5370\u8ba2\u5355\u9875\u663e\u793a\u5546\u54c1\u7684\u7f29\u7565\u56fe\uff0c\u8fd9\u6837\u5546\u54c1\u5c31\u66f4\u52a0\u4e00\u76ee\u4e86\u7136\u4e86\u3002<\/p>\n

\u9996\u5148\uff0c\u6253\u5f00admin\/order.php <\/p>\n

 <\/p>\n

$sql = “SELECT o.*, IF(o.product_id > 0, p.product_number, g.goods_number) AS storage, o.goods_attr, g.suppliers_id, IFNULL(b.brand_name, ”)   <\/p>\n

\u6dfb\u52a0\u4e00\u4e2a\u5b57\u6bb5 g.goods_thumb<\/p>\n

\u4fee\u6539\u4e3a<\/p>\n

 $sql = “SELECT o.*, IF(o.product_id > 0, p.product_number, g.goods_number) AS storage,g.goods_thumb, o.goods_attr, g.suppliers_id, IFNULL(b.brand_name, ”)<\/p>\n

 <\/p>\n

\u5982\u56fe\u6240\u793a\uff0c\u7ed3\u679c\u662f<\/p>\n

<\/p>\n

 <\/p>\n

 <\/p>\n

\u7136\u540e\u6253\u5f00\u8ba2\u5355\u6a21\u677f\u6587\u4ef6\uff0cdata\/order_print.html \u8fd9\u4e2a\u6587\u4ef6 <\/p>\n

 <\/p>\n

\u641c\u7d22 <td>&nbsp;{$goods.goods_name}<!– \u5546\u54c1\u540d\u79f0 –>  \u7136\u540e\u4e0b\u9762\u6dfb\u52a0<\/p>\n

 <\/p>\n

<img src=”..\/{$goods.goods_thumb}” width=”50″ height=”50″ align=”middle”><\/p>\n

 <\/p>\n

\u8fd9\u6837\u8ba2\u5355\u9884\u89c8\uff0c\u4f60\u5c31\u53ef\u4ee5\u770b\u5230\u5546\u54c1\u7684\u7f29\u7565\u56fe\u4e86\u3002<\/p>\n

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

ecshop\u540e\u53f0\u6253\u5370\u8ba2\u5355\u7684\u65f6\u5019\uff0c...<\/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-199381","post","type-post","status-publish","format-standard","hentry","category-4925"],"_links":{"self":[{"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/posts\/199381","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=199381"}],"version-history":[{"count":0,"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/posts\/199381\/revisions"}],"wp:attachment":[{"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/media?parent=199381"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/categories?post=199381"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/tags?post=199381"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}