Order Query

Code Example

TopPayRequestUtil(Click here to get the code sample)

import com.google.gson.JsonObject;
public class OrderQuery {

  private static final String MCH_ID = "S820211021094748000001";
  private static final String PLAT_PUBLIC_KEY = "MIGfMA0GCSqGSIb........3DQEBAQUA";
  private static final String MCH_PRIVATE_KEY = "MIICeAIBADANBgkqhkiG........kXf3Vp";
  private static final String orderQueryUrl = "https://vnm-openapi.toppay.asia/gateway/query";

  public static void main(String[] args) throws Exception {
    query();
  }
  private static void query() throws Exception {
    Map<String, String> requestParams = new TreeMap<>();
    requestParams.put("merchantCode", MCH_ID);
    requestParams.put("queryType", "CASH_QUERY");
    requestParams.put("orderNum", "186888188666");
    requestParams.put("platOrderNum", "PRE186888188666");
    requestParams.put("dateTime", "20220101105500");

    List<String> paramNameList = new ArrayList<>();
    for (String key : maps.keySet()) {
        paramNameList.add(key);
    }
    Collections.sort(paramNameList);
    StringBuilder stringBuilder = new StringBuilder();
    for (String key : paramNameList) {
        stringBuilder.append(requestParams.get(key));
    }
    String keyStr = stringBuilder.toString();
    System.out.println("keyStr:" + keyStr);
    String signedStr = TopPayRequestUtil.privateEncrypt(keyStr, TopPayRequestUtil.getPrivateKey(MCH_PRIVATE_KEY));
    requestParams.put("sign", signedStr);

    String postJson = new Gson().toJson(requestParams);
    System.out.println("Post Json Params:" + postJson);

    String responseJson = TopPayRequestUtil.doPost(orderQueryUrl, postJson);
    System.out.println("Response Msg:" + responseJson);
  }
}

<?php
    $mchPrivateKey = 'MIICeAIBADANBgkXTvM...........S6AoUbZT/';
    $merchantCode = 'S820250514103726000009';
    $queryType = 'ORDER_QUERY';
    $orderNum = '20240411230615';
    $platOrderNum = 'PRE1778454526152433731';
    $dateTime = '20191018105510';
    $params = array(
        'merchantCode' => $merchantCode,
        'queryType' => $queryType,
        'orderNum' => $orderNum,
        'platOrderNum' => $platOrderNum,
        'dateTime' => $dateTime,
    );

    ksort($params);
    $params_str = '';
    foreach ($params as $key => $val) {
        $params_str = $params_str . $val;
    }
    $sign = pivate_key_encrypt($params_str, $mchPrivateKey);
    $params['sign'] = $sign;
    $params_string = json_encode($params);
    $url = 'https://vnm-openapi.toppay.asia/gateway/query';
    $ch = curl_init();

    curl_setopt($ch, CURLOPT_URL, $url);
    curl_setopt($ch, CURLOPT_CUSTOMREQUEST, "POST");
    curl_setopt($ch, CURLOPT_POSTFIELDS, $params_string);
    curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
    curl_setopt($ch, CURLOPT_HTTPHEADER, array(
        'Content-Type: application/json',
        'Content-Length: ' . strlen($params_string))
    );
    curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, FALSE);

    $request = curl_exec($ch);
    $httpCode = curl_getinfo($ch, CURLINFO_HTTP_CODE);

    if($httpCode == 200)
    {
        $result = json_decode($request, true);
        if (isset($result['data'])) {
        $data = $result['data'];
        echo "message :". $result['message'] . "<br>";
        echo "platRespCode :". $data['platRespCode'] . "<br>";
        echo "platOrderNum :". $data['platOrderNum'] . "<br>";
        echo "msg :". $data['msg'] . "<br>";
        echo "amount :". $data['amount'] . "<br>";
        echo "orderNum :". $data['orderNum'] . "<br>";
        echo "status :". $data['status'] . "<br>";
        }else{
            echo "The order was not found.\n";
        }
    }
    else {
        echo $httpCode;
    }
    
    function pivate_key_encrypt($data, $pivate_key)
    {
        $pivate_key = '-----BEGIN PRIVATE KEY-----'."\n".$pivate_key."\n".'-----END PRIVATE KEY-----';
        $pi_key = openssl_pkey_get_private($pivate_key);
        $crypto = '';
        foreach (str_split($data, 117) as $chunk) {
            openssl_private_encrypt($chunk, $encryptData, $pi_key);
            $crypto .= $encryptData;
        }
        return base64_encode($crypto);
    }
?>

using demo.utils;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Net;
using System.Text;
using System.Threading.Tasks;

namespace demo.demos
{
    class QueryOrderDemo
    {
        private static readonly string MCH_ID = "S820250514103726000009";
        private static readonly string PLAT_PUBLIC_KEY = "MIGfMA0GCSqGLSZF7f..........QAB";
        private static readonly string MCH_PRIVATE_KEY = "MIICdwIBADANBgkqhk+2fQlE................qzuBvIGAe3OWNg="; 
        private static readonly string payUrl = "https://vnm-openapi.toppay.asia/gateway/query";
        public static void requestQuery()
        {
            long currenttimemillis = (long)(DateTime.UtcNow - new DateTime(1970, 1, 1, 0, 0, 0, DateTimeKind.Utc)).TotalMilliseconds;
            string merchantCode = MCH_ID;                                             
            string queryType = "ORDER_QUERY";                                         
            string orderNum = "ORDER_QUERY";                                          
            string platOrderNum = "PRE1778454526152433731";                            
            string dateTime = "20191107105500";                                       
            Dictionary<string, object> VarPost = new Dictionary<string, object>(); ;
            VarPost.Add("merchantCode", merchantCode);
            VarPost.Add("queryType", queryType);
            VarPost.Add("orderNum", orderNum);
            VarPost.Add("platOrderNum", platOrderNum);
            VarPost.Add("dateTime", dateTime);
            List<string> paramNameList = new List<string>();
            foreach (string key in VarPost.Keys)
            {
                paramNameList.Add(key);
            }
            paramNameList.Sort();
            StringBuilder stringBuilder = new StringBuilder();
            for (int i = 0; i < paramNameList.Count; i++)
            {
                string key = paramNameList[i];
                stringBuilder.Append(VarPost[key]); 
            }
            string keyStr = stringBuilder.ToString();
            int len = keyStr.Length;
            string signedStr = "";
            try
            {
                RSAForJava rsa = new RSAForJava();
                signedStr = rsa.EncryptByPrivateKey(keyStr, MCH_PRIVATE_KEY);
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.Message);
            }
            VarPost.Add("sign", signedStr);

            WebClient w = new WebClient();
            w.Headers[HttpRequestHeader.ContentType] = "application/json";
            string jsonStr = JsonNewtonsoft.SerializeDictionaryToJsonString(VarPost);
            Console.WriteLine("postJson:" + jsonStr);  
            string sRemoteInfo = w.UploadString(payUrl, "POST", jsonStr);
        }

    }
}

package main

import (
	"bytes"
	"encoding/base64"
	"encoding/json"
	"fmt"
	"io/ioutil"
	"net/http"
	"reflect"
	"sort"
	"strings"
)

type RequestBody struct {
	MerchantCode string `json:"merchantCode"`
	QueryType    string `json:"queryType"`
	OrderNum     string `json:"orderNum"`
	PlatOrderNum string `json:"platOrderNum"`
	DateTime     string `json:"dateTime"`
	Sign         string `json:"sign"`
}

func main() {
	cryptor := NewCryptor()
	cryptor.Pub64 = "MIGfMA0GC.......D37Bj0wIDAQAB"
	cryptor.Pri64 = "MIICdwIBA.........JwSWWBDEfuk="
	
	url := "https://vnm-openapi.toppay.asia/gateway/query"
	request := RequestBody{
		MerchantCode: "S820250514103726000009",
		OrderNum: "H202404161637",
		QueryType: "CASH_QUERY",
		DateTime: "20220101235959",
		PlatOrderNum: "W0626134353455545056289",
	}
	sortedValues, err := sortedConcatenatedValues(request)
	if err != nil {
		fmt.Printf("Error: %s\n", err)
		return
	}
	encryptedData := cryptor.PriEncrypt([]byte(sortedValues))
	encodedString := base64.StdEncoding.EncodeToString(encryptedData)
	request.Sign = encodedString
	jsonBytes, err := json.Marshal(request)
	if err != nil {
		fmt.Printf("Error: %s", err.Error())
		return
	}
	fmt.Println("json2", bytes.NewBuffer(jsonBytes))
	req, err := http.NewRequest("POST", url, bytes.NewBuffer(jsonBytes))
	if err != nil {
		fmt.Println("Error creating HTTP request:", err)
		return
	}
	req.Header.Set("Content-Type", "application/json")
	client := &http.Client{}
	resp, err := client.Do(req)
	if err != nil {
		fmt.Println("Error sending HTTP request:", err)
		return
	}
	defer resp.Body.Close()
	respBody, err := ioutil.ReadAll(resp.Body)
	if err != nil {
		fmt.Println("Error reading response body:", err)
		return
	}
	fmt.Println("Response Body:", string(respBody))
}

func sortedConcatenatedValues(v interface{}) (string, error) {
	valueOf := reflect.ValueOf(v)
	typeOf := valueOf.Type()
	kv := make(map[string]string)
	for i := 0; i < valueOf.NumField(); i++ {
		field := typeOf.Field(i)
		jsonTag := field.Tag.Get("json")
		if jsonTag == "" || jsonTag == "-" {
			continue
		}
		tagName := strings.Split(jsonTag, ",")[0] // 忽略omitempty选项
		kv[tagName] = fmt.Sprint(valueOf.Field(i).Interface())
	}
	keys := make([]string, 0, len(kv))
	for k := range kv {
		keys = append(keys, k)
	}
	sort.Strings(keys)
	var concatenatedValues strings.Builder
	for _, key := range keys {
		concatenatedValues.WriteString(kv[key])
	}
	return concatenatedValues.String(), nil
}

import json
import requests
import base64
import easyocr
from M2Crypto import RSA
from collections import OrderedDict

class TopQueryDemo:
    MCH_PRI_KEY_FILE = '\data\company_rsa_private_key.pem'
    MCH_PUBLIC_KEY_FILE = '\data\plat_rsa_public_key.pem'
    MCH_ID = "S820250514103726000009"
    pay_url = " https://vnm-openapi.toppay.asia/gateway/query"

    @staticmethod
    def cash():
        request_params = OrderedDict()
        request_params["merchantCode"] = TopQueryDemo.MCH_ID
        request_params["queryType"] = "ORDER_QUERY"
        request_params["orderNum"] = "Disbursement"
        request_params["platOrderNum"] = "T1642592278863"
        request_params["dateTime"] = "20220101235959"

        key_str = ''.join([str(value) for value in request_params.values()])
        print("keyStr:", key_str)

        signed_str = TopQueryDemo.private_encrypt(key_str, TopQueryDemo.MCH_PRI_KEY_FILE)
        request_params["sign"] = signed_str

        post_json = json.dumps(request_params)
        print("Post Json Params:", post_json)

        response_json = TopQueryDemo.do_post(TopQueryDemo.pay_url, post_json)
        print("Response Msg:", response_json)

        check = TopQueryDemo.public_key_decrypt(signed_str, TopQueryDemo.MCH_PUBLIC_KEY_FILE);
        print("check:", check)

    @staticmethod
    def private_encrypt(data, prikey_file):
        rsa_pri = RSA.load_key(prikey_file)
        crypto = b''
        for chunk in [data[i:i + 117] for i in range(0, len(data), 117)]:
            encrypt_data = rsa_pri.private_encrypt(chunk.encode('utf-8'), RSA.pkcs1_padding)
            crypto += encrypt_data
        return base64.b64encode(crypto).decode('utf-8')


    @staticmethod
    def public_key_decrypt(data, public_file):
        rsa_key = RSA.load_pub_key(public_file)
        data = base64.b64decode(data)
        crypto = b''
        for chunk in [data[i:i+128] for i in range(0, len(data), 128)]:
            decrypt_data = rsa_key.public_decrypt(chunk, RSA.pkcs1_padding)
            crypto += decrypt_data
        return crypto.decode('utf-8')
    @staticmethod
    def do_post(url, data):
        headers = {"Content-Type": "application/json"}
        response = requests.post(url, data=data, headers=headers)
        if response.status_code == 200:
            return response.json()
        return None

if __name__ == '__main__':
    TopPayDemo.pay()

const { encryptWithPrivateKey } = require('./RSAUtil');
const axios = require('axios');

var merchantCode = 'S820250514103726000009'
var queryType = 'ORDER_QUERY'
var orderNum = 'H202405061145003'
var platOrderNum = 'PR216513636130'
var dateTime = '20240430112200'
const data = {
    merchantCode: merchantCode,
    queryType: queryType,
    orderNum: orderNum,
    platOrderNum: platOrderNum,
    dateTime: dateTime
};

const sortedKeys = Object.keys(data).sort();

let sortedString = '';
sortedKeys.forEach(key => {
    sortedString += data[key];
});

console.log(sortedString);
var sign = encryptWithPrivateKey(sortedString);
data.sign = sign;
const jsonData = JSON.stringify(data);
console.log(jsonData)

var url = 'https://vnm-openapi.toppay.asia/gateway/query'

axios.post(url, jsonData,{
    headers: {
      'Content-Type': 'application/json'
    }
  })
  .then((response) => {
    console.log('Code:', response.status);
    console.log('Message:', response.data);
  })
  .catch((error) => {
    console.error('Fail:', error);
  });

Api Address

• Method : POST
• Address : https://vnm-openapi.toppay.asia/gateway/query

Request Params

• Note: Either the merchant order number or the platform order number must be passed, or both can be passed

Params	Required	Desc	Ex
merchantCode	Y	MchId	S820190712000002
queryType	Y	Query Type	Collection:ORDER_QUERY Cash:CASH_QUERY
orderNum	Y	Merchant order number	T1231511321515
platOrderNum	Y	Platform order number	PRE1234567890
dateTime	Y	Timestamp	20191018105510 yyyy-MM-dd HH:mm:ss
sign	Y	Sign	ja6R8eukQ...

Request Example

{
  "dateTime": "20220101105500",
  "merchantCode": "S820211021094748000001",
  "orderNum": "T1642593166888",
  "platOrderNum": "PRE1642593166888",
  "queryType": "ORDER_QUERY",
  "sign": "lGw1OJcuUL0MGaIq44U2u2bFM5dalJJuT/G6mQWbIBT9dmVAJaLwR125emPDXYYSdnOtNxja86A2VJJLf40BCg2HevHolebvt2ay3ukCQaUhwNkIGz4KF0Ud+XMUA36LoFTWZbDYv9y8vgCnWxwZFKj7ePrfLxc+TA7jpqv65lQ\u003d"
}

Response Params

Params	Type	Required	Desc	Ex
success	BOOLEAN	Y	Response Result	true/false
code	int	Y	Code	1000-Request Success, all others are failures
message	String	Y	Message	success
data	Json	Y	Data	The following parameters are returned in data, or null if failed
msg	String	Y	msg	Request Transaction Success
platOrderNum	String	Y	Platform order number	PI1453242857400963072
amount	String	Y	Order Amount	10000.00
orderNum	String	Y	Merchant order number	23645782
status	int/String	Y	Order Status	Order Status

• Collection Response Example

{
  "success": true,
  "code": 1000,
  "message": "Success",
  "data": {
    "msg": "Payment Success",
    "platOrderNum": "PRE1483771634191044608",
    "amount": "150",
    "orderNum": "T1642593166888",
    "status": "SUCCESS"
  }
}

• Cash Response Example

{
  "success": true,
  "code": 1000,
  "message": "Success",
  "data": {
    "msg": "test cash",
    "platOrderNum": "W0620220119174331000001",
    "amount": "125",
    "orderNum": "186888188666",
    "status": 2
  }
}