How can I calculate the number of check-ins per week in a month using Javascript? I have been unable to find relevant code for this task.
Specifically, I am interested in determining the total count of user check-ins on a weekly basis. For example, if a user makes 1 or 4 check-ins during the week from 10/29/23 to 11/04/23 (defining a week as starting on Sunday and ending on Saturday).
In cases where a user exceeds a limit of 3 check-ins within a 7-day period, the system should prevent additional check-ins. However, there may be scenarios where check-ins across 'broken' weeks need to be managed. For instance, if Tom checks in on 10/30, 10/31, and 11/1, how can we ensure that all check-ins are accurately recorded?
The challenge emerges when the week boundary intersects with the change of months, causing some check-ins to fall out of the scope of the current week. How can this issue be addressed effectively?
S M T W R F S
1 2 3 4
5 6 7 8 9 10 11
12 13 14 15 16 17 18
19 20 21 22 23 24 25
26 27 28 29 30 31
When a user checks in on the first two days of the week, the system captures the data correctly. However, challenges arise when transitioning between months, affecting the accuracy of weekly check-in counts. What strategies can be employed to overcome this obstacle?
const checkInOnWeek = await this.checkInsRepository.findByPlayerIdOnWeek(
player_id,
check_in_date,
);
const week = [];
const current = new Date();
// Starting Sunday not Monday
current.setDate(current.getDate() - current.getDay());
for (let i = 0; i < 7; i++) {
week.push(new Date(current));
current.setDate(current.getDate() + 1);
}
const datascheckin = week.map(date => {
const firstdayFormatted = format(date, 'dd/MM');
return firstdayFormatted;
});
const dataFormatada = format(check_in_date, 'dd/MM');
const a = datascheckin.some(data => {
return data === dataFormatada;
});
if (checkInOnWeek.length > 3) {
console.log(
`Qtd de checkins semanal atingida,
${checkInOnWeek[0].check_in_date}, Id ${checkInOnWeek[1].player_id}`,
);
throw new AppError('Weekly scheduling limit reached!', 400);
}
const countCheckInDate = await this.checkInsRepository.countSpacesRemaining(
check_in_date,
);
const checkIn = await this.checkInsRepository.create({
player_id,
check_in_date,
});
return checkIn;
Result obtained