查询平台账户日终余额

1curl -X GET \
2  https://api.mch.weixin.qq.com/v3/merchant/fund/dayendbalance/BASIC?date=2019-08-17 \
3  -H "Authorization: WECHATPAY2-SHA256-RSA2048 mchid=\"1900000001\",..." \
4  -H "Accept: application/json" 
5

1package com.java.demo;
2
3import com.java.utils.WXPayUtility; // 引用微信支付工具库，参考：https://pay.weixin.qq.com/doc/v3/partner/4014985777
4
5import com.google.gson.annotations.SerializedName;
6import com.google.gson.annotations.Expose;
7import okhttp3.MediaType;
8import okhttp3.OkHttpClient;
9import okhttp3.Request;
10import okhttp3.RequestBody;
11import okhttp3.Response;
12
13import java.io.IOException;
14import java.io.UncheckedIOException;
15import java.security.PrivateKey;
16import java.security.PublicKey;
17import java.util.ArrayList;
18import java.util.HashMap;
19import java.util.List;
20import java.util.Map;
21
22/**
23 * 查询收付通平台账户日终余额API
24 */
25public class QueryDayEndBalance {
26  private static String HOST = "https://api.mch.weixin.qq.com";
27  private static String METHOD = "GET";
28  private static String PATH = "/v3/merchant/fund/dayendbalance/{account_type}";
29
30  public static void main(String[] args) {
31    // TODO: 请准备商户开发必要参数，参考：https://pay.weixin.qq.com/doc/v3/partner/4013080340
32    QueryDayEndBalance client = new QueryDayEndBalance(
33      "19xxxxxxxx",                    // 商户号，是由微信支付系统生成并分配给每个商户的唯一标识符，商户号获取方式参考 https://pay.weixin.qq.com/doc/v3/partner/4013080340
34      "1DDE55AD98Exxxxxxxxxx",         // 商户API证书序列号，如何获取请参考 https://pay.weixin.qq.com/doc/v3/partner/4013058924
35      "/path/to/apiclient_key.pem",     // 商户API证书私钥文件路径，本地文件路径
36      "PUB_KEY_ID_xxxxxxxxxxxxx",      // 微信支付公钥ID，如何获取请参考 https://pay.weixin.qq.com/doc/v3/partner/4013038589
37      "/path/to/wxp_pub.pem"           // 微信支付公钥文件路径，本地文件路径
38    );
39
40    QueryDayEndBalanceRequest request = new QueryDayEndBalanceRequest();
41    request.accountType = AccountType.BASIC;
42    request.date = "2019-08-17";
43    try {
44      DayEndBalance response = client.run(request);
45        // TODO: 请求成功，继续业务逻辑
46        System.out.println(response);
47    } catch (WXPayUtility.ApiException e) {
48        // TODO: 请求失败，根据状态码执行不同的逻辑
49        e.printStackTrace();
50    }
51  }
52
53  public DayEndBalance run(QueryDayEndBalanceRequest request) {
54    String uri = PATH;
55    uri = uri.replace("{account_type}", WXPayUtility.urlEncode(request.accountType.toString()));
56    Map<String, Object> args = new HashMap<>();
57    args.put("date", request.date);
58    String queryString = WXPayUtility.urlEncode(args);
59    if (!queryString.isEmpty()) {
60        uri = uri + "?" + queryString;
61    }
62
63    Request.Builder reqBuilder = new Request.Builder().url(HOST + uri);
64    reqBuilder.addHeader("Accept", "application/json");
65    reqBuilder.addHeader("Wechatpay-Serial", wechatPayPublicKeyId);
66    reqBuilder.addHeader("Authorization", WXPayUtility.buildAuthorization(mchid, certificateSerialNo, privateKey, METHOD, uri, null));
67    reqBuilder.method(METHOD, null);
68    Request httpRequest = reqBuilder.build();
69
70    // 发送HTTP请求
71    OkHttpClient client = new OkHttpClient.Builder().build();
72    try (Response httpResponse = client.newCall(httpRequest).execute()) {
73      String respBody = WXPayUtility.extractBody(httpResponse);
74      if (httpResponse.code() >= 200 && httpResponse.code() < 300) {
75        // 2XX 成功，验证应答签名
76        WXPayUtility.validateResponse(this.wechatPayPublicKeyId, this.wechatPayPublicKey,
77            httpResponse.headers(), respBody);
78
79        // 从HTTP应答报文构建返回数据
80        return WXPayUtility.fromJson(respBody, DayEndBalance.class);
81      } else {
82        throw new WXPayUtility.ApiException(httpResponse.code(), respBody, httpResponse.headers());
83      }
84    } catch (IOException e) {
85      throw new UncheckedIOException("Sending request to " + uri + " failed.", e);
86    }
87  }
88
89  private final String mchid;
90  private final String certificateSerialNo;
91  private final PrivateKey privateKey;
92  private final String wechatPayPublicKeyId;
93  private final PublicKey wechatPayPublicKey;
94
95  public QueryDayEndBalance(String mchid, String certificateSerialNo, String privateKeyFilePath, String wechatPayPublicKeyId, String wechatPayPublicKeyFilePath) {
96    this.mchid = mchid;
97    this.certificateSerialNo = certificateSerialNo;
98    this.privateKey = WXPayUtility.loadPrivateKeyFromPath(privateKeyFilePath);
99    this.wechatPayPublicKeyId = wechatPayPublicKeyId;
100    this.wechatPayPublicKey = WXPayUtility.loadPublicKeyFromPath(wechatPayPublicKeyFilePath);
101  }
102
103  public static class QueryDayEndBalanceRequest {
104    @SerializedName("date")
105    @Expose(serialize = false)
106    public String date;
107  
108    @SerializedName("account_type")
109    @Expose(serialize = false)
110    public AccountType accountType;
111  }
112  
113  public static class DayEndBalance {
114    @SerializedName("available_amount")
115    public Long availableAmount;
116  
117    @SerializedName("pending_amount")
118    public Long pendingAmount;
119  }
120  
121  public enum AccountType {
122    @SerializedName("BASIC")
123    BASIC,
124    @SerializedName("OPERATION")
125    OPERATION,
126    @SerializedName("FEES")
127    FEES
128  }
129  
130}
131

1package main
2
3import (
4	"demo/wxpay_utility" // 引用微信支付工具库，参考 https://pay.weixin.qq.com/doc/v3/partner/4015119446
5	"encoding/json"
6	"fmt"
7	"net/http"
8	"net/url"
9	"strings"
10)
11
12func main() {
13	// TODO: 请准备商户开发必要参数，参考：https://pay.weixin.qq.com/doc/v3/partner/4013080340
14	config, err := wxpay_utility.CreateMchConfig(
15		"19xxxxxxxx",                 // 商户号，是由微信支付系统生成并分配给每个商户的唯一标识符，商户号获取方式参考 https://pay.weixin.qq.com/doc/v3/partner/4013080340
16		"1DDE55AD98Exxxxxxxxxx",      // 商户API证书序列号，如何获取请参考 https://pay.weixin.qq.com/doc/v3/partner/4013058924
17		"/path/to/apiclient_key.pem", // 商户API证书私钥文件路径，本地文件路径
18		"PUB_KEY_ID_xxxxxxxxxxxxx",   // 微信支付公钥ID，如何获取请参考 https://pay.weixin.qq.com/doc/v3/partner/4013038589
19		"/path/to/wxp_pub.pem",       // 微信支付公钥文件路径，本地文件路径
20	)
21	if err != nil {
22		fmt.Println(err)
23		return
24	}
25
26	request := &QueryDayEndBalanceRequest{
27		Date:        wxpay_utility.String("2019-08-17"),
28		AccountType: ACCOUNTTYPE_BASIC.Ptr(),
29	}
30
31	response, err := QueryDayEndBalance(config, request)
32	if err != nil {
33		fmt.Printf("请求失败: %+v\n", err)
34		// TODO: 请求失败，根据状态码执行不同的处理
35		return
36	}
37
38	// TODO: 请求成功，继续业务逻辑
39	fmt.Printf("请求成功: %+v\n", response)
40}
41
42func QueryDayEndBalance(config *wxpay_utility.MchConfig, request *QueryDayEndBalanceRequest) (response *DayEndBalance, err error) {
43	const (
44		host   = "https://api.mch.weixin.qq.com"
45		method = "GET"
46		path   = "/v3/merchant/fund/dayendbalance/{account_type}"
47	)
48
49	reqUrl, err := url.Parse(fmt.Sprintf("%s%s", host, path))
50	if err != nil {
51		return nil, err
52	}
53	reqUrl.Path = strings.Replace(reqUrl.Path, "{account_type}", url.PathEscape(fmt.Sprintf("%v", *request.AccountType)), -1)
54	query := reqUrl.Query()
55	if request.Date != nil {
56		query.Add("date", *request.Date)
57	}
58	reqUrl.RawQuery = query.Encode()
59	httpRequest, err := http.NewRequest(method, reqUrl.String(), nil)
60	if err != nil {
61		return nil, err
62	}
63	httpRequest.Header.Set("Accept", "application/json")
64	httpRequest.Header.Set("Wechatpay-Serial", config.WechatPayPublicKeyId())
65	authorization, err := wxpay_utility.BuildAuthorization(config.MchId(), config.CertificateSerialNo(), config.PrivateKey(), method, reqUrl.RequestURI(), nil)
66	if err != nil {
67		return nil, err
68	}
69	httpRequest.Header.Set("Authorization", authorization)
70
71	client := &http.Client{}
72	httpResponse, err := client.Do(httpRequest)
73	if err != nil {
74		return nil, err
75	}
76	respBody, err := wxpay_utility.ExtractResponseBody(httpResponse)
77	if err != nil {
78		return nil, err
79	}
80	if httpResponse.StatusCode >= 200 && httpResponse.StatusCode < 300 {
81		// 2XX 成功，验证应答签名
82		err = wxpay_utility.ValidateResponse(
83			config.WechatPayPublicKeyId(),
84			config.WechatPayPublicKey(),
85			&httpResponse.Header,
86			respBody,
87		)
88		if err != nil {
89			return nil, err
90		}
91		response := &DayEndBalance{}
92		if err := json.Unmarshal(respBody, response); err != nil {
93			return nil, err
94		}
95
96		return response, nil
97	} else {
98		return nil, wxpay_utility.NewApiException(
99			httpResponse.StatusCode,
100			httpResponse.Header,
101			respBody,
102		)
103	}
104}
105
106type QueryDayEndBalanceRequest struct {
107	Date        *string      `json:"date,omitempty"`
108	AccountType *AccountType `json:"account_type,omitempty"`
109}
110
111func (o *QueryDayEndBalanceRequest) MarshalJSON() ([]byte, error) {
112	type Alias QueryDayEndBalanceRequest
113	a := &struct {
114		Date        *string      `json:"date,omitempty"`
115		AccountType *AccountType `json:"account_type,omitempty"`
116		*Alias
117	}{
118		// 序列化时移除非 Body 字段
119		Date:        nil,
120		AccountType: nil,
121		Alias:       (*Alias)(o),
122	}
123	return json.Marshal(a)
124}
125
126type DayEndBalance struct {
127	AvailableAmount *int64 `json:"available_amount,omitempty"`
128	PendingAmount   *int64 `json:"pending_amount,omitempty"`
129}
130
131type AccountType string
132
133func (e AccountType) Ptr() *AccountType {
134	return &e
135}
136
137const (
138	ACCOUNTTYPE_BASIC     AccountType = "BASIC"
139	ACCOUNTTYPE_OPERATION AccountType = "OPERATION"
140	ACCOUNTTYPE_FEES      AccountType = "FEES"
141)
142