JVAV - 对接支付宝- 下载对账单接口

支付宝的对接文档

https://opendocs.alipay.com/apis/02byuu

import com.alipay.api.AlipayClient;

public vid aliPayBills(String billDate, PayAccountConfig accountConfig) throws Exception {

        AlipayClient alipayClient = getInstance();
        AlipayDataDataserviceBillDownloadurlQueryRequest request = new AlipayDataDataserviceBillDownloadurlQueryRequest();
        Map<String, String> params = new HashMap<>();
        params.put("bill_type", "signcustomer");
        params.put("bill_date", billDate);
        request.setBizContent(JSON.toJSONString(params));
        AlipayDataDataserviceBillDownloadurlQueryResponse response = alipayClient.certificateExecute(request);
        if (response.isSuccess()) {
            String payBillsPath = aliPayBillsPath;
            //获取支付宝对账单URL（url有效时间为30秒）
            String url = response.getBillDownloadUrl();
            log.info("***************获取到的支付宝对账单的URL：" + url + "**********************");
            String newZip = payBillsPath + new Date().getTime() + ".zip";
            // 开始下载 （下载文件为zip）
            SaveFile.downloadNet(url, newZip, payBillsPath);
            //解压（解压后有两个文件，明细，明细汇总）
            SaveFile.unZip(newZip, payBillsPath);
            log.info("***************下载，解压完成**********************");
            //获取解压后的两个文件
            File[] fs = new File(payBillsPath).listFiles();
            //用来保存明细的数据
            ArrayList<String[]> csvList = new ArrayList<>();
            String fileName = "";
            //获取对账单明细（只需要处理明细文件）
            for (File file : fs) {
                if (!file.getAbsolutePath().contains("汇总") && !file.getAbsolutePath().contains("zip")) {
                    fileName = file.getAbsolutePath();
                    csvList = getFileCell(fileName);
                }
            }
            File file2 = new File(fileName);
            FileInputStream inputStream = new FileInputStream(file2);
            MultipartFile multipartFile = new MockMultipartFile(file2.getName(), file2.getName(), ContentType.APPLICATION_OCTET_STREAM.toString(), inputStream);
            String originalFilename = multipartFile.getOriginalFilename();
            OssUtil.uploadFile(bucketName, originalFilename, multipartFile, "/paybills");

            for (File file : fs) {
                if (file.isFile()) {
                    SaveFile.delFile(file.getAbsolutePath());
                } else {
                    SaveFile.delFolder(file.getAbsolutePath());
                }
            }
            return csvList;
        } else {
            System.out.println("调用失败");
            return null;
        }
    }

工具类：支护宝API请求初始化

public static AlipayClient getInstance() throws Exception {
        if (Instance == null) {
            synchronized (AlipayClient.class) {
                if (Instance == null) {
                    //构造client
                    CertAlipayRequest certAlipayRequest = new CertAlipayRequest();
                    //设置网关地址
                    certAlipayRequest.setServerUrl("https://openapi.alipay.com/gateway.do");
                    //设置应用Id
                    certAlipayRequest.setAppId(appId);
                    //设置应用私钥
                    certAlipayRequest.setPrivateKey(privateKey);
                    //设置请求格式，固定值json
                    certAlipayRequest.setFormat("json");
                    //设置字符集
                    certAlipayRequest.setCharset(CPayConfig.CHARSET);
                    //设置签名类型
                    certAlipayRequest.setSignType(CPayConfig.ALI_SIGN_TYPE);
                    //设置应用公钥证书路径
                    certAlipayRequest.setCertPath(appCertPath);
                    //设置支付宝公钥证书路径
                    certAlipayRequest.setAlipayPublicCertPath(aliPayCertPath);
                    //设置支付宝根证书路径
                    certAlipayRequest.setRootCertPath(aliPayRootCertPath);
                    //构造client
                    return new DefaultAlipayClient(certAlipayRequest);
                }
            }
        }
        return Instance;
    }

文件工具

import lombok.extern.slf4j.Slf4j;
import org.apache.commons.compress.archivers.zip.ZipArchiveEntry;
import org.apache.commons.compress.archivers.zip.ZipFile;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.core.env.Environment;

import java.io.*;
import java.net.HttpURLConnection;
import java.net.MalformedURLException;
import java.net.URL;
import java.net.URLConnection;
import java.util.Enumeration;
import java.util.zip.ZipEntry;

/**
 * 根据url下载文件到本地指定目录
 * 然后上传到服务器
 *
 * @Author stone
 * @Date 2020/07/21
 * @return
 */
@Slf4j
public class SaveFile {

    /**
     * 使用GBK编码可以避免压缩中文文件名乱码
     */
    private static final String CHINESE_CHARSET = "GBK";

    /**
     * 文件读取缓冲区大小
     */
    private static final int CACHE_SIZE = 1024;

    /**
     * 根据Url下载文件
     *
     * @param urlStr
     * @param fileName
     * @param savePath
     * @throws IOException
     */
    public static void downLoadFromUrl(String urlStr, String fileName,
                                       String savePath) throws IOException {
        URL url = new URL(urlStr);
        HttpURLConnection conn = (HttpURLConnection) url.openConnection();
        //设置超时间为3秒
        conn.setConnectTimeout(3 * 1000);
        //防止屏蔽程序抓取而返回403错误
        conn.setRequestProperty("User-Agent", "Mozilla/4.0 (compatible; MSIE 5.0; Windows NT; DigExt)");

        //得到输入流
        InputStream inputStream = conn.getInputStream();
        //获取自己数组
        byte[] getData = readInputStream(inputStream);

        //文件保存位置
        File saveDir = new File(savePath);
        if (!saveDir.exists()) {
            saveDir.mkdir();
        }
        File file = new File(saveDir + File.separator + fileName);
        FileOutputStream fos = new FileOutputStream(file);
        fos.write(getData);
        if (fos != null) {
            fos.close();
        }
        if (inputStream != null) {
            inputStream.close();
        }
        log.info("info: {} download success ", url);
    }

    public static void delFile(String path) {
        File file = new File(path);
        if (!file.exists()) return;

        if (file.isFile() || file.list() == null) {
            file.delete();
            log.info("the file:{} has been deleted", file.getName());
        }
    }

    public static void delFolder(String folderPath) {
        try {
            delAllFile(folderPath); // 删除完里面所有内容
            String filePath = folderPath;
            filePath = filePath.toString();
            java.io.File myFilePath = new java.io.File(filePath);
            myFilePath.delete(); // 删除空文件夹
        } catch (Exception e) {
            e.printStackTrace();
        }
    }


    public static boolean delAllFile(String path) {
        boolean flag = false;
        File file = new File(path);
        if (!file.exists()) {
            return flag;
        }
        if (!file.isDirectory()) {
            return flag;
        }
        String[] tempList = file.list();
        File temp = null;
        for (int i = 0; i < tempList.length; i++) {
            if (path.endsWith(File.separator)) {
                temp = new File(path + tempList[i]);
            } else {
                temp = new File(path + File.separator + tempList[i]);
            }
            if (temp.isFile()) {
                temp.delete();
            }
            if (temp.isDirectory()) {
                delAllFile(path + "/" + tempList[i]);// 先删除文件夹里面的文件
                delFolder(path + "/" + tempList[i]);// 再删除空文件夹
                flag = true;
            }
        }
        return flag;
    }

    /**
     * 从输入流中获取字节数组
     *
     * @param inputStream
     * @return
     * @throws IOException
     */
    public static byte[] readInputStream(InputStream inputStream) throws IOException {
        byte[] buffer = new byte[1024];
        int len = 0;
        ByteArrayOutputStream bos = new ByteArrayOutputStream();
        while ((len = inputStream.read(buffer)) != -1) {
            bos.write(buffer, 0, len);
        }
        bos.close();
        return bos.toByteArray();
    }

    public static void downloadNet(String path, String filePath,String filePath1)
            throws MalformedURLException {
        // 下载网络文件
        int bytesum = 0;
        int byteread = 0;

        URL url = new URL(path);

        //文件保存位置
        File saveDir = new File(filePath1);
        if (!saveDir.exists()) {
            saveDir.mkdir();
        }
        try {
            URLConnection conn = url.openConnection();
            InputStream inStream = conn.getInputStream();
            FileOutputStream fs = new FileOutputStream(filePath);

            byte[] buffer = new byte[1204];
            while ((byteread = inStream.read(buffer)) != -1) {
                bytesum += byteread;
                fs.write(buffer, 0, byteread);
            }
        } catch (FileNotFoundException e) {
            e.printStackTrace();
        } catch (IOException e) {
            e.printStackTrace();
        }
    }


    /**
     * 解压到指定目录
     *
     * @param zipFilePath
     * @param destDir
     * @throws Exception
     */
    public static void unZip(String zipFilePath, String destDir)
            throws Exception {

        ZipFile zipFile = new ZipFile(zipFilePath, CHINESE_CHARSET);
        Enumeration<?> emu = zipFile.getEntries();
        BufferedInputStream bis;
        FileOutputStream fos;
        BufferedOutputStream bos;
        File file, parentFile;
        ZipEntry entry;
        byte[] cache = new byte[CACHE_SIZE];
        while (emu.hasMoreElements()) {
            entry = (ZipEntry) emu.nextElement();
            if (entry.isDirectory()) {
                new File(destDir + entry.getName()).mkdirs();
                continue;
            }
            bis = new BufferedInputStream(zipFile.getInputStream((ZipArchiveEntry) entry));
            file = new File(destDir + entry.getName());
            parentFile = file.getParentFile();
            if (parentFile != null && (!parentFile.exists())) {
                parentFile.mkdirs();
            }
            fos = new FileOutputStream(file);
            bos = new BufferedOutputStream(fos, CACHE_SIZE);
            int nRead = 0;
            while ((nRead = bis.read(cache, 0, CACHE_SIZE)) != -1) {
                fos.write(cache, 0, nRead);
            }
            bos.flush();
            bos.close();
            fos.close();
            bis.close();
        }
        zipFile.close();
    }
}