{"id":60202,"date":"2025-04-24T10:47:22","date_gmt":"2025-04-24T02:47:22","guid":{"rendered":"https:\/\/fwq.ai\/blog\/60202\/"},"modified":"2025-04-24T10:47:22","modified_gmt":"2025-04-24T02:47:22","slug":"ecshop%e6%94%af%e4%bb%98%e5%ae%9d%e8%87%aa%e5%8a%a8%e5%8f%91%e8%b4%a7%e6%8e%a5%e5%8f%a3-2","status":"publish","type":"post","link":"https:\/\/fwq.ai\/blog\/60202\/","title":{"rendered":"ecshop\u652f\u4ed8\u5b9d\u81ea\u52a8\u53d1\u8d27\u63a5\u53e3"},"content":{"rendered":"

 <\/p>\n

\u4e00\u3001   <\/span><\/span>\u5728<\/span>\u6570\u636e\u5e93<\/span>order_info<\/span>\u4e2d\u6dfb\u52a0<\/span>trade_no <\/span>\u5b57\u6bb5<\/span><\/span>
\nSQL<\/span>\u8bed\u53e5<\/span>:   <\/span>ALTER TABLE `ec_order_info` ADD COLUMN `trade_no`  varchar(100) NOT NULL DEFAULT ” AFTER `pay_name`;<\/span><\/font><\/span>
\n <\/span>
\n\u4e8c\u3001<\/font> <\/span>\u4fee\u6539<\/span>includes\/modules\/payment\/alipay.php\u6587\u4ef6<\/span><\/font><\/span>
\n\u67e5\u627e\uff1a<\/span>$order_sn = trim($order_sn);<\/font><\/span>
\n\u4ee3\u7801\u4e4b\u4e0b\u6dfb\u52a0\uff1a<\/span>$trade_no = trim($_GET[‘trade_no’]);<\/span>\/\/<\/span>\u83b7\u53d6\u652f\u4ed8\u5b9d\u4ea4\u6613\u53f7<\/span><\/font><\/span>
\n <\/span>
\n\u67e5\u627e\uff1a<\/span><\/span>
\nif ($_GET[‘trade_status’] == ‘WAIT_SELLER_SEND_GOODS’)<\/font><\/span>
\n        {<\/font><\/span>
\n            \/* \u6539\u53d8\u8ba2\u5355\u72b6\u6001<\/span> *\/<\/font><\/span>
\n            order_paid($order_sn, 2);<\/font><\/span>
\n\u4fee\u6539\uff1a<\/span><\/span>
\nif ($_GET[‘trade_status’] == ‘WAIT_SELLER_SEND_GOODS’)<\/font><\/span>
\n        {<\/font><\/span>
\n            \/* \u6539\u53d8\u8ba2\u5355\u72b6\u6001<\/span> *\/<\/font><\/span>
\n            order_paid($order_sn, 2,”,$trade_no<\/span>);<\/font><\/span>
\n <\/span>
\n\u4e09\u3001<\/font> <\/span>\u4fee\u6539<\/span>includes\/lib_payment.php\u6587\u4ef6<\/span>\u539f\u6587\u4ef6<\/span>118\u884c\u5f00\u59cb<\/span><\/font><\/span>
\n\/**<\/font><\/span>
\n * \u4fee\u6539\u8ba2\u5355\u7684\u652f\u4ed8\u72b6\u6001<\/span><\/font><\/span>
\n *<\/font><\/span>
\n * @access public<\/font><\/span>
\n * @param   string $log_id     \u652f\u4ed8\u7f16\u53f7<\/span><\/font><\/span>
\n * @param   integer $pay_status \u72b6\u6001<\/span><\/font><\/span>
\n * @param   string $note       \u5907\u6ce8<\/span><\/font><\/span>
\n * @param   string $trade_no   <\/span>\u652f\u4ed8\u5b9d\u4ea4\u6613\u53f7<\/span><\/font><\/span>
\n * @return void<\/font><\/span>
\n *\/<\/font><\/span>
\nfunction order_paid($log_id, $pay_status = PS_PAYED, $note = ”,$trade_no = ”<\/span>)<\/font><\/span>
\n{<\/font><\/span>
\n    \/* \u53d6\u5f97\u652f\u4ed8\u7f16\u53f7<\/span> *\/<\/font><\/span>
\n    $log_id = intval($log_id);<\/font><\/span>
\n    if ($log_id > 0)<\/font><\/span>
\n    {<\/font><\/span>
\n        \/* \u53d6\u5f97\u8981\u4fee\u6539\u7684\u652f\u4ed8\u8bb0\u5f55\u4fe1\u606f<\/span> *\/<\/font><\/span>
\n        $sql = “SELECT * FROM ” . $GLOBALS[‘ecs’]->table(‘pay_log’) .<\/font><\/span>
\n                ” WHERE log_id = ‘$log_id'”;<\/font><\/span>
\n        $pay_log = $GLOBALS[‘db’]->getRow($sql);<\/font><\/span>
\n        if ($pay_log && $pay_log[‘is_paid’] == 0)<\/font><\/span>
\n        {<\/font><\/span>
\n            \/* \u4fee\u6539\u6b64\u6b21\u652f\u4ed8\u64cd\u4f5c\u7684\u72b6\u6001\u4e3a\u5df2\u4ed8\u6b3e<\/span> *\/<\/font><\/span>
\n            $sql = ‘UPDATE ‘ . $GLOBALS[‘ecs’]->table(‘pay_log’) .<\/font><\/span>
\n                    ” SET is_paid = ‘1’ WHERE log_id = ‘$log_id'”;<\/font><\/span>
\n            $GLOBALS[‘db’]->query($sql);<\/font><\/span>
\n <\/span>
\n            \/* \u6839\u636e\u8bb0\u5f55\u7c7b\u578b\u505a\u76f8\u5e94\u5904\u7406<\/span> *\/<\/font><\/span>
\n            if ($pay_log[‘order_type’] == PAY_ORDER)<\/font><\/span>
\n            {<\/font><\/span>
\n                \/* \u53d6\u5f97\u8ba2\u5355\u4fe1\u606f<\/span> *\/<\/font><\/span>
\n                             $sql = ‘SELECT order_id, user_id, order_sn, trade_no, <\/span>consignee, address, tel, shipping_id, extension_code, extension_id, goods_amount ‘ .<\/font><\/span>
\n                        ‘FROM ‘ . $GLOBALS[‘ecs’]->table(‘order_info’) .<\/font><\/span>
\n                       ” WHERE order_id = ‘$pay_log[order_id]'”;<\/font><\/span>
\n                $order    = $GLOBALS[‘db’]->getRow($sql);<\/font><\/span>
\n                $order_id = $order[‘order_id’];<\/font><\/span>
\n                $order_sn = $order[‘order_sn’];<\/font><\/span><\/span>
\n                             \/*<\/span>\u89e3\u51b3\u8ba2\u5355\u4fee\u6539\u540e\u591a\u6b21\u4ed8\u6b3e\u53d1\u8d27\u786e\u8ba4<\/span>*\/<\/span><\/font><\/span>
\n                             $trade    = $order[‘trade_no’];<\/font><\/span><\/span>
\n                             if (!empty($trade))<\/font><\/span><\/span>
\n                             {<\/font><\/span><\/span>
\n                                       $trade_no = $trade.”,”.$trade_no;<\/font><\/span><\/span>
\n                             }<\/font><\/span><\/span>
\n                \/* \u4fee\u6539\u8ba2\u5355\u72b6\u6001\u4e3a\u5df2\u4ed8\u6b3e<\/span> *\/<\/font><\/span>
\n                $sql = ‘UPDATE ‘ . $GLOBALS[‘ecs’]->table(‘order_info’) .<\/font><\/span>
\n                            ” SET order_status = ‘” . OS_CONFIRMED . “‘, ” .<\/font><\/span>
\n                                ” confirm_time = ‘” . gmtime() . “‘, ” .<\/font><\/span>
\n                                ” pay_status = ‘$pay_status’, ” .<\/font><\/span>
\n                                                                   ” pay_time = ‘”.gmtime().”‘, ” .<\/font><\/span>
\n                                ” money_paid = order_amount,” .<\/font><\/span>
\n                                                                   ” trade_no = ‘$trade_no’,”.<\/span>\/\/<\/span>\u66f4\u65b0\u652f\u4ed8\u5b9d\u4ea4\u6613\u53f7<\/span><\/font><\/span>
\n                                ” order_amount = 0 “.<\/font><\/span>
\n                       “WHERE order_id = ‘$order_id'”;<\/font><\/span>
\n                $GLOBALS[‘db’]->query($sql);<\/font><\/span>
\n <\/span>
\n <\/span>
\n <\/span>
\n\u56db\u3001<\/font> <\/span>\u4fee\u6539<\/span>admin\/order.php\u6587\u4ef6<\/span><\/font><\/span>
\n\u67e5\u627e\uff1a<\/span><\/span>
\n     $smarty->assign(‘action_list’, $act_list);<\/font><\/span>
\n <\/span>
\n    \/* \u6a21\u677f\u8d4b\u503c<\/span> *\/<\/font><\/span>
\n    $smarty->assign(‘delivery_order’, $delivery_order);<\/font><\/span>
\n    $smarty->assign(‘goods_list’, $goods_list);<\/font><\/span>
\n$smarty->assign(‘delivery_id’, $delivery_id); \/\/ \u53d1\u8d27\u5355<\/span>id<\/font><\/span>
\n <\/span>
\n\u4ee3\u7801\u4e4b\u4e0a<\/span>\u6dfb\u52a0\uff1a<\/span><\/span>
\n    \/*<\/span>\u5224\u65ad\u652f\u4ed8\u65b9\u5f0f\u662f\u5426\u652f\u4ed8\u5b9d<\/span>*\/<\/span><\/font><\/span>
\n    $alipay    = false;<\/font><\/span><\/span>
\n    $order     = order_info($delivery_order[‘order_id’]); <\/span>\/\/<\/span>\u6839\u636e\u8ba2\u5355<\/span>ID<\/span>\u67e5\u8be2\u8ba2\u5355\u4fe1\u606f\uff0c\u8fd4\u56de\u6570\u7ec4<\/span>$order<\/span><\/font><\/span>
\n    $payment   = payment_info($order[‘pay_id’]);        <\/span>\/\/<\/span>\u53d6\u5f97\u652f\u4ed8\u65b9\u5f0f\u4fe1\u606f<\/span><\/font><\/span>
\n    if($payment[‘pay_code’] == “alipay” && $delivery_order[‘status’] == 2 && !empty($order[‘trade_no’]))      <\/font><\/span><\/span>
\n    {<\/font><\/span><\/span>
\n        $alipay    = true;   <\/font><\/span><\/span>
\n    }<\/font><\/span><\/span>
\n    $smarty->assign(‘alipay’, $alipay);<\/font><\/span><\/span>
\n <\/span>
\n <\/span>
\n\u4e94\u3001<\/font> <\/span>\u4fee\u6539<\/span>admin\\templates\\delivery_info.htm\u6587\u4ef6<\/span><\/font><\/span>
\n <\/span>
\n\u67e5\u627e\uff1a<\/span> <form action=”order.php” method=”post” name=”theForm”><\/font><\/span>
\n\u66ff\u6362\uff1a<\/span><form {if $alipay}onSubmit=”this.target=’_blank’;this.action=’alipay_delivery.php’;<\/font><\/span>
\n this.submit();this.target=’_self’;this.action=’order.php'”{else}action=”order.php”{\/if} method=”post” name=”theForm”><\/font><\/span>
\n <\/span>
\n\u516d\u3001<\/font> <\/span>\u4e0a\u4f20<\/span>alipay_delivery.php\u6587\u4ef6\u5230<\/span>admin \u76ee\u5f55\u4e0b<\/span><\/font><\/span> <\/p>\n

alipay_delivery.php\u6587\u4ef6  <\/span><\/font><\/p>\n

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

  \u4e00\u3001   \u5728\u6570\u636e\u5e93order_info\u4e2d\u6dfb\u52a0trade_no \u5b57\u6bb5 SQL\u8bed\u53e5:   ALTER TABLE `ec_order_info` ADD COLUMN `trade_no`  varchar(100) NOT NULL DEFAULT ” AFTER `pay_name`;   \u4e8c\u3001 \u4fee\u6539includes\/modules\/payment\/alipay.php\u6587\u4ef6 \u67e5\u627e\uff1a$order_sn = trim($order_sn); \u4ee3\u7801\u4e4b\u4e0b\u6dfb\u52a0\uff1a$trade_no = trim($_GET[‘trade_no’]);\/\/\u83b7\u53d6\u652f\u4ed8\u5b9d\u4ea4\u6613\u53f7   \u67e5\u627e\uff1a if ($_GET[‘trade_status’] == ‘WAIT_SELLER_SEND_GOODS’)         {             \/* \u6539\u53d8\u8ba2\u5355\u72b6\u6001 *\/             order_paid($order_sn, 2); \u4fee\u6539\uff1a if ($_GET[‘trade_status’] == ‘WAIT_SELLER_SEND_GOODS’)         {             \/* \u6539\u53d8\u8ba2\u5355\u72b6\u6001 *\/             order_paid($order_sn, 2,”,$trade_no);   \u4e09\u3001 \u4fee\u6539includes\/lib_payment.php\u6587\u4ef6\u539f\u6587\u4ef6118\u884c\u5f00\u59cb \/**  * \u4fee\u6539\u8ba2\u5355\u7684\u652f\u4ed8\u72b6\u6001  *  * @access public  * […]<\/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-60202","post","type-post","status-publish","format-standard","hentry","category-16"],"_links":{"self":[{"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/posts\/60202","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=60202"}],"version-history":[{"count":0,"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/posts\/60202\/revisions"}],"wp:attachment":[{"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/media?parent=60202"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/categories?post=60202"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/tags?post=60202"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}