数据 - 步行者811

数据

(u'001a89765fa64102a9f586f461488406', u'A2017051120231485903', u'CH300001', u'ACTIVITY_DF', u'SUCCESS', u'{"accName":"\u9b4f\u5ef6\u840d","account":"6217922251802204","amount":"2000","amountUnit":"FEN","billNo":"A2017051120231485903","borrowNid":"97836e79e1004c198f2c858e014635bc","channelCode":"CH300001","merchantSerial":"A2017051120231485903","payType":"Activity","phone":"13210296836","product":"uzone","type":"MANUAL"}', u'{"result_code":"0000","result_msg":"\u4ea4\u6613\u6210\u529f"}', datetime.datetime(2017, 5, 11, 20, 26, 2), u'system', datetime.datetime(2017, 5, 11, 20, 26, 28), u'microsite')
(u'0027aeaa317846f8aef5450537db54de', u'PC2017041821135859240', u'CH400003', u'APP_REPAY', u'PROCESSING', u'{"amount":"83300","billNo":"PC2017041821135859240","productType":"shoujidai","spbillCreateIp":"58.56.174.250","transDesc":"wechat"}', u'{"appid":"wxce7ece2d90165935","device_info":"WEB","mch_id":"1369979402","nonce_str":"wjLP5ZgbBCE4mz9Z","prepay_id":"wx2017041821134349458ceb730311521703","result_code":"SUCCESS","return_code":"SUCCESS","return_msg":"OK","sign":"A4FEF28CD6DD90878389A9D2BA33CCE5","trade_type":"APP"}', datetime.datetime(2017, 4, 18, 21, 13, 43), u'finance', datetime.datetime(2017, 4, 18, 21, 13, 43), u'finance')
(u'002e499ec6a846d297dbf9483c138bb0', u'PR2017062410482585254', u'CH100005', u'DS', u'SUCCESS', u'{"accNo":"6228480248214831971","accessMode":"01","accessType":"0","bankId":"01030000","bizType":"000501","currency":"CNY","customerInfo":{"certifTp":"01","certify_id":"370784198809114017","customerNm":"\u9a6c\u5764","phoneNo":"18610755496"},"merOrderId":"PR2017062410482585254","payType":"9000","ppFlag":"01","signMethod":"MD5","txnAmt":"300000","txnSubType":"01","txnTime":"20170624105200","txnType":"11","version":"1.0.0"}', u'{"billNo":"PR2017062410482585254","channelCode":"CH100005","code":"0001","msg":"\u94f6\u884c\u5904\u7406\u4e2d\u3002[\u4ea4\u6613\u8fdb\u884c\u4e2d]","payErrorCode":"42000012","payErrorMsg":"\u8bf7\u6c42\u8d85\u65f6[\u5904\u7406\u4e2d]","transStatus":3}', datetime.datetime(2017, 6, 24, 10, 52), u'finance', datetime.datetime(2017, 6, 24, 11, 44, 58), u'microsite')
(u'004f92b7960e46cd87a406873ed76fdb', u'PS2016102219323942596', u'CH100003', u'UNIONPAYSDK', u'PROCESSING', u'billNo:PS2016102219323942596;money:100000', u'{"txnType":"01","respCode":"31","merId":"898320157340109","txnSubType":"01","version":"5.0.0","signMethod":"01","certId":"69597475696","encoding":"UTF-8","bizType":"000201","respMsg":"\u5546\u6237\u72b6\u6001\u4e0d\u6b63\u786e[2500103]","signature":"sV7U81P51XZlQq5+JqoVyjseK3r2vb8lTLAznbVKGOukf17X4G9lf7YtePq3mmlnaz2TpZsiYLnQGlOgG575jU52AupT3uyQfMsY98RTtowdw/Ou1ATTfhIVeZ5GmzHzU+DASuO54Ev8KruoFPZfVFVQ0J4O3+Cy/KgoB8HeLsOat79pm56o1f152PFZlW2frlvizI6ZeD2dhCKZqL6PoQ5j5oxqwTlodBBD0lBeUGXNhDw+Z8ePnma6Ugu/ffwSqFOcPNfjgmf8yJlfvBW87uVzHRnTXMQle3YHEAYx08yDVxNuRZCx0an4Jaq1ojimyD5NNUU9qh0PWOyZiDplbA==","orderId":"PS2016102219323942596","accessType":"0","txnTime":"20161022193238"}', datetime.datetime(2016, 10, 22, 19, 32, 38), u'finance', datetime.datetime(2016, 10, 22, 19, 32, 39), u'finance')
(u'00604cc45bdc42eb81fde03706e9fee6', u'PO2017061220212060485', u'CH190003', u'ALIPAY', u'PROCESSING', u'{"cerPath":"alipay/ysepay/mobanker.pfx","notifyUrl":"http://118.178.245.120:8080/ysepay/callBack","out_trade_no":"PO2017061220212060485","partnerId":"mobanker","productType":"shoujidai","reqUrl":"https://openapi.ysepay.com/gateway.do","seller_id":"mobanker","seller_name":"\u4e0a\u6d77\u524d\u9686\u91d1\u878d\u4fe1\u606f\u670d\u52a1\u6709\u9650\u516c\u53f8","subject":"\u652f\u4ed8\u5b9d\u8fd8\u6b3e","timeout_express":"1h","timestamp":"2017-06-12 20:24:48","total_amount":"4400.00"}', u'<html><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8"><title>Alipay</title></head><body><form id="ysepaysubmit" name="ysepaysubmit" action="https://openapi.ysepay.com/gateway.do" method = "post" style="display:none"><input type="text" name="seller_name" value="上海前隆金融信息服务有限公司"/><br/><input type="text" name="total_amount" value="4400.00"/><br/><input type="text" name="partner_id" value="mobanker"/><br/><input type="text" name="timeout_express" value="1h"/><br/><input type="text" name="subject" value="支付宝还款"/><br/><input type="text" name="sign_type" value="RSA"/><br/><input type="text" name="notify_url" value="http://118.178.245.120:8080/ysepay/callBack"/><br/><input type="text" name="charset" value="utf-8"/><br/><input type="text" name="business_code" value="01000010"/><br/><input type="text" name="out_trade_no" value="PO2017061220212060485"/><br/><input type="text" name="return_url" value="http://127.0.0.1:8080"/><br/><input type="text" name="version" value="3.0"/><br/><input type="text" name="sign" value="O85uRAknl3Frn0WMljjt0UTNEgaaoX9AWgyyLOMtRWCVSgaSr6S/QZIIBJkKmOFWRQI5IsPj0TJp/njmToqlGdSCzzRNSQZNN85Vz8W3eLoQXOS2rohGoqNAEj5CHV2VIq2jhvYZ3qzrlsL/nm776GJGmrdulaUkW8IY4t9W2E8="/><br/><input type="text" name="timestamp" value="2017-06-12 20:24:48"/><br/><input type="text" name="pay_mode" value="native"/><br/><input type="text" name="method" value="ysepay.online.wap.directpay.createbyuser"/><br/><input type="text" name="seller_id" value="mobanker"/><br/><input type="text" name="bank_type" value="1903000"/><br/><input type="submit" value="\u786e\u8ba4" style="display;"></form><script>document.forms[\'ysepaysubmit\'].submit();</script></body></html>', datetime.datetime(2017, 6, 12, 20, 24, 49), u'finance', datetime.datetime(2017, 6, 12, 20, 24, 49), u'finance')
@@@@@@@@@@@@@@@@
影响行数:5

=====================
<type 'unicode'>
{"info": ["影响行数:5"], "stat": "success", "result": {"rows": [{"BILL_NO": "A2017051120231485903", "STATUS": "SUCCESS", "UPDATE_TIME": "2017-05-11 20:26:28", "UPDATE_USER": "microsite", "REQUEST_TEXT": "{"accName":"魏延萍","account":"6217922251802204","amount":"2000","amountUnit":"FEN","billNo":"A2017051120231485903","borrowNid":"97836e79e1004c198f2c858e014635bc","channelCode":"CH300001","merchantSerial":"A2017051120231485903","payType":"Activity","phone":"13210296836","product":"uzone","type":"MANUAL"}", "BILL_TYPE": "ACTIVITY_DF", "CREATE_USER": "system", "CREATE_TIME": "2017-05-11 20:26:02", "response_text": "{"result_code":"0000","result_msg":"交易成功"}", "ID": "001a89765fa64102a9f586f461488406", "CHANNEL": "CH300001"}, {"BILL_NO": "PC2017041821135859240", "STATUS": "PROCESSING", "UPDATE_TIME": "2017-04-18 21:13:43", "UPDATE_USER": "finance", "REQUEST_TEXT": "{"amount":"83300","billNo":"PC2017041821135859240","productType":"shoujidai","spbillCreateIp":"58.56.174.250","transDesc":"wechat"}", "BILL_TYPE": "APP_REPAY", "CREATE_USER": "finance", "CREATE_TIME": "2017-04-18 21:13:43", "response_text": "{"appid":"wxce7ece2d90165935","device_info":"WEB","mch_id":"1369979402","nonce_str":"wjLP5ZgbBCE4mz9Z","prepay_id":"wx2017041821134349458ceb730311521703","result_code":"SUCCESS","return_code":"SUCCESS","return_msg":"OK","sign":"A4FEF28CD6DD90878389A9D2BA33CCE5","trade_type":"APP"}", "ID": "0027aeaa317846f8aef5450537db54de", "CHANNEL": "CH400003"}, {"BILL_NO": "PR2017062410482585254", "STATUS": "SUCCESS", "UPDATE_TIME": "2017-06-24 11:44:58", "UPDATE_USER": "microsite", "REQUEST_TEXT": "{"accNo":"6228480248214831971","accessMode":"01","accessType":"0","bankId":"01030000","bizType":"000501","currency":"CNY","customerInfo":{"certifTp":"01","certify_id":"370784198809114017","customerNm":"马坤","phoneNo":"18610755496"},"merOrderId":"PR2017062410482585254","payType":"9000","ppFlag":"01","signMethod":"MD5","txnAmt":"300000","txnSubType":"01","txnTime":"20170624105200","txnType":"11","version":"1.0.0"}", "BILL_TYPE": "DS", "CREATE_USER": "finance", "CREATE_TIME": "2017-06-24 10:52:00", "response_text": "{"billNo":"PR2017062410482585254","channelCode":"CH100005","code":"0001","msg":"银行处理中。[交易进行中]","payErrorCode":"42000012","payErrorMsg":"请求超时[处理中]","transStatus":3}", "ID": "002e499ec6a846d297dbf9483c138bb0", "CHANNEL": "CH100005"}, {"BILL_NO": "PS2016102219323942596", "STATUS": "PROCESSING", "UPDATE_TIME": "2016-10-22 19:32:39", "UPDATE_USER": "finance", "REQUEST_TEXT": "billNo:PS2016102219323942596;money:100000", "BILL_TYPE": "UNIONPAYSDK", "CREATE_USER": "finance", "CREATE_TIME": "2016-10-22 19:32:38", "response_text": "{"txnType":"01","respCode":"31","merId":"898320157340109","txnSubType":"01","version":"5.0.0","signMethod":"01","certId":"69597475696","encoding":"UTF-8","bizType":"000201","respMsg":"商户状态不正确[2500103]","signature":"sV7U81P51XZlQq5+JqoVyjseK3r2vb8lTLAznbVKGOukf17X4G9lf7YtePq3mmlnaz2TpZsiYLnQGlOgG575jU52AupT3uyQfMsY98RTtowdw/Ou1ATTfhIVeZ5GmzHzU+DASuO54Ev8KruoFPZfVFVQ0J4O3+Cy/KgoB8HeLsOat79pm56o1f152PFZlW2frlvizI6ZeD2dhCKZqL6PoQ5j5oxqwTlodBBD0lBeUGXNhDw+Z8ePnma6Ugu/ffwSqFOcPNfjgmf8yJlfvBW87uVzHRnTXMQle3YHEAYx08yDVxNuRZCx0an4Jaq1ojimyD5NNUU9qh0PWOyZiDplbA==","orderId":"PS2016102219323942596","accessType":"0","txnTime":"20161022193238"}", "ID": "004f92b7960e46cd87a406873ed76fdb", "CHANNEL": "CH100003"}, {"BILL_NO": "PO2017061220212060485", "STATUS": "PROCESSING", "UPDATE_TIME": "2017-06-12 20:24:49", "UPDATE_USER": "finance", "REQUEST_TEXT": "{"cerPath":"alipay/ysepay/mobanker.pfx","notifyUrl":"http://118.178.245.120:8080/ysepay/callBack","out_trade_no":"PO2017061220212060485","partnerId":"mobanker","productType":"shoujidai","reqUrl":"https://openapi.ysepay.com/gateway.do","seller_id":"mobanker","seller_name":"上海前隆金融信息服务有限公司","subject":"支付宝还款","timeout_express":"1h","timestamp":"2017-06-12 20:24:48","total_amount":"4400.00"}", "BILL_TYPE": "ALIPAY", "CREATE_USER": "finance", "CREATE_TIME": "2017-06-12 20:24:49", "response_text": "<html><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8"><title>Alipay</title></head><body><form id="ysepaysubmit" name="ysepaysubmit" action="https://openapi.ysepay.com/gateway.do" method = "post" style="display:none"><input type="text" name="seller_name" value="上海前隆金融信息服务有限公司"/><br/><input type="text" name="total_amount" value="4400.00"/><br/><input type="text" name="partner_id" value="mobanker"/><br/><input type="text" name="timeout_express" value="1h"/><br/><input type="text" name="subject" value="支付宝还款"/><br/><input type="text" name="sign_type" value="RSA"/><br/><input type="text" name="notify_url" value="http://118.178.245.120:8080/ysepay/callBack"/><br/><input type="text" name="charset" value="utf-8"/><br/><input type="text" name="business_code" value="01000010"/><br/><input type="text" name="out_trade_no" value="PO2017061220212060485"/><br/><input type="text" name="return_url" value="http://127.0.0.1:8080"/><br/><input type="text" name="version" value="3.0"/><br/><input type="text" name="sign" value="O85uRAknl3Frn0WMljjt0UTNEgaaoX9AWgyyLOMtRWCVSgaSr6S/QZIIBJkKmOFWRQI5IsPj0TJp/njmToqlGdSCzzRNSQZNN85Vz8W3eLoQXOS2rohGoqNAEj5CHV2VIq2jhvYZ3qzrlsL/nm776GJGmrdulaUkW8IY4t9W2E8="/><br/><input type="text" name="timestamp" value="2017-06-12 20:24:48"/><br/><input type="text" name="pay_mode" value="native"/><br/><input type="text" name="method" value="ysepay.online.wap.directpay.createbyuser"/><br/><input type="text" name="seller_id" value="mobanker"/><br/><input type="text" name="bank_type" value="1903000"/><br/><input type="submit" value="确认" style="display;"></form><script>document.forms['ysepaysubmit'].submit();</script></body></html>", "ID": "00604cc45bdc42eb81fde03706e9fee6", "CHANNEL": "CH190003"}], "total": 5}, "err": [], "result_col": [[{"field": "ID", "width": 200, "title": "ID"}, {"field": "BILL_NO", "width": 200, "title": "BILL_NO"}, {"field": "CHANNEL", "width": 200, "title": "CHANNEL"}, {"field": "BILL_TYPE", "width": 200, "title": "BILL_TYPE"}, {"field": "STATUS", "width": 200, "title": "STATUS"}, {"field": "REQUEST_TEXT", "width": 200, "title": "REQUEST_TEXT"}, {"field": "response_text", "width": 200, "title": "response_text"}, {"field": "CREATE_TIME", "width": 200, "title": "CREATE_TIME"}, {"field": "CREATE_USER", "width": 200, "title": "CREATE_USER"}, {"field": "UPDATE_TIME", "width": 200, "title": "UPDATE_TIME"}, {"field": "UPDATE_USER", "width": 200, "title": "UPDATE_USER"}]]}

posted on 2017-11-14 18:46 步行者811 阅读(637) 评论(0) 编辑收藏举报

刷新页面返回顶部

步行者811

数据

导航

公告