Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
Sum billing report values from templatemonster chrome snippet
// Go to https://account.templatemonster.com/#/billing and scroll down to show enough BILLING HISTORY items
// Then run the script
{
const dateRegex = /aug \d+, 2017/i
// startDate = new Date('2017-8-1 00:00:00'),
// endDate = new Date('2017-9-1 00:00:00'),
allRows = Array.from($$( '.billing-history-operation' ));
let rowsWithinTimeFrame = [];
rowsWithinTimeFrame = allRows.filter(($row) => {
let rowDate = $row.querySelector('.billing-history-operation-info__date').innerText;
// rowDate = new Date(rowDate);
return dateRegex.test(rowDate);
// return daterowDate >= startDate && rowDate < endDate;
});
rowsWithinTimeFrame.reduce((sum, $row) => {
let $moneyNode = $row.querySelector('.billing-history-operation-info__balance .format-currency'),
$centsNode,
dollars = $moneyNode.innerText;
dollars = parseFloat(dollars.match(/[\d\.]+/)[0]);
if ($row.classList.contains('billing-history-operation_type_refund')) { // refunds are negative
dollars = -dollars;
}
return sum + dollars;
}, 0);
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment