Last active
March 2, 2018 11:49
-
-
Save primozcigler/578b04d3f5339ef1bf865d3e06f3ae2d to your computer and use it in GitHub Desktop.
Sum billing report values from templatemonster chrome snippet
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// 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