{"id":28655,"date":"2024-11-25T10:19:14","date_gmt":"2024-11-25T02:19:14","guid":{"rendered":"https:\/\/fwq.ai\/blog\/28655\/"},"modified":"2024-11-25T10:19:14","modified_gmt":"2024-11-25T02:19:14","slug":"%e5%be%ae%e4%bf%a1%e6%94%af%e4%bb%98%e5%bc%80%e5%8f%91%e5%af%b9%e8%b4%a6%e5%8d%95%e4%bb%8b%e7%bb%8d","status":"publish","type":"post","link":"https:\/\/fwq.ai\/blog\/28655\/","title":{"rendered":"\u5fae\u4fe1\u652f\u4ed8\u5f00\u53d1\u5bf9\u8d26\u5355\u4ecb\u7ecd"},"content":{"rendered":"

\u6ce8\u610f<\/p>\n

\u5fae\u4fe1\u652f\u4ed8\u73b0\u5728\u5206\u4e3av2\u7248\u548cv3\u7248\uff0c2014\u5e749\u670810\u53f7\u4e4b\u524d\u7533\u8bf7\u7684\u4e3av2\u7248\uff0c\u4e4b\u540e\u7533\u8bf7\u7684\u4e3av3\u7248\u3002V3\u7248\u7684\u5fae\u4fe1\u652f\u4ed8\u6ca1\u6709paySignKey\u53c2\u6570\u3002v2\u7684\u76f8\u5173\u4ecb\u7ecd\u8bf7\u53c2\u8003\u65b9\u500d\u5de5\u4f5c\u5ba4\u7684\u5176\u4ed6\u6587\u7ae0\u3002\u672c\u6587\u4ecb\u7ecd\u7684\u4e3a\u5fae\u4fe1\u652f\u4ed8v3\u3002<\/p>\n

 \u4e00\u3001\u5bf9\u8d26\u5355\u6570\u636e\u63a5\u53e3<\/p>\n

\u5fae\u4fe1\u652f\u4ed8v3\u63d0\u4f9b\u4e86\u5bf9\u8d26\u5355\u7684\u6570\u636e\u63a5\u53e3\uff0c\u5176\u4f7f\u7528\u7684\u63a5\u53e3\u4e3a <\/p>\n

https:\/\/api.mch.weixin.qq.com\/pay\/downloadbill<\/p>\n

\u8bf7\u6c42\u7684\u53c2\u6570\u5982\u4e0b<\/p>\n\n\n\n\n\n\n\n\n\n\n
\n

\u5b57\u6bb5\u540d<\/p>\n<\/th>\n

\n

\u53d8\u91cf\u540d<\/p>\n<\/th>\n

\n

\u5fc5\u586b<\/p>\n<\/th>\n

\n

\u7c7b\u578b<\/p>\n<\/th>\n

\n

\u793a\u4f8b\u503c<\/p>\n<\/th>\n

\n

\u63cf\u8ff0<\/p>\n<\/th>\n<\/tr>\n

\n

\u516c\u4f17\u8d26\u53f7ID<\/p>\n<\/td>\n

\n

appid<\/p>\n<\/td>\n

\n

\u662f<\/p>\n<\/td>\n

\n

String(32)<\/p>\n<\/td>\n

\n

wx8888888888888888<\/p>\n<\/td>\n

\n

\u5fae\u4fe1\u5206\u914d\u7684\u516c\u4f17\u8d26\u53f7ID<\/p>\n<\/td>\n<\/tr>\n

\n

\u5546\u6237\u53f7<\/p>\n<\/td>\n

\n

mch_id<\/p>\n<\/td>\n

\n

\u662f<\/p>\n<\/td>\n

\n

String(32)<\/p>\n<\/td>\n

\n

1900000109<\/p>\n<\/td>\n

\n

\u5fae\u4fe1\u652f\u4ed8\u5206\u914d\u7684\u5546\u6237\u53f7<\/p>\n<\/td>\n<\/tr>\n

\n

\u8bbe\u5907\u53f7<\/p>\n<\/td>\n

\n

device_info<\/p>\n<\/td>\n

\n

\u5426<\/p>\n<\/td>\n

\n

String(32)<\/p>\n<\/td>\n

\n

013467007045764<\/p>\n<\/td>\n

\n

\u5fae\u4fe1\u652f\u4ed8\u5206\u914d\u7684\u7ec8\u7aef\u8bbe\u5907\u53f7\uff0c\u586b\u5199\u6b64\u5b57\u6bb5\uff0c\u53ea\u4e0b\u8f7d\u8be5\u8bbe\u5907\u53f7\u7684\u5bf9\u8d26\u5355<\/p>\n<\/td>\n<\/tr>\n

\n

\u968f\u673a\u5b57\u7b26\u4e32<\/p>\n<\/td>\n

\n

nonce_str<\/p>\n<\/td>\n

\n

\u662f<\/p>\n<\/td>\n

\n

String(32)<\/p>\n<\/td>\n

\n

5K8264ILTKCH16CQ2502SI8ZNMTM67VS<\/p>\n<\/td>\n

\n

\u968f\u673a\u5b57\u7b26\u4e32\uff0c\u4e0d\u957f\u4e8e32\u4f4d\u3002\u63a8\u8350\u968f\u673a\u6570\u751f\u6210\u7b97\u6cd5<\/p>\n<\/td>\n<\/tr>\n

\n

\u7b7e\u540d<\/p>\n<\/td>\n

\n

sign<\/p>\n<\/td>\n

\n

\u662f<\/p>\n<\/td>\n

\n

String(32)<\/p>\n<\/td>\n

\n

C380BEC2BFD727A4B6845133519F3AD6<\/p>\n<\/td>\n

\n

\u7b7e\u540d\uff0c\u8be6\u89c1\u7b7e\u540d\u751f\u6210\u7b97\u6cd5<\/p>\n<\/td>\n<\/tr>\n

\n

\u5bf9\u8d26\u5355\u65e5\u671f<\/p>\n<\/td>\n

\n

bill_date<\/p>\n<\/td>\n

\n

\u662f<\/p>\n<\/td>\n

\n

String(8)<\/p>\n<\/td>\n

\n

20140603<\/p>\n<\/td>\n

\n

\u4e0b\u8f7d\u5bf9\u8d26\u5355\u7684\u65e5\u671f\uff0c\u683c\u5f0f\uff1a20140603<\/p>\n<\/td>\n<\/tr>\n

\n

\u8d26\u5355\u7c7b\u578b<\/p>\n<\/td>\n

\n

bill_type<\/p>\n<\/td>\n

\n

\u5426<\/p>\n<\/td>\n

\n

String(8)<\/p>\n<\/td>\n

\n

ALL<\/p>\n<\/td>\n

\n

ALL\uff0c\u8fd4\u56de\u5f53\u65e5\u6240\u6709\u8ba2\u5355\u4fe1\u606f\uff0c\u9ed8\u8ba4\u503c<\/p>\n

SUCCESS\uff0c\u8fd4\u56de\u5f53\u65e5\u6210\u529f\u652f\u4ed8\u7684\u8ba2\u5355<\/p>\n

REFUND\uff0c\u8fd4\u56de\u5f53\u65e5\u9000\u6b3e\u8ba2\u5355<\/p>\n

REVOKED\uff0c\u5df2\u64a4\u9500\u7684\u8ba2\u5355<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Demo\u4e2d\u7684\u5b9e\u73b0\u4ee3\u7801\u5982\u4e0b<\/p>\n<\/p>\n

include_once(\"..\/WxPayPubHelper\/WxPayPubHelper.php\");\r\n\r\n    \/\/\u5bf9\u8d26\u5355\u65e5\u671f\r\n    if (!isset($_POST[\"bill_date\"])){\r\n        $bill_date = \"20150401\";\r\n    }\r\n    else{\r\n        $bill_date = $_POST[\"bill_date\"];\r\n        \r\n        \/\/\u4f7f\u7528\u5bf9\u8d26\u5355\u63a5\u53e3\r\n        $downloadBill = new DownloadBill_pub();\r\n        \/\/\u8bbe\u7f6e\u5bf9\u8d26\u5355\u63a5\u53e3\u53c2\u6570\r\n        \/\/\u8bbe\u7f6e\u5fc5\u586b\u53c2\u6570\r\n        \/\/appid\u5df2\u586b,\u5546\u6237\u65e0\u9700\u91cd\u590d\u586b\u5199\r\n        \/\/mch_id\u5df2\u586b,\u5546\u6237\u65e0\u9700\u91cd\u590d\u586b\u5199\r\n        \/\/noncestr\u5df2\u586b,\u5546\u6237\u65e0\u9700\u91cd\u590d\u586b\u5199\r\n        \/\/sign\u5df2\u586b,\u5546\u6237\u65e0\u9700\u91cd\u590d\u586b\u5199\r\n        $downloadBill->setParameter(\"bill_date\",\"$bill_date\");\/\/\u5bf9\u8d26\u5355\u65e5\u671f \r\n        $downloadBill->setParameter(\"bill_type\",\"ALL\");\/\/\u8d26\u5355\u7c7b\u578b \r\n        \/\/\u975e\u5fc5\u586b\u53c2\u6570\uff0c\u5546\u6237\u53ef\u6839\u636e\u5b9e\u9645\u60c5\u51b5\u9009\u586b\r\n        \/\/$downloadBill->setParameter(\"device_info\",\"XXXX\");\/\/\u8bbe\u5907\u53f7  \r\n        \/\/$downloadBill->setParameter(\"device_info\",\"\u65b9\u500d\u5de5\u4f5c\u5ba41\");\/\/\u8bbe\u5907\u53f7 \r\n        \/\/\u5bf9\u8d26\u5355\u63a5\u53e3\u7ed3\u679c\r\n        $downloadBillResult = $downloadBill->getResult();\r\n        echo $downloadBillResult['return_code'];\r\n        \r\n        if ($downloadBillResult['return_code'] == \"FAIL\") {\r\n            echo \"\u901a\u4fe1\u51fa\u9519\uff1a\".$downloadBillResult['return_msg'];\r\n        }else{\r\n             print_r('<pre class=\"brush:php;toolbar:false\">');\r\n             echo \"\u3010\u5bf9\u8d26\u5355\u8be6\u60c5\u3011\".\"<\/br>\";\r\n             print_r($downloadBill->response);\r\n             print_r('<\/pre>\n
  \u767b\u5f55\u540e\u590d\u5236  ‘);         }     } <\/p>\n
\u4e0a\u8ff0\u5bf9\u8d26\u5355\u4e00\u6b21\u53ea\u80fd\u67e5\u8be2\u4e00\u5929\u7684\u6570\u636e\u3002<\/p>\n
\u5176\u8fd4\u56de\u7684\u8d26\u5355\u7ed3\u679c\u5982\u4e0b<\/p>\n
\u4ea4\u6613\u65f6\u95f4,\u516c\u4f17\u8d26\u53f7ID,\u5546\u6237\u53f7,\u5b50\u5546\u6237\u53f7,\u8bbe\u5907\u53f7,\u5fae\u4fe1\u8ba2\u5355\u53f7,\u5546\u6237\u8ba2\u5355\u53f7,\u7528\u6237\u6807\u8bc6,\u4ea4\u6613\u7c7b\u578b,\u4ea4\u6613\u72b6\u6001,\u4ed8\u6b3e\u94f6\u884c,\u8d27\u5e01\u79cd\u7c7b,\u603b\u91d1\u989d,\u4f01\u4e1a\u7ea2\u5305\u91d1\u989d,\u5fae\u4fe1\u9000\u6b3e\u5355\u53f7,\u5546\u6237\u9000\u6b3e\u5355\u53f7,\u9000\u6b3e\u91d1\u989d,\u4f01\u4e1a\u7ea2\u5305\u9000\u6b3e\u91d1\u989d,\u9000\u6b3e\u7c7b\u578b,\u9000\u6b3e\u72b6\u6001,\u5546\u54c1\u540d\u79f0,\u5546\u6237\u6570\u636e\u5305,\u624b\u7eed\u8d39,\u8d39\u7387 `2015-04-12 20:27:22,`wx554f0b3e56067c9d,`10024142,`0,`WJ4,`1000690206201504120059461630,`wx554f0b3e56067c9d1428841627,`oMfX0jgJjSPVvYOz3p_BP8LclWO0,`NATIVE,`SUCCESS,`CMB_CREDIT,`CNY,`71.00,`0.00,`0,`0,`0,`0,`,`,`\u5fae\u4fe1\u516c\u4f17\u5e73\u53f0\u5f00\u53d1\u6700\u4f73\u5b9e\u8df5,`,`0.42600,`0.60% `2015-04-12 18:08:38,`wx554f0b3e56067c9d,`10024142,`0,`WJ1,`1001370206201504120059259734,`wx554f0b3e56067c9d1428833308,`oMfX0jhbQ1xd0B6Vm-kuizH9e9rs,`NATIVE,`SUCCESS,`COMM_DEBIT,`CNY,`92.00,`0.00,`0,`0,`0,`0,`,`,`\u5fae\u4fe1\u516c\u4f17\u5e73\u53f0\u5f00\u53d1\u6700\u4f73\u5b9e\u8df5,`,`0.55200,`0.60% `2015-04-12 19:12:06,`wx554f0b3e56067c9d,`10024142,`0,`WJ1,`1001520206201504120059346120,`wx554f0b3e56067c9d1428837103,`oMfX0jj6h2ls1TsZEORs8WXRtSrE,`NATIVE,`SUCCESS,`CEB_CREDIT,`CNY,`69.60,`0.00,`0,`0,`0,`0,`,`,`\u5fae\u4fe1\u516c\u4f17\u5e73\u53f0\u5f00\u53d1\u6700\u4f73\u5b9e\u8df5,`,`0.41760,`0.60% `2015-04-12 13:03:25,`wx554f0b3e56067c9d,`10024142,`0,`WJ1,`1002120206201504120058869224,`wx554f0b3e56067c9d1428814993,`oMfX0jtHOXPrCCWebdJEYl1eIzVg,`NATIVE,`SUCCESS,`CFT,`CNY,`16.80,`0.00,`0,`0,`0,`0,`,`,`\u5fae\u4fe1\u516c\u4f17\u5e73\u53f0\u5f00\u53d1\u6700\u4f73\u5b9e\u8df5,`,`0.10080,`0.60% `2015-04-12 12:20:39,`wx554f0b3e56067c9d,`10024142,`0,`WJ2,`1002560206201504120058795541,`wx554f0b3e56067c9d1428812423,`oMfX0jhBckNfxRDHp2lUiFxXlCYE,`NATIVE,`SUCCESS,`CCB_DEBIT,`CNY,`126.60,`0.00,`0,`0,`0,`0,`,`,`\u5fae\u4fe1\u516c\u4f17\u5e73\u53f0\u5f00\u53d1\u6700\u4f73\u5b9e\u8df5,`,`0.75960,`0.60% `2015-04-12 09:35:03,`wx554f0b3e56067c9d,`10024142,`0,`WJ6,`1003310206201504120058568869,`wx554f0b3e56067c9d1428802486,`oMfX0jmQtv9nBfol_-e83xYdXacM,`NATIVE,`SUCCESS,`CMBC_DEBIT,`CNY,`0.10,`0.00,`0,`0,`0,`0,`,`,`\u5fae\u4fe1\u516c\u4f17\u5e73\u53f0\u5f00\u53d1\u6700\u4f73\u5b9e\u8df5,`,`0.00060,`0.60% `2015-04-12 09:23:20,`wx554f0b3e56067c9d,`10024142,`0,`WJ6,`1003310206201504120058569203,`wx554f0b3e56067c9d1428801789,`oMfX0jmQtv9nBfol_-e83xYdXacM,`NATIVE,`SUCCESS,`CMBC_DEBIT,`CNY,`0.10,`0.00,`0,`0,`0,`0,`,`,`\u5fae\u4fe1\u516c\u4f17\u5e73\u53f0\u5f00\u53d1\u6700\u4f73\u5b9e\u8df5,`,`0.00060,`0.60% `2015-04-12 10:15:27,`wx554f0b3e56067c9d,`10024142,`0,`WJ5,`1003310206201504120058606779,`wx554f0b3e56067c9d1428804915,`oMfX0jmQtv9nBfol_-e83xYdXacM,`NATIVE,`SUCCESS,`CFT,`CNY,`0.10,`0.00,`0,`0,`0,`0,`,`,`\u5fae\u4fe1\u516c\u4f17\u5e73\u53f0\u5f00\u53d1\u6700\u4f73\u5b9e\u8df5,`,`0.00060,`0.60% `2015-04-12 10:10:09,`wx554f0b3e56067c9d,`10024142,`0,`WJ5,`1003310206201504120058610924,`wx554f0b3e56067c9d1428804597,`oMfX0jmQtv9nBfol_-e83xYdXacM,`NATIVE,`SUCCESS,`CFT,`CNY,`0.10,`0.00,`0,`0,`0,`0,`,`,`\u5fae\u4fe1\u516c\u4f17\u5e73\u53f0\u5f00\u53d1\u6700\u4f73\u5b9e\u8df5,`,`0.00060,`0.60% `2015-04-12 10:06:19,`wx554f0b3e56067c9d,`10024142,`0,`WJ6,`1003310206201504120058617007,`wx554f0b3e56067c9d1428804368,`oMfX0jmQtv9nBfol_-e83xYdXacM,`NATIVE,`SUCCESS,`CFT,`CNY,`0.10,`0.00,`0,`0,`0,`0,`,`,`\u5fae\u4fe1\u516c\u4f17\u5e73\u53f0\u5f00\u53d1\u6700\u4f73\u5b9e\u8df5,`,`0.00060,`0.60% `2015-04-12 11:07:04,`wx554f0b3e56067c9d,`10024142,`0,`WJ1,`1003310206201504120058692567,`wx554f0b3e56067c9d1428808013,`oMfX0jmQtv9nBfol_-e83xYdXacM,`NATIVE,`SUCCESS,`CFT,`CNY,`0.10,`0.00,`0,`0,`0,`0,`,`,`\u5fae\u4fe1\u516c\u4f17\u5e73\u53f0\u5f00\u53d1\u6700\u4f73\u5b9e\u8df5,`,`0.00060,`0.60% `2015-04-12 11:27:07,`wx554f0b3e56067c9d,`10024142,`0,`WJ6,`1003310206201504120058735881,`wx554f0b3e56067c9d1428809215,`oMfX0jmQtv9nBfol_-e83xYdXacM,`NATIVE,`SUCCESS,`CFT,`CNY,`0.10,`0.00,`0,`0,`0,`0,`,`,`\u5fae\u4fe1\u516c\u4f17\u5e73\u53f0\u5f00\u53d1\u6700\u4f73\u5b9e\u8df5,`,`0.00060,`0.60% `2015-04-12 16:24:48,`wx554f0b3e56067c9d,`10024142,`0,`WJ1,`1003310206201504120059131508,`wx554f0b3e56067c9d1428827074,`oMfX0jk-zqqeyv7yZYEc4W1lWPVg,`NATIVE,`SUCCESS,`CFT,`CNY,`15.80,`0.00,`0,`0,`0,`0,`,`,`\u5fae\u4fe1\u516c\u4f17\u5e73\u53f0\u5f00\u53d1\u6700\u4f73\u5b9e\u8df5,`,`0.09480,`0.60% `2015-04-12 14:56:41,`wx554f0b3e56067c9d,`10024142,`0,`WJ1,`1005430206201504120058999894,`wx554f0b3e56067c9d1428821791,`oMfX0jnw_NpAlwgSuJsyR8ocGSjI,`NATIVE,`SUCCESS,`CCB_DEBIT,`CNY,`42.00,`0.00,`0,`0,`0,`0,`,`,`\u5fae\u4fe1\u516c\u4f17\u5e73\u53f0\u5f00\u53d1\u6700\u4f73\u5b9e\u8df5,`,`0.25200,`0.60% `2015-04-12 13:00:00,`wx554f0b3e56067c9d,`10024142,`0,`WJ1,`1006120206201504120058836372,`wx554f0b3e56067c9d1428814787,`oMfX0jnVvUaoR84XV8cP4ugcd9dk,`NATIVE,`SUCCESS,`PAB_CREDIT,`CNY,`16.80,`0.00,`0,`0,`0,`0,`,`,`\u5fae\u4fe1\u516c\u4f17\u5e73\u53f0\u5f00\u53d1\u6700\u4f73\u5b9e\u8df5,`,`0.10080,`0.60% `2015-04-12 16:13:48,`wx554f0b3e56067c9d,`10024142,`0,`WJ4,`1007560206201504120059119673,`wx554f0b3e56067c9d1428826408,`oMfX0jlf4aVHBY1nel1XuNvb2m1A,`NATIVE,`SUCCESS,`ABC_DEBIT,`CNY,`120.00,`0.00,`0,`0,`0,`0,`,`,`\u5fae\u4fe1\u516c\u4f17\u5e73\u53f0\u5f00\u53d1\u6700\u4f73\u5b9e\u8df5,`,`0.72000,`0.60% `2015-04-12 09:49:04,`wx554f0b3e56067c9d,`10024142,`0,`WJ1,`1009550206201504120058567546,`wx554f0b3e56067c9d1428803335,`oMfX0juZ58OdofLgirvkqK0FPq-w,`NATIVE,`SUCCESS,`CFT,`CNY,`0.10,`0.00,`0,`0,`0,`0,`,`,`\u5fae\u4fe1\u516c\u4f17\u5e73\u53f0\u5f00\u53d1\u6700\u4f73\u5b9e\u8df5,`,`0.00060,`0.60% \u603b\u4ea4\u6613\u5355\u6570,\u603b\u4ea4\u6613\u989d,\u603b\u9000\u6b3e\u91d1\u989d,\u603b\u4f01\u4e1a\u7ea2\u5305\u9000\u6b3e\u91d1\u989d,\u624b\u7eed\u8d39\u603b\u91d1\u989d `17,`571.40,`0.00,`0.00,`3.42840<\/pre>\n
  \u767b\u5f55\u540e\u590d\u5236   <\/p>\n
\u5982\u679c\u5f53\u5929\u6ca1\u6709\u8d26\u5355\uff0c\u5219\u8fd4\u56deXML\u5982\u4e0b<\/p>\n<\/p>\n
<xml>\r\n    <return_code><![CDATA[FAIL]]><\/return_code>\r\n    <return_msg><![CDATA[No Bill Exist]]><\/return_msg>\r\n<\/xml><\/pre>\n
  \u767b\u5f55\u540e\u590d\u5236   <\/p>\n
 \u4e8c\u3001\u8d26\u5355\u5165\u5e93<\/p>\n
\u4e0a\u8ff0\u7684\u8d26\u5355\u6570\u636e\u662f\u4e2a\u5b57\u7b26\u4e32\uff0c\u4e14\u53ea\u662f\u4e00\u5929\u7684\u6570\u636e\uff0c\u4e0d\u5229\u4e8e\u7edf\u8ba1\u53ca\u67e5\u8be2\u3002\u8fd8\u9700\u8981\u4e0b\u8f7d\u5230\u6570\u636e\u5e93\u4e2d\u6765\u3002<\/p>\n
1. \u5efa\u8868<\/p>\n
\u8d26\u5355\u7684\u5b57\u6bb5\u6709\u8fd9\u4e9b<\/p>\n<\/p>\n
\u4ea4\u6613\u65f6\u95f4,\u516c\u4f17\u8d26\u53f7ID,\u5546\u6237\u53f7,\u5b50\u5546\u6237\u53f7,\u8bbe\u5907\u53f7,\u5fae\u4fe1\u8ba2\u5355\u53f7,\u5546\u6237\u8ba2\u5355\u53f7,\u7528\u6237\u6807\u8bc6,\u4ea4\u6613\u7c7b\u578b,\u4ea4\u6613\u72b6\u6001,\u4ed8\u6b3e\u94f6\u884c,\u8d27\u5e01\u79cd\u7c7b,\u603b\u91d1\u989d,\u4ee3\u91d1\u5238\u6216\u7acb\u51cf\u4f18\u60e0\u91d1\u989d,\u5fae\u4fe1\u9000\u6b3e\u5355\u53f7,\u5546\u6237\u9000\u6b3e\u5355\u53f7,\u9000\u6b3e\u91d1\u989d, \u4ee3\u91d1\u5238\u6216\u7acb\u51cf\u4f18\u60e0\u9000\u6b3e\u91d1\u989d\uff0c\u9000\u6b3e\u7c7b\u578b\uff0c\u9000\u6b3e\u72b6\u6001,\u5546\u54c1\u540d\u79f0,\u5546\u6237\u6570\u636e\u5305,\u624b\u7eed\u8d39,\u8d39\u7387<\/pre>\n
  \u767b\u5f55\u540e\u590d\u5236   <\/p>\n
\u6839\u636e\u4e0a\u8ff0\u5b57\u6bb5\uff0c\u5efa\u8868\u5982\u4e0b<\/p>\n<\/p>\n
CREATE TABLE IF NOT EXISTS `wx_bill` (\r\n  `id` int(10) NOT NULL AUTO_INCREMENT,\r\n  `tradetime` varchar(20) NOT NULL,\r\n  `ghid` varchar(20) NOT NULL,\r\n  `mchid` varchar(20) NOT NULL,\r\n  `submch` varchar(10) NOT NULL,\r\n  `deviceid` varchar(16) NOT NULL,\r\n  `wxorder` varchar(30) NOT NULL,\r\n  `bzorder` varchar(30) NOT NULL,\r\n  `openid` varchar(30) NOT NULL,\r\n  `tradetype` varchar(10) NOT NULL,\r\n  `tradestatus` varchar(10) NOT NULL,\r\n  `bank` varchar(16) NOT NULL,\r\n  `currency` varchar(20) NOT NULL,\r\n  `totalmoney` varchar(20) NOT NULL,\r\n  `redpacketmoney` varchar(20) NOT NULL,\r\n  `wxrefund` varchar(10) NOT NULL,\r\n  `bzrefund` varchar(10) NOT NULL,\r\n  `refundmoney` varchar(20) NOT NULL,\r\n  `redpacketrefund` varchar(20) NOT NULL,\r\n  `refundtype` varchar(10) NOT NULL,\r\n  `refundstatus` varchar(10) NOT NULL,\r\n  `productname` varchar(30) NOT NULL,\r\n  `bzdatapacket` varchar(10) NOT NULL,\r\n  `fee` varchar(10) NOT NULL,\r\n  `rate` varchar(10) NOT NULL,\r\n  PRIMARY KEY (`id`),\r\n  UNIQUE KEY `wxorder` (`wxorder`),\r\n  UNIQUE KEY `bzorder` (`bzorder`)\r\n) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=272 ;<\/pre>\n
  \u767b\u5f55\u540e\u590d\u5236   <\/p>\n
2. \u5165\u5e93
 <\/h3>\n
\u5c06\u5fae\u4fe1\u8d26\u5355\u7684\u6570\u636e\u63d2\u5165\u5230\u6570\u636e\u5e93\u4e2d\uff0c\u5b9e\u73b0\u5982\u4e0b<\/p>\n
  INSERT INTO `wx_bill` (`id`, `tradetime`, `ghid`, `mchid`, `submch`, `deviceid`, `wxorder`, `bzorder`, `openid`, `tradetype`, `tradestatus`, `bank`, `currency`, `totalmoney`, `redpacketmoney`, `wxrefund`, `bzrefund`, `refundmoney`, `redpacketrefund`, `refundtype`, `refundstatus`, `productname`, `bzdatapacket`, `fee`, `rate`) VALUES\r\n(32, '1428843600', 'wx554f0b3e56067c9d', '10024142', '0', 'WJ1', '1006120206201504120058836372', 'wx554f0b3e56067c9d1428814787', 'oMfX0jnVvUaoR84XV8cP4ugcd9dk', 'NATIVE', 'SUCCESS', 'PAB_CREDIT', 'CNY', '16.80', '0.00', '0', '0', '0', '0', '', '', '\u5fae\u4fe1\u516c\u4f17\u5e73\u53f0\u5f00\u53d1\u6700\u4f73\u5b9e\u8df5', '', '0.10080', '0.60%'),\r\n(31, '1428850601', 'wx554f0b3e56067c9d', '10024142', '0', 'WJ1', '1005430206201504120058999894', 'wx554f0b3e56067c9d1428821791', 'oMfX0jnw_NpAlwgSuJsyR8ocGSjI', 'NATIVE', 'SUCCESS', 'CCB_DEBIT', 'CNY', '42.00', '0.00', '0', '0', '0', '0', '', '', '\u5fae\u4fe1\u516c\u4f17\u5e73\u53f0\u5f00\u53d1\u6700\u4f73\u5b9e\u8df5', '', '0.25200', '0.60%'),\r\n(30, '1428855888', 'wx554f0b3e56067c9d', '10024142', '0', 'WJ1', '1003310206201504120059131508', 'wx554f0b3e56067c9d1428827074', 'oMfX0jk-zqqeyv7yZYEc4W1lWPVg', 'NATIVE', 'SUCCESS', 'CFT', 'CNY', '15.80', '0.00', '0', '0', '0', '0', '', '', '\u5fae\u4fe1\u516c\u4f17\u5e73\u53f0\u5f00\u53d1\u6700\u4f73\u5b9e\u8df5', '', '0.09480', '0.60%');<\/pre>\n
  \u767b\u5f55\u540e\u590d\u5236   <\/p>\n
\u4e8c\u3001\u7edf\u8ba1\u5206\u6790<\/p>\n
\u6709\u4e86\u672c\u5730\u6570\u636e\uff0c\u5c31\u53ef\u4ee5\u8fdb\u884c\u5404\u79cd\u7edf\u8ba1\u5206\u6790\u4e86\u3002<\/p>\n
1. \u6761\u4ef6\u7ec4\u5408<\/h3>\n
\u4e0b\u9762\u662f\u4e00\u79cd\u8fdb\u884c\u7ec4\u5408\u67e5\u8be2\u8d26\u5355\u7684\u754c\u9762\u5b9e\u73b0\u3002\u9700\u8981\u67e5\u8be2\u4f7f\u7528\u7684\u8bbe\u5907\uff0c\u4f7f\u7528\u7684\u652f\u4ed8\u7c7b\u578b\uff0c\u53ca\u6307\u5b9a\u7684\u65f6\u95f4\u8303\u56f4\u3002<\/p>\n
\"\u5fae\u4fe1\u652f\u4ed8\u5f00\u53d1\u5bf9\u8d26\u5355\u4ecb\u7ecd\u63d2\u56fe\"<\/p>\n
\u5176\u67e5\u8be2\u7684\u7ed3\u679c\u5982\u4e0b\u6240\u793a<\/p>\n
\"\u5fae\u4fe1\u652f\u4ed8\u5f00\u53d1\u5bf9\u8d26\u5355\u4ecb\u7ecd\u63d2\u56fe1\"<\/p>\n
\u66f4\u591a\u5fae\u4fe1\u652f\u4ed8\u5f00\u53d1\u5bf9\u8d26\u5355\u4ecb\u7ecd\u76f8\u5173\u6587\u7ae0\u8bf7\u5173\u6ce8PHP\u4e2d\u6587\u7f51\uff01<\/p>\n","protected":false},"excerpt":{"rendered":"
\u6ce8\u610f \u5fae\u4fe1\u652f\u4ed8\u73b0\u5728\u5206\u4e3av2\u7248\u548cv3\u7248\uff0c2014\u5e749\u670810\u53f7\u4e4b\u524d\u7533\u8bf7\u7684\u4e3av2\u7248\uff0c\u4e4b\u540e\u7533\u8bf7\u7684\u4e3av3\u7248\u3002V3\u7248\u7684\u5fae\u4fe1\u652f\u4ed8\u6ca1\u6709paySignKey\u53c2\u6570\u3002v2\u7684\u76f8\u5173\u4ecb\u7ecd\u8bf7\u53c2\u8003\u65b9\u500d\u5de5\u4f5c\u5ba4\u7684\u5176\u4ed6\u6587\u7ae0\u3002\u672c\u6587\u4ecb\u7ecd\u7684\u4e3a\u5fae\u4fe1\u652f\u4ed8v3\u3002  \u4e00\u3001\u5bf9\u8d26\u5355\u6570\u636e\u63a5\u53e3 \u5fae\u4fe1\u652f\u4ed8v3\u63d0\u4f9b\u4e86\u5bf9\u8d26\u5355\u7684\u6570\u636e\u63a5\u53e3\uff0c\u5176\u4f7f\u7528\u7684\u63a5\u53e3\u4e3a  https:\/\/api.mch.weixin.qq.com\/pay\/downloadbill \u8bf7\u6c42\u7684\u53c2\u6570\u5982\u4e0b \u5b57\u6bb5\u540d \u53d8\u91cf\u540d \u5fc5\u586b \u7c7b\u578b \u793a\u4f8b\u503c \u63cf\u8ff0 \u516c\u4f17\u8d26\u53f7ID appid \u662f String(32) wx8888888888888888 \u5fae\u4fe1\u5206\u914d\u7684\u516c\u4f17\u8d26\u53f7ID \u5546\u6237\u53f7 mch_id \u662f String(32) 1900000109 \u5fae\u4fe1\u652f\u4ed8\u5206\u914d\u7684\u5546\u6237\u53f7 \u8bbe\u5907\u53f7 device_info \u5426 String(32) 013467007045764 \u5fae\u4fe1\u652f\u4ed8\u5206\u914d\u7684\u7ec8\u7aef\u8bbe\u5907\u53f7\uff0c\u586b\u5199\u6b64\u5b57\u6bb5\uff0c\u53ea\u4e0b\u8f7d\u8be5\u8bbe\u5907\u53f7\u7684\u5bf9\u8d26\u5355 \u968f\u673a\u5b57\u7b26\u4e32 nonce_str \u662f String(32) 5K8264ILTKCH16CQ2502SI8ZNMTM67VS \u968f\u673a\u5b57\u7b26\u4e32\uff0c\u4e0d\u957f\u4e8e32\u4f4d\u3002\u63a8\u8350\u968f\u673a\u6570\u751f\u6210\u7b97\u6cd5 \u7b7e\u540d sign \u662f String(32) C380BEC2BFD727A4B6845133519F3AD6 \u7b7e\u540d\uff0c\u8be6\u89c1\u7b7e\u540d\u751f\u6210\u7b97\u6cd5 \u5bf9\u8d26\u5355\u65e5\u671f bill_date \u662f String(8) 20140603 \u4e0b\u8f7d\u5bf9\u8d26\u5355\u7684\u65e5\u671f\uff0c\u683c\u5f0f\uff1a20140603 \u8d26\u5355\u7c7b\u578b bill_type \u5426 String(8) ALL ALL\uff0c\u8fd4\u56de\u5f53\u65e5\u6240\u6709\u8ba2\u5355\u4fe1\u606f\uff0c\u9ed8\u8ba4\u503c SUCCESS\uff0c\u8fd4\u56de\u5f53\u65e5\u6210\u529f\u652f\u4ed8\u7684\u8ba2\u5355 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[19],"tags":[],"class_list":["post-28655","post","type-post","status-publish","format-standard","hentry","category-19"],"_links":{"self":[{"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/posts\/28655","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=28655"}],"version-history":[{"count":0,"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/posts\/28655\/revisions"}],"wp:attachment":[{"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/media?parent=28655"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/categories?post=28655"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/tags?post=28655"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}