tlushim.co.il hours summary

tlushim-summary.js

var hours = [];
    totalMinutes = 0,
    maxMinutes = 0;
    minMinutes = Number.MAX_VALUE;

Array.prototype.forEach.call(document.querySelectorAll('table.atnd > tbody > tr'), function (tr) {
	// if there is an error td, then don't count that row
	var errorTd = tr.querySelectorAll('td.atnd_error');

	if (errorTd && errorTd.length > 0) {
		return;
	}

	var td = tr.querySelectorAll('td')[4];	
	var time = td ? td.innerText : null;
	var minutesInADay = 0;

	if (time && time.match(/\d+:\d+/)) {
		hours.push(time);
		var timeParts = time.split(':');
		
		minutesInADay +=	parseInt(timeParts[0]) * 60;
		minutesInADay +=	parseInt(timeParts[1]);

		totalMinutes += minutesInADay;
		maxMinutes = Math.max(maxMinutes, minutesInADay);
		minMinutes = Math.min(minMinutes, minutesInADay);

	}
});

console.log('Total worked:', totalMinutes / 60, 'Shouldve been working:', hours.length * 9, 'Days:', hours.length, 'Max:', maxMinutes/60, 'Min:', minMinutes/60);
console.log('Hours:',  hours);