{"id":59257,"date":"2025-04-23T15:51:50","date_gmt":"2025-04-23T07:51:50","guid":{"rendered":"https:\/\/fwq.ai\/blog\/59257\/"},"modified":"2025-04-23T15:51:50","modified_gmt":"2025-04-23T07:51:50","slug":"%e4%bf%ae%e6%94%b9ecshop%e8%ae%a9%e8%ae%a2%e5%8d%95%e8%af%a6%e6%83%85%e9%87%8c%e5%b0%86%e4%bc%9a%e5%91%98%e5%9c%b0%e5%9d%80%e8%af%a6%e6%83%85%e5%85%a8%e9%83%a8%e6%98%be%e7%a4%ba","status":"publish","type":"post","link":"https:\/\/fwq.ai\/blog\/59257\/","title":{"rendered":"\u4fee\u6539ecshop\u8ba9\u8ba2\u5355\u8be6\u60c5\u91cc\u5c06\u4f1a\u5458\u5730\u5740\u8be6\u60c5\u5168\u90e8\u663e\u793a"},"content":{"rendered":"

\"\u4fee\u6539ecshop\u8ba9\u8ba2\u5355\u8be6\u60c5\u91cc\u5c06\u4f1a\u5458\u5730\u5740\u8be6\u60c5\u5168\u90e8\u663e\u793a\u63d2\u56fe\"<\/p>\n

\"\u4fee\u6539ecshop\u8ba9\u8ba2\u5355\u8be6\u60c5\u91cc\u5c06\u4f1a\u5458\u5730\u5740\u8be6\u60c5\u5168\u90e8\u663e\u793a\u63d2\u56fe\"
\n\"\u4fee\u6539ecshop\u8ba9\u8ba2\u5355\u8be6\u60c5\u91cc\u5c06\u4f1a\u5458\u5730\u5740\u8be6\u60c5\u5168\u90e8\u663e\u793a\u63d2\u56fe\"
\n\"\u4fee\u6539ecshop\u8ba9\u8ba2\u5355\u8be6\u60c5\u91cc\u5c06\u4f1a\u5458\u5730\u5740\u8be6\u60c5\u5168\u90e8\u663e\u793a\u63d2\u56fe1\" <\/p>\n

 <\/p>\n

$sql = “SELECT concat(IFNULL(c.region_name, ”), ‘  ‘, IFNULL(p.region_name, ”), ” .<\/p>\n

                “‘  ‘, IFNULL(t.region_name, ”), ‘  ‘, IFNULL(d.region_name, ”)) AS region ” .<\/p>\n

            “FROM ” . $GLOBALS[‘ecs’]->table(‘order_info’) . ” AS o ” .<\/p>\n

                “LEFT JOIN ” . $GLOBALS[‘ecs’]->table(‘region’) . ” AS c ON o.country = c.region_id ” .<\/p>\n

                “LEFT JOIN ” . $GLOBALS[‘ecs’]->table(‘region’) . ” AS p ON o.province = p.region_id ” .<\/p>\n

                “LEFT JOIN ” . $GLOBALS[‘ecs’]->table(‘region’) . ” AS t ON o.city = t.region_id ” .<\/p>\n

                “LEFT JOIN ” . $GLOBALS[‘ecs’]->table(‘region’) . ” AS d ON o.district = d.region_id ” .<\/p>\n

            “WHERE o.order_id = ‘$order[order_id]'”;<\/p>\n

       $res = $GLOBALS[‘db’]->getRow($sql);<\/p>\n

 <\/p>\n

       $smarty->assign(‘address’,$res[‘region’]);<\/p>\n

\u5728user.php\u4e2d\u7684<\/p>\n

elseif ($action == ‘order_detail’)\u91cc\u9762\u52a0\u4e0a\u4e0a\u9762\u90a3\u53e5\u8bdd<\/p>\n

 <\/p>\n

\u5728user_transaction.dwt\u4e2d\u627e\u5230\u5bf9\u5e94\u7684\u4ee3\u7801\u663e\u793a\u51fa\u6765\u5373\u53ef<\/p>\n

 <\/p>\n

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

  $sql = “SELECT concat(IFNULL(c.region_name, ”), ‘  ‘, IFNULL(p.region_name, ”), ” .                 “‘  ‘, IFNULL(t.region_name, ”), ‘  ‘, IFNULL(d.region_name, ”)) AS region ” .             “FROM ” . $GLOBALS[‘ecs’]->table(‘order_info’) . ” AS o ” .                 “LEFT JOIN ” . $GLOBALS[‘ecs’]->table(‘region’) . ” AS c ON o.country = c.region_id ” .                 “LEFT JOIN ” . $GLOBALS[‘ecs’]->table(‘region’) . ” AS p […]<\/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-59257","post","type-post","status-publish","format-standard","hentry","category-16"],"_links":{"self":[{"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/posts\/59257","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=59257"}],"version-history":[{"count":0,"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/posts\/59257\/revisions"}],"wp:attachment":[{"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/media?parent=59257"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/categories?post=59257"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/tags?post=59257"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}