挖财账单导出
挖财账单接口数据转换为markdown文件。
挖财记账数据不能免费导出，需要￥50升级为vip才能导出。自己记账的数据，自己都不能导出，相当可恶。因此用程序员的方法将自己的数据导出来。主要是两步，通过挖财pc端接口获取数据，然后将这些数据转换一下。
1、获取账单明细
1、挖财网站 https://user.wacai.com/reform/web/login
2、时间戳在线工具 https://tool.lu/timestamp/
时间 毫秒值
2013-01-01 00:00:00 1356969600000
2020-01-01 00:00:00 1577808000000
3、挖财数据明细
接口
https://www.wacai.com/activity/bkk-frontier/api/v2/flow/list/web?___t=1616121710537 POST
传参
Headers
Content-Type application/json
Cookie --
Body
{"bkId":123456,"startTime":1356969600000,"endTime":1577808000000,"queryFlowCount":true,"recTypeList":null,"mainTypeIdList":null,
"subTypeIdList":null,"accountIdList":null,"projectIdList":null,"tradetgtIdList":null,"memberIdList":null,"reimburseList":null,"comment":"",
"amountStart":null,"amountEnd":null,"pageSize":9000,"pageIndex":1}
2、java解析数据
package com.xu.spring.test.common.util;
import com.alibaba.fastjson.JSONArray;
import com.alibaba.fastjson.JSONObject;
import java.io.*;
import java.math.BigDecimal;
import java.nio.ByteBuffer;
import java.nio.channels.FileChannel;
import java.text.SimpleDateFormat;
import java.util.Date;
import java.util.Optional;
/**
* 挖财账单接口数据转换为markdown文件
*
* @date 2021/3/19 11:22
*/
public class WaiCaiDataParseUtil {
/**
*
1、挖财网站 https://user.wacai.com/reform/web/login
2、时间戳在线工具 https://tool.lu/timestamp/
时间 毫秒值
2013-01-01 00:00:00 1356969600000
2020-01-01 00:00:00 1577808000000
3、挖财数据明细
接口
https://www.wacai.com/activity/bkk-frontier/api/v2/flow/list/web?___t=1616121710537 POST
传参
Headers
Content-Type application/json
Cookie --
Body
{"bkId":123456,"startTime":1356969600000,"endTime":1577808000000,"queryFlowCount":true,"recTypeList":null,"mainTypeIdList":null,
"subTypeIdList":null,"accountIdList":null,"projectIdList":null,"tradetgtIdList":null,"memberIdList":null,"reimburseList":null,"comment":"",
"amountStart":null,"amountEnd":null,"pageSize":9000,"pageIndex":1}
*/
/*** 时间格式化*/
public static final SimpleDateFormat SIMPLE_DATE_FORMAT = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss ");
private static Integer year = 0;
private static Integer categoryNameLength = 4;
public static void main(String[] args) throws IOException {
String filePath = "D:\\waicai_data.txt";
parse(filePath);
}
private static void parse(String filePath) throws IOException {
String text = importFile2String(filePath);
File file = new File("D:\\挖财账单" + System.currentTimeMillis() + ".md");
if (!file.exists()) {
file.createNewFile();
}
FileOutputStream fos = new FileOutputStream(file, true);
OutputStreamWriter osw = new OutputStreamWriter(fos);
BufferedWriter bw = new BufferedWriter(osw);
JSONObject object = JSONObject.parseObject(text);
JSONObject data = object.getJSONObject("data");
Integer flowCount = data.getInteger("flowCount");
JSONArray dailyItems = data.getJSONArray("dailyItems");
System.out.println(String.format("flowCount=%s,dailyItems_size=%s", flowCount, dailyItems.size()));
bw.write("## 挖财账单");
bw.newLine();
for (int i = 0; i < dailyItems.size(); i++) {
JSONObject item = dailyItems.getJSONObject(i);
JSONArray flowList = item.getJSONArray("flowList");
for (int j = 0; j < flowList.size(); j++) {
JSONObject flow = flowList.getJSONObject(j);
String comment = flow.getString("comment");
String currencyFlag = flow.getString("currencyFlag");
Integer amount = flow.getInteger("amount");
String bizTime = flow.getString("bizTime");
isNewYear(bizTime, bw);
String categoryName = flow.getString("categoryName");
String tradetgtName = flow.getString("tradetgtName");
StringBuilder builder = new StringBuilder();
builder.append("|").append(assembleTime(bizTime)).append("|").append(assembleCategory(categoryName)).append("|")
.append(assembleAmount(currencyFlag, amount)).append("|").append(Optional.ofNullable(tradetgtName).orElse(" - "))
.append("|").append(comment.replaceAll("\\n", "。")).append("|");
bw.write(builder.toString());
bw.newLine();
bw.flush();
}
}
bw.close();
osw.close();
fos.close();
}
private static void isNewYear(String bizTime, BufferedWriter bw) throws IOException {
String yearText = SIMPLE_DATE_FORMAT.format(new Date(Long.valueOf(bizTime))).substring(0, 4);
Integer currentYear = Integer.parseInt(yearText);
if (year == 0 || !currentYear.equals(year)) {
bw.newLine();
bw.write("### " + yearText);
bw.newLine();
year = currentYear;
titleRow(bw);
}
}
private static String assembleAmount(String currencyFlag, Integer amount) {
String s = currencyFlag + new BigDecimal(amount).divide(new BigDecimal(100)).toEngineeringString();
return s.length() == 6 ? s : blankText(6 - s.length()) + s;
}
private static String assembleCategory(String categoryName) {
return categoryName.length() == categoryNameLength ? categoryName : blankText((categoryNameLength - categoryName.length()) * 2) + categoryName;
}
private static String blankText(int n) {
StringBuilder builder = new StringBuilder();
for (int i = 0; i < n; i++) {
builder.append(" ");
}
return builder.toString();
}
private static String assembleTime(String bizTime) {
return SIMPLE_DATE_FORMAT.format(new Date(Long.valueOf(bizTime)));
}
private static void titleRow(BufferedWriter bw) throws IOException {
StringBuilder builder = new StringBuilder();
builder.append("|时间").append(blankText(16)).append("|").append("类别").append(blankText(4)).append("|")
.append("金额").append(blankText(2)).append("|").append("商家").append(blankText(2)).append("|").append("内容").append("|");
bw.write(builder.toString());
bw.newLine();
bw.write("| ------------------ | ------ | ---- | ---- | ---- |");
bw.newLine();
}
/**
* 文件导入为字符串
*
* @param filePath
* @return
*/
private static String importFile2String(String filePath) {
StringBuffer sb = new StringBuffer();
try {
long time = System.currentTimeMillis();
File file = new File(filePath);
if (!file.exists()) {
throw new FileNotFoundException("file not found");
}
RandomAccessFile raf = new RandomAccessFile(file, "rw");
FileChannel cha = raf.getChannel();
ByteBuffer buf = ByteBuffer.allocate(1024);
int size = 0;
while ((size = cha.read(buf)) != -1) {
buf.flip();
byte[] buff = new byte[size];
buf.get(buff);
sb.append(new String(buff, 0, size));
}
// System.out.println(System.currentTimeMillis() - time);
} catch (Exception e) {
e.printStackTrace();
}
return sb.toString();
}
}