{"id":59513,"date":"2025-04-23T16:09:40","date_gmt":"2025-04-23T08:09:40","guid":{"rendered":"https:\/\/fwq.ai\/blog\/59513\/"},"modified":"2025-04-23T16:09:40","modified_gmt":"2025-04-23T08:09:40","slug":"%e7%bb%99ecshop%e8%ae%a2%e5%8d%95%e6%b5%81%e7%a8%8b%e5%a2%9e%e5%8a%a0%e6%8b%a3%e8%b4%a7%e7%8a%b6%e6%80%81","status":"publish","type":"post","link":"https:\/\/fwq.ai\/blog\/59513\/","title":{"rendered":"\u7ed9ecshop\u8ba2\u5355\u6d41\u7a0b\u589e\u52a0\u62e3\u8d27\u72b6\u6001"},"content":{"rendered":"

\u9488\u5bf9ecshop\u8ba2\u5355\u4e2d\u7684\u7269\u54c1\uff0c\u9700\u8981\u652f\u6301\u62e3\u8d27\u7684\u72b6\u6001\uff0c\u6bd4\u5982\u672a\u62e3\u8d27\u3001\u62e3\u8d27\u4e2d\u3001\u62e3\u8d27\u5b8c\u6210\uff0c\u4ee5\u53ca\u663e\u793a\u62e3\u8d27\u4eba\u59d3\u540d\u3002<\/p>\n

\r\n-- ----------------------------<\/span>\r\n-- Table structure for `order_picking_status`<\/span>\r\n-- ----------------------------<\/span>\r\nDROP<\/span> TABLE<\/span> IF EXISTS<\/span> `order_picking_status`<\/span>;<\/span>\r\nCREATE<\/span> TABLE<\/span> `order_picking_status`<\/span> (\r\n  `order_id`<\/span> mediumint(8<\/span>) NOTNULL,\r\n  `user_name`<\/span> varchar<\/span>(60<\/span>)DEFAULT<\/span> NULL<\/span>,\r\n  `order_picking_status`<\/span>smallint<\/span>(5<\/span>) NOT<\/span> NULL<\/span> DEFAULT<\/span> '0'<\/span>,\r\n  PRIMARY<\/span> KEY<\/span> (`order_id`<\/span>)\r\n) ENGINE=InnoDB DEFAULT<\/span> CHARSET=gbk;<\/span><\/pre>\n
 \u30102\u3011\u5728\u6587\u4ef6languages\\zh_cn\\admin\\order.php\u4e2d\u589e\u52a0\uff1a<\/p>\n
\r\n\/* \u62e3\u8d27 *\/<\/span>\r\n$_LANG<\/span>['order_picking_status'<\/span>] = '\u62e3\u8d27\u72b6\u6001'<\/span>;\r\n$_LANG<\/span>['order_picking_status_none'<\/span>] = '\u672a\u62e3\u8d27'<\/span>;\r\n$_LANG<\/span>['order_picking_status_processing'<\/span>] = '\u62e3\u8d27\u4e2d'<\/span>;\r\n$_LANG<\/span>['order_picking_status_finish'<\/span>] = '\u62e3\u8d27\u5b8c\u6210'<\/span>;\r\n$_LANG<\/span>['invalid_order_picking_status'<\/span>] = '\u62e3\u8d27\u72b6\u6001\u65e0\u6548\u30020\uff1a\u672a\u62e3\u8d27\uff1b1\uff1a\u62e3\u8d27\u4e2d\uff1b2\uff1a\u62e3\u8d27\u5b8c\u6210'<\/span>;<\/pre>\n
 \u30103\u3011\u6587\u4ef6admin\\templates\\order_list.htm\u4e2d\u5728\u4e00\u4e0b\u4e24\u884c\u4e4b\u95f4\uff1a<\/p>\n
\r\n<th<\/span>><\/span>{$lang.all_status}<\/th<\/span>><\/span>\r\n   <th<\/span>><\/span>{$lang.handler}<\/th<\/span>><\/span><\/pre>\n
\r\n<th<\/span>><\/span>{$lang.order_picking_status}<\/th<\/span>><\/span><\/pre>\n
\r\n<td<\/span> align<\/span>=\"center\"<\/span> valign<\/span>=\"top\"<\/span> nowrap<\/span>=\"nowrap\"<\/span>><\/span>{$lang.os[$order.order_status]},{$lang.ps[$order.pay_status]},{$lang.ss[$order.shipping_status]}<\/td<\/span>><\/span><\/pre>\n
\r\n<td<\/span> align<\/span>=\"right\"<\/span> valign<\/span>=\"top\"<\/span>nowrap<\/span>=\"nowrap\"<\/span>><\/span><span<\/span> onclick<\/span>=\"listTable.edit(this,'edit_order_picking_status', {$order.order_id})\"<\/span>><\/span>{$order.user_name}\u3010{if $order.order_picking_status == 1}{$lang.order_picking_status_processing}{elseif $order.order_picking_status ==2} {$lang.order_picking_status_finish} {else}{$lang.order_picking_status_none}{\/if}\r\n     \u3011<\/span<\/span>><\/span><\/td<\/span>><\/span><\/pre>\n
 \u30104\u3011admin\\js\\listtable.js\u4e2d\uff0clistTable.edit\u7684\u54cd\u5e94\u51fd\u6570\u4fee\u6539\u5982\u4e0b\uff1a<\/p>\n
\r\n\/**\r\n * \u521b\u5efa\u4e00\u4e2a\u53ef\u7f16\u8f91\u533a\r\n *\/<\/span>\r\nlistTable.edit = function(obj, act, id)\r\n{\r\n  var<\/span> tag =obj.firstChild.tagName;\r\n \r\n  if<\/span> (typeof<\/span>(tag) !=\"undefined\"<\/span> && tag.toLowerCase() == \"input\"<\/span>)\r\n  {\r\n    return<\/span>;\r\n  }\r\n \r\n  \/* \u4fdd\u5b58\u539f\u59cb\u7684\u5185\u5bb9 *\/<\/span>\r\n  var<\/span> org = obj.innerHTML;\r\n  var<\/span> val = Browser.isIE ?obj.innerText : obj.textContent;\r\n \r\n  \/* \u521b\u5efa\u4e00\u4e2a\u8f93\u5165\u6846 *\/<\/span>\r\n  var<\/span> txt =document.createElement(\"INPUT\"<\/span>);\r\n  txt.value<\/span> = (val == 'N\/A'<\/span>) ?''<\/span> : val;\r\n  txt.style.width =(obj.offsetWidth + 12<\/span>) + \"px\"<\/span> ;\r\n \r\n  \/* \u9690\u85cf\u5bf9\u8c61\u4e2d\u7684\u5185\u5bb9\uff0c\u5e76\u5c06\u8f93\u5165\u6846\u52a0\u5165\u5230\u5bf9\u8c61\u4e2d *\/<\/span>\r\n  obj.innerHTML =\"\"<\/span>;\r\n  obj.appendChild(txt);\r\n  txt.focus();\r\n  txt.select<\/span>();\r\n \r\n  \/* \u7f16\u8f91\u533a\u8f93\u5165\u4e8b\u4ef6\u5904\u7406\u51fd\u6570 *\/<\/span>\r\n  txt.onkeypress = function(e)\r\n  {\r\n    var<\/span> evt =Utils.fixEvent(e);\r\n    var<\/span> obj =Utils.srcElement(e);\r\n \r\n    if<\/span> (evt.keyCode == 13<\/span>)\/\/www.ldhost.cn<\/span>\r\n    {\r\n      obj.blur();\r\n \r\n      return<\/span> false<\/span>;\r\n    }\r\n \r\n    if<\/span> (evt.keyCode == 27<\/span>)\r\n    {\r\n      obj.parentNode.innerHTML= org;\r\n    }\r\n  }\r\n \r\n  \/* \u7f16\u8f91\u533a\u5931\u53bb\u7126\u70b9\u7684\u5904\u7406\u51fd\u6570 *\/<\/span>\r\n  txt.onblur = function(e)\r\n  {\r\n    if<\/span>(Utils.trim(txt.value<\/span>).length > 0<\/span>)\r\n    {\r\n      res =Ajax.call(listTable.url, \"act=\"<\/span>+act+\"&val=\"<\/span> +encodeURIComponent(Utils.trim(txt.value<\/span>)) + \"&id=\"<\/span> +id, null<\/span>,\"POST\"<\/span>, \"JSON\"<\/span>, false<\/span>);\r\n \r\n      if<\/span> (res.message)\r\n      {\r\n        alert(res.message);\r\n      }\r\n \r\n      if<\/span>(res.id &&(res.act == 'goods_auto'<\/span> || res.act == 'article_auto'<\/span>))\r\n      {\r\n         document.getElementById('del'<\/span>+res.id).innerHTML = \"<ahref=\\\"\"<\/span>+ thisfile +\"?goods_id=\"<\/span>+ res.id+\"&act=del\\\" onclick=\\\"returnconfirm('\"<\/span>+deleteck+\"');\\\">\"<\/span>+deleteid+\"<\/a>\"<\/span>;\r\n      }\r\n \r\n      obj.innerHTML = (res.error== 0<\/span>) ? res.content : org;\r\n    }\r\n    else<\/span>\r\n    {\r\n      obj.innerHTML = org;\r\n    }\r\n   \r\n    if<\/span> (act =='edit_is_validated'<\/span>)\r\n    {\r\n         var<\/span> content = obj.innerHTML.trim();\r\n        \r\n         if<\/span> (content == '1'<\/span> || content.indexOf(\"yes\"<\/span>) >= 0<\/span>)\r\n         {\r\n            obj.innerHTML = '<imgsrc=\"images\/yes.gif\">'<\/span>;\r\n         }\r\n         else<\/span>\r\n        {\r\n            obj.innerHTML ='<img src=\"images\/no.gif\">'<\/span>;\r\n        }\r\n    }\r\n    else<\/span> if<\/span> (act =='edit_order_picking_status'<\/span>)\r\n    {\r\n         if<\/span> (org == obj.innerHTML)\r\n         {\r\n            return<\/span> true<\/span>;\r\n         }\r\n        \r\n         if<\/span> (obj.innerHTML == '1'<\/span>)\r\n         {\r\n            obj.innerHTML =\"\u3010\u62e3\u8d27\u4e2d\u3011\"<\/span>;\r\n         }\r\n         else<\/span> if<\/span> (obj.innerHTML == '2'<\/span>)\r\n        {\r\n            obj.innerHTML =\"\u3010\u62e3\u8d27\u5b8c\u6210\u3011\"<\/span>;\r\n        }\r\n         else<\/span>\r\n         {\r\n            obj.innerHTML =\"\u3010\u672a\u62e3\u8d27\u3011\"<\/span>;\r\n         }\r\n    }\r\n    else<\/span>\r\n    {\r\n        \r\n    }\r\n  }\r\n}<\/pre>\n
 \u30105\u3011admin\\order.php\u6587\u4ef6\u4e2d\u589e\u52a0\u4e0b\u9762\u7684\u51fd\u6570\uff1a<\/p>\n
\r\n\/*-<\/span>----------------------------------------------------- *\/<\/span>\r\n\/\/-- \u8ba2\u5355\u62e3\u8d27\u72b6\u6001\u67e5\u8be2\r\n\/<\/span>*-<\/span>----------------------------------------------------- *\/<\/span>\r\n \r\nif<\/span> ($_REQUEST<\/span>['act'<\/span>] == 'edit_order_picking_status'<\/span>)\r\n{\r\n    \/* \u68c0\u67e5\u6743\u9650 *\/<\/span>\r\n   check_authz_json('users_manage'<\/span>);\r\n \r\n    $id<\/span> =empty($_REQUEST<\/span>['id'<\/span>]) ? 0<\/span> : intval($_REQUEST<\/span>['id'<\/span>]);\r\n    $order_picking_status<\/span> =empty($_REQUEST<\/span>['val'<\/span>]) ? ''<\/span> : json_str_iconv(trim($_REQUEST<\/span>['val'<\/span>]));\r\n \r\n    $sql<\/span> = \"DELETE fromorder_picking_status WHERE order_id = '\"<\/span>. $id<\/span> .\"' LIMIT 1\"<\/span>;\r\n    $db<\/span>->query($sql<\/span>);\r\n   \r\n    $sql<\/span> = \"INSERT INTOorder_picking_status (order_id, user_name, order_picking_status) VALUES('\"<\/span>. $id<\/span> .\"', '\"<\/span>. $_SESSION<\/span>['admin_name'<\/span>] .\"', '\"<\/span>.$order_picking_status<\/span> .\"')\"<\/span>;\r\n    $db<\/span>->query($sql<\/span>);\r\n   \r\n    if<\/span> ($order_picking_status<\/span>> 2<\/span> || $order_picking_status<\/span> < 0<\/span>)\r\n    {\r\n         make_json_error($GLOBALS<\/span>['_LANG'<\/span>]['invalid_order_picking_status'<\/span>]);\r\n    }\r\n    else<\/span>\r\n    {\r\n         make_json_result($order_picking_status<\/span>);\r\n    }\r\n}<\/pre>\n
\r\n\/* \u67e5\u8be2 *\/<\/span>\r\n        $sql<\/span> = \"SELECTo.order_id, o.order_sn, o.add_time, o.order_status, o.shipping_status,o.order_amount, o.money_paid,\"<\/span> .\r\n                   \"o.pay_status, o.consignee, o.address, o.email, o.tel,o.extension_code, o.extension_id, \"<\/span> .\r\n                   \"(\"<\/span> . order_amount_field('o.'<\/span>) . \") AS total_fee, \"<\/span>.\r\n                   \"IFNULL(u.user_name, '\"<\/span> .$GLOBALS<\/span>['_LANG'<\/span>]['anonymous'<\/span>].\"') AS buyer \"<\/span>.\r\n                \" FROM\"<\/span> . $GLOBALS<\/span>['ecs'<\/span>]->table('order_info'<\/span>) . \" AS o \"<\/span> .\r\n                \" LEFT JOIN \"<\/span>.$GLOBALS<\/span>['ecs'<\/span>]->table('users'<\/span>). \" AS u ON u.user_id=o.user_id \"<\/span>.$where<\/span> .\r\n                \" ORDERBY $filter<\/span>[sort_by] $filter<\/span>[sort_order] \"<\/span>.\r\n                \" LIMIT\"<\/span> . ($filter<\/span>['page'<\/span>] - 1<\/span>) * $filter<\/span>['page_size'<\/span>] .\",$filter<\/span>[page_size]\"<\/span>;<\/pre>\n
\r\n\/* \u67e5\u8be2 *\/<\/span>\r\n        $sql<\/span> = \"SELECTo.order_id, o.order_sn, o.add_time, o.order_status, o.shipping_status,o.order_amount, o.money_paid,\"<\/span> .\r\n                   \"o.pay_status, o.consignee, o.address, o.email, o.tel,o.extension_code, o.extension_id, \"<\/span> .\r\n                    \"(\"<\/span> .order_amount_field('o.'<\/span>) . \") AS total_fee, \"<\/span> .\r\n                   \"IFNULL(u.user_name, '\"<\/span> .$GLOBALS<\/span>['_LANG'<\/span>]['anonymous'<\/span>].\"') AS buyer, p.user_name, p.order_picking_status \"<\/span>.\r\n                \" FROM\"<\/span> . $GLOBALS<\/span>['ecs'<\/span>]->table('order_info'<\/span>) . \" AS o \"<\/span> .\r\n                \" LEFTJOIN \"<\/span> .$GLOBALS<\/span>['ecs'<\/span>]->table('users'<\/span>). \" AS u ONu.user_id=o.user_id \"<\/span>.\r\n                \" LEFTJOIN order_picking_status AS p ON p.order_id = o.order_id \"<\/span>. $where<\/span> .\r\n                \" ORDERBY $filter<\/span>[sort_by] $filter<\/span>[sort_order] \"<\/span>.\r\n                \" LIMIT\"<\/span> . ($filter<\/span>['page'<\/span>] - 1<\/span>) * $filter<\/span>['page_size'<\/span>] .\",$filter<\/span>[page_size]\"<\/span>;<\/pre>\n
     <\/p>\n","protected":false},"excerpt":{"rendered":"
\u9488\u5bf9ecshop\u8ba2\u5355\u4e2d\u7684\u7269\u54c1\uff0c\u9700\u8981\u652f\u6301\u62e3\u8d27\u7684\u72b6\u6001\uff0c\u6bd4\u5982\u672a\u62e3\u8d27\u3001\u62e3\u8d27\u4e2d\u3001\u62e3\u8d27\u5b8c\u6210\uff0c\u4ee5\u53ca\u663e\u793a\u62e3\u8d27\u4eba\u59d3\u540d\u3002 — —————————- — Table structure for `order_picking_status` — —————————- DROP TABLE IF EXISTS `order_picking_status`; CREATE TABLE `order_picking_status` ( `order_id` mediumint(8) NOTNULL, `user_name` varchar(60)DEFAULT NULL, `order_picking_status`smallint(5) NOT NULL DEFAULT ‘0’, PRIMARY KEY (`order_id`) ) ENGINE=InnoDB DEFAULT CHARSET=gbk; \u30102\u3011\u5728\u6587\u4ef6languages\\zh_cn\\admin\\order.php\u4e2d\u589e\u52a0\uff1a \/* \u62e3\u8d27 *\/ $_LANG[‘order_picking_status’] = ‘\u62e3\u8d27\u72b6\u6001’; $_LANG[‘order_picking_status_none’] = ‘\u672a\u62e3\u8d27’; $_LANG[‘order_picking_status_processing’] = ‘\u62e3\u8d27\u4e2d’; $_LANG[‘order_picking_status_finish’] = ‘\u62e3\u8d27\u5b8c\u6210’; $_LANG[‘invalid_order_picking_status’] = […]<\/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-59513","post","type-post","status-publish","format-standard","hentry","category-16"],"_links":{"self":[{"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/posts\/59513","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=59513"}],"version-history":[{"count":0,"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/posts\/59513\/revisions"}],"wp:attachment":[{"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/media?parent=59513"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/categories?post=59513"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/tags?post=59513"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}