我們需要一個函數來計算周的總計數：
function getISOWeeks(y) {
var d,
isLeap;
d = new Date(y, 0, 1);
isLeap = new Date(y, 1, 29).getMonth() === 1;
//check for a Jan 1 that's a Thursday or a leap year that has a
//Wednesday jan 1. Otherwise it's 52
return d.getDay() === 4 || isLeap && d.getDay() === 3 ? 53 : 52
}
還有一個得到周數的函數：
function getWeek(date_string) {
let [d, M, y] = date_string.split(/[- :]/);
let passedDate = new Date(y, parseInt(M) - 1, d);
let onejan = new Date(passedDate.getFullYear(), 0, 1);
week = Math.ceil( (((passedDate - onejan) / 86400000) + onejan.getDay() + 1) / 7 );
return week;
}
在我們經歷了這周之后，我們每周計算人數。然后我們可以計算出一整年中每周有多少人在工作。
let weeks = dateRanges.map(s => s.map(d => this.getWeek(d)));
let distinctWeeks = weeks.map(s =>
s.filter((item, pos) => s.indexOf(item) == pos)).flatMap(s => s);
let personPerWeek = distinctWeeks.reduce((a, c)=> {
a[c] = a[c] || 0;
a[c] += 1;
return a;
},{})
const weekCount = getISOWeeks(2020);
let personsPerWeeks = [];
getWorkWeeks = (workWeeks, weekCount) => {
for (let index = 1; index <= weekCount; index++) {
let personCount = personPerWeek[index] || 0;
workWeeks.push(personCount);
}
return workWeeks;
}
一個例子可以在這里看到：
function getWeek(date_string) {
let [d, M, y] = date_string.split(/[- :]/);
let passedDate = new Date(y, parseInt(M) - 1, d);
let onejan = new Date(passedDate.getFullYear(), 0, 1);
week = Math.ceil( (((passedDate - onejan) / 86400000) + onejan.getDay() + 1) / 7 );
return week;
}
function getISOWeeks(y) {
var d,
isLeap;
d = new Date(y, 0, 1);
isLeap = new Date(y, 1, 29).getMonth() === 1;
//check for a Jan 1 that's a Thursday or a leap year that has a
//Wednesday jan 1. Otherwise it's 52
return d.getDay() === 4 || isLeap && d.getDay() === 3 ? 53 : 52
}
let dateRanges = [
['01-01-2020', '03-01-2020'], //week 1
['03-01-2020', '06-01-2020'], //week 1 and 2
['09-01-2020', '09-01-2020'], //week 2
['10-01-2020', '11-01-2020'], //week 2
['22-01-2020', '23-01-2020'], //week 4
];
let weeks = dateRanges.map(s => s.map(d => this.getWeek(d)));
let distinctWeeks = weeks.map(s => s.filter((item, pos) => s.indexOf(item) == pos)).flatMap(s => s);
let personPerWeek = distinctWeeks.reduce((a, c)=> {
a[c] = a[c] || 0;
a[c] += 1;
return a;
},{})
const weekCount = getISOWeeks(2020);
let personsPerWeeks = [];
getWorkWeeks = (workWeeks, weekCount) => {
for (let index = 1; index <= weekCount; index++) {
let personCount = personPerWeek[index] || 0;
workWeeks.push(personCount);
}
return workWeeks;
}
getWorkWeeks(personsPerWeeks, weekCount);
console.log(personsPerWeeks)
