{"id":59203,"date":"2025-04-23T16:16:58","date_gmt":"2025-04-23T08:16:58","guid":{"rendered":"https:\/\/fwq.ai\/blog\/59203\/"},"modified":"2025-04-23T16:16:58","modified_gmt":"2025-04-23T08:16:58","slug":"%e4%bf%ae%e6%94%b9ecshop%e5%ae%9e%e7%8e%b0%e4%b8%8d%e9%97%b4%e6%96%ad%e6%bb%9a%e5%8a%a8%e7%9a%84%e5%8f%91%e8%b4%a7%e9%80%9a%e7%9f%a5","status":"publish","type":"post","link":"https:\/\/fwq.ai\/blog\/59203\/","title":{"rendered":"\u4fee\u6539ecshop,\u5b9e\u73b0\u4e0d\u95f4\u65ad\u6eda\u52a8\u7684\u53d1\u8d27\u901a\u77e5"},"content":{"rendered":"<p>&nbsp;1\u3001\u6a21\u677f\u7528\u7684\u662f\u7528taobao MALL \uff0c\u4e0d\u77e5\u9053\u662f\u54ea\u4e2a\u5144\u5f1f\u5171\u4eab\u51fa\u6765\u7684\uff01\u6240\u4ee5\u4f7f\u7528\u5176\u4ed6\u6a21\u677f\u7684\u5144\u5f1f\uff0c\u7a0d\u6539\u4e0b\u5c31\u53ef\u4ee5\u4e86\uff0c\u4ee3\u7801\u4e5f\u5f88\u7b80\u5355\u3002<\/p>\n<p>  2\u3001\u6253\u5f00\u6839\u76ee\u5f55\u4e0b\u7684index.php\uff0c\u627e\u5230\uff1a   &nbsp;   &nbsp;&nbsp; &nbsp;$smarty-&gt;assign(&#8216;invoice_list&#8217;, &nbsp; &nbsp;index_get_invoice_query()); &nbsp;\/\/ \u53d1\u8d27\u67e5\u8be2   \u590d\u5236\u4ee3\u7801   &nbsp;   \u5728\u4e0b\u9762\u6dfb\u52a0\u4e00\u884c\uff1a   &nbsp;   &nbsp;&nbsp; &nbsp;$smarty-&gt;assign(&#8216;post_list&#8217;, &nbsp; &nbsp;index_get_post_query()); &nbsp;\/\/ \u53d1\u8d27\u901a\u77e5   \u590d\u5236\u4ee3\u7801   &nbsp;   &nbsp;   \u518d\u627e\u5230\uff1a   &nbsp;   \/*&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212; *\/   \/\/&#8211; PRIVATE FUNCTIONS   \/*&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212; *\/   \u590d\u5236\u4ee3\u7801   &nbsp;   \u5728\u4e0b\u9762\u6dfb\u52a0\u4ee5\u4e0b\u4ee3\u7801\uff1a   \/**   * \u8c03\u7528\u53d1\u8d27\u516c\u544a\u67e5\u8be2   *   * @access private   * @return array   *\/   function index_get_post_query()   {   $sql = &#8216;SELECT order_sn, user_name,action_note FROM &#8216; . $GLOBALS[&#8216;ecs&#8217;]-&gt;table(&#8216;order_info&#8217;) . &#8216; JOIN (&#8216; . $GLOBALS[&#8216;ecs&#8217;]-&gt;table(&#8216;users&#8217;) . &#8216;,&#8217; .&nbsp;   &nbsp;   $GLOBALS[&#8216;ecs&#8217;]-&gt;table(&#8216;order_action&#8217;) . &#8216;) ON (&#8216; . $GLOBALS[&#8216;ecs&#8217;]-&gt;table(&#8216;users&#8217;) . &#8216;.user_id=&#8217; . $GLOBALS[&#8216;ecs&#8217;]-&gt;table(&#8216;order_info&#8217;) . &#8216;.user_id&nbsp;   &nbsp;   AND &#8216; . $GLOBALS[&#8216;ecs&#8217;]-&gt;table(&#8216;order_action&#8217;) . &#8216;.order_id=&#8217; . $GLOBALS[&#8216;ecs&#8217;]-&gt;table(&#8216;order_info&#8217;) . &#8216;.order_id) WHERE &#8216; . $GLOBALS[&#8216;ecs&#8217;]-&gt;table   &nbsp;   (&#8216;order_info&#8217;) . &#8216;.shipping_status = 1 ORDER BY shipping_time DESC LIMIT 10&#8217;;   $postinfo = $GLOBALS[&#8216;db&#8217;]-&gt;getAll($sql);   &nbsp;   clearstatcache();   &nbsp;   return $postinfo;   }   \u590d\u5236\u4ee3\u7801   &nbsp;   &nbsp;   3\u3001\u5728\u4f7f\u7528\u6a21\u677f\u91cc\u9762\u7684library\u76ee\u5f55\u91cc\uff0c\u65b0\u5efa\u4e00\u4e2apost_list.lbi\u7684\u6587\u4ef6\uff0c\u628a\u4ee5\u4e0b\u4ee3\u7801\u590d\u5236\u5230\u8fd9\u4e2a\u6587\u4ef6\u91cc\u9762\u53bb\uff01   &lt;meta http-equiv=&#8221;Content-Type&#8221; content=&#8221;text\/html; charset=gbk&#8221;&gt;   &lt;DIV id=demo style=&#8221;overflow:hidden;height :220px;width :200px;&#8221;&gt;   &lt;DIV id=demo1&gt;&nbsp;   &lt;!&#8211; \u53d1\u8d27\u516c\u544a{foreach from=$post_list item=post} &#8211;&gt;   &lt;font color=red&gt;{$post.user_name}&lt;\/font&gt; \u60a8\u597d\uff0c\u60a8\u6240\u8d2d\u7269\u54c1\u5c06\u4e8e &lt;font color=red&gt;{$post.action_note}   &nbsp;   &lt;\/font&gt; \u53d1\u51fa\uff0c\u6211\u4eec\u9884\u5148\u77ed\u4fe1\u901a\u77e5\u60a8\uff0c\u8bf7\u6ce8\u610f\u67e5\u6536\uff01&lt;br&gt;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&lt;br&gt;   &lt;!&#8211; \u53d1\u8d27\u516c\u544a{\/foreach}&#8211;&gt;   &lt;\/DIV&gt;   &lt;DIV id=demo2&gt;   &lt;\/DIV&gt;   &lt;\/DIV&gt;   &lt;\/DIV&gt;   &lt;SCRIPT&gt;   var speed=100   demo2.innerHTML=demo1.innerHTML   function Marquee(){   if(demo2.offsetTop-demo.scrollTop&lt;=0)   demo.scrollTop-=demo1.offsetHeight   else{   demo.scrollTop++   }   }   var MyMar=setInterval(Marquee,speed)   demo.onmouseover=function(){clearInterval(MyMar)}   demo.onmouseout=function(){MyMar=setInterval(Marquee,speed)}   &lt;\/SCRIPT&gt;   \u590d\u5236\u4ee3\u7801   &nbsp;   &nbsp;   4\u3001\u7136\u540e\u6253\u5f00index.dwt\uff0c\u627e\u5230\uff1a   &lt;div class=&#8221;NewsList tc&#8221;&gt;   \u590d\u5236\u4ee3\u7801   &nbsp;   \u628a\u4e0b\u9762\u7684\u90a3\u6bb5\u4ee3\u7801\u6539\u4e3a\uff1a   &lt;!&#8211; #BeginLibraryItem &#8220;\/library\/post_list.lbi&#8221; &#8211;&gt;&lt;!&#8211; #EndLibraryItem &#8211;&gt;   \u590d\u5236\u4ee3\u7801   &nbsp;   &nbsp;   \u8fd9\u6837\u5c31\u884c\u4e86\uff0c\u5176\u4ed6\u7684\u6a21\u677f\u6839\u636e\u81ea\u5df1\u559c\u6b22\uff0c\u628a\u4e0a\u9762\u90a3\u6bb5\u4ee3\u7801\u653e\u5230\u4f60\u60f3\u8981\u7684\u5730\u65b9\u53bb\uff01 <\/p>\n","protected":false},"excerpt":{"rendered":"<p>&nbsp;1\u3001\u6a21\u677f\u7528\u7684\u662f\u7528taobao MALL \uff0c\u4e0d\u77e5\u9053\u662f\u54ea\u4e2a\u5144\u5f1f\u5171\u4eab\u51fa\u6765\u7684\uff01\u6240\u4ee5\u4f7f\u7528\u5176\u4ed6\u6a21\u677f\u7684\u5144\u5f1f\uff0c\u7a0d\u6539\u4e0b\u5c31\u53ef\u4ee5\u4e86\uff0c\u4ee3\u7801\u4e5f\u5f88\u7b80\u5355\u3002 2\u3001\u6253\u5f00\u6839\u76ee\u5f55\u4e0b\u7684index.php\uff0c\u627e\u5230\uff1a &nbsp; &nbsp;&nbsp; &nbsp;$smarty-&gt;assign(&#8216;invoice_list&#8217;, &nbsp; &nbsp;index_get_invoice_query()); &nbsp;\/\/ \u53d1\u8d27\u67e5\u8be2 \u590d\u5236\u4ee3\u7801 &nbsp; \u5728\u4e0b\u9762\u6dfb\u52a0\u4e00\u884c\uff1a &nbsp; &nbsp;&nbsp; &nbsp;$smarty-&gt;assign(&#8216;post_list&#8217;, &nbsp; &nbsp;index_get_post_query()); &nbsp;\/\/ \u53d1\u8d27\u901a\u77e5 \u590d\u5236\u4ee3\u7801 &nbsp; &nbsp; \u518d\u627e\u5230\uff1a &nbsp; \/*&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212; *\/ \/\/&#8211; PRIVATE FUNCTIONS \/*&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212; *\/ \u590d\u5236\u4ee3\u7801 &nbsp; \u5728\u4e0b\u9762\u6dfb\u52a0\u4ee5\u4e0b\u4ee3\u7801\uff1a \/** * \u8c03\u7528\u53d1\u8d27\u516c\u544a\u67e5\u8be2 * * @access private * @return array *\/ function index_get_post_query() { $sql = &#8216;SELECT order_sn, user_name,action_note [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[16],"tags":[],"class_list":["post-59203","post","type-post","status-publish","format-standard","hentry","category-16"],"_links":{"self":[{"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/posts\/59203","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/comments?post=59203"}],"version-history":[{"count":0,"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/posts\/59203\/revisions"}],"wp:attachment":[{"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/media?parent=59203"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/categories?post=59203"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/tags?post=59203"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}