? ???? ?? ?? ??? ?? ? ?? ??? ?????.

??

?? WeChat ??? v2 ??? v3 ???? ?????. 2014? 9? 10? ??? ???? ?? v2 ??, ? ??? ???? ?? v3 ?????. WeChat Pay V3 ???? paySignKey ????? ????. v2? ?? ?? ??? Fangbei Studio? ?? ??? ?????. ? ????? WeChat Pay v3? ?????.

1. ??? ??? ?????

WeChat Pay v3? ??? ??? ?????? ????, ???? ??????

https:// api.mch .weixin.qq.com/pay/downloadbill

??? ????? ??? ????

?? ????? ???? ??, ??: 20140603 / tr>

字段名 變量名 必填 類(lèi)型 示例值 描述 公眾賬號(hào)ID appid 是 String(32) wx8888888888888888 微信分配的公眾賬號(hào)ID 商戶(hù)號(hào) mch_id 是 String(32) 1900000109 微信支付分配的商戶(hù)號(hào) 設(shè)備號(hào) device_info 否 String(32) 013467007045764 微信支付分配的終端設(shè)備號(hào)，填寫(xiě)此字段，只下載該設(shè)備號(hào)的對(duì)賬單 隨機(jī)字符串 nonce_str 是 String(32) 5K8264ILTKCH16CQ2502SI8ZNMTM67VS 隨機(jī)字符串，不長(zhǎng)于32位。推薦隨機(jī)數(shù)生成算法 簽名 sign 是 String(32) C380BEC2BFD727A4B6845133519F3AD6 簽名，詳見(jiàn)簽名生成算法 對(duì)賬單日期 bill_date 是 String(8) 20140603 下載對(duì)賬單的日期，格式：20140603 賬單類(lèi)型 bill_type 否 String(8) ALL ALL，返回當(dāng)日所有訂單信息，默認(rèn)值 SUCCESS，返回當(dāng)日成功支付的訂單 REFUND，返回當(dāng)日退款訂單 REVOKED，已撤銷(xiāo)的訂單 ?? ??	?? ??	??	??	? ?? th>	??
?? ?? ID	appid	?	???(32)	wx888888888888888 td>	WeChat?? ??? ?? ?? ID
??? ??	mch_id	??? ????	???(32)	1900000109	WeChat ???? ??? ??? ??
?? ??	device_info td>	???	???(32)	013467007045764	WeChat ??? ??? ?? ?? ??, ? ??? ???? ? ?? ??? ?? ???? ???????
?? ???	nonce_str	?	???(32)	5K8264ILTKCH16CQ2502SI8ZNMTM67VS	32? ??? ?? ??????. ?? ?? ?? ????
??	sign	?	???(32)	C380BEC2BFD727A4B6845133519F3AD6	??, ?? ?? ???? ??
bill_date	?	???(8)	20140603
??? ??	bill_type	???	??? (8)	ALL	ALL, ?? ?? ?? ?? ?? , ??? SUCCESS, ?? ?? ??? ?? ?? REFUND, ?? ??? ?? ?? REVOKED, ??? ??

Demo? ?? ??? ??? ????

include_once("../WxPayPubHelper/WxPayPubHelper.php");

    //對(duì)賬單日期
    if (!isset($_POST["bill_date"])){
        $bill_date = "20150401";
    }
    else{
        $bill_date = $_POST["bill_date"];
        
        //使用對(duì)賬單接口
        $downloadBill = new DownloadBill_pub();
        //設(shè)置對(duì)賬單接口參數(shù)
        //設(shè)置必填參數(shù)
        //appid已填,商戶(hù)無(wú)需重復(fù)填寫(xiě)
        //mch_id已填,商戶(hù)無(wú)需重復(fù)填寫(xiě)
        //noncestr已填,商戶(hù)無(wú)需重復(fù)填寫(xiě)
        //sign已填,商戶(hù)無(wú)需重復(fù)填寫(xiě)
        $downloadBill->setParameter("bill_date","$bill_date");//對(duì)賬單日期 
        $downloadBill->setParameter("bill_type","ALL");//賬單類(lèi)型 
        //非必填參數(shù)，商戶(hù)可根據(jù)實(shí)際情況選填
        //$downloadBill->setParameter("device_info","XXXX");//設(shè)備號(hào)  
        //$downloadBill->setParameter("device_info","方倍工作室1");//設(shè)備號(hào) 
        //對(duì)賬單接口結(jié)果
        $downloadBillResult = $downloadBill->getResult();
        echo $downloadBillResult['return_code'];
        
        if ($downloadBillResult['return_code'] == "FAIL") {
            echo "通信出錯(cuò)：".$downloadBillResult['return_msg'];
        }else{
             print_r(&#39;<pre class="brush:php;toolbar:false">&#39;);
             echo "【對(duì)賬單詳情】"."</br>";
             print_r($downloadBill->response);
             print_r(&#39;

'); } }? ?? ? ?? ?? ??? ???? ??? ? ????. ??? ??? ??? ??? ????

交易時(shí)間,公眾賬號(hào)ID,商戶(hù)號(hào),子商戶(hù)號(hào),設(shè)備號(hào),微信訂單號(hào),商戶(hù)訂單號(hào),用戶(hù)標(biāo)識(shí),交易類(lèi)型,交易狀態(tài),付款銀行,貨幣種類(lèi),總金額,企業(yè)紅包金額,微信退款單號(hào),商戶(hù)退款單號(hào),退款金額,企業(yè)紅包退款金額,退款類(lèi)型,退款狀態(tài),商品名稱(chēng),商戶(hù)數(shù)據(jù)包,手續(xù)費(fèi),費(fèi)率 `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,`,`,`微信公眾平臺(tái)開(kāi)發(fā)最佳實(shí)踐,`,`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,`,`,`微信公眾平臺(tái)開(kāi)發(fā)最佳實(shí)踐,`,`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,`,`,`微信公眾平臺(tái)開(kāi)發(fā)最佳實(shí)踐,`,`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,`,`,`微信公眾平臺(tái)開(kāi)發(fā)最佳實(shí)踐,`,`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,`,`,`微信公眾平臺(tái)開(kāi)發(fā)最佳實(shí)踐,`,`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,`,`,`微信公眾平臺(tái)開(kāi)發(fā)最佳實(shí)踐,`,`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,`,`,`微信公眾平臺(tái)開(kāi)發(fā)最佳實(shí)踐,`,`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,`,`,`微信公眾平臺(tái)開(kāi)發(fā)最佳實(shí)踐,`,`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,`,`,`微信公眾平臺(tái)開(kāi)發(fā)最佳實(shí)踐,`,`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,`,`,`微信公眾平臺(tái)開(kāi)發(fā)最佳實(shí)踐,`,`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,`,`,`微信公眾平臺(tái)開(kāi)發(fā)最佳實(shí)踐,`,`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,`,`,`微信公眾平臺(tái)開(kāi)發(fā)最佳實(shí)踐,`,`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,`,`,`微信公眾平臺(tái)開(kāi)發(fā)最佳實(shí)踐,`,`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,`,`,`微信公眾平臺(tái)開(kāi)發(fā)最佳實(shí)踐,`,`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,`,`,`微信公眾平臺(tái)開(kāi)發(fā)最佳實(shí)踐,`,`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,`,`,`微信公眾平臺(tái)開(kāi)發(fā)最佳實(shí)踐,`,`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,`,`,`微信公眾平臺(tái)開(kāi)發(fā)最佳實(shí)踐,`,`0.00060,`0.60% 總交易單數(shù),總交易額,總退款金額,總企業(yè)紅包退款金額,手續(xù)費(fèi)總金額 `17,`571.40,`0.00,`0.00,`3.42840

?? ???? ?? ?? ???? XML? ??? ????

<xml>
    <return_code><![CDATA[FAIL]]></return_code>
    <return_msg><![CDATA[No Bill Exist]]></return_msg>
 </xml>

2. ??? ?? ? ??? ???? ???? ??? ?????? ?? ? ??? ??? ?? ????. . ?? ??????? ?????? ???. 1. ??? ????? ???? ??? ?????

交易時(shí)間,公眾賬號(hào)ID,商戶(hù)號(hào),子商戶(hù)號(hào),設(shè)備號(hào),微信訂單號(hào),商戶(hù)訂單號(hào),用戶(hù)標(biāo)識(shí),交易類(lèi)型,交易狀態(tài),付款銀行,貨幣種類(lèi),總金額,代金券或立減優(yōu)惠金額,微信退款單號(hào),商戶(hù)退款單號(hào),退款金額, 代金券或立減優(yōu)惠退款金額，退款類(lèi)型，退款狀態(tài),商品名稱(chēng),商戶(hù)數(shù)據(jù)包,手續(xù)費(fèi),費(fèi)率

? ??? ?? ??, ??? ?? ???? ?????

CREATE TABLE IF NOT EXISTS `wx_bill` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `tradetime` varchar(20) NOT NULL,
  `ghid` varchar(20) NOT NULL,
  `mchid` varchar(20) NOT NULL,
  `submch` varchar(10) NOT NULL,
  `deviceid` varchar(16) NOT NULL,
  `wxorder` varchar(30) NOT NULL,
  `bzorder` varchar(30) NOT NULL,
  `openid` varchar(30) NOT NULL,
  `tradetype` varchar(10) NOT NULL,
  `tradestatus` varchar(10) NOT NULL,
  `bank` varchar(16) NOT NULL,
  `currency` varchar(20) NOT NULL,
  `totalmoney` varchar(20) NOT NULL,
  `redpacketmoney` varchar(20) NOT NULL,
  `wxrefund` varchar(10) NOT NULL,
  `bzrefund` varchar(10) NOT NULL,
  `refundmoney` varchar(20) NOT NULL,
  `redpacketrefund` varchar(20) NOT NULL,
  `refundtype` varchar(10) NOT NULL,
  `refundstatus` varchar(10) NOT NULL,
  `productname` varchar(30) NOT NULL,
  `bzdatapacket` varchar(10) NOT NULL,
  `fee` varchar(10) NOT NULL,
  `rate` varchar(10) NOT NULL,  PRIMARY KEY (`id`),  UNIQUE KEY `wxorder` (`wxorder`),  UNIQUE KEY `bzorder` (`bzorder`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=272 ;

2. ??? ?? WeChat ??? ???? ??????? ?????.

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(32, '1428843600', 'wx554f0b3e56067c9d', '10024142', '0', 'WJ1', '1006120206201504120058836372', 'wx554f0b3e56067c9d1428814787', 'oMfX0jnVvUaoR84XV8cP4ugcd9dk', 'NATIVE', 'SUCCESS', 'PAB_CREDIT', 'CNY', '16.80', '0.00', '0', '0', '0', '0', '', '', '微信公眾平臺(tái)開(kāi)發(fā)最佳實(shí)踐', '', '0.10080', '0.60%'),
(31, '1428850601', 'wx554f0b3e56067c9d', '10024142', '0', 'WJ1', '1005430206201504120058999894', 'wx554f0b3e56067c9d1428821791', 'oMfX0jnw_NpAlwgSuJsyR8ocGSjI', 'NATIVE', 'SUCCESS', 'CCB_DEBIT', 'CNY', '42.00', '0.00', '0', '0', '0', '0', '', '', '微信公眾平臺(tái)開(kāi)發(fā)最佳實(shí)踐', '', '0.25200', '0.60%'),
(30, '1428855888', 'wx554f0b3e56067c9d', '10024142', '0', 'WJ1', '1003310206201504120059131508', 'wx554f0b3e56067c9d1428827074', 'oMfX0jk-zqqeyv7yZYEc4W1lWPVg', 'NATIVE', 'SUCCESS', 'CFT', 'CNY', '15.80', '0.00', '0', '0', '0', '0', '', '', '微信公眾平臺(tái)開(kāi)發(fā)最佳實(shí)踐', '', '0.09480', '0.60%');

2. ???? ?? ???? ???? ??? ????? ?????. 1. ??? ????? ?? ?? ??? ?? ????? ?????. ??? ??, ??? ?? ??, ??? ?? ??? ???? ???. ?? ??? ??? ????WeChat ?? ?? ???? ??? ? ?? ??? ??? ?????. PHP ??? ?? ?????!