#!/bin/bash -e

ID=...
COOKIE=...
OUTPUT=data.csv
echo "Date,Amount" > "$OUTPUT"

DATE="2007-02-01"  # Adjust based on your data to make it run faster
NOW="$(date +%Y-%m-%d)"
while [[ $DATE < $NOW ]]; do
  curl 'https://mint.intuit.com/pfm/v1/trends' \
    -H 'authority: mint.intuit.com' \
    -H 'accept: application/json, text/plain, */*' \
    -H 'accept-language: en-US,en;q=0.9' \
    -H 'authorization: Intuit_APIKey intuit_apikey=prdakyresYC6zv9z3rARKl4hMGycOWmIb4n8w52r,intuit_apikey_version=1.0' \
    -H 'content-type: application/json' \
    -H "cookie: $COOKIE" \
    -H 'intuit_tid: 27b096e4-5d76-4e55-958a-d01430a39a97' \
    -H 'origin: https://mint.intuit.com' \
    -H 'referer: https://mint.intuit.com/trends' \
    -H 'sec-ch-ua: "Microsoft Edge";v="119", "Chromium";v="119", "Not?A_Brand";v="24"' \
    -H 'sec-ch-ua-mobile: ?0' \
    -H 'sec-ch-ua-platform: "Windows"' \
    -H 'sec-fetch-dest: empty' \
    -H 'sec-fetch-mode: cors' \
    -H 'sec-fetch-site: same-origin' \
    -H 'user-agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36 Edg/119.0.0.0' \
    --compressed \
    --data @- <<EOF | jq -r '.Trend[]? | [.name, .amount] | @csv' >> "$OUTPUT"
{
  "reportView": {
    "type": "NET_WORTH"
  },
  "searchFilters": [
    {
      "matchAll": true,
      "filters": [
        {
          "type": "AccountIdFilter",
          "accountId": "$ID"
        }
      ]
    },
    {
      "matchAll": false,
      "filters": []
    }
  ],
  "dateFilter": {
    "type": "CUSTOM",
    "startDate": "$DATE",
    "endDate": "$(date +%Y-%m-%d -d "$DATE + 43 days")"
  },
  "offset": 0,
  "limit": 1000
}
EOF

  DATE=$(date +%Y-%m-%d -d "$DATE + 44 days")
done

await (async function(console) {
  let begin = new Date();

  // Fetch list of accounts
  let accounts = await fetch("https://mint.intuit.com/pfm/v1/accounts?offset=0&limit=1000", {
    "headers": {
      "authorization": "Intuit_APIKey intuit_apikey=prdakyresYC6zv9z3rARKl4hMGycOWmIb4n8w52r,intuit_apikey_version=1.0",
      "content-type": "application/json",
      "intuit_tid": "0dc9c908-ef3d-4d97-93eb-a676a74b0cb2",
    },
    "body": null,
    "method": "GET",
    "mode": "cors",
    "credentials": "include"
  }).then(
    response => response.json()
  ).then(
    result => result.Account ?? []
  );
  console.log("Accounts:", accounts);

  // data[date][account] = amount
  let data = {};
  for (const [index, account] of accounts.entries()) {
    const isDebtAccount = (account.type == "CreditAccount" || account.type == "LoanAccount");
    let ids = [account.id];
    if (isDebtAccount) {
      // Querying net worth doesn't seem to work for debt accounts, unless
      // there is at least one assert account that covers the same date range.
      // To work around this, add the bank accounts to the query, so that a
      // mix of ASSET and DEBT entries are returned. (The ASSET entries are
      // filtered out below).
      ids.push(...accounts.filter(({type}) => (type == 'BankAccount')).map(({id}) => id));
    }
    console.log(`Fetching account ${index+1}/${accounts.length}: ${account.name}`)
    let queries = [];
    for (let start = new Date('2007-01-01'); start < new Date(); start.setUTCDate(start.getUTCDate()+44)) {
      // Query data for date range in parallel
      let end = new Date(start-1); end.setUTCDate(end.getUTCDate()+44);
      queries.push(fetch("https://mint.intuit.com/pfm/v1/trends", {
        "headers": {
          "authorization": "Intuit_APIKey intuit_apikey=prdakyresYC6zv9z3rARKl4hMGycOWmIb4n8w52r,intuit_apikey_version=1.0",
          "content-type": "application/json",
          "intuit_tid": "0dc9c908-ef3d-4d97-93eb-a676a74b0cb2",
        },
        "body": JSON.stringify({
          "reportView": {
            "type": "NET_WORTH"
          },
          "searchFilters": [
            {
              "matchAll": true,
              "filters": ids.map(id => ({ "type": "AccountIdFilter", "accountId": id })),
            },
          ],
          "dateFilter": {
            "type": "CUSTOM",
            "startDate": start.toISOString().substring(0,10),
            "endDate": end.toISOString().substring(0,10),
          },
          "offset": 0,
          "limit": 1000,
        }),
        "method": "POST",
        "mode": "cors",
        "credentials": "include",
      }).then(
        response => response.json()
      ).then(result => {
        let trends = result.Trend ?? [];
        //console.log("Trends:", trends)
        for (const {name: date, type, amount} of trends) {
          if (isDebtAccount && type == 'DEBT') {
            (data[date] ??= {})[account.id] = -amount;
          } else if (!isDebtAccount && type == 'ASSET') {
            (data[date] ??= {})[account.id] = amount;
          }
        }
      }));

      // Wait for some requests to complete so that we don't get trottled
      if (queries.length >= 10) {
        await Promise.all(queries);
        queries = [];
      }
    }
    // Wait for remaining requests to complete
    await Promise.all(queries);

    // Wiggle mouse to keep from getting logged out
    document.body.dispatchEvent(new MouseEvent("mousedown"))
  }

  // Build csv content
  console.log("Data:", data);
  let csv_lines = [[`"Date"`, ...accounts.map(({name}) => `"${name}"`)].join(",")];
  for (const date of Object.keys(data).sort((a, b) => (new Date(a) - new Date(b)))) {
    csv_lines.push([`"${date}"`, ...accounts.map(({id}) => `"${data[date][id] ?? ""}"`)].join(","));
  }

  // Save csv file
  const blob = new Blob([csv_lines.join("\r\n")], {type: 'text/csv'});
  let a = document.createElement('a');
  a.download = "mint_bal_history.csv"
  a.href = window.URL.createObjectURL(blob)
  a.dataset.downloadurl =  ['text/csv', a.download, a.href].join(':')
  a.dispatchEvent(new MouseEvent("click"))
  console.log(`Finished in ${(new Date() - begin)/60000} minutes`)
})(console)